Homework Answers
Answer:
Shadow price for space constraint = $1.6
Hence,
Increase in objective value if space constraint is increased by 5 units = $1.6*5 = $8
Option C is correct
Add Answer to:
5 pts Question 19 Hock Use the Excel Solver output for a Maximization LP problem to...
Figure 1 provides the Excel Sensitivity output for the following LP model. 10x1 + 8x2 Max...
Figure 1 provides the Excel Sensitivity output for the following LP model. 10x1 + 8x2 Max Z= subject to: 31 +2x2 < 24 2x1 + 4x2 = 12 -2x1 + 2 x2 56 X1, X2 > 0 Variable Cells Cell Name $B$13 Solution x1 $C$13 Solution x2 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 6 0 10 1E+30 0 -12 8 12 1E+30 6 Constraints Cell $D$6 $D$7 $D$8 Name C1 Totals C2 Totals C3 Totals Final...
Question 18 5 pts Answer the following question using the output below. Determine the new objective...
Question 18 5 pts Answer the following question using the output below. Determine the new objective function value for this output, if the number of units of tomato sauce were reduced by 100. Variable Cells Final Reduced Objective Allowable Allowable Name Value Cost Coefficient Increase Dtgrease 0.25 Hot Salsa 560 1 0.107 Mild Salsa 240 1.25 1.15 3.25 Constraints Final Shadow Constraint Allowable Allowable Name Value Price R.H. Side Increase Decrease whole Tomatoes 4480 0.125 4480 1120 160 Tomato Sauce...
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 Varia...
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...
X1=130 and X2=0, optimal profit 32,500 Using the solver report and the sensitivity report answer the...
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...
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 value...
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...
Question 20 Answer the following question using the output below. What are the binding constraints? Variable...
Question 20 Answer the following question using the output below. What are the binding constraints? Variable Cells Final Reduced Objective Allowable Allowable Name Value Cost Coefficient Increase Decrease Hot Salsa 5600 0.25 0.107 Mild Salsa 1.25 1.15 3.25 240 Constraints Final Shadow Name Value Price Whole Tomatoes 4180 0.125 Tomato Sauce 19200 Tomato Paste 1600 0.188 Constraint Allowable Allowable R.H. Side Increase Decrease 4480 1120 160 2080 1E+30 1600 40 320 160 Whole tomatoes Tomatopiste All of the constraints are...
(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 Repo...
(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...
D 12.5 pts Question 7 Quality Bike Maps has produced four map designs for the local...
D 12.5 pts Question 7 Quality Bike Maps has produced four map designs for the local area. A limited amount of time (in minutes) is allocated to the printing, cutting and folding of each map. Additionally, at least one thousand of map designs A, B, and C must be printed. The profit per map is $1 for A and B and $2 for C and D. Using the Report below, which constraints are NOT binding? Variable Cells Reduced Objective Allowable...
a. What is the optimal solution in lay terms? What is the optimal value of the...
a. What is the optimal solution
in lay terms? What is the optimal value of the objective
function?
b. Which constraints are binding? Explain.
c. What are the shadow prices of demand for B constraint and
assembly time constraints? Interpret each.
d. If you could change the right-hand side of one constraint by
one unit (either increase or decrease), which one would you choose?
Why? Show all calculations.
e. State and interpret the ranges of optimality for any one of...
Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$6 Activity...
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...
Figure 1 provides the Excel Sensitivity output for the following LP model. 10x1 + 8x2 Max Z= subject to: 31 +2x2 < 24 2x1 + 4x2 = 12 -2x1 + 2 x2 56 X1, X2 > 0 Variable Cells Cell Name $B$13 Solution x1 $C$13 Solution x2 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 6 0 10 1E+30 0 -12 8 12 1E+30 6 Constraints Cell $D$6 $D$7 $D$8 Name C1 Totals C2 Totals C3 Totals Final...
Question 18 5 pts Answer the following question using the output below. Determine the new objective function value for this output, if the number of units of tomato sauce were reduced by 100. Variable Cells Final Reduced Objective Allowable Allowable Name Value Cost Coefficient Increase Dtgrease 0.25 Hot Salsa 560 1 0.107 Mild Salsa 240 1.25 1.15 3.25 Constraints Final Shadow Constraint Allowable Allowable Name Value Price R.H. Side Increase Decrease whole Tomatoes 4480 0.125 4480 1120 160 Tomato Sauce...
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...
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...
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...
Question 20 Answer the following question using the output below. What are the binding constraints? Variable Cells Final Reduced Objective Allowable Allowable Name Value Cost Coefficient Increase Decrease Hot Salsa 5600 0.25 0.107 Mild Salsa 1.25 1.15 3.25 240 Constraints Final Shadow Name Value Price Whole Tomatoes 4180 0.125 Tomato Sauce 19200 Tomato Paste 1600 0.188 Constraint Allowable Allowable R.H. Side Increase Decrease 4480 1120 160 2080 1E+30 1600 40 320 160 Whole tomatoes Tomatopiste All of the constraints are...
(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...
D 12.5 pts Question 7 Quality Bike Maps has produced four map designs for the local area. A limited amount of time (in minutes) is allocated to the printing, cutting and folding of each map. Additionally, at least one thousand of map designs A, B, and C must be printed. The profit per map is $1 for A and B and $2 for C and D. Using the Report below, which constraints are NOT binding? Variable Cells Reduced Objective Allowable...
a. What is the optimal solution
in lay terms? What is the optimal value of the objective
function?
b. Which constraints are binding? Explain.
c. What are the shadow prices of demand for B constraint and
assembly time constraints? Interpret each.
d. If you could change the right-hand side of one constraint by
one unit (either increase or decrease), which one would you choose?
Why? Show all calculations.
e. State and interpret the ranges of optimality for any one of...
Most questions answered within 3 hours.
-
Our ability to see distinct edges as well as our errors in
contrast perceptions (e.g., seeing...
asked 57 seconds ago -
you want to measure the gravitational acceleration at your
location. since g does not vary significantly...
asked 14 minutes ago -
Aside from commercial tools that are specifically geared toward
TAR/PC( Technology-Assisted Review), are there potential
alternative...
asked 16 minutes ago -
A woman expends 94 kJ of energy in walking a kilometer. The
energy is supplied by...
asked 9 minutes ago -
the period of a pendulum on earth is 5 seconds. what will be the
period of...
asked 32 minutes ago -
The
act of turning media against itself, such as flash mobs and
billboard is called
a....
asked 28 minutes ago -
A set of length measurements are obtained with the values 165.6
± 0.3, 165.1± 0.4,166.4± 1.0,...
asked 30 minutes ago -
Vertical Analysis
Income statement information for Einsworth Corporation
follows:
Sales
$237,000
Cost of goods sold
78,210...
asked 36 minutes ago -
A simple random sample was taken to test the claim that the
population mean is no...
asked 31 minutes ago -
Overview
JAVA LANGUAGE PROBLEM:
The owner of a restaurant wants a program to manage online
orders...
asked 36 minutes ago -
1- What is “progressive production?”
2- Where did the assembly line originate? (Name the industry)
3....
asked 34 minutes ago -
NPV
Project L costs $60,000 it’s expected cash inflows are $13,000
per year for 10 years,...
asked 39 minutes ago