Item 4ACity of Atlantic Beach A JiJNE22,20094A
FINANCIAL REPORT
MAY 2009
Cash Balances
Fund(s)
General
Tree Replacement
Convention Development Tax
Local Option Gas Tax
Better Jax 1/2 Cent Sales Tax
Police Training, Forfeit, etc.
Debt Service
Capital Projects
Utility
Sanitation
Building Code Enforcement
Storm Water
Pension -Police
Pension -General
Total
Total Restricted Cash
Total Unrestricted Cash
Prior
04/30/09
$5,961,360
14,822
21,603
259,999
776,643
211,728
52,700
525,773
2,483,707
349,440
102,323
3,659,931
222
198,714
$14,618,965
Current Dollar
05/31/09 Change
$5,770,052
14,822
2,825
253,750
783,290
208,243
58,431
548, 761
2,717,913
360, 905
94,487
3,746,216
48,119
40,656
$14,648,470
$7,294,043
$7,354,427
Cash and Investments
Account
Prior
04/30/09
Bank of America -Depository $6,600,093
Bank of America -Certificate of Deposit 6,013,640
5th 3rd Bank -Certificate of Deposit 2,001,546
SBA 1,286
Cash on Hand 2,400
Subtotal 14,618,965
Police Pension Investments 4,750,540
General Pension Investments 7,540,917
Subtotal 12,291,457
Total $26,910,422
Current
5/31 /09
$6,620,374
6,020,047
2,004,366
1,283
2,400
14,648,470
4,882,378
8,067,385
12, 949, 763
($191,308)
0
(18,778)
(6,249)
6,647
(3,485)
5,731
22,988
234,206
11,465
(7,836)
86,285
47,897
(158,058)
$29,505
Dollar Rate of
Change
$20,281
6,407
2,820
(3)
0
29,505
131,838
526,468
658.306
Return
0.30
1.24
1.66
0.86
N/A
$27,598,233 $687,811
3.51 (1)
3.46 (1)
(1) FYTD rate of return through 03/31 /09
City of Atlantic Beach
FINANCIAL REPORT
MAY 2009
Revenues
AGENDA ITEM # 4A
JUNE 22, 2009
Annual I YTD - 67% YTD Dollar Percent
Fund I (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $10,391,868 $6,931,376 $7,937,719 $1,006,343 14.52%
Tree Replacement 0 0 4,914 4,914 100.00%
Convention Development Tax 85,000 56,695 35,356 (21,339) -37.64%
Local Option Gas Tax 496,872 331,414 302,302 (29,112) -8.78%
Better Jax 1/2 Ct Sales Tax 638,188 425,671 436,099 10,428 2.45%
Police Training, Forfeit, etc. 40,150 26,781 21,251 (5,530) -20.65%
Grants 214,284 142,927 30,125 (112,802) -78.92%
Debt Service 69,500 46,357 45,760 (597) -1.29%
Capital Projects 335,000 223,445 220,561 (2,884) -1.29%
Utility (2) 9,398,075 6,268,517 4,768,731 (1,499,786) -23.93%
Sanitation 1,872,500 1,248,958 1,212,720 (36,238) -2.90%
Building Code Enforcement 207,500 138,403 138,301 (102) -0.07%
Storm Water (3) 2,374,600 1,583,858 2,150,060 566,202 35.75%
Pension -Police (4) 812,280 541,791 56,693 (485,098) -89.54%
Pension -General (4) 1,320,428 _ 880,725 274,357 (606,368) -68.85%
Total $28,256,245 $18,846,918 $17,634,949 ($1,211,9
Analysis of Major Variances
(1) The $1,006,343 positive variance in the General Fund resulted from having received
92% 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 $1,499,786 negative variance in the Utility Funds resulted from charges for services
$245,625 below projected year to date amounts and not having transferred the budgeted
amounts of $1,267,300 from the General Fund. These transfers wilt be executed when
the work begins on the well replacement & TMDL projects.
(3) The $566,202 positive variance in the Stormwater Fund resulted from having received
the Florida Department of Environmental Protection grant monies in this fiscal year.
These revenues were budgeted & recognized in the prior fiscal year.
(4) The $485,098 negative variance in the Police Employee Pension Fund & the $606,368
negative variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
MAY 2009
Expenses
AGENDA ITEM # 4A
JUNE 22, 2009
Annual YTD - 67% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $48,076 $32,067 $27,896 $4,171 13.01%
City Administration 2,645,981 1,764,870 1,602,791 162,079 9.18%
General Government (1) 4,101,465 2,735,677 1,559,090 1,176,587 43.01
Planning and Building 565,974 377,504 337,873 39,631 10.50%
Public Safety (2) 5,728,176 3,820,694 2,993,608 827,086 21.65%
Recreation and Special Events 455,619 303,898 276,625 27,273 8.97%
Public Works (3) 9,592,108 6,397,936 3,760,398 2,637,538 41.22%
Public Utilities (1) 9,349,931 6,236,404 5,413,067 823,337 13.20%
Pension -Police 451,236 300,974 332,294 (31,320) -10.41
Pension -General 485,152 323,596 333,966 (10 370) -3.20%
Total $33,423,718 $22,293,620 $16,637,608 $5,656,012
Annual YTD - 67% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services $9,091,380 $6,063,950 $5,631,830 $432,120 7.13%
Operating Expenses (2) & (3) 10,247,118 6,834,828 5,900,938 933,890 13.66%
Capital Outlay (1 ), (2) & (3) 7,871,213 5,250,099 1,682,698 3,567,401 67.95%
Debt Service (4) 1,681,207 1,121,365 1,665,275 (543,910) -48.50%
Transfers (1) 4,532,800 3,023,378 1,756,867 1,266,511 41.89%
Total $33,423,718 $22,293,620 $16,637,608 $5,656,012
Analysis of Major Variances
(1) The positive variance in the General Government and Transfers resulted from not
having transferred the budgeted amounts to date from the General Fund to the Public
Utilities departments. These transfers will be executed as the work progresses on the
well replacement & TMDL projects in the Public Utilities departments -see Project
Activity Schedule.
(2) The positive variance in the Public Safety departments is due to the lifeguards season
just beginning, the payment being due quarterly to the City of Jacksonville for fire &
rescue services (the payment for January to March was paid in April, 2009); and the
Police Building project has had limited activity -see Project Activity Schedule.
(3) The positive variance in the Public Works departments resulted from only 7 of 8 monthly
payments have been paid on the Advanced Disposal Services Jax LLC contract, only 3%
of the budget for Park repairs and maintenance has been spent in the General Fund, only
42% of the budget for paving has been spent in the Local Option Gas Tax Fund, the
projects for the renovation of the City Parks has had limited activity and the Royal Palms
Stormwater project has not started -see Project Activity Schedule.
(4) The negative variance in the Debt Service accounts is due to the payment on interest
and principal on 10/01/08 and 12/01/08 and the payment of interest only on 04/01 /09.
City of Atlantic Beach
FINANCIAL REPORT
MAY 2009
Project Activity -Current Year Activity Only
AGENDA ITEM # 4A
JUNE 22, 2009
Project YTD YTD YTD
Project Name Number Budget Actual Balance
Status
Public Safety
Police Building Renovation/Design/Construction
Public Utilities:
Replace Well #2 at Water Plant #1
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
TMDL -Lift Station Transfer Flow
Public Works:
Buckman Trust Property
Statue -Turtle
Cabinets for Donner
Gate at Dutton Island
Park Playground
Tennis Courts/Improvements/DonnerPark
Howell Park Bridge
Dune Crossover - 3rd Street Extnsion
Hopkins Creek Retention
Mayport Road Medians
Pedestrian Path Extensions
Sidewalks -George & Edgar Streets
Ardella Road Drainage Project
Royal Palms Design
Sidewalk/Pedestrian Path
Sidewalk & Curb
Royal Palms Stormwater Project
Status Kev
B -Bid Awarded
C -Project Completed
D -Design Completed
Subtotal
PS0504 660,000 4,738 655,262
PU0304 800,000 2,541 797,459
PU0706 84,005 84,005 0
PU0801 14,000 14,000 0
PU0802 183,939 183,938 1
PU0805 150,276 0 150,276
PU0901 349,597 349,593 4
PU0902 30,000 20,325 9,675
PU0903 18,708 18,428 280
PU0904 0 0 0
PU0905 710,000 28,377 681,623
PU0906 390,000 26,440 363,560
2,730,525 727,647 2,002,878
PM0804 191,000 190,410 590
PM0805 73,307 52,844 20,463
PM0901 2,000 0 2,000
PM0902 0 0 0
PM0903 45,000 42,109 2,891
PM0905 147,000 0 147,000
PM0906 15,000 0 15,000
PM0907 7,075 0 7,075
PW0309 1,110 1,110 0
PW0401 156,428 11,089 145,339
PW0802 0 0 0
PW0803 51,732 255 51,477
PW0807 33,753 33,904 (151)
PW0808 400,000 174,750 225,250
PW0901 0 0 0
PW0904 45,000 41,347 3,653
PW0905 2,810,000 0 2,810,000
Subtotal 3,978,405 547,818 3,430,587
Total $7,368,930 $1,280,203 $6,088,727
E -Design Phase
I -Project In-progress
R - Re-budget Next Fiscal Year
X -Project Cancelled
E
C
I
AGENDA ITEM # 4A
Ji7NE 22, 2009
City of Atlantic Beach, FI.
Utility Sales Report
May 2009 May 2008
Gallons Actual Revenue Gallons Actual Revenue
Water Sales Account 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per 1,000 gi
Atlantic Beach 5,590 42,826 $136,000 $3.18 5,635 43,405 $121,720 $2.80
Buccaneer 2,448 21,444 $78,217 $3.65 2,464 22,367 $70,694 $3.16
Total Water Sales 8,038 64,270 $214,217 $3.33 8,099 65,772 $192,414 $2.93
Gallons Gallons
Water Plant Production o000 0000
Atlantic Beach 54,401 60,520
Buccaneer 17,984 22,170
Total Production 72,385 82,690
Total Water Billed 64,270 65,772
Water Loss for month: 8,115 16,918
Percentage Loss 11.21 % 20.46%
Total 12 mo. Avg. Loss 12.15% 12.75%
Gallons Actual Revenue Gallons Actual Revenue
Sewer Sales Accounts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per 1,000 gi
Atlantic Beach 5,122 34,430 $203,483 $5.91 5,132 34,239 $179,028 $5.23
Buccaneer 2,324 20,177 $136,443 $6.76 2,347 21,114 $137,172 $6.50
Total Sewer Sales 7,446 54,607 $339,925 $6.22 7,479 55,353 $316,200 $5.71
Gallons Actual Revenue Gallons Actual Revenue
Sewer Treatment 0000 Revenue Per 1,000 gl 0000 Revenue Per 1,000 gi
Atlantic Beach 59.626 $203,483 $3.41 38.612 $179,028 $4.64
Buccaneer 20.056 $136,443 $6.80 20.114 $137,172 $6.82
Total Sewer Treated 79.682 $339,925 $4.27 58.726 $316,200 $5.38