Roswell, GA
File #: 10-0725    Version: 1 Name: FY 2011 Mid Year Adjustment
Type: Item with Resolution Status: Passed
File created: 10/19/2010 In control: Mayor and City Council
On agenda: 10/25/2010 Final action: 10/25/2010
Title: Request for approval of Budget Amendment 1585-10-25-10 to increase the FY 11 Revenue budget by $2,023,806 and increase the FY 11 Expenditure budget by $2,028,117. Presented by Keith Lee, Director of Strategic Planning and Budgeting
Title
Request for approval of Budget Amendment 1585-10-25-10 to increase the FY 11 Revenue budget by $2,023,806 and increase the FY 11 Expenditure budget by $2,028,117.
Presented by Keith Lee, Director of Strategic Planning and Budgeting
Body
Item Summary:
This budget amendment includes four components of appropriations as outlined below.  
 
Item 1:  The Citywide restructuring plan decreases the FY 2011 Approved Budget by (-$236,162) as follows:
 
 
 
·      Reclassification of the Traffic Signal Manager position to a Signal Systems Manager position - no impact on FY 11 Approved Budget.
 
 
Item 2:  Reappropriation of remaining FY 2010 funds in the amount of $93,269 as follows:
 
·      $3,310 in unspent Mayor's Supplies (1110-531131);
·      $3,457 in unspent Hospitality/Events ($1,760 in 1110-531310 and $1,697 in 1320-531310);
·      $5,685 in unspent "Find-It-All Roswell" funding (7510-531105);
·      $44,397 in unspent operating for additional "Find-It-All Roswell" funding (7510-531105)
·      $21,700 in unspent GIS professional services for centerline road attribution/quality control and GIS systems analysis/application development;
·      $2,320 in unspent travel and education and training for 2010 ESRI conference ($470 in 7415-523500 and $1,850 in 7415-5237000;
·      $2,400 in unspent printing and binding for the printing of marketing and promotional material for economic development (7510-523400)
·      $10,000 in unspent operating for the Bike Roswell Grant Match.  INSERT Cost Center and Account *****
 
Item 3:  Recognition of $173,806 in additional revenue (transfer in to Capital projects fund) and $371,010 in additional expenditures associated with special revenue funds as follows:
 
Revenue:
·      $173,806 in transfers in to the Capital Projects Fund from the Hotel/Motel Fund, Confiscated Assets Fund and Reserve for Sidewalk Assessments-General Fund (see projects below).
 
Expenditures:
·      $78,000 of Hotel/Motel-Trails fund balance for the Roswell Area Park trail culvert repair project.;
·      $35,000 in FY 10 unspent Confiscated Assets funds to increase the Ripley renovations project to include evidence lockers;
·      $60,806 of "Reserve for Sidewalk Assessment" funds for construction of Crabapple Road Sidewalks;
·      $15,000 in FY 10 unspent Water funds to fund the other half of the Dobbs Drive security gate project (the General Fund portion of the project was added during the budget process as part of the add/delete list but the Water Fund portion was not added)
·      $8,398 of remaining Transportation 2000 Bond Funds for the Sidewalk Connectivity project.
 
 
Item 4:  Recognition of $1,850,000 in additional revenue and $1,800,000 in additional expenditures associated with approved grant projects as follows:
 
·      $400,000 in Federal HPP funds for the Holcomb Bridge Road Corridor Study project;
·      $400,000 in Federal CMAQ construction funds for the SR 92 ATMS project as detailed in the Project Framework Agreement approved by M&CC on 9/3/08;
·      $600,000 in Federal CMAQ construction funds for the SR 140 ATMS project as detailed in the Project Framework Agreement approved by M&CC on 9/3/08;
·      $400,000 in Federal earmark design funds for the Chattahoochee River Bridge Pedestrian Enhancement project as detailed in the Project Framework Agreement approved by M&CC on 4/5/10;
·      $50,000 in local match funds from Sandy Springs for the Chattahoochee River Bridge Pedestrian Enhancement project as detailed  in the Intergovernmental Agreement approved by M&CC on 8/23/10 (expenditure is already budgeted);
 
Committee or Staff Recommendation:
On October 11, 2010 the Mayor and Council was presented the above information at a Work Session for the Mid Year Update.
 
Financial Impact:
 
FY 2011 Revenues
 
FY 11 Current
Mid-Year Budget
FY 11 New
 
Amended Budget
Amendment
Amended Budget
General Fund                              
$55,916,413.00
$50,000.00
$55,966,413.00
Solid Waste Fund
$9,538,000.00
 
$9,538,000.00
Debt Service Fund
$6,405,000.00
 
$6,405,000.00
Group Benefits
$6,702,407.00
 
$6,702,407.00
Recreation Participation Fund
$5,028,097.00
 
$5,028,097.00
Water Fund
$3,345,750.00
 
$3,345,750.00
E-911 Fund
$1,675,000.00
 
$1,675,000.00
Capital Projects Fund
$9,012,339.00
$173,806.00
$9,186,145.00
Risk Management Fund
$863,393.00
 
$863,393.00
Confiscated Assets Fund
$30,000.00
 
$30,000.00
Worker's Compensation Fund
$446,350.00
 
$446,350.00
Hotel/Motel Fund
$502,500.00
 
$502,500.00
Leita Thompson Rental Fund
$76,200.00
 
$76,200.00
Cemetery Care Fund
$0.00
 
$0.00
Soil Erosion Fund
$3,500.00
 
$3,500.00
Impact Fee Fund
$100,000.00
 
$100,000.00
Tree Bank Fund
$600.00
 
$600.00
Grant Funds
$117,627.69
$1,800,000.00
$1,917,627.69
TOTAL:
$99,763,176.69
$2,023,806.00
$101,786,982.69
 
FY 2011 Expenditures
 
FY 11 Current
Mid-Year Budget
FY 11 New
 
Amended Budget
Amendment
Amended Budget
General Fund                                 
$64,095,328.61
($93,433.00)
$64,001,895.61
General Fund - Reserve for Sidewalk Assessments
$0.00
$60,806.00
$60,806.00
Solid Waste Fund
$10,174,617.91
 
$10,174,617.91
Debt Service Fund
$6,407,100.00
 
$6,407,100.00
Group Benefits
$7,351,975.05
 
$7,351,975.05
Recreation Participation Fund
$5,035,376.93
 
$5,035,376.93
Water Fund
$5,374,651.46
($34,460.00)
$5,340,191.46
E-911 Fund
$1,586,541.00
 
$1,586,541.00
Capital Projects Fund
$23,181,633.53
$173,806.00
$23,355,439.53
Risk Management Fund
$863,393.00
 
$863,393.00
Confiscated Assets Fund
$566,633.75
$35,000.00
$601,633.75
Worker's Compensation Fund
$446,350.00
 
$446,350.00
Hotel/Motel Fund
$441,187.00
$78,000.00
$519,187.00
Leita Thompson Rental Fund
$62,500.00
 
$62,500.00
Cemetery Care Fund
$23,500.00
 
$23,500.00
Soil Erosion Fund
$100,450.00
 
$100,450.00
Impact Fee Fund
$2,624,943.44
 
$2,624,943.44
2000 Bond Fund
$1,440,103.85
$8,398.00
$1,448,501.85
Tree Bank Fund
$28,326.86
 
$28,326.86
Grant Funds
$3,305,636.48
$1,800,000.00
$5,105,636.48
TOTAL:
$133,110,248.87
$2,028,117.00
$135,138,365.87
 
Presented by:
Keith Lee, Director of Strategic Planning and Budgeting