Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Item 4A
I ' j I ! AGENDA ITEM # 4A I AUGUST 23, 2010 i - I o �. W 1 I MI U) N et 2N—wart—a) 0 o Z o N w w M M o,- N Ti 0 O H w F- w V J W } CO i 0 F s. < . W Z J O J J O O Z O a i - Z w a N L.. c 0 0uz — OW Ow c4 wz2-z Z4 1 3 e3 Ce mwa22 a z 000000 00000 o w O o O O, 0 0 0 00 0 . ° o O M 0000co w 0 J ti O ON mo w Ali W 00010>OD t0 001 WM N'7 0 'Q NO O MM Ot0 CO e } > N"1 N N eo NA Co; O; 0 LOEl NCO r N N M � W ,_ N O O N40 EA N J N ! m N 0 D 0 D O = � O I H NA 40 EA Ns 40 44 w • 0 ' 0 1 QW O o jII1L Z O o 0 N Z 0 0 Z $�o er� 0 W � Q o 00o ti = �' y 0 No> Ht.. °N• o ' I — iN m I-- Q IH a I 1- iX 0 0 00000000 0 0 00 O 0 0 0 o o 00000000 o O O oo o co o N�01c oNMNlnN o N o'o o co C Q NN V MMW /.N010 o O 'tet N M ▪ MI IX Na � (0 N 0 F- o jN• NN N � H• Q 0 M NNa- ! % (0 0 Nn eA t� Ns W r 0,� ! h im W V V N Z 1 I 0 ' — n 0 . a 1 U) co w NA NR Ns Ns NR NA Ng NA to I w us Ng ea W' _ mum 1 l y„ N N ' C 0 peOM �I� W r w 0 ti O O N a I M I u, i 1 w r0 00C) N7 N NN� 0)0 . MO1• M! t 6Y O O 1 ! 0. d O OI O I z I r r z 1 - i J I a 1 y J Z 1 FO 2 Z car- 0 a — j 1 i u.0 z g U F- 03 o i- c� wmw p I- �a wJa IF W 1 npWp , J a> w<u) , W > p > - 2aZo< C72 W z ›- a Cl— a �4 QQ OZ�w w N a a z u. 3' < nU aJpaa_5g3 po o W Z I }LL F- wlZ 1.1— ZZZOPw� } a I- J x Jpwwwwl I - aamzOJd J W - 3 W Zmwot- Zww000wJwwJ0— wWwewOwW0m ' I d u)oc o0 tAZreUV Vdw'2'2 a ! wsinixo_o a. fnu_o 1 • City of Atlantic Beach AGENDA ITEM # 4A FINANCIAL REPORT AUGUST 23, 2010 JULY 2010 Cash Balances Prior Current Dollar Fund(s) 06/30/10 07/31/10 Change General . • $5,366,715 $5,247,313 ($119,402) Tree Replacement 3,989 3,989 0 Convention Development Tax 54,045 45,810 (8,235) Local Option Gas Tax 94,780 99,692 4,912 Better Jax 1/2 Cent Sales Tax 430,763 395,056 (35,707) Police Training, Forfeiture & Grants 118,886 159,338 40,452 Community Development Block Grant (26,319) 0 .26,319 Debt Service 54,506 60,288 5,782 Capital Projects 1,384,214 1,466,764 82,550 Utility 3,118,792 3,541,433 422,641 Sanitation 600,231 611,656 11,425 Building Code Enforcement 55,910 47,318 (8,592) Storm Water 2,898,124 2,651,088 (247,036) Pension - Police 17,345 855 (16,490) Pension - General 95,360 124,397 29,037 Morgan Stanley Smith Barney Unrealized Gains 283,638 311,313 27,675 Total $14,550,979 $14,766,310 $215,331 Total Restricted Cash $7,502,840 Total Unrestricted Cash $7,263,470 Cash and Investments Prior Current Dollar Rate of Account 06/30/10 07/31/10 Change Return % Bank of America - Depository $7,050,097 $7,239,991 $189,894 0.300 Federal National Mortgage Association Bo_ nds 1,012,518 1,013,923 1,405 3.100 US Treasury Notes 1,147,255 1,160,275 13,020 4.625 US Treasury -Notes 2,140,358 2,156,406 16,048 3.625 Federal Farm Credit Bank Consolidated Bonds 1,152,850 1,141,400 (11,450) 4.875 Federal Home Loan Mortgage Corporation 1,017,906 1,019,071 1,165 4.000 Federal Home Loan Bank Consolidated Bonds 1,026,869 1,032,111 5,242 4.300 Morgan Stanley Smith Barney Cash Balance 0 0 0 N/A SBA - Florida Prime 226 233 7 0.380 Cash on Hand 2,900 2,900 0 N/A Subtotal 14,550,979 14,766,310 215,331 Police Pension Investments 5,639,097 5,834,562 195,465 1.550 (1) General Pension Investments 9,386,873 9,823,356 436,483 1.560 (1) Subtotal 15,025,970 15,657,918 631,948 Total $29,576,949 $30,424,228 $847,279 (1) YTD rate of return through 03/31/10 " AGENDA ITEM # 4A City of Atlantic Beach AUGUST 23, 2010 FINANCIAL REPORT JULY 2010 Revenues Annual YTD - 83% YTD Dollar Percent Fund / (Footnote) Estimate of Estimate Actual Variance Variance General (1) $11,446,448 $9,534,891 $10,295,350 $760,459 7.98% Tree Replacement 0 0 3,989 3,989 100.00% Convention Development Tax 80,500 67,057 61,620 (5,437) -8.11% Local Option Gas Tax 455,764 379,651 379,208 (443) -0.12% Better Jax 1/2 CtSales Tax 612,334 510,074 519,008 8,934 1.75% Police Training, Forfeiture & Grants 448,051 373,227 329,616 (43,611) - 11.68% Community Development Block Grant (2) 343,473 286,113 61,396 (224,717) - 78.54% Debt Service 69,000 57,477 57,238 (239) -0.42% Capital Projects 1,002,000 834,666 837,327 2,661 0.32% Utility (3) 13,766,898 11,467,826 7,111,988 (4,355,838) - 37.98% Sanitation 1,822,000 1,517,726 1,512,716 (5,010) -0.33% Building Code Enforcement 308,050 256,606 232,109 (24,497) -9.55% Storm Water 933,000 777,189 787,288 10,099 1.30% Pension - Police 910,823 758,716 721,164 (37,552) -4.95% Pension - General 1,449,292 1,207,260 1,170,365 (36,895) -3.06% Total $33,647,633 $28,028,479 $24,080,382 ($3,948,097) i Analysis of Major Variances • (1) The $760,459 positive variance in the General Fund resulted from having received 101% 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 $224,717 negative variance in the Community Development Block Grants resulted from expenditures that are 34.1 % of the budgeted year to date amounts. These grants receive revenues on a reimbursement request basis - see Project Activity Schedule. (3) The $4,355,838 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 11.5 %. City of Atlantic Beach AGENDA ITEM # 4A y AUGUST 23, 2010 FINANCIAL REPORT JULY 2010 Expenses Annual YTD - 83% YTD Dollar Percent Department / (Footnote) Estimate of Estimate Actual Variance Variance Governing Body $43,303 $36,071 $36,172 ($101) -0.28% City Administration 2,410,320 2,007,797 1,835,246 172,551 8.59% General Government 675,834 562,969 515,840 47,129 8.37% Planning and Building 508,068 423,221 407,637 15,584 3.68% Public Safety (1) 6,475,117 5,393,771 4,589,619 804,152 14.91% Recreation and Special Events 387,063 322,423 305,456 16,967 5.26% Public Works (2) 8,949,399 7,454,849 6,029,232 1,425,617 19.12% Public Utilities (3) 14,201,867 11,830,155 7,554,242 4,275,913 36.14% Pension - Police 519,506 432,748 500,371 (67,623) - 15.63% Pension - General 513,359 427,628 477,058 (49,430) - 11.56% Total $34,683,836 $28,891,632 $22,250,873 $6,640,759 Annual YTD - 83% YTD Dollar Percent Resource Allocation Estimate of Estimate Actual Variance Variance Personal Services $9,194,253 $7,658,810 $7,262,157 $396,653 5.18% Operating Expenses (1) - (2) 9,751,687 8,123,155 7,285,065 838,090 10.32% Capital Outlay (1) - (3) .10,904,493 9,083,443 3,458,778 5,624,665 61.92% Debt Service (4) 1,755,495 1,462,327 1,679,951 (217,624) - 14.88% Transfers 3,077,908 2,563,897 2,564,922 (1,025) -0.04% Total $34,683,836 $28,891,632 $22,250,873 $6,640,759 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 Administrative & Patrol divisions in the General Fund and the Police Grant Funds, seasonality of the Lifeguards and the Police Building project has had limited activity - see Project Activity Schedule. Also, the next quarterly payment to the City of Jacksonville for fire & rescue services is due in September, 2010 for July through September, 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 and 06/01/10. City of Atlantic Beach AGENDA ITEM # 4A AUGUST 23, 2010 FINANCIAL REPORT JULY 2010 Project Activity - Current Year Activity Only Project YTD YTD .YTD Project Name Number Budget Actual Balance Status Public Safety Lifeguard Building Roof Replacement LGO901 0 0 0 X Police Building Renovation /Design /Construction PS0504 435,788 20,628 415,160 E 435,788 20,628 415,160 Public Utilities: Replace Well at Water Plant #1 PUO304 752,834 299,475 453,359 I Reclaimed Water Plant Construction PU0805 0 0 0 X TMDL: WWTP #1 Design PU0905 566,125 391,976 174,149 E TMDL - Lift Station /Main Transfer Flow PU0906 3,847,296 373,216 3,474,080 E Generator - Mimosa Cove Lift Station PU0907 31,518 31,518 0 C Elevated Tank - Water Plant #1 PU1001 40,588 0 40,588 I Ground Storage Tank Rehab - Water Plant #1 PU1002 41,253 0 41,253 I Water Main - Ocean Boulevard /10th to 14th Street PU1003 150,331 146,583 3,748 I Salt Air Gravity Sewer Rehabilitation PU1004 400,000 0 400,000 I Mimosa Cove Lift Station Upgrades PU1005 142,000 0 142,000 I Lift Station E Upgrades PU1006 200,000 1,299 198,701 I Gavagan Lift Station PU1007 8,338 7,571 767 C Camelia & West 3rd Street Lift Station PU1008 12,000 12,000 0 C Schooner's Bay Lift Station PU1009 12,972 11,909 1,063 C Stewart Street Lift Station PU1010 17,190 2,187 15,003 I Selva Norte Lift Station PU1011 5,318 5,262 56 C Hydroscreen Replacement PU1012 6,000 0 6,000 Concrete to GRIT Container PU1013 8,500 0 8,500 Tank Rehab - Water Plant 4 PU1014 19,580 0 19,580 I Donner Subdivision Sewer Rehabilitation PU1015 178,000 0 178,000 Subtotal 6,439,843 1,282,996 5,156,847 • Public Works: Riverbranch Preserve PM0804 74,804 22,209 52,595 E Tennis Courts at Donner Community Center PM0905 13,354 4,912 8,442 C Howell Park Bridge #5 PM0908 8,500 8,500 0 C Howell Park Bridge Replacement PM1001 20,000 9,500 10,500 I Jordan Park - Drainage & Parking PM1002 30,000 0 30,000 Jordan Park - Water Fountain PM1003 5,000 0 . 5,000 I Jordan Park - Covered Shelter PM1004 25,000 0 25,000 I Roof at Donner Park Community Center PM1005 50,000 0 50,000 R Veteran's Park - Flag & Pavilion PM1006 10,196 10,196 0 C Donner Park - Accessory Building PM 1007 57,241 52,780 4,461 C Dog Park - Hopkins Creek PM1008 20,800 0 20,800 Skate Park Lights PM1009 16,000 0 16,000 Royal Palms Design PW0808 37,026 33,162 3,864 I Royal Palms Stormwater Project PW0905 3,162,257 1,798,280 1,363,977 I Sidewalk - Dutton Island Road & Donner Park PW1001 43,732 14,247 29,485 I Sidewalk/Curb Replacement - FY 2010 PW1002 25,000 1,988 23,012 I Manhole - Saturiba & Seminole Road • PW1003 15,000 0 15,000 Subtotal 3,613,910 1,955,774 1,658,136 Total $10,489,541 $3,259,398 $7,230,143 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 AGENDA ITEM # 4A AUGUST 23, 2010 City of Atlantic Beach, FI. Utility Sales Report IIIIIIIIIII 2010 July 2009 Gallons Actual Revenue Gallons Actual Revenue Water Sales Accounts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per 1,000 gl Atlantic Beach 5,663 51,673 $187,825 $3.63 5,615 43,202 $137,132 $3.17 Buccaneer 2,442 22,717 $95,226 $4.19 2,494 21,532 $77,889 $3.62 Total Water Sales 8,105 74,390 $283,052 $3.80 8,109 64,734 $215,021 $3.32 Gallons Gallons Water Plant Production 0000 0000 Atlantic Beach 63,960 53,322 Buccaneer 19,736 19,892 Total Production 83,696 73,214 Total Water Billed 74,390 64,734 Water Loss for month: 9,306 8,480 Percentage Loss 11.12% 11.58% Total 12 mo. Avg. Loss 15.83% 12.59% Gallons Actual Revenue Gallons Actual Revenue Sewer Sales Accounts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per 1,000 gl Atlantic Beach 5,132 37,240 $245,615 $6.60 5,148 34,996 $205,596 $5.87 Buccaneer 2,306 20,239 $169,545 $8.38 ' 2,367 20,006 $152,330 $7.61 Total Sewer Sales 7,438 57,479 $415,160 $7.22 7,515 55,002 $357,926 $6.51 111111111111111111111111 IIIIIIIIIIIIIIIIIIIIII Gallons Actual Revenue Gallons Actual Revenue Sewer Treatment 0000 Revenue Per 1,000 gi 0000 Revenue Per 1,000 gi Atlantic Beach 45.946 $245,615 $5.35 54.933 $205,596 $3.74 Buccaneer 16.957 $169,545 $10.00 18.890 $152,330 $8.06 Total Sewer Treated 62.903 $415,160 $6.60 73.823 $357,926 $4.85 AGENDA ITEM # 4A AUGUST 23, 2010 O o O "p ++ a G i, p b 5 c w Aa ° o o 5 ° v '� di C rn O> • ezt �' ; p O 6 C p p u U cu 42; p G) C .G = V U N O O O .O z z 0.o •.-. °•y o o u 5= a 0 o G z a) ).. a e si L o ° o Ow . m 0 -0 w �0 0 '° •5 0 = o° as o • 8 � '' c„ on i i a • ° ' E b a " ° a) cps `� o , a o u o � � a as U p u� ta, . O .-y I:4 MI A O U d u b w .o Uc..p„N p �� Uo a o.) a • a > � �' C F` ++ l, u'� a� o�° a a ui ..0 .1- °w a ,7 .a O o 4 a 0 •� 40 a M =11 y N .0 O F 11 ° c c 0. $,. a o . ae o 3 a ,, c4:•: . i o a $. � 0 o W > o O O a ,E, W � 0 w b °� o u a a a) b 4 ... O O W o o A A -C o 0 OA a, G) • ' V an z • ° �A o��` ° cuiQ o c a) > a (-+ 0 VI V ._ N • m r , 4? 0 m O \ 01 C . o C V Q U vi V Go a U F-. 0� N �, , .,, o 4 � M w 3 C ,0 w , 0 ° c WW a 1 - 0 y G) O N O. u Cr 0 0 N N O p O O '+-, O O � O W CA 0 01) Ur,¢4 1..rx U.- t) (I) 0 o U ° co a 4 E* r.r 0 F- FF d I. v) z ° o o f 0 Z oo F ce u H 0 c ° z U H oA ; 3 a W o °' © N . � o Cil �a O 0 o U a U x 0 4 Z • to � W OA .� :: c U � a E CO o 4), 0:1 . � `" a . .. x a Z o CA�a II U d o 2 II § u =.9 u z ti i4 G24 ti II �� a - o w 0 11. II w w r. w �. ,., F t=1 Q > QU AU U AU 0 o. .� �. `. ...., .� .� a F c4 z o e . E \ ° o g o ll ° e on e 0 0 3 U ZO o o \° G j II II 4 E O I . o\° ce e .3 W a - O b G) of ti '1 .� 0) Z Q o 3 c c k. Q v c4 II o 2 w a. 0 , - 1 E % q cl 0., ? • 6�0 �Z • A a ., aL U E--. C 3 Q U vn Q U a a u A N M eF V)