Scribd
Upload
5 views10 pages

Cogs #Recoveryjourney

The document provides a detailed breakdown of various beverage items, including their ingredient ratios, portion sizes, costs, and selling prices. Each item lists its components, usage, and total costs, along with a 10% markup for selling price calculations. Additionally, it includes instructions on how to prepare each drink and the necessary ingredients with their respective prices.

Uploaded by

posrondalimbangan
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
5 views10 pages

Cogs #Recoveryjourney

The document provides a detailed breakdown of various beverage items, including their ingredient ratios, portion sizes, costs, and selling prices. Each item lists its components, usage, and total costs, along with a 10% markup for selling price calculations. Additionally, it includes instructions on how to prepare each drink and the necessary ingredients with their respective prices.

Uploaded by

posrondalimbangan
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

Name of item Rasio Size by portion

Simple syrup 1:1= 1500 gr/ml


DESCRIPTION ITEM UOM PRICE USAGE COST
Ingredient Packaging by Sat Usage by ml/gr by Product

Air mineral Rp 0.4 1000 Rp 368


Gula Pasir Rp 14.5 1000 Rp 14,500
Rp -
Total cost Rp 14,868 10% Rp 16,355
Selling Price
Presentase

Name of item Rasio Size by portion


Lemon Consentrat 1:2:0,2= 2000 gr/ml
DESCRIPTION ITEM UOM PRICE USAGE COST
Ingredient Packaging by Sat Usage by ml/gr by Product

Lemon Lokal Rp 15.0 1000 Rp 15,000


Air mineral Rp 0.4 2000 Rp 737
Gula Pasir Rp 14.5 200 Rp 2,900
Total cost Rp 18,637 10% Rp 20,501
Selling Price
Presentase

Name of item Rasio Size by portion


Sereh Consentrat 1:11= 9000 gr/ml
DESCRIPTION ITEM UOM PRICE USAGE COST
Ingredient Packaging by Sat Usage by ml/gr by Product

Sereh Rp 12.0 1000 Rp 12,000


Air mineral Rp 0.4 11000 Rp 4,053
Rp -
Total cost Rp 16,053 10% Rp 17,658
Selling Price
Presentase

Name of item Rasio Size by portion


Kayumanis Cons 1:9= 7000 gr/ml
DESCRIPTION ITEM UOM PRICE USAGE COST
Ingredient Packaging by Sat Usage by ml/gr by Product

Kayumanis Rp 100.0 1000 Rp 100,000


Air mineral Rp 0.4 9000 Rp 3,316
Rp -
Total cost Rp 103,316 10% Rp 113,647
Selling Price
Presentase
Name of item Rasio Size by portion
Pandan cons 1:15= 10000 gr/ml
DESCRIPTION ITEM UOM PRICE USAGE COST
Ingredient Packaging by Sat Usage by ml/gr by Product

Pandan Rp 8.0 1000 Rp 8,000


Air mineral Rp 0.4 15000 Rp 5,526
Rp -
Total cost Rp 13,526 10% Rp 14,879
Selling Price
Presentase

Name of item Rasio Size by portion


Guava Juice 1:1 = 1500 gr/ml
DESCRIPTION ITEM UOM PRICE USAGE COST
Ingredient Packaging by Sat Usage by ml/gr by Product

Jambu Rp 4.0 1000 Rp 4,000


Air mineral Rp 0.4 1000 Rp 368
Rp -
Total cost Rp 4,368 10% Rp 4,805
Selling Price
Presentase

Name of item Rasio Size by portion


Peanaple Juice 1:1= 1500 gr/ml
DESCRIPTION ITEM UOM PRICE USAGE COST
Ingredient Packaging by Sat Usage by ml/gr by Product

Nanas Rp 10.0 1000 Rp 10,000


Air mineral Rp 0.4 1000 Rp 368
Rp -
Total cost Rp 10,368 10% Rp 11,405
Selling Price
Presentase

Name of item Rasio Size by portion


Jackfruit Juice 1:1= 1500 gr/ml
DESCRIPTION ITEM UOM PRICE USAGE COST
Ingredient Packaging by Sat Usage by ml/gr by Product

Belimbing Rp 10.0 1000 Rp 10,000


Air mineral Rp 0.4 1000 Rp 368
Rp -
Total cost Rp 10,368 10% Rp 11,405
Selling Price
Presentase
Name of item Rasio Size by portion
Soursop Juice 1:1= 1500 gr/ml
DESCRIPTION ITEM UOM PRICE USAGE COST
Ingredient Packaging by Sat Usage by ml/gr by Product

Sirsak Rp 9.0 1000 Rp 9,000


Air mineral Rp 0.4 1000 Rp 368
Rp -
Total cost Rp 9,368 10% Rp 10,305
Selling Price
Presentase

Name of item Rasio Size by portion


Rosella tea 1:50= 50000 gr/ml
DESCRIPTION ITEM UOM PRICE USAGE COST
Ingredient Packaging by Sat Usage by ml/gr by Product

Rosella tea Rp 200.0 1000 Rp 200,000


Air mineral Rp 0.4 50000 Rp 18,421
Rp -
Total cost Rp 218,421 10% Rp 240,263
Selling Price
Presentase
Name of item
Sapporo
DESCRIPTION ITEM UOM PRICE USAGE COST How To Make
Ingredient Packaging by Packaging Usage by ml/gr by Product Share to Glass

Simsy Rp 10.9 3 Rp 33
Lecy sirup Rp 44.4 5 Rp 222
Buah Naga Rp 25.0 5 Rp 125 Madler
Strawberry Rp 37.5 20 Rp 750
Sereh Rp 2.0 10 Rp 20
Air Rp 0.4 20 Rp 7
Ice Cube Rp 1.2 50 Rp 60
Soda Rp 15.6 20 Rp 312
Ice Cube Rp 1.2 20 Rp 24
Garnish Kamboja / Kulit Buah Naga

Total cost Rp 1,553 Up 10%


Selling Price Rp 17,000
Presentase 9.1%

Name of item
Miyajima
DESCRIPTION ITEM UOM PRICE USAGE COST How To Make
Ingredient Packaging by Packaging Usage by ml/gr by Product Share to Glass

Simsy Rp 10.9 20 Rp 218


Guava Juice Rp 3.2 30 Rp 96
Rosella Tea Rp 4.8 45 Rp 216 Shake
Cinamon Cons Rp 16.2 50 Rp 812
Ice Cube Rp 1.2 120 Rp 144
Rp -
Rp -
Rp -
Rp -
Garnish Cinamon
Rosella
Total cost Rp 1,486 Up 10%
Selling Price Rp 17,000
Presentase 8.7%

Name of item
Okinawa
DESCRIPTION ITEM UOM PRICE USAGE COST How To Make
Ingredient Packaging by Packaging Usage by ml/gr by Product Share to Glass

Simsy Rp 10.9 15 Rp 164


Soursop Juice Rp 6.9 10 Rp 69
Lemon Cons Rp 10.3 15 Rp 154
Shake
Jack Fruit Juice Rp 7.6 20 Rp 152
Ice Cube Rp 1.2 50 Rp 60
Shake

Air Rp 0.4 40 Rp 15
Ice Cube Rp 1.2 80 Rp 96
Rp -
Rp -
Garnish Jack Fruit Rp 10.0 5 Rp 50

Total cost Rp 759 Up 10%


Selling Price Rp 17,000
Presentase 4.5%

Name of item
Shizuoka
DESCRIPTION ITEM UOM PRICE USAGE COST How To Make
Ingredient Packaging by Packaging Usage by ml/gr by Product Share to Glass

Ice Cube Rp 1.2 120 Rp 144


Mint Sirup Rp 100.0 5 Rp 500
Lemon Cons Rp 10.3 10 Rp 103
Pure to Glass
Simsy Rp 10.9 20 Rp 218
Pandan Cons Rp 1.5 50 Rp 74
Air Rp 0.4 50 Rp 18
Rp -
Rp -
Rp -
Garnish Lemon Slice, Daun Mint, Pandan Slice

Total cost Rp 1,057 Up 10%


Selling Price Rp 17,000
Presentase 6.2%

Name of item
Hiroshima
DESCRIPTION ITEM UOM PRICE USAGE COST How To Make
Ingredient Packaging by Packaging Usage by ml/gr by Product Share to Glass

Lemon Cons Rp 10.3 10 Rp 103


Simsy Rp 10.9 15 Rp 164
Peanaple Juice Rp 7.6 20 Rp 152
Shake
Sereh Cons Rp 2.0 25 Rp 49
Ice Cube Rp 1.2 80 Rp 96
Air Rp 0.4 30 Rp 11
Ice Cube Rp 1.2 120 Rp 144
Rp -
Rp -
Garnish Peanaple Rp 10 5 Rp 50
Sereh
Total cost Rp 768 Up 10%
Selling Price Rp 17,000
Presentase 4.5%
Size by portion
70 ml
How To Make
Share to Glass

Shake Filter to Glass

Pure to Glass

Rp 1,708

Size by portion
265 ml
How To Make
Share to Glass

Pure to Glass

Rp 1,635

Size by portion
180 ml
How To Make
Share to Glass

Ice to Glass Filter to Glass


Ice to Glass Filter to Glass

Rp 835

Size by portion
255 ml
How To Make
Share to Glass

Rp 1,163

Size by portion
220 ml
How To Make
Share to Glass

Filter to Glass

Rp 845
No Bahan Packaging Sat Qty Harga Beli Harga/Sat
1 Air Galon Galon ml 19000 Rp 7,000 Rp 0.4
2 Sirup Mint Botol ml 1000 Rp 100,000 Rp 100
3 Sirup leci Botol ml 450 Rp 20,000 Rp 44
4 Zoda Botol ml 250 Rp 3,900 Rp 16
5 Gula pasir Pak gr 1000 Rp 14,500 Rp 15
6 Sirsak Pak gr 1000 Rp 9,000 Rp 9
7 Jambu Pcs gr 1000 Rp 4,000 Rp 4
8 Belimbing Pcs lbr 1000 Rp 10,000 Rp 10
9 Nanas Pcs gr 1000 Rp 10,000 Rp 10
10 Strawberry Pcs gr 320 Rp 20,000 Rp 63
11 Buah Naga Pcs gr 1000 Rp -
12 Lemon Lokal Pcs gr 1000 Rp 15,000 Rp 15
13 Sereh Pcs gr 1000 Rp 12,000 Rp 12
14 Kayumanis Pcs gr 1000 Rp 100,000 Rp 100
15 Pandan Pcs gr 1000 Rp 8,000 Rp 8
16 Rosella Pcs gr 1000 Rp 200,000 Rp 200
17 Ice Cube Pak gr 10000 Rp 12,000 Rp 1
18 #DIV/0!
19 #DIV/0!
20 #DIV/0!
21 #DIV/0!
22 #DIV/0!
23 #DIV/0!
24 #DIV/0!
25 #DIV/0!
26 #DIV/0!
27 #DIV/0!
28 #DIV/0!
29 #DIV/0!
30 #DIV/0!
31 #DIV/0!
32 #DIV/0!
33 #DIV/0!
34 #DIV/0!
35 #DIV/0!
36 #DIV/0!
37 #DIV/0!
38 #DIV/0!
39 #DIV/0!
40 #DIV/0!
41 #DIV/0!
42 #DIV/0!
43 #DIV/0!
44 #DIV/0!
45 #DIV/0!
46 #DIV/0!
47 #DIV/0!
48 #DIV/0!
49 #DIV/0!
50 #DIV/0!
51 #DIV/0!
52 #DIV/0!
53 #DIV/0!
54 #DIV/0!
55 #DIV/0!
No Bahan Packaging Sat Qty Harga Beli Harga/Sat
1 Air Galon Galon ml 19000 Rp 7,000 Rp 0.4
2 Sirup Mint Botol ml 1000 Rp 100,000 Rp 100
3 Sirup leci Botol ml 450 Rp 20,000 Rp 44
4 Zoda Botol ml 250 Rp 3,900 Rp 16
5 Simple Sirup Prepare ml 1500 Rp 16,355 Rp 11
6 Sirsak Prepare ml 1500 Rp 10,305 Rp 7
7 Jambu Prepare ml 1500 Rp 4,805 Rp 3
8 Belimbing Prepare ml 1500 Rp 11,405 Rp 8
9 Nanas Prepare ml 1500 Rp 11,405 Rp 8
10 Lemon Cons Prepare ml 2000 Rp 20,501 Rp 10
11 Sereh Cons Prepare ml 9000 Rp 17,658 Rp 2
12 Kayumanis Cons Prepare ml 7000 Rp 113,647 Rp 16
13 Pandan Cons Prepare ml 10000 Rp 14,879 Rp 1
14 Rosella Cons Prepare ml 50000 Rp 240,263 Rp 5
15 Strawberry Pcs gr 320 Rp 12,000 Rp 38
16 Buah Naga Pcs gr 1000 Rp 25,000 Rp 25
17 Ice Cube Pak gr 10000 Rp 12,000 Rp 1
18 #DIV/0!
19 #DIV/0!
20 #DIV/0!
21 #DIV/0!
22 #DIV/0!
23 #DIV/0!

You might also like