Question: 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,

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

★★★★★

3.49 Rating (149 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Assigning swimmers to events Range names used Assigns ModelB12E15 Times ColSums ModelB1... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (3 attachments)

1497_60b7412442bbf_696502.pdf

180 KBs PDF File

1497_6041cde1c4d8c_696502.xlsx

300 KBs Excel File

1497_60b7412442bbf_696502.docx

120 KBs Word File

Students Have Also Explored These Related Practical Management Science Questions!

Mail X Bb Welc X w Lab F X ta The E X Bb Annc x w w Pre-1 X w Note X w Vanil X 101 Chen x Chen X UJ Logir X w UCor X Logi X Phys X + V X C compadre.org/physlets/electromagnetism/prob25_7.cfm Apps...

You are putting together a portfolio made up of four different stocks. However, you are considering two possible weightings: a. What is the beta on each portfolio? b. Which portfolio is riskier? c....

STL has asked you for advice on putting together the details of the new debt issues it is planning to make. What information would you need to obtain to provide this advice?

Larry Lynch has been working for a year as an analyst for an investment company that specializes in serving very wealthy clients. These clients often purchase shares in closely held investment funds...

it is question 53 in the textbook and the next photo is the excel spreadsheet 48. The Amorco Oil Company controls two oil fields. Field I can produce up to 22 million barrels of oil per day, and...

Problem 1 Problem 5.51. Assigning Swimmers to Events (p. 269) Index Swimmer Hall Spitz Montgomery Jastremski Indexing locations Index Style 1 Free 2 Breast 3 Butterfly 4 Back 2 3 4 Swimmer Style...

Problem 5.51. Assigning Swimmers to Events (p. 269) Indexing locations Swimmer Index Style Index Hall Free Spitz 2 Breast 2 Montgomery Butterfly W lastremski 4 Back 4 Swimmer Flows Flow balance...

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 . 5 1 , Assigning...

finish the chart using solver. Also, please explain the steps on how it was achieved using solver 1 . Based on Machol ( 1 9 7 0 ) . A swimming coach is putting together a relay team for the 4 0 0 -...

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...

Why would CPAs prefer to avoid estimates in financial reporting?

Risk avoidance is an appropriate strategy when the potential losses seriously outweigh the likely benefits. What factors should be considered on the cost and benefit sides of the analysis? At what...

Evaluate the following algebraic expression at x = - 4 , y = - 4 and simplify your answer. - 6 x - y = 6 Answer - 2 6

TABLE B.6 Global Mean Surface Air Temperature Anomaly and Global CO, Concentration Year Anomaly (C) CO; (ppmv) Year Anomaly ('C) CO; (ppmv) Year Anomaly ('C) CO; (ppmv) 1880 -0.11 290.7 1922 -0.09...

Following table shows the actual amounts for year 2016 and projections for next 5 years of the firm KNJ (amounts are in millions). Actual Projected 2016 Year + 1 Year + 2 Year + 3 Year + 4 Year + 5...

Zeke pulls out a knife and tells Bob to write him a check for $500. Bob does so. Zeke takes the check to his bank, properly endorses it, and receives $500 in cash. Bob stops payment on the check....

As we have stated, self-assessment is a critical component of the Baldrige process. Accordingly, this assignment will require you to engage in a reflective process and allow you to develop and...

One of the most important lines of research in Organizational Behavior has to do with the links between job satisfaction and job performance. As a future leader its important to understand the...

=+8. Prove parts (a) through (c) of Proposition A.3.1.

Why do manufacturing companies use product costing systems to track costs throughout the production process?

Describe manufacturing costs and non-manufacturing costs. Provide examples of each.

Describe the difference between direct materials and direct labor versus indirect materials and indirect labor.

For each of the following products or operations, indicate the most appropriate type of layout. Answer Potential Matches: Hospital emergency facilities 1 : Warehouse Assembly line 2 : Office...

Management of Toys R4U Company needs to decide whether to introduce a certain new novelty toy for the upcoming Christmas season, after which it would be discontinued. The total cost required to...

To titrate to the endpoint, 19.15ml of 0.888MNaOH was used. If the Erlenmeyer flask originally contained 25.000ml of a hydrochloric acid solution, what is the molarity of the hydrochloric acid...