Salary And Benefit Schedule Template

SALARY AND BENEFIT SCHEDULE

Recharge Activity:____________________

Template 4

"C" Packet

(Formulas are embedded in form)

This template should identify the calculation of the total employee or position salary costs that are included in Template 2 - the Comparative Income Statement ("C" Packet).

The total of column F on this shet should provide the basis for salary costs shown on Template 2- the Comparative Income Statement ("C") Packet. The total for column

H should provide the basis for the employee benefit costs shown on Template 2 - the Comparative Income Statement ("C" Packet).

TOTAL Salary &

Benefit Calculations

Benefits

Current Salary Calculations

Merit Calculations

Salary Total

G

H

I

A

B

C

D

E

F

Total Benefits

Portion of FTE

Recharged

Rate Times

Devoted To

Projected Merit

Total Salary

FTE/% times

Actual or

Salary Charged

TOTAL Salary &

Recharge Activity

and/or Range

Calculations

Estimated

to Recharge

Benefit Costs

Annual Salary

Employee Name or

Current Annual

(May be % or

Amount

(Column D + Column

Benefit Rate

Activity (Column

(Column F +

(Column B times

(2)

F x Column G)

Column H)

Position Title

Salary

FTE)

(1)

E)

Column C)

2001-2002

0

0%

0

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

0

0

0

0

0

0

#VALUE!

Total

2002-2003

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

0

0

0

0

0

0

#VALUE!

Total

(1) Use the following for merit projections for 2001-02 and 2002-03

For MSP & PPS grade based staff, use 5% target control point effective 10/1/2001 and 2002.

For step based represented, use 4.50% target point effective date in accord with negotiated agreements.

For all step based staff, project a 4% range adjustment effective 10/1/2001 and 2002 contingent on bargaining.

(2) For the benefits rates, please use actual current benefit rates as a percentage of salary.