Materials Requirements and Production Inventory

Introduction

Production inventory is the stock of materials, components, subassemblies, work-in-process and finished goods required to transform inputs into customer-ready products. Unlike independent-demand inventory, which is forecast directly from market demand, most component demand is dependent demand: it is calculated from the production plan and the product structure. Effective materials planning therefore links customer requirements, the master production schedule, bills of materials, inventory records, purchasing, shop-floor capacity and supplier performance.

Materials requirements planning (MRP) provides a time-phased method for determining what materials are needed, how many are needed and when orders should be released. Modern organisations commonly combine MRP with enterprise resource planning (ERP), finite-capacity scheduling, lean practices and supplier collaboration. No single method is universally superior. MRP is valuable where products are complex and demand is variable; just-in-time (JIT) and Kanban are powerful where processes are stable, lead times are short and quality is reliable.

Learning Objectives

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

1. Interpret a bill of materials and distinguish independent from dependent demand.
2. Explain the relationship between the master production schedule, MRP and capacity planning.
3. Calculate gross requirements, net requirements, planned receipts and planned order releases.
4. Compare lot-sizing methods and identify their operational consequences.
5. Explain JIT, Kanban, lean inventory and the theory of constraints.
6. Apply these concepts to production and procurement decisions while recognising their limitations.

1. Product Structure and Bills of Materials

A bill of materials (BOM) is a structured list of all components, subassemblies, raw materials and quantities required to make one unit of a parent item. A single-level BOM lists immediate components; a multi-level or indented BOM shows the complete product structure. The top-level finished product is normally level 0, its direct components level 1, and so forth.

For example, one training kit may require:

The low-level code records the lowest level at which an item occurs. It prevents the planning system from calculating the same component prematurely when that component appears in more than one branch of the BOM.

A BOM must also identify units of measure, engineering revisions, scrap or yield factors, substitutes, effectivity dates and phantom assemblies. A phantom assembly is a logical grouping used for planning or design but not normally stocked as a separate item. BOM accuracy is essential: an incorrect quantity or obsolete revision creates shortages, excess inventory, rework and unreliable purchasing signals.

Dependent and Independent Demand

Independent demand originates outside the production system, such as customer orders or a forecast for finished goods. Dependent demand is derived from another item’s requirements. If 500 finished products each require four screws, gross screw demand is 2,000 screws before considering inventory, scheduled receipts or scrap.

This distinction matters because dependent demand should normally be calculated from a production plan rather than forecast separately. Forecasting both finished goods and all components can create inconsistency and unnecessary safety stock.

2. The Master Production Schedule

The master production schedule (MPS) translates aggregate plans and customer requirements into specific quantities of finished products, by time period. It is a principal input to MRP. An MPS should be realistic, stable enough for execution and detailed enough to generate component requirements.

An MPS typically contains:

• forecast demand and confirmed customer orders;
• available inventory and planned ending inventory;
• the production quantity for each time bucket;
• the available-to-promise quantity;
• a time fence separating fixed, moderately flexible and open planning periods.

The MPS is not simply a sales forecast. It is a commitment or proposed commitment to produce particular items at particular times. A master scheduler must reconcile market demand with labour, machines, suppliers, storage and financial constraints.

Available-to-Promise

Available-to-promise (ATP) indicates the quantity that can still be promised to customers without violating the MPS. In a basic case, for the first MPS period:

For later periods, ATP is generally the MPS receipt less orders booked from that receipt period up to the period before the next MPS receipt. The calculation depends on the organisation’s order-allocation rules and should not be confused with physical inventory alone.

3. Material Requirements Planning

MRP is a computer-supported planning process that uses the MPS, BOM, inventory records and lead times to calculate time-phased material requirements. Its central questions are:

1. What is required?
2. How much is required after existing supply is considered?
3. When must an order be received?
4. When must that order be released, considering lead time?

MRP Inputs and Outputs

Typical outputs include planned order releases, planned order receipts, rescheduling messages, cancellation messages, exception reports and projected available balances.

The MRP Record

For each item and time period, an MRP record commonly includes gross requirements, scheduled receipts, projected available balance, net requirements, planned order receipts and planned order releases.

The basic projected balance relationship is:

where PAB_t is projected available balance at the end of period t, SR_t is the scheduled receipt, POR_t is the planned order receipt and GR_t is gross requirement. The equation assumes all receipts are available in the stated period and ignores losses unless they are incorporated into requirements or yield factors.

A net requirement exists when projected supply is insufficient to meet gross requirements and any required safety stock. A general expression is:

where NR_t is net requirement and SS_t is desired safety stock. If a lot-for-lot rule is used, the planned receipt equals the net requirement. With a fixed lot size, the receipt is rounded upward to the next permitted multiple.

If an item’s lead time is two weeks, a planned receipt in week 6 produces a planned release in week 4, subject to calendars, order-processing time and supplier constraints.

Worked Example: Exploding a BOM

Assume an MPS requires 100 kits in week 5. Each kit requires 2 modules. Each module requires 3 sensors. Therefore:

• Gross requirement for modules in week 5 = 100 × 2 = 200 modules.
• Gross requirement for sensors = 200 × 3 = 600 sensors.

Suppose 80 modules are on hand, 40 modules are already scheduled to arrive in week 5, and a safety stock of 20 modules is required. The module net requirement is:

Under lot-for-lot planning, 100 modules are planned for receipt in week 5. If the module lead time is one week, the planned release is in week 4.

For sensors, suppose 150 are on hand, no scheduled receipt exists and safety stock is 50. The sensor net requirement is:

If sensors are purchased in cartons of 100, the planned receipt is 500 sensors. If the supplier’s lead time is three weeks, the order should be released in week 2.

The example demonstrates that component demand is generated by the planned production quantity and BOM quantities, not by an independent forecast of sensors.

4. Lot-Sizing Decisions

Lot sizing determines the quantity ordered or produced when a net requirement occurs. The choice affects ordering cost, setup cost, inventory, obsolescence, transport and flexibility.

For relatively stable independent demand, the basic economic order quantity is:

where Q* is the order quantity in units, D is annual demand in units per year, S is ordering or setup cost per order, and H is annual holding cost per unit. The model assumes constant demand, constant lead time, immediate replenishment, no shortages, and constant unit price. It is less appropriate for lumpy dependent demand, frequent engineering changes or severe capacity constraints.

For example, if annual demand is 10,000 units, ordering cost is $40 per order and annual holding cost is $2 per unit:

This is a planning estimate, not an automatic order quantity. Supplier minimums, pallet quantities, cash constraints and actual setup economics must also be considered.

5. Capacity Requirements and Feasibility

MRP answers whether and when materials are needed; it does not automatically prove that machines, labour, tools or suppliers can provide them. Capacity requirements planning (CRP) converts planned orders into time-phased workload by work centre.

A simplified workload calculation is:

where Load_w,t is the workload at work centre w in period t, and standard hours_i,w is the processing time for item i at that work centre. Capacity should be expressed in the same time units as load. If a work centre has 400 available labour-hours but planned work requires 460 hours, the 60-hour overload requires rescheduling, overtime, subcontracting, alternate routing or a reduced production commitment.

Available capacity must reflect breaks, maintenance, absenteeism, changeovers, quality losses and realistic efficiency. Infinite-capacity MRP can produce mathematically correct material dates that are operationally impossible. Feedback between MPS, MRP, CRP and procurement is therefore essential.

6. Just-in-Time, Kanban and Lean Inventory

Just-in-time (JIT) is an operating philosophy in which materials and products are supplied in the required quantity, at the required time and with minimal waste. JIT is not merely “zero inventory”; it seeks to expose and remove causes of delay, defects, overproduction, excess movement, waiting and unnecessary processing.

The seven commonly recognised wastes are overproduction, waiting, transport, overprocessing, inventory, motion and defects. Some organisations add underused human capability. Lean improvement uses methods such as standard work, 5S, setup reduction, preventive maintenance, visual management, value-stream mapping and root-cause analysis.

Kanban is a visual, demand-driven control mechanism. A downstream process withdraws items from a defined supermarket or point of supply; that withdrawal authorises replenishment by the upstream process. A card, electronic signal, container or barcode may serve as the kanban signal.

A commonly used sizing relationship is:

where n is the required number of containers or kanban cards, D is demand per time unit, L is replenishment lead time in the same time unit, s is the safety factor expressed as a decimal, and C is the quantity per container. The result is rounded up to a whole number. This relationship assumes relatively stable demand, reliable replenishment and a defined container quantity; it is not a substitute for analysing variability and disruption risk.

For demand of 240 units per day, a lead time of 0.5 day, a 10% allowance and 30 units per container:

Therefore, five containers are required under the stated assumptions.

JIT reduces inventory and reveals problems, but it increases exposure to unreliable suppliers, transport disruption, equipment failure and demand volatility. Resilience may require strategic buffers, multiple sources, contingency capacity and differentiated inventory policies.

7. Theory of Constraints

The theory of constraints (TOC) views an organisation as a system whose performance is limited by one or a small number of constraints. A constraint may be a machine, labour skill, policy, supplier, market limitation or information bottleneck.

The five focusing steps are:

1. Identify the system’s constraint.
2. Exploit it by ensuring that its scarce time is used productively.
3. Subordinate other activities to the constraint’s requirements.
4. Elevate the constraint by adding capacity or changing the process.
5. If the constraint moves, return to step one without allowing inertia to become the next constraint.

TOC distinguishes local efficiency from total system performance. Keeping every machine busy can increase work-in-process before a bottleneck and lengthen lead time. In production, the drum-buffer-rope concept uses the constraint as the drum setting the pace, a buffer protecting it from disruption and a rope controlling the release of work into the system.

A useful operational measure is throughput contribution. In a simplified form:

The measure is used for short-term constraint decisions and should not replace full cost, quality, safety and strategic analysis.

8. Integrated Application: Illustrative Case

Background

A fictional manufacturer, Northstar Appliances, produces compact water pumps. Demand for finished pumps varies weekly. The pump contains a motor, housing, seal kit and control module. The control module is purchased from one supplier and the assembly line has a limited testing station.

Problem

Northstar frequently experiences shortages of seals and control modules, while holding excess motors. Expedites are expensive, and the testing station is overloaded during month-end production. Management initially proposes increasing all safety stocks.

Analysis

The planning team audits the BOM and discovers that the seal quantity was recorded as one per pump although the current design requires two. Inventory records also include 300 motors that are reserved for service parts but appear available to production. MRP therefore understated seal requirements and overstated motor availability. CRP shows that the testing station is the system constraint, operating at 108% of available weekly capacity.

Approach and Solution

Northstar first corrects the BOM, inventory status and engineering revision controls. The MPS is then levelled to reduce end-of-month peaks. MRP uses lot-for-lot planning for seals because their demand is lumpy and shelf life is limited, while a supplier carton quantity is used for control modules. The testing station is protected with a small controlled buffer, and production release is subordinated to the station’s feasible schedule.

A Kanban loop is introduced for commonly used seals between the warehouse and assembly line. The control-module supplier receives a rolling forecast but firm near-term schedules. Procurement also qualifies a second source because the module is a supply-risk item. Setup reduction and preventive maintenance increase testing capacity without immediately purchasing another station.

Outcome

Shortages decline because requirements and records are accurate. Excess motor inventory is reclassified rather than treated as freely available supply. The levelled schedule reduces overtime, while the constraint-focused plan improves completed output more effectively than raising every inventory target.

Learning Points

The case illustrates that inventory problems may originate in data accuracy, schedule instability, capacity imbalance or supplier risk. MRP, lean and TOC are complementary when used selectively: MRP plans material timing, Kanban controls repetitive replenishment, and TOC directs attention to the system constraint.

9. Implementation, Governance and Technology

Successful implementation requires disciplined master data governance. Organisations should assign ownership for BOMs, item codes, lead times, supplier records, lot sizes, safety stocks and inventory transactions. Engineering changes need formal approval and effective dates. Cycle counting should focus on high-value, high-risk and frequently used items rather than relying only on an annual physical count.

ERP and advanced planning systems can automate BOM explosion, exception reporting, supplier schedules, capacity simulations and scenario analysis. Artificial intelligence may improve demand sensing, anomaly detection and parameter recommendations, but it cannot compensate for inaccurate BOMs, biased data or poor process ownership. Human planners remain responsible for interpreting exceptions and balancing cost, service, resilience, safety and ethical obligations.

Important performance measures include schedule adherence, material availability, inventory record accuracy, inventory turns, days of supply, supplier on-time delivery, stockout frequency, changeover time, throughput, constraint utilisation and perfect-order performance. Measures must be balanced: maximising utilisation at every work centre may worsen flow, and minimising inventory may increase disruption costs.

Challenges and Limitations

MRP can generate nervousness when demand, lead times or schedules change frequently. It may also recommend large batches because of inappropriate lot sizes, even when flow would be better. JIT can become fragile if managers remove buffers without improving process capability. Kanban is difficult to apply where demand is highly erratic, products are engineered to order or replenishment lead times are long. TOC can be misapplied if a temporary symptom is mistaken for the true system constraint.

Professional judgement is therefore required. Planners should validate assumptions, distinguish firm orders from forecasts, review exception messages, involve suppliers and production personnel, and test the effects of proposed policy changes. Inventory decisions also have ethical and regulatory dimensions: safe materials must not be substituted without approval, hazardous substances require proper control, and supplier decisions should consider labour standards, environmental impact and business continuity.

Chapter Summary

Materials requirements planning converts a master production schedule into time-phased component and raw-material requirements using the BOM, inventory records, lead times and lot-sizing rules. The MRP record calculates projected balances, net requirements, planned receipts and planned releases. Lot-for-lot, fixed quantities, period-order quantities and EOQ each have appropriate conditions and limitations. Capacity requirements planning tests whether material plans can be executed by available work centres.

JIT and lean inventory reduce waste and expose process problems, while Kanban provides a visual pull signal for replenishment. These approaches require reliable quality, short and dependable lead times, standard work and disciplined suppliers. The theory of constraints focuses improvement on the system bottleneck through identify, exploit, subordinate, elevate and repeat. In professional practice, accurate data, cross-functional governance, balanced metrics and resilience planning are as important as the mathematical logic of the planning system.

Key Terms

Bill of materials: Structured list of components and quantities needed to make a parent item.

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

Independent demand: Demand arising from external customers or markets.

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

Material requirements planning: System that calculates what materials are needed and when.

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

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

Planned order receipt: Quantity planned to become available in a specified period.

Planned order release: Date on which an order must be placed or production started.

Lead time: Time between initiating and receiving or completing an order.

Lot sizing: Method for determining the quantity ordered or produced.

Capacity requirements planning: Process of comparing planned workload with available capacity.

Just-in-time: Philosophy of supplying only what is needed, when needed, with minimal waste.

Kanban: Visual or electronic signal authorising replenishment in a pull system.

Lean inventory: Inventory managed to minimise waste while supporting reliable flow.

Theory of constraints: Approach that improves system performance by managing its limiting constraint.

Safety stock: Additional inventory held to protect against uncertainty.

BOM explosion: Process of deriving component requirements from parent-item demand.

Review Questions

Short Answer Questions

1. What is the difference between independent and dependent demand?
2. Identify four essential inputs to an MRP system.
3. What information does a bill of materials provide?
4. State the five focusing steps of the theory of constraints.
5. Why can an MRP plan be infeasible even when its calculations are correct?

Long Answer Questions

1. Explain how the MPS, BOM, inventory records and lead times interact in an MRP system.
2. Compare lot-for-lot, fixed order quantity and EOQ, including the conditions under which each may be appropriate.
3. Explain how JIT and Kanban reduce inventory and identify the risks of applying them without process stability.
4. Discuss how capacity constraints should influence production scheduling and procurement.
5. Evaluate the complementary roles of MRP, lean systems and TOC in a manufacturing organisation.

Analytical / Application Questions

1. A product requires three components per finished unit. The MPS calls for 400 units, 500 components are on hand, 200 are scheduled to arrive, and safety stock is 100. Calculate the component net requirement under lot-for-lot planning.
2. Daily demand is 300 units, replenishment lead time is 0.4 day, safety allowance is 15%, and each container holds 40 units. Calculate the number of Kanban containers, rounding up.
3. A work centre has 600 available hours in a week. Three planned items require 250, 180 and 220 hours respectively. Analyse the capacity position and recommend two possible managerial responses.

Multiple Choice Questions with Answers

Question 1

Which document shows the quantity of each component required to make one parent item?

A. Master production schedule

B. Bill of materials

C. Capacity report

D. Supplier scorecard

Correct Answer: B. Bill of materials

Question 2

Demand for a component calculated from the planned production of its parent is called:

A. Independent demand

B. Derived pricing

C. Dependent demand

D. Safety demand

Correct Answer: C. Dependent demand

Question 3

An MPS primarily specifies:

A. Finished products and their planned production timing

B. Every supplier's payment terms

C. The annual depreciation of machines

D. Employee attendance targets

Correct Answer: A. Finished products and their planned production timing

Question 4

If gross requirement is 900 units, opening available supply is 300, scheduled receipts are 200 and safety stock is 100, the net requirement is:

A. 300 units

B. 400 units

C. 500 units

D. 700 units

Correct Answer: B. 400 units

Question 5

Under lot-for-lot planning, the planned order receipt normally equals:

A. The economic order quantity

B. The supplier's largest truckload

C. The net requirement

D. Annual demand divided by twelve

Correct Answer: C. The net requirement

Question 6

In the EOQ model, an increase in annual holding cost, with all other variables constant, generally causes EOQ to:

A. Increase

B. Decrease

C. Remain exactly unchanged

D. Become equal to annual demand

Correct Answer: B. Decrease

Question 7

A Kanban signal primarily authorises:

A. Replenishment or movement of a defined quantity

B. An annual financial audit

C. A permanent increase in safety stock

D. The cancellation of all production orders

Correct Answer: A. Replenishment or movement of a defined quantity

Question 8

Which is the correct first step in the theory of constraints?

A. Elevate every work centre

B. Identify the system constraint

C. Subordinate the market to the warehouse

D. Increase all batch sizes

Correct Answer: B. Identify the system constraint

Question 9

If planned workload is 460 hours and available capacity is 400 hours, the work centre has:

A. 60 hours of unused capacity

B. A 400-hour surplus

C. A 60-hour overload

D. No capacity issue

Correct Answer: C. A 60-hour overload

Question 10

Which condition best supports JIT and Kanban?

A. Unreliable quality and highly variable replenishment

B. Accurate data, stable processes and dependable replenishment

C. Large safety stocks at every stage

D. Frequent unplanned engineering changes

Correct Answer: B. Accurate data, stable processes and dependable replenishment