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).
Your assignment: Enter the three tables above in an Excel spreadsheet, place them on the first worksheet and label the worksheet Bills. Create three additional worksheets, labeled Electric, Gas, and Water. On each of those worksheets, link (not cut and paste) the related information from the first worksheet to a table on the appropriately labeled worksheet and then create a chart to illustrate the information graphically. Make sure that your charts are labeled with a title and legends for the x and y-axis. Use three different types of charts (1 chart for each page). Your goal is to make the information look presentable. Each student is responsible for submitting their own unique Excel spreadsheet.
Formatting:
Text Size: All of the main text in this assignment needs to be set in 10 or 12-point size. Please resist the temptation to mix and match point sizes. If you doubt your applications intentions, just select all of your text and insure that it is in 10 or 12-point size. Your titles, legends and labels can be different sizes.
Name Block: Place the name block in the upper left corner of the page. In MS Excel, use the left side cells. In this class, the name block only needs to be on the first page/first worksheet. Put your name first, then the class title and then the due date.
Title: All homework assignments have a title. For all Excel-based assignments, skip one cell and place the title on the left, just below the name block. The title for this assignment is “Homework 2”.
Spelling/Grammar Checking: Remember to do your spelling and grammar checking before turning your assignments in. When doing the spelling/grammar checking keep in mind that some words such as mush and must, woods and words, or here and cow, will not be caught by either check. To correct these problems, you will need to proofread your work.
Saving/Naming Your File:
When you save your file make sure that your name, the class number, and the project number are included in it.
Example: YourName403HW3
0 comments