G-12-04-12-10B1 - 4/12/2012 ORDINANCE NO.("-17.-04--121-10&J
AN ORDINANCE ADOPTING AMENDMENT NO. 1 TO THE
OPERATING BUDGET OF THE CITY OF ROUND ROCK, TEXAS FOR
FISCAL YEAR 2011-2012.
BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF ROUND ROCK,
TEXAS:
That the operating budget for the City of Round Rock, Texas for Fiscal Year 2011-2012
is hereby revised for municipal purposes pursuant to §102.010, Local Government Code and in
accordance with the proposal submitted to the Council by the City Manager, which proposal is
attached hereto as Exhibit "A" and is incorporated into this ordinance by reference for all
purposes.
The City Clerk is directed to file a certified copy of this ordinance along with a true copy
of the attached revised budget with the County Clerk of Williamson County, Texas.
The City Council hereby finds and declares that written notice of the date, hour, place
and subject of the meeting at which this Ordinance was adopted was posted and that such
meeting was open to the public as required by law at all times during which this Ordinance and
the subject matter hereof were discussed, considered and formally acted upon, all as required by
the Open Meetings Act, Chapter 551, Texas Government Code, as amended.
READ and APPROVED on first reading this the ��ay of
2012.
READ, APPROVED and ADOPTED on second reading this the day of
Pei , 2012.
ALAN MCGRAW, Mayor
ATTEST: City of Round Rock, Texas
g4tA.." - dt4
SARA L. WHITE, City Clerk
0:\wdox\SCC1nts\0112\1204vKuxicrn,L\oozasssz.noarmc
City of Round Rock, Texas
Budget Revision#1
Fiscal Year 2011-2012
2011-2012 2011-2012
Original Revised Revision#1
GENERAL FUND Budget Budget#1 Variance
Revenues $ 83,345,350 $ 84,040,759 $ 695,409
Expenditures (83,345,011) (84,040,420) (695,409)
Total Change in Fund Balance $ 339 $ 339 $ -
DRAINAGE FUND
Revenues $ 1,650,000 $ 1,650,000 $ -
I
Operating Expenditures (1,549,863) (1,549,863) -
Change in Working Capital $ 100,137 $ 100,137 $ -
UTILITY FUND
Revenues $ 39,915,124 $ 39,915,124 $ -
Operating Expenditures (39,914,521) (39,914,521) -
Change in Working Capital $ 603 $ 603 $ -
EA
IT
Page 1
City of Round Rock, Texas
Budget Revision#1
Fiscal Year 2011-2012
2011-2012 2011-2012
Original Revised Revision#1
GENERAL FUND Budget Budget#1 Variance
Revenues $ 83,345,350 $ 84,040,759 $ 695,409
DEPARTMENT
Administration- 12 $ (2,301,666) $ (2,152,957) $ 148,709
DSO-31 (599,991) (613,197) (13,206)
Finance-17 (1,655,964) (1,697,819) (41,855)
Fire-22 (13,295,919) (14,067,865) (771,946)
Fiscal Support Services- 19 (11,032,363) (10,102,363) 930,000
Gen.Srvcs.-Bldng Const.&Facility Main.-35 (1,300,333) (1,341,693) (41,360)
Gen. Srvcs. -Vehicle Main. Facility-28 (1,136,349) (1,144,492) (8,143)
Human Resources-24 (1,096,850) (1,087,087) 9,763
Information Technology-15 (3,716,951) (3,906,037) (189,086)
Inspection Services-16 (1,294,089) (1,327,949) (33,860)
Legal Services- 13 (1,000,250) (1,000,250) -
Library-20 (2,352,039) (2,350,234) 1,805
Municipal Court-29 (753,952) (762,436) (8,484)
Parks&Recreation-23 (9,034,723) (9,125,579) (90,856)
Planning&Development Services- 14 (1,298,179) (1,290,738) 7,441
Police-21 (23,163,826) (23,655,435) (491,609)
Purchasing- 18 (597,601) (613,360) (15,759)
Transportation-Administration-27 (2,065,482) (2,121,037) (55,555)
Transportation-Operate&Maintain-34 (5,648,484) (5,679,892) (31,408)
General Government-Transfer - - -
Total Expenditures $ (83,345,011) $ (84,040,420) $ (695,409)
Page 2
City of Round Rock, Texas
Budget Revision#1
Fiscal Year 2011-2012
2011-2012 2011-2012
Original Revised Revision#1
DRAINAGE FUND Budget Budget#1 Variance
Revenues $ 1,650,000 $ 1,650,000 $ -
DEPARTMENT
Drainage-86 $ (1,549,863) $ (1,549,863) $ -
Total Expenditures $ (1,549,863) $ (1,549,863) $ -
Page 3
City of Round Rock, Texas
Budget Revision #1
Fiscal Year 2011-2012
2011-2012 2011-2012
Original Revised Revision#1
UTILITY FUND Budget Budget#1 Variance
Revenues $ 39,915,124 $ 39,915,124 $ -
DEPARTMENT
Utility Administration-40 $ (1,280,953) $ (1,305,001) $ (24,048)
Utility Billings&Collections-81 (1,394,275) (1,427,553) (33,278)
Utility Environmental Services-64 (552,650) (563,443) (10,793)
Wastewater Line Maintenance-63 (1,901,033) (1,927,048) (26,015)
Wastewater Systems Support-62 (2,521,086) (2,533,208) (12,122)
Wastewater Treatment Plant-61 (4,328,302) (4,328,302) -
Water Line Maintenance-43 (2,350,738) (2,384,716) (33,978)
Water Systems Support-42 (3,230,980) (3,275,267) (44,287)
Water Treatment Plant-41 (8,729,504) (8,754,983) (25,479)
Transfers-95 (13,625,000) (13,415,000) 210,000
General Government-Other - - -
Total Expenditures $ (39,914,521) $ (39,914,521) $ -
Page 4
City of Round Rock, Texas
Budget Revision#1
Fiscal Year 2011-2012
General Fund-Effect of the revision on fund balance:
Fund Balance 10/01/11 $ 40,542,118
Less Reserves(*1) (29,383,339)
Estimated Revenue(FY 2011-2012) 81,420,159
Interfund Transfers 2,620,600
Total Funds Available 95,199,538
Budgeted Expenditures (84,040,420)
Estimated Unreserved Fund Balance 9/30/12 $ 11,159,118
* 1 Reserve requirements established in accordance with operating reserve policies.
Page 5
City of Round Rock, Texas
Budget Revision #1
Fiscal Year 2011-2012
Drainage Fund-Effect of the revision on fund balance:
Fund Balance 10/01/11 $ 573,000
Less Reserves(*1) -
Estimated Revenue(FY 2011-2012) 1,650,000
Interfund Transfers -
Total Funds Available 2,223,000
Budgeted Expenditures (1,549,863)
Estimated Working Capital 9/30/12 $ 673,137
"1 Reserves are established in accordance with operating reserve policies.
Page 6
City of Round Rock, Texas
Budget Revision#1
Fiscal Year 2011-2012
Utility Fund-Effect of the revision on working capital:
Estimated Working Capital 10/01/11 $ 35,575,000
Less Reserves(*1) (14,369,228)
Estimated Revenue(FY 2011-2012) 39,915,124
Interfund Transfers (8,090,000)
Total Funds Available 53,030,896
Budgeted Expenditures (31,824,521)
Estimated Working Capital 9/30/12 $ 21,206,375 (*2)
*1 Reserves are established in accordance with operating reserve policies.
*2 Funds are designated for Capital Improvements to the Utility System.
ISI
Page 7
City of Round Rock
Budget Revision#1
Fiscal Year 2011-2012
Summary of Significant Adjustments
General Fund FY 2012 Explanation
Revenue Adjustments:
Misc.Grant Proceeds $ 230,000 Recognized various grant funds-see note(1)
Sales Tax 162,409 Increase in sales tax revenues
JAG 11,000 Department of Justice Grant
Sale of Assets 42,000 Sold Fire Truck
Transfer from General Self Financed Construction 250,000 Fisher(Emerson)Economic Development
Total Revenue Adjustments-General Fund $ 695,409
Expenditure Adiustments:
Increase above budgeted amount,movement of positions
Personnel Adjustments $ 403,598 amongst departments
Economic Development-Fisher(Emerson) 250,000 Economic Development agreement
Chamber of Commerce (225,000) Funded out of Type B Fund for half of FY 12
Fire Department New Programs 101,506 Various New Programs-see note(2)
Vehicle for Project Manager-Transportation Dept. 17,095 Vehicle for reclassified position
Emergency Planner Equipment 135,210 Grant funded equipment purchases
JAG Expenditures 11,000 Grant funded
Lonestar Grant-Library (22,000) Not applying for FY 12
Historic Preservation Grant 4,000 Grant funded-carryover from FY 11
Hazard Mitigation 20,000 Grant funded
Total Expenditure Adjustments-General Fund $ 695,409
(1)EMPG Grant$10,000,Hazardous Mitigation$20,000,Historic Preservation$4,000,UASI$196,000
(2)Additional Training(HAZMAT,Wildfire)$15,000,Wildland Equipment$33,029,Extrication Tools$29,562,Mule$11,500,
Alpha-Numeric Paging Software$12,415
Page 8
ROUND ROCK, C1 Council Agenda Summar Sheet
PURPOSE.PASSION.PROSPERITY.
Agenda Item No. *10131.
Consider an ordinance adopting Amendment No. 1 to the FY 2011-2012 Operating
Agenda Caption: Budget. (Second Reading)
Meeting Date: April 12,2012
Department: Finance
Staff Person making presentation: Cheryl Delaney
Finance Director
Item Summary:
This budget amendment addresses items which affect the current FY 2012 General Fund and Utility Fund Operating
budget. During the budget process, the City budgeted funding for a Market Study for employee compensation
during FY 2012. This amendment allocates the funding determined by the Market Study to the appropriate
departments in both the General Fund and the Utility Fund. The City has been awarded several grants during FY
2012, and has had grants extended from prior years into the current fiscal year. This amendment recognizes the
associated revenues and expenditures directly related to these grants. The amendment also reallocates expenses
resulting from personnel movements between departments.
Also included in this amendment is the purchase of several pieces of equipment and funding for additional training
for the Fire Department. The cost of this request is off-set by the sale of fire equipment. The extrication tool
addresses newer metals in newer vehicles. The HAZMAT Mule allows the HAZMAT team to drive closer to a
HAZMAT scene without using a substantial amount of air to get there. The Wildland equipment will build the
department's capabilities to respond to the growing threat. The Alpha-Numeric Paging Software will allow senior
Fire and Police Department staff to be notified immediately of significant events. The additional training will
enhance the department's ability to respond and manage threats posed by trains and tractor-trailer transportation.
Cost: N/A
Source of Funds: N/A
Date of Public Hearing(if required): N/A
Recommended Action: Approval