O. 100 Problem Set Q- Search Sheet Home Insert Page Layout Formulas Data Review View 3+ Share a Geneva 9 AA A Eto Wrap Text Ceneral 17 . Insert - * Delete - KA 49 Paste Iu B A A .no Merge & Center $ % .00 Conditional Format Formatting as Table Cell Styles Format Sort Filter V3 X fx J L M N 0 P Service level 4 4 A B D E F G H 1 1 Problem 6 2 Below is a table of information about 7 inventory items. For item 1, enter formulas to compute average demand during lead time 3 stdev of demand during lead time, safety stock and prob of stockout. Do it so the formulas can be copied for the other items. 4 The company's policy is that every iter has a reorder point of 72. (All the items come in cases of 12, and this is 6 cases.) 5 8 Sldev of Sldey of Average demand Sidev of 7 Item Demand day Demand/day Lead time Leed time during lead time LTD ROP Safety stock 8 1 17 1 4 0.25 9 2 15 2 0.2 10 3 3 22 2 3 3 0.2 11 13 4 3 0.3 12 5 1 3 0.3 13 6 25 5 2 2 0.2 14 7 17 2 4 0.5 15 16 How many items will have a service level below 95% with this policy of ordering when there are 72 left? 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 22 Summary #1 #2 #3 #5 #6 A 7 + Ready | IF + 130%