Please do not copy and paste similar answers from the past. This is a different question asking different material. This is part B, I only need 8 weeks of Top, Wheel assembly, and seats.

A firm received an order of 200 electric golf carts. The carts must be ready for delivery by week 8. Based on the following information, finish the questions. Lead Time Parts List for Electric Golf Cart Electric golf cart Top Supports (4) Cover Base Motor Quantity on Hand 0 40 200 0 20 300 50 35 0 240 120 1 1 1 2 3 1 1 1 2 Body Frame Controls Wheel assemblies (4) Seats (2) b. Develop a material requirements plan (MRP) by finishing the attached Excel template (TAB pl(b)). Notice that 200 carts must be ready by week 8. Use lot-for-lot. To help me grade your HW, find the sections of Top, Wheel assemblies, and Seats in your finished MRP Excel. Copy & paste the sections to the table below (or take snapshots). No need to upload the Excel sheet. I will grade only these three sections. 1 2 3 4 5 6 7 8 On hand = 40 LT = 1 wk Lot size: L4L Saftey_Stock = 0 Weeks Top Gross Requirement Scheduled Receipts Projected Ending Inventory Net Requirement Planned order receipts Planned order releases On hand = 240 LT = 1 wk Lot size: L4L Saftey_Stock = 0 Wheel assemblies (4) Gross Requirement Scheduled Receipts Projected Ending Inventory Net Requirement Planned order receipts Planned order releases On hand = 120 LT = 2 wk Lot size: L4L Saftey Stock = 0 Seats (2) Gross Requirement Scheduled Receipts Projected Ending Inventory Net Requirement Planned order receipts Planned order releases