Budget Project



Budget Project

Congratulations! You have graduated from high school and you are working (you may also be going to school.) Now you have decided to get your own place to live. Your mission is to research the expenses involved in renting your own place, moving in, and month-to-month living. You will be using Excel and the internet.

Activity 1

You will develop a menu, which meets good nutritional requirements; you are limited to eating out one/two times a week. The menu must include daily: dairy products, fruits, vegetables, protein, and grains. You must include three meals and a snack per day.

Develop a weekly menu in excel sheet one ( creating/design a table showing days of the week, meals and what you will eat.

Saves as Budget Project in the excel folder.

Activity Two In Excel

Open an excel document and save it in the excel project folder as budget project.

Worksheet 2:

➢ In Excel, you will save the second tab as shopping list. Including the following:

o List of items needed to complete the menu

o Cost of items needed and a picture for at least 2 items on the list

o Create a formula in a cell which calculates the sub total cost

o Create a formula in a cell which calculates the tax -use 7.75% or 0.0775 use * in formula with absolute value

o Create a formula for the total

o Cost of eating at fast food or restaurant one time. Do not forget the sales tax

o Create formula with grand total in the corresponding cell

o The list must appear in columns and not just one long list (see example)

o Format the spreadsheet with line color and fill color and different fonts

Worksheet 3:

➢ Rent- find an apartment in Southern California using

➢ Weekly food budget (based on menu) use a formula to find monthly total

➢ Find car at

➢ Car insurance is ($200) a month

➢ Cost of gas (find out the tank size and gas cost $4.10)

➢ Car payment /lending center/vehicle loans/loan calculator/auto loan-leases

➢ Entertainment cost (3 things)

➢ Miscellaneous cost (3 things)

Worksheet 4:

Worksheet 4: Save as yearly expenses compute the following formulas. Take

Using the following formulas to create cells that calculate the following:

➢ Annual Salary = monthly x 12

➢ Monthly = copied from the monthly expenses

➢ Weekly = yearly/52

➢ Daily = week/5

➢ Hours = day/8

➢ Minutes = day/60

Worksheet 5

Create a graph using the information on this worksheet to show the break down of your monthly expenses.

In word, answer the following two questions: create a text box and type your response:

1. How to cut my expenses (if budget is too high) or increase my budget (if budget is too low) Describe each i.e. shopping list renting an apartment and buying your car. Must be at least 5 sentences with two paragraphs MINIMUM = C average

Once the questions are completed in word, copy and paste a text box in your excel document “Yearly Summary Spreadsheet”

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download