Question: Please do not copy and paste similar answers from the past. This is a different question asking different material. This is part C, I only

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

Please do not copy and paste similar answers fromPlease do not copy and paste similar answers fromPlease do not copy and paste similar answers from

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) c. There is a change in the quantity and timing of orders for golf carts due to weather. The revised plan calls for 100 carts by week 6, 150 by week 8, and 200 by week 9. Furthermore, the firm now adopts a fixed order quantity lot sizing (lot size = 50). Develop an MRP for this new plan by finishing the Excel sheet (TAB plc)). If one order cannot cover net requirement (planned order receipts equals order size), you can increase the number of orders to 2 or more till net requirement is covered. Notice that there is no "week 0 or earlier. If planned order receipts or planned order releases must occur before wkl, simply ignore them. 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 9 On hand = 40 LT = 1 wk Lot size: 50 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: 50*4 = 200 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: 50*2 = 100 Saftey Stock = 0 Seats (2) Gross Requirement Scheduled Receipts Projected Ending Inventory Net Requirement Planned order receipts Planned order releases d. Based on part (c), what items have planned order receipts or planned order releases that must occur before week 1? That is to say.. what items need to be obtained immediately? How many for each of them

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!