Data penyewaan rental mobil

DATA PENYEWAAN MOBIL
RENTAL INDAH
Jalan SM. Raja No.90 Medan
NO	Nama Penyewa	Tipe	Tanggal Sewa	Tanggal Kembali	Lama	Sewa PerHari	Ket.Mobil		Pajak	Total		Potongan	Harus bayar
1	Ani	D	10-Jun-08	15-Jun-08	5	150,000	Futura PU		15,000	765,000		-	765,000
2	Zaenal	A	11-Jun-08	19-Jun-08	8	375,000	BMW		37,500	3,037,500		-	3,037,500
3	Putri	C	10-Jun-08	17-Jun-08	7	225,000	Suzuki APV		22,500	1,597,500		-	1,597,500
4	Andi	A	19-Jun-08	25-Jun-08	6	375,000	BMW		37,500	2,287,500		-	2,287,500
5	Ridwan	B	12-Jun-08	27-Jun-08	15	300,000	Kijang LX		30,000	4,530,000		226,500	4,303,500
6	Tia	D	19-Jun-08	30-Jul-08	41	150,000	Futura PU		15,000	6,165,000		308,250	5,856,750
7	Monica	C	13-Jun-08	15-Jul-08	32	225,000	Suzuki APV		22,500	7,222,500		361,125	6,861,375
					Jumlah				180,000	25,605,000		895,875	24,709,125
					Nilai Tertinggi				37,500	7,222,500		361,125	6,861,375
					Nilai Terkecil				15,000	765,000		-	765,000
					Total				25,714	3,657,857		127,982	3,529,875
Tabel Sewa
Tipe	Sewa per-Hari	Keterangan Mobil
A	Rp375,000	BMW
B	Rp300,000	Kijang LX
C	Rp225,000	Suzuki APV
D	Rp150,000	Futura PU