Hello, please help me solve this problem. Here is the complete question below.
Bill of Material for Toy Truck Assembly Toy Truck Final Assembly Wheel Body Assembly (3 required) (1 required) Axle Wheel (1 required) (2 required) MS.54 A toy company needs to calculate material requirements for its top-selling toy truck. The graphic above shows the bill of material for this item. Below are three MRP tables for the top-level assembly (the truck) and some of its components Toy Truck Final Assembly 8/1 8/8 8/15 8/22 8/29 9/5 9/12 9/19 9/26 Gross Requirements 2400 3400 4800 Scheduled Receipts Projected On-Hand Inv. 1,000 Net Requirements Planned Order Receipts Planned Order Releases Lead Time (in weeks) Lot Size 400 Wheel Assembly 8/1 8/8 |8/15 8/22 8/29 9/5 9/12 9/19 9/26 Gross Requirements Scheduled Receipts 2300 Projected On-Hand Inv. 2,700 Net Requirements Planned Order Receipts Planned Order Releases Lead Time (in weeks) Lot Size 800 Axle 8/1 8/8 |8/15 8/22 8/29 9/5 9/12 9/19 9/26 Gross Requirements Scheduled Receipts Projected On-Hand Inv. 4,000 Net Requirements Planned Order Receipts Planned Order Releases Lead Time (in weeks) Lot Size 1,000 HINT: Make sure you properly account for the bill of material information in this problem (especially the right quantity of components required per parent assembly). For example, how many wheel assemblies are required per toy truck? For the Toy Truck table above, what is the Projected On-Hand Inventory in the week of 9/26? Number For the Toy Truck table above, what are the Net Requirements in the week of 8/15? Number For the Toy Truck table above, what are the Planned Order Releases in the week of 9/12? Number For the Wheel Assembly table above, what are the Gross Requirements in the week of 9/12? Number For the Wheel Assembly table above, what are the Net Requirements in the week of 8/29? Number For the Wheel Assembly table above, what are the Planned Order Receipts in the week of 9/12? Number For the Axle table above, what are the Gross Requirements in the week of 8/29? Number For the Axle table above, what is the Projected On-Hand Inventory in the week of 8/29? Number