Assume that Product Z is made of two units of A and three units of B. A is made of four units of C and four of D. D is made of two units of E. Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks; A, B, C, and D take one week each; and E takes three weeks. Sixty-four units of Product Z are required in Period 10. (Assume that there is currently no inventory on-hand of any of these items.) b. Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates. Note: Leave the cells blank, whenever zero (0) is required. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{12}{|c|}{ Answer is complete but not entirely correct. } \\ \hline & Period: & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10 \\ \hline \multirow{6}{*}{\begin{tabular}{l} Item: Z \\ OH: 0 \\ LT: 2 \\ SS: 0 \\ Q: L4L \end{tabular}} & Gross requirements & 00 & 00 & 00 & 00 & 00 & 00 & 512 & 00 & 00 & \\ \hline & Scheduled receipts & 00 & 0 & 00 & 00 & 0 & 0 & 00 & 00 & 00 & 00 \\ \hline & Projected available balance & 00 & 02 & 00 & 00 & 02 & 02 & 0 & 0 & 0 & 0 \\ \hline & Net requirements & 00 & 00 & 00 & 00 & 00 & 00 & 512 & 00 & 00 & \\ \hline & Planned order receipts & 0 & 0 & 02 & 00 & 0 & 00 & 512 & 00 & 02 & 64 \\ \hline & Planned order releases & 0 & 0 & 00 & 00 & 0 & & 00 & 640 & 00 & 00 \\ \hline \multirow{6}{*}{\begin{tabular}{l} Item: A \\ OH: 0 \\ LT: 1 \\ SS: 0 \\ Q: L4L \end{tabular}} & Gross requirements & 0 & 00 & 00 & 00 & 0 & 0 & 00 & 1,280x & 00 & 00 \\ \hline & Scheduled receipts & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 \\ \hline & Projected available balance & 00 & 0 & 02 & 0 & 02 & 00 & 00 & 00 & 0 & 00 \\ \hline & Net requirements & 02 & 0 & 00 & 00 & 02 & 02 & 02 & 1,920x & 0 & 00 \\ \hline & Planned order receipts & 00 & 0 & 02 & 00 & 00 & 00 & 0 & 512 & 00 & 00 \\ \hline & Planned order releases & 00 & 0 & 00 & 00 & 00 & 00 & 512 & 00 & 00 & 00 \\ \hline \multirow{6}{*}{\begin{tabular}{l} Item: B \\ OH: 0 \\ LT: 1 \\ SS: 0 \\ Q: L4L \end{tabular}} & Gross requirements & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 512 & 00 & 00 \\ \hline & Scheduled receipts & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 \\ \hline & Projected available balance & 02 & 00 & 00 & 00 & 02 & 02 & 00 & 00 & 00 & 00 \\ \hline & Net requirements & 00 & 00 & 00 & 00 & 0 & 00 & 00 & 512 & 00 & 00 \\ \hline & Planned order receipts & 0 & 0 & 00 & 00 & 0 & 0 & 00 & 512 & 00 & 00 \\ \hline & Planned order releases & 00 & 0 & 00 & 00 & 00 & 00 & 512 & 00 & 00 & 00 \\ \hline \multirow{6}{*}{\begin{tabular}{c} Item: C \\ OH: 0 \\ LT: 1 \\ SS: 0 \\ Q: L4L \end{tabular}} & Gross requirements & 00 & 00 & 00 & 00 & 00 & 00 & 512 & 00 & 00 & 00 \\ \hline & Scheduled receipts & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 \\ \hline & Projected available balance & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 \\ \hline & Net requirements & 0 & 0 & 00 & 00 & 0 & 0 & 512 & 00 & 00 & 00 \\ \hline & Planned order receipts & 00 & 00 & 02 & 00 & 00 & 00 & 512 & 00 & 00 & 00 \\ \hline & Planned order releases & 00 & 00 & 00 & 00 & 00 & 512 & 00 & 00 & 00 & 00 \\ \hline \multirow{6}{*}{\begin{tabular}{c} Item: D \\ OH: 0 \\ LT: 1 \\ SS: 0 \\ Q: L4L \end{tabular}} & Gross requirements & 00 & 00 & 00 & 00 & 00 & 00 & 512 & 00 & 00 & 00 \\ \hline & Scheduled receipts & 02 & 00 & 00 & 00 & 02 & 02 & 00 & 00 & 00 & 00 \\ \hline & Projected available balance & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 \\ \hline & Net requirements & 00 & 0 & 00 & 00 & 0 & 0 & 512 & 00 & 00 & 00 \\ \hline & Planned order receipts & 00 & 0 & 00 & 00 & 0 & 0 & 512 & 00 & 00 & 00 \\ \hline & Planned order releases & 00 & 00 & 00 & 00 & 00 & 512 & 00 & 00 & 00 & 00 \\ \hline \multirow{6}{*}{\begin{tabular}{l} Item: E \\ OH: 0 \\ LT: 3 \\ SS: 0 \\ Q: L4L \end{tabular}} & Gross requirements & 00 & 00 & 00 & 00 & 00 & 512 & 00 & 00 & 00 & 00 \\ \hline & Scheduled receipts & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 \\ \hline & Projected available balance & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 & 00 \\ \hline & Net requirements & 00 & 00 & 02 & 00 & 00 & 1,024 & 00 & 00 & 00 & 00 \\ \hline & Planned order receipts & 00 & 00 & 00 & 00 & 00 & 1,024 & 00 & 00 & 00 & 00 \\ \hline & Planned order releases & 00 & 00 & 1,024 & 00 & 00 & 0 & 00 & 00 & 00 & 00 \\ \hline \end{tabular}