USA: +1(669)289-8683 
Sign in
Assignment:
You are the plant engineer and the plant manager has asked you to do an analysis of the utility bills and make a presentable report from the information. The data is required to evaluate cost saving improvements you are considering for the plant by improving energy and water usage:
|
ELECTRIC |
Use |
Demand |
TOTAL |
KWH |
|||||||||||||||||||||||||||||||||||||||||
|
JAN |
2008 |
208,120 |
$6,565 |
798 |
$6,464 |
$13,029 |
|||||||||||||||||||||||||||||||||||||||
|
FEB |
302,400 |
$10,121 |
819 |
$6,634 |
$16,755 |
||||||||||||||||||||||||||||||||||||||||
|
MAR |
273,000 |
$10, |
374 |
756 |
$6,124 |
$16,498 |
|||||||||||||||||||||||||||||||||||||||
|
APR |
193,200 |
$8,767 |
651 |
$5,273 |
$14,040 |
||||||||||||||||||||||||||||||||||||||||
|
MAY |
291,100 |
$10,377 |
546 |
$4,423 |
$14,800 |
||||||||||||||||||||||||||||||||||||||||
|
JUN |
391,100 |
$10,238 |
525 |
$4,262 |
$14,500 |
||||||||||||||||||||||||||||||||||||||||
|
JUL |
296,100 |
$13,575 |
735 |
$7,445 |
$21,020 |
||||||||||||||||||||||||||||||||||||||||
|
AUG |
407,400 |
$16,902 |
$8,091 |
$24,993 |
|||||||||||||||||||||||||||||||||||||||||
|
SEP |
420,000 |
$18,574 |
$8,025 |
$26,599 |
|||||||||||||||||||||||||||||||||||||||||
|
OCT |
348,600 |
$17,613 |
$7,634 |
$25,247 |
|||||||||||||||||||||||||||||||||||||||||
|
NOV |
199,500 |
$9,739 |
588 |
$4,663 |
$14,402 |
||||||||||||||||||||||||||||||||||||||||
|
DEC |
239,400 |
672 |
$5,269 |
$15,390 |
|||||||||||||||||||||||||||||||||||||||||
|
TOTALS |
3,569,920 |
$142,966 |
8,442 |
$74,307 |
$217,273 |
(Note: the dollar information on this table is set to the dollar value, no cents)
-When you enter this table into your spreadsheet, you will need to enter formulas for the Total $ column (Yellow) and Totals row (Green).
|
NATURAL GAS |
MMBTU |
Cost $ |
|
|
189 |
$1,218.00 |
$6.44 |
|
|
215 |
$1,297.00 |
$6.03 |
|
|
$412.00 |
$5.80 |
||
|
$142.00 |
$7.89 |
||
|
$22.00 |
$11.00 |
||
|
$44.00 |
|||
|
$14.67 |
|||
|
$601.00 |
$10.36 |
||
| $ |
820 |
$10.79 |
|
|
$940.00 |
$11.19 |
||
|
726 |
$5,628.00 |
$7.75 |
(Note: the dollar information on this table is set to the cents value)
-When you enter this table into your spreadsheet, you will need to enter formulas for the
$/MMBTU
column (yellow) and Totals row (green).
|
WATER |
SEWAGE |
Cubic |
$/CGAL |
|||||||||||||
|
Gallons |
||||||||||||||||
|
$59.00 |
$64.00 |
$123.00 |
$0.16 |
$0.17 |
||||||||||||
|
432 |
$67.00 |
$73.00 |
$140.00 |
|||||||||||||
|
640 |
$86.00 |
$106.00 |
$192.00 |
$0.13 |
||||||||||||
|
1,079 |
$144.00 |
$179.00 |
$323.00 |
|||||||||||||
|
1,148 |
$154.00 |
$346.00 |
||||||||||||||
|
729 |
$98.00 |
$122.00 |
$220.00 |
|||||||||||||
|
$110.00 |
$137.00 |
$247.00 |
||||||||||||||
|
$68.00 |
$77.00 |
$145.00 |
$0.11 |
$0.12 |
||||||||||||
|
540 |
$78.00 |
$91.00 |
$169.00 |
$0.14 |
||||||||||||
|
720 |
$120.00 |
$218.00 |
||||||||||||||
|
990 |
$129.00 |
$165.00 |
$294.00 |
|||||||||||||
|
850 |
$113.00 |
$255.00 |
||||||||||||||
|
8,962 |
$1,204.00 |
$1,468.00 |
$2,672.00 |
(Note: the dollar information on this table is set to the cents value)
-When you enter this table into your spreadsheet, you will need to enter formulas for the Total $ column (yellow), Water $/CGAL column (light blue), Sewage $/CGAL column (grey), and Totals row (green).
