EXCEL SHEET

Brody has three months to save $1200. Here is his plan. Will he make it?

March:
Must pay $200 to his mom
Must pay $300 for rent
Must pay $100 for his car
He will earn $200 from lawn mowing
He will earn $75 for babysitting
He will earn $775 for selling items on Ebay

April:
Must pay $50 in rent
Must pay $100 for his car
He will earn $300 from mowing lawns

May:
Must pay $60 for tickets to go to a concert
He will earn $20 from babysitting
Must pay $100 for rent

TASK
You must compose a spread sheet with all of the information above. Think about how you would design the spreadsheet. By month? By items he needs to pay for vs. money he owes? Be neat and organized! Make smart choices so your audience will understand it. In addition to including all of the information above, you must also provide the Total for he will have (either positive or negative) for each month and then provide a grand total at the end of how much he will have (it may be a positive or negative number). You will have to generate formulas for these.

Use different easy-to-read fonts and sizes, appropriate column headings, and again, make sure your information is organized in a smart way so if you were to present it, your audience would understand it. You may include only one piece of clip art.

When you are finished, print preview and make sure it is in landscape. In addition, add a footer with your name/date/hour.