The URL can be used to link to this page

CP 2021-07-29 (Budget)o I'll""' COFFELL Thursday, July 29, 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/29/2021 City Council Meeting Agenda July 29, 2021 Notice is hereby given that the City Council of the City of Coppell, Texas will meet in a Budget Workshop on Thursday, July 29, 2021 at 6:00 p.m. in the 2nd Floor Conference Room of Town Center, 255 E. Parkway Boulevard, Coppell, Texas. As authorized by Section 551.071(2) of the 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 of the meeting is to consider the following items: Work Session (Open to the Public) 2nd Floor Conference Room I. Call to Order II. Citizens' Appearance III. Final Review a. Assessed Valuation b. Debt Service c. General Fund d. Water/Sewer Fund e. Other Funds Attachments: Final Review.pdf IV. General Discussion V. Citizens' Appearance VI. Adjournment Wes Mays, Mayor 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 26th day of July, 2021, at Ashley Owens, City Secretary City of Coppell, Texas Page 2 Printed on 7/29/2021 City Council Meeting Agenda July 29, 2021 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/29/2021 C',P FE L File ID: 2021-5822 Version: 1 File Name: Final Review City of Coppell, Texas Master File Number: 2021-5822 Type: Agenda Item Reference: 255 E. Parkway Boulevard Coppell, Texas 75019-9478 Status: Agenda Ready In Control: City Council File Created: 07/26/2021 Final Action: Title: Final Review a. Assessed Valuation b. Debt Service c. General Fund d. Water/Sewer Fund e. Other Funds Notes: Sponsors: Enactment Date: Attachments: Final Review.pdf Enactment Number: Contact: Hearing Date: Drafter: Effective Date: Related Files: History of Legislative File ver- Acting Body: Date: Action: Sent To: Due Date: Return Result: sion: Date: Text of Legislative File 2021-5822 Title Final Review a. Assessed Valuation b. Debt Service c. General Fund d. Water/Sewer Fund e. Other Funds Summary City of Coppell, Texas Page 1 Printed on 7/29/2021 IV v Budget Workshop July 29, 2021 @ 6:00 p.m. Town Center 2n' Floor Conference Room Agenda DRAFT INFORMATION - For Internal Use Only - 1 2021 VALUATION ESTIMATES Certified Values 2021 Certified Value 8,737,297,796 2020 Certified Value 8,389,096,043 --------------------------- Valuation Increase 348,201,753 Percentage Growth 4.15% HISTORICAL DATA Tax Year 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 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,995,382 5,422,736,502 5,108,672,621 4,959, 6,933 8,463 3, 12,366 ;799,855 �j f 76,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 Value Report 8,389,096<<r 8,045,/ j 7,5 7,000,0 j i 6,713,232, N 30,716,425 �i ;2.025 x770,954 1,7,952,176 kms/. 105,750 3,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 (548,96I j�, (627,148,41 335,334,214) (341,133,247) (257,869,233) 211,615,092) 28,713,357) (192,807,481) (135,047,375) (157,350,049) (226,370,858) (284,877,971) (327,246,960) (564,345,974) (428,526,403) (434,750,454) (260,387,817) (244,953,713) (463,376,650) (359,334,746) (129,453,110) (207,981,213) (114,056,814) (54,493,037) (40,940,052) (56,660,467) (46,052,749) (25,390,566) (58,037,664) (45,190,863) Percent Change -6.14% -7.23% -4.23% -4.65% -3.70% -3.28% -7.02% -3.56% -2.64% -3.17% -4.47% -5.54% -6.28% -10.86% -9.16% -9.86% -6.36% -6.23% -11.64% -9.95% -4.21% -7.44% -4.77% -2.65% -2.35% -3.56% -3.32% -2.19% -5.49% -4.53% Average -5.55% DRAFT INFORMATION - For Internal Use Only - 2 VALUATION BREAKDOWN REPORT Certified Values 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.83 250,726,469 3.58% 129,848,807 1.85% 2018 2019 Value - Difference - 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,1 Residential Ag Land 4,444,749,062 43,236 302,019,105 16,017 7.29% 58.84% 4,597,309,191 40,238 152,560,129 (1, �7I7 N�J 3.43% -6.93% 105 31,416 Bus. Personal Prop. 1,132,339,429 ___________________________ ______________________ 130,135,857 12.98% _______________ 1,296,156,035 ___________________________ ______________________ 163,816,606 ______� 14/ � / %�� 3 TOTAL 7,590,756,781 590,671,209 8.44% 8,045,416,839 454,660,058 5.991 `��:� 43 '' 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.83 250,726,469 3.58% 129,848,807 1.85% 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% ('L^3 X,/66,X40) -40.38% ('X,'X22) 0.00% 343,679,204 4.27% 28,156,636 8.09% 23,619,990 6.78% 1,115,040 0.32% 101,198,661 29.06% 46,251,573 13.28% 147,669,472 42.41% 190,381 0.05% 348,201,753 4.15% DRAFT INFORMATION - For Internal Use Only - 3 2021 fence % Chg.Taxable Value - Difference - % Chg. 778,572 3.57% 2,353,508,598 124,818,651 5.60% 4,822,803,314 74,408,209 1.57% 221,797 190,381 606.00% 115,823,5 40'L92% 94% _______ 1,560 , 764087 ,,, 148784512 10.54% 343,679,204 4.27% 8,737,297,796 348,201,753 4.15% 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% ('L^3 X,/66,X40) -40.38% ('X,'X22) 0.00% 343,679,204 4.27% 28,156,636 8.09% 23,619,990 6.78% 1,115,040 0.32% 101,198,661 29.06% 46,251,573 13.28% 147,669,472 42.41% 190,381 0.05% 348,201,753 4.15% 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 YEAR 2020 Through 2019 2018 2017 / 2016 2007 2006 2005 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995 Proposed Distribution of Tax Collections TAX RA 99.91 99.94 99.96 99.97 99.97 99.98 99.99 99.99 99.99 99.99 99.99 99.99 99.97 99.99 99.99 99.99 99.99 99.99 99.99 99.99 99.99 $ 8,737,297,796 0.580000 50,676,327 100.00% 50.676.327 $ 50,676,327 49, 380, 608 49,153,445 47,800,864 47,574,387 43, 233,860 43,167,940 40, 760, 304 40, 708, 869 38, 535, 322 38, 507,194 36,067,044 36,035,965 33,976,650 33,957,757 33,086,012 33,072,215 33,221,456 33,211,291 33,232,958 33,224,639 33,209,502 33,201,555 31,051,829 31,051,141 30,039,813 30,039,278 29,535,306 29,534,822 27,536,930 27,536,441 26,257,525 26,257,444 24,850,505 24,850,427 24,287,437 24,280,909 22,882,932 22,882,825 21,030,640 21,030,563 19,065,176 19,065,099 16,774,415 16,774,341 14,815,871 14,815,797 13,522,774 13,522,750 11,419,196 11,419,134 10,237,648 10,237,553 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. Description Actual 2019-20 Ad Valorem Taxes -Current $ 8,662,921 $ Ad Valorem Taxes -Delinquent 31,727 Property Tax P & 1 21,741 Interest Income 24,826 Total Revenue $ 8,741,215 $ Services Total Expenditure Net Fund Balance B E Adopted FY 21 Bu 2020-21 Amend 8,290,272 $ 8,29( 3 30,000 FY 22 Budget Proposed 9,500,151 10,000 20,000 10,000 272 $ 9,540,151 $ 8,630,429 $: 8,839,805 ! $ , 8,839,805 $ 9,540,186 $ 8,630,429 $ 8,839,805 $ 8,839,805 $ 9,540,186 773 $ 1,074,559 $ 1,074,559 $ 595,026 559 $ 595,026 $ 595,026 $ 594,991 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, .00 2026 5,975,000.00 1,806,850.00 0.00 2027 5,565,000.00 1,580,425.01 425.00 2028 5,300,000.00 1,368,225 Q 00 2029 4,235,000.00 1 179 15 4 2030 4,415,000.00 1,000, 0 5,415, 2031 4,585,000.00 .50 5,415,187: 2032 3,810,000.00 40.63 ,508,540.63 2033 3,915,000.00 ,499,068.76 2034 3,335,000.00 47 %;� j 31810,871.88 2035 3,425, / 382,4%' 3,807,434.38 �% 2036 3,52 93. 2037 2,86 1.26 065,531.26 �� 2038 2,945, r 3,069,437.51 2039 1,770,00 �� ! 1,840,406.26 204q 805,00 36,296.88 1,841,296.88 2, 19;401000. /�, 9,400.00 949,400.00 ,447,415.82 ############## a al jj ;Debt Outstanding September 30, 2021 DRAFT INFORMATION - For Internal Use Only - 6 u Maturity Amount of Outstanding Certificates ' tion 3.00' %a � �Date 2013 Date 2033 Issue 9,095,000 as of 9/30/2021 6,430,000 GO Refunding ,/� 3 0 ' �4a'% 2013 2024 7,660,000 2,690,000 GO Refunding Bon ' / , 11 .` 0 2015 2028 18,675,000 11,590,000 Certificates of Obligati -4.00 2016 2036 11,800,000 8,545,000 GO Refunding Bonds 2016 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 Tota I $84,110,000 DRAFT INFORMATION - For Internal Use Only - 6 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 i Building Permit Street Light': Contrac f istration Fe Street C J" . Constructio ",�" on Fees Roll -Off Alarm Permits Small Cell Nodes Per P11 Vol' 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,, (3,205,416) (2,38 364,208 E 0 78,516 t % 0 10, 645, 000 20,755,781 $ 10,8 ` ,�- 2,120 i 1,026. 457,9" 488,09 93,182 1,059 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) 952G t 23,5°14, i (3,205,4%' r 602,543'! PP 70,000 20,985,599 $ 2,000,000 F"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 41,176,176 (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 - 7 41,058,176 10,575,000 j0 j 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 - 7 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 %i Interest Inco Donation Salary /jement Lease Rev Oil & Gas Exp /i Sale of City Prope.�� Claims/Damage Rei ent 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 5,789 0 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$ x,200,000 $ M! 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 �j 0 ,.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 $ 63,645,238 DRAFT INFORMATION - For Internal Use Only - 8 800,000 i j 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 $ 63,645,238 DRAFT INFORMATION - For Internal Use Only - 8 General Fund Revenue Graphic Analysis Ten Year History of General Fund Revenues $73,312,381 $80,000,000 $73,615,709 $64,100,852 $63,645,238 $62,994,950 $67,475,558 $70,000,000 $54,467,992 $60,000,000 ,,�'S4,496,861 $53,940,420 $58,732,720 ,,, $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 $0 FY 12-13 FY 13-14 FY 14-15 FY 15-1 * Budgeted Property Taxes $41,058,176 64.51 Fund Court) Fines $877,000 1.38% FY 18 - Viewed by Source Licenses & Permits $910,000 1.43% FY 20-21* FY 21-22* Franchise Taxes $3,796,000 5.96% Sales Tax $10,645,000 16.73% DRAFT INFORMATION - For Internal Use Only - 9 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 EnvironmentaLHi , Total Pu General Fund Expenditure Summary FY 20 Budget Actual 397,743 1,340,692 422,986 450,046 534,313 1,457,742 222,156 278,532 2,382,036 1,286,099 3,018,855 777,295 16,528,313 OEM 385,77x; %X 39,480 � 17,709 0.64% $ 2.16% 0.68% 0.72% 0.86% 2.35% 0.36% 0.4!%/i , I r 0.62% 2.32% j 12.90% 0.94% 1.30% 0.33% 45.01 FY 21 Budget Adopted 634,813 1,198,163 308.;908 ;399 4,707,325 A,404,460 ,630,455 939,557 216,724 i. f 98,709 14,295,596 438,529 1,639,497 8,035,506 536,864 561,428 26,150,614 0.99% 1.87% 0.48% 0.84% 1.05% 2.20% 0.36% 0.48% 7.34% 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 Wo , 1,917,714 3.09% 1,691,125 2.64% Fleet Service 1,108,613 1.78% 1,596,033 2.49% Facilities Manag�it, 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 - 10 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% /1632 3.30% O� Camps & Athletics 40,937 0.07% 07 0.41% ` Community Programs 333,095 0.54% �,� �0.49j Senior Center 539,459 0. 591' 0.92% Tennis Center 461,068 495,0 ° Biodiversity Education Center 184,022 „ % �, 229,151 �� 0.36% Total Cultural &Recreational 10,968,979 1 ��% 719,263 18.28% Total E; 5,731 DRAFT INFORMATION - For Internal Use Only - 11 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 EnvironmentaLHi , Total Pu General Fund Expenditure Summary FY 21 Budget Amended 703,058 1,212,917 311,155 615,559 734,522 1,467,320 229,982 308,754 5,844,587 1,420,734 3,966,034 1,356,770 217.6&21 1.03% $ 1.77 0.45 0.90% 1.07 2.14% 0.33% 0.4 `�%i , FY 22 Budget Proposed 588,073 1,298,881 312.,320 0.93 2.06% 0.49 0.85 1.04% 2.79 0.37 0.00 5.33% 2.28% 5.20% 1.64% 0.34% 23.32 23.07 0.59 2.52% 12.13 0.93 0.88% 0.88% 41.00 Public Woj 1,738,506 2.54% 1,750,380 2.77% Fleet Service 1,826,174 2.66% 1,567,160 2.48% Facilities Manag�it, 3,301,080 4.82% 3,440,860 5.45% Streets 2,274,143 3.32% 2,558,732 4.05% 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.45% DRAFT INFORMATION - For Internal Use Only - 12 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.20% 2,148,078 3.40% Parks Administration 1,496,693 2.18% 1,450A75 2.30% Di Parks 3,962,099 5.78% 3, 5.81/ CORE 2,191,315 3.20% x,306 3.30% Camps & Athletics 262,289 0.389/c, 26 0.410 Community Programs 317,033 0.46% / 0.50% Senior Center 607,569 0.8 590; 0.93% Tennis Center 535,851 442,77 0.70/ Biodiversity Education Center 232,210 Z4/0 �, 214,311 0.34% " Total Cultural &Recreational 12,155,597 1/ 11,515,360 18.23% Total E; 162,492 DRAFT INFORMATION - For Internal Use Only - 13 Cultural & Rec. $11,719 ')Fz 18.21 Public Work $10,027, 9 c r" Salary & Benefits $42,269,659 65.95% General Fund Expenditures Graphic Analysis General Fund Expenditures by Division —Adopted Budget FY 20-21 FY 21-22 Transfers $3,505,781 5.47% Capital $924,440 1.44% 19.42% afety 1,614 40.80% L Maint. $2,849,386 4.45% ion —Adopted Budget IW&14&*► Salary & Benefits $41,404,790 65.55% General Govt. $14,732,233 23.32% Public Safety $25,895,024 41.00% tl "' \_ Supplies $1,968,758 Transfers 3'12% $4,333,608 OCapital 6.86% Services Maint. $571,000 $11,730,400 $3,153,936 0.91% 18.57% 4.99% DRAFT INFORMATION - For Internal Use Only - 14 Cultural & General Rec. Govt. $11,515,360 '16,198,709 18.23% 25.27% afety 1,614 40.80% L Maint. $2,849,386 4.45% ion —Adopted Budget IW&14&*► Salary & Benefits $41,404,790 65.55% General Govt. $14,732,233 23.32% Public Safety $25,895,024 41.00% tl "' \_ Supplies $1,968,758 Transfers 3'12% $4,333,608 OCapital 6.86% Services Maint. $571,000 $11,730,400 $3,153,936 0.91% 18.57% 4.99% DRAFT INFORMATION - For Internal Use Only - 14 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,552,409 Budgeted Fund Balance 09-30-21 93,3: 021 Add: Budgeted Revenues FY 22 Less:j��j/ 45,238 Budgeted Expenditures FY 22 Budgeted Ending Fund Balance 09-30-22 63,E 93,81' %i. and Balance: lonspendable 10% Reserve of FY 22 Budget 6,316,249 estricted� / Designated for E911 / 929,057 Designated PEG Funds � � 616,058 Designated for Solid Waste Eon� 31,381 --------------------------------- ---- - ------------------- ommitted 15% Fund B / ;olicy / 91474,374 no elopm Allocate ; eri�� o) 666,355 Alloca r )' venue �� 35/0 1,587,048 Allocate �%;1,��i i' ��%%%%%G�rrrr358,858 PCntena j��% j 7,870,835 'u/ /�/i, sery w/ (June 2019) 1,575,975 Building z / pdate 325,000 Economics jj pment Program 185,000 j ersonnel gency Costs 500,000 ital 0 1 5 Year Forecast 9,106,650 a p i to I Campaign80,000 -------------------------------------- Rul i'''mplementation 19-2 Sales Tax (Rule 3.334 Implementation) 6,518,474 20-21 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 36,453,218 Projected Ending Fund Balance 09-30-22 $ 93,811,767 DRAFT INFORMATION - For Internal Use Only - 15 City of Coppell, Texas C',P FE L File ID: 2021-5823 Version: 1 File Name: Gen. Discussion Title: General Discussion Notes: Sponsors: Attachments: Contact: Drafter: Related Files: History of Legislative File Master File Number: 2021-5823 Type: Agenda Item Reference: 255 E. Parkway Boulevard Coppell, Texas 75019-9478 Status: Agenda Ready In Control: City Council File Created: 07/26/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-5823 Title General Discussion Summary City of Coppell, Texas Page 1 Printed on 7/29/2021