Materials & Inventory Management

Chapter 4
Inventory Costs, Valuation and Performance Measures

Advance Diploma in Production Management
Materials & Inventory Management   •   Advance Diploma

Inventory Costs, Valuation and Performance Measures

Introduction and context

Inventory is both an operational resource and a financial investment. It enables production continuity, customer service and purchasing economies, but it also ties up working capital and creates exposure to damage, deterioration, obsolescence and price change. Effective materials management therefore requires more than deciding how much to order. Managers must understand the cost consequences of inventory decisions, select an appropriate valuation method, and interpret performance measures in relation to service, risk and cash flow.

Inventory cost analysis connects three decisions. First, the organisation must determine the economic consequences of ordering, setting up, holding and running short of stock. Second, it must measure the value of inventory issued to production and remaining at period end. Third, it must evaluate whether inventory is supporting business objectives efficiently. A low inventory balance is not automatically good performance if it causes frequent stockouts; similarly, high availability may be uneconomic if it results from excessive safety stock.

Learning objectives

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

  1. Explain ordering, setup, carrying, shortage, obsolescence and total landed costs.
  2. Distinguish relevant, sunk, fixed and variable inventory costs.
  3. Apply FIFO, weighted-average and standard-cost valuation concepts.
  4. Calculate and interpret inventory turnover, days of inventory, fill rate, stockout rate and working-capital measures.
  5. Evaluate inventory decisions using both financial and service criteria.
  6. Recommend controls that improve inventory accuracy, value and operational performance.

1. The structure of inventory cost

The total economic cost of inventory is broader than the supplier’s invoice price. A useful classification is shown below.

Cost categoryMeaningTypical management driver
Purchase costPrice paid for materials or finished goodsSupplier price, quantity discounts
Ordering costAdministrative and transaction cost of placing and receiving an orderNumber of orders
Setup costCost of preparing equipment or processes for a production runNumber of setups or batches
Carrying costCost of holding inventory over timeAverage inventory and time
Shortage costCost arising when required stock is unavailableFrequency and duration of shortages
Obsolescence costLoss when stock becomes unusable, outdated or commercially unacceptableAge, technology and demand risk
Landed costCost of making an item available at its required locationPrice plus logistics and related charges

Ordering and setup costs

Ordering costs include purchase-order preparation, supplier communication, approval, receiving, inspection and invoice processing. In a production environment, the equivalent is setup cost: cleaning equipment, changing tooling, configuring software, preparing documentation and producing initial test pieces. These costs are generally incurred per order or production run rather than per unit.

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

Co = (D ÷ Q)S

Here, D ÷ Q is the number of orders per year. The expression assumes reasonably constant demand and a constant cost per order. For production setups, S is replaced by setup cost and Q represents the production-lot size.

Carrying cost

Carrying cost includes warehouse space, handling, insurance, security, inventory records, deterioration, financing and the opportunity cost of capital. It is often expressed as a percentage of unit value per year. If unit cost is C and the annual carrying-rate fraction is i, carrying cost per unit per year is:

H = iC

where H has currency-per-unit-per-year units. The carrying rate must be defined carefully. Some organisations include only physical holding costs; others include the cost of capital, obsolescence and insurance. Comparisons are meaningful only when the same components are used.

For a simple replenishment model in which stock rises to Q and falls steadily to zero, average cycle inventory is Q ÷ 2. Annual cycle-stock carrying cost is therefore:

Ch = (Q ÷ 2)H

This is a special case. Safety stock, seasonal stock, pipeline stock and returned goods must be added when they exist. If average inventory is known directly as Iavg, the more general expression is Ch = Iavg H.

Shortage and stockout costs

A shortage occurs when demand cannot be met from available stock. Costs may include emergency freight, overtime, production interruption, lost contribution margin, customer penalties, lost goodwill and expediting administration. The cost of a shortage is not necessarily equal to the sales value of the unavailable item: a lost production hour or contractual penalty may be much greater.

Shortage costs are difficult to estimate because they include both observable and indirect effects. A useful managerial practice is to identify the consequence by process: line stoppage, delayed shipment, substitution, backorder, lost sale or customer loss. The resulting estimates should be reviewed with production, sales, finance and customer-service personnel.

Obsolescence, deterioration and shrinkage

Obsolescence is the loss of economic usefulness caused by technological change, specification change, regulation, fashion, cancelled demand or expiry. Deterioration includes physical damage, corrosion, contamination and shelf-life loss. Shrinkage refers to unexplained loss, theft, counting error or process consumption not recorded correctly.

These costs are frequently hidden because the original purchase transaction remains in the accounting system until a write-down or disposal occurs. Inventory ageing reports, expiry controls, engineering-change procedures and disposition authority are therefore essential. A purchasing decision that appears cheap may be expensive if it creates slow-moving or unusable stock.

Total landed cost

Total landed cost is the cost of acquiring and making an item available at the required destination and condition. A general model is:

TLC = P + F + D + I + Hc + Cu + Tx - B

where P is purchase price; F freight; D duties and customs charges; I insurance; Hc handling and documentation; Cu inspection, compliance and other acquisition costs; Tx applicable taxes that are not recoverable; and B supplier rebates or credits. The terms included must reflect the organisation’s accounting policy and the applicable delivery contract. Recoverable input tax is normally excluded from inventory cost, whereas non-recoverable tax is included.

Landed cost should be calculated on a consistent basis. For example, a low-price overseas supplier may become less attractive after freight, duty, port congestion, inspection, currency risk and longer lead-time safety stock are considered. Total landed cost is consequently a procurement and supply-chain measure, not merely an accounting number.

2. Economic trade-offs and relevant costs

The basic inventory trade-off is illustrated by the opposing behaviour of ordering and carrying cost. Increasing order quantity reduces the number of orders but increases average cycle stock. Decreasing order quantity has the opposite effect. Under highly simplified assumptions, the annual relevant cost is:

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

The model excludes purchase cost when unit price is constant because total annual purchasing expenditure, DC, does not change with Q. If price varies with quantity, purchase cost must be included and the alternatives compared directly.

The familiar economic order quantity is:

Q* = √(2DS ÷ H)

This result applies when demand is stable, replenishment is instantaneous, shortages are not permitted, unit price is constant, ordering cost and carrying cost are known, and order quantity is not constrained by suppliers or equipment. In practice, the formula is a benchmark rather than an automatic answer. Minimum order quantities, quantity discounts, capacity, uncertain demand and supplier reliability may make another quantity preferable.

Worked example: order and carrying cost

A plant uses 24,000 components per year. Ordering cost is $45 per order and annual carrying cost is $3 per component. Assuming the basic model conditions apply:

Q* = √[(2 × 24,000 × 45) ÷ 3] = √720,000 ≈ 849 units

At Q = 849, the approximate number of orders is 24,000 ÷ 849 ≈ 28.3 per year. Annual ordering cost is approximately 28.3 × 45 = $1,273.50, while annual carrying cost is approximately (849 ÷ 2) × 3 = $1,273.50. Equality of these two components at the unconstrained optimum is a useful checking property, not a universal rule for real-world systems.

If the supplier requires a minimum order of 1,200 units, the organisation should compare feasible alternatives, including 1,200 units, rather than simply using 849. The minimum quantity may increase carrying cost but reduce order transactions or qualify for a price reduction.

3. Inventory valuation

Inventory valuation determines the cost assigned to units issued or sold and the cost remaining in inventory. It affects reported profit, assets, taxes and performance analysis. Physical flow and accounting cost flow are related but not identical: materials may be physically selected according to convenience while the accounting method assigns cost according to a chosen convention.

FIFO: first-in, first-out

FIFO assigns the oldest available costs to issues first. When purchase prices rise, FIFO normally produces a lower cost of goods issued and a higher closing inventory value than methods using more recent costs. Its closing balance tends to approximate current replacement cost, although this depends on the age and movement of stock.

FIFO is particularly intuitive for perishable items and products managed by expiry date. However, accounting FIFO does not by itself prove that the warehouse physically issued the oldest item; physical rotation requires location, labelling and picking controls.

Weighted-average cost

Weighted-average costing combines available costs and assigns one average cost per unit. For a periodic system:

Average cost per unit = Total cost of units available ÷ Total units available

In a perpetual system, a new average is calculated after each receipt:

New average cost = (Existing quantity × Existing average cost + Receipt quantity × Receipt unit cost) ÷ Total quantity after receipt

The method smooths price fluctuations and is useful when units are interchangeable. It can, however, obscure the effect of a recent price increase and may not reflect the cost of the specific physical items issued.

Standard cost

Standard cost assigns a predetermined cost to materials, labour and overhead for planning and control. Actual purchase-price and usage differences are recorded as variances. A material purchase-price variance may be represented as:

PPV = Actual quantity purchased × (Actual price − Standard price)

A positive result under this convention indicates an unfavourable price variance; organisations must state their sign convention because some systems reverse the labels. Standard cost is valuable for budgeting, product costing and exception reporting, but standards must be reviewed. An obsolete standard can make variance reports misleading and can encourage undesirable purchasing behaviour, such as buying excessive quantities solely to obtain a price concession.

Worked valuation example

Assume the following transactions for identical units:

TransactionQuantityUnit cost
Opening inventory100$10
Receipt80$12
Issue120—
Receipt60$14

Total units available are 240 and total cost is $1,960, so the periodic weighted-average cost is $1,960 ÷ 240 = $8.1667? No: the correct calculation is $1,960 ÷ 240 = $8.1667 only if the total cost were $1,960; actually, (100 × 10) + (80 × 12) + (60 × 14) = $2,680, giving:

Average cost = $2,680 ÷ 240 = $11.1667 per unit

After the issue, 120 units remain. Closing inventory under periodic weighted average is approximately 120 × 11.1667 = $1,340. Under FIFO, the issue uses 100 units at $10 and 20 units at $12, giving issue cost $1,240. The remaining 60 units at $12 and 60 units at $14 produce closing inventory of $1,560. The difference demonstrates how valuation method affects both reported issue cost and closing assets. The arithmetic also illustrates why transaction records must be checked carefully before management conclusions are drawn.

In practice, financial reporting is subject to the applicable accounting framework. Many frameworks require inventory to be measured at the lower of cost and net realisable value, where net realisable value is the estimated selling price less costs of completion and sale. Specific rules differ by jurisdiction and inventory type; professional decisions should therefore be documented and reviewed by qualified finance personnel.

4. Inventory performance measures

No single metric captures inventory performance. Financial efficiency, operational availability, accuracy and risk must be viewed together.

Inventory turnover

Inventory turnover indicates how many times average inventory is consumed or sold during a period:

Inventory turnover = Cost of goods sold ÷ Average inventory at cost

Average inventory is commonly (Opening inventory + Closing inventory) ÷ 2, although monthly or daily averages are more reliable when demand is seasonal. The numerator should be measured at cost, not sales value, to maintain unit consistency. High turnover may indicate efficient use of capital, but may also indicate inadequate stock. Low turnover may reflect overstocking, long lead times, seasonal build-up or deliberate service protection.

Days of inventory

Days of inventory expresses the average stock investment in days of consumption:

Days of inventory = (Average inventory ÷ Cost of goods sold) × Number of days in period

For a 365-day year, the measure is also approximately 365 ÷ Inventory turnover. The selected day convention must be stated. Days of inventory should be compared with lead time, replenishment frequency, safety-stock policy and customer-service requirements rather than treated as an isolated target.

Fill rate and stockout rate

A unit fill rate measures the proportion of demand supplied immediately from available stock:

Fill rate = Units supplied immediately ÷ Units demanded × 100

A line fill rate instead measures order lines completely supplied. These measures are not interchangeable: one large order line may contain many units, and a single missing unit can make a line incomplete.

A basic stockout rate can be expressed as:

Stockout rate = Stockout events ÷ Demand occasions × 100

A demand occasion may be a customer order, a production requirement or a review period. The definition must be fixed before data collection. Frequency alone does not show severity; managers should also monitor stockout duration, units short and lost or delayed demand.

Working-capital measures

Inventory is a current asset and contributes to the cash conversion cycle:

CCC = DIO + DSO − DPO

Here, DIO is days inventory outstanding, DSO is days sales outstanding, and DPO is days payable outstanding. The formula assumes that the measures use compatible annual or periodic bases. Reducing inventory days can shorten the cash cycle, but transferring inventory risk to suppliers through late payment or damaging service is not sustainable management.

Inventory accuracy is another essential measure:

Inventory record accuracy = Correct records ÷ Records checked × 100

A record may be considered correct only when quantity, location, status, unit of measure and identification agree with the approved tolerance. High accuracy supports planning systems; low accuracy causes false shortages, emergency purchasing and unnecessary safety stock.

5. Integrated interpretation and governance

Metrics must be interpreted as a system. A manager should ask:

  • Is turnover rising because excess stock was removed, or because service deteriorated?
  • Is fill rate high because demand is stable, or because inventory is excessive?
  • Are shortages concentrated in high-value or production-critical items?
  • Does standard-cost performance reflect genuine improvement or an outdated standard?
  • Are write-offs being delayed to make reported results appear better?

ABC analysis can focus control effort by annual usage value, but criticality, lead time, regulatory status and supply risk should also be considered. A low-value safety component may deserve tighter control than a high-value but easily replaced item. Cycle counting, segregation of duties, approved adjustments, batch and expiry traceability, and documented write-off authority are important governance practices.

Technology can improve visibility through barcode scanning, radio-frequency identification, warehouse-management systems and enterprise-resource-planning integration. Analytics and machine learning may identify unusual consumption, ageing risk or likely stockouts. Nevertheless, algorithms inherit errors in master data and transaction discipline. Human review remains necessary for engineering changes, exceptional demand, ethical sourcing and accounting judgement.

6. Illustrative case: Meridian Pumps Ltd.

Background

Meridian Pumps manufactures industrial water pumps. It had a reported inventory turnover of 3.1 times, a fill rate of 98%, and growing cash pressure. Finance also identified a large quantity of obsolete seals and electronic controllers.

Problem

The purchasing department had been rewarded for unit-price reductions. Buyers placed large orders to obtain discounts, but demand for several models declined after an engineering redesign. The warehouse used FIFO for some items but lacked reliable batch scanning. Standard costs had not been revised for two years, and shortages were recorded only when production stopped.

Analysis

A cross-functional team recalculated total landed cost. The apparent 8% unit-price saving from an overseas supplier was offset by freight, duty, inspection, longer lead time and additional safety stock. An ageing analysis showed that 19% of inventory value had no consumption in the previous twelve months. The high fill rate therefore concealed overstocking, while the turnover figure was depressed by obsolete items.

The team separated cycle stock, safety stock and non-moving stock, then recalculated performance by product family. High-volume standard pumps had acceptable turnover and service. Special-order controllers had low turnover and high obsolescence exposure. Critical seals had occasional stockouts despite low monetary value.

Approach and solution

Meridian introduced a two-dimensional classification based on annual usage value and operational criticality. It established monthly review of slow-moving items, engineering-change alerts to purchasing, and approval before buying items with less than twelve months’ forecast demand. Landed cost became the basis for supplier comparison. Cycle counting was increased for critical items, and standard costs were reviewed quarterly.

The organisation also defined its metrics formally: unit fill rate, line fill rate, stockout events, stockout hours, inventory turnover at cost and inventory ageing. This prevented departments from selecting whichever definition produced the most favourable result.

Outcome

After two review cycles, obsolete inventory was identified for controlled disposition, without concealing the write-down from management. Working capital declined, while the fill rate for critical seals improved because safety stock was placed where it mattered. Reported turnover improved partly because non-moving stock was removed, so management documented the accounting and operational effects separately rather than claiming that all improvement came from process efficiency.

Learning points

The case demonstrates that purchase price is not total cost, high service is not proof of efficiency, and a single inventory metric can mislead. Reliable classification, consistent definitions, cross-functional decisions and transparent accounting are more valuable than isolated numerical targets.

Challenges and limitations

Inventory models rely on assumptions that may not hold. Demand may be intermittent, supplier lead time may vary, and carrying cost may change with interest rates or warehouse capacity. Average inventory can hide severe peaks and shortages. Historical turnover cannot predict a product discontinuation. Valuation methods can change reported profit without changing physical stock. Finally, aggressive working-capital reduction can shift costs to customers, suppliers or production.

Best practice is therefore to combine quantitative models with scenario analysis, sensitivity testing and operational judgement. Managers should document assumptions, use consistent data definitions, review exceptions and assess service and risk alongside cost.

Chapter Summary

Inventory management requires a balanced view of cost, value, service and risk. Ordering and setup costs increase with the number of replenishment or production events, whereas carrying cost generally increases with average stock. Shortage, obsolescence and deterioration costs may be less visible but can be strategically significant. Total landed cost extends analysis beyond invoice price to include logistics, duties, handling and non-recoverable charges.

FIFO, weighted-average and standard cost assign inventory costs differently and consequently affect reported issues, closing inventory, profit and variance analysis. Inventory turnover and days of inventory assess capital efficiency; fill rate and stockout rate assess availability; and working-capital measures connect inventory with cash flow. None should be used alone. Effective practice combines accurate records, appropriate valuation, total-cost analysis, service definitions, risk-based classification and strong governance.

Key Terms

Inventory carrying cost: Cost of holding inventory over time.

Ordering cost: Cost incurred each time a purchase order is placed and processed.

Setup cost: Cost of preparing equipment or a process for a production run.

Shortage cost: Cost caused by unavailable inventory.

Obsolescence: Loss of value caused by declining usefulness or demand.

Deterioration: Physical or quality loss during storage.

Total landed cost: Total cost of acquiring and delivering an item to its required location and condition.

Relevant cost: Future cost that changes between decision alternatives.

FIFO: Valuation convention assigning the oldest available costs to issues first.

Weighted-average cost: Valuation method using a blended cost per unit.

Standard cost: Predetermined cost used for planning, control and variance analysis.

Inventory turnover: Cost of goods sold divided by average inventory at cost.

Days of inventory: Average inventory expressed as days of consumption.

Fill rate: Percentage of demand supplied immediately from stock.

Stockout rate: Frequency of occasions on which required stock is unavailable.

Working capital: Current operating investment, including inventory and receivables less operating liabilities.

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

Cycle counting: Continuous checking of selected inventory records.

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

Inventory accuracy: Agreement between recorded and physically verified inventory information.

Review Questions

Short Answer Questions

  1. Distinguish ordering cost from carrying cost.
  2. What costs may be included in total landed cost?
  3. State the main assumption behind the basic economic order quantity model.
  4. How does FIFO generally affect closing inventory during periods of rising prices?
  5. Why should fill rate and turnover be interpreted together?

Long Answer Questions

  1. Explain the major categories of inventory cost and discuss how each may influence purchasing and production decisions.
  2. Compare FIFO, weighted-average and standard-cost methods, including their managerial uses and limitations.
  3. Explain the assumptions, formula and practical limitations of the economic order quantity model.
  4. Discuss how inventory turnover, days of inventory and the cash conversion cycle support working-capital management.
  5. Design a governance framework for controlling obsolescence, inventory accuracy and inventory write-offs.

Analytical / Application Questions

  1. Annual demand is 18,000 units, ordering cost is $60 per order and annual carrying cost is $4 per unit. Calculate the basic economic order quantity and explain two reasons why the organisation might select a different feasible quantity.
  2. A business reports high fill rate but low turnover and increasing write-offs. Diagnose at least three possible causes and recommend a measurement or control response for each.
  3. Using the transactions in the valuation example, explain why FIFO and weighted-average produce different issue and closing-inventory values, and assess which method would be more informative for a business with rapidly rising replacement prices.

Multiple Choice Questions with Answers

Question 1

Which cost generally increases when order quantity increases, assuming all other conditions remain constant?

A. Annual ordering cost

B. Average cycle-stock carrying cost

C. Number of purchase orders

D. Supplier communication cost per order

Correct Answer: B. Average cycle-stock carrying cost

Question 2

A component has annual demand of 10,000 units, ordering cost of $50 per order and annual carrying cost of $2 per unit. What is the basic economic order quantity?

A. 500 units

B. 600 units

C. 707 units

D. 1,000 units

Correct Answer: C. 707 units

Question 3

Under FIFO during a period of rising purchase prices, which result is generally expected?

A. Higher issue cost and lower closing inventory than recent-cost methods

B. Lower issue cost and higher closing inventory than recent-cost methods

C. No effect on issue cost or closing inventory

D. Closing inventory is always valued at selling price

Correct Answer: B. Lower issue cost and higher closing inventory than recent-cost methods

Question 4

Which formula correctly represents inventory turnover?

A. Sales revenue ÷ closing inventory at selling price

B. Average inventory ÷ cost of goods sold

C. Cost of goods sold ÷ average inventory at cost

D. Purchases ÷ opening inventory

Correct Answer: C. Cost of goods sold ÷ average inventory at cost

Question 5

A firm supplies 9,500 units immediately from stock against demand for 10,000 units. What is the unit fill rate?

A. 5%

B. 90%

C. 95%

D. 105%

Correct Answer: C. 95%

Question 6

Which item is normally included in total landed cost when it is non-recoverable?

A. Recoverable input tax

B. Supplier rebate

C. Import duty

D. Future sales revenue

Correct Answer: C. Import duty

Question 7

What is the principal purpose of standard cost?

A. To eliminate all inventory risk

B. To provide a predetermined benchmark for planning and variance analysis

C. To guarantee that physical issues follow the oldest batch

D. To measure customer satisfaction directly

Correct Answer: B. To provide a predetermined benchmark for planning and variance analysis

Question 8

If average inventory is $200,000 and annual cost of goods sold is $1,000,000, what is inventory turnover?

A. 0.2 times

B. 2 times

C. 5 times

D. 20 times

Correct Answer: C. 5 times

Question 9

Which situation is most likely to indicate obsolescence risk?

A. High consumption and frequent replenishment

B. No consumption for twelve months after a design change

C. Accurate location records

D. Short supplier lead time

Correct Answer: B. No consumption for twelve months after a design change

Question 10

In the cash conversion cycle formula, which relationship is correct?

A. CCC = DIO − DSO − DPO

B. CCC = DIO + DSO − DPO

C. CCC = DSO + DPO − DIO

D. CCC = DIO × DSO × DPO

Correct Answer: B. CCC = DIO + DSO − DPO

Materials & Inventory Management
Chapter 4 of 14