Item 4A
~.
Cash Balances
City of Atlantic Beach
FINANCIAL REPORT
April, 2006
AGENDA ITEM 4A
MAY 22, 2006
Fund(s1
Prior Current
03131 /06 04/30/06
Dollar
Change
General
Tree Replacement
Convention Development Tax
Local Option Gas Tax
~„ Better Jax 1/2 Cent Sales Tax
Police Training, Forfeit, etc.
Grants
Debt Service
Utility
Sanitation
*"" Storm Water
Pension -Police
Pension -General
Total
Total Restricted Cash
Total Unrestricted. Cash
$6,108,922
30,978
170,151
438,077
925,396
1,619
(36,202)
50,875
3,720,054
543, 846
2,827,017
4,813
41,838
$14,827,384
$6,063,148
30,978
151,437
455,861
904,493
(904)
(35,824)
56,908
3,561,231
537, 021
2,780,346
(715)
58,100
$14,562,080
$6,557,002
$8,005,078
($45,774)
0
(18,714)
17,784
(20,903)
(2,523)
378
6,033
(158,823)
(6,825)
(46,671)
(5,528)
16,262
($265,304)
Cash and Investments
~. Prior Current Dollar Rate of
Account 3/31/06 4/30/06 Change Return
Bank of America -Depository
SBA
Cash on Hand
Subtotal
$159,337 $202,906
14, 665, 497 14, 356, 624
2,550 2,550
14, 827, 384 14, 562, 080
$43,569 3.84
(308,873) 4.85
0 -
(265,304)
Police Pension Investments
General Pension Investments
Subtotal
4,941,110
7,280,047
12, 221,157
5,032,742
7,435,389
12,468,131
91,632 5.60 (1)
155,342 5.90 (1)
246, 974
Total $27,048,541 $27,030,211 ($18,330)
(1) FYTD rate of return through 03/31 /06
~.
AGENDA ITEM 4A
City of Atlantic Beach MAY 22, 2006
~, FINANCIAL REPORT
April, 2006
~, Revenues
Annual YTD - 58% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
~.
General (1) $9,951,978 $5,802,003 $7,190,399 $1,388,396 23.93%
Tree Replacement 0 0 0 0 100.00%
"' Convention Development Tax 128,000 74,624 45,124 (29,500) -39.53%
Local Option Gas Tax 564,042 328,836 322,622 (6,214) -1.89%
Better Jax 1/2 Ct Sales Tax 702,336 409,462 440,171 30,709 7.50%
Police Training, Forfeit, etc. 31,800 18,540 13,468 (5,072) -27.36%
Grants (2) 508,111 296,228 76,312 (219,916) -74.24%
Debt Service 71,100 41,451 42,147 696 1.68%
,~, Utility (3) 6,685,534 3,897,667 3,709,398 (188,269) -4.83%
Sanitation 1,362,300 794,221 762,245 (31,976) -4.03%
Storm Water (4) 1,067,868 622,567 437,080 (185,487) -29.79%
Pension -Police 702,355 409,473 513,943 104,470 25.51
Pension -General (5) 1,015,029 591,762 902,670 310,908 52.54%
Total $22,790,453 $13,286,834 $14,455,579 $1,168,745
~.
Analysis of Major Variances
(1) The $1,388,396 positive variance in the General Fund resulted from having received
95.8% of the year's budgeted property taxes by April, 2006. Typically the majority of
these taxes are received from the City of Jacksonville in December & January.
(2) The $219,916 negative variance in the Grant Funds resulted from either items not
having been purchased or reimbursement requests not having been filed as of April 30,
2006.
(3) The $188,269 negative variance in the Utility F~and~. resulted from lower consumption
than budgeted. Consumption is billed in arrears and typically increases in the spring and
summer months.
(4) The $185,487 negative variance in the Stormwater Fund resulted from the award of a
grant in fiscal year 2006 that has not been received.
(5) The $310,908 positive variance in the General Employee Pension Fund resulted from
changes in the market values of the investments.
..
~.
City of Atlantic Beach
FINANCIAL REPORT
April, 2006
AGENDA ITEM 4A
MAY 22, 2006
Expenses
Annual YTD - 58% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $45,938 $26,782 $27,573 ($791) -2.95%
City Administration 2,119,933 1,235,921 1,132,178 103,743 8.39%
General Government (1) 2,240,185 1,306,028 817,748 488,280 37.39%
~* Planning and Building (2) 684,579 399,109 294,872 104,237 26.12%
Public Safety (3) 4,736,835 2,761,576 2,099,146 662,430 23.99%
Parks and Recreation 1,022,247 595,971 531,839 64,132 10.76%
Public Works (4) 6,214,842 3,623,253 2,642,135 981,118 27.08%
~.
Public Utilities 7,172,599 4,181,625 4,083,851 97,774 2.34%
Pension -Police 400,936 233,746 232,477 1,269 0.54%
Pension -General 405,798 236,580 237,136 (556) -0.24%
'"`" Total $25,043,892 $14,600,591 $12,098,955 $2,501,636
Annual YTD - 58% YTD Dollar Percent
~' Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services $7,899,947 $4,605,670 $4,225,207 $380,463 8.26%
Operating Expenses (2) & (3) 9,457,695 5,513,837 4,390,396 1,123,441 20.37%
~" Capital Outlay (1) & (3) 5,218,937 3,042,640 1,367,746 1,674,894 55.05%
Debt Service (4) 1,678,236 978,412 1,655,310 (676,898) -69.18%
Transfers 789 077 460,032 460,296 (264) -0.06%
~„ Total $25,043,892 $14,600,591 $12,098,955 $2,501,636
Analysis of Major Variances
(1) The positive variance in the General Government departments resulted from not having
begun the various budgeted projects -see the Project Activity Schedule.
(2) The positive variance in the Public Safety department is due to the payment for the City
of Jacksonville fire contract being paid quarterly, the lifeguard expenses being seasonal
and no expenditures in some of the grants.
(3) The majority of the positive variance in the Public Works department resulted from not
having begun the various budgeted projects -see the Project Activity Schedule. Also,
the waste management contract and First Vehicle are not billed and paid until the month
after the services are provided.
(4) The negative variance in the Debt Service departments resulted from the payment of
principal and interest on the Utility Revenue Bonds in the months of October & April.
City of Atlantic Beach
FINANCIAL REPORT
April, 2006
Project Activity -Current Year Activity Only
AGENDA ITEM 4A
MAY 22, 2006
Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
Parks and Recreation:
Beautification
Public Safety
Police Building Renovations
Homeland Security Items
PR0601 45,000 0 45,000
Subtotal 45,000 0 45,000
PS0504 475,000 2,570 472,430 D
PS0601 138,000 0 138,000
Subtotal 613,000 2,570 610,430
Public Works:
Plaza Entrance/Post Office PW0305 54,686 54,686 0
Hopkins Creek Basin Pond PW0309 1,300,000 0 1,300,000
Mayport Road Medians PW0401 346,858 55,858 291,000
Welcome Sign and Landscaping PW0405 78,000 52 77,948
~" Ocean/13th -Coast Drive/12th PW0409 141,816 141,797 19
Five Points Intersection Improvement PW0502 346,599 310,154 36,445
Sidewalks -New PW0503 26,175 26,175 0
,,,, Plaza Drive Phase 2 Pedestrian Path PW0504 37,500 37,109 391
Sidewalks -Replacements PW0505 5,864 5,864 0
Seminole Ditch Headwall PW0507 12,974 12,974 0
Pathway -Plaza (West of Mayport Road) PW0508 27,144 27,144 0
''~" Concrete Floor for Shed PW0601 8,800 8,800 0
Medians Rehab -Atlantic Boulevard PW0602 3,500 0 3,500
Roll Off Concrete Pads PW0603 10,000 0 10,000
^, Sidewalks & Curbs PW0604 50,000 3,592 46,408
Paving of City Hall Parking Lot PW0605 84,000 0 84,000
Pathways PW0606 149,000 0 149,000
Sidewalks - Sailfish,Royal Palm & Frances PW0607 90,800 446 90,354
Selva Tierra Ditch Improvements . PW0608 25,954 25,954 0
Pathway -Seminole Road Phase 1 PW0609 63,000 62,973 27
Pathway -Seminole Road Phase 2 PW0610 47,652 44,700 2,952
'"" Pathway -Seminole Road Phase 2 P11V~611 1.7,000 T 0 17,000
Traffic Isle -Mandalay Park 2,927,322 818,278 2,109,044
~, Public Utilities:
Security Upgrade/Water Plants PU0305 2,485 2,485 0
Headwork Improvements at WWTP2 PU0310 52,027 52,027 0
Water Line at 10th Street & Beach Avenue PU0503 83,446 83,446 0
Fence Replacement at Water Plant 1 PU0601 ' 70,000 0 70,000
Water Main at Sailfish Drive & Plaza PU0602 65,703 484 65,219
Sewer Crossing Ditch at Palm Landing PU0603 30,000 0 30,000
Genset at Lift Station B PU0604 44,650 0 44,650
Clarifier Rehabilitation PU0605 100,000 0 100,000
Fence Replacement at WWTP 1 PU0606 15,000 0 15,000
Sludge Container Refurbishment PU0607 15,000 0 15,000
~ Beach Habitat Subdivision PU0608 120 595 0 120,595
Subtotal _ 598 906 138,442 460,464
Total $4,184,228 $959,290 $3,224,938
Status Key
B -Bid Awarded E -Design Phase
'~ C -Project Completed I -Project In-progress
D -Design Completed R - Re-budget Next Fiscal Year
C
E
E
I
I
I
C
I
C
C
C
I
I
C
C
I
C
C
City of Atlantic Beach, FI.
Utility Sales Report
AGENDA ITEM 4A
MAY 22, 2006
~_, r
~,~~~ , ,..
-
April 2006 April 2005
;, ,
,..
.
,
Gallons Actual Revenue Gallons Actual Revenue
Water Sales Accounts (000) Revenue Per ~,ooo g~ Accounts (000) Revenue Per 1,000 gi
,_ -~~ .
Atlantic Beach 5,574 47,473 $113,915 $2.40 5,507 40,357 $93,951 $2.33
Buccaneer 2,609 25,524 $68,561 $2.69 2,705 26,301 $68,293 $2.60
Total Water Sales 8,183 72,997 $182,478 $2.50 8,212 66,658 $162,244 $2.43
Water Plant Production
Gallons Gallons
(000) (000)
Atlantic Beach 62,394 59,916
Buccaneer 25,495 20,754
Total Production 87,889 80,670
Total Water Billed 72,997 66,658
Water Loss for month: 14,892 14,Oi2
Percentage Loss 16.94% 17.37%
Total 12 mo. Avg. Loss 10.18% 10.11
Gallons Actual. Revenue„ Gallons Actual Revenue
Sewer Sales Accounts (000) Revenue Per ~,00o gl Accounts (000) Revenue Per 1,000 g~
Atlantic Beach 5,040 37,493 $167,538 4.47 4,961 32,560 $141,937 4.36
Buccaneer 2,491 24,167 $131,797 5.45 2,591 24,452 $127,580 5.22
Total Sewer Sales 7,531 61,660 $299,335 $4.85 7,552 57,012 $269,517 $4.73
Sewer Treatment
Millions of Gallons 71.63 81.10
Rev. er 1,000 Gallons $4.18 $3.32
n
a
m
0
3
A
Lei
a
3
0
0
~- -i D
~ ~ M
w '- .`-.
'° a
A
m
d
a
c
A
lACj ~`
N ~ c ~
up~.m
O G tC ~.
°~-'~Omm°
~ ~ CI
Ot~ ~ ~ 7
p'< ~ w <
n y j .yw
l (O N d
y .d.. c.
• ~ O
O ~ N N
y C
b
N
O
O
W
O
1
O
N
O
Oi
AGENDA ITEM 4A
MAY 22, 2006
~ o ~ ~
rn
rti 'D 3
a ~ ~. ~
f7 m
1 1
3 A
a ~ ~
c
c
~ m
m ~
N 03
i.w ~
w ,,,~
w ~
~G
7 .~
~ ~
N
N
O
O
N
a
a
b
N
O
O
W
L
0
N
O
O
A
D
v
1
O
N
O
O
D
O
N
O
O
01
~.
NR
~.
~w
~.
Om
a'rn Omra-°a Omrn3i ~vmra-~ ~°m~~
r
r ° r r ° ~
l ~ l
~ ° I
N rn
v ~z
m N ~ ~ zl
=
~ v o
~ ~, -~z
~ o -nz
~ a
~ ~Z
~
v o v v v
AGENDA ITEM 4A
MAY 22, 2006
O~d*
cn ~ A a ~ W o 0 0 ~ o ~ o 0 o S`~9~jp
a~'~n
C7 N A (T -~ A O O O
,
~
o
0
0
o
No`yd1
~7~'~
~ o ~ ~ o -~ a o A o 0 0 0 0 0 ~N`SN
~~
O W O -~ O N ~ A ~ W N O N ~N\~N
O O O ~ ~ O N N O OVD OVO O Oo 00 0 O SN.n`S
nil
~ C T A fD A CT A -+ W W O W W O W NS`~~
p~~!
tO N V ao CD N v w A N ~ -+ N N O ~rU~bda
No`~
W C A ~I cn N W N .~ ~ W A N W N W ndM~o y
`NpZ
' ' N 7 ~ A CD O 01 S` ~N
.
W N -• W O W ~ ~ O ,
C ~
S
S.~
p~d
A ~ W W QN1 v V v 0 A W -+ p N W 5~~~~N~n
~1
NS
~l01-~1 •• o
o 0 0 0 0 0 0 0 0
~a NcClO ~~"' ycoo
1dW~Nd
0 o SNO~ld 1`'J
N'~~
o ~ S1d 1pL O
c w m~za-r~3oc~
W
on ~ ~ ~ z- v z m v
~z-ramvva
,`d7~~.
w w o S~~9WnN ~r'poN
0 0 0 did M LNdN~d 1S