The URL can be used to link to this page

Agenda Item 4ACity of Atlantic Beach AGENDA ITEM # 4A FINANCIAL REPORT FEBRUARY 27, 2012 JANUARY 2012 Cash Balances Prior Current Dollar Fund(s) 12/31/11 01/31/12 Change General $7,749,974 $7,474,724 ($275,250) Tree Replacement 3,509 3,509 0 Convention Development Tax 23,881 17,791 (6,090) Local Option Gas Tax 141,091 164,215 23,124 Better Jax 1/2 Cent Sales Tax 138,755 126,698 (12,057) Police Training, Forfeiture, Grants, etc. 137,446 132,070 (5,376) Community Development Block & ARRA Grants (76,934) (86,431) (9,497) Debt Service 23,204 28,973 5,769 Capital Projects 2,347,268 2,376,845 29,577 Utility 3,666,805 5,108,570 1,441,765 Sanitation 678,086 677,781 (305) Building Code Enforcement 29,096 27,058 (2,038) Storm Water 1,072,764 1,082,594 9,830 Pension - Police 38,313 41,279 2,966 Pension - General 154,439 47,904 (106,535) Investments - Unallocated Gains (Losses) (90,762) 140,600 231,362 Total $16,036,935 $17,364,180 $1,327,245 0 0.31% Total Restricted Cash 2,950 $7,943,436 0 N/A Total Unrestricted Cash $9,420,744 17,364,180 Total $33,632,828 $35,839,504 $2,206,676 (1) 30 day SEC Yield as of 01/31/12 (2) Rate of return as of 01/31/12 Cash and Investments Prior Current Dollar Interest Account 12/31/11 01/31/12 Change Rate Bank of America - Depository $5,846,613 $6,020,215 $173,602 0.25% Eaton Vance Government Obligation Fund 4,019,156 4,021,893 2,737 2.38%(l) Loomis Sayles Limited Term Government & Agency Fund 2,005,525 2,019,738 14,213 1.55%(l) Delaware Corporate Bond Fund 1,019,964 1,048,538 28,574 4.13%(l) Loomis Sayles Investment Grade Bond Fund 998,877 1,033,177 34,300 3.18%(l) Lord Abbett Income Fund 1,007,900 1,036,485 28,585 3.99%(l) Goldman Sachs Inflation Protected Secs Fund 1,135,673 2,180,907 1,045,234 1.00% (1) MorganStanley SmithBarney AA Money Trust 0 0 0 0.01% SBA - Florida Prime 277 277 0 0.31% Cash on Hand 2,950 2,950 0 N/A Subtotal 16,036,935 17,364,180 1,327,245 Rate of Return Police Pension Investments 6,466,413 6,698,142 231,729 3.58%(2) General Pension Investments 11,129,480 11,777,182 647,702 4.39%(2) Subtotal 17,595,893 18,475,324 879,431 Total $33,632,828 $35,839,504 $2,206,676 (1) 30 day SEC Yield as of 01/31/12 (2) Rate of return as of 01/31/12 City of Atlantic Beach AGENDA ITEM# 4A FINANCIAL REPORT FEBRUARY 27, 2012 JANUARY 2012 Revenues Fund / (Footnote) Annual Estimate YTD - 33% of Estimate YTD Actual Dollar Variance Percent Variance General (1) $10,964,642 $3,651,226 $5,703,884 $2,052,658 56.22% Convention Development Tax 72,000 23,976 88,906 64,930 270,81% Local Option Gas Tax 472,612 157,380 143,334 (14,046) -8.92% Better Jax 1/2 Ct Sales Tax 646,212 215,189 202,936 (12,253) -5.69% Police Training, Forfeiture & Grants, etc. 138,796 46,219 49,737 3,518 7.61% Grants 318,214 105,966 44,789 (61,177) - 57.73% Debt Service 71,300 23,743 24,303 560 2.36% Capital Projects (2) 2,255,737 751,160 175,518 (575,642) - 76.63% Utility (3) 8,368,949 2,786,861 5,172,548 2,385,687 85.60% Sanitation 1,804,500 600,899 588,243 (12,656) -2.11% Building Code Enforcement 265,900 88,545 68,908 (19,637) - 22.18% Storm Water 972,200 323,743 315,791 (7,952) -2.46% Pension - Police (4) 1,232,311 410,360 772,714 362,354 88.30% Pension - General (4) 2,122,019 1 706,632 1,622,208 915,576 129.57% Total $29,705,392 $9,891,899 $14,973,819 Analysis of Major Variances (1) The $2,052,658 positive variance in the General Fund resulted from having received 52% of the budgeted property taxes. Typically the majority of the property taxes are received from the City of Jacksonville in December & January (2) The $575,642 negative variance in the Capital Projects Funds resulted from not having received the proceeds from the proposed loan for the new Public Safety building. If the loan was not included in this calculation, the variance would be a positive 1.2 %. (3) The $2,385,687 positive variance in the Utility Funds resulted from receiving proceeds from the State Revolving Fund Loan for the sewer plant improvements. If the loan was not included in this calculation, the variance would be a positive 4 %. (4) The $362,354 positive variance in the Police Employee Pension Fund & the $915,576 positive variance in the General Employee Pension Fund resulted from changes in market values of the investments. City of Atlantic Beach FINANCIAL REPORT AGENDA ITEM #4A JANUARY 2012 FEBRUARY 27, 2012 Expenses Analysis of Major Variances (1) The positive variance in the Public Safety divisions resulted from no expenditures fiscal year to date on the Police Building — see Project Activity Schedule. The variance without the budget for the Police Building is a positive 6.5 %. (2) The negative variance in the Public Utilities department resulted from the October payment of principal and interest on the Utility Revenue Bonds and the State Revolving Fund Loan. If the Debt Service payments were not included in this calculation, the variance would be a negative 4.6 %. (3) The positive variance in the Personnel Services resulted from vacant positions that have not been filled. The current vacancies include the following departments: Planning & Zoning, Painters, City Manager, Police Patrol & Lifeguards. The Lifeguards are typically seasonal employees working May through September. Annual YTD - 33% YTD Dollar Percent Department / (Footnote) Estimate of Estimate Actual Variance Variance Governing Body $41,986 $13,981 $14,664 ($683) -4.89% City Administration 2,660,587 885,977 812,947 73,030 8.24% General Government 778,668 259,297 260,670 (1,373) -0.53% Planning and Building 478,867 159,462 143,476 15,986 10.02% Public Safety (1) 10,064,396 3,351,445 1,658,598 1,692,847 50.51% Recreation and Special Events 394,207 131,271 152,489 (21,218) - 16.16% Public Works 6,005,918 1,999,971 1,765,149 234,822 11.74% Public Utilities (2) 14,271,501 4,752,409 5,488,895 (736,486) - 15.50% Pension - Police 587,832 195,748 210,459 (14,711) -7.52% Pension - General 740,710 246,656 245,999 657 0.27% Total $36,024,672 $11,996,217 $10,753,346 $1,242,871 Annual YTD - 33% YTD Dollar Percent Resource Allocation Estimate of Estimate Actual Variance Variance Personnel Services (3) $9,854,955 $3,281,699 $3,018,485 $263,214 8.02% Operating Expenses (1) 10,366,582 3,452,072 3,327,884 124,188 3.60% Capital Outlay (1) 11,847,280 3,945,146 2,432,484 1,512,662 38.34% Debt Service (2) 2,297,807 765,170 1,421,809 (656,639) - 85.82% Transfers 1,658,048 552,130 552,684 (554) -0.10% Total $36,024,672 $11,996,217 $10,753,346 $1,242,871 Analysis of Major Variances (1) The positive variance in the Public Safety divisions resulted from no expenditures fiscal year to date on the Police Building — see Project Activity Schedule. The variance without the budget for the Police Building is a positive 6.5 %. (2) The negative variance in the Public Utilities department resulted from the October payment of principal and interest on the Utility Revenue Bonds and the State Revolving Fund Loan. If the Debt Service payments were not included in this calculation, the variance would be a negative 4.6 %. (3) The positive variance in the Personnel Services resulted from vacant positions that have not been filled. The current vacancies include the following departments: Planning & Zoning, Painters, City Manager, Police Patrol & Lifeguards. The Lifeguards are typically seasonal employees working May through September. City of Atlantic Beach FINANCIAL REPORT JANUARY 2012 Project Activity - Curren Year Activity Only AGENDA ITEM # 4A FEBRUARY 27, 2012 Project Name Project Number Budget YTD YTD Actual Balance Status Public Safety Retrofit HVAC Systems GG1201 190,414 0 190,414 Lifeguard Building Roof Replacement LG0901 4,750 0 4,750 Police Building Renovation /Design /Construction PS0504 4,432,582 0 4,432,582 4,627,746 0 4,627,746 Public Utilities: TMDL - Lift Station /Main Transfer Flow PU0906 72,810 20,623 52,187 Donner Subdivision Sewer Rehabilitation PU1015 175,590 173,813 1,777 Replace 2" Water Main - 11th Street PU1104 61,283 43,355 17,928 TMDL Upgrade /Construction - WWTP #1 PU 1106 3,218,851 1,774,600 1,444,251 TMDL Sludge /Odor Improvements PU1110 2,392,784 280,131 2,112,653 Elevated Tank #1 - Internal Rehabilitation PU1201 40,000 0 40,000 Ground Storage Tank WP #2 - Interior Rehabilitation PU1202 40,000 0 40,000 Ground Storage Tanks WP #3 - Recoat Interior PU1203 60,000 0 60,000 Water Main - 12th Street at Ocean Blvd /Beach Ave PU1204 60,000 0 60,000 Water Main - 14th & 15th Street at Ocean Boulevard PU1205 140,000 0 140,000 Sewer Rehabilitation - Area B PU1206 300,000 0 300,000 Subtotal 6,561,318 2,292,522 4,268,796 Public Works: Riverbranch Preserve - Kayak & Canoe Launch PM0804 16,113 14,906 1,207 Lighted Parking - Donner Park PM1106 35,090 0 35,090 Security Cameras - Donner Park PM1109 1,000 0 1,000 Veteran's Park - Phase II - Memorial Garden PM1110 2,632 0 2,632 Howell Park Bridge Replacement PM1201 25,000 0 25,000 Bull Park Playground Equipment Replacement PM1202 40,000 0 40,000 Sidewalk & Curb Replacement PW1101 5,406 5,406 0 Sidewalk & Curb Replacement PW1201 25,000 5,345 19,655 East Coast Drive Drainage Improvements PW1202 50,000 0 50,000 Subtotal 200,241 25,657 174,584 Total $11,389,305 $2,318,179 $9,071,126 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 E E C I. 7- .' -!'•T. �'+��., IFS '�ir� {�..'a _..�.�,� ' � -- - 5- �...i.�� I lk � y "i 1 �� Y� i f + iir ■ � i�v. rH. Uli. �-� _ _ �. `h: -11 7 ice. s' -- . r ff :� -�� • - " "4 RJff t 1 -- — _ - - -- ftk m—mmmm - i bpycTF, '� ♦l-3cgc, A �� – _ — {}! �� •ur,, w r-- .•1 x, " - P t4�Y5m -' v.. _ _ ., _ — i r••r�.x I 1- ra { _ _ .4:J'xrt1�'r � 77T bYef�fr - r WE I L I 1r�I1' l ` iL� ii�4�.1.' - — - - -- -- �I r te — �.: - - — � �x4�,T,' L W= w it Fi..t= saA.�r I. ,I •__-_- tom= __ _- __ .-.. �:�� _��r -4m 4w AGENDA ITEM # 4A FEBRUARY 27, 2012 City of Atlantic Beach, Fl. Utility Sales Report w Januar 2012 January 2 011 Gallons Actual Revenue > Gallons Actual Revenue e Water Sales . Accounts 0000 Revenue Per 1 ,000 gt Accounts 0000 Revenue Per 1 ,000 gi Atlantic Beach I 5 35,415 $133,460 $3.77 5,566 38,172 $143,191 $3.75 Buccaneer 2,444 16,108 $88,847 $5.52 2,441 15,365 $81,124 $5.28 Total Water Sales 8,027 51,523 $222,307 $4.31 - 8,007 53,537 $224,315 $4.19 r Gallons Gallons Water Plant Production 0000 0000 Atlantic Beach 19 Buccaneer 45,004 19,133 39,683 24,198 Total Production 64,137 63,881 Total Water Billed A 51,523 53,537 Water Loss for month: 12,614 10,344 Percentage Loss 19.67% 16.19% Total 12 mo. Avg. Loss 17.59% 15.61% t �� -»� w I'Accounts Gallons Actual Revenue Gallons Actual Revenue Sewer Sales 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per 1,000 gi O F $7.63 5,094 30,905 $234,298 $7.58 Atlantic Beach 5,158 29,702 $226,636 Buccaneer 2,340 17,941 $173,299 $9.661, 2,324 17,062 $168,588 $9.88' Total Sewer Sales 7,498 47,643 $399,935 $8.39 N 7,418 47,967 $402,886 $8.40 Gallons Actual Revenue F , Gallons Actual Revenue Sewer Treatment 0000 Revenue Per 1,000 gi 0000 Revenue Per 1,000 g L Atlantic Beach 42392 $226,636 $5.35 42.237 $234,298 $5.55 Buccaneer 18.317 $173,299 $9.46` 18.290 $168,588 $9.22 60.709 $399,935 $6.59 ` 60.527 $402,886 $6.66 Total Sewer Treated AGENDA ITEM # 4A FEBRUARY 27, 2012 PREPARED 2/21/12,-8:21:53 LICENSE ACTIVITY REPORT BY BUSINESS NAME City of Atlantic Beach ALL LICENSES NEW LICENSES FOR YEAR: 2012 BETWEEN: 01/01/12 TO 01/31/12 PROGRAM OL122L DEPT: ALL DEPARTMENTS CLASS: ALL CLASSES -- - - - - -- --- r------------ --------------------- LIC # -------------------------------------------------------------------------------------------------- BUSINESS NAME ISSUED TYPE CLASSIFICATION 12- 00007085 BURRITO CANTINA ;INC 1/19/12 TRN RESTAURANTS(INC. SNACK BARS & TAKE O 12- 00007486 r BURRITO CANTINA INC 1/19/12 NEW FISH /SEAFOOD MARKET 12- 00007484 CARLOS EARL HOBBS JANITORIAL 1/19/12 NEW CLEANING /JANITORIAL /MAID SERVICE 12- 00007488 CATE LEWIS 1/25/12 NEW RENTALS: OTHER THAN LISTED 12- 00004644 GERALD BENNETT & D.J.CHANEY SV 1/19/12 RNW AUTO: SERVICE /REPAIR 12- 00007483 GREEN FROG ENTERPRISES 1/19/12 NEW LAWN /YARD SERVICE 12- 00005396 LORRAINE MILLSPAUGH ART DESIGN 1/19/12 RNW MISC. SERVICE ESTABLISHMENT, NOT LIS 12- 00007034 MPG AUTOMOTIVE PERFORMANCE,INC 1/19/12 RNW AUTO PARTS /SUPPLIES 12- 00007035 MPG AUTOMOTIVE PERFORMANCE,INC 1/19/12 RNW AUTO: SERVICE /REPAIR 12- 00007481 NANCY C HARRISON, ESQ.,P.L. 1/19/12 NEW ATTORNEY FIRM /CORPORATION 12- 00007482 NANCY C HARRISON, ESQ.,P.L. 1/19/12 NEW ATTORNEY 12- 00007489 PAULA DRAKE DEAN INSURANCE INC 1/30/12 TRN INSURANCE AGENCY 12- 00007490 PAULA DRAKE DEAN INSURANCE INC 1/30/12 NEW INSURANCE AGENT 12- 00005916 STOVALL ENT.INC- SUBWAY #832 1/18/12 RNW RESTAURANTS(INC. SNACK BAAS & TAKE O 12- 00007487 THE HOME PLATE DINER 1/24/12 NEW RESTAURANTS(INC. SNACK BARS & TAKE O GRAND TOTALS -------- - - - - -- NEW LICENSES AC: 8 PP: 0 IN: 0 VO: 0 PG: 0 BR: 0 OB: 0 UC: 0 LIC: 8