Exam 8: Linear Programming: Sensitivity Analysis and Interpretation of Solution

arrow
  • Select Tags
search iconSearch Question
  • Select Tags

Use the spreadsheet and Solver sensitivity report to answer these questions. Use the spreadsheet and Solver sensitivity report to answer these questions.      a.What is the cell formula for B12? b.What is the cell formula for C12? c.What is the cell formula for D12? d.What is the cell formula for B15? e.What is the cell formula for B16?f. What is the cell formula for B17?g. What is the optimal value for x1?h. What is the optimal value for x2?i. Would you pay $.50 each for up to 60 more units of resource 1?j. Is it possible to figure the new objective function value if the profit on product 1 increases by a dollar, or do you have to rerun Solver?    Use the spreadsheet and Solver sensitivity report to answer these questions.      a.What is the cell formula for B12? b.What is the cell formula for C12? c.What is the cell formula for D12? d.What is the cell formula for B15? e.What is the cell formula for B16?f. What is the cell formula for B17?g. What is the optimal value for x1?h. What is the optimal value for x2?i. Would you pay $.50 each for up to 60 more units of resource 1?j. Is it possible to figure the new objective function value if the profit on product 1 increases by a dollar, or do you have to rerun Solver?    a.What is the cell formula for B12? b.What is the cell formula for C12? c.What is the cell formula for D12? d.What is the cell formula for B15? e.What is the cell formula for B16?f. What is the cell formula for B17?g. What is the optimal value for x1?h. What is the optimal value for x2?i. Would you pay $.50 each for up to 60 more units of resource 1?j. Is it possible to figure the new objective function value if the profit on product 1 increases by a dollar, or do you have to rerun Solver? Use the spreadsheet and Solver sensitivity report to answer these questions.      a.What is the cell formula for B12? b.What is the cell formula for C12? c.What is the cell formula for D12? d.What is the cell formula for B15? e.What is the cell formula for B16?f. What is the cell formula for B17?g. What is the optimal value for x1?h. What is the optimal value for x2?i. Would you pay $.50 each for up to 60 more units of resource 1?j. Is it possible to figure the new objective function value if the profit on product 1 increases by a dollar, or do you have to rerun Solver?    Use the spreadsheet and Solver sensitivity report to answer these questions.      a.What is the cell formula for B12? b.What is the cell formula for C12? c.What is the cell formula for D12? d.What is the cell formula for B15? e.What is the cell formula for B16?f. What is the cell formula for B17?g. What is the optimal value for x1?h. What is the optimal value for x2?i. Would you pay $.50 each for up to 60 more units of resource 1?j. Is it possible to figure the new objective function value if the profit on product 1 increases by a dollar, or do you have to rerun Solver?

(Essay)
4.8/5
(42)

To solve a linear programming problem with thousands of variables and constraints

(Multiple Choice)
4.9/5
(33)

For a minimization problem,a positive dual price indicates the value of the objective function will increase.

(True/False)
4.9/5
(35)

The 100% Rule compares

(Multiple Choice)
4.9/5
(28)

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 stocked will be sold.Constraint 1 measures display space in units,constraint 2 measures time to set up the display in minutes.Constraints 3 and 4 are marketing restrictions. LINEAR PROGRAMMING PROBLEM MAX 100X1+120X2+150X3+125X4 S.T. 1)X1+2X2+2X3+2X4<108 2)3X1+5X2+X4<120 3)X1+X3<25 4)X2+X3+X4>50 OPTIMAL SOLUTION Objective Function Value = 7475.000 Variable Value Reduced Cost X1 8.000 0.000 X2 0.000 5.000 X3 17.000 0.000 X4 33.000 0.000 Constraint Slack/Surplus Dual Price 1 0.000 75.000 2 63.000 0.000 3 0.000 25.000 4 0.000 -25.000 OBJECTIVE COEFFICIENT RANGES Variable Lower Limit Current Value Upper Limit X1 87.500 100.000 No Upper Limit X2 No Lower Limit 120.000 125.000 X3 125.000 150.000 162.500 X4 120.000 125.000 150.000 RIGHT HAND SIDE RANGES Constraint Lower Limit Current Value Upper Limit 1 100.000 108.000 123.750 2 57.000 120.000 No Upper Limit 3 8.000 25.000 58.000 4 41.500 50.000 54.000 Use the output to answer the questions. a.How many necklaces should be stocked? b.Now many bracelets should be stocked? c.How many rings should be stocked? d.How many earrings should be stocked? e.How much space will be left unused?f. How much time will be used?g. By how much will the second marketing restriction be exceeded?

(Essay)
4.8/5
(30)

LINGO output is given for the following linear programming problem. MIN 12 X1 + 10 X2 + 9 X3 SUBJECT TO 2)5 X1 + 8 X2 + 5 X3 >= 60 3)8 X1 + 10 X2 + 5 X3 >= 80 END LP OPTIMUM FOUND AT STEP 1 OBJECTIVE FUNCTION VALUE 1)80.000000 VARIABLE VALUE REDUCED COST X1 .000000 4.000000 X2 8.000000 .000000 X3 .000000 4.000000 ROW SLACK OR SURPLUS DUAL PRICE 2) 4.000000 .000000 3) .000000 -1.000000 NO.ITERATIONS= 1 RANGES IN WHICH THE BASIS IS UNCHANGED:  OBJ. COEFFICIENT RANGES \quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\quad\text { OBJ. COEFFICIENT RANGES } X1 12.000000 INFINITY 4.000000 X2 10.000000 5.000000 10.000000 X3 9.000000 INFINITY 4.000000 RIGHTHAND SIDE RANGES CURRENT ALLOWABLE ALLOWABLE ROW RHS INCREASE DECREASE 2 60.000000 4.000000 INFINITY 3 80.000000 INFINITY 5.000000 a.What is the solution to the problem? b.Which constraints are binding? c.Interpret the reduced cost for x1. d.Interpret the dual price for constraint 2. e.What would happen if the cost of x1 dropped to 10 and the cost of x2 increased to 12?

(Essay)
4.8/5
(38)

The dual price associated with a constraint is the improvement in the value of the solution per unit decrease in the right-hand side of the constraint.

(True/False)
4.9/5
(35)

How is sensitivity analysis used in linear programming? Given an example of what type of questions that can be answered.

(Essay)
4.9/5
(26)

There is a dual price for every decision variable in a model.

(True/False)
4.8/5
(27)

Consider the following linear program: Min 6+9(\ cost ) s.t. +2\leq8 10+7.5\geq30 \geq2 ,\geq0 The Management Scientist provided the following solution output: OPTIMAL SOLUTION Objective Function Value = 27.000 Variable Value Reduced Cost X1 1.500 0.000 X2 2.000 0.000 Constraint Slack/Surplus Dual Price 1 2.500 0.000 2 0.000 -0.600 3 0.000 -4.500 OBJECTIVE COEFFICIENT RANGES Variable Lower Limit Current Value Upper Limit X1 0.000 6.000 12.000 X2 4.500 9.000 No Upper Limit RIGHT HAND SIDE RANGES Constraint Lower Limit Current Value Upper Limit 1 5.500 8.000 No Upper Limit 2 15.000 30.000 55.000 3 0.000 2.000 4.000 a.What is the optimal solution including the optimal value of the objective function? b.Suppose the unit cost of x1 is decreased to $4. Is the above solution still optimal? What is the value of the objective function when this unit cost is decreased to $4? c.How much can the unit cost of x2 be decreased without concern for the optimal solution changing? d.If simultaneously the cost of x1 was raised to $7.5 and the cost of x2 was reduced to $6, would the current solution still remain optimal? e.If the right-hand side of constraint 3 is increased by 1, what will be the effect on the optimal solution?

(Essay)
4.8/5
(33)

Sensitivity analysis information in computer output is based on the assumption of

(Multiple Choice)
5.0/5
(31)

An objective function reflects the relevant cost of labor hours used in production rather than treating them as a sunk cost.The correct interpretation of the dual price associated with the labor hours constraint is

(Multiple Choice)
4.8/5
(40)

The dual price for a percentage constraint provides a direct answer to questions about the effect of increases or decreases in that percentage.

(True/False)
4.9/5
(37)

When the right-hand sides of two constraints are each increased by one unit,the objective function value will be adjusted by the sum of the constraints' dual prices.

(True/False)
4.8/5
(36)

The binding constraints for this problem are the first and second. Min +2 s.t. +\geq300 2+\geq400 2+5\leq750 ,\geq0 a.Keeping c2 fixed at 2, over what range can c1 vary before there is a change in the optimal solution point? b.Keeping c1 fixed at 1, over what range can c2 vary before there is a change in the optimal solution point? c.If the objective function becomes Min 1.5x1 + 2x2, what will be the optimal values of x1, x2, and the objective function? d.If the objective function becomes Min 7x1 + 6x2, what constraints will be binding? e.Find the dual price for each constraint in the original problem.

(Essay)
4.8/5
(40)

For any constraint,either its slack/surplus value must be zero or its dual price must be zero.

(True/False)
4.8/5
(32)

Explain the two interpretations of dual prices based on the accounting assumptions made in calculating the objective function coefficients.

(Essay)
4.8/5
(35)

A section of output from The Management Scientist is shown here. Constraint Lower Limit Current Value Upper Limit 2 240 300 420 What will happen if the right-hand-side for constraint 2 increases by 200?

(Multiple Choice)
4.8/5
(28)

The 100% Rule does not imply that the optimal solution will necessarily change if the percentage exceeds 100%.

(True/False)
4.7/5
(34)

Given the following linear program: Max 5+7 s.t. \leq6 2+3\leq19 +\leq8 ,\geq0 The graphical solution to the problem is shown below.From the graph we see that the optimal solution occurs at x1 = 5,x2 = 3,and obj.func.= 46.  Given the following linear program:   \begin{array} { l r }  \operatorname { Max } & 5 x _ { 1 } + 7 x _ { 2 } \\ \text { s.t. }& x _ { 1 } \leq 6 \\  & 2 x _ { 1 } + 3 x _ { 2 } \leq 19 \\ & x _ { 1 } + x _ { 2 } \leq 8 \\ & x _ { 1 } , x _ { 2 } \geq 0 \end{array}   The graphical solution to the problem is shown below.From the graph we see that the optimal solution occurs at x<sub>1</sub> = 5,x<sub>2</sub> = 3,and obj.func.= 46.    a.Calculate the range of optimality for each objective function coefficient. b.Calculate the dual price for each resource. a.Calculate the range of optimality for each objective function coefficient. b.Calculate the dual price for each resource.

(Essay)
4.8/5
(40)
Showing 41 - 60 of 64
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)