Tugas
Aplikasi Komputer
Latihan 31
Tentang
oleh :
DINA PRITAMI (13106014)
Dosen Pembimbing
KEUKEU ROHENDI, M.KOM
PROGRAM STUDI PENDIDIKAN BIOLOGI JURUSAN TARBIYAH
SEKOLAH TINGGI AGAMA ISLAM NEGERI (STAIN)
BATUSANGKAR
2015
UD LARIS SELALU |
Laporan Penjualan
Minnguan |
|
NO |
Kode Barang |
Kode Sales |
Nama Barang |
Harga Satuan |
Jumlah Barang |
Nama Sales |
Jumlah Penjualan |
Bonus Sales |
Jumlah Total |
1 |
UD-L 01 |
A-LS 01 |
mouse intra |
Rp325.000 |
5 |
Ahmad Rianto |
Rp1.625.000 |
Rp48.750 |
Rp1.576.250 |
2 |
UD-L 03 |
C-LS 03 |
printer ink jel |
Rp476.000 |
4 |
Mahendri |
Rp1.904.000 |
Rp57.120 |
Rp1.846.880 |
3 |
UD-L 02 |
C-LS 03 |
monitar |
Rp760.000 |
4 |
Mahendri |
Rp3.040.000 |
Rp91.200 |
Rp2.948.800 |
4 |
UD-L 01 |
B-LS 02 |
mouse intra |
Rp325.000 |
7 |
Sherina |
Rp2.275.000 |
Rp68.250 |
Rp2.206.750 |
5 |
UD-L 01 |
B-LS 02 |
mouse intra |
Rp325.000 |
11 |
Sherina |
Rp3.575.000 |
Rp107.250 |
Rp3.467.750 |
6 |
UD-L 04 |
A-LS 01 |
keyboard intra |
Rp310.000 |
8 |
Ahmad Rianto |
Rp2.480.000 |
Rp74.400 |
Rp2.405.600 |
7 |
UD-L 05 |
D-LS 04 |
scanner |
Rp825.000 |
6 |
Iqbal |
Rp4.950.000 |
Rp148.500 |
Rp4.801.500 |
8 |
UD-L 04 |
D-LS 04 |
keyboard intra |
Rp310.000 |
8 |
Iqbal |
Rp2.480.000 |
Rp74.400 |
Rp2.405.600 |
9 |
UD-L 04 |
D-LS 04 |
keyboard intra |
Rp310.000 |
8 |
Iqbal |
Rp2.480.000 |
Rp74.400 |
Rp2.405.600 |
10 |
UD-L 02 |
A-LS 01 |
monitar |
Rp760.000 |
3 |
Ahmad Rianto |
Rp2.280.000 |
Rp68.400 |
Rp2.211.600 |
11 |
UD-L 02 |
C-LS 03 |
monitar |
Rp760.000 |
2 |
Mahendri |
Rp1.520.000 |
Rp182.400 |
Rp1.337.600 |
12 |
UD-L 01 |
C-LS 03 |
mouse intra |
Rp325.000 |
7 |
Mahendri |
Rp2.275.000 |
Rp68.250 |
Rp2.206.750 |
jumlah total
keseluruhan |
Rp29.820.680 |
jumlah penjualan
tertinggi |
Rp4.801.500 |
jumlah penjualan
terendah |
Rp1.337.600 |
rata-rata penjualan |
Rp2.485.057 |
jumlah total bonus
sales |
Rp1.063.320 |
|
bonus sales
tertinggi |
Rp182.400 |
|
bonus sales terendah |
Rp48.750 |
|
rata-rata bonus
sales |
Rp88.610 |
|
total bonus untuk
kode A-LS 01 |
Rp191.550 |
|
total
bonus untuk kode B-LS 02 |
Rp175.500 |
|
total bonus untuk
kode C-LS 03 |
Rp341.850 |
|
total bonus untuk
kode D-LS 04 |
Rp297.300 |
|
|
|
|
|
|
|
|
|
|
|
tabel 1 |
|
|
|
|
|
|
|
|
|
|
kode sales |
A-LS 01 |
B-LS 02 |
C-LS 03 |
D-LS 04 |
|
|
|
|
|
nama sales |
Ahmad Rianto |
Sherina |
Mahendri |
Iqbal |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
tabel 2 |
|
|
|
|
|
|
|
|
|
|
kode barang |
nama barang |
harga barang |
|
|
|
|
|
|
|
UD-L 01 |
mouse intra |
Rp325.000 |
|
|
|
|
|
|
|
UD-L 02 |
monitar |
Rp760.000 |
|
|
|
|
|
|
|
UD-L 03 |
printer ink jel |
Rp476.000 |
|
|
|
|
|
|
|
UD-L 04 |
keyboard intra |
Rp310.000 |
|
|
|
|
|
|
|
UD-L 05 |
scanner |
Rp825.000 |
|
|
|
|
|
|