Jamie Lee is reviewing her finances one month later. She has provided the actual amounts paid below. Use the cash budget table below to help her identify the variances in her budget. Each answer must have a value for the assignment to be complete. Enter "O" for any unused categories. Actual Amounts Income: Gross monthly salary Net monthly salary Savings allocation: Regular savings Rainy-day savings Entertainment: Cake decorating class Movies with friends Monthly expenses: $2,590 Rent obligation $2.170 Utilities electricity Utilities/water $155 Utilities/cable TV $45 Food Gas, maintenance $40 Credit card payment $75 Car insurance Clothing $270 $130 $50 $190 $175 $255 $55 $95 $195 $250 $100 Budgeted Amounts Assets: Checking account Emergency fund savings account Car Computer & iPad Llabilities: Student loan Credit Card balance Income: Gross monthly salary Net monthly salary Savings allocation: Regular savings Rainy day savings Monthly Expenses: $2.100 Rent obligation $4.800 Utilities electricity $5.700 Utilities water $1.350 Utilities cable TV Food $7.100 Gas maintenance $1.250 Credit card payment Car Insurance $2,405 Clothing $1,985 Entertainment: Cake decorating class $155 Movies with friends $45 $60 $145 $140 $120 $70 $70 $70 $40 $75 Budgeted Amounts Income (Inflows) Dollar Percent Actual Amounts Variance Salary Other NaN NaN Income (Inflows) Budgeted Amounts Dollar Percent NaN Actual Amounts Variance $ Salary Other Total income 0 S NaN NaNNaN $ 0 s 0 0 $ 0 Budgeted Amounts Disbursements (Outflows) Dollar Percent Actual Amounts Variance NaN S 0 NaN S 0 S NaN 0.00% $ 0 S 0 0 $ 0 NaN $ 0 NaN 0 0 NaN NaN Emergency fund savings Emergency fund Savings (regular) Savings Total savings Fixed expenses Mortgage or rent Property taxes Loan/credit card payment Insurance Other Total fixed expenses Variable expenses Food Utilities Clothing Transportation costs Personal care Medical and health care Entertainment Education Gifts donations Miscellaneous S $ $ S 5 0 NaN 0 S 0 0.00% S 0 0 S 0 S 0 $ 0 NaN NaN NaN NaN NaN NaN NaN $ 0 0 0 0 0 0 Other Total variable expenses Total expenses NaN NaN NaN NaN 0.00% 5 NaN S S $ S 0 $ 05 0 0 0 0 0 Jamie Lee is reviewing her finances one month later. She has provided the actual amounts paid below. Use the cash budget table below to help her identify the variances in her budget. Each answer must have a value for the assignment to be complete. Enter "O" for any unused categories. Actual Amounts Income: Gross monthly salary Net monthly salary Savings allocation: Regular savings Rainy-day savings Entertainment: Cake decorating class Movies with friends Monthly expenses: $2,590 Rent obligation $2.170 Utilities electricity Utilities/water $155 Utilities/cable TV $45 Food Gas, maintenance $40 Credit card payment $75 Car insurance Clothing $270 $130 $50 $190 $175 $255 $55 $95 $195 $250 $100 Budgeted Amounts Assets: Checking account Emergency fund savings account Car Computer & iPad Llabilities: Student loan Credit Card balance Income: Gross monthly salary Net monthly salary Savings allocation: Regular savings Rainy day savings Monthly Expenses: $2.100 Rent obligation $4.800 Utilities electricity $5.700 Utilities water $1.350 Utilities cable TV Food $7.100 Gas maintenance $1.250 Credit card payment Car Insurance $2,405 Clothing $1,985 Entertainment: Cake decorating class $155 Movies with friends $45 $60 $145 $140 $120 $70 $70 $70 $40 $75 Budgeted Amounts Income (Inflows) Dollar Percent Actual Amounts Variance Salary Other NaN NaN Income (Inflows) Budgeted Amounts Dollar Percent NaN Actual Amounts Variance $ Salary Other Total income 0 S NaN NaNNaN $ 0 s 0 0 $ 0 Budgeted Amounts Disbursements (Outflows) Dollar Percent Actual Amounts Variance NaN S 0 NaN S 0 S NaN 0.00% $ 0 S 0 0 $ 0 NaN $ 0 NaN 0 0 NaN NaN Emergency fund savings Emergency fund Savings (regular) Savings Total savings Fixed expenses Mortgage or rent Property taxes Loan/credit card payment Insurance Other Total fixed expenses Variable expenses Food Utilities Clothing Transportation costs Personal care Medical and health care Entertainment Education Gifts donations Miscellaneous S $ $ S 5 0 NaN 0 S 0 0.00% S 0 0 S 0 S 0 $ 0 NaN NaN NaN NaN NaN NaN NaN $ 0 0 0 0 0 0 Other Total variable expenses Total expenses NaN NaN NaN NaN 0.00% 5 NaN S S $ S 0 $ 05 0 0 0 0 0
