Item 4ACity of Atlantic Beach AGENDA ITEM#4A
FINANCIAL REPORT ApIUL26,aolo
MARCH 2010
Cash Balances
Fund(s)
Prior
02/28/10
Current
03/31 /10
Dollar
Change
General
Tree Replacement
Convention Development Tax
Local Option Gas Tax
Better Jax 1/2 Cent Sales Tax
Police Training, Forfeit, etc.
Community Development Block Grant
Debt Service
Capital Projects
utility
Sanitation
Building Code Enforcement
Storm Water
Pension -Police
Pension -General
Total
$5,544,289
18,741
35,431
199,245
564,398
176,179
(100)
37,083
1,052,896
3,584,265
528,916
41,240
3,700,425
916
147,433
$15,631,357
$5,208,546
8,890
41,439
187,535
524,029
176, 832
(100)
42,786
1,131,819
3,656,785
571,493
43, 341
3,559,278
33,817
31,013
$15,217,503
$7,442,417
$7,775,086
($335,743)
(9,851)
6,008
(11,710)
(40,369)
653
0
5,703
78,923
72, 520
42,577
2,101
(141,147)
32,901
(116,420)
($413,854)
Total Restricted Cash
Total Unrestricted Cash
Cash and Investments
Account
Prior
02/28/10
Current
Dollar Rate of
Bank of America -Depository $9,608,276
5th 3rd Bank -Certificate of Deposit 6,019,961
SBA -Florida Prime 220
Cash on Hand 2,900
Subtotal 15.631.357
Police Pension Investments 5,745,338
General Pension Investments 9,504,718
Subtotal 15,250,056
Total $30,881,413
03/31 /10
$15,214,384
0
219
2,900
15, 217, 503
5,861,405
9,908,784
15,770,189
$30,987,692
Change Return
$5,606,108 0.30
(6,019,961) 0.65
(1) 0.20
0 N/A
(413, 854)
116, 067
404, 066
520,133
4.00 (1)
3.83 (1)
$106,279
(1) YTD rate of return through 12/31/09
City of Atlantic Beach AGENDA ITEM # 4A
APRIL 26, 2010
FINANCIAL REPORT
MARCH 2010
Revenues
Fund / (Footnote) Annual
Estimate YTD - 50%
of Estimate YTD
Actual Dollar
Variance Percent
Variance
General (1) $11,796,728 $5,898,364 $7,372,720 $1,474,356 25.00%
Tree Replacement 0 0 3,920 3,920 100.00%
Convention DevefopmentTax 80,500 40,250 31,595 (8,655) -21.50%
Local Option Gas Tax 455,764 227,882 218,543 (9,339) -4.10%
Better Jax 1/2 Ct Sales Tax 612,334 306,167 303,344 (2,823) -0.92%
Police Training, Forfeit, etc. 25,750 12,875 11,988 (887) -6.89%
Community Development Block Grant 116,296 82,737 4,912 (77,825) -94.06%
Debt Service 69,000 34,500 34,244 (256) -0.74%
Capital Projects 1,002,000 501,000 499,822 (1,178) -0.24%
Utility (2) 13,484,898 6,742,449 3,754,752 (2,987,697) -44.31
Sanitation 1,822,000 911,000 910,354 (646) -0.07%
Building Code Enforcement (3) 308,050 154,025 126,517 (27,508) -17.86%
Storm Water 933,000 466,500 464,942 (1,558) -0.33%
Pension -Police (4) 910,823 455,412 574,163 118,751 26.08%
Pension -General (4) 1,449,292 724,646 972,671 248,025 34.23%
Total $33,066,435 $16,557,807 $15,284,487 ($1,273,320)
Analysis of Major Variances
(1) The $1,474,356 positive variance in the General Fund resulted from having received
88% of the budgeted amount of property taxes to date. Typically the majority of the
property taxes are received from the City of Jacksonville in December & January.
(2) The $2,987,697 negative variance in the Utility Funds resulted from not having issued
the 2009 Revenue Notes and not having received the funds from the SRF loan. If the
amounts to be financed were not included in this calculation, the variance would be a
negative 1.09%.
(3) The $27,508 negative variance in the Building Code Enforcement Fund resulted from
not having issued projected to date building permits. Typically October through February
are slow months for construction activity and the majority of the permits are anticipated to
be issued in the warmer months.
(4) The $118,751 positive variance in the Police Employee Pension Fund & the $248,025
positive variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
MARCH 2010
Expenses
AGENDA ITEM # 4A
APRIL 26, 2010
Department / (Footnote) Annual
Estimate YTD - 50%
of Estimate YTD
Actual Dollar
Variance Percent
Variance
Governing Body $43,303 $21,652 $21,864 ($212) -0.98%
City Administration 2,532,025 1,266,014 1,136,334 129,680 10.24%
General Government 642,296 321,148 306,999 14,149 4.41%
Planning and Building 508,068 254,034 238,520 15,514 6.11%
Public Safety (1) 6,343,731 3,171,867 2,608,284 563,583 17.77%
Recreation and Special Events 387,063 193,532 186,588 6,944 3.59%
Public Works (2) 8,916,675 4,458,340 3,221,530 1,236,810 27.74%
Public Utilities (3) 13,894,380 6,947,183 4,370,106 2,577,077 37.10%
Pension -Police 519,506 259,753 256,364 3,389 1.30%
Pension -General 513,359 256,680 248,491 8 189 3.19%
Total $34,300,406 $17,150,203 $12,595,080 $4,555,123
Annual YTD - 50% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (1) $9,291,713 $4,645,857 $4,155,243 $490,614 10.56%
Operating Expenses (1) - (2) 9,793,935 4,896,968 4,376,101 520,867 10.64%
Capital Outlay (1) - (3) 10,381,355 5,190,676 1,211,317 3,979,359 76.66%
Debt Service (4) 1,755,495 877,748 1,313,465 (435,717) -49.64%
Transfers 3,077,908 1,538,954 1,538,954 0 0.00%
Total $34,300,406 $17,150,203 $12,595,080 $4,555,123
Analysis of Major Variances
(1) The positive variance in the Public Safety department resulted from: vacant positions in
the Police Patrol and Detectives division, seasonality of the Lifeguards and the Police
Building project has had limited activity -see Project Activity Schedule.
(2) The positive variance in the Public Works department resulted from limited activity on the
Royal Palms Stormwater and Park Improvement projects -see Project Activity Schedule.
The paving budgeted in the Local Option Gas Tax Fund will not be expended until the
Royal Palms Stormwater project is completed.
(3) The positive variance in the Public Utilities department resulted from limited activity on
the projects budgeted in the Sewer Fund -see Project Activity Schedule.
(4) The negative variance in the Debt Service accounts resulted from the semi-annual
payment of principal and interest on the Utility Revenue Bonds in October, 2009.
City of Atlantic Beach
FINANCIAL REPORT
MARCH 2010
Project Activity -Current Year Activity Only
AGENDA ITEM # 4A
APRIL 26, 2010
Project Name Project
Number YTD
Budget YTD
Actual YTD
Balance
Status
Public Safety
Lifeguard Building Roof Replacement LG0901 2,979 0 2,979 X
Police Building Renovation/Design/Construction PS0504 435,788 18,068 417,720 E
438,767 18,068 420,699
Public Utilities:
Replace Well at Water Plant #1 PU0304 794,675 24,166 770,509 E
Reclaimed Water Plant Construction PU0805 150,276 0 150,276
TMDL - WWTP #1 Design PU0905 566,125 187,690 378,435 E
TMDL -Lift Station/Main Transfer Flow PU0906 3,847,296 100,839 3,746,457 E
Generator- Mimosa Cove Lift Station PU0907 31,518 31,518 0 C
Elevated Tank -Water Plant #1 PU1001 15,000 0 15,000
Ground Storage Tank Rehab -Water Plant #1 PU1002 30,000 0 30,000
Water Main -Ocean Boulevard/10th to 14th Street PU1003 150,331 21,422 128,909 I
Collection Syatem Inspection & Rehab PU1004 100,000 0 100,000
Mimosa Cove Lift Station Upgrades PU1005 160,000 0 160,000
Lift Station E Upgrades PU1006 200,000 0 200,000
Gavagan Lift Station PU1007 8,338 0 8,338
Camelia & West 3rd Street Lift Station PU1008 12,000 0 12,000 I
Schooner's Bay Lift Station PU1009 12,972 0 12,972
Stewart Street Lift Station PU1010 17,190 0 17,190 I
Selva Norte Lift Station PU1011 4,500 0 4,500 I
Hydroscreen Replacement PU1012 6,000 0 6,000
Concrete to GRIT Container PU1013 8,500 0 8,500
Subtotal 6,114,721 365,635 5,749,086
Public Works:
Riverbranch Preserve PM0804 74,804 54 74,750 A
Tennis Courts at Donner Community Center PM0905 13,354 4,912 8,442 I
Howell Park Bridge #5 PM0908 8,500 8,500 0 C
Howell Park Bridge Replacement PM1001 20,000 9,500 10,500 I
Jordan Park -Drainage & Parking PM1002 30,000 0 30,000
Jordan Park -Water Fountain PM1003 5,000 0 5,000
Jordan Park -Covered Shelter PM1004 25,000 0 25,000
Roof at Donner Park Community Center PM1005 50,000 0 50,000
Veteran's Park -Flag & Pavilion PM1006 10,196 10,196 0 C
Donner Park -Accessory Building PM1007 48,387 100 48,287 A
Royal Palms Design PW0808 37,026 22,898 14,128 I
Royal Palms Stormwater Project PW0905 3,162,257 636,030 2,526,227 I
Sidewalk -Dutton Island Road & Donner Park PW1001 43,732 0 43,732
Sidewalk/Curb Replacement - FY 2010 PW1002 25,000 578 24,422 I
Manhole - Saturiba & Seminole Road PW1003 15,000 0 15,000
Subtotal
Total
Status Kev
A -Bid Advertised
B -Bid Awarded
C -Project Completed
D -Design Completed
3,568,256 692,768 2,875,488
$10,121,744 $1,076,471 $9,045,273
I -Project In-progress
N -Complete/Non-Capital
R - Re-budget Next Fiscal Year
X -Project Cancelled
AGENDA ITEM # 4A
APRIL 26, 2010
City of Atlantic Beach, FI.
Utility Sales Report
March 2010
Water Sales
Atlantic Beach
Buccaneer
Total Water Sales
Gallons Actual Revenue
Accounts 0000 Revenue Per 7,000 gl
5,573 31,918 $122,782 $3.85
2,461 18,071 $81,423 $4.51
Water Plant Production
Atlantic Beach
Buccaneer
Total Production
Total Water Billed
Water Loss for month:
Percentage Loss
Total 12 mo. Avg. Loss
®Sewer Sales
Atlantic Beach
Buccaneer
Total Sewer Sales
i Sewer Treatment
Atlantic Beach
Buccaneer
Total Sewer Treated
Gallons
0000
50,873
15, 333
66,208
49,989
18,217
24.49%
14.19%
March 2009
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,00o gi
5,590 42,826 $136,000 $3.18
2,448 21,444 $78,217 $3.65
Gallons
0000
54,401
17,984
72,385
64,270
8,115
11.21%
12.15%
Gallons Actual Revenue Gallons Actual Revenue'
Accounts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per ~,ooo yi
5,111 27,950 $201,239 $7.20 5,122 34,430 $203,483 $5.91
2,333 16,984 $153,317 $9.03 2,324 20,177 $136,443 $6.76
7,444 44,934 $354,558 $7.89 7.446 54.607 5339.926 X6.22
Gallons Actual Revenue
0000 Revenue Per 1,000 gl
Gallons Actual Revenue
0000 Revenue Per ~.ooo ai
46.942 $201,239 $4.29 59.626 $203,483 $3.41
17.210 $153,317 $8.91 20.056 $136,443 $6.80
64.152 $354,558 $5.53 79.682 5339.926 54.27