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.4, Problem 16P
Summary Introduction
To identify: If the solver finds the same solution.
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 solution
Students have asked these similar questions
Let’s suppose that you have a set of time-series variables, and you want to model the relationship between them. Read the situations given below and answer the questions. (200 words)a) Explain the statistical test if the linear combination (of time-series variables) is I(0).b) Which statistical test can be applied if all the series are integrated of the same order I(1). Justify your answer
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
Consider the following linear program.
Max 3A + 2B
s.t.
1A
1B ≤ 10
3A + 1B ≤ 22
1A + 2B ≤ 18
A, B ≥ 0
(a) Use the graphical solution procedure to find the optimal solution.
What is the value of the objective function at the optimal solution?
at (A, B) =
(b) Assume that the objective function coefficient for A changes from 3 to 5. Use the graphical solution procedure to find the new optimal solution.
Does the optimal solution change?
The extreme point
(c) Assume that the objective function coefficient for A remains 3, but the objective function coefficient for B changes from 2 to 4. Use the graphical solution procedure to
find the new optimal solution.
Does the optimal solution change?
The extreme point
Variable
(d) The computer solution for the linear program in part (a) provides the following objective coefficient range information.
Objective Allowable Allowable
Coefficient Increase Decrease
A
B
---Select--- optimal. The value of the objective function becomes
3.00000
2.00000…
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
- Select the least accurate statement regarding RISKSIMTABLE. RISKSIMTABLE is a feature that is included in Excel. RISKSIMTABLE is helpful for automating the process of running multiple simulations with different input values. One difference between the RISKSIMTABLE functionality and the data table functionality is that it runs a simulation for each input value and data table does not. O When multiple simulation runs are specified, the RISKSIMTABLE function is used to control in the value of a particular input cell that is used for each simulation. O The RISKSIMTABLE function is inserted into a cell with an input value and points to a range of values that the input value will take on.arrow_forwardWhat is the implication of a data distribution with mean, median and mode being approximately equal? Group of answer choices 1. The spread in the data are equal 2. The data are unstable 3. The data can not be plotted using a Histogram 4. The data are normally distributed 5. The data can not be plotted using a Box Plotarrow_forwardGiven the following panel data model Y = Bo + B1X + a; + U which of the followings is(are) correct? Yanıtınız: a, refers observable fixed effects while u, refers to unobservable fixed effects. a, and u are both unobservable. We cannot estimate B, if X, is time varying. O We cannot estimate the model if some individuals are dropped from the data.arrow_forward
- One of the assumptions made in simple regression is that ______________. a. the error terms are exponentially distributed b. the error terms have unequal variances c. the model is linear d. the error terms are dependent e. the model is nonlineararrow_forwardTrue or False: If our explanatory variables do not vary, our model will produce no estimatesarrow_forwardSelecting smoothing constant is a key decision when applying exponentialsmoothing method. When you have previous data, one approach to makingthis decision is to apply the method retrospectively to these data withdifferent values of smoothing constant and then choose the value ofsmoothing constant that gives the smallest MAD. Use this approach forchoosing smoothing constant with each of the following data, whichrepresent monthly sales. In each case, use an initial estimate of 50 andcompare with the following smoothing constants of 0.1, 0.2, 0.3, 0.4, and0.5a. 51, 48, 52, 49, 53, 49, 48, 51, 50, 49arrow_forward
- The total number of thousands of tons of coal produced per year over a 10-year period for a certain region is provided in the accompanying dataset. Use double exponential smoothing to determine which pairs of values for alphaα and betaβ minimize MAD for this dataset. alphaαequals=0.10.1, betaβequals=0.80.8; alphaαequals=0.40.4, betaβequals=0.30.3; alphaαequals=11, betaβequals=0.60.6 Question content area bottom Part 1 First find the MAD for each pair of values, alphaα and betaβ. (Type integers or decimals rounded to two decimal places as needed.) alphaα betaβ MAD 0.10.1 0.80.8 enter your response here 0.40.4 0.30.3 enter your response here 11 0.60.6 enter your response here Part 2 Which pair of values for alphaα and betaβ minimize MAD for this dataset? alphaαequals=enter your response here and betaβequals=enter your response here (Type integers or decimals. Do not round.)arrow_forwardEddies restaurant collected the following data on the relationship between advertising and sales at a sample of five restaurants. .let x prepresent advertising expenditures and y represent sales. Use the method of least squares to develop a straight line approximation of the relationship between the two variablesarrow_forwardThe file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a supermarket for a one-year period. a. Using a span of 3, forecast the sales of this product for the next 10 weeks with the moving averages method. How well does this method with span 3 forecast the known observations in this series? b. Repeat part a with a span of 10. c. Which of these two spans appears to be more appropriate? Justify your choice.arrow_forward
- The 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_forwardThe method for rating teams in Example 7.8 is based on actual and predicted point spreads. This method can be biased if some teams run up the score in a few games. An alternative possibility is to base the ratings only on wins and losses. For each game, you observe whether the home team wins. Then from the proposed ratings, you predict whether the home team will win. (You predict the home team will win if the home team advantage plus the home teams rating is greater than the visitor teams rating.) You want the ratings such that the number of predictions that match the actual outcomes is maximized. Try modeling this. Do you run into difficulties? (Remember that Solver doesnt like IF functions.) EXAMPLE 7.8 RATING NFL TEAMS9 We obtained the results of the 256 regular-season NFL games from the 2015 season (the 2016 season was still ongoing as we wrote this) and entered the data into a spreadsheet, shown at the bottom of Figure 7.38. See the file NFL Ratings Finished.xlsx. (Some of these results are hidden in Figure 7.38 to conserve space.) The teams are indexed 1 to 32, as shown at the top of the sheet. For example, team 1 is Arizona, team 2 is Atlanta, and so on. The first game entered (row 6) is team 19 New England versus team 25 Pittsburgh, played at New England. New England won the game by a score of 28 to 21, and the point spread (home team score minus visitor team score) is calculated in column J. A positive point spread in column J means that the home team won; a negative point spread indicates that the visiting team won. The goal is to determine a set of ratings for the 32 NFL teams that most accurately predicts the actual outcomes of the games played.arrow_forwardSuppose you have invested 25% of your portfolio in four different stocks. The mean and standard deviation of the annual return on each stock are shown in the file P11_46.xlsx. The correlations between the annual returns on the four stocks are also shown in this file. a. What is the probability that your portfolios annual return will exceed 30%? b. What is the probability that your portfolio will lose money during the year?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,