Optimization Modeling (PDF)




File information


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.87 KB (1 page).
Privacy: public file




Document preview - Optimization Modeling.pdf - Page 1/1





File 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.






Download Optimization Modeling



Optimization Modeling.pdf (PDF, 43.87 KB)


Download PDF







Share this file on social networks



     





Link to this page



Permanent link

Use the permanent link to the download page to share your document on Facebook, Twitter, LinkedIn, or directly with a contact by e-Mail, Messenger, Whatsapp, Line..




Short link

Use the short link to share your document on Twitter or by text message (SMS)




HTML Code

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




QR Code to this page


QR Code link to PDF file Optimization Modeling.pdf






This file has been shared publicly by a user of PDF Archive.
Document ID: 0000103909.
Report illicit content