example-salary

Document Sample
example-salary Powered By Docstoc
					                            Example for Salaries and Wages Computation

                                                                                                                                                                                               AMOUNT OF
                                                                                                                                                                             AMOUNT OF       BASIC SALARY SHOW BELOW THE
                                                                                                                                                                                                                                                                                                                                                                                                                                                                     TOTAL       TOTAL      BALANCE OF
                                                                                          ESTIMATED                                                                          INDIVIDUAL         RECEIVED         ACTUAL                                                                                                                            PERIOD 1        PERIOD 2     PERIOD 2     PERIOD 3       PERIOD 3   PERIOD 4   PERIOD 4   PERIOD 5   PERIOD 5    ACTUAL      BUDGET      FUNDS USED
                                                                                                                                                                          MONTHLY SALARY                      INDIVIDUAL'S                                                                                           PERIOD 1 BUDGET
                                                                                            ANNUAL                                                                                                FROM                                                                                                                                              ACTUAL          BUDGET       ACTUAL       BUDGET         ACTUAL     BUDGET     ACTUAL     BUDGET     ACTUAL    PERIODS 1   PERIODS 1   PERIODS 1 TO
                                                                                                                                                                           TOP-UP (EUROS)                    GROSS MONTHLY
                                                                                         PAYRISE (%)                                                                                           INSTITUTE                                                                                CHECK CELL WILL BE                                                                                                                                                            TO 5        TO 5          5
                                                                                                                                                                          BEING REQUESTED     WHERE THEY     SALARY (EURO)    NO. OF MONTHS
                                                                                                                                                                                                                                                                                       YELLOW IF INCORRECT
                                          PERCENTAGE (%) OF                               APPLIES TO                                                                       FROM EDCTP FOR    ARE WORKING       FOR PERSON     OVER DURATION
            WORK PACKAGES (PLEASE SELECT                                                                                                                                                                                                       TOTAL TO BE SPREAD OVER PERIOD 1 TO   (AFTER YOU HAVE SPLIT IT
COST CENTRE                              PERSON'S TIME SPENT                             BASIC GROSS                JOB TITLE                                NAME        PERSON IDENTIFIED     INCLUDING      INCLUDED ON     OF THE PROJECT
              FROM THE DROPDOWN BOX)                                                                                                                                        ON EACH LINE -                      EACH LINE      PER PERSON -
                                                                                                                                                                                                                                                            5 - BUDGET                  ACROSS THE BUDGET
                                             ON PROJECT                                  SALARY ONLY                                                                                           ALL OTHER                                                                                COLUMNS), BLANK IF
                                                                                                                                                                          GROSS AND FIXED                    EXCLUDING ANY        BUDGET
                                                                                        NOT TO SALARY                                                                                         SALARY TOP -                                                                                    RIGHT
                                                                                                                                                                          AMOUNT (USE AN     UP'S ALREADY SALARY TOP-UP'S                                                                                                    EURO                     EURO           EURO         EURO         EURO          EURO       EURO       EURO       EURO       EURO        EURO        EURO         EURO
                                                                                        TOP UP - MUST                                                                     AVERAGE IF MORE                   (USE AN AVERAGE
                                                                                                                                                                                                 BEING
                                                                                          BE ENTERED                                                                     THAN 1 PERSON PER                   IF MORE THAN 1
                                                                                                                                                                                              RECEIVED BY
                                                                                                                                                                                LINE)        THIS PERSON - PERSON PER LINE)
                                                                                                                                                                                             ONLY FILL THIS

                WP3C-CAPACITY BUILDING (SENIOR
    40200                                                              50%                   5%                   SR Fellow Awardee                          Dr John                                             900                60                      29,838                                0                           5,400                                  5,670                      5,954                    6,251                 6,564                   0         29,838       29,838
                          FELLOSHIP)



              WP2-CLINICAL TRIALS (HIV - SIMPLIFIED
    33011                                                              50%                   5%                       Dr Smith                               Dr Smith           300                              900                60                      47,838                                0                           9,000                                  9,270                      9,554                    9,851                10,164                   0         47,838       47,838
                  ARV'S IN ADULTS & CHILDREN)



              WP2-CLINICAL TRIALS (HIV - SIMPLIFIED
    33011                                                              100%                  5%                       Ms. Barry                              Ms. Barry                                           900                60                      59,677                                0                          10,800                                  11,340                    11,907                   12,502                13,127                   0         59,677       59,677
                  ARV'S IN ADULTS & CHILDREN)


              WP2-CLINICAL TRIALS (HIV - SIMPLIFIED
    33011                                                              500%                  5%                        nurses                                  TBR                                               900                60                      298,384                               0                          54,000                                  56,700                    59,535                   62,512                65,637                   0        298,384       298,384
                  ARV'S IN ADULTS & CHILDREN)



              WP2-CLINICAL TRIALS (HIV - SIMPLIFIED
    33011                                                              100%                  0%                        Ms Cool                               Ms Cool            300                              900                60                      72,000                             72,000                                                                                                                                                                  0           0            0
                  ARV'S IN ADULTS & CHILDREN)




Example 1:   Without Supplements                                                                                                                                                                                                                           Example 4:                Without Supplements and 500% percentage time spent
                                                                       900
             Basic Salary                                                               MONTHS                                                                                                                                                                                       Total headcounts                                        5

             Life of the project                                               5 YRS                12 MONTHS                                                                                                                                                                        Basic salary                                         900

             Supplement                                                         none                                                                                                                                                                                                 life of the project                              5 years

             % increase per year                                                 5%               1.05                                                                                                                                                                               supplement

             percentage of time spent                                           50%               50%                                                                                                                                                                                % increase per year                                   5%
                                                                                                                                        Total to                                                                                                                                     percentage of time
                                                          Gross salary * months Gross per year***        Supplement per year          spread over   PERIODS                                                                                                                          spent                                              500%
                                                                                                                                         years                                                                                                                                                                                                   Gross per year     Supplement per year        Total to
                                                                                                                                                                                                                                                                                                                   Gross salary * months            without        should not be increased   spread over    PERIODS
             Year 1                                                              900          5,400.00                       -           5,400.00   Year 1                                                                                                                                                                                       supplement***             by 5%                years

             Year 2                                                              900          5,670.00                       -           5,670.00   Year 2                                                                                                                           Year 1                       900x12*500%                          54,000.00                                54,000.00   Year 1

             Year 3                                                              900          5,953.50                       -           5,953.50   Year 3                                                                                                                           Year 2                       900x12x500%1.05                      56,700.00                                56,700.00   Year 2

             Year 4                                                              900          6,251.18                       -           6,251.18   Year 4                                                                                                                           Year 3                       900x12x500%(1.05)^2                  59,535.00                                59,535.00   Year 3

             Year 5                                                              900          6,563.73                       -           6,563.73   Year 5                                                                                                                           Year 4                       900x12x500%(1.05)^3                  62,511.75                                62,511.75   Year 4
             Total                                                                           29,838.41                                  29,838.41                                                                                                                                    Year 5                       900x12x500%(1.05)^4                  65,637.34                                65,637.34   Year 5

                                                                                                                                                                                                                                                                                     Total                                                                                                     298,384.09

             ***Gross per year = balance per year multiplied by rate
                                                                                                                                                                                                                                                                         ***Gross per year = balance per year multiplied by rate
                       example: 5,400x1.05=5,670

                                                                                                                                                                                                                                                                                   example: 54000*1.05=56,700

Example 2:   Calculations with the percentage (%) of person's time spent on project
             Basic salary                                                        900
             life of the project                                              5 years

             supplement (fixed no increment)
                                                                                 300                                                                                                                                                                       Example 5:                With Supplements and 100% percentage time spent, without yearly increase
             % increase per year                                                 5%
             percentage of time spent                                           50%                                                                                                                                                                                                  Basic salary                                         900
                                                                                                                                        Total to
                                                          Gross salary * months Gross per year***        Supplement per year          spread over   PERIODS                                                                                                                          life of the project                              5 years
                                                                                                                                         years                                                                                                                                       supplement                                           300

             Year 1                                      (900x.5)12                           5,400.00 300x12          3,600.00          9,000.00   Year 1                                                                                                                           % increase per year                                none
                                                                                                                                                                                                                                                                                     percentage of time
             Year 2                                      (900x.5x12)1.05                      5,670.00 300x12          3,600.00          9,270.00   Year 2                                                                                                                           spent                                              100%
                                                                                                                                                                                                                                                                                                                                                 Gross per year                                Total to
             Year 3                                      (900x.5x12) (1.05)^2                 5,953.50 300x12          3,600.00          9,553.50   Year 3                                                                                                                                                         Gross salary * months            without         Supplement per year      spread over    PERIODS
             Year 4                                      (900x.5x12) (1.05)^3                 6,251.18 300x12          3,600.00          9,851.18   Year 4                                                                                                                                                                                       supplement***                                  years

             Year 5                                      (900x.5x12)x(1.05)^4                 6,563.73 300x12          3,600.00         10,163.73   Year 5                                                                                                                           Year 1                       900x12*100%                          10,800.00 300*12           3,600.00      14,400.00   Year 1

             TOTAL                                                                           29,838.41                                  47,838.41                                                                                                                                    Year 2                       900x12*100%                          10,800.00 300*12           3,600.00      14,400.00   Year 2

                                                                                                                                                                                                                                                                                     Year 3                       900x12*100%                          10,800.00 300*12           3,600.00      14,400.00   Year 3

             ***Gross per year = balance per year multiplied by rate                                                                                                                                                                                                                 Year 4                       900x12*100%                          10,800.00 300*12           3,600.00      14,400.00   Year 4

                       example: 5,400x1.05=5,670                                                                                                                                                                                                                                     Year 5                       900x12*100%                          10,800.00 300*12           3,600.00      14,400.00   Year 5

                                                                                                                                                                                                                                                                                     TOTAL                                                                                                      72,000.00
                                                                                                                                                                                                                                                                                                 ***Gross per year = balance per year multiplied by rate


Example 3:   Without Supplements                                                                                                                                                                                                                                                                           example: 54000*1.05=56,700

             Basic salary                                                        900

             life of the project                                              5 years

             supplement (fixed no increment)

             % increase per year                                                 5%

             percentage of time spent                                          100%
                                                                                                                                        Total to
                                                          Gross salary * months Gross per year***        Supplement per year          spread over   PERIODS
                                                                                                                                         years

             Year 1                                      900x12                              10,800.00                       -          10,800.00   Year 1

             Year 2                                      900x12x1.05                         11,340.00                       -          11,340.00   Year 2

             Year 3                                      900x12 x(1.05)^2                    11,907.00                       -          11,907.00   Year 3

             Year 4                                      900x12 x(1.05)^3                    12,502.35                       -          12,502.35   Year 4

             Year 5                                      900x12 x(1.05)^4                    13,127.47                       -          13,127.47   Year 5
             TOTAL                                                                           59,676.82                                  59,676.82



             ***Gross per year = balance per year multiplied by rate

                      example:      10,800x1.05=11,340                                                                                                                                                                                   -