Custom ERP for a Lagos Manufacturer: Reducing Production Waste by 30%

A Lagos based manufacturing company was bleeding money through raw material waste. They ran 5 production lines making consumer goods, but they had no idea how much material was being wasted on each production run. Raw materials arrived at the factory and disappeared into the production floor, and the only measurement was at the end of the month when they counted finished goods and compared with raw material purchases.

The owner knew the waste was significant, possibly 20-25% of raw materials. But without data, he could not pinpoint where the waste was happening, which lines were the worst, or how to fix it. We built a custom ERP system with bill of materials management, production tracking, and waste analytics that reduced raw material waste by 30% and increased overall production output by 20%.

The Challenge

Blind Production With No Tracking

The factory operated 5 production lines, each making different products. Raw materials were issued to the production floor based on handwritten requisition slips, and the production team estimated how much they used at the end of each shift. There was no way to verify those estimates. If a line operator reported using 50kg of raw material to produce 40kg of finished goods, the manager had no way to check whether the 10kg difference was actual waste or an inaccurate report.

Without production tracking, the company could not calculate accurate product costs. They priced their goods based on estimated material usage plus a markup, but the estimates were wrong. Some products were being sold below cost because the actual material usage was higher than they thought. The owner was making a loss on his best selling product without knowing it.

Manual Inventory Management Chaos

Inventory was managed with a combination of spreadsheets and physical counts. The storekeeper recorded incoming materials in a notebook and updated a spreadsheet at the end of the day. But production issued materials directly from the store without always recording it, so the spreadsheet never matched the physical stock. Monthly physical counts were painful and always revealed discrepancies that nobody could explain.

Stockouts were common. The factory would run out of a critical raw material mid-week, forcing production to stop on one or more lines. The procurement team ordered materials based on gut feel and past experience, not actual usage data. They either ordered too much, tying up cash in inventory, or too little, causing production stoppages that cost more than the materials themselves.

Our Solution

BOM Management and Production Tracking

We built the ERP with a bill of materials module for every product. Each product has a BOM that specifies exactly which raw materials are needed and in what quantities. When a production run is started, the system reserves the required raw materials from inventory and tracks actual usage against the BOM. At the end of the run, the system calculates the variance: how much material was actually used versus how much should have been used based on the finished goods produced.

Each production line has a tablet where operators record production data in real time. They enter the batch number, raw materials used, finished goods produced, and any issues encountered. The system timestamps every entry and links it to the specific shift and operator. Waste is calculated automatically and displayed on a live dashboard. Managers can see which lines, shifts, and products are generating the most waste.

Inventory Optimization and Reorder Alerts

The ERP tracks all inventory movements: goods received, materials issued to production, finished goods transferred to warehouse, and returns. Every movement is recorded with a timestamp and the person responsible. The inventory balance updates in real time, and the system generates reorder alerts when stock for any raw material drops below its configured minimum level.

We added waste analytics that identifies patterns: certain products that consistently waste more material, specific shifts where waste increases, and raw materials that are frequently overused. The owner receives a weekly waste report showing the top 5 waste sources and the estimated financial impact. This turned waste reduction from a guess into a measurable, manageable process.

The Results

In the first 3 months after the ERP went live, raw material waste dropped by 30%. The waste analytics dashboard showed that one production line was responsible for 40% of all waste because a machine calibration issue was causing overuse of a specific ingredient. Fixing that machine cost ₦85,000 and saved ₦420,000 per month in wasted materials. Production output increased by 20% because reducing waste meant more finished goods from the same raw materials.

Inventory accuracy improved from 65% to 98%, eliminating stockouts almost entirely. The procurement team now orders based on real usage data, and the reorder alerts prevent emergency purchases at premium prices. The owner saved ₦2.4M per month on raw material costs alone. Product costing became accurate, and he discovered that two products were being sold below cost. He adjusted pricing on those products and added ₦900,000 to his monthly profit.

Key Takeaways

• You cannot reduce what you do not measure. Before the ERP, waste was an estimate. After the ERP, waste was a precise number tied to specific lines, shifts, and operators. Measurement alone drove improvement.
• BOMs are the foundation of production control. Knowing exactly how much material each product should consume lets you detect waste immediately instead of discovering it months later.
• Real time data changes behavior. When operators know their waste is being tracked, they pay more attention to careful material usage. What gets measured gets managed.
• Product costing without data is dangerous. The owner was selling products below cost because his cost estimates were wrong. Accurate data would have saved him months of hidden losses.

Frequently Asked Questions