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