Formulas



Ø
Inventory = (Opening Inventory + n * Closing Inventories) / (1 + n)


Turnover Ratio = Usage / Ø Inventory


Ø Turnover Period = Days in Base Period / Turnover Ratio





n = Number of closing inventories

1 + n = Total number of calculation periods in base period

Usage = Negative item ledger entries within the base period