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.

How would I solve this using an excel sheet? Every time I

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!