Loading...
CP 2002-07-25 Budget Workshop 2002-2003 Budget Notebook l\1aster Index Budget \Vorkshop, July 25, 2002 n Budget \Vorkshop, July 1,2002 Budget \V orkshop, June 17, 2002 Budget Workshop, June 3,2002 Budget Workshop, February 19,2002 Budget Meeting July 25, 2002 Agenda I. Final Valuation II. General Fund Changes III. Final Fund Balance Walkforward IV. Discussion Regarding Covered Storage at Service Center V, Quarterly Report CERTIFICATION OF APPRAISAL ROLL Year: 2002 .7 @ Jurisdiction: CITY OF COPPELL In accordance with the requirements of the Texas Property Tax Code, Chapter 26, Section 26.01, paragraphs (A) and (B), the following values are hereby certified: Market Value of all Real & Bus Pers Prop Before Qualified Exemptions" $4,088,148,480 Taxable Value of all Real & Bus Pers Prop After Qualified Exemptions $3,470,245,977 1'L,1,1~, r,("V (, '13, 9Kc:'/f~S) ~ 5/t/13S; 7/~ -r f);!?u7?2> .4f),/)r. 4~e-~ In accordance with the requirements of the Texas Property Tax Code, Chapter 26, Section 26.01, paragraph (CL the following values are hereby certified as disputed values and are not included in the above totals: Market Value Taxable Value Values under protest as determined by the Appraisal District $114,929,260 $108,736,434 Market Value Taxable Value Values under protest as claimed by property owner or estimated by Appraisal District in event property owner's claim is upheld $94,822,740 $92,676,664 /~ 1? i (,) ~ 7 c./:::'c-:9 7-;-[:::- , / I, Foy Mitchell. Jr., Director/Chief Appraiser of the Dallas Central Appraisal District, do hereby certify the aforementioned values and totals to the taxing jurisdiction indicated above, in accordance with the requirements of the laws of the State of Texas. Dallas Central Appraisal District Witnessed hl.~>.': _5.,~h ~'~~;~fHIQ'n,1 : ~_~i7~~{J ':c~,~/c~~~~C~~S~"1~~:~~.:~~:a5 1 -;. . - . .,' r- ~ ;..., . I"; . i f) ...., ) t,". ,'" \... ~ _ ...... u: _ ~ .,.; ~.~- _.......~--- --~~......~........... <<Total Value of New Construction {Included in Certified Market Value above) $181,417,590 2949 N. Stemmons Freeway, Dallas, Texas 75247-6195 (214) 631-0520 c=~ ~ 7 :: 2 Additional Abatements Abatement Improvement Abatement Owner Account Number % Value Loss GSW 180045500A0010000 75% 7,765,270 5,823,953 Texas Dugan (445 Royal) 1800167000004CUOO 75% 9,126,230 6,844,673 Primera III 18001670020010000 75% 7,438,080 5,578,560 Coppell 121 Partners 18005380010020000 75% 10,030,400 7,522,800 Matsushita 99200108500166300 50% 2,879,590 1,439,795 Magoon Estates 18001 0500C001 0000 75% 11,409,320 8,556,990 Texas Dugan (611 Royal) 180016700A0020000 75% 10,187,140 7,640,355 KPT, Inc, 9900000021686530 50% 1,159,600 579,800 43,986,925 @ --"" DALLAS CENTRAL APPRAISAL DISTRICT PRELDlI:s'ARY & L~OFFICIAL ESTD1ATES AS OF 05/18/2002 Jurisdiction: CITY OF COPPELL The following totals are being provided by the Dallas Central Appraisal District to keep you abreast of the periodic changes in estimated values prior to certification of the appraisal roll for 2002. Current Market Value $4,357,924,940 Previous Market Value $0 Amount of Change $4,357,924,940+ Current Taxable Value $3,982,312,366 Previous Taxable Value $0 Amount of Change $3,982,312,366+ Estimated value of New Construction included in Current Market Value aba,e: $207,059,819 2949 N. Stemmons Freeway Dallas, Texas 75247-6195 l'AU! 01/00 l- e:: o a.. LU e:: Z ~ o Cl ::.::: < LU e:: ClJ Z ':"j 0'2 1-'" <~ ::>r--- ...JC5 < V> ><C '" :0 "' .....> o '" 0- N.o "' >< "' ~ '" :0 "' 0> 0", 0- N.o "' >< "' f- '" :0 "' "'> '" '" "'- ......0 "' >< "' ~ aD ~ U ~ ~ ~ ~ ~ """ ~ Q) N .q- m M ,...... a) ,...... ~ ,...... '" u <:: ~ ~ Q I'- ,...... 1..0 f'., <t '" I'- (Y) Lf) 1..0 0 cO cO N ...--i m LO ....-1 0 on (Y) on <t 0 '" I'- (Y) '" :0 "' N> 0", 0- N.o '" >< "' f- aD ~ U ~ '" u <:: ~ ~ Q aD ~ U ~ '" u <:: ~ :E Q aD ~ U ~ '" u <:: ~ ~ Q ~ o ... '" -;;; U <t I'- on o '" <t <t I'- ~ '-f) o ..0 (Y) <t o '-f) on M o (J) I'- N N N '-f) 00 N on '-f) ~ ~ N <t '" N o N ("J 00 N o <t 0 on I'- 00 0 r--- (J) en <t (J) N N '" 00 CD o en N '-f) en 'J2. (Y) N (Y) '" (Y) N 0-> I'- <t (Y) '-D '-D r--- o 0J "- '-f) '-f) <t ""0 <:: "- E E o u on I'- '-f) en en <t 00 I'- (Y) N ~ 00 00 '-f) 00 N '-f) cr) 0-> <t 00 on r--- 0-> o <t- O N N o (Y) on I'- r--- N '-f) o N tf <t I'- c0 '" (Y) o (Y) o N N N 00 ("oJ en o I'- N I'- (Y) 00 '" ;: '" ""0 "' '" Q: '-f) (J) 0_ ~ o (Y) ~ <t '" ~ 6' on on 00 ~ o (Y) <t 00 00 N tf?- ~ o (Y) (Y) <t I'- (Y) '" ~ M 00 '" 0-> on on 0-> (Y) ~ o 00 0-> '" (Y) M tf 00 00 r--- I'- N <t o cr) o I'- I'- <t_ ~ o N ""0 <:: '" ...J ... <C I'- M 00 ~ I'- on N <t ~ (Y) I'- N N 0-> N N cr) (J) ~ rei I'- <t 0-> N I'- N on 0-> (Y) 00- (Y) on '" o 00- o ("oJ ("oJ M tf (Y) (Y) 00 \D I'- 00 \D 00 0-> (Y) '" r--- '-f) 00 00 0-> 00 (Y) 00 N (J) o 00 00 on N C- O a: "' <:: o "' 0; C- on :0 1IJ ...J <C ~ o ~ ~ <J> ~ cO I'- o \D o I'- <t <.0 \D N '" I'- on (Y) <J> 00 ~ on (Y) ~ \D M ci ~ o on (Y) \D N <t on o M (J) o ~ on '" <t N on N (Y) ~ I'- 00 (Y) 00 ~ I'- <t <J> 00 on (Y) 0-> on I'- 00 (Y) o I'- <t <J> N ~ <t <t o o r--- I'- cO I'- (Y) 00 I'- on ~~~ "'~~ N(Y)O NMO 000 on N N (Y)ON OOOJ-""'; 000 <tOON M ,,- 1'-0 ~ ~*~ \D~O OOMO NNO M<J>O '-f)(Y) en (Y) oo~ N\D MO ~OO OO'-f) ~~&'( 00 00 on oeno ~r00 Nr---O <tN'-f) \D~<t (Y')oocn r---(Y)O LO ',.D N on ("oJ ~ 00-> 1f2tf2-tf.. '-D<tN 00000 mMO N\DO en N on on on r--- u) N ,...... f"'-.,.....--iQ If)~m~V) (J)<t NOO <:: ~ o Q "" "' '" Iii ~ 'i o t5 co. 2 <:: a.. ~ ro u c ~ ~ ~ ~ v;c~Qj 5 '" E a.. u ~ E vi f~8ci3 z ~~ ~ NO (Y) 0 q-.---l m 0 "";rri 0 ci r;:)T"- ,...... l..O 1'-'" U1 '" 1..0.......-1 00_ l..O 0)0- (J'l N OLO (j) ...... NO-> ("oJ <.00 0 <to (Y) ~~ ~~ tf, l..OlD CO 0 1'-0-> <t 0 O~ N 0 <tU1 <J> 0 0l.D N to r---.Q N l.[) ~- .....; 0) oci mm m .q- N U1 ~ N"r--: cv) Non r--- tf,tf, tf, N.......... (Y) .......... ...--Ilj) o:::t 0 O<:t 0 """"'0 CO (Y) ml..D (Y) ill N (Y) r--... t.O r--..(Y) m L() .q(Y) 0 (Y) ~M (J) Me) 1..0 ~ (Y) *-* (J)OO N "";..-j tf, r--- (J) oo<t 000 r---<t illr'" \D(Y) en<t OON N(J) '-f) N ~ cr) r--- <t M <t ":":--0 (0 c ~ .~:::::: C ~E~ ~ ~ ~ ~oa::: Q: C- ~ C- -;;; <:: o "' 0; C- on :0 1IJ ~ <J> ~ cO I'- o <D o I'- <t <.0 '" N tf, '-f) (Y) ci ~ o on (Y) ..0 N <t u) o (Y) tf, r--- 00 (Y) ~ ~ 00 r--- <t- (J) 00 U1 (Y) o D M o q tf, <t r....: N <t- O (J) o r--- <t o ~ c5 r--- I'- 00 r--- M ""0 <:: '" ...J ... <C ~ 'i o t5 "' '0 f- Assessed Valuation for 2002-03 (100%) Proposed Tax Rate Revenue from 2002-03 Taxes Estimated Collections Total Estimated Funds Available General Fund Bonded Indebtedness City of Coppell Estimated Ad Valorem Tax Collections and Proposed Distribution Fiscal Year 2001-2002 $ 3,518,935,716 0.64860 22,823,817 99.00% $ 22,595,579 Proposed Distribution of Tax Collections PERCENTAGE TAX RATE PER $100 AMOUNT 66.75% 33,25% $ $ 0.43296 0.21564 15,083,228 7,512,351 100.00% $ $ 0.64860 22,595,579 MEMORANDUM Date: July 16, 2001 To: Jennifer Armstrong, Director of Finance Stephanie Tumlison, Tax Assessor/Collectr From: Subject: Anticipated Collection Rate for 2002 & Excess Debt Collections in 2001 -------------------------------------------- -------------------------------------------- Pursuant to Section 26.04 of the Texas Property Tax Code, I have certified the anticipated collection rate for the period of July 1, 2002 through June 30, 2003 to be 99%. The purpose of this law is to permit a taxing unit to adjust the debt portion of its effective/rollback tax rate to account for anticipated delinquencies. The truth-in-taxation laws of Chapter 26 also require the Tax Assessor/Collector to compare the amount of debt tax dollars actually collected during the period from July 1, 2001 through June 30, 2002, with the amount of debt tax dollars that should have been collected according to the 2001 anticipated collection rate. If a taxing unit collects more debt tax dollars than should have _ been collected, the collector certifies the excess amount to the governing body. The adjusted amount of debt tax dollars levied in 2001 was $6,788,600.00, however, the actual debt collections during the same period was $6,953,036.48. Therefore, I have certified that $164,436.48 is the full, true and correct amount of excess debt collections. The above stated anticipated collection rate and the amount of excess debt collections will be used in the calculation of the effective/rollback tax rate for 2002. Attached is the certification of these two items to be approved by the City Council. CERTIFICATE OF THE TAX ASSESSOR/COLLECTOR ST A TE OF TEXAS X COUNTY OF DALLAS X CITY OF COPPELL X I, Stephanie Tumlison, the undersigned, Tax Assessor/Collector of the City of Coppell, Texas, a municipal corporation, in the performance of the functions of my office, hereby certifies that 99% is my estimate of the anticipated collection rate for the period of July 1, 2002 through June 30. 2003, and, that $164,436.48 is the full, true and correct amount of excess debt taxes collected for the period of July 1, 2001 through June 30. 2002, in accordance with Section 26.04 of the Texas Property Tax Code. WITNESS MY HAND AND THE OFFICIAL SEAL of the City of Coppell, Texas, on this the ~~ay orn' 2001. ( seal) s~~ \~~ Stephanie Tumlison , Tax Assessor/Collector City of Coppell TO AND SUBSCRIBED BEFORE ME on this the J5~day of ,2002, \\1\111111/// \\\ II, "" \~'O'( BAll I", ....." ~ ........... ,.~ ... ..~~y PUs '. " :::: .0" '</.... ~ ~ :< * 0" ~ - : : : - . .*- =*. . = :: : c,: ::. ~ ,p~ i-'t"... -::- '. -1""E:OF~." .. ".... . ~ ~.. -.. EXP1Rt." ..- ~ - "." ........ ~ " '/'1 6_ 11 _ 2()'iJ "" fff \\\ "11/111111\\ cXJl.L7J l.3a~ Sheet1 INTEREST & SINKING COLLECTED --------------------- ...---------.-------- --- _ u_~~ly_~ 20Q1 thur J.tJr1.~~_Q,}00_2 I. 7-1-01 thru 9-30-01 Current - ---- Delinquent P& I Rollback $31,021.87 ~----------- $5,449.74 - - "------------- $8,534.49 $297.32 $45,303.42 --- II. 1 0-1-01 th ru 6-30-02 Current Delinquent P&I Rollback $6,771,452.25 $30,520.80 ------------- $31,34418 $74,415.83 $6,907,733.06 Totall&S Collections - $6,953,036.48 2001 Adj. Debt Service (per 00 ETR Calc. Worksheet line 35) $6,788,600_00 EXCESS DEBT COLLECTIONS $164,436.48 Page 1 2002 PLANNING CALENDAR August 2, 2002_ Publication of EffectivelRoIlback Tax Rates, Schedules and Fund Balances August 13, 200~ Vote to Propose a Tax Increase and Certification of Anticipated Collection Rate August 16. 2002 "NOTICE OF PUBLIC HEARING ON TAX INCREASE" (1 ST Quarter-Page Notice) at least seven (7) days before the public hearing. August 23, 200L Post 72-hour notice for public hearing August 27. 200=~ PUBLIC HEARI0iG: Schedule and announce meeting to adopt the Tax Rate. (3 to 14 days from this date) , September 6.2002 "NOTICE OF VOTE ON T.~X RATE" (2nd Quarter-Page ~otice) Publish before meeting to adopt the Tax Rate. (No seven day rule). SePtember 6. 2002 Post 72-hour notice for meeting to adopt tax rate SePtember I O. 200~ Meeting to adopt Tax Rate. (3 to 14 days after the public hearing). 2002 Property Tax Rates In City of Coppell This notice concerns 2002 property tax rates for City of Coppe] I. It presents information about three tax rates. Last year's tax rate is the actual rate the taxing unit used to determine property taxes last year. This year's effective tax rate would impose the same total taxes as last year if you compare properties taxed in both years. This year's rollback tax rate is the highest tax rate the taxing unit can set before taxpayers can start tax rollback procedures. In each case these rates are found by dividing the total amount of taxes by the tax base (the total value of taxable property) with adjustments as required by state law_ The rates are given per $100 of property value, Last year's tax rate: Last year's operating taxes Last year's debt taxes Last year's total taxes Last year's tax base Last year's to tal tax rate This year's effective tax rate: Last year's adjusted taxes (after subtracting taxes on lost property) This year's adjusted tax base (after subtracting value of new property) = This year's effective tax rate x 1.03=maximum rate unless unit publishes notices and holds hearing This year's rollback tax rate: Last year's adjusted operating taxes (after subtracting taxes on lost property and adjusting for any transferred function, tax increment financing, and/or enhanced indigent health care expenditures) This year's adjusted tax base = This year's eth:ctive operating rate .x 1.08 = this year's maximum operating rate ... This year's debt rate This year's rollback rate $14,38],398 $6,926,080 $21,307,4 78 $3,285,149,245 0.64860 ISIOO $20,969,831 $3,337,518,126 0,628301S100 0,64714/$100 $14,152,347 $3,337,518,126 0.42404 /$100 0.45796/$100 02l564/$100 0,673601$100 Statement of IncreaseJDecrease If City of Coppell adopts a 2002 tax rate equal to the effective tax rate of SO.62830 per SI00 of value, taxes would increase compared to 2001 taxes by S801,995, Scbedule A Unencumbered Fund Balances The following estimated balances will be left in the unit's property tax accounts at the end of the fiscal year_ These balances are not encwnbered by a corresponding debt obligation, Type of Property Tax Fund Balance General Operating Debt Service $2,399,399 $381,282 Schedule B 2002 Debt Service The unit plans to pay the following amounts for long-tenn debts that are secured by property taxes, These amounts will be paid from property tax revenues (or additional sales tax revenues, if applicable). Principal or Interest to be Contract Payment Paid from Otber Description to be Paid from Property Amounts of Debt Property Taxes Taxes to be Paid Bonds $4,740,000 $2,917,672 $20,000 Total Payment $7,677,672 $7,677,672 $885 $0 $164,436 $7,512,351 Total required for 2002 debt service Amount (if any) paid from funds listed in Schedule A Amount (if any) paid from other resources - Excess collections last year Total to be paid from taxes in 2002 + Amount added in anticipation that the unit will collect only 99_00% of its taxes in 2002 Total debtle,)' $75,882 $7,588,233 This notice contains a swnmary of actual effective and rollback tax rates' calculations. You can inspect a copy of the full calculations at Town Center, 255 Parlrnay Blvd" CoppelL Name of person preparing this notice: Stephanie Tumlison, RTA Title: Revenue Collection Manager Date prepared: July 25, 2002 Notice of Public Hearing on Tax Increase The City of Coppell will hold a public hearing on a proposal to increase total tax revenues from properties on the tax roll in the preceding year by 3.23 percent. Your individuaf taxes may increase at a greater or lesser rate, or even decrease, depending on the change in the taxable value of your property in relation to the change in taxable value of all other property and the tax rate that is adopted. The public hearing will be held on August 27,2002 at 6:30 PM at Town Center, 255 Parkway Blvd., Cappel!. FOR the proposal: AGAINST the proposal: PRESENT and not voting: ABSENT: The following table compares taxes on an average home in this taxing unit last year to taxes proposed on the average home this year. Again, your individual taxes may be higher or lower, depending on the taxable value of your property. Last Year Average residence homestead value $222,211 General exemptions available $6,666 (amount available on the average homestead, not including senior citizen's or disabled person's exemptions) This Year $227,007 $11 ,350 Average taxable value Tax rate (per $100) Tax $215,545 0.64860 $1,398.02 $215,657 0.64860 $1,398.75 Under this proposal, taxes on the average homestead would increase by SO.73 or 0.05 percent compared with last year's taxes. Comparing tax rates without adjusting for changes in property value, the tax rate would increase by $0.00 per $100 of taxable value or 0.00 percent compared to last year's tax rate. These tax rate figures are not adjusted for changes in the taxable value of property. Notice of Vote on Tax Rate The City of Coppell conducted a public hearing on a proposal to increase the total tax revenues of the City of Coppell from properties on the tax roll in the preceding year by 3.23 percent on August 27, 2002 at 6:30 PM. The City of Coppell is scheduled to vote on the tax rate that will result in that tax increase at a public meeting to be held on September 10, 2002, at 6:30 PM at Town Center, 255 Parkway Blvd., Coppell. ANNUAL BUDGET The City of Coppell Debt Service Fund Revenue Summary Actual FY 02 Budget FY 03 Budget Description 2000-01 Amended Proposed Ad Valorem Tax-Current $ 6,618,328 $ 6,788,600 $ 7,512,351 Ad Valorem Tax-Delinquent 47,410 20,000 20,000 Penalty and Interest 38,927 15,000 15,000 Roll Back Taxes 55,065 0 0 Ad Valorem Tax-Delinq-MUD 558 0 0 Penalty and Interest-MUD 595 0 0 Roll back Taxes - MUD 0 0 0 I nterest Income 102,342 130,000 60,000 Road Assessments 0 0 0 Interest - Assessments 0 0 0 Transfer In 350,000 150,000 150,000 Total Revenue $ 7,213,225 $ 7,103,600 $ 7,757,351 CITY OF COPPELL ANNUAL BUDGET The City of Cappel! Debt Service Fund Expenditure Summary 2000-01 FY 02 Budget FY 03 Budget Description Actual Amended Proposed Filing Expense $ 0 $ 200 $ 0 Interest Expense 3,080,819 2,955,300 3,162,672 Cost of Bond Issue 0 0 0 Agency Fees 9,524 20,000 20,000 Bond Principal 4,150,000 4,255,000 4,740,000 Total Expenditures $ 7,240,343 $ 7,230,500 $ 7,922,672 CITY OF COPPELL ~ :::J "0 Q) ..c () Cf) Q) () C cu :::J CJJ CJJ "0 Q) C 0.0 a. co 0"0 o Q) CJJ o 0 ~g- 00:: 0 0 0 I"- 0 0 0 0 0 0 0 <.0 0 0 0 0 0 0 0 ..-- 0 N 0 0 CO 0 0 0 0 0 0 JJ 0 0 0 0 0 L{) 0 I "1" 0 0 0 0 0 "1" 0 0 0 0 0 c0 CO CO 0 N N 0 C"1 0 N 0 0 0 0 0 CU N 0 0 :::J 9 0 0 u ~ N N <{ 0 "1" '<t 00 0000 00 0 00 0000 00 0 ro 0 00 0000 00 0 :::J 0 - - - - 00 0000 o L{) L{) u en CON C"11"-00 CON CO <{ OJ OJ C"1 CO UJ L{) l"- I"- N L{) 00 0 0 000 0000 0 00 0 0 000 0000 0 00 0 0000 0000 0 (j) - - - - - - - - 00 0 0000 OL{)OO L{) 0 CO N C"1 I"-ONO CONOCO CO 0 OJ C"1 ~L{)OJN.. I"-ON CO N CO tIl - U Q) .0' "'c () a.. Q) .~~ E 2:J0. n... .Q '0 ~ >OQ) :!::O Cl:l.:.:: :;, '- orf. 'C '- c: :::J Cl:l..c tilt ~<{ ... () Cl:l CU a..::?; c Q) E a. o Q3 > Q) o OJCQ)OJC C .Q Q) C .Q 'C u ..c -c: t5 Q):::J:;::Q):::J (]) L.... Q) L.... C(j)CC(j) OJC8,OJC C 0 CU C 0 WO:;::WO "2: ~ (1) 0 EN o...c Ot Cii 0 >z ~ C U E ~ a.> .J::(j) - >. <l:Cf) C cu a:: L.. <l.J en cu CJJ ::?; OJ (i) '- .2 c <l.J a. <l.J cCf) o Q) <l.J CJJ U C '- C C C -> <l.JCOJ 3:<l.J C <l.J '(j) 0 a. <l.J1-<l.J I-~ 0'00 '0<.9 a3c~5co ~Ent5E25 00.<l.J20.~ '- .2 .~ (J) ..Q ~ .~ ~ "2 25 ~ ~ ~8<l:08& en Ocu cu '- wI- c..... 3: 0 C 2.Q co CJJ >, ~ "0_ C x <{w -0 - c (]) 0 2S::en 0-0 o (]) ..... (() o 0 >,0. ~ 0 00:: 0 0 I'-- 0 0 o. 0 0 If'i I LO <.D <.D <.D 0 <.D 0 <.D 0 0 0 0 0 0 , 0 LO 0 0 0 0 0 '<t '<t 0 0 LO 0 0 O. 0 0 0 ~ 0 0 0 0 '<to '<to N N 00 0 0 00 0 0 '<t qq q 0 0 00 0 0 I ("') LO 0 CO ("') 0 I'-- LO '<t. N N LO 00 0 00 0 ("') qq 0 0 00 0 N LOa LO 0 I'-- 0 I'-- ("') LO CO 000 00 0 0 000 00 0 0 CU N 000 00 0 0 ::::l 9 LOOLO 0.0. LO LO 13 ~ NOI'-- NO 0) ~ <t: 0 co ("') ~ co ("') ("') LO 0 00 00 000 0 0 00 00 000 0 ro 0 0 00 00 000 0 ::::l 0 LO 00 00 000 LO 13 I 0) N LOa ("')0 CONCO co <t: 0) 0 ("')'<t (",)N I'-- ("') 000 000 0000 000 000 000 00000 000 000 0000 000 000 000 000 O. a. O. qo.o. qo.o.o. 000 000 000 qo.q en LOOO LOOLO 0000 000 000 000 LO LO LO 0 NLOO NOI'-- LOOLOO NOCO ("')00 CONCO 0) <.D '<t 0 o I'-- LO ~ co ("') '<t 1'--. O. ("') ~ ~ T""" ~ "'1"_ ~ (",)N co <.D ("'). <.D ("') (",)LO N N 0 ("') 'f :.:J .~ (]) ::::l U (]) ..c u (/) (]) u c CU ::::l ({) ({) o .B 13 (]) '0' '- 0.... en (]) ~ m ~ ~- E ~_ *_ g~c ~ c ~c ~c W~c ~~ ~c .- 0 :~__ .- 0 .- 0 en.- 0 (/).- .- 0 ~C~ ~ _ c~ c~ c~ ~c c~ cu..c- CU ..c,- ..c.- o..c-~..c ..c.- OU.~ O'~ u~ u.~ ~U'~::::lU u~ 0::26 0:: 6 26 26 --'26 0::2 26 (])Ou U Ou (]) Ou (/)00 -0 (])>,Ou ~~(])<t: (]) <t: (])<t: ~ (])<t: ~(])<t: (])(]) rnCU(])<t: 0cu0 ~- 0 cu_0 -0 >0 cu~0 (() Q) .--J -- >- C --.J co ~ c - -- >. C C - -- >. C -0 -- >. C "i:: -- C C ....:x: -- >. C .... .0 >, 2? cu _Q .S? ~ Q -0 2? ~ .Q 'm -0 2? ~ .Q cu 2? ~ .Q 0 2?Q 'm ro 2? cu .Q al ~TI'c~U~c>uro'c>n~ro'c>uO'c>n~'cuL~'C~U'_ ~C(])""'::::lc..c""'::::lo(])""'::::lOo(])""'::::lO::(])_::::l(])(])::::lO (])-::::l2 ~CU(])O'-cualo,-O::(])O,-(])O::(])O'-_(])O,-_(]),-(])t(])O'-o.... Q) C/) .~ E en if) .... :c en U5 .~ .:c en :t= w .~ 1: U) 03 .~ 1: en ~ .~ en :t= 8..~ 1: en .... en~~c~o~c..c~~C({)..c~~Co.~~c(])~c~(])~~C(]) ~(])c,-o({)(])-O~c.-o=~c._Oo.c._o(])co=(])c._O(]) ->wO::OCU00::0(])wo::oO(])wo::oowo::O'-wOO,-wo::O~ ~> W en en 0 0 ~ (/) ~ ::J '0 (j) ..c U (j) (j) U c ro ::J </l </l '0 (j) C 0..0 o..ro 0'0 U (j) </l o 0 ,e25- GeL roN ::J9 U..- <(0 roO ::JO 13m <(0) o f'-, o c1> o o (0 o J, o L[) o ..,j. o o o o o o o '<:f" o c0 o o o o L[) o '<:f" o M o N o o o o o L[) 0) N (j) o U o o o o o f'-, o o 0_ L(") f'-, ~ u (j) "e 0... (!) c ro -10 o (j)0 o (j) 00 o '-0.00 o UL[)OO L[) ~M60 ..- 0~L()6 OW 0'0, WL[) o loojgc ,..- CIl ~. -g ~ ~ ~ .~ 2 W t) ~ &. ~ ~ .~ :2: ~ ~ CIlW':'::~WO:gWCL .0' I <V I I = ::J "'Q)~C';'l<?0(j)"8"8 Q..(j)U(')(')C</lOO CIl';:'~ ~~~~ Cl(j)oEE>,OcC: 1ll(j)"Ororo"O"Oo~ .s >, m ~ ~ ffi m :g ::J ~~2U5U5(j)2UI C o o o L[) (0 f'-, N o o o o o '<:f" o o o o o ~. M o o o L[) ..- ..- (0 o o o o L() f'-, co o o o L() M f'-, L[) o o o L() (0 co 0) o o o o M f'-, o ~ _!!! (j) ~ ro c <( V V Q. () g- .2: () v '0 U) ~:g U 0 v ro 15 (,) (5 v2: 1--0~ I'-- 0 o g cD IJ"i o <D >- I'-- lJ.. N W <D 0 o g ,;, ci o 0 >- LL '<t" W U) 0 o 0 ..,;. 0_ o g >- '<t"_ lJ.. C"l w '<t" 0 o 0 r0 O~ o ~ >- lJ.. <D w C"l 0 o 0 N D_ O g >- 1'--_ LL 00 w c v ~ :n u _ v2: ::J 0 <Il () U) ro ro ~ <Il u:: >- (J') ..... ,...... C'I CD "'l:t ~ CJ><DI'--Ol'--<DO ~L()c.-)OO:)Ol{) I'--U)O 0 1000 <D_I'--Nt-~IOIO Nr--:OO> c0 o ,...... 0 or- CO CJ><DNOO 0 r--:OOO>cO I'-- W CJ> <D <D U) C"l OONNN <ri-_crico o N 00 I'-- CJ> -O'>('f')C"')N LOcn~O_C""i CJ>C"l0CJ>0 10 C"l C"l 0 <D <D m <D- <D 0C"l0C"l<D000 o O<DNC"lO .oM 10.0 to '<1'0 CJ>0'<l'1'--<D00CJ> 1'--C"lCJ>_C"l<DCJ>I'-- Nf'-...-CO_CJ>-~""': C"l00 '<1'00 0 '<I' I,{)COf'-...cot'--_O> <O'<t"'<t"c0C"lc0 C"lu)OOOOOCO <DNOOIOU)ION tri-<DNNNO O>LOL()-_CDN Ol-.;t'-_CO__C"') cD ..q-- ,- cD a.O 00- CJ>CJ>O<D<D'<I'O CX)('f")_O>L{)C"'),-oo N ~ W ~ ~ '<t" <D I'-- 00 r--:I'-- 000000000 0100100U)0100 Or-....:LONOr-....:uiNO o co....... <.DLO('i')N_O LOl.Oc.ot'--OOO>O N <0 cr>NLOro,-LO I'-- <D <D 10 '<I' '<t" C"l NNNNNNN W 000000000000 l{)OLOOLOOLOOLOOlC)O I'-- .0 N 0 I'-- .0 N 0 ~ .0 N .0 ~~~~~~o;~~b_~~ '<I'I'--OC"l <DCJ>N <OcON<om oOCJ>COI'--I'--<DIOIO'<I'~ NN ,- .,...,- N '<1'- w 00 N N N N N 00000 OLOOIOQ o N .n I'-- 0 LO r-- ("') 0 r-....ON...LOCO CJ>oooo CJ> CJ> 00 I'-- <D C"'1 ('"") ('f') ("") ('f') w 00000 L() 0 l{) 0 l.() N.n~ON to N en LO _ 0C"l 10 00 0000000000 0100100100U)01O IOI'--0N.n~ON.o~ I'--C"lO<DNOOIO I'--C"l N~~~;;;~~-~~:-~- o (J) 00 I'-- <D 10 '<I' C"l N C"l N N N N N N N N N ~ 10 '<t" C"l N C"l C"l C"l C"l C"l 00000000 00000000 00000000 0100100100U) C C"l I'-- 0 '<t"_ I'-- '<t" C'"JIOI'--ON'<t"r--:o> N 00(J)001'--<D C"l C"l C"l C"l N N N N EFJ o 0 o 0 o 0 o 10 00 o 0 000 0 0 0 0 0 000 0 0 0 0 ~ 0 0 0000000000 o 10 0 10 0 U) 0 U) 0 10 10 00 N 10 CJ> N <D (J) C"l <D <DcO C"l<OOOONU)-r--: VC"')(")N_OOo>cor-- NNNNNNN,- ~ .f <D 10 N N o ("f) L{) CO 0 ('f) LO CO 0 ('f') lO 00 0 (") L() CO 0 C"") L() ex:> l.O t'--("")O<.DNCOLO t-("")OCDNCOl{) t'---(W') f"-..r0COVOLO <DNCOMO>LOOc.o t'--e0COV ("")'VVU1<D<O,......,......COCCOlmo N('\J(")("')<q" <D<D<D~~<D~<D~<D<D~I'--I'--I'--I'--I'--I'--I'--I'-- LONm<DC"')or--v COa.ONO>C'O("')O,......~ ro <D1OC"lN OOOI'--<D'<t"C"lNO(J)OOI'--IO'<I'C"l~ 10 10 10 10 10 10 '<t" '<t" '<t" '<t" '<t" '<t" '<t" C"l C"l C"l C"l C"l C"l C"l W 00000000000000000000 00000000000000000000 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00000000000000000000 10 0 U) 0 10 0 10 0_ 10 0 10 0_ 10 0 10 0 10 0 10 0 I'--ONIOI'--ONIOr--:ONIOr--:ON<OI'--ON<O COf'-L{)("") OCO(()VC"'1 mr--c.oVNomr-LO I'-- I'-- I'-- I'-- I'-- I'-- <D <D <D <D <D 10 10 10 10 10 10 '<t" '<t" '<I' w (J) '<I' I'-- CJ> <D N ,- L() CD I'-- 10 <D <D_ N 10 NO.f o (J) <D (J)_ 00 00 I'-- I'-- I'-- W (J) 00 0 to 0 10 10 10 <D <D 0101000 000 r-....Li),......LO LO,......NLOLOL.()OOO C'0NCOf"-..,- r---CO_r-....:N r---.:o 00 VNC'J(J)CX)(J)COO'>NL()('o"')L{)I,{}L.() NO'>("")Q)-_O'><DcnNI'-mQ ,......,...... C'0cr><Dl.(),-WC'0r-:,......(")-ov 0 V CO CO 0 V ..-- ,...... L() CD ,...... ,...... V ~~:-~~~'<t"-~~~ '<t" 00 10 00 N 0; U; I'-- 1'--- 10 N- N C"l'<t"1O<D1'--00(J)0 0000000 Nr0...tJ,<.b~ooo, 00000000 -NC'0""=t"L.()<.Dt--.-como ,- --- N o I Nc0..J.J,c.br-!.-cOo1 ~ ~ ~ NC"l'<l'IO<D1'-- 6';J~~~~~ NNNNNNN o o .0 I'-- CO '<t"- '<I' <D w o o o o 10 m o o 10 W o 00 00 00 c0 '<t" 00 00- w o o o o o <0 N '<1'_ N ~ W CO '<I' o lO_ t:: 10 CO W '" in 0>- n; c: .~ <( '" '" i& _ <C x ~ .~ ~ o ~ C 0", '" _(1)(6 o ~ > ~ ~ "g. oow ~ E ~ ~.gl') '" -0 -0 c: '" '" 0 ro-rom erg ~ x '" z ~~5 ~ '" '" 10 i5 ~ .e .~ I- 0: :::R Q) 5 ID :g .~ :il'1ii :J CD.....~ '" ro1)O o ",.iE. I- 0 '" en '" is 15 ~ :; ",iE. '" 0 '" 0: en 1OLOU) Ll)M...-M "lfMtDLOO>"f'tO Or---LOa>...-OlO ...-~tn.~ll'i<D<<'--;;; t:. ~_ ~_ 8. ~_ ~. ~ ..... ........- ...... ..... .15 .E~ ~ ~ Oz 'V1.O<D (OtJl("') COCO<DO'l'V Mf'-.. IDMOolr'cOt.ri ~N~_~_~.R~ ~.g~:g&j~~ "".. N. N. <'\I.. N.. N.. N.. ...... ...... ..... ...... ...- ..- ..... a ~ '" c: :J '" n; a. > '" t'-- t'-- t'-- M N 000> ~~ ...- '" t'-- N t--:M co 0 M ...- "-(oNCDCD roU10v"- M..-lOr--.m mWM '0. ..- M U'),...... m v'o:t""'ltvv coc.o N<:n(QN!"- CONMQCOovOlM coO) mLO-.;tN ~~~Mg~~~~ 000000000 600000066 l.(')("')t.OlOO m 0 CD 1.0 m ~~~~~ co f'-.. f.O "I:t 0 acacia ~:g;1;~~~ rococot-..r--.r--- uiriN(")(()- . f'-..Nt--NI'-M '1"'"". N.. N. M_ M. 'V. .,.... ..- ...-..- ..- co co <0 m m <0 ~ 0) 0 m m C') t'--. N ~ NN"'" co coco N..N..N.. o "ltOO"'d' 0 ~tDCOVI.OU') <oct N M 0 m<DOO om ll') co (X) f"-. ro ~ggco~'~ N.. N. N.. ~ N.. N.. ..... ..- ...... ..... ...... OlNr---.mmcoLO 1.0 N<D co OJ tDM O(OI/)CJlmc.o...... maicioti - . 'V' CO"lt..-r--oo:r OJ 'V. LO. (0. to. r--. ~ ~ ~~~~~ u)MNNO O'lM"l;f"N MlOM<'?N r--: N r--: <D ai 00 OlM("")OO N..N 'V 'V 0> C') N '" NON vOMCO VMNN.. - c.ci w l.O r---. en N l(') (0(0"""''''''' Nt'-- Nt'-- '" 0 t'-- co<o'" 00 o 0 ~ 660 NMf'..COMmt--vVVO>NvOQ ~~~8~:~N~~~~~gg mf'..(O(Olt)I.OLOvNN 000 oaooooaooooooo~ 666666666666000 1.0 OlNOOlm co """"t--M ;:~~~g~;::;~~~ lli"":.nccicciv-m-N"r--:<.D C"'lt--t--MID......MT"""......V mOlON......woo......t--m a:iOC'O~McDlli....:"OlO-M ("') ...... t-- M 0 00 c.o l[) l[) l.Ot--mONvll)t--m...... MM-M-~~~~~v-1I"i m...- t'-- m <0 N ..0 w t'-- '" <0 <0 N '" N- 0 ~ om<o m co co ,..:,..:,..: ~0g:1.O~;r; Wc:iMNOOt--. ~.;:;;~N~~&i M-mwu) ml.O-q- cooo T"""t--comvN r-..: Lli l[)- ~ v--.i NO 00 go ",on (IJ <'J 'c ,... "'''; en.,. NOlOlOOOO '<Tlt')~NOU')O 0""': wll'i"":ui ~~r;:;~m~~~N r--:mOOl!) (1) 0 <'JM't't~~'<t :t "f "f "f , , "f OOlflOI.()OOlflOlflOOON OONU1t--.OONOt-OOOv uilri(OJ'-..cooo ocooooui t--.lOi'!~_;!I'--O~_~;r;~~"~"~ com-co romcor--o O"lf" "t"tMM"tMC'1MC"1"t"t'l:f"lf"(J') "" "" "" "" "" "" "" "" "" "" "f "" "" i'- ro '" T-otD..-m<or-- VU1l"-lOOoo...- NIDcommJ'-..<O 0-0 "M<O-O-lO- ...-MLOr--mNv UllOU')I.()U')(Ol.O w ~ "''''- N N 00 6 0 ooJ'-..NlO N r--oot--.f'- MMv<Ooo ~~N~mm 000000 ooc:i60ci f'-LOm(j)lO vON<Doo 01 .... v 0> V M- o:i co- r--: M 000000<0 ..-lOvMU1 o -.i r-..: 0) 0- <or--mNt--.N C"'lU')f'--.ONLO l()- ..0 ..0 <0- l.O- f..Ci co '" 0 co N '" m 00 ~ ffi.<o ~<OM g ~ := -.i~~ U1l()00 t--."!lOlO cO r--: N co m N l.() mNt--m "':"':MO f"--1,{)c..Dt-- l.OOO..- C""i M M- N 00 00 go ",on ",<0 -c: co "'a> en.,. 000000000000 1.()l.()l.()l.f)l.f)l.()l.()lOlOLO~l.() r....:r....:.....:r....:r....:r....:Nr....:r....:NNN MCOMCOOClM(OMMtDN mNNt--U')wmot--oN..t-- o)oir-.:<<io::icDMu1-.io::ivo:i I.l) I.l) I.l) lO l.O l.() l() l() I.l) U') I,() I.() CX)CX)CX)COCX)CX)COOClCOCOoooo 000000 000000 66ci666 lO(()NOOO <O_LO ooom LOLOocio:ioiM LOU')U')l()I.()(Q 00 co co 00 00 co ~~~~l()~ ~6r....:Mr....:cO l.D 'I:t I.() t-- 0 v 00_ t-- 0 l.() v"":<.DN-r.L;"': om<oml.()v <OU')l.()CX)vM cD<D<O-u1~-.i l.O (")U')l()U')U')lt')0 aNa NNr--NNl.O ~~:;3gw~~~~~ t--._lt')~(")vco <.0<0 LOOOM--q--c--i-.iNr.DLO- Nmmol.()..-OOw<ot-... lO.......momco(")t--t--co MMNM-NNN~..-- 13 ro '" '" u:>- M-ql()l.Dl"-roO) 0 9900009 NM..}u1c.b~ooo\O 00000000 ;;: M ~ N '" <0 NMII"i co '" C') t'-- 0 C') cr) ,..: ,.......,. 00 '" 0 0 "":00 C') '" '" o t'--. v- ,..: I'- ..,. '" N"": o co 0...- ~o t--_ l.(). v~;::' ...- ..,. .,; <0 '" o o 6 ...- N <Ii M ...- u1 ;;; <0 0 I'- 0 co6 o t'-- '" M t'-- ...- co N <0 o m t'-- m_ o ...- m ci <0 '" NMvL(')lOr--oomo N NM..J.J,cb~rod:~~ ~ N N '" .<Jj >- lii C .~ <( '" ., ~rn ~ n:: _ -0:: " ~.~ ~ 8 ~ ~ _(J)m o _ > ~ -g "g. uOW .;g E ~ c .g 0 ~ (5 '" 1::> ., -g g mmeD n:: '(3 ~ >< ~ ~ ~~,s ~ * C n:: ~ ., I;j .E ~ I- U ~~2 '" '" ~~~ lDl-> ., ~ ~ .~ I- 0 ., (/J "'0 00 go '" 0 ., 0 'C .... "M (/J.. ....0 00 go '" on .~ ;: ., u;j (/J.. M 0 00 go '" 0 ., '" -c .... .,u;j (/J.. co ., ~ ~ .~ :J 0 ., U (/J 1'i Ci; '" ., u:>- li)li)<DLO g~:g~ .,..: lli,....- Iii ......l.()O)O "'. ~ ""': o. M~M ~g:g co- OC)"....: ....co..., o. o. "-. U')(O"ltcomcomC\lt-- NmLOw......OOLONtO rocoCOt--t-..,....OCOlO cDMNM<D~cr;a:ici ,..... C\l ,..... N ,.... ("') co .q- ...-_~"'!.M_M_~V_lO_(o_ 0> 0> co ex:> 0> 0> ~......- ........ <0_ 1"-_ CO'" <OM <0_ i 00. ~ o ex:> '" CO air--: '" M 0> 0 - <,j <ONa> a>......., M ..., m-..q: N ;:ggJ NNN s U; o 0 I-U ~~~~~~~~mLO~remm~~8~o~~~~~~ ~~~~~~~~~~U')~~~~6~~N~~~ "ltO ~~~~~~~:~~~~~~~~lD~OOM6~~~v~ ~~~~Na:iricilli~~~~MN~<D.....:a:iMN~lliMri cowom~t--Nt--......lDali)CJ)"ltmM(oMNt--comLOC'Ov NO<OOONvVMMNN......oammCOCOmOOMCOli)(") ~NNNMMriMMMMriririNNNN....:....:....: ~1i O>~ '0 C en ~ o :J UU ...."'<0 OOCXJ:cocn cnMooi NNMOCl CO COM ~-gi:8 ~~N..N.. 000 '" '" '" M N N a> M.... '" M M N r-- <D 0>..., M N........v ro 1.O C') CO V ("') t'-- en ,...: a> Ll) V ~~~~~ NN N CO 00 CO 00 N. ~ ~ N.. co<Oo 0> <0 co cri 0 -.:r= 0> M a> N ex:> '" N...fai CO CO .... N..N..N.. "'t"OO"ttOID <OOOvLOLOLO N MO III tOo::) om rom,...... COM wci...--..;r:N"r-: co co 0000 ro co N..NN..N..N..N .........- .,... ..- -" .E~ ~ ~ U~ gM~~N~~~m ~oo;Dli)~~:g~ CONCOOO mtO'II:t_ m-N"":m-cD~.-t--.-M j:::~w~~~:~8 ....:....:....: N N- N N CO co CO MMMOO(!) u)o~og '" ........ tJ)-LliMMO OlU'){{)vl'- COU')("")..-N <D M .. ~ ~ ~~~ 0>.... .... ai...jcir.ri f'- N r--..- m~ 0>_ co. 00_ 0> '" ....0 ,..: a> (DMO{O I'--:Mm...... ;:Lrio:iN N~;:~ N r---: n- m" <D 0 I.() m f'-._ 1"--_ <<>_ l(') ...... ..-- ..- ...- v 0,........,.. 0"" .... <<icriM<O N r-- M (X) Ncnr---"l:t tJ)~ ci (D- N -q-O'lMCO U') ~ 'V_ ~ '0 ~ ., C :J ., lii a. > '" .... .... .... M N rom ....<0 ..., M .... '" ....N f"-."rri CO 0 M .... ...-CON{O(O co I,() 0...... v M....Wr--_<DN en r.ti ~J- ci ci ,.... M L() r--. m V"lf"vvvlO 0<0 '" .... <0 co o M '" '" '" ~ a> '" 0 0> 0> M c.o~ .... 0> '" '" <0 .... N CO .... r-- co ~ ciu-.i N........ "" <0 <0 ON NNa:> OM co m...-oo MNN"lt"ml[) OOIDlO-..o<rim O>NU')(O..--'V <Dr---r--r---coco N '" I"- '" 0> MOO ~ m gN~~R~~::g~~~~~~ gN~~~g~~:~~~~~ o~oooooooO:O:ooo 00000000000006 M '" '" <0 .... '" N N 00 ci 6 COQMOr--OOOV NNMNOiJ")("') <D co LOOWOlU") lO MNomr--O(()v NNN 000 0000:00000 000006666 <0 N .... M 0 '" '" ex:> .... 0 ~N~ 606 <0 N 0> ll)r--mt- L{)....... 0 M CD to co....... t-- M N 0 6660 <J)L{)VMtJ) mmOll)vNr--aoooo :~~~~~~~~~~~~ggggg O)roCOr--r--WU')vMMNOOOOOOO 000<=':00000000<=':00000 ciciciocio66666cio6cicioo WO>NOm ......L{)U')f"-.O r---oovvo ..n~uia:iai M,.....,.....("')(() mOLON_ 00.0- c.O M- lCi ...... ("') ..-- ,..... M I.{) ,.... maN M-M-ri~.j 0> co N .... M ~ai W ~ on o co ....'" ...j...j ~ ......., 0> 0 0 co .... ~ N r--: (L) ~~.... ~ .... 0> Lri..o M" <0 '" '" .... 0> ~ ..j ott:t: U')- I'- 1.0 m <D VONCD m ....... "If" m M- cO 00 ,...... OOCOco ..-- U') V M c:i~r--:a) to f'- m N M\{)f'--.O u-.iLliLlitei l.OV-l.Ov CON<DN "'It" 0 ~...-. M- u:i (OCO'Ol;fM l,{)MNI,/') ci"':NM """NCOl(') N U') r-- 0 CD- <D <D 1"-.: 0> -q- ~ -q- 'V <D<DMc.o..- M C\!. N r- ..- Nmririm I'-mWMm IDO.N<D<D ~~~~~ M CD m N 1.0 1'-- ,....: ,....: cO oj 0> N .... <0 0.... 1'-- \i"i <0 <0 a> a> '" N co 0> N cOm N ~;1;~~:e;bom~~~~g U)(",)ocOOlll<D <DOOlll ~~.~R~~:;;~~~~.~~ ~r::g~~ID~~~-~go;8-N- tnWNOOI'-COQI.OMM 01.0 ,....: oj m- cO ,....: 1'-. ,....: w w <D ID- <<i I.() M 0 o M'" 0.... M 0> ""':ai M co co .... .q-" ..q' MCDCOO("")I.O <DNMQ~N I.OtDvOlJ") I'-CDcomcnlJ") MCDcnt--.~v oi ,....: ,....: CD- VcoO-q-mOl 00 I'-,..-cnCO,M ri M M- -.-: cooo co '" '" to N N '" ex:> 'V. <D' 0<0<0 0> "'..., oco '" N NO <0 N M ",u;j ....0 ex:> N ;;; ....0 00 go ",on .!! ~ v N (/J.. 00000 OLOOIOO Or--.:lriNO OCOl'-tDU1 I,()l{) CD I'-CO <IimN-U)-a5 I'-IDtDU1v NNNNN ... 00000 OlOOlJ)O Or---:U"iNl.O OCOI'-WN mm~ (f) triaiNllic6 to l() l,() V ~ ;h 00 "'0 ....on M N a>.o on .... M N N 00 '" 0 NO ;:~ <D NN NN 00 '" 0 ....on co.... N ..., .q-" 1'-- ~ 0 N N 00000 lJ")0U1~1.() Nor---:lON <DlOMN 'V l() to_ 1'-. 00 o"~-itDmN OOlOOt--'" N ..- ..- ..- ..- <0 0 00 go ",0 .!! 0 ~;i o 0 a 0 o 1.0 a l.O ONU"ir--.: '" .... M I'- 0 N 1.0 oicido" en en (() I'- M M M M .. '" .... M ..., 000000 0lJ")0U101.O o NlOr---:OC"\i OWNCOI,();: ciOM,I.OCON, <0 M o o on .... M N MN..-O M M M M 00 '" 0 ,....: 6 M 0 <0 0> f'iN 0> co N N 0000 1.0 0 l() 0 Nlri""':6 <DNCOI.O ....<00> C""i ri ri ri I'-<DLOv NNNN 000 '" 0 '" N lJ")""': .... M N........ 'V' <<::I; v- M N ~ NNN o o on .... ex:> ... .... u;j .. 0000000 0000000 6006066 OLOOlOOlOO OMI'-.ovt- M-trit-Of'iv"'r---" ~Mg~~~~ .. 0000 0000 0666 lOOI,()Q :co~:d to to lO 'V N N N N 00 00 00 '" 0 co N co- M M NN 00 00 66 '" 0 '" 0> Mon N ~ N N 00000 00000 60000 LOOlOOlO NtO_OlMW a:i 0 N lli t--' oomeol'- N N o o o o '" u;j o o on .. O(")I,()COOM 1.0 t- M a (() ,....: M cO -q: 0 u? ("')'V'VL{)CDCD (() <.0 <D W <.0, tD I.() N m w" M c:i to L() M N..- 0 1.0101,()l{)LOLO .. lO co 0 M ~eo~ cD N eo 1'-1'-0000 tD. to <0_ to f'-..~ ro ool'-<O..q 'VV'V'V lOCOOM f'-..MOm McnU"iO 0>0>0 co, to t-- f'-: lONO><O MNOO> vv":t"n '" co N co <.0 t:. ~ MO co.... M M o M l{) co '" .... M r--: n cO v N M M v I'- f'-.._ t-- 1"-_ ""':":t" co ~ ~ g M o ex:> cO co M '" co <D .. 000 000 000 000 I,()O~ t--."ciN "'....'" .... .... .... .. 000 000 600 000 0'" 0 LOf'-..O M~O .... .... .... 00 00 60 00 "'.0 Non co <0 <0 <0 00000 o~ooo 00000 00000 lO 0, l() 0 I,() ",- 0 N ll-i t--." ~~o;mro 00 00 00 00 0_ '" ON :g" 00 00 00 00 0'" u-i""': NO '" '" 000 o ~ 0 600 000 o lO_ 0 ciNll-i 0>....'" .... '" .... o o o o o '" N .... N .. ~~~~D r::~~:g~ (() N I,() l.l) l.l) ~gia;-:;;' mcoro..-I'- ,...: t--." t--- t--- an .. <0 .... '" M N N ~ M'm. ....~ <0 '" lli~ ~~~~ ~~a;co M en ..-_ 0>. g::gC;~ "l:t N M N v"'.q-" "'tI:-.:i OlOlOOO LOf'-..~lJ)U')LO t;;~m~~~ IDOlNf'-..mo ri r---" ,....: M' c:i ~ ;:to~~~r-- ..j M M' M N 000 OO~ 060 '" '" '" .... ..... o .... .... ex:> "', o '" ;::. ,..: ........ '" .... N~ '" co .. M..qI.()(()t-rornO"-NM'VlOIDf'-..COcno NM'VLOWr--- ~~~~~~~~O"-NM~~W~OO~~~~~J~~ 00000000 NNNNNNN City of Coppell FY 2002-03 Budget Changes made since July 1, 2002 I Department Revenues Revenues Police Police Library Overall Expenditures Traffic Police Amount Description 92,000 TIF Grant - Library (121,000) Lowering of Lease Proceeds on Tahoes (21,000) Lowering of Lease Payments on Tahoes (31,382) Equipment for Tahoes 101,200 Computer Equipment - TIF Grant (91,480) Insurance, Health, L TD & Life 75,000 Battery Backup 1/2 Replaced Victims Assistance with Patrol Officer 3,338 ANNUAL BUDGET City of Coppell General Fund Revenue Summary Actual FY 02 Budget FY 03 Budget Description 2000-01 Amended Proposed Ad Valorem - Current $ 12,320,371 $ 14,095,933 $ 15,083,228 Ad Valorem Delinquent 87,746 53,000 75,000 Penalty and Interest 70,608 30,000 50,000 Roll Back Tax 95,617 15,925 0 Prop.Tax Collection Service 0 0 20,000 Total Property Tax 12,574,342 14,194,858 15,228,228 Transmission Line Fee 51,626 51,176 51,000 Franchise - Electric 1,444,098 1,435,000 1,600,000 Franchise - Telephone 125,333 160,000 160,000 Franchise - Gas 371,052 200,000 160,000 Franchise - Solid Waste 326,079 325,000 325,000 Franchise - Cable 227,016 22'1,000 210,000 Total Franchise Tax 2,545,204 2,398,176 2,506,000 W/S Reimbursement 2,804,150 3,000,000 3,000,000 Sales Tax 4,720,485 3,485,000 3,535,000 Municipal Court Fines 1,513,984 1,300,500 1,102,000 Recreational Fees 906,808 950,000 1,053,500 Building Permits 731,823 400,000 300,000 Zoning/Subdivision Fees 38,733 36,000 30,000 Street Lighting/Sign Fees 8,347 1 ~j,OOO 15,000 Contractor Registration 27,235 25,000 25,000 Street Cut Fees 10,900 15,000 15,000 Library Fees 26,816 25,000 25,000 Health Permits 18,110 20,000 20,000 Licenses 33.400 34,000 34,000 Alarm Permits 31,010 20,000 25,000 Animal Control 24,780 20,000 25,000 Construction Fees 308,565 254,500 200,000 Total Fees and Permits $ 2,166,527 $ 1,814,500 $ 1,767,500 CITY OF COPPELL ANNUAL BUDGET - 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 (18,642) 80,000 0 Commercial Roll-Off 109,262 80,000 90,000 Interest Income 767,895 450,000 200,000 Miscellaneous Income 104,696 15,000 15,000 Grant Revenue 0 0 92,000 Claims/Damage Reimbursement 18,842 5,057 0 Lease Proceeds 49,169 20,998 464,000 Lease Revenue 0 13,918 15,000 Transfer In 615,375 0 0 Sale of City Property 38,201 0 0 Prior Year NE/R 41,396 0 0 Over (Short) (623) 500 0 Total Other Revenue 2,228,054 1,129,309 1,363,880 Total Revenue $ 28,552,746 $ 27,322,343 $ 28,502,608 CITY OF COPPELL ANNUAL BUDGET The City of Coppell General Fund Expenditure Summary Actual 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 567,063 Legal Services 356,329 300,000 300,000 Community Information Services 116,429 140,989 146,343 Finance 526,539 581,703 642,449 Tax Collections 195,876 195,138 187,485 Combined Services 2,908,927 2,904,655 1,908,765 * Human Resources 762,333 853,078 830,919 Purchasing 122,422 141,868 145,509 City Secretary 194,047 210,104 220,714 Records Management 125,531 153,868 151,690 Information Services 4,530 0 0 Information Systems 1,378,965 1,362,365 1,210,741 Total General Government 7,394,936 7569,771 6,509,743 Fire 4,838,308 4,992,303 5,330,910 Emergency Management 8,844 102,419 90,350 Building Inspections 382,948 404,643 389,050 Environmental Health 331,839 372,276 383,431 Municipal Court 716,555 749,745 772,649 Police 4,928,542 5,746,959 5,946,330 Total Public Safety 11,207,036 12,368,345 12,912,720 Engineering 586,458 734,451 817,431 Facilities Management 965,247 :356,607 783,229 Streets 1,007,297 998,816 627,054 Fleet Services 619,129 ~)68,315 625,581 Traffic Control 610,692 1346,506 761,736 Planning and Zoning 335,490 425,402 375,520 Total Public Works 4,124,313 4,230,097 3,990,551 Library 1,211,588 1,193,603 1,550,237 Leisure Services 3,611,609 3,553,330 4,367,610 Total Cultural/Recreational 4,823,197 4,746,933 5,917,847 Total Expenditures $ 27,549,482 $ 28,915,146 $ 29,330,861 Includes $945,000 IMF Transfer CITY OF COPPELL City of Coppell Walkforward of Fund Balance General Fund Beginning Fund Balance 10-01-01 $ 11,718,467 Add: Budgeted Revenues FY 02 27,322,343 Less: Budgeted Expenditures FY 02 28,915,146 Budgeted Fund Balance 09-30-02 10,125,664 Add: Budgeted Revenues FY 03 28,502,608 Less: Budgeted Expenditures FY 03 29,330,861 Budgeted Fund Balance 09-30-03 9,297,411 Fund Balance: 10% Reserve of FY 03 Budget 2,933,086 Designated for E911 537,690 Designated for One Time Sales Tax Payments 855,489 Designated for SH 121 400,000 Designated for Tax Stabilization 3,000,000 Unreserved, Undesignated 1,571,146 Projected Fund Balance 09-30-03 $ 9,297,411 a ;F- a ;F- CD a <F- ;F- u; co r- a a r- a a N a I") a ~ r- a a I") u; a a '" a a '" co N a ~ ..,. a a N <D a a <D r- r- ..,. ci c:i <ri c:i <ri -<i '" M r-- ..,.- ci <D ci M ..,.- ci ..,. ... I") '" a r- a I") '" ... ..,. a <D I") N ..,. N I") a_ I")_ <D co co I") a 1")' <h M ;;; M <ri co- ... a r- I") I") ... N a ... ..,. ... ..,. <F- a ;F- '" N :oR :oR :; r- r- a a r- r- ..,. N 0 r- a I") 0::> ~ '" 0 0 r- ..,.-0 a ..,. 0::> a '" a N '" ~ ..,. a a r- N N a '" r- N N 1")_ ci <ri c:i '" lli ai r-- M 1")- ci r-- ci lli '" ;; '" ..,. ..,. r- '" 0::> a a ..,. <D N N a I") '" I") r- r- a '" N N N "" a <D' ... ci cri ;;:; ai ",- ... N I") N ... '" ... 1")' ... <D ;f!. a ;f!. '" '" ;f!. ;f!. r- <D N a a N "" <D 0::> r- a I") r- '" a a r- N '" a a '" <D '" <D r- '" N ..,. 0::>, a a N co I") a a I") a r- N_ ..,. ",' N <ri ;: <ri '" ",- cri cri ci r- <D <ri N ;; I") ..,. '" <D co a a co a a "" a "" <D a, '" ~, r- r- "" a ci ... ",' <ri <ri 0::>' ... N "" N N ;;:; ... r- ... 6 ... '" ;f!. a ;f!. ..,. <D :oR ;f!. '" <D 0::> 0::> a I") u; u; N u; 0 a a I") N ~ '" a r- '" a a a '" r- 0::> '" N ..,. ~ r- a "" N <D '" a "" co "" <D '" 0::>' N a ",' <ri ai cO "" N r--: ",' cO ci r-' N '" "" "" ..,. "" '" ..,. ... a <D ..,. I") '" N N a I") '" I") ci '" <D '" r- I") r- '" a cO ... ... co CD- '" r-- r-' ... N N N N V> '" V> 6 V> 0::> ;f!. a ;f!. ~ '" <F- ;f!. ..,. r- I") '" a CD a a N '" '" co ~ a r- a '" r- ..,. '" '" ..,. a a 0::> 0::> r- 0::> CD '" a en_ r- "" "" r- <D '" N_ r--: N '" '" ",' c:i ai N "" N' ..,. ci ",' 6 ci N "" I") <D ~ '" ..,. N <D '" a I") 0::> a I") ", "" c:i "" <D N '" N I") a N V> V> r--: '" I") 0::> r-- r-' ... N '" N N N ... N V> 6 V> '" ;f!. a ;f!. '" ..,. ;f!. ;f!. a ..,. <D I") a I") <D <D "" N " r- I") N ..,. r- 0::> '" ..,. N '" r- N ..,. 0::> 0::> '" 0::> I") <D r- ..,. N r- a ", "- N "" <D '" '" .,-; 1")' C"i '" 6 N ",' a '" 6 ci cO ;; "" a <D '" '" ..,. '" 0::> <D ..,. ..,. a "" '" N c:i '" I") '" N N '" a :; ... V> 0::> 6 '" r- r-' r--: V> 0 N N N N V> 0 '" V> N' 0 () () G a ;f!. '" ;f!. '" "" <F- ;f!. a <D <D co a co ill ;; '" <0 0::> ;;:; '" a a I") ..,. 0::> ~ '" <D '" co I") '" '" en en en Q () en CD "" 0::> r- <D '" a r- '" N '" <D ~ a, N N ..,.- .,-; -<i '" '" <ri ai <D N cD ..,. '" ci ui en- ui :; ",,' ui a -::J a "" '" a '" '" ... '" <D I") a <D ..,. ;: " I") a N ill N c:i "" 0::> C') N r- en N "" '" '" 'I'- a <ri ... ... '" ",- I") I") r-- N ci <D <D V> --------- N co N N ;,; V> '" V> N' ... a ;f!. '" ;f!. I") '" ;f!. ;f!. "" a <D co a r- '" "" "" r- I") N '" r- <D N ~ I") C') co r- '" co a r- "" r- <D '" ~ a '" N '" ~ ..,. N a 0::> '" 0::> '" " a "" 0> '" '^ 6 I") '" ci ;:: ai ci ..,. r-' '" co- co' ui "., ,,- <D' r--: 0 Q 0> I") 0> N 0> r- '" r- "" N 0::> <D "" 0> '" N c:i "', co r- ... <D <D , 0> r- ... <h ci <D <ri ri ..,.- Lti Lti ... \""I N V> ~ N V> 0 0 N V> - 7- J \.L \.-:- (f) 15 (f) 0 ill UJ Z 0 a: ::J 0 (f) 0 0 (f) ::J u.. ::J UJ UJ Z UJ UJ I- UJ UJ ::2: ;f!. I- a: ::J I- ::J is a a a Z ~ (f) ::J (f) u- :2 z z :> :> -2 a UJ I- a: -' 0 UJ UJ a: UJ (f) UJ (f) a: ro i= (f) UJ ~ is UJ UJ ~ UJ C) a > (L UJ (f) >- ::J UJ >< Z UJ UJ u.. a: ~ (i) z (f) ~ ill (L a I- z Z 0:: UJ a (f) u a: UJ UJ UJ -' UJ 0 UJ UJ (f) ::J W w :5 I- i= l- e (f) >- (f) (L Z <J) u.. Z W > (L Z I- Z Z 0 0 0 CD a CD E cu a ~ a ~ ::2: a ~ UJ a ::J I- UJ >< <{ is w C) z <{ z z UJ UJ UJ g ro (f) -' i= l- I- 0 u- ~ a: UJ a: C) i.ii ::J CD ::J ::J 0 CD UJ a: (L a: UJ a: I- z u.. u.. (3 0 0 <{ <{ z z w 0 0 a: UJ u.i UJ a 0 u.i 0 15 '0 a ::2: a a: ::J a a: UJ ::J a g <fJ UJ 0 (L 0 z UJ UJ a: OJ e ~ UJ ~ UJ -' ~ a :> z z z u.. Z >< a a ~ ::J a a a z 0 :J Z (L Z u.. ::J ::J (f) Z Z (L u.. u.. ;; 0:: a <{ UJ u- :> :> -' <{ .9 f- a f- (f) I- a -' u.. u.. i= z :5 w 0:: ::s -' '0 Z Z z i= u.. UJ ~ UJ -' -' -' ~ -' -' > W ~ 0:: a: <{ ~ a ill UJ 0:: UJ Z UJ UJ 0 I- <fJ <{ ~ ~ <{ <{ <{ <{ 0:: <fJ W UJ <{ U a ro a w a UJ -' 0 a <{ w l- I- a: l- f- I- CD UJ W (f) (f) CD a e N CD UJ W 0 0: a 0:: 0 Z UJ Ol a: CD a: i= ~ a: -' ::J 0:: Z CD UJ UJ UJ u.. 0 (f) f- I- 0 <{ Z ci w ::2: UJ w -' w W I- Z Z (L <{ f- W Z I- CD CD Z '" -ii; U -' g :;; Z Z W OJ (L ::J (L (L a ;; C) 0 UJ w a u ::J a: ::J W W ::J L;: C) II> 0 c.. Z I- a l? C) U- 0 0 u.. City of Coppell Unfunded Projects FY 2002-03 Parking cover Additional funding for the Tennis Center Fire Apparatus Battery Backup for Traffic Signals e-Gov Initiative Gis Technician No additional crews Streets and Parks (6 maintenance worker positions) Old Coppel1 Mass Transit Stann water Drainage Grant Matching Funds * Funded from Bonds $ 114,000 125,000 * 800,000 75,000 51 ,000 60,000 200,000 ?? ?? ?? ?? $ 1,425,000 1. 2. 3. 4_ - THE-CITY-OF COPPELL 4L~~~'~ * ~:'~~4Z r~\.*..~.\l ~;r-~~ q -\' -'\ S . \ I'> PRIORITY PROJECTS FOR FY 2002 TO BE FUNDED Covered Structure @ Service Center Battery Backup for Traffic Lights Library Shelving e-GOY TOTAL $113,000 75,000 40,000 51,000 $279,000 255 PARKWAY * P.O BOX 478 * COPPELL TX 75019 * TEL 972/462 01)22 * FAX 972/304 3573 THE.CITY.OF AGENDA REQUEST FORM COPPELL ~~ '* f2.~~ , ;-~. CITY COUNCIL MEETING: July 25,2002 s . ITEM # 10 ITEM CAPTION: Consider Approval of a Change Order to the Texas Unified Constructors contract for the construction of the new Service Center, to add a Covered Equipment Shelter, in an amount not to exceed $113,963.00, and authorizing the City Manager to sign. SUBMITTED BY: Gary Sims TITLE: Director of Parks and Leisure Services STAFF COMMENTS: See Attached Memo BUDGET AMT. $ FINANCIAL COMMENTS: AMT. EST. $ + \-BID $ - ~1R. INITIALS:~M~:FIN. REVIEW:, r1' - Agenda Request Form - Revised 5/00 CITY MANAGER REVIEW: P- =~- -') ~-=:.: .; ~ lDl2.01" :=: ::ig Document Name: "servcen THE.CITY'OF COPPELL -v-~~* ~~-\f /;~() x A oS . \ B PARKS AND LEISURE SERVICES DEPARTMENT CITY COUNCIL AGENDA ITEM Date: July 25, 2002 To: Mayor and City Council From: Gary Sims, Director of Parks and Leisure Services ~ M f~ Re: Consider Approval of a Proposed Change Order to the Contract with Texas Unified Constructors, to allow for the Installation of a Covered Equipment/Materials Storage and Shop for the Parks and Leisure Services Department at the proposed Coppell Service Center, in an Amount not to Exceed $113,963.00. Background: The City Council awarded bid number Q-030 1-02 for the construction of the Coppell Service Center on June 26, 2001. At that meeting, staff was requested to bring back a justification and pricing for the construction of a large, covered storage building for the Parks and Leisure Services Department. This building is to provide equipment protection from the elements, to allow for work areas, lockable tool spaces and material handling and storage. This area will also serve as storage for the equipment that is used on a daily basis. The crews will have the opportunity to place a fully loaded trailer under the cover at the end of each day, without having to unload, and be ready for the next day. This covered area was el1minated from the original recommended award for purposes of reducing the award amount and to allow the opportunity to review alternate structures for reduced costs. The cost of the proposed structure was reduced as a result from a preliminary cost of $222,823.00 to a cost of $1 13,963.00 by changing the roof structure and by eliminating the electrical from the building. This structure is vital to the operation of the Parks Maintenance Division. There is currently covered storage and a small workshop at the Deforest Service Center, which will be lost if this building is removed from the scope of the proje,ct. This building will serve as space for equipment, materials and supply storage for the division, It will allow a dry area for receiving bagged fertilizers, mulch, field chalk, infield conditioners, etc. Also, the crews will be given the flexibility to assign all equipment, large and small, a designated space to improve asset management and inventory control. This space will offer the crews the opportunity to become better organized, improving responsiveness and create a more efficient daily workflow process. The contractor for the project, Texas Unified Constructors has provided a change order price to add this building into the project of $113,963.00. This price is elevated somewhat over the price previously discussed as the contractor will be finished with the work he is now contracted to perform, prior to the Covered Equipment/Storage Building arriving on site. This will require placement of a superintendent and laborer on the site specifically for this item. The contractor has requested an additional amount of $8,900.00 because of this fact. City Council Action requested: Award of a Change Order to Texas Unified Constructors in an amount not to exceed $113,963,00. Staff Recommendation: Award of the Change Order as outlined above BR