Loading...
HomeMy WebLinkAboutIT Budget Worksheet 2019 Actual Amount 2020 Adopted Budget 2020 Amended Budget 2021 Proposed Budget 225,946 216,200 216,200 214,255 8,354 8,700 8,700 8,700 1,158 - - - 83,197 19,400 19,400 21,410 19,782 22,000 22,000 26,749 3,102 3,100 3,100 3,233 26,391 37,800 37,800 44,783 15,656 9,700 9,700 12,969 3,992 4,200 4,200 6,307 2 - - - 67,086 - - - 2,855 3,000 3,000 3,000 5,054 4,000 3,985 4,000 4,931 4,000 1,600 4,000 - 800 800 800 425 800 800 - 1,300 - - - 799 - - - 3,269 7,000 7,000 1,000 473,299 340,700 338,285 351,206 Administration Totals: 5133 Education And Training 5167 Software Maintenance 5176 Copy Machine Charges 800 MISAC Annual Dues 5132 Meetings And Conferences 800 MISAC Annual Conference - Palm Springs Oct 2020 5111 Material And Supplies 5112 Small Tools And Equipment 5122 Dues And Subscriptions 9999 Suspense 5199 Depreciation Expense 5102 Computer Equip-Non Capital 5034 Calpers Unfunded Liability 5602 Workers Compensation 5603 Liability 5026 PERS Retirement 5027 Health Life Insurance 5029 Medicare 5011 Salaries Permanent Fulltime 5013 Auto Phone Allowance 5018 Vacation Pay Information technology Information Technology Administration Account Account Description 2019 Actual Amount 2020 Adopted Budget 2020 Amended Budget 2021 Proposed Budget 1,244 1,000 1,000 1,000 5,658 - 4,100 4,600 187 - - - 7,248 10,000 10,000 16,000 - 500 500 500 14,337 11,500 15,600 22,100 5505 Other Professional Services Print Shop Totals: 5174 Printing Charges 5176 Copy Machine Charges 16,000 Konica Copy Charges - all City copiers 5111 Material And Supplies 5171 Rentals 4,600 Call Center Mail Machine Rental Information Technology Fund Information Technology Print Shop Account Account Description 2019 Actual Amount 2020 Adopted Budget 2020 Amended Budget 2021 Proposed Budget 317,644 323,900 323,900 324,000 2,315 - - - 133,515 30,800 30,800 34,218 41,011 40,700 40,700 42,094 4,764 4,700 4,700 4,859 39,587 56,700 56,700 67,174 18,871 14,400 14,400 19,780 4,812 6,200 6,200 9,620 237,853 - - - 13,598 - - - - 245,000 245,000 - 0 - - - 4,418 3,000 3,000 3,000 3,101 7,800 6,200 5,453 6,000 7,000 7,000 7,500 1,594 6,000 6,000 - 20,187 - - - 275,373 285,200 285,200 506,518 9,305 34,300 34,300 - - 200 200 200 4,973 6,900 6,900 6,608 1,138,920 1,072,800 1,071,200 1,031,024 Business Systems Totals: 200 Document delivery and equipment shipments 5702 Computer Equipment 6,608 Backup system capacity expansion license (Commvault) 7,577 Web content management (Civica) 5172 Equipment Maintenance 5175 Postage 101,803 Permitting (Permits Plus) 12,491 Recruitment (NEOGOV) 51,000 Server virtualization (VMware) 170,000 Financials (New World ERP) 38,949 Microsoft operating system, database, clients 39,321 Payroll 15,750 CRM 8,576 Document management (Laserfiche) 495 File recovery (Undelete) 5167 Software Maintenance 45,314 Agenda management (MinuteTraq) 15,242 Backup software (Commvault) 2,000 Laserfiche Empower 2021 (Long Beach, CA) 4,000 Tyler Connect 2021 (San Antonio, TX) 5133 Education And Training 5122 Dues And Subscriptions 7,500 Property characteristics data 5132 Meetings And Conferences 3,098 Backup tapes 1,000 Miscellaneous supplies and consumables 1,355 W-2 electronic form update, W-2/1099 forms and envelopes 5102 Computer Equip-Non Capital 3,000 Desktop hardware, software, and peripherals 5111 Material And Supplies 5802 Debt Service Interest 5803 Lease Payments 9999 Suspense 5602 Workers Compensation 5603 Liability 5300 Amortization 5027 Health Life Insurance 5029 Medicare 5034 Calpers Unfunded Liability 5011 Salaries Permanent Fulltime 5018 Vacation Pay 5026 PERS Retirement Information Technology Fund Information Technology Business Systems Account Account Description 2019 Actual Amount 2020 Adopted Budget 2020 Amended Budget 2021 Proposed Budget 223,346 91,000 91,000 91,044 6,838 - - - 87,032 8,700 8,700 9,615 25,687 13,200 13,200 13,957 3,489 1,300 1,300 1,396 26,391 18,900 18,900 22,391 11,839 9,300 9,300 5,664 3,019 1,800 1,800 2,755 2,536 2,800 2,800 2,800 529 500 500 - 1,301 1,600 1,600 - - 75,000 75,000 88,500 70,000 500 500 500 - 500 500 - 462,008 225,100 225,100 238,622 5181 Other Operating Expense GIS & Office Automation Totals: 500 UNDELETE SOFTWARE ANNUAL MAINT. 5172 Equipment Maintenance 500 GIS Plotter Maintenance 5167 Software Maintenance 500 ESRI BUSINESS ANALYTICS 87,500 ESRI YEAR 2 OF 3 YEAR ELA ($75K, 87.5K, 100K) 5122 Dues And Subscriptions 5132 Meetings And Conferences 1,100 ESRI User Conference-San Diego July 2020 5602 Workers Compensation 5603 Liability 5111 Material And Supplies 5027 Health Life Insurance 5029 Medicare 5034 Calpers Unfunded Liability 5011 Salaries Permanent Fulltime 5018 Vacation Pay 5026 PERS Retirement Information Technology Fund Information Technology GIS & Office Automation Account Account Description 2019 Actual Amount 2020 Adopted Budget 2020 Amended Budget 2021 Proposed Budget 114,766 116,800 116,800 116,832 46,364 11,100 11,100 12,339 14,688 14,300 14,300 15,000 1,690 1,700 1,700 1,694 13,196 18,900 18,900 22,391 6,835 5,100 5,100 7,121 1,743 2,200 2,200 3,463 20 - - - 37,722 24,000 34,900 45,000 3,360 4,100 4,000 3,600 8,014 1,600 1,600 1,200 4,475 6,400 6,400 - 90,017 140,000 140,000 118,000 502,116 606,100 606,100 578,200 1,952 4,800 4,800 4,800 67,815 - - - 81 200 200 200 116,125 246,900 246,900 275,000 258 200 200 200 67,277 76,600 76,600 165,400 16,000 ATEL off contract system help 1,600 GoDaddy (Certs, DNS and web hosting) 13,800 LogMeIn (Remote access) 5175 Postage 200 Postage for RMA's 5502 Professional Contractual 120,000 NPA General h/w s/w maintenance 56,000 PBX Maintenance 65,000 Zeacom maintenance (or system upgrade) 5172 Equipment Maintenance 14,000 Fortinet firewall maintenance 20,000 Metropolis Call logging maintenance 5167 Software Maintenance 5171 Rentals 200 SPOK Pager rental for PD 1,200 Verizon landline 5166 Cable TV Charges 4,800 Time Warner cable tv charges 220,000 Frontier landline 1,000 PTS Feldhym payphone 340,000 TPX MPLS and PRI 110,000 Verizon cellular 5157 Telephone Charges 16,000 AT&T landline 6,400 Education and training (Fortinet, NEC) 5155 Cellular Service 8,000 Nextel cellular 5112 Small Tools And Equipment 1,200 Tools for networking maintenance and installation. 5133 Education And Training 2,000 Cable and general supplies (Graybar) 400 Office Depot general supplies 1,200 Verizon cellular supplies 15,000 Networking equipment for expansion and equip. failure. 30,000 Voip phones for Gig replacement at PD 5111 Material And Supplies 5603 Liability 9999 Suspense 5102 Computer Equip-Non Capital 5029 Medicare 5034 Calpers Unfunded Liability 5602 Workers Compensation 5011 Salaries Permanent Fulltime 5026 PERS Retirement 5027 Health Life Insurance Information Technology Fund Information Technology Network Services Account Account Description 2019 Actual Amount 2020 Adopted Budget 2020 Amended Budget 2021 Proposed Budget Information Technology Fund Information Technology Network Services Account Account Description 8,172 16,000 - - - - 5,100 - 1,106,687 1,297,000 1,296,900 1,370,440 5702 Computer Equipment 5704 Miscellaneous Equipment Network Services Totals: 24,000 Spectrum (Direct fiber Internet access) 30,000 Upgrade to Metro call logger 80,000 Upgrade to UCB19 (voice mail and IVR/AA/ACD) 2019 Actual Amount 2020 Adopted Budget 2020 Amended Budget 2021 Proposed Budget 152,540 155,200 155,200 155,256 75,415 14,800 14,800 16,397 17,317 29,000 29,000 18,171 2,237 2,300 2,300 2,251 26,391 37,800 37,800 44,783 1,937 1,900 1,900 1,895 9,298 7,500 7,500 9,377 2,371 3,100 3,100 4,560 717 1,000 1,000 1,032 24 - - - 104,626 50,000 50,000 50,000 - 5,000 1,000 5,000 - - 5,000 - 17,850 - - - 70,797 150,400 150,400 128,000 19,938 24,500 19,500 24,500 172 - - - 28,292 30,000 34,015 30,000 529,922 512,500 512,515 491,222 5505 Other Professional Services 30,000 Iron Mountain Data offsite storage Client Services Totals: 5172 Equipment Maintenance 24,500 Desktop & Printer Maintenance 5175 Postage 2,000 Lan Sweeper 15,000 Mimecast 25,000 Trend Mirco Security 5133 Education And Training 5167 Software Maintenance 86,000 Hosted Microsoft Exchange 5111 Material And Supplies 5,000 General Office Supply 5112 Small Tools And Equipment 9999 Suspense 5102 Computer Equip-Non Capital 50,000 Technology replacement fund 5602 Workers Compensation 5603 Liability 5612 Fleet Charges Fuel 5029 Medicare 5034 Calpers Unfunded Liability 5601 Garage Charges 5011 Salaries Permanent Fulltime 5026 PERS Retirement 5027 Health Life Insurance Information Technology Fund Information Technology Client Services Account Account Description 2019 Actual Amount 2020 Adopted Budget 2020 Amended Budget 2021 Proposed Budget 369,595 378,500 378,500 348,557 2,325 - - - 168,112 37,000 37,000 39,833 56,015 56,200 56,200 60,003 5,508 5,500 5,500 5,103 52,782 75,600 75,600 89,566 22,735 17,400 17,400 22,139 5,799 7,400 7,400 10,767 356,780 - - - 9 - - - 11,102 9,000 9,000 8,960 1,150 3,000 3,000 3,000 22,017 3,300 3,300 - - - - 97,879 158,341 159,900 174,900 163,261 5,242 9,500 9,500 9,510 71,568 166,500 212,500 164,119 5172 Equipment Maintenance 25,000 Celplan - hardware T&M (cameras, encoders, etc) 48,000 County - Citywide 800 Time and Materials 5,400 County CPU charges 221 County pager fees 3,888 County WAN monthly fees 20,500 TriTech - Omega Group Crimeview maintenance 6,300 VIP - Digital Belt recorder system maintenance 5171 Rentals 18,585 Intime Solutions - PD scheduling system maintenance 9,500 Netmotion annual maintenance 365 ReCrystallize server maintenance 5,500 Coplogic (LexisNexis - Coplogic maintenance) 5,200 Copware - electronic code book maintenance 51,000 Dell - VMWare mMaintenance - year 4 of 5 20,000 Chameleon - Animal Control system maintenance 2,900 Civica - PD intranet 13,791 Commvault software maintenance (PD portion) 5167 Software Maintenance 4,112 AT Solutions - Scene PD maintenance 5,508 Celplan - PD building surveillance system maintenance 2,500 Tyler Connect 2021 Conference (San Antonio, TX) 5157 Telephone Charges 97,878 Verizon - 4G broadband wireless for PD field units (was in 5502) 500 California User Group Training 110 CCUG Membership and Training 160 MISAC membership 1,000 Getac Batteries 2,000 Small computer parts (keyboards, mouse, monitiors, batteries) 5133 Education And Training 4,060 Backup tapes 2,500 Misc broken equipment 5111 Material And Supplies 9999 Suspense 5102 Computer Equip-Non Capital 2,400 4G Vehicle Antennas 5602 Workers Compensation 5603 Liability 5300 Amortization 5027 Health Life Insurance 5029 Medicare 5034 Calpers Unfunded Liability 5011 Salaries Permanent Fulltime 5014 Salaries Temporary Parttime 5026 PERS Retirement Information Technology Fund Information Technology Public Safety Systems Account Account Description 2019 Actual Amount 2020 Adopted Budget 2020 Amended Budget 2021 Proposed Budget Information Technology Fund Information Technology Public Safety Systems Account Account Description 6,510 7,100 7,100 6,194 112,963 97,900 97,900 - (216) - - - 1,428,337 1,033,800 1,094,800 1,028,891 5702 Computer Equipment Public Safety Systems Totals: 5181 Other Operating Expense 6,194 Commvault 1TB backup storage expansion 5502 Professional Contractual 3,700 Linear Systems - DIMS maintenance 19,200 QPCS - 4G wireless system backbone maintenance 5,000 West Coast Lights & Sirens - MDC installation T&M 36,768 County - dispatch console maintenance 23,388 ECS - document imaging system maintenance 3,063 EMC - DD2200 maintenance 2019 Actual Amount 2020 Adopted Budget 2020 Amended Budget 2021 Proposed Budget - - - 60,000 - - - 60,000 Cable Television Fund Totals: 5167 Software Maintenance 60,000 City Website Upgrades Cable Television Fund Information Technology Business Systems Account Account Description