Inventory Management Dashboard
Annual Demand:
(Your estimated total quantity required over a year)
Order Cost per Purchase Order:
(What will the cost be for placing a single order to replenish your inventory?)
Holding Cost per Unit per Year:
(Cost to store one unit of inventory for a year)
Lead Time (in days):
(How long will it take for an order to be delivered?)
Variance in Demand during Lead Time:
(Expected deviation in demand during lead time)
Desired Service Level (%):
(Acceptable probability of meeting demand)
Minimum Quantity:
(Minimum inventory level required)
Calculate
New Inventory
Item ID:
Item Quantity:
Add Item
Current Inventory
ID
Quantity