Materials Requirements and Enterprise Resource Planning

Introduction and context

Manufacturing organizations must answer three linked questions: what materials are required, how much is required, and when must they be available? Materials Requirements Planning (MRP) provides a time-phased method for answering these questions. It converts the production plan for finished goods into planned orders for assemblies, components and purchased materials.

MRP is not simply an inventory calculation. It is a dependent-demand planning system. Demand for a wheel, circuit board or fastener is normally derived from the planned production of a higher-level product. The quality of the plan therefore depends on the accuracy of the master production schedule, bill of materials, inventory records, lead times and transaction data.

MRP later developed into Manufacturing Resource Planning (MRP II), which integrated materials planning with capacity, finance, labour and other manufacturing resources. Enterprise Resource Planning (ERP) extends the integration across the whole organization, including procurement, production, sales, finance, human resources, maintenance and supply-chain activities.

Learning objectives

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

• explain dependent demand and the logic of MRP;
• interpret bills of materials, master production schedules and inventory records;
• calculate gross requirements, net requirements, planned receipts and planned order releases;
• apply lot-sizing and lead-time rules;
• distinguish MRP, MRP II and ERP;
• evaluate data accuracy, system integration and governance requirements;
• explain planning nervousness and methods for stabilizing plans;
• assess the managerial, technological and ethical implications of ERP implementation.

1. Dependent demand and the role of MRP

Independent demand originates outside the production system, for example customer orders for finished products or forecasts of market demand. Dependent demand is calculated from the demand for another item. If one bicycle requires two wheels, production of 500 bicycles creates dependent demand for 1,000 wheels, subject to inventory, scrap and timing considerations.

The distinction is important because independent demand is commonly forecast, whereas dependent demand is usually calculated. Forecasting every component separately can create inconsistent and unnecessary inventories. MRP uses the production schedule and product structure to derive component requirements systematically.

MRP normally performs five linked activities:

1. explodes the master production schedule through the bill of materials;
2. offsets requirements by lead times;
3. subtracts available inventory and scheduled receipts;
4. applies lot-sizing rules;
5. produces planned order releases and exception messages.

An MRP recommendation is not automatically a purchase order or manufacturing order. A planner must consider supplier reliability, capacity, minimum order quantities, engineering changes, quality constraints and commercial commitments.

2. The principal MRP inputs

Master production schedule

The Master Production Schedule (MPS) states which finished products are to be produced, in what quantities and in which time periods. It translates the aggregate production plan into specific end-item requirements. The MPS must be feasible with respect to capacity, available materials and promised delivery dates.

The planning horizon should cover at least the longest relevant cumulative lead time, often with additional time for visibility. Time buckets may be days, weeks or months. Short buckets improve precision but increase data and planning effort.

Bill of materials

A Bill of Materials (BOM) is a structured description of the components required to make one unit of a parent item. It normally identifies:

• parent and component item numbers;
• quantity per assembly;
• unit of measure;
• level in the product structure;
• effectivity dates or revision status;
• alternative, substitute or optional components;
• scrap or yield information where relevant.

A product structure can be represented as a tree. For example, one finished product may require two subassemblies; each subassembly may require three components. The low-level code records the lowest level at which an item appears and helps ensure that requirements are processed in the correct sequence.

BOM accuracy is essential. A wrong quantity per assembly creates systematic over- or under-planning. An obsolete revision may cause purchasing and production of nonconforming material.

Inventory records

The inventory record contains planning information for each item, including:

• on-hand balance;
• allocated or committed quantity;
• scheduled receipts;
• safety stock;
• lead time;
• lot-sizing rule;
• order policy and minimum or maximum quantities;
• scrap or yield assumptions;
• planning horizon and time-bucket data.

The planning balance is not always equal to the physical count. On-hand inventory may include material that is damaged, quarantined, reserved for another order or located where it cannot be used. Cycle counting, transaction discipline and reconciliation are therefore central to MRP performance.

Lead time

Lead time is the elapsed time between releasing an order and receiving usable material. It may include queue time, setup, processing, inspection, transport and administrative delay. For a manufactured item, the lead time may depend on routing, lot size and capacity loading. Treating lead time as a fixed constant is convenient but may be unrealistic in congested systems.

3. Time-phased MRP logic

MRP works period by period. For each item and period, it determines gross requirements, projected available balance, net requirements, planned order receipts and planned order releases.

Let:

• GR_t = gross requirement in period t;
• SR_t = scheduled receipt in period t;
• PAB_t-1 = projected available balance at the end of the previous period;
• SS = required safety stock;
• NR_t = net requirement in period t;
• PORc_t = planned order receipt in period t.

A common netting relationship is:

This formula assumes that requirements, receipts and inventory are expressed in the same units and that scheduled receipts are usable in period t. If safety stock is not used, SS is set to zero. The projected balance after planned activity is:

The planned receipt is determined by the lot-sizing rule. The planned order release is the planned receipt shifted earlier by the item’s lead time:

Here, L is lead time measured in the same periods as the planning horizon. This offset assumes a fixed lead time and no delay. In practice, planners may release earlier to protect against uncertainty.

Worked example: lot-for-lot planning

An item has the following data:

• opening available inventory: 40 units;
• safety stock: 10 units;
• lead time: 1 week;
• scheduled receipt: 20 units in week 2;
• gross requirements: 20, 30, 40 and 25 units in weeks 1–4;
• lot-sizing rule: lot-for-lot.

Under lot-for-lot, each planned receipt equals the exact net requirement. The calculations are:

For week 1, the balance is 40−20=20. In week 2, the scheduled receipt produces 20+20−30=10. In week 3, a receipt of 40 is required to preserve the 10-unit safety stock: 10+40−40=10. In week 4, a receipt of 25 is required: 10+25−25=10.

The planned releases occur one week before the receipts because lead time is one week. A planned release is a signal to initiate procurement or production, not proof that the material has already been received.

4. BOM explosion and gross-to-net processing

Suppose one table requires four legs and one tabletop. If the MPS requires 120 tables in week 6, gross requirements are 480 legs and 120 tabletops in week 6, before considering inventory or scheduled receipts. If each leg requires a plastic foot and two screws, the next explosion creates 480 plastic feet and 960 screws.

The general requirement for a component may be expressed as:

where q_{component,parent} is the quantity of the component required per parent and the summation covers all relevant parent items. The formula assumes a valid, single-level relationship for the period being processed. Multi-level products require sequential explosion from higher to lower levels, with lead-time offsets.

Scrap and yield may alter the gross requirement. If a process has an expected yield of 95%, the input required for a desired output may be calculated as:

Yield must be expressed as a decimal, so 95% becomes 0.95. This relationship is appropriate when yield losses are statistically stable and the organization plans to compensate for them. Unstable or quality-related losses require corrective action rather than merely larger orders.

5. Lot-sizing decisions

Lot sizing determines how much to order or produce when a net requirement occurs. The choice affects setup cost, carrying cost, obsolescence, space, cash flow and service performance.

The classical Economic Order Quantity (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 model assumes relatively constant demand, instantaneous replenishment, no shortages, constant costs and a single item considered independently. These assumptions often do not hold exactly in MRP environments, so EOQ should be treated as a benchmark rather than an unquestionable answer.

For example, if annual demand is 10,000 units, ordering cost is 50 currency units per order and annual holding cost is 2 currency units per unit, then:

Q* = √(2×10000×50÷2) = √500000 ≈ 707 units.

A supplier minimum of 1,000 units would override the unconstrained EOQ, subject to an evaluation of inventory and service consequences.

6. MRP, MRP II and ERP

MRP

MRP is primarily a materials and component planning system. It links the MPS, BOM and inventory records to create time-phased procurement and production recommendations. Its central concern is material availability.

MRP II

MRP II broadens MRP by integrating manufacturing resources. It may include:

• capacity requirements planning;
• shop-floor control;
• purchasing and supplier scheduling;
• aggregate production planning;
• costing and financial feedback;
• simulation of alternative production plans.

MRP II asks not only whether materials are available, but also whether labour, machines, tools and finance can support the proposed plan.

ERP

ERP is an integrated enterprise system using a common database and connected business processes. It may link sales and operations planning, customer orders, product configuration, purchasing, inventory, production, quality, maintenance, finance, human resources and logistics.

ERP does not eliminate the need for planning expertise. It automates calculations and transactions, but it cannot decide correctly when the underlying data, policies or assumptions are wrong.

7. Data governance and system integration

The expression “garbage in, garbage out” is particularly applicable to MRP and ERP. Important controls include:

• a single approved item master;
• standardized units of measure;
• controlled item numbering;
• formal engineering-change procedures;
• revision and effectivity-date control;
• cycle counting and inventory reconciliation;
• lead-time measurement based on actual performance;
• ownership of BOM and routing data;
• validation of supplier minimums, yields and scrap factors;
• audit trails for changes;
• role-based access and segregation of duties.

Integration requires more than connecting software modules. The organization must define common data meanings and process ownership. For example, “available inventory” must consistently distinguish unrestricted stock, quality-hold stock, allocated stock and consignment stock.

Interfaces with warehouse systems, supplier portals, manufacturing execution systems, product-lifecycle-management systems and financial ledgers should include validation, error handling and reconciliation. Real-time integration can improve visibility, but it can also transmit errors faster. Automated interfaces therefore require monitoring and exception management.

8. Planning nervousness and stability

Planning nervousness is excessive change in planned orders caused by frequent updates to demand, inventory, lead times, capacity or planning parameters. A small change in a finished-product schedule can move many component orders across time periods. This may cause cancellations, expediting, rescheduling, overtime, supplier dissatisfaction and excess inventory.

Common causes include:

• unstable forecasts or customer orders;
• short frozen planning windows;
• inaccurate inventory records;
• unrealistic lead times;
• variable yields and supplier performance;
• poor coordination between sales, production and purchasing;
• inappropriate order-modifier settings;
• lack of capacity checks.

Practical responses include:

1. establish time fences, such as frozen, slushy and liquid planning zones;
2. use planning calendars and agreed update frequencies;
3. separate genuine priority changes from routine forecast noise;
4. improve forecast and inventory accuracy;
5. use safety time or safety stock selectively;
6. apply order policies that avoid unnecessary small changes;
7. communicate changes through formal exception management;
8. measure schedule adherence, rescheduling frequency and supplier impact.

Stability must not become rigidity. A frozen schedule that ignores a safety emergency, major customer change or material-quality problem is also poor management. The objective is controlled responsiveness.

9. Implementation and managerial practice

An MRP or ERP implementation is an organizational change project, not merely a software installation. A disciplined implementation normally includes process mapping, data cleansing, parameter definition, pilot testing, user training, cutover planning and post-implementation review.

Management should ensure that planners understand both system logic and operational reality. Excessive reliance on manual overrides can hide structural problems, whereas unquestioning reliance on system recommendations can create serious disruption. Exception messages should direct attention to material shortages, overdue receipts, rescheduling proposals and demand changes that exceed agreed limits.

Useful performance measures include:

• inventory record accuracy;
• BOM accuracy;
• schedule adherence;
• plan stability;
• supplier delivery reliability;
• stockout frequency;
• inventory turns;
• order-expediting frequency;
• capacity utilization and overload;
• forecast and demand-plan accuracy.

No single metric is sufficient. High inventory turns may conceal poor customer service; high schedule adherence may result from setting an unrealistic schedule; and high capacity utilization may reduce flexibility and increase delays.

10. Case application: illustrative electronics manufacturer

Background

Nova Controls produces industrial sensor panels. Each panel requires one controller, two interface boards and one housing. Each interface board requires three connectors and four fasteners. The company uses an ERP system, but planners frequently expedite materials and suppliers receive schedule changes every week.

Problem

An audit found that the controller BOM had not been revised after an engineering change. The inventory system also counted quarantined connectors as available. Supplier lead times were maintained as optimistic commercial estimates rather than actual elapsed times. Consequently, MRP showed sufficient supply while production experienced shortages.

Analysis

The organization traced the problem through the data chain:

• the MPS was reasonably accurate;
• the controller BOM used an obsolete revision;
• inventory status codes were not consistently used;
• connector lead time was recorded as two weeks, while actual performance averaged four weeks;
• planners manually changed orders without recording reasons;
• sales changes were passed directly into the near-term schedule.

The issue was therefore not a mathematical failure of MRP. It was a governance, master-data and planning-policy failure.

Approach and solution

Nova Controls assigned ownership for each data object. Engineering controlled BOM revisions, warehouse management controlled stock status, procurement maintained supplier lead-time evidence, and production planning controlled time fences. A two-week frozen zone was introduced, and changes inside that zone required approval. Cycle counting was increased for high-value and shortage-critical items. Supplier lead times were recalculated from receipt-history data, and the ERP was configured to exclude quarantined stock from available inventory.

A pilot product family was tested before wider rollout. Planners were trained to distinguish planned orders from firm orders and to document overrides.

Outcome

After three planning cycles, emergency purchase orders declined, schedule changes inside the frozen zone became less frequent, and material shortages were identified earlier. Inventory did not immediately fall, because the organization initially increased selected safety stocks while supplier reliability was being improved. This illustrates an important principle: data correction may reveal previously hidden requirements before performance improves.

Learning points

The case demonstrates that MRP quality depends on master data, transaction discipline, planning policies and cross-functional accountability. ERP integration improves coordination only when the integrated processes are defined and governed.

11. Contemporary developments and responsible use of technology

Cloud ERP, advanced planning systems, supplier collaboration platforms, Internet-of-Things sensors and machine-learning forecasting are changing production planning. Real-time machine data can improve completion estimates; supplier portals can expose shipment status; and analytics can identify abnormal lead times or inventory transactions.

Artificial intelligence may support demand sensing, anomaly detection, parameter recommendations and predictive maintenance. However, AI recommendations require explainability, data-quality checks, human accountability and monitoring for systematic bias. A model trained on historical shortages may learn to recommend excessive safety stock rather than address supplier unreliability. Sensitive commercial and employee data also require cybersecurity, access control and lawful processing.

Responsible practice includes maintaining auditability, testing automated decisions, protecting confidential information, ensuring that workers understand process changes and retaining human authority over safety-critical or high-impact decisions.

Challenges and limitations

MRP is powerful but not omniscient. Its limitations include:

• dependence on accurate BOMs, inventory and lead times;
• difficulty representing highly uncertain demand;
• sensitivity to capacity constraints unless linked to capacity planning;
• simplified assumptions about fixed lead times;
• potential for excessive nervousness;
• weak treatment of unplanned scrap, rework and disruptions;
• implementation cost and organizational resistance;
• danger of confusing system precision with decision accuracy.

MRP should be complemented by sound forecasting, sales and operations planning, finite-capacity analysis, supplier development, lean practices and effective shop-floor control.

Chapter Summary

MRP converts an MPS into time-phased component and material plans by exploding the BOM, netting requirements against inventory and scheduled receipts, applying lot-sizing rules and offsetting planned receipts by lead times. Its central equations calculate net requirements and projected available balances, but the usefulness of the result depends on accurate data and realistic assumptions.

MRP focuses on materials; MRP II integrates broader manufacturing resources; ERP connects enterprise-wide processes through shared data and transactions. Effective implementation requires controlled item masters, BOM governance, inventory accuracy, lead-time management, secure integration and trained users. Planning nervousness must be managed through time fences, disciplined change control, better data and meaningful exception management. Modern analytics and AI can enhance planning, but they do not replace governance, professional judgement or accountability.

Key Terms

Dependent demand: Demand calculated from the requirement for another item.

Enterprise Resource Planning (ERP): Integrated software and processes supporting multiple organizational functions.

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

Gross requirement: Total demand for an item before available supply is deducted.

Independent demand: Demand originating from customers or external markets.

Inventory record: Planning record containing stock, receipts, lead time and policy data.

Lead time: Time between order release and receipt of usable material.

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

Lot sizing: Determination of the quantity released or received for an item.

Low-level code: BOM indicator showing the lowest product-structure level at which an item occurs.

Master Production Schedule (MPS): Time-phased plan for producing specified finished goods.

MRP: Materials Requirements Planning.

MRP II: Manufacturing Resource Planning, extending MRP to broader manufacturing resources.

Net requirement: Requirement remaining after usable supply and relevant inventory are considered.

Planned order release: Recommended time to initiate an order.

Planned order receipt: Recommended time and quantity for an order to become available.

Planning nervousness: Excessive instability in planned orders caused by frequent changes.

Safety stock: Inventory held to protect against uncertainty.

Time fence: Boundary controlling the extent to which planned orders may be changed.

Review Questions

Short Answer Questions

1. Distinguish independent demand from dependent demand.
2. What information is normally contained in a BOM?
3. Explain the difference between a planned order receipt and a planned order release.
4. State two causes of planning nervousness.
5. Why is inventory-record accuracy important in MRP?

Long Answer Questions

1. Explain the complete input-process-output logic of an MRP system.
2. Compare MRP, MRP II and ERP in terms of scope, information and managerial use.
3. Discuss the assumptions and limitations of EOQ when used in an MRP environment.
4. Explain how BOM governance and engineering-change control affect production performance.
5. Describe a systematic approach to implementing an ERP-supported planning process.

Analytical / Application Questions

1. An item has 30 units available, safety stock of 5 units and gross requirements of 20, 25 and 15 units in three successive weeks. There is a scheduled receipt of 10 units in week 2. Using lot-for-lot logic, calculate planned receipts and ending balances.
2. A component is used four times in each parent product. The MPS requires 180 parent units in week 5. The component has 60 units available and a lead time of two weeks. Explain the gross requirement, the likely net requirement before other receipts, and the release period.
3. A factory has accurate MPS data but obsolete BOM revisions, optimistic supplier lead times and frequent near-term schedule changes. Diagnose the likely effects and propose an integrated improvement plan.

Multiple Choice Questions with Answers

Question 1

Which input directly defines the quantity of each component required for one parent item?

A. Master production schedule

B. Bill of materials

C. Inventory turnover report

D. Capacity utilization report

Correct Answer: B. Bill of materials

Question 2

If projected available inventory before a period is 20 units, gross requirement is 35 units, scheduled receipt is 10 units and safety stock is zero, what is the net requirement?

A. 5 units

B. 15 units

C. 25 units

D. 45 units

Correct Answer: A. 5 units

Question 3

A planned order receipt is normally converted into a planned order release by:

A. Adding the safety stock

B. Multiplying by the BOM quantity

C. Offsetting it earlier by the lead time

D. Subtracting the gross requirement

Correct Answer: C. Offsetting it earlier by the lead time

Question 4

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

A. Fixed order quantity

B. Lot-for-lot

C. Minimum order quantity

D. Periodic order quantity

Correct Answer: B. Lot-for-lot

Question 5

The primary scope of MRP II, compared with MRP, includes:

A. Only customer relationship management

B. Only warehouse location control

C. Broader manufacturing resources such as capacity and finance

D. Only payroll processing

Correct Answer: C. Broader manufacturing resources such as capacity and finance

Question 6

Using Q* = √(2DS÷H), what is the EOQ when D=8000, S=25 and H=2?

A. 200 units

B. 316 units

C. 447 units

D. 632 units

Correct Answer: C. 447 units

Question 7

Which condition is most likely to create planning nervousness?

A. A controlled frozen planning zone

B. Stable lead times and accurate inventory

C. Frequent changes to near-term schedules

D. Formal engineering-change control

Correct Answer: C. Frequent changes to near-term schedules

Question 8

Which stock should normally be excluded from usable available inventory?

A. Unrestricted inspected stock

B. Stock on quality hold

C. Confirmed scheduled receipt

D. Approved safety stock

Correct Answer: B. Stock on quality hold

Question 9

ERP differs from traditional MRP mainly because ERP:

A. Eliminates the need for inventory records

B. Integrates enterprise-wide processes and shared data

C. Uses no time-phased planning

D. Plans only purchased components

Correct Answer: B. Integrates enterprise-wide processes and shared data

Question 10

Why are time fences used in production planning?

A. To prevent all future schedule changes

B. To control changes and improve short-term plan stability

C. To increase every lot size

D. To replace the bill of materials

Correct Answer: B. To control changes and improve short-term plan stability