1 2 3 3 0 0 0 0 0 0 On hand = 40 LT=1 Lot size: 50 Saftey Stock=0 0 Weeks Top Gross Requirement Scheduled Receipts Projected Ending Inventory Net Requirement Planned order receipts Planned order releases 0 olololololo 0 0 0 0 0 0 100 0 0 100 100 0 0 0 0 ololololo 1.50 0 0 150 150 200 200 0 0 200 200 0 0 0 0 0 0 0 100 SOO 0 150 0 0 On hand-240 LT=1 Lot: 50* 4200 Saftey. Stock=0 Wheel assemblies (1) Gross Requirement Scheduled Receipts Projected Ending Inventory Net Requirement Planned order receipts Planned order releases 0 0 40 0 200 0 240 0 0 0 600 0 40 560 600 40 40 800 0 40 760 800 0 0 0 40 0 0 olololololo ooooo 0 40 0 ololololo Sogoa 0 0 40 0 0 0 Ooo 0 600 800 0 0 0 100 0 On hand=120 LT=2 k Lot: 502 =100 Saftey Stock 0 Seats (2) Gross Requirement Scheduled Receipts Projected Ending Inventory Net Requirement Planned order receipts Planned order releases 0 0 120 0 150 0 20 &o 120 0 120 0 0 0 20 0 0 120 0 0 0 120 0 0 0 8. Soos 200 0 20 180 200 0 0 0 20 0 0 0 130 0 0 150 150 0 0 200 3 d. Based on part ().what items have "planned order receipts" or "planned order releases" that must occur before week 17 Tivota8.10.52%. what items need to be obtained immediately? How many for each of them? 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 p1(c)). If one order cannot cover net requirement (planned order receipts equals order size), you can increase the mamber 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=k Lot size50 Sattey Stock=0 Weeks Top Gross Requirement Scheduled Receipts Projected Ending Inventory Net Requirement Planned order receipts Planned order releases Wheel assemblies (4) On hand-240 Gross Requirement LT- Scheduled Receipts Lot: 504=200 Projected Ending Inventory Sifa Stock=0 Net Requirement Planned order receipts Planned order releases On and 120 LT2uk Lot: 50*2=100 Safy Stock=0 Seats (2) Gross Requirement Scheduled Receipts Projected Ending luventory Net Requirement Planned order receipts Planned order releases