Develop a revised forecast for the five models assembled at Work Centre 12. Work Centre 12 Set-up

Develop a revised forecast for the five models assembled at Work Centre 12.
 

Transcribed Image Text:

Work Centre 12 Set-up Time (per lot) 90 minutes 40 minutes 60 minutes 200 minutes 120 minutes Model Run Time (per item in minutes) 3.7 Lot Size (minimum quantity) 150 On Hand* A 10 B 5.1 100 4.3 120 D 8.4 11.2 350 22 400 153 Most of the on-hand was really forced when the lot size exceeded orders for the week for that model. They would then assemble the rest of the lot as "plain vanilla", such that they could easily add any subassembly options once the actual customer orders came in Two workers are currently assigned to Work Centre 12, and only for the first shift. Even though assembly workers are highly flexible, Justin cannot take workers from another assembly area, as those wok centres are also behind and therefore appear to be equally overloaded. The following is the forecast and customer orders for each of the five models assembled in work centre 12 Model Weeks 1 2 45 3 4 6 7 45 8 9. 10 45 Forecast Customer 45 45 45 45 45 45 45 A 53 41 22 15 4 7 2 Orders Forecast 35 35 35 35 35 35 35 35 券 券 в Customer 66 31 30 17 6 2 Orders Forecast 50 50 50 50 50 50 50 50 50 Customer 52 33 14 4 7 1 Orders Forecast 180 180 180 180 180 180 180 180 180 180 D Customer 277 178 178 132 12 7 9 2 Orders Forecast Customer 200 200 200 200 200 200 200 200 200 200 E 223 109 185 109 74 36 12 2 Orders Work Centre 12 Set-up Time (per lot) 90 minutes 40 minutes 60 minutes 200 minutes 120 minutes Model Run Time (per item in minutes) 3.7 Lot Size (minimum quantity) 150 On Hand* A 10 B 5.1 100 4.3 120 D 8.4 11.2 350 22 400 153 Most of the on-hand was really forced when the lot size exceeded orders for the week for that model. They would then assemble the rest of the lot as "plain vanilla", such that they could easily add any subassembly options once the actual customer orders came in Two workers are currently assigned to Work Centre 12, and only for the first shift. Even though assembly workers are highly flexible, Justin cannot take workers from another assembly area, as those wok centres are also behind and therefore appear to be equally overloaded. The following is the forecast and customer orders for each of the five models assembled in work centre 12 Model Weeks 1 2 45 3 4 6 7 45 8 9. 10 45 Forecast Customer 45 45 45 45 45 45 45 A 53 41 22 15 4 7 2 Orders Forecast 35 35 35 35 35 35 35 35 券 券 в Customer 66 31 30 17 6 2 Orders Forecast 50 50 50 50 50 50 50 50 50 Customer 52 33 14 4 7 1 Orders Forecast 180 180 180 180 180 180 180 180 180 180 D Customer 277 178 178 132 12 7 9 2 Orders Forecast Customer 200 200 200 200 200 200 200 200 200 200 E 223 109 185 109 74 36 12 2 Orders