Q6. The information below are given by the Sales and Production Managers. You are required to determine the detailed Sales Plan and Production Plan for Product Group B. Product Group B 1 Item B21 35% Item B22 15 % Item B23 50% Sales Plan Product Group A Product Group B Product Group C Jan 450 600 650 Feb 650 460 550 Mar 450 360 700 Product Group A Product Group B Product Group C Jan 550 660 650 Production Plan Feb 450 520 650 Mar 450 420 650 Detailed Sales Plan Jan Feb Mar Item B21 (35%) Item B22 (15%) Item B23 (50%) Detailed Production Plan Feb Jan Mar Item B21 (35%) Item B22 (15%) Item B23 (50%) (c) Transfer the information you completed on the Detailed Sales Plan and Production Plan to master schedule report below(for Jan and Feb only, assuming 4 weeks in a month) and complete the calculation for the forecast, the master schedule, the available-to-promise, and the projected-on-hand. Master Schedule JAN FEB Week 4 5 1 2 3 6 7 8 Item Product Line B23 B Lead On-Hand Time 3 Wk 10 Forecast Customer Orders Master Schedule Available-To- Promise Projected-On-Hand 60 65 63 60 55 45 40 35 P6 (d) What are the actions required by the Master Scheduler if order entry promises a new customer 30 units of Item B23 to be shipped in week 2. Comment on the Projected-On-Hand information in the MPS report for Item B23. (e)