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 2 3 Swimmer Style Flows Flow balance constraints Swimmer Flow out 2. 1 1 3 4 2 3 4 2 1 - 2. 2 3 Style Flow in Time 54 54 51 53 51 57 52 52 50 53 54 56 56 54 55 53 4 2 2 2 2 3 3 3 3 4 4 4 4 4 4 1 2 3 4 Total time 51. 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