Item No: 5C.

Meeting Date: May 29, 2012

From: Brandy McDaniel, Budget Manager

Subject: Ordinance amending the fiscal year 2011-12 Budget for the General, Stormwater, Capital Projects, Electric, Gas, Water, Wastewater, Communications and Health Insurance Funds for the Second Quarter

Staff Recommendation:

Staff recommends adopting the attached ordinance amending the Fiscal Year 2011-12 budget for the General, Stormwater, Capital Projects, Electric, Gas, Water, Wastewater, Communications and Health Insurance Funds for the Second Quarter.

Analysis:

As established in the Budget Policy, adopted September 28, 1998, total appropriations within a fund cannot increase or decrease without formal action by the City Commission.

These budget adjustments are required due to the following changes:

Fund	Amount	Source
General:
Reimbursement for Accident (Meter Readers)	$ 632	Miscellaneous Reimbursement
Voice over internet Protocol (VOIP) phone System Phase I (IT -Rollover which was missed)	125,000	Fund Balance
Smartgrid Test Environment (IT)	14,821	Transfer from Electric
Smartgrid Sungard Modules (IT)	69,030	Transfer from Electric
FDOT Hwy 441 Pond Maintenance (Recreation- Public Parks)	11,200	Fund Balance- Hwy 441 Pond Maintenance
Desktop Computers (IT- Rollover which was missed)	35,000	Fund Balance
Repair PD Fuel Site (Fleet)	2,349	Transfer from Capital Project Fund
Labor & Materials to install generator for Lift Station #9 (Fleet)	5,938	Transfer from Wastewater
Licensing Upgrade for Core Switch (IT)	22,393	Transfer from Electric, Gas, Water & Wastewater
GIS Technician Position	32,620	Transfer from Stormwater
Total General Fund	$ 318,983
Stormwater:
GIS Technician Position (General Fund)	$ 32,620	Fund Balance
Transfer to Communications-LCSB Project	315,000	Fund Balance
Total Stormwater Fund	$ 347,620
Capital Projects:
Fuel Site (2) refurbishment	$ 27,428	Fuel Surcharge Fund Balance
Total Capital Projects Fund	$ 27,428
Electric: Renewal & Replacement Repairs	$ 100,000	Renewal & Replacement
Smartgrid Project	15,583,060	Department of Energy Grant (DOE), Grant Anticipation Note (GAN), Energy Efficiency Community Block Grant (EECBG)
Transfer to IT (Licensing Upgrade for Core Switch)	3,732	Fund Balance
Total Electric Fund	$ 15,686,792
Gas:
Transfer to IT (Licensing Upgrade for Core Switch)	$ 3,732	Fund Balance
Total Gas Fund	$ 3,732
Water:
Transfer to IT (Licensing Upgrade for Core Switch)	$ 3,732	Fund Balance
Total Water Fund	$ 3,732
Wastewater:
Transfer to IT (Licensing Upgrade for Core Switch)	$ 11,197	Fund Balance
Total Wastewater Fund	$ 11,197
Communications:
Smartgrid Project	$ 140,000	Transfer from Electric
Lake County School Board Project	732,784	Transfer from Stormwater, Renewal & Replacement, Fund Balance
Total Communications Fund	$ 872,784
Health Insurance:
Firefighter & Police Physicals	$ 20,175	Transfer from General Fund
Total Health Insurance Fund	$ 20,175

Options:

1. Adopt the attached ordinance amending the fiscal year 2011-12 budget for the General, Stormwater, Capital Projects, Electric, Gas, Water, Wastewater, Communications and Health Insurance Funds, or

2. Such other action as the City Commission may deem necessary.

Fiscal Impact:

The following funds will increase/decrease as seen below:

FUND	FY 2012 ADOPTED	CHANGE	FY 2012 AMENDED
General	23,392,700	318,983	23,711,683
Stormwater	4,046,916	347,620	4,394,536
Greater Leesburg CRA	700,660	-0-	700,660
Carver Heights CRA	1,265,886	-0-	1,265,886
Hwy 441/27 CRA	5,723,304	-0-	5,723,304
Debt Service	1,628,054	-0-	1,628,054
Capital Projects	5,071,820	27,428	5,099,248
Electric	85,782,443	15,686,792	101,469,235
Gas	9,834,009	3,732	9,837,741
Water	13,243,974	3,732	13,247,706
Wastewater	11,661,997	11,197	11,673,194
Communications	1,763,080	872,784	2,635,864
Solid Waste	3,622,991	-0-	3,622,991
Police Pension	1,019,184	-0-	1,019,184
Fire Pension	1,220,868	-0-	1,220,868
General Employees Pension	2,375,000	-0-	2,375,000
Health Insurance	6,203,016	20,175	6,223,191
Workers’ Compensation	625,321	-0-	625,321
Discretionary Sales Tax	1,669,799	-0-	1,669,799
Gas Tax	977,705	-0-	977,705
Police Impact Fees Recreation Impact Fees Building Permits	5,800 58,964 435,607	-0- -0- -0-	5,800 58,964 435,607
Police Education Receipts	15,000	-0-	15,000
Magnolia Townhomes	156,093	-0-	156,093
Total	$182,500,191	$17,292,443	$199,792,634

Submission Date and Time: 5/24/12 4:13 PM____

Department: __Finance_____________ Prepared by: __Brandy McDaniel__ Attachments: Yes____ No ______ Advertised: ____Not Required ______ Dates: __________________________ Newspapers: _________________________________ _________________________________ Revised 6/10/04

Reviewed by: Dept. Head _______ Finance Dept. ___________ Deputy C.M. _______________ Submitted by: City Manager ___________________

Account No. _________________ Project No. ___________________ WF No. ______________________ Budget ______________________ Available _____________________

ORDINANCE NO.____________________
		AN ORDINANCE OF THE CITY COMMISSION OF THE CITY OF LEESBURG, FLORIDA, AMENDING THE FISCAL YEAR 2011-12 BUDGET FOR THE GENERAL, STORMWATER, CAPITAL PROJECTS, ELECTRIC, GAS, WATER, WASTEWATER, COMMUNICATIONS AND HEALTH INSURANCE FUNDS FOR THE SECOND QUARTER; AND PROVIDING AN EFFECTIVE DATE.
WHEREAS, the City Commission of the City of Leesburg Florida, adopted a budget for Fiscal Year 2011-12 on September 26, 2011, which they felt was in the best interest of the citizens of the City of Leesburg, and
WHEREAS, it is now necessary to amend the current budget for Fiscal Year 2011-12 to provide funds for various projects as adopted at City Commission meetings, and
WHEREAS, such action was not anticipated in the original 2011-12 annual budget;
NOW THEREFORE, BE IT ENACTED BY THE PEOPLE OF THE CITY OF LEESBURG, FLORIDA:
SECTION I.
Pursuant to Section 200.065, Florida Statutes, and all other applicable laws, the following amounts for use by the various funds during Fiscal Year 2011-12 as reflected below, including all modifications or amendments made during this meeting, are hereby adopted as increases/decreases to the original budget for Fiscal Year 2011-12 for the City of Leesburg, Florida:
	GENERAL FUND
	ESTIMATED REVENUES AND OTHER RECEIPTS
	Miscellaneous Revenues		632
	Other Financing Sources:
	Fund Balance Appropriated		160,000
	Fund Balance Appropriated- Hwy 441 Pond Maintenance		11,200
	Transfer from Stormwater		32,620
	Transfer from Capital Projects Fund		2,349
	Transfer from Electric		87,583
	Transfer from Gas		3,732
	Transfer from Water		3,732
	Transfer from Wastewater		17,135
	TOTAL ESTIMATED REVENUES AND OTHER RECEIPTS		318,983
	PROPOSED APPROPRIATIONS
	General Government		275,163
	Physical Environment		32,620
	Culture/Recreation		11,200
	TOTAL PROPOSED APPROPRIATIONS		318,983

	STORMWATER FUND
	ESTIMATED REVENUES AND OTHER RECEIPTS
	Other Financing Sources:
	Fund Balance		347,620
	TOTAL ESTIMATED REVENUES AND OTHER RECEIPTS		347,620
	PROPOSED APPROPRIATIONS
	Non Expenditures:
	Transfer to General Fund		32,620
	Transfer to Communications		315,000
	TOTAL PROPOSED APPROPRIATIONS		347,620
	CAPITAL PROJECTS FUND
	ESTIMATED REVENUES AND OTHER RECEIPTS
	Other Financing Sources:
	Fund Balance- Fuel Surcharge		27,428
	TOTAL ESTIMATED REVENUES AND OTHER RECEIPTS		27,428
	PROPOSED APPROPRIATIONS
	General Government		25,079
	Non Expenditures:
	Transfer to General Fund		2,349
	TOTAL PROPOSED APPROPRIATIONS		27,428
	ELECTRIC FUND
	ESTIMATED REVENUES AND OTHER RECEIPTS
	Intergovernmental Revenue		8,114,249
	Other Financing Sources:
	Debt Proceeds		7,468,811
	Renewal & Replacement		100,000
	Fund Balance		3,732	347,620
	TOTAL ESTIMATED REVENUES AND OTHER RECEIPTS		15,686,792
	PROPOSED APPROPRIATIONS
	Physical Environment		15,459,209
	Non Expenditures:
	Transfer to General Fund		87,583
	Transfer to Communications		140,000
	TOTAL PROPOSED APPROPRIATIONS		15,686,792
	GAS FUND
	ESTIMATED REVENUES AND OTHER RECEIPTS
	Other Financing Sources:
	Fund Balance		3,732
	TOTAL ESTIMATED REVENUES AND OTHER RECEIPTS		3,732
	PROPOSED APPROPRIATIONS
	Non Expenditures:
	Transfer to General Fund		3,732
	TOTAL PROPOSED APPROPRIATIONS		3,732
	WATER FUND
	ESTIMATED REVENUES AND OTHER RECEIPTS
	Other Financing Sources:
	Fund Balance		3,732
	TOTAL ESTIMATED REVENUES AND OTHER RECEIPTS		3,732
	PROPOSED APPROPRIATIONS
	Non Expenditures:
	Transfer to General Fund		3,732
	TOTAL PROPOSED APPROPRIATIONS		3,732
	WASTEWATER FUND
	ESTIMATED REVENUES AND OTHER RECEIPTS
	Other Financing Sources:
	Fund Balance		11,197
	TOTAL ESTIMATED REVENUES AND OTHER RECEIPTS		11,197
	PROPOSED APPROPRIATIONS
	Non Expenditures:
	Transfer to General Fund		11,197
	TOTAL PROPOSED APPROPRIATIONS		11,197
	COMMUNICATIONS FUND
	ESTIMATED REVENUES AND OTHER RECEIPTS
	Other Financing Sources:
	Transfer from Stormwater		315,000
	Transfer from Electric		140,000
	Renewal & Replacement		350,000
	Fund Balance		67,784
	TOTAL ESTIMATED REVENUES AND OTHER RECEIPTS		872,784
	PROPOSED APPROPRIATIONS
	Physical Environment		872,784
	TOTAL PROPOSED APPROPRIATIONS		872,784
	HEALTH INSURANCE FUND
	ESTIMATED REVENUES AND OTHER RECEIPTS
	Other Financing Sources:
	Transfer from General Fund		20,175
	TOTAL ESTIMATED REVENUES AND OTHER RECEIPTS		20,175
	PROPOSED APPROPRIATIONS
	General Government		20,175
	TOTAL PROPOSED APPROPRIATIONS		20,175
	ALL FUNDS
	ESTIMATED REVENUES AND OTHER RECEIPTS
	Miscellaneous Revenues		632
	Intergovernmental Revenue		8,114,249
	Other Financing Sources:
	Transfers from Other Funds		622,326
	Debt Proceeds		7,468,811
	Renewal & Replacement		450,000
	Fund Balance Appropriated- Fuel Surcharge		27,428
	Fund Balance Appropriated- Hwy 441 Pond Maintenance		11,200
	Fund Balance Appropriated		597,797
	TOTAL ESTIMATED REVENUES AND OTHER RECEIPTS		17,292,443
	ALL FUNDS
	PROPOSED APPROPRIATIONS
	General Government		320,417
	Physical Environment		16,364,613
	Culture & Recreation		11,200
	Non Expenditures:
	Transfers to Other Funds		596,213
	TOTAL PROPOSED APPROPRIATIONS		17,292,443
SECTION II.
This ordinance shall become effective upon its passage and adoption by the Leesburg City Commission in the manner provided by law.
PASSED AND ADOPTED at a regular meeting of the City Commission of the City of Leesburg, Florida held on the ______ day of May, 2012.
		Mayor
ATTEST:
City Clerk