Loading...
HomeMy WebLinkAbout09. Information TechnologyINFORMATION TECHNOLOGY DEPARTMENT FY 2023/24 & 2024/25 ADOPTED BUDGET CITY OF AZUSA City Information Systems Light & Water Information Systems Sewer Information Systems Information Technology 1    INFORMATION    TECHNOLGY    PROGRAM DESCRIPTION  The Department of Information Technology provides leadership in the development of  powerful, cost‐effective technical services, and business solutions for City staff and policy  makers. Services include the management and support of the technology infrastructure and  network administration, providing citywide systems and solutions. Maintaining a 24/7 center  of information and services via WEB and social media to the community.   Ongoing responsibilities include: Strategic planning related to technology and the City’s  networking infrastructure; Software and hardware support of all systems including but not  limited to: software licensing, financial software systems, business licensing systems, building  permit systems, land management systems, geographic information systems (GIS), library  systems, utility billing and integrated systems, and all phone and telecom systems;  helpdesk,  internet, e‐mail, web sites, social media, wireless, and the fiber backbone and network  infrastructure and security on which all systems reside.   FY 2023-24 STRATEGIC GOALS AND OBJECTIVES  • Begin the 2‐year implementation of Office 365 and Active Directory   Website refresh   Implement Disaster Recovery for Utility Billing systems   Upgrade of Virtual Infrastructure for MITEL VOIP system    FY 2024-25 STRATEGIC GOALS AND OBJECTIVES  • Complete the implementation of O365 and Active Directory   Implement Multifactor Authentication(MFA) and single sign on   Transition mobile devices to Mobile Device Management for security, asset management  and support    FY 2022-23 ACCOMPLISHMENTS  • Evaluate migration to Office 365 and Outlook make recommendation for FY 23‐24  • Upgrade firewall and implement expanded network monitoring software  • Expand existing VX‐Rail storage network  • Implement the Govsense Land Management System software solution   Complete Finance System Software upgrade   Implement Disaster Recovery system for Finance   Information Technology 2 Description 6220 Training Schools - Microsoft Training, VM -Ware 6235 Meetings/Conferences - MISAC, Women Leading Government, CENIC, 6415 Computer Software Services - Central Square, SIRSI, ESRI, Civicplus, Granicus, Envisionware, BMI, PubWorks, Unitrends, Govsense 6493 Outside Services & Repairs - JD Briggs,SIRSI, EMP Electric 6499 Contract Services - Client First 6504 Computer Software Licensing - MS Office, Go to My PC, Netware, McAfee, Adobe, Novell Patch Management, Zenworks, GroupWise, Solarwinds Orion,Digicert,Veritas, Public Contract Software Service, zoom 6570 Computer Hardware Peripherals - GovConnection, CDW-G, PC Mall 6846 Computer Hardware Maintenance - Charter Fiber, Verizon T1x3, Cisco , Watchguard, Laser printer service, Hewlett Packard, Barracuda,Watchgard 6915 Utilities-Telephone - City phone expense, payphones, cell phones, aircards, CENIC Account Number 4849xxxxxx INFORMATION TECHNOLOGY ACTIVITY DETAIL (SUMMARY) Information Technology 3 INFORMATION TECHNOLOGY EXPENDITURE SUMMARY ALL FUND 48 ACTUAL REVISED YEAR END EST ADOPTED ADOPTED VARIANCE Acct. #DESCRIPTION 21‐22 22‐23 22‐23 23‐24 24‐25 23 to 24 PERSONNEL 6003 Salaries/Regular              591,507            816,660            620,268            910,892            949,049            94,232             6006 Salaries/Temp & Part‐Time     48,727              ‐                         16,302              ‐                         ‐                         ‐                        6012 Salaries/Comp‐Time 2,103                ‐                         ‐                         ‐                         ‐                         ‐                        6015 Salaries/Vacation 8,638                ‐                         38,737              ‐                         ‐                         ‐                        6024 Salaries/Sick Leave           31,910              ‐                         20,885              ‐                         ‐                         ‐                        6027 Salaries/Bereavement 2,679                ‐                         2,313                ‐                         ‐                         ‐                        6033 Overtime Pay/Premium 3,938                ‐                         5,015                5,015                ‐                         5,015               6039 Salaries/Standby 856                    ‐                         1,564                ‐                         ‐                         ‐                        6047 Covid Pay ‐                         7,500                5,250                ‐                         ‐                         (7,500)              6048 Salaries/Language Pay 10,040              8,805                7,048                4,500                4,500                (4,305)              6068 Allowances/Management 31                      ‐                         ‐                         2,400                2,400                2,400               6069 Allowances/Vehicle 5,415                5,400                5,180                2,400                2,400                (3,000)              6075 Vacation Pay‐Off              74,347              59,500              93,164              58,200              58,200              (1,300)              6078 Sick Leave Pay‐Off            11,701              12,400              28,783              18,000              18,000              5,600               6091 Leave Liability Adjustments (38,219)            ‐                         ‐                         ‐                         ‐                         ‐                        6101 PERS/Employee Contribution    40,844              55,945              33,394              64,285              66,960              8,340               6104 PERS Lump Sum ‐                         2,285                2,357                ‐                         ‐                         (2,285)              6105 PERS/Employer Contribution    (2,807,999)       30,470              38,806              35,810              37,300              5,340               6107 Apple Pay Plan 133                    ‐                         ‐                         ‐                         ‐                         ‐                        6109 PARS/Employer 17,501              18,060              23,179              ‐                         ‐                         (18,060)           6125 FICA/Employer Contrib/Med     11,763              14,120              11,861              15,690              16,250              1,570               6133 Retiree Health Premium Reimb  5,149                6,000                5,146                2,500                2,500                (3,500)              6140 Life Insurance Allocation     1,708                2,465                1,597                2,675                2,780                210                   6155 Workers' Comp Allocation      28,595              33,500              29,167              36,800              38,325              3,300               6160 LTD Insurance Allocation      5,555                6,410                5,306                7,075                7,375                665                   6165 Unemployment Allocation       584                    980                    539                    1,075                1,120                95                     6175 Benefits/Flex Plan            97,018              124,160            103,021            162,000            162,000            37,840             6180 Deferred Comp/Employer Paid   7,791                11,080              9,706                17,160              17,160              6,080               PERSONNEL SUBTOTAL (1,837,689)       1,215,740        1,108,588        1,346,477        1,386,319        130,737          OPERATIONS 6220 Training Schools              4,625                6,000                6,000                7,000                7,000                1,000               6230 Dues & Subscriptions          141                    1,100                1,100                1,600                1,600                500                   6235 Meetings & Conferences        148                    4,100                4,100                4,100                4,100                 ‐                        6240 Mileage Reimbursement         151                    400                    400                    400                    400                     ‐                        6415 Computer Software Support 355,209            435,700            435,700            425,780            468,475            (9,920)              6493 Outside Services & Repairs    16,861              63,040              63,040              82,342              63,040              19,302             6499 Contract Services & Fees/Other 67,485              230,943            230,943            254,425            185,320            23,482             6504 Computer Software/Licensing 226,452            296,260            294,760            294,760            324,235            (1,500)              6521 Messenger Service             ‐                         100                    100                    100                    100                    ‐                        6527 Supplies/Computer/Small Equipment 11,693              15,500              15,500              15,500              15,500               ‐                        6530 Office Supplies               658                    690                    690                    1,000                1,000                310                   6563 Supplies/Special              1,170                2,000                2,000                2,000                2,000                 ‐                        6569 Small Equipment               6,850                15,800              5,300                15,800              15,800              ‐                        6570 Computer Peripherals/Misc 8,726                15,000              15,000              15,000              15,000              ‐                        6835 Maint & Repair/Equipment      48,225              ‐                         ‐                         6,000                6,000                6,000               6846 Computer Hardware Maint/Repair 100,934            95,435              95,435              116,935            116,935            21,500             6915 Utilities/Telephone           176,702            224,300            153,613            167,745            183,178            (56,555)           OPERATIONS SUBTOTAL 1,026,030        1,406,368        1,323,681        1,410,487        1,409,683        4,119               CAPITAL OUTLAY 7142 Computer Equipment 17,906               ‐                          ‐                         395,329            65,048              395,329          7143 Computer Software 264,131             ‐                          ‐                         363,468            173,092            363,468          CAPITAL OUTLAY SUBTOTAL 282,037            ‐                          ‐                         758,797           238,140           758,797          INFORMATION TECH FUND TOTAL: (529,621)          2,622,108        2,432,269        3,515,761        3,034,142        893,653          Information Technology 4 ACCOUNT 4849930000 REVISED YEAR END EST ADOPTED ADOPTED VARIANCE ACCT # DESCRIPTION 22-23 22-23 23-24 24-25 23 to 24 EXPLANATION OPERATIONS 6220 Training Schools              3,000 3,000 3,500 3,500 500 Advanced VM Ware Training 6415 Computer Software Support 369,650 369,650 350,030 371,502 (19,620) Had some multi year agreements 6493 Outside Services & Repair 28,040 28,040 37,691 28,040 9,651 One time FY2324 Capital Outlay purchase to re- configure IT area. 6499 Contract Services & Fees/other 205,943.00  205,943.00       106,660.00  106,660.00  (99,283) Lower due to LMS System  completion, and the FY2223  revised budget included one  time appropriation of $84K in  the land mgmt sys and the  rest in budget carryforward  from FY2122. 6504 Computer Software/Licensing 189,963.00  189,963.00       176,380.00  191,117.00  (13,583) Had some mulit year  agreements  6846 Computer Hardware Maint/Repair 39,335.00    39,335.00         50,085.00    50,085.00    10,750 Anticipated increases in support costs on Gov Sense. CITY INFORMATION SYSTEMS DETAILED VARIANCE EXPLANATION Information Technology 5 ACCOUNT 4849940000 REVISED YEAR END EST ADOPTED ADOPTED VARIANCE ACCT # DESCRIPTION 22-23 22-23 23-24 24-25 23 to 24 EXPLANATION OPERATIONS 6835 Maint & Repair/Equipment - - 6,000 6,000 6,000 Phone replacements with additional liceses 6915 Utilities/Telephone 216,800 150,159 163,973 179,059 (52,827) anticipated reduction in telephone lines after new phone system implementation COMMUNICATION SERVICES DETAILED VARIANCE EXPLANATION Information Technology 6 ACCOUNT 48499420000 REVISED YEAR END EST ADOPTED ADOPTED VARIANCE ACCT # DESCRIPTION 22-23 22-23 23-24 24-25 23 to 24 EXPLANATION OPERATIONS 6220 Training Schools 3,000 3,000 3,500 3,500 500 additional staff traning 6230 Dues and Subscriptions 650 650 900 900 250 FY2324 Dues and Subcriptions 6415 Computer Software Support 66,050 66,050 75,750 96,973 9,700 additional software, KnowB4, Manage Engine.additional users 6493 Outside Services & Repair 35,000 35,000 44,651 35,000 9,651 One time FY2324 Capital Outlay purchase to re- configure IT area. 6499 Contract Services & Fee/Other 25,000 25,000 147,765 78,660 122,765 Client First GIS support 6504 Computer Software/Licensing 104,797 104,797 113,380 128,118 8,583 Additional liceses, SocialMedia Mgmt, Phising software, Increases in various software 6530 Office Supplies 200 200 500 500 300 FY2324 Office Supplies 6846 Computer Hardware Maint/Repair 56,100 56,100 66,850 66,850 10,750 increase in hardware support costs LIGHT & WATER INFORMATION SYSTEMS DETAILED VARIANCE EXPLANATION Information Technology 7 ACCOUNT 4849942120 REVISED YEAR END EST ADOPTED ADOPTED VARIANCE ACCT # DESCRIPTION 22-23 22-23 23-24 24-25 23 to 24 EXPLANATION OPERATIONS - - - - - 6915 Utilities/Telephone 7,500 3,454 3,772 4,119 (3,728) Anticipated upcoming costs for FY2324 and FY2425. LIGHT & WATER TECH FUND DETAILED VARIANCE EXPLANATION Information Technology 8 ACCOUNT 4849944000 REVISED YEAR END EST ADOPTED ADOPTED VARIANCE ACCT # DESCRIPTION 22-23 22-23 23-24 24-25 23 to 24 EXPLANATION OPERATIONS 6504 Computer/Software Licensing 1,500 1,500 5,000 5,000 3,500            additional licenses for  Public Works Dept. SEWER INFORMATION SYSTEMS DETAILED VARIANCE EXPLANATION Information Technology 9 Description 6235 Meetings/Conferences - Microsoft Training, VM -Ware 6415 Computer Software Services - Central Square, SIRSI, ESRI, Civicplus, Granicus, Govsense 6493 Outside Services & Repairs - JD Briggs SIRSI 6499 Contract Services - EMP Electric, Client First 6504 Computer Software Licensing - MS Office, Go To My PC, Netware, Adobe, GroupWise, Solarwinds Digicert,Public Contract Software Service, Mobile Device Management, Zoom, Trelix, 6846 Computer Hardware Maintenance - Laser printer services, Hewlett Packard Server support, Sonic Firewall, VX-Rail, Dell Account Number 4849930000 INFORMATION TECHNOLOGY - CITY ACTIVITY DETAIL Information Technology 10 Description 6220 Training Schools - Microsoft Training, VM-Ware 6235 MISAC 6415 Computer Software Services - SunGard, SIRSI, ESRI, HDL, Civicplus, Granicus, HDL 6493 Outside Services & Repairs - JD Briggs 6504 Computer Software Licensing - MS Office, Go to My PC, Netware, McAfee, Adobe, Novell Patch Management, Zenworks, GroupWise, Solarwinds Orion,Digicert,Veritas, Public Contract Software Service, zoom 6499 Contract Services - Client First 6570 Computer Hardware Peripherals - GovConnection, CDW-G, PC Mall 6846 Computer Hardware Maintenance - Charter Fiber, Verizon T1x3, Cisco , Watchguard, Laser printer service, Hewlett Packard Account Number 4849942000 ACTIVITY DETAIL INFORMATION TECHNOLOGY - LIGHT AND WATER INFORMATION SYSTEMS Information Technology 11 Description 4849942120 6915 Utilities-Telephone - City Council phones and aircards-Verizon Wireless INFORMATION TECHNOLOGY - LIGHT AND WATER TECHNOLOGY FUND Account Number ACTIVITY DETAIL Information Technology 12 Description 4849944000 6504 Computer Software Licensing - Autodesk, AutoCAD Account Number ACTIVITY DETAIL INFORMATION TECHNOLOGY - SEWER INFORMATION SYSTEM Information Technology 13 INFORMATION TECHNOLOGY EXPENDITURE DETAIL ALL FUND 48 ACTUAL REVISED YEAR END EST ADOPTED ADOPTED VARIANCE Acct. #DESCRIPTION 21‐22 22‐23 22‐23 23‐24 24‐25 23 to 24 PERSONNEL 4800000000 COMMUNICATION SERVICES 6105 PERS/Employer Contribution (2,840,093)       ‐ ‐ ‐ ‐ ‐  SUBTOTAL (2,840,093)      ‐ ‐ ‐ ‐ ‐  4849930000 CITY COMPUTER SERVICES         6003 Salaries/Regular              241,166           300,040         289,474           407,577         424,189         107,537          6006 Salaries/Temp & Part‐Time 24,364             ‐ 8,151               ‐ ‐ ‐  6012 Salaries/Comp‐Time            1,051               ‐ ‐ ‐ ‐ ‐  6015 Salaries/Vacation             2,758               ‐ 17,531             ‐ ‐ ‐  6024 Salaries/Sick Leave           8,943               ‐ 8,350               ‐ ‐ ‐  6027 Salaries/Bereavement          1,213               ‐ 995 ‐ ‐ ‐  6033 Overtime Pay/Premium          1,208               ‐ 2,365               2,365              ‐ 2,365               6039 Standby Pay/Premium 86 ‐ 782 ‐ ‐ ‐  6047 Covid Pay ‐ 2,630              2,005               ‐ ‐ (2,630)              6048 Salaries/Language Pay         4,210               3,600              3,231               2,250              2,250              (1,350)              6068 Allowances/Management 31 ‐ ‐ 2,400              2,400              2,400               6069 Allowance/Vehicle 2,707               2,700              2,590               ‐ ‐ (2,700)              6075 Vacation Pay‐Off              31,904             23,000            42,894             28,000            28,000            5,000               6078 Sick Leave Pay‐Out 5,851               6,200              15,912             10,000            10,000            3,800               6091 Leave Liability Adjustments (16,413)            ‐ ‐ ‐ ‐ ‐  6101 PERS/Employee Contribution    16,083             20,100            14,885             28,780            29,945            8,680               6104 PERS Lump Sum ‐ 815                 864 ‐ ‐ (815)                 6105 PERS/Employer Contribution    14,274             13,995            18,657             16,030            16,680            2,035               6107 Apple Pay Plan 66 ‐ ‐ ‐ ‐ ‐  6109 PARS/Employer Contribution    6,125               6,320              10,698             ‐ ‐ (6,320)              6125 FICA/Employer Contrib/Med     4,800               5,275              5,495               7,020              7,265              1,745               6133 Retiree Health Prem 5,149               6,000              5,146               2,500              2,500              (3,500)              6140 Life Insurance Allocation     677 905                 730 1,200              1,245              295                  6155 Workers' Comp Allocation      11,704             12,100            13,547             16,485            17,150            4,385               6160 LTD Insurance Allocation      2,293               2,350              2,477               3,165              3,295              815                  6165 Unemployment Allocation       231 365                 244 480                 500                 115                  6175 Benefits/Flex Plan            37,695             50,400            47,191             72,000            72,000            21,600             6180 Deferred Comp/Employer Paid   3,015               4,500              4,500               7,530              7,530              3,030               SUBTOTAL 411,192           461,295         518,714           607,782         624,949         146,487          4849942000 LIGHT AND WATER INFORMATION SYSTEMS         6003 Salaries/Regular              329,094           490,180         328,773           455,445         474,525         (34,735)           6006 Salaries/Temp & Part‐Time 24,364             ‐ 8,151               ‐ ‐ ‐  6012 Salaries/Comp‐Time            1,051               ‐ ‐ ‐ ‐ ‐  6015 Salaries/Vacation             4,818               ‐ 18,199             ‐ ‐ ‐  6024 Salaries/Sick Leave           20,184             ‐ 12,384             ‐ ‐ ‐  6027 Salaries/Bereavement 995 ‐ 717 ‐ ‐ ‐  6033 Overtime Pay/Premium          2,730               ‐ 2,650               2,650              2,650               6039 Standby Pay/Premium          770 ‐ 782 ‐ ‐ ‐  6047 Covid Pay ‐ 4,610              2,985               ‐ ‐ (4,610)              6048 Salaries/Language Pay         5,047               4,425              3,645               2,250              2,250              (2,175)              6069 Allowances/Vehicle 2,707               2,700              2,590               2,400              2,400              (300)                 6075 Vacation Pay‐Off              41,327             34,500            45,528             28,000            28,000            (6,500)              6078 Sick Leave Pay‐Off 5,851               6,200              12,429             8,000              8,000              1,800               6091 Leave Liability Adjustments (16,432)            ‐ ‐ ‐ ‐ ‐  6101 PERS/Employee Contribution    22,910             34,000            18,069             32,140            33,480            (1,860)              6104 PERS Lump Sum ‐ 1,390              1,417               ‐ ‐ (1,390)              Information Technology 14 INFORMATION TECHNOLOGY EXPENDITURE DETAIL ALL FUND 48 ACTUAL REVISED YEAR END EST ADOPTED ADOPTED VARIANCE Acct. #DESCRIPTION 21‐22 22‐23 22‐23 23‐24 24‐25 23 to 24 6105 PERS/Employer Contribution    17,002             15,625            19,963             17,905            18,650            2,280               6107 APPLE/EMPLOYER CONTRIBUTION 66                      ‐                        ‐                         ‐                        ‐                        ‐                        6109 PARS/Employer Contribution    11,376             11,740            12,480              ‐                        ‐                       (11,740)           6125 FICA/Employer Contrib/Med     6,570               8,380              6,202               7,850              8,125              (530)                 6140 Life Insurance Allocation     958                   1,480              851                   1,335              1,385              (145)                 6155 Workers' Comp Allocation      15,837             20,310            15,369             18,400            19,165            (1,910)              6160 LTD Insurance Allocation      3,066               3,855              2,785               3,540              3,690              (315)                 6165 Unemployment Allocation       328                   585                 284                   540                 560                 (45)                   6175 Benefits/Flex Plan            54,501             69,080            54,631             81,000            81,000            11,920             6180 Deferred Comp/Employer Paid   4,776               6,280              5,206               8,580              8,580              2,300               SUBTOTAL 559,896           715,340         576,089           670,035         689,810         (45,305)           COMMUNICATION SERVICES 6091 Leave Liability Adjustments (3,779)              ‐                       ‐                        ‐                       ‐                       ‐                        SUBTOTAL (3,779)              ‐                       ‐                        ‐                       ‐                       ‐                        LW TECHNOLOGY FUND 6091 Leave Liability Adjustments (75)                   ‐                       ‐                        ‐                        SUBTOTAL (75)                   ‐                       ‐                        ‐                       ‐                       ‐                        4849944000 SEWER INFORMATION SYSTEMS         6003 Salaries/Regular              21,247             26,440            2,021               47,870            50,335            21,430             6015 Salaries/Vacation             1,061               ‐                       3,007               ‐                       ‐                       ‐                        6024 Salaries/Sick Leave           2,782               ‐                       150                   ‐                       ‐                       ‐                        6027 Salaries/Bereavement 472                   ‐                       601                   ‐                        6047 Covid Pay ‐                        260                 260                   ‐                       ‐                       (260)                 6048 Salaries/Language Pay         783                   780                 172                   ‐                       ‐                       (780)                 6075 Vacation Pay‐Off              1,116               2,000              4,743               2,200              2,200              200                  6078 Sick Leave Pay‐Off ‐                        ‐                       442                   ‐                       ‐                       ‐                        6091 Leave Liability Adjustments (1,520)              ‐                       ‐                        ‐                       ‐                       ‐                        6101 PERS/Employee Contribution    1,850               1,845              441                   3,365              3,535              1,520               6104 PERS Lump Sum ‐                        80                   76                     ‐                       (80)                   6105 PERS/Employer Contribution    819                   850                 186                   1,875              1,970              1,025               6125 FICA/Employer Contrib/Med     393                   465                 164                   820                 860                 355                  6140 Life Insurance Allocation     73                     80                   16                     140                 150                 60                    6155 Workers' Comp Allocation      1,054               1,090              251                   1,915              2,010              825                  6160 LTD Insurance Allocation      196                   205                 44                     370                 390                 165                  6165 Unemployment Allocation       25                     30                   11                     55                   60                   25                    6175 Benefits/Flex Plan            4,822               4,680              1,199               9,000              9,000              4,320               6180 Deferred Comp/Employer Paid   ‐                        300                 ‐                        1,050              1,050              750                  SUBTOTAL 35,171             39,105            13,785             68,660            71,560            29,555             PERSONNEL SUBTOTAL (1,837,689)      1,215,740      1,108,588       1,346,477      1,386,319      130,737          OPERATIONS 4849930000 CITY COMPUTER SERVICES         6220 Training Schools              125                   3,000              3,000               3,500              3,500              500                  6230 Dues & Subscriptions          141                   450                 450                   700                 700                 250                  6235 Meetings & Conferences        148                   100                 100                   100                 100                  ‐                        6240 Mileage Reimbursement         33                     200                 200                   200                 200                  ‐                        6415 Computer Software Support 338,995           369,650         369,650           350,030         371,502         (19,620)           6493 Outside Services & Repairs    7,294               28,040            28,040             37,691            28,040            9,651               6499 Contract Services & Fees/Other 40,735             205,943         205,943           106,660         106,660         (99,283)           6504 Computer Software/Licensing 124,312           189,963         189,963           176,380         191,117         (13,583)           Information Technology 15 INFORMATION TECHNOLOGY EXPENDITURE DETAIL ALL FUND 48 ACTUAL REVISED YEAR END EST ADOPTED ADOPTED VARIANCE Acct. #DESCRIPTION 21‐22 22‐23 22‐23 23‐24 24‐25 23 to 24 6527 Supplies/Computer/Small Equip         4,572               6,800              6,800               6,800              6,800               ‐                        6530 Office Supplies               464                   490                 490                   500                 500                 10                    6563 Supplies/Special              716                   1,500              1,500               1,500              1,500               ‐                        6569 Small Equipment               3,812               3,300              3,300               3,300              3,300               ‐                        6846 Computer Hardware Maint/Repair 41,100             39,335            39,335             50,085            50,085            10,750             SUBTOTAL 562,448           848,771         848,771           737,446         764,004         (111,325)         4849940000 COMMUNICATION SERVICES         6415 Computer Software Support 100                    ‐                        ‐                         ‐                        ‐                       ‐                        6493 Outside Services & Repairs 255                   ‐                       ‐                        ‐                       ‐                       ‐                        6835 Maint & Repair/Equipment      48,225             ‐                       ‐                        6,000              6,000              6,000               6915 Utilities/Telephone           173,040           216,800         150,159           163,973         179,059         (52,827)           SUBTOTAL 221,620           216,800         150,159           169,973         185,059         (46,827)           4849942000 LIGHT AND WATER INFORMATION SYSTEMS         6220 Training Schools              4,500               3,000              3,000               3,500              3,500              500                  6230 Dues & Subscriptions          ‐                        650                 650                   900                 900                 250                  6235 Meetings & Conferences        ‐                        4,000              4,000               4,000              4,000              ‐                        6240 Mileage Reimbursement         118                   200                 200                   200                 200                 ‐                        6415 Computer Software Support 15,814             66,050            66,050             75,750            96,973            9,700               6493 Outside Services & Repairs    9,312               35,000            35,000             44,651            35,000            9,651               6499 Contract Services & Fees/Other 26,749             25,000            25,000             147,765         78,660            122,765          6504 Computer Software/Licensing 100,738           104,797         104,797           113,380         128,118         8,583               6521 Messenger Service             ‐                        100                 100                   100                 100                 ‐                        6527 Supplies/Computer/Small Equip 7,121               8,700              8,700               8,700              8,700              ‐                        6530 Office Supplies               194                   200                 200                   500                 500                 300                  6563 Supplies/Special 454                   500                 500                   500                 500                 ‐                        6569 Small Equipment               2,028               2,000              2,000               2,000              2,000              ‐                        6570 Computer Peripherals/Misc 8,726               15,000            15,000             15,000            15,000            ‐                        6846 Computer Hardware Maint/Repair 59,833             56,100            56,100             66,850            66,850            10,750             SUBTOTAL 235,589           321,297         321,297           483,796         441,001         162,499          4849942120 LIGHT AND WATER TECHNOLOGY FUND 6569 Small Equipment 1,010               10,500            ‐                        10,500            10,500            ‐                        6915 Utilities/Telephone           3,662               7,500              3,454               3,772              4,119              (3,728)              SUBTOTAL 4,672               18,000            3,454               14,272            14,619            (3,728)              4849944000 SEWER INFORMATION SYSTEMS        ‐                        6415 Computer Software Support 300                   ‐                       ‐                        ‐                       ‐                       ‐                        6504 Computer Software/Licensing 1,403               1,500              ‐                        5,000              5,000              3,500               SUBTOTAL 1,702               1,500              ‐                        5,000              5,000              3,500               OPERATIONS SUBTOTAL 1,026,030       1,406,368      1,323,681       1,410,487      1,409,683      4,119               CAPITAL OUTLAY 4849930000 CITY COMPUTER SERVICES         7142 Computer Equipment 9,090                ‐                        ‐                        164,721         36,383            164,721          7143 Computer Software 51,033              ‐                        ‐                        236,859         86,546            236,859          SUBTOTAL 60,122              ‐                        ‐                        401,580         122,929         401,580          4849942000 LIGHT AND WATER INFORMATION SYSTEMS         7142 Computer Equipment ‐                         ‐                        ‐                        230,608         28,665            230,608          7143 Computer Software 162,098            ‐                        ‐                        126,609         86,546            126,609          SUBTOTAL 162,098            ‐                        ‐                        357,217         115,211         357,217          Information Technology 16 INFORMATION TECHNOLOGY EXPENDITURE DETAIL ALL FUND 48 ACTUAL REVISED YEAR END EST ADOPTED ADOPTED VARIANCE Acct. #DESCRIPTION 21‐22 22‐23 22‐23 23‐24 24‐25 23 to 24 4849944000 SEWER INFORMATION SYSTEMS         7142 Computer Equipment 8,817                ‐                        ‐                         ‐                        ‐                        ‐                        7143 Computer Software 51,000              ‐                        ‐                         ‐                        ‐                        ‐                        SUBTOTAL 59,817              ‐                        ‐                         ‐                        ‐                        ‐                        CAPITAL OUTLAY SUBTOTAL 282,037            ‐                        ‐                        758,797         238,140         758,797          INFORMATION TECH FUND TOTAL: (529,621)         2,622,108      2,432,269       3,515,761      3,034,142      893,653          Information Technology 17