485 Worksheet by wbg10392

VIEWS: 64 PAGES: 7

More Info
									                                                                     Estimated Payroll and Health Insurance

                                                                                      Classified
Grade      Step      Wage      Fica     Medicare   Wrks. Comp Package Type              Package
VIII                1 $4,080.17 $252.97     $59.16        $8.57 Employee+Family           $960.00



                                                                                       Faculty
Grade      Step      Wage      Fica     Medicare   Wrks. Comp Package Type              Package
Dept Chair Step 1     $6,447.25 $399.73     $93.49       $13.54 Employee+Family         $1,143.00



                                                                                       Exempt
Grade      Step      Wage      Fica     Medicare   Wrks. Comp Package Type              Package
Grade 19          18 $10,737.57 $665.73    $155.69       $22.55 Employee+Family         $1,143.00




  Input Fields         *These are the fields that need to be populated
Automated Fields           *These fields will be populated for you
 Answer Fields          *These fields yield the summation of the cost
and Health Insurance Costs

Classified
             PERS Plan            PERS        PERS Reserves Monthly Cost    Yearly Cost
             Member before 1/1/04     $295.81        $326.41      $5,983.10    $71,797.22



 Faculty
             PERS Plan            PERS        PERS Reserves Monthly Cost    Yearly Cost
             Member before 1/1/04     $467.43        $515.78      $9,080.21   $108,962.51



 Exempt
             PERS Plan            PERS        PERS Reserves Monthly Cost    Yearly Cost
             Member before 1/1/04     $778.47        $859.01     $14,362.02   $172,344.29
CLASSIFIED SALARY SCHEDULE:

STEP                      1              2              3              4              5             6             7             8
CLASS
        Xt         5,415.33       5,572.38       5,733.98       5,900.26       6,071.37      6,247.44      6,428.61      6,615.04
       IXt         4,835.11       4,975.33       5,119.62       5,268.08       5,420.86      5,578.06      5,739.83      5,906.28
        IX         4,651.39       4,786.28       4,925.09       5,067.91       5,214.88      5,366.11      5,521.73      5,681.86
      VIIIt        4,316.82       4,442.01       4,570.83       4,703.38       4,839.78      4,980.14      5,124.56      5,273.17
      VIII         4,080.17       4,198.50       4,320.26       4,445.54       4,574.46      4,707.12      4,843.63      4,984.09
      VIIt         3,768.79       3,878.09       3,990.55       4,106.28       4,225.36      4,347.90      4,473.98      4,603.73
       VII         3,579.10       3,682.90       3,789.70       3,899.60       4,012.69      4,129.06      4,248.80      4,372.01
       Vit         3,447.55       3,547.53       3,650.40       3,756.27       3,865.20      3,977.29      4,092.63      4,211.32
        VI         3,139.56       3,230.60       3,324.29       3,420.70       3,519.90      3,621.97      3,727.01      3,835.09
        Vt         3,096.05       3,185.84       3,278.22       3,373.29       3,471.12      3,571.78      3,675.36      3,781.95
         V         2,754.00       2,833.87       2,916.05       3,000.62       3,087.63      3,177.17      3,269.31      3,364.12
        IV         2,415.79       2,485.85       2,557.93       2,632.11       2,708.45      2,786.99      2,867.81      2,950.98
        III        2,119.12       2,180.57       2,243.81       2,308.88       2,375.84      2,444.73      2,515.63      2,588.59
         II        1,858.87       1,912.78       1,968.25       2,025.33       2,084.06      2,144.50      2,206.69      2,270.68
          I        1,630.58       1,677.87       1,726.53       1,776.60       1,828.12      1,881.13      1,935.69      1,991.82

FACULTY SALARY SCHEDULE:

                        0              1              2              3              4
Regular            6362.5         6065.5        5303.75        4454.33        4030.17
Dept. Chair       6744.25        6447.25         5685.5        4836.08        4411.92

EXEMPT SALARY SCHEDULE:

                          1              2              3              4              5             6             7             8
         6    $     3,795.85 $     3,860.38 $     3,926.00 $     3,992.75 $     4,060.62 $    4,129.65 $    4,199.86 $    4,271.26
         7    $     4,102.79 $     4,172.54 $     4,243.47 $     4,315.61 $     4,388.97 $    4,463.59 $    4,539.47 $    4,616.64
         8    $     4,435.45 $     4,510.85 $     4,587.54 $     4,665.53 $     4,744.84 $    4,825.50 $    4,907.54 $    4,990.96
         9    $     4,793.71 $     4,875.20 $     4,958.08 $     5,042.37 $     5,128.09 $    5,215.27 $    5,303.93 $    5,394.09
        10    $     5,183.24 $     5,271.35 $     5,360.96 $     5,452.10 $     5,544.79 $    5,639.05 $    5,734.91 $    5,832.41
        11    $     5,457.30 $     5,550.07 $     5,644.42 $     5,740.38 $     5,837.96 $    5,937.21 $    6,038.14 $    6,140.79
        12    $     5,746.64 $     5,844.33 $     5,943.68 $     6,044.73 $     6,147.49 $    6,251.99 $    6,358.28 $    6,466.37
        13    $     6,048.42 $     6,151.24 $     6,255.81 $     6,362.16 $     6,470.32 $    6,580.31 $    6,692.18 $    6,805.95
        14    $     6,372.64 $     6,480.97 $     6,591.15 $     6,703.20 $     6,817.15 $    6,933.04 $    7,050.91 $    7,170.77
        15    $     6,709.23 $     6,823.29 $     6,939.29 $     7,057.26 $     7,177.23 $    7,299.24 $    7,423.33 $    7,549.53
        16    $     7,065.11 $     7,185.21 $     7,307.36 $     7,431.59 $     7,557.93 $    7,686.41 $    7,817.08 $    7,949.97
        17    $     7,383.33 $     7,508.85 $     7,636.50 $     7,766.32 $     7,898.34 $    8,032.62 $    8,169.17 $    8,308.05
        18    $     7,715.09 $     7,846.25 $     7,979.63 $     8,115.29 $     8,253.25 $    8,393.55 $    8,536.24 $    8,681.36
        19    $     8,062.13 $     8,199.19 $     8,338.57 $     8,480.33 $     8,624.50 $    8,771.11 $    8,920.22 $    9,071.86




     Classified                                      Faculty
Grade     Value                              Grade      Value
I       15   Grade 19   14   19   14
II      14   Grade 18   13   18   13
III     13   Grade 17   12   17   12
IV      12   Grade 16   11   16   11
V       11   Grade 15   10   15   10
Vt      10   Grade 14    9   14    9
VI       9   Grade 13    8   13    8
Vit      8   Grade 12    7   12    7
VII      7   Grade 11    6   11    6
VIIt     6   Grade 10    5   10    5
VIII     5   Grade 9     4    9    4
VIIIt    4   Grade 8     3    8    3
IX       3   Grade 7     2    7    2
IXt      2   Grade 6     1    6    1
Xt       1
           9           10            11            12            13            14            15

    6,806.88      7,004.28      7,207.40      7,416.42      7,631.50      7,852.81      8,080.54
    6,077.57      6,253.81      6,435.18      6,621.80      6,813.83      7,011.43      7,214.76
    5,846.64      6,016.19      6,190.66      6,370.19      6,554.92      6,745.01      6,940.62
    5,426.09      5,583.45      5,745.37      5,911.99      6,083.43      6,259.85      6,441.39
    5,128.63      5,277.36      5,430.41      5,587.89      5,749.94      5,916.69      6,088.27
    4,737.24      4,874.62      5,015.98      5,161.45      5,311.13      5,465.15      5,623.64
    4,498.80      4,629.27      4,763.52      4,901.66      5,043.81      5,190.08      5,340.59
    4,333.44      4,459.11      4,588.43      4,721.49      4,858.42      4,999.31      5,144.29
    3,946.31      4,060.75      4,178.52      4,299.69      4,424.38      4,552.69      4,684.72
    3,891.62      4,004.48      4,120.61      4,240.11      4,363.07      4,489.60      4,619.80
    3,461.68      3,562.07      3,665.37      3,771.67      3,881.05      3,993.60      4,109.41
    3,036.56      3,124.62      3,215.23      3,308.47      3,404.42      3,503.15      3,604.74
    2,663.65      2,740.90      2,820.39      2,902.18      2,986.34      3,072.94      3,162.06
    2,336.53      2,404.29      2,474.02      2,545.76      2,619.59      2,695.56      2,773.73
    2,049.58      2,109.02      2,170.18      2,233.12      2,297.88      2,364.52      2,433.09




           9           10            11            12            13            14            15            16            17
$    4,343.87 $    4,417.71 $    4,492.81 $    4,569.19 $    4,646.87 $    4,725.86 $    4,806.20 $   4,887.91 $     4,971.00
$    4,695.12 $    4,774.94 $    4,856.11 $    4,938.66 $    5,022.62 $    5,108.01 $    5,194.84 $   5,283.16 $     5,372.97
$    5,075.81 $    5,162.10 $    5,249.86 $    5,339.10 $    5,429.87 $    5,522.18 $    5,616.05 $   5,711.53 $     5,808.62
$    5,485.79 $    5,579.05 $    5,673.90 $    5,770.35 $    5,868.45 $    5,968.21 $    6,069.67 $   6,172.86 $     6,277.79
$    5,931.56 $    6,032.39 $    6,134.94 $    6,239.24 $    6,345.30 $    6,453.17 $    6,562.88 $   6,674.45 $     6,787.91
$    6,245.18 $    6,351.35 $    6,459.32 $    6,569.13 $    6,680.81 $    6,794.38 $    6,909.89 $   7,027.35 $     7,146.82
$    6,576.30 $    6,688.09 $    6,801.79 $    6,917.42 $    7,035.02 $    7,154.61 $    7,276.24 $   7,399.94 $     7,525.74
$    6,921.65 $    7,039.32 $    7,158.98 $    7,280.69 $    7,404.46 $    7,530.34 $    7,658.35 $   7,788.54 $     7,920.95
$    7,292.68 $    7,416.65 $    7,542.73 $    7,670.96 $    7,801.37 $    7,933.99 $    8,068.87 $   8,206.04 $     8,345.54
$    7,677.87 $    7,808.39 $    7,941.13 $    8,076.13 $    8,213.43 $    8,353.06 $    8,495.06 $   8,639.47 $     8,786.34
$    8,085.12 $    8,222.57 $    8,362.35 $    8,504.51 $    8,649.09 $    8,796.12 $    8,945.65 $   9,097.73 $     9,252.39
$    8,449.28 $    8,592.92 $    8,739.00 $    8,887.56 $    9,038.65 $    9,192.31 $    9,348.58 $   9,507.50 $     9,669.13
$    8,828.94 $    8,979.03 $    9,131.68 $    9,286.92 $    9,444.79 $    9,605.36 $    9,768.65 $   9,934.71 $    10,103.60
$    9,226.09 $    9,382.93 $    9,542.44 $    9,704.66 $    9,869.64 $   10,037.42 $   10,208.06 $   10,381.60 $   10,558.08
         18
$    5,055.51
$    5,464.31
$    5,907.37
$    6,384.52
$    6,903.31
$    7,268.32
$    7,653.67
$    8,055.60
$    8,487.42
$    8,935.71
$    9,409.68
$    9,833.51
$   10,275.37
$   10,737.57

								
To top