ART+OF+BUDGETING+MB13

Create a spreadsheet based on the following information.
Net Monthly Income from bookstore part time work = $500. Net Monthly Income from part time secretarial work in a veterinarian's office = $900.


 * Planned Expenses**
 * **Planned Primary Expenses** || **Planned Secondary Expenses** ||
 * $175 for rent || $60 for clothes ||
 * $200 for car payment || $100 for school ||
 * $240 for car insurance || $50 for entertainment ||
 * $50 for gas & oil || $50 for personal & household items ||
 * $100 for food ||  ||
 * $25 into savings ||  ||

Net Monthly Income from bookstore = $500 Net Monthly Income from veterinarian is $900. $100 overtime from veterinarian office.
 * Actual Income and Expenses**
 * **Actual Primary Expenses** || **Actual Secondary Expenses** ||
 * $175 for rent || $20 for parking and tolls ||
 * $200 for car payment || $185 for car repairs ||
 * $240 for car insurance || $90 for pair of shoes ||
 * $60 for gas & oil || $60 for entertainment ||
 * $140 for food || $80 for personal items ||
 * $50 into savings || $30 for birthday present ||
 * || $160 for a speeding ticket ||


 * Create a spreadsheet with 3 columns for Income/Expenses, Planned, and Actual. Enter the correct information and figures for each item.**
 * After completing the spreadsheet, answer these questions in a text document.**
 * 1) What is the difference between the planned expense and actual expense? One is Real and one is thought or planned to be correct and real.
 * 2) In what areas did she overspend?Gas and oil, food, savings, and entertainment.
 * 3) Where did she get the extra money to spend? From areas she spent less.
 * 4) Which budget areas seems to cost the most?Car insurance, car payment, rent, and food.
 * 5) How much money did she have at the end of the month to put into savings or into school costs? $200


 * The planning sheet looks like this:**


 * To start the spreadsheet, it should look like the spreadsheet below. Enter the data and formulas to find the difference between the planned and actual budget. Be sure to format the cells as a Currency with 0 decimals. Show the completed work to Mrs. Carrier. Do not print the work.**