Usaha Gado Gado

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 11

NO BAHAN BERAT (KG) HARGA SATUAN (KG)

1 KENTANG 1.00 8,000.00


2 LONTONG 1.00 600.00
3 TELUR 1.00 17,000.00
4 TAHU 1.00 2,000.00
5 KECAMBAH 1.00 4,000.00
6 SLADA AIR 1.00 4,000.00
7 KERUPUK 1.00 6,000.00
8 EMPING BLINJO 1.00 4,000.00
9 BAWANG GORENG 0.01 500.00
BUMBU KACANG UNTUK 10 BUNGKUS (3000ML)
10 KACANG 1.00 16,000.00
11 BAWANG PUTIH 1.00 20,000.00
12 BAWANG MERAH 1.00 24,000.00
13 GULA JAWA 1.00 16,000.00
14 SANTAN 1.00 3,500.00
15 GULA PASIR 1.00 12,500.00

16 PEMBUNGKUS (KERTAS,PLASTIK,KRESEK) 1.00 300.00


BELA

PROFIT NETTO P
GADO GADONYA "BUNG" BEN
BUAH PERKG HARGA SATUAN PENGGUNAAN HARGA PERBUNGKUS BELANJA BAHAN (ONS)
6.00 1,333.33 0.50 666.67 25.00
1.00 600.00 0.50 300.00 25.00
19.00 894.74 0.50 447.37 25.00
4.00 500.00 0.25 125.00 0.50
10.00 400.00 1.00 400.00 50.00
5.00 800.00 0.50 400.00 25.00
10.00 600.00 0.50 300.00 25.00
10.00 400.00 0.50 200.00 25.00
1.00 500.00 0.50 250.00 25.00
3,089.04
10.00 1,600.00 2.50 4,000.00 1.25
10.00 2,000.00 0.05 1,000.00 0.25
10.00 2,400.00 0.05 1,200.00 0.25
4.00 4,000.00 0.25 4,000.00 1.25
1.00 3,500.00 2.00 7,000.00 10.00
10.00 1,250.00 0.50 625.00 0.25
1,782.50
1.00 300.00
BELANJA MODAL PERHARI 5,171.54
BELANJA MODAL AWAL
PROFIT NETTO PERBUNGKUS PERHARI 1,828.46
PENDAPATAN KOTOR PERHARI
HARGA PERBUNGKUS 7,000.00
A "BUNG" BEN LEGO
50 BELANJA BAHAN 75 BELANJA BAHAN 100
33,333.33 37.50 50,000.00 8.33 66,666.67
15,000.00 37.50 22,500.00 50.00 30,000.00
22,368.42 37.50 33,552.63 2.63 44,736.84
6,250.00 18.75 9,375.00
20,000.00 75.00 30,000.00 10.00 40,000.00
20,000.00 37.50 30,000.00 10.00 40,000.00
15,000.00 37.50 22,500.00 5.00 30,000.00
10,000.00 37.50 15,000.00 5.00 20,000.00
12,500.00 37.50 18,750.00 50.00 25,000.00
154,451.75 231,677.63 296,403.51
20,000.00 18.75 30,000.00 2.50 40,000.00
5,000.00 3.75 7,500.00 0.50 10,000.00
6,000.00 3.75 9,000.00 0.50 12,000.00
20,000.00 7.50 30,000.00 2.50 40,000.00
35,000.00 15.00 52,500.00 20.00 70,000.00
3,125.00 3.75 4,687.50 0.50 6,250.00
89,125.00 133,687.50 178,250.00
15,000.00 22,500.00 30,000.00
258,576.75 387,865.13 504,653.51
1,458,576.75 1,587,865.13 1,704,653.51
91,423.25 137,134.87 182,846.49
350,000.00 525,000.00 687,500.00
7,000.00 7,000.00 7,000.00
ROMBONG SEWA STAN TERPAL

0
.0

.0

.0
00

00

00
0

0
0,

0,

0,
80

30

10
800,000.00 300,000.00 100,000.00
BELUM TERMASUK LPG,KOMPOR,PERALATAN DAPUR LAINNYA
DATA PENJUALAN HARIAN

BULAN JUNI
TAHUN 2014

TANGGAL HARI FREQ BUNGKUS OMZET BELANJA HARIAN U/ 50 BUNGKUS


1 SEL 30 210,000.00
2 RAB 35 245,000.00
3
4
KAM
JUM
30
30
210,000.00
210,000.00 258,576.75
5 SAB 40 280,000.00
6 MING 40 280,000.00
7 SEN LIBUR
8 SEL 50 350,000.00
9 RAB 56 392,000.00
10
11
KAM
JUM
40
30
280,000.00
210,000.00 258,576.75
12 SAB 50 350,000.00
13 MING 50 350,000.00
14 SEN LIBUR
15 SEL 50 350,000.00 258,576.75

BULAN JULI
TAHUN 2014 137,134.87

TANGGAL HARI FREQ BUNGKUS OMZET BELANJA HARIAN U/ 100 BUNGKUS


1 KAM 60 420,000.00
2
3
JUM
SAB
60
60
420,000.00
420,000.00 387,865.13
4 MING 75 525,000.00
5 SEN LIBUR
6 SEL 65 455,000.00
7 RAB 70 490,000.00
8
9
KAM
JUM
75
70
525,000.00
490,000.00 387,865.13
10 SAB 70 490,000.00
11 MING 75 525,000.00
12 SEN LIBUR
13 SEL 70 490,000.00
14 RAB 75 525,000.00
387,865.13
15 KAM 75 525,000.00
NETT PROFIT TANGGAL HARI FREQ BUNGKUS OMZET
- 16 RAB 50 350,000.00
13,576.75 17 KAM 50 350,000.00
62,153.51 18 JUM 50 350,000.00
110,730.26 19 SAB 50 350,000.00
89,307.02 20 MING 50 350,000.00
67,883.77 21 SEN LIBUR
22 SEL 50 350,000.00
23,539.47 23 RAB 50 350,000.00
392,000.00 24 KAM 50 350,000.00
303,539.47 25 JUM 50 350,000.00
602,000.00 26 SAB 50 350,000.00
653,539.47 27 MING 50 350,000.00
952,000.00 28 SEN LIBUR
29 SEL 50 350,000.00

1,043,423.25 30 RAB 50 350,000.00

NETT PROFIT TANGGAL HARI FREQ BUNGKUS OMZET


32,134.87 16 RAB 75 525,000.00
64,269.74 17 KAM 75 525,000.00
484,269.74 18 JUM 75 525,000.00
621,404.61 19 SAB 75 525,000.00
20 MING 75 525,000.00
688,539.47 21 SEN LIBUR
790,674.34 22 SEL 75 525,000.00
1,315,674.34 23 RAB 75 525,000.00
1,805,674.34 24 KAM 75 525,000.00
2,295,674.34 25 JUM 75 525,000.00
2,820,674.34 26 SAB 75 525,000.00
27 MING 75 525,000.00
2,922,809.21 28 SEN LIBUR
3,059,944.08 29 SEL 75 525,000.00

3,584,944.08 30 RAB 75 525,000.00


31 KAM 75 525,000.00
BELANJA HARIAN U/ 50 BUNGKUS NETT PROFIT
1,134,846.49
1,484,846.49
258,576.75 1,834,846.49
2,184,846.49
2,534,846.49
LIBUR
2,626,269.74
2,976,269.74

258,576.75 3,326,269.74
3,676,269.74
4,026,269.74
4,376,269.74
LIBUR
4,467,692.98
258,576.75 4,559,116.23

PENINGKATAN BELANJA DRI 50-100 129,288.38


BELANJA LPG 12 KG 100,000.00
MINYAK GORENG 4 LITER 50,000.00
NETT PROFIT BULAN JUNI 4,279,827.85

BELANJA HARIAN U/ 100 BUNGKUS NETT PROFIT


3,722,078.95
3,859,213.82
387,865.13 4,384,213.82
4,909,213.82
5,434,213.82
LIBUR
5,571,348.68
5,708,483.55

387,865.13 6,233,483.55
6,758,483.55
7,283,483.55
7,808,483.55
LIBUR
7,945,618.42

387,865.13 8,082,753.29
387,865.13
8,607,753.29

PENINGKATAN BELANJA DRI 50-100 0.00


BELANJA LPG 12 KG 100,000.00
MINYAK GORENG 4 LITER 50,000.00
NETT PROFIT BULAN JULI 8,457,753.29
DATA NETT PROFIT BULANAN

TAHUN 2014

BULAN NETT PROFIT PPN 10% SEWA STAND NETT PROFIT + SEWA STAND
JUN 4,279,827.85 427,982.79 300,000.00 3,979,827.85
JUL 8,457,753.29 845,775.33 300,000.00 8,157,753.29
AGUS 0.00 300,000.00 -300,000.00
SEP 0.00 300,000.00 -300,000.00
OKT 0.00 300,000.00 -300,000.00
NOV 0.00 300,000.00 -300,000.00
DES 0.00 300,000.00 -300,000.00
NETT PROFIT SETELAH DIPOTONG PAJAK+ SEWA STAND
3,551,845.07
7,311,977.96
-300,000.00
-300,000.00
-300,000.00
-300,000.00
-300,000.00

También podría gustarte