CP 2021-07-20 (Budget)o I'll""'
COFFELL
Tuesday, July 20, 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/16/2021
City Council Meeting Agenda July 20, 2021
Notice is hereby given that the City Council of the City of Coppell, Texas will meet in a Budget
Workshop on Tuesday, July 20, 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. Water and Sewer Budget
Attachments: Water & Sewer Budget Draft.pdf
IV. Special Revenue Funds
Attachments: Special Revenue Funds Draft.pdf
V. General Discussion
VI. Citizens' Appearance
VII. 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 16th day of July, 2021, at
Ashley Owens, City Secretary
City of Coppell, Texas Page 2 Printed on 7/16/2021
City Council Meeting Agenda July 20, 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/16/2021
City of Coppell, Texas
C',P FE L
File ID: 2021-5805
Version: 1
File Name: Water and Sewer Budget
Master
File Number: 2021-5805
Type: Agenda Item
Reference:
Title: Water and Sewer Budget
Notes:
Sponsors:
Attachments: Water & Sewer 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-5805
Title
Water and Sewer Budget
Summary
City of Coppell, Texas Page 1 Printed on 7/16/2021
Description
Water Service Sales
Total Water Sales
Sewer Service Sales
Total Sewer Sales
Interest - Operating
Interest - IMF
Total Interest Income
Disconnect/I
Water Tap F
Sewer Tap Fi
Utility Inspec
Licenses
Water Impar
Sewer Impar
Total Fees
Donations
Miscellaneoi
Lease Reven
Claim/Dama
Penalties & I
Meter Sales
Prior Year A/
Prior Year A/
Over (Short)
Total Other Revenue
Total Revenue
Water and Sewer Fund
Revenue Summary
Actual Adopted FY 21 Budget FY 22 Budget
2019-20 2020-21 Amended Proposed
$ 11,608,457 $ 12,052,434 $ 12,052,434 $ 12,052,434
11,608,457 12, 05 2,434 12, 05 2,434 12, 05 2,434
FEE
6,559,988 7,130,548 / ,130,548 7,130,548
6,559,988 7,130,54 ,, ��r,548 7,130,548
124,934 j 2 25,000
3,568 / ;000 5, p 2,500
f %
128,502 /, '°! � 30,000 27,500
9,30, 16, / " 16,000 16,000
2,,% ��///%%/i„ / 5,00 5,000 5,000
21 '� 000 5,000 5,000
2,3 4,000 4,000
6,675?% /f 6,500 6,500
60,894 , 75,000 75,000 75,000
4,891 55,000 55,000 55,000
j 70//" 166,500 166,500 166,500
j79, 0 0 0
20,728 2,500 2,500 2,500
j454 85,000 85,000 85,000
0 2,000 2,000 0
80,659 160,000 160,000 160,000
32,928 35,000 35,000 35,000
352,030 0 461,711 0
% 1 434,080 0 0 0
1 100 100 0
1,094,430 284,600 746,311 282,500
$ 19,530,047 $ 19,664,082 $ 20,125,793 $ 19,659,482
DRAFT INFORMATION - For Internal Use Only- 1
Water and Sewer Fund Revenues
Ten Year History
$15,000,000
$10,000,000
$5,000,000
$0
*Budgeted
12-13 13-14 14-15 15-16 16-17 17-18 18-19 19-20 20-21* 21-22*
2.24/ Supplies Benefits Out
$101,900 $1,715,699 $147,200
0.56% 9.37% 0.80%
FY 20-21 Adopted Budget
Services
$16,677,083
85.00%
Expenses are broken down by classification, which include: salaries, supplies, maintenance, services, transfers,
and capital.
DRAFT INFORMATION - For Internal Use Only - 2
Donn
�,��:� Capital
$600,000
Maint.
3.06%
$404,494 Salary &
Transfer
2.06% Supplies Benefits
Out
$108,250 $1,682,336
$147,200
0.55% 8.57%
0.75%
FY 21-22 Proposed Budget
Expenses are broken down by classification, which include: salaries, supplies, maintenance, services, transfers,
and capital.
DRAFT INFORMATION - For Internal Use Only - 2
Water and Sewer Fund
Expense Summary
Actual
Department 2019-20
Utility Operations $ 2,689,986 $
Utility Billing
701,483
Combined Services
2,220,346
Cost of Water Sold
6,345,705
Cost of Sewer Treated
3,987,567
Debt Service
933,949
Total Expenses $
16,879,036 $
Debt
Service
9.37%
COSL of
Sewer
Treated
23.83%
FY 20-21
Fund
Adopted
FY 21 Budget
FY 22 Budget
2020-21
Amended
Proposed
2,359,959 $
2,923,559; $
3,146,778
763,749
779,442
664,216
2,483,135
2,489,135
2,477,276
6,620,159
6,620,159
7,139,230
4,360,641
4,360,641
4,003,160
1,714,672
1,714,672
2,110,252
18,302,315 $,
18,887,608 $
19,540,912
Debt
Jtility Service
3illing 10.80%
1.17%
of
Water
Sold
36.17%
Cost
Sewe
Treated
20.49%
by Division
FY 21-22 Proposed Budget
utility
Combined Operations
Services 16.10%
12.68%
Utility
Billing
3.40%
of
Water
Sold
36.53%
The total expenses for the Water and Sewer Fund for the Fiscal Year 2021-2022 is estimated at
$19,540,912 with operating costs at $17,430,660 or 89.20% and the remaining $2,110,252 or
10.80% designated for debt.
DRAFT INFORMATION - For Internal Use Only - 3
City of Coppell, Texas
C',P FE L
File ID: 2021-5806
Version: 1
File Name: Special Revenue Funds
Title: Special Revenue Funds
Notes:
Master
File Number: 2021-5806
Type: Agenda Item
Reference:
Sponsors:
Attachments: Special Revenue Funds 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-5806
Title
Special Revenue Funds
Summary
City of Coppell, Texas Page 1 Printed on 7/16/2021
Recreational Programs Special Revenue Fund
The Recreational Programs special revenue fund is restricted for recreational programs or services. This fund
is no longer collecting revenue from a designated source and is, therefore, being mindfully spent for one-
time, qualifying purchases. There are no revenues or expenditures budgeted in FY2022.
Actual Adopted FY 21 Budget FY 22 Budget
Description 2019-20 2020-21 Amended Proposed
Interest Income
Total Revenue
Supplies
Capital Outlay
Total Expenditure
Fund Balance
Beginning Balance
Ending Balance
66,826 $
67,326 $
66,826 $
67,326 $
2021-22 Expenditures
No budgeted expenditures for
FY 21-22
67,326
67,326
DRAFT INFORMATION - For Internal Use Only - 1
Hotel Occupancy Tax Special Revenue Fund
The Hotel Occupancy Tax special revenue fund is restricted to the promotion of tourism and the
convention/hotel industry. Revenues come from a 7% tax levy on the cost of the lodging. The City
will retain the taxes received for hotels in accordance with their agreements and all short-term
rentals during FY2022. The expenditures budgeted are for qualifying service organization funding.
Description
Actual Adopted FY 21 Budget FY 22 Budget
2019-20 2020-21 Amended Proposed
Hotel Occupancy Tax
$
348,719
$
300,000
$ 300,000
$ 300,000
Economic Development
$
(123,550)
$
(200,000)
(200,000)
, (54,000)
Interest Income
1,154
1,000
1,000
1,500
Total Revenue
$
226,323
$
101,000
$ 101,000
$ 247,500
Services
$
3,400
$
25,000
$ 31,600
$ 67,300
Total Expenditure
$
3,400
$
" 25,000
$ 31,600
$ 67,300
Fund Balance
Begin
Endin
185,961
$
408,884
$
408,884
$
478,284
408,884
$
484,884
$
478,284
$
658,484
lues
2021-22 Expenditures
I
Services
100.00%
DRAFT INFORMATION - For Internal Use Only - 2
Municipal Drainage Utility District (DUD)
The Municipal Drainage Utility District special revenue fund is restricted for storm water control
development. Revenues come from a standard fee on residential utility bills and a sliding scale for commercial
utility bills. Expenditures for FY2022 include the Earthfest event, North Texas Council of Governments
programs, street sweeping, erosion control, and a study on the storm sewer system. Design for Arborbrook
Channel and equipment for creek maintenance are included for FY2022. Two positions are partially funded in
DUD: 50% of the Assistant Director of Public Works and 25% of a Construction Inspector. In FY2022, a
Stormwater Specialist is being added; the transfer out is for the vehicle required for the new position.
Actual Adopted F ;budget FY 22 Budget
Description 2019-20 2020-21 ended Proposed
Storm Water Revenue $ 247,284 $ 1 070 000
Interest Income 4,083 00 5 �;�� 5000
Total Revenue $ 251,367 1,075,000
Salary &Benefits $ 106 j��%/i 109,148"///%, 109,148 $ 187,470
/j� 00� 1300 1
Supplies /� �j � ,
300
ii
Maintenance 100,1 %/ 258,271 240,000
Services 101,87 /32, 734,017 359,287
Capital Outlay 0 '/ 0 0 40,000
Transfer Out % 0j 0 0 4,400
Total Expenditure
Fund Bala
Beginning Ba
Ending Balance
2021-22 Revenues
604,096 $
546,698 $
502,948 $ 1,102,736 $ 832,457
546,698
$
546,698
$
72,962
298,750
$
72,962
$
315,505
2021-22 Expenditures
Capital Transfer
Outlay Out
Salary & Benefits
4.80% 0.53%
22.52%
Supplies
Services ��
0.16%
43.16%
Maintenance
28.83%
DRAFT INFORMATION - For Internal Use Only - 3
Donations Special Revenue Fund
The Donations special revenue fund is used to account for any donations the City receives. Revenues come
from a variety of donors, including those for the Arts Center. Expenditures are only identified when donation
revenue is available and use is identified. In FY2022, only costs to spay and neuter animals at the City's shelter
are budgeted.
Actual Adopted FY 21 Budget FY 22 Budget
Description 2019-20 2020-21 Amended Proposed
Recycling
$ 2,302
$
500
$
500
$
500
Interest Income
989
Recycling
500
2.99%
500
250
Art Center Proceeds
37,175
10,000
9,000
9,000
Donations -Living Well in Coppell
0
0
466
0
Donations -Parks
0
500
500
0
Donations -Library
993
500
1,195
500
Donations -Senior Adults
786
4,000
2,500
2,500
Donations -Tennis Center
0
500
500
0
Donations -Animal Services
3,782
2,500
4,075
3,000
Donations -Bio Diversity
1,501
0
0
0
Donations -Fire
50
2,000
1,764
1,000
Total Revenue
$ 47,578
$
21,000
$
21,000
$
16,750
Fire
$ 0
$
10,500
$
10,500
0
Library
320
0
1,112
0
Animal Services
5,997
6,000
6,000
6,000
Arts Center
10,000
0
0
0
Senior Center
0
0
0
0
Total Expenditure
$ 16,317
$
16,500
$
17,612
$
6,000
Net ����rna,
1,261
4,500
3,388
10,750
Fund Balance
Beginning Balance
$ 223,924
$
255,185
$
255,185
$
258,573
Ending Balance
$ 255,185
$
259,685
$
258,573
$
269,323
Revenues
Art Center
Proceeds
53.73%
Donations
41.79%
Interest Income
Recycling
1.49%
2.99%
2021-22 Expenditures
i
Animal Services
100.00%
DRAFT INFORMATION - For Internal Use Only - 4
Parks Special Revenue Fund
The Parks special revenue fund is restricted to use for park improvements. Revenues historically come from
the new home construction fee of $1,285 per lot. There are no expenditures budgeted for FY2022.
Actual Adopted FY 21 Budget FY 22 Budget
Description 2019-20 2020-21 Amended Proposed
Interest Income $ 1,961 $ 5,000 $
,///5
,000 $ 0
Total Revenue $ 1,961 $ 5,000 $ 1z, 5,000 $ 0
Services $ 6,050 $ ' 0$ '�� 0
Capital Outlay 352,000 / , 0 �� / 0
Total Expenditure$ 358,050 $ 0 $ 0-9
Fund Balance
Beginning
Ending Ba
0 $ 0 $ 5,000
5,000 $ 5,000 $ 5,000
2021-22 Expenditures
No budgeted expenditures for
FY 21-22
DRAFT INFORMATION - For Internal Use Only - 5
Tree Preservation Special Revenue Fund
The Tree Preservation special revenue fund is restricted to use for tree preservation. Revenues come from
tree reparations paid by developers. The only expenditures budgeted in FY2022 are for routine tree removal
and trimming.
Actual Adopted FY 21 Budget FY 22 Budget
Description 2019-20 2020-21 Amended Proposed
Tree Preservation Fee
$
56,650
$
0
$
13,300 $
Interest Income
799
400
10,000
Total Revenue
$
57,449
$
400
$
23,300 $
Services
$
0
$
70,000
$ '
70,000 $
Total Expenditure
$
0
$,
70,000
$
70,000 $
Fund Balance
Beginning Balance
Ending Balance
9,545 $ 236,994 $ 236,994 $
6,994 $ 167,394 $ 190,294 $
2021-22 Expenditures
Services
100.00%
70,000
70,000
190,294
120,294
DRAFT INFORMATION - For Internal Use Only - 6
Police Special Revenue Fund
The Police special revenue fund is restricted to use for public safety purposes. Revenues come from
forfeitures, seizures, grants, and donations. Expenditures for FY2022 include training, supplies, Honor Guard,
and National Night Out programs.
Actual Adopted FY 21 Budget FY 22 Budget
Description 2019-20 2020-21 Amended Proposed
Grant Revenue $ 3,324 $ 0 $ 0 $ 0
Interest Income 990 1,000 1,000 500
Donations 2,695 5,000 5,000 5,000
Municipal Court Fines 6,112 6,200 6,200 6,200
Forfeitures 20,237 0 0 0
Total Revenue $ 33,358 $ 12,200 $ 12,200 $ 11,700
Supplies $ 11,669 $ 26,000 $ 27,150 $ 23,000
Services 41,115 49,000 49,954 46,000
Total Expenditure $ 52,784 $ 75,000 $ 77,104 $ 69,000
Net (19;4 (64,904) (57,300)
Fund Balance
Beginning Balance $ 172,676 $ 153,250 $ 153,250 $ 88,346
Ending Balance $ 153,250 $ 90,450 $ 88,346 $ 31,046
2021-22 Revenues 2021-22 Expenditures
Municipal Court
Fines Services
/ 52.99% 66.67%
Donations
42.74% Interest
Income Supplies
4.27% 33.33%
DRAFT INFORMATION - For Internal Use Only - 7
Municipal Court Security Special Revenue Fund
The Municipal Court Security special revenue fund is restricted for providing security services or
improvements for buildings housing a municipal court. Revenues come from $3 per non -ordinance violations.
The only expenditures budgeted in FY2022 are for maintenance and service on existing equipment.
Description
Court Fees
Local Consolidated Fee
Interest Income
Total Revenue
Actual
Adopted
FY 21 Budget
FY 22 Budget
2019-20
2020-21
Amended
Proposed
$ 8,201 $
20,000
$ 20,000
$ 9,000
10,328
0
0
11,000
1,548
1,000
1,000
500
$ 20,077 $
$ 20,500
Maintenance
$ 0 $ 5,000 $
5,000 $
5,000
Services
0 1,000
1,000
1,000
Total Expenditure
$ 0 $ 6,000 $
6,000 $
6,000
Fund Balance
Beginning Balance
Ending Balance
Court Fees
43.90%
Interest
Income
2.44%
2021-22
37,126 $ 357,203 $ 357,203 $ 372,203
57,203 $ 372,203 $ 372,203 $ 386,703
2021-22 Expenditures
Maintenance
83.33%
rvices
16.67%
DRAFT INFORMATION - For Internal Use Only - 8
Juvenile Case Manager/Truancy Prevention Special Revenue Fund
The Juvenile Case Manager/Truancy Prevention special revenue fund is restricted to necessary expenditures
for the prevention of juvenile truancy. Revenues come from a $5 fee added to court costs for fine -only
misdemeanors. The only budgeted expenditures in FY2022 are for one-quarter of the Juvenile Case Manager's
personnel costs and training.
Actual Adopted FY 21 Budget FY 22 Budget
Description 2019-20 2020-21 Amended Proposed
Case Manager Fee $ 16,345 $ 45,000 $ 45,000 $ 15,000
Local Consolidated Fee 10,544 0 0 25,000
Interest Income 1,421 1,000 1,000 500
Total Revenue $ 28,310 $ 46,000 $ 46,000 $ 40,500
Salary & Benefits
$ 0 $ 18,048 $
18,048 $
17,369
Services
0 5,000
5,000
5,168
Total Expenditure
$ 0 $ 23,048 $
23,048 $
22,537
Fund Balance
Beginning Balance
Ending Balance
Case Manage
37.04%
011111111
)nsolidated Fee
61.73%
Income
1.23%
331,095 $ 331,095 $ 354,047
354,047 $ 354,047 $ 372,010
2021-22 Expenditures
Salary &
Benefits
77.07%
ces
22.93%
DRAFT INFORMATION - For Internal Use Only - 9
Child Safety Special Revenue Fund
The Child Safety special revenue fund provides funding for Police Department programs that enhance child
safety, health, or nutrition. The revenue source is $25
per ticket issued in
a school zone. Expenditures
in
FY2022 will be for the
red ribbon program.
Actual
Adopted
FY 21 Budget
FY 22 Budget
Description
2019-20
2020-21
Amended
Proposed
Child Safety Revenue
$ 50,826
$ 12,500
$
35,000
$
23,750
Interest Income
49
0
100
0
Total Revenue
$ 50,875
$ 12,500
$
35,100
$
23,750
Supplies
$ 5,113
$ 37,000
$
37,000
$
2,500
Services
906
2,000
2,000
0
Total Expenditure
$ 6,019
$, 39,000
$
39,000
$
2,500
Net
44,'ft',""
"1 j��P"
(3,900)
21,250
Fund Balance
Beginning Balance
$ 102,630
$ 147,486
$
147,486
$
143,586
Ending Balance
$ 147,486
$ 120,986
$
143,586
$
164,836
C1
2021-22 Expenditures
rs'lplplri"
DRAFT INFORMATION - For Internal Use Only - 10
Municipal Court Technology Special Revenue Fund
The Municipal Court Technology special revenue fund is restricted to use for technology for the Court.
Revenues come from $4 per non -ordinance violations. There are no budgeted expenditures for FY2022.
Actual Adopted FY 21 Budget FY 22 Budget
Description 2019-20 2020-21 Amended Proposed
Court Fees $ 19,363 $
22,000 $
22,000 $
22,000
Interest Income 0
1,000
1,000
500
Total Revenue $ 19,363 $
23,000 $
23,000 $
22,500
Capital Outlay
$
103,773
$
0
$
0
$ 0
Total Expenditure
$
103,773
$
0
$
0
$ 0
Fund Balance
Beginning
Ending Ba
Income
2.22%
1,747 $ 1,747 $ 24,747
24,747 $ 24,747 $ 47,247
2021-22 Expenditures
No budgeted expenditures for
FY 21-22
DRAFT INFORMATION - For Internal Use Only - 11
Judicial Efficiency Special Revenue Fund
The Judicial Efficiency special revenue fund is restricted to uses that improve the efficiency of the
administration of justice. Revenues come from $0.60 per $6 non -ordinance violations with the remaining
$5.40 being remitted to the State. There are no budgeted expenditures for FY2022.
Actual Adopted FY 21 Budget FY 22 Budget
Description 2019-20 2020-21 Amended Proposed
Judicial Fees
$
1,602
$
4,500
$
4,500
$
4,500
Total Revenue
$
1,602
$
4,500
$
4,500
$
4,500
Capital Outlay
$
0 $
0 $
0
$
0
Total Expenditure
$
0 $
0 $
0
$
0
Net
1�1
4;50�i°
4,500
4,500
Fund Balance
Beginning Balance
$
17,007 $
18,609 $
18,609
$
23,109
Ending Balance
$
18,609 $
23,109 $
23,109
$
27,609
100.00%
2021-22 Expenditures
No budgeted expenditures for
FY 21-22
DRAFT INFORMATION - For Internal Use Only - 12
Red Light Enforcement Special Revenue Fund
The Red Light Enforcement special revenue fund is restricted for traffic and signal enforcement or
improvements and pedestrian safety. The program was discontinued by the State Legislature during FY2019.
The remaining fund balance was spent on qualifying purchases in FY2020 in order to close the fund. There will
be no budgeted revenues or expenditures in FY2022.
Actual Adopted FY 21 Budget FY 22 Budget
Description 2019-20 2020-21 Amended Proposed
Red Light Civil Penalty
Interest Income
Total Revenue
Services
Capital
Total Expenditure
Fund Balance
Beginning Balance
Ending Balance
ei,
d revenues for
21-22
0 S
63,300
582,894
646,194 $
1A ' QV 646,194 $ 646,194 $
1194 $ 646,194 $ - $
2021-22 Expenditures
No budgeted expenditures for
FY 21-22
DRAFT INFORMATION - For Internal Use Only - 13
Infrastructure Maintenance Fund (IMF)
The Infrastructure Maintenance Fund is restricted for maintenance on the City's infrastructure.
Revenues come from the voter -authorized %% sales tax and transfers from the General Fund.
Expenditures for FY2022 include ongoing street system maintenance, including alley and sidewalk
repairs, pavement/parking lot markings and improvements, ADA improvements, traffic signal
maintenance, scheduled painting, flooring, roof replacement, and maintenance at City facilities. The
IMF also funds 25% of a construction inspector, with 50% in the General Fund and 25% in the
Drainage Utility District. Beginning in FY2022, the IMF is being charged for administrative services
provided by the General Fund.
Fund B
Beginning Balance $ 21,563,069 $ 20,226,203 $ 20,226,203 $ 15,230,213
Ending Balance $ 20,226,203 $ 20,574,965 $ 15,230,213 $ 15,268,325
Transfer In
49.98%
2021-22 Revenues
Sales Tax
46.92%
Interest
Income
0.89%
sous
2.21%
2021-22 Expenditures
DRAFT INFORMATION - For Internal Use Only - 14
Actual
Adopted
FY 21 Budget
FY 22 Budget
Description
2019-20
2020-21
Amended
Proposed
Sales Tax
$
5,891,879
$
3,322,000
$
5,891,880
$
2,650,000
Sales Tax Recovery
91,052
0
0
0
Interest Income
188,759
100,000
100,000
50,000
Miscellaneous Income
0
0
0
125,000
Transfer In
3,235,000
2,144,000
2,144,000
2,823,000
Total Revenue
$
9,406,690
$
5,566,000
$
8,135,880
$
5,648,000
Salary & Benefits
$
22,309
$
23,238
$
23,238
$
23,314
Maintenance
3,439,643
2,144,000
7,666,106
2,948,000
Services
492,064
550,000
938,324
138,574
Capital Outlay
6,789,540
2,500,000
4,504,202
2,500,000
Total Expenditure
$
10,743,556
$
5,217,238
$
13,131,870
$
5,609,888
Fund B
Beginning Balance $ 21,563,069 $ 20,226,203 $ 20,226,203 $ 15,230,213
Ending Balance $ 20,226,203 $ 20,574,965 $ 15,230,213 $ 15,268,325
Transfer In
49.98%
2021-22 Revenues
Sales Tax
46.92%
Interest
Income
0.89%
sous
2.21%
2021-22 Expenditures
DRAFT INFORMATION - For Internal Use Only - 14
Department: Rolling Oaks Memorial Cemetery
Division: Special Revenue
Mission
The Rolling Oaks Memorial Cemetery, which opened in FY2009 and operates as part of the Parks and
Recreation Department, facilitates burial, memorial, and related services.
FY2022 Key Goals °D/////O ,
�O,
Presell Phase 2 of Rolling Oaks and grow at -need services by a of 25 calls.
Continue marketing and cooperative efforts with local organ s to f ,, he diverse sof the
population.
17-18 18-1 j JJ„ %'//; 20-21 21-22
Niches � ���
30 33 35 38 42
New Monuments
95 97 200
Burial RightsVNI
202 �`� 210 353 850
DRAFT INFORMATION - For Internal Use Only - 15
Authorized Personnel
Position/Title Pay Grade 19-20 20-21 21-22
Cemetery Manager
35 1
1
1
Assistant Cemetery Manager
29 1
1
1
Administrative Tech. III
23 1;
1
Total
3
3
FY2022 Key Goals °D/////O ,
�O,
Presell Phase 2 of Rolling Oaks and grow at -need services by a of 25 calls.
Continue marketing and cooperative efforts with local organ s to f ,, he diverse sof the
population.
17-18 18-1 j JJ„ %'//; 20-21 21-22
Niches � ���
30 33 35 38 42
New Monuments
95 97 200
Burial RightsVNI
202 �`� 210 353 850
DRAFT INFORMATION - For Internal Use Only - 15
Rolling Oaks Memorial Cemetery
The Rolling Oaks Memorial Cemetery special revenue fund is restricted to use for the operation and
maintenance of the municipal cemetery. Revenues are from sales of burial rights, less 15% required to fund
the perpetual care fund. Expenditures for FY2022 include personnel, increased supplies and maintenance for
the grounds, and costs associated with the purchase of memorial items and interments.
Description
Burial Rights Sales
Service Fees
Memorial Sales
Installation Fees
Interest Income
Lease Revenue
Miscellaneous
Over/Short
Transfer In
Total Revenue
Salary & Benefits
Supplies
Maintenance
Services
Total Expenditure
Fund Balance
Beginning Ba
Ending Balans
Actual
Adopted
Salary &
FY 21 Budget
// /�
FY 22 Budget
2019-20
2020-21
Amended
Proposed
593,743
$
325,000
$
1,000,000
$
1,610,750
196,554
125,000
200,000
240,000
143,581
150,000
150,000
200,000
51,758
50,000
50,000
50,000
1,989
3,000
3,000
1,000
46,667
46,667
46,667
46,667
5
0
0
0
10
0
0
0
0
300,000
0
0
1,034,307,
5
999,667
5.
1,449,667
5
2,148,417
304,423
$
313,241
$
313,241
$
310,410
112,233
252,400
246,400
445,400
150,130
330,000
316,689
385,000
385,010
374,890
400,161
650,877
951,796
$
1,270,531
$
1,276,491
$
1,791,687
(270,864)
173,176
356,730
320,109
$
402,620
$
402,620
$
575,796
402,620
$
131,756
$
575,796
$
932,526
nues
Memorial
Sales
9.31%
2021-22 Expenditures
Services
Salary &
36.33%
/ ���j��///i" Benefits
// /�
17.32%
Service Fees
11.17%
Maintenance
21.49%
Supplies
24.86%
DRAFT INFORMATION - For Internal Use Only - 16
Department: Crime Prevention District
Division: Special Revenue
Mission
The Crime Prevention District facilitates the Coppell Police Department's efforts to maintain a safe
community environment. This is accomplished by providing quality programs and services such as our School
Resource Officers, Community Services Crime Prevention Officer programs and jail services. The district also
provides funding for public safety communications, which is done in collaboration with our partner cities
through the North Texas Emergency Communications Center (NTECC).
Authorized Personnel
Position/Title Pay Grade 19-20! ' 21-22
Deputy Police Chief 43 1 1
Police Sergeant PD 4 1j 1
FBI
Police Corporal PD 3 1
Police Officer PD 2 13 1 13
Systems Administrator 35 1 1 1
Crime Analyst 28/�j� 1 1
Terminal Agency Coordinator 26 N
Total 19 19 19
FY2022 Key Gd'
Support the CISD and provide education to the yoi� � citiz "",", �i with the School Resource Officer
program, youth engagement pyra d various ation` asses, including the self-defense for
i'
women course offered to highContinue to engage our citizen % rennialI ard-winning National Night Out program.
rformance Measures
X19 19-20 20-21 21-22
911 Calls Re ��/
18,003; 19,083 12,381 11,816 16,069
Schools with dedi jj '
�e� 6 6 6 6
Schools Adopted by Patr
10 10 10 10 10
DRAFT INFORMATION - For Internal Use Only - 17
Crime Prevention District Special Revenue
The Crime Prevention District special revenue fund is restricted to crime prevention programs and services.
Revenues come primarily from the %% sales tax, which are expected to decrease significantly due to changes
at the State level. Expenditures in FY2022 include the School Resource Officer program, jail services, the
neigh boorhood/community policing program, and the joint emergency dispatch center. Additionally, cameras
for the ALPR system and ticket writers are budgeted for replacement.
Fund Balance
Beginning Balance
Ending Ba
Sala
Reimburs
9.40
.103.
nneIt! x niwrIt!
0.68%
771 $ '
12,006,224 $ 12,006,224 $
Actual
224 $
Adopted
12,996,642
FY 21 Budget
FY 22 Budget
Description
2019-20
20-21
Sales Tax
Amended
Out
Proposed
Sales Tax
$
5,846,419
$
3,324,750
$
5,846,420
$
2,630,875
Sales Tax Recovery
90,301
0
165,352
0
Interest Income
102,586
Salary &
100,000
Supplies
20,000
20,000
Salary Reimbursement
0
37.30%
331,875
331,875
275,000
Total Revenue
$
6,039,306
$
3,756,625
$
6,363,647
$
2,925,875
Salary & Benefits
$
1,603,314
$
1,839,349
$
1,839,349
$
1,542,313
Supplies
40,213
9,000
9,000
99,000
Maintenance
7,205
0
28,818
0
Services
1,832,509
1,591,310
1,591,310
1,903,602
Capital Outlay
63,954
25,000
106,396
0
Transfer Out
589,658
589,658
589,658
589,658
Total Expenditure
$
4,136,853
$
4,054,317
$
4,164,531
$
4,134,573
Fund Balance
Beginning Balance
Ending Ba
Sala
Reimburs
9.40
.103.
nneIt! x niwrIt!
0.68%
771 $ '
12,006,224 $ 12,006,224 $
14,205,340
224 $
11,708,532 $ 14,205,340 $
12,996,642
2021-22 Expenditures
Transfer
Sales Tax
Services
Out
89.92%
1,903,6025
589,658
/ :i,, o
46.04% 14.26
�f/�� /
Salary &
Supplies
Benefits
99,000
1,542,313
2.40%
37.30%
DRAFT INFORMATION - For Internal Use Only - 18
Recreation Development Corporation Special Revenue Fund
The Coppell Recreation Development Corporation special revenue fund is restricted for improvements and
maintenance to specific recreation facilities, trails, drainage,
and streetscapes. Revenues come from the
expanded %z% sales tax authorized by voters in 2013.
In FY2022, expenditures will consist of the costs
associated with operating
the Coppell Arts Center
and the annual transfer to the General Fund.
$
Actual
Adopted
FY 21 Budget
FY 22 Budget
Description
2019-20
2020-21
Amended
Proposed
Sales Tax
$ 11,783,758 $
6,649,384 $
11,782,633 $
5,301,519
Dedicated for Debt Service
(3,332,519)
(3,331,394)
(3,331,394)
(3,331,519)
Sales Tax Recovery
182,104
0
329,959
0
Art Center Revenue
10,014
799,930
200,000
505,630
Donations
40,000
0
4,348
0
Interest Income
140,322
100,000
10,000
50,000
Total Revenue
$ 8,823,679 $
4,217,920 $
8,995,546 $
2,525,630
Salary & Benefits
$ 490,485 $
703,616 $
703,616 $
752,180
Supplies
348,331
66,700
444,000
244,750
Maintenance
3,402
10,000
31,800
42,000
Services
575,204
1,390,990
1,842,506
1,580,574
Capital Outlay
3,770,641
0
1,691,849
0
Transfer Out
7,021,670
1,372,867
2,957,934
689,500
Total Expenditure
$ 12,209,733 $
3,544,173 $
7,671,705 $
3,309,004
Fund Balance
Beginning Bal
Ending Balanc
Sales Tax
78.00%
Intere<_
1.98%
202
es
3,299,143
$
9,913,089
$
9,913,089
$
11,236,930
9,913,089
$
10,586,836
$
11,236,930
$
10,453,556
t Center
=venue
20.02%
2021-22 Expenditures
Services Transfer Out
47.76% � � i r�14�h 20.84/
/%� l l/ , V u,�
0
/ Salary &
Maintenanc Benefits
o Supplies
1.27/ 7.40% 22.73%
DRAFT INFORMATION - For Internal Use Only - 19
Recreation Development Corporation Debt Service Fund
The Coppell Recreation Development Corporation Debt Service Fund is to account for the payment
of principal and interest on the City's CRDC debt. Revenues are from the CRDC %z% sales tax and only
the minimum necessary to pay the debt obligations. Expenditures for FY2022 are only the scheduled
debt payments.
Description
Actual Adopted FY 21 Budget FY 22 Budget
2019-20 2020-21 Amended Proposed
Sales Tax $ 3,332,519 $
3,331,394 $
3,331,394 $
3,331,519
Interest Income 6,488
10,000
10,000
10,000
Total Revenue $ 3,339,007 $
3,341,394 $
3,341,394 $
3,341,519
Services
Total Expenditure
Net
Fund Balance
Begin
Endin
$ 3,333,269
$
3,337,394
$
3,337,394
$
3,337,519
$ 3,333,269
$
3,337,394
$
3,337,394
$
3,337,519
101,966
$
107,704
$
107,704
$
111,704
107,704
$
111,704
$
111,704
$
115,704
2021-22 Expenditures
DRAFT INFORMATION - For Internal Use Only - 20
City of Coppell, Texas
C',P FE L
File ID: 2021-5807
Version: 1
File Name: Gen Discussion
Title: General Discussion
Notes:
Sponsors:
Attachments:
Contact:
Drafter:
Related Files:
History of Legislative File
Master
File Number: 2021-5807
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-5807
Title
General Discussion
Summary
City of Coppell, Texas Page 1 Printed on 7/16/2021