Exh 4ACity of Atlantic Beach
FINANCIAL REPORT
JULY 2005
AGIrNDA ITIJM #4A
AUGUST 22, 2005
Cash Balances
Prior Current Dollar
Fund(s) 06/30/05 07/31!05 Change
General $5,067,431 $4,807,170 ($260,261)
Tree Replacement 30,978 30,978 0
Convention Development Tax 130,454 138,053 7,599
Local Option Gas Tax 330,964 335,634 4,670
Better Jax 112 Cent Sales Tax 1,001,480 1,047,461 45,981
Police Training, Forfeit, etc. 30,802 34,220 3,418
Grants (38,098) (23,423) 14,675
Debt Service 57,451 63,640 6,189
Capital Project 0 0 0
Utility 4,170,648 4,189,379 18,731
Sanitation 641,314 635,686 (5,628)
Storm Water 2,653,722 2,823,164 169,442
Pension -Police 10,064 20,366 10,302
Pension-General 51,068 (294) (51,362)
Total $14,138,278 $14,102,034 ($36,244)
Total Restricted Cash $6,308,222
Total Unrestricted Cash $7,793,812
Cash and Investments
Prior Current Dollar Rate of
Account 06!30/05 07/31/05 Change Return
Bank of America -Depositary $58,023 $33,282 ($24,741) 2.03
SBA $14,078,205 $14,066,702 (11,503) 3.07
Cash on Hand $2,050 $2,050 0 -
Subtotal 14,138,278 14,102,034 (36,244)
Suntrust-Pension-Police 4,091,772 4,153,131 61,359 6.10 (1)
Merrill Lynch-Pension-Police 460,114 480,100 19,986 14.50 (1)
Suntrust-Pension-General 5,562,619 5,736,826 174,207 6.10 (1)
Merrill Lynch-Pension-General 976,356 1,018,765 42,409 14.50 (1)
Subtotal 11,090,861 11,388,822 297,961
Total $25,229,139 $25,490,856 $261,717
(1) FYTD rate of return through 06/30/05
City of Atlantic Beach AGEi~1DA ITEM #4A
FINANCIAL REPORT AucusT 22, 2aos
JULY 2005
Revenues
Fund / (Footnote) Annual
Estimate YTD - 83%
of Estimate YTD
Actual Dollar
Variance Percent
Variance
General (1) $9,274,236 $7,725,439 $8,366,615 $641,176 8.30%
Tree Replacement 13,778 11,477 13,778 2,301 20.05%
Convention Development Tax 177,000 147,441 169,996 22,555 15.30%
Local Option Gas Tax 519,800 432,993 456,888 23,895 5.52%
Better Jax 112 Ct Sales Tax (2) 617,300 514,211 585,678 71,467 13.90%
Police Training, Forfeit, etc. 33,180 27,639 27,611 (28) -0.10%
Grants (3) 392,109 326,627 380,925 54,298 16.62%
Debt Service 73,035 60,838 61,439 601 0.99%
Capital Project 0 0 286 286 0.00%
Public Utilities (4) 6,627,412 5,520,634 5,508,694 (11,940) -0.22%
Sanitation 1,413,367 1,177,335 1,199,063 21,728 1.85%
Storm Water 2,608,063 2,172,516 2,208,853 36,337 1.67%
Pension -Police (5) 523,361 435,960 584,588 148,628 34.09%
Pension -General (5) 775,943 646,361 1,022,500 376,139 58.19%
Total $23,048,584 $19,199,471 $20,586,914 $1,387,443
Analysis of Major Variances
(1) The $641,176 positive variance in the General Fund resulted primarily from the receipt
of 99.2% of the property taxes from the City of Jacksonville having been received in the
first ten months of fiscal year 2005.
(2) The $71,467 positive variance in the Better Jacksonville '/~ Cent Sales Tax Fund
resulted from 95.9% of the revenues from the State of Florida having been received in
the first ten months of fiscal year 2005.
(3) The $54,298 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 in the
FDOT -DUI Enforcement Grant.
(4) The $11,940 negative variance in the Public Utilities Funds resulted from the revenues
generated by the charges for services deficit of $162,686 offset by the other revenues in
these funds for the first ten months of fiscal year 2005.
(5) The $376,139 positive variance in the General Employee Pension Fund resulted from
increases in the market values of the investments above estimates. The Police
Employee Pension Fund has not received the Section 185 funds and therefore the
variance for better than expected investment returns is not evident in this schedule.
City of Atlantic Beach AGf/h'DA ITE)VI #~A
FINANCIAL REPORT AucusT 22, Zoos
JULY 2005
Expenses
Annual YTD - 83% YTD Dollar Percent
• Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $47,607 $39,657 $37,948 $1,709 4.31%
City Administration 2,037,979 1,697,636 1,539,563 158,073 9.31%
General Government (1) 4,102,314 3,417,228 2,798,418 618,810 18.11%
Planning and Building 774,953 645,536 548,847 96,689 14.98%
Public Safety 4,148,554 3,455,747 3,274,773 180,974 5.24%
Parks and Recreation 981,209 817,348 764,721 52,627 6.44%
Public Works (2) 5,944,450 4,951,727 3,169,309 1,782,418 36.00%
' Public Utilities (2) 7,669,539 6,388,722 5,700,164 688,558 10.78%
Pension -Police 337,266 280,943 267,316 13,627 4.85%
Pension -General 382,231 318,398 300,969 17,429 5.47%
• Total $26,426,102 $22,012,942 $18,402,028 $3,610,914
Annual YTD Estimate YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services $7,410,405 $6,172,866 $5,828,567 $344,299 5.58%
• Operating Expenses (3) 8,919,866 7,430,249 6,255,588 1,174,661 15.81%
Capital Outlay (1) & (2) 5,306,159 4,420,030 2,029,609 2,390,421 54.08%
Debt Service 1,647,725 1,372,555 1,647,711 (275,156) -20.05%
' " Transfers 3,141,947 2,617,242 2,640,553 23,311 -0.89%
Total $26,426,102 $22,012,942 $18,402,028 $3,610,914
Analysis of Major Variances
(1) The positive variance in the General Government departments resulted from a less than 83% completion
status of some of these projects funded from this source -see the Project Activity Schedule. The variance
includes: the Mayport Road Medians, the Plaza Road Entrance for the Post Office and the Five Points
Intersection Improvements.
(2) The positive variance in the Public Works & Public Utilities departments resulted from not having begun
or a less than 83% completion status of some of the various projects funded from this source -see the
Project Activity Schedule. The largest of these projects is the Hopkins Creek Drainage project that has not
begun due to issues surrounding the land acquisition.
(3) The positive variance in the Operating Expenses resulted from the following expenses being less than
the budgeted amounts: Super Bowl and the Fire Contract in the General Fund, professional and other
contractual services in the Sewer Fund and the Solid Waste Contract in the Sanitation Fund.
City of Atlantic Beach
FINANCIAL REPORT
JULY 2005
Project Activity -Current Year Activity Only
AGENDA ITI;bI #4A
AUGUST 22, 2005
YTD YTD YTD
Project Name Budget Actual Balance Status
General Government:
City Hall Expansion
Parks and Recreation:
Skateboard Park
Veteran's Memorial Park
Public Safety
Police Building Design
$462,805 $410,974 51,831
Subtotal 462,805 410,974 51,831
195,927 195,780 147 C
22,963 22,963 0 C
Subtotal 218,890 218,743 147
30,000 275 29,725
Subtotal 30,000 275 29,725
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 Drivel12th
Shed -Equipment Storage
Five Points Intersection Improvement
Sidewalks -New
• Pedestrian Path -Plaza Road
Sidewalks -Replacements
• ~ 19th Street Ditch Bulkhead
Seminole Ditch Headwall
Subtotal
• - Public Utilities:
Telemetry for Water System
• Replace Well 2 at WWTP1
• Security Upgrade/VVater Plants
Telemetry at Lift Stations
Headwork Improvements at WWTP2
Relocate Elevated Storage Tank at WP2
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
100,000 2,215 97,785
1,423,149 21,405 1,401,744
301,942 11,648 290,294
97,930 97,930 0
230,291 170,220 60,071
37,600 1,927 35,673
137,000 19,300 117,700
15,000 12,637 2,363
315,000 31,453 283,547
61,500 9,616 51,884
75,000 2,150 72,850
50,000 2,898 47,102
12,000 0 12,000
35,000 0 35,000
2,891,412 383,399 2,508,013
6,043 6,043 0
6,389 6,389 0
14,864 14,864 0
90,811 90,811 0
362,382 115,399 246,983
89,108 81,938 7,170
56,123 29,537 26,586
24,500 17,000 7,500
287,292 46,129 241,163
64,663 6,656 58,007
105,550 97,290 8,260
45,000 44,212 788
60,000 51,417 8,583
122,386 122,386 0
1,335,111 730, 071 605,040
$4,938,218 $1,743,462 $3,194,756
• Status Key
A -Bid Advertised D -Design Completed
B -Bid Awarded E -Design Phase
• C -Project Completed I -Project In-progress
A
E
E
E
C
I
E
E
E
I
E
I
C
C
C
C
E
I
C
I
C
AGirNDA ITEM #4A
AUGUST 22, 2005
City of Atlantic Beach, FI.
Utility Sales Report
July 2005 July 2004
Gallons Actual Revenue Gallons Actual Revenue
Water Sales Accounts (000) Revenue Per 1,000 gl Accounts (000) Revenue Per 1,000 gl
Atlantic Beach 5,559 52,308 $122,594 $2.34 5,472 53,500 $104,451 $1.95
Buccaneer 2,736 28,437 $72,824 $2.56 2,685 29,054 $68,098 $2.34
Total Water Sales 8,295 80,745 $195,417 $2.42 8,157 82,554 $172,549 $2.09
Water Plant Produc
~ tion
:
Gallons Gallons
(000) (000)
Atlantic Beach 64,388 67,968
Buccaneer 24,777 25,612
Total Production 89,165 93,580
Total Water Billed 80,745 82,554
Water Loss for month: 8,420 11,026
Percentage Loss 9.44% 11.78%
Total 12 mo. Avg. Loss 10.72% 13.60%
I Sewer Sales
Atlantic Beach
Buccaneer
Total Sewer Sales
I Sewer Treatment
Millions of Gallons
Rev, per 1,000 Gallons
Gallons Actual Revenue Gallons Actual Revenue
Accounts (000) Revenue Per 1,000 gl Accounts (000) Revenue Per 1,D00 gl
5,018 39,887 $170,115 4.26 4,921 38,573 $152,987 3.97
2,602 26,962 $135,829 5.04 2,575 26,791 $130,417 4.87
7,620 66,849 5305,944 $4.58 7,496 65,364 5283,404 $4.34
92.69
73.80
53.84
v ~ v ~n -i cn ~ ~ 3 -v m cn ~ G~ cn ~ c ~*+ v c~ a v cn O n ~ v cn -n
rn _ ~ ~ ~ o ~ O rn r r ~ rn y x 0 --~ m rn O v c Z -~ O rn c
' z m
z - m - - ~ n c rn r u m o r= z n 3 v v
'
0 = 3 3 ~ ~
~
o
- v
O m 3
~ m
~ z
O G~
~ ~
= =
a ~
W n
~ y r
cn a
O v
c~ -n
Z -
~ n
m 7C
cn ~
rn -~
O r
rn r
-
rn m
~ 3
rn 0
v r
~ r
rn ~
3 ~ ~
a z m 'o z z - rn O ~ ~ z ~ -n ~ rn -n -i
O VA -~ 0 3 ~ CL O D v C~ ~ a n [ 3 ...~
r r = a ~
O ~ O D O y r m r 3 C ~ -~ r p r '
G
r O -
C m
D ~ u~i O O x v rn a o
~
r a
m
to
I
,.
~z
C
..- i
A
O v
~
; ~ V t
D ~P ?~NO W
m
~ o
~P
t0
V ~7f N W Oa .P W ~ N V N -~ ~ N W N -- ~ N N ~ O
'r1
3'
.a .a
v '~
f~ o~i ~ ~n a' a~ vo~
0 3
'~ ~+ ,_~
~ ~
m ~
3 ~
~ ~
N _
00
O1
V W
W
t7~
V
0 .p
Qf ~'
~
W "'~
~
O OD
~ ..~
N N
-0.
'V
t0 00
O
W ~
O ~+
A
~
,p, V
-+
tO i
A
N O O
W LA
A V •
(/)
O
O
O 0
C
C N W O O V ~7f b~ ..- .-~
O
O
O p
O
O
O O
O O
O N
O O
O O
0 G
0 O
0 O
0 O
0 pp
0 ~
0 O
0 <if
0 m
v j
pf
..a
N
.i-
-+
fh
~P
N
io
Q~
U~
O
-+
O
Uf
Q~ N
N O C1
OD
O
N
-+
A
tO
Of
' O
O,p O
Z ~
W V
N IJ
OO i•
N V
O O z
O
1s
W
O
-+
A ~
07
= 0
o 0
0 0
0 0
0 0
0 0 ~
o C
~
n
L z
- a
~ r
~{ r
C
C c ~
N
~
~
Z
~
~
N o
j p z
.ia ~ W W W N w N -~01
W
0 a
w ,
~ w
~ a
N
~
°~
a
w
~. N t
0 w ~. ~ _ v
i r
c
r :~
~p o
O A o
O r
-~
OD ~.
O ~
,A, o
O ~a
O c~
~1 ~ r
V C w
01 ~
N r
m
O w
N w
W ao
V
W s O O O O 0 ,,,~ O N N N rn tD f7f O OD OD OD
O
0 O
0 C
o C
c O
o O
0 O
o 0
p ~
o 0
o 0
o 0
o 0
0 0
0 0
0 0
0 0
0 0
0
O ~ -I ~ -o c~ N OO 3 -+ 3 ~ m n ooZ
A rn
o o
n N
n ~
' p O c ~
n ~ m r r" O
z cy
v
z ° m z v r" x ~ n c
i vrn -~
o
m Z C z O ~ n p y Z Z ~ m ~~ ooh
v ~ 3 ~ n O n m O r
oA
r ~ r N ,
,
N
' 'O
z 9
~ m
~~
W
W
N
N
O1
y
N
W
I~
ti
~-
~
tND
p T
W O n.i
tpON O
Z
3 O0 °
i~
o t
rn N
v
AGENDA ITEM #4A
AUGUST 22, 2005
a
Z
m
Q
m
L
r
N
0
v
A
C
m
i
0
b
"''
m
c
r
N
O
0
r~
m
O
Z
'i1
Z
~~
L'
C
N
0
0
~Jf