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

    SpreadsheetZone

    Creating Document...