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
| Input | Value |
|---|---|
| Book inventory units | 1,000 |
| Physical count in units | 950 |
| Cost per unit | 7.5 |
| Result | Value |
|---|---|
| Shrinkage at cost | 375 |
| Book units less physical units | 50 |
| Shrinkage percentage | 5% |
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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Book inventory units | 1,000 | 1,100 | Shrinkage at cost | 375 | 1,125 |
| Physical count in units | 950 | 1,045 | Shrinkage at cost | 375 | -337.5 |
| Cost per unit | 7.5 | 8.5 | Shrinkage at cost | 375 | 425 |
