x=40

please show 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 11 and 6 for products A and B respectively. You do not have to do the MRP for parts A\&B. Just use the demand and the projected available balance of parts A\&B to estimate the gross requirements of parts G and Y. Notice that the MRP of G will affect the MRP of Y. (Chapter 8) 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 G and Y for the next seven weeks