2019_0211_CCPacket 7.a, 7.e bench handout

Home

Ac6eince4 fie"`7 e City of Roseville (•' h 1/ 2_01/ Capital Improvement Plan:Fire Vehicle&Equipment Fund(401) �-�C , 2019-2038 2412 2923 2421 3922 2421 2924 2422 2425 2422 2928 2924 2970 2211 2472 2471 2934 2421 2233 2912 2411 Tax Levy Current 5 335,000 $ 333,000 5 335,000 5 335,000 $ 335,000 S 335,000 f 335,000 1 335,000 T 335,000 1 335,000 $ 335,000 S 335,000 5 333,000 0 335,000 5 333,000 $ 333,000 $ 335,000 $ 335,000 S 335,000 f 335,000 Tax Levy:Add/Sub Other - - - . _ _ - - _ . - _ Sale of Assets - - Interest Earnings 21,900 24,530 15,270 2,676 7,689 10,573 14,857 6,824 9,680 9,926 13,314 19,011 5,751 8,748 12,783 18,739 22,113 9,136 9,568 16,080 Revenues $ 356,900 S 359,530 S 350,270 f 337,676 $ 342,689 $ 345,575 $ 349,857 $ 341,824 5 344,680 $ 344,926 5 348,314 5 354,011 $ 340,751 $ 343,748 $ 347,783 f 353,739 $ 357,113 $ 344,136 $ 344,568 1 351,080 56,959,169 Vehicles I 105,000 5 632,500 $ 950,000 5 60,000 $ 70,000 $ 62,500 $ 632,000 5 65,000 5 75,000 $ 142,500 0 - 5 830,000 S 112,000 $ 72,500 0 - 5 75,000 $ 880,000 $ 112,500 S - $ - Egtupment 109,500 177,500 22,000 27,000 127,000 55,000 1.18,000 126,000 256,000 28,000 50,000 180,500 77,300 36,500 30,000 105,000 121,000 205,000 10,000 36,000 Furniture&Fixtures 10,900 12,500 8,000 - 1,400 14,000 1,500 8,000 1,400 5,000 13,500 6.500 1,400 13,000 20,000 5.000 3,000 5,000 9,000 _ Buildings _ - _ _ _ _ _ _ _ _ _ _ _ _ - - - - - Improvements - - - - - 000 5 322,500 $ 19,000 $ 36,000 $6,935,100 Expenditures 5 225,400 f 822,300 5 980,000 $ 87,000 $ 1%,400 f 131,500 f 751,500 $ 199,000 $ 332,400 f 175,500 $ 63,500 51,017,000 $ 190,900 S 142,000 $ 50,000 f 185,000 51,006, Beginning Cash Balance 11,094,993 $1,226,493 5 763.523 5 133,793 $ 314,469 $ 328,759 $ 742,834 $ 341,190 $ 484,014 5 496,295 $ 663,720 $ 950,333 $ 287,546 $ 437,396 $ 639,144 $ 936,927 $1,105,666 $ 456,779 5 478,415 .5 803,983 Annual Surplus(deficit) 131,500 (462,970) (629,730) 250,676 144,289 214,075 (401,643) 142,824 12,280 169,426 284,814 (662,989) 149,851 201,748 297,713 168,739 (648,887) 21,636 325,568 315,080 Cash Balance 11,226,493 $ 763,523 5 133,793 5 384,469 $ 528,759 $ 742,834 $ 301,190 $ 484,014 $ 496,295 $ 665,720 $ 950,535 $ 287,546 1 437,396 5 639,144 $ 936,927 $1,105,666 1 456,779 I 478,415 $ 803,983 51,119,063 Funding Status 644% 173% 107% 118% 123% 130% 111% 114% 113% 117% 124% 106% 108% 112% 117% 120% 307% 107% 112% 116% Cash Balance(Year-End) $ 888,993 2017 Fire Vehicle 6 Equipment Fund Planned CEP Surplus/Deficit 206.000 2018 Adjust for Delayed CIP Items - 2018 $1,400,000 -'- Cash Balance(Beg,Year) 51,094,993 2019 l$1,200,000 ..________._.____...____....___ $1,000,000 _.__ _ _....._ __-___.. .._ 1800,000 A - -- 5600 000 4' ■.■ _ 1400.000 _.. 5200,000 .1. " '7 11 " 117 1 ,10 " i 2019 2022 2025 2028 2031 2034 2037 Revenues =MN Expenditures -Cash Balance Eepeoditure Detail Km Pescriotiou 2419 2021 2021 2022 2921 2424 2421 2425 1022 2921 2422 2414 2471 2931 2011 2474 2411 2434 242 2038 Staffed engine replacement 1 - 8 575,000 9 - 5 - $ - S - T 632,000 f - 1 - f - 1 - 8 695,000 5 - $ - f • 5 - S 765,000 5 - $ - 5 - 52,667,000 Medic Unit 105000 - _ - 70,000 - - 75,000 75,000 - • 112.000 - - - 115,000 - - - 552,000 Lhilit5-foam trmmpor9'trailer - - _ - _ _ - 65,000 - - - - - - - - 65,000 Ladder truck - - 950,000 - - - - - - . - - - - - . - - - - 950,000 Command Response Vehicle - 57,500 - 60,000 - 62,500 - 6.5.000 - 67,500 - 70,000 - 72.500 • 7.3,000 - 77,500 - - 607,500 Rescue boat _ _ _ _ _ • 35,000 - - 35,000 Exercise room-fitness equipment - 15.000 - - 18,000 • - 18.000 - - 20,000 - - 70.000 - • 20,000 . - 111,000 Self contained breathing apparatus - - - - _ - - 200,000 - - - - - - • 150,000 - - 350,000 Ventilation fans - - • 7,100 - • - - - - - 8000 - - - - - - • - 15,000 Power equipment - 10000 • - - - - 10,000 - - - _ _ - 20,000 Personal Protective Equipment 40,000 40000 - - - 35,000 30,000 15,000 - - - 35.000 25,000 10,000 - - • 35.000 . - 265,000 Cardiac Monitoring and Response 1 • 45,000 - - 50.000 - - 55,000 - _ _ 60.000 65,000 36.000 311,000 Medial hags and 02 begs 6,500 _ - _ _ _ 6,500 . _ - 6,500 - - - - 19,500 Trainingt - - - - 2,000 . . - - 2,000 - . _ - _ - - 4,000 equipment 620,000 Camera to asSiA with rescuafirchgl - - 7,000 - • - - 6,500 - - • - 6,500 - - - - _ - Portable and mobile radios 20,000 20.00 5,000 20,000 20.000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20.000 20,000 20,000 20,000 20,000 - - 345,000 Firefighting Equipment _ _ _ _ _ 5,000 - - - _ _ - _ - 5,000 Response to water related emergent - - - - 6,000 - - - - 6,000 - - - - - - - - - - 12,000 Apparatus Based IT InOtstnxaure 26,000 - 10,000 - 26-000 - 10,000 - 26,000 - 10000 - 26,000 - 10.000 - 26,000 - 10,000 • 180,000 Air monitoring equipment 5,000 - - 5,000 - 5,000 _ _ 5,000 - - _ _ • 20,000 Rescue equipment • 32,500 - - - - 35.000 - - - - 37,500 - - - - 40,010 - - - 145,000 Of-site paging equipment - - - - - - _ - - - . SWAT Gear.Equipnest - - - - - _ - . . - - - - - 15,000 Nozzles 12,000 - _ - - 3.000 - - - - - 20000 - - - 20,000 Fire adnnn-office furniture - _ - - - - - - - - - - - Trainmg room tablas&chairs - 15,000 • . - - 15,000 - - - - 15.000 - - - • 15.000 . . - 60,000 Cool room Furniture 5.0003,000 5,000 - 20,000- - 5,000 - . - - - - _ " Kitchen appliances - 4.500 - - - 4.500 - - . 5,00') - _ _ 5,000 - - 5,000 - . 24,000 ' Kitchen table&chairs - _ . - - _ 1,500 - . - - 1,500 - - _ - - - 3,000 Day room chairs - 8,000 - - - - - 8.000 - - - - - 6,000 - . - . - - 24,000 AV equipment-training room 4,500 - - - - 4,500 . - - - 5.000 - - - - 5,000 - - . - 19,000 Second Boor waster&dryer 1.400 - - - 1400 - . - 1.400 - - - 1.400 - - - - - 5•600 Bed Mattresses - - 8,000 - - . - - - - 6.500 - - - - . - 9000 - 25,500 Bed Structure - - . - - . _ _ . 21000' . . - - - 20,000 $ 225,400 $ 822,500 $ 980,000 $ 87,000 $ 198,400 $ 131,500 $ 751,500 0 199,000 $ 332,400 $ 175,500 $ 63,500 $1,017,000 1 190,900 5 142,000 $ 50,000 $ 185,000 51,006,000 $ 322,500 $ 19.000 $ 36,000 56,935,100