Item 4APREPAREII 5/12/10-,10:11:56
City of Atlantic Beach.
PROGRSM OL122L
-----------------------------------
LIC # BUSINESS NAME
BUSINESS ADDRESS
10-00007227 A-1 WiG GALLERY LLC~
1193 MAYPORT RD
ATLANTIC BEACH FL 32233
10-0000")258 ALPHA & OMEGA LAWNCARE
63 LEWIS ST
ATLANTIC BEACH FL 32233
GRAND TOTALS
-------------- SEW LICENSES
AC: 2
PP: 0
TN: 0
vo: a
PG: 0
BR: 0
OB: 0
UC: 0
LIC: 2
LICENSE ACTIVITY REPORT BY BUSINESS NAME AGENDA ITEM # 4A
NEW LICENSES FOA YEAR: 201Q Bli~WBEI~I: 04/01/10 TO 0$/30/10 MAY 24, 2010
DEPT: ALL DEPARTMENTS CLASS: AId; CLASSES
ISSUED TYPE CLASSIFICATION
BUS PHONE #
4128/10 NEW BEAUTY SUPPLY
4/28/10 NEW' LAAN/YARD SERVICE
904-241-0886
904-442-3948
AGENDA ITEM # 4A
MAY 24, 2010
City of Atlantic Beach, FI.
Utility Sales Report
Apri 12010
Water Sales
Atlantic Beach
Buccaneer
Total Water Sales
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gl
5,606 35,392 $131,633 $3.72
2,458 18,407 $82,600 $4.49
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
0000
53,181
18,277
71,458
53,799
17,659
24.71
14.50%
April 2009
Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 yi
5,542 37,500 $122,496 $3.27
2,395 19,501 $73,079 $3.75
Gallons
0000
48,617
23, 589
72,206
57,001
15,205
21.06%
13.03%
Gallons Actual Revenue Gallons Actual Revenue
Accounts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per ~,ooo y~
5,142 30,277 $210,358 $6.95 5,069 30,851 $189,182 $6.13
2,331 16,927 $151,999 $8.98 2,273 18,501 $144,088 $7.79
7.473 47.204 $362.357 $7.68 7.342 49.352 $333.270 X6.75
Gallons Actual Revenue Gallons Actual Revenue
0000 Revenue Per 1,000 gi 0000 Revenue Per 1,000 yi
44.529 $210,358 $4.72 49.370 $189,182 $3.83
16.650 $151,999 $9.13 20.557 $144,088 $7.01
81.179 $362,357 $5.92 69.927 5333.270 54.77
Clt of Atlantic Beach AGENDA ITEM#4A
y MAY 24, 2010
FINANCIAL REPORT
APRIL 2010
Cash Balances
Fund(s)
Total
General
Tree Replacement
Convention Development Tax
Local Option Gas Tax
Better Jax 1/2 Cent Sales Tax
Police Training, Forfeiture & Grants
Community Development Block Grant
Debt Service
Capital Projects
Utility
Sanitation
Building Code Enforcement
Storm Water
Pension -Police
Pension -General
Total Restricted Cash
Total Unrestricted Cash
Subtotal
$7,459,788
$7,712,531
Cash and Investments
Account
Bank of America -Depository
US Treasury Notes
US Treasury Notes
Federal Farm Credit Bank Consolidated Bonds
SBA -Florida Prime
Cash on Hand
Police Pension Investments
General Pension Investments
Subtotal
Prior Current Dollar
03/31/10 04/30/10 Change
$5,208,546
8,890
41,439
187,535
524,029
176,832
(100)
42,786
1,131,819
3,656,785
571,493
43,341
3,559,278
33,817
31,013
$15, 217, 503
$5,478,055
8,890
48,098
181,413
488,119
65,373
(100)
48,606
1,218,041
3,516,415
577,861
48,707
3,410,641
26,438
55,762
$15,172,319
$269,509
0
6,659
(6,122)
(35,910)
(111,459)
0
5,820
86,222
(140, 370)
6, 368
5, 366
(148,637)
(7,379)
24, 749
($45,184)
Prior Current Dollar Rate of
03/31/10 04/30/10 Change Return
$15,214,384 $10,929,698 ($4,284,686) 0.300
0 1,122,276 1,122,276 4.625
0 2,009,081 2,009,081 3.625
0 1,108,143 1,108,143 4.875
219 221 2 0.230
2,900 2,900 0 N/A
15, 217, 503 15,172, 319 (45,184)
5,861,405 5,953,628 92,223 4.000 (1)
9,908,784 10,066,806 158,022 3.830 (1)
15,770,189 16,020,434 250,245
Total $30,987,692 $31,192,753 $205,061
(1) YTD rate of return through 12/31/09
City of Atlantic Beach
FINANCIAL REPORT
APRIL 2010
Revenues
AGENDA ITEM ~ 4A
MAY 24, 2010
Annual I YTD - 58% YTD Dollar Percent
Fund / (Footnote) Estimate of Estimate Actual Variance Variance
General (1) $11,433,948 $6,665,992 $8,126,955 $1,460,963 21.92%
Tree Replacement 0 0 3,989 3,989 100.00%
Convention Development Tax 80,500 46,932 38,253 (8,679) -18.49%
Local Option Gas Tax 455,764 265,710 253,379 (12,331) -4.64%
Better Jax 1/2 Ct Sales Tax 612,334 356,991 350,768 (6,223) -1.74%
Police Training, Forfeiture & Grants (2) 414,513 241,661 117,811 (123,850) -51.25%
Community Development Block Grant 165,473 96,471 4,912 (91,559) -94.91
Debt Service 69,000 40,227 40,065 (162) -0.40%
Capital Projects 1,002,000 584,166 586,043 1,877 0.32%
Utility (3) 13,766,898 8,026,101 4,933,134 (3,092,967) -38.54%
Sanitation 1,822,000 1,062,226 1,145,402 83,176 7.83%
Building Code Enforcement 308,050 179,593 160,198 (19,395) -10.80%
Storm Water 933,000 543,939 576,851 32,912 6.05%
Pension -Police (4) 910,823 531,010 703,797 172,787 32.54%
Pension -General (4) 1,449,292 844,937 1,203,418 358,481 42.43%
Total $33,423,595 $19,485,956 $18,244,975 ($1,240,981
Analysis of Major Variances
(1) The $1,460,963 positive variance in the General Fund resulted from having received
94% of the budgeted amount of property taxes to date. Typically the majority of the
property taxes are received from the City of Jacksonville in December & January.
(2) The $123,850 negative variance in the Police Training, Forfeiture & Grant Funds
resulted from not having received the reimbursement requests submitted in April, 2010.
(3) The $3,092,967 negative variance in the Utility Funds resulted from not having issued
the 2009 Revenue Notes and not having received the funds from the SRF loan or the
Local Mitigation Strategy Grant. If amounts to be financed and the grant were not
included in this calculation, the variance would be a positive 10.5%.
(4) The $172,787 positive variance in the Police Employee Pension Fund & the $358.481
positive variance in the General Employee Pension Fund resulted from changes in
market values of the investments.
City of Atlantic Beach
FINANCIAL REPORT
APRIL 2010
AGENDA ITEM # 4A
MAY 24, 2010
Expenses
Annual YTD - 58% YTD Dollar Percent
Department / (Footnote) Estimate of Estimate Actual Variance Variance
Governing Body $43,303 $25,246 $28,210 ($2,964) -11.74%
City Administration 2,410,321 1,405,217 1,314,290 90,927 6.47%
General Government 642,296 374,458 345,912 28,546 7.62%
Planning and Building 508,068 296,204 298,436 (2,232) -0.75%
Public Safety (1) 6,464,653 3,768,892 3,136,356 632,536 16.78%
Recreation and Special Events 387,063 225,658 223,227 2,431 1.08%
Public Works (2) 8,937,475 5,210,548 3,756,984 1,453,564 27.90%
Public Utilities (3) 14,026,104 8,177,217 5,323,959 2,853,258 34.89%
Pension -Police 519,506 302,872 334,382 (31,510) -10.40%
Pension -General 513,359 299,288 323 408. (24 120) -8.06%
Total $34,452,148 $20,085,600 $15,085,164 $5,000,436
Annual YTD - 58% YTD Dollar Percent
Resource Allocation Estimate of Estimate Actual Variance Variance
Personal Services (1) $9,285,613 $5,413,512 $5,158,646 $254,866 4.71%
Operating Expenses (1) - (2) 9,778,215 5,700,699 4,965,584 735,115 12.90%
Capital Outlay (1) - (3) 10,554,917 6,153,515 1,605,079 4,548,436 73.92%
Debt Service (4) 1,755,495 1,023,454 1,667,597 (644,143) -62.94%
Transfers 3,077,908 1,794,420 1,688,258 106,162 5.92%
Total $34,452,148 $20,085,600 $15,085,164 $5,000,436
Analysis of Major Variances
(1) The positive variance in the Public Safety department resulted from: vacant positions and
purchases of capital items below budget in the Police Patrol division, seasonality of the
Lifeguards and the Police Building project has had limited activity -see Project Activity
Schedule. Also, the payment is due quarterly to the City of Jacksonville for fire & rescue
services. The next payment is due in June 2010 for April through June 2010.
(2) The positive variance in the Public Works department resulted from limited activity on the
Royal Palms Stormwater and Park Improvement projects -see Project Activity Schedule.
The paving budgeted in the Local Option Gas Tax Fund will not be expended until the
Royal Palms Stormwater project is completed.
(3) The positive variance in the Public Utilities department resulted from limited activity on
the projects budgeted in the Sewer Fund -see Project Activity Schedule.
(4) The negative variance in the Debt Service accounts is due to the payment on interest and
principal on 10/01/09 and 12/01/09 and the payment of interest only on 04/01/10.
City of Atlantic Beach
FINANCIAL REPORT
APRIL 2010
Project Activity -Current Year Activity Only
AGENDA ITEM # 4A
MAY 24, 2010
Project YTD YTD YTD
Project Name Number Budget Actual Balance Status
Public Safety
Lifeguard Building Roof Replacement LG0901 0 0 0
Police Building Renovation/Design/Construction PS0504 435,788 18,068 417,720
435,788 18,068 417,720
Public Utilities:
Replace Well at Water Plant #1 PU0304 794,675 24,166 770,509
Reclaimed Water Plant Construction PU0805 0 0 0
TMDL - WWTP #1 Design PU0905 566,125 240,803 325,322
TMDL -Lift Station/Main Transfer Flow PU0906 3,847,296 134,654 3,712,642
Generator -Mimosa Cove Lift Station PU0907 31,518 31,518 0
Elevated Tank -Water Plant #1 PU1001 10,000 0 10,000
Ground Storage Tank Rehab -Water Plant #1 PU1002 30,000 0 30,000
Water Main -Ocean Boulevard/10th to 14th Street PU1003 150,331 112,773 37,558
Collection Syatem Inspection & Rehab PU1004 382,000 0 382,000
Mimosa Cove Lift Station Upgrades PU1005 160,000 0 160,000
Lift Station E Upgrades PU1006 200,000 0 200,000
Gavagan Lift Station PU1007 8,338 2,838 5,500
Camelia & West 3rd Street Lift Station PU1008 12,000 12,000 0
Schooner's Bay Lift Station PU1009 12,972 11,909 1,063
Stewart Street Lift Station PU1010 17,190 1,190 16,000
Selva Norte Lift Station PU1011 5,318 1,318 4,000
Hydroscreen Replacement PU1012 6,000 0 6,000
Concrete to GRIT Container PU1013 8,500 0 8,500
Tank Rehab -Water Plant 4 PU1014 15,000 0 15,000
Subtotal 6,257,263 573,169 5,684,094
Public Works:
Riverbranch Preserve PM0804 74,804 54 74,750
Tennis Courts at Donner Community Center PM0905 13,354 4,912 8,442
Howell Park Bridge #5 PM0908 8,500 8,500 0
Howell Park Bridge Replacement PM1001 20,000 9,500 10,500
Jordan Park -Drainage & Parking PM1002 30,000 0 30,000
Jordan Park -Water Fountain PM1003 5,000 0 5,000
Jordan Park -Covered Shelter PM1004 25,000 0 25,000
Roof at Donner Park Community Center PM1005 50,000 0 50,000
Veteran's Park -Flag & Pavilion PM1006 10,196 10,196 0
Donner Park -Accessory Building PM 1007 57,241 5,960 51,281
Dog Park -Hopkins Creek PM1008 20,800 0 20,800
Royal Palms Design PW0808 37,026 22,898 14,128
Royal Palms Stormwater Project PW0905 3,162,257 793,341 2,368,916
Sidewalk -Dutton Island Road & Donner Park PW1001 43,732 0 43,732
Sidewalk/Curb Replacement - FY 2010 PW1002 25,000 578 24,422
Manhole - Saturiba & Seminole Road PW1003 15,000 0 15,000
Subtotal 3,597,910 855,939 2,741,971
Total $10,290,961 $1,447,176 $8,843,785
Status Key
A -Bid Advertised I -Project In-progress
B -Bid Awarded N -Complete/Non-Capital
C -Project Completed R - Re-budget Next Fiscal Year
D -Design Completed X -Project Cancelled
E -Design Phase
X
E
E
X
E
E
C
A
C
C
I
R
C
I
! AG EN DA ITE M # 4A
MA Y 2 4, 2 010
I
t--
~-
_
--
- -
--
- -
_
-_
_
-
-
_
--
_ -
-
N
___
I
- -
_
, -- i
i ! i =
~
I
!
N N ~ ~
~ O t00 ~ ~ S a ~ ~ ~ S O j
j
~ r
~
M
i !
!
i V
Ow.
--
--__
-
~-- --
-_
~
-
--
-
_
_.
J
__
.
_._
___
-~
__
-~
}
~
--
Q
(~
W
~-_
~ _~__..
{
Z ~ ~ I ~
?
Q O
00
O
a
V
O ~
Z ~
J ~
~ Y
a I
i
- F-N ~ O(7 V C9
Z ~ O $ a ~
O r- W _Z
WU IY
V - Z
Z
'~ Z
M O
U ~ !
J
r ~
U
~
~
I
r !
I Z ~~
~ I~ i ~ ~ m w a ~ ~
~ _ _ ~ a z z o
0
I ~ 0 0 0 0 0 o W o 0 0 °o o °o °o
(
~ c ~ °o~
w
~y. i 0
O
~ 0 0
O
0 0
~~}}
1A 0
O
M 0
CD
eh O
N
N J O
a 0 O OOD O N
~ O
~ ti ~
p ti
W
~~
I
O
0
/~
'Of
~'
0
~!
~
'
C~
tG
N
CO
Cf
e'~
~
<O
O
~ ..J
N~/
~i.
~
_.
,'~
~ O
M N
O O
~
~
.
N er
O
. i
i
I
~,
j 1
O ~
i-
~',
OI N ~ ~ ~ ~ ~ a ~
Imo;
> Ji I
I ~ LL,
~ ~
~
!
'
i- ~ a' o f ~ = z
I ! i ~ ~
Q ° ; I . ~ ~~ '
Q ° _- - ~ ~
~. w
~= ~
o 0
0
~ 0
o 0
0
~
g ~
g I ~ -_ _
j --~ -
~ - -F-
~ ,
' F,,. ~ O C
eo N
ci G
m t0
m 00 W
<
0 ~
'A 5i
V/ G Z
O
-
~
N M
o~
a-
~
m
1+
oo
1~' ao
eo
O
M i F-
:
J
~
I
~
!
_
,
I
O
~= ~
a/ O
~
O O
O 0
~ 0
O 0
O 0
O 0
OD 0
tf~ 0
0 0
0
S O
1A O
O O
O 0
0 0
0 0
0
0
--
-- -
0
~ /Q ~' Q ~ NS ti
et M
a ~
N 0r°
M M
af aNO ~i a~ C N N ~ oao a°o ° O O
~
~
• Y.
~ ~ Q.
~ ~ ~ ~ i ~ ~ ~ N
O N
P ~ N C~
N O
M N
N CO
a- N !
I N!
' N N N
a j
~ ~ ~ --- T- ~-{ - j l
w ~ i
~ ~
~ ~
W
!
I
,~~ ,
W ill ~ _~ i
--
_ - -_ .____ ~ i ___ M
~ _
f M ~Mi AN
____ /A
__ /A
.- ~ iN M
_- ~
-_. H,
__ 1sj
_..
{ 1A
-- /A
-- Ml
+ v! VS -
1 --
Z~ '~! ~ O
m° ~ WI ~ l i ~ I ~
~
i ~'~ '
I I
I t
I I
I
Q ~ FN
- ON e~l ~ 1A pp
t0
I 0
1~ a ! I ' j
J
~ t'F ~! ~
-!
W
~ i
~
W~
~
~ f
i
i
~ a
-
O
I _
~
~
--~
~
r-
d
O
N
~
O
~
~
D
~
~
~
O
N
N
M
N
N
A
r
O
~
lO
r
0
~
~
>
~
~!
~
~
i
i
,~
!01-
~
I
I
I ~ ~ ~
m NN
O
~
~ 0
O>
I r, ~
00 O
Z i
I. t
~
I~
i O
H ~ O !
I
I
1
I ~
i Z
~
- -~
r
I
- ~
-
~
-
.J
'Q
--~-
I _
- (
--
I
i
-
!
--
-
_
_ i
_-_
__
_
~--
--t
-
_}
_
J
_
i
, f-
p
~
N
Z
O
i
~
z
i
~"
m Ri o ~ ~ I v ~ IO
' z
O
3
t-
J
-
~
3
F-
W
V m
N
W
J
W
W
! I
i,
!
W ~ ~
O W
z
i
I~~ ~
~I
°a W
z p
o J
a a
ta ~
x
~ I
La
3
z fa
z
m
! d. J
~ J
a I J'
-
>C '
J' J a J U
N
_
J~
J
qq'
i .
O~W
-
W I ~
a
!
=
W
W W
~
W
W
S Z
W ~
W (,)
~ ~
W tq
F-
~ Z Z Z C9
3 1
J W
l-
d
~
fA a
O ~,
~ ~ '~ J O ~ ~
W J O D ~ W ~ ~ V Q
2 a
= m
=. Z
{L O d
fn'g ~ a fn V ~ H I
~ t9
W z n,
~ g
W ~
O x
F- ~
z 3
W rn
W ~
O ~
O ~
O m
W w
J v
W v
W ~
J p
O D
z
- ~
W ?~
WW v
U z
W z
~ z
W ?
d' =i
~ ~
' a v~ o a c~ o v~ z ~ v v c.~ a w ~ g a ~ 3 o ~ai 0 a m u. o m j