ERP for Operations Planning and Control

Introduction and Context

Enterprise resource planning (ERP) systems integrate data and transactions across purchasing, inventory, production, sales, finance, quality, maintenance, and logistics. In operations management, their central value is not merely automation. ERP creates a common planning model in which demand, materials, capacity, schedules, inventory, and customer commitments can be evaluated together.

Operations planning and control converts market requirements into feasible production and procurement decisions. Planning determines what should be produced, purchased, or held and when these activities should occur. Control monitors execution, records deviations, and initiates corrective action. ERP supports both activities through a connected sequence:

Demand and orders → master production schedule → material requirements plan → capacity checks → production and purchasing execution → inventory and performance feedback.

The quality of this sequence depends on the quality of master data, planning assumptions, and managerial judgment. An ERP system can calculate a mathematically consistent plan, but it cannot compensate for an inaccurate bill of material, an obsolete routing, an unrealistic lead time, or an unapproved forecast.

Learning Objectives

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

1. Explain how bills of material, routings, inventory records, and work centers form the operational foundation of ERP.
2. Apply material requirements planning (MRP) to time-phased dependent demand.
3. Evaluate capacity requirements and distinguish material feasibility from capacity feasibility.
4. Select appropriate inventory policies and interpret their operational consequences.
5. Construct and assess production schedules, demand plans, and available-to-promise commitments.
6. Explain how sales and operations planning (S&OP) aligns demand, supply, finance, and executive decisions.
7. Critically evaluate ERP implementation risks, governance requirements, and emerging analytical capabilities.

1. The Integrated Operations Planning Model

ERP planning is usually organized into planning horizons and levels of aggregation. Strategic planning addresses facilities, technologies, suppliers, and aggregate capacity over years. S&OP reconciles product-family demand and supply over months. The master production schedule (MPS) translates this agreement into end-item quantities by time period. MRP explodes the MPS into component requirements. Detailed scheduling sequences operations on machines, labor groups, or production lines.

These levels are related but not interchangeable. An MPS is not a detailed machine schedule, and MRP is not a demand forecast. MRP calculates the timing and quantity of dependent requirements after considering inventory, scheduled receipts, lead times, and lot-sizing rules.

A useful planning hierarchy is:

The integration creates feedback. For example, an MRP run may identify a shortage of a constrained component. The planner may revise the MPS, authorize an alternate supplier, change the product mix, or negotiate a customer date. Thus, ERP planning is a decision-support process rather than a one-time calculation.

2. Operational Master Data

Bills of Material

A bill of material (BOM) is a structured representation of the components required to manufacture or assemble an item. A single-level BOM lists immediate components; a multilevel BOM represents the complete product structure. Each parent–component relationship normally includes a quantity per parent, unit of measure, scrap allowance, effectivity dates, and sometimes issue-point or phantom-item information.

For a parent requiring q units of a component per parent and a planned production quantity of P, gross component demand is:

where G is gross component demand in component units. If expected scrap proportion is s, with 0 ≤ s < 1, the adjusted requirement may be represented as:

This expression assumes scrap is proportional and that the stated quantity is good output required. For example, producing 100 good units with a component quantity of 2 and 5% scrap requires (100 × 2) ÷ 0.95 = 210.53, normally rounded according to the item’s lot-sizing and unit rules.

BOM accuracy is strategically important. An incorrect quantity creates systematic shortages or excesses; an omitted component can stop production; an obsolete revision can cause quality and compliance failures. Engineering change control should therefore connect product lifecycle management, document control, inventory, and production systems.

Routings and Work Centers

A routing specifies the sequence of operations required to manufacture an item. It commonly identifies operation numbers, work centers, setup time, run time, queue or move time, labor skills, tools, inspection requirements, and alternatives.

If a work center processes Q units, with processing time t_p per unit and setup time t_s, the basic load is:

If there are n identical machines or parallel resources, a simplified elapsed processing time is L ÷ n, assuming work can be divided without loss and that labor, tooling, and material are available. This assumption often fails in practice because of batch integrity, qualification restrictions, sequence-dependent setups, or bottleneck interactions.

Capacity requirements planning converts planned orders into work-center loads. Available capacity should consider calendars, shifts, breaks, planned maintenance, absenteeism, and an appropriate efficiency or utilization assumption. Capacity should not automatically be planned at 100% utilization: variability and disruptions require protective capacity, especially at bottlenecks.

Inventory and Planning Records

ERP item records typically contain on-hand balance, allocated quantity, safety stock, lot-size rule, lead time, order policy, planning calendar, supplier or production source, and status. These records are supplemented by open purchase orders, production orders, reservations, quality holds, and projected receipts.

The planning file must distinguish physical on-hand inventory from available inventory. A quantity in quarantine, already allocated to another order, or located at the wrong site may not be usable for the requirement being planned. Unit-of-measure conversions and location-specific availability are frequent sources of error.

3. Material Requirements Planning

Logic of MRP

MRP is a time-phased planning technique for dependent demand. Dependent demand is derived from the planned production of another item, whereas independent demand originates from customers, forecasts, service requirements, or other external sources.

The fundamental MRP sequence is:

1. Establish gross requirements from the MPS or a parent planned order.
2. Determine projected available balance after receipts and requirements.
3. Calculate net requirements after considering available inventory and scheduled receipts.
4. Apply a lot-sizing rule.
5. Offset the planned receipt by the item lead time to determine the planned release.
6. Explode the planned parent order through the BOM to create lower-level gross requirements.

For period t, a simplified projected available balance is:

where PAB_t is projected available balance, SR_t is scheduled receipt, POR_t is planned order receipt, and GR_t is gross requirement. A planned order receipt is required when the projected balance would otherwise fall below the desired protection level. If safety stock is SS, a common net-requirement calculation is:

This formula assumes that safety stock is a target minimum and that the prior balance and scheduled receipts are usable for the requirement. Actual ERP systems may apply safety-time, firming, dynamic safety stock, reservations, or site-specific rules.

If the planned receipt is released only after a lead time of LT periods, then:

where PORel is planned order release and PORcpt is planned order receipt. The lead time must use consistent units and the correct calendar; a five-day lead time is not necessarily one weekly period.

Worked MRP Example

An end item requires two units of component C. The MPS requires 50 end items in week 3 and 40 in week 4. Component C has 20 units on hand, no scheduled receipts, a lot-for-lot policy, and a one-week lead time. Ignore safety stock.

Gross requirements for C are 100 units in week 3 and 80 units in week 4. The week 3 shortage is 100 − 20 = 80 units, so an 80-unit planned receipt is needed in week 3. The projected balance after that receipt is zero. Week 4 therefore requires 80 units. With a one-week lead time, releases occur in weeks 2 and 3.

The example illustrates why a component release can precede the end-item production period. It also shows why planners must distinguish receipt date from release date.

Lot-Sizing Policies

Common MRP lot-sizing methods include:

• Lot-for-lot: order exactly the net requirement. It minimizes cycle inventory but may create frequent orders and setups.
• Fixed order quantity: order a predetermined quantity, often based on supplier packs or economic considerations.
• Economic order quantity (EOQ): balance ordering and holding costs under stable assumptions.
• Period-order quantity: cover requirements for a selected number of periods.
• Minimum/maximum or reorder-point policies: useful for repetitive, stable, or service parts.

The classical EOQ expression is:

where 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, immediate replenishment, no quantity discounts, and no stockouts. These assumptions are often unrealistic in MRP environments, so EOQ should be treated as a policy reference rather than an automatic answer.

4. Capacity Planning and Scheduling

Material Feasibility versus Capacity Feasibility

An MRP plan can be materially feasible but operationally impossible. For example, all components may be available, yet a heat-treatment furnace may have insufficient hours. Capacity planning tests whether required work can be performed by available resources within the required periods.

For a work center, required load may be calculated as:

where Q_i is quantity of job or item i, t_i is its unit processing time, and s_j represents setup times. If available productive capacity is C_avail, a simple load ratio is:

A ratio above 1 indicates overload under the stated assumptions. A ratio below 1 does not guarantee on-time completion because variability, priorities, material shortages, and sequence constraints may still cause delay.

Capacity requirements planning is usually performed at a more detailed level than rough-cut capacity planning. Rough-cut analysis tests whether the MPS is broadly feasible at critical resources. Detailed analysis evaluates individual work centers and operations.

Scheduling Principles

Scheduling assigns timing and sequence to jobs. Important rules include earliest due date, shortest processing time, first-in–first-out, critical ratio, and setup-minimizing sequences. No rule is universally optimal. The appropriate rule depends on the performance objective: delivery reliability, flow time, setup reduction, customer priority, or schedule stability.

The critical ratio is commonly defined as:

Both numerator and denominator must use the same time unit. A value below 1 suggests that the job is behind schedule if no recovery action occurs. The ratio is a priority indicator, not a guarantee of completion.

Finite-capacity scheduling recognizes that a resource cannot process more work than its available time. Infinite-capacity MRP, by contrast, may place planned orders without fully resolving resource conflicts. ERP implementations should make clear which scheduling logic is being used.

5. Inventory Policies and Demand Planning

Inventory decisions balance service, cost, risk, and operational stability. Cycle stock supports replenishment cycles; safety stock protects against uncertainty; anticipation inventory supports predictable seasonal demand; pipeline inventory is in transit; and decoupling stock separates stages with different rates or reliability.

For continuous review with approximately normal demand during lead time, a simplified safety-stock expression is:

where z is the desired service-level standard-normal factor and σ_LT is the standard deviation of demand during lead time. If daily demand has standard deviation σ_d and lead time is constant at L days, then:

These formulas assume independent daily demand and stable statistical behavior. If lead time is variable, demand and lead-time uncertainty should be modeled jointly rather than using the constant-lead-time expression.

Reorder point under constant lead time is often represented as:

where μ_d is average demand per day. The first term is expected lead-time demand; the second protects against uncertainty. Service level must be defined carefully: cycle service level, fill rate, and on-time delivery are not identical measures.

Demand planning combines historical demand, customer orders, promotions, market intelligence, and statistical forecasts. Forecasts should be segmented by demand pattern and business importance. Intermittent demand, new products, promotions, and end-of-life items require different methods and managerial review.

Forecast error should be measured with an explicitly stated convention. Mean absolute deviation is:

where A_t is actual demand, F_t is forecast demand, and n is the number of observations. Forecast metrics support learning, but they should not be used mechanically to reward or punish planners when demand is influenced by stockouts, promotions, or deliberate commercial actions.

6. Available-to-Promise and Customer Commitments

Available-to-promise (ATP) is the quantity of uncommitted supply that can be promised to customers. It links inventory, planned production, scheduled receipts, existing orders, and customer requested dates.

In a simple discrete ATP calculation for the first period, available inventory and the next confirmed supply receipt are allocated against customer orders until the next supply event. A general conceptual expression is:

The exact calculation depends on the ERP configuration and whether ATP is calculated by period, order, product, location, or capable-to-promise logic. Capable-to-promise (CTP) goes further by checking whether additional production capacity, components, and operations can support a requested date.

ATP should not be confused with physical inventory. A warehouse may contain units, but those units may be allocated, blocked by quality, or required for a higher-priority order. Reliable ATP requires synchronized inventory, order status, MPS, procurement, production, and transportation data.

7. Sales and Operations Planning

S&OP is a cross-functional process for reconciling demand and supply at an aggregate level. It normally includes data gathering, demand review, supply review, reconciliation or pre-S&OP, and executive review. The purpose is to create one agreed plan and expose decisions that cannot be solved within a single function.

Demand plans may be expressed in product families, units, revenue, standard hours, or other aggregate measures. Supply plans evaluate workforce, overtime, subcontracting, inventory, backlog, capacity, and supplier constraints. Financial reconciliation tests whether the operational plan supports revenue, margin, cash, and working-capital objectives.

The aggregate inventory balance can be represented conceptually as:

where all quantities use a consistent unit and time period. If backorders are permitted, the model must distinguish positive inventory from unmet demand; otherwise, a negative calculated balance may be incorrectly interpreted as ordinary inventory.

S&OP is effective when assumptions are explicit, decisions are owned, exceptions are escalated, and the approved plan flows into the MPS. It fails when meetings merely report history, departments maintain competing forecasts, or executives approve plans that cannot be executed.

8. Integrated ERP Execution and Control

Planning becomes control when planned activities are converted into executable orders and performance is measured. Typical execution transactions include purchase-order release, production-order release, material issue, operation confirmation, receipt, inspection, shipment, and variance closure.

Closed-loop control requires feedback. Actual quantities, scrap, labor time, machine downtime, supplier performance, and customer demand should update the planning picture. However, automatic replanning can create nervousness: minor changes may repeatedly reschedule orders, cancel receipts, or change priorities. Planners therefore use time fences, frozen zones, firm planned orders, exception messages, and controlled change procedures.

Useful operational indicators include:

Metrics should be interpreted together. High utilization can coexist with poor delivery if queues and bottlenecks are unmanaged. Low inventory can indicate excellent flow—or unacceptable stockouts.

9. Illustrative Case: Meridian Pumps

Background

Meridian Pumps is an illustrative manufacturer of industrial water pumps. Its ERP system contains a multilevel BOM, routings for machining and assembly, supplier lead times, customer orders, forecasts, and inventory records. The company produces three pump families on shared machining centers.

Problem

Customer service frequently promises dates based on warehouse stock without considering allocations and constrained machining capacity. MRP generates component orders, but buyers report frequent rescheduling. The monthly forecast is substantially higher than actual demand for one family, while another family experiences shortages. Inventory is rising even as delivery performance declines.

Analysis

A cross-functional team audits the item master and finds three problems: an obsolete BOM revision, a supplier lead time recorded in calendar days rather than working days, and a routing that excludes a required inspection operation. Capacity analysis shows that the machining center is loaded at 118% during two weeks, while assembly has unused capacity. The ATP report also counts quality-held inventory as available.

The team separates independent demand from dependent component demand, corrects the BOM and routing through engineering change control, and establishes a weekly demand review. The MPS is revised by product family, with the constrained machining center treated as the pacing resource. Customer service uses site-specific ATP that excludes allocated and quality-held stock. CTP is used for urgent orders requiring additional machining capacity.

Outcome

The revised process reduces false promise dates and exposes the need for overtime and selective subcontracting during the peak period. Buyers receive fewer unstable signals because lead times and lot sizes are reviewed jointly with suppliers. Inventory does not immediately fall; instead, the first improvement is greater visibility of genuine shortages and excesses. After several planning cycles, obsolete purchases are reduced, delivery reliability improves, and management can evaluate the cost of additional machining capacity using evidence rather than anecdote.

Learning Points

The case demonstrates that ERP integration is a socio-technical capability. Correct calculations require accurate master data, disciplined governance, cross-functional ownership, and decision rules. ATP cannot repair an inaccurate MPS, and MRP cannot resolve a capacity bottleneck unless the planning process recognizes it.

10. Governance, Ethics, and Contemporary Developments

ERP data influences supplier awards, employee workload, customer promises, inventory investment, and financial reporting. Governance should define data ownership, approval rights, segregation of duties, audit trails, access controls, and change management. Manipulating forecasts to obtain favorable performance measures, hiding shortages, or overriding allocation rules for influential customers creates ethical and operational risk.

AI and advanced analytics can support demand sensing, anomaly detection, predictive maintenance, dynamic safety-stock recommendations, and schedule optimization. Their use requires careful validation. A machine-learning forecast trained on stockout-constrained sales may learn that low observed demand means low market demand. An optimization model may recommend infeasible schedules if setup, labor, or quality constraints are omitted. Human accountability, explainability, monitoring for bias, and controlled experimentation remain essential.

Contemporary ERP environments increasingly integrate cloud platforms, industrial Internet of Things data, digital twins, supplier portals, and event-driven planning. These technologies can shorten response time, but they also increase cybersecurity exposure, integration complexity, and dependence on data quality. A digitally connected operation still requires sound planning concepts and disciplined managerial judgment.

Best-Practice Guidelines

1. Govern BOMs, routings, lead times, calendars, and inventory records as business-critical data.
2. Keep planning levels distinct while ensuring that S&OP, MPS, MRP, capacity planning, and execution are linked.
3. Use exception management rather than allowing planners to review every transaction manually.
4. Treat bottlenecks and supplier constraints explicitly; do not assume material feasibility implies capacity feasibility.
5. Define ATP rules jointly across sales, operations, logistics, and finance.
6. Use time fences and order firming to prevent excessive schedule nervousness.
7. Segment inventory and forecasting policies by demand pattern, value, risk, and service requirement.
8. Measure outcomes such as delivery reliability and flow, not utilization or inventory alone.
9. Validate AI and analytical tools against operational reality and retain human accountability.
10. Review planning assumptions after major product, supplier, process, or market changes.

Chapter Summary

ERP for operations planning and control integrates demand, product structure, materials, capacity, scheduling, inventory, customer commitments, and financial decisions. BOMs describe what is required; routings describe how work is performed; inventory records and calendars describe what is available; MRP determines time-phased dependent requirements; capacity planning tests operational feasibility; scheduling sequences work; ATP supports credible customer promises; and S&OP aligns aggregate demand and supply.

The effectiveness of these mechanisms depends on accurate master data, appropriate assumptions, coordinated governance, and feedback from execution. Quantitative models such as MRP balance equations, safety-stock relationships, EOQ, load ratios, and forecast-error measures are useful only within their applicability conditions. Contemporary ERP and AI capabilities can improve visibility and responsiveness, but they do not remove the need for managerial judgment, ethical controls, and disciplined cross-functional processes.

Key Terms

Bill of material: Structured list of components and quantities required for an item.

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

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

Independent demand: Demand arising from customers, forecasts, or external requirements.

Master production schedule: Time-phased plan for producing specified end items.

Material requirements planning: Systematic calculation of component requirements and order timing.

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

Planned order release: Date on which a planned order should be initiated.

Lot sizing: Rule used to convert net requirements into order quantities.

Capacity requirements planning: Analysis of required work against available resource capacity.

Bottleneck: Resource whose constrained capacity limits system throughput.

Safety stock: Inventory held to protect against uncertainty.

Reorder point: Inventory position at which replenishment should be initiated.

Available-to-promise: Uncommitted supply that can be allocated to customer orders.

Capable-to-promise: Promise calculation that considers production and resource capability.

Sales and operations planning: Cross-functional process aligning aggregate demand and supply.

Time fence: Planning boundary restricting changes within a defined horizon.

Schedule nervousness: Frequent, disruptive changes to planned orders and schedules.

Master data governance: Defined ownership and controls for critical planning data.

Review Questions

Short Answer Questions

1. What is the difference between a bill of material and a routing?
2. Why is MRP described as a time-phased planning method?
3. Distinguish material feasibility from capacity feasibility.
4. What does available-to-promise measure?
5. Why are time fences used in ERP planning?

Long Answer Questions

1. Explain how S&OP, the MPS, MRP, capacity planning, and scheduling form an integrated hierarchy.
2. Discuss the assumptions and limitations of the EOQ and safety-stock formulas presented in this chapter.
3. Explain how inaccurate BOMs, routings, and lead times affect operational and financial performance.
4. Compare lot-for-lot, fixed-order-quantity, and period-order-quantity policies.
5. Evaluate the managerial and ethical requirements for using AI in ERP planning.

Analytical / Application Questions

1. An item requires three components per finished unit. The MPS calls for 80 units in week 4 and 60 in week 5. There are 50 components on hand, no scheduled receipts, lot-for-lot ordering, and a two-week lead time. Prepare the component MRP record and identify planned release weeks.
2. A work center has 360 productive minutes available in a day. Three jobs require 80 units at 2 minutes each, 40 units at 3 minutes each, and one setup of 45 minutes. Calculate the load and determine whether the resource is overloaded.
3. A company has adequate component inventory but a bottleneck machine loaded at 125%. Recommend changes to the MPS, sourcing, scheduling, or capacity plan, and explain the trade-offs.

Multiple Choice Questions with Answers

Question 1

Which ERP artifact specifies the sequence of manufacturing operations?

A. Bill of material

B. Routing

C. Forecast error report

D. Customer credit record

Correct Answer: B. Routing

Question 2

An end item requires 4 units of component X. If the MPS requires 75 end items, what is the gross requirement for X before inventory offsets?

A. 71 units

B. 79 units

C. 300 units

D. 375 units

Correct Answer: C. 300 units

Question 3

In MRP, a planned order release is generally determined by:

A. Adding lead time to the required receipt date

B. Subtracting lead time from the planned receipt date

C. Ignoring the planned receipt date

D. Replacing the gross requirement with safety stock

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

Question 4

A work center requires 480 minutes and has 400 minutes of available productive capacity. What is its load ratio?

A. 0.83

B. 1.00

C. 1.20

D. 1.80

Correct Answer: C. 1.20

Question 5

Which demand is normally derived from the production plan for a parent item?

A. Independent demand

B. Dependent demand

C. Seasonal demand only

D. Capacity demand only

Correct Answer: B. Dependent demand

Question 6

Under the classical EOQ model, which variable represents annual ordering or setup cost per order?

A. D

B. S

C. H

D. Q

Correct Answer: B. S

Question 7

A customer promise calculation that checks additional production resources and components is called:

A. Cycle counting

B. Capable-to-promise

C. Lot-for-lot planning

D. Aggregate forecasting

Correct Answer: B. Capable-to-promise

Question 8

Which condition most directly indicates that an MRP plan may be operationally infeasible despite adequate materials?

A. A corrected item description

B. A work center load above available capacity

C. A lower forecast error

D. An approved customer order

Correct Answer: B. A work center load above available capacity

Question 9

In the simplified safety-stock formula SS = z × σ_LT, what does z represent?

A. Average daily demand

B. Lead time in days

C. A service-level standard-normal factor

D. Annual holding cost

Correct Answer: C. A service-level standard-normal factor

Question 10

The primary purpose of S&OP is to:

A. Sequence every job on every machine

B. Reconcile aggregate demand and supply across functions

C. Replace all item-level inventory records

D. Calculate only supplier invoice totals

Correct Answer: B. Reconcile aggregate demand and supply across functions