Question: How would I solve this using an excel sheet? Every time I ask this question, the answers are incorrect. I have the correct answers listed
How would I solve this using an excel sheet? Every time I ask this question, the answers are incorrect. I have the correct answers listed below.

Bill of Material for Toy Car Assembly 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: 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 g/7? Your response Correct response 1800 3,360 Grade: 011.0 0 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? Your response Correct response Grade: 01.0 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 8/14 ? Your response Correct response 300 3,000 For the Axle table above, what are the Planned Order Releases in the week of 8/17? Bill of Material for Toy Car Assembly 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: 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 g/7? Your response Correct response 1800 3,360 Grade: 011.0 0 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? Your response Correct response Grade: 01.0 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 8/14 ? Your response Correct response 300 3,000 For the Axle table above, what are the Planned Order Releases in the week of 8/17
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
