Given the following information, develop a material requirements plan (MRP) for end item A and its components. 50 and 80 units of A are needed at the beginning of week 6 and 8 , respectively. 1. The planned-order release for product A is: 2. The planned-order release for product B is: 3. The planned-order release for product C is: 4. The planned-order release for product D is: 5. The planned-order release for product E is: The attached spreadsheet may be useful in calculating the answers. \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|l|} \hline Item: LT=Qe & \multicolumn{1}{|c|}{ Week } & Beg. Inv. & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 \\ \hline & Gross requirements & & & & & & & & & \\ \hline & Scheduled receipts & & & & & & & & \\ \hline & Projected on hand & & & & & & & & \\ \hline Net requirements & & & & & & & & & \\ \hline & Planned-order receipt & & & & & & & & \\ \hline & Planned-order release & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|l|} \hline Item: LT= Q= & \multicolumn{1}{|c|}{ Week } & Beg. Inv. & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 \\ \hline & Gross requirements \\ \cline { 1 - 9 } & Scheduled receipts & & & & & & & & & \\ \hline & Projected on hand & & & & & & & & \\ \hline & Net requirements & & & & & & & & & \\ \hline & Planned-order receipt & & & & & & & & & \\ \hline & Planned-order release & & & & & & & & \\ \hline \end{tabular}