G-11-10-27-9D1 - 10/27/2011ORDINANCE NO.(i--[t— ID -2 -'tt4
AN ORDINANCE ADOPTING AMENDMENT NO. 2 TO THE
OPERATING BUDGET OF THE CITY OF ROUND ROCK, TEXAS FOR
FISCAL YEAR 2010-2011.
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 2010-2011
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 Secretary 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 6j day of
2011.
READ, APPROVED and ADOPTED on second reading this the itiday of
ak401.---V" , 2011.
ALAN MCGRAW, Mayor
ATTEST: City of Round Rock, Texas
SARA L. WHITE, City Secretary
O:\wdox\SCC1nts\0112\ 1104\MUNICIPAL\00233733.DOC/rmc
JI t t( �
11Whi SP1
City of Round Rock, Texas
Budget Revision #2
Fiscal Year 2010-2011
GENERAL FUND
2010-2011 2010-2011 2010-2011
Original Revised Revised Revision #2
Budget Budget #1 Budget #2 Variance
Revenues $ 81,460,949 $ 82,654,562 $ 89,038,936 $ 6,384,374
Expenditures (81,456,568) (82,650,181) (89,896,552) (7,246,371)
Total Change in Fund Balance $ 4,381 $ 4,381 $ (857,616) $ (861,997)
DRAINAGE FUND
Revenues $ 1,647,881 $ 1,647,881 $ 1,647,881 $
Operating Expenditures (1,647,881) (1,647,881) (1,647,881)
Change in Operations
Transfer to Self Financed Construction
Change in Working Capital $ $ $ $
UTILITY FUND
Revenues $ 38,904,000 $ 38,904,000 $ 38,904,000 $
Operating Expenditures (38,851,910) (38,851,910) (38,851,910)
Change in Operations 52,090 52,090 52,090
Transfer to Self Financed Construction
Change in Working Capital $ 52,090 $ 52,090 $ 52,090 $
EXHIBIT
„A„»
«A
1
City of Round Rock, Texas
Budget Revision #2
Fiscal Year 2010-2011
GENERAL FUND
2010-2011 2010-2011 2010-2011
Original Revised Revised Revision #2
Budget Budget #1 Budget #2 Variance
Revenues $ 81,460,949 $ 82,654,562 $ 89,038,936 $ 6,384,374
DEPARTMENT
Administration -12 $ (2,189,846) $ (2,460,910) $ (2,202,910) $ (258,000)
Development Services Office - 31 (699,565) (699,565) (634,565) (65,000)
Finance - 17 (1,685,707) (1,685,707) (1,685,707)
Fire - 22 (13,212,901) (13,257,901) (13,032,901) (225,000)
General Services - 19 (11,884,619) (11,884,619) (11,435,254) (449,365)
Human Resources - 24 (1,063,497) (1,063,497) (955,497) (108,000)
Information Technology - 15 (3,069,837) (3,165,437) (2,965,437) (200,000)
Legal Services -13 (1,010,500) (1,010,500) (1,010,500)
Library - 20 (2,419,690) (2,419,690) (2,337,690) (82,000)
Municipal Court - 29 (731,029) (731,029) (706,029) (25,000)
Parks & Recreation - 23 (9,016,373) (9,016,373) (8,433,373) (583,000)
Planning -14 (1,309,771) (1,309,771) (1,289,771) (20,000)
Police - 21 (22,960,125) (23,708,574) (23,933,574) 225,000
Purchasing -18 (615,278) (615,278) (565,278) (50,000)
PW - Admin. & Spec. Prog. - 32 (849,145) (849,145) (534,145) (315,000)
PW - Build. Const. & Fac. Main. - 35 (1,030,473) (1,063,973) (1,083,973) 20,000
PW - Infrast. Dev. & Const. Main. - 33 (2,446,289) (2,446,289) (2,361,289) (85,000)
PW - Operate & Maintain - 34 (4,180,426) (4,180,426) (3,905,426) (275,000)
PW - Vehicle Main. Fac. - 28 (1,081,497) (1,081,497) (1,126,497) 45,000
General Govemment - Transfer (9,696,736) 9,696,736
Total Expenditures $ (81,456,568) $ (82,650,181) $ (89,896,552) $ 7,246,371
2
City of Round Rock, Texas
Budget Revision #2
Fiscal Year 2010-2011
DRAINAGE FUND
2010-2011 2010-2011 2010-2011
Original Revised Revised Revision #2
Budget Budget #1 Budget #2 Variance
Revenues $ 1,647,881 $ 1,647,881 $ 1,647,881 $
DEPARTMENT
Drainage - 86
General Govemment - Transfer
$ (1,647,881) $ (1,647,881) $ (1,647,881) $
Total Expenditures $ (1,647,881) $ (1,647,881) $ (1,647,881) $
3
City of Round Rock, Texas
Budget Revision #2
Fiscal Year 2010-2011
2010-2011 2010-2011 2010-2011
Original Revised Revised Revision #2
UTILITY FUND Budget Budget #1 Budget #2 Variance
Revenues $ 38,904,000 $ 38,904,000 $ 38,904,000 $
DEPARTMENT
Utility Administration - 40 $ (1,005,249) $ (1,005,249) $ (1,005,249) $
Water Treatment Plant - 41 (9,697,713) (9,697,713) (9,263,713) (434,000)
Water Systems Support - 42 (3,535,557) (3,535,557) (3,595,557) 60,000
Water Line Maintenance - 43 (2,294,828) (2,294,828) (2,413,828) 119,000
Wastewater Treatment Plant - 61 (3,905,087) (3,905,087) (4,075,087) 170,000
Wastewater Systems Support - 62 (3,074,249) (3,074,249) (3,119,249) 45,000
Wastewater Line Maintenance - 63 (1,829,404) (1,829,404) (1,869,404) 40,000
Environmental Services - 64 (569,409) (569,409) (569,409)
Utility Billings & Collections - 81 (1,350,414) (1,350,414) (1,350,414)
Transfers - 95 (11,590,000) (11,590,000) (11,590,000)
General Govemment - Other
Total Expenditures $ (38,851,910) $ (38,851,910) $ (38,851,910) $
4
City of Round Rock, Texas
Budget Revision #2
Fiscal Year 2010-2011
General Fund - Effect of the revision on fund balance:
Fund Balance 10/01/10 $ 40,287,116
Less Reserves (*1) (29,665,862)
Estimated Revenue (FY 2010-2011) 87,497,209
Interfund Transfers 1,541,727
Total Funds Available 99,660,190
Budgeted Expenditures (89,896,552)
Estimated Unreserved Fund Balance 9/30/11 $ 9,763,638
1 Reserve requirements established in accordance with operating reserve policies.
Drainage Fund - Effect of the revision on working capital:
Estimated Working Capital 10/01/10 $
Less Reserves (*1)
Estimated Revenue (FY 2010-2011) 974,365
Interfund Transfers 673,516
Total Funds Available 1,647,881
Budgeted Expenditures (1,647,881)
Estimated Working Capital 9/30/11 $ - (* 2)
* 1 Reserves are established in accordance with operating reserve policies.
* 2 Funds are designated for Capital Improvements to the Drainage System.
5
City of Round Rock, Texas
Budget Revision #2
Fiscal Year 2010-2011
Utility Fund - Effect of the revision on working capital:
Estimated Working Capital 10/01/10 $ 32,954,604
Less Reserves ('1) (13,986,688)
Estimated Revenue (FY 2010-2011) 38,904,000
Interfund Transfers (7,190,000)
Total Funds Available 50,681,916
Budgeted Expenditures (31,661,910)
Estimated Working Capital 9/30/11 $ 19,020,006 (2)
* 1 Reserves are established in accordance with operating reserve policies.
2 Funds are designated for Capital Improvements to the Utility System.
6
City of Round Rock
Budget Revision #2
Fiscal Year 2010-2011
Summary of Significant Adjustments
General Fund
Revenue Adlustments:
FY 2011
Explanation
Current Property Taxes
Franchise - Cablevision
Sales Tax
Red Light Camera Fines
$ 300,000
300,000
6,170,000
(288,000)
Higher than expected payments
Higher than expected payments
Increase in sales tax collections
Program begins FY 12
FTA Reduction
(120,000) Will not be receiving
ARRA Grant
Interest Income
Transfer from Self Financed Construction
Grant received mid -year -
89,490 Violence Against Women Act
(295,116) Marked to Market adjustment
Grant reimbursement from Self
228,000 Financed Construction
Total Revenue Adjustments - General Fund
Expenditure Adjustments:
$ 6,384,374
2012 Self Financed Construction
2012 Capital Spending Plan
Salary Savings
$ 8,719,059
115,680
(1,240,000)
Dell Payment
1,115,000
To be allocated by Council
Replacement of Police vehicles
Departmental salary savings
Increase due to increased Dell
sales taxes collections
Contractual Services Savings
(2,325,365) Departmental savings
Transfer to PEG Fund
Establishment of PEG Fund
account in accordance with SB
861,997 1087
Total Expenditure Adjustments - General Fund
Drainage Fund
Revenue Adjustments:
Total Revenue Adjustments - Drainage Fund
Expenditure Adjustments:
Total Expenditure Adjustments - Drainage Fund
Utility Fund
Revenue Adjustments:
Total Revenue Adjustments - Utility Fund
Expenditure Adjustments:
Total Expenditure Adjustments - Utility Fund
7
$ 7,246,371
$
ROUND ROCK, TEXAS
PURPOSE. PASSION. PROSPERITY
City Council Agenda Summary Sheet
Agenda Item No. *9D1.
Consider an ordinance adopting Amendment No. 2 to the FY 2010-2011 Operating
Agenda Caption: Budget. (Second Reading)
Meeting Date: October 27, 2011
Department: Finance
Staff Person making presentation: Cheryl Delaney
Finance Director
Item Summary:
In September 2010, Council adopted the Operating Budget for the City for FY 2010-2011. The Operating Budget
consists of the General Fund, General Debt Service Fund, Water/Wastewater Utility Fund, and the Drainage Fund.
Amendment No. 1 to the Operating Budget was approved in June, 2011. The amendment recognized the revenues
and expenses directly related to several grants that had been awarded to the City during FY 11. The amendment
also allocated additional funding needed to address unbudgeted costs in the Administration and Fire departments.
This Amendment No. 2 to the Operating Budget allocates available cash from this fiscal year (2010-2011). These
available funds are provided primarily due to the collection of additional sales tax revenues, other revenues, and
departmental budget savings.
Approximately $6 million will be moved to the Self -financed Construction fund to be allocated as directed by Council
at a later date.
Cost:
Source of Funds:
N/A
N/A
Date of Public Hearing (if required): N/A
Recommended Action: Approval