In manufacturing companies, there are five types of data that act as the core foundation — pillars supporting production operations:
- BOM (Bill of Materials)
- Routing (Process Flow)
- Production Schedule
- MRP (Material Requirements Planning)
- Inventory
They may look like ordinary lists or spreadsheets, but they are interconnected — missing one causes ripple effects. Below is a case study to clarify their meaning and usage.
Case Background
Imagine a manufacturing company called “Starlight Electronics” producing a smart speaker model called “StarBox”. The StarBox consists of a plastic housing, a main board, speaker units, packaging box, etc. To deliver on time, control inventory cost and avoid production bottlenecks, Starlight must manage these five data sets well.
1. BOM (Bill of Materials)
The BOM is the “what to make” list. For the StarBox stage, the BOM shows:
- 1 plastic housing
- 1 main board (containing multiple chips, resistors, capacitors)
- 2 speaker units
- 1 packaging box + manual + power adapter Each component is specified with type, quantity, maybe vendor, cost, lead time etc. If the BOM is wrong (for example missing a key chip), then downstream you may have shortage, idle production, wrong assembly etc.
2. Routing (Process Flow)
Routing is the “how to make” description. For StarBox:
- First plastic housing injection →
- Drying and painting →
- Assemble main board with speaker units →
- Functional test → Packaging → Shipping The routing links each operation, equipment, time, workforce and quality check. If routing is unclear, operations may be chaotic, efficiency low, rework high.
3. Production Schedule
With “what” (BOM) and “how” (routing) clear, next is “when” and “how many” (production schedule). Suppose Starlight electronic has order for 10,000 units of StarBox to deliver in 2 months. The production schedule must decide how many units per week, which workshop, using which equipment, how to batch deliveries.
A good production schedule considers equipment capacity, workforce shifts, material arrival etc.
4. MRP (Material Requirements Planning)
Once production schedule is set, we ask: are materials available? When to procure? Is inventory sufficient? That’s where MRP enters. MRP essentially calculates, based on production schedule + BOM + current inventory, the demand quantity and timing for each component and raw material.
In our StarBox example: if we plan to produce 10,000 units, then materials like main boards, speaker units, housings must be prepared in advance. Suppose main boards have a procurement lead-time of 2 weeks, speaker units 3 weeks, housing 1 week. The MRP system automatically computes when to issue purchase orders, how many units needed, when they must arrive. If MRP is wrong (e.g., BOM outdated or inventory data inaccurate), you risk material shortage, over-stocking, rework.
5. Inventory
Inventory is both the baseline data and the guarantee. Inventory data must be accurate (physical matches system) because inventory levels directly impact MRP and production schedule execution. If system shows 1000 units in stock but actual is 800, MRP may miscalculate “we have enough” and then production stops.
In Starlight’s case, they adopt barcode scanning for in/out operations and regular stock counts to ensure inventory data is real-time accurate, supporting downstream planning and purchasing.
How These Five Work Together
- BOM is the foundation — tells you what to make.
- Routing tells you how to make it.
- The production schedule tells you when and how many to make.
- MRP uses the first three plus inventory to tell you what to buy, when to buy, how many to buy.
- Inventory supports all of the above by providing accurate data. If one link fails (e.g., BOM wrong or inventory data bad), you trigger a chain reaction: procurement delay, production halt, cost increase, delivery failure.
Practical Tips
- Establish a standardized BOM management process (version control, change workflow, cross-department collaboration).
- Routing must be clear and traceable, with standard operating procedures for critical operations.
- Production scheduling must take resource capacity (machines, labor) into account for load analysis.
- MRP systems must rely on real-time, accurate data — “garbage in, garbage out”.
- Inventory management must ensure physical-system accuracy; recommended to use barcodes/RFID and conduct regular counts.
Summary
In manufacturing, managing these “five core data sets” well is like equipping your production system with a navigator, a metronome and a safety net. They don’t exist separately but form a chain: accurate BOM → reasonable routing → executable production schedule → precise MRP → reliable inventory support.