Inventory, Materials and Enterprise Planning

Introduction and context

Inventory is a stock of materials, components, work-in-process, finished goods, spare parts, or information-enabled service capacity held to support future operations. It exists because supply and demand rarely occur at exactly the same time, quantity, location, or quality. Inventory can protect customer service and production continuity, but it also consumes capital, space, labor, energy, and management attention. The central operations-management problem is therefore not to minimize inventory absolutely, but to determine the economically and strategically appropriate level and location of inventory under uncertainty.

Materials planning extends this problem from individual items to networks of dependent components. Enterprise planning further integrates purchasing, production, distribution, finance, sales, and human resources. This chapter develops the principal analytical models used for independent-demand inventory and then connects them to materials requirements planning (MRP), manufacturing resource planning (MRP II), and enterprise resource planning (ERP).

Learning objectives

After completing this chapter, students should be able to:

1. Classify inventory and explain its operational and financial purposes.
2. Apply ABC analysis and interpret its managerial implications.
3. Calculate and critique economic order quantity, reorder-point, safety-stock, periodic-review, and newsvendor decisions.
4. Distinguish independent from dependent demand and construct a basic bill of materials and MRP record.
5. Explain the evolution from MRP to MRP II and ERP.
6. Evaluate inventory-control trade-offs under uncertainty, including service, cost, resilience, sustainability, and governance.

1. Inventory as an operations decision

Inventory performs several functions:

• Cycle stock arises because replenishment occurs in batches rather than continuously.
• Safety stock protects against demand, supply, and lead-time uncertainty.
• Anticipation inventory is accumulated for predictable peaks, promotions, shutdowns, or seasonal supply constraints.
• Pipeline inventory is in transit or otherwise committed but not yet available for use.
• Decoupling inventory separates stages so that a disruption at one process does not immediately stop another.
• Work-in-process (WIP) is inventory undergoing transformation.

Inventory may be owned, consigned, in transit, obsolete, damaged, or held at a supplier. These distinctions matter because accounting ownership and physical availability are not always identical.

The principal costs are ordering or setup cost, purchase cost, holding cost, shortage cost, and disposal or obsolescence cost. Holding cost often includes capital cost, insurance, storage, handling, shrinkage, deterioration, and taxes. A common annual holding-cost representation is:

where H is annual holding cost per unit, i is the annual holding-rate fraction, and C is unit purchase or production cost. The equation is applicable when the holding rate is expressed as a proportion of item value and the relevant value base is stable. Units are currency per unit per year.

Inventory performance should be assessed with more than an average-stock measure. Useful metrics include fill rate, cycle-service level, inventory turnover, days of supply, forecast bias, obsolete inventory, schedule adherence, and cash-to-cash cycle time. Inventory turnover is commonly defined as:

High turnover is not automatically desirable: it may indicate efficient flow, or it may reflect chronic shortages and excessive expediting.

2. ABC analysis and differentiated control

ABC analysis ranks items by annual dollar usage, usually calculated as:

Items are then ordered from highest to lowest usage and grouped, often approximately as A items (the few items representing most annual value), B items (intermediate importance), and C items (many items representing relatively little annual value). The boundaries are managerial conventions rather than universal laws.

A items normally receive accurate records, frequent review, close supplier coordination, rigorous forecasting, and senior management attention. B items receive standard controls. C items may use simple two-bin systems, broad reorder rules, or larger order quantities to reduce administrative effort. ABC classification should not be based solely on value. Criticality, lead time, substitutability, regulatory importance, and risk of stockout can justify elevating a low-value item to tighter control. A useful extension is a two-dimensional value–criticality matrix.

Worked example: ABC classification

Suppose four items have the following annual demand and unit values.

Total annual usage is $150,000. P contributes 53.3%, Q 26.7%, R 13.3%, and S 6.7%. A firm might classify P as A, Q as B, and R and S as C, but it should validate these boundaries against operational criticality and administrative cost. The analysis indicates where precision is most financially consequential; it does not determine the order quantity by itself.

3. Continuous-review inventory models

3.1 Economic order quantity

The basic economic order quantity (EOQ) balances ordering cost against cycle-stock holding cost:

D is annual demand in units per year, S is ordering or setup cost per order, H is annual holding cost per unit per year, and Q* is the optimal order quantity in units. The model assumes known and constant demand, constant lead time, instantaneous replenishment, no shortages, a fixed unit price, independent replenishment cycles, and ordering cost independent of order size. It is a cost-minimization model, not a service-level model.

Annual relevant cost is:

The first term is annual ordering cost and the second is annual cycle-stock holding cost. Purchase cost is omitted when unit price is constant because it does not change with Q. Differentiating with respect to Q and setting the derivative to zero gives the EOQ expression; the second derivative is positive, confirming a minimum.

At EOQ, annual ordering cost equals annual cycle-stock holding cost. The number of orders per year is D ÷ Q, and the order cycle in operating days is approximately Q ÷ daily demand.

Worked example: EOQ

A component has annual demand of 10,000 units, ordering cost of $50 per order, and annual holding cost of $2 per unit. Thus:

Average cycle stock is approximately 353.5 units. Annual ordering cost is approximately (10,000 ÷ 707) × $50 = $707. Annual holding cost is 353.5 × $2 = $707. These values are equal within rounding. If demand is lumpy, capacity is constrained, quantity discounts apply, or replenishment is gradual, the basic EOQ must be modified.

3.2 Reorder point and safety stock

For continuous review, an order is released when the inventory-position signal reaches the reorder point. Inventory position is normally on-hand inventory plus on-order inventory minus backorders. With constant demand and lead time:

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

If demand during lead time is normally distributed and lead time is constant, safety stock for a target cycle-service level is:

where z is the standard-normal quantile associated with the target probability of no stockout during lead time, and σL is the standard deviation of lead-time demand. For daily independent demand with standard deviation σd and lead time L days:

These equations assume a suitable normal approximation, independent daily demand, stable parameters, and that the service measure is a cycle-service probability. A fill rate requires a different analysis because it measures the proportion of demand supplied immediately, not merely the probability of avoiding any stockout.

If both daily demand and lead time vary independently, with mean demand d, standard deviation σd, mean lead time L, and standard deviation σL, the variance of lead-time demand can be approximated by:

Thus SS = zσLT. If demand and lead time are correlated, a covariance term is required; blindly applying the independent formula can understate risk.

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, use z ≈ 1.645.

Expected lead-time demand = 100 × 4 = 400 units.

Therefore:

The reorder point is not the order quantity. The firm orders approximately 707 units in the preceding EOQ example whenever inventory position reaches 466 units, subject to practical rounding and capacity constraints.

4. Periodic review and service decisions

Under periodic review, inventory is checked every P time units and replenishment raises the inventory position to an order-up-to level S. Protection is needed over the review period plus lead time:

where μ is mean demand per time unit and σ(P+L) is the standard deviation of demand over the protection interval. For independent daily demand with standard deviation σd:

The order quantity at review is:

where IP is current inventory position. Periodic review can reduce administrative and transportation effort and is convenient for supplier routes, but it exposes inventory to unnoticed demand during the review interval. It generally needs more safety stock than an equivalent continuous-review system because protection includes P.

Newsvendor model

The newsvendor model addresses a single selling season or short life cycle, where leftover and shortage consequences are asymmetric. Let c be purchase cost, p selling price, v salvage value per unit, and Cu underage cost. When p ≥ c ≥ v:

The recommended order quantity Q satisfies:

where F is the cumulative distribution function of demand. The model assumes one decision before demand is realized, known or estimated demand distribution, and specified treatment of leftovers and shortages. It is not a substitute for a replenishment model in a multi-period environment.

For example, if p = $30, c = $18, and v = $6, then Cu = $12, Co = $12, and the critical fractile is 0.5. The optimal quantity is therefore the median of the demand distribution, not necessarily the mean. If the product has a high shortage penalty relative to leftover cost, the fractile and order quantity increase.

5. Dependent demand and bills of materials

Independent demand originates outside the inventory system, such as customer demand for a finished product or replacement-part demand. It must generally be forecast. Dependent demand is derived from the requirements of another item, such as components needed to assemble a product. It can be calculated from the master production schedule and the bill of materials (BOM).

A BOM is a structured description of parent–component relationships. It specifies component quantities, engineering revision, scrap or yield factors, units of measure, and often effective dates. A single-level BOM lists immediate components; a multilevel or indented BOM represents the complete product structure. A planning BOM may group options or families, whereas an engineering BOM emphasizes design structure. Confusing these purposes causes planning and configuration errors.

Consider a product A requiring 2 units of B and 3 units of C. Each B requires 4 units of D. If planned production of A is 100 units, gross requirements are 200 B and 300 C. The derived gross requirement for D is 200 × 4 = 800 units, before accounting for inventory, scheduled receipts, lot sizes, scrap, and lead times. Dependent demand should not normally be forecast independently of the parent schedule, because doing so can create double counting and nervousness.

6. Material requirements planning

MRP is a time-phased planning technique that converts a master production schedule into planned orders for components and materials. Its principal inputs are:

1. Master production schedule (MPS): what end items are required, in which periods.
2. BOM: how many components are required for each parent.
3. Inventory records: on-hand balances, scheduled receipts, allocations, safety stocks, lot-sizing rules, and lead times.

A basic MRP record contains gross requirements, scheduled receipts, projected available balance, net requirements, planned-order receipts, and planned-order releases. The logic is:

The exact available-balance calculation depends on whether safety stock is treated as protected inventory and on the system’s conventions. A planned-order release is offset from its receipt by the item’s lead time. Lot-for-lot ordering makes the planned receipt equal to the net requirement; fixed-order-quantity, periodic-order-quantity, or minimum/maximum rules impose other constraints.

Illustrative MRP record

Suppose an item has 20 units on hand, no scheduled receipts, a safety stock of 5, lead time of one period, and gross requirements of 30 in period 1 and 10 in period 2. Under lot-for-lot:

After the first receipt, projected available is 5 units, preserving safety stock. In an actual system, a negative-period release would be moved to an earlier planning horizon or flagged as infeasible. MRP is a plan, not a guarantee: late suppliers, inaccurate BOMs, unstable schedules, and capacity constraints can invalidate it.

MRP nervousness and capacity

Small changes in the MPS can generate many changes in component orders, a phenomenon called nervousness. Time fences, order modifiers, frozen schedules, accurate data, and appropriate rescheduling rules reduce unnecessary disruption. Basic MRP is primarily a material-feasibility system; it may assume infinite capacity. Capacity requirements planning and finite-capacity scheduling are needed to test labor, machine, tooling, and supplier constraints.

7. From MRP to MRP II and ERP

MRP focused on material timing. MRP II, or manufacturing resource planning, extended the logic to capacity, labor, equipment, financial implications, and feedback from execution. It supports a closed-loop planning process in which plans are checked against resources and revised.

ERP integrates broader enterprise processes through shared data and transaction controls. Typical modules include procurement, inventory, production, sales, distribution, finance, maintenance, quality, human resources, and analytics. ERP creates a common database and standardized workflows, but integration does not guarantee good decisions. Poor master data, inappropriate parameters, weak process ownership, and excessive customization can simply spread errors more quickly.

The planning hierarchy should be coherent:

• Strategic planning establishes network capacity, sourcing, technology, and policies.
• Sales and operations planning balances aggregate demand and supply.
• The MPS translates the aggregate plan into end-item schedules.
• MRP explodes end-item requirements into component plans.
• Execution systems record receipts, issues, production, and exceptions.

ERP implementation is therefore an organizational change project, not merely a software installation. Governance should define data ownership, approval rights, parameter review, segregation of duties, cybersecurity, audit trails, and procedures for exceptional manual overrides.

8. Managing trade-offs under uncertainty

Inventory decisions balance competing objectives. More inventory can improve service, absorb variability, exploit quantity discounts, and protect against geopolitical or transportation disruption. Less inventory can release cash, reduce obsolescence, lower emissions from storage, and expose process problems that inventory had concealed. The appropriate decision depends on product economics, risk, customer promises, reversibility, and the cost of disruption.

Important managerial choices include:

• Centralization versus decentralization: pooling demand can reduce aggregate safety stock, but longer delivery distances may reduce responsiveness.
• Single versus multiple sourcing: a sole source may achieve scale, while multiple sources improve resilience but add qualification and coordination costs.
• Forecast-driven versus order-driven replenishment: postponement and modular design can delay commitment until demand information improves.
• Push versus pull control: MRP generally plans from anticipated requirements; kanban and related systems authorize replenishment from actual consumption. Hybrid systems are common.
• Cost versus service: a target service level should be tied to customer economics, not selected mechanically.

Risk pooling is valuable because independent demand variability grows more slowly than the sum of separate variabilities. However, pooling benefits weaken when demands are highly correlated, transportation lead times are long, or product differentiation occurs late.

Ethical and governance issues include deliberate concealment of shortages, inaccurate inventory records, unsafe substitution, manipulation of forecasts or service metrics, and procurement decisions influenced by conflicts of interest. Inventory accuracy also affects financial reporting; cycle counting, authorization controls, traceability, and reconciliation are therefore operational and governance requirements.

Technology can improve visibility through barcode and RFID capture, warehouse-management systems, supplier portals, IoT sensors, and event monitoring. AI and machine learning may improve forecasts, anomaly detection, dynamic safety stocks, and estimated lead times. They do not remove the need for causal understanding, clean data, human accountability, and monitoring for bias. A model trained on stockout-censored sales may systematically underestimate true demand because observed sales exclude unmet demand.

Contemporary practice increasingly emphasizes resilience, circularity, and sustainability. Firms are measuring carbon and water implications of expedited freight, returns, packaging, obsolescence, and buffer stock. Service-parts planning, remanufacturing, repair, and reverse logistics require inventory policies that account for uncertain returns and multiple quality states.

9. Applied case: Northstar Medical Devices (illustrative)

Background

Northstar assembles diagnostic units from electronic boards, sensors, and housings. Demand for finished units is moderately stable, but a specialized sensor has a long, variable supplier lead time. The sensor is inexpensive relative to the finished product but is clinically critical.

Problem

The purchasing department classified the sensor as a C item because annual dollar usage was low. It used a simple large-batch policy and experienced repeated production stoppages. Meanwhile, obsolete housings accumulated because sales promotions changed the product mix without timely BOM and MPS updates.

Analysis

ABC analysis alone concealed criticality. A value–criticality assessment elevated the sensor to managerial control. Demand during the supplier lead time was estimated from usage and supplier data. Rather than relying on a nominal average, Northstar examined lead-time variability, supplier reliability, and the cost of a line stoppage. The company also audited the sensor’s BOM revision and inventory records.

The production planner then separated decisions: a reorder point and safety stock were used for the sensor, while MRP planned sensor requirements from the MPS for finished units. The policy included supplier confirmation, exception alerts, and a periodic review of safety-stock parameters. For housings, engineering and sales established an effective-date discipline so that obsolete configurations could not be scheduled without authorization.

Approach and outcome

Northstar introduced cycle counting based on risk, froze the near-term MPS, and integrated supplier acknowledgments into the ERP workflow. It did not simply maximize sensor inventory; instead, it compared the marginal holding cost with the expected cost of disruption and negotiated a shorter, more reliable lead time. Production interruptions declined, obsolete housing receipts were reduced, and planners spent less time expediting.

Learning points

The case illustrates that classification must reflect operational criticality, not only annual value; MRP depends on accurate structures and schedules; safety stock is a risk decision; and ERP produces value only when processes, data, and accountability are aligned.

Best-practice checklist

1. Segment items by value, criticality, variability, and supply risk.
2. Use EOQ only when its assumptions are reasonably appropriate.
3. Match safety stock to a clearly defined service measure.
4. Keep demand, lead-time, BOM, inventory, and supplier data accurate.
5. Separate planning horizons and use time fences to control nervousness.
6. Test material plans against capacity and supplier constraints.
7. Review parameters after structural changes, not only on a fixed calendar.
8. Measure both service and total cost, including obsolescence and disruption.
9. Treat ERP and AI outputs as governed decision support, not unquestionable truth.
10. Include resilience, sustainability, ethics, and financial control in inventory policy.

Chapter Summary

Inventory supports continuity, synchronization, service, and risk management, but creates holding, ordering, shortage, and obsolescence costs. ABC analysis directs management attention, while EOQ balances ordering and cycle-stock costs under restrictive assumptions. Reorder-point and safety-stock models incorporate lead-time demand and uncertainty; periodic review protects against the longer review-plus-lead-time interval. The newsvendor model selects a one-time order quantity using the critical fractile.

Independent demand is forecast externally, whereas dependent demand is calculated from a master schedule and BOM. MRP time-phases component requirements and planned orders; MRP II adds capacity and resource feedback; ERP integrates planning and execution across the enterprise. Effective inventory governance requires accurate data, differentiated controls, explicit service objectives, capacity awareness, resilience analysis, ethical conduct, and disciplined use of digital technologies.

Key Terms

ABC analysis: Classification of inventory by annual dollar usage, usually into A, B, and C groups.

Annual dollar usage: Annual demand multiplied by unit value.

Bill of materials (BOM): Structured record of parent items, components, quantities, and related product-structure information.

Cycle stock: Inventory created by ordering or producing in batches.

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

Economic order quantity (EOQ): Order quantity that minimizes basic ordering plus holding cost.

Enterprise resource planning (ERP): Integrated system supporting cross-functional enterprise processes and shared data.

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

Independent demand: Demand determined outside the inventory system, commonly by customers.

Inventory position: On-hand inventory plus on-order inventory minus backorders.

Lead-time demand: Demand occurring while replenishment is in process.

Material requirements planning (MRP): Time-phased calculation of component requirements and planned orders.

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

Newsvendor model: Single-period inventory model balancing underage and overage costs.

Reorder point: Inventory-position level that triggers replenishment.

Safety stock: Buffer inventory held against uncertainty.

Service level: Probability or proportion associated with meeting demand under a specified service definition.

Time fence: Planning boundary restricting changes to near-term schedules.

Work-in-process: Inventory currently undergoing transformation.

Review Questions

Short Answer Questions

1. What operational purposes are served by cycle stock, safety stock, and decoupling inventory?
2. Why should ABC analysis be supplemented by criticality and supply-risk information?
3. What assumptions underlie the basic EOQ model?
4. How does dependent demand differ from independent demand?
5. What are the three principal inputs to an MRP system?

Long Answer Questions

1. Explain the relationship among EOQ, reorder point, safety stock, and service level. Include the limitations of each model.
2. Compare continuous-review and periodic-review systems in terms of monitoring, protection interval, inventory, and administrative requirements.
3. Explain how an MPS, BOM, inventory records, and lead times interact in MRP.
4. Discuss the evolution from MRP to MRP II and ERP, including organizational and data-governance challenges.
5. Evaluate the trade-offs between lean inventory, resilience, sustainability, and customer service under uncertainty.

Analytical / Application Questions

1. Daily demand for an item has mean 80 units and standard deviation 15 units. Lead time is constant at 9 days. Using z = 1.645, calculate lead-time demand, safety stock, and reorder point for a 95% cycle-service level.
2. A product sells for $50, costs $30, and has a salvage value of $10. Calculate underage cost, overage cost, and the newsvendor critical fractile. Explain what demand percentile should determine the order quantity.
3. Construct a two-period lot-for-lot MRP record for a component with 25 units on hand, 5 units of safety stock, no scheduled receipts, gross requirements of 30 and 20 units, and a one-period lead time. State the planned-order releases and identify any feasibility issue caused by the planning horizon.

Multiple Choice Questions with Answers

Question 1

Which inventory category primarily protects against demand or supply uncertainty?

A. Cycle stock

B. Safety stock

C. Pipeline inventory

D. Anticipation inventory

Correct Answer: B. Safety stock

Question 2

Annual demand is 12,000 units, ordering cost is $40 per order, and annual holding cost is $2 per unit. What is the basic EOQ approximately?

A. 490 units

B. 693 units

C. 980 units

D. 1,200 units

Correct Answer: B. 693 units

Question 3

Daily demand has a mean of 50 units, standard deviation of 10 units, and constant lead time of 4 days. Using z = 1.645, what is the approximate reorder point?

A. 200 units

B. 216 units

C. 233 units

D. 266 units

Correct Answer: C. 233 units

Question 4

In a periodic-review system, the protection interval normally includes:

A. Only the lead time

B. Only the review period

C. The review period plus lead time

D. The order quantity plus lead time

Correct Answer: C. The review period plus lead time

Question 5

A product has selling price $40, cost $25, and salvage value $10. What is the newsvendor critical fractile?

A. 0.40

B. 0.50

C. 0.60

D. 0.75

Correct Answer: B. 0.50

Question 6

Which item is most characteristic of dependent demand?

A. Customer demand for a finished bicycle

B. Demand for replacement batteries sold independently

C. Demand for tires required by a scheduled bicycle assembly plan

D. Seasonal demand for umbrellas

Correct Answer: C. Demand for tires required by a scheduled bicycle assembly plan

Question 7

Which combination is the essential traditional input set for MRP?

A. BOM, MPS, and inventory records

B. EOQ, income statement, and marketing plan

C. Supplier scorecard, balance sheet, and routing map

D. Customer survey, warehouse map, and payroll register

Correct Answer: A. BOM, MPS, and inventory records

Question 8

What is a principal purpose of a time fence in MRP?

A. To eliminate all safety stock

B. To prevent unnecessary near-term schedule changes

C. To convert dependent demand into independent demand

D. To calculate annual dollar usage

Correct Answer: B. To prevent unnecessary near-term schedule changes

Question 9

Which statement best distinguishes MRP II from basic MRP?

A. MRP II excludes capacity considerations

B. MRP II extends planning to broader manufacturing resources and capacity feedback

C. MRP II is limited to finished-goods forecasting

D. MRP II replaces the bill of materials with ABC analysis

Correct Answer: B. MRP II extends planning to broader manufacturing resources and capacity feedback

Question 10

Why can a low-value item require tight inventory control?

A. Low-value items always have high holding costs

B. Annual dollar usage determines all control policies

C. The item may be operationally critical, difficult to substitute, or subject to long lead time

D. Low-value items cannot be counted accurately

Correct Answer: C. The item may be operationally critical, difficult to substitute, or subject to long lead time