Complete the MRP Spreadsheet Below for a Component Which Is

Multiple Choice

Complete the MRP spreadsheet below for a component which is ordered in varying quantities over weeks 1 - 7. $$\begin{array} { | l | l | l | l | l | l | l | l | l | } \hline \text { Week } & 0 & 1 & 2 & 3 & 4 & 5 & 6 & 7 \\\hline \begin{array} { l } \text { Gross } \\\text { Requirement }\end{array} & & 5 & 20 & 10 & 10 & 20 & 10 & 25 \\\hline \begin{array} { l } \text { Scheduled } \\\text { Receipts }\end{array} & & 0 & 30 & 0 & 30 & 25 & 0 & 30 \\\hline \begin{array} { l } \text { Available } \\\text { Balance }\end{array} & 12 & \mathrm { X } & \mathrm { X } & \mathrm { X } & \mathrm { X } & \mathrm { X } & \mathrm { X } & \mathrm { X } \\\hline\end{array}$$ Which answer should correctly replace the Xs?

A) 7 / 17 / 7 / 27 / 32 / 22 / 27
B) 7 / 37 / 57 / 37 / 12 / 22 / 17
C) 17 / 22 / 32 / 52 / 47 / 37 / 32
D) 17 / 27 / 17 / 37 / 12 / 2 / 7
E) 7 / 17 / 27 / 47 / 22 / 12 / 17