Please provide answer in excel format with formulas.

Y is (2 required)

Q = 64.

Disregard the X and 2.

1. Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble 64 product As and 32 product Bs. The current projected available balance is 10 and 30 for products A and B respectively. a. Given this information and the following product structure diagrams for A and B, fill out the MRP records inventory status files) for component parts and Y for the next seven weeks. (2. IT 1 2 3 4 5 6 7 Part G Week Gross Requirements Scheduled Receipts Projected Available Balance Planned Order Release Q-L4L, LT = 1, SS = 5 64 32 3 4 5 6 7 Part Y Week Gross Requirements Scheduled Receipts Projected Available Balance Planned Order Release Q=2X, LT=2, SS = 3 32 52 1 Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble 64 product As and 32 product Bs. The current projected available balance is 10 and 30 for products A and B respectively. 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 (required) 1 2 3 4 5 6 7 Part G Week Gross Requirements Scheduled Receipts Projected Available Balance Planned Order Release Q=L4L, LT=1, SS = 5 32 1 2 3 4 5 6 Party Week Gross Requirements Scheduled Receipts Projected Available Balance Planned Order Release Q- LT=2, SS = 3 32 52