0% found this document useful (0 votes)
788 views14 pages

Beverage Costing

The document lists cost prices and proposed selling prices for various alcoholic and non-alcoholic drinks. It includes information on drink sizes, number of shots per bottle, cost per bottle and total, as well as proposed increases to bottle and total prices. Drink categories include soft drinks, juices, beers, spirits like vodka, whisky and rum, liqueurs and shooters.

Uploaded by

Kenn G Munyeki
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)
788 views14 pages

Beverage Costing

The document lists cost prices and proposed selling prices for various alcoholic and non-alcoholic drinks. It includes information on drink sizes, number of shots per bottle, cost per bottle and total, as well as proposed increases to bottle and total prices. Drink categories include soft drinks, juices, beers, spirits like vodka, whisky and rum, liqueurs and shooters.

Uploaded by

Kenn G Munyeki
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/ 14

Cost Price ToT/Glass

Unit of Measure

Cost PrIce Btl


Bottle size ML

# 25 ml Shots
Items

SOFT DRINKS
Orange 300 ml 224
Citron 300 ml 224
Vitalo 300 ml 224
Stoney 300 ml 420
Fiesta 300 ml 224
Coca Zero 300 ml 224
Coca Cola 300 ml 224
Sprite 300 ml 224
Tonic 300 ml 224
Water Inyange 500 ml 181
Aqua Sipi 500 ml 181
Juices
Apple 1,440
Passion 1,375
Pineapple 1,375
Mango 1,440
Beers
Mutzing 330 ml 348
Mutzing Lite 330 ml 348
Amstel 330 ml 486
Skol Lager 330 ml 512
Skol Malt 330 ml 512
Tusker Lager 500 ml 610
Tusker Malt 330 ml 610
Primus 330 ml 413
Legend 330 ml 415
Leffe 330 ml 1,907
Smirnoff ice black 330 ml 636
Panache Lemon 330 ml 438
Panache Passion 330 ml 438
Guinness 330 ml 636
Heineken 330 ml 694
Draught beer 20000 ml 40 23,475 587
Bavaria Alcohol 500 ml 1,700
virunga mist 330 ml 424
virunga gold 330 ml 424
Smirnoff Guaranna 500 ml 900
Energy Drinks
Red Bull 250 ml 1,264
Bavaria Non Alcoholic 500 ml 1,307
Vodka 1 2 3 4 5
Grey Goose 1000 ml 40 35,593 890
Ciroc Vodka 1000 ml 40 45,763 1,144
Belvedere blue 1000 ml 40 32,203 805
Belvedere Citrus 1000 ml 40 32,203 805
Absolute Citron 1000 ml 40 14,407 360
Absolute Mandrine 1000 ml 40 14,406 360
Absolute Apeach 1000 ml 40 14,406 360
Absolute Vanilla 1000 ml 40 14,406 360
Absolute Rasberry 1000 ml 40 14,406 360
Smirnoff Vodka 1000 ml 40 13,000 325
Absolute Vodka 1000 ml 40 13,983 350
Whiskies - Single Malts
Glenfiddich 1000 ml 40 44,068 1,102
Glenmorangie
Glenlivet
Premium Whiskies
Johnny Walker Blue Label 1000 ml 40 205,084 5,127
Johhny Walker Gold label 1000 ml 40 52,542 1,314
Johnny Walker Double Black 1000 ml 40 37,288 932
Johnny Walker Black Label 1000 ml 40 32,203 805
Jack Daniels 1000 ml 40 27,966 699
Jack Daniels Honey 1000 ml 40 27,118 678
Chivas Regal 1000 ml 40 25,423 636
Regular Whiskies
Jameson 1000 ml 40 21,186 530
Ballantines 1000 ml 40 18,644 466
Johny Walker Red Label 1000 ml 40 14,406 360
J&B 1000 ml 40 14,406 360
Famous Grouse 1000 ml 40 14,406 360
Label 5 black 1000 ml 40 18,000 450
Label 5 blue 1000 ml 40 18,000 450
Grants 1000 ml 40 13,135 328
Gin
Bombay Sapphire 1000 ml 40 35,593 890
Gordon's Gin 1000 ml 40 14,407 360
Uganda Waragi 750 ml 30 6,355 212
Beefeater 1000 ml 40 28,000 700
Cognac
Remy Martin V.S.O.P 1000 ml 40 47,457 1,186
Hennessy V.S 1000 ml 40 35,593 890
Hennessy V.S.O.P 1000 ml 40 56,780 1,420
Martel V.S.O.P 1000 ml 40 51,694 1,292
Martel V.S 1000 ml 40 33,050 826
Courvosier V.S 1000 ml 40 39,830 996
Courvosier V.S.O.P 1000 ml 40 44,067 1,102
RUM
Bacardi White 1000 ml 40 13,559 339
Bacardi Dark 1000 ml 40 14,406 360
Captain Morgan Spiced 1000 ml 40 15,254 381
Captain Morgan Dark 1000 ml 40 14,406 360
Malibu 1000 ml 40 20,339 508
Bacardi Gold 1000 ml 40 13,559 339
Apperitif
Cinzano White 1000 ml 40 11,864 297
Cinzano Rosso 1000 ml 40 17,000 425
Martini Rosso 1000 ml 40 19,491 487
Martin White 1000 ml 40 11,864 297
Martin Dry 1000 ml 40 17,796 445
Bailey's 1000 ml 40 19,491 487
Amarula 1000 ml 40 18,220 456
Tia Maria 1000 ml 40 18,644 466
Tequilla camino 750 ml 30 17,712 590
Cointreau 1000 ml 40 25,424 636
Grand Marnier 700 ml 28 30,000 1,071
Sandeman Porto 1000 ml 40 22,033 551
Crème De Cassis 1000 ml 40 15,254 381
AmarettoDISARONNO 1000 ml 40 34,000 850
Jagermeister 1000 ml 40 22,881 572
Sheridan's 1000 ml 40 25,423 636
Zappa Blue 750 ml 50 11,017 220
Zappa green 750 ml 50 11,017 220
Zappa Red 750 ml 50 11,017 220
Campari 1000 ml 40 20,000 500
Kahlua 1000 ml 40 21,186 530
Drambuie 1000 ml 40 45,000 1,125
Proposed Selling Price
TOT Selling Price 25%

Proposed Selling Price


Btl Selling Price 25%

Btl

TOT/Glass
896 - 1,500
896 - 1,500
896 - 1,500
1,680 - 1,500
896 - 1,500
896 - 2,000
896 - 1,500
896 - 1,500
896 - 1,500
724 - 1,500
724 - 1,500

5,760 -
5,500 - 4,000
5,500 - 4,000
5,760 - 4,000

1,392 - 2,000
1,392 - 2,000
1,944 - 2,000
2,048 - 2,000
2,048 - 2,000
2,440 - 2,500
2,440 - 2,500
1,652 - 2,000
1,660 - 2,000
7,628 - 3,000
2,544 - 2,500
1,752 - 1,500
1,752 - 1,500
2,544 - 2,000
2,776 - 2,500
93,900 2,348 2,500
6,800 - 4,000
1,696 - 2,000
1,696 - 2,000
3,600 - 2,500

5,056 - 3,000
5,228 - 2,500
6 7 8 9
142,372 3,559 150,000 4000
183,052 4,576 150,000 5000
128,812 3,220 140,000 4000
128,812 3,220 140,000 4000
57,628 1,441 57,000 2000
57,624 1,441 57,000 2000
57,624 1,441 57,000 2000
57,624 1,441 55,000 2000
57,624 1,441 55,000 2000
52,000 1,300 52,000 2000
55,932 1,398 52,000 2000
176,272 4,407 175,000 4500

820,336 20,508 400,000 21000


210,168 5,254 210,000 5500
149,152 3,729 150,000 4000
128,812 3,220 130,000 4000
111,864 2,797 110,000 3500
108,472 2,712 110,000 3500
101,692 2,542 100,000 3500

84,744 2,119 85,000 3000


74,576 1,864 75,000 3000
57,624 1,441 57,000 3000
57,624 1,441 57,000 3000
57,624 1,441 57,000 3000
72,000 1,800 57,000 3000
72,000 1,800 57,000 3000
52,540 1,314 52,000 3000

142,372 3,559 98,000 4000


57,628 1,441 57,000 3000
25,420 847 30,000 2500
112,000 2,800 110,000 3500

189,828 4,746 190,000 5200


142,372 3,559 140,000 4000
227,120 5,678 220,000 6000
206,776 5,169 205,000 5500
132,200 3,305 135,000 4000
159,320 3,983 160,000 4500
176,268 4,407 175,000 5000

54,236 1,356 55,000 3000


57,624 1,441 57,000 3000
61,016 1,525 60,000 3000
57,624 1,441 57,000 3000
81,356 2,034 80,000 3500
54,236 1,356 54,000 3000

47,456 1,186 47,000 2500


68,000 1,700 68,000 2500
77,964 1,949 77,000 2500
47,456 1,186 47,000 2500
71,184 1,780 71,000 2500
77,964 1,949 77,000 2500
72,880 1,822 72,000 2500
74,576 1,864 75,000 2500
70,848 2,362 70,000 2500
101,696 2,542 101,000 3000
120,000 4,286 120,000 3500
88,132 2,203 88,000 3000
61,016 1,525 61,000 2000
136,000 3,400 136,000 4000
91,524 2,288 91,000
101,692 2,542 101,000 3000
44,068 881 45,000 1500
44,068 881 45,000 1500
44,068 881 45,000 1500
80,000 2,000 80,000 2500
84,744 2,119 85,000 2500
180,000 4,500 18,000 5000
-
Unit of Measure

# 150 ml Glass

Cost PrIce Btl


Bottle size ML
Country
Grape
Items
Wines - Red Wine
Ca del Dog 750 ml 5 11,500
Zonin Chianti 750 ml 5 9,746
zonin merlot 750 ml 5 9,746
Barton Guestie 750 ml 5 10,169
Kwv Merlot 750 ml 5 8,686
Chateau pontetne 750 ml 5 10,000
cellar cask red 750 ml 5 7,500
Calvet cabernet sauvignon 750 ml 5 7,500
Chateau fon froide red 750 ml 5 10,000
Grand sud sauvignon, 750 ml 5 7,500
CULUMBORG RED 750 ml 5 8,000
ZONNEBLOEM MERLOT 750 ml 5 13,559
Grand sud merlot 750 ml 5 7,500
kwv cabernet sauvignon 750 ml 5 8,686
KWV SHIRAZ 750 ml 5 8,686
KWV PINOTAGE 750 ml 5 8,686
BARON D'ARGNAC 750 ml 5 4,500
Calvet Bordeaux C.Sauvignon 750 ml 5 7,500
J.P.Chenet M Sweet 750 ml 5 10,930
J.P.Chenet Dry Merlot 750 ml 5 10,930
Cellar Cask 750 ml 5 7,500
Antonini ceresa Veneto 750 ml 5
Louis L'Eschenauer Merlot 750 ml 5
Domaine Bergon 750 ml 5 9,000
Franschhoek cellar C.sauvignon 750 ml 5 7,500
Franschoek Cellar Pinotage 750 ml 5 7,500
Calvet Bordeaux Merlot 750 ml 5 7,500
Chanteau pont nivelle 750 ml 5 11,250
chateau de fauzan 750 ml 5 11,250
Douglass 750 ml 5
Chateau de pena 750 ml 5 11,250
Hardy's C.Sauvignon 750 ml 5 7,924
Louis L'eschenauer C.Sauvignon 750 ml 5 7,924
Quereu C.Sauvignon 750 ml 5 6,483
Quereu Merlot 750 ml 5 6,483
victor Berard Brouilly 750 ml 5 10,169
B&G Merlot (COTE DU RHONE) 750 ml 5 10,169
Victor Berard Pinot Noir 750 ml 5 10,169
B & G C.Sauvignon 750 ml 5 10,169
Wines - White Wine
zonin moscato 750 ml 5 9,746
zonin soave 750 ml 5 9,746
falanghina 750 ml 5 9,746
Calvet Chardoney 750 ml 5 7,500
cellar Cask white 750 ml 5 7,500
chateau fon froide white 750 ml 5 10,000
CULUMBORG WHITE 750 ml 5 8,000
ZONNEBLOEM SAUVIGNON BLANC 750 ml 5 13,559
CALVET S/BLANC 750 ml 5 7,500
KWV CHARDONNAY 750 ml 5 8,686
KWV SAUVIGNON BLANC 750 ml 5 8,686
ASTORIA WINE 750 ml 5 10,000
CALVET CHARDONNAY 750 ml 5 7,500
J.P.Chenet M Sweet 750 ml 5 10,930
J.P.Chenet Dry 750 ml 5 10,930
Hardy's Chardonnay 750 ml 5 7,924
Hardy's Sauvignon blanc 750 ml 5 7,924
Domaine De La Baume 750 ml 5 13,000
Domaine Bergon 750 ml 5 13,000
Antonini ceresa Veneto 750 ml 5 9,500
Louis L'Eschenauer Chardonnay 750 ml 5 9,500
B&G Chardonnay 750 ml 5 10,169
VICTOR BERARD CHABLIS 750 ml 5 10,169
VICTOR BERARD(Bourgogne Chardonnay) 750 ml 5 10,169
Franschoek Sauvignon Blanc 750 ml 5 8,051
J.P.Chenet Ice Edition Dry 750 ml 5 10,930
Champagne
Moet 750 ml 5 55,000
Laurent - Perrier 750 ml 5 58,000
Dom-Perignon 750 ml 5 220,000
Taittinger Demi - Sec 750 ml 5 68,000
Taittinger Necture 750 ml 5 68,000
Sparkling Wine
Prosecco 750 ml 5 11,000
Bacio Della Luna Rose 750 ml 5 10,000
Bacio Della Luna Extra Dry 750 ml 5 10,000
J.P.Chenet Medium Dry 750 ml 5 10,930
Rose
J.P.Chenet Ice Edition Rose 750 ml 5 10,930
Nederbug Rose 750 ml 5 8,644
Rose D' Anjou 750 ml 5 10,930
J.P.Chenet Rose 750 ml 5 10,930
Mateus The Original Rose 1000 ml 7 12,000
Grand sud Carbarnet Sauvignon 1000 ml 7 7,500
Zonin Bardolino Sauvignon Blanc 750 ml 5 9,746
Proposed Selling Price
Glass Selling Price 25%

Proposed Selling Price


Btl Selling Price 25%
Cost Price Glass

Btl

Glass
2,300 38,333 9,200 38,000
1,949 32,487 7,797 32,000
1,949 32,487 7,797 32,000
2,034 33,897 8,135 35,000
1,737 28,953 6,949 30,000
2,000 33,333 8,000 33,000
1,500 25,000 6,000 30,000
1,500 25,000 6,000 30,000
2,000 33,333 8,000 35,000
1,500 25,000 6,000 30,000 5000
1,600 26,667 6,400 30,000 5000
2,712 45,197 10,847 45,000
1,500 25,000 6,000 30,000 5000
1,737 28,953 6,949 30,000
1,737 28,953 6,949 30,000
1,737 28,953 6,949 30,000
900 15,000 3,600 30,000
1,500 25,000 6,000 30,000
2,186 36,433 8,744 35,000
2,186 36,433 8,744 40,000
1,500 25,000 6,000 30,000
- - -
- - -
1,800 30,000 7,200 30,000
1,500 25,000 6,000 30,000
1,500 25,000 6,000 30,000
1,500 25,000 6,000 30,000
2,250 37,500 9,000 40,000
2,250 37,500 9,000 40,000
- - -
2,250 37,500 9,000 40,000
1,585 26,413 6,339 30,000
1,585 26,413 6,339 30,000
1,297 21,610 5,186 30,000
1,297 21,610 5,186 30,000
2,034 33,897 8,135 35,000
2,034 33,897 8,135 35,000
2,034 33,897 8,135 35,000
2,034 33,897 8,135 35,000
-
1,949 32,487 7,797 35,000
1,949 32,487 7,797 35,000
1,949 32,487 7,797 35,000
1,500 25,000 6,000 30,000
1,500 25,000 6,000 30,000
2,000 33,333 8,000 35,000
1,600 26,667 6,400 30,000
2,712 45,197 10,847 45,000
1,500 25,000 6,000 30,000 5000
1,737 28,953 6,949 30,000
1,737 28,953 6,949 30,000
2,000 33,333 8,000 35,000 5000
1,500 25,000 6,000 30,000
2,186 36,433 8,744 35,000
2,186 36,433 8,744 35,000
1,585 26,413 6,339 30,000
1,585 26,413 6,339 30,000
2,600 43,333 10,400 45,000
2,600 43,333 10,400 45,000
1,900 31,667 7,600 30,000
1,900 31,667 7,600 30,000
2,034 33,897 8,135 35,000
2,034 33,897 8,135 35,000
2,034 33,897 8,135 35,000
1,610 26,837 6,441 30,000
2,186 36,433 8,744 35,000
-
11,000 220,000 44,000 150,000
11,600 232,000 46,400 150,000
44,000 880,000 176,000 350,000
13,600 272,000 54,400 120,000
13,600 272,000 54,400 120,000
-
2,200 44,000 8,800 44,000
2,000 40,000 8,000 40,000
2,000 40,000 8,000 40,000
2,186 43,720 8,744 45,000
-
2,186 43,720 8,744 45,000 5000
1,729 34,576 6,915 35,000
2,186 43,720 8,744 45,000
2,186 43,720 8,744 45,000
1,800 48,000 7,200 48,000
1,125 30,000 4,500 30,000
1,949 38,984 7,797 38,000

You might also like