A coach is trying to choose the starting line-up 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 (G = guard, C = center, F = forward) and the player’s abilities are: Player    Position    Defense Ability 1            G              3 2            C              2 3            G-F           2 4            F-C           1 5            G-F           1 6            F-C           3 7            G-F           3 Formulate an IP to choose the starting lineup such that the five-player starting line-up satisfies the following restrictions, then solve your IP using python (if you have not taken and are not currently taking python you may use the excel solver - be sure to document this in your homework submission). Submit your python file on canvas and include the optimal solution in your written submission. (a) At least 3 starters must be able to play guard, at least 2 starters must be able to play forward, and at least one starter must be able to play center. (b) The average defensive ability of the starting lineup must be at least 2. (c) If player 3 starts, then player 6 cannot start. (d) If player 1 starts, then players 4 and 5 must both start. (e) Either player 2 or player 3 (or both) must start.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

A coach is trying to choose the starting line-up 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 (G = guard, C = center, F = forward) and the player’s abilities are:
Player    Position    Defense Ability
1            G              3
2            C              2
3            G-F           2
4            F-C           1
5            G-F           1
6            F-C           3
7            G-F           3
Formulate an IP to choose the starting lineup such that the five-player starting line-up satisfies
the following restrictions, then solve your IP using python (if you have not taken and are not
currently taking python you may use the excel solver - be sure to document this in your
homework submission). Submit your python file on canvas and include the optimal solution
in your written submission.
(a) At least 3 starters must be able to play guard, at least 2 starters must be able to play
forward, and at least one starter must be able to play center.
(b) The average defensive ability of the starting lineup must be at least 2.
(c) If player 3 starts, then player 6 cannot start.
(d) If player 1 starts, then players 4 and 5 must both start.
(e) Either player 2 or player 3 (or both) must start.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Time complexity
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education