Materials Requirements Planning

Introduction and Context

Materials Requirements Planning (MRP) is a time-phased planning and control system used to determine what materials and components are required, how many are required, and when they must be available. It translates the production plan for finished goods into planned orders for assemblies, components and purchased materials.

MRP is particularly valuable in environments where products are made from dependent components. Demand for a wheel, motor, circuit board or fastener is usually not forecast independently; it is derived from the planned production of the parent product. This is called dependent demand. By contrast, demand for finished goods, replacement parts and service items may be independent demand.

MRP does not replace managerial judgement. It provides a disciplined calculation framework, but its results depend on the accuracy of the master production schedule, bill of materials, inventory records, lead times and planning policies. Poor data produces precise-looking but unreliable plans.

Learning Objectives

After studying this chapter, the learner should be able to:

1. Explain the purpose, logic and data requirements of MRP.
2. Interpret master production schedules, bills of materials and inventory records.
3. Perform BOM explosion, gross-to-net calculations and time-phased offsetting.
4. Apply common lot-sizing rules and evaluate their consequences.
5. Explain safety stock, lead-time management and MRP nervousness.
6. Distinguish open-loop MRP, closed-loop MRP and MRP II.
7. Assess implementation risks, technology requirements and managerial implications.

1. The Logic of MRP

MRP answers three linked questions:

• What is needed? The BOM identifies the components required for each parent item.
• How much is needed? Gross requirements are adjusted for inventory, scheduled receipts and safety stock.
• When is it needed? Requirements are scheduled backward from the date of parent production using lead times.

The basic planning sequence is:

1. Establish the master production schedule (MPS).
2. Explode each scheduled parent item through its BOM.
3. Net gross requirements against available inventory and scheduled receipts.
4. Apply lot-sizing rules.
5. Offset planned order releases by lead time.
6. Communicate planned orders and exception messages.
7. Replan when actual conditions change.

MRP is usually organized into discrete time periods such as days or weeks. Each item has a planning record containing requirements, receipts, projected balances and planned orders.

Independent and Dependent Demand

Independent demand is determined outside the production system, usually by customers, forecasts or service requirements. Dependent demand is calculated from the demand for another item. If one bicycle requires two wheels, a planned production quantity of 500 bicycles creates a gross requirement for 1,000 wheels, before inventory and other receipts are considered.

The relationship is expressed as:

Here, GR_component,t is the gross requirement for a component in period t, PORel_p,t is the planned order release of parent p in that period, and usage_component,p is the quantity of the component required per parent. The summation applies when a component is used by more than one parent.

2. Core MRP Records

2.1 Master Production Schedule

The MPS states which finished goods or major end items are to be produced, in what quantities and in which periods. It is more specific than an aggregate production plan. The aggregate plan may state that 1,000 units of a product family will be produced in a month; the MPS may specify 250 units in week 1, 300 in week 2, 200 in week 3 and 250 in week 4.

The MPS must be feasible in relation to capacity, materials and delivery commitments. An unrealistic MPS creates instability throughout the MRP system.

2.2 Bill of Materials

A bill of materials is a structured list of all components, subassemblies, raw materials and quantities required to manufacture or assemble one unit of a parent item. It is both a product definition and a planning relationship.

A single-level BOM lists only the immediate components of a parent. A multilevel BOM shows successive levels. For example:

• Level 0: Finished bicycle
• Level 1: Frame assembly, wheel assembly, brake assembly
• Level 2: Frame tubes, spokes, rim, brake cable
• Level 3: Nipples, fasteners and other purchased materials

A phantom item represents a temporary grouping used for design or planning convenience and may not be stocked or manufactured as a separate item. A planning BOM represents an expected product mix and supports aggregate planning where exact configurations are not yet known.

BOM accuracy requires correct quantities, units of measure, revision status, effectivity dates, scrap factors and engineering change controls. A component appearing at the wrong level or with an incorrect usage quantity causes systematic planning errors.

2.3 Inventory Records

The inventory record contains the information required to calculate net requirements. Typical fields include:

• Item identification and description
• Available on-hand balance
• Allocations or committed stock
• Scheduled receipts and their due dates
• Safety-stock requirement
• Lot-sizing rule
• Lead time
• Order policy and supplier or work-centre information
• Engineering revision and effectivity

Available inventory should not automatically be treated as unrestricted inventory. Quality holds, quarantine stock, reserved material and obsolete stock may be physically present but unavailable for the planned order.

2.4 MRP Planning Table

A simplified MRP record normally contains the following rows:

3. BOM Explosion, Netting and Offsetting

BOM Explosion

BOM explosion converts parent requirements into component requirements. If 120 parent units are scheduled and each requires four components, the gross component requirement is 480 units. If the component is used in multiple products, each parent contribution is calculated and added by period.

Requirements must be time-phased. A component required for assembly in week 5 is not necessarily required in week 5 if it must be issued to an earlier subassembly operation. The BOM structure and manufacturing lead times determine the timing.

Netting

Netting subtracts available inventory and valid scheduled receipts from gross requirements while protecting the required safety stock. A general period-by-period relationship is:

where PAB_t is projected available balance at the end of period t, SR_t is the scheduled receipt, PORc_t is the planned order receipt and GR_t is the gross requirement. The opening balance PAB₀ is the usable stock at the beginning of the horizon.

If the projected balance would fall below the safety-stock level, a net requirement is created. Before lot sizing, the requirement can be represented as:

Here, NR_t is net requirement, SS is safety stock and max(0,·) prevents a negative order requirement. This formulation assumes that beginning projected inventory and scheduled receipts are available in the relevant periods and that no other reservations or losses apply.

After a planned receipt is added, the projected balance is recalculated. The exact calculation depends on whether safety stock is treated as a minimum balance, a demand component or a policy constraint. The organization must define this convention consistently.

Offsetting

Offsetting determines the planned release date from the planned receipt date. Under a fixed lead-time assumption:

For example, if a purchased item is required in week 8 and its lead time is two weeks, the purchase order should be released in week 6. If the lead time is measured in working days, calendars, holidays, queue time and receiving time must be handled consistently.

Offsetting through a multilevel BOM is cumulative. A component with a two-week fabrication lead time inside an assembly with a one-week assembly lead time may need to be released three weeks before the finished item is due, subject to overlap and operation-specific timing.

4. Lot-Sizing Decisions

Net requirements specify the minimum additional quantity needed, but the actual order quantity depends on the lot-sizing rule. Lot sizing affects inventory, ordering or setup costs, capacity, supplier constraints and responsiveness.

Lot-for-Lot

Lot-for-lot (L4L) sets the planned order equal to the net requirement in each period. It minimizes planned cycle inventory and is useful for expensive, perishable or highly variable items. However, it may create frequent orders and setups.

Fixed Order Quantity

A fixed-order-quantity policy orders a predetermined quantity, such as 500 units, whenever a shortage occurs. It may reflect supplier pack sizes, process economics or minimum order quantities. The resulting projected balance may exceed the safety stock considerably.

Period Order Quantity

A period order quantity combines requirements over a specified number of periods, such as four weeks. It reduces order frequency but can increase inventory and exposure to forecast error.

Economic Order Quantity

For relatively stable independent demand, the classic EOQ is:

where Q^* is the economic order quantity in units per order, D is annual demand in units per year, S is ordering or setup cost per order, and H is annual holding cost per unit per year. The formula assumes relatively constant demand, known costs, replenishment that is effectively instantaneous, no stockouts and no quantity discounts. These assumptions are often weak for dependent-demand MRP items, so EOQ should not be applied mechanically.

Least Total Cost and Least Unit Cost

Dynamic lot-sizing methods compare alternative order groupings over several periods. Least total cost seeks a lot where cumulative holding cost is close to cumulative setup or ordering cost. Least unit cost chooses the grouping with the lowest combined cost per unit. These methods can be useful when requirements are uneven, although their results depend on the planning horizon and cost estimates.

5. Worked Example: A Single-Level MRP Calculation

Assume that 100 units of finished product A must be completed in week 4. Each A requires three units of component B. Component B has 30 units available, no scheduled receipts, a safety stock of 10 units, a one-week lead time and a lot-for-lot policy. Assume the component is needed when production of A begins in week 4.

The gross requirement for B in week 4 is:

At the start of week 4, usable inventory is 30 units. To finish the period with 10 units of safety stock, the net requirement is:

With lot-for-lot, the planned order receipt is 280 units in week 4. With a one-week lead time, the planned order release is 280 units in week 3. The ending projected balance is 10 units.

This example is deliberately simple. In a multilevel BOM, the planned order release for a parent—not merely its finished-goods requirement—would generate the component’s gross requirement.

6. Safety Stock and Lead-Time Management

Safety stock protects against uncertainty in demand, supply, quality, yield or transportation. It is not a substitute for accurate planning. Excessive safety stock hides data problems, consumes working capital and can increase obsolescence; insufficient safety stock increases shortages and expediting.

For an item with variable demand during a replenishment lead time, a commonly used service-oriented expression is:

where SS is safety stock, z is the standard-normal service factor, and σ_LT is the standard deviation of demand during lead time. This relationship assumes that demand uncertainty is represented adequately by a normal approximation and that the selected service factor corresponds to the desired cycle-service probability.

If independent period demand has standard deviation σ_d and lead time is a constant L periods, then:

If both demand and lead time vary, the calculation must incorporate both sources of variation; a simple constant-lead-time formula is then inappropriate. Organizations should also consider supplier reliability, demand intermittency, criticality, substitution and the cost of shortage.

Lead-time management should address the full elapsed time: order processing, queueing, setup, fabrication, inspection, transport, receiving and put-away. Reducing variability is often more valuable than reducing the average alone. Accurate supplier promises, realistic routings, capacity checks and feedback from actual completion dates improve MRP performance.

7. MRP Nervousness

MRP nervousness is excessive change in planned orders caused by small changes in demand, inventory, lead time or system parameters. A revised forecast may change a planned order from one period to another, alter its quantity or create cancellation and expediting messages. Frequent changes disrupt suppliers, production schedules and workforce plans.

Causes include:

• Unstable MPS and frequent order reprioritization
• Short planning horizons
• Inaccurate inventory and BOM data
• Long or variable lead times
• Poor lot-sizing policies
• Inappropriate safety stocks
• Lack of time fences
• Excessive forecast revision

Controls include frozen and slushy planning time fences, order-change tolerances, firm planned orders, supplier communication, longer frozen horizons, accurate transaction discipline and selective use of safety stock. A time fence should not be used to conceal infeasibility; it should establish clear authority for changing different parts of the plan.

Managers should distinguish useful responsiveness from harmful instability. A change that prevents a major customer shortage may be necessary, while repeated changes to low-value items may create more cost than benefit. Exception messages should therefore be prioritized by shortage risk, customer impact, material value and change magnitude.

8. Open-Loop MRP, Closed-Loop MRP and MRP II

Open-Loop MRP

Open-loop MRP calculates material plans from the MPS but does not systematically check whether production capacity can execute them. It may produce a mathematically consistent materials plan that is impossible because labour, machines, tools or suppliers lack capacity.

Closed-Loop MRP

Closed-loop MRP adds capacity planning and feedback. Material plans are checked against rough-cut capacity, detailed capacity requirements and shop-floor status. Actual completions, scrap, delays and inventory transactions feed back into the planning process. If capacity is inadequate, management may revise the MPS, routing, lot size, overtime or sourcing plan.

MRP II

Manufacturing Resource Planning (MRP II) extends closed-loop MRP beyond materials and shop-floor capacity. It integrates business planning, sales and operations planning, finance, purchasing, engineering, production and performance measurement. MRP II seeks a common plan in which operational decisions can be evaluated financially.

Modern enterprise resource planning (ERP) systems embody many MRP II concepts and integrate them with finance, procurement, maintenance, quality, human resources and customer processes. The names of systems vary, but the central principle remains integration of valid data, planning logic and execution feedback.

9. Implementation, Governance and Technology

Successful MRP implementation is primarily a process and data-governance project, not merely a software installation. Essential controls include:

• A single item master with defined ownership
• Accurate and revision-controlled BOMs and routings
• Cycle counting and inventory transaction discipline
• Lead-time review based on actual performance
• Clear policies for safety stock and lot sizing
• Authorized engineering change procedures
• User training and segregation of duties
• Audit trails for changes to orders and master data

Digital systems can provide dashboards, exception prioritization, supplier portals and automatic rescheduling. Advanced analytics and AI may forecast demand, estimate lead-time distributions, identify anomalous inventory transactions or recommend parameter changes. However, AI-generated recommendations must remain explainable, traceable and subject to human approval. Historical data may encode supplier or product biases, and an algorithm cannot compensate for an incorrect BOM or a physically impossible capacity plan.

Cybersecurity is also relevant because an altered BOM, supplier lead time or planned order can create operational and financial damage. Access controls, change logs, backups, validation and business-continuity procedures are therefore part of responsible MRP governance.

10. Illustrative Case: Northstar Pump Works

Background

Northstar Pump Works assembles industrial pumps from a motor, impeller, housing and seal kit. Demand for pumps is seasonal, and the company has experienced both component shortages and excessive stocks of seals.

Problem

The planning team used a spreadsheet MRP system. The BOM listed four seals per pump, but a recent engineering revision required three seals. The inventory record showed 1,200 seals, although 300 were on quality hold. Supplier lead time was recorded as two weeks, while actual average elapsed time was three weeks with significant variation. Production planners frequently changed the MPS inside the same week.

Analysis

The incorrect BOM created systematic overstatement of gross requirements. Treating quarantined stock as available understated net requirements. The unrealistic lead time caused late releases, while unstable MPS changes produced nervousness. The company had a materials problem, but the deeper causes were master-data governance and weak feedback.

Approach and Solution

Northstar established an engineering-change approval process, separated unrestricted and quarantined inventory, and reviewed supplier lead time using actual receipt history. It introduced a two-week frozen zone for stable customer orders and a controlled exception process for urgent changes. The pump BOM was corrected to three seals, and safety stock was recalculated using demand and supplier variability. The company also connected purchase-order receipts and production completions to the planning system and began weekly review of exception messages.

Outcome

The company reduced unnecessary seal purchases, improved visibility of genuine shortages and gave suppliers more stable schedules. It did not eliminate all shortages because demand remained uncertain, but planners were able to distinguish data errors, capacity constraints and genuine demand changes.

Learning Points

The case demonstrates that MRP performance depends on the integrity of the product structure, inventory status, lead-time assumptions and decision rules. Software automation magnifies both good and bad inputs. Effective MRP combines calculation with governance, cross-functional communication and disciplined execution.

11. Limitations and Best Practices

MRP is less effective when demand is highly intermittent, products are engineered uniquely, lead times are extremely uncertain or routings and BOMs change continuously. In such settings, planners may need project planning, order-point systems, kanban, postponement, supplier agreements or hybrid approaches.

Best practices include:

1. Keep the MPS realistic and linked to sales and operations planning.
2. Audit BOMs, routings, inventory balances and effectivity dates.
3. Use actual lead-time distributions rather than optimistic promises.
4. Select lot-sizing rules according to cost, variability and operational constraints.
5. Protect the plan with appropriate time fences without hiding problems.
6. Prioritize exception messages rather than treating every message equally.
7. Measure schedule stability, shortage frequency, inventory accuracy, supplier reliability and plan adherence.
8. Integrate capacity and financial implications through closed-loop MRP or MRP II.
9. Use AI and automation as controlled decision support, not as a replacement for accountability.
10. Review parameters periodically because demand, suppliers and processes change.

Chapter Summary

Materials Requirements Planning converts a master production schedule into time-phased plans for assemblies, components and purchased materials. BOM explosion calculates dependent gross requirements; netting subtracts usable inventory and scheduled receipts; lot sizing determines order quantities; and offsetting schedules releases according to lead time. The central MRP records are the MPS, BOM and inventory file, supported by accurate lead times, order policies and revision control.

Lot-for-lot, fixed order quantity, period order quantity and dynamic lot-sizing methods produce different trade-offs among setup cost, inventory and stability. Safety stock protects against uncertainty but should be based on service objectives and demand or lead-time variability. MRP nervousness arises when plans change excessively, and it can be controlled through accurate data, time fences, change tolerances and disciplined exception management.

Open-loop MRP plans materials without adequate capacity feedback. Closed-loop MRP adds capacity and execution feedback, while MRP II integrates manufacturing planning with business and financial planning. Modern ERP and analytics can strengthen MRP, but technology cannot correct inaccurate master data or poor governance. Effective MRP is therefore both a quantitative planning method and a cross-functional management system.

Key Terms

Available inventory: Stock that is usable for a specific planning purpose.

Bill of materials (BOM): Structured description of components and quantities required for a parent item.

BOM explosion: Conversion of parent requirements into component requirements.

Dependent demand: Demand calculated from the planned production of another item.

Economic order quantity (EOQ): Order quantity that balances ordering and holding costs under specified assumptions.

Gross requirement: Total component demand before inventory and receipts are considered.

Independent demand: Demand originating outside the production structure, such as customer demand.

Lot-for-lot: Lot-sizing rule that orders exactly the net requirement.

Lot sizing: Determination of the quantity released in a planned order.

Master production schedule (MPS): Time-phased schedule for producing specified end items.

MRP nervousness: Excessive changes in planned orders caused by plan or data changes.

MRP II: Integrated manufacturing resource planning including materials, capacity and business resources.

Net requirement: Additional quantity needed after available stock and receipts are considered.

Offsetting: Scheduling an order release backward from its required receipt date.

Phantom item: BOM grouping used for planning or design that is not normally stocked as a separate item.

Planned order release: Date and quantity at which an order should be launched.

Planned order receipt: Date and quantity at which a planned order is expected to become available.

Safety stock: Inventory held to protect against uncertainty.

Scheduled receipt: Previously released order expected to arrive in a specified period.

Review Questions

Short Answer Questions

1. What are the three principal inputs to an MRP system?
2. Distinguish independent demand from dependent demand.
3. What is the purpose of BOM explosion?
4. Why is a planned order release earlier than its planned order receipt?
5. Define MRP nervousness.

Long Answer Questions

1. Explain the complete sequence of explosion, netting, lot sizing and offsetting in an MRP system.
2. Compare lot-for-lot, fixed-order-quantity and period-order-quantity policies.
3. Explain how inaccurate BOMs, inventory records and lead times affect MRP results.
4. Compare open-loop MRP, closed-loop MRP and MRP II.
5. Discuss the managerial and governance requirements for successful MRP implementation.

Analytical / Application Questions

1. A product requires five units of component X. Planned production is 240 units in week 6. X has 180 usable units on hand, no scheduled receipt, a safety stock of 40 units and a one-week lead time. Using lot-for-lot, calculate the planned receipt and release quantity and date.
2. A supplier’s average lead time has increased from two to four weeks and its variability has also increased. Analyse the likely effects on MRP plans, safety stock and nervousness, and recommend actions.
3. A company has frequent shortages despite high total inventory. Diagnose possible MRP data and process causes and design a closed-loop improvement plan.

Multiple Choice Questions with Answers

Question 1

Which document specifies the time-phased quantities of finished goods to be produced?

A. Inventory record

B. Master production schedule

C. Routing sheet

D. Purchase requisition

Correct Answer: B. Master production schedule

Question 2

A product requires four units of component X for each finished unit. If 150 finished units are planned, what is the gross requirement for X before netting?

A. 37.5 units

B. 150 units

C. 154 units

D. 600 units

Correct Answer: D. 600 units

Question 3

Which MRP activity converts parent-item requirements into component requirements?

A. Offsetting

B. BOM explosion

C. Capacity smoothing

D. Cycle counting

Correct Answer: B. BOM explosion

Question 4

A component has a gross requirement of 500 units, 120 usable units on hand, no scheduled receipt and a safety stock requirement of 20 units. What is the net requirement before lot sizing?

A. 360 units

B. 380 units

C. 400 units

D. 640 units

Correct Answer: B. 380 units

Question 5

If an order is required in week 9 and its lead time is three weeks, when should it be released under a fixed-lead-time assumption?

A. Week 6

B. Week 7

C. Week 9

D. Week 12

Correct Answer: A. Week 6

Question 6

Which lot-sizing rule orders exactly the calculated net requirement in each period?

A. Fixed order quantity

B. Economic order quantity

C. Lot-for-lot

D. Period order quantity

Correct Answer: C. Lot-for-lot

Question 7

What is the principal purpose of safety stock?

A. To eliminate all setup costs

B. To protect against uncertainty

C. To replace the master schedule

D. To increase gross requirements permanently

Correct Answer: B. To protect against uncertainty

Question 8

Which condition is most directly associated with MRP nervousness?

A. Stable schedules and accurate records

B. Frequent changes to planned orders

C. Reduced supplier lead times

D. A frozen planning horizon

Correct Answer: B. Frequent changes to planned orders

Question 9

What distinguishes closed-loop MRP from open-loop MRP?

A. Closed-loop MRP excludes capacity planning

B. Closed-loop MRP uses capacity and execution feedback

C. Closed-loop MRP does not use BOMs

D. Closed-loop MRP plans only finished goods

Correct Answer: B. Closed-loop MRP uses capacity and execution feedback

Question 10

Which statement best describes MRP II?

A. It is limited to warehouse counting

B. It integrates manufacturing planning with broader business resources

C. It is a lot-for-lot calculation only

D. It eliminates the need for inventory records

Correct Answer: B. It integrates manufacturing planning with broader business resources