urgent

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 43319=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 Seattle \\ Warehouse \end{tabular}} & & \multicolumn{8}{|c|}{ Period } \\ \hline & & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 \\ \hline forecast Requirements & & 20 & 20 & 20 & 20 & 20 & 20 & 20 & 20 \\ \hline \multicolumn{10}{|l|}{ In Transit } \\ \hline \begin{tabular}{c} Projected Avaliable \\ Balance \end{tabular} & 21 & & & & & & & & \\ \hline \multicolumn{10}{|l|}{ Planned Shipments } \\ \hlineQ=60 lead time =1 & Safet & k=0 & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{l} Gro-Pup Portland \\ Warehouse \end{tabular}} & \multicolumn{8}{|c|}{ Period } \\ \hline & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 \\ \hline forecast Requirements & 10 & 10 & 10 & 10 & 10 & 10 & 10 & 10 \\ \hline \multicolumn{9}{|l|}{ In Transit } \\ \hline \multicolumn{9}{|l|}{\begin{tabular}{c} Projected Available \\ Balance \end{tabular}} \\ \hline \multicolumn{9}{|l|}{ Planned Shipments } \\ \hline Q=15 lead time =1 & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{l} Gro-Pup Plant \\ Warehouse \end{tabular}} & \multicolumn{8}{|c|}{ Period } \\ \hline & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 \\ \hline \multicolumn{9}{|l|}{ Gross Requirements } \\ \hline \multicolumn{9}{|l|}{ Scheduled Receipts } \\ \hline \begin{tabular}{c} Projected Available \\ Balance \end{tabular} & -10 & & & & & & & \\ \hline \multicolumn{9}{|l|}{ Planned Order Release } \\ \hline Q=50 lead time = & ck=0 & & & & & & & \\ \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 { 3 - 9 } & & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 \\ \hline Gross Requirements & & & & & & & & & \\ \hline Scheduled Receipts & & & & & & & & & \end{tabular}