This template is an advanced weekly inventory scheduler with one item limitation. s-S or s-Q policies may be used to automize the process. When the parameters of the system are defined, the decision of when to order and the order size are taken automatically every week by entering the demand of the week. Weekly costs including holding cost, variable order cost, fixed order cost and backorder cost are evaluated. A report is also provided on another sheet displaying the system statistics, cost distribution and inventory-demand vs. time chart. Report can be taken up to a specified week. This template is an initial study on single item inventory and may be extended to multi-item, also including other policies like lost-sale case.

You must sign-in or register to comment on templates

    SpreadsheetZone

    Creating Document...