You are going to be saving up for a technological device of some kind.. (such as an iPhone, iPad Air, Virtual Reality System, Gaming System) Minimum cost $300.00
1. Open a Sheets document and save as: 8Sheets4 your name think of an electronic device and research how much that device will cost plus shipping if it is not available locally!
2. Place the name of that device (in cell A1). Merge and center A1 from column A1 to D1. Change the font from Times New Roman to another legible font. Choose a new color as well.
3. In cell E1 place the cost of the item, in cell E2 input the shipping, if necessary, using a formula indicate the total cost in cell E3
4. In cell A2 input your allowance for each week (if you don’t receive an allowance your allowance for now is $20.00 a week!) if you do receive allowance it just got bumped up or downgraded to $20.00!
5. With this new increase in allowance (or downgrade in allowance) you are now responsible for the following costs (debits) each week. You have to chooseone of the options below to include in your Sheets spreadsheet.
Option 1 Lunch @ $1.75 per day (x’s 4), Art supplies $1.00 Tuesday and Thursday each week, and two trips to Sonic for after school snack @ $2.17 per trip you choose the days.
Option 2 Skip lunch at school 4 trips to McDonalds @ $1.75 per day x’s 4 days, Technology supplies .35 cents per day Tuesday and Thursday only, Popcorn and a pickle all four school days at the going rate.
Option 3 Starbucks for breakfast x’s 4 days @ $2.35 per day, PE supplies Monday and Wednesday @ .55 cents per Monday and Wednesday, and 3 trips to Circle K @ $1.17 per visit you pick the days.
6. Friday, Saturday, and Sunday you hang out at home so they are free!
7. Input all of the above data (including one option 1, 2, or 3) add any other expenses you might incur if I forgot anything.
Cell A10 Money Spent
Cell A11 Money Left
B2 Lunch or Breakfast Money (depending upon your choice of options 1 – 3)
C2 PE, Art, or Technology Supplies as indicated by your option choice
D2 Afternoon snacks as indicated by your option choice
8. In cell E8 indicate the total amount of money remaining after expenses after one week, then using a formulaindicate how many weeks it would take to save up for your device at your current rate of spending and saving.
9. Save again, show me completed Sheets1, Sheets2, and Sheets3 >MFT