Inventory & Warehouse Management

Chapter 2
Inventory Classification, Cost and Financial Control

Advance Diploma in Supply Chain Management
Inventory & Warehouse Management   •   Advance Diploma

Inventory Classification, Cost and Financial Control

Introduction and Context

Inventory is the stock of materials, components, work in process, finished goods, spare parts, consumables and merchandise held for future use or sale. It connects purchasing, production, distribution, sales and finance. A warehouse may report a large inventory value while still suffering stockouts of strategically important items; conversely, high availability may be achieved at an uneconomic cost. Effective inventory management therefore requires more than counting units. It requires classification, valuation, cost analysis and financial control.

Inventory classification makes managerial attention selective. Not every item deserves the same forecasting method, review frequency, approval level or physical-security control. Cost analysis shows the economic consequences of ordering, holding, shortages and obsolescence. Financial control ensures that the physical stock recorded in the warehouse agrees with accounting records and that working capital is not unnecessarily tied up.

This chapter develops practical methods appropriate for supply-chain professionals, including ABC, XYZ and FSN analyses, cost calculations, inventory valuation and control design.

Learning Objectives

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

  1. Classify inventory by form, function, demand behaviour and value.
  2. Apply ABC, XYZ and FSN analyses and interpret their combined results.
  3. Calculate relevant holding, ordering, shortage and obsolescence costs.
  4. Explain inventory valuation methods and their financial effects.
  5. Interpret the relationship between inventory, working capital, liquidity and profitability.
  6. Design practical physical and financial controls for inventory.

1. The Nature and Purposes of Inventory

Inventory exists because supply and demand rarely occur at exactly the same time, quantity or location. Firms hold stock to:

  • satisfy anticipated customer demand;
  • decouple production stages and protect process continuity;
  • obtain quantity discounts or exploit transport economies;
  • protect against uncertain demand, replenishment time and supply disruption;
  • support seasonal operations;
  • provide maintenance, repair and operating supplies; and
  • hedge against expected price increases.

These benefits must be balanced against capital commitment, storage space, insurance, handling, deterioration, theft, obsolescence and the risk that demand will not materialise. Inventory is therefore both an operational resource and a financial investment.

Important terminology includes stock keeping unit (SKU), safety stock, cycle stock, pipeline stock, dead stock and stockout. A SKU is a uniquely managed item-location combination. Cycle stock is the normal inventory consumed between replenishments. Safety stock is additional inventory held against uncertainty. Pipeline stock is inventory ordered or in transit but not yet available for use. Dead stock has had no movement for a defined period and may require special investigation.

2. Inventory Classification Frameworks

2.1 Classification by physical form

CategoryMeaningTypical control concern
Raw materialsInputs purchased for processingSupplier quality and lead time
ComponentsPurchased parts incorporated into a productCompatibility and availability
Work in processItems undergoing transformationFlow, quality and production scheduling
Finished goodsCompleted items awaiting sale or dispatchCustomer service and demand risk
MRO suppliesMaintenance, repair and operating itemsCriticality and identification
PackagingMaterials used to protect or present goodsConsumption linked to dispatch

The classification is not always mutually exclusive. A steel sheet may be raw material for one plant and finished goods for a distributor. Classification depends on the organisation's position in the supply chain.

2.2 Classification by function

Functional categories clarify why inventory is held:

  • Cycle stock: created by replenishing in batches.
  • Safety stock: protects against uncertainty.
  • Anticipation stock: accumulated before a seasonal peak, promotion or expected disruption.
  • Decoupling stock: separates dependent operations so that one stoppage does not immediately stop another.
  • Pipeline stock: exists because goods require time to move through the network.
  • Speculative stock: purchased to benefit from expected price or exchange-rate changes.
  • Obsolete or surplus stock: no longer expected to generate normal economic benefit.

A single SKU can have several functional elements. For example, the quantity on hand may consist of cycle stock plus safety stock, while a separate quantity is in transit.

2.3 Classification by demand relationship

Independent demand arises mainly from external customer requirements, such as demand for finished products. Dependent demand is derived from the production plan or bill of materials, such as the number of screws required for a scheduled assembly run. Independent demand is commonly forecast; dependent demand is often calculated through material requirements planning (MRP), provided the bill of materials, inventory records and schedules are accurate.

Demand can also be classified as:

  • Stable: relatively predictable rate and variability.
  • Seasonal: systematic variation by month, quarter or trading season.
  • Intermittent: many periods with zero demand and occasional requirements.
  • Lumpy: intermittent demand with highly variable quantities.
  • Erratic: frequent and substantial variation.

The correct control response depends on both demand pattern and item criticality. A low-value intermittent spare may need a specific service-level policy rather than an automatic forecast based on average demand.

2.4 Classification by value: ABC analysis

ABC analysis ranks items according to annual consumption value (ACV):

ACVi = Di × Ci

where Di is annual demand for item i in units per year and Ci is unit cost in currency per unit. ACV is therefore measured in currency per year. The method normally orders items from highest to lowest ACV and calculates cumulative percentages.

A common, but not universal, policy is:

ClassApproximate share of itemsApproximate share of annual valueTypical policy
A10–20%70–80%Frequent review, accurate records, senior approval
B20–30%15–25%Periodic review and normal controls
C50–70%5–10%Simple replenishment and economical administration

The percentages are heuristics, not laws. ABC measures monetary significance, not operational importance. A cheap fuse can be more critical than an expensive routine item.

Worked example. Four SKUs have the following annual demand and unit cost:

SKUAnnual demandUnit costACV
P1,0005050,000
Q5,000630,000
R2,00048,000
S10,0000.505,000

Total ACV is 93,000. Ranked in descending order, P represents 53.8% of value, P and Q together 86.0%, and all four 100%. Under a locally defined policy, P may be A, Q may be A or B at the boundary, and R and S may be C. The important point is to establish thresholds consistently and review boundary cases.

2.5 XYZ analysis: demand predictability

XYZ analysis classifies items by variability of demand. One common measure is the coefficient of variation (CV):

CV = σ / μ

where σ is the standard deviation of demand and μ is mean demand over the selected periods. Both must use the same units, so CV is dimensionless. It is meaningful when the mean is positive and the time periods are comparable.

Typical local thresholds are X for low variability, Y for moderate or seasonal variability, and Z for high or unpredictable variability. Exact boundaries must be defined by the organisation; they should not be treated as universal. If demand is intermittent and the mean is near zero, CV can become unstable, so alternative measures or judgement are required.

XYZ influences forecasting and safety-stock decisions. X items may support statistical forecasting and lower uncertainty buffers. Z items require closer investigation of demand drivers, supplier responsiveness, minimum order quantities and service-level consequences.

2.6 FSN analysis: movement rate

FSN classifies items as:

  • Fast-moving (F): frequent or high-volume issues;
  • Slow-moving (S): occasional issues; and
  • Non-moving (N): no issue or consumption during a defined review period.

The review period must be stated, for example, no movement for 12 months. FSN is especially useful for warehouse layout, cycle counting, disposal and obsolescence review. It should be based on reliable issue and return records; an item can appear non-moving simply because transactions are not recorded.

2.7 Combined classification

The strongest decisions combine dimensions. An AX item is high value and predictable; it may receive tight replenishment control and statistical planning. An AZ item is high value but unpredictable; it deserves senior review, supplier collaboration and explicit risk analysis. A CX item may be managed with simple rules, while a CZ item may be inexpensive but difficult to forecast.

FSN adds time-based evidence. An AZN item is high-value, highly variable and non-moving: it is a strong candidate for investigation, reservation validation, return to supplier or controlled disposal. Classification should also include criticality, lead time, shelf life, hazard and supplier dependence, because ABC/XYZ/FSN alone cannot represent all risks.

3. Inventory Costs

3.1 Purchase and acquisition cost

Purchase cost includes the supplier price and, depending on the accounting framework and policy, directly attributable costs required to bring inventory to its present location and condition. Freight, duties, inspection and handling may be included in inventory cost, while abnormal waste, selling costs and many administrative expenses are normally treated separately under applicable accounting rules.

3.2 Ordering or setup cost

Ordering cost is the cost per replenishment order, excluding the purchase price. It may include requisition processing, supplier communication, approval, receiving, inspection, invoice matching and payment administration. In manufacturing, the analogous setup cost includes machine preparation and changeover.

If annual demand is D, order quantity is Q, and ordering cost per order is S, the annual ordering cost under constant demand is:

Co = (D / Q) × S

Here D/Q is the number of orders per year. The formula assumes replenishment orders of approximately equal size and excludes purchase price.

3.3 Holding or carrying cost

Holding cost is the cost of retaining inventory. It may include capital cost, storage space, insurance, handling, shrinkage, deterioration and obsolescence risk. If average inventory is Iavg units and annual holding cost per unit is H, then:

Ch = Iavg × H

For a basic order quantity system with no safety stock and instantaneous replenishment, average cycle stock is Q/2, so:

Ch = (Q / 2) × H

If safety stock is SS, a more realistic approximation is:

Ch = (Q / 2 + SS) × H

This assumes cycle stock and safety stock are additive and stable. If inventory is tracked in currency, average inventory value can be multiplied by an annual carrying-rate percentage.

The carrying rate is often represented as:

r = rc + rs + ri + rh + ro

where rc is capital or opportunity cost, rs storage cost, ri insurance and tax cost, rh handling and shrinkage cost, and ro obsolescence and deterioration allowance. The components must not be double-counted.

3.4 Shortage costs

Shortage cost arises when demand cannot be met from available stock. It can include emergency freight, expediting, lost margin, production downtime, contractual penalties, customer dissatisfaction and reputational damage. Some costs are measurable and others are estimates; managers should document assumptions rather than present uncertain effects as precise facts.

A simple expected shortage-cost expression is:

E(Cs) = E(Ns) × cs

where E(Ns) is expected shortage quantity during the period and cs is shortage cost per unit. This is a simplified model and should be adapted when shortage cost differs by customer, time or consequence.

3.5 Obsolescence and deterioration

Obsolescence occurs when inventory loses economic usefulness because of technological change, expiry, fashion, regulatory change, damage or discontinued demand. A practical expected loss estimate is:

E(Cob) = Po × Vrisk

where Po is the estimated probability of obsolescence during the relevant horizon and Vrisk is the recoverable-risk value exposed. The estimate is managerial, not a universal accounting formula. Accounting provisions and write-downs must follow the applicable reporting framework and evidence.

3.6 Total relevant inventory cost

For a decision period, a useful analytical model is:

TC = Cp + Co + Ch + E(Cs) + E(Cob)

where Cp is purchase cost, Co ordering cost, Ch holding cost, E(Cs) expected shortage cost and E(Cob) expected obsolescence cost. The model is only as good as its definitions. For example, purchase cost may be constant across order quantities and therefore irrelevant to an order-size comparison, while it remains relevant to total spend and valuation.

4. Economic Order Quantity and Its Limits

Under the basic EOQ assumptions—known constant demand, constant unit price, fixed ordering cost, constant holding cost, immediate replenishment, no shortages and no quantity discounts—the order quantity that minimises ordering plus cycle-stock holding cost is:

Q* = √(2DS / H)

where Q* is optimal order quantity in units per order, D annual demand in units per year, S ordering cost in currency per order and H annual holding cost in currency per unit per year. Unit consistency gives units per order because DS/H has units of units².

Worked example. Annual demand is 12,000 units, ordering cost is 40 currency units per order and holding cost is 2 currency units per unit per year.

Q* = √[(2 × 12,000 × 40) / 2] = √480,000 ≈ 692.8 units

The practical order quantity is approximately 693 units. Annual ordering cost is approximately (12,000/692.8)×40 = 692.8 currency units, and annual cycle-stock holding cost is approximately (692.8/2)×2 = 692.8 currency units. Their equality is a property of the basic EOQ optimum, not a general rule for every inventory system.

EOQ should not be applied mechanically where demand is intermittent, prices change by quantity, replenishment is capacity-constrained, shelf life is short, shortages are unacceptable or lead time is highly uncertain. In such settings, periodic review, min–max policies, MRP, service-level models or constrained optimisation may be more appropriate.

5. Inventory Valuation and Financial Reporting

Inventory valuation determines the amount reported as an asset before sale and the cost transferred to cost of sales when inventory is issued. Under widely used financial-reporting principles, inventory is generally measured at the lower of cost and net realisable value (NRV), subject to the applicable jurisdiction and reporting standard. NRV is the estimated selling price in the ordinary course of business less estimated costs of completion and costs necessary to make the sale.

Cost may include purchase costs, conversion costs and other costs incurred to bring inventory to its present location and condition. Common cost-flow methods include:

  • Specific identification: assigns actual cost to individually identifiable items; useful for unique, high-value goods.
  • FIFO (first in, first out): issues the oldest cost layers first in the accounting calculation.
  • Weighted average: assigns an average cost to units available for issue.

LIFO is not permitted under IFRS, although it may be permitted in some other reporting regimes. Physical flow need not exactly match the accounting cost-flow assumption, but the chosen method must be applied consistently and disclosed as required.

Illustrative valuation example. A business buys 100 units at 10 currency units and later 100 units at 14. It issues 150 units. Under FIFO, cost of sales is (100×10)+(50×14)=1,700, and closing inventory is 50×14=700. The total cost available is 2,400, so the accounting identity holds: cost of sales plus closing inventory equals 2,400. Under weighted average, average unit cost is 12, cost of sales is 1,800 and closing inventory is 600. In a period of rising prices, FIFO generally reports lower cost of sales and higher closing inventory than weighted average, though tax and reporting effects depend on the applicable rules.

Physical stock records should distinguish quantity, location, status, ownership and unit cost. Consignment stock, customer-owned materials, goods in transit and inventory held by third parties require clear ownership and cut-off procedures.

6. Working Capital and Financial Control

Working capital is commonly expressed as:

Net working capital = Current assets − Current liabilities

Inventory is a current asset, but it is less liquid than cash and usually less immediately convertible than receivables. Excess inventory increases capital tied up, storage cost and risk. Insufficient inventory may reduce assets but create lost sales, downtime and emergency procurement.

Useful performance indicators include:

Inventory turnover = Cost of sales / Average inventory
Days inventory outstanding = Average inventory / Cost of sales × 365

The first ratio is measured in turns per year; the second in days. Average inventory should normally be calculated consistently, for example as opening plus closing inventory divided by two, or by using more frequent observations where seasonality is material. A high turnover is not automatically good if it reflects chronic stockouts; a low turnover is not automatically bad if strategic safety stock is justified.

Financial control should integrate the following:

  1. Authorisation: approved purchasing limits, supplier controls and segregation of duties.
  2. Custody: restricted access, secure storage, identification and location discipline.
  3. Recording: timely receipts, issues, transfers, returns and adjustments.
  4. Reconciliation: comparison of physical counts, warehouse records, perpetual ledgers and the general ledger.
  5. Review: ageing, slow-moving stock, negative balances, unusual adjustments and obsolete items.
  6. Cut-off: correct treatment of goods received, dispatched and in transit at period end.

Cycle counting is often superior to relying solely on an annual wall-to-wall count. A-items and high-risk items may be counted more frequently, while C-items may be counted less frequently. Variances should be investigated for root causes such as incorrect units of measure, unauthorised issues, duplicate item codes, receiving errors, damage or system timing problems.

7. Applied Case: Meridian Medical Devices (Illustrative)

Background

Meridian Medical Devices distributes diagnostic equipment and replacement parts. It holds 4,800 SKUs across two warehouses. Finance reports that inventory increased by 22% in one year while sales increased by only 5%. Customer service nevertheless reports shortages of several critical replacement parts.

Problem

The company uses one replenishment rule for all SKUs. Item descriptions are duplicated, demand history contains returns and transfers, and obsolete parts remain valued at original cost. Managers want to reduce working capital without damaging service.

Analysis

The supply-chain team first cleans item masters and separates customer-owned, quarantined and available stock. It calculates ACV for each SKU, demand variability using comparable monthly observations, and movement status over the preceding 12 months. It then adds a criticality flag based on whether a stockout can stop a customer’s medical equipment.

The resulting matrix identifies three distinct groups:

  • high-value predictable items requiring close replenishment and executive visibility;
  • high-value unpredictable items requiring supplier collaboration and explicit service-level decisions; and
  • low-value but critical spare parts requiring availability protection despite their C-class value.

An ageing review finds that 9% of inventory value has had no movement for 12 months. Technical staff confirm that part of this stock supports discontinued equipment, while another portion is usable but stored under duplicate codes.

Approach and solution

Meridian adopts the following controls:

  • ABC/XYZ/FSN classification is refreshed quarterly and after major product changes.
  • AZ items receive monthly exception review rather than automatic large replenishment.
  • Critical C-items receive minimum availability targets and supplier lead-time monitoring.
  • Duplicate codes are consolidated after engineering approval.
  • Obsolete items are segregated, documented and assessed for return, repair, alternative use or write-down.
  • Cycle counts are scheduled by value and risk, not only by physical convenience.
  • Purchase orders require approved quantities and prices; receiving and invoice approval are segregated.
  • A dashboard reports inventory value, service level, aged stock, adjustments, turnover and root causes of variance.

Outcome

After two review cycles, the company reduces non-moving stock through approved returns and controlled disposal, while protecting critical spare availability. The important result is not a universal percentage reduction; it is a better alignment between inventory policy, operational criticality and financial evidence.

Learning points

Classification is useful only when it changes decisions. Financial control cannot compensate for poor item data, and a reduction in inventory is not a success if it causes service failure. The case also demonstrates why value, variability, movement and criticality should be interpreted together.

8. Technology, Governance and Contemporary Practice

Warehouse management systems, enterprise resource planning systems, barcode scanning and radio-frequency identification improve transaction accuracy and location visibility. Analytics can identify abnormal consumption, duplicate materials and ageing patterns. Machine-learning forecasts may assist where data quality and demand volume are adequate, but they do not remove the need for human review, especially for intermittent demand, new products and critical parts.

Good governance requires traceability of adjustments, role-based access, audit logs and protection of commercially sensitive data. Automated recommendations should be explainable enough for managers to challenge them. A system that optimises carrying cost while ignoring patient safety, product recalls or contractual service obligations is not a sound control system.

Sustainability also affects classification and cost. Excess stock consumes energy and materials; disposal may create environmental liabilities. Reverse logistics, repair, remanufacturing, reuse and supplier take-back schemes can reduce both financial and environmental waste. However, reuse decisions must comply with quality, safety and regulatory requirements.

Chapter Summary

Inventory must be classified in ways that support decisions. Form distinguishes raw materials, work in process, finished goods and supplies; function explains why stock is held; demand classification distinguishes independent, dependent, stable, seasonal and intermittent requirements; and value classification supports selective control. ABC ranks annual consumption value, XYZ assesses demand variability, and FSN identifies movement. These methods are complementary rather than complete, so criticality, shelf life and supply risk should also be considered.

Inventory cost includes acquisition, ordering, holding, shortage and obsolescence effects. The basic EOQ model balances ordering and cycle-stock holding costs under restrictive assumptions and must not be applied mechanically. Valuation methods such as specific identification, FIFO and weighted average affect reported cost of sales and closing inventory, while lower-of-cost-and-NRV principles protect against overstated assets where applicable. Inventory influences working capital, liquidity and profitability, making accurate records, authorisation, custody, reconciliation, cycle counting and ageing review essential. Technology can strengthen control, but data quality, governance and professional judgement remain fundamental.

Key Terms

Inventory: Stock held for use, transformation or sale.

SKU: A uniquely managed item-location combination.

Cycle stock: Inventory created by replenishment in batches.

Safety stock: Additional inventory held against uncertainty.

Pipeline stock: Inventory in transit or moving through a supply network.

Independent demand: Demand arising mainly from external customers.

Dependent demand: Demand derived from a production plan or bill of materials.

ABC analysis: Classification by annual consumption value.

XYZ analysis: Classification by demand variability or predictability.

FSN analysis: Classification into fast-, slow- and non-moving items.

Annual consumption value: Annual demand multiplied by unit cost.

Carrying cost: Cost of holding inventory over time.

Ordering cost: Cost incurred each time replenishment is placed.

Shortage cost: Cost arising when required inventory is unavailable.

Obsolescence: Loss of economic usefulness caused by change, expiry or deterioration.

EOQ: Basic economic order quantity that minimises ordering plus cycle-stock holding cost under stated assumptions.

Net realisable value: Expected selling price less completion and selling costs.

Inventory turnover: Cost of sales divided by average inventory.

Cycle counting: Planned counting of selected inventory throughout the year.

Working capital: Current assets less current liabilities.

Review Questions

Short Answer Questions

  1. Distinguish cycle stock from safety stock.
  2. What does ABC analysis measure, and what does it not measure?
  3. Define the coefficient of variation and explain why it is used in XYZ analysis.
  4. Identify four components that may form part of carrying cost.
  5. Why is physical inventory reconciliation important for financial control?

Long Answer Questions

  1. Explain how form, function, demand, value and movement classifications support different inventory decisions.
  2. Describe the assumptions of the basic EOQ model and discuss situations in which it may be inappropriate.
  3. Compare FIFO, weighted average and specific identification as inventory cost-flow methods.
  4. Explain how inventory affects working capital, liquidity, profitability and customer service.
  5. Design a financial-control system covering authorisation, custody, recording, counting, reconciliation and ageing review.

Analytical / Application Questions

  1. An item has annual demand of 18,000 units, ordering cost of 30 currency units per order and annual holding cost of 3 currency units per unit. Calculate the basic EOQ and explain two practical factors that could make the recommended quantity different.
  2. A warehouse has an inexpensive spare part with highly variable demand and severe consequences when unavailable. Explain how ABC, XYZ, FSN and criticality classifications should jointly influence its policy.
  3. A company’s inventory turnover rises sharply while customer complaints about stockouts increase. Analyse at least three possible explanations and recommend indicators that management should review before celebrating the improvement.

Multiple Choice Questions with Answers

Question 1

Which measure is used to rank items in ABC analysis?

A. Annual consumption value

B. Number of warehouse locations

C. Supplier distance

D. Physical volume only

Correct Answer: A. Annual consumption value

Question 2

Annual demand is 10,000 units and unit cost is 6 currency units. What is annual consumption value?

A. 600 currency units

B. 1,667 currency units

C. 16,000 currency units

D. 60,000 currency units

Correct Answer: D. 60,000 currency units

Question 3

In XYZ analysis, the coefficient of variation is calculated as:

A. Mean divided by standard deviation

B. Standard deviation divided by mean

C. Demand divided by unit cost

D. Annual value divided by demand

Correct Answer: B. Standard deviation divided by mean

Question 4

Which item is most likely to be classified as non-moving in FSN analysis?

A. An item issued every day

B. An item issued weekly

C. An item with no recorded issue during the defined review period

D. An item received yesterday

Correct Answer: C. An item with no recorded issue during the defined review period

Question 5

Under the basic EOQ model, which two costs are balanced?

A. Purchase cost and tax cost

B. Ordering cost and cycle-stock holding cost

C. Shortage cost and selling cost

D. Insurance cost and revenue

Correct Answer: B. Ordering cost and cycle-stock holding cost

Question 6

Annual demand is 12,000 units, ordering cost is 40 per order and holding cost is 2 per unit per year. What is the approximate EOQ?

A. 245 units

B. 490 units

C. 693 units

D. 1,200 units

Correct Answer: C. 693 units

Question 7

Which classification identifies demand as predictable or unpredictable?

A. FSN

B. XYZ

C. FIFO

D. MRO

Correct Answer: B. XYZ

Question 8

Under FIFO, if 100 units at 10 and 100 units at 14 are available and 150 units are issued, what is the closing inventory value?

A. 500

B. 600

C. 700

D. 2,400

Correct Answer: C. 700

Question 9

Inventory turnover is commonly calculated as:

A. Average inventory divided by cost of sales

B. Cost of sales divided by average inventory

C. Sales divided by current liabilities

D. Annual demand divided by ordering cost

Correct Answer: B. Cost of sales divided by average inventory

Question 10

Which control most directly verifies that recorded stock agrees with stock physically held?

A. Supplier advertising review

B. Physical counting and reconciliation

C. Increasing order quantities

D. Reducing warehouse lighting

Correct Answer: B. Physical counting and reconciliation

Inventory & Warehouse Management
Chapter 2 of 14