8. Materials Requirements Planning, CRP and ERP Integration

Introduction and Context

Production planning and control must answer three connected questions: what is required, when is it required, and whether the organization has sufficient resources to produce it. Materials Requirements Planning (MRP) addresses the first two questions by converting the production plan into time-phased requirements for components and materials. Capacity Requirements Planning (CRP) then examines whether the planned orders can be executed with available machines, labour, tools, and other work-centre resources. When these activities are integrated with finance, purchasing, sales, inventory, maintenance, and human resources, they form the broader system known as Enterprise Resource Planning (ERP).

MRP is particularly valuable in environments where demand for components is dependent on the demand for finished products. A gearbox, for example, is not forecast independently when its requirement is generated by a production schedule for industrial pumps. Its requirement is calculated from the bill of materials (BOM), planned production quantities, inventory records, and lead times. This distinction between independent and dependent demand is the foundation of MRP.

MRP is not merely a software calculation. It is a planning logic that depends on accurate data, realistic schedules, disciplined transaction recording, and managerial judgement. An MRP system can produce precise-looking but impractical recommendations when its BOMs, inventory balances, lead times, or capacity assumptions are unreliable. The central managerial task is therefore to integrate material, capacity, and enterprise information into a feasible and responsive planning process.

Learning Objectives

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

1. Explain the purpose, logic, assumptions, and data requirements of MRP.

2. Distinguish independent demand from dependent demand and interpret the role of the master production schedule.

3. Explode a BOM and perform gross requirements, net requirements, planned receipts, and planned order releases calculations.

4. Apply lot-sizing rules and lead-time offsetting in practical planning situations.

5. Explain CRP and assess the relationship between material plans and available capacity.

6. Describe closed-loop MRP, Manufacturing Resource Planning (MRP II), and ERP integration.

7. Evaluate implementation risks, data-quality problems, governance requirements, and emerging digital developments.

From the Master Schedule to Component Requirements

The master production schedule (MPS) specifies the quantities and timing of end items to be completed. It is normally developed from sales orders, demand forecasts, customer commitments, inventory policies, and management decisions concerning production rates. The MPS is the principal input to MRP, but it should not be confused with a simple sales forecast. It is a time-phased statement of what the organization intends and expects to produce.

MRP uses three primary information sources:

• The MPS, which defines end-item requirements.
• The bill of materials, which defines product structure and component quantities.
• The inventory or item master record, which contains on-hand balances, scheduled receipts, lead times, lot-sizing rules, safety stock, and related parameters.

A BOM is a structured representation of the materials and assemblies needed to make one unit of a product. A single-level BOM identifies immediate components; a multi-level BOM shows the complete product structure. The level of an item indicates its position in the product hierarchy. In a product such as a pump, the pump may be level 0, the motor and casing level 1, and bearings or seals incorporated into those assemblies at level 2.

BOM accuracy is essential because requirements are multiplied as they are exploded through the product structure. A small error in a high-level quantity can create a substantial error in lower-level requirements. Engineering changes must therefore be reflected promptly, with effective dates and revision control.

The MRP Record and Its Logic

For each item, an MRP record is maintained across planning periods, usually weeks or days. The record commonly contains gross requirements, scheduled receipts, projected available balance, net requirements, planned order receipts, and planned order releases.

Gross requirements are the total quantities needed in a period before considering inventory or incoming orders. For a component, gross requirements are generated from the planned order releases of its parent item multiplied by the quantity per parent. If 300 parent assemblies are released in week 4 and each requires two units of a component, the component has a gross requirement of 600 units in week 4.

Projected available balance is calculated as:

Projected available balance = Previous projected balance + Scheduled receipts + Planned order receipts − Gross requirements

When safety stock is required, the projected balance should normally not fall below the specified safety-stock level. Net requirements arise when available inventory and scheduled receipts are insufficient to meet gross requirements while maintaining the required stock level. A simplified expression is:

Net requirement = Gross requirement + Desired ending inventory − Available supply

Available supply includes beginning inventory and relevant scheduled receipts. In practice, the calculation also considers earlier planned receipts, safety stock, allocation rules, and planning fences.

A planned order receipt is the quantity expected to become available in the period of need. A planned order release is the quantity that must be ordered or started earlier, after allowing for lead time. If an item has a two-week lead time and a planned receipt of 500 units is required in week 6, the planned release occurs in week 4.

The distinction is operationally important. Purchasing acts on purchase-order releases, while production control acts on manufacturing-order releases. MRP recommendations therefore become meaningful only when they are converted into authorized orders, monitored, and revised when conditions change.

A Worked MRP Calculation

Consider a product A with the following simplified structure:

• Each unit of A requires two units of B and three units of C.
• B requires two units of D.
• A has a one-week lead time; B and C have two-week lead times; D has one-week lead time.
• The MPS requires 100 units of A in week 5 and 80 units in week 6.
• Beginning inventory is 20 units of A, 40 units of B, 100 units of C, and 100 units of D.
• There are no scheduled receipts, safety stocks, or prior orders.
• Lot-for-lot sizing is used.

The MPS creates gross requirements for A of 100 units in week 5 and 80 units in week 6. Beginning inventory of 20 units is used against the first requirement, producing a net requirement of 80 units in week 5 and 80 units in week 6. The planned receipts for A are therefore 80 units in week 5 and 80 units in week 6. With a one-week lead time, planned releases for A occur in weeks 4 and 5.

B requirements are generated from the planned releases of A, not directly from the MPS. Since each A requires two B, releases of 80 units in week 4 and 80 units in week 5 create gross requirements of 160 B in week 4 and 160 B in week 5. Beginning inventory of 40 B leaves net requirements of 120 B in week 4 and 160 B in week 5. Thus, B planned receipts are 120 and 160 units, with releases in weeks 2 and 3 because B has a two-week lead time.

C requirements are three per A. The same parent releases create gross requirements of 240 C in weeks 4 and 5. Beginning inventory of 100 C leaves net requirements of 140 C and 240 C. Planned receipts are released in weeks 2 and 3.

D is a second-level component. Its gross requirements are generated from B planned releases, because D is required when B is started. Each B requires two D. B releases of 120 in week 2 and 160 in week 3 produce gross requirements of 240 D in week 2 and 320 D in week 3. Beginning inventory of 100 D produces net requirements of 140 and 320. With a one-week lead time, D releases occur in weeks 1 and 2.

This example illustrates three important principles. First, component demand is derived from parent planned releases. Second, inventory is netted at each level independently. Third, timing is determined by the relationship between the need date and the item’s lead time. If a parent order is rescheduled, the requirements of its children may also move, creating the familiar phenomenon of nervousness in MRP schedules.

Lot Sizing and Planning Policies

Lot sizing determines the quantity included in a planned order. The simplest policy is lot-for-lot, in which the order quantity equals the net requirement. It minimizes planned inventory but may create frequent orders, setup costs, or supplier transactions.

Fixed-order-quantity rules generate orders in a predetermined quantity, such as 500 units. This may reflect economic purchase quantities, machine setup considerations, packaging constraints, or supplier requirements. However, fixed quantities can create excess inventory and may cause order timing to be less closely aligned with actual demand.

Other approaches include economic order quantity, period-order quantity, minimum or maximum order quantities, and least-unit-cost methods. The economic order quantity balances ordering and holding costs under simplifying assumptions, but its usefulness is limited when demand, lead time, prices, or capacity change frequently. Period-order quantity groups requirements over a selected number of periods and can reduce administrative or setup costs.

Lot sizing is not purely a mathematical choice. A low unit price may be outweighed by obsolescence, storage, quality deterioration, or cash-flow costs. Conversely, frequent small orders may increase setups and transport emissions. Planners should evaluate total relevant cost, service requirements, supplier capability, and operational flexibility rather than selecting a rule mechanically.

Lead-Time Offsetting, Safety Stock and Planning Horizons

Lead-time offsetting moves a planned receipt backwards to determine the release date. The lead time may include queue time, setup time, processing time, move time, inspection, and purchasing or transportation time. Treating lead time as only the processing time often produces unrealistic schedules.

Safety stock protects against demand, supply, or process uncertainty. In MRP, it is generally maintained as a minimum projected balance. Excessive safety stock can conceal poor quality, unreliable suppliers, and inaccurate forecasts; insufficient safety stock can expose the production system to shortages. Its level should be connected to service objectives, demand variability, lead-time variability, and the criticality of the item.

MRP also uses planning time fences. Within a firm zone, changes may require managerial approval because materials, labour, or customer commitments have already been arranged. In a less restricted planning zone, the system may reschedule orders more freely. Time fences reduce instability, but they should not become excuses for ignoring serious changes in demand or supply.

Capacity Requirements Planning: Testing Feasibility

MRP answers whether materials are planned; CRP asks whether the required work can be performed. CRP translates planned and released orders into capacity requirements for specific work centres over time. It uses routing data, which identify operations, sequence, work centres, setup times, run times, queue assumptions, and sometimes labour qualifications.

For a work centre, required capacity can be represented as:

Required capacity = Σ (Setup time + Run time per unit × Order quantity)

Available capacity depends on the number of machines or workers, working hours, shifts, efficiency, utilization, planned downtime, breaks, holidays, and maintenance. A simple calculation might begin with scheduled hours and then subtract planned downtime, although organizations often distinguish theoretical, demonstrated, and practical capacity.

Suppose a work centre has two machines, each available for 35 hours per week after planned downtime. Its practical available capacity is 70 hours. If planned orders require 82 hours, the centre has a 12-hour overload. Management may respond by changing the order sequence, using overtime, subcontracting, adding a temporary machine, transferring work, reducing setup time, revising the MPS, or negotiating delivery dates.

CRP should be applied at an appropriate level of detail. Excessively detailed estimates may create administrative effort without improving decisions, while overly broad capacity groups may conceal bottlenecks. The most critical work centres, constrained suppliers, specialized skills, and long-lead resources deserve particular attention.

Closed-Loop MRP and MRP II

Basic MRP is often described as an open-loop system because it generates material plans without systematically checking production capacity or feeding execution results back into the plan. Closed-loop MRP adds capacity checks, shop-floor feedback, purchasing feedback, and schedule revision. Actual completions, scrap, delays, machine breakdowns, and inventory transactions are used to update the planning system.

MRP II extends closed-loop MRP by integrating manufacturing planning with broader organizational resources. It connects business planning, sales and operations planning, MPS, MRP, CRP, purchasing, shop-floor control, inventory, costing, and often financial planning. A change in the production plan can therefore be evaluated not only for material and capacity consequences but also for cash, labour, and delivery implications.

The logic is iterative rather than strictly linear. Business plans influence the aggregate production plan; the aggregate plan influences the MPS; the MPS drives MRP and CRP; execution produces feedback; and feedback leads to revised plans. This closed-loop characteristic is essential because a plan that is feasible on paper may become infeasible after disruptions or changes in priorities.

ERP Integration and Enterprise Data

ERP systems provide an integrated database and transaction architecture across functions. In an ERP environment, MRP and CRP are connected with sales orders, purchasing, warehouse management, quality, maintenance, costing, finance, human resources, and sometimes customer and supplier portals. A goods receipt can update inventory and accounts payable; a production confirmation can update inventory, labour records, costing, and order status.

Integration creates visibility but also increases the consequences of incorrect data. A wrong unit of measure can distort purchasing quantities. An incorrect BOM revision can generate unusable components. An unrealistic lead time can cause late releases. A failure to record scrap can create false inventory. ERP implementation therefore requires data governance, ownership, validation, change control, user training, and clear procedures for exception handling.

ERP does not eliminate planning judgement. It standardizes transactions and provides decision support, but planners still need to interpret demand uncertainty, supplier reliability, engineering changes, capacity constraints, and commercial priorities. The system should support differentiated planning: stable, repetitive items may use automatic replenishment, while engineered or constrained products require closer human review.

Practical Applications Across Industries

In discrete manufacturing, MRP is widely used for products such as vehicles, machinery, appliances, electronics, and medical equipment. It is especially useful where products have multi-level BOMs and components are assembled in a defined sequence. In process industries, the same logic may be adapted to recipes, formulas, co-products, batch sizes, and yield losses.

In project manufacturing, such as aerospace or large industrial equipment, MRP must accommodate long lead times, configuration changes, milestone schedules, and stringent traceability. In maintenance, repair, and overhaul operations, material planning is linked to work orders, equipment histories, interchangeable parts, and urgent service requirements. In make-to-order environments, planners must protect due dates while avoiding premature procurement of product-specific materials.

MRP also supports supplier collaboration. Shared forecasts, planned releases, supplier schedules, and electronic purchase orders can reduce manual communication. However, collaborative planning requires agreement on responsibilities, data visibility, security, and procedures for forecast changes.

Illustrative Case: Orion Pumps’ Capacity and Material Mismatch

Background

Orion Pumps, a fictional manufacturer of industrial water pumps, uses an ERP system with MRP. Its sales division accepts a large order for 240 pumps over six weeks. The MPS is revised immediately, and MRP generates component requirements for motors, casings, seals, bearings, and fasteners.

Situation and Problem

The MRP report shows that all materials can be available by the required dates. However, the production supervisor discovers that the machining centre responsible for casings is already heavily loaded. The ERP system also contains an outdated routing that understates setup time. As a result, the planned casing orders require 190 hours in a period with only 150 hours of practical capacity. The order appears materially feasible but is operationally impossible.

Analysis

The planning team first validates the BOM, inventory balances, open purchase orders, and engineering revision. It then corrects the routing by incorporating realistic setup and inspection times. CRP identifies the machining centre as the bottleneck. Alternative work centres are examined, but one lacks the required fixture and another has lower demonstrated capability. Supplier capacity for partially machined casings is also investigated.

The team compares four alternatives: overtime, subcontracting, changing the production sequence, and negotiating a phased delivery. Overtime can cover only part of the gap and would increase fatigue and cost. Subcontracting is feasible for a portion of the casings but requires supplier quality approval. Rescheduling other orders would protect the urgent customer but delay an existing commitment.

Approach and Solution

Orion decides to subcontract 40 casings, authorize limited overtime, and revise the MPS into two delivery waves. The ERP master data are corrected, including routing times, work-centre calendars, and supplier lead times. A planning time fence is established for the first two weeks, requiring production-control approval for schedule changes. Daily exception meetings review shortages, capacity, supplier status, and actual production confirmations.

Outcome

The revised plan becomes feasible without compromising critical quality requirements. The customer accepts the phased delivery because the commercial team communicates the constraint early. The company also identifies that its previous planning process treated MRP outputs as commitments without validating CRP assumptions.

Learning Points

The case demonstrates that material availability does not guarantee production feasibility. Accurate routing data are as important as accurate BOMs. Capacity planning should occur before customer promises are finalized when bottleneck resources are scarce. Finally, ERP integration is valuable only when operational data are current and responsibilities for maintaining them are clear.

Challenges, Risks and Common Mistakes

The most common MRP failure is poor data quality. Typical problems include inaccurate inventory records, missing scrap factors, obsolete BOMs, incorrect lead times, duplicate item codes, and unrecorded open orders. The resulting plan may be mathematically correct but operationally wrong.

Another problem is nervousness: small changes in the MPS can produce many changes in lower-level orders. Nervousness increases expediting, cancellations, supplier instability, and shop-floor confusion. Planning time fences, stable schedules, modular BOMs, appropriate safety stocks, and careful exception rules can reduce this effect.

MRP may also encourage a false belief that every requirement is known precisely. Forecast error, quality failures, supplier disruption, engineering changes, and equipment breakdowns remain unavoidable. MRP should therefore be combined with scenario analysis, risk buffers, supplier development, and visible escalation procedures.

Excessive reliance on system-generated recommendations is another risk. Planners may accept suggested orders without checking minimum order quantities, supplier calendars, tooling, cash constraints, or customer priorities. Conversely, users may override the system repeatedly, indicating that parameters or processes are defective. Overrides should be analysed as evidence for continuous improvement rather than treated as normal workarounds.

Governance, Ethics and Professional Responsibility

Planning decisions affect employees, suppliers, customers, and the environment. A planner who advances an order without considering labour safety, supplier capacity, or quality risk may meet a short-term date while creating greater harm. ERP access controls should ensure that users can change only appropriate data and that important changes are auditable.

Ethical planning includes honest communication of capacity and delivery risks, protection of confidential supplier and customer information, fair treatment of suppliers, and avoidance of deliberate data manipulation to improve performance indicators. Governance should define ownership of BOMs, routings, inventory records, planning parameters, and master-data changes.

Digital Developments and Emerging Practice

Modern planning platforms increasingly combine MRP with advanced planning and scheduling, real-time shop-floor data, supplier portals, and analytics. Internet of Things devices can provide machine status and actual production data; barcode and radio-frequency identification systems improve transaction accuracy; predictive analytics can identify likely shortages or late orders.

Artificial intelligence and machine learning can assist with demand sensing, lead-time estimation, anomaly detection, and recommendation of rescheduling alternatives. Their value depends on reliable historical data and explainable decision rules. An algorithm that recommends a schedule without exposing its assumptions may be difficult to govern in a regulated or safety-critical environment.

Cloud ERP improves accessibility and facilitates standardized updates, but it introduces cybersecurity, data residency, integration, and vendor-dependence concerns. Digital transformation should therefore be approached as a process and governance initiative, not simply as a software purchase.

Best-Practice Principles for Integrated Planning

Effective organizations generally follow several principles:

• Maintain disciplined ownership and revision control for BOMs, routings, calendars, lead times, and inventory records.
• Validate the MPS against aggregate capacity before releasing detailed requirements.
• Use CRP and bottleneck analysis to test feasibility rather than treating MRP output as an unquestionable plan.
• Segment items and suppliers according to value, risk, variability, and strategic importance.
• Establish planning time fences and clear approval rules for changes.
• Measure schedule adherence, inventory accuracy, shortage frequency, capacity utilization, supplier reliability, and forecast error together.
• Review exceptions and manual overrides to identify process and data problems.
• Train users in both system transactions and the underlying planning logic.
• Integrate operational, financial, quality, and sustainability consequences into decisions.

Chapter Summary

MRP converts an MPS into time-phased component requirements by exploding BOMs, netting inventory and scheduled receipts, applying lot-sizing rules, and offsetting orders by lead time. Its effectiveness depends on accurate item, BOM, routing, inventory, calendar, and supplier data. CRP extends the logic by comparing workload with available capacity at relevant work centres. Closed-loop MRP incorporates feedback from purchasing, production, and capacity execution, while MRP II connects manufacturing planning with wider organizational resources. ERP integrates these processes with finance, sales, quality, maintenance, and enterprise transactions. The central managerial lesson is that materials, capacity, information, and decisions must be integrated; a technically correct MRP calculation is not sufficient unless the resulting plan is feasible, governed, and responsive to uncertainty.

Key Terms

Independent demand: Demand arising directly from external customers or market requirements.

Dependent demand: Demand calculated from the requirements of a parent item.

Master Production Schedule: A time-phased plan specifying the quantity and timing of end items.

Bill of Materials: A structured list of components and quantities required to make a product.

Item master: The record containing planning, purchasing, inventory, and control data for an item.

Gross requirement: Total quantity required before considering available supply.

Scheduled receipt: An already-authorized order expected to arrive in a specified period.

Projected available balance: Expected inventory remaining after receipts and requirements.

Net requirement: Additional quantity needed after available supply is considered.

Planned order receipt: Quantity planned to become available in the period of need.

Planned order release: Quantity authorized for purchase or production after lead-time offsetting.

Lot sizing: The method used to determine the quantity in a planned order.

Lead time: Elapsed time required to procure, produce, inspect, and make an item available.

Safety stock: Inventory held to protect against uncertainty in demand or supply.

Capacity Requirements Planning: The process of comparing planned workload with available capacity.

Routing: The sequence of operations, work centres, and times required to produce an item.

Closed-loop MRP: MRP linked with capacity checks and feedback from execution.

MRP II: An integrated manufacturing planning system covering material, capacity, and broader resources.

ERP: An integrated enterprise system connecting cross-functional processes and data.

Planning time fence: A period within which schedule changes are restricted or controlled.

Review Questions

Short Answer Questions

1. Why is dependent demand calculated from planned order releases rather than directly from the sales forecast?

2. Distinguish between a planned order receipt and a planned order release.

3. What information is supplied by a routing in CRP?

4. How does safety stock affect net requirements?

5. Why is BOM revision control important in an ERP environment?

Long Answer Questions

1. Explain the complete logic of MRP from the MPS through BOM explosion, netting, lot sizing, and lead-time offsetting.

2. Discuss the relationship between MRP and CRP and explain why material availability does not guarantee production feasibility.

3. Compare basic MRP, closed-loop MRP, MRP II, and ERP in terms of scope and feedback.

4. Evaluate the major data-quality, implementation, and behavioural risks associated with ERP-based MRP.

5. Explain how lot-sizing, safety stock, and planning time fences influence inventory, responsiveness, and schedule stability.

Analytical / Application Questions

1. A product requires three units of component X per unit. The MPS requires 120 units in week 5 and 100 units in week 6. Beginning inventory of X is 50 units, with no scheduled receipts. Using lot-for-lot sizing, calculate the gross and net requirements for X and identify the planned receipts.

2. A work centre has 90 practical hours available in week 4. Planned orders require 35 hours of setup and 70 hours of run time. Analyse the capacity position and recommend two possible managerial responses.

3. An ERP system repeatedly recommends urgent purchases even though physical inventory appears sufficient. Diagnose at least four possible master-data or transaction causes and propose a corrective-action plan.

22. Multiple Choice Questions with Answers

Question 1

Which input directly determines the quantity and timing of end items that MRP must support?

A. Routing file

B. Master production schedule

C. Supplier rating

D. Work-centre calendar

Correct Answer: B. Master production schedule

Question 2

A parent item has planned order releases of 80 units in week 4 and 80 units in week 5. Each parent requires two units of component X. What are the gross requirements for X?

A. 80 units in weeks 4 and 5

B. 160 units in week 4 only

C. 160 units in weeks 4 and 5

D. 320 units in week 5 only

Correct Answer: C. 160 units in weeks 4 and 5

Question 3

If a planned order receipt is required in week 8 and the item lead time is three weeks, when should the planned order be released?

A. Week 5

B. Week 6

C. Week 8

D. Week 11

Correct Answer: A. Week 5

Question 4

Which lot-sizing rule normally minimizes planned inventory but may increase the number of orders or setups?

A. Fixed-order quantity

B. Lot-for-lot

C. Maximum-order quantity

D. Economic batch with annual review

Correct Answer: B. Lot-for-lot

Question 5

The principal purpose of CRP is to determine whether:

A. Customer demand is independent or dependent

B. BOM levels are correctly numbered

C. Planned workloads can be completed with available resources

D. Inventory valuation complies with accounting rules

Correct Answer: C. Planned workloads can be completed with available resources

Question 6

A component has a gross requirement of 500 units, beginning inventory of 120 units, and a scheduled receipt of 200 units. Assuming no safety stock, what is its net requirement?

A. 180 units

B. 200 units

C. 300 units

D. 380 units

Correct Answer: A. 180 units

Question 7

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

A. It eliminates the need for a master schedule

B. It incorporates capacity and execution feedback into replanning

C. It uses only financial data

D. It applies exclusively to process industries

Correct Answer: B. It incorporates capacity and execution feedback into replanning

Question 8

In the Orion Pumps case, why did the initial MRP output fail to guarantee delivery feasibility?

A. The MPS contained no end items

B. The BOM had too many levels

C. The machining work centre was overloaded and routing times were inaccurate

D. Safety stock was set to zero for every finished product

Correct Answer: C. The machining work centre was overloaded and routing times were inaccurate

Question 9

Which ERP governance practice most directly reduces the risk of obsolete BOMs generating incorrect requirements?

A. Allowing unrestricted master-data edits

B. Using revision control with effective dates and ownership

C. Increasing all safety-stock levels

D. Replacing CRP with manual scheduling

Correct Answer: B. Using revision control with effective dates and ownership

Question 10

Repeated manual overrides of MRP recommendations should primarily be interpreted as:

A. Proof that planners are unnecessary

B. Evidence that data, parameters, or planning processes may require investigation

C. A reason to disable inventory transactions

D. Evidence that lot-for-lot sizing is always inappropriate

Correct Answer: B. Evidence that data, parameters, or planning processes may require investigation