Inventory shrinkage cost · Calculation guide

Value the difference between ledger stock and a physical count.

Calculation guide

Use one SKU and one count date. Value the difference at unit cost. A negative result is a stock surplus. The shrinkage percentage uses book units as the denominator.

shrink_value = (book-physical)*unit_cost; missing = book-physical; shrink_pct = 100*missing/book

Inputs

Book inventory units

Example entry 1000. Minimum 1.0. Use whole numbers.

Physical count in units

Example entry 950. Use whole numbers.

Cost per unit

Example entry 7.5 (in the selected currency).

Worked example

InputValue
Book inventory units1,000
Physical count in units950
Cost per unit7.5
ResultValue
Shrinkage at cost375
Book units less physical units50
Shrinkage percentage5%

Calculation steps

Shrinkage at cost = ((Book inventory units − Physical count in units) × Cost per unit)

((1,000 − 950) × 7.5) = 375

Book units less physical units = (Book inventory units − Physical count in units)

(1,000 − 950) = 50

Shrinkage percentage = ((100 × Book units less physical units) ÷ Book inventory units)

((100 × 50) ÷ 1,000) = 5%

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Book inventory units1,0001,100Shrinkage at cost3751,125
Physical count in units9501,045Shrinkage at cost375-337.5
Cost per unit7.58.5Shrinkage at cost375425
Inventory shrinkage cost →

Sources