Scribd
Upload
4 views4 pages

Excel Minimization Problem Report

The document contains an Excel report that solved an optimization problem to minimize waste released into a river by 3 factories. It summarizes that the optimized amounts of waste treated by each factory are: Factory 1: 7.69 tons, Factory 2: 146.15 tons, Factory 3: 0 tons, for a total treated waste of 153.85 tons at a cost of $1,576.92. It also lists the adjustable cells, constraints, and reporting on sensitivity and limits.

Uploaded by

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

Excel Minimization Problem Report

The document contains an Excel report that solved an optimization problem to minimize waste released into a river by 3 factories. It summarizes that the optimized amounts of waste treated by each factory are: Factory 1: 7.69 tons, Factory 2: 146.15 tons, Factory 3: 0 tons, for a total treated waste of 153.85 tons at a cost of $1,576.92. It also lists the adjustable cells, constraints, and reporting on sensitivity and limits.

Uploaded by

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

Microsoft Excel 10.

0 Answer Report
Worksheet: [question [Link]]Sheet1
Report Created: 28/03/03 [Link] PM

Target Cell (Min)


Cell Name Original Value Final Value
$G$4 USED 0 1576.923077

Adjustable Cells
Cell Name Original Value Final Value
$C$3 Minimization problem x1 0 7.692307692
$D$3 Minimization problem x2 0 146.1538462
$E$3 Minimization problem x3 0 0

Constraints
Cell Name Cell Value Formula Status Slack
$G$5 ≥ USED 30 $G$5>=$H$5 Binding 0
$G$6 ≥ USED 40 $G$6>=$H$6 Binding 0
Microsoft Excel 10.0 Sensitivity Report
Worksheet: [question [Link]]Sheet1
Report Created: 28/03/03 [Link] PM

Adjustable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$C$3 Minimization problem x1 7.692307692 0 15 3 10
$D$3 Minimization problem x2 146.1538462 0 10 2.666666667 1.666666667
$E$3 Minimization problem x3 0 6.153846154 20 1E+030 6.153846154

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$G$5 ≥ USED 30 11.53846154 30 2 21.11111111
$G$6 ≥ USED 40 30.76923077 40 95 2.5
Microsoft Excel 10.0 Limits Report
Worksheet: [question [Link]]Limits Report 1
Report Created: 28/03/03 [Link] PM

Target
Cell Name Value
$G$4 USED 1576.923077

Adjustable Lower Target Upper Target


Cell Name Value Limit Result Limit Result
$C$3 Minimization problem x1 7.692307692 7.692307692 1576.923077 #N/A #N/A
$D$3 Minimization problem x2 146.1538462 146.1538462 1576.923077 #N/A #N/A
$E$3 Minimization problem x3 0 0 1576.923077 #N/A #N/A
xi = no. of tons of waste released in Moniss River by factory i

x1 x2 x3
Minimization problem 7.69 146.15 0.00 USED RHS
Cost of Treatment 15 10 20 1576.92
(Pollutant 1 constraint) 0.1 0.2 0.4 ≥ 30 30
(Pollutant 2 constraint) 0.45 0.25 0.3 ≥ 40 40

Changing cells
Target cells
Constraint eqns

Therefore, the amount of waste treated at factory 1 is 7.69


The amount of waste treated at factory 2 is 146.15
The amount of waste treated at factory 3 is 0
Total waste treated 153.85
Cost of treating waste $1,576.92

You might also like