0% found this document useful (0 votes)
13 views6 pages

Pricing

The document provides a detailed breakdown of ingredients, their quantities, costs, and total expenses for various recipes, including chocolate-based items and baked goods. It also includes inventory items with their respective quantities and costs, along with calculations for selling prices and final selling prices. Overall, it presents a comprehensive overview of ingredient costs and pricing strategies for multiple products.

Uploaded by

utsavmistry22
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
13 views6 pages

Pricing

The document provides a detailed breakdown of ingredients, their quantities, costs, and total expenses for various recipes, including chocolate-based items and baked goods. It also includes inventory items with their respective quantities and costs, along with calculations for selling prices and final selling prices. Overall, it presents a comprehensive overview of ingredient costs and pricing strategies for multiple products.

Uploaded by

utsavmistry22
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 6

ingredients QTY cost total

Dark chocolate 187 1623 304 46.75 140.25


Salted Butter 61 590 36 15.25 45.75
Condesed Milk 300 380 114 75 225
Flour 51 60 3.06 12.75 38.25
Coco Powder 28 1120 31 7 21
Baking Powder 1.8 360 0.65 0.45 1.35
Coffee Powder 1.5 3000 4.5 0.375 1.125
water 3.75 20 0.08 0.9375 2.8125
Total 634.05 493 158.5125 475.5375
no of piece 8
price per piece 61.642
selling price 184.93
packging price 25
final selling price 209.93
inventory Items Quantity cost total
Butter 34 590 20.06
sugsr 25 105 2.625
milk 10 70 0.7
custard pwdr 10 400 4
flour 45 55 2.475
milk pwdr 12 650 7.8
coconut milk pwdr 20 1000 20
baking soda 1 330 0.33
pista 20 800 16
almomd 50 800 40
cashew 30 1000 30
cranberry 40 650 26
tutti frutti 20 180 3.6
dry apricot 20 1200 24
total 337 6750 197.59
no of piece 16
price per piece 12.349375
pack of 5 61.746875
selling price 185.240625
packing price 16
final selling price 201.240625
inventory Items Quantity cost total
butter 100 590 59
brown sugar 55 110 6.05
salt 2 18 0.036
cream 20 220 4.4
flour 100 55 5.5
baking powder 4 360 1.44
chocolate chips 100 260 26
milk powder 8 650 5.2

total 389 2263 107.626


gram per piece 20
cookie per recepie 19.45
cost per cookie 5.533470437
pack of 5 27.66735219
selling price 83.00205656
packing price 16
final selling price 99.00205656
inventory ItemQuantity cost total inventory ItemQuantity
butter 120 590 70.8 potato whip 4
brownsugar 125 110 13.75 water 37.5
honey 115 475 54.625 icing sugar 250
amul cream 45 220 9.9 lemon 10
flour 450 55 24.75
salt 1.5 18 0.027
ginger powder 3.5 800 2.8
clove powder 0.5 2200 1.1
cinnamon pow 1 3000 3
baking soda 0.5 330 0.165
baking powder 0.5 360 0.18

total 862.5 181.097 total 301.5


gram per cook 20
pieces per rec 43.125
cost per piece 4.199350725
royal icing 1.972173913
total 6.171524638
selling price 30.85762319
packing price 5
final selling pr 35.85762319
cost total
14000 56
20 0.75
110 27.5
80 0.8

85.05
1.972173913
inventory Items Quantity

inventory Items Quantity

You might also like