Cupcake Costing and Recipe

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 15

RECIPE COSTING

INGREDIENTS QUANTITY UNIT OF MEASUREMENT COST/PRICE


APF 64 GRAMS 46
BAKING POWDER 8 GRAMS 16
SALT 2 GRAMS 20
RICE FLOUR 160 GRAMS 40
WATER GRAMS
BUTTER 10 GRAMS 60
EGG 100 GRAMS 14
SUGAR 100 GRAMS 41
COCONUT MILK 152 GRAMS 18

TOTAL DOUGH WEIGHT 596 TOTAL AP COST 255

OTHER EXPENSES
GASUL 30
LABOR 50
PACKAGING 5
TOTAL CAPITAL 133.157939393939

YIELD 15
AMOUNT UNIT OF MEASUR UNIT COST
1000 G 2.944
30 G 4.26666666666667
1000 G 0.04
1000 G 6.4
237 G 0
220 G 2.72727272727273
100 G 14
1000 G 4.1
200 G 13.68
100 0
100 0
100 0
100 0
100 0
1000 0
1000 0
1000 0
TOTAL UNIT COST 48.1579393939394

DESIRED NO.
RECIPE COSTING- SPANISH BREAD

INGREDIENTS QUANTITY UNIT OF MEASUREMENT COST/PRICE


APF 250 GRAMS 46
BAKING SODA 3 GRAMS 12
SALT 3 GRAMS 45
CARROTS 150 GRAMS 25
SUGAR 100 GRAMS 42
OIL 100 GRAMS 110
EGG 100 GRAMS 14
VANILLA 5 GRAMS 20
BAKING POWDER 5 GRAMS 16
ORANGE 25 GRAMS 25
APF 45 GRAMS 46
POWDERED MILK 33 GRAMS 13
CINNAMON 2 GRAMS 70
BUTTER MELTED 28 GRAMS 60
BROWN SUGAR 25 GRAMS 20
CHOCOLATE CHIPS 20 GRAMS 125
CASHEW 20 GRAMS 90
RAISINS 15 GRAMS 90
TOTAL WEIGHT 929 TOTAL AP COST 869

OTHER EXPENSES
GASUL 20
LABOR
PACKAGING 10
TOTAL CAPITAL 173.513714285714

YIELD 2
COST PER PORTION 86.7568571428571
SRP 126.756857142857
130
READ

AMOUNT UNIT OF MEASUR UNIT COST


1000 G 11.5
125 G 0.288
500 G 0.27
150 G 25
1000 G 4.2
1200 G 9.16666666666667
100 G 14
700 G 0.142857142857143
30 G 2.66666666666667
25 G 25
1000 G 2.07
33 G 13
30 G 4.66666666666667
200 G 8.4
500 G 1
350 G 7.14285714285714
200 G 9
225 G 6
TOTAL UNIT COST 143.513714285714

20

21

3
61.5045714285714
91.5045714285714
90
RECIPE COSTING- SPANISH BREAD

INGREDIENTS QUANTITY UNIT OF MEASUREMENT COST/PRICE


APF 250 GRAMS 46
BAKING SODA 3 GRAMS 12
SALT 3 GRAMS 45
BANANA 100 GRAMS 20
SUGAR 60 GRAMS 42
OIL 100 GRAMS 110
EGG 100 GRAMS 14
VANILLA 5 GRAMS 20
BAKING POWDER 5 GRAMS 16
APF 45 GRAMS 46
EVAP 245 GRAMS 26
CINNAMON 4 GRAMS 70
BUTTER MELTED 28 GRAMS 60
BROWN SUGAR 25 GRAMS 20
CHOCOLATE CHIPS 20 GRAMS 125
CASHEW 20 GRAMS 90
RAISINS 15 GRAMS 45
TOTAL WEIGHT 1028 TOTAL AP COST 807

OTHER EXPENSES
GASUL/GAS 20
LABOR
PACKAGING 10
TOTAL CAPITAL 151.466597168597

YIELD medium loaf 2


COST PER YIELD 75.7332985842986
SRP 115.733298584299
120
READ

AMOUNT UNIT OF MEASUR UNIT COST


1000 G 11.5
125 G 0.288
500 G 0.27
100 G 20
1000 G 2.52
1200 G 9.16666666666667
100 G 14
700 G 0.142857142857143
30 2.66666666666667
1000 2.07
370 17.2162162162162
30 9.33333333333333
200 8.4
500 1
350 7.14285714285714
200 9
100 6.75
TOTAL UNIT COST 121.466597168597

20

15
156.4665971686

3
52.15553238953
82.15553238953
80
09/28/20
LOAF MEDIUM PCS.SOLD AMOUNT SALES NET
BANANA CAKE 2 120 240 89
SOLO
BANANA CAKE 2 140 -16

Sep-27
LOAF MEDIUM PCS.SOLD AMOUNT SALES NET
BANANA CAKE 4 120 480 180
SOLO
LUMPIA 2 50 100 40
TOTAL SALES 580 220

LOSS TOTAL LOSS


FREE TASTE 300 -80

Sep-29 LOAF MEDIUM PCS.SOLD AMOUNT SALES NET


BANANA CAKE 2 120 240 90
SOLO
BANANA CAKE 8 80 640 210
GROSS SALES 880
NET SALES (LESS RESELLER) 820

CARROT CAKE PCS.SOLD AMOUNT SALES NET


MEDIUM 2 130 260 80
SOLO 10 90 900 280
GROSS SALES 1160
NET SALES (LESS RESELLER) 1140

TOTAL GROSS SALES 2040


TOTAL NET INCOME 660
LESS TOTAL LOSS 96
564

TOTAL NET SALES 584 (2040-660-96-170-10-520)


-110 DOMINIC
INGREDIENTS QUANTITY UNIT OF MEASU COST/PRICE AMOUNT
APF 450 GRAMS 46 1000
GRAMS 125
SALT 12 GRAMS 45 500
GRAMS 100
SUGAR 150 GRAMS 46 1000
OIL 200 GRAMS 110 1200
EGG 150 GRAMS 21 150
VANILLA 15 GRAMS 20 700
BAKING POWDER 20 GRAMS 16 30
BIRCH TREE 100 GRAMS 24 100
CHEESE 83 GRAMS 55 165
GRAMS 30
GRAMS 200
GRAMS 500
GRAMS 350
GRAMS 200
GRAMS 100
TOTAL WEIGHT 1180 TOTAL AP COST 383

20 TUBS
UNIT OF MEASUREMUNIT COST
G 20.7 23
G 0
G 1.08 2
G 0
G 6.9
G 18.33333
G 21
G 0.428571
10.66667
24
27.66667
0
0
0
0
0
0
TOTAL UNIT COST 130.7752
TARGET SALES
BANANA
Sep-29 LOAF 4 120
SOLO
LETTUCE 40 1 TALI
CHICKEN 40 1/4
SIBUYAS 5
BAWANG 5
BEANS 15 1 GUHIT
CARROTS 25 25
EGG 28
SUGAR 5
KNOERR 6
NUTTS 5
KAMOTE 20
OIL 10
APF 20
CORNSTAR 10
SALT 3
237
RECIPE COSTING- SPANISH BREAD

INGREDIENTS QUANTITY UNIT OF MEASUREMENT COST/PRICE


APF 250 GRAMS 46
BAKING SODA 3 GRAMS 12
SALT 3 GRAMS 45
BANANA 100 GRAMS 15
SUGAR 100 GRAMS 42
OIL 100 GRAMS 110
EGG 100 GRAMS 14
VANILLA 5 GRAMS 20
BAKING POWDER 5 GRAMS 16
MILK 57 GRAMS 26
GRAMS 26
CINNAMON 4 GRAMS 70
GRAMS 60
GRAMS 20

TOTAL DOUGH WEIGHT 727 TOTAL AP COST 522

OTHER EXPENSES
GASUL 30
LABOR 50
PACKAGING 5
TOTAL CAPITAL 155.572929214929

YIELD 14-15
READ

AMOUNT UNIT OF MEASUR UNIT COST


1000 G 11.5
125 G 0.288
500 G 0.27
100 G 15
1000 G 4.2
1200 G 9.16666666666667
100 G 14
700 G 0.142857142857143
30 2.66666666666667
370 4.00540540540541
370 0
30 9.33333333333333
200 0
500 0
1000 0
1000 0
1000 0
TOTAL UNIT COST 70.5729292149292

SRP 6 PESOS EACH


RECIPE COSTING- SPANISH BREAD

INGREDIENTS QUANTITY UNIT OF MEASUREMENT COST/PRICE


APF 180 GRAMS 46
BAKING SODA 8 GRAMS 12
SALT 4 GRAMS 20
COCOA POWDER 60 GRAMS 320
WATER 237 GRAMS 0
OIL 73 GRAMS 110
EGG 50 GRAMS 7
VINEGAR 14 GRAMS 5
SUGAR 200 GRAMS 42

TOTAL DOUGH WEIGHT 826 TOTAL AP COST 562

OTHER EXPENSES
GASUL 30
LABOR 50
PACKAGING 5
TOTAL CAPITAL 133.086333333333

YIELD 15
READ

AMOUNT UNIT OF MEASUR UNIT COST


1000 G 8.28
125 G 0.768
1000 G 0.08
1000 G 19.2
237 G 0
1200 G 6.69166666666667
100 G 3.5
60 G 1.16666666666667
1000 G 8.4
100 0
100 0
100 0
100 0
100 0
1000 0
1000 0
1000 0
TOTAL UNIT COST 48.0863333333333

DESIRED NO.

You might also like