The Problem: Excel Notebooks Running a Perishable Operation
Amilma Ice is an ice cream manufacturer based in Kerala, producing over 40 SKUs across their product line — from classic vanilla tubs to seasonal fruit bars. Their production floor ran on a system that most food manufacturers will recognize: Excel spreadsheets, physical logbooks, and a production manager who kept critical formulas in his head.
Every morning, the floor supervisor would check yesterday's sales numbers, open a spreadsheet, and manually calculate how much milk, sugar, stabilizer, and flavoring to requisition from the cold store. The Bill of Materials for each product existed as a row in a shared Excel file that hadn't been audited in over a year.
The consequences were predictable. Raw materials expired before they could be used. Batches were over-produced because nobody cross-referenced Tuesday's production plan with Wednesday's demand forecast. And when a key ingredient ran short, the team would substitute quantities based on gut feel rather than tested ratios — leading to inconsistent product quality.
By the time Amilma's operations head reached out to us, they estimated that 12-15% of their monthly raw material spend was going directly into waste — expired milk solids, unused flavoring concentrates, and finished goods that sat too long in the freezer.
Why Perishable Manufacturing Is Different
Most ERP case studies focus on discrete manufacturing — assembling parts into products where components sit on shelves for months. Perishable goods manufacturing operates under fundamentally different constraints.
- Shelf life is measured in hours and days, not months. A batch of cream base that isn't used within 48 hours becomes waste, not inventory.
- Batch traceability isn't optional. Food safety regulations require you to trace every input back to its source. Excel doesn't do this reliably.
- Yield variance matters more. When you mix 100 liters of ice cream base, you don't always get exactly 100 liters of finished product. Evaporation, spillage, and equipment retention eat into your yield. If your BOM doesn't account for this, your inventory numbers drift from reality every single day.
- Seasonal demand swings are extreme. Summer production volumes can be 3x winter volumes. A static production plan doesn't survive contact with a heatwave.
Amilma needed a system that understood these realities — not a generic manufacturing module bolted onto accounting software.
The Solution: Digitized Auto-BOMs With Real-Time Tracking
We implemented OneBook's manufacturing module with a focus on three capabilities that directly addressed Amilma's pain points.
1. Digitized Bill of Materials with Auto-BOM Generation
Every product recipe was converted from Excel rows into structured BOMs inside OneBook. Each BOM includes the exact quantity of every raw material, the expected yield percentage, and the shelf life of the finished product.
The Auto-BOM feature is where the real leverage comes in. When Amilma's planning team enters a production order for 500 units of mango ice cream, OneBook automatically calculates the exact raw material requirements, checks current inventory levels, flags any ingredients that will expire before the planned production date, and generates purchase requisitions for shortfalls.
No spreadsheet. No manual calculation. No guesswork.
2. Real-Time Consumption Tracking
Every time the production floor issues materials from the cold store, the transaction is logged in OneBook. The system tracks actual consumption against the BOM's expected consumption in real time.
If a batch of vanilla ice cream is consuming 8% more sugar than the BOM specifies, the system flags it immediately. This early warning catches problems — a miscalibrated dosing machine, a new operator over-pouring, or a supplier delivering a lower-concentration ingredient — before they compound over weeks of production.
3. Expiry Alerts and FEFO Enforcement
OneBook enforces First Expiry, First Out (FEFO) logic across the cold store. When a production order is created, the system automatically selects the inventory batches closest to expiry. Operators see exactly which pallet to pull, eliminating the common problem of newer stock being used while older stock expires in the back of the freezer.
Expiry alerts trigger at configurable thresholds — 72 hours, 48 hours, 24 hours — giving the planning team time to either accelerate production using near-expiry materials or arrange disposal before the materials become a food safety risk.
The Results: 31% Waste Reduction in 90 Days
Within the first 90 days of going live, Amilma Ice measured the following improvements:
- 31% reduction in raw material waste, driven primarily by FEFO enforcement and accurate BOM-based requisitioning
- 18% reduction in over-production, because production orders were now tied to demand forecasts rather than manual estimates
- Near-zero expired finished goods, down from an average of 4-6 pallets per month
- Batch traceability compliance achieved across all product lines, satisfying FSSAI audit requirements without additional paperwork
- Production planning time cut from 3 hours to 40 minutes per day, freeing the operations team to focus on quality and throughput
The financial impact was significant. Amilma estimated the waste reduction alone saved them approximately 2.8 lakhs per month in raw material costs — more than covering the cost of the OneBook implementation within the first quarter.
What This Means for Food Manufacturers
Amilma's story isn't unique. Every perishable goods manufacturer — whether you're producing dairy, baked goods, fresh juices, or ready-to-eat meals — faces the same fundamental challenge: your margin for error is measured in hours, and your planning tools need to reflect that reality.
The shift from Excel-based production planning to a digitized BOM system isn't about technology for technology's sake. It's about making the invisible visible — seeing exactly where waste happens, why it happens, and stopping it before it hits your bottom line.
If your production floor still runs on spreadsheets and tribal knowledge, the question isn't whether you're losing money to waste. The question is how much.
Want to see this in action?
Schedule a quick demo of OneBook