Item 4A v~,.
Clty Of At~antlC Beach
FINANCIAL REPORT AGENDA ITEM#4A
NOVEMBER 27, zoos
~" OCTOBER 2006
Cash Balances
Prior Current Dollar
Fund(s) 09/30/06 10/31/06 Change
General $5,017,648 $4,469,113
($548,535)
~• Tree Replacement 20, 913 20, 913 0
Convention Development Tax. 184,732 162,105 (22,627)
Local Option Gas Tax 266,143 287,365 21,222
~"' Better Jax 1 /2 Cent Sales Tax 1,126,899 1,167,238 40,339
Police Training, Forfeit, etc. 8,215 7,042 (1,173)
Grants 0 64,907 64,907
~"" Debt Service 77,265 83,482 6,217
Utility 4,074,315 3,369,073 (705,242)
~, Sanitation 479,859 486,121 6,262
Storm Water 2,808,708 2,721,689 (87,019)
Pension -Police 33,607 26,770 (6,837)
~„ Pension -General 7,891 29,830 21,939
Total $14,106,195 $12,895,648 ($1,210,547)
Total Restricted Cash $6,795,018
~.
Total Unrestricted Cash $6,100,630
Cash and Investments
Prior Current Dollar Rate of
Account 9130106 10/31/06 Change Return
Bank of America -Depository
SBA
Cash on Hand
Subtotal
$170,966 $253,135 $82,169
13,932,679 12,639,963 (1,292,716)
2,550 2,550 0
14,106,195 12,895,648 (1,210,547)
4.36
5.37
Police Pension Investments 5,152,102 5,265,033 112,931
General Pension Investments 7,701,101 7,866,383 165,282
Subtotal 12,853,203 13,131,416 278,213
Total $26,9.59,398 $26,027,064 ($932,334)
(1) FYTD rate of return through 09/30/06
9.40 (1)
10.00 (1)
r^
City of Atlantic Beach
FINANCIAL REPORT
~^ OCTOBER 2006
Revenues
AGENDA ITEM # 4A
NOVEMBER 27, 2000
Annual I YTD - 8% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $10,576,532
,~„ Tree Replacement 0
Convention Development Tax 81,000
Local Option Gas Tax 563,042
~„ Better Jax 1/2 Ct Sales Tax 761,298
Police Training, Forteit, etc. 31,250
Grants (2) 209,234
~• Debt Service 73,048
Utility (3) 6,750,002
Sanitation 1,462,200
Storm Water 1,862,500
Pension -Police (4) 765,862
Pension -General (4) 1,096,364
.. Total $24,232,332
$877,852 $732,675 ($145,177) -16.54%
0 0 0 100.00%
6,723 6,904 181 2.69%
46,732 46,794 62 0.13%
63,188 60,089 (3,099) -4.90%
2,594 27 (2,567) -98.96%
17,367 88,005 70,638 406.74%
6,063 6,216 153 2.52%
560,251 605,573 45,322 8.09%
121,363 110,039 (11,324) -9.33%
154,588 128,704 (25,884) -16.74%
63,567 139,470 75,903 119.41%
90,998 219,496 128,498 141.21
$2,011,286 $2,143,992 $132,706
Analysis of Major Variances
(1) The $145,177 negative variance in the General Fund resulted from not having received
property taxes. Typically the majority of these taxes are received from the City of
Jacksonville in December & January.
(2) The $70,368 positive variance in the Grant Funds resulted from the reimbursement of
expenses from the prior fiscal year in October, 2006.
(3) The $45,322 positive variance in the Utility Funds resulted from billed revenues
exceeding estimated amounts & collection of the tower lease payment in October, 2006.
(4) The $75,903 positive variance in the Police Employee Pension Fund & the $128,498
positive variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
~,.
City of Atlantic Beach
FINANCIAL REPORT
~„ OCTOBER 2006
AGENDA ITEM # 4A
NOVEMBER 27, 200E
Expenses
Department / (Footnote)
Governing Body
City Administration
General Government (1)
Planning and Building
Public Safety (2)
Parks and Recreation
Public Works (3)
Public Utilities (4)
Pension -Police
Pension -General
Total
Annual YTD - 8% YTD Dollar Percent
Estimate of Estimate Actual Variance Variance
$50,898 $4,225 $4,695 ($470) -11.12%
2,253,291 187,023 169,637 17,386 9.30%
2,977,978 247,173 128,833 118,340 47.88%
652,227 54,135 25,955 28,180 52.06%
4,759,060 395,001 224,176 170,825 43.25%
1,185,330 98,382 76,669 21,713 22.07%
7,723,057 641,014 359,583 281,431 43.90%
7,655,855 635,436 1,282,854 (647,418) -101.89%
424,133 35,203 33,376 1,827 5.19%
436,713 36,247 32,273 3,974 10.96%
$28,118,542 $2,333,839 $2,338,051 ($4,212)
Annual YTD Estimate YTD Dollar Percent
Resource Allocation Estimate 8% Actual Variance Variance
Personal Services (5)
Operating Expenses (2) & (3)
Capital Outlay (1) & (3)
Debt Service (4)
~"" Transfers
Total
$8,576,372 $711,838 $503,142 $208,696 29.32%
9,708,652 805,819 554,806 251,013 31.15%
6,814,764 565,625 40,291 525,334 92.88%
1,675,695 139,083 1,127,891 (988,808) -710.95%
1,343,059 111,474 111,921 (447) -0.40%
$28,118,542 $2,333,839 $2,338,051 ($4,212)
Analysis of Major Variances
(1) The positive variance in the General Government departments resulted from not having
begun the various projects funded from this source -see Project Activity Schedule.
(2) The positive variance in the Public Safety departments is partially due to the payment
being due quarterly to the City of Jacksonville for fire & rescue services. The next
payment is due in January 2007 for October through December 2006. Also, there is a
vacant position in the Police Patrol division.
(3) The positive variance in the Public Works departments resulted from the waste
management and First Vehicle contracts not having been paid in October 2006 and not
having begun various projects funded from this source -see Project Activity Schedule.
(4) The negative variance in the Public Utilities department resulted from the October
payment of principal and interest on the Utility Revenue Bonds.
(5) The positive variance in the Personal Services is typical for the first month of the new
fiscal year due to the payroll expense only including three weeks of the month of
October. The last week of October will not be paid until November. This explains why
approximately 29% of October's budgeted payroll has not been expensed.
~• I~_
'~ City of Atlantic Beach
FINANCIAL REPORT
~, OCTOBER 2006
AGENDA ITEM#dA
NOVEMBEh 27, ?006
Project Activity -Current Year Activity Only
~" Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
General Government:
Buchman Trust Property
*~ Parks and Recreation:
Jordan Park Shelter
Playground Equipment-Donner Park
~„ Shade for the Skate Park
Russell Park Light Replacements
Public Safety
Police Building Renovations
GG0701 $450,000 $0 $450,000
Subtotal 450,000 0 450,000
PR0701 10,000 0 10,000
PR0702 35,000 0 35,000
PR0703 18,000 0 18,000
PR0704 17,500 0 17,500
Subtotal 80,500 0 80,500
PS0504 466,850 0 466,850 E
Subtotal 466,850 0 466,850
Public Utilities:
Fence Replacement at Water Plant 1
~" Genset at Lift Station B
Clarifier Rehabilitation at WWTP 1
Fence Replacement at WWTP 1
~. Sludge Container Refurbishment
Beach Habitat Subdivision
Remodel SCADA Control Area
,,, Roof Replacement at Lab/Office
Begonia Street Water & Sewer Extension
Collection System Inspection & Rehabilitation
Replace 2 Hydroscreens
TMDL Engineering WWTP 1
Subtotal
Public Works:
Hopkins Creek Retention
Mayport Road Medians
Five Points Intersection Improvement
Pathways
Sidewalks - Sailfish,Royal Palm & Frances
Storage Bins for Limerock
Mandalay Park Improvements
Repave Asphalt at Public Works Yard
Asphalt Stewart Street at West Main Street
Sidewalk & Curb Replacement
Pedestrian Path -Five Points to Selva Marina
New Sidewalks -Marsh Oaks
Ocean Boulevard Between 14th & 15th Street
Subtotal
Total
Status Key
B -Bid Awarded
+~ C -Project Completed
D -Design Completed
PU0601 12,049 0 12,049
PU0604 26,507 0 26,507
PU0605 145,223 0 145,223
PU0606 3,984 0 3,984
PU0607 8,900 0 8,900
PU0608 151,179 0 151,179
PU0701 20,000 0 20,000
PU0702 10,000 0 10,000
PU0703 100,000 0 100,000
PU0704 365,400 0 365,400
PU0705 30,000 0 30,000
PU0706 350,000 0 350,000
1,223,242 0 1,223,242
PW0309 2,530,730 4,292 2,526,438
PW0401 400,000 0 400,000
PW0502 8,164 5,914 2,250
PW0606 66,500 500 66,000
PW0607 5,102 0 5,102
PW0701 30,000 0 30,000
PW0702 50,000 0 50,000
PW0703 70,000 0 70,000
PW0704 10,000 0 10,000
PW0705 50,000 0 50,000
PW0706 120,000 0 120,000
PW0707 120,000 0 120,000
PW0708 350,000 0 350,000
3,810,496 10,706 3,799,790
$6,031,088 $10,706 $6,020,382
E -Design Phase
I -Project In-progress
R - Re-budget Next Fiscal Year
..
AGENDA ITEM # 4A
NOVEtiIBER 27, 2006
City of Atlantic beach, FI.
Water and Sewer Utility Sales Report
October 2006 October 2005
Water Sales
Accounts Gallons
0000 Actual
Revenue Revenue
Per 1,000 9i
:Accounts Gallons
0000 Actual
Revenue Revenue
Per 1,000 9I
Atlantic Beach
Buccaneer 5,596
2,552 48,873
26,371 $124,068
$74,377 $2.54
$2.82 5,638
. 2,718 50,113
28,467 $122,427
$73,097 $2.44
$2.57
Total Water Sales 8,148 75,244 $198,445 $2.64 8,356 78,580 $195,524 52.49 ,
Gallons Gallons
.Water Plant Production 0000 0000
Atlantic Beach ~ 64,934 56,693
Buccaneer 24,114 24,644
Total Production 89,048 81,337
Total Water Billed 75,244 78,580
:Water Loss for month: 13,804 2,757
Percentage Loss 15.50% 3.39°k
Total 12 mo. Avg. Loss 10.72°~ 10.85%
Gallons Actual Revenue Gallons Actual Revenue
'Sewer Sales Accounts 0000 Revenue Per 1,000 gI ;Accounts 0000 Revenue Per 1,000 gl
Atlantic Beach 5,070 36,085 $165,600 $4.59 5,046 38,403 $165,858 $4.32
Buccaneer 2,437 24,433 $136,487 $5.59 2,583 26,875 $141,718 $5.27
Total Sewer Sales 7,507 60,518 5302,086 54.99 7.629 65.278 5307.576 $4.77
Sewer Treatment
Atlantic Beach
Buccaneer
Total Sewer Treated
Gallons Actual Revenue
0000 Revenue Per 1,000 gl
50.565 $165,600 $3.27
23.667 $136,487 $5.77
74.232 5302.086 54.07
Gallons Actual Revenue
0000 Revenue Per 1,000 gl
51.725 $165,858 $3.21
21.481 $141,718 $6.60.
73.206 5307,576 54.20 =^~
~.