please provide excel formulas

Question 3: Complete the following master schedule with the Projected Available, ATP. and MPS sections, and then answer the following questions. Assume that the demand time fence is 3 weeks and that you currently have 46 units on-hand. Use an MPS batch size of 50 units. (20 points) Wk 1 20 21 Wk 2 25 22 Wk3 20 24 Wk 4 Wk 5 Wk 6 Wk 7 Wk 8 30 30 20 20 25 20 17 21 17 12 Wk 9 25 9 Wk 10 20 11 Forecast Orders Available ATP MPS 1. Is there anything on the master schedule that should be of great concern? If so, why, and what should you do? b. A customer wants to place a new order for 8 units in week 4. Should you accept the order? Why or why not? If you cannot accept the order right away, what is one alternative that you could suggest so that the customer is satisfied? Question 4: Produce MRP records for components B, C, D, and E. Item A is the finished product, made from one B and two Cs. Item B is made from three Ds and one E Item C is made from one D and two Es. (It may be helpful for you to draw out the product structure tree version of this bill of materials so that it's easier for you to compute the gross requirements.) Do you see any lead time concerns for any of the components? [00 points] Item Master File Item E Lot size Mult 150 Mult 250 Min 400 Lead time in weeks) On hand Scheduled receipts None None 250, Wk 1 None Safety stock None None 20 None Low-level code 1 2 D B LIL 1 10 2 50 1 10 2 320 1 2 1 2 5 7 12 Week MPS Quantity 3 4 20 30 6 50 8 9 10 30 10 11 50