1. D. $0
Shadow price of resource C is 0, hence one unit increase in resource C has no effect in total profit
2. C. 13<=A2<=53
For activity 1, allowable increase =23, allowable decrease = 17, objective coefficient = 30
Lower value = 30 - 27 = 13
Upper value = 30+23 = 53
3. B. the original solution remains optimal
For activity 1, allowable increase =23, allowable decrease = 17, objective coefficient = 30
Lower value = 30 - 27 = 13
Upper value = 30+23 = 53
Original solution remains optimal for coefficient of activity 1 in the range of (13,53)
4. C. will increase by $38.9
Shadow price of resource A is $7.78
one unit increase in resource A will increase objective function value by $7.78. Hence 5 units increase will increase objective function value by $7.78*5 = $38.9
Refer to the following sensitivity report Vaiatle Cels Reduced Objectirve Cel Hame Cost Value 3 C$6...
Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$6 Activity 1 3 0 30 23 17 $C$6 Activity 2 6 0 40 50 10 $D$6 Activity 3 0 –7 20 7 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease $E$2 Resource A 20 7.78 20 10 12.5 $E$3 Resource B 30 6 30 50 10 $E$4 Resource C 18 0 40 1E+30 22 What is the allowable...
200 The sensitivity report: Adjustable Cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $C$18 Baskets 25 0 2.5 1E430 0.5 1E+30 $C$19 0 -1 1.5 1 Eggs Rabbits $C$20 25 0 2 0.5 1E+30 Constraints Cell Name Final Value Dual Constraint R.H.Side Allowable Increase Allowable Decrease Value $G$13 Mix/mold 18.75 0 20 1.25 1E+30 2.5 $G$14 Kiln 50 2.5 25 50 80 Paint and Seal 25 0 1E+30 55 $G$15 $G$16 Demand 25 -0.5 25...
1.Using the sensitivity report below, answer the following question: Which constraints are binding? Name Final Value Reduced Cost Objective Coefficient Allowable Increase AllowableDecrease # Of Apple Pie 5.66 0 6 5.87 3.25 # Of Turnovers 35.25 0 0.75 0.89 0.55 # Of Cheesecake 4 0 8 1E+30 3.860759494 Name Value price R.H. Side Increase Decrease Apple Total 16.81 0 20.83 1E+30 4.02 Flour Total 5.7 6.17 5.7 2.67 2.98 Sugar Total 200 0.21 200 63.534 71.77 Cheese Total 15 1.03...
(b) A LP model and its solution outputs and sensitivity report are as below. LP Model: Maximise R 7X+5Y+10 Z Subjective to: CI: 2X +Y+32 <= 50 C3: X 3 C6: X, Y, Z)so Outputs & Sensitivity Report: Objective Cell Name Valu 101.33 SC$8 Max Variable Cells Final Value ReducedObjective Allowable Allowable Coefficient Increase Cell Name Cost Decrease 7.333333333 SC$3 X 0 E+30 SC$4 Y 0 5 4.333333333 E+30 SC$5 2 4 0 10 1.666666667 E+30 Constraints Final Value Shadow...
Question 14 5 pts Consider the sensitivity report below for the problems which follow. 6 Variable Cells Name Cell $8$3 $C$3 x1 X2 Final Reduced Objective Allowable Allowable Value Cost Coefficient increase Decrease 34 67.333333333 4011 12 Constraints Cell Constraint Allowable Allowable RH. Side Increase Decrease Name $0$10 Extrusion Used $0$11 Packaging Used $D$12 Additive Used Final Shadow Value Price 48 3 18 11 12 0 18 16 2 1E30 4 Which of the following constraints are binding? Extrusion and...
HERE IS THE SENSITIVITY REPORT!!!!!!!!! PLEASE SHOW ALL WORK A B C D E F G H J K M N O 1 Transportation Model (Basic) Use Solver on Data Ribbon to solve 2 3 Input Matrix: Destinations C D A 4 1 4 7 7 1 100 5 SUPPLY 8 8 2 12 3 200 6 5 3 10 16 150 7 90 80 120 160 8 Demand Required 10 Do not change or delete unshaded cells. 11 12...
hapter 5 Quiz (pp. 150-162) Saved Help In linear programming, what-if analysis is associated with determining the effect of changing I. objective function coefficients Il. right-hand side values of constraints. IlI. decision variable values. 0150-13) Multiple Choice eBook objective function coefficients and right-hand side values of constraints References right-hand side values of constraints and decision variable values objective function coefficients, right-hand side values of constraints, and decision variable values objective function coefficients and decision veriable values None of the choices...
(10) Problem #3 Using the Sensitivity Report output for the Blue Ridge Hot Tub example appearing below: a. What is the range in the number of available pumps that will keep the current basis optimal assuming the amount of labor hours and tubing feet remain constant? b. Blue Ridge is considering introducing a new model of hot tub called the Typhoon-Tub. Suppose that each unit of this new model requires 1 pump, 12 hours of labor, and 13 feet of...
Very Good Juice Company produces five different juices: cherry, apple, orange, pineapple, and lemon. Each month, management is faced with the decision of how much of each product to produce for the next month. Virtually no finished product inventory is carried, but ample supplies of the raw materials are on hand. The products yield different profits and require different amounts of machine time in each of three processes (blending, straining, and bottling). The relevant data, per 1,000 gal as well...
1 2 12 1 14 Performance Cooling Inc. manufactures air conditioners for home use and they currently have three models serving this market: (1) the essential model, (2) the comfort model, and (3) the majestic model. The units sell for reasonable prices and bring in a profit of $63, 995, and $135 respectively. Currently, the resources required for production of each unit is given in the table below. Fans Cooling Coils Assembly Time (hr) Essential 8 Comfort Majestic In Stock/Available...