Excel Risky Off U
-
Upload
estehanget25 -
Category
Documents
-
view
105 -
download
8
Transcript of Excel Risky Off U
Laporan Pembelian Barang Tahun 2011PT ANGKASA
No Tanggal Merk Jumlah Barang Harga Satuan
1 3/20/11 Sepatu Nike 10 Pasang Rp2 5/21/11 Sandal Adidas 15 Pasang Rp3 6/22/11 T-Shirt H & R 28 Potong Rp4 1/23/11 Kemeja Choya 15 Kodi Rp5 3/24/11 Rokok Marlboro 150 Slop Rp6 5/23/11 Sepatu Lotto 15 Pasang Rp7 7/22/11 Sandal Ando 25 Pasang Rp8 9/20/11 T-Shirt Polo 21 Potong Rp9 11/19/11 Kemeja Gabriel 23 Kodi Rp
10 1/18/11 Rokok Dunhill 130 Slop Rp11 3/18/11 Sepatu Speed 28 Pasang Rp12 5/17/11 Sandal Swallow 26 Pasang Rp13 5/18/11 T-Shirt Wasser 16 Potong Rp14 5/19/11 Kemeja Wall e 18 Kodi Rp15 5/20/11 Rokok Wismilak 134 Slop Rp16 5/21/11 Sepatu Homiped 10 Pasang Rp17 5/22/11 Sandal Joger 17 Pasang Rp18 5/23/11 T-Shirt Diery 11 Potong Rp19 5/24/11 Kemeja Clothe 37 Kodi Rp20 5/25/11 Rokok Surya 175 Slop Rp
Total Pembelian Rp 270,551,000 Rata-Rata Pembelian Rp 13,527,550 Pembelian tertinggi Rp 83,250,000 Pembelian terendah Rp 825,000
Nama Barang
Harga Satuan Total Harga Keterangan
500,000 Rp 5,000,000 0300,000 Rp 4,500,000 0100,000 Rp 2,800,000 100000
2,500,000 Rp 37,500,000 07,000 Rp 1,050,000 100000
600,000 Rp 9,000,000 0450,000 Rp 11,250,000 100000125,000 Rp 2,625,000 0
1,450,000 Rp 33,350,000 08,500 Rp 1,105,000 100000
100,000 Rp 2,800,000 100000450,000 Rp 11,700,000 100000125,000 Rp 2,000,000 0
3,000,000 Rp 54,000,000 09,000 Rp 1,206,000 100000
245,000 Rp 2,450,000 0120,000 Rp 2,040,000 075,000 Rp 825,000 0
2,250,000 Rp 83,250,000 10000012,000 Rp 2,100,000 100000
PT. PALIMANAN PERSADALAPORAN PENJUALAN
Salesman Tape % Televisi %Tony 24,000,000 4% 67,000,000 7%Adi 34,000,000 5% 77,000,000 8%Deddy 54,000,000 9% 76,000,000 8%Ferry 32,000,000 5% 50,000,000 5%Kemal 33,000,000 5% 56,000,000 6%Syam 55,000,000 9% 45,000,000 5%Putu 44,000,000 7% 78,000,000 8%Kusmawan 31,000,000 5% 77,000,000 8%Agus 27,000,000 4% 45,000,000 5%Ahmad 35,000,000 6% 56,000,000 6%Doddy 59,000,000 9% 43,000,000 4%Febri 16,000,000 3% 66,000,000 7%Akmal 26,000,000 4% 55,000,000 6%Syamsul 27,500,000 4% 45,000,000 5%Rudi 43,000,000 7% 40,000,000 4%Kurniawan 51,000,000 8% 25,750,000 3%Tono 23,000,000 4% 37,000,000 4%Budi 19,750,000 3% 52,000,000 5%Total Rp 634,250,000 100% Rp 990,750,000 100%Rata-rata Rp 35,236,111 Rp 55,041,667 Penjualan Maksimum Rp 59,000,000 Rp 78,000,000 Penjualan Minimum Rp 16,000,000 Rp 25,750,000
PT. PALIMANAN PERSADALAPORAN PENJUALAN
March 2011
Kulkas % Freezer % VCD Player % Total45,000,000 5% 32,000,000 3% 50,000,000 7% 218,000,00055,000,000 6% 65,000,000 7% 33,000,000 4% 264,000,00043,000,000 5% 43,000,000 5% 65,000,000 9% 281,000,00023,000,000 3% 43,000,000 5% 43,000,000 6% 191,000,00045,000,000 5% 50,000,000 5% 23,000,000 3% 207,000,00034,000,000 4% 50,000,000 5% 23,000,000 3% 207,000,00034,000,000 4% 77,000,000 8% 55,000,000 7% 288,000,00076,000,000 8% 43,000,000 5% 45,000,000 6% 272,000,00050,000,000 6% 51,000,000 6% 28,500,000 4% 201,500,00045,000,000 5% 45,000,000 5% 38,000,000 5% 219,000,00052,000,000 6% 62,000,000 7% 47,000,000 6% 263,000,00062,000,000 7% 46,000,000 5% 29,000,000 4% 219,000,00074,000,000 8% 58,000,000 6% 51,000,000 7% 264,000,00055,000,000 6% 37,000,000 4% 37,000,000 5% 201,500,00060,000,000 7% 53,000,000 6% 64,000,000 9% 260,000,00054,000,000 6% 71,000,000 8% 32,000,000 4% 233,750,00039,000,000 4% 35,000,000 4% 34,000,000 5% 168,000,00061,000,000 7% 65,000,000 7% 54,000,000 7% 251,750,000
Rp 907,000,000 100% Rp 926,000,000 100% Rp 751,500,000 100% Rp 4,209,500,000 Rp 50,388,889 Rp 51,444,444 Rp 41,750,000 Rp 233,861,111 Rp 76,000,000 Rp 77,000,000 Rp 65,000,000 Rp 288,000,000 Rp 23,000,000 Rp 32,000,000 Rp 23,000,000 Rp 168,000,000
%5%6%7%5%5%5%7%6%5%5%6%5%6%5%6%6%4%6%
100%
Fluktuasi Rupiah Terhadap Dollarper tgl 1 s.d. 7 September 2011
Tanggal Senin Selasa Rabu Kamis Jumat
Rupiah 8,500 8,750 9,000 9,700 9,350Rupiah BI 9,000 9,300 9,650 9,300 9,700
Senin
Selas
aRab
uKam
isJumat
Sabtu
Minggu
7,500
8,000
8,500
9,000
9,500
10,000
10,500
8,5008,750
9,000
9,700
9,350
9,900
9,050
9,0009,300
9,650
9,300
9,700
10,200
9,500
Pergerakan Rupiah
RupiahRupiah BI
Hari
Rupi
ah
Sabtu Minggu
9,900 9,05010,200 9,500
Senin Se-lasa
Rabu Kamis
Ju-mat
Sabtu Minggu
Senin Se-lasa
Rabu Kamis
Ju-mat
Sabtu Minggu
Rupiah
8,500
8,750
9,000
9,700
9,350
9,900
9,050
Rupiah BI
9,000
9,300
9,650
9,300
9,700
10,200
9,500
7,7508,2508,7509,2509,750
10,250
Pergerakan Rupiah
RupiahRupiah BI
Hari
Ru
pia
h
Laporan Pembelian Barang Tahun 2011PT ANGKASA
No Tanggal Merk Jumlah Barang Harga Satuan
1 3/20/11 Sepatu Nike 10 Pasang Rp 500,0002 5/21/11 Sandal Adidas 15 Pasang Rp 300,0003 6/22/11 T-Shirt H & R 28 Potong Rp 100,0004 1/23/11 Kemeja Choya 15 Kodi Rp 2,500,0005 3/24/11 Rokok Marlboro 150 Slop Rp 7,000
Merk Total Harga
Sepatu Nike 5,000,000Sandal Adidas 4,500,000T-Shirt H & R 2,800,000Kemeja Choya 37,500,000Rokok Marlboro 1,050,000
Nama Barang
Nama Barang
Nike Adidas H & R Choya Marlboro
0
5,000,000
10,000,000
15,000,000
20,000,000
25,000,000
30,000,000
35,000,000
40,000,000
5,000,000 4,500,0002,800,000
37,500,000
1,050,000
Laporan Pembelian
Total Harga
Total Harga
Rp 5,000,000Rp 4,500,000Rp 2,800,000Rp 37,500,000Rp 1,050,000
PT. PALIMANAN PERSADALAPORAN PENJUALAN
March 2011
Salesman Tape Televisi KulkasTony 24,000,000 67,000,000 45,000,000Adi 34,000,000 77,000,000 55,000,000Deddy 54,000,000 76,000,000 43,000,000Ferry 32,000,000 50,000,000 23,000,000Kemal 33,000,000 56,000,000 45,000,000Syam 55,000,000 45,000,000 34,000,000Putu 44,000,000 78,000,000 34,000,000Kusmawan 31,000,000 77,000,000 76,000,000Total Rp 307,000,000 Rp 526,000,000 Rp 355,000,000 Rata-rata Rp 38,375,000 Rp 65,750,000 Rp 44,375,000 Penjualan Maksimum Rp 55,000,000 Rp 78,000,000 Rp 76,000,000 Penjualan Minimum Rp 24,000,000 Rp 45,000,000 Rp 23,000,000
Tony
Adi
Deddy
Ferry
Kemal
Syam
Putu
Kusmawan
0 10,000,000 20,000,000 30,000,000 40,000,000 50,000,000 60,000,000 70,000,000 80,000,000
24,000,000
34,000,000
54,000,000
32,000,000
33,000,000
55,000,000
44,000,000
31,000,000
67,000,000
77,000,000
76,000,000
50,000,000
56,000,000
45,000,000
78,000,000
77,000,000
45,000,000
55,000,000
43,000,000
23,000,000
45,000,000
34,000,000
34,000,000
76,000,000
32,000,000
65,000,000
43,000,000
43,000,000
50,000,000
50,000,000
77,000,000
43,000,000
50,000,000
33,000,000
65,000,000
43,000,000
23,000,000
23,000,000
55,000,000
45,000,000
Laporan Penjualan
VCD PlayerFreezerKulkasTelevisiTape
Penjualan
Sale
sman
Tony
Adi
Deddy
Ferry
Kemal
Syam
Putu
Kusmawan
0 10,000,000 20,000,000 30,000,000 40,000,000 50,000,000 60,000,000 70,000,000 80,000,000
24,000,000
34,000,000
54,000,000
32,000,000
33,000,000
55,000,000
44,000,000
31,000,000
67,000,000
77,000,000
76,000,000
50,000,000
56,000,000
45,000,000
78,000,000
77,000,000
45,000,000
55,000,000
43,000,000
23,000,000
45,000,000
34,000,000
34,000,000
76,000,000
32,000,000
65,000,000
43,000,000
43,000,000
50,000,000
50,000,000
77,000,000
43,000,000
50,000,000
33,000,000
65,000,000
43,000,000
23,000,000
23,000,000
55,000,000
45,000,000
Laporan Penjualan
VCD PlayerFreezerKulkasTelevisiTape
Penjualan
Sale
sman
PT. PALIMANAN PERSADALAPORAN PENJUALAN
Freezer VCD Player Total32,000,000 50,000,000 218,000,00065,000,000 33,000,000 264,000,00043,000,000 65,000,000 281,000,00043,000,000 43,000,000 191,000,00050,000,000 23,000,000 207,000,00050,000,000 23,000,000 207,000,00077,000,000 55,000,000 288,000,00043,000,000 45,000,000 272,000,000
Rp 403,000,000 Rp 337,000,000 Rp 1,928,000,000 Rp 50,375,000 Rp 42,125,000 Rp 241,000,000 Rp 77,000,000 Rp 65,000,000 Rp 288,000,000 Rp 32,000,000 Rp 23,000,000 Rp 191,000,000
Tony
Adi
Deddy
Ferry
Kemal
Syam
Putu
Kusmawan
0 10,000,000 20,000,000 30,000,000 40,000,000 50,000,000 60,000,000 70,000,000 80,000,000
24,000,000
34,000,000
54,000,000
32,000,000
33,000,000
55,000,000
44,000,000
31,000,000
67,000,000
77,000,000
76,000,000
50,000,000
56,000,000
45,000,000
78,000,000
77,000,000
45,000,000
55,000,000
43,000,000
23,000,000
45,000,000
34,000,000
34,000,000
76,000,000
32,000,000
65,000,000
43,000,000
43,000,000
50,000,000
50,000,000
77,000,000
43,000,000
50,000,000
33,000,000
65,000,000
43,000,000
23,000,000
23,000,000
55,000,000
45,000,000
Laporan Penjualan
VCD PlayerFreezerKulkasTelevisiTape
Penjualan
Sale
sman
Tony
Adi
Deddy
Ferry
Kemal
Syam
Putu
Kusmawan
0 10,000,000 20,000,000 30,000,000 40,000,000 50,000,000 60,000,000 70,000,000 80,000,000
24,000,000
34,000,000
54,000,000
32,000,000
33,000,000
55,000,000
44,000,000
31,000,000
67,000,000
77,000,000
76,000,000
50,000,000
56,000,000
45,000,000
78,000,000
77,000,000
45,000,000
55,000,000
43,000,000
23,000,000
45,000,000
34,000,000
34,000,000
76,000,000
32,000,000
65,000,000
43,000,000
43,000,000
50,000,000
50,000,000
77,000,000
43,000,000
50,000,000
33,000,000
65,000,000
43,000,000
23,000,000
23,000,000
55,000,000
45,000,000
Laporan Penjualan
VCD PlayerFreezerKulkasTelevisiTape
Penjualan
Sale
sman
Daftar Tinggi Badan Siswa Kelas 9SMP Negeri 1 Malang
NO NIM NAMA KETERANGAN
1 40-531 PRASOJO MAKDI 160 TINGGI2 30-367 NILA RUSMANIA 155 PENDEK3 30-371 NURUL KHOIRIYAH 130 PENDEK4 30-372 DIEN YENSEE 161 TINGGI5 30-374 DWI SEPTIANNY 150 PENDEK6 30-375 ESHA PRADAN 152 PENDEK7 30-377 RAUDATUL FARIDA 140 PENDEK8 30-378 MARIYAH ULFA 135 PENDEK9 30-381 DEWI ANGGANINGRUM 165 TINGGI
10 30-383 SURYA SAPUTRA 163 TINGGI11 30-384 ANDRI BSATOMI 159 PENDEK12 30-385 JAZILATUL FIKRIYAH 149 PENDEK13 30-386 INDAH ROHMANSYAH 158 PENDEK14 30-389 FINA NURIL 170 TINGGI15 30-390 AHMAD DIDIK 157 PENDEK
TINGGI (cm)
PROG. STUDI S1 MANAJEMENNIM/KELAS 110413423533/UNAMA RISKY RAMADHANISEMESTER GENAP/2
NO MATA KULIAH SKS DOSEN1 EKONOMI PEMBANGUNAN 3 LUDHI WISHNU2 ASPEK HUKUM 3 SUBAGYO3 PENDIDIKAN PANCASILA 2 HARIYONO4 TEKNOLOGI, INFORMASI DAN KOMUNIKASI 3 MURDIONO5 BAHASA INGGRIS PROFESI 2 NUR HAYATI6 STATISTIKA DESKRIPTIF 3 ANIEK INDRAWATI7 PENGANTAR AKUNTANSI 2 3 HERI PRATIKTO8 KOPERASI DAN PEREKONOMIAN 3 J.G. NIRBITO
PA LULU LUTFIANASKS PAIPTTD PA
NILAI KETERANGAN87 B+67 C59 D98 A-88 B+71 B-85 B+
100 A
LAPORAN PENJUALANMINI MARKET SURYA MALANG
Per 31 Januari 2011
NO JUMLAH HARGA
1 BIMOLI 20 Rp 1,500.000 Rp 30,000.000 30002 FILMA 30 Rp 1,450.000 Rp 43,500.000 03 SUNRISE 25 Rp 1,425.000 Rp 35,625.000 04 SENDOK 60 Rp 1,435.000 Rp 86,100.000 05 HAPPY SALAD OIL 69 Rp 1,750.000 Rp 120,750.000 120756 BROCO 21 Rp 1,455.000 Rp 30,555.000 07 DORANG 39 Rp 1,475.000 Rp 57,525.000 08 KUNCI MAS 12 Rp 1,465.000 Rp 17,580.000 0
TOTAL
MERK MINYAK GORENG
JUMLAH (BOX)
HARGA per BOX
DISKON 10%
Rp 27,000.000 Rp 43,500.000 Rp 35,625.000 Rp 86,100.000 Rp 108,675.000 Rp 30,555.000 Rp 57,525.000 Rp 17,580.000 Rp 406,560.000
JUMLAH PENJUALAN
DAFTAR TRANSAKSI MESIN FOTOCOPY "XEROX"
NO NAMA PELANGGAN JENIS KERTAS
1 PRASOJO MAKDI A4 XEROX 125 18,7502 DIEN YENSEE F4 XEROX 350 52,5003 DWI SEPTIANNY KWARTO XEROX 597 89,5504 ESHA PRADAN F4 XEROX 1250 187,5005 RAUDATUL FARIDA KWARTO XEROX 2548 382,2006 MARIYAH ULFA KWARTO XEROX 981 147,1507 DEWI ANGGANINGRUM F4 XEROX 458 68,7008 SURYA SAPUTRA A4 XEROX 861 129,1509 ANDRI BSATOMI A4 XEROX 450 67,500
10 JAZILATUL FIKRIYAH KWARTO XEROX 387 58,05011 INDAH ROHMANSYAH F4 XEROX 891 133,65012 FINA NURIL KWARTO XEROX 987 148,050
JENIS MESIN FOTOCOPY
JUMLAH LEMBAR
HARGA (150/LBR)
DISKON JUMLAH
0 18,750 0 52,500
2,239 87,311 0 187,500
9,555 372,645 3,679 143,471
0 68,700 0 129,150 0 67,500
1,451 56,599 0 133,650
3,701 144,349
Daftar Berat Badan Keluarga
No Nama Berat Keterangan1 Ayah 89 kg Gemuk2 Ibu 50 kg Kurus3 Kakak 83 kg Gemuk4 Adik 35 kg Kurus5 Saya 53 kg Kurus
LAPORAN PENJUALANMINI MARKET SURYA MALANG
Per 31 Januari 2011
NO JUMLAH HARGA
1 AQUA 20 Rp 11,000.00 Rp 220,000.00 11000 Rp 209,000.00 2 CLUB 30 Rp 12,500.00 Rp 375,000.00 0 Rp 375,000.00 3 CLEO 23 Rp 12,000.00 Rp 276,000.00 ### Rp 262,200.00 4 TOTAL 45 Rp 10,000.00 Rp 450,000.00 0 Rp 450,000.00 5 MAAQO 20 Rp 9,500.00 Rp 190,000.00 ### Rp 180,500.00 6 CLEAR 31 Rp 14,500.00 Rp 449,500.00 0 Rp 449,500.00 7 WATER 20 Rp 11,500.00 Rp 230,000.00 0 Rp 230,000.00 8 COOL 30 Rp 9,000.00 Rp 270,000.00 0 Rp 270,000.00 9 SWEAT 23 Rp 12,000.00 Rp 276,000.00 0 Rp 276,000.00
10 POCARE 45 Rp 11,000.00 Rp 495,000.00 0 Rp 495,000.00 11 COKE 20 Rp 14,000.00 Rp 280,000.00 0 Rp 280,000.00 12 QUASE 31 Rp 10,500.00 Rp 325,500.00 0 Rp 325,500.00 13 CLEO 20 Rp 12,000.00 Rp 240,000.00 ### Rp 228,000.00 14 FANTA 30 Rp 13,000.00 Rp 390,000.00 0 Rp 390,000.00 15 SPRITE 23 Rp 13,000.00 Rp 299,000.00 0 Rp 299,000.00 16 AQUA 45 Rp 11,000.00 Rp 495,000.00 ### Rp 470,250.00 17 MAAQO 20 Rp 9,500.00 Rp 190,000.00 ### Rp 180,500.00 18 WATER 31 Rp 11,500.00 Rp 356,500.00 0 Rp 356,500.00 19 CLUB 20 Rp 12,500.00 Rp 250,000.00 0 Rp 250,000.00 20 COOL 30 Rp 9,000.00 Rp 270,000.00 0 Rp 270,000.00 21 AQUA 23 Rp 11,000.00 Rp 253,000.00 ### Rp 240,350.00 22 SPLASH 45 Rp 15,000.00 Rp 675,000.00 0 Rp 675,000.00 23 FREEZE 20 Rp 12,750.00 Rp 255,000.00 0 Rp 255,000.00 24 QUASE 31 Rp 10,500.00 Rp 325,500.00 0 Rp 325,500.00 25 CLEO 29 Rp 12,000.00 Rp 348,000.00 ### Rp 330,600.00
MERK AIR MINUM
JUMLAH (BOX)
HARGA per BOX
DISKON 5%
JUMLAH PENJUALAN
DAFTAR TRANSAKSI UD DETERJEN
NO NAMA PELANGGAN JUMLAH DISKON JUMLAH
1 ADI RINSO 125 11000 1650 11687502 ADE WINGS 90 9500 0 8550003 ALDO ATTACK 105 10500 0 11025004 ALDI SO KLIN 110 11500 0 12650005 ALDA SUNLIGHT 95 12500 0 11875006 ANI MAMA 80 9000 0 7200007 ANA HARPIC 235 12500 1875 24968758 INA RINSO 90 11000 0 9900009 IDA WINGS 125 9500 0 1187500
10 BUDI ATTACK 85 10500 0 89250011 AGUS SUNLIGHT 90 12500 0 112500012 EKO RINSO 105 11000 1650 98175013 PRANOTO HARPIC 101 12500 1875 107312514 WARAS ATTACK 95 10500 0 99750015 REBO MAMA 135 9000 0 1215000
MERK DETERJEN
HARGA per BUAH
REKAPITULASI HASIL CPNS KOTA MALANG
No Nama No TestHASIL TEST
TULIS WAWANCARA PSI1 PRASOJO MAKDI 40-531 L L L2 NILA RUSMALIANA 30-368 L L T3 NURUL KHOIRIYAH 30-371 T L L4 DIEN YENSEE R 30-372 L T L5 DWI SEPTI LAILY 30-374 L L L6 ESA PRADANA 30-375 T T L7 RAUSATUL FARIDA 30-377 L T T8 MARIYAUTL KIPTIYAH 30-378 L L T9 DEWI KHOIRUN NIKMAH 30-381 L L L
KETERANGAN
LULUSCADANGANGUGURGUGURLULUSGUGURGUGURCADANGANLULUS
NYAMAN RENT CARJl. Ambarawa No 29 Malang
NO NAMA KODE TGL. SEWA TGL. KEMBALI LAMA SEWA1 PRASOJO MAKDI 2 3-Mar-04 8-Mar-04 5 Hari2 NILA RUSMALIANA 3 5-Mar-04 16-Mar-04 11 Hari3 NURUL KHOIRIYAH 3 1-Mar-04 7-Mar-04 6 Hari4 DIEN YENSEE R 2 3-Mar-04 4-Mar-04 1 Hari5 DWI SEPTI LAILY 3 5-Mar-04 8-Mar-04 3 Hari6 ESA PRADANA 3 7-Mar-04 10-Mar-04 3 Hari7 RAUSATUL FARIDA 1 4-Mar-04 14-Mar-04 10 Hari8 MARIYAUTL KIPTIYAH 2 4-Mar-04 24-Mar-04 20 Hari9 DEWI KHOIRUN NIKMAH 1 1-Mar-04 9-Mar-04 8 Hari
10 SENJANG 1 2-Mar-04 12-Mar-04 10 HariJUMLAH
JENIS MOBIL TARIP JUMLAH DISKON TOTALPANTHER 350,000 1,750,000 350,000 1,400,000 MITSUBHISI 250,000 2,750,000 - 2,750,000 MITSUBHISI 250,000 1,500,000 - 1,500,000 PANTHER 350,000 350,000 70,000 280,000 MITSUBHISI 250,000 750,000 - 750,000 MITSUBHISI 250,000 750,000 - 750,000 KIJANG 400,000 4,000,000 1,000,000 3,000,000 PANTHER 350,000 7,000,000 1,400,000 5,600,000 KIJANG 400,000 3,200,000 800,000 2,400,000 KIJANG 400,000 4,000,000 1,000,000 3,000,000
26,050,000 4,620,000 21,430,000
BPR SYARI'AH BUMI RINJANIDaftar Pituang
May-09
tanggal proses 1-May-09Denda per Hari Umum 0.10%Denda per Hari Karyawan 0.06%
No NAMA NASABAH KODE STATUS
1 ADOLF MANOPO U UMUM 14-Apr-09 5,000,000 2 SUDIANTORO U UMUM 25-Apr-09 4,000,000 3 A. FAISAL K KARYAWAN 20-Apr-09 7,000,000 4 SUNARTO U UMUM 22-Apr-09 9,000,000 5 EMIR MUKTAR U UMUM 18-Apr-09 5,000,000 6 T. C. CHAN K KARYAWAN 29-Apr-09 10,000,000 7 MUHAMMAD RIDWAN U UMUM 10-Mar-09 17,000,000 8 ARIS ROHMAN K KARYAWAN 01-Mar-09 12,000,000 9 SAMIUL SAHAB U UMUM 02-May-09 8,000,000
10 ROBERT SINAGA U UMUM 03-Apr-09 9,000,000 TOTAL 86,000,000
JATUH TEMPO
PIUTANGJUMLAH PIUTANG
LEWAT HARI DENDA KETERANGAN
12 Hari 60,000 5,060,000 DEBT COLLECTOR1 Hari 4,000 4,004,000 DITAGIH VIA TELPON6 Hari 25,200 7,025,200 DEBT COLLECTOR4 Hari 36,000 9,036,000 DITAGIH VIA TELPON8 Hari 40,000 5,040,000 DEBT COLLECTOR0 Hari - 10,000,000 TIDAK DITAGIH
47 Hari 799,000 17,799,000 DEBT COLLECTOR56 Hari 403,200 12,403,200 DEBT COLLECTOR0 Hari - 8,000,000 TIDAK DITAGIH
23 Hari 207,000 9,207,000 DEBT COLLECTOR 1,574,400 87,574,400
TOTAL YG DIBAYAR
NYAMAN RENT CARJl. Ambarawa No 29 Malang
NO NAMA KODE TGL. KEMBALI
1 PRASOJO MAKDI 2 3-Mar-04 8-Mar-04 5 Hari2 NILA RUSMALIANA 3 5-Mar-04 16-Mar-04 11 Hari3 NURUL KHOIRIYAH 3 1-Mar-04 7-Mar-04 6 Hari4 DIEN YENSEE R 2 3-Mar-04 4-Mar-04 1 Hari5 DWI SEPTI LAILY 3 5-Mar-04 8-Mar-04 3 Hari6 ESA PRADANA 3 7-Mar-04 10-Mar-04 3 Hari7 RAUSATUL FARIDA 1 4-Mar-04 14-Mar-04 10 Hari8 MARIYAUTL KIPTIYAH 2 4-Mar-04 24-Mar-04 20 Hari9 DEWI KHOIRUN NIKMAH 1 1-Mar-04 9-Mar-04 8 Hari
10 SENJANG 1 2-Mar-04 12-Mar-04 10 HariJUMLAH
TGL. SEWA
LAMA SEWA
NYAMAN RENT CARJl. Ambarawa No 29 Malang
JENIS MOBIL TARIP JUMLAH DISKON TOTAL
PANTHER 350,000 1,750,000 350,000 1,400,000 MITSHIBISI 250,000 2,750,000 - 2,750,000 MITSHIBISI 250,000 1,500,000 - 1,500,000 PANTHER 350,000 350,000 70,000 280,000 MITSHIBISI 250,000 750,000 - 750,000 MITSHIBISI 250,000 750,000 - 750,000 KIJANG 400,000 4,000,000 1,000,000 3,000,000 PANTHER 350,000 7,000,000 1,400,000 5,600,000 KIJANG 400,000 3,200,000 800,000 2,400,000 KIJANG 400,000 4,000,000 1,000,000 3,000,000
26,050,000 4,620,000 21,430,000
PT MADONA FINANCEDAFTER GAJI PEGAWAI BAGIAN KREDIT
NO NAMA PEGAWAI KODE BAGIAN STATUS GRADE GAJI POKOK
1 DINDA C COLLECTION K 1 12,000,000 2 ANNISA R RISK MANAGEMENT T 2 9,000,000 3 SRI O COLLECTION T 4 4,000,000 4 APRILIA O COLLECTION K 4 4,000,000 5 NURCANGGIH O COLLECTION K 3 6,000,000 6 SULAILI C COLLECTION K 7 1,500,000 7 NONIE C COLLECTION K 6 2,000,000 8 SATRIA R RISK MANAGEMENT K 5 3,000,000 9 RIA ULFAH R RISK MANAGEMENT T 5 3,000,000
TOTAL 44,500,000
GRADE GAJI POKOKC COLLECTION 1 12000000R RISK MANAGEMENT 2 9000000O OPERATION 3 6000000
4 40000005 30000006 20000007 1500000
PT MADONA FINANCEDAFTER GAJI PEGAWAI BAGIAN KREDIT
DESEMBER 2011
TUNJ. JABATAN TUNJ. KELUARGA GAJI KOTOR PPh 15% GAJI BERSIH BONUS
3,000,000 3,600,000 18,600,000 2,790,000 15,810,000 36,000,000 1,350,000 - 10,350,000 1,552,500 8,797,500 27,000,000 - - 4,000,000 600,000 3,400,000 8,000,000 - 800,000 4,800,000 720,000 4,080,000 8,000,000 600,000 1,800,000 8,400,000 1,260,000 7,140,000 12,000,000 - 300,000 1,800,000 270,000 1,530,000 1,500,000 - 400,000 2,400,000 360,000 2,040,000 2,000,000 - 600,000 3,600,000 540,000 3,060,000 3,000,000 - - 3,000,000 450,000 2,550,000 3,000,000 4,950,000 7,500,000 56,950,000 8,542,500 48,407,500 100,500,000
T JABATAN T KELUARGA BONUS25% 30% 3 x 015% 30% 3 x 010% 30% 2 x 0
0% 20% 2 x 00% 20% 1 x 00% 20% 1 x 00% 20% 1 x 0
TOTAL
51,810,000 35,797,500 11,400,000 12,080,000 19,140,000 3,030,000 4,040,000 6,060,000 5,550,000 148,907,500
HOTEL SANTIKALAPORAN PENGHASILAN
JL. AMBARAWA 11, MALANG
NO NAMA NAMA KAMAR CHECK IN CHECK OUT
1 TITIK 3 A SINGLE DELUXE 2-Mar-11 6-Mar-112 NILA 1 B FAMILY SUPERIOR 3-Mar-11 6-Mar-113 NURUL 2 C DOUBLE STANDARD 3-Mar-11 9-Mar-114 DIEN 3 B SINGLE SUPERIOR 5-Mar-11 9-Mar-115 DWI 2 B DOUBLE SUPERIOR 5-Mar-11 15-Mar-116 WIEGA 2 C DOUBLE STANDARD 5-Mar-11 8-Mar-117 PUTRI 1 A FAMILY DELUXE 6-Mar-11 22-Mar-118 DWI ARIE 1 A FAMILY DELUXE 8-Mar-11 9-Mar-119 SHOHIBUR 3 B SINGLE SUPERIOR 8-Mar-11 10-Mar-11
10 ETIKA 2 A DOUBLE DELUXE 11-Mar-11 15-Mar-11JUMLAH
KODE KAMAR1 2 3 A DELUXE
FAMILY DOUBLE SINGLE B SUPERIOR
C STANDARD
KODE TIPE
KODE KAMAR
TIPE KAMAR
HOTEL SANTIKALAPORAN PENGHASILAN
JL. AMBARAWA 11, MALANG
TARIP JUMLAH DISKON TOTAL
4 hari 300,000 1,200,000 120,000 1,080,000 3 hari 400,000 1,200,000 120,000 1,080,000 6 hari 200,000 1,200,000 180,000 1,020,000 4 hari 200,000 800,000 80,000 720,000
10 hari 300,000 3,000,000 450,000 2,550,000 3 hari 200,000 600,000 60,000 540,000
16 hari 500,000 8,000,000 2,400,000 5,600,000 1 hari 500,000 500,000 50,000 450,000 2 hari 200,000 400,000 40,000 360,000 4 hari 400,000 1,600,000 160,000 1,440,000
18,500,000 3,660,000 14,840,000
FAMILY DOUBLE SINGLE500000 400000 300000400000 300000 200000300000 200000 100000
LAMA MENGINAP
TOKO MUSIKINDO JAYA ABADILAPORAN PENJUALAN BARANG
MINGGU I - MARET 2011
NO. KODE MUSIK HARGA VOLUME JML. HARGA1 1-INA KASET INDONESIA Rp 22,000 7 Rp 154,000 2 1-ASI KASET ASIA Rp 25,000 9 Rp 225,000 3 2-BAR VCD BARAT Rp 33,000 8 Rp 264,000 4 2-ASI VCD ASIA Rp 30,000 14 Rp 420,000 5 1-INA KASET INDONESIA Rp 22,000 23 Rp 506,000 6 1-ASI KASET ASIA Rp 25,000 5 Rp 125,000 7 3-IND DVD INDIA Rp 40,800 8 Rp 326,400 8 3-ASI DVD ASIA Rp 51,000 9 Rp 459,000 9 1-BAR KASET BARAT Rp 27,500 5 Rp 137,500
10 3-INA DVD INDONESIA Rp 44,880 6 Rp 269,280 11 2-BAR VCD BARAT Rp 33,000 12 Rp 396,000 12 2-ASI VCD ASIA Rp 30,000 20 Rp 600,000
TOTAL PENJUALAN 126 Rp 3,882,180
TOKO BATIKNUANSA INDONESIA
LAPORAN PENJUALAN
NO. NAMA PEMBELI KODE TRANSAKSI NAMA BARANG JML BRG
1 AYU ANANDHIKA B5-K1-H1-001 KAIN BATIK SURABAYA 112 ARIEF NASUTION B2-K7-H2-002 KAOS BATIK YOGYAKARTA 723 MADE BAYU B4-K8-H3-003 BAJU KOKO BATIK PURWOKERTO 834 MAGDALENA KOHAR B5-K8-H4-004 KAIN BATIK PURWOKERTO 845 MAHFUD JAKILE B2-K5-H5-005 KAOS BATIK PEKALONGAN 556 MAHYUDIN B2-K6-H6-006 KAOS BATIK SOLO 667 MARDIANA B5-K7-H7-007 KAIN BATIK YOGYAKARTA 778 MARIA LUSIANA B5-K8-H8-008 KAIN BATIK PURWOKERTO 889 MARTHA WIDYARI B3-K8-H2-009 DASTER BATIK PURWOKERTO 82
10 MARINI INDAH B3-K2-H4-010 DASTER BATIK JAKARTA 2411 MAYA ARIFIN B5-K3-H3-011 KAIN BATIK SEMARANG 3312 MAYANG SARI B4-K4-H8-012 BAJU KOKO BATIK CIREBON 4813 MULIA HERWAMAN B5-K6-H2-013 KAIN BATIK SOLO 6214 WULAN SARI B4-K7-H2-014 BAJU KOKO BATIK YOGYAKARTA 7215 MELLY INAWATI B5-K8-H5-015 KAIN BATIK PURWOKERTO 8516 MERRY TAMBUNAN B5-K3-H6-016 KAIN BATIK SEMARANG 3617 SARAH SEHAN B2-K4-H4-017 KAOS BATIK CIREBON 4418 RADITYA DIKA B3-K6-H4-018 DASTER BATIK SOLO 6419 ALEX B2-K8-H2-019 KAOS BATIK PURWOKERTO 8220 LEO NARDO B3-K2-H4-020 DASTER BATIK JAKARTA 24
1,192
KODE KOTA KODE BARANGK1 SURABAYA B1 KEMEJAK2 JAKARTA B2 KAOSK3 SEMARANG B3 DASTERK4 CIREBON B4 BAJU KOKOK5 PEKALONGAN B5 KAINK6 SOLOK7 YOGYAKARTAK8 PURWOKERTO
TOKO BATIKNUANSA INDONESIA
LAPORAN PENJUALAN
HARGA SATUAN HARGA KOTOR DISKON PPN 10% NILAI BERSIH
50,000 550,000 82,500 55,000 412,500 60,000 4,320,000 - 432,000 3,888,000 70,000 5,810,000 2,324,000 581,000 2,905,000 80,000 6,720,000 1,008,000 672,000 5,040,000 90,000 4,950,000 - 495,000 4,455,000 100,000 6,600,000 - 660,000 5,940,000 110,000 8,470,000 1,270,500 847,000 6,352,500 120,000 10,560,000 1,584,000 1,056,000 7,920,000 60,000 4,920,000 1,476,000 492,000 2,952,000 80,000 1,920,000 576,000 192,000 1,152,000 70,000 2,310,000 346,500 231,000 1,732,500 120,000 5,760,000 2,304,000 576,000 2,880,000 60,000 3,720,000 558,000 372,000 2,790,000 60,000 4,320,000 1,728,000 432,000 2,160,000 90,000 7,650,000 1,147,500 765,000 5,737,500 100,000 3,600,000 540,000 360,000 2,700,000 80,000 3,520,000 - 352,000 3,168,000 80,000 5,120,000 1,536,000 512,000 3,072,000 60,000 4,920,000 - 492,000 4,428,000 80,000 1,920,000 576,000 192,000 1,152,000
97,660,000 17,057,000 9,766,000 70,837,000
DISKON KODE HARGA10% H1 50000
0% H2 6000030% H3 7000040% H4 8000015% H5 90000
H6 100000H7 110000H8 120000
REKAPITULASI
NAMA BARANG JUMLAH NILAI BERSIH
KEMEJA BATIK SURABAYA 0 0KEMEJA BATIK JAKARTA 0 0KEMEJA BATIK SEMARANG 0 0KEMEJA BATIK CIREBON 0 0KEMEJA BATIK PEKALONGAN 0 0KEMEJA BATIK SOLO 0 0KEMEJA BATIK YOGYAKARTA 0 0KEMEJA BATIK PURWOKERTO 0 0KAOS BATIK SURABAYA 0 0KAOS BATIK JAKARTA 0 0KAOS BATIK SEMARANG 0 0KAOS BATIK CIREBON 44 3168000KAOS BATIK PEKALONGAN 55 4455000KAOS BATIK SOLO 66 5940000KAOS BATIK YOGYAKARTA 72 3888000KAOS BATIK PURWOKERTO 82 4428000DASTER BATIK SURABAYA 0 0DASTER BATIK JAKARTA 48 2304000DASTER BATIK SEMARANG 0 0DASTER BATIK CIREBON 0 0DASTER BATIK PEKALONGAN 0 0DASTER BATIK SOLO 64 3072000DASTER BATIK YOGYAKARTA 0 0DASTER BATIK PURWOKERTO 82 2952000BAJU KOKO BATIK SURABAYA 0 0BAJU KOKO BATIK JAKARTA 0 0BAJU KOKO BATIK SEMARANG 0 0BAJU KOKO BATIK CIREBON 48 2880000BAJU KOKO BATIK PEKALONGAN 0 0BAJU KOKO BATIK SOLO 0 0BAJU KOKO BATIK YOGYAKARTA 72 2160000BAJU KOKO BATIK PURWOKERTO 83 2905000KAIN BATIK SURABAYA 11 412500KAIN BATIK JAKARTA 0 0KAIN BATIK SEMARANG 69 4432500KAIN BATIK CIREBON 0 0KAIN BATIK PEKALONGAN 0 0KAIN BATIK SOLO 62 2790000KAIN BATIK YOGYAKARTA 77 6352500KAIN BATIK PURWOKERTO 257 18697500