Consider the following sensitivity report: Sensitivity Report Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SB$2 Coffee blend A (xl) 120 0 1.95 E+30 3.083333333 $CS2 Coffee Blend B (x2) 80 0 1.7 E+30 4.625 Constraints Final Shadow Constraint Allowable Allowable Increase Cell Name Value Price R.H. Side Decrease $D$10 Available quanitity of Coffee G SD$11 Proportion of sales SD$7 Brewing capacity SD$8 Available quanitity of Coffee B |SD$9 Available quanitity of Coffee T 78 0 80 E+30 2 0 0.1 0 33.33333333 50 200 1.85 200 5.128205128 200 74 80 1E+30 6 1E+30 48 0 80 32 What would be the change in objective function if the objective coefficient for variable xl is changed from 1.95 to 2? a) Objective function will increase by $8 b) Objective function will increase by $6 c) Objective function will remain unchanged d) Can't be determined due to insufficient information

Consider the following sensitivity report: Sensitivity Report Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SB$2 Coffee blend A (xl) 120 0 1.95 E+30 3.083333333 $CS2 Coffee Blend B (x2) 80 0 1.7 E+30 4.625 Constraints Final Shadow Constraint Allowable Allowable Increase Cell Name Value Price R.H. Side Decrease $D$10 Available quanitity of Coffee G SD$11 Proportion of sales SD$7 Brewing capacity SD$8 Available quanitity of Coffee B |SD$9 Available quanitity of Coffee T 78 0 80 E+30 2 0 0.1 0 33.33333333 50 200 1.85 200 5.128205128 200 74 80 1E+30 6 1E+30 48 0 80 32 What would be the change in objective function if the objective coefficient for variable xl is changed from 1.95 to 2? a) Objective function will increase by $8 b) Objective function will increase by $6 c) Objective function will remain unchanged d) Can't be determined due to insufficient information

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter7: Nonlinear Optimization Models

Section: Chapter Questions

Problem 63P

See similar textbooks

Similar questions

An automobile manufacturer is considering whether to introduce a new model called the Racer. The profitability of the Racer depends on the following factors: The fixed cost of developing the Racer is triangularly distributed with parameters 3, 4, and 5, all in billions. Year 1 sales are normally distributed with mean 200,000 and standard deviation 50,000. Year 2 sales are normally distributed with mean equal to actual year 1 sales and standard deviation 50,000. Year 3 sales are normally distributed with mean equal to actual year 2 sales and standard deviation 50,000. The selling price in year 1 is 25,000. The year 2 selling price will be 1.05[year 1 price + 50 (% diff1)] where % diff1 is the number of percentage points by which actual year 1 sales differ from expected year 1 sales. The 1.05 factor accounts for inflation. For example, if the year 1 sales figure is 180,000, which is 10 percentage points below the expected year 1 sales, then the year 2 price will be 1.05[25,000 + 50( 10)] = 25,725. Similarly, the year 3 price will be 1.05[year 2 price + 50(% diff2)] where % diff2 is the percentage by which actual year 2 sales differ from expected year 2 sales. The variable cost in year 1 is triangularly distributed with parameters 10,000, 12,000, and 15,000, and it is assumed to increase by 5% each year. Your goal is to estimate the NPV of the new car during its first three years. Assume that the company is able to produce exactly as many cars as it can sell. Also, assume that cash flows are discounted at 10%. Simulate 1000 trials to estimate the mean and standard deviation of the NPV for the first three years of sales. Also, determine an interval such that you are 95% certain that the NPV of the Racer during its first three years of operation will be within this interval.
solve a and b The following table shows the rank attained by male and female officers in the NewYork City Police Department (NYPD).a) Do these data indicate that men and women are equitably represented at all levelsof the department? Test using a p-value approach. Male FemaleOfficer 21,900 4281Detective 4058 806Sergeant 3898 415Lieutenant 1333 89Captain 359 12Higher ranks 218 10 b) There are far more men than women in the police force in general. However, the NYCPolice Commission has set itself certain goals with respect to the positions of the femalesamong its ranks. Across the females they aim to target the same proportion by rank asthey do among the males. The target proportions by category are:(1) Officer – 70% (2) Detectives – 15% (3) Sargent – 10%(4) Lieutenant – 3% (5) Captain – 1% (6) Higher – 1%Conduct a test to determine whether the proportions,…
The director of cooperative education at a state college wants to examine the effect of cooperative education job experience on marketability in the work place. She takes a random sample of 4 students. For these 4, she finds out how many times each had a cooperative education job and how many job offers they received upon graduation. These data are presented in the table below. Student CoopJobs JobOffer 1 1 4 2 2 6 3 1 3 4 0 1
Use the table below to answer the questions that follow and caculate the Expected Monetary Value(EMV) of the different outcomesDECISION TABLE WITH CONDITIONAL VALUESSTATE OF NATUREFAVORABLE OUTCOME UNFAVORABLE OUTCOMEALTERNATIVES ($) ($)Start a big Company 2,000,000 -500,000Start a small company 800,000 -200,000Build Nothing 0 0Probabilities 0.3 0.7Calculate the following The EMV Maximin criterion Maximax criterion Minimax criterion
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?
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…
Below is an excerpt from the article: Bennett, R. (2005). Factors associated with student plagiarism in a post-1992 university. Assessment & Evaluation in Higher Education, 30, 137-162.“There is a need for university staff to address forcefully the issue of academic integrity during introductory programs and to explain clearly and sympathetically the objective need for honesty in academic life” (p. 156).Which of the following examples correctly paraphrases the above passage without plagiarizing? Select one: a. During orientations, university staff should be very clear about the importance of academic integrity (Bennett, 2005). b. There is a need for colleges to forcefully address the issue of academic integrity during beginning programs and to explain clearly and sympathetically the objective need for integrity in college life (Bennett, 2005). c. There is a need for university staff to address forcefully the issue of academic integrity during introductory programs and to explain…
A Midsize Pharmaceutical CompanyJennifer Childs is the owner and chief executive officer of a midsize global pharmaceutical company with sales offices or manufacturing plants in eight countries. At an October staff meeting she tells her managers that company profits for the year are expected to be $2,000,000 more than anticipated. She tells them she would like to reinvest this additional profit by funding projects within the company that will either increase sales or reduce costs. She asks her three key managers to get together to develop a prioritized list of potential projects and then to meet with her to “sell” her on their ideas. She mentions that they should not assume the funds will be divided equally among the three of them. She also mentions that she is willing to put all of the funds into just one project if it seems appropriate. Julie Chen, manager of product development, has had a team of scientists working on a new prescription drug. This effort has been taking much longer…
A Midsize Pharmaceutical CompanyJennifer Childs is the owner and chief executive officer of a midsize global pharmaceutical company with sales offices or manufacturing plants in eight countries. At an October staff meeting she tells her managers that company profits for the year are expected to be $2,000,000 more than anticipated. She tells them she would like to reinvest this additional profit by funding projects within the company that will either increase sales or reduce costs. She asks her three key managers to get together to develop a prioritized list of potential projects and then to meet with her to “sell” her on their ideas. She mentions that they should not assume the funds will be divided equally among the three of them. She also mentions that she is willing to put all of the funds into just one project if it seems appropriate. Julie Chen, manager of product development, has had a team of scientists working on a new prescription drug. This effort has been taking much longer…
A Midsize Pharmaceutical CompanyJennifer Childs is the owner and chief executive officer of a midsize global pharmaceutical company with sales offices or manufacturing plants in eight countries. At an October staff meeting she tells her managers that company profits for the year are expected to be $2,000,000 more than anticipated. She tells them she would like to reinvest this additional profit by funding projects within the company that will either increase sales or reduce costs. She asks her three key managers to get together to develop a prioritized list of potential projects and then to meet with her to “sell” her on their ideas. She mentions that they should not assume the funds will be divided equally among the three of them. She also mentions that she is willing to put all of the funds into just one project if it seems appropriate. Julie Chen, manager of product development, has had a team of scientists working on a new prescription drug. This effort has been taking much longer…
what is advantage and dis advantage of the following: maximac criterion maximin Criterion Minimax regret criterion Hurwicz Criterion Equal likelihood criterion
1. Suppose you are going on a weekend trip to a city that is d miles away. Develop a model that determines your round-trip gasoline costs. What assumptions or approximations are necessary to treat this model as a deterministic model? Are these assumptions or approximations acceptable to you? 2. Suppose that a manager has a choice between the following two mathematical models of a given situation: (a)a relatively simple model that is a reasonable approximation of the real situation, and (b)a thorough and complex model that is the most accurate mathematical representation of the real situation possible. Why might the model described in part (a) be preferred by the manager?