Question: Suppose you are the coach of the Charlotte Bobcats and have been given a budget of $50 million/year to sign free agents for the team. In addition to drafting college players, you want to sign a minimum of 5 free agents to give the team a solid core. You would like the free agent players select to contribute (on average) a minimum of 80 points per game, 40 rebounds per game, 25 assists, and contribute an average of at least 190 minutes of playing time. You want at least 2 Front Court (FC) players and 3 Back Court (BC) players.

12 candidates are available:
Initials Position Pts Rebs Asst Min Salary($M)
MM BC 14.7 4.4 9.3 40.3 8.2
DB FC 12.6 10.6 2.1 34.5 6.5
SC BC 13.5 8.7 1.7 29.3 5.2
RD BC 27.1 7.1 4.5 42.5 16.4
JE BC 18.1 7.5 5.1 41.0 14.3
AF BC 22.8 9.5 2.4 38.5 20.5
HG FC 9.3 12.2 3.5 31.5 4.7
AR FC 10.2 12.6 1.8 44.4 7.1
FW BC 16.9 2.5 11.4 42.7 15.8
MJ BC 28.5 6.5 1.3 38.1 22.4
BB FC 24.8 8.6 6.9 42.6 17.5
GH FC 11.3 12.5 3.2 39.5 8.6

Which players should you sign to meet the playing objectives at minimum cost and how much (if any) increase in the free agent budget do you need to ask for?

If the objective was to maximize points per game with the $50M as a hard budgetary constraint, who should you sign? How much of your budget is left over? (14pts)

Price: $2.99

Solution: The downloadable solution consists of 6 pages
Deliverable: Word Document