Manufacturing2 min read
Manufacturing ERP Guide: BOMs, MRP, Shop Floor and Costing
A practical guide to manufacturing ERP: modelling BOMs and routings, making MRP trustworthy, shop-floor data capture, costing, quality and traceability.
Industry · Manufacturing
Food and beverage ERP built around traceability
In food and drink manufacturing, traceability is not a feature — it is the job. When a supplier recalls an ingredient, you need to know within hours which batches used it, where those batches went, and how much is still in your warehouse or your customers'.
- M01Manufacturing (Recipes)
- M02Inventory (Lots & Expiry)
- M03Quality
- M04Purchasing
- M05Sales
- M06Accounting
Context
ERP in food & beverage
That same lot-level discipline pays off every day: first-expiry-first-out picking, accurate yields, allergen segregation and clean conversations with retailers who audit you.
01Operational challenges
What usually breaks before the ERP project starts
01
Slow mock recalls
Tracing an ingredient lot forward to customers takes days of searching paper batch records.
02
Expiry write-offs
Stock expires on the shelf because picking ignores dates and nobody sees what is close to expiry.
03
Yield variance
Actual output per batch differs from recipe expectations, but nobody measures it consistently.
04
Retailer requirements
Supermarkets demand EDI orders, specific labels and compliance with delivery windows and service levels.
02Core flows
How the ERP should handle each part of the business
- Sales flow
- Orders from retailers, distributors and foodservice arrive via EDI, portal or email; customer-specific pricing, promotions and minimum shelf-life requirements are applied at allocation.
- Procurement
- Ingredients and packaging purchased from approved suppliers only, with specifications and certificates on file. Short shelf-life ingredients bought close to need.
- Inventory
- Every ingredient and finished-good lot tracked with production and expiry dates; quarantine status until quality release; FEFO allocation for outbound orders.
- Warehouse
- Temperature-zoned locations for ambient, chilled and frozen; receipt checks record temperatures and lot details; picking enforces minimum remaining shelf life per customer.
- Manufacturing
- Recipes scaled to batch size, with production recording actual ingredient lots and quantities used, output lots created, and yield calculated automatically.
- Accounting
- Batch costs include ingredients at actual lot cost, packaging, labour and overhead; yield variances and write-offs reported separately.
- CRM
- Key account management for retailers and distributors, including promotions, listings and service-level performance.
03Industry workflows
Workflows specific to food & beverage
01
Forward and backward trace
From any lot, see which batches it went into and which customers received them — or the reverse — in a single report.
02
Quality release
Finished batches held in quarantine until lab results or checks are approved.
03
Allergen management
Allergens recorded on ingredients and rolled up to recipes, with production sequencing to reduce cross-contact risk.
04
Minimum shelf-life allocation
Each customer's minimum remaining life enforced when allocating stock to orders.
04 — Reporting
Reports that should come out of the system, not a spreadsheet
- Mock recall trace by ingredient lot
- Stock nearing expiry by location
- Batch yield vs recipe
- Write-offs by reason and product
- Service level by retailer
- Supplier quality non-conformances
05 — Compliance
Compliance considerations
Food safety regimes such as HACCP plans, GFSI schemes (BRCGS, SQF, FSSC 22000) and regional rules like the FDA Food Safety Modernization Act in the US emphasise traceability, supplier approval and documented controls. The ERP should provide lot genealogy, supplier certificates and quality records; specific obligations should be confirmed with your food safety advisor.
Regulatory requirements vary by jurisdiction. We configure the system to support your obligations; confirm specific rules with your auditor or compliance advisor.
06 — Integrations
Systems the ERP needs to talk to
EDI with retailers and distributors, label printing with GS1 barcodes, weighing scales and checkweighers, temperature monitoring, and carrier systems for chilled logistics are common integrations.
07AI opportunities
Where AI is genuinely useful here
Practical uses that sit on top of clean ERP data. None of them replace getting the core transactions right first.
01
Supplier certificate tracking
Read certificates of analysis and audit certificates, capture expiry dates and alert before they lapse.
02
Demand forecasting assistance
Combine order history with promotion calendars to suggest production quantities for short-life products.
03
Customer order intake
Convert emailed orders from smaller customers into draft sales orders.
08ERP modules
Modules a typical deployment includes
- M01Manufacturing (Recipes)
- M02Inventory (Lots & Expiry)
- M03Quality
- M04Purchasing
- M05Sales
- M06Accounting
- M07Barcode
- M08EDI
09Roadmap
Implementation roadmap
- 01
Lot discipline
Lot and expiry capture on all ingredients and finished goods from receipt onward.
- 02
Production and yield
Recipe-based batches recording actual lots and output.
- 03
Quality and release
Quarantine, checks and release workflows.
- 04
Customer integration
EDI, labels and minimum shelf-life allocation for retailers.
10Common mistakes
Mistakes we see repeatedly
01
Backflushing ingredients
Assuming recipe quantities instead of recording actual lots breaks traceability.
02
Optional lot entry
If lot capture can be skipped at receipt, it will be — and the trace chain breaks.
03
Ignoring units of measure
Ingredients bought in sacks, stored in kilos and used in grams need careful conversions.
04
No mock recall test
Run a mock recall before go-live to prove the trace works end to end.
Explore further
Related services, solutions and platforms
Insights
Related reading
Inventory2 min read
3D Warehouse Management: Visualising Stock in 3D
What 3D warehouse management offers: bin occupancy views, slotting decisions, space planning, and how to build a 3D view on ERP location data.
Inventory2 min read
RFID vs Barcode: Which Is Right for Your Warehouse?
A practical RFID vs barcode comparison: cost, speed, accuracy, environment and use cases, with clear guidance on when RFID pays off and when barcodes are the better choice.
FAQ
Frequently asked questions
Can we perform a mock recall in the ERP?
Yes. Lot traceability reports show every batch, shipment and customer linked to a given lot in either direction.
Does the ERP support catch weight?
Products sold by variable weight need catch-weight handling. Support varies by platform and may require extension; we assess this early.
How are recipes scaled?
Recipes are defined for a base quantity and scaled proportionally to the batch size, with actual consumption recorded.
Similar industries
Industries with related workflows
ManufacturingBOMs, routings, MRP, shop-floor control, costing and traceability for discrete and mixed-mode manufacturers.Metal FabricationJob-shop ERP for quoting, nesting-driven material planning, routings, heat numbers and job costing.Plastic ManufacturingERP for injection moulding and extrusion: resin and regrind, tooling, cavities, cycle times and scrap.
Next step
How long would your next recall take?
We will review your lot tracking and show what a complete trace looks like.