MTH 154: Project - Yearly Budget

Project Directions:
Construct a budget sheet that assists you in analyzing your financial status, set goals, make changes, whatever the case may be. This
project will have more meaning to you the more it reflects your real life. You can use this to create a budget for your future life based
on your plans of a future job, future housing, expenses, etc. I assure you that, should you choose to include personal values, I will be
assessing your work only on if it was accurately represented and interpreted. Please work to be realistic so you can gain from the
experience. There will never be any judgement made on my part nor any information shared out.
Your sheet should address both regular and unexpected monthly expenses, necessities and luxuries, and any debts/savings plans. Your
first sheet should create a baseline budget of your expenses (list what you spend/think you will spend each month for each category
without regard to if you balance) and then create monthly and yearly budget as well as totals by category. You should have a
minimum of 10 to 15 categories with amounts for each month as well as monthly and yearly totals. Your second sheet should be
a tracking sheet for each category that tracks your expenses for each month of one year. In sheet two enter your data for three
months and leave space for entering data for the rest of the year (these can be left blank). You should have space to enter the date and
each expense under the category and month. You should have totals by category (both month and year) as well as monthly totals and
a year to date total. Totals will currently only reflect your three months you entered but should update automatically if you add data
for the remaining months. These totals should then be compared to your planned budget in sheet one by category and month. Sheet
three will be your reflection as described below.
❖ Provide visually appealing formatting to allow for quick differentiation among the categories and months and for quick
location of individual items.
❖ Provide visually appealing and correct formatting to allow for ease of data entry without disrupting the form or function
of sheet one and two. (What if electrical budget is changed from $150 to $125 a month? What if you have to add another
gas receipt for January?)
❖ Accurately calculate your totals in each category in dollars for each month on sheet two.
❖ Accurately calculate your totals in each category in dollars and percentage of total for the year on both sheet one and
sheet two.
❖ Accurately calculate your expenses and savings as new items are added to sheet two.
❖ Create two charts on sheet one that compare expenses by month and by category.
❖ Create a chart sheet two that compares actual expenses to budget amounts.

Reflection:

The reflection must be completed in Canvas. “Module 3: Project 2 – Reflection – Requires Respondus LockDown Browser +
Webcam.
Project due date: ____________________

Rubric for Reflections

6 Points 4 Points 2 Points 0 Points
Reflection Paragraph I Reflection is well Reflection is written Reflection is written No reflection
written in organization with poor organization with poor organization submitted.
Reflection Paragraph II and grammatical or lacking grammatical and lacking
structure. Demonstrate structure. Demonstrate grammatical structure.
Reflection Paragraph III both deep thought and some thought and Demonstrate little
comprehensive comprehensive thought and no
overview of the overview of the overview of the
project. project. project.
Rubric for Sheet One and Two
6 Points 4 Points 2 Points 0 Points
Sheet one minimum number of 10-15 categories are used. Missing 1 or 2 categories. Missing 3 or more
categories used categories.
Sheet one formatting and Layout, Borders, The use of, Borders, The use of, Borders, The use of, Borders,
labeling Background color, Font, Background color, Font, Background color, Font, Background color, Font,
Font size, and Font style all Font size, and Font style Font size, and Font style Font size, and Font style
work to differentiate are mostly effective to are barely effective to are not effective to
between each category. differentiate between each differentiate between each differentiate between each
category. category. category.
Sheet one ease of data Entry of data is easy, cell Data is easy to enter, but The form or function of the The sheet does not function
change/entry has correct formatting, and some cells do not have workbook is disrupted properly, making data
does not cause disruption proper formatting for the when some data is entered entry almost impossible.
in the form or function of data. and some cells do not have This can be due to
the workbook The form or function of the the proper formatting. formatting issues or issues
workbook is not disrupted. with the layout.
Sheet one all requested totals All totals are on sheet and 1 or 2 totals are missing or 3 or 4 totals are missing or 5 or more totals are
included and correct correct. incorrect. incorrect. missing or incorrect.
Sheet one all requested All percentages are on 1 or 2 percentages are 3 or 4 percentages are 5 or more percentages are
percentages included and sheet and correct. missing or incorrect. missing or incorrect. missing or incorrect.
correct
Sheet one chart comparing The chart is completely The chart is missing a The chart is missing two or The chart is missing three
categories labeled, including axes, legend or one of the axis more labels or a legend and or more labels.
title and legend. It has not been labeled. the chart does not
accurately reflects the data. accurately reflect the data
in the two indicated
categories.
Sheet one chart comparing The chart is completely The chart is missing a The chart is missing two or The chart is missing three
months labeled, including axes, legend or one of the axis more labels or a legend and or more labels.
title and legend. It has not been labeled. the chart does not
accurately reflects the data. accurately reflect the data
in the two indicated
categories.
Sheet two minimum number of 3 months of data are 3 months of data are Only 2 months of data is Only one months of data is
months data included with included and space is included bit space is not included. included
space for all months included of the additional 9 included of the additional 9
months. months.
Sheet two formatting and Layout, Borders, The use of, Borders, The use of, Borders, The use of, Borders,
labeling Background color, Font, Background color, Font, Background color, Font, Background color, Font,
Font size, and Font style all Font size, and Font style Font size, and Font style Font size, and Font style
work to differentiate are mostly effective to are barely effective to are not effective to
between each category. differentiate between each differentiate between each differentiate between each
category. category. category.
Sheet two ease of data Entry of data is easy, cell Data is easy to enter, but The form or function of the The sheet does not function
change/entry has correct formatting, and some cells do not have workbook is disrupted properly, making data
does not cause disruption proper formatting for the when some data is entered entry almost impossible.
in the form or function of data. and some cells do not have This can be due to
the workbook The form or function of the the proper formatting. formatting issues or issues
workbook is not disrupted. with the layout.
Sheet two calculations correct Adding additional data will Adding additional data will Adding additional data will Adding additional data will
when new items added automatically update all automatically update most automatically update some not automatically update
calculations. calculations. calculations. calculations.
Sheet two all requested totals All totals are on sheet and 1 or 2 totals are missing or 3 or 4 totals are missing or 5 or more totals are
included and correct correct. incorrect. incorrect. missing or incorrect.
Sheet two all requested All percentages are on 1 or 2 percentages are 3 or 4 percentages are 5 or more percentages are
percentages included and sheet and correct. missing or incorrect. missing or incorrect. missing or incorrect.
correct
Sheet two chart comparing The chart is completely The chart is missing a The chart is missing two or The chart is missing three
budget to actual labeled, including axes, legend or one of the axis more labels or a legend and or more labels.
title and legend. It has not been labeled. the chart does not
accurately reflects the data. accurately reflect the data
in the two indicated
categories.