Materials Planning and Demand Management

Introduction

Materials planning is the systematic process of determining what materials are required, in what quantities, and at what times so that production and customer-service objectives can be achieved. It connects market demand with purchasing, inventory, production, warehousing, suppliers, and financial control. In procurement and materials management, planning is not simply a clerical activity. It is a decision system that balances customer responsiveness, working capital, capacity, supplier reliability, and operational risk.

A central distinction is between independent demand and dependent demand. Independent demand originates outside the production system, such as customer orders or market demand for finished products. Dependent demand is derived from the demand for another item, such as the requirement for wheels resulting from the planned production of bicycles. Independent demand is generally forecast; dependent demand is calculated from a bill of materials (BOM), inventory records, and production schedules.

Materials planning has evolved from simple reorder systems to integrated enterprise planning. Forecasts and aggregate plans establish broad requirements. The master production schedule (MPS) translates these plans into specific end-item schedules. Material requirements planning (MRP) explodes end-item requirements into component and raw-material requirements. MRP II adds capacity, finance, and other resources, while enterprise resource planning (ERP) integrates these decisions across the organization.

Learning Objectives

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

1. Distinguish independent and dependent demand and explain their planning implications.
2. Apply basic qualitative and quantitative forecasting methods.
3. Explain aggregate planning and its relationship with the MPS.
4. Construct and interpret a bill of materials.
5. Prepare a basic MRP record using gross requirements, scheduled receipts, projected available balance, and planned order releases.
6. Compare MRP, MRP II, and ERP.
7. Evaluate capacity limitations, data-quality requirements, implementation risks, and managerial trade-offs.

1. Demand in the Supply Chain

Demand is the quantity of a product or service that customers are willing and able to purchase during a specified period. It may be observed as actual sales, customer orders, forecasts, or requirements generated by another production item.

Independent and dependent demand

A finished laptop has independent demand. Its keyboard, battery, memory module, and packaging have dependent demand when they are consumed in laptop assembly. A component may have both forms of demand: a motor used in an internally assembled product has dependent demand, while the same motor sold as a replacement part has independent demand.

Demand management includes forecasting, order promising, promotion coordination, demand sensing, allocation during shortages, and communication with sales and customers. Good demand management does not mean accepting every forecast as fact. It means creating a disciplined process through which assumptions, uncertainty, and changes are visible.

2. Forecasting for Materials Planning

A forecast is a structured estimate of future demand. Forecasts support decisions about aggregate capacity, supplier commitments, workforce, inventory, and cash. They do not eliminate uncertainty; they make assumptions explicit.

Forecasting approaches

Qualitative methods rely on expert judgement. They include executive opinion, sales-force composite estimates, market research, customer surveys, and the Delphi method. They are useful when historical data are absent, products are new, or structural market changes make old data unreliable.

Quantitative methods use historical observations. Common methods include naïve forecasting, moving averages, weighted moving averages, exponential smoothing, regression, and seasonal models.

The naïve forecast for the next period equals the latest observed demand:

where F_t+1 is the forecast for period t+1 and A_t is actual demand in period t. It is simple and often useful as a benchmark.

A simple moving average of n periods is:

The method assumes that recent observations are representative and gives equal weight to all included periods. It is inappropriate when strong trend or seasonality exists unless the data are adjusted.

A weighted moving average is:

where weights w_i are non-negative and must sum to 1. Larger weights may be assigned to recent observations.

Exponential smoothing is commonly expressed as:

where 0 ≤ α ≤ 1, A_t is actual demand, and F_t is the previous forecast. A high α responds rapidly to changes but may overreact to random variation; a low α produces a smoother forecast but responds slowly to genuine shifts.

Forecast error for a period is:

Important accuracy measures include mean absolute deviation (MAD), mean squared error (MSE), and mean absolute percentage error (MAPE):

Here, n is the number of evaluated periods. MAPE should not be used when actual demand is zero, and it can distort comparisons when actual demand is very small. Error measures should be interpreted alongside bias. A forecast with persistent positive errors systematically underforecasts demand; persistent negative errors indicate overforecasting.

Worked forecasting example

Demand for a spare part over three months was 100, 120, and 110 units. A three-period moving-average forecast for month 4 is:

F₄ = (100 + 120 + 110) ÷ 3 = 110 units.

If exponential smoothing uses α = 0.30 and the previous forecast for month 3 was 105 units, then:

F₄ = 0.30(110) + 0.70(105) = 33 + 73.5 = 106.5 units.

The organization may round this to 107 units for planning, while retaining the unrounded value in analytical records. The moving average gives 110 because all observations receive equal weight; exponential smoothing gives 106.5 because the prior forecast influences the result.

3. Aggregate Planning

Aggregate planning establishes medium-term production, inventory, workforce, subcontracting, and backlog policies. The planning horizon is commonly several months to approximately two years, although practice varies by industry. The plan uses product families rather than individual stock-keeping units.

The principal strategies are:

• Level strategy: maintain relatively stable production and workforce while using inventory or backlog to absorb demand variation.
• Chase strategy: vary production or workforce to follow demand.
• Mixed strategy: combine regular production, overtime, inventory, subcontracting, temporary labour, and controlled backlog.

The choice depends on hiring and dismissal costs, storage cost, service requirements, labour agreements, supplier flexibility, product perishability, and capacity constraints. A low-cost aggregate plan may be unacceptable if it causes late delivery or excessive employee turnover.

A simplified aggregate-planning cost function can be represented as:

This is a conceptual identity rather than a universal optimization formula. Each organization must define its cost categories, constraints, and units consistently. A linear-programming model may minimize this cost subject to demand balance, workforce, inventory, production, and capacity constraints.

The aggregate plan is not the final purchasing schedule. It provides constraints and targets for the MPS. For example, an aggregate plan may authorize production of 10,000 units of a product family in March; the MPS then specifies which models, configurations, and delivery dates make up that quantity.

4. Master Production Scheduling

The MPS is a time-phased plan for producing or procuring specific end items. It converts aggregate plans, actual orders, forecasts, inventory policies, and available capacity into a schedule. The MPS is often expressed in weekly time buckets, although daily buckets may be required for short lead-time operations.

An effective MPS should:

• reflect the aggregate plan;
• consider customer due dates and available inventory;
• respect production and supplier capacity;
• use realistic lot sizes and lead times;
• be stable enough for execution but responsive to material changes;
• provide a controlled basis for MRP.

The MPS is not identical to a sales forecast. A forecast describes expected demand; the MPS states what the organization intends and is able to produce. The difference is important when demand exceeds capacity.

A simplified projected available balance for an end item is:

where PAB_t is projected available balance in period t, MPS_t is the MPS receipt, F_t is forecast demand, and C_t is customer-order demand. The use of max(F_t,C_t) avoids adding forecast and orders when orders are already included in the forecast; organizations may use a different consumption rule depending on their planning design. Beginning inventory, safety stock, and available-to-promise logic must also be defined.

5. Bills of Materials

A bill of materials is a structured record of all components, subassemblies, raw materials, and quantities required to make one unit of a parent item. It may also include scrap factors, engineering revisions, effectivity dates, substitutes, and issue methods.

A single-level BOM lists immediate components. A multilevel BOM shows the complete product structure through several levels. A modular BOM groups common subassemblies, supporting product variety and postponement. A planning BOM may represent a product family using percentages or options, whereas a manufacturing BOM specifies what is actually assembled.

Consider a product P requiring 2 units of A and 3 units of B. Each A requires 4 units of C, and each B requires 2 units of C. For one P:

• A requirement = 2;
• B requirement = 3;
• C requirement through A = 2 × 4 = 8;
• C requirement through B = 3 × 2 = 6;
• total C requirement = 14 units.

The calculation demonstrates the principle of BOM explosion: requirements at lower levels are multiplied by the usage quantity at each parent level and summed when a component is used in multiple branches.

BOM accuracy is strategically important. An incorrect quantity creates systematic shortages or excesses; an obsolete revision can cause quality failures; an omitted component can stop production even when the principal material is available. Engineering change control, revision status, unit-of-measure discipline, and effectivity dates are therefore essential.

6. Material Requirements Planning

MRP is a time-phased method for calculating dependent material requirements. It uses four primary inputs:

1. the MPS or other parent-item requirements;
2. the BOM;
3. inventory records;
4. planning parameters such as lead time, lot size, safety stock, and scheduled receipts.

The basic logic is: explode gross requirements, subtract available inventory and scheduled receipts, calculate net requirements, apply lot-sizing rules, and offset planned receipts by lead time to determine planned releases.

For period t, a general net-requirement calculation can be written as:

where NR_t is net requirement, GR_t is gross requirement, SS_t is desired safety stock, PAB_t-1 is prior projected available balance, and SR_t is scheduled receipt. This assumes that scheduled receipts are usable in the stated period and that units are consistent.

After lot sizing, the planned order receipt PORc_t must be at least the net requirement. With a lot-for-lot rule:

With a fixed lot size Q, the receipt may be:

where ceil means rounding upward to the next whole lot. If lead time is L periods, the planned order release is offset earlier:

These formulas assume deterministic lead time. In practice, safety stock, supplier reliability, yield loss, and calendar constraints may require more sophisticated policies.

MRP worked example

A component has beginning inventory of 40 units. Gross requirements are 30 units in week 1 and 50 units in week 2. A scheduled receipt of 20 units arrives in week 2. There is no safety stock, the lot-sizing rule is lot-for-lot, and lead time is one week.

At the end of week 1, inventory is 40 − 30 = 10. In week 2, available supply before a planned receipt is 10 + 20 − 50 = −20, so a net requirement of 20 exists. Because the lead time is one week, the order must be released in week 1. If the lot size were 50 rather than lot-for-lot, the planned receipt would be 50 and projected ending inventory would be 30 units.

7. Lot Sizing, Safety Stock, and Planning Parameters

MRP output depends strongly on planning parameters. Common lot-sizing methods include:

• Lot-for-lot: order exactly the net requirement; it minimizes cycle inventory but may create frequent orders and setup costs.
• Fixed-order quantity: order a standard quantity; it may simplify purchasing or production but create excess inventory.
• Economic order quantity: balances ordering and holding costs under restrictive assumptions.
• Period-order quantity: covers requirements for a specified number of periods.
• Part-period balancing: seeks a practical balance between setup and holding costs.

The classical economic order quantity is:

where D is annual demand in units, S is ordering or setup cost per order, and H is annual holding cost per unit. The model assumes relatively constant demand, known costs, instantaneous replenishment, no quantity discounts, and no shortages. These assumptions often fail in complex MRP environments, so the result should be treated as a benchmark rather than an automatic policy.

Safety stock protects against demand or supply uncertainty. A simple reorder-point relationship is:

where d is average demand per period, L is lead time in periods, and SS is safety stock. Under a simple demand-variability model with constant lead time:

where z is the desired service-level factor and σ_d is the standard deviation of demand per period. This formula assumes independent demand variation and a specified service interpretation. If both demand and lead time vary, the variance model must include both sources and their relationship.

8. MRP II and ERP

MRP focuses primarily on material timing and quantity. MRP II extends this logic to manufacturing resources, including labour, machines, capacity, purchasing, finance, and feedback from execution. It is often described as a closed-loop planning system: plans are generated, capacity is checked, execution results are reported, and plans are revised.

ERP integrates planning and transaction processing across functions such as procurement, inventory, production, sales, finance, quality, maintenance, and human resources. ERP does not replace managerial judgement. It provides a common database, workflow, controls, and visibility, but poor master data or poor processes can be propagated faster through an integrated system.

Modern cloud platforms, advanced planning systems, supplier portals, and analytics increasingly connect ERP with external supply-chain data. Artificial intelligence may improve demand sensing, anomaly detection, forecast segmentation, and parameter recommendations. However, AI-generated forecasts must be governed through data-quality checks, explainability, human review, bias monitoring, and clear accountability. An algorithm cannot resolve an incorrect BOM, an unrecorded supplier constraint, or a strategically impossible service promise.

9. Capacity Considerations and Feasibility

A material plan is useful only if it can be executed. Capacity exists at several levels:

• supplier capacity and component availability;
• receiving, storage, and handling capacity;
• machine and tooling capacity;
• labour skills and working hours;
• warehouse, transport, and distribution capacity;
• cash and credit capacity.

MRP may produce a mathematically valid plan that overloads a work centre. Capacity requirements planning (CRP) converts planned and released orders into required hours by work centre and compares them with available capacity. A simplified utilization measure is:

A value above 1, or above 100%, signals overload under the stated assumptions. Available capacity must account for working time, breaks, maintenance, planned downtime, efficiency, and yield. Capacity requirements may be expressed in machine-hours, labour-hours, kilograms, pallet positions, or supplier units; the unit must match the resource being evaluated.

When capacity is insufficient, managers may alter the MPS, authorize overtime, subcontract, shift demand, change lot sizes, qualify another supplier, redesign the product, or allocate scarce materials according to explicit priorities. Shortage allocation should be governed by customer commitments, contractual obligations, safety or public-interest considerations, profitability, and fairness—not merely by the loudest internal request.

10. Integrated Planning Process

A disciplined planning cycle usually follows these steps:

1. Collect demand signals, forecasts, orders, promotions, returns, and market intelligence.
2. Review data quality, abnormal observations, forecast bias, and assumptions.
3. Develop or revise the aggregate plan by product family.
4. Translate the aggregate plan into an MPS for end items.
5. Validate rough-cut capacity and key supplier constraints.
6. Explode the MPS through current BOMs.
7. Net requirements against inventory, scheduled receipts, safety stock, and open orders.
8. Apply lot-sizing and lead-time offsets.
9. Run capacity and feasibility checks.
10. Release, communicate, and monitor purchase and production orders.
11. Measure performance and replan using controlled change rules.

This process should be cross-functional. Sales and operations planning provides demand and commercial assumptions; procurement provides supplier capability and lead-time information; production provides capacity and yield data; finance tests the working-capital consequences; engineering controls product structures and revisions.

Illustrative Case: Northstar Appliances

Background

Northstar Appliances manufactures countertop mixers. The final product, Model M, has independent demand from retailers. Each mixer requires one motor assembly, one housing, and one control board. The motor assembly requires two bearings. The company uses weekly MRP and has a one-week supplier lead time for bearings.

Problem

Retail demand has increased, but production frequently reports missing bearings even though total monthly bearing inventory appears adequate. Procurement suspects that the problem is not total inventory but timing and inaccurate records.

Analysis

The planning team audits the BOM and discovers that the bearing quantity was recorded as one per motor instead of two. It also finds that a scheduled receipt of 1,000 bearings was shown in week 3 although the supplier had confirmed delivery in week 4. The MPS calls for 400 mixers in week 3 and 500 in week 4.

Bearing gross requirements are therefore 800 in week 3 and 1,000 in week 4. Beginning inventory is 600 bearings. With the corrected BOM, week 3 projected inventory before a planned receipt is 600 − 800 = −200, creating a 200-unit net requirement. The week-3 release must occur in week 2 because of the one-week lead time. The receipt planned for week 3 cannot be assumed to cover week 3 if the supplier has confirmed week 4 delivery.

Approach and solution

Northstar corrects the BOM, confirms supplier dates through the supplier portal, and introduces an exception report for negative projected balances within the frozen production window. It also separates independent demand for replacement motors from dependent demand for mixers. A capacity review confirms that the bearing supplier can provide the additional 200 units, but expedited freight is required.

Outcome

The immediate shortage is avoided through an approved expedited order. Longer-term performance improves because BOM accuracy, schedule-date integrity, and exception ownership are monitored together. Procurement no longer judges material security solely by aggregate inventory value.

Learning points

1. Dependent demand calculations are only as reliable as the parent schedule and BOM.
2. Timing errors can create shortages despite adequate total inventory.
3. ERP visibility is valuable only when master and transaction data are accurate.
4. Exception management should focus attention on items that threaten execution.
5. Expediting is a short-term response, not a substitute for correcting planning parameters.

Challenges, Governance, and Best Practices

Common implementation challenges include forecast volatility, nervousness caused by frequent schedule changes, inaccurate inventory balances, obsolete BOM revisions, unrealistic lead times, inappropriate safety stocks, supplier minimum quantities, and organizational resistance. Excessive system messages can also overwhelm planners, causing important exceptions to be missed.

Best practices include:

• establish ownership for every master-data field;
• cycle-count high-value and high-risk items;
• measure supplier lead-time reliability rather than using nominal lead time alone;
• freeze or stabilize near-term schedules while defining controlled exception rules;
• segment items by value, variability, criticality, and supply risk;
• distinguish forecast error from sales-order cancellation and promotion effects;
• use capacity and supplier checks before releasing commitments;
• review forecast bias, service level, inventory turns, schedule adherence, and expedite frequency;
• maintain audit trails for BOM and planning-parameter changes;
• protect personal, commercial, and supplier data in integrated systems;
• train users in both system transactions and the operational meaning of the data.

Ethical procurement and planning require transparent allocation rules during shortages, avoidance of supplier manipulation, respect for contractual commitments, and prevention of discriminatory or opaque algorithmic decisions. Regulatory requirements may apply to traceability, product safety, export controls, environmental reporting, records retention, and data protection. Materials planning therefore has operational, financial, legal, and social consequences.

Chapter Summary

Materials planning links demand, production, procurement, inventory, capacity, and finance. Independent demand is externally generated and generally forecast, whereas dependent demand is calculated from parent requirements through a BOM. Forecasting methods range from managerial judgement to moving averages and exponential smoothing; accuracy measures must be interpreted alongside bias and data limitations.

Aggregate planning establishes medium-term policies for product families. The MPS converts those policies into specific end-item schedules. MRP then uses the MPS, BOM, inventory records, scheduled receipts, lot sizes, safety stocks, and lead times to calculate planned material receipts and releases. MRP II extends planning to manufacturing resources and feedback, while ERP integrates planning and transactions across the enterprise.

Effective planning requires capacity validation, accurate master data, controlled engineering changes, reliable supplier information, and cross-functional governance. Technology and AI can improve visibility and analysis, but they cannot compensate for poor data, unrealistic assumptions, or weak accountability. The professional materials manager must therefore combine quantitative planning with judgement, communication, ethical governance, and continuous improvement.

Key Terms

Aggregate planning: Medium-term planning of production, workforce, inventory, subcontracting, and backlog by product family.

Bill of materials (BOM): Structured listing of components and quantities required to make a parent item.

Capacity requirements planning (CRP): Process of comparing resource capacity with capacity required by planned orders.

Dependent demand: Demand calculated from the requirements of another item.

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

Enterprise resource planning (ERP): Integrated system connecting enterprise processes and data.

Exponential smoothing: Forecasting method that weights recent actual demand and the previous forecast.

Forecast bias: Persistent tendency of forecasts to overestimate or underestimate demand.

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

Independent demand: Demand originating from external customers or markets.

Lot-for-lot: Lot-sizing rule that plans a receipt equal to the net requirement.

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

Material requirements planning (MRP): System for calculating time-phased dependent material requirements.

MRP II: Extension of MRP incorporating capacity, manufacturing resources, finance, and feedback.

Net requirement: Additional quantity needed after considering available inventory and scheduled receipts.

Projected available balance: Expected inventory position after requirements and planned supplies.

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

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

Time-phasing: Placing requirements, receipts, and releases into specific time periods.

Review Questions

Short Answer Questions

1. What is the difference between independent and dependent demand?
2. State two assumptions of the simple moving-average method.
3. What are the principal inputs to an MRP system?
4. Why is a BOM revision-control process important?
5. Distinguish MRP from ERP.

Long Answer Questions

1. Explain how aggregate planning, the MPS, and MRP form an integrated planning hierarchy.
2. Compare level, chase, and mixed aggregate-planning strategies, including their operational trade-offs.
3. Explain BOM explosion and illustrate how a multilevel BOM generates component requirements.
4. Discuss the role of lot sizing, safety stock, and lead time in MRP.
5. Evaluate the benefits and risks of implementing ERP for procurement and materials management.

Analytical / Application Questions

1. A product requires three units of component A and two units of component B. Each A requires four units of C, while each B requires three units of C. Calculate the quantity of C required for 100 finished products and explain your method.
2. Beginning inventory is 70 units, gross requirements are 50 units in week 1 and 40 units in week 2, and a scheduled receipt of 10 units arrives in week 2. Using lot-for-lot sizing and zero safety stock, calculate the week-2 net requirement and state when the order should be released if lead time is one week.
3. A supplier has adequate monthly capacity but repeatedly misses weekly requirements. Diagnose possible planning and data causes and propose a cross-functional corrective-action plan.

Multiple Choice Questions with Answers

Question 1

Which type of demand is normally calculated through a bill of materials?

A. Independent demand

B. Dependent demand

C. Promotional demand

D. Seasonal demand

Correct Answer: B. Dependent demand

Question 2

In exponential smoothing, what does α represent?

A. The number of periods in the moving average

B. The supplier lead time

C. The smoothing constant between 0 and 1

D. The planned order quantity

Correct Answer: C. The smoothing constant between 0 and 1

Question 3

A product requires 2 units of A and 3 units of B. Each A requires 4 units of C and each B requires 2 units of C. How many C units are required per product?

A. 10

B. 12

C. 14

D. 16

Correct Answer: C. 14

Question 4

Which document specifies the time-phased plan for producing specific end items?

A. Master production schedule

B. Supplier invoice

C. Receiving report

D. Cycle-count sheet

Correct Answer: A. Master production schedule

Question 5

Under lot-for-lot sizing, the planned order receipt is generally equal to the:

A. Annual demand

B. Net requirement

C. Safety stock

D. Fixed supplier lot

Correct Answer: B. Net requirement

Question 6

If a component has a one-week lead time and a planned receipt is required in week 4, when should the planned order normally be released?

A. Week 1

B. Week 2

C. Week 3

D. Week 4

Correct Answer: C. Week 3

Question 7

Which system extends MRP by incorporating manufacturing resources, capacity, and feedback?

A. MRP II

B. POS

C. EDI

D. WMS

Correct Answer: A. MRP II

Question 8

A capacity utilization value greater than 1 indicates that:

A. Inventory is obsolete

B. Required capacity exceeds available capacity

C. Demand is entirely independent

D. The BOM has no components

Correct Answer: B. Required capacity exceeds available capacity

Question 9

Which forecast accuracy measure should not be used directly when actual demand is zero?

A. MAD

B. MSE

C. MAPE

D. Forecast error

Correct Answer: C. MAPE

Question 10

What is a major risk of using ERP with inaccurate master data?

A. The system automatically corrects all BOM errors

B. Poor data can propagate through integrated processes

C. Capacity constraints disappear

D. Forecast uncertainty becomes zero

Correct Answer: B. Poor data can propagate through integrated processes