1.)Use the Excel Solver output for a LP problem whose objective was to maximize profits, to determine by how much the right-hand side of the labor constraint can increase before it becomes necessary to recalculate the linear program.

Objective Function Value = 26.40

2.) Variable Cells

Final

Reduced

Objective

Allowable

Allowable

Name

Value

Cost

Coefficient

Increase

Decrease

Variable1

2.4

0

5

4

1

Variable2

2.4

0

6

1.5

2.67

Constraints

Final

Shadow

Constraint

Allowable

Allowable

Name

Value

Price

R.H. Side

Increase

Decrease

Labor

12

0.6

12

3

3

Wood

6.4

0

14

7.6

1E+30

Space

12

1.6

12

6

1.8

Limit

3.2

0

10

6.8

1E+30

a.)

9

b.)

6

c.)

12

d.)

2.5