Item 4A~" City of Atlantic Beach AGENDA ITEM #4A
FINANCIAL REPORT JUNE 26, 2006
May, 2006
Cash Balances
~.
Prior Current Dollar
Fund(s) 04/30/06 05/31/06 Change
General $6, 063,148 $5, 931, 354 ($131,794)
~„ Tree Replacement 30,978 25,503 (5,475)
Convention Development Tax 151,437 152,049 612
Local Option Gas Tax 455,861 473,165 17,304
Better Jax 1/2 Cent Sales Tax 904,493 972,270 67,777
Police Training, Forfeit, etc. (904) (4,698) (3,794)
Grants (35,824) (27,184) 8,640
Debt, Service 56,908 62,984 6,076
Utility 3,561,231 3,719,368 158,137
Sanitation 537,021 534,544 (2,477)
~"' Storm Water 2,780,346 2,760,315 (20,031)
Pension -Police (715) 24,143 24,858
Pension -General 58,100 17,895 (40,205)
Total $14,562,080 $14,641,708 $79,628
Total Restricted Cash $6,541,655
Total Unrestricted Cash $8,100,053
Cash and Investments
'~ -Prior Current Dollar Rate of
Account 4/30/06 5/31/06 Change Return
Bank of America -Depository $202,906 $166,296 ($36,610) 3.95
SBA 14,356,624 14,472,862 116,238 5.03
~"" Cash on Hand 2,550 2,550' 0 -
Subtotal 14,562,080 14,641,708 79,628
"' Police Pension Investments 5,032,742 4,909,596 (123,146) 5.60 (1)
General Pension Investments 7,435,389 7,352,784 (82,605) 5.90 (1)
Subtotal 12,468,131 12,262,380 (205,751)
~,
Total $27,030,211 $26,904,088 ($126,123)
(1) FYTD rate of return through 03/31/06
AGENDA ITEM #4A
JUNE 26, 2006
City of Atlantic Beach
~, FINANCIAL REPORT
May, 2006
~, Revenues
Annual YTD - 67% YTD Dollar Percent
Fund ! (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $9,951,978 $6,637,969 $7,970,273 $1,332,304 20.07%
Tree Replacement 0 0 0 0 100.00%
Convention Development Tax 128,000 85,376 45,736 (39,640) -46.43%
Local Option Gas Tax 564,042 376,216 367,267 (8,949) -2.38%
Better Jax 1/2 Ct Sales Tax 702,336 468,458 517,948 49,490 10.56%
"` Police Training, Forfeit, etc. 31,800 21,211 13,484 (7,727) -36.43%
Grants (2) 508,111 338,911 113,380 (225,531) -66.55%
Debt Service 71,100 47,424 48,223 799 1.68%
Utility (3) 6,685,534 4,459,252 4,304,349 (154,903) -3.47%
Sanitation 1,362,300 908,654 873,857 (34,797) -3.83%
Storm Water (4) 1,067,868 712,268 501,591 (210,677) -29.58%
Pension -Police 702,355 468,471 444,158 (24,313) -5.19%
~.
Pension -General (5)
1,015,029
677,024
809,058
132,034
19.50%
Total $22,790,453 $15,201,234 $16,009,324 $808,090
Analysis of Major Variances
(1) The $1,332,304 positive variance in the General Fund resulted from having received
99.3% of the year's budgeted property taxes by May, 2006. Typically the majority of
these taxes are received from the City of Jacksonville in December 8 January.
(2) The $225,531 negative variance in the Grant Funds resulted from either items not
having been purchased or reimbursement requests not having been filed as of May 31,
2006.
(3) The $154,903 negative variance in the Utility Funds resulted from lower consumption
than budgeted. Consumption is billed in arrears and typically increases in the spring and
summer months.
(4) The $210,677 negative variance in the Stormwater Fund resulted from the award of a
grant in fiscal year 2006 that has not been received.
(5) The $132,034 positive variance in the General Employee Pension Fund resulted from
changes in the market values of the investments.
~. AGENDA ITEM #aA
JUNE 26, 2006
City of Atlantic Beach
FINANCIAL REPORT
May, 2006
Expenses
Annual YTD - 67% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $46,938 $31,308 $33,926 ($2,618) -8.36%
City Administration 2,119, 933 1,413, 995 1,266, 580 147,415 10.43%
General Government (1) 2,250,185 1,500,873 897,231 603,642 40.22%
~'" Planning and Building 684,579 456,615 325,373 131,242 28.74%
Public Safety (2) 4,736,835 3,159,469 2,555,997 603,472 19.10%
Parks and Recreation 1,022,247 681,839 607,214 74,625 10.94%
,~„ Public Works (3) 6,214,842 4,145,300 2,963,773 1,181,527 28.50%
Public Utilities 7,172,599 4,784,123 4,568,307 215,816 4.51%
Pension -Police 400,936 267,424 260,543 6,881 2.57%
Pension -General 405,798 270,667 266,334 4,333 1.60%
Total $25,054,892 $16,711,613 $13,745,278 $2,966,335
Annual YTD - 67% YTD Dollar Percent
"~ Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (4) $7,899,947 $5,269,264 $4,809,991 $459,273 8.72%
Operating Expenses (2) & (3) 9,531,838 6,357,736 5,318,471 1,039,265 16.35%
~"' Capital Outlay (1) & (3) 5,155,794 3,438,915 1,435,454 2,003,461 58.26%
Debt Service (5) 1,678,236 1,119,383 1,655,310 (535,927) -47.88%
Transfers 789,077 526,315 526,052 263 0.05%
~,. Total $25,054,892 $16,711,613 $13,745,278 $2,966,335
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 Public Safety department is due to the payment for the City
of Jacksonville fire contract being paid quarterly, the lifeguard expenses being seasonal,
two vacant positio~~s in ti.e Patrol division and no expenditures in some of the grants.
(3) 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.
(4) The positive variance in Personal Services is due to vacant positions in Information
Technology, Sewer Wastewater, Police Department Patrol Division and the Lifeguard
positions being seasonal.
(5) The negative variance in the Debt Service departments resulted from the payment of
principal and interest on the Utility Revenue Bonds in the months of October & April.
~""' City of Atlantic Beach
FINANCIAL REPORT
May, 2006
Project Activity -Current Year Activity Only
AGENDA ITEM #4A
JUNE 26, 2006
Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
~, Parks and Recreation:
Beautification PR0601 45,000 0 45,000
Subtotal 45,000 0 45,000
Public Safety
Police Building Renovations PS0504 475,000 2,570 472,430
Homeland Security Items PS0601 138,000 0 138,000
Subtotal 613,000 2,570 610,430
Public Works:
~„ Plaza Entrance/Post Office PW0305 54,686 54,686 0
Hopkins Creek Basin Pond PW0309 1,300,000 0 1,300,000
Mayport Road Medians PW0401 346,858 55,858 291,000
Welcome Sign and Landscaping PW0405 78,000 3,852 74,148
~"" Ocean/13th -Coast Drive/12th PW0409 141,816 141,797 19
Five Points Intersection Improvement PW0502 346,599 331,141 15,458
Sidewalks -New PW0503 26,175 26,175 0
~.. Plaza Drive Phase 2 Pedestrian Path PW0504 37,500 37,109 391
Sidewalks -Replacements PW0505 5,864 5,864 0
Seminole Ditch Headwall PW0507 12,974 12,974 0
Pathway -Plaza (West of Mayport Road) PW0508 27,144 27,144 0
Concrete Floor for Shed PW0601 8,800 8,800 0
Medians Rehab -Atlantic Boulevard PW0602 3,500 0 3,500
Roll Off Concrete Pads PW0603 10,000 0 10,000
Sidewalks & Curbs PW0604 50,000 18,952 31,048
Paving of City Hall Parking Lot PW0605 84,000 0 84,000
Pathways PW0606 149,000 0 149,000
Sidewalks - Sailfish,Royal Palm & Frances PW0607 90,800 23,196 67,604
,~, Selva Tierra Ditch Improvements PW0608 25,954 25,954 0
Pathway -Seminole Road Phase 1 PW0609 63,000 62,973 27
Pathway -Seminole Road Phase. 2 PW0610 47,652 44,700 2,952
'~'' Pathway -Seminole Road Phase 2 PW0611 17,000 0 17,000
Traffic Isle- Mandalay Park 2,927,322 881,176 2,046,147
~„ Public Utilities:
Security Upgrade/Water Plants PU0305 2,485 2,485 0
Headwork Improvements at WWTP2 PU0310 52,027 52,027 0
Water Line at 10th Street & Beach Avenue PU0503 83,446 83,446 0
"°~ Fence Replacement at Water Plant 1 PU0601 70,000 0 70,000
Water Main at Sailfish Drive & Plaza PU0602 65,703 484 65,219
Sewer Crossing Ditch at Palm Landing PU0603 30,000 0 30,000
Genset at Lift Station B PU0604 44,650 0 44,650
Clarifier Rehabilitation PU0605 100,000 0 100,000
Fence Replacement at WWTP 1 PU0606 15,000 0 15,000
Sludge Container Refurbishment PU0607 15,000 0 15,000
~ Beach Habitat Subdivision PU0608 120,595 0 120,595
Subtotal 598,906 138,442 460,464
Total $4,184,228 $1,022,187 $3,162,040
Status Kev
B -Bid Awarded E -Design Phase
~* C -Project Completed I -Project In-prog ress
D -Design Completed R - Re-budget Next Fiscal Year
D
C
E
E
I
C
I
C
C
C
C
C
C
I
C
C
I
C
C
~,.
~.
~..
~.
..
~.
~a.
AGENDA ITEiV1 #4A
JUNE 26, 2006
City of Atlantic Beach, FI.
Utility Sales Report
.~
Ma 2006
Ma 2005
Gallons Actual Revenue ~ Gallons Actual Revenue
` Water Sales =Accounts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per 1,000 gl `':,
Atlantic Beach
5,615
53,933 $131,172 $2.43
5,531
46,299
$107,786 xi
$2.33 ~'~
Buccaneer 2,585 28,324 $74,036 $2.61'' 2,690 30,170 $75,246 $2.49
Total Water Sales 8,200 82,257 $205,208 $2.49 ` 8,221 76,469 $183,032 52.39
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
Sewer Treatment
Atlantic Beach
Buccaneer
Total' Sewer Treated
Gallons Gallons
0000 0000
71, 720 65, 544
23,598 26,901
95,318 92,445
82,257 76,469
13,061 15,976
13.70% 17.28%
9.85% 9.57%
Gallons Actual Revenue Gallons Actual Revenue
Accounts 0000 - Revenue Per i,ooa 9i Accounts 0000 Revenue Per 1,000 s~
5,093 40,681 $178,207 $4.38 4,972 36,.530 $159,153 $4.36
2,467 26,937 $142,270 $5.28 2,574 28,566 $145,725 $5.10
Gallons Actual Revenue
0000 Revenue Per 1,000 gl
46.294 $178,207 $3.85
21.091: $142,270 $6.75
Gallons Actual Revenue
0000 Revenue Per 1,000 9i
56.929 $159,153 $2.80
24.269 $145,725 $6.00
81.198 $304,878 53.75