My pizza snack bar
Recipe Ingredients
Pizza Napoli 500g flour $ 0.75
2 cans tomato $ 1.20
100g cheese $ 1.00
10g oregano $ 0.05
10g salt $ 0.01
5g yeast $ 0.10
Total cost $ 3.11
Number of portions 8
Cost per potion $ 0.39
Selling price $ 1.00
Profit per potion $ 0.61
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format will permanently break the
chart.
eak the
Recipe Ingredients
Tiramisu Cake 1000ml cream $ 2.50
500g cheese $ 5.00
150g sugar $ 0.50
600ml coffee $ 1.25
400g biscuit $ 1.00
50g chocolate $ 0.75
Total Cost $ 11.00
Number of portions 12
Cost per portion $ 0.92
Selling Price $ 1.50
Profit per portion $ 0.58
Chart Title
$14.00
$12.00
$10.00
$8.00
$6.00
$4.00
$2.00
$-
r it t
m es
e
ga ffe
e te os ns n
ric
e n
r ea e u o scu ola C t io r tio P r tio
s i l r
lc ch lc b c
ta po po g po
m g 0g m g c ho To f er llin er
0 0 5 0 0 o
00 50 1
60 40 g r p Se p
1 50 be o st fit
o
u m C Pr
N
My pizza snack bar
Product Pizza napoli Terimisu cake
Profit perf portion $ 0.61 $ 0.58
Number of portions sold 30 25
Profit per product $ 18.34 $ 14.58
TOTAL PROFIT $ 32.94 $ 15.18
CUSTUMER A1BILL
BOOK Auther or Company PRICE
Islamiat Olevel studies Farkhanda Noor $ 850.00
Spiro art Hinkler $ 12.99
Cambride essential english dictionary Cambrige $ 9.95
Wimpy kid The Third Wheel Jeff Kinney $ 6.99
Dork diaries Frenimes Forever Rachel Renee $ 7.99
Black Beauty Annna Sewell $ 12.99
Harry potter J.k. Rolwing $ 14.99
The Tales Of Two Cities Charles Dickens $ 7.99
TOTAL $ 850.00
12.99
9.95
6.99
7.99
12.99
14.99
7.99
Chart Title
17
15
13
11
9
7
5
3
1
0 100 200 300 400 500 600 700 800 900
Column A Column B Column C
