Below is the Sensitivity Report for the Par Inc. What would be the increase in the objective function if 10 additional hours were available in the Finishing Department? Enter your answer without a dollar sign and rounded to two decimal places.
Microsoft Excel 16.0 Sensitivity Report | |||||||
Worksheet: [Par.xlsx]Model | |||||||
Report Created: 3/1/2018 4:16:53 PM | |||||||
Variable Cells | |||||||
Final | Reduced | Objective | Allowable | Allowable | |||
Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
$B$14 | Bags Produced Standard | 540 | 0 | 10 | 3.5 | 3.7 | |
$C$14 | Bags Produced Deluxe | 252 | 0 | 9 | 5.285714286 | 2.333333333 | |
Constraints | |||||||
Final | Shadow | Constraint | Allowable | Allowable | |||
Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
$B$19 | Cutting and Dyeing Hours Used | 630 | 4.375 | 630 | 52.36363636 | 134.4 | |
$B$20 | Sewing Hours Used | 480 | 0 | 600 | 1E+30 | 120 | |
$B$21 | Finishing Hours Used | 708 | 6.9375 | 708 | 192 | 128 | |
$B$22 | Inspection and Packaging Hours Used | 117 | 0 | 135 | 1E+30 | 18 |
Shadow price for Finishing hours = 6.9375
Hence,
For 10 hours increase, the objective function will increase by (6.9375*10) i.e. 69.38
Below is the Sensitivity Report for the Par Inc. What would be the increase in the objective function if 10 additional hours were available in the Finishing Department? Enter your answer without a do...
Below is the Sensitivity Report for Par Inc. In which departments would you not investigate whether it was possible to increase the available hours? Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$14 Bags Produced Standard 540 0 10 3.5 3.7 $C$14 Bags Produced Deluxe 252 0 9 5.286 2.33 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$19 Cutting and Dyeing Hours Used 630 4.375 630 52.364...
The question is: If the company adds an additional worker in the
finishing department, what will happen?
The question is: If the company adds an additional worker in the
finishing department, what will happen?
Multiple choice answer options are below. The answer is either
A, B, C or D.
A.) profit will increase by $120
B.) profit will increase by $20
C.) the optimal solution will not change
D.) the company will produce 20 additional surfboards
Beach Boys Surfers is...
X1=130 and X2=0, optimal profit 32,500
Using the solver report and the sensitivity report
answer the question below. Please show your work:
Assume the marginal profit on the generators will
decrease by $25.00. Without solving the problem again, what is the
optimal profit for the company now?
We were unable to transcribe this imageDecision Variable Cells Final Reduced Objective Allowable Allowable Cell SCS4 Number to produce Generators SDS4 Number to produce Alternators Name Value Cost Coefficient Increase Decrease E+30 150.0000001...
Use the sensitivity report given to answer the questions below: Name SENSITIVITY REPORT Final Reduced Objective Value Cost Coefficient 110 0 350 300 75 Allowable Increase 80 # Aqua-Spa # Hydro-Lux # Typhoon-Lagoon Allowable Decrease 30 Infinite 10 -20 20 320 50 Constraints Name Shadow Price 150 Allowable Decrease Final Value 175 1400 2550 # Pumps used Hrs. Labor Used Ft. of Tubing Used Constant RHS 175 1500 2550 Allowable Increase 10 Infinite 100 15 125 O 7 50 11...
If you could sell 50 oz. of stabilizer at $2.25/oz, how would
this affect profit?
Adjustable Cells Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease Cell $B$5 Variable C $C$5 Variable P Name 100 350 0 1E+30 2 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 200 500 50 Cell Name $D$11 Fragrance LHS 1600 $D$12 Intensifier LHS 1300 $D$13 Stabilizer LHS 350 1600 166.6666667 1E+30 50 1.5 1800 350 2
Adjustable Cells Final...
(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...
The sensitivity report is shown in Figure below SENSITIVITY REPORT FOR THE DIGITAL CONTROLS, INC., PROBLEM Variable Cells Model Final Reduced Objective Allowable Allowable Name Variable Value Coefficient Increase Decrease Cost Models A Manufactured 1.750 IE+30 AM 00.000 0.000 10.000 3.000 Models B Manufactured 0.000 2.333 BM 60.000 6.000 1.750 AP BP Models A Purchased E+30 1.750 0.000 90.000 14.000 0.000 3.000 Models B Purchased 9.000 2.333 Constraints Final Shadow Constraint Allowable Allowable Price Constraint Number Name R.H. Side Value...
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...
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...
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...