HomeMy WebLinkAboutQuarterlyReport_2010-06-30
Financial Report and Investment Report
for Quarter Ended June 30, 2010
TABLE OF CONTENTS
I. Executive Summary
Quarterly Financial Analysis ................................................................................. 1-3
Investments .......................................................................................................... 3-4
Internal Control ........................................................................................................ 5
Capital Projects ....................................................................................................... 5
II. Reports
General Fund Revenue & Expense Comparison 2009/2010 .................................. 6
Investment Report - City ......................................................................................... 9
Major Fund Revenue Comparison ........................................................................ 12
Investment Report – GTEC/GEDCO ................................................................ 14-21
Pending Grants ..................................................................................................... 22
Internal Audit Report Summary ............................................................................. 23
Bids Awarded ........................................................................................................ 24
Capital Improvement Project Summary – General Projects .................................. 25
Capital Improvement Project Summary – Facilities/GUS Projects ........................ 26
Capital Improvement Project Summary - GTEC ................................................... 28
3rd Fiscal Quarter – 2010
Executive Financial Summary
Executive Summary
Quarter ended 6/30/10
I. Quarterly Financial Analysis
General Fund Revenues:
General fund revenues collected through the end of the third quarter of fiscal 2010 are slightly higher than prior year
collections totaling $28 million or 96% of current year projections; an increase of 2.9% over prior year.
Property tax revenues are typically received during the
first two quarters of the fiscal year. The amount of
revenue is based on the assessed value and is
estimated using the County Assessor’s data. Any
deviations from estimates in this revenue stream are
typically related to new construction and delinquency
rates. Property tax revenues are up 7.34%. As of the
end of the quarter, 100.8% of the budgeted property
tax levy has been received. This is greater than 100%
due to the acual levy for 2009 being higher than
anticipated once the appeals process was completed.
This is a positive variance over the previous year’s
collection rate of 97.6% at this point in 2009.
$3.8 million of sales tax revenue has been collected for sales generated October 2009 through May 2010. Collection
revenue is up 4.3% compared to previous year. Sales tax projections were increased after seeing actual collection
activity. The City also collects 1/8 cent sales tax to be used toward the reduction of property taxes.
Court fines are up 5.4% from prior year with 10,162 cases processed during the third quarter versus 9,827 processed
in the prior year’s third quarter.
The City collects a 4 – 5% franchise fee on electrical, natural gas, cable, solid waste, and telephone revenues provided
by entities other than the City. The City has collected $1,061,250 or 85% of current year projections through the end of
the quarter. The City also collects a 2% franchise fee and an 8% return on investment fee from the City owned utilities
which totaled respectively, $1,014,183 and $4,199,905 through June or 66% of projections. These collections are
down 1.4% from prior year. These fees are expected to meet projections by the end of the year due to the majority of
the summer month billings being recognized in the last quarter of the fiscal year.
Development related revenue is up $68,830 or 11.9%
from prior year. The revenues are also at 81% of
projections with three months of the year remaining.
As the economy strengthens, development activity will
increase and be reflected in future budgets.
Overall, General Fund revenues are slightly ahead of
last year. Miscellaneous revenue has a negative
variance due to the decreased interest earnings and
contract with the emergency service district. The
other revenue categories are holding their own
compared to 3rd quarter of 2009.
1
3rd Fiscal Quarter – 2010
Executive Financial Summary
General Fund Expenditures:
General fund expenditures through the end of the third fiscal quarter of 2010 are on par with prior year. This is
due to staff maintaining the budget contingency mode of minimal or reduced spending.
Salaries and benefit expenditures year to date reached $15.4 million or 71% of projections. An additional $11 million or
79% of budget was spent on operations.
The Community Development Division provides resources for planning and development, as well as, building permit
and inspection processing. Personnel expenditures were $1,238,061 or 71% of projections. This is down 7.3%
compared to the prior year’s third quarter due to open/non-frozen positions.
The Finance Division includes court fine processing
through Municipal Court. Operating expenditures for
the quarter are down 16.6% from the prior year. The
reduction in expenditures is a result of lower internal
service fund allocations and lower contract
expenditures for Williamson Central Appraisal District.
Expenditures for Public Safety for the third quarter are
75% of projections with a total of $7.1 million. This is
slightly less than previous year.
Management Services includes City Management, Council, Public Information and social service funding. Total
expenditures year to date are $3.2 million and is slightly lower than prior year. Lower internal service fund allocations
contribute to the reduction in expenditures.
Community Services includes parks and recreation expenditures. Current expenditures total $4.9 million compared to
$4.7 million in the prior year. Expenditures have increased 5.2% due to the necessary operational expenses to offer
the current level of programming.
Utility Revenues:
Electric Revenue is over 8.5% greater than third quarter 2009. Collections of $41.3 million or 67% of current year
projections was received through June 2010, compared to $38.1 million received at this time last year.
Wastewater revenue is slightly up at 1.58% from last year. This revenue has leveled out as the year progresses. Tap
revenue is up 21.4% compared to the same time last year. Other revenue is down from the prior year due to interest
earnings being significantly less.
Water revenue is down 12.2% due to a wetter fall and summer compared to previous year. As with wastewater, tap
revenue is up. Interest revenue is less than prior year’s third quarter causing other revenue to be down 5.4% from last
year.
Utility revenues are significantly impacted by growth and weather conditions. Slowdown in the economy and housing
market continue to impact future revenues. Staff will monitor these trends over the upcoming months to identify areas
that may impact the current budget and 2010/11 CIP implementation.
Other Revenues:
Hotel Occupancy Tax revenue is 4.6% lower than prior year due to the slowdown of the economy, as well as the
closure of the Holiday Inn Express for renovations for half the fiscal year. Staff will continue to monitor revenues
2
3rd Fiscal Quarter – 2010
Executive Financial Summary
closely to evaluate the operating budget for the upcoming year. Future revenues could continue to decrease as a
result of the slowing economy, although, new properties at IH35 and Northwest Blvd and the reopening of the property
that was Holiday Inn Express could dramatically improve next year’s revenue projections.
Fuel revenues at the airport are higher than prior year due to the fluctuation in gas prices. This increase will be
reflected in the current year fuel margin.
II. Investments
Compliance Statement:
The investment activity and strategies described in this report are in compliance with the Public Funds
Investment Act, City’s investment policy, and generally accepted accounting principles. This report includes the
investment position of the City at the end of the third fiscal quarter 2010.
Activity for the quarter primarily related to the bond sale, maturity of higher yielding securities, and certificates of
deposit and the lack of reinvestment opportunities. Due to a flattening yield curve, funds have been reinvested in
overnight investment pools. Bonds were sold on April 27, 2010 for stormwater & water system improvements,
automated meter reading/customer information system (AMR/CIS) replacement project, land purchase and
transportation improvements.
The Investment Report for the Quarter Ended June 30, 2010 and the supporting schedules are attached. A
summary of the investment balances at June 30, 2010 compared to the prior quarter is shown below for the City
and both component units.
CITY GTEC GEDCO
3/31/10 6/30/10 3/31/10 6/30/10 3/31/10 6/30/10
Total cash and security
investments
$64,777,623 $80,384,427 $16,783,153 $16,527,229 $3,019,243 $3,224,308
Unrealized gain $19,772 $8,688 $10,863 $1,305 $242 $474
Realized gain (loss) for
quarter
$0 $0 $0 $0 $0 $0
The cash yield curve flattened in June due
to economic statistics being weaker than
anticipated. It appears unlikely the Federal
Reserve will raise benchmark rates until
November or December. Policymakers
noted the absence of inflationary pressures
as a reason to leave rates alone. Three
month Treasury bills yielded 0.18% for the
quarter, while one-year bills were at 0.31%.
Two year notes are near an all time low at
0.61%.
9/30/09 12/31/09 3/31/10 6/30/10
Managed portfolio yield 1.10% 0.81% 0.53% 0.43%
3
3rd Fiscal Quarter – 2010
Executive Financial Summary
The City’s investment strategy is to “ladder” or
stagger maturities, thus minimizing erratic interest
rate fluctuations. The current unrealized gain in the
portfolio is due to higher yielding securities
purchased before market interest rates fell. The
interest income, from these securities, diversifies
and enhances the yields from shorter-term deposits
and investments. Maintaining safety of principal
and adequate liquidity remain the City’s investment
portfolio objectives. Total managed portfolio yield
was 0.43% on an annualized basis. The overall
yield is higher than the yield trend for the 3-month
Treasury bill and the local government pools which are currently at 0.15% and 0.14% respectively, as of June
2010.
City portfolio balances have increased in the last few years in direct correlation to the increase in contingency
reserves and debt proceeds issued for capital improvement projects. The City’s investment portfolio includes
bank deposits, local government investment pool balances, and federal agency and instrumentality securities. All
of these investments carry insurance or an implied backing from the Federal Government.
Market conditions have created value in non-depository bank deposits. These deposits are insured or
collateralized as required by Policy and state law. The Certificate of Deposit Account Registry Service (CDARS)
allows the City to deposit funds with a Texas financial institution. That institution then “spreads” the funds to
other banks throughout the CDARS system to effectively insure the total deposit. The Bank of New York acts as
custodian and functions to prevent deposits in excess of FDIC insurance levels at any one CDARS bank. Note:
With the temporary nature of the increased FDIC level, CDARS has chosen to maintain $100,000 deposit
limitations. The City’s CDs through the CDARS program earn between 1.87% and 2.29%.
Laurie Brewer, Assistant Finance Director
Micki Rundell, Chief Financial Officer
4
3rd Fiscal Quarter – 2010
Executive Financial Summary
III. Internal Control
Internal Control Program:
Internal controls are the practices performed by departments to provide management with reasonable assurance
that assets are safeguarded and transactions are authorized, valid, complete, and accurate. Elements of a good
internal control system include 1) separation of duties; 2) authorization; 3) documentation; and 4) reconciliation.
During the 3rd quarter of the fiscal year several audits were performed and reported. These internal audits
validate the accuracy and validity of the City’s financial records by detail testing on individual transactions and
ensuring compliance with City’s financial and administrative policies. Areas reviewed include:
A Travel audit was performed by reviewing individual expense reports and evaluating receipts to
ensure compliance with current travel policies.
A procurement card audit was done to ensure compliance with current purchasing policies.
A Long Distance usage Audit was performed to prevent excessive use. All bills greater than $1 are
evaluated and substantiated.
Fuel usage was audited comparing gallons purchased with monthly usage to verify amounts.
Petty Cash and cash drawer audits were performed at various locations to verify cash on hand.
A development fee audit was performed by taking a random sample of Planning and Zoning approved
items and correlating them to the development payment receipts in the financial system.
A municipal court audit was performed by looking at cases whereby community service or jail time
credit was granted by the Judge. In these cases, no payment was received therefore documentation
is crucial.
No other material weaknesses or issues were discovered. All identified items have been or are being
addressed by each department.
A copy of the audit results is included on page 23 of this report.
IV. Capital Projects
Capital Improvement Program:
The projects in the Capital Improvement Program (CIP) generally consists of infrastructure and related
construction and do not include small capital items such as furniture, equipment, and vehicles. Significant
maintenance projects, such as street overlay are not included in the capital project schedules.
These maintenance type projects are not capitalized as a fixed asset and are always cash-funded therefore, are
considered operational in nature and are included in the departmental operating budget.
A report showing the current year budget status as well as, project to date information on the approved capital
improvement projects is included in the quarterly financial report. Information on projects completed during the
quarter is also provided for review.
5
CITY BALANCE COMPARISON BY QUARTER - June 30, 2010
Balance Balance Balance Balance
INVESTMENT BALANCES BY TYPE 9/30/09 12/31/09 3/31/10 6/30/10
U. S. GOVERNMENT AGENCY SECURITIES 7,035,474 5,018,648 2,009,087 1,000,814
TEXPOOL 11,342,233 15,842,473 20,888,632 20,485,061
TEXSTAR 17,743,726 25,170,405 21,842,247 36,731,357
JPMORGAN CHASE- Overnight Investment 2,230,212 2,463,889 2,963,943 5,081,846
JPMORGAN CHASE - Local Depository 99,307 147,147 93,029 91,987
VIEWPOINT BANK - Money Market 112,333 136,157 173,785 137,495
TEXAS CAPITAL BANK - Money Market 240,076 240,372
CERTIFICATES OF DEPOSIT - CDARS PROG. 14,039,326 10,569,337 6,062,665 6,084,006
CERTIFICATES OF DEPOSIT - RBANK 2,000,000 2,010,107
CERTIFICATES OF DEPOSIT - VIEWPOINT 8,504,159 8,521,382
TOTAL CASH AND INVESTMENTS 52,602,611 59,348,056 64,777,623 80,384,427
Note: Balances shown are at book value.
City
City Investment Balances
6/30/2010
Types of Investments
6/30/2010
6
PORTFOLIO SUMMARY - By Maturityyy
08/09 09/10 09/10 09/10
Maturity Time Frame 4th Quarter 1st Quarter 2nd Quarter 3rd Quarter
0-6 Months 44,555,910 51,288,769 53,213,059 70,818,274
6-12 Months 2,025,693 4,036,215 5,528,961 7,556,046
12-18 Months 4,009,442 4,023,072 4,035,603
18-36 Months 2,011,566 2,000,000 2,010,107
52,602,611 59,348,056 64,777,623 80,384,427
Long term investments, securities with a 12 month or greater maturity, decreased to 2.5% for this quarter ended June
30, 2010. Maturities are matched with projected disbursement requirements, such as capital improvement projects
and debt service payments, thus maintaining a staggered maturity schedule that hedges the portfolio from market
volatility is recommended. Eighty-eight percent of the portfolio will mature within the next six months, with another 9%
maturing within 12 months. These maturities match buildout and funding of current projects, as well as, debt service
payments due in February and August.
08/09 09/10 09/10 09/10
Liquidity Indicators 4th Quarter 1st Quarter 2nd Quarter 3rd Quarter
Weighted Average Maturity 98 57 89 51
Maturities < 12 months 88.55%93.22%90.68%97.50%
Long term investments, securities with a 12 month or greater maturity, decreased to 2.5% for this quarter ended June
30, 2010. Maturities are matched with projected disbursement requirements, such as capital improvement projects
and debt service payments, thus maintaining a staggered maturity schedule that hedges the portfolio from market
volatility is recommended. Eighty-eight percent of the portfolio will mature within the next six months, with another 9%
maturing within 12 months. These maturities match buildout and funding of current projects, as well as, debt service
payments due in February and August.
Maturities 12 months 88.55%93.22%90.68%97.50%
Long term investments, securities with a 12 month or greater maturity, decreased to 2.5% for this quarter ended June
30, 2010. Maturities are matched with projected disbursement requirements, such as capital improvement projects
and debt service payments, thus maintaining a staggered maturity schedule that hedges the portfolio from market
volatility is recommended. Eighty-eight percent of the portfolio will mature within the next six months, with another 9%
maturing within 12 months. These maturities match buildout and funding of current projects, as well as, debt service
payments due in February and August.
Long term investments, securities with a 12 month or greater maturity, decreased to 2.5% for this quarter ended June
30, 2010. Maturities are matched with projected disbursement requirements, such as capital improvement projects
and debt service payments, thus maintaining a staggered maturity schedule that hedges the portfolio from market
volatility is recommended. Eighty-eight percent of the portfolio will mature within the next six months, with another 9%
maturing within 12 months. These maturities match buildout and funding of current projects, as well as, debt service
payments due in February and August.
Long term investments, securities with a 12 month or greater maturity, decreased to 2.5% for this quarter ended June
30, 2010. Maturities are matched with projected disbursement requirements, such as capital improvement projects
and debt service payments, thus maintaining a staggered maturity schedule that hedges the portfolio from market
volatility is recommended. Eighty-eight percent of the portfolio will mature within the next six months, with another 9%
maturing within 12 months. These maturities match buildout and funding of current projects, as well as, debt service
payments due in February and August.
7
TRANSACTION LISTING - SECURITIES - June 30, 2010
Purchase Maturity / Discount / Par Investment
Date Description Call Coupon Value Yield Comments
PURCHASES:
There were no purchases this quarter.
MATURITIES:
12/19/07 Federal Home Loan Bank (FHLB)06/30/10 5.00% 1,000,000 3.93% Ongoing staggered maturity
Source: Operating / Reserves investment strategy
ALL SECURITIES REDEEMED AT MATURITY, THEREFORE NO GAIN OR LOSS WAS REALIZED.
8
INVESTMENTS OUTSTANDING - June 30, 2010
3/31/10
Purchase Invest Par Coupon Book Market Book Accrued Investment Market Unrealized
Date Description Number Maturity Value Yield Value Value Value Interest Yield Value Gain/Loss
U. S. GOVERNMENT AGENCY SECURITIES:
1/30/08 Federal Home Loan Mortgage Corp (FHLMC) 3128X33F8 1/25/10 1,000,000 4.38% Matured - - - - - Source: Operating / Reserves
3/6/08 Federal Farm Credit Banks (FFCB) 31331YSR2 2/8/10 2,000,000 2.63% Matured - - - - -
Source: Operating / Reserves
12/19/07 Federal Home Loan Bank (FHLB) 31339XNW0 6/30/10 1,000,000 5.00% 1,002,638 1,013,070 Matured - - - - - - - - - - - - - - - - - - - -
Source: Operating / Reserves
3/6/08 Federal Home Loan Bank (FHLB)31339YGY2 7/14/10 1,000,000 5.00% 1,006,450 1,014,879 1,000,814 12,500 2.66% 1,002,873 2,059
Source: Operating / Reserves
TOTAL INVESTMENT SECURITIES 2,009,088 2,027,949 1,000,814 12,500 1,002,873 2,059
TexPool 6/30/10 20,888,632 20,887,796 20,485,061 20,486,290 1,229TexSTAR6/30/10 21,842,247 21,843,994 36,731,357 36,736,757 5,400
Certificates of Deposit - R Bank 3/24/12 2.00% 2,000,000 2,000,000 2,010,107 2.00% 2,010,107
Certificates of Deposit - ViewPoint Bank various various 8,504,159 8,504,159 8,521,382 various 8,521,382Certificates of Deposit - CDARS various various 6,062,665 6,062,665 6,084,006 various 6,084,006
TOTAL INVESTMENT BALANCES 61,306,791 61,326,563 74,832,727 12,500 74,841,415 8,688
CITY DEPOSITORY
JPMorgan Chase**6/30/10 0.15%93,029 93,029 91,987 0.15% 91,987
JPMorgan Chase Overnight Security**6/30/10 0.15% 2,963,943 2,963,943 5,081,846 0.15% 5,081,846 Texas Capital Bank Money Market 6/30/10 0.48%240,076 240,076 240,372 0.48% 240,372
ViewPoint Bank - Money Market 6/30/10 3.00%173,785 173,785 137,495 3.00% 137,495
TOTAL CASH AND INVESTMENT BALANCES 64,777,624 64,797,396 80,384,427 12,500 80,393,115 8,688
Balances and rates as of 6/30/10.
**Funding of outstanding checks presented for payment, interest earned netted against bank service changes.
6/30/10
9
TRANSACTION LISTING - INVESTMENT POOLS - June 30, 2010
08/09 09/10 09/10 09/10
4th Quarter 1st Quarter 2nd Quarter 3rd Quarter
Balance Market Value Balance Market Value Balance Market Value Balance Market Value
Description 09/30/09 09/30/09 12/31/09 12/31/09 3/31/10 3/31/10 6/30/10 6/30/10 Comments
TexPool 11,342,233 11,346,997 15,842,473 15,845,008 20,888,632 20,887,796 20,485,061 20,486,290 AAA Rated Pool -
$1 per $1 value
Current value:
$1.00006 per $1
TexSTAR 17,743,726 17,751,161 25,170,405 25,176,018 21,842,247 21,843,994 36,731,357 36,736,757 AAA Rated Pool -
$1 per $1 value
Current value:
$1.000147 per $1
(Any changes in market value during quarter were within minimum guidelines unless noted.)
10
Balance Balance Balance Balance
INVESTMENT BALANCES BY TYPE 9/30/09 12/31/09 3/31/10 6/30/10
U. S. GOVERNMENT AGENCY SECURITIES 4,010,062 2,005,437 1,002,638
TEXPOOL 5,561,633 3,526,278 3,594,075 4,449,906
TEXSTAR 7,262,125 11,225,399 7,183,818 7,063,842
VIEWPOINT BANK - Money Market 10,815 14,876
CDARS CERTIFICATES OF DEPOSIT 1,000,000 1,000,000
CERTIFICATES OF DEPOSIT - VIEWPOINT BANK 5,002,622 5,013,481
TOTAL CASH AND INVESTMENTS 17,844,635 17,771,990 16,783,153 16,527,229
Note: Balances shown are at book value.
Liquidity Indicator / Weighted Average to Maturity 40 15 89 59
Georgetown Transportation Enhancement Corporation
For the Quarter Ended June 30, 2010
GTEC Investments GTEC Weighted Average to Maturity
Balance Balance Balance Balance
INVESTMENT BALANCES BY TYPE 9/30/09 12/31/09 3/31/10 6/30/10
TEXSTAR 1,946,500 2,096,906 3,019,243 3,224,308
VIEWPOINT BANK - Money Market 8,024 11,037
CDARS CERTIFICATES OF DEPOSIT 750,000 750,000
TOTAL CASH AND INVESTMENTS 2,704,524 2,857,943 3,019,243 3,224,308
Note: Balances shown are at book value.
Liquidity Indicator / Weighted Average to Maturity 34811
GEDCO Investments GEDCO Weighted Average to Maturity
Georgetown Economic Development Corporation
For the Quarter Ended June 30, 2010
11
GENERAL FUND REVENUE & EXPENSE COMPARISON 2009/2010
For the Quarter Ended 6/30/10
3rd QUARTER PRIOR YEAR 3rd QUARTER
TOTAL PRELIMINARY 6/30/10 %ACTUAL 6/30/09 %YTD
BUDGET PROJECTIONS YTD PROJ TOTAL YTD ACTUAL ACTUAL %
REVENUES:
Property Taxes 8,392,600 8,521,100 8,589,640 100.8% 8,195,857 8,002,127 97.6%587,513 7.34%
Sales Tax 6,494,300 6,620,000 3,831,325 57.9% 6,457,087 3,672,715 56.9%158,610 4.32%
Sales Tax (1/8 cent) 836,750 890,000 525,007 59.0% 869,426 500,327 57.5%24,680 4.93%
Franchise Fee/ROI 9,352,579 9,630,921 6,275,338 65.2% 8,954,053 6,364,417 71.1%-89,079 -1.40%
Development & Inspections 1,012,173 804,200 648,896 80.7% 791,881 580,067 73.3%68,830 11.87%
Court Fines 905,500 888,500 690,088 77.7% 889,367 654,456 73.6%35,632 5.44%
Parks & Recreation 1,647,190 1,813,220 1,609,164 88.7% 1,481,953 1,184,032 79.9%425,131 35.91%
Other 3,399,731 2,894,669 2,223,295 76.8% 3,962,501 2,809,642 70.9%-586,347 -20.87%
REVENUE WITHOUT ENVIRON. SVCS 32,040,823 32,062,610 24,392,754 76.1% 31,602,125 23,767,783 75.2%624,971 2.63%
Environmental Services 5,102,918 4,811,875 3,600,760 74.8% 4,582,794 3,443,393 75.1%157,367 4.57%
..
TOTAL REVENUES (1)37,143,741 36,874,485 27,993,514 75.9% 36,184,919 27,211,176 75.2%782,338 2.88%
(1) excludes transfers and SIP related fees
EXPENSES:
TRANSPORTATION
Personnel 978,342 948,793 663,045 69.9% 909,767 671,655 73.8%-8,610 -1.28%
Operations 951,264 764,766 615,740 80.5% 858,487 536,900 62.5%78,840 14.68%
TOTAL TRANSPORTATION 1,929,606 1,713,559 1,278,785 74.6% 1,768,254 1,208,555 68.3%70,230 5.81%
COMMUNITY DEVELOPMENT
Personnel 1,752,871 1,735,779 1,238,061 71.3% 1,801,418 1,336,089 74.2%-98,028 -7.34%
Operations 376,392 332,758 291,801 87.7% 380,512 334,135 87.8%-42,334 -12.67%
TOTAL COMMUNITY DEVELOP 2,129,263 2,068,537 1,529,862 74.0% 2,181,930 1,670,223 76.5%-140,362 -8.40%
FINANCE & ADMINISTRATION
Personnel 430,101 425,960 307,395 72.2% 411,868 309,677 75.2%-2,282 -0.74%
Operations 108,951 108,951 73,732 67.7% 104,396 88,410 84.7%-14,679 -16.60%
TOTAL FINANCE & ADMIN 539,052 534,911 381,126 71.3% 516,264 398,087 77.1%-16,961 -4.26%
FIRE
Personnel 5,916,794 5,851,099 4,213,639 72.0% 5,457,154 4,007,717 73.4%205,921 5.14%
Operations 946,834 937,082 836,469 89.3% 1,058,511 945,555 89.3%-109,086 -11.54%
TOTAL FIRE 6,863,628 6,788,181 5,050,108 74.4% 6,515,665 4,953,272 76.0%96,836 1.95%
MANAGEMENT SERVICES
Personnel 682,289 892,015 582,889 65.3% 725,860 546,887 75.3%36,002 6.58%
Operations 3,319,433 3,413,394 2,586,505 75.8% 3,543,952 2,692,279 76.0%-105,774 -3.93%
TOTAL MANAGEMENT SVCS 4,001,722 4,305,409 3,169,394 73.6% 4,269,812 3,239,166 75.9%-69,771 -2.15%
COMMUNITY SERVICES
Personnel 3,832,748 3,850,208 2,627,656 68.2% 3,579,905 2,473,867 69.1%153,789 6.22%
Operations 2,758,338 2,757,838 2,347,161 85.1% 2,793,764 2,257,177 80.8%89,984 3.99%
TOTAL COMMUNITY SERVICES 6,591,086 6,608,046 4,974,817 75.3% 6,373,669 4,731,044 74.2%243,773 5.15%
POLICE
Personnel 8,189,275 7,977,601 5,698,324 71.4% 7,698,599 5,750,490 74.7%-52,166 -0.91%
Operations 1,479,895 1,503,723 1,394,968 92.8% 1,584,510 1,429,465 90.2%-34,497 -2.41%
TOTAL POLICE 9,669,170 9,481,324 7,093,293 74.8% 9,283,109 7,179,955 77.3%-86,663 -1.21%
OPERATING EXP WITHOUT ENVIRON. SVCS.
Personnel 21,782,420 21,681,455 15,331,009 70.7% 20,584,571 15,096,382 73.3%234,627 1.55%
Operations 9,941,107 9,818,512 8,146,375 83.0% 10,324,132 8,283,922 80.2%-137,546 -1.66%
OPERATING EXPENSES 31,723,527 31,499,967 23,477,384 74.5% 30,908,703 23,380,303 75.6%97,081 0.42%
GUS (Environmental Services)
Personnel 59,802 59,897 43,767 73.1% 59,447 44,329 74.6%-563 -1.27%
Operations 4,194,506 4,045,251 2,804,960 69.3% 4,136,890 2,702,878 65.3%102,082 3.78%
TOTAL GUS 4,254,308 4,105,148 2,848,726 69.4% 4,196,337 2,747,207 65.5%101,519 3.70%
TOTAL OPERATING EXPENSES
Personnel 21,842,222 21,741,352 15,374,775 70.7% 20,644,018 15,140,711 73.3%234,065 1.55%
Operations 14,135,613 13,863,763 10,951,335 79.0% 14,461,022 10,986,799 76.0%-35,464 -0.32%
TOTAL OPERATING EXPENSES (2)35,977,835 35,605,115 26,326,111 73.9% 35,105,040 26,127,510 74.4%198,600 0.76%
(2) excludes capital related expenditures
VARIANCE
12
MAJOR FUND REVENUE COMPARISON 2009/2010
For the Quarter Ended 6/30/10
Other Major Funds:
3rd QUARTER PRIOR YEAR 3rd QUARTER
TOTAL PRELIMINARY 6/30/10 %ACTUAL 6/30/09 %YTD
REVENUES:BUDGET PROJECTIONS YTD PROJ TOTAL YTD ACTUAL ACTUAL %
Utility Fund Revenues:
ELECTRIC
Electric revenue 58,461,733 60,291,143 39,912,277 66.2% 56,154,879 36,781,877 65.5%3,130,400 8.51%
Electric tap revenue 150,000 105,900 270,440 255.4% 265,227 201,460 76.0%68,980 34.24%
Electric other revenue 1,233,800 1,619,818 1,122,709 69.3% 1,526,377 1,087,394 71.2%35,315 3.25%
TOTAL ELECTRIC REVENUE 59,845,533 62,016,861 41,305,426 66.6% 57,946,483 38,070,732 65.7%3,234,695 8.50%
WASTEWATER
Wastewater revenue 7,889,919 7,727,648 5,759,078 74.5% 7,649,538 5,646,576 73.8%112,503 1.99%
Wastewater tap revenue 75,000 130,000 165,653 127.4% 200,989 136,402 67.9%29,251 21.44%
Wastewater other revenue 679,960 548,638 467,407 85.2% 1,184,672 509,692 43.0%-42,285 -8.30%
TOTAL WASTEWATER REVENUE 8,644,879 8,406,286 6,392,138 76.0% 9,035,199 6,292,670 69.6%99,468 1.58%
WATER
Water revenue 14,303,297 12,814,605 7,980,868 62.3% 14,171,479 9,254,601 65.3%-1,273,733 -13.76%
Water tap revenue 145,000 275,000 278,289 101.2% 339,386 245,207 72.3%33,082 13.49%
Water other revenue 1,449,686 1,632,272 1,099,342 67.4% 2,416,027 1,161,426 48.1%-62,084 -5.35%
TOTAL WATER REVENUE 15,897,983 14,721,877 9,358,499 63.6% 16,926,892 10,661,234 63.0%-1,302,734 -12.22%
Other Fund Revenues:
CVB
HOT tax 350,000 250,000 213,627 85.5% 376,377 250,736 66.6%-37,109 -14.80%
Other Revenue 45,834 89,747 87,767 97.8% 62,330 65,079 104.4%22,689 34.86%
TOTAL CVB REVENUE 395,834 339,747 301,395 88.7% 438,707 315,815 72.0%-14,420 -4.57%
AIRPORT
Fuel revenue 2,300,000 1,900,000 1,359,702 71.6% 1,682,328 1,235,436 73.4%124,266 10.06%
Leases and Rents 440,880 440,880 391,003 88.7% 533,124 398,543 74.8%-7,540 -1.89%
Other revenue 86,780 81,780 31,272 38.2% 86,577 43,920 50.7%-12,647 -28.80%
TOTAL AIRPORT REVENUE 2,827,660 2,422,660 1,781,978 73.6% 2,302,029 1,677,899 72.9%104,079 6.20%
TOTAL MAJOR FUND REVENUES 87,611,889 87,907,431 59,139,436 67.3% 86,649,310 57,018,349 65.8%2,121,087 3.72%
* Does not include transfers
VARIANCE
13
Georgetown Transportation Enhancement Corporation
Investment Report
For the Quarter Ended 6/30/10
Compliance Statement
The investment activity and strategies described in this report are in compliance with GTEC’s
investment policy and state law.
The Investment Report for the Quarter Ended June 30, 2010 and the supporting schedules are
attached. Portfolio balances decreased 1.5% during the quarter. Due to the decline in market yields,
the City has invested in bank deposits outside of the City’s regular depository. Market conditions have
created value in these non-depository bank deposits. These deposits are insured or collateralized as
required by Policy and state law.
Securities purchased in prior quarters have higher yields and thus, contribute to the unrealized market
gain in the portfolio. Our investment strategy is to “ladder” or stagger maturities, thus minimizing
interest rate risk in the long-term.
A summary of the investment balances at June 30, 2010, compared to the prior quarter, is shown
below.
GTEC
3/31/10 6/30/10
Total cash and security
investments
$16,783,153 $16,527,229
Unrealized gain $10,863 $1,305
Realized gain or loss for
quarter
$0 $0
Laurie Brewer, Assistant Finance Director
Micki Rundell, Chief Financial Officer
14
GTEC BALANCE COMPARISON BY QUARTER - June 30, 2010
Balance
INVESTMENT BALANCES BY TYPE 6/30/10
U. S. GOVERNMENT AGENCY SECURITIES
TEXPOOL 4,449,906
TEXSTAR 7,063,842
VIEWPOINT BANK - Money Market
CERTIFICATES OF DEPOSIT - VIEWPOINT BANK 5,013,481
CDARS CERTIFICATES OF DEPOSIT
TOTAL CASH AND INVESTMENTS 16,527,229
Note: Balances shown are at book value.
09/10
Maturity Time Frame 4th Quarter 1st Quarter 2nd Quarter 3rd Quarter
0 - 6 months 12,516,072
6 - 12 months 4,011,157
16,527,229
Liquidity Indicator
09/1008/09
16,783,153
3,526,278
10,815
1,000,000
17,844,635
Balance
9/30/09
4,010,062
5,561,633
7,262,125
12/31/09
Balance
7,183,818
5,002,622
17,844,635 16,783,153
17,771,990
1,007,972
11,225,399
17,771,990
16,836,663 16,766,685
1,005,305
09/10
Balance
3/31/10
1,002,638
3,594,075
2,005,437
12,780,983
14,876
4,002,170
1,000,000
Weighted Average Maturity 40 15 89 59
GTEC TRANSACTION LISTING - SECURITIES - June 30, 2010
Description Comments
PURCHASES:
There were no purchases this quarter.
MATURITIES:
Federal Home Loan Bank (FHLB)Ongoing staggered maturity
Source: Operating/Reserves investment strategy
ALL SECURITIES REDEEMED AT MATURITY, THEREFORE NO GAIN OR LOSS WAS REALIZED.
YieldCoupon
Par
Value
3.93%1,000,000
as of 6/30/10
Date Call
12/19/07 6/30/10 5.00%
InvestmentPurchase Maturity / Discount /
GTEC Weighted Average to MaturityTypes of Investments
15
GTEC INVESTMENTS OUTSTANDING - June 30, 2010
6/30/10
Purchase Invest Par Coupon Book Market Book Accrued Investment Market Unrealized
Date Description Number Maturity Value Yield Value Value Value Interest Yield Value Gain/Loss
U. S. GOVERNMENT AGENCY SECURITIES:
3/10/08 Federal Farm Credit Banks (FFCB)31331YSR2 2/8/10 1,000,000 2.63% Matured - - - - - Source: Operating/Reserves
12/19/07 Federal Home Loan Bank (FHLB)31339XNW0 6/30/10 1,000,000 5.00% 1,002,638 1,013,070 Matured - - - - - - - - - - - - - - - - - - - -
Source: Operating/Reserves
TOTAL INVESTMENT SECURITIES 1,002,638 1,013,070
TexPool 6/30/10 3,594,075 3,593,931 4,449,906 4,450,173 267
TexSTAR 6/30/10 7,183,818 7,184,393 7,063,842 7,064,880 1,038
Certificates of Deposit - Viewpoint Bank various various 5,002,622 5,002,622 5,013,481 5,013,481
TOTAL INVESTMENT BALANCES 16,783,153 16,794,016 16,527,229 16,528,534 1,305
Balances and rates as of 6/30/10.
3/31/10
16
GTEC TRANSACTION LISTING - INVESTMENT POOLS - June 30, 2010
08/09 09/10 09/10 09/10
4th Quarter 1st Quarter 2nd Quarter 3rd Quarter
Balance Market Value Balance Market Value Balance Market Value Balance Market Value
Description 9/30/09 9/30/09 12/31/09 12/31/09 3/31/10 3/31/10 6/30/10 6/30/10 Comments
TexPool 5,561,633 5,563,969 3,526,278 3,526,842 3,594,075 3,593,931 4,449,906 4,450,173 AAA Rated Pool -
$1 per $1 value
Current value:
$1.00006 per $1
TexSTAR 7,262,125 7,265,168 11,225,399 11,227,902 7,183,818 7,184,393 7,063,842 7,064,880 AAA Rated Pool -
$1 per $1 value
Current value:
$1.000147 per $1
(Any changes in market value during quarter were within minimum guidelines unless noted.)
17
Georgetown Economic Development Corporation
Investment Report
For the Quarter Ended 6/30/10
Compliance Statement
The investment activity and strategies described in this report are in compliance with GEDCO’s
investment policy and state law.
The Investment Report for the Quarter Ended June 30, 2010 and the supporting schedules are
attached. Portfolio balances increased 6.8% during the quarter.
Our investment strategy is to “ladder” or stagger maturities, thus minimizing interest rate risk in the
long-term.
A summary of the investment balances at June 30, 2010, compared to the prior quarter, is shown
below.
Laurie Brewer, Assistant Finance Director
Micki Rundell, Chief Financial Officer
GEDCO
3/31/10 6/30/10
Total cash and security
investments
$3,019,243 $3,224,308
Unrealized gain $242 $474
Realized gain or loss for
quarter
$0 $0
18
GEDCO BALANCE COMPARISON BY QUARTER - June 30, 2010
Balance
INVESTMENT BALANCES BY TYPE 6/30/10
TEXSTAR 3,224,308
VIEWPOINT BANK - Money Market
CDARS CERTIFICATES OF DEPOSIT
TOTAL CASH AND INVESTMENTS 3,224,308
Note: Balances shown are at book value.
09/10
Maturity Time Frame 3rd Quarter
0 - 6 months 3,224,308
3,224,308
Liquidity Indicator
Weighted Average Maturity 34 8 1 1
GEDCO TRANSACTION LISTING - SECURITIES - June 30, 2010
Description Comments
PURCHASES:
There were no purchases this quarter.
MATURITIES:
There were no maturities this quarter.
Balance
3/31/10
Balance
12/31/09
Balance
9/30/09
2,096,9061,946,500
11,0378,024
2,704,524
3,019,243
3,019,243
750,000
09/10
2,857,943
09/10
2,704,524
1st Quarter
InvestmentPar
2,857,943
2,857,943
Date
Purchase Discount /
GEDCO Weighted Average to Maturity
Value
Types of Investments
as of 6/30/10
3,019,243
Coupon
3,019,243
2,704,524
Maturity /
2nd Quarter
YieldCall
750,000
4th Quarter
08/09
19
GEDCO INVESTMENTS OUTSTANDING - June 30, 2010
3/31/10 6/30/10
Purchase Invest Par Coupon Book Market Book Accrued Investment Market Unrealized
Date Description Number Maturity Value Yield Value Value Value Interest Yield Value Gain/Loss
U. S. GOVERNMENT AGENCY SECURITIES:
No investments in U.S. government agency securities at this time.
TOTAL INVESTMENT SECURITIES
TexSTAR 6/30/10 3,019,243 3,019,485 3,224,308 3,224,782 474
TOTAL INVESTMENT BALANCES 3,019,243 3,019,485 3,224,308 3,224,782 474
Balances and rates as of 6/30/10.
20
GEDCO TRANSACTION LISTING - INVESTMENT POOLS - June 30, 2010
08/09 09/10 09/10 09/10
4th Quarter 1st Quarter 2nd Quarter 3rd Quarter
Balance Market Value Balance Market Value Balance Market Value Balance Market Value
Description 9/30/09 9/30/09 12/31/09 12/31/09 3/31/10 3/31/10 6/30/10 6/30/10 Comments
TexSTAR 1,946,500 1,947,316 2,096,906 2,097,374 3,019,243 3,019,485 3,224,308 3,224,782 AAA Rated Pool -
$1 per $1 value
Current value:
$1.000147 per $1
(Any changes in market value during quarter were within minimum guidelines unless noted.)
21
Grant Description Grantor Grant Amount Match Notes
Planning
CBDG Grants Williamson County 458,370 ???Pending
Library
Sculpture for Hike/Bike Trail in San Gabriel Park Southwestern Univ & 3M 4,000 Pending
Police
FEMA Prehazard Mitigation Grant FEMA 1,000,000 250,000 Pending
Bulletproof Vest Program OJP 6,650 Pending
Fire
Equip/Training for Water & Dive Team CAPCOG 26,400 6,600 Pending
PPE & Washer-Extractor Assistance to FF Grant (AFG) 57,081 5,708 Pending
Response/Utility Truck Assistance to FF Grant (AFG) 42,360 4,236 Pending
Regional Rope & Rescue Training Assistance to FF Grant (AFG) 47,514 9,502 Pending
Brush Truck Apparatus Texas Forest Service 85,000 Pending
City of Georgetown
Pending Grants
as of 6/30/10
22
Audit Type Total Exceptions
Fuel Usage Report
Diesel gallons purchased 59,585 - N/A
Unleaded gallons purchased 29,569
City's average rate-diesel 2.28$
City's average rate-gasoline 2.19$
Total amount paid (including taxes) 237,311.68$
Long Distance Audits
Calls over $1.00 150 - Six personal long-distance calls were made from
Call explanations requested 86 a City phone line.
Total amount reimbursed 14.37$ - One employee's long-distance code was being used
Calls reimbursed to City 6 by an unauthorized user. The code has been cancelled
to prevent further misuse.
Payroll Audits
Payrolls audited 7 - N/A
Employee pay rates audited 263
Violations -
Stipend Audits
Payrolls audited 7 - N/A
Employee stipends audited 110
Violations -
Procurement Card Audits
Expense Reports generated 466 - Four reports were missing itemized receipts.
Total dollars spent 244,116.39$ - Two reports were missing a receipt.
Reports audited 208 - Five reports were missing food receipt descriptions.
Violations 17 - Two reports had purchases over $1,000 that were not
approved by Purchasing first.
- Two reports were approved by supervisors that were not
listed as authorized signers per their division's signature
card.
- One employee purchased a computer program not approved
by the IT Department.
- One employee purchased a phone charger for their personal
cell phone and were required to reimburse the City.
Travel Audits
Expense Reports generated 154 - One employee received per diem for a trip that was
Reports audited 120 cancelled and did not return per diem funds to the City.
Violations 5 - Three employees did not provide copies of travel receipts
with their travel reimbursement request.
- One employee did not submit a Travel Authorization Request
prior to traveling overnight.
Internal Control Report Summary
For the Third Fiscal Quarter 2009/2010
23
BID COUNCIL AMOUNT
BID NO. BID NAME DATE APPROVAL AWARDED VENDOR
201010 2009 Annual Electric System Trenching (labor only)3/4/2010 4/13/2010 750,000.00$ Pedro Construction
201011 2009 Annual Electric Overhead Const. & Maint. (labor)3/4/2020 4/13/2010 2,000,000.00$ H&B Construction
201012 2009 Annual Electric Underground Const. & Maint. (labor) 3/4/2010 4/13/2010 1,000,000.00$ Pedro Construction
201025 Swimming Pool Chemicals 3/15/2010 4/13/2010 37,360.00$ Altivia
201026 Office Supplies 2/22/2010 4/13/2010 48,000.00$ V-Quest
201027 Bank Depository RFP 3/24/2010 6/8/2010 30,000.00$ JP Morgan Chase
201028 Fiber Optic Material 2/26/2010 4/27/2010 250,000.00$ various vendors
201034 Janitorial Supplies 4/8/2010 5/11/2010 45,847.00$ Gulf Coast Paper
201035 Hot Mix Asphalt 4/19/2010 5/25/2010 370,000.00$ RTI
201036 Mosquito Spray - informal 4/19/2010 N/A 11,400.00$ Univar
201039 Vehicles 4/26/2010 5/11/2010 59,328.54$ Mac Haik and Philpott
201040 22nd Street and Austin Avenue Improvements 4/20/2010 5/25/2010 49,208.00$ Rogers Construction
201042 Renovations to Georgetown Municipal Complex 5/18/2010 6/8/2010 540,600.00$ Zapalac Reed
City of Georgetown
Bids Awarded During 3rd QUARTER 2009-2010
24
Capital Improvement Project Summary – General Projects
Third Quarter 2010
Highway Monument Sign
Project is completed and operational.
Police Evidence Storage
Project completed and in use.
Municipal Complex Renovation
Phase I construction is underway and scheduled for completion by the end
of August. Modular furniture for phase I will be installed the week following
completion and employees officed in the newly completed phase I area
will be moved in. The week following the relocation of employees, phase 2
construction will begin and is expected to take approximately 60 days to
complete.
Fire Station 5
Land purchase on DB Wood Road has been approved by Council and
closing on the property is expected on August 9, 2010. Request for
Qualifications for architectural services to provide design services for
Station 5 have been received. Approval by Council of the selection
committee members is scheduled for the August 10 Council meeting.
Once approved, the selection committee will evaluate the 24 responses
received and make a recommendation to Council.
Public Safety Facility
A site master plan is being developed by Brinkley Sargent Architects in
order to maximize the use of the 20 acre site for the Fire Station, Police
Station, Fire Administration and Public Safety training. Space needs are
currently being developed so that the facility is sized appropriately.
25
Capital Improvement Projects
For the Quarter Ended 06/30/10
Division Projected Total PTD
Project Budget Exp. Enc. Balance Budget Costs Balance Status
Facilities
6CE Fire Station 1,538 14 0 1,525 1,538 14 1,525
6AS Dtown Master Plan 26 71 (40) (4)28 77 (49)
6BI Pedestrian Bridge 0 3 (3)0010(10)
6BS Rock St Extension 678 225 (141)593 1,028 467 561
6CL Police Softwar, QED 950 694 230 26 950 924 26
68E Land acquisition 2 2 0 0 367 372 (4)
6CK SAN Equipemnt 0 100 (100)0 0 100 (100)
City Office Improvements 892 70 37 785 1,303 276 1,027 Construction
Total Facilities $4,086 1,179 (17)$2,925 $6,123 $2,819 $3,304
Recreation Center 0 (9)09 0022Complete
6AW New Library 0 0 0 0 0 0 0 Complete
Total Bond Projects 0 (9)09 0022
Parkland Development 0 8 (8)0 000
Total Parks Improvements 0 8 (8)0 000
Transportation
Total General Government CIP 4,086 1,178 (26)2,934 6,123 2,819 3,326
Streets / Transportation
Y-T-D
2009/10 (000s)Project to Date (000s)
1AZ 2007 Street Rehabs 0 (114)114 0 3,350 2,731 619 Construction
1BC 2008 Street Rehabs 0 33 (33) (0)1,535 1,959 (424)Construction
1BH Oak Tree Drive Bridge 0 54 (54) (0)1,151 632 518 Construction
1BI College St Bridge 0 15 (15)0449(45)Complete
1BJ Street Maint 2009 0 282 (276) (6)1,720 1,914 (194)
1BK Austin Ave Bridge painting 0 113 (112) (0)0 122 (122)Complete
1BL NE Inner Loop/ FM971 0 110 (109) (1)0 188 (188)
1BO DB Wood widening 1,625 289 481 854 1,727 960 767 Construction
1BP SE 1- Maple to SW Blvd 455 141 (141)455 866 411 455
1BQ CDBG Sidewalk on 22nd St (9) (4) (6)0 000
1BT Williams Dr Widening 1,500 1,500 0 0 3,000 3,000 0
2BO 2006 Annexations Eastside 0 2 0 (2)02(2)
41A Db Wood & Williamson Reloc 0 3 0 (3)03(3)
1BU Streets Rehabilitation 1,010 3 (1)1,008 1,010 2 1,008
19A 2010 Street Rehab/Maintenance 1,450 0 0 1,450 1,450 0 1,450
5AM1Curb & Sidewalk 0 28 9 (37)037(37)
Total Streets $6,031 2,455 (142)$3,718 $17,147 $12,189 $4,958
Stormwater
1BE Maple Street Culverts 910 1 (1)910 1,100 45 1,055 Construction
1BH Oak Tree Drive Bridge 10 132 (132)10 1,133 544 588 Construction
1BV Ranch Road Storm sewer 0 14 0 (14)014(14)
5AG Railroad Drainage 30 0 0 30 197 43 154 Construction
5AK Curbs & Gutters 559 0 0 559 559 0 559
5AM 2009 Curb & Sidewalks 0 111 388 (499)41 539 (498)Construction
5AF Northwest @ IH35 292 19 (19)292 325 33 292 Construction
19A Churchill Farms 14 0 0 14 14 0 14
19C Eubank Drainage Improvements 300 0 0 300 300 0 300
19D Stormwater Infrastructure 200 0 0 200 200 0 200
19E 7th & 9th Street Storm Drainage 200 0 0 200 200 0 200
Total Stormwater $2,515 278 235 $2,002 $4,069 $1,218 $2,850
26
Capital Improvement Projects
For the Quarter Ended 06/30/10
Division Projected Total PTD
Project Budget Exp. Enc. Balance Budget Costs Balance Status
Y-T-D
2009/10 (000s)Project to Date (000s)
Irrigation
5IB Pecan Branch Reuse Line 15 56 (44)2 4,272 1,211 3,061 Complete
3BB SG Peak Flow/Irrg 25 124 (99)12549(24)Complete
Total Irrigation $40 180 (143)$3 $4,344 $1,259 $3,085
Wastewater
39A WW Interceptors 2,159 1,817 (425)767 2,159 1,392 767
39B WWTP Upgrades/exp 365 101 (97)361 365 4 361
39C Lift Station Upgrades 714 171 (148)691 714 23 691
Total Wastewater $3,238 $2,089 ($671)$1,819 $26,665 $14,048 $12,618
Water
1AA 13th Street Rehab 0 29 0 (29)099(99)Complete
1AC Old Mill Non-elec 0 34 0 (34)034(34)
29A WTP Upgrade/exp 9,100 1,724 1,956 5,420 9,100 3,680 5,420
Pump Station Upgrades 2,654 1,000 1,644 10 2,654 2,644 10
29E Water Mains 2,443 972 (183)1,654 2,443 789 1,654
2BL Utility Patching- St Maint 0 2 (2)0024(24)Construction
5IB Pecan Branch Reuse Line 0 12 (12)0080(80)Complete
Total Water $14,197 $3,773 $3,404 $7,021 $36,440 $20,844 $15,596
AMI/CIS-Water
2BK AMI/CIS Upgrade 120 724 (611)7 120 113 7
4XY AMI/CIS 0 0 0 (0)00(0)
Total Water/AMI/CIS 14,317 4,497 2,793 7,027 36,560 20,957 15,603
27
Capital Improvement Projects
For the Quarter Ended 06/30/10
Division Projected Total PTD
Project Budget Exp. Enc. Balance Budget Costs Balance Status
GTEC
51A Economic Development Projects 843 0 0 843 1,785 0 1,785
5QX NW Blvd Bridge 561 101 460 1 626 585 41
5QC Southwest Bypass 1,962 327 (232)1,866 3,522 1,682 1,840 Design
5QG Arterial SE1: Inner Loop / SH 130 10,828 171 (154)10,811 10,828 17 10,811 Design
5QP 500 South Austin Avenue 70 0 0 70 903 678 224
5QW Wolf Ranch Pkwy Ext 1,000 13 (14)1,001 1,330 329 1,001 Design
51E Williamson Drive Widening 33 0 0 33 33 0 33
Total GTEC $15,298 $613 $60 $14,626 $20,414 $4,184 $16,231
Y-T-D
2009/10 (000s)Project to Date (000s)
28