Question: Question 4. What-if analysis (25 marks) Answer the following questions considering the sensitivity analysis report given below: 6 Variable Cells 7 Final Reduced Objective Allowable

Question 4. What-if analysis (25 marks) Answer

Question 4. What-if analysis (25 marks) Answer the following questions considering the sensitivity analysis report given below: 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $C$13 Variable 1 0 -50 1300 50 1E+30 10 $D$13 Variable 2 20 0 600 150 50 11 $E$13 Variable 3 10 0 500 300 33.33333333 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 $F$10 Constraint 3 Spent 0 0 5 1E+30 5 17 $F$8 Constraint 1 Spent 4000 3 4000 1000 1500 18 $F$9 Constraint 2 Spent 1000 5 1000 600 200 10 a. What is the optimal solution? (2 marks) b. What is the optimal objective function value? (3 marks) C. What is the allowable range for the objective function coefficient of Variable 1? (3 marks) d. What is the allowable range for the Right-hand side value of "Constraint 1? (3 marks) Does the optimal solution change if we change the objective function coefficient of "Variable 2" to 800? Why? (3 marks) e

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!

Ignacio Carlos Flores-Figueroa (Defendant) was convicted in the United States District Court for the Southern District of Iowa of aggravated identity theft. Flores-Figueroa appealed on the ground...

Question 4. What-if analysis (25 marks) Answer the following questions considering the sensitivity analysis report given below: -50 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8...

The LP problem whose output follows determines how many necklaces, bracelets, rings, and earrings a jewelry store should stock. The objective function measures profit; it is assumed that every piece...

Eastcoasters, a bicycle shop in Blacksburg, stocks bicycles for walk-in customers. Three types of bicycles are sold at the store: road racing, cross country, and mountain. The average cost of a road...

A salad dressing supplier to Ottawa area restaurants has been using Linear Programming (LP) for years to determine how much dressing they should produce for every season. In particular, they...

Q4: Consider the LP + 10B + 4C min 3A s.t. + + ALAL 40 + B B 2B A 35 > 0 9 7 The problem is solved by Excel Solver and the Excel Solver sensitivity report for the LP model is given below: Variable...

(15) Problem #1 A company manufactures three products X1, X2, and x3 requiring two resources, labor and material. The following LP problem was formulated to determine the production level of each...

The A-B-C department of a large company makes three products (A, B and C). To determine the best production schedule, the manager has formulated the following linear programming model: Decision...

In the movie Forrest Gump, the public school required an IQ of at least 80 for admittance. a. If IQ test scores are normally distributed with mean 100 and standard deviation 16, what percentage of...

Using the simple model of Table 15.12, explain why there is a balance of payments equilibrium when export spending equals import spending. What is the more general condition for equilibrium in the...

Morningside Bakeries recently purchased equipment at a cost of $650,000. Management expects the equipment to generate cash flows of $275,000 in each of the next four years. The cost of capital is...

On June 30, 2015, Wisconsin, Inc., issued $158,100 in debt and 21,600 new shares of its $10 par value stock to Badger Company owners in exchange for all of the outstanding shares of that company....