Scribd
Upload
11 views6 pages

Excel 16.0 Sensitivity Analysis Report

This document summarizes the results of a linear programming sensitivity analysis. It lists the final values and reduced costs of variable cells, objective coefficients, constraint right-hand sides and shadow prices. The analysis found the optimal solution that maximizes profit is to produce 7000 units of LQP and 3000 units of DMP, with total profit of $8,500,000.

Uploaded by

swethakamath93
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
11 views6 pages

Excel 16.0 Sensitivity Analysis Report

This document summarizes the results of a linear programming sensitivity analysis. It lists the final values and reduced costs of variable cells, objective coefficients, constraint right-hand sides and shadow prices. The analysis found the optimal solution that maximizes profit is to produce 7000 units of LQP and 3000 units of DMP, with total profit of $8,500,000.

Uploaded by

swethakamath93
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Microsoft Excel 16.

0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 18/10/2016 15:53:07

Variable Cells
Final
Cell Name
Value
$B$7
0
$C$7
0.25
$D$7
0.25
$E$7
0
$F$7
0.5
$G$7
0
$H$7
8.67362E-019

Reduced
Cost
0
0
0
8.5
0
11.5
0

Objective
Allowable
Allowable
Coefficient
Increase
Decrease
38 1.00000E+030
0
43
0 12.545454545
35
0 1.00000E+030
48 1.00000E+030
8.5
40
0 1.00000E+030
45 1.00000E+030
11.5
48 1.00000E+030 1.00000E+030

Constraints
Cell Name
$I$4 LEAD
$I$5 ZINC
$I$6 TIN
$I$7

Final
Value
0.35
0.3
0.35
1

Shadow
Constraint
Allowable
Allowable
Price
R.H. Side
Increase
Decrease
50.317460317
0.35 0.0498561151 3.00541E-017
0.3174603175
0.3
17.325 3.00541E-017
20.317460317
0.35 0.0747841727 3.00541E-017
14.682539683
1 3.00541E-017 0.1241045845

ALLOY
LEAD
ZINC
TIN
COST/KG

Cost

0.3
0.3
0.4
0.00
38

0.4
0.2
0.4
0.25
43

0.2
0.3
0.5
0.25
35

0.35
0.3
0.35
0.00
48

0.4
0.35
0.25
0.50
40

0.25
0.45
0.3
0.00
45

0.3
35
0.35
0.00
48

39.5

0.35
0.3
0.35
1

0.35
0.3
0.35

Microsoft Excel 16.0 Sensitivity Report


Worksheet: [OR formulation [Link]]Sheet4
Report Created: 18/10/2016 18:01:25

Variable Cells
Cell
$B$2 LQP
$C$2 DMP

Name

Final Reduced Objective


Value
Cost
Coefficient
7000
0
1000
3000
0
500

Constraints
Cell
Name
$D$4 Labour (hrs) Labour hours required
$D$5 Clean room (hrs) Labour hours required
$D$6 Testing room (hrs) Labour hours required

Final Shadow Constraint


Value
Price
R.H. Side
10000
250
10000
13000
0
16000
24000
250
24000

Allowable
Allowable
Increase
Decrease
500
500
500 166.66666667

Allowable
Increase
1200
1.000E+030
6000

Allowable
Decrease
2000
3000
6000

LQP

DMP
7000

Labour (hrs)
Clean room (hrs)
Testing room (hrs)

1
1
3
1000

Profit

8500000

3000
Labour hours requiredAvailability
1
10000
10000
2
13000
16000
1
24000
24000
500

You might also like