VIEWS: 1 PAGES: 8

• pg 1
```									Spreadsheets

Biscuit Model
Biscuit Model
• You already should know how to enter
formula.
• Why do should you use formulas?
Biscuit Model
Today's biscuits                                                                     7.4T2c
Quantity                Quantity for    Cost for
200            Ingredient    Measure       for 1   Cost for 1      today          today
Wholemeal
flour        grams       17.5          £0.02        3500            £4.00
Oatmeal         grams         5           £0.02        1000            £4.00
Butter          grams        11           £0.03        2200            £6.00
Soft brown      teaspoon
sugar          s        0.4          £0.01         80             £2.00
teaspoon
Baking powder       s        0.1          £0.03         20             £6.00
teaspoon
Salt                s       0.05          £0.01         10             £2.00

£0.12                       £24.00
Totals; These are formulas, the
formulas are written as
=SUM(E3:E8)
Biscuit Model
• The first question asks how much would
500 biscuits cost?
• To work this out we need to find the
information on the spreadsheet of how
much 1 biscuits costs?
• And we need to display the answer for 500
biscuits so that everyone understands
what it is.
Biscuit Model
Today's biscuits                                                                                         7.4T2c
200                   Ingredient     Measure   Quantity for 1   Cost for 1    Quantity for today   Cost for today

Wholemeal flour       grams            17.5              £0.02          3500                     £4.00

Oatmeal               grams             5                £0.02          1000                     £4.00

Butter                grams             11               £0.03          2200                     £6.00

Soft brown sugar      teaspoons        0.4               £0.01           80                      £2.00

Baking powder         teaspoons        0.1               £0.03           20                      £6.00

Salt                  teaspoons        0.05              £0.01           10                      £2.00

Cost of one Biscuit                                        £0.12                                   £24.00
Biscuit Model
Today's biscuits

200                   Change this to 500
and watch what
happens

Biscuit model

• What do I have to alter to find out the cost
of butter for 750 biscuits

What do I have to do?
Biscuit Model

Today's biscuits

200

I wonder what
happens when I
change this?