Loading...
HomeMy WebLinkAbout2020-01-08 Handout @ Meeting City of Centerville Capital Asset Replacement-Fund 409 11/14/18 Sys.No. Description Date In Method/ Depr. Cost/Other Salvage Service Cony. Yrs. Basis Value 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Public Works 295 10/31/2007 SL/N/A 6 11,370 32,700 36,800 2000 Ford Ranger 10/31/2007 SL/N/A 6 5,685 25,355 28,500 FO[ R r"''''' 'll - 10/31/2007 SL/N/A 6 11,370 32,700 36,800 V Blade Plow 11,000 2005 Ford Ranger 10/31/2007 SL/N/A 6 5,685 26,000 29,300 347 1 ,,.'-' ° 3 i.' 11/1/2014 SL/N/A 6 30,607 10,000 34,000 38,300 231 1 V Blade Plow 4/15/2004 SL/N/A 6 5,567 3,000 10,000 11,200 346 ______________________________________________l 11/1/2014 SL/N/A 6 29,617 12,000 38,000 42,800 348 1 J 12/1/2014 SL/N/A 6 20,004 5,000 27,000 30,400 114 2007 Sterling Truck 12/31/2006 SL/N/A 24 62,331 35,000 293 2001 Sterling Truck 3/14/2007 SL/N/A 24 63,060 30,000 140,000 15 11,000 5,000 15,000 19 Cushman Utility Cart 11/9/1998 SL/N/A 5 3,000 - 238 1998 Massey Ferguson Tractor(C728148) 12/31/1998 SL/N/A 20 55,000 5,000 65,000 329 12/9/2010 M/HY 7 27,463 6,000 40,000 239 12/31/2001 SL/N/A 10 29,252 5,000 35,000 76 Versa Vac 4/3/2004 SL/N/A 10 35,371 5,000 40,000 341 Allied Generator 10/1/2013 SL/N/A 5 9,321 2,000 12,000 Beuthling Blacktop Roller 5,000 - 8,000 335 Salt Brine Mixing Tank(Varitech) 11/1/2012 SL/N/A 10 9,640 - 12,000 254 Siren LS 1 12/31/1980 SL/N/A 20 8,000 - 12,000 257 Flammable Cabinets(3) 12/31/2001 SL/N/A 20 3,150 - 275 7/26/2006 SL/N/A 10 15,203 2,000 20,000 Hottsy Pressure Washer 2,000 3,000 Shop Air Compressor 2,000 3,000 PW Roof&Cap 136,000 Pw HVAC 50,000 Total Public Works 460,696 - - 90,755 135,000 35,000 80,000 52,000 166,000 133,100 164,000 226,000 - Grand Total Expenditures: 1,232,591 1,700 27,040 111,755 185,600 41,100 100,100 112,600 222,100 194,200 209,600 277,100 76,100 Beginning of Year Fund Balance-Fund 409 158,473 208,055 252,221 239,988 192,118 253,039 263,422 261,348 155,779 134,173 116,162 (40,223) Interest Earnings 1,282 2,081 2,522 2,400 1,921 2,530 2,634 2,613 1,558 1,342 1,162 (402) Transfers In from General Fund 50,000 61,125 76,000 81,000 83,430 85,933 88,511 91,166 93,901 96,718 99,620 102,608 Transfers In from Enterprise Funds 11,000 11,330 11,670 12,020 12,381 12,752 13,135 13,529 13,934 14,353 Salvage/Trade-In Proceeds Pickups - 10,000 43,000 - - - - 60,000 80,000 - Salvage/Trade-In Proceeds Heavy Trucks 10,000 Salvage/Trade-In Proceeds Other Equipment - - 5,000 10,000 7,000 - 4,000 - 6,000 Insurance Proceeds-Park Shelter Roofs 8,000 Expenditures (1,700) (27,040) (111,755) (185,600) (41,100) (100,100) (112,600) (222,100) (194,200) (209,600) (277,100) (76,100) End of Year Fund Balance-Fund 409 208,055 252,221 239,988 192,118 253,039 263,422 261,348 155,779 134,173 116,162 (40,223) 236