with excel formulas

1 Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble "X"product As and X/2" (if the ratio is not integer then round it down) product Bs. The current projected available balance is 7 and 3 for products A and B respectively. (Chapter 8) Given this information and the following product structure diagrams for A and B, fill out the MRP records (inventory status files) for component parts G and Y for the next seven weeks a. Y required) 1 2 3 4 5 6 7 X 5 X 35 Part 6 Week Gross Requirements Scheduled Receipts Projected Available Balance Planned Order Release Q=X.LT = 1, SS = 5 Part Y Week Gross Requirements Scheduled Receipts Projected Available Balance Planned Order Release Q=L4L, LT=2, SS = 3 1 2 3 4 5 6 7 X 2x