Review the Bill of Material below. Assembly A123 is the "top level" assembly - it consists of (1) each of the 3695 Sub-Assembly and the 3890 Sub-Assembly. The components that make up each sub-assembly are listed below them - they are all level 2 items. A. Your factory is working two 8-hour shifts with one 30 minute lunch break and TWO 10-minute additional breaks. Assume an efficiency of 85% and a demand of 3900 units of Assembly A123 required per day. What is the TAKT? B. Using the BOM and the routings on the following pages, create and submit a Product-Process matrix complete with the TOTAL NUMBER OF EACH MACHINES REQUIRED for our facility. Preferred format of this submission is Excel - please submit the file so that I can review the calculations used in the cells. CAUTION - NOTE THE QUANTITIES OF EACH COMPONENT! Component Routings \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Component A } \\ \hline Operation No. & Description & Standard Time (mins) \\ \hline 10 & Band Saw & 0.073 \\ \hline 20 & Lathe & 0.114 \\ \hline 30 & CNC Drill & 0.069 \\ \hline 40 & Grinder & 0.227 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Component X } \\ \hline Operation No. & Description & Standard Time (mins) \\ \hline 10 & Band Saw & 0.081 \\ \hline 20 & Lathe & 0.712 \\ \hline 30 & Mill & 0.277 \\ \hline 40 & Grinder & 0.343 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Component B } \\ \hline Operation No. & Description & Standard Time (mins) \\ \hline 10 & Lathe & 0.159 \\ \hline 20 & Mill & 0.234 \\ \hline 30 & CNC Drill & 0.166 \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Component Y } \\ \hline Operation No. & Description & Standard Time (mins) \\ \hline 10 & Band Saw & 0.044 \\ \hline 20 & Lathe & 0.378 \\ \hline 30 & Mill & 0.512 \\ \hline 40 & CNC Drill & 0.215 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Component C } \\ \hline Operation No. & Description & Standard Time (mins) \\ \hline 10 & Band Saw & 0.097 \\ \hline 20 & Mill & 0.428 \\ \hline 30 & Grinder & 0.189 \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Component Z } \\ \hline Operation No. & Description & Standard Time (mins) \\ \hline 10 & Band Saw & 0.111 \\ \hline 20 & Lathe & 0.281 \\ \hline 30 & Mill & 0.320 \\ \hline 40 & CNC Drill & 0.263 \\ \hline \end{tabular} Review the Bill of Material below. Assembly A123 is the "top level" assembly - it consists of (1) each of the 3695 Sub-Assembly and the 3890 Sub-Assembly. The components that make up each sub-assembly are listed below them - they are all level 2 items. A. Your factory is working two 8-hour shifts with one 30 minute lunch break and TWO 10-minute additional breaks. Assume an efficiency of 85% and a demand of 3900 units of Assembly A123 required per day. What is the TAKT? B. Using the BOM and the routings on the following pages, create and submit a Product-Process matrix complete with the TOTAL NUMBER OF EACH MACHINES REQUIRED for our facility. Preferred format of this submission is Excel - please submit the file so that I can review the calculations used in the cells. CAUTION - NOTE THE QUANTITIES OF EACH COMPONENT! Component Routings \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Component A } \\ \hline Operation No. & Description & Standard Time (mins) \\ \hline 10 & Band Saw & 0.073 \\ \hline 20 & Lathe & 0.114 \\ \hline 30 & CNC Drill & 0.069 \\ \hline 40 & Grinder & 0.227 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Component X } \\ \hline Operation No. & Description & Standard Time (mins) \\ \hline 10 & Band Saw & 0.081 \\ \hline 20 & Lathe & 0.712 \\ \hline 30 & Mill & 0.277 \\ \hline 40 & Grinder & 0.343 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Component B } \\ \hline Operation No. & Description & Standard Time (mins) \\ \hline 10 & Lathe & 0.159 \\ \hline 20 & Mill & 0.234 \\ \hline 30 & CNC Drill & 0.166 \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Component Y } \\ \hline Operation No. & Description & Standard Time (mins) \\ \hline 10 & Band Saw & 0.044 \\ \hline 20 & Lathe & 0.378 \\ \hline 30 & Mill & 0.512 \\ \hline 40 & CNC Drill & 0.215 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Component C } \\ \hline Operation No. & Description & Standard Time (mins) \\ \hline 10 & Band Saw & 0.097 \\ \hline 20 & Mill & 0.428 \\ \hline 30 & Grinder & 0.189 \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Component Z } \\ \hline Operation No. & Description & Standard Time (mins) \\ \hline 10 & Band Saw & 0.111 \\ \hline 20 & Lathe & 0.281 \\ \hline 30 & Mill & 0.320 \\ \hline 40 & CNC Drill & 0.263 \\ \hline \end{tabular}