The Go-SNAX Project

1
The Go-SNAX Project
The final part of our market research is to look
at how people may look at value for money when
choosing snacks. How can we compare the value
for money of different snacks? Do healthy
snacks differ in price and value for money?
2
Comparisons
Vs
3
The weight of snacks we get for our money. If a
10g Sugar free cherosa lolly costs 22p 1g 22
2.2p 1 kg 1000g so costs 2200p
10 Using real data 50g of Garden Gang dried
fruit snack cost 28p 1g 28 0.69 p 1 kg
1000g so costs 690p 50 Which is best
value?

• These are quite complicated calculations.
• Sometimes prices and weights may change.
• What type of computer program is used when we
  need to complete tables of calculations?

4
Creating the spreadsheet

• Load the file
• Price per kilogram
• Enter the formulae to calculate the value for
  money figures.
• Enter some trial values for your new snacks
  (number of snacks, weight of pack, price), you do
  not want to be too expensive!
• Now choose an appropriate graph to present your
  data

5
Advantages of Spreadsheets

• What are the advantages of having the figures
  calculated on a spreadsheet?
• Our Market research is finished, next week we
  will create a report and suggest what our new
  snacks should be like. Discuss your ideas!