| Economic Order Quantity | | | Optimal Inventory Policy |
| Annual Demand | | | Economic Order Quantity | ERROR:#DIV/0! |
| Ordering Cost | | | Annual Inventory Holding Cost | ERROR:#DIV/0! |
| Annual Inventory Holding Rate % | | | Annual Ordering Cost | ERROR:#DIV/0! |
| Cost per Unit | | | Total Annual Cost | ERROR:#DIV/0! |
| Working Days per Year | 260 | | Maximum Inventory Level | ERROR:#DIV/0! |
| Lead Time (Days) | 15 | | Average Inventory Level | ERROR:#DIV/0! |
| | | | Reorder Point | 0.00 |
| Note: Assumed LT, this can be changed to see impact | | | Number of Orders per Year | ERROR:#DIV/0! |
| | | | Cycle Time (Days) | ERROR:#DIV/0! |
| Note: Working days per year assumes 52 weeks * 5 working days |
SteelTiger4
Phase3IP3Worksheet1.xlsx
