Family Budget
Primary Subject - Computers / Life Skills
Secondary Subjects - Other, Multidisciplinary
Grade Level - 8-12

Software: Spreadsheet such as Excel


You are responsible for creating a monthly budget for your family for a certain month. Your budget must be realistic and you must live within your means. Please create a spreadsheet that reflects your family’s monthly income and expenditures with the following information:

Monthly household income:

Expenses: Please fill in your monthly expenses for the following, if it does not apply write N/A.

Rent or mortgage:

Utilities:

Telephone:

Television:

Automobile (payment, insurance gasoline, etc):

Entertainment:

Family clothing expense:

Food expenses:

Childcare expenses:

Household items (toilet paper, shampoo, cleaner, etc):

Personal Care (haircuts, manicure, etc):

Birthdays/Holidays gifts:

Savings

After you have gathered all of the above information please create a spreadsheet showing your budget. Your spreadsheet should contain formulas so you can plug in different numbers each month and your spreadsheet will accurately calculate the current month’s expenses.

Graph your spreadsheet using a graph style that you feel best illustrates the breakdown of your monthly expenses. Customize your graph to look visually pleasing.