Question: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease Type A x 6 0 5 4 3 Type B y

Variable Cells

Final

Reduced

Objective

Allowable

Allowable

Cell

Name

Value

Cost

Coefficient

Increase

Decrease

Type A

x

6

0

5

4

3

Type B

y

2

0

7

3

3

Type C

z

0

-3.5

4

1E+30

8

Constraints

Final

Shadow

Constraint

Allowable

Allowable

Cell

Name

Value

Price

R.H. Side

Increase

Decrease

Wood

1

32

1.5

32

20

10

Steel

2

40

2.5

30

45

30

hours

3

15

0

38

1E+30

25

a) What is the expected profit if the coefficient of x changes to 8?

b) Calculate the optimal value of the objective function If the coefficient of x changes to 7 and the coefficient of y changes to 9 simultaneously. Explain your answer.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

The table below contains data on the monthly amount, in millions of dollars, which was spent by "leading national advertisers" for advertising apparel and accessories in magazines, in four recent...

Q:

We are making four products ( P 1 - P 4 ) . Objective function coefficients are profit per unit for each product. Constraints are the amount of labor available, raw materials ( 1 , 2 and 3 ) and...

Q:

The sensitivity report provided below was generated using Excel Solver to determine the optimal solution to a linear program. Using the sensitivity report, answer questions 11-17. Variable Cells...

Q:

Given results after developing the excel LP and so 10 minutes on slide Remove Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease Type A x 15...

Q:

Consider the following sensitivity report: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$ 5 # 2 0 7 0 1 0 4 0 $D$ 5 # 4 0 3 0 5 3 5...

Q:

Question 2 (40pts) Figure 1 provides the Excel Sensitivity output for the following LP model. Max Z= 10x, + 8x subject to: 3, +2x 0 Variable Cells Final Reduced Objective Allowable Allowable Cell...

Q:

A winemaker in California's Napa Valley must decide how much of two types of wine she will produce from a particular variety of grapes. Each liter of table wine yields $8 profit, while each liter of...

Q:

Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SSS Number to Make Chair 230 240 230 16 + 30 5CBS Number to Make Table 720 5035 Number to...

Q:

Jones Furniture Company produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hour of varnishing. Each...

Q:

Assuming all other parameters remain unchanged, if the objective function coefficient associated with Large Rooms increases by $15, what will be the change in the objective function? O A. increases...

Q:

Adobe encourages PC users to download its Acrobat Reader and Flash Player free of charge. How does this eventually help Adobe strategically? If they give the application away, how does their...

Q:

A block of wood A of mass 10 kg is held on a rough horizontal table. An elastic string connected to the block passes over a smooth pulley at the end of the table and then under a second smooth pulley...

Q:

Intangible assets are not listed on the balance sheet because they do not have physical substance. True False

Q:

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...