Question: The following is the sensitivity report for a maximization problem. If the company can increase the available hours for one of their constraints by two

The following is the sensitivity report for a maximization problem. If the company can increase the available hours for one of their constraints by two hours, which constraint the should increase?

MAX 50R + 75S

s.t.

1.2 R + 1.6 S 600 assembly (hours)

0.8 R + 0.5 S 300 paint (hours)

.16 R + 0.4 S 100 inspection (hours)

Sensitivity Report:

Cell

Name

Final

Value

Reduced

Cost

Objective

Coefficient

Allowable

Increase

Allowable

Decrease

$B$7

Regular =

291.67

0.00

50

70

20

$C$7

Super =

133.33

0.00

75

50

43.75

Cell

Name

Final

Value

Shadow

Price

Constraint

R.H. Side

Allowable

Increase

Allowable

Decrease

$E$3

Assembly (hr/unit)

563.33

0.00

600

1E+30

36.67

$E$4

Paint (hr/unit)

300.00

33.33

300

39.29

175

$E$5

Inspect (hr/unit)

100.00

145.83

100

12.94

40

Select one:

a.

Paint

b.

Inspect

c.

Assembly

d.

Paint or Inspect

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!