Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 7.6, Problem 32P
Summary Introduction
To calculate: The ratings and home-field advantage for the teams.
Non-linear programming (NLP):
Non-linear programming (NLP) is used in complex optimization problems where the objectives or constraints or sometimes both are non-linear functions of the decision variables. A model can be termed as non-linear for more than one reason.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
BE eBook
Problem 10-07 (Algorithmic)
Aggie Power Generation supplies electrical power to residential customers for many U.S. cities. Its main power generation plants are located in Los Angeles, Tulsa, and Seattle. The following table shows Aggie
Power Generation's major residential markets, the annual demand in each market (in megawatts or MWs), and the cost to supply electricity to each market from each power generation plant (prices are in
$/MW).
City
Seattle
Portland
San Francisco
Boise
Reno
Bozeman
Laramie
Park City
Flagstaff
Durango
Los Angeles
$364.25
$367.25
$166.13
$341.25
$241.50
$428.63
$367.25
$375.25
$238.13
$363.25
Distribution Costs
Tulsa
The optimal solution is to produce
$601.75
$604.75
$463.00
$460.00
$479.00
$428.63
$426.63
$375.25
$535.00
$303.88
Seattle
The optimal solution is to produce
cost associated with the additional constraints is $
$67.38
$189.13
$284.88
$281.88
$360.25
$309.88
$367.25
$494.00
$653.75
$600.75
Demand (MWS)
958.00
MWs in Los Angeles,
842.25…
USING EXCEL SOLVER
Check the image for clarification
Q&H Company advertises during soap operas and football games. Each soap opera ad costs $75,000, and each football game ad costs $130,000. If S soap opera ads are purchased, they will be seen by 4S^1/2 million men and 22S^1/2 million women. If F football ads are purchased, they will be seen by 28F^1/2 million men and 10F^1/2 million women. The company wants at least 60 million men and at least 50 million women to see its ads.
Determine how to minimize Q&H’s cost of reaching the required number of viewers.
*Please show the equations in the cells
A textbook publisher for books used in business schools believes that the number of books sold is
related to the number of campus visits to decision makers made by their sales force. A sampling
of the number of sales calls made and the number of books sold is shown in the following table.
NUMBER OF SALES CALLS
MADE
25
15
25
45
35
25
25
35
25
15
NUMBER OF BOOKS SOLD
375
250
525
825
550
575
550
575
400
400
a. Plot the data in excel and generate the linear regression model.
b.
What percent in the variation of the variable Books Sold is explained by the value of the
variable Sales Calls Made?
c. For every sale call made, the number of books sold increases by how much?
d. In order to realize the sale of 700 books, how many sales calls will the sales
representative have to make?
Chapter 7 Solutions
Practical Management Science
Ch. 7.3 - Prob. 1PCh. 7.3 - Prob. 2PCh. 7.3 - Pricing Decisions at Madison The Madison Company...Ch. 7.3 - Prob. 4PCh. 7.3 - Prob. 5PCh. 7.3 - Prob. 6PCh. 7.3 - Prob. 7PCh. 7.3 - Prob. 8PCh. 7.3 - Prob. 9PCh. 7.3 - Prob. 10P
Ch. 7.3 - Prob. 11PCh. 7.3 - Prob. 12PCh. 7.3 - Prob. 13PCh. 7.3 - PRICING SUITS AT SULLIVANS Sullivans is a retailer...Ch. 7.3 - Prob. 15PCh. 7.4 - Prob. 16PCh. 7.4 - Prob. 17PCh. 7.4 - Prob. 18PCh. 7.4 - Prob. 19PCh. 7.4 - Prob. 20PCh. 7.4 - Prob. 21PCh. 7.4 - Prob. 22PCh. 7.4 - Prob. 23PCh. 7.5 - Prob. 24PCh. 7.5 - Prob. 25PCh. 7.5 - Prob. 26PCh. 7.5 - Prob. 27PCh. 7.6 - Prob. 28PCh. 7.6 - Prob. 29PCh. 7.6 - Prob. 30PCh. 7.6 - Prob. 31PCh. 7.6 - Prob. 32PCh. 7.6 - Prob. 33PCh. 7.6 - The method for rating teams in Example 7.8 is...Ch. 7.7 - Prob. 35PCh. 7.7 - Prob. 36PCh. 7.7 - Prob. 37PCh. 7.7 - The stocks in Example 7.9 are all positively...Ch. 7.7 - Prob. 39PCh. 7.7 - Prob. 40PCh. 7.7 - Prob. 41PCh. 7.7 - Prob. 42PCh. 7.8 - Given the data in the file Stock Beta.xlsx,...Ch. 7.8 - Prob. 44PCh. 7 - Prob. 45PCh. 7 - Prob. 46PCh. 7 - Another way to derive a demand function is to...Ch. 7 - Prob. 48PCh. 7 - If a monopolist produces q units, she can charge...Ch. 7 - Prob. 50PCh. 7 - Prob. 51PCh. 7 - Prob. 52PCh. 7 - Prob. 53PCh. 7 - Prob. 54PCh. 7 - Prob. 55PCh. 7 - Prob. 56PCh. 7 - A beer company has divided Bloomington into two...Ch. 7 - Prob. 58PCh. 7 - Prob. 59PCh. 7 - Prob. 60PCh. 7 - Prob. 61PCh. 7 - Prob. 62PCh. 7 - Prob. 63PCh. 7 - You have 50,000 to invest in three stocks. Let Ri...Ch. 7 - Prob. 65PCh. 7 - Prob. 66PCh. 7 - Prob. 67PCh. 7 - Prob. 68PCh. 7 - Prob. 69PCh. 7 - Prob. 70PCh. 7 - Based on Grossman and Hart (1983). A salesperson...Ch. 7 - Prob. 73PCh. 7 - Prob. 74PCh. 7 - Prob. 75PCh. 7 - Prob. 76PCh. 7 - Prob. 77PCh. 7 - Prob. 78PCh. 7 - Prob. 79PCh. 7 - Prob. 80PCh. 7 - Prob. 81PCh. 7 - Prob. 82PCh. 7 - Prob. 83PCh. 7 - Prob. 84PCh. 7 - Prob. 85PCh. 7 - Prob. 86PCh. 7 - Prob. 1.1CCh. 7 - Prob. 1.2CCh. 7 - Prob. 1.3CCh. 7 - Prob. 1.4C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- need helparrow_forwardSuppose a social psychologist sets out to see whether having children is related to relationship longevity. He decides to measure relationship satisfaction in a group of couples with children and a group of childless couples. He chooses the Marital Satisfaction Inventory because it refers to “partner” and “relationship” rather than “spouse” and “marriage,” which makes it useful for research with both traditional and nontraditional couples. Higher scores on the Marital Satisfaction Inventory indicate greater relationship satisfaction. The psychologist administers the Marital Satisfaction Inventory to 58 couples—30 are couples with children and 28 are childless couples. He wants to calculate the correlation between a couple’s relationship satisfaction and whether they have children. Which of the following types of correlations would be most appropriate for the psychologist to use?arrow_forwardSports over the years have become highly competitive — today, the scenarios are so intense that a minute can completely flip the course of a game. And to stay one step ahead of the rivals, sports teams are opting to use analytics. And it is not only because of the competitive pressure but also because of the fan base who seek detailed information about players, their performance, and why the team won or lost. Select a cricket sport and explain how sports analytics is used in that sport.arrow_forward
- SOLVE IN EXCEL AND PROVIDE SENSITIVITY REPORT PLEASE SHOW ALL FORMULA IN EXCEL A company blends nitrogen and phosphorous to produce two types of fertilizers. Fertilizer 1 must be at least 50% nitrogen and sells for $55 per pound. Fertilizer 2 must be at least 55% phosphorous and sells for $45 per pound. The company can purchase up to 9000 pounds of nitrogen at $20 per pound and up to 12,000 pounds of phosphorous at $12 per pound. Assuming that all fertilizer produced can be sold, determine the optimal blending plan for the company. What is the maximum profit? Suppose the company could acquire 1,000 pounds more of either nitrogen or phosphorous. Which should it choose? What would be the resulting impact on profit?arrow_forwardA company manufacturers a product in the United States and sells it in England. The unit cost of manufacturing is 50. The current exchange rate (dollars per pound) is 1.221. The demand function, which indicates how many units the company can sell in England as a function of price (in pounds) is of the power type, with constant 27556759 and exponent 2.4. a. Develop a model for the companys profit (in dollars) as a function of the price it charges (in pounds). Then use a data table to find the profit-maximizing price to the nearest pound. b. If the exchange rate varies from its current value, does the profit-maximizing price increase or decrease? Does the maximum profit increase or decrease?arrow_forwardThe model in Example 9.3 has only two market outcomes, good and bad, and two corresponding predictions, good and bad. Modify the decision tree by allowing three outcomes and three predictions: good, fair, and bad. You can change the inputs to the model (monetary values and probabilities) in any reasonable way you like. Then you will also have to modify the Bayes rule calculations. You can decide whether it is easier to modify the existing tree or start from scratch with a new tree.arrow_forward
- Stock market analysts are continually looking for reliable predictors of stock prices. Consider the problem of modeling the price per share of electric utility stocks (Y). Two variables thought to influence this stock price are return on average equity (X1) and annual dividend rate (X2). The stock price, returns on equity, and dividend rates on a randomly selected day for 16 electric utility stocks are provided in the file P13_15.xlsx. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Also, interpret the standard error of estimate and the R-square value for these data.arrow_forwardYou want to take out a 450,000 loan on a 20-year mortgage with end-of-month payments. The annual rate of interest is 3%. Twenty years from now, you will need to make a 50,000 ending balloon payment. Because you expect your income to increase, you want to structure the loan so at the beginning of each year, your monthly payments increase by 2%. a. Determine the amount of each years monthly payment. You should use a lookup table to look up each years monthly payment and to look up the year based on the month (e.g., month 13 is year 2, etc.). b. Suppose payment each month is to be the same, and there is no balloon payment. Show that the monthly payment you can calculate from your spreadsheet matches the value given by the Excel PMT function PMT(0.03/12,240, 450000,0,0).arrow_forwardUsing the table below please compute for (a) and (b)arrow_forward
- The following table gives the density D (in gm/cm³) of the earth at a depth x km below the earth's surface. The radius of the earth is about 6370 km. i Find an upper bound for the earth's mass that you can give based on this data. Round your answer to two decimal places. i 7.06 x1027 g Find the best lower bound for the earth's mass that you can give based on this data. Round your answer to two decimal places. X1027 5.38 0 D 3.3 4.5 5.1 1000 2000 2900 3000 4000 5000 6000 6370 5.6 10.1 11.4 12.6 13.0 13.0 garrow_forwardParaphrase this one. Analyze and elaborate in 120 words. Time series analysis is used for non-stationary data—things that are constantly fluctuating over time or are affected by time. Industries like finance, retail, and economics frequently use time series analysis because currency and sales are always changing. Stock market analysis is an excellent example of time series analysis in action, especially with automated trading algorithms. Likewise, time series analysis is ideal for forecasting weather changes, helping meteorologists predict everything from tomorrow’s weather report to future years of climate change. Examples of time series analysis in action include: Weather data Rainfall measurements Temperature readings Heart rate monitoring (EKG) Brain monitoring (EEG) Quarterly sales Stock prices Automated stock trading Industry forecasts Interest ratesarrow_forward27 01:03:06 eBook Acme's Advertising Strategy Large Budget A B $800 $600 $800 $1200 C D $1200 $1000 Small Budget $600 $1000 Refer to the game theory matrix, where the numerical data show the profits resulting from alternative combinations of advertising strategies for Ajax and Acme. Ajax's profits are shown in the upper right part of each cell; Acme's profits are shown in the lower left. Without collusion, Nash equilibrium is represented by which cell? Multiple Choice D A B and C both О There is no Nash equilibrium in this game.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,