Public records library › 26-262 › IS Allocations 2027.xlsx
Request 26-262
IS Allocations 2027.xlsx
Excel · 318 KB · released by the City of Moscow on request 26-262
Excel file. Download it to open in the matching program.
SHA-256 3793578efc17f1c234dccab17f45f20de7024ae7af6b4cafec63ff0ea556b4c1
Extracted text
Machine-extracted text layer of the file above, shown verbatim for search and reading. Tables and slides lose their layout. The original file governs.
# IS Allocations 2027.xlsx - path: - path: IS Allocations 2027.xlsx - type: xlsx - size: 318243 bytes - sheets: 18 - extraction method: xlsx (openpyxl, cached values) === Sheet: Task tracker and how to === | | | | | | | | | done | not done | started How to work this sheet and do the IS budget. 1 | In the Access DB "hardware inventory.mdb"- create/copy the queries that will spit out the systems that are due for replacement. Its called FY 2027 Computer. In design view, change the criteria to show you the systems purchased FOR not nessissaritlly IN FY23 | Use that to A. know how many computers to order and B. other stuff later on in 4f 2 | Compile planning requests. You will send these out to depts to get their needs for the FY - examples are in the budget folders - self explanitory 3 | Send out the planning requests, and a blank request form by a date in feb, enough time for you to you to get the this Allocation Sheet to Finance by the required time in March, as noted on the budget calendar. | a. determine IS needs as well for step 4d 4 | Do this spreadsheet - make a copy of the previous year and start from that. If things are highlighted green, its because I (maybe you) marked them done, so you didn’t lose your place because the phone rang 9 times. | a. | Copy the table from "deprec+central+ renewal+phone" down below for the history, do the same kind of thing with the columns for the "Budget History" tab | b. | Update the inventory tab, these are likely small adds or subtracts, since we arent adding many systems each year. | c | Update costs on the depreciation tab to keep up with what we are actually spending for laptops, mdts, desktops etc, give a buffer, account for docking stations and monitors etc tariffs etc | d | On "crea_centralized" tab make a new column for the FY you are working on and do the work to populate sheet. | | 1 | figure out what you need here. This column and tab fund IS. Important. | e | Populate "New" tab with results from the Planning Requests that came back from departments. | f | Populate "Actual Replacement" tab with results from the Access DB | g | Ask Sarah about "From Accumulation" tab | h | Don’t touch "Transfers and Replacements" tab - it is auto populated. | i | Update the "Budget Recap" tab and work with Sarah | j | Update the "Budget History" tab and work with Sarah | | | | | | | | | | racom | 1110167.5 | | | | | | | | | | motorola | 1041362.55 | | | | | | | | | | | 2151530.05 | | | | | | | | | | plus 20k for kvl etc | 2171530.5 | | | | | | | | | | minus 369k already spent | 1802354.5 [24 non-empty rows] === Sheet: inventory === | | | | | | | | Printer type | Printer type | Printer type | Printer type | Printer type | Printer type | Printer type | Desktop | laptop / desktop plus | eng desktop | tablet | MDT | PD Server & storage | SCADA server | desk | small workgroup | med workgroup | large workgroup | Production Copier | Plotter/scanner | Sheet Copier | Timeclock | phones | fax | users | | total printers | users+workstations | phones+faxes+timeclocks | total of all totals | | | | | | | | | | | | | | | | | | | | 0 Legislative | 0 | 0 | 0 | 6 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | | 0 | 12 | 0 | 12 Executive | 0 | 1 | 0 | 1 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | | 0 | 3 | 1 | 4 Admin | 0 | 3 | 1 | 0 | 0 | | | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 5 | 0 | 4 | | 2 | 8 | 5 | 15 Finance | 1 | 5.5 | 0 | 0 | 0 | | | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 7 | 0 | 7 | | 2 | 13.5 | 7 | 22.5 Legal | 2 | 5 | 0 | 0 | 0 | | | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 6 | | 1 | 13 | 4 | 18 HR | 0 | 2 | 0 | 0 | 0 | | | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | | 1 | 4 | 2 | 7 Building-grounds (Facilities) | 1 | 1 | 0 | 3 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 3 | | 0 | 8 | 1 | 9 | 0 | 0 | | 0 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | 0 | 0 Non-Departmental | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | | 0 | 0 | 0 | 0 URA | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | 0 | 0 Total General Govt | 4 | 17.5 | 1 | 10 | 0 | | | 1 | 1 | 2 | 0 | 2 | 0 | 0 | 0 | 20 | 0 | 29 | | 6 | 61.5 | 20 | 87.5 Parks | 14 | 7 | 0 | 6 | 0 | | | 1 | 5 | 2 | 1 | 1 | 0 | 0 | 3 | 16 | 0 | 35 | | 10 | 62 | 19 | 91 Arts | 0 | 2 | 0 | 0 | 0 | | | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | | 1 | 4 | 2 | 7 Events | 0 | 2 | | 2 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | | 0 | 6 | 2 | 8 Public Safety Police | 22 | 20 | 0 | 2 | 15 | 4 | | 15 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 31 | 0 | 52 | | 18 | 111 | 31 | 164 Police Parking | 2 | 0 | 0 | 0 | 1 | | | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | | 2 | 5 | 2 | 9 Fire | 2 | 9 | 0 | 5 | 6 | | | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 7 | 0 | 11 | | 3 | 33 | 7 | 43 CPD | 6 | 17 | 7 | 0 | 0 | | | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 21 | 0 | 20 | | 6 | 50 | 21 | 75 Total Public Safety | 32 | 46 | 7 | 7 | 22 | 4 | | 18 | 2 | 1 | 1 | 4 | 1 | 0 | 0 | 61 | 0 | 85 | | 29 | 199 | 61 | 291 Water | 11 | 13.2 | 0 | 2 | 0 | | 2 | 3 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 17 | 0 | 18.2 | | 5 | 44.4 | 17 | 68.4 Sewer | 12 | 8.2 | 0 | 2 | 0 | | 2 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 13 | 0 | 14.2 | | 3 | 36.4 | 13 | 54.400000000000006 Street | 6 | 5.2 | 0 | 8 | 0 | | | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 10 | 0 | 10.2 | | 3 | 29.4 | 10 | 42.400000000000006 Fleet | 0 | 3 | 0 | 2 | 0 | | | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 4 | | 3 | 9 | 6 | 18 Sanitation | 0 | 0.7 | 0 | 0 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1.2 | | 0 | 1.9 | 1 | 2.9 Storm Water | 0 | 3.2 | 0 | 3 | 0 | | | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3.2 | | 1 | 9.4 | 3 | 13.399999999999999 Total | 79 | 108.00000000000001 | 8 | 42 | 22 | 4 | 4 | 30 | 10 | 5 | 3 | 10 | 1 | 0 | 3 | 150 | 1 | 203.99999999999994 | | 61 | 462.9999999999999 | 154 | 683.9999999999999 IS | 3 | 10 | 0 | 0 | | | | | | | | | | | | 6 | | 5 Total with IS | 82 | 118.00000000000001 | 8 | 42 | 22 | 4 | 4 | 30 | 10 | 5 | 3 | 10 | 1 | 0 | 3 | 156 | 1 | 208.99999999999994 | | 61 replacement | 550 | 650 | 1380 | 300 | 1250 | 7725 | 1375 | 437 | 1592 | 2652 | 3845 | 6630 | 15915 | 10610 | 1030 | 103 | 103 value | 45100 | 76700.00000000001 | 11040 | 12600 | 27500 | 30900 | 5500 | 13110 | 15920 | 13260 | 11535 | 66300 | 15915 | 0 | 3090 | 16068 | 103 Total value user equipment | 364641 Main IT Servers | 36050 SAN | 15850 Back up storage | 14210 Switches | 75000 Network appliances | 36000 Wireless | 12000 PBX | 60000 Battery Backups | 11000 [44 non-empty rows] === Sheet: depreciation === Department | Desktop | | Laptop/ desktop plus | | eng desktop | | tablet | | MDT | | PD Servers/storage | | SCADA Servers | | Large IS Servers | | Small IS Servers | | 10p & 24p IS Switches | | 48p IS Switches | | Desktop Printer | | Small Workgroup Printer | | Medium Capacity Workgroup Printer | | Large Capacity Workgroup Printer | | Production Copier | | Production Copier/Plotter/scanner | | Sheet Copier | | Phones | | Time clocks | | Backup SAN | | SAN | | Total Depreciation Expenses | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation | Inventory | Annual Depreciation Replacement Cost | | 550 | | 650 | | 1380 | | 300 | | 1250 | | 7725 | | 1375 | 10 | 36050 | 2 | 2835 | 22 | 14300 | 5 | 5775 | | 437 | | 1592 | | 2652 | | 3845 | | 6630 | | 15915 | | 10610 | | 103 | | 1030 | 1 | 14210 | 1 | 15850 Service Life (yrs.) | | 4 | | 4 | | 4 | | 3 | | 4 | | 5 | | 5 | | 6 | | 6 | | 6 | | 6 | | 4 | | 5 | | 5 | | 5 | | 5 | | 7 | | 7 | | 8 | | 7 | | 6 | | 6 per year | | 137.5 | | 162.5 | | 345 | | 100 | | 312.5 | | 1545 | | 275 | | 6008.333333333333 | | 472.5 | | 2383.3333333333335 | | 962.5 | | 109.25 | | 318.4 | | 530.4 | | 769 | | 1326 | | 2273.5714285714284 | | 1515.7142857142858 | | 12.875 | | 147.14285714285714 | | 2368.3333333333335 | | 2641.6666666666665 IS Dep. Allocation | 3 | 412.5 | 10 | 1625 | 0 | 0 | 0 | 0 | | | | | | | 10 | | 2 | | 22 | | 5 per year per computer | | 5.2215189873417724 | | 15.046296296296294 | | 0 | | 0 General Government Legislative | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 600 | | | | | | | | 127.38515901060073 | | 10.01766784452297 | | 50.530035335689064 | | 20.406360424028275 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 50.212014134275634 | | 56.007067137809194 | 914.558303886926 Executive | 0 | 0 | 1 | 177.5462962962963 | 0 | 0 | 1 | 100 | | | | | | | | 21.230859835100123 | | 1.669611307420495 | | 8.421672555948177 | | 3.4010600706713787 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 12.875 | 0 | 0 | | 8.368669022379272 | | 9.334511189634867 | 342.84768027745065 Admin | 0 | 0 | 3 | 532.6388888888889 | 1 | 345 | 0 | 0 | | | | | | | | 84.92343934040049 | | 6.67844522968198 | | 33.68669022379271 | | 13.604240282685515 | 0 | 0 | 1 | 318.4 | 0 | 0 | 0 | 0 | 1 | 1326 | 0 | 0 | 0 | 0 | 5 | 64.375 | 0 | 0 | | 33.47467608951709 | | 37.33804475853947 | 2796.119424813506 Finance | 1 | 142.72151898734177 | 5.5 | 976.5046296296296 | 0 | 0 | 0 | 0 | | | | | | | | 169.84687868080098 | | 13.35689045936396 | | 67.37338044758542 | | 27.20848056537103 | 0 | 0 | 0 | 0 | 1 | 530.4 | 0 | 0 | 1 | 1326 | 0 | 0 | 0 | 0 | 7 | 90.125 | 0 | 0 | | 66.94935217903418 | | 74.67608951707894 | 3485.162220466206 Legal | 2 | 285.44303797468353 | 5 | 887.7314814814815 | 0 | 0 | 0 | 0 | | | | | | | | 169.84687868080098 | | 13.35689045936396 | | 67.37338044758542 | | 27.20848056537103 | 1 | 109.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 51.5 | 0 | 0 | | 66.94935217903418 | | 74.67608951707894 | 1753.3355913053995 HR | 0 | 0 | 2 | 355.0925925925926 | 0 | 0 | 0 | | | | | | | | | 42.461719670200246 | | 3.33922261484099 | | 16.843345111896355 | | 6.802120141342757 | 0 | 0 | 0 | 0 | 1 | 530.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 25.75 | 0 | 0 | | 16.737338044758545 | | 18.669022379269734 | 1016.0953605549013 Building-grounds (Facilities) | 1 | 142.72151898734177 | 1 | 177.5462962962963 | 0 | 0 | 3 | | | | | | | | | 84.92343934040049 | | 6.67844522968198 | | 33.68669022379271 | | 13.604240282685515 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 12.875 | 0 | 0 | | 33.47467608951709 | | 37.33804475853947 | 542.8483512082554 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | | | | | | | | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 0 | | 0 | 0 Non-Departmental | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | | | | | | | | | | | | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 URA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | | | | | | | | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | | 0 Total General Govt | 4 | 570.8860759493671 | 17.5 | 3107.060185185185 | 1 | 345 | 10 | 700 | | | | | | | | 700.618374558304 | | 55.097173144876336 | | 277.9151943462898 | | 112.2349823321555 | 1 | 109.25 | 1 | 318.4 | 2 | 1060.8 | 0 | 0 | 2 | 2652 | 0 | 0 | 0 | 0 | 20 | 257.5 | 0 | 0 | | 276.166077738516 | | 308.0388692579506 | 10850.966932512645 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 0 Parks and Recreation | 14 | 1998.1012658227849 | 7 | 1242.8240740740741 | 0 | 0 | 6 | 600 | | | | | | | | 1040.312131919906 | | 81.81095406360426 | | 412.66195524146065 | | 166.65194346289755 | 1 | 109.25 | 5 | 1592 | 2 | 1060.8 | 1 | 769 | 1 | 1326 | 0 | 0 | 0 | 0 | 16 | 206 | 3 | 441.42857142857144 | | 410.06478209658434 | | 457.39104829210845 | 11914.296726401994 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 0 Arts | 0 | 0 | 2 | 355.0925925925926 | 0 | 0 | 0 | 0 | | | | | | | | 42.461719670200246 | | 3.33922261484099 | | 16.843345111896355 | | 6.802120141342757 | 1 | 109.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 25.75 | 0 | 0 | | 16.737338044758545 | | 18.669022379269734 | 594.9453605549013 Events | 0 | 0 | 2 | 355.0925925925926 | 0 | 0 | 2 | 200 | | | | | | | | 42.461719670200246 | | 3.33922261484099 | | 16.843345111896355 | | 6.802120141342757 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 25.75 | 0 | 0 | | 16.737338044758545 | | 18.669022379269734 | 685.6953605549013 Public Safety | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 0 | | 0 | | 0 | | | | 0 Police | 22 | 3139.873417721519 | 20 | 3550.925925925926 | 0 | 0 | 2 | 200 | 15 | 4687.5 | 4 | 1250 | | 0 | | 1571.0836277974088 | | 123.55123674911663 | | 623.203769140165 | | 251.678445229682 | 15 | 1638.75 | 1 | 318.4 | 1 | 530.4 | 0 | 0 | 1 | 1326 | 0 | 0 | 0 | 0 | 31 | 399.125 | 0 | 0 | | 619.2815076560661 | | 690.75382803298 | 20920.52675825286 Police Parking | 2 | 285.44303797468353 | 0 | 0 | 0 | 0 | 0 | | | | | | | | | 84.92343934040049 | | 6.67844522968198 | | 33.68669022379271 | | 13.604240282685515 | 2 | 218.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 25.75 | 0 | 0 | | 33.47467608951709 | | 37.33804475853947 | 739.3985738993007 Fire | 2 | 285.44303797468353 | 9 | 1597.9166666666667 | 0 | 0 | 5 | 500 | 6 | 1875 | | 0 | | 0 | | 276.0011778563016 | | 21.704946996466436 | | 109.48174322732629 | | 44.21378091872792 | 1 | 109.25 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2652 | 0 | 0 | 0 | 0 | 7 | 90.125 | 0 | 0 | | 108.79269729093053 | | 121.34864546525326 | 7791.277696396357 | | 628949 Engineering | 6 | 856.3291139240506 | 17 | 3018.287037037037 | 7 | 2415 | 0 | 0 | | | | | | | | 552.0023557126032 | | 43.40989399293287 | | 218.96348645465258 | | 88.42756183745584 | 0 | 0 | 1 | 318.4 | 0 | 0 | 1 | 769 | 1 | 1326 | 1 | 2273.5714285714284 | 0 | 0 | 21 | 270.375 | 0 | 0 | | 217.58539458186107 | | 242.6972909305065 | 12610.04856304253 | | 359125 Total Public Safety | 32 | 4567.0886075949375 | 46 | 8167.12962962963 | 7 | 2415 | 7 | 700 | 21 | 6562.5 | 4 | 1250 | 0 | 0 | | 2484.0106007067143 | | 195.34452296819794 | | 985.3356890459368 | | 397.92402826855135 | 18 | 1966.5 | 2 | 636.8 | 1 | 530.4 | 1 | 769 | 4 | 5304 | 1 | 2273.5714285714284 | 0 | 0 | 61 | 785.375 | 0 | 0 | | 979.1342756183747 | | 1092.1378091872793 | 42061.25159159105 | | 1034327.0000000002 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 43466 Water | 11 | 1569.9367088607596 | 13.2 | 2343.611111111111 | 0 | 0 | 2 | | | 0 | | 0 | 2 | 625 | | 619.9411071849236 | | 48.75265017667846 | | 245.91283863368676 | | 99.31095406360426 | 3 | 327.75 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2652 | 0 | 0 | 0 | 0 | 17 | 218.875 | 0 | 0 | | 244.36513545347475 | | 272.5677267373381 | 9268.023232221578 Sewer | 12 | 1712.6582278481012 | 8.2 | 1455.8796296296293 | 0 | 0 | 2 | | | 0 | | 0 | 2 | 625 | | 556.2485276796232 | | 43.74381625441697 | | 220.64782096584221 | | 89.10777385159012 | 2 | 218.5 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1326 | 0 | 0 | 0 | 0 | 13 | 167.375 | 0 | 0 | | 219.25912838633693 | | 244.5641931684335 | 6878.9841177839735 Streets | 6 | 856.3291139240506 | 5.2 | 923.2407407407408 | 0 | 0 | 8 | | | 0 | | 0 | | 0 | | 343.93992932862193 | | 27.047703180212018 | | 136.43109540636044 | | 55.097173144876336 | 2 | 218.5 | 0 | 0 | 0 | 0 | 1 | 769 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 128.75 | 0 | 0 | | 135.5724381625442 | | 151.21908127208482 | 3745.1272751594906 Fleet Management | 0 | 0 | 3 | 532.6388888888889 | 0 | 0 | 2 | 200 | | 0 | | 0 | | 0 | | 84.92343934040049 | | 6.67844522968198 | | 33.68669022379271 | | 13.604240282685515 | 2 | 218.5 | 1 | 318.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 64.375 | 0 | 0 | | 33.47467608951709 | | 37.33804475853947 | 1543.6194248135064 Sanitation | 0 | 0 | 0.7 | 124.28240740740739 | 0 | 0 | 0 | | | 0 | | 0 | | 0 | | 25.47703180212014 | | 2.0035335689045937 | | 10.106007067137812 | | 4.081272084805654 | 1 | 109.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 12.875 | 0 | 0 | | 10.042402826855126 | | 11.201413427561839 | 309.3190681847925 Storm Water | 0 | 0 | 3.2 | 568.1481481481482 | 0 | 0 | 3 | | | 0 | | 0 | | 0 | | 67.93875147232039 | | 5.342756183745585 | | 26.949352179034168 | | 10.883392226148413 | 0 | 0 | 1 | 318.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 38.625 | 0 | 0 | | 26.779740871613672 | | 29.870435806831573 | 1092.937576887842 | | Departments Total Totals | 79 | 11275.000000000002 | 108.00000000000001 | 19175.000000000004 | 8 | 2760 | 42 | 2400 | 21 | 6562.5 | 4 | 1250 | 4 | 1250 | | 6008.333333333334 | | 472.5000000000001 | | 2383.333333333334 | | 962.5000000000003 | 31 | 3386.75 | 10 | 3184 | 5 | 2652 | 3 | 2307 | 10 | 13260 | 1 | 2273.5714285714284 | 0 | 0 | 150 | 1931.25 | 3 | 441.42857142857144 | | 2368.333333333334 | | 2641.6666666666674 | 88945.16666666667 | | 88945.16666666667 | | 33825.00000000001 | | 57525.000000000015 | | 8280 | | 4800 | | 19687.5 | | 5000 | | 5000 | | 30041.66666666667 | | 2362.5000000000005 | | 11916.66666666667 | | 4812.500000000002 | | 10160.25 | | 12736 | | 10608 | | 9228 | | 53040 | | 13641.42857142857 | | 0 | | 13518.75 | | 2648.5714285714284 | | 11841.66666666667 | | 13208.333333333338 | 333881.8333333334 [39 non-empty rows] === Sheet: crea_centralized === final centralized | 1199946.6099999999 10-510-11 | Full-Time Wages | 435282 | | | | | | | 2027 | 2026 | 2025 | 2024 | 2023 | 2022 | 2021 | 2020 | 2019 | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 | 2011 10-510-15 | Part-Time Wages | | | | | | 10-510-15 | Part -Time Wages | | | | | | | | | | | | 8112 | 4000 10-510-19 | Overtime | 500 | | | | | | Hours | | | | | | | | | | | | 624 | 320 10-520-21 | FICA Taxes | 33337 | | | | | | Wage | | | | | | | | | | | | 13 | 12.5 10-520-22 | PERSI ( State Retirement) | 52120 | | | | | 10-642-10 | Professional Services 10-520-23 | Unemployment Insurance | 1307 | | | | | | Radio maintenance | 15000 | 15000 | 15000 | 15000 | 15000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 5000 | 5000 | 5000 | 5000 10-520-24 | Worker's Compensation | 692 | | | | | | Fiber Optic network maintenance | 10000 | 10000 | 10000 | 70000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 10-520-25 | Health & Accident Insurance | 93900 | | | | | | Potential fiber builds | 50000 | 50000 | 50000 | 0 | | | | | | | | | | | | 1000 10-520-26 | Life Insurance | 2952 | | | | | | Electrician services | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 0 | Total Personal Services | | | 620090 | | | | Phone system maintance | 2500 | 2500 | 2500 | 2500 | 2500 | 2200 | 2200 | 2200 | 2200 | 2200 | 0 | 0 | 0 | 0 | 0 | 0 | | | | | | | | Water tank Cell tower inspections | 2000 | 2000 | 2000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 10000 IS operations | | | | | | | 10-642-35 | Total | 80500 | 80500 | 80500 | 92500 | 31500 | 26200 | 26200 | 26200 | 26200 | 26200 | 24000 | 19000 | 19000 | 19000 | 19000 10-642-10 | Professional Services | 80500 10-642-50 | Health Program - VEBA | 3000 | sarah will update this | | | | | Professional Services IS Computer | | | | | | | | | | | | | | | | 73000 10-642-35 | Professional Services IS Computer | 234450.61000000002 | | | | | | I.S. Software support renewals | 229450.61000000002 | 208627.98 | 160000 | 183000 | 150000 | 130000 | 110000 | 110000 | 100000 | 95000 | 95000 | 95000 | 90000 | 90000 | 80000 | 3500 10-668-10 | Liability Insurance | 4298 | sarah will update this | | | | | New unanticipated software needs | 5000 | 5000 | 2000 | 15000 | 15000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 7000 | 7000 | 5000 | 30000 10-631-05 | Office Supplies | 1500 | | | | | | GIS | moved into department renewals | moved into department renewals | 29000 | 27000 | 27000 | 27000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 50000 | 25000 10-631-10 | Postage | 500 | | | | | | | | | | | | | 800 | 800 | | 0 | 0 | 0 | 0 10-632-40 | Department Supplies | 9500 | | | | | | Bluebeam | moved into department renewals | moved into department renewals | 3500 | 10080 | 4200 | 2000 | 800 | 800 | 800 | 800 | 800 | 600 | 3000 10-647-10 | Travel & Meetings | 2500 | | | | | | | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50000 | | 2000 10-648-10 | Dues, Subscriptions & Memberships | 500 | | | | | | | | | | | | | | | | | | | 50000 | | | 106500 10-649-10 | Professional development | 10000 | | | | | | Total | 234450.61000000002 | 213627.98 | 194500 | 235080 | 196200 | 169000 | 146600 | 146600 | 135800 | 130800 | 130800 | 130600 | 225000 | 147000 | 112000 10-651-10 | Telephones and Internet Service | 55600 10-652-20 | Utility Expense | 10200 | | | | | 10-651-10 | "Landline" Telephones and Internet Service | | | | | | | | | | | | | | | | 1500 10-658-40 | R&M – Equipment | 600 | | | | | | communications costs(doe not include cellular) | 55600 | 55600 | 50760 | 47000 | 42800 | 42800 | 39800 | 36800 | 36800 | 36800 | 36800 | 36800 | 36800 | 36800 | 36800 | 0 10-669-20 | Recruitment Expense | 200 | | | | | | | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 10-690-15 | Minor Equipment IS | 35000 | | | | | | Total | 55600 | 55600 | 50760 | 47000 | 42800 | 42800 | 39800 | 36800 | 36800 | 36800 | 36800 | 36800 | 36800 | 36800 | 36800 | Total Commodities | | | 448348.61 | | | | | | | 10-690-15 | Minor Equipment IS | | | | | | | | | | | | | | | | 4000 | | | | | | | | unanticipated laptop and desktop replacements | 6500 | 6500 | 6500 | 6500 | 6000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 Capital Outlay | | | | | | | | Network switch replacement year 2 of 2 | 23000 | 18000 | 14000 | 6500 | 6000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 2000 10-770-74 | Equipment –Gen Govt Replacement | 0 | | 0 | | | | Misc. peripherals | 5500 | 5500 | 5500 | 5500 | 5000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 0 | | | | | | | | | | 3000 | | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5700 | 0 | | | | | | | | | | 2900 | | | | | | | | | | | | 0 | | 0 10-900-00 | Operating Contingency | | | 0 | | | | | | | | | | | | | | | 2000 | 2000 | 0 | | 0 | 11000 | | | | | | | | Total | 35000 | 35900 | 26000 | 18500 | 17000 | 14000 | 14000 | 14000 | 14000 | 14000 | 16000 | 16000 | 14000 | 19700 | 14000 130-681-01 | Internal Service Charge - General Fund | 130434 | | | | | 10-770-74 10-685-01 | Fleet Services Supplies | 229 10-685-02 | Fleet Services R&M | 845 | | | | | | Capital Equipment –Gen Govt | | | | | | | | | | | | | | | | 0 130-890-01 | Transfer To: General Fund | 0 | | | | | | | | | | 28000 | | | | | | | 5000 | 5000 | 0 | 0 | 0 60-890-90 | Transfer To: Fleet | | | 131508 | | | | | | | | | | | | 10775 | | | | | | | 10000 | 10000 | 0 | 0 | 0 | From IS Fund | | | | | | | | | | | | | | | | | | | | 0 | 0 | 0 | 0 | offset operations from accumulation | 0 | | 0 | | | | Total | | | | 38775 | 0 | 0 | 0 | 0 | 0 | 0 | 15000 | 15000 | 0 | 0 | 0 | | | | | | | 10-900-00 | | | | 1199946.6099999999 | | | | | | | | | | | | | | | | | | | | 25000 | | | | | | | | Operating Contingency | | | | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 40000 | 40000 | 40000 | 40000 | 25000 | 25000 [48 non-empty rows] === Sheet: Software renewal === Department | Reoccurring Professional Services Computer | | | | Information Systems Renewals | | | | | Description | 2027 | 2026 | 2025 | 2024 General Government | | | | | SHI International M365, Visio, SQL Server, & Remote Desktop Services Packages 8% increase effective 7/2026 | 99000 | 91000 | 90750 | 90402 Legislative | 0 | | | | Barracuda Endpoint protection | 35873.32 | 35873.32 | 35873 Executive | 0 | | | | Veeam Data Platform Advanced Universal Subscription License | 17000 | 17000 | 15000 | 11800 Administration | 47445 | | | | Barracuda Email Gateway Defense and Message Archiver | 9200 | 9000 | 8698 | 9196 Finance | 1400 | | | | Duo | 6200 | 6000 | 5950 Legal | 5800 | | | | Ruckus wireless Renewal | 5247.31 | 5247.31 | 5247 | 5247 Human Resources | 1200 | | | | BeyondTrust Renewal November 1, 2023 - October 31, 2024 | 6300 | 5000 | 4398 | 3342 Buildings and Grounds | 80 | | | | Netmotion VPN Licenses | 4700 | 4694.9 | 4560 | 4694 Community Development | 0 | | | | Cisco Smartnet + SW Renewal - Compunet - core switches | 3500 | 3000 | 2861 | 4564 | | | | | BMC Software - Track It! | 2300 | 2200 | 2200 | 2200 Total General Govt | 55925 | | | | Zoho - AD Audit+ | 2100 | 1500 | 1440 | 1440 | | | | | SonicWall analytics | 370 | 350 | 336 | 325 Parks and Recreation | 27495 | | | | Dmarcly Reporting | 260 | 250 | 215 | 215 | | | | | Unused Seats for Bluebeam, Adobe, etc | 1500 | 1500 Arts | 1000 | | | | Godaddy WildCard Cert *.ci.moscow.id.us | 899.98 | 899.98 | 899.98 Farmers Market | 2000 | | | | ESRI ARCGIS (fy25 and fy26 are 30200, fy27 is going to be more) | 35000 | 30200 | 30200 Public Safety Police | 80594 Police Parking | 12500 | | | | | 229450.61000000002 | 213715.51 | 208627.98 | 133425 Fire | 1490 CPD | 39065 Total Public Safety | 133649 Water | 38875 Sewer | 42300 Streets | 7000 Fleet Management | 2025 Sanitation | 9803 Storm Water | 10745 | 330817 Legislative total | 0 Executive total | 0 Administration Civic Clerk | 19800 Next Request | 15000 Civicplus | 5000 Archive Social | 4500 Adobe CC | 3000 | 1000 | 3 BlueBeam | 145 | 145 | 1 | bill total | 47445 Finance Adobe Acrobat | 1400 | 200 | 7 BS&A(finance is takingin fy26) total | 1400 Legal Caseguard | 4800 Adobe Acrobat | 1000 | 200 | 5 total | 5800 Human Resources(Employee Services) Adobe Acrobat | 200 | 200 | 1 Adobe cc | 1000 | 1000 | 1 total | 1200 Buildings and Grounds (Fac) Key Trail | 80 total | 80 Community Development in the engineering lines total | 0 Parks and Recreation Time Clocks | 8800 BlueBeam | 145 | 145 | 1 | dave when to work | 1500 Adobe Acrobat | 400 | 200 | 2 Pool management | 650 Civic Rec | 10700 Nexgen Maintenance Management | 5300 total | 27495 Arts Adobe CC | 1000 | 1000 | 1 total | 1000 Police WatchGuard Cloud Storage - Unlimited | 0 Spillman | 30000 GrayKey | 12825 Watchguard | 0 Axiom and Axiom Cloud | 8322 Access unlimited ExaqVision Video System | 4600 Leads Online | 3796 Power DMS planit police | 3850 Oxygen Forensics Software | 3248.0000000000005 Brivo Control Systems | 3200 AXON investigate pro | 4000 IDEMIA LiveScan AFIS | 2250 Cellebrite Inspector | 1100 OsForensics | 1008 Cellebrite Collector | 1100 active 911 | 695 Adobe Acrobat | 600 | 200 | 3 total | 80594 Police Parking Aims Support and Web | 12500 total | 12500 Fire *All cloud based subscriptions in fire budget Adobe CC | 1000 | 1000 | 1 Bluebeam | 290 | 145 | 2 | matt dan Adobe Acrobat | 200 | 200 | 1 total | 1490 Engineering CPD washington state reference network | 2000 Bluebeam | 2465 | 145 | 17 | the rest Adobe Acrobat | 400 | 200 | 1 permit trax | 11200 Adobe CC | 2000 | 1000 | 2 Autodesk Support | 21000 total | 39065 Water SCADA/PLC programing | 15000 win911 | 2300 Wonderware Software Support ISS | 13000 Rapid Plan | 1500 Syncta | | | | moved to theirs for 26 Bluebeam | 435 | 145 | 3 | ty marq kyle Adobe Acrobat | 400 | 200 | 2 | aadded Gayle Nexgen Maintenance Management | 5300 sensaphone | 90 GPS software support | 850 Handheld Meter Reading total | 38875 Sewer Nexgen Maintenance Management | 5300 win911 | 2300 Aveva Software Support ISS | 13000 | | | | | | 4750 | 5000 F.O.G. | | | | moved to theirs for 26 SCADA/PLC programing | 12000 WinCan(determine cost for fy26) | 8200 Brivo Control Systems | 1500 total | 42300 Streets Rapid Plan | 1500 Nexgen Maintenance Management | 5300 Adobe Acrobat | 200 | 200 | 1 total | 7000 Fleet Management CFA | 1825 Adobe Acrobat | 200 | 200 | 1 total | 2025 Sanitation Encore | 9803 total | 9803 Farmers Market(CE) Adobe CC | 2000 | 1000 | 2 total | 2000 Stormwater Rapid Plan | 1300 WinCAN | 4000 Nexgen Maintenance Management | 5300 Bluebeam | 145 | 145 | 1 | dana total | 10745 Total | 330817 | | 3625 | 25 BB total | Bluebeam | 5000 | 24 | 25 owned as of 3/1/25 Adobe Acrobat | Adobe Acrobat | 10000 | 10 | 11 owned as of 3/1/2025 Adobe Creative Cloud | Adobe CC [157 non-empty rows] === Sheet: Allocae centralized === Total Centralized Expenses | Workstation Support | User Support | Printer/Fax Support | Server/Network Administration | User Training | Communications Support | Administration | GIS | Intra-Internet Support | SCADA | Televising Council Meeting | Total 1199946.6099999999 | Workstation | User | Printers | Users and Workstations | User | Phones and Faxes | Workstations, Users, Phones, Printers | | users | | Legislative percent of cost | 0.2 | 0.11 | 0.08 | 0.14 | 0.03 | 0.08 | 0.08 | 0.04 | 0.12 | 0.1 | 0.02 | 1 value of total | 239989.322 | 131994.12709999998 | 95995.7288 | 167992.52539999998 | 35998.39829999999 | 95995.7288 | 95995.7288 | 47997.8644 | 143993.59319999997 | 119994.661 | 23998.9322 | 1199946.6099999999 per item | 1105.9415760368663 | 647.0300348039217 | 1573.7004721311475 | 362.83482807775385 | 176.4627367647059 | 623.3488883116883 | 140.34463274853803 | | 705.8509470588236 General Government Legislative | 0 | 3882.18020882353 | 0 | 4354.017936933046 | 1058.7764205882354 | 0 | 1684.1355929824563 | | 4235.105682352942 | | 23998.9322 | 39213.14804168021 Executive | 1105.9415760368663 | 647.0300348039217 | 0 | 1088.5044842332616 | 176.4627367647059 | 623.3488883116883 | 561.3785309941521 | | 705.8509470588236 | | | 4908.517198203419 Administration | 4423.766304147465 | 2588.120139215687 | 3147.400944262295 | 2902.678624622031 | 705.8509470588236 | 3116.7444415584414 | 2105.1694912280705 | | 2823.4037882352945 | | | 21813.134680328105 Finance | 7188.620244239631 | 4529.210243627452 | 3147.400944262295 | 4898.270179049677 | 1235.2391573529414 | 4363.442218181818 | 3157.754236842106 | 0 | 4940.956629411766 | | | 33460.89385296769 Legal | 7741.591032258064 | 3882.18020882353 | 1573.7004721311475 | 4716.8527650108 | 1058.7764205882354 | 2493.395553246753 | 2526.2033894736846 | | 4235.105682352942 | | | 28227.805523885152 Human Resources | 2211.8831520737326 | 1294.0600696078434 | 1573.7004721311475 | 1451.3393123110154 | 352.9254735294118 | 1246.6977766233765 | 982.4124292397662 | | 1411.7018941176473 | | | 10524.72057963394 Buildings and Grounds | 2211.8831520737326 | 1941.090104411765 | 0 | 2902.678624622031 | 529.3882102941177 | 623.3488883116883 | 1263.1016947368423 | | 2117.552841176471 | | | 11589.043515626647 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 0 | | | 0 Administration/URA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | | 0 Information systems Total General Govt | 24883.685460829493 | 18763.871009313727 | 9442.202832786885 | 22314.34192678186 | 5117.419366176471 | 12466.977766233766 | 12280.15536549708 | 0 | 20469.677464705885 | | 23998.9322 | 149737.26339232514 | | | | | | | | | | | | | | gen gov | 757114.4488726641 | 0.6309567797126109 Parks and Recreation | 23224.77309677419 | 22646.051218137258 | 15737.004721311476 | 22495.75934082074 | 6176.195786764707 | 11843.628877922078 | 12771.361580116962 | 2399.89322 | 24704.783147058828 | | | 141999.45098890623 | | funds | 425664.23558458267 | 0.3547359791154231 Arts | 2211.8831520737326 | 1294.0600696078434 | 1573.7004721311475 | 1451.3393123110154 | 352.9254735294118 | 1246.6977766233765 | 982.4124292397662 | | 1411.7018941176473 | | | 10524.72057963394 Farmers market | 2211.8831520737326 | 1294.0600696078434 | 0 | 2177.008968466523 | 352.9254735294118 | 1246.6977766233765 | 1122.7570619883043 | | 1411.7018941176473 | | | 9817.034396406838 Public Safety Police | 63038.669834101376 | 33645.56180980393 | 28326.608498360656 | 40274.66591663068 | 9176.062311764706 | 19323.815537662336 | 23016.51977076024 | | 36704.249247058826 | | | 253506.15292614276 Police Parking | 3317.8247281105987 | 1294.0600696078434 | 3147.400944262295 | 1814.1741403887693 | 352.9254735294118 | 1246.6977766233765 | 1263.1016947368423 | | 1411.7018941176473 | | | 13847.886721376784 Fire | 18801.006792626726 | 7117.330382843139 | 4721.101416393442 | 11973.549326565877 | 1941.090104411765 | 4363.442218181818 | 6034.819208187136 | | 7764.36041764706 | | | 62716.69986685696 CPD | 33178.24728110599 | 12940.600696078434 | 9442.202832786885 | 18141.741403887692 | 3529.2547352941183 | 13090.326654545453 | 10525.847456140353 | | 14117.018941176473 | | | 114965.24000101541 Total Public Safety | 118335.74863594468 | 54997.55295833334 | 45637.313691803276 | 72204.13078747301 | 14999.332625000003 | 38024.282187012985 | 40840.28812982456 | | 59997.33050000001 | | | 445035.9795153919 Water | 26763.786140092165 | 11775.946633431375 | 7868.502360655738 | 16109.86636665227 | 3211.6218091176474 | 10596.9311012987 | 9599.572880000002 | 15599.30593 | 12846.48723647059 | 59997.3305 | | 174369.3509577185 Sewer | 22340.0198359447 | 9187.826494215687 | 4721.101416393442 | 13207.187742030239 | 2505.7708620588237 | 8103.535548051947 | 7634.74802152047 | 15599.30593 | 10023.083448235295 | 59997.3305 | | 153319.9097984506 Streets | 12386.545651612902 | 6599.706355000001 | 4721.101416393442 | 10667.343945485964 | 1799.9199150000002 | 6233.488883116883 | 5950.612428538014 | 14399.35932 | 7199.679660000001 | | | 69957.75757514719 Fleet Management | 3317.8247281105987 | 2588.120139215687 | 4721.101416393442 | 3265.5134526997845 | 705.8509470588236 | 3740.0933298701293 | 2526.2033894736846 | | 2823.4037882352945 | | | 23688.111191057444 Sanitation | 774.1591032258063 | 776.436041764706 | 0 | 689.3861733477323 | 211.75528411764708 | 623.3488883116883 | 406.99943497076026 | 0 | 847.0211364705883 | | | 4329.106062208929 Storm Water | 3539.0130433179725 | 2070.4961113725494 | 1573.7004721311475 | 3410.6473839308865 | 564.680757647059 | 1870.0466649350647 | 1880.6180788304093 | 0 | 2258.723030588236 | | | 17167.925542753324 Totals | 239989.32199999996 | 131994.1271 | 95995.72880000001 | 167992.52540000004 | 35998.3983 | 95995.7288 | 95995.7288 | 47997.864400000006 | 143993.5932 | 119994.661 | 23998.9322 | 1199946.61 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 [35 non-empty rows] === Sheet: Phone services === Department | Departmental Cell services | | | Cell phone services worksheet General Government | | | | We are on t-mobile, public safety and scada are on varible plans that move through tiers based on data used. Upto the $33 unlitmed plan. Legislative | 0 Executive | 0 Administration | 0 Finance | 0 Legal | 0 Human Resources | 0 Buildings and Grounds | 0 Community Development | 0 Total General Govt | 0 Parks and Recreation | 2568 Arts | 0 Events | 264 Public Safety Police | 6204 Police Parking Fire | 3036 CPD | 792 Total Public Safety | 10032 Water | 3696 Sewer | 1848 Streets | 528 Fleet Management | 120 Sanitation | 0 Storm Water | 816 | | verizon | tmobile est | 19872 | | 17568 | 16000 | # of data plans | line cost | yearly cost Legislative total | | | 0 Executive total | | | 0 Administration Finance total | | | 0 Legal total | | | 0 Human Resources total | | | 0 Buildings and Grounds total | | | 0 Community Development issued phones total | | | 0 Parks and Recreation | | | 0 field access in trucks | 4 | 22 | 1056 sprinkler controllers (cudys) (low speed plan $6.60/month) | 18 | 7 | 1512 total | | | 2568 Community Events / Farmers Market Internet access farmers market iPad | 1 | 22 | 264 total | | | 264 Police ipad celluar (2) | 2 | 22 | 528 Aircards cards MDT(13) | 13 | 33 | 5148 issued phones (2) | 2 | 22 | 528 | | | 0 total | | | 6204 Fire data card service MDTs (5) | 7 | 33 | 2772 ipad | 1 | 22 | 264 issued phones | 0 | | 0 total | | | 3036 CPD ipad celluar Qty:2 | 2 | 22 | 528 wifi hot spot | 1 | 22 | 264 total | | | 792 Water field access in trucks (2) | 2 | 22 | 528 Cellular SCADA cards (9) | 9 | 22 | 2376 issued phones (3) | 3 | 22 | 792 total | | | 3696 Sewer Cellular SCADA cards (4) | 4 | 22 | 1056 field access in trucks (3) | 3 | 22 | 792 total | | | 1848 Streets field access in trucks (2) | 2 | 22 | 528 total | | | 528 Fleet Management Cudy outdoor cell router for EV chargers | 1 | 10 | 120 total | | | 120 Sanitation total | | | 0 Arts total | | | 0 Storm Water 2 Cradlepoint Routers | 2 | 34 | 816 Total | | | 816 Infosys checkout hotspots and mdt | 4 | 34 | 1632 total | | | 1632 Total | | | 21504 [91 non-empty rows] === Sheet: deprec+central+ renewal+phone === | Current Costs Department | Total Depreciation Expenses | Total Centralized IS Expenses | Software renewal | Phone Services(cellular) | Subtotal | Rounded Subtotal | Delta from 2026 | | Don't adjust values on this sheet(except the fy in H2 and the delta column). Just copy values and formatting to a new table below for reference to the previous year. General Government Legislative | 914.558303886926 | 39213.14804168021 | 0 | 0 | 40127.70634556713 | 40130 | 840 Executive | 342.84768027745065 | 4908.517198203419 | 0 | 0 | 5251.364878480869 | 5260 | -250 Administration | 2796.119424813506 | 21813.134680328105 | 47445 | 0 | 72054.25410514162 | 72060 | 13850 Finance | 3485.162220466206 | 33460.89385296769 | 1400 | 0 | 38346.056073433894 | 38350 | -2800 Legal | 1753.3355913053995 | 28227.805523885152 | 5800 | 0 | 35781.14111519055 | 35790 | -1320 Human Resources | 1016.0953605549013 | 10524.72057963394 | 1200 | 0 | 12740.815940188842 | 12750 | -800 Buildings and Grounds | 542.8483512082554 | 11589.043515626647 | 80 | 0 | 12211.891866834902 | 12220 | -270 Information systems | 0 | 0 | | | 0 | 0 | 0 Administration/URA | 0 | 0 | | | 0 | 0 | 0 Total General Govt | 10850.966932512645 | 149737.26339232514 | 55925 | 0 | 216513.23032483782 | 216560 | 9250 | | | | | | | 0 Parks and Recreation | 11914.296726401994 | 141999.45098890623 | 27495 | 2568 | 183976.7477153082 | 183980 | -6530 | | | | | | | 0 Arts | 594.9453605549013 | 10524.72057963394 | 1000 | 0 | 12119.665940188841 | 12120 | -380 Events | 685.6953605549013 | 9817.034396406838 | 2000 | 264 | 12766.729756961739 | 12770 | -510 Public Safety | | | | | | | 0 Police | 20920.52675825286 | 253506.15292614276 | 80594 | 6204 | 361224.6796843956 | 361230 | -16460 Police Parking | 739.3985738993007 | 13847.886721376784 | 12500 | 0 | 27087.285295276088 | 27090 | -340 Fire | 7791.277696396357 | 62716.69986685696 | 1490 | 3036 | 75033.97756325331 | 75040 | -2540 CPD | 12610.04856304253 | 114965.24000101541 | 39065 | 792 | 167432.28856405793 | 167440 | -2850 Total Public Safety | 42061.25159159105 | 445035.9795153919 | 133649 | 10032 | 630778.231106983 | 630800 | -22190 | | | | | | | 0 Water | 9268.023232221578 | 174369.3509577185 | 38875 | 3696 | 226208.37418994008 | 226210 | -4150 | | | | | | | 0 Sewer | 6878.9841177839735 | 153319.9097984506 | 42300 | 1848 | 204346.89391623458 | 204350 | -2150 | | | | | | | 0 Streets | 3745.1272751594906 | 69957.75757514719 | 7000 | 528 | 81230.88485030668 | 81240 | -1830 | | | | | | | 0 Fleet Management | 1543.6194248135064 | 23688.111191057444 | 2025 | 120 | 27376.73061587095 | 27380 | 1200 | | | | | | | 0 Sanitation | 309.3190681847925 | 4329.106062208929 | 9803 | 0 | 14441.425130393722 | 14450 | -210 Storm Water | 1092.937576887842 | 17167.925542753324 | 10745 | 816 | 29821.863119641166 | 29830 | -740 | | | | | | | 0 | 88945.16666666667 | 1199946.61 | 330817 | 19872 | 1639580.7766666668 | 1639690 | -28240 Holdback modifier | 1 FY26 Department | Total Depreciation Expenses | Total Centralized IS Expenses | Software renewal | Phone Services(cellular) | Subtotal | Rounded Subtotal | Delta from 2025 General Government Legislative | 1835.857142857143 | 37445.71190755291 | 0 | 0 | 39281.56905041006 | 39290 | 130 Executive | 768.7632275132274 | 4737.765915636904 | 0 | 0 | 5506.529143150131 | 5510 | -360 Administration | 5842.765873015874 | 19921.49021461473 | 32445 | 0 | 58209.2560876306 | 58210 | 5200 Finance | 7475.6176578929735 | 32269.677772182717 | 1400 | 0 | 41145.29543007569 | 41150 | -43160 Legal | 4016.4535697542024 | 27289.031015352244 | 5800 | 0 | 37105.484585106446 | 37110 | 2660 Human Resources | 2198.526455026455 | 10143.269078723693 | 1200 | 0 | 13541.795533750148 | 13550 | -880 Buildings and Grounds | 1217.5462293215458 | 11187.038103355708 | 80 | 0 | 12484.584332677254 | 12490 | 2180 Information systems | 0 | 0 | | | 0 | 0 | 0 Administration/URA | 0 | 0 | | | 0 | 0 | 0 Total General Govt | 23355.53015538142 | 142993.9840074189 | 40925 | 0 | 207274.51416280033 | 207310 | -34230 | | | | | | | 0 Parks and Recreation | 25148.66176076619 | 136802.07671341902 | 27495 | 1056 | 190501.73847418523 | 190510 | 470 | | | | | | | 0 Arts | 1356.276455026455 | 10143.269078723693 | 1000 | 0 | 12499.545533750148 | 12500 | -1660 Events | 1537.5264550264549 | 9475.531831273807 | 2000 | 264 | 13277.058286300262 | 13280 | -330 Public Safety | | | | | | | 0 Police | 47820.02630433327 | 244786.77536902626 | 80594 | 4488 | 377688.8016733595 | 377690 | -26980 Police Parking | 1574.6136226642557 | 13346.40393775794 | 12500 | 0 | 27421.017560422195 | 27430 | 2870 Fire | 17241.280289330924 | 56735.74923272048 | 1490 | 2112 | 77579.02952205141 | 77580 | -7880 CPD | 26969.03002143192 | 103457.9499574256 | 39065 | 792 | 170283.97997885753 | 170290 | 4560 Total Public Safety | 93604.95023776038 | 418326.8784969303 | 133649 | 7392 | 652972.8287346907 | 652990 | -27430 | | | | | | | 0 Water | 20493.292384970864 | 167288.71372784843 | 38875 | 3696 | 230353.0061128193 | 230360 | -28870 | | | | | | | 0 Sewer | 15347.283058736855 | 147002.17557040107 | 42300 | 1848 | 206497.45862913792 | 206500 | -6640 | | | | | | | 0 Streets | 8261.53346058536 | 67274.72907133993 | 7000 | 528 | 83064.26253192528 | 83070 | -4700 | | | | | | | 0 Fleet Management | 3232.2896825396824 | 20802.639842749104 | 2025 | 120 | 26179.929525288786 | 26180 | -3520 | | | | | | | 0 Sanitation | 677.5973544973546 | 4176.042224498398 | 9803 | 0 | 14656.639578995753 | 14660 | 150 Storm Water | 2451.8923280423282 | 16549.469435397466 | 10745 | 816 | 30562.361763439796 | 30570 | 9630 | | | | | | | 0 | 195466.83333333334 | 1140835.5100000005 | 315817 | 15720 | 1667839.3433333333 | 1667930 | -97130 Fiscal year 2025 Department | Total Depreciation Expenses | Total Centralized IS Expenses | Software renewal | Phone Services(cellular) | Subtotal | Rounded Subtotal General Government Legislative | 1826.7391304347827 | 36713.30775781159 | 0 | 0 | 38540.046888246376 | 38550 Executive | 738.2403055229142 | 4662.099471081902 | 0 | 0 | 5400.3397766048165 | 5410 Administration | 5427.961222091657 | 20648.561488637697 | 29800 | 0 | 55876.522710729354 | 55880 Finance | 7525.3548766157455 | 32489.924579289836 | 41200 | 0 | 81215.27945590558 | 81220 Legal | 3816.0710928319622 | 26830.73139724313 | 5800 | 0 | 36446.80249007509 | 36450 Human Resources | 2326.4806110458285 | 9967.512672151495 | 1200 | 0 | 13493.993283197324 | 13500 Buildings and Grounds | 1163.6098707403055 | 11008.800757464362 | 80 | 0 | 12252.410628204667 | 12260 Information systems | 0 | 0 | | | 0 | 0 Administration/URA | 0 | 0 | | | 0 | 0 Total General Govt | 22824.457109283197 | 142320.93812368 | 78080 | 0 | 243225.3952329632 | 243270 Parks and Recreation | 24393.12934362935 | 129771.05970270878 | 26350 | 1920 | 182434.18904633814 | 182440 Arts | 1288.9806110458285 | 9967.512672151495 | 2000 | 0 | 13256.493283197324 | 13260 Events | 1476.4806110458285 | 9324.198942163805 | 2000 | 480 | 13280.679553209633 | 13290 Public Safety Police | 42881.95828437133 | 240096.82460869348 | 112069.76 | 8160 | 403208.5428930648 | 403210 Police Parking | 1516.8260869565215 | 13115.517888090362 | 11500 | 0 | 26132.343975046882 | 26140 Fire | 15514.335487661576 | 52718.582462541606 | 1200 | 3360 | 72792.91795020318 | 72800 CPD | 22419.047171395003 | 103391.64350186389 | 31750 | 1440 | 159000.69067325888 | 159010 Total Public Safety | 82332.16703038443 | 409322.56846118934 | 156519.76 | 12960 | 661134.4954915738 | 661160 Water | 17940.576380728555 | 163876.97488469735 | 34150 | 6720 | 222687.55126542592 | 222690 Sewer | 13082.787896592245 | 143941.94954039436 | 27500 | 2880 | 187404.73743698662 | 187410 Streets | 8239.871327849589 | 66098.86755903803 | 6200 | 960 | 81498.73888688762 | 81500 Fleet Management | 3239.7209165687427 | 20442.513333311013 | 2025 | 0 | 25707.234249879755 | 25710 Sanitation | 853.388366627497 | 4879.2524651277945 | 8500 | 0 | 14232.640831755292 | 14240 Storm Water | 2467.3689776733254 | 16278.164315538157 | 6000 | 960 | 25705.533293211483 | 25710 | 178138.92857142858 | 1116224 | 349324.76 | 26880 | 1670567.6885714289 | 1670680 Fiscal year 2024 Department | Total Depreciation Expenses | Total Centralized IS Expenses | Software renewal | Phone Services(Cell) | Subtotal | Rounded Subtotal General Government Legislative | 2053.9416058394163 | 37103.49286506121 | 0 | 0 | 39157.434470900625 | 39160 Executive | 1143.7051799206045 | 4722.527548853113 | 0 | 0 | 5866.232728773718 | 5870 Administration | 7019.404053015751 | 20987.385620251505 | 25000 | 0 | 53006.78967326725 | 53010 Finance | 9935.411386492931 | 32971.20393456699 | 41400 | 0 | 84306.61532105992 | 84310 Legal | 6248.6126584709955 | 27200.601011955696 | 1000 | 0 | 34449.21367042669 | 34450 Human Resources | 3091.5770265078754 | 10133.046281987225 | 1200 | 0 | 14424.6233084951 | 14430 Buildings and Grounds | 1103.3523818670765 | 9097.521411884587 | 100 | 0 | 10300.873793751663 | 10310 Information systems | 0 | 0 | | | 0 | 0 Administration/URA | 0 | 0 | | | 0 | 0 Total General Govt | 30596.004292114652 | 142215.7786745603 | 68700 | 0 | 241511.78296667497 | 241540 Parks and Recreation | 28436.91978922408 | 131802.00740154943 | 28600 | 1200 | 190038.9271907735 | 190040 Arts | 2022.8270265078754 | 10133.046281987225 | 2000 | 0 | 14155.8733084951 | 14160 Events | 2045.7436931745424 | 8957.564672383962 | 2000 | 600 | 13603.308365558503 | 13610 Public Safety Police | 59073.13969480245 | 238937.27904483565 | 95800 | 10850 | 404660.4187396381 | 404670 Police Parking | 1758.860613938606 | 11796.018316912752 | 11000 | 0 | 24554.87893085136 | 24560 Fire | 23431.571746334143 | 55089.06266940575 | 1200 | 5736 | 85456.63441573989 | 85460 CPD | 30050.0646363935 | 102976.90778147343 | 30900 | 1800 | 165726.97241786693 | 165730 Total Public Safety | 114313.63669146871 | 408799.2678126276 | 138900 | 18386 | 680398.9045040964 | 680420 Water | 23935.700145774896 | 165847.4450963963 | 56900 | 12540 | 259223.1452421712 | 259230 Sewer | 17791.211259137242 | 147151.344880821 | 39850 | 8340 | 213132.55613995827 | 213140 Streets | 11090.63338271436 | 67021.57590451314 | 8450 | 1200 | 87762.20928722751 | 87770 Fleet Management | 5264.5804520425145 | 22402.879843244013 | 2025 | 0 | 29692.460295286528 | 29700 Sanitation | 1070.1962159047252 | 4937.785936981607 | 8500 | 0 | 14507.982152886332 | 14510 Storm Water | 0 | 16533.303494935626 | 3200 | 1200 | 20933.303494935626 | 20940 | 236567.45294806358 | 1125802.0000000002 | 359125 | 43466 | 1764960.4529480638 | 1765060 Fiscal year 2023 Department | Total Depreciation Expenses | Total Centralized IS Expenses | Software renewal | Phone Services | Subtotal | Rounded Subtotal General Government Legislative | 2191.6770703287557 | 33380.95482243328 | 0 | 0 | 35572.63189276204 | 35580 Executive | 1152.1774475012758 | 4421.4679182313785 | 0 | 0 | 5573.645365732655 | 5580 Administration | 6679.841747414356 | 22035.26626218588 | 34600 | 0 | 63315.10800960024 | 63320 Finance | 9965.190066475267 | 31586.003160621265 | 44000 | 0 | 85551.19322709653 | 85560 Legal | 6053.959746736049 | 26381.31656580708 | 0 | 0 | 32435.27631254313 | 32440 Human Resources | 3018.552425866749 | 9626.154513045563 | 0 | 0 | 12644.706938912313 | 12650 Buildings and Grounds | 1079.0327672404906 | 7422.661762129804 | 80 | 0 | 8581.694529370294 | 8590 Information systems | 0 | 0 | | | 0 | 0 Administration/URA | 0 | 0 | | | 0 | 0 Total General Govt | 30140.431271562942 | 134853.82500445424 | 78680 | 0 | 243674.2562760172 | 243720 Parks and Recreation | 26084.102114079586 | 117392.82508402767 | 28150 | 1200 | 172826.92719810727 | 172830 Arts | 2248.9536604346504 | 10091.509323127564 | 800 | 0 | 13140.462983562215 | 13150 Events | 2036.4536604346504 | 8377.581026380756 | 0 | 600 | 11014.034686815407 | 11020 Public Safety Police | 51491.37916210114 | 204696.10299687355 | 104000 | 10850 | 371037.4821589747 | 371040 Police Parking | 1283.2631086142324 | 7912.226216298757 | 11000 | 0 | 20195.48932491299 | 20200 Fire | 20616.636223228863 | 48471.92127442693 | 19500 | 5736 | 94324.5574976558 | 94330 CPD | 36401.78203846146 | 98520.09562629645 | 28200 | 1800 | 164921.8776647579 | 164930 Total Public Safety | 109793.0605324057 | 359600.34611389565 | 162700 | 18386 | 650479.4066463014 | 650500 Water | 21021.287861217053 | 151652.60393495488 | 54450 | 12540 | 239663.89179617193 | 239670 Sewer | 17949.304732329998 | 132458.2497612689 | 38610 | 8340 | 197357.5544935989 | 197360 Streets | 8879.440049135828 | 59305.72698541511 | 8200 | 1200 | 77585.16703455093 | 77590 Fleet Management | 3976.9798733680245 | 16791.887606884884 | 1750 | 0 | 22518.86748025291 | 22520 Sanitation | 884.2762129333746 | 3956.1131081493786 | 8500 | 0 | 13340.389321082754 | 13350 Storm Water | 0 | 14978.332051440944 | 0 | 1200 | 16178.332051440944 | 16180 Totals | 223014.2899679018 | 1009459 | 381840 | 43466 | 1657779.2899679018 | 1657890 [162 non-empty rows] === Sheet: new === | Requested New Expenditures | | | | Total Department | New Minor Equipment | New Capital Equipment | New Professional Services Computer | Other transfers General Government Legislative | 0 | | | | 0 Executive | 0 | | | | 0 Administration | 0 | 0 | 15000 | | 15000 | | x Finance | 0 | 0 | 0 | | 0 Legal | 0 | 0 | 0 | | 0 Human Resources | 0 | 0 | 0 | | 0 Buildings and Grounds | 0 | 0 | 0 | | 0 | 0 | 0 | 0 | | 0 Total General Govt | 0 | 0 | 15000 | | 15000 | | | | | 0 Parks and Recreation | 16270.08 | 0 | 12000 | | 28270.08 | | x | | | | | 0 Arts | 0 | 0 | 0 | | 0 Events | 0 | 0 | 0 | | 0 Public Safety | | | | | 0 Police | 0 | 0 | 13000 | | 13000 | | x Police Parking | 0 | 0 | 0 | 0 | 0 Fire | 3300 | 0 | 0 | | 3300 | | x CPD | 0 | 0 | 0 | | 0 Total Public Safety | 3300 | 0 | 13000 | | 16300 | | x | | | | | 0 Water | 0 | 0 | 30000 | 0 | 30000 | | x Sewer | 6000 | 0 | 30000 | 0 | 36000 | | x Streets | 0 | 0 | 20500 | | 20500 | | x Fleet Management | 0 | 0 | 12000 | | 12000 | | x Sanitation | 0 | 0 | 0 | | 0 Storm Water | 0 | 0 | 18000 | 0 | 18000 | | x | 25570.08 | 0 | 150500 | 0 | 176070.08000000002 computer price desktop | 1100 eng desktop | 2760 notebook | 1300 Tablet | 600 upgrade from desk to notebook | 200 Phone | 206 27" monitor | 350 Confrence room display | 1000 Mobile data terminals | 2050 wireless card | 100 lap top | 1250 car mount | 700 software | 0 Tablet case | 100 tablet data service | 600 desktop scanner | 900 Permitting ipad application | 220 Adobe Creative Suite subscription | 600 lincense for new computer | 500 lincese for new user | 300 | minor | capital | services | | | | minor | Capital | services HR none for fy27 Total | 0 | 0 | 0 | 0 | 0 | 0 Arts none for fy27 Total | 0 | 0 | 0 | 0 | 0 | 0 Buildings and Grounds none for fy27 Total | 0 | 0 | 0 | 0 | 0 | 0 Community Events none for fy27 Total | 0 | 0 | 0 | 0 | 0 | 0 Administration nextrequest | | | 15000 Total | 0 | 0 | 15000 | 0 | 0 | 15000 Legal none for fy27 Total | 0 | 0 | 0 | | 0 | 0 Finance none for fy27 | | 0 Total | 0 | 0 | 0 | | 0 | 0 Total | 0 | 0 | 0 | 0 | 0 | 0 Community Planning and Design none for fy27 Total | 0 | 0 | 0 | | 0 | 0 PD FRED | | | 13000 Total | 0 | 0 | 13000 | | 0 | 13000 Police Parking none for fy27 Total | 0 | 0 | 0 | 0 | 0 | 0 Fire IPAD x3 plus cellular and cases Medic units | 1700 new workstation for proposed employee Program Manager | 1600 Total | 3300 | 0 | 0 | | 0 | 3300 Park and rec | | | | | 0 HIRC cameras | 9465.92 Eggan cameras | 6804.16 Asset Management | | | 12000 Total | 16270.08 | 0 | 12000 | | 0 | 28270.08 Water | | | | | 0 Asset Management software | | | 30000 GPT for 2 users Total | 0 | 0 | 30000 | 0 | 0 | 30000 Sewer | | | | | 0 Simatic IFP2200 V2, 22-inch multi-touch monitors | 6000 Asset Management software | | | 30000 Total | 6000 | 0 | 30000 | 0 | 0 | 36000 Streets Asset Management | | | 18000 new shop training room conf equipment? Tv -micro - camera | | | 2500 Total | 0 | 0 | 20500 | | 0 | 20500 Fleet Management Asset Management | | | 12000 Total | 0 | 0 | 12000 | | 0 | 12000 Sanitation Total | 0 | 0 | 0 | | 0 | 0 Storm Water Asset management | | | 18000 Total | 0 | 0 | 18000 | 0 | 0 | 18000 Total | ===========================================> | | | | | 158070.08000000002 [114 non-empty rows] === Sheet: Actualreplacement === | Requested Replacement Expenditures | | | | | | | | Total | Notes Department | Replacement Minor Equipment | qty desktop | qty laptop | qty tablet | qty MDT | qty Eng desktop | Replacement minor Equipment | Replacement Capital Equipment General Government Legislative | 0 | 0 | 0 | | | | | | 0 Executive | 0 | 0 | 0 | | | | | | 0 Administration | 1300 | | 1 | | | | | 0 | 1300 | 1 | x Finance | 1300 | 0 | 1 | | | | | | 1300 | 1 | x Legal | 1300 | 0 | 1 | | | | | | 1300 | 1 | x Human Resources | 0 | 0 | | | | | | | 0 Buildings and Grounds | 0 | 0 | | | | | | | 0 | 0 | | | | | | | | 0 Information Systems | 1100 | 1 | | | | | | | 1100 | 1 | x Total General Govt | 5000 | | | | | | | 0 | 5000 | | | | | | | | | 0 Parks and Recreation | 7200 | 3 | 3 | | | | | | 7200 | 6 | x | | | | | | | | | 0 Arts | 0 | 0 | 0 | | | | | | 0 Events | 0 | 0 | 0 | | | | | | 0 Public Safety | | | | | | | | | 0 Police | 9200 | 6 | 2 | | | | | 8835 | 18035 | 8 | 7960 | 875 | x Police Parking | 0 | | | | | | | | 0 Fire | 1100 | 1 | | | | | | | 1100 | 1 | | | x CPD | 9380 | 1 | | | | 3 | | 14135 | 23515 | 4 | 13260 | 875 | x Total Public Safety | 19680 | | | | | | 0 | 22970 | 42650 | | | | | | | | | 0 Water | 4800 | 2 | 2 | | | | | | 4800 | 4 | x | | | | | | | | | 0 Sewer | 0 | | | | | | | | 0 | | | | | | | | | 0 Streets | 2400 | 1 | 1 | | | | | | 2400 | 2 | x | | | | | | | | | 0 Fleet Management | 0 | 0 | | | | | | | 0 | | | | | | | | | 0 Sanitation | 0 | 0 | | | | | | | 0 Storm Water | 0 | 0 | | | | | | | 0 0 | 39080 | | | | | | | 22970 | 62050 | 29 | this matches the table below 👍👍 price for desktop | 1100 price for laptop | 1300 price for tablet | 600 Copier | 13260 large printer | 7690 medium printer | 5304 small printer | 3184 desktop printer | 874 Server | 7210 | start looking into paying for new synergy frame in 2030 Sheet Copier | 21220 Plotter/scanner combo | 31830 Plotter Projector | 3500 MDT | 2500 ENG computer | 2760 Panel PC | 4000 FY27 systems from Access DB IS ID | User Name | name as of 1/23/2026 | Cost | Department | location | Description | Serial Number | Column1 IS3210 | AD-MEDIA-3210L (coglesby) | | 2258.28 | ADM | replaced by MAC 3668T in Jan of FY26 for better video editing capability | Dell XPS 15 9520 | GHKQHW3 | do not replace in fy27 IS3211 | AD-EXASST-3211L | | 2258.28 | ADM | in IS somewere | Dell XPS 15 9520 | 8PTQHW3 | do not replace in fy27 IS3225 | AD-CLERK-3225L | | 0 | ADM | | Dell XPS 13 2-in-1 (9315) | 4RMMGX3 IS3187 | EN-STFENG-3187T | en-int2-3187t | 2788.99 | EN | | Dell Precision 3660 ENG DESKTOP | 5Q7T7V3 IS3188 | EN-TECH2-3188T | | 2788.99 | EN | | Dell Precision 3660 ENG DESKTOP | 4Q7T7V3 IS3189 | EN-TECH3-3189T | | 2788.99 | EN | | Dell Precision 3660 ENG DESKTOP | 6Q7T7V3 IS3197 | EN-2FCONF-3197T | | 1225.03 | EN | | Dell OptiPlex 7000 | 9K1T7V3 IS3204 | EN-TECH5-3204T | | 1225.03 | EN | where is this? Tech5 is now 3270L | Dell OptiPlex 7000 | 6K1T7V3 | do not replace in fy27 IS3212 | FN-TREAS-3212L | | 2258.28 | FIN | | Dell XPS 15 9520 | 4CPQHW3 IS3201 | FR-TRAIN-3201T | | 1225.03 | FR | | Dell OptiPlex 7000 | 9Z9S7V3 IS3186 | IS-MANAGER-3186 | | 1952.61 | IS | boyds office | Dell XPS 13 9315 2-in-1 | C0DFCS3 | do not replace in fy27 IS3190 | IS-MAYCON-3190T | | 1225.03 | IS | | Dell OptiPlex 7000 | 5X9S7V3 IS3216 | LG-TEMP-3216L | lg-ext-3216L | 2258.28 | LG | | Dell XPS 15 9520 | 9LHRHW3 IS3192 | PD-CAMPUS-3192T | | 1225.03 | PD | | Dell OptiPlex 7000 | 9J1T7V3 IS3193 | PD-CONF2-3193T | | 1225.03 | PD | | Dell OptiPlex 7000 | FY9S7V3 IS3194 | PD-REP1-3194T | | 1225.03 | PD | | Dell OptiPlex 7000 | GY9S7V3 IS3195 | PD-REP2-3195T | | 1225.03 | PD | | Dell OptiPlex 7000 | 5H1T7V3 IS3202 | PD-EVIMGR-3202T | | 1225.03 | PD | where is this? He is on 3269L now | Dell OptiPlex 7000 | 7K1T7V3 IS3203 | PD-RECEPT-3203T | | 1225.03 | PD | | Dell OptiPlex 7000 | 218T7V3 IS3214 | PD-CHIEF-3214L | | 2258.28 | PD | | Dell XPS 15 9520 | JCPQHW3 IS3219 | PD-CACPT-3219L | | 2258.28 | PD | | Dell XPS 15 9520 | 1QQTHW3 IS3191 | PR-HRCINT-3191T | | 1225.03 | PR | | Dell OptiPlex 7000 | D0BS7V3 IS3196 | PR-HRCAA2-3196T | | 1225.03 | PR | | Dell OptiPlex 7000 | 9Y9S7V3 IS3200 | PR-HRCCON-3200T | | 1225.03 | PR | | Dell OptiPlex 7000 | BK1T7V3 IS3213 | PR-RECCOR-3213L | | 2258.28 | PR | | Dell XPS 15 9520 | 5R15HW3 IS3224 | PK-PKSUPR-3224L | | 0 | PRK | | Dell XPS 13 2-in-1 (9315) | 4YBMGX3 IS3226 | PK-MNT-3226L | | 0 | PRK | | Dell XPS 13 2-in-1 (9315) | 793MGX3 IS3220 | SN-MANAGE-3220L | | 2258.28 | SN | ? | Dell XPS 15 9520 | 5K2RHW3 | what is happening with the SAN dept? IS3198 | ST-SIGN3-3198T | | 1225.03 | ST | | Dell OptiPlex 7000 | 5Y9S7V3 IS3215 | ST-FLTSUP-3215L | | 2258.28 | ST | | Dell XPS 15 9520 | CN15HW3 IS3205 | WR-OPERATOR3-3205T | | 1225.03 | WR | whereis this? IN IS. | Dell OptiPlex 7000 | 5K1T7V3 | do not replace in fy27 IS3222 | WR-TUNNEL-3222T | | 947.62 | WR | | Dell OptiPlex Micro 7010 | 8M1R7Y3 IS3223 | WR-FILTER-3223T | | 947.62 | WR | | Dell OptiPlex Micro 7010 | 6N1R7Y3 IS3217 | IS-TECH4-3217 | wt-dist2-3217L | 2258.28 | wt | | Dell XPS 15 9520 | 94X4HW3 IS3221 | WT-METER1-3221 | | 2258.28 | WT | | Dell XPS 15 9520 | 88XRHW3 [89 non-empty rows] === Sheet: From Accumulation === | Requested New Expenditures paid for by IS Accumulation | | | | Total Department | Minor Equipment | Capital Equipment | Professional Services Computer | Other transfers IS | | | | | 0 radio upgrade phase 1 and 2 records management General Government | 0 | 0 | 0 | 0 Legislative | 0 | | | | 0 Executive | 0 | | | | 0 Administration | 0 | | 0 | 0 | 0 Finance | 0 | 0 | 0 | | 0 Legal | 0 | 0 | 0 | | 0 Human Resources | 0 | 0 | 0 | | 0 Buildings and Grounds | 0 | 0 | 0 | | 0 | 0 | 0 | 0 | | 0 Information systems | 0 | | 0 | | 0 Total General Govt | 0 | 0 | 0 | 0 | 0 | | | | | 0 Parks and Recreation | 0 | 0 | 0 | | 0 | | | | | 0 Arts | 0 | 0 | 0 | | 0 Events | 0 | 0 | 0 | | 0 Public Safety | | | | | 0 Police | 0 | 0 | 0 | | 0 Police Parking | 0 | 0 | 0 | 0 | 0 Fire | 0 | 0 | 0 | | 0 CPD | 0 | 0 | 0 | | 0 Total Public Safety | 0 | 0 | 0 | | 0 | | | | | 0 Water | 0 | 0 | 0 | 0 | 0 Sewer | 0 | 0 | 0 | 0 | 0 Streets | 0 | 0 | 0 | | 0 Fleet Management | 0 | 0 | 0 | | 0 Sanitation | 0 | 0 | 0 | | 0 Storm Water | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 computer price desktop | 550 notebook | 650 upgrade from desk to notebook | 100 Phone | 103 Information Systems total | 0 | 0 | 0 Events total | 0 | 0 | 0 | | 0 | 0 arts total | 0 | 0 | 0 | | 0 | 0 Administration Reallocation of FY24 Radio Project | | 2300141 | 0 total | 0 | 2300141 | 0 | | 0 | 2300141 Legal | | 0 total | 0 | 0 | 0 | | 0 | 0 Finance | | 0 | | 0 total | 0 | 0 | 0 | | 0 | 0 Community Development total | 0 | 0 | 0 | | 0 | 0 Engineering | | | | | 0 total | 0 | 0 | 0 | 0 | 0 | 0 PD total | 0 | 0 | 0 | | 0 | 0 Storm Water total | 0 | 0 | 0 | 0 | 0 | 0 Fire total | 0 | 0 | 0 | 0 | 0 | 0 Park and rec | | | | | 0 total | 0 | 0 | 0 | | 0 | 0 Water | | | | | 0 total | 0 | 0 | 0 | 0 | 0 | 0 Sewer | | | | | 0 total | 0 | 0 | 0 | 0 | 0 | 0 Streets total | 0 | 0 | 0 | | 0 | 0 Fleet Management | 0 | 0 total | 0 | 0 | 0 | | 0 | 0 Sanitation | | | 0 total | 0 | 0 | 0 | | 0 | 0 Total | ===========================================> | | | | | 2300141 [82 non-empty rows] === Sheet: Transfers & replacement === Budget Expenditure Categories Department | Replacement Minor Equipment | New Minor Equipment | New Minor Equipment From Accumlation | Total Minor Equipment | Replacement Capital Equipment | New Capital Equipment | New Capital Equipment From Accumlation | Capital Total | Renewal Profesional Services Computer | New Professional Services Computer | New Professional Services Computer from Accumulation | Professional Services Total | Working Capital | Other Transfers | Transfer In | From IS Fund | From IS Service Fee | | | balance check | | | | | | | | | | | | | | | | | | | expence | 638383.08 | | | | | | | | | | | | | | | | | | | revenue | 638383.0800000001 | | | | | | | | | | | | | | | | | | | balanced | No Information systems | 1100 | | 0 | 1100 | 0 | #REF! | 0 | #REF! | | #REF! | 0 | #REF! | 0 | | #REF! | 1100 | 0 General Government Legislative | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | 0 Executive | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | 0 Administration | 1300 | 0 | 0 | 1300 | 0 | 0 | 0 | 0 | 47445 | 15000 | 0 | 62445 | | | 15000 | 1300 | 47445 Finance | 1300 | 0 | 0 | 1300 | 0 | 0 | 0 | 0 | 1400 | 0 | 0 | 1400 | | | 0 | 1300 | 1400 Legal | 1300 | 0 | 0 | 1300 | 0 | 0 | 0 | 0 | 5800 | 0 | 0 | 5800 | | | 0 | 1300 | 5800 Human Resources | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1200 | 0 | 0 | 1200 | | | 0 | 0 | 1200 Buildings and Grounds | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 80 | 0 | 0 | 80 | | | 0 | 0 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | 0 | | | | 0 | | | | | | | | | | | 0 | 0 | 0 Total General Govt | 3900 | 0 | 0 | 3900 | 0 | 0 | 0 | 0 | 55925 | 15000 | 0 | 70925 | 0 | 0 | 15000 | 3900 | 55925 Parks and Recreation | 7200 | 16270.08 | 0 | 23470.08 | 0 | 0 | 0 | 0 | 27495 | 12000 | 0 | 39495 | 0 | | 28270.08 | 7200 | 27495 Arts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 1000 | 0 | | 0 | 0 | 1000 Events | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | 0 Public Safety Police | 9200 | 0 | 0 | 9200 | 8835 | 0 | 0 | 8835 | 0 | 13000 | 0 | 13000 | | | 13000 | 18035 | 0 Police Parking | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | 0 | 0 | 0 Fire | 1100 | 3300 | 0 | 4400 | 0 | 0 | 0 | 0 | 80594 | 0 | 0 | 80594 | | | 3300 | 1100 | 80594 CPD | 9380 | 0 | 0 | 9380 | 14135 | 0 | 0 | 14135 | 12500 | 0 | 0 | 12500 | | | 0 | 23515 | 12500 Total Public Safety | 19680 | 3300 | 0 | 22980 | 22970 | 0 | 0 | 22970 | 93094 | 13000 | 0 | 106094 | 0 | | 16300 | 42650 | 93094 Water | 4800 | 0 | 0 | 4800 | 0 | 0 | 0 | 0 | 133649 | 30000 | 0 | 163649 | 0 | 0 | 30000 | 4800 | 133649 Sewer | 0 | 6000 | 0 | 6000 | 0 | 0 | 0 | 0 | 38875 | 30000 | 0 | 68875 | 0 | | 36000 | 0 | 38875 Streets | 2400 | 0 | 0 | 2400 | 0 | 0 | 0 | 0 | 42300 | 20500 | 0 | 62800 | 0 | | 20500 | 2400 | 42300 Fleet Management | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7000 | 12000 | 0 | 19000 | 0 | | 12000 | 0 | 7000 Sanitation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2025 | 0 | 0 | 2025 | 0 | | 0 | 0 | 2025 Storm Water | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18000 | 0 | 18000 | | | 18000 | 0 | 0 | 37980 | 25570.08 | 0 | 63550.08 | 22970 | 0 | 0 | 22970 | 401363 | 150500 | 0 | 551863 | 0 | 0 | 176070.08000000002 | 60950 | 401363 [33 non-empty rows] === Sheet: budget history === | | | | 2008 | 2009 | 2011 | 2012 | 2010 | 2011 | 2011 | 2012 | 2012 | 2013 | 2013 | 2014 | 2015 | 2015 | 2016 | 2017 | 2017 | 2018 | 2018 | 2019 | 2019 | 2020 | 2020 | 2021 | 2021 | 2022 | 2023 | 2023 | 2024 | 2024 | 2025 | 2025 | 2026 | 2026 | 2027 | 2027 Account Number | Description | | | Actual | Actual | Actual | Actual | Adopted | Adopted | 12 month estim | Adopted | 12 month estim | Adopted | 12 month estim | Adopted | Adopted | 12 month estim | addopted | addopted | 12 month estim | addopted | 12 month estim | addopted | 12 month estim | addopted | 12 month estim | Requested | 12 month estim | Requested | Requested | 12 month estim | Requested | 12 month estim | Requested | 12 month estim | requested | 12 month est | Requested | 12 month estim 295 | Information Systems | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 295-000-431-26 | Federal Grant - Fire FEMA | | | | | -4790.34 | -629.66 | | | | | | | | 0 295-000-431-30 | Federal Grant - Office Of Highway Safety | | | | | 0 | 0 | | | | | | | | 0 | | | | | | | | | | -12000 | 0 | 0 | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 295-000-431-46 | Federal Grant - MDT'S | | | | | 0 | -60190 | | | | | -60190 | | | 0 295-000-434-01 | State Grant Revenue | | | 0 | -123968 | 0 | -1533 | -23705 | 0 | 0 | 0 | | -88620 | -88620 | 0 | | | 0 | 0 | | 0 | 0 | 0 | | 0 | | 0 | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Intergovernmental Revenues | | | 0 | -123968 | -4790.34 | -62352.66 | -23705 | 0 | 0 | 0 | -60190 | -88620 | -88620 | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | 0 | | -12000 | | 0 | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 295-000-448-70 | Information System Service Fees | | | -423100 | -625540 | -597980.04 | -849060 | -558950 | -597980 | -597980 | 849060 | 849060 | -888980 | -888980 | -1010740 | -1010740 | -1010740 | -1119960 | -1153670 | -1153670 | -1170820 | -1170820 | -1234220 | -1234220 | -1408100 | -1408100 | -1343710 | -1343710 | -1397670 | -1659160 | -1659160 | -1766470 | -1765060 | -1673480 | -1673480 | -1670070 | -1670070 | -1639690 | -1598710 | Charges for Services | | | -423100 | -625540 | -597980.04 | -849060 | -558950 | -597980 | -597980 | 849060 | 849060 | -888980 | -888980 | -1010740 | -1010740 | -1010740 | -1119960 | -1153670 | -1153670 | -1170820 | -1170820 | -1234220 | -1234220 | -1408100 | -1408100 | -1343710 | -1343710 | -1397670 | -1657890 | -1659160 | -1766470 | -1765060 | -1673480 | -1673480 | -1670070 | -1670070 | -1639690 | -1598710 295-000-471-00 | Investment Earnings | | | -2372.93 | -10686.15 | | | 0 | -5000 | -5000 | 5005 | | -5005 | | -8000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -22000 | -25000 | -100000 | -118450 | -213631 | -215767 | -258526 | -268796 | -268796 | -123106 | -268796 | Investment Earnings | | | -2372.93 | -10686.15 | | | 0 | -5000 | -5000 | 5005 | 0 | -5005 | 0 | -8000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -22000 | -25000 | -100000 | -118450 | -213631 | -215767 | -258526 | -268796 | -268796 | -123106 | -268796 295-000-479-01 | Refunds & Reimbursements | | | 0 | -27668.75 | | | -1350 | -2520 | -2520 | 4000 | 5000 | -4000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -7476 | -57550 | -8397 | -58400 | -58400 | -58400 | -58400 | Refunds and Reimbursements | | | 0 | -27668.75 | | | -1350 | -2520 | -2520 | 4000 | 5000 | -4000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -6000 | -7476 | -57550 | -8397 | -58400 | -58400 | -58400 | -58400 295-000-00-479-02 | Moscow Urban Renewal Contract | | | 0 | 0 | | | -1370 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 0 | | 0 | | | | 0 | 0 | Other Revenues | | | 0 | 0 | | | -1370 | 0 | 0 | 0 | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 0 | | 0 | | | | 0 | 0 295-000-498-01 | Transfer In: General Fund | | | -6300 | -122200 | | | -42625 | -10925 | -10925 | 0 | 0 | -10470 | -10470 | -13855 | -13855 | -13855 | -85702 | -2600 | -2600 | 0 | 0 | -64382 | -64382 | -62234 | -62234 | -174100 | -174100 | -327250 | -14850 | -14850 | -28965 | -28965 | -1750 | -1750 | -12225 | -1750 | -31300 | -31300 295-000-498-50 | Transfer In: Streets Fund | | | -1000 | -7000 | | | -900 | -900 | -900 | 0 | 0 | -2500 | -2500 | -600 | -600 | -600 | -1420 | 0 | 0 | -4225 | -4225 | -6275 | -6275 | -28375 | -28375 | -10100 | -10100 | -5000 | -2500 | -2500 | 0 | 0 | -770 | -770 | 0 | -770 | -20500 | -52500 295-000-498-33 | Transfer In: Rec & Culture Fund | | | -600 | -8100 | | | -6000 | -4500 | -4500 | 5500 | 5500 | 0 | 0 | 0 | 0 | 0 | -1200 | 0 | 0 | -5275 | -5275 | -300 | -300 | -8000 | -8000 | -21600 | -21600 | -4075 | -6700 | -6700 | -6125 | -6125 | 0 | 0 | -5625 | 0 | -28270.08 | -16270.08 295-000-498-80 | Transfer In: Sanitation Fund | | | -3000 | -6000 | | | 0 | -76780 | -76780 | 0 | 0 | 0 | 0 | -995 | -995 | -995 | -2500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 295-000-498-25 | Transfer In: Arts | | | -300 | -900 | | | -200 | 0 | 0 | 1100 | 1100 | 0 | 0 | -500 | -500 | -500 | -2275 | 0 | 0 | 0 | 0 | 0 | 0 | -4000 | -4000 | 0 | 0 | -6200 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 295-000-498-10 | Transfer In: Community Events | | | | | | | | | | | | | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1200 | -1200 | -3400 | -1000 | -1000 | 0 | 0 | -600 | -600 | 0 | -600 | 0 | 0 295-000-498-90 | Transfer In: Fleet Fund | | | | | | | | -2200 | -2200 | 0 | 0 | 0 | 0 | -4610 | -4610 | -4610 | -2100 | -14960 | -14960 | -15000 | -15000 | 0 | 0 | -25000 | -25000 | -1200 | -1200 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -12000 | 0 295-000-498-60 | Transfer In: Water Fund | | | -3000 | -67700 | | | -4475 | -10550 | -10550 | 14100 | 14100 | -24350 | -24350 | -2750 | -2750 | -2750 | -25889 | -500 | -500 | -25100 | -25100 | -2475 | -2475 | -104000 | -104000 | -89000 | -89000 | -77500 | 0 | 0 | -7600 | -7600 | 0 | 0 | -200 | 0 | -30000 | -50000 295-000-498-70 | Transfer In: Sewer Fund | | | -4300 | -30500 | | | -11050 | -5550 | -5550 | 19025 | 19025 | -14240 | -14240 | -11075 | -11075 | -11075 | -31989 | -4500 | -4500 | 0 | 0 | 0 | 0 | -27900 | -27900 | -1700 | -1700 | -39300 | 0 | 0 | -2765 | -2765 | -16000 | -16000 | -5300 | -16000 | -36000 | -56000 295-000-498-75 | Transfer In: Storm Water | | | 0 | -105000 | | | -30000 | -30000 | -30000 | 9450 | 9450 | -18455 | -18455 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -5000 | -5000 | 0 | 0 | 0 | 0 | 0 | 0 | -18000 | -50000 | Transfers In | | | -18500 | -347400 | | | -95250 | -141405 | -141405 | 49175 | 49175 | -70015 | -70015 | -34385 | -34385 | -34385 | -153075 | -22560 | -22560 | -49600 | -49600 | -73432 | -73432 | -259509 | -259509 | -298900 | -298900 | -462725 | -30050 | -30050 | -45455 | -45455 | -19120 | -19120 | -23350 | -19120 | -176070.08000000002 | -256070.08000000002 295-000-00-900-01 | Restricted Fund Balance | | | 0 | | | | -165230 | -165230 | | 115125 | 115125 | -50000 | -62855 | | | | -13869.95 | -317756 | -317756 | -715606 | -715606 | -261985 | -261985 | -55344 | | -13309 | -13309 | -1309719.67 | -3864403 | -4283737 | -4206840 | -4315315 | -1562962 | -3356912 | -545393 | -3356912 | -725479 | -545393 | Other Financing Sources | | | 0 | 0 | | | -165230 | -165230 | 0 | 115125 | 115125 | -50000 | -62855 | | | | -13869.95 | -317756 | -317756 | -715606 | -715606 | -261985 | -261985 | -55344 | 0 | -13309 | -13309 | -1309719.67 | -3864403 | -4283737 | -4206840 | -4315315 | -1562962 | -3356912 | -545393 | -3356912 | -725479 | -545393 | Total IS Revenue | | | #REF! | #REF! | | | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | -1057125 | #REF! | -1298904.95 | #REF! | #REF! | -1947956 | #REF! | -1581637 | -1581637 | #REF! | #REF! | -1667919 | #REF! | -3182114.67 | -5583343 | -6078947 | -6143215 | -6346937 | -3528879 | -5316435 | -2566009 | -5373298 | -2722745.08 | -2727369.08 | | 2006 | 2007 | 2008 | 2009 | | | 2010 | 2011 | 2011 | 2012 | 2012 | 2013 | 2013 | 2014 | 2015 | 2015 | 2016 | 2017 | 2017 | 2018 | 2018 | 2019 | 2019 | 2020 | 2020 | 2021 | 2021 | 2022 | 2023 | 2023 | 2024 | 2024 | 2025 | 2025 | 2026 | 2026 | 2027 | 2027 Account Number | Description | Actual | Adopted | Adopted | Adopted | | | Adopted | Adopted | 12 month estim | Adopted | 12 month estim | Adopted | 12 month estim | Adopted | Adopted | 12 month estim | Adopted | Adopted | 12 month estim | addopted | 12 month estim | addopted | 12 month estim | Requested | 12 month estim | Requested | 12 month estim | Requested | Requested | 12 month estim | Requested | 12 month estim | Requested | 12 month estim | Requested | 12 month estim | Requested | 12 month estim 135 | Dept | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 295-130-510-11 | Full-Time Wages | 0 | 104000 | 163000 | 205415 | | | 179900 | 166600 | 166600 | 180300 | 180300 | 245200 | 245200 | 256800 | 284000 | 256800 | 302105 | 332000 | 332000 | 331200 | 331200 | 349500 | 349500 | 399099 | 399099 | 415309 | 415309 | 416994 | 456287 | 456287 | 400587 | 375000 | 417745 | 417745 | 422320 | 417745 | 435282 | 422320 295-130-510-15 | Part-Time Wages | 0 | 4000 | 4000 | 6500 | | | 12000 | 16900 | 16900 | 37740 | 37740 | 1000 | 1000 | 3125 | 4000 | 3125 | 8000 | 0 | 0 | 0 | 0 | 0 | | 0 | 25.14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 295-130-510-19 | Overtime | 0 | 750 | 750 | 1500 | | | 1500 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 1000 | 2000 | 225 | 500 | 0 | 500 | 500 | 743 | 500 | 500 | 500 | 286 | 500 | 286 | 500 | 500 295-130-520-21 | FICA Taxes | 0 | 8250 | 12800 | 16400 | | | 14750 | 14100 | 14100 | 17000 | 17000 | 19250 | 19250 | 20200 | 22250 | 20200 | 23950 | 25600 | 25600 | 25500 | 25500 | 26925 | 26925 | 30725 | 30725 | 31810 | 31810 | 31900 | 34944 | 34944 | 30683 | 28500 | 31996 | 31996 | 32346 | 31996 | 33337 | 32346 295-130-520-22 | PERSI (State Retirement) | 0 | 11600 | 17700 | 22000 | | | 19100 | 18100 | 18100 | 23350 | 23350 | 26400 | 26400 | 29500 | 32600 | 29500 | 34620 | 37900 | 37975 | 38700 | 38700 | 40800 | 40800 | 46100 | 46100 | 49650 | 49650 | 49789 | 54540 | 54540 | 47128 | 43875 | 51664 | 51664 | 50569 | 51664 | 52120 | 50569 295-130-520-23 | Unemployment Insurance | 0 | 325 | 525 | 650 | | | 590 | 9370 | 9370 | 675 | 675 | 750 | 750 | 800 | 875 | 800 | 1200 | 1000 | 1050 | 1020 | 1478.59 | 1075 | 1075 | 1250 | 1250 | 1250 | 1250 | 1251 | 1370 | 1370 | 1203 | 1118 | 1255 | 1255 | 1268 | 1255 | 1307 | 1268 295-130-520-24 | Worker's Compensation | 0 | 500 | 700 | 780 | | | 700 | 550 | 550 | 650 | 650 | 700 | 630 | 750 | 800 | 750 | 1000 | 1000 | 1050 | 1100 | 1100 | 1100 | 1100 | 1225 | 1225 | 1050 | 1050 | 883 | 1083 | 1083 | 1034 | 960 | 914 | 914 | 798 | 914 | 692 | 798 295-130-520-25 | Health & Accident Insurance | 0 | 14000 | 21800 | 34000 | | | 22700 | 23710 | 23710 | 33200 | 33200 | 34500 | 34500 | 46200 | 43300 | 46200 | 44915 | 58000 | 56300 | 51100 | 51100 | 46300 | 42124 | 65825 | 65825 | 57615 | 57615 | 54978 | 71621 | 71621 | 70015 | 70015 | 84919 | 84919 | 89015 | 84919 | 93900 | 89015 295-130-520-26 | Life Insurance | 0 | 500 | 700 | 900 | | | 1000 | 1000 | 1000 | 1250 | 1250 | 1375 | 1375 | 1450 | 1550 | 1450 | 1875 | 1800 | 1875 | 1800 | 1800 | 1900 | 1360 | 2175 | 2175 | 2190 | 2190 | 2835 | 3124 | 3124 | 2727 | 961 | 2839 | 2839 | 2868 | 2839 | 2952 | 2868 | Personal Services | 0 | 143925 | 221975 | 288145 | | | 252240 | 253330 | 253330 | 297165 | 297165 | 332175 | 332105 | 361825 | 392375 | 361825 | 419665 | 459300 | 457850 | 452420 | 452878.59 | 469600 | 463884 | 548399 | 546649.14 | 559374 | 559374 | 559130 | 623469 | 623712 | 553877 | 520929 | 591832 | 591618 | 599684 | 591618 | 620090 | 599684 295-130-642-10 | Professional Services | 0 | 14000 | 5500 | 12000 | | | 10000 | 10000 | 10000 | 19000 | 19000 | 19000 | 18000 | 19000 | 19000 | 19000 | 19000 | 24000 | 19000 | 26200 | 21200 | 26200 | 26200 | 26200 | 26200 | 26200 | 26200 | 26200 | 31500 | 31500 | 92500 | 45000 | 80500 | 9000 | 80500 | 9000 | 80500 | 80500 295-130-642-31 | Professional Services - General Govt | 0 | 5500 | 2400 | 300 | | | 33775 | 0 | 0 | 1200 | 1200 | 5420 | 420 | 1300 | 0 | 1300 | 43952 | 90901.34 | 10901.339999999997 | 0 | 17500 | 32500 | 32500 | 84709 | 76709 | 15000 | 41925 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 27000 | 15000 295-132-642-32 | Professional Services - Public Safety | 0 | 650 | 600 | 17150 | | | 18350 | 2225 | 2225 | 3500 | 2000 | 950 | 950 | 2505 | 6140 | 2505 | 11700 | 23100 | 15000 | 14115 | 9890 | 7900 | 7900 | 9000 | 9000 | 58600 | 58600 | 30990 | 800 | 800 | 20240 | 21100 | 250 | 250 | 7800 | 250 | 13000 | 13000 295-133-642-33 | Professional Services - Rec & Culture | 0 | 0 | 900 | 0 | | | 1500 | 0 | 0 | 1000 | 1000 | 0 | 0 | 0 | 0 | 0 | 2400 | 911.3399999999999 | 911 | 0 | 0 | 300 | 300 | 4500 | 4602.69 | 16200 | 16200 | 9100 | 600 | 600 | 0 | 0 | 0 | 0 | 0 | 0 | 12000 | 0 295-150-642-50 | Professional Services - Streets | 0 | 0 | 1000 | 1000 | | | 1000 | 0 | 0 | 0 | 0 | 2500 | 2500 | 0 | 0 | 0 | 1170 | 0 | 0 | 4225 | 0 | 1300 | 1300 | 25800 | 25800 | 500 | 500 | 600 | 0 | 0 | 0 | 0 | 350 | 350 | 0 | 350 | 20500 | 52500 295-240-642-80 | Professional Services - Sanitation | 0 | 0 | 3000 | 3000 | | | 3000 | 43580 | 43580 | 0 | 0 | 0 | 0 | 995 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 295-230-642-70 | Professional Services - Sewer | 0 | 0 | 3000 | 3000 | | | 3000 | 0 | 0 | 8000 | 8000 | 8665 | 8665 | 0 | 5300 | 0 | 19489 | 4000 | 4000 | 0 | 0 | 0 | 0 | 1200 | 1200 | 500 | 500 | 37500 | 0 | 27019 | 0 | | 16000 | 10000 | 5300 | 10000 | 30000 | 50000 295-220-642-60 | Professional Services - Water | 0 | 1000 | 3000 | 38000 | | | 3000 | 35000 | 35000 | 0 | 0 | 3450 | 3450 | 0 | 0 | 0 | 20089 | 0 | 0 | 15000 | 15000 | 800 | 800 | 0 | 0 | 37000 | 37000 | 15000 | 0 | 0 | 3000 | 3000 | 0 | 0 | 200 | 0 | 30000 | 50000 295-130-642-95 | Professional Services - IS | 0 | 70420 | 95920 | 96120 | | | 125500 | 129300 | 106500 | 228365 | 253365 | 252060 | 252060 | 308960 | 403920 | 308960 | 341884.95 | 342746.29000000004 | 342746.29000000004 | 359904.95 | 369704.95 | 378246 | 422246 | 470426 | 466426 | 488366 | 495000 | 501451 | 578041 | 578041 | 594205 | 525000 | 543824.76 | 543825 | 534333 | 543825 | 565267.61 | 564667.61 295-235-642-75 | Professional Services - Storm Water | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 2000 | 2000 | 0 | 0 | 0 | 0 | 0 | 0 | 18000 | 50000 295-130-668-10 | Insurance | | | | | | | | 1235 | 1235 | 1235 | 1235 | 7030 | 7030 | 7030 | 7130 | 7030 | 6100 | 6880 | 6880 | 6765 | 6765 | 8723 | 8723 | 9137 | 9137 | 9137 | 9137 | 9137 | 9137 | 10919 | 11374 | 11374 | 9137 | 28820 | 19121 | 28820 | 4298 | 19121 295-130-642-55 | VEBA Program | | | | 1500 | | | 750 | 750 | 750 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 750 | 1000 | 1000 | 1000 | 1000 | 1750 | 1750 | 1750 | 1750 | 1750 | 2500 | 2500 | 2500 | 3000 | 3830 | 3000 | 21238 | 3000 | 4700 | 3000 | 4700 | 3000 | 3000 295-135-10-670-15 | Televised Council Meetings | 0 | 2000 | 0 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | 0 | 0 | Contractual | 0 | 93570 | 115320 | 172070 | | | 199875 | 222090 | 199290 | 263300 | 286800 | 300075 | 294075 | 340790 | 442490 | 339545 | 466784.95 | 493538.97000000003 | 400438.63 | 427209.95 | 441809.95 | 457719 | 501719 | 632722 | 620824.69 | 653253 | 687562 | 642478 | 625078 | 654709 | 724319 | 626712 | 653061.76 | 596945 | 650254 | 596945 | 803565.61 | 897788.61 295-130-631-05 | Office Supplies | 0 | 200 | 200 | 400 | | | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 500 | 400 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 8500 | 1500 | 1500 | 1500 | 800 | 1500 | 870 | 1500 | 870 | 1500 | 1500 295-130-631-10 | Postage Expense | 0 | 150 | 150 | 150 | | | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 300 | 600 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 500 | 500 | 500 | 500 | 600 | 600 | 600 | 600 | 0 | 500 | 100 | 500 | 100 | 500 | 500 295-130-632-40 | Department Supplies | 0 | 1500 | 3000 | 6000 | | | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 7000 | 6000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 8500 | 8500 | 8500 | 7000 | 8500 | 8500 | 9500 | 8500 | 9500 | 9500 295-130-647-10 | Travel & Meetings | 0 | 200 | 200 | 1000 | | | 2000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 1500 | 3000 | 1500 | 3000 | 1500 | 3000 | 200 | 3000 | 3000 | 3000 | 3000 | 500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 295-130-648-10 | Dues, Subscriptions & Memberships | 0 | 300 | 200 | 300 | | | 300 | 300 | 350 | 400 | 400 | 400 | 0 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 0 | 400 | 400 | 400 | 400 | 500 | 500 | 500 | 500 | 500 | 500 | 500 295-130-649-10 | Professional Development | 0 | 4000 | 3500 | 10000 | | | 9000 | 7500 | 7500 | 12000 | 12000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 11500 | 11500 | 11500 | 11500 | 11500 | 3500 | 0 | 1100 | 12000 | 12000 | 12000 | 12000 | 4000 | 10000 | 4000 | 10000 | 4000 | 10000 | 10000 295-130-651-10 | Telephones & Communications | 0 | 5450 | 1350 | 25350 | | | 1650 | 1500 | 443.46 | 63950 | 63950 | 73435 | 73435 | 75835 | 76395 | 75835 | 65175 | 68743 | 68743 | 67441 | 67441 | 76101 | 76101 | 76101 | 76101 | 76701 | 76701 | 82101 | 86266 | 86266 | 90466 | 80000 | 77640 | 77640 | 71320 | 77640 | 75472 | 75472 295-130-652-20 | Utility Expense | 0 | 0 | 2000 | 2000 | | | 3500 | 3500 | 3236.18 | 3500 | 3557.1 | 3500 | 3670.7 | 4000 | 4000 | 3719 | 4000 | 4000 | 3979 | 4000 | 3909 | 4000 | 3908 | 4000 | 4000 | 4000 | 4000 | 4000 | 4600 | 5564 | 6200 | 9157 | 9200 | 10178 | 10200 | 10178 | 10200 | 10200 295-130-658-40 | R & M - Equipment | 0 | 200 | 200 | 200 | | | 200 | 200 | 0 | 200 | 200 | 200 | 200 | 200 | 600 | 500 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 400 | 600 | 600 | 600 | 600 | 600 | 600 295-130-669-20 | Recruitment Expense | 0 | 200 | 200 | 200 | | | 200 | 200 | 0 | 200 | 200 | 200 | 0 | 200 | 0 | 200 | 200 | 200 | 200 | 200 | 0 | 200 | 0 | 200 | 200 | 200 | 0 | 200 | 200 | 200 | 200 | 150 | 200 | 0 | 200 | 0 | 200 | 200 295-130-681-01 | Internal Service Charge - General Fund | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 120859 | 90180 | 120859 | 130434 | 91155 295-130-685-01 | Fleet Services Supplies | 0 | 0 | 120 | 160 | | | 140 | 555 | 555 | 585 | 585 | 410 | 410 | 430 | 430 | 430 | 400 | 345 | 345 | 365 | 260 | 260 | 260 | 357 | 357 | 385 | 385 | 400 | 603 | 603 | 540 | 540 | 451 | 451 | 366 | 451 | 229 | 366 295-130-685-02 | Fleet Services R&M | 0 | 0 | 825 | 1625 | | | 1435 | 1470 | 1470 | 660 | 660 | 595 | 595 | 490 | 490 | 490 | 605 | 640 | 640 | 695 | 695 | 850 | 850 | 1224 | 1224 | 360 | 360 | 400 | 350 | 357 | 250 | 250 | 185 | 185 | 194 | 185 | 845 | 194 295-130-690-30 | Minor Equipment - Gen Govt | 0 | 18700 | 4600 | 26350 | | | 41700 | 11800 | 11800 | 7000 | 7000 | 24000 | 24000 | 21015 | 7950 | 24000 | 11850 | 33300 | 33300 | 12600 | 34500 | 2100 | 2100 | 16600 | 16600 | 24300 | 19000 | 20285 | 10900 | 10900 | 32775 | 16000 | 9000 | 8753 | 6000 | 8753 | 3900 | 1950 295-132-690-32 | Minor Equipment - Public Safety | 0 | 26700 | 6100 | 22600 | | | 26100 | 33200 | 33200 | 9500 | 9500 | 20700 | 20700 | 27400 | 23700 | 27400 | 54200 | 64100 | 64100 | 57225 | 79725 | 50850 | 50850 | 46025 | 42025 | 71600 | 71600 | 61525 | 33100 | 33100 | 111550 | 47500 | 43600 | 36000 | 39225 | 36000 | 22980 | 13140 295-133-690-33 | Minor Equipment - Rec & Culture | | 14000 | 5200 | 14200 | | | 1500 | 7400 | 7400 | 5300 | 5300 | 10200 | 10200 | 7400 | 12900 | 7400 | 1075 | 19750 | 19750 | 8875 | 25075 | 18600 | 18600 | 11550 | 11550 | 11100 | 11100 | 15975 | 12700 | 14933 | 23525 | 12100 | 3600 | 2814 | 12975 | 2814 | 23470.08 | 19870.08 295-150-690-50 | Minor Equipment - Streets | 0 | 0 | 1300 | 2600 | | | 0 | 0 | 0 | 1300 | 1300 | 3300 | 3300 | 600 | 3900 | 4800 | 1450 | 7700 | 7700 | 1800 | 6000 | 4975 | 4975 | 5275 | 5275 | 4200 | 4200 | 4400 | 10300 | 10300 | 10450 | 5100 | 1920 | 1424 | 3520 | 1424 | 2400 | 1200 295-230-690-70 | Minor Equipment - Sewer | 0 | 1300 | 1300 | 1300 | | | 13500 | 0 | 0 | 4025 | 4025 | 6775 | 6775 | 9175 | 5400 | 9175 | 3600 | 500 | 758 | 9300 | 9300 | 2100 | 2100 | 16600 | 16600 | 1200 | 1200 | 5100 | 0 | 0 | 24015 | 12500 | 1500 | 1500 | 6070 | 1500 | 6000 | 6000 295-220-690-60 | Minor Equipment - Water | 0 | 8500 | 4800 | 8700 | | | 425 | 2600 | 2666.35 | 12700 | 12700 | 15900 | 15900 | 2750 | 21200 | 2750 | 14100 | 34300 | 34300 | 5300 | 19100 | 22875 | 22875 | 18800 | 18800 | 9900 | 9900 | 14300 | 2600 | 8490 | 30450 | 13400 | 1500 | 1500 | 11495 | 1500 | 4800 | 2400 295-130-690-95 | Minor Equipment - IS | 0 | 30500 | 26000 | 34450 | | | 21300 | 15000 | 15000 | 14000 | 14000 | 18500 | 18500 | 19700 | 17700 | 22700 | 16000 | 17600 | 17600 | 26900 | 30500 | 31400 | 31400 | 56100 | 56100 | 20300 | 125000 | 14000 | 22200 | 22200 | 25450 | 9600 | 32000 | 32000 | 35900 | 32000 | 36100 | 35550 295-240-690-80 | Minor Equipment - Sanitation | | | | | | | | 0 | | 0 | 0 | 0 | | 0 | | 0 | 0 | 2700 | 2700 | 0 | 2100 | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 320 | 0 | 0 | 0 295-235-690-75 | Minor Equipment - Storm Water | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 3000 | 3000 | 0 | 875 | 1500 | 1424 | 3520 | 1424 | 0 | 0 | Commodities | 0 | 111900 | 61245 | 157585 | | | 129500 | 94775 | 93170.99 | 144870 | 144927.1 | 196665 | 196235.7 | 188145 | 194865 | 198799 | 193455 | 274678 | 274915 | 218001 | 300405 | 237611 | 235819 | 276332 | 262832 | 236246 | 333346 | 254786 | 213419 | 222513 | 382471 | 220372 | 206396 | 311798 | 316585 | 311798 | 342130.08 | 282797.08 295-130-770-74 | Equipment | 0 | 18185 | 10000 | 89000 | | | 24500 | 30000 | 29972.43 | 60000 | 10000 | 63000 | 63000 | 5000 | | 5000 | 17500 | 50000 | 50000 | 452500 | 452500 | 0 | 0 | 12500 | 7143 | 12000 | 12000 | 1490266.6666666667 | 2497034 | 197126 | 2346573 | 990000 | 1354678 | 1802355 | 0 | 1802355 | 0 | 13260 295-132-770-74 | Equipment - Public Safety | 0 | 40115 | 7500 | 64745 | | | 60905 | 11500 | 31156 | 126500 | 186690 | 119275 | 119275 | 53600 | | 53600 | 5000 | 15100 | 15100 | 0 | 0 | 15732 | 15732 | 53000 | 23286 | 75000 | 145000 | 117000 | 14200 | 14200 | 0 | 0 | 15000 | 14210 | 0 | 14210 | 22970 | 22970 295-133-770-74 | Equipment - Rec & Culture | 0 | 10500 | 0 | 4500 | | | 4500 | 9000 | 9000 | 5500 | 14500 | 0 | 0 | 23000 | | 20008 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25000 | 14286 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | 0 | 0 295-150-770-74 | Equipment - Streets | | | | 7000 | | | 900 | 1800 | 1800 | 0 | 1800 | 0 | 0 | 0 | | 0 | 0 | 5000 | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 7500 | 7500 | 0 | 0 | 6500 | 0 | 0 | 0 | | | | 0 | 0 295-240-770-74 | Equipment - Sanitation | | | | 6000 | | | 0 | 33200 | 33200 | 0 | 2800 | 0 | 0 | 0 | | 0 | 2500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | 0 | 0 | 0 | 0 | | | | 0 | 0 295-230-770-74 | Equipment - Sewer | 0 | 0 | 11500 | 30500 | | | 4050 | 8100 | 8100 | 5500 | 13600 | 0 | 0 | 29000 | | 21500 | 12500 | 0 | 0 | 0 | 0 | 0 | 0 | 33500 | 28143 | 0 | 14000 | 0 | 0 | 0 | 0 | 0 | 0 | | | | 0 | 0 295-220-770-74 | Equipment - Water | | | | 30500 | | | 4050 | 24600 | 21840 | 6000 | 14100 | 0 | 0 | 11500 | | 11300 | 2500 | 12500 | 12500 | 6000 | 6000 | 0 | 0 | 111500 | 106143 | 52000 | 99500 | 56000 | 0 | 0 | 0 | 0 | 7500 | 5166 | 0 | 5166 | 0 | 0 295-235-770-74 | Equipment - Storm Water | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 0 | 0 | 0 | 0 | 0 | | | | 0 | 0 | Capital Outlay | 0 | 68800 | 29000 | 201745 | | | 94855 | 118200 | 135068.43 | 203500 | 243490 | 182275 | 182275 | 122100 | | 111408 | 40000 | 82600 | 82600 | 458500 | 458500 | 15732 | 15732 | 235500 | 179001 | 146500 | 278000 | 1663266.6666666667 | 2511234 | 217826 | 2346573 | 990000 | 1377178 | 1821731 | 0 | 1821731 | 22970 | 36230 295-130-890-01 | Transfer To: General Fund | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 188760 | 188760 | 0 | 0 | 0 | 0 | 0 | 0 295-130-890-90 | Transfer To: Fleet Fund | 0 | 0 | 4000 | 8000 | | | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | | 4000 | 4000 | 141593 | 141593 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 0 | 0 | 4000 | 4000 | 4000 | 5000 | 5000 | 0 | 5000 | 5000 | 5000 | 0 | 5000 | Transfers To | 0 | 0 | 4000 | 8000 | | | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | | 4000 | 4000 | 141593 | 141593 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 0 | 0 | 4000 | 4000 | 4000 | 193760 | 193760 | 0 | 5000 | 5000 | 5000 | 0 | 5000 295-130-900-10 | Operating Contingency | 0 | 20000 | 3500 | 25000 | | | 25750 | 25000 | 0 | 27060 | 15000 | 25000 | 25000 | 24995 | | | 40000 | 40000 | 0 | 40000 | 0 | 50000 | 0 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | | 50000 | 0 | 0 | 50000 | 50975 | 50000 | 0 | 50000 | Contingency | 0 | 20000 | 3500 | 25000 | | | 25750 | 25000 | 0 | 27060 | 15000 | 25000 | 25000 | 24995 | | | 40000 | 40000 | 0 | 40000 | 0 | 50000 | 0 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 0 | 50000 | 0 | 0 | 50000 | 50975 | 50000 | 0 | 50000 295-130-990-05 | Ending Fund Balance - Restricted | 0 | 0 | 42910 | 191565 | | | 135585 | 30000 | | 82470 | 82470 | 103821 | 103821 | 17270 | | | 0 | 14277 | | 0 | | 0 | | 0 | 16302 | 25499 | | 13295 | 1556726 | 4356187 | 1892215 | 1562962 | 574552 | 1939343 | 943511 | 1939343 | 933989.39 | 943511.49 | | 2414430 | Ending Fund Balance | 0 | 0 | 42910 | 191565 | | | 135585 | 30000 | 0 | 82470 | 82470 | 103821 | 103821 | 17270 | | | 0 | 14277 | 0 | 0 | | 0 | | 0 | 16302 | 25499 | | 13295 | 1556726 | 4356187 | 1892215 | 1562962 | 574552 | 1939343 | 943511 | 1939343 | 933989.39 | 943511.49 | Total IS Expense | 0 | 438195 | 477950 | 1044110 | | | 841805 | 747395 | 684859.4199999999 | 1022365 | 1073852.1 | 1144011 | 1137511.7 | 1059125 | | 1015577 | 1163904.95 | 1505986.97 | 1357396.63 | 1600130.95 | 1657593.54 | 1234662 | 1221154 | 1746953 | 1679608.83 | 1670872 | | 3186955.666666667 | 5583926 | 6078947 | 6143215 | 4114735 | 3403019.76 | 5316435 | 2566009 | 5316435 | 2722745.08 | 2815011.18 | | | | | | | | | | | | | | | | | | | | | | | | | | | balanced | | 4840.996666667052 | | 0 | 0 | -2232202 | -125859.24000000022 | 0 | 0 | -56863 | 0 | 87642.1000000001 [98 non-empty rows] === Sheet: Future === Capital Contingency total | 0 [2 non-empty rows] === Sheet: Budget Recap === | | | 2027 Account Number | Description | | Requested 295 | Information Systems | | 295-000-431-26 | Federal Grant - Fire FEMA 295-000-431-30 | Federal Grant - Office Of Highway Safety 295-000-431-46 | Federal Grant - MDT'S 295-000-434-01 | State Grant Revenue | Intergovernmental Revenues | | 0 295-000-448-70 | Information System Service Fees | | -1639690 | Charges for Services | | -1639690 295-000-471-00 | Investment Earnings | | -123106 | Investment Earnings | | -123106 295-000-479-01 | Refunds & Reimbursements | | -58400 | Refunds and Reimbursements | | -58400 295-000-498-01 | Transfer In: General Fund | | -31300 | 0.17777012425961297 295-000-498-50 | Transfer In: Streets Fund | | -20500 | 0.11643091205501808 295-000-498-33 | Transfer In: Rec & Culture Fund | | -28270.08 | 0.1605615218667476 295-000-498-80 | Transfer In: Sanitation Fund | | 0 | 0 295-000-498-25 | Transfer In: Arts | | 0 | 0 295-000-498-10 | Transfer In: Community Events | | 0 | 0 295-000-498-90 | Transfer In: Fleet Fund | | -12000 | 0.06815468022732765 295-000-498-60 | Transfer In: Water Fund | | -30000 | 0.17038670056831914 295-000-498-70 | Transfer In: Sewer Fund | | -36000 | 0.20446404068198298 295-000-498-75 | Transfer In: Storm Water | | -18000 | 0.10223202034099149 | Transfers In | | -176070.08000000002 295-000-900-05 | Fund Balance - Restricted | | -725479 | Other Financing Sources | | -725479 | Total IS Revenue | | -2722745.08 | | | 2027 | 2027 | 2027 | 2027 | 2027 Account Number | Description | | Total | Centralized | Replacement hardware and Software renewal | new | From Accumulation 295-130-510-11 | Full-Time Wages | | 435282 | 435282 295-130-510-15 | Part-Time Wages | | 0 | 0 295-130-510-19 | Overtime | | 500 | 500 295-130-520-21 | FICA Taxes | | 33337 | 33337 295-130-520-22 | PERSI (State Retirement) | | 52120 | 52120 295-130-520-23 | Unemployment Insurance | | 1307 | 1307 295-130-520-24 | Worker's Compensation | | 692 | 692 295-130-520-25 | Health & Accident Insurance | | 93900 | 93900 295-130-520-26 | Life Insurance | | 2952 | 2952 | Personal Services | | 620090 | 620090 | 0 | 0 295-130-642-10 | Professional Services | | 80500 | 80500 295-130-642-55 | VEBA Program | | 3000 | 3000 295-130-668-10 | Insurance | | 4298 | 4298 295-130-642-31 | Professional Services - General Govt | | 27000 | | | 27000 | 0 295-132-642-32 | Professional Services - Public Safety | | 13000 | | | 13000 | 0 295-133-642-33 | Professional Services - Rec & Culture | | 12000 | | | 12000 | 0 295-150-642-50 | Professional Services - Streets | | 20500 | | | 20500 | 0 295-240-642-80 | Professional Services - Sanitation | | 0 | | | 0 | 0 295-230-642-70 | Professional Services - Sewer | | 30000 | | | 30000 | 0 295-220-642-60 | Professional Services - Water | | 30000 | | | 30000 | 0 295-130-642-95 | Professional Services - IS | | 565267.61 | 234450.61000000002 | 330817 295-235-642-75 | Professional Services - Storm Water | | 18000 | | | 18000 | 0 | Contractual | | 803565.61 | 322248.61 | 330817 | 150500 | 0 295-130-631-05 | Office Supplies | | 1500 | 1500 295-130-631-10 | Postage Expense | | 500 | 500 295-130-632-40 | Department Supplies | | 9500 | 9500 295-130-647-10 | Travel & Meetings | | 2500 | 2500 295-130-648-10 | Dues, Subscriptions & Memberships | | 500 | 500 295-130-649-10 | Professional Development | | 10000 | 10000 | | 0 295-130-651-10 | Telephones & Communications | | 75472 | 55600 | 19872 295-130-652-20 | Utility Expense | | 10200 | 10200 295-130-658-40 | R & M - Equipment | | 600 | 600 295-130-669-20 | Recruitment Expense | | 200 | 200 295-130-681-01 | Internal Service Charge - General Fund | | 130434 | 130434 295-130-685-01 | Fleet Services Supplies | | 229 | 229 | | 0 295-130-685-02 | Fleet Services R&M | | 845 | 845 295-130-690-30 | Minor Equipment - Gen Govt | | 3900 | | 3900 | 0 | 0 295-132-690-32 | Minor Equipment - Public Safety | | 22980 | | 19680 | 3300 | 0 295-133-690-33 | Minor Equipment - Rec & Culture | | 23470.08 | | 7200 | 16270.08 | 0 295-150-690-50 | Minor Equipment - Streets | | 2400 | | 2400 | 0 | 0 295-240-690-80 | Minor Equipment - Sanitation | | 0 | | 0 | 0 | 0 295-230-690-70 | Minor Equipment - Sewer | | 6000 | | 0 | 6000 | 0 295-220-690-60 | Minor Equipment - Water | | 4800 | | 4800 | 0 | 0 295-130-690-95 | Minor Equipment - IS | | 36100 | 35000 | 1100 | | 0 295-235-690-75 | Minor Equipment - Storm Water | | 0 | | 0 | 0 | 0 | Commodities | | 342130.08 | 257608 | 58952 | 25570.08 | 0 295-130-770-74 | Equipment | | 0 | 0 | 0 | 0 | 0 295-132-770-74 | Equipment - Public Safety | | 22970 | 0 | 22970 | 0 | 0 295-133-770-74 | Equipment - Rec & Culture | | 0 | 0 | 0 | 0 | 0 295-230-770-74 | Equipment - Sewer | | 0 | 0 | 0 | 0 | 0 295-220-770-74 | Equipment - Water | | 0 | 0 | 0 | 0 | 0 295-150-770-74 | Equipment - Streets | | 0 | 0 | 0 | 0 | 0 295-240-770-74 | Equipment - Sanitation | | 0 | 0 | 0 | 0 | 0 295-235-770-74 | Equipment - Storm Water | | 0 | | 0 | 0 | 0 | Capital Outlay | | 22970 | 0 | 22970 | 0 | 0 295-130-890-01 | Transfer To: General Fund | | 0 | 0 295-130-890-90 | Transfer To: Fleet Fund | | 0 | 0 | Transfers To | | 0 | 0 | 0 | 0 | 0 295-130-900-10 | Operating Contingency | | | 0 | Contingency | | 0 | 0 | 0 | 0 295-130-990-05 | Ending Fund Balance - Restricted | | 933989.39 | Ending Fund Balance | | 933989.39 | 0 | 0 | 0 | Total IS Expense | | 2722745.08 | 1199946.6099999999 | 412739 | 176070.08000000002 | 0 | Difference ==> | | 0 | 0 | 321014 | 0 | Fund Balance | | 0 [95 non-empty rows] === Sheet: Switch replacement fy26 & fy27 === crea centralized | | | buy for year 2 existing switches to replace | | | bought in year 1 | | | | | | | INVENTORY NUMBERS model | desc | location | Column1 | Column2 | juniper replacement ex2300 | meraki replacemtn ms150 | cataylst c9200L | | | 10p(2 of these equal 1 24p, round up) | 3 | 500 | 1500 SG250-10P-K9-NA | ^Cisco SG250-10P 10-port Gigabit PoE Switch | desks | year 1 | | 800 | 600 | 600 | | | 24p | 11 | 1500 | 16500 SG250-10P-K9-NA | ^Cisco SG250-10P 10-port Gigabit PoE Switch | desks | year 1 | | 800 | 600 | 600 | | | 48p | 2 | 2500 | 5000 SG250-10P-K9-NA | ^Cisco SG250-10P 10-port Gigabit PoE Switch | desks | year 1 | | 800 | 600 | 600 | | | | | | 23000 SG350X-24P-K9-NA | ^Cisco SG350X-24P 24-port Gigabit POE Stackable Switch | | year 1 | | 1389 | 1347 | 1300 SG350X-24P-K9-NA | ^Cisco SG350X-24P 24-port Gigabit POE Stackable Switch | | year 1 | | 1389 | 1347 | 1300 SG350X-24P-K9-NA | ^Cisco SG350X-24P 24-port Gigabit POE Stackable Switch | | year 1 | | 1389 | 1347 | 1300 SG350X-24P-K9-NA | ^Cisco SG350X-24P 24-port Gigabit POE Stackable Switch | | year 1 | | 1389 | 1347 | 1300 SG350X-24P-K9-NA | ^Cisco SG350X-24P 24-port Gigabit POE Stackable Switch | | year 1 | | 1389 | 1347 | 1300 SG350X-48MPK9EU-WS | ^Cisco SG350X-48MP 48-port GB POE StackableSwitch REFURBISHED | | year 1 | | 2336 | 2152 | 2310 SG350X-48MP-K9-NA | ^Cisco SG350X-48MP 48-port Gigabit POE Stackable Switch | | year 1 | | 2136 | 2152 | 2310 SG350X-48P-K9-NA | ^Cisco SG350X-48P 48-port Gigabit POE Stackable Switch | | year 1 | | 2336 | 2152 | 2310 SG350X-48P-K9-NA | ^Cisco SG350X-48P 48-port Gigabit POE Stackable Switch | | year 1 | | 2336 | 2152 | 2310 SG250-10P-K9-NA | ^Cisco SG250-10P 10-port Gigabit PoE Switch | desks | year 2 | | 800 | 600 | 600 SG350-10P-K9-NA | Cisco SG350-10P 10-port Gigabit POE Managed Switch | chambers | year 2 | | 800 | 600 | 600 SG350-10P-K9-NA | Cisco SG350-10P 10-port Gigabit POE Managed Switch | county? | year 2 | | 800 | 600 | 600 SG350-10P-K9-NA | Cisco SG350-10P 10-port Gigabit POE Managed Switch | ? | year 2 | | 800 | 600 | 600 SG350X-24MP-K9-NA | ^Cisco SG350X-24MP 24-port Gigabit POE Stackable Switch | | year 2 | | 1389 | 1347 | 1300 SG350X-24MP-K9-NA | ^Cisco SG350X-24MP 24-port Gigabit POE Stackable Switch | | year 2 | | 1389 | 1347 | 1300 SG350X-24P-K9-NA | ^Cisco SG350X-24P 24-port Gigabit POE Stackable Switch | | year 2 | | 1389 | 1347 | 1300 SG350X-24P-K9-NA | ^Cisco SG350X-24P 24-port Gigabit POE Stackable Switch | | year 2 | | 1389 | 1347 | 1300 SG350X-24P-K9-NA | ^Cisco SG350X-24P 24-port Gigabit POE Stackable Switch | | year 2 | | 1389 | 1347 | 1300 SG350X-24P-K9-NA | ^Cisco SG350X-24P 24-port Gigabit POE Stackable Switch | | year 2 | | 1389 | 1347 | 1300 SG350X-24P-K9-NA | ^Cisco SG350X-24P 24-port Gigabit POE Stackable Switch | | year 2 | | 1389 | 1347 | 1300 SG350X-24P-K9-NA | ^Cisco SG350X-24P 24-port Gigabit POE Stackable Switch | | year 2 | | 1389 | 1347 | 1300 SG350X-24P-K9-NA | ^Cisco SG350X-24P 24-port Gigabit POE Stackable Switch | | year 2 | | 1389 | 1347 | 1300 SG350X-24P-K9-NA | ^Cisco SG350X-24P 24-port Gigabit POE Stackable Switch | | year 2 | | 1389 | 1347 | 1300 SG350X-48P-K9-NA | ^Cisco SG350X-48P 48-port Gigabit POE Stackable Switch | | year 2 | | 2336 | 2152 | 2310 SG550XG-24F-K9-NA | ^Cisco SG550XG-24F 24-Port 10G SFP+ Stackable Managed Switch | san | | | | | getting replaced in 2nd half of fy25 unless over budget SG550XG-24F-K9-NA | ^Cisco SG550XG-24F 24-Port 10G SFP+ Stackable Managed Switch | san | | | | | getting replaced in 2nd half of fy25 unless over budget SG550XG-24F-K9-NA | ^Cisco SG550XG-24F 24-Port 10G SFP+ Stackable Managed Switch | coreaux | | | | | getting replaced in 2nd half of fy25 unless over budget SG550XG-24F-K9-NA | ^Cisco SG550XG-24F 24-Port 10G SFP+ Stackable Managed Switch | coreaux | | | | | getting replaced in 2nd half of fy25 unless over budget C9500-24Y4C-A | Catalyst 9500 24x1/10/25G and 4-port 40/100G, Advantage | core | | | | | not eol C9500-24Y4C-A | Catalyst 9500 24x1/10/25G and 4-port 40/100G, Advantage | core | | | | | not eol CBS250-24T-4X-NA | CBS250 Smart 24-port GE, 4x10G SFP+ | old san | | | | | not eol CBS250-24T-4X-NA | CBS250 Smart 24-port GE, 4x10G SFP+ | old san | | | | | not eol CBS250-24T-4X-NA | CBS250 Smart 24-port GE, 4x10G SFP+ | | | | | | not eol | | | | | 37915 | 35165 | 35250 [40 non-empty rows] === Sheet: Printers Inv detail === | Serial Number | Model | size for inventory | install year | Install Date | Install Location | replace/replaced in… | notes | Contract Number | Coverage Type | Contract Start Date | Contract End Date | Auto Toner Flag | Auto Toner Status | imageWARE Status | Supply Shipment Address | Packing Slip Information | Shipping Label Instructions | Shipping Label Attention Name | Toner Contact Phone | Order Confirmation Email | Tech Support Name | Tech Support Phone | Tech Support Email Address | 2UA00655 | IRADVDXC3725I | | 2020 | 27-JUN-2020 | 120 W A ST,WATER DEPT,,,MOSCOW, LATAH, ID - 83843-2055 | | | 2746100 | C | 30-SEP-2020 | 29-JUN-2025 | ENABLED | ACTIVE | 30 - IWR ACTIVE | | | FLOWERS JESSE | FLOWERS JESSE | 208.883.7120 | jflowers@ci.moscow.id.us | FLOWERS JESSE | 208-883-7120 | jflowers@ci.moscow.id.us | WXD04481 | IRADVC5550I | | 2016 | 20-DEC-2016 | 155 SOUTHVIEW AVE,POLICE DEPT,,,MOSCOW, LATAH, ID - 83843-2959 | | went to surplus did not sell - at ghormley | 2148249 | C | 28-DEC-2023 | 27-DEC-2024 | NOT ENABLED | INACTIVE | 30 - IWR ACTIVE | | | | Karen Potter | 208 883 7115 | KPOTTER@CI.MOSCOW.ID.US | QLA27044 | IRADV400IF | | 2016 | 26-JUL-2016 | 155 SOUTHVIEW AVE,POLICE DEPT,,,MOSCOW, LATAH, ID - 83843-2959 | FY27 | detectives - could be a small canon | 2066855 | C | 28-JUL-2023 | 27-JUL-2024 | ENABLED | ACTIVE | 30 - IWR ACTIVE | | | | Karen Potter | 208 883 7115 | KPOTTER@CI.MOSCOW.ID.US | XTK13956 | IRADVC3525IV2 | | 2018 | 25-DEC-2018 | 155 SOUTHVIEW AVE,POLICE DEPT,,,MOSCOW, LATAH, ID - 83843-2959 report room | FY27 | | 2503096 | C | 27-DEC-2023 | 26-DEC-2024 | ENABLED | ACTIVE | 30 - IWR ACTIVE | | | | Karen Potter | (208) 883-7115 | kpotter@ci.moscow.id.us | 38M01011 | IRADVDXC5840I | prod | 2021 | 25-OCT-2021 | 155 SOUTHVIEW AVE,POLICE DEPT,,,MOSCOW, LATAH, ID - 83843-2959 ADMIN | | | 2818713 | C | 27-OCT-2021 | 26-OCT-2026 | ENABLED | ACTIVE | 30 - IWR ACTIVE | | | TOM PICARELLA | TOM PICARELLA | 208.883.7120 | TPICARELLA@CI.MOSCOW.ID.US | TOM PICARELLA | 208-883-7120 | TPICARELLA@CI.MOSCOW.ID.US | 4LY02355 | IRADVDXC3930I | | 2024 | 26-NOV-2024 | 155 SOUTHVIEW AVE,POLICE DEPT,,,MOSCOW, LATAH, ID - 83843-2959 | | replaced WXD04481 | 2JH03119 | IRADVC5550IV3 | | 2020 | 27-JUN-2020 | 1724 EAST F ST,H I R C,,,MOSCOW, LATAH, ID - 83843 | | | 2746099 | C | 30-SEP-2020 | 29-JUN-2025 | ENABLED | ACTIVE | 30 - IWR ACTIVE | | | FLOWERS JESSE | FLOWERS JESSE | 208.883.7120 | jflowers@ci.moscow.id.us | FLOWERS JESSE | 208-883-7120 | jflowers@ci.moscow.id.us | WXD01729 | IRADVC5550I | | 2016 | 20-DEC-2016 | 201 N MAIN ST,,,,MOSCOW, LATAH, ID - 83843-2725 | | went to surplus did not sell - at ghormley | 2149769 | C | 29-DEC-2023 | 28-DEC-2024 | NOT ENABLED | INACTIVE | 30 - IWR ACTIVE | | | | | | G***@CI.MOSCOWID.US | 4MK21365 | IRADVDXC3926I | | 2024 | 26-NOV-2024 | 201 N MAIN ST,,,,MOSCOW, LATAH, ID - 83843-2725 | | replaced WXD01729 | 2JH05106 | IRADVC5550IV3 | prod | 2020 | 27-JUN-2020 | 206 E 3RD ST,,,,MOSCOW, LATAH, ID - 83843-2959 - FINANCE backroom | | | 2746109 | C | 30-SEP-2020 | 29-JUN-2025 | ENABLED | ACTIVE | 30 - IWR ACTIVE | | | FLOWERS JESSE | FLOWERS JESSE | 208.883.7120 | jflowers@ci.moscow.id.us | FLOWERS JESSE | 208-883-7120 | jflowers@ci.moscow.id.us | 25V02167 | IRADVDX4735I | med | 2020 | 27-JUN-2020 | 206 E 3RD ST,,,,MOSCOW, LATAH, ID - 83843-2959 - FIN central area | | | 2746118 | C | 30-SEP-2020 | 29-JUN-2025 | ENABLED | ACTIVE | 30 - IWR ACTIVE | | | FLOWERS JESSE | FLOWERS JESSE | 208.883.7120 | jflowers@ci.moscow.id.us | FLOWERS JESSE | 208-883-7120 | jflowers@ci.moscow.id.us | XLA01594 | IRADVC5560I | prod | 2018 | 13-FEB-2018 | 206 E 3RD ST,ADMIN,,,MOSCOW, LATAH, ID - 83843-2959 | FY27 | | 2361829 | C | 16-FEB-2024 | 15-FEB-2025 | ENABLED | ACTIVE | 30 - IWR ACTIVE | | | City Hall 3rd Floor Reception | Taylor Riedner | (208) 883-7080 | TRIEDNER@CI.MOSCOW.ID.US | Information Systems | 208-883-7004 | helpdesk@ci.moscow.id.us | 2UA00626 | IRADVDXC3725I | med | 2020 | 27-JUN-2020 | 206 E 3RD ST,INFORMATIONS SYSTEMS,,,MOSCOW, LATAH, ID - 83843-2919 PAUL MANN HR IS | | | 2745861 | C | 30-SEP-2020 | 29-JUN-2025 | ENABLED | ACTIVE | 30 - IWR ACTIVE | | | FLOWERS JESSE | FLOWERS JESSE | 208.883.7120 | jflowers@ci.moscow.id.us | FLOWERS JESSE | 208-883-7120 | jflowers@ci.moscow.id.us | 2KK03794 | IRADVC5535IV3 | | 2020 | 27-JUN-2020 | 2221 W PULLMAN RD,WASTE WATER TREATMENT,,,MOSCOW, LATAH, ID - 83843-4027 | | | 2746104 | C | 30-SEP-2020 | 29-JUN-2025 | ENABLED | ACTIVE | 30 - IWR ACTIVE | | | FLOWERS JESSE | FLOWERS JESSE | 208.883.7120 | jflowers@ci.moscow.id.us | FLOWERS JESSE | 208-883-7120 | jflowers@ci.moscow.id.us | 2KK03726 | IRADVC5535IV3 | | 2020 | 27-JUN-2020 | 229 PINTAIL LN,FIRE DEPARTMENT,,,MOSCOW, LATAH, ID - 83843-8202 | | | 2746119 | C | 30-SEP-2020 | 29-JUN-2025 | ENABLED | ACTIVE | 30 - IWR ACTIVE | | | FLOWERS JESSE | FLOWERS JESSE | 208.883.7120 | jflowers@ci.moscow.id.us | FLOWERS JESSE | 208-883-7120 | jflowers@ci.moscow.id.us | 4LM08694 | IRADVDXC3935I | | 2024 | 19-NOV-2024 | 504 s washington - enginneering | | replaced WXD03911 | WXD03911 | IRADVC5550I | | 2016 | 21-DEC-2016 | 504 S WASHINGTON ST,COPY RM MAIN FL,,,MOSCOW, LATAH, ID - 83843 | FY27 | went to surplus did not sell - NOW BACK IN SERVICE because they didn’t like 4LM08694 | 2148253 | C | 28-DEC-2023 | 27-DEC-2024 | ENABLED | ACTIVE | 30 - IWR ACTIVE | | | | | | COBRIEN@CI.MOSCOW.ID.US | XTK13962 | IRADVC3525IV2 | | 2018 | 25-DEC-2018 | 504 S WASHINGTON ST,ENGINEERING DOWNSTAIRS,,,MOSCOW, LATAH, ID - 83843 | FY24 | removed to ghormley, replaced with 4LM08694 (because 2nd floor didn’t like it) | 2503098 | C | 27-DEC-2023 | 26-DEC-2024 | ENABLED | ACTIVE | 30 - IWR ACTIVE | | | | | | TORTIZ@CI.MOSCOW.ID.US | RZJ27055 | IR1435IF | | 2017 | 26-APR-2017 | 504 S WASHINGTON ST,FRONT OFC/CDV,,,MOSCOW, LATAH, ID - 83843 | FY27 | | 2217711 | C | 27-APR-2023 | 26-APR-2024 | NOT ENABLED | INACTIVE | 30 - IWR ACTIVE | 2UA00609 | IRADVDXC3725I | | 2020 | 27-JUN-2020 | 603 S MAIN ST,FIRE STATION 1,,,MOSCOW, LATAH, ID - 83843-3039 | | | 2746120 | C | 30-SEP-2020 | 29-JUN-2025 | ENABLED | ACTIVE | 30 - IWR ACTIVE | | | FLOWERS JESSE | FLOWERS JESSE | 208.883.7120 | jflowers@ci.moscow.id.us | FLOWERS JESSE | 208-883-7120 | jflowers@ci.moscow.id.us | 3FY05487 | IRADVDXC3830I | | 2022 | 18-OCT-2022 | 650 N VAN BUREN ST,STREETS DEPT,,,MOSCOW, LATAH, ID - 83843-2770 | | | 2924746 | C | 27-OCT-2022 | 26-OCT-2027 | NOT ENABLED | INACTIVE | 30 - IWR ACTIVE | | | TOM PICARELLA | TOM PICARELLA | 208.883.7120 | TPCARELLA@CI.MOSCOW.ID.US | TOM PICARELLA | 208-883-7120 | TPCARELLA@CI.MOSCOW.ID.US [22 non-empty rows] === Sheet: Camera Project === | HLAC cameras | | | quanity | vivotek CC9390-HV 180* 8mp | | 420 | 6 | 2520 | | Six 180 degree cameras on the exterior of the building and the ticket booth exit. One on each end of the | Exacq EVENIP-01 Enterprise IP Camera License | | 264.88 | 6 | 1589.28 | | building, two facing the pool, and one by the bike rack. | truecable cat6 1000ft | | 322 | 1 | 322 | misc brackets/hardware | | | | 1000 | | | | | 5431.28 | eggan cameras | | | quanity | vivotek CC9390-HV 180* 8mp building sides | | 420 | 3 | 1260 | | Three 180 degree cameras on the exterior north, west and south side of the building. | Vivotek FE9380-HV 360 5mp indoor | | 412 | 2 | 824 | | Two 90 degree cameras on the exterior east side of the building for the skate park and rest rooms. | Vivotek IB9365-HT-A 2mp 4-9mm lens skate prk | | 1066 | 1 | 1066 | | Two 360 degree cameras in the game rooms. | Vivotek IB9399-EHV 8mp outdoor bball court | | 478 | 1 | 478 | Exacq EVENIP-01 Enterprise IP Camera License | | 264.88 | 7 | 1854.1599999999999 | truecable cat6 1000ft | | 322 | 1 | 322 | misc brackets/hardware | | | | 1000 | | | | | 6804.16 | HIRC cameras | | | quanity | vivotek CC9390-HV 180* 8mp building sides | | 420 | 3 | 1260 | | Three 180 degree cameras on the exterior east, west and north side of the building. | Vivotek FE9380-HV 360 5mp indoor | | 412 | 1 | 412 | | Two 90 degree cameras on the exterior northeast and northwest corner to view toward the garden area | Vivotek FD9199-H 8mp 4.2mm gyms ne entry hdmi outs | | 470 | 3 | 1410 | | and bike racks. | Vivotek IB9399-EHV 8mp outdoor garden, bike racks | | 478 | 2 | 956 | | One 360 degree camera in the lobby area to view the front desk, hall towards the locker rooms. | Exacq EVENIP-01 Enterprise IP Camera License | | 264.88 | 9 | 2383.92 | | Three 90 degree interior cameras, one to view the northeast entry, and two cameras in the gym. | truecable cat6 1000ft | | 322 | 2 | 644 | new switch in north equipment room (old switch too far away) | | 1400 | 1 | 1400 | misc brackets/hardware | | | | 1000 | | | | | 9465.92 | | | | | | | https://www.cctvcamerapros.com/Security-Camera-Lens-Comparison-s/90.htm | | | | | | | based on bandwith calc, 22 cameras running full rez is 247.6 Mbit/s or 2.47% of a 10g link | | | | | 21701.36 [28 non-empty rows]