Question: data from the file is already typed in . Use Excel please to solve this problem Please create a single Excel file with each problem

data from the file is already typed in. Use Excel please to solve this problem Please create a single Excel file with each problem on a separate worksheet tab. Problem 1 Problem 5.51, Assigning Swimmers to Events (p.269) Index 1 Swimmer Hall Spitz Montgomery Jastremski Indexing locations Index Style Free 2 Breast Butterfly 4 Back 23 Swimmer Style Flows Flow balance constraints Swimmer Flow out 2.113423421-2.23 Style Flow in Time 545451535157525250535456565455534222233334444441234 Total time51. 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?

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!