Part 1: Given the Master Production Schedule and Product Structure for product DR-X below, compute for all figures in the blank cells 1-18 (green-shaded):

Week -->	5	6	7	8	9	10
Gross Requirements		20		20		20
Part #	Lead Time	Qty On Hand		Part #	Lead Time	Qty On Hand
DR-X	1	22		C	1	0
B1	2	8		D	1	0
B2	2	6		E	3	10
A1	1	5

Part 2: From your computations in Part A above, fill-up blank cells 1 - 22 (green-shaded) below:

PRODUCT STRUCTURE \begin{tabular}{|c|c|c|c|c|c|} \hline Part\# & Level & \begin{tabular}{c} Qty Per \\ Unit of DR-X \end{tabular} & \begin{tabular}{c} Total \\ Reqmts \end{tabular} & \begin{tabular}{c} Lead \\ Time \end{tabular} & \begin{tabular}{c} Qty On \\ Hand \end{tabular} \\ \hline DR-X & 0 & 1 & 20 & 1 & 22 \\ \hline B1 & {[ blank01] } & {[ blank07] } & {[ blank13] } & 2 & 8 \\ \hline B2 & {[ blank02] } & {[ blank08] } & {[ blank14] } & 2 & 6 \\ \hline A1 & {[ blank03] } & {[ blank09] } & {[ blank15] } & 1 & 5 \\ \hline C & {[ blank04] } & {[ blank10] } & {[ blank16] } & 1 & 0 \\ \hline D & {[ blank05] } & {[ blank11 ]} & {[ blank17] } & 1 & 0 \\ \hline E & {[ blank06] } & {[ blank12] } & {[ blank18] } & 3 & 10 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{l} Lead \\ Time \end{tabular}} & \multirow{2}{*}{\begin{tabular}{l} Qty On \\ Hand \end{tabular}} & \multirow{2}{*}{ Level } & \multirow{2}{*}{ Part \# } & & \multicolumn{10}{|c|}{ PERIOD } \\ \hline & & & & & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10 \\ \hline \multirow{5}{*}{1} & \multirow{5}{*}{22} & \multirow{5}{*}{0} & \multirow{5}{*}{ DR-X } & Gross Requirements & & & & & & 20 & & 20 & & 20 \\ \hline & & & & Projected On Hand & & & & & & & & 1 & & \\ \hline & & & & Net Requirements (Surplus) & & & & & & & & & & \\ \hline & & & & Planned order receipts & & & & & & 22 & & 2 & & \\ \hline & & & & Planned Order Releases & & & & & & & 18 & & 3 & \\ \hline \multirow{5}{*}{2} & \multirow{5}{*}{8} & \multirow{5}{*}{1} & \multirow{5}{*}{ B1 } & Gross Requirements & & & & & & & 4 & & 5 & \\ \hline & & & & Projected On Hand & & & & & 6 & & 8 & & & \\ \hline & & & & Net Requirements (Surplus) & & & & & & & & & & \\ \hline & & & & Planned order receipts & & & & & & & 7 & & 20 & \\ \hline & & & & Planned Order Releases & & & & & 8 & & 9 & & & \\ \hline \multirow{5}{*}{2} & \multirow{5}{*}{6} & \multirow{5}{*}{1} & \multirow{5}{*}{ B2 } & Gross Requirements & & & & & & & 10 & & 11 & \\ \hline & & & & Projected On Hand & & & & & 12 & & 6 & & & \\ \hline & & & & Net Requirements (Surplus) & & & & & & & & & & \\ \hline & & & & Planned order receipts & & & & & & & 13 & & 40 & \\ \hline & & & & Planned Order Releases & & & & & 14 & & 15 & & & \\ \hline \multirow{5}{*}{1} & \multirow{5}{*}{5} & \multirow{5}{*}{2} & \multirow{5}{*}{ A1 } & Gross Requirements & & & & & 16 & & 17 & & & \\ \hline & & & & Projected On Hand & & & & 5 & 5 & & & & & \\ \hline & & & & Net Requirements (Surplus) & & & & & & & & & & \\ \hline & & & & \begin{tabular}{|c|} Planned order receipts \\ \end{tabular} & & & & & 5 & & 20 & & & \\ \hline & & & & Planned Order Releases & & & & & & 20 & & & & \\ \hline \multirow{5}{*}{1} & \multirow{5}{*}{0} & & & Gross Requirements & & & & & & & & & & \\ \hline & & & & Projected On Hand & & & & & & & & & & \\ \hline & & 2 & C & Net Requirements (Surplus) & & & & & & & & & & \\ \hline & & & & Planned order receipts & & & & & & & & & & \\ \hline & & & & Planned Order Releases & & & & & & 18 & & & & \\ \hline & & & & Gross Requirements & & & & & & & & & & \\ \hline & & & & Projected On Hand & & & & & & & & & & \\ \hline 1 & 0 & 2 & D & Net Requirements (Surplus) & & & & & & & & & & \\ \hline & & & & Planned order receipts & & & & & & & & & & \\ \hline & & & & Planned Order Releases & & & & & & 19 & & & & \\ \hline & & & & Gross Requirements & & & & 90 & & 120 & & & & \\ \hline & & & & Projected On Hand & 20 & & & 10 & & & & & & \\ \hline 3 & 10 & 3 & E & Net Requirements (Surplus) & & & & & & & & & & \\ \hline & & & & Planned order receipts & & & & 80 & & 120 & & & & \\ \hline & & & & Planned Order Releases & 21 & & 22 & & & & & & & \\ \hline \end{tabular} PRODUCT STRUCTURE \begin{tabular}{|c|c|c|c|c|c|} \hline Part\# & Level & \begin{tabular}{c} Qty Per \\ Unit of DR-X \end{tabular} & \begin{tabular}{c} Total \\ Reqmts \end{tabular} & \begin{tabular}{c} Lead \\ Time \end{tabular} & \begin{tabular}{c} Qty On \\ Hand \end{tabular} \\ \hline DR-X & 0 & 1 & 20 & 1 & 22 \\ \hline B1 & {[ blank01] } & {[ blank07] } & {[ blank13] } & 2 & 8 \\ \hline B2 & {[ blank02] } & {[ blank08] } & {[ blank14] } & 2 & 6 \\ \hline A1 & {[ blank03] } & {[ blank09] } & {[ blank15] } & 1 & 5 \\ \hline C & {[ blank04] } & {[ blank10] } & {[ blank16] } & 1 & 0 \\ \hline D & {[ blank05] } & {[ blank11 ]} & {[ blank17] } & 1 & 0 \\ \hline E & {[ blank06] } & {[ blank12] } & {[ blank18] } & 3 & 10 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{l} Lead \\ Time \end{tabular}} & \multirow{2}{*}{\begin{tabular}{l} Qty On \\ Hand \end{tabular}} & \multirow{2}{*}{ Level } & \multirow{2}{*}{ Part \# } & & \multicolumn{10}{|c|}{ PERIOD } \\ \hline & & & & & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10 \\ \hline \multirow{5}{*}{1} & \multirow{5}{*}{22} & \multirow{5}{*}{0} & \multirow{5}{*}{ DR-X } & Gross Requirements & & & & & & 20 & & 20 & & 20 \\ \hline & & & & Projected On Hand & & & & & & & & 1 & & \\ \hline & & & & Net Requirements (Surplus) & & & & & & & & & & \\ \hline & & & & Planned order receipts & & & & & & 22 & & 2 & & \\ \hline & & & & Planned Order Releases & & & & & & & 18 & & 3 & \\ \hline \multirow{5}{*}{2} & \multirow{5}{*}{8} & \multirow{5}{*}{1} & \multirow{5}{*}{ B1 } & Gross Requirements & & & & & & & 4 & & 5 & \\ \hline & & & & Projected On Hand & & & & & 6 & & 8 & & & \\ \hline & & & & Net Requirements (Surplus) & & & & & & & & & & \\ \hline & & & & Planned order receipts & & & & & & & 7 & & 20 & \\ \hline & & & & Planned Order Releases & & & & & 8 & & 9 & & & \\ \hline \multirow{5}{*}{2} & \multirow{5}{*}{6} & \multirow{5}{*}{1} & \multirow{5}{*}{ B2 } & Gross Requirements & & & & & & & 10 & & 11 & \\ \hline & & & & Projected On Hand & & & & & 12 & & 6 & & & \\ \hline & & & & Net Requirements (Surplus) & & & & & & & & & & \\ \hline & & & & Planned order receipts & & & & & & & 13 & & 40 & \\ \hline & & & & Planned Order Releases & & & & & 14 & & 15 & & & \\ \hline \multirow{5}{*}{1} & \multirow{5}{*}{5} & \multirow{5}{*}{2} & \multirow{5}{*}{ A1 } & Gross Requirements & & & & & 16 & & 17 & & & \\ \hline & & & & Projected On Hand & & & & 5 & 5 & & & & & \\ \hline & & & & Net Requirements (Surplus) & & & & & & & & & & \\ \hline & & & & \begin{tabular}{|c|} Planned order receipts \\ \end{tabular} & & & & & 5 & & 20 & & & \\ \hline & & & & Planned Order Releases & & & & & & 20 & & & & \\ \hline \multirow{5}{*}{1} & \multirow{5}{*}{0} & & & Gross Requirements & & & & & & & & & & \\ \hline & & & & Projected On Hand & & & & & & & & & & \\ \hline & & 2 & C & Net Requirements (Surplus) & & & & & & & & & & \\ \hline & & & & Planned order receipts & & & & & & & & & & \\ \hline & & & & Planned Order Releases & & & & & & 18 & & & & \\ \hline & & & & Gross Requirements & & & & & & & & & & \\ \hline & & & & Projected On Hand & & & & & & & & & & \\ \hline 1 & 0 & 2 & D & Net Requirements (Surplus) & & & & & & & & & & \\ \hline & & & & Planned order receipts & & & & & & & & & & \\ \hline & & & & Planned Order Releases & & & & & & 19 & & & & \\ \hline & & & & Gross Requirements & & & & 90 & & 120 & & & & \\ \hline & & & & Projected On Hand & 20 & & & 10 & & & & & & \\ \hline 3 & 10 & 3 & E & Net Requirements (Surplus) & & & & & & & & & & \\ \hline & & & & Planned order receipts & & & & 80 & & 120 & & & & \\ \hline & & & & Planned Order Releases & 21 & & 22 & & & & & & & \\ \hline \end{tabular}