ERP for Manufacturing: MRP, BOM, and Shop Floor Control

Manufacturing companies have the most complex processes an ERP must support. Bills of Materials (BOM), Material Requirements Planning (MRP), production orders, shop floor control, actual vs. standard costs, lot traceability. This article covers the essentials that a manufacturing ERP must have and the typical challenges faced by Panamanian manufacturing companies.

Typical Manufacturing Operation

A typical mid-sized manufacturing company:

20–200 finished goods (final SKUs).
100–2,000 raw materials and components.
5–30 production processes.
Multiple lines or production cells.
Partial subcontracting (tolling, specialized processes).
High inventory: raw materials + work in progress (WIP) + finished goods.
Regulatory traceability: especially food, pharmaceuticals, cosmetics.

What a Manufacturing ERP Must Have

1. BOM (Bill of Materials)

The hierarchical structure that defines what is needed to produce each product:

Multi-level BOM: finished product → semi-finished → components → raw material.
BOM versions: when a recipe changes, maintain the history.
Estimated scrap and waste in the BOM.
Component substitutions: if raw material A runs out, use B.
Standard cost calculated from the BOM.

2. Production Routes

Defines how the product is manufactured:

Sequential operations (cutting, assembly, painting, packaging).
Work centers assigned to each operation.
Standard times per operation.
Labor costs per operation.
Manufacturing overhead (MOH) allocated proportionally.

3. MRP (Material Requirements Planning)

Based on expected demand (firm orders + forecasts):

Gross requirements calculation for each material.
Comparison with available inventory.
Net requirements calculation (what needs to be purchased or produced).
Generation of suggested orders: raw material purchase orders and semi-finished production orders.
Considering lead times from suppliers and internal production times.

Without MRP, companies operate with high safety stocks or suffer raw material stockouts that halt production.

4. Production Orders

When a production decision is made, a production order is generated:

Material reservation: inventory is set aside for that order.
Work center assignment.
Start and end with recording of actual times.
Material issue (consumption).
Finished goods receipt (into inventory).
By-products and waste recorded.

5. Shop Floor Control

In real time during production:

Status of each order: queued, in process, completed, on hold.
Work center efficiency.
Actual scrap vs. standard.
Downtime: type (maintenance, lack of raw material, quality) and duration.
Quality: rejects, rework.

Mobile apps or tablets on the plant floor make it easy for operators to record data without paper.

6. Costing: Standard vs. Actual

Standard cost: budgeted at the start of the period. Useful for budgeting and pricing.

Actual cost: what it actually cost to produce each lot, including: - Raw material actually consumed. - Labor actually used. - MOH actually allocated.

Variances (actual vs. standard) are analyzed: - Quantity variance: did you use more or less material than the standard? - Price variance: did the raw material cost more or less than the standard? - Efficiency variance: did the operation take more or less time than the standard?

Without this analysis, actual margins by product are a black box.

7. Lot Traceability

For regulated industries (food, pharmaceuticals, cosmetics):

Lot of each raw material recorded at receipt.
Lot-to-production-order linkage: which raw material lots were used in which finished goods lot.
Finished goods lot: linked to its raw materials.
Lot distribution: which invoices and which customers received it.

Bidirectional traceability: if a raw material is reported as contaminated → identify all affected finished products → identify all customers who purchased them.

8. Subcontracting / Tolling

If part of the process is subcontracted:

Materials sent to the subcontractor (not a sale, a loan).
Inventory held by third parties.
Receipt of processed product.
Service cost allocated to the product.
Reconciliation of materials sent vs. processed vs. returned.

Typical Errors Without a Manufacturing ERP

BOMs in Excel: recipes live in spreadsheets that go out of date. Producing incorrectly because the BOM is not current.
Frozen standard costs: never compared against actual costs. Real margin is unknown.
Manual MRP: over-buying for safety, or raw material stockouts due to oversight.
Production without traceability: when there is a quality problem, it is impossible to track which customers purchased the affected product.
Lost WIP: in-process inventory is not correctly accounted for, distorting the balance sheet.

Use Case: Consumer Goods Manufacturer

Panamanian company manufacturing food products: - 35 finished goods. - 150 raw materials. - 6 production lines. - 80 production orders per month. - Regulatory traceability per AUPSA.

With QuickBooks or Sage 50: - BOM in Excel, recipes not updated. - Standard costs from 2 years ago. - MRP calculated manually every Monday. - Lot traceability: impossible. - Real margin by product: unknown (estimated).

With a manufacturing ERP: - Digital BOMs with version control. - Standard and actual costs compared monthly with variance analysis. - Automatic MRP with daily suggestions. - Complete bidirectional traceability. - Real margin by product, lot, customer: visible. - Monthly close: 3–4 days vs. 8–10 days.

Manufacturing ERP: What It Should NOT Assume

A serious manufacturing ERP for mid-sized companies in LATAM must adapt to the actual operation, not force the operation to fit the ERP:

Semi-flexible recipes: adjustments during production are common.
By-products: many processes generate by-products that have value (they are not just waste).
Variable scrap: depends on supplier, lot, conditions.
Batch vs. continuous processes: the ERP must support both.

Large ERPs (SAP, Oracle) have robust functionality but their cost and implementation complexity make them unviable for mid-sized companies. Modern cloud ERPs designed for LATAM cover the requirements at a fraction of the cost.

How cifraHQ Approaches Manufacturing

cifraHQ has manufacturing capabilities:

Multi-level BOM with versions.
Production routes with work centers.
MRP with automatic generation of suggested orders.
Production orders with recording of times and material consumption.
Standard and actual costing with variance analysis.
Lot traceability bidirectional.
Subcontracting / tolling with inventory control at third parties.
Operational reporting with efficiency and margin dashboards.

Are you in manufacturing and want to see the ERP in action? Request a demo — we will show you the full workflow from BOM to variance analysis with data similar to your operation.

The features presented here are typical of manufacturing-oriented ERPs. Specific applicability to your company requires detailed evaluation with your implementation team.