Question: Please use the attached spreadsheet as a model while showing the work and don't use the incorrect data from a similar problem that has been
Please use the attached spreadsheet as a model while showing the work and don't use the incorrect data from a similar problem that has been posted previously on here. I want to see if I got this particular question correct. especially the final constraint where RS, BS and DE cannot all sign contraint because I think the rest is correct.
46. The Cubs are trying to determine which of the follow- ing free-agent pitchers should be signed: Rick Sutcliffe (RS), Bruce Sutter (BS), Dennis Eckersley (DE), Steve Trout (ST), or Tim Stoddard (TS). (Feel free to substitute your own set of players for these old guys.) The cost of signing each pitcher and the predicted number of vic- tories each pitcher will add to the Cubs are listed in the file P06_46.xlsx. The Cubs want to sign the pitchers who will add the most victories to the team. Determine who the Cubs should sign based on the following restrictions: At most, $55 million can be spent. At most, three right-handed pitchers can be signed. The Cubs cannot sign BS, RS, and DE (that is, they cant sign all three of these players).
Note that the data from P06_46.xlsx is already in the attached spreadsheet.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
