2020-078 Quarterly Financial ReportDate: September 4, 2020 Report No. 2020-078
INFORMAL STAFF REPORT
TO MAYOR AND CITY COUNCIL
SUBJECT:
Quarterly Financial Report for the period ending June 30, 2020.
BACKGROUND:
Attached for your review is the Quarterly Financial Report for the period ending June 30, 2020.
If you have any questions or need additional information, please let me know.
STAFF CONTACT:
Cassey Ogden, Finance Director
(940) 349-7195
cassandra.ogden@cityofdenton.com
Section 1
City of Denton
Quarterly Financial Report
June 2020
Executive Dashboards
Note: All figures presented are in millions of dollars.FY 2019-20ANNUAL YTDDESCRIPTIONBUDGET 1ACTUALS ANNUAL VARIANCEBeginning Fund Balance as of 09/30/19 30.13$ 30.74$ 30.74$ RESOURCES: Ad Valorem Taxes48.63 48.50 48.63 0% Sales Tax39.28 28.84 37.83 -4% Franchise Fees4.60 3.06 3.88 -16% Other Taxes0.50 0.17 0.23 -54% Service Fees8.17 4.42 6.74 -18% Fines and Fees3.58 1.92 2.53 -29% Licenses and Permits6.63 3.95 6.11 -8% Miscellaneous Revenue3.31 1.84 2.67 -19% Transfers In21.64 16.09 23.80 10% CRF Funding4.62 Total Revenues 136.34 108.79 137.04 1%Total Resources166.47 139.53 167.78 EXPENDITURES: Personal Service93.24 70.04 93.12 0% Material and Supplies3.27 1.85 2.43 -26% Maintenance and Repairs1.71 0.93 1.51 -12% Insurance1.57 1.18 1.57 0% Miscellaneous1.54 0.84 3.93 155% Operations17.17 10.76 16.36 -5% Transfers Out17.45 13.28 16.77 -4% Fixed Assets0.55 0.30 0.42 -24%Total Expenditures136.50 99.18 136.11 0%Net Income (Loss)(0.16) 9.61 0.93 FY 2019-20PROJECTIONSCity of Denton, Texas General Fund Executive Dashboard $‐ $20 $40 $60 $80 $100 $120Revenue & Expenses (in Millions)YTD RevenueYTD ExpensesKey TrendsSales Tax revenues are projected $1.45M less than budget due to COVID‐19.Service Fees revenues are projected $1.43M less than budget due to the Aquatics Center.Fines and Fees revenues are projected $1.05M less than budget mainly due to Municipal Court fines and fees.Transfers In revenues are projected $2.16M more than budget due to Electric Return on Investment. Under the CARES Act, the Coronavirus Relief Fund (CRF) is projected to provide $4.62M in FY 2019‐20.Miscellaneous expenditures are projected $2.39M more than budget mainly due to COVID‐19 related expenditures. $‐ $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 DashboardFY 2019-20ANNUAL YTDDESCRIPTION BUDGET ACTUALS ANNUAL VARIANCEBeginning Working Capital and Reserves as of 9/30/19 55.64$ 77.92$ 77.92$ RESOURCES: Rate Revenues 146.49 98.64 147.31 1% Transmission Revenue 46.70 32.03 51.92 11% Other Revenues3.98 3.27 9.15 130% DEC Revenues25.07 7.57 25.07 0% COVID-19 Revenue Impact- - (7.35) -7%Total Revenues222.24 141.51 226.10 2%Total Resources277.88 219.43 304.02 EXPENDITURES: Purchased Power74.33 38.81 75.81 2% DEC Fuel12.48 2.05 11.00 -12% Transmission of Power18.62 11.49 17.91 -4% Personnel Service22.75 15.42 22.90 1% Operation and Maintenance30.37 18.01 31.41 3% Debt Service54.73 47.25 54.73 0% Transfers Out15.85 11.62 15.60 -2% Capital Outlay0.10 - 0.11 10%Total Expenditures229.23 144.65 229.47 0%Net Income (Loss)(6.99) (3.14) (3.37) Ending Working Capital and Reserves48.65$ 74.78$ 74.55$ FY 2019-20PROJECTIONS$0$20$40$60$80$100$120$140$160Oct‐19 Nov‐19 Dec‐19 Jan‐20 Feb‐20 Mar‐20 20‐Apr 20‐May 20‐JunRevenue & Expenses (in Millions)YTD RevenueYTD ExpenseKey TrendsTransmission revenue is projected to be $5.2 Million higher than budgeted based on the 2020 Transmission Matrix and DME’s 2019 Interim Filing. Other Revenues are projected to be $5.2 Million higher than budgeted as a result of TMPA Transmission revenue received.As a result of the COVID‐19 Pandemic, a rate revenue loss of $7.35 Million is projected. The ROI rate has been increased from 3.5% to 6% or $2.2 Million in the current year. As a result of cost‐cutting measures, the FY 2020 expenditures are projected to be only $240,000 higher than the budget. 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. Electric Rate Revenues are seasonal with higher revenues normally occurring in the 3rdand 4th Quarters. Estimated projections are based on figures presented to the City Council in April and will be updated in June.01002003004005006002014 – 2020 Historical Quarterly GWH Sales1 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-20ANNUALYTDDESCRIPTIONBUDGET 1ACTUALS ANNUAL VARIANCEBeginning Working Capital and Reserves as of 09/30/19223.54$ 25.46$ 25.46$ RESOURCES: Water Sales39.35 26.40 38.63 -2% Other Water Revenues1.16 1.12 1.19 3% Transfers In0.95 0.86 1.15 21% Impact Fee Revenue6.61 4.96 6.61 0% COVID-19 Revenue Impact- - (0.62) -1%Total Revenues48.07 33.34 46.96 -2%Total Resources71.61 58.80 72.42 EXPENDITURES: Personal Service8.90 6.29 8.51 -4% Operations, Services10.46 6.74 9.94 -5% Capital Outlay13.64 9.16 13.24 -3% Debt Service12.88 12.32 12.88 0% Transfers Out5.18 3.62 5.18 0%Total Expenditures51.06 38.13 49.75 -3%Net Income (Loss)(2.99) (4.79) (2.79) Ending Working Capital and Reserves 20.55$ 20.67$ 22.67$ FY 2019-20PROJECTIONSCity of Denton, Texas Water Fund Executive Dashboard $‐ $5 $10 $15 $20 $25 $30 $35 $40 $45Oct‐19 Nov‐19 Dec‐19 Jan‐20 Feb‐20 Mar‐20 Apr‐20 May‐20 Jun‐20Revenue & Expenses (in Millions)YTD RevenueYTD ExpensesKey TrendsA $0.62M revenue reduction is projected due to the COVID‐19 Pandemic.Transfers in are projected higher than budget due to a larger administrative transfer fromElectric.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.05001,0001,5002,0002,5002014‐2020 Historical Quarterly Gallons Sold (in Millions)
FY 2019-20ANNUALYTDDESCRIPTIONBUDGET 1 ACTUALS ANNUAL VARIANCEBeginning Working Capital and Reserves as of 09/30/19216.19$ 16.93$ 16.93$ RESOURCES: Wastewater Fees25.09 17.82 24.36 -3% Other Wastewater Revenue1.81 1.61 1.71 -6% Drainage Fees4.96 3.80 5.03 1% Transfer In0.59 0.44 0.59 0% Impact Fee Revenue4.27 3.20 4.27 0% COVID-19 Revenue Impact- - (0.39) 0%Total Revenues36.72 26.87 35.57 -3%Total Resources52.91 43.80 52.50 EXPENDITURES: Personal Service9.36 6.63 8.95 -4% Operations, Services9.84 5.59 8.82 -10% Capital Outlay6.79 3.73 7.33 8% Debt Service7.49 7.16 7.48 0% Transfer Out4.85 3.65 4.85 0%Total Expenditures38.33 26.76 37.43 -2%Net Income (Loss)(1.61) 0.11 (1.86) Ending Working Capital and Reserves 14.58$ 17.04$ 15.07$ FY 2019-20PROJECTIONSNote: All figures presented are in millions of dollars.City of Denton, Texas Wastewater1Fund Executive Dashboard $‐ $5 $10 $15 $20 $25 $30Oct‐19 Nov‐19 Dec‐19 Jan‐20 Feb‐20 Mar‐20 Apr‐20 May‐20 Jun‐20Revenue & Expenses (in Millions)YTD RevenueYTD ExpensesKey TrendsA $0.39 million revenue reduction is projected due to the COVID‐19 pandemic.1Includes Drainage.2Annual adopted budget as amended or modified. Beginning Fund Balance represents the amount which was estimated in the FY 2019‐20 budget process.3The 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.02004006008001,0001,2001,4002014‐2020 Historical Quarterly Gallons Billed (in Millions)
FY 2019-20ANNUALYTDDESCRIPTIONBUDGET ACTUALSANNUAL VARIANCEREVENUES: Residential Drainage Fees1.90$ 1.46$ 1.94$ 2% Nonresidential Drainage Fees3.06 2.35 3.09 1% Wastewater Resources0.04 - 0.02 -50% General Fund Transfer0.35 0.26 0.35 0%Total Revenues5.35 4.07 5.40 1%EXPENDITURES: Personal Service2.30 1.63 2.26 -2% Operations, Services0.95 0.57 0.78 -18% Capital Outlay1.14 0.09 1.40 23% Debt Service0.48 0.45 0.48 0% Transfer Out0.48 0.50 0.48 0%Total Expenditures5.35 3.24 5.40 1%Net Income (Loss)-$ 0.83$ -$ FY 2019-20PROJECTIONSNote: All figures presented are in millions of dollars.City of Denton, Texas Drainage Operations Executive Dashboard $‐ $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 $3.5 $4.0 $4.5Revenue & Expenses (in Millions)YTD RevenueYTD ExpensesKey TrendsOperations, Services are projected to be below budget due to reduced materials & supplies and outside services expenses.
FY 2019-20FY 2019-20ANNUAL YTDPROJECTIONSDESCRIPTIONBUDGET 1ACTUALS ANNUAL VARIANCEBeginning Working Capital and Reserves as of 09/30/19210.36$ 9.21$ 9.21$ RESOURCES: Collection & Disposal27.08 20.64 31.00 14% Recycling7.04 5.06 5.84 -17% Other Revenue1.27 1.47 1.54 21% COVID-19 Revenue Impact- - (0.28) Total Revenues35.39 27.17 38.10 8%Total Resources45.75 36.38 47.31 EXPENDITURES: Personal Service11.10 7.85 10.88 -2% Operations, Services9.83 5.50 9.28 -6% Capital Outlay3.81 3.04 3.41 -10% Debt Service8.45 8.16 8.45 0% Landfill Closure0.61 - - -100% Transfer Out4.65 3.34 4.65 0%Total Expenditures38.45 27.89 36.67 -5%Net Income (Loss)(3.06) (0.72) 1.43 Ending Working Capital and Reserves7.30$ 8.49$ 10.64$ 01,0002,0003,0004,0005,0006,0007,0008,0009,00010,0002018Qtr 42019Qtr 12019Qtr 22019Qtr 32019Qtr 42020Qtr 12020Qtr 22020Qtr 3Refuse TonnageRecycling and ReuseTonnageResidential Curbside Collection TonnageNote: All figures presented are in millions of dollars.City of Denton, Texas Solid Waste Fund Executive DashboardKey TrendsResidential curbside collections has increased due to the effect of the response to COVID‐19 with more people at home and increasing residential waste collections.The net effects of COVID‐19 includes revenue reductions of $280,000.The COVID‐19 impact on expenses has been built into the new annual projection amounts.05,00010,00015,00020,00025,00030,0002018Qtr 42019Qtr 12019Qtr 22019Qtr 32019Qtr 42020Qtr 12020Qtr 22020Qtr 3Commercial Refuse & Recycling (Front & Side Load)Cubic Yards Serviced per WeekCommercial RefuseCommercial Recycling1Annual 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 TrendsDue to the economic slow down created by the COVID‐19 response, neither revenues or expenses are projected to meet budget expectations.$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-20FY 2019-20ANNUAL YTDDESCRIPTIONBUDGET 1ACTUALS ANNUAL VARIANCEBeginning Working Capital and Reserves as of 09/30/182.81$ 2.88$ 2.88$ RESOURCES: Airport Ground Leases0.770.590.78 1% FBO Commissions0.210.120.16 -24% Fuel Flowage Fees0.130.080.12 -8%Total Operating Revenues1.11 0.79 1.06 -5%EXPENDITURES: Personal Service0.520.33 0.45 -13% Operations, Services0.390.16 0.21 -46% Transfer Out0.38 0.29 0.38 0%Total Operating Expenditures1.29 0.78 1.04 -19%Net Operating Income (Loss)(0.18) 0.01 0.02 NON-OPERATING REVENUES: Investment Income0.020.070.09 350% Gas Well Royalties0.360.110.21 -42% Miscellaneos Income0.000.000.00 0%Total Non-Operating Revenues0.38 0.18 0.30 -21%NON-OPERATING EXPENDITURES: Transfer Out - Capital0.25 0.25 0.30 20%Total Non-Operating Expenditures0.25 0.25 0.30 20%Net Non-Operating Income (Loss)0.13 (0.07) - Net Income (Loss)(0.05) (0.06) 0.02 Ending Working Capital and Reserves2.76$ 2.82$ 2.90$ 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-20ANNUALYTDDESCRIPTIONBUDGET 1ACTUALS ANNUAL VARIANCEBeginning Working Capital and Reserves as of 09/30/192.35$ 3.44$ 3.44$ RESOURCES: Franchise Fees13.09 8.70 13.09 Street Cuts0.37 0.23 0.37 0% Investment Income0.01 0.04 0.04 300% Transfers In1.18 1.00 1.18 0%Total Revenues14.65 9.97 14.68 0%Total Resources17.00 13.41 18.12 EXPENDITURES: Personal Service3.51 2.50 3.16 -10% Materials & Supplies0.09 0.05 0.08 -11% Maintenance & Repairs10.06 3.95 8.95 -11% Operations, Services0.81 0.52 0.70 -14% Transfer Out1.26 0.97 1.26 0%Total Expenditures15.73 7.99 14.15 -10%Net Income (Loss)(1.08) 1.98 0.53 Ending Fund Balance1.27$ 5.42$ 3.97$ FY 2019-20PROJECTIONS1Annual 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 DashboardKey TrendsProjections for the expenditure impacts of COVID‐19 are included and are based on figures presented to the City Council in August.2.18 lane mile surface treatments were completed in the 3rd quarter. There were no surface treatments completed in the 3rd quarter of FY18‐19.Note: All figures presented are in millions of dollars.036912Qtr1 Qtr2 Qtr3Tons of Asphalt Laid (in Thousands)FY18-19FY19-20020406080100Qtr 1 Qtr 2 Qtr 3Lane Miles Surface TreatmentFY 18-19FY 19-20 $- $1.0 $2.0 $3.0 $4.0 $5.0 $6.0 $7.0 $8.0 $9.0 $10.0 $11.0Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20Revenue & Expenses (in Millions)YTD RevenueYTD Expenses
FY 2019-20FY 2019-20GRANT YTD ANNUAL FY 2019-20DESCRIPTION AMOUNT ACTUALS PROJECTION VARIANCE2019-20 Budget Comm Development13.77$ 1.23$ 1.10$ -71% Public Safety 0.63 0.34 0.63 0% Transportation161.80 13.92 21.26 -66% Other 0.36 0.02 0.36 0%Total Budget 66.56 15.51 23.35 -65%New Awards Public Safety 0.23 0.23 0.23 0% Transportation 0.20 0.20 0.20 0%Total New Awards 0.43 0.43 0.43 0%Totals 66.99$ 15.94$ 23.78$ -65%COMM DEV5.63%PUBLIC SAFETY1.28%TRANS92.55%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 years.Key TrendsThe following grants have been received in FY 2019-20: Federal Equitable Sharing: $146,839Chapter 59 Asset Forfeitures: $15,110U.S. Marshals Violent Offenders Task Force: $41,287Organized Crime Drug Enforcement Task Force: $13,249USSS’ North Texas Financial Crimes Task Force: $310PD-Law Enforcement Officer Standards & Education:$9,600Sexual Assault Examiners Reimbursement:$1,779IH35 E FR & Brinker Signal: $204,937Collaborative Summer Library Program Scholarship Award: $118
Section 2
City of Denton
Quarterly Financial Report
June 2020
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 Fund
Schedule of Revenues - Budget vs Projection (Unaudited)
For the Period Ended June 30, 2020
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 45,411,613$ 47,846,792$ 47,908,948$ 47,996,976$ 47,996,976$ 0%
Delinquent - Ad Valorem 141,538 205,905 253,492 311,978 311,978 0%
Miscellaneous Penalties & Fees 330,966 246,647 341,088 320,775 320,775 0%
Ad Valorem Taxes 45,884,117 48,299,344 48,503,528 48,629,729 48,629,729 0%
Sales Tax 28,159,957 29,465,386 28,837,659 39,281,942 37,834,982 -4%
Franchise - Gas Utilities 224,196 242,553 220,289 384,313 338,163 -12%
Franchise - Private Electric Utilities 46,035 31,912 50,486 117,980 103,813 -12%
Franchise - Cable 169,458 245,964 164,467 363,687 152,678 -58%
Franchise - Telecom 98,784 36,048 62,450 53,301 73,268 37%
Franchise - Denton Municipal Utilities 2,257,469 2,449,877 2,558,245 3,679,652 3,214,907 -13%
Franchise Fees 2,795,942 3,006,354 3,055,937 4,598,933 3,882,830 -16%
Other Taxes 168,626 250,935 168,642 501,870 225,528 -55%
Ambulance Service Fees 1,891,357 2,202,815 2,169,474 3,679,000 3,680,637 0%
Fire Department Fees 150,394 156,000 110,736 208,000 167,600 -19%
Building Inspections Fees 446,894 442,733 422,065 597,476 555,748 -7%
Park Department Fees 1,108,444 1,170,246 227,981 2,040,353 263,817 -87%
Planning Department Fees 775,097 1,021,751 1,342,090 1,362,254 1,864,697 37%
Reprographics Fees 234,065 73,212 85,380 97,603 97,603 0%
Miscellaneous Service Fees 106,813 136,862 65,239 182,471 113,117 -38%
Service Fees 4,713,064 5,203,619 4,422,965 8,167,157 6,743,219 -17%
Denton Municipal Fines 1,083,679 1,127,616 828,852 1,503,486 1,100,879 -27%
Parking Fines 216,650 196,966 121,225 262,620 210,096 -20%
Miscellaneous Fines and Fees 631,350 520,430 405,001 725,712 597,132 -18%
Court Administrative and Service Fees 780,948 782,400 568,027 1,084,800 619,616 -43%
Fines and Fees 2,712,627 2,627,412 1,923,105 3,576,618 2,527,723 -29%
Demolition Permits 3,420 3,322 8,699 4,430 14,750 233%
Building Permits 2,602,671 4,890,717 3,899,957 6,526,709 6,032,542 -8%
Certificate of Occupancy 53,995 50,419 35,223 67,226 52,159 -22%
Miscellaneous Licenses and Permits 24,038 21,065 5,169 28,087 9,255 -67%
Licenses and Permits 2,684,124 4,965,523 3,949,048 6,626,452 6,108,706 -8%
Investment Income 678,735 677,785 595,235 903,382 646,390 -28%
Miscellaneous Revenues 1,271,141 1,160,622 1,248,932 2,409,191 2,028,144 -16%
Miscellaneous Resources 1,949,876 1,838,407 1,844,167 3,312,573 2,674,534 -19%
ROI - Denton Municipal Utilities 5,587,372 6,476,007 6,830,007 8,978,547 11,452,923 28%
Transfers 7,641,000 9,497,856 9,256,591 12,662,121 12,342,121 -3%
Transfers 13,228,372 15,973,863 16,086,598 21,640,668 23,795,044 10%
CRF Funding 4,619,755
Total General Fund Revenues 102,296,705$ 111,630,843$ 108,791,649$ 136,335,942$ 137,042,050$ 1%
City of Denton
General Fund
Schedule of Expenditures - Budget vs Projection (Unaudited)
For the Period Ended June 30, 2020
PRIOR BUDGET CURRENT ANNUAL ANNUAL BUDGET VS
Y-T-D Y-T-D Y-T-D BUDGET PROJECTION PROJECTION
NEIGHBORHOOD SERVICES
Building Inspections 2,300,791$ 2,578,180$ 2,481,481$ 3,437,095$ 3,319,517$ -3%
Community Improvement Services 1,007,604 1,215,588 957,282 1,620,557 1,602,951 -1%
Libraries 4,458,359 4,649,167 4,409,124 6,194,023 6,086,638 -2%
Parks and Recreation 7,140,588 9,086,973 6,866,414 12,114,271 10,830,399 -11%
Planning 2,178,377 3,041,519 2,766,963 4,054,801 3,726,072 -8%
Gas Well Review 219,563 316,844 236,923 422,398 422,398 0%
Social Services 447,837 1,287,714 923,849 1,716,712 1,577,323 -8%
17,753,119 22,175,985 18,642,036 29,559,857 27,565,298 -7%
PUBLIC SAFETY
Animal Services 1,472,668 1,720,650 1,625,778 2,293,869 2,276,024 -1%
Fire 22,898,284 23,896,576 24,664,970 31,857,795 31,961,491 0%
Municipal Court 830,262 887,216 1,094,001 1,182,784 1,154,475 -2%
Municipal Judge 314,654 425,574 430,202 564,530 552,300 -2%
Police 26,100,548 29,954,045 29,438,085 39,933,338 40,106,002 0%
51,616,416 56,884,061 57,253,036 75,832,316 76,050,292 0%
TRANSPORTATION
Traffic Operations 1,229,715 1,732,788 1,578,315 2,310,060 2,279,912 -1%
Transportation Operations 146,322 - - - - 0%
Street Lighting 614,822 637,585 613,414 850,000 816,167 -4%
1,990,859 2,370,373 2,191,729 3,160,060 3,096,079 -2%
ADMINISTRATIVE & COMMUNITY SERVICES
City Manager's Office 1,789,631 1,843,876 1,652,450 2,458,145 2,408,453 -2%
Economic Development 2,610,174 3,722,615 2,437,934 4,962,803 4,449,950 -10%
Facilities Management 3,409,172 - - - - 0%
Finance 2,495,789 2,974,732 2,710,121 3,965,753 3,965,753 0%
Human Resources 1,321,710 1,369,974 1,707,879 1,826,381 1,850,707 1%
Internal Audit 314,142 482,709 386,188 643,519 598,719 -7%
Legal Administration 1,825,246 2,171,470 2,089,387 2,883,241 2,895,473 0%
Public Affairs 1,413,017 1,885,152 1,425,508 2,513,173 1,919,720 -24%
Non-Departmental 5,627,500 6,505,485 8,688,048 8,691,300 11,306,708 30%
20,806,381 20,956,013 21,097,515 27,944,315 29,395,483 5%
TOTAL EXPENDITURES 92,166,775$ 102,386,432$ 99,184,316$ 136,496,548$ 136,107,152$ 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 June 30, 2020
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 101,046,654$ 99,210,107$ 98,641,565$ 146,489,831 147,313,675 1%
Transmission Revenues 31,467,284 28,397,027 32,034,565 46,700,670 51,916,732 11%
Other Revenues 3,493,377 2,592,759 3,274,226 3,977,004 9,147,994 130%
COVID-19 Revenue Impact (7,349,785)
DEC Revenues 9,666,842 17,517,112 7,568,590 25,073,394 25,073,394 0%
Total Revenues 145,674,157 147,717,005 141,518,946 222,240,899 226,102,010 2%
EXPENDITURES:
Purchased Power 44,256,021 51,739,434 38,810,182 74,329,750 75,805,525 2%
DEC Fuel 4,102,393 8,583,427 2,048,738 12,475,775 11,000,000 -12%
Transmission of Power 13,757,937 10,658,271 11,491,662 18,616,102 17,911,273 -4%
Personnel Services 13,530,176 17,411,110 15,427,051 22,747,359 22,900,384 1%
Materials and Supplies 510,341 842,531 570,831 1,283,850 971,570 -24%
Maintenance and Repair 478,526 1,255,910 475,512 1,826,609 1,060,581 -42%
Insurance 204,045 1,068,029 748,172 1,424,039 1,403,470 -1%
Return on Investment Return on Investment4,136,664 4,416,109 5,277,189 6,613,804 8,851,888 34%
Franchise Fee Franchise Fee5,910,147 6,309,929 6,320,598 9,448,292 9,973,958 6%
Miscellaneous 463,664 1,169,389 1,488,529 1,374,225 1,541,768 12%
Operations 3,569,571 6,297,746 3,126,855 8,415,902 7,617,455 -9%
Debt Service 43,493,607 47,247,510 47,247,510 54,728,969 54,728,969 0%
Interfund Transfers 10,510,058 11,886,400 11,620,585 15,848,533 15,590,049 -2%
Capital Outlay 8,160,000 - - 95,000 111,000 17%
Total Expenditures 153,083,150 168,885,795 144,653,414 229,228,209 229,467,890 0%
Net Income (Loss)(7,408,993)$ (21,168,790)$ (3,134,468)$ (6,987,310) (3,365,880)
Ending Working Capital and Reserves 48,655,060$ 74,553,556$
City of Denton
Water Fund
Schedule of Revenues and Expenditures - Budget vs Projections (Unaudited)
For the Period Ended June 30, 2020
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 11,057,531$ 13,040,817$ 13,119,920$ 20,508,495 19,922,302 -3%
Water Sales Commercial 10,692,401 12,017,997 11,815,200 17,661,792 17,229,269 -2%
Water for Resale 629,227 901,474 1,463,171 1,184,134 1,473,383 24%
Other Water 1,069,444 611,920 872,639 865,090 903,038 4%
Transfers In 1,117,540 712,416 862,494 949,888 1,149,112 21%
Investment Income 318,672 220,500 247,601 294,000 294,000 0%
Impact Fee Revenue 4,275,570 4,953,750 4,954,411 6,605,000 6,605,000 0%
COVID-19 Revenue Impact (616,542)
Total Revenues 29,160,385 32,458,874 33,335,436 48,068,399 46,959,562 -2% Use of Reserves - - - -
EXPENDITURES:
Personal Service 5,805,850 6,257,087 6,290,222 8,902,207 8,510,158 -4%
Purchased Power 883,570 1,010,156 922,617 1,410,789 1,410,789 0%
Purchase of Water 1,520 - 1,408 3,000 3,000 0%
Materials and Supplies 852,456 1,027,768 971,411 1,510,203 1,478,542 -2%
Maintenance and Repairs 831,878 996,758 1,179,475 1,604,503 1,711,781 7%
Insurance 167,575 174,593 174,591 232,791 232,790 0%
Miscellaneous 197,507 299,686 151,213 401,060 209,752 -48%
Operations, Services 1,011,020 1,476,910 1,136,156 1,903,980 1,610,219 -15%
Capital Outlay 9,940,797 8,672,635 9,149,019 13,636,219 13,236,219 -3%
Return on Investment 805,076 951,375 908,029 1,404,533 1,351,873 -4%
Franchise Fee 1,150,108 1,349,174 1,297,185 1,991,812 1,931,248 -3%
Debt Service 12,168,436 12,321,126 12,321,126 12,879,020 12,879,020 0%
Transfers Out 2,641,946 3,886,235 3,623,562 5,181,646 5,181,647 0%
Total Expenditures 36,457,739 38,423,503 38,126,014 51,061,763 49,747,038 -3%
Net Income (Loss)(7,297,354)$ (5,964,629)$ (4,790,578)$ (2,993,364) (2,787,476)
Ending Working Capital
and Reserves 20,545,984$ 22,669,998$
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 Fund1
Schedule of Revenues and Expenditures - Budget vs Projections (Unaudited)
For the Period Ended June 30, 2020
PRIOR BUDGET CURRENT ANNUAL ANNUAL BUDGET VS
DESCRIPTION Y-T-D Y-T-D Y-T-D BUDGET3 PROJECTION PROJECTION
Beginning Working Capital
and Reserves as of 09/30/192 16,190,748$ 16,927,079$
REVENUES:
Residential Fees 8,730,268$ 8,637,222$ 8,544,750$ 11,545,026 11,403,067 -1%
Commercial Fees 8,539,786 9,301,059 8,601,412 12,784,519 12,210,744 -4%
Effluent Irrigation Fees 52,933 35,363 83,828 60,424 60,424 0%
Wholesale Fees 559,053 512,939 579,615 693,802 695,320 0%
Other Wastewater Fees 1,030,799 1,132,275 1,443,986 1,580,878 1,489,451 -6%
Drainage Fees 3,648,037 3,694,227 3,801,784 4,959,200 5,029,283 1%
Transfer In 492,180 440,921 440,921 587,895 587,894 0%
Investment Income 210,303 176,144 174,930 234,858 216,694 -8%
Impact Fee Reserves 1,500,200 3,202,500 3,202,927 4,270,000 4,270,000 0%
COVID-19 Revenue Impact (388,788)
Total Revenues 24,763,559 27,132,650 26,874,153 36,716,602 35,574,090 -3%
EXPENDITURES:
Personal Service 5,993,564 6,515,403 6,627,969 9,357,192 8,951,899 -4%
Purchased Power 816,544 944,959 782,496 1,221,000 1,220,000 0%
Materials and Supplies 638,731 788,817 699,835 1,352,538 1,098,940 -19%
Maintenance and Repairs 710,529 1,206,213 669,980 1,770,032 1,552,580 -12%
Insurance 174,015 199,307 199,307 265,743 265,744 0%
Miscellaneous 72,526 75,723 52,098 82,218 59,168 -28%
Operations, Services 1,435,767 1,816,164 1,626,732 2,624,514 2,117,481 -19%
Capital Outlay 7,225,858 5,088,800 3,723,089 6,785,067 7,338,229 8%
Return on Investment 645,632 883,876 644,789 1,196,502 1,028,959 -14%
Franchise Fee 922,331 985,509 921,127 1,334,082 1,469,942 10%
Debt Service 6,600,030 7,162,859 7,162,859 7,485,506 7,479,000 0%
Transfers Out 2,666,606 3,637,862 3,654,831 4,850,481 4,850,481 0%
Total Expenditures 27,902,133 29,305,492 26,765,112 38,324,875 37,432,423 -2%
Net Income (Loss)(3,138,574)$ (2,172,842)$ 109,041$ (1,608,273) (1,858,333)
Ending Working Capital
and Reserves 14,582,475$ 15,068,746$
1 Includes Drainage.
2 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.
3 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 June 30, 2020
PRIOR BUDGET CURRENT ANNUAL ANNUAL BUDGET VS
DESCRIPTION Y-T-D Y-T-D Y-T-D BUDGET PROJECTION PROJECTION
REVENUES:
Residential Drainage Fees 1,405,447$ 1,417,672$ 1,457,071$ 1,897,150$ 1,934,821$ 2%
Nonresidential Drainage Fees 2,242,590 2,276,574 2,344,713 3,062,050 3,094,463 1%
Wastewater Resources - 26,250 - 35,000 18,000 -49%
General Fund Transfer 237,596 264,671 264,671 352,895 352,894 0%
Total Revenues 3,885,633 3,985,167 4,066,455 5,347,095 5,400,177 1%
EXPENDITURES:
Personal Service 1,281,953 1,624,533 1,626,518 2,304,775 2,262,925 -2%
Materials and Supplies 30,876 57,877 41,918 80,425 69,342 -14%
Maintenance and Repairs 89,439 104,415 73,864 127,500 125,500 -2%
Insurance 26,825 31,094 31,094 41,459 41,459 0%
Miscellaneous 13,765 14,878 8,375 17,200 12,800 -26%
Operations, Services 323,512 513,599 408,414 677,047 528,045 -22%
Capital Outlay 1,304,039 827,900 92,482 1,144,236 1,405,653 23%
Debt Service 462,153 453,451 453,451 477,893 477,893 0%
Transfer Out 353,071 357,420 496,483 476,560 476,560 0%
Total Expenditures 3,885,633 3,985,167 3,232,599 5,347,095 5,400,177 1%
Net Income (Loss)-$ -$ 833,856$ -$ -$
City of Denton
Solid Waste Fund
Schedule of Revenues and Expenditures - Budget vs Projection (Unaudited)
For the Period Ended June 30, 2020
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$ 9,205,597$
REVENUES:
Refuse Fees - Residential 4,317,373$ 4,319,750$ 3,849,623$ 5,797,663 5,429,749 -6%
Refuse Fees - Commercial 11,145,834 11,403,669 10,389,363 15,432,175 16,091,876 4%
Residential Recycling 3,969,821 3,999,304 4,071,442 5,331,694 4,850,729 -9%
Commercial Recycling 1,050,283 1,278,930 987,392 1,705,012 987,392 -42%
Landfill Gate and Material Sales 4,620,246 4,317,733 6,403,341 5,854,458 9,482,887 62%
Recycled Material Sales 50,506 45,756 50,508 61,000 67,433 11%
Asset Sales and Interest Income 114,767 516,433 987,194 688,486 987,194 43%
Other Revenue 177,198 390,749 435,184 520,925 487,634 -6%
COVID-19 Revenue Impact (280,000)
Total Revenues 25,446,028 26,272,324 27,174,047 35,391,413 38,104,894 8%
EXPENDITURES:
Personal Service 7,488,187 8,304,868 7,852,348 11,104,627 10,879,651 -2%
Materials and Supplies 141,258 198,413 141,315 379,463 716,813 89%
Maintenance and Repairs 173,121 254,388 166,488 327,192 254,877 -22%
Insurance 202,129 193,062 194,738 257,942 240,308 -7%
Miscellaneous 71,404 76,502 68,433 102,120 86,262 -16%
Operations, Services 4,541,428 5,445,770 3,632,885 6,999,814 6,228,106 -11%
Capital Outlay 748,478 2,768,439 3,035,085 3,810,010 3,409,735 -11%
Debt Service 8,702,688 8,159,750 8,158,892 8,451,027 8,451,027 0%
Franchise Fee 1,270,491 1,316,979 1,299,259 1,755,737 1,755,737 0%
Transfers for Landfill Closure 877,014 457,551 - 609,985 - -100%
Admin Transfers Out 2,850,563 3,486,645 3,343,878 4,652,484 4,652,484 0%
Total Expenditures 27,066,761 30,662,367 27,893,321 38,450,401 36,675,000 -5%
Net Income (Loss)(1,620,733)$ (4,390,043)$ (719,274)$ (3,058,988) 1,429,894
Ending Working Capital
and Reserves 7,296,490$ 10,635,491$
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 June 30, 2020
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 551,051$ 576,115$ 586,975$ 768,051 782,633 2%
FBO Commissions 142,776 158,685 116,495 211,552 155,327 -27%
Miscellaneous 97,191 101,592 80,172 135,437 117,916 -13%
Total Operating Revenues 791,018 836,392 783,642 1,115,040 1,055,876 -5%
OPERATING EXPENDITURES:
Personal Service 381,800 389,252 334,116 518,930 445,488 -14%
Materials and Supplies 14,282 33,476 14,802 44,794 19,736 -56%
Maintenance and Repairs 13,188 54,309 29,259 72,400 39,012 -46%
Insurance 32,846 18,284 18,282 24,376 24,376 0%
Miscellaneous - 75 - 100 - -100%
Operations 126,419 187,956 95,078 250,565 127,054 -49%
Transfers Out - Operating 391,161 287,778 287,244 383,487 382,991 0%
Total Operating Expenses 959,696 971,130 778,781 1,294,652 1,038,657 -20%
Operating (Loss)(168,678) (134,738) 4,861 (179,612) 17,219
NON-OPERATING REVENUES:
Investment Income 74,594 16,700 65,913 22,263 87,884 295%
Gas Well Royalties 174,084 269,211 108,155 358,900 216,310 -40%
Total Non-Operating Revenues 248,678 285,911 182,245 381,163 304,194 -20%
NON-OPERATING EXPENDITURES:
Transfers Out - Capital 250,000 187,525 250,000 250,000 300,000 0%
Total Non-Operating Expenses 250,000 187,525 250,000 250,000 300,000 0%
Non-Operating Income (Loss)(1,322)98,386 (67,755)131,163 4,194
Net Income (Loss)(170,000)$ (36,352)$ (62,894)$ (48,449)21,413
Ending Working Capital 2,766,243$ 2,900,353$
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 June 30, 2020
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 8,664,269$ 9,816,599$ 8,696,195$ 13,087,053 13,087,053 0%
Street Cuts 150,632 278,605 229,245 371,423 371,423 0%
Investment Income 21,021 7,501 43,361 10,000 43,361 334%
Transfers In 775,936 888,556 1,003,235 1,184,582 1,184,582 0%
Total Resources 9,611,858 10,991,261 9,972,036 14,653,058 14,686,419 0%
EXPENDITURES:
Personal Service 2,486,603 2,629,302 2,498,426 3,505,267 3,164,472 -10%
Materials and Supplies 54,814 65,374 53,933 87,150 83,550 -4%
Maintenance and Repairs 4,962,128 7,539,606 3,945,777 10,058,459 8,945,604 -11%
Insurance 54,545 70,745 70,734 94,312 94,312 0%
Miscellaneous 5,062 3,751 3,023 5,000 4,500 -10%
Operations, Services 593,575 535,299 442,233 710,302 603,773 -15%
Transfer Out 1,026,319 955,850 984,534 1,270,626 1,259,626 -1%
Total Expenditures 9,183,046 11,799,927 7,998,660 15,731,116 14,155,837 -10%
Net Income (Loss)428,812$ (808,666)$ 1,973,376$ (1,078,058) 530,582
Ending Fund Balance 1,270,212$ 3,972,314$
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 June 30, 2020
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$ 758,023$ 2,314,276$ 700,000$ -70%
US Dept of HUD -
HOME Investment Partnership Program 3,725,784 467,998 1,458,845 400,000 -73%
Community Development1 8,000,211 1,226,021 3,773,121 1,100,000 -71%
TxDot STEP Comprehensive Grant - 43,731 97,315 97,315 0%
Victim Assistance Coordinator Grant - 74,097 89,040 89,040 0%
2019 UASI-Specialized Regional Response Teams
Sustainment - 33,625 144,137 144,137 0%
Emergency Management Performance Grant - - 40,977 40,977 0%
Staffing for Adequate Fire & Emergency Response
(SAFER) Grant 736,068 184,810 260,913 260,913 0%
Public Safety 736,068 336,263 632,382 632,382 0%
Airport Maintenance (RAMP) Grant - 23,321 50,000 50,000 0%
TxDot-RTR-Mayhill Rd-IH35 E to US 380 39,389,775 5,173,782 9,624,580 7,406,466 -23%
TxDot-RTR-Bonnie Brae Rd-IH35 E to US 377 17,236,196 3,335,113 29,630,282 6,382,373 -78%
TxDot-IH35E at Loop 288/Lillian Miller Pkwy - - 53,865 - -100%
TxDot-RTR-McKinney (Formerly FM426) 3,834,606 4,711,740 16,410,716 6,413,186 -61%
TxDot-RTR-Hickory Creek FM2181-FM2499 224,556 437,469 2,204,917 512,030 -77%
TxDot-RTR-North Texas Boulevard Roundabout 67,518 25,524 1,946,267 30,903 -98%
TxDot-RTR-ITS COMM Trunk Line 1,379,761 210,521 375,417 271,491 -28%
Bicycle & Pedestrian Projects Grant - - 1,500,000 195,000 -87%
Transportation1 62,132,412 13,917,470 61,796,044 21,261,449 -66%
Interlibrary Loan Program (ILL) - - 25,000 25,000 0%
TexTreasures Grant - 24,820 24,820 24,820
TIFMAS Training Tuition Grant - - 9,000 9,000 0%
Miscellaneous New Grants - - 300,000 300,000 0%
Other - 24,820 358,820 358,820 0%
Total FY 2019-20 Budget 70,868,691 15,504,574 66,560,367 23,352,651 -65%
New Awards
Federal Equitable Sharing - 146,839 146,839 146,839 0%
Chapter 59 Asset Forfeitures - 15,110 15,110 15,110 0%
U.S. Marshals Violent Offenders Task Force - 41,287 41,287 41,287 0%
Organized Crime Drug Enforcement Task Force - 13,249 13,249 13,249 0%
USSS' North Texas Financial Crimes Task Force - 310 310 310 0%
PD-Law Enforcement Officer Standards &
Education - 9,600 9,600 9,600 0%
Sexual Assault Nurse Examiners (SANE)
Reimbursement - 1,779 1,779 1,779 0%
Public Safety - 228,174 228,174 228,174 0%
TxDot-IH35 E FR & Brinker Signal - 204,937 204,937 204,937 0%
Transportation - 204,937 204,937 204,937 0%
City of Denton
Grants
Schedule of Expenditures - Budget vs Projection (Unaudited)
For the Period Ended June 30, 2020
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 - 433,229 433,229 433,229 0%
TOTALS 70,868,691$ 15,937,803$ 66,993,596$ 23,785,880$ -64%
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
June 2020
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 June 30, 2020
Gross Domestic Product (GDP)
In early June, the NBER declared the U.S. expansion had peaked in February and was officially in recession. The initial reading of
second quarter GDP showed a -32.9% plunge, the sharpest quarterly decline in eight decades. The decline was primarily
driven by a -34.6% drop in consumption as nonessential businesses were shuttered and most consumers were huddled in their
homes. Spending on services, typically more resilient to downturns, felt the brunt of the lockdown as bars, restaurants, hair
salons, gyms, yoga studios and dry cleaners were closed for much of the quarter. Residential investment (housing) fell nearly
-40%, and business investment dropped -27%. Federal government spending was one of few positive contributors, up +2.7%, while state and local government spending fell -5.6%.
Nonfarm Payrolls Data graphs will forever be warped by the last four months of employment data. U.S.
company payrolls dropped by almost 21 million jobs in April before re-adding 2.7 million of those jobs in May and another 4.8 million in June. The unemployment rate spiked to 14.7% in April, easily the highest since the Great Depression, but has
subsequently moved lower. The number of individuals who’d like a job but are not currently looking for work fell by -767k in June, but remains elevated at 8.2 million. The U6, or “underemployment rate,” which includes everyone who would accept a suitable full-time job if presented to them, along with those working part-time while
preferring to work fulltime, fell from 21.2% to 18%. This is more indicative of reality.
Inflation The headline consumer price index (CPI) rose +0.6% month-over-month in June while the core (ex-food and energy) climbed +0.2%, each a tenth more than expected. On a year-over-year basis, CPI was up +0.6%, as expected, while the core rose +1.2%, the same as in May. The Fed-favorite Core Personal Consumption Expenditures (PCE) rose +0.1% in May, a tenth of a percentage point more than forecast following a decline of -0.5% in
April. Fed officials and most economists expect
deflation to be more of a problem than inflation at this point as overall consumer demand has retreated.
Retail Sales
The +7.5% June increase in retail sales followed a revised +18.2% record gain in May. Spending was positive in 10 of 13 categories with clothing sales up more than 100% month-over-month, while sales of furniture and electronics climbed 33% and 37% respectively. Auto sales and parts
rose +8.2% as people opted for private vehicles over public transportation. Spending in grocery stores retreated -1.6%
as more and more Americans cautiously began returning to restaurants. On a year-over-year basis, spending was actually
higher in 2020. However, the trend is likely to be shorted-lived unless congress is willing to extend the generous federal unemployment benefits that have helped fuel the recent surge in purchases.
Denton County and Texas Home Sales
Texas home sales rose +20.2% in the second quarter, but were down -9.5% over the same three-month period a year ago. The average Texas home price in June was $313.1k, setting a new record high. The available inventory was just 3 months, the lowest level since the data series began in 1990. In Denton County, unit home sales rose +27.2% during the second quarter, but were down -5.8% over the same three-month period a year ago. The average home price in June was $372.1k, the highest level on
record, and up +2.7% year-over-year.
Denton County home listings totaled 3,110 in June, a -30% decline year-over-year. The available inventory was just 2.4 months,
compared to 3.6 months a year ago.
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 20.2%decrease from the prior quarter at the national level
and a 22.8% 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
3Q '16 1Q '17 3Q '17 1Q '18 3Q '18 1Q '19 3Q '19 1Q '20 3Q '20 MillionsDollarsFuel Prices
Sales Tax Texas Fuel Prices US Fuel Prices
Municipal Cost Index Outlook Cautious
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 3rd Quarter of 2019-20 shows an decrease of 2.6 for a 1.0% decrease over the prior quarter and an
decrease of 1.1 for a 0.4% decrease over the 3rd Quarter of 2018-19. Staff has rated this indicator as Cautious.
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
247.00
248.00
249.00
250.00
251.00
252.00
253.00
254.00
255.00
256.00
3Q '18 4Q '18 1Q '19 2Q '19 3Q '19 4Q '19 1Q '20 2Q '20 3Q '20
Municipal Cost Index
Hotel Occupancy Tax Analysis Outlook Cautious
3rd Quarter FY 2019-20
Actual Y-T-D
Occupancy Tax Revenue:334,415$ 1,665,471$
FY 2019-20 Budget 1,022,684$ 2,512,191$
Over (Under) Budget (688,269)$ (846,721)$
Hotel Occupancy Tax Budget:3,375,164$
2,072,776$
Variance:(1,302,388)$
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 3rd Quarter of FY 2020 was 67.3% less than budget and 148.64% less than the prior year's
actual. This quarter illustrated the immediate economic impact of the COVID-19 Pandemic. Staff has rated the outlook
for this economic indicator as Cautious.
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 Cautious
3rd Quarter FY 2019‐20
Actual Y‐T‐D
Revenue: Gross Sales Tax
Municipal Operations 433,864$ 1,316,718$
General Retail & Others 9,318,401 28,633,142
Comptroller Fees (182,981) (561,718)
Amount Retained (179,321) (550,484)
Total Revenue 9,389,963$ $28,837,658
Expenses: Economic Incentives*
Economic Incentives1 650,508$ 2,144,834$
Net Total 8,739,455 26,692,824
FY 2019‐20 Budget 9,045,593 26,684,522
Over(Under) Budget (306,138)$ 8,302$
Sales Tax Budget:39,281,942$
Year End Projection:37,834,982
Variance to Original Budget:(1,446,960)$
Economic Development Expenditure Budget:3,011,090$
Year End Projection:2,591,090
Variance to Original Budget:(420,000)$
* Economic Incentive actuals are through May 2020 with budget amount for June.
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 3rd quarter of FY 2020 compared to revenues from
the prior year 3rd quarter shows a 3.72% decrease, and compared to the budget it is 3.38% under. Staff has rated this
indicator as Negative.
$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 Cautious
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 40.19%from the prior quarter and decreased 39.05%
from the 3rd Quarter of 2019. Staff has rated the outlook for this revenue indicator as Cautious.
0.0
20.0
40.0
60.0
80.0
100.0
120.0
140.0
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
2Q
'20
3Q
'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 increased 18.1%from the prior quarter and decreased 32.6%from the 3rd
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
'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
2Q
'20
3Q
'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 15.13% from the prior quarter and
decreased 19.66% from the 3rd Quarter of 2018‐19. Staff has rated this indicator as Cautious
100.0
105.0
110.0
115.0
120.0
125.0
130.0
135.0
140.0
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 3Q '20
Texas Leading Indicators Index
Unemployment Rate Index Outlook Cautious
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 11.77% for the 3rd
Quarter. As a result of the upward unemployment trend, staff has rated the outlook indicator as Cautious.
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
20.0
3Q '14 1Q '15 3Q '15 1Q '16 3Q '16 1Q '17 3Q '17 1Q '18 3Q '18 1Q '19 3Q '19 1Q '20 3Q '20
Unemployment Rate Index
Dallas‐Plano‐Irving MD Denton Texas U6 Unemployment United States
Section 4
City of Denton
Quarterly Financial Report
June 2020
INVESTMENT REPORT
3rd Fiscal Quarter 2020- June 30, 2020 Page 1
INVESTMENT POOL
Policy
Par Market Book Unrealized Max.Benchmark
Portfolio:Value Value Value Gain/(Loss)1 WAM WAM YTM Yield*
Investment Pool 523,113,175$ 529,289,987$ 524,669,650$ 4,620,337$ 245 550 1.31%0.18%
*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 149,000,000 151,048,888 149,366,856 1,682,032 252 1.93% 28.47%100.00%
U.S. Federal Agencies 221,281,000 225,243,610 222,362,573 2,881,037 392 1.56% 42.38%100.00%
Municipal Bonds 4,000,000 4,171,929 4,172,413 (484) 229 0.23% 0.80%15.00%
Certificates of Deposit - 0 0.00% 0.00%35.00%
Commercial Paper 45,000,000 44,993,385 44,935,633 57,752 57 0.69% 8.56%15.00%
Local Government Investment Pools 100,855,390 100,855,390 100,855,390 - 1 0.20% 19.22%50.00%
Demand Deposits 2,976,785 2,976,785 2,976,785 - 1 0.25% 0.57%-
Total Portfolio 523,113,175$ 529,289,987$ 524,669,650$ 4,620,337$ 245 1.31% 100.00%-
Current 3 Months Ago 3 Month 1 Year Ago
Investment Pool Comparisons:06/30/2020 03/31/2020 Difference 06/30/2019
Par Value 523,113,175$ 551,772,526$ (28,659,351)$ 571,880,125$
Market Value 529,289,987$ 556,140,638$ (26,850,651)$ 572,216,038$
Book Value 524,669,650$ 552,720,901$ (28,051,251)$ 570,837,285$
Unrealized Gain(Loss)4,620,337$ 3,419,737$ 1,200,600$ 1,378,753$
Weighted Average Maturity 245 256 (11) 276
Yield to Maturity 1.31%1.62%-0.310%2.20%
Portfolio Composition:
U.S. Treasuries 28.47%32.45%-3.98%17.41%
U.S. Federal Agencies 42.38%40.53%1.85%51.21%
Municipal Bonds 0.80%0.00%0.80%0.70%
Certificates of Deposit 0.00%0.00%0.00%5.26%
Commercial Paper 8.56%9.12%-0.56%6.53%
Local Government Investment Pools 19.22%13.09%6.13%18.53%
Demand Deposits 0.57%4.80%-4.24%0.36%
Bank Collateral Review**:Institution Collateral Type Market Value Collected Balance Collateral Ratio
Wells Fargo Demand Deposits BNY Mellon U.S. Agency MBS 25,521,671$ 2,976,785$ 857.36%
**Does not include FDIC insurance
Depository Ledger Balance Review:Institution Account Type Beginning Bal. Deposits Ending Bal.
Wells Fargo Bank Checking 3,054,522$ 105,626,980$ 2,976,785$
Compliance Statement & Review:
(31)
-0.89%
0.10%
(42,926,051)$
(46,167,635)$
3,241,584$
11.06%
CITY OF DENTON : QUARTERLY INVESTMENT REPORT
1 Year Ago
Difference
(48,766,950)$
1Unrealized gain/(loss) is the difference between the market and book value and does not represent an actual gain or loss. Gains and losses are realized only
when a security is sold prior to maturity. Since it is the City's practice to hold investments until they mature, the temporary gains and losses are unlikely to be
realized.
Withdrawals
The Quarterly Investment Report is in full compliance with the objectives, restrictions, and strategies as set forth in the City of Denton's Investment Policy and the
Public Funds Investment Act (Texas Government Code, Chapter 2256.023).
Approver: David Gaines
-8.83%
-5.26%
0.21%
Pledge Required
2.03%
> 102%
0.69%
DAVID GAINES
105,704,717$
Assistant Director of Finance
Reviewer: Cody Wood
Chief Financial Officer Director of Finance
Approver: Cassandra Ogden
CASSANDRA OGDEN
Reviewer: Randee Klingele
Treasury Manager
CODY WOOD RANDEE KLINGELE
NICHOLE WOODS
Preparer: Nichole Woods
Treasury Analyst
3rd Fiscal Quarter 2020- June 30, 2020 Page 2
INVESTMENT POOL
Current 3 Months Ago 3 Month 1 Year Ago 1 Year
06/30/2020 03/31/2020 Difference 06/30/2019 Difference
Par Value - U.S. Treasuries 149,000,000$ 179,000,000$ (30,000,000)$ 100,000,000$ 49,000,000$
Par Value - U.S. Federal Agencies 221,281,000 223,281,000 (2,000,000) 292,536,000 (71,255,000)
Par Value - Municipal Bonds 4,000,000 4,000,000 4,000,000 -
Certificates of Deposit - 30,000,000 (30,000,000)
Par Value - Commercial Paper 45,000,000 50,580,000 (5,580,000) 37,500,000 7,500,000
Local Government Investment Pools 100,855,390 72,355,390 28,500,000 105,804,194 (4,948,804)
Demand Deposits 2,976,785 26,556,136 (23,579,351) 2,039,931 936,854
Total Par Value 523,113,175$ 551,772,526$ (28,659,351)$ 571,880,125$ (48,766,950)$
Market Value - U.S. Treasuries 151,048,888$ 180,628,912$ (29,580,024)$ 99,902,745$ 51,146,143$
Market Value - U.S. Federal Agencies 225,243,610 226,185,853 (942,243) 293,165,540 (67,921,930)
Market Value - Municipal Bonds 4,171,929 4,171,929 3,991,640 180,289
Certificates of Deposit - 30,000,000 (30,000,000)
Market Value - Commercial Paper 44,993,385 50,414,347 (5,420,962) 37,311,988 7,681,397
Local Government Investment Pools 100,855,390 72,355,390 28,500,000 105,804,194 (4,948,804)
Demand Deposits 2,976,785 26,556,136 (23,579,351) 2,039,931 936,854
Total Market Value 529,289,987$ 556,140,638$ (26,850,651)$ 572,216,038$ (42,926,051)$
Book Value - U.S. Treasuries 149,366,856$ 179,374,877$ (30,008,021)$ 99,375,096$ 49,991,760$
Book Value - U.S. Federal Agencies 222,362,573 224,006,234 (1,643,661) 292,317,285 (69,954,712)
Book Value - Municipal Bonds 4,172,413 4,172,413 4,000,000 172,413
Certificates of Deposit - 30,000,000 (30,000,000)
Book Value - Commercial Paper 44,935,633 50,428,264 (5,492,631) 37,300,779 7,634,854
Local Government Investment Pools 100,855,390 72,355,390 28,500,000 105,804,194 (4,948,804)
Demand Deposits 2,976,785 26,556,136 (23,579,351) 2,039,931 936,854
Total Book Value 524,669,650$ 552,720,901$ (28,051,251)$ 570,837,285$ (46,167,635)$
Accrued Interest 2,283,427$ 1,887,805$ 395,622$ 2,706,286$ (422,859)$
Cash Value -531,573,414$ 558,028,443$ (26,455,029)$ 574,922,324$ (43,348,910)$
(Total Market Value + Accrued Interest)
Unrealized Gain/(Loss)4,620,337$ 3,419,737$ 1,200,600$ 1,378,753$ 3,241,584$
Change in Fair Value for the Quarter -(889,543)$ (1,597,066)$ 707,522$ (1,980,866)$ 1,091,323$
(GASB 31)
Strategy Statement:
CITY OF DENTON : QUARTERLY INVESTMENT REPORT
The investment pool is an aggregation of the majority of City funds which may include tax receipts, enterprise fund revenues, fine and fee income,
as well as some, but not necessarily all bond proceeds, grants, gifts and endowments. This portfolio is maintained to meet anticipated daily cash
needs for the City's operations, capital projects and debt service. In order to meet these obligations and 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 are to: (1)
ensure safety of principal by investing in only high quality securities for which a strong secondary market exists; (2) ensure that anticipated cash
flow needs are matched with adequate investment liquidity; (3) limit market and credit risk through diversification; and (4) attain the best feasible
yield, commensurate with the objectives and restrictions set forth in the Investment Policy, by actively managing the portfolio 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.
3rd Fiscal Quarter 2020- June 30, 2020 Page 3
INVESTMENT POOL
Current 3 Months Ago 1 Year Ago
Summary By Security Type:06/30/2020 03/31/2020 06/30/2019
U.S. Treasuries - Coupon 149,366,856$ 179,374,877$ 99,375,096$
U.S. Federal Agencies - Amort - - 6,184,686
U.S. Federal Agencies - Coupon 212,606,573 208,250,234 270,376,599
U.S. Federal Agencies - Callable 9,756,000 15,756,000 15,756,000
Municipal Bonds - Coupon 4,172,413 - 4,000,000
Certificates of Deposit - CDARS - - 25,000,000
Certificates of Deposit - SLOC - - 5,000,000
Commercial Paper - Discount 44,935,633 50,428,264 37,300,779
Local Government Investment Pools 100,855,390 72,355,390 105,804,194
Demand Deposits 2,976,785 26,556,136 2,039,931
Total Book Value 524,669,650$ 552,720,901$ 570,837,285$
Objective:
Current 3 Months Ago 1 Year Ago
Summary By Security Type:06/30/2020 03/31/2020 06/30/2019
U.S. Treasuries - Coupon 28.47%32.45%17.41%
U.S. Federal Agencies - Amort --1.08%
U.S. Federal Agencies - Coupon 40.52%37.69%47.37%
U.S. Federal Agencies - Callable 1.86%2.85%2.76%
Municipal Bonds - Coupon 0.80%-0.70%
Certificates of Deposit - CDARS --4.38%
Certificates of Deposit - SLOC --0.88%
Commercial Paper - Discount 8.56%9.12%6.53%
Local Government Investment Pools 19.22%13.09%18.53%
Demand Deposits 0.57%4.80%0.36%
Total 100.00%100.00%100.00%
CITY OF DENTON : QUARTERLY INVESTMENT REPORT
The portfolio is restricted to U.S. Treasuries and agency securities (maturing in less than five years); state and locally issued Texas municipal bonds rated
AA 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 (maturing in less than270 days);
and local government pools & SEC registered government money market mutual funds (weighted average maturity of less than 60 days).
U.S. Treasuries ‐ Coupon
28.47%
U.S. Federal Agencies ‐
Coupon
40.52%
U.S. Federal Agencies ‐
Callable
1.86%
Commercial Paper ‐
Discount
8.56%
Local Government Investment Pools
19.22%
Municipal Bonds ‐ Coupon
0.80%
Demand Deposits
0.57%
Current06/30/2020
3rd Fiscal Quarter 2020- June 30, 2020 Page 4
INVESTMENT POOL
Current 3 Months Ago 1 Year Ago
Summary By Issuer:06/30/2020 03/31/2020 06/30/2019
AUSTIN TEXAS -$ 6,080,000$ -$
BAYLOR SCOTT 9,998,500 - -
CDARS CDs - - 25,000,000
CORNELL UNIVERSITY - 4,992,000 -
DALLAS, TX WTR & SWR REV BDS - - 4,000,000
FFCB 87,565,946 88,588,436 82,779,293
FHLB 79,551,502 69,402,674 108,984,950
FHLMC 19,998,010 40,979,880 45,785,962
FNMA 35,247,115 25,035,244 54,767,080
INDEPENDENT BANK CDs - - 5,000,000
JP MORGAN SECURITIES LLC 9,966,011 9,925,314 9,923,192
NATIXIS NY BRANCH - - 19,926,197
NESTLE FINANCE INTL LTD - - 4,961,428
NORTHWESTERN UNIVERSITY - 2,490,667 2,489,962
PLANO ISD-BLDG 4,172,413 - -
PRINCETON UNIVERSITY - 7,000,000 -
RBC 4,972,089 4,952,246 -
STATE OF CALIFORNIA 5,000,000 5,000,000 -
TEXPOOL 25,000,000 25,000,000 -
TEXSTAR 75,855,390 47,355,390 80,750,000
TOYOTA MOTOR CREDIT CORP 4,999,033 4,988,038 25,054,194
U.S. TREASURY 149,366,856 179,374,877 99,375,096
UNIVERSITY OF NORTH CAROLINA 10,000,000 5,000,000 -
WELLS FARGO DEMAND DEPOSITS 2,976,785 26,556,136 2,039,931
Total Book Value 524,669,650$ 552,720,901$ 570,837,285$
Objective:
Current 3 Months Ago 1 Year Ago
Summary By Issuer:06/30/2020 03/31/2020 06/30/2019
AUSTIN TEXAS - 1.10%-
BAYLOR SCOTT 1.91%- -
CDARS CDs - - 4.38%
CORNELL UNIVERSITY - 0.90%-
DALLAS, TX WTR & SWR REV BDS - - 0.70%
FFCB 16.69%16.03%14.50%
FHLB 15.16%12.57%19.08%
FHLMC 3.81%7.41%8.02%
FNMA 6.72%4.53%9.59%
INDEPENDENT BANK CDs - - 0.88%
JP MORGAN SECURITIES LLC 1.90%1.80%1.74%
NATIXIS NY BRANCH - - 3.49%
NESTLE FINANCE INTL LTD - - 0.87%
NORTHWESTERN UNIVERSITY - 0.45%0.44%
PLANO ISD-BLDG 0.80%- -
PRINCETON UNIVERSITY - 1.27%-
RBC 0.95%0.90%-
STATE OF CALIFORNIA 0.95%0.90%-
TEXPOOL 4.76%4.52%4.39%
TEXSTAR 14.46%8.57%14.15%
TOYOTA MOTOR CREDIT CORP 0.95%0.90%-
U.S. TREASURY 28.47%32.45%17.41%
UNIVERSITY OF NORTH CAROLINA 1.90%0.90%-
WELLS FARGO DEMAND DEPOSITS 0.57%4.80%0.36%
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.57%
1.90%
0.95%
0.95%
0.95%
1.90%
4.76%
6.72%
3.81%
16.69%
14.46%
15.16%
1.91%
0.80%
28.47%
Current
06/30/2020
WELLS FARGO DEMAND DEPOSITS
JP MORGAN SECURITIES LLC
TOYOTA MOTOR CREDIT CORP
RBC
STATE OF CALIFORNIA
UNIVERSITY OF NORTH CAROLINA
TEXPOOL
FNMA
FHLMC
FFCB
TEXSTAR
FHLB
BAYLOR SCOTT
PLANO ISD‐BLDG
U.S. TREASURY
3rd Fiscal Quarter 2020- June 30, 2020 Page 5
INVESTMENT POOL
Current 3 Months Ago 1 Year Ago
Maturity Time Frame:06/30/2020 03/31/2020 06/30/2019
00-03 Months 193,588,175$ 206,491,526$ 194,544,125$
03-06 Months 35,000,000 64,756,000 40,000,000
06-12 Months 143,025,000 128,945,000 179,000,000
12-24 Months 131,500,000 131,580,000 120,836,000
24 Months & Over 20,000,000 20,000,000 37,500,000
Total Par Value 523,113,175$ 551,772,526$ 571,880,125$
Objective:
Current 3 Months Ago 1 Year Ago
Maturity Time Frame:06/30/2020 03/31/2020 06/30/2019
00-03 Months 37.01%37.42%34.02%
03-06 Months 6.69%11.74%6.99%
06-12 Months 27.34%23.37%31.30%
12-24 Months 25.14%23.85%21.13%
24 Months & Over 3.82%3.62%6.56%
Total 100.00%100.00%100.00%
CITY OF DENTON : QUARTERLY INVESTMENT REPORT
The risk of market price volatility is minimized through maturity diversification. Investment maturities are staggered to provide cash flows basedon
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
Current 3 Months Ago 1 Year Ago
00-06 Months 06-12 Months 12-24 Months 24 Months & Over
3rd Fiscal Quarter 2020- June 30, 2020 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:AvgAvgAvgAvgAvgAvgAvgAvgAvgAvgAvgAvg
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:AvgAvgAvgAvgAvgAvgAvgAvgAvgAvgAvgAvg
Fed Funds (effective)1.30% 1.67% 1.90% 2.15% 2.40% 2.41% 2.37% 1.90% 1.56% 0.02% 0.08%
3-Month U.S. T-Bill 1.32% 1.71% 1.92% 2.20% 2.36% 2.39% 2.09% 1.82% 1.55% 0.09% 0.14%
2-Year U.S. T-Note 1.84% 2.27% 2.53% 2.57% 2.49% 2.26% 2.10% 1.76% 1.57% 0.25% 0.15%
Portfolio Benchmark*1.20% 1.46% 1.75% 2.05% 2.33% 2.48% 2.00% 1.80% 1.55% 0.33% 0.18%
Portfolio Yield 1.29% 1.42% 1.58% 1.73% 2.01% 2.20% 2.20% 2.08% 1.96% 1.62% 1.31%
*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
06/30/2020
2,743,857$ 1,771,206$
12,354,692$ 9,262,499$ 6,122,536$
4,734,315$ 6,999,226$
3,961,973$
2nd Quarter 3rd Quarter 4th Quarter
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 third quarter. In April, there were maturities totaling
$21 million along with $25 million in purchases. In May, there were maturities totaling $57 million with purchases totaling $44
million. During June, seven investments matured totaling $39.5 million and two new investments were purchased totaling $15
million. The portfolio's weighted average yield remains higher than the benchmark 12-month Treasury bill index by 113 basis
points. Portfolio liquidity at the end of June was approximately 19.85%. The COVID-19 pandemic brought unemployment claims
to over 48 million towards the end of June leaving the economic outlook uncertain. The second quarter saw a spike in the
number of coronavirus cases causing the re-opening process to slow significantly. 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
2,138,420$ 8,955,045$
2,982,157$ 5,750,078$ 7,712,197$ -$
4,317,890$ 6,515,166$
2,955,835$
1st Quarter
Fiscal Year 2017-2018 Fiscal Year 2019-2020
0.00%
1.00%
2.00%
3.00%
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 Mar-20 Jun-20
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 June 30, 2020
More than Remaining Encumbered Unencumbered
Departments:0-4YR 5-8YR 9-10YR 10YR Amount Amount Amount
Facilities 23,925,104$ 2,531,689$ -$ -$ 26,456,793$ 7,544,041$ 18,912,752$
Airport 3,414,296 97,360 - - 3,511,656 909,203 2,602,453
Engineering 35,261,645 35,847,713 4,642,897 4,650,903 80,403,158 35,008,036 45,395,122
Development 6,844,469 38,855 - 28,198 6,911,522 775,467 6,136,055
Customer Service 16,781 - - - 16,781 - 16,781
Streets 35,443,155 - - - 35,443,155 8,692,132 26,751,023
Traffic 11,174,094 1,526,951 176,648 16,292 12,893,985 1,301,072 11,592,913
Parks 5,623,083 408,829 3,079,450 - 9,111,362 390,715 8,720,647
Public Arts 605,867 - - - 605,867 98,016 507,851
Water 38,470,168 8,945,603 973,318 - 48,389,089 29,489,650 18,899,439
Wastewater 26,652,860 1,828,719 16,696,447 - 45,178,026 21,923,549 23,254,477
Drainage 4,425,063 289,315 - 28 4,714,406 1,861,693 2,852,713
Solid Waste 13,384,061 - - - 13,384,061 1,334,462 12,049,599
Warehouse 229,006 - - - 229,006 - 229,006
Motor Pool 3,511,484 - - - 3,511,484 1,431,790 2,079,694
Fleet 761,873 - - - 761,873 30,611 731,262
Tech Services 5,016,106 64,428 - - 5,080,534 1,716,967 3,363,567
Electric 61,898,697 17,822,183 84,336 1,073,231 80,878,447 20,047,233 60,831,214
Total City 276,657,812$ 69,401,645$ 25,653,096$ 5,768,652$ 377,481,205$ 132,554,637$ 244,926,568$
|----- ---- ---- ---- ---- Project Age ---- ---- ---- ---- -----|
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
100185XXX CITY BUILDING ADA REPAIRS Total 460,887.27 189,564.43 271,322.84 0.16 271,322.68 2020 0
100194XXX FIRE STATION#3 REBUILD Total 9,403,525.90 6,927,425.78 2,476,100.12 2,400,565.24 75,534.88 2015 5
100198XXX POLICE FIRING RANGE IMPR Total 205,969.00 150,920.70 55,048.30 - 55,048.30 2015 5
100199XXX POLICE REMODEL & RELOCATION Total 315,483.07 314,942.46 540.61 540.61 - 2015 5
100201XXX PARKING LOT ENHANCEMENTS Total 203,950.00 153,703.12 50,246.88 323.52 49,923.36 2020 0
100218XXX FIRE STATION #8 LAND ACQ Total 5,439,724.32 2,244,637.41 3,195,086.91 2,930,904.28 264,182.63 2016 4
100232XXX CITY HALL WEST BUILDING USAGE Total 111,918.35 96,110.61 15,807.74 12,401.19 3,406.55 2017 3
100233XXX AMERICAN LEGION HALL RENOVATIO Total 1,832,241.79 162,382.16 1,669,859.63 88,624.00 1,581,235.63 2017 3
100235XXX MULTI PARKING LOT REPLACEMENT Total 1,100,090.31 550,255.60 549,834.71 112,389.55 437,445.16 2017 3
100248XXX CCNHC TRAIL IMPROVEMENTS Total 324,000.00 197,907.10 126,092.90 - 126,092.90 2018 2
100251XXX 2018 HVAC-FLOORING-ROOFS Total 1,038,731.98 1,015,187.93 23,544.05 34,411.75 (10,867.70) 2018 2
100254XXX 651 MAYHILL BLDG RENOVATION Total 1,626,200.10 330,165.99 1,296,034.11 49,557.04 1,246,477.07 2018 2
100255XXX SERVICE CENTER RENOVATION Total 8,066,261.53 457,896.32 7,608,365.21 108,063.84 7,500,301.37 2018 2
100264XXX BE-14&19 POLICE STATION Total 7,210,349.52 4,272,109.50 2,938,240.02 1,470,694.43 1,467,545.59 2019 1
100266XXX LEGAL REMODEL Total 64,902.41 47,715.53 17,186.88 - 17,186.88 2019 1
100268XXX 2019 HVAC-FLOORING-ROOFS Total 1,195,236.51 - 1,195,236.51 - 1,195,236.51 2019 1
100272XXX CITY HALL WEST RENOVATION Total 336,102.25 453.05 335,649.20 335,565.00 84.20 2020 0
100274XXX DAYBREAK PARKING LOT Total 1,000,000.00 - 1,000,000.00 - 1,000,000.00 2020 0
100276XXX COURTS SECURITY UPGRADES Total 168,378.45 - 168,378.45 - 168,378.45 2020 0
100278XXX LOOP 288 PROPERTY ACQUISITION Total 3,423,000.00 34,888.46 3,388,111.54 - 3,388,111.54 2020 0
109999XXX FACILITIES UNALLOCATED FUNDING Total 76,106.52 - 76,106.52 - 76,106.52 2020 0
Grand Total 43,603,059.28 17,146,266.15 26,456,793.13 7,544,040.61 18,912,752.52
Facilities
City of Denton -Job Cost Summary
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup YearProject Years
200052XXX WEST SIDE PARALLEL RUNWAY Total 2,544,270.00 2,446,910.00 97,360.00 - 97,360.00 2014 6
200061XXX 2017 - AIRPORT MASTER PLAN Total 12,001.47 3,388.00 8,613.47 - 8,613.47 2017 3
200062XXX FY18 PRIMARY RUNWAY & TAXIWAY Total 50,000.00 18,992.00 31,008.00 - 31,008.00 2018 2
200063XXX FY 2018 NORTH TAXIWAY & RUNWAY Total 360,000.00 - 360,000.00 - 360,000.00 2018 2
200065XXX CONTROL TOWER EQUIPMENT 2018 Total 90,000.00 7,500.00 82,500.00 - 82,500.00 2018 2
200070XXX DENTON MED TRANSPORTATION Total 149,300.00 - 149,300.00 - 149,300.00 2018 2
200071XXX AIRPORT PAVEMENT MAINTENANCE Total 1,050,000.00 46,618.08 1,003,381.92 - 1,003,381.92 2019 1
200072XXX TXDOT RNWY LGHTING - WEST SIDE Total 180,160.00 165,000.00 15,160.00 - 15,160.00 2019 1
200073XXX FY19 ARPRT SECURITY ENHANCMENT Total 250,000.00 165,262.53 84,737.47 54,039.40 30,698.07 2019 1
200074XXX FY19 AIRPORT CONF ROOM UPGRADE Total 15,000.00 - 15,000.00 - 15,000.00 2019 1
200075XXX AIRPORT LANDSIDE PAVING Total 1,374,100.00 42,122.57 1,331,977.43 855,163.75 476,813.68 2020 0
209999XXX AIRPORT UNALLOCATED Total 332,618.00 - 332,618.00 - 332,618.00 2020 0
Grand Total 6,407,449.47 2,895,793.18 3,511,656.29 909,203.15 2,602,453.14
City of Denton -Job Cost Summary
Airport
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
250009XXX VINTAGE BLVD (BB TO IH 35W) Total 332,066.47 296,576.03 35,490.44 4,015.51 31,474.93 2013 7
250013XXX CITY-WIDE SW & ADA RAMP SURVEY Total 5,020.58 - 5,020.58 - 5,020.58 2015 5
250021XXX BE14-RUDDELL EXTENSION @ MINGO Total 1,635,794.00 319,029.44 1,316,764.56 0.25 1,316,764.31 2015 5
250022XXX MORSE EXPAN LOOP288-MYHIL Total 600,000.00 312,830.14 287,169.86 179,089.80 108,080.06 2015 5
250023XXX BB PH4 2ND ARTL IH35E-N SCRIP Total 11,213,756.07 9,687,161.67 1,526,594.40 287,137.74 1,239,456.66 2015 5
250028XXX ENG SOFTWARE EQPMT & TNG Total 466,865.00 49,600.00 417,265.00 2,000.00 415,265.00 2015 5
250043XXX HICKORY CREEK FM2181-2499 ENG Total 300,000.00 267,040.51 32,959.49 31,541.76 1,417.73 2016 4
250044XXX HICKORY CREEK FM2181-2499- ROW Total 50,000.00 454,424.37 (404,424.37) - (404,424.37) 2016 4
250045XXX HICKORY CREEK FM2181-2499 CONS Total 2,895,000.00 106,065.87 2,788,934.13 143,387.80 2,645,546.33 2016 4
250046XXX N Texas BLVD ROUNDABOUT-ENG Total 401,029.73 92,477.23 308,552.50 10,786.12 297,766.38 2016 4
250047XXX N TX BLVD ROUNDABOUT-CONSTRUCT Total 1,600,000.00 565.14 1,599,434.86 - 1,599,434.86 2016 4
250063XXX RTR- MCKINNEY (FORMERLY FM426) Total 18,267,303.00 8,546,346.11 9,720,956.89 8,234,333.06 1,486,623.83 2017 3
250073XXX WARSCHUN INTRSECTION&TRUN LANE Total 101,827.91 9,767.82 92,060.09 49.25 92,010.84 2018 2
250075XXX DOWNTOWN TIF PROJECTS Total 1,466,845.00 629,870.15 836,974.85 295,907.16 541,067.69 2018 2
250076XXX BE14&19 BB 2ND ARTERIL UNI-WIN Total 11,486,146.43 1,915,025.69 9,571,120.74 581,008.69 8,990,112.05 2018 2
250077XXX US 380 LIGHTING STUDY Total 75,000.00 74,679.91 320.09 - 320.09 2018 2
250079XXX STANDARD CONSTRUCTION SPEC Total 1,008,800.00 968,008.41 40,791.59 56,768.63 (15,977.04) 2018 2
250080XXX RYAN ROAD THOROUGHFARE PROJECT Total 200,000.00 10,763.05 189,236.95 - 189,236.95 2018 2
250081XXX BE14&19 HICKOR CREEK RD REALI Total 5,200,000.00 1,547,416.12 3,652,583.88 1,884,066.24 1,768,517.64 2019 1
250100XXX EVERS WAY RETAINING WALL SURVE Total 5,710.00 6,230.37 (520.37) - (520.37) 2019 1
250101XXX ENG SOFTWARE RTVISION Total 50,000.00 - 50,000.00 - 50,000.00 2019 1
250102XXX LANDSCAPE REPAIR Total 4,000.00 3,000.00 1,000.00 - 1,000.00 2019 1
250103XXX RAYZOR SOUTH PIPEBURST Total 998,778.00 620,836.62 377,941.38 230,488.53 147,452.85 2019 1
250104XXX FURNITURE FOR DEVELOPMENT STAF Total 44,022.00 10,666.00 33,356.00 19,979.90 13,376.10 2019 1
250106XXX 2018 SIDEWALK CONSTRUCTION Total 1,411,210.09 161,946.66 1,249,263.43 222,384.32 1,026,879.11 2020 0
250107XXX TRAFFIC OFFICE FURNITURE RELOC Total 5,000.00 1,496.00 3,504.00 1,495.34 2,008.66 2020 0
250109XXX MAYHILL MCKINNEY INTERSECTION Total 1,900,000.00 2,908.80 1,897,091.20 - 1,897,091.20 2020 0
250110XXX IT NEXUS MAP Total 26,000.00 12,950.00 13,050.00 - 13,050.00 2020 0
250111XXX FORT WORTH DR UTILITY IMPV Total 3,000,000.00 - 3,000,000.00 - 3,000,000.00 2020 0
250112XXX PLANTE MORAN - PROJECT CONSULT Total 50,000.00 - 50,000.00 45,000.00 5,000.00 2020 0
350044XXX HICKORY CREEK FM2181-RIVERPASS Total 6,269,999.53 1,619,096.17 4,650,903.36 4,636,993.06 13,910.30 2005 15
350045XXX BE14-MISC ROADWAYS Total 1,055,000.00 - 1,055,000.00 - 1,055,000.00 2015 5
350281XXX MAYHILL PHASE 2 RIGHT OF WAY Total 11,600,333.48 11,572,288.78 28,044.70 - 28,044.70 2010 10
350282XXX MAYHILL PHASE 3 UTILITIES Total 521,352.01 521,618.73 (266.72) - (266.72) 2010 10
350283XXX MAYHILL PHASE 4 CONSTRUCTION Total 39,977,436.86 36,941,752.83 3,035,684.03 1,914,954.28 1,120,729.75 2010 10
350285XXX BONNIE BRAE SOUTH ENGINEERING Total 7,906,967.23 7,055,207.15 851,760.08 658,417.57 193,342.51 2010 10
350286XXX BONNIE BR SOUTH RIGHT OF WAY Total 3,098,082.93 3,039,106.77 58,976.16 51,625.83 7,350.33 2010 10
350287XXX BONNIE BRAE SOUTH UTILITIES Total 1,129,282.19 460,583.86 668,698.33 40,747.07 627,951.26 2010 10
350288XXX BONNIE BR SOUTH CONSTRUCTION Total 46,363,646.76 15,159,238.80 31,204,407.96 15,403,570.99 15,800,836.97 2012 8
350462XXX MAYHILL DCTA BRIDGE Total 3,530,000.00 3,383,805.93 146,194.07 72,287.13 73,906.94 2018 2
359000XXX UNALLOCATED - ENGINEERING Total 11,263.92 - 11,263.92 - 11,263.92 2020 0
Grand Total 186,263,539.19 105,860,381.13 80,403,158.06 35,008,036.03 45,395,122.03
City of Denton -Job Cost Summary
Engineering
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
100182XXX ANIM CONTR BLDG-FURN FIXT & EQ Total 158,023.00 157,725.81 297.19 - 297.19 2014 6
100226XXX PUBLIC SAFETY RADIOS Total 2,000,000.00 1,997,702.00 2,298.00 - 2,298.00 2017 3
100228XXX CAD SYSTEM REPLACEMENT Total 2,256,035.00 1,962,049.26 293,985.74 248,765.21 45,220.53 2017 3
100243XXX EXPLOSIVE MAG & EQUIP SECURITY Total 14,000.00 14,262.76 (262.76) - (262.76) 2018 2
300039XXX TIME ENTRY AUTOMATION Total 382,562.17 382,163.45 398.72 - 398.72 2014 6
300047XXX USDN-TX SUSTAINABILITY PROFESS Total 4,997.00 4,105.99 891.01 - 891.01 2015 5
300053XXX TECH DENTON CITY LEASE Total 202,173.26 198,757.86 3,415.40 3,415.40 - 2015 5
300058XXX 83 POLICE OFFICER BODY CAMERAS Total 171,200.00 153,471.32 17,728.68 - 17,728.68 2016 4
300060XXX TASK CHAIRS FOR LBRARY Total 22,000.00 21,774.07 225.93 216.77 9.16 2016 4
300068XXX POLICE PARKING LOT FENCING Total 90,000.00 83,016.29 6,983.71 - 6,983.71 2016 4
300070XXX SMALL AREA PLAN SECTOR 1 SOUTH Total 239,252.00 167,450.28 71,801.72 71,801.72 - 2017 3
300071XXX HISTORIC PRESERVATION PLAN Total 140,000.00 69,284.80 70,715.20 - 70,715.20 2017 3
300073XXX BUDGETING SOFTWARE Total 276,871.00 258,968.64 17,902.36 17,877.56 24.80 2017 3
300077XXX COURTROOM AV EQUIPMENT Total 30,000.00 106.53 29,893.47 - 29,893.47 2018 2
300080XXX MUNI ARCHIVES SUPPLIES & EQPT Total 8,000.00 8,036.33 (36.33) - (36.33) 2018 2
300082XXX SATELLITE WORK STATION Total 6,315.00 - 6,315.00 - 6,315.00 2018 2
300083XXX SRO RESPONSE EQUIPMENT Total 26,718.00 24,468.86 2,249.14 - 2,249.14 2018 2
300084XXX LEGAL CONFERENCE ROOM CHAIRS Total 5,658.00 5,193.04 464.96 464.96 - 2018 2
300085XXX POLICE DEPARTMENT SPACE STUDY Total 44,710.46 - 44,710.46 - 44,710.46 2018 2
300086XXX MUNI COURT CONFENC RM BUILDOUT Total 3,500.00 516.32 2,983.68 - 2,983.68 2018 2
300088XXX AUTOEXTERNAL DEFIBRILLATORS Total 53,888.40 51,937.15 1,951.25 - 1,951.25 2018 2
300091XXX STATION#7 ALERTING SYSTEM Total 71,100.84 69,095.47 2,005.37 - 2,005.37 2018 2
300093XXX WEST OAK PARKING Total 14,500.00 14,244.86 255.14 - 255.14 2019 1
300094XXX NLC COMMUNITY RESILIENCE GRANT Total 10,000.00 - 10,000.00 6,250.00 3,750.00 2019 1
300096XXX SECURITY CAMERAS AT ANIMAL SVC Total 4,500.28 4,480.26 20.02 - 20.02 2019 1
300099XXX DAYBREAK BUILDING Total 10,025,250.00 4,675,361.80 5,349,888.20 290,042.55 5,059,845.65 2019 1
300100XXX FIRE HOSE REPLACEMENT Total 14,000.00 13,832.88 167.12 - 167.12 2019 1
300101XXX EXHAUST FILTERS FIRE ST 5&6 Total 53,000.00 - 53,000.00 43,695.30 9,304.70 2019 1
300102XXX LAND MGMT SOFTWARE-PLANNING Total 482,420.00 13,920.00 468,500.00 71,360.00 397,140.00 2019 1
300104XXX ECO DEV STRATEGIC PLAN Total 164,000.00 130,975.34 33,024.66 17,946.66 15,078.00 2019 1
300105XXX COMPREHENSIVE PLAN UPDATE Total 95,000.00 - 95,000.00 - 95,000.00 2020 0
300106XXX FINANCE OFFICE RENOVATION Total 35,000.00 33,381.50 1,618.50 - 1,618.50 2020 0
300107XXX FURNITURE FOR THE JUDGE'S OFFI Total 41,500.00 41,803.42 (303.42) - (303.42) 2020 0
300108XXX CONSULTANT TO IMPLEM HR ORACLE Total 255,000.00 - 255,000.00 - 255,000.00 2020 0
300109XXX CAMERAS IN LIBRARY Total 12,000.00 10,031.07 1,968.93 3,630.75 (1,661.82) 2020 0
309999XXX UNALLOCATED FINANCE FUNDS Total 4,414.19 - 4,414.19 - 4,414.19 2020 0
400078XXX CLEAR CREEK HERITAGE CENTER Total 272,302.15 244,103.89 28,198.26 - 28,198.26 2006 14
400127XXX WAY FINDING SIGNAGE Total 772,504.25 738,651.88 33,852.37 0.03 33,852.34 2012 8
Grand Total 18,462,395.00 11,550,873.13 6,911,521.87 775,466.91 6,136,054.96
City of Denton -Job Cost Summary
Development
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
870001XXX FY18-19 HARRIS CUSTOMER SERVE 870001750 22,694.00 13,527.78 9,166.22 - 9,166.22 2019
870001XXX FY18-19 HARRIS CUSTOMER SERVE Total 22,694.00 13,527.78 9,166.22 - 9,166.22 2019 1
870002XXX SUPPLY ROOM REMODEL 870002750 15,000.00 7,385.62 7,614.38 - 7,614.38 2019
870002XXX SUPPLY ROOM REMODEL Total 15,000.00 7,385.62 7,614.38 - 7,614.38 2019 1
Grand Total 37,694.00 20,913.40 16,780.60 - 16,780.60
City of Denton -Job Cost Summary
Customer Service
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
350425XXX BE12 - HINKLE DRIVE Total 2,400,842.00 2,318,829.26 82,012.74 57,814.00 24,198.74 2017 3
350433XXX SMITH STREET Total 40,000.00 6,902.61 33,097.39 - 33,097.39 2017 3
350434XXX JOHNSON STREET Total 40,000.00 6,620.21 33,379.79 - 33,379.79 2017 3
350436XXX TRINITY BRIDGE Total 669,762.00 16,680.64 653,081.36 - 653,081.36 2017 3
350457XXX WINDSOR DR (LOCUST -OLD NORTH) Total 2,687,911.00 662,306.95 2,025,604.05 - 2,025,604.05 2018 2
350463XXX HICKORY ST PHV (WELCH-CARROLL) Total 3,296,765.28 445,407.85 2,851,357.43 48,028.25 2,803,329.18 2018 2
350483XXX BE-14 SHERATON RD SID 830, 830 Total 315,167.00 220,167.40 94,999.60 - 94,999.60 2019 1
350495XXX CO 14 2019 ST RECONSTRUCTION Total 5,850,715.00 840,596.82 5,010,118.18 5,005,906.50 4,211.68 2020 0
350496XXX CO 12 2019 ST RECONSTRUCTION Total 2,671,449.61 9,283.70 2,662,165.91 1,932,180.73 729,985.18 2020 0
350497XXX BE14 2019 ST RECONSTRUCTION Total 824,049.48 62,339.35 761,710.13 - 761,710.13 2020 0
350498XXX BE12 2019 ST RECONSTRUCTION Total 9,122.98 - 9,122.98 - 9,122.98 2020 0
350499XXX CO 14 2020 ST RECONSTRUCTION Total 958,127.89 5,914.43 952,213.46 90,703.60 861,509.86 2020 0
350500XXX BE 14 2020 ST RECONSTRUCTION Total 1,247,512.11 8,429.07 1,239,083.04 - 1,239,083.04 2020 0
350501XXX BE 14 KERLEY STREET Total 819,000.00 134,460.26 684,539.74 589,752.37 94,787.37 2020 0
350502XXX BE 14 OUTSOURCE 2&3 BUNDLE Total 1,105,000.00 16,234.28 1,088,765.72 182,500.00 906,265.72 2020 0
350503XXX BE 14 MASCH BRANCH Total 486,315.00 220,004.68 266,310.32 158,107.09 108,203.23 2020 0
350504XXX BE 19 STREET REHAB PROGRAM Total 1,200,000.00 - 1,200,000.00 - 1,200,000.00 2020 0
350505XXX BE12 W HERCULES DR Total 627,139.00 - 627,139.00 627,139.00 - 2020 0
359995XXX BE14-STREET RECONSTRUCTION Total 14,357,920.77 - 14,357,920.77 - 14,357,920.77 2020 0
359996XXX GAS WELL- RDAP UNALLOCATED Total 386,738.02 - 386,738.02 - 386,738.02 2020 0
359999XXX UNALLOCATED STREETS IMPRV FUND Total 423,795.32 - 423,795.32 - 423,795.32 2020 0
Grand Total 40,417,332.46 4,974,177.51 35,443,154.95 8,692,131.54 26,751,023.41
City of Denton -Job Cost Summary
Streets
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
250019XXX OAK/HICKORY BIKE ACCOMMODATION Total 220,000.00 156,841.38 63,158.62 5,868.89 57,289.73 2015 5
250025XXX DCTA BIKE HIKE TRAIL Total 70,000.00 46,424.17 23,575.83 - 23,575.83 2015 5
250058XXX BE14 - EAST SIDE STUART RD SW Total 245,000.00 11,896.12 233,103.88 - 233,103.88 2017 3
250061XXX 2017 MISC. BIKELANES STRIPING Total 39,677.53 39,726.64 (49.11) (0.05) (49.06) 2017 3
250065XXX BICYCLES WAYFINDING SIGNS Total 8,348.49 360.26 7,988.23 - 7,988.23 2017 3
250067XXX AVE A BIKE (COLLINS-HIGHLAND) Total 25,688.66 - 25,688.66 - 25,688.66 2017 3
250090XXX BE14-POCKRUS PAGE RD Total 86,501.00 86,080.05 420.95 - 420.95 2019 1
259998XXX UNALLOCATED BIKE FUND Total 82,020.00 - 82,020.00 - 82,020.00 2020 0
300037XXX HICKORY ST. RAILROAD IMPRV Total 525,905.00 88,523.63 437,381.37 4,495.92 432,885.45 2013 7
310001XXX RAIL QUIET ZONE MKNNY-PRR Total 541,310.00 - 541,310.00 - 541,310.00 2015 5
310004XXX MCKINNEY SWALK DIVEWAY- AUSTIN Total 85,000.00 77,466.31 7,533.69 - 7,533.69 2017 3
310005XXX PARKWAY SIDEWALK ELM- LOCUST Total 122,000.00 28,823.71 93,176.29 - 93,176.29 2017 3
350167XXX ELAP - SIGNALIZATION TIMING Total 206,701.75 190,410.00 16,291.75 - 16,291.75 2007 13
360100XXX ITS COMM TRUNK LINES-TXDOT Total 2,164,500.00 1,987,851.96 176,648.04 101,066.18 75,581.86 2011 9
360118XXX COLORADO/MEDPARK TRAFFIC SIG Total 16,580.00 - 16,580.00 - 16,580.00 2013 7
360119XXX BELL AND SHERMAN SIGNAL Total 556,848.40 111,902.95 444,945.45 - 444,945.45 2014 6
360140XXX US-380/WESTERN BLVD SIGNAL Total 397,522.37 396,856.52 665.85 - 665.85 2017 3
360141XXX OAK & JAGOE TRAFFIC SIGNAL Total 373,941.72 307,418.85 66,522.87 41,031.40 25,491.47 2016 4
360142XXX BELL & MINGO SIGNAL Total 423,192.70 46,650.00 376,542.70 - 376,542.70 2017 3
360143XXX BE14 - BELL & EAGLE SIGNAL Total 100,000.00 11,125.00 88,875.00 10,375.00 78,500.00 2017 3
360148XXX IH35E & LILLIAN MILLER SIGNAL Total 53,865.00 - 53,865.00 - 53,865.00 2017 3
360156XXX EAGLE CORRIDOR IMPROVEMENTS Total 46,119.61 16,630.08 29,489.53 - 29,489.53 2018 2
360158XXX SHORT-TERM TRAFFIC IMPROVEMENT Total 2,120,000.00 1,413,799.79 706,200.21 317,280.13 388,920.08 2018 2
360159XXX CMAQ SIDEWALKS Total 100,284.00 1,644.00 98,640.00 - 98,640.00 2018 2
360161XXX 2018 SIDEWALK SEGMENTS DESIGN Total 432,000.00 423,184.79 8,815.21 89,536.01 (80,720.80) 2018 2
360162XXX SHERMAN SW (BOLIVAR TO ELM) Total 25,000.00 3,208.46 21,791.54 21,881.08 (89.54) 2018 2
360164XXX SIGNAL SPECIFICATION DEVELOPMT Total 10,000.00 9,150.00 850.00 - 850.00 2018 2
360165XXX 2019 SIDEWALK SEGMENTS DESIGN Total 281,492.81 201,675.01 79,817.80 70,800.00 9,017.80 2018 2
360166XXX FY18-19 SMALL TRANS PROJECTS Total 2,950,000.00 419,860.54 2,530,139.46 80,267.03 2,449,872.43 2018 2
360168XXX SYCAMORE/WELCH BIKE&PEDESTRIAN Total 190,627.00 4,331.00 186,296.00 - 186,296.00 2019 1
360169XXX INS SIGN STRIP HICKORY CREEK Total 40,000.00 29,435.00 10,565.00 - 10,565.00 2019 1
360170XXX TRAFFIC CALMING MEASURES Total 58,567.46 40,487.23 18,080.23 - 18,080.23 2019 1
360171XXX UNT I-35E SPECIAL EVENTS AGREE Total 60,000.00 53,082.60 6,917.40 - 6,917.40 2019 1
360173XXX TRAFFIC WARRANT STUDIES Total 35,000.00 15,916.03 19,083.97 14,083.97 5,000.00 2019 1
360174XXX HICKORY CREEK & MONTECIT SIGNA Total 341,690.49 169,228.78 172,461.71 - 172,461.71 2019 1
360175XXX MOBILITY PLAN Total 538,330.00 327,778.00 210,552.00 209,522.00 1,030.00 2019 1
360176XXX US-380/HERITAGE SIGNAL Total 108,664.17 21,506.25 87,157.92 14,337.50 72,820.42 2019 1
360180XXX RAIL QUIET ZONE UNION PACIFIC Total 930,000.00 - 930,000.00 - 930,000.00 2019 1
360181XXX WAZE DATA SHARING NCTCOG Total 5,000.00 - 5,000.00 - 5,000.00 2019 1
360182XXX TXDOT IH35 E FR&BRINKER SIGNAL Total 205,000.00 258,657.80 (53,657.80) 17,751.10 (71,408.90) 2020 0
360185XXX TWU TRAFFIC STUDY Total 140,000.00 15,212.00 124,788.00 124,788.00 - 2020 0
360186XXX BE 19 SIDEWALKS Total 820,967.00 - 820,967.00 - 820,967.00 2020 0
360188XXX 2019 INTERSECTION SHERMAN&L288 Total 300,000.00 7,352.94 292,647.06 - 292,647.06 2020 0
360189XXX BE19 SIDEWALK STUDY NEAR SCHOO Total 50,000.00 20,000.00 30,000.00 - 30,000.00 2020 0
City of Denton -Job Cost Summary
Traffic
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
City of Denton -Job Cost Summary
Traffic
360190XXX US 380 SW (MAYHILL- NATURE PK) Total 211,800.00 - 211,800.00 - 211,800.00 2020 0
369997XXX BE 14 STREET FUNDS FOR TRAFFIC Total 1,241,500.00 64,758.36 1,176,741.64 33,633.14 1,143,108.50 2020 0
921701XXX SAFETY FUND - OAK & FRY SIGNAL Total 383,400.00 315,413.35 67,986.65 - 67,986.65 2017 3
921702XXX SAFETY FUND - ADA PROWAG IMPV Total 168,064.00 113,055.68 55,008.32 - 55,008.32 2017 3
921705XXX PEDESTRIAN & BICYCLE SAFETY Total 7,000.00 - 7,000.00 - 7,000.00 2017 3
921706XXX BUS STOP IMPROVEMENTS Total 15,000.00 300.00 14,700.00 - 14,700.00 2017 3
921707XXX DOWNTOWN SIDEWALK IMPROVEMENTS Total 145,000.00 15,422.81 129,577.19 23,000.00 106,577.19 2017 3
921710XXX SHERMAN@WINSOR TRAFFIC SIGNAL Total 400,000.00 70,298.50 329,701.50 - 329,701.50 2018 2
921711XXX LOCUST@WINSOR TRAFFIC SIGNAL Total 400,000.00 45,200.00 354,800.00 - 354,800.00 2018 2
921712XXX MCKINNEY@WOODROW TRAFFIC SIG Total 400,000.00 121,338.61 278,661.39 16,598.50 262,062.89 2018 2
921713XXX CITYWIDE SPEED STUDY Total 80,000.00 - 80,000.00 - 80,000.00 2019 1
921714XXX IH35E FR & FM 2181 SIGNAL Total 90,000.00 45,608.91 44,391.09 3,902.20 40,488.89 2019 1
921715XXX LOOP 288 & MCKINNEY SIGNAL Total 55,000.00 5,649.98 49,350.02 20,567.70 28,782.32 2019 1
921716XXX LOOP 288 & KINGS ROW SIGNAL Total 65,000.00 20,871.91 44,128.09 27,153.19 16,974.90 2019 1
921717XXX LOOP 288 & US 380 SIGNAL Total 80,000.00 9,480.03 70,519.97 39,022.00 31,497.97 2019 1
921718XXX FM 426 & MOCKINGBIRD SIGNAL Total 65,000.00 50,959.19 14,040.81 14,110.88 (70.07) 2019 1
921719XXX TRAFFIC STRIPING TRUCK Total 150,000.00 148,979.03 1,020.97 - 1,020.97 2020 0
921720XXX TRAFFIC SIGNALS Total 700,000.00 - 700,000.00 - 700,000.00 2020 0
921721XXX TRAFFIC CALMING Total 200,000.00 28,289.60 171,710.40 - 171,710.40 2020 0
Grand Total 20,990,109.16 8,096,123.81 12,893,985.35 1,301,071.77 11,592,913.58
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
400112XXX EMERGECY ACT PLAN LAKE FOREST Total 3,448,902.27 369,452.27 3,079,450.00 79,450.00 3,000,000.00 2010 10
400145XXX Dog Park @ HWY 77 & HINKLE Total 553,240.53 531,988.04 21,252.49 4,624.00 16,628.49 2014 6
400171XXX VELA SOCCER COMPLEX PHII Total 6,471,486.98 6,338,865.54 132,621.44 - 132,621.44 2015 5
400173XXX PLAYGROUND REPLACEMENTS Total 850,483.21 595,527.92 254,955.29 - 254,955.29 2015 5
400193XXX LOON LAKE TRAIL Total 63,352.00 17,870.38 45,481.62 18.40 45,463.22 2016 4
400232XXX SKATE PARK AMENITY Total 60,000.00 - 60,000.00 - 60,000.00 2018 2
400233XXX FITNESS EQUIPMENT REPLACEMENT Total 40,928.00 15,927.70 25,000.30 - 25,000.30 2018 2
400242XXX CARL YOUNG PARK RESTROOM ADDT Total 99,026.18 54,377.23 44,648.95 14,863.90 29,785.05 2018 2
400243XXX QUAKERTOWN PARK RESTROOM Total 152,000.00 68,562.44 83,437.56 19,810.91 63,626.65 2018 2
400246XXX SOUTH LAKES PARK IMPROVEMENT Total 303,943.71 4,814.65 299,129.06 - 299,129.06 2018 2
400247XXX TENNIS CENTER REMODEL&DEVL Total 3,709,197.34 207,825.08 3,501,372.26 (29,643.76) 3,531,016.02 2018 2
400248XXX SOUTH LAKES PARKING LOT Total 291,484.41 32,770.00 258,714.41 16,821.00 241,893.41 2018 2
400252XXX EAGLE-ELM BEAUTIFICATION NODE Total 119,534.02 39,181.52 80,352.50 6,000.00 74,352.50 2018 2
400254XXX SW PARK MASTER PLAN AND DESIGN Total 685,000.00 25,039.28 659,960.72 198,800.00 461,160.72 2019 1
400255XXX DENIA AND NL REC CABINET Total 21,115.27 - 21,115.27 - 21,115.27 2019 1
400256XXX PARD 2019 MASTER PLAN Total 107,887.41 27,378.99 80,508.42 7,750.00 72,758.42 2019 1
400258XXX CARNEGIE RIDGE PROPERTY Total 231,660.00 162,532.82 69,127.18 11,656.29 57,470.89 2019 1
400270XXX LEISURE SERVICES FURNITURE Total 27,083.40 7,125.05 19,958.35 - 19,958.35 2019 1
400274XXX MCKENNA PARK IMPROVEMENTS Total 15,000.00 8,908.53 6,091.47 - 6,091.47 2019 1
400275XXX HWY 2499 GREEN RIBBON DESIGN Total 19,575.00 10,800.00 8,775.00 8,775.00 - 2019 1
400284XXX WELCH PROPERTY Total 8,000.00 - 8,000.00 - 8,000.00 2020 0
400285XXX CITY HALL SIGNAGE Total 15,193.62 550.00 14,643.62 6,988.24 7,655.38 2020 0
400287XXX 24 SCOREBOARDS REPLACEMENT Total 143,726.00 136,155.90 7,570.10 1,495.45 6,074.65 2020 0
400288XXX NLDR TEE BOX REPLACEMENT Total 16,000.00 - 16,000.00 - 16,000.00 2020 0
400289XXX NATATORIUM LEISURE POOL PLASTE Total 32,848.00 - 32,848.00 32,848.00 - 2020 0
400290XXX BOWLING GREEN PARK IMPROVEMENT Total 114,127.20 - 114,127.20 - 114,127.20 2020 0
400291XXX CCP RESTROOM FLOOR REPLACEMENT Total 10,458.00 - 10,458.00 10,458.00 - 2020 0
400292XXX AUDRA PROPERTY ACQUISITION Total 70,000.00 - 70,000.00 - 70,000.00 2020 0
400294XXX VILLAGES OF CARMEL MP & DESIGN Total 75,000.00 - 75,000.00 - 75,000.00 2020 0
409999XXX UNALLOCATED PARKS FUNDS Total 10,763.14 - 10,763.14 - 10,763.14 2020 0
Grand Total 17,767,015.69 8,655,653.34 9,111,362.35 390,715.43 8,720,646.92
City of Denton -Job Cost Summary
Parks
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
300075XXX PD LOBBY BRICK SCULPTURES Total 54,300.00 26,969.39 27,330.61 28,330.61 (1,000.00) 2018 2
400188XXX STATE BRINKER MEDALLIONS Total 200,000.00 - 200,000.00 - 200,000.00 2016 4
400249XXX BE12-LOOP 288 BRDG. MEDALLIONS Total 28,300.00 20,615.00 7,685.00 7,685.00 - 2018 2
400276XXX N LAKE TENNIS ART SCUPLTURE Total 35,000.00 - 35,000.00 - 35,000.00 2019 1
400277XXX N LAKE DOG PARK SCULPTURE Total 35,000.00 - 35,000.00 - 35,000.00 2019 1
400278XXX VELA ATHLETIC SCULPTURE Total 32,712.39 - 32,712.39 - 32,712.39 2019 1
450001XXX MLK PUBLIC ART CMTE ART PIECE Total 70,252.00 7,046.50 63,205.50 62,000.00 1,205.50 2018 2
450002XXX PARKS PUBLIC ART Total 20,000.00 - 20,000.00 - 20,000.00 2019 1
450003XXX HOT PY19 PUBLIC ART C DENTON Total 18,477.00 - 18,477.00 - 18,477.00 2019 1
450004XXX PUBLIC ART FOR STREET IMPROVE Total 30,000.00 - 30,000.00 - 30,000.00 2020 0
459997XXX TRANSPORTATION-PUB ART UNALLOC Total 74,087.87 - 74,087.87 - 74,087.87 2020 0
459998XXX PUBLIC SAFETY-PUBLI ART UNALLO Total 62,298.94 - 62,298.94 - 62,298.94 2020 0
459999XXX PARKS - PUBLIC ART UNALLOCATED Total 69.19 - 69.19 - 69.19 2020 0
Grand Total 660,497.39 54,630.89 605,866.50 98,015.61 507,850.89
City of Denton -Job Cost Summary
Public Arts
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
630081XXX TEASLEY FM 2181 TXDOT Total 3,737,674.12 2,764,355.85 973,318.27 190,692.01 782,626.26 2010 10
630088XXX TANK PAINTING Total 3,599,961.59 2,947,695.32 652,266.27 - 652,266.27 2020 0
630240XXX CCNHC MAINT / HUNTING PERMITS Total 53,983.38 21,196.06 32,787.32 - 32,787.32 2020 0
630248XXX SERVICE CENTER FS MAINTENANCE Total 136,882.00 53,036.63 83,845.37 - 83,845.37 2020 0
630264XXX FT WORTH DR RELOCATE I-35E Total 3,011,903.45 2,948,815.85 63,087.60 6,411.10 56,676.50 2014 6
630282XXX NORTH/SOUTH WTR MAIN, PH2 Total 13,859,973.00 7,005,022.63 6,854,950.37 5,812,191.18 1,042,759.19 2012 8
630285XXX ELM ST Total 1,825,835.00 1,354,761.63 471,073.37 17,343.80 453,729.57 2012 8
630287XXX FY 2012 LOCUST PH 1 Total 1,367,168.00 246,090.17 1,121,077.83 1,082,013.80 39,064.03 2012 8
630314XXX CLEAR CREEK SLOPE MAINTENANCE Total 430,079.00 - 430,079.00 - 430,079.00 2014 6
630341XXX BUDGET SOFTWARE Total 69,600.00 64,265.04 5,334.96 - 5,334.96 2015 5
630344XXX LLWTP UPGRADE PHASE II Total 17,640,000.00 4,078,700.28 13,561,299.72 13,508,760.98 52,538.74 2016 4
630347XXX BONNIE BRAE-I-35 TO SCRIPTURE Total 90,000.00 1,296.20 88,703.80 - 88,703.80 2016 4
630348XXX BONNIE BRAE-SCRIPTURE TO 380 Total 60,000.00 2,743.97 57,256.03 - 57,256.03 2016 4
630349XXX MORSE ST WATER RELOCATION Total 170,000.00 38,036.69 131,963.31 1,313.31 130,650.00 2016 4
630350XXX RUDDELL@MINGO UTILITY RELOCATE Total 90,000.00 - 90,000.00 - 90,000.00 2016 4
630351XXX MCKINNEY TRANSMISSION LINE Total 2,315,000.00 - 2,315,000.00 - 2,315,000.00 2016 4
630353XXX SCRIPTURE TO I-35 TRANS LINE Total 785,000.00 171,138.42 613,861.58 46,339.96 567,521.62 2016 4
630356XXX HWY 380-I-35 TRANSMISSION LINE Total 1,790,000.00 308,366.45 1,481,633.55 16,147.75 1,465,485.80 2016 4
630357XXX FY17 FSRP HICKORY Total 1,266,026.71 1,266,064.72 (38.01) - (38.01) 2016 4
630364XXX UPDATE WATER DIST MASTER PLAN Total 215,000.00 220,834.35 (5,834.35) 17,465.65 (23,300.00) 2016 4
630373XXX FY '17 FSRP JOHNSON II Total 105,632.95 105,379.89 253.06 212.64 40.42 2017 3
630376XXX FY '17 FSRP FOXCROFT Total 645,553.70 195,749.57 449,804.13 30,099.05 419,705.08 2017 3
630378XXX FY 18 FSRP JOHNSON-N OF DALLAS Total 10,000.00 3,892.68 6,107.32 - 6,107.32 2017 3
630381XXX SW AREA CHLORAMINATION BOOSTER Total 227,529.09 201,658.43 25,870.66 - 25,870.66 2017 3
630385XXX ALLRED-JOHN PAINE RD TRAN LINE Total 6,584,210.92 5,582,268.90 1,001,942.02 501,719.48 500,222.54 2017 3
630387XXX LLWTP SOLIDS HANDLING Total 8,741,000.00 4,354,857.25 4,386,142.75 4,656,004.74 (269,861.99) 2017 3
630390XXX LAKE LEWISVILLE DAM SAFETY MOD Total 150,000.00 - 150,000.00 - 150,000.00 2017 3
630391XXX BONNIE BRAE 380 TO WINDSOR Total 60,000.00 43,372.08 16,627.92 - 16,627.92 2017 3
630400XXX CHLORINE SCRUBBER TANK REPAIR Total 154,276.09 169,276.09 (15,000.00) - (15,000.00) 2018 2
630402XXX FY18 FSRP KERLEY Total 267,919.00 265,128.91 2,790.09 - 2,790.09 2018 2
630403XXX FY18 FSRP HOLLY HILL Total 197,700.00 145,074.47 52,625.53 10,941.00 41,684.53 2018 2
630404XXX FY19 FSRP HERCULES Total 570,601.00 569,494.88 1,106.12 - 1,106.12 2018 2
630405XXX FY19 FSRP ATLAS Total 184,930.70 184,945.92 (15.22) - (15.22) 2018 2
630407XXX FY19 FSRP ROYAL MISTYWOOD Total 280,218.00 274,230.67 5,987.33 7,717.49 (1,730.16) 2018 2
630409XXX RRWTP REG/PERFORMANCE UPGRADE Total 1,699,411.00 224,411.00 1,475,000.00 - 1,475,000.00 2018 2
630412XXX FY 2019 WATER TAPS INSTALLED Total 358,328.73 368,893.30 (10,564.57) 43,780.61 (54,345.18) 2019 1
630413XXX FY 2019 FIRE HYDRANT INSTALLS Total 55,149.70 23,467.14 31,682.56 33,484.71 (1,802.15) 2019 1
630417XXX HERCULES WL OVERSIZE Total 50,000.00 - 50,000.00 - 50,000.00 2019 1
630418XXX CHE LOBBY GLASS REPLACEMENT Total 50,000.00 29,667.81 20,332.19 - 20,332.19 2018 2
630419XXX WATER DISTRIBUTION ASSET MGMT Total 250,000.00 210,150.37 39,849.63 5,049.63 34,800.00 2018 2
630420XXX FY20 FSRP WESTGATE HEIGHTS Total 50,000.00 358.33 49,641.67 - 49,641.67 2019 1
630422XXX FY19 FSRP NORTHWOOD PLACE WATR Total 94,422.00 91,548.24 2,873.76 204.00 2,669.76 2019 1
630423XXX FY19 FSRP PRECISION WATER PROJ Total 31,920.00 11,078.23 20,841.77 - 20,841.77 2019 1
630424XXX FY20 FSRP WOODLAND/CHERYWD WTR Total 255,879.00 57,774.54 198,104.46 11,302.00 186,802.46 2019 1
City of Denton -Job Cost Summary
Water
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
City of Denton -Job Cost Summary
Water
630425XXX FY20 FSRP ORR WATER Total 120,577.23 106,750.42 13,826.81 6,309.57 7,517.24 2019 1
630428XXX FSRP QUAIL RIDGE WATER Total 127,633.68 127,962.97 (329.29) - (329.29) 2019 1
630429XXX RISK ASMT&EMERG RESPONSE PLAN Total 356,750.00 115,631.01 241,118.99 59,988.99 181,130.00 2019 1
630430XXX WATER 2019 RATE STUDY Total 54,400.00 48,107.78 6,292.22 6,127.22 165.00 2019 1
630431XXX FY20 FSRP Ave B Water Total 227,347.00 157,492.26 69,854.74 14,128.48 55,726.26 2019 1
630432XXX FY20 FSRP WEST MULBERRY WATER Total 15,000.00 16,223.22 (1,223.22) - (1,223.22) 2019 1
630433XXX DESIGN - RRWTP 500HP VFD Total 25,000.00 22,639.40 2,360.60 1,240.60 1,120.00 2019 1
630434XXX 300' REPLACEMENT MAIN-SCRIPTUR Total 65,000.00 41,405.90 23,594.10 - 23,594.10 2019 1
630435XXX FY 2020 WATER METERS Total 1,092,738.87 705,152.64 387,586.23 - 387,586.23 2019 1
630436XXX FY 2020 WATER TAPS INSTALLED Total 273,306.21 183,163.69 90,142.52 23,482.95 66,659.57 2020 0
630437XXX FY 2020 FIRE HYDRANT INSTALLS Total 51,806.20 493.98 51,312.22 25,000.00 26,312.22 2020 0
630438XXX REHAB RRWTP HIGH SRV PUMP STAN Total 440,000.00 275,035.61 164,964.39 - 164,964.39 2020 0
630439XXX RINEY RD BPS&NW TRANS. LINES Total 1,398,600.00 197,537.68 1,201,062.32 1,201,725.00 (662.68) 2020 0
630440XXX TX DOT I35 RELOCATION Total 2,723,023.00 186,724.25 2,536,298.75 406,075.75 2,130,223.00 2020 0
630441XXX FY 20 STREET BUNDLING-DESIGN Total 252,079.00 4,340.72 247,738.28 - 247,738.28 2020 0
630442XXX FY 19 STREET BUNDLING-WINSOR Total 1,426,535.00 99,982.00 1,326,553.00 1,326,553.00 - 2020 0
630444XXX FSRP - FY 19-20 FANNIN Total 10,272.00 6,830.56 3,441.44 - 3,441.44 2020 0
630445XXX FSRP - FY 19-20 WEST OAK Total 24,720.00 12,324.89 12,395.11 - 12,395.11 2020 0
630446XXX FSRP - FY 19-20 AMHERST Total 7,680.00 9,785.26 (2,105.26) - (2,105.26) 2020 0
630447XXX FSRP - FY 19-20 BELL AVE Total 62,500.00 37,675.17 24,824.83 - 24,824.83 2020 0
630448XXX WATER DIST. EQUIPMENT Total 26,000.00 26,889.11 (889.11) - (889.11) 2020 0
630449XXX Westray OPA Total 138,000.00 137,758.00 242.00 - 242.00 2020 0
630450XXX ANLZS LL&RR RAW WATER CHEMICAL Total 50,000.00 21,461.94 28,538.06 - 28,538.06 2020 0
630451XXX BLUE BEACON - OPA Total 30,000.00 28,443.48 1,556.52 - 1,556.52 2020 0
630452XXX ELM & LOCUST PHASE II Total 950,000.00 3,788.85 946,211.15 - 946,211.15 2020 0
630453XXX LRRWTP SCADA AND NETWORK UPGRA Total 297,000.00 - 297,000.00 136,428.55 160,571.45 2020 0
630454XXX LLWTP STORAGE SHED EXTENSION Total 70,000.00 - 70,000.00 10,296.25 59,703.75 2020 0
630455XXX LL PRELIM TRANSMISSION STUDYII Total 150,000.00 - 150,000.00 - 150,000.00 2020 0
630456XXX LL TRANS PIPELINE ASSESSMNT II Total 600,000.00 - 600,000.00 - 600,000.00 2020 0
630996XXX UNALLOCATED BOND FUNDS Total 20,021.10 - 20,021.10 - 20,021.10 2020 0
635108XXX WP1925 3/4 TON w/UTILITY BED Total 47,000.00 11,625.05 35,374.95 27,298.60 8,076.35 2019 1
635109XXX WP1989 TRAILER (DUMP) Total 7,500.00 - 7,500.00 - 7,500.00 2019 1
635110XXX WD1962 DUMP TRUCK 14 YD GREEN Total 152,000.00 152,712.93 (712.93) - (712.93) 2019 1
635111XXX WD1963 2 T w/VERMEER BODY Total 140,000.00 136,301.75 3,698.25 - 3,698.25 2019 1
635117XXX WD19134-CX80C CASE EXCAVATOR Total 113,000.00 - 113,000.00 113,000.00 - 2020 0
635118XXX WD19137CX145 MSR CASE EXCAVATR Total 132,800.00 - 132,800.00 132,800.00 - 2020 0
635119XXX WM2068 - 1 TON MAINT. TRUCK Total 45,000.00 - 45,000.00 - 45,000.00 2020 0
635120XXX WD2051 -MAINT. TRUCK Total 140,000.00 80,939.83 59,060.17 - 59,060.17 2020 0
635121XXX CC20121 - ATV Total 13,000.00 - 13,000.00 - 13,000.00 2020 0
635122XXX WP2069 - CREW CAB UTILITY BED Total 65,000.00 - 65,000.00 - 65,000.00 2020 0
635123XXX WP2070 - 3/4 TON PICK PICK UP Total 32,000.00 - 32,000.00 - 32,000.00 2020 0
635126XXX WD - 20122 - VACUUM EXCAVATOR Total 80,000.00 - 80,000.00 - 80,000.00 2020 0
635127XXX WM2063 - 2 TON Total 65,000.00 - 65,000.00 - 65,000.00 2020 0
635128XXX WM2064 - 2 TON W CRANE Total 75,000.00 - 75,000.00 - 75,000.00 2020 0
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
City of Denton -Job Cost Summary
Water
635129XXX WD20120 EXCAVATOR W/ATTACHMENT Total 130,000.00 - 130,000.00 - 130,000.00 2020 0
635130XXX WD20119 TRAILER Total 20,000.00 - 20,000.00 - 20,000.00 2020 0
635131XXX WD20118 LIGHT TOWER Total 15,000.00 - 15,000.00 - 15,000.00 2020 0
635996XXX UNALLOCATED FUNDS Total 2,002,311.58 - 2,002,311.58 - 2,002,311.58 2020 0
Grand Total 87,949,369.00 39,560,279.31 48,389,089.69 29,489,649.85 18,899,439.84
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
640052XXX TEASLEY FM 2181 TXDOT Total 3,312,358.25 2,459,867.80 852,490.45 76,073.58 776,416.87 2010 10
640111XXX ASSET MANAGEMENT PROGRAM Total 489,235.89 226,171.26 263,064.63 - 263,064.63 2020 0
640137XXX WW LAB RENOVATIONS Total 400,049.00 64,060.15 335,988.85 172,260.00 163,728.85 2020 0
640160XXX ELM ST Total 1,656,117.00 937,269.40 718,847.60 491,972.93 226,874.67 2010 10
640162XXX LOCUST ST Total 2,358,286.50 2,192,895.81 165,390.69 17,343.80 148,046.89 2010 10
640163XXX HICKORY CR. DETENTION FACILITY Total 15,629,893.72 670,175.44 14,959,718.28 14,458,000.00 501,718.28 2010 10
640175XXX HOBSON GENSET & UPGRADE Total 323,341.55 78,604.00 244,737.55 - 244,737.55 2013 7
640193XXX PRIVATE LATERALS REPLACEMENT Total 149,695.00 108,072.91 41,622.09 9,801.25 31,820.84 2020 0
640213XXX FT WORTH DR RELOCATE I-35E Total 2,929,093.34 2,854,460.01 74,633.33 20,659.64 53,973.69 2015 5
640219XXX FY 12 DRY FORK HC TRIBUTARY I Total 1,442,985.59 310,178.38 1,132,807.21 22,262.55 1,110,544.66 2012 8
640248XXX WW LAB LIMS PURCHASE Total 168,698.00 114,349.20 54,348.80 35,400.00 18,948.80 2014 6
640265XXX GENSET FOR COOPER CREEK LS Total 90,000.00 - 90,000.00 - 90,000.00 2014 6
640271XXX DENTON WEST LS UPGRADE Total 716,380.04 722,970.75 (6,590.71) 22,242.11 (28,832.82) 2014 6
640286XXX WEST WET WEATHER STORAGE FAC Total 864,993.27 653,936.89 211,056.38 211,055.24 1.14 2015 5
640289XXX REUSE MCC REPLACEMENT Total 25,000.00 - 25,000.00 - 25,000.00 2015 5
640291XXX RAPID AMMONIA ANALYZER Total 20,000.00 17,273.79 2,726.21 - 2,726.21 2015 5
640296XXX BONNIE BRAE-I-35 TO SCRIPTURE Total 40,000.00 744.15 39,255.85 - 39,255.85 2016 4
640297XXX BONNIE BRAE-SCRIPTURE TO 380 Total 25,000.00 - 25,000.00 - 25,000.00 2016 4
640298XXX RUDDELL@MINGO UTILITY RELOCATE Total 275,000.00 - 275,000.00 - 275,000.00 2016 4
640300XXX HICKORY CREEK INTERCEPTOR I Total 3,180,049.23 180,049.23 3,000,000.00 - 3,000,000.00 2016 4
640301XXX HICKORY CREEK INTERCEPTOR II Total 7,941,766.67 604,611.52 7,337,155.15 134,228.21 7,202,926.94 2016 4
640306XXX FY '16 WEST HICKORY FSRP Total 485,630.65 484,180.78 1,449.87 1,626.37 (176.50) 2016 4
640311XXX FY '17 HILL ALLEY FSRP Total 12,447.00 6,539.62 5,907.38 - 5,907.38 2016 4
640312XXX FY '17 HOLLYHILL FSRP Total 27,984.50 27,367.48 617.02 - 617.02 2016 4
640313XXX FY '17 FOXCROFT FSRP Total 609,703.00 230,144.53 379,558.47 53,946.66 325,611.81 2016 4
640316XXX FY '17 KERLEY FSRP Total 454,337.35 455,634.01 (1,296.66) 21,961.25 (23,257.91) 2016 4
640319XXX FY '17 EMERSON FSRP Total 65,600.00 57,338.08 8,261.92 - 8,261.92 2016 4
640320XXX FY '17 DALLAS FSRP Total 15,000.00 12,865.41 2,134.59 - 2,134.59 2016 4
640323XXX EASEMENT MAINTENANCE Total 75,000.00 30,063.96 44,936.04 10,546.39 34,389.65 2020 0
640325XXX MANHOLE REPAIR/REPLACEMENT Total 313,878.51 253,606.06 60,272.45 13,013.44 47,259.01 2020 0
640326XXX FY '16 NORTH BELL ST Total 2,851.19 2,597.44 253.75 - 253.75 2016 4
640331XXX FLUSHING TRUCK BAYS Total 368,000.00 25,724.00 342,276.00 4,491.00 337,785.00 2016 4
640332XXX WAYNE RYAN LS ABANDONMENT Total 33,566.00 - 33,566.00 33,566.00 - 2016 4
640336XXX HICKORY CREEK LS UPGRADE Total 3,426,700.00 877,327.12 2,549,372.88 2,585,466.90 (36,094.02) 2016 4
640345XXX LAND PURCHASE Total 936,502.97 - 936,502.97 - 936,502.97 2017 3
640346XXX BARROW GRAVITY MAIN REPLACEMEN Total 217,210.00 62,148.12 155,061.88 18,715.50 136,346.38 2017 3
640348XXX FY '17 HOLIDAY PARK II FSRP Total 657,567.49 652,028.96 5,538.53 2,793.75 2,744.78 2017 3
640355XXX FY '17 FSRP ULAND Total 21,223.00 1,879.30 19,343.70 - 19,343.70 2017 3
640359XXX SAMPLING EQUIPMENT Total 60,190.00 24,558.00 35,632.00 - 35,632.00 2017 3
640360XXX SCADA MASTER PLAN Total 288,798.00 82,213.38 206,584.62 156,304.22 50,280.40 2017 3
640361XXX BONNIE BRAE 380 TO WINDSOR Total 15,000.00 14,447.72 552.28 - 552.28 2017 3
640365XXX PAINTING BUILDINGS Total 250,000.00 91,429.25 158,570.75 148,831.40 9,739.35 2017 3
640367XXX PCWRP LEVEE Total 55,000.00 49,324.00 5,676.00 - 5,676.00 2017 3
640370XXX FY 2018 MANAGEMENT STUDY Total 158,000.00 147,231.29 10,768.71 - 10,768.71 2018 2
City of Denton -Job Cost Summary
Wastewater
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
City of Denton -Job Cost Summary
Wastewater
640373XXX FY '19 FSRP WELLINGTON Total 90,000.00 21,697.27 68,302.73 - 68,302.73 2018 2
640375XXX FY '19 FSRP HETTIE Total 7,000.00 3,494.83 3,505.17 - 3,505.17 2018 2
640376XXX FY '19 FSRP STELLA Total 13,000.00 10,706.18 2,293.82 - 2,293.82 2018 2
640377XXX FY '18 LINING PROJECTS Total 343,553.00 338,736.75 4,816.25 4,816.25 - 2018 2
640378XXX CREEKSIDE CAPACITY PROJECT Total 200,000.00 27,263.86 172,736.14 - 172,736.14 2018 2
640379XXX HILLCREST SEWER REHAB Total 99,071.05 103,880.25 (4,809.20) - (4,809.20) 2018 2
640382XXX HICKORY CREEK INTERCEPTOR III Total 500,827.91 318,648.47 182,179.44 15,197.00 166,982.44 2018 2
640386XXX MCKINNEY STREET WIDENING Total 610,000.00 55,340.00 554,660.00 - 554,660.00 2018 2
640387XXX FY 2019 WW SERVICE LINES Total 89,464.53 79,264.51 10,200.02 10,200.02 - 2019 1
640388XXX FY 2019 WASTEWATER TAPS Total 56,810.26 47,953.86 8,856.40 14,755.96 (5,899.56) 2019 1
640390XXX PECAN CREEK SCADA UPGRADE Total 100,000.00 86,987.38 13,012.62 - 13,012.62 2019 1
640391XXX FY20 FSRP WESTGATE HEIGHTS IPT Total 230,000.00 198.20 229,801.80 - 229,801.80 2019 1
640392XXX FY20 FSRP GRANADA TRAIL SEWER Total 20,000.00 372.71 19,627.29 - 19,627.29 2019 1
640393XXX FY20 FSRP ROBSON RANCH SEWER Total 170,000.00 61,552.75 108,447.25 - 108,447.25 2019 1
640394XXX 24" WASTEWATER FORCE MAIN REP Total 102,868.46 115,218.48 (12,350.02) - (12,350.02) 2019 1
640395XXX FY19 FSRP MAGNOLIA PH II Total 217,110.00 212,849.19 4,260.81 - 4,260.81 2019 1
640396XXX FY19 FSRP ORR ST SEWER REHAB Total 238,000.00 231,844.70 6,155.30 17,150.79 (10,995.49) 2019 1
640397XXX FIELD TABLETS FOR INSPECTION Total 5,000.00 3,852.38 1,147.62 - 1,147.62 2019 1
640398XXX FY19 FSRP SMITH ST SEWER REHAB Total 156,000.00 155,210.53 789.47 2,065.50 (1,276.03) 2019 1
640399XXX FY19 FSRP NORTHWOOD PLACE SEWR Total 59,000.00 56,274.87 2,725.13 806.00 1,919.13 2019 1
640400XXX FY19 FSRP SANDY CREEK REHAB Total 94,182.10 80,788.49 13,393.61 13,508.00 (114.39) 2019 1
640401XXX WW SCADA NETWORK UPGRADE Total 157,000.00 155,708.72 1,291.28 - 1,291.28 2019 1
640402XXX FY20FSRP WODLAND/CHERYWD SEWER Total 419,932.00 206,295.92 213,636.08 31,413.46 182,222.62 2019 1
640403XXX HOBSON FORCE MAIN REPAIR Total 60,000.00 40,377.35 19,622.65 1,216.50 18,406.15 2019 1
640405XXX FY19 FSRP PRECISION DR SEWR LN Total 82,000.00 11,212.75 70,787.25 - 70,787.25 2019 1
640407XXX ROBSON WW DIVERSION PROJECT Total 1,000,000.00 - 1,000,000.00 - 1,000,000.00 2019 1
640408XXX WASTEWATER 2019 RATE STUDY Total 54,400.00 45,568.85 8,831.15 8,666.15 165.00 2019 1
640409XXX FY20 FSRP WEST MULBERRY WW Total 156,000.00 19,894.52 136,105.48 - 136,105.48 2019 1
640410XXX 300' REPLACEMENT MAIN-SCRIPTUR Total 4,935.28 5,878.29 (943.01) - (943.01) 2019 1
640412XXX UV LAMP REPLACEMENT Total 88,173.00 85,771.65 2,401.35 - 2,401.35 2019 1
640414XXX FY 2020 WW SERVICE LINES Total 281,837.00 63,836.78 218,000.22 14,516.88 203,483.34 2020 0
640415XXX FY 2020 WASTEWATER TAPS Total 82,279.00 28,051.84 54,227.16 14,108.40 40,118.76 2020 0
640416XXX OVERSIZE WATER LINES Total 200,000.00 - 200,000.00 - 200,000.00 2019 1
640417XXX STARK FARMS LIFT STATION Total 25,620.80 19,720.32 5,900.48 - 5,900.48 2019 1
640418XXX HILLCREST SEWER REHAB II Total 184,000.00 - 184,000.00 - 184,000.00 2020 0
640419XXX CLEAR CREEK BASIN PUMP STATION Total 493,686.68 5,555.76 488,130.92 488,580.92 (450.00) 2020 0
640420XXX TX DOT I35 RELOCATION Total 480,000.00 - 480,000.00 330,000.00 150,000.00 2020 0
640421XXX HICKRY CREEK EMERG DECLARATION Total 430,000.00 364,163.73 65,836.27 853.81 64,982.46 2020 0
640422XXX FY 2020 MANHOLE REPAIR/REPLACE Total 50,000.00 8,150.02 41,849.98 - 41,849.98 2020 0
640424XXX COOPER CREEK ATO SWITCH Total 175,000.00 165,000.00 10,000.00 - 10,000.00 2020 0
640425XXX FY 19 STREET BUNDLING-SCRIPT Total 402,160.00 246,952.64 155,207.36 155,388.00 (180.64) 2020 0
640426XXX FY 19 STREET BUNDLING-WINDSOR Total 635,775.00 - 635,775.00 635,775.00 - 2020 0
640427XXX FY 20 STREET BUNDLING-DESIGN Total 218,065.00 1,425.71 216,639.29 - 216,639.29 2020 0
640428XXX BELL STREET II Total 140,000.00 512.11 139,487.89 - 139,487.89 2020 0
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
City of Denton -Job Cost Summary
Wastewater
640430XXX CARNEGIE - OPA Total 44,000.00 42,841.00 1,159.00 - 1,159.00 2020 0
640431XXX ELM & LOCUST PHASE II Total 92,008.00 14,050.19 77,957.81 492.55 77,465.26 2020 0
640432XXX FSRP - FY 19-20 WWC AMHURST Total 26,000.00 2,369.81 23,630.19 5,360.00 18,270.19 2020 0
645081XXX WC1828 PUMP Total 60,000.00 25,967.77 34,032.23 25,678.00 8,354.23 2018 2
645089XXX WC1964 DUMP TRUCK 14 YD GREEN Total 152,000.00 152,975.77 (975.77) - (975.77) 2019 1
645090XXX WC1965 DUMP TRUCK 14 YD GREEN Total 152,000.00 153,350.30 (1,350.30) - (1,350.30) 2019 1
645091XXX WC1966 2T CREW CAB DIESEL UTIL Total 90,000.00 31,448.30 58,551.70 44,949.00 13,602.70 2019 1
645092XXX WC1990 TRAILER Total 2,000.00 - 2,000.00 - 2,000.00 2019 1
645093XXX WW1923 1/2 TON DOUBLE CAB Total 55,700.00 25,031.41 30,668.59 - 30,668.59 2019 1
645216XXX WT20131 AND WT20132 GENERATORS Total 400,000.00 - 400,000.00 400,000.00 - 2019 1
645218XXX WC19135-CX80C CASE EXCAVATOR Total 113,000.00 - 113,000.00 113,000.00 - 2020 0
645219XXX WC19136-CX80C CASE EXCAVATOR Total 113,000.00 - 113,000.00 113,000.00 - 2020 0
645220XXX WC19138-CX145MSR CASE EXCAVATR Total 132,800.00 - 132,800.00 132,800.00 - 2020 0
645221XXX WC19139-CX145MSR CASE EXCAVATR Total 132,800.00 - 132,800.00 132,800.00 - 2020 0
645222XXX DR2088 - LIGHT DUTY MAINT TRUK Total 30,000.00 29,117.26 882.74 - 882.74 2020 0
645225XXX WC1941 - UTILITY TRUCK Total 90,000.00 - 90,000.00 - 90,000.00 2020 0
645226XXX DR2087 - 2 TON TRUCK Total 75,000.00 - 75,000.00 - 75,000.00 2020 0
645227XXX DR2092 - STREET SWEEPER Total 250,000.00 - 250,000.00 239,185.00 10,815.00 2020 0
645228XXX WT19100 - CHASSIS/SWAPLOADER Total 240,000.00 - 240,000.00 234,703.94 5,296.06 2020 0
645229XXX BOBCAT ATTACHMENT Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
645996XXX UNALLOCATED VEHICLE FUNDING Total 2,854,537.97 - 2,854,537.97 - 2,854,537.97 2020 0
Grand Total 64,925,729.75 19,747,703.63 45,178,026.12 21,923,549.32 23,254,476.80
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
650039XXX CHANNEL REHABILITATION Total 346,491.05 107,099.93 239,391.12 - 239,391.12 2020 0
650043XXX MINGO LANE & LOOP 288 IMPROVE Total 659,761.30 679,464.73 (19,703.43) 4,142.91 (23,846.34) 2007 13
650047XXX PEC-4 LOCUST AND HIGHLAND Total 4,832,201.78 4,812,470.01 19,731.77 17,846.02 1,885.75 2007 13
650048XXX HIGH WATER MONITORING Total 104,657.49 86,782.86 17,874.63 2,845.49 15,029.14 2020 0
650095XXX HICKORY CR WPT IMPLEMENTATION Total 562,685.79 483,933.89 78,751.90 - 78,751.90 2012 8
650097XXX MOSQUITO CONTROL ACTIVITIES Total 205,650.00 194,186.99 11,463.01 100.00 11,363.01 2020 0
650098XXX STORM WATER MAPPING SYSTEM Total 31,937.22 28,278.25 3,658.97 - 3,658.97 2012 8
650103XXX MAGNOLIA DRAINAGE PH II Total 4,318,687.85 4,141,374.84 177,313.01 - 177,313.01 2015 5
650106XXX EAGLE DRIVE DRAINAGE PH II Total 2,410,000.00 2,380,408.98 29,591.02 45,249.56 (15,658.54) 2015 5
650107XXX SOUTH BELL DRAINAGE SYSTEM Total 806,000.00 67,762.97 738,237.03 3,793.00 734,444.03 2016 4
650108XXX HICKORY ST DRAINAGE&TRUNK LINE Total 911,350.00 142,795.31 768,554.69 4,501.00 764,053.69 2016 4
650111XXX SMITH ST DRAINAGE Total 200,000.00 135,992.81 64,007.19 34,298.84 29,708.35 2016 4
650113XXX DRAINAGE MASTER PLAN UPGRADE Total 211,539.03 83,738.29 127,800.74 - 127,800.74 2017 3
650115XXX OAK STREET DRAINAGE SYSTEM Total 293,399.00 35,024.81 258,374.19 1,190.00 257,184.19 2017 3
650116XXX MULTIPARAMETER DATASONDES Total 24,000.00 10,224.26 13,775.74 - 13,775.74 2017 3
650118XXX PEC 4 - PHASE 3&4 Total 1,230,575.84 1,004,456.12 226,119.72 234,152.00 (8,032.28) 2018 2
650120XXX PEC 4 - PHASE 2 Total 2,485,000.00 1,207,147.24 1,277,852.76 1,287,001.93 (9,149.17) 2018 2
650121XXX HERCULES STORM DRAIN Total 100,000.00 81,472.18 18,527.82 - 18,527.82 2018 2
650122XXX PECAN CREEK DRAINAGE STUDY Total 500,000.00 515,167.43 (15,167.43) 40,274.41 (55,441.84) 2018 2
650123XXX OAKTREE PROJECT Total 100,000.00 53,859.30 46,140.70 - 46,140.70 2019 1
650124XXX COOPER CREEK EROSION REPAIR Total 200,000.00 56,471.68 143,528.32 26,263.96 117,264.36 2019 1
650125XXX WESTGATE DRIVE Total 150,000.00 3,182.98 146,817.02 - 146,817.02 2019 1
650126XXX HICKORY ST/FRY Total 54,312.41 26,162.41 28,150.00 - 28,150.00 2019 1
650127XXX 2017 GOLF CT STORM DRAIN Total 40,000.00 19,956.83 20,043.17 - 20,043.17 2019 1
650128XXX STORMWATER MASTER PLAN VALUE E Total 75,000.00 58,156.88 16,843.12 - 16,843.12 2020 0
650129XXX S. TRINITY ROAD STORM DRAIN Total 30,000.00 10,784.64 19,215.36 13,972.20 5,243.16 2020 0
650981XXX CHOCTAW DRAINAGE PROJECT Total 100,000.00 43,077.64 56,922.36 - 56,922.36 2019 1
650982XXX ELLISON PARK FLUME Total 20,000.00 13,369.95 6,630.05 - 6,630.05 2019 1
650996XXX UNALLOCATED BOND FUNDS Total 112.91 - 112.91 - 112.91 2020 0
655031XXX DR19102 BACKHOE 430 Total 115,000.00 106,198.63 8,801.37 - 8,801.37 2019 1
655032XXX DR1944 2T CREW CAB 4X4 UTILITY Total 67,500.00 73,892.02 (6,392.02) - (6,392.02) 2019 1
655033XXX DR1991 TRAILER Total 10,000.00 - 10,000.00 - 10,000.00 2019 1
655035XXX DR2086 - LIGHT DUTY MAINT. TRU Total 30,000.00 28,365.17 1,634.83 - 1,634.83 2020 0
655036XXX DR2090 - EXCAVATOR Total 150,000.00 194.98 149,805.02 146,062.00 3,743.02 2020 0
655037XXX WP20126 PICK UP Total 30,000.00 - 30,000.00 - 30,000.00 2020 0
Grand Total 21,405,861.67 16,691,455.01 4,714,406.66 1,861,693.32 2,852,713.34
City of Denton -Job Cost Summary
Drainage
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
660243XXX GAS WELL INSTALLATION PROJECT Total 250,000.00 208,859.00 41,141.00 28,795.00 12,346.00 2019 1
660244XXX DESIGN OF CART CORALS Total 25,000.00 - 25,000.00 - 25,000.00 2019 1
660245XXX FY 19 - RF - ROUTE MAPPING Total 49,500.00 39,650.00 9,850.00 800.00 9,050.00 2019 1
660251XXX FY 19-20 ROLL OFF-SW2055 Total 200,447.27 - 200,447.27 192,661.00 7,786.27 2020 0
660252XXX RF - WATER TRUCK FILL STAND Total 45,000.00 8,500.00 36,500.00 31,525.00 4,975.00 2020 0
660253XXX 5YR - SW20128 D6XE Dozer Total 475,000.00 - 475,000.00 469,401.38 5,598.62 2020 0
660254XXX 5YR - PDA RELOCATION FUND Total 1,425,000.00 - 1,425,000.00 - 1,425,000.00 2020 0
660255XXX SCALEHOUSE SOFTWARE Total 400,000.00 - 400,000.00 - 400,000.00 2020 0
660560XXX 20YR-LT-LF PERMIT EXPANSION Total 2,417,194.66 2,200,816.75 216,377.91 206,008.07 10,369.84 2020 0
660640XXX FY '18 - LF ENGINEER SERVICES Total 109,000.00 81,079.57 27,920.43 - 27,920.43 2020 0
660642XXX 10YR - 1001 MAYHILL REMODEL Total 371,250.13 336,599.36 34,650.77 7,188.18 27,462.59 2018 2
660657XXX RF - FY2020 - CART STORAGE & Total 8,500.00 - 8,500.00 - 8,500.00 2020 0
660658XXX 10 YR - UTILITY TRUCK BED Total 95,000.00 - 95,000.00 92,367.77 2,632.23 2020 0
660659XXX NEW CELL DESIGN Total 450,000.00 - 450,000.00 - 450,000.00 2020 0
660891XXX 20YR - BUFFER ZONE IRRIGATION Total 975,000.00 161,030.16 813,969.84 70,305.70 743,664.14 2020 0
660893XXX 20YR-LT-MOSELY ROAD LANDFILL Total 3,300,000.00 45,349.58 3,254,650.42 133.50 3,254,516.92 2020 0
660894XXX FLEET SOLID WASTE FACILITY Total 100,000.00 27,802.92 72,197.08 - 72,197.08 2019 1
660897XXX 20YR - ADMIN BLDG RENOVATIONS Total 517,018.30 - 517,018.30 - 517,018.30 2020 0
660898XXX NORTHLAKES ENCLOSURES Total 410,439.00 8,010.50 402,428.50 14,989.50 387,439.00 2020 0
660899XXX 20YR-GAS HEADER PERIMETER RD Total 2,875,000.00 - 2,875,000.00 - 2,875,000.00 2020 0
660992XXX UNALLOCATED-OTHER REVENUE FUND Total 4,347.78 - 4,347.78 - 4,347.78 2020 0
660996XXX 10YR - MISC UNALLOCATED FUNDS Total 34,970.94 - 34,970.94 - 34,970.94 2020 0
665033XXX SW1930-STAKE BED TRUCK Total 59,626.35 - 59,626.35 27,626.35 32,000.00 2019 1
665038XXX SW2083-FY 19-20 ROLL OFF Total 200,000.00 - 200,000.00 192,661.00 7,339.00 2020 0
665039XXX SW2053 - DELCO SYSTEM TRAILER Total 35,000.00 - 35,000.00 - 35,000.00 2020 0
665040XXX SW2052 - FY 19-20 WATER PUMP Total 64,000.00 - 64,000.00 - 64,000.00 2020 0
665043XXX SW2085-FY19-20 MINI REAR LOAD Total 121,594.37 123,365.87 (1,771.50) - (1,771.50) 2020 0
665044XXX SW2054 - FY 19-20 KUBOTA Total 23,000.00 22,266.70 733.30 - 733.30 2020 0
665996XXX VEH REPLACEMENT UNALLOCATED Total 1,606,503.04 - 1,606,503.04 - 1,606,503.04 2020 0
Grand Total 16,647,391.84 3,263,330.41 13,384,061.43 1,334,462.45 12,049,598.98
City of Denton -Job Cost Summary
Solid Waste
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
805006XXX WAREHOUSE STORAGE FACILITY Total 234,873.92 5,867.50 229,006.42 - 229,006.42 2017 3
Grand Total 234,873.92 5,867.50 229,006.42 - 229,006.42 2017
City of Denton -Job Cost Summary
Warehouse
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
810382XXX FD1913 - 3/4 TON DBL CAB Total 42,500.00 - 42,500.00 28,393.60 14,106.40 2019 1
810384XXX FD1914-3/4 TON DBL CAB UTL BED Total 60,000.00 - 60,000.00 49,533.60 10,466.40 2019 1
810386XXX FD1915 - 1/2 TON DBL CAB Total 39,000.00 38,972.24 27.76 - 27.76 2019 1
810397XXX PM1919 - 3/4 TON DBL CAB Total 38,000.00 32,604.69 5,395.31 906.40 4,488.91 2019 1
810399XXX PM1920- 3/4 TON CAB W UTIL BED Total 60,000.00 - 60,000.00 47,487.34 12,512.66 2019 1
810405XXX ST1905 - 3/4 TON DBL CAB Total 45,000.00 3,520.59 41,479.41 13,378.60 28,100.81 2019 1
810406XXX ST1960 - PETERBILT 330 Total 140,000.00 150,207.66 (10,207.66) - (10,207.66) 2019 1
810411XXX TC1992 - TRAILER Total 15,000.00 - 15,000.00 - 15,000.00 2019 1
810424XXX ST1980 - TRAILER Total 40,000.00 - 40,000.00 - 40,000.00 2019 1
810425XXX ST1994 - MINI EXCAVATOR Total 120,000.00 53,044.76 66,955.24 - 66,955.24 2019 1
810426XXX ST1995 - SKID STEER Total 62,250.00 - 62,250.00 - 62,250.00 2019 1
810435XXX FD19115 LIGHT AND AIR TRUCK Total 750,000.00 702,580.34 47,419.66 43,948.58 3,471.08 2019 1
810453XXX TC2050 TRAFFIC BUCKET TRUCK Total 170,000.00 - 170,000.00 151,867.00 18,133.00 2020 0
810454XXX FD2021-EMERGENCY ONE ARFF Total 759,992.00 754,922.00 5,070.00 - 5,070.00 2020 0
810455XXX ST2045-BACKHOE Total 115,000.00 106,689.43 8,310.57 - 8,310.57 2020 0
810456XXX 5 PWI VEHICLES Total 140,000.00 - 140,000.00 - 140,000.00 2019 1
810457XXX FD2093 FIRE ENGINE Total 950,000.00 742,761.10 207,238.90 188,463.64 18,775.26 2020 0
810458XXX AP2001-AP1059 MOWER/TRACTOR Total 94,000.00 - 94,000.00 - 94,000.00 2020 0
810459XXX BI2034-BI0740-1/2 TON TRUCK Total 28,000.00 - 28,000.00 - 28,000.00 2020 0
810460XXX FD2017-FD0689-2 TON BRUSH TRUC Total 150,000.00 - 150,000.00 - 150,000.00 2020 0
810461XXX FD2018-FD0828-2 TON BRUSH TRUC Total 150,000.00 - 150,000.00 - 150,000.00 2020 0
810462XXX FD2020-FD1017-TAHOE/SUV Total 35,000.00 - 35,000.00 - 35,000.00 2020 0
810463XXX FD2019-FD0833 1/2 TON TRUCK Total 39,000.00 - 39,000.00 - 39,000.00 2020 0
810464XXX FM2022-FM0893-3/4 TON TRUCK Total 45,000.00 - 45,000.00 - 45,000.00 2020 0
810465XXX PD2028-PD1125 -PPV TAHOE/SUV Total 67,500.00 - 67,500.00 54,851.52 12,648.48 2020 0
810466XXX PD2081 ADDITION PD TRUCK Total 35,000.00 - 35,000.00 30,822.00 4,178.00 2020 0
810468XXX PD2025-PD1010 PPV TAHOE/SUV Total 67,500.00 - 67,500.00 54,851.52 12,648.48 2020 0
810469XXX PD2026-PD1079 PPV TAHOE/SUV Total 67,500.00 - 67,500.00 54,851.52 12,648.48 2020 0
810470XXX PD2029-PD1211 PPV TAHOE/SUV Total 67,500.00 - 67,500.00 54,851.52 12,648.48 2020 0
810471XXX PD2030-PD1215 PPV TAHOE/SUV Total 67,500.00 - 67,500.00 54,851.52 12,648.48 2020 0
810472XXX PD2031-PD1342 PPV TAHOE/SUV Total 67,500.00 - 67,500.00 54,851.52 12,648.48 2020 0
810473XXX PD2032-PD1402 PPV TAHOE/SUV Total 67,500.00 - 67,500.00 54,851.52 12,648.48 2020 0
810474XXX PD2033-PD1409 PPV TAHOE/SUV Total 67,500.00 - 67,500.00 54,851.52 12,648.48 2020 0
810475XXX PD2075-ADDITION PPV TAHOE/SUV Total 67,500.00 - 67,500.00 - 67,500.00 2020 0
810476XXX PD2076-ADDITION PPV TAHOE/SUV Total 67,500.00 - 67,500.00 - 67,500.00 2020 0
810477XXX PD2077-ADDITION PD TRUCK Total 30,000.00 - 30,000.00 23,671.00 6,329.00 2020 0
810478XXX PD2078-ADDITION PD TRUCK Total 30,000.00 - 30,000.00 23,671.00 6,329.00 2020 0
810479XXX PD2079-ADDITION PD TRUCK Total 30,000.00 - 30,000.00 23,671.00 6,329.00 2020 0
810480XXX PD2080-ADDITION PD TRUCK Total 35,000.00 644.17 34,355.83 30,822.00 3,533.83 2020 0
810481XXX PB2023-PB1397-MOWER/TRACTOR Total 56,000.00 - 56,000.00 55,400.00 600.00 2020 0
810482XXX PM2035-PM0744 DUMP TRUCK Total 157,000.00 - 157,000.00 - 157,000.00 2020 0
810483XXX PM2036-PM1018 MOWER/TRACTOR Total 125,000.00 - 125,000.00 - 125,000.00 2020 0
810484XXX PM2037-PM1334 MOWER/TRACTOR Total 56,000.00 - 56,000.00 55,400.00 600.00 2020 0
810485XXX PM2066-PM08120-AERWAY AERATOR Total 14,000.00 - 14,000.00 - 14,000.00 2020 0
City of Denton -Job Cost Summary
Motor Pool
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
City of Denton -Job Cost Summary
Motor Pool
810487XXX PQ2038 PQ1162 KAWASAKI MULE Total 11,000.00 - 11,000.00 - 11,000.00 2020 0
810488XXX ST2003-ST0166 DUMP TRUCK Total 155,000.00 - 155,000.00 - 155,000.00 2020 0
810489XXX ST2039-ST0531 TRAILER Total 7,500.00 - 7,500.00 - 7,500.00 2020 0
810490XXX ST2040 ST 0573 TRAILER Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
810491XXX ST2041 ST0636 CONCRETE SAW Total 27,000.00 - 27,000.00 - 27,000.00 2020 0
810492XXX ST2042 ST0683 PATHOLE TRUCK Total 180,000.00 - 180,000.00 - 180,000.00 2020 0
810493XXX ST2043 ST0932 BOBCAT Total 8,500.00 - 8,500.00 - 8,500.00 2020 0
810494XXX ST2046 ST8835 TRAILER Total 8,000.00 - 8,000.00 - 8,000.00 2020 0
810495XXX ST2047 ST9426 TRAILER Total 5,000.00 - 5,000.00 - 5,000.00 2020 0
810496XXX ST2048 ST9513 TRAILER Total 5,000.00 - 5,000.00 - 5,000.00 2020 0
810497XXX ST2049-ST9704 TRAILER Total 2,000.00 - 2,000.00 - 2,000.00 2020 0
810498XXX TC2095 ADDITION 1/2 TON TRUCK Total 45,000.00 42,976.34 2,023.66 - 2,023.66 2020 0
810499XXX WH2065 WH0267 FORKLIFT Total 49,000.00 - 49,000.00 - 49,000.00 2020 0
810500XXX PD2024 PD1007 PPV TAHOE SUV Total 67,500.00 - 67,500.00 54,851.52 12,648.48 2020 0
810501XXX PD2027 ADDITION PPV TAHOE/SUV Total 67,500.00 - 67,500.00 54,851.52 12,648.48 2020 0
810502XXX PM20113 ELECTRIC MOWER Total 39,700.00 - 39,700.00 38,939.29 760.71 2020 0
810503XXX PD20108 PD 1773 PPV TAHOE/SUV Total 35,000.00 - 35,000.00 29,935.25 5,064.75 2020 0
810504XXX PD20127 ADDITION PD VAN Total 51,184.00 - 51,184.00 46,964.00 4,220.00 2020 0
810999XXX Unallocated Vehicles Total 39,666.64 3,885.00 35,781.64 - 35,781.64 2020 0
Grand Total 6,144,292.64 2,632,808.32 3,511,484.32 1,431,789.50 2,079,694.82
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
820022XXX FLEET ANNEX FACILITY Total 63,170.00 28,771.88 34,398.12 - 34,398.12 2017 3
820026XXX FLEET SERVICES EXPANSION Total 747,466.66 125,978.01 621,488.65 30,611.21 590,877.44 2019 1
820999XXX UNALLOCATED BOND FUNDS Total 105,986.53 - 105,986.53 - 105,986.53 2020 0
Grand Total 916,623.19 154,749.89 761,873.30 30,611.21 731,262.09
City of Denton -Job Cost Summary
Fleet
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
840035XXX INFRASTRUCTURE REPLACEMENT Total 571,089.62 245,520.70 325,568.92 11,061.63 314,507.29 2020 0
840036XXX PD MDC MODEM REPLACEMENT Total 70,000.00 5,571.71 64,428.29 - 64,428.29 2012 8
840056XXX DME INFRASTRUCTURE Total 2,026,746.27 1,994,223.27 32,523.00 15.00 32,508.00 2020 0
840070XXX PS TECH APP AND HARDWARE Total 390,389.00 363,808.09 26,580.91 26,336.50 244.41 2020 0
840077XXX ENTERPRISE DATA CENTER REFRESH Total 3,704,047.70 2,882,788.14 821,259.56 77,294.56 743,965.00 2017 3
840078XXX INTERNET UPGRADE Total 19,000.00 - 19,000.00 - 19,000.00 2017 3
840079XXX FIRE EMERGENCY REPORTING Total 50,000.00 45,801.00 4,199.00 - 4,199.00 2017 3
840080XXX UNIVERSITY E-TICKET WRITERS Total 20,000.00 10,023.89 9,976.11 - 9,976.11 2017 3
840081XXX BUDGET REPORTING SOFTWARE Total 25,000.00 22,500.00 2,500.00 2,500.00 - 2017 3
840084XXX PC REFRESH Total 2,157,618.00 1,880,236.00 277,382.00 299,047.00 (21,665.00) 2017 3
840086XXX HCM INTEGRATION Total 216,000.00 184,371.00 31,629.00 - 31,629.00 2018 2
840087XXX P25 RADIO SYSTEM REPLACEMENT Total 5,574,083.00 4,575,589.73 998,493.27 968,193.27 30,300.00 2018 2
840088XXX RADIO FIBER INFRASTRUCTURE Total 108,274.41 102,787.21 5,487.20 5,487.20 - 2018 2
840090XXX FY18 - ADOBE PROFESSIONAL UPG Total 20,000.00 - 20,000.00 - 20,000.00 2019 1
840091XXX FY18 - GIS LASERFICHE CONNECT Total 20,000.00 - 20,000.00 - 20,000.00 2019 1
840092XXX FY18-APP PROXY SERVERS UPGRADE Total 30,000.00 25,658.00 4,342.00 - 4,342.00 2019 1
840094XXX DME PC REFRESH Total 230,000.00 91,313.26 138,686.74 - 138,686.74 2019 1
840095XXX DME UTILITY NETWORK UPGRADE Total 400,000.00 118,960.00 281,040.00 66,038.00 215,002.00 2019 1
840096XXX DME SCADA HARDWARE REFRESH Total 300,000.00 24,622.42 275,377.58 - 275,377.58 2019 1
840099XXX DME METERING INITIATIVES Total 194,897.00 - 194,897.00 30,450.00 164,447.00 2019 1
840100XXX P25 INTEGRATE TO HIGHER GROUND Total 87,000.00 43,357.50 43,642.50 43,357.50 285.00 2019 1
840101XXX FY 18 - 19 NETWORK CABLING Total 37,473.00 36,772.70 700.30 700.30 - 2019 1
840102XXX FY18 - 19 APPLICATION Total 5,823.00 - 5,823.00 - 5,823.00 2019 1
840103XXX SUPPORT SERVICES EQUIPMENT Total 16,978.00 - 16,978.00 - 16,978.00 2019 1
840104XXX FIRE MDCS Total 86,700.00 58,730.80 27,969.20 1,469.13 26,500.07 2019 1
840105XXX FIRE TECH HARDWARE & APPS Total 17,742.00 1,737.07 16,004.93 15,557.14 447.79 2019 1
840106XXX POLICE MDCS Total 255,000.00 261,650.32 (6,650.32) - (6,650.32) 2019 1
840107XXX POLICE TECHNOLOGY HARDWARE Total 21,490.00 5,179.49 16,310.51 - 16,310.51 2019 1
840108XXX POLICE FIRST NET Total 161,500.00 84,000.00 77,500.00 6,560.81 70,939.19 2019 1
840109XXX DME TS BACKUP MACHINES Total 20,000.00 - 20,000.00 - 20,000.00 2019 1
840110XXX DME TS DATABASE ASSESSMENT Total 20,000.00 - 20,000.00 - 20,000.00 2019 1
840111XXX CITY WIDE BACKUP MACHINES Total 24,000.00 - 24,000.00 - 24,000.00 2019 1
840112XXX OUTSOURCE ERP SERVICES Total 131,000.00 - 131,000.00 - 131,000.00 2019 1
840113XXX OUTSOURCE DESKTOP SERVICES Total 50,000.00 - 50,000.00 - 50,000.00 2019 1
840114XXX OUTSOURCE APP ENHANCEMENTS Total 20,000.00 - 20,000.00 - 20,000.00 2019 1
840116XXX CITY WIDE DATA WAREHOUSE Total 25,000.00 - 25,000.00 25,000.00 - 2019 1
840117XXX PRINTER STRATEGIES Total 127,000.00 18,307.70 108,692.30 600.00 108,092.30 2019 1
840118XXX 311 ASSESSMENT Total 30,000.00 19,500.00 10,500.00 - 10,500.00 2019 1
840119XXX IDENTIX LIVESCAN UPGRADE Total 37,000.00 - 37,000.00 - 37,000.00 2020 0
840120XXX DME HARDWARE UPGRADES Total 150,000.00 - 150,000.00 - 150,000.00 2020 0
840121XXX DME CAMERA INFRASTRUCTURE Total 250,000.00 - 250,000.00 - 250,000.00 2020 0
840122XXX FY 19-20 CABLING Total 20,000.00 8,814.19 11,185.81 7,299.07 3,886.74 2020 0
840123XXX FY20 PUBLIC SAFETY REDUNDANCY Total 130,000.00 - 130,000.00 130,000.00 - 2020 0
840125XXX FY2020 ANTI VIRUS Total 60,000.00 26,639.95 33,360.05 - 33,360.05 2020 0
City of Denton -Job Cost Summary
Tech Services
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
City of Denton -Job Cost Summary
Tech Services
840126XXX KEMP REPLACEMENT Total 15,000.00 - 15,000.00 - 15,000.00 2020 0
840127XXX AP & VENDOR MGMNT SOFTWARE Total 238,000.00 - 238,000.00 - 238,000.00 2020 0
840128XXX CUST SERVICE NORTHSTAR UPGRADE Total 50,000.00 27,895.30 22,104.70 - 22,104.70 2020 0
840999XXX UNALLOCATED PROJECT FUNDS Total 33,042.01 - 33,042.01 - 33,042.01 2020 0
Grand Total 18,246,893.01 13,166,359.44 5,080,533.57 1,716,967.11 3,363,566.46
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
600755XXX POCKRUS-BRINKER/SPENCER INT TM Total 3,958,042.67 2,884,811.66 1,073,231.01 921,809.94 151,421.07 2005 15
602921XXX PSA-SGS ENGINEERING, LLC FY11 Total 84,335.59 - 84,335.59 84,335.59 - 2011 9
603187XXX PSA-BLACK & VEATCH CORP-FY 13 Total 210,297.40 - 210,297.40 210,297.40 - 2013 7
603188XXX PSA-POWER TESTING Total 32,915.00 - 32,915.00 32,915.00 - 2013 7
603200XXX EAGLE SUBSTATION Total 5,294,820.24 2,397,138.26 2,897,681.98 114,283.60 2,783,398.38 2013 7
603234XXX HICKORY SUBSTATION RECONSTRUCT Total 6,523,030.24 4,195,183.97 2,327,846.27 379,422.30 1,948,423.97 2013 7
603246XXX PSA - POWER ENGINEERS - FY13 Total 741,813.70 - 741,813.70 741,813.70 - 2013 7
603289XXX Underwood Substation Total 407,507.25 364,116.24 43,391.01 - 43,391.01 2013 7
603290XXX Brinker Substation Total 24,651,780.30 20,340,205.40 4,311,574.90 3,901,794.53 409,780.37 2013 7
603291XXX PSA - KELSEY Total 163,789.44 - 163,789.44 163,789.44 - 2013 7
603314XXX C of D Lewisville Pumps Update Total 84,629.00 80,895.49 3,733.51 - 3,733.51 2013 7
603332XXX PWR Solutions PSA FERC Filing Total 143,320.07 - 143,320.07 143,320.07 - 2013 7
603363XXX PSA - Teague, Nall & Perkins Total 2,078,838.56 - 2,078,838.56 2,078,838.56 - 2013 7
603364XXX PSA - D & S Engineering Total 209,210.32 - 209,210.32 209,210.32 - 2013 7
603390XXX PSA- Freese & Nichols Total 158,717.84 - 158,717.84 3.74 158,714.10 2014 6
603496XXX Denton W INTCHG Relay Upgrade Total 3,740,168.08 1,958,392.55 1,781,775.53 - 1,781,775.53 2014 6
603500XXX BRINKER TO SPENCER INT TM LINE Total 217,242.11 207,374.77 9,867.34 - 9,867.34 2014 6
603511XXX ARCO to Cooper Creek TM Total 4,517,709.22 2,808,964.86 1,708,744.36 514,173.32 1,194,571.04 2014 6
603581XXX MOBILE WORK FORCE MANAGEMENT Total 541,000.00 467,234.98 73,765.02 59,550.52 14,214.50 2015 5
603582XXX LIFE CYCLE ASSETS Total 545,000.00 400,791.80 144,208.20 - 144,208.20 2015 5
603631XXX CIP2017-13 Hobson DBL CIR Total 957,395.78 495,850.88 461,544.90 - 461,544.90 2015 5
603725XXX BONNIE BRAE SUBST 138 KV Total 410,000.00 134,085.21 275,914.79 151,710.00 124,204.79 2015 5
603778XXX PSA- JB TEMPLETON CONSULTING Total 43,233.33 - 43,233.33 43,233.33 - 2015 5
603803XXX Asset Management System Total 350,000.00 79,545.00 270,455.00 127,035.50 143,419.50 2018 2
603804XXX Eng Sys & Computer Related Equ Total 251,000.00 - 251,000.00 - 251,000.00 2018 2
603921XXX Courts of Bonnie Brae Ph 1 Total 190,000.00 8,408.31 181,591.69 - 181,591.69 2016 4
603924XXX Admin Budget Software Total 190,360.00 157,709.30 32,650.70 32,650.70 - 2016 4
603932XXX Sherman Crossing Res PH 2A Total 253,676.68 91,152.90 162,523.78 30,428.23 132,095.55 2018 2
603933XXX Sherman Crossing Retail PhA Total 220,000.00 126,353.64 93,646.36 28,858.03 64,788.33 2018 2
603987XXX ELECTRIC APPLICATIONS UPGRADES Total 350,053.00 255,936.45 94,116.55 14,240.00 79,876.55 2016 4
603991XXX HICKORY SUB TM UG/OH RECONFIG Total 1,066,605.00 1,025,912.68 40,692.32 2,700.00 37,992.32 2016 4
603996XXX DENTON ENERGY CENTER Total 215,200,000.00 213,226,720.34 1,973,279.66 527,400.09 1,445,879.57 2016 4
604025XXX UNT Mulberry St OH to UG Total 250,000.00 6,217.93 243,782.07 - 243,782.07 2016 4
604030XXX Hickory Sub Fdr Exit Conduits Total 13,301.80 3,970.02 9,331.78 - 9,331.78 2017 3
604052XXX Hartlee Substation Total 155,440.28 143,495.20 11,945.08 - 11,945.08 2017 3
604056XXX Service King Service Total 20,000.00 - 20,000.00 - 20,000.00 2017 3
604087XXX RD Wells to Hickory TM Tie-In Total 400,514.34 117,770.77 282,743.57 262,692.46 20,051.11 2017 3
604093XXX The Park (LABB) Total 15,000.00 2,192.72 12,807.28 - 12,807.28 2019 1
604095XXX Hickory Creek Detention Facili Total 20,000.00 2,851.37 17,148.63 - 17,148.63 2017 3
604096XXX Pecan Creek West Peak Flow Total 25,000.00 300.00 24,700.00 - 24,700.00 2017 3
604100XXX Windsor/Hanover/Emerson Reb Total 680,000.00 669,243.33 10,756.67 1,288.40 9,468.27 2019 1
604103XXX Woodrow to Brinker TML Total 243,781.04 150,184.44 93,596.60 15,413.27 78,183.33 2017 3
604112XXX MAYHILL RD STREET LIGHTING Total 400,000.00 13,320.17 386,679.83 104,033.44 282,646.39 2017 3
604116XXX DISD BUS YARD Total 12,000.00 397.17 11,602.83 - 11,602.83 2017 3
City of Denton -Job Cost Summary
Electric
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
City of Denton -Job Cost Summary
Electric
604142XXX Pioneer ETRM Total 1,126,000.00 - 1,126,000.00 - 1,126,000.00 2017 3
604163XXX Bonnie Brae Expansion Ph IV Total 550,000.00 228,921.40 321,078.60 937.50 320,141.10 2017 3
604164XXX Bonnie Brae Expansion Ph V Total 165,429.63 21,763.75 143,665.88 1,010.00 142,655.88 2017 3
604173XXX DN TRANSFORMER #2 FDR EXITS Total 370,000.00 145,284.48 224,715.52 48,391.42 176,324.10 2017 3
604183XXX Locust Subst SW Fdr Exits Total 509,867.60 504,497.60 5,370.00 5,370.00 - 2017 3
604188XXX Eagle to Locust TM Line Total 1,785,133.24 1,413,009.11 372,124.13 2,538.44 369,585.69 2017 3
604189XXX Hickory to Eagle TM Line Total 2,680,715.19 2,191,054.40 489,660.79 37,057.60 452,603.19 2017 3
604190XXX Traffic Signals US377 S Total 10,000.00 215.29 9,784.71 - 9,784.71 2017 3
604204XXX DENTON NORTH POWER XFRMR ADDTN Total 2,705,058.92 2,546,546.02 158,512.90 129,900.58 28,612.32 2017 3
604206XXX CORNER STORE Total 20,000.00 441.33 19,558.67 - 19,558.67 2017 3
604219XXX Colorado Medical Office Bldg Total 20,000.00 1,107.66 18,892.34 - 18,892.34 2018 2
604220XXX Sundown Ranch Commercial Total 20,000.00 2,535.94 17,464.06 - 17,464.06 2017 3
604222XXX Eng GIS Tech Sys Replacements Total 808,050.00 508,552.54 299,497.46 37,909.50 261,587.96 2017 3
604227XXX Compliance Software Services Total 120,000.00 71,250.00 48,750.00 - 48,750.00 2017 3
604285XXX COD Irrigation Svc at Marshall Total 13,342.06 4,624.73 8,717.33 - 8,717.33 2018 2
604297XXX ED1808 ED0416 Excavator Total 60,000.00 53,305.07 6,694.93 - 6,694.93 2018 2
604299XXX ED1810 ED0856 Backhoe Total 110,000.00 106,252.72 3,747.28 - 3,747.28 2018 2
604318XXX Denton County Admin PH III Total 52,380.00 42,122.00 10,258.00 9,448.60 809.40 2018 2
604339XXX ADMS Communications 2018 Total 18,000.00 3,407.72 14,592.28 - 14,592.28 2018 2
604346XXX JC Denton West Erosion Control Total 47,226.22 28,618.05 18,608.17 - 18,608.17 2018 2
604357XXX Denton North Drainage Total 312,767.44 242,538.04 70,229.40 - 70,229.40 2018 2
604370XXX Service Center Renovation Total 1,317,337.00 82,336.88 1,235,000.12 - 1,235,000.12 2018 2
604375XXX Country Lakes North Ph 5A Total 158,250.00 8,832.52 149,417.48 27,155.11 122,262.37 2019 1
604376XXX Bell & McKinney St Light Reloc Total 79,902.00 22,286.92 57,615.08 27,057.35 30,557.73 2018 2
604377XXX Denton N-Arco Dist Underbuild Total 558,890.93 537,949.76 20,941.17 - 20,941.17 2018 2
604379XXX Spencer-Locust UB Switches Total 270,000.00 236,378.76 33,621.24 17,890.00 15,731.24 2018 2
604380XXX Masch Branch & Hampton Svc Total 10,000.00 2,958.08 7,041.92 - 7,041.92 2018 2
604382XXX PETERBILT PRIMARY SVC & PME Total 185,510.00 43,827.57 141,682.43 - 141,682.43 2018 2
604383XXX BB-NL TM Final Span & Esmt Total 31,332.36 15,320.40 16,011.96 - 16,011.96 2018 2
604386XXX Beall Way Addition Total 398,100.00 270,081.29 128,018.71 68,638.50 59,380.21 2018 2
604389XXX Carmel Villas Total 234,850.00 132,194.64 102,655.36 63,829.50 38,825.86 2018 2
604392XXX Denton Student Housing Total 50,000.00 19,201.70 30,798.30 - 30,798.30 2018 2
604393XXX Old Kings Row Subst Retirement Total 500,000.00 12,684.32 487,315.68 - 487,315.68 2018 2
604394XXX MDMS Integration to Synergy Total 45,000.00 33,295.04 11,704.96 - 11,704.96 2018 2
604397XXX Switchgear 864 Replacement Total 100,000.00 23,718.95 76,281.05 - 76,281.05 2018 2
604403XXX Clean & Green Car Wash FM2499 Total 30,000.00 25,513.80 4,486.20 - 4,486.20 2018 2
604405XXX Forrestridge Cable Repl Total 200,000.00 95,002.93 104,997.07 72,895.00 32,102.07 2018 2
604427XXX Fire Station #3 Service Total 26,301.95 19,051.39 7,250.56 - 7,250.56 2020 0
604433XXX DEC Fixtures Total 140,000.00 345.88 139,654.12 - 139,654.12 2018 2
604438XXX S & C Software Licenses Total 113,850.00 42,092.00 71,758.00 - 71,758.00 2018 2
604440XXX Shady Oaks Office Total 15,000.00 2,778.99 12,221.01 - 12,221.01 2018 2
604442XXX Hick's Hanger Total 20,000.00 11,598.14 8,401.86 - 8,401.86 2018 2
604444XXX ED1961 ED0858 Altec 60' Bucket Total 300,000.00 1,043.53 298,956.47 1,637.00 297,319.47 2019 1
604445XXX ED1941 ED0899 3/4 T Crew Cab Total 60,750.00 14,933.86 45,816.14 32,164.21 13,651.93 2019 1
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
City of Denton -Job Cost Summary
Electric
604446XXX ED1942 ED1032 3/4 T Crew Cab Total 60,000.00 14,538.84 45,461.16 32,164.21 13,296.95 2019 1
604447XXX EM1922 EM1135 Chevy C1500 Total 40,585.00 17,174.23 23,410.77 22,014.91 1,395.86 2019 1
604453XXX PRECISION DR FDR TIE PH 2 Total 10,000.00 4,028.84 5,971.16 - 5,971.16 2020 0
604456XXX Residences at Razor Ranch Total 11,256.00 6,695.60 4,560.40 - 4,560.40 2020 0
604457XXX Valvoline Express Care Total 20,000.00 7,162.11 12,837.89 - 12,837.89 2019 1
604458XXX RINEY ROAD TOWNHOMES Total 15,389.00 6,688.11 8,700.89 - 8,700.89 2019 1
604460XXX Country Club Road Estates Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604464XXX Hercules West Phase 2C Total 69,975.00 7,066.56 62,908.44 13,845.58 49,062.86 2019 1
604465XXX Evans Residence Total 20,000.00 9,410.97 10,589.03 8,865.24 1,723.79 2019 1
604466XXX Denton North Substation Fence Total 1,101,000.00 220,988.40 880,011.60 737,362.10 142,649.50 2019 1
604467XXX Stark Farms Ph 1 Total 345,214.86 27,123.57 318,091.29 65,763.35 252,327.94 2019 1
604469XXX Audra Heights Phase 2 Total 130,000.00 15,639.35 114,360.65 - 114,360.65 2019 1
604470XXX LED St Llighting Retrofit Total 1,076,238.08 - 1,076,238.08 - 1,076,238.08 2019 1
604471XXX Wave Wash Total 20,000.00 14,149.11 5,850.89 2,475.78 3,375.11 2019 1
604472XXX University Self Storage Total 110,000.00 48,845.89 61,154.11 - 61,154.11 2019 1
604479XXX Park 7 Denton - West Total 13,609.00 5,071.07 8,537.93 1,680.00 6,857.93 2020 0
604482XXX Sherman Crossing Res Ph 2B Total 249,875.00 18,247.16 231,627.84 38,937.17 192,690.67 2019 1
604483XXX BBI Denton Total 175,000.00 60,726.72 114,273.28 - 114,273.28 2019 1
604484XXX DHS Campus Phase 1 Total 375,000.00 59,005.75 315,994.25 - 315,994.25 2019 1
604485XXX DN Fdr Exit Relocation Total 600,000.00 570,393.50 29,606.50 2,968.04 26,638.46 2019 1
604487XXX I35E NBSR Reloc Ph1 Total 50,000.00 15,227.30 34,772.70 8,000.00 26,772.70 2019 1
604490XXX US 377 STREETLIGHTS PH 1 Total 10,000.00 - 10,000.00 - 10,000.00 2019 1
604491XXX Denton Cope Addition Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604492XXX All Storage Denton Total 135,000.00 84,225.50 50,774.50 - 50,774.50 2019 1
604493XXX Haven at Daugherty Total 101,000.00 2,596.75 98,403.25 - 98,403.25 2020 0
604494XXX Cooper Creek Business Park Total 20,000.00 888.52 19,111.48 6,158.04 12,953.44 2020 0
604495XXX RRTC Lighting Ph 2 East Total 649,200.00 227,843.13 421,356.87 61,421.16 359,935.71 2019 1
604497XXX Morse St Relocation Total 10,000.00 1,183.07 8,816.93 - 8,816.93 2019 1
604499XXX Hickory Creek Rd Reloc Total 360,000.00 28,177.62 331,822.38 - 331,822.38 2019 1
604501XXX US380 East Pole Relocations Total 232,274.07 209,690.81 22,583.26 - 22,583.26 2019 1
604502XXX CVR Trial Total 35,000.00 28,032.46 6,967.54 - 6,967.54 2019 1
604503XXX Enclave At Denton Total 100,000.00 80,196.06 19,803.94 - 19,803.94 2019 1
604504XXX Outback RV Shop Total 10,000.00 7,049.24 2,950.76 - 2,950.76 2019 1
604506XXX Woodrow Wilson Elem Service Total 10,000.00 7,746.22 2,253.78 - 2,253.78 2019 1
604509XXX Hickory Creek Lift Sta Total 25,000.00 18,720.24 6,279.76 - 6,279.76 2019 1
604511XXX Rayzor Ranch S - Ph 2A East Total 375,000.00 327,616.74 47,383.26 - 47,383.26 2019 1
604512XXX Power Quality Improvement Total 344,994.86 325,636.50 19,358.36 - 19,358.36 2019 1
604514XXX Parkview by Toll Brothers Total 125,000.00 19,889.92 105,110.08 29,519.55 75,590.53 2019 1
604515XXX Carriage Square North Total 100,000.00 35,451.22 64,548.78 - 64,548.78 2019 1
604517XXX Bellaire Assisted Living Total 23,825.00 17,253.96 6,571.04 - 6,571.04 2019 1
604519XXX FW221 Circuit Upgrade Total 10,000.00 6,973.51 3,026.49 - 3,026.49 2019 1
604522XXX Forest Crossing Total 10,000.00 1,675.06 8,324.94 - 8,324.94 2019 1
604523XXX Advantage Self Storage Total 10,000.00 291.84 9,708.16 - 9,708.16 2019 1
604524XXX E MCKINNEY ST STREET LIGHTING Total 10,000.00 8,024.43 1,975.57 - 1,975.57 2019 1
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
City of Denton -Job Cost Summary
Electric
604526XXX COD Emergency Sirens Total 23,095.00 10,836.57 12,258.43 - 12,258.43 2019 1
604527XXX PEC 4 Ph 3-4 Reloc Total 10,000.00 2,042.22 7,957.78 - 7,957.78 2019 1
604529XXX Greenville Storm Total 100,000.00 84,435.72 15,564.28 - 15,564.28 2019 1
604532XXX Fairhaven Assisted Living Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604533XXX DHS Campus Phase II Total 320,000.00 4,017.08 315,982.92 - 315,982.92 2020 0
604535XXX S Bonnie Brae Street Lighting Total 130,000.00 70,013.89 59,986.11 - 59,986.11 2019 1
604536XXX Hercules Ln Street Lighting Total 29,250.00 16,878.49 12,371.51 - 12,371.51 2019 1
604537XXX Wave Wash Temp Service Total 6,000.00 - 6,000.00 - 6,000.00 2019 1
604541XXX Rayzor Ranch Senior Living Total 60,000.00 9,585.76 50,414.24 18,143.08 32,271.16 2019 1
604542XXX Academy Foot & Ankle Total 235,000.00 13,864.07 221,135.93 76,006.86 145,129.07 2020 0
604543XXX Crawford Rd to I35W Extension Total 240,166.53 134,590.70 105,575.83 18,000.00 87,575.83 2019 1
604544XXX I35E SBSR Reloc Ph1 Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604545XXX Bonnie Brae/I35E-Hickory Reloc Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604546XXX Bonnie Brae/Hickory-Oak Reloc Total 10,000.00 1,312.15 8,687.85 - 8,687.85 2020 0
604547XXX Exeter Westpark Total 25,000.00 7,775.65 17,224.35 - 17,224.35 2019 1
604548XXX WWTP Xfmr #5644 Replacement Total 100,500.00 5,288.86 95,211.14 - 95,211.14 2019 1
604549XXX **BARRICADE & TRAFFIC CONTROL Total 12,643.65 - 12,643.65 12,643.65 - 2019 1
604552XXX DN Fdr Tie Reconfiguration Total 15,000.00 10,462.87 4,537.13 - 4,537.13 2019 1
604553XXX VINTAGE TOWNHOMES NORTH Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604558XXX Audra Oaks Ph 2A Total 10,000.00 298.96 9,701.04 - 9,701.04 2020 0
604559XXX Guyer HS Field House Total 80,000.00 3,968.67 76,031.33 - 76,031.33 2020 0
604560XXX Ryan HS Auditorium Total 10,000.00 3,803.27 6,196.73 - 6,196.73 2019 1
604561XXX DEC Warehouse Total 120,000.00 - 120,000.00 - 120,000.00 2019 1
604564XXX Fire Station #8 Total 64,336.25 36,438.42 27,897.83 - 27,897.83 2019 1
604565XXX US Cold Storage RR Spur Reloc Total 114,247.48 63,559.48 50,688.00 - 50,688.00 2019 1
604566XXX At the Table Total 10,000.00 4,911.90 5,088.10 2,744.39 2,343.71 2019 1
604567XXX Hillcrest Retail Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604568XXX IOOF Storage Service Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604569XXX Acme Brick Cap Bank Total 20,000.00 - 20,000.00 - 20,000.00 2019 1
604570XXX Annual TS OSI SCADA Maintenanc Total 41,000.00 - 41,000.00 - 41,000.00 2019 1
604630XXX 2020 OH Conductors Total 100,000.00 65,229.21 34,770.79 - 34,770.79 2020 0
604631XXX 2020 UG Conduit Ordinary Repl Total 149,429.00 120,326.80 29,102.20 16,711.00 12,391.20 2019 1
604632XXX 2020 UG Conductor Ordinary Rep Total 244,531.00 200,713.14 43,817.86 - 43,817.86 2019 1
604633XXX 2020 Services Total 977,768.80 580,991.90 396,776.90 91,055.00 305,721.90 2019 1
604634XXX 2020 Poles Total 373,667.48 202,519.02 171,148.46 126,911.30 44,237.16 2020 0
604635XXX 2020 Serv Truck Sec Light Total 109,156.00 75,734.24 33,421.76 25,000.00 8,421.76 2020 0
604636XXX 2020 Street Lights & Signals Total 216,102.00 202,889.18 13,212.82 - 13,212.82 2020 0
604637XXX 2020 City Street Lights Progra Total 1,250,000.00 - 1,250,000.00 - 1,250,000.00 2020 0
604638XXX 2020 Three Phase Meter Total 93,469.00 6,400.00 87,069.00 - 87,069.00 2020 0
604639XXX 2020 Single Phase Meters Total 607,040.00 399,940.00 207,100.00 207,100.00 - 2020 0
604640XXX 2020 Instrument Rated Equip Total 144,604.34 23,675.00 120,929.34 2,814.00 118,115.34 2020 0
604641XXX 2020 AMI & WAN Equipment Total 164,938.46 - 164,938.46 - 164,938.46 2020 0
604642XXX 2020 Prepayment Meter System Total 42,052.00 - 42,052.00 - 42,052.00 2020 0
604643XXX 2020 Substation Security Total 201,977.97 80,829.79 121,148.18 26,778.40 94,369.78 2020 0
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
City of Denton -Job Cost Summary
Electric
604644XXX 2020 FIBER NETWORK MAINTENANCE Total 363,437.88 147,490.68 215,947.20 30,784.64 185,162.56 2020 0
604645XXX 2020 Transformers Total 3,008,900.00 2,262,218.32 746,681.68 70,457.00 676,224.68 2020 0
604646XXX 2020 St Light Conv to LED Prog Total 625,000.00 479,591.10 145,408.90 - 145,408.90 2020 0
604647XXX 2020 Storm Outage Total 84,267.76 59,198.34 25,069.42 - 25,069.42 2020 0
604648XXX 2020 Outage Total 326,609.66 277,997.42 48,612.24 - 48,612.24 2019 1
604649XXX TOWNSEND GREEN PHASE 1 Total 10,000.00 5,222.72 4,777.28 - 4,777.28 2020 0
604650XXX WESTGATE DR FDR UPGRADE Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604651XXX VERIZON WIRELESS NODE SERVICES Total 26,279.00 23,467.75 2,811.25 - 2,811.25 2020 0
604652XXX Garland Storm Recovery Total 50,000.00 21,537.02 28,462.98 - 28,462.98 2020 0
604653XXX Denton County Emergency Ops Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604655XXX Swisher Rd Feeder Tie Total 146,974.56 46,974.56 100,000.00 - 100,000.00 2020 0
604656XXX Jim Christal Rd Reloc Total 50,000.00 - 50,000.00 - 50,000.00 2020 0
604658XXX American National Bank & Trust Total 40,000.00 9,648.62 30,351.38 - 30,351.38 2020 0
604659XXX 427 & 431 Jannie Services Total 27,467.89 26,511.74 956.15 - 956.15 2020 0
604661XXX Denton Crossing Building 3 Total 145,000.00 14,856.35 130,143.65 - 130,143.65 2020 0
604662XXX Denton Crossing Building 4 Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604664XXX Bonnie Brae Ph4A Streetlights Total 40,000.00 4,877.98 35,122.02 - 35,122.02 2020 0
604665XXX Mulberry St Loop Tie Total 20,000.00 872.94 19,127.06 - 19,127.06 2020 0
604666XXX Honda of Denton Relocation Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604667XXX EO2014 EO0857 Pole Machine Total 160,000.00 - 160,000.00 - 160,000.00 2020 0
604668XXX ED2009 ED0876 60' Bucket Truck Total 270,000.00 - 270,000.00 257,427.00 12,573.00 2020 0
604669XXX ES2016 ES1058 Utility Truck Total 160,000.00 - 160,000.00 151,867.00 8,133.00 2020 0
604670XXX Emerson Ln Pole Relocations Total 55,170.00 35,826.61 19,343.39 - 19,343.39 2020 0
604671XXX PROSE WINDSOR APARTMENTS Total 360,000.00 37,734.52 322,265.48 - 322,265.48 2020 0
604672XXX 2020 PRIORITY POLE REPLACEMENT Total 250,000.00 187,309.93 62,690.07 8,457.99 54,232.08 2020 0
604673XXX 2020 STREETLIGHT ADDITIONS Total 500,000.00 3,367.33 496,632.67 - 496,632.67 2020 0
604674XXX The Mark at Denton Total 10,000.00 7,162.49 2,837.51 - 2,837.51 2020 0
604675XXX Cooper Creek Lift Station ATO Total 250,000.00 53,057.95 196,942.05 4,141.05 192,801.00 2020 0
604676XXX EO20102 EO1580 Bucket Truck Total 177,711.00 - 177,711.00 171,286.00 6,425.00 2020 0
604677XXX EO20103 EO1581 Bucket Truck Total 177,711.00 - 177,711.00 171,286.00 6,425.00 2020 0
604678XXX EO20104 EO1582 Bucket Truck Total 177,711.00 - 177,711.00 171,286.00 6,425.00 2020 0
604679XXX EO20105 EO1583 Bucket Truck Total 177,711.00 - 177,711.00 171,286.00 6,425.00 2020 0
604680XXX EO20106 EO1584 Bucket Truck Total 177,711.00 - 177,711.00 171,286.00 6,425.00 2020 0
604681XXX 501 Crawford St Services Total 13,196.00 1,416.35 11,779.65 - 11,779.65 2020 0
604682XXX Bonnie Brae/University to US77 Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604683XXX Hinkle & Mimosa Pole Reloc Total 20,000.00 18,864.97 1,135.03 - 1,135.03 2020 0
604684XXX Colorado Blvd Fdr/Ties Total 60,879.69 15,672.10 45,207.59 8,426.00 36,781.59 2020 0
604685XXX 725 & 727 E Prairie Services Total 12,975.00 3,115.98 9,859.02 - 9,859.02 2020 0
604686XXX JC223 Feeder Extension Total 210,000.00 97,774.27 112,225.73 3,980.00 108,245.73 2020 0
604687XXX FM 1515 Line Relocation Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604688XXX Fannin Street Apartments Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604689XXX Gas Pipeline Svc Total 10,000.00 335.60 9,664.40 - 9,664.40 2020 0
604690XXX 2202 Robinwood Services Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604691XXX Vista Verde Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
City of Denton -Job Cost Summary
Electric
604692XXX US377 James St Pole Reloc Total 30,000.00 10,694.13 19,305.87 - 19,305.87 2020 0
604693XXX Greenwood Dr Pole Relo Total 10,000.00 1,033.74 8,966.26 - 8,966.26 2020 0
604694XXX Teasley Ln Anchor Relo Total 28,730.00 5,325.00 23,405.00 - 23,405.00 2020 0
604695XXX Speed of Light Broadband Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604699XXX 832 SOUTHMONT SERVICE Total 10,000.00 860.35 9,139.65 - 9,139.65 2020 0
604700XXX 7-ELEVEN SHERMAN Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604701XXX KINGS RIDGE PH 1 Total 10,000.00 139.80 9,860.20 - 9,860.20 2020 0
604702XXX 2 TMPA POLES-HICKRY CRK RD EXT Total 100,000.00 11,837.83 88,162.17 - 88,162.17 2020 0
604703XXX I35 RV Svc Extension Total 10,000.00 4,558.93 5,441.07 - 5,441.07 2020 0
604704XXX AT&T Wireless Node Services Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604705XXX Prose Windsor Apts Temp Svc Total 15,645.00 1,570.10 14,074.90 - 14,074.90 2020 0
604706XXX US377 Fulton Pole Reloc Total 10,000.00 2,378.07 7,621.93 - 7,621.93 2020 0
604708XXX 5521 Blagg Well Service Total 18,745.00 1,858.44 16,886.56 - 16,886.56 2020 0
604709XXX Woodrow Fdr Exits Reloc Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604710XXX Covid 19 Pandemic Total 50,000.00 - 50,000.00 - 50,000.00 2020 0
604711XXX THR Surgery Center Total 20,000.00 2,434.56 17,565.44 - 17,565.44 2020 0
604712XXX HSW Westpark Building 1 Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604713XXX Solutions for North Texas 2020 Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604714XXX Candlewood Suites Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604715XXX Bruno Apartments Total 10,000.00 387.06 9,612.94 - 9,612.94 2020 0
604716XXX DHS Campus Phase III Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604717XXX Conn's at Golden Triangle Mall Total 48,142.00 11,989.88 36,152.12 - 36,152.12 2020 0
604718XXX Johnson Ln Business Park Ph3 Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604719XXX Arrowhead Stairs & Trim Total 10,000.00 149.48 9,850.52 - 9,850.52 2020 0
604720XXX Hunter's Creek Apts Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604721XXX BONNIE BRAE WATER LINE CP SVC Total 5,000.00 2,507.47 2,492.53 - 2,492.53 2020 0
604722XXX I35 Warehouse Addition Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604723XXX 2112 Hollyhill Ln St Lt Reloc Total 16,299.00 122.63 16,176.37 - 16,176.37 2020 0
604724XXX BOWIE STORM Total 80,000.00 71,123.30 8,876.70 - 8,876.70 2020 0
604725XXX Hickory Crk Rd Traffic Signal Total 24,302.00 1,457.29 22,844.71 - 22,844.71 2020 0
604726XXX THR Center for Women Total 10,000.00 171.85 9,828.15 - 9,828.15 2020 0
604727XXX Denton Ophthalmology Total 10,000.00 1,139.80 8,860.20 - 8,860.20 2020 0
604728XXX Oxford at Sherman Apts Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604729XXX Audra Heights Assisted Living Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604730XXX Advantage Hail Repair Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604731XXX 2417 College Park Service Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604732XXX Cambridge Brook Ph1 Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604733XXX DE20133 Mower Total 20,000.00 - 20,000.00 18,803.28 1,196.72 2020 0
604734XXX Northgate Addition Conduits Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604735XXX LC211 GOAB Switch Addition Total 15,000.00 - 15,000.00 - 15,000.00 2020 0
604736XXX Vintage Blvd Street Lights Total 150,000.00 - 150,000.00 - 150,000.00 2020 0
604737XXX PSA-POWER ENGINEERS-PRG MNGMNT Total 5,070,304.00 - 5,070,304.00 5,070,304.00 - 2020 0
604738XXX PSA - 7 ARROWS LAND STAFF Total 430,000.00 - 430,000.00 430,000.00 - 2020 0
604739XXX LORETO HOUSE Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
Project Bus Unit Budget Expenditures Remaining Encumbrances Unencumbered setup Year Project Years
City of Denton -Job Cost Summary
Electric
604740XXX DOLLAR GENERAL AT MCKINNEY Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604741XXX WESTWOOD AT RAYZOR RANCH APTS Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604742XXX BUCKLEY RESIDENCE #2 Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604743XXX MURPHY OIL MCKINNEY Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604744XXX US377 POLE RELOC AT FM1830 Total 25,000.00 - 25,000.00 - 25,000.00 2020 0
604745XXX PARKVUE BY TOLL BROTHERS PH 2 Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604746XXX 2020 CHARTER SERVICES Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604747XXX DAYBREAK LOT EV CHARGING Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
604748XXX MCKINNEY & BOLIVAR ST LIGHTING Total 10,000.00 - 10,000.00 - 10,000.00 2020 0
699001XXX 001 - AUTOMATED METER READ Total 975,189.56 - 975,189.56 - 975,189.56 2018 2
699003XXX 003 - 497 BUILDING CONSTRUCTIO Total 105,542.00 - 105,542.00 - 105,542.00 2018 2
699007XXX 007 - FIBER EQUIP MAINTENA Total 1,413,906.75 - 1,413,906.75 - 1,413,906.75 2018 2
699014XXX 014 - DISTRIBUTION TRANSFO Total 1,800,000.00 - 1,800,000.00 - 1,800,000.00 2020 0
699019XXX 019 - FEEDER & EXTENSIONS Total 4,629,101.69 - 4,629,101.69 - 4,629,101.69 2018 2
699024XXX 024 - 497 OTHER DME PROJECTS Total 14,732.81 - 14,732.81 - 14,732.81 2018 2
699025XXX 025 - NEW RESIDENTIAL & CO Total 2,295,675.42 - 2,295,675.42 - 2,295,675.42 2018 2
699028XXX 028 - OVER TO UNDER CONVER Total 1,000,000.00 - 1,000,000.00 - 1,000,000.00 2018 2
699032XXX 032 - POWER FACTOR IMPROVE Total 81,759.64 - 81,759.64 - 81,759.64 2020 0
699040XXX 040 - STREET LIGHTING Total 887,328.53 - 887,328.53 - 887,328.53 2018 2
699080XXX 497 OTHER ELECTRIC PROJECTS Total 351,065.64 - 351,065.64 - 351,065.64 2018 2
699090XXX 500 OTHER ELECTRIC PROJECTS Total 83,129.86 - 83,129.86 - 83,129.86 2018 2
699999XXX UNALLOCATED PROJECT & JOB REVE Total 17,918,876.78 - 17,918,876.78 - 17,918,876.78 2020 0
Grand Total 352,449,171.77 271,570,725.25 80,878,446.52 20,047,232.56 60,831,213.96