NASI GORENG SAMBAL IJO

yeild 1 por
no item qty unit unit price cost no
1 Nasi 1 por Rp 1,400 Rp 1,400 1
2 telur 2 KG Rp 5,000 Rp 10,000 2
3 sambal ijo 0.035 KG Rp 70,000 Rp 2,450 3
4 ikan asin 0.05 KG Rp 13,000 Rp 650 4
5 emping 0.02 KG Rp 20,000 Rp 400 5
6 acar 0.05 KG Rp 10,000 Rp 500 6
7 KG Rp - 7
8 Rp - 8
9 Rp - 9
10 Rp - 10
11 Rp - 11
12 Rp - 12
total cost Rp 15,400 total cost
alowence 10% Rp 1,540 alowence
cogs Rp 16,940 cogs
selling price Rp 26,000 selling price
cost percentage 65% cost percentage

NASI GORENG OMELET

yeild 1 por
no item qty unit unit price cost no
1 Nasi 1 por Rp 1,400 Rp 1,400 1
2 telur 2 KG Rp 5,000 Rp 10,000 2
3 kol 0.09 KG Rp 16,000 Rp 1,440 3
4 tempe 0.03 KG Rp 4,500 Rp 135 4
5 sambal terasi 0.035 KG Rp 70,000 Rp 2,450 5
6 acar 0.05 KG Rp 10,000 Rp 500 6
7 krupuk 0.02 KG Rp 20,000 Rp 400 7
8 Rp - 8
9 Rp - 9
10 Rp - 10
11 Rp - 11
12 Rp - 12
total cost Rp 16,325 total cost
alowence 10% Rp 1,633 alowence
cogs Rp 17,958 cogs
selling price Rp 28,000 selling price
cost percentage 64% cost percentage
 yeild 1 por
no item qty unit unit price cost no
1 KG Rp - 1
2 KG Rp - 2
3 KG Rp - 3
4 KG Rp - 4
5 KG Rp - 5
6 KG Rp - 6
7 KG Rp - 7
8 Rp - 8
9 Rp - 9
10 Rp - 10
11 Rp - 11
12 Rp - 12
total cost Rp - total cost
alowence 10% Rp - alowence
cogs Rp - cogs
selling price selling price
cost percentage #DIV/0! cost percentage
 NASI GORRENG KAMPUNG NASI PUTIH
yeild 1 por
item qty unit unit price cost no item qty
Nasi 1 por Rp 1,400 Rp 1,400 1 NASI 1
telur 2 KG Rp 5,000 Rp 10,000 2
ayam sayap 0.02 KG Rp 31,500 Rp 630 3
sambal terasi 0.035 KG Rp 70,000 Rp 2,450 4
krupuk 0.02 KG Rp 20,000 Rp 400 5
acar 0.05 KG Rp 10,000 Rp 500 6
KG Rp - 7
Rp - 8
Rp - 9
Rp - 10
Rp - 11
Rp - 12
total cost Rp 15,380 total cost
alowence 10% Rp 1,538 alowence 10%
Rp 16,918
selling price Rp 25,000 COGS
cost percentage 68%

NASI GORENG ROYAL kwetiau seafood

yeild 1 por
item qty unit unit price cost no item qty
Nasi 1 por Rp 1,400 Rp 1,400 1 kwetiau 0.02
telur 2 KG Rp 5,000 Rp 10,000 2 telur 2
mixed vegetable 0.05 KG Rp 30,000 Rp 1,500 3 sotong 0.01
telur KG Rp - 4 udang 0.01
udang 0.01 KG Rp 50,000 Rp 500 5 bakso 0.05
sotong 0.01 KG Rp 70,000 Rp 700 6 kol 0.09
bakso 0.05 KG Rp 26,000 Rp 1,300 7 sawi 0.02
kerupuk 0.02 KG Rp 20,000 Rp 400 8 acar 0.05
acar 0.05 KG Rp 10,000 Rp 500 9 kerupuk 0.02
Rp - 10
Rp - 11
Rp - 12
total cost Rp 16,300 total cost
alowence 10% Rp 1,630 alowence 10%
Rp 17,930 cogs
selling price Rp 28,000 selling price
cost percentage 64% cost percentage
 yeild 1 por
item qty unit unit price cost no item qty
KG Rp - 1
KG Rp - 2
KG Rp - 3
KG Rp - 4
KG Rp - 5
KG Rp - 6
KG Rp - 7
Rp - 8
Rp - 9
Rp - 10
Rp - 11
Rp - 12
total cost Rp - total cost
alowence 10% Rp - alowence 10%
Rp - cogs
selling price selling price
cost percentage #DIV/0! cost percentage
 NASI PUTIH
yeild 11 por
unit unit price cost yeild 1
KG Rp 14,000 Rp 14,000 no item qty unit unit price
Rp - 1 KG
Rp - 2 KG
Rp - 3 KG
Rp - 4 KG
Rp - 5 KG
Rp - 6 KG
Rp - 7 KG
Rp - 8
Rp - 9
Rp - 10
Rp - 11
Rp 14,000 12
Rp 1,400 total cost
Rp 15,400 alowence 10%
Rp 1,400 cogs
selling price
cost percentage

kwetiau seafood
yeild 1 por
unit unit price cost yeild 1
KG Rp 4,580 Rp 92 no item qty unit unit price
KG Rp 5,000 Rp 10,000 1 KG
KG Rp 70,000 Rp 700 2 KG
KG Rp 50,000 Rp 500 3 KG
KG Rp 26,000 Rp 1,300 4 KG
KG Rp 16,000 Rp 1,440 5 KG
KG Rp 10,200 Rp 204 6 KG
kg Rp 10,000 Rp 500 7 KG
kg Rp 20,000 Rp 400 8
Rp - 9
Rp - 10
Rp - 11
Rp 15,136 12
Rp 1,514 total cost
Rp 16,649 alowence 10%
Rp 27,000 cogs
62% selling price
cost percentage
yeild 1 por yeild 1
unit unit price cost no item qty unit unit price
KG Rp - 1 KG
KG Rp - 2 KG
KG Rp - 3 KG
KG Rp - 4 KG
KG Rp - 5 KG
KG Rp - 6 KG
KG Rp - 7 KG
Rp - 8
Rp - 9
Rp - 10
Rp - 11
Rp - 12
Rp - total cost
Rp - alowence 10%
Rp - cogs
selling price
#DIV/0! cost percentage
 yeild 1 por
por no item qty unit unit price cost
cost 1 KG Rp -
Rp - 2 KG Rp -
Rp - 3 KG Rp -
Rp - 4 KG Rp -
Rp - 5 KG Rp -
Rp - 6 KG Rp -
Rp - 7 KG Rp -
Rp - 8 Rp -
Rp - 9 Rp -
Rp - 10 Rp -
Rp - 11 Rp -
Rp - 12 Rp -
Rp - total cost Rp -
Rp - alowence 10% Rp -
Rp - cogs Rp -
Rp - selling price
cost percentage #DIV/0!
#DIV/0!

por yeild 1 por

cost no item qty unit unit price cost
Rp - 1 KG Rp -
Rp - 2 KG Rp -
Rp - 3 KG Rp -
Rp - 4 KG Rp -
Rp - 5 KG Rp -
Rp - 6 KG Rp -
Rp - 7 KG Rp -
Rp - 8 Rp -
Rp - 9 Rp -
Rp - 10 Rp -
Rp - 11 Rp -
Rp - 12 Rp -
Rp - total cost Rp -
Rp - alowence 10% Rp -
Rp - cogs Rp -
selling price
#DIV/0! cost percentage #DIV/0!
 por
cost
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -

#DIV/0!
 SOSIS BBQ
yeild 1 por
no item qty unit unit price cost no
1 saus bbq 0.01 KG Rp 9,000 Rp 90 1
2 kol putih 0.09 KG Rp 16,000 Rp 1,440 2
3 kol umgu 0.01 KG Rp 27,000 Rp 270 3
4 mayonais 0.01 KG Rp 6,200 Rp 62 4
5 saus tomat 0.01 KG Rp 16,000 Rp 160 5
6 tomato mariana 0.02 KG Rp 26,900 Rp 538 6
7 madu 0.06 KG Rp 21,850 Rp 1,311 7
8 lea perins 0.01 btl Rp 22,890 Rp 229 8
9 gula merah 0.01 kg Rp 25,000 Rp 250 9
10 blavck pepper 0.02 kg Rp 59,000 Rp 1,180 10
11 SOSIS 0.01 peck Rp 75,000 Rp 750 11
12 Rp - 12
total cost Rp 6,280 total cost
alowence 10% Rp 628 alowence
cogs Rp 6,908 cogs
selling price Rp 20,000 selling price
cost percentage 35% cost percentage

TAHU CABE GARAM

yeild 1 por
no item qty unit unit price cost no
1 TAHU KG Rp - 1
2 CABE SETAN KG Rp - 2
3 BAWANG PUTIH KG Rp - 3
4 D BAWANG KG Rp - 4
5 KG Rp - 5
6 KG Rp - 6
7 KG Rp - 7
8 Rp - 8
9 Rp - 9
10 Rp - 10
11 Rp - 11
12 Rp - 12
total cost Rp - total cost
alowence 10% Rp - alowence
cogs Rp - cogs
selling price selling price
cost percentage #DIV/0! cost percentage
 UBI GORENG
yeild 1 por
no item qty unit unit price cost no
1 UBI KG Rp - 1
2 SAUS TOMAT KG Rp - 2
3 SAUS SAMBAL KG Rp - 3
4 KG Rp - 4
5 KG Rp - 5
6 KG Rp - 6
7 KG Rp - 7
8 Rp - 8
9 Rp - 9
10 Rp - 10
11 Rp - 11
12 Rp - 12
total cost Rp - total cost
alowence 10% Rp - alowence
cogs Rp - cogs
selling price selling price
cost percentage #DIV/0! cost percentage

HARGA UBI
cari tau harga satuan yeild 10 por
no item qty unit unit price cost
1 UBI KAYU/RAMBAT 1 KG Rp 50,000 Rp 50,000
2 KG Rp -
3 KG Rp -
4 KG Rp -
5 KG Rp -
6 KG Rp -
7 KG Rp -
8 Rp -
9 Rp -
10 Rp -
11 Rp -
12 Rp -
total cost Rp 50,000
alowence 10%
cogs Rp 5,000
HARGA SATUAN
 CHICKEN NUGGET FRENCH FRIES
yeild 1 por
item qty unit unit price cost no item qty
SAUS KG Rp - 1 FRENCH FRIES
MAYONAISE KG Rp - 2 GARAM
SELADA KG Rp - 3 D.PARSLEY
NUGGET KG Rp - 4
KG Rp - 5
KG Rp - 6
KG Rp - 7
Rp - 8
Rp - 9
Rp - 10
Rp - 11
Rp - 12
Rp - total cost
10% Rp - alowence 10%
Rp - cogs
selling price selling price
cost percentage #DIV/0! cost percentage

SPRING ROLL CARI TAU HARGA NUGGET

yeild 1 por cari tau harga satuan
item qty unit unit price cost no item qty
KULIT SPRING ROLL KG Rp - 1 NUGGET 1
KOL KG Rp - 2
WORTEL KG Rp - 3
B PUTIH KG Rp - 4
D.BAWANG KG Rp - 5
AYAM DADA KG Rp - 6
KG Rp - 7
Rp - 8
Rp - 9
Rp - 10
Rp - 11
Rp - 12
Rp - total cost
10% Rp - alowence 10%
Rp - cogs
selling price HARGA SATUAN
cost percentage #DIV/0!
 PISANG KEJU ONION RINGS
yeild 1 por
item qty unit unit price cost no item qty
TEPUNG CAKRA KG Rp - 1 BOMBAY
T BERAS KG Rp - 2 T CAKRA
PISANG KG Rp - 3 T BERAS
GULA KG Rp - 4 TELUR
SERES KG Rp - 5 T ROTI
SUSU KG Rp - 6
KEJU KG Rp - 7
Rp - 8
Rp - 9
Rp - 10
Rp - 11
Rp - 12
Rp - total cost
10% Rp - alowence 10%
Rp - cogs
selling price selling price
cost percentage #DIV/0! cost percentage
 FRENCH FRIES
yeild 1 por
unit unit price cost
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -

#DIV/0!

RI TAU HARGA NUGGET

yeild 30 por
unit unit price cost
KG Rp 50,000 Rp 50,000
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp 50,000

Rp 1,667
ONION RINGS
yeild 1 por
unit unit price cost
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -

#DIV/0!
 SPAGHETTI CARBONARA SPAG
yeild 1 por
no item qty unit unit price cost no
1 PASTA KG Rp - 1
2 SUSU KG Rp - 2
3 SMOCKED BEEF KG Rp - 3
4 BOMBAY KG Rp - 4
5 COOKING CREAM KG Rp - 5
6 PARMESAN KG Rp - 6
7 FRENCH BREAD KG Rp - 7
8 Rp - 8
9 Rp - 9
10 Rp - 10
11 Rp - 11
12 Rp - 12
total cost Rp - total cost
alowence 10% Rp - alowence
cogs Rp - cogs
selling price selling price
cost percentage #DIV/0! cost percentage

CARI TAU MODAL COLESLOW

CONTOH CARI SATUAN PORSI yeild 10 por
no item qty unit unit price cost no
1 KOL PUTIH 1 KG Rp 17,000 Rp 17,000 1
2 KOL UNGU 1 KG Rp 15,000 Rp 15,000 2
3 MYONAIS KG Rp - 3
4 WORTEL KG Rp - 4
5 KG Rp - 5
6 KG Rp - 6
7 KG Rp - 7
8 Rp - 8
9 Rp - 9
10 Rp - 10
11 Rp - 11
12 Rp - 12
total cost Rp 32,000 total cost
alowence alowence
cogs Rp 3,200 cogs
selling price
cost percentage
 yeild 1 por
no item qty unit unit price cost
1 KG Rp -
2 KG Rp -
3 KG Rp -
4 KG Rp -
5 KG Rp -
6 KG Rp -
7 KG Rp -
8 Rp -
9 Rp -
10 Rp -
11 Rp -
12 Rp -
total cost Rp -
alowence 10% Rp -
cogs Rp -
selling price
cost percentage #DIV/0!
 SPAGHETTY AGLIO E OLIO CHICKEN WINGS BBQ
yeild 1 por
item qty unit unit price cost no item
PASTA KG Rp - 1 SAYAP AYAM
B PUTIH KG Rp - 2 SAUS BBQ
C SETAN KG Rp - 3 KOLSLOW
SMOKED BEEF KG Rp - 4 MAYONAIS
C KERING KG Rp - 5
PARMESAN KG Rp - 6
FRENCH BREAD KG Rp - 7
Rp - 8
Rp - 9
Rp - 10
Rp - 11
Rp - 12
Rp - total cost
10% Rp - alowence
Rp - cogs
selling price selling price
cost percentage #DIV/0! cost percentage

yeild 1 por
item qty unit unit price cost no item
KG Rp - 1
KG Rp - 2
KG Rp - 3
KG Rp - 4
KG Rp - 5
KG Rp - 6
KG Rp - 7
Rp - 8
Rp - 9
Rp - 10
Rp - 11
Rp - 12
Rp - total cost
10% Rp - alowence
Rp - cogs
selling price selling price
cost percentage #DIV/0! cost percentage
CHICKEN WINGS BBQ
yeild 1 por
qty unit unit price cost
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
10% Rp -
Rp -

#DIV/0!

yeild 1 por
qty unit unit price cost
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
10% Rp -
Rp -

#DIV/0!
 AYAM SAMBAL MATAH AYAM
RICE BOWL yeild 1 por RICE BOWL
no item qty unit unit price cost no
1 NASI PUTIH 1 POR Rp 1,400 Rp 1,400 1
2 T CAKRA KG Rp - 2
3 T BERAS KG Rp - 3
4 TELUR KG Rp - 4
5 C SETAN KG Rp - 5
6 D.JERUK KG Rp - 6
7 B MERAH KG Rp - 7
8 SERAY Rp - 8
9 TIMUN Rp - 9
10 SELADA Rp - 10
11 TOMAT Rp - 11
12 AYAM DADA Rp - 12
13 BELACAN Rp -
14 1 Rp -
total cost Rp 1,400 total cost
alowence 10% Rp 140 alowence
cogs Rp 1,540 cogs
selling price selling price
cost percentage #DIV/0! cost percentage

CHICKEN BBQ BEE

yeild 1 por
no item qty unit unit price cost no
1 NASI PUTIH 1 POR Rp 1,400 Rp 1,400 1
2 KG Rp - 2
3 KG Rp - 3
4 KG Rp - 4
5 KG Rp - 5
6 KG Rp - 6
7 KG Rp - 7
8 Rp - 8
9 Rp - 9
10 Rp - 10
11 Rp - 11
12 Rp - 12
13 Rp - 13
14 Rp - 14
15 Rp - 15
16 Rp - 16
17 Rp - 17
 18 1 Rp - 18
total cost Rp 1,400 total cost
alowence 10% Rp 140 alowence
cogs Rp 1,540 cogs
selling price selling price
cost percentage #DIV/0! cost percentage
 AYAM LADA HITAM CHICKEN SALTED EGGS
RICE BOWL yeild 1 por RICE BOWL
item qty unit unit price cost no item qty
NASI PUTIH 1 POR Rp 1,400 Rp 1,400 1 NASI PUTIH 1
KG Rp - 2
KG Rp - 3
KG Rp - 4
KG Rp - 5
KG Rp - 6
KG Rp - 7
Rp - 8
Rp - 9
Rp - 10
Rp - 11
Rp - 12
Rp -
Rp -
Rp 1,400 total cost
10% Rp 140 alowence 10%
Rp 1,540 cogs
selling price selling price
cost percentage #DIV/0! cost percentage

BEEF BULGOGI
yeild 1 por
item qty unit unit price cost no item qty
NASI PUTIH KG Rp - 1
BEEF SLICE KG Rp - 2
B PUTIH KG Rp - 3
KG Rp - 4
KG Rp - 5
KG Rp - 6
KG Rp - 7
Rp - 8
Rp - 9
Rp - 10
Rp - 11
Rp - 12
Rp - 13
Rp - 14
Rp - 15
Rp - 16
Rp - 17
 Rp - 18
Rp - total cost
10% Rp - alowence 10%
Rp - cogs
selling price selling price
cost percentage #DIV/0! cost percentage
CHICKEN SALTED EGGS
yeild 1 por
unit unit price cost
POR Rp 1,400 Rp 1,400
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp 1,400
Rp 140
Rp 1,540

#DIV/0!

yeild 1 por
unit unit price cost
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -

#DIV/0!
 yeild 1 por
no item qty unit unit price cost no
1 POR Rp - 1
2 KG Rp - 2
3 KG Rp - 3
4 KG Rp - 4
5 KG Rp - 5
6 KG Rp - 6
7 KG Rp - 7
8 Rp - 8
9 Rp - 9
10 Rp - 10
11 Rp - 11
12 Rp - 12
13 Rp - 13
14 Rp - 14
total cost Rp - total cost
alowence 10% alowence
cogs cogs

cost percentage cost percentage

 yeild 1 por
item qty unit unit price cost no item qty
POR Rp - 1
KG Rp - 2
KG Rp - 3
KG Rp - 4
KG Rp - 5
KG Rp - 6
KG Rp - 7
Rp - 8
Rp - 9
Rp - 10
Rp - 11
Rp - 12
Rp - 13
Rp - 14
Rp - total cost
10% alowence 10%
cogs

cost percentage cost percentage

yeild 1 por
unit unit price cost
POR Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
KG Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -
Rp -