In a spreadsheet factory, the recipe for a product lives in someone's head or in a tab called "komposisi" that nobody dares to sort. When the head of production is on leave, nobody knows exactly how much resin goes into a batch, and the cost sheet still uses last year's recipe.
An ERP holds two master records for every product you make: the bill of materials (what it is made of) and the routing (how it is made, step by step, and where). Planning, costing, material issue and labour reporting all read from these two records, so getting them right is the single most important set-up task in manufacturing.
The bill of materials
A bill of materials (BOM) lists the components and quantities needed to make one unit of a parent item, in the parent's base unit.
| Parent: Cabinet C-200 (1 pcs) | Qty per | Unit | Scrap % |
|---|---|---|---|
| Side panel SP-10 | 2 | pcs | 0 |
| Shelf SH-05 | 3 | pcs | 0 |
| Steel sheet 0.8 mm | 1.5 | kg | 5 |
| Screw M4 | 24 | pcs | 2 |
| Powder coat | 0.2 | kg | 10 |
Three ideas you will meet in every ERP:
- Levels. A component can have its own BOM. Here, Side panel SP-10 is itself made from steel sheet, so the cabinet's structure is two levels deep. When the system works out how much steel to buy, it explodes the BOM level by level, multiplying quantities as it goes; MRP nets each level against its own stock first, so side panels already on the shelf need no steel (see MRP).
- Component scrap. Some material is always lost: cut-offs, overspray, rejects at the press. Scrap percentage on a BOM line inflates the requirement so planning orders enough. 1.5 kg of steel at 5% scrap means 1.575 kg is planned and issued per cabinet.
- Units. The quantity per is in the unit shown on the line. If you buy steel in sheets but consume it in kg, a unit conversion on the item handles the translation; stock always moves in the item's base unit.
Versions and the one active BOM
Recipes change: a cheaper screw, a new supplier's sheet thickness, a design fix. Rather than editing the BOM that past work orders were built from, you create a new version, check it, and activate it. The old version is retired but kept, so you can always see what a work order released last March was supposed to consume.
At any moment exactly one version is the active one. Planning, cost roll-up and new work orders use it. A work order fixes (pins) the BOM version at release, so activating a new version does not change work already on the floor.
Where-used
The reverse question matters just as much: "Screw M4 is being discontinued; which products use it?" A where-used lookup walks the active BOMs upward and lists every parent, directly or through sub-assemblies. Use it before changing or phasing out any component.
The routing
The routing lists the operations to make one unit, in sequence, each at a work centre:
| Seq | Operation | Work centre | Setup (min) | Run (min / unit) |
|---|---|---|---|---|
| 10 | Cut and punch sheet | PRESS-1 | 30 | 2.0 |
| 20 | Bend | BRAKE-1 | 20 | 3.0 |
| 30 | Powder coat | PAINT | 45 | 1.5 |
| 40 | Assemble and pack | ASSY | 0 | 12.0 |
- Setup time happens once per batch, whatever the quantity: changing dies, cleaning the spray booth.
- Run time is per unit.
- Sequences in steps of 10 leave room to insert an operation later without renumbering.
Work centres
A work centre is a machine, a line or a group of people that does an operation. It carries the rates that turn minutes into money:
- Hourly (labour) rate: what an hour of this work centre costs in wages.
- Overhead rate: the hourly share of electricity, depreciation, supervision and other indirect cost, often called machine burden.
- Cost centre: which department's results its cost belongs to.
For the cabinet, a 50-unit batch at PRESS-1 takes 30 + 50 × 2 = 130 minutes. At a labour rate of Rp 60,000 per hour and overhead of Rp 90,000 per hour, that operation absorbs Rp 130,000 labour and Rp 195,000 overhead. The full calculation is in Product costing, WIP and variances.
Getting the master data right
The BOM and routing are only as good as the discipline around them:
- One owner. Engineering or production engineering owns BOMs and routings; nobody else activates a version.
- Measure, then set. Use real time studies or averages from past work orders for run times. Guesses produce a standard cost nobody believes.
- Every purchased component has a cost. A roll-up cannot cost a product whose screw has no price.
- Change by version. Never repair a BOM that past orders used; create the next version.
- Check after every change. Re-run the cost roll-up and look at the change in product cost before activating.
In Voltrus
What is not there yet, so plan around it:
- No capacity planning or finite scheduling. Work centres store a capacity per day, but nothing schedules against it. Check load by hand (for example, total run minutes of released work orders per work centre per week) until it exists.
- No phantom or kit item types. Items are raw, finished or consumable. A sub-assembly that is never stocked still needs its own work order, or you flatten its components into the parent BOM.
- No engineering change order (ECO) document. Use versions plus the record's Discussion tab to record why a change was made and who agreed to it.
Checklist
- Every manufactured item has exactly one active BOM and one active routing.
- Scrap is on BOM lines, not buried in quantities.
- Work centre rates are set and reviewed at least yearly.
- Every purchased component has a cost.
- Changes go through a new version, with the reason written in the discussion.