Consider the following sensitivity report: Sensitivity Report Variable Cells Allowable Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase Decrease $B$2 Coffee blend A (x1) $C$2 Coffee Blend B (x2) 120 0 1.95 E+30 3.083333333 80 0 1.7 E+30 4.625 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SD$10 Available quanitity of Coffee G $D$11 Proportion of sales SDS7 Brewing capacity SDS8 Available quanitity of Coffee B SD$9 Available quanitity of Coffee T 78 0 80 E+30 2 0 33.33333333 0 0.1 50 200 185 200 5.128205128 200 0 74 80 E+30 6 48 0 80 E+30 32 What would be the change in optimal solution if the objective coefficient for variable xl is changed from 1.95 to 2? a) Final value for X1 will increase, but final value of X2 will decrease b) Final value for X1 will increase, but final value of X2 will remain unchanged c) No change would take place in the final value of Xl and X2 d) Can't be determined due to insufficient information

Consider the following sensitivity report: Sensitivity Report Variable Cells Allowable Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase Decrease $B$2 Coffee blend A (x1) $C$2 Coffee Blend B (x2) 120 0 1.95 E+30 3.083333333 80 0 1.7 E+30 4.625 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SD$10 Available quanitity of Coffee G $D$11 Proportion of sales SDS7 Brewing capacity SDS8 Available quanitity of Coffee B SD$9 Available quanitity of Coffee T 78 0 80 E+30 2 0 33.33333333 0 0.1 50 200 185 200 5.128205128 200 0 74 80 E+30 6 48 0 80 E+30 32 What would be the change in optimal solution if the objective coefficient for variable xl is changed from 1.95 to 2? a) Final value for X1 will increase, but final value of X2 will decrease b) Final value for X1 will increase, but final value of X2 will remain unchanged c) No change would take place in the final value of Xl and X2 d) Can't be determined due to insufficient information

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section: Chapter Questions

Problem 49P

See similar textbooks

Similar questions

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
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…
Based on Carino and Lenoir (1988). BradyCorporation produces cabinets. Each week, Bradyrequires 90,000 cubic feet of processed lumber. Thecompany can obtain lumber in two ways. First, itcan purchase lumber from an outside supplier andthen dry it at the Brady kiln. Second, Brady canchop down trees on its land, cut them into lumber atits sawmill, and then dry the lumber at its kiln. Thecompany can purchase grade 1 or grade 2 lumber.Grade 1 lumber costs $3 per cubic foot and whendried yields 0.7 cubic foot of useful lumber. Grade 2lumber costs $7 per cubic foot and when dried yields0.9 cubic foot of useful lumber. It costs the company$3 to chop down a tree. After being cut and dried,a log yields 0.8 cubic feet of lumber. Brady incurscosts of $4 per cubic foot of lumber it dries. It costs$2.50 per cubic foot of logs sent through the sawmill.Each week, the sawmill can process up to 35,000cubic feet of lumber. Each week, up to 40,000 cubicfeet of grade 1 lumber and up to 60,000 cubic feetof…
This problem does not require the use of data mining software and focuses on knowledge of concepts and basic calculations. Jay Gatsby categorizes wines into one of three clusters. The centroids of these clusters (in standardized units), describing the average characteristics of a wine in each cluster, are listed in the following table. Characteristic Cluster 1 Cluster 2 Cluster 3 Alcohol 0.819 0.164 −0.937 Malic Acid −0.329 0.869 −0.368 Ash 0.248 0.186 −0.393 Alkalinity −0.677 0.523 0.249 Magnesium 0.643 −0.075 −0.573 Phenols 0.825 0.977 −0.034 Flavonoids 0.896 −1.212 0.083 Nonflavonoids −0.595 0.724 0.009 Proanthocyanidins 0.619 −0.778 0.010 Color Intensity 0.135 0.939 −0.881 Hue 0.497 −1.162 0.437 Dilution 0.744 −1.289 0.295 Proline 1.117 −0.406 −0.776 Jay has recently discovered a new wine from the Piedmont region of Italy with the following characteristics. In which cluster of wines should Jay place this new wine? Justify your choice with appropriate…
Karen Archer is the hiring manager for a coal mining company in Kentucky. Karen finds her job especially fulfilling because she knows how important employment in the mines is for the local community where few other job prospects exist. Recently, Karen learned that top management has been hiding some disturbing information on the levels of toxins in the air in the deeper parts of the mine. Although only a couple of people are exposed to the risk, which seems slight, Karen is very upset because she views the people she hires as family. Using the knowledge that you have about Karen, explain the cognitive dissonance that she is experiencing and two ways that Karen could alter her behavior or attitude to reduce the dissonance?
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…
Rucklehouse Public Relations has been contracted to do a survey following an election primary in New Hampshire. The firm must assigninterviewers to conduct the survey by telephone or in person. One person can conduct 80 telephone interviews or 40 personal interviews in asingle day. The following criteria have been established by the firm to ensure a representative survey:At least 3,000 interviews must be conducted.At least 1,000 interviews must be by telephone.At least 800 interviews must be personal.An interviewer conducts only one type of interview each day. The cost is $50 per day for a telephone interviewer and $70 per day for a personalinterviewer. The firm wants to know the minimum number of interviewers to hire in order to minimize the total cost of the survey Determine the sensitivity ranges for the daily cost of a telephone interviewer and the number of personal interviews required.
A portfolio manager summarizes the input from the macro and micro forecasters in the following table: Micro Forecasts AssetExpected Return (%)BetaResidual Standard Deviation (%) Stock A 22 1.4 53 Stock B 21 1.8 61 Stock C 19 0.7 58 Stock D 16 1.1 46 Macro Forecasts AssetExpected Return (%)Standard Deviation (%) T-bills 7 0 Passive equity portfolio 16 20 Calculate the following for a portfolio manager who is not allowed to short sell securities. If allowed to short sell securities, the manager's Sharpe ratio is 0.4647. a. What is the cost of the restriction in terms of Sharpe’s measure? (Do not round intermediate calculations. Enter your answer as decimals rounded to 4 places.) cost of restriction= b. What is the utility loss to the investor (A = 1.9) given his new complete portfolio? (Do not round intermediate calculations. Round your answers to 2 decimal places.)
a wine maker has a stock of three different wines with the following characteristics Wine proofs acids(%) specific gravity stock(gallons) A 27 .32 1.70 20 B 33 .20 1.08 34 C 32 .30 1.04 22 A dry table wine should be between 30 and 31 degree proof, it should contain at least 0.25% acid and should have a specific gravity of at least 1.06. The wine maker wishes to blend the three types of wine to produce as large a quantity as possible of satisfactory dry table wine. However, his stock of wine A must be completely used in the blend because further storage would cause it to deteriorate. What quantities of wines of B and C should be made in the blend. Formulate this problem as LP model. a wine maker has a stock of three different wines with the following characteristicsWine proofs acids(%) specific gravity stock(gallons)A 27 .32 1.70 20B 33 .20 1.08 34C 32 .30 1.04 22 A dry table wine…
The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $1000 between newspaper advertising and radio advertising. Management decided that at least 25% of the budget must be spent on each type of media, and that the amount of money spent on local newspaper advertising must be at least twice the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar of advertising on a scale from 0 to 100, with higher values implying greater audience exposure. If the value of the index for local newspaper advertising is 50 and the value of the index for spot radio advertising is 80, how should the restaurant allocate its advertising budget in order to maximize the value of total audience exposure? a. Formulate a linear programming model that can be used to determine how the restaurant should allocate its advertising budget in order to maximize the value of total audience exposure. It's…