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
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
This file has been shared publicly by a user of PDF Archive.
Document ID: 0000103909.