CP 2002-07-01 Budget Workshop
2002-2003 Budget Notebook
~1aster Index
Budget Workshop, July 1,2002
Budget Workshop, June] 7, 2002
Budget Workshop, June 3, 2002
Budget \V orkshop, February 19,2002
Budget Meeting
July L 2002
A.genda
I. General Fund
a) Summaries
b) Department Review
c) Additional Personnel
d) Capital over $10.000
e) Unfunded Projects
II. FYO 1-02 Budget Amendment Discussion
Ill. General Discussion
Description
Ad Valorem - Current
Ad Valorem Delinquent
Penalty and Interest
Roll Back Tax
Prop_Tax Collection Service
Total Property Tax
Transmission Line Fee
Franchise - Electric
Franchise - Telephone
Franchise - Gas
Franchise - Solid Waste
Franchise - Cable
Total Franchise Tax
W/S Reimbursement
Sales Tax
Municipal Court Fines
Recreational Fees
BUilding Permits
Zoning/SubdivIsion Fees
Street Lighting/Sign Fees
Contractor Registration
Street Cut Fees
Library Fees
Health Permits
Licenses
Alarm Permits
i'lnlmal Control
Construction Fees
Total Fees and Permits
The City of Coppell
General Fund
Re.enue Summary
Actual
20C001
$
12.320,371 $
87,746
70,608
95,617
o
12.574,342
51,626
1444,098
125,333
371.052
326,079
227,016
2545,204
2804,150
4.720,485
1513,984
906.808
731.823
38.733
8,347
27,235
10,900
26,816
18,110
33,400
31,010
24,780
308.565
s
2 166.527 $
FY 02 Budget
Amended
14,095,933 $
53,000
30,000
15,925
o
14,194,858
51,176
1,435,000
160,000
200,000
325,000
227,000
2,398.176
3,000.000
3,835.000
1,300.500
950,000
400,000
36,000
15,000
25,000
15.000
25,000
20,000
34,000
20,000
20,000
254,500
1.814,500 $
/70,R f1 r=c:J
:........ ! ,';" =:--< /f _ " ........, /;
..... l..L' i.,.,.....J L.
FY 03 Budget
Proposed
15,002,089
75,000
50,000
o
20,000
15,147,089
51,000
1,600,000
160,000
160,000
325,000
210,000
2.506,000
3.000,000
3,535,000
1.102.000
1.053.500
300,000
30,000
15,000
25,000
15,000
25,000
20,000
34,000
25,000
25,000
200,000
1.767,500
--...., ,-.-..,,, f..... -~
- ~,
i ,-.....,~. --,
The City of Coppell
General Fund
Revenue Summary
Actual FY 02 Budget FY 03 Budget
Description 2000-01 Amended Proposed
E911 Revenue $ 296,835 $ 300,000 $ 300,000
Telecommunications Fee 10,081 2,711 6,000
CRDC Reimbursement 55,125 55,125 57,880
Salary Reimbursement 55,695 40,000 40,000
Project Reimbursement 3,300 0 0
Homestead Reimbursement 50 0 0
Ambulance Services 77.056 60,000 78,000
Maps and Publications 4,341 6,000 6,000
Concessions ~ 80,000 0
Commercial Roll-Off 109,262 80,000 90,000
1 nterest Income 767,895 450,000 200,000
Miscellaneous Income 104,696 15,000 15,000
Grant Revenue 0 0 0
Claims/Damage Reimbursement 18,842 5,057 0
Lease Proceeds 49,169 20,998 585,000
Lease Revenue 0 13,918 15,000
Transfer In 615,375 0 0
Sale of City Property 38,201 0 0
Prior Year A/E/R 41,396 0 0
Over (Short) (623) 500 0
Total Other Revenue 2,228.054 1 , 129,309 1,392,880
-otal Revenue $ 28,552.746 $ 27.672,343 $ 28.450.4~2.~_
I-~/~ /- -='c.~,
, "
The City of Cappel I ,
...... -'/
General Fund
Expe'lditure Summary
;.\,ctual FY 02 Budget FY 03 Budget
Department 2000-01 Amended Proposed
Mayor and Council $ 181.955 $ 200,822 $ 198,065
City Management 521.053 525,181 575,062
Legal Services 356,329 275,000 300,000
Community Information Services 116.429 140,989 146,655
Finance 526,539 581,703 644,689
Tax Collections 195,876 195, 138 187,795
Combined Services 2.908,927 1,903,699 1. 908.765 ,.-
Human Resources 762,333 853,078 833,273
Purchasing 122.422 141.868 146,099
City Secretary 194,047 211.714 221,568
Records Management 125,531 152,258 152,701
Information Services 4,530 0 0
Information Systems 1.378,965 1,362,365 1. 213,106
Total General Government 7,394,936 6,543,815 6,527,778
Fire 4,838,308 4,992,303 5,362,631
emergency Management 8,844 27,375 91,024
Building Inspections 382,948 404,643 391,152
EnVironmental Health 331,839 372,276 385,777
Municipal Court 716,555 749,745 776,548
Police 4,928,542 5,746,959 6,078,071
Total Public Safety 11.207,036 12,293,301 13,085,203
Engineering 586.458 734.451 836,022
FaCilities Management 965.247 856,607 785,192
Streets 1.007,297 998,816 637.488
Fleet Services 619,129 568,315 627,892
Traffic Control 610,692 646,506 690,236
Planning and Zoning 335.490 360.402 376.939
Total Public Works 4,124,313 4,165,097 3,953,769
Library 1.211,588 1.193,603 1,454,260
Leisure Services 3,611.609 3.553,330 4,391.089
Total Cultural/Recreational 4,823,197 4,746,933 5,845,349
Total Expenditures $ 27,549.482 $ 27,749,146 $ 29.412,099
* Ir,cludes $945,000 IMF Transfer
City of Coppell
Fiscal Year 2002-2003
Line Item Breakdown
Department: Mayor and Council
ACCT. NO. 4220 OTHER PROFESSIONAL SERVICES
Council Photographs
Service contracts
ACCT. NO. 4230 PRINTING SERVICES
Citizen Survey, Quarterly Newsletter
and Other Printed Material
ACCT. NO. 4240 SPECIAL PROJECTS
Coppel! Woman of the Year
Thanksgiving Luncheon
Senior Adult Services
The Family Place
Metrocrest Social Service Center
Red Ribbon Kickoff
New Teachers Breakfast
Christmas Parade
Youth Leadership
Leadership Coppel!
Project Graduation
Children's Advocacy Center for Denton County
Metrocrest Family Medical Clinic
Special Care and Career Services
Coppel! International Music Exchange
Homeland Security I NCTCOG
ACCT. NO. 4320 TRAINING
Various Training Courses Sponsored by COG,
TML and National League of Cities & Austin
L-~JL/J!iJn
$ 700.00
8,300.00
TOTAL $9,000.00
$ 5,500.00
TOTAL $5,500.00
$ 400.00
2,500.00
46,295.00
10,000.00
8,000.00
500.00
600.00
1,000.00
2,000.00
3,000.00
1,500.00
3,500.00
2,000.00
10,000.00
750.00
5,000.00
TOTAL $97,045"QO
$ 18,000.00
TOTAL $18,000.00
,r::::; (;:::;n) Il ~ I
'I ';1' f ,'A' ,/ ,~
J' / '-' ' //1' ,
G / / n /~~ i i -,
i-- / !-)' l....'L/iJL:r- ,
City of Coppell
Fiscal Year 2002-2003
Line Item Breakdown
Department: Mayor and Council
ACCT. NO. 4340 DUES & MEMBERSHIPS
Texas Municipal league
NCTCOG
Metroplex Mayors Commission
Dallas Regional Mobility Coalition
North Texas Commission
National League of Cities
SW Legal Foundation
Chamber Luncheons
National Civic League
Chamber of Commerce
Tex-21
$ 3,000.00
3,500.00
450.00
3,350.00
3,057.00
2,000.00
75.00
720.00
275.00
10,000.00
5,000.00
TOTAL
$31,427.00
ACCT. NO. 4350 BOARDS & COMMISSIONS
Boards & Commissions Expenses
$ 3,500.00
TOTAL
$3,500.00
ACCT. NO. 4370 PUBLICATIONS & SUBSCRIPTIONS
Publications
$ 1,000.00
TOTAL
$1,000.00
ACCT. NO. 4950 CONTINGENCY FUNDS
Contingency Funds
$ 15,000.00
TOTAL
$15,000.00
City of Coppell
General Fund Analysis
Combined Services
!'(=::)@~n
'I 1/
,-Lj~i ,L1 b'
2002 2002 2003 Difference
Adopted Amended Proposed Amended/
Budget Budget Budget Proposed
Combined Services
Salaries 22,470 22,470 28,550 6,080
Supplies 51,660 51,660 58,675 7,015
Maintenance 31,904 31,904 31,900 (4 )
Services 374,440 374,440 444,640 70,200 Ins $40,000; Hlth Ins Consult $22,500
Transfer Out 1,003,000 1,423,225 1,345,000 (78,225) Hold account for round 2 budget cuts.
1,483,474 1,903,699 1,908,765 5,066
City of Coppel'
General Fund Analysis
Mayor and Council
2002 2002 2003 Difference
Adopted Amended Proposed Amended/
Budget Budget Budget Proposed
Mayor & Council
Salaries 0 0 0 0
Supplies 3,900 3,900 4,593 693
Maintenance 0 0 0 0
Services 237,422 196,922 193,472 (3.450)
Capital 0 0 0 0
241,322 200,822 198,065 (2,757)
--....
~ \ /r--.;
.' /;'.'.c-..~)! 01 I~. '
~ '-../ 1;--", ~ i ' '-- -
- "'" I: Ir' /
L
-,
-, . /~) .;
City of Coppeli -/ ;:, . /'":::::r:--,
~ ,/11 '-- '-"
General Fund Analysis ' I '-' I! . I
~UU /:
City Management '-J
2002 2002 2003 Difference
Adopted Amended Proposed Amended/
Budget Budget Budget proposed
Administration
Salaries 430,897 430.897 483,578 52,681 Includes 4 year contract payment
Supplies 7,405 6,905 6,905 0
Maintenance 810 1,179 1,179 0
Services 113,700 86,200 83,400 (2,800)
Capital 0 0 0 0
552,812 525,181 575,062 49,881
Legal
Salaries 0 0 0 0
Supplies 0 0 0 0
Maintenance 0 0 0 0
Services 275,000 275,000 300,000 25,000 Increased LerJal costs
Capital 0 0 0 0
275,000 275,000 300,000 25,000
Community Information
Salaries 83,679 60,699 64,875 4,176
Supplies 4,660 4,160 4,660 500
Maintenance 0 0 0 0
Services 126,530 76,130 77,120 990
Capital 4,392 0 0 0
219,261 140,989 146,655 5,666
City Secretary
Salaries 157,504 157,504 167,493 9,989
Supplies 16,900 16,910 16,900 (10)
Maintenance 500 890 500 (390)
Services 41,975 36,800 36,675 (125)
Capital 0 0 0 0
216,879 212,104 221,568 9,464
Records Management
Salaries 91,623 91,623 93066 1 ,443
Supplies 6,735 6,735 6.735 0
Maintenance 500 110 500 390
Services 77 ,400 53,400 52,400 (1,000)
Capital 0 0 0 0
176,258 151,868 152,701 833
~~
City of Coppell LLJiRJ!JFf
General Fund Analysis
Engineering
2002 2002 2003 Difference
Adopted Amended Proposed Amended/
Budget Budget Budget Proposed
Engineering
Salaries 747,294 676,614 765,932 89,318 Position held vacant 2001002
Supplies 8,175 6,463 6,825 362
Maintenance 10,525 8,125 10,025 1,900
Services 49,505 34,055 41,240 7,185
Capital 1,500 9,194 12,000 2,806
816,999 734,451 836,022 101,571
Facilities
Salaries 188,948 178,184 185,492 7,308
Supplies 21,655 17,405 19,525 2,120
Maintenance 170,000 156,000 156,000 0
Services 380,875 336,843 424,175 87,332 $155,000 Arch Design for Police Remodel
Capital 161,950 168,175 0 (168,175) No capital in 2003 year
923,428 856,607 785,192 (71,415)
Streets
Salaries 478,338 478,338 498,183 19,845
Supplies 18,000 15,405 16,000 595
Maintenance 361,875 365,140 90,875 (274,265) Funded by IMF in 2003
Services 20,105 10,405 15,230 4,825
Capital 244,528 129,528 17,200 (112,328) Crack Sealer & Vehicle
1,122,846 998,816 637,488 (361,328)
Fleet
Salaries 229,928 208,544 217,050 8,506
Supplies 222,060 148,722 182,577 33,855 Fuel $30,000
Maintenance 207,200 202,274 207,000 4,726
Services 12,625 8,775 10,165 1,390
Capital 32,710 0 11 ,100 11,100 See Capital List
704,523 568,315 627,892 59,577
Traffic
Salaries 197,793 197,793 215,596 17,803
Supplies 10,765 8,308 9,100 792
Maintenance 88,300 82,855 74,800 (8,055)
Services 315,250 302,550 370,740 68,190 Electric for Street Lights $65,000
Capital 95,000 55,000 20,000 (35,000) Sign Lettering Machine
707,108 646,506 690,236 43,730
City of Coppell -
.. .~-~J--
General Fund Analysis -..J
Fire
2002 2002 2003 Difference
Adopted Amended Proposed Amended!
Budget Budget Budget Proposed
Fire
Salaries 4,414,636 4,407,751 4,588,796 181,045
Supplies 169,140 156,527 151,700 (4,827)
Maintenance 32,690 25,728 25,520 (208)
Services 364,610 348,489 334,615 (13,874)
Capital 98,776 53,808 262,000 208,192 See Capital List
5,079,852 4,992,303 5,362,631 370,328
Emergency Management
Salaries 0 0 75,204 75,204 Traded Position
Supplies 3.675 9,230 2,575 (6,655)
Maintenance 6,700 6,470 6,230 (240)
Services 7,575 7,575 7,015 (560)
Capital 19,000 4,100 0 (4,100)
36,950 27,375 91,024 63,649
Inspections
Salaries 401,392 381,832 368,012 (13,820) Traded Position
Supplies 8,160 7,484 6.865 (619)
Maintenance 1,185 1,135 1.420 285
Services 16,535 14,192 14,855 663
Capital 1,950 0 0 0
429,222 404,643 391,152 (13,491)
Environmental Health
Salaries 301,359 299,359 322,787 23,428
Supplies 26,375 25,337 22,555 (2,782)
Maintenance 1,600 1,540 1,400 (140)
Services 42,075 38,541 39,035 494
Capital 27,899 7.499 0 (7,499)
399,308 372,276 385.777 13,501
City of Coppell
General Fund Analysis
Finance
Administration
Salaries
Supplies
Maintenance
Services
Capital
Tax
Salaries
Supplies
Maintenance
Services
Capital
2002
Adopted
Budget
481,321
13,045
350
139,905
o
634,621
2002
Amended
Budget
466,321
14,181
350
100,851
o
581,703
'':::\ ,........,
,.--; / 'l 'J: ,----
'i'~'/I: I~'~;
L.' /..1 / , L'I ,: L --
-- _./ ;~jJ:._}IJr-'
2003 Difference
Proposed Amended/
Budget Proposed
506,129
11,395
350
126,815
o
644,689
39,808 Position on hold 2001-02
(2,786)
o
25,964 Arbitrage deferred to 2002-03
o
62,986
96,534
960
o
121,685
o
219,179
65,681
1,040
o
128,417
o
195,138
65,635
1,100
o
121,060
o
187,795
(46) Position cut - Contingency
60
o
(7,357) No longer needed Temp Svcs
o
(7,343)
-~-~'."
-_.
--',
City of Coppell
General Fund Analysis ,-f
Human Resources
2002 2002 2003 Difference
Adopted Amended Proposed Amended/
Budget Budget Budget Proposed
Administration
Salaries 551,749 551,749 515,208 (36,541) Reorganization
Supplies 7,300 7,300 7,300 0
Maintenance 0 254 0 (254)
Services 346,855 293,775 310,765 16,990 Compensation Study $15,000
Capital 1,500 0 0 0
907,404 853,078 833,273 (19,805)
Purchasing
Salaries 124,728 120,228 122,420 2.192
Supplies 2,480 2,480 5,480 3.000
Maintenance 1,085 1,085 1,085 0
Services 23,799 18,075 17,114 (961 )
Capital 2,810 0 0 0
154,902 141,868 146,099 4,231
Municipal Court
Salaries 517,501 489,981 514,121 24,140
Supplies 15,908 12,758 12,758 0
Maintenance 2,511 2,511 3,060 549
Services 246,695 233,333 241,157 7.824
Capital 41,869 11,162 5,452 (5710)
824,484 749,745 776,548 26,803
-t --
'- ~
City of Coppell ,o.i. ' ,- , ,
General Fund Analysis -.
Planning
2002 2002 2003 Difference
Adopted Amended Proposed Amended/
Budget Budget Budget Proposed
Administration
Salaries 342,172 342,172 353,359 11,187
Supplies 3,680 2,880 3,380 500
Maintenance 200 200 200 0
Services 22,350 15,150 20,000 4,850
Capital 0 0 0 0
368,402 360.402 376,939 16,537
f";:'.F;J
City of Coppell I,,", I ,...., .i1 r--r-
/L. ,/'; .::://'2t! / c--. ._~
General Fund Analysis i ,~
.- ,
Library
2002 2002 2003 Difference
Adopted Amended Proposed Amended!
Budget Budget Budget Proposed
Library
Salaries 918,279 886,804 1,010,560 123,756 Delayed hiring dates 2001-02
Supplies 29,470 24,775 28,135 3,360
Maintenance 4,695 3,195 3,895 700
Services 208,840 168,829 246,670 77,841 Long Range Plan $60,000
Capital 217,000 110,000 165,000 55,000 Additional in Books $15,000
1,378,284 1,193,603 1,454,260 260,657 Shelving $40,000
City of Coppell
General Fund Analysis
Police
Police
Salaries
Supplies
Maintenance
Services
Capital
2002
Adopted
Budget
~(RJfiWlf~ .
- II
<oj
2002 2003 Difference
Amended Proposed Amended!
Budget Budget Proposed
4,596,642 4,536,172 4,931,223
126,665 120,424 114,665
84,921 84,921 116,492
332,418 274,017 261,258
262,598 731,425 654,433
5,403,244 5,746,959 6,078,071
395,051 Added 2 Dispatchers $78,000; $80,000 Increased OT
(5,759)
31,571 Keep Cycles 1 year longer MV Maint $10,000
Contract with Lewisville on Radios $21,571
(12,759)
(76,992) See Capital List
331, 112
City of Coppell
General Fund Analysis
Information Systems
Administration
Salaries
Supplies
Maintenance
Services
Capital
2002
Adopted
Budget
350,432
19,790
167,553
371,147
472,552
1,381,474
2002
Amended
Budget
350,432
12,727
141,053
323,598
534,555
1,362,365
~H
2003 Difference
Proposed Amended/
Budget Proposed
433,626
18,450
214,564
244,533
301,933
1 ,213,1 06
83,194 Reorganized the Department
5,723
73,511 Police CAD $39,670; Library $39,688
(79,065) Wiltellease completed
(232,622) See Capital List
(149,259)
City of Cappel' @~[5[
General Fund Analysis
Leisure Services
2002 2002 2003 Difference
Adopted Amended Proposed Amended!
Budget Budget Budget Proposed
Administration
Salaries 1,773,315 1,760,787 1,862,850 102,063
Supplies 28,041 30,635 28,828 (1,807)
Maintenance 7,545 7,545 8,895 1,350
Services 133,825 113,693 115,300 1,607 Temporary and Contract Services
Capital 21 ,094 9,901 15,047 5,146
1,963,820 1,922,561 2,030,920 108,359
Parks
Salaries 0 0 0 0
Supplies 168,233 144,848 123,561 (21,287) Chemicals $6,165; Bot & Ag $12,752
Maintenance 114,226 104,555 88,600 (15,955) Grounds $10,765; Irrigation $5,190
Services 75, 1 64 65,172 110,866 45,694 Electric $27,002; Contract for Maintenance $15
$15,817 - Aerators, Ice Machines
Capital 90,783 30,992 212,642 181,650 See Capital List
448,406 345,567 535,669 190,1 02
Right of Way
Salaries 0 0 0 0
Supplies 23,446 21,101 21,071 (30)
Maintenance 300 270 300 30
Services 7,948 5,265 7,153 1,888
Capital 9,283 9,283 4,642 (4,641)
40,977 35,919 33,166 (2,753)
Senior Citizens
Salaries 0 0 0 0
Supplies 4,630 4,170 4,154 (16)
Maintenance 0 0 1,180 1,180
Services 20,360 17,479 19,445 1,966
Capital 0 1,381 0 (1,381 )
24,990 23,030 24,779 1,749
rr))~[?77
L-0 iJ ,~.
City of Coppell
General Fund Analysis
Leisure Services
2002 2002 2003 Difference
Adopted Amended Proposed Amended/
Budget Budget Budget Proposed
Recreation
Salaries 822,632 787,632 960,276 172,644 Additional hours for full coverage
Supplies 76,372 71,630 86,615 14,985 Snack Shack $15,400 -- was Fund 17
Maintenance 11,570 11,570 36,500 24,930 Fitlinxx Contract $15,000; E-connect $5,000
Dectron Licensing $3,600
Services 254,605 209,315 308,859 99,544 Fund 17 -- Instructors $78,000; Other $15,400
Capital 0 0 25,000 25,000 See Capital List
1,165,179 1,080,147 1,417,250 337,103
Ballfield Maintenance
Salaries 0 0 0 0
Supplies 31,020 27,903 28,887 984
Maintenance 55,800 38,135 50,220 12,085 Grounds Maintenance $12,100
Services 59,430 71,983 185,967 113,984 Electric for Ballfield Lights $132,000
Wagon Wheel, Soccer and MacArthur
Capital 8,085 8,085 8,086 1
154,335 146,106 273,160 127,054
Tennis Center
Salaries 0 0 13,000 13,000 New Program
Supplies 0 0 28,295 28,295 New Program
Maintenance 0 0 1,700 1,700 New Program
Services 0 0 28,150 28,150 New Program
Capital 0 0 5,000 5,000 New Program
0 0 76,145 76,145
":::::'1.-, n
.' r::- " f! /-::::::;r---.<i
, IL. ----
-'
City of Coppell
Proposed FY 02-03
Personnel Additions
II
Department
Position
Emergency \lanagement
BuIlding Inspections
Poltce
Recreation
Tennis Center
Emergency \lanagement Coordinator
Building Inspector
Entry-Leve! Dispatcher
Add'! hrs for full coverage (~o FT positions)
Front Desk Cashier (PT coverage)
General Fund Totals
~
-
-., -
"
'--- ~. --
-::J
0
,...
::: -::J
0 S
:::
0 ,...
0
Vl ,...
0 0
-::J 0- ''::
0 ~ Vl
..= ,... ~ 0
~ ...J C.
::: g u
0 ,... '-
'" > ()
- ,... 0 ()
- ;>-0
0 0 ~ :::
'';::: ~ ~ Vl 2
~ -:/] 2 0
:: 0 0- W
"'0 C. u U
v Q) >-.
0::: --- VJ I- ......
,... :cj
c::i () :::l U
- u > ':)J)
'- :cj ~
c:: ~ ,...
..... > ~
~ -- -1
~ ~ Vl
N .;::: Vl -::J Vl
"0 u c ~ Vl
Q) Q) --<
- c. ,...
- Vl c :c :;1,)
.... ::: -::J
0 .- :::
0::: 2 <( 0
() ::5 c::;
u 1)
'-' .- Q) :::
c::i I- 'SJ
,... U
:::l 0 :::
cc: ~ ~ Cl.J
~
-"
U
,...
0
Vl
~ 0
...J 0-
'" u ~
.-
= ::: I3
0 0
~ Vl
.....
~ ...... --- Vl Vl
:::l Vl
.... U :::l 0 <t:
"'0 u C.
,...
<:J 0 C ~ Vl
,y 0 ,...
- ";:: ~
= ---
Vl ~ --- ...J
0 -" UJ 2 u Sb
c:: u 0 ~
..... C. ...J U .- 2
VJ ::: 0- () () 0
..... ~ VJ .,- n..
- .- ~ ::: ---
r:; I- ~
- Q) 0 () Vl :::l ~
v; UJ > 0 u
Q,., Vl ~ U ~ c. ::: 3
c. Vl e
;;.- Vl X 0 I- 0
<t: () ,...
~ ~ .- c. ~ ::: ...J
= r::: Vl () ,... u
::: ..;.<: ,- Vl
<:J ,... t:: ::: :::
... 0 2 ~ u 0 0
- .- ,... 0 0- U 0
--- ~
- ,- u u -a I- ~
..... .v u >-. t-
,... () Q) Vl
- .- ~ < :2
c VJ > () u n.. c
Vl 0 U t;:: C.
,... W ~ Vl .- ~ <.,.., Vl
C --- ,... ;; -" VJ 0 QJ ,...
'.J c () .- u
~ () 0 u 0 u
,
0.. U ~ >-. :..r.- ..... ~ '-' E c u
:: ~ u ,... -3
-" ----- ~ 1) :::
:) , c Vl :oJ :cj VJ ,...
-' :oJ
() 0 ~ c. C- o.. u
- :::: '~ ,... ~ ~ 0
:: ,... U u 1) 1)
r-l .- - ..... ,... U u
>-. - 5 ,~ x 0 Vl VJ
>-- :cj B :::l 0
~ U ~ 0 ()
-' e/:; C-l-. '- C-l-. C- n.. -1 ~
2etail of Capital :Jutl,,! ::'ver $10,000
;:- seai Year 20022003
':;eneral Func
Departmerot
::.rlglneerlng
:3~;eets
~ rahc Control
F!re
_.brary Serv'ces
Pel Ice
i'iiJrC"latloll Syster:-s
Oescrl~tion
Toshiba Copier
Total E 19lneerlng
~ease Payments
Total Streets
~ed Traffic Lights
~otal T'afflc Control
Vehicle for Battalion Chief
MICU (_ease)
Thermal Imaging ~ackage (Comprehensive Package
With (3) handheld thermal ur,lts, remote monitors &
telemetryeqUlpn-'ent)
Lease F)ayrnents
TotaiFre
Library Media
Shelvl ng
Total L brary Services
Replacement Taroes
Lease F)ayrnents
Total Police
Computer Hardware Expansion:
Workstation u:::gcades (3 yr cld PC's)
New.ork bacl<uc disk arra:,
Computer Software Expansion
Oneprlnt 16:Jcrt upgrade 'or Service Center ;::c ,cters
Netvvork backL..o software
Safewatch Clcense for additional PC's)
Arcserve 2000 (backup/recovery vendor upgra:::e)
New World GJI server system
New World GiJl user seats
Telephone connectivity for Te:ln:s Center
Hardware requests from departments:
Large Docume:lt Scanner
Flattled Scarner
Replacement laptop for Bat'lilon Chief
Replacement laptop for A rM'l a I Services DIVIS .:~
Notebook CO'T1puter for Errergency Manageme~:
Hub'; to expar,d drops In EGC
DesHop com:Juter for Inveltory control
Printer for Inventory contr:;1
Color Laser Pr:rter for SerJce Center
External USBCD-RW Orve
Photo color printer for pOlce lineups
Software requests from departments:
Webr:nk E1ter;::rlse
'.PJ!JFf!'
_.. 'I ~ '
- - ~
Dollar
Value
$
12,000
12,000
11.200
11. 200
20,000
20.000
40,000
105,000
50,000
67,000
262,000
125,000
40,000
165,000
440,000
214.433
654.433
30,500
20,000
10,500
29,925
10,000
4,650
6.250
1,300
6,500
1.225
18.500
31,600
12,900
3,500
3,000
3,000
3,000
300
1,000
1.200
3,000
300
400
47,308
8,010
Account
Number
01-03-12.5060
01-03.145500
01.03435060
01.04-09.5010
01.04-09-5290
0104.09-5290
010409-5500
010908-4983
01-09.08-5030
01-10.01-5010
011001-5500
01-11015000
0111-015000
01.11.01.5000
011101.5000
City Secretary
City Secretary
Fire
Fire
Fire
Fire
Fleet Services
Fleet Services
Lei su re Services
Police
Police
City Secretary
Detail of Capital OutlayJ.e' $10,000
Fiscal Year 20022003
General Fund
Department
~elsure Services
Parks
Recreation
Descrlpkm
Land DeSKtop (2)
Civil Package (2)
Survey Package (2)
Maintenance! Support
NW Desktop Interface (report writing)
Crystal Reports (appllcatlor tool)
Microsoft 2000 OS (10 user licenses)
NW De~;ktop Interface (report writing)
QWIZ .Appllcant Testing (MS Office)
Microsoft 2000 OS (50 user icenses)
Microsoft Office XP (forensIc eVidence deVice)
_ease anc Tax Payments
-otal Infol-mallon Systems
Copier and Fax Machine
-otal Lels.He Services Admin
::Jtfront f\lowers (3)
:;otary Mower
At:lletic Field VaCL;um
:;eplacement Landscaping
_Jndscapng and irrigation for Service Center
:Jlayground equipment. Duck Pond
-Jtal Parfs
:Jump :;eplacer;lents
- Jtal :;ecr eatlon
::;rand Total General Fund
Dollar
Value
6,693
4,015
1,334
1.035
5,000
800
2,200
5,000
2,000
11 ,000
220
144,100
301.933
11,500
11.500
48.000
25.000
15,000
10,000
40,000
70.000
208.000
25,000
25.000
$ 1,646.066
~.';/WJ~ H.
~,!
~ ....
Account
Number
Engineem'g
Engineering
Engineering
Engineering
Finance
Finance
Fire
Human Resources
Human Resources
Police
Police
01.11015500
0112015060
0112155060
0112-155060
0112-15.5060
011215 5130
01- 12 -1 5 5 1 30
0112-155140
0112-325060
---..
~. /r-
--'r----
Contingency and Five Year Plan
Items remaining to be funded - FY 2002-03
Department Amount Notes
Engineering 35,000 Inspector Vehicle
*** If the top 3 Tahoes from the Police
Department can be moved to Engineering
Inspector Vehicles would not be needed.
Facilities 150,000 NC Town Center
150,000 FS 123 Remodel - Associated with Company
Streets 75,000 Brick Paver Program
Fire 656,650 Crew and Associated Costs
40,000 1 staff vehicle
75,000 Lease for New Fire Truck
***2 vehicles are scheduled to be replaced
for front line purposes. If the old front line
vehicle can remain in the department,
Inspections and Environmental Health
vehicles will not be needed.
Finance 3,000 Every Year - Arbitrage Issues
Tax Collections Allowed to increase Services due to DCAD
Library 44,457 Library Technician
75,000 Books
6,000 Replacement Furniture
Police 34,929 1 Patrol Officer
60,000 3 Replacement Vehicles
20,000 New Vehicle - Moved to 2003-04
37,000 Furniture - Moved to 2003-04
Information Systems 75,000 E-Gov Solutions
40,000 Software for E-Gov
Leisure Services Administration 20,000 Replacement Vehicle
13,000 Community Program Assistant to Full Time
54,000 2 Maintenance Workers
82,000 2 Parks Supervisor
40,000 2 Tennis Instructors - Possibly Fund 17
40,000 3 Tennis Attendants
Parks 6,000 Trash Receptacles/Feces Control
5,000 Sprayer
70,000 Replacement Vehicles
_5J{ffJ!J1f:rf
Contingency and Five Year Plan
Items remaining to be funded - FY 2002-03
Department
Amount
Notes
Right of Way
15,000 15" Mower
1,000 Curb Dresser
Recreation
74,126 3,09 FTE Positions throughout Center
5,000 Indoor Fence
***$25,000 was added each year to cover
equipment replacement
Ballfield Maintenance
1,000 30" Mower
2,003,162
Contingency Plan Cuts
Round 2 Holds
1,579,608
589,825
2,169,433
City of Coppell
Unfunded Projects
FY 2002-OJ
Parking cover
Additional funding for the Tennis Center
Fire Apparatus
Battery Backup for Traffic Signals
e-Gov Initiative
Gis Technician
No additional cre\\s
Streets and Parks (6 maintenance worker positions)
Old Coppell
Mass Transit
Stom1\vater Drainage
Grant Matching Funds
'---
L__.'
s
110,000
125,000
800,000
150,000
195,000
60,000
200,000
')')
??
??
')')
S 1,640,000
-
~
, .
- -'---.
,
~,-
'- L..
THE.CITY,OF
AGENDA REQUEST FORM
corrELL
*~~~\~:~
~ ~ ~ ,," CITY COUNCIL MEETING: July 9,2002
<5 '
ITEM #
~b~-'::~~
ITEM CAPTION: Consider approval of an Ordinance of the City of Coppell, Texas, appv ...
amendment to Ordinance No. 2001-959, the budget for Fiscal Year October 1, 2001 through Sept,_
2002, and authorizing the Mayor to sign.
r---
.' ,....-
-". 1-'
,.--..,. ',..1
;,-=~I:~--'
SUBMITTED BY: Jennifer Armstrong
TITLE: Director of Finance
STAFF COMMENTS: See attached memorandum for details.
BUDGET AMT $ AMT EST. $
FINANCIAL COM1vlENTS:
+ \-BID $
DIR. INITIALS: FIN. REVIEW:
CITY MANAGER REVIEW:
Agenda Request Form - Revised 5 00
Document Name Sbudamn3doc
AN ORDIl'IANCE OF THE CITY OF COPPELL, TEXAS
ORDINA:\TE NO.
AN ORDINANCE OF THE CITY OF COPPELL, TEXAS APPROVING AN
A:\lENDMEl'iT TO THE BUDGET FOR THE CITY FOR THE FISCAL YEAR
OCTOBER 1, 2001 THROCGH SEPTEMBER 30, 2002; PROVIDING THAT
EXPENDITURES FOR SAID FISCAL YEAR SHALL BE :\IADE IN ACCORDANCE
\VITH SAID BUDGET; AND DECLARING AN EFFECTIVE DATE.
\VHEREAS, the Budget Officer of the City of Coppell. Texas, did on the 2nd day of
August, 2001, file with the City Secretary, a proposed general budget for the City covering the
fiscal year aforesaid. and
WHEREAS, the City Council of the City ofCoppell approved said budget on the 11th day
of September, 2001. and
\VHEREAS, the goveming body of the City has this date considered an amendment to said
budget;
NO\V, THEREFORE BE IT ORDAlNED BY THE CITY COUNCIL OF THE CITY
OF COPPELL, TEXAS:
SECTIOl'll. That Section ~o. 2 of Ordinance I\o. 2001-959. for the 2001-02 Fiscal Year
Budget. is hereby amended as follows:
General Fund
Current Budget
Amending Budget
Change
Revenues
527,672,343
527,322,343
($350,000)
Expenditures
Combined St:?rvices
S 1 ,863.699
$3,029,699
($1,166.000)
Total Expt:?nditure Increase
Less Designated for Service Center':vlinyards
Net Decrease in Projected Fund Balance
$1,166,000
(1.016,000)
iS350.QQQJ
ill 1)\\1.....1) Ol\[)
Water/Sewer Fund
CU1Tent Budget
Amending Budget
Change
Revenues 51..1-,046,156
Net Decrease in Projected Retained Earnings
$ 13,224,865
(5821,291)
(5821.291 )
Parks Special RevenueFund Current Budget
Amending Budget
Change
Revenues $78,000
Expenditures 5350,000
Net Decrease in Projected Fund Balance
$30,000
$303,365
(548,000)
( 46.635)
(5 1365)
Self Insurance Fund
Current Budget
Amending Budget
Change
Revenues S 1 ,060,000
Expenses S 1,060,000
Net Increase in Projected Retained Earnings
$1,390,000
$1,333,000
$330,000
273.000
$ 57.000
Donations
Current Budget
Amending Budget
Chan ge
Revenues
Expenditures
Net Decrease in Fund Balance
535,000
27,350
536.445
62,010
5 1,455
34,660
$ 33,205
CEDC -Special Revenue
Current Budget
Amending Budget
Change
Revenues SO
Expenditures 0
Net Decrease in Projected Fund Balance
$940,000
935,000
5940,000
935,000
.5._5,QQQ
C.R.D,C. Spec. Rev,
Current Budget
Amending Budget
Change
Reven ues 51.180,000
Net Decrease in Projected Fund Balance
$950,000
(5230,000)
~230.000)
SECTION 2. EFFECTIVE DATE.
That this ordinance shall become effective immediately from and after its passage as the law
and charter in sLlch cases provide.
DULY PASSED and adopted by the City Council of the City ofCoppell, Texas, on the _ day
of June, 2002.
III !)\\l,\[)OIW
ATTEST:
LIBBY BALL. CITY SECRET MY
APPROVED AS TO FORM:
ROBERT E, HAGER, CITY ATTORNEY
IlUD.-\.\I'-DURD
APPROVED:
CANTIY SHEEHAN, MAYOR
----
.I . __4 .--..~
I '"-r I
-- ;~, /:-
2002/03 Property Tax Growth Data
ffj)/r
LLJJLi
Description
7% Growth
8% Growth
9% Growth
'10';1,
Taxable Value Projection
3,480,137,667 3,512,662,318 3,545,186,969
Value of 1 Cent of the Tax Rate
$
344,534 $
347,754 $
350,974 $
Levy Change above/below 8% Growth $
(208,845) $
$
208,845 $
DRAFT
Addt. 1% Homestead with Equivalent Tax Rate Increase
Net Tax Saving on Residential Parcels
2002/03 A V 3,512,662317 Average Res. HS Value 238,274
Addt. HS AV Loss (1%) (22,214,296) HS Expt. Percentage 0.01
Adj. 2002/03 AV 3490448021 Average Expt. Value 2,383
Addt.Tax Rate to No. of HS Parcels 9,323
Replace HS Expt. 0.004128
HS AV Loss 22,214,285
Levy Equivalent to
HS Expt. $ 144,082 Tax Rate 06486
Levy Loss Due to
HS Expt. $ 144,082
Average Res. HS Value 238,274 Average Res. HS Value 238,274
Addt. HS Expt. % 0.01 Average Expt. Value (2,383)
Average Expt. Value 2,383 Av. Res. Value after 1% HS 235,891
Tax Rate 0.6486
Rate to Replace Addt. HS 0.004128
Addt. Average HS Tax Savings $ 1545
Addt. Levy Due To Tax
Addt. Levy Due To Tax Rate Recapture $ 9.74
Rate Recapture (974)
Net Tax Savings on
Residential Parcels $ 5.72
Largest Taxpayers
Name of Taxpayer
Addt. Levy
Due to HS
Assessed T ax Rate
Nature of Property Valuation Recaptu re
Wholesale/Grocery $ 47,951,880 $ 1,97945
Wh 01 esale/Distri b ution 41,952598 1,731 80
Telephone/Utility 39,180,878 1,61739
Multi-Family Complex 30,535.740 1,260.52
Multi-Family Complex 24,907,580 1,02818
Multi-Family Complex 24,000,000 990.72
Multi-Family Complex 23,053,480 95165
Electric Utility 21,997,090 90804
Multi-Family Complex 18,600,000 767.81
S272,179,246 $ 11,235.56
MlI1yard Food Stores
Gulf United Industries
Verlzon
WHCO Rea: Estate
Western Rim Facilities
Fountain View Assoc
Houtex USA Inc
TXU ElectriC
Post Apartments/Homes LP