Scribd Logo
Upload

Welcome to Scribd!

  • 29 views

    7 Sss and Philhealth

    Uploaded by

    ARRAICE YAM NERAK
    The document instructs to use the LOOKUP function to fill in the SSS and Philhealth columns for each employee by referring to the provided tables, which list employee contribution amounts for different salary levels. This task is worth 30 points.

    Copyright:

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

    7 Sss and Philhealth

    Uploaded by

    ARRAICE YAM NERAK
    29 views3 pages
    The document instructs to use the LOOKUP function to fill in the SSS and Philhealth columns for each employee by referring to the provided tables, which list employee contribution amounts for different salary levels. This task is worth 30 points.

    Original Description:

    how to compute sss and philhealth

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document instructs to use the LOOKUP function to fill in the SSS and Philhealth columns for each employee by referring to the provided tables, which list employee contribution amounts for different salary levels. This task is worth 30 points.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    29 views3 pages

    7 Sss and Philhealth

    Uploaded by

    ARRAICE YAM NERAK
    The document instructs to use the LOOKUP function to fill in the SSS and Philhealth columns for each employee by referring to the provided tables, which list employee contribution amounts for different salary levels. This task is worth 30 points.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 3

    Part 2. Use the LOOKUP function to fill up the values under the SSS and Philhealth columns.

    Refer to the tables pr


    the ‘SSS and PhilHealth’ worksheet. This part is worth 30 points.

    Base salary SSS PhilHealth


    Abeja, Alexis B. 6,300.00
    Angay, Marcus Daniel D. 11,500.00
    Ayaay, Pearl 8,900.00
    Banta, Anna Erika 7,275.00
    Batocabe, Shelbert M. 9,875.00
    Crispo, Leziel D. 11,825.00
    Cuanan, Diane 7,600.00
    Dañez, Velman E. 13,450.00
    De la Cruz, Jane Roe Stephane R. 13,775.00
    De Ocampo, Diana O. 14,425.00
    Dimaculangan, Jocelyn L. 12,800.00
    Edaño, Eloise 8,250.00
    Go, Chinette Angela Kim A. 10,850.00
    Ignacio, Liezel A. 5,325.00
    Lazarte, Liezel 6,625.00
    Losloso, Glyren M. 12,475.00
    Malasmas, Edward Joseph H. 14,750.00
    Mancenido, Ann Cherie 11,175.00
    Martinez, Mary Rose Apple G. 15,725.00
    Medina, Mary Antonette 12,150.00
    Mercurio, Geselle P. 5,650.00
    Merluza, Racel G. 5,000.00
    Napeñas, Yves A. 10,200.00
    Nieva, Jezie Ann H. 13,125.00
    Oriarte, Princess L. 9,550.00
    Paco, Heorgy Mhel M. 10,525.00
    Padillo, Jelyne A. 5,975.00
    Padillo, Reden P. 15,075.00
    Pangan, Jeseca 14,100.00
    Peras, Rose Abigail L. 7,925.00
    Perez, Jeana Monica A. 8,575.00
    Sio, Raissa M. 9,225.00
    Talusig, Karla Carmela M. 15,400.00
    Tan, Jeff John G. 6,950.00
    hilhealth columns. Refer to the tables provided in

    Other deductions Total deductions NET SALARY


    630.00
    1,150.00
    890.00
    727.50
    987.50
    1,182.50
    760.00
    1,345.00
    1,377.50
    1,442.50
    1,280.00
    825.00
    1,085.00
    532.50
    662.50
    1,247.50
    1,475.00
    1,117.50
    1,572.50
    1,215.00
    565.00
    500.00
    1,020.00
    1,312.50
    955.00
    1,052.50
    597.50
    1,507.50
    1,410.00
    792.50
    857.50
    922.50
    1,540.00
    695.00
    SSS Table Philhealth Table
    Employee's Employee's
    Salary base contribution Salary base contribution
    1,000.00 33.30 1,000.00 50.00
    1,500.00 50.00 2,000.00 62.50
    2,000.00 66.70 3,000.00 75.00
    2,500.00 83.40 4,000.00 87.50
    3,000.00 100.10 5,000.00 100.00
    3,500.00 116.80 6,000.00 112.50
    4,000.00 133.50 7,000.00 125.00
    4,500.00 150.20 8,000.00 137.50
    5,000.00 166.90 9,000.00 150.00
    5,500.00 183.60 10,000.00 162.50
    6,000.00 200.30 11,000.00 175.00
    6,500.00 217.00 12,000.00 187.50
    7,000.00 233.70 13,000.00 200.00
    7,500.00 250.40 14,000.00 212.50
    8,000.00 267.10 15,000.00 225.00
    8,500.00 283.80
    9,000.00 300.50
    9,500.00 317.20
    10,000.00 333.90
    10,500.00 350.60
    11,000.00 367.30
    11,500.00 384.00
    12,000.00 400.70
    12,500.00 417.40
    13,000.00 434.10
    13,500.00 450.80
    14,000.00 467.50
    14,500.00 484.20
    15,000.00 500.90

    You might also like