Logistics Costing & Budgeting

Chapter 8
Inventory Costing and Working-Capital Economics

Post Graduate Program in Logistics
Logistics Costing & Budgeting   •   Post Graduate

Inventory Costing and Working-Capital Economics

Introduction and context

Inventory is both a service asset and a financial commitment. It enables a logistics system to meet demand despite supplier lead times, transport variability, minimum order quantities and uncertain customer requirements. At the same time, inventory absorbs cash, occupies space, creates handling work and may lose value before sale or use. Inventory costing therefore cannot be reduced to the purchase price recorded in an accounting system. A logistics manager must understand the total economic cost of owning and replenishing stock and must connect operational decisions with cash flow, profitability and risk.

This chapter develops an integrated approach to acquisition, ordering, carrying, shortage, obsolescence, shrinkage and reverse-logistics costs. It then applies economic order quantity (EOQ), reorder-point, safety-stock, service-level and total-landed-cost models. The final sections examine inventory’s effect on working capital and show how operational controls can improve both customer service and financial performance.

Learning objectives

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

  1. Classify the principal costs associated with inventory and distinguish accounting cost from relevant economic cost.
  2. Apply EOQ and reorder-point models, explaining their assumptions and limitations.
  3. Relate safety stock to demand, lead-time variability and customer-service objectives.
  4. Calculate total landed cost and evaluate sourcing alternatives.
  5. Analyse shortage, obsolescence, shrinkage and reverse-logistics costs.
  6. Interpret inventory’s effects on cash conversion, working capital and return on investment.
  7. Design governance and technology practices that improve inventory-cost decisions.

1. The economics of inventory

Inventory creates value when it makes a required product available at the required place and time. Its economic purpose is to decouple stages of a supply chain and protect service against uncertainty. However, each additional unit has an opportunity cost: cash tied up in stock cannot be used for debt reduction, investment or other operating needs.

A useful distinction is between stockholding decisions and flow decisions. Stockholding decisions determine how much inventory is present and where it is positioned. Flow decisions determine when and how much is ordered, produced, transferred or returned. Costing must evaluate both.

1.1 Inventory categories

Common categories include:

  • Cycle stock: inventory expected to meet demand between replenishments.
  • Safety stock: additional inventory held against uncertainty.
  • Pipeline inventory: stock in transit or otherwise committed but not yet available.
  • Anticipation stock: inventory accumulated for predictable peaks, promotions or supply interruptions.
  • Decoupling stock: inventory separating processes with different capacities or schedules.
  • Obsolete or dead stock: inventory unlikely to generate normal economic benefit.
  • Returns inventory: products moving through inspection, repair, resale, recycling or disposal.

These categories should be visible in management reports. Treating all units as equivalent can conceal excessive safety stock, slow-moving goods or a costly returns stream.

2. Inventory cost architecture

2.1 Acquisition and purchase cost

Acquisition cost normally includes the supplier invoice price less valid discounts, plus directly attributable costs needed to bring goods to the required location and condition. Depending on the accounting framework and policy, freight, insurance, customs duties, non-recoverable taxes, inspection and handling may be included in inventory cost. Recoverable taxes are generally not an economic cost of the inventory.

The managerial question is broader than the accounting entry. A low invoice price may be offset by high minimum quantities, unreliable delivery, damage, quality failures or expensive inbound transport.

2.2 Ordering and setup cost

Ordering cost is the cost that varies with the number of replenishment events rather than with the number of units. It can include requisition processing, supplier qualification, purchase-order administration, receiving, inspection, invoice matching and production setup. Some costs are fixed per order; others are step-fixed or partly variable. The EOQ model uses an average order cost, but managers should test whether that approximation is credible.

2.3 Carrying or holding cost

Carrying cost includes:

  • capital or financing cost;
  • warehouse space, utilities and material-handling cost;
  • insurance, security and information-system cost;
  • damage, deterioration, expiry and obsolescence;
  • taxes or fees linked to possession; and
  • internal administration associated with stock control.

If annual holding cost per unit is expressed as H = iC, then i is the annual carrying-rate fraction and C is the relevant unit value. The rate may be calculated as an economic estimate rather than copied mechanically from an accounting budget. For example, a high-value electronic component with rapid technological change may require a materially higher risk allowance than a stable commodity.

2.4 Shortage and service-failure cost

A shortage may cause a backorder, lost sale, production stoppage, emergency shipment, contractual penalty or reputational damage. The relevant cost depends on the customer and the consequence. A lost sale is not necessarily equal to the selling price: the avoidable contribution margin, recovery probability and strategic customer effect matter.

Shortage cost is difficult to estimate because many consequences are indirect. A sound costing system records the immediate event and periodically estimates downstream effects using customer, order and service data.

2.5 Obsolescence and deterioration

Obsolescence occurs when inventory loses economic usefulness through technological change, fashion, regulation, product substitution or expiry. Deterioration includes physical damage, contamination and reduced quality. Expected loss can be estimated as:

Expected loss = Probability of loss × Exposure if loss occurs

The expression is useful for planning but does not eliminate the need for accounting impairment tests, write-downs or provisions required by the applicable reporting framework. Forecasts should distinguish normal ageing from exceptional events.

2.6 Shrinkage

Shrinkage is the difference between recorded and physically available inventory arising from theft, miscounting, process error, damage, scanning failure or unrecorded consumption. A basic shrinkage rate is:

Shrinkage rate = (Book quantity − Physical quantity) ÷ Book quantity

The denominator must be defined consistently. Shrinkage should be analysed by location, product, process, shift and transaction type rather than treated as an unexplained general percentage.

2.7 Reverse-logistics cost

Returns create costs for authorization, collection, transport, inspection, repackaging, repair, refurbishment, resale, recycling and disposal. The economic value of a returned item depends on its recovery route and timing. A returned product may be worth more when rapidly tested and resold than when held for a later batch. Reverse-logistics analysis should therefore include recovery value and not only return-handling expenditure.

3. Costing methods and decision relevance

Financial inventory valuation and managerial decision costing serve related but different purposes. First-in, first-out (FIFO), weighted-average costing and other permitted methods assign accounting values to inventory flows. They support reporting and control but do not automatically identify the cost relevant to a replenishment decision.

For a decision, managers should ask:

  1. Which costs change if the decision changes?
  2. Which costs are avoidable in the relevant time horizon?
  3. What service, risk and cash consequences are created?
  4. Are taxes, transfer prices or accounting allocations distorting the comparison?

For example, an allocated warehouse rent may not change when one additional pallet is purchased this month. It may nevertheless be relevant over a longer horizon if the purchase triggers a new facility or shift. Cost relevance is therefore time- and decision-dependent.

4. Economic order quantity

The basic EOQ model determines the replenishment quantity that balances ordering and cycle-stock carrying costs. With constant demand and instantaneous replenishment, the annual relevant cost is:

TC(Q) = (D ÷ Q)S + (Q ÷ 2)H

where:

  • Q = order quantity, in units per order;
  • D = annual demand, in units per year;
  • S = ordering or setup cost, in currency per order;
  • H = annual holding cost, in currency per unit per year;
  • TC(Q) = annual relevant ordering plus cycle-stock holding cost.

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

Q* = √(2DS ÷ H)

At Q = Q*, annual ordering cost equals annual cycle-stock holding cost. This is a property of the basic model, not a universal rule for real inventories.

Assumptions and applicability. The model assumes known and steady demand, constant unit price, fixed order cost, constant holding cost, immediate and complete replenishment, no shortages, and no quantity discounts. It is most useful as a benchmark. Quantity discounts, capacity limits, stochastic demand, multiple items competing for space and supplier constraints require extensions or simulation.

Worked example: EOQ

A distributor sells 24,000 units per year. The administrative and receiving cost is £75 per order, and annual holding cost is £2.50 per unit.

Q* = √[(2 × 24,000 × 75) ÷ 2.50]
= √1,440,000
= 1,200 units per order

Orders per year are D ÷ Q = 24,000 ÷ 1,200 = 20. Annual ordering cost is 20 × £75 = £1,500. Average cycle stock is Q ÷ 2 = 600 units, so annual cycle-stock carrying cost is 600 × £2.50 = £1,500. The relevant annual total is therefore £3,000, excluding purchase expenditure, safety stock and shortage costs.

If supplier lead time is five working days and demand is stable at 100 units per working day, the reorder point without safety stock is:

ROP = dL

where d is demand per time unit and L is lead time in the same time unit. Thus, ROP = 100 × 5 = 500 units. This is a trigger level, not an order quantity.

5. Safety stock, uncertainty and service levels

Safety stock protects against demand and/or lead-time uncertainty. It should be linked to a clearly defined service measure. Cycle service level is the probability of not experiencing a stockout during a replenishment cycle. Fill rate is the proportion of demand supplied immediately from available stock. These measures are not interchangeable.

For variable demand with approximately normal demand during a fixed lead time, a common model is:

ROP = μL + zσL

where μL is mean demand during lead time, σL is the standard deviation of lead-time demand, and z is the standard-normal safety factor associated with the target cycle service level. Safety stock is zσL.

If demand per period has standard deviation σd and lead time is a constant L periods, then:

σL = σd√L

If demand and lead time are both variable, with independent demand across periods, mean demand per period μd, demand standard deviation σd, mean lead time μL and lead-time standard deviation σL, a widely used approximation is:

σDL = √(μLσd² + μd²σL²)

This approximation assumes independence and uses the mean lead time in the demand-variance component. If demand and lead time are correlated, the covariance term should be considered; if distributions are highly skewed or intermittent, simulation or empirical quantiles may be preferable.

Worked example: safety stock

Daily demand has mean 100 units and standard deviation 20 units. Lead time is constant at five days. The desired cycle service level is 95%, for which z ≈ 1.645.

μL = 100 × 5 = 500 units
σL = 20√5 ≈ 44.72 units
Safety stock = 1.645 × 44.72 ≈ 73.6 units
ROP ≈ 500 + 73.6 = 573.6 units

A practical policy would set the reorder point at approximately 574 units, subject to rounding, review frequency and data quality. The result does not mean that 95% of all demand will always be filled; it refers to the model’s cycle-service interpretation.

Increasing the target service level raises safety stock nonlinearly because the normal-distribution factor rises progressively in the upper tail. Managers should compare the incremental carrying cost with the incremental shortage cost and customer value.

6. Total landed cost and sourcing decisions

Total landed cost (TLC) evaluates the cost of acquiring a product at the point where it becomes available for use or sale. A general structure is:

TLC per unit = Purchase price + Inbound freight + Duties and non-recoverable taxes + Insurance + Handling + Quality cost + Expected loss − Allowable credits

The terms must be defined for the decision. Quality cost may include inspection, rework and supplier failure; expected loss may include damage, shrinkage and obsolescence attributable to the sourcing choice. Pipeline inventory and financing may also be included when lead-time differences materially affect cash or service.

Supplier comparison example

Supplier A quotes £48 per unit, freight £2.40, duty £1.60 and inspection £0.50. Supplier B quotes £46.50, freight £4.20, duty £1.60 and inspection £1.20. Expected damage and rework are £0.80 for A and £1.50 for B.

A’s landed cost is £53.30 per unit; B’s is £55.00 per unit. Supplier B’s invoice price is lower, but its total economic cost is higher by £1.70. If B provides substantially shorter or more reliable lead time, the analysis should add the value of reduced safety stock and shortage exposure before a final decision.

7. Inventory and working-capital economics

Working capital is commonly analysed through operating current assets and liabilities. A practical operating measure is:

Net operating working capital = Inventory + Trade receivables − Trade payables

Inventory days are often expressed as:

Inventory days = Average inventory ÷ Cost of goods sold × 365

The cash conversion cycle is:

CCC = DIO + DSO − DPO

where DIO is days inventory outstanding, DSO is days sales outstanding and DPO is days payable outstanding. The 365-day convention should be used consistently; some organisations use 360 days for management reporting.

Inventory reduction releases cash only when it reduces actual purchases or enables disposal, sale or avoidance of future expenditure. Reclassifying stock, delaying receipts or increasing payables does not necessarily create sustainable value. Equally, cutting inventory below a viable service level may reduce reported assets while increasing expedites, lost sales and customer churn.

Cash-flow illustration

Suppose average inventory is £2.4 million and annual cost of goods sold is £14.6 million. Inventory days are approximately:

DIO = £2.4m ÷ £14.6m × 365 ≈ 60.0 days

A sustainable reduction of ten inventory days would release approximately:

Cash released ≈ £14.6m ÷ 365 × 10 = £400,000

This is an approximation. Actual cash release depends on purchasing patterns, supplier terms, taxes, demand, write-downs and whether inventory can be sold without reducing service.

Useful performance measures include inventory turnover, gross margin return on inventory investment (GMROII), working-capital return, fill rate, forecast bias, forecast error, ageing profile, write-off rate and return recovery rate. No single measure is sufficient: high turnover can reflect understocking, while high service can be purchased at economically excessive stock levels.

8. Integrated case: Northstar Medical Distribution

The following is an illustrative case, constructed for educational purposes.

Background

Northstar distributes a temperature-sensitive medical consumable. Annual demand is 36,000 units. Demand averages 120 units per working day with a daily standard deviation of 30 units. Supplier lead time averages six working days and has a standard deviation of two days. Unit purchase price is £18. The company estimates annual carrying cost at 24% of unit value, or £4.32 per unit. Ordering cost is £90 per order. The current policy uses a reorder point of 1,050 units and frequently relies on emergency freight.

Problem

Finance reports rising inventory and cash pressure, while operations reports shortages. A supplier comparison based only on invoice price favours an overseas source, but that source has longer and more variable lead time. Returns also increase because temperature excursions occur during transport.

Analysis

EOQ is:

Q* = √[(2 × 36,000 × 90) ÷ 4.32] ≈ 1,225 units

Assuming independent demand and lead time, the standard deviation of lead-time demand is approximated by:

σDL = √(6 × 30² + 120² × 2²)
= √(5,400 + 57,600)
= √63,000 ≈ 251.0 units

For a 95% cycle service level, safety stock is approximately 1.645 × 251.0 = 413 units. Mean lead-time demand is 120 × 6 = 720 units, so the recommended reorder point is approximately 1,133 units. The existing 1,050-unit trigger is lower than this modelled requirement, although actual policy must consider the product’s criticality and non-normal demand.

The analysis also identifies a possible misconception: reducing the reorder point alone could lower stock but would increase shortage risk. Northstar should instead improve supplier reliability, monitor temperature compliance and segment the item by clinical criticality. If lead-time variability falls, safety stock can decrease without sacrificing the same service objective.

Approach and solution

Northstar adopts the following controls:

  • a pilot order quantity close to 1,225 units, subject to expiry and cold-chain capacity;
  • separate service targets for critical and non-critical customers;
  • a reorder-point calculation based on current demand and lead-time data;
  • supplier scorecards covering price, reliability, temperature excursions, damage and response time;
  • lot-level expiry tracking and FEFO (first-expired, first-out) picking;
  • an approved reverse-logistics route for inspection, quarantine, recovery and disposal;
  • monthly reconciliation of physical stock, system stock and temperature records; and
  • a working-capital dashboard combining DIO, fill rate, emergency freight and write-offs.

Outcome and learning points

The case demonstrates that EOQ does not determine the complete policy. It addresses a replenishment trade-off, while safety stock addresses uncertainty and service, and total landed cost addresses sourcing economics. A financially credible solution must also account for expiry, quality, reverse logistics, cold-chain risk and the cash impact of inventory. The best decision is not necessarily the one with the lowest purchase price or lowest stock level; it is the one that produces the best risk-adjusted service and cash outcome.

9. Governance, technology and contemporary practice

Inventory decisions require governance because inaccurate master data and weak transaction discipline can invalidate sophisticated models. Essential controls include approved item masters, units-of-measure governance, cycle counting, segregation of duties, authorization for adjustments, documented write-off approval and reconciliation between warehouse, purchasing and finance systems.

Warehouse-management systems, barcode scanning, RFID, IoT temperature sensors and electronic proof of delivery can improve event visibility. Advanced planning systems can estimate demand distributions, simulate service levels and identify excess and obsolete stock. AI and machine-learning models may improve forecasts or anomaly detection, but they do not remove the need for causal review, bias monitoring, explainability and human accountability. A model trained on stockout-censored demand may underestimate true demand because observed sales were constrained by unavailable inventory.

Contemporary practice increasingly combines:

  • multi-echelon inventory optimisation rather than isolated location-level targets;
  • probabilistic forecasts and quantile-based replenishment;
  • supplier collaboration and shared demand signals;
  • circular-economy recovery, repair and resale;
  • carbon-aware sourcing and transport decisions; and
  • scenario analysis for disruption, geopolitical risk and climate events.

Technology should be evaluated through measurable outcomes—service, cash, total cost, data quality and resilience—not through adoption alone.

10. Limitations and managerial judgement

Models simplify reality. Demand may be intermittent, seasonal, promotional or substitution-driven. Lead times may be censored by expedites. Holding cost is partly uncertain, and shortage costs are often strategic rather than directly observable. EOQ may recommend a quantity that conflicts with vehicle capacity, supplier packaging, shelf life or warehouse labour. Normal-distribution safety-stock models can be inappropriate for slow-moving items or heavy-tailed demand.

Accordingly, managers should segment inventory using value, criticality, demand pattern, lead-time risk and obsolescence exposure. They should validate assumptions with actual transaction data, conduct sensitivity analysis and review policies after structural changes. A decision-quality model is transparent about uncertainty and supports judgement; it does not disguise judgement behind false precision.

Ethically, organisations should not manipulate inventory classifications to conceal ageing stock, defer write-downs or meet short-term performance targets. Accurate reporting, traceability, safe disposal and responsible treatment of returned products are both governance obligations and sources of long-term operational trust.

Chapter Summary

Inventory creates service and supply-chain flexibility but consumes cash and generates ordering, carrying, shortage, obsolescence, shrinkage and reverse-logistics costs. EOQ balances ordering cost against cycle-stock holding cost under restrictive assumptions. Reorder points combine expected lead-time demand with safety stock, while service-level measures must be defined carefully because cycle service and fill rate are different. Total landed cost extends analysis beyond invoice price to freight, duties, quality, loss and recovery effects. Inventory influences working capital through inventory days and the cash conversion cycle; sustainable reduction releases cash only when it changes real economic flows. Effective practice combines quantitative models with segmentation, governance, accurate data, technology, supplier management and managerial judgement.

Key Terms

Inventory: Goods held for sale, production, support or distribution.

Cycle stock: Inventory expected to be consumed between replenishments.

Safety stock: Additional stock held against uncertainty.

Pipeline inventory: Stock committed or in transit but not yet available.

Ordering cost: Cost incurred per replenishment order or setup.

Carrying cost: Cost of financing, storing, insuring and risking inventory.

Shortage cost: Economic consequence of unavailable stock.

Obsolescence: Loss of economic usefulness due to technological, market or regulatory change.

Shrinkage: Difference between recorded and physically available inventory.

Reverse logistics: Movement and recovery of returned, repaired, recycled or disposed products.

EOQ: Order quantity that minimises basic ordering plus cycle-stock holding cost.

Reorder point: Inventory position at which replenishment is initiated.

Lead-time demand: Demand expected during replenishment lead time.

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

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

Total landed cost: Cost of acquiring and making a product available at the relevant destination.

DIO: Days inventory outstanding, a measure of inventory investment relative to cost of sales.

Cash conversion cycle: Time between cash outflow for inputs and cash collection from customers.

FEFO: First-expired, first-out inventory issuing method.

GMROII: Gross margin return on inventory investment.

Review Questions

Short Answer Questions

  1. Distinguish cycle stock from safety stock.
  2. What costs are represented by the two terms in the basic EOQ total-cost equation?
  3. Why are cycle service level and fill rate not interchangeable?
  4. Define shrinkage and identify two possible causes.
  5. Explain why invoice price may be an inadequate basis for supplier selection.

Long Answer Questions

  1. Explain the principal components of inventory carrying cost and discuss how each may affect replenishment policy.
  2. Derive the basic EOQ expression from the annual ordering and holding-cost relationship, stating its assumptions.
  3. Discuss how demand and lead-time uncertainty should influence safety-stock policy and service-level selection.
  4. Analyse the relationship between inventory, inventory days and the cash conversion cycle.
  5. Evaluate the role of technology and governance in improving inventory-cost accuracy.

Analytical / Application Questions

  1. Annual demand is 18,000 units, ordering cost is £60 per order and annual holding cost is £3 per unit. Calculate EOQ, annual order frequency and annual ordering cost at EOQ.
  2. Mean daily demand is 80 units, daily standard deviation is 15 units, and lead time is constant at four days. Using z = 1.645, calculate safety stock and reorder point.
  3. A supplier’s low invoice price is accompanied by higher freight, damage and lead-time variability. Design a total-landed-cost and working-capital analysis to decide whether the supplier should be selected.

Multiple Choice Questions with Answers

Question 1

In the basic EOQ model, which cost is assumed to occur per replenishment order?

A. Ordering cost

B. Annual holding cost per unit

C. Unit purchase price

D. Shortage cost per lost sale

Correct Answer: A. Ordering cost

Question 2

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

A. 500 units

B. 707 units

C. 1,000 units

D. 2,500 units

Correct Answer: C. 1,000 units

Question 3

If daily demand is 80 units and lead time is five days, with no safety stock, what is the reorder point?

A. 16 units

B. 85 units

C. 400 units

D. 4,000 units

Correct Answer: C. 400 units

Question 4

What does safety stock primarily protect against?

A. Known unit purchase prices

B. Demand and lead-time uncertainty

C. Fixed annual warehouse rent

D. Accounting depreciation only

Correct Answer: B. Demand and lead-time uncertainty

Question 5

Which statement best describes fill rate?

A. Probability of no stockout in one replenishment cycle

B. Percentage of demand immediately supplied from available stock

C. Percentage of suppliers paid within terms

D. Ratio of orders to warehouse employees

Correct Answer: B. Percentage of demand immediately supplied from available stock

Question 6

Which item is normally relevant to total landed cost?

A. Inbound freight

B. Unrelated corporate advertising

C. A sunk cost from a closed warehouse

D. A shareholder dividend

Correct Answer: A. Inbound freight

Question 7

If average inventory is £1,000,000 and annual cost of goods sold is £7,300,000, approximately what are inventory days using 365 days?

A. 5 days

B. 25 days

C. 50 days

D. 100 days

Correct Answer: C. 50 days

Question 8

Which formula represents the cash conversion cycle?

A. DIO + DSO − DPO

B. DIO − DSO + DPO

C. DPO + DSO − DIO

D. DIO × DSO × DPO

Correct Answer: A. DIO + DSO − DPO

Question 9

What is shrinkage?

A. A planned seasonal increase in inventory

B. The difference between recorded and physically available inventory

C. The cost of placing a purchase order

D. The time goods spend in transit

Correct Answer: B. The difference between recorded and physically available inventory

Question 10

Why can a lower inventory level fail to improve overall performance?

A. It always increases purchase price

B. It may increase shortages, expedites and lost sales

C. It eliminates all carrying costs but also all revenue

D. It necessarily increases supplier reliability

Correct Answer: B. It may increase shortages, expedites and lost sales

Logistics Costing & Budgeting
Chapter 8 of 15