0% found this document useful (0 votes)
1K views161 pages

Bar Inventory Cost Analysis

Uploaded by

james brahmane
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)
1K views161 pages

Bar Inventory Cost Analysis

Uploaded by

james brahmane
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/ 161

Bar Items Master List

Basanti & Co.

Quantity Oty by Cost


per serving Price per Selling
UOM serving per serving Price by
ITEMS (ML,GM) Cost Price Cost per (ML,GM) by glass bottle by glass glass
CHAMPAGNE & SPARKLING
Moet & Chandon Brut 750 312.58 0.417 0.00 750 0.00 0
Chandon Brut 750 154.24 0.206 150 750 30.85 125
Zonin prosecco Brut 750 68.28 0.091 150 750 13.66 65
RED WINE
Shiraz, South Africa Nederburg 750 54.6 0.073 150 750 10.92 60
Shiraz-wood-fired, DE Bortoli 750 92.82 0.124 0 750 0.00 0
Merlot,Dark Horse USA 750 54.6 0.073 150 750 10.92 60
Malbec, Zuccardi Series A 750 70.98 0.095 0 750 0.00 0
Pinot Noir, Boisset Bourgogne 750 129.68 0.173 0 750 0.00 0
Chianti Classico Riserva DOCG 750 159.72 0.213 0 750 0.00 0
WHITE WINE
Chardonnay, Eaglehawk 750 40.3 0.054 150 750 8.06 50
Savignon Blanc, Casillero Del Diablo 750 57.33 0.076 150 750 11.47 60
Chenin Blanc, Sula 750 48.1 0.064 150 750 9.62 60
Sauvignon Blanc Chardonnay, Lindemans 750 37.7 0.050 0 750 0.00 0
Resling, Domaine Trimbach 750 135.14 0.180 0 750 0.00 0
Pinot GriS Reserve, Domaine Trimbach 750 154.25 0.206 0 750 0.00 0
ROSE WINE
Rose, chateau DE Marsan 750 64.15 0.086 150 750 12.83 60
Rose, Rocca Di Montemasi Syrosa 750 69.62 0.093 150 750 13.92 60
VODKA
Absolut 750 135.14 0.180 30 750 5.41 50
Stolichnaya premium 750 129.68 0.173 30 750 5.19 55
Ciroc 750 368.55 0.491 30 750 14.74 65
Grey Goose 750 368.55 0.491 30 750 14.74 65
Belvedere 750 368.55 0.491 30 750 14.74 65
RUM
Bacardi Carta Blanca 750 135.14 0.180 30 750 5.41 50
Captain Morgan spiced Rum 750 308.1 0.411 30 750 12.32 55
Captain Morgan Dark Rum 750 117 0.156 30 750 4.68 55
Malibu 750 143.3 0.191 30 750 5.73 55
GIN
Gordons 750 137.87 0.184 30 1000 5.51 50
Bombay Sapphire 750 137.86 0.184 30 750 5.51 50
Beefeater 750 139.23 0.186 30 750 5.57 40
Hendricks 700 242.97 0.347 30 750 10.41 60

Tanqueray No. 10 750 242.97 0.324 30 750 9.72 60


TEQUILA
Jose Cuervo silver 750 135.14 0.180 30 750 5.41 50
Jose Cuervo Gold 750 135.14 0.180 30 750 5.41 50
Patron XO cafe 750 178.81 0.238 30 750 7.15 60
Patron Sliver 750 296.2 0.395 30 750 11.85 65
COGNAC
Hennessy VS 700 279.83 0.400 30 750 11.99 60
Remy Martin VSOP 700 432.71 0.618 30 750 18.54 70
WHISKEY
BLENDED SCOTCH
Johnnie Walker Blue Label 750 1598.42 2.131 30 750 63.94 185
Johnnie Walker Black Label 750 305.76 0.408 30 750 12.23 55
Johnnie Walker Red Label 750 147.42 0.197 30 750 5.90 45
Chivas Regal 12 yrs 750 305.75 0.408 30 750 12.23 50
Chivas Regal 18 yrs 750 670.21 0.894 30 750 26.81 100
Monkey shoulder 750 241.6 0.322 30 750 9.66 55
AMERICAN/IRISH
Jack Daniels 750 245.7 0.328 30 750 9.83 60
Jameson Irish Whisky 750 237.51 0.317 30 750 9.50 50
JIM Beam 750 171.99 0.229 30 750 6.88 45
SINGLE MALT 0
Talisker 10yrs 750 303.3 0.404 30 750 12.13 65
The Glenlivet 12yrs 750 320.77 0.428 30 750 12.83 65
The Macallan 12yrs 750 424.52 0.566 30 750 16.98 75
The Glenfidich 12yrs 700 320.78 0.458 30 750 13.75 65
The Glenfidich 18yrs 750 559.65 0.746 30 750 22.39 95
LIQUEURS
White Sambuca 700 141.96 0.203 30 750 6.08 55
Jagermeister 700 137.87 0.197 30 750 5.91 55
Khalua 750 159.5 0.213 30 750 6.38 55
Baileys 750 227.96 0.304 30 750 9.12 55
Disaronno 700 120.12 0.172 30 750 5.15 65
Triple sec 700 204.75 0.293 0 750 0.00 0
Blue Curaçao 700 204.75 0.293 0 750 0.00 0
Archers 700 117.39 0.168 0 750 0.00 0
Cointreau 700 153.4 0.219 30 750 6.57 65
MARTINI
Martini Rosso 1000 98.28 0.098 0 1000 0
Martini extra dry 1000 94.19 0.094 0 1000 0
APERITIF
Aperol 700 92.86 0.133 0 700 0.00 0
BITTERS 0 #DIV/0! 0
Orange Bitters 100 57.33 0.573 0 330 0.00 0
Angostura 200 70.98 0.355 0 200 0.00 0
Campari 1000 121.49 0.121 0 1000 0.00 0
BOTTLED BEERS
Heineken 330 10.83 0.033 0 330 0.00 0
Budweiser 330 10.58 0.032 0 330 0.00 0
Kingfisher 330 9.95 0.030 0 330 0.00 0
Corona 380 12.56 0.033 0 330 0.00 0
Magners 330 11.41 0.035 0 330 0.00 0
Hoegarden 330 11.6 0.035 0 330 0.00 0
DRAUGHT
Heineken (20L) 20000 624.35 0.031 380 20000 11.86 50
Brewdog Punk IPA (30L) 30000 1196 0.040 380 30000 15.15 60
BEVERAGES
Coke 300 2.06 0.007 0 300 0.00 0
Coke lite 300 2.06 0.007 0 300 0.00 0
Sprite 300 2.06 0.007 0 300 0.00 0
Fanta 300 2.06 0.007 0 300 0.00 0
Tonic water 330 2.72 0.008 0 330 0.00 0
Ginger Ale 330 2.72 0.008 0 330 0.00 0
Soda water 330 1.67 0.005 0 330 0.00 0
Red Bull 330 0.000 0 330 0.00 0
Avian Still 750 6.80 0.009 0 750 0.00 0
Perrier 750 6.40 0.009 0 750 0.00 0
TEA/COFFEE
English Breakfast 300 0.90 0.003 0 0.90 25
Earl Grey 300 0.90 0.003 0 0.90 25
Morrocan Mint 300 0.90 0.003 0 0.90 25
Lemon Ginger 300 0.90 0.003 0 0.90 25
Rosehip 300 0.90 0.003 0 0.90 25
Green 300 0.90 0.003 0 0.90 25
Camomile 300 0.90 0.003 0 0.90 25
Arabica Beans 1 kg 1000 148.42 0.148 0 0.00 0
SYRUPS
Passion Fruit Syrup 1000 44.10 0.044 0 0.00 0
Strawberry Syrup 1000 44.10 0.044 0 0.00 0
Mojito Syrup 1000 44.10 0.044 0 0.00 0
Watermelon Syrup 1000 44.10 0.044 0 0.00 0
Cucumber Syrup 1000 44.10 0.044 0 0.00 0
Grenadine 1000 44.10 0.044 0 0.00 0
Vanilla Syrup 700 46.00 0.066 0 0.00 0
Caramel Syrup 1000 46.00 0.046 0 0.00 0
Maple Syrup 700 46.00 0.066 0 0.00 0
Roohafza Syrup 800 9.75 0.012 0 0.00 0
Lavender Syrup 700 44.10 0.063 0 0.00 0
Orgeat Syrup 700 44.10 0.063
Sun Dried Syrup 700 46.00 0.066 0 0.00 0
JUICES
Guava Nectar 1000 4.55 0.005 0 0.00 0
Mango Nectar 1000 4.55 0.005 0 0.00 0
Pineapple juice 1000 3.68 0.004 0 1000 0.00 0
Orange Juice 1000 3.68 0.004 0 1000 0.00 0
Tomato juice 1000 4.55 0.005 0 1000 0.00 0
Apple juice 1000 3.68 0.004 0 1000 0.00 0
Pomegranate Juice 1000 0.000 0 1000 0.00 0
Cranberry juice 1000 4.55 0.005 0 1000 0.00 0
Grapefruit juice 1000 5.68 0.006 0 1000 0.00 0
OTHERS
Aam Panna Mixture #DIV/0!
Apple Green 1000 5.54 0.006
Blackberry 125 15.16 0.121
Blueberry 125 12.04 0.096
Brown Sugar Cubes 500 15.75 0.032
Cardamom Green 1000 194.25 0.194
Chili Red Birdeye 100 4.66 0.047
Cinnamon Sticks 1000 26.25 0.026
Cloves 1000 19.95 0.020
Coconut Cream 400 4.50 0.011
Fresh Milk 2000 12.10 0.006
Ginger Root 1000 7.50 0.008
Honey 500 5.69 0.011
Ice 1000 4.50 0.005
Lemon Zest 1000 3.47 0.003
Lemon 1000 3.47 0.003
Lemon Grass 1000 18.35 0.018
Lime 1000 7.35 0.007
Mango Green 1000 10.50 0.011
Mango Pulp 850 25.00 0.029
Mango Ripe 1000 14.18 0.014
Mint 1000 8.30 0.008
Mixed Spice 100 3.31 0.033
Orange Zest 1000 3.84 0.004
Orange (Garnish) 1000 3.84 0.144
Passion Fruit 1000 25.20 0.025
Pepper 100 7.69 0.077
Pineapple ( Garnish ) - Dehydrated 1000 6.20 0.124
Pomegranate 1000 1.67 0.002
Rosemary (Garnish) 1000 60.67 0.182
Saffron 4 63.00 15.750
Salt 1000 2.63 0.003
Shikanji Powder 45 8.00 0.178
Star Anise 1000 72.00 0.072
Strawberry ( Garnish ) 250 8.40 0.420
Strawberry Puree 1000 44.12 0.044
Tabasco 60 9.00 0.150
Thandai Powder 100 5.25 0.053
Turmeric 1000 4.53 0.005
Watermelon 1000 2.60 0.003
Worcestershire Sauce 150 11.10 0.074
Sugar Syrup 750 1.70 0.002
Yoghurt 1000 7.50 0.008
Lemon (Garnish) - Dehydrated 1000 3.47 0.069
Chilli powder garnish
Lemon Juice 750 6.94 0.009
Lemon Grass - infused Gin 750 142.4475 0.190 5.6979
Ginger Root - infused Vodka 750 131.555 0.175 5.2622
Turmeric & Lemon - infused Vodka 750 131.5576 0.175 5.262304
Cinnamon - infused Bourbon 750 187.6125 0.250 7.5045
Orange - infused Whiskey 750 149.148 0.199 5.96592
Coffee - infused Bourbon 750 201.674 0.269 8.06696
Orange Peel (Garnish) 1000 3.84 0.864 0
Green Apple Peel (Garnish) 1000 5.54 1.828 0
Red Apple Peel (Garnish) 1000 0.000 0
Tea Loose 5000 105 0.021 0.021
Celery sticks 1000
Total Total
Selling selling Selling Cost Cost %
Priceby price by Price by Percentage W/o Tax
bottle glass Bottle w/o tax bottle

750 0 877.5 0.00% 41.68%


400 146.25 468 24.68% 38.56%
300 76.05 351 21.01% 22.76%

200 70.2 234 18.20% 27.30%


300 0 351 0.00% 30.94%
200 70.2 234 18.20% 27.30%
250 0 292.5 0.00% 28.39%
350 0 409.5 0.00% 37.05%
500 0 585 0.00% 31.94%

200 58.5 234 16.12% 20.15%


250 70.2 292.5 19.11% 22.93%
250 70.2 292.5 16.03% 19.24%
300 0 351 0.00% 12.57%
300 0 351 0.00% 45.05%
500 0 585 0.00% 30.85%

250 70.2 292.5 21.38% 25.66%


275 70.2 321.75 23.21% 25.32%

800 58.5 936 10.81% 16.89%


850 64.35 994.5 9.43% 15.26%
1300 76.05 1521 22.68% 28.35%
1300 76.05 1521 22.68% 28.35%
1300 76.05 1521 22.68% 28.35%
800 58.5 936 10.81% 16.89%
1000 64.35 1170 22.41% 30.81%
850 64.35 994.5 8.51% 13.76%
850 64.35 994.5 10.42% 16.86%

850 58.5 994.5 11.03% 16.22%


850 58.5 994.5 11.03% 16.22%
850 46.8 994.5 13.92% 16.38%
950 70.2 1111.5 17.36% 25.58%

950 70.2 1111.5 16.20% 25.58%

850 58.5 994.5 10.81% 15.90%


950 58.5 1111.5 10.81% 14.23%
1000 70.2 1170 11.92% 17.88%
1250 76.05 1462.5 18.23% 23.70%

1100 70.2 1287 19.99% 25.44%


1650 81.9 1930.5 26.49% 26.22%

4100 216.45 4797 34.56% 38.99%


1100 64.35 1287 22.24% 27.80%
0 52.65 0 13.10% 0.00%
1100 58.5 1287 24.46% 27.80%
2100 117 2457 26.81% 31.91%
1200 64.35 1404 17.57% 20.13%

1200 70.2 1404 16.38% 20.48%


1150 58.5 1345.5 19.00% 20.65%
1000 52.65 1170 15.29% 17.20%
0 0 0 0.00% 0.00%
1100 76.05 1287 18.66% 27.57%
1100 76.05 1287 19.74% 29.16%
1650 87.75 1930.5 22.64% 25.73%
1150 76.05 1345.5 21.15% 27.89%
2000 111.15 2340 23.56% 27.98%

950 64.35 1111.5 11.06% 14.94%


950 64.35 1111.5 10.74% 14.51%
1000 64.35 1170 11.60% 15.95%
1100 64.35 1287 16.58% 20.72%
950 76.05 1111.5 7.92% 12.64%
1100 0 1287 0.00% 18.61%
1100 0 1287 0.00% 18.61%
950 0 1111.5 0.00% 12.36%
950 76.05 1111.5 10.11% 16.15%

900 0 1053 0.00% 10.92%


900 0 1053 0.00% 10.47%

0 0 0 0.00% 0.00%
0 0 0
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%

50 0 58.5 0.00% 21.66%


50 0 58.5 0.00% 21.16%
50 0 58.5 0.00% 19.90%
55 0 64.35 0.00% 22.84%
55 0 64.35 0.00% 20.75%
55 0 64.35 0.00% 21.09%

0 58.5 0 23.73% 0.00%


0 70.2 0 25.25% 0.00%

25 0 29.25 0.00% 8.24%


25 0 29.25 0.00% 8.24%
25 0 29.25 0.00% 8.24%
25 0 29.25 0.00% 8.24%
25 0 29.25 0.00% 10.88%
25 0 29.25 0.00% 10.88%
25 0 29.25 0.00% 6.68%
25 0 29.25 0.00% 0.00%
20 0 23.4 0.00% 34.00%
25 0 29.25 0.00% 25.60%

0 29.25 0 3.60% 0.00%


0 29.25 0 3.60% 0.00%
0 29.25 0 3.60% 0.00%
0 29.25 0 3.60% 0.00%
0 29.25 0 3.60% 0.00%
0 29.25 0 3.60% 0.00%
0 29.25 0 3.60% 0.00%
0 0 0 0.00% 0.00%

0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%

0 0 0 0.00% 0.00%

0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
0 0 0 0.00% 0.00%
Unit
Item Cost Price 30 ml Usage Usage Cost
(ML/GM)
Lemon Grass - infused Gin 750 142.4475 5.6979
Bombay Sapphire 750 137.86
Lemon Grass 250 4.5875
Total Batch Cost

Ginger Root - infused Vodka 750 131.555 5.2622


Stolichnaya premium 750 129.68
Ginger Root 250 1.875
Total Batch Cost

Turmeric & Lemon - infused Vodka 750 131.5576 5.262304


Stolichnaya premium 750 129.68
Turmeric 200 0.906
Lemon Zest 280 0.9716
Total Batch Cost

Cinnamon - infused Bourbon 750 187.6125 7.5045


JIM Beam 750 171.99
Star Anise 50 3.6
Cinnamon Sticks 50 1.3125
Cloves 50 0.9975
Cardamom Green 50 9.7125
Total Batch Cost

Orange - infused Whiskey 750 149.148 5.96592


Johnnie Walker Red Label 750 147.42
Orange Zest 450 1.728
Total Batch Cost

Coffee - infused Bourbon 750 201.674 8.06696


JIM Beam 750 171.99
Arabica Beans 1 kg 200 29.684
Total Batch Cost
Cocktail Recipe w/ Cost

Product Name: Lemon Drop Martini


Category: House Cocktail
Selling Price: 75 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Turmeric & Lemon - infused Vodka 0.17541 60 10.5246
Triple sec 0.2925 15 4.3875
Lemon Juice 0.009253 15 0.1388
Sugar Syrup 0.002268 15 0.03402
Ice 0.0045 100 0.45
Lemon (Garnish) - Dehydrated 0.0694 1 0.0694

Total Product Cost 15.60


Cocktail Recipe w/ Cost

Product Name: Caught Red Handed


Category: House Cocktail
Selling Price: 75 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Zonin prosecco Brut 0.09104 150 13.656
Disaronno 0.1716 30 5.148
Strawberry Puree 0.04412 15 0.6618

Total Product Cost 19.47


Cocktail Recipe w/ Cost

Product Name: Rhubarb and Strawberry CinCin


Category: House Cocktail
Selling Price: 75 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Lemon Grass - infused Gin 0.18993 60 11.3958
Aperol 0.132657 30 3.97971
Lemon Juice 0.009253 15 0.1388
Sugar Syrup 0.002268 30 0.06804
Ice 0.0045 100 0.45
Strawberry ( Garnish ) 0.42 1 0.42

Total Product Cost 16.45


0.0336
Cocktail Recipe w/ Cost

Product Name: Love Potion


Category: House Cocktail
Selling Price: 75 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Stolichnaya premium 0.172907 60 10.3744
Pineapple juice 0.00368 30 0.1104
Cranberry juice 0.00455 30 0.1365
Grenadine 0.0441 15 0.6615
Lemon Juice 0.009253 15 0.1388
Orgeat Syrup 0.063 15 0.945
Blue Curaçao 0.2925 30 8.775
Ice 0.0045 100 0.45

Total Product Cost 21.59


Cocktail Recipe w/ Cost

Product Name: Pretty Pink


Category: House Cocktail
Selling Price: 75 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Jose Cuervo silver 0.180187 60 10.8112
Lemon Juice 0.009253 15 0.1388
Grenadine 0.0441 10 0.441
Sugar Syrup 0.002268 10 0.02268
Grapefruit juice 0.00568 120 0.6816
Soda water 0.005061 90 0.45545
Ice 0.0045 100 0.45
Orange Peel (Garnish) 0.864 1 0.864
Green Apple Peel (Garnish) 1.8282 1 1.8282
Red Apple Peel (Garnish) 0 0

Total Product Cost 15.69


Cocktail Recipe w/ Cost

Product Name: Jungle Bird


Category: House Cocktail
Selling Price: 75 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Captain Morgan Dark Rum 0.156 60 9.36
Campari 0.12149 30 3.6447
Pineapple juice 0.00368 120 0.4416
Lemon Juice 0.009253 15 0.1388
Sugar Syrup 0.002268 15 0.03402
Ice 0.0045 100 0.45
Pineapple ( Garnish ) - Dehydrated 0.124 1 0.124

Total Product Cost 14.19


Cocktail Recipe w/ Cost

Product Name: Cacophony


Category: House Cocktail
Selling Price: 75 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Coffee - infused Bourbon 0.268899 60 16.1339
Khalua 0.212667 30 6.38
Vanilla Syrup 0.065714 25 1.64286
Ice 0.0045 100 0.45

Total Product Cost 24.61


Cocktail Recipe w/ Cost

Product Name: Monsoon


Category: House Cocktail
Selling Price: 75 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Ginger Root - infused Vodka 0.175407 60 10.5244
Mango Nectar 0.00455 120 0.546
Strawberry Syrup 0.0441 10 0.441
Ice 0.0045 100 0.45
Mango (Garnish) #N/A 1

Total Product Cost 11.96


Cocktail Recipe w/ Cost

Product Name: Buzz-anti Old Fashioned


Category: House Cocktail
Selling Price: 75 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Orange - infused Whiskey 0.198864 60 11.9318
Maple Syrup 0.065714 30 1.97143
Angostura 0.3549 2.00 0.7098
Orange Bitters 0.5733 2 1.1466
Ice 0.0045 100 0.45
Orange (Garnish) 0.144 1 0.144

Total Product Cost 16.35


Cocktail Recipe w/ Cost

Product Name: Cart No. SE-02


Category: House Cocktail
Selling Price: 75 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Johnnie Walker Red Label 0.19656 60 11.7936
Pomegranate 0.00167 60 0.1002
Lemon Juice 0.009253 15 0.1388
Disaronno 0.1716 30 5.148
Ice 0.0045 100 0.45
Sugar Syrup 0.002268 15 0.03402

Total Product Cost 17.66


Cocktail Recipe w/ Cost

Product Name: Rooh Afza Cosmopolitan


Category: House Cocktail
Selling Price: 75 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Stolichnaya premium 0.172907 60 10.3744
Cranberry juice 0.00455 60 0.273
Roohafza Syrup 0.012188 10 0.12188
Lemon Juice 0.009253 15 0.1388
Triple sec 0.2925 15 4.3875
Ice 0.0045 100 0.45
Orange (Garnish) 0.144 1 0.144

Total Product Cost 15.89


Cocktail Recipe w/ Cost

Product Name: Chai Tea Bourbon


Category: House Cocktail
Selling Price: 75 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
JIM Beam 0.22932 60 13.7592
Maple Syrup 0.065714 30 1.97143
Tea Loose 0.021 5 0.105
Fresh Milk 0.00605 15 0.09075
Ice 0.0045 100 0.45
Rosemary (Garnish) 0.18201 1 0.18201

Total Product Cost 16.56


Cocktail Recipe w/ Cost

Product Name: She Said Yes


Category: House Cocktail
Selling Price: 75 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Zonin prosecco Brut 0.09104 150 13.656
Strawberry Puree 0.04412 30 1.3236
Strawberry ( Garnish ) 0.42 1.00 0.42

Total Product Cost 15.40


Cocktail Recipe w/ Cost

Product Name: Bloody Mary


Category: Classic Cocktail
Selling Price: 65 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Stolichnaya premium 0.172907 60 10.3744
Tomato juice 0.00455 120 0.546
Lemon Juice 0.009253 15 0.1388
Tabasco 0.15 2.5 0.375
Salt 0.00263 3 0.00789
Pepper 0.0769 2 0.1538
Ice 0.0045 100 0.45
Worcestershire Sauce 0.074 2.5 0.185
Celery Stick (Garnish) #N/A #N/A

Total Product Cost

Worcestershire Sauce
Cocktail Recipe w/ Cost

Product Name: Sex On The Beach


Category: Classic Cocktail
Selling Price: 65 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Stolichnaya premium 0.172907 60
Archers 0.1677 30
Cranberry juice 0.00455 60
Orange Juice 0.00368 60
Ice 0.0045
Orange (Garnish) 0.144

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Pina Colada


Category: Classic Cocktail
Selling Price: 65 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Bacardi Carta Blanca 0.180187 60
Malibu 0.191067 30
Coconut Cream 0.01125 30
Pineapple juice 0.00368 120
Sugar Syrup 0.002268 15
Ice 0.0045
Pineapple (Garnish) #N/A

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Mojito


Category: Classic Cocktail
Selling Price: 65 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Bacardi Carta Blanca 0.180187 60
Lime Wedge #N/A
Mint 0.0083
Lemon Juice 0.009253 15
Sugar Syrup 0.002268 15
Soda water 0.005061 330
Ice 0.0045
Mint Leaves (Garnish #N/A
Lime Wheel (Garnish) #N/A

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Whiskey Sour


Category: Classic Cocktail
Selling Price: 65 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
JIM Beam 0.22932 60
Angostura 0.3549
Lemon Juice 0.009253 30
Sugar Syrup 0.002268 30
Ice 0.0045
Orange (Garnish) 0.144

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Mint Julep


Category: Classic Cocktail
Selling Price: redl AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Johnnie Walker Red Label 0.19656 60
Mint Leaves #N/A
Lemon Juice 0.009253 15
Sugar Syrup 0.002268 15
Ice 0.0045
Mint Leaves (Garnish) #N/A

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Hot Toddy


Category: Classic Cocktail
Selling Price: 65 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Hennessy VS 0.399757 60
Honey 0.01138 15
Mixed Spice 0.0331
Celery #N/A
Dehydrated Lime #N/A
Total Product Cost
Cocktail Recipe w/ Cost

Product Name: Between The Sheets


Category: Classic Cocktail
Selling Price: 65 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Hennessy VS 0.399757 30
Bacardi Carta Blanca 0.180187 30
Triple sec 0.2925 15
Lemon Juice 0.009253 30
Ice 0.0045 100
Sugar Syrup 0.002268 15
Total Product Cost
Cocktail Recipe w/ Cost

Product Name: Negroni


Category: Classic Cocktail
Selling Price: 65 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Bombay Sapphire 0.183813 60
Martini Rosso 0.09828 30
Campari 0.12149 30
Orange (Garnish) 0.144

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Classic Martini


Category: Classic Cocktail
Selling Price: 65 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Gordons 0.183827 60
Martini extra dry 0.09419 30
Ice 0.0045
Olives #N/A
Total Product Cost
Cocktail Recipe w/ Cost

Product Name: Tequila Sunrise


Category: Classic Cocktail
Selling Price: 65 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Jose Cuervo silver 0.180187 60
Triple sec 0.2925 15
Orange Juice 0.00368 120
Grenadine 0.0441 10
Ice 0.0045
Orange (Garnish) 0.144

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Margarita


Category: Classic Cocktail
Selling Price: 65 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Jose Cuervo silver 0.180187 60
Triple sec 0.2925 30
Lemon Juice 0.009253 15
Sugar Syrup 0.002268 15
Ice 0.0045
salt 0.00263
Total Product Cost
Cocktail Recipe w/ Cost

Product Name: Spicy Guava


Category: Mocktail
Selling Price: 50 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Guava Nectar 0.00455 150
Lemon Juice 0.009253 15
Tabasco 0.15
Ice 0.0045
Chili (Garnish) #N/A
Chilli powder garnish
Total Product Cost
Cocktail Recipe w/ Cost

Product Name: Aam Panna


Category: Mocktail
Selling Price: 50 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Aam Panna Mixture #DIV/0! 90
Sprite 0.006867 300
Lime Wedge (Garnish) #N/A
Mint Sprigs (Garnish) #N/A
Ice 0.0045

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Thandai


Category: Mocktail
Selling Price: 50 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Fresh Milk 0.00605 150
Sugar Syrup 0.002268 15
Thandai Powder 0.0525 10.00
Saffron 15.75 0.001
Ice 0.0045

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Cool As Cucumber


Category: Mocktail
Selling Price: 50 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Cucumber Syrup 0.0441 20
Lavender Syrup 0.063 20
Lemon Juice 0.009253 15
Sprite 0.006867 300
Ice 0.0045
Cucumber (Garnish) #N/A
Rosemary (Garnish) 0.18201

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Shikanji


Category: Mocktail
Selling Price: 25 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Shikanji Powder 13 0.177778 2.5
Lemon Juice 0.009253 15
Sprite 0.006867 300
Lime Wedge (Garnish) #N/A
Mint Leaves (Garnish) #N/A
Ice 0.0045

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Nojito


Category: Mocktail
Selling Price: 50 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Mojito Syrup 0.0441 30
Lemon Juice 0.009253 15
Sprite 0.006867 300
Ice 0.0045
Lemon Wedge (Garnish) #N/A
Mint Leaves (Garnish) #N/A

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Lemon Mint


Category: Mocktail
Selling Price: 50 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Lemon Juice 0.009253 30
Sugar Syrup 0.002268 15
Mint 0.0083
Sprite 0.006867 300
Ice 0.0045
Lemon Wedge (Garnish) #N/A
Mint Leaves (Garnish) #N/A

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Shirley Temple


Category: Mocktail
Selling Price: 50 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Ginger Ale 0.008242 330
Grenadine 0.0441 15
Lemon Juice 0.009253 15
Ice 0.0045
Salt 0.00263
Pepper 0.0769
Ice 0.0045
Celery Stick (Garnish) #N/A

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Bloody Maria


Category: Mocktail
Selling Price: 50 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Tomato juice 0.00455 150
Lemon Juice 0.009253 15
Worcestershire Sauce 0.074
Tabasco 0.15
Salt 0.00263
Pepper 0.0769
Ice 0.0045
Celery Stick (Garnish) #N/A

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Mango Lassi


Category: Mocktail
Selling Price: 50 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Yoghurt 7 0.0075 333.33
Mango Pulp 0.029412 150
saffron 15.75 0.001

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Mint Lassi


Category: Mocktail
Selling Price: 50 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Yoghurt 7 0.0075 333.33
Mint 0.0083 4

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Salty Lassi


Category: Mocktail
Selling Price: 50 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Yoghurt 7 0.0075 333.33
Salt 0.00263 1.5
Mint 0.0083 1

Total Product Cost


Cocktail Recipe w/ Cost

Product Name: Sweet Lassi


Category: Mocktail
Selling Price: 50 AED

Basanti & Co.

Cost
Cost Price Price
per Pack / per Total
Item BTL Gm/ ML Usage Cost
Yoghurt 7 0.0075 333.33
Sugar Syrup 0.002268 15
saffron 15.75 0.001

Total Product Cost

You might also like