No preview available
 /
     
Item 4A AGENDA ITEM # 4A FEBRUARY 26, 2007 ti ~ o Z N~ o o ~ ti o 0 0 ~ O [] r ~ Q r M N N r r ~ O ~ W d ~ a H J v ~ J v J Q O o M ? JN~ ~~ f~ W Z W ~ ? Z H ~Qr, z aQ V ~ ~ = w o OF ~ ~. U W W ~ ~ m U W d ~ F -- ~ O o 0 0 0 0 0 0 0 0 0 o 0 Z 0 ~ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a Z o 1~ O o O o O o O ~ ao ~ c~ o V o o a o iA o fA o fR o ~ o ~ o fR a tf? a iA o fA o tf1 o iA o fR o E9 o 1A o fi? o fA ~ W A/ I` O I` O OOSA F- Nti O O 1~ O 0 Q1 1~ 1+ 0 Y> W O > > P O O 1~ O O Q~ N r ~ O o ii O 0 a Q M N 000 N ~ ti ~ Q M N O00 N t~R ~ ~ ~' N N ~ s 's ~' ~ ~' ~ z ~' ~ ~ ~ ~ ~ , Q ~ , ~ U > > O = ~p ~ Z U 0 0 0 0 0 0 0 ~ 0 0 O 0 0 N 0 0 7 a O a - ~ 00 ~ per 0 c~ ti 1 O ts N r• Y r N N ~ LL ~oo ~Nr ~ ti ~ , ti O J ~ O Z Q M o ~~ N ~ 1p ~ r ~, M N = a ~ 1- Z W Z O O O o o o a O o o ~ 0 o 0 o 0 ~ 0 o 0 o 0 o 0 o 0 0 0 0 M 0 ~ O 0 0 0 0 0 0 0 0 0 o 0 0 ~O O ~ ~ ~ a ~ ~ ~ O tOA ~ CO~ N C10l H ~l O O V! Cg M O fii O lA O ~ O ~ 1~ M N M 0 ~ OfA~ EOR ~ N 0 ~ ~ ~~// d V d~9 ~ 1!9 ~ ~ ~ ~ ~ ~ ~ ~ <D ~ 1~ N O LL ~ ll_. ^ O N a ~ ~ W a Z Q r N ~ M M ~ ~ N p a F= N ~~ ~ m n ~ ~ N M O M O t0 O O N r ~ M M O O O N N ~L! • ~ 0 ~ W r r ~ ~ p O Woo ~a ~ ~ J ~ J ~ - ~ a m o O m o ~ J v ~~ O v) O J ~ O W a ~„ o } ~ O w p a a t o ~ „ 1-- J ¢ j Q ~ N 0 a = 0-~ Q c~ y z J v t~ ¢ c~ p t~ ~ p N ~ F. w W c ~ ~ w ~ z ~ ~ Q c7 W z z ~ w ~ z Q 3 c ' J W J Q O r2 W J W J O - rL fi W t) ~ - 1%. ~ D O ~ J ~ z H t~ m ~ = V ~7 (~ z w ~ ~ W > O Q D ~ ~ W t9 Z a Q ~ W ~ O a y c9 ? a Q Q Q ~ O c~ W z W d F ~ O W 2 Q -j W ~ w J ~ J v W ~ 0 ~ ~ w ~ - ~ - ~ z - ' m a ~ Q ~ v ? rn G a t~ Q w ~ ~ N C9 ~ cn w a ~ a ~ cn ~- N Q S ~- ~. ~w lilt of Atlantic Beach Y AGENDA ITEM # 4A FEBRUARY 26, 2007 FINANCIAL REPORT JANUARY 2007 Cash Balances -- Prior Current Dollar Fund 12/31/06 01/31/07 Change General $6,043,138 $7,005,155 $962,017 Tree Replacement 20,913 20,913 $0 Convention Development Tax 163,448 177,110 $13,662 Local Option Gas Tax 309,762 325,594 $15,832 ~. Better Jax 1/2 Cent Sales Tax 1,252,422 1,231,325 ($21,097) Police Training, Forfeit, etc. 9,587 9,717 $130 Grants 65,956 62,867 ($3,089) ~" Debt Service 32,430 38,471 $6 041 Utility 3,511,406 3,603,647 , $92,241 Sanitation 569,424 489,657 ($79,767) '" Storm Water 1,971,166 2,024,825 $53,659 Pension -Police 14,177 (5,769) ($19,946) Pension -General 64,621 79,773 $15,152 Total $14,028,450 $15,063,285 $1,034,835 Total Restricted Cash $6,817,216 Total Unrestricted Cash $8,246,069 Cash and Investments Prior Current Dollar Rate of Account 12/31/06 1/31/07 Change Return Bank of America -Depository $85,266 $409,646 $324,380 4.33 SBA 13,940,634 14,651,089 710,455 5.38 Cash on Hand 2,550 2,550 0 - Subtotal 14,028,450 15,063,285 1,034,835 Police Pension Investments 5,387,366 5,434,203 46,837 4.60 (1) General Pension Investments 8,059,747 8,126,237 66,490 4.70 (1) Subtotal 13,447,113 13,560,440 113,327 Total $27,475,563 $28,623,725 $1,148,162 (1) FYTD rate of return through 12/31/06 City of Atlantic Beach FINANCIAL REPORT JANUARY 2007 Revenues AGENDA ITEM # 4A FEBRUARY 26, 2007 Fund / (Footnote) Annual Estimate YTD - 33% of Estimate YTD Actual Dollar Variance Percent Variance General (1) $10,576,532 $3,521,985 $5,635,604 $2,113,619 60.01% Tree Replacement 0 0 0 0 100.00% Convention Development Tax 81,000 26,973 21,908 (5,065) -18.78% Local Option Gas Tax 563,042 187,493 184,757 (2,736) -1.46% Better Jax 1/2 Ct Sales Tax 761,298 253,512 258,506 4,994 1.97% Police Training, Forfeit, etc. 31,250 10,406 16,908 6,502 62.48% Grants 209,234 69,675 123,389 53,714 77.09% ~,. Debt Service 73,048 24,325 24,639 314 1.29% Utility (2) 6,750,002 2,247,750 2,186,093 (61,657) -2.74% Sanitation 1,462,200 486,913 441,272 (45,641) -9.37% Storm Water (3) 1,862,500 620,213 505,062 (115,151) -18.57% Pension -Police (4) 765,862 255,032 388,733 133,701 52.43% Pension -General (4) 1,096,364 365,089 639,720 274,631 75.22% "" Total $24,232,332 $8,069,366 $10,426,591 $2,357,225 Analysis of Major Variances (1) The $2,113,619 positive variance in the General Fund resulted from having received 82% of the budgeted property taxes in December, 2006 and January, 2007. Typically the majority of these taxes are received from the City of Jacksonville in December & January. Also,...the 4th quarter of 2006 reimbursement for Beach Maintenance & Lifeguards was received from the City of Jacksonville in October, 2006. (2) The $61,657 negative variance in the Utility Funds resulted from the lower sales volume of water & sewer. (3) The $115,151 negative variance in the Stormwater Fund resulted from not having received the grant for the Hopkins Creek Retention project -see Project Activity Schedule. This project is partially funded on a reimbursement basis grant for $400,000 from the Florida Department of Environmental Protection. The new time line for this project is to commence in December, 2007. (4) The $133,701 positive variance in the Police Employee Pension Fund & the $274,631 positive variance in the General Employee Pension Fund resulted from changes in market values of the investments. "" C It of Atlantic Beach AGENDA ITEM # 4A y FEBRUARY 26, 2007 FINANCIAL REPORT JANUARY 2007 Expenses Annual YTD - 33% YTD Dollar Percent Department / (Footnote) Estimate of Estimate Actual Variance Variance ~"" Governing Body $50,898 $16,949 $18,493 ($1,544) -9.11% City Administration 2,253,291 750,347 708,961 41,386 5.52% General Government (1) 3,037,978 1,011,648 548,604 463,044 45.77% Planning and Building 652,227 217,192 112,716 104,476 48.10% Public Safety (2) 4,759,060 1,584,766 1,325,638 259,128 16.35% Parks and Recreation 1,185,330 394,715 374,350 20,365 5.16% Public Works (3) 7,723,057 2,571,776 2,178,152 393,624 15.31% Public Utilities (4) 7,650,855 2,547,735 2,642,222 (94,487) -3.71 Pension -Police 424,133 141,236 146,008 (4,772) -3.38% Pension -General 436,713 145,425 142,702 2,723 1.87% ~. Total $28,173,542 $9,381,789 $8,197,846 $1,183,943 Annual YTD - 33% YTD Dollar Percent ,~ Resource Allocation Estimate of Estimate Actual Variance Variance Personal Services (2) & (5) $8,570,674 $2,854,034 $2,383,084 $470,950 16.50% ., Operating Expenses (2) & (3) 9,701,051 3,230,450 2,634,587 595,863 18.45% Capital Outlay (1) & (3) 6,883,063 2,292,060 1,460,858 831,202 36.26% Debt Service (4) 1,675,695 558,006 1,271,630 (713,624) -127.89% Transfers 1,343,059 447,239 447,687 (448) -0.10% ~. Total $28,173,542 $9,381,789 $8,197,846 $1,183,943 Analysis of Major Variances (1) The positive variance in the General Government departments resulted from not having begun the Buchman Trust Property project or the Police Building Renovations --see the Project Activity Schedule. (2) The positive variance in the Public Safety departments is partially due to the payment being due quarterly to the City of Jacksonville for fire & rescue services. A payment was made in January 2007 for October through December 2006. Also, there are vacant positions in the Police Patrol division and the Lifeguard expenses are seasonal (typically June through September). (3) The positive variance in the Public Works departments resulted from only 3 of 4 payments having been made on the solid waste contract, not purchasing the budgeted trash truck as of January 31, 2007 and not having begun various projects -see the Project Activity Schedule. (4) The negative variance in the Public Utilities department resulted from the annual payment of principal and semi-annual payment of interest on the Utility Revenue Bonds. (5) The positive variance in the Personal Services is related to 50% of the first payroll of October, 2006 being expensed in the prior fiscal year and vacant positions that have not been filled. ~"" ~ I ~" City of Atlantic Beach AGENDA ITEM # 4A FEBRUARY 26, 2007 FINANCIAL REPORT JANUARY 2007 Project Activity -Current Year Activity Only - Project YTD YTD YTD Project Name Number Budget Actual Balance Status General Government: Buchman Trust Property GG0701 $450,000 $0 $450,000 Subtotal 450,000 0 450,000 ~„ Parks and Recreation: Jordan Park Shelter PR0701 10,000 0 10,000 Playground Equipment-Donner Park PR0702 33,000 0 33,000 Shade for the Skate Park PR0703 20,000 0 20,000 Russell Park Light Replacements PR0704 17,500 0 17,500 Dune Crossover for 3rd Street PR0705 20,000 0 20,000 Subtotal 100,500 0 100,500 Public Safety Police Building Renovations PS0504 466,850 0 466,850 Subtotal 466,850 0 466,850 Public Utilities: Fence Replacement at Water Plant 1 PU0601 12,049 0 12,049 Genset at Lift Station B PU0604 29,007 0 29,007 Clarifier Rehabilitation at WWTP 1 PU0605 145,223 89,840 55,383 Fence Replacement at WWTP 1 PU0606 3,984 0 3,984 '~"` Sludge Container Refurbishment PU0607 8,900 8,876 24 Beach Habitat Subdivision PU0608 151,179 63,035 88,144 Remodel SCADA Control Area PU0701 20,000 0 20,000 ~* Roof Replacement at Lab/Office PU0702 17,695 12,000 5,695 Begonia Street Water & Sewer Extension PU0703 100,000 3,260 96,740 Collection System Inspection & Rehabilitation PU0704 365,400 0 365,400 Replace 2 Hydroscreens PU0705 30,000 0 30,000 TMDL Engineering WWTP 1 PU0706 338,500 0 338,500 Subtotal 1,221,937 177,011 1,044,926 """' Public Works: Hopkins Creek Retention PW0309 2,530,730 906,914 1,623,816 Mayport Road Medians PW0401 400,000 0 400,000 Five Points Intersection Improvement PW0502 8,164 8,164 0 Pathways PW0606 81,500 66,917 14,583 Sidewalks - Sailfish,Royal Palm & Frances PW0607 5,102 0 5,102 ~,,, Storage Bins for Limerock PW0701 30,000 0 30,000 Mandalay Park Improvements PW0702 50,000 0 50,000 Repave Asphalt at Public Works Yard PW0703 70,000 0 70,000 Asphalt Stewart Street at West Main Street PW0704 10,000 0 10,000 Sidewalk & Curb Replacement PW0705 50,000 6,400 43,600 Pedestrian Path -Five Points to Selva Marina PW0706 120,000 0 120,000 New Sidewalks -Marsh Oaks PW0707 120,000 0 120,000 '" Ocean Boulevard Between 14th & 15th Street PW0708 350,000 0 350,000 Subtotal 3,825,496 988,395 2,837,101 Total $6,064,783 $1,165,406 $4,899,377 Status Key B -Bid Awarded E -Design Phase ~. C -Project Completed I -Project In-progress D -Design Completed R - Re-budget Next Fis cal Year E I E E D C I I E AGENDA ITEM # 4A FEBRUARY 26, 2007 Water Sales Atlantic Beach Buccaneer Total Water Sales Water Plant Production Atlantic Beach Buccaneer Total Production Total Water Billed Water Loss for month: Percentage Loss Total 12 mo. Avg. Loss Sewer Sales Atlantic Beach Buccaneer Total Sewer Sales City of Atlantic Beach, f=1. Water and Sewer Utility Sales Report Janua 2007 January 2006 ~, Gallons Actual Revenue Gallons Actual Revenue Accounts 0000 Revenue Per t,000 yi ' Accounts 0000 Revenue Per 1,000 yi I` 5,620 42,868 $106,951 $2.49' 5,564 39,222 $96,178 $2.45` 2,481 22,196 $64.114 $2.89'. 2.689 23.638 $60.872 52.58 Gallons Gallons 0000 0000 46,443 50,164 27,661 20,980 74,104 71,144 65,064 62,860 9,040 8,284 12.20% 11.64°k 11.17°k 9.86% Gallons Actual Revenue Gallons Actual Revenue Accounts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per 1,000 gl 5,071 34,295 $157,450 $4.59 5,031 32,344 $149,107 $4.61 2,363 20.531 $122.236 $5.95 2.566 22.880 $123,223 $5.39 Sewer Treatment Gallons 0000 Actual Revenue Revenue Per 1,000 9i Gallons 0000 Actual Revenue Revenue Per 1,000 gi Atlantic Beach Buccaneer 47.004 22.643 $157,450 $122,236 $3.35. $5.40': 50.090 17.956 $149,107 $123,223 $2.98 $6.86 Total Sewer Treated 69.647 $279,686 $4.02 68.046 $272,330 $4.00