DATA PENYEWAAN MOBIL

RENTAL BANDUNG INDAH

Jalan Otto Iskandardinata No.90 Bandung

Tanggal Tanggal Sewa

No Nama Penyewa Tipe Lama
Sewa Kembali perHari
1 Ani D 10-Jun-08 15-Jun-08 5 Rp150,000
2 Zaenal A 11-Jun-08 19-Jun-08 8 Rp375,000
3 Putri C 10-Jun-08 17-Jun-08 7 Rp225,000
4 Andi A 19-Jun-08 25-Jun-08 6 Rp375,000
5 Ridwan B 12-Jun-08 27-Jun-08 15 Rp300,000
6 Tia D 19-Jun-08 30-Jul-08 41 Rp150,000
7 Monica C 13-Jun-08 15-Jul-08 32 Rp225,000
Jumlah
Nilai tertinggi
Nilai terkecil
Nilai Rata-rata

Tabel Sewa
Tipe Sewa per-Hari Keterangan Mobil
A Rp 375,000 BMW
B Rp 300,000 Kijang LX
C Rp 225,000 Suzuki APV
D Rp 150,000 Futura PU
EWAAN MOBIL
NDUNG INDAH
dinata No.90 Bandung

[Link] Pajak Total Potongan Harus Bayar

Futura PU Rp15,000 Rp765,000 Rp0 Rp765,000

BMW Rp37,500 Rp3,037,500 Rp0 Rp3,037,500
Suzuki APV Rp22,500 Rp1,597,500 Rp0 Rp1,597,500
BMW Rp37,500 Rp2,287,500 Rp0 Rp2,287,500
Kijang LX Rp30,000 Rp4,530,000 Rp226,500 Rp4,303,500
Futura PU Rp15,000 Rp6,165,000 Rp308,250 Rp5,856,750
Suzuki APV Rp22,500 Rp7,222,500 Rp361,125 Rp6,861,375
Jumlah Rp180,000 Rp25,605,000 Rp895,875 Rp24,709,125
Nilai tertinggi Rp37,500 Rp7,222,500 Rp361,125 Rp6,861,375
Nilai terkecil Rp15,000 Rp765,000 Rp0 Rp765,000
Nilai Rata-rata Rp25,714 Rp3,657,857 Rp127,982 Rp3,529,875
Soal 2

Tabel Harga Karcis Kereta Api

Kategori Karcis
No Nama Harga Karcis
Kelas Waktu
1 Alan E S Rp45,000
2 Susi E M Rp70,000
3 Tony B S Rp35,000
4 Sigit B S Rp35,000
5 Canra B M Rp55,000
6 Tinto E S Rp45,000
7 Yaris E S Rp45,000
8 Maman B M Rp55,000
9 Sentot E S Rp45,000
10 Marko B S Rp35,000

S M
E 45,000 70,000
B 35,000 55,000
Soal 3
MEMBUAT REKAP GAJI KARYAWAN

NO NAMA NIP STATUS

1 Endiartono 03110 Kawin

2 Hendriawan Ali 10111 Tidak Kwn
3 Randy Suwandi 04112 Kawin
4 Adhitya Samudra 08113 Kawin
5 Agung Mulyono 07114 Kawin
6 Andy Setiawan 09115 Tidak Kwn
7 Sarah Noordeviana 10116 Tidak Kwn
8 Ayu Anandhita 10117 Kawin
9 Ernawati 11118 Tidak Kwn
10 Rudolf Sakilangit 08119 Tidak Kwn
11 Herry Endarto 07120 Tidak Kwn
12 Rianto Suherman 11121 Kawin
13 Debby Andalausia 05122 Tidak Kwn

GRADE GJ POKOK

1 5,000,000
2 3,500,000
3 2,500,000
4 2,000,000
5 1,000,000
 LAMA TUNJANGAN
JML ANAK GRADE GJ POKOK
BEKERJA
ISTRI/SUAMI ANAK JABATAN
1 1 22 Rp5,250,000 Rp1,500,000 Rp500,000 Rp1,000,000
0 4 15 Rp2,100,000 Rp0 Rp0 Rp400,000
4 3 21 Rp2,625,000 Rp750,000 Rp750,000 Rp500,000
2 2 17 Rp3,675,000 Rp1,050,000 Rp700,000 Rp700,000
0 3 18 Rp2,625,000 Rp750,000 Rp0 Rp500,000
0 4 16 Rp2,100,000 Rp0 Rp0 Rp400,000
0 4 15 Rp2,100,000 Rp0 Rp0 Rp400,000
5 4 15 Rp2,100,000 Rp600,000 Rp600,000 Rp400,000
0 3 14 Rp2,625,000 Rp0 Rp0 Rp500,000
0 4 17 Rp2,100,000 Rp0 Rp0 Rp400,000
0 3 18 Rp2,625,000 Rp0 Rp0 Rp500,000
5 4 14 Rp2,100,000 Rp600,000 Rp600,000 Rp400,000
0 2 20 Rp3,675,000 Rp0 Rp0 Rp700,000

TUNJANGAN
ISTRI/SUAMI ANAK JABATAN TRANSPORT UANG MKN
1,500,000 500,000 1,000,000 250,000 300,000
1,050,000 350,000 700,000 175,000 250,000
750,000 250,000 500,000 125,000 230,000
600,000 200,000 400,000 100,000 200,000
300,000 100,000 200,000 50,000 180,000
UNJANGAN JUMLAH TASPEN ASURANSI
GJ KOTOR PAJAK 15%
TUNJANGAN 5% 2%
TRANSPORT UANG MKN
Rp250,000 Rp300,000 Rp3,550,000 Rp8,800,000 Rp440,000 Rp176,000 Rp1,320,000
Rp100,000 Rp200,000 Rp700,000 Rp2,800,000 Rp140,000 Rp56,000 Rp420,000
Rp125,000 Rp230,000 Rp2,355,000 Rp4,980,000 Rp249,000 Rp99,600 Rp747,000
Rp175,000 Rp250,000 Rp2,875,000 Rp6,550,000 Rp327,500 Rp131,000 Rp982,500
Rp125,000 Rp230,000 Rp1,605,000 Rp4,230,000 Rp211,500 Rp84,600 Rp634,500
Rp100,000 Rp200,000 Rp700,000 Rp2,800,000 Rp140,000 Rp56,000 Rp420,000
Rp100,000 Rp200,000 Rp700,000 Rp2,800,000 Rp140,000 Rp56,000 Rp420,000
Rp100,000 Rp200,000 Rp1,900,000 Rp4,000,000 Rp200,000 Rp80,000 Rp600,000
Rp125,000 Rp230,000 Rp855,000 Rp3,480,000 Rp174,000 Rp69,600 Rp522,000
Rp100,000 Rp200,000 Rp700,000 Rp2,800,000 Rp140,000 Rp56,000 Rp420,000
Rp125,000 Rp230,000 Rp855,000 Rp3,480,000 Rp174,000 Rp69,600 Rp522,000
Rp100,000 Rp200,000 Rp1,900,000 Rp4,000,000 Rp200,000 Rp80,000 Rp600,000
Rp175,000 Rp250,000 Rp1,125,000 Rp4,800,000 Rp240,000 Rp96,000 Rp720,000

TOTAL GAJI
GAJI TERBESAR
GAJI TERKECIL
GAJI RATA-RATA
BANYAKNYA PEGAWAI
BANYAKNYA PEGAWAI DENGAN GAJI DIATAS 3 JUTA
JUMLAH GAJI DIATAS 3 JUTA
GAJI BERSIH

Rp6,864,000
Rp2,184,000
Rp3,884,400
Rp5,109,000
Rp3,299,400
Rp2,184,000
Rp2,184,000
Rp3,120,000
Rp2,714,400
Rp2,184,000
Rp2,714,400
Rp3,120,000
Rp3,744,000

Rp43,305,600
Rp6,864,000
Rp2,184,000
Rp3,331,200
13
7
Rp29,140,800
Soal 4

LAPORAN PENJUALAN TIKET KERETA API

No Nama Umur Kode1 Nama Kereta Api Jurusan

1 Yully 40 Tahun AG-EXE Argo Gede Jakarta-Bandung

2 Sesha 30 Tahun SB-EXE Sembrani Jakarta-Surabaya
3 Nurmazan 32 Tahun TK-BIS Taksaka Jakarta-Yogyakarta
4 Nugroho 31 Tahun PR-EKO Parahyangan Jakarta-Bandung
5 Maurizka 54 Tahun BM-EXE Bima Jakarta-Malang
6 Maulita 56 Tahun AL-BIS Argo Lawu Jakarta-Surabaya
7 Iyop Ropika 70 Tahun TK-EXE Taksaka Jakarta-Yogyakarta
8 Fajar 3 Tahun AG-BIS Argo Gede Jakarta-Bandung
9 Arief 65 Tahun AG-EXE Argo Gede Jakarta-Bandung
10 Annabel 2 Tahun CE-EKO Cirebon Express Jakarta-Cirebon
11 Agus 37 Tahun AG-EXE Argo Gede Jakarta-Bandung
12 Ade Nurlaeli 50 Tahun CE-EXE Cirebon Express Jakarta-Cirebon

Kode1 Nama Kereta Api Jurusan Harga Tiket Kode2

AG Argo Gede Jakarta-Bandung Rp90,000 BIS

AL Argo Lawu Jakarta-Surabaya Rp220,000 EKO
AM Argo Mulia Jakarta-Semarang Rp160,000 EXE
BM Bima Jakarta-Malang Rp190,000
CE Cirebon Express Jakarta-Cirebon Rp60,000
PR Parahyangan Jakarta-Bandung Rp50,000
SB Sembrani Jakarta-Surabaya Rp150,000
TK Taksaka Jakarta-Yogyakarta Rp120,000
 Harga Tiket
Kelas Tarip Tambahan Harga Tiket Diskon Harga Jual
Dasar
Eksekutif Rp90,000 Rp45,000 Rp135,000 Rp0 Rp135,000
Eksekutif Rp150,000 Rp75,000 Rp225,000 Rp0 Rp225,000
Bisnis Rp120,000 Rp30,000 Rp150,000 Rp0 Rp150,000
Ekonomi Rp50,000 Rp0 Rp50,000 Rp0 Rp50,000
Eksekutif Rp190,000 Rp95,000 Rp285,000 Rp85,500 Rp199,500
Bisnis Rp220,000 Rp55,000 Rp275,000 Rp68,750 Rp206,250
Eksekutif Rp120,000 Rp60,000 Rp180,000 Rp54,000 Rp126,000
Bisnis Rp90,000 Rp22,500 Rp112,500 Rp28,125 Rp84,375
Eksekutif Rp90,000 Rp45,000 Rp135,000 Rp40,500 Rp94,500
Ekonomi Rp60,000 Rp0 Rp60,000 Rp9,000 Rp51,000
Eksekutif Rp90,000 Rp45,000 Rp135,000 Rp0 Rp135,000
Eksekutif Rp60,000 Rp30,000 Rp90,000 Rp0 Rp90,000

Tarip
Kelas
Tambahan
Bisnis 25%
Ekonomi 0%
Eksekutif 50%