Scribd Logo
Upload

Welcome to Scribd!

  • 32 views

    Itk - Tugas 3

    Uploaded by

    Riski Lya Amalia
    The document contains a table listing the names and salaries of 5 employees of PT. Maju Mundur. It includes basic salary, allowances, transportation, total salary, tax, and net salary for each employee. Additional tables provide the salary scales and tax rates based on employee level. The highest paid employee receives Rp. 1,221,000 total salary while the lowest is Rp. 750,000. Total salaries for all employees is Rp. 51,300,000 with Rp. 1,708,000 deducted as tax.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Itk - Tugas 3

    Uploaded by

    Riski Lya Amalia
    32 views12 pages
    The document contains a table listing the names and salaries of 5 employees of PT. Maju Mundur. It includes basic salary, allowances, transportation, total salary, tax, and net salary for each employee. Additional tables provide the salary scales and tax rates based on employee level. The highest paid employee receives Rp. 1,221,000 total salary while the lowest is Rp. 750,000. Total salaries for all employees is Rp. 51,300,000 with Rp. 1,708,000 deducted as tax.

    Original Title

    ITK_TUGAS 3

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains a table listing the names and salaries of 5 employees of PT. Maju Mundur. It includes basic salary, allowances, transportation, total salary, tax, and net salary for each employee. Additional tables provide the salary scales and tax rates based on employee level. The highest paid employee receives Rp. 1,221,000 total salary while the lowest is Rp. 750,000. Total salaries for all employees is Rp. 51,300,000 with Rp. 1,708,000 deducted as tax.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    32 views12 pages

    Itk - Tugas 3

    Uploaded by

    Riski Lya Amalia
    The document contains a table listing the names and salaries of 5 employees of PT. Maju Mundur. It includes basic salary, allowances, transportation, total salary, tax, and net salary for each employee. Additional tables provide the salary scales and tax rates based on employee level. The highest paid employee receives Rp. 1,221,000 total salary while the lowest is Rp. 750,000. Total salaries for all employees is Rp. 51,300,000 with Rp. 1,708,000 deducted as tax.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 12

    A B A+B A-B A*B A/B A * 10%

    56 23 79 33 1288 2.4347826 5.6


    45 34 79 11 1530 1.3235294 4.5
    75 23 98 52 1725 3.2608696 7.5
    78 11 89 67 858 7.0909091 7.8
    78 34 112 44 2652 2.2941176 7.8
    98 45 143 53 4410 2.1777778 9.8
    67 23 90 44 1541 2.9130435 6.7
    78 53 131 25 4134 1.4716981 7.8
    67 23 90 44 1541 2.9130435 6.7
    97 12 109 85 1164 8.0833333 9.7
    90 34 124 56 3060 2.6470588 9
    67 54 121 13 3618 1.2407407 6.7
    67 65 132 2 4355 1.0307692 6.7
    97 34 131 63 3298 2.8529412 9.7
    Total 1528 592 35174 41.7346145 106
    Rata - Rata 109.142857142857 42.28571429 2512.42857 2.98104389 7.57142857
    Nilai Tertinggi 143 85 4410 8.08333333 9.8
    Nilai Terendah 79 2 858 1.03076923 4.5
    Jumlah Item 14 14 14 14 14
    B * 20% B - (B * 20%)
    4.6 18.4
    6.8 27.2
    4.6 18.4
    2.2 8.8
    6.8 27.2
    9 36
    4.6 18.4
    10.6 42.4
    4.6 18.4
    2.4 9.6
    6.8 27.2
    10.8 43.2
    13 52
    6.8 27.2
    93.6 374.4
    6.685714286 26.7428571428571
    13 52
    2.2 8.8
    14 14
    PT. TELKOM INDONESIA Tbk Cab
    DAFTAR UPAH KARYAW
    BULAN AGUSTUS 201

    NO NAMA JAM KERJA JAM LEMBUR


    1 Adhyastha Gultorn 45 15
    2 Adrian Meshach Pradipto 48 17
    3 Adriell Raymond 47 11
    4 Maritza Zaila Beatric 50 10
    5 Meiying Rawnie Xianlun 45 12
    6 Nurdaffa Pratama 44 10
    7 Tony Mathew 50 15
    8 Vanio Tristan Ardhani 39 10
    9 Vincent Hadi Wijaya 41 12
    10 Wyne Malvin 45 17
    Total Upah Seluruh Karyawan
    Rata-Rata Upah Seluruh Karyawan
    Upah Tertinggi Karyawan
    Upah Terendah Karyawan
    PT. TELKOM INDONESIA Tbk Cabang Pontianak
    DAFTAR UPAH KARYAWAN
    BULAN AGUSTUS 2015

    UPAH KERJA (KOTOR) UPAH LEMBUR TOTAL UPAH PAJAK


    1125000 450000 1575000 78750
    1200000 510000 1710000 85500
    1175000 330000 1505000 75250
    1250000 300000 1550000 77500
    1125000 360000 1485000 74250
    1100000 300000 1400000 70000
    1250000 450000 1700000 85000
    975000 300000 1275000 63750
    1025000 360000 1385000 69250
    1125000 510000 1635000 81750
    TOTAL UPAH (NETTO)
    1496250
    1624500
    1429750
    1472500
    1410750
    1330000
    1615000
    1211250
    1315750
    1553250
    14459000
    1445900
    1624500
    1211250
    NO NAMA NILAI STATUS
    1 DINA 80 Complete NOTE :
    2 YUNI 60 Failed
    Grade : Grade A for Marks 90-100, Grade B fo
    3 DANI 55 Failed
    4 ANA 90 Complete Status : if grade > 75 is Complete, if grade < 7
    5 JEFRI 75 0
    Grade A for Marks 90-100, Grade B for marks 80-89, Grade C for marks 70-79, Grade D for marks 60-69, Grade E for < 60
    f grade > 75 is Complete, if grade < 75 is Failed
    Grade B for marks 80-89, Grade C for marks 70-79, Grade D for marks 60-69, Grade E for < 60
    if grade < 75 is Failed
    VLOOKUP
    MENGHITUNG HARGA JUAL BUKU

    No Judul Buku Kategori Harga Buku Diskon


    1 Tip dan Trik Photoshop CS6 A 275000 25%
    2 Manajemen Website dan Web Server C 220000 75%
    3 Hacker dan Keamanan A 310000 25%
    4 Desain Web Praktis dengan CSS A 400000 25%
    5 Animasi Iklan Flash untuk Pemula B 180000 50%
    6 Magic of Adobe After Effect C 150000 75%

    Kategori Diskon
    A 25%
    B 50%
    C 75%
    Harga Jual
    Rp 275,000
    Rp 219,999
    Rp 310,000
    Rp 400,000
    Rp 180,000
    Rp 149,999
    DAFTAR GAJI PEGAWAI PT.MAJU MUNDUR

    Gaji
    No Gol Nama Pegawai
    Gaji Pokok Tunjangan Transportasi
    1 1C Adam Albert Adrian 1000000 120000 100000
    2 1B Huanran Alko Fausta 800000 70000 100000
    3 1B Indrasta Hastungkara 800000 70000 100000
    4 1C Ivan Reynard Adley 1000000 120000 100000
    5 1A Reuel Avshalom 600000 50000 100000
    Total 4200000 430000 500000

    Tabel Gaji
    Gol Gaji Pokok Tunjangan Transportasi
    1A 600000 50000 100000
    1B 800000 70000 100000
    1C 1000000 120000 100000
    MUNDUR

    Total Gaji Pajak Gaji Bersih

    1220000 48800 1171200


    970000 29100 940900
    970000 29100 940900
    1220000 48800 1171200
    750000 15000 735000
    5130000 170800 4959200

    Tabel Pajak
    1A 1B 1C
    2% 3% 4%

    You might also like