Item 4AAGENDA ITEM # 4A
MARCH 23, 2009
City of Atlantic Beach, FI.
Utility Sales Report
February 2009 February 2008
Gallons Actual Revenue Gallons Actual Revenue
Water Sales Accounts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per 1,000 gi
Atlantic Beach 5,585 38,982 $125,588 $3.22 5,637 38,247 $108,919 $2.85
Buccaneer 2,420 22,411 $81,110 $3.62 2,426 21,625 $68,590 $3.17
Total Water Sales 8,005 61,393 $206,699 x3.37 8,063 59,872 $177,509 $2.96
Gallons Gallons
Water Plant Production o000 0000
Atlantic Beach 47,569 47,947
Buccaneer 13,537 15,989
Total Production 61,106 63,936
Total Water Billed 61,393 59,872
Water Loss for month: -287 4,064
Percentage Loss -0.47°k 6.36%
Total 12 mo. Avg. Loss 12.73% 12.76%
Gallons Actual Revenue Gallons Actual Revenue
Sewer Sales Accounts 0000 Revenue Per a,ooo ei Accounts 0000 Revenue Per ~,oo0 9i
Atlantic Beach 5,115 32,531 $195,956 $6.02 5,105 31,820 $169,816 $5.34
Buccaneer 2,300 19,449 $147,392 $7.58 2,323 20,581 $135,262 $6.57
Total Sewer Sales 7,415 51,980 1343,348 $6.61 7,428 52,401 $305,078 x5.82
Gallons Actual Revenue Gallons Actual Revenue
Sewer Treatment 0000 Revenue Per ~,ooo gi 0000 Revenue Per 1,000 gi
Atlantic Beach 37.100 $195,956 $5.28 42.138 $169,816 $4.03
Buccaneer 18.095 $147,392 $8.15 19.710 $135,262 $6.86
Total Sewer Treated 55.195 $343 348 16.22 61.848 $305,078 14.93
Clt of Atlantic Beach AGENDA ITEM # 4A
y MARCH 23, 2009
FINANCIAL REPORT
FEBRUARY 2009
Cash Balances
Prior Current Dollar
Fund(s) 01/31/09 02/28/09 Change
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
$7,035,918
33,693
209,039
201,297
759,602
207,554
35, 553
443,052
2,640,736
306,027
131,419
2,987,301
45,683
161,185
$15,198,059
$6,627,162
33,693
212,243
232,738
782,507
207,935
41,255
470,482
2,619,333
311, 386
124,427
3,161,619
11,475
140.709
$14,976,964
$7,357,452
$7,619,512
Subtotal
Prior Current
01 /31 /09 2/28/09
$8,459,910
0
6,734,438
1,311
2,400
15,198,059
$8,972,224
6,001,033
0
1, 307
2,400
14,976,964
4,207,771
6,676,868
10,884,639
($408,756)
0
3,204
31,441
22,905
381
5, 702
27,430
(21,403)
5,359
(6,992)
174,318
(34,208)
(20,476)
($221,095)
Total Restricted Cash
Total Unrestricted Cash
Cash and Investments
Account
Bank of America -Depository
Bank of America -Certificate of Deposit
Banc of America Securities LLC
SBA
Cash on Hand
Police Pension Investments
General Pension Investments
Subtotal
Total
4,414,538
7,003,995
11,418,533
$26,616,592
$25,861,603
Dollar Rate of
Change Return
$512,314 0.12
6,001,033 1.24
(6,734,438) 0.18
(4) 0.94
0 N/A
(221,095)
(206,767)
(327,127)
(533,895)
(12.20) (1)
(11.99) (1)
($754,989)
(1) FYTD rate of return through 12/31/08
City of Atlantic Beach AGENDA ITEM # 4A
FINANCIAL REPORT MARCH 23,2009
FEBRUARY 2009
Revenues
Fund / (Footnote) Annual
Estimate YTD - 42%
of Estimate YTD
Actual Dollar
Variance Percent
Variance
General (1) $10,431,720 $4,350,027 $5,929,900 $1,579,873 36.32%
Tree Replacement 0 0 3,510 3,510 100.00%
Convention Development Tax 85,000 35,445 26,250 (9,195) -25.94%
Local Option Gas Tax 496,872 207,196 191,686 (15,510) -7.49%
Better Jax 1/2 Ct Sales Tax 690,130 287,784 282,701 (5,083) -1.77%
Police Training, Forfeit, etc. 40,150 16,744 11,494 (5,250) -31.35%
Grants 214,284 89,356 30,125 (59,231) -66.29%
Debt Service 69,500 28,982 28,584 (398) -1.37%
Capital Projects 335,000 139,695 137,544 (2,151) -1.54%
Utility 7,498,075 3,126,698 3,018,124 (108,574) -3.47%
Sanitation 1,872,500 780,833 756,956 (23,877) -3.06%
Building Code Enforcement 207,500 86,528 94,703 8,175 9.45%
Storm Water (2) 2,374,600 990,208 1,202,324 212,116 21.42%
Water/Sewer Construction (3) 1,310,000 546,270 0 (546,270) -100.00%
Pension -Police (4) 812,280 338,721 (783,011) (1,121,732) -331.17%
Pension -General (4) 1,320,428 550,618 1,157,658 1,708,276 -310.25%
Total $27,758,039 $11,575,105 $9,773,232 ($1,801,873)
Analysis of Major Variances
(1) The $1,579,873 positive variance in the General Fund resulted from having received
83% 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 $212,116 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.
(3) The $546,270 negative variance in the Water & Sewer Construction Fund resulted
from not having issued the 2009 Revenue Notes.
(4) The $1,121,732 negative variance in the Police Employee Pension Fund & the
$1,708,276 negative variance in the General Employee Pension Fund resulted from
changes in market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
FEBRUARY 2009
Expenses
AGENDA ITEM # 4A
MARCH 23, 2009
Annual YTD - 42% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $48,076 $20,048 $16,854 $3,194 15.93%
City Administration 2,652,002 1,105,885 1,045,429 60,456 5.47%
General Government 2,013,465 839,615 863,842 (24,227) -2.89%
Planning and Building 575,748 240,086 197,979 42,107 17.54%
Public Safety (1) 5,728,380 2,388,734 1,721,590 667,144 27.93%
Recreation and Special Events 455,619 189,993 190,188 (195) -0.10%
Public Works (2) 9,686,303 4,039,188 2,255,597 1,783,591 44.16%
Public Utilities 8,764,584 3,654,831 3,656,416 (1,585) -0.04%
Pension -Police 451,236 188,165 203,842 (15,677) -8.33%
Pension -General 485,152 202,308 192,416 9,892 4.89%
Total $30,860,565 $12,868,853 $10,344,153 $2,524,700
Annual YTD - 42% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services $9,091,380 $3,791,105 $3,504,345 $286,760 7.56%
Operating Expenses (3) 10,323,556 4,304,921 3,503,901 801,020 18.61
Capital Outlay (1) & (2) 7,136,622 2,975,971 941,164 2,034,807 68.37%
Debt Service (4) 1,681,207 701,063 1,299,826 (598,763) -85.41
Transfers 2,627,800 1,095,793 1,094,917 876 0.08%
Total $30,860,565 $12,868,853 $10,344,153 $2,524,700
Analysis of Major Variances
(1) The positive variance in the Public Safety departments is due to 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 limited activity in the
various projects funded from this source -see Project Activity Schedule.
(3) The positive variance in the Operating Expenses is partially due to: the payment being
due quarterly to the City of Jacksonville for fire & rescue services (the payment for October
through December 2008 was paid in January, 2009); only 4 of 5 monthly payments have
been paid on the Advanced Disposal Services Jax LLC and First Vehicle contracts; only
16% of the budget for paving has been spent in the Local Option Gas Tax Fund and the
projects for the renovation of the City Parks have not started.
(4) The negative variance in the Debt Service accounts is due to the payment on interest and
principal on 10/01/08.
City of Atlantic Beach
FINANCIAL REPORT
FEBRUARY 2009
Project Activity -Current Year Activity Only
AGENDA ITEM # 4A
MARCH 23, 2009
Project YTD YTD YTD
Project Name Number Budget Actual Balance
Status
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
Public Works:
Statue -Turtle
Cabinets for Donner
Gate at Dutton Island
Park Playground
Tennis Courts/Improvements/DonnerPark
Howell Park Bridge
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
Subtotal
PS0504 660,000 0 660,000
PU0706 84,005 79,356 4,649
PU0801 14,000 0 14,000
PU0802 184,132 183,938 194
PU0805 150,276 0 150,276
PU0901 349,000 324,690 24,310
PU0902 30,000 20,325 9,675
PU0903 18,708 18,428 280
PU0904 800,000 0 800,000
PU0905 510,000 0 510,000
2,140,121 626,737 1,513,384
PM0805 73,307 20,700 52,607
PM0901 2,000 0 2,000
PM0902 0 0 0
PM0903 45,000 0 45,000
PM0905 147,000 0 147,000
PM0906 50,000 0 50,000
PW0309 1,110 1,110 0
PW0401 156,428 11,089 145,339
PW0802 0 0 0
PW0803 51,732 0 51,732
PW0807 33,933 33,904 29
PW0808 400,000 26,476 373,524
PW0901 8,200 0 8,200
PW0904 50,000 20,368 29,632
PW0905 2,810,000 0 2,810,000
Subtotal 3,828,710 113,647 3,715,063
Total $6,628,831 $740,384 $5,888,447
Status Kev
B -Bid Awarded E -Design Phase
C -Project Completed I -Project In-progress
D -Design Completed R - Re-budget Next Fiscal Year
X -Project Cancelled
E
C
E
I
C
C
X
C
I
X
C