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.
Please use the attached spreadsheet as a model

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!