You are the plant engineer and the plant manager has asked you to do an analysis of the utility bills...

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:

(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 and Totals row (the fields in yellow).

(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 and Totals row (the fields in yellow).

(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, Water $/CGAL column, Sewage $/CGAL column, and Totals row (the fields in yellow).