Inventory and Materials Planning

Introduction

Inventory and materials planning determines what materials should be available, in what quantity, at which location, and at what time. It links customer demand, procurement, production, distribution, finance and operations strategy. The central managerial problem is a trade-off: too little inventory causes stockouts, production interruptions and lost sales; too much inventory consumes working capital, occupies space, increases handling and insurance costs, and creates obsolescence risk.

Inventory is therefore not simply a store of goods. It is a buffer against uncertainty and a synchronising mechanism between processes that operate at different rates. Effective planning combines classification, forecasting, replenishment policies, bills of material, capacity information, supplier performance and service-level decisions.

Learning Objectives

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

1. Explain the economic and operational role of inventory.
2. Classify inventory using ABC, XYZ, criticality and related methods.
3. Apply EOQ, reorder-point, safety-stock and service-level models.
4. Distinguish continuous-review from periodic-review systems.
5. Explain multi-echelon inventory, MRP, DRP and just-in-time systems.
6. Evaluate trade-offs involving availability, working capital and obsolescence.
7. Design governance, data and performance practices for materials planning.

1. The Role and Economics of Inventory

Inventory includes raw materials, components, work-in-process, finished goods, maintenance supplies and goods in transit. It exists for several reasons:

• Cycle stock: inventory created by ordering or producing in economic batches.
• Safety stock: inventory held against demand, lead-time or supply uncertainty.
• Pipeline inventory: stock moving between locations or stages.
• Anticipation inventory: stock built before seasonal demand, promotions or expected disruption.
• Decoupling inventory: stock separating processes so that one interruption does not immediately stop another.

The annual relevant cost of an inventory policy commonly includes purchase or production cost, ordering or setup cost, holding cost and shortage cost. Purchase cost may be constant across order quantities and can then be excluded from the basic lot-sizing decision, but quantity discounts and capacity constraints may make it relevant.

Holding cost includes capital cost, storage, insurance, damage, shrinkage, taxes and obsolescence. If the annual holding-cost rate is i and unit value is C, the annual holding cost per unit is:

where H is currency per unit per year. The calculation assumes that i captures the relevant annual carrying-cost rate and that value remains an appropriate basis for carrying cost.

A useful managerial approximation is:

The terms should not be added mechanically when a system defines them differently; the planner must prevent double counting.

2. Inventory Classification and Segmentation

A single policy for every item is inefficient. Classification focuses managerial attention according to value, uncertainty, criticality and supply risk.

ABC analysis

ABC analysis ranks items by annual consumption value:

Items are then ordered from highest to lowest value and grouped, often approximately as follows:

These percentages are heuristics, not laws. ABC analysis identifies financial impact but does not identify operational criticality. A low-value bearing can stop a production line and therefore require a higher control level than its value suggests.

Other useful classifications

• XYZ: X items have relatively predictable demand; Z items are highly variable or intermittent.
• VED: Vital, essential and desirable, based on consequences of non-availability.
• FSN: Fast-moving, slow-moving and non-moving, based on issue or consumption frequency.
• HML: High, medium and low unit price.
• SDE: Scarce, difficult and easy to procure, based on supply conditions.

A multidimensional policy may classify an item as AX-V: high value, predictable demand and vital. Another may be CZ-D: low value, uncertain demand and desirable. Such combinations support differentiated review frequency, supplier strategy, safety-stock rules and approval authority.

3. Economic Order Quantity

The basic EOQ model identifies the order quantity that minimises annual ordering and holding costs. Let D be annual demand in units, S the ordering or setup cost per order, Q the order quantity and H the annual holding cost per unit. Assuming constant demand, instantaneous replenishment, no shortages, no quantity discounts and constant lead time, the relevant annual cost is:

The first term is annual ordering cost and the second is annual cycle-stock holding cost. Differentiating with respect to Q and setting the derivative to zero gives:

At Q*, annual ordering cost equals annual cycle-stock holding cost. The model is most useful as a benchmark, not as an unquestionable answer. It excludes safety stock, supplier minimums, transport economics, quantity discounts, finite production rates and capacity constraints.

Related measures are:

The second expression is in years when Q* and D use the same time basis.

Worked example

Annual demand is 24,000 units, ordering cost is $75 per order, and annual holding cost is $2.40 per unit. Then:

The firm should use an order quantity of approximately 1,225 units under the model assumptions. Orders per year are 24,000 ÷ 1,225 ≈ 19.6, and average cycle stock is approximately 612.5 units, excluding safety stock.

Extensions

For finite replenishment, where production occurs at rate p and demand at rate d, with p > d, the maximum cycle inventory is reduced because demand occurs during production. The economic production quantity is:

This applies only when production and demand rates are reasonably stable and replenishment is gradual. Quantity discounts require comparison of total cost at feasible price-break quantities; choosing the lowest unit price alone is incorrect.

4. Reorder Point, Lead Time and Safety Stock

A continuous-review system triggers replenishment when the inventory position reaches a reorder point. Inventory position includes on-hand inventory plus scheduled receipts minus backorders. With constant demand and lead time:

where d is demand per time unit, L is lead time in the same time unit, and SS is safety stock. The term dL is expected lead-time demand.

Safety stock under demand uncertainty

If lead time is constant and demand during lead time is normally distributed with standard deviation σL, a cycle-service-level safety stock is:

where z is the standard-normal quantile associated with the desired probability of no stockout during one replenishment cycle. For example, z is approximately 1.645 for a 95% cycle service level and 2.326 for 99%.

If daily demand has standard deviation σd and lead time is a constant L days, independent daily demand gives:

If both demand and lead time vary, let mean daily demand be μd, standard deviation σd, mean lead time be μL and lead-time standard deviation σL. Under independence and a normal approximation:

Thus:

This formula assumes demand and lead time are independent. If their covariance is material, an additional covariance term is required; planners should not apply the independent formula blindly.

Service-level meanings

A cycle service level is the probability of having no stockout during a replenishment cycle. A fill rate is the proportion of demand supplied immediately from stock. They are not identical. A policy can have a high cycle service level but a lower fill rate if occasional shortages are large. The selected metric must match the commercial promise and the cost of shortage.

Worked example: reorder point

Daily demand has mean 100 units and standard deviation 20 units. Lead time is constant at 4 days. For a 95% cycle service level, z = 1.645.

When inventory position falls to about 466 units, an order should be released, subject to rounding, minimum order quantities and operational constraints.

5. Periodic Review and Base-Stock Policies

Under periodic review, inventory is checked at intervals P and replenished to a target level. The protection period is the review interval plus lead time. With normally distributed demand and constant lead time:

where S is the order-up-to level and P and L are expressed in the same time units. The order quantity at review is:

The formula assumes independent demand increments, stable parameters and a normal approximation. Periodic review reduces administrative effort and supports route or supplier schedules, but it exposes the item to demand occurring before the next review. Consequently, its protection period is longer than that of an equivalent continuous-review system.

A base-stock system attempts to maintain a target inventory position close to a prescribed level and is particularly useful for short lead times, high-value items or environments with frequent replenishment signals. Kanban systems are a practical pull-based form of replenishment, although their effectiveness depends on stable processes and disciplined container control.

6. Multi-Echelon Inventory

A supply chain is multi-echelon when inventory exists at several connected levels, such as supplier, factory, regional distribution centre and retailer. Optimising each location independently can increase total inventory because every stage protects itself against the same uncertainty.

Important concepts include:

• Echelon stock: inventory at a location plus inventory downstream that it is responsible for supporting.
• Risk pooling: aggregation of demand reduces relative variability when demands are not perfectly correlated.
• Strategic stock positioning: locating inventory where it provides the greatest response and postponement benefit.
• Installation stock: inventory physically held at one location.

A centralised distribution centre may reduce safety stock through pooling but increase transportation lead time. A decentralised network may provide faster customer response but duplicate buffers. The correct design considers total landed cost, service requirements, transport frequency, capacity, customs and disruption risk rather than local inventory cost alone.

7. Material Requirements Planning

Material Requirements Planning (MRP) is a time-phased planning technique for dependent-demand items. Dependent demand is derived from a parent item, such as components required for a production order. MRP requires three primary inputs:

1. Master Production Schedule (MPS): what end items are required and when.
2. Bill of material (BOM): parent-component relationships and quantities.
3. Inventory records: on-hand balances, scheduled receipts, lead times, lot-sizing rules and safety stocks.

MRP performs a product-structure explosion, offsets requirements by lead times and produces planned orders. For each period, a simplified record includes gross requirements, scheduled receipts, projected available balance, net requirements, planned-order receipts and planned-order releases.

The basic logic is:

Planned-order release is the planned-order receipt offset backward by the item lead time. The exact calculation depends on the chosen lot-sizing rule, such as lot-for-lot, fixed order quantity, period-order quantity or economic batch quantity.

MRP is powerful for structured production but vulnerable to inaccurate BOMs, unreliable inventory records, nervousness caused by frequent schedule changes and unrealistic lead times. MRP outputs are plans, not facts; buyers and planners must validate capacity, supplier capability and engineering changes.

8. Distribution Requirements Planning

Distribution Requirements Planning (DRP) applies time-phased logic to replenishing distribution locations. It uses forecasts or demand schedules, current inventory, planned receipts, transport lead times, order cycles and distribution rules. DRP connects customer-facing demand to factory and supplier plans.

A typical flow is: customer demand → regional distribution requirements → central distribution replenishment → production schedule → purchased materials. DRP and MRP can therefore form an integrated planning system, provided calendars, item definitions and lead times are consistent.

9. Just-in-Time and Lean Materials Management

Just-in-time (JIT) seeks to provide the required item, in the required quantity, at the required time, with minimal waste. It does not mean zero inventory under all conditions. It means that inventory is deliberately reduced by improving flow, quality, setup time, supplier reliability and problem visibility.

JIT practices include pull signals, small lots, stable schedules, cellular production, supplier development, error prevention, preventive maintenance and rapid changeovers. Its benefits include lower working capital, shorter throughput time and earlier detection of defects. Its vulnerability is exposure to disruption when supply networks lack resilience, alternative sources or recovery capacity.

A mature policy combines lean efficiency with resilience. Critical items may require dual sourcing, strategic buffers, geographic diversification or qualified substitutes. The objective is not minimum inventory; it is the economically and strategically appropriate level of total risk.

10. Integrated Planning and Performance Measurement

Inventory decisions should be integrated with sales and operations planning, procurement, production, finance and customer-service commitments. Common measures include:

Turnover and service measures must be interpreted together. High turnover with poor availability may indicate understocking; high availability with rising obsolescence may indicate overstocking or weak segmentation. Financial measures should include working-capital cost, write-offs, expediting and lost-margin consequences.

11. Technology, Data and Governance

Enterprise resource planning systems, warehouse-management systems, barcode or RFID identification, supplier portals and advanced planning software support materials planning. Demand sensing and machine-learning forecasts can identify patterns, but they do not eliminate structural breaks, promotions, new-product uncertainty or biased data.

AI should be governed through data lineage, model monitoring, exception management, human approval thresholds and explainable recommendations. A forecast that improves statistical accuracy but systematically underestimates demand for vulnerable customers can create unacceptable service and ethical consequences. Master data governance is foundational: units of measure, lead times, pack sizes, BOMs, supplier calendars, item status and substitution rules must be controlled.

12. Illustrative Case: Meridian Medical Devices

Background

Meridian Medical Devices assembles diagnostic equipment. Its imported sensor module is expensive, has a six-week lead time and is vital because assembly cannot proceed without it. Annual demand is 2,400 modules. Ordering cost is $180 per order and annual holding cost is $12 per module. Weekly demand has mean 46 modules and standard deviation 8 modules. Supplier lead time is six weeks with standard deviation 1.5 weeks. Demand and lead time are assumed independent for initial planning.

Problem

The purchasing department uses a fixed order quantity and experiences both emergency shipments and excess stock. Finance wants lower inventory, while operations requires a 98% cycle service level.

Analysis

The EOQ benchmark is:

Mean weekly demand during lead time is 46 × 6 = 276 modules. The standard deviation of lead-time demand is:

For a 98% cycle service level, z ≈ 2.054. Safety stock is therefore approximately 2.054 × 73.6 = 151 modules. The reorder point is:

Approach and solution

Meridian adopts a continuous-review policy with an order quantity near 268 modules, subject to supplier pack-size constraints, and a reorder point near 427 modules. It also:

• validates the supplier’s lead-time history rather than relying on a nominal six-week value;
• separates cycle service level from the financial impact of a prolonged shortage;
• establishes a second qualified source for disruption resilience;
• uses supplier scorecards for delivery reliability and quality;
• reviews the safety stock monthly and after major demand or lead-time changes;
• classifies the module as high-value, uncertain and vital, requiring executive exception control.

Outcome

The policy reduces arbitrary emergency ordering and makes the service-versus-working-capital trade-off explicit. The organisation does not treat 151 units as permanently correct: it monitors forecast bias, lead-time variance, supplier capacity and engineering changes. The case demonstrates that a mathematically sound policy still requires governance, sourcing decisions and data discipline.

Learning points

1. EOQ determines a cycle-stock benchmark, not total inventory.
2. Safety stock depends on the chosen service definition and uncertainty.
3. Criticality can justify stronger controls even when demand volume is modest.
4. Resilience may require actions beyond increasing inventory.

Challenges, Limitations and Ethical Considerations

Inventory models are abstractions. Demand may be intermittent, correlated, censored by stockouts or distorted by promotions. Normal approximations can be poor for low-volume items. Lead times may be endogenous: congestion and rush orders can lengthen them. Cost estimates may omit carbon emissions, labour conditions, waste disposal and social consequences.

Managers should avoid manipulating forecasts or service metrics to meet targets, hiding obsolete stock, or shifting inventory upstream merely to improve a local balance sheet. Procurement decisions should consider supplier labour practices, environmental compliance, conflict materials and concentration risk. Traceability is essential for regulated products, recalls and product safety.

Best practice is to combine quantitative models with cross-functional review, scenario analysis, cycle counting, exception-based control, post-implementation validation and periodic policy reset. Segmentation should determine the sophistication of control: not every C item needs a complex stochastic model, but every vital item needs a credible continuity plan.

Chapter Summary

Inventory and materials planning balances service, cost, cash, risk and operational continuity. ABC analysis prioritises financial attention, while XYZ, VED, FSN and supply-risk classifications reveal uncertainty and criticality. EOQ provides an economic cycle-stock benchmark under restrictive assumptions. Reorder points combine expected lead-time demand with safety stock; safety stock must reflect demand variability, lead-time variability and the selected service measure. Periodic-review systems protect against demand during both review and lead-time intervals.

Multi-echelon planning evaluates total network inventory and risk pooling rather than optimising isolated locations. MRP plans dependent-demand components through MPS, BOM and inventory records; DRP extends time-phased logic through distribution networks. JIT reduces waste by improving flow and reliability, but must be balanced with resilience. Effective practice depends on accurate data, integrated systems, governance, ethical sourcing and continuous review of assumptions.

Key Terms

Inventory: Stock of materials, components, work-in-process or finished goods held for future use or sale.

Cycle stock: Inventory arising from replenishment or production in batches.

Safety stock: Buffer inventory held against uncertainty.

Pipeline inventory: Inventory moving between supply-chain locations.

ABC analysis: Classification by annual consumption value.

XYZ analysis: Classification by demand predictability or variability.

VED analysis: Classification by vital, essential and desirable criticality.

EOQ: Economic order quantity that minimises basic ordering and holding costs.

Reorder point: Inventory position at which replenishment is triggered.

Inventory position: On-hand inventory plus scheduled receipts minus backorders.

Cycle service level: Probability of no stockout during a replenishment cycle.

Fill rate: Proportion of demand supplied immediately from available stock.

Safety stock: Inventory calculated to protect against uncertainty.

MRP: Time-phased planning system for dependent-demand materials.

Master Production Schedule: Schedule of required end items by time period.

Bill of material: Structured representation of parent-item and component relationships.

DRP: Time-phased replenishment planning for distribution networks.

JIT: System that synchronises supply with use while minimising waste.

Multi-echelon inventory: Inventory distributed across interconnected supply-chain levels.

Obsolescence: Loss of usefulness or value because of age, change or lack of demand.

Review Questions

Short Answer Questions

1. What is the difference between cycle stock and safety stock?
2. Why is ABC analysis insufficient as the only inventory classification method?
3. Define reorder point and inventory position.
4. Distinguish cycle service level from fill rate.
5. Identify the three primary inputs to an MRP system.

Long Answer Questions

1. Explain the EOQ model, its derivation, assumptions and limitations.
2. Compare continuous-review and periodic-review inventory systems.
3. Discuss how demand and lead-time variability affect safety-stock decisions.
4. Explain how MRP and DRP can be integrated across a supply network.
5. Critically evaluate JIT in an environment exposed to supply disruption.

Analytical / Application Questions

1. Daily demand has a mean of 80 units and standard deviation of 15 units. Lead time is constant at 9 days. Calculate safety stock and reorder point for a 95% cycle service level, using z = 1.645.
2. A company has annual demand of 18,000 units, ordering cost of $50 and annual holding cost of $4 per unit. Calculate EOQ and explain two practical reasons why the implemented quantity may differ.
3. Design a classification and replenishment policy for a low-value but vital spare part with intermittent demand and a long, unreliable supplier lead time. Justify the service metric, sourcing response and governance controls.

Multiple Choice Questions with Answers

Question 1

Which inventory category is primarily held to protect against demand or lead-time uncertainty?

A. Cycle stock

B. Safety stock

C. Pipeline inventory

D. Anticipation inventory

Correct Answer: B. Safety stock

Question 2

Annual demand is 10,000 units, ordering cost is $40, and annual holding cost is $5 per unit. The basic EOQ is approximately:

A. 126 units

B. 400 units

C. 632 units

D. 2,000 units

Correct Answer: C. 632 units

Question 3

In a continuous-review system with constant demand and lead time, the reorder point equals:

A. Annual demand plus holding cost

B. Order quantity minus safety stock

C. Lead-time demand plus safety stock

D. Average inventory plus ordering cost

Correct Answer: C. Lead-time demand plus safety stock

Question 4

If daily demand standard deviation is 10 units and constant lead time is 9 days, the standard deviation of lead-time demand is:

A. 10 units

B. 19 units

C. 30 units

D. 90 units

Correct Answer: C. 30 units

Question 5

Which classification focuses on the consequence of non-availability?

A. ABC

B. VED

C. FSN

D. HML

Correct Answer: B. VED

Question 6

The protection period in a periodic-review system generally includes:

A. Only supplier lead time

B. Only the review interval

C. Review interval plus lead time

D. Annual demand divided by unit cost

Correct Answer: C. Review interval plus lead time

Question 7

MRP is most directly designed for:

A. Independent retail demand only

B. Dependent demand for components

C. Calculating warehouse rent

D. Measuring inventory turnover

Correct Answer: B. Dependent demand for components

Question 8

Which statement best describes a cycle service level?

A. The percentage of inventory that is obsolete

B. The probability of no stockout during a replenishment cycle

C. The percentage reduction in ordering cost

D. The proportion of suppliers delivering early

Correct Answer: B. The probability of no stockout during a replenishment cycle

Question 9

A key risk of optimising each echelon independently is that it may:

A. Eliminate all transportation costs

B. Duplicate safety stocks across the network

C. Make demand completely predictable

D. Remove the need for inventory records

Correct Answer: B. Duplicate safety stocks across the network

Question 10

The primary objective of JIT is to:

A. Maximise buffer inventory at every stage

B. Synchronise supply with use while reducing waste

C. Replace all suppliers with one supplier

D. Guarantee zero stockouts regardless of cost

Correct Answer: B. Synchronise supply with use while reducing waste