SpreadsheetZONE
Inventory Theory Template
This template is prepared for understanding one-item inventory optimization with several assumtions like deterministic demand. Not only the optimal order quantity but also the optimal policy may be found. Inventory costs available are order cost, holding cost, backorder cost (3 types) and lost sale cost. With the entered parameters (demand, unit cost, etc.) order quantity and order placement level that maximize total profit are determined. Inventory schedule is simualated on a net inventory-period chart and the distribution of costs is analyzed.
To download it for free, please go to:
Inventory Theory Template
This template is prepared for understanding one-item inventory optimization with several assumtions like deterministic demand. Not only the optimal order quantity but also the optimal policy may be found. Inventory costs available are order cost, holding cost, backorder cost (3 types) and lost sale cost. With the entered parameters (demand, unit cost, etc.) order quantity and order placement level that maximize total profit are determined. Inventory schedule is simualated on a net inventory-period chart and the distribution of costs is analyzed.
To download it for free, please go to: