Please use and show excel formulas

Bill of Material for Toy Car Assembly Planned Order Receipts Planned Order Releases Lead Time (in weeks) Toy Car Lot Size 400 Final Assembly For the Toy Car table above, what are the Planned Order Receipts in the week of 8/31? Wheel Assembly (2 required) Body (1 required) For the Toy Car table above, what are the Planned Order Releases in the week of 9/21? Axle Wheel (1 required) (2 required) For the Wheel Assembly table above, what are the Gross Requirements in the week of 9/7? 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 For the Wheel Assembly table above, what is the Projected On-Hand Inventory in the week of 8/31? components Toy Car Final Assembly 8/2 3 8/3 9/2 9/2 For the Wheel Assembly table above, what are the Net Requirements in the week of 8/24? Gross Requirements 800 1300 2100 2300 Scheduled Receipts 280 690 280 For the Axle table above, what are the Gross Requirements in the week of 9/7? Projected On-Hand Inv. 80 Net Requirements Planned Order Receipts For the Axle table above, what are the Gross Requirements in the week of 9/14? Planned Order Releases Lead Time (in weeks) -8 Lot Size For the Axle table above, what are the Planned Order Releases in the week of 8/17? Wheel Assembly 8/2 8/3 9/ 7 9/1 9/2 9/2 Gross Requirements Scheduled Receipts 1800 1700 1800 Projected On-Hand Inv. 700 Net Requirements Planned Order Receipts Planned Order Releases Lead Time (in weeks) Lot Size 100 8/1 8/2 8/3 9/ 9/1 9/2 9/2 Axle Gross Requirement Scheduled Receipts 700 1700 Projected On-Hand Inv. 600 Net Requirements