Service Level (%)	Safety Factor
85	1.04
86	1.08
87	1.13
88	1.18
89	1.23
90	1.28
91	1.34
92	1.40
93	1.48
94	1.56
95	1.65
96	1.75
97	1.88
98	2.05
99	2.33
99.99	4.00

Please use excel to show the work if possible thanks

The lead-time for a replenishment item at a local grocery store is 2 weeks. Management would like to tolerate only one stockout each year. The ordering cost is $100, the holding cost is $5 /unit/year. The weekly demand is normally distributed with a mean of 100 and a standard deviation (sigma) of 15. Assume the company operates 50 weeks in a year. Determine: 1. The economic order quantity. ( 3 pts) 2. The service level ( 3 pts) 3. The safety stock for the desired customer service level. (2 pts) 4. The order point. (3 pts) 5. The average inventory. ( 2pts) 6. Suppose the lead time changes to 3 weeks, what will be the new safety stock? ( 2 pts)