Scribd
Upload
46 views5 pages

Cell Name Original Value Final Value

The document contains the results of a linear programming optimization performed in Microsoft Excel. The objective was to maximize profits up to $11 million. The optimal solution was found after 3 iterations in 0.016 seconds, with variables M101 at 2000 and M102 at 1000. All constraints were satisfied, with the first two binding and the second two not binding but still within limits.

Uploaded by

Subhranil Baksi
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
46 views5 pages

Cell Name Original Value Final Value

The document contains the results of a linear programming optimization performed in Microsoft Excel. The objective was to maximize profits up to $11 million. The optimal solution was found after 3 iterations in 0.016 seconds, with variables M101 at 2000 and M102 at 1000. All constraints were satisfied, with the first two binding and the second two not binding but still within limits.

Uploaded by

Subhranil Baksi
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
You are on page 1/ 5

Microsoft Excel 16.

0 Answer Report
Worksheet: [merton_trck_iqdm.xlsx]Sheet1
Report Created: 11/9/2019 12:32:38 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.016 Seconds.
Iterations: 3 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative

Objective Cell (Max)


Cell Name Original Value Final Value
$H$4 11000000 11000000

Variable Cells
Cell Name Original Value Final Value Integer
$F$10M101 2000 2000 Contin
$G$10M102 1000 1000 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$H$5 4000 $H$5<=$J$5 Binding 0
$H$6 6000 $H$6<=$J$6 Binding 0
$H$7 4000 $H$7<=$J$7 Not Binding 1000
$H$8 3000 $H$8<=$J$8 Not Binding 1500
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [merton_trck_iqdm.xlsx]Sheet1
Report Created: 11/9/2019 12:32:39 AM

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$F$10 M101 2000 0 3000 2000 500
$G$10 M102 1000 0 5000 1000 2000

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$H$5 4000 2000 4000 500 500
$H$6 6000 500 6000 500 1000
$H$7 4000 0 5000 1E+030 1000
$H$8 3000 0 4500 1E+030 1500
Microsoft Excel 16.0 Limits Report
Worksheet: [merton_trck_iqdm.xlsx]Sheet1
Report Created: 11/9/2019 12:32:39 AM

Objective
Cell Name Value
$H$4 11000000

Variable Lower Objective Upper Objective


Cell Name Value Limit Result Limit Result
$F$10 M101 2000 0 5000000 2000 11000000
$G$10 M102 1000 0 6000000 1000 11000000
M101 M102
3000 5000 11000000
1 2 4000 <= 4000
2 2 6000 <= 6000
2 0 4000 <= 5000
0 3 3000 <= 4500

2000 1000
M101 M102
S.p 39000 38000
Lab. Cost 4000 4500
Dir. Mat 24000 20000
Var. Ohead 8000 8500
Contribution 3000 5000

You might also like