Item Ingrediant Item Qty UoM Cost COGS

Juice Terong Belanda 2,280.00

Terong Belanda 120 gr 1,800.00
Gula pasir 40 gr 480.00

Juice Apel Hijau 3,930.00

Apel Hijau 150 gr 3,450.00
Gula pasir 40 gr 480.00

Mocktail Symple Red 10,570.00

Grenadyne Syrup 30 ml 5,800.00
Sprite 1 can 4,500.00
Fresh Milk 30 ml 270.00

Mocktail Violetta 9,123.00

Black Currant Syrup 30 ml 5,143.00
Passion Syrup 30 ml 458.00
Fresh Milk 30 ml 270.00
Soda Water 1 can 3,252.00
Menu Baru

item ingredient qty uom methode glass garnish

Beer Flava Beer Bintang 1 can masukan flv choice pilsener

Flavour 30 ml dan tambahkan beer

Blaster Flavour 30 ml masukan flv choice red cherry

Coke 1 can kemudian ice cream
Vanilla ice cream 30 gr dan topping coke
ice cube 7 pcs
chery 1 pcs

Lychee Tea black darjeling 7 gr masukan tea dlm hurricane red cherry
Lychee Fruit 2 pcs plunger (mirip cnc tea)
Lychee flavour 30 ml lalu shake dgn flv
ice cube 7 pcs stlh itu tambahkan
chery 1 pcs lychee 2 buah
 Kompliment
Ingrediant Item Qty UoM Price Total Cost COGS Selling Price COGS %

Ice Shot chocolate 6,868.90 30,000.00 23%

Davinci chocolate 30 ml 133.33 3,999.90
Fresh Milk 100 ml 9.79 979.00
Bistro Premio 9 gr 210 1,890.00
Espresso shake choc 6,868.90 30,000.00 23%
Davinci chocolate 30 ml 133.33 3,999.90
Fresh Milk 100 ml 9.79 979.00
Bistro Premio 9 gr 210 1,890.00
Mexicano coffee 11,200.75 45000 25%
Bistro Premio 9 gr 210 1,890.00
whipping cream supreme 30 ml 26.31 789.30
cream charger N2O 0.09 pcs 7500 675.00
Brown sugar stick 2 pcs 206.00 412.00
Davinci chocolate 15 ml 133.33 1,999.95
Beehive 15 ml 181.15 2,717.25
kahlua 15 ml 181.15 2,717.25
ice shoot almond 6,388.90 30000 21%
Davinci Almond 30 ml 117.33 3,519.90
Fresh Milk 100 ml 9.79 979.00
Bistro Premio 9 gr 210 1,890.00
espresso shake almond 6,388.90 30000 21%
Davinci Almond 30 ml 117.33 3,519.90
Fresh Milk 100 ml 9.79 979.00
Bistro Premio 9 gr 210 1,890.00

Prepared By,

Dhani Syahputra
COGS Beverages Cup&Cino Medan
Ingrediant item Qty UoM Price Total Cost COGS Selling Price COGS %

Irish Coffee 8,725.49 49,000.00 18%

Bistro Premio 9 gr 210.00 1,890.00
Whipping Cream Supreme 30 ml 26.59 797.70
Cream Charger N2O 0.09 pcs 5,749.85 517.49
Nutmeg 0.05 gr 110.00 5.50
Brown Sugar Stick 2 pcs 257.50 515.00
Vibe whisky 30 ml 166.66 4,999.80
Jamaican Coffee 8,725.49 49,000.00 18%
Bistro Premio 9 gr 210.00 1,890.00
Whipping Cream Supreme 30 ml 26.59 797.70
Cream Charger N2O 0.09 pcs 5,749.85 517.49
Nutmeg 0.05 gr 110.00 5.50
Vibe Rum 30 ml 166.66 4,999.80
Brown Sugar Stick 2 pcs 257.50 515.00
Mexicano Coffee 8,697.54 49,000.00 18%
Bistro Premio 9 gr 210.00 1,890.00
Whipping Cream Supreme 30 ml 26.59 797.70
Cream Charger N2O 0.09 pcs 5,749.85 517.49
Nutmeg 2 gr 110.00 220.00
Brown Sugar Stick 3 pcs 257.50 772.50
DA VINCI - Chocolate 15 ml 133.33 1,999.95
Vibe Robusta Coffee 15 ml 166.66 2,499.90
Russian Coffee 9,197.49 49,000.00 19%
Bistro Premio 9 gr 210.00 1,890.00
Whipping Cream Supreme 30 ml 26.59 797.70
Cream Charger N2O 0.09 pcs 5,749.85 517.49
Nutmeg 2 gr 110.00 220.00
Vibe Vodka original 30 ml 166.66 4,999.80
 Brown Sugar Stick 3 pcs 257.50 772.50
Blue Lady 11,580.59 75,000.00 15%
Vibe cacao brown 30 ml 166.66 4,999.80
MONIN - Blue Curacao 30 ml 166.66 4,999.80
Whipping Cream Supreme 30 ml 26.59 797.70
Cream Charger N2O 0.09 pcs 5,749.85 517.49
Lime 15 gr 17.72 265.80
- -
Chocolate Martini #N/A 80,000.00 #N/A
Vibe Vodka original 30 ml 166.66 4,999.80
Vibe blue curacao 15 ml 166.66 2,499.90
vibe crem d cacao 30 ml 166.66 4,999.80
Sauce Chocolate 20 ml #N/A #N/A
Chocolate Stick 1 pcs #N/A #N/A
Flaming Bikini 19,999.20 85,000.00 24%
Vibe Cherry Brandy 15 ml 166.66 2,499.90
Vibe Vodka original 30 ml 166.66 4,999.80
Vibe triple sec 15 ml 166.66 2,499.90
Vibe Sambuca 30 ml 166.66 4,999.80
Vibe blue curacao 30 ml 166.66 4,999.80
Illusion - - 13,857.80 70,000.00 20%
Vibe Vodka original 30 ml 166.66 4,999.80
Vibe Triple Sec 15 ml 166.66 2,499.90
Vibe Blue Curacao 5 ml 166.66 833.30
Vibe Melon 30 ml 166.66 4,999.80
Pinneaple fruit 120 gr 3.75 450.00
Lime Fruit 15 gr 5.00 75.00
Long Island Tea 19,292.51 85,000.00 23%
Vibe gin 15 ml 166.66 2,499.90
Vibe Vodka original 30 ml 166.66 4,999.80
Vibe tequilla 15 ml 166.66 2,499.90
 Vibe Rum 15 ml 166.66 2,499.90
Vibe triple sec 15 ml 166.66 2,499.90
Lime Fruit 15 gr 5.00 75.00
Coca Cola 1 can 4,218.11 4,218.11
Margarita - - 7,790.47 70,000.00 11%
Vibe tequilla 30 ml 166.66 4,999.80
Vibe Triple Sec 15 ml 166.66 2,499.90
Lime Juice RTD 15 ml 13.59 203.85
Salt 2 gr 5.96 11.92
Lime 15 gr 5.00 75.00
Blue Margarita 7,572.00 70,000.00 11%
Vibe Blue Curacao 15 ml 166.60 2,499.00
Vibe Tequilla 15 ml 166.60 2,499.00
Vibe Triple Sec 15 ml 166.60 2,499.00
Lime Fruit 15 gr 5.00 75.00
Blue Lagoon 12,072.20 70,000.00 17%
Vibe Blue Curacao 15 ml 166.66 2,499.90
Vibe Vodka Original 30 ml 166.66 4,999.80
Lime Fruit 15 gr 5.00 75.00
Sprite 1 can 4,497.50 4,497.50
Mexican Bulldog 12,548.21 70,000.00 18%
Vibe Tequilla 22.5 ml 166.66 3,749.85
Vibe Robusta Coffee 22.5 ml 166.66 3,749.85
IC Diamond Vanilla 80 ml 10.38 830.40
Coca Cola 1 can 4,218.11 4,218.11
Screw Driver 6,103.80 70,000.00 9%
Vibe Vodka Original 30 ml 166.66 4,999.80
Orange Juice RTD 120 ml 9.20 1,104.00
Tequila Sunrise 7,103.70 65,000.00 11%
Vibe Tequilla 30 ml 166.66 4,999.80
Vibe Grenadyne 15 ml 66.66 999.90
 Orange Juice RTD 120 ml 9.20 1,104.00
Screaming Orgasm 9,999.60 70,000.00 14%
Bailey's 15 ml 166.66 2,499.90
Vibe Robusta Coffee 15 ml 166.66 2,499.90
Vibe Vodka Original 15 ml 166.66 2,499.90
Blow Job 12,499.50 70,000 18%
Bailey's 15 ml 166.66 2,499.90
Vibe Robusta Coffee 15 ml 166.66 2,499.90
Vibe Sambuca 15 ml 166.66 2,499.90
Caipiroska Strawbery 13,454.80 70,000 19%
Vibe Vodka Original 30 ml 166.66 4,999.80
Vibe Triple sec 15 ml 166.66 2,499.90
Davinci strawberry 30 ml 114.67 3,440.10
Brown Sugar 2 pcs 257.50 515.00
Strawbery Fruit 50 gr 40.00 2,000.00
Lime Fruit 15 gr 5.00 75.00
Caipirisima 8,089.70 70,000.00 12%
Vibe Rum 30 ml 166.66 4,999.80
Vibe triple Sec 15 ml 166.66 2,499.90
Lime Fruit 15 gr 5.00 75.00
Brown Sugar 2 pcs 257.50 515.00

Prepared By,

Dhani Syahputra
 PROGRAM KERJA HARIAN BAR AREA
Bulan :
Tanggal 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Openning Duty
Staff Incharge
Melihat & mengisi log book
Menghidupkan lampu showcase, displya, dan atas bar
Menghidupkan kran dan filter air serta mesin kopinya
Membersihkan atau mencuci milk jug
Menghitung penjualan minuman kedalam form daily sales
Menerima barang (buah-buahan) yang masuk
Preperation minuman( teh, juice, ice cappucino, gula )
Membersihkan toples teh & atas showcase dan mengisi tehnya
Membersihkan showcase ice cream, chiller & display botol flavour
Mengisi inventory bar ke laptop & membuat form orderan barang
Stand by/Menunggu orderan dari server

Closing Duty
Staff Incharge
Memesan buah ke supplier
Membersihkan mesin blender
Mengunci drawer, showcase, & mematikan lampunya
Membersihkan Mesin kopi & mematikanya serta kran & filter airnya
Mencuci peralatan & gelas-gelas kotor
Membersihkan sing (tempat cuci gelas)
Membersihkan & mengepel lantai bar
Mematikan listrik yang perlu di matikan ( lampu atas bar & display )
Mengisi log book & mengecek ulang segala sesuatu
Posting dan pulang ke rumah masing-masing

Di buat oleh,

Toni
(Bar leader)
 Menu Vallentine
Ingrediant Item Qty UoM Price Total Cost COGS Selling Price COGS %

love of tea 3,396.50 39,000.00 9%

grenadine 30 ml 55.55 1,666.50
tea 7 gr 200 1,400.00
longan 5 pcs 50 250.00
selasi 2 tsp 25 50.00
Daun mint 1 siung 30 30
Tropical blast 5,066.50 40,000.00 13%
Marquisa 30 ml 55.55 1,666.50
Orange jc 250 ml 12 3,000.00
longan 5 pcs 50 250.00
melon 1 slice 150 150.00
 DAILY CONSUMTION
Date
Hot coffee & chocolate Tea
Cappucino Black Darjeeling Pralino
Cappucino Small Earl Grey Latte
Cappucino Decaff English Brekfast Machiato
Coffe Creme Green Tea MADAGASKAR
Coffe Creme Small Jasmine PUERTO CABELO
Coffe Creme Decaff Ice Lemon Tea AMAZONAS
Coffe Latte Peppermint TOBAGO
Coffe Latte Small Refreshing C&C Frappe
Coffe Latte Decaff Charmomile Dbl. Choc Oreo
Coffe Melange Ice Drink White Avocado
Espresso Espremisu Manggo
Espresso Decaff Ice Cacao Strawberry
Espresso Machiato Ice Cappucino Oreo
Machiato Ice Chococino Almond
Machiato XXL Ice Coffee
Ristretto Ice Latte Pralino Frappe
Hot Chocolate Ice Macchiato Caramel Frappe
Moccacino Ice Moccacino Springkle
Chococino Beverage Green Tea
Juice Mineral Water Banana Choco
Guava Spark. Minrl Water
Lime Coke Frozen & Slushy
Orange Diet Coke Tiramisu
Pineapple Coke Zero Coklat
Fresh Avocado Soda Water
Mango Sprite
Orange Tonic
Pineapple Beer
Rock Melon Bintang Ice Shoot
Starfruit Heineken Tiramisu
Strawberry Cocktail Coklat
Tomato Choc. Martini
Water Melon Margarita
Carot Tequilla Sunrise
Screw Driver
Blue Lady ice Shoot Delux
Smoothies Blue Margarita
Banana Blue Lagoon
Strawberry Blue Oasis
Strawberry Banana Godfather Machiatho Super
Vanilla Blue Martini
Vanilla Strawbery Coffe Fly Away
Ice Cream Illution
coklat Flaming Bikini
Strawberi Electric Green Espresso Shake
Vanilla Long Island Ice Tea
Milk Shake Mud Mad
coklat Mexican Buldog
Strawberi Shotter
Vanilla B52 Open beverages
Squash Blow Job
Lime Screaming Orgasm
Orange House Pouring
Pineapple Add Flavour
Coffee Special wa
Irish Coffee
Jamaican Coffee
Mexican Coffee Premium Pouring
Rusian Coffee Beverage Promo
Espresso salute Pink Strawberry
Caipis
Caipirisima Yellow Banana
Caipiroska Mixer
Caipis strawbery Special lunch
Sprite
Virgin Mocktail
16ers Blue Coke
C&C Iced Tea
Fruit Punch ice tea
San Francisco
Sparkling Green
Julietta
Cinderella
Virgin banana
BEVERAGE COGS

ingredient Qty UOM Price Total Cost COGS Selling Price COGS %
item
Virgin Banana Banana 1 pcs 867 866,67
(New) Pineaple 360 ml 5 1,800,00
Chocolate Flavor 30 ml 10.9 1,090,00
Fresh milk 100 ml 133.3333333 3.999,9
7.756.57 40,000.00 19,39%
Cinderella lime juice 30 ml 6 180,00
(New) orange juice 30 ml 6.5 195,00
pineapple juice 30 ml 5 150,00
grenadine 30 ml 189.33 5.679,90
ginger ale 1 can 3875 3.875,00
10.079.9 40.000.00 25,20%
tropical blast melon 1 slice 400 400,00
(New) longan 6 pcs 654 3,923
orange juice 90 ml 6.50 585,00
marquisa 30 ml 16.66666667 500
5.408 40.000.00 13,52%
irish coffee frappe fresh milk 100 ml
espresso 10 gr
baileys liquer 45 ml
irish whisky 30 ml
white frappee powder 40 gr
whipping cream 20 ml
brown sugar 2 pcs
cream charger N2O 0.14 pcs
Hazelnut mocha frappe fresh milk 100 ml
espresso 10 gr
white frappee powder 40 gr
Davinci hazelnut 30 ml
Davinci chocolate 30 ml
Davinci vanilla 30 ml
whipping cream 20 ml
cream charger N2O 0.14 pcs
brown sugar 2 pcs

Death by choco frappee fresh milk 100 ml

 espresso 10 gr
chocolate powder 40 gr
ice cream chocolate 1 scoop
whipping cream 20 ml
cream charger N2O 0.14 pcs

Caramel apple frappe fresh milk 100 ml

espresso 10 gr
white frappe powder 40 gr
Davinci caramel 30 ml
apple concentrate 90 ml
whipping cream 20 ml
cream charger N2O 0.14 pcs
Beverage Cost
Medan
Ingredient
item Qty Uom item price Cost/unit total cost
Beer Flava Beer Bintang 1 can 11875 11,875.00
Flavour 30 ml 173.91 5,217.30
17,092.30
Blaster Flavour 30 ml 173.91 5,217.30
Coke 1 can 5750 5,750.00
Vanilla ice cream 30 gr 23.3 699.00
ice cube 7 pcs 120.00 840.00
chery 1 pcs 1,800.00 1,800.00
14,306.30
Lychee Tea black darjeling 7 gr 720 5,040.00
Lychee Fruit 2 pcs 400 800.00
Lychee flavour 30 ml 173.91 5,217.30
ice cube 7 pcs 120.00 840.00
chery 1 pcs 1,800.00 1,800.00
13,697.30

Prepared by,

Dhani Syahputra
Bukti Penyerahaan Bon dari Bar Bukti Penyerahaan Bon dari Bar

No Description Kode Bon No Description Kode Bon

1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10

Medan, Medan,

Diserahkan oleh, Diterimah oleh, Diserahkan oleh, Diterimah oleh,

Bukti Penyerahaan Bon dari Bar Bukti Penyerahaan Bon dari Bar

No Description Kode Bon No Description Kode Bon

1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10

Medan, Medan,

Diserahkan oleh, Diterimah oleh, Diserahkan oleh, Diterimah oleh,

Bukti Penyerahaan Bon dari Bar Bukti Penyerahaan Bon dari Bar

No Description Kode Bon No Description Kode Bon

1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10

Medan, Medan,

Diserahkan oleh, Diterimah oleh, Diserahkan oleh, Diterimah oleh,

 Item Item
Fruits Qty UOM Fruits Qty UOM
Avocado Kg Avocado Kg
Banana Sisir Banana Sisir
Lemon Kg Lemon Kg
Lime Kg Lime Kg
Manggo Kg Manggo Kg
Orange Kg Orange Kg
Pineapple Buah Pineapple Buah
Watermelon Buah Watermelon Buah
Rock melon Buah Rock melon Buah
Strawbery Pack Strawbery Pack
Starfruit Kg Starfruit Kg
Kayu Manis gr Kayu Manis gr
Daun sre ikat Daun sre ikat
Gula pasir Kg Gula pasir Kg
Nutrijell kotak Nutrijell kotak

tgl, tgl,

ordered by : ordered by :