Step 1: Use the values below to calculate the EOQ, Order Cost, Holding Cost, and Total...

Transcribed Image Text:

Step 1: Use the values below to calculate the EOQ, Order Cost, Holding Cost, and Total Cost (hint: your quantity to calculate the costs should be the EQQ): Product Demand Product A Product B Product C 20000 Product D 45000 Product E 100000 D 75000 Product Value V $20 Order Cost Inventory Carrying Cost 0 C $30 22.50% Step 2: Use the values below to calculate safety stock: 10000 $50 $8,000 $4 $62.50 $80 $300 $40 $200 20% 15% 22.50% 25% Product A Product B Product C Product D Product E Demand 96 Order Lead Time 3 Demand 107 Order Lead Time Demand 4 164 Order Lead Time 7 Demand Order Lead Time Demand 168 8 217 Order Lead Time 11 98 94 156 200 190 103 98 161 194 184 97 100 155 177 196 104 95 152 172 185 96 3 106 4 155 7 195 8 208 11 103 102 153 193 196 103 104 150 191 199 103 95 151 182 219 103 90 158 181 204 99 3 107 4 159 7 161 10 215 11 103 103 154 189 182 100 90 159 171 212 105 104 155 174 196 96 103 154 163 181 97 2 103 4 162 8 195 9 200 13 103 92 158 190 210 100 94 164 178 213 102 108 158 198 209 100 104 154 166 208 97 2 100 5 162 6 187 8 191 10 99 94 159 166 216 95 93 152 186 199 99 106 163 167 188 Step 1: Use the values below to calculate the EOQ, Order Cost, Holding Cost, and Total Cost (hint: your quantity to calculate the costs should be the EQQ): Product Demand Product A Product B Product C 20000 Product D 45000 Product E 100000 D 75000 Product Value V $20 Order Cost Inventory Carrying Cost 0 C $30 22.50% Step 2: Use the values below to calculate safety stock: 10000 $50 $8,000 $4 $62.50 $80 $300 $40 $200 20% 15% 22.50% 25% Product A Product B Product C Product D Product E Demand 96 Order Lead Time 3 Demand 107 Order Lead Time Demand 4 164 Order Lead Time 7 Demand Order Lead Time Demand 168 8 217 Order Lead Time 11 98 94 156 200 190 103 98 161 194 184 97 100 155 177 196 104 95 152 172 185 96 3 106 4 155 7 195 8 208 11 103 102 153 193 196 103 104 150 191 199 103 95 151 182 219 103 90 158 181 204 99 3 107 4 159 7 161 10 215 11 103 103 154 189 182 100 90 159 171 212 105 104 155 174 196 96 103 154 163 181 97 2 103 4 162 8 195 9 200 13 103 92 158 190 210 100 94 164 178 213 102 108 158 198 209 100 104 154 166 208 97 2 100 5 162 6 187 8 191 10 99 94 159 166 216 95 93 152 186 199 99 106 163 167 188