menu
bartleby
search
close search
Hit Return to see all results
close solutoin list

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 players’ abilities are listed in the file P06_43.xlsx. The five-player starting lineup must satisfy the following restrictions: At least four members must be able to play guard (G), at least two members must be able to play forward (F), and at least one member must be able to play center (C). The average ballhandling, shooting, and rebounding level of the starting lineup must each be at least 1.8. Either player 2 or player 3 (or both) must start. Given these constraints, Coach Night wants to maximize the total defensive ability of the starting team. Use Solver to determine his starting team.

BuyFindarrow_forward

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659

Solutions

Chapter
Section
BuyFindarrow_forward

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659
Chapter 6, Problem 43P
Textbook Problem
13 views

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 players’ abilities are listed in the file P06_43.xlsx. The five-player starting lineup must satisfy the following restrictions:

  • At least four members must be able to play guard (G), at least two members must be able to play forward (F), and at least one member must be able to play center (C).
  • The average ballhandling, shooting, and rebounding level of the starting lineup must each be at least 1.8.
  • Either player 2 or player 3 (or both) must start. Given these constraints, Coach Night wants to maximize the total defensive ability of the starting team. Use Solver to determine his starting team.

Summary Introduction

To frame: The players line-up using the given restrictions.

Introduction: The variation between the present value of the cash outflows and the present value of the cash inflows are known as the Net Present Value (NPV).

Explanation of Solution

Model:

Formulae to determine the model:

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 6 Solutions

Practical Management Science
Show all chapter solutions
add
Ch. 6.4 - The Great Threads Company is capable of...Ch. 6.4 - The Great Threads Company is capable of...Ch. 6.4 - The Great Threads Company is capable of...Ch. 6.4 - The Great Threads Company is capable of...Ch. 6.4 - The Great Threads Company is capable of...Ch. 6.4 - Dorian Auto is considering manufacturing three...Ch. 6.4 - Dorian Auto is considering manufacturing three...Ch. 6.4 - Dorian Auto is considering manufacturing three...Ch. 6.4 - If Solver could handle IF functions correctly, how...Ch. 6.4 - In the Great Threads model, we found an upper...Ch. 6.4 - In the last sheet of the file Fixed Cost...Ch. 6.4 - In the Dorian production model, suppose that the...Ch. 6.4 - Suppose in the Dorian production model that no...Ch. 6.5 - In the original Western set-covering model in...Ch. 6.5 - In the original Western set-covering model in...Ch. 6.5 - Set-covering models such as the original Western...Ch. 6.5 - In the United Copiers service center model, we...Ch. 6.5 - In the United Copiers service center model, we...Ch. 6.5 - In the Green Grass shipping model, we assumed that...Ch. 6.5 - In the optimal solution to the Green Grass...Ch. 6.5 - In the Green Grass shipping model, use SolverTable...Ch. 6.5 - In the United Copiers service center model, we...Ch. 6.5 - In the Green Grass shipping model, we assumed that...Ch. 6.5 - In the Green Grass shipping model, we currently...Ch. 6.6 - In the cutting stock example, we minimized the...Ch. 6.6 - A company sells 3-foot, 5-foot, and 9-foot pieces...Ch. 6.6 - The Mayfree Appliance Company requires sheet metal...Ch. 6 - Four projects are available for investment. The...Ch. 6 - You are given a group of possible investment...Ch. 6 - You are moving from New Jersey to Indiana and have...Ch. 6 - NASA must determine how many of three types of...Ch. 6 - Coach Night is trying to choose the starting...Ch. 6 - To graduate from Southeastern University with a...Ch. 6 - Based on Bean et al. (1987). Boris Milkems firm...Ch. 6 - The Cubs are trying to determine which of the...Ch. 6 - Based on Sonderman and Abrahamson (1985). In...Ch. 6 - Because of excessive pollution on the Momiss...Ch. 6 - A manufacturer can sell product 1 at a profit of...Ch. 6 - A company is considering opening warehouses in...Ch. 6 - The TightBond company produces three types of glue...Ch. 6 - Avion Computer produces two types of computers:...Ch. 6 - A product can be produced on four different...Ch. 6 - Consider the Pigskin example (Example 3.3) from...Ch. 6 - McPherson Publishers is considering publishing...Ch. 6 - Toshovo Computer owns four production plants at...Ch. 6 - Eastinghouse sells air conditioners. The annual...Ch. 6 - During the next five periods, the demands listed...Ch. 6 - At a machine tool plant, five jobs must be...Ch. 6 - Ford has four automobile plants. Each is capable...Ch. 6 - Bertallo Classic produces tomato sauce at five...Ch. 6 - Eight jobs need to be completed. Each job can be...Ch. 6 - Based on Walker (1974). The Smalltown Fire...Ch. 6 - State University must purchase 1200 computers from...Ch. 6 - At Blair General Hospital, six types of surgical...Ch. 6 - Spencer Electric ships 17,000 capacitors per month...Ch. 6 - Based on Liggett (1973). A court decision has...Ch. 6 - Based on Westerberg, Bjorklund, and Hultman...Ch. 6 - Based on Boykin (1985). Thompson Chemicals...Ch. 6 - Based on Zangwill (1992). Murray Manufacturing...Ch. 6 - Based on Fitzsimmons and Allen (1983). The State...Ch. 6 - Suppose you own 15 bronze coins worth a total of...Ch. 6 - Cousin Bruzie of radio station WABC schedules...Ch. 6 - Based on Bean et al. (1988). Simons Mall has 9000...Ch. 6 - Indiana Universitys Business School has two rooms...Ch. 6 - Based on Efroymson and Ray (1966). Stonecutters is...Ch. 6 - On Monday morning, you have 5000 in cash on hand....Ch. 6 - Based on Eaton et al. (1985). The city of...Ch. 6 - Arthur Ross, Inc., must complete many corporate...Ch. 6 - Based on Muckstadt and Wilson (1968). PSI believes...Ch. 6 - Newsome Construction is considering erecting three...Ch. 6 - Four trucks are available to deliver milk to five...Ch. 6 - A county is going to build two hospitals. There...Ch. 6 - It is currently the beginning of year 1. Gotham...Ch. 6 - Based on Spencer et al. (1990). When you lease 800...Ch. 6 - State University is scheduling 24 sections of a...Ch. 6 - Hoosier Power needs to determine a capacity...Ch. 6 - Based on Angel et al. (2003). A fertilizer company...Ch. 6 - Sam is in his final year of college and is trying...Ch. 6 - A medical supply company has customers in eight...Ch. 6 - You are scheduling company interviews at the...Ch. 6 - The file P06_92.xlsx lists the distances between...Ch. 6 - This problem is based on Motorolas online method...Ch. 6 - Specialty Software is considering 10 projects. The...Ch. 6 - You are moving away from Bloomington and need to...Ch. 6 - Based on McBride and Zufryden (1988). A company is...Ch. 6 - Suppose that you want to divide a state containing...Ch. 6 - An insurance company has hired you to determine...Ch. 6 - Ten different types of brownies are sold. You are...Ch. 6 - Telco, a national telemarketing firm, usually...Ch. 6 - Giant Motor Company This case deals with strategic...Ch. 6 - Selecting Telecommunication Carriers to Obtain...Ch. 6 - Project Selection AT Ewing Natural Gas This is an...Ch. 6 - Project Selection at Ewing Natural Gas This is an...Ch. 6 - Project Selection at Ewing Natural Gas This is an...Ch. 6 - Project Selection at Ewing Natural Gas This is an...Ch. 6 - Project Selection at Ewing Natural Gas This is an...Ch. 6 - Project Selection at Ewing Natural Gas This is an...

Additional Business Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What steps are followed in posting cash payments from the general journal to the accounts payable ledger?

College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)

What is the primary purpose of an accounting system?

Intermediate Accounting: Reporting And Analysis

WACC AND PERCENTAGE OF DEBT FINANCING Hook Industriess capital structure consists solely of debt and common equ...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

What is meant by the garnishment of wages?

PAYROLL ACCT.,2019 ED.(LL)-TEXT