City of Roseville
<br />Capital Improvement Plan: IT Support Equipment Fund (113 & 114)
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: Current$200,000$200,000$200,000$200,000$200,000$200,000$200,000$200,000$200,000$200,000$200,000$200,000$200,000$200,000$200,000$200,000$200,000$200,000$200,000$200,000
<br />Tax Levy: Add/Sub--------------------
<br />Other--------------------
<br />Sale of Assets--------------------
<br />Interest Earnings8,3567,4268,9069,54411,0299,4448,9287,95610,06010,91013,23813,87115,2266,2857,3259,0559,4929,5788,8079,679
<br />Revenues$208,356$207,426$208,906$209,544$211,029$209,444$208,928$207,956$210,060$210,910$213,238$213,871$215,226$206,285$207,325$209,055$209,492$209,578$208,807$209,679$4,195,114
<br />Vehicles$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Equipment254,880108,430176,980135,330290,280235,230257,530102,730167,58069,530181,580146,130662,230154,330120,780187,230205,180223,130165,230117,830
<br />Furniture & Fixtures-25,000-------25,000-------25,000--
<br />Buildings--------------------
<br />Improvements--------------------
<br />Expenditures$254,880$133,430$176,980$135,330$290,280$235,230$257,530$102,730$167,580$94,530$181,580$146,130$662,230$154,330$120,780$187,230$205,180$248,130$165,230$117,830$4,037,150
<br />
<br />Beginning Cash Balance$417,820$371,296$445,292$477,218$551,433$472,181$446,395$397,793$503,019$545,499$661,879$693,536$761,277$314,273$366,228$452,773$474,598$478,910$440,358$483,936
<br />
<br />Annual Surplus (deficit)(46,524)73,99631,92674,214(79,251)(25,786)(48,602)105,22642,480116,38031,65867,741(447,004)51,95586,54521,8254,312(38,552)43,57791,849
<br />Cash Balance$371,296$445,292$477,218$551,433$472,181$446,395$397,793$503,019$545,499$661,879$693,536$761,277$314,273$366,228$452,773$474,598$478,910$440,358$483,936$575,784
<br />5-Year Funding Status148%10-Year Funding Status136%Long-Term Funding Status114%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$1,463,08110-Year Funding Sources (Rev + Beg Cash Balance)$2,510,379Long-Term Funding Sources (Rev + Beg Cash Balance)$4,612,934
<br />Cash Balance (Year-End) *$398,7502016
<br />IT Support Equipment Fund
<br />Less Amt Needed for OperationsN/A2017
<br />Planned CIP Surplus/Deficit19,0702017
<br /> $800,000
<br />Adjust for Delayed CIP Items-2017
<br /> $700,000
<br />Cash Balance (Beg. Year)$417,8202018
<br /> $600,000
<br />Adopted Budget (Excl.Capital)$2,019,6002017
<br /> $500,000
<br /> $400,000
<br />* Current Assets - Current Liabilities
<br /> $300,000
<br /> $200,000
<br /> $100,000
<br /> $-
<br />2018202120242027203020332036
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />EComputers (Notebooks, Desktop)$69,800$30,150$35,100$29,850$10,900$37,450$35,850$30,150$35,100$29,850$10,900$37,450$35,850$30,150$35,100$29,850$10,900$37,450$35,850$30,150$637,850
<br />EMonitor/Display8,7008,7008,7008,7008,7008,7008,7008,7008,7008,7008,7008,7008,7008,7008,7008,7008,7008,7008,7008,700174,000
<br />EMS Office License8,10011,70015,0009,90011,1008,10011,70015,0009,90011,1008,10011,70015,0009,90011,1008,10011,70015,0009,90011,100223,200
<br />EDesktop Printer1,200-----1,300-----1,400-----1,500-5,400
<br />ENetwork Switches/Routers (Rosevil38,0009,00013,00012,00078,000--38,00038,0009,00013,00012,00078,000--38,00038,0009,00013,00012,000448,000
<br />EPower/UPS - Closets (11)1,7001,7003,0001,7004008004001,7001,7001,7001,7002,1001,7004001,7004001,7008001,7001,70028,700
<br />EPower/UPS - Server Room (1)-18,000---5,000----5,000----5,000----33,000
<br />EAir Conditioner - Server Room Unit --38,000--------------38,000--76,000
<br />EAir Conditioner - Server Room Unit -------------18,000------18,000
<br />EFire Protection - Server Room (1)---19,000-------------20,000--39,000
<br />ESurveillance Cameras (53)9,1809,1809,1809,1809,1809,1809,1809,1809,1809,1809,1809,1809,1809,1809,1809,1809,1809,1809,1809,180183,600
<br />ETelephone Handsets (283)------85,000----------85,000--170,000
<br />EFiber Network Replacements------------350,000-------350,000
<br />ENetwork Racks---------------------
<br />EWireless Access Points (38)23,200-----30,400-----30,400-----30,400-114,400
<br />ETelephone Routers (Shared)---45,000-18,000-----45,000-18,000-----45,000171,000
<br />ETelephone Servers (Shared)----40,00040,00040,000---120,000
<br />EServers - Host - Shared (5)30,00020,000---30,00020,000---30,00020,000---30,00020,000---200,000
<br />EStorage Area Network Nodes- Share 55,000-55,000-55,000-55,000-55,000-55,000-55,000-55,000-55,000-55,000-550,000
<br />EWireless LAN Controllers (Shared)-----58,000---------58,000----116,000
<br />ENetwork Switches/Routers (Shared)10,00077,00060,00010,00077,00060,00010,000---304,000
<br />FOffice Furniture-25,000-------25,000-------25,000--75,000
<br />B---------------------
<br />$254,880$133,430$176,980$135,330$290,280$235,230$257,530$102,730$167,580$94,530$181,580$146,130$662,230$154,330$120,780$187,230$205,180$248,130$165,230$117,830$4,037,150
<br />
<br />
|