Scribd Logo
Upload

Welcome to Scribd!

  • 11 views

    344

    Uploaded by

    niharikasarkar2005
    1) The document contains information about 5 employees - ASMIT, ARIT, ANIT, AMIT, and AJIT including their post, salary and other allowances. 2) It provides consolidated information for each post - Clerk, DO, Driver, Manager and Peon by summing the total salary and other details for the 5 employees under each post. 3) The last section provides the grand total for salary and other details by summing across all the posts.

    Copyright:

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

    344

    Uploaded by

    niharikasarkar2005
    11 views5 pages
    1) The document contains information about 5 employees - ASMIT, ARIT, ANIT, AMIT, and AJIT including their post, salary and other allowances. 2) It provides consolidated information for each post - Clerk, DO, Driver, Manager and Peon by summing the total salary and other details for the 5 employees under each post. 3) The last section provides the grand total for salary and other details by summing across all the posts.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1) The document contains information about 5 employees - ASMIT, ARIT, ANIT, AMIT, and AJIT including their post, salary and other allowances. 2) It provides consolidated information for each post - Clerk, DO, Driver, Manager and Peon by summing the total salary and other details for the 5 employees under each post. 3) The last section provides the grand total for salary and other details by summing across all the posts.

    Copyright:

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

    344

    Uploaded by

    niharikasarkar2005
    1) The document contains information about 5 employees - ASMIT, ARIT, ANIT, AMIT, and AJIT including their post, salary and other allowances. 2) It provides consolidated information for each post - Clerk, DO, Driver, Manager and Peon by summing the total salary and other details for the 5 employees under each post. 3) The last section provides the grand total for salary and other details by summing across all the posts.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 5

    NAME BENGALI HISTORY GEO MATH COMP TOTAL AVERAGE RANK

    AROY 56 73 85 92 99 405 81 2ND


    ANIOY 65 79 84 94 94 416 83.2 1ST
    AJOY 49 78 69 96 95 387 77.4 3RD
    AMIT 45 75 63 90 96 369 73.8 3RD
    ANIT 42 71 79 93 99 384 76.8 3RD
    NAME POST SALARY TA DA HRA GROSS PF NET
    AJIT DO 39000 3900 7800 11700 62400 2496 59904
    ANIT MANAGER 29000 2900 5800 8700 46400 1856 44544
    AMIT CLERK 25000 2500 5000 7500 40000 1600 38400
    ARIT PEON 22000 2200 4400 6600 35200 1408 33792
    ASMIT DRIVER 19500 1950 3900 5850 31200 1248 29952
    NAME POST SALARY TA DA HRA GROSS PF NET
    ASMIT DRIVER 19500 1950 3900 5850 31200 1248 29952
    ARIT PEON 22000 2200 4400 6600 35200 1408 33792
    ANIT MANAGER 29000 2900 5800 8700 46400 1856 44544
    AMIT CLERK 25000 2500 5000 7500 40000 1600 38400
    AJIT DO 39000 3900 7800 11700 62400 2496 59904

    SALARY
    <=26000

    NAME POST SALARY TA DA HRA GROSS PF NET


    AMIT CLERK 25000 2500 5000 7500 40000 1600 38400
    ARIT PEON 22000 2200 4400 6600 35200 1408 33792
    ASMIT DRIVER 19500 1950 3900 5850 31200 1248 29952
    NAME POST SALARY TA DA HRA GROSS PF NET
    ASMIT CLERK 19500 1950 3900 5850 31200 1248 29952
    ARIT CLERK 22000 2200 4400 6600 35200 1408 33792
    ANIT CLERK 29000 2900 5800 8700 46400 1856 44544
    AMIT CLERK 25000 2500 5000 7500 40000 1600 38400
    AJIT CLERK 39000 3900 7800 11700 62400 2496 59904
    CLERK Tota 134500 206592
    ASMIT DO 19500 1950 3900 5850 31200 1248 29952
    ARIT DO 22000 2200 4400 6600 35200 1408 33792
    ANIT DO 29000 2900 5800 8700 46400 1856 44544
    AMIT DO 25000 2500 5000 7500 40000 1600 38400
    AJIT DO 39000 3900 7800 11700 62400 2496 59904
    DO Total 134500 206592
    ASMIT DRIVER 19500 1950 3900 5850 31200 1248 29952
    ARIT DRIVER 22000 2200 4400 6600 35200 1408 33792
    ANIT DRIVER 29000 2900 5800 8700 46400 1856 44544
    AMIT DRIVER 25000 2500 5000 7500 40000 1600 38400
    AJIT DRIVER 39000 3900 7800 11700 62400 2496 59904
    DRIVER Tot 134500 206592
    ASMIT MANAGER 19500 1950 3900 5850 31200 1248 29952
    ARIT MANAGER 22000 2200 4400 6600 35200 1408 33792
    ANIT MANAGER 29000 2900 5800 8700 46400 1856 44544
    AMIT MANAGER 25000 2500 5000 7500 40000 1600 38400
    AJIT MANAGER 39000 3900 7800 11700 62400 2496 59904
    MANAGER T 134500 206592
    ASMIT PEON 19500 1950 3900 5850 31200 1248 29952
    ARIT PEON 22000 2200 4400 6600 35200 1408 33792
    ANIT PEON 29000 2900 5800 8700 46400 1856 44544
    AMIT PEON 25000 2500 5000 7500 40000 1600 38400
    AJIT PEON 39000 3900 7800 11700 62400 2496 59904
    PEON Tota 134500 206592
    Grand Tota 672500 1032960

    You might also like