Item 4ACity of Atlantic Beach SEPTEMBERS 8, io 9
FINANCIAL REPORT
AUGUST 2009
Cash Balances
Fund(s)
General
Community Development Block Grant
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 Current Dollar
07/31/09 08/31/09 Change
$4,916,148
(49, 775)
14,822
21, 973
290,294
711,169
211,909
63,165
599,481
3,129,009
508,800
74,253
3,946,973
25,813
89,605
$14,553,639
$4,373,162
(2,988)
14, 822
12,798
310,370
720, 958
194,404
68, 894
627,180
3,242,714
510,223
66,338
4,084,357
105,830
110, 848
$14,439,910
$7,421,946
$7,017,964
($542,986)
46,787
0
(9,175)
20,076
9,789
(17,505)
5,729
27,699
113,705
1,423
(7,915)
137,384
80,017
21.243
($113,729)
Cash and Investments
Account
Prior
07/31 /09
Current Dollar Rate of
08/31/09 Change Return
-__
Bank of America -Depository
Bank of America -Certificate of Deposit
5th 3rd Bank -Certificate of Deposit
5th 3rd Bank -Certificate of Deposit
SBA
Cash on Hand
Police Pension Investments
General Pension Investments
Subtotal
Subtotal
Total
$6,506,912
6,032,653
2,009,915
0
1,259
2,900
14,553,639
5,169,980
8,551,627
13,721,607
$28,275,246
$6,422,266
0
2,012,734
6, 000, 748
1,262
2,900
14,439,910
5,294,296
8,759,894
14,054,190
($84,646)
(6,032,653)
2,819
6,000,748
3
0
0.30
1.24
1.66
0.65
0.41
N/A
(113,729)
124,316
208,267
332,583
7.95 (1)
8.27 (1)
$28,494,100 $218,854
(1) FYTD rate of return through 06/30/09
City of Atlantic Beach
FINANCIAL REPORT
AUGUST 2009
Revenues
AGENDA ITEM # 4A
SEPTEMBER 28, 2009
Annual ( YTD - 92% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $10,391,868 $9,529,343 $9,917,413 $388,070 4.07%
Tree Replacement 0 0 4,914 4,914 100.00%
Convention Development Tax 85,000 77,945 59,522 (18,423) -23.64%
Local Option Gas Tax 496,872 455,632 422,548 (33,084) -7.26%
Better Jax 1/2 Cent Sales Tax 638,188 585,218 590,725 5,507 0.94%
Police Training, Forfeit, etc. 40,150 36,819 31,184 (5,635) -15.30%
Grants 214,284 196,498 119,152 (77,346) -39.36%
Debt Service 69,500 63,732 62,954 (778) -1.22%
Capital Projects 335,000 307,195 303,717 (3,478) -1.13%
Utility (2) 9,398,075 8,618,035 6,741,153 (1,876,882) -21.78%
Sanitation 1,872,500 1,717,083 1,783,517 66,434 3.87%
Building Code Enforcement 207,500 190,278 186,148 (4,130) -2.17%
Storm Water (3) 2,374,600 2,177,508 2,768,737 591,229 27.15%
Pension -Police 812,280 744,861 647,006 (97,855) -13.14%
Pension -General 1,320,428 1,210,832 1,152,261 58,571 -4.84%
Total $28,256,245 $25,910,979 $24,790,951 ($1,120,028)
Analysis of Major Variances
(1) The $388,070 positive variance in the General Fund resulted from having received 99%
of the budgeted amount of property taxes & 120% of the budgeted amount of the Utility
Service Taxes from JEA.
(2) The $1,876,882 negative variance in the Utility Funds resulted from charges for services
$282,409 below projected year to date amounts, system development charges $247,876
below projected year to date amounts and not having transferred the budgeted amount of
$1,558,343 from the General Fund. These transfers will be executed as the work
progresses on the well replacement & TMDL projects -see Project Activity Schedule.
(3) The $591,229 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.
City of Atlantic Beach AGENDA ITEM # 4A
FINANCIAL REPORT sEPTEMBER2s,zoo9
AUGUST 2009
Expenses
Department / (Footnote) Annual
Estimate YTD - 92%
of Estimate YTD
Actual Dollar
Variance Percent
Variance
Governing Body $48,076 $44,086 $37,902 $6,184 14.03%
City Administration 2,645,981 2,426,364 2,252,185 174,179 7.18%
General Government (1) 4,101,465 3,761,044 2,226,397 1,534,647 40.80%
Planning and Building 565,974 518,997 473,097 45,900 8.84%
Public Safety (2) 6,019,866 5,520,217 4,598,720 921,497 16.69%
Recreation and Special Events 455,619 417,803 372,665 45,138 10.80%
Public Works (3) 9,862,108 9,043,554 5,383,782 3,659,772 40.47%
Public Utilities (1) 9,389,931 8,610,567 6,832,096 1,778,471 20.65%
Pension -Police 451,236 413,783 453,517 (39,734) -9.60%
Pension -General 485,152 444,884 449,172 (4,288) -0.96%
Total $34,025,408 $31,201,299 $23,079,533 $8,121,766
Annual YTD - 92% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services $9,297,043 $8,525,388 $8,313,304 $212,084 2.49%
Operating Expenses (2) & (3) 10,341,445 9,483,105 8,341,242 1,141,863 12.04%
Capital Outlay (1 ), (2) & (3) 8,172,913 7,494,561 2,146,797 5,347,764 71.36%
Debt Service 1,681,207 1,541,667 1,680,416 (138,749) -9.00%
Transfers (1) 4,532,800 4,156,578 2,597,774 1,558,804 37.50%
Total $34,025,408 $31,201,299 $23,079,533 $8,121,766
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 payment being due
quarterly to the City of Jacksonville for fire & rescue services (three payments have been
expensed fiscal year to date); 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 10 of 11
monthly payments have been paid on the Advanced Disposal Services Jax LLC contract,
only 48% of the budget for paving has been spent in the Local Option Gas Tax Fund, the
projects for the renovation of the City Parks have had limited activity and the Royal Palms
Stormwater project has not started -see Project Activity Schedule.
City of Atlantic Beach
FINANCIAL REPORT
AUGUST 2009
AGENDA ITEM # 4A
SEPTEMBER 28, 2009
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 9,475 650,525
Public Utilities:
Replace Well #2 at Water Plant #1 PU0304 800,000 5,325 794,675
TMDL Engineering PU0706 84,005 84,005 0
SCADA Improvements PU0801 14,000 14,000 0
Collection System Inspection & Rehabilitation PU0802 183,939 183,938 1
Reclaimed Water Plant Construction PU0805 150,276 0 150,276
Collection System Rehabilitation PU0901 349,597 349,593 4
Check Valve -Water Plant #1 PU0902 25,244 20,325 4,919
Concrete to GRIT Container PU0903 18,708 18,428 280
New Well PU0904 0 0 0
Design TDML PU0905 710,000 124,206 585,794
TMDL -Lift Station Transfer Flow PU0906 390,000 54,426 335,574
Generator -Mimosa Cove Lift Station PU0907 40,000 0 40,000
Subtotal 2,765,769 854,246 1,911,523
Public Works:
Buckman Trust Property PM0804 191,000 190,410 590
Statue -Turtle PM0805 73,307 61,444 11,863
Cabinets for Donner PM0901 0 0 0
Gate at Dutton Island PM0902 0 0 0
Park Playground PM0903 45,000 42,109 2,891
Tennis Courts/Improvements/DonnerPark PM0905 147,000 55,390 91,610
Howell Park Bridge PM0906 15,000 14,850 150
Dune Crossover - 3rd Street Extension PM0907 7,075 7,075 0
Hopkins Creek Retention PW0309 1,110 1,110 0
Mayport Road Medians PW0401 156,428 73,477 82,951
Pedestrian Path Extensions PW0802 0 0 0
Sidewalks -George & Edgar Streets PW0803 51,732 39,508 12,224
Ardella Road Drainage Project PW0807 33,753 33,904 (151)
Royal Palms Design PW0808 393,000 292,975 100,025
Sidewalk/Pedestrian Path PW0901 0 0 0
Sidewalk & Curb PW0904 45,000 41,347 3,653
Royal Palms Stormwater Project PW0905 3,220,000 0 3,220,000
Subtotal 4,379,405 853,599 3,525,806
Total $7,805,174 $1,717,320 $6,087,854
Status Key
B -Bid Awarded
C -Project Completed
D -Design Completed
E -Design Phase
I -Project In-progress
N -Complete/Non-Capital
R - Re-budget Next Fiscal Year
X -Project Cancelled
E