Simple and Flexible ERP with Excel

For many food manufacturers, while the bill-of-materials (BOM) to deduct raw materials is a guide, the variability of raw material used requires the user to be able to account for the actual raw material used.

One cost effective, yet flexible way to deduct using BOM is to use excel. Using a combination of sumifs, index and other simple excel functions, you can create inventory incoming, production and outgoing records to check inventory balance. System inventory balance is then used to check against physical inventory balance. 

You can also monitor intermediate products and subassembly this way. Wastage and variation can be tracked in separate columns. In addition reorder points can also be set up and highlighted (using conditional formatting) when the reorder point is reached.