Using and showing excel formulas solve this 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. 9/21 9/28 Toy Car Final Assembly 8/3 8/10 8/17 8/24 8/31 9/7 9/14 1100 1900 2200 Gross Requirements 1000 Scheduled Receipts 440 450 260 Projected On-Hand Inv. 200 Net Requirements Planned Order Receipts Planned Order Releases Lead 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 1600 2100 1600 Projected On-Hand Inv. 900 Net Requirements Planned Order Receipts Planned Order Releases Lead Time (in weeks) Lot Size 200 Axle 8/3 8/10 8/17 8/24 8/31 9/7 9/14 9/21 9/28 Gross Requirements Scheduled Receipts 1400 2000 Projected On-Hand Inv. 700 Net Requirements Planned Order Receipts Planned Order Releases Lead Time (in weeks) ot Size 200 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