Item 4A
AGENDA ITEM #4A
~'"'
City of Atlantic Beach NOVEMBER 22, 2004
FINANCIAL REPORT
~. OCTOBER 2004
Cash Balances
Prior Current Dollar
Fund(s) 9/30/04 10/31/04 Change
~"' General $5,670,035 $4,872,185 ($797,850)
Tree Replacement 17,201 17,201 p
Convention Development Tax 163,539 145,077 (18,462)
~., Local Option Gas Tax 297,935 292,201 (5,734)
Better Jax 1/2 Cent Sales Tax 1,076,829 1,040,270 (36,559)
Police Training, Forfeit, etc. 34,272 36,449 2,177
~ Grants (88,551) (61,758) 26,793
Debt Service 74,632 80,768 6,136
Capital Project 39,889 39,940 51
~""'" Utility 4,619,267 3,782,643 (836,624)
Sanitation 696,701 532,686 (164,015)
Storm Water 1,236,055 1,240,320 4,265
Bond Construction 0 320 320
~- Pension -Police 16,980 15,752 (1,228)
Pension -General 22,532 43,924 21,392
Total $13,877,315 $12,077,978 ($1,799,337)
Total Restricted Cash $6,347,827
Total Unrestricted Cash $5,730,151
Cash and Investments
~,. Prior Current Dollar Rate of
Account 9/30/04 10/31/04 Change Return
~• Bank of America -Depository $1,368,229 $179,599
($1,188,630)
0.75
SBA 12,507,036 11,896,329 (610,708) 1.82
Cash on Hand 2,050 2,050 0 -
~,,, SBA -Bond Construction 0 0 0 1.82
Subtotal ~`
' 13,877,315 12,077,978 (1,799,338)
-
I ~:
Suntrust-Pension-Police 3,986;110 4,029,721 43,610 7.10 (1)
Merrill Lynch-Pension-Police 335,518 347,011 11,493 20.20 (1)
Suntrust-Pension-General 5,321,686 5,378,580 56,894 7.00 (1)
Merrill Lynch-Pension-General 691,745 715,438 23,694 20.20 (1)
~'"' Subtotal 10,335,058 10,470,750 135,691
Total $24,212,373 $22,548,728 ($1,663,647)
~, (1) FYTD rate of return through 09/30/04
f'"
AGENDA ITEM #4A
NOVEMBER 22, 2004
City of Atlantic Beach
FINANCIAL REPORT
_ OCTOBER 2004
Revenues
Fund / (Footnote) Annual
Estimate YTD - 8%
of Estimate YTD
Actual Dollar
Variance Percent
Variance
General (1) $9,166,252 $760,799 $552,443 ($208,356) -27.39%
Tree Replacement 0 0 0 0 100.00%
Convention Development Tax 177,000 14,691 6,538 (8,153) -55.50%
Local Option Gas Tax 519,800 43,143 48,600 5,457 12.65%
Better Jax 1/2 Ct Sales Tax (2) 617,300 51,236 1,407 (49,829) -97.25%
Police Training, Forteit, etc. 33,180 2,753 2,178 ~ (575) -20.89%
Grants (3) 265,149 22,008 57,162 35,154 159.73%
Debt Service 73,035 6,062 6,136 74 1.22%
Capital Project 0 0 51 51 100.00%
Utility 6,458,352 536,043 500,884 (35,159) -6.56%
Sanitation 1,319,500 109,519 106,984 (2,535) -2.31%
Storm Water 2,607,493 216,422 218,209 1,787 0.83%
Bond Construction 0 0 0 0 100A0%
Pension -Police (4) 523,361 43,439 75,474 32,035 ~ 73.75%
Pension -General (4) 775,943. 64,403 127,003 62,600 97.20%
Total $22,536,365 $1,870,518 $1,703,069 ($167,449)
Analysis of Major Variances
(1) The $208,356 negative variance in the General Fund resulted from not having received
the October Sales Tax until November 2004 & property taxes typically being received
from the City of Jacksonville in January of the next year.
(2) The $49,829 negative variance in the Better Jacksonville One-Half Cent Sales Tax
Fund resulted from not having received the October revenues until November 2004.
(3) The $35,154 positive variance in the Grant Funds resulted from cash being received in
fiscal year 2005 for the reimbursement of expenses incurred in fiscal year 2004.
(4) The $32,035 positive variance in the Police Employee Pension Fund & the $62,600
positive variance in the General Employee Pension Fund resulted from increases
above estimates in the ma~ke~values of the investments.
~*
~""
City of Atlantic Beach
FINANCIAL REPORT
OCTOBER 2004
AGENDA ITEM #4A
NOVEMBER 22, 2004
Expenses
~""
Department / (Footnote) Annual
Estimate YTD - 8%
of Estimate YTD
A
t
l Dollar Percent
c
ua Variance Variance
!~ Governing Body $43,807 $3,636
$3,706
($70)
-1
93%
Cit Administration
y 1,878,828 155,943 155,200 743 .
0
48%
General Government (1) 3,976,583 330,056 190,126 139
930 .
42
40%
~ Planning and Building 697,108 57,860 31,093 ,
26
767 .
46
26%
Public Safety (2) 4,129,655 342,761 187,532 ,
155
229 .
45
29%
Parks and Recreation 976,291 81,032 53,584 ,
27
448 .
33
87%
~„ Public Works (3) 6,013,878 499,152 307,751 ,
191
401 .
38
35%
Public Utilities (4) 7,489,105 621,595 1,155,003 ,
(533,408) .
-85
81
Pension -Police 337,266 27,993 19,757- 8
236. .
29
42%
Pension -General 382,231 31,725 23,445 ,
8
280 .
26
10%
Total $25,924,752 $2,151,753 $2,127,197 ,
$24,556 .
'"" Annual YTD Estimate YTD Dollar Percent
Resource Allocation Estimate 8% Actual Variance Variance
""' Personal Services (5) $7,435,571 $617.,152 $466,890 $150
262 24
35%
~ Operating Expenses 8,520,173 707,174 348,657 ,
358
517 .
50
70%
Capital Outlay (1) & (3) 5,204,236 431,952 3,815 ,
428
137 .
99
12%
Debt Service (4) 1,756,403 145,781 1,057,138 ,
(911,357) .
-625
15%
Transfers 3,008,369 249 695 250 697 (1 002)' .
-0.40%
Total $25,924,752 $2,151,753 $2,127,197 $24,556
Analysis of Major Variances
(1) The positive variance in the General Government departments resulted from not having
begun the various projects funded from this source -see Project Activity Schedule.
(2) The positive variance in the Public Safety departments is partially due to the payment
being due quarterly to the City of Jacksonville for fire & rescue services. The next
payment is due in January 2005 for October through December, 2004.
(3) The positive variance in 'the Public Works departments resulted from the waste
management contract nat,ISaving been paid in October 2004 and not having begun
various projects funded from this source -see Project Activity Schedule.
(4) The negative variance in the Public Utilities departments resulted from the semi-annual
payment of principal and interest on the 1996 Utility Revenue Bonds in October 2004.
(5) The positive variance in the Personal Services is typical for the first month of the new
fiscal year due to the payroll expense only including three weeks of the month of
October. The last week of October will not be paid until November. This explains why
approximately 25% of the budgeted payroll has not been expensed.
,~•
~*
City of Atlantic Beach
FINANCIAL REPORT
OCTOBER 2004
AGENDA ITEM #4A
NOVEMBER 22, 2004
'~ Project Activity -Current Year Activity Only
YTD YTD YTD
~"' Project Name Budget Actual Balance Status
General Government:
~" City Hall Expansion $409,264
$0
$409
264 B
City Hall Lobby Remodel 35,000 0 ,
35,000 B
Parks and Recreation: Subtotal 444,264 0 444,264
Skateboard Park 180,827 0 180
827 E
Veteran's Memorial Park 34,000 0 ,
34,000
~*" Subtotal 214,827 _ 0 214.827
Public Safety
Police Building Design
Public Works:
Plaza Entrance/Post Office
Hopkins Creek Basin Pond
Mayport Road Medians
Drainage-George & Dudley Streets
Bike Paths on Seminole and Plaza
Welcome Sign and Landscaping
Ocean/13th -Coast Drive/12th
Shed -Equipment Storage
Five Points Intersection Improvement
Sidewalks -New
Pedestrian Path -Plaza Road
Sidewalks -Replacements
19th Street.Ditch Bulkhead
30,000 0 30,000
Subtotal .30,000 0 30,000
0
Subtotal
Public Utilities:
Replace Well 2 at WWTP1
Security Upgrade/VNater Plants
Telemetry at Lift Stations
Headwork Improvements at WWTP2
Relocate Elevated Storage Tank at;lNP2
Kesner Road Waterline Replacement .,
Fence at Water Plants 1, 2 & 3
Water Line at 10th Street & Beach Avenue
Mayport Road Sewer Crossing
Lift Station Scada
Pond Liner Replacement
Digester Blowers at WWTP 2
Utility Relocation - Wonderwood Connector
Subtotal
Total
Status Kev
B -Bid Awarded
C -Project Completed
D -Design Completed
---f __...._
100,000 a 100,000
1,480,000 0 1,480,000 E
551,942 0 551,942
107,723 0 107,723 D
232,272 0 232,272 B
37,600 0 37,600
127,000 0 127,000
15,000 0 15,000
65,000 0 65,000 E
80,000 0 80,000
75,000 0 75,000 E
50,000 0 50,000
12,000 0 12,000
2,933,537 0 2,933,538
6,389 0 6,389 E
14,864 0 14,864 I
90,811 0 90,811 B
330,000 0 330,000 D
72,418 0 72,418 I
33,938 0 33,938
40,000 0 40,000
200,000 0 200,000 E
150,000 0 150,000 E
50,000 0 50,000 E
45,000 0 45,000
60,000 0 60,000
117,258 0 117,258 C
1,210,678 0 1,210,678
$4,833,306 $0 $4,833,307
E -Design Phase
I -Project In-progress
R - Re-budget Next Fiscal Year
e~
City of Atlantic Beach, FI.
Utility Sales Report
AGENDA ITEM #4A
NOVEMBER 22, 2004
~w~:, .,:
~i~
Y: i.
Z%YS .,
October 2004 October 2003
~A. ~, _
;~ _ 1
..
,
-
Gallons Actual Revenue Gallons Actual Revenue
Water Sales Accounts (000) Revenue Per ~,aoo gl Accounts (000) Revenue Per 1,ooa gi
+
Atlantic Beach 5,460 40,842 $99,056 $2.43 5,425 56,371 $108,491 $1.92
Buccaneer 2,668 26,036 $67,645 $2.60 2,583 33,332 $73,786 $2.21
~„ Total Water Sales 8,128 66,878 $166,702 $2.49 8,008 89,703 $182,277 $2.03
Water Plant Production
~~~f
;~~~, ~
r
~„ Gallons Gallons
(000) (000)
Atlantic Beach 61,061 61,687
Buccaneer .22,808 32,065
~'"
t Total Production 83,869 93,752
Total Water Billed 66,878 89,703
Water Loss for month: 16,991 4,049
~ Percentageloss 20.26% 4.32%
Total 12 mo. Avg. Loss 12.83% 14.42%
~, Sewer Sales
Atlantic Beach
Buccaneer
Total Sewer Sales
Sewer Treatment
Millions of Gallons
Rev. per 1,000 Gallons
Gallons Actual Revenue Gallons Actual Revenue
Accounts (000) Revenue Per 1,00o gl Accounts (000) Revenue Per ~,ooo g~
4,904 32,964 $148,016
2,556 ` 24,674 $128,335
7,460 ~ 5T,638 $276,350
73.98
$3.74
75.51
$3.99
4.49 4,880 41,204 $160,323 3.89
5.20 2,472 31,609 $141,045 4.46
4.79 7,352 72,813 $301,368 $4.14
AGENDA ITEM #4A
NOVEMBER 22, 2004
Departe~ent of Publ6c Safety
Monthly Report
2004 October
Police Emergency Res Time2.000 Minutes
Reported Crimes
2002 Oc Y-T-D 2003 Oct Y-T-D 2004 Oct Y-T-D
MurderJManslau hter 0 0 0 0 0 0
Forcible Rae 0 4 0 3 1 8
Robbe 4 23 0 14 0 14
A ravated Assault 4 43 3 37 3 45
Sim le Assault/Threats 10 126 12 153 11 149
Bur la 13 114 14 97 11 126
Larcen 51 329 23 346 30 338
Auto Theft 0 42 2 46 4 52
Total
Activities
82 681 54 696 60 732
Calls for Service 2234 18580 1898 19156 1918 19400
Arrests 70 720 55 918 77 679
Uniform Traffic Citations 367 4446 419 4362 424 3847
Training Police Fitness
Departmental Updates
City Email Policy and 1T
AEA CIO FORUM: A CONVERSATION BETWEEN GOVERNMENT 8 THE
P.E.A.F. 3RD ANh9UAL FALL TRA9NSNG CONFERENCE AND LA.P.E. PROPERTY
HELPJSYSTEMS TRAINING-OPERATIONS 101-BASIC AS 400 OPERATIONS FOR LT.
Crime Suppression Activities School Safety Presentation for Halloween
Search Warrant Served for Narcotics
Task Force Operations with Other Agencies
9M3 Clr N/A AMR Clrt V_T_rl 9Md rlrf V_T_r'1
Animal Control
Jacksonville Fire and
Phone Calls 140 173 1403 129 1727
Animal Bites Re orted 1 1 15 3 22
Animals Ca 4ured 36 32 243 36 327
Animal Ado ted 3 8 39 2 50
Animals Returned to Owners 14 3 52 4 71
Citations 14 19 152 12 256
1 '\^
e ~ ~
2002 Oc Y-T-D
2003 Oct Y-T-D
2004 Oct Y-T-D
# Fire Alarms 6 156 12 147 13 196
Res onse Time Minutes 4.75 3.767 3.86
# EMS Calls 74 707 74 691 61 705
Response Time (Minuted 4.524 4.401 3.961
Code Enforcement See Attachment
AGENDA ITEM #4A
NOVEMBER 22, 2004
~""
a 4 t w a ~- 2 V
a w a O- Z V b v u~ m b ~+ '~ ^ '~ m
~ o
~ uo~ a~-az um ,. ,., ,., r, ° n n n N
t PLS m 0~
V m
n
4 N
gi O f
~~
O~ n °'
Y N M
~ u~
OtO
G~
c~P~:
0
0
0
0
° m
~`
P~
~Q O
~Np O O O O O O O O f l O .N O O O ~ O ~ O O O O O O Cl O N f! O N n O
SjpG~
~
tAOF' - o n
JUS~y+J
a H oco 000
¢
a ~cN ~~b n 0o ti~ o 0o v.~
~cti
o ~N
t
~1 0
F
ti5
r
i o
N
~+
N
~~
Yam
u~ o m
~~~
~
z
~J~s
~GI
r, o
a ra ^~
m ~S
H
~
~ ~Y1P v
~6
~ b m Y b N m m N e .~ O ~ "'r n b 0
~Q
S
u ~G
~`p~ »
v b N~ v0v ~~~~
H
K~:-
5~ m m ~~ n N N ri Y ^ Y~ Y N o~ b
~6
~G
o
a 0 0
~. ~'~
O V O O 0 0 0 b O m S O N Y Y
~~~~ N V Y ~ \^
n m 1 m
J~~p~
O B ~~ N O ~I N m
r~~~~ rl O N Y
~ m °°Z t° f°im =~m ~ZOi Sam
3om~ ~
g~ ~.~ {9~ m
~ lm
9~ m
3~~ m
30~ ~m
~-~~s~ 30~ .,g~ ~o~ ~g~
uuE°- ~
caiu~ uu°r vcwi° ~u° ~"S~ u~o ~~o uu~ uu° uu°