Finance Committee

FINANCE COMMITTEE JUNE 25, 2019 AGENDA TIME: 3:30 p.m. LOCATION: City Hall Conference Room 1) NON-PUBLIC MEETING 1. Indemnification: Jennifer Davidson (Building & Codes employee) ​Neil Stauffer 2) PUBLIC MEETING CALL TO ORDER 3) ATTENDANCE 4) Authorization of indemnification of Jennifer Davidson (Building & Codes employee) Neil Stauffer 5) ADOPTION OF MINUTES: May 28 6) DEPARTMENT REPORTS 1. PURCHASING ​Camille Thomas a) Report of bids b) Report of award of professional service contracts ● Gas & Water - Miscellaneous Easement Services as needed from Croft & Associates, LLC in the amount of $50,000.00.  ● Gas & Water - Miscellaneous Engineering Services in Support of Capital Improvement Projects as needed from Hazen & Sawyer in the amount of $100,000.00. ● Gas & Water - Miscellaneous WWTP Facility Improvements from Hazen & Sawyer in the amount of $255,360.00. ● Gas & Water - Sango Water System Improvements from AECOM Technical Services, Inc. in the amount of $1,200,000.00. ● Recreation/Project Management - Design of a Trail Spur near Red River East from Young, Hobbs & Associates in the amount of $9,500.00. c) Report of sale of surplus property on ​GovDeals.com ​May 2019: $15,623.78. 2. GENERAL FUND a) Monthly reports ​Laurie Matta 3. DEPARTMENT OF ELECTRICITY a) Monthly reports ​David Johns, Christy Batts 4. CITY ATTORNEY a) Report of payment of legal expenditures ​Lance Baker ● Bradley Arant, ​Kimberly Black v. City​ - $145.25 ● Bradley Arant, ​Jeff Robinson v. City​ - $35,978.80 7) COMMITTEE ACTION None. 8) CITY COUNCIL ACTION 1. GAS & WATER a) ORDINANCE 1-2019-20 ​(First Reading) Accepting donation of certain real property from the Industrial Development Board for the purpose of a water storage tank ​Councillady Guzman (Gas & Water Committee: Approval)  b) ORDINANCE 2-2019-20 ​(First Reading) Authorizing purchase of property at 111 Cunningham Lane for the Gas & Water North Service Center Councillady Guzman (Gas & Water Committee: Approval) c) ORDINANCE 3-2019-20 ​(First Reading) Authorizing purchase of property for the Gas & Water new Meadowbrook Sewer Pump Station Equalization Basin ​Councillady Guzman (Gas & Water Committee: Approval) 2. PUBLIC SAFETY a) RESOLUTION 2-2019-20 Authorizing an interlocal agreement between the City of Clarksville and the E-911 Emergency Communication District Councilman Henley (Public Safety Committee: Approval) 3. STREETS a) ORDINANCE 4-2010-20 ​(First Reading) Authorizing exercise of right of eminent domain to acquire easements and/or rights-of-way for ​the Trenton Road and Meriwether Road Project, the Tylertown-Oakland Road Improvements Project, and the Whitfield Road Improvements Project ​Councilman Chandler (Street Committee: Approval) b) RESOLUTION 1-2019-20 Asking the Tennessee Department of Transportation for improvements to SR374/Warfield Boulevard from south of Dunbar Cave Road to SR112/Madison Street ​Councilman Chandler (Street Committee: Approval) 9) PUBLIC COMMENTS ​ (3 individuals allowed; 5 minutes each) 10) ADJOURNMENT  FINANCE COMMITTEE MAY 28, 2019 AGENDA CALL TO ORDER The regular monthly meeting of the City of Clarksville Finance Committee was called to order by Chairman Jeff Burkhart on Tuesday, May 28, 2019, at 3:30 p.m. in the City Hall Conference Room, 1 Public Square, Clarksville, Tennessee. ATTENDANCE PRESENT: Jeff Burkhart, Tim Chandler, Valerie Guzman, Jeff Henley, Stacey Streetman Mayor Joe Pitts was also present. MINUTES Councillady Guzman made a motion to adopt the minutes of April 23, April 25, April 30, May 2, May 15, and May 23 as presented. The motion was seconded by Councilman Henley. A voice vote was taken; the motion passed without objection. PURCHASING REPORT Director of Purchasing Camille Thomas presented the monthly bid summary and reported award of the following professional service contracts: ● Gas & Water - Design Services for the Red River Bridge Pipeline Relocation from Clark Engineering & Utility Solutions, LLC in the amount of $49,900.00. ● Gas & Water - Design Services for the Highway 41A Gas Pipeline from Clark Engineering & Utility Solutions, LLC in the amount of $48,000.00. ● Gas & Water - Engineering Services for the WWTP Primary Building HVAC Replacement from Hazen & Sawyer in the amount of $30,000.00. ● Gas & Water - Engineering Services for the TDOT Utility Relocation at SR13/US79 from Holiday Drive to Alfred Thun Road from HDR Engineering, Inc. in the amount of $80,000.00.  ● Recreation/Project Management - Pettus Park Master Plan from Lose Design in the amount of $8,000.00. ● Recreation/Project Management - Design Services for the Renovations to the Billy Dunlop Pavilion from Powell Architecture in the amount of $2,000.00. ● Internal Audit - IT Related Audit Work from Kraft CPA's in the amount of $15,000.00. Mrs. Thomas reported sale of surplus property on ​GovDeals.com ​during the month of April in the amount of $18,796.52. Mrs. Thomas presented the department’s Contract Administration Policy. She said all departments will follow the policy, including CDE and Gas & Water for operating contracts. Heather Fleming noted that Gas & Water engineering contracts would be processed according to the policy by their contract manager. Mrs. Thomas presented the department’s Surplus Real Property Policy and informed the members of an interactive map that would show the location of each property. Mr. Baker said City Council approval is not required for either policy. GENERAL FUND REPORT Chief Financial Officer Laurie said the City had collected $11.9 million more than was spent for the first ten months of FY19 and noted revenues were exceeding expenditures by 14.3%. She said $33 million, or 96%, had been collected in property taxes. Ms. Matta said expenditures were currently 10.9% under budget with department spending $3.5 million, or 5.3%, under total budgets. Local Option Sales Tax collection within the City was $5.2 million with $1.3 million going to the Road Improvement Fund and $4.1 million to the school system. Capital project spending totaled $6.4 million year-to-date with a total investment of $49.3 million. The estimated Fund Balance was $39.2, or 40% of budgeted expenditures. The City had applied for a grant for the Summer Youth Program to provide meals and received notice of award of a $12,000 grant for police motorcycle safety enforcement. Mayor Pitts said an upcoming meeting would be held to discuss distribution of City-County revenues from internet sales. DEPARTMENT OF ELECTRICITY CDE Chief Financial Officer David Johns said the Broadband Division’s initial interdivisional loan from the Electric Division of $18 million was currently $10.2 million with another payment due by the end of June. Mr. Johns said April power usage was down resulting in a net income of $700,000 for the Electric Division. Christy Batts said the Broadband Division ended the month of April with 22,000 subscribers and noted 750 new connects with a net gain of 25. She noted CDE had recently been recognized as having one of the top ten nationwide most affordable high speed internet plans, top three fastest fiber providers in Tennessee, top three fastest internet providers in Tennessee, top ten fastest fiber provider nationwide, and top ten fastest internet provider nationwide. CITY ATTORNEY Mr. Baker reported payment of the following legal expenditures and noted the Miller v. City case had been settled. ● Bradley Arant, ​Kimberly Black v. City​ - $2,280.87 ● Bradley Arant, ​Jeff Robinson v. City​ - $30,832.50 REGIONAL TRANSPORTATION AUTHORITY RESOLUTION 60-2018-19 ​Authorizing an interlocal agreement with the Regional Transportation Authority for transportation service between Clarksville and Nashville Ms. Matta said this agreement was for the Clarksville-Nashville commuter service and that funding would be available July 1 if approved in the FY20 Budget. Councilman Chandler made a motion to forward this resolution to the City Council with a recommendation of approval. The motion was seconded by Councillady Guzman. A voice vote was taken; the motion passed without objection. PUBLIC COMMENTS There were no public comments. ADJOURNMENT The meeting was adjourned at 3:55 p.m. Department of Finance & Revenue May 2019 Financial Review Fiscal Year 2019 Clarksville, Tennessee May 31, 2019  General Fund Revenues vs. Expenditures Fiscal Year 2019 As of May 31, 2019 FY 2019 Monthly FY 2019 Revenues Expenditures Variance July $ 4,091,658 $ 8,104,262 $ (4,012,605) August 6,447,488 6,305,053 142,436 September 4,448,778 7,022,647 (2,573,868) October 4,797,738 7,220,036 (2,422,298) November 7,399,053 6,961,101 437,952 December 10,970,345 6,546,791 4,423,555 January 17,899,039 7,912,332 9,986,707 February 15,975,125 6,497,012 9,478,113 March 6,350,095 7,117,979 (767,884) April 5,275,436 7,969,755 (2,694,319) May 6,898,288 10,794,384 (3,896,096) June - YTD Total $ 90,553,045 $ 82,451,352 $ 8,101,694 $18,000,000 $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 FY 2019 Revenues $6,000,000 FY 2019 Expenditures $4,000,000 $2,000,000 $-  General Fund Revenue Comparison Fiscal Year 2019 As of May 31, 2019 FY 2019 FY 2018 Variance Revenue Revenue July $ 4,091,658 $ 5,485,030 $ (1,393,372) August 6,447,488 $ 4,855,699 1,591,789 September 4,448,778 $ 4,459,243 (10,464) October 4,797,738 $ 4,910,911 (113,173) November 7,399,053 $ 7,688,352 (289,298) December 10,970,345 $ 9,428,493 1,541,852 January 17,899,039 $ 18,211,978 (312,939) February 15,975,125 $ 14,103,119 1,872,006 March 6,350,095 $ 7,840,692 (1,490,597) April 5,275,436 $ 5,018,923 256,514 May 6,898,288 $ 4,819,621 2,078,667 June - - YTD Total $ 90,553,045 $ 86,822,060 $ 3,730,985 $93,000,000 $83,000,000 $73,000,000 $63,000,000 $53,000,000 FY2018 YTD Revenue $43,000,000 FY2019 YTD Revenue $33,000,000 FY2019 YTD Budgeted Revenue $23,000,000 $13,000,000 $3,000,000  GENERAL FUND REVENUES Fiscal Year 2019 As of May 31, 2019 Total Budget YTD Month TAXES Prior Year Property Taxes 1,142,396 1,049,781 3,331 2018 Property Taxes 31,553,619 33,182,881 221,272 PiLOTS 116,899 116,899 - Local Option Sales Tax 19,332,505 16,416,412 1,562,603 Beer & Liquor Tax 4,208,097 3,756,897 354,889 Business License 2,593,225 2,075,972 1,157,067 Franchise Tax (cable) 1,500,000 1,293,883 382,377 Hote/Motel 420,000 421,960 40,511 Other Taxes 491,700 391,530 26,904 TOTAL TAXES 61,358,441 58,706,215 3,748,955 LICENSES AND PERMITS Building Permits 1,759,840 1,789,722 245,706 Other Permits 114,540 99,637 18,921 TOTAL PERMITS 1,874,380 1,889,359 264,627 INTERGOVERNMENTAL Grant reimbursements 127,753 76,930 1,973 State Shared Revenues TVA Replacement Tax 1,574,193 1,180,645 - State Sales Tax 11,500,000 10,706,697 1,029,397 State Street Aid 5,547,526 4,494,830 437,817 Other Taxes 2,230,532 1,930,299 255,139 TOTAL INTERGOVERNMENTAL 20,980,004 18,389,402 1,724,326 OTHER REVENUES Charges for Services 952,046 802,456 71,165 Recreation 630,139 502,855 120,778 Golf Courses 604,871 541,952 87,500 Fines and Forefeitures 593,606 543,535 49,265 Investment & Interest Earnings 359,540 368,184 59,678 Other Misc. Revenues 617,605 570,539 33,734 Transfer from CDE 4,792,787 4,316,751 392,432 Transfer From CGW 3,989,430 3,656,978 332,453 Other Transfers 280,000 264,821 13,376 TOTAL OTHER REVENUES 12,820,024 11,568,070 1,160,380 TOTAL REVENUES GENERAL FUND 97,032,849 90,553,045 6,898,288  General Fund Expenditure Comparison Fiscal Year 2019 As of May 31, 2019 FY 2019 FY 2018 Variance Expenditures Expenditures July $ 8,104,262 $ 6,719,041 $ 1,385,221 August 6,305,053 $ 7,161,006 (855,953) September 7,022,647 $ 7,117,343 (94,696) October 7,220,036 $ 6,433,721 786,315 November 6,961,101 $ 6,410,781 550,321 December 6,546,791 $ 6,964,453 (417,662) January 7,912,332 $ 7,700,935 211,397 February 6,497,012 $ 7,005,812 (508,800) March 7,117,979 $ 7,639,383 (521,404) April 7,969,755 $ 8,351,050 (381,295) May 10,794,384 $ 8,257,214 2,537,170 June - - YTD Total $ 82,451,352 $ 79,760,739 $ 2,690,613 $92,000,000 $82,000,000 $72,000,000 $62,000,000 $52,000,000 FY2018 YTD Expenditures $42,000,000 FY2019 YTD Expenditures $32,000,000 FY2019 YTD Budgeted Expenditures $22,000,000 $12,000,000 $2,000,000  General Fund Year-to-Date Departmental Budget vs. Actual Expenditures Fiscal Year 2019 As of May 31, 2019 $30,000,000 Expenditures Estimated Variance FY 2019 YTD YTD Budget (Over)Under $25,000,000 Departmental: $20,000,000 Police $ 25,311,597 $ 25,910,027 $ 598,430 $15,000,000 FY 2019 Actual Fire 16,438,669 16,645,562 206,893 YTD Highway & Street 11,292,394 12,802,905 1,510,511 $10,000,000 Parks & Rec. & Golf 6,675,733 7,624,235 948,501 $5,000,000 Building & Codes 1,851,677 2,007,533 155,856 FY2019 Total $0 Info. Technology 1,484,149 1,523,871 39,722 Budget Finance 1,469,485 1,587,579 118,093 City Garage 1,024,582 1,141,728 117,145 Municipal Properties 479,494 809,812 330,318 Human Resources 798,706 810,886 12,180 Legislative / Admin. 534,052 570,190 36,137 Mayor's Office 562,658 568,979 6,320 City Court 414,457 422,530 8,073 $1,100,000 Legal 391,800 425,379 33,579 $1,000,000 $900,000 Internal Audit 328,511 375,800 47,290 $800,000 Purchasing 146,424 161,749 15,325 $700,000 Departmental Total 69,204,390 73,388,763 4,184,374 $600,000 $500,000 FY 2019 $400,000 Actual YTD Nondepartmental: $300,000 Debt 8,452,310 8,447,337 (4,973) $200,000 FY2019 Total Transit 1,171,207 1,801,479 630,272 $100,000 Budget $0 Retirees 967,786 1,333,459 365,672 Other 2,655,658 3,323,670 668,012 YTD Total $ 82,451,352 $ 88,294,708 $ 5,843,357  Schedule of Sales Tax Collections Fiscal Year 2019 As of May 31, 2019 City of Clarksville Local Sales & Use Tax Net Collections Net Collections Net Collections Net Collections FY 2016 FY 2017 FY 2018 FY 2019 July $ 1,307,509 $ 1,291,892 $ 1,425,145 $ 1,524,372 August 1,319,998 1,394,223 1,453,282 1,552,311 September 1,318,379 1,312,394 1,376,154 1,461,197 October 1,234,765 1,305,179 1,330,621 1,576,737 November 1,298,471 1,362,262 1,443,473 1,509,818 December 1,218,473 1,275,621 1,357,713 1,602,804 January 1,309,284 1,356,898 1,454,962 1,559,092 February 1,715,397 1,807,932 1,823,774 2,079,756 March 1,144,941 1,196,658 1,234,732 1,333,119 April 1,249,510 1,164,740 1,319,995 1,383,586 May 1,405,109 1,448,181 1,556,171 1,639,262 June YTD Total $ 14,521,836 $ 14,915,980 $ 15,776,022 $ 17,222,053 City of Clarksville $18,500,000 $16,500,000 $14,500,000 $12,500,000 $10,500,000 $8,500,000 $6,500,000 $4,500,000 $2,500,000 $500,000 FY 2016 FY 2017 FY 2018 FY 2019  Local Sales Tax Collections Fiscal Year 2019 As of May 31, 2019 TOTAL NET COLLECTIONS PAID TO GROSS COLLECTIONS UNICORPORATED NET COLLECTIONS COUNTY CITY CITY ROADS SCHOOLS AREA CITY LIMITS PAID TO STATE July $ 6,102,327 $ 80,797 $ 1,453,086 $ 71,286 $ 4,497,157 $ 404,021 $ 5,767,738 $ 69,432 August 6,273,118 85,785 1,479,719 72,592 4,635,021 471,042 5,873,451 71,376 September 5,896,213 80,233 1,392,865 68,331 4,354,784 434,599 5,528,701 67,087 October 6,354,157 86,084 1,503,003 73,734 4,691,336 460,584 5,965,871 72,298 November 6,164,561 87,211 1,438,944 70,605 4,567,801 522,304 5,712,670 70,143 December 6,530,750 91,764 1,527,851 74,953 4,836,182 540,558 6,064,499 74,307 January 6,387,448 91,332 1,486,183 72,909 4,737,024 561,018 5,899,107 72,676 February 9,137,200 158,523 1,982,498 97,258 6,898,921 1,372,030 7,869,132 103,963 March 5,562,368 84,087 1,270,777 62,342 4,145,162 581,560 5,044,097 63,289 April 5,605,081 77,283 1,318,885 64,701 4,144,213 433,808 5,235,047 63,775 May 6,846,983 103,829 1,562,603 76,658 5,103,893 722,445 6,202,443 77,905 June - YTD TOTAL $ 70,860,206 $ 1,026,929 $ 16,416,413 $ 805,370 $ 52,611,494 $ 6,503,969 $ 65,162,757 $ 806,251 Monthly Distribution 1.32% 23.81% 1.17% COUNTY CITY 73.70% CITY ROADS SCHOOLS  Capital Project Status Report Fiscal Year 2019 As of May 31, 2019 TOTAL ACTIVE ACTIVE PROJECTS TOTAL FY EXPENSES PROJECT PROJECT FY2018-2019 FUNDING 7/1/18-5/31/19* BALANCE EXPENSES ** STREET DEPARTMENT: 93101 Rossview/Dunbar Cave/Cardinal Improvements 12,280,000 816,686 2,489,745 9,790,255 13301 Trenton/Tylertown Regional Drainage 283,380 0 163,195 120,185 14301 Edmondson Ferry/1A Bypass Interesection Improvement 1,180,000 543,555 800,127 379,873 15301 Trenton/Needmore 1,252,459 0 949,470 302,989 15305 Professional Park/Cardinal Lane Extension 2,800,385 232,796 470,682 2,329,703 15306 Northeast Connector 16,808,700 318,278 811,229 15,997,471 17301 International & Dunlop Intersection Improvement 749,051 42,065 118,168 630,883 17303 Ringold & SR374 Interesection Improvements 250,000 145,888 161,881 88,119 17304 Adaptaive Signal Control Project (Wilma) 1,200,000 0 0 1,200,000 17305 Tylertown & Oakland Intersection Improvement 1,500,000 242,603 515,087 984,913 17307 Tylertown & Trenton Drainage Overflow Project 920,000 13,683 56,147 863,853 18301 Drainage Mitigation FY2018 280,801 86,001 106,642 174,159 18302 New Sidewalks FY2018 934,954 40,650 60,650 874,304 19301 Lilac Lane 100,000 1,600 1,600 98,400 19302 Whitfield Road Improvements 500,000 149,140 149,140 350,861 19303 Spot Intersection Improvements (meriweather & trenton) 750,000 6,200 6,200 743,800 $ 41,789,730 $ 2,639,144 $ 6,859,962 $ 34,929,768 PARKS & RECREATION: 13501 River Trail (Fed Grant) 1,196,349 0 1,192,026 4,323 16503 Athlectic Complex 5,650,000 181,702 4,463,760 1,186,240 16504 Red River East Trail Project 1,972,832 245,219 915,675 1,057,157 16505 Splash Park (Rotary & Heritage) 498,692 109,476 490,330 8,362 17501 Valleybrook Park & Upland Trail Connection 160,000 0 0 160,000 17502 Public Spaces Comprehensive Plan 150,000 29,265 148,750 1,250 17503 Edith Pettus Park Renovations 201,800 6,000 6,615 195,185 17504 Crow Community Center Renovation 120,000 3,280 3,280 116,720 17505 Liberty Park/Marina Remediation 905,218 17,475 60,524 844,694 17506 Swan Lake Renovations 976,000 844,051 896,911 79,089 18501 Urban Wilderness 450,000 0 429,065 20,935 18502 Lighting one field at Stokes Ballfield 175,000 0 0 175,000 18503 Band Shell for Amphitheatre Stage 100,000 7,500 13,450 86,550 19501 Pool Dome Replacement 165,000 151,359 151,359 13,641 19502 Pollard Road Additional Parking 175,000 8,000 8,000 167,000 19503 Billy Dunlop Pavillion & Restroom 25,000 2,000 2,000 23,000 19504 Heritage Park Improvements 1,000,000 57,051 57,051 942,949 19505 Regional Community Center 100,000 0 0 100,000 $ 14,020,891 $ 1,662,379 $ 8,838,797 $ 5,182,094 FIRE DEPARTMENT: 16221 Fire Maintenance Facility 314,352 0 1,300 313,052 18221 Engine 3 replacement 350,000 349,852 349,852 148 18222 Rescue 3 replacement 250,000 235,556 235,556 14,444 19221 Commercial Engine 375,000 347,309 347,309 27,691 19222 Custom Engine 500,000 442,757 442,757 57,243 $ 1,789,352 $ 1,375,474 $ 1,376,774 $ 412,578 POLICE DEPARTMENT: 19211 District 3 Precinct Building 3,500,000 0 0 3,500,000 $ 3,500,000 $ - $ - $ 3,500,000 CITY GARAGE 19103 Replacement of Refueling Tanks 360,000 189,362 189,362 170,638 $ 360,000 $ 189,362 $ 189,362 $ 170,638 GENERAL GOVERNMENT: 41016 Corporate Business Park Expansion $ 14,289,610 $ - $ 14,092,700 $ 196,910 13101 Clarksville Performing Arts & Conf Center 1,818,075 3,500 176,907 1,641,168 15102 TDOT 2013 Multimodal Access 906,017 59 128,880 777,137 16103 2015 Multimodal Access Grant 915,758 4,766 121,038 794,721 16104 Senior Citizens Center Expansion 3,325,000 329,398 3,103,760 221,240 17102 FEMA Grant - Hazard Mitigation (Flood Buyouts) 1,440,650 268,139 1,414,276 26,374 17101 Smith Trahern Renovations (porch) 186,379 22,761 165,773 20,606 19101 New Council Chambers 50,000 0 0 50,000 19102 Structural Repairs - Cumberland Garage 1,099,036 0 0 1,099,036 $ 24,030,525 $ 628,623 $ 19,203,333 $ 4,827,192 debt issuance costs $ 136,588 Total Spent YTD: Major Projects $ 85,490,498 $ 6,631,569 $ 36,468,228 $ 49,022,270 * Fiscal Year to date invoices paid (July 1st to current month end) ** Total Active Expenses includes all expenses paid during the life of a project, not just the current fiscal year.  Fund Balances Fiscal Year 2019 As of May 31, 2019 Beginning Fund Estimated Ending Revenues Expenditures Fund Balance Fund Balance YTD YTD 7/01/18 5/31/19 General Fund: $ 27,240,880 $ 88,053,045 $ 82,451,352 $ 32,842,573 Capital Projects Fund: (786,060) 162,185,068 160,823,602 575,406 Debt Service Fund: 454,067 10,837,638 10,817,328 474,377 Internal Service Funds: 6,325,999 12,512,520 14,197,917 4,640,601 Non-Major Governmental Funds: Drug Fund 560,504 281,481 332,843 509,142 Road Improvement Fund 2,459,700 812,794 2,250,000 1,022,494 Police Special Fund 69,987 199,961 341,933 (71,985) Parks Special Fund 406,209 409,327 482,016 333,520 Other Special Revenue Fund* 3,226,187 1,192,566 1,041,407 3,377,346 Community Development 401,035 20,412,438 20,366,363 447,109 Capital Projects Revenue District Fund 171,601 2,500,000 2,513,139 158,462 * Includes: Fire Spec. Rev., Traffic Camera Police & Parks, SRF  Notice of Grant Applications Fiscal Year 2019 As of May 31, 2019 Date Funding Funds Match Submitted Project Title Agency Requested Required Status Notes To purchase intercom systems and headsets to be installed in 25 fire service 2017 Assistance to Dept of Homeland 02/02/18 $110,713 $11,071 Awarded vehicles to protect firefighters hearing and improve communications. Firefighters Grant Security, FEMA Anticipate aware announcement April 2018 Fire Safety FEMA - Fire To purchase a new fire safety trailer to be used for public education programs 03/13/18 Trailer/Fire Educator Prevention & Safety $56,771 $2,838 Not funded and pay for 2 fire staff to become ceretified fire and safety educators. Training Grant For continued funding of alcohol and impaired driver countermeasures. Pays TN Highway - $217,058.99 03/30/18 THSO $0 Awarded overtime for police to conduct DUI checkpoints and saturation patrols for one Impaired Driver $90,000 year. Summer Food Service TN Dept of Human $144,720.64 To serve a maximum of 36,895 meals during the Summer Youth Program from 04/18/18 $0 Awarded Program Resource $44,811 June 4th through July 13th at 15 different sites throughout the City. Farmers Martket USDA Agricultural 05/07/18 $208,810 $0 Not funded To improve and expand the owntown farmer's market Promotion Program Marketing Service 2018 Body Worn 05/30/18 US Dept of Justice $114,130 $114,130 Awarded To purchase 80 camera systems for full deployment in police department. Camera 2018 TAEP Tree TN Dept of $1,375 $1,375 To purchase 14 trees to be planted at Liberty Park's newest parking lot near the 06/07/18 Planting at Liberty Awarded Agriculture $3,100 $3,100 rear of the park. Park Walmart Store CFR Family $2,500 Requested to assist families affected by fire by providing them with toiletries, 07/11/18 #4469 (Whitfield $0 Awarded Assistance Program $1,500 etc. Rd) To add healthy eating initiative to Mayor's Summer Night Lights Program. US Conf of Mayors 2019 Childhood Would provide an educational component on healty food choices, provide 07/31/18 American Beverage $120,000 $0 Not Funded Obesity Prevention youth with fresh fruit and vegetables and teach them how to grow their own, Foundation provide cooking demonstrations. CPD will use their share to purchase ballistic plates to supplement their existing 08/22/18 2018 JAG Grant US Dept of Justice $62,577 $0 Awarded ballistic vests as well as helmets. The Sheriff will use their share for wireless communication services for deputies in the field.  Notice of Grant Applications Fiscal Year 2019 As of May 31, 2019 Date Funding Funds Match Submitted Project Title Agency Requested Required Status Notes TAEP Farmers TN Dept. of 2019 funding for advertising and promotion of the Clarksville Downtown 09/14/18 $1,000 $0 Awarded Market Promotion Agriculture Market. Anticipate award announcement in November. Transportation TN Dept of Funding for a pedestrian bridge over the Red River to complete the connection 10/03/18 $1,994,338 $498,584 Submitted Alternative Program Transportion between the Red River Trail and the Greenway Assistance to Dept of Homeland To purchase 82 sets of ballistic protective equipment for firefighters in the 10/26/18 $127,846 $12,784 Submitted Firefighters Grant Security (FEMA) event of an active shooter/mass casualty situation. 2018 Fire Prevention Dept of Homeland To purchase a new fire safety trailer used for public education programs and to 12/06/18 $56,840 $2,841 Submitted & Safety Grant Security (FEMA) pay for 2 fire staff to become certified as Fire and Safety Educators. 2019 Historic TN Historical To hire a consultant to perform a historical survey of the CBID including the 01/29/19 $15,000 $10,000 Submitted Preservation Grant Commission Dog Hill and Emerald Hill Residential Historic Districts. Mayors Summer Walmart Store 02/15/19 $1,000 $0 Submitted Requested funding to support the 2019 Mayors Summer Night Lights Program Night Lights #1075 Mayors Summer 02/15/19 Walmart Store #673 $1,000 $0 Submitted Requested funding to support the 2019 Mayors Summer Night Lights Program Night Lights Mayors Summer Walmart Store 02/15/19 $1,000 $0 Submitted Requested funding to support the 2019 Mayors Summer Night Lights Program Night Lights #3495 Clarksville Fire Requested funding to support to assist families affected by fire by providing Walmart Store 02/15/19 Rescue Family $1,500 $0 Submitted them with toiletries, etc. and purchase smoke alarms to be installed free of #4469 Assistance charge. Clarksville Fire Walmart Store 02/15/19 Rescue Smoke Alarm $1,500 $0 Submitted Requested funding to purchase smoke alarms to be installed free of charge. #4591 Program TN Highway Safety For continued fuding for alcohol and impaired driver countermeasures. This 03/15/19 Office 2020 Alcohol THSO $90,000 $0 Submitted grant pays for overtime for police officers to conduct DUI checkpoints and Impairment saturation patrols for a one year period.  Notice of Grant Applications Fiscal Year 2019 As of May 31, 2019 Date Funding Funds Match Submitted Project Title Agency Requested Required Status Notes TN Highway Safety Grant will pay for overtime for officers to conduct specialized motorcycle Specialized 03/28/19 THSO $12,000 $0 Awarded enforcement activities from May to September 2019 to reduce motorcycle Motorcycle crashes and fatalities. Enforcement Summer Food Service TN Dept of Human To serve a maximum of 37,120 meals during the Summer Youth Program from 04/11/19 $149,686 $0 Submitted Program Services June 3 through July 12 at 15 different sites throughout the City. Requested funding to purchase 5 laptops for dispatchers to use in the event the 05/14/19 Dispatcher Laptops Firehouse Subs $9,471 $0 Submitted E911 center is evacuated. Heritage Park Dog Boyd Foundations Requested funding to purchase new agility and play equipment as well as 05/30/19 $12,045 $0 Submitted Park Enhancement Dog Park Dash amenities for Heritgage dog park  Investment Report Fiscal Year 2019 As of May 31, 2019 ISSUER NAME PAR VALUE CUSIP COUPON RATE LOCAL GOVERNMENT INVESTMENT POOL SELF-INSURANCE $ 581,663 2.400 CAPITAL PROJECTS FUNDS 1,775,188 2.400 INVESTMENT ACCOUNT 25,835,911 2.400 2016 BOND ISSUANCE 1,646,330 2.400 2.400 LGIP TOTAL / AVERAGE $ 29,839,092 2.400 CAPITAL PROJECTS SELF-INSURANCE 2016 BOND ISSUANCE FUNDS INVESTMENT ACCOUNT YIELD TO PAR VALUE CUSIP MATURITY SYNOVUS - BANK OF NASHVILLE US Treasury - 4/30/19 $ 3,000,000 91282D23 2.031 Total Invested & Interest Earned to Maturity $ 3,000,000 $ 60,000  CDE Lightband Rolling 4 month Balance Sheet - Broadband Division May 31, 2019 5/31/18 % Change 5/31/19 4/30/19 3/31/19 2/28/19 Assets Current Assets: Cash -Operating Account $ 6,324,369.73 11.27% $ 7,036,975.69 $ 6,678,896.36 $ 6,395,156.46 $ 6,102,857.24 Accounts Receivable: Subscribers, less allowance 1,389,152.47 0.73% 1,399,344.55 1,476,076.20 1,485,372.14 1,498,883.69 Other 35,835.06 10.54% 39,612.87 41,652.55 47,129.93 51,292.24 Temporary advances - Electric 1,846,911.22 7.78% 1,990,576.44 1,921,410.78 1,964,469.08 1,836,145.14 Inventory 476,151.68 -11.66% 420,624.39 366,858.91 370,937.02 326,086.00 Total Current Assets $ 10,072,420.16 8.09% $ 10,887,133.94 $ 10,484,894.80 $ 10,263,064.63 $ 9,815,264.31 Noncurrent Assets: Construction Work In Progress $ 401,713.64 -93.60% $ 25,715.22 $ 7,142.38 $ 343,259.55 $ 292,982.32 Telecommunications Plant 7,764,442.61 7.00% 8,307,995.07 8,329,388.74 8,103,807.82 8,113,343.49 Accumulated Depreciation (5,853,280.92) -6.23% (5,488,565.02) (5,470,736.47) (5,506,657.72) (5,507,932.55) Deferred Debit - Unamortized Software 251,056.89 45.49% 365,257.08 389,721.70 295,785.16 219,630.26 Total Noncurrent Assets $ 2,563,932.22 25.21% $ 3,210,402.35 $ 3,255,516.35 $ 3,236,194.81 $ 3,118,023.52 Total Assets $ 12,636,352.38 11.56% $ 14,097,536.29 $ 13,740,411.15 $ 13,499,259.44 $ 12,933,287.83 Retained Earnings and Liabilities: Retained Earnings (Deficit): Retained Earnings - Beginning of Year $ (6,637,623.19) -54.63% $ (3,011,499.48) $ (3,011,499.48) $ (3,011,499.48) $ (3,011,499.48) Retained Earnings - YTD 3,211,018.86 5.26% 3,380,057.74 3,007,341.54 2,562,665.52 2,158,913.06 Retained Earnings - Current 357,096.79 -25.95% 264,412.40 372,716.20 444,676.02 403,752.46 Total Retained Earnings (Deficit) $ (3,069,507.54) -120.62% $ 632,970.66 $ 368,558.26 $ (4,157.94) $ (448,833.96) Current Liabilities: Accounts Payable $ 1,869,485.12 11.89% $ 2,091,746.69 $ 2,027,253.49 $ 2,018,271.51 $ 1,845,634.94 Unearned Revenue $ 614,895.42 -0.95% $ 609,040.12 $ 609,040.12 $ 609,040.12 $ 609,040.12 Other Accrued Payables 185,572.30 -31.41% 127,276.33 97,963.79 237,812.87 288,456.46 Total Current Liabilities $ 2,669,952.84 5.92% $ 2,828,063.14 $ 2,734,257.40 $ 2,865,124.50 $ 2,743,131.52 Noncurrent Liabilities: Customer Deposits $ 4,663.87 -48.57% $ 2,398.81 $ 2,794.42 $ 2,794.42 $ 2,794.42 Postretirement Benefits 185,312.08 78.17% 330,178.55 330,875.94 331,573.33 332,270.72 Deferred Inflows of Resources - 7,994.00 7,994.00 7,994.00 7,994.00 Long Term Debt to the Electric Division 12,845,931.13 -19.85% 10,295,931.13 10,295,931.13 10,295,931.13 10,295,931.13 Total Noncurrent Liabilities $ 13,035,907.08 -18.41% $ 10,636,502.49 $ 10,637,595.49 $ 10,638,292.88 $ 10,638,990.27 Total Liabilities $ 15,705,859.92 -14.27% $ 13,464,565.63 $ 13,371,852.89 $ 13,503,417.38 $ 13,382,121.79 Total Liabilities & Retained Earnings $ 12,636,352.38 11.56% $ 14,097,536.29 $ 13,740,411.15 $ 13,499,259.44 $ 12,933,287.83  CDE Lightband Income Statement - Broadband Division 5/31/2019 % 5/31/18 Change 5/31/19 4/30/19 3/31/19 2/28/19 Operating Revenue: Programming Revenue $ 416,574.59 -0.58% $ 414,139.37 $ 420,739.22 $ 421,881.72 $ 423,695.23 Internet Revenue 1,057,845.08 10.82% 1,172,347.01 1,182,987.65 1,159,064.10 1,154,744.65 Telephone Revenue 152,572.39 -2.37% 148,950.05 147,696.25 145,749.93 145,278.19 Miscellaneous Fee Revenue 139,326.56 15.62% 161,093.13 130,569.56 182,748.87 145,904.98 Total Operating Revenues 1,766,318.62 7.37% 1,896,529.56 1,881,992.68 1,909,444.62 1,869,623.05 Cost of Programming & Services 680,350.36 1.93% 693,505.25 702,240.31 713,862.44 705,335.32 Gross Revenue: $ 1,085,968.26 10.78% $ 1,203,024.31 $ 1,179,752.37 $ 1,195,582.18 $ 1,164,287.73 Operating Expenses: Network Support Expense-Video $ 37,403.56 4.70% $ 39,162.84 $ 42,214.99 $ 34,796.25 $ 37,783.51 Network Support Expense-Internet 122,589.76 9.38% 134,091.54 133,697.99 131,545.40 132,319.86 Network Support Expense-Phone 16,142.06 -3.08% 15,644.72 19,773.42 15,681.56 15,761.38 Network Admin. & Oper. Expense 100,688.56 10.92% 111,682.30 114,876.78 104,512.44 103,590.46 Building & Office Expense 8,047.00 0.00% 8,047.00 8,047.00 8,047.00 8,047.00 Depreciation & Amortization Expense 63,310.41 23.02% 77,884.77 71,868.17 66,807.58 63,894.99 General & Administrative Expense 166,864.90 51.26% 252,400.10 186,361.04 148,633.31 158,673.34 Station Apparatus Expense 106,325.63 55.48% 165,312.83 113,256.85 117,414.03 98,401.78 Customer Service Expense 53,191.34 1.22% 53,839.97 57,247.96 50,226.60 54,909.62 Marketing Expense 45,800.17 46.05% 66,889.61 45,972.76 58,109.46 71,473.04 Total Operating Expenses $ 720,363.39 28.40% $ 924,955.68 $ 793,316.96 $ 735,773.63 $ 744,854.98 Operating Income (Loss) $ 365,604.87 -23.94% $ 278,068.63 $ 386,435.41 $ 459,808.55 $ 419,432.75 Interest Expense 908.91 1064.38% 10,583.14 10,646.12 12,059.44 12,607.20 Other Expenses - Tax Equivalent 7,599.17 -59.56% 3,073.09 3,073.09 3,073.09 3,073.09 Other Expense - Loss on Retirement of Equipment $ - $ - $ - $ - $ - Total Other Expenses (Income) $ 8,508.08 60.51% $ 13,656.23 $ 13,719.21 $ 15,132.53 $ 15,680.29 Net Income (Loss) $ 357,096.79 -25.95% $ 264,412.40 $ 372,716.20 $ 444,676.02 $ 403,752.46 EBITDA $ 428,915.28 $ 355,953.40 $ 458,303.58 $ 526,616.13 $ 483,327.74  CDE Lightband Cash Flow Statement - Broadband Division May 31, 2019 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income (loss) $ 278,068.63 Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 77,884.77 Changes in: Accounts receivable 78,771.33 Advances to Electric (69,165.66) Inventory (53,765.48) Accounts payable 64,493.20 Accrued expenses 28,615.15 Customer deposits (395.61) Other 10,808.39 Net Cash Provided by Operating Activities 415,314.72 CASH FLOWS FROM FINANCING ACTIVITIES: Payment of long term debt - Additions to plant (57,235.39) Net Cash Used by Financing Activities (57,235.39) NET INCREASE IN CASH AND CASH EQUIVALENTS $ 358,079.33 CASH AND CASH EQUIVALENTS - BEG OF MONTH 6,678,896.36 CASH AND CASH EQUIVALENTS - END OF MONTH $ 7,036,975.69  CDE Lightband Rolling 4 Month Balance Sheet - Electric Division May 31, 2019 Prior Year Prior 3 Months 5/31/2018 % Change 5/31/2019 4/30/2019 3/31/2019 2/28/2019 UTILITY PLANT 1 Electric Plant $ 278,312,350.27 6.08% $ 295,227,234.01 $ 294,159,330.49 $ 292,550,677.10 $ 291,336,391.35 2 Less Depreciation (95,742,051.75) 6.98% (102,422,474.12) (102,470,225.97) (101,576,474.00) (100,569,108.29) 3 Total $182,570,298.52 5.61% $192,804,759.89 $191,689,104.52 $190,974,203.10 $190,767,283.06 4 Unamortized acq. adj. 111,167.61 -32.43% 75,113.25 78,117.78 81,122.31 84,126.84 6 Total Plant - Net $182,681,466.13 5.58% $192,879,873.14 $191,767,222.30 $191,055,325.41 $190,851,409.90 OTHER PROPERTY AND INVESTMENTS 8 Interdivisional loan 12,845,931.13 -19.85% 10,295,931.13 10,295,931.13 10,295,931.13 10,295,931.13 9 Sinking Funds 10,869,509.99 -14.24% 9,321,156.73 7,319,195.81 7,317,283.82 7,315,540.54 12 Other Special Funds - - - - - 13 Total 23,715,441.12 -17.28% 19,617,087.86 17,615,126.94 17,613,214.95 17,611,471.67 CURRENT AND ACCRUED ASSETS 14 General Cash/temp cash investments 12,414,552.93 -47.67% 6,497,046.27 8,546,279.00 8,950,456.93 10,221,359.98 14.1 Reserved Cash 25,193,874.12 10.91% 27,942,463.35 27,729,934.58 27,524,582.37 27,246,140.69 15 Accounts Receivable 11,678,792.22 -9.06% 10,620,121.08 11,141,408.62 13,169,823.61 15,478,704.15 16 Materials and Supplies 3,056,843.17 1.31% 3,096,891.73 3,554,128.96 4,223,878.91 4,226,333.22 18 Other Current Assets 16,103,208.05 31.21% 21,129,794.51 22,956,192.60 21,924,118.94 20,637,299.41 19 Total 68,447,270.49 1.23% 69,286,316.94 73,927,943.76 75,792,860.76 77,809,837.45 DEFERRED DEBITS 22 Clearing Accounts - - - - - 24 Energy Service Loans Rec 3,791,219.59 -30.85% 2,621,512.29 2,724,630.39 2,803,716.27 2,894,224.26 26 Other Deferred Debits 3,802,020.97 7.13% 4,073,226.28 4,113,821.25 4,020,621.88 4,022,203.12 27 Total 7,593,240.56 -11.83% 6,694,738.57 6,838,451.64 6,824,338.15 6,916,427.38 28 TOTAL ASSETS & OTHER DEBITS $282,437,418.30 2.14% $288,478,016.51 $290,148,744.64 $291,285,739.27 $293,189,146.40 CAPITAL EARNINGS REINVESTED IN SYSTEM ASSETS 33 Beginning of year 164,090,426.23 4.81% 171,989,065.77 171,989,065.77 171,989,065.77 171,989,065.77 34 Current Year to Date 7,948,198.94 24.22% 9,873,382.35 10,891,161.64 10,136,862.95 9,458,297.62 35 Total 172,038,625.17 5.71% 181,862,448.12 182,880,227.41 182,125,928.72 181,447,363.39 Long Term Debt 39.1 Bonds and other Long Term Debt 65,570,000.00 -4.53% 62,600,000.00 62,600,000.00 62,600,000.00 62,600,000.00 40 Debt Premium and discount 8,674,604.94 -6.84% 8,081,384.94 8,130,819.94 8,180,254.94 8,229,689.94 41 Total 74,244,604.94 -4.80% 70,681,384.94 70,730,819.94 70,780,254.94 70,829,689.94 OTHER NON-CURRENT LIABILITIES 41.9 Post Retirement Benefits 548,947.03 159.05% 1,422,065.23 1,424,025.22 1,426,933.75 1,429,274.74 42 Energy Service Loans - Advances 3,926,228.76 -30.25% 2,738,445.43 2,818,021.45 2,910,838.41 2,984,524.87 44 Total 4,475,175.79 -7.03% 4,160,510.66 4,242,046.67 4,337,772.16 4,413,799.61 CURRENT AND ACCRUED LIABILITIES 46 Accounts Payable 21,776,786.70 -0.72% 21,619,869.84 22,306,612.03 24,316,478.95 27,049,019.35 47 Customer Deposits 6,300,687.08 8.12% 6,812,612.83 6,811,746.57 6,778,295.06 6,688,061.91 52.2 Interest Accrued - Other 1,185,549.41 -45.17% 650,078.10 433,385.40 216,692.70 - 53 Other Current Liabilities 2,415,989.21 11.39% 2,691,112.02 2,743,906.62 2,730,316.74 2,761,212.20 54 Total 31,679,012.40 0.30% 31,773,672.79 32,295,650.62 34,041,783.45 36,498,293.46 58 TOTAL LIABILITIES AND OTHER CREDITS $ 282,437,418.30 2.14% $ 288,478,016.51 $ 290,148,744.64 $ 291,285,739.27 $ 293,189,146.40  CDE Lightband Revenues and Expenses ‐ Electric Division 5/31/2019 Prior Year Prior 3 Months 5/31/2018 % Change 5/31/2019 4/30/2019 3/31/2019 2/28/2019 OPERATING REVENUE 59 Electric Sales Revenue 12,301,351.95 ‐1.53% 12,112,702.98 11,659,084.31 14,020,216.92 16,038,269.91 60 Revenue from Late Payments 96,713.31 1.74% 98,399.71 113,893.12 124,797.16 128,203.81 61 Misc Service Revenue 149,498.09 ‐29.24% 105,781.12 119,138.51 93,527.62 123,122.65 62 Rent from Electric Property 395,279.51 ‐36.31% 251,744.75 252,049.47 309,012.29 407,159.86 63 Other Electric Revenue 6.51 ‐37.33% 4.08 1.96 0.28 1.45 64 Total Operating Revenue 12,942,849.37 ‐2.89% 12,568,632.64 12,144,167.37 14,547,554.27 16,696,757.68 PURCHASED POWER 65 Total Power Cost 10,186,767.30 ‐4.28% 9,750,606.07 7,889,445.54 10,853,854.40 10,038,990.89 OPERATING EXPENSE 66 Transmission Expense 2,847.63 31.93% 3,756.76 3,135.99 3,459.77 3,656.29 67 Distribution Expense 469,887.49 ‐29.75% 330,073.82 381,159.02 291,602.77 368,893.93 68 Customer Accounts Expense 365,968.49 ‐19.28% 295,395.83 575,265.95 256,281.53 392,205.57 69 Cust. Service and Inf. Exp. 24,659.72 13.71% 28,041.38 25,791.64 20,729.73 28,162.44 70 Sales Expense 12,479.00 ‐16.55% 10,414.13 10,914.04 9,325.37 12,267.36 71 Admin. And General Expense 268,233.37 201.42% 808,521.86 327,814.94 294,598.63 340,289.92 72 Operating Expense 1,144,075.70 29.03% 1,476,203.78 1,324,081.58 875,997.80 1,145,475.51 MAINTENANCE EXPENSE 73 Transmission Expense 1,711.98 46.46% 2,507.33 1,963.35 3,523.48 2,794.06 74 Distribution Expense 333,605.81 26.70% 422,670.58 312,275.09 253,994.08 301,635.00 75 Admin. and General Expense 79,241.61 186.86% 227,314.21 153,771.44 192,469.39 184,433.36 76 Maintenance Expense 414,559.40 57.39% 652,492.12 468,009.88 449,986.95 488,862.42 OTHER OPERATING EXPENSE 77 Depreciation Expense 987,223.85 5.09% 1,037,492.49 1,028,126.70 1,024,020.52 1,023,988.76 78 Amort. of Acquisition Adjust. 3,004.53 0.00% 3,004.53 3,004.53 3,004.53 3,004.53 79 Taxes and Tax Equivalents 543,271.98 2.39% 556,243.27 559,686.27 551,927.92 551,808.29 80 Total other oper. Expense 1,533,500.36 4.12% 1,596,740.29 1,590,817.50 1,578,952.97 1,578,801.58 Total operating expense and 81 purchased power 13,278,902.76 1.48% 13,476,042.26 11,272,354.50 13,758,792.12 13,252,130.40 INCOME 82 Operating Income (336,053.39) 170.02% (907,409.62) 871,812.87 788,762.15 3,444,627.28 83 Other Income 42,390.47 81.62% 76,987.79 70,276.26 77,124.23 72,185.15 84 Total Income (293,662.92) 182.78% (830,421.83) 942,089.13 865,886.38 3,516,812.43 85 Misc Income Deductions ‐ ‐ (500.00) ‐ ‐ 86 Net Income before debt expense (293,662.92) 182.78% (830,421.83) 941,589.13 865,886.38 3,516,812.43 DEBT EXPENSE 90 Interest on Long Term Debt 209,926.91 12.07% 235,270.09 235,270.09 235,270.09 197,728.63 92 Other Interest Expense 1,505.68 1.11% 1,522.37 1,455.35 1,485.96 1,408.62 93 Amort. of Debt Disc. and Exp. ‐ ‐ ‐ ‐ ‐ 94 Amort. of Prem. on Debt (49,435.00) 0.00% (49,435.00) (49,435.00) (49,435.00) (49,435.00) 95 Total Debt Expense 161,997.59 15.65% 187,357.46 187,290.44 187,321.05 149,702.25 NET INCOME 96 Income before Extraord. Items (455,660.51) 123.36% (1,017,779.29) 754,298.69 678,565.33 3,367,110.18 97 Extraordinary Items ‐ ‐ ‐ ‐ ‐ 98 Net Income (455,660.51) 123.36% (1,017,779.29) 754,298.69 678,565.33 3,367,110.18  CDE Lightband Cash Flow Statement - Electric Division May 31, 2019 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income $ (907,409.62) Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 1,040,497.02 Changes in: Accounts receivable 521,287.54 Materials and supplies 457,237.23 Interdivisional loan - Accounts receivable - TVA Energy Service Loans 103,118.10 Advances - TVA Energy Service Loans (79,576.02) Prepayments - Other current assets 1,756,623.39 Accounts payable (686,742.19) Accrued expenses 216,692.70 Customer deposits 866.26 Other postemployment benefits (1,959.99) Other (52,794.60) Net Cash provided by Operating Activities 2,367,839.82 CASH FLOWS FROM FINANCING ACTIVITIES: Additions to plant (2,153,147.86) Payment of long-term debt (49,435.00) Net Cash used by Financing Activities (2,202,582.86) NET DECREASE IN CASH AND CASH EQUIVALENTS $ 165,256.96 CASH AND CASH EQUIVALENTS - BEG OF MONTH 43,595,409.39 CASH AND CASH EQUIVALENTS - END OF MONTH $ 43,760,666.35 CASH AND CASH EQUIVALENTS CONSIST OF: Sinking Funds 9,321,156.73 Construction Funds - General cash/temp cash investments 6,497,046.27 Reserved Cash 27,942,463.35 $ 43,760,666.35 CDE Lightband Subscriber Analysis March 2019 - May 2019 Month End Reports March 2019 April 2019 Net Gain % Growth Over Growth March % Year March March March Prev. to 2018 over April April April Service Actual Budget Variance Month Budget Actual Year Actual Budget Variance Video ( 5,303) ( 6,064) ( (761) ( (8) -13% ( 5,768) -8% ( 5,246) ( 6,064) ( (818) LB Basic ( 361) ( 364) ( (3) ( 5) -1% ( 346) 4% ( 367) ( 364) ( 3) LB Plus ( 1,815) ( 1,819) ( (4) ( 13) 0% ( 1,732) 5% ( 1,811) ( 1,820) ( (9) LB Extra ( 3,089) ( 3,881) ( (792) ( (26) -20% ( 3,641) -15% ( 3,032) ( 3,882) ( (850) Bronze Pkg ( 2) ( 4) ( (2) ( - ) -50% ( 4) -50% ( 2) ( 4) ( (2) Silver Pkg ( 2) ( 3) ( (1) ( - ) -33% ( 3) -33% ( 2) ( 3) ( (1) Gold Pkg ( 34) ( 43) ( (9) ( - ) -21% ( 42) -19% ( 32) ( 43) ( (11) Internet ( 19,607) ( 19,582) ( 25) ( 219) 0% ( 18,350) 7% ( 19,645) ( 19,692) ( (47) Phone ( 2,554) ( 2,720) ( (166) ( (13) -6% ( 2,644) -3% ( 2,551) ( 2,725) ( (174) Comm Internet ( 1,510) ( 1,631) ( (121) ( 13) -7% ( 1,435) 5% ( 1,523) ( 1,654) ( (131) Broadband ONTs ( 22,107) ( 22,161) ( (54) ( 192) 0% ( 20,810) 6% ( 22,132) ( 22,271) ( (139) April 2019 May 2019 Net Gain % Growth Net Gain % Growth Over Growth April % Year Over Growth % Year Prev. to 2018 over May May May Prev. to May 2018 over Month Budget Actual Year Actual Budget Variance Month Budget Actual Year ( (57) -13% ( 5,731) -8% ( 5,220) ( 5,546) ( (326) ( (26) -6% ( 5,680) -8% ( 6) 1% ( 354) 4% ( 372) ( 364) ( 8) ( 5) 2% ( 355) 5% ( (4) 0% ( 1,763) 3% ( 1,834) ( 1,818) ( 16) ( 23) 1% ( 1,760) 4% ( (57) -22% ( 3,567) -15% ( 2,979) ( 3,878) ( (899) ( (53) -23% ( 3,518) -15% ( - ) -50% ( 4) -50% ( 2) ( 4) ( (2) ( - ) -50% ( 4) -50% ( - ) -33% ( 2) 0% ( 2) ( 3) ( (1) ( - ) -33% ( 2) 0% ( (2) -26% ( 41) -22% ( 31) ( 43) ( (12) ( (1) -28% ( 41) -24% ( 38) 0% ( 18,399) 7% ( 19,674) ( 19,792) ( (118) ( 29) -1% ( 18,410) 7% ( (3) -6% ( 2,633) -3% ( 2,548) ( 2,743) ( (195) ( (3) -7% ( 2,629) -3% ( 13) -8% ( 1,448) 5% ( 1,536) ( 1,674) ( (138) ( 13) -8% ( 1,453) 6% ( 25) -1% ( 20,859) 6% ( 22,213) ( 22,371) ( (158) ( 81) -1% ( 20,920) 6%  ORDINANCE 1-2019-20 AN ORDINANCE ACCEPTING THE DONATION OF CERTAIN REAL PROPERTY FROM THE INDUSTRIAL DEVELOPMENT BOARD TO THE CITY OF CLARKSVILLE FOR THE PURPOSE OF A WATER STORAGE TANK WHEREAS, The Industrial Development Board has agreed to donate certain real property and ingress/egress easement to the City of Clarksville for the operation of an existing water tank; and WHEREAS, the Clarksville City Council has determined that it is in the best interest of the City and its residents that the donation from the Industrial Development Board be accepted with appreciation. NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF CLARKSVILLE, TENNESSEE: 1. That the City of Clarksville hereby accepts the donation of certain real property and ingress/egress easement from the Industrial Development Board, being a portion of the property conveyed to donor by deeds of record in Official Record Book Volume 1262, Page 2490 & Volume 1244, Page 2574, in the Register’s Office for Montgomery County, Tennessee, and being more particularly described in “Exhibit A”, attached hereto. 2. That upon acceptance of transfer documents, the City will assume ownership and responsibility for said property and easement. 3. That this Ordinance shall be in full force and effect from and after its passage and approval. FIRST READING: SECOND READING: EFFECTIVE DATE:  ORDINANCE 1-2019-20 EXHIBIT A Land Description of the Industrial Development Board of Montgomery County Property Jim Johnson Road, Clarksville, TN 37043 Being a portion of the Industrial Development Board of Montgomery County Property in the 1​st Civil District of Montgomery County, Tennessee, said property being a portion of Tax Map # 015, Parcel # 003.01 (Volume 1262 Page 2490), and of Tax Map # 009, Parcel # 014.02 Volume (ORV) 1244 Page (PG) 2574, all recorded in the Register’s Office of Montgomery County, Tennessee (ROMCT), said property is generally bounded on the west and south by Jim Johnson Road, and on the north by Life is Good Road. Being more particularly described as follows: Commencing at a set ½” iron pin capped “DBS & Associates” located at Tennessee State Plane coordinates (NAD 83) coordinates of Northing 838556.71, Easting 1600845.50 in the eastern right of way of Jim Johnson Road. Said POINT OF BEGINNING being South 20°31’10” West a distance of 101.29 feet from the southwest corner of the Industrial Development Board of Montgomery County Property ORV 1855 PG 2267. Thence leaving said right of way of Jim Johnson Road and with the said southern proposed right of way (ROW) of Life is Good Road, South 81°00’14” East a distance of 304.81 feet to a new iron rod capped “DBS & Assoc.”. Thence leaving said ROW on four new severance lines (NSL) as follows: South 29°55’19” West a distance of 45.07 feet to a new iron rod capped “DBS & Assoc.”; thence, North 83°12’33” West a distance of 78.18 feet to a new iron rod capped “DBS & Assoc.”; thence, generally, one-foot East of a fence line, South 05°36’07” West a distance of 270.36 to an iron rod capped “DBS & Assoc.”; thence, approximately one-foot south of the fence line, North 82°23’25” West a distance of 257.56 to an new iron rod capped “DBS & Assoc.” in said East ROW of Jim Johnson Road; Thence, North 19°53’31” East a distance of 83.34 feet to a point; Thence, North 12°42’56” East a distance of 234.37 feet to a point; Thence, North 08°12’34” East a distance of 5.51 feet to said POINT OF BEGINNING, containing 76,492.19 SQ FT or 1.76 acres more or less. Together with and subject to any easements, covenants, right of ways, and conveyances that are of record and not of record. According to a survey by W. Logan McCraw, TN RLS#2887 of DBS Engineering & Associates, Job # CC 98231, dated June 17, 2019.  ORDINANCE 1-2019-20 Ingress and Egress Easement Commencing at a set ½” iron pin capped “DBS & Associates” located in the eastern right of way of Jim Johnson Road, said pin being in the southwest corner of the Water Tower Boundary. Said pin having Tennessee State Plane Coordinates Northing 838244.27, Easting 1600764.77. Thence, leaving said iron pin South 82°23’25” East at a distance of 60.09 feet to the northwest corner and the true point of beginning for this description. Thence, with South boundary South 82°23’25” East at a distance 10.00 feet to a point, also the width of the Ingress/Egress easement; Thence South 07°15’34” West at a distance of 44.32 feet to a point; Thence along a curve to the right having a radius of 35.00 feet, a delta of 090°00’00”, an arc distance of 54.98, a chord bearing of South 52° 15’34” and a chord distance of 49.50 feet to a point; Thence, North 82°44’26” West at a distance of 52.96 feet to a point in the east right of way of Jim Johnson Road; Thence, with Jim Johnson Road, North 19°53’31” East at a distance of 10.25 feet to a point; Thence South 82°44’26” East at a distance of 50.72 feet to point being the start of a curve; Thence northeasterly an arc distance of 39.27 feet along a curve to the left having a radius of 25.00 feet, a delta of 090°00’00”, chord bearing of North 52°15’34” East and a chord distance of 35.36 feet to a point; Thence North 07°15’34” East at a distance of 44.38 feet to the point of beginning containing 1,433.12 SQ FT or 0.03 Acres more or less. Together with and subject to any easements, covenants, right of ways, and conveyances that are of record and not of record. According to a survey by W. Logan McCraw, TN RLS#2887 of DBS Engineering & Associates, Job # CC 98231, dated June 17, 2019.  ORDINANCE 2-2019-20 AN ORDINANCE AUTHORIZING PURCHASE OF PROPERTY AT 111 CUNNINGHAM LANE FOR THE CITY OF CLARKSVILLE GAS & WATER DEPARTMENT NORTH SERVICE CENTER WHEREAS, property acquisition is necessary for the relocation of the City of Clarksville Gas & Water Department North Service Center; and WHEREAS, the City of Clarksville Gas & Water Department has agreed to purchase property located at 111 Cunningham Lane from First Tennessee Bank National Association for the price of $435,000.00 plus additional cost and closing fees. NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF CLARKSVILLE, TENNESSEE: That the Clarksville City Council hereby authorizes the purchase of property at 111 Cunningham Lane (CMAP 43, Parcel 1.01) for the City of Clarksville Gas & Water Department North Service Center, not to exceed $445,000.00. FIRST READING: SECOND READING: EFFECTIVE DATE:  ORDINANCE 2-2019-20 EXHIBIT A  ORDINANCE 3-2019-20 AN ORDINANCE AUTHORIZING PURCHASE OF PROPERTY FOR CLARKSVILLE GAS & WATER’S NEW MEADOWBROOK SEWER PUMP STATION EQUALIZATION BASIN WHEREAS, property acquisition is necessary to construct a new equalization basin for the new Meadowbrook Sewer Pump Station; and WHEREAS, the City of Clarksville Gas & Water Department has agreed to purchase property located at Fort Campbell Boulevard from Baggett & Harvey and Mehigan Family Partnership for the price of $481,000.00 plus any additional costs and closing fees. NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF CLARKSVILLE, TENNESSEE: That the Clarksville City Council hereby authorizes purchase of property at Fort Campbell Boulevard (CMAP 43J, Parcel 30.00) for the new Meadowbrook Sewer Pump Station Equalization Basin, not to exceed $491,000.00. FIRST READING: SECOND READING: EFFECTIVE DATE:  ORDINANCE 3-2019-20 EXHIBIT A  RESOLUTION 2-2019-20 A RESOLUTION AUTHORIZING AN INTERLOCAL AGREEMENT BETWEEN THE CITY OF CLARKSVILLE, TENNESSEE AND THE E911 EMERGENCY COMMUNICATION DISTRICT OF MONTGOMERY COUNTY, TENNESSEE BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF CLARKSVILLE, TENNESSEE: That the Clarksville City Council hereby authorizes an interlocal agreement, effective July 1, 2019 through June 30, 2020, attached hereto as Exhibit A, between the City of Clarksville, Tennessee, and the Emergency Communication District of Montgomery County, Tennessee. ADOPTED:  ORDINANCE 4-2019-20 AN ORDINANCE AUTHORIZING THE MAYOR, OR HIS DESIGNEE, TO CONDUCT NEGOTIATIONS AND TO ENTER AN AGREEMENT FOR PURCHASE OF EASEMENTS AND/OR RIGHTS OF WAY, OR SHOULD NEGOTIATIONS FAIL, TO PURSUE CONDEMNATION THROUGH USE OF EMINENT DOMAIN FOR ACQUISITION OF PROPERTY FOR A PUBLIC PURPOSE FOR SPOT INTERSECTION IMPROVEMENTS FOR THE TRENTON ROAD AND MERIWETHER ROAD PROJECT, THE TYLERTOWN-OAKLAND ROAD IMPROVEMENTS PROJECT, AND THE WHITFIELD ROAD IMPROVEMENTS PROJECT WHEREAS, the Clarksville City Council finds that improvements to roads and intersections within the City are a vital component to the proper function of the transportation system and enhanced quality of life for city residents; and WHEREAS, the Clarksville City Council finds it to be in the public interest to acquire easements and / or right of way rights for the purpose of constructing improvements to Trenton Road and Meriwether Road, Tylertown Road and Oakland Road, and Whitfield Road and Needmore Road. NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF CLARKSVILLE, TENNESSEE: That the Mayor, acting through the City Attorney or his designee, may negotiate and enter into an agreement for the purchase of any necessary property rights from affected property owners for the Spot Intersection Improvements for the Trenton Road And Meriwether Road Project, the Tylertown-Oakland Road Improvements Project, and the Whitfield Road Improvements Project, and further, that if agreement cannot be reached on a reasonable purchase price in a timely manner, then the Mayor, acting through the City Attorney or his designee, and on behalf of the City of Clarksville, is hereby authorized to exercise the right of eminent domain and institute a condemnation action in the appropriate court for acquisition of any necessary property rights from affected property owners for the Spot Intersection Improvements for the Trenton Road and Meriwether Road Project, the Tylertown-Oakland Road Improvements Project, and the Whitfield Road Improvements Project, ​and said negotiations, acquisitions, and /or exercise of the right of eminent domain should be performed in compliance with Tennessee Department of Transportation policies and the Federal Uniform Relocation Assistance and Real Property Acquisition Policies Act. ____________________________ Mayor ATTEST: _________________________ City Clerk FIRST READING: SECOND READING: EFFECTIVE DATE:  RESOLUTION 1-2019-20 A RESOLUTION ASKING THE TENNESSEE DEPARTMENT OF TRANSPORTATION FOR IMPROVEMENTS TO SR374/WARFIELD BOULEVARD FROM SOUTH OF DUNBAR CAVE ROAD TO SR112/MADISON STREET WHEREAS, ​the ​Clarksville City Council is asking for improvements to SR374 to help provide for a more efficient and safer transportation corridor. This section of SR374 is already experiencing deficiency which has led to increased congestion, delay and potential environmental hazards; and WHEREAS, ​the travel time reliability analysis indicates the corridor is experiencing volumes exceeding capacity resulting in a poor level of service. Considering the projected traffic volumes are expected to continue to increase the level of service will continue to worsen; and WHEREAS, the intersection at Memorial Drive ranks number sixteen in the Top Twenty intersections with high crash frequency by collision type, 2012-2016; and WHEREAS, ​the proposed project will complete improvements to the final link in the northern circumferential By-Pass for Clarksville. Said project is included in the fiscally constrained roadway project list in the Clarksville Urbanized Area Metropolitan Planning Organization’s 2045 Metropolitan Transportation Plan; and WHEREAS, the Clarksville City Council is asking that a Technical Report be produced and funding be obligated in the Clarksville Urbanized Area Metropolitan Planning Organization’s Transportation Improvement Program for PE/Environmental in a timely manner. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF CLARKSVILLE, TENNESSEE: That the Mayor is hereby authorized to submit a request via the Clarksville Urbanized Area Metropolitan Planning Organization to the Tennessee Department of Transportation and improvements to SR374/Warfield Boulevard from south of Dunbar Cave Road to SR112/Madison Street and to execute all necessary documents in connection therewith on behalf of the City of Clarksville. ADOPTED: