QUESTION 1 PART B As the Master Scheduler for Nice Things Ltd you are required to produce a master production schedule (MPS) for item "Nuff Niceness with ATP logle. The following information is available Lot Size: 50 On Hand: 46 Planning time fence 12 weeks Demand Time Fence 3 weeks Reproduce table 3 in your booklet and do the following: On-hand inventory Table 3 1 2 3 2025 20 21 22 24 420 30 20 5 6 30 20 1721 7 20 17 8 25 12 9 25 9 10 11 12 20 20 30 11 4 2 Week Forecast Demand Orders Booked Projected Available Master schedule (MPS) Available-to-Promise (ATP) f) Determine the Available-to-Promise (ATP). 16 marks) Answer the following questions based on your completed Master Production Schedule g) Is there anything on the master schedule that should be of great concern? Your answer should include why and your solution for the concern identified. points) h) A customer wants 8 units of Nuff Niceness in period 4. What should you tell them and why? [3 marks) i) Suppose the forecast for period 12 increases from 30 to 75 units because of a possible marketing campaign. What action should you take and why? marks)