Question: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$3 Number to make P1 36.7142 0.0000 50.0000 11.5335 15.3129 $C$3

Variable Cells

Final

Reduced

Objective

Allowable

Allowable

Cell

Name

Value

Cost

Coefficient

Increase

Decrease

$B$3

Number to make P1

36.7142

0.0000

50.0000

11.5335

15.3129

$C$3

Number to make P2

58.6371

0.0000

58.0000

13.2315

14.9192

$D$3

Number to make P3

0.0000

-19.4686

46

19.4686

1E+30

$E$3

Number to make P4

63.5675

0.0000

62

1E+30

6.3795

Constraints

Final

Shadow

Constraint

Allowable

Allowable

Cell

Name

Value

Price

R.H. Side

Increase

Decrease

$F$11

Labour Used

3488.5543

0.0000

3600

1E+30

111.4457

$F$12

Machine hours Used

1700.0000

2.6008

1700

61.4764

336.3636

$F$13

Management

-7.10543E-15

6.2907

0

20.1320

64.4643

$F$7

Cloth Used

600.0000

7.9275

600

148.0000

70.9184

$F$8

Starch Used

350.3346

0.0000

500

1E+30

149.6654

Use the sensitivity report to answer the following questions.

a) How many units of each product are to be produced?

b) What is the value of the objective function corresponding to your answer in (a) above?

c) How many hours of labour effort should be allocated to each product?

d) How many pounds of cloth should be allocated to each product?

e) Why do three of the products have zero reduced cost?

f) What is the minimum profit for product 3 to enable the company produce some of it?

g) Which constraints are binding?

h) Which constraints are not binding?

i) What is the effect on the objective function value if the pounds of cloth are increased by 120?

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!