Using excel and showing formulas please answer the following question

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/10 8/17 8/24 8/31 9/7 9/14 9/21 9/28 Toy Car Final Assembly 8/3 800 1300 2100 2300 Gross Requirements 280 Scheduled Receipts 280 690 Projected On-Hand Inv. 80 Net Requirements Planned Order Receipts Planned Order Releases ead Time (in weeks) Lot Size 80 Wheel Assembly 8/3 8/10 8/17 8/24 8/31 9/7 9/14 9/21 9/28 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 Axle 8/3 8/10 8/17 8/24 8/31 9/7 9/14 9/21 9/28 Gross Requirements Scheduled Receipts 700 1700 Projected On-Hand Inv. 600 Net Requirements Planned Order Receipts Planned Order Releases Lead Time (in weeks) Lot Size 400 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 abo the Projected On-Hand Inventory in the week of 8/31? Number For the Wheel Assembly table abo 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