Loading...
Item 4ACity of Atlantic Beach Arco tvtsER9,2oo9 FINANCIAL REPORT --- SEPTEMBER 2009 Cash Balances Fund(s) General Community Development Block Grant Tree Replacement Convention Development Tax Local Option Gas Tax Better Jax 1/2 Cent Sales Tax Police Training, Forfeit, etc. Debt Service Capital Projects Utility Sanitation Building Code Enforcement Storm Water Pension -Police Pension -General Prior Current 08/31 /09 09/30/09 $4,373,162 (2,988) 14,822 12,798 310, 370 720,958 194,404 68,894 627,180 3,242,714 510,223 66,338 4,084,357 105,830 110.848 Total $14,439,910 Total Restricted Cash Total Unrestricted Cash $2,918,635 (63,844) 14,822 20,091 222,345 720,569 186,166 74,605 649,961 4,307,091 525,894 57,654 4,190,853 33,748 8,122 $13,866,712 $7,247,139 $6,619,573 Dollar Change ($1,454,527) (60,856) 0 7,293 (88,025) (389) (8,238) 5,711 22,781 1,064,377 15,671 (8,684) 106,496 (72,082) (102,726) ($573,198) Cash and Investments Prior Account 08/31 /09 Current 09/30/09 Bank of America -Depository $6,422,266 5th 3rd Bank -Certificate of Deposit 2,012,734 5th 3rd Bank -Certificate of Deposit 6,000,748 SBA 1,262 Cash on Hand 2,900 Subtotal 14,439,910 Police Pension Investments 5,294,296 General Pension Investments 8,759,894 Subtotal 14,054,190 Total $28,494,100 $5,845,110 2,014,064 6,003,358 1,280 2,900 13,866,712 5,541,835 9,205,224 14, 747, 059 $28,613,771 Dollar Rate of Change Return ($577,156) 0.30 1,330 1.65 2,610 0.65 18 0.37 0 N/A (573,198) 247,539 445,330 692,869 7.95 (1) 8.27 (1) $119,671 (1) FYTD rate of return through 06/30/09 City of Atlantic Beach FINANCIAL REPORT SEPTEMBER 2009 Revenues AGENDA ITEM # 4A NOVEMBER 9, 2009 Annual I YTD - 100% Fund / (Footnote) Estimate of Estimate YTD Dollar Percent Actual Variance Variance General (1) $10,391,868 $10,391,868 Tree Replacement 0 0 Convention Development Tax 85,000 85,000 Local Option Gas Tax 496,872 496,872 Better Jax 1 /2 Cent Sales Tax 638,188 638,188 Police Training, Forfeit, etc. 40,150 40,150 Community Development Block Grant (2) 214,284 214,284 Debt Service 69,500 69,500 Capital Projects 335,000 335,000 Utility (3) 9,398,075 9,398,075 Sanitation 1,872,500 1,872,500 Building Code Enforcement 207,500 207,500 Storm Water (4) 2,374,600 2,374,600 Pension -Police 812,280 812,280 Pension -General 1,320,428 1,320,428 Total $28,256,245 $28,256,245 $10,563,757 $171,889 1.65% 4,914 4,914 100.00% 66,816 (18,184) -21.39% 462,049 (34,823) -7.01 639,295 1,107 0.17% 33,637 (6,513) -16.22% 122,140 (92,144) -43.00% 68,664 (836) -1.20% 331,236 (3,764) -1.12% 8,287,810 (1,110,265) -11.81% 1,933,837 61,337 3.28% 200,573 (6,927) -3.34% 2,967,003 592,403 24.95% 863,463 51,183 6.30% 1,532,556 212,128 16.07% $28,077,750 ($178,495) Analysis of Major Variances (1) The $171,889 positive variance in the General Fund resulted from having received 131 % of the budgeted amount of the Utility Service Taxes from JEA. (2) The $92,144 negative variance in the Community Development Block Grant resulted from expenditures 77% below the projected budget amounts & $63,844 of reimbursements from the current fiscal year were received in fiscal year 2010. This grant is executed on a reimbursement basis. (3) The $1,110,265 negative variance in the Utility Funds resulted from charges for services $303,806 below the projected budget amounts, system development charges $272,776 below the projected budget amounts and not having transferred the budgeted amount of $745,725 from the General Fund for the well replacement & TMDL projects which will be budgeted for completion in fiscal year 2010 & will be funded by external sources -see Project Activity Schedule. (4) The $592,403 positive variance in the Stormwater Fund resulted from having received the Florida Department of Environmental Protection grant monies in this fiscal year. These revenues were budgeted & recognized in the prior fiscal year. Also, the Utility fees were $18,985 over the projected budget amount. AGENDA ITEM # 4A City of Atlantic Beach NOVEMBER 9,209 FINANCIAL REPORT - SEPTEMBER 2009 Expenses Annual YTD -100% YTD Dollar Percent Department / (Footnote) Estimate of Estimate Actual Variance Variance Governing Body $48,076 $48,076 $41,553 $6,523 13.57% City Administration 2,645,981 2,645,981 2,486,999 158,982 6.01 General Government (1) 4,101,465 4,101,465 3,341,000 760,465 18.54% Planning and Building 565,974 565,974 522,080 43,894 7.76% Public Safety (2) 6,019,866 6,019,866 5,268,927 750,939 12.47% Recreation and Special Events 441,619 441,619 420,625 20,994 4.75% Public Works (3) 9,876,108 9,876,108 6,118,171 3,757,937 38.05% Public Utilities (1) 9,389,931 9,389,931 7,366,951 2,022,980 21.54% Pension -Police 451,236 451,236 494,007 (42,771) -9.48% Pension -General 485,152 485,152 486,889 (1,737) -0.36% Total $34,025,408 $34,025,408 $26,547,202 $7,478,206 Annual YTD -100% YTD Dollar Percent Resource Allocation Estimate of Estimate Actual Variance Variance Personal Services $9,306,543 $9,306,543 $9,265,189 $41,354 0.44% Operating Expenses (2) & (3) 10,351,315 10,351,315 9,518,416 832,899 8.05% Capital Outlay (1), (2) & (3) 8,153,543 8,153,543 2,303,465 5,850,078 71.75% Debt Service 1,681,207 1,681,207 1,680,416 791 0.05% Transfers (1) 4,532,800 4,532,800 3,779,716 753,084 16.61% Total $34,025,408 $34,025,408 $26,547,202 $7,478,206 Analysis of Major Variances (1) The positive variance in the General Government and Transfers resulted from not having transferred the budgeted amounts to date from the General Fund to the Public Utilities departments. The well replacement & TMDL projects are budgeted for completion in fiscal year 2010 & will be funded by external sources -see Project Activity Schedule. (2) The positive variance in the Public Safety departments resulted from limited activity on the Police Building project -see Project Activity Schedule. This project's design has been budgeted in fiscal year 2010. (3) The positive variance in the Public Works departments resulted from the Advanced Disposal Services Jax LLC contract being below the budgeted amount, only 49% of the budget for paving has been spent in the Local Option Gas Tax Fund, the projects for the renovation of the City Parks were not completed at year-end, the Better Jacksonville '/2 Cent Sales Tax projects have had limited activity and the Royal Palms Stormwater project has had limited activity -see Project Activity Schedule. City of Atlantic Beach FINANCIAL REPORT SEPTEMBER 2009 AGENDA ITEM # 4A NOVEMBER 9, 2009 Project Activity -Current Year Activity Only Project YTD YTD YTD Project Name Number Budget Actual Balance Status Public Safety Lifeguard Building Roof Replacement Police Building Renovation/Design/Construction Public Utilities: Replace Well #2 at Water Plant #1 TMDL Engineering SCADA Improvements Collection System Inspection & Rehabilitation Reclaimed Water Plant Construction Collection System Rehabilitation Check Valve -Water Plant #1 Concrete to GRIT Container New Well Design TDML TMDL -Lift Station Transfer Flow Generator -Mimosa Cove Lift Station Subtotal Public Works: Buckman Trust Property Statue -Turtle Cabinets for Donner Gate at Dutton Island Park Playground Tennis Courts/Improvements/DonnerPark Howell Park Bridge #1 Dune Crossover - 3rd Street Extension Howell Park Bridge #5 Hopkins Creek Retention Mayport Road Medians Pedestrian Path Extensions Sidewalks -George & Edgar Streets Ardella Road Drainage Project Royal Palms Design Sidewalk/Pedestrian Path Sidewalk & Curb Royal Palms Stormwater Project Subtotal Total Status Key B -Bid Awarded C -Project Completed D -Design Completed E -Design Phase LG0901 7,080 0 7,080 PS0504 660,000 14,213 645,787 E 667,080 14,213 652,867 PU0304 800,000 5,325 794,675 E PU0706 44,575 44,575 (0) C PU0801 14,000 14,000 0 C PU0802 183,939 183,938 1 C PU0805 150,276 0 150,276 E PU0901 349,597 349,593 4 C PU0902 20,326 20,325 1 C PU0903 18,708 18,428 280 C PU0904 0 0 0 X PU0905 706,585 150,327 556,258 E PU0906 398,333 78,797 319,536 E PU0907 40,000 394 39,606 I 2,726,339 865,702 1,860,637 PM0804 191,000 190,410 590 C PM0805 73,307 61,444 11,863 C PM0901 0 0 0 N PM0902 0 0 0 X PM0903 45,000 42,109 2,891 C PM0905 147,000 122,060 24,940 I PM0906 15,000 14,850 150 C PM0907 7,075 7,075 0 C PM0908 10,000 0 10,000 I PW0309 1,110 1,110 0 C PW0401 156,428 73,477 82,951 N PW0802 0 0 0 X PW0803 51,732 39,508 12,224 C PW0807 33,753 33,904 (151) C PW0808 393,000 296,975 96,025 I PW0901 0 0 0 X PW0904 45,000 41,708 3,292 N PW0905 3,220,000 37,157 3,182,843 I 4,389,405 961,787 3,427,618 $7,782,824 $1,841,702 $5,941,122 I -Project In-progress N -Complete/Non-Capital R - Re-budget Next Fiscal Year X -Project Cancelled AGENDA ITEM # 4A NOVEMBER 9, 2009 ~ ,~ ~ 1 , 0 vi U p ~ 4: ,.~ .-i ~ ~ ~ ~ O p O ~ ~ G. Q ~ ~' O -~ .~ b N .~ ~ N ~ 6~ ~ °~ 'C ~ ~ ~ a -, :~ •~ ~ ^° ° ~ a ~ : U ,> W ~ Q ~ ,~ Ri 'Ty ~ •a i7 • b U ~ ' v N ~ ~ ~ ~ ~ ~ ~ ~ ~-+ ~ O ~ C b ~, N ~ ~ ~ ~ C N ~ ~ ~ ~ G„ p„ -~ d ~ ~ a i U ~ ~ ~ ~ ~ CL, Q ~ '~ ~ a W ~ ~ ~ O ~ ' ~ z ~ ~~~ oA ~~-w w ~ , •U 6~ ~ O ~ Q O , V ~ ~p~ O ~ o ~ V ~ ~ ~ .~ ~ ~ ~ ~ C +~ Ri a c ~ o "O ~ C ~ -o ~ ~ i N ~ ~ A -~ ~ ~ ~°, o ~ +r b >°, F ~ ~ ~ •-~ ~ o o '~ ~ ~ ~ 3 ~ v ~ ~' a ~ , ; ~ ~ ~ > ~ iq W . ~ ~ rw U 3 ~' AW z ~ on a,~ Z a~ UW ~UU ~ C7 U O a ~ u .~ ~ ~ H ~ ,~ ~ o ff z ~ O ~ o ~ ~ ~ v ~ c ° w ~ ~ °~ ° ~ ~ o b • ~ a 3a ~ o ~ ° ~ ~ .~ . ~ ~ o pq ~ ~ a . o ~ ~ ~ u a ~ ~~ ~ a W ~ o ~ ~ °, ~ A a F ~ o ~ ~ ~ c i w ~ ~ way ~ as ~ a cZ r~ ~ z p ti u ii ~ u u u ~3 u n ~?3 ii a °~ E'" ~ AUU Q QUU Q U U ~1 U U a F o ~ ~ a o a« u ,~ \ o ~ °o a w o ~ u ~ o ~, ~ \ w ~~ ~ ~ :, W _ E.., a .~ O~ ~ N ,~ +... N O O ~ O ~ O ~ A ~~ ~~ ~ ~ ~ 3 ~ .~ ~~ ~~ ~ ~ ~~ 3 ~~ ~ ¢~ O O O Z w Q F, ~ y w ~ ~ ~ a `~ Q ~ ~ 3 .~ ~, ~ ~0 '" ~ .~ ~ ~ U ~' ~ u ~ -~ ~ r~ ,,,, u v s GZ.7 U .p q ~ ~. .~ ~ ~ Q ~ ~. "'~„ .~ N . O ~ c~ U ~ ~ b O ~ +Y v~ O ~ .~ ~ ~ ~ d ~ ~ ~ ~ ~ . ~ O, ~ ~ ~ a •~ r w A ~ ~~~.~ H ~i2~, 3 ~ ~ ~~q~ o° a v° II .•. A •-+ N M ~ ~ AGENDA ITEM # 4A NOVEMBER 9, 2009 ~ I I I I I I I I I w 1 u a I I I I i I I I I I I I I O O ` O N n N ` N O W ~ ~ ~ yr 1 lf1 O h lfl l~ M lfl L~ dl M M h ri H I I !` lD L` !` lD M M M 00 O1 O~ N M M I W I O In N d' M d' M L~ r-I ~O l0 Ln Ol Ol I z 1 I I I I I I I 1 I I I I I I I O I W tP t` H l0 t` VI O d' M M dl r-I H I x I co vl rn ~ ~ ~ in rn m vi ui o c al I pi I I I N I N I N I N I N I N I lfl I OD I N I N 1 N I VI N N O~ I U1 I H d' d' d' d' dl C [O M d' dl I N I d' I d' O I ] I O O In O O (~ O W O CO N O O H Q O !n O \ I p] I N 01 N ~ ~ w Ol w 01 CO ~ Ol 01 Lf) W ~ H Ol rl I I H a H a M I I [i~ \ (LI \ I H U1 H F O I I m W W O ,~ I I w o w z m I I h wows I a Fm~ ~ ~ U a U a z zeal I w o z w w o a I 1 W O CA ~ Cn \ V I I H H H '~,' to H I I 3 U H S m woa I I ~+ a m ~ a H z\al I a w H w a n°~ ~ ~ w H ~ ° c n a F a ] •• I I ~ ~ ~ ~ o r a N o F o ~ w ~ ~ ~ \ o ~ \ ~ w a~ ~ z u z o w w a t o I ~ ~ ~ w a z H ~ ~ ~ z w g U I H I O O O a W rj x O G4' O U F F I H I U U U O F fx U U H U H R; W 1~ I F z F F ~ W F ~ o m v I w w w m w ~ z w w a a w I H I v u u U o U ~ al u ~ w W o F I W I + z I H I rx >I F U C7 W W F a cn ~ o w ~ m I a w w ] x ~ ~ a ~ p' >I N ~ (f1 i ~ ] ~ U Q CA Q Q O , ~ (n U F F I FC to (!] U] O fk z z z r-0 F F CJl z U1 H •• a l a I z z z a ~ O H W z F F z O H a I U H H H H ~ ~ U '~ ~ H ~i !.C H U a F W W U >I q I w ~ 3 3 3 3 3 3 3 3 3 S 3 3 3 3 .~ l a w w w w w w w w w w w w w w as I~ 1 z z z z z z z z z z z z z z woalF mw~C i I z. 01 ~ O1 O1 01 Ol O~ Ol O~ O~ 01 O~ O~ 01 W cn I q o 0 0 0 0 0 0 0 0 0 0 0 0 0 U W F I w I \ \ \ \ \ \ \ \ \ \ \ \ \ \ H Cn p. I] I N H H 01 l0 r-i Ol .--I N N N H O~ 01 a'2. W I Cn I O O N O N O O O O N N O O O w q I (n 1 \ \ \ \ \ \ \ \ \ \ \ \ \ \ U I H I O O O O O O O O O O O O O O H I I H H I-I r-1 ri H ~-I H r-I '-I ri H r-I 1-1 a I I I I z ~ I I o o w U z N ~ a v z u n a z z ~ H a H H a ~ F w ~ ~ W M ~ M M M a M ~ M l M G M I p. M (n M W M p: M a M ~ M C1~ M ~ M W M M M ~ M M M I ~ N Q,' N W N O N N O N N O N (~ N M N M N N F N N I I I I O N U M U N M H N a M N U] M N N W. M U N M M N M U N M H N U M H N ~ M H N f•C M ,7, N M H N U] M N M i I Q - W F~ C9 U F F W W 1 cnl w a a w a ~ w W a a w H a ~ w rn a w m dG a a w >+ a w z a H w ~ a w a H a w a H a w o a w F a a w I w w H ~ HF a x ~a -a~ o o w z w ~ I W I x x N x ~ x m a x z x W H x fx ~C F x x >+ x >+ x U x \ F x F x M I W a 1 a U F U U U q U U U x q U F U W U x (a U x q U U z u1 U ~ U • I ~ q I O >+ FC a ?I FC H N ~ FC FC ~ H FC m RC FC O GL' FC w ~ RC w 9 ~ ~ FC p'W a] ~I cC O FC ~C 3 L H Y H C m HA F z H ~Q H y+ ~ x c.~ I z~C I ••v I I H W wu [ ( f I oU /. [Q , lu g Gq H W qz W O am ~G W £F fA Cal W a U pgfA ~ GgC1 ~ HHCA U a w wu OxFQ cnu o rt I cn m I C C U U ' W a U W z U H U w U H H H U Y H u u IS H x a U W] H a a u ~ H a u ~ U Y ~ U w U z o U F a o u n I n H N t -fA I WW I Q, H FqF W H qF FC W UqF Zi a HHF ( , W~F i r.~FF aOIH Q /. UWF RC W H HqF ( a H WH W H WF W W H HqF I H WmF W F H zu]F 01 I „'7.i z I H ~ /y' H ~ H H ~ ~ w~ ~ ~ O ~~~ ~ ~ ,~. ~ z H o ~ 'N U ~ ~ U ~ a H ~ ~ ~ ~ ~.° ~m~~ qF aF a wH a ~ ~ a~ a ar a uo a O F O Ho Ho H ~ ~ q~ ~ O AN I Fq W I RCORC FCORC O~ FC~~ o]'-+FC wriFC Uu1RC UMFC UORC w~r.~ wiorl ~-IOFC r-IQ ~ i.-art \roN I H H H I I (~ N ~ ~ N V' N O CO O H H H O H~ a I I m r rn ~ o r rn r m o o r m rn FC O I I H H H ri N H .-1 H H N N .-i H H q I r r t` r ~ t` t` t` t` r r [~ t` r w w ~,' I I o 0 0 0 0 0 o O O o 0 0 0 0 rx o FL I o' 0 0 0 0 0 0 0 0 0 0 0 0 0 r.~ a l a ~ o 0 0 0 0 0 0 0 0 0 0 0 0 0 p, >, U I I o 0 0 0 0 0 0 0 0 0 0 0 0 0 W L O I U I I I 1 I 1 I 1 1 I (k •~ p,' I H O O O O O O O O O O O O O O Pr V LL I a ~ rl H rl •-i H H ri H ,~ r-I H H ri r-1 AGENDA ITEM # 4A NOVEMBER 9, 2009 N I I I I I I w I I I I I I a I I I 1 1 I I I I I 1 I I I I I I I I I I I I I I I I I I ~ a l o o m r m ~ o Yk I O~ N N W r O~ r N In O I I r O~ 01 r N In N O r l0 W I M 01 O~ OI LI1 r O ~O M lfl ~ Z I I I I 1 I I I 1 I I p l ~ O N CO O~ N N ~D ~O O Lfl x I co ~ ~ ~ ~ m <r In o a I a I I tP N 1 W I ~ 1 O1 I ~ I N I N I <M I N I O~ I (n I N d' C OJ CN ~N dl lfl VI C O I ",~ I O O VI O O q 0 O O N C!1 O O \ (q I Vl O~ H O~ Lf1 W Ol dl O~ d' H O~ O~ H I a H a M I I [II \ I I E H F o I I O m O ~ ~ z z ~ ~ wows a H~I " ~ x z z z~a~ o w w w o a I o ~ m m\ul q x H Cf) rl I CA `,~ U~ W O a I Q H Qy H z\al ~ F a w a ~ I H n~ ~ a a a q i W .. a~ ~ I ?-I z O p E u] >+ z O >+ z ~ ~+ z F u1 YI z z~ I I FC q W ~ F RC W ~w~lz a a o a a a mwa t o ~ ~ w ~ z ~ z ~ w ~ ~u I H I o z u o o x o u o H F I [-. I U O H U U O U H U a W I FC I H ~ F U ~ O al I U I W H ck W W a W fx W a cn I H I u U U U ~ U woHlw I ~ H ~ F+ w I H I aow . w I ~ H u ~ \ ~+ ~I N ,'~ I W I H V W V E. H I S I m a ~ cn z ~ ~ ~ w H •• ai l a I 7-. O H z ~ z 7y H Zi H~ a j U i H UI '~ H V H H ~ H H W W I I U ~+ q I W I 3 3 3 3 3 3 S 3 3 3 ~ l a I w w w w w w w w w w as I~ I z z z z z z z z z z woalH I cnwr~ I I '7y I I O1 O1 O~ O~ O~ 01 Ol 01 01 01 W cn •• I q I o 0 0 0 0 0 0 0 0 0 U W F I W I \ \ \ \ \ \ \ \ \ \ H Cn a I ',..1" I M W CO H N N r-1 N ~ N a 'Za W I W I H N N O O O N N N O W q I Cn I \ \ \ \ \ \ \ \ \ \ V i H I O O O O O O O O O O H I I I-i r-I ri H H e-i ri H I-I H a I I I I w w r ~ ~ ~ ~ w z a I w cn o w ~ I I ~ M a M a M ~ M M M M M M ~I M I I I a M ~ N M x N M x N M a N W M ,7., N ~I M ~ N F M H N W M V N M N f-I M P: N I I I O N U V N ' V N ~ ,~ N O M H N M N a M ~ N U M ~ N M N W N a I M a M ~ /- M ~ u ~ o a a M M a w a a a a a a g a s a a m I u w w w ~ w ~n w u w aw z w w a w w ~ ~ ~ Q q w u ~r w x u H x u H x u ~ x u ~ x m u N x H u Hmx ~ u H x u aqx aau H x u u m M I wa I q I ~ H a~~ WNW ~ ~Ha CnW ~ aFa U]W aa~+~ ]FW q a W H'~TIF(' EW auk OHW w~l~ WHW ~ i4 CW w~+~C 'HW w I q I mss 12~ I ' ~' H(7] g [q q pa U]H W UE W ~ H(p UFW HH(T1 F UaRI a HHW U .. • U I I , HV x x ZiU am WU ~ au oa q V H a o ro I (~ tb I U Q ' WH H U HMH F V HMH H U WH a U ~xH qnC U W H x U UaH U r~ WH [~ r-~ U 'JH U Z W H ~A7 I W W I , xwH fxHF fx~F W qH 3HF F~ HqF EE F4gF W r•CH HqF 3 W ''~ M O O O O O O cM 01 I ,7, Z. I ~ H ~ Cn p7 ~ p] ~ ~ p: H ~ wm O Lf) ~ ~ H ~ Hm [Q F~ ~ H H ~ ww a V ~ H p: H ~ Hw zN N \•.~ I mm I N ua I U~ . /r zzHa r1gF s w a W MF . w a W ME-I aFa qF Ma OrF xFa m]F xMa ~oH ~ a >+~F Na ~ME HFa ~E ~ ~ o C"N I (p pa I Or-C arr~ ara~ ~ o~ zMa rxoa V1Mf.(' cnoFC F~~ ao~ I \ ro N I I Cn I H rl H I I lP VI to r-I N V' M Ol lD M `~ H .u a l I m o o m m m m m o m ~ ~ O i I '-I N N ri rl H H r-I N ri H I I q r r r r r r r r r r O I W w~ I I o 0 0 0 0 0 0 0 0 0 H a' O cC I I o 0 0 0 0 0 0 0 0 o rl rx I x I o 0 0 0 0 0 0 0 0 o Q, .. a >., U I I 1o I V I w J o I 0 I 0 I 0 I 0 I 0 I 0 I 0 I 0 I o I z .. .. .. .. .. .. .. .. U - a•~a I H I o 0 0 0 0 0 0 0 0 o FC I uazoc~amuH a, r~wH>a W OOa a v a I a I ~ .~ ,~ r-I H ,~ ~ ~ ,-i ~ u