Item 4A
0
City of Atlantic Beach
FINANCIAL REPORT
DECEMBER 2006
AGENDA ITEM # 4A
JANUARY 22, 200'7
Cash Balances
Prior Current Dollar
Fund 11/30/06 12/31/06 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
Total
$4, 331,168
20,913
162,759
312,488
1,214,663
6,627
56, 510
89,718
3,441,157
570,453
1, 924,473
20, 309
47,306
$12,198,544
$6,043,140
20,913
163,448
309,762
1,252,422
9, 587
65,956
32,430
3,511,404
569,424
1,971,166
14,177
64, 621
$14,028,450
$1,711,972
$0
$689
($2,726)
$37,759
$2,960
$9,446
($57,288)
$70,247
($1,029)
$46,693
($6,132)
$17,315
$1,829,906
Total Restricted Cash
Total Unrestricted Cash
$6,806,033
$7,222,417
..
Cash and Investments
Prior Current Dollar Rate of
Account 11/30/06 12/31/06 Change Return
Bank of America -Depository
SBA
Cash on Hand
Subtotal
$484,092 $85,266
11, 711, 902 13, 940, 634
2,550 2,550
12,198,544 14,028,450
Police Pension Investments 5,370,217 5,387,366
General Pension Investments 8,026,344 8,059,747
Subtotal 13,396,561 13,447,113
~,.
($398,826) 4.34
2,228,732 5.40
0 -
1,829,906
17,149
33,403
50, 552
Total $25,595,105 $27,475,563 $1,880,458
(1) FYTD rate of return through 09/30/06
9.40 (1)
10.00 (1)
~•
AGENDA ITEM # 4A
~' City of Atlantic Beach rANUARV22,zoo~
FINANCIAL REPORT
DECEMBER 2006
Revenues
Fund / (Footnote)
General (1)
~ Tree Replacement
Convention Development Tax
Local Option Gas Tax
,~, Better Jax 1/2 Ct Sales Tax
Police Training, Forfeit, etc.
Grants (2)
,~, Debt Service
Utility
Sanitation
~. Storm Water (3)
Pension -Police (4)
Pension -General (4)
Total
Annual YTD - 25% YTD Dollar Percent
Estimate of Estimate Actual Variance Variance
$10,576,532 $2,644,133 $3,899,203 $1,255,070 47.47%
0 0 0 0 100.00%
81,000 20,250 8,247 (12,003) -59.27%
563,042 140,761 140,972 211 0.15%
761,298 190,325 193,935 3,610 1.90%
31,250 7,813 13,346 5,533 70.82%
209,234 52,308 123,389 71,081 135.89%
73,048 18,262 18,598 336 1.84%
6,750,002 1,687,501 1,725,349 37,848 2.24%
1,462,200 365,550 331,257 (34,293) -9.38%
1,862,500 465,625 378,848 (86,777) -18.64%
765,862 191,466 315,197 123,731 64.62%
1,096,364 274,091 519,644 245,553 89.59%
$24,232,332 $6,058,085 $7,667,985 $1,609,900
Analysis of Major Variances
(1) The $1,255,070 positive variance in the General Fund resulted from having received
property taxes in December, 2006. Typically the majority of these taxes are received
from the City of Jacksonville in December & January. Also, the 4~h quarter of 2006
reimbursement for Beach Maintenance & Lifeguards was received ,from. the City of
Jacksonville in October, 2006.
(2) The $71,081 positive variance in the Grant Funds resulted from the reimbursement of
expenses from the prior fiscal year in October, November and December, 2006.
(3) The $86,777 negative variance in the Stormwater Fund resulted from not having begun
construction on the Hopkins Creek Retention project -see Project Activity Schedule.
This project is partially funded on a reimbursement basis grant for $400,000 from the
Florida Department of Environmental Protection.
(4) The $123,731 positive variance in the Police Employee Pension Fund & the $245,553
positive variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
A
ae~
~..
City of Atlantic Beach
FINANCIAL REPORT
DECEMBER 2006
Expenses AGENDA ITEM # 4A
JANUARY 22, aoo~
~'"' Annual YTD - 25% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $50,898 $12,725 $13,823 ($1,098) -8.63%
City Administration 2,253,291 563,324 566,588 (3,264) -0.58%
General Government (1) 3,037,978 759,495 386,091 373,404 49.16%
'~" Planning and Building 652,227 163,057 84,432 78,625 48.22%
Public Safety (2) 4,759,060 1,189,768 820,951 368,817 31.00%
Parks and Recreation 1,185,330 296,333 259,899 36,434 12.29%
~" Public Works (3) 7,723,057 1,930,760 1,822,550 108,210 5.60%
Public Utilities (4) 7,650,855 1,912,714 2,153,671 (240,957) -12.60%
Pension -Police 424,133 106,033 99,365 6,668 6.29%
+~. Pension -General 436,713 109,178 104,267 4,911 4.50%
Total $28,173,542 $7,043,387 $6,311,637 $731,750
..
Annual
YTD - 25%
YTD
Dollar
Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
~„ Personal Services (5) $8,570,704 $2,142,676 $1,775,468 $367,208 17.14%
Operating Expenses (2) & (3) 9,721,021 2,430,256 1,764,238 666,018 27.41
Capital Outlay 6,863,063 1,715,766 1,165,587 550,179 32.07%
Debt Service (4) 1,675,695 418,924 1,270,579 (851,655) -203.30%
Transfers 1,343,059 335,765 335,765 0 0.00%
Total $28,173,542 $7,043,387 $6,311,637 $731,750
Analysis of Major Variances
(1) The positive variance in the General Government departments resulted from not having
begun the Buchman Trust Property project -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 are
vacant positions in the Police Patrol division, capital items have not been purchased and
the Lifeguard expenses are seasonal (typically June through September).
(3) The positive variance in the Public Works departments resulted from only 2 payments
having been made on the solid waste contract and not purchasing the budgeted trash
truck as of December 31, 2006.
(4) The negative variance in the Public Utilities department resulted from the annual
payment of principal and semi-annual payment of interest on the Utility Revenue Bonds.
(5) The positive variance in the Personal Services is related to 50% of the first payroll of
October, 2006 being expensed in the prior fiscal year.
~" City of Atlantic Beach
FINANCIAL REPORT
DECEMBER 2006
~.
Project Activity -Current Year Activity Only
AGENDA ITEM # 4A
JANUARY 22, 2007
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 33,000 0 33,000
PR0703 20,000 0 20,000
PR0704 17,500 0 17,500
Subtotal 80,500 0 80.500
PS0504 466,850 0 466,850
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
PU0601 12,049 0 12,049
PU0604 29,007 0 29,007
PU0605 145,223 0 145,223
PU0606 3,984 0 3,984
PU0607 8,900 8,876 24
PU0608 151,179 63,035 88,144
PU0701 20,000 0 20,000
PU0702 12,000 0 12,000
PU0703 100,000 0 100,000
PU0704 365,400 0 365,400
PU0705 30,000 0 30,000
PU0706 338,500 0 338,500
1,216,242 71,911 1,144,331
PW0309 2,530,730 892,821 1,637,909
PW0401 400,000 0 400,000
PW0502 8,164 8,164 0
PW0606 81,500 1,418 80,082
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,825,496 902,403 2,923,093
$6,039,088 $974,314 $5,064,774
Status Key
B -Bid Awarded E -Design Phase
~* C -Project Completed I -Project In-progress
D -Design Completed R - Re-budge# Next Fiscal Year
E
E
E
E
C
I
I
w.
~.
~•
~.
~.
a~
AGENDA ITEM # 4A
JANUARY 22, 2007
City of Atlantic Beach, FI.
Water and Sewer Utility Sales Report
Water Sales
r
,r
~~ Atlantic Beach
t:~
IrI= Buccaneer
I' Total Water Sales
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
December 2006 December 2005
Gallons Actual Revenue Gallons Actual Revenue
punts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue aer x,000 gi
5,568 44,855 $113,747 $2.54 5,601 45,444 $110,937 $2.44
2,456 24,805 $69,909 $2.82 2,676 25,982 $67,511 $2.60 `
Gallons Gallons
0000 0000
43,834 55,036
34,833 19,285
78,667 74,321
69,660 71,426
9,007 2,885
11.45% 3.90%
11.45% 9.93°h
Gallons Actual Revenue
~ Gallons Actual Revenue
Accounts 0000 Revenue Par 1,000 g~ Accounts 0000 Revenue Per 1,000 gl .
5,033 34,206 $160,380 $4.69`' 5,012 34,877 $159,194 $4.56
2,339 23,135 $134,402 $5.81 2,544 24,522 $134,430 $5.48'
7,372 57,341 5294,782 65.14 7,556 59,399 5293.624 $4.94
Gallons Actual Revenue
0000 Revenue Per 1,000 gl
47.959 $160,380 $3.34
21.076 $134,402 $6.38
Gallons Actual Revenue '
0000 Revenue Per 1,000 gi
52.891 $159,194 $3.01;
16.436 $134.430 $8.18
i