create a simple budget, and track our budget compliance over the course of a 12 month period

Marketing Management
12/09/2019
Entrepreneurship And Innovation.
12/09/2019

create a simple budget, and track our budget compliance over the course of a 12 month period

Assignment Instructions

For this exercise we are going to create a simple budget, and track our budget compliance over the course of a 12 month period.  Although it is possible (and common) to track budget compliance on a month to month basis, to keep things simple for this exercise we are going to only examine the year end result.

Start by creating a budget in Excel in the following format.

Spreadsheet image

For the starting budget $ amounts you use the following logic.  Determine the yearly values and enter them into your budget.  Don’t forget to add the totals, and to determine the amount you are short/extra.

Salary = $4,000 a month

Rent = $1200 a month

Car payment = $650 a month

Phone = $95 a month

Health Insurance = $250 a month

Food = $500 a month

We are now going to add the following data for the monthly amounts in out spreadsheet

Salary:  Your starting salary for the year is $4,000 a month.  In June you get a 3% pay increase.

Additionally you get a one-time bonus payout of $500 in October.

Rent:  Your monthly rent per your lease is $1,200 a month, with a 5% increase in November.

Car:  Your car is under lease at a rate of $650 a month.

Phone:  Your month rate for your phone is $95 a month, but you incurred overage charges of $25 each in the months of April, August, and December.

Health Insurance:  Your monthly installments for health insurance are $250 a month.

Food: Food expense tends to be more varied than the other expenses be captured.  Use the follow table to enter your food expenses.

food expense

Other:  In the month of March you have a car repair bill of $750 and in August you took a $125 flight to visit your parents.

WhatsApp Chat with us on Whatsapp