|
|
|
|
|
|
|
|
|
|
Attachment C |
|
|
|
|
|
|
|
|
Actual |
|
|
|
|
|
|
|
|
2005 |
2006 |
2007 |
2008 |
2009 |
2010 |
2011 |
2012 |
2013 |
2014 |
|
|
|
|
|
|
|
Revenues |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
City - Employee |
5,287,932.00 |
5,678,536.00 |
6,005,611.00 |
6,321,793.00 |
6,369,977.36 |
7,246,945.96 |
7,571,408.56 |
6,801,560.05 |
7,042,571.49 |
6,715,767.46 |
|
|
|
|
|
|
|
City - Retiree |
|
|
|
|
|
|
|
657,000.00 |
657,000.00 |
1,000,000.00 |
|
|
|
|
|
|
|
Employee |
864,609.54 |
909,102.23 |
964,376.20 |
959,811.04 |
1,052,992.01 |
1,090,287.58 |
1,212,037.98 |
1,350,438.36 |
1,334,100.33 |
1,333,494.31 |
|
|
|
|
|
|
|
Retiree |
252,562.60 |
285,339.75 |
265,263.24 |
269,069.32 |
334,810.69 |
390,394.58 |
400,402.27 |
400,958.74 |
425,570.91 |
407,533.71 |
|
|
|
|
|
|
|
Interest - Employee/Retiree |
122,696.12 |
253,552.79 |
293,838.00 |
283,002.59 |
14,936.55 |
13,421.78 |
16,714.13 |
16,492.42 |
12,431.89 |
977.69 |
|
|
|
|
|
|
|
ERRP |
|
|
|
|
|
|
129,713.14 |
|
|
|
|
|
|
|
|
|
|
Total Revenues |
6,527,800.26 |
7,126,530.77 |
7,529,088.44 |
7,833,675.95 |
7,772,716.61 |
8,741,049.90 |
9,330,276.08 |
9,226,449.57 |
9,471,674.62 |
9,457,773.17 |
|
|
|
|
|
|
|
Expenses |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Claims - Employees |
4,377,650.54 |
5,024,471.39 |
6,082,168.73 |
6,715,784.55 |
7,371,877.61 |
7,099,333.91 |
7,024,139.67 |
6,531,404.74 |
6,996,878.46 |
7,173,248.37 |
|
|
|
|
|
|
|
Claims - Retirees |
|
|
|
|
|
|
|
486,167.40 |
953,389.00 |
1,082,287.00 |
|
|
|
|
|
|
|
Admin Charge - Employee |
173,390.69 |
162,852.15 |
192,487.90 |
234,478.51 |
254,926.83 |
391,106.95 |
482,331.17 |
306,540.96 |
391,809.61 |
332,654.42 |
|
|
|
|
|
|
|
Stop Loss Premium - Employee |
311,057.25 |
312,202.02 |
386,141.05 |
424,221.55 |
499,666.96 |
631,270.00 |
696,000.00 |
754,906.00 |
905,467.62 |
872,849.00 |
|
|
|
|
|
|
|
Admin Charge - Retiree |
|
|
|
|
|
|
|
27,801.57 |
29,651.68 |
84,097.00 |
|
|
|
|
|
|
|
Stop Loss Premium - Retiree |
|
|
|
|
|
|
|
58,470.00 |
68,932.38 |
60,037.00 |
|
|
|
|
|
|
|
Other Contractual Expenses |
0.00 |
0.00 |
10,501.36 |
0.00 |
81,745.12 |
48,548.40 |
60,842.90 |
50,000.00 |
50,000.00 |
46,182.00 |
|
|
|
|
|
|
|
Health &
Wellness/WellCare Clinic |
|
|
|
|
|
|
|
197,908.32 |
160,874.53 |
131,685.52 |
|
|
|
|
|
|
|
Total Expenses |
4,862,098.48 |
5,499,525.56 |
6,671,299.04 |
7,374,484.61 |
8,208,216.52 |
8,170,259.26 |
8,263,313.74 |
8,413,198.99 |
9,557,003.28 |
9,783,040.31 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
City Authorized FTEs |
767.89 |
798.25 |
827.67 |
818.92 |
809.17 |
812.67 |
796.67 |
796.00 |
804.00 |
810.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Income - Employee |
1,665,701.78 |
1,627,005.21 |
857,789.40 |
459,191.34 |
-435,499.91 |
570,790.64 |
1,066,962.34 |
327,730.81 |
-115,926.51 |
-506,379.85 |
|
|
|
|
|
|
|
Net Income - Retiree |
|
|
|
|
|
|
|
485,519.77 |
30,597.85 |
181,112.71 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Actual ending fund balance -
Employee |
4,587,423.78 |
6,214,428.99 |
7,072,218.39 |
7,531,409.73 |
7,095,909.82 |
7,666,700.46 |
8,713,711.87 |
8,789,326.76 |
8,679,541.09 |
8,173,161.24 |
|
|
|
|
|
|
|
Actual ending fund balance -
Retiree |
|
|
|
|
|
|
|
737,635.69 |
768,233.54 |
949,346.25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Percent change |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Revenues |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
City |
9.50% |
7.39% |
5.76% |
5.26% |
0.76% |
13.77% |
4.48% |
-1.49% |
13.20% |
9.56% |
|
|
|
|
|
|
|
Employee |
1.72% |
5.15% |
6.08% |
-0.47% |
9.71% |
3.54% |
11.17% |
11.42% |
-1.21% |
-0.05% |
|
|
|
|
|
|
|
Retiree |
-0.23% |
12.98% |
-7.04% |
1.43% |
24.43% |
16.60% |
2.56% |
0.14% |
6.14% |
-4.24% |
|
|
|
|
|
|
|
Interest |
262.37% |
106.65% |
15.89% |
-3.69% |
-94.72% |
-10.14% |
24.53% |
-1.33% |
-24.62% |
-92.14% |
|
|
|
|
|
|
|
ERRP |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Revenues |
9.42% |
9.17% |
5.65% |
4.05% |
-0.78% |
12.46% |
6.74% |
-1.11% |
2.66% |
-0.15% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Expenses |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Claims - Employees/Retirees |
0.37% |
14.78% |
21.05% |
10.42% |
9.77% |
-3.70% |
-1.06% |
-0.09% |
13.29% |
3.84% |
|
|
|
|
|
|
|
Admin Charge -
Employee/Retiree |
-11.47% |
-6.08% |
18.20% |
21.81% |
8.72% |
53.42% |
23.32% |
-30.68% |
26.06% |
-1.12% |
|
|
|
|
|
|
|
Stop Loss Premium -
Employee/Retiree |
-35.15% |
0.37% |
23.68% |
9.86% |
17.78% |
26.34% |
10.25% |
16.86% |
19.80% |
-4.26% |
|
|
|
|
|
|
|
Other Contractual Expenses |
|
|
|
|
|
-40.61% |
25.32% |
-17.82% |
0.00% |
-7.64% |
|
|
|
|
|
|
|
Health &
Wellness/WellCare Clinic |
|
|
|
|
|
|
|
100.00% |
-18.71% |
-18.14% |
|
|
|
|
|
|
|
Total Expenses |
-3.47% |
13.11% |
21.31% |
10.54% |
11.31% |
-0.46% |
1.14% |
1.81% |
13.60% |
2.37% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Actual ending fund balance |
57.01% |
35.47% |
13.80% |
6.49% |
-5.78% |
8.04% |
13.66% |
9.33% |
-0.84% |
-3.57% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|