G-12-10-25-I1 - 10/25/2012 f
t
ORDINANCE NO.
z
AN ORDINANCE ADOPTING AMENDMENT NO. 2 TO THE
OPERATING BUDGET OF THE CITY OF ROUND ROCK, TEXAS FOR
FISCAL YEAR 2011-2012.
t
I
BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF ROUND ROCK, e
TEXAS: k
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
Y
accordance with the proposal submitted to the Council by the City Manager, which proposal is j
g
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
F
and subject of the meeting at which this Ordinance was adopted was posted and that such
I
I
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 —day of
2012. x
READ, APPROVED and ADOPTED on second reading this the day of
' 2012.
ALA MCGRAW, Mayor
ATTEST: City of Round Rock, Texas
SARA L. WHITE, City Clerk
0:\wdox\SCC1nts\0112\1204\MUNICIPAL\00259364.DOC/rmc
p:
City of Round Rock, Texas
Budget Revision#2
Fiscal Year 2011-2012
2011-2012 2011-2012 2011-2012
Original Revised Revised Revision#2
GENERAL FUND Budget Budget#1 Budget#2 Variance E
Revenues $ 83,345,350 $ 84,040,759 $ 89,887,159 $ 5,846,400
Expenditures (83,345,011) (84,040,420) (89,886,820) (5,846,400)
Total Change in Fund Balance $ 339 $ 339 $ 339 $ -
3f
f:
DRAINAGE FUND
Revenues $ 1,650,000 $ 1,650,000 $ 1,650,000 $ - e
Operating Expenditures (1,549,863) (1,549,863) (1,549,863) - #
Change in Working Capital $ 100,137 $ 100,137 $ 100,137 $ - f
UTILITY FUND
Revenues $ 39,915,124 $ 39,915,124 $ 39,915,124 $ -
a
Operating Expenditures (39,914,521) (39,914,521) (47,914,521) (8,000,000)
3
Change in Working Capital $ 603 $ 603 $ (7,999,397) $ (8,000,000)
i
Y
2'
1'
y#yi
i
R:
F
G:
S
3:
f
1
3
EXHIBIT
"A„
Pagel
(
'f
City of Round Rock, Texas =
Budget Revision#2
Fiscal Year 2011-2012
2011-2012 2011-2012 2011-2012
Original Revised Revised Revision#2 f
GENERAL FUND Budget Budget#1 Budget#2 Variance
Revenues $ 83,345,350 $ 84,040,759 $ 89,887,159 $ 5,846,400
DEPARTMENT
Administration-12 $ (2,301,666) $ (2,152,957) $ (2,152,957) $
DSO-31 (599,991) (613,197) (637,197) (24,000)
i
Finance-17 (1,655,964) (1,697,819) (1,668,819) 29,000
Fire-22 (13,295,919) (14,067,865) (14,067,865) -
Fiscal Support Services-19 (11,032,363) (10,102,363) (10,464,363) (362,000)
Gen. Srvcs.-Bldng Const. &Facility Main. -35 (1,300,333) (1,341,693) (1,341,693) -
Gen. Srvcs. -Vehicle Main. Facility-28 (1,136,349) (1,144,492) (1,153,267) (8,775)
s
Human Resources-24 (1,096,850) (1,087,087) (949,087) 138,000
Information Technology-15 (3,716,951) (3,906,037) (3,543,037) 363,000 E
t
Inspection Services-16 (1,294,089) (1,327,949) (1,303,949) 24,000
Legal Services-13 (1,000,250) (1,000,250) (1,246,250) (246,000)
Library-20 (2,352,039) (2,350,234) (2,300,234) 50,000
Municipal Court-29 (753,952) (762,436) (712,436) 50,000
r-
Parks&Recreation-23 (9,034,723) (9,125,579) (8,850,579) 275,000
Planning&Development Services-14 (1,298,179) (1,290,738) (1,238,738) 52,000
fi
Police-21 (23,163,826) (23,655,435) (23,137,435) 518,000
Purchasing-18 (597,601) (613,360) (569,360) 44,000
Transportation-Administration-27 (2,065,482) (2,121,037) (1,569,037) 552,000
Transportation-Operate&Maintain-34 (5,648,484) (5,679,892) (4,119,892) 1,560,000
I
General Government-Transfer - - (8,860,625) (8,860,625)
Total Expenditures $ (83,345,011) $ (84,040,420) $ (89,886,820) $ (5,846,400)
(
f
k
f
f
Page 2
4
i
S
City of Round Rock, Texas f
y.
Budget Revision#2
Fiscal Year 2011-2012
2011-2012 2011-2012 2011-2012
Original Revised Revised Revision#2
DRAINAGE FUND Budget Budget#1 Budget#2 Variance
A
Revenues $ 1,650,000 $ 1,650,000 $ 1,650,000 $ -
DEPARTMENT
Drainage-86 $ (1,549,863) $ (1,549,863) $ (1,549,863) $ -
Total Expenditures $ (1,549,863) $ (1,549,863) $ (1,549,863) $ -
E
r
(
z
t
i
}jFf
R
5�
jY
1
i
{
C
f
Page 3
b
City of Round Rock, Texas
Budget Revision#2
Fiscal Year 2011-2012
2011-2012 2011-2012 2011-2012
Original Revised Revised Revision#2
UTILITY FUND Budget Budget#1 Budget#2 Variance F
Revenues $ 39,915,124 $ 39,915,124 $ 39,915,124 $ -
(
DEPARTMENT
Utility Administration-40 $ (1,280,953) $ (1,305,001) $ (1,305,001) $ -
i
Utility Billings&Collections-81 (1,394,275) (1,427,553) (1,427,553) -
Utility Environmental Services-64 (552,650) (563,443) (563,443) -
Wastewater Line Maintenance-63 (1,901,033) (1,927,048) (1,927,048) -
Wastewater Systems Support-62 (2,521,086) (2,533,208) (2,568,208) (35,000)
Wastewater Treatment Plant-61 (4,328,302) (4,328,302) (4,328,302) -
Water Line Maintenance-43 (2,350,738) (2,384,716) (2,384,716) -
Water Systems Support-42 (3,230,980) (3,275,267) (3,275,267) -
Water Treatment Plant-41 (8,729,504) (8,754,983) (8,754,983)
Transfers-95 (13,625,000) (13,415,000) (21,380,000) (7,965,000)
f
General Government-Other - - - -
Total Expenditures $ (39,914,521) $ (39,914,521) $ (47,914,521) $ (8,000,000)
(
s
Ft
fr
3
f
E
T
i
{
i
i
't
Page 4
i
t
k
City of Round Rock, Texas '
Z
Budget Revision#2
Fiscal Year 2011-2012
General Fund-Effect of the revision on fund balance:
Fund Balance 10/01/11 $ 40,542,118
Less Reserves(*1) (31,312,651)
Estimated Revenue(FY 2011-2012) 86,897,059
t
Interfund Transfers 2,990,100
k
Total Funds Available 99,116,626
Budgeted Expenditures (89,886,820)
Estimated Unreserved Fund Balance 9/30/12 $ 9,229,806
* 1 Reserve requirements established in accordance with operating reserve policies.
Note-This revision increases the FTE count in PARD by.25 to correct for a prior reorganization,transfers one FTE from Police to
Administration for the Special Events Coordinator position,and activates a new FTE in Administration for the Neighborhood
Development Coordinator position.
i>
3:
t
}
t
S
F
k
F
4
d
i
E
E
i
t
a`
I
i
{
S
Page 5
City of Round Rock, Texas
Budget Revision#2
Fiscal Year 2011-2012
Drainage Fund-Effect of the revision on fund balance:
A
k
Fund Balance 10/01/11 $ 573,000
Y
Less Reserves(*1) (511,455)
Estimated Revenue(FY 2011-2012) 1,650,000
Interfund Transfers -
Total Funds Available 1,711,545
Budgeted Expenditures (1,549,863)
Estimated Working Capital 9/30/12 $ 161,682
*1 Reserves are established in accordance with operating reserve policies.
1
3
f
1
5
f'
R
F
t
i
I
I
F
_ a
7
Page 6
i
I
f
x
City of Round Rock, Texas
F
Budget Revision#2
Fiscal Year 2011-2012
t
t
Utility Fund-Effect of the revision on working capital:
Estimated Working Capital 10/01/11 $ 36,120,040
i
Less Reserves(*1) (17,249,228) '
6
Estimated Revenue(FY 2011-2012) 39,915,124
Interfund Transfers (16,090,000)
Total Funds Available 42,695,936
Budgeted Expenditures (31,824,521)
Estimated Working Capital 9/30/12 $ 10,871,415 (*2)
*1 Reserves are established in accordance with operating reserve policies.
*2 Funds are designated for Capital Improvements to the Utility System.
i
t
A
k
d'
(k
Z
3
t
a
i
I
t
i
Page 7
City of Round Rock
Budget Revision#2
Fiscal Year 2011-2012
Summary of Significant Adjustments
General Fund FY 2012 Explanation ,
a.
t
Revenue Adiustments:
_ t
Sales Tax $ 4,286,900 Increase in Sales Tax Revenues )
Property Taxes 99,000 Revenues higher than anticipated
s
Capitalized Lease Proceeds 313,000 Annual Lease Program
Emergency Services Organization 73,800 Reimbursement from Williamson ESO
NRPA Grant 15,000 Parks&Recreation Trail Enhancement
Transfer from Municipal Court Fund 119,500 Funding for School Crosswalk Upgrades
Franchise Fees 839,000 Increase in Electric,Cable Franchise Fees {
Recreation Programs Revenues 198,000 Revenues higher than anticipated
FTA Reimbursement 54,000 Agreement for Demand Response received mid-year
4
UASI Grant _,______200,000 Reimbursement for Grant expenditures
Training Fees (12_,500) Fire Department no longer receiving reimbursement „
Separate Fund for PEG Fees(previously in General
PEG Fees (225,000) Fund)
Interest Income (205,000) Income less than anticipated
Includes charges for garbage services,library&police it
Miscellaneous Fines&Fees 90,700 fines
t
Total Revenue Adjustments-General Fund $ 5,846,400
t
Expenditure Adiustments: s
2013 Self Financed Construction $ 7,610,625 To be allocated by Council
Transfer to Pavement Management Program 1,250,000 Transfer funds to Pavement Management Program
Salary Savings (1,258,000) Departmental salary savings
Dell Payment 362,000 Increase due to increased Dell sales taxes collections
Contractual Services Savings (1,079,900) Departmental savings(power&light,fuel,training)
Pavement Management Program (1,250,000) Originally included as General Fund expenditure
Grant Expenditures 15,000 Trail improvements funded through grant
School Crosswalk Upgrades 119,500 Funded from Municipal Court Fund and General Fund g
Fire Department Analysis 68,400 Comprehensive analysis of Fire Department
Vehicle Maintenance Facility Equipment 8,775 Equipment for Fuel System
z
Total Expenditure Adjustments-General Fund $ 5,846,400
Utility Fund FY 2012 Explanation
f
Revenue Adjustments: `
None
Total Revenue Adjustments-Utility Fund $ -
Expenditure Adiustments:
Transfer to Self Financed Water Construction $ 6,000,000 Transfer from Fund Balance j
Transfer to Self Financed Wastewater Construction 2,000,000 Transfer from Fund Balance
Total Expenditure Adjustments-Utility Fund $ 8,000,000
i
s
i
i
3
Page 1
i
)
t
I
ROUND ROCK TEXAS City Council Agenda Summary Sheet g
PURPOSE.PASSION.PROSPERITY.
i
f
3
P;
f
Agenda Item No. I1.
Consider an ordinance adopting amendment No. 2 to the FY 2011-2012 Operating Budget.
Agenda Caption: (Second Reading)
Y
Meeting Date: October 25, 2012
Department: Finance
Staff Person making presentation: Cheryl Delaney }
Finance Director G;
Item Summary:
In September 2011, Council adopted the Operating Budget for the City for FY 2011-2012. 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 April, 2012. The amendment allocated funding to the
appropriate General Fund and Utility Fund departments as determined by the Market Study for employee
compensation. The amendment recognized the revenues and expenses directly related to several grants that had
been awarded to the City during FY 12. The amendment also allocated additional funding for several pieces of t;
equipment and training for the Fire department.
3
(
This Amendment No. 2 to the Operating Budget allocates available cash from this fiscal year (2011-2012). These
available funds are provided primarily due to the collection of additional sales tax revenues, capitalized lease k
proceeds, other revenues, and departmental budget savings. This amendment also addresses personnel items,
including increasing the FTE count in PARD by .25, transferring a position from Police to Administration, and
t
activating a new FTE in Administration.
Approximately $4.5 million will be moved to the Self-financed Construction fund to be allocated as directed by
Council at a later date.
This amendment also utilizes fund balance in the Utility Fund to transfer $6 million to Self-Financed Water
Construction, and $2 million to Self-Financed Wastewater Construction.
Strategic Goal 1- Financially sound city providing high value services.
Q
Cost: None—This is a budget adoption only
Date of Public Hearing(if required): N/A
Recommended Action: Approval f
i
k
. . . . ... . . .. . . . . . . . . . . . . .
LLJ
inw 3
oc � O
O � J
u
V OO
� O
cl
ORD 2013020664
10 PGS
THE STATE OF TEXAS
COUNTY OF WILLIAMSON
CITY OF ROUND ROCK
I, SARA L. WHITE, City Clerk of the City of Round Rock, Texas, do hereby certify that I am
the custodian of the public records maintained by the City and that the above and foregoing is
a true and correct copy of Ordinance No. G-12-10-25-11, which adopts Amendment No. 2 to the
FY 2011 — 2012 Operating Budget of the City of Round Rock. This ordinance was approved by F
i
the City Council at a regular meeting on the 11tH day of October 2012 and adopted on the 251H
x
day of October 2012. This ordinance is recorded in the official City Council Minute Book No.
I
1
60.
CERTIFIED by my hand and seal of the City of Round Rock, Texas on this 7tH day of
March 2013.
i
SARA L. WHITE, TRMC, City Clerk
is
r
E
}
1
1
4
i
ORDINANCE NO. t z
AN ORDINANCE ADOPTING AMENDMENT NO. 2 TO THE
OPERATING BUDGET OF THE CITY OF ROUND ROCK, TEXAS FOR Y
FISCAL YEAR 2011-2012.
f
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
i
accordance with the proposal submitted to the Council by the City Manager, which proposal is
F
3
attached hereto as Exhibit "A" and is incorporated into this ordinance by reference for all
s
purposes.
t
The City Clerk is directed to file a certified copy of this ordinance along with a true copy
Y
a
of the attached revised budget with the County Clerk of Williamson County, Texas.
r
The City Council hereby finds and declares that written notice of the date, hour, place
{ t
and subject of the meeting at which this Ordinance was adopted was posted and that such Y
E
meeting was open to the public as required by law at all times during which this Ordinance and i
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 day of
2012.
s
1 k
READ, APPROVED and ADOPTED on second reading this the Pday of
'2012. F }
i
F
f
ALAI MCGRAW, Mayor
ATTEST: City of Round Rock, Texas `
4��Iv ��V�• ����Wyli r €�
SARA L. WHITE, City Clerk
`s
0:\wdox\SCC1nts\0112\1204\MUNICIPA000259364.DOC/mc N
7
r:
City of Round Rock, Texas
4
Budget Revision#2
Fiscal Year 2011-2012
2011-2012 2011-2012 2011-2012
Original Revised Revised Revision#2
GENERAL FUND Budget Budget#1 Budget#2 Variance j
i
Revenues $ 83,345,350 $ 84,040,759 $ 89,887,159 $ 5,846,400
Expenditures (83,345,011) (84,040,420) (89,886,820) (5,846,400)
Total Change in Fund Balance $ 339 $ 339 $ 339 $
i
f
i
DRAINAGE FUND
Revenues $ 1,650,000 $ 1,650,000 $ 1,650,000 $
� f
Operating Expenditures (1,549,863) (1,549,863) (1,549,863) -
3pp
F E
Change in Working Capital $ 100,137 $ 100,137 $ 100,137 $ -
a
UTILITY FUND i
E S
Revenues $ 39,915,124 $ 39,915,124 $ 39,915,124 $ -
5
Operating Expenditures (39,914,521) (39,914,521) (47,914,521) (8,000,000) s
Change in Working Capital $ 603 $ 603 $ (7,999,397) $ (8,000,000)
i
� b
1
x E
Y
t a
f.
i_
I
p
4
4
EXHIBIT F
"All p
I
Page 1
4
i
City of Round Rock, Texas
Budget Revision#2
Fiscal Year 2011-2012
2011-2012 2011-2012 2011-2012
Original Revised Revised Revision#2 .
GENERAL FUND Budget Budget#1 Budget#2 Variance
Revenues $ 83,345,350 $ 84,040,759 $ 89,887,159 $ 5,846,400
DEPARTMENT
Administration-12 $ (2,301,666) $ (2,152,957) $ (2,152,957) $DSO-31 (599,991) (613,197) (637,197) (24,000)
i
Finance-17 (1,655,964) (1,697,819) (1,668,819) 29,000
Fire-22 (13,295,919) (14,067,865) (14,067,865) -
i
Fiscal Support Services-19 (11,032,363) (10,102,363) (10,464,363) (362,000)
Gen.Srvcs.-Bldng Const.&Facility Main.-35 (1,300,333) (1,341,693) (1,341,693)
Gen.Srvcs. -Vehicle Main. Facility-28 (1,136,349) (1,144,492) (1,153,267) (8,775)
Human Resources-24 (1,096,850) (1,087,087) (949,087) 138,000 €
� f
Information Technology-15 (3,716,951) (3,906,037) (3,543,037) 363,000
s
Inspection Services-16 (1,294,089) (1,327,949) (1,303,949) 24,000 f
Legal Services-13 (1,000,250) (1,000,250) (1,246,250) (246,000) ' I
Library-20 (2,352,039) (2,350,234) (2,300,234) 50,000
2
Municipal Court-29 (753,952) (762,436) (712,436) 50,000
)
Parks&Recreation-23 (9,034,723) (9,125,579) (8,850,579) 275,000 : s;
(
e
Planning&Development Services-14 (1,298,179) (1,290,738) (1,238,738) 52,000 }
Police-21 (23,163,826) (23,655,435) (23,137,435) 518,000
i
Purchasing-18 (597,601) (613,360) (569,360) 44,000
l
t 4:
Transportation-Administration-27 (2,065,482) (2,121,037) (1,569,037) 552,000
Transportation-Operate&Maintain-34 (5,648,484) (5,679,892) (4,119,892) 1,560,000 r
General Government-Transfer - - (8,860,625) (8,860,625)
Total Expenditures $ (83,345,011) $ (84,040,420) $ (89,886,820) $ (5,846,400) ( }
i
i
i
Page 2 f
I
a
[ t
City of Round Rock, Texas
E
Budget Revision#2 E
Fiscal Year 2011-2012
2011-2012 2011-2012 2011-2012
Original Revised Revised Revision#2
DRAINAGE FUND Budget Budget#1 Budget#2 Variance
Revenues $ 1,650,000 $ 1,650,000 $ 1,650,000 $ -
f
DEPARTMENT
Drainage-86 $ (1,549,863) $ (1,549,863) $ (1,549,863) $
Total Expenditures $ (1,549,863) $ (1,549,863) $ (1,549,863) $ -
i
i
P
r
f
k
i
3
i
e
t
f x
i
i
E
t
r.
{ f
{
i
t t
i'
I z.
f
7j
i
7
s
I t
R
P
k
i
Page 3
1 `
5
4
r
k
,
City of Round Rock, Texas
Budget Revision#2
Fiscal Year 2011-2012
2011-2012 2011-2012 2011-2012
Original Revised Revised Revision#2
UTILITY FUND Budget Budget#1 Budget#2 Variance
Revenues $ 39,915,124 $ 39,915,124 $ 39,915,124 $ - t
DEPARTMENT
Utility Administration-40 $ (1,280,953) $ (1,305,001) $ (1,305,001) $ -
Utility Billings&Collections-81 (1,394,275) (1,427,553) (1,427,553) -
Utility Environmental Services-64 (552,650) (563,443) (563,443) -
I
Wastewater Line Maintenance-63 (1,901,033) (1,927,048) (1,927,048) -
I
Wastewater Systems Support-62 (2,521,086) (2,533,208) (2,568,208) (35,000)
Wastewater Treatment Plant-61 (4,328,302) (4,328,302) (4,328,302) -
Water Line Maintenance-43 (2,350,738) (2,384,716) (2,384,716) -
i
t
Water Systems Support-42 (3,230,980) (3,275,267) (3,275,267) -
Water Treatment Plant-41 (8,729,504) (6,754,983) (8,754,983)
(
Transfers-95 (13,625,000) (13,415,000) (21,380,000) (7,965,000)
General Government-Other - - -
Total Expenditures $ (39,914,521) $ (39,914,521) $ (47,914,521) $ (8,000,000)
I
i
(
%
x
4
}
i
k P
f�
f
E
S
S d
Page 4
(I
s
t
City of Round Rock, Texas
Budget Revision#2
Fiscal Year 2011-2012
General Fund-Effect of the revision on fund balance:
Fund Balance 10/01/11 $ 40,542,118
Less Reserves(*1) (31,312,651)
Estimated Revenue(FY 2011-2012) 86,897,059
i
Interfund Transfers 2,990,100 I
9
Total Funds Available 99,116,626
Y I
Budgeted Expenditures (89,886,820)
f
Estimated Unreserved Fund Balance 9/30/12 $ 9,229,806
f
"1 Reserve requirements established in accordance with operating reserve policies.
}
Note-This revision increases the FTE count in PARD by.25 to correct for a prior reorganization,transfers one FTE from Police to
Administration for the Special Events Coordinator position,and activates a new FTE in Administration for the Neighborhood f
Development Coordinator position.
I
{
{
S
j
S
Y �
F
{
e
}
f
Y
t
E
t
f
1 �
t
s
i
p
r
i
's y
i
i
i;
i
C
Page 5
City of Round Rock, Texas
F
Budget Revision#2
Fiscal Year 2011-2012
Drainage Fund-Effect of the revision on fund balance:
Fund Balance 10/01/11 $ 573,000
t
Less Reserves(•1) (511,455) i
Estimated Revenue(FY 2011-2012) 1,650,000
Interfund Transfers
Total Funds Available 1,711,545
t
Budgeted Expenditures (1,549,863)
Estimated Working Capital 9/30/12 $ 161,682
4
1 Reserves are established in accordance with operating reserve policies. k
i
k e
F
t C
l
� f
F
5i
f
4€4€
F F
Y
i F
t
Y L
1
i
f S
1
Page 6
i
i
• I
City of Round Rock, Texas
Budget Revision#2
Fiscal Year 2011-2012
k
Utility Fund-Effect of the revision on working capital:
Estimated Working Capital 10/01/11 $ 36,120,040
Less Reserves("1) (17,249,228) !
t
Estimated Revenue(FY 2011-2012) 39,915,124 s
i
Interfund Transfers (16,090,000)
I
Total Funds Available 42,695,936
Budgeted Expenditures (31,824,5211
Estimated Working Capital 9/30/12 $ 10,871,415 (-2)
{
'1 Reserves are established in accordance with operating reserve policies.
2 Funds are designated for Capital Improvements to the Utility System.
}
r
s
r
1
i
t
4
t
t
i
tr;
k
1
r
E
f }'
I p
i
}
i
i
'r
4
t
Page 7
,
t
City of Round Rock
Budget Revision#2
Fiscal Year 2011-2012
Summary of Significant Adjustments
f
General Fund FY 2012 Explanation
G
Revenue Adjustments:
1 �
Sales Tax $ 4,286,900 Increase in Sales Tax Revenues f
Property Taxes 99,000 Revenues higher than anticipated
Capitalized Lease Proceeds 313,000 Annual Lease Program j
Emergency Services Organization 73,800 Reimbursement from Williamson ESO
NRPA Grant 15,000 Parks&Recreation Trail Enhancement I
Transfer from Municipal Court Fund 119,500 Funding for School Crosswalk Upgrades
Franchise Fees 839,000 Increase in Electric,Cable Franchise Fees
Recreation Programs Revenues 198,000 Revenues higher than anticipated
FTA Reimbursement _ 54,000 Agreement for Demand Response received mid-year x
UASI Grant 200,000 Reimbursement for Grant expenditures #
Training Fees (12,500) Fire Department no longer receiving reimbursement
Separate Fund for PEG Fees(previously in General
PEG Fees (225,000) Fund)
Interest Income (205,000_) Income less than anticipated E
Includes charges for garbage services,library&police
Miscellaneous Fines&Fees 90,700 fines [ g
h
Total Revenue Adjustments-General Fund $ 5,846,400
t
Expenditure Adjustments:
s
2013 Self Financed Construction $ 7,610,625 To be allocated by Council
Transfer to Pavement Management Program 1,250,000 Transfer funds to Pavement Management Program ( j
Salary Savings (1,258,000) Departmental salary savings _
Dell Payment 362,000 Increase due to increased Dell sales taxes collections
Contractual Services Savings (1,079,900) Departmental savings(power&light,fuel,training)
Pavement Management Program (1,250,000) Originally included as General Fund expenditure
Grant Expenditures 15,000 Trail improvements funded through grant
School Crosswalk Upgrades 119,500 Funded from Municipal Court Fund and General Fund
Fire Department Analysis 68,400 Comprehensive analysis of Fire Department
Vehicle Maintenance Facility Equipment 8,775 Equipment for Fuel System F
Total Expenditure Adjustments-General Fund $ 5,846,400
i
Utility Fund FY 2012 Explanation
i
t
I k:
Revenue Adjustments:
t
I
None
Total Revenue Adjustments-Utility Fund $
Expenditure Adjustments: l
Transfer to Self Financed Water Construction $ 6,000,000 Transfer from Fund Balance j
Transfer to Self Financed Wastewater Construction 2,000,000 Transfer from Fund Balance 1 t
Total Expenditure Adjustments-Utility Fund $ 8,000,000
,
i
i
'r
Page 1
FILED AND RECORDED i • -
OFFICIAL PUBLIC RECORDS 2013020664
E. A.►`
03/07/2013 01:23 PM
MARIA $52.00
NANCY E. RISTER, COUNTY CLERK
WILLIAMSON COUNTY, TEXAS
i
s
Y
4
{
}
}
i
3
s
r.
P
i
k
2
A
k.
i
f'
t
t
3 CITY OF ROUND ROCK
221 EAST MAIN STREET
ROUND ROCK, TX 78664
3'
i
I
IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII ITRV
I PGS 2013067899 i
3
s
THE STATE OF TEXAS
COUNTY OF TRAVIS
CITY OF ROUND ROCK
i
I, SARA L. WHITE, City Clerk of the City of Round Rock, Texas, do hereby certify that I am
4
the custodian of the public records maintained by the City and that the above and foregoing is
a true and correct copy of Ordinance No. G-12-10-25-11, which adopts Amendment No. 2 to the j
FY 2011 — 2012 Operating Budget of the City of Round Rock. This ordinance was approved by
i
the City Council at a regular meeting on the 11th day of October 2012 and adopted on the 25th
day of October 2012. This ordinance is recorded in the official City Council Minute Book No.
60.
I
CERTIFIED by my hand and seal of the City of Round Rock, Texas on this 7th day of
I
March 2013.
SARA L. WHITE,TRMC, City Clerk
a °1
'f I
SEAL
i
i
F
1
4
S
E
i
G-1�- -� -T I-
AN
NO. t
i
AN ORDINANCE ADOPTING AMENDMENT NO. 2 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:
a
That the operating budget for the City of Round Rock, Texas for Fiscal Year 2011-2012 F
I
is hereby revised for municipal purposes pursuant to §102.010, Local Government Code and in
1
accordance with the proposal submitted to the Council by the City Manager, which proposal is
3
f i
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
` 4
of the attached revised budget with the County Clerk of Williamson County, Texas. f
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
k
meeting was open to the public as required by law at all times during which this Ordinance and ;
i
the subject matter hereof were discussed, considered and formally acted upon, all as required by
3
the Open Meetings Act, Chapter 551, Texas Government Code, as amended.
JM �
READ and APPROVED on first reading this the ( day of
4 I
I
2012. ;
READ, APPROVED and ADOPTED on second reading this the l 'day of
' 2012. F
I
k
i
i
ALAITIMCGRAW, Mayor f
ATTEST: City of Round Rock, Texas
SARA L. WHITE, City Clerk
O\wdox\SCC1nts\0112\1204\MUNICEPAL\00259364.DOC/mc
d
P
{
i
- -- - i
City of Round Rock, Texas
k
Budget Revision#2
Fiscal Year 2011-2012
2011-2012 2011-2012 2011-2012
Original Revised Revised Revision#2
GENERAL FUND Budget Budget#1 Budget#2 Variance j
k
Revenues $ 83,345,350 $ 84,040,759 $ 89,887,159 $ 5,846,400
c
Expenditures (83,345,011) (84,040,420) (89,886,820) (5,846,400)
Total Change in Fund Balance $ 339 $ 339 $ 339 $ -
s
DRAINAGE FUND
t
Revenues $ 1,650,000 $ 1,650,000 $ 1,650,000 $
Operating Expenditures (1,549,863) (1,549,863) (1,549,863) -
Change in Working Capital $ 100,137 $ 100,137 $ 100,137 $
i
UTILITY FUND
Revenues $ 39,915,124 $ 39,915,124 $ 39,915,124 $ -
E i
Operating Expenditures (39,914,521) (39,914,521) (47,914,521) (8,000,000)
Change in Working Capital $ 603 $ 603 $ (7,999,397) $ (8,000,000)
j I
t
i
i
F
$� S
i
f
{
E"
BIT
"A"
f
Page 1
4
City of Round Rock, Texas s
Budget Revision#2 f
Fiscal Year 2011-2012
)
2011-2012 2011-2012 2011-2012
Original Revised Revised Revision#2
GENERAL FUND Budget Budget#1 Budget#2 Variance I
t
Revenues $ 83,345,350 $ 84,040,759 $ 89,887,159 $ 5,846,400
t k
i
DEPARTMENT
Administration-12 $ (2,301,666) $ (2,152,957) $ (2,152,957) $ -
DSO-31 (599,991) (613,197) (637,197) (24,000)
Finance-17 (1,655,964) (1,697,819) (1,668,819) 29,000
)
Fire-22 (13,295,919) (14,067,865) (14,067,865) - a
g
Fiscal Support Services-19 (11,032,363) (10,102,363) (10,464,363) (362,000)
Gen. Srvcs.-Bldng Const.&Facility Main.-35 (1,300,333) (1,341,693) (1,341,693)
i s
Gen.Srvcs. -Vehicle Main. Facility-28 (1,136,349) (1,144,492) (1,153,267) (8,775)
Human Resources-24 (1,096,850) (1,087,087) (949,087) 138,000
K
Information Technology-15 (3,716,951) (3,906,037) (3,543,037) 363,000
Inspection Services-16 (1,294,089) (1,327,949) (1,303,949) 24,000 f
Legal Services-13 (1,000,250) (1,000,250) (1,246,250) (246,000)
)
Library-20 (2,352,039) (2,350,234) (2,300,234) 50,000 s
Municipal Court-29 (753,952) (762,436) (712,436) 50,000
r
Parks&Recreation-23 (9,034,723) (9,125,579) (8,850,579) 275,000
e
t
Planning&Development Services-14 (1,298,179) (1,290,738) (1,238,738) 52,000
i
Police-21 (23,163,826) (23,655,435) (23,137,435) 518,000
i
Purchasing-18 (597,601) (613,360) (569,360) 44,000
t
Transportation-Administration-27 (2,065,482) (2,121,037) (1,569,037) 552,000
i
Transportation-Operate&Maintain-34 (5,648,484) (5,679,892) (4,119,892) 1,560,000
s t
General Government-Transfer - - (8,860,625) (8,860,625) r
Total Expenditures $ (83,345,011) $ (841040,420) $ (89,886,820) $ (5,846,400)
4
q
i
t
fE
i t
4
S
S
Page 2
b
k
t
City of Round Rock, Texas
Budget Revision#2
r
Fiscal Year 2011-2012
2011-2012 2011-2012 2011-2012
Original Revised Revised Revision#2
DRAINAGE FUND Budget Budget#1 Budget#2 Variance
Revenues $ 1,650,000 $ 1,650,000 $ 1,650,000 $ - f
f
DEPARTMENT
Drainage-86 $ (1,549,863) $ (1,549,863) $ (1,549,863) $
Total Expenditures $ (1,549,863) $ (1,549,863) $ (1,549,863) $ -
t
i
I
s
s
Off
I
3
ff�
l
3E
P
E
7 S
f
F I
t }
i
i
I
I
s
i
I
4
t
4
i
f [
I !{
4 i
jfS �
[
y t
I
i
j
{i I§
E S
Page 3
S I
t
i
e
City of Round Rock, Texas
Budget Revision#2
Fiscal Year 2011-2012 i
i
2011-2012 2011-2012 2011-2012
Original Revised Revised Revision#2
UTILITY FUND Budget Budget#1 Budget#2 Variance
I
Revenues $ 39,915,124 $ 39,915,124 $ 39,915,124
t
� f
DEPARTMENT }
Utility Administration-40 $ (1,280,953) $ (1,305,001) $ (1,305,001) $ -
q
Utility Billings&Collections-81 (1,394,275) (1,427,553) (1,427,553) -
Utility Environmental Services-64 (552,650) (563,443) (563,443) -
4
Wastewater Line Maintenance-63 (1,901,033) (1,927,048) (1,927,048) -
(
Wastewater Systems Support-62 (2,521,086) (2,533,208) (2,568,208) (35,000)
I
Wastewater Treatment Plant-61 (4,328,302) (4,328,302) (4,328,302) -
Water Line Maintenance-43 (2,350,738) (2,384,716) (2,384,716) - }
Water Systems Support-42 (3,230,980) (3,275,267) (3,275,267) -
Water Treatment Plant-41 (8,729,504) (8,754,983) (8,754,983) - g
Transfers-95 (13,625,000) (13,415,000) (21,380,000) (7,965,000)
s
General Government-Other - - - -
)
Total Expenditures $ (39,914,521) $ (39,914,521) $ (47,9141521) $ (8,000,000)
r
a
f
! Y
4
S
t
S
1 t
Y!
F S
is
t
f �
f
4
i
i
I
I
i
S
T
s P
Page 4
if
{F
C
i
e
F
City of Round Rock, Texas
Budget Revision#2
Fiscal Year 2011-2012
General Fund-Effect of the revision on fund balance:
Fund Balance 10/01/11 $ 40,542,118
Less Reserves('1) (31,312,651) ` I
3
Estimated Revenue(FY 2011-2012) 86,897,059 1
i
Interfund Transfers 2,990,100
i
Total Funds Available 99,116,626
I
Budgeted Expenditures (89,886,820)
S
Estimated Unreserved Fund Balance 9/30/12 $ 9,229,806
i
i
1 Reserve requirements established in accordance with operating reserve policies. s
f
Note-This revision increases the FTE count in PARD by.25 to correct for a prior reorganization,transfers one FTE from Police to
Administration for the Special Events Coordinator position,and activates a new FTE in Administration for the Neighborhood
Development Coordinator position.
(
s
a
t {
5 f
}
C
P.
� I
t
F
P
SIS
f
S
4
i }
i
1
4! (
1 2
i.
E
Page 5
1
(
City of Round Rock, Texas
i
Budget Revision#2
Fiscal Year 2011-2012 £
i
Drainage Fund-Effect of the revision on fund balance:
i g
Fund Balance 10/01/11 $ 573,000
Less Reserves("1) (511,455)
i
Estimated Revenue(FY 2011-2012) 1,650,000 E'
i
Interfund Transfers -
Total Funds Available 1,711,545
r
Budgeted Expenditures (1,549,863)
Estimated Working Capital 9/30/12 $ 161,682 y
1 Reserves are established in accordance with operating reserve policies. n
4,
j
Y
E
s
1 1
Y
F �:
if
k f€6
p�
i
_ t
{{Y
t� L
Y
i y
G
C
i
i k
LL
1
i
L
i
' e
Page 6 '
i
i
)
k
City of Round Rock, Texas E
Budget Revision#2
Fiscal Year 2011-2012
t I
k
Utility Fund-Effect of the revision on working capital:
Estimated Working Capital 10/01/11 $ 36,120,040
Less Reserves(*1) (17,249,228)
Estimated Revenue(FY 2011-2012) 39,915,124 K
}
Interfund Transfers (16,090,000)
Total Funds Available 42,695,936
Budgeted Expenditures (31,824,521)
Estimated Working Capital 9/30112 $ 10,871,415 ('2)
i
*1 Reserves are established in accordance with operating reserve policies.
*2 Funds are designated for Capital Improvements to the Utility System.
i
3 t
F
4
4
f
1 fi
t
s
1
i
2
i
i
i
,
k
a
x
i
4
i
t
a:
Page 7
J
i
3
3
City of Round Rock
Budget Revision#2
Fiscal Year 2011-2012
Summary of Significant Adjustments
z
� R
General Fund FY 2012 Explanation
i
f((
Revenue Adjustments: C
Sales Tax $ 4,286,900 Increase in Sales Tax Revenues 1 p
` Property Taxes 99,000 Revenues higher than anticipated
Capitalized Lease Proceeds 313,000 Annual Lease Program
Emergency Services Organization _ 73,800 Reimbursement from Williamson ESO
NRPA Grant 15,000 Parks&Recreation Trail Enhancement
Transfer from Municipal Court Fund 119,500 Funding for School Crosswalk Upgrades
Franchise Fees 839,000 Increase in Electric,Cable Franchise Fees t
R
Recreation Programs Revenues 198,000 Revenues higher than anticipated y
FTA Reimbursement _ 54,000 Agreement for Demand Response received mid-year i N
UASI Grant 200,000 Reimbursement for Grant expenditures s
Training Fees (12,500) Fire Department no longer receiving reimbursement '
Separate Fund for PEG Fees(previously in General
PEG Fees (225,000) Fund)
Interest Income (205,000) Income less than anticipated
Includes charges for garbage services,library&police
Miscellaneous Fines&Fees 90,700 fines }
i
Total Revenue Adjustments-General Fund $ 5,846,400
Expenditure Adjustments:
2013 Self Financed Construction $ 7,610,625 To be allocated by Council
Transfer to Pavement Management Program 1,250,000 Transfer funds to Pavement Management Program
Salary Savings (1,258,000) Departmental salary savings
Dell Payment 362,000 Increase due to increased Dell sales taxes collections
Contractual Services Savings (1,079,900) Departmental savings(power&light,fuel,training)
Pavement Management Program (1,250,000) Originally included as General Fund expenditure t
Grant Expenditures 15,000 Trail improvements funded through grant
School Crosswalk Upgrades 119,500 Funded from Municipal Court Fund and General Fund
t
Fire Department Analysis _ _ 68,400 Comprehensive analysis of Fire Department
Vehicle Maintenance Facility Equipment 8,775 Equipment for Fuel System
Total Expenditure Adjustments-General Fund $ 5,846,400
b
}
Utility Fund FY 2012 Explanation ;
3 (
Revenue Adjustments:
None $
)
Total Revenue Adjustments-Utility Fund $
Expenditure Adjustments:
Transfer to Self Financed Water Construction $ 6,000,000 Transfer from Fund Balance
Transfer to Self Financed Wastewater Construction 2,000,000 Transfer from Fund Balance
Total Expenditure Adjustments-Utility Fund $ 8,000,000
t `s
i
i
i
i
E
t
4
Page 1 �
e
4
c
t
t
,
}
f
4
i'
S
Y
1
FF
i
E
THE CITY OF ROUND ROCK £
221 EAST MAIN
ROUND ROCK TX 78664
E;
Recorders Memorandum-At the time of recordation
this instrument was found to be inadequate for the best
reproduction,because of illegibility,carbon or
photocopy,discolored paper,etc.All blockouts,
additions and changes were present at the time the
instrument was filed and recorded. p
fi
g
FILED AND RECORDED
a
OFFICIAL PUBLIC RECORDS 1
t
Apr 16, 2013 12:09 PM 2013067899
VANHOOSERJ: $56.00 s
Dana DeBeauvoir, County Clerk
Travis County TEXAS
k
3
s
P
Iy'
¢P
j