HomeMy WebLinkAbout2002 08 28 Other - Outstanding Budget Issues
"
. , . t.
City of Winter Springs .
Memo
To: Mayor and City Commission
From: Ron McLemore
Date: 08/28/02
Re: Outstanding Budget Issues
The following represents a list of the outstanding budget issues ranked in descending order of priority
(first things first).
. ..1 have provided you with a brief synopsis of each of the issues as well as my recommendation.
Attached you will find additional supporting information regarding a few of the more involved issues as
well as an updated Commission Alternative Worksheet that lists each of the items under consideration
and the corresponding cost translated into mils.
OUTSTANDING BUDGET ISSUES FOR COMMISSION DISCUSSION AND DIRECTION '
--J Health Insurance
Discussion - The costs of health insurance have skyrocketed in the past couple of years. The
Commission buffered that full increase in cost in FY 02 to benefit our employees; however, faced
with continuing increases in the cost of this benefit, I feel it prudent to move towards a less rich
plan.
Recommendation - I am recommending that the Commission elect for FY 03 HMO Plan #7502B
with Funding Option #3.
--J Cody Alternative #2 or #3
Discussion - Cody Alternative #1 adjusts the salaries of the employees who fall below the
minimum of the pay grade to the minimum. Cody Alternative #1 is already included in the FY 03 .
Preliminary Budget. Cody A1temative #2 adjusts the salaries of the employees who fall at or up to
1 % over' the recommended minimum and who have one or more years in grade to a level up to 3%
above the recommended minimum. Cody A1temative #2 represents an additional cost of $79,029.
Cody A1temative #3 adjusts the employees into their recommended pay range according to the
number of years "in grade". No one, no mater how many years in grade would be advanced
further than the mid-point of their appropriate salary range. Approximately 118 employees would
receive salary increases under Cody Alternative #3. Cody Alternative #3 represents an additional
cost above and beyond Alternative #2 of $28,800 or a total of $1 07,829.
. Page 1
Recommendation - In light of the approach I feel the City will need to begin to take in regards to
health insurance, I think it is prudent to implement Cody Alternative #3 in an effort to pay our
employees a fair and equitable market salary. The cost of implementing Cody Altemative #3 is
$107,829 above the FY 03 Preliminary Budget as previously presented. I feel an increase in the
millage rate would be necessary to fund this option, as it is an on-going operating cost.
-v 2 Maintenance Personnel in Parks Mid-Year
Discussion - In light of the increased maintenance workload associated with bringing the Parker
property on line, I feel it is necessary to hire 2 FT Maintenance Workers in an effort to maintain our
Fields of Excellence. Given the time frame of events, these employees should be hired at mid-
year.
Recommendation - I recommend hiring 2 FT Maintenance Workers in the Parks Department at
mid-year at a cost of $25,300 fully loaded. I feel an increase in the millage rate would be necessary
to fund this option, as it is an on-going operating cost.
"j Information Technology Upgrade Year 1
Discussion - The City hired the League to conduct an IT Strategic Plan. This plan has been
presented to the Commission. The costs to fund this plan in FY 03 only are $290,350 and
represent both operating and capital costs in the amount of $209,350 and $81,000 respectively.
Note that this does not include Mobile Police Units discussed below.
Recommendation - I recommend funding Year 1 of the IT plan. Looking out, it appears that
approximately $100,000 per year will be the increase in annual operating costs related to this
upgrade. Therefore, I feel an increase in the millage rate would be necessary for the $100,000
increase in on-going operating costs; whereas the $190,350 in Year 1 could be funded by way of
fund balance.
x Mobile Police Units
Discussion - While I recognize the benefits provided by this additional level of technology, I feel it is
prudent to search for grant opportunities to fund this acquisition as it appears there may other
funding alternatives. The IT plan calls for $299,211 in mobile police units in year 1 and $198,942 in
year 2.
Recommendation - I recommend that the City hold off funding the mobile police units in FY 03 in .
light of possible grant opportunities. I recommend the City revisit this issue at a later point in time if
other funding options do not come to fruition.
x 8 COPS Grant Officers
Discussion - The Police Department is requesting 8 FT COPS Grant Officers in FY 03. These
grants are funded at 75% for 4 years. The cost in FY 03 would be $76,800 to the General Fund.
This amount represents 25% of the personnel costs alone.
Recommendation - Given that the City just added two FT Police Officers this past April 02, I
recommend holding off on additional hiring at this time for the Police Department. The full effect of
the contribution provided by the newly hired officers should be realized during the year. If the
officers are added, they could be added at mid-year.
. Page 2
x 1 Data Entry Clerk in Fire Department
Discussion - The Fire Department is requesting 1 FT Data Entry Clerk in FY 03. The cost for this
position is projected to be $27,200.
Recommendation - I do not recommend hiring additional clerical assistance at this time in the Fire
Department. .
x Creation of Fire Department Satellite Office
Discussion - The Commission has previously discussed the possibility of creating a Fire
Department Satellite Office at City Hall in the Sally Port and Jail Cell area. The FY 03 cost for this
budget consideration is $471,443. This amount includes the costs of 8 personnel, and related
equipment, vehicles and operating expenses.
Recommendation - Given our First Response Arrangements and volume of activity, I do not feel it
is necessary to undertake this endeavor at this point in time. In the future, as build-out occurs in
this area of the City, I feel it would be prudent to consider the addition of a fire station. If the
Commission elects to budget this item, I recommend bringing the firefighters on board at mid-year
and funding the vehicle and equipment out of impact fees. .
x 1 Athletic Coordinator
Discussion - The P& R Department is requesting 1 FT Athletic Coordinator in FY 03. The cost for
this position is projected to be $29,700.
Recommendation - I do not recommend hiring an Athletic Coordinator at this time.
x 1 PT Sports Monitor
Discussion - The P& R Department is requesting 1 PT Sports Monitor in FY 03. The cost for this
position is projected to be $8,200.
Recommendation - I do not recommend hiring a Sports Monitor at this time.
x Concession Stand
Discussion - Attached y~u will find profonna's associated with the turn over of the stands to' the
Leagues. .
Recommendation - Based upon my analysis of the situation I do not see the advantage of
changing our current approach to the City's management of the stands.
. Page 3
~.
Ll/
C)
Cl I-
-, w
al ~
~: ~
...: c::
Zo
~~
::iUl
UI w
Ullr.>
C) ~. i=
z ~: <(
ii::;;; ~
a.. (\1 w
U) CI t-
o:: Ct..J
W'" <
I-cx:Z
~~Q
~>-~
lL-I_
O<::E
>-O::E
I-UlO
U ;;::0
Q;
.g>
'"
CO
~
'"
.S;
.~
e!
n.
....
'"
n.
'"
'"
'"
c:
'"
~
LU
<;;
~
~
o;t
.~
C5
EO
.'!!
<(
-S
o
u
CO")
o;t
.~
C5
EO
'"
~
-S
o
u
....
'" ....
~.s
o '"
s.S; ....
Q)~g
<> 0 c:
l~~!
:S.'!!15
~~c%
............
u..u..n.
~--
&]
~
.'!!
u
.s
tti
~
'"
Q
....
u..
-
c;;-
'"
~c;;-
.... - '"
:gQ) ~~
"'~ ~ 13
I:::! 0 '- '"
::: '" ~ ~
0"'" '-
__"" "t)~
Q)~ {g:s.
~ '" c:"t)
Oll) .2{g
.... .......c:
CD .E Q)::'
~Q)Q)~~
]!:g~0'"
&'l ~O '" ~
l... I~ ~ ~ 0
.2l.U:S;~~
~ .~ ~ ~ ~
~1OCI)\""1b
~::5w....~CI)
~Q.J2-l...
eo", ~ ~
it<;;~EO.'!!
ti: ~ g .~~
cx>~:5tZ~
....
'"
~
~
:0-
.EO
&!
"*
~
~
~
'"
<>
liO
o
c:
l'?
(.!)
lI)
n.
o
u
....
u..
iCX>
:;::-
c:
l'?
Ol
o
c:
....
e
~
"t)
{g
c:
~
'"
'"
c:
o
it
'"
.~
&
,9l
.0
~
CO")
c:
.\2
g
CO
~
C>
~
....
~
"t)
'"
"t)
'"
'"
c:
'b
"t)
">::
'"
<>
c:
l'?
'"
'"
~
oS
<;;
'"
J:
~Ol
s,s
"t) l'?
'" '"
"t) Q.
c:o
@.c:n
- .S;
'" 0
""9'
fil'c:
uo
- -
g:g:
{g{g
~ ~
0l0l
gg
0l0l
.~ .~
'_ CI) CI)
'" '"
<> <>
e e
n.n.
'" '"
mC5
QQ
'"
Ol
'"
""
~
"t)
e
'S
0-
'"
a::
~ ~ 0 0> 0 0
0 N 0 0
c: CO. 0 CO C")
'" '- 0 oi cO .n
~Cii :':::C\I N r- N N
c: EO g N '" '" '"
'" '" .n
:E"'"
">:: '"
~ ~ 0 0> 0 0
0 N 0 0
c: ~ 0 CO C")
'" '- .0 oi cO .n
~15 g- N r- N N
c: EO N '" '" '"
~~ .n
<l: '"
0> 0
'" 0 N 0 000
!1: 0 0 CO 000
~ oi cO C") r- N
- ll'ia>ai
'" r- N
EO N '" '" NN'"
N '" '"
'" .n
"'"
">::1 '"
.!!! CO 0 <J:) ~~J:lo
0 It) C")
.Q '" r- <J:) N NNO
'" Ol t- O 0 000
<> '" M 0 0 000
&~
<l:
0
0
0
0
N
'"
=
0 ::J:OO<J:)OO 0 0
0 OMNOO 0 0
N Neomo N "" N 0
,..: ~ci<ti,....-Lt'i 0 cO oi 0
N m............MNCO C") 0> N
'" ...... tJI't tJ") fh tJ") N '" N '"
'" '" '"
"" C")NN r- <J:) ..,.
N ......CO('l")Q)Q)CO ;;; '" <J:)
N lOO......C)C)r--- Ol ;;
0 ~C!qrom""': 0 ~
0 000:::::::==0 0 0
E E 'E
o 0 0
c c c
N
",N
OlCO
",0
~o
o
c
00
It) 0
C") 0
00
0> 0
'" '"
o
o
o
o
o
'"
C")
o
N
N
0>
<J:)
.n
'"
0>
N
0>
.q:
r-
""
.n
'"
o
0>
cO
""
C")
cD
'"
..,.
N
""
N
'<i
o
o
o
o
o
'"
;;l;
cD
;;;
..,.
N
..,.
N
'<i
<J:)
<0
r-
0>
M
0;
'"
~
~
'"
~
'"
c:
....
o
'"
~
.S;
"t)
'"
'"
'"
'"
.Q
~
o
<>
'"
.~
l:::
!1:
o
<;;
c:
,g
:g
'"
~
....
'"
:t:
u
e
it
"t)
c:
'"
'"
.~
&
'"
~
Q;
~
~
.'!!
.:::
Ol
~~
ou..
u""
.... ....
o 0
'" '"
~~
.5; .5;
........
00
~~
">::<l:
o ~
0>0
""It)
00
ca
Nit)
0> ~
It) 0>
me
It) <J:)
'" '"
,,"00
,,"OC")
N 00
"':ciu5
0> ~ ~
~ '" '"
'"
o
o
o
o
N
'"
I!.~;.~; "'-,;,',' . r.:> '. '-r:"j'OT' ,
r.!:.,<:: 3l.~ '" ..." g. "IN." ,..8
.~,' ~~J:::/.~:;., c:: ,~':~ co 'I, "Q ~', ,co
s' ,"" "Ht! 0 .., ., .-. '10;' . 1..>.-
I!:,t !1:~ 1 :;i'\l:~~{~'
...1 l 3l;~' { ;. . .g
..~i ~:.<:'" 'a ,~,', 'cO
e'E:~b .::,."'1,::......:.
f;~^" 'i~ ~.
~~; :S ~:(; t:
~s; . Q) VJ~1 J - ,0
.S.~.~1J~.. -
01 .....'~. .
~ <(~";,'
,c:'", .en
~; .~.'.~'~
~~, ~.~{:.'" .~
~; .S~: '.'Q..
0' ~.~l '. 0
Q';l:'~~\
. " \ ,- ""',l -~'-
I,g.',~:~~~ :
~,,s;'~1) .t::
EO" "'. ih. . ,e' ;
:EOS . ~?l Q.. "";
9: ~ ~l:}(.. 'Q
~F'<l: ,tl'
, . "':;r~
,5"'~'~:::'
~,; ,s;3l::.. t:
...... (Q ,.c::l ~ '0
,~tE,,'~j~' ~,\')
."".."'0' 0
.(3: ~'~;j .
2,g'8
~..~'N
,!G" gf.:~
"".""
~'
,..:
N
""
::tggg~
NOO" .
~OtO ,"
0)....- "r
~tI),,~,
<h' .
O' 0
~"" .,.
~
'1:,
g
o
~
.'"
~gll3.
01 f"o.
8' g
,~ t--
.,. -
It)
.,.
C")
r-
It)
'<i
..,.
N
....
N
'<i
;,~,
-.
..~ &
City of Winter Springs
Memo
To: Mayor and City Commission
From: Ron McLemore
Date: 08/28/02
Re: Health Insurance Recommendation
Based upon my analysis, I am recommending that we chose Health Plan
7502(Rx4)B and that we maintain the current cost sharing %'s. This will, result in a
26% increase or $190,665 a year for the City over our current plan. .
The FY 03 Preliminary Budget presented to you includes $170,000 of this increase. The selection of
this particular plan will require an additional $20,665 to be budget for City health insurance expense.
The Finance Department has provided an alternative in which the cost sharing would be amended to
reduce the City's share of the dependent coverage from the current cost sharing arrangement to' an
across the board 50/50 of the total premium cost sharing arrangement for those employees with
dependent care coverage. This altemative will result in a reduction of FY 03 preliminary budgeted City
health expense of about $17,000. This will result in a 21 % increase or $152,924 a year for the City over
our current plan.
City Pays:
Current Cost Sharinq
50/50 Cost Sharinq
Employee
100% of total premium
100% of total premium
Employee + Spouse
58.63% of total premium
50% of total premium
Employee + Child
58.54% of total premium
50% of total premium
Employee + Family
55.79% of total premium
50% of total premium
. Page 1
i ~~
\.~\ -
City of Winter Springs
, I
Memo
To: Mayor and City Commission
From: Ron W. McLemore
Date: 08/28/02
Re: Budget Workshop - Health Insurance
At our last budget workshop, the Commission requested additional information regarding health
insurance in an effort to assist them in the decision making process.
The following sUNeys/schedules/analysis were requested:
1) SCHEDULE A = % of Benefits (Health/Life/Disability/Pension) to Total Payroll for the Seminole
County sister cities.
2) SCHEDULE B + C = Copy of Calno Health Insurance sUNey.
3) SCHEDULE D + E = Health costs to Payroll for the last 5 years for the City of Winter Springs. Note
that "Total Budget" varies widely from year to year due to capital expenditures; hence 'Total
Payroll" was used in place of 'Total Budget" for analysis purposes.
4) SCHEDULES F = Cost of Health Insurance to Employee Payroll by different Payroll grades. Note
that Finance Department used Plan 7502B Funding Option 4 as an example. However, CM is
recommending Funding Option 3.
5) SCHEDULE G = $ Impact on premium if City self-insured the hospital co-pay. NOT YET
AVAILABLE - FLUFFY STILL WORKING ON IT.
In addition, I have included the full health insurance packet distributed at our last budget workshop.
. Page 1
CITY OF WINTER SPRINGS
SURVEY OF SEMINOLE COUNTY CITIES BENEFITS TO PAYROLL
A
FY02 FY02 FY02 FY02 FY03 FY03 FY03 FY 03
Final Final Final Final Tentative Tentative Tentative Tentative
Budget Budget Budget Budget Budget Budget Budget Budget
Total Total % Total Total Total % Total
Benefits Payroll Benefits to Total Benefits Payroll Benefits to Total
Citywide Citywide Payroll Citywide Citywide Citywide Payroll Citywide
Longwood $ 1,700,040 $ 5,909,900 28.77% $ 18,157.430 $ 1,784,420 $ 6,202,815 28.77% $ 20,254,900
Lake Mary $ 958,978 $ 6,021,069 15.93% $ 24,228,541 $ 1,217,588 $ 6,279,394 19.39% $ 30,219,327
Winter Springs $ 1.482.400 $ 8,570,600 17 .30% $ 44,197,171 $ 1,713,775 * $ 9,230,500 18.57% $ .39,264,058
Oviedo $ 1,329,927 $ 11.231,887 11.84% $ 62.135.693 $ 1,563,541 $ 12.380,894 12.63% $ 38,586,788
Sanford $ 3,007,543 $ 15.261,135 19.71% $ 79.379,669 $ 3.187,534 $ 15.706,375 20.29% $ 50,229,472
Altamonte Spring $ 5,127,002 $ 20.240,551 25.33% $ 69,820,897 $ 4,783,973 $ 17,385,498 27.52% $ 69,207,910
Casselberry No Response
Average 19.81% 21.19%
*=Includes only $905,000 for health insurance. Plan and Funding Option still TBD.
Note that other personnel costs such as FICA and Workman's Camp are not included in analysis.
"Benefits" represent health, life, disability and retirement.
r:
:,~
~ \1/'-1;
..am '.:>- ~tP
~'i. 0b 1. \
CttNO INSURANCE SURV~Y~JU""~
~ ~.,/
. \\~
'f<.
~~J
-'1" .---~
~SSEtJi~
~~~
\
f?1 /
/;] , . .
/ 1\( '-'iA'v;;-kdJ
~AKE MABY.-J
L,()
1-, ./
'9.>..1;
G~NG~~
Cf1?
$~?J 2-1
~
5tiJ21
33c-~
~e
HEALTH CIGNA - .- HUM.1.NA (GATEKEEPER) BLUE CROSS/BLUE SHIELD C~(GATEKEEPEFf) ~~.,
- - . ,
-:' '\ ;':~~ POS ( -HMO) (3) ( /HMV Ii ( HMO~
RATE/TYPE ,.. HMO ;~ POS IIMOIA POS ELECT CARE POS
\ __/(f) I -.--..-... - r -
SINGLE ~~' 222.67 294.26 273.64 389.28 _-1~, 1" 2~<)'i1- 248.21 ;WO.09 I: 256.30 307.50
. . ') ~58 287.55
( . l~ i
.' l. !63.90 197.10
SPOUSE r\~ c- 253.87 288.38 268.IS 517.76 - j - 244.01 281.05 200.13 1\
, I 2'1.58 i I l .~
CHILDREN po ~ c' \ " 213.54 250.14 232.62 451.56 I - - 199.53 229.11 200.13 150.30 180.20
,~f..' ).. (, " I 432.84 ~. !l[> ! I
FAMILY 449.13 479.64 446.04 875.88 493.29 571.77 360.23 I 305.20 366.20
. ~ ~
I c::~;) .:,1.,> 1 f)4>S,'1'f f
CITY PA YS(EMP) yes, up to yes, up to yes, up to yes, up to yes, up to je , up to yes, up to 268.00/ yes, up to yes, up to
hmo amt hmoamt 269.26 269.26 269.26 hmo amtj hmo amt MONTH. I hmo arnt hmo amt
I CITY PAYS (OEP) no no yes/S60 yes/S60 yes/S30 no I no no/55% 00/55% See Above. 1 55% 55%
HOW LONG W/ -._------- ; M________ 3 years 3 years 3 years ---------- ! ______om ----------- --------- 3 years I: I 3 years 3 years
PROVIDER I I
BENEFfTS ! I I
i I
I I 15.00 I
OFFICE: REG 15.00 15.00 10.00 10.00 10.00 15.00 i 15.00 15.00 5.00 10.00 15.00
PREVENTIVE 0 0 10.00 10.00 10.00 '1 I 15.00 i5.00
15.00 . 15.00 0 0 lO.OO
SPECiALIST I 25.00 I 15.00 20.00 20.00 20.00 25.00 125'.00 35.00 5.00 20.00 I 25.00 25.00
I
I SURG PROCEDURE I '}.25.00 I
I 0 0 ' 20.00 20.00 20.00 25.00 0 0 20.00 O. 0
HOSPlT AL- 500.00 500.00 300.00 300.00 300.00 IOO/day , IOO/day 150.00 0 0 I 500.00 0
j.
INP.-\. TIEl'll' I
.!.
OUTPATIENT 50.00 50.00 150.00 150.00 150.00 0 0 0 I 0 250.00 Ii 0 0
I . !
I .
:
SURG CARE iOO.OO I eo.oo 0 0 0 0 0 0 0 125.00 0 0
, I
ER ' 50.00 50.00 75.00 75.00 75.00 50.00 . ! SO.OO 0 0 75.00 100.00 0
1 I
RX 15/25/35 15/25/35 7/15/35 7//5/35 7/15/35 5/20 J 5/20 15/30/50 15/30/50 10/20 15/20/35 15/20/35
., I
MAX OUT OF 1,500/ 1,500/ 1,500/ 1,500/ 1,500/ 1,500/ ""\1 500/ 0/0 0/0 1,500/ 1,500/ 1,500/
.' ,
POCKET 3,000 3,000 3,000 3,000 3,000 3,000 I 3,000 3,000 3,000 3,000
i I
RETIRED EMP COY YES/ YES/ YES YES YES NO I NO YES/ YES/ 'YES YES/ YES/
, I.
EMP EMP EMP EMP EMP EMP
PAID PAID j. PAID PAID I' PAID PAID
I
. .
<SAl~I..QJ.ill_-:~
{.
9
RATE/TYPE
SINGLE
I SPOUSE
I CHILDREN -~.._~
FAMILY
I CITY PA YS (EMP)
I
I
'------
,
, CITY FAYS (DEP)
!
I HOW LONG WI.
PROVIDER
BENEFITS
OFFICE: REG
PREVENTiVE
SPECIALIST
I SURGPROCEDURE
I HOS;;~L~:"ATlENT
o lrrPATIENT
--. ----
SURG CA.1ffi
--........--
ER
RX
MAX OUT OF
POCKET
RETIRED EMP COV
"
.';..
SEMINOLE
COUNTY (UNITED)
HMO POS
234.79 348.89
275.67 254.91
254.64 211.67
538.58 569.31
yes, up to yes, up to
hmo hmo
amount amount
73/74/65 69170/63
% %
I 5 years 5 years
o
15.00 15.00
o
25.00
100.00
250.00
100.00
100.00
100.00
$10115/25
$1,5000/
$3,000
Yes
25.00
100.00
250.00
100.00
100.00
100.00
$10/15/25
$1,500/
$3,000
Yes
SEMINOLE COUNTY PUBLIC
SCHOOLS UNITED)
HMO
244.74
267.48
535.00
yes
no
15.00
o
I
I
!
20.00
o
300.00
50.00
50.00
50.00
$5115/25
$1,500/
$3,000
Yes!
employee
pays
100%
POS
267.35
292.33
584.70
I yes
no
15.00
o
30.00
o
400.00
50.00
50.00
50.00
$10/20/25
$1,500/
$3,000
Yes!
empioyee
pays
100%
OOA
314.38
345.78
643.68
I yes
no
SEMINOLE (:OUNTY PUBLIC
SCHOOLS (10/02) (CIGNA)
HMO
270.69
296.05
862.77
yes, up to
hmo
amount
no
100.00
$8/18/28
$1,500!
$3,000
Yes!
employee
pays
100%
POS
295.91
10~.00
$8118/28
I $1,500/
$3,000
I Yes!
I employee
I pays
100%
OOA
$289.68
$606.62
923.56
no, retiree
pays 100 %
r-
no
15.00
No Charge
30.00
30% once
ded met
'30% once
~met_
50.00
100.00
$8118/28
$3,000/
$6,000
Yest
rei tree
pays
100%
W1NT.ER SPRINGS .' II
U~D . \-\. v!-,\ A':-J A.' II
HMO POS ..' PPO IU
224.63 ./ 94'75'3 224.63 LJ
2~0 \- 3.} / 258.32 388.64 II~
2~.9 l\:; ]'::, 256.81 I 3e9.13 Ii ~
2sj.!?6 ".;j:i 297.14 /442.00 'I: -J
1\ I
78% :: I
I;, !
1--'
45/45/42% I
j. I
-j
I
I
I
I. i
Ii
/'-rl
II
IJ
/, I
.i,-i
t I
r .1
r-
I
) i
1
i
t
(,
100%
i 59/59/56%
10.00
10.00
o
o
o
o
50.00
55/10
Yes,
employee
pays
100%
\()
Q
,
II
I
.1
VVl
r I
j
____ v-. / if
1.7 ("'I'
,
c
I 348.98
.-t--
."T
I 943.46
+
I, yes, up to .
hmo
_~amount
i no
I
-r-
1---
I
T
~--.f!.oo
I I S 1;:;;- I No Charge
I .~.
I 30.00 I 25.00
,
! No charge . "50.00
..l I
I 3~'.~~~_.' "J 400.00/
900.00 max ..~ 1,200. Max
I
200.00 ._.~O.OO
94%
; 55/55/52%
I
-I
o
CITY OF WINTER SPRINGS
% HEAL TH/LlFE/DISABILlTY TO PAYROLL LAST FIVE YEARS
D
FINAL FINAL FINAL FINAL FINAL PRELIMINARY
BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET
E:L..9a EY...illl EY...QQ EYJll EY..Q2 EY.JU
Health/LifelDisa bility $437,489 $446,808 $460,609 $517,554 $778,600 $961,100 Note: $905.000 currently included for Health
-Plan and Funding Option still TBD
Payroll $6,277,511 $6,941,798 $7,347,913 $8,275,108 $8,570,600 $9,230,500
% Health/LifelDisability to Payroll 6.97% 6.44% 6.27% 6.25% 9.08% 10.41%
2.83% inc
overpy
';
'..
--
CITY OF WINTER SPRINGS l::.
% HEALTH/LIFE/DISABILITY TO PAYROLL BY PLAN BY OPTION
.
HMO #22 HMO #22 HMO #22 HMO #22 HMO #22 HMO #7501 HMO #7501 HMO #7501 HMO #7501 HMO #7501 HMO #75026 HMO #75026 HMO #75026 HMO #75026 HMO #75026
OPTION #1 OPTION #2 OPTION #3 OPTION #4 OPTION #5 OPTION #1 OPTION #2 OPTION #3 OPTION #4 OPTION #5 OPTION #1 OPTION #2 OPTION #3 OPTION #4 OPTION #5
PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED PROPOSED
TENTATIVE TENTATIVE TENTATIVE TENTATIVE TENTATIVE TENTATIVE TENTATIVE TENTATIVE TENTATIVE TENTATIVE TENTATIVE TENTATIVE TENTATIVE TENTATIVE TENTATIVE
BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET
EX..lla EX..lla EX..lla EX..lla EX..lla EX..lla EX..lla EX..lla EX..lla EL03 EX..lla EX..lla aha EX..lla EX..lla
Health/life/Disability $1,149,793 $791,419 $1.074,971 $1,033,434 $968,735 $1,098,518 $791,419 $1,034,283 $994,404 $932,279 $1,032,653 $791,419 $982,OB5 $944,343 $885,650
Payroll $9,230,500 $9,230,500 $9,230,500 $9.230,500 $9,230,500 $9.230,500 $9,230,500 $9,230,500 $9,230,500 $9,230.500 $9,230,500 $9,230,500 $9,230,500 $9.230.500 $9.230,500
% Health/life/Disability to Payroll 12.46% 8.57% 11.65% 11.20% 10.49% 11.90% 8.57% 11.21% 10.77% 10.10% 11.19% 8.57% 10.64% 10.23% 9.59%
.
;
t~,
CITY OF WINTER SPRINGS
COST OF FAMilY COVERAGE TO EMPLOYEE ANNUALLY AS COMPARED TO PROPOSED PAY RANGES BY HEALTH OPTIONS
HEW
PAY
ClRAOE
BY PAY GRADE
.'"
.......OYEES
"
"
"
n
2A
n
2Il
20
>0
"
32
>>
"
'"
.,
'"
,.
PO
HONE
"
RENEW CURRENT PLAN
PROPOSED
RANGE
$17.421-12S,2&O
SII,207-W~
$2l:l.161-$2B,243
$21. 171l-S3O.705
$22.234-$32.233
>>
$23,348-$33,1152
$:2-4,.513-$3.5.544
U5.7>>$J7.322
m.Q2lS..S39.1811
S2ll,.377-$41.147
25
129.796-$43.204
2Il
$31.2aS-S45.365
2A
$32.115l)..$.41,lD3
t3C.ol934SO.o15
S38,21&-15z.518
W.02$-$".1-41
SJ:I.8J0.$S7,899
"
"'1.928-$6.).;83
$-4-4.022463.&32
141.5)5..$70.37.
S50,681413.894
m.510417.l58O
S56.ta5-$llI,46ll
S5ll,19S-$a5,54J $3.000
SGl~.all S3.Q!l6
233
.. Colt 10 %c-11D CltyP~ 100't10 'Woeo.tlo
Clt)'Amort. ~Io ~ ~ID ~&SIw.. ~ID
Incfta. MirWTun f1I ~t.cwt. ft MiWnum cI eun-..... o.p ~ cI
ParR-. Pay~ PerRano-
OPTION
,
13....
13....
13....
13....
13....
13....
13_
13._
13_
13....
13....
13._
13.096
13_
13.096
13.096
13._
13.096
13....
13....
13_
13....
13....
13....
17.7N
".12'1lo
15.35"4
14,~
13,12')1,
13-"'"
12.43%
12.03"10
ID.91%
......
e.liI&%
'.55%
7.7~
'.38"
'.03..
..3&'iI
a.l1"11o
5.""
5.51"110
5.""
5.""
OPTION
2.
55.&&8
55.8-4tl
55,-'48
ss....
55.8-4tl
55.a.!
ss....
ss....
n....,
$S....,
ss....
$5.ua
ss.....
05.....
55.lloUl
$5.848
.......
$5.848
ss.....
55.644
"....
ss....
$S,&4S
ss.....
".....
$5,&t8
30,45%
"..,..
n.....
22.'''''
21.64'%
2O.81"1lo
19.63"1lo
".....
16.95..
18.15"
15.38'%
1-4.8S"
13.95'1l.
13.28'1l.
12.05"
11.5.4"
10.93"1lo
to.41"1lo
t.""
OPTION
3
$4.312
$4.312
$4.312
....3t2
$4.312
$4.312
$4,312
$4.312
$4.312
...."
$4.312
$4.312
$4.312
....312
$4.312
$4.312
$4.312
$4.312
....312
$4.312
$4.312
$4.312
..~"
$4.312
$4.312
$4,312
OtyPayt, 100'%
-......<<
so "clOhrCoo;g
T""'...........
2-4.15'%
"An
22....
$4.871
".-
....871
",...,.
$4,871
".....
$-4,1171
111.47'1l.
"An
17.Sft.
...an
16.15"1lo
"An
1S.9n.
$-4,8n
15.20"0
$-4.811
t4,41%
$4.1111
13.1",
$4,1111
13.13%
$4.1111
'2."'"
$4,811
11.1'"
$4.871
11.3-4"
$4.811
10.llO"A.
$4,a11
$4.1111
9.eo..
....8n
a.ea%
"An
$4,a11
..,...
...an .
7.51%
$4,e11
1.31..
"An
......
$4.811
$4,8n
OPTION
.
"'Co:ollo CltyP.,.. 100'% %Co.llo
~1o~&$Q~1o
Mlnlnun cI ..,."... o.p Covg MInmom of
p..,R..., P~~
OPTION
5
"......
n.....
23.03'"
",.....
19.~
18,~
11.19'11.
18.31'
15.5ft
14.as...
14.1-4"
13.-47"1lo
12.&.rIl.
11.fimI.
11.05"
10.05'"
...,..
9.11"
II.."
8.21'"
'.mfo
08.029
$6,029
$6.029 2t.~
$8,029
$8.029 21.12%
$6.029
$8.029
18.029 23.-42'l'o
18.029
$1.0211
....29
~.0211
$6.029
$8,029
18,021
18.029
$6.029 15.10'1l.
$8.029
"'029
13.7n
$8.029
lH2"!I.
$8.029
11.a91I.
18.029
11.%7"
08~20
10.73'"
"'0211
1D.22%
.,029
1.73'"
"'0211
S'WITCH TO PLAN 15028
"eon..
Oly~ ~Io
Itlcr_ Llinim..ncl
Poy"",
..eon..
~yMlD
M--....noi'
P.Y R-nge
OP'ION
,
)-4,81%
$3.096 17.11'1l.
13....
$3.CY..16 15.35"i
28,41%
03."""
$3.096 13.92'\1(,
25.112% .
SJ,096 13~
24,eo"
SJ.096 12.63%
$1.096 12.03'
22.31'"
03_
21.25'1(0
$3.096 10.91%
20.23%
$3.0ge 10.33'!li
11U1'"
13."""
la.35","
13,096 9,-42'1l.
17.-4ll%
$3,098 a.~
111.65"
$3.096 a.55%
15.115%
$3,096 11.1-4%
03....
13."""
53.096 1.03%
$3.096 6.3&%
$3.096 6.11"110
13,096 5.79'11.
53.096 5.5t'll.
13....
,,-
"'090
"CoulD ClIyP.-ys 100", '!l.CosllO
~ EmpklyM 10 ~....& Sn.r.. ~ ~
~ Inc Minrrun ot Current" .. o.p MriTum of
P-rR.-ng. P.Y~
5,2:5"
5....
oPTION
2
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
......
28,""",'
25,19%
2".56~
n....
1$,]3'1l.
11.~%
115.~
15,e3'%
15.08'l1o
13,6$'Il.
'2_"'"
lU2'llo
10,21%
9.n'io
..-
...,..
11..0'"
8.00%
OPTION
3
13.917
$3,917
13.917
13.911
$3,911
$3.911
53.811
13.911
D.il1
13.911
53,917
$3.911
53.911
$3.911
$3.911
$3,911
$3.917
$3.917
$3.917
$3.911
$3,811
$3.911
S3.Jl17
$3,917
$3,917
$3.917
Oty P.\'1I 100%
Emc:iot-P'e<ncw
5O....ofoct.-eo..v
T""'...........
20.39%
18.50%
16,18"
15.98%
15.22'Ilo
1380%
13.15'"
12.S~
11.92%
10,82'It.
8.81%
'$4.-430
9.J.I'Il.
8.01'M.
1.13'l1io
,,""
U4"1lo
.."..
......
......
'" CosllCl CIty P.p lOO'llo
E~ lD EmpIoyH & $0
loCNrunol IowMds o.peo..;
P~R.11O"
OPTION
.
......
2$,0' 55.41-4
......
23,Q6'"<;, 55,-41-4
......
21.'17'" S5.'H
$lI.'3Q
2O,Q2'lI, $5,41'
......
......
......
111.01'lib S5."U
......
11.21% 55.-474
......
......
t5,81.... 55,4U
......
".81' $5."1'
......
......
13.0' 55.'7-4
......
12.'" 55.""
......
12.2J"l. 55,-4U
......
1 US, 5s"U
11.09'lib $5.47-4
......
10.51'" $5.-41"
......
10.06'" 55,414
......
9.13' $5,-41'
......
8,1" l5-.'U
......
l.2:ll.... $5.41.4
......
1.811' $5,'14
......
7.51'110
7.l5%
OPTION
5
55.'"
55.41'
55.41'
$5.'1-4
12.-43%
"-2.8'110
10.ao'Mo
10.23%
$5,414
$5.41-4
$5.474
SWITCH TO PlAN 1501
FI
%CosIID
City Abs~ EmPoyn 10
loet_ Mnm..m of
P.,-
OP71OH
t
31.-42'l!.
53,096 11.71%
211."'"
$3,096 18.12'%
Z7,"'M.
53.096 15.35"110
25JS5%
$3.09G ".~
$3.096 13.92'Ilo
23.-45%
53.096 13.28%
="
53,096 12.&3""
21.21%
13.096 12.03'"
",.....
13.096 11..46'110
.......
$3.096 lD.IU'"
$3.096 IO.39'llo
17.5O'Il.
$3.096 1.90%
$3,096 9,42"1lo
$3.096 8.911%
15.11'110
$3,096 8.55"
$3.096 11.1-4110
13.11%
$3.098 7.75%
S3.l)96 7.311'lb
13.096 1.Q3"
$3.096 8.3ll"Il.
$:3.096 8.1'"
$3.096 5.19'1l.
9.14'1l.
$3.096 5.51"1lo
9.28'"
13....
UW"Ilo
13_
13.096
'i
'" Cost 10 Cify Pays 100"" % CosllO City P.,.. 100"" ,Cost Ie) Qty P.\'1I100""" "ec.11D
~.... e~ 10 Employ.. & Sham EmpIoyo.o 10 Empbyeoe P<-n or Errpoy... 10 E~ & so ~ 10
At.orbs Irw:: M~ of Curr.nc "Ilo ... Dep t.linirrvn cI 50 '" cI Ollw COvv Mininun 01 \I::IoIoWdS o.p Covg ...~ cI
P.Y ~ P.Y R.nge f~ P.--..,. PlY ~ P.,- R-.
5.25"1lo
.00..
OPTION
2.
55,'58
$5.-458
55.-45011
55.-458
$5,-458
$5,'58
$5,'58
55,'511
$5.'58
05....
55,-458
$5.458
$5,458
$5,458
S5.-45a
55.'58
$5.'sa
$5,'58
55.'Sll
05....
55.4511
$5,-458
55,-4511
$5.4511
55.'511
$5.'511
I
I
'1.33"
j
28.-4~
\
"i
25.771
::j
22.17 ,
21.21
",,,,J
192JJ
I
1!.3...'"'lf
17.-45J
I
:::J
I
lS.07'li
14.3.5J
I
13.51,.
13.02%
I
1"0"
tt.25J
10.77"'\
.0.J
I,
1.11"'l
9.2S"lli'r
.....'!.
t
OPTION
3
$4,140
$-4.,l-4lJ
$4.140
$01.140
$o&.1~
$4.140
$0&.1..0
$4.1-40
$01.1010
$01,1010
$-4.140
$01,1010
$-4.1..0
$.1,1010
$01.1-40
....1..0
$4.1-40
$.I,1.o1l)
$01.140
$-4.1010
"-'<0
$4.1..0
$.1.140
$4.1010
$4.1010
$01,1010
OPTION
.
23.16'110
$4.$ll.2 26.88'"
21.55""
......,
20.53'11:0
$.01.6&2 23.:2%
19.55%
$.01.682 22.11'"
18.&2'110
".082
11.13"-
s.c.6a2 '20.05%
nU19"'"
$-4.5e2 19.10'1l0
".082
".....
s.c.682 11.32'Ji.
".59'"
$.I.1Ia2 16.50%
S-4.M2 15.11'"
s.c.1a2 1-4,17%
12.GO'lb
$ool.682 1-4.25'110
$.I.M2 13.57%
11.-43""
$-4,!.8.2 12.113%
$lI.6112 12.31"1lo
10.37%
$.I.M2 tt.13""
9.a1%
$.I.M2 11.11%
8,-40%
......,
8.53%
$ool.6ll2 i.55'"
$001,6&2 1.2-4'"
1.1-4'"
$001,682 4.15%
7.37"
$4.&a2 e.33%
1.0l'lil
".082
6.68'\110
".082
".082
,.....
,.....
OPTION
5
$5.149
33.""
",..
Xt14'"
55,749
$5,149
27.3<..
$5,149
26.001'"
05.'"
SS,189
23.""
55,1119
22.....
$5.1119
21.-42"11.
$5,749
$S.7!l9
t9.~
$5,1!l9
t8.5D"lIO
S5,7a
17.62"llo
$5.7ei
IS.18"ll,
SS.789
15.SlS"Ili
55.749
"..,..
SS,7.
1-4.SO<w.
$S,7ll9
13.11"
55.7ei
13.15'll.
$5.789
""'"
",..
".1"
.0..,.,
",..
",..
$5.189
to.....
0.11"6.
......
$5.789
~ & ~ ~ ~ ~ ~ ~ t ~ ~ ~ ~ ~ ~ ~ ~ u ~ ~ ~
:: ;; 1:
e -
., N ~ tII ~ ....
.~.~.~-
I ~
I i
il ~
~ ~ ~
- ~ I
g ~ -
.- . S
A W I!
E t ~
~ I i
~ e ~
II 9 Ii
~ 0 '"
~ ~ ~
~ ~ "
" i: ~
~ - .
2 ~ ~ ~ ~ ~ ~ ~ n ~ g
I I I ~ ~ ! ~ ~ ~ ~ ~
~e~~5ii~te~~
~ ~ .
~ ! i
lH
m
~.!
m~l
Ii
; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
, i ~ ~ ;;
~ i ;
~ 101 ....
'~9~5~~j~
~ i ~ ~ ~
~ ~ ~ E ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
E E E & E E E E E E E E E E E E E E E E E E E ~ E E
t io
. ;;
p ~
~ ~ ~ ~ ~
,~~~,~
~~;:;;;~~
~ ~ ~ ~ ~ ~ ~ ~
r r r r r r r r r r r r r r r r r r
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ ~ ~ ~ ~ i , ; ~ ~ ~
p
~ s
.
~ ~ ~
'" .~~~~
~s~~~~~~
r r r r r r r r r r r r r r r r r r r r r r r r r r
S ~ 5 ~ ~ ~ 5 5 5 5 555 5 5 5 5 5 5 555 5 5 5 5
~ ~ ~
~
~ ~ ~ ~ ;; 5 ~ ~ ~ , ~ ;
;~ ~~U~
~~,~~.~,
I I g ~ I ~ I I II I ~ I II I I I II I II II I II I I II II
U U Q it U a U U U U a U U U U U u a u u U U it U U U
~ ; ~ ~ ~ ~ ~ i ~ ~
, ~ ~ ; ~ ~ ; i ; j ; ; ~ ~
f9
Q . f
-~
lHi
11.8'8'
Q H
~"
i lfH
f ll.8'''
[f~
'. -3
w~ Hj ~
lfH I
fa.. ~
-~i9
'j 1.1 :
.~ lIii
lfH
ii.S'1r
li~
S g.!
~2 Sll~
lfH
fall' 8'
c c c c c c c c c c c c c c c c c c c c c c c c c c
i i i Iii i i i i i i i i i i i i i i i i i ~ i i
~~~,;;,~
.
io
;;
~ r:;
# ~
~
~ # ~ ; $ ~
~
r r r r r r r r r r r r r r r r r r r r r r r r r r
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
(II (10 (Il .,
~~~~~;;~~
~
i ~ -;
~~~~~
~,,~~S
$ ,
Ii a ~ &
,. I- #. I-
~ ~ ~
~ ~ ~ ~
c c c c c
~ ~ ~ ~ ~
c c c
~ ~ ~
~ ~ ~
c c c c c c
~ ~ ~ ~ ~ ~
~ ~ S ~ ~ ; ~ ~ ;;
; i ~; ~ ~ ~ ~
~ , $
r r r r r r r r r r r r r r r r r r r r r r r r r r
Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q
~ ~ i ; )
; ~ ;
p p
~ r
, ,
~ u ~
~~1~9
i:
;;
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ . ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
s i ~ ~ ~ , ~
. g m ~
it #. it #
~ ~~~~~~..
~~~~~~~~~~
1fH
las-II'
'"
;;
Q Ii
-~
lfH
ii-If'"
Q If
~"
i
1fH
12,58'
~ ~
[h !
i!? ~
f",- 0
H~ ~
"lI1:.S'1- t
~ h~ ~
~ 51-
of i. U' It
Q
w~
~
~
,
-~Is
OJ I. .
f~ ·
.~ is!j
lfH
f!l1J IS'
i ~~
H.
gi!
.s Sa
~
c c ~ c ~ c ~ c ~ c c c c c c c c c c c c c c c c p
i i I i I . I i Ii. i . i i i i i . . i i i . i I
~ i ~ ~ ;; , ~ ~ ~ ~ ~ , ~ ~ ~ ~ , ~ 9
;;
$ ~ ~ ~ ~
~ t ~ ~ ~ ~ ~ ~ ~
i ~ ~ i ~ i ~ i ~ G ~ i ~ i G i i i i G i i i G G i
; i ~ ~ ~
$ ~ ~ ;
~u ~~~
~;~;t~~~
S :f .., ~ ;.: ~
r ~ ~ ~ ~ ~ ~ ~ ~ ~ r ~ ~ ~ r ~ ~ ~ ~ ~ ~ ~ r r ~ ~
~ii ii ii ii ii ii ii ii ii~iiiiii~iiii iiii iiiiii~~ ii ii
5 , ~ ~ ~ ~
.
, ~ ~
~ ~ ;
, ~ ~ ~
r r r r r r r r r r r r r r r r r r r r r r r r r r
E E E E E E E E E E E E E E E E E E E E E E E E E E
, ~ ~ ~ ~ ~ 5 ~ ~ ~ ~ ~ ~
~ ~ ~
~ , ;; ~
'" s
;; #
,
~ i ~ i ~ ~ i ~ i i i i i i ~ i ~ ~ i ~ ~ i i i ~ i
i ~ ; ~ ~ ~ ~ ; , ~ ~ , ~ ; ; ; ~ ; ~ ; ; ~ ~ ~ ;
o
0;
Ii
: >>
_s
~
:n'#
. 51!
falSII'
>i
11
~s
~ :<1'
H~!
"'alii!"
~ ~
~ ~ ,
H~ ~
lit to ~ (;
w~ Hj ~
i 1 fii ~
i 2.8' II'
i~is
'1l 9..) :
Q I~l~
.. 2 j ~ if!!
lfii
i kif IS'
Ip
Q i.:
~" Sll~
i
1Hi
fl.slJ
~
R
.
~g
"'0
0"
:::~
~'l
!(!iJ
gill
~~
"
'"
...
o
'"
'"
;lI
o
m
~
~
1;
n
o
I
...
o
:ll
o
(1l
en
'"
"
~
~
I)l
III
-<
~
~
o
;'j
o
iri
"
.....
CITY OF WINTER SPRINGS
CODY PAY STUDY BY PAY GRADE
ACTIVE LISTING AS OF MAY 9, 2002
,
NEW
PAY
GRADE
BY PAY GRADE
#OF
EMPLOYEES
14
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
35
38
CUMUlATIVE
ASCENDING
#OF
EMPLOYEES
BY PAY GRADE
29
30
6
25
26.
24
9
19
WEIGHTED AVERAGE NOT INCLUDING
DIRECTOR LEVEL
AVERAGE NON DIRECTOR SAlARY
37
38
39
40
NONE
(...
3
233
... ~~,... .
.:...-.,-
..'"
-,......-~. .. -~~,,"'-.....--._4~6c~_.....
WEIGHTED
CURRENT ACTIVE @ 5/9/02 AVERAGE
ACTUAL ACTUAL ACTUAL OF AVERAGE
MINIMUM AVERAGE MAXIMUM CURRENT ACT
516.592 516.592 $16.592
$16,592
30
$16,592 $19.075 527.321
34
518.292 520.177 $24.534
39
521.393 526.315 $28,510
48
520,167 $23,348 $26.546
78
$19.159 $25.678 $36,165
87
$21.967 $26.521 $33,736
93
$23.346 $28,795 $35.544
100
526,768 529,728 533.640
107
$26,769 $34,001 $39,188
132
$24,360 $28,895 $38,782
158
$27.931 $33,566 $41,147
182
$30,988 $34,598 $43,012
184
$31,286 534,467 $37,649
193
$33.640 $42.581 $49.797
194
545,676 $45.676 $45.676
198
$43.813 549,079 $52,516
217
536,218 $43,001 $52,655
219
$49.920 $49.960 $50,000
220
$60.136 $60.136 $60,136
225
$45.783 $48.727 552,263
226
$68.642 $68,642 $68,642
227
$51,980 $51,980 $51,980
230
$63,600 $67,970 $75,309
232
$77,617 $78,346 $79,074
233
594.000 594,000 $94,000
$553,175
$80.708
$131.575
$210,132
5770.340
5238,689
$172,770
$208.096
5238,007
$722,375
$872,716
$830,352
$68,934
$383.229
$45.676
$196,316
$817,019
$99,920
$60,136
$243,635
$6,960,392
$30,935
$68,842
$51,980
$203,910
$156,692
$94,000
PROPOSED
RANGE
$17 .421.$25,260
519,207.$27.850
$20.167.$29.243
$21.176.$30,705
$22,234.$32,239
$23.346-$33.852
$24,513.$35.544
$25,739-$37,322
$27,026.$39,168
$28,377-$41,147
$29,796-$43,204
$31.286-$45,365
$32,850-$47,633
$34.493.$50,015
$36.216.$52.516
$38,028.$55.141
$39,930.$57,899
$41,926.$60,793
$44,022-$83,832
$48,535-$70.376
$50.691.$73,894
$53,510.$77,590
$58,185-$81,488
$58,995-$85,543
$61,944-$89,819
.~,;....
. -. " - .~.. ~.&~
. . ~L . "__ ..._ _., .
...-.
F~
AFFECT ON CURRENT EMPLOYEES SAlARIES AFFECT ON CURRENT EMPLOYEES SAlARIES AFFECT ON CURRENT EMPLOYEES SAlARIES
WEIGHTED
AVERAGE
CODY A CODY A CODY A OF AVERAGE
MINIMUM AVERAGE MAXIMUM CODY A
$17.521 $17,521 $17,521
$17.521
519,207 519,831 $27,321
$20.167 $21,259 $24.534
$21,393 526,315 $28.510
$22,234 523.7 43 $26,546
$23,346 $26.284 $36,165
$24,513 $26,560 $33,736
$25,739 529,194 $35,544
$27,028 $29,800 $33,640
$28,377 $34,231 $39,188
$29,798 $30,819 $38,782
$30,694 $33,931 $41,147
$32,858 $34.887 $43,012
$34.487 $36,068 $37,649
$36.218 $42.868 $49.797
$45,676 $45.676 $45,676
$43,813 $49,079 $52.516
$41,926 $44,701 $52.655
$49,920 $49.960 $50,000
$60,136 $60,136 $60,136
$50,962 $51.222 $52,263
$68,642 $68,642 $68,842
$56,185 $58,185 $58,185
$63,800 $87,970 $75,309
$77,617 $78,346 $79,074
$94,000 $94,000 $94,000
$575,099
$85,036
$131.575
$2 I 3.687
5788,520
$239,040
$175,164
$208,600
$239,817
$770,475
$882,206
$837,288
$72,136
$385.812
$45,676
$196,316
$849,319
$99,920
$60,136
$256,110
$7,129,253
$31,686
$68,642
$58,185
$203,910
$158,692
$94,000
WEIGHTED
AVERAGE
CODY B CODY B CODY B OF AVERAGE
MINIMUM AVERAGE MAXIMUM CODY 8
$17.521 $17.521 $17,521
$17.521
$19,207 $20.103 $27.321
$20,772 $21.713 524.534
$21,393 $26,315 $28.510
$22.234 $23,965 526,546
$23.346 $26,510 $36.165
$24,513 $26,698 $33,736
$25,739 $29,194 $35.544
$27,838 $30,109 $33,640
$29,229 $34,352 $39,188
$29,798 $31,422 $38,782
$31,601 $34,255 $41,147
$32,658 $35,281 $43,012
$35,528 $38,588 $37,649
$37.305 $42,966 $49.797
$45,676 $45,676 $45.676
$43,813 549,079 $52,516
$41,926 $45,322 $52,655
$49,920 $49.960 550,000
$60,136 $60,136 $60.136
$50,962 $52.139 $52,263
$68,542 $66,642 $68,642
$57,871 $57,671 $57,871
$63,600 $67,970 $75,309
$77,617 $78,346 $79,074
$94,000 $94,000 $94,000
$582.987
$86.852
$131.575
$215.685
$795,300
$240.282
$175.164
$210,763
$240.454
$785,550
$890,630
$546,744
$73,176
$386,692
$45,676
$196,316
$861,118
$99,920
$60.136
$260,695
$7,203,446
$32,015
$68,642
$57,871
$203,910
$156,692
$94,000
WEIGHTED
AVERAGE
CODY C CODY C CODY C OF AVERAGE
MINIMUM AVERAGE MAXIMUM CODY C
517.521 $17.521 517.521
517.521
519.207 520.162 527.321
$20.772 521.713 524.534
521,393 526,315 528.510
522.234 524,014 526,546
$23.346 526.554 $36.165
524.513 526,889 $33,736
$25,739 $29,194 535,544
$27,840 530.186 $33,640
$29,229 534,352 539.188
529,796 $31,581 $38,782
$31,601 $34,294 541,147
$32,856 $35,330 $43,012
$35,528 $36,588 537,649
$37,899' 543.069 $49.797
$45.676 $45.676 $45,676
$43,813 $49,079 $52.516
$41,926 545.576 552.655
$49.920 $49.960 $50,000
$60,136 $60.136 $60,136
$50.962 $53,510 $56,058
$68,642 $68,642 $68,842
$57,871 $57,871 $57,871
$63,600 $67,970 $75,309
$77,617 $78,346 579,074
$94,000 $94,000 $94,000
5584.698
$86.852
5131 ;575
5216,126
5796.620
$242,001
$175,164
5211,302
$240,464
$789,525
5891.644
$847,920
$73,176
$387,621
545.676
5196,316
$865,944
$99.920
$60,136
5267.550
57;227,751
$32,123
568,642
$57,871
$203,910
$158,692
594,000
i.
.t'
CITY OF WINTER SPRINGS
CODY PAY STUDY BY PAY GRADE
ACTIVE LISTING AS OF MAY 9,2002
YEARLY YEARLY YEARLY
PER CODY SALARY SALARY SALARY
STUDY WITH WITH WITH
PAY YEARLY CODY CODY CODY CODY CODY CODY
GRADE SALARY A A Ii Ii .c. .c.
14 $16,592 $929 $17,521 $929 $17.521 $929 $17,521
16 $16,592 $2,615 $19,207 $3,191 $19,783 $3.191 . $19,783
16 $17,368 $1,839 $19,207 $2,415 $19,783 $2,415 $19,783
16 $17,421 $1,786 $19,207 $1,786 $19,207 $1,786 $19,207
16 $17,421 $1,786 $19,207 $1,786 $19,207 $1,786 $19,207
16 $18,118 $1,090 $19,208 $1,090 $19,208 $1,666 $19,784
16 $18,292 $915 $19,207 $1,491 $19,783 $1,491 $19,783
16 $18,292 $915 $19,207 $915 $19,207 $915 $19,207
16 $18,292 $915 $19,207 $915 $19.207 $915 $19,207
16 $18,292 $915 $19.207 $915 $19,207 $915 $19,207
16 $18,292 $1.005 $19,297 $1 ,491 $19,783 $1,491 $19,783
16 $18.292 $1,005 $19,297 $1,491 $19,783 $1,491 $19,783
16 $18,292 $1,005 $19,297 $1 ,491 $19,783 $1,491 $19.783
16 $18,292 $1,005 $19.297 $1,005 $19,297 $1,005 $19,297
16 $18,292 $914 $19,206 $914 $19,206 $914 $19,206
16 $18,292 $1,005 $19,297 $1,491 $19,783 $1,491 $19,783
16 $18,292 $1.005 $19,297 $1,005 $19,297 $1,005 $19,297
16 $18,292 $914 $19,206 . $914 $19.206 $914 $19,206
16 $18,658 $550 $19,208 $1,510 $20,168 $1,510 $20,168
16 $19,024 $184 $19,208 $760 $19,784 $1,144 $20,168
16 $19,024 $184 $19,208 $760 $19,784 $760 $19,784
16 $19,024 $184 $19,208 . $760 $19,784 $760 $19,784
16 $19,031 $177 $19,208 $753 $19,784 $1.137 $20,168
16 $19,206 $0 $19,206 $577 $19,783 $577 $19.783
16 $19,206 $19,206 $19,206 $19,206
16 $19,405 $0 $19,405 $379 $19,784 $763 $20,168
16 $19,531 $19,531 $19,531 $19,531
16 $21,733 $21,733 $21,733 $21,733
16 $25,590 $25,590 $25,590 $25,590
16 $27,321 $27,321 $27,321 $27,321
#29 $553,177 $21,913 $575,090 $29,805 $582,982 $31,533 $584,710
Avg $19,075 $19,831 $20,103 $20,162
17 $18,292 $1,875 $20,167 $2,480 $20,772 $2,480 $20,772
17 $18,292 $1,875 $20,167 $2,480 $20,772 $2,480 $20,772
17 $19,591 $576 $20,167 $1,181 $20,772 $1,181 $20,772
17 $24,534 $24,534 $24,534 $24,534
#4 $80,709 $4,326 $85.035 $6,141 $86,850 $6,141 $86.850
$20,177 $21,259 $21,713 $21,713
18 $21,393 $21,393 $21.393 $21,393
18 $26.777 $26,777 $26,777 $26,777
18 $27,055 $27,055 $27,055 $27.055
F.3
"
~.
':~
CITY OF WINTER SPRINGS
CODY PAY STUDY BY PAY GRADE
ACTIVE LISTING AS OF MAY 9, 2002
YEARLY YEARLY YEARLY
PER CODY SALARY SALARY SALARY
STUDY WITH WITH WITH
PAY YEARLY CODY CODY CODY CODY CODY CODY
~ SALARY A A .6 .6 ~ ~
18 $27,842 $27,842 $27,842 $27,842
18 $28,510 $28,510 $28,510 $28,510
#5 $131,577 $0 $131,577 $0 $131,577 $0 $131,577
$26,315 $26,315 $26,315 $26,315
19 $20,167 $2,067 $22,234 $2,733 $22,900 $2,733 $22,900
19 $21,176 $1,058 $22,234 $1,058 $22,234 $1,058 $22,234
19 $21,813 $421 $22,234 $1,088 $22,901 $1,088 $22,901
19 $22,232 $3 $22,235 $670 $22,902 $1,115 $23,347
19 $23,508 $23,508 $23,508 $23,508
19 $23,920 $23,920 $23,920 $23,920
19 $25,122 $25,122 $25,122 $25,122
19 $25,652 $25,652 $25,652 $25,652
19 $26,546 $26,546 $26,546 $26,546
#9 $210,136 $3,549 $213,685 $5,549 $215,685 $5,994 $216,130
$23,348 $23,743 $23,965 $24,014
20 $19,159 $4,188 $23,347 $4,888 $24,047 $4,888 $24,047
20 $20,320 $3,026 $23,346 $3,726 $24,046 $3,726 $24,046
20 $20,722 $2,624 $23,346 $3,324 $24,046 $3,324 $24,046
20 $20,722 $2,624 $23,346 $3,324 $24,046 $3,324 $24,046
20 $21,176 $2,170 $23,346 $2,870 $24,046 $2,870 $24,046
20 $22,234 $1,112 $23,346 $1,112 $23,346 $1,112 $23,346
20 $22,447 $900 $23,347 $1,600 $24,047 $1,600 $24,047
20 $22,651 $695 $23,346 $1,395 $24,046 $1,395 $24,046
20 $22,714 $633 $23,347 $1,333 $24,047 $1,333 $24,047
20 $23,123 $223 $23,346 $923 $24,046 $923 $24,046
20 $23,346 $23,346 $23,346 $23,346
20 $23,586 $0 $23,586 $461 $24,047 $461 $24,047
20 $23:820 $23,820 $23,820 $894 $24,714
20 $24,662 $24,662 $24,662 $24,662
20 $24,767 $24,767 $24,767 $24,767
20 $25,195 $25,195 $25,195 $25,195
20 $25,251 $25,251 $25,251 $429 $25,680
20 $25,482 $25,482 $25,482 $25,482
20 $26,271 $26,271 $26,271 $26,271
20 $26,271 $26,271 $26,271 $26,271
20 $26,438 $26,438 $26,438 $26,438
20 $29,852 $29,852 $29,852 $29,852
20 $29,863 $29,863 $29,863 $29,863
20 $29,872 $29,872 $29,872 $29,872
20 $30,123 $30,123 $30,123 $30,123
20 $30,123 $30,123 $30,123 $30,123
20 $30,705 $30,705 $30,705 $30,705
20 $30,705 $30,705 $30,705 $30,705
"
}-
,~
CITY OF WINTER SPRINGS
CODY PAY STUDY BY PAY GRADE
ACTIVE LISTING AS OF MAY 9, 2002
YEARLY YEARL Y YEARLY
PER CODY SALARY SALARY SALARY
STUDY WITH WITH WITH
PAY YEARLY CODY CODY CODY CODY CODY CODY
GRADE SALARY A A B- B- e. e.
20 $32,572 $32,572 $32,572 $32,572
20 $36,165 $36,165 $36,165 $36,165
#30 $770,334 $18,195 $788,529 $24,956 $795,290 $26.279 $796,613
$25,678 $26,284 $26,510 $26,554
....-.-... ,- J
$2'1,967... )-- . I
21 $21,967 $21,967 $21,967
21 $24,163 $351 $24,514 $1,086 $25,249 $2,313 $26,476
21 $24,747 $0 $24,747 $502 $25,249 $993 $25,740
21 $25,895 $25,895 $25,895 $25,895
21 $25,972 $25,972 $25,972 $25,972
21 $27,193 $27,193 $27,193 $27,193
21 $27,271 $27,271 $27,271 $27,271
21 $27,748 $27,748 $27,748 $27,748
21 $33,736 $33,736 $33,736 $33,736
#9 $238,692 $351 $239,043 $1,588 $240,280 $3,306 $241,998
$26,521 $26,560 $26,698 $26,889
22 $23,346 $2,393 $25,739 $2,393 $25,739 $2,393 $25,739
22 $26,499 $26,499 $26,499 $26,499
22 $28,189 $28,189 $28,189 $28,189
22 $29,185 $29,185 $29,185 $29,185
22 $30,009 $30,009 $30,009 $30,009
22 $35,544 $35,544 $35,544 $35,544
#6 $172,772 $2,393 $175,165 $2,393 $175,165 $2,393 $175,165
$28,795 $29,194 $29,194 $29,194
23 $26,768 $257 $27,025 $1,609 $28,377 $1,609 $28,377
23 $26,779 $248 $27,027 $1,059 $27,838 $1,599 $28,378
23 $27,840 $27,840 $27,840 $27,840
23 $30,363 $30,363 $30,363 $30,363
23 $30,649 $30,649 $30,649 $30,649
23 $32,058 $32,058 $32,058 $32,058
23 $33,640 $33,640 $33,640 $33,640
#7 $208,097 $505 $208,602 $2,668 $210,765 $3,208 $211,305
$29,728 $29,800 $30,109 $30,186
24 $26,769 $1,609 $28,378 $2,460 $29,229 $2,460 $29,229
24 $30,312 $30,312 $30,312 $30,312
24 $30,909 $30,909 $30,909 $30,909
24 $32,826 $32,826 $32,826 $32,826
24 $38,815 $38,815 $38,815 $38,815
24, $39,188 $39,188 $39,188 $39,188
24 $39,188 $39,188 $39,188 $39,188
#7 $238,006 $1,609 $239,615 $2,460 $240,466 $2,460 $240,466
$34,001 $34,231 $34,352 $34,352
~
~i'
CITY OF WINTER SPRINGS
CODY PAY STUDY BY PAY GRADE
ACTIVE LISTING AS OF MAY 9, 2002
YEARLY YEARLY
PER CODY SALARY SALARY
STUDY WITH WITH
PAY YEARLY CODY CODY CODY CODY
.G..BAQ..!; SALARY A A J3. J3.
YEARLY
SALARY
WITH
CODY CODY
~ ~
25 $24,360 $5,437 $29,797 $6,331 $30,691 $6,331 $30,691
25 $24,360 $5,437 $29,797 $6,331 $30,691 $6,331 $30,691
25 $24,360 $5,437. $29,797 $6,331 $30,691 $6,331 $30,691
25 $25,335 $4,462 $29,797 $5,356 $30,691 $5,356 $30,691
25 $25,739 $4,058 $29,797 $4,058 $29,797 $4,058 $29,797
25 $26,895 $2,901 $29,796 $3,795 $30,690 $5,285 $32,180
25 $27,016 $2,780 $29,796 $3,674 $30,690 $3,674 $30,690
25 $27.026 $2,771 $29,797 $2,771 $29,797 $2,771 $29,797
25 $27,026 $2,771 $29,797 $2,771 $29,797 $2,771 $29,797
25 $27,402 $2,394 $29,796 $3,288 $30,690 . $4,198 $31,600
25 $28,107 $1,689 $29,796 $2,583 $30,690 $2,583 $30,690
25 $28,107 $1,689 $29,796 $2.583 $30,690 $2,583 $30,690
25 $28,107 $1,689 $29,796 $2,583 $30,690 $2,583 $30,690
25 $28,107 $1,689 $29,796 $2,583 $30,690 $2,583 $30,690
25 $28,681 $1,116 $29,797 $2,010 $30.691 $2,010 $30,691
25 $28,776 $1,020 $29,7.96 $1.914 $30,690 $1,914 $30,690
25 $29,254 $542 $29,796 $1 ,436 $30,690 $2,346 $31,600
25 $29,566 $231 $29,797' $1,125 $30,691 $1 ,125 $30,691
25 $29,796 $29,796 $894 $30,690 $894 $30,690
25 $29,927 $0 $29,927 $763 $30,690 $763 $30,690
25 $31,239 $31,239 $31,239 $31,239
25 $32,114 $0 $32,114 $0 $32,114 $661 $32; 775
25 $34,307 $34,307 $34,307 $34,307.
25 $37,981 $37,981 $37,981 $37,981
25 $38,782 $38,782 $38,782 $38,782
#25 $722,370 $48,113 $770,483 $63,180 $785,550 $67,151 $789,521
$28,895 $30,819 $31 ,422 $31,581
26 $27,931 $3,669 $31,600 $4,617 $32,548 $4,617 $32,548
26 $29,512 $2,088 $31,600 $2,711 $32,223 $3,056 $32,568
26 $30,692 $908 $31,600 $1,531 $32,223 $1,856 $32,548
26 $30,693 $908 $31,601 $1,856 $32,549 $1,856 $32,549
26 $30,694 $0 $30,694 $1,855 $32,549 $1,855 $32,549
26 $30,918 $683 $31.601 $1,306 $32,224 $1,306 $32,224
26 $31,000 $601 $31,601 $1,549 $32,549 $1,549 $32,549
26 $31,283 $318 $31,601 $1,266 $32,549 $1,266 $32,549
26 $31,286 $315 $31,601 $315 $31,601 $315 $31,601
26 $31,653 $31,653 $31,653 $31,653
26 $31,725 $0 $31,725 $823 $32,548 $823 $32,548
26 $32,463 $0 $32,463 $85 $32,548 $85 $32,548
26 $33,309 $33.309 $33,309 $33,309
26 $33,877 $33,877 $33,877 .$33,877
26 $33,877 $33,877 $33,877 $33,877
26 $34,061 $0 $34,061 $0 $34,061 $353 $34,414
:-
.~
CITY OF WINTER SPRINGS
CODY PAY STUDY BY PAY GRADE
ACTIVE LISTING AS OF MAY 9, 2002
YEARLY YEARLY YEARLY
PER CODY SALARY SALARY SALARY
STUDY WITH WITH WITH
PAY YEARLY CODY CODY CODY CODY CODY CODY
GRADE SALARY A A .6 .6 C C
26 $34,643 $34,643 $34,643 $34,643
26 $35,924 $35,924 $35,924 $35,924
26 $36,044 $36,044 $36,044 $36,044
26 $36,544 $36,544 $36,544 $36,544
26 $36,660 $36,660 $36,660 $36,660
26 $36,660 $36,660 $36,660 $36,660
26 $36,660 $36,660 $36,660 $36,660
26 $36,660 $36,660 $36,660 $36,660
26 $36,789 $36,789 $36,789 $36,789
26 $41,147 $41,147 $41,147 $41,147
#26 $872,704 $9,490 $882,194 $17,914' $890,618 $18,937 $891,641
$33,566 $33,931 $34,255 $34,294
27 $30,988 $1,869 $32,857 $2,855 $33,843 $2,855 $33,843
27 $31,286 $1,571 $32,857 $2,771 $34,057 $2,771 $34,057
27 $32,154 $702 $32,856 $1,688 $33,842 $1,688 $33,842
27 $32,218 $638 $32,856 $1,624 $33,842 $2,275 $34,493
27 $32,228 $628 $32,856 $1,614 $33,842 $1,614 $33,842
27 $32,537 $319 $32,856 $1,305 $33,842 $1 ,305 $33,842
27 $32,537 $319 $32,856 $1,305 $33,842 $1,305 $33,842
27 $32,537 $319 $32,856 $1,305 $33,842 $1,305 $33,842
27 $32,538 $319 $32,857 $1,305 $33,843 $1,305 $33,843
27 $32,596 $260 $32,856 $260 $32,856 $260 $32,856
27 $33,163. $33,163 $33,163 $33,163
27 $33,311 $0 $33,311 $0 $33,311 $531 $33,842
27 $33.479 $0 $33.479 $363 $33,842 $363 $33,842
27 $33,838 $33.838 $33,838 $33,838
27 $34,644 $34,644 $34.644 $34,644
27 $35,000 $35,000 $35,000 $35,000
27 $35,192 $35,192 $35,192 $35,192
27 $35,991 $35,991 $35,991 $35,991
27 $36,030 . $36,030 $36,030 $36,030
27 $37,539 $37,539 $37,539 $37,539
27 $37,719 $37,719 $37,719 $37,719
27 $38,673 $38,673 $38,673 $38,673
27 $41 ,143 $41,143 $41 ,143 $41,143
27 $43,012 $43,012 $43,012 $43,012
#24 $830,354 $6,944 $837,298 $16,395 $846,749 $17,577 $847,931
$34,598 $34,887 $35,281 $35,330
28 $31,286 $3,201 $34,487 $4,242 $35,528 $4,242 $35,528
28 $37,649 $37,649 $37,649 $37,649
#2 $68,935 $3,201 $72,136 $4,242 $73,177 $4,242 $73,177
$34,467 $36,068 $36,588 $36,588
~
,,\""
CITY OF WINTER SPRINGS
CODY PAY STUDY BY PAY GRADE
ACTIVE LISTING AS OF MAY 9,2002
YEARLY YEARLY YEARLY
PER CODY SALARY SALARY SALARY
STUDY WITH WITH WITH
PAY YEARLY CODY CODY CODY CODY CODY CODY
GRADE SALARY A A a a .c c.
29 $33,640 $2,578 $36,218 $3,665 $37,305 $4,388 $38,028
29 $37,899 $37,899 $37,899 $37,899
29 $39,384 $39,384 $39,384 $39,384
29 $40,096 $40,096 $40,096 $40,096
29 $43,152 $43,152 $43,152 $43,152
29 $44,590 $44,590 $44,590 $44,590
29 $47,000 $47,000 $47,000 $47,000
29 $47,673 $47,673 $47,673 $47,673
29 $49,797 $49,797 $49,797 $49,797
#9 $383,231 $2,578 $385,809 $3,665 $386,896 $4,388 $387,619
$42,581 $42,868 $42,988 $43,069
30 $45,676 $45,676 $45,676 $45,676
31 $43,813 $43,813 $43,813 $43,813
31 $47,987 $47,987 $47,987 $47,987
31 $52,000 $52,000 $52,000 $52,000
31 $52,516 $52,516 $52,516 $52,516
#4 $196,316 $0 $196,316 $0 $196,316 $0 $196,316
$49,079 $49,079 $49,079 $49,079
32 $36,218 $5,708 $41,926 $5,708 $41,926 $5,708 $41,926
32 $38,029 $3,898 $41,927 $5,156 $43,185 $5,156 $43,185
32 $38,029 $3,898 $41,927 $5,156 $43,185 $5,156 $43,185
32 $38,029 $3,898 $41,927 $5,156 $43,185 $5,156 $43,185
32 $38,029 $3,898 $41,927 $5,156 $43,185 $5,156 $43,185
32 $38,029 $3,898 $41,927 $5,156 $43,185 $5,156 $43,185
32 $39,173 $2,753 $41,926 $4,011 $43,184 $4,849 $44,022
32 $39,565 $2,361 $41,926 $3,619 $43,184 $4,457 $44,022
32 $39,927 $2,000 $41,927 $3,258 $43,185 $3,258 $43,185
32 $42,322 $0 $42,322 $862 $43,184 $1,700 $44,022
32 $42,761 $0 $42,761 $862 $43,623 $1 ,700 $44,461
32 $43,167 $0 $43,167 $0 $43,167 $18 $43,185
32 $44,916 $44,916 $44,916 $365 $45,281
32 $45,033 $0 $45,033 $0 $45,033 $1,086 $46,119
32 $48,812 $48,812 $48,812 $48,812
32 $49,592 $49,592 $49,592 $49,592
32 $51,332 $51,332 $51,332 $51,332
32 $51,398 $51,398 $51,398 $51,398
32 $52,655 $52,655 $52,655 $52,655
#19 $817,016 $32,312 $849,328 $44,100 $861,116 $48,921 $865,937
$43,001 $44,701 $45,322 $45,576
33 $49,920 $49,920 $49,920 $49,920
,
-;
..'
CITY OF WINTER SPRINGS
CODY PAY STUDY BY PAY GRADE
ACTIVE LISTING AS OF MAY 9,2002
YEARLY YEARLY YEARLY
PER CODY SALARY SALARY SALARY
STUDY WITH WITH WITH
PAY YEARLY CODY CODY CODY CODY CODY CODY
GRADE SALARY A- A- S. S. ~ ~
33 $50,000 $50,000 $50,000 $50,000
#2 $99,920 $0 $99,920 $0 $99,920 $0 $99,920
$49,960 $49,960 $49,960 $49,960
35 $60,136 $60,136 $60,136 $60,136
36 $45,783 $5,179 $50,962 $5,179 $50,962 $5,179 $50,962
36 $48,530 $2,432 $50,962 $3,961 $52,491 $4,981 $53,511
36 $48,530 $2,432 $50,962 $3,961 $52,491 $4,981 $53,511
36 $48,530 $2,432 $50,962 $3,961 $52,491 $4,981 $53,511
36 $52,263 $52,263 $52,263 $3,795 $56,058
#5 $243,635 $12,475 $256,110 $17,062 $260,697 $23,917 $267,552
$48,727 $51,222 $52,139 $53,510
37 $68,642 $68,642 $68,642 $68,642
38 $51,980 $4,205 $56,185 $5,891 $57,871 $5,891 $57,871
39 $63,600 $63,600 $63,600 $63,600
39 $65,000 $65,000 $65,000 $65,000
39 $75,309 $75,309 $75,309 $75,309
#3 $203,909 $0 $203,909 $0 $203,909 . $0 $203,909
$67,970 $67,970 $67,970 $67,970
40 $77,617 $77,617 $77,617 $77,617
40 $79,074 $79,074 $79,074 $79,074
#2 $156,692 $0 $156,692 $0 $156,692 $0 $156,692
$78,346 $78,346 $78,346 $78,346
NONE $94,000 $94,000 $94,000 $94,000
$7,535,608 $173,088 $7,708,696 $248,938 $7,784,546 $273,267 $7,808,875
,.
CITY OF WINTER SPRINGS ,:- ~
ANALYSIS OF EMPLOYEES WI DEPENDENT COVERAGE
INCREASE IN COST OF INSURANCE FOR HMO 7502B OPTION 4
COMPARED TO CODY A, B, C INCREASES BY DEPARTMENT
Inc in Ins
New New Plan 75028
#Emp New Pay Range Pay Range As of May 9, 2002 Oplion 4 Inc under Inc under Inc under
Deet Name iJ:LJ2JtJ21.~ Mimm.um MilKimum Current Salary Cava Tyee &1nual1x .c&d.Ul ~ ~
Stormwater 2 17 20,167 29,243 19.591 family 1,332 576 1,181 1,181
23 27,026 39,188 30,363 spouse 1,392
City Mng Office nla nla nla 94,000 spouse 1,392
Finance 2 26 31,286 45,365 29,512 spouse 1,392 2,088 2,711 3,056
29 36,218 52,516 43,152 family 1,332
Comm Dev 20 23,346 33,852 22,446 family 1,332 900 1,600 1,600
City Hall 14 17,421 25,260 16,592 family 1,332 929 929 929
Police 16 19 22,234 32,239 25,652 child 1,392
25 29,796 43,204 27.026 spouse 1,392 2,771 2,771 2,771
21 24,513 35,544 27,193 family 1,332
25 29,796 43,204 28.107 family 1,332 1,689 2,583 2,583
20 23,346 33,852 30,705 child 1,392
26 31,286 45,365 31,283 family 1,332 318 1,266 1,266
26 31,286 45,365 31.725 spouse 1,392 823 823
27 32,850 47,633 32,537 family 1,332 319 1,305 1,305
27 32,850 47,633 32,537 family 1,332 319 1,305 1,305
27 32,850 47,633 33,311 family 1,332 531
27 32,850 47,633 33,479 child 1,392 363 363
32 41,926 60,793 36,218 family 1,332 5,708 5,708 5,708
27 32.850 47,633 37.719 family 1,332
32 41,926 60,793 38,029 family 1,332 3,898 5,156 5,156
32 41,926 60,793 42,322 spouse 1,392 862 1,700
36 50,961 73,894 52.263 family 1,332 3,795
Fire 17 25 29,796 43,204 24,360 family 1,332 5,437 6,331 6,331
25 29,796 43,204 25,335 family 1,332 4,462 5,356 5,356
25 29,796 43,204 25,739 spouse 1,392 4,057 4,057 4,057
25 29,796 43,204 26,895 child 1,392 2,901 3,795 5,285
25 29,796 43,204 27,402 family 1,332 2,394 3,288 4,198
25 29,796 43,204 28,681 family 1,332 1,116 2,010 2,010
26 31,286 45,365 33,877 child 1,392
26 31,286 45,365 35.924 family 1,332
26 31,286 45,365 36,660 family 1,332
26 31,286 45,365 36,660 family 1,332
26 31,286 45,365 36,660 family 1,332
29 36,218 52,516 40,096 child 1,392
32 41,926 60,793 43,167 family 1,332 18
29 36,218 52,516 44,590 family 1,332
32 41,926 60,793 45,033 family 1.332 1,086
32 41,926 60,793 51,332 family 1,332
32 41,926 60,793 52,655 family 1,332
Building 4 18 21,176 30,705 26,777 spouse 1.392
18 21,176 30,705 27,842 spouse 1,392
27 32,850 47,633 43.012 family 1,332
29 36,218 52,516 47,673 family 1,332
Utility 11 16 19,207 27,850 18,292 family 1,332 914 914 914
16 19,207 27,850 19,206 family 1,332 577 577
20 23,346 33,852 21,176 family 1,332 2,170 2,870 2,870
20 23,346 33,852 23,586 family 1,332 461 461
20 23,346 33,852 23.820 family 1,332 694
20 23,346 33,852 26,271 spouse 1,392
20 23,346 33,852 29 ,852 family 1,332
23 27,026 39,188 33,640 family 1,332
24 28,377 41,147 38,815 family 1,332
24 28,377 41,147 39,188 family 1,332
31 39,930 57,899 52,516 spouse 1,392
Public Works 5 16 19,207 27,850 18,658 spouse 1,392 550 1,510 1,510
20 23,346 33,852 26,438 spouse 1,392
20 23,346 33,852 30,122 child 1,392
21 24,513 35,544 33.736 spouse 1,392
26 31,286 45,365 41,147 spouse 1,392
P&R 5 16 19.207 27,850 18,292 family 1,332 914 914 914
20 23,346 33,852 23,346 family 1,332
27 32,850 47,633 32,218 child 1,392 638 1,624 2,275
25 29,796 43,204 37,981 spouse 1,392
37 53,510 77,590 68,642 family 1,332
'." F 5
CITY OF WINTER SPRINGS
ANALYSIS OF EMPLOYEES W/ DEPENDENT COVERAGE
INCREASE IN COST OF INSURANCE FOR HMO 7502B OPTION 4
COMPARED TO CODY A, B, C INCREASES
Inc in Ins
New New Plan 75028 $'s out of $'s out of $'s out of
New Pay Range Pay Range As of May 9, 2002 Option 4 Inc under pocket for Inc under pocket for Inc under pocket for
~ Minimum M.MimJJ.m Current Sa/aN ,~ ~ .c&l&A iIls...al1erA ~ iIJ.s..a!IJlLJl ~ ~
1 14 17,421 25,260 16,592 family 1,332 929 403 929 403 929 403
2 16 19,207 27,650 16,292 family 1,332 914 416 914 416 914 416
3 16 19,207 27,650 16,292 family 1.332 914 416 914 416 914 416
4 16 19,207 27,650 16,656 spouse 1,392 550 642 1,510 (116) 1,510 (116)
5 16 19,207 27,650 19,206 family 1,332 1,332 577 755 577 755
6 17 20,167 29,243 19,591 family 1,332 576 756 1,161 151 1,161 151
7 20 23,346 33,652 21,176 family 1,332 2,170 (636) 2,670 (1,536) 2,670 (1,536)
6 20 23,346 33,652 22,446 family 1,332 900 432 1,600 (266) 1,600 (266)
9 20 23,346 33,652 23,346 family 1,332 1,332 1,332 1,332
10 20 23,346 33,652 23,566 family 1,332 1,332 461 671 461 671
11 20 23,346 33,652 23,620 family 1,332 1,332 1,332 694 636
12 25 29,796 43,204 24,360 family 1,332 5,437 (4,105) 6,331 (4,999) 6,331 (4,999)
13 25 29,796 43,204 25,335 family 1,332 4,462 (3,130) 5,356 (4,024) 5,356 (4,024)
14 19 22,234 32,239 25,652 child 1,392 1,392 1,392 1,392
15 25 29,796 43,204 25,739 spouse 1,392 4,057 (2,665) 4,057 (2,665) 4,057 (2,665)
16 20 23,346 33,652 26,271 spouse 1,392 1,392 1,392 1,392
17 20 23,346 33,652 26,436 spou~e 1,392 1,392 1,392 1,392
16 16 21,176 30,705 26,777 spouse 1,392 1,392 1,392 1,392
19 25 29,796 43,204 26,695 child 1,392 2,901 (1,509) 3,795 (2,403) 5,265 (3,693)
20 25 29,796 43,204 27,026 spouse 1,392 2,771 (1,379) 2,771 (1.379) 2,771 (1,379)
21 21 24,513 35,544 27,193 family 1,332 1,332 1,332 1,332
22 25 29,796 43,204 27,402 family 1,332 2,394 (1,062) 3,266 (1,956) 4,196 (2,666)
23 16 21,176 30,705 27,642 spouse 1,392 1,392 1,392 1,392
24 25 29,796 43,204 26,107 family 1,332 1,669 (357) 2,563 (1,251) 2,563 (1,251)
25 25 29,796 43,204 26,661 family 1,332 1,116 216 2,010 (676) 2,010 (676)
26 26 31,266 45,365 29,512 spouse 1,392 2,066 (696) 2,711 (1,319) 3,056 (1,664)
27 20 23,346 33,652 29,652 family 1,332 1,332 1,332 1,332
26 20 23,346 33,652 30,122 child 1,392 1,392 1,392 1,392
29 23 27,026 39,166 30,363 spouse 1,392 1,392 1,392 1,392
30 20 23,346 33,652 30,705 child 1,392 1,392 1,392 1,392
31 26 31,266 45,365 31,263 family 1,332 316 1,014 1,266 66 1.266 66
32 26 31,266 45,365 31,725 spouse 1,392 1,392 623 569 623 569
33 27 32,65(1 47,633 32,216 child 1,392 636 754 1.624 (232) 2,275 (663)
34 27 32,650 47,633 32,537 family 1,332 319 1,013 1,305 27 1.305 27
35 27 32,650 47,633 32,537 family 1,332 319 1,013 1,305 27 1,305 27
36 27 32,650 47,633 33,311 family 1,332 1,332 1,332 531 601
37 27 32,650 47,633 33,479 child 1,392 1,392 363 1,029 363 1,029
36 23 27,026 39,166 33,640 family 1,332 1,332 1,332 1,332
39 21 24.513 35,544 33,736 spouse 1,392 1,392 1,392 1,392
40 26 31,266 45,365 33,677 child 1,392 1,392 1,392 1,392
41 26 31,266 45,365 35,924 family 1,332 1,332 1,332 1.332
42 32 41,926 60,793 36,216 family 1,332 5,706 (4,376) 5,706 (4,376) 5,706 (4,376)
43 26 31,266 45,365 36,660 family 1,332 1,332 1,332 1,332
44 26 31,266 45,365 36.660 family 1,332 1,332 1,332 1,332
45 26 31,266 45,365 36,660 family 1,332 1,332 1,332 1,332
46 27 32,650 47,633 37,719 family 1,332 1,332 1,332 1,332
47 25 29,796 43,204 37,961 spouse 1,392 1,392 1,392 1,392
46 32 41,926 60,793 36,029 family 1,332 3,696 (2,566) 5,156 (3,624) 5,156 (3,624)
49 24 26,377 41,147 36,615 family 1,332 1,332 1,332 1,332
50 24 26,377 41,147 39,166 family 1,332 1,332 1,332 1,332
51 29 36.216 52,516 40,096 child 1,392 1,392 1,392 1,392
52 26 31.266 45,365 41,147 spouse 1,392 1,392 1,392 1,392
53 32 41,926 60,793 42,322 spouse 1,392 1,392 662 530 1,700 (306)
54 27 32.650 47,633 43,012 family 1,332 1,332 1,332 1,332
55 29 36,216 52,516 43,152 family 1,332 1,332 1,332 1,332
56 32 41,926 60,793 43,167 family 1,332 1,332 1,332 16 1,314
57 29 36,216 52,516 44,590 family 1,332 1,332 1,332 1,332
56 32 41,926 60,793 45,033 family 1,332 1,332 1,332 1,066 246
59 29 36,216 52,516 47,673 family 1,332 1,332 1,332 1,332
60 32 41,926 60,793 51,332 family 1,332 1,332 1,332 1,332
61 36 50,961 73,694 52,263 family 1,332 1,332 1,332 3,795 (2,463)
62 31 39,930 57,699 52,516 spouse 1,392 1,392 1,392 1,392
63 32 41,926 60,793 52,655 family 1,332 1,332 1,332 1,332
64 37 53.510 77 ,590 66,642 family 1,332 1,332 1,332 1,332
~ n/a "/a "/a 94,000 spouse 1,392 1,392 1,392 1,392
66,020 45,066 62,270 72,626
)
~.....l..,=-- \
~~ _~ ~.-~..s \-c:. p
,.
'i,-'city of W~nte~, ~~rings' .
Memo
To: Mayor and City Commissioners
From: Ronald W. McLemore
Date: 08/05/02
Re: Health Insurance
Our current health insurance rates with Humana expire September 30, 2002. Humana desires to
increase our rates for our current plan 39%.
Our agent has sent out Request for Bids to the carriers on our behalf in an effort to obtain lower rates.
Requests were sent to: Aetna, AvMed, Cigna, BCCBS, United Healthcare, Nationwide Trust and PRM
Health Trust along with Humana. The 5 major carriers declined to bid due to our medical conditions.
Nationwide Trust did quote; however, the rates were comparable to the various ones quoted by
Humana. The other Trust did not respond. Declinations attached.
Humana provided our agent with a number of different plans as shown on the attached legal size
worksheet. This worksheet was prepared by our agent. I have reviewed the various plans and submit 3
for your consideration: the current HMO plan, HM07501 and HM07502B. The plans descend in terms
of "richness" and accordingly, cost.
Included for each of the 3 plans under consideration is another spreadsheet (one each) that relays the
various cost increases to the City and the Employee for various "Options" under each of the plans.
There are 5 Funding Options presented for each plan:
. the City absorbs the total increase over the current rates,
. the Employee absorbs the increase,
. the City pays 100% of the Employee and maintains the current cost sharing % breakdown for the
dependent coverage's,
+ the City pays 100% of the Employee coverage and participates in a 50% cost sharing of the
premium for the other coverage types and lastly,
+ the City pays 100% of the employee coverage for each type of coverage (the dependent
coverage's are paid in total by the employee)
The City currently cost shares in that it subsidizes, in part, the cost of the employees dependent care
coverage. The City is currently bearing a larger % of the total premium for those employees with
dependent care coverage than the employees are bearing themselves. Consideration should be given
. Page 1
-t'1~
to at least moving towards an equal sharing in~emium for coverage types other than employee
only or moving towards the employee covering the cost of dependent care coverag'e entirely.
As an example, Option #4 HMO 75028 results in an equal cost sharing of the premium. This
represents a cost to the City of $888,243/year or a 21% increase. An employee wI a child or a spouse
would incur approximately $116 more in expense per month or 53% ($1 ,392/year); whereas, an
employee with family coverage would incur approximately $111 more in expense per month or 43%
($1,331/year).
The current cost of the health insurance plan is approximately $735,000 a year. The recommended
budget for fiscal year 2003 included an anticipated increase in health insurance. Approximately
$905,000 is included in the budget for health insurance alone or an additional $170,000 above what is
currently being paid.
. Page 2
"
City of Winter Springs
Quote Listing 2002
Medical
Company Action
Aetna Declined
AvMed Declined
Cigna Declined
BeBS Declined
United Healthcare Declined
Nationwide Trust Quoted
PRM Health Trust No Response
,"
jUL-26-2002 17:02
HUMANA COMMERCIAL SLS/ORL
407 661 6063 P.02/02
~\
~)
@
@
(j
@
City of Winter Springs Renewals and Alternates
Renewal Rates HMO Option 22(RX3)
EE EE + I EE + CH. Family
$310.42 $742.J4 $742.14 $812.84
40% Increase
Renewal Rates POS Option 41 (RX3)
.' EE EE-4-1 EE+CH Family
$331.41 $792.29 $792.29 $867.69
40% Increase
Renewal Rates HMO Option 22(RX4)
EE EE + 1 EE + CH Family
$308.89 $738.49 $738.49 $808.84
39.3% Increase
Renewal Rates POS Option 41 (RX4)
EE EE.+ I EE + CH FamiJy
29.88 $788.64 $788.64 . $863.69
39.3% Increase
Renewal Rates "EPO" Option So..oo3(RX4)
EE BE + J EE -4- CH Family.
$260.78 $623.47 $623.47 $682.87
17.6% Increase(from HMO)
Renewal Rates POS Option 42(RX4)
EE EE + 1 EE + CH Family
$322.09 $770.04 $770.04 $843.39
36% Increase
Ren<;;waJ Rates "EPO" Option 80-002(RX4)
EE EI:: + 1 EE + CH Family
$297.02 $710.10 $710.10 $777.76
34% Increase(from HMO) .'
ReneWal Rates HMO Option 75-01(RX4)
$5/15/351100.RX4
EE EE + I EE + CH Family
$298.02 $712.52 $712.52 $780.40
34.5% Increase
Renewal Rates HMO Option 75-02
$5/15135/100-RX4
EE EE + I EE -+- CH Family
$291.32 $696.50 $696.50 ~762.85
31 % Increase
Renewal Rates HMO Option 75-02
$10/2SIS0/100-RX4
EE EE + I EE -I- CH Family
$282.16 $674.59 $674.59 $738.86.
27.3% Increase
TnTCll P Vl?
I Aetna"
Aetna
385 Douglas Avenue
Suite 3350
A1tamonte Springs, FL 32714
Michael R. Share
Senior Account Executive
(407) 616-2470
Fax: (407)616-2514
E-mail: ShareM@aetna.com
July 29, 2002
Mrs. Fluffy Bellus
Bellus Insurance Services, Inc.
PO Box 1820
Wmter Park, Florida 32790
Re: City ofWmter Springs
Dear Fluffy,
We have received your request for a proposal on the above named prospect.
Aetna uses underwriting guidelines to determine whether or not each potential prospect will be
eligible for group insurance. Based on the medical information provided, we decline to quote on
this prospect. . ........ ...... .
Thank you for your time and consideration.
Sincerely,
ru-;~
Michael R. Share, MBA, RHU
Senior Account Executive
MS:tr
--'.
; V flloOIIJ lo r.u .1.l:: l.V .'JU.
l@002
:.-,AvMEoI~
HEALTH
PLAN
1:100 RIVJ;RPf..ACE ULVO.
Slim :!OO
JACKSO/'/VILI..E. FlORIDA 32107
(904) 858-1300
WATS: 1-800-227.4IH4
FAX: (904) 858-1355
July 24, 2002
Ms. Fluffy Bellus
Bellus !nStirance Services
Post Office Box 1820
Winter Park, Florida 32790
Re: City of Winter Springs
Dear Fluffy:
Thank Y9u for the opportuni ty. to quote ()nuthe. City.of-Winter Springs. We must, however;---"
decline to quote, as our network cannot accommodate all of the empJoyee locations. I
certainly look forward to working with you on future cases.
Wannest regards,
~
Missy S~
AvMEO-TflE
HEALTH I"'PJloVeMeNT COMPANY
)1'-11\0 (9/97)
,
JUL.~~.~~~~ ~:03PM
CIGNA HEALTHCARE
NO. 638
P.2/2
Lee Hopper .
New BUSiness MllWIger ;
Sales .
II.
CIGNA HealthCare
255 Primera Blvd
S41te 261
Ljl.ke Mary ilL 32746
TelepAane 407.833.3124
FilGimUC! 407.833.3159
July 29,2002
Fluffy Bellus
Bellus Insurance Sl~rvices
P.O. Box 1820
Winter Pcuk, FL 3:~790
RE:' CITY OF l!rnwER SPRINGS
Dear Fluffy:
I regret that lam -qnable to provide you with a quote for the apove-reterenced group due
to current medic~l' conditions.
I appreciate your interest in CIGNA HealthCare of florida and look forward to a future
opportunity to wO!d< with you.
Sincerely,
bi:~;z4~
New Business Mana-ger
LH/dd
"
RUG-01-2002 10:39
BLUE CROSS BLUE SHIELD
8636824179 P.02/02
+(1
BlueCro!iS BlueShield
of Florida
Health Optlons.
Blue Cross and Blue Shield of Florida
and Health Options
Central Business Unit
3191 Maguire Boulevard. Suite 200
P.O. Box 149208
Orlando. Fl 32814-9208
Ho4lUl ()pr.I\)N AmlIIl'O.,tmt, 8lJO Cnl$tO IlM Ill. :""*''''
Id t'c.fw, .,0 It\dCOOMtnll.tc--..,1 1M Suo Clo"
Qnd!lk1e:"""",d~
Tel 407-894-7200
80Q-S45-f5565
August I, 2002
Fluffy Bellus
Bellus Insurance
P.O. Box 1820
Winter Park, FL 32790
RE: City of Winter Springs
Dear Fluffy Bellus:
Thank you for the opportunity to quote benefits for the above mentioned group.
However, this group does not meet our Underwriting Guidelines at this time, due to the
following:
On-going medical conditions
Once again, we appreciate the opportunity to quote health, life and dental benefits for you
and your clientele.
If you have any questions, please feel free to contact me at 407-228-9202.
Sincerely,
~fl-.
Marketing Representative
GE/je
784lJ.6O' R PS
TnTOf P Cl?
.'
AUi~0\-20~2 04:10am From-Customer Service
+4072453720
T-(~~ f".UUI/UUI r-uuu
DnitedHealthcare
I.ID ^ unileaHcatth Group CUnlpdny
Decline to Quote Notification
Ul1itcdl1ealmcare
4')~ NOrth Keller ROBo SUil~ ?OO M3tilano FL ::l:r/~ 1
Tel 800 B99 6500
William Abrahams, Key Accounts Executive
Phone: (407) 659-6964 Fax: (407) 659-6940
Chris Abney, New Business Coordinator
Phone: (407) 659-6966 Fax: (407659-6940
e-mail: william_b_abrahams@uhc.com
e-mail: chris_m_abney@uhc.com
July 31, 2002
Fluffy Bellus
Bellus Insurance Services
P. O. Box 1820
Winter Park, Florida 32790
Fax: (407) 539.0798
Re: City of Winter Springs
Dear Fluffy:
Thank you for your proposal request on City of Winter Springs. Unfortunately, after a thorough evaluation of the
information provided, our decision is to decfine to quote at Ihis lime. The reason for this declination is:
. Large, ongoing medical claims prevent underwriting from providing a quote.
We appreciate being given the opportunity to review this quote and we look forward to working with your office on
future prospects. If you have any questions or need assistance please contact your Key Accounts Executive or your
New Business Coordinator.
~'
William Abrahams
Key Account Executive
Revi:;ed 06/01 tlO 1
".
.
CITY OF WINTER SPRINGS
7/27/02
I
,jt
RATES
Lifetime Office Visit Prescription Out-of-Pocket Hospital Emergency Employee I Spouse U Children I
Deductible Maximum Coinsurance Copay Copay Limit Admission Copay Copay Familv
~ Current Plan Currerit Rates
I
Humana HMO #22 NA Unfimijed NA $10 $5/$10/$25 $1500 1 $3000 $0 $50 $224.63 I $533.00 II I $533.00 I $583.50
Renewal Rates
$310.42 1 $742.14 I $742.14 I $812.84 3
,
I'
Humana HMO #22(RX4) NA Unlimited NA $10 $51 $15/ $35/ $100 $1500 1 $3000 $0 $50 $308.89 I $738.49 1 $738.49 I $808.84
I
I ~,
Humana HMO #7501(RX4) NA Unlimited NA $10/$20 $51$15/$35/$100 $1500 / $3000 $100 per day $75 $298.02 1 $712.52 1 $712.52 1 $78C.4O
1 sl 3 days per admission I
1
Humana HMO #7502(RX4)A NA Unlimijed NA $15/$25 $51$15/$35/$100 $1500 1 $3000 $250 per day $75 $291.32 $696.50 I $696.50 I $762.85
lsl3 days per admission r
.. J _t
Humana HMO #7502(RX4)8 NA Unlimited NA $15/ $25 $101 $25/ $50 / $100 $1500 1 $3000 $250 per day $75 $282.16 $674.59 I $674.59 I $738.86
) lSl 3 days per admission I
l...
Humana EPO II8OOO2(RX4) $250 / $750 $2,000,000 10% $20 / $30 $51 $15/ $35/25% $2000 / $6000 $250 per day $100 /10% $297.02 $710.10 I $710.10 1 $777.76
1 sl 5 days per admission I
then 10%
Humana EPO II8OOO3(RX4) $500 / $1500 $2,000.000 20% $20 1 $30 $101 $25/ $50 /25% $3000 / $9000 $500 per day $100/20% $260.78 $623.47 $623.4 7 I $682.87
1 sl 7 days per admission I
then 20%
Currenl Plan Current Rates
Humana POS 1#41 NA-In Unfimijed -In NA-In $15/$25-ln $5/ $10 / $25 $1500/ $3000 -In $100 per day, 5 day max - In $50 $239.62 $568.82 $568.82 I $622.68
$400 / $800 - Oul $1000ooo - Out 70/3O-Out Deduct+3O% - Out $5000/ $lllOOO-Out Deduct + 30% - Out ReneWal Rates
$331.41 $792.29 I $792.29 $867.69
,
I
Humana POS 1#41(Rx4) NA-In Unlimited - In NA-In $15/$25-ln $5/$15/$35/$100 $1500 / $3000 -In $100 per day, 5 day max - In $50 $329.88 $788.64 I $788.84 $863.69
$400 / $800 - Out $1000ooo - Out 70/3O-Oul Deduct+3O% - Oul $5000 / $1llOOO-Out Deduct + 30% - Out I
" J
Humana POS tI42(Rx4) NA-In Unlimiled - In NA-In $15/$25-ln $5/$15/$35/$100 $15001 $3000 -In $300 per day, 5 day max - In $50 $322.09 $770.04 I $770.04 $843.39
$400 / $800 - Oul $1000ooo - Out 6O/4O-Out Deduct+4O% - Out $5000/ $lllOOO-Out Deduct + 40% - Out I
Curreilt Rates
Humana PPO $250 / $750 $5,000.000 90110 -In $15-ln $51$10/$25 $1000 1 $2000 -In Deduct + 10% - Out Deduct + 10% +$501 $292.49 $698.24 J $698.24 $784.84
70/3O-Out Deduct + 30% - In $2000 / $4000 - Out Deduct + 30% - Out Deduct + 30% - Out ReneWal Rates
$409.48 I $977.55 I: I $977.55 I $1,070.51
1"
Nationwide Public Trust NA-In NA-In $15/$25-ln . $10/$201$30 $1500 / $3000 -In $100 per day, 5 day max -In $50 $325.93 $779.181 1 $779.18 $853.13
(2yr rate & benefil guarentee) $400 / $800 - Oul $1,000,000 70 130 - Out Deduct+ 3O"A. - Out $5000 / $lllOOO-Out Deduct + 30% - Out 70% alter $150 I
copay per visij
I'.
Nationwide Public Trust NA-In NA-In $10-ln $101$20I$3O $1500 / $3000 -In $0 $50 $352.00 $841.511: I $841.51 $921.38
(2yr rate & benefit guarentee) $400 / $800 - Out $1,000,000 70 130 - Out Deduct+ 300/0 - Out $5000 / $1llOOO-Out Deduct + 30% - Out 70% alter $150 r.
copay per visil !i
*"
"*3C\
~~
~ J31
J-fo
.
.
Ii
II
,I
II
II
i
if
.~
CITY OF WINTER SPRINGS
HEALTH INSURANCE ANALYSIS. RENEW CURRENT PLAN HUMANA HMO #22
0810512002 .
MONTHLY PER EMPLOYEE
ANNUAL PER EMPLOYEE
A1iliJ.IAL..fXefHS.!;
CATEGORIES
II
EMPLOYEES
CITY
fAYS
".
llfJlwn
EMPLOYEE % TOTAL
fAYS llfJlwn fRf.M1llM
elTY
fAYS
EMPLOYEE
fAYS
TOTAL
eRfMIllM
elTY
fAYS
EMPLOYEE
fAYS
TOTAL
~
CURRENT PLAN.+ RATES
EMPLOYEE 180 . $224.63 100.00% SO.OO 0.00% $224.63 $2,695.56 $0.00 $2,695.56 $485.200.60 $0.00 $485.200.80
EMPLOYEE + CHILD 8 $312.Q1 58.54% $220.99 41.46% $533.00 $3.744.12 $2.651.66 $6.396.00 $29,952.96 $21.215.04 $51.168.00
EMPLOYEE + SPOUSE 16 $312.50 58.63% $220.50 41.37% $533.00 $3,750.00 $2.646.00 $6.396.00 $60,000.00 $42.336.00 $102.336.00
FAMILY 41 $325.54 55.79% $257.96 44.21% $583.50 $3.906.48 $3,095.52 $7,002.00 $160.165.68 $126.916.32 $287,082.00
245 $735,319.44 $190.467.36 $925.780.60
OPTION tI1
RENEW CURRENT PLAN
CITY ABSORBS INCREASE
EMPLOYEE 180 $310.42 100.00% $0.00 0.00% $310.42 $3.725.04 $0.00 $3.725.04 $670,507.20 $0.00 $670.507.20
EMPlOYEE + CHILD 8 $521.15 70.22% $220.99 29.78% $742.14 $6,253.80 $2,651.66 $8.905.68 $50,030.40 $21.215.04 $71.245.44
EMPlOYEE .+ SPOUSE 16 $521.64 70.29% $220.50 29.71% $742.14 $6,259.68 $2,646.00 $6.905.68 5100.154.66 $42,336.00 $142.490.66
FAMILY 41 $554.66 68.26% $257.96 31.74% $612.64 . $6.658.58 $3,095.52 $9.754.06 $273,000.96 $126.916.32 $399.917.28
245 51.093,693.44 $190.467.36 $1,264.160.80
5358.374.00 $0 $358.374.00
49% 0% 39%
increase incroase increase
OPnON 1/2
RENEW CURRENT PLAN
EMPLOYEE ABSORBS INCREASE
EMPlOYEE 180 $224.63 72.36% $85.79 27.54% $310.42 $2,695.56 $1,029.48 $3.725.04 $485,200.80 $ 185.306.40 $670.507.20
EMPlOYEE .+ CHILD 8 $312.01 42.04% $430.13 57.96% $742.14 $3,744.12 $5,161.58 $8.905.68 $29.952.96 $41.292.48 $71.245.44
EMPLOYEE + SPOUSE 16 $312.50 42.11% $429.64 57.69% $742.14 $3,750.00 $5,155.68 $8.905.68 $60.000.00 $82.490.88 $142.490.66
FAMILY 41 $325.54 40.05% $487.30 59.95% $812.64 $3,906.46 $5,847.60 $9.754.08 $160.165.66 $239.751.60 $399.917.28
245 5735,319.44 $548.641.36 $1.264.160.80
$0 $358.374.00 $358.374.00
0% 188% 390,;
increase increase inaea.se
OpnON 113
RENEW CURRENT PLAN
CITY PAYS 100% FOR EMPLOYEE ONL Y-
AND MAINTAINS SAME PERCENTAGE
SHARE OF DEPENDENT COVERAGE AS
CURRENTLY BEARING
OYEE ... '180 $310.42'" 100.00% '$It.OO '11.00%" ., $310:42 . ..... '.'$3,72S:()1l' .... ... $l.00 "$3,725:04 .... $670;507:20'" ... $0.110 -....$870.507.20
EMPLOYEE.+ CHILD 8 $434.45 58.54% $307.69 41.46% $742.14 $5,213.39 $3,692.29 $6.905.68 $41.707.08 $29,536.36 $71.245.44'
EMPLOYEE .+ SPOUSE 16 $435.12 58.63% $307.02 41.37% $742.14 $5.221.40 $3,684.28 $8.905.68 $63.542.40 $58,948.48. $142.490.66
FAMILY 41 $453.48 55.79% $359.36 44.21%. $812.64 $5.441.80 $4,312.28 59,754.08 5223,113.85 $176,803.43 $399.917.28
245 51,018.870.53 $265.290.27 $1,264.160.80
Employee wi Child or Spouse will pay approx $87 or 39% Employee wi Child or Spouse will pay 5283,551.09 $74.822.91 $358,374.00
mora a month wi Option 3 approx $1,044 more a year wlOpl #3 39% 39% 39'S
incraase inaease ;naTJaSe
Employees wI Family will pay approx $101 or 39% more Employee wi Family will pay approx
a month w/OpUon3 $1,212 more a rw 1#3
_.-.....~.........
-- -. ----
180
8
16
41
245
$310.42
$371.07
$371.Q7
$406.42
100.00%
50.00%
50.00%
50.00%
SO.OO
$371.07
$371.07
$406.42
0.00%
50.00%
50.00% .
50.00%
$310.42
$742.14
$742.14
$812.84
$3,725.04
$4,452.64
$4.452.64
$4,877.04
$0.00
$4.452.64
$4,452.64
$4.877.04
$3,725.04
$8.905.68
$6,905.68
$9,754.08
$670.507.20 $0.00 $670.507.20
$35,622.72 $35,622. 72 $71.245.44
$71.245.44 $71,245.44 $142.490.80
$199,958.64 $199,958.64 $399.91728
5977,334.00 $306,826.80 51.264.160.60
5242.014.58 $116,359.44 $358.374.00
33% 61% 3~
;naease IncroBse inaease
Employee wi Child or 5,Jouse will pay approx $150 or 68%
more a inooth wi Option 4
Employee wi Child Of Spouse will pay
approx $1.800 more a year wlOpl #4
Employees wi Family will payapprox $148 Of 58% more
_ ------".rnonth wi Opl/on 4
Employee wI Family will pay approx
$I,776moreayearw 1#4
-. "''''''''.........
_ _ Y VI ,""V""''-
180
8
16
41
245
$310.42 100.00% SO.OO 0.00% $310.42 $3,725.04 SO.OO $3,725.04 $670,507.20 50.00 $670.507 .20
$310.42 41.83% $431.72 58.17% $742.14 $3.725.04 $5,180.54 $8,905.68 $29.800.32 $41.445.12 $71.245.44
$310.42 41.83% $431.72 58.17% $742.14 $3.725.04 $5.180.64 $6.905.68 $59,800.64 $82.890.24 $142.490.66
$310.42 38.19% $502.42 61.81% $812.64 $3.725.04 $6,029.04 $9.754.08 5152.726.64 $247.190.64 $399.91728
5912.634.80 $371,526.00 $ 1,264. 160.80
Employee wi Child or Spouse will pay appro. $210 or 95% Employee wi Child or Spouse will pay $177,315.38 $181,058.64 $358.3:74.00
more a month wi Option 5 approx $2.520 more a year wlOpl #5 24% 95% 39"lO
IncroBse Inaease ;nO'liMStt
Employees wi Family will pay approx $244 or 95% more Employee wi Family will pay appro.
acmonth wi OpU"" 5 $2,933 more a year w I tIS
180 $298.02 100.00% $0.00 0.00% $298.02 $3,576.24 SO.OO $3,576.24 $643,723.20 $0.00 $643.723.20
~ ~~ . v."....... 8 $298.02 41.83% $414.50 58.17% $712.52 $3.576.24 $4,974.00 $8,550.24 $28,609.92 $39,792.00 $68,401.92
~~ T...".V.......;JL. 16 $298.02 41.83% $414.50 58.17% $712.52 $3,576.24 $4.974.00 $8.550.24 $57,219.84 $79,584.00 $136.803.84
41 $298.02 38.19% $482.38 61.81% $780.40 $3,578.24 $5,788.58 $9,364.80 $146,625.84 $237,330.96 $383.956.80
245 $876,178.80 $356,706.96 $ 1,232,685.76
Employee wi ChUd Q( Spouse will Payapprox $193 or 88% Employee wi Child or Spouse will pay $ 140,859.36 $166,239.60 $307.098.96
more a month wi Option 5 approx $2,316 more a year wlOp1115 19% 87% 33%
inaoase lnaoaso Inaease
Employees wi Family will pay approx $224 or 87% more Employee wi Family will pay approx
a monlhw/Oplioo 5 $2,688 more a year wlO t 115
i.
.,
CITY OF WINTER SPRINGS
HEALTH INSURANCE ANALYSIS - HMO 75028
08/0512002 .
MONTHLY PER EMPLOYEE . ANNUAL PER EMPLOYEE . ANNUAL EXPENSE
# CITY % EMPLOYEE % TOTAL CITY EMPLOYEE TOTAL CITY EMPLOYEE TOTAL
CATEGORIES EMPLOYEES fAYS lIf.Rmm fAYS llLJlwn ~ fAYS fAYS fR.EMlUM eAYS fAYS fB.fMl.lI.M
CURRENT PLAN + RATES
EMPLOYEE 180 $224.63 100.00% $0.00 0.00% $224.63 $2,695.56 $0.00 $2,695.56 $485,200.80 $0.00 $485,200.80
EMPLOYEE + CHILD 8 $312.Q1 58.54% $220.99 41.48% $533.00 $3,744.12 $2,651.88 $6,396.00 $29.952.96 $21,215.04 $51,168.00
EMPLOYEE + SPOUSE 16 5312.50 58.63% $220.50 41.37% $533.00 $3,750.00 $2,646.00 $6,396.00 $60.000.00 $42,336.00 $102,336.00
FAMILY 41 5325.54 55.79% $257.96 44.21% $583.50 $3,906.48 $3.095.52 $7,002.00 $180.165.68 $126,916.32 $287,082.00
245 $735.319.44 $190.467.36 $925,786.80
OpnON #1
GO WITH HMO 7502B
CITY ABSORBS INCREASE
EMPLOYEE 180 $282.16 100.00% SO.OO 0.00% $282.16 $3,385.92 SO.OO $3.385.92 $809.465.60 $0.00 $809.465.80
EMPLOYEE + CHILD 8 $453.60 67.24% $220.99 . 32.76% $674.59 $5,443.20 $2,651.88 $6,095.08 $43.545.60 $21,215.04 $64,760.64
EMPLOYEE + SPOUSE 16 $454.09 67.31% $220.50 32.69% $674.59 $5,449.08 $2,646.00 $6,095.08 $87,185.28 $42,336.00 $129,521.28
FAMILY 41 $480.40 65.06% $257.96 34.94% $738.36 $5,764.80 53,095.52 $8,860.32 $236,356.80 $126,916.32 $363,273.12
245 $976.553.28 $190,467.36 $1,167.020.64
$241,233.64 $0 $241,233.64
33% 0% 26%
increase increase incroase
OpnON #2
GO WITH HMO 7502B
EMPLOYEE ABSORBS INCREASE
EMPLOYEE 180 $224.63 79.61% $57.53 . 20.39% $282.16 $2,695.56 $690.36 $3,385.92 $485.200.80 $124,264.80 $609,465.60
EMPLOYEE + CHILD . 8 $312.01 46.25% 5362.58 53.75% $674.59 $3,744.12 $4,350.96 $8,095.08 $29,952.96 $34.807.68 $64,760.64
EMPLOYEE + SPOUSE 16 5312.50 46.32% 5362.09 53.68% $674.59 $3,750.00 $4.345.08 $8,095.08 $60.000.00 $69,521.28 $129,521.28
FAMILY 41 $325.54 44.09% $412.82 55.91% $738.36 $3,906.48 $4,953.84 $8,860.32 $160.165.68 $203,107.44 $363,273.12
245 $735,319.44 $431,701.20 $1,167.020.64
SO $241,233.84 $241,233.84
0% 127% 26% I
increase increase increase
OpnON fI3
GO WITH HMO 7502B
CITY PAYS 100% FOR EMPLOYEE ONLY.
AND MAINTAINS SAME PERCENTAGE
SHARE OF DEPENDENT COVERAGE AS
CURRENT1.Y BEARING
EMPLOYEE 180 $282.16 100.00% SO.OO 0.00% $282.16 $3,385.92 $0.00 $3,385.92 $609,465.60 $0.00 $609,465.60
EMPLOYEE + CHILD 8 5394.90 58.54% $279.69 41.46% $674.59 $4,738.86 53.356.22 $8,095.08 537,910.88 $26,849.76 $64,760.64
EMPLOYEE + SPOUSE 16 5395.51 58.63% $279.08 41.37% $874.59 $4,746.15 53,348.93 $8,095.08 $75.938.33 $53,582.95 $129,521.28
~A~.,:~!L v 41 $411.93 55.79% $326.43 44.21% $738.36 $4,943.17 53.917.15 $8,860.32 $202,670.07 $160,603.05 $363.273.12
i 245 $925.984.88 $241,035.76 $1,167,020.64
,
Employee wi Child ex Spouse will pay apProx $59 ex 27% EmpIoy;,e wi Child or Spouse will pay . $190,665.44 $50,568.40 $241,233.84
f1lOf'e a month wi Option 3 approx $708 more a year ~1Opt #3 26% 27% 26%
increase Increase increase
Employees wi Family will payapprox $68 ex 27% more Employee wi Family win pay approx
a month wI Option 3 $816 more a vearwlOol #3
-~ ~-- -----
------ -- ---~
180 $282.18 100.00% SO.OO 0.00%" $282.16 53,385.92 SO.OO 53,385.92 5609,465.60 SO.OO 5609,465.60
-- 8 $337.30 50.00% $337.30 50.00% $674.59 $4,047.54 $4,04 7.54 $8,095.08 532.380.32 532,380.32 584,760.64
-...--
-- 16 $337.30 50.00% 5337.30 50.00% $674.59 $4,047.54 $4,047.64 $8,095.08 $64,760.64 $64.760.64 $129.521.28
_ _ .; U;f.VU;';"-.
41 $369.18 50.00% $369.18 50.00% $738.36 $4.430.16 $4.430.16 $8,860.32 5181,636.58 $181,636.56 5363.27'3.12
245 5888,243.12 $278,777.52 $1,167.020.64
Employee wi Child or Spouse will pay approx 5116 or 53% Employee wi Child or Spouse will pay $152,923.68 $88,310.16 5241,233.84
more a month wI Option 4 approx $1,392 more a year wlOot #4 21% 46% 26%
increase incroase Increase
Employees wi Family will pay approx 5111 ex 43% more Employee wi Family will pay approx
a monlllwl Option 4 $1,332 more a year wi 1#4
__ u__.. ...__ _____
__ _._... .n',_ .____
180 $282.16 10(J.QO% SO.OO 0.00% $282.16 $3,385.92 $0.00 $3,385.92 $609.465.60 $0.00 $609.465.60
- -- 8 $282.16 41.83% $392.43 58.17% $674.59 $3,385.92 $4,709.16 $8.095.08 $27.087.36 $37,673.28 $64,760.64
_ _ ~ "',.........
-- .....''''............ 16 5282. 16 41.83% $392.43 58.17% $674.59 $3,385.92 $4,709.16 $8.095.08 $54.174.72 $75,346.58 $129.521.28
41 $282.16 38.21% $456.20 61.79% $738.36 53.385.92 55.474.40 $8,860.32 $138,822.72 $224,450.40 $363.27'3.12
245 5829,550.40 $337,470.24 $1,167.020.64
Employee wi Child ex Spouse will pay approx $171 ex 78% Employee wI ClIIld or Spouse will pay 594,230.96 $147,002.88 $241.233.84
more a month wI Option 5 approx $2.052 morn a year wlOpl tIS 13% 77% 26"-
increase Increase Incroase
Employees wI Family wiU pay approx 5198 or 77% more Employee wI Family will pay approx
a month wI Option 5 $2,376 more a rwlO 1#5
'.
CONCESSION STAND ANALYSIS
BOTTOM LINE
. PROJECT $10,000 LOSS A YEAR IF WE OPERATE BASED ON HISTORY
. PROJECT BREAKEVEN IF LEAGUE OPERATES - PROVIDED THEY GIVE US 22.5% OF
GROSS REVENUES - BASED ON A FULL YEARS WORTH OF ACTIVITY
. PROJECT LOSS IN TRANSITION YEAR OF $3,137
. LEAGUErS PROJECTED TO MAKE $3,790 A YEAR IF THEY OPERATE
. .... ~ .
'. . ~ : :
~
..
"\ :;''/.'-; < "'~ - . --:... ~
. , (:jty of.,~.....*~r ~prings
Memo
To: Ron McLemore
From: Louise Frangoul
cc: Chuck Pula
Date: 08/28/02
Re: League Assumption of Concession Operations - Proforma's FY 03 and FY 04
I have prepared proforma's of the projected results of operations for FY 03 and FY 04 assuming the
League's take over responsibility for operating the Concession Stands beginning January 1, 2003.
I project the City will lose approximately $3,137 in FY 03 as a result of the transition. Note that the City
lost $8,490 in FY 01 as a result of its operations (less the sales tax issue) and has lost YTD in FY 02
$9,389.
FY 04 will represent a full year with the League running the stands. I project the City will breakeven in
FY04 under this arrangement with the League's.
In addition, I prepared a proforma of the anticipated results of operations of the League in FY 04 to
determine whether this proposal will be favorable to them in terms of profits. My analysis projects a net
earnings to the League of approximately $3,790 in FY 04.
Many assumptions were used in the preparation of this analysis. Some of the more noteworthy are the
following:
. Revenue projections were based on an average of the last 5 years by month. Schedules by
calendar year and fiscal year were used. I felt this was conservative as I noted large swings for a
given month depending on the year. The analysis does not take into account the League's ability
to prevent their members from bringing in their own food and their willingness to increase prices.
. I have used 22.5% of gross sales as the amount we receive from the League NOT 30% as 30%
results in the League NOT showing a profit in FY04. In addition, I show the League reimbursing
the City for actual utility bills.
. I have included the PT Monitor in the Cities expenses as requested. I have also included the
League's PT Concession Manager at 20 hours a week in the League's expenses.
. Expenses basically based on either YTD FY 02 annualized, FY 01 or an estimate given the
nature of the expense.. Basis explained out to the side of the expense.
. Page 1
':
Attachments:
. City of Winter Springs - Concession Stand Proforma for Transition Year - FY 03
. City of Winter Springs - Concession Stand Proforma - FlY 04
. League's - Concession Stand Proforma - FY 04
. City of-Winter Springs.- Concession Stand Net Profit (Loss) Prior (FY 01) & Current Year (FY 02)
. City of Winter Springs - Concession Stand Sales History - 5 Full Years By Calendar Year
. City of Winter Springs "- Concession Stand Sales History - 5 Full Years By Fiscal Year
. City of Winter Springs - Concession Stand CGS History
. City of Winter Springs - Parks & Recreation Department Prior Analysis
. City of Winter Springs - Equipment Inventory
. Page 2
i
CITY OF WINTER SPRINGS
CONCESSION STAND PROFORMA TRANSITION YEAR - FY 03
Estimated Revenue
City Ooerations Oct 02-Dec 02'
October 2002
November 2002
December 2002
@ 23%
Leaaue ODeraUons Jan OJ-Sent 03-
January 2003
February 2003
March 2003
April 2003
May 2003
June 2003
July 2003
August 2003
September 2003
Reimbursement for Utilities
Total Estimated Revenue
Estimated Expense City Directly Pays:
Citv Ooerations Oct 02-Dec 02'
Salaries
Sick Leave Payout
Overtime
FICA
HeaftMifelDisabltity
Workers' Comp
Pension
Physicat Exams
Interest Expense
Utility Service
R&M-Equipment
R&M-Building
Offire Supplies
Operating Supplies
Concession. Food
Concession - Drink
Janitorial Supplies
Small Tools & Equipment
DuesIRegistrations
Other Equipment - tS
Citv Ooerations JRn 03-Seot 03'
Salaries - Dec 02 - Sept 03
FICA
Workers' Comp
UI/lity Servire
R&M.Equipment
R&M.Buiiding
Office Supplies
Small Tools & Equipment
Total Estimated Expense
Estimated Net Profit (Loss)
FY03
Transition Year
$10,272
$6,299
$0
$16,571
$401
$1,610
$2,760
$3,135
$2,837
$855
$1,007
$603
$1,248
$14.456
$4,456
$35.483
$7,192
$0
$0
$550
$618
$558
$575
$0
$0
$1.485
$661
$112
$106
$305
$3,197
$4,123
$56
$31
$0
$0
$19,569
$9,976
$763
$773
$4.456
$500
$500
$100
$1,983
$19,051
$38,620
($3,137)
Note - Average monthly revenue - past fIVe years is used as an
estimate of future revenue
Average monthly revenue - past five years
Average monthly revenue - past five years
Transition month - will not operate stand(s)
% of Average monthly revenue - past five years
% of Average monthly revenue - past five years
% of Average monthly revenue - past five years
% of Average monthly revenue - past five years
% of Average monthly revenue. past five years
% of Average monthly revenue - past five years
% of Average monthly revenue - past five years
% of Average monthly revenue - past five years
% of Average monthly revenue - past five years
Oct and Nov only - 2 months worth of prior year + 5%
none
none
Oct and Nov only - 2 months worth of prior year + 25%
Oct and Nov only - 2 months worth of prior year + 25%
none
none
OcVNovlDec - 3 months worth of prior year
One quarter of annual est 01 $2,644
Oct and Nov only.-.2.months.worth of prior.year.+.S%.
Oct and Nov only - 2 months worth of prior year + 5%
Oct and Nov only - 2 months worth 01 prior year + 5%
Oct and Nav only - 2 months worth of prior year + 5%
Oct and Nov only - 2 months worth of prlor year + 5%
OctlNovlOec - 3 months worth of prlor year
Oct and Nov only - 2 months worth of prlor year + 5%
none
none
PT Monllor @ $81hr-29 hrlwk"43 wks (10 months)
Jan-Sept - 9 months worth of prior year
estimate
estimate
lor PT Monitor
Three quarters 01 annual est of $2,644
i'
'. '. ." " .,. ",,' .t::i :::::.:-:;-:::;'.~H~:t
CITY OF WINTER SPRINGS
CONCESSION STAND PROFORMA - FY 04
Estimated Revenue City Receives From League:
@ 22.50%
League Ooerations Oct 03-Se.pt 04'
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
Reimbursement for Utility
Total Estimated Revenue
Estimated Expense City Directly Pays:
City Operations Oct 03-Sept 04
Salaries
FICA
Workers' Camp
Utility Service
R&M-Equipment
R&M-Building
Office Supplies
Small Tools & Equipment
Total Estimated Expense
Estimated Net Profit (Loss)
FY04
$2,087
$1,312
$89
. $401
$1,610
$2,760
$3,135
$2,837
$855
$1,007
.$603
$1,248
$17,944
$5,941
$23,886
$12,064
$923
$935
$5,941
$750
$500
$150
$2,644
$23.907
($21)
Note - Average monthly revenue - past five years is used as an
estimate of future revenue
% of Average monthly revenue - past five years
% of Average monthly revenue - past five years
% of Average monthly revenue - past five years
% of Average monthly revenue - past five years
% of Average monthly revenue - past five years
% of Average monthly revenue - past five years
% of Average monthly revenue - past five years
. % of Average monthly revenue - past five years
% of Average monthly revenue - past five years
% of Average monthly revenue - past five years
% of Average monthly revenue - past five years
% of Average monthly revenue - past five years
21892
2015
23907
PT Monitor @ $8/hr.29 hr/wk.52 wks
prior year annualized
estimate
estimate
for PT Monitor
annual est of $2,644 - see inv list
y
LEAGUES
CONCESSION STAND PROFORMA - FY 04
FY04
Estimated Revenue From Concession Sales:
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
$9,274
$5,832
$397
$1,782
$7,156
$12,265
$13,935
$12,607
$3,800
$4,475
$2,680
$5,549
Total Estimated Revenue
$79,753
Estimated Expense Pay to Others:
Salaries
Fica
Workers' Compensation
Office Supplies
Operating Supplies
Concession - Food & Drink
Janitorial Supplies
$8,320
$636
$645
$300
$2,000
$39,877
$300
$52,078
Estimated Expense Pay to City:
% of Sales to cover City costs
Utility Reimbursement
$17,944
$5.941
$23,886
Total Estimated Expense
$75,964
Estimated Net Profit (Loss)
$3,790
Note - Average monthly revenue - past five years is used as an
estimate of future revenue
Average of last full S fiscal years for same month
Average of last full S fiscal years for same month
Average of last full S fiscal years for same month
Average of last full S fiscal years for same month
Average of last fullS fiscal years for same month
Average of last full S fiscal years for same month
Average of last full S fiscal years for same month
Average of last full S fiscal years for same month
Average of last full S fiscal years for same month
Average of last full S fiscal years for same month
Average of last full S fiscal years for same month
Average of last full S fiscal years for same month
PT paid Concession Manager @ $8Ihr*20 hr/wk*S2 wk/yr
Cities FY 01 expense
Cities FY 01 expense
@ SO% of Gross Sales
Cities FY 01 expense
@22.S%
CITY OF WINTER SPRINGS
CONCESSION STAND NET PROFIT(LOSS)
PRIOR AND CURRENT YEAR
Note: FY 01 is the first year a .Cost Center. was established for the Concession Stand in an attempt
to capture all of the direct costs associated with running the stand.
Prior to FY 01, the only cost easily carved out of the general ledger as attributable to the concession
were the inventory purchases for food and drink. These items when purchased are charged immediately
to expense, no balance sheet transactions for inventory occur. Assume contribution of leftover inventory to
employees in December for Xmas party.
Actual
FY
01
Actual
Oct-July
FY
02
Concession Sales
$97,602
$80,510
EXDenses.
Salaries $37,163 $34,247 x
Sick Leave Payout $584 $0
Overtime $1,731 $47
FICA $2,975 $2,612 x
Health/Life/Disability $2,420 $2,473
Workers' Comp $2,727 $2,232 x
Pension $2,260 $1,807
Physical Exams $150 $295
Interest Expense . .... ~ ...' ,.... ',' . ~...:: ...... .$7,B7B_. '__ ..... .$Q--.......-
........ ..~.. -.......................
Utility Service $2,937 $4,951
R&M-Equipment $157 $3,175 x
R&M-Building $619 $531 x
Office Supplies $334 $505 x
Operating Supplies $1,961 $1 ,452
Concession - Food $19,875 $15,223
Concession - Drink $27,351 $19,633
Janitorial Supplies $306 $187
Small Tools & Equipment $801 $146 x
Dues/Registrations $460 $382
Other Equipment - IS $1,283 $0
Total Expense $113,971 $89,899
Interest Expense (sales returns) ($7,878) $0
Adjusted Total Expense $106,092 $89,899
Net Loss ($8,490) ($9,389)
ac in '02
pest control
x=expenses that will c~ntinue in some form or fashion if the league's take over
~
CITY OF WINTER SPRINGS
CONCESSION STAND SALES HISTORY BY MONTH - 5 FULL YEARS
BY CALENDAR YEAR
Calendar Calendar Calendar Calendar Calendar Calendar
11lEZ ~ ~ 2QQQ 2.QQ1 Average 2QQ2.
January $1 ,156 $1,218 $1 ,794 $1,315 $3.427 $1,782 $1,059
February $4,958 $6,664 $8,844 $5,777' $9,537 $7,156 $3,276
March $13,981 $10.424 $11,675 $13,282 $11,966 $12,265 $14,603.
April $15,183 $11,564 $12,676 $13,202 $17,049 $13,935 $14,781
May $11,861 $12,959 $11,943 $14,641 $11,633 $12,607 $11,750
June $1,359 $1,785 $2.497 $3,007 $10,356 $3,800 $3,918
July $2,011 $938 $7,611 $5,158 $6,656 $4,475 $0
August $1,643 $2,690 $2,113 $3,641 $3,313 $2,680 $0
September $8,009 $4,303 $3.477 $8,003 $3,950 $5,549 $0
October $6,531 $10,294 $6,917 $14,602 $13,017 $10,272 $0
November $5,920 $6,192 $5.496 $5,112 $8,774 $6,299 $0
December $324 $456 $682 $0 $185 $329 $0
$72,936 $69.486 $75,727 $87,739 $99,864 $81,151 $49,385
Source - General Ledger ale # 343801 Concession Stand Revenues net of sales tax revenue
,"
.'
. CITY OF WINTER SPRINGS .
CONCESSION STAND SALES HISTORY BY MONTH - 5 FULL YEARS
BY FISCAL YEAR
FY FY FY FY FY FY
fll 9.8. ~ QQ Q1 Average Q2
October $8,026 $6,531 $10,294 $6,917 $14,602 $9,274 $13,017
November $6,442 $5,920 $6,192 $5,496 $5,112 $5,832 $8,774
December $521 $324 $456 $682 $0 $397 $185
January $1 ,156 $1,218 $1,794 $1,315 $3,427 $1,782 $1,059
February $4,958 $6,664 $8,844 $5,777 $9,537 $7,156 $3,276
March $13,981 $10,424 $11,675 $13,282 $11,966 $12,265 $14,603 .
April $15,183 $11,564 $12,676 $13,202 $17,049 $13,935 $14,781
May $11,861 $12,959 $11,943 $14,641 $11,633 $12,607 $11,750
June $1,359 $1,785 $2,497 $3,007 $10,356 $3,800 $3,918
July $2,011 $938 $7,611 $5,158 $6,656 $4,475 $9,149
August $1,643 $2,690 $2,113 $3,641 $3,313 $2,680 $0
Septftmber $8,009 $4,303 $3,477 $8,003 $3,950 $5,549 $0
$75,150 $65,319 $79,573 $81,121 $97,602 $79,753 $80,510
Source - GeneraLLedgeralc.#_3438.oLCoaCEssinn.Stam1.Be.lleaue.sJ1JiLQ[.sale.s.tax1B)LfmUfL_-..~.__._____.____ ____ .. _ ..
'~
CITY OF WINTER SPRINGS
CONCESSION STAND CGS HISTORY
Oct-July
FY FY FY FY FY FY
97 98 99 00 01 Average 02
CGS-Food $16,781 $16,362 $22,732 $14,592 $19,875 $18,068 $15,223-
CGS-Drink $21,218 $19,569 $23,320 $19,099 $27,351 $22,111 $19,633
. Total CGS $37,998 $35,932 $46,051 $33,691 $47,225 $40,180 $34,856
Total Sales. $75,150 $65,319 $79,573 $81,121 $97,602 $79,753 $80,510
Margin $37,152 $29,388 $33,522 $47,430 $50,377 $39,574 $45,654
CGS as a % of Sales 51% 55% 58% 42% 48% 50% 43%
~ "
:, .
"". "
CONCESSION OPERA TON PROFITS/LOSS
1995
-16,982
1999
-12,944
1996
-18,403
2000
-3.911
1997
-8,931
2001
-8.647
1998
-13,285
2002 To-Date
-7.363
Both the little league and the Youth Soccer Group are interested in running the resp~ctive Concession
Stands.
Both begin playing their Fall Leagues this month. They are Mid-Season October 1. 2002. The Leagues
end at the end of November 2002. There are no league games during the month of December 2002. This
would be an ideal transition month from City Operation to Leagues Operation. Leagues begin in January
2003.
The current Concession Manager would transfer into a Full Time Maintenance Worker Position Vacancy
effective December 2. 2002 or another Full Time City Vacancy.
Staff will put together for our City Attorney and League Review an Agreement that will cover:.
1. The Leagues must have a PT paid Concession Manager who runs their operation and supervises
volunteers and communicates with the city Concession Representative..
2. The concession must be open for all events at the facility even Adult Sports and. other
Organization or Rental Group Activities (4-10pm. M-F, Saturday and Sunday8am-10pm).
3. 20% of _ Gross Sales come to City and 1 0% Gros~ Sales to an.. Escrow. account to. fix City
Equipment.
4. Leagues pay City Electric and Water bills. Phones if needed will be put in and paid for by the
Leagues.
5. . City will monitor Contracts and Operation through a PT Concession Contract Monitor .
6. Staff will bring 1 year agreement to City Commission in SepVOct. .
Funding needed for FY2002/03
Total Expenses
$ 23,682
$ 9,600
$ 33.282
2 month current Concession Operation
10 Month PT Contract Monitor
($ 8.00 hr. x 30 hrs. wk. x 40 weeks) =
Projected Revenue
City Operation 2 months
Leagues Operation 9 months
(Total $ 80,000-20% to city = $ 16,000)
$ 17,000
$ 16.000
Total Projected Revenue
$ 33,000
~' "
.~. III ~.oi' .:
,;' ..
CITY OF WINTER SPRINGS
PARKS & RECREATION CONCESSIONS
Contractual Manager (PT Funding Needed)
January - September
Concession Hours: . Monday - Friday
Saturday
S unda y
4:00pm - lO:OOpm
8:00am - lO:OOpm
12:00pm - lO:OOpm
SUPERVISES THESE JOB FUNCTIONS:
RESPONSIBILITIES:
o Trains all volunteers and Concession Coordinator for Youth
Organization.
o Monitors Sports Programs 'and -Personnel. 'Resolves problems and'
disputes with public.
o -Insures that the City- of Winter Springs Parks and Recreation Rules
are observed.
o Enforces Park and Facility Rules in a courteous manner.
o Coordinates all Tournaments, Leagues and Special Events with the
Youth Organization.
o Sets schedules for Part-time Sports Monitors.
o Checks and verifies funds received are accurate.
o Does spots checks of operation for cleanliness, food handling
practices and food sold.
o Submits reports to the Leagues Concession Managers with issues and
concerns to address and follow-up with phone call and meetings.
:~. ,:
. '
"
,
. CONCESSION #1 BALLFIELDS
PURCHASED
DESCRIPTION
PRICE
$ 239.97
$ 290.00
$ 450.00
$ 615.00
$ 1 ,531 .17
$ 1,871.18
$ 2,026.06
$ 400.65
$ 245.00
$ 298.00
$ 2,335.00
$ 300.00
$ 200.00
$ 19.99
$10,822.02
1995
1995
1994
1992
1992
1992
2002
1993
1993
1999
2000
2000
2000
2000
CHEST FREEZER
HOT DOG COOKER
MEAT SLICER
POPCORN MACHINE
REFRIGERATOR
FREEZER
ICE MACHINE
CHILE KETILE
CHEESE DISPENSER
CASH RIGISTERS (2)
QUIK & CRISPY MACHINE
2 HEATING LAMPS
2 MICROWAVES ($ 100 EA.)
SLO-COOKER
TOTAL
CONCESSION # 2 SOCCER FIELDS
PURCHASED DESCRIPTION PRICE
1999 CASH RIGISTERS (2) $ 298.00
2000 . 49" FREEZER $ 2,380.00
2000 23 CUFT REFRIGEARTOR $ 1,380.00
2000 ICE CREAM FREEZER $ 640.00
2000 HOT DOG MACHINE $ 605.00
2000 POPCORN MACHINE $ . 495.00
2000 CHILE KETTLE $ 170.00
2000 CHEESE DISPENSER $ 323.00
2000 QUIK & CRISPY MACHINE $ 2,335.00
2000 2 HEATING LAMPS $ 300.00
2002 COFFEE URN $ 79.98
TOTAL $ 9,005.98
('1 8~i?
.I
-
~
I.S
#-
..::t c..:.Y3.1.:3
.J
fr-
. . \
<::....>+- .s - \-= yr-
\ _'c...-
Q. ..$
--'-
l-O
~
o
~
o
~
>
~
r.n
I
~
~
~
~
l-O
>
{]
~
~
~
~
~
o
~
~
>
~
~
~
~
~
~
{]
>
~
~
~
~
r.n
l-O
o
~
~
~
o
~
~
tD
o
~
o
3'::
r'
Z
trl
.
(/)
....,
>
....,
<3
z
>
8
trl
Z
o
~
'"d
~
o
tI1
o
~
t:J
....,
o
o
o
o
z
,
t""
~
Z
"Tj
-<
o
Vl
.
'Tl
~
~
>
o
....,
"Tj
trl
trl
~
o
o
trl
(/)
I~
'"d
~
o
<:
S
trl
trl
Z
o
c
o
:r:
3'::
o
z
.....
trl
(/)
"Tj
o
~
~
trl
Z
trl
~
(/)
~
....,
<3
z
>
8
trl
Z
o
Z
trl
.
"Tj
~
~
'"d
>
o
....,
"Tj
trl
trl
~
o
trl
"Tj
n
::J
>
"Tj
....,
trl
~
(/)
....,
>
....,
<3
z
>
z
o
trl
Z
o
Z
trl
Z
"Tj
-<
o
Vl
.....
(/)
l;I9
-...J
IV
v-...J,
....
.;..
....
.
~3'::
>trl
""'0
..... .....
00
z>
>r'
8~
~z
oEg
;;lO
tI1~
"Tj
~
o
.....
(/)
'"d
~
o
tI1
~
o
....,
o
g2
<:
trl
>
'"d
o
(/)
::J
~
~
tD
>
~
o
trl
>
8
o
o
?
o
o
~
~
~
trl
Z
'"d
>
~
....,
o
....,
::r:
trl
.
3'::
trl
o
n
>
t""
~
(/)
'"d
o
~
~
~
tD
>
~
o
trl
.....
(/)
'"d
~
tI1
q
trl
o
....,
o
tD
trl
l;I9
v.>
00
IV
't..>
o
v.>
>
....,
"Tj
-<
trl
o
Vl
.
~
>
o
....,
"Tj
trl
trl
(/)
~
t""
t""
o
~0~
trl
....,
o
tD
tTl
>
Z
>
t""
-<
N
tTl
o
.
t""
~
t""
-<
~
....,
E;
C1
::J
<3
z
>
t""
3'::
o
z
.....
tTl
en
~
t""
tD
tTl
~
tTl
o
tTl
o
....,
o
(/)
~
'"d
t""
tTl
~
....,
~
tTl
'"d
~
o
g2
en
tI1
o
'T1
>
en
~
::j
~
~
~
o
~
Z
"Tj
-<
o
Vl
.,.....-.--..--
...:~...:~~""~..........
. . ;.-
.-..:-------,. . CITY OF WINTER SPRINGS
FIRE IMPACT FEE FUND
J PROFORMA
,
I{
,
FY03 FY03 FY04 FY04 FY05 FY05 FY06 FY06 FY07 FY07
SF SF SF SF SF
I
Beginning Fund Baiance $367,459 $409,644 $538,236 ($727,141 ) ($646,013)
Residential:
@ 0.086 sf
I
A very Park 10,400 $894 80,600 $6,932 80,600 $6,932 $0 $0
Parks tone 30,800 $2,649 92,400 $7,946 92,400 $7,946 92,400 $7,946 $0
St. John's Landing 8,400 $722 16,800 $1,445 16,800 $1,445 $0 $0
Beifaire 4,400 $378 79,200 $6,811 79,200 $6,811 74,800 $6,433 $0
Tuskawilla Trails $0 28,500 $2,451 28,500 $2,451 $0 $0
Highland Apts $0 44,000 $3,784 44,000 $3,784 $0 $0
Wagner's Curve $0 36,000 $3,096 42,000 $3,612 42,000 $3,612 38,000 $3,268
Commercial:
@ 0.948 sf
Tuskawilla Office Park 4,800 $4,550 14,400 $13,651 14,400 $13,651 14,400 $13,651 4,800 $4,550
,
Town Center 34,800 $32,990 87,000 $82,476 34,800. $32,990 52,200 $49,486 $0
\
Additions to Fund Balance 93,600 $42,185 478,900 $128,592 432,700 $79,623 275,800 $81,128 42,800 $7,818
Less Capital Expenditures
Per Capital Improvement Plan" $1,345,000
Ending Fund Balance $409,644 $538,236 ($727,141 ) ($646,013) ($638,195)
*=Station #3 at $1,000,000 and engine #3 at $345,000
~.;.
:'
Based on our projections. there are not sufficient impact fees to pay for the new fire station in FY 05,
Alternative revenue sources will be necessary to supplement the monies needed for the new fire station.
Note that we are continuing to analyze the impact fee itself, both the fee being currently proposed as well as
future fees.
{fJ~~~~:;'~
v_-~_. _,"
CITY OF WINTER SPRINGS
MEDICAL TRANSPORT FUND
PROJECTED FUND BALANCE THROUGH FY 07
Actual Actual Budgeted Projected Projected Projected Projected Projected
FYOO FY01 FY02 FY03 FY04 FY05 FY06 FY07
Revenue
Operating
$194,920 $181,758 $176,500 $175,000 $175,000 $175,000 $175,000 $175,000
Expense
Operating $61,115 $66,986 $77,400 $81,270 $85,334 $89,600 $94,080 $98,784
Capital $1,546 $0 $33,000 $5,000 $130,000 $5,000 $195,000 $5,000
Lease $30,056 $30,100 $30,100 $30,100 $13,189 $0 $0 $0
Note $0 $26,529 $31,500 $31,500 $31,500 $31,283 $0 $0
Total Expense $92,717 $123,615 $172,000 $147,870 $260,023 $125,883 $289,080 $103,784
Beginning
Fund Balance
$226,233 $328,436 $386,579 $391,079 $418,209 $333,187 $382,303 $268,223
Appropriation to (from) $102,203 $58,143
$4,500 $27,130 ($85,023) $49,117 ($114,080) $71,216
Ending
Fund Balance
$328,436 $386,579 $391,079 $418,209 $333,187 $382,303 $268,223 $339,439
ASSUMPTIONS:
t'"
. Flat revenues - trend indicates decreasing
. 5% Increase in operating expenses
. $5,000 annual capital outlay for equipment
. $125,000 capital outlay in '04 for 5 heart monitor replacements
. $190,000 capital outlay in '06 for Rescue #3
"
Note that the remaining funds can be used for participation in the purchase
of a fire vehicle andlor the new building.