Part A: Budget (5 marks) Use the following information to set up Rachel's budget on the attached spreadsheet (the projected column). 1. Income: Gabrielle works part-time at a greeting card company and part-time at a record store. The net monthly income from her first job is $600. The net monthly income from her second job is $800. 2. Her planned fixed monthly expenses include: $200 for rent (she shares an apartment with two friends) $175 for car payment $220 for car insurance Part B: How her month actually went (enter the following into the actual column on the spreadsheet) (5 marks) 1. Income: (What actually she made this month) Her projected income plus Gabrielle made $45 in overtime pay this month. 2. What her fixed expenses actually were: Rent went up to $225, starting this month Her monthly car payment was \$175 Her monthly car insurance premium, as of this month, went up to $295 4. Unforeseen events: Gabrielle got two speeding tickets in one week. The total cost of both tickets is $230. Part C: Calculate the Difference (last column) (4 marks) Difference = projected actual (if it's negative, put it in brackets) Part D: Monthly Budget Summary (4 marks) - Complete the summary with your calculations Part D: Questions about the budgets (5 marks) 1. What is the difference between Rachel's planned expenses and her actual expenses? 2. In what areas did she overspend? 3. In what areas did she spend less than she planned? 4. How much did she spend for the use of her car this month? 5. How much money did she have at the end of the month to put into savings? Rdnet Prenared for. Rachal Iviuillily Dunger suinililary