We have a feed mill and need a spreadsheet to track bulk ingredients that go into feed rations. We have several bulk ingredients that are use to make different mixes each mix uses a so much of each ingredient, I have put all of the mixes in a spreadsheet with the amounts of bulk ingredients used in each mix. I need the spreadsheet to track my inventory daily with me entering the amount of the mixes produced each day. I can make it take out of the bulk but have to reenter the starting amounts each day. I want it to keep track of my ingredients with out reentering the starting amount everyday.
I would be delivering an MRP system using Access & Excel with it's own Bill of Materials, Inventory & P&L reporting if you can provide acquisition cost for the raw material and selling price for each mix.
Regards,
We have a production control software with major installation in food and other units, in which each and every segments input and output is determined, loss for each ingredients etc. and total output. ready for demo.