Please solve with excel and show steps

Consider the following product structure diagrams for products A and X. OH inventory, forecasts, demand and partially developed MPS for product A are as given below. MPS Lot size is 50 units and SS=0. Note the following in solving the question: 1. Backordering is not allowed. 2. Since we do not have any additional information about this particular problem, in the slushy zone refrain from scheduling new MPSs and/or increasing the values of existing MPSs (if any). Us the same conventions we used in class for frozen and liquid zones. a) Complete the following MPS time-phased record for product A. b) The following events occurred during week 1 : 1) Actual demand during week 1 was indeed 25 units. 2) Only 45 units of the planned MPS was produced. 3) Marketing forecasted that 40 units would be needed for week 9. Provide an updated MPS table that you will see in the beginning of week 2 . Note that, in your new MPS table, previous week 2 is now relabeled as week 1 , etc., and week 9 is relabeled as week 8 . c) By using the updated MPS table in part (b), answer the following inquiries. Evaluate the inquiries in the sequence given below and if you accept a certain order, update the timephase MPS record before you consider the next inquiry. 1) Do you have 20 units in week 4 ? If not, how soon can you provide it? 2) Do you have 40 units in week 5 ? If not, how soon can you provide it? 3) Do you have 55 units in week 6 ? If not, how soon can you provide it