Loading...
HomeMy WebLinkAboutPreliminary (Binder Notes) Operating Budget FY19-20City of Euless, Texas Fiscal Year 2019-2020 Budget Cover Page This budget will raise more revenue from property taxes than last year's budget by an amount of $900,888, which is a 4.64 percent increase from last year's budget. The property tax revenue to be raised from new property added to the tax roll this year is $961,908. City of Euless : Misc. Equipment Transfer Budget Year 2019 - 2020 Department Name Account Code Transfer Overage/ Shortage Finance - Purchasing 101-5036-519 9601 $2,000 ($8,000) Police / Administration 101-3045-521 9601 $3,000 ($27,000) Police / Patrol 101-3046-521 9601 $116,250 ($258,500) Police / C.I.D. 101-3047-521 9601 $867 ($6,933) Police / Service 101-3048-521 9601 $8,950 ($4,200) Police / Detention 101-3049-521 9601 $4,618 ($37,764) Police / EOC 101-3024-521 9601 $15,567 ($76,333) Police / CCPD - Patrol 101-3046-521 9601 $87,617 ($161,117) Fire / Administration 101-4023-522 9601 $14,500 ($58,778) Fire / Safety & Training 101-4023-522 9601 $3,000 ($15,800) Fire / EMS 101-4041-522 9601 $2,375 ($7,125) Fire / Suppression 101-4041-522 9601 $39,532 ($228,366) Facility Maintenance 101-5037-519 9601 $28,633 ($256,620) Receation - Adm 101-7084-550 9601 $6,000 ($10,800) Recreation EFLAP 101-7051-550 9601 $108,225 ($612,150) Recreation - ELFC NAT 101-7052-550 9601 $6,425 ($38,550) Recreation - Splash 101-7052-550 9601 $6,706 ($96,083) Recreation - Sen Cntr 101-7052-550 9601 $29,879 ($197,021) Public Works - Yard Equip. 101-8033-531 9601 $19,557 ($155,229) Information Services 101-5016-519 9601 $17,714 ($67,143) Total General Fund: $521,414 ($2,323,512) Euless Development Corp Westpark 210-1052-550 9601 $5,433 ($119,533) Bob Eden 210-1052-550 9601 $3,642 ($97,408) VOBC 210-1052-550 9601 $6,500 ($84,500) Midway 210-1052-550 9601 $8,033 ($153,333) Heritage 210-1052-550 9601 $5,433 ($141,267) Trailwood 210-1052-550 9601 $4,680 ($107,640) Preserve 210-1052-550 9601 $13,714 ($191,998) McCormick 210-1052-550 9601 $5,200 ($93,600) Blessing Branch 210-1052-550 9601 $1,650 ($29,700) Total EDC $54,286 ($1,018,979) Fleet Services 504-5090-519 9601 $13,739 ($115,250) Special Rec Fund 520-7055-550 9601 $84,438 ($246,862) Texas Star Sports Complex 550-7078-550 9601 $19,462 ($330,699) Softball World 530-7050-550 9601 $8,027 ($48,720) $27,488 ($379,419) Texas Star / Golf Operations 540-7062-550 9601 $54,401 ($1,209,480) Texas Star / Conf. Center 540-7068-550 9601 $21,340 ($175,547) Texas Star / Grille Operations 540-7067-550 9601 $25,506 ($164,259) Texas Star Golf & Conference: $101,247 ($1,549,285) City Total; $802, 612 ($5, 633, 307) FACILITY MAINTENANCE Dept. 37 MISC. EQUIPMENT DEPRECIATION PURCHASE DEPT. EQUIPMENT YEAR ASSIGNED DESCRIPTION 2004 FACMAINT GENERATOR - FS #1 2018 FACMAINT GENERATOR - FS #2 2005 FACMAINT GENERATOR - FS #3 2017 FACMAINT GENERATOR - FIRE ADMIN 2011 FACMAINT GENERATOR - CITY HALL 2001 FACMAINT GENERATOR - PD / COURTS 2010 FACMAINT GENERATOR - EFLC 2019 FACMAINT GENERATOR - PW 2007 FACMAINT GENIE LIFT - SINGLE 2009 FACMAINT GENIE LIFT - SINGLE 2015 FACMAINT JLG LIFT - SINGLE 2012 FACMAINT TELEPHONE TEST EQUIP. Department Depreciation: @ 100% $28,633 Department Depreciation Collected LTD: $28,633 Department Fleet value: $513,000 Replacement Costs: $667,000 Average Asset Year: 2011 AS OF: 31-Jul-19 EST. REVISED REVISED ANNUAL FUND NET CAR (SHORTAGE) PURCH LIFE SELL SELL LIFE DEPR DEPRE. FUTURE BALANCE REPLACE RENTAL TOTAL / OVERAGE COST EXP YR YEAR EXP. TO DATE @ 100% DEPRE. @ REPLACE COST PORTION REP. COST @ PURCH $32,000 25 2029 $1,680 $1,680 $15,120 $16,800 $42,000 $42,000 ($25,200) $38,000 25 2043 $1,960 $1,960 $45,080 $47,040 $49,000 $49,000 ($1,960) $58,000 25 2030 $3,000 $3,000 $30,000 $33,000 $75,000 $75,000 ($42,000) $28,000 25 2042 $1,440 $1,440 $31,680 $33,120 $36,000 $36,000 ($2,880) $82,000 25 2036 $4,280 $4,280 $68,480 $72,760 $107,000 $107,000 ($34,240) $78,000 25 2026 $4,040 $4,040 $24,240 $28,280 $101,000 $101,000 ($72,720) $82,000 25 2035 $4,280 $4,280 $64,200 $68,480 $107,000 $107,000 ($38,520) $68,000 25 2044 $3,520 $3,520 $84,480 $88,000 $88,000 $88,000 $0 $15,000 15 2022 $1,333 $1,333 $2,667 $4,000 $20,000 $20,000 ($16,000) $15,000 15 2024 $1,333 $1,333 $5,333 $6,666 $20,000 $20,000 ($13,334) $10,000 15 2030 $867 $867 $8,667 $9,534 $13,000 $13,000 ($3,466) $7,000 10 2022 $900 $900 $1,800 $2,700 $9,000 $9,000 ($6,300) ($256,620) FD - SUPPRESSION Dept. 41 AS OF; 31-Jul-19 MISC. EQUIPMENT DEPRECIATION EST. ANNUAL FUND NET CAR (SHORTAGE) ASSET LOCATION EQUIPMENT PURCH UNIT TOTAL LIFE SELL DEPR DEPRE. FUTURE BALANCE REPLACE RENTAL TOTAL 1OVERAGE YEAR ASSIGNED DESCRIPTION COST EA. COUNT COST EXP YR TO DATE @ 100% DEPRE. @ REPLACE COST PORTION REP. COST @ PURCH 2017 ADMIN AUTO DEFIBULATORS $1,350 43 $58,050 10 2027 $7,500 $7,500 $52,500 $60,000 $75,000 $75,000 ($15,000) 2012 ADMIN TREADMILLS $6,000 2 $12,000 9 2021 $1,778 $1,778 $1,778 $3,556 $16,000 $16,000 ($12,444) 2013 ADMIN TREADMILLS $6,000 6 $36,000 9 2022 $5,222 $5,222 $10,444 $15,667 $47,000 $47,000 ($31,333) 2016 EMS ALS TRAINING MANNEQUIN $14,335 1 $14,335 8 2024 $2,375 $2,375 $9,500 $11,875 $19,000 $19,000 ($7,125) 2014 SUPP SCBA $4,685 36 $168,660 15 2029 $14,600 $14,600 $131,400 $146,000 $219,000 $219,000 ($73,000) 2014 SUPP RIT PACKS $4,100 4 $16,400 15 2029 $1,400 $1,400 $12,600 $14,000 $21,000 $21,000 ($7,000) 2005 SUPP THERMAL IMAGING UNIT $9,522 1 $9,522 16 2021 $750 $750 $750 $1,500 $12,000 $12,000 ($10,500) 2008 SUPP THERMAL IMAGING UNIT $9,522 2 $19,044 14 2022 $1,786 $1,786 $3,571 $5,357 $25.000 $25,000 ($19,643) 2009 SUPP THERMAL IMAGING UNIT $9,522 1 $9,522 14 2023 $857 $857 $2,571 $3,429 $12,000 $12,000 ($8,571) 2010 SUPP THERMAL IMAGING UNIT $9,522 2 $19,044 14 2024 $1,786 $1,786 $7,143 $8,929 $25,000 $25,000 ($16,071) 2014 SUPP THERMAL IMAGING UNIT $9,522 1 $9,522 7 2021 $1,714 $1,714 $1,714 $3,429 $12,000 $12,000 ($8,571) 2016 SUPP THERMAL IMAGING UNIT $9,522 1 $9,522 7 2023 $1,714 $1,714 $5,143 $6,857 $12,000 $12,000 ($5,143) 2018 SUPP THERMAL IMAGING UNIT $9,522 2 $19,044 7 2025 $3,571 $3,571 $17,857 $21,429 $25,000 $25,000 ($3,571) 2018 SUPP EXTRACTORSIWASHERS $15,000 2 $30,000 15 2033 $2,600 $2,600 $33,800 $36,400 $39,000 $39,000 ($2,600) 2004 SUPP HYDRAULIC TOOL SET $31,000 1 $31,000 17 2021 $2,353 $2,353 $2,353 $4,706 $40,000 $40,000 ($35,294) 2013 SUPP HYDRAULIC TOOL SET $31,000 1 $31,000 15 2028 $2,667 $2,667 $21,333 $24,000 $40,000 $40,000 ($16,000) 2013 SUPP SCBA COMPRESSOR $43,000 1 $43,000 15 2028 $3,733 $3,733 $29,867 $33,600 $56,000 $56,000 ($22,400) 2012 TRAIN CERT TRAILER $4,500 1 $4,500 15 2027 $400 $400 $2,800 $3,200 $6,000 $6,000 ($2,800) 2014 TRAIN BULLEX EXT. TRAINING SYST. $20,000 1 $20,000 10 2024 $2,600 $2,600 $10,400 $13,000 $26,000 $26,000 ($13,000) FD Total ($310,068) Depreciation - Administration $14,500 Admin ($58,778) Depreciation - Emergency Medical Srvs. $2,375 Train ($15,800) Depreciation - Suppression $39, 532 EMS ($7,125) Depreciation - Training $3,000 Suppr ($228,366) Depart. Depreciation Total: @ 100% $59,407 FINANCE - PURCHASING Dept. 36 AS OF. 31-Jul-19 MISC. EQUIPMENT DEPRECIATION EST. REVISED REVISED ANNUAL FUND NET CAR PURCHASE DEPT. EQUIPMENT PURCH LIFE SELL SELL LIFE DEPR DEPRE. FUTURE BALANCE REPLACE RENTAL TOTAL YEAR ASSIGNED DESCRIPTION COST EXP YR YEAR EXP. TO DATE @ 100% DEPRE. @ REPLACE COST PORTION REP. COST 2015 FINPURCH MAILING MACHINE $12,000 8 2023 $2,000 $2,000 $6,000 $8,000 $16,000 $16,000 Department Depreciation: @ 100% $2,000 Department Depreciation Collected LTD: $2,000 Department Fleet value: $12,000 Replacement Costs: $16,000 Average Asset Year: 2015 (SHORTAGE) 1 OVERAGE @ PURCH ($8,000) ($8,000) FLEET SERVICE Dept. 90 MISC. EQUIPMENT DEPRECIATION PURCHASE DEPT. EQUIPMENT YEAR ASSIGNED DESCRIPTION 2016 FLEET FLOOR CLEANING MACHINE 2016 FLEET EPDXY SHOP FLOOR 2017 FLEET HD DIAGNOSTIC COMPUTER 2015 FLEET SHOP AIR COMPRESSOR 1997 FLEET SHOP VEHICLE LIFTS 2008 FLEET TIRE MACHINE 2010 FLEET MILLER TIG WELDER 2010 FLEET MILLER MIG WELDER 2014 FLEET THERMAL DYNAMIC PLASMA 2010 FLEET OIL/LUBE DISPENSING EQUIP 2019 FLEET SUNNEX RADIANT HEATERS 2014 FLEET TPMS DEVICE Department Depreciation: @ 100% $13,739 Department Depreciation Collected LTD: $13,739 Department Fleet value: $173,500 Replacement Costs: $227,000 Average Asset Year: 2012 AS OF. 31-Jul-19 EST. REVISED REVISED ANNUAL FUND NET CAR (SHORTAGE) PORCH LIFE SELL SELL LIFE DEPR DEPRE. FUTURE BALANCE REPLACE RENTAL TOTAL /OVERAGE COST EXP YR YEAR EXP. TO DATE @ 100% DEPRE. @ REPLACE COST PORTION REP. COST @ PORCH $14,000 10 2026 $1,800 $1,800 $10,800 $12,600 $18,000 $18,000 ($5,400) $24,000 15 2031 $2,067 $2,067 $22,733 $24,800 $31,000 $31,000 ($6,200) $11,000 10 2027 $1,400 $1,400 $9,800 $11,200 $14,000 $14,000 ($2,800) $12,000 15 2030 $1,067 $1,067 $10,667 $11,733 $16,000 $16,000 ($4,267) $65,000 30 2027 $2,833 $2,833 $19,833 $22,667 $85,000 $85,000 ($62,333) $10,000 12 2020 $1,083 $1,083 $0 $1,083 $13,000 $13.000 ($11,917) $6,000 12 2022 $667 $667 $1,333 $2,000 $8,000 $8,000 ($6,000) $5,000 12 2022 $583 $583 $1,167 $1,750 $7,000 $7,000 ($5,250) $4,000 12 2026 $417 $417 $2,500 $2,917 $5,000 $5,000 ($2,083) $10,000 18 2028 $722 $722 $5,778 $6,500 $13,000 $13,000 ($6,500) $9,000 20 2039 $600 $600 $11,400 $12,000 $12,000 $12,000 $0 $3,500 10 2024 $500 $500 $2,000 $2,500 $5,000 $5,000 ($2,500) ($115,250) INFORMATION SERVICES MISC. EQUIPMENT DEPRECIATION ASSET LOCATION EQUIPMENT YEAR ASSIGNED DESCRIPTION 2015 IS Storage Area Network - IS 2016 IS Network Core Switch - IS Department Depreciation: @ 100% $17,714 Department Depreciation Collected LTD: $17,714 Department asset value: Replacement Costs: Average Asset Year: $95,000 $124,000 2016 EST. ANNUAL FUND PURCH LIFE SELL DEPR DEPRE. FUTURE BALANCE COST EXP YR TO DATE @ 100% DEPRE. u? REPLACE $75,000 7 2022 $14,000 $14,000 $28,000 $42,000 $20,000 7 2023 $3,714 $3,714 $11,143 $14,857 AS OF: 31-Jul-19 NET CAR (SHORTAGE) REPLACE RENTAL TOTAL IOVERAGE COST PORTION REP. COST @ PURCH $98,000 $98,000 ($56,000) $26,000 $26,000 ($11,143) $67,143 PARKS at TEXAS STAR Dept. 50 AS OF. 31-Jul-19 MISC. EQUIPMENT DEPRECIATION ASSET LOCATION YEAR ASSIGNED EST. EQUIPMENT PURCH LIFE SELL DEPR DESCRIPTION COST EXP YR TO DATE ANNUAL FUND NET CAR (SHORTAGE) DEPRE. FUTURE BALANCE REPLACE RENTAL TOTAL / OVERAGE @ 100% DEPRE. @ REPLACE COST PORTION REP. COST @ PURCH PATS SCOREBOARDS (x6) $108,000 25 2023 $5,600 $5,600 $16,800 $22,400 $140,000 $140,000 ($117,600) PATS ICE MACHINE (x3) $27,000 20 2023 $1,750 $1,750 $5,250 $7,000 $35,000 $35,000 ($28,000) PATS COOLERS (x6 Countertop) $9,600 10 2027 $1,200 $1,200 $8,400 $9,600 $12,000 $12,000 ($2,400) PATS COOLERS (x3 Stand-up units) $9,000 10 2027 $1,200 $1,200 $8,400 $9,600 $12,000 $12,000 ($2,400) PATS TUNNELS (x2) $16,000 15 2033 $1,400 $1,400 $18,200 $19,600 $21,000 $21,000 ($1,400) PATS PICNIC TABLES (x20) $22.000 22 2022 $1,318 $1,318 $2,636 $3,955 $29,000 $29,000 ($25,045) PATS PLAYGOUND $125,000 30 2027 $5,433 $5,433 $38,033 $43,467 $163,000 $163,000 ($119,533) PATS WATER FOUNTAINS (4) $30,000 25 2022 $1,560 $1,560 $3,120 $4,680 $39.000 $39,000 ($34,320) SBW SCOREBOARDS (x4) $72,000 15 2031 $6,267 $6,267 $68,933 $75,200 $94,000 $94,000 ($18,800) SBW ICE MACHINE $9,000 15 2023 $800 $800 $2,400 $3,200 $12,000 $12,000 ($8,800) SBW PICNIC TABLES (x17) $18,700 25 2022 $960 $960 $1,920 $2,880 $24,000 $24,000 ($21,120) Adm Vinyl Cutter $6,000 10 2022 $800 $800 $1,600 $2,400 $8,000 $8,000 ($5,600) Adm Christmas Tree $40,000 10 2028 $5,200 $5,200 $41,600 $46,800 $52,000 $52,000 ($5,200) EFLAP CONCESSION EQUIPMENT $20,000 10 2023 $2,600 $2,600 $7,800 $10,400 $26,000 $26,000 ($15,600) EFLAP SAND FILTERS $10,000 8 2021 $1,625 $1,625 $1,625 $3,250 $13,000 $13,000 ($9,750) EFLAP AQUATIC PLAY STRUCTURE $75,000 5 2019 $16,333 $16,333 -$16,333 $0 $98,000 $98,000 ($98,000) EFLAP SLIDES (x3) $500,000 10 2023 $65,000 $65,000 $195,000 $260,000 $650,000 $650,000 ($390,000) EFLAP GUARD STANDS (x8) $12,000 10 2023 $1,600 $1,600 $4,800 $6,400 $16,000 $16,000 ($9,600) EFLAP PA SYSTEM $6,700 10 2023 $900 $900 $2,700 $3,600 $9,000 $9,000 ($5,400) EFLAP VARIABLE FREQUENCY DRIVES $7,000 10 2023 $900 $900 $2,700 $3,600 $9,000 $9,000 ($5,400) EFLAP TOT WATER SLIDE $9,500 5 2021 $2,400 $2,400 $2,400 $4,800 $12,000 $12,000 ($7,200) EFLAP LILY PADS $8,000 5 2023 $2,000 $2,000 $6,000 $8,000 $10,000 $10,000 ($2,000) EFLAP SHADE FABRIC $15,000 6 2025 $3,333 $3,333 $16,667 $20,000 $20,000 $20,000 $0 EFLAP PUMPS (x8) $55,000 10 2023 $7,200 $7,200 $21,600 $28,800 $72,000 $72,000 ($43,200) EFLAP SAND FILTERS $50,000 15 2028 $4,333 $4,333 $34,667 $39,000 $65,000 $65,000 ($26,000) EFLCNAT POOL VACUUM $3,000 10 2023 $400 $400 $1,200 $1,600 $4,000 $4,000 ($2,400) EFLCNAT PATIO FURNITURE $7,000 8 2021 $1,125 $1,125 $1,125 $2,250 $9,000 $9,000 ($6,750) EFLCNAT SLIDE $30,000 10 2023 $3,900 $3,900 $11,700 $15,600 $39,000 $39,000 ($23,400) EFLCNAT EXHAUST FAN $7,500 10 2023 $1,000 $1,000 $3,000 $4,000 $10,000 $10,000 ($6,000) SPLASH THRILL & SPILL FEATURE $6,000 20 2024 $400 $400 $1,600 $2,000 $8,000 $8,000 ($6,000) SPLASH GROUND GEYSER $1,500 20 2024 $100 $100 $400 $500 $2,000 $2,000 ($1,500) SPLASH MINI WATER TUNNEL $2,500 20 2024 $150 $150 $600 $750 $3,000 $3,000 ($2,250) SPLASH BELL SPRAY COLUMN $3,500 20 2024 $250 $250 $1,000 $1,250 $5,000 $5,000 ($3,750) SPLASH GATEWAYARCH $5,500 20 2024 $350 $350 $1,400 $1,750 $7,000 $7,000 ($5,250) SPLASH MAGIC TOUCH BOLLARD $4,000 20 2024 $250 $250 $1,000 $1,250 $5,000 $5,000 ($3,750) SPLASH HOLDING TANK $18,000 20 2024 $1,150 $1,150 $4,600 $5,750 $23,000 $23,000 ($17,250) SPLASH PUMPS & FILTERS $35,000 18 2022 $2,556 $2,556 $5,111 $7,667 $46,000 $46,000 ($38,333) SPLASH UV SYSTEM $23,000 20 2027 $1,500 $1,500 $10,500 $12,000 $30,000 $30,000 ($18,000) EFLC - SC AUTOMATIC DOORS $45,000 12 2022 $4,917 $4,917 $9,833 $14,750 $59,000 $59,000 ($44,250) EFLC - SC TV MONITORS (x14) $7,000 12 2022 $750 $750 $1,500 $2,250 $9,000 $9,000 ($6,750) EFLC - SC AV SYSTEM $20,000 12 2022 $2,167 $2,167 $4,333 $6,500 $26,000 $26,000 ($19,500) EFLC - SC KITCHEN EQUIPMENT $40,000 12 2022 $4,333 $4,333 $8,667 $13,000 $52,000 $52,000 ($39,000) EFLC - SC FURNITURE $65,000 12 2022 $7,083 $7,083 $14,167 $21,250 $85,000 $85,000 ($63,750) EFLC - SC EXPRESSO BIKES (x2) $18,000 7 2021 $3,286 $3,286 $3,286 $6,571 $23,000 $23,000 ($16,429) EFLC - SC RECUMBENT BIKES (x2) $6,500 7 2025 $1,143 $1,143 $5,714 $6,857 $8,000 $8,000 ($1,143) EFLC - SC TREADMILLS (x3) $24.000 5 2023 $6,200 $6,200 $18,600 $24,800 $31,000 $31,000 ($6,200) EFLC - FC TV MONITORS (x5) $2,500 7 2025 $429 $429 $2,143 $2,571 $3,000 $3,000 ($429) EFLC - FC STEP MILL $5,500 5 2022 $1,400 $1,400 $2,800 $4,200 $7,000 $7,000 ($2,800) EFLC - FC FITNESS CENTER FLOORING $90,000 15 2025 $7,800 $7,800 $39,000 $46,800 $117,000 $117,000 ($70,200) EFLC - FC STEP MILL $5,500 6 2023 $1,167 $1,167 $3,500 $4,667 $7,000 $7,000 ($2,333) EFLC - FC SPIN BIKES (x2) $4,000 7 2021 $714 $714 $714 $1,429 $5,000 $5,000 ($3,571) EFLC - FC WEIGHT MACHINES $32,000 10 2024 $4,200 $4,200 $16,800 $21,000 $42,000 $42,000 ($21,000) EFLC - FC TREADMILLS (x8) $53,000 5 2022 $13.800 $13,800 $27,600 $41,400 $69,000 $69,000 ($27,600) EFLC - FC GYM FLOOR RESURFACE $18,000 10 2025 $2,300 $2,300 $11,500 $13.800 $23,000 $23,000 ($9,200) EFLC - FC RECUMBENT BIKES $13,000 5 2021 $3,400 $3,400 $3,400 $6,800 $17,000 $17,000 ($10,200) EFLC - FC TREADMILLS (X2) $16,000 5 2021 $4,200 $4,200 $4,200 $8,400 $21,000 $21,000 ($12,600) EFLC - FC ELIPTICALS $14,000 5 2021 $3,600 $3,600 $3,600 $7,200 $18,000 $18,000 ($10,800) 2016 EFLC - FC AMT'S (x2) $16,000 5 2021 $4,200 $4,200 $4,200 $8,400 $21,000 $21,000 ($12,600) 2016 EFLC - FC EXPRESSO BIKES UPRIGHT (x2) $16,000 7 2023 $3,000 $3,000 $9,000 $12,000 $21,000 $21,000 ($9,000) 2016 EFLC - FC SPIN BIKES (x4) $5,500 7 2023 $1,000 $1,000 $3,000 $4,000 $7,000 $7,000 ($3,000) 2016 EFLC - FC PRECOR SELECTORIZED GLUTE $3,200 10 2026 $400 $400 $2,400 $2,800 $4,000 $4,000 ($1,200) 2016 EFLC - FC GYM WALL CARPET $11,000 12 2028 $1,167 $1,167 $9,333 $10,500 $14,000 $14,000 ($3,500) 2017 EFLC - FC PRECOR MULTI UNIT $21,000 10 2027 $2,700 $2,700 $18,900 $21,600 $27,000 $27,000 ($5,400) 2017 EFLC - FC STAIRMASTER $5,500 5 2022 $1,400 $1,400 $2,800 $4,200 $7,000 $7,000 ($2,800) 2018 EFLC - FC TV MONITORS (4) $2,000 7 2025 $429 $429 $2,143 $2,571 $3,000 $3,000 ($429) 2018 EFLC - FC PA SYSTEM $3,000 10 2028 $400 $400 $3,200 $3,600 $4,000 $4,000 ($400) 2018 EFLC - FC HYDRAULIC EQUIPMENT $18,500 10 2028 $2,400 $2,400 $19,200 $21,600 $24,000 $24,000 ($2,400) 2019 EFLC - FC FURNITURE $30,000 10 2029 $3,900 $3,900 $35,100 $39,000 $39,000 $39,000 $0 2019 EFLC - FC LOBBY FLOORING $96,000 10 2029 $12,500 $12,500 $112,500 $125,000 $125,000 $125,000 $0 2019 EFLC - FC SPIN BIKES (x8) $16,000 7 2026 $3,000 $3,000 $18,000 $21,000 $21,000 $21,000 $0 2019 EFLC - FC DUMB BELLS $5,000 7 2026 $1,000 $1,000 $6,000 $7,000 $7,000 $7,000 $0 2010 EFLC - FC GYM CURTAIN $5,000 15 2025 $467 $467 $2,333 $2,800 $7,000 $7,000 ($4,200) 2010 EFLC - FC PRESCHOOL PLAYGROUND $30,000 15 2025 $2,600 $2,600 $13,000 $15,600 $39,000 $39,000 ($23,400) 2010 EFLC - FC PLAYGOUND SURFACE $10,000 15 2025 $867 $867 $4,333 $5,200 $13,000 $13,000 ($7,800) 1997 WPARK PLAYGROUND $125,000 30 2027 $5,433 $5,433 $38,033 $43,467 $163,000 $163,000 ($119,533) 1982 BOBEDEN WATER FOUNTAINS (x4) $30,000 40 2022 $975 $975 $1,950 $2,925 $39,000 $39,000 ($36,075) 1996 BOBEDEN PLAYGROUND $61,500 30 2026 $2,667 $2,667 $16,000 $18,667 $80,000 $80,000 ($61,333) 2006 VOBC PLAYGROUND $100,000 20 2026 $6,500 $6,500 $39,000 $45,500 $130,000 $130,000 ($84,500) 2006 MIDPRK WATER FOUNTAINS (x4) $30,000 15 2021 $2,600 $2,600 $2,600 $5,200 $39,000 $39,000 ($33,800) 1997 MIDPRK PLAYGROUND $125,000 30 2027 $5,433 $5,433 $38,033 $43,467 $163,000 $163,000 ($119,533) 1993 HERIT PLAYGROUND $125,000 30 2023 $5,433 $5.433 $16,300 $21,733 $163,000 $163,000 ($141,267) 1996 TRAIL PLAYGROUND $60,000 25 2021 $3,120 $3,120 $3,120 $6,240 $78,000 $78,000 ($71,760) 1996 TRAIL WATER FOUNTAINS (x4) $30,000 25 2021 $1,560 $1,560 $1,560 $3,120 $39,000 $39,000 ($35,880) 2005 PRESER FLOATING DOCK $100,000 25 2030 $5,200 $5,200 $52,000 $57,200 $130,000 $130,000 ($72,800) 2005 PRESER POND FOUNTAINS $25,000 25 2030 $1,320 $1,320 $13,200 $14,520 $33,000 $33,000 ($18,480) 2005 PRESER PLAYGROUND $75,000 20 2025 $4,900 $4,900 $24,500 $29,400 $98,000 $98,000 ($68,600) 2005 PRESER WATER FOUNTAINS (x4) $30,000 17 2022 $2,294 $2.294 $4,588 $6,882 $39,000 $39,000 ($32,118) 2001 MCCORM PLAYGROUND $50,000 20 2021 $3,250 $3,250 $3,250 $6,500 $65,000 $65,000 ($58,500) 2001 MCCORM WATER FOUNTAINS (x4) $30,000 20 2021 $1,950 $1,950 $1,950 $3,900 $39,000 $39,000 ($35,100) 2001 BLESS PLAYGROUND $25,000 20 2021 $1,650 $1,650 $1,650 $3,300 $33,000 $33,000 ($29,700) Depreciation - Parks @ TX Star $19,462 Depreciation - Softball World $8,027 Depreciation - PACS Administration $6,000 Depreciation - Aquatic Park $108,225 Depreciation - Natitorium $6,425 Depreciation - Splash Pad $6,706 Depreciation - Senior Center $29,879 Depreciation - Fitness Center $84,438 Depreciation - Westpark Park $5,433 Depreciation - Bob Eden Park $3,642 Depreciation - Villages of Bear Creek $6,500 Depreciation - Midway Park $8,033 Depreciation - Heritage Park $5,433 Depreciation - Trailwood Park $4,680 Depreciation - The Preserves $13,714 Depreciation - McCormick Park $5,200 Depreciation - Blessing Branch Park $1,650 Depart. Depreciation Total: @ 100% $323,446 Department Depreciation Collected LTD: $3237446 7-1 Department asset value: $3,201,200 Replacement Costs: $4,168.000 PACS Total Prks TX Star SBW PACS Admin EFLAP EFLAP - NAT Splash Senior Cntr Westpark Bob Eden VOBC Midway Heritage Trailwood Preserve McCormick Blessing Fitness Cntr ($2,599,865) ($330,699) ($48,720) ($10,800) ($612,150) ($38,550) ($96,083) ($197,021) ($119,533) ($97,408) ($84,500) ($153,333) ($141,267) ($107,640) ($191,998) ($93,600) ($29,700) ($246,862) Average Asset Year: 2010 PD - SERVICE DIVISION Dept. 48 AS OF: 31-Jul-19 MISC. EQUIPMENT DEPRECIATION EST. ANNUAL FUND NET CAR (SHORTAGE) ASSET LOCATION EQUIPMENT PURCH LIFE SELL DEPR DEPRE. FUTURE BALANCE REPLACE RENTAL TOTAL /OVERAGE YEAR ASSIGNED DESCRIPTION COST EXP YR TO DATE @ 100% DEPRE. @ REPLACE COST PORTION REP. COST @ PURCH 2018 SERVICE CELLBRITE MACHINE $5,000 10 2023 $700 $700 $2,100 $2,800 $7,000 $7,000 ($4,200) 2019 SERVICE DISPATCH / RADIOS UPS BATT. $25,000 4 2023 $8,250 $8,250 $24,750 $33,000 $33,000 $33,000 $0 2016 CCPD SWAT VESTS $30,000 5 2021 $7,800 $7,800 $7,800 $15,600 $39,000 $39,000 ($23,400) 2010 CCPD TRAINING ROOM FURNITURE $25,000 11 2021 $3,000 $3,000 $3,000 $6,000 $35,000 $33,000 ($29,000) 2018 CCPD HVAC REPLACEMENT COMP. RM. $15,000 5 2023 $4,000 $4,000 $12,000 $16,000 $20,000 $20,000 ($4,000) 2019 CCPD CRIME SCENE CAMERAS $5,000 5 2024 $1,400 $1,400 $5,600 $7,000 $7,000 $7,000 $0 2019 CCPD DRONE PROGRAM EQUIPMENT $30,000 5 2024 $7,800 $7,800 $31,200 $39,000 $39,000 $39,000 $0 2015 CCPD TRAINING ROOM AV EQUIPMENT $75,000 10 2025 $9,800 $9,800 $49,000 $58,800 $98,000 $98,000 ($39,200) 2017 CCPD COMMUNITY TRAILER $20,000 10 2027 $2,600 $2,600 $18,200 $20,800 $26,000 $26,000 ($5,200) 2017 CCPD FURNITURE REPLACEMENT $75,000 10 2027 $9,800 $9,800 $68,600 $78,400 $98,000 $98,000 ($19,600) 2018 CCPD RIFLE REPLACEMENT $28,000 10 2028 $3,600 $3,600 $28,800 $32,400 $36,000 $36,000 ($3,600) 2018 CCPD OVEN REPLACEMENT $7,500 10 2028 $1,000 $1,000 $8,000 $9,000 $10,000 $10,000 ($1,000) 2018 CCPD EOC AV EQUIPMENT $150,000 10 2028 $19,500 $19,500 $156,000 $175,500 $195,000 $195,000 ($19,500) 2018 CCPD SHOOTING SIMULATOR $85,000 10 2028 $11,100 $11,100 $88,800 $99.900 $111,000 $111,000 ($11,100) 2019 CCPD LAMINATOR $5,000 10 2029 $700 $700 $6,300 $7,000 $7,000 $7,000 $0 2018 CCPD BLOODBANK REFRIGERATOR $10,500 15 2033 $933 $933 $12,133 $13,067 $14,000 $14,000 ($933) 2018 CCPD EVIDENCE LOCKER REPLACE $20.000 15 2033 $1,733 $1,733 $22,533 $24.267 $26,000 $26,000 ($1,733) 2018 CCPD NETCO RADIO EQUIP / GRAPE $28,500 20 2038 $1,850 $1,850 $33,300 $35,150 $37,000 $37,000 ($1,850) 2018 CCPD COVERED PARKING $15,000 20 2038 $1,000 $1,000 $18,000 $19,000 $20,000 $20,000 ($1,000) 2018 EMG MGM EOC PLOTTER $3,000 3 2021 $1,333 $1.333 $1,333 $2,667 $4,000 $4,000 ($1,333) 2019 EMG MGM EOC FURNITURE REPLACE $20,000 15 2034 $1,733 $1,733 $24,267 $26,000 $26,000 $26,000 ($0) 2013 EMG MGM LIGHTNING DETECTION $96,000 10 2023 $12,500 $12,500 $37,500 $50,000 $125.000 $125,000 ($75,000) 2010 JAIL FLOOR SCRUBBING MACHINE $7,000 11 2021 $818 $818 $818 $1,636 $9,000 $9,000 ($7,364) 2011 JAIL REFRIGERATOR $5,000 10 2021 $700 $700 $700 $1,400 $7,000 $7,000 ($5,600) 2011 JAIL WASHER & DRYER $20,000 10 2021 $2,600 $2,600 $2,600 $5,200 $26,000 $26,000 ($20,800) 2011 JAIL FREEZER $4,000 10 2021 $500 $500 $500 $1,000 $5,000 $5,000 ($4,000) 2011 CID DUCTLESS FUME HOOD $10,000 15 2026 $867 $867 $5,200 $6,067 $13.000 $13,000 ($6,933) 2010 ADMIN FITNESS CENTER EQUIP. $30,000 13 2023 $3,000 $3,000 $9,000 $12,000 $39,000 $39,000 ($27,000) 2017 PATROL IN -CAR RADIO REPLACE $300,000 5 2022 $78,000 $78,000 $156,000 $234,000 $390,000 $390,000 ($156,000) 2017 PATROL PISTOL REPLACEMENT $75,000 8 2025 $12,250 $12,250 $61,250 $73,500 $98,000 $98,000 ($24,500) 2016 PATROL ACTIVE SHOOTER EQUIPMENT $100,000 5 2021 $26,000 $26,000 $26,000 $52,000 $130,000 $130,000 ($78,000) PD Total ($571,847) Depreciation - Service $8,950 Admin ($27,000) Depreciation - CCPD $87,617 Patrol ($258,500) Depreciation - Emg. Mgmt $15,567 CID ($6,933) Depreciation - Jail $4,618 Service ($4,200) Depreciation - CID $867 Detention ($37,764) Depreciation - Admin $3,000 EOC ($76,333) Depreciation - Patrol $1161250 CCPD ($161,117) Depart. Depreciation Total: @ 100% $236,868 Department Depreciation Collected LTD: $236,868 Department asset value: $1,324,500 Replacement Costs: $1,728,000 Average Asset Year: 2016 Dispatch Phone Recorder- Being requested in FY2020. Iffunded, new equipment would go on Motorola's System user Assurance Plan. Can delete from list. PUBLIC WORKS DEPT. Dept 33 MISC. EQUIPMENT DEPRECIATION ASSET LOCATION EQUIPMENT YEAR ASSIGNED DESCRIPTION 2005 PWYRD WAKER - 6" TRASH PUMP 2010 PWYRD MOTOROLA - PORTABLES 2008 PWYRD ALLEN - DATAGRAPH 2018 PWYRD TRENCH BOX - 57"X 102" 2018 PWYRD TRENCH BOX - 57"X 87" 2014 PWYRD TRENCH BOX - 10'X 8' 2014 PWYRD LEAK DETECTION 2016 PWYRD MIC DEVICES & CORRELATOR 2007 PWYRD SECURITY CAMERAS (16) Department Depreciation: @ 100% $19,557 Department Depreciation LTD: $19,557 Department asset value: $195,800 Replacement Costs: $267,000 Average Asset Year: 2012 AS OF. 31-Jul-19 EST. ANNUAL FUND NET CAR (SHORTAGE) PURCH LIFE SELL DEPR DEPRE. FUTURE BALANCE REPLACE RENTAL TOTAL /OVERAGE COST EXP YR TO DATE @ 100% DEPRE. @ REPLACE COST PORTION REP. COST @ PURCH $20,000 20 2025 $1,700 $1,700 $8,500 $10,200 $34,000 $34,000 ($23,800) $102,500 15 2025 $8,867 $8,867 $44,333 $53,200 $133,000 $133,000 ($79,800) $20,000 14 2022 $1,857 $1,857 $3,714 $5,571 $26,000 $26,000 ($20,429) $9,400 10 2028 $1,600 $1,600 $12,800 $14,400 $16,000 $16,000 ($1,600) $7,700 10 2028 $1,000 $1,000 $8,000 $9,000 $10,000 $10,000 ($1,000) $8,400 10 2024 $1,100 $1,100 $4,400 $5,500 $11,000 $11,000 ($5,500) $10,000 10 2024 $1,300 $1,300 $5,200 $6,500 $13,000 $13,000 ($6,500) $5,000 7 2023 $1,000 $1,000 $3,000 $4,000 $7,000 $7,000 ($3,000) $12,800 15 2022 $1,133 $1,133 $2,267 $3,400 $17,000 $17,000 ($13,600) ($155,229) TEXAS STAR - GOLF OPERATIONS Dept. 62 AS OF: 31-Jul-19 MISC. EQUIPMENT DEPRECIATION EST. ANNUAL FUND NET CAR (SHORTAGE) ASSET LOCATION EQUIPMENT PURCH LIFE SELL DEPR DEPRE. FUTURE BALANCE REPLACE RENTAL TOTAL /OVERAGE YEAR ASSIGNED DESCRIPTION COST EXP YR TO DATE @ 100% DEPRE. @ REPLACE COST PORTION REP. COST @ PURCH 1997 GOLF REEL GRINDER $30,000 30 2027 $1.300 $1,300 $9,100 $10,400 $39,000 $39,000 ($28,600) 2000 GOLF EQUIP. LIFT - GOLF SHOP $13,000 40 2040 $425 $425 $8,500 $8,925 $17,000 $17,000 ($8,075) 2008 GOLF ICE MACHINE - COURSE SERV. $5,000 15 2023 $467 $467 $1,400 $1,867 $7,000 $7,000 ($5,133) 2014 GOLF ICE MACHINE - STARTER SHACK $2,500 15 2029 $200 $200 $1,800 $2,000 $3,000 $3,000 ($1,000) 1999 GOLF FAIRWAYAERIFIER $30,000 25 2024 $1,560 $1,560 $6,240 $7,800 $39,000 $39,000 ($31,200) 1999 GOLF BEDKNIFE GRINDER $10,000 25 2024 $520 $520 $2,080 $2,600 $13,000 $13,000 ($10,400) 2017 GOLF ICE MACHINE - MAINTENANCE BARN $5,000 15 2032 $467 $467 $5,600 $6,067 $7,000 $7,000 ($933) 2017 GOLF ICE MACHINE - MAINTENANCE BARN $5.000 15 2032 $467 $467 $5,600 $6,067 $7,000 $7,000 ($933) 2008 GOLF 2 DOOR COOLER $3,000 15 2023 $267 $267 $800 $1,067 $4,000 $4,000 ($2,933) 2008 GOLF 2 DOOR REACH IN REFRIGERATOR $4,000 15 2023 $333 $333 $1,000 $1,333 $5,000 $5,000 ($3,667) 1995 GOLF WATER FEATURE - 18 WFALL $25,000 30 2025 $1,100 $1,100 $5,500 $6,600 $33,000 $33,000 ($26,400) 1997 GOLF WATER FEATURE -AERIFIERS $12,000 28 2025 $571 $571 $2,857 $3,429 $16,000 $16,000 ($12,571) 1996 GOLF IRRIGATION - PUMPS $50,000 30 2026 $2,167 $2,167 $13,000 $15,167 $65,000 $65,000 ($49,833) 1996 GOLF IRRIGATION CENTRAL CONT. $30,000 30 2026 $1,300 $1,300 $7,800 $9,100 $39,000 $39,000 ($29,900) 1996 GOLF IRRIGATION SAT. BOX (21) $210,000 30 2026 $9,100 $9,100 $54,600 $63,700 $273,000 $273,000 ($209,300) 1996 GOLF IRRIGATION PUMP - SKID $20,000 30 2026 $867 $867 $5,200 $6,067 $26,000 $26,000 ($19,933) 1995 GOLF CART BRIDGE - HOLE 10 $75,000 30 2025 $3,267 $3,267 $16,333 $19,600 $98,000 $98,000 ($78,400) 1995 GOLF CART BRIDGE - HOLE 9 $75,000 30 2025 $3,267 $3,267 $16,333 $19,600 $98,000 $98,000 ($78,400) 1995 GOLF CART BRIDGE - HOLE 18 $80,000 30 2025 $3,467 $3,467 $17,333 $20,800 $104,000 $104,000 ($83,200) 2009 GOLF WALKING BRIDGE - HOLE 18 $50,000 30 2039 $2,167 $2,167 $41,167 $43,333 $65,000 $65,000 ($21,667) 1995 GOLF UNDERGROUND IRRG. SYSTEM $650,000 40 2035 $21,125 $21,125 $316,875 $338,000 $845,000 $845,000 ($507,000) 2008 CONF. CNTR. UNDER COUNTER 2 DOOR COOLER $3,300 15 2023 $267 $267 $800 $1,067 $4,000 $4,000 ($2,933) 2008 CONF. CNTR. WALL MTD. COOLER - 3 DOOR $5,800 15 2023 $533 $533 $1,600 $2,133 $8,000 $8,000 ($5,867) 2008 CONF. CNTR. WALL MTD. COOLER - 2 DOOR $5,300 15 2023 $467 $467 $1,400 $1,867 $7,000 $7,000 ($5,133) 2008 CONF. CNTR. PASS THRU COOLER-4 DOOR $13,500 15 2023 $1,200 $1,200 $3,600 $4,800 $18,000 $18,000 ($13,200) 2008 CONF. CNTR. HOT BOX-4 DOOR $12,500 15 2023 $1,067 $1,067 $3,200 $4,267 $16,000 $16,000 ($11,733) 2008 CONF. CNTR. FLAT TOP - 4 BURNER $5,200 15 2023 $467 $467 $1,400 $1,867 $7,000 $7,000 ($5,133) 2008 CONF. CNTR. CHARGRILLER-11 BURNER $6,200 15 2023 $533 $533 $1,600 $2,133 $8,000 $8,000 ($5,867) 2008 CONE CNTR. STOVE TOP/OVEN - 8 BURNER $10,000 15 2023 $867 $867 $2,600 $3,467 $13,000 $13,000 ($9,533) 2008 CONE CNTR. STEAM TABLE $17,200 20 2028 $1,100 $1,100 $8,800 $9,900 $22,000 $22,000 ($12,100) 2008 CONF. CNTR. TILT SKILLET $17,500 15 2023 $1,533 $1,533 $4,600 $6,133 $23,000 $23,000 ($16,867) 2008 CONF. CNTR. DEEP FRYER $17,000 20 2028 $1,100 $1,100 $8,800 $9,900 $22,000 $22,000 ($12,100) 2008 CONF. CNTR. MOBILE HOT BOX $7,600 15 2023 $667 $667 $2,000 $2,667 $10,000 $10.000 ($7,333) 2008 CONF. CNTR. MOBILE HOT BOX $7,600 15 2023 $667 $667 $2,000 $2,667 $10,000 $10,000 ($7,333) 2010 CONF. CNTR. ICE MACHINE - REMOTE CONDENSER $2,000 15 2025 $200 $200 $1,000 $1,200 $3,000 $3,000 ($1,800) 2017 CONF. CNTR. AV EQUIP. - MASTER COMPONENTS $29,000 6 2023 $6,333 $6,333 $19,000 $25,333 $38,000 $38,000 ($12,667) 2008 CONF. CNTR. DISHWASHER $7,500 15 2023 $667 $667 $2,000 $2,667 $10,000 $10,000 ($7,333) 2008 CONF. CNTR. STACKABLE OVENS (2 SETS) $13,500 15 2023 $1,200 $1,200 $3,600 $4,800 $18,000 $18,000 ($13,200) 1997 CONF. CNTR. BEER COOLER - 4 DOOR $4,500 25 2022 $240 $240 $480 $720 $6,000 $6,000 ($5,280) 2011 CONF. CNTR. AV EQUIP. - TV UNITS (5) $7,000 10 2021 $900 $900 $900 $1,800 $9,000 $9,000 ($7,200) 2008 CONF. CNTR. INTERIOR DECOR (LOBBY) $5,000 15 2023 $467 $467 $1,400 $1,867 $7,000 $7,000 ($5,133) 2010 CONF. CNTR. FURNITURE - TABLES $10,000 15 2025 $867 $867 $4,333 $5,200 $13,000 $13,000 ($7,800) 2008 GRILLE ICE MACHINE REMOTE COND $5,000 15 2023 $467 $467 $1,400 $1,867 $7,000 $7,000 ($5,133) 2008 GRILLE STOVE / OVEN - 4 BURNER $3,500 15 2023 $333 $333 $1,000 $1,333 $5,000 $5,000 ($3,667) 2008 GRILLE KETTLE $12,000 15 2023 $1,067 $1,067 $3,200 $4,267 $16,000 $16,000 ($11,733) 2008 GRILLE STOVE TOP - 4 BURNER $4,000 15 2023 $333 $333 $1,000 $1,333 $5,000 $5,000 ($3,667) 2008 GRILLE DEEP FRYER $25,000 15 2023 $2,200 $2,200 $6,600 $8,800 $33,000 $33,000 ($24,200) 2018 GRILLE STAND-UP FREEZER $3,000 10 2028 $400 $400 $3,200 $3,600 $4,000 $4,000 ($400) 2008 GRILLE BAR COOLER - 4 DOOR $2,500 15 2023 $200 $200 $600 $800 $3,000 $3,000 ($2,200) 2008 GRILLE COOLER - 2 DOOR $4,000 15 2023 $333 $333 $1,000 $1,333 $5,000 $5,000 ($3,667) 2008 GRILLE WALK-IN COOLER $8,000 35 2043 $286 $286 $6,571 $6,857 $10,000 $10,000 ($3,143) 1999 GRILLE WALK-IN FREEZER $10,000 35 2034 $371 $371 $5,200 $5,571 $13,000 $13,000 ($7,429) 2019 GRILLE FURNITURE -TABLES $12,000 10 2029 $1,600 $1,600 $14,400 $16,000 $16,000 $16.000 $0 2019 GRILLE FURNITURE - CHAIRS (120) $35,000 10 2029 $4,600 $4,600 $41,400 $46,000 $46,000 $46,000 $0 2008 GRILLE DISHWASHER $7,500 15 2023 $667 $667 $2,000 $2,667 $10,000 $10,000 ($7,333) 2008 GRILLE CONVECTION OVENS $14,000 15 2023 $1,200 $1,200 $3,600 $4,800 $18.000 $18,000 ($13,200) 2008 GRILLE FLAT TOP - 4 BURNER $5,000 15 2023 $467 $467 $1,400 $1,867 $7,000 $7,000 ($5,133) 2008 GRILLE CHARGRILL-6BURNER $4,000 15 2023 $333 $333 $1,000 $1,333 $5,000 $5,000 ($3,667) 2008 GRILLE SALAD PREP COOLER - 4 DR $7,300 15 2023 $600 $600 $1,800 $2,400 $9,000 $9,000 ($6,600) 1997 GRILLE MIXER $10,000 25 2022 $520 $520 $1,040 $1,560 $13,000 $13,000 ($11,440) 2008 GRILLE UNDER CNT. COOLER - 6 DR $11,000 15 2023 $933 $933 $2,800 $3,733 $14,000 $14,000 ($10,267) 2015 GRILLE CARPET $40,000 7 2022 $7,429 $7,429 $14,857 $22,286 $52,000 $52,000 ($29,714) 2009 GRILLE PATIO TABLE 12 $3,500 12 2021 $417 $417 $417 $833 $5,000 $5,000 ($4,167) 2009 GRILLE PATIO CHAIRS 48 $6,750 12 2021 $750 $750 $750 $1,500 $9,000 $9,000 ($7,500) Tx Star Total ($1,549,285) Depreciation - Golf $54,401 Golf ($1,209,480) Depreciation - Conference Center $21,340 Conf Cntr ($175,547) Depreciation - Grille $25,506 Grille ($164,259) Depart. Depreciation Total: @ 100% $101,247 Department Depreciation Collected LTD: $101,247 Department asset value: $1,824,750 Replacement Costs: $2,380,000 Average Asset Year: 2006 Office ity Manager July 26, 2019 Dear Mayor and Council Members: Please find attached the FY2019-2020 Proposed Operating and Capital Budgets for your review. As you will see, we are recommending that you maintain the current property tax rate of 46.25C. Our goal this year was to put the City in the best financial position possible to deal with the upcoming legislative changes. This budget also addresses the lost revenue from franchise fees, provides a modest 2.5% salary package for employees and provides depreciation funding for furnishings, fixtures and equipment that has not previously been included. This is critical to eliminating our dependency on excess reserves. It also provides for a number of major capital improvement including replacing Fire Station #1 and funding for Phase VII of the Parks at Texas Star (Softball World). We plan to cover most of the proposed budget the evening of Thursday, August 1st beginning at 5:30 p.m. in the Pre -Council room at City Hall. Dinner will be provided. On Saturday, August 3rd, we will begin with breakfast at 7:30 a.m. in the Treaty Room at Texas Star and continue the work session at 8:30 a.m. in the Travis Room. We will begin by wrapping up the proposed budget discussion, followed by presentations on a variety of topics. There will be ample time allowed for discussions. Please let us know if there are any specific topics you would like to discuss so that we can be prepared. Your staff has worked diligently to prepare this budget and we look forward to good conversation and discussion. Sincerely, C � 02 5 rj� Loretta Getchell City Manager 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 • Metro 817/267-4403 • Fax 817/685-1416 www.ci.euless.tx.us Highlights This year we continued the effort to prepare the City for build out. Over the years, the City has worked to get the street overlay and water and wastewater line replacements in the baseline budget. Last year, we also added computer hardware and software replacement in the baseline budget. Many years ago, the City established an Equipment Replacement Fund. Each operating budget has contributed its pro-rata share toward the replacement of vehicles and mobile equipment. However, furnishings, fixture and non -mobile equipment was not included in the replacement fund. As these items come due for replacement, the directors have requested capital funding from excess reserves to replace these items. For FY2020, directors complied a listing of all the major capital equipment that is not currently being funded, established useful lives and determined the amount of accumulated depreciation to date that has not been funded. Examples of these items include the generators on our various facilities, thermal imaging cameras, FD rescue tools, SCBA units and compressors, concession equipment, aquatic park slides, filters and pumps, fitness center equipment, playground equipment, PD & FD radios, EOC equipment, lightning detection system, just to name a few. As you can see, these are not discretionary type purchases. Therefore, we believe it is critical to provide annual baseline funding for the replacement of these items and to fund the accumulated depreciation on these items. In total, this will require just over $800K annually from all funds. The accumulated depreciation to date was over $5M. We were able to address all the funding this year except for the Texas Star Golf Course and a few major items such as park pavilions and lighting, turf fields, buildings, outdoor warning sirens, roof replacements and replacement of the HTE financial software. We also did not include the AV system in the Council Chambers which is funded through the Cable PEG fees and electronic ticket writers that are funded from Court Technology. Of course, we may identify more items in the future that may need to be added. Items not addressed will continue to be dependent upon either excess reserves, car rental funding or debt financing. The other area that we have not fully achieved is the depreciation on vehicles in excess of $75K. These still require a combination of funding from car rental and short-term tax notes. Therefore, the majority of baseline increases in this year's operating funds is not for new expenditures but is merely to ensure we can sustain our current operations. The other most significant increase is funding for a 2.5% pay plan. There were other small increases in supplies and maintenance. (drone program supplies, computer maintenance contracts, mowing, alarm services — backflow preventers) which are less than 1 %. We were able to increase the street overlay by $25,000 to a total of $975,000 to keep pace with the recommended level of annual funding per our consultants street study. The only new programs being requested in the General Fund is the addition of one code officer and a small amount of software to assist the Fire department and the Planning Dept in fieldwork. The believe the addition of the code officer is critical due to volume of work. In addition to the hundreds of Access Euless requests, they are doing minimum housing inspections, restaurant inspections, pool inspections, and we have added hotel inspections. We are recommending that the tax rate be held flat at 46.250 Water & Wastewater In the Water and Wastewater Fund, TRA has increased our cost to purchase water by 160 and the cost of wastewater treatment by just under 10. Factoring in a 2.5% pay plan, we are requesting that water rates be adjusted by 190 and wastewater rates be adjusted by 2¢ in addition to a 250 increase in each base rate. The only new supplemental program we are recommending is the addition of one public works field technician. Capital Improvements Fund We have a significant amount of Capital Projects underway and are proposing to fund the replacement of Fire Station #1 next year along with Phase VII of the Parks at Texas Star and the Wilshire Park Improvements. The Fire Station costs is estimated at $7.3M and is proposed to be funded from a CO debt sale. Due to the drop off in existing debt, we will not need to increase the tax rate to fund this project. Phase VII of the Parks at Texas Star is proposed to be funded by the EDC through an EDC Revenue Bond that will be paid from sales tax proceeds dedicated to the EDC. We are proposing to cash flow the Wilshire Park Improvements from the car rental fund. We have water and wastewater line replacement projects of almost $1.5M with $1,075K from baseline plus anticipated CDBG funding. As mentioned, street overlay has been increased to $975K along with funding for the signal at Heritage and Cheeks Spargur that is being shared with 3 other entities and the Glade Road improvements that are being shared with Grapevine and the developer.