1. Section 1

1.8. Explore 3

Mathematics 20-3 Module 1

Section 1: Personal Budgets

 

This is a photo of a cook preparing food.

Stockbyte/Thinkstock

Try This 2

 

Andre works as a short-order cook in a restaurant in his hometown. For the month of September he has prepared a spreadsheet for his net pay, his share of the tips, and his expenses. Andre owns a car and makes monthly insurance payments.

 

This is a play button that opens an interactive spreadsheet.

 

Open Andre's Life spreadsheet and, if possible, work with a partner to answer these questions.

  1. To describe Andre's income, enter an R (for recurring) or V (for variable) in the column headed Regular or Variable.

  2. Enter an R or V in the column headed Recurring or Variable to describe his expenses.

  3. Andre’s total expenses in September were greater than his total income; Andre spent more than he earned.

    • Suggest ways Andre might have adjusted his expenses so that they total less than his earnings.

    • Enter your suggested dollar values in the Expenses column.

    • Explain why you made each suggestion in the Explanation of Adjustment column.

  4. What percentage of his regular income does Andre spend on rent? Hint

course folder Save a copy of the spreadsheet and your answers to your course folder.



Set up a fraction to help to find the percent of income spent on rent.