End item Alpha's product structure tree and inventory information are as follows: All parts can be ordered using lot-for-lot ordering. (1) If 50 units of Alpha are to be assembled, how many additional units of S will be needed? (Your answer must include the calculation in text or in an uploaded Excel file. ) (2) An order for 100 units of Alpha is scheduled to be shipped at the start of week 9. When is the latest week that any particular component must be started so that the order for Alpha will be ready to ship? \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|l|} \hline Master Schedule for: & Week & & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 \\ \hline \end{tabular} Week \begin{tabular}{|l|c|c|c|c|c|c|c|c|c|} \hline Item: Lot size : & 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 receipts & & & & & & & & & \\ \hline Planned-order releases & & & & & & & & & \\ \hline \end{tabular} Week \begin{tabular}{|l|c|c|c|c|c|c|c|c|c|} \hline Item: Lot size: & 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 receipts & & & & & & & & & \\ \hline Planned-order releases & & & & & & & & & \\ \hline \end{tabular} Week \begin{tabular}{|l|c|c|c|c|c|c|c|c|c|} \hline Item: Lot size: & 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 receipts & & & & & & & & & \\ \hline Planned-order releases & & & & & & & & & \\ \hline \end{tabular}