Please solve in excel & show formulas, thank you!!

Bill of Material for Toy Car Assembly Toy Car Final Assembly Wheel Assembly (2 required) Body (1 required) Axle Wheel (2 required) (1 required) MS.52 A toy company needs to calculate material requirements for its top-selling toy car. The graphic above shows the bill of material for this item. Below are three MRP tables for the top-level assembly (the car) and some of its components: 8/3 8/10 8/17 8/24 8/31 9/7 9/14 9/21 9/28 800 1100 2000 2200 380 650 400 210 Toy Car Final Assembly Gross Requirements Scheduled Receipts Projected On-Hand Inv. Net Requirements Planned Order Receipts Planned Order Releases Lead Time (in weeks) Lot Size 1 140 8/3 8/10 8/17 8/24 8/31 9/7 9/14 9/21 9/28 1700 1800 2200 400 Wheel Assembly Gross Requirements Scheduled Receipts Projected On-Hand Inv. Net Requirements Planned Order Receipts Planned Order Releases Lead Time (in weeks) Lot Size 1 300 8/3 8/10 8/17 8/24 8/31 9/7 9/14 9/21 9/28 1100 2000 400 Axle Gross Requirements Scheduled Receipts Projected On-Hand Inv. Net Requirements Planned Order Receipts Planned Order Releases Lead Time (in weeks) ILot Size 4 100 For the Toy Car table above, what are the planned Order Receipts in the week of 8/31? Number For the Toy Car table above, what are the planned Order Releases in the week of 9/21? Number For the Wheel Assembly table above, what are the Gross Requirements in the week of 9/7? Number For the Wheel Assembly table above, what is the Projected On-Hand Inventory in the week of 8/31? Number For the Wheel Assembly table above, what are the Net Requirements in the week of 8/24? Number For the Axle table above, what are the Gross Requirements in the week of 9/7? Number For the Axle table above, what are the Gross Requirements in the week of 9/14? Number For the Axle table above, what are the planned Order Releases in the week of 8/17? Number