Closed-Loop MRP, Capacity, ERP, and S&OP Integration

Introduction

Material Requirements Planning (MRP) is often introduced as a time-phased calculation that converts a master production schedule (MPS) into planned orders for components and raw materials. In practice, however, an MRP plan is useful only when it is feasible, executable, financially justified, and continuously corrected by feedback. A planned order that exceeds machine capacity, depends on unavailable labor, conflicts with supplier lead times, or cannot be funded is not a plan in the managerial sense; it is merely a computational result.

Closed-loop MRP addresses this limitation by connecting material planning with capacity planning, purchasing, shop-floor control, distribution, finance, and feedback. Enterprise resource planning (ERP) extends the concept by integrating transaction data and business processes across the organization. Sales and operations planning (S&OP), and its broader form integrated business planning (IBP), provide the cross-functional governance through which alternative plans are evaluated against demand, supply, inventory, risk, and financial objectives.

The central principle of this chapter is that planning must operate as a controlled system: plans are generated, tested, authorized, executed, measured, and revised. Integration is therefore both a technical and organizational challenge.

Learning Objectives

By the end of this chapter, the reader should be able to:

1. Explain the architecture and logic of closed-loop MRP.
2. Distinguish material feasibility from capacity and financial feasibility.
3. Apply capacity requirements planning (CRP) and rough-cut capacity planning.
4. Explain the links among purchasing, shop-floor control, distribution, and MRP.
5. Evaluate how ERP supports, but does not replace, planning discipline.
6. Describe the relationship between MRP, S&OP, and IBP.
7. Design meaningful feedback, exception-management, and governance mechanisms.
8. Critically assess implementation risks, data requirements, and emerging technologies.

1. From Material Planning to Closed-Loop Control

Traditional MRP performs three principal tasks:

• Explosion: translating parent-item requirements into component requirements through the bill of materials (BOM).
• Netting: subtracting available inventory, scheduled receipts, and other usable supplies from gross requirements.
• Time phasing: offsetting planned receipts by relevant lead times to determine planned release dates.

A simplified net-requirement relationship for period t is:

Here, NR_t is net requirement, GR_t is gross requirement, PAB_t−1 is projected available balance at the end of the previous period, and SR_t is scheduled receipt in period t. All quantities must use the same unit of measure and time bucket. The expression assumes that available inventory is unrestricted and that safety-stock requirements have either been included in the netting logic or separately protected.

A planned receipt is then determined by the lot-sizing rule. Under lot-for-lot sizing, the planned receipt equals the net requirement. Under a fixed-lot rule, the receipt may be the smallest permitted lot that covers the requirement. The planned release is offset from the receipt by the effective lead time:

This calculation is not sufficient by itself. MRP commonly assumes that capacity, supplier performance, inventory records, BOMs, routings, and lead times are valid. Closed-loop MRP tests these assumptions and feeds execution results back into the planning process.

A closed-loop system contains four linked stages:

1. Planning: MPS, MRP, purchasing plans, and capacity plans are generated.
2. Validation: material, labor, machine, supplier, storage, and financial constraints are assessed.
3. Execution: orders are released, purchased, manufactured, received, and distributed.
4. Feedback: actual completions, scrap, delays, inventory balances, capacity utilization, and customer changes update the next planning cycle.

Figure: Closed-loop MRP links planning, execution, and feedback.

2. Capacity Requirements Planning

2.1 Rough-cut capacity planning

Rough-cut capacity planning (RCCP) evaluates whether the MPS is broadly compatible with critical resources before detailed MRP execution. It uses resource profiles, such as standard hours per unit at a work center, and compares required hours with available hours.

MPS_i,t is the quantity of product i scheduled in period t, and Load_i,w is the standard capacity load imposed on work center w by one unit of product i. Both sides are measured in hours per period. The equation assumes that routing standards are representative and that the selected resource is the capacity bottleneck being tested.

A basic utilization measure is:

Utilization above 1.00 indicates a nominal overload. It does not automatically prove that production is impossible, because overtime, alternate resources, subcontracting, queue reduction, or lot rescheduling may be available. Conversely, utilization below 1.00 does not guarantee feasibility if skills, sequence, tooling, or maintenance constraints are ignored.

Available capacity should be defined explicitly. A practical calculation is:

This form is applicable when efficiency and downtime are estimated independently. If efficiency already includes downtime, multiplying by both factors would double-count losses. Capacity models must therefore document definitions carefully.

2.2 Detailed CRP

CRP uses MRP planned orders and detailed routings to calculate time-phased loads at individual work centers. It considers operation sequence, setup time, run time, queue time, move time, yield loss, tooling, and alternative work centers. A simplified order load is:

If quantity is 100 units, setup time is 2 hours, and run time is 0.08 hours per unit, the load is 10 hours. If the work center has only 8 available hours in the required period, the order is not feasible without an intervention.

CRP responses include changing the MPS, moving orders, splitting lots, authorizing overtime, adding shifts, using an alternate routing, subcontracting, improving setup performance, or accepting a service consequence. The correct response depends on cost, customer priority, due-date risk, and strategic capacity policy.

3. Integrating Purchasing and Shop-Floor Control

Purchasing integration

MRP-generated purchase requisitions or planned orders become purchase orders only after review of supplier status, price, minimum order quantity, contract terms, quality requirements, and delivery capability. Purchasing is therefore not a passive execution department. It contributes information about:

• supplier capacity and allocation;
• realistic lead times and variability;
• minimum and economic order quantities;
• approved substitutes;
• quality and regulatory requirements;
• supply risk and geopolitical exposure.

A system should distinguish planned, firm, and released orders. Excessive automatic release can create obsolete inventory when demand changes. Excessive manual intervention can destroy system discipline and create untraceable overrides.

Shop-floor control

Shop-floor control converts planned orders into dispatchable work. Its activities include order release, sequencing, material staging, labor assignment, progress reporting, quality recording, and completion confirmation. The feedback loop depends on accurate reporting of actual quantities, scrap, rework, operation completion, and interruptions.

A key governance issue is the boundary between planning and execution. MRP should determine what is needed and approximately when; dispatching determines the detailed sequence within the constraints of the work center. If planners repeatedly override the schedule without recording reasons, the system loses learning capability.

Distribution requirements planning

Distribution requirements planning (DRP) applies time-phased logic to distribution centers. A distribution location’s gross requirement may be generated by a replenishment policy or by the demand of downstream locations. DRP can then create planned transfer orders, which must be checked against transportation capacity, warehouse capacity, and inventory availability at the supplying location. In a multi-echelon network, local optimization can create excess total inventory; policies should therefore be evaluated across the network.

4. The Financial Dimension of MRP

Operational feasibility does not guarantee financial desirability. MRP decisions affect working capital, cash timing, margins, expediting cost, capacity investment, and risk of obsolescence. Finance should participate in policy design rather than merely report variances after execution.

For a simplified inventory position, ignoring accounting valuation differences:

All quantities must refer to the same item, location, and time period. Financial inventory value may be calculated using a cost convention such as standard cost, weighted average cost, or an approved accounting method; operational quantity and accounting value should not be confused.

A plan can be evaluated through a resource and financial reconciliation:

Contribution margin for a product may be expressed as:

This is useful for short-term mix decisions, but it should not be used alone for long-term product strategy because fixed costs, strategic customers, service commitments, and capacity opportunity costs also matter.

5. ERP as an Integrating Platform

ERP integrates master data, transactions, workflows, and financial records. Typical modules include sales and distribution, production planning, procurement, inventory management, quality, maintenance, warehouse management, transportation, costing, and finance. The major benefit is a common transaction record and process visibility.

ERP does not automatically create accurate plans. Its outputs depend on:

• correct item identifiers and units of measure;
• complete and effective-dated BOMs;
• valid routings and work-center calendars;
• accurate inventory and open-order records;
• realistic lead times and lot-sizing rules;
• disciplined transaction timing;
• clearly defined ownership of master data.

The principle “garbage in, garbage out” is especially important in MRP. A technically sophisticated ERP system can produce systematically wrong recommendations if inventory accuracy or BOM integrity is poor.

Implementation should address process design, data migration, role-based access, testing, training, change management, cybersecurity, and segregation of duties. Interfaces with suppliers, customers, warehouse automation, and planning tools introduce additional risks involving duplicate transactions, latency, and inconsistent definitions.

6. S&OP and IBP: Connecting Strategy and Operations

S&OP is a recurring, cross-functional process that reconciles a demand plan and a supply plan with business strategy. A typical monthly cycle includes data gathering, statistical or commercial demand review, supply review, pre-S&OP reconciliation, and executive decision-making. IBP extends the scope by more explicitly integrating product portfolio, projects, financial plans, risk, and strategic scenarios.

The planning hierarchy is important:

S&OP normally works at product-family and aggregate-resource levels, while MRP works at item and component level. They should not be forced into one time bucket or one degree of detail. S&OP establishes approved assumptions and boundary conditions; MPS translates them into end-item schedules; MRP and CRP test detailed feasibility.

Scenario planning is central to advanced S&OP. Alternatives may include a base plan, constrained-supply plan, demand-shaping plan, and resilience plan. Each scenario should state assumptions, constraints, service consequences, financial effects, and decision owners.

7. Feedback, Control, and Performance Measurement

Closed-loop planning requires feedback that is timely, accurate, and actionable. Useful feedback categories include:

• Demand: forecast error, order changes, cancellations, and bias.
• Supply: supplier confirmations, late receipts, quality failures, and lead-time changes.
• Production: schedule adherence, yield, scrap, downtime, and bottleneck utilization.
• Inventory: record accuracy, turns, aging, excess, obsolete stock, and shortages.
• Customer service: fill rate, on-time delivery, backorders, and recovery time.
• Financial: inventory investment, expediting cost, margin, and cash conversion.

Forecast error can be measured in several ways. Mean absolute deviation is:

Here, A_t is actual demand, F_t is forecast demand, and n is the number of observations. MAD is expressed in demand units and treats positive and negative errors equally. It should not be compared across products without considering scale; percentage-based measures may be more appropriate in some settings, although they behave poorly when actual demand is zero or very small.

Exception management is superior to reviewing every planning message with equal intensity. Exceptions should be prioritized by customer impact, financial exposure, constraint severity, and time to recovery. A control tower may consolidate alerts, but accountability must remain with named process owners.

8. Illustrative Integrated Case: Meridian Pumps

Background

Meridian Pumps, an illustrative industrial-pump manufacturer, sells three product families through regional distribution centers. Its ERP system contains MRP, purchasing, shop-floor, and finance modules. The company has historically measured departmental efficiency rather than end-to-end service and cash performance.

Problem

A new quarterly demand plan increases the MPS for the MP-200 family by 300 units in month two. MRP generates sufficient component orders, but CRP identifies an overload at the precision-machining center. At the same time, a critical supplier confirms a two-week delay, and finance warns that the resulting inventory plan exceeds the working-capital target.

Analysis

The S&OP team evaluates four alternatives:

1. retain the demand plan and authorize overtime;
2. shift some production to an approved alternate machine;
3. use a qualified subcontractor for machining;
4. negotiate delivery-date changes and shape demand through allocation.

The analysis includes machining hours, supplier capacity, qualification lead time, subcontract price, customer penalties, contribution margin, and cash timing. The team rejects an unqualified supplier despite its lower price because quality approval would not be completed before the required date.

Approach and solution

The executive S&OP meeting approves a mixed response: 60% of the incremental volume is produced using overtime, 25% is transferred to the alternate machine, and 15% is deferred with customer agreement. Purchasing splits the component order between the incumbent supplier and an approved secondary source. The MPS is revised, MRP is rerun, and CRP confirms that the remaining load is within authorized capacity.

The ERP system records the revised dates, supplier commitments, overtime authorization, and customer allocations. Shop-floor reporting is required at each operation, and a daily exception review is established until the constraint is removed.

Outcome

The company meets its highest-priority customer commitments, avoids an emergency subcontractor, and keeps projected inventory investment within the approved range. The apparent success is not attributed to ERP alone. It results from reliable master data, cross-functional decision rights, financial visibility, and a feedback loop that compares actual machining hours and supplier receipts with the approved scenario.

Learning points

The case demonstrates that MRP is a central calculation within a broader management system. Capacity, supplier, customer, and financial constraints must be considered together. It also illustrates that the best response to overload is often a portfolio of actions rather than a single universal rule.

9. Challenges, Governance, and Contemporary Developments

Major implementation challenges include unstable demand, poor inventory accuracy, excessive customization, conflicting performance incentives, weak executive sponsorship, and unclear ownership of master data. Local metrics can produce harmful behavior: purchasing may increase order size to obtain price discounts, while operations then carries excess inventory; production may maximize utilization by making items that are not needed; sales may accept orders without checking constrained capacity.

Governance should define approval thresholds for schedule changes, supplier substitutions, safety-stock revisions, and capacity overrides. Audit trails are important where planning decisions affect regulated products, product traceability, financial reporting, or customer commitments. Cybersecurity controls must protect supplier portals, production systems, and ERP interfaces from unauthorized changes.

Artificial intelligence and advanced analytics can support demand sensing, anomaly detection, lead-time estimation, supplier-risk analysis, and schedule optimization. They do not eliminate the need for clean data, causal reasoning, human accountability, or constraint validation. A machine-learning forecast that improves average error may still be unsuitable if it increases bias during a critical promotion or fails to explain a major demand shift. Human planners should review model assumptions, monitor drift, and retain override authority under defined governance.

Digital twins and scenario engines increasingly allow organizations to test capacity, inventory, and network alternatives before committing resources. Their value depends on model fidelity and synchronization with actual operations. More detail is not automatically better: an overcomplex model may be too slow, opaque, or difficult to maintain.

Best-Practice Design Principles

1. Maintain one governed definition for items, locations, calendars, BOMs, routings, and lead times.
2. Separate strategic, tactical, operational, and execution horizons.
3. Validate the MPS at rough-cut capacity level before detailed release.
4. Use CRP to identify bottlenecks, not merely to produce utilization reports.
5. Treat suppliers and customers as sources of planning information, not only transaction endpoints.
6. Reconcile operational plans with cash, margin, and working-capital objectives.
7. Use exception-based management with clear escalation ownership.
8. Measure end-to-end outcomes rather than isolated departmental efficiency.
9. Record the reasons for overrides and use them to improve parameters.
10. Introduce analytics and AI only with data governance, validation, cybersecurity, and human accountability.

Chapter Summary

Closed-loop MRP extends material calculation into a managed cycle of planning, feasibility testing, execution, measurement, and revision. RCCP tests aggregate compatibility between the MPS and critical resources, while CRP evaluates detailed loads using routings, operations, and work-center calendars. Purchasing, shop-floor control, and DRP convert planned requirements into coordinated physical flows.

ERP provides an integrated transaction and data platform, but its value depends on master-data quality, process discipline, and governance. S&OP and IBP connect aggregate demand and supply decisions with strategy, finance, risk, and executive authority. Effective feedback uses actual demand, supply, production, inventory, service, and financial data to correct assumptions and improve future plans. The strategic objective is not maximum utilization or minimum inventory in isolation; it is a feasible, responsive, financially aligned operating plan.

Key Terms

Closed-loop MRP: MRP linked to capacity, execution, and feedback processes.

Capacity Requirements Planning (CRP): Detailed calculation of resource loads generated by planned orders.

Rough-Cut Capacity Planning (RCCP): Aggregate capacity test of the master production schedule.

Master Production Schedule (MPS): Time-phased plan for end items or major products.

Material Requirements Planning (MRP): Time-phased system for calculating component and material requirements.

Bill of Materials (BOM): Structured description of component relationships required to make a product.

Routing: Ordered sequence of manufacturing operations and their resource requirements.

Projected Available Balance: Expected inventory available after considering receipts and usage.

Planned Order Release: Date on which an order should be initiated to meet a planned receipt.

Shop-Floor Control: Management of order release, dispatching, progress, and completion.

Distribution Requirements Planning (DRP): Time-phased replenishment planning for distribution networks.

Enterprise Resource Planning (ERP): Integrated platform for enterprise transactions, processes, and data.

Sales and Operations Planning (S&OP): Cross-functional process reconciling demand, supply, and business objectives.

Integrated Business Planning (IBP): Broader planning approach linking S&OP with strategy, finance, portfolio, and risk.

Master Data: Governed definitions of items, structures, resources, suppliers, and planning parameters.

Exception Management: Prioritization and resolution of significant deviations from plan.

Schedule Adherence: Degree to which actual production follows the authorized schedule.

Working Capital: Funds committed to operating assets, including inventory and receivables less relevant current liabilities.

Digital Twin: Data-connected model used to represent and analyze a physical operation or network.

Review Questions

Short Answer Questions

1. What distinguishes closed-loop MRP from traditional MRP?
2. Explain the difference between RCCP and CRP.
3. Why can an ERP system produce poor MRP recommendations despite advanced functionality?
4. What role does finance play in integrated planning?
5. Why are actual shop-floor confirmations important to feedback?

Long Answer Questions

1. Explain how MPS, MRP, CRP, purchasing, and shop-floor control form an integrated planning hierarchy.
2. Discuss how S&OP and IBP connect operational planning with strategic and financial objectives.
3. Evaluate the benefits and risks of using ERP as the primary integration platform.
4. Explain how capacity overloads can be managed and why no single response is universally optimal.
5. Design a governance framework for master data, planning overrides, and exception escalation.

Analytical / Application Questions

1. A work center has 42 scheduled hours, 85% efficiency, and 10% planned downtime. Calculate available hours, stating whether the downtime factor is being treated independently of efficiency. If required load is 34 hours, calculate utilization and interpret the result.
2. Construct an S&OP response for a product family facing a 20% demand increase, a constrained supplier, and a fixed working-capital ceiling. Specify assumptions, alternatives, decision criteria, and feedback measures.
3. Using the Meridian Pumps case, assess the trade-offs among overtime, alternate routing, subcontracting, and customer-date negotiation. Recommend additional data that would improve the decision.

Multiple Choice Questions with Answers

Question 1

Which feature most directly distinguishes closed-loop MRP from traditional MRP?

A. It eliminates the need for a bill of materials.

B. It connects planning with execution feedback and capacity validation.

C. It plans only finished goods.

D. It replaces all managerial judgment with automatic releases.

Correct Answer: B. It connects planning with execution feedback and capacity validation.

Question 2

RCCP is primarily used to:

A. Verify aggregate capacity compatibility of the MPS.

B. Record supplier invoices.

C. Sequence every job on a machine.

D. Calculate financial depreciation.

Correct Answer: A. Verify aggregate capacity compatibility of the MPS.

Question 3

If a work center has 40 required hours and 32 available hours, its nominal utilization is:

A. 0.80

B. 1.00

C. 1.25

D. 1.40

Correct Answer: C. 1.25

Question 4

Which data item is most essential for detailed CRP?

A. Employee satisfaction survey results

B. Routing operation and work-center standards

C. Annual advertising expenditure

D. Customer color preferences only

Correct Answer: B. Routing operation and work-center standards

Question 5

In the simplified MRP netting equation, scheduled receipts are generally:

A. Added to gross requirements

B. Subtracted as an available source of supply

C. Ignored in every planning period

D. Converted directly into demand forecasts

Correct Answer: B. Subtracted as an available source of supply

Question 6

The main purpose of S&OP is to:

A. Replace all item-level MRP calculations

B. Reconcile aggregate demand, supply, and business objectives

C. Optimize only machine utilization

D. Authorize every shop-floor dispatch decision

Correct Answer: B. Reconcile aggregate demand, supply, and business objectives

Question 7

Which statement about ERP is most accurate?

A. ERP guarantees accurate plans regardless of data quality.

B. ERP integrates transactions and processes but depends on governed data and discipline.

C. ERP is limited to accounting transactions.

D. ERP removes the need for capacity planning.

Correct Answer: B. ERP integrates transactions and processes but depends on governed data and discipline.

Question 8

Which measure is expressed in demand units rather than a percentage?

A. Mean absolute deviation

B. Utilization ratio

C. Fill-rate percentage

D. Forecast bias percentage

Correct Answer: A. Mean absolute deviation

Question 9

A planned order release is normally time-phased by:

A. Adding lead time to the required receipt date

B. Subtracting effective lead time from the required receipt date

C. Ignoring the receipt date

D. Using the accounting period only

Correct Answer: B. Subtracting effective lead time from the required receipt date

Question 10

Why should AI-based planning recommendations retain human governance?

A. AI cannot process any historical data.

B. Models require validation, accountability, and monitoring for drift and constraint errors.

C. Human review always produces lower forecast accuracy.

D. AI systems do not use assumptions.

Correct Answer: B. Models require validation, accountability, and monitoring for drift and constraint errors.