Cupcak Numb

e er
flavour made NumberIngredients (Price (per Total cost of producTotal income from cupcake flavour
Vanilla 350 200 $0.20 $1.60
Strawb 1)Insert your name as header
225 150 $1.60
erry $0.20 2) Apply Formatting (Apply
Borders, shading & format Text
Chocola (including currency)
200 200 $1.60
te $0.20 3) Work out the Total cost of
Lemon 120 20 $0.20 $1.60 producing cupcake flavour =
Total cost Ingredients (per cupake) *
Number made
Total profit 4) Use a Sum function to work
out the Total Cost of =
SUM(F2:F5)
5) Work out the Total income
from cupcake flavour= Price
(per cupcake)* Number sold
6) Work out the Total profit =
Total Cost of producing cupcake
flavour - Total income from
cupcake flavour
7) Create a simple bar chart
showing the total profit for
each Cupcake flavour. Include
appropriate titles.
 your name as header
y Formatting (Apply
shading & format Text
ng currency)
out the Total cost of
ng cupcake flavour =
nts (per cupake) *
made
Sum function to work
Total Cost of =
:F5)
out the Total income
pcake flavour= Price
cake)* Number sold
out the Total profit =
st of producing cupcake
- Total income from
flavour
e a simple bar chart
g the total profit for
upcake flavour. Include
iate titles.
Cupcake flavoNumber Number SolTotal Cost of produci Total Income from cupTotal Profit
Vanilla 350 200 $70.00 $320.00 -250.00
Strawberry 225 150 $45.00 $240.00 -195.00 1)Insert your name as header
Chocolate 200 200 $40.00 $320.00 -280.00 2) Apply Formatting (Apply
Lemon 120 20 $24.00 $32.00 -8.00 Borders, shading & format Text
(including currency)
Total Cost / $179.00
3) Work out the Total cost of
producing cupcake flavour =
Ingredients (per cupake) *
Ingredients (p $0.20 Number made. Use absolute cell
Price (per cup $1.60 reference
4) Use a Sum function to work
Total Profit out the Total Cost of =
SUM(D2:D5)
5) Work out the Total income
Lemon from cupcake flavour= Price (per
cupcake)* Number sold. Use
absolute cell reference
6) Work out the Total profit =
Chocolate
Total Cost of producing cupcake
flavour - Total income from
cupcake flavour
Strawberry
Graph: 7) Create a simple bar
chart showing the total profit
Vanilla
for each Cupcake flavour.
Include appropriate titles.
-300.00-250.00-200.00-150.00-100.00 -50.00 0.00
 rt your name as header
ply Formatting (Apply
rs, shading & format Text
ding currency)
rk out the Total cost of
cing cupcake flavour =
dients (per cupake) *
er made. Use absolute cell
nce
a Sum function to work
e Total Cost of =
D2:D5)
rk out the Total income
cupcake flavour= Price (per
ke)* Number sold. Use
ute cell reference
rk out the Total profit =
Cost of producing cupcake
ur - Total income from
ke flavour

: 7) Create a simple bar