The URL can be used to link to this page

Agenda Item 4AAGENDA ITEM # 4A APRIL 25, 2011 City of Atlantic Beach, Fl. Utility Sales Report N March 2011 March 2010 M. ,br- ,.., Gallons Actual Revenue W Gallons Actual Revenue Water Sales rjAccounts 0000 Revenue Per 1,000 gi "' Accounts 0000 Revenue Per 1,00o gi Atlantic Beach z j 5 32,149 $122,869 $3.82 5,573 31,918 $122,782 $3.85 Buccaneer 2,452 16,936 $80,720 $4.77 2,461 18,071 $81,423 $4.51 Total Water Sales p 7,950 49,085 $203,589 $4.15 8,034 49,989 $204,205 $4.08 y Gallons Gallons Water Plant Production 0000 0000 r Atlantic Beach { a 52,057 50,873 Buccaneer Total Production r , 18,854 70,911 ,1' 15,333 66,206 r K Total Water Billed a 49,085 PEI 49,989 Water Loss for month: 21,826 16,217 z Percentage Loss 30.78% 24.49% Mill k Total 12 mo. Avg. Loss 14.85% UH 14.19% 3 � i .,. "...- ._.. ". ..<, ..., ., .....� �. .. i ,,,...+.., .._' -^a .. P.., `L: o -.., ,., . .. .. ... ......: r, m ",'�„. '�'� ,. .., ,. ,-, r.. -rte .. •, e o-. .�...... n . , ,. Gallons Actual Revenue Gallons Actual Revenue q Sewer Sales V ccoun ts 0000 Revenue Per 1 ,000 gi Accounts 0000 Revenue Per 1,000 gi Atlantic Beach 5,094 28,045 $219,017 $7.81 5,111 27,950 $201,239 $7.20 Buccaneer 2,359 17,643 $169,651 $9.62 2,333 16,984 $153,317 $9.03 Total Sewer Sales 7,453 45,688 $388,669 $8.51 � 7,444 44,934 $354,556 $7.89 Gallons Actual Revenue p Gallons Actual Revenue Sewer Treatment 0000 Revenue Per 1,000 gi 0000 Revenue Per 1,000 gi Atlantic Beach 43,529 $219,017 $5.03 € 46.942 $201,239 $4.29 Buccaneer 9 16.795 $169,651 $10.10 17.210 $153,317 $8.91 Total Sewer Treated 60.324 $388,669 $6.44 64.152 $354,556 $5.53 a AN City of Atlantic Beach FINANCIAL REPORT MARCH 2011 AGENDA ITEM # 4A APRIL 25, 2011 Cash Balances Prior Current Dollar Fund(s) 02/28/11 03/31/11 Change General $6,998,366 $6,633,026 ($365,340) Tree Replacement 3,989 3,989 0 Convention Development Tax 50,751 50,858 107 Local Option Gas Tax 9,889 15,827 5,938 Better Jax 1/2 Cent Sales Tax 287,906 265,512 (22,394) Police Training, Forfeiture, Grants, etc. 149,691 139,157 (10,534) Community Development Block Grant 0 0 0 Debt Service 35,826 41,617 5,791 Capital Projects 2,048,407 2,036,561 (11,846) Utility 4,187,113 3,881,942 (305,171) Sanitation 663,369 684,602 21,233 Building Code Enforcement 45,095 45,653 558 Storm Water 1,542,851 1,492,996 (49,855) Pension - Police 13,221 53,129 39,908 Pension - General 148,496 46,192 (102,304) Investments - Unallocated Gains (Losses) (301,152) (331,088) (29,936) Total $15,883,818 $15,059,973 ($823,845) 15,059,973 (823,845) Total Restricted Cash $7,591,323 Total Unrestricted Cash Rate of $7,468,650 Cash and Investments Account Prior 02/28/11 Current 03/31/11 Dollar Interest Change Rate Bank of America - Depository $4,496,159 $3,665,408 ($830,751) 0.300% Federal National Mortgage Association Bonds 2,008,588 2,007,434 (1,154) 4.300%(l) US Treasury Notes 1,134,563 1,132,273 (2,290) 4.625%(l) US Treasury Notes 2,062,484 2,063,392 908 3.625%(l) Federal Farm Credit Bank Consolidated Bonds 1,125,058 1,126,461 1,403 4.875%(l) Federal Home Loan Bank Consolidated Bonds 1,017,354 1,019,817 2,463 4.300%(1) Pimco Mutual Fund 1,971,994 1,995,849 23,855 2.054%(1) Putnam US Government Mutual Fund 2,014,529 2,036,497 21,968 5.076%(l) MorganStanley SmithBarney Cash 49,856 9,605 (40,251) 0.000% SBA - Florida Prime 283 287 4 0.270% Cash on Hand 2,950 2,950 0 N/A Subtotal 15,883,818 15,059,973 (823,845) Rate of Return Police Pension Investments 6,596,229 6,576,046 (20,183) 0.430% General Pension Investments 11,486,421 11,700,397 213,976 0.360% Subtotal 18,082,650 18,276,443 193,793 Total $33,966,468 $33,336,416 ($630,052) (1) Fiscal year to date rate of return is (1.7 %) City of Atlantic Beach FINANCIAL REPORT MARCH 2011 Revenues AGENDA ITEM # 4A APRIL 25, 2011 Annual YTD - 50% YTD Dollar Percent Fund / (Footnote) Estimate of Estimate Actual Variance Variance General (1) & (3) $11,515,549 $5,757,775 $7,782,857 $2,025,082 35.17% Convention Development Tax 192,857 96,429 34,917 (61,512) - 63.79% Local Option Gas Tax 463,523 231,762 225,516 (6,246) -2.70% Better Jax 1/2 Ct Sales Tax 658,424 329,212 316,344 (12,868) -3.91% Police Training, Forfeiture & Grants, etc. 185,917 92,959 154,324 61,365 66.01% Grants (2) 647,352 323,677 15,230 (308,447) - 95.29% Debt Service 68,650 34,325 34,550 225 0.66% Capital Projects 903,000 451,500 516,586 65,086 14.42% Utility (3) 19,061,825 9,530,913 5,626,347 (3,904,566) - 40.97% Sanitation 1,837,500 918,750 907,772 (10,978) -1.19% Building Code Enforcement 317,850 158,925 145,883 (13,042) -8.21% Storm Water 669,124 334,562 345,156 10,594 3.17% Pension - Police (4) 964,726 482,363 769,929 287,566 59.62% Pension - General (4) 1,522,969 1 761,485 1,654,228 892,743 117.24% Total $39,009,266 $19,504,637 $18,529,639 Analysis of Major Variances (1) The $2,025,082 positive variance in the General Fund resulted from having received 89.4% of the budgeted property taxes. Typically the majority of these taxes are received from the City of Jacksonville in December & January. Also, the TMDL related transfer of $892,560 from the Utility System Debt Service Fund was done due to the receipt of loan proceeds. (2) The $308,447 negative variance in the Grant Funds resulted from not having any expenditures fiscal year to date. All of these grants receive revenues when the related expenditures are made on the projects and a reimbursement request is filed with the granting agency. (3) The $3,904,566 negative variance in the Utility Funds resulted from not having received the budgeted fiscal year to date proceeds from the Bank - Qualified Loan. Partial receipt of the loan proceeds was received in December, 2010. The City will receive additional loan proceeds as needed when the related expenditures are made on the project. If the loan was not included in this calculation, the variance would be a positive 2.02 %. (4) The $287,566 positive variance in the Police Employee Pension Fund & the $892,743 positive variance in the General Employee Pension Fund resulted from changes in market values of the investments. City of Atlantic Beach FINANCIAL REPORT MARCH 2011 AGENDA ITEM # 4A APRIL 25, 2011 Expenses Department I (Footnote) Governing Body City Administration General Government Planning and Building Public Safety (1) Recreation and Special Events Public Works Public Utilities (2) & (4) Pension - Police Pension - General Total Annual Estimate YTD - 50% of Estimate YTD Actual Dollar Variance Percent Variance $42,260 $21,130 $21,054 $76 0.36% 2,465,322 1,232,663 1,210,786 21,877 1.77% 914,780 457,391 273,050 184,341 40.30% 531,131 265,566 225,190 40,376 15.20% 6,135,392 3,067,698 2,694,287 373,411 12.17% 392,160 196,080 200,149 (4,069) -2.08% 6,752,937 3,376,471 3,201,962 174,509 5.17% 19,711,651 9,855,826 6,680,321 3,175,505 32.22% 548,977 274,489 276,584 (2,095) -0.76% 555,445 277,723 325,479 (47,756) - 17.20% $38,050,055 $19,025,037 $15 $3,916,175 Resource Allocation Personal Services Operating Expenses (1) & (3) Capital Outlay (1) & (2) Debt Service (4) Transfers (5) Total Annual YTD - 50% YTD Dollar Percent Estimate of Estimate Actual Variance Variance $9,433,359 $4,716,680 $4,269,558 $447,122 9.48% 10,155,798 5,077,899 4,749,784 328,115 6.46% 13,872,485 6,936,251 3,088,443 3,847,808 55.47% 2,137,906 1,068,953 1,329,542 (260,589) - 24.38% 2,450,507 1 225 254 1,671,535 (446,281) - 36.42% $38,050,055 $19,025,037 $15,108,862 $3,916,175 Analysis of Major Variances (1)The positive variance in the Public Safety Funds resulted from: open positions in the Patrol division, the seasonality of the Lifeguards, and limited activity on the Public Safety Building — see Project Activity Schedule. (2)The positive variance in the Public Utilities department resulted from limited activity on the various projects funded from this source — see Project Activity Schedule. (3)The positive variance in the Operating Expenses is partially due to: only 5 of 6 monthly payments have been paid on the First Vehicle contract; no monies have been spent on the Stormwater Master Plan and only 46.4% of the budget for professional & contractual services has been spent City wide. (4)The negative variance in the Debt Service Accounts resulted from the October and December payment of principal and interest on the Utility Revenue Bonds. (5)The positive variance in the Transfer Accounts resulted from the TMDL related transfer from the Utility System Debt Service Fund to the General Fund due to the receipt of loan proceeds. The accounts are now 98% of the budgeted amounts. City of Atlantic Beach FINANCIAL REPORT MARCH 2011 Project Activity - Current Year Activi Only AGENDA ITEM # 4A APRIL 25, 2011 Project YTD YTD Project Name Number Budget Actual Balance Status Public Safety I - Project In- progress B - Bid Awarded N - Complete /Non - Capital C - Project Completed Lifeguard Building Roof Replacement LG0901 8,000 0 8,000 Police Building Renovation /Design /Construction PS0504 421,297 113,271 308,026 429,297 113,271 316,026 Public Utilities: Replace Well at Water Plant #1 PUO304 287,018 194,757 92,261 TMDL - WWTP #1 Design PU0905 91,276 91,204 72 TMDL - Lift Station /Main Transfer Flow PU0906 1,708,740 1,250,835 457,905 Elevated Tank - Water Plant #1 PU1001 1,688 0 1,688 Ground Storage Tank Rehab - Water Plant #1 PU1002 44,340 44,340 0 Collection System Inspection & Rehab PU1004 42,836 27,789 15,047 Mimosa Cove Lift Station Upgrades PU1005 61,590 44,078 17,512 Lift Station E Upgrades PU1006 48,183 48,183 0 Tank Rehab - Water Plant #4 PU1014 814 0 814 Well Rehab - Well # 1 @ Water Plant #1 PU1101 50,000 0 50,000 Elevated Tank Rehab - Water Plant #2 PU1102 15,000 0 15,000 Ground Storage Tank Rehab - Water Plant #4 PU1103 40,000 0 40,000 Replace 2" Water Main -11th Street PU1104 120,000 3,750 116,250 Sewer Rehab - Sea Oats Drive PU1105 300,000 0 300,000 TMDL Upgrade /Construction - WWTP #1 PU1106 5,693,230 412,983 5,280,247 Valve Replacement - Davco & Clarifier PU1107 35,000 0 35,000 Replace Equipment- PW Yard Station PU1108 30,000 0 30,000 Plant Improvements - Master Plan PU1109 469,000 0 469,000 TMDL Sludge /Odor Improvements PU1110 241,414 44,937 196,477 Subtotal 9,280,129 2,162,856 7,117,273 Public Works: Riverbranch Preserve - Kayak & Canoe Launch PM0804 196,306 5,465 190,841 Howell Park Bridge Replacement PM1001 20,000 0 20,000 Veteran's Park- Flag & Pavilion PM1006 72,063 71,576 487 Dog Park - Hopkins Creek PM1008 27,800 18,578 9,222 Gate at Dutton Island PM1101 20,000 0 20,000 Lighting - Basketball Court PM1102 22,000 0 22,000 Lighting - Security at Community Center PM1103 20,188 0 20,188 Sod - Baseball Field PM1104 32,000 0 32,000 Sod - South End of Soccer Field PM 1105 20,000 0 20,000 Parking - Paved PM1106 36,975 0 36,975 Water Fountain - Russell Park PM1107 5,000 0 5,000 Veteran's Park - Phase II - Stage PM1108 50,000 1,000 49,000 Royal Palms Design PW0808 3,294 3,294 (0) Royal Palms Stormwater Project PW0905 580,405 507,129 73,276 Bulkhead - Ditch @ Cavalla PW1005 9,472 9,472 0 Sidewalk & Curb Replacement PW1101 25,000 11,952 13,048 Drain Line - Atlantic Blvd /East Coast Dr /Ahern St PW1102 50,000 0 50,000 Subtotal 1,190,503 628,466 562,037 Total $10,899,929 $2,904,593 $7,995,336 Status Key E C C I C E 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 ff 6 -dp W" w TI �;'V A IA 1 v, z .'- P 177 "I OTIIMMM M �r � x ■ I =7 77 1=1 Ti M, RV r 71i 2 �Tf '1-- 37, 0 ft m i m e J� F I R 4r %r AGENDA ITEM # 4A APRIL 25, 2011 �O bA Cdd sz % .7r it _ O O rA V a p 9 O G ^C p .. u O'�� Utina, b on o C d p �p O p bD ac Cd cd o O p° M '� * % .2 b 8 CD o v E p bU...N A 0 N _ C'C v a p i. G) cd Cd o ' 0 i ion o o� �.°�... o 17 oS �A o0�. ° o ° ' -U4° as � r" ti w uo v to w U w a3 a � uo c P-4 rA rA a Wa 0 00 rA rA V rA 00 z (~ Q' 0 o to b U H to a V E ' N p O bq U °>~° (~ v N '� rn cn o� 94 0 o � ° �� w to x �, r . w�� w � o '" o o ox x x 3 w � ; ,;� :; 3 x =3 , rA +� cd 00 pGC1a o ti SAG °o' 2Aa z zaciu rA Ud�q -� II pll o on a z w " "x� ti II HS a4 w c7 14 ;::z a wQM dd II U II II w II II �,� w II II ��.•� w II II �,�w II 11 �.�w a Quu Q Quu QU U C)U u QpU QUP H Flo o o � � \ o N Cd tb tm W o II •� II .o U z O to a II p,, ° o0 0 Cd o G o o '" °�° F LT u a Q 3 °'•sue o � q � u � � II ° � \ u ° o �\ a �\ u o U o � a� cd Z st •� � ° W F , cd � � �3 .� � � � o � � � � �3 II � i Q a II v ti ca � v v� •T, �, •° >, ry a c�c�Iz,U H ��w � q U q U �'n U QqU c�qU a u N M d kn �p AGENDA ITEM # 4A APRIL 25, 2011 O -� r-� U � � w 0 .a � W W PC p .. .. Z O U , H ¢ soN U 1.4 d S z a.a Wo 0 A w n ^' o H bCA U cn m U ii ii u u C7 a a o w a AUU E1UU U U a � 0 PC P C I� � pq •� y A � � U z w d q I R 4 PC .b cn V b ° 0 •o C7 W >~ C s. .� • Cf .d b e;; C x. PC tw ,� . ti o a Z U y 7 0 c � � t�. y b C%1 V q a to 1U SAG A u •o 0 u