Welcome to SpreadsheetZONE, Login or Register

    

Inventory Theory

+Like us on Facebook
+Like us on Twitter
     
Title:
Inventory Theory
Author:
Pagos
Downloads:
4915
Rating:
Language:
English


Overview:
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.
You must sign-in or register to comment on templates