Agenda Item 4ACity of Atlantic Beach
FINANCIAL REPORT
JULY 2012
Prior
06/30/12
Cash Balances
Fund(s)
Current
07/31/12
AGENDA ITEM # 4A
AUGUST 27, 2012
Dollar
Change
General
$6,686,105
Tree Replacement
3,509
Convention Development Tax
28,798
Local Option Gas Tax
294,411
Better Jax 1/2 Cent Sales Tax
102,117
Police Training, Forfeiture, Grants, etc.
133,557
Community Development Block & ARRA Grants
(83,432)
Debt Service
56,062
Capital Projects
2,595,948
Utility
5,740,687
Sanitation
676,784
Building Code Enforcement
49,260
Storm Water
1,237,432
Pension - Police
17,246
Pension - General
240,897
Investments - Unallocated Gains (Losses)
89,135
Total $17,868,516
Total Restricted Cash
Total Unrestricted Cash
$6,382,916 ($303,189)
3,509
0
22,849
(5,949)
314,826
20,415
90,320
(11,797)
156,179
22,622
(105,992)
(22,560)
62,115
6,053
2,642,151
46,203
6,350,834
610,147
685,716
8,932
53,334
4,074
1,282,804
45,372
20,293
3,047
281,067
40,170
246,099
156,964
$18,489,020 $620,504
$8,027,948
$10,461,072
Cash and Investments
Account
Bank of America - Depository
Columbia Limited Duration Fund
Delaware Diversified Income Fund
Lord Abbett Short Duration Fund
Putnam Diversified Income Fund
Putnam Income Fund
American Century GNMA Fund
Alliance Limited Duration High Income Fund
Legg Mason WA Cash Reserve Fund
MSSB Money Market/Cash
SBA - Florida Prime
Cash on Hand
Police Pension Investments
General Pension Investments
Prior Current Dollar Rate of
06130112 07131/12 Change Return
$4,431,529
$4,853,548
$422,019
0.25%
2,064,727
2,086,926
22,199
1.85%(1)
1,640,152
1,673,366
33,214
2.78%(l)
1,626,487
1,638,997
12,510
2.88%(l)
1,956,803
2,006,316
49,513
5.98%(l)
2,008,009
2,049,922
41,913
2.33%(l)
999,192
1,007,105
7,913
2.46%(l)
2,128,720
2,159,781
31,061
4.42%(l)
1,000,204
1,000,364
160
0.20%
9,245
9,245
0
0.00%
298
300
2
0.31%
3,150
3,150
0
N/A
Subtotal 17,868,516
18,489,020
620,504
Rate of
Return
6,704,890
6,755,799
50,909
10.17%(2)
11,812,716
11,909,344
96,629
12.66%(2)
Subtotal 18,517,606
18,665,143
147,537
Total $36,386,122 $37,154,163 $768,041
(1) 30 day SEC Yield as of 07/31/12
(2) Fiscal Year to Date Rate of return as of 07/31/12
City of Atlantic Beach AGENDA ITEM # 4A
FINANCIAL REPORT AUGUST 27, 2012
JULY 2012
Revenues
Fund / (Footnote)
Annual
Estimate
YTD - 83%
of Estimate
YTD
Actual
Dollar
Variance
Percent
Variance
General (1)
$10,964,642
$9,133,547
$9,645,756
$512,209
5.61%
Convention Development Tax
72,000
59,976
129,964
69,988
116.69%
Local Option Gas Tax
472,612
393,686
353,193
(40,493)
- 10.29%
Better Jax 1/2 Ct Sales Tax
646,212
538,295
531,558
(6,737)
-1.25%
Police Training, Forfeiture & Grants, etc.
138,796
115,617
153,455
37,838
32.73%
Grants
519,658
432,875
299,461
(133,414)
- 30.82%
Debt Service
71,300
59,393
60,321
928
1.56%
Capital Projects (2)
2,266,207
1,887,751
457,821
(1,429,930)
- 75.75%
Utility (3)
8,368,949
6,971,335
12,269,522
5,298,187
76.00%
Sanitation
1,804,500
1,503,149
1,482,522
(20,627)
-1.37%
Building Code Enforcement
265,900
221,495
224,318
2,823
1.27%
Storm Water
972,200
809,843
808,402
(1,441)
-0.18%
Pension - Police (4)
1,232,311
1,026,515
1,158,167
131,652
12.83%
Pension - General (4)
2,122,019
1,767,642
2,380,308
612,666
34.66%
Total
$29,917,306
$24,921,119
$29,954,768
$5,033,649
Analysis of Major Variances
(1) The $512,209 positive variance in the General Fund resulted from having received
99.5% of the budgeted property taxes. Typically the majority of the property taxes are
received from the City of Jacksonville in December.
(2) The $1,429,930 negative variance in the Capital Projects Funds resulted from not
having received the proceeds from the proposed loan for the new Public Safety building.
If the loan was not included in this calculation, the variance would be a positive 8.2 %.
(3) The $5,298,187 positive variance in the Utility Funds resulted from receiving proceeds
from the State Revolving Fund Loan for the sewer plant improvements. If the loan was
not included in this calculation, the variance would be a positive .6 %.
(4) The $131.652 positive variance in the Police Employee Pension Fund & the $612,666
positive variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
City of Atlantic Beach AGENDA ITEM # 4A
FINANCIAL REPORT AUGUST27,2012
JULY 2012
Expenses
Analysis of Major Variances
(1) The positive variance in the Public Safety divisions resulted from .39% of the budgeted
amount expended fiscal year to date on the Police Building — see Project Activity
Schedule. The variance without the budget for the Police Building is a positive 6.9 %.
(2) The positive variance in the Public Works divisions resulted from: 28% expended fiscal
year to date on the paving projects funded by the Local Option Gas Tax Fund, only 9 of
the 10 payments being paid on the 1 St Vehicles & Advanced Disposal Services contracts,
57.7% expended fiscal year to date on the Stormwater Contractual Services & 11.7%
expended fiscal year to date on projects - see Project Activity Schedule.
(3) The positive variance in the Personnel Services resulted from vacant positions that
have not been filled or have been filled with employees at a lesser wage & benefits. The
vacancies &/or replacements include the following departments: Public Works, Painters,
City Manager, Planning & Development, Police, Public Utilities, Finance, Human
Resources & Lifeguards. The Lifeguards are typically seasonal employees working May
through September.
Annual
YTD - 83%
YTD
Dollar
Percent
Department / (Footnote)
Estimate
of Estimate
Actual
Variance
Variance
Governing Body
$41,986
$34,974
$35,125
($151)
-0.43%
City Administration
2,660,587
2,212,521
1,944,656
267,865
12.11%
General Government
802,694
672,392
506,812
165,580
24.63%
Planning and Building
550,867
458,872
340,495
118,377
25.80%
Public Safety (1) & (3)
10,112,138
8,423,412
4,420,900
4,002,512
47.52%
Recreation and Special Events
394,207
328,374
328,416
(42)
-0.01%
Public Works (2) & (3)
6,123,436
5,100,821
4,251,753
849,068
16.65%
Public Utilities
14,418,298
12,010,442
11,617,099
393,343
3.28%
Pension - Police
587,832
489,664
558,933
(69,269)
- 14.15%
Pension - General
740,710
617,011
638,367
(21,356)
-3.46%
Total
$36,432,755
$30,348,483
$24,642,556
$5,705,927
Annual
YTD - 83%
YTD
Dollar
Percent
Resource Allocation
Estimate
of Estimate
Actual
Variance
Variance
Personnel Services (3)
$9,817,665
$8,178,113
$7,667,863
$510,250
6.24%
Operating Expenses (1) & (2)
10,580,552
8,813,600
7,826,652
986,948
11.20%
Capital Outlay (1) & (2)
12,068,749
10,053,268
5,965,623
4,087,645
40.66%
Debt Service
2,297,807
1,914,073
1,790,776
123,297
6.44%
Transfers
1,667,982
1,389,429
1,391,642
(2,213)
-0.16%
Total
$36,432,755
$30,348,483
$24,642,556
$5,705,927
Analysis of Major Variances
(1) The positive variance in the Public Safety divisions resulted from .39% of the budgeted
amount expended fiscal year to date on the Police Building — see Project Activity
Schedule. The variance without the budget for the Police Building is a positive 6.9 %.
(2) The positive variance in the Public Works divisions resulted from: 28% expended fiscal
year to date on the paving projects funded by the Local Option Gas Tax Fund, only 9 of
the 10 payments being paid on the 1 St Vehicles & Advanced Disposal Services contracts,
57.7% expended fiscal year to date on the Stormwater Contractual Services & 11.7%
expended fiscal year to date on projects - see Project Activity Schedule.
(3) The positive variance in the Personnel Services resulted from vacant positions that
have not been filled or have been filled with employees at a lesser wage & benefits. The
vacancies &/or replacements include the following departments: Public Works, Painters,
City Manager, Planning & Development, Police, Public Utilities, Finance, Human
Resources & Lifeguards. The Lifeguards are typically seasonal employees working May
through September.
City of Atlantic Beach
FINANCIAL REPORT
JULY 2012
Project Activity - Current Year Activity Only
AGENDA ITEM # 4A
AUGUST 27, 2012
Project YTD YTD
Project Name Number Budget Actual Balance Status
Public Safety
Retrofit HVAC Systems
GG1201
224,135
110,263
113,872
Lifeguard Building Roof Replacement
LG0901
4,750
4,750
0
Police Building Renovation /Design /Construction
PS0504
4,432,582
14,364
4,418,218
4,661,467
129,377
4,532,090
Public Utilities:
TMDL - Lift Station /Main Transfer Flow
PU0906
72,810
60,700
12,110
Donner Subdivision Sewer Rehabilitation
PU1015
175,590
173,813
1,777
Replace 2" Water Main -11th Street
PU1104
51,833
57,403
(5,570)
TMDL Upgrade /Construction - WWTP #1
PU1106
3,218,851
2,985,631
233,220
TMDL Sludge /Odor Improvements
PU1110
2,392,785
1,898,879
493,906
Elevated Tank #1 - Internal Rehabilitation
PU1201
0
0
0
Ground Storage Tank WP #2 - Interior Rehabilitation
PU1202
0
0
0
Ground Storage Tanks WP #3 - Recoat Interior
PU1203
0
0
0
Water Main - 12th Street at Ocean Blvd /Beach Ave
PU1204
60,000
8,456
51,544
Water Main - 14th & 15th Street at Ocean Boulevard
PU1205
294,302
8,363
285,939
Sewer Rehabilitation - Area B
PU1206
380
350,684
29,316
Water Plant #1 - New Concrete Vault
PU1207
10,731
10,730
1
Subtotal
6,656,902
5,554,659
1,102,243
Public Works:
Riverbranch Preserve - Kayak & Canoe Launch
PM0804
16,113
14,906
1,207
Parking Improvements - Donner Park
PM1106
115,901
6,400
109,501
Veteran's Park - Phase II - Memorial Garden
PM1110
13,102
2,632
10,470
Howell Park Bridge Replacement
PM1201
0
306
(306)
Bull Park Playground Equipment Replacement
PM1202
40,000
0
40,000
Sidewalk & Curb Replacement
PW1101
5,406
5,406
0
Sidewalk & Curb Replacement
PW1201
13,543
113
13,430
East Coast Drive Drainage Improvements
PW1202
50,000
0
50,000
Subtotal
254,065
29,763
224,302
Total
$11,572,434
$5,713,799
$5,858,635
Status Key
A - Bid Advertised E - Design Phase
B - Bid Awarded I - Project In- progress
C - Project Completed N - Complete /Non - Capital
D - Design Completed R - Re- budget Next Fiscal Year
DE - Deferred X - Project Cancelled
I
C
DE
C
I
AGENDA ITEM # 4A
AUGUST 27, 2012
Atlantic Beach
Police Department
Semiannual 2012
Highlights
The Police Department continues to have two full time Officers dedicated to the
Community Oriented Policing (COPS) program. They have positive interaction with the
community on a daily basis; often assisting citizens who are in need of services or
assistance. The COPS officers conduct many of their patrols on bicycles, interact with
the kids at the Atlantic Beach Community Centers and apartment complexes, form
relationships with both residents and business owners, and attend special events in the
community.
During strategic planning in April of this year, City Commission identified pedestrian
and bike (also known as Vulnerable Road Users or VNRs) safety as the number three
priority for the city. The first step for the police department in this initiative was to
analyze our crash data, from previous years, obtain same from neighboring jurisdictions
for comparison purposes, evaluate our intersection for any maintenance or other
concerns, contact other departments and reviewing their pedestrian safety efforts and
results, and provide a basic roadmap for moving forward. This preliminary report was
presented to the commission at the first meeting in July.
During the preparation of the pedestrian Safety Report, it was learned that the Florida
Department of Transportation (FDOT) had identified this as a top strategic initiative
statewide as well. Police and other city staff subsequently met with local FDOT
Engineers regarding the concerns about the increase in VNR accidents over the past 3
years. Staff requested that the Engineers evaluate a number of intersections along State
Routes within the city as determined by accident data. FDOT has completed this
evaluation and their report will be forthcoming.
The FDOT also held a "kickoff" meeting to discuss the VRU statewide initiative. One
purpose of this meeting was to gain input at a local level for incorporation into their
strategic plan as appropriate. Police staff attended the roundtable discussion on the
Pedestrian/Bicycle safety issue hosted by FDOT.
It will important to address the VRU concerns from each of the three E's, Engineering,
Education and Enforcement. One item that was gleaned by reviewing efforts and results
of other law enforcement agencies is that there were very limited improvements from just
Engineering and Education. The most significant improvements in safety were only
realized after effective enforcement measures were initiated and sustained. While
preliminary efforts are already underway, the specific details about how the entire
program will be implemented in AB are still being developed.
AGENDA ITEM # 4A
AUGUST 27, 2012
The Atlantic Beach Police Department continues to have an exceptional emergency
response time. The average emergency response time for January through June of this
year was 1 minute 47 seconds.
Crime
The semiannual crime rate for 2012 showed a substantial decrease of 23% (188 vs 243)
when compared to the same time in 2011. Part 1 crimes include Murder, Rape, Robbery,
Aggravated Assault, Burglary, Larceny and Auto theft. The reductions are very evident
for both the entire city as well as the Mayport corridor where violent crime was more
than cut in half and all Part I crime was down 26 %. The most extreme reductions city-
wide are Rapes and Auto Thefts respectively.
Regardless of the very positive report on crime in general, AB continues to have a
problem with people driving under the influence. This year is no exception as DUI arrests
remain high, with 121 made during the just the first six months.
Productivity
The police department had over 10,000 calls for service in the first two quarters of 2012,
and made 435 arrests. While the Part I crimes were down, the number of arrests have
remained pretty consistent for many years.
The Crime Suppression Unit (CSU) continues to be very productive. They have made a
total of 58 arrests during this 6 month time period. They have also conducted 5 alcohol
deployments, which resulted in 7 arrests during this time.
Animal Control had 1222 calls during the first 6 months, which is up slightly from last
year (1191). Seventy eight Animal Control citations were issued which is a dramatic
decrease from prior years; however this is due to short staffing for several months.
Personnel
Currently the Police Department is fully staffed. There are no vacant positions.
Training
The Department is deeply committed to providing quality training to all its employees. In
the first quarters of 2012, employees have attended training in the following topics.
• Large Vehicle Operations
• General Instructor Techniques
• Crime Prevention through Environmental Design
• Interviews and Interrogations
• Emergency Animal Sheltering
AGENDA ITEM # 4A
AUGUST 27, 2012
• FBI -LEEDA Supervisor Liability
• Radar /Laser Speed Measurement
• Administrative Investigations for First Line Supervisors
• Excel 2007 Intermediate
• Property & Evidence training conference
• DUI Standardized Field Sobriety Testing
• Crime Scene Processing
• Domestic Drug Interdiction
• Courtroom Testimony
• Police Applicant Background Investigation
• Emotional Intelligence
• Glock Armorer
Advanced training keeps employees current and on the cutting edge of Public Safety
techniques, trends and strategies. The Department believes a better trained employee
results in the delivery of a higher quality of service. The above list does not include
classes taken by the employees who are enrolled in various college degree programs.
N
e-'
O
N
.L
to
N
Q)
CL
A �
W
r
O
CL
v
t�
O
Q.
i .
Cat
AGENDA ITEM # 4A
AUGUST 27, 2012
ol
0
0
o
a
o
0
0
0
o
o
a
\
o
\o
q
o
0
��
0
0
o•
0
0
0
0
0
0
0
�
0
o
0
o�
O
Co
CO
O
00
M
M
r
1�
r
O
"-I.
M
N
v
N'
co
(0
r
6)
O
0
M
M
M
O
(')
0
V)
r
M
M
NC
■
i
i
Y
i
,
r ...
e
N 0)
■
a
E
O
V
-
-
O
i-1
00
tD
CT
CO
M
00
N
Ln
c-I
M
m
ri
M
O S
cf
ri
m
rMi
u
m
M
(D
°�
d
N
h
co
m
U
O
.2 O
d'
O
M
.�-a
O
CIA
r-j
...
_V
O
M
W
W
N
m
m �
N
O
v i
m
o
00
m
m
1-4
W
m
h
0
rn
m
r+
M
o
m
en
'A
r+
m
r
N
-4-t
mot
�
a
,
m
�..�
m
m
`N
�s
v
0
cs
a
r
�r
r
o
Lo
�r
r
�r
Cl) M
M
CO 00
rn
O
Nt
to
u)
r`
M
r
(0
co W
o
u
m
u
cam-
N
r-
cr
r
N
r
to
6
d
N
"T
u
®
N
N
C00
CO
<"
M
M
L
r
N
000
co
O
Z�
M
O Lo
s. N
V)
r
N
_C
_C
d
E
E
O
O
O
O
D
O
O
O
O
O
p
O
�
O
o
O
�
o
p
O
�
O
O
O
�
O
O
p
U?
O
O
O
O
Cl
r
N
M
N
f-
Ct}
(�
N
0)
N
Lo
N
co
0o
GO
M
O
O
O
O
C)
W
'
to
O
w
h-
00
N
O
N a.
In
i
i
■
i
r
i
■
M�
i
■ Rf
r
E
N °
U
N
q
o
N
u
a
L11
1+
co
.n
N
Ln
("'
0)
'`
co
mm
a
r-i
M
Ln
m
m
LO
Ln
Ln
O
O
N
u
u
@ N
O
N
Q)
C
C
C
C
ra
uy
Ln
0
Ln
m
c(?
�
r"
00
Ln
ko
_i
N
q
R
w
00
14
0
n
00
Ln
f
R
m
c
Ln
le
N
N
Ln
m
O
r•
tf)
N
R
e-i
ri
N
5 V
w
c-I
c-{
t+!
00
to
�
N
N
M
N
E
N
ti?
u1•
:zr
�'
�•
Q3
O
"r
O
r
W
N
M
O
6)
M
0
M
r-
N
r~
0
00
U)
r
N
(O
00
(O
(U
r
h
(N
O
c1
cr
I t
r
O
N
N
M
C)
N
co
d
M
O
N
vi
Ln
O
00
r
CC7
0
co
d'
O
Cf
C
E
E
N
N
Cr
.N
le
(�-
N
N
e
0
O
Q
v
E
In
t"i)
(u
0
m
13
W
e
Q
o
d
¢
0
m
m
a
d
o¢
Of
E
E
w
C
a
O.
3
a
c
c
U
N
N
.+
ttt
C N
Q
t?
■��
U&
O
Uy
uy
a
a n
v
io
y
Q
d
O
O
c
o a t
E
m
c �
o
ca
U
o
Q
0
o
0
o
to
E
cn
a
�
�
¢
m
�
t
►°-
V
�
oo
ui
C%
V
LL
a
n
¢
¢
iiLUM
L L