Skip to content
ENExplore Calculators

Inventory Expiry Loss Calculator

Work out inventory expiry loss instantly with clear inputs, formula shown and shareable results.

About Inventory Expiry Loss Calculator

Values the stock expiring and expresses it as a share of total holdings, the standard expiry-loss indicator in pharmacy stock audits.

Formula

Expiry loss

Loss value = units expiring x unit cost; share of stock = units expiring / total stock units x 100

Worked example

With the default values below, Inventory Expiry Loss Calculator returns Value written off of $1,800.00. Change any input above and every figure here is recalculated in your browser.

Inputs used

Units expiringaccepts 0–100,000
120
Cost per unitaccepts 0.01–10,000
15
Total stock units heldaccepts 1–1,000,000
2,000

Results

Value written off
$1,800.00
Units written off
120
Share of stock expiring
6.00%
Total stock value
$30,000.00

Step by step

  1. 1Values used
  2. 2Expiry loss
  3. 3Value written off= 1,800.00
  4. 4Units written off= 120
  5. 5Share of stock expiring= 6.00
  6. 6Total stock value= 30,000.00

Assumptions and limits

  • The result is derived only from the 3 inputs listed above. Anything not among them is not part of the calculation.
  • In particular, this calculator does not take inflation, tax or compounding frequency into account.
  • Figures are rounded for display to 2 decimal places, so totals built from several rounded parts can differ slightly from the unrounded arithmetic.

How these calculators are built and tested is described on the Methodology page. If a figure looks wrong, please report it.

Frequently Asked Questions

What is an acceptable expiry loss?

Under 2% of stock value is a common internal target for hospital pharmacy.

How is expiry loss reduced?

First-expiry-first-out stock rotation, smaller more frequent orders and redistribution between sites before expiry.

Related Calculators

Inventory Expiry Loss Calculator | Calcrivo