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 1= poor to 3= excellent) according to ball-handling, 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 2 guards, 1 center, and 2 forwards.
The starting lineup's total ball-handling, shooting and rebounding score must each be at least 10.
Given these constraints, Coach Night wants to maximize the total defensive score of the starting line-up. 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 Ball-handling Shooting Rebounding Defense Positions
13133 G
22132 C
32322 G, F
41331 F, C
53112 G, F
63321 F, C
73221 G, F

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!