Loading...
Item 4A AGENllA ITEM ~r1 SEPTEMBI+JR 27, 204 N o N t ~D (/~ O N M M ' ti ~ Q1~ ~ j e r ~ N ~ rl 1 ~ 1 ~ O U D N O 07 r t 0 ~ r' r N Z W ~ - H a d V a z a J a J ~ ~ ° _ M a w ~: Z ~ O J O N as N Z Z W ~ ~ Z m Z Q ~ V Z ~ W ~ J J O Q F- ~ ~ N - D U ~ V ~ x y ul V ° J Z Z W ° a U Q f- O v~ Z w ~ J ~ m N ~ a ~l ~ ~ O H' ?' m U w a ~ ~ O O O O O O O O O W O O O O O = M ~ O O O O O N O 0 0 ~ O L ~ O v O N 000 t~0 a ~ IA N N M ~ N O N S ch _ 1n ti Os ' ~ O N ~ M ~ ao r ~ O r ~„~ N t0 r. O r N ~ ~' N Q> GO I~ t0 N ~ O 01 N M ~O N r ~ r ~ O Z O tf1 r ~ ~ N 00 O O r ~"' O ~ r N ~ N ~ ~ a Q U _ Q ~ f- F- ~ .~ N N ~ C7 z Z ~ O U of ~r ~ ~ u~ ~ ~ ~s v~ ~ v> ~ ~ ~ N Ch U ~ ~ u~ tfs v- ~ ~ J O O ~ o 0 0 °o °o °o O , , , `~ Q ~ N N ~"~ ~ oo N ~t <O M ' O ~ Z Z LL S Z O : N ao o~ O ~ r rn W M Q r o~ O O O t0 N CO N N IV ~/ V (,~ 0 = I"" ~ X O 0 O 0 O 0 O 0 O 0 O O O Q O 0 O 0 O 0 O 0 O 0 O O O O O O O O O O Q ~ Q ~' W N ~ N O 1~ O !O N p O ~"~ O p 47 l0 d7 N N r OD ~ p 0 to O O O O 00 1~ !r O O O ~ W ~ Q O ~ tD t~ O O 01 O 01 ~ 1~ M r O r 1n Q1 Fi /^~ O H- N V i'7 r r t0 r e r r ~ ~ N O N ~ ~ W ~ ~ D z w o o a _ ~ ~. W O O Ip M ~ N IL d Q N ~ ~ M NI ~' I_' Z . r r C G M W Q O ~ } r N C1 ~ N r ~ ~ ~ ~ ~ r N d' N M ~ N ~ ~ et ~ O I ti 1 „ W N ~ ch W r W m .O t0 ' r O O Q N N M CO N d I ~ ~ ~ z } ~ U Z ~ J a w - ^ ~ J O ~ ~ Q W d J H ^ ~ . ~ ~ . J c = n O ~ J J J Q ~ O a H ~ O ~ C o Z I-' O ~ ~ Q J Q ~ ~ ~ a Q U J Y 0 ~ ~ > ~ ~ ~ W ~ ~ C Z ~ C 7 U z a w 0 z Q ' ~ ~ „ W ^ ~ J W ~ ~ fn W ~ Z f w A U f n ~ m z Q x ~ ( ~ ~ _ ~ s W O _ O J ~ O ~ w - ~ Y U u - ^ Q J Z U~ V~ c? ? w ~ >Z ~ O Q w ~ ? J J w 0 ~ o ~ ~ ~ w W G .. Z c ^ n W ^ O ~ U F- O ? c n ^ ^ ^ Q O w U ^ W I ~ - ^ ~ c x n c ~ ~ c n w a ~ a ~ cn F - c n ^ ~ ^ r Water Sales Atlantic Beach Buccaneer Total Water Sales City of Atlantic Beach, FI. Utility Sales Report AGENDA ITE~~I 4A SEPTEMBER 27, 2004 August 2004 August 2003 _ _- -- _ _ - Gallons -- Actual evenue ',, - --- allons -- ctual __--- evenue ___ Accounts -- (000) Revenue Per 1,000 gi _ __ - Accounts (000) Revenue Per 1,aoo 9i 5, 505 50, 561 $108, 861 $2.15 +{ 5, 367 53, 577 $102, 384 $1.91 747 2 29,296 $66,278 $2.26 2,588 33,632 $74,096 $2.20 , 8.252 79,857 $175,140 $2.19 7,955 87,209 $178,480 $2.02 ---- _- Water Plant Production _ _ ___ __ __ Gallons (000) Atlantic Beach Buccaneer Total Production Total Water Billed Water Loss for month: Percentage Loss Total 12 mo. Avg. Loss 64,667 25, 066 89,733 79,857 9,87fi 11.01% 13.75% Gallons (000) 61, 606 34, 690 96,296 87,209 9,087 9.44% 13.18% Gallons Actual Revenue Gallons Actual Revenue Sewer Sales Accounts (000) Revenue Per 1,000 yl Accounts (000) Revenue Per 1,00o yi !~'' , ,. ' Atlantic Beach 4,950 36,762 $154,063 4.19 4,828 40,190 $155,490 3.87 Buccaneer 2,621 27,150 $136,032 5.01 2,483 31,622 $140,409 4.44 Total Sewer Sales 7,571 63,912 $290,095 $4.54 7,311 71,812 $295,899 $4.12 e* !+" AGENDA ITI~:11~I ~a~'. S~1''TE11IB1?.I: 1.7. tlif)1 !'•~ O `pper b N ~ ° ~ O ado "~'' M ~ d N S a ' r' ' ~ c . t` a v ~ O O o C. N 'O O ~ ~ U ~ ~ ..t 0 N . N~ M N G ~ p N U c d N ~ QD U N M O ~ y ~ ~v U ~"" ~ '" ~'" N p ^C W A ~n G ~0., O ~.+ ~,' ~+ C ~ ~ .~ ~ ~ .~ ~ N W ~ N ~ A O I-~l ..~i ^~ C~ H ~" f/1 n ~ ~ .~ Uj ~ O w M y G~i .0 ~r U y CJ ~ • F W P"y V s, r~ '~ o `.+~'"-~ j O :O "~ b ^~ ~ O CL ~Q ~ y t) y N •vi M ,~ ,~ iti ^ •~ ry W y "~ 00 N 4. N ~' N s0,•, ~n b a> ~ C O ~ ~ • d ~ _ b • a~,o u: ~ ~U y' O ~ Y c C'1 ~ ~^y ~ Y p ~ ~ U ~! ~ La•' ~ T.~ o ~ " ~ {~ OLyy ~ 01 °" ` N ~ UR7 ^y lC ~ b a ~ p 3 . oA ~ ~ ~ c ~ P , bA v ~ , i ~ . ~.. a o O N N •b D ~"' cad y ~~. Q G O N ~ O O 1, N y ~ 'y P-i pD ~ ~ ~ s. ~ in . b ~ ~ ~ y ~ ~ U CAF ~ ~ ~ °~ ~ O O ~ ~ '~-' r ~ 'a ~ C ~ ~ ~ ,,, . b cd P • C ~ f1 ~ \ ~ ~ ~ fy cd + .~ ^ . 0 O ~+ ~ F7 v, O O ` ~ E' ~ F. ~ ~^ L C a -. w ~' .d :b CYd C'.. G ^" ~ CC + A i-i p., N a) ~'" ~O G" ~ w ~r ~-~ L. O y N ~ c p ,b ,o a oU cd 3~ N o u O ~ww ~ o. U ,: o I M o Q ~ o oU y~ ",y ~ o y ~,•, y .~~~'~c ~ c3dC~AObo•oR .ty ~ ~a~~° P.. boW ;'~ ~c ~c3 ~ [••i t 1 o is ~ ~ bA n ~ °~-d °~'~ ~ O ~ ~ • ~ ~; -dw °' >, ~ A ~ ~bq° 8 w cd ~~b ~'~ °~ C' Z = ~ G a y ~ +r ~ + ~+ " °~ "' U ~ ~ L^ a~ cV " v, C +: W z ~ "l7 ~'+ ~~' r1 U ~ ~ ~ ^ i. b ~ ~ L6 b VI U y ~' s~ v' i? 3 ~., .C L'i ~O {~ ° ° . p V bA w .~ ° ~ b0 q F O p ~ a QO O ~ ~ ~ O c~ ~ ~ Y ~ O Y U ~ 3 c c d C ~ O V ~ Iti VI .~ \ ~ ., • w 'CJ ~ r. O .~ ~ ~ 3-i Fr ~ w O d o -d o o~ o ~ ~ b~ ~ o a r ; ° q 3 ° a o a a~ -o ~ A ~ ~„ U U~ 300 ~ o ~ U cd.~ U U> o , a U W 3•oQa ., Q P. ~+ Ewd a a~-oS R~ W d H ~ z ~, F d ~ O ~ b~ H F ~ Q 3 a H ~ U z O ~ s ° ~ x a o 3 '~ ~ ~ z ~ ~ O m o ~ ° ° ~ 3 rV.i W ~ ~ ~ 3 o U X23 ~ °~' N .~ ~ ~ z Q ~~ 3~~ x q ~ U ~ ' ' I 0. W ~ 7 ~ II C ~ ~' II p .~ 3~ ~ ~ 2 s~ z ti ~ x ~ II II ~ a n u W n u u n W O a II GQ ~V ~ A ~ ~ ~ A ~v O a N z ~ b H ~ 0 3 ~ 3 U u '~ ~, w o~ ~ .oA v~ 3 ~ ~ w ~ ~ '~ ~ y ~, ~ o ~ ~ N ~ U z O ~ ~ ~ E-• ~ o ~ ~ ~, ~ e c°~ y ~ ~ ai ~ ~ o ~ , 0 ~ ~ ~ ~ ' a ~ ~o ~° ° o o ~~ > oo ~o~ ° ~ ~ `ti `° o x a ~ o W x ~ ~ ° ~ ~ ,° a ~ I ° ~ ~ II r cn W ~ ~~ W \ O T II ~ o ~, 0 ~ ~ GL ~ G h ~ O O U A ~ O ~ r O p . 0 0 I y 0 ~ .~, O~ . O O q .~ •... W z F U M • - ~ 0 II ~ ~ ~ ~ ~ II ~ .~ II b U = ~ ~ V II ~ ~ p o II 3 ~ w ~ ~ ~ • cv 0 ~.^. ~ t~ .o h ~o fy' V y y .~ v] ~ y . b ~ W O ~"•V ~ r• O~ ~ O y O N O ~ ,y" N q U 3 O~~ N U wa q N N O x qv A a 'xw q~ a qU r a F q A ~ N ~,, d. v, ~ #~ S~Z''1'I~;il!fll±:1~ 2'/, 2004 ~ -~~ .. L N ~: Y ~ ~ y ~ O ~ O ~ i vi C C H G 7 3 ~ "O QJ C .C b O c'~ ~ y N ~" p r ~. s •~ ~ ~. W ~ ~ N O O a 3 ~ °' ^o' y a„ •G .~ •~ q~ ~ p° i L~ u ~ p o ~c 3 '~ ~b.o`; U a`iw E.. d d C~ o ~'' cd QJ Ci y 0O N ~ O y d i ~O„ [""~ ~ N Cd .b ~ a~ .`~ .O ~ .~ ~ 'LS ~ d 7, ~ ~ O a~ N 'C .-+ .~ N O O ~... ~ ~ .b ~ C 0 ~ L ~ 00 C U ~ .~a U ~ a~ ~ o d ,~ ^ ao 6 O v, v O ~ ~ y ~ p0 A ~ ~.' ~ u r !~ (~ 'b C cd . ~ ~ C ,~ .`? Z p o ~ ~ ~ ~ y ~ ~ O ~ n ,b .SC ,,~ ~ N v C ~ O N Q =~ V G N F U .S 3 ~ a ~ o ~3 .~ b .S a ~ G'' ' N ~„ ° .ri ~ ~ 'd VJ ~ N~ E y G" L ~ U O~ .-..~ ~ v d 14....i '~ Q R G eC y ~" -p ti' ,p N y 'tJ ~ ~ R i+i C v, ~, O "C O O h a~ a~ O ti .~ T O p ` ,O bA O V ~r7 V :w, ~" y y a~ ~ a0i eQ dq O~ •~ .rte. N ~ "" b cad ~' ~ ~ ~ ~ C.~ ~ ~ r ~ c0 ~ .9 o a, ~ ~ ._ o Q .d U 'fl y ^-°- ~' >, ~ 3 by q ~ ~ ~ O w, U b ~ u 3 N O O a0+ ~ Y y 'd O >. O ~, "d ~ Z ~ ~ ~ ~ o ~ y ~ ~ ~ ~ d " d vae ~ a ~ ~ 0 3 ° i on • a~ " e a`i ... b i 'C W ca ~ ~., ~ v ezza W 'Z bA ~ , N \ C"» (~ N 0. L y ay a+ 7. ~ ^O '~ C N L a E., ,~'~, v °~~' c <t ~ v abi ,5 ~ ~ aai °° U ~ .~„ ~p '~ y ~ an c ~ o0 0, `y w/ [..I s.. N O O ~ ~ .." ~ b O s.. ?~ C~ ~ 01 L O N '~ V ~ ~ ~ A W cn ~ ~ :° v ~ . aS ° a ~ A G, a, A W w ea C~ o ~ 0, U en 3 a a H ° z ~ .~ o U ~ ~ a ~ ~ ~ ~ 3 ~ F- z Q ~ ~ w t/~ V O a ~ a0i 'd .,`~ ~ ~ 'o ",t,' ti U O ~ Y '~ o ~ o a ao w x o b 3 .~ 3 ~ d ~, 3 A ~ Y ~ a ,~ ~ co b b y a ~ ~ °~ 3 N z a 3 ~ b ~ 3 A a a ra z 3 w ,~ b ~ o ~ ~ 7 ~ y~ p" W U ~'y n ~ II Q u ~ II b II ~ ° II ~ ~ II O ~ II II W II ~ II W II II W I^ H W II I^ W InnI II W II II W U Oai Q .Vi U ~ Z .Vi U A U .U.i A v~ Q .U.. .U.~ C ~ V Q ~ U a H z O '° ~ ~ y U ~ ~ ~ ~ I~ ~ C, Pr a~i Q, a3 ~' A a ~ i W p d ~ ~' ~ ~ U H c ~ o ° 3 • ~ c _ ~ a~i \ II ~ o\° u ~ u ~ ~ o k C7 ~ u U ~ u ~ o~~° u W > 0 3 0 ~ 'd \ ~ ~ o ~ W Q7 00 ~ v~ °, z a`p o ~ W V ~ II ~ a) II ~ ~ II ~ ~ II ~ ~ ~ II ~ .•~ II ~ ~ ~, II ~ ~' O 3 ~ o -~ m o~ o"i o ?~ ~ o ~~ o"i o~ `~ m o~ N m o A a ~ qU ~ qU ~ QU csa qU v~A qU as qU v~.-° ~1U u A ~ '" ~ ~ ~ AGENDA tTEP~14A SI.~P'TI:11[73ER 27, 2004 V ,G o H ~ Q' 7 a~~ y- a a o~~ o ~ ~ N N a 0 N :: c N ~_ H to m C m O1 m E W m w_ 0 4 F- } O 7 a v 0 0 N 0 f- 01 Q M O p N Q N >- O 7 Q N O O N o ti r n. m ~n oo o~ r M r O d' V' ~ r N O O M N O N M O C r (y L O M N ~D r ~ N O+ r N ~ t~ N s}' O O r M 00 M t~ M~ r r M I p sr 0) M (O ^~ O tf) r M p ~ t0 M ~ N i p r M to M M r h r r N w w = N 'C ~ L dl ~ Q c ~ Q' N ~ N ~ a ~ Q a~ a~ ~ ~ ~ m m - m ~ a~ ~ ~ ~ ~ ~ i O ~ 11 ~ Q (/1 m J Q M m •` U O a d r 7 n O (~0 m 4 Cf C . C . ~ N o .~ • ~ ~ r v ~ ~ ~ c~ ~ y C p~ N ~ ~ C -L U C N •`'• e Fz_-a~ XQ p W c ~N c U > , ~ ; ~ U c ~U ~ W U o U ~ ~ c ~ U ' J ~ fp N • V C Q .._ ° v a~~ mcxu . a aT c C .~ f~ F- } ~r 0 0 N 0 F- M O O N Q Z N O O N C 0 U E Q SG4''1'~l'II3til.t ?7, 200.4 ~ rn T {(~ 1 ~ M n ~ Q M ~ M M O O N f~ Q D ,Nr. ~ ~ H } Q r ~ ~ O M 'd' ~' Q d N M f~0 Q +r- tC) i h ?- o r~ rn r~ ~ ~ N M I ~ N Q '~ N ~ O O N N y }~ f4 V cA S W N d ~ ~ ~ m V m 'C C ~ ` C m L L m m !~ > w C C O W H Y m , v a V ~ AGENDA ITEM 4A SEPTEMBER 27, 2004 aaawaJ-ZC7 awzc-zt9 $ v uNi $ m ~ m ~ uoza~-azuw ~i $ " $ "' m o N $ amD OI ~ V CWD ~ v n N ~ O f7 Q ~ f~ N ~ ~ v ~ O1 N O n ~O~pp ~Wfpp N ~ ZP N N N N N N N l7 N N t~1 N W NOSO Gam' NS ~ o ~ ~ o ~ o 0 0 0 0 o m o m m o m ~ o ~ o 0 o mm o ~ Q ~ Pty G MP~' PN~ E~ PZ 0 0 0 O O O O O O N O N O O O ~ O ~ O O O O O O f~l O M t.N PGN~ S~ ~S E O r r O ~ ~ O [h M O O O O ~ •- O N N O O t+f O •- ~ ~ N NUMS USE 1~Q PL ~ N Hf ~ m 1~ N N r O O O O n t` O O O d ~ N O N N m N ~ ~`` ECE SN~ SNP S m fh ~ N O N N O N t~ ~ ~ ^ ~ N N ~ l7 m 0 0 d ^ t~ O NW d V vEN`c PB~ 5 UE m O m N O N h 0 t~ d N m m 0 ~f1 d i m N N E N m m ~ O to ~ NG "S QUg\ N ~PV c~ W ~ d d m d d m C1 N ~p ~ u~ m o n r ~ fo o f7 o fn N $ N ~ °F w R NG d t7 1~ N '- f~l N f7 N r YI m d m 0 N O N O m W N N d N ~. ~ ~ !~"C P H m ~ W m M m d m W d N m N (7 m ~ N N m m O N N M N m ~~BB`S irf '- N f~ m 1~ N m ~ O r O N O N N N N fp r m O ~ ~ O N ' N N ~ t~ m of 5`GN N N N N d ~ m ~~NG 0 0 0 O O O N N d O M O .~ N ~- N ~ O ~ O O O m I~ FE `NG ~ ~- N d O d d O d O O O f+l O fh N .- d Yl O ~(1 N O N O N O wENS V N N A M N O N N ~ m f7 W N f+f m W 10 O N ~ m N h N W N m r l~ ~'ESP d t +/ VE R`S N O N N O N d 0 d O N N N O N O N N ~ O '- [7 ^ ^ ^ m O O QEO y PL W W d W I W W W W W W a R R ~ Q p lL y ILL A LL pa LL y LL C LL 7 IL IL (.. LL tl!F LL MH =' M~ l a g HF- MF NF h1= d YIF ~ 2Zm M ZZJ ZZN ZZm 22/q 2ZfA . ~~ ~ G a J O_ ~ J O F J O B O~ ~ G~ J O F N ~ O a W 0 a W 0 ~ W Q a W Q a W 0 ~ W Q a W 0 a W 0 a W 0 ~nr c~o~- oc~~- c>c~t- oc~~ c~c~r- aar c~c~~ c,~c>r ~• AGENDA ITEM 4A SEPTEMBER 27, 2004 City of Atlantic Beach FINANCIAL REPORT AUGUST 2004 Cash Balances Prior Current Dollar Fund(s) 7/31/04 8/31/04 Change General $5,869,428 $5,772,946 ($96,482) Tree Replacement 13,720 17,201 3,481 Convention Development Tax 148,709 156,685 7,977 Local Option Gas Tax 290,726 315,525 24,799 Better Jax 1/2 Cent Sales Tax 1,043,984 1,080,399 36,415 Police Training, Forfeit, etc. 35,308 38,117 2,810 Grants (30,137) (55,303) (25,166) Debt Service 62,624 68,622 5,997 Capital Project 39,796 39,841 45 Utility 4,068,218 4,237,937 169,719 Sanitation 792,014 798,113 6,099 Storm Water 1,059,057 1,156,604 97,546 Bond Construction 268,737 260,192 (8,544) Pension -Police (5,012) 20,050 25,062 Pension -General 59,868 10,260 (49,609) Total $13,717,040 $13,917,189 $200,149 Total Restricted Cash $6,793,166 Total Unrestricted Cash $7,124,023 ~" Cash and Investments Prior Current Dollar Rate of ~""' Account 7/31/04 8/31/04 Change Return Bank of America -Depository $60,150 $492,692 $432,542 0.50 SBA 13,386,103 13,153,358 (232,745) 1.54 Cash on Hand 2,050 2,050 0 - SBA -Bond Construction 268,737 269,089 352 1.54 Subtotal 13,717,040 13,917,189 200,149 Suntrust-Pension-Police 3,857,494 3,935,349 77,855 7.40 (1) Merrill Lynch-Pension-Police 323,773 328,518 4,745 19.70 (1) Suntrust-Pension-General 5,176,746 5,255,505 78,759 7.40 (1) Merrill Lynch-Pension-General 667,464 677,246 9,782 19.70 (1) Subtotal 10,025,477 10,196,618 171,141 Total $23,742,517 $24,113,807 $371,290 (1) FYTD rate of return through 6/30/04 ~* AGENDA ITEM 4A SEPTEMBER 27, 2004 City of Atlantic Beach FINANCIAL REPORT AUGUST 2004 Revenues Fund / (Footnote) Annual Estimate YTD - 92% of Estimate YTD Actual Dollar Variance Percent Variance General (1) $8,894,927 $8,156,649 $8,349,381 $192,732 2.36% Tree Replacement 3,000 2,751 3,481 730 26.54% Convention Development Tax 77,000 70,609 75,285 4,676 6.62% Local Option Gas Tax 508,870 466,634 478,634 12,000 2.57% Better Jax 1/2 Ct Sales Tax (2) 605,442 555,190 660,935 105,745 19.05% Police Training, Forfeit, etc. 33,250 30,490 33,628 3,138 10.29% Grants (3) 433,342 397,375 145,933 (251,442) -63.28% Debt Service 72,086 66,103 65,738 (365) -0.55% Capital Project 51,265 51,265 100.00% Utility (4) 6,519,477 5,978,360 5,795,304 (183,056) -3.06% Sanitation 1,259,000 1,154,503 1,181,128 26,625 2.31 Storm Water 1,755,265 1,609,578 1,644,528 34,950 2.17% Bond Construction 5,693 5,693 100.00% Pension -Police 467,587 428,777 539,181 110,404 25.75% Pension -General 686,518 629,537 783,474 153,937 24.45% Total $21,315,764 $19,546,556 $19,813,588 $267,032 Analysis of Major Variances (1) The $192,732 positive variance in the General Fund resulted from the timing of property tax receipts, increased building permit fees, early receipt of interlocal revenue from the City of Jacksonville, and reimbursement for DOT system lighting maintenance, offset by lower than anticipated revenues from the Communication Service Tax and State Revenue Sharing, and reimbursement not received from the City of Neptune Beach, due to the delay in the Welcome Sign project. (2) The $105,745 positive variance in the Better Jacksonville Half Cent Sales Tax Fund was due to slightly higher than anticipated sales, and early receipt of sales tax revenue from the State and grant reimbursement for the Dutton Island Park construction from the Florida Inland Navigation District. (3) The $251,442 negative variance in the Grant Funds was due to the completion and subsequent reimbursement of the CDBG drainage project at George and Dudley Streets being delayed until FY05, and the delay in quarterly reimbursement from the granting agencies, resulting from grant expenditures not occurring until late in FY04. (4) The $183,056 negative variance in the Utility Funds was due to approximately $390,000 lower than anticipated water and sewer sales and a $38,000 difference in accounting for Section H assessments, offset by a $205,000 positive variance in sewer and water impact fees and a $40,000 reimbursement related to the Beaches Cooperative Utility Plan, planned for in FY03, but received in FY04. ~• AGENDA ITEM 4A SEPTEMBER 27, 2004 City of Atlantic Beach FINANCIAL REPORT AUGUST 2004 Expenses Department / (Footnote) Annual Estimate YTD - 92% of Estimate YTD Actual Dollar Variance Percent Variance Governing Body $44,484 $40,792 $39,852 $940 2.30% City Administration 1,930,491 1,770,260 1,582,620 187,640 10.60% General Government (1) 2,366,747 2,170,307 1,262,986 907,321 41.81% Planning and Building 677,228 621,019 467,034 153,985 24.80% Public Safety (2) 4,162,286 3,816,814 3,278,866 537,948 14.09% Parks and Recreation 924,890 848,125 765,540 82,585 9.74% Public Works (3) 5,693,899 5,221,305 4,210,113 1,011,192 19.37% Public Utilities (4) 7,627,547 6,994,461 6,067,781 926,680 13.25% Pension -Police 282,812 259,339 266,318 (6,979) -2.69% Pension -General 344,297 315,720 296,552 19,168 6.07% Total $24,054,681 $22,058,142 $18,237,662 $3,820,480 Annual YTD Estimate YTD Dollar Percent Resource Allocation Estimate 92% Actual Variance Variance Personal Services $7,309,556 $6,702,863 $6,323,548 $379,315 5.66% Operating Expenses 8,228,395 7,545,438 6,178,383 1,367,055 18.12% Capital Outlay 4,661,013 4,274,149 2,050,605 2,223,544 52.02% Debt Service 1,751,509 1,606,133 1,751,376 (145,243) -9.04% Transfers 2,104,208 1,929,559 1,933,750 4,191 -0.22% Total $24,054,681 $22,058,142 $18,237,662 $3,820,480 Analysis of Major Variances (1) The $907,321 positive variance in the General Government departments resulted from the delayed or deferred construction of various projects funded from this source -See Project Activity schedule. (2) The $537,948 positive variance in the Public Safety departments was due to position vacancies, delays in grant expenditures until later in the fiscal year, and $325,000 of the variance was a result of only two quarterly invoices for contracted fire services with the City of Jacksonville being received and paid FYTD. (3) The $1,011,192 positive variance in the Public Works departments was due to the Hopkins Creek drainage improvement land purchase and construction project being delayed, the demand for mosquito control services being less than anticipated, and annual tippage to the City of Jacksonville and the July and August billings for sanitation hauling services to be paid in September. (4) The $926,680 positive variance in the Public Utilities departments was due to a reduction in infrastructure repairs and maintenance, no contractual obligation to pay the City of Jacksonville for the right-of-way franchise fees, and delayed or deferred construction of various projects funded from this source - See Project Activity schedule. I i AGENDA ITEM 4A SEPTEMBER 27, 2004 City of Atlantic Beach FINANCIAL REPORT AUGUST 2004 ~" Project Activity YTp YTD YTD ~'"' Project Name Budget Actual Balance Status General Government: City Hall Expansion Parks and Recreation: Veteran's Memorial Park Skateboard Park Public Works: Core City Project Core City Sewer Improvements Core City Water Improvements Plaza Entrance/Post Office Hopkins Creek Basin Pond Town Center-Phase III Mayport Road Medians Drainage-George & Dudley Streets Sidewalk Replacements Bike Paths on Seminole and Plaza Welcome Sign and Landscaping Concrete Pipe-Country Club Lane $363,450 $54,735 $308,715 B Subtotal 363,450 54,735 308,715 10,477 10,477 0 C 88,574 8,847 79,727 E Subtotal 99,051 19,324 79,727 Subtotal Public Utilities: Sludge Holding Tank at WWTP2 Rehabilitate Well 5 at WTP3 Replace Well 2 at WWTP1 Security Upgrade/Water Plants Water Main-Ocean, Ahern-8th Telemetry at Lift Stations Switchgear at WWTP1 Headwork Improvements at WWTP2 Influent Screens at WWTP2 Relocate Elevated Storage Tank at WP2 Water Interties - AB & BUC Fencing at WP2 and WTP3 Water Main -Park and Dudley Streets Shelves at 902 Assisi Lane Sewer Rehabilitation Mini-System B Security Upgrades at WWTPs Sludge Holding Tanks at WWTP2 Utility Relocation - Wonderwood Connector Subtotal Total 406,300 158,447 247,853 17,673 17,673 0 60,758 60,758 0 67,200 67,200 730,465 24,711 705,754 141,845 140,544 1,301 231,000 25,835 205,165 121,403 12,326 109,077 50,000 15,410 34,590 217,650 15,082 202,568 18,800 18,800 84,056 84,056 0 2,147,150 554,842 1,592,308 58,053 57,980 73 19,257 19,257 0 178,405 150,276 28,129 105,000 4,368 100,632 14,912 14,912 0 120, 000 14, 888 105,112 24,984 24,951 33 199,500 11,632 187,868 35,625 35,625 0 260,630 187,737 72,893 13,991 13,959 32 6,594 6,053 541 111,489 100, 342 11,147 8,000 3,414 4,586 150,000 29,377 120,623 40,000 29,554 10,446 95,000 85,190 9,810 117,258 117,258 1,558,698 789,515 769,183 $4,168,349 $1,418,416 $2,749,933 '~ Status Key B -Bid Awarded E -Design Phase C -Project Completed I -Project In-progress ~"" D -Design Completed R - Re-budget Next Fiscal Year I C C R E C R R I R C C C E B C E D C I C C C C D C C C