Question: Solve the integer programming model formulated in Question 3 by using Excel. 3. Coach Night is trying to choose the starting lineup for the basketball

Solve the integer programming model formulated in Question 3 by using Excel.

3. 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 excellent) according to their 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 table below, Player 1 2 3 4 5 6 Position G G-F F C G-F F C G-F Ball Handling 3 2 2 1 3 3 3 Shooting 3 1 3 3 3 1 Rebounting 1 3 2 3 Defense 3 2 2 1 2 2 The fiw-player starting lineup must satisfy the following restrictions 1. At least 4 members must be able to play guard, at least 2 members must be able to play forward, and at least 1 member must be able to play center 2. The average, shooting level of the starting lineup must be at least 2 4. Either player 2 or player 3 must start Given these constraints, Coach Night wants to maximize the total defensive ability of the starting team. Formulate an IP that will help him choose his starting team

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!

Solve the integer programming model formulated in Question 3 by using Excel. You can see the required IP model in the relevant 3. Coach Night is trying to choose the starting lineup for the...

1. Solve the integer programming model formulated in Question 3 of Problem set 8 document located in itslearning by using Excel. You can see the required IP model in the relevant solution document as...

solve it as integer programming and solve it by excel solver 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...

solve by using excel. 3. 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)...

Question 3 Question 3) A basketball coach is trying to choose the 5 players for lineup to maximize the shooting ability of the starting team. The team consists of seven players who have been rated on...

1 2 2 1 4 3 3 1 3 3 6 4. (20 pts.) 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 =...

please, put the "exhibits" into excel and show the work put into excel thats needed to answers questions 1 - 6. INTRODUCTION Allegheny County Port Authority is the main organization that oversees...

I WANT THE EXCEL FILE NOT THE SCREENSHOT IF YOU CAN'T UPLOAD THE FILE PLS COMMENT AND I'LL GIVE EMAIL THANK YOU 3. Coach Night is trying to choose the starting lineup for the basketball team. The...

solve it as integer programming solve it using excel solver 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...

b) A customer requires during the next four months, respectively, 50.65, 100, and 70 units of a product in stock-out is allowed). Production costs are $5. 58. 54, and 57 per unit during these months....

Show that if P(A|B) = 1, then P(B^c/A^c) = 1.

According to the Expenditure Approach to calculating GDP, if personal consumption is $300 billion, gross private investment is $150 billion, Government spending is $210 billion, and net exports are...

direct materials are 1 . prime costs 2 . conversion cost 3 . manufacturing cost and prime cost 4 . manufacturing, prime and conversion cost

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...