Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions