Item 4A
^.
~R
A G ENDA ITEM #4A
JA NUARY 23, 2006
. N
Z N W
~~N W
~ O
~ T
U>
N
<O
M
00
M
O
N
M
e-
~
~
0
N
~
0
~
0
0
N
N
O
M
~ N
~
a a ?
~
+
~ ~
Z
O
V J
a J
a
~
N Z W a-, ? Z ~ V Z Z Z W
W ~ Z ~ ~
N~
?m O J J W
~
~
m
N
U
a ~ E-
~ y
~ W
V W G. F
-- ~ ~ O
O 0
0 0
0 0
0 0
0 0
0 0
0
~ o
o o
o o
o o
o o
er> m
~o o
v~ o
o o
v~ o
~ o
u~ o
u~ o
er~ o
~ o
s~s ~o
~rs o
w o
v~ o
u~ o
o o
u~ ,o
~ o
us o
o
W N 000 ~ O M O Q W ~
~ ^
~ ~
~ d- ~ 10A r O
/
LL ~ v_
M o~
~ o~
lf' c~
000 c~
0 t-
00 N
~ ~
~ N r {R ~ O ~
e- M
~ <D
~ e~ N
~ d'
W
Z, H-
fq
kfi r
iR ti
v~
"_ N Z 0~
N ~ ~ m O
1
O O G
> ~ ~
~ W ~
_
~"' N O ~ W y
N , ~ z
Q w
m ~ ~ O V
'' m V
J W ~ =
V
~
o
~ ~
o
o
o
o
o
o
r~
°
o
o F
-
Z
W r
i
Z ~ w o ~o
~ N
V ui
~O e`i
~ r:
c9 M
M N
0A ~
O LL
O Q NN N tO e+ fA 00 Q
c G~ ~ w ~ N W
C ~ °O ° ° ° ° ° ° ° ° ° ° ° ° °
= ~ ~ ~ O, o o o o o o o oo, o o o o o, °o °o °o °o °o °o °o °o °o o°
~...
Z V)
V' ~ 0
~ ~"~
CA 0
fR 'A
~ 0
fA 0
N 'L~
el
N O
fR N
N
f~ O
fA ~A
ti
r O
/A O
4f) M
~
O I~
r
<O ~A
OD
O 0
M ,
0
to 0
iH O
Y! O
00 C
P ,
O
{A O
O N
~
W ~
~ ~'
~
~'
~
'~ ~ Vl ~ ~
Q ~ a ~
~ ~
Z O
~ O
v ~
a a
~
z
~~
W No
a o1A o
M ~
N m
M r~l
0>
t~ o
C'~
N N
~
m O LL~ g
O W ~
Q. ~
~ ~ N ~ O O OD O N O N O O N N M O O O e- C7 ~ M ~
w c
~
~I
0 a
ON N ~
r 0
f
r Z
~ ~
Z
Z J
~
w
o
x
~
o
~'
~
a
a ~ o ~ ~ J O W, ~ a °o a o Z O
~
a
]
Q
t~
~
a
_
-
~l
-
a Z
~
G
Q ~
a
C
Y
~
a
a
}
p
> ~-
~
W
G
W
~ ~
W ~ t~ Z ? ~
N ~
D ~
~ v~
0 O
~
~ J
C9 J
0 O
~ B
~ W
= J
O LI,I
J
d ~
-
O ~
~ fn
Y
V W
() ~
-
J Z
LL
O f/)
p
W C7
~ N
J
J ~
Z ~
W m
j a
=
U =
~
C9 O
Z
W ~
~ W
~
Z O
~
w z .
~ w o F- Z ~ c o w Z
w ~ o x a W ~? ~ ~ W o ~ ~ 1
~ 3 ~ - W
a. m o ~ c~ o in o a t~ o a. ~ ~ v~ t9 3~ n w a ~ a ~ v~ F- m o 3 o
AGENDA ITEM #4A
City of Atlantic Beach JANUARY 23, 2006
FINANCIAL REPORT
DECEMBER 2005
Cash Balances
Prior Current Doilar ,
Fund(s) 11/30/05 12/31105 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,360,515
$7,865,271
Cash and Investments
Prior Current Doflar Rate of
Account 11/30/05 12!31/05 Change Return
Sank of America -Depository $172,459 $254,715 $82,256 3.16
SBA 17,486,262 13,968,521 1,482,259 4.23
Cash on Hand 2,550 2,550 0 -
Subtotal 12,661,271 14,225,786 1,564,515
Suntrust-Pension-Police 4,279,305 4,294,503 15,198 7.50 (1)
Merrill Lynch-Pension-Police 525,836 552,918 27,082 28.60 (1)
Suntrust-Pension-General 5,791,132 5,812,353 21,221 7.60 (1)
Merrill Lynch-Pension-General 1,115,752 1,173,222 57,470 28.60 (1)
Subtotal 11,712,025 11,832,996 120,971
Total $24,373,296 $26,058,782 $1,685,486
(1) FYTD rate of return through 09/30/05
$3,764,806 $5,712,916 $1,948,110
30,978 30,978 0
163,309 152,575 (10,734)
367,787 386,221 18,434
1,028,928 964,913 (64,015)
23,727 12,281 (11,446)
40,314 (34,507) (74,821)
88,243 32,938 (55,305)
3,440,648 3,391,987 (48,661)
658,577 551,550 (107,027)
2,997,487 2,951,569 (45,918)
(421) (5,996) (5,575)
56,888 78,361 21,473
$12,661,271 $14,225,786 $1,564,515
~.
City of Atlantic Beach
~• FINANCIAL REPORT
DECEMBER 2005
Revenues
AGENDA ITEM #4A
JANUARY 23, 2006
Annual YTD - 25% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $9,951,978 $2,487,995 $3,755,189 $1,267,194 50.93%
Tree Replacement 0 0 0 0 100.00%
Convention Development Tax 128,000 32,000 21,211 (10,789) -33.72%
Local Option Gas Tax 564,042 141,011 142,093 1,082 0.77%
Better Jax 1/2 Ct Sales Tax 702,336 175,584 185,594 10,010 5.70%
~"' Police Training, Forfeit, etc. 31,800 7,951 4,850 (3,101) -39.00%
Grants (2) 447,833 111,958 49,763 (62,195) -55.55%
Debt Service 71,100 17,775 18,177 402 2.26%
,.,. Utility 6,623,534 1,655,883 1,636,631
(19,252)
-1.16%
Sanitation 1,362,300 340,575 326,876 (13,699) -4.02%
Storm Water (3) 1,067,868 266,967 185,482 - (81,485) -30.52%
~. Pension -Police 702,355 175,589 188,293 12,704 7.24%
Pension -General (4) 1,015,029 253,757 329,637 75,880 29.90%
Total $22,668,175 $5,667,045 $6,843,796 $1,176,751
Analysis of Major Variances
(1) The $1,267,194 positive variance in the General Fund resulted from having received
60% of the year's budgeted property taxes in December, 2005. Typically the majority of
these taxes are received from the City of Jacksonville in December & January.
(2) The $62,195 negative variance in the Grant Funds resulted from either items not having
been purchased or reimbursement requests not having been filed as of December 31,
2005.
(3) The $81,485 negative variance in the Stormwater Fund resulted from the award of a
grant in fiscal year 2006 that has not been received.
(4) The $75,880 positive variance in the General Employee Pension Fund resulted from
changes in the market values of the investments.
City of Atlantic Beach
~„ FINANCIAL REPORT
DECEMBER 2005
AGENDA ITEM #4A
JANUARY 23, 2006
Expenses
Department / (Footnote)
~.
Governing Body
City Administration
General Government (1)
~"' Planning and Building (2)
Public Safety (3)
Parks and Recreation
~, Public Works (4)
Public Utilities (5)
Pension -Police
Pension -General
"~ Tota I
Resource Allocation
Personal Services
Operating Expenses (2) - (4)
'"" Capital Outlay (1), (4) & (5)
Debt Service (5)
Transfers
~. Total
Annual
Estimate YTD - 25%
of Estimate YTD
Actual Dollar
Variance Percent
Variance
$45,938 $11,485 $12,016 ($531) -4.62%
2,122,737 530,685 440,302 90,383 17.03%
2,165,615 541,404 352,215 189,189 34.94%
591,118 147,779 107,710 40,069 27.11%
4,714,649 1,178,660 718,633 460,027 39.03%
1,023,072 255,769 224,394 31,375 12.27%
6,136,758 1,534,190 994,660 539,530 35.17%
7,115,581 1,778,896 2,136,157 (357,261) -20.08%
400,936 100,234 96,989 3,245 3.24%
405,798 101 450 93 656 7 794 7.68%
$24,722,202 $6,180,552 $5,176,732 $1,003,820
Annual YTD - 25% YTD Dollar Percent
Estimate of Estimate Actual Variance Variance
$7,909,947 $1,977,487 $1,623,302- $354,185 17.91%
9,481,128 2,370,283 1,659,617 710,666 29.98%
4,863,814 1,215,954 440,147 775,807 63.80%
1,678,236 419,559 1,256,397 (836,838) -199.46%
789,077 197,269 197 269 0 0.00%
$24,722,202 $6,180,552 $5,176,732 $1,003,820
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 Planning 8 Building departments resulted from no monies
being expended in the Community Development Block Grant as of December 31, 2005.
(3) 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 2006 for October through December 2005. Also, the police
union contract has not been approved as of December 31, 2005 so salaries and benefits
are less than the amount budgeted.
(4) The positive variance in the Public Works departments resulted from the waste
management contract and First Vehicle not having been paid in October 2005 and not
having begun various projects funded from this source -see Project Activity Schedule.
(5) The negative variance in the Public Utilities department resulted from the October
payment of principal and interest on the Utility Revenue Bonds and is partially offset by
not having begun various projects funded from this source -see Project Activity
Schedule.
City of Atlantic Beach
FINANCIAL REPORT
DECEMBER 2005
Project Activity -Current Year Activity Only
AGENDA ITEM #4A
JANUARY 23, 2006
Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
General Government:
City Hall Expansion
Parks and Recreation:
Beautification
GG0402 $2,816 $0 $2 816
Subtotal 2,816 0 2 816
PR0601 45,000 0 45 000
Subtotal 45,000 0 45,000
~* Public Safety
Police Building Renovations PS0504 475,000 2,570 472,430 D
Homeland Security Items PS0601 138,000 0 138 000
~. Subtotal 61.3,000 2 570 610 430
Public Works:
Plaza Entrance/Post Office PW0305 55,080 54,687 393 I
""" Hopkins Creek Basin Pond PW0309 1,301,500 0 1,301,500 E
Mayport Road Medians PW0401 346,858 0 346,858 E
Welcome Sign and Landscaping PW0405 78,000 0 78,000
~,. Ocean/13th -Coast Drive/12th PW0409 139,116 2,745 136,371 I
Five Points Intersection Improvement PW0502 346,643 125,333 221,310
Sidewalks -New PW0503 23,795 0 23,795
Sidewalks -Replacements PW0505 10,752 5,864 4,888 I
Seminole Ditch Headwall PW0507 12,974 0 12,974 I
Pathway -Plaza (West of Mayport Road) PW0508 24,676 0 24,676 I
Concrete Floor for Shed PW0601 8,800 0 8,800 I
*~ Medians Rehab -Atlantic Boulevard PW0602 20,000 0 20,000
Roll Off Concrete Pads PW0603 10,000 0 10,000
Sidewalks & Curbs PW0604 50,000 1,160 48,840 I
~„ Paving of City Hall Parking Lot PW0605 84,000 0 84,000
Pathways PW0606 88,000 0 88,000
Sidewalks - Sailfish,Royal Palm & Frances PW0607 90,800 0 90,800
Selva Tierra Ditch Improvements PW0608 25,954 0 25,954 I
"'" Pathway -Seminole Road Phase 1 PW0609 62,000 0 62,000
Pathway -Seminole Road Phase 2 PW0610 0 0 0
Subtotal 2,778,948 189,789 2 589 159
,, Public Utilities:
Security Upgrade/Water Plants PU0305 2,485 2,485 0 C
Headwork Improvements at WWTP2 PU0310 52,027 52,027 0 C
Water Line at 10th Street & Beach Avenue PU0503 99,776 31,138 68,638 I
Mayport Road Sewer Crossing PU0504 50,000 0 50,000
Fence Replacement at Water Plant 1 PU0601 70,000 0 70,000
Water Main at Sailfish Drive & Plaza PU0602 60,000 0 60,000
~* Sewer Crossing Ditch at Palm Landing PU0603 30,000 0 30,000
Genset at Lift Station B PU0604 44,650 0 44,650 I
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
Subtotal 538,938 85,650 453,289
Total $3,978,702 $ 278,009 $3,700,693
Status Kev
B -Bid Awarded E -Design Phase
""' C -Project Completed I -Project In-progress
D -Design Completed R - Re-budget Next Fis cal Year
~.
~.
,°.
AGENDA ITEM #4A
JANUARY 23, 2006
,. ,
December 2005 December 2004
Gallons Actual Revenue Gallons Actual Revenue
Water Sales Accounts (000) Revenue Per 1,000 gi Accounts (000) Revenue Per 1,000 gl
„~-~-
Atlantic Beach 5,601 45,444 $110,937 $2.44 5,480 49,391 $120,367 $2.44
Buccaneer 2,676 25,982 $67,511 $2.60 2,663 28,982 $69,390 $2.39
Total Water Sales 8,277 71,426 $178,448 $2.50 8,143 78,373 $189,757 $2.42
I Water Plant Production
Gallons Gallons
(000) (000)
Atlantic Beach 55,036 57,601
Buccaneer 19,285 22,856
Total Production 74,321 80,457
Total Water Billed 71,428 78,373
Water Loss for month: 2,895 2,084
Percentage Loss 3.90°k 2.59%
Total 12 mo. Avg. Loss 9.93% 12.19%
Gallons Actual Revenue Gallons Actual Revenue
Sewer Sales Accounts (000) Revenue Per 1,000 gi Accounts (000) Revenue Per 1,000 gi
Atlantic Beach 5,012 34,877 $159,194 4.56 4,924 37,364 $162,727 4.36
Buccaneer 2,544 24,522 $134,430 5.48 2,548 27,847 $144,241 5.18
Total Sewer Sales 7,556 59,399 $293,624 $4.94 7,472 65,211 $306,968 $4.71
City of Atlantic Beach, FI.
Utility Sales Report