Question: (c) The sensitivity report for the problem is shown below: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$2

(c) The sensitivity report for the problem is shown below: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$2 x1 6.4 o 6 3 4.5 $C$2 x2 1.8 0 3 9 1 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$3 c1 0.3 20 64 6 $D$4 c2 21 1.8 21 9 16 20 (i) Determine the allowable interval for the coefficient of X1 of the objective function. (ii) If the coefficient for x2 in the objective function is changed to 8, will the current solution remain optimal? (iii) Determine the allowable interval for the right hand side of constraint 1 (iv) If the right hand side of constraint 2 is changed to 15, will the optimal mix remain the same

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Classic New Orleans desserts include pralines, pecan pie and Bananas Foster. A recipe for a dozen pralines takes a cup of pecans, two cups of brown sugar, a cup of granulated sugar, a half teaspoon...

Given the below table generated by Excel Solver's sensitivity analysis: What will happen to the objective value if the coefficient of Variable Y is increased by 2? Variable Cells Final Reduced...

Consider the following linear program. Maximise total profit ($) = 3X 1 + 4X 2 Subject to constraints: X 1 +3X 2 ? 12 (constraint 1) 2X 1 +X 2 ? 8 (constraint 2) X 1 ? 3 (constraint 3) X 1 , X 2 ? 0....

Which answer choice results in the biggest improvement to the Objective Function Value? Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease...

We are making four products ( P 1 - P 4 ) . Objective function coefficients are profit per unit for each product. Constraints are the amount of labor available, raw materials ( 1 , 2 and 3 ) and...

Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $M$19 Decision Variable Tablet 16 0 80 70 20 $N$19 Decision Variable Smart Phone 10 0 120...

Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $G$3 125 92 0 18 1E+30 18 $G$4 s.t. 36 0 12 1E+30 18 Constraints Final Shadow Constraint...

Question 4 George, a farmer in west Victoria, Is determining what crops to grow on his 120-acre land that was recently bought via an auction. There are two crops he is considering: soybean and com....

Suppose that the marginal propensity to save is dS/dy=0.2-0.1e^-2y and the consumption is 7.8 trillion when disposable income is $0. Find the national consumption function: C(y)=?

1) Are US Accounting and Auditing Standards law? Explain your answer? 2) Who established the SEC and what are the major functions of the SEC? 3) What role does the SEC play in establishing Accounting...

What does " Mkt . Cap." mean? Group of answer choices the total value of a company. The maximum number of stock shares that a company is allowed to sell to the public. The maximum quantity of product...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...