Every manufacturer asks the same three questions every week: what do we need, how much, and when must we order it? With spreadsheets the answer is a planner's experience plus a stock sheet, and the result is familiar: too much of what is not needed, and a line stopped for a component nobody ordered.
MRP (material requirements planning) answers the questions with arithmetic. It takes what customers want and when, subtracts what you have and what is already on order, explodes the rest through the bills of materials, and offsets each requirement by its lead time. The output is a list of planned orders: buy this, make that, by this date. MRP has worked the same way since the 1970s; SAP, Oracle and every serious ERP run variations of it.
The inputs
MRP is only as good as four sets of data:
| Input | Where it comes from | What goes wrong if it is wrong |
|---|---|---|
| Demand | Open sales order lines, delivery schedules, component needs of open work orders, safety stock | Planning for orders that will never ship, or missing real ones |
| Supply | Stock on hand, open purchase orders, open work orders, incoming transfers | Ordering what is already coming |
| Structure | Active BOMs with quantities and scrap | Wrong components or quantities ordered |
| Parameters | Lead times, minimum order quantity, order multiple, safety stock | Orders arriving late or in the wrong size |
Sales demand is independent demand: the customer decides it. Component demand is dependent demand: it is calculated from the parent's plan. MRP only ever forecasts the first; the second is pure calculation.
The MRP record
MRP works item by item, level by level, in time buckets (weeks, usually). For each item it fills in one table, the MRP record:
- Gross requirements: demand falling in each week.
- Scheduled receipts: supply already ordered (open POs and work orders), in the week it is due.
- Projected on hand: stock at the end of the week = previous projected + scheduled receipts + planned receipts − gross requirements.
- Net requirements: the shortfall when projected on hand would go below zero (or below safety stock).
- Planned order receipts: the quantity to arrive, after lot sizing (minimums and multiples).
- Planned order releases: the same quantity, moved earlier by the lead time. This is when the order must be placed or the work order released.
The planned releases of a parent become the gross requirements of its components, multiplied by the BOM quantity. That is the explosion.
A worked example: two levels
Cabinet C-200 is made from 2 Side panels SP-10; each side panel is made from 1.5 kg of steel sheet. (Other components and scrap are left out to keep the numbers readable.)
| Item | On hand | Lead time | Lot sizing |
|---|---|---|---|
| Cabinet C-200 | 30 | 1 week | Lot for lot |
| Side panel SP-10 | 50 | 1 week | Lot for lot |
| Steel sheet (kg) | 100 | 2 weeks | Multiples of 50 kg |
Level 0: the cabinet
Sales orders need 20, 40, 30 and 50 cabinets in weeks 1, 3, 4 and 6. A work order for 20 is already due in week 2.
| Cabinet C-200 | W1 | W2 | W3 | W4 | W5 | W6 |
|---|---|---|---|---|---|---|
| Gross requirements | 20 | 0 | 40 | 30 | 0 | 50 |
| Scheduled receipts | 20 | |||||
| Projected on hand (start 30) | 10 | 30 | 0 | 0 | 0 | 0 |
| Net requirements | 10 | 30 | 50 | |||
| Planned order receipts | 10 | 30 | 50 | |||
| Planned order releases | 10 | 30 | 50 |
In week 3 the 30 cabinets on hand cover only 30 of the 40 needed, so 10 must be made. With a one-week lead time, that work order must be released in week 2.
Level 1: the side panel
The cabinet's planned releases × 2 become the side panel's gross requirements.
| Side panel SP-10 | W1 | W2 | W3 | W4 | W5 | W6 |
|---|---|---|---|---|---|---|
| Gross requirements | 20 | 60 | 100 | |||
| Projected on hand (start 50) | 50 | 30 | 0 | 0 | 0 | 0 |
| Net requirements | 30 | 100 | ||||
| Planned order receipts | 30 | 100 | ||||
| Planned order releases | 30 | 100 |
Level 2: the steel
The side panel's planned releases × 1.5 kg are the steel's gross requirements. A purchase order for 60 kg arrives in week 3, and the supplier sells in multiples of 50 kg.
| Steel sheet (kg) | W1 | W2 | W3 | W4 | W5 | W6 |
|---|---|---|---|---|---|---|
| Gross requirements | 45 | 150 | ||||
| Scheduled receipts | 60 | |||||
| Projected on hand (start 100) | 100 | 55 | 115 | 15 | 15 | 15 |
| Net requirements | 35 | |||||
| Planned order receipts | 50 | |||||
| Planned order releases | 50 |
The steel is short by 35 kg in week 4, rounded up to 50 kg. With a two-week lead time the purchase order must go out in week 2. The 15 kg left over is the cost of the supplier's multiple.
Notice what MRP did not do: it did not order steel for all 140 cabinets, because stock and open orders at every level absorbed most of the demand. That netting at each level is the whole point.
Action messages
A planner does not read every record. The system turns the records into exceptions:
- Release now: a planned order whose release date is this week.
- Late: a planned release date already in the past. The order can no longer arrive on time by normal lead time; expedite, split, or tell sales.
- Reschedule in / out: an open order due later (or earlier) than it is now needed.
Lot sizing and safety stock
- Lot for lot orders exactly the net requirement. Lowest stock, most orders.
- Minimum order quantity and order multiple reflect supplier or machine constraints. The excess covers later weeks, as with the steel above.
- Safety stock is a buffer MRP keeps untouched: projected on hand is not allowed to fall below it, so it shows up as an extra requirement. Use it for uncertain supply or demand, not to cover bad data. See Reorder points, safety stock and lead times.
Items that are cheap and steadily consumed (screws, packaging) are often better planned by reorder point (min/max) than by MRP: when stock plus open supply falls below the minimum, order up to the maximum.
In Voltrus
Three things to know so you read the suggestions correctly:
- Planning method decides who plans. Items on reorder point get a suggestion when stock and open supply fall below the minimum; a made item on reorder point is also exploded, with its components due today. Items with planning method none create no suggestions and no component demand.
- No reschedule messages and no capacity check. MRP suggests new orders and flags late ones; it does not propose moving existing orders, and it assumes every work centre has unlimited capacity.
- Suggestions only. MRP never creates orders on its own; conversion is always a person's decision.
Checklist
- Lead times, minimums and multiples are filled in for every purchased and manufactured item.
- Every manufactured item has an active BOM.
- Sales order lines carry real requested or promised dates.
- MRP is run and worked at a fixed rhythm by a named planner.
- Late suggestions are discussed with sales the same day.