2020-027 FY 2019-20 Q1 Financial ReportDate: March 20, 2020 Report No. 2020-027
INFORMAL STAFF REPORT
TO MAYOR AND CITY COUNCIL
SUBJECT:
Quarterly Financial Report for the period ending December 31, 2019.
BACKGROUND:
Attached for your review is the Quarterly Financial Report for the period ending December 31,
2019. If you have any questions or need additional information, please let me know.
STAFF CONTACT:
David Gaines, Finance Director
(940) 349-8260
David.Gaines@cityofdenton.com
About This Quarterly Financial
Report
This report has been prepared by the City of Denton’s Finance
Department. The Quarterly Financial Report is intended to provide
our users (internal and external) with information regarding the City’s
financial position and economic activity. This report includes
information for the quarter ending December 31, 2019.
This report is presented in four sections.
1. The Executive Dashboard section contains a high level
summary of the major operating funds using graphic
illustrations and key economic indicators. Narrative disclosures
are also included to highlight any significant changes or
fluctuations.
2. The Financial Summary section reports the performance of the
major operating funds of the City. In addition, the report
provides an end of year projection and a comparison to the
budget for major revenue sources and expenditure items.
3. The Revenue & Economic Analysis section provides additional
analysis regarding key revenue sources and economic
indicators.
4. The Quarterly Investment Report section provides a summary
of the City’s investment portfolio, interest earnings and a brief
market outlook.
The Quarterly Financial Report is intended to provide our users with
timely and relevant information. Please provide us with any
comments or suggestions you may have. If you would like additional
information, feel free to contact me.
David Gaines
Director of Finance
215 East McKinney Street
Denton, TX 76201
940-349-8260
Section 1
City of Denton
Quarterly Financial Report
December 2019
Executive Dashboards
Note: All figures presented are in millions of dollars.FY 2019-20ANNUAL YTDDESCRIPTION BUDGET 1ACTUALS ANNUAL VARIANCEBeginning Fund Balance as of 09/30/19 30.13$ 30.74$ 30.74$ RESOURCES: Ad Valorem Taxes 48.63 23.34 48.63 0% Sales Tax 39.28 10.49 39.28 0% Franchise Fees 4.60 0.87 4.60 0% Other Taxes 0.50 - 0.50 0% Service Fees 8.12 1.79 8.12 0% Fines and Fees 3.58 0.74 3.58 0% Licenses and Permits 6.63 1.47 6.63 0% Miscellaneous Revenue 3.36 0.23 3.36 0% Transfers In 21.64 5.11 21.64 0%Total Revenues 136.34 44.04 136.34 0%Total Resources 166.47 74.78 167.08 EXPENDITURES: Personal Service 93.24 22.99 93.24 0% Material and Supplies 3.19 0.43 3.19 0% Maintenance and Repairs 1.71 0.35 1.71 0% Insurance 1.57 0.39 1.57 0% Miscellaneous 1.54 0.25 1.54 0% Operations 17.56 2.87 17.56 0% Transfers Out 17.14 4.25 17.14 0% Fixed Assets 0.55 0.09 0.55 0%Total Expenditures 136.50 31.62 136.50 0%Net Income (Loss) (0.16) 12.42 (0.16) Ending Fund Balance 29.97$ 43.16$ 30.58$ FY 2019-20PRO JEC TIO NSCity of Denton, Texas General Fund Executive Dashboard $‐ $5 $10 $15 $20 $25 $30 $35 $40 $45 $50Revenue & Expenses (in Millions)YTD RevenueYTD ExpensesKey TrendsAt this point in the fiscal year, revenues and expenditures are projected to meet budgeted levels. $‐ $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 $3.5 $4.0Sales Tax Monthly Average by Quarter1Annual adopted budget as amended or modified. Beginning Fund Balance represents the amount which was estimated in the FY 2019‐20 budget process.
Note: All figures presented are in millions of dollars.
City of Denton, Texas
Electric Fund Executive Dashboard
FY 2019-20
ANNUAL YTD
DES CRIP TION B UDGET
1 ACTUALS ANNUAL VARIANCE
B e ginning Wo rking Capital
and Re s e rve s as o f 9/30/19 55.64$ 77.92$ 77.92$
RES OURCES :
Rate Re ve nue s 146.49 35.23 146.49 0%
Trans mis s io n Re ve nue 46.70 7.10 46.70 0%
Othe r Re ve nue s 3.98 1.44 3.98 0%
DEC Re ve nue s 25.07 3.32 25.07 0%
To tal Re ve nue s 222.24 47.09 222.24 0%
To tal Re s o urc e s 277.88 125.01 300.16
EXP ENDITURES :
P urc has e d P o we r 74.33 12.65 74.33 0%
DEC Fue l 12.48 0.87 12.48 0%
Trans mis s io n o f P o we r 18.62 2.13 18.62 0%
P e rs o nne l S e rvic e 22.75 4.97 22.75 0%
Ope ratio n and Mainte nanc e 30.39 5.50 30.39 0%
De bt S e rvic e 54.73 21.39 54.73 0%
Trans fe rs Out 15.83 3.92 15.83 0%
Capital Outlay 0.10 - 0.10 0%
To tal Expe nditure s 229.23 51.43 229.23 0%
Ne t Inc o me (Lo s s )(6.99) (4.34) (6.99)
Ending Wo rking Capital
and Re s e rve s 48.65$ 73.58$ 70.93$
FY 2019-20
P ROJECTIONS
$0
$10
$20
$30
$40
$50
$60
Oct-19 Nov-19 Dec-19
Revenue & Expenses (in Millions)
YTD Revenue YTD Expense
Key Trends
➢At this point in the fiscal year, both revenues and expenditures are projected to meet budgeted levels. YTD actual
expenses are high compared to budget; this is attributed to the large portion of the debt service hitting in the first part of
the fiscal year.
➢The Beginning Working Capital and Reserves is $22.3 Million higher than budgeted mainly as a result of not retiring
$28.62 Million of TMPA Scrubber debt, posting $10 Million more for DEC debt, and receiving $4.2 Million in unanticipated
revenue from TMPA.
➢Revenues are seasonal with a majority hitting in Quarters 3 and 4.
0
100
200
300
400
500
600
1Q 14 3Q 14 1Q 15 3Q 15 1Q16 3Q16 1Q17 3Q17 1Q18 3Q18 1Q19 3Q19 1Q20
2014 –2019 Historical Quarterly GWH Sales
1 Annual adopted budget as amended or modified. Beginning Fund Balance represents the amount which was estimated in
the FY 2019-20 budget process.
Note: All figures presented are in millions of dollars.
FY 2019-20
ANNUAL YTD
DES CRIP TION B UDGET
1 ACTUALS ANNUAL VARIANCE
B e ginning Wo rking Capital
and Re s e rve s as o f 09/30/19
2 23.54$ 25.46$ 25.46$
RES OURCES :
Wate r S ale s 39.35 10.68 39.35 0%
Othe r Wate r Re ve nue s 1.16 0.38 1.16 0%
Trans fe rs In 0.95 0.29 0.95 0%
Impac t Fe e Re ve nue 6.61 1.65 6.61 0%
To tal Re ve nue s 48.07 13.00 48.07 0%
To tal Re s o urc e s 71.61 38.46 73.53
EXP ENDITURES :
P e rs o nal S e rvic e 8.90 2.01 8.90 0%
Ope ratio ns , S e rvic e s 10.86 2.17 10.86 0%
Capital Outlay 13.24 3.24 13.24 0%
De bt S e rvic e 12.88 6.72 12.88 0%
Trans fe rs Out 5.18 1.21 5.18 0%
To tal Expe nditure s 51.06 15.35 51.06 0%
Ne t Inc o me (Lo s s )(2.99) (2.35) (2.99)
Ending Wo rking Capital
and Re s e rve s 20.55$ 23.11$ 22.47$
FY 2019-20
P ROJECTIONS
City of Denton, Texas
Water Fund Executive Dashboard
$-
$2
$4
$6
$8
$10
$12
$14
$16
$18
Oct-19 Nov-19 Dec-19
Revenue & Expenses (in Millions)
YTD Revenue YTD Expenses
Key Trends
➢At this point in the fiscal year, expenditures and revenues are projected to meet budgeted
levels. YTD actual expenses are high compared to budget; this is attributed to the large portion
of the debt service hitting in the first of the fiscal year.
➢Revenues are seasonal with a majority hitting in Quarters 3 and 4.
1Annual adopted budget as amended or modified. Beginning Fund Balance represents the amount which was estimated in the
FY 2019-20 budget process.
2The Beginning Working Capital balance excludes $13.05M of Impact Fee Reserves and $0.75 million for Development Plan
Line Reserves.
0
500
1,000
1,500
2,000
2,500
1Q
14
3Q
14
1Q
15
3Q
15
1Q
16
3Q
16
1Q
17
3Q
17
1Q
18
3Q
18
1Q
19
3Q
19
1Q
20
2014-2020 Historical Quarterly Gallons Sold (in Millions)
FY 2019-20
ANNUAL YTD
DES CRIP TION B UDGET
1 ACTUALS
ANNUAL VARIANCE
B e ginning Wo rking Capital
and Re s e rve s as o f 09/30/19
2 16.19$ 16.93$ 16.93$
RES OURCES :
Was te wate r Fe e s 25.03 6.27 25.03 0%
Othe r Was te wate r Re ve nue 1.86 0.36 1.86 0%
Drainage Fe e s 4.96 1.26 4.96 0%
Trans fe r In 0.59 0.15 0.59 0%
Impac t Fe e Re ve nue 4.27 1.07 4.27 0%
To tal Re ve nue s 36.71 9.11 36.71 0%
To tal Re s o urc e s 52.90 26.04 53.64
EXP ENDITURES :
P e rs o nal S e rvic e 9.36 2.07 9.36 0%
Ope ratio ns , S e rvic e s 9.84 1.79 9.84 0%
Capital Outlay 6.31 2.07 6.31 0%
De bt S e rvic e 7.96 3.92 7.96 0%
Trans fe r Out 4.85 1.19 4.85 0%
To tal Expe nditure s 38.32 11.04 38.32 0%
Ne t Inc o me (Lo s s )(1.61) (1.93) (1.61)
Ending Wo rking Capital
and Re s e rve s 14.58$ 15.00$ 15.32$
FY 2019-20
P ROJECTIONS
Note: All figures presented are in millions of dollars.
City of Denton, Texas
Wastewater Fund Executive Dashboard
$-
$2
$4
$6
$8
$10
$12
Oct-19 Nov-19 Dec-19
Revenue & Expenses (in Millions)
YTD Revenue YTD Expenses
Key Trends
➢At this point in the fiscal year, expenditures and revenues are projected to meet
budgeted levels. YTD actual expenses are high compared to budget; this is attributed to
the large portion of the debt service hitting in the first part of the fiscal year.
➢Revenues are seasonal with a majority hitting in Quarters 3 and 4.
1Annual adopted budget as amended or modified. Beginning Fund Balance represents the amount which was estimated in
the FY 2019-20 budget process.
2The Beginning Working Capital balance excludes $6.77 million of Impact Fee Reserves, $1.0 million for Drainage Reserves,
and $0.54 million for Development Plan Line Reserves.
0
200
400
600
800
1,000
1,200
1,400
1Q 14 3Q 14 1Q 15 3Q 15 1Q 16 3Q 16 1Q 17 3Q 17 1Q 18 3Q 18 1Q 19 3Q 19 1Q20
2014-2020 Historical Quarterly Gallons Billed (in Millions)
FY 2019-20ANNUAL YTDDESCRIPTION BUDGET ACTUALS ANNUALVARIANCEREVENUES: Residential Drainage Fees 1.90$ 0.48$ 1.90$ 0% Nonresidential Drainage Fees 3.06 0.78 3.06 0% Wastewater Resources 0.04 - 0.04 0% General Fund Transfer 0.35 0.09 0.35 0%Total Revenues 5.35 1.35 5.35 0%EXPENDITURES: Personal Service 2.30 0.49 2.30 0% Operatio ns , Services 0.95 0.11 0.95 0% Capital Outlay 1.14 0.36 1.14 0% Debt Service 0.48 0.25 0.48 0% Transfer Out 0.48 0.14 0.48 0%Total Expenditures 5.35 1.35 5.35 0%Net Income (Loss) -$ -$ -$ FY 2019-20PROJECTIONSNote: All figures presented are in millions of dollars.City of Denton, Texas Drainage Operations Executive Dashboard $‐ $0.2 $0.4 $0.6 $0.8 $1.0 $1.2 $1.4 $1.6Oct‐19 Nov‐19 Dec‐19Revenue & Expenses (in Millions)YTD RevenueYTD ExpensesKey TrendsAt this point in the fiscal year, expenditures and revenues are projected to meet budgeted levels.
FY 2019-20 FY 2019-20
ANNUAL YTD P ROJECTIONS
DES CRIP TION B UDGET
1 ACTUALS ANNUAL VARIANCE
B e ginning Wo rking Capital
and Re s e rve s as o f 09/30/19
2 10.36$ 13.17$ 13.17$
RES OURCES :
Co lle c tio n & Dis po s al 27.08 6.84 27.08 0%
Re c yc ling 7.04 1.70 7.04 0%
Othe r Re ve nue 1.27 0.40 1.27 0%
To tal Re ve nue s 35.39 8.94 35.39 0%
To tal Re s o urc e s 45.75 22.11 48.56
EXP ENDITURES :
P e rs o nal S e rvic e 11.10 2.58 11.10 0%
Ope ratio ns , S e rvic e s 10.62 1.96 10.62 0%
Capital Outlay 3.02 1.08 3.02 0%
De bt S e rvic e 8.45 4.55 8.45 0%
Landfill Clo s ure 0.61 0.15 0.61 0%
Trans fe r Out 4.65 1.11 4.65 0%
To tal Expe nditure s 38.45 11.43 38.45 0%
Ne t Inc o me (Lo s s )(3.06) (2.49) (3.06)
Ending Wo rking Capital
and Re s e rve s 7.30$ 10.68$ 10.11$
0
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
2018
Qtr 2
2018
Qtr 3
2018
Qtr 4
2019
Qtr 1
2019
Qtr 2
2019
Qtr 3
2019
Qtr 4
2020
Qtr 1
Refuse Tonnage Recycling and ReuseTonnage
Residential Curbside Collection Tonnage
Note: All figures presented are in millions of dollars.
City of Denton, Texas
Solid Waste Fund Executive Dashboard
Key Trends
➢Revenue and expenses are expected to reach budget levels.
➢YTD actual expenses are high compared to budget; this is attributed to the large portion of the
debt service hitting in the first part of the fiscal year.
0
5,000
10,000
15,000
20,000
25,000
30,000
2018
Qtr 2
2018
Qtr 3
2018
Qtr 4
2019
Qtr 1
2019
Qtr 2
2019
Qtr 3
2019
Qtr 4
2020
Qtr 1
Commercial Refuse & Recycling (Front & Side Load)
Cubic Yards Serviced per Week
Commercial Refuse Commercial Recycling
1Annual adopted budget as amended or modified. Beginning Working Capital and Reserves represents the amount which was
estimated in the FY 2019-20 budget process.
2The Beginning Working Capital and Reserves excludes $11.06 million of Landfill Closure/Post Closure reserves.
City of Denton, Texas Airport Fund Executive DashboardKey TrendsCurrently, all operating revenue and expenses are projected to be at budgeted levels.Interest earned on investments is currently ahead of budget projections.$0.0$1.0$2.0$3.0$4.0$5.02010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020GAS WELLREVENUE(in millions of dollars by fiscal year) 20,000 30,000 40,000 50,000 60,000AIRPORT OPERATIONS BY QUARTER(takeoff or landing by fiscal year)Note: All financial amounts presented are in millions of dollars.FY 2019-20 FY 2019-20ANNUAL YTDDESCRIPTION BUDGET 1ACTUALS ANNUAL VARIANCEBeginning Working Capital and Reserves as of 09/30/18 2.81$ 2.88$ 2.88$ RESOURCES: Airport Ground Leases 0.77 0.19 0.77 0% FBO Commissions 0.21 0.04 0.21 0% Fuel Flowage Fees 0.13 0.02 0.13 0%Total Operating Revenues 1.11 0.25 1.11 0%EXPENDITURES: P e rs o nal S e rvic e 0.52 0.12 0.52 0% Operations, Services 0.39 0.04 0.39 0% Transfer Out 0.38 0.10 0.38 0%Total Operating Expenditures 1.29 0.26 1.29 0%Net Operating Income (Loss) (0.18) (0.01) (0.18) NON-OPERATING REVENUES: Investment Income 0.02 0.03 0.10 400% Gas Well Royalties 0.36 0.04 0.36 0% Miscellaneos Income 0.00 0.00 0.00 0%Total Non-Operating Revenues 0.38 0.07 0.46 21%NON-OPERATING EXPENDITURES: Transfer Out - Capital 0.25 - 0.25 0%Total Non-Operating Expenditures 0.25 - 0.25 0%Net Non-Operating Income (Loss) 0.13 0.07 0.21 Net Income (Loss) (0.05) 0.06 0.03 Ending Working Capital and Reserves 2.76$ 2.94$ 2.91$ PROJECTIONS1Annual adopted budget as amended or modified. Beginning Working Capital and Reserves represents the amount which was estimated in the FY 2019‐20 budget process.
FY 2019-20
ANNUAL YTD
DES CRIP TION B UDGET
1 ACTUALS ANNUAL VARIANCE
B e ginning Wo rking Capital
and Re s e rve s as o f 09/30/19 2.35$ 3.44$ 3.44$
RES OURCES :
Franc his e Fe e s 13.09 2.47 13.09 0%
S tre e t Cuts 0.37 0.06 0.37 0%
Inve s tme nt Inc o me 0.01 0.01 0.01 0%
Trans fe rs In 1.18 0.30 1.18 0%
To tal Re ve nue s 14.65 2.84 14.65 0%
To tal Re s o urc e s 17.00 6.28 18.09
EXP ENDITURES :
P e rs o nal S e rvic e 3.51 0.83 3.51 0%
Mate rials & S upplie s 0.09 0.02 0.09 0%
Mainte nanc e & Re pairs 10.07 1.88 10.07 0%
Ope ratio ns , S e rvic e s 0.81 0.20 0.81 0%
Trans fe r Out 1.25 0.36 1.25 0%
To tal Expe nditure s 15.73 3.29 15.73 0%
Ne t Inc o me (Lo s s )(1.08) (0.45) (1.08)
Ending Fund B alanc e 1.27$ 2.99$ 2.36$
FY 2019-20
P ROJECTIONS
1Annual adopted budget as amended or modified. Beginning Fund Balance represents the amount
which was estimated in the FY 2019-20 budget process.
City of Denton, Texas
Street Improvement Fund Executive Dashboard
Key Trends
➢Revenues and expenditures are projected to meet budgeted levels.
➢Franchise fee revenues are received later in the fiscal year.
➢43.36 lane mile surface treatments were completed in the 1st quarter.
Note: All figures presented are in millions of dollars.
0
3
6
9
12
Qtr1
Tons of Asphalt Laid (in Thousands)
FY18-19 FY19-20
0
20
40
60
Qtr 1
Lane Miles Surface Treatment
FY 18-19 FY 19-20
$-
$1.0
$2.0
$3.0
$4.0
Oct-19 Nov-19 Dec-19
Revenue & Expenses (in Millions)
YTD Revenue YTD Expenses
FY 2019-20GRANT YTDDESCRIPTION AMOUNT ACTUALS ANNUAL VARIANCE2019-20 Budget Comm Development 3.77$ 0.17$ 1.10$ -71% Public Safety 0.63 0.09 0.63 0% Transportation161.80 3.70 44.93 -27% Other 0.36 - 0.36 0%Total Bu dge t 66.56 3.96 47.02 -29%New Awards Public Safety 0.16 0.16 0.16 0% Transportation 0.06 0.06 0.06 0%Total New Awards 0.22 0.22 0.22 0%Total s 66.78$ 4.18$ 47.24$ -29%FY 2019-20PRO JEC TIO NSCOMM DEV5.65%PUBLIC SAFETY1.19%TRANS92.62%OTHER0.54%FY 2019‐20 Grants Awarded $‐ $20.0 $40.0 $60.0 $80.0COMMDEVPUBLICSAFETYTRANSOTHERAwardsExpensesFY 2019‐20 Awards & Expenses (in Millions)City of Denton, Texas Grants DashboardNote: All figures presented are in millions of dollars.1This grant amount will be spent over several years and the fiscal year 2019-20 projections are estimated expenditures for one year. Remaining grant amounts will be spent in future fiscal year.Key TrendsThe following grants have been received in FY 2019-20: Federal Equitable Sharing: $142,749Chapter 59 Asset Forfeitures: $10,334U.S. Marshals Violent Offenders Task Force: $5,127Organized Crime Drug Enforcement Task Force: $2,781Sexual Assault Examiners Reimbursement:$1,214IH35 E FR & Brinker Signal: $56,394Collaborative Summer Library Program Scholarship Award: $118
Section 2
City of Denton
Quarterly Financial Report
December 2019
This report is designed for internal use and does not include all the
funds and accounts included in the City of Denton’s operations. The
information provided is unaudited; for a complete audited report,
please refer to the City of Denton Comprehensive Annual Financial
Report, available through the City’s Finance Department, City
Secretary’s Office, or Denton Public Libraries.
FINANCIAL SUMMARY
City of Denton General FundSchedule of Revenues - Budget vs Projection (Unaudited)For the Period Ended December 31, 2019
PRIOR BUDGET CURRENT ANNUAL ANNUAL BUDGET VS
REVENUE DESCRIPTION Y-T-D Y-T-D Y-T-D BUDGET PROJECTION PROJECTION
Current Year - Ad Valorem 20,244,896$ 21,774,418$ 23,063,390$ 47,996,644$ 47,996,644$ 0%
Delinquent - Ad Valorem 50,118 65,515 172,409 311,978 311,978 0%
Miscellaneous Penalties & Fees 33,249 52,675 108,329 320,775 320,775 0%
Ad Valorem Taxes 20,328,263 21,892,608 23,344,128 48,629,397 48,629,397 0%
Sales Tax 9,902,458 9,828,342 10,491,343 39,281,942 39,281,942 0%
Franchise - Gas Utilities 11,593 - 9,311 384,313 384,313 0%
Franchise - Private Electric Utilities - - - 117,980 117,980 0%
Franchise - Cable - - - 363,687 363,687 0%
Franchise - Telecom - - - 53,301 53,301 0%
Franchise - Denton Municipal Utilities 816,782 596,385 860,328 3,679,652 3,679,652 0%
Franchise Fees 828,375 596,385 869,639 4,598,933 4,598,933 0%
Other Taxes - - - 501,870 501,870 0%
Ambulance Service Fees 658,136 421,970 773,367 3,679,000 3,679,000 0%
Fire Department Fees 49,520 57,691 48,560 230,743 230,743 0%
Building Inspections Fees 125,414 135,533 138,889 597,476 597,476 0%
Park Department Fees 99,906 213,088 105,367 2,040,353 2,040,353 0%
Planning Department Fees 344,820 340,685 638,352 1,362,254 1,362,254 0%
Reprographics Fees 62,653 24,420 68,264 97,603 97,603 0%
Miscellaneous Service Fees 23,417 27,159 17,943 108,634 108,634 0%
Service Fees 1,363,866 1,220,546 1,790,742 8,116,063 8,116,063 0%
Denton Municipal Fines 321,799 375,875 329,773 1,503,486 1,503,486 0%
Parking Fines 73,935 65,656 66,470 262,620 262,620 0%
Miscellaneous Fines and Fees 189,754 145,503 176,763 725,712 725,712 0%
Court Administrative and Service Fees 217,620 240,000 171,092 1,084,800 1,084,800 0%
Fines and Fees 803,108 827,034 744,098 3,576,618 3,576,618 0%
Demolition Permits 1,045 1,107 3,188 4,430 4,430 0%
Building Permits 800,588 1,437,137 1,452,989 6,526,709 6,526,709 0%
Certificate of Occupancy 17,290 16,806 11,138 67,226 67,226 0%
Miscellaneous Licenses and Permits 3,012 7,021 1,842 28,087 28,087 0%
Licenses and Permits 821,935 1,462,071 1,469,157 6,626,452 6,626,452 0%
Investment Income 143,787 225,928 159,180 903,714 903,714 0%
Miscellaneous Revenues 167,118 323,507 66,088 2,460,285 2,460,285 0%
Miscellaneous Resources 310,905 549,435 225,268 3,363,999 3,363,999 0%
ROI - Denton Municipal Utilities 1,830,748 2,137,710 2,013,807 8,978,547 8,978,547 0%
Transfers 2,179,628 3,168,056 3,096,777 12,662,121 12,662,121 0%
Transfers 4,010,376 5,305,766 5,110,584 21,640,668 21,640,668 0%
Total General Fund Revenues 38,369,286$ 41,682,187$ 44,044,959$ 136,335,942$ 136,335,942$ 0%
City of Denton
General Fund
Schedule of Expenditures - Budget vs Projection (Unaudited)
For the Period Ended December 31, 2019
PRIOR BUDGET CURRENT ANNUAL ANNUAL BUDGET VS
Y-T-D Y-T-D Y-T-D BUDGET PROJECTION PROJECTION
NEIGHBORHOOD SERVICES
Building Inspections 724,582$ 859,962$ 845,889$ 3,437,095$ 3,437,095$ 0%
Community Improvement Services 321,128 405,465 303,871 1,620,557 1,620,557 0%
Libraries 1,635,787 1,546,726 1,594,121 6,182,023 6,182,023 0%
Parks and Recreation 2,011,378 3,030,992 2,305,821 12,114,271 12,114,271 0%
Planning 717,490 1,014,510 966,718 4,054,801 4,054,801 0%
Gas Well Review 42,997 105,677 41,358 422,398 422,398 0%
Social Services 115,046 429,527 212,712 1,716,712 1,716,712 0%
5,568,408 7,392,859 6,270,490 29,547,857 29,547,857 0%
PUBLIC SAFETY
Animal Services 410,391 573,925 565,415 2,293,869 2,293,869 0%
Fire 8,008,837 7,970,816 7,781,090 31,857,795 31,857,795 0%
Municipal Court 300,420 295,934 294,767 1,182,784 1,182,784 0%
Municipal Judge 117,983 147,594 106,065 564,530 564,530 0%
Police 8,641,884 9,991,306 9,545,082 39,933,338 39,933,338 0%
17,479,515 18,979,575 18,292,419 75,832,316 75,832,316 0%
TRANSPORTATION
Traffic Operations 439,501 577,977 555,284 2,310,060 2,310,060 0%
Transportation Operations 75,251 - - - - 0%
Street Lighting 211,828 212,670 202,534 850,000 850,000 0%
726,580 790,647 757,818 3,160,060 3,160,060 0%
ADMINISTRATIVE & COMMUNITY SERVICES
City Manager's Office 511,349 615,037 529,191 2,458,145 2,458,145 0%
Economic Development 317,638 1,241,691 300,385 4,962,803 4,962,803 0%
Facilities Management 1,107,109 - - - - 0%
Finance 839,162 992,233 873,190 3,965,753 3,965,753 0%
Human Resources 493,037 456,960 566,312 1,826,381 1,826,381 0%
Internal Audit 74,970 161,007 113,976 643,519 643,519 0%
Legal Administration 534,041 747,628 650,032 2,883,241 2,883,241 0%
Public Affairs 412,049 628,794 540,483 2,513,173 2,513,173
Non-Departmental 2,443,471 2,144,971 2,720,882 8,703,300 8,703,300 0%
6,732,826 6,988,321 6,294,451 27,956,315 27,956,315 0%
TOTAL EXPENDITURES 30,507,329$ 34,151,402$ 31,615,178$ 136,496,548$ 136,496,548$ 0%
Beginning FY 19-20, Transportation Operations and Facilities Management are no longer budgeted within the General Fund.
City of Denton
Electric Fund
Schedule of Revenues and Expenditures - Budget vs Projection (Unaudited)
For the Period Ended December 31, 2019
PRIOR BUDGET CURRENT ANNUAL ANNUAL BUDGET VS
DESCRIPTION Y-T-D Y-T-D Y-T-D BUDGET1 PROJECTION PROJECTION
Beginning Working Capital
and Reserves as of 9/30/19 55,642,370$ 77,919,436$
REVENUES:
Rate Revenues 34,473,793$ 33,222,648$ 35,225,279$ 146,489,831 146,489,831 0%
Transmission Revenues 6,444,844 5,696,238 7,103,812 46,700,670 46,700,670 0%
Other Revenues 1,331,232 954,835 1,441,497 3,977,004 3,977,004 0%0%
DEC Revenues 4,061,861 5,472,725 3,323,034 25,073,394 25,073,394 0%
Total Revenues 46,311,730 45,346,446 47,093,622 222,240,899 222,240,899 0%
EXPENDITURES:
Purchased Power 16,334,143 16,314,034 12,654,360 74,329,750 74,329,750 0%
DEC Fuel 1,678,366 2,696,008 872,320 12,475,775 12,475,775 0%
Transmission of Power 1,267,236 1,962,893 2,128,748 18,616,102 18,616,102 0%
Personnel Services 4,558,341 6,029,440 4,968,902 22,747,359 22,747,359 0%
Materials and Supplies 83,178 172,355 110,856 1,303,950 1,303,950 0%
Maintenance and Repair 94,057 301,039 93,097 1,975,209 1,975,209 0%
Insurance 68,015 205,738 84,891 822,952 822,952 0%
Return on Investment Return on Investment1,334,912 1,397,330 1,437,873 6,613,804 6,613,804 0%
Franchise Fee Franchise Fee1,909,380 1,996,188 2,051,604 9,448,292 9,448,292 0%
Miscellaneous 122,289 558,157 696,636 1,374,225 1,374,225 0%
Operations 1,063,628 2,114,460 1,029,707 8,869,731 8,869,731 0%
Debt Service 17,129,878 21,390,284 21,390,284 54,728,969 54,728,969 0%
Interfund Transfers 3,579,625 3,956,773 3,913,510 15,827,091 15,827,091 0%
Capital Outlay - - - 95,000 95,000 0%
Total Expenditures 49,223,048 59,094,699 51,432,788 229,228,209 229,228,209 0%
Net Income (Loss)(2,911,318)$ (13,748,253)$ (4,339,166)$ (6,987,310) (6,987,310)
Ending Working Capital and Reserves 48,655,060$ 70,932,126$
1Annual adopted budget as amended or modified. Beginning Working Capital and Reserves represents the amount
which was estimated in the FY 2019-20 budget process.
City of Denton
Water Fund
Schedule of Revenues and Expenditures - Budget vs Projections (Unaudited)
For the Period Ended December 31, 2019
PRIOR BUDGET CURRENT ANNUAL ANNUAL BUDGET VS
DESCRIPTION Y-T-D Y-T-D Y-T-D BUDGET2 PROJECTION PROJECTION
Beginning Working Capital
and Reserves as of 09/30/191 23,539,348$ 25,457,474$
REVENUES:
Water Sales Residential 3,675,360$ 4,861,363$ 4,829,881$ 20,508,495 20,508,495 0%
Water Sales Commercial 3,884,314 4,758,104 4,867,288 17,661,792 17,661,792 0%
Water for Resale 121,861 333,214 977,655 1,184,134 1,184,134 0%
Other Water 288,899 207,535 275,704 865,090 865,090 0%
Transfers In 372,513 237,473 287,498 949,888 949,888 0%
Investment Income 104,535 73,500 106,517 294,000 294,000 0%
Impact Fee Revenue 1,426,140 1,651,250 1,652,571 6,605,000 6,605,000 0%
Total Revenues 9,873,622 12,122,439 12,997,114 48,068,399 48,068,399 0% Use of Reserves - - - -
EXPENDITURES:
Personal Service 2,055,010 1,930,540 2,011,874 8,902,207 8,902,207 0%
Purchased Power 262,589 387,839 341,757 1,410,789 1,410,789 0%
Materials and Supplies 234,804 342,691 245,540 1,510,203 1,510,203 0%
Maintenance and Repairs 271,825 285,417 283,945 1,754,503 1,754,503 0%
Insurance 55,858 58,198 58,197 232,791 232,791 0%
Miscellaneous 103,803 109,088 49,614 401,060 401,060 0%
Operations, Services 521,382 570,805 330,149 2,153,980 2,153,980 0%
Capital Outlay 1,720,155 2,131,031 3,243,429 13,236,219 13,236,219 0%
Return on Investment 276,939 373,290 351,831 1,404,533 1,404,533 0%
Franchise Fee 395,628 529,374 502,616 1,991,812 1,991,812 0%
Debt Service 6,662,950 6,723,005 6,723,005 12,879,020 12,879,020 0%
Transfers Out 880,649 1,295,412 1,207,855 5,181,646 5,181,646 0%
Total Expenditures 13,442,062 14,736,690 15,350,190 51,061,763 51,061,763 0%
Net Income (Loss)(3,568,440)$ (2,614,251)$ (2,353,076)$ (2,993,364) (2,993,364)
Ending Working Capital
and Reserves 20,545,984$ 22,464,110$
1 The Beginning Working Capital balance excludes $13,045,131 of Impact Fee Reserves and $750,000 for Development Plan Line Reserves.
budget process.
2 Annual adopted budget as amended or modified. Beginning Fund Balance represents the amount which was estimated in the FY 2019-20
City of Denton
Wastewater Fund
Schedule of Revenues and Expenditures - Budget vs Projections (Unaudited)
For the Period Ended December 31, 2019
PRIOR BUDGET CURRENT ANNUAL ANNUAL BUDGET VS
DESCRIPTION Y-T-D Y-T-D Y-T-D BUDGET2 PROJECTION PROJECTION
Beginning Working Capital
and Reserves as of 09/30/191 16,190,748$ 16,927,079$
REVENUES:
Residential Fees 2,974,289$ 2,882,756$ 2,847,046$ 11,545,026 11,545,026 0%
Commercial Fees 2,967,486 3,276,540 3,230,451 12,734,519 12,734,519 0%
Effluent Irrigation Fees 18,582 13,023 37,273 60,424 60,424 0%
Wholesale Fees 193,766 162,458 158,436 693,802 693,802 0%
Other Wastewater Fees 241,891 380,550 292,097 1,630,878 1,630,878 0%
Drainage Fees 1,196,332 1,242,371 1,258,669 4,959,200 4,959,200 0%
Transfer In 137,949 146,974 146,974 587,895 587,895 0%
Investment Income 76,199 58,715 73,209 234,858 234,858 0%
Impact Fee Reserves 500,400 1,067,500 1,068,354 4,270,000 4,270,000 0%
Total Revenues 8,306,894 9,230,887 9,112,509 36,716,602 36,716,602 0%
EXPENDITURES:
Personal Service 2,049,466 1,948,433 2,066,095 9,357,192 9,357,192 0%
Purchased Power 275,767 290,831 252,838 1,221,000 1,221,000 0%
Materials and Supplies 211,970 178,016 204,397 1,354,025 1,354,025 0%
Maintenance and Repairs 265,008 338,741 144,318 1,770,257 1,770,257 0%
Insurance 58,005 66,436 66,436 265,743 265,743 0%
Miscellaneous 58,196 49,577 9,773 82,218 82,218 0%
Operations, Services 572,774 779,371 576,593 2,624,964 2,624,964 0%
Capital Outlay 4,842,598 2,552,540 2,064,278 6,311,604 6,311,604 0%
Return on Investment 218,897 299,907 224,103 1,196,502 1,196,502 0%
Franchise Fee 312,709 334,392 320,147 1,334,082 1,334,082 0%
Debt Service 3,649,709 3,918,157 3,918,157 7,958,969 7,958,969 0%
Transfers Out 888,869 1,212,081 1,194,451 4,848,319 4,848,319 0%
Total Expenditures 13,403,968 11,968,482 11,041,586 38,324,875 38,324,875 0%
Net Income (Loss)(5,097,074)$ (2,737,595)$ (1,929,077)$ (1,608,273) (1,608,273)
Ending Working Capital
and Reserves 14,582,475$ 15,318,806$
1 The Beginning Working Capital balance excludes $6,766,815 of Impact Fee Reserves, $1,000,000 for Drainage Reserves,
and $540,000 for Development Plan Line Reserves.
2 Annual adopted budget as amended or modified. Beginning Fund Balance represents the amount which was estimated
in the FY 2019-20 budget process.
City of Denton
Drainage Operations
Schedule of Revenues and Expenditures - Budget vs Projections (Unaudited)
For the Period Ended December 31, 2019
PRIOR BUDGET CURRENT ANNUAL ANNUAL BUDGET VS
DESCRIPTION Y-T-D Y-T-D Y-T-D BUDGET PROJECTION PROJECTION
REVENUES:
Residential Drainage Fees 455,010$ 468,894$ 481,654$ 1,897,150$ 1,897,150$ 0%
Nonresidential Drainage Fees 741,323 773,448 777,015 3,062,050 3,062,050 0%
Wastewater Resources - 8,750 - 35,000 35,000 0%
General Fund Transfer 79,199 88,224 88,224 352,895 352,895 0%
Total Revenues 1,275,532 1,339,316 1,346,893 5,347,095 5,347,095 0%
EXPENDITURES:
Personal Service 439,499 476,894 488,117 2,304,775 2,304,775 0%
Materials and Supplies 8,176 18,498 10,223 80,425 80,425 0%
Maintenance and Repairs 50,500 31,199 14,599 127,500 127,500 0%
Insurance 8,942 10,365 10,365 41,459 41,459 0%
Miscellaneous 1,720 6,639 1,875 17,200 17,200 0%
Operations, Services 111,558 114,949 72,910 677,497 677,497 0%
Capital Outlay 278,489 313,687 361,153 1,144,236 1,144,236 0%
Debt Service 258,957 248,056 248,056 477,893 477,893 0%
Transfer Out 117,691 119,029 139,595 476,110 476,110 0%
Total Expenditures 1,275,532 1,339,316 1,346,893 5,347,095 5,347,095 0%
Net Income (Loss)-$ -$ -$ -$ -$
City of Denton
Solid Waste Fund
Schedule of Revenues and Expenditures - Budget vs Projection (Unaudited)
For the Period Ended December 31, 2019
PRIOR BUDGET CURRENT ANNUAL ANNUAL BUDGET VS
DESCRIPTION Y-T-D Y-T-D Y-T-D BUDGET2 PROJECTION PROJECTION
Beginning Working Capital
and Reserves as of 09/30/191 10,355,478$ 13,172,813$
REVENUES:
Refuse Fees - Residential 1,395,608$ 1,403,824$ 1,415,487$ 5,797,663 5,797,663 0%
Refuse Fees - Commercial 3,604,996 3,660,749 3,601,121 15,432,175 15,432,175 0%
Residential Recycling 1,286,053 1,333,990 1,346,517 5,331,694 5,331,694 0%
Commercial Recycling 345,919 426,594 353,638 1,705,012 1,705,012 0%
Landfill Gate and Material Sales 1,520,362 1,445,004 1,819,290 5,854,458 5,854,458 0%
Recycled Material Sales 16,834 15,261 16,836 61,000 61,000 0%
Asset Sales and Interest Income 42,549 172,260 263,050 688,486 688,486 0%
Other Revenue 194,176 130,332 124,771 520,925 520,925 0%
Total Revenues 8,406,497 8,588,014 8,940,710 35,391,413 35,391,413 0%
EXPENDITURES:
Personal Service 2,692,434 2,704,126 2,580,169 11,104,627 11,104,627 0%
Materials and Supplies 57,827 199,536 35,113 772,789 772,789 0%
Maintenance and Repairs 37,986 71,894 77,562 290,350 290,350 0%
Insurance 67,376 63,262 64,913 257,942 257,942 0%
Miscellaneous 61,217 25,250 32,608 102,120 102,120 0%
Operations, Services 1,452,907 1,943,271 1,319,308 7,439,397 7,439,397 0%
Capital Outlay 21,600 753,345 1,077,702 3,015,186 3,015,186 0%
Debt Service 4,870,389 4,546,084 4,546,084 8,451,027 8,451,027 0%
Franchise Fee 412,376 439,285 432,750 1,755,737 1,755,737 0%
Transfers for Landfill Closure 292,338 152,619 151,146 609,985 609,985 0%
Admin Transfers Out 924,076 1,153,243 1,114,627 4,651,241 4,651,241 0%
Total Expenditures 10,890,526 12,051,915 11,431,982 38,450,401 38,450,401 0%
Net Income (Loss)(2,484,029)$ (3,463,901)$ (2,491,272)$ (3,058,988) (3,058,988)
Ending Working Capital
and Reserves 7,296,490$ 10,113,825$
1 The Beginning Working Capital Reserve excludes $11,057,545 Landfill Closure/Post Closure Reserves.
2 Annual adopted budget as amended or modified. Beginning Fund Balance represents the amount which was estimated in the FY 2019-20 budget process.
City of Denton
Airport Fund
Schedule of Revenues and Expenditures - Budget vs Projection (Unaudited)
For the Period Ended December 31, 2019
PRIOR BUDGET CURRENT ANNUAL ANNUAL BUDGET VS
DESCRIPTION Y-T-D Y-T-D Y-T-D BUDGET1 PROJECTION PROJECTION
Beginning Working Capital
and Reserves as of 09/30/19 2,814,692$ 2,878,940$
OPERATING REVENUES:
Airport Ground Leases 182,477$ 192,165$ 192,234$ 768,051 768,051 0%
FBO Commissions 20,351 52,930 36,471 211,552 211,552 0%
Miscellaneous 10,999 33,886 19,109 135,437 135,437 0%
Total Operating Revenues 213,827 278,981 247,814 1,115,040 1,115,040 0%
OPERATING EXPENDITURES:
Personal Service 129,205 129,837 121,203 518,930 518,930 0%
Materials and Supplies 1,638 11,329 1,639 45,290 45,290 0%
Maintenance and Repairs 1,077 18,114 625 72,400 72,400 0%
Insurance 7,823 6,099 6,094 24,376 24,376 0%
Miscellaneous - 24 - 100 100 0%
Operations 36,421 62,693 31,906 250,565 250,565 0%
Transfers Out - Operating 130,386 95,823 95,748 382,991 382,991 0%
Total Operating Expenses 306,550 323,919 257,215 1,294,652 1,294,652 0%
Operating (Loss)(92,723) (44,938) (9,401) (179,612) (179,612)
NON-OPERATING REVENUES:
Investment Income 22,957 5,571 25,212 22,263 100,848 353%
Gas Well Royalties 24,362 89,796 42,966 358,900 358,900 0%
Total Non-Operating Revenues 47,319 95,367 68,178 381,163 459,748 21%
NON-OPERATING EXPENDITURES:
Transfers Out - Capital - 62,550 - 250,000 250,000 0%
Total Non-Operating Expenses - 62,550 - 250,000 250,000 0%
Non-Operating Income (Loss)47,319 32,817 68,178 131,163 209,748
Net Income (Loss)(45,404)$ (12,121)$ 58,777$ (48,449)30,136
Ending Working Capital 2,766,243$ 2,909,076$
1 Annual adopted budget as amended or modified. Beginning Working Capital and Reserves represents the amount which was estimated in the FY 2019-20 budget process.
City of Denton
Street Improvement Fund
Schedule of Expenditures - Budget vs Projection (Unaudited)
For the Period Ended December 31, 2019
PRIOR BUDGET CURRENT ANNUAL ANNUAL BUDGET VS
DESCRIPTION Y-T-D Y-T-D Y-T-D BUDGET1 PROJECTION PROJECTION
Beginning Fund Balance
as of 9/30/2019 2,348,270$ 3,441,732$
RESOURCES:
Franchise Fees 2,257,138$ 3,274,380$ 2,474,708$ 13,087,053 13,087,053 0%
Street Cuts 50,496 92,931 61,194 371,423 371,423 0%
Investment Income 3,859 2,502 14,040 10,000 10,000 0%
Transfers In 258,645 296,382 296,145 1,184,582 1,184,582 0%
Total Resources 2,570,138 3,666,195 2,846,087 14,653,058 14,653,058 0%
EXPENDITURES:
Personal Service 817,063 877,014 832,680 3,505,267 3,505,267 0%
Materials and Supplies 11,267 21,805 17,283 87,150 87,150 0%
Maintenance and Repairs 1,132,404 2,521,884 1,879,311 10,069,459 10,069,459 0%
Insurance 18,182 23,598 23,578 94,312 94,312 0%
Miscellaneous 3,632 1,251 3,023 5,000 5,000 0%
Operations, Services 157,283 175,213 175,063 710,302 710,302 0%
Transfer Out 402,513 315,159 360,817 1,259,626 1,259,626 0%
Total Expenditures 2,542,344 3,935,924 3,291,755 15,731,116 15,731,116 0%
Net Income (Loss)27,794$ (269,729)$ (445,668)$ (1,078,058) (1,078,058)
Ending Fund Balance 1,270,212$ 2,363,674$
1Annual adopted budget as amended or modified. Beginning Fund Balance represents the amount which was estimated in the FY 2019-20 budget process.
City of Denton
Grants
Schedule of Expenditures - Budget vs Projection (Unaudited)
For the Period Ended December 31, 2019
GRANT DESCRIPTION
EXPENDITURES
AS OF 9/30/20192 CURRENT
Y-T-D
ANNUAL
BUDGET
ANNUAL
PROJECTION
BUDGET VS
PROJECTION
FY 2019-20 Budget
US Dept of HUD -
Community Development Block Grant(CDBG)4,274,427$ 152,369$ 2,314,276$ 700,000$ -70%
US Dept of HUD -
HOME Investment Partnership Program 3,725,784 20,821 1,458,845 400,000 -73%
Community Development1 8,000,211 173,190 3,773,121 1,100,000 -71%
TxDot STEP Comprehensive Grant - 10,328 97,315 97,315 0%
Victim Assistance Coordinator Grant - 23,120 89,040 89,040 0%
2019 UASI-Specialized Regional Response Teams
Sustainment - - 144,137 144,137 0%
Emergency Management Performance Grant - - 40,977 40,977 0%
Staffing for Adequate Fire & Emergency Response
(SAFER) Grant 736,068 51,799 260,913 260,913 0%
Public Safety 736,068 85,247 632,382 632,382 0%
Airport Maintenance (RAMP) Grant - - 50,000 50,000 0%
TxDot-RTR-Mayhill Rd-IH35 E to US 380 39,389,775 2,849,093 9,624,580 5,946,679 -38%
TxDot-RTR-Bonnie Brae Rd-IH35 E to US 377 17,236,196 249,060 29,630,282 21,686,366 -27%
TxDot-IH35E at Loop 288/Lillian Miller Pkwy - - 53,865 53,865 0%
TxDot-RTR-McKinney (Formerly FM426) 3,834,606 235,626 16,410,716 14,432,697 -12%
TxDot-RTR-Hickory Creek FM2181-FM2499 224,556 330,712 2,204,917 2,175,444 -1%
TxDot-RTR-North Texas Boulevard Roundabout 67,518 6,507 1,946,267 193,248 -90%
TxDot-RTR-ITS COMM Trunk Line 1,379,761 31,558 375,417 191,839 -49%
Bicycle & Pedestrian Projects Grant - - 1,500,000 195,000 -87%
Transportation1 62,132,412 3,702,556 61,796,044 44,925,138 -27%
Interlibrary Loan Program (ILL) - - 25,000 25,000 0%
TexTreasures Grant - - 24,820 24,820
TIFMAS Training Tuition Grant - - 9,000 9,000 0%
Miscellaneous New Grants - - 300,000 300,000 0%
Other - - 358,820 358,820 0%
Total FY 2019-20 Budget 70,868,691 3,960,993 66,560,367 47,016,340 -29%
New Awards
Federal Equitable Sharing - 142,749 142,749 142,749 0%
Chapter 59 Asset Forfeitures - 10,334 10,334 10,334 0%
U.S. Marshals Violent Offenders Task Force - 5,127 5,127 5,127 0%
Organized Crime Drug Enforcement Task Force - 2,781 2,781 2,781 0%
Sexual Assault Nurse Examiners (SANE)
Reimbursement - 1,214 1,214 1,214 0%
Public Safety - 162,205 162,205 162,205 0%
TxDot-IH35 E FR & Brinker Signal - 56,394 56,394 56,394 0%
Transportation - 56,394 56,394 56,394 0%
City of Denton
Grants
Schedule of Expenditures - Budget vs Projection (Unaudited)
For the Period Ended December 31, 2019
GRANT DESCRIPTION
EXPENDITURES
AS OF 9/30/20192 CURRENT
Y-T-D
ANNUAL
BUDGET
ANNUAL
PROJECTION
BUDGET VS
PROJECTION
Collaborative Summer Library Program
Scholarship Award - 118 118 118 0%
Others - 118 118 118 0%
Total New Awards - 218,717 218,717 218,717 0%
TOTALS 70,868,691$ 4,179,710$ 66,779,084$ 47,235,057$ -29%
1 This grant amount will be spent over several years and the fiscal year 2019-20 projections are just estimated expenditure in the one year.
Remaining grant amounts will be spent in future fiscal year.
2 A portion of the grants presented cover multiple years.
Section 3
City of Denton
Quarterly Financial Report
December 2019
REVENUE & ECONOMIC
ANALYSIS
Revenue & Economic Analysis
Summary
The data included in this section provides information on local, state
and national trends impacting the City’s financial position.
The following notes are provided to facilitate this section’s readability.
1. Positive Outlook – Represents favorable conditions for the local
economy. Color code – Green.
2. Cautious Outlook – Represents changing conditions that
require close monitoring. Color code – Yellow.
3. Negative Outlook – Represents unfavorable conditions for the
local economy. Color code – Red.
The data included in this section have been obtained from a variety of
sources. Sales tax and construction related data have been obtained
from internal city departments. Economic data for the State have
been obtained from the Federal Reserve Bank of Dallas and may be
subject to availability. National economic data were compiled with
assistance from the City’s investment advisor, First Southwest Asset
Management.
National Economic Trends
Period Ending December 30, 2019
Gross Domestic Product (GDP) The economic growth rate has stabilized at a lackluster pace. The initial reading of fourth quarter GDP growth came in at an annualized rate of +2.1%. On the surface, the Q4 number was as expected, but the underlying details paint a much weaker picture. In particular, the consumer spending downtrend continued with household consumption slowing from a 4.6%
pace in Q2 to +3.2% in Q3 to a +1.8% annualized rate during the fourth quarter. Business investment growth was negative for
the third straight quarter. With the China trade war no longer escalating, the hope is that U.S. businesses will increase their spending in 2020, but early indications are that purchasing managers remain pessimistic. When government purchases and the volatile inventory and trade components are factored out, real final sales rose by just +1.4%.
Nonfarm Payrolls
The labor market remains on solid ground.
Nonfarm payrolls added +145k new jobs in December, slightly below the expected +160k forecast while -14k jobs were subtracted from the previous two month’s count. For all of 2019 (subject to revision) there were 2.11 million jobs created, for an average of +176k per month. Although below the 2018 average of +233k and the slowest annual pace of job creation since 2011, there are plenty of legitimate reasons for the weakening. First and foremost, December marked a record 111 straight months of uninterrupted job gains, while the U.S. economy enters its 127th month of expansion …so most people are working already, and some
moderation is to be expected. The economy did slow in 2019, so again, a lesser pace of hiring makes sense.
Inflation Inflation generally remains tame. The Fed
could potentially cut rates again if inflation were to fall in 2020. The headline consumer price index (CPI) rose +0.2% in December, following a +0.3% increase in November. The year-over-year pace ticked up from +2.1% to +2.3%. Core CPI (which excludes food and energy prices) rose just +0.2% in December following a +0.1% gain in November. The year-over-year core rate held stable at +2.3% for the third consecutive month. The more recent three-
month annualized trend for core CPI is running at +2.0%. The Fed favorite Core Personal Consumption Expenditures (PCE)
rose +0.1% in November, meeting expectations, while the year-over-year pace slipped from +1.7% to +1.6%.
Retail Sales
Consumer spending is showing signs of slowing. Headline retail sales increased by +0.3% in December, matching the median
forecast in Bloomberg’s survey as well as November’s +0.3% gain. The ex-autos and gasoline figure rose +0.5%, a tenth better than expected, although November was revised down from 0% to -0.2%. The control group, which excludes several volatile categories, feeds into GDP calculations and is generally considered a better gauge of underlying consumer heath, also rose +0.5%, but again November data was revised lower from +0.1% to -0.1%.
According to reports by Bloomberg Intelligence, retail sales increased at an annualized rate of +6.0% in Q3 but actually
declined at annualized -0.3% rate in Q4.
Denton County and Texas Home Sales
Texas home sales dropped -16.5% in the fourth quarter, but rose +7.5% over the same three-month period a year ago. The
average Texas home price in December was $303k, slightly below the record high of $306.3k in June, but an increase of +6.5% from a year ago. In Denton County, unit home sales declined by -18.5% during the fourth quarter, but rose +14.7% over the same three-month period a year ago. The average home price in December was $361.8k, an increase of +4.7% year-over-year, but below the $371.3
high point from five months earlier. Denton County home listings totaled 2,839 in December, a 9% decline year-over-year.
The paper was prepared by Hilltop Securities Asset Management, is intended for educational and informational purposes only and does not constitute legal or investment advice, nor is it an offer or a solicitation of an offer to buy or sell any investment or other specific product. Information provided in this paper was obtained from sources that are believed to be reliable; however, it is not guaranteed to be correct, complete, or current, and is not intended to imply or establish standards of care applicable to any attorney or advisor in any particular circumstances. The statements within constitute the views of Hilltop Securities Asset Management as of the date of the report and may differ from the views of other divisions/departments of Hilltop Securities. In addition, the views are subject to change without notice. This paper represents historical information only and is not an indication of future performance.
Fuel Prices Outlook Cautious
Description: Quarterly fuel trends for the United States and Texas.
Analysis:Fuel prices are a major commodity source in the economy.Studies have shown a positive effect on
disposable income levels when fuel prices decrease.It is estimated that for every penny decrease in the price of
fuel,$1.3 billion is available to the consumer for disposable income.Therefore,the price of fuel is likely to be a key
predictor of sales tax collections.Fuel prices showed an 4.1%decrease from the prior quarter at the national level
and a 2.5% decrease at the state level. Staff has rated this outlook as Cautious.
Source: U.S. Department of Energy
$0
$2
$4
$6
$8
$10
$12
$0.00
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
1Q '16 3Q '16 1Q '17 3Q '17 1Q '18 3Q '18 1Q '19 3Q '19 1Q '20 MillionsDollarsFuel Prices
Sales Tax Texas Fuel Prices US Fuel Prices
Municipal Cost Index Outlook Negative
Description:The Municipal Cost Index was developed to show the rate of inflation for the cost of goods purchased
frequently by local governments.The MCI draws on the monthly statistical data collected by the U.S.Departments
of Commerce and Labor as well as independently compiled data to project a composite cost picture for the
municipal budget officer or operating department manager.Costs of labor,materials and contract services are all
factored into the composite MCI.Major indicators of these items used for the MCI include the Consumer Price
Index,the Wholesale Price Index for Industrial Commodities (now known as the Producer Price Index)and the
construction cost indexes published by the U.S. Department of Commerce, respectively.
Analysis:The Municipal Cost Index (MCI)pulls a variety of prices for frequently purchased commodities for local
governments.The cost for labor,materials and contract services are factored for the MCI.An increase in MCI
means the overall price mix for these types of commodities will cost local governments more to do routine business.
The 1st Quarter of 2019-20 shows an increase of 1.8 for a 0.7%increase over the prior quarter and an increase of 3
for a 1.2% increase over the 1st Quarter of 2018-19. Staff has rated this indicator as Negative.
Note:The Municipal Cost Index is designed to show the effects of inflation on the cost of providing municipal services.State
and local government officials rely on American City &County's Municipal Cost Index to stay on top of price trends,help
control price increases for commodities,make informed government contract decisions and intelligent budget planning.Since
1978,readers have loyally referred to the Municipal Cost Index to determine the cost of inflation and,hence,the rising cost of
doing business as a local government.
Source: American City and County Magazine
235.00
240.00
245.00
250.00
255.00
260.00
3Q '17 4Q '17 1Q '18 2Q '18 3Q '18 4Q '18 1Q '19 2Q '19 3Q '19 4Q '19 1Q '20
Municipal Cost Index
Hotel Occupancy Tax Analysis Outlook Positive
1st Quarter FY 2019-20
Actual Y-T-D
Occupancy Tax Revenue:717,292$ 717,292$
FY 2019-20 Budget 739,120$ 739,120$
Over (Under) Budget (21,827)$ (21,827)$
Hotel Occupancy Tax Budget:3,375,164$
3,375,164$
Variance:-$
Description:Tax imposed on a person who,under a lease,concession,permit,right of access,license,contract,or
agreement,pays for the use of a room that is in a hotel.A hotel includes:any building in which the public may obtain
sleeping accommodations;motels;a tourist home,house or court;lodging house;inn;rooming house;or bed and
breakfast. The tax rate levied by the City is 7% of the price paid for a room. The State also levies a tax equal to 6%.
Analysis:While the use of this revenue source is restricted by state law,it is an essential revenue source for various
tourist related activities within the community and an important indicator of local economic activity.Hotel Occupancy
tax revenue through the 1st Quarter of FY 2020 was 2.95%less than budget but 1.72%more than prior year's actual.
Staff has rated the outlook for this economic indicator as Positive.
FISCAL YEAR FORECAST
End of Year Projection:
$0
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
$900,000
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
Hotel Occupancy Tax Collections
FY 2016-17 FY 2017-18 FY 2018-19 FY 2019-20
Sales and Use Tax Analysis Outlook Positive
1st Quarter FY 2019‐20
Actual Y‐T‐D
Revenue: Gross Sales Tax
Municipal Operations 462,215$ 462,215$
General Retail & Others 10,435,075 10,435,075
Comptroller Fees (205,023) (205,023)
Amount Retained (200,924) (200,924)
Total Revenue 10,491,343$ $10,491,343
Expenses: Economic Incentives*
Economic Incentives1 801,309$ 801,309$
Net Total 9,690,034 9,690,034
FY 2018‐19 Budget 9,345,082 9,345,082
Over(Under) Budget 344,952$ 344,952$
Sales Tax Budget: 39,281,942$
Year End Projection: 39,281,942
Variance to Original Budget:‐$
Economic Development Expenditure Budget: 3,011,090$
Year End Projection: 3,011,090
Variance to Original Budget:‐$
* Economic Incentive actuals are through November 2018 with budget amount for December.
1. Includes Denton Crossing, Unicorn Lake, Rayzor Ranch, Golden Triangle Mall, O'Reilly Hospitality, and Buc‐ee's.
Description:Tax imposed on all retail sales, leases, and rentals of most goods, as well as taxable services. The total tax
rate levied within the City is 8.25% (State, 6.25%; City, 1.5%; DCTA, 0.5%).
Analysis:As the second largest revenue source to the City's General Fund, sales and use taxes are essential to the
delivery of services to the community. Sales tax revenues through the 1st quarter of FY 2020 compared to revenues from
the prior year 1st quarter shows a 5.95% increase, and compared to the budget it is 3.69% above. Staff has rated this
indicator as Cautious.
$0.0
$2.0
$4.0
$6.0
$8.0
$10.0
$12.0
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
Gross Sales Tax Collections (Millions)
FY 2015‐16 Actual FY 2016‐17 Actual FY 2017‐18 Actual FY 2018‐19 Actual FY 2019‐20 Actual
Certificates of Occupancy Outlook Positive
Source: City of Denton's Development Services Department.
Description:Certificates of Occupancy (CO)are permits issued in compliance with the 2009 International Building
Code (IBC)and applicable City ordinances.The IBC states,"that no building shall be used or occupied,and no
change in the existing occupancy classification of a building or structure or portion thereof shall be made,until the
building official has issued a certificate of occupancy."Certificates of Occupancy ensure that applicable building,fire
and consumer health codes are met.
Analysis:Certificates of Occupancy are an economic indicator that provides a framework for the overall condition of
the local economy.Certificates of Occupancy decreased 1.68%from the prior quarter and increased 194.96%from
the 1st Quarter of 2019. Staff has rated the outlook for this revenue indicator as positive.
0.0
20.0
40.0
60.0
80.0
100.0
120.0
140.0
3Q
'14
4Q
'14
1Q
'15
2Q
'15
3Q
'15
4Q
'15
1Q
'16
2Q
'16
3Q
'16
4Q
'16
1Q
'17
2Q
'17
3Q
'17
4Q
'17
1Q
'18
2Q
'18
3Q
'18
4Q
'18
1Q
'19
2Q
'19
3Q
'19
4Q
'19
1Q
'20
Certificates of Occupancy
Residential Permits Outlook Cautious
Source: City of Denton's Development Services Department.
Description:Residential Permits are issued in compliance with the 2009 International Residential Code (IRC)and
applicable City ordinances.The data presented in this analysis only include new permits issued and not
remodels/alterations.
Analysis:Residential Permits are an economic indicator that provides a framework for the overall condition of the
local economy.In particular,residential permits have a direct correlation with building inspection fees and
appraised values.Residential permits decreased 40.1%from the prior quarter and decreased 7.3%from the 1st
Quarter of 2019. Staff has rated the outlook for this revenue indicator as Cautious.
0.0
50.0
100.0
150.0
200.0
250.0
300.0
350.0
3Q
'14
4Q
'14
1Q
'15
2Q
'15
3Q
'15
4Q
'15
1Q
'16
2Q
'16
3Q
'16
4Q
'16
1Q
'17
2Q
'17
3Q
'17
4Q
'17
1Q
'18
2Q
'18
3Q
'18
4Q
'18
1Q
'19
2Q
'19
3Q
'19
4Q
'19
1Q
'20
Residential Permits
Texas Leading Indicators Index Outlook Cautious
Source: Federal Reserve Bank of Dallas
Description:The Texas Leading Indicators Index is a single weighted summary statistic that sheds light on the future
of the state's economy.The index is designed to signal movements and changes in the state's rate of growth.The
index includes the following leading indicators:Texas Value of the Dollar,U.S.Leading Index,Real Oil Prices,Well
Permits,Initial Claims for Unemployment Insurance,Texas Stock Index,Help-Wanted Advertising,and Average
Weekly Hours Worked in Manufacturing.
Analysis:Texas Leading Indicators provide a framework for the overall condition of the local economy.Data for this
quarter shows a decrease in the state's rate of growth.The index decreased .19%from the prior quarter and
increased .38% from the 1st Quarter of 2018-19. Staff has rated this indicator as Negative
100.0
105.0
110.0
115.0
120.0
125.0
130.0
135.0
140.0
3Q
'10
1Q
'11
3Q
'11
1Q
'12
3Q
'12
1Q
'13
3Q
'13
1Q
'14
3Q
'14
1Q
'15
3Q
'15
1Q
'16
3Q
'16
1Q
'17
3Q
'17
1Q
'18
3Q
'18
1Q
'19
3Q
'19
1Q
'20
Texas Leading Indicators Index
Unemployment Rate Index Outlook Positive
Description:Unemployment is defined as the number or proportion of people looking for work at the prevailing
wage who are unable to find employment.
Analysis:Unemployment is an economic indicator that provides a framework for the overall condition of the
national,state and local economies.The unemployment rate for the City of Denton is at 2.69%for the 1st Quarter.
The unemployment rates for most of the other reported sectors were either up slightly or flat from the prior
quarter.As a result of the doward trend since the high of the 1st Quarter of 2014,staff has rated the outlook for
this revenue indicator as Positive.
Note:U6 unemployment includes marginally attached workers who currently are neither working nor looking for work but
indicate that they want and are available for a job and have looked for work sometime in the recent past.Discouraged
workers,a subset of the marginally attached,have given a job-market related reason for not looking currently for a job.
Persons employed part-time for economic reasons are those who want and are available for full-time work but have had to
settle for a part-time schedule.
Source: Federal Reserve Bank of Dallas, U.S. Bureau of Labor Statistics, and Texas Workforce Commission
2.0
4.0
6.0
8.0
10.0
12.0
14.0
16.0
18.0
1Q '14 3Q '14 1Q '15 3Q '15 1Q '16 3Q '16 1Q '17 3Q '17 1Q '18 3Q '18 1Q '19 3Q '19 1Q '20
Unemployment Rate Index
Dallas-Plano-Irving MD Denton Texas U6 Unemployment United States
Section 4
City of Denton
Quarterly Financial Report
December 2019
INVESTMENT REPORT
1st Fiscal Quarter 2019- December 31, 2019 Page 1
INVESTMENT POOL
Policy
Par Market Book Unrealized Max.Benchmark
Portfolio:Value Value Value Gain/(Loss)1 WAM WAM YTM Yield*
Investment Pool 611,064,138$ 613,068,792$ 611,166,048$ 1,902,744$ 223 550 1.96%1.55%
*Twelve month moving average of a one year
U.S. T-bill yield
% of Total
Par Market Book Unrealized Portfolio Policy
Securities By Investment Type:Value Value Value Gain/(Loss)1 WAM YTM (Book Value)Max.
U.S. Treasuries 179,000,000 179,736,593 179,126,075 610,518 351 2.13%29.31%100.00%
U.S. Federal Agencies 261,281,000 262,596,567 261,285,570 1,310,997 272 2.09%42.75%100.00%
Municipal Bonds - 0 0.00%0.00%15.00%
Certificates of Deposit 5,000,000 5,000,000 5,000,000 - 36 2.30%0.82%35.00%
Commercial Paper 37,500,000 37,452,494 37,471,265 (18,771) 43 1.58%6.13%15.00%
Local Government Investment Pools 125,255,390 125,255,390 125,255,390 - 1 1.57%20.49%50.00%
Demand Deposits 3,027,748 3,027,748 3,027,748 - 1 1.00%0.50%-
Total Portfolio 611,064,138$ 613,068,792$ 611,166,048$ 1,902,744$ 282 2.08%100.00%-
Current 3 Months Ago 3 Month 1 Year Ago
Investment Pool Comparisons:12/31/2019 9/30/2019 Difference 12/31/2018
Par Value 611,064,138$ 596,080,671$ 14,983,467$ 627,577,468$
Market Value 613,068,792$ 597,577,745$ 15,491,047$ 624,491,587$
Book Value 611,166,048$ 595,794,891$ 15,371,157$ 626,046,406$
Unrealized Gain(Loss)1,902,744$ 1,782,854$ 119,890$ (1,554,819)$
Weighted Average Maturity 223 282 (59) 223
Yield to Maturity 1.96%2.08%-0.117%2.01%
Portfolio Composition:
U.S. Treasuries 29.31%26.83%2.47%10.69%
U.S. Federal Agencies 42.75%49.05%-6.30%43.55%
Municipal Bonds 0.00%0.67%-0.67%0.80%
Certificates of Deposit 0.82%0.84%-0.02%13.10%
Commercial Paper 6.13%6.28%-0.14%10.44%
Local Government Investment Pools 20.49%15.88%4.61%21.12%
Demand Deposits 0.50%0.45%0.04%0.30%
Bank Collateral Review**:Institution Collateral Type Market Value Collected Balance Collateral Ratio
Wells Fargo Demand Deposits BNY Mellon U.S. Agency MBS 25,605,391$ 3,027,748$ 845.69%
Independent Bank Certificates of Deposit Fed Home Loan Bank Standby LOC 8,140,172$ 4,949,989$ 164.45%
**Does not include FDIC insurance
Depository Ledger Balance Review:Institution Account Type Beginning Bal.Deposits Ending Bal.
Wells Fargo Bank Checking 3,780,768$ 98,714,262$ 3,027,748$
Compliance Statement & Review:
99,467,282$
Treasury Manager
Preparer: Nancy Towle, CGFO
NANCY TOWLE
Chief Financial Officer Director of Finance
Reviewer: David Gaines
DAVID GAINES
Withdrawals
TheQuarterlyInvestmentReportis infull compliance withtheobjectives,restrictions,andstrategiesas setforthin the CityofDenton'sInvestmentPolicy and
the Public Funds Investment Act (Texas Government Code, Chapter 2256.023).
Reviewer: Antonio Puente, Jr., CGFO
-0.80%
-12.28%
0.20%
Pledge Required
-4.31%
> 102%
> 100%
-0.63%
ANTONIO PUENTE JR.
-
-0.05%
-0.80%
(11,422,795)$
(14,880,358)$
3,457,563$
18.62%
CITY OF DENTON : QUARTERLY INVESTMENT REPORT
1 Year Ago
Difference
(16,513,330)$
1Unrealizedgain/(loss)isthe difference betweenthemarket and book value and does not represent anactual gainorloss.Gains andlossesarerealizedonly
when asecurity issold prior to maturity.Since itis the City's practice to hold investments until theymature,the temporary gains andlosses are unlikely to be
realized.
1st Fiscal Quarter 2019- December 31, 2019 Page 2
INVESTMENT POOL
Current 3 Months Ago 3 Month 1 Year Ago 1 Year
12/31/2019 9/30/2019 Difference 12/31/2018 Difference
Par Value - U.S. Treasuries 179,000,000 160,000,000$ 19,000,000$ 67,500,000$ 111,500,000$
Par Value - U.S. Federal Agencies 261,281,000 292,281,000 (31,000,000) 272,956,000 (11,675,000)
Par Value - Municipal Bonds 4,000,000 (4,000,000) 5,000,000 (5,000,000)
Certificates of Deposit 5,000,000 5,000,000 - 82,000,000 (77,000,000)
Par Value - Commercial Paper 37,500,000 37,500,000 - 66,000,000 (28,500,000)
Local Government Investment Pools 125,255,390 94,609,584 30,645,806 132,202,864 (6,947,474)
Demand Deposits 3,027,748 2,690,087 337,661 1,918,604 1,109,144
Total Par Value 611,064,138$ 596,080,671$ 14,983,467$ 627,577,468$ (16,513,330)$
Market Value - U.S. Treasuries 179,736,593 160,421,080$ 19,315,513$ 67,136,495$ 112,600,098$
Market Value - U.S. Federal Agencies 262,596,567 293,474,372 (30,877,805) 270,938,188 (8,341,621)
Market Value - Municipal Bonds 4,000,000 (4,000,000) 4,948,950 (4,948,950)
Certificates of Deposit 5,000,000 5,000,000 - 82,000,000 (77,000,000)
Market Value - Commercial Paper 37,452,494 37,382,622 69,872 65,346,486 (27,893,992)
Local Government Investment Pools 125,255,390 94,609,584 30,645,806 132,202,864 (6,947,474)
Demand Deposits 3,027,748 2,690,087 337,661 1,918,604 1,109,144
Total Market Value 613,068,792$ 597,577,745$ 15,491,047$ 624,491,587$ (11,422,795)$
Book Value - U.S. Treasuries 179,126,075 159,877,995$ 19,248,080$ 66,927,741$ 112,198,334$
Book Value - U.S. Federal Agencies 261,285,570 292,230,562 (30,944,992) 272,619,818 (11,334,248)
Book Value - Municipal Bonds 4,000,000 (4,000,000) 5,000,000 (5,000,000)
Certificates of Deposit 5,000,000 5,000,000 - 82,000,000 (77,000,000)
Book Value - Commercial Paper 37,471,265 37,386,663 84,602 65,377,379 (27,906,114)
Local Government Investment Pools 125,255,390 94,609,584 30,645,806 132,202,864 (6,947,474)
Demand Deposits 3,027,748 2,690,087 337,661 1,918,604 1,109,144
Total Book Value 611,166,048$ 595,794,891$ 15,371,157$ 626,046,406$ (14,880,358)$
Accrued Interest 2,662,163$ 1,925,422$ 736,741$ 3,374,014$ (711,851)$
Cash Value -615,730,955$ 599,503,167$ 16,227,788$ 627,865,601$ (12,134,646)$
(Total Market Value + Accrued Interest)
Unrealized Gain/(Loss)1,902,744$ 1,782,854$ 119,890$ (1,554,819)$ 3,457,563$
Change in Fair Value since 9/30/18 -(288,646)$ (671,478)$ 382,832$ (1,516,332)$ 1,227,686$
(GASB 31)
Strategy Statement:The investment pool is an aggregation of the majority of City fundswhich may include taxreceipts,enterprisefund revenues,fine and fee income,as
wellas some,but not necessarily all bond proceeds,grants,gifts and endowments.This portfolio is maintained to meetanticipateddailycash needs
for theCity's operations,capital projects and debt service.In order to meet these obligationsand to minimize potential liquidation losses,the dollar-
weighted stated average maturity of the investment pool shall not exceed 1.5 years or 550 days.The objectives of this portfolio areto:(1)ensure
safety ofprincipal by investing in onlyhigh quality securities for which a strong secondary marketexists;(2)ensurethat anticipated cashflow needs
are matched with adequate investment liquidity;(3)limit market and credit risk through diversification;and (4)attain the best feasible yield,
commensurate with theobjectives and restrictions set forthin the Investment Policy,by activelymanaging theportfolio to meet or exceed the twelve
month moving average yield of a one year U.S. Treasury bill as derived from the Federal Reserve Statistical Release H.15 for constant maturities.
CITY OF DENTON : QUARTERLY INVESTMENT REPORT
1st Fiscal Quarter 2019- December 31, 2019 Page 3
INVESTMENT POOL
Current 3 Months Ago 1 Year Ago
Summary By Security Type:12/31/2019 9/30/2019 12/31/2018
U.S. Treasuries - Coupon 179,126,075$ 159,877,995$ 66,927,741$
U.S. Federal Agencies - Amort - - 6,107,691
U.S. Federal Agencies - Coupon 245,529,570 276,474,562 245,756,279
U.S. Federal Agencies - Callable 15,756,000 15,756,000 20,755,849
Municipal Bonds - Coupon - 4,000,000 5,000,000
Certificates of Deposit - CDARS - - 42,000,000
Certificates of Deposit - SLOC 5,000,000 5,000,000 40,000,000
Commercial Paper - Discount 37,471,265 37,386,663 65,377,379
Local Government Investment Pools 125,255,390 94,609,584 132,202,864
Demand Deposits 3,027,748 2,690,087 1,918,604
Total Book Value 611,166,048$ 595,794,891$ 626,046,407$
Objective:
Current 3 Months Ago 1 Year Ago
Summary By Security Type:12/31/2019 9/30/2019 12/31/2018
U.S. Treasuries - Coupon 29.31%26.83%10.69%
U.S. Federal Agencies - Amort --0.97%
U.S. Federal Agencies - Coupon 40.17%46.40%39.26%
U.S. Federal Agencies - Callable 2.58%2.65%3.32%
Municipal Bonds - Coupon -0.67%0.80%
Certificates of Deposit - CDARS --6.71%
Certificates of Deposit - SLOC 0.82%0.84%6.39%
Commercial Paper - Discount 6.13%6.28%10.44%
Local Government Investment Pools 20.49%15.88%21.12%
Demand Deposits 0.50%0.45%0.31%
Total 100.00%100.00%100.00%
CITY OF DENTON : QUARTERLY INVESTMENT REPORT
Theportfolio isrestrictedtoU.S.Treasuries and agency securities (maturinginless thanfive years);state and locally issued Texas municipal bonds ratedAA
or better (maturing in less than three years);insured,collateralized,or standby letter of credit backed certificates of deposit (maturing in less than three
years);collateralized repurchase agreements (maturing in less than thirty days);commercial paper rated A-1/P-1 or better (maturingin lessthan 270days);
and local government pools & SEC registered government money market mutual funds (weighted average maturity of less than 60 days).
U.S. Treasuries -Coupon
29.31%
U.S. Federal Agencies -Coupon
40.17%
U.S. Federal Agencies -
Callable
2.58%
CD -SLOC
0.82%
Commercial Paper -Discount
6.13%
Local Government Investment Pools
20.49%
Demand Deposits
0.50%
Current
12/31/2019
1st Fiscal Quarter 2019- December 31, 2019 Page 4
INVESTMENT POOL
Current 3 Months Ago 1 Year Ago
Summary By Issuer:12/31/2019 9/30/2019 12/31/2018
CDARS CDs -$ -$ 42,000,000$
CORNELL UNIVERSITY 4,995,938 - -
DALLAS, TX WTR & SWR REV BDS - 4,000,000 4,000,000
FFCB 68,570,870 68,582,551 67,645,911
FHLB 121,984,247 142,993,541 113,959,085
FHLMC 45,923,966 45,854,964 30,870,083
FNMA 24,806,488 34,799,506 77,690,423
INDEPENDENT BANK CDs 5,000,000 5,000,000 15,000,000
JP MORGAN SECURITIES LLC 4,999,286 4,966,447 15,830,273
KAISER 4,997,939 9,968,250 -
LEGACYTEXAS BANK CDs*- - 25,000,000
NATIXIS NY BRANCH - - 14,746,283
NESTLE FINANCE INTL LTD - 4,994,906 -
NORTHWESTERN UNIVERSITY 2,493,469 2,488,863 -
RBC 4,989,092 - 4,947,500
STATE OF CALIFORNIA 5,000,000 5,000,000 -
TEXAS A&M UNIV REV BDS - - 1,000,000
TEXPOOL 25,000,000 25,054,194 25,102,864
TEXSTAR 100,255,390 69,555,390 107,100,000
TOYOTA MOTOR CREDIT CORP 4,995,542 4,968,197 29,853,322
U.S. TREASURY 179,126,075 159,877,995 49,382,057
UNIVERSITY OF NORTH CAROLINA 5,000,000 5,000,000 -
WELLS FARGO DEMAND DEPOSITS 3,027,748 2,690,087 1,918,604
Total Book Value 611,166,048$ 595,794,891$ 626,046,406$
Objective:
Current 3 Months Ago 1 Year Ago
Summary By Issuer:12/31/2019 9/30/2019 12/31/2018
CDARS CDs - - 6.71%
CORNELL UNIVERSITY 0.81%- -
DALLAS, TX WTR & SWR REV BDS - 0.67%0.64%
FFCB 11.22%11.51%10.80%
FHLB 19.96%24.00%18.20%
FHLMC 7.51%7.70%4.93%
FNMA 4.06%5.84%12.41%
INDEPENDENT BANK CDs 0.82%0.84%2.40%
JP MORGAN SECURITIES LLC 0.82%0.83%2.53%
KAISER 0.81%1.67%-
LEGACYTEXAS BANK CDs*- - 3.99%
NATIXIS NY BRANCH - - 2.36%
NESTLE FINANCE INTL LTD - 0.84%-
NORTHWESTERN UNIVERSITY 0.41%0.42%-
RBC 0.82%- 0.79%
STATE OF CALIFORNIA 0.82%0.84%-
TEXAS A&M UNIV REV BDS - - 0.16%
TEXPOOL 4.09%4.22%4.01%
TEXSTAR 16.40%11.67%17.11%
TOYOTA MOTOR CREDIT CORP 0.82%0.83%4.77%
U.S. TREASURY 29.31%26.83%7.89%
UNIVERSITY OF NORTH CAROLINA 0.82%0.84%-
WELLS FARGO DEMAND DEPOSITS 0.50%0.45%0.30%
Total 100.00%100.00%100.00%
*Formerly, ViewPoint Bank
CITY OF DENTON : QUARTERLY INVESTMENT REPORT
It is the policy of the City to diversify its investment portfolio by restricting investments in a single issuer/institution to no more than 35 percent of the portfolio's total book value and to those offering repurchase agreements, collateralized CDs (including standby letters of credit), and local or state of Texas municipal securities to no greater than 15
percent. The purpose of this requirement is to limit market and credit risk. Commercial paper issuers are further restricted by a 5 percent total portfolio limitation. There are no issuer limitations on U.S. Treasuries or FDIC insured products except as they pertain to the overall 35% certificates of deposit and 15% savings deposit restrictions. Some
investment types may be further limited.
0.41%0.81%0.50%
0.82%
0.82%
0.82%
0.82%
0.82%0.82%0.81%
4.09%
4.06%7.51%
11.22%
16.40%
19.96%
29.31%
Current
12/31/2019
NORTHWESTERN UNIVERSITY
CORNELL UNIVERSITY
WELLS FARGO DEMAND DEPOSITS
JP MORGAN SECURITIES LLC
TOYOTA MOTOR CREDIT CORP
INDEPENDENT BANK CDs
RBC
STATE OF CALIFORNIA
UNIVERSITY OF NORTH CAROLINA
KAISER
TEXPOOL
FNMA
FHLMC
FFCB
TEXSTAR
FHLB
U.S. TREASURY
1st Fiscal Quarter 2019- December 31, 2019 Page 5
INVESTMENT POOL
Current 3 Months Ago 1 Year Ago
Maturity Time Frame:12/31/2019 9/30/2019 12/31/2018
00-03 Months 268,783,138$ 149,799,671$ 250,121,468$
03-06 Months 77,000,000 118,000,000 76,000,000
06-12 Months 84,756,000 136,756,000 109,200,000
12-24 Months 160,525,000 164,025,000 184,756,000
24 Months & Over 20,000,000 27,500,000 7,500,000
Total Par Value 611,064,138$ 596,080,671$ 627,577,468$
Objective:
Current 3 Months Ago 1 Year Ago
Maturity Time Frame:12/31/2019 9/30/2019 12/31/2018
00-03 Months 43.99%25.13%39.85%
03-06 Months 12.60%19.80%12.11%
06-12 Months 13.87%22.94%17.40%
12-24 Months 26.27%27.52%29.44%
24 Months & Over 3.27%4.61%1.20%
Total 100.00%100.00%100.00%
CITY OF DENTON : QUARTERLY INVESTMENT REPORT
Therisk of market price volatility is minimizedthroughmaturity diversification.Investment maturities are staggered toprovide cash flows based on
the anticipated needs of the City.Liquidity is achieved by matching investment maturities with forecasted cash disbursements and by investing in
securities with active secondary markets.Short-term local government investment pools and government money market mutual funds help to
provide daily liquidity and may be utilized as a competitive alternative to other fixed income investments.
$0
$50,000,000
$100,000,000
$150,000,000
$200,000,000
$250,000,000
$300,000,000
$350,000,000
$400,000,000
$450,000,000
$500,000,000
$550,000,000
$600,000,000
$650,000,000
$700,000,000
Current 3 Months Ago 1 Year Ago
00-06 Months 06-12 Months 12-24 Months 24 Months & Over
1st Fiscal Quarter 2019- December 31, 2019 Page 6
ECONOMIC SUMMARY
Interest Rate History
Source: U.S. Federal Reserve Statistical
Release (H.15)
Dec-14 Mar-15 Jun-15 Sep-15 Dec-15 Mar-16 Jun-16 Sep-16 Dec-16 Mar-17 Jun-17 Sep-17
Market Sector:Avg Avg Avg Avg Avg Avg Avg Avg Avg Avg Avg Avg
Fed Funds (effective)0.12%0.11%0.13%0.14%0.24%0.36%0.38%0.40%0.54%0.79%1.04%1.15%
3-Month U.S. T-Bill 0.03%0.03%0.02%0.02%0.23%0.30%0.27%0.29%0.51%0.75%1.00%1.05%
2-Year U.S. T-Note 0.64%0.64%0.69%0.71%0.98%0.88%0.73%0.77%1.20%1.31%1.34%1.38%
Portfolio Benchmark*0.12%0.15%0.18%0.24%0.32%0.41%0.49%0.54%0.61%0.69%0.83%1.00%
Portfolio Yield 0.55%0.57%0.57%0.65%0.72%0.79%0.81%0.90%0.95%1.07%1.16%1.25%
Dec-17 Mar-18 Jun-18 Sep-18 Dec-18 Mar-19 Jun-19 Sep-19 Dec-19 Mar-20 Jun-20 Sep-20
Market Sector:Avg Avg Avg Avg Avg Avg Avg Avg Avg Avg Avg Avg
Fed Funds (effective)1.30%1.67%1.90%2.15%2.40%2.41%2.37%1.90%2.40%
3-Month U.S. T-Bill 1.32%1.71%1.92%2.20%2.36%2.39%2.09%1.82%2.36%
2-Year U.S. T-Note 1.84%2.27%2.53%2.57%2.49%2.26%2.10%1.76%2.49%
Portfolio Benchmark*1.20%1.46%1.75%2.05%2.33%2.48%2.00%1.80%1.55%
Portfolio Yield 1.29%1.42%1.58%1.73%2.01%2.20%2.20%2.08%1.96%
*Twelve month moving average of a
one year U.S. T-bill yield
Fiscal Year:
2019-2020
2018-2019
2017-2018
2016-2017
2015-2016
QUARTERLY COMMENTARY
December 31, 2019
2,138,420$ 8,955,045$
3,035,543$ -$ -$ -$
1,175,753$ 2,763,135$
Source: Hilltop Securities Asset
Management Economic Summary
CITY OF DENTON : QUARTERLY INVESTMENT REPORT
Fiscal Year 2014-2015 Fiscal Year 2015-2016 Fiscal Year 2016-2017
Fiscal Year to Date Earnings
3 Months 6 Months 9 Months 12 Months
849,369$
The portfolio was in compliance with the City's Investment Policy during the first quarter. In July, there were maturities totaling
$25 million, and $39 million in purchases at an average yield of 2.01%. In August, there were maturities totaling $43.7 million
with an average yield of 1.91%. Purchases in August totaled approximately $22.5 million at an average yield of 1.99%. During
September, three investments matured totaling $18 million with an average yield of 1.97%, and seven new investments were
purchased totaling $60 million with an average yield of 1.84%. The portfolio's weighted average yield remains higher than the
benchmark 12-month Treasury bill index by 28 basis points. Portfolio liquidity at the end of December was approximately
20.99%. The Fed cut interest rates twice this quarter by 25 basis points each time, moving the target range to 1.75% to 2.0%.
Further tariffs are expected by the end of the year, along with another predicted rate cut in December. Staff will continue to
monitor the investment portfolio and ensure compliance with the City's Investment Policy and the Public Funds Investment Act.
Fiscal Year 2018-2019
4,317,890$ 6,515,166$
2,743,857$ 1,771,206$
12,354,692$ 9,262,499$ 6,122,536$
4,734,315$ 6,999,226$
3,961,973$
2,955,835$
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
Fiscal Year 2017-2018 Fiscal Year 2019-2020
0.00%
1.00%
2.00%
3.00%
Dec-14 Mar-15 Jun-15 Sep-15 Dec-15 Mar-16 Jun-16 Sep-16 Dec-16 Mar-17 Jun-17 Sep-17 Dec-17 Mar-18 Jun-18 Sep-18 Dec-18 Mar-19 Jun-19 Sep-19 Dec-19
Fed Funds 3-Month T-Bill 2-Year T-Note Portfolio Yield Portfolio Benchmark*
FY 2014-15 FY 2015-16 FY 2016-17 FY 2017-18 FY 2018-19 FY 2019-20
CITY OF DENTON
CIP Funds Summary
As of December 31, 2019
More than Remaining Encumbered Unencumbered
Departments:0-4YR 5-8YR 9-10YR 10YR Amount Amount Amount
Facilities 24,828,271$ 4,702,479$ -$ -$ 29,530,750$ 11,985,755$ 17,544,995$
Airport 3,616,882 - - - 3,616,882 267,886 3,348,996$
Engineering 30,830,887 46,126,721 5,302,316 5,227,176 87,487,100 44,067,906 43,419,194$
Development 7,077,585 33,201 - - 7,110,786 726,796 6,383,990$
Customer Service 37,694 - - - 37,694 - 37,694$
Streets 32,629,228 - - - 32,629,228 2,813,329 29,815,899$
Traffic 11,220,300 2,028,917 - 16,292 13,265,509 2,392,615 10,872,894$
Parks 6,939,475 616,133 150,875 - 7,706,483 799,921 6,906,562$
Public Arts 582,867 - - - 582,867 105,016 477,851$
Water 31,372,873 30,556,579 1,010,089 - 62,939,541 44,970,593 17,968,948$
Wastewater 27,094,859 4,257,179 20,355,408 750 51,708,196 22,167,246 29,540,950$
Drainage 7,544,510 1,140,725 - - 8,685,235 5,403,276 3,281,959$
Solid Waste 19,133,594 - - - 19,133,594 5,850,659 13,282,935$
Warehouse 229,006 - - - 229,006 - 229,006$
Motor Pool 4,797,468 - - - 4,797,468 1,207,263 3,590,205$
Fleet 804,631 - - - 804,631 78,694 725,937$
Tech Services 6,245,728 64,428 - - 6,310,156 2,567,667 3,742,489$
Electric 76,332,885 24,236,811 1,076,346 1,053,540 102,699,582 18,735,306 83,964,276$
Total City 291,318,743$ 113,763,173$ 27,895,034$ 6,297,758$ 439,274,708$ 164,139,928$ 275,134,780$
|----- ---- ---- ---- ---- Project Age ---- ---- ---- ---- -----|
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
100185XXX CITY BUILDING ADA REPAIRS Total 460,887.27 189,564.43 271,322.84 0.16 271,322.68
100194XXX FIRE STATION#3 REBUILD Total 9,403,525.90 4,871,825.37 4,531,700.53 4,352,478.47 179,222.06
100198XXX POLICE FIRING RANGE IMPR Total 205,969.00 150,920.70 55,048.30 500.00 54,548.30
100199XXX POLICE REMODEL & RELOCATION Total 316,403.64 290,424.33 25,979.31 25,125.25 854.06
100201XXX PARKING LOT ENHANCEMENTS Total 203,950.00 114,199.28 89,750.72 40,877.36 48,873.36
100218XXX FIRE STATION #8 LAND ACQ Total 5,439,724.32 674,164.08 4,765,560.24 4,336,000.44 429,559.80
100231XXX COMMUNICATION CENTR RELOCATION Total 103,596.36 93,228.41 10,367.95 865.71 9,502.24
100232XXX CITY HALL WEST BUILDING USAGE Total 111,918.35 93,430.91 18,487.44 18,487.44 -
100233XXX AMERICAN LEGION HALL RENOVATIO Total 829,124.94 112,234.30 716,890.64 6,434.00 710,456.64
100235XXX MULTI PARKING LOT REPLACEMENT Total 2,728,986.31 344,548.09 2,384,438.22 243,133.30 2,141,304.92
100248XXX CCNHC TRAIL IMPROVEMENTS Total 324,000.00 197,907.10 126,092.90 - 126,092.90
100251XXX 2018 HVAC-FLOORING-ROOFS Total 1,062,410.74 356,189.32 706,221.42 132,021.45 574,199.97
100252XXX CITY HALLl-FS#1-SBLB REROOF Total 1,524,260.54 1,516,760.54 7,500.00 7,500.00 -
100254XXX 651 MAYHILL BLDG RENOVATION Total 1,626,069.40 321,067.96 1,305,001.44 55,991.04 1,249,010.40
100255XXX SERVICE CENTER RENOVATION Total 8,286,663.53 387,519.75 7,899,143.78 175,826.78 7,723,317.00
100257XXX NEW WORK ORDER SOFTWARE Total 57,629.71 52,969.71 4,660.00 4,500.00 160.00
100262XXX THREE OUTDOOR WARNING SIRENS Total 82,800.00 5,790.00 77,010.00 76,323.00 687.00
100264XXX BE-14 POLICE FAC DESIGN/LAND Total 3,999,061.00 614,067.84 3,384,993.16 2,509,690.00 875,303.16
100265XXX ANIMAL SERVICES FLOOR DRAINS Total 7,500.00 6,621.68 878.32 - 878.32
100266XXX LEGAL REMODEL Total 64,902.41 40,428.03 24,474.38 - 24,474.38
100267XXX N BRANCH LIBRARY NOISE CONTROL Total 30,000.00 22,470.44 7,529.56 - 7,529.56
100268XXX 2019 HVAC-FLOORING-ROOFS Total 3,000,000.00 - 3,000,000.00 - 3,000,000.00
100271XXX NEW CHAIRS FOR CITY COUNCIL Total 25,000.00 9,176.50 15,823.50 - 15,823.50
109999XXX FACILITIES UNALLOCATED FUNDING Total 101,875.14 - 101,875.14 - 101,875.14
Grand Total 39,996,258.56 10,465,508.77 29,530,749.79 11,985,754.40 17,544,995.39
City of Denton -Job Cost Summary
Facilities
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
200033XXX FY 2018 AIRPORT ROAD PAVING Total 881,396.56 783,746.56 97,650.00 23,550.00 74,100.00
200052XXX WEST SIDE PARALLEL RUNWAY Total 2,544,270.00 2,446,910.00 97,360.00 - 97,360.00
200062XXX FY18 PRIMARY RUNWAY & TAXIWAY Total 50,000.00 18,992.00 31,008.00 - 31,008.00
200063XXX FY 2018 NORTH TAXIWAY & RUNWAY Total 360,000.00 - 360,000.00 - 360,000.00
200065XXX CONTROL TOWER EQUIPMENT 2018 Total 90,000.00 7,100.00 82,900.00 400.00 82,500.00
200070XXX DENTON MED TRANSPORTATION Total 149,300.00 - 149,300.00 - 149,300.00
200071XXX AIRPORT PAVEMENT MAINTENANCE Total 250,000.00 46,618.08 203,381.92 - 203,381.92
200072XXX TXDOT RNWY LGHTING - WEST SIDE Total 180,160.00 - 180,160.00 - 180,160.00
200073XXX FY19 ARPRT SECURITY ENHANCMENT Total 250,000.00 193.08 249,806.92 214,501.98 35,304.94
200074XXX FY19 AIRPORT CONF ROOM UPGRADE Total 15,000.00 - 15,000.00 - 15,000.00
200075XXX AIRPORT LANDSIDE PAVING Total 1,300,000.00 1,883.17 1,298,116.83 29,434.37 1,268,682.46
209999XXX AIRPORT UNALLOCATED Total 852,198.12 - 852,198.12 - 852,198.12
Grand Total 6,922,324.68 3,305,442.89 3,616,881.79 267,886.35 3,348,995.44
City of Denton -Job Cost Summary
Airport
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
250009XXX VINTAGE BLVD (BB TO IH 35W) Total 332,066.47 315,788.95 16,277.52 105,822.48 (89,544.96)
250013XXX CITY-WIDE SW & ADA RAMP SURVEY Total 5,020.58 - 5,020.58 - 5,020.58
250021XXX BE14-RUDDELL EXTENSION @ MINGO Total 1,635,794.00 316,935.80 1,318,858.20 0.25 1,318,857.95
250022XXX MORSE EXPAN LOOP288-MYHIL Total 3,150,000.00 236,795.73 2,913,204.27 253,180.83 2,660,023.44
250023XXX BB PH4 2ND ARTL IH35E-N SCRIP Total 11,213,756.07 8,660,528.16 2,553,227.91 421,923.08 2,131,304.83
250028XXX ENG SOFTWARE EQPMT & TNG Total 492,865.00 49,600.00 443,265.00 2,000.00 441,265.00
250043XXX HICKORY CREEK FM2181-2499 ENG Total 300,000.00 234,287.51 65,712.49 95,582.55 (29,870.06)
250044XXX HICKORY CREEK FM2181-2499- ROW Total 50,000.00 439,208.55 (389,208.55) 3,700.00 (392,908.55)
250045XXX HICKORY CREEK FM2181-2499 CONS Total 2,650,000.00 20,588.64 2,629,411.36 - 2,629,411.36
250046XXX N Texas BLVD ROUNDABOUT-ENG Total 401,029.73 74,024.49 327,005.24 25,473.66 301,531.58
250047XXX N TX BLVD ROUNDABOUT-CONSTRUCT Total 1,600,000.00 - 1,600,000.00 - 1,600,000.00
250049XXX ADA STUDY FOR ST/ROW/SIDEWALKS Total 205,000.00 182,164.75 22,835.25 22,835.25 -
250063XXX RTR- MCKINNEY (FORMERLY FM426) Total 18,267,303.00 4,070,231.69 14,197,071.31 12,271,950.87 1,925,120.44
250073XXX WARSCHUN INTRSECTION&TRUN LANE Total 101,827.91 2,792.92 99,034.99 - 99,034.99
250074XXX BIKE-PED CORDINATOR CONSLT SVC Total 45,000.00 44,999.50 0.50 - 0.50
250075XXX DOWNTOWN TIF PROJECTS Total 1,466,845.00 414,431.73 1,052,413.27 465,925.98 586,487.29
250076XXX BB PH6 2ND ARTERIAL UNI-WINSOR Total 7,486,146.43 1,145,161.85 6,340,984.58 1,301,504.22 5,039,480.36
250077XXX US 380 LIGHTING STUDY Total 75,000.00 74,679.91 320.09 - 320.09
250078XXX DOWNTOWN MEWS STREETS STUDY Total 177,076.95 122,692.42 54,384.53 15,542.39 38,842.14
250079XXX STANDARD CONSTRUCTION SPEC Total 1,008,800.00 901,254.19 107,545.81 116,608.89 (9,063.08)
250080XXX RYAN ROAD THOROUGHFARE PROJECT Total 200,000.00 7,616.79 192,383.21 - 192,383.21
250081XXX BE14-HICKORY CREEK ROAD REALIG Total 3,300,000.00 879,841.91 2,420,158.09 680,251.87 1,739,906.22
250100XXX EVERS WAY RETAINING WALL SURVE Total 5,710.00 6,230.37 (520.37) - (520.37)
250101XXX ENG SOFTWARE RTVISION Total 50,000.00 - 50,000.00 - 50,000.00
250102XXX LANDSCAPE REPAIR Total 4,000.00 3,000.00 1,000.00 - 1,000.00
250103XXX RAYZOR SOUTH PIPEBURST Total 998,778.00 367,636.78 631,141.22 282,396.00 348,745.22
250104XXX FURNITURE FOR DEVELOPMENT STAF Total 50,000.00 2,013.08 47,986.92 4,202.50 43,784.42
250105XXX FURNITURE FOR ENG CONFERENCE Total 45,000.00 978.00 44,022.00 - 44,022.00
250106XXX 2018 SIDEWALK CONSTRUCTION Total 282,177.09 16,236.27 265,940.82 218,444.32 47,496.50
250107XXX TRAFFIC OFFICE FURNITURE RELOC Total 5,000.00 - 5,000.00 2,991.34 2,008.66
350044XXX HICKORY CREEK FM2181-RIVERPASS Total 6,269,999.53 1,042,823.12 5,227,176.41 5,272,109.06 (44,932.65)
350045XXX BE14-MISC ROADWAYS Total 1,300,000.00 - 1,300,000.00 - 1,300,000.00
350280XXX MAYHILL PHASE 1 ENGINEERING Total 6,665,877.02 6,666,834.72 (957.70) - (957.70)
350281XXX MAYHILL PHASE 2 RIGHT OF WAY Total 11,600,333.48 11,306,426.20 293,907.28 - 293,907.28
350282XXX MAYHILL PHASE 3 UTILITIES Total 521,352.01 491,124.61 30,227.40 - 30,227.40
350283XXX MAYHILL PHASE 4 CONSTRUCTION Total 38,507,436.86 34,334,198.45 4,173,238.41 4,352,517.53 (179,279.12)
350285XXX BONNIE BRAE SOUTH ENGINEERING Total 7,906,967.23 6,761,652.91 1,145,314.32 733,125.04 412,189.28
350286XXX BONNIE BR SOUTH RIGHT OF WAY Total 3,098,082.93 3,038,772.18 59,310.75 51,625.83 7,684.92
350287XXX BONNIE BRAE SOUTH UTILITIES Total 1,129,282.19 382,692.20 746,589.99 52,022.93 694,567.06
350288XXX BONNIE BR SOUTH CONSTRUCTION Total 46,363,646.76 11,673,452.97 34,690,193.79 17,285,246.86 17,404,946.93
350462XXX MAYHILL DCTA BRIDGE Total 5,000,000.00 3,258,640.27 1,741,359.73 30,922.46 1,710,437.27
359000XXX UNALLOCATED - ENGINEERING Total 1,066,263.92 - 1,066,263.92 - 1,066,263.92
Grand Total 185,033,438.16 97,546,337.62 87,487,100.54 44,067,906.19 43,419,194.35
City of Denton -Job Cost Summary
Engineering
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
100182XXX ANIM CONTR BLDG-FURN FIXT & EQ Total 158,023.00 157,725.81 297.19 - 297.19
100226XXX PUBLIC SAFETY RADIOS Total 2,000,000.00 1,997,702.00 2,298.00 - 2,298.00
100228XXX CAD SYSTEM REPLACEMENT Total 2,256,035.00 1,937,432.61 318,602.39 230,057.21 88,545.18
100243XXX EXPLOSIVE MAG & EQUIP SECURITY Total 14,000.00 14,262.76 (262.76) - (262.76)
300039XXX TIME ENTRY AUTOMATION Total 382,562.17 382,163.45 398.72 - 398.72
300047XXX USDN-TX SUSTAINABILITY PROFESS Total 4,997.00 4,105.99 891.01 - 891.01
300053XXX TECH DENTON CITY LEASE Total 202,173.26 198,757.86 3,415.40 3,415.40 -
300058XXX 83 POLICE OFFICER BODY CAMERAS Total 171,200.00 153,471.32 17,728.68 - 17,728.68
300060XXX TASK CHAIRS FOR LBRARY Total 22,000.00 21,774.07 225.93 216.77 9.16
300061XXX DENTON DEVELOPMENT CODE Total 250,000.00 240,924.87 9,075.13 - 9,075.13
300068XXX POLICE PARKING LOT FENCING Total 90,000.00 83,016.29 6,983.71 - 6,983.71
300070XXX SMALL AREA PLAN SECTOR 1 SOUTH Total 239,252.00 167,450.28 71,801.72 71,801.72 -
300071XXX HISTORIC PRESERVATION PLAN Total 120,000.00 67,763.98 52,236.02 - 52,236.02
300073XXX BUDGETING SOFTWARE Total 262,871.00 255,118.64 7,752.36 21,727.56 (13,975.20)
300077XXX COURTROOM AV EQUIPMENT Total 30,000.00 106.53 29,893.47 - 29,893.47
300079XXX LIBRARY MASTER PLAN Total 41,632.00 31,224.00 10,408.00 10,408.00 -
300080XXX MUNI ARCHIVES SUPPLIES & EQPT Total 8,000.00 8,036.33 (36.33) - (36.33)
300082XXX SATELLITE WORK STATION Total 6,315.00 - 6,315.00 - 6,315.00
300083XXX SRO RESPONSE EQUIPMENT Total 26,718.00 24,468.86 2,249.14 - 2,249.14
300084XXX LEGAL CONFERENCE ROOM CHAIRS Total 5,658.00 5,193.04 464.96 464.96 -
300085XXX POLICE DEPARTMENT SPACE STUDY Total 44,710.46 - 44,710.46 - 44,710.46
300086XXX MUNI COURT CONFENC RM BUILDOUT Total 3,500.00 516.32 2,983.68 - 2,983.68
300088XXX AUTOEXTERNAL DEFIBRILLATORS Total 53,888.40 51,937.15 1,951.25 - 1,951.25
300090XXX CPR DEVICES Total 142,172.00 - 142,172.00 142,171.38 0.62
300091XXX STATION#7 ALERTING SYSTEM Total 71,100.84 69,095.47 2,005.37 - 2,005.37
300093XXX WEST OAK PARKING Total 14,500.00 14,244.86 255.14 - 255.14
300094XXX NLC COMMUNITY RESILIENCE GRANT Total 10,000.00 - 10,000.00 6,250.00 3,750.00
300096XXX SECURITY CAMERAS AT ANIMAL SVC Total 4,500.28 4,480.26 20.02 - 20.02
300099XXX DAYBREAK BUILDING APPRAISAL Total 10,025,250.00 4,511,792.50 5,513,457.50 11,139.25 5,502,318.25
300100XXX FIRE HOSE REPLACEMENT Total 14,000.00 13,832.88 167.12 - 167.12
300101XXX EXHAUST FILTERS FIRE ST 5&6 Total 53,000.00 - 53,000.00 43,695.30 9,304.70
300102XXX LAND MGMT SOFTWARE-PLANNING Total 482,420.00 13,920.00 468,500.00 71,360.00 397,140.00
300103XXX LIBRARY PUBLIC TASK CHAIR REPL Total 22,673.00 22,672.59 0.41 - 0.41
300104XXX ECO DEV STRATEGIC PLAN Total 164,000.00 34,833.33 129,166.67 114,088.67 15,078.00
300105XXX COMPREHENSIVE PLAN UPDATE Total 95,000.00 - 95,000.00 - 95,000.00
300106XXX FINANCE OFFICE RENOVATION Total 25,000.00 - 25,000.00 - 25,000.00
309999XXX UNALLOCATED FINANCE FUNDS Total 4,414.19 - 4,414.19 - 4,414.19
400078XXX CLEAR CREEK HERITAGE CENTER Total 272,302.15 244,103.89 28,198.26 - 28,198.26
400127XXX WAY FINDING SIGNAGE Total 787,697.87 738,651.91 49,045.96 - 49,045.96
Grand Total 18,581,565.62 11,470,779.85 7,110,785.77 726,796.22 6,383,989.55
City of Denton -Job Cost Summary
Development
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
921706XXX BUS STOP IMPROVEMENTS Total 15,000.00 300.00 14,700.00 - 14,700.00
Grand Total 15,000.00 300.00 14,700.00 - 14,700.00
City of Denton -Job Cost Summary
Transportation
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
350425XXX BE12 - HINKLE DRIVE Total 2,400,842.00 133,502.94 2,267,339.06 1,720,483.11 546,855.95
350433XXX SMITH STREET Total 40,000.00 6,902.61 33,097.39 - 33,097.39
350434XXX JOHNSON STREET Total 40,000.00 6,620.21 33,379.79 - 33,379.79
350436XXX TRINITY BRIDGE Total 669,762.00 16,500.00 653,262.00 - 653,262.00
350457XXX WINDSOR DR (LOCUST -OLD NORTH) Total 838,613.00 659,224.09 179,388.91 7,881.03 171,507.88
350463XXX HICKORY ST PHV (WELCH-CARROLL) Total 696,765.28 214,442.77 482,322.51 89,935.83 392,386.68
350480XXX KING'S ROW Total 215,300.00 152,311.44 62,988.56 - 62,988.56
350481XXX YELLOWSTONE Total 228,350.00 219,470.83 8,879.17 - 8,879.17
350482XXX BE-14 KINGS ROW SID 487-4 Total 206,200.00 173,265.88 32,934.12 - 32,934.12
350483XXX BE-14 SHERATON RD SID 830, 830 Total 315,167.00 195,586.40 119,580.60 32,332.85 87,247.75
350485XXX BE-14 MASCH BRANCH Total 619,701.00 - 619,701.00 619,700.80 0.20
350489XXX BE-14 FORRESTRIDGE DR Total 576,542.00 314,762.14 261,779.86 203,121.05 58,658.81
350490XXX BE-14 HICKORY ST PH IV Total 400,000.00 343,512.30 56,487.70 29,095.56 27,392.14
350491XXX HICKORY ST SEWER RELOCATION Total 32,443.65 15,565.25 16,878.40 - 16,878.40
350492XXX HICKORY CREEK RD GUARDRAIL Total 35,000.00 34,649.00 351.00 - 351.00
350493XXX BE-14 SAGEWOOD ST Total 420,000.00 306,039.81 113,960.19 107,199.69 6,760.50
350494XXX BE-12 WELCH ST Total 69,713.00 - 69,713.00 3,579.00 66,134.00
350495XXX CO 14 2019 ST RECONSTRUCTION Total 5,850,715.00 1,382.31 5,849,332.69 - 5,849,332.69
350496XXX CO 12 2019 ST RECONSTRUCTION Total 2,821,449.61 - 2,821,449.61 - 2,821,449.61
350497XXX BE14 2019 ST RECONSTRUCTION Total 2,673,347.48 - 2,673,347.48 - 2,673,347.48
350498XXX BE12 2019 ST RECONSTRUCTION Total 655,127.98 - 655,127.98 - 655,127.98
359995XXX BE14-STREET RECONSTRUCTION Total 14,936,651.63 - 14,936,651.63 - 14,936,651.63
359996XXX GAS WELL- RDAP UNALLOCATED Total 386,738.02 - 386,738.02 - 386,738.02
359999XXX UNALLOCATED STREETS IMPRV FUND Total 294,537.54 - 294,537.54 - 294,537.54
Grand Total 35,422,966.19 2,793,737.98 32,629,228.21 2,813,328.92 29,815,899.29
City of Denton -Job Cost Summary
Streets
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
250011XXX BIKE TRAIL CROSSING BRINKER Total 40,000.00 2,743.76 37,256.24 13,290.00 23,966.24
250019XXX OAK/HICKORY BIKE ACCOMMODATION Total 220,000.00 156,841.38 63,158.62 5,868.89 57,289.73
250024XXX CRESCENT ST BIKE ACCOMMODATION Total 25,122.41 5,122.46 19,999.95 - 19,999.95
250025XXX DCTA BIKE HIKE TRAIL Total 70,000.00 43,500.01 26,499.99 4,726.99 21,773.00
250058XXX BE14 - EAST SIDE STUART RD SW Total 245,000.00 11,896.12 233,103.88 - 233,103.88
250061XXX 2017 MISC. BIKELANES STRIPING Total 50,000.00 37,246.00 12,754.00 (0.05) 12,754.05
250065XXX BICYCLES WAYFINDING SIGNS Total 8,348.49 360.26 7,988.23 - 7,988.23
250066XXX HERCULES BIKE (SHERMAN-LOCUST) Total 100,000.00 - 100,000.00 - 100,000.00
250067XXX AVE A BIKE (COLLINS-HIGHLAND) Total 35,000.00 - 35,000.00 - 35,000.00
250090XXX BE14-POCKRUS PAGE RD Total 86,501.00 78,858.93 7,642.07 6,500.67 1,141.40
259998XXX UNALLOCATED BIKE FUND Total 132,020.00 - 132,020.00 - 132,020.00
300037XXX HICKORY ST. RAILROAD IMPRV Total 525,905.00 80,005.84 445,899.16 9,112.61 436,786.55
310001XXX RAIL QUIET ZONE MKNNY-PRR Total 541,310.00 - 541,310.00 - 541,310.00
310004XXX MCKINNEY SWALK DIVEWAY- AUSTIN Total 85,000.00 77,466.31 7,533.69 - 7,533.69
310005XXX PARKWAY SIDEWALK ELM- LOCUST Total 122,000.00 2,533.96 119,466.04 26,289.75 93,176.29
350167XXX ELAP - SIGNALIZATION TIMING Total 206,701.75 190,410.00 16,291.75 - 16,291.75
360100XXX ITS COMM TRUNK LINES-TXDOT Total 2,164,500.00 1,764,148.72 400,351.28 173,520.22 226,831.06
360118XXX COLORADO/MEDPARK TRAFFIC SIG Total 16,580.00 - 16,580.00 - 16,580.00
360119XXX BELL AND SHERMAN SIGNAL Total 556,848.40 78,986.14 477,862.26 31,208.49 446,653.77
360140XXX US-380/WESTERN BLVD SIGNAL Total 397,522.37 396,856.52 665.85 - 665.85
360141XXX OAK & JAGOE TRAFFIC SIGNAL Total 373,941.72 205,112.75 168,828.97 116,863.51 51,965.46
360142XXX BELL & MINGO SIGNAL Total 423,192.70 32,174.00 391,018.70 15,546.00 375,472.70
360143XXX BE14 - BELL & EAGLE SIGNAL Total 100,000.00 11,125.00 88,875.00 10,375.00 78,500.00
360144XXX BE14 - TEASLEY & DALLAS SIGNAL Total 30,000.00 34,099.72 (4,099.72) - (4,099.72)
360148XXX IH35E & LILLIAN MILLER SIGNAL Total 53,865.00 - 53,865.00 - 53,865.00
360156XXX EAGLE CORRIDOR IMPROVEMENTS Total 49,119.61 16,630.08 32,489.53 - 32,489.53
360158XXX SHORT-TERM TRAFFIC IMPROVEMENT Total 2,120,000.00 1,136,133.35 983,866.65 260,566.04 723,300.61
360159XXX CMAQ SIDEWALKS Total 100,284.00 1,644.00 98,640.00 - 98,640.00
360161XXX 2018 SIDEWALK SEGMENTS DESIGN Total 432,000.00 366,167.28 65,832.72 146,553.52 (80,720.80)
360162XXX SHERMAN SW (BOLIVAR TO ELM) Total 25,000.00 3,208.46 21,791.54 21,881.08 (89.54)
360164XXX SIGNAL SPECIFICATION DEVELOPMT Total 10,000.00 9,150.00 850.00 - 850.00
360165XXX 2019 SIDEWALK SEGMENTS DESIGN Total 281,492.81 193,965.56 87,527.25 47,600.00 39,927.25
360166XXX FY18-19 SMALL TRANS PROJECTS Total 3,250,000.00 214,212.03 3,035,787.97 215,655.06 2,820,132.91
360168XXX SYCAMORE/WELCH BIKE&PEDESTRIAN Total 190,627.00 4,331.00 186,296.00 - 186,296.00
360169XXX INS SIGN STRIP HICKORY CREEK Total 40,000.00 29,435.00 10,565.00 - 10,565.00
360171XXX UNT I-35E SPECIAL EVENTS AGREE Total 60,000.00 53,082.60 6,917.40 - 6,917.40
360173XXX TRAFFIC WARRANT STUDIES Total 35,000.00 4,163.08 30,836.92 25,836.92 5,000.00
360174XXX HICKORY CREEK & MONTECIT SIGNA Total 341,690.49 - 341,690.49 - 341,690.49
360175XXX MOBILITY PLAN Total 605,330.00 199,866.00 405,464.00 337,434.00 68,030.00
City of Denton -Job Cost Summary
Traffic
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
City of Denton -Job Cost Summary
Traffic
360176XXX US-380/HERITAGE SIGNAL Total 108,664.17 - 108,664.17 35,843.75 72,820.42
360180XXX RAIL QUIET ZONE UNION PACIFIC Total 930,000.00 - 930,000.00 - 930,000.00
360181XXX WAZE DATA SHARING NCTCOG Total 5,000.00 - 5,000.00 - 5,000.00
360182XXX TXDOT IH35 E FR&BRINKER SIGNAL Total 205,000.00 56,393.93 148,606.07 204,937.15 (56,331.08)
360185XXX TWU TRAFFIC STUDY Total 70,000.00 - 70,000.00 - 70,000.00
369997XXX BE 14 STREET FUNDS FOR TRAFFIC Total 1,241,500.00 62,258.36 1,179,241.64 36,133.14 1,143,108.50
369999XXX UNALLOCATED TRAFFIC FUNDS Total (9,550.94) 463.76 (10,014.70) - (10,014.70)
921701XXX SAFETY FUND - OAK & FRY SIGNAL Total 383,400.00 88,283.70 295,116.30 240,650.00 54,466.30
921702XXX SAFETY FUND - ADA PROWAG IMPV Total 168,064.00 103,430.68 64,633.32 - 64,633.32
921705XXX PEDESTRIAN & BICYCLE SAFETY Total 7,000.00 - 7,000.00 - 7,000.00
921706XXX BUS STOP IMPROVEMENTS Total 15,000.00 300.00 14,700.00 - 14,700.00
921707XXX DOWNTOWN SIDEWALK IMPROVEMENTS Total 145,000.00 10,088.22 134,911.78 - 134,911.78
921710XXX SHERMAN@WINSOR TRAFFIC SIGNAL Total 400,000.00 20,183.50 379,816.50 55,366.50 324,450.00
921711XXX LOCUST@WINSOR TRAFFIC SIGNAL Total 400,000.00 26,206.00 373,794.00 18,994.00 354,800.00
921712XXX MCKINNEY@WOODROW TRAFFIC SIG Total 400,000.00 57,175.50 342,824.50 51,674.50 291,150.00
921713XXX CITYWIDE SPEED STUDY Total 80,000.00 - 80,000.00 - 80,000.00
921714XXX IH35E FR & FM 2181 SIGNAL Total 90,000.00 33,902.31 56,097.69 15,608.80 40,488.89
921715XXX LOOP 288 & MCKINNEY SIGNAL Total 55,000.00 3,364.68 51,635.32 22,853.00 28,782.32
921716XXX LOOP 288 & KINGS ROW SIGNAL Total 65,000.00 14,208.09 50,791.91 33,746.94 17,044.97
921717XXX LOOP 288 & US 380 SIGNAL Total 80,000.00 9,480.03 70,519.97 39,022.00 31,497.97
921718XXX FM 426 & MOCKINGBIRD SIGNAL Total 65,000.00 25,955.73 39,044.27 22,023.38 17,020.89
921719XXX TRAFFIC STRIPING TRUCK Total 150,000.00 - 150,000.00 146,933.00 3,067.00
Grand Total 19,203,979.98 5,953,170.81 13,250,809.17 2,392,614.86 10,858,194.31
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
400112XXX EMERGECY ACT PLAN LAKE FOREST Total 448,902.27 298,027.27 150,875.00 150,875.00 -
400145XXX Dog Park @ HWY 77 & HINKLE Total 613,529.50 497,399.42 116,130.08 26,584.29 89,545.79
400171XXX VELA SOCCER COMPLEX PHII Total 6,521,486.98 6,321,920.93 199,566.05 26,237.20 173,328.85
400173XXX PLAYGROUND REPLACEMENTS Total 850,483.21 595,527.92 254,955.29 - 254,955.29
400193XXX LOON LAKE TRAIL Total 63,352.00 17,870.38 45,481.62 18.40 45,463.22
400232XXX SKATE PARK AMENITY Total 60,000.00 - 60,000.00 - 60,000.00
400233XXX FITNESS EQUIPMENT REPLACEMENT Total 40,928.00 15,927.70 25,000.30 - 25,000.30
400242XXX CARL YOUNG PARK RESTROOM ADDT Total 99,026.18 25,437.25 73,588.93 24,692.84 48,896.09
400243XXX QUAKERTOWN PARK RESTROOM Total 152,000.00 18,243.58 133,756.42 53,171.01 80,585.41
400246XXX SOUTH LAKES PARK IMPROVEMENT Total 303,943.71 4,814.65 299,129.06 - 299,129.06
400247XXX TENNIS CENTER REMODL&EXPANSION Total 3,709,197.34 105,222.40 3,603,974.94 62,935.08 3,541,039.86
400248XXX SOUTH LAKES PARKING LOT Total 291,484.41 7,750.00 283,734.41 37,100.00 246,634.41
400251XXX DALLAS-TEASLEY BEAUTIFY NODE Total 80,521.19 30,808.66 49,712.53 6,000.00 43,712.53
400252XXX EAGLE-ELM BEAUTIFICATION NODE Total 80,521.19 29,280.28 51,240.91 15,207.20 36,033.71
400254XXX SW PARK MASTER PLAN AND DESIGN Total 685,000.00 24,922.88 660,077.12 - 660,077.12
400255XXX DENIA AND NL REC CABINET Total 21,115.27 - 21,115.27 - 21,115.27
400256XXX PARD 2019 MASTER PLAN Total 107,887.41 26,678.99 81,208.42 5,550.00 75,658.42
400257XXX NORTH LAKES MANTENANCE SHED Total 55,000.00 47,119.50 7,880.50 7,880.50 -
400258XXX PATRICK PARK Total 231,660.00 65,591.76 166,068.24 77,944.89 88,123.35
400259XXX QUAKERTOWN PLAYGROUND REPLACEM Total 100,000.00 - 100,000.00 100,000.00 -
400260XXX MLK PLAYGROUND REPL Total 160,500.00 - 160,500.00 160,500.00 -
400265XXX DALLAS PARK PROPERTY Total 5,000.00 1,750.00 3,250.00 - 3,250.00
400266XXX LAKE FOREST EXPANSION PROPERTY Total 5,000.00 1,800.00 3,200.00 2,800.00 400.00
400270XXX LEISURE SERVICES FURNITURE Total 27,083.40 2,336.60 24,746.80 - 24,746.80
400273XXX MILL PROPERTY Total 2,388,000.00 2,380,877.16 7,122.84 - 7,122.84
400274XXX MCKENNA PARK IMPROVEMENTS Total 15,000.00 8,908.53 6,091.47 - 6,091.47
400275XXX HWY 2499 GREEN RIBBON DESIGN Total 19,575.00 - 19,575.00 19,575.00 -
400280XXX NORTH LAKE SOCCER FENCE Total 16,490.00 - 16,490.00 16,490.00 -
400281XXX GOLF BALL DISPENSER Total 13,840.00 13,305.00 535.00 - 535.00
400282XXX CIVIC CTR TECH UPGRADE Total 6,359.53 - 6,359.53 6,359.53 -
400283XXX PARK PROPERTY ACQUISITION Total 1,005,000.00 - 1,005,000.00 - 1,005,000.00
400284XXX WELCH PROPERTY Total 8,000.00 - 8,000.00 - 8,000.00
409999XXX UNALLOCATED PARKS FUNDS Total 62,116.85 - 62,116.85 - 62,116.85
Grand Total 18,248,003.44 10,541,520.86 7,706,482.58 799,920.94 6,906,561.64
City of Denton -Job Cost Summary
Parks
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
300075XXX PD LOBBY BRICK SCULPTURES Total 54,300.00 26,969.39 27,330.61 28,330.61 (1,000.00)
400188XXX STATE BRINKER MEDALLIONS Total 200,000.00 - 200,000.00 - 200,000.00
400249XXX BE12-LOOP 288 BRDG. MEDALLIONS Total 28,300.00 20,615.00 7,685.00 7,685.00 -
400276XXX N LAKE TENNIS ART SCUPLTURE Total 35,000.00 - 35,000.00 - 35,000.00
400277XXX N LAKE DOG PARK SCULPTURE Total 35,000.00 - 35,000.00 - 35,000.00
400278XXX VELA ATHLETIC SCULPTURE Total 32,712.39 - 32,712.39 - 32,712.39
450001XXX MLK PUBLIC ART CMTE ART PIECE Total 70,252.00 46.50 70,205.50 69,000.00 1,205.50
450002XXX PARKS PUBLIC ART Total 20,000.00 - 20,000.00 - 20,000.00
450003XXX HOT PY19 PUBLIC ART C DENTON Total 18,477.00 - 18,477.00 - 18,477.00
459997XXX TRANSPORTATION-PUB ART UNALLOC Total 74,087.87 - 74,087.87 - 74,087.87
459998XXX PUBLIC SAFETY-PUBLI ART UNALLO Total 62,298.94 - 62,298.94 - 62,298.94
459999XXX PARKS - PUBLIC ART UNALLOCATED Total 69.19 - 69.19 - 69.19
Grand Total 630,497.39 47,630.89 582,866.50 105,015.61 477,850.89
City of Denton -Job Cost Summary
Public Arts
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
630081XXX TEASLEY FM 2181 TXDOT Total 3,737,674.12 2,719,757.83 1,017,916.29 194,863.98 823,052.31
630088XXX TANK PAINTING Total 3,449,961.59 2,947,695.32 502,266.27 - 502,266.27
630234XXX LAKE RAY ROBERTS OZONE Total 400,000.00 317,259.03 82,740.97 - 82,740.97
630240XXX CCNHC MAINT / HUNTING PERMITS Total 53,983.38 21,196.06 32,787.32 - 32,787.32
630248XXX SERVICE CENTER FS MAINTENANCE Total 136,882.00 53,036.63 83,845.37 - 83,845.37
630264XXX FT WORTH DR RELOCATE I-35E Total 2,926,903.45 2,934,731.05 (7,827.60) 6,411.10 (14,238.70)
630282XXX NORTH/SOUTH WTR MAIN, PH2 Total 13,059,973.00 2,233,609.20 10,826,363.80 10,566,104.05 260,259.75
630285XXX ELM ST Total 1,825,835.00 1,253,522.30 572,312.70 63,730.64 508,582.06
630287XXX FY 2012 LOCUST PH 1 Total 2,317,168.00 265,115.43 2,052,052.57 1,082,013.80 970,038.77
630314XXX CLEAR CREEK SLOPE MAINTENANCE Total 503,102.00 - 503,102.00 - 503,102.00
630324XXX ROBSON OVERSIZE Total 89,995.32 - 89,995.32 89,995.32 -
630341XXX BUDGET SOFTWARE Total 69,600.00 64,265.04 5,334.96 - 5,334.96
630344XXX LLWTP UPGRADE PHASE II Total 17,640,000.00 1,132,582.13 16,507,417.87 16,446,848.35 60,569.52
630347XXX BONNIE BRAE-I-35 TO SCRIPTURE Total 90,000.00 - 90,000.00 - 90,000.00
630348XXX BONNIE BRAE-SCRIPTURE TO 380 Total 60,000.00 2,743.97 57,256.03 - 57,256.03
630349XXX MORSE ST WATER RELOCATION Total 170,000.00 33,228.65 136,771.35 6,121.35 130,650.00
630350XXX RUDDELL@MINGO UTILITY RELOCATE Total 90,000.00 - 90,000.00 - 90,000.00
630351XXX MCKINNEY TRANSMISSION LINE Total 2,340,000.00 198,414.94 2,141,585.06 - 2,141,585.06
630353XXX SCRIPTURE TO I-35 TRANS LINE Total 785,000.00 159,780.94 625,219.06 44,203.76 581,015.30
630356XXX HWY 380-I-35 TRANSMISSION LINE Total 1,790,000.00 273,976.48 1,516,023.52 16,000.00 1,500,023.52
630357XXX FY17 FSRP HICKORY Total 1,266,026.71 1,266,064.72 (38.01) - (38.01)
630364XXX UPDATE WATER DIST MASTER PLAN Total 215,000.00 214,937.50 62.50 23,362.50 (23,300.00)
630373XXX FY '17 FSRP JOHNSON II Total 224,000.00 82,472.26 141,527.74 4,908.00 136,619.74
630374XXX FY '17 FSRP MIMOSA Total 76,270.89 75,685.89 585.00 - 585.00
630378XXX FY 18 FSRP JOHNSON-N OF DALLAS Total 10,000.00 1,185.03 8,814.97 1,845.00 6,969.97
630381XXX SW AREA CHLORAMINATION BOOSTER Total 227,529.09 201,658.43 25,870.66 - 25,870.66
630383XXX FY18 FSRP WAYNE Total 187,000.00 73,362.24 113,637.76 122.32 113,515.44
630385XXX ALLRED-JOHN PAINE RD TRAN LINE Total 6,584,210.92 688,880.15 5,895,330.77 5,333,455.54 561,875.23
630387XXX LLWTP SOLIDS HANDLING Total 8,741,000.00 1,124,553.43 7,616,446.57 7,872,597.89 (256,151.32)
630390XXX LAKE LEWISVILLE DAM SAFETY MOD Total 150,000.00 - 150,000.00 - 150,000.00
630391XXX BONNIE BRAE 380 TO WINDSOR Total 60,000.00 43,372.08 16,627.92 - 16,627.92
630396XXX FY18 FSRP BOWLING GREEN Total 216,000.00 145,167.80 70,832.20 - 70,832.20
630400XXX CHLORINE SCRUBBER TANK REPAIR Total 154,276.09 169,276.09 (15,000.00) - (15,000.00)
630402XXX FY18 FSRP KERLEY Total 360,900.00 264,821.36 96,078.64 - 96,078.64
630403XXX FY18 FSRP HOLLY HILL Total 9,700.00 6,855.04 2,844.96 2,500.00 344.96
630404XXX FY19 FSRP HERCULES Total 748,000.00 560,597.84 187,402.16 23,788.30 163,613.86
630405XXX FY19 FSRP ATLAS Total 184,930.70 184,945.92 (15.22) - (15.22)
City of Denton -Job Cost Summary
Water
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
City of Denton -Job Cost Summary
Water
630407XXX FY19 FSRP ROYAL MISTYWOOD Total 478,000.00 166,952.82 311,047.18 3,752.75 307,294.43
630409XXX RRWTP REG/PERFORMANCE UPGRADE Total 1,323,941.41 224,411.00 1,099,530.41 - 1,099,530.41
630412XXX FY 2019 WATER TAPS INSTALLED Total 358,328.73 360,628.24 (2,299.51) 43,780.61 (46,080.12)
630413XXX FY 2019 FIRE HYDRANT INSTALLS Total 55,149.70 23,467.14 31,682.56 33,484.71 (1,802.15)
630417XXX HERCULES WL OVERSIZE Total 50,000.00 - 50,000.00 - 50,000.00
630418XXX CHE LOBBY GLASS REPLACEMENT Total 50,000.00 29,667.81 20,332.19 - 20,332.19
630419XXX WATER DISTRIBUTION ASSET MGMT Total 250,000.00 170,342.12 79,657.88 44,857.88 34,800.00
630420XXX FY20 FSRP WESTGATE HEIGHTS Total 50,000.00 358.33 49,641.67 - 49,641.67
630421XXX FY19 FSRP EAGLE Total 137,800.00 128,516.37 9,283.63 - 9,283.63
630422XXX FY19 FSRP NORTHWOOD PLACE WATR Total 157,000.00 91,217.38 65,782.62 204.00 65,578.62
630423XXX FY19 FSRP PRECISION WATER PROJ Total 31,920.00 6,034.96 25,885.04 - 25,885.04
630424XXX FY20 FSRP WOODLAND/CHERYWD WTR Total 22,140.00 14,361.23 7,778.77 - 7,778.77
630425XXX FY20 FSRP ORR WATER Total 152,300.00 90,003.21 62,296.79 574.00 61,722.79
630428XXX FSRP QUAIL RIDGE WATER Total 233,040.00 110,438.93 122,601.07 8,892.00 113,709.07
630429XXX RISK ASMT&EMERG RESPONSE PLAN Total 106,750.00 16,042.60 90,707.40 90,707.40 -
630430XXX WATER 2019 RATE STUDY Total 54,400.00 - 54,400.00 54,235.00 165.00
630431XXX FY20 FSRP Ave B Water Total 227,347.00 65,509.02 161,837.98 5,791.75 156,046.23
630432XXX FY20 FSRP WEST MULBERRY WATER Total 15,000.00 15,929.40 (929.40) - (929.40)
630433XXX DESIGN - RRWTP 500HP VFD Total 25,000.00 - 25,000.00 23,880.00 1,120.00
630434XXX 300' REPLACEMENT MAIN-SCRIPTUR Total 65,000.00 41,405.90 23,594.10 - 23,594.10
630435XXX FY 2020 WATER METERS Total 1,092,738.87 235,429.65 857,309.22 - 857,309.22
630436XXX FY 2020 WATER TAPS INSTALLED Total 273,306.21 10,188.94 263,117.27 20,000.00 243,117.27
630437XXX FY 2020 FIRE HYDRANT INSTALLS Total 51,806.20 - 51,806.20 20,000.00 31,806.20
630438XXX REHAB RRWTP HIGH SRV PUMP STAN Total 500,000.00 - 500,000.00 275,035.61 224,964.39
630439XXX RINEY RD BPS&NW TRANS. LINES Total 2,166,000.00 - 2,166,000.00 1,398,600.00 767,400.00
630440XXX TX DOT I35 RELOCATION Total 650,000.00 - 650,000.00 592,800.00 57,200.00
630441XXX FY 20 STREET BUNDLING-DESIGN Total 255,800.00 - 255,800.00 - 255,800.00
630442XXX FY 19 STREET BUNDLING-WINSOR Total 1,426,535.00 - 1,426,535.00 - 1,426,535.00
630443XXX BELL STREET II Total 140,000.00 - 140,000.00 - 140,000.00
630996XXX UNALLOCATED BOND FUNDS Total 304,987.48 - 304,987.48 - 304,987.48
635091XXX WD1728 14 YD DUMP TRUCK Total 150,000.00 140,312.18 9,687.82 - 9,687.82
635101XXX WD1823 14 YD DUMP TRUCK Total 152,000.00 150,895.00 1,105.00 - 1,105.00
635106XXX HORIZONTAL DIRECTIONAL DRILL Total 175,000.00 137,882.12 37,117.88 - 37,117.88
635107XXX WP1924 1/2 TON REG CAB Total 25,000.00 22,965.86 2,034.14 - 2,034.14
635108XXX WP1925 3/4 TON w/UTILITY BED Total 47,000.00 - 47,000.00 36,903.60 10,096.40
635109XXX WP1989 TRAILER (DUMP) Total 7,500.00 - 7,500.00 - 7,500.00
635110XXX WD1962 DUMP TRUCK 14 YD GREEN Total 152,000.00 152,712.93 (712.93) - (712.93)
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
City of Denton -Job Cost Summary
Water
635111XXX WD1963 2 T w/VERMEER BODY Total 140,000.00 - 140,000.00 133,637.06 6,362.94
635115XXX WM1926 1/2 TON DOUBLE CAB Total 27,000.00 - 27,000.00 22,061.61 4,938.39
635116XXX WM1943 2 TON REG CAB Total 70,000.00 3,379.73 66,620.27 55,783.28 10,836.99
635117XXX WD19134-CX80C CASE EXCAVATOR Total 113,000.00 - 113,000.00 113,000.00 -
635118XXX WD19137CX145 MSR CASE EXCAVATR Total 132,800.00 - 132,800.00 132,800.00 -
635119XXX WM2068 - 1 TON MAINT. TRUCK Total 45,000.00 - 45,000.00 - 45,000.00
635120XXX WD2051 -MAINT. TRUCK Total 140,000.00 - 140,000.00 80,939.83 59,060.17
635996XXX UNALLOCATED FUNDS Total 2,031,831.43 - 2,031,831.43 - 2,031,831.43
Grand Total 85,063,344.29 22,123,803.65 62,939,540.64 44,970,592.99 17,968,947.65
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
640052XXX TEASLEY FM 2181 TXDOT Total 3,312,358.25 2,369,891.89 942,466.36 96,274.69 846,191.67
640111XXX ASSET MANAGEMENT PROGRAM Total 489,235.89 226,171.26 263,064.63 - 263,064.63
640137XXX WW LAB RENOVATIONS Total 400,049.00 64,060.15 335,988.85 - 335,988.85
640160XXX ELM ST Total 3,648,125.00 287,886.96 3,360,238.04 1,333,449.80 2,026,788.24
640162XXX LOCUST ST Total 2,358,286.50 1,289,816.00 1,068,470.50 746,027.73 322,442.77
640163XXX HICKORY CR. DETENTION FACILITY Total 15,629,893.72 659,673.97 14,970,219.75 14,458,000.00 512,219.75
640175XXX HOBSON GENSET & UPGRADE Total 323,341.55 78,604.00 244,737.55 - 244,737.55
640193XXX PRIVATE LATERALS REPLACEMENT Total 149,695.00 108,072.91 41,622.09 9,801.25 31,820.84
640213XXX FT WORTH DR RELOCATE I-35E Total 2,844,093.34 2,830,079.41 14,013.93 35,016.24 (21,002.31)
640219XXX FY 12 DRY FORK HC TRIBUTARY I Total 1,442,985.59 282,785.63 1,160,199.96 74,315.01 1,085,884.95
640248XXX WW LAB LIMS PURCHASE Total 168,698.00 110,549.20 58,148.80 39,200.00 18,948.80
640265XXX GENSET FOR COOPER CREEK LS Total 90,000.00 - 90,000.00 - 90,000.00
640271XXX DENTON WEST LS UPGRADE Total 716,380.04 719,565.75 (3,185.71) 22,242.11 (25,427.82)
640286XXX WEST WET WEATHER STORAGE FAC Total 3,166,000.00 559,735.76 2,606,264.24 305,256.37 2,301,007.87
640289XXX REUSE MCC REPLACEMENT Total 25,000.00 - 25,000.00 - 25,000.00
640291XXX RAPID AMMONIA ANALYZER Total 20,000.00 17,273.79 2,726.21 - 2,726.21
640296XXX BONNIE BRAE-I-35 TO SCRIPTURE Total 40,000.00 744.15 39,255.85 - 39,255.85
640297XXX BONNIE BRAE-SCRIPTURE TO 380 Total 25,000.00 - 25,000.00 - 25,000.00
640298XXX RUDDELL@MINGO UTILITY RELOCATE Total 275,000.00 - 275,000.00 - 275,000.00
640300XXX HICKORY CREEK INTERCEPTOR I Total 1,279,846.88 180,049.23 1,099,797.65 - 1,099,797.65
640301XXX HICKORY CREEK INTERCEPTOR II Total 7,851,359.26 527,745.37 7,323,613.89 139,587.18 7,184,026.71
640306XXX FY '16 WEST HICKORY FSRP Total 485,630.65 482,018.78 3,611.87 3,611.87 -
640311XXX FY '17 HILL ALLEY FSRP Total 12,447.00 6,387.13 6,059.87 - 6,059.87
640312XXX FY '17 HOLLYHILL FSRP Total 27,984.50 27,367.48 617.02 - 617.02
640313XXX FY '17 FOXCROFT FSRP Total 76,340.00 37,446.36 38,893.64 - 38,893.64
640316XXX FY '17 KERLEY FSRP Total 454,337.35 450,736.54 3,600.81 31,323.00 (27,722.19)
640319XXX FY '17 EMERSON FSRP Total 65,600.00 57,268.00 8,332.00 - 8,332.00
640320XXX FY '17 DALLAS FSRP Total 15,000.00 622.56 14,377.44 1,845.00 12,532.44
640323XXX EASEMENT MAINTENANCE Total 75,000.00 30,063.96 44,936.04 10,546.39 34,389.65
640325XXX MANHOLE REPAIR/REPLACEMENT Total 313,878.51 250,730.69 63,147.82 15,888.81 47,259.01
640326XXX FY '16 NORTH BELL ST Total 2,851.19 2,597.44 253.75 - 253.75
640328XXX FY '16 FULTON II Total 37,000.00 19,846.71 17,153.29 2,160.00 14,993.29
640330XXX FY '16 FULTON Total 156,000.00 128,103.79 27,896.21 11,333.44 16,562.77
640331XXX FLUSHING TRUCK BAYS Total 200,000.00 25,724.00 174,276.00 4,491.00 169,785.00
640332XXX WAYNE RYAN LS ABANDONMENT Total 33,566.00 - 33,566.00 33,566.00 -
640336XXX HICKORY CREEK LS UPGRADE Total 3,426,700.00 313,736.37 3,112,963.63 3,130,322.60 (17,358.97)
640337XXX RAS PUMP STATION 2 MCC UPGRADE Total 100,000.00 - 100,000.00 - 100,000.00
640345XXX LAND PURCHASE Total 5,000.00 - 5,000.00 - 5,000.00
640346XXX BARROW GRAVITY MAIN REPLACEMEN Total 217,210.00 51,128.83 166,081.17 15,000.00 151,081.17
City of Denton -Job Cost Summary
Wastewater
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
City of Denton -Job Cost Summary
Wastewater
640348XXX FY '17 HOLIDAY PARK II FSRP Total 864,328.07 622,269.79 242,058.28 3,352.86 238,705.42
640355XXX FY '17 FSRP ULAND Total 21,223.00 1,879.30 19,343.70 - 19,343.70
640359XXX SAMPLING EQUIPMENT Total 60,190.00 24,558.00 35,632.00 - 35,632.00
640360XXX SCADA MASTER PLAN Total 288,798.00 43,326.38 245,471.62 195,191.22 50,280.40
640361XXX BONNIE BRAE 380 TO WINDSOR Total 15,000.00 14,447.72 552.28 - 552.28
640365XXX PAINTING BUILDINGS Total 250,000.00 43.90 249,956.10 240,216.75 9,739.35
640367XXX PCWRP LEVEE Total 55,000.00 49,324.00 5,676.00 5,676.00 -
640370XXX FY 2018 MANAGEMENT STUDY Total 158,000.00 147,231.29 10,768.71 - 10,768.71
640373XXX FY '19 FSRP WELLINGTON Total 90,000.00 21,697.27 68,302.73 - 68,302.73
640374XXX FY '19 FSRP ATLAS Total 176,000.00 152,067.65 23,932.35 1,108.00 22,824.35
640375XXX FY '19 FSRP HETTIE Total 7,000.00 3,424.76 3,575.24 - 3,575.24
640376XXX FY '19 FSRP STELLA Total 13,000.00 10,706.18 2,293.82 - 2,293.82
640377XXX FY '18 LINING PROJECTS Total 343,553.00 338,736.75 4,816.25 4,816.25 -
640378XXX CREEKSIDE CAPACITY PROJECT Total 200,000.00 27,193.79 172,806.21 - 172,806.21
640382XXX HICKORY CREEK INTERCEPTOR III Total 500,827.91 179,688.66 321,139.25 15,000.00 306,139.25
640383XXX KINGS ROW REVERSION Total 235,000.00 87,145.17 147,854.83 1,481.60 146,373.23
640386XXX MCKINNEY STREET WIDENING Total 610,000.00 55,340.00 554,660.00 - 554,660.00
640387XXX FY 2019 WW SERVICE LINES Total 765,400.50 79,264.51 686,135.99 10,200.02 675,935.97
640388XXX FY 2019 WASTEWATER TAPS Total 56,810.26 47,953.86 8,856.40 14,755.96 (5,899.56)
640389XXX 21 IN GRAVITY MAIN REPAIR Total 600,000.00 375,700.22 224,299.78 - 224,299.78
640390XXX PECAN CREEK SCADA UPGRADE Total 100,000.00 86,792.26 13,207.74 - 13,207.74
640391XXX FY20 FSRP WESTGATE HEIGHTS IPT Total 230,000.00 198.20 229,801.80 - 229,801.80
640392XXX FY20 FSRP GRANADA TRAIL SEWER Total 20,000.00 286.62 19,713.38 - 19,713.38
640393XXX FY20 FSRP ROBSON RANCH SEWER Total 170,000.00 48,233.47 121,766.53 - 121,766.53
640394XXX 24" WASTEWATER FORCE MAIN REP Total 102,868.46 108,092.11 (5,223.65) - (5,223.65)
640395XXX FY19 FSRP MAGNOLIA PH II Total 217,110.00 212,849.19 4,260.81 - 4,260.81
640396XXX FY19 FSRP ORR ST SEWER REHAB Total 186,000.00 165,227.96 20,772.04 32,921.21 (12,149.17)
640397XXX FIELD TABLETS FOR INSPECTION Total 5,000.00 3,852.38 1,147.62 - 1,147.62
640398XXX FY19 FSRP SMITH ST SEWER REHAB Total 180,000.00 66,689.73 113,310.27 4,522.20 108,788.07
640399XXX FY19 FSRP NORTHWOOD PLACE SEWR Total 123,000.00 55,960.92 67,039.08 3,078.48 63,960.60
640400XXX FY19 FSRP SANDY CREEK REHAB Total 130,000.00 66,646.68 63,353.32 13,508.00 49,845.32
640401XXX WW SCADA NETWORK UPGRADE Total 157,000.00 155,708.72 1,291.28 - 1,291.28
640402XXX FY20FSRP WODLAND/CHERYWD SEWER Total 32,500.00 9,286.91 23,213.09 - 23,213.09
640403XXX HOBSON FORCE MAIN REPAIR Total 60,000.00 40,377.35 19,622.65 1,216.50 18,406.15
640405XXX FY19 FSRP PRECISION DR SEWR LN Total 82,000.00 7,569.09 74,430.91 - 74,430.91
640407XXX ROBSON WW DIVERSION PROJECT Total 1,000,000.00 - 1,000,000.00 - 1,000,000.00
640408XXX WASTEWATER 2019 RATE STUDY Total 54,400.00 - 54,400.00 54,235.00 165.00
640409XXX FY20 FSRP WEST MULBERRY WW Total 156,000.00 19,338.43 136,661.57 - 136,661.57
640410XXX 300' REPLACEMENT MAIN-SCRIPTUR Total 4,935.28 5,878.29 (943.01) - (943.01)
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
City of Denton -Job Cost Summary
Wastewater
640411XXX LAMSON BLOWER BLDG TRANSFORMER Total 50,500.00 - 50,500.00 - 50,500.00
640414XXX FY 2020 WW SERVICE LINES Total 281,837.00 3,558.24 278,278.76 4,293.37 273,985.39
640415XXX FY 2020 WASTEWATER TAPS Total 82,279.00 10,198.79 72,080.21 11,828.35 60,251.86
640416XXX OVERSIZE WATER LINES Total 200,000.00 - 200,000.00 - 200,000.00
640417XXX STARK FARMS LIFT STATION Total 25,620.80 739.94 24,880.86 6,293.10 18,587.76
640418XXX HILLCREST SEWER REHAB II Total 184,000.00 - 184,000.00 - 184,000.00
640419XXX CLEAR CREEK BASIN PUMP STATION Total 2,000,000.00 - 2,000,000.00 - 2,000,000.00
640420XXX TX DOT I35 RELOCATION Total 330,000.00 - 330,000.00 330,000.00 -
640421XXX HICKRY CREEK EMERG DECLARATION Total 200,000.00 134,514.78 65,485.22 52,325.92 13,159.30
640422XXX FY 2020 MANHOLE REPAIR/REPLACE Total 50,000.00 - 50,000.00 - 50,000.00
640424XXX COOPER CREEK ATO SWITCH Total 175,000.00 - 175,000.00 - 175,000.00
640425XXX FY 19 STREET BUNDLING-SCRIPT Total 402,160.00 - 402,160.00 - 402,160.00
640426XXX FY 19 STREET BUNDLING-WINDSOR Total 635,775.00 - 635,775.00 - 635,775.00
640427XXX FY 20 STREET BUNDLING-DESIGN Total 35,065.00 - 35,065.00 - 35,065.00
640996XXX UNALLOCATED BOND FUNDS Total 101,656.22 - 101,656.22 - 101,656.22
645058XXX WC15154 RS TECH INS TRAILER Total 133,416.00 132,666.00 750.00 - 750.00
645081XXX WC1828 PUMP Total 60,000.00 25,967.77 34,032.23 25,678.00 8,354.23
645084XXX BS1831 WHEEL LOADER Total 395,000.00 374,230.93 20,769.07 - 20,769.07
645088XXX WT1927 1/2 TON CREW CAB Total 30,000.00 - 30,000.00 26,178.58 3,821.42
645089XXX WC1964 DUMP TRUCK 14 YD GREEN Total 152,000.00 152,801.91 (801.91) - (801.91)
645090XXX WC1965 DUMP TRUCK 14 YD GREEN Total 152,000.00 153,350.30 (1,350.30) - (1,350.30)
645091XXX WC1966 2T CREW CAB DIESEL UTIL Total 90,000.00 - 90,000.00 75,169.00 14,831.00
645092XXX WC1990 TRAILER Total 2,000.00 - 2,000.00 - 2,000.00
645093XXX WW1923 1/2 TON DOUBLE CAB Total 25,700.00 - 25,700.00 23,341.61 2,358.39
645094XXX BS19101 WHEEL LOADER (SM) Total 195,000.00 174,176.31 20,823.69 - 20,823.69
645095XXX BS1928 1/2 TON REG CAB Total 27,000.00 23,070.58 3,929.42 - 3,929.42
645216XXX WT19100 GENERATOR Total 190,000.00 - 190,000.00 - 190,000.00
645218XXX WC19135-CX80C CASE EXCAVATOR Total 113,000.00 - 113,000.00 113,000.00 -
645219XXX WC19136-CX80C CASE EXCAVATOR Total 113,000.00 - 113,000.00 113,000.00 -
645220XXX WC19138-CX145MSR CASE EXCAVATR Total 132,800.00 - 132,800.00 132,800.00 -
645221XXX WC19139-CX145MSR CASE EXCAVATR Total 132,800.00 - 132,800.00 132,800.00 -
645222XXX DR2088 - LIGHT DUTY MAINT TRUK Total 30,000.00 - 30,000.00 - 30,000.00
645996XXX UNALLOCATED VEHICLE FUNDING Total 3,416,496.97 - 3,416,496.97 - 3,416,496.97
Grand Total 68,424,943.69 16,716,747.13 51,708,196.56 22,167,246.47 29,540,950.09
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
650039XXX CHANNEL REHABILITATION Total 376,491.05 107,099.93 269,391.12 - 269,391.12
650043XXX MINGO LANE & LOOP 288 IMPROVE Total 659,761.30 679,464.73 (19,703.43) 4,142.91 (23,846.34)
650047XXX PEC-4 LOCUST AND HIGHLAND Total 4,832,201.78 3,754,184.22 1,078,017.56 1,229,165.70 (151,148.14)
650048XXX HIGH WATER MONITORING Total 104,657.49 86,782.86 17,874.63 2,845.49 15,029.14
650095XXX HICKORY CR WPT IMPLEMENTATION Total 562,685.79 483,933.89 78,751.90 - 78,751.90
650097XXX MOSQUITO CONTROL ACTIVITIES Total 205,650.00 194,186.99 11,463.01 100.00 11,363.01
650098XXX STORM WATER MAPPING SYSTEM Total 31,937.22 28,278.25 3,658.97 - 3,658.97
650103XXX MAGNOLIA DRAINAGE PH II Total 4,318,687.85 3,012,678.66 1,306,009.19 1,040,476.82 265,532.37
650106XXX EAGLE DRIVE DRAINAGE PH II Total 2,410,000.00 2,377,143.78 32,856.22 34,751.73 (1,895.51)
650107XXX SOUTH BELL DRAINAGE SYSTEM Total 806,000.00 47,413.64 758,586.36 3,793.00 754,793.36
650108XXX HICKORY ST DRAINAGE&TRUNK LINE Total 911,350.00 139,248.26 772,101.74 4,501.00 767,600.74
650111XXX SMITH ST DRAINAGE Total 200,000.00 56,313.45 143,686.55 - 143,686.55
650113XXX DRAINAGE MASTER PLAN UPGRADE Total 211,539.03 83,738.29 127,800.74 - 127,800.74
650115XXX OAK STREET DRAINAGE SYSTEM Total 293,399.00 34,941.70 258,457.30 1,190.00 257,267.30
650116XXX MULTIPARAMETER DATASONDES Total 24,000.00 10,224.26 13,775.74 5,313.00 8,462.74
650118XXX PEC 4 - PHASE 3&4 Total 1,230,575.84 977,978.36 252,597.48 255,638.52 (3,041.04)
650119XXX HICKORY ST STORM DRAIN STUDY Total 100,000.00 128,150.00 (28,150.00) - (28,150.00)
650120XXX PEC 4 - PHASE 2 Total 2,485,000.00 95.81 2,484,904.19 2,355,063.54 129,840.65
650121XXX HERCULES STORM DRAIN Total 100,000.00 81,472.18 18,527.82 - 18,527.82
650122XXX PECAN CREEK DRAINAGE STUDY Total 500,000.00 191,666.00 308,334.00 249,290.88 59,043.12
650123XXX OAKTREE PROJECT Total 100,000.00 53,308.61 46,691.39 - 46,691.39
650124XXX COOPER CREEK EROSION REPAIR Total 200,000.00 4,786.42 195,213.58 - 195,213.58
650125XXX WESTGATE DRIVE Total 150,000.00 1,353.87 148,646.13 - 148,646.13
650126XXX HICKORY ST/FRY Total 54,312.41 26,162.41 28,150.00 - 28,150.00
650127XXX 2017 GOLF CT STORM DRAIN Total 40,000.00 12,351.60 27,648.40 - 27,648.40
650128XXX STORMWATER MASTER PLAN VALUE E Total 75,000.00 4,065.75 70,934.25 48,000.00 22,934.25
650981XXX CHOCTAW DRAINAGE PROJECT Total 100,000.00 20,232.75 79,767.25 - 79,767.25
650982XXX ELLISON PARK FLUME Total 20,000.00 13,369.95 6,630.05 - 6,630.05
650996XXX UNALLOCATED BOND FUNDS Total 112.91 - 112.91 - 112.91
655031XXX DR19102 BACKHOE 430 Total 115,000.00 - 115,000.00 105,768.70 9,231.30
655032XXX DR1944 2T CREW CAB 4X4 UTILITY Total 67,500.00 - 67,500.00 63,234.57 4,265.43
655033XXX DR1991 TRAILER Total 10,000.00 - 10,000.00 - 10,000.00
Grand Total 21,295,861.67 12,610,626.62 8,685,235.05 5,403,275.86 3,281,959.19
City of Denton -Job Cost Summary
Drainage
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
660233XXX SECURITY CAMERAS Total 22,500.00 22,295.68 204.32 - 204.32
660236XXX SW1968-AUTO SIDE LOAD Total 285,537.00 - 285,537.00 280,537.00 5,000.00
660240XXX RF-SW19128 - MINI REAR LOADER Total 98,679.38 105,108.38 (6,429.00) - (6,429.00)
660241XXX RF-FY19-TRAILER Total 5,699.65 5,379.65 320.00 - 320.00
660243XXX GAS WELL INSTALLATION PROJECT Total 250,000.00 - 250,000.00 237,654.00 12,346.00
660244XXX DESIGN OF CART CORALS Total 25,000.00 - 25,000.00 - 25,000.00
660245XXX FY 19 - RF - ROUTE MAPPING Total 49,500.00 - 49,500.00 42,900.00 6,600.00
660246XXX 5YR - WASTEHANDLER BULL DOZER Total 1,160,000.00 - 1,160,000.00 1,057,079.89 102,920.11
660248XXX SW2058-5YR-AUTO SIDE LOADER Total 320,000.00 - 320,000.00 311,079.00 8,921.00
660249XXX SW2059-5YR-AUTO SIDE LOADER Total 320,000.00 - 320,000.00 311,079.00 8,921.00
660250XXX SW2060-5YR-AUTO SIDE LOADER Total 320,000.00 - 320,000.00 311,079.00 8,921.00
660251XXX FY 19-20 ROLL OFF-SW2055 Total 201,241.00 - 201,241.00 186,845.00 14,396.00
660560XXX 20YR-LT-LF PERMIT EXPANSION Total 2,417,194.66 2,182,130.33 235,064.33 227,907.33 7,157.00
660640XXX FY '18 - LF ENGINEER SERVICES Total 150,000.00 81,079.57 68,920.43 34,603.09 34,317.34
660641XXX 10YR - SW 1842 ROLL OFF Total 189,318.00 189,016.41 301.59 - 301.59
660642XXX 10YR - 1001 MAYHILL REMODEL Total 700,000.00 305,343.53 394,656.47 34,779.94 359,876.53
660645XXX 10YR-SW1972-ROLL OFF Total 189,718.00 188,628.28 1,089.72 - 1,089.72
660647XXX 10YR-SW1969-AUTO SIDE LOADER Total 285,537.00 - 285,537.00 280,537.00 5,000.00
660648XXX 10YR-SW1970-AUTO SIDE LOADER Total 316,079.00 314,917.63 1,161.37 - 1,161.37
660649XXX 10YR-SW1971-AUTO SIDE LOADER Total 316,079.00 316,169.77 (90.77) - (90.77)
660650XXX 10YR-SW1973-FRONT LOAD Total 303,980.00 303,558.72 421.28 - 421.28
660651XXX 10YR-SW1974-FRONT LOAD Total 303,980.00 304,359.21 (379.21) - (379.21)
660652XXX 10YR-SW1975-FRONT LOAD Total 303,980.00 - 303,980.00 298,980.00 5,000.00
660653XXX 10YR-SW1976-FRONT LOAD Total 303,980.00 5,521.02 298,458.98 298,980.00 (521.02)
660656XXX 10YR - RF COMPACTOR Total 425,000.00 100,064.63 324,935.37 203,238.56 121,696.81
660891XXX 20YR - BUFFER ZONE IRRIGATION Total 975,000.00 161,030.16 813,969.84 70,305.70 743,664.14
660893XXX 20YR-LT-MOSELY ROAD LANDFILL Total 3,300,000.00 45,349.58 3,254,650.42 133.50 3,254,516.92
660894XXX FLEET SOLID WASTE FACILITY Total 100,000.00 27,802.92 72,197.08 - 72,197.08
660896XXX 20YR - 651 MAYHILL Total 4,068,640.00 - 4,068,640.00 - 4,068,640.00
660897XXX 20YR - ADMIN BLDG RENOVATIONS Total 1,000,000.00 - 1,000,000.00 - 1,000,000.00
660898XXX NORTHLAKES ENCLOSURES Total 410,439.00 - 410,439.00 - 410,439.00
660992XXX UNALLOCATED-OTHER REVENUE FUND Total 30,969.99 - 30,969.99 - 30,969.99
660994XXX 5YR - MISC UNALLOCATED FUNDS Total 26,456.11 - 26,456.11 - 26,456.11
660996XXX 10YR - MISC UNALLOCATED FUNDS Total 55,788.58 - 55,788.58 - 55,788.58
660997XXX 20YR - MISC UNALLOCATED FUNDS Total 609,802.18 - 609,802.18 - 609,802.18
665033XXX SW1930-STAKE BED TRUCK Total 55,000.00 - 55,000.00 27,626.35 27,373.65
665034XXX SW2056-FY19-20 FRONT LOADER Total 322,000.00 - 322,000.00 298,980.00 23,020.00
665035XXX SW2061-FY19-20 FRONT LOADER Total 310,000.00 - 310,000.00 298,980.00 11,020.00
City of Denton -Job Cost Summary
Solid Waste
665037XXX SW2062-FY19-20 FRONT LOADER Total 310,000.00 - 310,000.00 298,980.00 11,020.00
665038XXX SW2083-FY 19-20 ROLL OFF Total 200,000.00 - 200,000.00 186,845.00 13,155.00
665039XXX SW2053 - DELCO SYSTEM TRAILER Total 35,000.00 - 35,000.00 - 35,000.00
665040XXX SW2052 - FY 19-20 WATER PUMP Total 64,000.00 - 64,000.00 - 64,000.00
665041XXX SW2057-FY19-20 AUTO SIDE LOAD Total 320,000.00 - 320,000.00 311,079.00 8,921.00
665042XXX SW2085-FY19-20 MINI REAR LOAD Total 140,000.00 - 140,000.00 120,225.50 19,774.50
665043XXX SW2085-FY19-20 MINI REAR LOAD Total 140,000.00 - 140,000.00 120,225.50 19,774.50
665044XXX SW2054 - FY 19-20 KUBOTA Total 23,000.00 - 23,000.00 - 23,000.00
665996XXX UNALLOCATED FUNDS Total 2,032,250.87 - 2,032,250.87 - 2,032,250.87
Grand Total 23,791,349.42 4,657,755.47 19,133,593.95 5,850,659.36 13,282,934.59
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
805006XXX WAREHOUSE STORAGE FACILITY Total 234,873.92 5,867.50 229,006.42 - 229,006.42
Grand Total 234,873.92 5,867.50 229,006.42 - 229,006.42
City of Denton -Job Cost Summary
Warehouse
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
810378XXX PD1951 - PPV TAHOE Total 67,500.00 54,767.70 12,732.30 - 12,732.30
810379XXX PD1952 - PPV TAHOE Total 67,500.00 55,485.05 12,014.95 - 12,014.95
810380XXX PD1953 - PPV TAHOE Total 67,500.00 55,839.02 11,660.98 - 11,660.98
810381XXX PD1954 - PPV TAHOE Total 67,500.00 56,817.25 10,682.75 - 10,682.75
810382XXX FD1913 - 3/4 TON DBL CAB Total 42,500.00 - 42,500.00 28,393.60 14,106.40
810383XXX FD19108- PIERCE FIRE ENGINE Total 1,000,000.00 913,461.16 86,538.84 (59,272.19) 145,811.03
810384XXX FD1914-3/4 TON DBL CAB UTL BED Total 60,000.00 - 60,000.00 49,533.60 10,466.40
810386XXX FD1915 - 1/2 TON DBL CAB Total 39,000.00 - 39,000.00 22,656.61 16,343.39
810397XXX PM1919 - 3/4 TON DBL CAB Total 38,000.00 - 38,000.00 28,578.60 9,421.40
810399XXX PM1920- 3/4 TON CAB W UTIL BED Total 60,000.00 - 60,000.00 47,487.34 12,512.66
810405XXX ST1905 - 3/4 TON DBL CAB Total 45,000.00 - 45,000.00 13,378.60 31,621.40
810406XXX ST1960 - PETERBILT 330 Total 140,000.00 1,337.16 138,662.84 - 138,662.84
810411XXX TC1992 - TRAILER Total 15,000.00 - 15,000.00 - 15,000.00
810424XXX ST1980 - TRAILER Total 40,000.00 - 40,000.00 - 40,000.00
810425XXX ST1994 - MINI EXCAVATOR Total 120,000.00 - 120,000.00 52,489.11 67,510.89
810426XXX ST1995 - SKID STEER Total 62,250.00 - 62,250.00 - 62,250.00
810435XXX FD19115 LIGHT AND AIR TRUCK Total 750,000.00 682,732.31 67,267.69 (1,500.00) 68,767.69
810448XXX PD1949 PPV TAHOE Total 67,500.00 55,240.98 12,259.02 - 12,259.02
810449XXX PD1950 PPV TAHOE Total 67,500.00 54,683.15 12,816.85 - 12,816.85
810452XXX WH19143 WAREHOUSE FORKLIFT Total 32,000.00 167.96 31,832.04 28,251.00 3,581.04
810453XXX TC2050 TRAFFIC BUCKET TRUCK Total 170,000.00 - 170,000.00 151,867.00 18,133.00
810454XXX FD2021-EMERGENCY ONE ARFF Total 754,992.00 754,922.00 70.00 - 70.00
810455XXX ST2045-BACKHOE Total 115,000.00 - 115,000.00 105,768.70 9,231.30
810456XXX 5 PWI VEHICLES Total 140,000.00 - 140,000.00 - 140,000.00
810457XXX FD2093 FIRE ENGINE Total 950,000.00 - 950,000.00 739,631.00 210,369.00
810999XXX Unallocated Vehicles Total 2,508,064.43 3,885.00 2,504,179.43 - 2,504,179.43
Grand Total 7,486,806.43 2,689,338.74 4,797,467.69 1,207,262.97 3,590,204.72
City of Denton -Job Cost Summary
Motor Pool
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
820022XXX FLEET ANNEX FACILITY Total 63,170.00 28,771.88 34,398.12 - 34,398.12
820023XXX ADA COMPLIANT BATHROOM CONST Total 250,696.00 208,470.77 42,225.23 8,657.16 33,568.07
820025XXX FS19112 - CHEVY BOLT Total 36,000.00 - 36,000.00 32,992.00 3,008.00
820026XXX FLEET SERVICES EXPANSION Total 750,000.00 117,010.67 632,989.33 37,045.21 595,944.12
820999XXX UNALLOCATED BOND FUNDS Total 59,018.92 - 59,018.92 - 59,018.92
Grand Total 1,158,884.92 354,253.32 804,631.60 78,694.37 725,937.23
City of Denton -Job Cost Summary
Fleet
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
840035XXX INFRASTRUCTURE REPLACEMENT Total 571,089.62 151,391.70 419,697.92 115,588.00 304,109.92
840036XXX PD MDC MODEM REPLACEMENT Total 70,000.00 5,571.71 64,428.29 - 64,428.29
840056XXX DME INFRASTRUCTURE Total 2,026,746.27 1,980,137.79 46,608.48 14,100.48 32,508.00
840070XXX PS TECH APP AND HARDWARE Total 390,389.00 343,859.95 46,529.05 13,386.45 33,142.60
840077XXX ENTERPRISE DATA CENTER REFRESH Total 3,674,258.14 2,882,788.14 791,470.00 2,145.00 789,325.00
840078XXX INTERNET UPGRADE Total 19,000.00 - 19,000.00 - 19,000.00
840079XXX FIRE EMERGENCY REPORTING Total 50,000.00 26,540.00 23,460.00 - 23,460.00
840080XXX UNIVERSITY E-TICKET WRITERS Total 20,000.00 10,023.89 9,976.11 - 9,976.11
840081XXX BUDGET REPORTING SOFTWARE Total 25,000.00 22,500.00 2,500.00 2,500.00 -
840084XXX PC REFRESH Total 2,157,618.00 1,517,604.00 640,014.00 640,014.00 -
840086XXX HCM INTEGRATION Total 216,000.00 184,371.00 31,629.00 - 31,629.00
840087XXX P25 RADIO SYSTEM REPLACEMENT Total 5,574,083.00 4,287,713.08 1,286,369.92 1,256,069.92 30,300.00
840088XXX RADIO FIBER INFRASTRUCTURE Total 103,500.00 102,057.21 1,442.79 9,342.74 (7,899.95)
840089XXX FY18 - CAMERA SOFTWARE SERVER Total 50,000.00 - 50,000.00 48,853.17 1,146.83
840090XXX FY18 - ADOBE PROFESSIONAL UPG Total 20,000.00 - 20,000.00 - 20,000.00
840091XXX FY18 - GIS LASERFICHE CONNECT Total 20,000.00 - 20,000.00 - 20,000.00
840092XXX FY18-APP PROXY SERVERS UPGRADE Total 30,000.00 25,658.00 4,342.00 - 4,342.00
840094XXX DME PC REFRESH Total 230,000.00 61,220.87 168,779.13 - 168,779.13
840095XXX DME UTILITY NETWORK UPGRADE Total 400,000.00 - 400,000.00 184,998.00 215,002.00
840096XXX DME SCADA HARDWARE REFRESH Total 300,000.00 24,622.42 275,377.58 - 275,377.58
840099XXX DME METERING INITIATIVES Total 194,897.00 - 194,897.00 30,450.00 164,447.00
840100XXX P25 INTEGRATE TO HIGHER GROUND Total 87,000.00 - 87,000.00 86,715.00 285.00
840101XXX FY 18 - 19 NETWORK CABLING Total 37,473.00 36,772.70 700.30 700.30 -
840102XXX FY18 - 19 APPLICATION Total 5,823.00 - 5,823.00 - 5,823.00
840103XXX SUPPORT SERVICES EQUIPMENT Total 16,978.00 - 16,978.00 - 16,978.00
840104XXX FIRE MDCS Total 86,700.00 46,207.56 40,492.44 - 40,492.44
840105XXX FIRE TECH HARDWARE & APPS Total 17,742.00 - 17,742.00 - 17,742.00
840106XXX POLICE MDCS Total 255,000.00 - 255,000.00 16,264.80 238,735.20
840107XXX POLICE TECHNOLOGY HARDWARE 840107744 21,490.00 - 21,490.00 5,179.49 16,310.51
840107XXX POLICE TECHNOLOGY HARDWARE Total 21,490.00 - 21,490.00 5,179.49 16,310.51
840108XXX POLICE FIRST NET 840108744 161,500.00 - 161,500.00 90,560.81 70,939.19
840108XXX POLICE FIRST NET Total 161,500.00 - 161,500.00 90,560.81 70,939.19
840109XXX DME TS BACKUP MACHINES Total 20,000.00 - 20,000.00 - 20,000.00
840110XXX DME TS DATABASE ASSESSMENT Total 20,000.00 - 20,000.00 - 20,000.00
840111XXX CITY WIDE BACKUP MACHINES Total 24,000.00 - 24,000.00 - 24,000.00
840112XXX OUTSOURCE ERP SERVICES Total 131,000.00 - 131,000.00 - 131,000.00
840113XXX OUTSOURCE DESKTOP SERVICES Total 50,000.00 - 50,000.00 - 50,000.00
City of Denton -Job Cost Summary
Tech Services
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
City of Denton -Job Cost Summary
Tech Services
840114XXX OUTSOURCE APP ENHANCEMENTS Total 20,000.00 - 20,000.00 - 20,000.00
840115XXX GIS NEAR MAP AERIALS Total 24,000.00 - 24,000.00 24,000.00 -
840116XXX CITY WIDE DATA WAREHOUSE Total 25,000.00 - 25,000.00 - 25,000.00
840117XXX PRINTER STRATEGIES Total 187,000.00 - 187,000.00 - 187,000.00
840118XXX 311 ASSESSMENT Total 30,000.00 - 30,000.00 19,500.00 10,500.00
840119XXX IDENTIX LIVESCAN UPGRADE Total 37,000.00 - 37,000.00 - 37,000.00
840120XXX DME HARDWARE UPGRADES Total 150,000.00 - 150,000.00 - 150,000.00
840121XXX DME CAMERA INFRASTRUCTURE Total 250,000.00 - 250,000.00 - 250,000.00
840122XXX FY 19-20 CABLING Total 20,000.00 2,700.93 17,299.07 7,299.07 10,000.00
840123XXX FY20 PUBLIC SAFETY REDUNDANCY Total 130,000.00 - 130,000.00 - 130,000.00
840125XXX FY2020 ANTI VIRUS Total 60,000.00 26,639.95 33,360.05 - 33,360.05
840126XXX KEMP REPLACEMENT Total 15,000.00 - 15,000.00 - 15,000.00
840999XXX UNALLOCATED PROJECT FUNDS Total 23,250.07 - 23,250.07 - 23,250.07
Grand Total 18,048,537.10 11,738,380.90 6,310,156.20 2,567,667.23 3,742,488.97
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
870001XXX FY18-19 HARRIS CUSTOMER SERVE Total 22,694.00 - 22,694.00 - 22,694.00
870002XXX SUPPLY ROOM REMODEL Total 15,000.00 - 15,000.00 - 15,000.00
Grand Total 37,694.00 - 37,694.00 - 37,694.00
City of Denton -Job Cost Summary
Customer
Services
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
600755XXX POCKRUS-BRINKER/SPENCER INT TM Total 3,616,292.48 2,562,752.01 1,053,540.47 921,809.94 131,730.53
602921XXX PSA-SGS ENGINEERING, LLC FY11 Total 266,626.54 - 266,626.54 266,626.54 -
602931XXX RD WELLS SWGR BLDG 4 Total 1,886,397.26 1,839,914.69 46,482.57 40,614.55 5,868.02
602948XXX WOODROW TO LOCUST TM LINE Total 5,429,573.36 5,165,969.98 263,603.38 52,494.15 211,109.23
603187XXX PSA-BLACK & VEATCH CORP-FY 13 Total 466,718.76 - 466,718.76 466,718.76 -
603188XXX PSA-POWER TESTING Total 32,915.00 - 32,915.00 32,915.00 -
603200XXX EAGLE SUBSTATION Total 5,294,820.24 2,230,734.07 3,064,086.17 209,000.00 2,855,086.17
603233XXX LOCUST SUBSTATION RECONSTRUCTI Total 15,435,088.72 15,124,925.79 310,162.93 125,225.31 184,937.62
603234XXX HICKORY SUBSTATION RECONSTRUCT Total 6,423,030.24 3,998,739.63 2,424,290.61 419,540.40 2,004,750.21
603246XXX PSA - POWER ENGINEERS - FY13 Total 1,174,146.62 - 1,174,146.62 1,174,146.62 -
603286XXX Masch Branch Switch Station Total 8,599,354.19 6,907,668.60 1,691,685.59 962,337.08 729,348.51
603289XXX Underwood Substation Total 407,507.25 359,343.83 48,163.42 - 48,163.42
603290XXX Brinker Substation Total 21,494,835.31 17,115,038.88 4,379,796.43 3,386,676.81 993,119.62
603291XXX PSA - KELSEY Total 163,789.44 - 163,789.44 163,789.44 -
603314XXX C of D Lewisville Pumps Update Total 84,629.00 76,418.89 8,210.11 - 8,210.11
603332XXX PWR Solutions PSA FERC Filing Total 311,400.77 - 311,400.77 311,400.77 -
603363XXX PSA - Teague, Nall & Perkins Total 2,400,641.98 - 2,400,641.98 2,400,641.98 -
603364XXX PSA - D & S Engineering Total 267,599.78 - 267,599.78 267,599.78 -
603390XXX PSA- Freese & Nichols Total 158,717.84 - 158,717.84 158,717.84 -
603493XXX Shady Shores Tie Total 20,000.00 8,437.67 11,562.33 - 11,562.33
603496XXX Denton W INTCHG Relay Upgrade Total 3,340,606.55 1,734,278.03 1,606,328.52 261,244.88 1,345,083.64
603500XXX BRINKER TO SPENCER INT TM LINE Total 217,242.11 207,374.77 9,867.34 - 9,867.34
603511XXX ARCO to Cooper Creek TM Total 4,267,709.22 171,744.26 4,095,964.96 827,988.00 3,267,976.96
603581XXX MOBILE WORK FORCE MANAGEMENT Total 541,000.00 467,234.98 73,765.02 59,550.52 14,214.50
603582XXX LIFE CYCLE ASSETS Total 545,000.00 400,791.80 144,208.20 - 144,208.20
603631XXX CIP2017-13 Hobson DBL CIR Total 957,395.78 109,245.74 848,150.04 - 848,150.04
603718XXX SPENCER INTERCHANGE SUB RECON Total 4,637,986.16 4,303,219.42 334,766.74 18,973.53 315,793.21
603725XXX BONNIE BRAE SUBST 138 KV Total 110,000.00 101,418.05 8,581.95 - 8,581.95
603751XXX Fireside Village Total 194,323.61 137,632.75 56,690.86 - 56,690.86
603778XXX PSA- JB TEMPLETON CONSULTING Total 43,233.33 - 43,233.33 43,233.33 -
603803XXX Asset Management System Total 350,000.00 - 350,000.00 - 350,000.00
603804XXX Eng Sys & Computer Related Equ Total 251,000.00 - 251,000.00 - 251,000.00
603909XXX Rayzor Ranch S - Ph 2 East Total 66,540.24 53,465.24 13,075.00 13,075.00 -
City of Denton -Job Cost Summary
Electric
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
City of Denton -Job Cost Summary
Electric
603921XXX Courts of Bonnie Brae Ph 1 Total 190,000.00 8,408.31 181,591.69 - 181,591.69
603924XXX Admin Budget Software Total 190,360.00 157,709.30 32,650.70 32,650.70 -
603932XXX Sherman Crossing Res PH 2A Total 253,676.68 30,646.06 223,030.62 5,300.00 217,730.62
603933XXX Sherman Crossing Retail PhA Total 220,000.00 8,661.29 211,338.71 30,647.30 180,691.41
603935XXX Cooper Creek Sub Line PT's Total 80,928.62 76,094.30 4,834.32 - 4,834.32
603987XXX ELECTRIC APPLICATIONS UPGRADES Total 350,053.00 240,654.45 109,398.55 - 109,398.55
603990XXX NEW JIM CHRISTAL SUBSTATION Total 22,940,836.59 21,623,049.33 1,317,787.26 476,374.33 841,412.93
603991XXX HICKORY SUB TM UG/OH RECONFIG Total 100,000.00 80,547.32 19,452.68 - 19,452.68
603996XXX DENTON ENERGY CENTER Total 215,200,000.00 211,258,178.44 3,941,821.56 2,037,937.33 1,903,884.23
604025XXX UNT Mulberry St OH to UG Total 250,000.00 6,217.93 243,782.07 - 243,782.07
604030XXX Hickory Sub Fdr Exit Conduits Total 13,301.80 3,510.46 9,791.34 - 9,791.34
604052XXX Hartlee Substation Total 155,440.28 143,495.20 11,945.08 - 11,945.08
604056XXX Service King Service Total 20,000.00 - 20,000.00 - 20,000.00
604075XXX TCOS-Jim Christal TM Tie-In Total 1,076,182.35 1,040,360.72 35,821.63 - 35,821.63
604087XXX RD Wells to Hickory TM Tie-In Total 100,514.34 97,007.98 3,506.36 - 3,506.36
604093XXX The Park (LABB) Total 15,000.00 2,192.72 12,807.28 - 12,807.28
604095XXX Hickory Creek Detention Facili Total 20,000.00 - 20,000.00 - 20,000.00
604096XXX Pecan Creek West Peak Flow Total 25,000.00 300.00 24,700.00 - 24,700.00
604100XXX Windsor/Hanover/Emerson Reb Total 457,719.04 456,323.76 1,395.28 - 1,395.28
604102XXX Nottingham Dr Rebuild Total 300,000.00 285,608.59 14,391.41 - 14,391.41
604103XXX Woodrow to Brinker TML Total 243,781.04 127,347.99 116,433.05 22,936.50 93,496.55
604116XXX DISD BUS YARD Total 12,000.00 397.17 11,602.83 - 11,602.83
604142XXX Pioneer ETRM Total 1,126,000.00 - 1,126,000.00 - 1,126,000.00
604156XXX Masch Branch Tie-In Total 1,177,645.17 1,142,614.44 35,030.73 - 35,030.73
604163XXX Bonnie Brae Expansion Ph IV Total 550,000.00 36,115.28 513,884.72 5,900.00 507,984.72
604164XXX Bonnie Brae Expansion Ph V Total 165,429.63 15,518.67 149,910.96 5,705.00 144,205.96
604173XXX DN TRANSFORMER #2 FDR EXITS Total 370,000.00 26,600.79 343,399.21 - 343,399.21
604182XXX Locust Subst NE Fdr Exits Total 590,768.08 508,433.68 82,334.40 81,034.40 1,300.00
604183XXX Locust Subst SW Fdr Exits Total 483,317.97 477,947.97 5,370.00 5,370.00 -
604188XXX Eagle to Locust TM Line Total 1,765,937.71 1,377,701.85 388,235.86 2,292.19 385,943.67
604189XXX Hickory to Eagle TM Line Total 3,597,320.19 3,050,522.46 546,797.73 36,860.60 509,937.13
604190XXX Traffic Signals US377 S Total 10,000.00 215.29 9,784.71 - 9,784.71
604204XXX DENTON NORTH POWER XFRMR ADDTN Total 2,605,058.92 2,311,172.29 293,886.63 237,334.18 56,552.45
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
City of Denton -Job Cost Summary
Electric
604206XXX CORNER STORE Total 20,000.00 441.33 19,558.67 - 19,558.67
604219XXX Colorado Medical Office Bldg Total 20,000.00 808.41 19,191.59 - 19,191.59
604220XXX Sundown Ranch Commercial Total 20,000.00 2,535.94 17,464.06 - 17,464.06
604222XXX Eng GIS Tech Sys Replacements Total 808,050.00 508,552.54 299,497.46 634.50 298,862.96
604227XXX Compliance Software Services Total 120,000.00 71,250.00 48,750.00 - 48,750.00
604267XXX Duluth Trading Co Total 150,000.00 125,653.38 24,346.62 7,286.80 17,059.82
604285XXX COD Irrigation Svc at Marshall Total 13,342.06 4,624.73 8,717.33 - 8,717.33
604297XXX ED1808 ED0416 Excavator Total 60,000.00 - 60,000.00 52,489.11 7,510.89
604299XXX ED1810 ED0856 Backhoe Total 110,000.00 - 110,000.00 105,768.70 4,231.30
604318XXX Denton County Admin PH III Total 52,380.00 41,041.44 11,338.56 2,113.00 9,225.56
604339XXX ADMS Communications 2018 Total 18,000.00 3,407.72 14,592.28 - 14,592.28
604340XXX Creekside Addition Total 222,969.69 112,014.41 110,955.28 56,665.79 54,289.49
604341XXX Country Lakes North Ph 7 Total 323,520.94 153,921.58 169,599.36 44,384.90 125,214.46
604346XXX JC Denton West Erosion Control Total 47,226.22 27,992.15 19,234.07 - 19,234.07
604357XXX Denton North Drainage Total 312,767.44 242,344.86 70,422.58 - 70,422.58
604358XXX Fort Worth 411L Relay Total 50,000.00 41,550.63 8,449.37 - 8,449.37
604367XXX Keas & Pruett Apartments Total 11,750.30 8,129.85 3,620.45 - 3,620.45
604370XXX Service Center Renovation Total 1,317,337.00 82,336.88 1,235,000.12 - 1,235,000.12
604375XXX Country Lakes North Ph 5A Total 158,250.00 6,707.71 151,542.29 - 151,542.29
604376XXX Bell & McKinney St Light Reloc Total 79,902.00 22,286.92 57,615.08 16,307.35 41,307.73
604377XXX Denton N-Arco Dist Underbuild Total 558,890.93 537,949.76 20,941.17 - 20,941.17
604378XXX Forest Ridge Apts Cable Repl Total 73,221.40 49,341.40 23,880.00 19,720.00 4,160.00
604379XXX Spencer-Locust UB Switches Total 270,000.00 233,233.89 36,766.11 - 36,766.11
604380XXX Masch Branch & Hampton Svc Total 10,000.00 2,958.08 7,041.92 - 7,041.92
604382XXX PETERBILT PRIMARY SVC & PME Total 185,510.00 6,726.55 178,783.45 - 178,783.45
604383XXX BB-NL TM Final Span & Esmt Total 31,332.36 - 31,332.36 - 31,332.36
604386XXX Beall Way Addition Total 398,100.00 52,452.91 345,647.09 68,197.50 277,449.59
604389XXX Carmel Villas Total 234,850.00 46,300.11 188,549.89 63,829.50 124,720.39
604392XXX Denton Student Housing Total 20,000.00 210.96 19,789.04 - 19,789.04
604393XXX Old Kings Row Subst Retirement Total 500,000.00 11,681.84 488,318.16 - 488,318.16
604394XXX MDMS Integration to Synergy Total 45,000.00 33,000.00 12,000.00 - 12,000.00
604397XXX Switchgear 864 Replacement Total 100,000.00 1,263.91 98,736.09 - 98,736.09
604399XXX TMPA Windhaven Upgrade Total 199,412.44 60,889.52 138,522.92 53,472.13 85,050.79
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
City of Denton -Job Cost Summary
Electric
604403XXX Clean & Green Car Wash FM2499 Total 25,000.00 15,334.79 9,665.21 - 9,665.21
604405XXX Forrestridge Cable Repl Total 200,000.00 95,002.93 104,997.07 72,895.00 32,102.07
604411XXX 2019 UG Conductor Ordinary Rep Total 126,380.43 120,248.25 6,132.18 - 6,132.18
604412XXX 2019 Services Total 722,954.58 688,640.04 34,314.54 1,491.50 32,823.04
604427XXX Fire Station #3 Service Total 10,000.00 - 10,000.00 - 10,000.00
604432XXX Meter Seals Total 5,000.00 - 5,000.00 - 5,000.00
604433XXX DEC Fixtures Total 140,000.00 345.88 139,654.12 - 139,654.12
604434XXX Discount Tire N I35 Total 20,000.00 17,002.66 2,997.34 - 2,997.34
604436XXX RRTC Heritage Trl Lighting Ph2 Total 37,600.00 11,672.97 25,927.03 3,864.20 22,062.83
604437XXX Computer Equipment Replacement Total 52,095.00 45,076.00 7,019.00 - 7,019.00
604438XXX S & C Software Licenses Total 113,850.00 42,092.00 71,758.00 - 71,758.00
604440XXX Shady Oaks Office Total 15,000.00 2,778.99 12,221.01 - 12,221.01
604442XXX Hick's Hanger Total 20,000.00 11,598.14 8,401.86 - 8,401.86
604444XXX ED1961 ED0990 Altec 60' Bucket Total 300,000.00 - 300,000.00 245,176.00 54,824.00
604445XXX ED1941 ED0899 3/4 T Crew Cab Total 60,750.00 - 60,750.00 45,684.21 15,065.79
604446XXX ED1942 ED1032 3/4 T Crew Cab Total 60,000.00 - 60,000.00 45,684.21 14,315.79
604447XXX EM1922 ED1135 Chevy C1500 Total 40,585.00 - 40,585.00 34,244.91 6,340.09
604453XXX PRECISION DR FDR TIE PH 2 Total 10,000.00 - 10,000.00 - 10,000.00
604455XXX CHARTER SERVICES Total 30,000.00 29,111.19 888.81 - 888.81
604456XXX Residences at Razor Ranch Total 10,000.00 - 10,000.00 - 10,000.00
604457XXX Valvoline Express Care Total 20,000.00 7,162.11 12,837.89 - 12,837.89
604458XXX RINEY ROAD TOWNHOMES Total 15,389.00 2,556.06 12,832.94 - 12,832.94
604460XXX Country Club Road Estates Total 10,000.00 - 10,000.00 - 10,000.00
604463XXX Texas Oncology Total 47,500.00 29,757.71 17,742.29 - 17,742.29
604464XXX Hercules West Phase 2C Total 10,000.00 1,605.41 8,394.59 - 8,394.59
604465XXX Evans Residence Total 10,000.00 3,806.69 6,193.31 - 6,193.31
604466XXX Denton North Substation Fence Total 1,101,000.00 73,988.40 1,027,011.60 884,362.10 142,649.50
604469XXX Audra Heights Phase 2 Total 10,000.00 1,739.97 8,260.03 - 8,260.03
604470XXX LED St Llighting Retrofit Total 2,865,347.68 - 2,865,347.68 - 2,865,347.68
604471XXX Wave Wash Total 20,000.00 3,317.33 16,682.67 - 16,682.67
604472XXX University Self Storage Total 110,000.00 11,442.70 98,557.30 2,100.00 96,457.30
604473XXX McDonald's Fort Worth Dr Total 35,000.00 27,303.04 7,696.96 - 7,696.96
604478XXX Park 7 Denton - East Total 53,203.85 38,012.45 15,191.40 - 15,191.40
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
City of Denton -Job Cost Summary
Electric
604479XXX Park 7 Denton - West Total 10,000.00 - 10,000.00 - 10,000.00
604480XXX Peterbilt Truck Lot Total 40,000.00 22,588.53 17,411.47 10,460.00 6,951.47
604482XXX Sherman Crossing Res Ph 2B Total 10,000.00 2,884.70 7,115.30 - 7,115.30
604483XXX BBI Denton Total 175,000.00 83,616.41 91,383.59 21,296.50 70,087.09
604484XXX DHS Campus Phase 1 Total 375,000.00 10,109.18 364,890.82 - 364,890.82
604485XXX DN Fdr Exit Relocation Total 600,000.00 569,872.00 30,128.00 3,258.04 26,869.96
604487XXX I35E NBSR Reloc Ph1 Total 50,000.00 8,369.04 41,630.96 6,150.00 35,480.96
604490XXX US 377 STREETLIGHTS PH 1 Total 10,000.00 - 10,000.00 - 10,000.00
604491XXX Denton Cope Addition Total 10,000.00 - 10,000.00 - 10,000.00
604492XXX All Storage Denton Total 135,000.00 71,707.68 63,292.32 - 63,292.32
604493XXX Haven at Daugherty Total 10,000.00 - 10,000.00 - 10,000.00
604494XXX Cooper Creek Business Park Total 10,000.00 - 10,000.00 - 10,000.00
604495XXX RRTC Lighting Ph 2 East Total 455,000.00 114,006.15 340,993.85 60,980.20 280,013.65
604497XXX Morse St Relocation Total 10,000.00 720.53 9,279.47 - 9,279.47
604499XXX Hickory Creek Rd Reloc Total 10,000.00 3,077.11 6,922.89 - 6,922.89
604500XXX Strickland School Pole Reloc Total 18,600.00 6,633.09 11,966.91 - 11,966.91
604502XXX CVR Trial Total 35,000.00 24,576.46 10,423.54 - 10,423.54
604503XXX Enclave At Denton Total 100,000.00 20,253.28 79,746.72 - 79,746.72
604504XXX Outback RV Shop Total 10,000.00 7,049.24 2,950.76 - 2,950.76
604505XXX Woodrow Wilson Elem Reloc Total 125,000.00 56,309.23 68,690.77 - 68,690.77
604506XXX Woodrow Wilson Elem Service Total 10,000.00 5,822.19 4,177.81 - 4,177.81
604509XXX Hickory Creek Lift Sta Total 25,000.00 18,720.24 6,279.76 - 6,279.76
604511XXX Rayzor Ranch S - Ph 2A East Total 350,000.00 209,001.34 140,998.66 43,123.80 97,874.86
604512XXX Power Quality Improvement Total 173,623.50 154,522.50 19,101.00 17,010.00 2,091.00
604513XXX Arco SS CT Metering Addition Total 100,000.00 6,502.70 93,497.30 - 93,497.30
604514XXX Parkview by Toll Brothers Total 125,000.00 13,450.08 111,549.92 1,400.00 110,149.92
604515XXX Carriage Square North Total 75,000.00 1,443.42 73,556.58 - 73,556.58
604517XXX Bellaire Assisted Living Total 13,825.00 3,647.87 10,177.13 - 10,177.13
604518XXX Johnson Ln Business Park Ph2 Total 20,000.00 14,259.31 5,740.69 - 5,740.69
604519XXX FW221 Circuit Upgrade Total 10,000.00 - 10,000.00 - 10,000.00
604520XXX TM Line Mod at Locust/Hercules Total 30,000.00 11,847.12 18,152.88 10,653.48 7,499.40
604521XXX Pax Ag Building Total 10,000.00 1,499.93 8,500.07 - 8,500.07
604522XXX Forest Crossing Total 10,000.00 1,675.06 8,324.94 - 8,324.94
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
City of Denton -Job Cost Summary
Electric
604523XXX Advantage Self Storage Total 10,000.00 291.84 9,708.16 - 9,708.16
604526XXX COD Emergency Sirens Total 10,000.00 875.49 9,124.51 - 9,124.51
604527XXX PEC 4 Ph 3-4 Reloc Total 10,000.00 2,042.22 7,957.78 - 7,957.78
604529XXX Greenville Storm Total 100,000.00 84,435.72 15,564.28 - 15,564.28
604531XXX Ponder Duplexes Total 27,615.00 5,944.75 21,670.25 - 21,670.25
604532XXX Fairhaven Assisted Living Total 10,000.00 - 10,000.00 - 10,000.00
604533XXX DHS Campus Phase II Total 10,000.00 - 10,000.00 - 10,000.00
604535XXX S Bonnie Brae Street Lighting Total 130,000.00 - 130,000.00 - 130,000.00
604536XXX Hercules Ln Street Lighting Total 20,000.00 636.77 19,363.23 5,629.00 13,734.23
604537XXX Wave Wash Temp Service Total 6,000.00 - 6,000.00 - 6,000.00
604538XXX All Storage Temp Service Total 5,000.00 1,459.08 3,540.92 - 3,540.92
604539XXX Cooper Creek Landscape Reconst Total 60,000.00 15,502.41 44,497.59 - 44,497.59
604541XXX Rayzor Ranch Senior Living Total 10,000.00 1,139.55 8,860.45 - 8,860.45
604542XXX Academy Foot & Ankle Total 10,000.00 - 10,000.00 - 10,000.00
604543XXX Crawford Rd to I35W Extension Total 240,166.53 12,370.51 227,796.02 19,492.50 208,303.52
604544XXX I35E SBSR Reloc Ph1 Total 10,000.00 - 10,000.00 - 10,000.00
604545XXX Bonnie Brae/I35E-Hickory Reloc Total 10,000.00 - 10,000.00 - 10,000.00
604546XXX Bonnie Brae/Hickory-Oak Reloc Total 10,000.00 - 10,000.00 - 10,000.00
604547XXX Exeter Westpark Total 10,000.00 2,179.96 7,820.04 - 7,820.04
604548XXX WWTP Xfmr #5644 Replacement Total 50,000.00 5,288.86 44,711.14 - 44,711.14
604549XXX **BARRICADE & TRAFFIC CONTROL Total 12,643.65 - 12,643.65 12,643.65 -
604552XXX DN Fdr Tie Reconfiguration Total 10,000.00 1,957.44 8,042.56 - 8,042.56
604553XXX VINTAGE TOWNHOMES NORTH Total 10,000.00 - 10,000.00 - 10,000.00
604554XXX BOB-O-LINK DR CABLE REPL Total 30,000.00 10,999.27 19,000.73 - 19,000.73
604558XXX Audra Oaks Ph 2A Total 10,000.00 - 10,000.00 - 10,000.00
604559XXX Guyer HS Field House Total 10,000.00 - 10,000.00 - 10,000.00
604560XXX Ryan HS Auditorium Total 10,000.00 761.59 9,238.41 - 9,238.41
604561XXX DEC Warehouse Total 120,000.00 - 120,000.00 - 120,000.00
604564XXX Fire Station #8 Total 10,000.00 801.38 9,198.62 - 9,198.62
604566XXX At the Table Total 10,000.00 - 10,000.00 - 10,000.00
604567XXX Hillcrest Retail Total 10,000.00 - 10,000.00 - 10,000.00
604568XXX IOOF Storage Service Total 10,000.00 - 10,000.00 - 10,000.00
604569XXX Acme Brick Cap Bank Total 20,000.00 - 20,000.00 - 20,000.00
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
City of Denton -Job Cost Summary
Electric
604570XXX Annual TS OSI SCADA Maintenanc Total 41,000.00 - 41,000.00 - 41,000.00
604630XXX 2020 OH Conductors Total 100,000.00 7,008.45 92,991.55 - 92,991.55
604631XXX 2020 UG Conduit Ordinary Repl Total 99,304.00 32,404.10 66,899.90 - 66,899.90
604632XXX 2020 UG Conductor Ordinary Rep Total 144,531.00 6,618.04 137,912.96 - 137,912.96
604633XXX 2020 Services Total 962,837.00 178,733.87 784,103.13 203,012.12 581,091.01
604634XXX 2020 Poles Total 171,667.48 55,719.49 115,947.99 8,000.00 107,947.99
604635XXX 2020 Serv Truck Sec Light Total 9,156.00 - 9,156.00 - 9,156.00
604636XXX 2020 Street Lights & Signals Total 191,102.00 34,493.10 156,608.90 - 156,608.90
604637XXX 2020 City Street Lights Progra Total 1,250,000.00 - 1,250,000.00 - 1,250,000.00
604638XXX 2020 Three Phase Meter Total 93,469.00 - 93,469.00 6,400.00 87,069.00
604639XXX 2020 Single Phase Meters Total 587,199.00 396,200.00 190,999.00 3,740.00 187,259.00
604640XXX 2020 Instrument Rated Equip Total 144,604.34 - 144,604.34 23,675.00 120,929.34
604641XXX 2020 AMI & WAN Equipment Total 164,938.46 - 164,938.46 - 164,938.46
604642XXX 2020 Prepayment Meter System Total 42,052.00 - 42,052.00 - 42,052.00
604643XXX 2020 Substation Security Total 201,977.97 7,313.79 194,664.18 56,432.53 138,231.65
604644XXX 2020 FIBER NETWORK MAINTENANCE Total 363,437.88 38,667.89 324,769.99 56,740.67 268,029.32
604645XXX 2020 Transformers Total 3,039,539.84 832,704.02 2,206,835.82 622,307.00 1,584,528.82
604646XXX 2020 St Light Conv to LED Prog Total 375,000.00 - 375,000.00 - 375,000.00
604647XXX 2020 Storm Outage Total 20,000.00 9,144.44 10,855.56 - 10,855.56
604648XXX 2020 Outage Total 100,000.00 69,617.73 30,382.27 - 30,382.27
604649XXX TOWNSEND GREEN PHASE 1 Total 10,000.00 - 10,000.00 - 10,000.00
604650XXX WESTGATE DR FDR UPGRADE Total 10,000.00 - 10,000.00 - 10,000.00
604651XXX VERIZON WIRELESS NODE SERVICES Total 25,000.00 6,730.18 18,269.82 - 18,269.82
604652XXX Garland Storm Recovery Total 50,000.00 21,537.02 28,462.98 - 28,462.98
604653XXX Denton County Emergency Ops Total 10,000.00 - 10,000.00 - 10,000.00
604654XXX 2628 Boliver St Security Lt Total 5,000.00 - 5,000.00 - 5,000.00
604655XXX Swisher Rd Feeder Tie Total 146,974.56 46,974.56 100,000.00 - 100,000.00
604656XXX Jim Christal Rd Reloc Total 50,000.00 - 50,000.00 - 50,000.00
604657XXX I35E & Brinker Traffic Signal Total 10,000.00 39.94 9,960.06 - 9,960.06
604658XXX American National Bank & Trust Total 10,000.00 - 10,000.00 - 10,000.00
604659XXX 427 & 431 Jannie Services Total 10,000.00 1,167.84 8,832.16 - 8,832.16
604660XXX FM2499 Irrigation Service Total 10,000.00 - 10,000.00 - 10,000.00
604661XXX Denton Crossing Building 3 Total 10,000.00 - 10,000.00 - 10,000.00
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered
City of Denton -Job Cost Summary
Electric
604662XXX Denton Crossing Building 4 Total 10,000.00 - 10,000.00 - 10,000.00
604664XXX Bonnie Brae Ph4A Streetlights Total 40,000.00 - 40,000.00 - 40,000.00
604665XXX Mulberry St Loop Tie Total 10,000.00 - 10,000.00 - 10,000.00
604666XXX Honda of Denton Relocation Total 10,000.00 - 10,000.00 - 10,000.00
604667XXX EO2014 EO0857 Pole Machine Total 160,000.00 - 160,000.00 - 160,000.00
604668XXX ED2009 ED0876 Bucket Truck Total 270,000.00 - 270,000.00 - 270,000.00
604669XXX ES2016 ES1058 Utility Truck Total 160,000.00 - 160,000.00 151,867.00 8,133.00
604671XXX PROSE WINDSOR APARTMENTS Total 10,000.00 - 10,000.00 - 10,000.00
604672XXX 2020 PRIORITY POLE REPLACEMENT Total 250,000.00 - 250,000.00 - 250,000.00
604673XXX 2020 STREETLIGHT ADDITIONS Total 500,000.00 1,308.89 498,691.11 - 498,691.11
604674XXX The Mark at Denton Total 10,000.00 - 10,000.00 - 10,000.00
604675XXX Cooper Creek Lift Station ATO Total 10,000.00 - 10,000.00 - 10,000.00
699001XXX 001 - AUTOMATED METER READ Total 989,980.56 - 989,980.56 - 989,980.56
699003XXX 003 - 497 BUILDING CONSTRUCTIO Total 105,542.00 - 105,542.00 - 105,542.00
699007XXX 007 - FIBER EQUIP MAINTENA Total 1,413,906.75 - 1,413,906.75 - 1,413,906.75
699019XXX 019 - FEEDER & EXTENSIONS Total 6,459,528.86 - 6,459,528.86 - 6,459,528.86
699024XXX 024 - 497 OTHER DME PROJECTS Total 39,732.81 - 39,732.81 - 39,732.81
699025XXX 025 - NEW RESIDENTIAL & CO Total 1,978,012.22 - 1,978,012.22 - 1,978,012.22
699028XXX 028 - OVER TO UNDER CONVER Total 500,000.00 - 500,000.00 - 500,000.00
699032XXX 032 - POWER FACTOR IMPROVE Total 103,131.00 - 103,131.00 - 103,131.00
699040XXX 040 - STREET LIGHTING Total 5,933,060.67 - 5,933,060.67 - 5,933,060.67
699080XXX 497 OTHER ELECTRIC PROJECTS Total 112,475.05 - 112,475.05 - 112,475.05
699090XXX 500 OTHER ELECTRIC PROJECTS Total 100,633.14 - 100,633.14 - 100,633.14
699999XXX UNALLOCATED PROJECT & JOB REVE Total 28,709,796.39 - 28,709,796.39 - 28,709,796.39
Grand Total 417,477,925.17 314,778,342.82 ############18,735,305.66 83,964,276.69