Item 4AAGENDA ITEM #4A
MARCH 27, 2006
City of Atlantic Beach, F1.
Utility Sales Report
February 2006 February 2005
Gallons Actual Revenue Gallons Actual Revenue
Water Sales Accounts (000) Revenue Per 1,000 gi Accounts (000) Revenue Per 1,000 gl
Atlantic Beach 5,555 41,184 $96,765 $2.35 5,494 41,593 $89,139 $2.14
Buccaneer 2,676 26,139 $69,361 $2.65 2,675 27,168 $66,149 $2.43
Total Water Sales
~I 8,231 67,323 $166,128 $2.47 8,169 68,761 $155,288 $2.26
Water Plant Produc tion
', Gallons Gallons
(000) (000)
Atlantic Beach 45,175 52,103
Buccaneer 19,381 21,505
Total Production 64,556 73,608
Total Water Billed 67,323 68,761
Water Loss for month: (2,767) 4,847
Percentage Loss x.29% 6.58%
Total 12 mo. Avg. Loss 9.17% 11.92%
Gallons Actual Revenue Gallons Actual Revenue
Sewer Sales Accounts (000) Revenue Per 1,000 gi Accounts (000) Revenue Per 1,000 gi
Atlantic Beach 5,029 34,537 $156,787 4.54 4,946 33,773 $148,084 4.38
Buccaneer 2,558 25,298 $137,594 5.44 2,559 25,404 $131,658 5.18
Total Sewer Sales 7,587 59,835 $294,382 $4.92 7,505 59,177 $279,742 $4.73
Sewer Treatment
Millions of Gallons 62.37 68.13
Rev. r 1,000 Gallons $4.72 $4.11
AGENDA ITEM #4A
MARCH 27, 2006
City of Atlantic Beach
FINANCIAL REPORT
FEBRUARY 2006
Cash Balances
Prior Current Dollar
Fund(s) 01/31/06 02/28/06 Change
General $6,340,274 $6,355,404 $15,130
Tree Replacement 30,978 30,978 0
Convention Development Tax 158,716 164,290 5,574
Local Option Gas Tax 403,514 420,219 16,705
Better Jax 1/2 Cent Sales Tax 1,022,488 930,967 (91,521)
Police Training, Forteit, etc. 5,224 567 (4,657)
Grants (20,553) (28,616) (8,063)
Debt Service 38,896 44,864 5,968
Utility 3,568,930 3,593,185 24,255
Sanitation 544,741 546,670 1,929
Storm Water 2,971,542 2,950,422 (21,120)
Pension -Police 19,609 15,525 (4,084)
Pension -General 5,147 27,721 22,574
Total $15,089,506 $15,052,196 ($37,310)
Total Restricted Cash $6,542,863
Total Unrestricted Cash $8,509,333
Cash and Investments
Prior Current Dollar Rate of
Account 1/31/06 2/28/06 Change Return
Bank of America -Depository $110,200 $251,995 $141,795 3.47
SBA 14,976,756 14,797,651 (179,105) 4.56
Cash on Hand 2,550 2,550 0 -
Subtotal 15,089,506 15,052,196 (37,310)
Suntrust-Pension-Police 4,313,077 4,318,580 5,503 2.00 (1)
Merrill Lynch-Pension-Police 586,278 580,897 (5,381) 7.10 (1)
Suntrust-Pension-General 5,975,194 5,981,839 6,645 1.90 (1)
Merrill Lynch-Pension-General 1,244,011 1,232,593 (11,418) 7.10 (1)
Subtotal 12,118,560 12,113,909 (4,651)
Total $27,208,066 $27,166,105 ($41,961)
(1) FYTD rate of return through 12/31/05
AGENDA ITEM #4A
MARCH 27, 2006
City of Atlantic Beach
FINANCIAL REPORT
FEBRUARY 2006
Revenues
Fund / (Footnote) Annual
Estimate YTD - 42%
of Estimate YTD
Actual Dollar
Variance Percent
Variance
General (1) $9,951,978 $4,149,975 $6,000,903 $1,850,928 44.60%
Tree Replacement 0 0 0 0 100.00%
Convention Development Tax 128,000 53,376 32,977 (20,399) -38.22%
Local Option Gas Tax 564,042 235,206 230,319 (4,887) -2.08%
Better Jax 1/2 Ct Sales Tax 702,336 292,874 323,944 31,070 10.61%
Police Training, Forfeit, etc. 31,800 13,260 4,898 (8,362) -63.06%
Grants (2) 447,833 186,746 69,776 (116,970) -62.64%
Debt Service 71,100 29,649 30,104 455 1.53%
Utility 6,623,534 2,762,013 2,633,809 (128,204) -4.64%
Sanitation 1,362,300 568,079 544,751 (23,328) -4.11%
Storm Water (3) 1,067,868 445,301 310,582 (134,719) -30.25%
Pension -Police 702,355 292,882 325,265 32,383 11.06%
Pension -General (4) 1,015,029 423,267 571,488 148,221 35.02%
Total $22,668,175 $9,452,628 $11,078,816 $1,626,188
Analysis of Major Variances
(1) The $1,850,928 positive variance in the General Fund resulted from having received
90.1 % of the year's budgeted property taxes by February, 2006. Typically the majority of
these taxes are received from the City of Jacksonville in December & January.
(2) The $116,970 negative variance in the Grant Funds resulted from either items not
having been purchased or reimbursement requests not having been filed as of February
28, 2006.
(3) The $134,719 negative variance in the Stormwater Fund resulted from the award of a
grant in fiscal year 2006 that has not been received.
(4) The $148,221 positive variance in the General Employee Pension Fund resulted from
changes in the market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
FEBRUARY 2006
Expenses
AGENDA ITEM #4A
MARCH 27, 2006
Annual YTD - 42% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $45,938 $19,156 $19,692 ($536) -2.80%
City Administration 2,122,737 885,182 799,831 85,351 9.64%
General Government (1) 2,223,615 927,247 640,141 287,106 30.96%
Planning and Building (2) 651,118 271,516 185,970 85,546 31.51%
Public Safety (3) 4,714,649 1,966,009 1,441,045 524,964 26.70%
Parks and Recreation 1,023,072 426,621 386,222 40,399 9.47%
Public Works (4) 6,230,758 2,598,225 1,793,391 804,834 30.98%
Public Utilities 7,115,581 2,967,197 2,966,730 467 0.02%
Pension -Police 400,936 167,190 160,385 6,805 4.07%
Pension -General 405,798 169 218 157,290 11,928 7.05%
Total $24,934,202 $10,397,561 $8,550,697 $1,846,864
Annual YTD - 42% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services $7,909,947 $3,298,447 $2,847,864 $450,583 13.66%
Operating Expenses (2)-(4) 9,537,621 3,977,188 3,109,790 867,398 21.81%
Capital Outlay (1) & (4) 5,019,321 2,093,057 1,007,864 1,085,193 51.85%
Debt Service (5) 1,678,236 699,824 1,256,397 (556,573) -79.53%
Transfers 789,077 329 045 328,782 263 0.08%
Total $24,934,202 $10,397,561 $8,550,697 $1,846,864
Analysis of Major Variances
(1) The positive variance in the General Government departments resulted from not having
begun the various budgeted projects -see the Project Activity Schedule.
(2) The positive variance in the Planning 8~ Building departments resulted from no monies
being expended in the Community Development Block Grant or the Tree Replacement
Fund as of February 28, 2006.
(3) The positive variance in the Public Safety department is due to the payment for the City
of Jacksonville fire contract being paid quarterly, the lifeguard expenses being seasonal
and no expenditures in some of the grants.
(4) The majority of the positive variance in the Public Works department resulted from not
having begun the various budgeted projects -see the Project Activity Schedule. Also,
the waste management contract and First Vehicle are not billed and paid until the month
after the services are provided.
(5) The negative variance in the Debt Service departments resulted from the October
payment of principal and interest on the Utility Revenue Bonds.
City of Atlantic Beach
FINANCIAL REPORT
FEBRUARY 2006
Project Activity -Current Year Activity Only
AGENDA ITEM #4A
MARCH 27, 2006
Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
General Government:
City Hall Expansion
Parks and Recreation:
Beautification
Public Safety
Police Building Renovations
Homeland Security Items
GG0402 $2,816 $0 $2,816
Subtotal 2,816 0 2,816
PR0601 45,000 0 45,000
Subtotal 45,000 0 45,000
PS0504 475,000 2,570 472,430
PS0601 138,000 0 138,000
Subtotal 613 000 2,570 610,430
Public Works:
Plaza Entrance/Post Office
Hopkins Creek Basin Pond
Mayport Road Medians
Welcome Sign and Landscaping
Ocean/13th -Coast Drive/12th
Five Points Intersection Improvement
Sidewalks -New
Plaza Drive Phase 2 Pedestrian Path
Sidewalks -Replacements
Seminole Ditch Headwall
Pathway -Plaza (West of Mayport Road)
Concrete Floor for Shed
Medians Rehab -Atlantic Boulevard
Roll Off Concrete Pads
Sidewalks & Curbs
Paving of City Hall Parking Lot
Pathways
Sidewalks - Sailfish,Royal Palm & Frances
Selva Tierra Ditch Improvements
Pathway -Seminole Road Phase 1
Pathway -Seminole Road Phase 2
Subtotal
Public Utilities:
Security Upgrade/Water Plants
Headwork Improvements at WWTP2
Water Line at 10th Street & Beach Avenue
Mayport Road Sewer Crossing
Fence Replacement at Water Plant 1
Water Main at Sailfish Drive & Plaza
Sewer Crossing Ditch at Palm Landing
Genset at Lift Station B
Clarifier Rehabilitation
Fence Replacement at WWTP 1
Sludge Container Refurbishment
Subtotal
Total
PW0305 55,080 54,687 393
PW0309 1,301,500 0 1,301,500
PW0401 346,858 0 346,858
PW0405 78,000 52 77,948
PW0409 141,816 3,063 138,753
PW0502 346,643 305,416 41,227
PW0503 26,175 26,175 0
PW0504 30,000 19,616 10,384
PW0505 10,752 5,864 4,888
PW0507 12,974 12,974 0
PW0508 27,144 27,144 0
PW0601 8,800 8,800 0
PW0602 20,000 0 20,000
PW0603 10,000 0 10,000
PW0604 50,000 3,592 46,408
PW0605 84,000 0 84,000
PW0606 149,000 0 149,000
PW0607 90,800 446 90,354
PW0608 25,954 0 25,954
PW0609 63,000 62,973 27
PW0610 55,152 43,122 12,030
2,933,648 573,924 2,359,724
PU0305 2,485 2,485 0
PU0310 52,027 52,027 0
PU0503 97,776 83,446 14,330
PU0504 50,000 0 50,000
PU0601 70,000 0 70,000
PU0602 65,294 484 64,810
PU0603 30,000 0 30,000
PU0604 44,650 0 44,650
PU0605 100,000 0 100,000
PU0606 15,000 0 15,000
PU0607 15,000 0 15,000
542,232 138,442 403,790
$4,136,696 $714,936 $3,421,760
Status Key
B -Bid Awarded E -Design Phase
C -Project Completed I -Project In-progress
D -Design Completed R - Re-budget Next Fiscal Year
C
D
I
E
E
I
I
I
C
I
I
C
C
C
C
C
I
E