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

Question

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

Quizplus · Accepted Answer

To calculate the available balance for each week, you start with the initial available balance and adjust it based on the scheduled receipts and gross requirements for each week. For week 1, you start with 12 units, add 0 scheduled receipts, and subtract the 5 units required, leaving 7 units. This process is repeated for each subsequent week, taking the new available balance from the previous week, adding any scheduled receipts, and subtracting the gross requirements. The correct sequence of available balances is 7 / 17 / 7 / 27 / 32 / 22 / 27.

Complete the MRP Spreadsheet Below for a Component Which Is