Contoh HPP Makanan

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 18

NOMOR BAHAN POKOK QTY UNIT CONVERTION UNIT QTY

1 IGA SAPI 1 KG gram 1000


2 DAGING UTUH 2 KG gram 2000
3 AYAM UTUH 3 KG gram 3000
4 DADA FILET 3 KG gram 3000
5 KULIT AYAM 1 KG gram 1000
6 BAKSO 1 PACK pcs 100
7 SMOKED BEEF 500 gram gram 500
8 SOSIS 2 PACK pcs 82
9 NUGGET 1 PACK pcs 40
10 KENTANG GORENG 5 KG gram 5000
11 MIE AYAM MENTAH 2 PACK gram 1000
12 TELOR AYAM 2 TRAY butir 60
13 BERAS 20 LITER gram 20000
14 MINYAK GORENG 10 LITER ml 10000
15 MINYAK WIJEN 1 BOTOL ml 640
16 TEPUNG TAPIOKA 1 KG gram 1000
17 TEPUNG SEGITIGA BIRU 2 KG gram 2000
18 TEPUNG ROTI 1.5 KG gram 1500
19 GULA MERAH 2 KG gram 2000
20 GULA PASIR 2 KG gram 2000
21 GULA HALUS 1 KG gram 1000
22 GARAM 1 KG gram 1000
23 KNORR 1 KG gram 1000
24 SASA MSG 1 KG gram 1000
25 LADA PUTIH 500 gram gram 500
26 SAOS SAMBEL 5.5 KG gram 5500
27 SAOS TOMAT 1 KG gram 1000
28 MAYONAISE 2 KG gram 2000
29 KECAP MANIS 2 KG gram 2000
30 KECAP ASIN ANGSA 1 BOTOL ml 600
31 KECAP IKAN 1 BOTOL ml 600
32 CUKA 1 BOTOL ml 650
33 BBQ MARINASI 1 KG gram 1000
34 BLACK PEPPER MARINASI 1 KG gram 1000
35 HONEY MUSTARD 1 KG gram 1000
36 BUTTER ANCHOR 1 KG gram 1000
37 MAPLE SYRUP 1 KG gram 1000
38 NUTELLA 1 KG gram 1000
39 VANILLA PERASA 1 BOTOL gram 30
40 SKM 500 gram gram 500
41 SUSU FULL CREAM 1 DUS ml 12000
42 KEJU CHEDDAR 2 KG gram 2000
43 KEJU QUICK MELT 500 gram gram 500
44 CURRY PASTE 1 KG gram 1000
45 TOMYAM PASTE 1 DUS pack 12
46 ONION POWDER 1 KG gram 1000
47 GARLIC POWDER 500 gram gram 500
48 SMOKED PAPRIKA POWDER 250 gram gram 250
49 OREGANO 100 gram gram 100
50 BAKING POWDER 110 gram gram 110
51 ASAM JAWA 150 gram gram 150
52 DAUN BAWANG 250 gram gram 250
53 DAUN SALAM 250 gram lembar 250
54 DAUN JERUK 100 gram lembar 100
55 SEREH 250 gram gram 250
56 JAHE 250 gram gram 250
57 LENGKUAS 250 gram gram 250
58 JAMUR TIRAM 250 gram gram 250
59 TOMAT IJO BUAH 500 gram gram 500
60 TOMAT MERAH BUAH 500 gram gram 500
61 WORTEL 1 KG gram 1000
62 TIMUN 1 KG gram 1000
63 KOL 1 KG gram 1000
64 KENTANG SAYUR 1 KG gram 1000
65 LETTUCE 1 KG gram 1000
66 POKCOY 500 gram gram 500
67 CABE MERAH KRITING 250 gram gram 250
68 CABE MERAH BESAR 250 gram gram 250
69 CABE RAWIT SETAN 250 gram gram 250
70 BAWANG MERAH 1 KG gram 1000
71 BAWANG PUTIH 1 KG gram 1000
72 BAWANG BOMBAY 1 KG gram 1000
73 KEMIRI 250 gram gram 250
74 KETUMBAR 250 gram gram 250
75 JERUK LIMO 500 gram gram 500
76 JERUK LEMON 500 gram gram 500
77 MIX BERRIES 500 gram gram 500
78 PISANG RAJA 2 SISIR buah 40

TOTAL
HARGA FINAL COST
Rp 29,000.00 Rp 29.00
Rp 180,000.00 Rp 90.00
Rp 150,000.00 Rp 50.00
Rp 180,000.00 Rp 60.00
Rp 40,000.00 Rp 40.00
Rp 40,000.00 Rp 400.00
Rp 60,000.00 Rp 120.00
Rp 80,000.00 Rp 975.61
Rp 22,000.00 Rp 550.00
Rp 154,000.00 Rp 30.80
Rp 24,000.00 Rp 24.00
Rp 100,000.00 Rp 1,666.67
Rp 220,000.00 Rp 11.00
Rp 230,000.00 Rp 23.00
Rp 40,000.00 Rp 62.50
Rp 10,000.00 Rp 10.00
Rp 30,000.00 Rp 15.00
Rp 30,000.00 Rp 20.00
Rp 18,000.00 Rp 9.00
Rp 32,000.00 Rp 16.00
Rp 15,000.00 Rp 15.00
Rp 10,000.00 Rp 10.00
Rp 90,000.00 Rp 90.00
Rp 50,000.00 Rp 50.00
Rp 60,000.00 Rp 120.00
Rp 141,000.00 Rp 25.64
Rp 15,000.00 Rp 15.00
Rp 80,000.00 Rp 40.00
Rp 100,000.00 Rp 50.00
Rp 22,000.00 Rp 36.67
Rp 36,000.00 Rp 60.00
Rp 15,000.00 Rp 23.08
Rp 35,000.00 Rp 35.00
Rp 40,000.00 Rp 40.00
Rp 65,000.00 Rp 65.00
Rp 150,000.00 Rp 150.00
Rp 40,000.00 Rp 40.00
Rp 150,000.00 Rp 150.00
Rp 25,000.00 Rp 833.33
Rp 18,000.00 Rp 36.00
Rp 190,000.00 Rp 15.83
Rp 195,000.00 Rp 97.50
Rp 225,000.00 Rp 450.00
Rp 150,000.00 Rp 150.00
Rp 90,000.00 Rp 7,500.00
Rp 50,000.00 Rp 50.00
Rp 50,000.00 Rp 100.00
Rp 65,000.00 Rp 260.00
Rp 20,000.00 Rp 200.00
Rp 13,000.00 Rp 118.18
Rp 7,000.00 Rp 46.67
Rp 8,000.00 Rp 32.00
Rp 5,000.00 Rp 20.00
Rp 3,000.00 Rp 30.00
Rp 8,000.00 Rp 32.00
Rp 10,000.00 Rp 40.00
Rp 7,000.00 Rp 28.00
Rp 10,000.00 Rp 40.00
Rp 20,000.00 Rp 40.00
Rp 20,000.00 Rp 40.00
Rp 25,000.00 Rp 25.00
Rp 20,000.00 Rp 20.00
Rp 24,000.00 Rp 24.00
Rp 20,000.00 Rp 20.00
Rp 20,000.00 Rp 20.00
Rp 12,000.00 Rp 24.00
Rp 12,000.00 Rp 48.00
Rp 12,000.00 Rp 48.00
Rp 20,000.00 Rp 80.00
Rp 30,000.00 Rp 30.00
Rp 30,000.00 Rp 30.00
Rp 18,000.00 Rp 18.00
Rp 15,000.00 Rp 60.00
Rp 10,000.00 Rp 40.00
Rp 22,000.00 Rp 44.00
Rp 10,000.00 Rp 20.00
Rp 80,000.00 Rp 160.00
Rp 40,000.00 Rp 1,000.00

Rp 4,392,000
NOMOR NAMA BAHAN QTY UNIT FINAL COST
1 DAGING BP DAGING 1000 gram Rp 90,000.00
BP MARINASI 400 gram Rp 16,000.00
FINAL

2 DAGING BBQ DAGING 1000 gram Rp 90,000.00


BBQ MARINASI 500 gram Rp 17,500.00
FINAL

3 SALAD SAYUR WORTEL 300 gram Rp 7,500.00


KOL 300 gram Rp 7,200.00
MAYONAISE 200 gram Rp 8,000.00
SAOS SAMBEL 200 gram Rp 5,127.27
SAOS TOMAT 200 gram Rp 3,000.00
SKM 10 gram Rp 360.00
GARAM 3 gram Rp 30.00
FINAL

4 SAMBEL CABE KRITING 50 gram Rp 2,400.00


CABE SETAN 100 gram Rp 8,000.00
BAWANG PUTIH 6 gram Rp 180.00
GARAM 6 gram Rp 60.00
GULA 3 gram Rp 48.00
MINYAK 50 ml Rp 1,150.00
SASA MSG 2 gram Rp 100.00
KNORR 10 gram Rp 900.00
FINAL

5 CIRENG TEPUNG TAPIOKA 400 gram Rp 4,000.00


GARAM 12 gram Rp 120.00
SASA MSG 2 gram Rp 100.00
KNORR 10 gram Rp 900.00
BAWANG PUTIH 6 gram Rp 180.00
DAUN BAWANG 3 gram Rp 96.00
AIR 400 ml Rp -
FINAL

6 SAMBEL RUJAK GULA MERAH 250 gram Rp 2,250.00


CABE RAWIT SETAN 10 gram Rp 800.00
GARAM 6 gram Rp 60.00
AIR ASAM JAWA 50 gram Rp 700.00
AIR 250 ml Rp -
FINAL

7 NUTELLA SAUCE NUTELLA 500 gram Rp 75,000.00


SUSU FULL CREAM 300 gram Rp 4,750.00
FINAL

8 BUMBU NASGOR BAWANG PUTIH 70 gram Rp 2,100.00


BAWANG MERAH 80 gram Rp 2,400.00
KEMIRI 9 gram Rp 540.00
GARAM 18 gram Rp 180.00
GULA 18 gram Rp 288.00
MINYAK 40 ml Rp 920.00
FINAL

9 KECAP BAKMIE AYAM KECAP ASIN ANGSA 50 ml Rp 1,833.33


KECAP IKAN 50 ml Rp 3,000.00
FINAL

10 KUAH KALDU BAKMI TULANG AYAM 330 gram Rp 16,500.00


GARAM 24 gram Rp 240.00
KNORR 18 gram Rp 1,620.00
LADA PUTIH 12 gram Rp 1,440.00
SASA MSG 3 gram Rp 150.00
DAUN BAWANG 25 gram Rp 800.00
AIR 1500 ml Rp -
FINAL

11 TOPING BAKMIE DAGING AYAM 700 gram Rp 35,000.00


DAUN SALAM 2 gram Rp 40.00
DAUN JERUK 2 gram Rp 60.00
BAWANG PUTIH 20 gram Rp 600.00
BAWANG MERAH 15 gram Rp 450.00
GULA MERAH 30 gram Rp 270.00
GULA PASIR 30 gram Rp 480.00
KECAP MANIS 40 gram Rp 2,000.00
KECAP IKAN 15 gram Rp 900.00
KECAP ASIN 10 gram Rp 366.67
GARAM 18 gram Rp 180.00
KNORR 15 gram Rp 1,350.00
SASA MSG 4 gram Rp 200.00
LADA PUTIH 6 gram Rp 720.00
AIR 100 ml Rp -
FINAL

12 MINYAK KULIT KULIT AYAM 500 gram Rp 20,000.00


BAWANG PUTIH 22 gram Rp 660.00
GARAM 15 gram Rp 150.00
KNORR 12 gram Rp 1,080.00
SASA MSG 4 gram Rp 200.00
MINYAK GORENG 10 ml Rp 230.00
FINAL

13 PANCAKES TEPUNG TERIGU 400 gram Rp 6,000.00


SUSU FULL CREAM 300 ml Rp 4,750.00
GULA PASIR 100 gram Rp 1,600.00
BAKING POWDER 3 gram Rp 354.55
TELOR 1 butir Rp 1,666.67
GARAM 3 gram Rp 30.00
BUTTER 60 gram Rp 9,000.00
VANILLA PERISA 2 gram Rp 1,666.67
FINAL

14 WAFFLES TEPUNG TERIGU 400 gram Rp 6,000.00


SUSU FULL CREAM 300 ml Rp 4,750.00
GULA PASIR 100 gram Rp 1,600.00
BAKING POWDER 3 gram Rp 354.55
TELOR 2 gram Rp 3,333.33
GARAM 6 gram Rp 60.00
BUTTER 60 gram Rp 9,000.00
VANILLA PERASA 2 gram Rp 1,666.67
FINAL

15 POTATO BALLS KENTANG 1000 gram Rp 20,000.00


KEJU CHEDDAR 150 gram Rp 14,625.00
KEJU QUICK MELT 40 gram Rp 18,000.00
SMOKED BEEF 60 gram Rp 7,200.00
GARAM 18 gram Rp 180.00
KNORR 12 gram Rp 1,080.00
SASA MSG 4 gram Rp 200.00
GARLIC POWDER 8 gram Rp 800.00
ONION POWDER 8 gram Rp 400.00
FINAL

16 ASAM JAWA ASAM JAWA 60 gram Rp 2,800.00


AIR 200 ml Rp -
FINAL

17 ONION RINGS BAWANG BOMBAY 600 gram Rp 10,800.00


GARAM 18 gram Rp 180.00
LADA 6 gram Rp 720.00
TEPUNG TERIGU 50 gram Rp 750.00
TEPUNG ROTI 500 gram Rp 10,000.00
TELOR 3 butir Rp 5,000.00
FINAL

18 CHICKEN POPCORNS DADAFILLET 350 gram Rp 21,000.00


TEPUNG TERIGU 200 gram Rp 3,000.00
ONION POWDER 24 gram Rp 1,200.00
PAPRIKA POWDER 18 gram Rp 4,680.00
GARLIC POWDER 24 gram Rp 2,400.00
KNORR 18 gram Rp 1,620.00
FINAL
TOTAL

Rp 106,000.00
Rp 75.71

Rp 107,500
Rp 72

Rp 31,217.27
Rp 31.22

Rp 12,838.00
Rp 57.06

Rp 5,396.00
Rp 13.49

Rp 3,810.00
Rp 15.24

Rp 79,750.00
Rp 79,750.00
Rp 99.69

Rp 6,428.00
Rp 27.35

Rp 4,833.33
Rp 48.33

Rp 20,750.00
Rp 13.83

Rp 42,616.67
Rp 53.27

Rp 22,320.00
Rp 22,320.00
Rp 44.64

Rp 25,067.88
Rp 35.81

Rp 26,764.55
Rp 38.24

Rp 62,485.00
Rp 62.49

Rp 2,800.00
Rp 14.00

Rp 27,450.00
Rp 25

Rp 33,900.00
Rp 56.50
NOMOR MENU BAHAN QTY UNIT HPP
1 RICE BOWL ( BP ) DAGING MARINASI 60 gram Rp 4,543
NASI 150 gram Rp 1,650
SALAD SAYUR 15 gram Rp 468

2 RICE BOWL ( BBQ ) DAGING MARINASI 60 gram Rp 4,300


NASI 150 gram Rp 1,650
SALAD SAYUR 15 gram Rp 468

3 RB ( CHICKEN CURRY ) DADA FILET 54 gram Rp 2,700


GARLIC POWDER 1 gram Rp 100
GARAM 1 gram Rp 10
LADA 1 gram Rp 120
WORTEL 3 gram Rp 75
KENTANG 3 gram Rp 60
NASI 120 gram Rp 1,320
TELOR 1 butir Rp 1,667
CURRY PASTE 18 gram Rp 2,700

4 ASAM ASAM IGA IGA BACK BONE 1000 gram Rp 29,000


DAGING UTUH 250 gram Rp 22,500
SALAM 1 gram Rp 20
SEREH 25 gram Rp 800
DAUN JERUK 1 gram Rp 30
AIR ASAM JAWA 30 gram Rp 420
JAHE 20 gram Rp 800
LENGKUAS 30 gram Rp 840
GULA MERAH 25 gram Rp 225
GULA PASIR 10 gram Rp 160
KNORR 18 gram Rp 1,620
SASA MSG 12 gram Rp 600
GARAM 24 gram Rp 240
LADA PUTIH 3 gram Rp 360
BUMBU TOMYAM 2 pack Rp 15,000
BAWANG PUTIH 37 gram Rp 1,110
BAWANG MERAH 40 gram Rp 1,200
BELIMBING WULUH 30 gram Rp -
TOMAT IJO BUAH 15 gram Rp 600
CABE KERITING 15 gram Rp 720
CABE RAWIT SETAN 15 gram Rp 1,200
JERUK LIMO 3 buah Rp 132
UNTUK 5 PORSI ( PER-PORSI ) Rp 47,016

5 BAKMI AYAM JAMUR MIE FRESH 85 gram Rp 2,040


POKCOY 5 gram Rp 120
KALDU BAKMI 40 ml Rp 553
KECAP BAKMI 12 gram Rp 580
MINYAK KULIT 15 gram Rp 670
BAKSO 2 PCS Rp 800
TOPING AYAM 35 gram Rp 1,864

6 NASI GORENG NASI 250 gram Rp 2,750


BUMBU PUTIH 3 gram Rp 82
TELOR 1 butir Rp 1,667
SOSIS 1 pcs Rp 976
BAKSO 1 pcs Rp 400
GULA 3 gram Rp 48
GARAM 10 gram Rp 100
LADA PUTIH 3 gram Rp 360
SASA MSG 3 gram Rp 150
KNORR 4 gram Rp 360
KECAP ASIN 3 gram Rp 110
KECAP IKAN 3 gram Rp 180
MINYAK WIJEN 5 gram Rp 313
DAUN BAWANG 2 gram Rp 64

A. OMLET TELUR RB BBQ & BP 1 BUTIR Rp 1,667


FINAL COGS PRICING RECOMMENDED HPP/SALES SALES

Rp 6,661 Rp 20,185 22% Rp 30,000

Rp 6,418 Rp 19,449 21% Rp 30,000

Rp 8,752 Rp 26,520 29% Rp 30,000

Rp 77,577 Rp 235,082 26% Rp 300,000

Rp 6,627 Rp 20,083 20% Rp 33,000


Rp 6,627 Rp 20,083 20% Rp 33,000

Rp 7,559 Rp 22,906 24% Rp 32,000

Rp 1,667 Rp 5,051 28% Rp 6,000


NOMOR MENU BAHAN QTY UNIT HPP
1 FRENCH FRIES KENTANG FORZEN 200 gram Rp 6,160.00
OREGANO 1 gram Rp 200.00

2 SNACK PLATTER KENTANG GORENG 90 gram Rp 2,772.00


SOSIS 2 pcs Rp 1,951.22
NUGGETS 4 pcs Rp 2,200.00
ONION RINGS 40 gram Rp 998.18

3 ONION RINGS ONION RINGS 300 gram Rp 7,486.36

4 CHICKEN POPCORNS CHICKEN POPCORNS 80 gram Rp 4,520.00

5 POTATO BALLS POTATO BALLS 100 gram Rp 6,248.50

6 RUJAK CIRENG CIRENG 100 gram Rp 1,349.00


SAMBEL RUJAK 15 gram Rp 228.60

7 BANANA NUGGETS PISANG 2 sisir Rp 2,000.00


TEPUNG ROTI 20 gram Rp 400.00
TELOR 1 butir Rp 1,666.67
NUTELLA SAUCES 10 gram Rp 996.88

8 PANCAKES PANCAKES 100 gram Rp 3,581.13


MIX BERRIES 10 gram Rp 1,600.00
GULA HALUS 1 gram Rp 15.00
MAPLE SYRUP 10 gram Rp 400.00
BUTTER 15 gram Rp 2,250.00

9 WAFFLES WAFFLES 150 gram Rp 5,735.26


MIX BERRIES 10 gram Rp 1,600.00
GULA HALUS 1 gram Rp 15.00
MAPLE SYRUP 10 gram Rp 400.00
BUTTER 5 gram Rp 750.00

A. NUTELLA ADD ONS PANCAKES & WAFFLES 15 gram Rp 1,495.31


FINAL COGS PRICING RECOMMENDED HPP/SALES SALES

Rp 6,360 Rp 19,273 29% Rp 22,000

Rp 7,921 Rp 24,004 27% Rp 29,000

Rp 7,486 Rp 22,686 30% Rp 25,000

Rp 4,520 Rp 13,697 23% Rp 20,000

Rp 6,249 Rp 18,935 25% Rp 25,000

Rp 1,578 Rp 4,781 11% Rp 15,000

Rp 5,064 Rp 15,344 24% Rp 21,000

Rp 7,846 Rp 23,776 26% Rp 30,000

Rp 8,500 Rp 25,758 28% Rp 30,000

Rp 1,495 Rp 4,531 21% Rp 7,000

You might also like