Question: Consider the following linear program, which maximizes profit for two products--regular (R) and super (S): MAX 40R + 75S s.t. 1.6 R + 1.7 S

Consider the following linear program, which maximizes profit for two products--regular (R) and super (S):

MAX 40R + 75S

s.t.

1.6 R + 1.7 S 600 assembly (hours)

0.9 R + 0.4 S 300 paint (hours)

.18 R + 0.5 S 100 inspection (hours)

Sensitivity Report:

Cell

Name

Final

Value

Reduced

Cost

Objective

Coefficient

Allowable

Increase

Allowable

Decrease

$B$7

Regular =

???

0.00

40

30.58

13

$C$7

Super =

???

0.00

75

36.11

32.5

Cell

Name

Final

Value

Shadow

Price

Constraint

R.H. Side

Allowable

Increase

Allowable

Decrease

$E$3

Assembly (hr/unit)

600

13.16

600

27.51

260

$E$4

Paint (hr/unit)

278.94

0

300

1E+30

21.05

$E$5

Inspect (hr/unit)

100.00

105.26

100

76.47

11.68

19) The optimal number of regular products to produce is ________, and the optimal number of super products to produce is ________, for total profits of ___________.

Answer:

20) If the company wanted to increase the available hours for one of their constraints (assembly, painting, or inspection) by two hours, they should increase ________.

Answer: ___________

21) The profit on the super product could increase by ________ without affecting the product mix.

Answer: ___________________

22) If downtime reduced the available capacity for inspecting by 40 hours (from 100 to 60 hours), profits would be reduced by ________.

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!