Help Thu 12:59 PM Q E Word File Edit View Insert Format Tools Table Window AutoSave n H E 6 0 OFF In-class assignment 11 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Arial ARA 12 General Insert v Delete v Z?" Or 8 Paste B I U EEEEE 3 $ V % 9 % of Ideas Sensi Conditional Format Cell Formatting as Table Styles E! Format v Sort & Filter Find & Select K L M N O L17 X fx B D E F G . I 1 In-Class Assignment 11 - November 19, 2020 2 3 Dell Computers 4 5 Weekly demand for Dell computers at a Best Buy is normally distributed, with a mean of 750 and a standard deviation of 180. The store 6 manager continuously monitors inventory and currently orders 4,500 computers each time the inventory drops to 4,000 printers. Dell currently 7 takes 5 weeks to fill an order. 8 9 1.How much safety inventory does the store carry? (3pts) 10 2.What is the cycle inventory? (3pts) 11 3.What is the average inventory? (3pts) 12 4.What is the average flow time? (3pts) 13 5.What CSL does Best Buy achieve as a result of this policy? (3pts) 14 6.What would be the safety inventory if Best Buy want a CSL of 95% (3pts) 15 7.What would be the expected shortage per replenishment cycle (ESC) with the Best Buy's CSL? (3pts) 16 8.What would be the ESC with 95% CSL? (3pts) 17 9.What can Best Buy do to lower its safety inventory? (4pts) 18 10.What can Best Buy do to raise its Cycle Service Level? (4pts) 19 11. What is the role of safety inventory in the supply chain? (4pts) 20 12. Explain how a reduction in lead time can help a supply chain reduce safety inventory without hurting product availability? (4pts) 21 22 23 Prob. Statement Safety Inventory Q1-Q8 Q9-Q12 + Ready 3 + 120% 51,655 NON 1 50 19 A W Dulu 0 Help Thu 12:59 PM Q E Word File Edit View Insert Format Tools Table Window AutoSave n H E 6 0 OFF In-class assignment 11 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Arial ARA 12 General Insert v Delete v Z?" Or 8 Paste B I U EEEEE 3 $ V % 9 % of Ideas Sensi Conditional Format Cell Formatting as Table Styles E! Format v Sort & Filter Find & Select K L M N O L17 X fx B D E F G . I 1 In-Class Assignment 11 - November 19, 2020 2 3 Dell Computers 4 5 Weekly demand for Dell computers at a Best Buy is normally distributed, with a mean of 750 and a standard deviation of 180. The store 6 manager continuously monitors inventory and currently orders 4,500 computers each time the inventory drops to 4,000 printers. Dell currently 7 takes 5 weeks to fill an order. 8 9 1.How much safety inventory does the store carry? (3pts) 10 2.What is the cycle inventory? (3pts) 11 3.What is the average inventory? (3pts) 12 4.What is the average flow time? (3pts) 13 5.What CSL does Best Buy achieve as a result of this policy? (3pts) 14 6.What would be the safety inventory if Best Buy want a CSL of 95% (3pts) 15 7.What would be the expected shortage per replenishment cycle (ESC) with the Best Buy's CSL? (3pts) 16 8.What would be the ESC with 95% CSL? (3pts) 17 9.What can Best Buy do to lower its safety inventory? (4pts) 18 10.What can Best Buy do to raise its Cycle Service Level? (4pts) 19 11. What is the role of safety inventory in the supply chain? (4pts) 20 12. Explain how a reduction in lead time can help a supply chain reduce safety inventory without hurting product availability? (4pts) 21 22 23 Prob. Statement Safety Inventory Q1-Q8 Q9-Q12 + Ready 3 + 120% 51,655 NON 1 50 19 A W Dulu 0