Tic Tac

1
Tic Tacs
Tic Tac Statistics Pack Weight 16 Grams No. of
Sweets in a pack 33 Price of Tic Tacs
37p Kcal/100g 386
2
Polo Fruits
Polo Fruits Statistics Pack Weight 42 Grams No.
of Sweets in a pack 18 Price of Polo Fruits
29p Kcal/100g 345
3
The Small Sweets Project

• The final part of our market research is to look
  at how people may look at value for money when
  choosing sweets.
• How can we compare the value for money of
  different sweets?
• Are Tic Tacs better value than Polo mints?

4
How many sweets we get for our money. Tic Tacs
33 sweets for 37p We get 33 0.89 sweets per
penny. 37 Polos 18 sweets for
29p We get 18 0.62 sweets per penny
29 Which is best value?
5
The weight of sweets we get for our money. 16g
of Tic Tacs costs 37p 1g 37 2.31 p
16 42g of Polos cost 29p 1g 29 0.69 p
42 Which is best value?
6
Best Value

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

• How many sweets we get for our money.
• Tic Tacs 33 sweets for 37p
• We get 33 0.89 per penny.
• 37
• Polos 18 sweets for 29p
• We get 18 0.62 per penny
• 29

• The weight of sweets we get for our money.
• 16g of Tic Tacs costs 37p
• 1g 37 2.31 p
• 16
• 42g of Polos cost 29p
• 1g 29 0.69 p
• 42

WHICH IS THE BEST VALUE ?
7
Creating the spreadsheet

• Load the file
• Value for money table
• Enter the formulae to calculate the value for
  money figures.
• Enter some trial values for your new sweets
  (number of sweets, weight of pack, price), you do
  not want to be too expensive!
• Complete the box on the right to show your
  understanding.
• You may draw some graphs to show the value for
  money figures more clearly.

8
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
  sweets should be like. Discuss your ideas!