|
2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030Estimated Actual Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated EstimatedDepartment Unit # Item Useful Life Amounts Amounts (1)Amounts (1)Amounts (1)Amounts (1)Amounts (1)Amounts (1)Amounts (1)Amounts (1)Amounts (1)Amounts (1)Fire T11 Tender - Station #1 -$ -$ -$ -$ 282,500$ 282,500$ -$ -$ -$ -$ -$ Fire T21 Tender - Station #2 - - - - - 292,500 292,500 - - - - Fire A21 Quint - Station #2 - - - - - - - 1,100,000 1,100,000 - - Fire 618 Ford Explorer 8 - 45,000 - - - - - - - 57,005 - Fire 617 Ford Explorer 8 - - 46,350 - - - - - - - 58,715 Fire 619 Ford Explorer 8 - - - 47,741 - - - - - - - Fire 600 Ford Explorer 8 - - - - 49,173 - - - - - - Fire BOAT21 Rescue Boat - - - - - 50,648 - - - - - Police 301 Unmarked Admin Vehicle 6 - - - - 43,709 - - - - - 52,191 Police 302 Marked Patrol Vehicle 5 - - 51,500 - - - - 59,703 - - - Police 303 Marked Patrol Vehicle 5 - - - 53,045 - - - - 61,494 - - Police 304 Marked Patrol Vehicle 5 - - - - 54,636 - - - - 63,339 - Police 306 Unmarked Investigation Vehicle 8 - - - - - 45,020 - - - - - Police 307 Unmarked Investigation Vehicle 8 - - - - - 45,020 - - - - - Police 308 CSO Vehicle 6 - - - - 43,709 - - - - - 52,190 Police 309 Marked Investigation Vehicle 8 - - - - - - 46,370 - - - - Police 311 Marked Investigation Vehicle 7 - - - - - 45,020 - - - - - Police 314 Marked Patrol Vehicle 5 - - - - 54,636 - - - - 63,338 - Police 315 Marked Patrol Vehicle 5 - - - - 54,636 - - - - 36,338 - Police 316 Marked Patrol Vehicle 5 44,471 - - - - 56,275 - - - - 65,238 Police 317 Unmarked Patrol Vehicle 5 38,325 - - - - 56,275 - - - - 65,238 Police 382 Marked Patrol Vehicle 5 - - 51,500 - - - - 59,703 - - - Police 392 Marked Patrol Vehicle 5 - - 51,500 - - - - 59,703 - - - Police 393 Marked Patrol Vehicle 5 - 50,000 - - - - 57,964 - - - - Police 394 Marked Patrol Vehicle 5 - 50,000 - - - - 57,964 - - - - Police 396 Marked Patrol Vehicle 5 - 50,000 - - - - 57,964 - - - - Police 397 Unmarked Admin Vehicle 6 - - - 42,436 - - - - - 50,671 - Police 398 Unmarked Admin Vehicle 6 - - - - 43,709 - - - - - 52,191 Police 399 Unmarked Patrol Vehicle 5 - - - 53,045 - - - - 61,494 - - Public Services 417 GMC Sierra 1500 9 41,262 - - - - - - - - - - Public Services 418 Ford F550 Roll-Off 9 99,837 - - - - - - - - - - Public Services 268 Ford F350 w/ Dumpbox 9 64,189 - - - - - - - - - - Public Services 807 Ford F250 9 56,525 - - - - - - - - - - Public Services 224 John Deere 544J Loader 13 - 212,000 - - - - - - - - - Public Services 132 Case 85XT Skid Steer 13 - 60,000 - - - - - - - - - Public Services 119 John Deere LV4100 Tractor 13 - - 20,000 - - - - - - - - Public Services 200 Sterling L8500 Single Axle Dump Truck 13 - - 250,000 - - - - - - - - Public Services NEW Electric Man Lift 10 - - - 25,000 - - - - - - - Public Services 214 Chevy 1 ton 4x4 with plow 9 - - - 57,000 - - - - - - - Public Services 403 GMC Sierra 3500 with Dump Box 9 - - - 57,000 - - - - - - - Public Services 239 Ford L8000 Bucket Truck 9 - - - 150,000 - - - - - - - Public Services 142 Vermeer BC1500 Chipper 15 - - - - 45,000 - - - - - - Public Services 251 Caterpillar 420E Backhoe 13 - - - - 150,000 - - - - - - Public Services 117 John Deere 6410 Tractor 13 - - - - 125,000 - - - - - - Public Services 135 John Deere 4710 Tractor 13 - - - - 35,000 - - - - - - Public Services 404 Bobcat Toolcat 5600 10 - - - - - 64,600 - - - - - Public Services 415 Ferris Zero Turn Mower 10 - - - - - 15,000 - - - - - Public Services 252 Elgin Pelican Street Sweeper 13 - - - - - 250,000 - - - - - Public Services 405 Ferris Zero Turn Mower 10 - - - - - 15,000 - - - - - Public Services 140 John Deere 5525 Tractor 10 - - - - - - 128,000 - - - - Public Services 215 Ford Sterling Dump Truck 13 - - - - - - 250,000 - - - - Public Services 803 GMC Sierra 4wd Reg Cab Pickup 9 - - - - - - 36,700 - - - - Public Services 218 Ford Sterling L850 Dump Truck 13 - - - - - - - 252,500 - - - Public Services 225 Ford F-350 4x4 Pickup 9 - - - - - - - 100,400 - - - Public Services 137 Ingersol Rand Air Compressor XP185WJD 13 - - - - - - - - 19,700 - - Public Services 255 F350 4x4 Reg Chas Cab DRW 9 - - - - - - - - 73,480 - - Public Services 256 F550 4x4 Reg Chas Cab DRW 9 - - - - - - - - 73,480 - - Public Services 258 Falcon 2-ton Asphalt Hot Box 10 - - - - - - - - 25,220 - - Public Services 259 GMC Sierra 4WD Reg Cab 9 - - - - - - - - 35,600 - - Public Services 406 John Deere 3720 Tractor 13 - - - - - - - - 51,900 - - Public Services 409 Progressive Mower TD-65B 8 - - - - - - - - 25,600 - - Public Services 414 Bobcat Toolcat 5600 (Trade-in) 10 - - - - - - - - - 72,760 - Public Services 210 Mack Truck 13 - - - - - - - - - 314,070 - Public Services 262 F550 Hook Roll-off Truck 9 - - - - - - - - - 64,400 - Public Services 263 F550 4x4 with Plow 9 - - - - - - - - - 64,400 - Public Services 260 Mack Truck 13 - - - - - - - - - - 324,970 Public Services 267 Ford F250 Reg Cab 4x4 9 - - - - - - - - - - 55,300 Public Services 411 Kubota RTV-X1120D 5 - - - - - - - - - - 17,500 Public Services 412 Ford F-250 9 - - - - - - - - - - 41,690 Grand Total 344,609$ 467,000$ 470,850$ 485,267$ 981,708$ 1,217,858$ 927,462$ 1,632,009$ 1,527,968$ 786,321$ 785,223$ Fire Annual Total -$ 45,000$ 46,350$ 47,741$ 331,673$ 625,648$ 292,500$ 1,100,000$ 1,100,000$ 57,005$ 58,715$ Police Annual Total 82,796$ 150,000$ 154,500$ 148,526$ 295,035$ 247,610$ 220,262$ 179,109$ 122,988$ 213,686$ 287,048$ Public Services Annual Total 261,813$ 272,000$ 270,000$ 289,000$ 355,000$ 344,600$ 414,700$ 352,900$ 304,980$ 515,630$ 439,460$ Assumptions:(1) Current dollars with 3.00% annual inflationCity of Lino LakesCapital Equipment PlanCapital Outlay ScheduleCapital Equipment Revolving Fund 402
|