3. Given the following data, can an order for 20 for delivery in week 4 be accepted? Calculate the ATP using the following table. On hand - 50 units. Week 1 Customer Orders 2 3 4 50 5 6 MPS SO 7 8 30 40 50 40 100 30 15 ATP 100 100 100 4. The whisk company manufactures a line of broomsticks. The most popular is the 36-inch model, and the sales department has prepared a forecast for 6 weeks. The opening inventory is 30. As master scheduler, you must prepare an MPS. The brooms are manufactured in lots of 100. (2.5 marks) Week 1 2 3 4 Forecast Sales s 6 10 50 25 SO 10 Projected Available Balance 15 30 MPS