Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Coach Night is trying to choose the starting lineup for the basketball team. There are seven candidate players who have been rated on a scale
Coach Night is trying to choose the starting lineup for the basketball team. There are seven candidate players who have been rated on a scale of 1 (poor) to 3 (excellent) according to their ball handling, shooting, rebounding, and defensive abilities, listed in the table below. 1 2 3 4 5 6 7 3 2 2 1 1 3 3 3 1 3 3 3 1 2 Player Ball-handling Shooting Rebounding Defensive Ability 1 3 2 3 1 2 2 3 2 2 1 2 3 1 The positions that each player is allowed to play is as follows: Play 1,3,5,7 can play Guard; Player 3,4,5,6,7 can play Forward; Player 2,4,6 can play Center. Exactly five players must be chosen for the starting line-up, and must also satisfy the following restrictions: At least three members must be able to play guard, at least two members must be able to play forward, and at least one member must be able to play center. The total ball-handling, shooting, and rebounding level of the starting lineup must each be at least 9. Either payer 2 or player 3, or both of them, must be chosen for the starting lineup. Given these constraints, Coach Night wants to decide which players to choose to maximize the total defensive ability of the starting team. (a) Formulate appropriately as an IP model. Provide the algebraic model formulation in your submission. Must be neatly presented. (b) Input and solve the formulation using Excel
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started