Learning Intention: Can I create a spreadsheet to help with finances?
Success Criteria:
I can understand what spreadsheets are used for
I can download a spreadsheet and understand how to format
I can insert the shop data
I can create formulas to calculate the total costs
Discuss:
I can get a copy of the spreadsheet and understand how to format
Click here to get a copy of the spreadsheet
Tools you will use when you format your own spreadsheet:
Borders
Cell Colour
I can insert the shop data + I can create formulas to calculate the total costs
You can just type numbers into a spreadsheet
If you want it to do Maths you have to put in a formula - Every formula starts with an = sign
FIXED COSTS + Formulas
FIXED COSTS - A cost that is the same each week
Website cost = 50 per week
Adverts = 30 per week
Formula answers
VARIABLE COSTS + Formulas
Variable Costs - A cost that changes depending on how many products you buy or sell
Standard FS = 3
Flashing FS = 5
Number Sold
Week 1: 8 Standard & 4 Flashing
Week 2: 6 Standard & 5 Flashing
Week 3: 10 Standard & 5 Flashing
Week 4: 7 Standard & 7 Flashing
Formula answers
Total Variable costs:
Can you work out what formulas you need to put into the totals?
Finished Spreadsheet - Formulas
Spreadsheet results
Extension
I can create graphs that show this information