Item 4A v~' City of Atlantic Beach
FINANCIAL REPORT AGENDA ITEM #4A
June, 2006 JULY 24, 2006
Cash Balances
Prior Current Dollar
Fund(s) May, 2006 June, 2006 Change
General
„~ Tree Replacement
Convention Development Tax
Local Option Gas Tax
~. Better Jax 1/2 Cent Sales Tax
Police Training, Forfeit, etc.
Grants
Debt Service
Utility
Sanitation
~'' Storm Water
Pension -Police
Pension -General
$5,931,354
25,503
152,049
473,165
972,270
(4,698)
(27,184)
62,984
3,719,368
534, 544
2,760,315
24,143
17,895
$14,641,708
$5,719,010
20,913
159,895
479,089
989,375
(15,567)
(26,124)
58,896
3,804,042
529,773
2,784,927
16,154
35,860
$14,556,243
($212,344)
(4,590)
7, 846
5,924
17,105
(10,869)
1, 060
(4,088)
84,674
(4,771)
24,612
(7,989)
17,965
($85,465)
Total
Total Restricted Cash
Total Unrestricted Cash
$6,551,631
$8,004,612
Cash and Investments
• Prior Current Dollar Rate of
Account May, 2006 June, 2006 Change Return
Bank of America -Depository
SBA
~" Cash on Hand
Subtotal
~"" Police Pension Investments
Gel~eral Pension Investments
Subtotal
$166,295 $68,171
14,472, 863 14,485, 522
2,550 2,550
14, 641, 708 14, 556, 243
4,909,596
7,352,784
12,262,380
4,918,684
7,365,264
12,283,948
($98,124) 4.03
12,659 5.17
0 -
(85,465)
9,088 5.60 (1)
12,480 5.90 (1)
21,568
Total $26,904,088 $26,840,191 ($63,897)
(1) FYTD rate of return through 03/31/06
~.
~.
City of Atlantic Beach
FINANCIAL REPORT
June, 2006
Revenues
AGENDA ITEM #4A
JULY 24, 2006
Annual YTD - 75% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $9,951,978 $7,463,984 $8,431,621 $967,637 12.96%
Tree Replacement 0 0 0 0 100.00%
Convention pevelopment Tax 128,000 96,000 57,382 (38,618) -40.23%
Local Option Gas Tax 564,042 423,032 415,437 (7,595) -1.80%
Better Jax 1/2 Ct Sales Tax 702,336 526,752 578,791 52,039 9.88%
~"' Police Training, Forteit, etc. 31,800 23,851 13,499 (10,352) -43.40%
Grants (2) 508,111 381,083 113,380 (267,703) -70.25%
Debt Service 71,100 53,325 54,300 975 1.83%
~. Utility 6,685,534 5,014,151 4,956,198 (57,953) -1.16%
Sanitation 1,362,300 1,021,725 987,669 (34,056) -3.33%
Storm Water (3) 1,067,868 800,901 567,210 (233,691) -29.18%
~. Pension -Police 702,355 526,766 476,307 (50,459) -9.58%
Pension -General (4) 1,015,029 761,272 871,732 110,460 14.51
Total $22,790,453 $17,092,842 $17,523,526 $430,684
Analysis of Major Variances
(1 j The $967,637 positive variance in the General Fund resulted from having received
99.9% of the year's budgeted property taxes by June, 2006. Typically the majority of
these taxes are received from the City of Jacksonville in December & January.
(2) The $267,703 negative variance in the Grant Funds resulted from either items not
having been purchased or reimbursement requests not having been filed as of June 30,
2006.
(3) The $233,691 negative variance in the Stormwater Fund resulted from the award of a
grant in fiscal year 2006 that has not been received.
(5) The $110,460 positive variance in the General Employee Pension Fund resulted from
changes in the market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
June, 2006
AGENDA ITEM #4A
JULY 24, 2006
Expenses
~.
Annual
YTD - 75%
YTD
Dollar
Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $46,938 $35,204 $37,326 ($2,122) -6.03%
City Administration 2,157,933 1,618,450 1,429,207 189,243 11.69%
General Government (1) 2,250,185 1,687,639 934,627 753,012 44.62%
Planning and Building 684,579 513,434 359,633 153,801 29.96%
Public Safety (2) 4,736,835 3,552,628 2,885,746 666,882 18.77%
Parks and Recreation 1,022,247 766,686 691,424 75,262 9.82%
Public Works (3) 6,214,842 4,661,132 3,440,263 1,220,869 26.19%
Public Utilities 7,172,599 5,379,446 5,007,657 371,789 6.91%
Pension -Police 400,936 300,702 291,591 9,111 3.03%
Pension -General 405 798 304 349 298 562 5 787 1.90%
Total $25,092,892 $18,819,670 $15,376,036 $3,443,634
Annual YTD - 75% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (4) $7,886,115 $5,914,586 $5,488,940 $425,646 7.20%
Operating Expenses (2) & (3) 9,571,978 7,178,984 6,099,362 1,079,622 15.04%
Capital Outlay (1) & (3) 5,167,486 3,875,615 1,517,752 2,357,863 60.84%
Debt Service (5) 1,678,236 1,258,677 1,678,174 (419,497) -33.33%
Transfers 789,077 591,808 591,808 0 0.00%
Total $25,092,892 $18,819,670 $15,376,036 $3,443,634
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 positions in the 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
June, 2006
Project Activity -Current Year Activity Only
AGENDA ITEM #4A
JULY 24, 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 - Coasi Drive/12th PW0409 141,816 i 41,797 19
~s
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
RoIIOffConcretePads PW0603 10,000 6,180 3,820
Sidewalks & Curbs PW0604 48,480 18,952 29,528
"~' Paving of City Hall Parking Lot PW0605 80,650 2,909 77,741
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,922,452 890,264 2,032,188
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
Lift Station Scada PU0505 5,820 0 5,820
""' 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 26,507 0 26,507
Clarifier Rehabilitation PU0605 132,020 0 132,020
Fence Replacement at WWTP 1 PU0606 12,637 0 12,637
Sludge Container Refurbishment PU0607 8,900 0 8,900
Beach Habitat Subdivision PU0608 120,595 0 120,595
Subtotal 610,140 138,442 471,698
Total $4,190,592 $1,031,276 $3,159,316
~.
Status Key
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
C
C
C
~.
AGENDA ITEM #4A
JULY 24, 2006
City of Atlantic Beach, F1.
Utility Sales Report
June 2006 June 2005
Gallons Actual Revenue Gallons Actual Revenue
Water Sales Accounts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per 1,000 gi
Atlantic Beach 5,569 53,104 $131,903 $2.48 5,570 52,377 $123,363 $2.36
Buccaneer 2,584 28,907 $73,986 $2.56 2,704 28,347 $70,079 $2.47
Total Water Sales 8,153 82,011 5205,889 52.51 8,274 80,724 5193,442 52.40
Gallons Gallons
Water Plant Production 0000 0000
Atlantic Beach 66,772 60,358
Buccaneer 22,630 24,230
Total Production 89,402 84,588
Total Water Billed 82,011 80,724
Water Loss for month: 7,391 3,864
Percentage Loss 8.27% 4.57%
Total 12 mo. Avg. Loss 10.16% 10.37%
Gallons Actual Revenue Gallons Actual Revenue
Sewer Sales .Accounts 0000 Revenue Per 1,000 gi :,Accounts 0000 Revenue Per 1,000 gi
Atlantic Beach 5,057 38,839 $171,857 $4.42 5,016 39,511 $169,628 $4.29
Buccaneer 2,465 27,023 $144,034 $5.33 2,583 26,217 $134,823 $5.14
'Total Sewer Sales 7,522 65,862 5315,890 54.80 7,599 65,728 $304,451 54.63
Gallons Actual Revenue Gallons Actual Revenue
Sewer Treatment 0000 Revenue Per 1,000 gi 0000 Revenue Per 1,000 gi
Atlantic Beach 47.390 $171,857 $3.63 56.467 $169,628 $3.00
Buccaneer 16.509 $144,034 $8.72 23.923 $134,823 $5.64
Total Sewer Treated 63.899 5315,890 54.94 80.390 $304,451 53.79