Mario moved out of his parents home into a two bedroom apartment four months ago. H has recorded his expenses.

a) Use a spreadsheet to calculate Marios total expenses by expense type and by month from january to april

b) Which expense do you think will decrease over the next few months? Explain (consider when you would expect to pay for these expenses.)

c) Extend the spreadsheet to what you think his expenses will be for the year.

d) If one month's accommodations expenses should not exceed one week's net income, what approximate minimum weekly net income does Mario need to afford this apartment? justify your answer.

Jan 1-first and last month rent-$1180

Jan 7-activate cable-$65

Jan 19-top up cellular telephone time-$40

Feb 1-rent-$590

Feb 18-gas bill-$117.40

Feb 22-electricity bill-$86.23

Mar 1- rent-$590

Mar 11-cable bill-$103.06

Mar 18-gas bill-$123.64

Mar 29-top up cellular telephone time -$50

Apr 1- rent-$590

Apr 18-gas bill-$93.68

Apr 22-electricity bill-$92.21