PT. MARKINDO Jl. Soekarno Hatta No.9 Malang Telp. 0341-4404424
PEMBAYARAN INSENTIF DESEMBER 2012 No.
Nama
Kode Pegawai
Jumlah Jual
Jenis Kelamin
Jabatan
Target Penjualan
Insentif
1
Jeni
PSM10
15
P
SM
10
Rp350,000.00
2
Adytia
LSL10
8
L
SL
10
Rp250,000.00
3
Andi
LSL08
20
L
SL
08
Rp250,000.00
4
Ahmad
LSC10
15
L
SC
10
Rp150,000.00
5
Bagus
LSL07
7
L
SL
07
Rp250,000.00
6
Atika
PSC05
15
P
SC
05
Rp150,000.00
7
Safira
PSC10
20
P
SC
10
Rp150,000.00
8
Faisal
LSL05
5
L
SL
05
Rp250,000.00
9
Dendy
LSC05
5
L
SC
05
Rp150,000.00
10
Gebyar
LSL07
3
L
SL
07
Rp250,000.00
Rumus Kolom Jenis Kelamin :
"=LEFT(C8;1)"
Rumus Kolom Jabatan : Rumus Kolom Target Penjualan :
"=MID(C8;2;2)" "=RIGHT(C8;2)"
Rumus Kolom Insentif : Rumus Kolom Bonus :
"=VLOOKUP(F8;$M$9:$N$11;2)"
Rumus Kolom Pajak : Rumus Kolom Total :
"=IF((D8-G8)<=0;"0";IF((D8-G8)<=4;"100.000";IF((D8-G8)<=9;"500.000";IF((D8
"=((H8+I8)*25%)" "=((H8-J8)+(I8-J8))"
Bonus
Pajak
Total
TABEL INSE
Rp50 Rp500, 0,00 000. 0.00 00
Rp21 Rp21,2 ,250 50.0 .00 0
Rp80 Rp807, 7,50 500. 0.00 00
Jabatan
Rp0.00
Rp6,250.00
Rp237,500.00
SC
Rp1,000,000.00
Rp31,250.00
Rp1,187,500.00
SL
Rp500,000.00
Rp16,250.00
Rp617,500.00
SM
Rp0.00
Rp6,250.00
Rp Rp237,500.00
Rp1,000,000.00
Rp28,750. Rp28,750.00 00
Rp1,092,5 Rp1,092,500.00 00.00
Rp1,000,000.00
Rp28,750. Rp28,750.00 00
Rp1,092,5 Rp1,092,500.00 00.00
Rp0.00
Rp6, Rp6,25 250. 0.00 00
Rp23 Rp237, 7,50 500. 0.00 00
Rp0.00
Rp3, Rp3,75 750. 0.00 00
Rp14 Rp142, 2,50 500. 0.00 00
Rp0.00
Rp6, Rp6,25 250. 0.00 00
Rp23 Rp237, 7,50 500. 0.00 00
-G8)>9;"1.000.000"))))"
TIF Insentif Rp150,000.00 Rp250,000.00 Rp350,000.00