Item 4ACity of Atlantic Beach JANUARY i ioo9
FINANCIAL REPORT
NOVEMBER 2008
Cash Balances
Fund(s)
Prior
10/31 /08
$4, 824, 377
31,183
214,523
203,994
757,672
203,491
30,125
83,081
360,753
2,521,910
333, 924
152, 581
2,444,403
82, 555
93,488
$12,338,060
Current
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
Capital Projects
Utility
Sanitation
Building Code Enforcement
Storm Water
Pension -Police
Pension -General
Total
Total Restricted Cash
Total Unrestricted Cash
Prior Current
10/31 /08 11 /30/08
Cash and Investments
Account
Bank of America -Depository
SBA
Banc of America Securities LLC
Cash on Hand
Subtotal
Police Pension Investments
General Pension investments
Subtotal
$5,602,301
1,361
6,731,848
2,550
12,338,060
11 /30/08
$5,073,039
34,693
214,503
187, 611
767,665
202, 825
0
88,781
388,218
2,466,676
274,170
160,470
2,527,687
69,670
116,307
$12,572,315
$7,391,245
$5,181,070
$248,662
3,510
(20)
(16,383)
9, 993
(666)
(30,125)
5,700
27,465
(55,234)
(59,754)
7, 889
83,284
(12,885)
22.819
$234,255
Dollar Rate of
Change Return
$5,835,074
1,356
6,733,485
2,400
12,572,315
5,110, 387
8, 095, 745
13,206,132
Total $25,544,192
4,450,898
7,053,879
11, 504,777
$232,773
(5)
1,637
(150)
234,255
0.31
1.42
0.15
(659,489)
(1,041,866)
(1,701,355)
(11.64) (1)
(12.10) (1)
$24,077,092
($1,467,100)
(1) FYTD rate of return through 09/30/08
AGENDA ITEM # 4A
City of Atlantic Beach JANUARY 12, 2009
FINANCIAL REPORT
NOVEMBER 2008
Revenues
Fund / (Footnote) Annual
Estimate YTD -16.6%
of Estimate YTD
Actual Dollar
Variance Percent
Variance
General (1) $10,538,732 $1,759,968 $1,620,237 ($139,731) -7.94%
Tree Replacement 0 0 3,510 3,510 100.00%
Convention Development Tax 94,000 15,698 10,820 (4,878) -31.07%
Local Option Gas Tax 530,872 88,656 68,235 (20,421) -23.03%
Better Jax 1/2 Ct Sales Tax 732,630 122,349 113,968 (8,381) -6.85%
Police Training, Forfeit, etc. 40,150 6,706 4,009 (2,697) -40.22%
Grants 214,284 35,785 30,125 (5,660) -15.82%
Debt Service 69,500 11,607 11,482 (125) -1.08%
Capital Projects 335,000 55,945 55,280 (665) -1.19%
Utility 7,551,075 1,261,030 1,305,600 44,570 3.53%
Sanitation 1,880,500 314,044 311,348 (2,696) -0.86%
Building Code Enforcement 207,500 34,653 59,120 24,467 70.61
Storm Water 2,377,000 396,959 388,692 (8,267) -2.08%
Water/Sewer Construction (2) 1,310,000 218,770 0 (218,770) -100.00%
Pension -Police (3) 812,280 135,651 (602,783) (738,434) -544.36%
Pension -General (3) 1,320,428 220,511 922,992 1,143,503 -518.57%
Total $28,013,951 $4,678,332 $2,456,651 ($2,221,681)
Analysis of Major Variances
(1) The $139,731 negative variance in the General Fund resulted from not having received
the budgeted amount of property taxes. Typically the majority of these taxes are
received from the City of Jacksonville in December & January.
(2) The $218,770 negative variance in the Water & Sewer Construction Fund resulted
from not having issued the 2009 Revenue Notes.
(3) The $738,434 negative variance in the Police Employee Pension Fund & the
$1,143,503 negative variance in the General Employee Pension Fund resulted from
changes in market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
NOVEMBER 2008
Expenses
AGENDA ITEM # 4A
JANUARY 12, 2009
Annual YTD - 16.6% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $48,076 $8,029 $6,318 $1,711 21.31
City Administration 2,709,964 452,564 401,212 51,352 11.35%
General Government 1,884,365 314,689 323,445 (8,756) -2.78%
Planning and Building 563,748 94,146 73,238 20,908 22.21%
Public Safety (1) 5,742,080 958,928 573,246 385,682 40.22%
Recreation and Special Events 455,619 76,088 55,614 20,474 26.91
Public Works (2) 9,903,063 1,653,811 1,031,696 622,115 37.62%
Public Utilities (3) 8,817,584 1,472,537 2,044,040 (571,503) -38.81%
Pension -Police 451,236 75,356 82,749 (7,393) -9.81
Pension -General 485,152 81,020 74,472 6,548 8.08%
Total $31,060,887 $5,187,168 $4,666,030 $521,138
Annual YTD - 16.6% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (4) $9,093,980 $1,518,694 $1,198,383 $320,311 21.09%
Operating Expenses 10,290,788 1,718,562 1,439,098 279,464 16.26%
Capital Outlay (1) & (2) 7,380,612 1,232,562 438,788 793,774 64.40%
Debt Service (3) 1,681,207 280,762 1,154,044 (873,282) -311.04%
Transfers 2,614,300 436,588 435,717 871 0.20%
Total $31,060,887 $5,187,168 $4,666,030 $521,138
Analysis of Major Variances
(1) 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 2009 for October through December 2008. Also, there are
vacant positions in the Police Administrative, Police Patrol & Police Dispatch divisions and
the Police Building project has not begun -see Project Activity Schedule.
(2) The positive variance in the Public Works departments resulted from not having begun
various projects funded from this source -see Project Activity Schedule.
(3) The negative variance in the Public Utilities department resulted from the October
payment of principal and interest on the Utility Revenue Bonds.
(4) 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 2 weeks of October were not be paid until November. Also, there are vacant
positions in the Police Administrative, Police Patrol & Police Dispatch divisions.
City of Atlantic Beach
FINANCIAL REPORT
NOVEMBER 2008
Project Activity -Current Year Activity Only
AGENDA ITEM # 4A
JANUARY 12, 2009
Project Name
Public Safety
Police Building Renovation/Design/Construction
Public Utilities:
TMDL Engineering
SCADA Improvements
Collection System Inspection & Rehabilitation
Reclaimed Water Plant Construction
Collection System Rehabilitation
Check Valve -Water Plant #1
Concrete to GRIT Container
New Well
Design TDML
Subtotal
Public Works:
Statue -Turtle
Cabinets for Donner
Gate at Dutton Island
Park Playground
Tennis Courts at Donner Community Center
Howell Park Bridge
Hopkins Creek Retention
Mayport Road Medians
Pedestrian Path Extensions
Sidewalks -George & Edgar Streets
Sidewalks -Contingency
Ardella Road Drainage Project
Royal Palms Design
Sidewalk/Pedestrian Path
Sidewalk & Curb
Royal Palms Stormwater Project
Subtotal
Total
Project YTD YTD YTD
Number Budget Actual Balance
PS0504 660,000 0 660,000
PU0706 83,645 31,258 52,387
PU0801 14,000 0 14,000
PU0802 184,132 183,938 194
PU0805 150,276 0 150,276
PU0901 349,000 77,964 271,036
PU0902 30,000 0 30,000
PU0903 22,208 0 22,208
PU0904 800,000 0 800,000
PU0905 510,000 0 510,000
2,143,261 293,160 1,850,101
PM0805 73,307 18,990 54,317
PM0901 2,000 0 2,000
PM0902 10,000 0 10,000
PM0903 50,000 0 50,000
PM0905 70,000 0 70,000
PM0906 50,000 0 50,000
PW0309 1,110 1,110 0
PW0401 156,428 1,560 154,868
PW0802 100,000 535 99,465
PW0803 44,000 0 44,000
PW0805 7,732 0 7,732
PW0807 36,333 33,904 2,429
PW0808 400,000 0 400,000
PW0901 50,000 0 50,000
PW0904 50,000 0 50,000
PW0905 2,810,000 0 2,810,000
3,910,910 56,099 3,854,811
$6,714,171 $349,259 $6,364,912
Status Key
B -Bid Awarded E -Design Phase
C -Project Completed I -Project In-progress
D -Design Completed R - Re-budget Next Fiscal Year
Status
C
I
I
AGENDA ITEM # 4A
JANUARY 12, 2009
City of Atlantic Beach, FI.
Utility Sales Report
November 2008 November 2007
Water S81es
Accounts Gallons
0000 Actual
Revenue Revenue
Per 1,000 gi
Accounts Gallons
0000 Actual
Revenue Revenue
Per 1,000 gl
Atlantic Beach
Buccaneer 5,558
2,406 41,085
21,301 $130,646
$73,260 $3.18
$3.44 5,636
2,476 43,498
22,607 $122,293
$73,176 $2.81
$3.24
Total Water Sales 7.964 62.386 5203.906 53.27 s_~~~ as ~n~ s~o~ dao c~ oc
Gallons
Water Plant Production Oooo
Atlantic Beach 47,529
Buccaneer 16,664
Total Production 64,193
Total Water Billed 62,386
Water Loss for month: 1,807
Percentage Loss 2.81%
Total 12 mo. Avg. Loss 12.32%
Gallons Actual Revenue
Sewer Sales Accounts 0000 Revenue Per 1,oao yi
Atlantic Beach 5,077 32,674 $194,227 $5.94
Buccaneer 2,290 19,777 $145,750 $7.37
Total Sewer Sales 7.367 52.451 5339.977 99 dR
Gallons Actual Revenue
Sewer Treatment OOOO Revenue Per 1,000 s
Atlantic Beach 37.748 $194,227 $5.15
Buccaneer 20.460 $145,750 $7.12
Total Sewer Treated 58.208 5339.977 S5_sd
Gallons
0000
54,661
19, 792
74,453
66,105
8,348
11.21
13.16%
Gallons Actual Revenue
Accounts 0000 Revenue Per 1.000 al
5,112 33,797 $176,380 $5.22'
2,335 21,135 $138,779 $6.57
Gallons Actual Revenue
0000 Revenue Per 7,000 9i
47.872 $176, 380 $3.68
20.057 $138,779 $6.92
67.929 $315,159 $4.64
AGENDA ITEM # 4A
JANUARY 12, 2009
ri I I
1
I 1
I I
I 1
w I I
1 I -
I I
a 1 I
1
I I
1 i
1 1
I I
I
1 i
i I
i I
I I
I
I 1
I 1
I i
I I
I 1
I I
I I
1 I
1 I H dl r ~o - io r o ~n
I ~ I o m H m m rn m dl
I I r r vl o o m In io
I Gr] 1 CO m N O O r Ol l0
i z 1 I I I I 1 I I I
I O 1 In H .-{ O O m l0 ~
I x l m vl w r r H dl H
I a I N N N N N l0 N 10
I 1 1 I 1 I I I I I
N I U} I a' VI ~ [M ~N W ql W
b I ] I o ao 0 0 o cAO o ao
\ I Gp I m W m rn rn rn H rn m W m
H [n I 1 fRyIC ~
m W I I \ \
\ Cn I I U1
H~ 1 I O z O
W O U I I h H ~
H I I Q \ z nQ"
a I 1 q U
7-I o I-a I I O H H O
~\-I •• i i U H 'a H
~7 ~ r.~ U
H N C ~ i H O a' W W H
~ r.~ H U q ~
~Hu ~ ~ u x w a ~ z rx
m~ ~ ~ a o ~ ~ H o
~ 3 W i 10-I i W U O U ~ ~ ~ U
F H W I H I z ~ W H U z O
l# W q I~ i O' F F ~ W O H
O Rl I i H z FC a a H W
a W I H I m O F W 3 H b O
a o z i FW-t I H U W O ~ ~ U U
o W i ~ I
~I N U I O I W O O H H O O
H ••a ~ a ~ w H ~ ~ o z ~ z
1~-I ~ a i U , U ~ a FC H H FC ~
HWr•C I I
~~ O i W i W W ~~~77 W W ~~7 W (~(~~
W O H I F i z 7. 7. 7-I z 7. z 7-.
U] W Fl; I I
z a l I W m ca m m m m m
W w p l q 1 0 0 0 0 0 0 0 0
U W U I ~ 1 \ \ \ \ \ \ \ \
H V} U I I O O O N N H O O
a ~'i O 1 Vl I ri .--I r-1 N N .-I ri ri
[.] 1 U] I \ \ \ \ \ \ \ \
U •• I H I N N N N N N N N
H H 1 I rl H H ri rl ~-i r-I r-1
aal I
aA~ ~ ~ ~ a I
w I I A FC ~ i
z I I u
F 1
1 1
1 1 H a~ o a rx
~ ~ m m a a m ~ m m m >+ m ~ m
I I W m m >+ W m C7 m m m r.~ m a m I
I I p.,' N N H N N N N W N W N 1
I I W N N a U N Q,' N N N N W. N I
1 1 P m m r.~ H m W m m m a' m m i
i 1
I I a a x a a ~~-. a Q a a a EW'I a ~ H a 1
~ [~i7 i QaW QW xa W Z W Z W NW ~HW ~UW W
m ~ wQ ~ ~~~ aH~ ~~~ o~~ ~~~ .-I~ a~s~ oo~
In 1 ~q 1 WO~ OW W H.-iW z W z W W WHW OFW U
H 1i 1 z RC i 7. RI 3 a• W W a1 H cy' W H Rl r1'i H W q a P] U W H
•• U 1 1 Ow H~ Ziw .~J .3 ~~ H
wro I(n(n I Hsu wl~u Fv owu o u o u rx u A~u a
N 1 U7 UW] I W HH ,~U]H µ~HH HaH HaH .71WWH ~,J H VIH
-W I W W~~....II I aF O ~~--II q~ H~'~ z H v] E zr~-looooooco
o U I HH ~ ~O'~ '~'W7y HV]'~.I PiRI~ Ri WiG ~jyH,7. F ~Ty ~ Vl~
\•rl 1 Ul U1 I Boa ~a ow EOir Era a O.H-i Oo I
In+~l-7 I pp I qqmF I~rnH arF r•C~nF r•C~nF UHF UoH ~y'iH I
o qN I papa I r.~r-iQ' FCmQ, WmQ', C7r+Q,' L7Hy' O~nr.G cn.-IRC FHr•C I
\ ro N I I
~ r°I ri I I r o m rn o H m m ~ 1
N a I I In ~o N m o ~o In in '~
r.~ O I I o 0 o rn o 0 0 0 E-I I
A 1 I r r r ~o r r r r p l
W w I I o 0 0 0 0 0 0 0 E-1 1
W, O I I o 0 0 0 0 0 0 0
FC 1~ 1 0 o O O o o O o
a ?I C7 1 i 0 0 0 0 0 0 0 0 .. .. ..
wJ-1O I U 1 I I I 1 1 1 I I ~ V a z o~W'Ga LJH
x•ax I H I m m rn rn rn m rn m I rjaH~aW Oda
a U a l a I o 0 0 0 0 0 0 0 ~ry