Q5. Given the information below, determine the quantities for product group B for the detailed sales...

  

Transcribed Image Text:

Q5. Given the information below, determine the quantities for product group B for the detailed sales plan and production plan on the next page. Product Group A Product Group B Product Group C Total Dollars April 100 200 550 Sales Plan May 100 200 720 June 100 200 920 Product Group A Product Group B Product Group C Total Dollars Backlog Inventory Product Group B Item 330 (35%) Item 415 (50%) Item 482 (15%) Total Units Product Group B Item 330 (35%) Item 415 (50%) Item 482 (15%) Total Units April 100 400 Production Plan 600 $40,000 0 $9,500 Item 330 35% April Family Bill Of Material Product Group B May 100 0 600 $32,000 0 0 Item 415 50% Detailed Sales Plan Item 482 15% May Detailed Production Plan April May June 100 200 600 $36,500 0 0 June June (b) Item 415 Lead Time 1 Wk Transfer the information you completed on the Detailed Sales plan and Production Plan to master schedule report on the next page and complete the calculation for the forecast, the master schedule, the available-to-promise, and the projected-on-hand. Master Schedule Product Line B On-Hand 50 Forecast Customer Orders Master Schedule Available-To- Promise Projected-On-Hand 1 30 APRIL 2 20 3 10 4 5 Week 5 0 6 0 MAY 7 0 8 0 Q5. Given the information below, determine the quantities for product group B for the detailed sales plan and production plan on the next page. Product Group A Product Group B Product Group C Total Dollars April 100 200 550 Sales Plan May 100 200 720 June 100 200 920 Product Group A Product Group B Product Group C Total Dollars Backlog Inventory Product Group B Item 330 (35%) Item 415 (50%) Item 482 (15%) Total Units Product Group B Item 330 (35%) Item 415 (50%) Item 482 (15%) Total Units April 100 400 Production Plan 600 $40,000 0 $9,500 Item 330 35% April Family Bill Of Material Product Group B May 100 0 600 $32,000 0 0 Item 415 50% Detailed Sales Plan Item 482 15% May Detailed Production Plan April May June 100 200 600 $36,500 0 0 June June (b) Item 415 Lead Time 1 Wk Transfer the information you completed on the Detailed Sales plan and Production Plan to master schedule report on the next page and complete the calculation for the forecast, the master schedule, the available-to-promise, and the projected-on-hand. Master Schedule Product Line B On-Hand 50 Forecast Customer Orders Master Schedule Available-To- Promise Projected-On-Hand 1 30 APRIL 2 20 3 10 4 5 Week 5 0 6 0 MAY 7 0 8 0

Answer rating: 100% (QA)

Detailed Sales Plan for Product Group B Product Group B Item ... View the full answer