Question: please provide excel spread sheet for decision variable and constrant sna objective function. also, please show me what to add to my sover Coach Night
please provide excel spread sheet for decision variable and constrant sna objective function. also, please show me what to add to my sover
Coach Night is trying to choose the starting lineup for the basketball team.
The team consists of seven players who have been rated on a scale of poor to excellent according to ballhandling, shooting, rebounding, and defensive abilities.
The positions that each player is allowed to play and the player's abilities are listed in the above table. The starting lineup consists of guards, center, and forwards.
The starting lineup's total ballhandling, shooting and rebounding score must each be at least
Given these constraints, Coach Night wants to maximize the total defensive score of the starting lineup Note that two players can be assigned bench positions in order to create a one for one assignment.
Create a spreadsheet model and use Solver to find the optimal starting five lineup.
Hint: If a player cannot play a certain position, you can force that assignment to equal zero.Player Ballhandling Shooting Rebounding Defense Positions
G
C
G F
F C
G F
F C
G F
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
