Question: Develop a material requirements plan for component H. Lead times for the end item and each component except B are one week. The lead time



Develop a material requirements plan for component H. Lead times for the end item and each component except B are one week. The lead time for B is three weeks. Sixty units of A are needed at the start of week 8 . There are currently 15 units of B on hand and 130 of E on hand, and 50 units of H are in production and will be completed by the start of week 2. (Leave no cells blank - be certain to enter " 0 " wherever required.) Master Schedule \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hlineALT=1 & \begin{tabular}{l} Boginning \\ imvertony \\ \end{tabular} & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 \\ \hline \multicolumn{10}{|l|}{ Gross requirumonts } \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Scheduled recoipts \\ Projected on hand \end{tabular}}} \\ \hline & & & & & & & & & \\ \hline \multicolumn{10}{|l|}{\begin{tabular}{l} Net requirements. \\ Plamed-onser receipts \end{tabular}} \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Plamed-onder roceipts \\ Planned-onder releases \end{tabular}}} \\ \hline & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & \begin{tabular}{l} Begining \\ ineriogy \end{tabular} & 3 & 2 & 3 & 4 & 5 & 6 & 7 & 8 \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Grons requirentents \\ Scheduled recopts \\ Projected on hand \end{tabular}}} \\ \hline & & & & & & & & & \\ \hline Projocted on hand & & & & & & & & & \\ \hline Net roquirements & & & & & & & & & \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Planned-orbar recapts \\ Planned-onder releases \end{tabular}}} \\ \hline Pianned-onder releases & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hlineCLT=1 & \begin{tabular}{l} Beginning \\ irventory \\ \end{tabular} & 1 & 2 & 3 & 4 & 5 & 6. & 7 & 8 \\ \hline \multicolumn{10}{|l|}{ Gross requirements } \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Scheduled recelpts \\ Projected on hand \end{tabular}}} \\ \hline & & & & & & & & & \\ \hline \multicolumn{10}{|l|}{\begin{tabular}{l} Net requirements \\ Planned-crder receipts \end{tabular}} \\ \hline \multicolumn{10}{|l|}{\begin{tabular}{l} Planned-crder receipts \\ Planned-crder roleases \end{tabular}} \\ \hline Planned-order roleases & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hlineE(2)E(4)LT=1 & \begin{tabular}{l} Boginning \\ invindory \end{tabular} & 1 & 2 & 3 & 4 & 5 & 6 & 7 & a \\ \hline Grost requirements & & & & & & & & & \\ \hline Scheduled recoipts & & & & & & & & & \\ \hline Projected on hand & & & & & & & & & \\ \hline \multicolumn{10}{|l|}{\begin{tabular}{l} Net requirementa \\ Planned-order recelpts \\ Planned-order releases \end{tabular}} \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Planned-order feceipts \\ Planned-order releases \end{tabular}}} \\ \hline Planned-onder releases & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hlineH(ES)H(E)LT=1 & \begin{tabular}{l} Beginning \\ inventory \end{tabular} & 1 & 2 & 3 & 4 & 5 & 6 & 7 & B \\ \hline \multicolumn{10}{|l|}{\begin{tabular}{l} Gross requiroments \\ Scheduled receipts \end{tabular}} \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Scheduled recoipts \\ Projected on hand \\ Net reouirements \end{tabular}}} \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Projected on hand \\ Net requirements \\ Planned-crder mentots \end{tabular}}} \\ \hline Net requirements & & & & & & & & & \\ \hline Planned-order mocelpts & & & & & & & & & \\ \hline Planned-order releases & & & & & & & & & \\ \hline \end{tabular} Develop a material requirements plan for component H. Lead times for the end item and each component except B are one week. The lead time for B is three weeks. Sixty units of A are needed at the start of week 8 . There are currently 15 units of B on hand and 130 of E on hand, and 50 units of H are in production and will be completed by the start of week 2. (Leave no cells blank - be certain to enter " 0 " wherever required.) Master Schedule \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hlineALT=1 & \begin{tabular}{l} Boginning \\ imvertony \\ \end{tabular} & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 \\ \hline \multicolumn{10}{|l|}{ Gross requirumonts } \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Scheduled recoipts \\ Projected on hand \end{tabular}}} \\ \hline & & & & & & & & & \\ \hline \multicolumn{10}{|l|}{\begin{tabular}{l} Net requirements. \\ Plamed-onser receipts \end{tabular}} \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Plamed-onder roceipts \\ Planned-onder releases \end{tabular}}} \\ \hline & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & \begin{tabular}{l} Begining \\ ineriogy \end{tabular} & 3 & 2 & 3 & 4 & 5 & 6 & 7 & 8 \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Grons requirentents \\ Scheduled recopts \\ Projected on hand \end{tabular}}} \\ \hline & & & & & & & & & \\ \hline Projocted on hand & & & & & & & & & \\ \hline Net roquirements & & & & & & & & & \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Planned-orbar recapts \\ Planned-onder releases \end{tabular}}} \\ \hline Pianned-onder releases & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hlineCLT=1 & \begin{tabular}{l} Beginning \\ irventory \\ \end{tabular} & 1 & 2 & 3 & 4 & 5 & 6. & 7 & 8 \\ \hline \multicolumn{10}{|l|}{ Gross requirements } \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Scheduled recelpts \\ Projected on hand \end{tabular}}} \\ \hline & & & & & & & & & \\ \hline \multicolumn{10}{|l|}{\begin{tabular}{l} Net requirements \\ Planned-crder receipts \end{tabular}} \\ \hline \multicolumn{10}{|l|}{\begin{tabular}{l} Planned-crder receipts \\ Planned-crder roleases \end{tabular}} \\ \hline Planned-order roleases & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hlineE(2)E(4)LT=1 & \begin{tabular}{l} Boginning \\ invindory \end{tabular} & 1 & 2 & 3 & 4 & 5 & 6 & 7 & a \\ \hline Grost requirements & & & & & & & & & \\ \hline Scheduled recoipts & & & & & & & & & \\ \hline Projected on hand & & & & & & & & & \\ \hline \multicolumn{10}{|l|}{\begin{tabular}{l} Net requirementa \\ Planned-order recelpts \\ Planned-order releases \end{tabular}} \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Planned-order feceipts \\ Planned-order releases \end{tabular}}} \\ \hline Planned-onder releases & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hlineH(ES)H(E)LT=1 & \begin{tabular}{l} Beginning \\ inventory \end{tabular} & 1 & 2 & 3 & 4 & 5 & 6 & 7 & B \\ \hline \multicolumn{10}{|l|}{\begin{tabular}{l} Gross requiroments \\ Scheduled receipts \end{tabular}} \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Scheduled recoipts \\ Projected on hand \\ Net reouirements \end{tabular}}} \\ \hline \multirow{2}{*}{\multicolumn{10}{|c|}{\begin{tabular}{l} Projected on hand \\ Net requirements \\ Planned-crder mentots \end{tabular}}} \\ \hline Net requirements & & & & & & & & & \\ \hline Planned-order mocelpts & & & & & & & & & \\ \hline Planned-order releases & & & & & & & & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
