Calculate the target inventory for a service level of 90%

_______________________________________________

Q4. (25 points) The 40 week demand data for a product is given below. Replenishment cycle is weekly and lead time is 3 days. 61 9 16 Week Sales 51 431 10 5951 11 253 12 33 3571 224 14 285 17 384 18 46 15 363 19 437 210 328 20 149 330254 242 271 177 305 22 25 29 39 33 34 Week Sales 40 23 293 23 24 96394 351 26 27 438405 28 304 32 274 33 605 36 182 337 30 37 277) 39 576 38 269 352 Given the below values for a product Annual Sales Weekly standard deviation of sales Reorder point Leadtime Order size 780 units/year 15 units 40 units 2 weeks 70 units Questions. 1. Plot inventory vs. time graph 2. What is the average weeks of inventory kept ? 3. What is the inventory turnover ratio