Question: finish the chart using solver. Also, please explain the steps on how it was achieved using solver 1. Based on Machol (1970). A swimming coach

finish the chart using solver. Also, please explain the steps on how it was achieved using solver
finish the chart using solver. Also, please
finish the chart using solver. Also, please
1. Based on Machol (1970). A swimming coach is putting together a relay team for the 400 -meter relay. Each swimmer must swim 100 meters of breaststroke, backstroke, butterfly, or freestyle, and each swimmer can swim only one race. The coach believes that each swimmer can attain the times given in the file P05_51.xlsx. To minimize the team's total time for the race, which swimmers should swim which strokes? Indexing locations \begin{tabular}{|l|c|l|c|} \hline \multicolumn{1}{|c|}{ Swimmer } & Index & \multicolumn{1}{|c|}{ Style } & Index \\ \hline Hall & 1 & Free & 1 \\ \hline Spitz & 2 & Breast & 2 \\ \hline Montgomery & 3 & Butterfly & 3 \\ \hline Jastremski & 4 & Back & 4 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline Swimmer & Style & Time & Flows \\ \hline 1 & 1 & 54 & \\ \hline 1 & 2 & 54 & \\ \hline 1 & 3 & 51 & \\ \hline 1 & 4 & 53 & \\ \hline 2 & 1 & 51 & \\ \hline 2 & 2 & 57 & \\ \hline 2 & 3 & 52 & \\ \hline 2 & 4 & 52 & \\ \hline 3 & 1 & 50 & \\ \hline 3 & 2 & 53 & \\ \hline 3 & 3 & 54 & \\ \hline 3 & 4 & 56 & \\ \hline 4 & 1 & 56 & \\ \hline 4 & 2 & 54 & \\ \hline 4 & 3 & 55 & \\ \hline 4 & 4 & 53 & \\ \hline \end{tabular} Total time \begin{tabular}{|c|c|} \hline Style & Flow in \\ \hline 1 & \\ \hline 2 & \\ \hline 3 & \\ \hline 4 & \\ \hline \end{tabular} \begin{tabular}{|l|} \hline 1 \\ \hline 1 \\ \hline 1 \\ \hline 1 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!