\begin{tabular}{|c|c|c|c|c|c|c|c|r|r|} \hline \multirow{2}{*}{\begin{tabular}{c} Gro-Pup Seattle \\ Warehouse \end{tabular}} & & \multicolumn{7}{|c|}{ Period } \\ \cline { 2 - 10 } & & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 \\ \hline forecast Requirements & & 20 & 20 & 20 & 20 & 20 & 20 & 20 & 20 \\ \hline In Transit & & & & & & & & & \\ \hline \begin{tabular}{c} Projected Available \\ Balance \end{tabular} & 21 & & & & & & & & \\ \hline \begin{tabular}{c} Planned Shipments \\ Q =60 lead time =1 \end{tabular} & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{c} Gro-Pup Portland \\ Warehouse \end{tabular}} & & \multicolumn{7}{|c|}{ Period } \\ \cline { 2 - 10 } & & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 \\ \hline forecast Requirements & & 10 & 10 & 10 & 10 & 10 & 10 & 10 & 10 \\ \hline In Transit & & & & & & & & & \\ \hline \begin{tabular}{c} Projected Available \\ Balance \end{tabular} & & & & & & & & & \\ \hline \begin{tabular}{c} Planned Shipments \\ Q =15 lead time =1 Safety stock =0 \end{tabular} & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{c} Gro-Pup Plant \\ Warehouse \end{tabular}} & & \multicolumn{7}{|c|}{ Period } \\ \cline { 2 - 10 } & & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 \\ \hline Gross Requirements & & & & & & & & & \\ \hline \begin{tabular}{c} Scheduled Receipts \\ \begin{tabular}{c} Projected Available \\ Balance \end{tabular} \end{tabular} & -10 & & & & & & & \\ \hline \begin{tabular}{c} Planned Order Release \\ Q=50 lead time =2 \end{tabular} & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{c} Gro-Pup Packaging \\ Material \end{tabular}} & & \multicolumn{7}{|c|}{ Period } \\ \cline { 2 - 10 } & & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 \\ \hline Gross Requirements & & & & & & & & & \\ \hline Scheduled Receipts & & & & & & & & & \\ \hline \end{tabular} Distribution Requirements Planning Assignment 20 Marks 5\% Following on from Distribution Requirements Planning Tutorial Question 3 (MVA Pet Food) Update all four records as of the start of Week 2, assuming the following transactions occurred during week 1 Hint for above: Calculate the Ending inventory for Wk 1 for all first, then follow same steps as previously outlined in the Tutorial. So For example: Gro-pup Seattle, for Period 1 Sales were 19 not 20, Inventory was down 3, from a projected 23 to 20. Therefore the ending inventory or Available Balance at the end of Week 1 is 43-3-19 = 21 Which you will see in the Table below. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{c} Gro-Pup Packaging \\ Material \end{tabular}} & & \multicolumn{7}{|c|}{ Period } \\ \cline { 2 - 10 } & & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 \\ \hline Gross Requirements & & & & & & & & & \\ \hline \begin{tabular}{c} Scheduled Receipts \\ \begin{tabular}{c} Projected Available \\ Balance \end{tabular} \end{tabular} & & & & & & & & & \\ \hline \begin{tabular}{c} Planned Order Release \\ Q \end{tabular} & & & & & & & & \\ \hline \end{tabular}