Given the Information Below, Complete the Materials Requirements Planning (MRP)

Essay

Given the information below, complete the materials requirements planning (MRP) record and explain what it tells the inventory analyst to do. $\begin{array}{|l|l|}\hline \text { Lot Size Rule: Fixed Q }=200 \text { units } & \text { Safety Stock: 0 units } \\\hline \text { Lead Time }=2 \text { weeks } & \text { Current On-Hand Quantity }=100 \text { units } \\\hline\end{array}$ $\begin{array}{|l|l|l|l|l|l|l|l|l|}\hline \text { Week } & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 \\\hline \text { Gross Requirement } & 50 & 100 & 60 & 0 & 0 & 50 & 90 & 200 \\\hline \text { Scheduled Receipts } & & 200 & & & & & & \\\hline \text { Projected On Hand 100 } & & & & & & & & \\\hline \text { Planned Receipts } & & & & & & & & \\\hline \text { Planned Order Release } & & & & & & & &\\\hline \end{array}$