Business
Engineering
Math
Science
Social Science
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:
Chapter 6 Solutions
Practical Management Science
Show all chapter solutions
addCh. 6.3 - In the capital budgeting model in Figure 6.5, we...Ch. 6.3 - Solve the previous problem using the input data in...Ch. 6.3 - Solve Problem 1 with the extra assumption that the...Ch. 6.3 - Solve the following modifications of the capital...Ch. 6.3 - The Tatham Company is considering seven...Ch. 6.3 - The Tatham Company is considering seven...Ch. 6.3 - The Tatham Company is considering seven...Ch. 6.3 - The Tatham Company is considering seven...Ch. 6.3 - The Tatham Company is considering seven...Ch. 6.3 - The Tatham Company is considering seven...
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 addSuppose you sign a contract with a supplier for 50,000 worth of tablet computers. You tell the supplier that yo...
Purchasing and Supply Chain Management
Gross profit method The inventory was destroyed by fire on December 31. The following data were obtained from t...
Financial & Managerial Accounting
Describe the steps involved in conducting a marketing research project
MKTG 12:STUDENT ED.-TEXT
ECONOMIC ORDER QUANTITY Generators R Us (GRU) is a leading manufacturer of partible electric generators used fo...
Accounting Information Systems
The FinancialTimes/Harris Poll is a monthly online poll of adults from six countries in Europe and the United S...
Statistics for Business & Economics, Revised (MindTap Course List)
Which of the following is an example of source documents? a. Canceled checks b. Vendor invoices c. Receipts d. ...
College Accounting (Book Only): A Career Approach
Suppose that changes in bank regulations expand the availability of credit cards so that people need to hold le...
Principles of Macroeconomics (MindTap Course List)
BOND VALUATION You are considering a 10-year, 1,000 par value bond. Its coupon rate is 8%, and interest is paid...
Fundamentals of Financial Management, Concise Edition (MindTap Course List)
Identify the three states of the economy in terms of TE and TP.
Economics (MindTap Course List)
What are an attendance time record and a job time record? How is each used by the payroll process?
Pkg Acc Infor Systems MS VISIO CD
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
Asset traded for similar asset Assume the same facts as in Exercise 9-23, except that the book value of the pre...
Corporate Financial Accounting
Sales, production, direct materials purchases, and direct labor cost budgets The budget director of Gourmet Gri...
Accounting (Text Only)
Beginning inventory, purchases, and sales for WCS12 are as follows: Assuming a perpetual inventory system and u...
Financial Accounting
COST OF CAPITAL Coleman Technologies is considering a major expansion program that has been proposed by the com...
Fundamentals of Financial Management (MindTap Course List)
A survey conducted by Better Homes and Gardens Real Estate LLC showed that one in five U.S. homeowners have eit...
STATISTICS F/BUSINESS+ECONOMICS-TEXT
Use online resources to work on this chapter's questions. Please note that website information changes over tim...
Fundamentals of Financial Management (MindTap Course List)
Name one economic interaction that isnt covered by the simplified circular-flow diagram.
Brief Principles of Macroeconomics (MindTap Course List)
What category of proposal, solicited or unsolicited, is more likely to succeed, and why?
Essentials of Business Communication (MindTap Course List)
What is the difference between a product cost and a period cost?
Financial And Managerial Accounting
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
Price indexes such as the CPI are calculated using a base year. The term base year refers to a. the first year ...
Economics For Today
Recording payroll and payroll taxes Using the data from P8-2, indicate the effects on net assets and EPS of eac...
Survey of Accounting (Accounting I)
Compare bar codes and radio frequency identification (RFID) tags by placing a check mark in the appropriate box...
Accounting Information Systems
Classify the following topics as relating to microeconomics or macroeconomics. a. a familys decision about how ...
Principles of Macroeconomics (MindTap Course List)
The data needed to calculate working capital and its current ratio can be found on which of the following? a. C...
College Accounting (Book Only): A Career Approach
Weber Valley Regional Hospital has collected data on all of its activities for the past 16 months. Data for car...
Cornerstones of Cost Management (Cornerstones Series)
Use a production possibilities frontier to describe the idea of efficiency.
Essentials of Economics (MindTap Course List)
In the sell-or-process-further decision, a. joint costs are always relevant. b. total costs of joint processing...
Managerial Accounting: The Cornerstone of Business Decision-Making
Direct expenses are operating expenses incurred for the benefit of the business as a whole and untraceable dire...
College Accounting, Chapters 1-27
As a manager, what actions would you take if an operations employee with six years of experience on the job ref...
Foundations of Business (MindTap Course List)
Tom Harrington loved his job as an assistant quality control officer for Rockingham Toys. After six months of u...
Management, Loose-Leaf Version
Finders Investigative Services is an investigative services firm that is owned and operated by Stacy Tanner. On...
Financial Accounting
Why does the creation of a government program create a special interest group, which makes it difficult to redu...
Exploring Economics
A German worker takes 400 hours to produce a car and 2 hours to produce a case of wine. A French worker takes 6...
Principles of Economics (MindTap Course List)
Determining cost relationships Midsize Containers Inc. manufactures cans for the canned food industry. The oper...
Financial & Managerial Accounting
(Welfare Cost of Monopoly) Explain why the welfare loss of a monopoly may be smaller or larger than the loss sh...
ECON: MICRO4 (New, Engaging Titles from 4LTR Press)
Can a business earn a gross profit but incur a net loss? Explain.
Corporate Financial Accounting
Give an example of a positive statement and an example of a normative statement that somehow relates to your da...
Principles of Microeconomics (MindTap Course List)
Contrast the focus of marketing activities during the five eras of marketing history.
Contemporary Marketing
Accounts Payable Sleek Ride, a company providing limo services, has a December 31 year-end date. For Sleek Ride...
Cornerstones of Financial Accounting
Experts say that for teams to function well, members must get to know one another in some depth. What specifica...
Understanding Management (MindTap Course List)
If a firm produces the quantity of output at which MR = MC, does it necessarily earn profits?
Microeconomics
A production possibilities curve is drawn based on which of the following assumptions? a. Resources are fixed a...
Micro Economics For Today
Name the three inventory accounts for a manufacturing business, and describe what each balance represents at th...
Managerial Accounting
What are implicit costs? Do implicit costs contribute to the opportunity cost of production? Should an implicit...
Microeconomics: Private and Public Choice (MindTap Course List)
Suppose the government of a large city levies a 5 percent sales tax on hotel rooms. How will the tax affect (a)...
Economics: Private and Public Choice (MindTap Course List)
“Franklin Roosevelt was one of our greatest presidents because it was his New Deal policies that brought the Gr...
Macroeconomics: Private and Public Choice (MindTap Course List)
