The National Basketball Dream Team
Assignment:
a) The spreadsheet DREAM-TEAM.XLS contains all of the data about the statistics of players. Using this spreadsheet, construct and solve a discrete optimization model that can be used to select the national men's basketball dream team.
b) How will the composition of the dream team be changed if the following constraints are changed as follows:
- the average number of rebounds among the 12 selected players needs to be at least 8 rebounds per game,
- the average number of assists per game among the 12 selected players must be at least 7 assists per game, and
- the average number of points per game among the 12 selected players must be at least 20 points per game.
c) Rudy is thinking of also selecting two more players as alternates in case any of the 12 selected players is injured prior to the start of the world championship games in Barcelona. Propose a method for selecting the two alternates.
Attachment:- dream team.xls