Please solve on excel with the steps

Consider the following product structure diagrams for products A and X. ALT=1 X LT=1 Level o B LT=1 C LT=2 D LT=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 8 Forecast 30 30 30 30 20 20 20 303 23 12 18 16 Orders 25 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 1 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