Use EXCEL to answer the question. See the excel file and solve the Q2 sheet.

Q2. 12 Tasks to 4 Workers (30 points, 6 for each part) Consider the following tasks that must be assigned to four workers on a worker-paced assembly line. Each worker must perform at least one task. There is unlimited demand. The current worker-paced assembly-line configuration assigns the workers in the following way: - Worker 1: Tasks 1, 2, 3 - Worker 2: Tasks 4, 5, 6 - Worker 3: Tasks 7, 8, 9 - Worker 4: Tasks 10, 11, 12 a. What is the hourly capacity of the current line? b. What is the direct labor content in seconds? c. What is the average labor utilization? d. How long would it take to produce 100 units, starting with an empty system? (Hint: refer to Exhibit 4.1 of Chapter 4 of CT) The firm is hiring two additional workers. Assume that tasks are re-allocated to the six workers to maximize capacity of the line, subject to the conditions that (i) a worker can only perform adjacent operations, (ii) all tasks need to be done in their numerical order and (iii) each task can only be assigned to a single worker. e. What is the capacity of this line now? (Note: we could have multiple optimal assignments, you just need to present one to receive full credit.)| \begin{tabular}{|c|c|c|c|c|c|} \hline & A & B & C & D & E \\ \hline 1 & Worker & Processing Time (seconds) & \multicolumn{2}{|c|}{ Hourly capacity } & \\ \hline 2 & \multicolumn{4}{|c|}{1} & \\ \hline 3 & \multicolumn{4}{|l|}{2} & \\ \hline 4 & \multicolumn{4}{|c|}{3} & \\ \hline 5 & \multicolumn{4}{|c|}{4} & \\ \hline 6 & & & & & \\ \hline 7 & \multicolumn{4}{|l|}{ a. Process capacity (hourly) } & \\ \hline 8 & \multicolumn{2}{|l|}{ b. Direct labor content } & seconds & & \\ \hline 9 & \multicolumn{2}{|l|}{ c. Average labor utilization } & & & \\ \hline 10 & \multicolumn{4}{|c|}{ d. Time it takes to produce 100 units, starting with an empty system } & \\ \hline 11 & & \multirow{2}{*}{\multicolumn{2}{|c|}{ Hourly capacity }} & \\ \hline 12 & Worker & Processing Time (seconds) & & & \\ \hline 13 & 1 & & & & \\ \hline 14 & 2 & & & & \\ \hline 15 & 3 & & & & \\ \hline 16 & 4 & & & & \\ \hline 17 & 5 & & & & \\ \hline 18 & 6 & & & & \\ \hline 19 & e. New process capacity (hourly) & & & & \\ \hline 20 & & & & & \\ \hline 21 & & & & & \\ \hline \end{tabular}