Please answer for part b only.

Submit the following on Moodle: 1. Your MS Word file (Summary and explanation of your solutions). 2. Your Excel file you used for your solution. Moodle closes at 10:00AM and you will not be able to submit afterwards. Late assignments or assignments submitted by email will not be accepted. Consider the following product structure diagrams for products A and X. ALT=1 X LT=1 Level 0 D LT=2 B LT=1 CLT=2 Level 1 D LT=2 Level 2 OH inventory, forecasts, demand and partially developed MPS for product A are as given below. MPS Lot size is 50 units and SS=0. a) Complete the following MPS time-phased record for product A. Week 1 2 3 4 5 6 7 00 Forecast 20 20 20 30 30 30 30 30 Orders 25 23 12 18 16 Projected Available Balance 20 Available to Promise MPS 50 50 b) The following events occurred during week 1: 1) Marketing forecasted that 40 units would be needed for week 9. 2) Actual demand during week I was 25 units. 3) Only 45 units of the planned MPS was produced. In the beginning of week 2, you received the following orders: 4) Received a new order for 10 for new week 2. Will you accept it? 5) Received a new order for 35 for new week 3. Will you accept it? 6) Received a new order for 20 for new week 4. Will you accept it? 7) Received three new orders: 15 for new week 5, 10 for new week 6 and 5 for new week 7. Will you accept them? Keep updating the time-phased record as you roll through time and keep making decisions