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 (HW5_P1(c)). 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 wk1, 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.

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?

\begin{tabular}{lcc} Parts List for Electric Golf Cart & Lead Time & Quantity on Hand \\ \hline Electric golf cart & 1 & 0 \\ Top & 1 & 40 \\ Supports (4) & 1 & 200 \\ Cover & 1 & 0 \\ Base & 1 & 20 \\ Motor & 2 & 300 \\ Body & 3 & 50 \\ Frame & 1 & 35 \\ Controls & 1 & 0 \\ Wheel assemblies (4) & 1 & 240 \\ Seats (2) & 2 & 120 \end{tabular} Wheel assemblies (4) On hand =240 Gross Requirement LT=1wk Scheduled Receipts Lot size =504 Projected Ending Inventory Saftey Stock =0 Net Requirement Planned order receipts Planned order releases Seats (2) On hand =120 Gross Requirement LT=2wk Scheduled Receipts Lot size =502 Projected Ending Inventory Saftey Stock =0 Net Requirement Planned order receipts Planned order releases \begin{tabular}{|l|l|l|l|l|l|l|l|l|} \hline & & & & & & & & \\ \hline & & & & & & & & \\ \hline & & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & & \\ \hline \end{tabular}