# Optimization Modeling .pdf

### File information

Original filename: Optimization Modeling.pdf
Author: Kevin Fingerman

This PDF 1.3 document has been generated by Apple Numbers 2.1 / Mac OS X 10.6.8 Quartz PDFContext, and has been sent on pdf-archive.com on 09/05/2013 at 12:46, from IP address 108.244.x.x. The current document download page has been viewed 1085 times.
File size: 43 KB (1 page).
Privacy: public file

Optimization Modeling.pdf (PDF, 43 KB)

### Document preview

Power Plant Fuel Management
Part 1
Fuel
Coal 1
Coal 2
Coal 3

Fraction
Sulfur (ppm)
0.0579710128
1100
0.5507246362
3500
0.3913043509
1300

PM(kg/T)
1.7
3.2
2.4

Pounds of Steam
24000
36000
28000

W/out Scrubbers
Objective Cell
Variable Cells
Constraint Cells
W/Scrubbers

Constraints
Fraction
Sulfur (ppm)
PM(kg/T)

Used
1
2499.9999971
2.8

Max

Total Steam
32173.9130385132

1
2500
2.8

Objective Cell
Variable Cells
Constraint Cells

Part 2
Fuel
Coal 1
Coal 2
Coal 3

\$ w/out scrubbers
\$ w/scrubbers
Fraction
Sulfur (ppm)
PM(kg/T)

Fraction
Sulfur (ppm)
0
1100
0.8295454545
3500
0.1704545455
1300

PM(kg/T)
1.7
3.2
2.4

Pounds of Steam
24000
36000
28000

\$/T
95
83
91

\$
84.363636364
85.863636364
1
2500
2.4509090909

Total Steam
34636.3636363636
1
2500
2.8
Part 1 of this excel sheet uses optimization
modeling to find the ideal fractions of 3
different types of coal to maximize profit,
while staying in compliance with pollution
constraints.
Part 2 uses optimization modeling to
analyze whether or not it would be worth it
to invest in scrubbers that would reduce
pollutants by 20% for an extra \$1.50 per ton
of coal. An analysis of the results determines
that it is cost effective to instal the
scrubbers.

### Related documents

#### HTML Code

Copy the following HTML code to share your document on a Website or Blog