Pembekalan Spreadsheet [PDF]

Citation preview

PERSEWAAN DVD DAFTAR PEMINJAM BULAN DESEMBER 2017 JL. Soekarno Hatta (022) 5620390 Yogyakarta



NO 1 2 3 4 5 6 7 8 9



NAMA PEMINJAM ADINDA NISYA AMANDA AKHDAN ARISYA ANITA ANA AMARTA ARIQ



KODE KASET



JENIS FILM



TANGGAL PINJAM



TANGGAL KEMBALI



LAMA SEWA



TARIF SEWA PERHARI



D-06 H-08 H-01 D-03 H-05 A-07 K-09 A-02 K-04



DRAMA HOROR HOROR DRAMA HOROR ACTION KOMEDI ACTION KOMEDI



12/5/2017 12/8/2017 12/10/2017 12/11/2017 12/13/2017 12/14/2017 12/21/2017 12/25/2017 12/28/2017



12/7/2017 12/11/2017 12/14/2017 12/13/2017 12/17/2017 12/20/2017 12/26/2017 12/27/2017 12/30/2017



2Hari 3Hari 4Hari 2Hari 4Hari 6Hari 5Hari 2Hari 2Hari



Rp Rp Rp Rp Rp Rp Rp Rp Rp



7,500 5,500 5,500 7,500 5,500 5,000 4,500 5,000 4,500



TOTAL BAYAR TOTAL PEMINJAM



DENDA Rp Rp Rp 550 Rp Rp 550 Rp 1,500 Rp 900 Rp Rp -



JUMLAH BAYAR Rp Rp Rp Rp Rp Rp Rp Rp Rp



15,000 16,500 22,550 15,000 22,550 31,500 23,400 10,000 9,000



Rp 165,500 9



TABEL 1 KODE



JENIS FILM



A D H K



ACTION DRAMA HOROR KOMEDI



TABEL 2 KODE GAJI



Rp



SEWA PER HARI Rp Rp Rp Rp



5,000 7,500 5,500 4,500



01 02 2,300,000 Rp 2,500,000 Rp



03 950,000



PERSEWAAN DVD DAFTAR PEMINJAM BULAN DESEMBER 2017 JL. Soekarno Hatta (022) 5620390 Yogyakarta NO URUT



NAMA PEGAWAI 1 RAMA 2 RAIDA 3 RANDY 4 ROMY



KODE PEGAWAI 01-PL 02-AD 02-PL 03-OB



STATUS



JUMLAH GAJI PEGAWAI MASUK



Pelayanan 25Hari Administrasi 19Hari Pelayanan 20Hari Office Boy 26Hari JUMLAH GAJI GAJI TERTINGGI GAJI TERENDAH RATA-RATA GAJI



Rp Rp Rp Rp



2,300,000 2,500,000 2,500,000 950,000



UANG MAKAN Rp Rp Rp Rp



375,000 285,000 300,000 390,000



GAJI BERSIH Rp Rp Rp Rp Rp Rp Rp Rp



2,675,000 2,785,000 2,800,000 1,340,000 9,600,000 2,800,000 1,340,000 2,400,000



PERSEWAAN DVD DAFTAR PEMINJAM BULAN DESEMBER 2017 JL. Soekarno Hatta (022) 5620390 Yogyakarta



NAMA PEMINJAM



LAMA SEWA



ADINDA NISYA AMANDA AKHDAN ARISYA ANITA ANA AMARTA ARIQ



2Hari 3Hari 4Hari 2Hari 4Hari 6Hari 5Hari 2Hari 2Hari



LAMA SEWA DV ANA 17%



JUMLAH BAYAR Rp Rp Rp Rp Rp Rp Rp Rp Rp



15,000 16,500 22,550 15,000 22,550 31,500 23,400 10,000 9,000



AMARTA 7%



ANITA 20%



ARIQ ADINDA 7% 7% NISYA 10%



ARISYA 13%



Rp35,000 Rp30,000 Rp25,000 Rp20,000 Rp15,000 Rp10,000 Rp5,000 RpA YA NDA DAN ISYA NITA ND NIS I A H A AR AD AK AM



A AN



AMA SEWA DVD



TA



AMANDA 13%



TA %



DA



ARIQ ADINDA 7% 7% NISYA 10%



AKHDAN 7%



ARISYA 13%



Column B Column C



N YA TA DA RIS NI H A A AK



A AN



TA AR AM



IQ AR



HP PERALATAN PERSA UMUR EKONOMIS NILAI SISA



NO 1 2 3 4 5



PENYUSUTAN Rp8,250,000.00 Rp6,600,000.00 Rp4,950,000.00 Rp3,300,000.00 Rp1,650,000.00



Rp Rp



AKUMULASI PENYUSUTAN Rp8,250,000.00 Rp14,850,000.00 Rp19,800,000.00 Rp23,100,000.00 Rp24,750,000.00



25,000,000 5 250,000



NILAI SISA Rp16,750,000.00 Rp10,150,000.00 Rp5,200,000.00 Rp1,900,000.00 Rp250,000.00