The URL can be used to link to this page

CP 2021-07-22 (Budget)o I'll""' COFFELL Thursday, July 22, 2021 WES MAYS Mayor CLIFF LONG Place 1 DON CARROLL Place 3 KEVIN NEVELS Place 4 MIKE LAND City Manager City of Coppell, Texas Meeting Agenda City Council 6:00 PM Budget Workshop 255 E. Parkway Boulevard Coppell, Texas 75019-9478 2nd Floor Conference Room BRIANNA HINOJOSA-SMITH Mayor Pro Tem JOHN JUN Place 5 BIJU MATHEW Place 6 MARK HILL Place 7 As authorized by Section 418.016(e) of the Texas Government Code, on March 16, 2020, Governor Greg Abbott suspended various provisions that require government officials and members of the public to be physically present at a specified meeting location. The following requirements have been suspended by the governor: 1. A quorum of the city council need not be present at one physical location. Id. § 551.127(b). 2. In light of (1), above, the meeting notice need not specify where the quorum of the city council will be physically present and the intent to have a quorum present. Id. § 551.127(e). 3. In light of (1) above, the meeting held by videoconference call is not required to be open to the public at a location where council is present. Id. § 551.127(f). 4. The audio and video are not required to meet minimum standards established by Texas Department of Information Resources (DIR) rules, the video doesn't have to be sufficient that a member of the public can observe the demeanor of the participants, the members faces don't have to be clearly visible at all times, and the meeting can continue even if a connection is lost, so long as a quorum is still present. Id. § 551.127(a-3); (h); (i); Q). City of Coppell, Texas Page 1 Printed on 7/19/2021 City Council Meeting Agenda July 22, 2021 Notice is hereby given that the City Council of the City of Coppell, Texas will meet in a Budget Workshop on Thursday, July 22, 2021 at 6:00 p.m. in the 2nd Floor Conference Room of Town Center, 255 E. Parkway Boulevard, Coppell, Texas. As authorized bySection S51.071(2)ofthe Texas Government Code, this meeting may be convened into closed Executive Session for the purpose of seeking confidential legal advice from the City Attorney on any agenda item listed herein. The City of Coppell reserves the right to reconvene, recess or realign the Work Session or called Executive Session or order of business at any time prior to adjournment. The purpose mfthe meeting isboconsider the following items: Work Session (Open to the Public) 2nd Floor Conference Room i Call tmOrder II. Citizens' Appearance Debt Service Fund a. Assessed Valuation b. Revenue/ExpendituneGunnnnary Attachments: Debt Service Fun |Yf. Mayor and Council Budget Attachments: V. General Budget a. Revenue Summary b. Expenditure Summary o. Capital Outlay Attachments: General Fund Draft.pdf Yf|. General Discussion Vil. Citizens' Appearance Vill. Adjournment Wes Mays, Mayor City of Coppell, Texas Page 2 Printed on 711912021 City Council Meeting Agenda July 22, 2021 CERTIFICATE I certify that the above Notice of Meeting was posted on the bulletin board at the City Hall of the City of Coppell, Texas on this 19th day of July, 2021, at Ashley Owens, City Secretary PUBLIC NOTICE - STATEMENT FOR ADA COMPLIANCE AND OPEN CARRY LEGISLATION The City of Coppell acknowledges its responsibility to comply with the Americans With Disabilities Act of 1990. Thus, in order to assist individuals with disabilities who require special services (i.e. sign interpretative services, alternative audio/visual devices, and amanuenses) for participation in or access to the City of Coppell sponsored public programs, services and/or meetings, the City requests that individuals make requests for these services seventy-two (72) hours — three (3) business days ahead of the scheduled program, service, and/or meeting. To make arrangements, contact Kori Allen, ADA Coordinator, or other designated official at (972) 462-0022, or (TDD 1 -800 -RELAY, TX 1-800-735-2989). Pursuant to Section 30.06, Penal Code (trespass by license holder with a concealed handgun), a person licensed under Subchapter H, Chapter 411, Government Code (handgun licensing law), may not enter this property with a concealed handgun. Pursuant to Section 30.07, Penal Code (trespass by license holder with an openly carried handgun), a person licensed under Subchapter H, Chapter 411, Government Code (handgun licensing law), may not enter this property with a handgun that is carried openly. City of Coppell, Texas Page 3 Printed on 7/19/2021 C',P FE L File ID: 2021-5808 Version: 1 File Name: Debt Service Fund City of Coppell, Texas Master File Number: 2021-5808 Type: Agenda Item Reference: Title: Debt Service Fund a. Assessed Valuation b. Revenue/Expenditure Summary Notes: Sponsors: Attachments: Debt Service Fund Draft.pdf Contact: Drafter: Related Files: History of Legislative File 255 E. Parkway Boulevard Coppell, Texas 75019-9478 Status: Agenda Ready In Control: City Council File Created: 07/15/2021 Final Action: Enactment Date: Enactment Number: Hearing Date: Effective Date: Ver- Acting Body: Date: Action: Sent To: Due Date: Return Result: sion: Date: Text of Legislative File 2021-5808 Title Debt Service Fund a. Assessed Valuation b. Revenue/Expenditure Summary Summary City of Coppell, Texas Page 1 Printed on 7/19/2021 VALUATION BREAKDOWN REPORT 7/19/2021 2018 2019 2020 Category Taxable Value Difference %Chg.- Taxable Value Difference %Chg. - Taxable Value --------------------------- _______ ________ --------------- Comm/Ind 2,013,625,054 158,500,230 8.54% 2,151,911,375 138,286,321 6.87% 2,228 Residential 4,444,749,062 302,019,105 7.29% 4,597,309,191 152,560,129 3.43% 4 �,� ,105 Ag Land 43,236 16,017 58.84% 40,238 l ``+3is"j -6.93%31.416 Bus. Personal Prop. 1,132,339,429 130,135,857 12.98% 1,296,156,035 163,816,606 1 TOTAL 7,590,756,781 590,671,209 8.44% 8,045,416,839 454,660,058 5.99% Growth Break -Down New Construction: Residential Comm/Ind Bus. Personal Prop. Reappraisal: Comm/Ind Residential Bus. Personal Prop. Ag Land Total Growth 51,292,636 0.73% 30,605,300 0.44% 287,050 0.00% 127,894,930 1.834 250,726,469 3.58% 129,848,807 1.85% No2021 pence %Chg. Taxable Value - Difference - %Chg. 778,572 3.57% 2,374,742,429 146,052,482 6.55% 9"jj' 4 3.29% � 4,553,959,357 105,564,252 2.22% m. -21.92%39.559 8,143 25.92% 3,54 4% 1,563,513,286 151,533,711 10.73% 343,679,204 4.27% 8,792,254,631 403,158,588 4.81% 29,537,521 8.59% 21,170,880 6.16% 254,590,380 74.08% 55,607,692 16.18% 121,548,393 35.37% 1,1.3 ,,'hf-,W0) -40.38% 0.00% 343,679,204 4.27% 28,195,062 6.99% 23,619,990 5.86% 1,115,040 0.28% 122,432,492 30.37% 77,369,190 19.19% 150,418,671 37.31% 8,143 0.00% 403,158,588 4.81% DRAFT INFORMATION - For Internal Use Only - 1 2021 VALUATION ESTIMATES 5/14/2021 2021 Preliminary/Cert 9,417,268,280 2020 Certified Value 8,389,096,043 --------------------------- Valuation Increase 1,028,172,237 Percentage Growth 12.26% Est. Valuation at Taxable Value Est. % Certification Certification Growth 30 yr. Average Decline -5.55% 8,894,644,681 8,894,644,681 6.03% From Prelim. -to -Cert. Highest % Decline -11.64% 8,321,098,252 8,321,098,252 -0.81% Lowest % Decline -2.19% 9,211,030,105 / '% ', ,030,105 9.80% //i HISTORICAL DATA Tax Year 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994 1993 1992 1991 Original Prelim. Value Report ----------------------- 8,938,057,671 8,672,565,249 7,926,090,995 7,341,218,819 6,971,101, 268 6,442,331,517 6, 105,99 4,092 : 33 39 j 63 r 2,366 1, 799,855 /076,491,869 2,796,072,791 2,390,025,212 2,060,218,573 1,742,129,900 1,590,995,441 1, 385, 648, 294 1,159, 296,829 1,057,211,744 998,432,713 Certification Value011 Report ------- ------------ 8,389,096,043 1�7�416,839 JUI..2.176 05,750 4,883, 365,186 4,631,471,179 4, 247, 609,166 3,973,408,106 3,832,559,116 3,688,654,750 3,518,935,716 3,252,465,109 2,947,038,759 2,588,091,578 2,275,968,398 2,005,725,536 1,701,189,848 1,534,334,974 1,339,595,545 1,133,906, 263 999,174,080 953,241,850 Percent Change -- ------- 61,628) -6.14% -7.23% -4.23% (341,13 /f,�%7) -4.65% 169,233) -3.70% b15,092) -3.28% (428,713,357) -7.02% (192,807,481) -3.56% (135,047,375) -2.64% (157,350,049) -3.17% (226,370,858) -4.47% (284,877,971) -5.54% (327,246,960) -6.28% (564,345,974) -10.86% (428,526,403) -9.16% (434,750,454) -9.86% (260,387,817) -6.36% (244,953,713) -6.23% (463,376,650) -11.64% (359,334,746) -9.95% (129,453,110) -4.21% (207,981,213) -7.44% (114,056,814) -4.77% (54,493,037) -2.65% (40,940,052) -2.35% (56,660,467) -3.56% (46,052,749) -3.32% (25,390,566) -2.19% (58,037,664) -5.49% (45,190,863) -4.53% ---------------------------- Average -5.55% DRAFT INFORMATION - For Internal Use Only - 2 2021 VALUATION ESTIMATES 7/19/2021 2021 Preliminary/Cert 8,792,254,631 2020 Certified Value 8,389,096,043 --------------------------- Valuation Increase 403,158,588 Percentage Growth 4.81% Est. Valuation at Taxable Value Est. % Certification Certification Growth 30 yr. Average Decline -5.55% 8,304,316,981 8,304,316,981 -1.01% From Prelim. -to -Cert. Highest % Decline -11.64% 7,768,836,192 7768,836,192 -7.39% Lowest % Decline -2.19% 8,599,704,255 / '% 704,255 2.51% HISTORICAL DATA Tax Year 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994 1993 1992 1991 Original Prelim. Value Report ----------------------- 8,938,057,671 8,672,565,249 7,926,090,995 7,341,218,819 6,971,101, 268 6,442,331,517 6,105,99A 4,092 : 33 39 j 63 r 2,366 1, 799,855 /076,491,869 2,796,072,791 2,390,025,212 2,060,218,573 1,742,129,900 1,590,995,441 1, 385, 648, 294 1,159, 296,829 1,057,211,744 998,432,713 Certification Value011 Report ------- ------------ 8,389,096,043 1�7�416,839 JUI..2.176 05,750 4,883, 365,186 4,631,471,179 4, 247, 609,166 3,973,408,106 3,832,559,116 3,688,654,750 3,518,935,716 3,252,465,109 2,947,038,759 2,588,091,578 2,275,968,398 2,005,725,536 1,701,189,848 1,534,334,974 1,339,595,545 1,133,906, 263 999,174,080 953,241,850 Percent Change -- ------- 61,628) -6.14% -7.23% -4.23% (341,13 /f,�%7) -4.65% 169,233) -3.70% b15,092) -3.28% (428,713,357) -7.02% (192,807,481) -3.56% (135,047,375) -2.64% (157,350,049) -3.17% (226,370,858) -4.47% (284,877,971) -5.54% (327,246,960) -6.28% (564,345,974) -10.86% (428,526,403) -9.16% (434,750,454) -9.86% (260,387,817) -6.36% (244,953,713) -6.23% (463,376,650) -11.64% (359,334,746) -9.95% (129,453,110) -4.21% (207,981,213) -7.44% (114,056,814) -4.77% (54,493,037) -2.65% (40,940,052) -2.35% (56,660,467) -3.56% (46,052,749) -3.32% (25,390,566) -2.19% (58,037,664) -5.49% (45,190,863) -4.53% ---------------------------- Average -5.55% DRAFT INFORMATION - For Internal Use Only - 3 Estimated Ad Valorem Tax Collections and Proposed Distribution Fiscal Year 2021-22 Assessed Valuation for 2021-22 Proposed Tax Rate Revenue from 2021-22 Taxes Estimated Collections Total Estimated Funds Available General Fund Bonded Indebtedness $ 8,389,096,043 0.580000 48,656,757 jj 100.00% 48,656,757 Proposed Distribution of Tax Collectiof / ATE PERCENTAGE /ER$100 80.48% $ 19.52% j 44 46 0 � �%%%%iaP.5800 „ $ 39,156, 609 9,500,148 48,656,757 DRAFT INFORMATION - For Internal Use Only - 4 Debt Service Fund Summary The mission of the Debt Service Fund is to account for the payment of principal and interest on the City's general obligation debt. Revenues come mostly from the interest and sinking portion of the property tax rate and can only be used to make the principal and interest payments on the debt. Services Actual Adopted FY 21 Budget„ FY 22 Budget Description 2019-20 2020-21 Amended Proposed Ad Valorem Taxes -Current $ 8,662,921 $ 8,290,272 $ 8,290,272 $ 9,500,148 Ad Valorem Taxes -Delinquent 31,727 0 0 10,000 Property Tax P & 1 21,741 30,000' 30,000 20,000 Interest Income 24,826 40,000 40,000 10,000 Total Revenue $ 8,741,215 $ 8,360,272 $ 8,360,272 $ 9,540,148 Services $ 8,630,429 $; 8,839,805 $ , 8,839,805 $ 9,540,186 Total Expenditure $ 8,630,429 $ 8,839,805 $ 8,839,805 $ 9,540,186 Fund Balance B E 3,773 $ 1,074,559 $ 1,074,559 $ 595,026 559 $ 595,026 $ 595,026 $ 594,988 2021-22 Expenditures DRAFT INFORMATION - For Internal Use Only - 5 Summary Requirements for Principal and Interest Retirements Year Principal Interest Total 2022 6,675,000.00 2,855,186.00 9,530,186.00 2023 6,505,000.00 2,630,136.00 9,135,136.00 2024 6,675,000.00 2,292,000.00 8,967,000.00 2025 5,845,000.00 2,034,900.00 7,879,900.00 2026 5,975,000.00 1,806,850.00 7,781,850.00 2027 5,565,000.00 1,580,425.00 7,145,425.00 2028 5,300,000.00 1,368,225.00 6,668,225.00 2029 4,235,000.00 1,179,125.00 5,414,125.00 2030 4,415,000.00 11000,300.00 5,415,300.00 2031 4,585,000.00 830,187.50 5,415,187.50 2032 3,810,000.00 698,540.63 4,508,540.63 2033 3,915,000.00 584,068.76 4,499,068.76 2034 3,335,000.00 475,871.88 3,810,871.88 2035 3,425,000.00 382,434.38 3,807,434.38 2036 3,525,000.00'; 288,093.76 3,813,093.76 2037 2,865,000.00 200,531.26 3,065,531.26 2038 2,945,000.00 124,437.51 3,069,437.51 2039 1,770,000.00' 70,406.26 1,840,406.26 2040 1,805,000.00: 36,296.88 1,841,296.88 2041 940,000.00' 9,400.00 949,400.00 7,415.82 $104,557,415.82 General Obligation. Debt Outstanding September 30, 2021 DRAFT INFORMATION - For Internal Use Only - 6 Interest Issue Maturity Amount of Outstanding Bonds Rate (%) ; bate Date Issue as of 9/30/2021 Certificates of Obligation 3.00-5.00 2013 2033 9,095,000 6,430,000 GO Refunding Bonds 3.00-5.00 2013 2024 7,660,000 2,690,000 GO Refunding Bonds 2.00-4.00 2015 2028 18,675,000 11,590,000 Certificates of Obligation 2.00-4.00 2016 2036 11,800,000 8,545,000 GO Refunding Bonds 2.00-3.00 2016 2027 4,405,000 2,525,000 Certificates of Obligation 3.25-5.00 2018 2038 16,705,000 15,050,000 Certificates of Obligation 1.00-4.00 2020 2040 14,650,000 14,080,000 GO Refunding Bonds 0.50-1.00 2021 2031 8,165,000 8,165,000 Certificates of Obligation 1.50-2.00 2021 2041 15,035,000 15,035,000 Total $84,110,000 DRAFT INFORMATION - For Internal Use Only - 6 City of Coppell, Texas C',P FE L File ID: 2021-5809 Version: 1 File Name: Mayor and CC Budget Master File Number: 2021-5809 Type: Agenda Item Reference: Title: Mayor and Council Budget Notes: Sponsors: Attachments: Mayor & Council Budget Draft.pdf Contact: Drafter: Related Files: History of Legislative File 255 E. Parkway Boulevard Coppell, Texas 75019-9478 Status: Agenda Ready In Control: City Council File Created: 07/15/2021 Final Action: Enactment Date: Enactment Number: Hearing Date: Effective Date: Ver- Acting Body: Date: Action: Sent To: Due Date: Return Result: sion: Date: Text of Legislative File 2021-5809 Title Mayor and Council Budget Summary City of Coppell, Texas Page 1 Printed on 7/19/2021 Mayor & Council 10101100 Object Account Description Actual Adopted FY 20 Budget FY 22 Budget 2019-20 2020-21 Amended Proposed 6200 OFFICE SUPPLIES $0.00 $500.00 $500.00 $500.00 6201 COMPUTER SUPPLIES $0.00 $100.00 $100.00 $100.00 6215 FOOD/REFRESHMENTS $5,788.56 $10,000.00 $10,000.00 $10,000.00 6230 UNIFORMS/CLOTHING $0.00 $0.00 $0.00 $300.00 6413 TELEPHONE $9,579.27 $11,880.00 $11,880.00 $8,000.00 6425 TRAINING EXPENSE $10,894.64 $22,000.00 $22,035.00 $22,000.00 6427 LEGISLATIVE TRAVEL $1,940.18 $25,000.00 $25,000.00 $5,000.00 6435 DUES & MEMBERSHIPS $61,789.81 $83,883.00 $91,980.00 $83,883.00 6436 PUBLICATIONS/SUBSCRIPTIONS $0.00 $375.00 $375.00 $375.00 6451 PRINTING SERVICES $1,057.31 $1,000.00 $1,000.00 $1,000.00 6452 ADVERTISING $0.00 $1,200.00 $1,200.00 ,, $1,200.00 6470 CONTINGENCY FUNDS $0.00 $58,000.00 $58,000.00 $50,000.00 6471 SPECIAL PROJECTS $219,741.18 $246,875.00 $289,987.67 $205,715.00 6530 OTHER SERVICES $86,952.12 $174,000.00 $191,000.00 $174,000.00 Operating Expenditures $397,743.07 $634,813.00 $703,057.67 $562,073.00 6941 FURNITURE $0.00 $0.00 $0.00 $26,000.00 Capital Outlay $0.00 $0.00 $0.00 $26,000.00 EXPENDITURE TOTAL $397,743.07 $634,813.00 $703,057.67 $588,073.00 DRAFT INFORMATION - For Internal Use Only - 1 Mayor & Council 10101100 Object Description 6200 OFFICE SUPPLIES $300.00 Routine Office Supplies 6201 COMPUTER SUPPLIES Applications for Phones/Tablets 6215 REFRESHMENTS Meals/Refreshments 6230 UNIFORMS/CLOTHING Uniforms/Clothing for Council 6413 TELEPHONE 6413 Cellular Service for Phones & Laptops Cell Phone Replacements 6425 TRAINING EXPENSE Mayor & Council Training 6427 LEGISLATIVE TRAVEL Special Sessions 6435 DUES & MEMBERSHIPS Castle Coppell Chamber of Commerce Dallas Regional Mobility Coalition Homeland Security/NCTCOG Metroplex Mayor's Association National Civic League National League of Cities NCTCOG North Dallas Chamber of Commerce North Texas Commission Tex -21 Texas Municipal League 6436 PUBLICATIONS/SUBSCRIPTIONS Various Publications 6451 PRINTING SERVICES Special Projects Amount Total $500.00 $100.00 $500.00 $0.00 $10,000.00 $10,000.00 $300.00 $300.00 $6,600.00 $1,400.00 $8,000.00 $22,000.00 $22,000.00 $5,000.00 $5,000.00 $4,000.00 45,500.00 $3,100.00 $5,185.00 $660.00 $300.00 $3,258.00 $4,030.00 $4,000.00 $3,850.00 $5,000.00 $5,000.00 $375.00 $1,000.00 $83,883.00 $375.00 $1,000.00 DRAFT INFORMATION - For Internal Use Only - 2 Mayor & Council 10101100 Object Description 6452 ADVERTISING CHS Advertising 6470 CONTINGENCY FUNDS Contingency Funds 6471 SPECIAL PROJECTS Children's Advocacy Center of Denton Christian Community Action Christmas Parade Community Theatre Storage Mayor and Council Retreat Metrocrest Mayor's Breakfast Metrocrest Services New Teacher's Breakfast Project Graduation Red Ribbon Kickoff SPAN Teen Leadership Thanksgiving Luncheon Woven Community Health Clinic YMCA Coppell North Texas Innovation Alliance YMCA Coppell Ballet Ensemble of Texas - HOT Funded CODDell Arts Council - HOT Funded mmunity Orchestra - HOT Funded mmunity Chorale - HOT Funded ;torical Society - HOT Funded 6530 6941 Margulies Solutions for Local Control FURNITURE Remodel Council Chambers Dais Amount Total $1,200.00 $50,000.00 $3,400.00 515.000.00 $1,500.00 $7,900.00 $9,700.00 $500.00 $90,000.00 $600.00 $1,500.00 $515.00 $16,000.00 $2,100.00 $5,500.00 $6,500.00 $20,000.00 $15,000.00 $10,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $48,000.00 $60,000.00 $24,000.00 $42,000.00 $26,000.00 $1,200.00 $50,000.00 $205,715.00 $174,000.00 $26,000.00 DRAFT INFORMATION - For Internal Use Only - 3 C',P FE L File ID: 2021-5810 Version: 1 File Name: General Fund City of Coppell, Texas Master File Number: 2021-5810 Type: Agenda Item Reference: Title: General Budget a. Revenue Summary b. Expenditure Summary c. Capital Outlay Notes: Sponsors: Attachments: General Fund Draft.pdf Contact: Drafter: Related Files: History of Legislative File 255 E. Parkway Boulevard Coppell, Texas 75019-9478 Status: Agenda Ready In Control: City Council File Created: 07/15/2021 Final Action: Enactment Date: Enactment Number: Hearing Date: Effective Date: Ver- Acting Body: Date: Action: Sent To: Due Date: Return Result: sion: Date: Text of Legislative File 2021-5810 Title General Budget a. Revenue Summary b. Expenditure Summary c. Capital Outlay Summary City of Coppell, Texas Page 1 Printed on 7/19/2021 Description Ad Valorem - Current $ Ad Valorem - Eco Devo Ad Valorem - Delinquent Penalty and Interest Rendition Penalty Total Property Tax Sales Tax $ Sales Tax - Eco Devo Sales Tax Recovery Mixed Beverage Sales Tax Total Sales Tax Franchise - Electric $ Franchise - Solid Waste Franchise - Cable Franchise - Gas PEG Programming Transmission Line Fee Total Franchise Tax Licenses Building Permit Street Light Contracistration Fe " Street C/ ' Constructi jj%, , on Fees Roll -Off Per Alarm Permits Small Cell Nodes Perm Health Permits Zoning & Subdivision Fees Animal Control Special Events Permits Booth Revenue Telecommunication Fees (ROW) Public Education Fee Total Licenses and Permits S General Fund Revenue Summary Actual 2019-20 38,225,119 $ (204,995) 122,442 90,546 (2,923) Adopted 2020-21 40,366,485 $ 0 0 70,000 0 38,230,189 $ 40,436,485 $ 23,518,473 $ 131200,0 (3,205,416) (2,38 364,208 / 0 78,516 / 0 20,755,781 $ 10,8 Z ; i 2,120 1,026; ////:/, 457,9, 488,09 93,182 N1,059 --,. ..,/r//� 671,430 0 ,000 0 134,766 300 112,834 1,000 60,000 14,090 30,009 50 0 121,136 14,168 1,214,558$ 1,775 40,000 51,000 ,466,000 $ 20,000 $ 400,000 1,000 45,000 1,000 100,000 1,000 115,000 2,500 55,000 0 35,000 1,000 1,000 125,000 15,000 917,500 $ FY 21 Budget Amended 40,366,485 $ (205,000) 100,000 00) ,Qq c 23,57 j� (3,205, 602,543' j 70,000 2019851599 $ 02,000,000 000,000 450,000 475,000 90,000 31,059 4,046,059 $ 13,000 $ 400,000 0 45,000 0 100,000 1,000 115,000 1,000 60,000 14,000 30,000 50 0 120,000 15,000 914,050 $ FY 22 Budget Proposed 39,156,609 (205,000) 20,000 70,000 (3,000) 13,000 400,000 1,000 45,000 1,000 100,000 500 115,000 2,500 55,000 0 35,000 1,000 1,000 125,000 15,000 910,000 DRAFT INFORMATION - For Internal Use Only - 1 39,038,609 10,575,000 Man. jj 0 70,000 10,645,000 1,775,000 1,000,000 450,000 475,000 65,000 31,000 3,796,000 13,000 400,000 1,000 45,000 1,000 100,000 500 115,000 2,500 55,000 0 35,000 1,000 1,000 125,000 15,000 910,000 DRAFT INFORMATION - For Internal Use Only - 1 Description Municipal Court Fines $ Time Payment Fees Local Consolidated Fee Teen Court Fees Truancy Court Fees Total Municipal Court Fines $ Ambulance Services $ E-911 Revenue Library Fees Concessions Recreation Fees Program Proceeds Youth Recreation Fees Sports Entry Fees Tennis Center Revenue Child Care Fees Total Charges for Services Administrative Services $ Grant Revenue Arts Center Reve Interest Inco;" Donation '9"" Salary11 Aement Lease Rev df%//FER Oil & Gas Expl Sale of CityPro Claims/Damage Rei' ,ent /M Transfer In Miscellaneous Income Over (Short) Prior Year A/E/R Total Other Revenue $ Total Revenue $ General Fund Revenue Summary Actual Adopted 2019-20 2020-21 687,166 $ 1,100,000 $ 1,527 1,000 211 0 0 500 � ,78� 15,359 127,534 21,575 15,312 26,902 3,021,670 92,720 8 33,387 4,294,024$ 1,102,000 $ 2,796,000 $ ,200,000 $ N! 0 650,000 0 61,500 125,000 15,000 0 0 1,372,867 70,000 0 0 2,294,367 $ FY 21 Budget Amended 650,000 $ 1,500 200 j0 ,700 $ FY 22 Budget Proposed 875,000 1,000 0 500 500 877,000 2,065,750 $ 2,165,850 2,200,000 $ 255,644$ 0 200,000 0 0 125,000 20,000 0 17,582 2,957,934 72,258 0 8,693 3,657,111 $ 3,093,712 0 0 200,000 0 0 125,000 15,000 0 0 689,500 70,000 0 0 1,099,500 73,312,381 $ 64,100,852 $ 74,848,754 $ 61,625,671 DRAFT INFORMATION - For Internal Use Only - 2 800,000 350,000 100 5,000 525,000 105,000 40,000 65,000 275,000 750 2,065,750 $ 2,165,850 2,200,000 $ 255,644$ 0 200,000 0 0 125,000 20,000 0 17,582 2,957,934 72,258 0 8,693 3,657,111 $ 3,093,712 0 0 200,000 0 0 125,000 15,000 0 0 689,500 70,000 0 0 1,099,500 73,312,381 $ 64,100,852 $ 74,848,754 $ 61,625,671 DRAFT INFORMATION - For Internal Use Only - 2 General Fund Revenue Graphic Analysis Ten Year History of General Fund Revenues Fund Property Taxes 63.35% Other Revenue_ 1.78% Administrative Services 5.02% Charges for Services—/ 3.52% Court Fines 1.42% Viewed by Source Sales Tax .17.27% Franchise Taxes 6.16% Licenses & Permits 1.48% DRAFT INFORMATION - For Internal Use Only - 3 Department Mayor & Council City Management City Secretary Legal Services Community Information Services Finance Procurement Services Revenue Collections Combined Services Human Resources Enterprise Solutions Community Development Development Services Total General Government Fire & Life Services Emergency Management Municipal Court Police Animal Services Building Inspections Environmental !"M Total Pu N General Fund Expenditure Summary FY 20 Budget Actual 397,743 1,340,692 422,986 45 0, 046 534,313 1,457,742 222,156 278,532 2,382,036 1,286,099 3,018,855 777,295 0.64% $ 2.16% 0.68% 0.72% 0.86% 2.35% 0.36% FY 21 Budget Adopted 634,813 1,198,163 308.,908 0.99% 1.87% 0.48% 0.84% 1.05% 2.20% 0.36% 0.48% No 7.34% 10 2.19% 5.66% 1.47% 0.34% 25.27% 22.30% 0.68% 2.56% 12.54% 0.84% 0.88% 1.00% 40.80% Public Wof'j / 1,917,714 3.09% 1,691,125 2.64% Fleet Services 1,108,613 1.78% 1,596,033 2.49% Facilities Manag�i/i 3,280,602 5.28% 2,892,534 4.51% Streets 2,782,880 4.48% 2,154,490 3.36% Traffic Control 1,200,563 1.93% 1,388,157 2.17% Planning 185,513 0.30% 304,806 0.48% Total Public Works 10,475,885 16.86% 10,027,145 15.65% DRAFT INFORMATION - For Internal Use Only - 4 General Fund Expenditure Summary FY 20 Budget FY 21 Budget Department Actual Adopted Life Safety Park 265,592 0.43% 345,591 0.54% Library Services 2,072,354 3.33% 2,164,522 3.38% Parks Administration 1,245,573 2.00% 1,455 55 2.27% Parks 3,698,551 5.95% 3, 5 5.85% CORE 2,128,328 3.43% 1'632 3.30% Camps & Athletics 40,937 0.07%�% 07 0.41% Community Programs 333,095 0.5406 0.49% Senior Center 539,459 0.8 591' 1 �/j/ 0.92% /' �j I 4i o Tennis Center 461,068 49 5,00 °��/� 0.77% Biodiversity Education Center 184,022 % j, 229,151 0.36% Total Cultural &Recreational 10,968,979 1 11,719,263 18.28% Total E 095,731 DRAFT INFORMATION - For Internal Use Only - 5 Department Mayor & Council City Management City Secretary Legal Services Community Information Services Finance Procurement Services Revenue Collections Combined Services Human Resources Enterprise Solutions Community Development Development Services Total General Government Fire & Life Services Emergency Management Municipal Court Police Animal Services Building Inspections Environmental !"M Total Pu N General Fund Expenditure Summary FY 21 Budget Amended 703,058 1,212,917 296,911 615,559 734,522 1,467,320 229,982 308,754 5,844,587 1,420,734 3,966,034 1,356,770 217 1.03% $ 1.77% 0.43% 0.90% 1.07% 2.14% 0.33% 0.4561/11, FY 22 Budget Proposed 588,073 1,298,881 312.,320 0.93% 2.06% 0.50% 0.85% 1.04% 2.80% 0.37% 0.00% 5.33% 2.28% 5.21% 1.65% 0.34% 23.36% 23.10% 0.59% 2.52% 12.14% 0.93% 0.88% 0.88% 41.04% Public Wof 1,738,506 2.54% 1,750,380 2.77% Fleet Services 1,826,174 2.66% 1,567,160 2.48% Facilities Manag�i/i 3,301,080 4.82% 3,440,860 5.45% Streets 2,274,143 3.32% 2,558,732 4.06% Traffic Control 1,490,582 2.17% 1,525,438 2.42% Planning 314,567 0.46% 177,305 0.28% Total Public Works 10,945,052 15.97% 11,019,875 17.46% DRAFT INFORMATION - For Internal Use Only - 6 General Fund Expenditure Summary FY 21 Budget FY 22 Budget Department Amended Proposed Life Safety Park 353,328 0.52% 338,754 0.54% Library Services 2,197,210 3.21% 2,074,645 3.29% Parks Administration 1,496,693 2.18% 1,450 475 2.30% Parks 3,962,099 5.78% 3,�' 5.82% CORE 2,191,315 3.20% 1306 3.30% Camps &Athletics 262,289 0.38%i� 26 0.41% Community Programs 317,033 0.46% - 0.50% Senior Center 607,569 0.8 / 590 0.94% Tennis Center 535,851 � 442 77'„/ 0.70% Biodiversity Education Center 232,210 4%214,311% 0.34% � „ Total Cultural &Recreational 12,155,597 1 � `., i � 1,441,927 18.14% Total E 089,059 DRAFT INFORMATION - For Internal Use Only - 7 Cultural & Rec. $11,719,263 18.28 Public Works $10,027,1 15.65 Salary & Benefits $42,269,659 65.95% — Transfers $3,505,781 5.47% Capital $924,440 1.44% General Fund Expenditures Graphic Analysis General Fund Expenditures by Division —Adopted Budget FY 20-21 FY 21-22 2,450,870 19.42 Public Safety $26,150,614 40.80% L Maint. $2,849,386 4.45 ion —Adopted Budget IW&14&*► "Salary & Benefits $41,331,357 65.51% ., General Govt. $14,732,233 23.36% Public Safety $25,895,024 41.04% L$Supplies 1,968,75 8 Transfj 3.12 $4,333,608 Capital 6.87% Services Maint. $571,000 $11,730,400 $3,153,936 0.910 0 18.59% 5.00% DRAFT INFORMATION - For Internal Use Only - 8 Cultural & General Rec. Govt. $11,441,927 '16,198,709 18.14 25.27% Public Safety $26,150,614 40.80% L Maint. $2,849,386 4.45 ion —Adopted Budget IW&14&*► "Salary & Benefits $41,331,357 65.51% ., General Govt. $14,732,233 23.36% Public Safety $25,895,024 41.04% L$Supplies 1,968,75 8 Transfj 3.12 $4,333,608 Capital 6.87% Services Maint. $571,000 $11,730,400 $3,153,936 0.910 0 18.59% 5.00% DRAFT INFORMATION - For Internal Use Only - 8 Detail of Capital Outlay Fiscal Year 2021-2022 General Fund Department Organization Object Amount Description Mayor & Council 10101100 6941 $26,000 REMODEL COUNCIL CHAMBERS DAIS jo Fleet 10103310 6910 $75,000 REPLACE HD PORTAB � � � S Streets 10103330 6910 $25,000 NEW MID SIZE,;` Traffic 10103340 6925 $75,000 UPGRAD i I 'AL CON„ TIONS Library 10109100 6980 $220,000 LI =, , D IA / Animal Services 10110280 6940 $110,000 AN"��LAY AREA CORE 10112420 6910 General Fund Total ANNUAL IPMENT REPLACEMENT DRAFT INFORMATION - For Internal Use Only - 9 Walkforward of Fund Balance General Fund Beginning Fund Balance 10-01-20 $ 87,032,676 Add: Amended Revenues FY 21 74,848,754 Less: Amended Expenditures FY 21 68,538,165 Budgeted Fund Balance 09-30-21 93,3 265 Add: j Budgeted Revenues FY 22 5,671 Less: Budgeted Expenditures FY 22 ��/� 63 Budgeted Ending Fund Balance 09-30-22/ 91,8 �/ and Balance: lonspendable 10% Reserve of FY 22 Budget 6,308,906 estricted Designated for E911 929,057 Designated PEG Funds 616,058 g - //j - Desi nated for Solid Waste Ed ' on ------- 31,381 ommitted 15% Fund I olicy / 9,463,359 Allocate° nom`s elopme ' o) 666,355 Alloca venue 35%) 1,587,048 Allocate Q /r�'/. i��%%%%%/ii�358,858 lugpg/ teng�' 7,870,835 �l%Osery ;,�/(June 2019) 1,575,975 g,eJ,pBuildm ` Zoni date 325,000 Economic'%� opment Program 185,000 i ersonnel / /gency Costs 500,000 ital O f- 5 Year Forecast 9,106,650 ----------------------------------------------------------------- plementation 1es Tax (Rule 3.334 Implementation) 6,518,474 20-2 Sales Tax (Rule 3.334 Implementation) 10,318,473 Sales Tax Recoveries 898,762 Sales Tax Uses Fund Capital Fleet Replacement - $10m Fund Capital IT Replacements - $5m •----------------------------------------------------------------------------------- Unassigned Unreserved, Undesignated 34,619,686 Projected Ending Fund Balance 09-30-22 $ 91,879,877 DRAFT INFORMATION - For Internal Use Only - 10 City of Coppell, Texas C',P FE L File ID: 2021-5811 Version: 1 File Name: Gen Discussion Title: General Discussion Notes: Sponsors: Attachments: Contact: Drafter: Related Files: History of Legislative File Master File Number: 2021-5811 Type: Agenda Item Reference: 255 E. Parkway Boulevard Coppell, Texas 75019-9478 Status: Agenda Ready In Control: City Council File Created: 07/15/2021 Final Action: Enactment Date: Enactment Number: Hearing Date: Effective Date: Ver- Acting Body: Date: Action: Sent To: Due Date: Return Result: sion: Date: Text of Legislative File 2021-5811 Title General Discussion Summary City of Coppell, Texas Page 1 Printed on 7/19/2021