MRP: material requirements planning

How demand, stock and open orders turn into planned purchases and production.

Baca dalam Bahasa Indonesia

On this page
  1. The inputs
  2. The MRP record
  3. A worked example: two levels
  4. Action messages
  5. Lot sizing and safety stock
  6. In Voltrus
  7. Checklist

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:

InputWhere it comes fromWhat goes wrong if it is wrong
DemandOpen sales order lines, delivery schedules, component needs of open work orders, safety stockPlanning for orders that will never ship, or missing real ones
SupplyStock on hand, open purchase orders, open work orders, incoming transfersOrdering what is already coming
StructureActive BOMs with quantities and scrapWrong components or quantities ordered
ParametersLead times, minimum order quantity, order multiple, safety stockOrders 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.)

ItemOn handLead timeLot sizing
Cabinet C-200301 weekLot for lot
Side panel SP-10501 weekLot for lot
Steel sheet (kg)1002 weeksMultiples 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-200W1W2W3W4W5W6
Gross requirements2004030050
Scheduled receipts20
Projected on hand (start 30)10300000
Net requirements103050
Planned order receipts103050
Planned order releases103050

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-10W1W2W3W4W5W6
Gross requirements2060100
Projected on hand (start 50)50300000
Net requirements30100
Planned order receipts30100
Planned order releases30100

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)W1W2W3W4W5W6
Gross requirements45150
Scheduled receipts60
Projected on hand (start 100)10055115151515
Net requirements35
Planned order receipts50
Planned order releases50

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.

Run it in Voltrus ERP

Everything in these guides is built in: documents that post to the ledger as they happen, Indonesian tax, MRP and costing, with AI agents that propose and people who approve.

See Voltrus ERP