Item 4AAGENDA ITEM #4A
APRIL 24, 2006
City of Atlantic Beach, FI.
Utility Sales Report
~~
Fi.z99,r~t~~YY '"T=c.15iki:7~Cb71'1..uisi:~4:c -
,.~+L=l1:i'~~.3~!..:ir.+w..t.ir'r.~,~ux~C"E!+:SL:i~.Jl~i~~YvL~3~rL4:y_
to l~_~ilv..-iu. ~`d'n.~.Sr:..+.&~~.1~rN.:.li~"'.~f~iei~,~~~:::ll .~_...~
March 2006 March 2005
;~,
t
Gallons Actual Revenue Gallons Actual Revenue
Water Sales Accounts (000) Revenue Per ~,ooo gi Accounts (000) Revenue Per 1,000 gi
-Q=~
Atlantic Beach 5,583 36,605 $89,609 $2.45 5,503 41,943 $99,256 $2.37
', Buccaneer 2,670 22,599 $61,362 $2..72 2,708 26,516 $69,222 $2.61
Total Water Sales 8,253 59,204 $150,971 $2.55 8,211 68,459 $168,478 $2.46
Water Pfant Produc tion
Gallons Gallons
(000) (000)
Atlantic Beach 57,647 56,818
Buccaneer 21,871 22,310
Total Production 79,518 79,128
Total Water Billed 59,204 68,459
Water Loss for month: 20,31.4 10,665
Percentage Loss 25.55% 13.48%
Total 12 mo. Avg. Loss 10.18% 10.77°!°
Gallons Actual Revenue Gallons Actual Revenue
Sewer Sales Accounts (000) Revenue Per 1,000 gl Accounts (000) Revenue Per 4,000 gt
Atlantic Beach 5,071 30,749 $143,715 4.67 4,945 33,622 $144,997 4.31
Buccaneer 2,551 21,735 $120,848 5.56 2,594 24,925 $131,375 5.27
Total Sewer Sales 7,622 52,484 $264,582 $5.04 7,539 58,547 $278,372 $4.72
64.62
88.13
AGENDA ITEbI #4A
City of Atlantic Beach APRIL 24, 2006
FINANCIAL REPORT
March, 2006
Cash Balances
Prior Current Dollar
Fund(s) 02/28/06 03/31/06 Change
~.
General $6,355,404 $6,108,922 ($246,482)
Tree Replacement 30,978 30,978 0
~"" Convention Development Tax 164,290 170,151 5,861
Local Option Gas Tax 420,219 438,077 17,858
Better Jax 1/2 Cent Sales Tax 930,967 925,396 (5,571)
Police Training, Forfeit, etc. 567 1,619 1,052
Grants (28,616) (36,202) (7,586)
Debt Service 44,864 50,875 6,011
~„ Utility 3,593,185 3,720,054 126,869
Sanitation 546,670 543,846 (2,824)
Storm Water 2,950,422 2,827,017 (123,405)
Pension -Police 15,525 4,813 (10,712)
Pension -General 27,721 41,838 14,117
Total $15,052,196 $14,827,384 ($224,812)
Total Restricted Cash $6,546,268
Total Unrestricted Cash $8,281,116
Cash and Investments
Prior Current Dollar Rate of
Account 2/28/06 3/31/06 Change Return
Bank of America -Depository $251,995 $159,337 ($92,658) 3.66
SBA 14,797,651 14,665,497 (132,154) 4.65
Cash on Hand 2,550 2,550 0 -
Subtotal 15,052,196 14,827,384 (224,812)
Suntrust-Pension-Police 4,318,580 339 (4,318,241) 2.00 (1)
Merrill Lynch-Pension-Police 580,897 4,940,771 4,359,874 7.10 (1)
Suntrust-Pension-General 5,981,839 449 (5,981,390) 1.90 (1)
Merrill Lynch-Pension-General 1,232,593 7,279,599 6,047,006 7.10 (1)
Subtotal 12,113,909 12,221,158 107,249
Total $27,166,105 $27,048,542 ($117,563)
(1) FYTD rate of return through 12/31/05
0
City of Atlantic Beach
FINANCIAL REPORT
March, 2006
AGENDA ITEM #4A
APRIL 24, 2006
Revenues
Annual YTD - 50% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $9,951,978 $4,975,989 $6,586,811 $1,610,822 32.37%
Tree Replacement 0 0 0 0 100.00%
Convention Development Tax 128,000 64,000 38,839 (25,161) -39.31
Local Option Gas Tax 564,042 282,021 277,724 (4,297) -1.52%
Better Jax 1/2 Ct Sales Tax 702,336 351,168 381,643 30,475 8.68%
Police Training, Forfeit, etc. 31,800 15,900 13,453 (2,447) -15.39%
Grants (2) 447,833 223,917 69,776 (154,141) -68.84%
Debt Service 71,100 35,550 36,114 564 1.59%
Utility (3) 6,623,534 3,311,768 3,139,426 (172,342) -5.20%
Sanitation 1,362,300 681,150 655,821 (25,329) -3.72%
Storm Water (4) 1,067,868 533,934 374,476 (159,458) -29.86%
Pension -Police 702,355 351,178 399,000 47,822 13.62%
Pension -General (5) 1,015,029. 507,515 699,604 192,089 37.85%
Total $22,668,175 $11,334,090 $12,672,687 $1,338,597
Analysis of Major Variances
(1) The $1,610,822 positive variance in the General Fund resulted from having received
91.8% of the year's budgeted property taxes by March, 2006. Typically the majority of
these taxes are received from the City of Jacksonville in December & January.
(2) The $154,141 negative variance in the Grant Funds resulted from either items not
having been purchased or reimbursement requests not having been filed as of March 31,
2006.
(3) The $172,342 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 $159,458 negative variance in the Stormwater Fund resulted from the award of a
grant in fiscal year 2006 that has not been received.
(4) The $192,089 positive variance in the General Employee Pension Fund resulted from
changes in the market values of the investments.
~,.
City of Atlantic Beach
FINANCIAL REPORT
March, 2006
AGENDA ITEM #4A
APRIL 24, 2006
Expenses
~,
Annual YTD - 50% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $45,938 $22,969 $23,918 ($949) -4.13%
City Administration 2,119,933 1,059,967 1,011,421 48,546 4.58%
General Government (1) 2,240,185 1,120,093 760,618 359,475 32.09%
Planning and Building (2) 650,837 325,419 222,459 102,960 31.64%
Public Safety (3) 4,710,299 2,355,149 1,796,474 558,675 23.72%
Parks and Recreation 1,022,247 511,123 469,313 41,810 8.18%
~. Public Works (4) 6,214,842 3,107,420 2,247,127 860,293 27.69%
Public Utilities 7,062,599 3,531,300 3,362,790 168,510 4.77%
Pension -Police 400,936 200,468 203,201 (2,733) -1.36%
Pension -General 405,798 202,899 205,675 (2,776) -1.37%
aw Total $24,873,614 $12,436,807 $10,302,996 $2,133,811
Annual YTD - 50% YTD Dollar Percent
~.
Resource Allocation
Estimate
of Estimate
Actual
Variance
Variance
Personal Services $7,899,947 $3,949,974 $3,646,059 $303,915 7.69%
Operating Expenses (2) - (4) 9,495,220 4,747,609 3,738,992 1,008,617 21.24%
~. Capital Outlay (1) & (4) 5,011,134 2,505,567 1,267,010 1,238,557 49.43%
Debt Service (5) 1,678,236 839,118 1,256,397 (417,279) -49.73%
Transfers 789,077 394,539 394,538 1 0.00%
~"' Total $24,873,614 $12,436,807 $10,302,996 $2,133,811
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 & Building departments resulted from no monies
being expended in the Community Development Block Grant or the Tree Replacement
Fund as of March 31, 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 payment of
principal and interest on the Utility Revenue Bonds in the months of October & April.
~.
City of Atlantic Beach
FINANCIAL REPORT
March, 2006
Project Activity -Current Year Activity Only
AGENDA ITEM #4A
APRIL 24, 2006
Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
Parks and Recreation:
Beautification
Public Safety
Police Building Renovations
Homeland Security Items
PR0601 45,000 0 45,000
Subtotal 45,000 0 45,000
PS0504 475,000 2,570 472,430 D
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
Pathway -Seminole Road Phase 2
Traffic Isle -Mandalay Park
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 54,686 54,686 0
PW0309 1,300,000 0 1,300,000
PW0401 346,858 55,858 291,000
PW0405 78,000 52 77,948
PW0409 141,816 141,797 19
PW0502 346,599 310,154 36,445
PW0503 26,175 26,175 0
PW0504 37,500 19,951 17,549
PW0505 5,864 5,864 0
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 47,652 44,700 2,952
PWOE11 17,000 0 17,000
2,943,822 775,166 2,168,656
PU0305 2,485 2,485 0
PU0310 52,027 52,027 0
PU0503 83,446 83,446 0
PU0504 50,000 0 50,000
PU0601 70,000 0 70,000
PU0602 65,703 484 65,219
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
528,311 138,442 389,869
$4,130,133 $916,178 $3,213,955
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
E
E
I
I
I
C
I
C
C
C
C
C
C
C