usaha beras

45
LAPORAN PENJUALAN BERAS Mar-12 TGL TOKO JUAL HUTANG LAMA 1 ASRI 405,000 489,000 1 SONY MULIA 410,000 174,000 1 BAROKAH ARJOSAR 223,750 2 REVOLUSI SUKARNO 615,000 289,100 2 AZZAMAR 615,000 574,000 2 ASRI 810,000 405,000 2 SUKSES MANDIRI 405,000 486,000 2 BROKEN 82,500 2 MUNAWAR 130,000 3 SAKINAH 4,326,250 2,629,000 3 CHOLIS 210,000 205,000 3 SUMBER JAYA 912,000 1,386,000 3 USMAN 45,000 4 MIIKEL 407,500 4 GALUH MORITA 410,000 4 BAROKOH DIENG ATAS 292,000 4 JULAIKA 27,500 4 SONY MULIA 4 USMAN 4 TOKO IMAH 5 MUNAWAR 5 ARGO TUNGGAL 820,000 810,000 5 PABELA 223,750 5 PERSADA 1,650,000 5 LANCAR 400,000 805,000 5 CAHAYA 283,500 5 TOKO IMAH 681,250 5 PANGESTU 243,000 5 MULYA JAYA 860,000 5 IMAM TIRTASARI 1,198,500 6 RIYADIN 502,500 6 BRAWIJAYA DARDO 6 SRIKANDI 941,250 6 SANYA 567,000 6 HEMAT 950,000 6 LINDA 1,838,250 6 SUGENG 205,000 7 MENTari 1,210,000 7 ABN 411,500 7 ACB 407,500 7 AZZAHRA HAMID RUSDI 615,000 7 DWIJAYA 607,500 7 SITI KRG AMPEL 205,000 7 SITI KRG TGH 137,500

Upload: miftachurrohman

Post on 04-Dec-2015

292 views

Category:

Documents


10 download

DESCRIPTION

contoh hitungan usaha beras

TRANSCRIPT

Page 1: Usaha Beras

LAPORAN PENJUALAN BERAS Mar-12

TGL TOKO JUAL HUTANG LAMA BAYAR1 ASRI 405,000 489,000 489,000 1 SONY MULIA 410,000 174,000 1 BAROKAH ARJOSAR 223,750 223,750 2 REVOLUSI SUKARNO 615,000 289,100 289,100 2 AZZAMAR 615,000 574,000 574,000 2 ASRI 810,000 405,000 405,000 2 SUKSES MANDIRI 405,000 486,000 486,000 2 BROKEN 82,500 82,500 2 MUNAWAR 130,000 130,000 3 SAKINAH 4,326,250 2,629,000 2,629,000 3 CHOLIS 210,000 205,000 205,000 3 SUMBER JAYA 912,000 1,386,000 1,368,000 3 USMAN 45,000 4 MIIKEL 407,500 285,250 4 GALUH MORITA 410,000 369,000 4 BAROKOH DIENG ATAS 292,000 332,000 4 JULAIKA 27,500 27,500 4 SONY MULIA 174,000 4 USMAN 45,000 4 TOKO IMAH 589,750 5 MUNAWAR 221,000 5 ARGO TUNGGAL 820,000 810,000 500,000 5 PABELA 223,750 223,750 5 PERSADA 1,650,000 5 LANCAR 400,000 805,000 400,000 5 CAHAYA 283,500 285,250 5 TOKO IMAH 681,250 5 PANGESTU 243,000 246,000 5 MULYA JAYA 860,000 667,000 5 IMAM TIRTASARI 1,198,500 1,112,750 6 RIYADIN 502,500 328,000 6 BRAWIJAYA DARDO 162,000 6 SRIKANDI 941,250 747,500 6 SANYA 567,000 449,000 6 HEMAT 950,000 613,500 6 LINDA 1,838,250 1,180,000 6 SUGENG 205,000 7 MENTari 1,210,000 7 ABN 411,500 350,000 7 ACB 407,500 246,000 7 AZZAHRA HAMID RUSDI 615,000 7 DWIJAYA 607,500 718,250 7 SITI KRG AMPEL 205,000 207,500 7 SITI KRG TGH 137,500 137,500

Page 2: Usaha Beras

7 LANCAR 600,000 405,000 7 SANYA 225,000 7 CEMARA 7 239,200 8 CASH 41,000 8 PANGESTU 405,000 202,500 8 AZZAHRA KENDALSARI 203,750 205,000 8 IBU JUWARIYAH 222,500 179,000 8 TOKO IJO 1,222,500 698,500 8 TOKO PERKASA 815,000 8 LEO MANTUNG 1,252,050 271,500 9 TOKO POJOK 367,250 369,500 9 ISHARYONO 563,500 171,500 9 CEMARA 7 239,200 9 ASRI 810,000 810,000 9 TEL 41,000

10 SAKINAH 4,360,900 10 SUMBER JAYA 856,900 912,000

t el 50,000 yaumil 45,000

11 ALEX 45 450,000 11 GALUH MORITA 410,000 11 MUSRI 175,500 11 BAROKAH DIENG 100,000 11 SITI KRGTEMGAHJ 137,500 11 LEO MANTUNG 500,000 11 SUGENG 205,000 12 MUNAWAR 184,600 12 DINOYO SWALAYAN 1,420,000 1,437,000 12 PERSADA 2,050,000

CAHAYA 405,000 283,500 TOKO LAB4 681,250

13 BROKEN 77,500 BOSTON 607,500 REJEKI JAYA 205,000 210,000 GALUH MORITA 407,000 IMAM KRPLOSO 1,489,500 640,500

14 gibran 317,500 160,000 rahma oma kampus 205,000 123,000 BOSTON 405,000 muria sengkaling 498,000 223,850 hidayah jetis 402,500 405,000 wijaya darmo 202,500 rio mart 548,000 129,500 akbar siguragura 92,000 44,500 PANGESTU 402,500 324,000 anggun 205,000 205,000 fajar 292,000 assalam 204,500 251,500

Page 3: Usaha Beras

toko 108 0 247,500 SUKSES MANDIRI 604,000 366,500

15 BU MUNTIK PRECET 542,500 100,000 ANNING 312,900 330,500 MUKSRI 92,000 SITI KRGTGH 442,500 44,750 SITI KRGAMPEL 205,000 100,000 ISHARYONO 200,000 wijaya darmo 205,000 HEMAT 1,095,250 347,000 LINDA 1,748,750

16 CEMARA 7 184,000 REVOLUSI SUKARNO 520,000 518,900 ASRI 607,500 810,000 SRIKANDI 971,500 807,750 ABDILLA 160,000 160,000

17 TRIADIN 497,500 502,500 SANIA 630,000 702,500 POJOK 405,000 367,250 LANCAR 800,000 FAZA 182,400 AZZAMAR 810,000 ACB 121,500 407,500 AZZAMAR TSMD 688,500 493,000

18 LANCAR 1,000,000 rio mart 300,000 GALUH MORITA 407,500 AZZAMART HDRD 615,000 MUKSRI 199,750 BAROKAH DIENG 92,000 SITI KRGTH 220,000 SITI KRG AMPEL 105,000 LINDA 948,750 LAB4 231,250 MUNAWAR 260000 260,000 ARGO TUNGGAL 1,000,000 PERSADA 2500000ACB 486000MULYA JAYA 675000 655,000 PANGESTU 402500 402,500 LAB4 457500wijaya BCT 607500 607500AXEL 92000 92000JUMAICA 165000 165000

65,003,700 9,842,300 33,767,350

Page 4: Usaha Beras

LAPORAN CASHFLOWMar-12

SISA HUTANG NO URAIAN 1 2 405,000 SALDO AWAL (554,850) 172,900 584,000 PENERIMAAN - Penjualan Beras 1,147,750 1,966,600 615,000 Pinjaman 5,200,000 615,000 810,000 405,000 JUMLAH 5,792,900 2,139,500 - PENGELUARAN - 1,215,000 Beli Beras 5,500,000 1,177,500 4,326,250 4,202,000 Bensin Mobil/Motor 100,000 210,000 Makan/parkir 10,000 10,000 930,000 Gaji karyawan 95,000 45,000 Lembur 10,000 122,250 Cetak plastik beras 41,000 Perawatan Mobil (40,000) Jumlah BIAYA 120,000 105,000 - JUMLAH 5,620,000 1,282,500 (174,000) Cicilan (45,000) Sakinah (589,750) 1,822,500 (221,000) SALDO AKHIR 172,900 857,000 1,130,000 -

3,655,750

3,480,000

Page 5: Usaha Beras

2,064,250

1,597,500

1,590,200

1,007,000

1,978,000

1,905,100

928,000

Page 6: Usaha Beras

2,885,350 3,973,500

1,327,250

2,480,650

Page 7: Usaha Beras

3 4 5 6 7 8 9 857,000 (44,250) 1,131,250 340,250 1,597,250 275,500 1,576,000

4,202,000 1,822,500 3,655,750 3,480,000 2,064,000 1,597,500 1,590,200 3,000,000 3,000,000 3,000,000

5,059,000 1,778,250 7,787,000 3,820,250 6,661,250 1,873,000 6,166,200

4,906,250 6,868,750 2,158,000 6,083,750 4,290,000 100,000 100,000 100,000 50,000 37,000 10,000 10,000 10,000 10,000 10,000 47,000 68,000 55,000 65,000

3,000 2,000 289,000 291,500

120,000 197,000 137,000 78,000 65,000 302,000 297,000 301,500 5,103,250 137,000 6,946,750 2,223,000 6,385,750 297,000 4,591,500

510,000 500,000

(44,250) 1,131,250 340,250 1,597,250 275,500 1,576,000 1,574,700

Page 8: Usaha Beras

10 11 12 13 14 15 16 1,574,700 2,375,200 4,343,200 4,439,300 967,300 307,250 1,539,500

1,007,000 1,978,000 6,231,100 928,000 2,885,350 1,327,250 2,480,650

2,581,700 4,353,200 10,574,300 5,367,300 3,852,650 1,634,500 4,020,150

6,045,000 4,290,000 3,510,000 3,510,000 100,000 100,000 50,000 10,000 10,000 10,000 10,000 10,000 10,000 35,000 80,000 80,000

2,000 5,000 21,500 215,000

23,400 206,500 10,000 90,000 110,000 35,400 95,000 225,000 206,500 10,000 6,135,000 4,400,000 3,545,400 95,000 3,735,000

2,375,200 4,343,200 4,439,300 967,300 307,250 1,539,500 285,150

Page 9: Usaha Beras

17 18 19 20 21 22 23 285,150 285,150 285,150

38,363,650 14,200,000 - -

285,150 285,150 285,150 74,316,600 - 48,339,250 600,000 267,000 525,000 22,000 817,000 143,400

- - - 2,374,400 - - - 50,713,650

1,010,000 - -

285,150 285,150 285,150 22,592,950

Page 10: Usaha Beras

24 25 26 27 28 29 30 31

Page 11: Usaha Beras

LAPORAN PENJUALAN BERAS APRIL

NAMA TOKO PIUTANG AWAL TGL 1 TGL 2NOTA BAYAR NOTA

GIBRAN 317,500 RAHMA 205,000 MURIA 498,000 HIDAYAH 402,500 WIJAYA DERMO 202,500 FAJA 297,000 ASSALAM 498,750 204,500 BOSTON 607,500 REJEKI JAYA 205,000 LANCAR 874,500 MENTARI SWALAYAN 1,210,000 SABELA SWALAYAN 202,500 CAHAYA Tlogo MAS 400,000 LAB4 SWALAYAN 741,000 ASRI 603,750 ISHARYONO 515,500 POJOK 405,000 CEMARA 7 SWALAYAN 385,500 SANIA SWALAYAN 804,000 TRIADINS SWALAYAN 497,500 REVOLUSI S SWALAYAN 520,000 BERLIN JETISWARTEL DUNIA 583,000 RIZKI 253,500 TOP AM 10 91,000 PERSADA SWALAYAN 4,165,000 DINOYO SWALAYAN 1,420,000

selatanRIO MART 710,500 AKBAR SIGURAGURA 92,000 PANGESTU 402,500 ANGGUN 205,000 SRIKANDI SWALAYAN 971,500 BAROKAH DIENG ATAS 100,000 IBU MUKSRI 100,000 IBU AMI 147,500 IBU IYEM 116,000 DWIIAYA BCT 607,500 IBU KARANG AMPEL 205,000 IBU SITI KARANG TENGAH 292,500 AXEL 702,400 MULIA JAYA 1,685,000 BAGUS 297,500

Page 12: Usaha Beras

ATIK JOYOSUKO 205,000 ANNING ARTOMORO 312,900 utaraIMAM KRPLOSO 1,100,750 VILLA MART 385,000 ABN PAK SADELI 411,500 AZZAMART TSM 688,500 AMIRA TGWULUNG 202,500 ABDILLA RIVERSIDE 562,500

ARGO TUNGGAL SWALAYAN 1,835,000 IJO YUDI 1,420,000 IJO PERKASA 1,015,000 IBU JUARIYAH 221,250 SHOFADIEN 615,000 LEO MANTUNG 1,199,000 LINDA SELECTA 2,038,650 IBU SOEGEONG 205,000 HEMART SWALAYAN 1,130,200 IBU MUNTIK PRECET 480,000 SUKSES MANDIRI 604,000 GALUH MORITA 405,000 405000AZZAMART HAMID RUSDI 724,500 ADIKA SWALAYAN 400,000 SONY MULYA 529,500 MICHAEL 402,500 ACB 607,500 BAROKAH ARJOSARI 275,000 SUMBER REJEKI 279,500 SUMBER JAYA 1,307,900 SAKINAH 4,148,450 WISMA PERMAI 225,000 AZZAHRA 203,750 KAK NENA 46,000 YAUMILKHOLIS 210,000

47,936,750

STOK BARANG 1,080.5 8,373,875.0

Page 13: Usaha Beras

UANG TUNAI 383,150 56,693,775.0

Page 14: Usaha Beras

TGL 2 TGL 3 TGL 4 TGL 5BAYAR NOTA BAYAR NOTA BAYAR NOTA

Page 15: Usaha Beras
Page 16: Usaha Beras

TGL 5 TGL 6 TGL 7 TGL 8BAYAR NOTA BAYAR NOTA BAYAR NOTA

Page 17: Usaha Beras
Page 18: Usaha Beras

TGL 8 TGL 9 TGL 10 TGL 11BAYAR NOTA BAYAR NOTA BAYAR NOTA

Page 19: Usaha Beras
Page 20: Usaha Beras

TGL 11 TGL 12 TGL 13 TGL 14BAYAR NOTA BAYAR NOTA BAYAR NOTA

Page 21: Usaha Beras
Page 22: Usaha Beras

TGL 14 TGL 15 TGL 16 TGL 17BAYAR NOTA BAYAR NOTA BAYAR NOTA

Page 23: Usaha Beras
Page 24: Usaha Beras

TGL 17 TGL 18 TGL 19 TGL 20BAYAR NOTA BAYAR NOTA BAYAR NOTA

Page 25: Usaha Beras
Page 26: Usaha Beras

TGL 20 TGL 21 TGL 22 TGL 23BAYAR NOTA BAYAR NOTA BAYAR NOTA

Page 27: Usaha Beras
Page 28: Usaha Beras

TGL 23 TGL 24 TGL 25 TGL 26BAYAR NOTA BAYAR NOTA BAYAR NOTA

Page 29: Usaha Beras
Page 30: Usaha Beras

TGL 26 TGL 27 TGL 28 TGL 29BAYAR NOTA BAYAR NOTA BAYAR NOTA

Page 31: Usaha Beras
Page 32: Usaha Beras

TGL 29 TGL 30 TGL 31 SALDO PIUTANGBAYAR NOTA BAYAR NOTA BAYAR

317,500 205,000 498,000 402,500 202,500 297,000 294,250 607,500 205,000 874,500 1,210,000 202,500 400,000 741,000 603,750 515,500 405,000 385,500 804,000 497,500 520,000 - 583,000 253,500 91,000 4,165,000 1,420,000

710,500 92,000 402,500 205,000 971,500 100,000 100,000

116,000 607,500 205,000 292,500 702,400 1,685,000 297,500

Page 33: Usaha Beras

205,000 312,900

1,100,750 385,000 411,500 688,500 202,500 562,500

1,835,000 1,420,000 1,015,000 221,250 615,000 1,199,000 2,038,650 205,000

Page 34: Usaha Beras

TOTAL OMSET

Page 35: Usaha Beras
Page 36: Usaha Beras

DAFTAR AGEN BERAS

GIBRANRAHMAMURIAHIDAYAHWIJAYA DERMOFAJAASSALAMBOSTONREJEKI JAYALANCARMENTARI SWALAYANSABELA SWALAYANCAHAYA TULUNG MASLAB4 SWALAYANASRIISHARYONOPOJOKCEMARA 7 SWALAYANSANIA SWALAYANTRIADINS SWALAYANREVOLUSI S SWALAYANBERLIN JETISWARTEL DUNIARIZKITOP AM 10PERSADA SWALAYANDINOYO SWALAYANRIO MARTAKBAR SIGURAGURAPANGESTUANGGUNSRIKANDI SWALAYANBAROKAH DIENG ATASIBU MUKSRIIBU IYEMDWIIAYA BCTIBU KARANG AMPELIBU KARANG TENGAHAXELMULIA JAYABAGUSATIK JOYOSUKOANNING ARTOMOROIMAM KRPLOSOVILLA MARTABN PAK SADELI

Page 37: Usaha Beras

AZZAMART TSMAMIRA TGWULUNGABDILLA RIVERSIDEARGO TUNGGAL SWALAYANIJO YUDIIJO PERKASAIBU JUARIYAHLEO MANTUNGLINDA SELECTAIBU SOEGEONGHEMART SWALAYANIBU MUNTIK PRECETSUKSES MANDIRIGALUH MORITAAZZAMART HAMID RUSDISONY MULYAMICHAELACBBAROKAH ARJOSARISUMBER REJEKISUMBER JAYA SAKINAHWISMA PERMAIKAK NENAYAUMILBROKEN

Page 38: Usaha Beras

Investasi yang sudah masuk ke usaha beras

tgl keterangam jumlah2/23/2012 al pinjam 2,000,000 bri/al

3/1/2012 invest1/bayar htg suplier 5,200,000 bri/al3/1/2012 invest2/bayar p omar 5,000,000 bca dr bmi3/5/2012 imvest3/beli beras 3,000,000 bri/al3/7/2012 invest4/beli beras 3,000,000 bri/al3/9/2012 invest5/beli beras 3,000,000 bri/al

3/17/2012 invest6/beli beras 3,000,000 bri/al3/17/2012 invest7/bayar p omar 5,000,000 bca3/29/2012 invest8/beli beras 3,000,000 bri/al

JUMLAH 32,200,000

Page 39: Usaha Beras

talangan bayar tagihan sakinah utk al

tgl keterangan jumlah diganti sakinah3/3/2012 byr nota tgl 24 2,629,000 3/5/2012

3/12/2012 byr nota tgl 3 4,326,000

6,955,000