Safety stock calculator
Formula:
Safety stock = [ Maximum daily use x Maximum lead time ] – [ Average daily use x Average lead time ]
Reorder point calculator
Formula:
Reorder point = ( Average daily usage x Average lead time in days ) + Safety stock
Formula:
EOQ = √((2 x Annual demand in units x Order cost per Purchase Order) ÷ Annual holding cost per unit)
Inventory turnover calculator
Formula:
Inventory turnover = Cost of Goods Sold [Beginning inventory value + Purchases made - Final inventory value] ÷ Average inventory [Beginning inventory value + Final inventory value ÷ 2]
Average inventory value calculator
Formula:
Average inventory value = (Beginning inventory value + Ending inventory value) ÷ 2