| | | | | service | 50% |
| | | | | Inventory Item | Average Demand (Annual) | Average Demand (days) | Sigma (Std. Dev.) of Demand During Lead Time | Item Unit Cost | z value (from table)- Appendix I Normal curve areas from Text | safety stock | Reorder point | Inventory costs due to safety stock |
| | | | | F-11001 | 15,000 | 41 | 100 | $250.00 | 0 | 0 | 41 | $0.00 |
| | | | | K-12002 | 100,000 | 274 | 300 | $2.00 | 0 | 0 | 274 | $0.00 |
| | | | | L-13003 | 250,000 | 685 | 200 | $0.20 | 0 | 0 | 685 | $0.00 |
| | | | | N-14004 | 300,000 | 822 | 400 | $1.00 | 0 | 0 | 822 | $0.00 |
| | | | | P-21001 | 50,000 | 137 | 60 | $125.00 | 0 | 0 | 137 | $0.00 |
| | | | | S-22002 | 80,000 | 219 | 75 | $30.00 | 0 | 0 | 219 | $0.00 |
| | | | | service | 80% |
| | | | | Inventory Item | Average Demand (Annual) | Average Demand (days) | Sigma (Std. Dev.) of Demand During Lead Time | Item Unit Cost | z value (from table)- Appendix I Normal curve areas from Text | safety stock | Reorder point | Inventory costs due to safety stock |
| | | | | F-11001 | 15,000 | 41 | 100 | $250.00 | 0.85 | 85 | 126 | $21,250.00 |
| | | | | K-12002 | 100,000 | 274 | 300 | $2.00 | | 0 | 274 | $0.00 |
| | | | | L-13003 | 250,000 | 685 | 200 | $0.20 | | 0 | 685 | $0.00 |
| | | | | N-14004 | 300,000 | 822 | 400 | $1.00 | | 0 | 822 | $0.00 |
| | | | | P-21001 | 50,000 | 137 | 60 | $125.00 | | 0 | 137 | $0.00 |
| | | | | S-22002 | 80,000 | 219 | 75 | $30.00 | | 0 | 219 | $0.00 |
| | | | | service level | 90% |
| | | | | Inventory Item | Average Demand (Annual) | Average Demand (days) | Sigma (Std. Dev.) of Demand During Lead Time | Item Unit Cost | z value (from table)- Appendix I Normal curve areas from Text | safety stock | Reorder point | Inventory costs due to safety stock |
| | | | | F-11001 | 15,000 | 41 | 100 | $250.00 | | 0 | 41 | $0.00 |
| | | | | K-12002 | 100,000 | 274 | 300 | $2.00 | | 0 | 274 | $0.00 |
| | | | | L-13003 | 250,000 | 685 | 200 | $0.20 | | 0 | 685 | $0.00 |
| | | | | N-14004 | 300,000 | 822 | 400 | $1.00 | | 0 | 822 | $0.00 |
| | | | | P-21001 | 50,000 | 137 | 60 | $125.00 | | 0 | 137 | $0.00 |
| | | | | S-22002 | 80,000 | 219 | 75 | $30.00 | | 0 | 219 | $0.00 |
| | | | | service level | 95% |
| | | | | Inventory Item | Average Demand (Annual) | Average Demand (days) | Sigma (Std. Dev.) of Demand During Lead Time | Item Unit Cost | z value (from table)- Appendix I Normal curve areas from Text | safety stock | Reorder point | Inventory costs due to safety stock |
| | | | | F-11001 | 15,000 | 41 | 100 | $250.00 | | 0 | 41 | $0.00 |
| | | | | K-12002 | 100,000 | 274 | 300 | $2.00 | | 0 | 274 | $0.00 |
| | | | | L-13003 | 250,000 | 685 | 200 | $0.20 | | 0 | 685 | $0.00 |
| | | | | N-14004 | 300,000 | 822 | 400 | $1.00 | | 0 | 822 | $0.00 |
| | | | | P-21001 | 50,000 | 137 | 60 | $125.00 | | 0 | 137 | $0.00 |
| | | | | S-22002 | 80,000 | 219 | 75 | $30.00 | | 0 | 219 | $0.00 |
| | | | | service level | 90% |
| | | | | Inventory Item | Average Demand (Annual) | Average Demand (days) | Sigma (Std. Dev.) of Demand During Lead Time | Item Unit Cost | z value (from table)- Appendix I Normal curve areas from Text | Lead time | Reorder point |
| | | | | F-11001 | 15,000 | 41 | 100 | $250.00 | | 60 | 2,466 |
| | | | | K-12002 | 100,000 | 274 | 300 | $2.00 | | 60 | 16,438 |
| | | | | L-13003 | 250,000 | 685 | 200 | $0.20 | | 60 | 41,096 |
| | | | | N-14004 | 300,000 | 822 | 400 | $1.00 | | 60 | 49,315 |
| | | | | P-21001 | 50,000 | 137 | 60 | $125.00 | | 60 | 8,219 |
| | | | | S-22002 | 80,000 | 219 | 75 | $30.00 | | 60 | 13,151 |
jptazma33
week2_assgn_2_template-su4059_revised.xlsx
