Scribd Logo
Upload

Welcome to Scribd!

  • 25 views

    Arr Calculations

    Uploaded by

    MILIND
    The document contains calculations related to an employee's salary over a period of 16 months. It shows the old and new basic salary, DA, allowances and other details month-wise. It then summarizes the total difference in basic pay, DA, allowances, CPF amount, arrears due, etc. for different time periods. Some key figures include a total basic difference of Rs. 1,20,140, total DA difference of Rs. 1,25,672, total arrears due of Rs. 1,78,451 and CPF contribution of Rs. 29,497.

    Copyright:

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

    Arr Calculations

    Uploaded by

    MILIND
    25 views10 pages
    The document contains calculations related to an employee's salary over a period of 16 months. It shows the old and new basic salary, DA, allowances and other details month-wise. It then summarizes the total difference in basic pay, DA, allowances, CPF amount, arrears due, etc. for different time periods. Some key figures include a total basic difference of Rs. 1,20,140, total DA difference of Rs. 1,25,672, total arrears due of Rs. 1,78,451 and CPF contribution of Rs. 29,497.

    Original Description:

    refgret rr

    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 contains calculations related to an employee's salary over a period of 16 months. It shows the old and new basic salary, DA, allowances and other details month-wise. It then summarizes the total difference in basic pay, DA, allowances, CPF amount, arrears due, etc. for different time periods. Some key figures include a total basic difference of Rs. 1,20,140, total DA difference of Rs. 1,25,672, total arrears due of Rs. 1,78,451 and CPF contribution of Rs. 29,497.

    Copyright:

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

    Arr Calculations

    Uploaded by

    MILIND
    The document contains calculations related to an employee's salary over a period of 16 months. It shows the old and new basic salary, DA, allowances and other details month-wise. It then summarizes the total difference in basic pay, DA, allowances, CPF amount, arrears due, etc. for different time periods. Some key figures include a total basic difference of Rs. 1,20,140, total DA difference of Rs. 1,25,672, total arrears due of Rs. 1,78,451 and CPF contribution of Rs. 29,497.

    Copyright:

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

    APPROXIMATE CALCULATIONS

    Sr.No. Month Old_Basic 25 % Rise in Basic New Basic


    1 Apr-13 29280 36600 36605
    2 May-13 29280 36600 36605
    3 Jun-13 29280 36600 36605
    4 Jul-13 29280 36600 36605
    5 Aug-13 30255 37819 37825
    6 Sep-13 30255 37819 37825
    7 Oct-13 30255 37819 37825
    8 Nov-13 30255 37819 37825
    9 Dec-13 30255 37819 37825
    10 Jan-14 30255 37819 37825
    11 Feb-14 30255 37819 37825
    12 Mar-14 30255 37819 37825
    13 Apr-14 30255 37819 37825
    14 May-14 30255 37819 37825
    15 Jun-14 30255 37819 37825
    16 Jul-14 30255 37819 37825

    Basic Diff DA Diff Allowance Diff


    Sep-14 Apr-13 to Jul-13 29300 26515 5245
    Dec-14 Aug-13 to Nov-13 30280 27252 5245
    Apr-15 Dec-13 to Mar-14 30280 38600 5245
    Aug-15 Apr-14 to Jul-14 30280 33306 5245
    CALCULATIONS
    Allow. Type Old Fig New Fig
    ECA 440 550
    CLA 180 225
    ORDERLY 3500 4375
    BOOK 605 756.25
    ENTERTAINMENT 520 650
    FB 0 0
    Generation 0 0
    0 0
    0 0
    0 0
    0 0
    0 0
    0 0
    0 0
    Total Allowance 5245 6556

    Total Cpf 12 % Arrears


    61060 6698 54362
    62777 6904 55873
    74125 8266 65859
    68831 7630 61200
    Month Old_PayScale Actual Old DA DA % Old_Basic

    Apr-13 25380-975-30255-1105-54565 80 72 29280

    May-13 25380-975-30255-1105-54565 80 80 29280

    Jun-13 25380-975-30255-1105-54565 80 80 29280

    Jul-13 25380-975-30255-1105-54565 90 90 29280

    Aug-13 25380-975-30255-1105-54565 90 90 30255

    Sep-13 25380-975-30255-1105-54565 90 90 30255

    Oct-13 25380-975-30255-1105-54565 90 90 30255

    Nov-13 25380-975-30255-1105-54565 90 90 30255

    Dec-13 25380-975-30255-1105-54565 90 90 30255

    Jan-14 25380-975-30255-1105-54565 100 90 30255

    Feb-14 25380-975-30255-1105-54565 100 90 30255

    Mar-14 25380-975-30255-1105-54565 100 90 30255

    Apr-14 25380-975-30255-1105-54565 100 90 30255

    May-14 25380-975-30255-1105-54565 100 100 30255

    Jun-14 25380-975-30255-1105-54565 100 100 30255

    Jul-14 25380-975-30255-1105-54566 100 100 30255

    480180

    Total Difference CPF

    Sep-14 Apr-13 to Jul-13 62455 6698

    Dec-14 Aug-13 to Nov-13 64172 6904

    Apr-15 Dec-13 to Mar-14 75520 8266

    Aug-15 Apr-14 to Jul-14 70226 7630

    272372 29497

    30255 40510

    30255 40510

    6640 8300

    4500 4500

    71650 93820
    22170

    3500

    4500

    14170
    Old_DA_Amount New Basic New DA Basic Diff DA Diff ECA CLA

    21082 36605 29284 7325 8202 440 180

    23424 36605 29284 7325 5860 440 180

    23424 36605 29284 7325 5860 440 180

    26352 36605 32944.5 7325 6593 440 180

    27230 37825 34042.5 7570 6813 440 180

    27230 37825 34042.5 7570 6813 440 180

    27230 37825 34042.5 7570 6813 440 180

    27230 37825 34042.5 7570 6813 440 180

    27230 37825 34042.5 7570 6813 440 180

    27230 37825 37825 7570 10596 440 180

    27230 37825 37825 7570 10596 440 180

    27230 37825 37825 7570 10596 440 180

    27230 37825 37825 7570 10596 440 180

    30255 37825 37825 7570 7570 440 180

    30255 37825 37825 7570 7570 440 180

    30255 37825 37825 7570 7570 440 180

    430112 600320 555784 120140 125672

    120140 125672

    Income Tax @ 30 % Arr in hand

    11566 44191 29300 26515

    11909 45359 30280 27252

    21268 45986 30280 38600

    19680 42915 30280 33306

    64424 178451

    37825

    37825

    8300

    4500

    88450
    OLD Allowances

    ORDERLY BOOK ENTERTAINMENT FB Old All Total ECA CLA ORDERLY

    3500 605 520 1395 6640 550 225 4375

    3500 605 520 1395 6640 550 225 4375

    3500 605 520 1395 6640 550 225 4375

    3500 605 520 1395 6640 550 225 4375

    3500 605 520 1395 6640 550 225 4375

    3500 605 520 1395 6640 550 225 4375

    3500 605 520 1395 6640 550 225 4375

    3500 605 520 1395 6640 550 225 4375

    3500 605 520 1395 6640 550 225 4375

    3500 605 520 1395 6640 550 225 4375

    3500 605 520 1395 6640 550 225 4375

    3500 605 520 1395 6640 550 225 4375

    3500 605 520 1395 6640 550 225 4375

    3500 605 520 1395 6640 550 225 4375

    3500 605 520 1395 6640 550 225 4375

    3500 605 520 1395 6640 550 225 4375

    Taxable Total

    57830

    59547

    70895

    65601
    New Allowances

    BOOK ENTERTAINMENT FB_EDP Taxable Non Taxable New All Total Allow Diff

    756 650 1744 504 1156 8300 1660

    756 650 1744 504 1156 8300 1660

    756 650 1744 504 1156 8300 1660

    756 650 1744 504 1156 8300 1660

    756 650 1744 504 1156 8300 1660

    756 650 1744 504 1156 8300 1660

    756 650 1744 504 1156 8300 1660

    756 650 1744 504 1156 8300 1660

    756 650 1744 504 1156 8300 1660

    756 650 1744 504 1156 8300 1660

    756 650 1744 504 1156 8300 1660

    756 650 1744 504 1156 8300 1660

    756 650 1744 504 1156 8300 1660

    756 650 1744 504 1156 8300 1660

    756 650 1744 504 1156 8300 1660

    756 650 1744 504 1156 8300 1660

    26560

    Taxable Non tax Total

    2015 4625 6640

    2015 4625 6640

    2015 4625 6640

    2015 4625 6640

    You might also like