BTA3O1                                        HOME BUDGET SPREADSHEET

Running a budget for your household can be tricky. Often times we spend money without realizing where our dollars end up. Over the course of one year we also waste money. We buy things that we want instead of buying what we need. Some of us use our credit cards and become overwhelmed when the bill arrives. We keep on spending because it is easy to put it on the plastic. But deep down in our conscience we know we have over spent. In the following exercise you will be required to create a spreadsheet that will answer where you spent your money over the course of three years. Your net income per month is $2,300.
YEAR 2002

Dog Food 180 Groceries 4,800 Vehicle Gasoline and Maintenance 1,800 Utilities 1,200 Entertainment 1,200 Retirement 1,200
Toiletries and Sundries 300 Haircuts 300 Insurance 700 Rent 700 Clothing 800

YEAR 2003
Dog Food 185 Groceries 4,885 Vehicle Gasoline and Maintenance 1,890 Utilities 1,225 Entertainment 1,200 Retirement 1,200
Toiletries and Sundries 310 Haircuts 320 Insurance 730 Rent 700 Clothing 810

YEAR 2004
Dog Food 190 Groceries 4,900 Vehicle Gasoline and Maintenance 2,000 Utilities 1,230 Entertainment 1,200 Retirement 1,200
Toiletries and Sundries 325 Haircuts 330 Insurance 750 Rent 700 Clothing 900

Instructions:

  1. Create a spreadsheet making sure you assemble the information in rows and columns that are appropriate for this exercise.

  2. Your column headings should be as follows
     YEAR 2002 YEAR 2003 YEAR 2004

  3. Your row headings should be as follows:

    Dog Food Groceries, Toiletries and Sundries, Haircuts, Vehicle Gasoline and Maintenance, Insurance, Rent, Utilities, Entertainment, Clothing, Retirement Total

  4. Beyond the cell with Year 2004 find the average, minimum and maximum for all of the row titles for each of the years.

  5. Format the total row for currency and two decimal places and bold the Total Row.

  6. Find the Percentage of Total for all the expenses for all three years . Hint: Remember absolute cell addressing. How much of the total expense is the dog food, etc.

  7. Insert a Header with your name in it centered in 22 pt. Font and a footer with the title BUDGET in capitals bolded, centered and 36 pt. Font.

  8. Create a visually impressive graph which gives information about your spending habits.

  9. Save the workbook as Budget.