Inventory, Materials and Enterprise Resource Planning

Introduction

Inventory and materials management connects customer demand with the physical resources required to produce and deliver goods and services. It includes the planning, purchasing, receiving, storing, issuing, transforming and controlling of materials. Enterprise Resource Planning (ERP) extends this discipline by integrating inventory, procurement, production, finance, sales, quality and human resources through a common information system.

The central managerial problem is balance. Excess inventory increases capital employed, storage cost, deterioration, obsolescence and risk. Insufficient inventory causes stockouts, production interruptions, expediting, lost sales and dissatisfied customers. Effective operations therefore do not seek simply to minimise inventory. They seek an economically and strategically appropriate level of availability under uncertainty.

Inventory decisions should be aligned with quality objectives. A low-cost material that varies widely in quality may create more total cost through rework and warranty failures. Similarly, an ERP system can improve visibility but cannot compensate for inaccurate bills of material, unreliable lead-time data or weak process discipline.

Learning Objectives

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

1. Classify inventory and materials according to their operational importance.
2. Apply ABC analysis and explain its limitations.
3. Calculate economic order quantity, reorder point and safety stock under stated assumptions.
4. Explain cycle stock, safety stock, service level and uncertainty.
5. Describe MRP, closed-loop MRP and ERP and distinguish their purposes.
6. Evaluate inventory decisions using cost, service, quality and risk criteria.
7. Identify implementation, governance, ethical and technological issues in integrated materials management.

1. Inventory and Materials Management

Inventory is a stock of items held for future use or sale. It may be physical material, partially completed work or finished output. Materials management is the coordinated management of material flow from suppliers through internal operations to customers. Its objectives include:

• continuity of supply;
• acceptable customer service;
• minimum total relevant cost;
• protection of material quality and traceability;
• efficient use of working capital; and
• reliable information for planning and control.

Inventory exists because supply and demand are not perfectly synchronised. Common reasons include economies of scale in purchasing or production, supplier lead time, seasonal demand, transportation uncertainty, process decoupling and the need to protect customer service.

Major inventory categories

Inventory can also be classified as cycle stock, safety stock, anticipation stock, decoupling stock and obsolete or excess stock. These categories may overlap. For example, finished goods held before a predictable holiday peak are anticipation stock, while units ordered in batches to obtain a quantity discount are cycle stock.

2. Inventory Costs and Performance Measures

The principal cost categories are:

• Purchase cost: supplier price, freight, duties and applicable taxes.
• Ordering or setup cost: administrative processing, transport arrangements, inspection and production changeover.
• Holding cost: capital cost, storage, insurance, handling, shrinkage, damage and obsolescence.
• Shortage cost: lost contribution, customer dissatisfaction, emergency purchasing, downtime and expediting.
• Quality cost: inspection, sorting, rework, scrap, returns and failures caused by poor material quality.

A useful annual performance identity is inventory turnover:

The numerator and denominator must be expressed in the same monetary basis. A high turnover is not automatically good: it may indicate efficient flow, or it may indicate dangerously low stock. Complementary measures include fill rate, stockout frequency, days of supply, supplier on-time delivery, inventory accuracy, obsolete inventory percentage and order-cycle time.

Days of supply can be estimated as:

This measure is meaningful only when the demand period and inventory quantity are comparable and demand is reasonably stable.

3. Classification and ABC Analysis

Classification allows management attention to reflect economic importance and operational risk. Useful dimensions include annual usage value, criticality, lead time, substitutability, demand variability, shelf life, regulatory status and supplier availability.

Annual usage value is:

ABC analysis ranks items by annual usage value. A typical, but not universal, arrangement is:

• A items: relatively few items accounting for a large share of value; strict control, frequent review and accurate records.
• B items: intermediate importance; normal managerial control.
• C items: many low-value items accounting for a small share of value; simplified ordering and control may be appropriate.

The percentages are conventions, not laws. An inexpensive aircraft fastener may be a C item by value but an A item by operational criticality. Therefore ABC should be combined with a criticality or risk classification. A two-dimensional matrix can identify, for example, low-value/high-criticality items requiring special controls.

ABC procedure

1. List each stock-keeping unit (SKU), annual demand and unit cost.
2. Calculate annual usage value.
3. Rank items from highest to lowest value.
4. Calculate cumulative value and cumulative percentage of items.
5. Establish organisation-specific A, B and C boundaries.
6. Validate the result using criticality, lead time and demand variability.
7. Assign review, approval, counting and forecasting policies.

ABC analysis is not a substitute for judgement. It can undervalue safety-critical items, fail to represent volatility and become misleading when prices or demand change.

4. Economic Order Quantity

The basic Economic Order Quantity (EOQ) determines the order or production quantity that balances ordering cost and holding cost.

Here, Q^* is the economic order quantity in units per order, D is annual demand in units per year, S is ordering or setup cost per order, and H is annual holding cost per unit. If holding cost is stated as a fraction i of unit price C, then H = iC.

The basic EOQ model assumes constant and known demand, constant lead time, instantaneous replenishment, no shortages, no quantity discounts, fixed ordering cost and constant unit price. It is most useful as a benchmark rather than an unquestionable answer.

Derivation

Ignoring purchase cost, 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:

Therefore:

The result is a minimum because the total-cost function is convex for positive Q.

Worked example: EOQ

A maintenance item has annual demand of 12,000 units. Ordering cost is $40 per order and annual holding cost is $2 per unit.

The recommended basic order quantity is approximately 693 units. Orders per year are:

The model does not imply that every order must contain exactly 693 units. Packaging, supplier minimums, transport constraints, shelf life and quantity discounts may require adjustment.

5. Reorder Point, Safety Stock and Service Level

EOQ determines how much to order; the reorder point determines when to order. With constant demand and lead time:

ROP is reorder point in units, d is average demand per time unit, and L is lead time in the same time unit. With safety stock:

SS is safety stock. Unit consistency is essential: daily demand must be multiplied by lead time in days, or weekly demand by lead time in weeks.

Safety stock protects against demand and/or lead-time uncertainty. A simple statistical model assumes independent, normally distributed demand during a fixed lead time:

Here, z is the standard-normal factor associated with the desired cycle-service probability, σ is standard deviation of demand per period, and L is lead time in periods. This formula assumes constant lead time and independent demand observations.

If demand per period has standard deviation σ_d and lead time has standard deviation σ_L, a commonly used approximation for independent demand and lead time is:

Then:

The approximation excludes covariance. If demand and lead time are correlated, the variance should include the covariance term:

The exact model should reflect the organisation’s data and replenishment policy. Normal assumptions may be unsuitable for intermittent, highly seasonal or lumpy demand.

Service levels

A cycle service level is the probability that available stock will meet demand throughout a replenishment cycle without a stockout. A fill rate is the proportion of total demand supplied immediately from stock. These are different measures: a cycle may experience one stockout but still satisfy most unit demand, producing a high fill rate.

Worked example: reorder point

Average daily demand is 80 units, lead time is 5 days, and safety stock is 120 units.

A replenishment order should be released when the inventory position reaches 520 units. Inventory position includes on-hand stock plus outstanding orders minus backorders; using only physical on-hand stock can create premature or duplicate orders.

6. Materials Requirements Planning

Materials Requirements Planning (MRP) is a time-phased system for planning dependent-demand items. Dependent demand is calculated from the demand for a parent item. For example, the number of wheels required depends on the planned production of vehicles.

MRP requires three principal inputs:

1. Master Production Schedule (MPS): what finished goods or major assemblies are to be produced, in which quantities and periods.
2. Bill of Material (BOM): the product structure, component quantities and relationships.
3. Inventory status records: on-hand balance, scheduled receipts, open orders, lead times, lot sizes, safety stock and allocated quantities.

MRP produces planned order receipts and planned order releases. The basic logic is:

In practice, the calculation is constrained by safety stock, lot-sizing rules and existing orders. A planned receipt is offset by the relevant lead time to determine the planned release.

MRP logic

Gross requirements are generated by exploding the BOM from parent requirements to component requirements. Scheduled receipts are orders already released and expected to arrive. Projected available balance is updated period by period. When projected inventory falls below the required level, MRP creates a planned receipt, applies the lot-sizing rule and offsets it for lead time.

Common lot-sizing methods include lot-for-lot, fixed order quantity, economic quantities, minimum order quantities and period-order quantities. Lot-for-lot minimises planned residual inventory but may create many orders. Fixed quantities may reduce ordering effort but create excess stock.

MRP is particularly effective where demand is dependent, product structures are known and data is accurate. It is less effective when forecasts, BOMs, inventory records or lead times are unreliable.

7. Closed-Loop MRP and Capacity

Closed-loop MRP adds feedback from execution and capacity planning. It does not merely calculate material requirements; it checks whether proposed plans are feasible and updates plans using actual production, inventory and purchasing information.

A closed-loop system generally links:

MPS → MRP → capacity requirements planning → shop-floor and purchasing execution → feedback and replanning.

Capacity Requirements Planning (CRP) estimates the load imposed on work centres by planned orders and compares it with available capacity. If a work centre is overloaded, management may alter due dates, lot sizes, routing, shifts, subcontracting or the MPS. This feedback distinguishes closed-loop MRP from a purely materials-focused calculation.

8. Enterprise Resource Planning

ERP is an integrated information and process architecture that coordinates transactions and planning across organisational functions. Typical modules include procurement, inventory, production, sales and distribution, finance, maintenance, quality, human resources and product lifecycle management.

ERP creates a shared data environment. A goods receipt can update inventory, create an accounts-payable obligation, support supplier performance measurement and trigger quality inspection. A sales order can affect available-to-promise inventory, production requirements, delivery planning and revenue records.

MRP, closed-loop MRP and ERP compared

ERP implementation should begin with process design and data governance, not software installation. Important master data includes item codes, units of measure, suppliers, lead times, BOMs, routings, work centres, quality specifications and inventory locations.

9. Integrated Quality and Inventory Control

Inventory accuracy is a quality characteristic of information. If the system says that 100 units are available but only 60 usable units exist, planning quality is compromised. Causes include unrecorded receipts, incorrect issues, unit-of-measure errors, unreported scrap, location errors and unauthorised adjustments.

Best practices include:

• barcode, RFID or other controlled identification where justified;
• cycle counting based on risk rather than relying only on an annual count;
• quarantine and status control for nonconforming material;
• lot and serial traceability for regulated or safety-critical products;
• supplier qualification and incoming-quality controls;
• controlled engineering-change procedures;
• segregation of duties for purchasing, receipt, approval and payment; and
• regular reconciliation between physical and system records.

A quality hold must be visible in the ERP system. Otherwise quarantined stock may be accidentally allocated to production or customers.

10. Illustrative Case: Northstar Medical Devices

Background

Northstar Medical Devices assembles diagnostic instruments. It holds electronic components, precision machined parts, packaging and service spares. Customer demand is variable, supplier lead times range from two to ten weeks, and the company has experienced both stockouts and excess obsolete components.

Problem

An ABC analysis based only on annual usage value classified a low-cost sensor connector as a C item. However, a single missing connector stopped final assembly. Inventory records also showed frequent discrepancies because engineering changes were not promptly reflected in BOMs.

Analysis

The materials team conducted a multi-criteria review. Annual usage value, production criticality, lead time, supplier concentration, defect history and shelf life were assessed. The connector was reclassified as low-value/high-criticality. Cycle counting was increased, a second supplier was evaluated, and a modest safety stock was authorised after reviewing the cost of line stoppage.

The company also corrected units of measure, created revision-controlled BOMs and required quality release before material became available in the ERP system. MRP parameters were reviewed using actual supplier lead-time data rather than optimistic standard values. Capacity planners began reviewing MRP proposals weekly with production supervisors.

Approach and outcome

The solution combined classification, supplier development, data governance and closed-loop planning. Stockouts of the connector declined, while excess stock was reduced for several obsolete components. The most important improvement was not a particular software function; it was agreement about ownership of item data, engineering changes, quality status and inventory transactions.

Learning points

1. Value-based ABC analysis must be supplemented by operational criticality.
2. Safety stock should reflect the cost of uncertainty and failure, not habit alone.
3. ERP output is only as reliable as its master data and transaction discipline.
4. Quality, engineering, purchasing and operations must jointly govern material information.

11. Implementation Challenges and Contemporary Developments

Common implementation risks include poor data migration, excessive customisation, inadequate training, weak executive sponsorship, unclear process ownership and treating ERP as an IT project rather than an organisational transformation. Change management should include user involvement, role-based training, pilot testing, controlled cutover and post-implementation measurement.

Digital technologies can improve materials management when their use is justified. RFID and IoT sensors can provide location, temperature or usage data. Analytics can identify abnormal consumption, likely shortages and obsolete inventory. Machine-learning forecasts may support demand planning, but they require sufficient historical data, monitoring for bias and human review during structural changes such as product launches or disruptions.

AI-generated recommendations should be explainable enough for planners to challenge them. Automated purchasing should respect approval limits, supplier contracts, segregation of duties and sanctions or regulatory controls. Cybersecurity is also an operations issue: a compromised ERP can alter supplier bank details, inventory records or production plans.

Sustainable materials management considers carbon, water, hazardous substances, repairability, packaging and end-of-life recovery. Lowest purchase price may conflict with lifecycle cost and environmental responsibility. Ethical practice requires accurate reporting, fair supplier treatment, protection of confidential data and avoidance of manipulative inventory targets that encourage concealment of shortages or quality problems.

Chapter Summary

Inventory management balances availability, cost, quality and uncertainty. Inventory may be classified by physical role, demand relationship, value, criticality and risk. ABC analysis focuses attention according to annual usage value but should be combined with criticality and variability. EOQ provides a benchmark order quantity under restrictive assumptions, while the reorder point determines when replenishment should occur. Safety stock protects service against uncertainty, and its size should reflect demand, lead-time variation and the chosen service objective.

MRP converts the MPS, BOM and inventory records into time-phased component plans. Closed-loop MRP adds capacity and execution feedback. ERP integrates materials planning with finance, procurement, sales, quality and other enterprise processes. Successful systems depend on accurate master data, disciplined transactions, process ownership and effective governance. Technology and AI can strengthen visibility and prediction, but they do not replace professional judgement, quality controls or ethical accountability.

Key Terms

ABC analysis: Classification of inventory according to annual usage value.

Annual usage value: Annual demand multiplied by unit cost.

Bill of materials (BOM): Structured list of components and quantities required for a product.

Closed-loop MRP: MRP linked with capacity planning, execution feedback and replanning.

Cycle stock: Inventory arising from ordering or producing in batches.

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

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

Economic Order Quantity (EOQ): Order quantity balancing ordering and holding costs under specified assumptions.

Enterprise Resource Planning (ERP): Integrated system supporting cross-functional enterprise processes and data.

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

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

Lead time: Time between placing an order or initiating activity and receiving the usable output.

Master Production Schedule (MPS): Time-phased plan for producing finished goods or major assemblies.

Materials Requirements Planning (MRP): System for calculating time-phased requirements for dependent-demand items.

Reorder point (ROP): Inventory position at which replenishment is initiated.

Safety stock: Additional inventory held to protect against uncertainty.

Stock-keeping unit (SKU): Distinct identifiable item managed in inventory.

Work-in-process (WIP): Partially completed inventory within the production process.

Review Questions

Short Answer Questions

1. What is the difference between cycle stock and safety stock?
2. Why can an inexpensive item require strict inventory control?
3. Identify the three principal inputs to an MRP system.
4. Define cycle service level and fill rate.
5. State two reasons why ERP data may be unreliable.

Long Answer Questions

1. Explain the objectives and major cost categories of inventory management.
2. Describe the ABC analysis procedure and discuss its limitations.
3. Derive the basic EOQ formula and state its assumptions.
4. Compare MRP, closed-loop MRP and ERP.
5. Explain how quality management and inventory accuracy are related.

Analytical / Application Questions

1. Annual demand is 18,000 units, ordering cost is $25 per order and annual holding cost is $1.80 per unit. Calculate EOQ and explain two practical reasons why the result might be adjusted.
2. Average demand is 70 units per day, lead time is 6 days and safety stock is 150 units. Calculate the reorder point and explain what information should be included in inventory position.
3. Design a control policy for a low-value, safety-critical spare part with intermittent demand and a long supplier lead time. Justify your choices concerning classification, review frequency, suppliers, safety stock and ERP data.

Multiple Choice Questions with Answers

Question 1

Which inventory category consists of items currently undergoing transformation?

A. Raw materials

B. Work-in-process

C. Finished goods

D. Pipeline inventory

Correct Answer: B. Work-in-process

Question 2

Annual usage value is calculated as:

A. Annual demand ÷ unit cost

B. Unit cost ÷ annual demand

C. Annual demand × unit cost

D. Average inventory × lead time

Correct Answer: C. Annual demand × unit cost

Question 3

A basic EOQ model primarily balances:

A. Purchase price and shortage cost

B. Ordering cost and holding cost

C. Quality cost and transport cost

D. Labour cost and tax cost

Correct Answer: B. Ordering cost and holding cost

Question 4

Annual demand is 10,000 units, ordering cost is $50 and annual holding cost is $2 per unit. What is the approximate EOQ?

A. 224 units

B. 500 units

C. 707 units

D. 1,000 units

Correct Answer: C. 707 units

Question 5

If average daily demand is 40 units, lead time is 5 days and safety stock is 60 units, the reorder point is:

A. 140 units

B. 200 units

C. 260 units

D. 300 units

Correct Answer: C. 260 units

Question 6

Which input defines the product structure used by MRP?

A. Bill of materials

B. Supplier invoice

C. Income statement

D. Maintenance log

Correct Answer: A. Bill of materials

Question 7

Closed-loop MRP differs from basic MRP because it includes:

A. Only financial accounting

B. Capacity and execution feedback

C. Only finished-goods sales data

D. Elimination of lead times

Correct Answer: B. Capacity and execution feedback

Question 8

Which statement correctly distinguishes fill rate from cycle service level?

A. They are always identical

B. Fill rate measures the proportion of demand supplied immediately

C. Fill rate measures supplier profit

D. Cycle service level measures annual inventory turnover

Correct Answer: B. Fill rate measures the proportion of demand supplied immediately

Question 9

A low-value item that can stop a production line should generally be:

A. Ignored because it is a C item

B. Controlled only through annual counting

C. Evaluated using criticality as well as value

D. Removed from the BOM

Correct Answer: C. Evaluated using criticality as well as value

Question 10

Which condition most directly threatens ERP planning accuracy?

A. Accurate, revision-controlled BOMs

B. Timely recording of goods receipts

C. Incorrect inventory records and lead times

D. Defined data ownership

Correct Answer: C. Incorrect inventory records and lead times