Question

Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$2 DVs...

Variable Cells

Final

Reduced

Objective

Allowable

Allowable

Cell

Name

Value

Cost

Coefficient

Increase

Decrease

$B$2

DVs Standard

0

0

25

7.5

17.77777778

$C$2

DVs Deluxe

20

0

65

160

15

Constraints

Final

Shadow

Constraint

Allowable

Allowable

Cell

Name

Value

Price

R.H. Side

Increase

Decrease

$D$4

Standard Leather

0

0

210

1E+30

210

$D$5

Premium leather

180

2.142857143

180

0

105

$D$6

Cutting and Sewing

80

0

120

1E+30

40

$D$7

Finishing

40

22.85714286

40

12.17391304

0

Consider the RHS sensitivity analysis in above.

  1. Suppose the amount of premium leather decreases from 180 to 150

  1. Does the shadow price change? Why or why not?

  1. If possible, determine the change in value of the objective function in this situation.
  1. Does the optimal solution change? Explain why or why not.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Here's a portion of the sensitivity analysis for the constraints. Answer the following questions. Cell Name...
Here's a portion of the sensitivity analysis for the constraints. Answer the following questions. Cell Name Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease $E$10 Bar/Food 0 1560 0 5 16 $E$11 Budget 150000 3.4 150000 1E+30 96200 $E$6 Excursions 24.24 0 5 19.24 1E+30 $E$7 Restaurant 12 -1660 12 16 What happens to the optimal solution if you can get more budget? How much more of the budget can you get? [10 Marks] What happens to...
Based on the following sensitivity report, what would be the change in the objective function value...
Based on the following sensitivity report, what would be the change in the objective function value if the objective function coefficient for Product_2 increases to 19? Cell $B$3 Name Product_2    Final Value 175 Reduced Cost 0   Objective Coefficient 14 Allowable Increase 9 Allowable Decrease 1
Question 6 (6 marks):In the following Excel Solver sensitivity report, some values are missing as shown...
Question 6 :In the following Excel Solver sensitivity report, some values are missing as shown below.    Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$17 lbs used A1 (whole) 525000 j? 0.006667 1E+30 0.0148889 $C$17 lbs used A2 (juice) 75000 -0.0045 0.0148889 1E+30 $D$17 lbs used A3 (paste) k? -0.02233 0.0048 l? $E$17 lbs used B1 (whole) 175000 0.006667 1E+30 0.0148889 $F$17 lbs used B2 (juice) 225000 -0.0045 0.0132296 1E+30 $G$17 lbs used...
Spencer Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish...
Spencer Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. These departments have 360 hours, 200 hours, and 125 hours of labor available each week. The firm has a contract with a distributor to produce a minimum of 300 of each cabinet per week (or 60 cabinets per day). An analyst had been consulted to determine a product mix to...
!!!PLEASE PROVIDE GRAPHS!!! 1. Suppose a small company is in the business of making golf bags...
!!!PLEASE PROVIDE GRAPHS!!! 1. Suppose a small company is in the business of making golf bags to be sold at a local golf course where state championships are often held. They make 2 types of golf bags, a standard bag and a deluxe bag. The table below gives the information for limitations of materials and labor hours, and also for the profit for each type of bag. The materials and labor hours are the amount available per week, and the...
A factory produces canoes, dinghies, speedboats and catamarans. The resources required are steel, fibreglass, wood and...
A factory produces canoes, dinghies, speedboats and catamarans. The resources required are steel, fibreglass, wood and marine paint. The following table shows the per-unit resource quantities required for each product, the price we sell each product for, the per-unit resource prices, and the resource quantities available to us for purchase: Products Resources Selling price steel fibreglass wood marine paint canoes 0.000 27.000 1.000 7.000 $381.80 dinghies 15.000 4.000 2.500 2.100 $153.10 speedboats 36.000 4.000 1.000 2.300 $220.60 catamarans 11.000 64.000...
A factory produces cakes, pies, rolls and danishes. The resources required are flour, sugar, meat and...
A factory produces cakes, pies, rolls and danishes. The resources required are flour, sugar, meat and fruit. The following table shows the per-unit resource quantities required for each product, the price we sell each product for, the per-unit resource prices, and the resource quantities available to us for purchase: Products Resources Selling price flour sugar meat fruit cakes 0.500 0.900 0.000 0.100 $8.40 pies 0.430 0.090 0.500 0.000 $20.21 rolls 0.250 0.015 0.000 0.000 $1.45 danishes 0.180 0.290 0.000 0.050...
Find solutions for your homework or get textbooks home / study / business / operations management...
Find solutions for your homework or get textbooks home / study / business / operations management / operations management questions and answers / partial of the excel solver sensitivity report for the lp model in problem (3) is provided ... Question: Partial of the Excel Solver Sensitivity Report for the LP model in Problem (3) is provided b... Edit question Partial of the Excel Solver Sensitivity Report for the LP model in Problem (3) is provided below. Microsoft Excel 16.0...