Rincian Keuangan

Download as pdf or txt
Download as pdf or txt
You are on page 1of 7

Biaya Investasi Total Rp8,439,000

no Uraian Volume Harga/satuan Harga


1 kompor 2 Rp450,000 Rp900,000
2 tabung LPG 3KG 2 Rp150,000 Rp300,000
3 kulkas 1 Rp2,700,000 Rp2,700,000
4 blender 1 Rp400,000 Rp400,000
5 wajan 1 Rp50,000 Rp50,000
6 panci 3 Rp62,000 Rp186,000
7 teflon 2 Rp100,000 Rp200,000
8 mixer 2 Rp110,000 Rp220,000
9 spatula 3 Rp50,000 Rp150,000
10 deep frying 1 Rp675,000 Rp675,000
11 oven 1 Rp700,000 Rp700,000
12 sendok 2 lusin Rp30,000 Rp60,000
13 pisau 3 Rp80,000 Rp240,000
14 telenan 3 Rp20,000 Rp60,000
15 bowl 1 lusin Rp84,000 Rp84,000
16 piring 2 lusin Rp217,000 Rp434,000
17 pencapit 2 Rp15,000 Rp30,000
18 galon 1 Rp50,000 Rp50,000
19 cangkir 1 lusin Rp120,000 Rp120,000
20 smoothie glass 1 lusin Rp64,000 Rp64,000
21 sedotan 1 pack Rp10,000 Rp10,000
22 rice cooker 1 Rp350,000 Rp350,000
23 centong nasi 2 Rp10,000 Rp20,000
24 crofffle maker 1 Rp150,000 Rp150,000
25 balon whisk 3 Rp15,000 Rp45,000
26 timbangan 2 Rp40,000 Rp80,000
27 sumpit 1 pack Rp11,000 Rp11,000
28 ceramic bowl 12 buah Rp10,000 Rp120,000
29 jigger 1 Rp30,000 Rp30,000
Biaya gedung
No. Tempat Volume Harga Satuan Harga Total Rp 6.600.000
1 Sewa gedung 1 gedung 80.000.000/thn 6.600.000/bulan
Biaya Bahan Habis Pakai
Bahan Habis Volume satuan (gr/ml)
Harga Satuan (Rp) Nilai (Rp) Total bahan Kenaikan 60% Harga Jual/porsi
Smoothie Naga Nanas Rp9,960 1.67 Rp16,633
Buah naga 100 20.000/1000 gr Rp2,000
Buah nanas 50 10.000/ 1000 gr Rp500
Yoghurt 40 40.000/500 gr Rp3,200
Madu 15 25.000/500 ml Rp750
Oatmeal 30 18.000/250 gr Rp2,160
Kacang Almond 10 15.000/200 gr Rp750
Chia seed 10 60.000/1000 gr Rp600
Smoothie Strawberry Mangga 12770 1.67 21325.9
Buah strawberry 50 30.000/500 gr 3000
Buah mangga 100 20.000/1000 gr 2000
Yoghurt 40 40.000/500 gr 3200
Madu 15 25.000/500 gr 750
Susu 30 5.000/250 ml 600
Kismis 10 15.000/200 gr 750
Granola 10 70.000/400 gr 1750
Oatmeal 10 18.000/250 gr 720
Milkshake Banana 5660 1.67 9452.2
Pisang cavendish 125 Rp. 30.000/ 1kg 3750
Susu UHT 50 Rp, 13.000/ 1 liter 50
Es Krim Vanilla 10 Rp. 60.000/ 1,5 liter 400
Ekstrak Vanilla 2 Rp. 9.000/ 50 ml 360
whipping cream 20 Rp. 55.000/ 1 liter 1100
Milkshake Berry 8630 1.67 14412.1
Pisang cavendish 50 Rp. 30.000/ 1kg 1500
Blackberry 50 Rp, 26.000/ 500 gr 2600
Strawberry 50 Rp. 35.000/ 1kg 1750
Susu UHT 60 Rp. 13.000/ 1 liter 780
Yourt plain 25 Rp. 44.000/ 1 liter 1100
Madu 15 Rp. 60.000/ 1 liter 900
Mojito Ocean Blue 3821 1.67 6381.07
Sirup coco pandan 20 Rp 20.800/550ml 756
Gula pasir 20 Rp 11.800/1kg 321
Soda (sprite) 100 Rp 18.500/1,5liter 1233
Biji selasih 8 Rp 10.900/100gram 872
Nata de coco 8 Rp 12.450/1kg 99
Jeruk nipis 1 Rp 500/1buah 500
ice 20 Rp 1000/500gram 40
Dalgona Coffe 4636 1.67 7742.12
Kopi Bubuk 30 Rp.12.300/165 gr 2236
Gula Aren 50 Rp.28.000/kg 1400
Susu cair 50 Rp.14.000/L 700
Choco granola 5 Rp.30.000/1/2 kg 300
Cappucino Cincau 5036 1.67 8410.12
Kopi Bubuk 30 Rp.12.300/165 gr 2236
Susu Kental Manis 30 Rp.9.500/370 gr 770
Fiber Cream Bubuk 10 Rp.11.350/100 gr 1135
Gula Pasir 15 Rp.13.000/Kg 195
Cincau 50 Rp.7.000/500 gr 700
Potato Fries 14598 1.67 24378.66
Kentang 250 Rp 20.000/kg 5000
Tepung maizena 50 Rp 4.000/ 150 gr 1334
Keju parut 25 Rp 16.000/ 165 gr 1424
Garam 5 Rp 6.000/ ½ kg 90
Merica bubuk 3 Rp 30.000/ 100 gr 900
Kaldu bubuk 2 Rp 25.000/ 150 gr 500
Seledri 5 Rp 2.000/ 100 gr 100
Minyak goreng 250 Rp 21.000/ L 5250
Onion Ring 12243 1.67 20445.81
Bawang bombay 50 Rp 8.000/ 250 gr 1600
Tepung roti 50 Rp 12.000/ 500 gr 1200
Kaldu bubuk 5 Rp 25.000/ 150 gr 833
Tepung terigu 100 Rp 10.000/ kg 1000
Minyak goreng 250 Rp 21.000/ L 5250
Tepung maizena 30 Rp 4.000/ 150 gr 800
Garam 5 Rp 6.000/ ½ kg 60
Merica bubuk 5 Rp 30.000/ 100 gr 1500
Air es 200 - -
Chocolate Pancake 3005 1.67 5018.35
Telur 150 17.000/kg 850
Vanilla extract 1 55.000/ 80 ml 687
Susu cair 25 17.400/1000ml 435
Tepung terigu 27 10.000/kg 270
Cocoa powder 5 20.000/ 45 gr 22
Baking powder 2 6.000/ 45gr 266
Gula 25 11.000/ kg 275
Mentega 20 5000/500 gr 200
Fluffy Pancake 3767 1.67 6290.89
Tepung terigu 52.5 10.000/ kg 525
gula 12 12.000/ kg 144
Baking powder 2 6.000/45 gr 133
garam 2 10.800/ kg 22
Baking soda 2 76.000/500 gr 304
telur 60 17.000/kg 1020
Susu cair 60 17.400/ 1000ml 104
Mentega cair 7 5000/250 gr 140
Vanilla extract 2 55.000/ 80 ml 1375
Desssert Box Red Velvet 12673 1.67 21163.91
Telur 180 16.000/kg 3000
gula pasir 50 13.000/kg 650
emulsifer 10 7.000/35g 2000
tepung terigu pro sedang 60 10.000/kg 600
tepung maizena 10 19.000/kg 190
coklat bubuk 10 150.000/kg 1500
mentega 50 15.000/kg 750
susu cair 20 15.000/lt 300
pewarna merah 1 5.000/60ml 83
cream cheese 10 180.000/kg 1800
whipped cream 20 80.000/kg 1800
Crispy Chicken mentai 19717 1.67 32927.39
daging ayam fillet 50 32.000/kg 1600
tepung terigu 30 7.000/kg 210
tepung maizena 10 5.000/100g 50
Air es 100
minyak goreng 300 30.000/lt 9000
saus pedas 30 24.000/950g 757
saus tomat 10 16.500/950g 170
bubuk cabai 2 10.500/100g 210
mayonaise 30 12.000/500g 720
Keju 10 12.500/250g 500
beras 150 50.000/5kg 1500
bubuk nori boncabe 15 20.000/60g 5000
Chicken Katsu with Curry 15395 1.67 25709.65
Bawang Bombay 50 16.000/kg 800
kentang 50 11.000/kg 550
wortel 50 10.000/kg 500
minyak goreng 45 30.000/kg 675
Air 500 -
curry block 18 34.000/180g 3400
daging ayam fillet 50 32.000/kg 1600
tepung terigu 15 7.000/kg 105
garam 2 2.500/250 20
lada 1 1.000/8g 125
telur 1 16.000/kg 960
tepung panir 30 11.000/500g 660
minyak goreng 300 30.000/2 lt 4500
beras 150 50.000/5kg 1500
Air es 250 -
Croissant Wafle 1796 1.67 2999.32
Tepung terigu pt 50 10.000/ kg 500
gula 6 12.000/ kg 72
Ragi 1 3.000/11 gr 272
Telur 2.5 5.500/ 250 gr 55
Air es 10 1000/1000 gr 10
Susu UHT dingin 12 6.000/500ml 144
Margarin 1.5 4.000/250 gr 40
Garam 0.6 2.000/340 gr 3
Korsvet 2.5 7.000/250 gr 700
Vegie Tempura 8632 1.67 14415.44
Terong ungu 30 Rp 6.000/kg 180
Buncis 25 Rp 17.500/ kg 437
Bawang Bombay 25 Rp 8.000/ 250 gr 800
Tepung terigu 75 Rp 10.000/ kg 750
Tepung beras 15 Rp 7.500/ 500 gr 225
Air 100 - -
Garam 2 Rp 6.000/ ½ kg 90
Merica bubuk 1 Rp 30.000/ 100 gr 900
Minyak goreng 250 Rp 21.000/ L 5250
Desssert Box Nutella 12673 1.67 21163.91
Telur 180 16.000/kg 3000
gula pasir 50 13.000/kg 650
emulsifer 10 7.000/35g 2000
tepung terigu pro sedang 60 10.000/kg 600
tepung maizena 10 19.000/kg 190
coklat bubuk 10 150.000/kg 1500
mentega 50 15.000/kg 750
susu cair 20 15.000/lt 300
pewarna merah 1 5.000/60ml 83
cream cheese 10 180.000/kg 1800
whipped cream 20 80.000/kg 1800
Total : Rp155,012 Kenaikan 60% Rp258,870 total/bulan (pokok) 4 Rp43,403,360
Kapasitas Produksi : 10/hari Total/hari : Rp1,550,120 10 Rp2,588,700
hari kerja per pekan : 7 Total/Minggu Rp10,850,840 7 Rp18,120,903 Total/bulan (harga jual) Rp72,483,611
Biaya Kemasan
Nomor
Uraian Volume Harga/satuan Harga
1 paper bowl 10 500 5,000
2 paper bag 15 400 6,000
3 sendok plastik 40 200 8,000
4 grapu plastik 40 120 4,800
5 aluminium voil cup 25 1,000 25,000
6 paper box 15 200 3,000
7 coffee cup 10 400 4,000
8 plastic glass 34 200 6,800
9 dessert box 10 200 2,000
10 plastic bag 10 400 4,000
Total 68,600 4
Total/minggu 480,200 Total/bulan Rp1,920,800 Rp1,921,603
Gaji Karyawan
No. Posisi Jumlah Upah/hari Perminggu Perbulan
1 Manajer Operasional 1 40000 40000 7 280000
2 Kasir 2 38000 76000 7 532000
3 Chef 2 38000 76000 7 532000
4 Barista 2 38000 76000 7 532000
5 Delivery 2 38000 76000 7 532000 4
Beban gaji/hari 344000 2408000 Rp9,632,000

Biaya Operasional
No Keperluan Volume Harga Satuan Harga Total Perminggu Perbulan
1 Bensin Belanja 1L 11000 11000 7 77000
2 Bensin Distribusi 2L 11000 22000 7 154000
3 Listrik 24 jam 50000 50000 7 350000
4 Gas 0,3 (2 buah) 19000 12600 7 88200
5 Air 24 jam 45000 45000 7 315000 4
6 b. operasional/hari 140600 984200 Rp3,936,800

Biaya Administrasi
no. Administrasi Publik Volume Harga Satuan (Rp) Nilai (Rp)
Biaya promosi melalui
Instagram, whatsapp dan
1 diskon 250 250
Biaya promosi melalui
2 pamflet, banner dan poster 3 buah 100 300
3 Pembelian buku keuangan 1 buah 15 15
4 Paket internet XL 50 gb 225 225
TOTAL Rp. 790.000

Total biya keseluruhan produksi/hari 2721020


Bahan habis pakai 1550120
Kemasan 686300
Gaji karyawan 344000
Operasional 140600

HPP rata2 (Total biaya produksi/hari: total produksi) 17


Rp 160060
Presentase keuntungan ((harga jual - HPP) : HPP)
harga jual 2588700.4 2428640.4
HPP 160060 Break Event Point 155012 10
HPP 160060 160060 1550120
Total 15%
BEP/Unit 1550120 160060
9.684618268
10 produk/menu

Rencana Aliran Kas

URAIAN TRANSAKSI BULAN 1 BULAN 2 BULAN 3 BULAN 4


PERSEDIAAN PRODUK - - - -
1 2 3 4
Kas Awal Bulan Rp100,000,000 Rp97,760,848 Rp102,960,696 Rp135,319,492
Jumlah Unit Terjual 170 170 340 340
Nilai Penjualan Rp72,483,611 Rp72,483,611 Rp144,967,222 Rp144,967,222
Pendapatan lain-lain
jumlah pemasukan Rp172,483,611 Rp170,244,459 Rp247,927,918 Rp280,286,714

Biaya Sewa Gedung Rp6,600,000 Rp6,600,000 Rp6,600,000 Rp6,600,000


Biaya Investasi Rp8,439,000 - - -
Pembelian bahan habis pakai Rp43,403,360 Rp43,403,360 Rp86,806,420 Rp86,806,420
pembelian kemasan Rp1,921,603 Rp1,921,603 Rp3,843,206 Rp3,843,206
biaya operasional Rp3,936,800 Rp3,936,800 Rp3,936,800 Rp3,936,800
biaya administrasi Rp790,000 Rp790,000 Rp790,000 Rp790,000
Gaji dan Upah Rp9,632,000 Rp9,632,000 Rp9,632,000 Rp9,632,000
Biaya Penyusustan Peralatan Rp1,000,000 Rp1,000,000 Rp1,000,000
Jumlah Pengeluaran : Rp74,722,763 Rp67,283,763 Rp112,608,426 Rp112,608,426

Saldo Akhir Bulan : Rp97,760,848 Rp102,960,696 Rp135,319,492 Rp167,678,288 saldo akhir Rp167,678,288
total laba rugi Rp67,678,288
Laba -Rugi : -Rp2,239,152 Rp5,199,848 Rp32,358,796 Rp32,358,796 Rp67,678,288
modal Rp100,000,000

You might also like