Question: Can somebody please provide an answer along with steps to th

107 cases days annually A 127 A B C D E G H K L M N 0 98 Inventory Supply As part of your examination of the ICE services, you examined how they manage their raw material inventory. 99 On average there are 120 standard food types in 5 freezers. Plus there are seasonal items when appropriate. 100 They have a physical holding cost rate of h- 40% You spoke to the ICE manager about this and pointed out 101 other departments at GDC only have a 8% physical holding cost rate. The ICE manager said that is because 102 electricity to keep foods frozen is expensive and frozen foods are perishable if the temperature rises in the freezers. The manager 103 said that other departments are probably under estimating the costs of physically holding their inventory 104 The cost of placing an order at ICE is $ 10 an order. The ICE manager stated that orders are placed once a week 105 and that the lead time is one week. ICE operates only 5 days a week, so the manager schedules deliveries from suppliers 106 so that suppliers whose food goes into Freezer 1 deliver on Monday. Suppliers whose food is stored in Freezer 2 deliver on Tuesday. The manager requirees that all deliveries be made between 8 AM and 12 Noon Monday to Friday, so deliveries do not interfere 108 with shipments out to the grocery stores. To simplify the ordering process, the manager has set all order quantities at 800 109 The manager also set the reorder point, ROP = 600 cases for all foods. The manager argues that this simplified 110 ordering and delivery and that the sales volume did not vary significantly between food items. 111 You obtained the following information to test whether the manager's assumptions were correct. Assume ICE works 250 112 These represent food items with the lowest annual volume, the highest annual volume and the highest standard deviation. Standard Deviation Annual of Sales Sales Cases/ Unit Cost 113 Food Item (Cases) Week) per Case 114 10000 100 $300 200 115 B 20000 25 $225 116 30000 30 $140 117 D 22000 20 $205 118 E 19000 80 $203 119 10 Assume the manager's cost figures are correct. Compare costs with the current Q to the EOQ costs. 120 insert rows as needed) 121 122 # 5 What is the time to zero (tz) for each item? 123 124 125 126 10 To test the impact of the manager's ROP decision, make a graph of Ending Inventory for 10 weeks for Food item A. Calculate two Ending Inventories. One for a level demand (i.e., Annual Sales / 50 weeks). One level for high demand of Average weekly sales +1 standard 128 deviation (Show work and graph below. Have only one graph with two lines on it. Please label it). 129 130 131 10 To test the impact of the manager's ROP decision, make a graph of Ending Inventory for 10 weeks for Food item C. Calculate two 132 Ending Inventorics. One for a level demand (i.e., Annual Sales / 50 weeks). One level for high demand of Average weekly sales + 1 standard 133 deviation (Show work and graph below. Have only one graph with two lines on it. Please label it). 134 135 136 5 Based on the two graphs above, state your conclusion about the ordering policies of this manager. Explain your conclusion. 137 138 139 140 141 142 143 SCENARIO A process has a mean of 63.06 and a standard deviation of 0.11 It's lower specification limit is 144 and it's upper specification limit is 63.5 145 #### 5 Calculate its Cp Co- 146 #NA 147 148 #### 2 Explain what this Cp means for the process. 149 150 151 152# 5 Calculate the Cpk for the above scenario. Cok 153 #NA 154 155 #### 2 Explain what this Cpk means for the process. 156 157 158 159 #### 5 5 Calculate its S value. S 160 #N/A 161 162 #### 2 Explain what this S value means for the process. 163 164 165 62.5