b. Develop a material requirements plan (MRP) by finishing the attached Excel template (HW5_P1(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).

\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}