Question: Include the excel file you generated (answer report, excel model) 3. Coach Night is trying to choose the starting lineup for the basketball team. The

Include the excel file you generated (answer report, excel model)

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) 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 Position 1 2 3 G-F 4 F-C 5 G-F 6 F-C 7 Ball- Handling 3 2 2 1 3 3 3 Shooting 3 1 3 3 3 1 2 Rebounding Defense 1 3 3 2 2 2 3 1 3 3 2 3 2 1 G-F The five-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!

Include the excel file you generated (answer report, excel model) Include the excel file you generated (answer report, excel model) Include the excel file you generated (answer report, excel model)...

i need the soloution in an excel file with tge steps Coach Night is trying to ehoose the starting lincup for the basketball team. The team consists of seven players who have been rated (on a scale of...

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...

please solve question A) provide the algebraic model formulation! Coach Night is trying to choose the starting lineup for the basketball team. There are seven candidate players who have been rated on...

2 Operations Research 1 Due Date: 4 May 2016 Please submit your work to the class coordinator or the assistants! 1. Consider the following puzzle. You are to pick out 4 three-letter \"words\" from...

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)...

1 TABLE 9 Ball- Handling Player Position Shooting Rebounding Defense 1 3 3 1 3 2 1 2 3 3 4 5 G G-F F-C G-F F-C G-F 3 2 2 1 3 3 3 3 3 Coach Night is trying to choose the starting lineup for the...

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) according to their...

Player1 Player 2 Player3 Player 4 Player 5 Player6 Player 7 Guard? 1=yes 0=no 1 0 1 0 1 0 1 Forward 1=yes 0=no 0 0 1 1 1 1 1 Center 1=yes 0=no 0 1 0 1 0 1 0 Ball-handling 3 2 2 1 1 3 3 Shooting 3 1 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) according to their...

The required return on assets is 18%. The firm can borrow at 12.5%; firm's target debt to value ratio is 3/5. The corporate tax rate is 34%, and the risk-free rate is 4% and the market risk premium...

Given that Er, t) = Re (Eexpljo]}, derive a method for determining if a wave is LHP and RHP in terms of E(r, t) and a(r, t).

A limited liability company with 1 0 0 unrelated owners: May be tawed as a partnership. May be taxed as an 5 corporation. Only "May be tawed as a C corporation" and "May be tawed as a partinership"...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...