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?

ComparisonsComparisons

VsVs

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 data50g 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?

Creating the spreadsheet

Load the file Price per kilogram1. Enter the formulae to calculate the

‘value for money’ figures.2. Enter some trial values for your new

snacks (number of snacks, weight of pack, price), you do not want to be too expensive!

3. Now choose an appropriate graph to present your data

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!