Refer to the following sensitivity report: Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$2 Product_1 0 −2 5 2 1E+30 $B$3 Product_2 175 0 7 1E+30 1 $B$4 Product_3 0 −1.5 9 1.5 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side Allowable Increase Allowable Decrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700 If the right-hand side of Resource_C increases to 750, which of the following would be true The objective function value will increase by $1.75 The objective function value will decrease by $1.75 The objective function value will increase by $87.50 The objective function value will decrease by $87.50 None of the answer choices is correct

Refer to the following sensitivity report: Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$2 Product_1 0 −2 5 2 1E+30 $B$3 Product_2 175 0 7 1E+30 1 $B$4 Product_3 0 −1.5 9 1.5 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side Allowable Increase Allowable Decrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700 If the right-hand side of Resource_C increases to 750, which of the following would be true The objective function value will increase by $1.75 The objective function value will decrease by $1.75 The objective function value will increase by $87.50 The objective function value will decrease by $87.50 None of the answer choices is correct

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section9.5: Multistage Decision Problems

Problem 17P

See similar textbooks

Similar questions

The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?
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.
Bus and subway ridership for the summer months in London England is believed to be tied heavily to the number of tourists visiting the city. During the past 12 years, the following data have been obtained: Year 1 2 3 4 5 6 7 8 9 10 11 12 # of tourist (millions) 7 2 6 4 14 15 16 12 14 20 15 7 Ridership(millions) 1.6 1.1 1.4 1.5 2.6 2.8 2.5 1.9 2.7 4.4 3.5 1.6 b) The least squares regression equation that shows the best relationship between ridership and the number of tourists is ^y=[_]+[_]X where ^y= Dependent Variable and x= Independent Variable
#28Even though independent gasoline stations have been having a difficult time, Susan Solomon hasbeen thinking about starting her own independent gasoline station. Susan’s problem is to decide howlarge her station should be. The annual returns will depend on both the size of her station and a numberof marketing factors related to the oil industry and demand for gasoline. After a careful analysis, Susandeveloped the following table: GOOD FAIR POORSIZE OF MARKET MARKET MARKETFIRST STATION ($) ($) ($)Small 50,000 20,000 –10,000Medium 80,000 30,000 –20,000Large 100,000 30,000 –40,000Very large 300,000 25,000 –160,000For example, if Susan constructs a…
Carlisle Tire and Rubber, Inc., is considering expanding production to meet potential increases in the demand for one of its tire products. Carlisle’s alternatives are to construct a new plant, expand the existing plant, or do nothing in the short run. The market for this particular tire product may expand, remain stable, or contract. Carlisle’s marketing department estimates the probabilities of these market outcomes to be 0.25, 0.35, and 0.40, respectively. The file P09_31.xlsx contains Carlisle’s payoffs and costs for the various combinations of decisions and outcomes. a. Use PrecisionTree to identify the strategy that maximizes this tire manufacturer’s expected profit. b. Perform a sensitivity analysis on the optimal decision, letting each of the monetary inputs vary one at a time plus or minus 10% from its base value, and summarize your findings. Which of the inputs appears to have the largest effect on the best solution? Tire plant decisions Decision\outcome…
Macomb Inc. used Excel to run a least-squares regression analysis on the production cost data resulting in the following output: Regression StatisticsMultiple R 0.9834 R Square 0.9596 Observations 30 Coefficients Standard Error T Stat P-ValueIntercept 174,980 61,580 2.84 0.021 Production units (X) 11.53 0.9265 12.44 0.000 What total cost would Macomb predict for a month in which production is 2,000 units? Multiple Choice $174,900 $63,433 $198,040 $23,037
A motion picture industry analyst is studying movies based on epic novels. The following data were obtained for 10 Hollywood movies made in the past five years. Each movie was based on an epic novel. For these data, x1 = first-year box office receipts of the movie, x2 = total production costs of the movie, x3 = total promotional costs of the movie, and x4 = total book sales prior to movie release. All units are in millions of dollars. x1 x2 x3 x4 85.1 8.5 5.1 4.7 106.3 12.9 5.8 8.8 50.2 5.2 2.1 15.1 130.6 10.7 8.4 12.2 54.8 3.1 2.9 10.6 30.3 3.5 1.2 3.5 79.4 9.2 3.7 9.7 91.0 9.0 7.6 5.9 135.4 15.1 7.7 20.8 89.3 10.2 4.5 7.9 a) Suppose Hollywood is planning a new epic movie with projected box office sales x1 = 100 million and production costs x2 = 12 million. The book on which the movie is based had sales of x4 = 9.2 million. Forecast the dollar amount (in millions) that should be budgeted for promotion costs x3 and find an 80% confidence interval for your…
Use the following data to answer all of the remaining questions. Consider a commodity market where the products provided by all sellers are identical. A group of 12 potential buyers in this market have willingness to pay (WTP) as follows (in random order): $65, $60, $55, $80, $70, $30, $20, $55, $10, $45, $40, and $15. A group of potential suppliers serving this market have wiliness to accept (WTA) as follows (also in random order): $20, $25, $30, $10, $45, $50, $55, $15, $20, $30, $40, and $60. What is the value captured by all sellers? Buyers 2. What is the value captured in this market by an individual buyer with WTP = $80? 3. What is the total consumers surplus (i.e., all buyers) in this market? Value added 4. What is the value added for the supplier with a WTA (willingness to accept) of $15?
Refer to Problems 1 and 2. Construct a graph that will enable you to perform sensitivity analysis on the problem. Over what range of P(high) would the alternative of doing nothing be best? Expand? Subcontract?
Integrated Products Corporation (IPC) needs to estimate its PC sales for next year.The most recent six years of revenue data for the company’s line of XT PersonalComputers, and those of the industry, is found in the table below:Year XT PC Sales Revenue($’000,000)All Industry PC Sales Revenue($’000,000,000)1 2.4 4.62 5.9 8.63 15.5 10.74 27.8 14.85 35.9 18.56 38.1 19.4Required:A. Assuming that the sales data above are representative of sales expected nextyear, use time series regression analysis to forecast next year’s sales revenues(there is no seasonal effect).B. Perform a regression analysis between the annual sales revenues of XTPersonal Computers and all industry PC annual sales revenues. What is theforecast for next year’s sales revenue for XT Personal Computers if the estimateof next year’s industry PC sales revenues is $21.9 billion? C. Advise management at Integrated Products Corporation (IPC) which of the twosales estimates from parts A and B above they should use. Justify your…
Integrated Products Corporation (IPC) needs to estimate its PC sales for next year.The most recent six years of revenue data for the company’s line of XT PersonalComputers, and those of the industry, is found in the table below:Year XT PC Sales Revenue($’000,000)All Industry PC Sales Revenue($’000,000,000)1 2.4 4.62 5.9 8.63 15.5 10.74 27.8 14.85 35.9 18.56 38.1 19.4Required:A. Assuming that the sales data above are representative of sales expected nextyear, use time series regression analysis to forecast next year’s sales revenues(there is no seasonal effect).B. Perform a regression analysis between the annual sales revenues of XTPersonal Computers and all industry PC annual sales revenues. What is theforecast for next year’s sales revenue for XT Personal Computers if the estimateof next year’s industry PC sales revenues is $21.9 billion?
During the year, Brownout Company experienced the following power outages:Number of Power Outages Per Month Number of Months 0 3 1 2 2 4 3 3 12Each power outage results in out of pocket costs of P400. For P500 per month, the company can lease an auxiliary generator to provide power during outages. If the company leases an auxiliarygenerator next year, the estimated savings (or…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

Cell	Name	Final Value	Reduced Cost	Objective Coefficient	Allowable Increase	Allowable Decrease
$B$2	Product_1	0	−2	5	2	1E+30
$B$3	Product_2	175	0	7	1E+30	1
$B$4	Product_3	0	−1.5	9	1.5	1E+30