(PLEASE SHOW YOUR EXCEL SHEET)

For the Toy Car table above, what are the Planned Order Receipts in the week of 8/31?

For the Toy Car table above, what are the Planned Order Releases in the week of 9/21?

For the Wheel Assembly table above, what are the Gross Requirements in the week of 9/7?

For the Wheel Assembly table above, what is the Projected On-Hand Inventory in the week of 8/31?

For the Wheel Assembly table above, what are the Net Requirements in the week of 8/24?

For the Axle table above, what are the Gross Requirements in the week of 9/7?

For the Axle table above, what are the Gross Requirements in the week of 9/14?

For the Axle table above, what are the Planned Order Releases in the week of 8/17?

Bill of Material for Toy Car Assembly Toy Car Final Assembly Wheel Assembly (2 required) Body (1 required) Axle (1 required) Wheel (2 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/24 917 9/21 8/17 1200 8/31 800 9/14 1900 350 9/28 2200 340 390 240 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 100 8/3 8/10 8/17 8/24 8/31 917 9/14 9/21 9/28 1000 1600 1800 900 Wheel Assembly Gross Requirements Scheduled Receipts Projected On-Hand Inv. Net Requirements Planned Order Receipts Planned Order Releases Lead Time (in weeks) Lot Size 250 8/3 8/10 8/17 8/24 8/31 977 9/14 9/21 9/28 1100 1600 700 Axle Gross Requirements Scheduled Receipts Projected On-Hand Inv. Net Requirements Planned Order Receipts Planned Order Releases Lead Time (in weeks) ||Lot Size 3 300