Item 4AAGENDA ITEM # 4A
JANUARY 26, 2009
City of Atlantic Beach, FI.
Utility Sales Report
December 2008
Water Sales
Atlantic Beach
Buccaneer
Total Water Sales
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gi
5,526 38,269 $121,424 $3.17
2.432 21.113 $75,857 $3.59
Water Plant Production
Atlantic Beach
Buccaneer
Total Production
Total Water Billed
Water Loss for month:
Percentage Loss
Total 12 mo. Avg. Loss
Sewer Safes
Atlantic Beach
Buccaneer
Total Sewer Sales
Sewer Treatment
Atlantic Beach
Buccaneer
Total Sewer Treated
Gallons
0000
53,790
15,698
69,488
59,382
10,106
14.54%
12.71
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,00o gi
5,112 32,170 $192,932 $6.0(
2,336 19.861 $150,096 $7.5E
Gallons Actual Revenue
0000 Revenue Per 1,000 gi
40.306 $192,932 $4.79
20.844 $150,096 $7.20
81.150 $343.028 $5.61
December 2007
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gl
5,580 43,474 $122,036 $2.81
2,460 22,919 $72,921 $3.18
Gallons
0000
54,908
18,723
73,631
66,393
7,238
9.83%
13.05%
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gl
5,072 33,701 $177,040 $5.25
2,333 21,212 $138,184 $6.51
Gallons Actual Revenue
0000 Revenue Per 1,000 gi
44.651 $177,040 $3.96
21.741 $138,184 $6.36
City of Atlantic Beach ,~ °RY 6M o09
FINANCIAL REPORT
DECEMBER 2008
Cash Balances
Fund(s)
Prior Current
11 /30108 12/31 /08
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
Cash and Investments
$5,073,040
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,316
$7,413,583
34,693
205,096
203,494
763,003
206,756
0
29,853
415,664
2,584,610
309,879
148,983
2,675,282
56, 994
139,202
$15,187,092
$7,401,464
$7,785,628
$2,340,543
0
(9,407)
15,883
(4,662)
3,931
0
(58,928)
27,446
117,934
35,709
(11,487)
147, 595
(12,676)
22,895
$2,614,776
Account
Prior Current
11 /30/08 12/31 /08
Dollar Rate of
Bank of America -Depository $5,835,074 $8,449,059
SBA 1,356 1,311
Banc of America Securities LLC 6,733,486 6,734,322
Cash on Hand 2,400 2,400
Subtotal 12,572,316 15,187,092
Police Pension Investments 4,450,898 4,589,614
General Pension Investments 7,053,879 7,288,561
Subtotal 11.504.777 11.878.175
Change Return
$2,613,985 0.14
(45) 1.02
836 0.00
0 -
2,614,776
138,716 (11.64) (1)
234,682 (12.10) (1)
373.398
Total $24,077,093 $27,065,267 $2,988,174
(1) FYTD rate of return through 09/30/08
City of Atlantic Beach
FINANCIAL REPORT
DECEMBER 2008
AGENDA ITEM # 4A
JANUARY 26, 2009
Expenses
Annual YTD - 25% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $48,076 $12,019 $9,791 $2,228 18.54%
City Administration 2,709,964 677,492 619,637 57,855 8.54%
General Government 1,884,365 471,091 527,956 (56,865) -12.07%
Planning and Building 563,748 140,938 112,884 28,054 19.91
Public Safety (1) 5,742,080 1,435,521 857,267 578,254 40.28%
Recreation and Special Events 455,619 113,905 115,382 (1,477) -1.30%
Public Works (2) 9,903,063 2,475,766 1,560,963 914,803 36.95%
Public Utilities (3) 8,817,584 2,204,396 2,636,810 (432,414) -19.62%
Pension -Police 451,236 112,809 122,692 (9,883) -8.76%
Pension -General 485,152 121,288 111,071 10,217 8.42%
Total $31,060,887 $7,765,225 $6,674,453 $1,090,772
Annual YTD - 25% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (4) $9,093,980 $2,273,498 $1,931,438 $342,060 15.05%
Operating Expenses 10,290,788 2,572,697 2,268,094 304,603 11.84%
Capital Outlay (1) & (2) 7,380,612 1,845,153 521,520 1,323,633 71.74%
Debt Service (3) 1,681,207 420,302 1,299,826 (879,524) -209.26%
Transfers 2,614,300 653,575 653,575 0 0.00%
Total $31,060,887 $7,765,225 $6,674,453 $1,090,772
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 paid until November. Also, there are vacant
positions in the Police Administrative, Police Patrol & Police Dispatch divisions.
City of Atlantic Beach
FINANCIAL REPORT
DECEMBER 2008
Revenues
AGENDA ITEM # 4A
JANUARY 26, 2009
Annual I YTD - 25% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $10,538,732 $2,634,683 $4,822,413 $2,187,730 83.04%
Tree Replacement 0 0 3,510 3,510 100.00%
Convention Development Tax 94,000 23,500 19,102 (4,398) -18.71%
Local Option Gas Tax 530,872 132,718 110,385 (22,333) -16.83%
Better Jax 1/2 Ct Sales Tax 732,630 183,158 164,666 (18,492) -10.10%
Police Training, Forfeit, etc. 40,150 10,038 7,548 (2,490) -24.81
Grants 214,284 53,571 30,125 (23,446) -43.77%
Debt Service 69,500 17,375 17,182 (193) -1.11
Capital Projects 335,000 83,750 82,726 (1,024) -1.22%
Utility 7,551,075 1,887,769 1,876,850 (10,919) -0.58%
Sanitation 1,880,500 470,125 461,140 (8,985) -1.91
Building Code Enforcement 207,500 51,875 71,249 19,374 37.35%
Storm Water 2,377,000 594,250 581,240 (13,010) -2.19%
Water/Sewer Construction (2) 1,310,000 327,500 0 (327,500) -100.00%
Pension -Police (3) 812,280 203,070 (436,801) (639,871) -315.10%
Pension -General (3) 1,320,428 330,107 628,817 958,924 -290.49%
Total $28,013,951 $7,003,489 $7,182,518 $179,029
Analysis of Major Variances
(1) The $2,187,730 positive variance in the General Fund resulted from having received
76% of the budgeted amount of property taxes. Typically the majority of these taxes are
received from the City of Jacksonville in December & January.
(2) The $327,500 negative variance in the Water & Sewer Construction Fund resulted
from not having issued the 2009 Revenue Notes.
(3) The $639,871 negative variance in the Police Employee Pension Fund & the $958,924
negative variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
City of Atlantic Beach AGENDA ITEM # 4A
JANUARY 26, 2009
FINANCIAL REPORT
DECEMBER 2008
Project Activity -Current Year Activity Only
Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
Public Safety
Police Building Renovation/Design/Construction PS0504 660,000 0 660,000
Public Utilities:
TMDL Engineering PU0706 83,645 51,251 32,394
SCADA Improvements PU0801 14,000 0 14,000
Collection System Inspection & Rehabilitation PU0802 184,132 183,938 194
Reclaimed Water Plant Construction PU0805 150,276 0 150,276
Collection System Rehabilitation PU0901 349,000 78,561 270,439
Check Valve -Water Plant #1 PU0902 30,000 20,325 9,675
Concrete to GRIT Container PU0903 22,208 18,428 3,780
New Well PU0904 800,000 0 800,000
Design TDML PU0905 510,000 0 510,000
Subtotal 2,143,261 352,503 1,790,758
Public Works:
Statue -Turtle PM0805 73,307 18,990 54,317
Cabinets for Donner PM0901 2,000 0 2,000
Gate at Dutton Island PM0902 10,000 0 10,000
Park Playground PM0903 50,000 0 50,000
Tennis Courts at Donner Community Center PM0905 70,000 0 70,000
Howell Park Bridge PM0906 50,000 0 50,000
Hopkins Creek Retention PW0309 1,110 1,110 0
Mayport Road Medians PW0401 156,428 1,560 154,868
Pedestrian Path Extensions PW0802 100,000 535 99,465
Sidewalks -George & Edgar Streets PW0803 44,000 0 44,000
Sidewalks -Contingency PW0805 7,732 0 7,732
Ardella Road Drainage Project PW0807 36,333 33,904 2,429
Royal Palms Design PW0808 400,000 0 400,000
Sidewalk/Pedestrian Path PW0901 50,000 0 50,000
Sidewalk & Curb PW0904 50,000 8,831 41,169
Royal Palms Stormwater Project PW0905 2,810,000 0 2,810,000
Subtotal 3,910,910 64,931 3,845,979
Total $6,714,171 $417,434 $6,296,737
Status Kev
B -Bid Awarded E -Design Phase
C -Project Completed I -Project In-progress
D -Design Completed R - Re-budget Next Fiscal Year
C
I
I
AGENDA ITEM # 4A
2009 ANNUAL CODE ENFORCEMENT INVESTIGATION REPORT JANUARY 26, 2009
8p t~ p0`p ~ CZ ~O P ~ Z
~p ~ 4~ ~Z~c+ pw s ~ ~< ~w w ~ ~pw 9p Z
w
1994 TOTALS
CALL INS
0
CE IDENTIFIED 0
TOTALS 53 129 18 0 ZB 11 2S 41 3S 223 47 0 0 0 808
1995 TOTALS
CALL INS 0
CE IDENTIFIED
0
TOTALS 28 187 14 0 29 11 47 45 30 182 64 0 5 2 642
1996 TOTALS
CALL INS
0
CE IDENTIFIED
0
TOTALS 56 217 48 0 37 12 48 73 19 239 43 0 2 B 798
1997 TOTALS
CALL INS 0
CE IDENTIFIED 0
TOTALS 39 149 28 0 4S 39 38 102 20 192 5S 0 3 1 711
1998 TOTALS
CALL INS 0
CE IDENTIFIED
0
TOTALS 51 82 36 0 25 32 80 170 20 144 S1 0 4 3 878
1999 TOTALS
CALL INS 37 34 18 0 S 29 28 87 18 27 37 0 S 8 313
CE IDENTIFIED 18 ZO 1 0 35 13 18 84 9 78 18 0 2 14 308
TOTALS 5S 54 19 0 40 42 44 151 27 103 55 0 7 22 619
2000 TOTALS
CALL INS 16 47 30 4 2 36 15 78 Z3 49 26 0 5 3 332
CE IDENTIFIED 3b 83 S 33 918 64 59 70 1 120 70 8 0 4 1468
TOTALS 51 130 35 37 920 100 74 148 24 189 88 8 5 7 1800
2001 TOTALS
CALLINS 11 76 62 5 S 63 18 41 41 37 23 1 8 6 397
CE IDENTIFIED 13 128 8 4 1814 38 89 78 0 159 80 85 0 0 2454
TOTALS 24 204 70 9 1819 99 87 119 41 198 83 88 8 6 2851
2002 TOTALS
CALL INS 14 35 38 11 10 56 36 28 39 35 6 0 8 1 310
CE IDENTIFIED 14 66 2 78 1329 80 80 77 17 230 321 227 0 1 2522
TOTALS 28 101 38 89 1339 138 115 103 56 285 327 227 6 2 2832
2003 TOTALS
CALL INS 23 57 ~ 12 2 47 34 42 37 46 11 3 8 0 379
CE IDENTIFIED 3 88 S2 16 2020 82 47 40 9 144 118 35 0 0 2591
TOTALS 28 125 91 28 2022 109 81 82 48 190 128 38 8 0 2970
2004 TOTALS
CALL INS 25 55 48 7 13 47 32 36 42 73 12 2 7 92 489
CE IDENTIFIED 107 39 6 7 2114 Z6 34 48 63 105 53 12 0 0 2614
TOTALS 132 94 52 14 2127 73 86 84 105 178 85 14 7 92 3103
2005 TOTALS
CALL INS 20 N 18 14 4 44 31 45 57 92 17 0 8 40 457
CE IDENTIFIED 2 68 11 10 2025 38 5E 25 17 180 3a 24 0 0 2496
TOTALS 22 137 27 24 2029 82 89 70 74 272 5S 24 8 40 2953
2008 TOTALS
CALL INS 20 41 54 10 11 42 28 42 81 43 10 1 6 8 375
CE IDENTIFIED 7 38 8 5 1995 28 78 25 23 153 14 1S 1 0 2388
TOTALS 27 79 82 15 2006 70 104 87 84 198 24 18 7 8 2783
2007 TOTALS
CALL INS 30 41 S4 9 31 41 16 32 88 81 20 0 8 33 438
CE IDENTIFIED 2 53 8 13 1980 38 60 18 23 184 11 24 2 0 2398
TOTALS 32 97 62 22 2011 79 78 50 82 225 31 24 8 33 2832
2008 TOTALS BLDG
CALL INS 20 87 18 30 18 Si 19 27 82 38 34 1 8 11 399
CE IDENTIFIED 107 41 16 162 2535 17 52 6 50 93 28 29 4 19 2959
TOTALS 127 108 32 192 2353 88 71 33 112 128 82 30 12 30 tea
AGENDA ITEM # 4A
JANUARY 26, 2009
M
M
M
M
~ O
e-I
M
O
I~
M
~
M M N N ~
N ~ N N
N
V
~ °o
~ ~
v
V ~'
L ~
W
~ r,
e-I a~i
^
N
GJ ~ ~o ~ ~ o
~ lD
V
J
a J
a J
a J
a J
a J
a J
a J
a J
a J
a J
a J
a J
a J
a J
a
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
00
O I~
O lD
O LA
O ti'
O M
O N
O ~--I
O O
O Q1
01 00
Q1 1~
Q1 l0
G1 u1
01 d'
Q1
O
N O
N O
N O
N O
N O
N O
N O
N O
N rn
e-1 ~
r-I rn
r-I ~
e-~ o~
r-I rn
rl