Exh 4ACity of Atlantic Beach
FINANCIAL REPORT
JUNE 2005
AGENDA ITIJM #4A
JULY 25, 2005
Cash Balances
Prior Current Dollar
Fund(s) 05131!05 06/30105 Change
General
Tree Replacement
Convention Development Tax
Local Option Gas Tax
Better Jax 112 Cent Sales Tax
. Police Training, Forfeit, etc.
Grants
' Debt Service
Capital Project
Utility
Sanitation
Storm Water
' Pension -Police
Pension -General
Total
Total Restricted Cash
Total Unrestricted Cash
$6,349,283
$7,788,995
Cash and Investments
Prior Current Dollar Rate of
Account 05/31/05 06/30/05 Change Return
Bank of America -Depository $177,350 $58,023 ($119,327) 2.03
SBA $13,873,275 $14,078,205 204,930 3.07
Cash on Hand $2,050 $2,050 0 -
Subtotal 14,052,675 14,138,278 85,603
Suntrust-Pension-Police 4,069,229 4,091,772 22,543 4.20 (1)
Merrill Lynch-Pension-Police 452,363 460,114 7,751 13.60 (1}
Suntrust-Pension-General 5,530,255 5,562,619 32,364 4.20 (1)
Merrill Lynch-Pension-General 959,980 976,356 16,376 13.60 (1)
Subtotal 11,011,827 11,090,861 79,034
Total $25,064,502 $25,229,139 $164,637
$5,399,386 $5,067,431 ($331,955)
30,978 30,978 0
102,675 130,454 27,779
325,765 330,964 5,199
954,876 1,001,480 46,604
34,957 30,802 (4,155)
(51,755) (38,098) 13,657
62,483 57,451 (5,032)
0 0 0
4,084,487 4,170,648 86,161
579,418 641,314 61,896
2,480,074 2,653,722 173,648
14,988 10,064 (4,924)
34,343 51,068 16,725
$14,052,675 $14,138,278 $85,603
(1) FYTD rate of return through 03/31/05
City of Atlantic Beach
FINANCIAL REPORT
JUNE 2005
Revenues
AGENDA ITIrM #4A
JULY 25, 2005
Annual YTD - 75% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $9,274,236 $6,955,677 $7,697,090 $741,413 10.66%
Tree Replacement 13,778 10,334 13,778 3,444 33.33%
Convention Development Tax 177,000 132,750 162,396 29,646 22.33%
Local Option Gas Tax 519,800 389,850 412,000 22,150 5.68%
Better Jax 112 Ct Sales Tax (2) 617,300 462,975 530,676 67,701 14.62%
Police Training, Forfeit, etc. 33,180 24,886 21,616 (3,270) -13.14%
Grants (3) 282,707 212,030 352,103 140,073 66.06%
Debt Service 73,035 54,776 55,249 473 0.86%
Capital Project 0 0 286 286 0.00%
Public Utilities 6,627,412 4,970,559 5,012,091 41,532 0.84%
Sanitation 1,413,367 1,060,025 1,078,930 18,905 1.78%
Storm Water 2,608,063 1,956,047 1,995,653 39,606 2.02%
Pension -Police 523,361 392,521 464,024 71,503 18.22%
Pension -General (4) 775,943 581,957 824,750 242,793 41.72%
Total $22,939,182 $17,204,387 $18,620,642 $1,41fi,255
Analysis of Major Variances
(1) The $741,413 positive variance in the General Fund resulted primarily from the receipt
of 96.5% of the property taxes from the City of Jacksonville having been received in the
first nine months of fiscal year 2005.
(2) The $67,701 positive variance in the Better Jacksonville 'h Cent Sales Tax Fund
resulted from 87% of the revenues from the State of Florida having been received in the
first nine months of fiscal year 2005.
(3) The $140,073 positive variance in the Grant Funds resulted from cash being received in
fiscal year 2005 for the reimbursement of expenses incurred in fiscal year 2004 ($8,035
in the Local Law Enforcement Block Grant, $7,016 in the Safe Neighborhood Grant,
$54,307 in the CDBG & $57,465 in the FDOT -DUI Enforcement Grant) and a request
for reimbursement for fiscal year 2005 in the CDBG for 79% of the amount budgeted.
(4) The $242,793 positive variance in the General Employee Pension Fund resulted from
increases in the market values of the investments above estimates. The Police
Employee Pension Fund has not received the Section 185 funds and therefore the
variance for better than expected investment returns is not evident in this schedule.
AGENDA ITEM #4A
JULY 25, 2005
City of Atlantic Beach
FINANCIAL REPORT
JUNE 2005
~• Expenses
Annual YTD - 75% YTD Dollar Percent
Department !(Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $43,807 $32,855 $34,706 ($1,851) -5.63%
City Administration 2,015,979 1,511,985 1,408,313 103,672 6.86%
General Government (1) 4,102,314 3,076,736 2,523,726 553,010 17.97%
Planning and Building 771,070 578,303 506,946 71,357 12.34%
Public Safety (2) 4,148,554 3,111,417 2,820,951 290,466 9.34%
Parks and Recreation 981,209 735,907 696,663 39,244 5.33%
Public Works (3) 6,060,135 4,545,102 2,847,718 1,697,384 37.35%
Public Utilities (3) 7,628,910 5,721,678 5,155,334 566,344 9.90%
Pension -Police 337,266 252,950 238,250 14,700 5.81
Pension -General 382 231 286 673 268 267 18 406 6.42%
Total $26,471,475 $19,853,606 $16,500,874 $3,352,732
Annual YTD Estimate YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services $7,410,405 $5,557,804 $5,253,725 $304,079 5.47%
Operating Expenses (2) 8,895,993 6,671,995 5,461,364 1,210,631 18.14%
Capital Outlay (1) & (3) 5,266,727 3,950,045 1,748,219 2,201,826 55.74%
Debt Service (4) 1,756,403 1,317,302 1,647,711 (330,409) -25.08%
Transfers 3 141,947 2,356 460 2 389 855 33 395 -1.42%
Total $26,471,475 $19,853,606 $16,500,874 $3,352,732
Analysis of Major Variances
(1) The positive variance in the General Government departments resulted from not having
begun some of the various projects funded from this source until January, 2005 -see the
Project Activity Schedule. The variance includes: the Mayport Road Medians, the Plaza
Road Entrance for the Post Oftice and the Five Points Intersection Improvements.
(2) The positive variance in the Public Safety departments is due to the City of Jacksonville
not billing on a timely basis for fire & rescue services and the lifeguard season having
just begun. This positive variance is partially offset by the negative variance in Police
Patrol overtime being over budget.
(3) The positive variance in the Public Works & Public Utilities departments resulted from
not having begun or a less than 75% completion status of some of the various projects
funded from this source -see the Project Activity Schedule. The largest of these
projects is the Hopkins Creek Drainage project that has not begun due to issues
surrounding the land acquisition.
(4) The negative variance in the Debt Service accounts resulted from the semi-annual
payment of principal and interest in October and the payment of interest in April on the
Utility Revenue Bonds.
City of Atlantic Beach
FINANCIAL REPORT
JUNE 2005
AGIJNDA ITIJIVI #4A
JULY 25, 2005
Project Activity -Current Year Activity Only
YTD YTD YTD
Project Name Budget Actual Balance Status
General Government:
City Hall Expansion
Parks and Recreation:
Skateboard Park
Veteran's Memorial Park
Public Safety
Police Building Design
$458,768 $302,681 156,087
Subtotal 458,768 302,681 156,087
195,927 195,780 147 C
22,963 22,963 0 C
Subtotal 218,890 218,743 147
30,000 275 29,725
Subtotal 30,000 275 29,725
Public Works:
Plaza EntrancelPost Office
Hopkins Creek Basin Pond
Mayport Road Medians
Drainage-George & Dudley Streets
Bike Paths on Seminole and Plaza
Welcome Sign and Landscaping
Oceanl13th -Coast Drive/12th
Shed -Equipment Storage
Five Points Intersection Improvement
Sidewalks -New
Pedestrian Path -Plaza Road
Sidewalks -Replacements
19th Street Ditch Bulkhead
Seminole Ditch Headwall
Subtotal
Public Utilities:
Telemetry for Water System
Replace Well 2 at WWTP1
Security Upgrade/VVater Plants
Telemetry at Lift Stations
Headwork Improvements at WWTP2
Relocate Elevated Storage Tank at WP2
Kesner Road Waterline Replacement
Fence at Water Plants 1, 2 & 3
Water Line at 10th Street & Beach Avenue
Mayport Road Sewer Crossing
Lift Station Scada
Pond Liner Replacement
Digester Blowers at WWTP 2
Utility Relocation - Wonderwood Connector
Subtotal
Total
100,000 1,750 98,250
1,423,149 18, 989 1,404,160
301,942 11,648 290,294
97,930 97,930 0
230,291 170,108 60,183
37,600 0 37,600
137,000 13,209 123,791
15,000 12,637 2,363
315,000 29,505 285,495
61,500 9,616 51,884
75,000 2,150 72,850
50,000 2,898 47,102
12,000 0 12,000
35,000 0 35,000
2,891,412 370,439 2,520,973
6,043 0 6,043
6,389 6,389 0
14,864 14,864 0
90,811 90,811 0
361,182 63,239 297,943
89,108 81,938 7,170
52,726 29,537 23,189
24,500 17,000 7,500
261,670 5,250 256,420
64,663 6,656 58,008
105,550 87,166 18,384
45,000 0 45,000
60,000 51,417 8,583
122,386 122,386 0
1,304,892 576,653 728,239
$4,903,962 $1,468,790 $3,435,172
Status Key
A -Bid Advertised D -Design Completed
B -Bid Awarded E -Design Phase
C -Project Completed I -Project In-progress
A
E
E
E
C
I
E
I
E
I
E
I
C
C
C
I
I
I
I
E
E
I
I
C
AGENDA ITEM #4A
JULY 25, ?005
City of Atlantic Beach, FI.
' ' Utility Sales Report
~e..,. _
Water Sales
Atlantic Beach
Buccaneer ,.~. ,
ccounts
5,570
2,704
June 2005
Gallons Actual
(000) Revenue
52,377 $123,363
28,347 $70,079
evenue
Per 1,000 gl
$2.36
$2.47
ccounts
5,495
2,726
June 2004
Gallons Actual
(000) Revenue
53,868 $103,716
47,432 $104,734
evenue
Per 1,000 gl
$1.93
$2.21
Total Water Sales 8,274 80,724 $193,442 $2.40 8,221 101,300 $208,450 $2.06
~.r~l ~...i!~1t.lA d ..F~.a ,.,.Y .°.'.!R.•f 'i~.~~ . ~'A'~.. ...t:'1 'C t ~P...::
Water Plant Produc tion
Gallons Gallons
(ooo) (ooo)
Atlantic Beach 60,358 65,959
Buccaneer 24,230 26,440
Total Production 84,588 92,399
Total Water Billed 80,724 101,300
Water Loss for month: 3,864 (8,901)
Percentage Loss 4.57% -9.83%
Total 12 mo. Avg. Loss 11.93% 13.59%
Gallons Actual Revenue Gallons Actual Revenue
Sewer Sales Accounts (000) Revenue Per 1,000 gl Accounts (000) Revenue Per 1,000 gl
Atlantic Beach 5,016 39,511 $169,628 4.29 4,931 38,804 $152,586 3.93
Buccaneer 2,583 26,217 $134,823 5.14 2,616 28,785 $135,065 4.69
Total Sewer Sales 7,599 65,728 $304,451 $4.83 7,547 87,589 $287,651 $4.26
I Sewer Treatment
Millions of Gallons 80.39 69.52
Rev. er 1,000 Gallons $3.79 $4.14