Scribd Logo
Upload

Welcome to Scribd!

  • 15 views

    NO Nama Karyawan Upah Kerja JAM Kerja JAM Lembua R

    Uploaded by

    dika subendra
    The document contains a table listing 10 employees with their work hours, salaries, overtime pay, bonuses, taxes, and net salaries. It summarizes that the total net pay for all employees is Rp 814,953,13, with an average net salary of Rp 81,495.31. The highest net salary is Rp 114,078.13 for May Nurul Aini and the lowest is Rp 50,312.50 for Nur Aini.

    Copyright:

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

    NO Nama Karyawan Upah Kerja JAM Kerja JAM Lembua R

    Uploaded by

    dika subendra
    15 views2 pages
    The document contains a table listing 10 employees with their work hours, salaries, overtime pay, bonuses, taxes, and net salaries. It summarizes that the total net pay for all employees is Rp 814,953,13, with an average net salary of Rp 81,495.31. The highest net salary is Rp 114,078.13 for May Nurul Aini and the lowest is Rp 50,312.50 for Nur Aini.

    Original Description:

    gampang excel

    Original Title

    Ujian Excel

    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 10 employees with their work hours, salaries, overtime pay, bonuses, taxes, and net salaries. It summarizes that the total net pay for all employees is Rp 814,953,13, with an average net salary of Rp 81,495.31. The highest net salary is Rp 114,078.13 for May Nurul Aini and the lowest is Rp 50,312.50 for Nur Aini.

    Copyright:

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

    NO Nama Karyawan Upah Kerja JAM Kerja JAM Lembua R

    Uploaded by

    dika subendra
    The document contains a table listing 10 employees with their work hours, salaries, overtime pay, bonuses, taxes, and net salaries. It summarizes that the total net pay for all employees is Rp 814,953,13, with an average net salary of Rp 81,495.31. The highest net salary is Rp 114,078.13 for May Nurul Aini and the lowest is Rp 50,312.50 for Nur Aini.

    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 2

    JAM

    JAM
    NO NAMA KARYAWAN LEMBUA UPAH KERJA
    KERJA R
    1 MUHAMMAD IKHSAN 40 JAM 9 JAM Rp 80,000.00
    2 NUR AINI 20 JAM 7 JAM Rp 40,000.00
    3 KOMARUDIN 31 JAM 8 JAM Rp 62,000.00
    4 LILIS HIDAYATI 38 JAM 8 JAM Rp 76,000.00
    5 ERMA NAWIYATI 25 JAM 7 JAM Rp 50,000.00
    6 EVENDY F. 48 JAM 10 JAM Rp 96,000.00
    7 RAMDHANY F. 40 JAM 8 JAM Rp 80,000.00
    8 RENDY ARIF R. 30 JAM 9 JAM Rp 60,000.00
    9 MAY NURUL AINI 50 JAM 9 JAM Rp 100,000.00
    10 ALI ABDUL GODIR 25 JAM 7 JAM Rp 50,000.00
    TOTAL UPAH SELURUHNYA
    RATA RATA UPAH NETTO
    NILAI TERTINGGI UPAH NETTO
    NILAI TERRENDAH UPAH NETTO
    TOTAL UPAH TOTAL UPAH
    UPAH LEMBUR BONUS 35% PPH 12,5%
    (BRUTO) (NETTO)

    Rp 22,500.00 Rp 7,875.00 Rp 110,375.00 Rp 13,796.88 Rp 96,578.13


    Rp 17,500.00 Rp - Rp 57,500.00 Rp 7,187.50 Rp 50,312.50
    Rp 20,000.00 Rp - Rp 82,000.00 Rp 10,250.00 Rp 71,750.00
    Rp 20,000.00 Rp - Rp 96,000.00 Rp 12,000.00 Rp 84,000.00
    Rp 17,500.00 Rp - Rp 67,500.00 Rp 8,437.50 Rp 59,062.50
    Rp 25,000.00 Rp 8,750.00 Rp 129,750.00 Rp 16,218.75 Rp 113,531.25
    Rp 20,000.00 Rp - Rp 100,000.00 Rp 12,500.00 Rp 87,500.00
    Rp 22,500.00 Rp 7,875.00 Rp 90,375.00 Rp 11,296.88 Rp 79,078.13
    Rp 22,500.00 Rp 7,875.00 Rp 130,375.00 Rp 16,296.88 Rp 114,078.13
    Rp 17,500.00 Rp - Rp 67,500.00 Rp 8,437.50 Rp 59,062.50
    TOTAL UPAH SELURUHNYA Rp 814,953.13
    RATA RATA UPAH NETTO Rp 81,495.31
    NILAI TERTINGGI UPAH NETTO Rp 114,078.13
    NILAI TERRENDAH UPAH NETTO Rp 50,312.50

    You might also like