Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Preliminary (Binder Notes) Operating Budget FY12-13
THIS BUDGET WILL RAISE MORE TOTAL PROPERTY TAXES THAN LAST YEAR'S BUDGET BY $4189253 OR 3.51 %, AND OF THAT AMOUNT, $61,992 IS TAX REVENUE TO BE RAISED FROM NEW PROPERTY ADDED TO THE TAX ROLL THIS YEAR. September 1, 2012 Proposed Apparatus Replacement Schedule What are our Neighbors doing? Bedford - 2-Engines, 1-Truck (103 ft.) 3 Medics, 1-BC Hurst: 2-Engines, 1 Quint (75 ft.) 2 Medics, 1 BC Grapevine: 3-Engines, 2 Quints (75 ft.) 3 Medics, 1-BC (100 ft. platform on order) Colleyville: 1 Engine, 2 Trucks (95 ft. & 105 ft.), 1-Medic, 1 BC Haltom City: 1 Quint (75 ft.) 3 Engines NRH: 3 Engines, 1 Truck (100 Ft.) 1 Quint (75 Ft.) 3 Medics, 1 BC DFW: 2 Engines, 2 Trucks (90-110 ft.), 2 Quints (75 Ft.), 3 Medics, 1 BC Keller: 2 Quints, 1 Truck (110 ft.), 2 Medics, 1 BC Euless Current Deployment 2 Quints (75 ft.) 1 Truck (110 ft.) 1 Squad, 3 Medics, 1-BC Options: Suggested Replacement Plan: 12-years for Engines total or 10 years front line and up to 2-5 years reserve 14-years for Trucks/Quints total or 12 years front line and up to 2-5 years reserve National Average is: 10-15 years for Engines and 15-20 years for Trucks/Quints Quints and Trucks are not run first out in the National Average Data. Bedford does not have a replacement schedule. Current deployment is 2000 & 2011 Engine, 2008 110 ft. Truck. Reserves are 1998 Engine and a 2000 Quint. Hurst has a 10 year front line and 10 year reserve but they don't follow it. Current deployment is a 2007 Quint, 2010 & 2011 Engines. Reserves are 1999 & 2000 Engines and a 1996 Quint. Current age/mileage of front line apparatus 2002 Sutphen Truck 110 ft. current age 10 yrs. with 51,300 miles Proposed Replacement 2014-2015 (Quint) 2005 Sutphen Quint 75 ft. current age 7 yrs. with 53,527 miles Proposed Replacement 2017 (Quint) 2008 Sutphen Quint 75 ft. current age 4 yrs. with 32,564 miles Proposed Replacement 2020 (Quint) 1998 Quality Pumper current age 14 yrs. with 6065 hrs. logged Proposed Replacement 2013(Engine) 1995 Sutphen Pumper current age 17 yrs. with 106,672 miles Proposed Replacement 2009 (Engine) *current mileage is unknown on 1998 pumper due to odometer being replaced twice. Note: Truck 553110 ft. Platform was put into service in 2003 which could push the replacement out to 2015. Pros of an Engine: Cost $500,000-550,000 with CAFS ➢ More Reliable requiring less maintenance ➢ Will more easily deploy/reload supply lines on working fires (central location in city) ➢ Additional Command Light for nighttime operations and carries 500 gallons water. Pros of a Quint: Cost $675,000-725,000 with CAFS 78ft-90ft. ➢ Will continue with the "All Quint Concept" maximizing versatility. ➢ It won't be perceived that we are taking a step back backward or changing the direction that was sold prior to my arrival. ➢ Immediate Rescue capability in buildings of 3 stories or greater with first arriving unit. Pros/Cons: (list separately) ➢ We can handle most or all buildings if we have access with the 75 ft. Quints. ➢ What about Glade Parks? Discussion of building above 5 stories... ➢ No known rescue in Northeast Tarrant County using an aerial device. ➢ The utilization of aerial devices averages 2-3 times annually. The total call volume to 2011 was 4132. When the aerial is used it is typically a defensive fire operation. ➢ Keller is the only city in NEFDA that runs all quints/trucks. ➢ Reserve Engines ran almost 858 calls or 36% of the total calls made in 2011. The next fire truck replacement is the most difficult because of the age of the reserve engines and the recommendation to not replace Truck 553 with a similar vehicle. Truck 553 averages 5000 miles per year and with the squad in service 30%-65% of the time that should be reduced even more. An engine would meet the needs of the department but because of the direction set prior to my arrival and the concern of affecting our ISO score based on my meeting with our consultant Mike Peitsch it is my recommendation to consider a 75-80 ft. single axle quint for the replacement of Truck 553. This does not address the current issue regarding the age of the reserve apparatus. However, the biggest issue that the fire department has with the fire truck fleet is keeping the front line equipment and reserve equipment in service and the time that they are out of service often waiting for parts. It is not uncommon to see more than one fire truck in the service center in need of repairs or waiting for parts. 77 ILI= avdZI In v 67- (4. /, 4", Jo -Ia AYA Oil It w,;itl 61 71A 1,4 CA dtl,6. - Tar ,, s --),3,. OA)4ulll 97 AL Ct Oi Water Rate Comparison Local Commercial Customers ,°lvua •Ys Y�i:r�. .;i "�,.3�'vl r�. E, x, .�� .. .aai'utiEc .. :. a...,�9xa� kid'"'�� di� _...� +auv ��k.Ffi .3 i m �. h�:u,:a h '�h� �E'� � uk.�i�.�"' .:E �:.L4l�ak� E E d�». "' i'• 4 � � �:'a f '��. d... �.a�zu,.',� �., f a .. f E. i i'..�i'�n. ,.:.a.�atl �1! S� awl �akf..,, ��f rip !. k N.,: ; yy vd� } :Tv �� u 4 ri ra. i ,�1 March I 52,000 gals I $208.32 I $244.19 I $242.39 f 3.3q jes5 Calculations at FY2013 Rates Customer Type Meter Size/ Consumption Current Flat Rate Structure Tiered Rate Structure Tiered Rate with 12C Rebate Customer Type Meter Size/ Consumption Current Tiered Rate Structure Current Tiered Rate with 12C Rebate Flat Rate Structure Volume Revs by Tier 13,074,000 $ 48,897 T1 38,211,000 $ 142,909 T2 41,956,000 $ 156,915 T3 103,890,000 $ 388,549 T4 472,933,000 $ 1,768,769 T5 T6 670,064,000 $ 2,506,039 Total Volume 670,064,320 $ 1,217,662 Total Base $ 3,723,702 $ 3,723,701 Total Revs City of Euless Tiered Water Rate Analysis - Sept 11 to Aug 12 Consumption by Month - MultiFamily Increase Increase Nn VnlnmP invindi-d In Minimnm Cost at Cost of 2013 CY Rebate Amt Rebate Multifamily % of Volume % of Revs $ 0.21 $ 0.12 0-2000 gals CONA $ 3.74 2% 2% $ 2,746 $ 1,569 3000-8000 CONB $ 3.74 6% 6% $ 8,024 $ 4,585 9000-15000 CONC $ 3.74 6% 6% $ 8,811 $ 5,035 16000-35000 COND $ 3.74 16% 16% $ - $ - 71% 71% $ - $ - > 50000 $ 3.74 0% 0% $ - $ - Gas Welts/CN $ 6.60 100% 100% $ 19,581 $ 11,189 Base $ 7.95 Volume Revs by Tier 12,742,000 $ 47,655 T1 24,496,000 $ 91,615 T2 19,676,000 $ 73,588 T3 36,555,000 $ 136,716 T4 99,567,000 $ 372,381 T5 T6 193,036,000 $ 721,955 Total Volume 193,036,380 $ 105,820 Total Base $ 827,780 $ 827,775 Total Revs City of Euless Tiered Water Rate Analysis - Sept 11 to Aug 12 Consumption by Month - Commercial Increase Increase No Volume Included In Minimum Cost at Cost of 2013 CY Rebate Amt Rebate Commercial % of Volume % of Revs $ 0.21 $ 0.12 0-2000 gals CONA $ 3.74 7% 7% $ 2,676 $ 1,529 3000-8000 CONB $ 3.74 13% 13% $ 5,144 $ 2,940 9000-15000 CONC $ 3.74 10% 10% $ 4,132 $ 2,361 16000-35000 COND $ 3.74 19% 19% $ - $ - 52% 52% $ - $ - > 50000 $ 3.74 0% 0% $ - $ - 100% 100% $ 11,952 $ 6,830 Insurance Admin Fees FY12 # of Current Annual # of Budgeted Budgeted Participant Fee as of May # of Proposed Proposed Participants* Rate Annual Fee s as of May Actual Rate enrollments Participants Rate Annual Fee Medical Admin 364 $15.00 $65,520 373 $15.00 $67,140 373 $15.75 $70,497 Cobra/Hippa Admin 364 $1.45 $6,334 373 $1.45 $6,490 373 $1.53 � $6,848 lJ UR 364 $5.95 $25,990 373 $2.50 $11,190 373 $2.50 $11,19.0 Medical PPO Network 364 $12.75 $55,692 373 $15.25 $68,259 373 $15.86 $70,989 Dental Admin 359 $1.70 $7,324 368 $1.70 $7,507 368 $1.79 $7,905 W 13,gL5 Dental PPO Network 359 $1.25 $0.00 $5,385 $0 368 128 $1.25 $4.75 $5,520 $7,296 368 128 $1.25 $4.75 $5,520 nz. $7,396 FY13 includes $100 Renewal fee Flex LDI (based on # of Scripts) 128 9,240 $4.25 $39,270 9,543 $4.25 $40,558 9,543 $4.25 $40;558(3) Total Insurance Services $205,514 $213,960 $220;903 Reporting (Verisk)/Disease Mgmt 364 $3.45 $15,070 373 $2.95 $13,204 373 $2.95 $9204 Disease Mgmt ($100 per hour) 160 $100.00 $16,000 160 $100.00 $16,000 160 $100.00 $"r6;t?00V City Wellness Expenses $2,184 %Opo 1� Total Wellness $31,070 $31,388 $04 Aggregate 364 $5.67 $27,243 373 $5.67 $25,379 373 $5.67 g7;�917 FY13 includes IC increase Spec -Employee Only 161 41.93 $89,110 168 $43.78 $88,260 168 43.78 $ tl 500 F _13 includes 15% increase `I r Spec -Employee Plus 203 $100.37 $268,951 205 102.92 $253,183 205 $102.92 $291,16114) Total Re -insurance $385,304 $366,823 :$4 577 Personnel Expenses $69,691 $69,691 $T42 (includes payplan) Special Services $30,000 $30,000 $31�;000 Other $2,000 $2,000 $;bD Other Admin Fees $101,691 $101,691 .2 Insurance Claims $3,382,940 $3,382,940 3,a)��93( a6.71p RX Claims $559,890 $3,942,830 $559,890 $3,942,830 Claims Contingency $155,000 $155,000 .,,.UU efelused as a ancing ) OPEB $400,000 $400,000 $0�3Yf00 Total Insurance Budget $5,221,409 $5,211,692 $1,�34,526 $313,539 $316,649 $332;88,T L < 1- ��a 25 JUL 2012 TARRANT APPRAISAL DISTRICT CITY OF EULESS 2012 Certified Appraisal Roll Valuation Summary 1, Jeff Law, Chief Appraiser for the Tarrant Appraisal District, to the best of my ability do solemnly swear that the attached is that portion of the appraisal roll of the Tarrant Appraisal District which lists property taxable by the above named entity and constitutes their certified appraisal roll. APPRAISED VALUE (Considers Value Caps) - - - - - - - - - - - - - - - - - > $ Absolute Exemption $ 536,864,994 Cases before ARB $ 52, 775, 184 Incompletes $ 31,874,931 Deferred, Special Use, and Partial Exemptions $ 344,853,644 See Totals Report for breakdown of each Exemption NET TAXABLE VALUE -------------- ---------------> $ Appraised value minus Absolute Exemption amount, minus ARB amount, minus Incompletes, minus Deferred, Special Use and Partial Exemptions to equal the NTV. ESTIMATED NET TAXABLE VALUE --------- ----------> $ Including suggested values to be used for pending A.R.B. accounts (see page two), and Incomplete accounts (see page three). 3,667,561,802 2,701,193,049 2,761,884,486 Page 1 of 3 2500 Handley-Ederville Road Fort Worth, Texas 76118 (817) 284-0024 LTR25C.fsl 6-29-2012 25 JUL 2012 `TW TARRANT APPRAISAL DISTRICT Jeff Law, Chief Appraiser CITY OF EULESS 2012 Appraisal Review Board Information Section 25.01 (c) of the State Property Tax Code directs the chief appraiser to prepare a list of all properties under protest with the Appraisal Review Board and pending disposition at the time of value roll certification. The values below are from the ARB roll and are not included in the totals certified by the chief appraiser and represented on page 1 of this report. $ 52,775,184 Total appraised value of properties under protest. $ 45,781 , 769 Net taxable value of properties under protest. $ 32,047,238 Estimated minimum taxable value for the same properties. This value should be added to the net taxable value on page one. Page 2 of 3 2500 Handley-Ederville Road Fort Worth, Texas 76118 (817) 284-0024 LTR25D.fsl 6-29-2012 25 JUL 2012 _M W TARRANT APPRAISAL DISTRICT Jeff Law, Chief Appraiser CITY OF EULESS 2012 Incomplete Property Information Section 26.01(d) of the State Property Tax Code directs the chief appraiser to prepare a list of all properties that are not on the certified appraisal roll and not included on the ARB roll. The values below are from the incomplete property listing and are not included in the totals certified by the chief appraiser and represented on page 1 of this report. The value of incomplete properties are subject to change and are also subject to apReal before the AePraisal Review Board. $ 31,874,931 Total appraised value of incomplete properties $ 28,644,199 Estimated net taxable value of incomplete properties Page 3 of 3 2500 Handley-Ederville Road Fort Worth, Texas 76118 (817) 284-0024 LTR25E.fsl 6-29-2012 07/20/2012 TARRANT APPRAISAL DISTRICT 7.24.48 CITY OF EULESS 025 TOT200EP TOTALS REPORT ROLL: JUL 2012 CERTIFIED REPORT ITEM APPRAISED VALUE ACCOUNTS TAXABLE VALUE 1. REAL ESTATE RESIDENTIAL (+) 1,629,512,924 12,295 1,303,417,077 2. REAL ESTATE COMMERCIAL (+) 1,551,173,855 1,094 1,005,514,314 3. REAL ESTATE INDUSTRIAL (+) 8,714,487 10 8,714,487 4. PERSONAL PROPERTY COMMERCIAL(+) 440,760,277 1,062 433,946,819 5. PERSONAL PROPERTY INDUSTRIAL(+) 17,534,091 24 11,330,528 6. MINERAL LEASE PROPERTIES (+) 15,866,800 318 12,690,700 7. AGRICULTURE PROPERTIES (+) 3,999,368 12 5,092 8 TOTAL APPRAISED VALUE (_) 3,667,561,802 14,815 2,775,619,017 -------------------------------------------------------------------------------- 9. CASES BEFORE ARB (-) 52,775,184 171 45,781,769 10. INCOMPLETE ACCOUNTS (-) 31,874,931 490 28,644,199 11. CERTIFIED APPRAISED VALUE (_) 3,582,911,687 14,154 2,701,193,049 -------------------------------------------------------------------------------- EXEMPTION DETAIL EXEMPT AMOUNT ACCOUNTS APPRAISED VALUE 12. ABSOLUTE EXEMPTIONS 536,864,994 306 536,864,994 13. AG DEFERRALS ' 3,994,276 12 3,999,368 14. SCENIC DEFERRALS 0 0 0 15. ABATEMENTS 0 0 0 16. PUBLIC ACCESS AIRPORTS 0 0 0 17. INDIGENT HOUSING 0 0 0 18. NOMINAL VALUE ACCOUNTS 0 0 0 19. DISABLED VETS 4,749,960 195 27,384,389 20. FREEPORT INVENTORY 1,764,770 4 3,790,694 21. GOODS IN TRANSIT 0 0 0 22. HOMESTEADS - STATE MANDATE 0 0 0 23. OVER 65 - STATE MANDATE 0 0 0 24. DISABLED - STATE MANDATE 0 0 0 25. HOMESTEADS - LOCAL OPTION 249,298,232 8,793 1,251,119,365 26. OVER 65 - LOCAL OPTION 69,216,121 2,021 251,908,339 27. DISABLED - LOCAL OPTION 0 124 0 28. SOLAR/WIND 0 0 0 29..POLLUTION CONTROL 307,514 3 1,697,751 30. COMM HSE DEV 15,101,587 3 15,101,587 31. PRORATED ABSOLUTE 421,184 5 1,366,165 32. HISTORIC SITES 0 0 0 33. FOREIGN TRADE ZONE 0 0 0 34 TOTAL EXEMPT AMOUNT (-) 881,718,638 35 NET TAXABLE VALUE (_) 2,701,193,049 14,154 3,582,911,687 -------------------------------------------------------------------------------- NEW EXEMPTIONS THIS YEAR EXEMPT AMOUNT ACCOUNTS APPRAISED VALUE (INCLUDED IN ITEM 12 TO 33) 36. NEW ABSOLUTE EXEMPTIONS 0 0 0 37. NEW AG DEFERRALS 0 0 0 38. NEW SCENIC DEFERRALS 0 0 0 39. NEW ABATEMENTS 0 0 0 40. NEW PUBLIC ACCESS AIRPORTS 0 0 0 41. NEW INDIGENT HOUSING 0 0 0 42. NEW NOMINAL VALUE ACCOUNTS 0 0 0 43. NEW DISABLED VETS 140,900 6 914,900 44. NEW FREEPORT INVENTORY 0 0 0 45. NEW GOODS IN TRANSIT 0 0 0 PAGE 1 07/20/2012 TARRANT APPRAISAL DISTRICT 7.24.48 CITY OF EULESS 025 TOT200EP TOTALS REPORT ROLL: JUL 2012 CERTIFIED -------------------------------------------------------------------------------- NEW EXEMPTIONS THIS YEAR EXEMPT AMOUNT ACCOUNTS APPRAISED VALUE 46. NEW HOMESTEADS - STATE MANDATE 0 0 0 47. NEW OVER 65 - STATE MANDATE 0 0 0 48. NEW DISABLED - STATE MANDATE 0 0 0 49. NEW HOMESTEADS - LOCAL OPTION 4,173,276 113 21,065,571 50. NEW OVER 65 - LOCAL OPTION 1,359,167 40 5,795,081 51. NEW DISABLED - LOCAL OPTION 0 3 0 52. NEW SOLAR/WIND 0 0 0 53. NEW POLLUTION CONTROL 0 0 0 54. NEW COMM HSE DEV 0 0 0 55. NEW PRORATED ABSOLUTE 393,122 3 451,054 56. NEW HISTORIC SITES 0 0 0 57. NEW FOREIGN TRADE ZONE 0 0 0 -------------------------------------------------------------------------------- NEW CONSTRUCTION TAXABLE VALUE ACCOUNTS APPRAISED VALUE 58. ALL REAL ESTATE 13,189,725 92 17,439,616 59. NEW BUSINESS IN NEW IMPROVEMENT 0 0 0 60. TOTAL NEW CONSTRUCTION 13,189,725 92 17,439,616 61. NEW CONSTRUCTION IN RESIDENTIAL 10,471,040 81 11,997,605 62. -------------------------------------------------------------------------------- NEW CONSTRUCTION IN COMMERCIAL 2,718,685 11 5,442,011 63. ANNEXATIONS 0 0 0 64. DEANNEXATIONS 0 0 0 -------------------------------------------------------------------------------- TAX CEILINGS TAXABLE VALUE ACCOUNTS CEILING AMOUNT 65. OVER 65 127,798,911 1,978 611,323.53 66. DISABLED PERSON 10,950,976 122 54,682.81 67. TOTAL CEILINGS 138,749,887 2,100 666,006.34 (INCLUDED IN ABOVE) 68. NEW OVER 65 CEILINGS 9,539,749 136 45,253.69 69. NEW DISABLED PERSON CEILINGS - 1,012,920 11 4,916.82 -------------------------------------------------------------------------------- CAPPED ACCOUNTS CAP VALUE ACCOUNTS CAP LOSS 70. CAP TOTAL 41,862,923 418 2,141,377 71. NEW CAP THIS YEAR 39,875,096 403 1,948,604 -------------------------------------------------------------------------------- ALL EXEMPTIONS BY GROUP EXEMPT AMOUNT APPRAISED VALUE 72. ALL RESIDENTIAL ACCOUNTS 326,095,847 1,629,512,924 73. ALL COMMERCIAL ACCOUNTS 552,472,999 1,991,934,132 74. ALL INDUSTRIAL ACCOUNTS 6,203,563 26,248,578 75. ALL MINERAL LEASE ACCOUNTS 3,176,100 15,866,800 76. -------------------------------------------------------------------------------- ALL AGRICULTURE ACCOUNTS 3,994,276 3,999,368 PAGE 2 07/20/2012 CITY OF EULESS 025 7.25.50 ABSOLUTES, ARB & INCOMPLETE TOTALS BY CATEGORY ROLL: JUL TOT210EP 2012 CERTIFIED 1. REAL ESTATE RESIDENTIAL 2. REAL ESTATE COMMERCIAL 3. REAL ESTATE INDUSTRIAL 4. PERSONAL PROPERTY COMMERCIAL 5. PERSONAL PROPERTY INDUSTRIAL 6. MINERAL LEASE PROPERTIES 7. AGRICULTURE PROPERTITES TOTAL ABSOLUTES ARB INCOMPLETE AMOUNT COUNT AMOUNT COUNT AMOUNT COUNT 1,668,432 40 8,038,330 64 254,871 2 529,307.961 256 11,716,649 50 8,309,501 6 0 0 599,950 1 0 0 5,888,601 10 25,963,443 54 19,023,389 302 0 0 6,456.812 2 0 0 0 0 0 0 4,287,170 180 0 0 0 0 0 0 536,864,994 306 52,775,184 171 31,874.931 490 07/20/2012 CITY OF EULESS 025 7.30.37 CERTIFIED, ARB & INCOMPLETE EXEMPTION TOTALS ROLL: JUL TOT350EP 2012 CERTIFIED CERTIFIED LOSS 1. ABSOLUTE EXEMPTIONS 536,864,994 2. AG DEFERRALS 3,994,276 3. SCENIC DEFERRALS 0 4. ABATEMENTS 0 5. PUBLIC ACCESS AIRPORTS 0 6. INDIGENT HOUSING 0 7. NOMINAL VALUE ACCOUNTS 0 8. DISABLED VETS 4,749,960 9. FREEPORT INVENTORY 1,764,770 10. HOMESTEADS 249,298,232 11. OVER 65 69,216.121 12. DISABLED PERSON 0 13. SOLAR/WIND 0 14. POLLUTION CONTROL 307,514 15. COMM HSE DEV 15,101,587 16. PRORATED ABSOLUTE 421,184 17. HISTORIC SITES 0 18. FOREIGN TRADE ZONE 0 19. NET TAXABLE VALUE OF ALL FROZEN ACCTS 20. CAP LOSS ON RESIDENTIAL MARKET VALUES CERTIFIED APPRAISED VALUE PROTESTED APPRAISED VALUE INCOMPLETE APPRAISED VALUE ABSOLUTE EXEMPT VALUE TOTAL APPRAISED VALUE CERTIFIED NET TAXABLE VALUE NET TAXABLE IN ARB NET TAXABLE IN INCOMPLETE TOTAL NET TAXABLE VALUE ARB INCOMPLETE TOTAL COUNT LOSS COUNT LOSS COUNT LOSS COUNT 306 622,649 2 3,176,100 117 540.663,743 425 12 0 0 0 0 3,994,276 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3,658 9 3,658 9 195 0 0 0 0 4.749.960 195 4 5.177.175 3 0 0 6,941,945 7 8,793 852,662 23 50,974 2 250,201.868 8,818 0 245,000 7 0 0 69,461,121 7 124 O 0 0 0 0 124 0 0 0 0 0 0 0 3 95.929 3 0 0 403,443 6 3 0 0 0 0 15,101,587 3 5 O 0 0 0 421,184 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 138,749,887 2,100 ACCTS 2,141,377 418 ACCTS 3,046,046,693 9,425 ACCTS 52.775.184 171 ACCTS 31,874,931 490 ACCTS 536,864,994 306 ACCTS 3,667,561.802 14,815 ACCTS 2,701.193,049 45,781,769 28,644,199 2,775,619.017 TOT320BP-A TARRANT APPRAISAL DISTRICT PAGE 1 TOT3200 STATE USE CODE STATISTICS 2012 DATE: 07/20/2012 TDC: 025 CITY OF EULESS TIME: 08:18:57 CATEGORY ------------------------------ CERT. APPR VALUE ARB VALUE INCOMPLETE VALUE AG VALUE AG NEW CONSTRUCTION NUMBER OF ACCTS NUMBER OF ACCTS NUMBER OF ACCTS NUMBER OF ACCTS ACREAGE NUMBER OF ACCTS ------------------------------------------------ ---------------- ------------- ---------------- Al RESIDENTIAL SINGLE-FAMILY 1,454,786,091 6,545,935 254,871 0 0.0000 10,455,452 10,189 43 2 0 68 NET TAXABLE VALUE 1,152,676,569 5,471,273 203,897 A2 RESIDENTIAL MOBILE HOMES 2,110,102 0 0 0 0.0000 390 98 0 0 0 1 NET TAXABLE VALUE 1,493,682 0 0 A3 RESIDENTIAL CONDOMINIUMS 795,200 0 0 0 0.0000 0 16 0 0 0 0 NET TAXABLE VALUE 795,200 0 0 A4 RESIDENTIAL TOWNHOMES 21,642,024 174,400 0 0 0.0000 0 249 2 0 0 0 NET TAXABLE VALUE 18.020,986 174,400 0 A5 RESIDENTIAL UNDECLARED 24,723,800 62,300 0 0 0.0000 0 184 1 0 0 0 NET TAXABLE VALUE 20,683.500 62,300 0 A9 INTERIM USE 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 ------------- ----------------- ** ------------------- CAT A TOTALS ------------------- 1,504,057,217 ------------------- 6,782.635 ------------------- 254,871 0 0.0000 10.455,842 10,736 46 2 0 69 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT A NET TAXABLE VALUE 1,193,669,937 5,707,973 203,897 B1 RESIDENTIAL MULTI -FAMILY 577,175,404 0 0 0 0.0000 0 81 0 0 0 0 NET TAXABLE VALUE 562,073,817 0 0 62 RESIDENTIAL DUPLEX 98,608,705 1,340,200 0 0 0.0000 16,663 1,100 16 0 0 1 NET TAXABLE VALUE 85,905,246 1.317,200 0 B3 RESIDENTIAL TRIPLEX 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 B4 RESIDENTIAL QUADRUPLEX 8,739,300 0 0 0 0.0000 0 51 0 0 0 O NET TAXABLE VALUE 8.667,400 0 0 ------------------- ------------- ----------------- ** ------------------- CAT B TOTALS ------------------- 684,523,409 ------------------- 1,340,200 0 0 0.0000 16,663 1.232 16 0 0 1 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT B NET TAXABLE VALUE 656,646,463 1.317,200 0 Cl VAC/PLATTED RES. LT 5 ACRES 1,840,673 41,295 0 235 1.7820 0 197 3 0 2 0 NET TAXABLE VALUE 1,796,200 41,295 0 C2 VAC/PLATTED COMMERCIAL 35,062,848 1,094,515 570,333 699 5.2920 0 226 9 4 1 0 NET TAXABLE VALUE 34,371,990 1,094,515 570,333 C3 VAC/UNPLATTED RURAL LT 5 ACRES 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 TOT320BP-A TARRANT APPRAISAL DISTRICT PAGE 2 TOT320J STATE USE CODE STATISTICS 2012 DATE: 07/20/2012 TDC: 025 CITY OF EULESS TIME: 08:18:57 CERT. APPR VALUE ARB VALUE INCOMPLETE VALUE AG VALUE AG NEW CONSTRUCTION ------------------------------ CATEGORY NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ---------------- ------------- ACREAGE NUMBER OF ACCTS ---------------- C6 VACANT EXEMPT -RIGHT OF WAY 118,365 0 0 0 0.0000 0 1 0 0 0 0 NET TAXABLE VALUE 3,243 0 0 ** CAT C TOTALS -------------------------------------- 37,021,886 ------------------- 1,135.810 ------------------- 570,333 ------------- 934 7.0740 ----------------- 0 424 12 4 3 0 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT C NET TAXABLE VALUE 36,171.433 1,135,810 570,333 D1 ACREAGE RANCH LAND 3,263.103 0 0 4,158 50.2961 0 9 0 0 9 0 NET TAXABLE VALUE 4.158 0 0 D2 ACREAGE TIMBERLAND 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 D3 ACREAGE FARM LAND 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 D4 ACREAGE UNDEVELOPED 26,153,566 1,451,803 6,639,939 0 0.0000 0 34 2 1 0 0 NET TAXABLE VALUE 26,153,566 ------------------- 1,451,803 6,639,939 ** CAT D TOTALS ------------------- 29,416,669 ------------------- 1,451,803 ------------------- 6,639,939 4,158 ------------- 50.2961 ----------------- 0 43 2 1 9 0 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT D NET TAXABLE VALUE 26.157,724 1,451,803 6,639,939 E1 FARM/RCH HOUSE + LTD ACRES 534.900 0 0 0 0.0000 0 2 0 0 0 0 NET TAXABLE VALUE 461,960 0 0 E2 FARM/RCH MH + LTD ACRES 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 E3 FARM/RCH OTHER 0 0 0 O 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 ------------------- 0 0 ** CAT E TOTALS ------------------- 534,900 ------------------- 0 ------------------- 0 0 ------------- 0.0000 ----------------- 0 2 0 0 0 0 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT E NET TAXABLE VALUE 461,960 0 0 F1 COMMERCIAL 353,252,049 8,421,882 1.099,229 0 0.0000 1,785,476 409 36 1 0 6 NET TAXABLE VALUE 352,739,827 8,421,882 1.099,229 F2 INDUSTRIAL 8,114,537 599,950 0 0 0.0000 51,634 9 1 0 0 1 NET TAXABLE VALUE 8,114,537 599,950 0 F3 BILLBOARDS 0 0 66,471 0 0.0000 0 0 0 2 0 0 NET TAXABLE VALUE 0 0 66.471 TOT320BP-A TARRANT APPRAISAL DISTRICT PAGE 3 TOT320J STATE USE CODE STATISTICS 2012 DATE: 07/20/2012 TDC: 025 CITY OF EULESS TIME: 08:18:57 CATEGORY ------------------------------ CERT. APPR VALUE ARB VALUE INCOMPLETE VALUE AG VALUE AG NEW CONSTRUCTION NUMBER OF ACCTS NUMBER OF ACCTS NUMBER OF ACCTS NUMBER OF ACCTS ACREAGE NUMBER OF ACCTS --------------------------------------------------------------------------------------------- ** CAT F TOTALS 361,366,586 9,021,832 1,165,700 0 0.0000 1,837,110 418 37 3 0 7 *+ ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT F NET TAXABLE VALUE 360,854,364 9,021,832 1,165,700 G1 OIL, GAS, MINERAL RESERVE 11,579,630 0 1,111,070 0 0.0000 0 138 0 85 0 0 NET TAXABLE VALUE 11,579,630 0 1,111,070 ------------------- ------------- ----------------- ** CAT G TOTALS -------------------------------------- 11,579.630 ------------------- 0 1.111,070 0 0.0000 0 138 0 85 0 0 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT G NET TAXABLE VALUE 11,579,630 0 1,111,070 J1 UTILITY WATER SYSTEMS 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 J2 UTILITY GAS COMPANIES 4,196,160 0 0 0 0.0000 0 1 0 0 0 0 NET TAXABLE VALUE 4.196,160 0 0 J3 UTILITY ELECTRIC COMPANIES 34,526,080 0 100 0 0.0000 0 11 0 1 0 0 NET TAXABLE VALUE 34,526,080 0 100 J4 UTILITY TELEPHONE COMPANIES 58.350,889 147,753 2,393,525 0 0.0000 881,575 22 1 29 0 2 NET TAXABLE VALUE 58,350,889 147,753 2,393,525 J5 UTILITY RAILROADS 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 J6 UTILITY PIPELINES 12,568,440 2.136.720 0 0 0.0000 0 9 2 0 0 0 NET TAXABLE VALUE 12,568,440 2,042,921 0 J7 UTILITY CABLE COMPANIES 1,846,508 0 0 0 0.0000 0 3 0 0 0 0 NET TAXABLE VALUE 1,846,508 0 0 J8 UTILITY OTHER 1,330,650 0 0 0 0.0000 0 2 0 0 0 0 NET TAXABLE VALUE 1,330,650 0 0 ------------------- ------------- ----------------- ** CAT J TOTALS -------------------------------------- 112,818,727 ------------------- 2,284,473 2,393,625 0 0.0000 881.575 48 3 30 0 2 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT J NET TAXABLE VALUE 112.818,727 2,190.674 2,393,625 L1 COMMERCIAL 286,989,390 23,678,970 16,563,293 0 0.0000 0 662 51 270 0 0 NET TAXABLE VALUE 286,840,304 23.000,656 16.559,635 L2 INDUSTRIAL 11.077.279 6,456.812 0 0 0.0000 0 22 2 0 0 0 NET TAXABLE VALUE 9,374,707 1,955,821 0 I TOT320BP-A TARRANT APPRAISAL DISTRICT PAGE 4 TOT320J STATE USE CODE STATISTICS 2012 DATE; 07/20/2012 TDC: 025 CITY OF EULESS TIME: 08:18:57 it CERT. APPR VALUE ARB VALUE INCOMPLETE VALUE AG VALUE AG NEW CONSTRUCTION ------------------------------ CATEGORY NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ---------- - ---- NUMBER OF ACCTS ----------------------------- ACREAGE NUMBER OF ACCTS ---------------- ** CAT L TOTALS 298,066,669 30,135,782 16,563,293 0 0.0000 0 684 53 270 0 0 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT L NET TAXABLE VALUE 296,215,011 24,956,477 16,559,635 M1 PRIVATE WATERCRAFT 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 M2 PRIVATE AIRCRAFT 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 M3 MOBILE HOME IMPROVEMENT ONLY 236,200 0 0 0 0.0000 0 12 0 0 0 0 NET TAXABLE VALUE 193,000 0 0 M4 MISCELLANEOUS 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 ** CAT M TOTALS 236,200 0 0 0 0.0000 0 12 0 0 0 0 ** ------------------------------------------------------------------------------------------------------------------------------------------------------- CAT M NET TAXABLE VALUE 193,000 0 0 N1 NOT OTHERWISE CLASSIFIED 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 ----------------- ** CAT N TOTALS ------------------- 0 ------------------- 0 ------------------- ------------------- 0 0 ------------- 0.0000 0 D 0 0 0 0 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT N NET TAXABLE VALUE 0 0 0 01 RES VACANT INVENTORY Cl 3,213.840 0 0 0 0.0000 0 94 0 0 0 0 NET TAXABLE VALUE 3,213,840 0 0 02 RES IMPROVED INVENTORY 3,210.960 0 0 0 0.0000 1,525,100 17 0 0 0 11 NET TAXABLE VALUE 3,210,960 0 0 03 RES IMPROVED INVENTORY A3 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 04 RES IMPROVED INVENTORY A4 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 05 RES IMPROVED INVENTORY A5 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 06 RES IMPROVED INVENTORY 82 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 TOT320BP-A TARRANT APPRAISAL DISTRICT PAGE 5 TOT320J STATE USE CODE STATISTICS 2012 DATE: 07/20/2012 TDC: 025 CITY OF EULESS TIME: 08:18:57 CATEGORY ------------------------------ CERT. APPR VALUE ARB VALUE INCOMPLETE VALUE AG VALUE AG NEW CONSTRUCTION NUMBER OF ACCTS NUMBER OF ACCTS NUMBER OF ACCTS NUMBER OF ACCTS ACREAGE NUMBER OF ACCTS ---------------------------------------------------------------- ----------------------------- 07 RES IMPROVED INVENTORY B3 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 08 RES IMPROVED INVENTORY B4 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 ------------- ----------------- ** ------------------- CAT O TOTALS ------------------- 6,424,800 ------------------- 0 ------------------- 0 0 0.0000 1,525,100 111 0 0 0 11 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT 0 NET TAXABLE VALUE 6.424,800 0 0 ** ------------------- TDC TOTALS ------------------- 3,046,046.693 ------------------- 52,152,535 ------------------- 28,698,831 ------------- 5.092 ----------------- 57.3701 14,716,290 13,848 169 395 12 90 BEGIN CERT APPRAISED VALUE 3,582.911,687 BEGIN CERT APPRAISED ACCTS 14,154 ** TDC NET TAXABLE VALUE 2.701.193.049 45.781,769 28,644,199 5,092 ** TDC AG IMPROVEMENTS 0 NOTE: ABSOLUTE EXEMPTIONS ARE NOT INCLUDED EXCEPT FOR PRORATED ABSOLUTES 07/20/12 TARRANT APPRAISAL DISTRICT (TADBO60) JURISDICTION CITY OF EULESS AVERAGE MARKET VALUE PER ACCOUNT > 143,064 AVERAGE NET TAXABLE VALUE PER ACCOUNT > 113,297 TOTAL MARKET VALUE >>>>> 1,454,390,079 VALUE IN PARCEL ENTITY PLEASE NOTE: ACCOUNTS IN PROTEST & INCOMPLETE ACCOUNTS ARE THOUSANDS COUNT DISTRIBUTION GRAPHICS - N 0 T - INCLUDED IN ANY OF THE CALCULATIONS UND - 5 ' 5 ' 5 - 10 1 �* 10 - 15 0 15 - 20 1 20 - 25 7 �* 25 - 30 5 30 - 35 15 �* 35 - 40 I 9 �* 40 - 45 35 �* 45 - 50 64 �* 50 - 55 53 �* 55 - 60 118** 60 - 65 167** 65 - 70 271*** 70 - 75 ( 235*** 75 - 80 254*** 80 - 85 351**** 85 - 90 362**** 90 - 95 358**** 95 - 100 340**** 100 - 105 332**** 105 - 110 322**** 110 - 115 297 115 - 120 285*** 120 - 125 413***** 125 - 130 329**** 130 - 135 345**** 135 - 140 425***** 140 - 145 381**** 145 - 150 384**** 150 - 155 I 401***** 155 - 160 343**** 160 - 165 278*** 165 - 170 I 331**** 170 - 175 317 (**** 175 - 180 192** 180 - 185 ( 190** 185 - 190 189** 190 - 195 173** 195 - 200 156** 200 - 205 143** 205 - 210 115** 210 - 215 ( 96 �* 215 - 220 67 �* 220 - 225 69 �* 225 - 230 84 �* 230 - 235 81 �* 235 - 240 54 �* 240 - 245 81 �* OVR - 245 642 10,166****5****10***15***20***25***30***35***40***45***50***55***60***65***70***75***80 PARCEL COUNTS IN HUNDREDS - SINGLE FAMILY RESIDENCE ONLY - 2012 Property Valuations per Tarrant Appraisal District Comparison to Property Incomplete Comparison to July 2012 Estimated Values at 5-15-12 Certified Values Under Protest Property Total May 2012 Estimates Total Appraised Value $3,674,586,232 $21,492,914 $0 $3,696,079,146 Net Taxable Value $2,789,712,360 $12,288,864 $0 $2,802,001,224 New Construction $15,324,314 Net taxable Value of frozen Properties $136,925,223 Certified Values as of 9-01-11 Total Appraised Value $3,533,418,247 $18,623,702 $16,232,705 $3,568,274,654 3.582% 0.474% Net Taxable Value $2,651,724,005 $12,836,853 $10,482,623 $2,676,043,481 4.746% 1.604% New Construction $26,667,818 Net taxable Value of frozen Properties $133,749,333 Certified Values as of 7-25-11 Total Appraised Value $3,445,784,542 $93,767,324 $31,691,909 $3,571,243,775 3.496% 0.391% Net Taxable Value $2,568,459,648 $62,399,757 $26,578,264 $2,657,437,669 5.440% 2.277% O&M Tax Value in FYI Budget $2,568,459,648 $62,399,757 $26,578,264 $2,657,437,669 5."0% 2.277% I&S Tax Value in FYI Budget $2,523,614,656 $0 $0 $2,523,614,656 2.275% New Construction $26,772,135 Net taxable Value of frozen Properties $133,823,013 Estimated Values as of 5-15-11 Total Appraised Value $3,575,729,148 $13,685,315 $0 $3,589,414,463 2.972% -0.118% Net Taxable Value $2,695,198,219 $8,812,362 $0 $2,704,010,581 3.624% 0.515% New Construction $27,255,904 Net taxable Value of frozen Properties $132,456,124 Expectations for July based on estimated reduction due to protest Estimated 7-25-12 with 5% reduction Total Appraised Value $3,490,856,920 $20,418,268 Net Taxable Value (O&M) $2,650,226,742 $11,674,421 Net Taxable Value (I&S) $2,524,975,940 $0 Frozen Properties $136,925,223 Estimated 7-25-12 with 3% reduction Total Appraised Value Net Taxable Value (O&M) Net Taxable Value (I&S) Frozen Properties REVENUE COMPARISON FY12 O&M Revenue FY121&S Revenue Total Property Tax Revenue $3,564,348,645 $20,848,127 $2,706,020,989 $11,920,198 $2,581,015,964 $0 $136,925,223 0.345388 0.124612 $0 $3,511,275,189 $0 $2,661,901,163 $0 $2,524,975,940 $0 $3,585,196,772 $0 $2,717,941,187 $0 $2,581,015,964 $8,994,901 $3,144,727 $12,139,628 Preliminary estimates for FYI based on May 15th Tad Numbers (less 5%) with a 98% collection rate Est FYI O&M Revenue 0.344723 0,350664 $8,992,668 $9,147,640 Est FY13 I&S Revenue 0.125277 0.119336 $3,163,208 $3,013,208 Est. Total Revenue $12,155,876 $12,160,848 Difference from FYI Budget $16,248 $21,220 O&M ($2,233) $152,739 I&S $18,481 ($131,519) Preliminary estimates for FYI based on May 15th Tad Numbers (less 3%) with a 98% collection rate Est FYI O&M Revenue 0.347443 0.353255 $9,254,438 $9,409,237 Est FYI I&S Revenue 0.122557 0.116745 $3,163,208 $3,013,208 Est. Total Revenue $12,417,646 $12,422,445 Difference from FYI Budget $278,018 $282,817 O&M $259,537 $414,336 I&S $18,481 ($131,519) TARRANT APPRAISAL DISTRICT 14 MAY 2012 -TAMJeff Law, Chief Appraiser CITY OF EULESS 2012 Appraisal Roll Information Valuation Summary Listed below are UNCER T iFIED PRELIMINARY ESTIMATES of the 2012 appraised values of the property in your district. These gross figures are yet subject to further reductions resulting from: Completion of 2012 Appraisal Activities Completion of staff discussions with taxpayers Appraisal Review Board appeals (A.R.B.) Rendition filing deadline Partial exemption processing Absolute exemption processing Special exemption processing: (Freeport, Open -Space, Ag Deferral, Foreign Trade Zone, Etc.) Historically, the reductions above have averaged 5% countywide. You should anticipate additional losses in value, as a result of these reductions. APPRAISED VALUE (considers value caps) - - - - - - - - - - - - - - - - - > $ Absolute Exemption $ 540,270,618 Cases before ARB $ 21,492,914 Incompletes $ 0 Deferred, Special Use, and Partial Exemptions $ 344,603,254 See Totals Report for breakdown of each Exemption NET TAXABLE VALUE -------------- ---------------> $ Appraised value minus Absolute Exemption amount, minus ARB amount, minus Incompletes, minus Deferred, Special Use and Partial Exemptions to equal the NTV. ESTIMATED NET TAXABLE VALUE- ----------------> $ Including suggested values to be used for pending A.R.B. accounts (see page two). 3,696,079,146 2,789,712,360 2,802,001,224 Pagel of 2 2500 Handley-Ederville Road Fort Worth, Texas 76118 (817) 284-0024 LTR25A 4-20-12 TARRANT APPRAISAL DISTRICT 14 MAY 2012 Jeff Law, Chief Appraiser CITY OF EULESS 2012 Appraisal Roll Information Valuation Summary The protest period has just begun and the protest deadlines do not end until 30 days after the notice is delivered. The A.R.B. will begin hearing protests in mid June. Listed below are the values -to -date of protested accounts in your taxing unit. These values are likely to be subject to some reduction in the ARB hearing process. Our estimated minimum value is included in the Estimated Net Taxable Value line on page 1. $ 21,492,914 Total appraised value of properties under protest. $ 17,555,521 Net taxable value of properties under protest. $ 12,288,864 Estimated minimum taxable value for the.same properties. This value should be added to the net taxable value on page one. i n.,.... 7 ..4 11 �cnn u.d.... M 0...,A c..� UUwAh T.- W11A 1A171'')Ad-nn )A LTR258 4-20-201 05/10/2012 TARRANT APPRAISAL DISTRICT 7.37.07 CITY OF EULESS 025 TOT200EP TOTALS REPORT ROLL: MAY -------------------------------------------------------------------------------- 2012 ESTIMATED REPORT ITEM APPRAISED VALUE ACCOUNTS TAXABLE VALUE -------------------------------------------------------------------------------- 1. REAL ESTATE RESIDENTIAL (+) 1,632,488,923 12,293 1,309,541,707 2. REAL ESTATE COMMERCIAL (+) 1,616,341,512 1,090 1,070,695,567 3. REAL ESTATE INDUSTRIAL (+) 8,714,527 10 8,714,527 4. PERSONAL PROPERTY COMMERCIAL(+) 403,852,636 1,072 397,008,471 5. PERSONAL PROPERTY INDUSTRIAL(+) 14,815,380 24 8,611,817 6. MINERAL LEASE PROPERTIES (+) 15,866,800 318 12,690,700 7. AGRICULTURE PROPERTIES (+) 3,999,368 12 5,092 8 TOTAL APPRAISED VALUE (_) 3,696,079,146 14,819 2,807,267,881 -------------------------------------------------------------------------------- 9. CASES BEFORE ARB (-) 21,492,914 130 17,555,521 10. INCOMPLETE ACCOUNTS (-) 0 0 0 11. CERTIFIED APPRAISED VALUE (_) 3,674,586,232 14,689 2,789,712,360 -------------------------------------------------------------------------------- EXEMPTION DETAIL EXEMPT AMOUNT ACCOUNTS APPRAISED VALUE 12. ABSOLUTE EXEMPTIONS 540,270,618 423 540,270,618 13. AG DEFERRALS 3,994,276 12 3,999,368 14. SCENIC DEFERRALS 0 0 0 15. ABATEMENTS 0 0 0 16. PUBLIC ACCESS AIRPORTS 0 0 0 17. INDIGENT HOUSING 0 0 0 18. NOMINAL VALUE ACCOUNTS 4,802 13 4,802 19. DISABLED VETS 4,689,960 188 26,624,489 20. FREEPORT INVENTORY 6,941,945 7 10,426,060 21. GOODS IN TRANSIT 0 0 0 22. HOMESTEADS - STATE MANDATE 0 0 0 23. OVER 65 - STATE MANDATE 0 0 0 24. DISABLED - STATE MANDATE 0 0 0 25. HOMESTEADS - LOCAL OPTION 245,032,242 8,657 1,229,994,826 26..OVER 65 - LOCAL OPTION 67,993,866 1,985 247,117,128 27. DISABLED - LOCAL OPTION 0 119 0 28. SOLAR/WIND 0 0 0 29. POLLUTION CONTROL 433,306 6 2,715,349 30. COMM HSE DEV 15,101,587 3 15,101,587 31. PRORATED ABSOLUTE 411,270 4 561,454 32. HISTORIC SITES 0 0 0 33. FOREIGN TRADE ZONE 0 0 0 34 TOTAL EXEMPT AMOUNT (-) 884,873,872 35 NET TAXABLE VALUE (_) 2,789,712,360 14,689 3,674,586,232 -------------------------------------------------------------------------------- NEW EXEMPTIONS THIS YEAR EXEMPT AMOUNT ACCOUNTS APPRAISED VALUE (INCLUDED IN ITEM 12 TO 33) 36. NEW ABSOLUTE EXEMPTIONS 0 0 0 37. NEW AG DEFERRALS 0 0 0 38. NEW SCENIC DEFERRALS 0 0 0 39. NEW ABATEMENTS 0 0 0 40. NEW PUBLIC ACCESS AIRPORTS 0 0 0 41. NEW INDIGENT HOUSING 0 0 0 42. NEW NOMINAL VALUE ACCOUNTS 1,108 3 1,108 43. NEW DISABLED VETS 128,900 5 814,200 44. NEW FREEPORT INVENTORY 0 0 0 45. NEW GOODS IN TRANSIT 0 0 0 PAGE 1 05/10/2012 TARRANT APPRAISAL DISTRICT 7.37.07 CITY OF EULESS 025 TOT200EP TOTALS REPORT ROLL: MAY -------------------------------------------------------------------------------- 2012 ESTIMATED NEW EXEMPTIONS THIS YEAR EXEMPT AMOUNT ACCOUNTS APPRAISED VALUE 46. NEW HOMESTEADS - STATE MANDATE 0 0 0 47. NEW OVER 65 - STATE MANDATE 0 0 0 48. NEW DISABLED - STATE MANDATE 0 0 0 49. NEW HOMESTEADS - LOCAL OPTION 3,440,441 93 17,320,859 50. NEW OVER 65 - LOCAL OPTION 875,000 25 3,577,110 51. NEW DISABLED - LOCAL OPTION 0 2 0 52. NEW SOLAR/WIND 0 0 0 53. NEW POLLUTION CONTROL 0 0 0 54. NEW COMM HSE DEV 0 0 0 55. NEW PRORATED ABSOLUTE 393,122 3 451,054 56. NEW HISTORIC SITES 0 0 0 57. NEW FOREIGN TRADE ZONE 0 0 0 -------------------------------------------------------------------------------- NEW CONSTRUCTION TAXABLE VALUE ACCOUNTS APPRAISED VALUE 58. ALL REAL ESTATE 15,324,314 91 19,214,353 59. NEW BUSINESS IN NEW IMPROVEMENT 0 0 0 60. TOTAL NEW CONSTRUCTION 15,324,314 91 19,214,353 61. NEW CONSTRUCTION IN RESIDENTIAL 10,834,492 80 12,001,205 62. --------------------------------------------------------- NEW CONSTRUCTION IN COMMERCIAL 4,489,822 11 m 7,213,148 ANNEXATIONS 0 0 0 64. DEANNEXATIONS 0 0 0 -------------------------------- TAX ----------------------------------------------- CEILINGS TAXABLE VALUE ACCOUNTS CEILING AMOUNT 65. OVER 65 126,423,127 1,956 604,669.47 66. DISABLED PERSON 10,502,096 118 52,435.54 67. TOTAL CEILINGS 136,925,223 2,074 657,105.01 (INCLUDED IN ABOVE) 68. NEW OVER 65 CEILINGS 8,916,053 125 42,218.75 69. NEW DISABLED PERSON CEILINGS 775,320 9 3,744.22 -------------------------------------------------------------------------------- CAPPED ACCOUNTS CAP VALUE ACCOUNTS CAP LOSS 70. CAP TOTAL 42,894,790 426 2,262,610 71. NEW CAP THIS YEAR 40,726,189 409 2,066,111 -------------------------------------------------------------------------------- ALL EXEMPTIONS BY GROUP EXEMPT AMOUNT APPRAISED VALUE 72. ALL RESIDENTIAL ACCOUNTS 322,947,216 1,632,488,923 73. ALL COMMERCIAL ACCOUNTS 552,490,110 2,020,194,148 74. ALL INDUSTRIAL ACCOUNTS 6,203,563 23,529,907 75. ALL MINERAL LEASE ACCOUNTS 3,176,100 15,866,800 76. -------------------------------------------------------------------------------- ALL AGRICULTURE ACCOUNTS 3,994,276 3,999,368 PAGE 2 05/10/2012 CITY OF EULESS 025 7.38.12 ABSOLUTES, ARB & INCOMPLETE TOTALS BY CATEGORY ROLL: MAY TOT210EP 2012 ESTIMATED 1. REAL ESTATE RESIDENTIAL 2. REAL ESTATE COMMERCIAL 3. REAL ESTATE INDUSTRIAL 4. PERSONAL PROPERTY COMMERCIAL 5. PERSONAL PROPERTY INDUSTRIAL 6. MINERAL LEASE PROPERTIES 7. AGRICULTURE PROPERTITES ABSOLUTES ARB INCOMPLETE AMOUNT COUNT AMOUNT COUNT AMOUNT COUNT 1,668,432 40 19,687,244 125 0 0 529,537,785 257 1,805,670 5 O 0 0 0 O O 0 0 5,888,301 9 0 0 0 0 O 0 0 0 0 0 3,176,100 117 0 0 0 0 0 O O 0 0 0 TOTAL 540,270,618 423 21,492,914 130 0 0 05/10/2012 CITY OF EULESS 025 7.40.25 CERTIFIED, ARB & INCOMPLETE EXEMPTION TOTALS ROLL: MAY TOT350EP 2012 ESTIMATED CERTIFIED ARB INCOMPLETE TOTAL LOSS COUNT LOSS COUNT LOSS COUNT LOSS COUNT 1. ABSOLUTE EXEMPTIONS 540,270,618 423 392,825 1 0 0 540,663,443 424 2. AG DEFERRALS 3,994,276 12 0 0 0 0 3,994,276 12 3. SCENIC DEFERRALS O 0 0 0 0 O 0 0 4. ABATEMENTS 0 0 0 0 0 0 0 0 5. PUBLIC ACCESS AIRPORTS 0 0 0 0 0 0 O O 6. INDIGENT HOUSING 0 0 0 0 0 0 0 0 7. NOMINAL VALUE ACCOUNTS 4,802 13 0 0 0 0 4,802 13 8. DISABLED VETS 4,689,960 188 10,000 2 0 0 4,699,960 190 9. FREEPORT INVENTORY 6,941,945 7 0 0 0 0 6,941,945 7 10. HOMESTEADS 245,032,242 8,657 2,974,568 87 0 0 248,006,S10 8,744 11. OVER 65 67,993,866 0 560,000 16 0 0 68,553,866 16 12. DISABLED PERSON 0 119 0 2 0 0 0 121 13. SOLAR/WIND 0 0 0 0 0 0 0 0 14. POLLUTION CONTROL 433,306 6 0 0 0 0 433,306 6 15. COMM HSE DEV 15,101,587 3 0 0 0 0 15,101.587 3 16. PRORATED ABSOLUTE 411,270 4 0 0 0 0 411,270 4 17. HISTORIC SITES 0 0 0 0 0 0 0 0 18. FOREIGN TRADE ZONE 0 0 0 0 0 0 0 0 19. NET TAXABLE VALUE OF ALL FROZEN ACCTS 136,925,223 2,074 ACCTS 20. CAP LOSS ON RESIDENTIAL MARKET VALUES 2,262,610 426 ACCTS CERTIFIED APPRAISED VALUE PROTESTED APPRAISED VALUE INCOMPLETE APPRAISED VALUE ABSOLUTE EXEMPT VALUE TOTAL APPRAISED VALUE CERTIFIED NET TAXABLE VALUE NET TAXABLE IN ARB NET TAXABLE IN INCOMPLETE TOTAL NET TAXABLE VALUE 3,134,315,614 21,492,914 0 540,270,618 3,696,079,146 2,789,712,360 17,555.521 0 2,807,267,881 13,466 ACCTS 130 ACCTS 0 ACCTS 423 ACCTS 14,819 ACCTS TOT320BP-A TARRANT APPRAISAL DISTRICT PAGE 1 TOT3200 STATE USE CODE STATISTICS 2012 DATE: 05/10/2012 TDC: 025 CITY OF EULESS TIME: 08:12:29 CERT. APPR VALUE ARB VALUE INCOMPLETE VALUE AG VALUE AG NEW CONSTRUCTION ------------------------------ CATEGORY NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ----------------------------- ACREAGE NUMBER OF ACCTS ---------------- Al RESIDENTIAL SINGLE-FAMILY 1.446,647,512 17,744,744 0 0 0.0000 10,459,052 10,126 106 0 0 67 NET TAXABLE VALUE 1,149,773,341 14,292.876 0 A2 RESIDENTIAL MOBILE HOMES 2,110,102 0 0 0 0.0000 390 98 0 0 0 1 NET TAXABLE VALUE 1,493,682 0 0 A3 RESIDENTIAL CONDOMINIUMS 795.200 0 0 0 0.0000 0 16 0 0 0 0 NET TAXABLE VALUE 795,200 0 0 A4 RESIDENTIAL TOWNHOMES 21,833,564 0 0 0 0.0000 0 251 0 0 0 0 NET TAXABLE VALUE 18,258,678 0 0 A5 RESIDENTIAL UNDECLARED 24,554.900 277,700 0 0 0.0000 0 184 1 0 0 0 NET TAXABLE VALUE 20,623,100 222,160 0 A9 INTERIM USE 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 ----------------- ** CAT A TOTALS -------------------------------------- 1,495,941.278 ------------------- 18,022,444 ------------------- 0 ------------- 0 0.0000 10,459,442 10,675 107 0 0 68 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT A NET TAXABLE VALUE 1,190,944,001 14,515,036 0 B1 RESIDENTIAL MULTIFAMILY 622,550,518 0 0 0 0.0000 0 81 0 0 0 0 NET TAXABLE VALUE 607,448,931 0 0 B2 RESIDENTIAL DUPLEX 99.152,305 859,100 0 0 0.0000 16,663 1,106 10 0 0 1 NET TAXABLE VALUE 86,603,406 821,940 0 B3 RESIDENTIAL TRIPLEX 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 B4 RESIDENTIAL QUADRUPLEX 8,371,900 394,700 0 0 0.0000 0 49 2 0 0 0 NET TAXABLE VALUE 8,300,000 ------------------- 394.700 0 ------------------- ------------- ----------------- ** CAT B TOTALS ------------------- 730,074,723 ------------------- 1,253,800 0 0 0.0000 16,663 1,236 12 0 0 1 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT B NET TAXABLE VALUE 702,352,337 1.216,640 0 C1 VAC/PLATTED RES. LT 5 ACRES 1,648,568 233,400 0 235 1.7820 0 198 2 0 2 0 NET TAXABLE VALUE 1,604,095 233,400 0 C2 VAC/PLATTED COMMERCIAL 36,886,905 4,726 0 699 5.2920 0 234 1 0 1 0 NET TAXABLE VALUE 36,196,047 4,726 0 C3 VAC/UNPLATTED RURAL LT 5 ACRES 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 TOT320BP-A TARRANT APPRAISAL DISTRICT PAGE 2 TOT320J STATE USE CODE STATISTICS 2012 DATE: 05/10/2012 TDC: 025 CITY OF EULESS TIME: 08:12:29 CERT. APPR VALUE ARB VALUE INCOMPLETE VALUE AG VALUE AG NEW CONSTRUCTION ------------------------------ CATEGORY NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ----------------------------- ACREAGE NUMBER OF ACCTS ---------------- C6 VACANT EXEMPT -RIGHT OF WAY 118,365 0 0 0 0.0000 0 1 0 0 0 0 NET TAXABLE VALUE 3,243 0 0 ----------------- ** CAT C TOTALS -------------------------------------- 38,653,838 ------------------- 238,126 ------------------- 0 ------------- 934 7.0740 0 433 3 0 3 0 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT C NET TAXABLE VALUE 37,803,385 238,126 0 D1 ACREAGE RANCH LAND 3,263,103 0 0 4,158 50.2961 0 9 0 0 9 0 NET TAXABLE VALUE 4,158 0 0 D2 ACREAGE TIMBERLAND 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 D3 ACREAGE FARM LAND 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 D4 ACREAGE UNDEVELOPED 39.168,410 480,119 0 0 0.0000 0 36 1 0 0 0 NET TAXABLE VALUE 39,168,410 -------------------------------------- 480,119 0 ------------------- ------------- ----------------- ** CAT D TOTALS 42,431,513 ------------------- 480,119 0 4,158 50.2961 0 45 1 0 9 0 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT D NET TAXABLE VALUE 39,172,568 480,119 0 E1 FARM/RCH HOUSE + LTD ACRES 534,900 0 0 0 0.0000 0 2 0 0 0 0 NET TAXABLE VALUE 461,960 0 0 E2 FARM/RCH MH + LTD ACRES 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 E3 FARM/RCH OTHER 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 ** CAT E TOTALS -------------------------------------- 534,900 ------------------- 0. ------------------- 0 0 ------------- 0.0000 ----------------- 0 2 0 0 0 0 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT E NET TAXABLE VALUE 461,960 0 0 F1 COMMERCIAL 376,053,222 928,000 0 0 0.0000 3,556,613 444 2 0 0 6 NET TAXABLE VALUE 375,554,596 928,000 0 F2 INDUSTRIAL 8,714,527 0 0 0 0.0000 51,634 10 0 0 0 1 NET TAXABLE VALUE 8,714,527 0 0 F3 BILLBOARDS 68,198 0 0 0 0.0000 0 2 0 0 0 0 NET TAXABLE VALUE 68,198 0 0 TOT320BP-A TARRANT APPRAISAL DISTRICT PAGE 3 TOT320J STATE USE CODE STATISTICS 2012 DATE: 05/10/2012 TDC: 025 CITY OF EULESS TIME: 08:12:29 CATEGORY ------------------------------ CERT. APPR VALUE ARB VALUE INCOMPLETE VALUE AG VALUE AG NEW CONSTRUCTION NUMBER OF ACCTS NUMBER OF ACCTS NUMBER OF ACCTS NUMBER OF ACCTS ACREAGE NUMBER OF ACCTS ---------------- ------------------------------------------------ ------------- ---------------- ** CAT F TOTALS 384,835,947 928,000 0 0 0.0000 3,608,247 456 2 0 0 7 ** ----------------------- CAT F NET TAXABLE VALUE 7------------------------------------------------------------------------------------------------------------------------------ 384,337,321 928,000 0 G1 OIL, GAS, MINERAL RESERVE 12,690,700 0 0 0 0.0000 0 223 0 0 0 0 NET TAXABLE VALUE 12,690,700 ------------------- 0 0 ------------------- ------------- ----------------- ** CAT G TOTALS ------------------- 12,690.700 ------------------- 0 0 0 0.0000 0 223 0 0 0 0 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT G NET TAXABLE VALUE 12,690,700 0 0 J1 UTILITY WATER SYSTEMS 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 J2 UTILITY GAS COMPANIES 3,893,140 0 0 0 0.0000 0 1 0 0 0 0 NET TAXABLE VALUE 3,893,140 0 0 J3 UTILITY ELECTRIC COMPANIES 33,864,365 0 0 0 0.0000 0 12 0 0 0 0 NET TAXABLE VALUE 33,864,365 0 0 J4 UTILITY TELEPHONE COMPANIES 48,784,391 0 0 0 0.0000 881,575 51 0 0 0 2 NET TAXABLE VALUE 48,784,391 0 0 J5 UTILITY RAILROADS 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 J6 UTILITY PIPELINES 15,376,090 0 0 0 0.0000 0 11 0 0 0 0 NET TAXABLE VALUE 15,252,428 0 0 J7 UTILITY CABLE COMPANIES 3,624,203 0 0 0 0.0000 0 3 0 0 0 0 NET TAXABLE VALUE 3,624,203 0 0 J8 UTILITY OTHER 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 ------------- ----------------- ** CAT J TOTALS -------------------------------------- 105,542,189 ------------------- 0 ------------------- 0 0 0.0000 881,575 78 0 0 0 2 ** ---------------------------------------------------------------------------------------------------------------------------------------------I-------- CAT J NET TAXABLE VALUE 105,418,527 0 0 L1 COMMERCIAL 302,294,546 0 0 0 0.0000 0 997 0 0 0 0 NET TAXABLE VALUE 301,462,344 0 0 L2 INDUSTRIAL 14,815,380 0 0 0 0.0000 0 24 0 0 0 0 NET TAXABLE VALUE 8,611.817 0 0 TOT320BP-A TARRANT APPRAISAL DISTRICT PAGE 4 TOT320J STATE USE CODE STATISTICS 2012 DATE: 05/10/2012 TDC: 025 CITY OF EULESS TIME: 08:12:29 CERT. APPR VALUE ARB VALUE INCOMPLETE VALUE AG VALUE AG NEW CONSTRUCTION ------------------------------ CATEGORY NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ---------------- ------------- ACREAGE NUMBER OF ACCTS ---------------- ** CAT L TOTALS 317,109,926 0 0 0 0.0000 0 1,021 0 0 0 0 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT L NET TAXABLE VALUE 310,074.161 0 0 M1 PRIVATE WATERCRAFT 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 M2 PRIVATE AIRCRAFT 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 M3 MOBILE HOME IMPROVEMENT ONLY 236.200 0 0 0 0.0000 0 12 0 0 0 0 NET TAXABLE VALUE 193,000 0 0 M4 MISCELLANEOUS 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 ** CAT M TOTALS -------------------------------------- 236,200 ------------------- 0 ------------------- 0 0 ------------- 0.0000 ----------------- 0 12 0 0 0 0 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT M NET TAXABLE VALUE 193,000 0 0 Ni NOT OTHERWISE CLASSIFIED 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 ** CAT N TOTALS -------------------------------------- 0 ------------------- 0 ------------------- 0 0 ------------- 0.0000 ----------------- 0 0 0 0 0 0 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT N NET TAXABLE VALUE 0 0 0 01 RES VACANT INVENTORY Cl 3,045,840 177,600 0 0 0.0000 0 90 4 0 0 0 NET TAXABLE VALUE 3,045,840 177,600 0 02 RES IMPROVED INVENTORY 3,218,560 0 0 0 0.0000 1,525.100 17 0 0 0 11 NET TAXABLE VALUE 3,218,560 0 0 03 RES IMPROVED INVENTORY A3 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 04 RES IMPROVED INVENTORY A4 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 05 RES IMPROVED INVENTORY A5 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 06 RES IMPROVED INVENTORY B2 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 TOT320SP-A TARRANT APPRAISAL DISTRICT PAGE 5 TOT320J STATE USE CODE STATISTICS 2012 DATE: 05/10/2012 TDC: 025 CITY OF EULESS TIME: 08:12:29 CERT, APPR VALUE ARB VALUE INCOMPLETE VALUE AG VALUE AG NEW CONSTRUCTION ------------------------------ CATEGORY NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ---------------- NUMBER OF ACCTS ----------------------------- ACREAGE NUMBER OF ACCTS ---------------- 07 RES IMPROVED INVENTORY B3 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 . 08 RES IMPROVED INVENTORY B4 0 0 0 0 0.0000 0 0 0 0 0 0 NET TAXABLE VALUE 0 0 0 ----------------- ** CAT 0 TOTALS ------------------- ------------------- 6.264,400 ------------------- 177,600 ------------------- 0 ------------- 0 0.0000 1,525,100 107 4 0 0 11 ** ------------------------------------------------------------------------------------------------------------------------------------------------------ CAT 0 NET TAXABLE VALUE 6,264,400 177,600 0 ** TDC TOTALS -------------------------------------- 3,134,315,614 ------------------- 21,100,089 ------------------- 0 ------------- 5,092 57.3701 ----------------- 16,491,027 14.288 129 0 12 89 BEGIN CERT APPRAISED VALUE 3,674,586,232 BEGIN CERT APPRAISED ACCTS 14,689 ** TDC NET TAXABLE VALUE 2,789,712,360 17,555,521 0 5,092 +* TDC AG IMPROVEMENTS 0 NOTE: ABSOLUTE EXEMPTIONS ARE NOT INCLUDED EXCEPT FOR PRORATED ABSOLUTES 05/10/12 TARRANT APPRAISAL DISTRICT (TADBO60) JURISDICTION CITY OF EULESS AVERAGE MARKET VALUE PER ACCOUNT > 143,152 AVERAGE NET TAXABLE VALUE PER ACCOUNT > 113,714 TOTAL MARKET VALUE »»> 1,446,125,700 VALUE IN PARCEL ENTITY PLEASE NOTE: ACCOUNTS IN PROTEST & INCOMPLETE ACCOUNTS ARE THOUSANDS COUNT DISTRIBUTION GRAPHICS - N 0 T - INCLUDED IN ANY OF THE CALCULATIONS UND - 5 5 5 - 10 + 1 +* 10 - 15 0 15 - 20 2 20 - 25 6 �* 25 - 30 5 �* 30 - 35 14 �* 35 - 40 9 �* 40 - 45 34 �* 45 - 50 I 64 �* 50 - 55 51 �* 55 - 60 116** 60 - 65 165** 65 - 70 270*** 70 - 75 ( 231*** 75 - 80 252*** 80 - 85 350**** 85 - 90 I 363**** 90 - 95 356**** 95 - 100 338**** 100 - 105 333**** 105 - 110 317**** 110 - 115 300**** 115 - 120 280*** 120 - 125 412***** 125 - 130 327**** 130 - 135 341**** 135 - 140 425 (***** 140 - 145 380**** 145 - 150 381 (**** 150 - 155 402***** 155 - 160 339**** 160 - 165 275*** 165 - 170 331**** 170 - 175 315**** 175 - 180 190** 180 - 185 188** 185 - 190 185** 190 - 195 ( 169** 195 - 200 153** 200 - 205 142** 205 - 210 117** 210 - 215 90 �* 215 - 220 66 �* 220 - 225 71 �* 225 - 230 77 �* 230 - 235 81 �* 235 - 240 55 (* 240 - 245 80 �* OVR - 245 648******* 10,102****5****10***15***20***25***30***35***40***45***50***55***60***65***70***75***80 PARCEL COUNTS IN HUNDREDS - SINGLE FAMILY RESIDENCE ONLY - 2012 I NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE Budget Issues Work Sheet .a Please complete the questionnaire and return to us by July 9, 2012 Please fax to: 817-704-2543 or email to scecil@nctcog.org CITY: Grand Prairie CITY MANAGER: Tom Hart 1. Tax Rate: 2011/12: O&M 0.484892 I&S 0.185106 Total 0.669998 Anticipated 2012/13: O&M 0.484892 I&S 0.185106 Total 0.669998 2. Actual Tax Roll: 2011/12 $9,442,941,551 Anticipated FY 2012/13 (1%) decrease for $9,348,512,135 3. Sales Tax: next year projections (percentage up or down): ( 0.6%) down from 2011/12 Projected and 11 3% up from 2011/12 Approved Budget 4. Fee Increases: Proposed Fee Increases for 2012/13 — To Be Determined 5. Utility Rate Adjustments: Proposed increases for 2012/13 — To Be Determined 6. Health Insurance Cost Adjustments_: City Contributions increase of 18.6% in 2012/13 Employee/Retiree — To Be Determined 7. Salary Adjustments: • Civil Service: Annual Step (5% unless topped out) • Civil Service and Non Civil Merit — To Be Determined 8. Pension/TMRS Rate Change: 2011/12 Rate: 17.46/18.07% 2012/13 Rate: 18.07/17.97% 9. Other Comments NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE — JULY 12, 2012 Budget Issues Work Sheet Please complete the questionnaire and return to us by July 9th, 2012 Please fax to: 817-704-2543 (No cover sheet is needed) or email to: scecil(a-nctcog.org CITY: Town of Addison CITY MANAGER: Ron Whitehead 1. Tax Rate: 2011-2012: $0.5800 Anticipated 2012-2013: $0.5800 2. Actual Tax Roll: 2011-2012 $2,993,024,000 2012-2013 $3,028,043 3. Sales Tax: next year projections (percentage up or down) 2% increase 4. Fee Increases: Addison is not anticipating increasing existing fees, but will consider adopting a stormwater utility fee in November. 5. Utility Rate Adjustments: not anticipated at this time. 6. Health Insurance Cost Adjustments: The Town is anticipating a 10% increase in health insurance costs. 7. Salary Adjustments: merit/performance review across the board The Town is currently undergoing a comprehensive compensation study for all positions 8. Other Comments -- Such as: Pension/TMRS Revisons, etc. NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE - JULY 12, 2012 Budget Issues Work Sheet Please complete the questionnaire and return to us by July 9th 2012 Please fax to: 817-704-2543 (No cover sheet is needed) or email to: scecila-nctcog.org CITY: _The City of Richardson CITY MANAGER: Dan Johnson 1. Tax Rate: 2011-2012 _$0.63516 Anticipated 2012-2013 _$0.63516 (No Change)_ 2. 3. 4. 5. 6. 7. Actual Tax Roll: 2011-2012 _$9,762,481,127 2012-2013 Anticipating 0% growth_ Sales Tax: next year projections (percentage up or down) _1.7% increase from year-end estimate_ Fee Increases: All user fees under review, but no increases are anticipated at this time. Utility Rate Adjustments: Water and sewer rates are under review and will need to be adjusted in _ FY 2012-2013. The amount of the increase will be in the 5% -10% range. 9 Health Insurance Cost Adjustments: Not at this time.. uw "� _ — O2 L( (AkaA � 0 Salary Adjustments: merit/performance review _Now across the board _None 8. Other Comments -- Other than the possibility of increases to water and sewer rates likely balancing tactic will be through expenditure reductions and the use of rate stabilization reserves. 55 fix' Ups c NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE - JULY 12, 2012 Budget Issues Work Sheet Please complete the questionnaire and return to us by July 9th, 2012 Please fax to: 817-704-2543 (No cover sheet is needed) or email to: scecil .nctcog.org CITY: Carrol CITY MANAGER: Leonard Ma 1. Tax Rate: 2011-2012 _$0.617875 Anticipated 2012-2013 _$0.617875 2. Actual Tax Roll: 2011-2012 $8,863,273,150 2012-2013 _Projected at $8,917,259,444_ 3. Sales Tax: next year projections (percentage up or down) Up 2.5% 4. Fee Increases: Annual Solid Waste increase per vendor contract effective 10/1/12. Alarm Permit and False Alarm fee adjustments effective 10/1/12 already adopted. Irrigation water rate increase effective 11/1/12 already adopted. Possible changes in Ambulance fees and small changes in Athletics fees. 5. Utility Rate Adjustments: Irrigation water rate increase effective 11/1/12. 6. Health Insurance Cost Adiustments: Increase in employer and employee rates by 5.3% 7. Salary Adjustments: merit/performance review across the board 2% general pay plan adjustment another 1 % for targeted pay plan corrections. 8. Other Comments — Such as: Pension/TMRS Revisions, etc. Ie,Li Sr s K (� sk 5 t Q; c c -,rr� (YU_(6o' e �c 40a/t rL �' NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE - JULY 12, 2012 Budget Issues Work Sheet Please complete the questionnaire and return to us by July 9th 2012 Please fax to: 817-704-2543 (No cover sheet is needed) or email to: scecil()-nctcog.ora CITY: Colleyville, CITY MANAGER: Jennifer Fadden 1. Tax Rate: 2011-2012 _$0.3559 Anticipated 2012-2013 $0.3559 2. Actual Tax Roll: 2011-2012 _$3,730,446,941_ 2012-2013 $3,808,821,224 (Preliminary)_ 3. Sales Tax: next year projections (percentage up or down) actual sales tax revenue up 10.29% YTD 4. Fee Increases: None 5. Utility Rate Adjustments: Proposing to establish a tiered water rate structure. Current rate is $3.74 per 1,000 gallons. Proposed tiers would be $3.74 for 2,000 to 20,000, $4.30 for 20,001 to 30,000,_ $4.86 for 30,001 to 40,000, $5.42 for 40,001 to 50,000, $5.98 for over 50,000. Council votes on 8/21. 6. Health Insurance Cost Adjustments: Health Insurance rate decrease of 7.85% -Changing carriers_ from Aetna to Blue Cross and Blue Shield. 7. Salary Adjustments: merit/performance review across the board probably will propose 2%-3% 8. Other Comments — TMRS rate dropping from 7.38% to 7.18% 140�' Gil At," .E Fc�tcC NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE — JULY 12, 2012 Budget Issues Work Sheet Please complete the questionnaire and return to us by July 9th, 2012 Please fax to: 817-704-2543 (No cover sheet is needed) or email to: scecil(@-nctcoq.orq CITY: City of Dallas Texas CITY MANAGER: Mary Suhm 1. Tax Rate: 2011-2012: $0.797 / $100 Anticipated 2012-2013: $0.797 / $100 2. Actual Tax Roll: 2011-2012: $81.994 Billion Anticipated 2012-2013: Current planning for FY13 assumes that the FY13 tax roll will remain the same as FY12. 3. Sales Tax: next year projections (percentage up or down): FY13 projects a +1.7% increase above the FY12 year end estimate. 4. Fee Increases: Citywide fee adjustments for FY13 are still to be determined, however preliminary projections anticipate no increase in fees for sanitation residential services, landfill, and storm water. 5. Utility Rate Adjustments: Preliminary water utility rates for retail customers are projected to increase 5. 7%. 6. Health Insurance Cost Adjustments: - 4�r Preliminary health insurance costs are projected to increase between 5% & 8%. — < �c� 7. Salary Adiustments: merit/performance review: TBD Across the board: Preliminary plans are to restore all civilian pay cuts and discontinue furlough days implemented in previous budget years. Restorations would bring civilian employees back to FY10 budgeted pay levels. Police and Fire uniform personnel will receive a 3% cost of living adjustment as part of the 3fd and final year of meet & confer agreement. 8. Other Comments - Such as: Pension/TMRS Revisons, etc. In FY13, the City's civilian pension system contribution rate will increase. The City's obligation for the civilian plan will increase from 9.19% to 10.48% and the civilian employee's contribution portion will increase from 10.79% to 11.87%. No changes in uniform contributions are anticipated (the City currently contributes 27.5% to the uniform pension plan, while uniform employees contribute 8.5% to their plan). NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE - JULY 12, 2012 Budget Issues Work Sheet Please complete the questionnaire and return to us by July 9th 2012 Please fax to: 817-704-2543 (No cover sheet is needed) or email to: scecil(cDnctcog.or4 CITY: Farmers Branch CITY MANAGER: Gary D. Greer 1. Tax Rate: 2011-2012 .5295 Anticipated 2012-2013 .5295 2. Actual Tax Roll: 2011-2012 _$3.6 billion 2012-2013 $3.7 billion (est.)_ 3. Sales Tax: next year projections (percentage up or down) 4% Up 4. Fee Increases: None 5. Utility Rate Adjustments: 3% Water & Sewer Increase 6. Health Insurance Cost Adjustments: 5-10% 7. Salary Adjustments: merit/performance review 3% across the board 0% 3% structure adjustment for sworn police & fire 8. Other Comments — Implemented recommendations of Employee Retirement Benefits Committee — no changes to TMRS at this point but benchmarks established. C) (Do7 — I n ,�s — , �- FY '13 = "Year of Technology Improvements" — new website, new financial software system, new agenda management system, server virualization. NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE — JULY 12, 2012 Budget Issues Work Sheet Please complete the questionnaire and return to us by July 9th 2012 Please fax to: 817-704-2543 (No cover sheet is needed) or email to: scecil(a)nctcog.orci CITY: Fort Worth CITY MANAGER: Tom Higgins 1. Tax Rate: 2011-2012 .8550 Anticipated 2012-2013 .8550 Adjusted Actual Tan Roll 2. Actual Tax Roll: 2011-2012 $42.1B 2012-2013 $42.913 3. Sales Tax: next year projections (percentage up or down) 7% — 3c% _ ik" {(;U 4. Fee Increases: Nominal 5. Utility Rate Adjustments: None anticipated 6. Health Insurance Cost Adjustments: 8% increase 4b OPEA 7 0% across theboard 0% _ 7 1A A - r"L, /1 A %1)- n n . 8. Other Comments — Proposing to redu Pension Benefits NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE — JULY 12, 2012 Budget Issues Work Sheet Please complete the questionnaire and return to us by July 9th. 2012 Please fax to: 817-704-2543 (No cover sheet is needed) or email to: scecil(a)nctcoa.org CITY: Haltom City CITY MANAGER: Tom Muir 1. 2. 3. 4. 5. 6. 7. Tax Rate: 2011-2012 $0.65174 Actual Tax Roll: 2011-2012 $1,556,006,123 (net) Anticipated 2012-2013 $0.67174 2012-2013 $1, 581, 780, 000 (est. net) Sales Tax: next year projections (percentage up or down) up 4.8% from FY2012 projected. Fee Increases: Inspection Fee for multi -unit (new) : Fire Inspection fee increase: smaller inspection fees being considered. Utility Rate Adjustments: Sewer Increase 6% Sewer Surcharge 2% aggregate Health Insurance Cost Adjustments: Increase in City cost of 10.7%. Salary Adjustments: merit/performance review across the board 2.5%, effective January 1 2013 being considered 8. Other Comments -- Such as: Pension/TMRS Revisions, etc. Adding three Q) firefighters two (2) fire inspectors (part-time) a GIS Technician. a Fleet Services Worker, and convert apart -time Marshal to full-time NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE — JULY 12, 2012 Budget Issues Work Sheet Please complete the questionnaire and return to us by July 9th, 2012 Please fax to: 817-704-2543 (No cover sheet is needed) or email to: scecil(-nctcog.org CITY: City of Hurst CITY MANAGER: Allan Wee -gar 1. Tax Rate: 2011-2012 .578 Anticipated 2012-2013 .611 Q & S increase in response voter- approved bond issuance) bn Ce--aC'� 2. Actual Tax Roll: 2011-2012 $2.175 billion 2012-2013 $2.21 Billion Total Taxable July Certified 3. Sales Tax: next year projections (percentage up or down) + 3% 4. Fee Increases: Evaluating ambulance billing and other select user fees such as recreation/ athletics fees 5. Utility Rate Adiustments: Evaluating at this time— Impacted by 26% increase in pass- through sewer rates from Fort Worth 6. Health Insurance Cost Adjustments: None planned �v 7. Salary Adiustments: merit/performance review Across the board 2% and $M one- time for full-time employees CAA 8. Other Comments — Such as Pension/TMRS Revisons, etc. TMRS contributions will be lowered by 1 5% Hurst continued its COLA ad -hoc status at a 30% funding level The city's OPEB Trust Fund maintained its net asset position * Will add one full-time code enforcement officer *Overall budget will increase less than 1 % NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE — JULY 12, 2012 Budget Issues Work Sheet Please complete the questionnaire and return to us by July 9th, 2012 Please fax to: 817-704-2543 (No cover sheet is needed) or email to: scecil(cDnctcog.ora CITY: Lancaster, Texas CITY MANAGER: Opal Mauldin Robertson 1. Tax Rate: 2011-2012 .8675 Anticipated 2012-2013 .8675 2. Actual Tax Roll: 2011-2012 $1,497,549,787 2012-2013 $1,487,250,442 (preliminary) 3. Sales Tax: next year projections (percentage up or down) 3% increase 4. Fee Increases: n/a 5. Utility Rate Adjustments: sanitation - slight increase 6. Health Insurance Cost Adjustments: 19.6% increase 7. Salary Adjustments: merit/performance review 0% across the board 0% '\elu --,J nc-,z zC07 $1 000 one time all except Directors Civil Service Step increases (Police and Fire) Note: 2007 last salary adjustments for non -civil service employees 8. Other Comments -- Such as: Pension/TMRS Revisions, etc. 1-1-2012 13.70% 1-1-2013 14.31% NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE - JULY 12, 2012 Budget Issues Work Sheet Please complete the questionnaire and return to us by July 9th, 2012 Please fax to: 817-704-2543 (No cover sheet is needed) or email to: scecil()-nctcog.org CITY: Mansfield CITY MANAGER: Clayton W. Chandler, City Manager 1. Tax Rate: 2011-2012 710 Anticipated 2012-2013 710 2. Actual Tax Roll: 2011-2012 $4,396,696,698 2012-2013 $4,467,028,462 (as of 6/8/12) GY1� no 's"LAS A,P 3. Sales Tax: next year projections (percentage up or down) 5.48% T 4. Fee Increases: Ambulance fees/rates 5. Utility Rate Adjustments: Considering $4.25/month per customer ($867/yr) 6. Health Insurance Cost Adjustments: none 7. Salary Adjustments: merit/performance -across the board - 3% 8. Other Comments —Such as: Pension/TMRS Revisions, etc. 0 14.77% 4 15.01 % JrD NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE — JULY 12, 2012 Budget Issues Work Sheet Please complete the questionnaire and return to us by July 9th, 2012 Please fax to: 817-704-2543 (No cover sheet is needed) or email to: scecil(aD-nctcog.org CITY: Mesquite CITY MANAGER: Ted Barron 1. Tax Rate: 2011-2012 .64000 Anticipated 2012-2013 .64000 2. Actual Tax Roll: 2011-2012 $5,592,757,516 2012-2013 $5,437,560,930 3. Sales Tax: next year projections (percentage up or down) 0.75% ter-, .�-a -J (04 4. Fee Increases: Proposed $0.50 a week solid waste fee increase and some small fee increases in 6VO some Recreation programs 5. Utility Rate Adjustments: Water and sewer rates will escalate to cover NTMWD increases 7 A Health Insurance Cost Adjustments: No increases to active employee monthly premiums are --4-;..;..-4-A f— Onl 7_V2 0- ,.-.,-, _ L n G n r, nn A, n r, nn n i i 0 4 r1 Salary Adjustments: merittperformance review across the board NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE - JULY 12, 2012 Budget Issues Work Sheet Please complete the questionnaire and return to us by July 9th, 2012 Please fax to: 817-704-2543 (No cover sheet is needed) or email to: sceciVa)nctcoa.ora CITY: City of CITY MANAGER: Bruce Glasscock, 1. Tax Rate: 2011-2012 48.86_cents Anticipated 2012-2013 2. 3. amount. 4. 5. 6. 7. E1 Actual Tax Roll: 2011-2012 _$25.013 2012-2013 growth of $272M and existing property increase $182M or 0.73%. 48.86_cents, $25.513 includes new property Sales Tax: next year projections (percentage up or down) Under City Council imposed cap since 2008 to project Sales Tax at $57M was recently increased to $59M cap representing a 3.5% increase over budget Actual collections for FY 2011-12 could come in at $64M which includes an audit adjustment of $3.2M. Fee Increases: None planned Utility Rate Adjustments: 10% to 12% for water and 5% for sewer— both as a result of NTMWD rate Increases. None planned for Solid Waste. Will need Drainage increase in 2013-14. Health Insurance Cost Adjustments: None planned Salary Adjustments: merit/performance review 2% for civil service. across the board - 3% for non -civil service— Implementing several salary adjustments based on Compensation Plan study recently completed by staff. The adjustments will be implemented October 1, 2012 and include reclassifying positions based on external market conditions and implementing a step plan for labor and skilled workers. Other Comments — Such as: Pension/TMRS Revisions, etc. Required to increase OPEB contribution by $500K per year based on new actuarial study. NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE — JULY 12, 2012 Budget Issues Work Sheet Please complete the questionnaire and return to us by July 9th, 2012 Please fax to: 817-704-2543 (No cover sheet is needed) or email to: scecil(aD-nctcog.org CITY: CITY MANAGER: Tax Rate: 2011-2012 . &-7Tk Anticipated 2012-2013 a- AAS 2. Actual Tax Roll: 2011-2012 ;19 -7 t , 0Ag 2012-2013 '_, t1� �1�Q 3. Sales Tax: next year projections (percentage up or down) 61 � \('1 Ai Wu. 4. Fee Increases: TAA1iti6 6. Health Insurance Cost Adjustments: 5170 mUiW1j 7. Salary Adjustments: merit/performance review across the board 3 El Other Comments -- NORTH TEXAS CITY MANAGEMENT ASSOCIATION CITY MANAGERS' ADVISORY COMMITTEE — JULY 12, 2012 Budget Issues Work Sheet Please complete the questionnaire and return to us by July 9th, 2012 Please fax to: 817-704-2543 (No cover sheet is needed) or email to: scecil(aD_nctcoq.orq CITY: Of C�u le�z5 CITY MANAGER: �t (i i c j t,r,,' e 1. Tax Rate: 2011-2012 Anticipated 2012-2013 2. Actual Tax Roll: 2011-2012 �, 7 `/�/ 2012-2013 �D�2. �G/�a yI Ka s 3. Sales Tax: next year projections (percentage up or down) 4 5. 0 7 Fee Increases: Utility Rate Adjustments: 3A i)jr6 �C i o ct ey �L Health Insurance Cost Adjustments: Lcrrx i nr reriS< ey,zcL 0 Salary Adjustments: merit/performance review o across the board 8. Other Comments -- Such as: Pension/TMRS Revisons, etc. S-�7 -.Sas" + 54-fs COCA -t Lt SC - ; � -7Q �� i IC`��j� 04�at S'o �,-�cTtuS Acct. No. 2013 Baseline FY2011 FY2012 Actual Pct Budget Primary Vendors Other Vendors Budget Actual Pct.Budget Primary Vendors Other Vendors Budget Thru April 101-2013-515 1,000 1,000 886 88.6% Denitech 1,000 952 95.2% Denitech Lone Star Coffee (Repairs) 101-3024-521 6,000 6,000 4,344 72.4% Goddard Enterprises 6,000 812 13.5% Misc. Vendors 101-3046-521 10,704 10,286 7,453 72.5% Denitech Misc. Vendors 10,286 1,977 19.2% Denitech FITT Exercise Equip. Sam Houston Sam Houston 101-3048-521 95,431 80,083 83,260 104.0% Voice Products Datamax 80,083 90,135 112.6% Voice Products Datamax Business Imaging Systems Business Imaging Systems 101-3049-521 8,552 8,552 6,277 73.4% Electronic Facility Systems Documation N. Texas 8,5521 5,364 62.7%1 Electronic Facility Systems Documation N. Texas 101-4023-522 250 250 180 72.0% Mike's Auto Glassworks 2501 86 34.4% None 101-5016-519 21,427 21,427 15,108 70.5% None 21,427 8,668 40.5% None Overhead Door Lift Aids 101-5037-519 27,500 15,000 21,957 146.4% Overhead Door Brick Doctor 15,000 21,238 141.6% Atlantic Service & Supply Atlantic Service &Supply Affordable Afterhours Otis Elevator Loftin Equipment Co. 501-5076-519 6,170 6,170 10,556 171.1% IBM Corp. Technique Data Systems 6,170 7,349 119.1% None Misc. Vendors AMCAD & Graphics LP 504-5090-519 1,500 1,500 1,363 90.9% Ron Turley Associates 1,500 1,400 93.3% Ron Turley Associates Alliance Mechanical Services Club Prophet Systems 540-7060-550 8,000 8,000 4,163 52.0% Air Performance Inc. 8,000 9,214 115.2% Alliance Mechanical Services Automatic Sprinkler of Texas 540-7062-550 28,000 28,0001 23,701 84.6% Professional Turf Products Misc. 28,000 18,490 66.0% Professional Turf Products Misc. Metroplex Refrigeration Cozzini Brothers Advanced Hood Cleaning Cozzini Brothers Advanced Hood Cleaning 8,000 7,488 93.6% Southwaste Disposal LLC Shepherd Food Equipment 540-7067-550 11,000 5,600 10,685 190.8% Southwaste Disposal LLC Kimbrough Fire Ext. Kimbrough Fire Ext. Metroplex Refrigeration 540-7068-550 1,500 1,000 9341 93.4%1 None 1,500 0 0.0% 540-7069-550 2,000 700 01 0.0% N/A 2,000 101 5.1% 41-07 Marhinpry Maintpnanrp Acct. No. 2013 Baseline FY2011 FY2012 Actual Pct.Budget Primary Vendors Other Vendors Budget Actual Pct.Budget Primary Vendors Other Vendors Budget Thru April 101-3047-521 2,600 1,295 1,070 82.6% Documation Inc. 2,000 1,057 52.9% Documation Inc. 101-3049-521 7,858 7,858 6,876 87.5% Identix Inc. 7,858 7,116 90.6% Identix Inc. CDW Government 101-4041-522 500 225 25 11.1% None 500 179 35.8% None Absolute Ice Makers & Refrig. Affordable Afterhours Absolute Ice Makers & Refrig. Affordable Afterhours Specialty Underwriters Appliances Specialty Underwriters Appliances 101-5037-519 40,000 35,000 36,580 104.5% Ricoh Americas 35,000 14,114 40.3% Ricoh Americas Overhead Door Otis Elevator 101-7051-5S0 1000 1000 85 8.5% None 1,000 211 21.1%1 Denitech 101-7052-5S0 500 500 339 67.8% None 500 211 42.2% Denitech 101-7053-550 4,000 4,000 2,622 65.6% Smith Pump Co. 4,000 6 0.2% Sunbelt Pools 101-7057-550 6,500 6,500 617 9.5% None 6,500 103 1.6% 210-1052-550 2,500 2,500 0 0.0% None 2,500 0 0.0% 501-2070-515 5,250 4,650 4,562 98.1% ASI Business Solutions F Once Annually in June 4,6501 0 0.0% ASI Business Solutions E- Once Annually in June 501-8071-531 1,000 1,000 677 67.7% None 1,000 52 5.2% 501-8072-531 1,000 1,000 0 0.0% None 1,000 582 58.2% None CLS Sewer Equipment Co. CLS Sewer Equipment Co. 501-8073-531 2,000 2,000 4,446 222.3% Tex. Municipal Equipment LLC 2,000 2,869 143.5% Atlas Inspection Techs. Underground Inc. 504-5090-519 1,000 1,000 4,047 404.7% Matrix Lift & Air 1,000 0 0.0% Magnegrip South 520-7055-550 8,000 8,000 3,447 43.1% Service First In The Wind 8,000 1,568 19.6% Service First Commercial Equipment Co. 530-7050-550 10,000 15,000 8,679 57.9% Ed's Electric Tusa's Plumbing 15,000 3,819 25.5% Ed's Electric Sportable Scoreboards Absolute Ice Makers & Refrig. Tusa's Plumbing Absolute Ice Makers & Refrig. Absolute Ice Makers & Refrig. 550-7078-550 8,000 8,000 3,860 48.3% Automated Batting Cages 8,000 2,505 31.3% Automated Batting Cages Doyle Brown I I I Doyle Brown 101,708 2%58 ZZ 2 MY2 34 Z 34.2% AR-1R Annaratua Maintenanre Acct. No. 2013 Baseline FY2011 FY2012 Budget Actual Thru April Pct.Budget Primary Vendors Other Vendors Budget Actual Pct.Budget Primary Vendors Other Vendors 101-4041-522 4,000 4,000 3,353 83.8% CASCO Industries 5,000 4,496 89.9% CASCO Industries N. Texas Ladder Techs. 501-8066-531 250 250 0 0.0% N/A 250 0 0.0% N/A 501-8071-531 1,500 1,500 750 50.0% None 1,500 494 32.9% None 501-8072-531 500 500 21 4.2% N/A 500 989 197.8% Badger Meter Inc. 501-8073-531 500 500 0 0.0% N/A 500 221 44.2% UndergroundInc. 1501-8077-5311 10001 1000 01 0.0% N/A 1,000 0 0.0% N/A Z ! U24 512 & 5! UM IM City Benefit to Payroll Ratio Flower Mound 40.8% Colleyville 40% Keller 40% Hurst 35% Frisco 34.1 % Bedford 33.6% Coppell 30% Farmer's Branch 22.6% Euless 34.8% Grapevine NRH University Park Average 1 34.5% Southlake ?? MULTI -YEAR STREET OVERLAY PLAN May, 2012 Street overlay construction includes material and labor for subgrade repair, curb and gutter replacement (as needed), manhole and water valve adjustments, driveway approach repair (as needed) and other miscellaneous items associated with specific locations. The overlay list will be re-evaluated each year to determine if adjustments to the plan are warranted based on unexpected pavement failures and street reconstruction due to unanticipated water main replacements. FY 2012-13 Ridgecrest Drive — SH 183 to SH 10 S. Sheppard Drive — SH 183 to Ridgecrest Dr. Skyway Drive — Ridgecrest Dr. to SH 10 Fairlawn Court Windward Way — SH 183 to S. Sheppard Dr. W. Huitt Lane — S. Main to Martha Dr. Gaye Court Henslee Drive — Reaves Ct. to Cannon Dr. Henslee Drive — Hollywood Dr. to Sunset Dr. Jefflyn Court — Gaye Ct. to Cannon Dr. Reaves Court — Vine St. to cul-de-sac Cannon Drive — Jefflyn Ct. to Reaves Ct. Cannon Drive — Reaves Ct. to S. Pipeline Rd. Sunset Drive — S. Main to S. Pipeline Rd. FY 2013-14 Koen Lane — Huntington Dr. to East City Limits N. & S. Atkerson Lane — Huntington Dr. to Huntington Dr. Copher Court Dunaway Drive — E. Alexander Ln. to Ascot Dr. Amber Hill Ln. — Laurel Ln. to Springridge Ln. Springridge Ln. — Amber Hill to Nettle Ln. Lark Ln. — Amber Hill to Nettle Ln. Country Ln. — Amber Hill to Nettle Ln. Laurel Ln. — Amber Hill to Nettle Ln. Nettle Ln. — Laurel Ln. to Springridge Ln. Thistle Ct. Laurel Ct. Holly Ct. FY 2014-15 Westover Dr. — Baze to Underwood Westover Dr. — Lawndale to N. Main Buck Trail — Westover to Moss Hill Moss Hill — Buck Trail to Knoll Trail Underwood Ln. — Westover to Moss Hill Lawndale Ln. — Westover to Moss Hill Driskill Dr. — Westover to Moss Hill Knoll Trail — Westover to Canterbury Jenny Ln. Sprucewood Ln. Kayli Ln. FY 2015-16 Wooddale — North Main Street to Woodhollow Wildbriar — North Main Street to Woodhollow Pleasant Trail — Wildbriar to Wooddale Woodhollow — Wildbriar to Wooddale Tanglecrest Court Tangleridge Court Trail Lake Drive — Lakewood Blvd. to Bent Tree Bent Tree — Trail Lake Drive to Lakewood Blvd. Eden Trail — Trail Lake Drive to Bent Tree Overlake Court FY 2016-17 Rosemary — Almond to Sage Sandlewood — Rosemary to Almond Sage — Almond to Fuller -Wiser Almond — Cinnamon to Dead End Lemon — Almond to Nutmeg Nutmeg — North Main to 205 Nutmeg FY 2017-18 Commerce — Sagebrush to Marlene Debra — Mary to S.H. 10 Eastcliff —Dead end to Marlene Toplea — Wilshire to Eastcliff Eastcliff — Marlene to Kynette Windlea — Eastcliff to Wilshire Signet — Canyon Ridge to Westcliff Toplea — Westcliff to Canyon Ridge Northcliff — Canyon Ridge to Marlene T H E C I T Y O F EULESS Underwriting Analysis Policy Period: October 1, 2012 through September 30, 2013 CILIA CONSULTING GRoup,. INC. EMPLOYEE E -SEMI.-Pr 3525 N. Causeway Boulevard Suite 815 Metairie, LA 70002 Email Address: rina@tikia.nocoxmail.com T H E C I T Y Q F E U- "t LESS Experience Analysis for Renewal Period 10/01/12 - 09/30/13 Medical Claims Summary of Experience Recorded Adjusted Month Employees Claims Claims* Mar-11 365 $251,532 $251,532 Apr-11 364 $180,042 $180,042 May-11 364 $213,021 $213,021 Jun-11 364 $161,186 $160,766 Jul-11 364 $219,803 $219,536 Aug-11 362 $305,253 $305,237 Sep-11 366 $438,835 $305,595 Oct-11 363 $214,292 $214,292 Nov-11 360 $218,539 $218,436 Dec-11 361 $167,009 $167,009 Jan-12 360 $149,987 $149,043 Feb-12 360 $264,946 $264,894 Mar-12 362 $176,927 $176,690 Apr-12 363 $131,314 $131,314 May-12 370 $326,997 $326,997 Totals for Projection: 4,353 $2,775,087 $2,639,808 Claim Average Latest: 12 months 231,257 219,984 9 months 232,094 217,141 6 months 202,863 202,658 3 months 211,746 211,667 *Adjusted claims reflect claims net of specific reimbursements and/or ineligibles The above data reflects $133240.12 in claims over the specific deductible (net of Aggregating Specific of $110,000) T- x CW4;.UI"wW- Last Updated: 7/3/2012 at 2:32 PM T H E C 1 T Y O F EULESS Experience Analysis for Renewal Period 10/01/12 - 09/30/13 Medical Claims of Projected Claims ecorded Claims June 11-May 12 laims over $100,000 Specific Deductible/Ineligibles et Paid Claims verage Employees March 11-Feb 12 / verage Claims PEPY = [onthly Claims PEPM (Before Trend) -ojected Employees on October 1, 2012 x -ojected Renewal Period x -ejected Claims (Before Trend) _ Claims $2,775,087 $135,279 $2,639,808 363 $7,272 $606 373 12 71 Experience Period Jun- 11 thru May-12 Midpoint> Dec. 01,'11 Billing Period Oct-12 thru Sep-13 Midpoint > April 0 1, '13 Claims (A) Annual Trend Rate 9.50% (B) Number of Months Between Midpoints 16.0 (C) Projected Claims Before Trend 2,712,456 (D) Trend Adjustments (((1 + A) ^ (B / 12)) x C) - C Credibility 348,907 (E) Expected Claims (C + D) 100% $3,061,363 (F) Manual Annualized Claims 0% $0 (G) Total Adjusted Expected Annualized Claims 100% $3,061,363 ((E x .1.00) + (F x .00) =G (H) Demographic Change 1.020 ( I ) Expected Claims PEPY $8,371 (J) Margin (25%) $10,464 (K) Annualized Attachment $3,903,044 (L) Projected Specific Premiums (Trend 15%) $392,660 (M) Administrative Expenses/Overheads $452,884 (N) Total Fixed Cost $845,544 (0) Total Exposure $4,748,588 (P) Total Expected + Fixed Costs $3,967,979 (Q) Current Attachment $4,248,630 (R) New Attachment $3,903,044 (S) Increase/Decrease % in Attachment -8.13% (T) Current Fixed Cost $820,106 (U) Increase/Decrease % in Fixed Cost 3.10% TMK a C"0+4 Last Updated: 7/3/2012 at 2:32 PM T H E C I T Y O F EULESS Experience Analysis for Renewal Period 10/01/12 - 09/30/13 Prescription Drug Claims Summary of Experience Recorded Adjusted Month Employees Claims Claims* Mar-11 365 $40,488 $36,794 Apr-11 364 $43,717 $43,717 May-11 364 $43,099 $33,902 Jun-11 364 $44,683 $44,683 Jul-11 364 $44,490 $41,168 Aug-11 362 $43,960 $37,670 Sep-11 366 $53,891 $53,891 Oct-11 363 $50,638 $43,763 Nov-11 360 $54,998 $54,998 Dec-11 361 $49,191 $49,191 Jan-12 360 $49,231 $42,381 Feb-12 360 $50,025 $50,025 Mar-12 362 $53,327 $53,327 Apr-12 363 $54,717 $54,717 May-12 370 $56,540 $50,515 Totals for Projection: 4,349 $605,692 $576,330 Claim Average Latest: 12 months 50,474 48,027 9 months 52,506 50,312 6 months 52,172 50,026 3 months 54,862 52,853 *Adjusted claims reflect claims net of Rx rebates >a �NW4 i,�awFo, rne� Last Updated: 7/3/2012 at 2:32 PM T H E C I T Y O F EULESS Experience Analysis for Renewal Period 10/01/12 - 09/30/13 Prescription Drug Claims of Projected Claims ecorded Claims June 11-May 12 x Rebates et Paid Claims verage Employees May I I - April 12 verage Claims PEPY [onthly Claims PEPM (Before Trend) -ojected Employees on October 1, 2012 -ejected Renewal Period -ejected Claims (Before Trend) Claims $605,692 $29,362 $576,330 / 362 $1,592 $133 x 373 x 12 $595,308 Experience Period Jun- 11 thru May-12 Midpoint> Dec. 01,'11 Billing Period Oct-12 thru Sep-13 Midpoint> April 01,'13 Claims (A) Annual Trend Rate 9.50% (B) Number of Months Between Midpoints 16.0 (C) Projected Claims Before Trend 595,308 (D) Trend Adjustments (((I + A) " (B / 12)) x C) - C Credibility 76,575 (E) Expected Claims (C + D) 100% $671,883 (F) Manual Annualized Claims 0% $0 (G) Total Adjusted Expected Annualized Claims 100% $671,883 ((E x .1.00) + (F x .00) =G (H) Demographic Change 1.020 (I) Expected Claims PEPY $1,837 (J) Margin (25%) $2,296 (K) Annualized Attachment $856,510.58 (L) Administrative Expenses/Overheads $40,558 (M) Total Exposure $897,069 (N) Total Expected + Fixed Costs $725,766.46 IITOTAL ATTACHMENT (Medical/Rx) $4,759,555 II Increase/Decrease % 12.03% Last Updated: 7/3/2012 at 2:32 PM T H E C 1 T Y O F EULESS Experience Analysis for Renewal Period 10/01/12 - 09/30/13 Dental Claims Summary of Experience Recorded Adjusted Month Employees Claims Claims Mar-11 365 $11,936 $11,936 Apr-11 364 $10,137 $10,13 7 May-11 364 $13,499 $13,499 Jun-11 364 $7,809 $7,809 Jul-11 364 $12,598 $12,598 Aug-11 362 $15,123 $15,123 Sep-11 366 $11,179 $11,179 Oct-11 363 $22,083 $22,083 Nov-11 360 $17,576 $17,576 Dec-11 361 $13,525 $13,525 Jan-12 360 $15,114 $15,114 Feb-12 360 $11,743 $11,743 Mar-12 362 $12,930 $12,930 Apr-12 358 $17,165 $17,165 May- 12 370 $17,949 $17,949 Totals for Projection: 4,350 $174,794 $174,794 Claim Average Latest: 12 months 14,566 14,566 9 months 15,474 15,474 6 months 14,738 14,738 3 months 16,015 16,015 Last Updated: 7/3/2012 at 2:32 PM T H E C I T Y O F EULESS Experience Analysis for Renewal Period 10/01/12 - 09/30/13 Dental Claims of Projected Claims ecorded Claims June 11-May 12 verage Employees April 11 - March 11 / verage Claims PEPY = [onthly Claims PEPM (Before Trend) -ojected Employees on October 1, 2012 x -ojected Renewal Period x -ojected Claims (Before Trend) _ Claims $174,794 363 $482 $40 368 12 $176,640 Experience Period Jun- 11 thru May-12 Midpoint > Dec. 01, '11 Billing Period Oct-12 thru Sep-13 Midpoint> April. 01,'13 (A) Annual Trend Rate (B) Number of Months Between Midpoints (C) Projected Claims Before Trend (D) Trend Adjustments (((1 + A) ^ (B / 12)) x C) - C (E) Expected Claims (C + D) (F) Demographic Change (G) Total Adjusted Expected Annualized Claims ((E x .1.00) + (F x .00) =G (H) Expected Claims PEPY (I) Administrative Expenses/Overheads (J) Total Expected + Fixed Costs Claims 9.00% 16.0 176,640 Credibility 21,509 100% $198,149 1.020 100% $202,112 $549 $13,425 $215,537 . K,�tMia. iwc Last Updated: 7/3/2012 at 2:32 PM T H E C 1 T Y O F EULESS Experience Analysis for Renewal Period 10/01/12 - 09/30/13 Medical/Rx $4,693,745.68 Total Exposure 670 Number of Partici ants Conventional Rates Current New TOTAL New Enrollment Conventional Conventional COBRA OPEB Conventional Lives Rates w/o OPEB Rates w/o OPEB Rates Rates Rates w/OPEB 10/01/11 - 09/30/12 10/01/12 - 09/30/13 10/01/12 - 09/30/13 10/01/12 - 09/30/13 10/01/12 - 09/30/13 Medical/Rx Employee 168 $ 568.43 $ 584.06 $ 595.74 $ 102.25 $ 686.31 Employee + Spouse 53 2.30 $ 1,307.40 $ 1,343.34 $ 1,370.21 $ 102.25 $ 1,445.59 Employee + Child(ren) 61 1.90 $ 1,080.02 $ 1,109.72 $ 1,131.91 $ 102.25 $ 1,211.97 Employee + Family 91 2.90 $ 1,648.45 $ 1,693.78 $ 1,727.65 $ 102.25 $ 1,796.03 Total Enrollment 373 $ 4,568,143 $ 4,693,746 S 4,787,62 S$ 400,0 22 $ 5,093,748 Increas&Decrease % 2.75% Contributions Employee 168 $ 125.05 $ 134.33 Employee + Spouse 53 $ 326.85 $ 335.83 Employee + Child(ren) 61 $ 270.01 $ 277.43 Employee + Family 91 $ 412.11 $ 423.44 Total Enrollment 373 $ 1,107,657 $ 1,149,887 of Employee Contributions 24.25% 24.50% I j4.r,Cw�.wn., ',i, Geewr, twc Last Updated: 7/3/2012 at 2:32 PM T H E C I T Y O F EULESS Experience Analysis for Renewal Period 10/01/12 - 09/30/13 Dental $2151536.98 Total Exposure 653 Number of Participants Rates Current Enrollment Conventional Lives Rates 10/01/11 - 09/30/12 Dental New Conventional COBRA Rates Rates 10/01/12 - 09/30/13 Employee 169 $ 23.61 $ 27.51 Employee + Spouse 62 $ 54.30 $ 63.27 Employee + Child(ren) 56 $ 44.86 $ 52.27 Employee + Family 81 $ 68.46 $ 79.78 Total Enrollment 368 $ 184,969 s 215,537 IncreaselDecrease % 16.53% Contributions Employee 169 $ 5.19 $ 6.88 Employee + Spouse 62 $ 13.58 $ 15.82 Employee + Child(ren) 56 $ 11.22 $ 13.07 Employee + Family 81 $ 17.12 $ 19.94 Total Enrollment 368 $ 44,806 $53,884 of Employee Contribution 24.22% 25.00% 10/01/12 - 09/30/13 $ 28.06 $ 64.54 $ 53.31 $ 81.38 $ 219,848 TIK A C U*%ftuL * Mir- Last Updated: 7/3/2012 at 2:32 PM The City of Euless Experience Analysis for Renewal Period 10/01/12 - 09/30/13 Medical/Rx $400,000.00 Total Exposure 326 Number of Participants Conventional Rates OPEB OPEB Enrollment Conventional Lives Rates 10/01/12 - 09/30/13 Medical/Rx Employee 144 $102.25 Employee + Spouse 38 $102.25 Employee + Child(ren; 59 $102.25 Employee + Family 85 $102.25 Total Enrollment 326 $400,000 Medical/Rx New Employee Contributions Employee 144 $25.56 Employee + Spouse 38 $25.56 Employee + Child(ren; 59 $25.56 Employee + Family 85 $25.56 326 $100,000 Employee Contribution % 25.00% Retiree Lives Medical Dental Employee 24 Employee + Spouse 15 Employee + Child(ren; 2 Employee + Family 6 47 2011-2012 2012-2013 LTD & STD Budgeted Budgeted Employees Employees Basis Life Short Term Disability Long Term Disability Accidential Death Total 374 374 Employer Portion (100% GTL - 25% LTD & STD) Employee Portion (25% of LTD & STD) Total 2011-2012 2011-2012 2011-2012 2012-2013 2012-2013 2012-2013 Total Employer Employee Total Employer Employee Portion Portion Portion Portion $68,960.00 $68,960.00 $0.00 $65,739.00 $65,739.00 $0.00 $45,999.00 $34,499.25 $11,499.75 $36,142.00 $27,106.50 $9,035.50 $50,686.00 $38.014.50 $12,671.50 $50,686.00 $38,014.50 $12,671.50 $7,400.00 $5,550.00 $1,850.00 $7,400.00 $5,550.00 $1.850.00 $173,045.00 $147,023.75 $26,021.25 $159,967.00 $136,410.00 $23,557.00 $15.37 $15.37 $0.00 $14.65 $14.65 $0.00 $23.19 $17.39 $5.80 $21.00 $15.75 $5.25 $38.56 $32.76 $5.80 $35.64 $30.39 $5.25 City of Euless Total Rates and Employee Contributions 2012 - 2013 Totalx osure $4 I697 745.68 # of P-ei nts 670 Portion Conventional Rates 10/01/2011 -09/30/2012 Medical Dental Medical Dental Coverage Tier Enrollment Enrollment Enrollment Enrollment CURRENT Medical CURRENT Dental Total Med & Den[al 2011-2012 2011-2012 2012-2013 2012-2013 Rates w/o OPEB Rates OPEB GTD/LTD/STD Rate w/ OPEB & (Retiree Rate) (Retiree Rate) LTD/STD Em to ee 161 164 168 169 $ 568,43 $ 2361 $102.88 $38.56 $ 733.48 Em to ee + S ouse 56 61 53 62 1,307.40 $ 54.30 102.88 $38.56 $ 1 503.14 Employee + Children 59 51 61 56 1.080.02 $ 44.88 102.88 3&56 $ 1 266.32 Em to ee+Famil 88 83 91 81 1648.45 $ 68A6 $102.88 $38.56 1 858.35 Total Enrollment 1 364 1 359 773 368 1 $ 4,482,197 $ 181,853 1 $400 000 1 $173 045 1 $ 5 237 094 MEDICAL INCREASE / DECREASE % 4.72% Pnrtinn Cnnventinnal Rates 10/0112012-0913012013 _ NEW Medical Mad & Dc I Rates OPEB Rates LTD/STD Total Medical Dental Rates [Total Rate w/o OPEB Rates wl OPES (Retiree Rate) .lop REB etiree Rata 584.08 $102.25 $35.64 $686.31 $27.51 $713.82 _ 1343.34 $102.25 _ $35.64 $1445.59 $63.27 $1,508.86 1109.72 $102.25 $35.64 $1,211.96 $52.27 $1,264.23 1 693.78 102.25 35.64 1 796 03 79.78 $1 875.81 $4,693,746 1 $400 000 1 $159 967 1 $6 093 746 1 $215 537 $5 309,283 Coverage Tier Medical Enrollment 2011-2012 Dental Enrollment 2011-2012 Medical Enrollment 2012.2013 Dental Enrollment 2012.2013 10/01/2011 - 09/30/2012 10/01/2012 - 09/3012013 Current EE Medical Contribs Cutreat EE Dental Contnbs EE OPEB Contribs LTDBTD Contribution Total Employee Contribution EE Medical Contributions OPEB Medical Contribution L7D/STD Total Medical Contribution Total Dental Rate Total EE Contribution w/OPEB Em to ee 161 164 168 169 $125.05 $5.19 $25.72 $6.00 $161.97 $134.33 5.56 5 2_ $159.90 $6.88 $166.77 toee + Spouse $.00 $372.15 5 $525 $361.40 $15.82 $377.22$23Em + Children 59 51 61 56 $270.01 $11.22 $25.72 . $31294 _.- $27743 525 _ $5.25 $302.98 $13.07 $316.08Employee Employee + Family88 83 91 81 12.11 $17.12 $460.95 . $42344 $2556 $449.01 $19.94 68.95 a Total Enrollment 3" 359 1 373 1 388 1 $1 087 607 1 YA,069 $100 000 1 $26 928 $1,258.60t__JL $1 149 887 1 $100 000 $23 557 -1,149,R97 1 - 884 $1 303 771 Vision Rates Covere a Tier Premium Employee $7.87 Em to ee + spouse $15.29 Employee + Children $12.87 EMIDIOee + Famil $21.60 Euless Fire Department 2012 Salary Survey Euless Fire Department 2012 Salary Survey Operational Monthly Salaries Rank Bedford Hurst Grapevine Colleyville NRH Lewisville Avg. Salary Euless Avg -Euless Firefighter Entry Level $3,761.50 $4,846.33 $4,270.11 $4,053.08 $4,020.00 $4,159.25 $4,185.05 $4,298.00 ($112.96) Top Salary $4,498.42 $5,307.25 $5,504.35 $4,986.75 $5,290.00 $5,254.75 $5,140.25 $5,531.00 ($390.75) Years to Top out 3 1 5 9 7 5 5.00 5 0.00 Firefighter II Top Salary $4,550.00 N/A N/A N/A N/A N/A $4,550.00 $5,631.00 Driver/ Engineer Top Salary $4,950.58 $5,720.84 $6,493.93 N/A $5,785.00 $5,903.58 $5,770.79 $5,973.00 ($202.21) Lieutenant Top Salary $6,125.41 $6,503.25 $7,327.54 $6,732.41 $6,443.00 $7,156.17 $6,714.63 $6,896.00 ($181.37) Captain Top Salary N/A N/A N/A $7,541.73 N/A N/A $7,541.73 $7,259.00 $282.73 Battalion Chief Top Salary $7,070.00 $7,068.60 $8,268.50 $8,500.00 $7,338.00 $8,063.17 $7,718.05 F$7,692.00 $26.04 Page 1 of 4 Euless Fire Department 2012 Salary Survey Operational Salary Ranking Firefighter Entry Firefighter Top Driver Lt. BC 1 st $ 4,846.33 Hurst $5,531.00 Euless $ 6,493.93 Grapevine $ 7,327.54 Grapevine $ 8,500.00 Colleyville 2nd $ 4,298.00 Euless $5,504.35 Grapevine $ 5,973.00 Euless $ 7,156.17 Lewisville $ 8,268.50 Grapevine 3rd $ 4,270.11 Grapevine $5,307.25 Hurst $ 5,903.58 Lewisville $ 6,896.00 Euless $ 8,063.17 Lewisville 4rth $ 4,159.25 Lewisville $5,290.00 NRH $ 5,785.00 NRH $ 6,732.41 Colleyville $7,692.00 Euless 5th $ 4,053.08 Colleyville $5,254.75 Lewisville $ 5,720.84 Hurst $ 6,503.25 Hurst $7,338.00 NRH 6th 1 $ 4,020.00 NRH $4,986.75 Colleyville 1 $ 4,950.58 1 Bedford $ 6,443.00 NRH $ 7,070.00 Bedford Firefighter II Captain 1st $ 5,631.00 Euless $7,259.00 Euless 2nd $ 4,550.00 Bedford Page 2 of 4 Euless Fire Department 2012 Salary Survey Differential Pay Rank Salary Differential Firefighter Top Salary $5,531.00 Firefighter Il $100.00 Top Salary $5,631.00 Driver / Engineer $342.00 Top Salary $5,973.00 Lieutenant $923.00 Top Salary $6,896.00 Captain $363.00 Top Salary $7,259.00 Battalion Chief $433.00 Top Salary $7,692.00 Page 3 of 4 Euless Fire Department 2012 Salary Survey Inflation Table .. 2012 JAN 0.44% FEB 0.44% MAR 0.76% APR MAY JUN JUL AUG SEP OCT NOV DEC AVE 2011 0.48% 0.49% 0.98% 0.64% 0.47% -u 'i 1' 4; 0.09% 0.28% 0.15% -0.21% -0.08% -0.25% 2010 2.63% 2.14% 2.31 % 2.24% 2.02% 1.05% 1.24% 1.15% 1.14% 1.17% 1.14% 1.50% 1.64% 2009 0.03%1 0.24% -0.38% -0.74% -1.28% -1.43% -2.10% -1.48% -1.29% -0.18% 1.84%1 2.72% -0.34% 2008 4.28% 4.03% 3.98% 3.94% 4.18% 5.02% 5.60% 5.37% 4.94% 3.66% 1.07% 0.09% 3.85% 2007 2.08% 2.42% 2.78% 2.57% 2.69% 2.69% 2.36% 1.97% 2.76% 3.54% 4.31 % 4.08% 2.85% 2005 2.97% 3.01 % 3.15% 3.51 % 2.80% 2.53% 3.17% 3.64% 4.69% 4.35% 3.46% 3.42% 3.39% 2004 1.93% 1.69% 1.74% 2.29% 3.05% 3.27% 2.99% 2.65% 2.54% 3.19% 3.52% 3.26% 2.68% 2003 2.60% 2.98% 3.02% 2.22% 2.06% 2.11 % 2.11 % 2.16% 2.32% 2.04% 1.77% 1.88% 2.27% 2002 1.14% 1.14% 1.48% 1.64% 1.18% 1.07% 1.46% 1.80% 1.51 % 2.03% 2.20% 2.38% 1.59% 2001 3.73% 3.53% 2.92% 3.27% 3.62% 3.25% 2.72% 2.72% 2.65% 2.13% 1.90% 1.55% 2.83% 2000 2.74% 3.22% 3.76% 3.07% 3.19% 3.73% 3.66% 3.41 % 3.45% 3.45% 3.45% 3.39% 3.38% Information obtained from www.inflationdata.com Page 4 of 4 Police 2012 Police Records Clerk city Position Title Min Max Actual Lowest Paid Actual Highest Paid # in Position Grapevine Records Specialist 30,597 42,836 36,490 36,490 3 North Richland Hills Police Records Tech -Shift 31,128 46,080 33,011 33,011 1 Southlake Records Clerk Part Time 26,088 36,536 30,244 30,244 0.5 Keller Records Technician 28,912 40,643 39,478 39,478 1 Euless Police Records Clerk 30,692 39,147 30,692 35,221 4 Bedford Records Technician 32,115 44,963 32,115 35,316 3 Hurst Police Records Clerk 29,182 44,262 29,515 41,933 5 + 1 Colleyville Administrative Clerk 14 18 14 15 2 Police Records Supervisor City Position Title Min Max Actual Lowest Paid Actual Highest Paid #' in Position Hurst "Police Sergeant' 79,488 79,488 79,488 79,488 1 Keller Regional Commun Mgr 56,151 88,580 67,184 67,184 1 Grapevine Records Supervisor 42,988 60,183 vacant vacant vacamt North Richland Hills Police Records Sys Mgr 45,828 68,743 63,523 63,523 1 Bedford I Rec/Prop Supervisor 49,822 1 69,752 1 51,824 1 51,824 11 Euless Police Records Supervisor 42,206 54,501 48,436 48,436 1 Colleyville Office Assistant 44,091 59,652 48,000 1 Southlake Records Coordinator 36,169 50,641 44,658 44,658 1 supervises clerks, among other areas ** supervises both records and dispatch, *** supervises clerks and police computers Dispatcher city Position Title Min Max 'Actual Lowest Paid Actual Highest Paid # in Position' Euless Dispatcher 40,736 51,986 44,904 51,986 14 North Richland Hills Dispatcher 34,727 51,403 35,422 51,403 9 Grapevine Telecommunicator 35,389 49,544 35,389 50,035 14 Keller Dispatcher 34,819 47,570 34,819 47,568 16 Colleyville Vacant Bedford Dispatcher 37,182 52,052 37,182 40,751 11 Hurst Dispatcher (8) SR Disp (3) 36,691 58,573 37,107 43,410 8 + 3 Southlake Keller Dispatches Communications Supervisor city Position Title Min Max Actual Lowest Paid' Actual Highest Paid # in Position Keller Regional Commun Mgr 56,151 88,580 67,184 67,184 1 Grapevine Communications Supervisor 42,988 60,183 60,771 60,771 1 Euless Communications Supervisor 46,926 59,895 VACANT VACANT VACANT Bedford Communications Supervisor 49,822 69,752 55,780 55,780 1 North Richland Hills Communications Supervisor 451518 67,377 46,428 461428 1 Hurst Communications Supervisor 42,390 70,658 49,858 49,858 1 Colleyville Vacant Southlake Keller Dispatches Public Service Officer (Jailer) city Position Title Min Max Actual Lowest Paid Actual Highest Paid # in Position Euless Public Service Officer 35,628 45,462 37,410 45,461 14 Keller Detention Officer 32,843 44,907 33,176 40,310 6 Grapevine Jailer 33,727 47,219 33,727 45,645 5 North Richland Hills Dentention Officer 31,128 46,080 31,128 46,080 18 Bedford Detention Officer 33,720 47,212 33,720 1 35,527 13 Hurst Jailer (8) PSO (4) 30,888 49,171 31,304 38,792 8 + 4 Colleyville Vacant Southlake Keller Jail Police Officer (highest paid, non -competitively promoted) city Position Title Min Max Actual Lowest Paid' Actual Highest Paid # in Position Euless Police Officer 51,254 64,700 51,254 56,250 9 Bedford Police Officer II 49,418 66,343 51,644 65,561 41 Hurst Police Officer 59,700 65,376 59,700 65,376 47 North Richland Hills Police Officer 49,204 64,749 49,204 64,749 79 Grapevine Police Officer 51,241 66,052 51,241 66,052 40 Keller Police Officer 49,462 65,042 49,462 65,042 29 Colleyville Police Officer 48,610 65,767 48,610 61,769 27 Southlake Police Officer 50,778 66,241 50,778 66,241 28 Senior Police Officer / Police Corporal (highest paid, non -competitively promoted) City Position Title Min Max Actual Lowest Paid Actual Highest Paid # in Position Euless Sr. Police Officer/ Police Corpora 54,723 68,169 62,392 68,169 52 Bedford Detective/Corporal 52,250 73,153 56,680 69,238 13 Hurst See Below SR/CPL North Richland Hills Vacant Grapevine Sr. Police Officer 56,115 72,335 1 68,891 1 72,335 28 Keller Corporal 57,075 75,046 57,637 65,686 4 Colleyville School Resou Ofc Corporal 51,041 69,055 63,456 65,537 2 Southlake Police Corporal 60,977 74,977 60,977 74,977 6 Senior Police Corporal city Position Title Min Max Actual Lowest Paid Actual Highest Paid # in Position Euless Senior Police Corporal 58,605 71,875 71,875 71,875 8 Bedford Detective/Corporal 52,250 73,153 56,680 69,238 13 Hurst Corporal Comp promoted 69,909 69,909 69,909 69,909 13 North Richland Hills Vacant Grapevine Vacant Keller Corporal 57,075 75,046 57,637 65,686 4 Colleyville School Resou Ofc Corporal Southlake Police Corporal 60,977 74,977 60,977 74,977 6 Police Sergeant (competitively promoted) City Position Title Min Max Actual Lowest Paid Actual Highest Paid # in Position Euless Police Sergeant 67,226 79,876 75,876 79,876 5 Bedford Police Sergeant 66,689 93,363 66,689 77,768 6 Hurst Police Sergeant 79,498 79,498 79,498 79,498 8 North Richland Hills Police Sergeant 67,412 78,862 67,412 78,578 15 Grapevine Police Sergeant 71,619 83,737 75,952 83,737 15 Keller Police Sergeant 63,898 84,011 64,542 80,808 6 Colleyville Police Sergeant 59,086 79,940 60,278 64,754 3 Southlake Police Sergeant 69,757 83,298 69,757 83,298 8 Police Lieutenant City Position Title Min Max Actual Lowest Paid Actual ` : Highest Paid # in Position Euless Police Lieutenant 76,494 89,680 89,680 89,680 6 Bedford Police Lieutenant 81,061 113,487 81,061 84,971 5 Hurst Police Lieutenant 87,776 87,776 87,776 87,776 3 North Richland Hills Police Lieutenant 79,849 89,818 82,425 87,820 5 Grapevine Police Lieutenant 83,099 92,534 88,127 92,534 5 Keller Police Lieutenant 78,930 98,884 82,267 89,657 3 Colleyville Police Lieutenant 68,399 92,540 77,259 83,557 2 Southlake Police Lieutenant 79,585 95,026 79,585 92,269 2 Police Captain city Position Title Min Max Actual Lowest Paid Actual Highest Paid "# in Position Euless Police Captain 81,498 96,013 96,010 96,010 3 Bedford Vacant Hurst Vacant North Richland Hills 70,527 105,789 87,790 98,753 4 Grapevine Police Captain 95,627 106,483 106,483 106,483 3 Keller Vacant Colleyville Vacant Southlake Vacant Assistant Police Chief City Position Title Min Max Actual Lowest Paid Actual Highest Paid # in Position Euless Assistant Police Chief 109,462 109,462 109,462 109,462 1 Bedford Deputy Police Chief 98,531 137,945 99,131 99,313 2 Hurst Assistant Police Chief 98,904 98,904 98,904 98,904 2 North Richland Hills Assistant Police Chief 79,723 119,586 97,538 103,696 2 Grapevine Assistant Police Chief. 89,076 129,161 120,302 120,302 1 1 Keller Vacant Colleyville Vacant Southlake Deputy Police Chief 93,442 108,324 99,133 99,133 1 Pnlir_P Chief city Position Title' Min Max Actual Lowest Paid Actual Highest Paid # in Position Euless Police Chief 129,062 129,062 129,062 129,062 1 Bedford Police Chief 119,766 167,670 120,665 120,655 1 Hurst Chief of Police 80,268 12,792 125,008 125,008 1 North Richland Hills Director of Public Safety 107,071 160,608 150,846 150,846 1 Grapevine Police Chief 103,069 149,450 150,939 150,939 1 Keller Police Chief 86,413 130,483 130,483 130,483 1 Colleyville Police Chief 101,057 136,724 122,430 122,430 1 Southlake Police Chief 123,000 123,000 1 *full time equiv salary listed ""based on hourly as the position is p/t Dispatch Supv - 38999 - 54598 ttl of 3, one is currently vacant CITY OF EULESS: PROPOSED FLEET REPLACEMENTS FY2013 -- CURRENT -- UNIT # YEAR VEHICLE TYPE DEPT. VEHICLE / EQUIPMENT NOTES 288 1991 CHEVY C70 DUMP TRUCK PARKS TRANSFER UNIT #568 FROM PUBLIC WORKS 589 1998 KAWASAKI MULE PARKS 622 1999 CHEVY 3/4T PICKUP PARKS 642 2000 FORD 3/4T PICKUP PARKS TRANSFER UNIT #707 FROM FACILITY 764 2006 GRASSHOPPER DECK MOWER PARKS 765 2006 GRASSHOPPER DECK MOWER PARKS 568 1997 CHEVY C70 DUMP TRUCK PW - STREETS 10 YARD DUMP BODY 675 2001 CRAFCO CRACK SEALER PW - STREETS 603 1999 FORD 1/2T MID -SIZE PICKUP PW-METERS 619 1999 CHEVY 3/4T UTILITY TRUCK FACILITY SMALL UTILITY VAN 707 2003 FORD 34/T UTILITY TRUCK FACILITY SMALL UTILITY VAN 627 2000 FORD 1/2T MID -SIZE PICKUP PLANNING 639 2000 CHEVY 4DR SEDAN PD - CID 797 2006 FORD 1T / FRAZER MICU FD - MICU REMOUNT MICU TO NEW CHASSIS 695 2001 SCAT SPEED TRAILER PD - PATROL N/N POLICE PATROL UNIT PD - PATROL INCLUDES NEW VEHICLE EQUIPMENT N/N POLICE PATROL UNIT PD - PATROL INCLUDES NEW VEHICLE EQUIPMENT N/N POLICE PATROL UNIT PD - PATROL INCLUDES NEW VEHICLE EQUIPMENT N/N POLICE PATROL UNIT PD - PATROL INCLUDES NEW VEHICLE EQUIPMENT #1480 2009 GOLF CART FLEET TX STAR COURSE 171 2001 TORO WORKMAN HD UTILITY CART TX STAR MAINT. 172 2001 TORO WORKMAN HD UTILITY CART TX STAR MAINT. 193 2002 LELY SPREADER TX STAR MAINT. 232 2006 EZ-GO WORKHORSE TX STAR MAINT. 331 2007 EZ-GO WORKHORSE / BEVERAGE TX STAR MAINT. 704 2006 TORO MULIT-PRO 160 GAL SPRAYEF TX STAR MAINT. 709 2008 BUFFALO DEBRIS BLOWER TX STAR MAINT. 823 2006 TORO WORKMAN MD UTILITY CART TX STAR MAINT. 824 2006 TORO WORKMAN MD UTILITY CART TX STAR MAINT. 830 2006 TORO FLEX 21 GREENSMOWER TX STAR MAINT. 834 2006 TORO FLEX 21 GREENSMOWER TX STAR MAINT. 835 2006 TORO FLEX 21 GREENSMOWER TX STAR MAINT. 888 2007 EZ-GO WORKHORSE / BEVERAGE TX STAR MAINT. 898 2007 EZ-GO WORKHORSE TX STAR MAINT. 899 2006 EZ-GO LD UTILITY CART TX STAR MAINT. 984 2007 EZ-GO (6) PASSENGER SHUTTLE TX STAR MAINT. 985 2007 ,EZ-GO (4) PASSENGER SHUTTLE TX STAR MAINT. 20000731 1997 KUBOTA TRACTOR TX STAR MAINT. 20000732 1997 KUBOTA TRACTOR TX STAR MAINT. 20000756 1997 TYCROP HANDLER TX STAR MAINT. REPLACEMENT COST $ 9,500 $ 25,500 $ 15,500 $ 15,500 $ 74,000 $ 55,000 $ 16,800 $ 24,500 $ 24,500 $ 16,500 $ 20,500 $ 98,500 $ 18,224 $ 32,450 $ 32,450 $ 32,450 $ 32,450 $ 260,500 $ 21,000 $ 21,000 $ 4,500 $ 8,000 $ 22,000 $ 35,166 $ 8,500 $ 12,100 $ 12,100 $ 12,500 $ 12,500 $ 12,500 $ 12,000 $ 8,000 $ 12,500 $ 9,774 $ 7,500 $ 31,850 $ 31,850 $ 27,000 TOTAL REPLACEMENT DOLLARS: $ 1,127,164.00 PROJECTED VEHICLE REPLACEMENTS - CITY FLEET PAGE 1 FY2013 UNIT DEPT YEAR MAKE TYPE 1 FLEET 1999 FORD 1T/FLAT 2 FLEET 1999 PARIS TRAILER 4 FLEET 2001 FORD 3/4 T 5 FLEET 1995 CHAMPION TRAILER 100 PARKS 2002 TORO MOWER 307 PW 1992 INTERSTATE TRAILER 308 PARKS 1992 PARIS TRAILER 326 PW 1993 GMC DUMP 335 FIRE 1994 CHEVY 1T / GRASS 347 FLEET 1994 PARIS SANDER TRAILER 363 PW 1995 PARIS TRAILER 364 PW 1995 PARIS TRAILER 381 PW 1995 HAMM ROLLER 6" PARKS 4996 FORD 1 CT QUIP IICT 540 FLEET 1996 PARIS TRAILER 541 FLEET 1996 PARIS TRAILER 550 ADMIN 1997 FORD RANGER 653 FIRE 4897 FOR VAN 556 ADMIN 1997 KAWASAKI MULE I" PLW 4897 KUBOTA TRACHO€ 568 PW 1997 CHEVY DUMP 570 PW 1997 TOP LINE TRAILER 575 FACILITY 1998 US CARGO BOX TRAILER 581 FLEET 1998 TAILIFT FORK LIFT 582 PW 1998 PARIS TRAILER 600 PW 1999 GMC DUMP 601 PW 1999 GMC 2T / UTILITY 602 PW 1999 GMC DUMP 615 POLICE 1999 CHEVY 3/4 T 621 REC 1999 CHEVY 3/4T PICKUP 626 PARKS 2000 CASE TRENCHER 644 PARKS 2000 BIG JOHN TREE SPADE 645 POLICE 2000 FORD VAN 646 REC 2000 FORD VAN 653 REC 2000 FORD BUS MILES SRVS YRS 1ST YEAR REVISED 37,362 16 2015 DNR 16 2015 DNR 19,878 14 2015 2017 20 2015 DNR 13 2015 DNR 22 2014 2016 21 2013 2014 58,175 20 2013 2014 10 2004 DNR 20 2014 DNR 19 2014 2015 19 2014 2015 20 2015 64,644 20 2016 20 2016 DNR 51,914 15 2012 2014 36,608 15 2012 DNR 10 2007 2015 16 2013 2017 16 2013 2015 17 2015 DNR 20 2018 2020 15 2013 2015 56,192 16 2015 2016 27,727 16 2015 2017 40,582 16 2015 2017 151,148 15 2014 DNR 52,677 14 2013 2014 13 2013 2014 15 2015 2016 46,884 12 2012 2014 33,756 14 2014 2015 41,184 15 2015 2014 2015 2016 2017 2018 2019 $ 23,500 $ 25,000 $ 4,500 $ 74,000 $ 1,936 $ 1,936 $ 74,917 NO REPLACEMENT PASS DOWN T. FIR O.A.4- F.A. C-1 $ 1,212 $ 18,500 $ 41,62 CFA - NO REPLACEMENT $ 13,682 REPLACED IN PY2012 NO :NT 1INIT $ 74,000 $ 5,088 $ 3,483 $ 77,000 $ 71,000 $ 77,000 $ 24,500 $ 6,030 $ 39,724 $ 29,765 $ 31,000 $ 68,500 Vehicle retirements are based on years of usage and miles driven. Pricing is based on the most recent cost estimates. Vehicles may be retired sooner than listed or delayed until criteria is met. Base replacement costs will not reflect budgeted dollars. Units eligible for CNG conversion or purchase Units eligible for LPG conversion or purchase PAGE 2 UNIT DEPT YEAR MAKE TYPE MILES SRVS YRS 1ST YEAR REVISED I F 2014 2015 2016 2017 2018 2019 661 1 REC 2001 FORD VAN 662 FIRE 2001 FORD SPRT. UTILITY 667 FACILITY 2001 DELCO WASHER 668 PW 2001 TRAIL KING TRAILER 669 PARKS 2001 KUBOTA TRACTOR 670 FLEET 2001 FORD (BI-FUEL) 3/4 PICKUP 673 PARKS 2001 TORO MOWER 674 PW 2001 FORD 1.5T BUCKET 679 PARKS 2000 KAWASAKI MULE 687 FIRE 2002 IFORD SPRT. UTILITY 688 FIRE 2002 FORD SPRT. UTILITY 692 PARKS 2002 FORD 1T PICKUP 694 PW 2002 FORD 2T UTILITY 695 POLICE 2001 SCAT SPD TRAIL 697 PARKS 2002 FORD (BI-FUEL) 3/4 PICKUP 698 PW 2002 BELSHE HD TRAILER 7" PAR14S 2000 TORS MOWER 707 FACILITY 2003 FORD 3/4T UTILITY 708 FACILITY 2003 FORD 3/4T PICKUP 709 FIRE 2003 FORD 3/4T PICKUP 710 PW 2003 FORD 3/4T PICKUP 711 PW 2003 FORD 3/4T PICKUP 712 PW 2003 FORD 3/4T PICKUP 29,492 14 2015 40,946 12 2013 2015 12 2013 DNR 14 2015 2016 13 2014 2015 53,213 12 2013 2015 14 2015 33,661 12 2013 2015 13 2013 41,098 12 2014 2015 35,073 12 2014 2016 68,833 12 2014 2015 13,993 12 2014 2017 12 2013 2015 62,027 12 2014 15 2017 49,766 11 2014 2016 51,557 11 2014 2016 34,700 15 2018 2018 66,871 12 2015 79,184 12 2015 2014 53,502 12 2015 2016 $ 31,000 $ 29,000 $ 31,500 $ 34,500 $ 31,500 $ 19,000 $ 89,833 $ 10,781 $ 29,000 $ 41,098 $ 35,000 $ 74,000 $ 17,224 $ 28,500 $ 3,885 REPI AGED CV9010 NONE REPI ACEMENIT llnu'T' $ 37,530 $ 27,500 $ 28,000 $ 28,500 $ 31,500 $ 35,000 FF-P-AG-E-3-11 UNIT DEPT YEAR MAKE TYPE MILES SRVS YRS 1ST YEAR REVISED 2014 2015 2016 2017 2018 2019 713 FACILITY 2002 ALLMAN LIGHT TWR. 716 PARKS 2003 JOHN DEERE TRACTOR 722 PW 2004 FORD 3/4T PICKUP 724 PARKS 2004 FORD 3/4T PICKUP 726 PW 2004 INGERSOL COMPRESSOR 727 PW 2004 FORD 3/4T PICKUP 728 CID 2004 FORD 4DR SEDAN 729 CID 2004 FORD 4DR SEDAN 730 REC 2004 FORD 1/2T VAN 731 PD TAC 2004 FORD 3/4 TON VAN 734 PW 2004 GENERAL TRAILER 735 PW 2004 GENERAL TRAILER 736 POLICE 2004 IFORD 4DR SEDAN 738 PW 2004 NEW HOLLAND SKID STIR. 739 SBW 2004 MASSEY TRACTOR 745 FIRE 2005 FORD EXPED 748 PARKS 2005 NEW HOLLAND TRACTOR 749 PARKS 2005 NEW HOLLAND TRACTOR 750 CID 2005 FORD 4DR SEDAN 751 CID 2005 IFORD 4DR SEDAN 753 PARKS 2005 HUSQVARNA GRINDER 755 COURTS 2005 FORD 4DR SEDAN 757 PW 2006 FORD 3/4T PICKUP 758 PW 2006 FORD 3/4T PICKUP 759 PARKS 2006 FORD 3/4T PICKUP 760 PW 2006 FORD 3/4T PICKUP 761 PW 2006 FORD 3/4T PICKUP 762 PW 2006 CARGO TRAILER 771 PARKS 2005 CASE SKID STIR. 772 PARKS 2006 TYCROP SPREADER 774 FIRE 2006 FORD 1T PICKUP 12 2014 DNR 15 2018 78,314 12 2016 2014 75,469 12 2016 15 2019 74,223 12 2016 43,656 12 2016 60,348 12 2016 24,229 12 2016 24,300 12 2016 2017 15 2019 15 2019 25,241 12 2016 2017 15 2019 12 2016 38,574 12 2017 15 2020 15 2020 63,032 12 2017 2016 41,833 12 2017 10 2015 2016 47,806 10 2015 2016 61,776 12 2018 2017 74,075 11 2017 2016 38,177 12 2018 38,269 12 2018 59,302 12 2018 2017 15 2021 16 2021 12 2018 32,246 12 2018 $ 34,500 $ 29,000 $ 25,532 $ 17,504 $ 29,000 $ 20,313 $ 20,313 $ 31,500 $ 29,000 $ 5,535 $ 5,535 $ 19,466 $ 34,500 $ 10,802 $ 33,129 $ 20,273 $ 21,000 $ 35,034 $ 5,154 $ 32,238 $ 26,286 $ 29,500 $ 28,500 $ 29,500 $ 26,286 $ 28,286 $ 34,758 $ 66,224 FF PAGE 4 UNIT DEPT YEAR MAKE TYPE MILES SRVS YRS 1ST YEAR REVISED I F 2014 2015 2016 2017 2018 2019 775 CID 2006 FORD 4DR SEDAN 776 ENG 2006 FORD 1/2T PICKUP 777 PW 2006 FORD 1/2T PICKUP 779 PARKS 2006 BELSHE TRAILER 780 PARKS 2006 LOAD TRAIL TRAILER 781 PW 2006 GMC T DUMP 782 PARKS 2006 ROAD KING TRAILER 783 PARKS 2006 HARLEY SAND RAKE 784 PARKS 2007 1 LOAD TRAIL TRAILER 785 PARKS 2006 IBUFFALO BLOWER 786 PARKS 2006 ISUPREME TRAILER 788 REC 2007 ICARGO TRAILER 789 SBW 2006 TORO RAKE 799 CID 2007 FORD 4DR SEDAN 800 CID 2008 FORD 4DR SEDAN 801 CID 2008 FORD 4DR SEDAN 802 PD ADMIN 2008 FORD 4DR SEDAN 803 PD ADMIN, 2008 FORD 4DR SEDAN 804 PW 2008 FORD DUMP 805 PARKS 2007 FORD 1/2T PICKUP 807 FIRE 2007 FORD EXPED 811 DEVO 2008 FORD 1/2T PICKUP 812 DEVO 2008 FORD SUV HYBRID 813 ENG 2008 FORD 1/2T PICKUP 814 PARKS 2008 FORD 1T UTILITY 815 PARKS 2007 ROAD CLIPPER TRAILER 816 PARKS 2008 FORD 1T UTILITY 817 PARKS 2008 LOAD TRAIL TRAILER 818 PARKS 2007 LELY SPREADER 819 PW 2008 GMC T. DUMP 820 PD ADMIN 2007 FORD 4 DR SEDAN 821 FIRE 2008 CARGO TRAILER 1 1 • 1 1 • 1 • �� 1 1 72 22,000 21,500 20,867 22.000 $ 30,000 $ 30,000 $ 19,800 $ 4,888 $ 24,500 PAGE 5 UNIT DEPT YEAR MAKE TYPE I I MILES SRVS YRS 1ST YEAR REVISED I F-2014 2015 2016 2017 2018 2019 822 PW 2007 HUSQV CON. SAW 823 CODE 2007 FORD 1/2T PICKUP 824 CODE 2007 FORD 1/2T PICKUP 827 FIRE 2007 FORD MICU CHASSIS 827X FIRE 2002 FRAZER MICU BOX 833 CID 2008 FORD 4 DR SEDAN 836 PW 2008 IFORD 1T UTILITY 837 PARKS 2008 FORD 3/4T PICKUP 838 AC 2008 FORD 3/4T PICKUP 839 AC 2008 FORD 3/4T PICKUP 840 PW 2008 WARREN SANDER 841 CID 2008 FORD 4 DR SEDAN 843 PARKS 2008 JOHN DEERE TRACTOR 845 PD CERT 2006 PACE TRAILER 847 PW 2008 FORD 1/2T PICKUP 848 PW 2008 IFORD 1/2T PICKUP 849 PW 2008 FORD 1/2T PICKUP 850 PW 2008 FORD 1/2T PICKUP 851 PW 2008 FORD 1/2T PICKUP 852 FIRE 2009 FORD MICU CHASSIS 852X FIRE 2003 FRAZER MICU BOX 854 FIRE 2009 CHEVY SUV HHR 855 PW 2009 CHEVY 1T UTILITY 856 CODE 2009 TOYOTA 4DR HYBRID 857 CODE 2009 TOYOTA 4DR HYBRID 863 PD 2008 ICHEVY VAN 865 PARKS 2009 IBANDIT CHIPPER 872 PW 2011 IFORD 1/2 T 873 PW 2011 FORD 1/2 T 874 FACILITY 2011 FORD 1/2 T 15,695 $ 33,300 $ 66,600 $ 33 $ 67 42 42 PAGE 6 UNIT DEPT YEAR MAKE TYPE I MILES SRVS YRS 1ST YEAR REVISED 1 2015 2016 2017 2018 2019 876 CODE 2011 FORD 4DR SEDAN 885 PARKS 2011 JOHN DEERE GATOR 886 SBW 2011 KUBOTA MOWER 887 PARKS 2011 KUBOTA MOWER 888 PARKS 2011 KUBOTA UTILITY CART 889 PARKS 2011 KUBOTA UTILITY CART 890 PW 2011 IMONROE SM SANDER 891 PARKS 2011 MONROE SM SANDER 892 PD 2012 ICX SKYWATCH 893 PW 2012 MONROE HD SPREADER 894 PD 2012 CARRYON TRAILER 895 FIRE 2012 FORD AMB CHASSIS 895X FIRE FRAZER MICU BOX 896 CODE 2012 IFORD 1/2T PU 897 REC 2011 EZ GO CART 898 FIRE 2012 FORD 4DR SEDAN 899 PW 2012 RAMVAC VACUUM 900 PD 2006 CHEVY (BAIT) AVALANCHE ANNUAL FIGURE: PD SEDANS PD UTILITIES SUBTOTAL: 12 2023 12 2023 10 2021 10 2021 12 2023 12 2023 15 2026 15 2026 10 2022 10 2022 10 2022 DNR 7 2019 0 12 2024 10 2021 12 2024 10 2022 12 2018 DNR $ 53,900 $ 53,900 $ 68,000 $ 74,500 $ 75,625 $ 75,625 $ 82,500 $ 82,500 $ 82,500 $ 74,500 $ 75,625 $ 75,625 $ 82,500 $ 82,500 $ 82,500 $447,705 $696,349 1 $691,439 $643,552 $449,802 1 $349,974 PAGE 7 VEHICLE PURCHASES OVER $100,000.00 FUNDED BY VEHICLE DEPRECIATION UNIT DEPT YEAR MAKE TYPE FHOURS SRVS YRS 1ST YEAR REVISED I F 2014 2015 2016 2017 2018 2019 381 PW 1995 HAMM ROLLER 399 FIRE 1995 SUTPHEN PUMPER 583 FIRE 1998 QUALITY PUMPER 618 PW 1999 CASE BACKHOES 647 PW 2000 VACTOR SEWER JET 714 FIRE 2002 SUTPHEN 110+ TOWER 715 PW 2003 GRADALL GRADER 717 PARKS 2003 KOMATSU LOADER 746 FIRE 2004 FORD / NEFDA RESQ SQUAD 767 FIRE 2006 SUTPHEN 65+ QUINT 798 PW 2007 CASE BACKHOE 809 PARKS 2008 FORD 2T CHIPPER BX 828 FIRE 2008 SUTPHEN 65+ QUINT 842 FACILITY 2008 FORD 2.5T BUCKET 846 PW 2008 FORD SEWER JET 862 PW 2009 NORAM GRADER 866 PW 2010 CASE LOADER 867 PW 2010 FORD CAMERA CARRYOVER - DEFERRED PURCHASES -� 11 UNIT DEPT YEAR MAKE TYPE I FIRST YR. SRVS YRS DEFF. YRS. 282 PW 1990 CATERPILLAR ROLLER 304 PW 1992 11CATERPILLAR PAVER 355 FIRE 1994 ICHEVY GR. TRUCK 381 PW 1995 JHAMM ROLLER TOTAL: VEHICLE TOTAL: UNDER $100K OVER $100K CARRYOVER - DEFERREDPURCH. PROPOSED COSTS: 11• �� 1 1 ®© $ 74,917 $ 127,816 $ 230,000 PUMPER?? $ 700,000 $ 166,667 $ 130,000 ESTABLISH WHO DICTATES REPLACEMENT SCHEDULE $ 825,280 $ 942,374 2014 2015 2016 2017 2018 2019 ®$ 1,738,111 $ 1,301,905 $ 1,655,832 $ 946,357 $ 1,801,548