Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
02-04-22 City Manager Report
1 City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 2/4/2022 1. Parks and Recreation Maintenance staff completed a small remodeling project to restore a historical window at the Attorney’s office, in the old water department building, to its original state. Field crews are designing and constructing some small foot bridges to help users better utilize the new section of nature trail along the Lawrence Park that was installed last summer. Forestry staff are pruning trees on the 100 block of 5th Avenue East. Our small tree pruning crew is working in the Stratford Village Subdivision. Kalispell Kickers youth indoor soccer league started this Saturday the 22nd. With 170 plus participants in the program, we were able to schedule, coordinate, and plan 22 teams to play each week for the next 6 weeks. Our ice-skating sessions 4 & 5 are coming up within the next few weeks and have record participation numbers for the program. On Saturday February 12, Kalispell Parks and Recreation will be hosting our annual Valentine's Day Dance at Linderman Education Center from 7:00 pm – 9:00 pm. The cost of this is $6 for an individual and $20 for a family of four (youth under 18 must be accompanied by an adult). We are excited to have Mike Hammer from KOFI Radio back again to DJ for the event and our three sponsors: Park Side Credit Union, Kalispell Public Schools, and Able Body. 2. Fire Department From January 12 to January 25 the Fire Department had 185 responses. Of these, there were 150 medical incidents, 6 Motor vehicle accidents, 6 Fire alarm activations, 3 public assists, 2 Vehicle Fires, 4 Haz-Mat (Gas leak, spills, carbon monoxide) calls, and 13 dispatched and canceled enroute. Total call volume for 2021 was 4,329 incidents as compared to the 2020 call volume of 2 3,931. New Firefighter-Paramedic academy for our 4 new recruits has begun. All 4 responders come from other fire agencies and instructors have noted their previous experience is evident. Fire crews and building officials have completed the annual school inspections for all Kalispell area schools. Members of Kalispell Fire Department have completed the 35-hour refresher course needed to recertify their advanced EMT and Paramedic certifications. 3.Information Services The City shop complex, North fire station, and WWTP received internet upgrades to improve speed and reliability. Network planning continues for the City staff-wide area network. IT staff added new body camera docking stations so more body cameras could charge and upload video content from a newly configured check-out station to the server. The station has a tablet that allows officers to go through a quicker body camera check-out process. GIS staff are updating maps for the large frames in the Council Chambers. The GIS dashboards are also being updated for the calendar year 2022, including the 2022 building permits issued. 4.Police Department Sgt. Chad Fetveit and Captain Ryan Bartholomew attended the Tactical Command Course in Great Falls, January 24-28. This Montana POST Credited 40-hour course combined classroom instruction with group exercises. Topics covered included; command leadership, critical thinking and decision-making, strategic planning for tactical teams, training considerations, commander’s responsibilities, current issues and documentation. Members of the Kalispell Special Response Team and the Kalispell Police Department BEAR played a key role in the safe apprehension of a fugitive in Mineral County on the morning of January 28, 2022. The fugitive had previously eluded and shot at peace officers in Washington and Idaho. Kalispell Police Officers will be participating in the Polar Plunge in Whitefish on February 5. The Polar Plunge is primarily organized, promoted and conducted by the Law Enforcement Torch Run to benefit Special Olympics Montana. Year to date calls for service stand at 3001, this compares with 2985 in 2021, and 3168 in 2020. 3 The Kalispell Police Detectives Division handled 601 felony cases in 2021, this compares with 466 in 2020, and 541 in 2019. 5. Public Works Yearly Production: Water and Wastewater The City records daily, monthly, and annual production and treatment quantities for water and wastewater flows. In 2021 the City produced 1,523 million gallons (MG) of water, with an average production per day of 4.1 MG and a max production day of 12.4 MG. On the flip side, 1,048 MG of wastewater was treated, with a daily average of 2.9 MG, with a max daily flow of 5.1 MG. As a comparison, below is a table with past annual production and treatment quantities. Yearly Water Production and Wastewater Treatment Summary Year Water Production (MG) Wastewater Treatment (MG) 2021 1,523 1,048 2020 1,430 1,005 2019 1,381 1,019 2018 1,482 1,042 2017 1,526 1,108 2016 1,356 1,013 2015 1,490 992 2014 1,230 1,043 2013 1,274 919 2012 1,263 935 2011 1,281 1,096 2010 1,242 957 2009 1,436 960 2008 1,367 1,011 2007 1,474 1,017 4 Annual Bio-Solids Report The City of Kalispell Wastewater Treatment Plant maintains and operates Bio-Solids Disposal under the regulatory oversight of United States Environmental Protection Agency (EPA). Staff annually reports the amounts of bio-solids generated at the Kalispell WWTP by completing and sending in a “Bio-Solids Report Form.” The report consists of reporting the tonnage production of bio-solids. In 2021, the WWTP process generated 731 dry tons of bio-solids, 528 dry tons were delivered to Glacier Gold LLC for composting, and 203 dry tons were delivered to the Flathead County Solid Waste Landfill. 6. Planning Department The Kalispell City Planning Board will hold a public hearing at their February 8 meeting and take public comments on the agenda items listed below: 1. Files # KPUD-21-05; KPP-21-08; KZC-21-04 – A request from GKM Associates, LLC, for a zone change and Planned Unit Development (“PUD”) overlay on approximately 90.87 acres located to the east of West Springcreek Road between Two Mile Drive and Three Mile Drive, as well as and preliminary plat for Phase 1 of the development. The property is currently zoned B-1 (Neighborhood Business – about 3.9 acres) and R-3 (Residential – about 87 acres) with a PUD overlay. The proposed zone change would change approximately 25.60 acres of the R-3 to RA-1 (Residential Apartment). It would also realign and expand the B-1 area to approximately 5.82 acres. The existing PUD overlay would be replaced with a new PUD over the entire property. The PUD would include 65 single-family dwellings, 113 townhome/rowhouse dwellings, and 464 multi-family dwelling units, along with 2 commercial lots, park area, and open space. The preliminary plat would cover approximately 40.52 acres in the southeastern portion of the property and include the 65 single-family lots and 95 of the townhome/rowhouse lots, as well as 6.2 acres of open space and 1.52 acres of parkland. 2. File #KPP-22-01 – A request from Silvermont Properties, LLLP, for preliminary plat approval for Silverbrook Estates Phase 3, a major subdivision containing 12 lots (10 residential and 2 commercial) on approximately 22.12 acres including the lots, roads, and open space. The property is located in the northeast portion of Silverbrook Estates. Documents pertaining to the agenda items are on file for public inspection at the Kalispell Planning Department, 201 First Avenue East, Kalispell, MT 59901, and are available for public review during regular office hours. In addition, information on the agenda items are posted on our website at https://mt-kalispell.civicplus.com/314/Planning-Board under planning board “upcoming agenda.” 5 7. Building Department The 2021 Construction, Subdivision and Annexation Report has been completed and can be found on the City’s website: NEW RESIDENTIALCONSTRUCTION (kalispell.com) In the last 3 weeks, we have issued permits for 6 single-family homes and 10 townhomes. That will bring the total of new single-family/duplex and townhouse units for the year to 18, compared to 13 last year at this time. There have been 24 multi-family housing units issued so far this year. Last year at this time we had not issued any multi-family housing units. There was a total of 200 combined building and/or fire inspections completed in the last 3 weeks. Residential – 83 Plumbing – 26 Commercial – 33 Mechanical - 25 Electrical – 24 Fire - 9 8. Community Development Community Development is working with the Kalispell Parking Advisory Board to develop parking solutions during the construction period of the Charles Hotel and public parking garage. 9. Finance Department First Half Finance Report Attached are the printouts reflecting the activity for the 1st half of fiscal year 2022. This printout reflects payroll through December 18, for biweekly employees. For fire and ambulance, this printout reflects payroll paid thru December 4. All claims submitted by the end of December should be included. Debt service funds are not included. REVENUES: General Fund tax revenue reflects taxes collected through December 31. Some first half taxes received by the County aren’t distributed to the City until the County completes the distribution in January. The City has not yet received the January distribution. Last year, the general fund received over $600,000 of first half taxes in January. A similar distribution this January would bring collections to about 57% of the fiscal year 2022 budgeted amount of $6,145,000. Protested taxes remain very low. Liquor licenses are billed once a year and are due by June 30. City Court fines and fees revenue reflect July thru November (5 months). 6 Parks tax revenues should be about 60% after the County’s January distribution. Charges for services revenues are up over $50,000 from the first half of fiscal year 21. Youth camps revenue, and many of the other user-based parks fees, historically receives more of their revenue in the 2nd half of the fiscal year (spring). The Ambulance Fund 1st half fees for services are 37% of the annual budget or $260,111. This is a slight decrease when compared to the 1st half of fiscal year 2021. First half Building Department revenues of $1,119,127 are 104% of the annual budget. First half fiscal year 2021 revenues were $593,000. Metered water sales are at 69%. First half water sales are usually more than 50% due to summer and early fall sprinkling and irrigation. Sewer service charges are at 53%, about the same as last fiscal year. Water, sewer, treatment, and storm impact fees remain strong in the first half. Sewer (collection and treatment plant) are both over the fiscal year 2022 budgeted amount. Police and fire impact fees revenues have also exceeded the annual budget. EXPENDITURES/EXPENSES: At this point in the year, the salary and retirement amounts remaining should be at least 53% in most funds (14 of 26 pay periods remaining). Some seasonal parks and rec salaries would be an exception. Fire and ambulance should have about 58% remaining in salaries and retirement (7.5 of 13 pay periods remaining). Health insurance reflects 5 months paid and should have around 58% remaining. With a few exceptions, administrative, central garage, and information technology transfers are done monthly and should show 50% remaining. This is the same on the revenue side for fees for services (Central Garage/Information Technology) and administrative charges (General Fund). The general fund administrative charges may vary slightly as some charges are based on a percentage of revenues collected. Annual budgeted operating transfers are generally done quarterly, depending on cash availability, and should show 50% remaining. The City prepays its annual liability ($420,812) and property insurance ($158,082) in August. This can result in general government expenditures and some other funds’ expenses reflecting greater than 50% spent in the 1st half of the fiscal year. THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 1 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 2,877,316 6,145,000 3,267,684 53% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 0 17,750 17,750 100% 1000-000-311200-000 PERSONAL PROPERTY TAXES 151,509 170,000 18,491 11% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 6,033 10,000 3,967 40% 1000-000-322101-000 LIQUOR LICENSES 1,763 33,000 31,238 95% 1000-000-322300-000 BUSINESS LICENSES 239 1,500 1,261 84% 1000-000-323012-000 PLANNING FEES 92,555 95,000 2,445 3% 1000-000-323109-000 SITE REVIEW 11,916 30,000 18,084 60% 1000-000-323200-000 PARADE PERMITS 300 500 200 40% 1000-000-331023-000 MRVCTF 440 0 440- 0% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 1,350 1,350 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 54,400 60,000 5,600 9% 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,650 1,400 250- -18% 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 1,504,030 3,020,000 1,515,970 50% 1000-000-341020-000 ADMINISTRATIVE CHARGES 344,135 690,000 345,865 50% 1000-000-341021-000 GRANT ADMIN FEES 30,982 25,000 5,982- -24% 1000-000-341025-000 CITY COLLECTIONS 8,814 5,000 3,814- -76% 1000-000-342010-000 POLICE SERVICES 21,188 29,000 7,812 27% 1000-000-342014-000 RESOURCE OFFICERS 230,045 224,435 5,610- -3% 1000-000-342016-000 KPD REGIONAL TRAINING 2,539 14,500 11,961 82% 1000-000-343018-000 PARKING PERMITS 51,403 90,000 38,597 43% 1000-000-343062-000 AIRPORT FUEL TAXES 2,533 4,000 1,467 37% 1000-000-343063-000 AIRPORT GROUND LEASE (HILTON) 13,259 15,301 2,042 13% 1000-000-351000-000 CITY COURT FINES & FEES 154,598 450,000 295,402 66% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 9,309 30,000 20,691 69% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 19,388 45,000 25,613 57% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 571 20,000 19,429 97% 1000-000-362020-000 MMIA LIABILITY RETRO 40,436 30,000 10,436- -35% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 750 10,000 9,250 93% 1000-000-371010-000 INVESTMENT EARNINGS 19,808 30,000 10,192 34% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 550,000 1,100,000 550,000 50% ------------------------------------------------- TOTAL GENERAL FUND REVENUE 6,201,908 12,397,736 6,195,828 50% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 2 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 2,500 3,030 530 17% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 12,425 13,750 1,325 10% 1000-400-410530-354 GASB 75 ACTUARIAL VALUATION 7,500 10,000 2,500 25% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 812 4,000 3,188 80% 1000-400-410560-312 POSTAGE 7,845 16,000 8,155 51% 1000-400-410560-320 PRINTING & ENVELOPES 1,271 5,500 4,229 77% 1000-400-410560-354 CONTRACT SERVICES - DOC. SHRED / 10 55 1,500 1,445 96% 1000-400-410600-354 ELECTIONS 0 20,000 20,000 100% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 1,895 4,500 2,605 58% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 269 350 81 23% 1000-400-430300-355 AIRPORT REIMBURSEMENT 18,065 20,000 1,935 10% 1000-400-460000-820 TFR TO WESTSIDE TIF 450,000 900,000 450,000 50% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 15,000 15,000 0 0% 1000-400-460452-366 HOCKADAY MAINTENANCE 6,600 6,600 0 0% 1000-400-510300-000 CONTINGENCY 0 210,000 210,000 100% 1000-400-510310-354 ICMA PLAN FEES 250 500 250 50% 1000-400-510330-513 LIABILITY INSURANCE 287,407 287,406 1- 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 10,124 50,000 39,876 80% 1000-400-510330-517 PROPERTY INSURANCE 60,043 60,043 0 0% ------------------------------------------------- SUBTOTAL GEN.GOV'T. 882,060 1,628,179 746,119 46% CITY MANAGER 1000-401-410210-110 SALARIES-CITY MANAGER'S OFFICE 72,925 171,133 98,208 57% 1000-401-410210-153 HEALTH INSURANCE 10,388 25,759 15,371 60% 1000-401-410210-155 RETIREMENT 7,859 18,227 10,368 57% 1000-401-410210-210 SUPPLIES 0 1,000 1,000 100% 1000-401-410210-312 NEWSLETTER/BOOKS 0 400 400 100% 1000-401-410210-345 TELEPHONE & COMMUNICATION 480 1,200 720 60% 1000-401-410210-373 DUES & TRAINING 1,906 12,000 10,094 84% 1000-401-410210-379 MEETINGS 408 6,500 6,092 94% ------------------------------------------------- SUBTOTAL CITY MANAGER 93,966 236,219 142,253 60% HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 64,879 173,487 108,608 63% 1000-401-410830-153 HEALTH INSURANCE 9,635 24,323 14,688 60% 1000-401-410830-155 RETIREMENT 5,224 14,032 8,808 63% 1000-401-410830-210 OFFICE SUPPLIES 370 900 530 59% 1000-401-410830-338 RECRUITMENT/RELOCATION 10,516 20,000 9,484 47% 1000-401-410830-354 CONTRACT SERVICES 875 2,000 1,125 56% 1000-401-410830-373 DUES & TRAINING 8,325 17,000 8,675 51% ------------------------------------------------- SUBTOTAL HUMAN RESOURCES 99,824 251,742 151,918 60% THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 3 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 29,576 63,179 33,603 53% 1000-402-410100-153 HEALTH INSURANCE 21,158 50,123 28,965 58% 1000-402-410100-155 RETIREMENT 1,241 2,617 1,376 53% 1000-402-410100-210 OFFICE SUPPLIES 0 6,500 6,500 100% 1000-402-410100-335 MT LEAGUE OF CITIES 198 7,100 6,902 97% 1000-402-410100-354 CONTRACT SERVICES 849 5,500 4,651 85% 1000-402-410100-373 DUES & TRAINING 9,372 11,500 2,128 19% 1000-402-410100-379 MEETINGS 3,867 22,255 18,388 83% ------------------------------------------------- SUBTOTAL MAYOR/COUNCIL 66,261 168,774 102,513 61% CITY CLERK 1000-402-410150-110 SALARIES-CITY CLERK 52,110 114,510 62,400 54% 1000-402-410150-121 OVERTIME 0 250 250 100% 1000-402-410150-153 HEALTH INSURANCE 7,179 21,768 14,589 67% 1000-402-410150-155 RETIREMENT 4,274 9,323 5,049 54% 1000-402-410150-210 OFFICE SUPPLIES 253 800 547 68% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 80 600 520 87% 1000-402-410150-345 TELEPHONE & COMMUNICATION 240 480 240 50% 1000-402-410150-352 CODIFICATION 1,925 4,100 2,175 53% 1000-402-410150-354 CONTRACT SERVICES 78 650 572 88% 1000-402-410150-373 DUES & TRAINING 1,363 6,200 4,837 78% ------------------------------------------------- SUBTOTAL CITY CLERK 67,501 158,681 91,180 57% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES-FINANCE OFFICE 111,937 247,730 135,793 55% 1000-403-410550-121 OVERTIME 0 500 500 100% 1000-403-410550-153 HEALTH INSURANCE 15,892 40,712 24,820 61% 1000-403-410550-155 RETIREMENT 9,281 20,116 10,835 54% 1000-403-410550-210 SUPPLIES 197 800 603 75% 1000-403-410550-322 BOOKS 0 500 500 100% 1000-403-410550-353 CONTRACT SERVICES 0 350 350 100% 1000-403-410550-354 CONTRACT-GRIZZLY SECURITY 883 900 17 2% 1000-403-410550-355 BANK CHARGES & FEES 1,570 3,500 1,930 55% 1000-403-410550-373 DUES & TRAINING 530 8,500 7,970 94% ------------------------------------------------- SUBTOTAL FINANCE 140,289 323,608 183,319 57% THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 4 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CITY ATTORNEY 1000-404-411110-110 SALARIES-CITY ATTORNEY'S 250,951 551,082 300,131 54% 1000-404-411110-112 SALARIES - RETIREMENT 0 130,000 130,000 100% 1000-404-411110-153 HEALTH INSURANCE 36,151 85,995 49,844 58% 1000-404-411110-155 RETIREMENT 20,606 44,825 24,219 54% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 4,241 5,700 1,459 26% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 11,975 25,000 13,025 52% 1000-404-411110-345 TELEPHONE & COMMUNICATION 482 1,500 1,018 68% 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 841 10,000 9,159 92% 1000-404-411110-373 DUES & TRAINING 2,926 8,000 5,074 63% ------------------------------------------------- SUBTOTAL CITY ATTORNEY 328,171 862,102 533,931 62% MUNICIPAL COURT 1000-406-410360-110 SALARIES-COURT 119,714 264,684 144,970 55% 1000-406-410360-121 OVERTIME 0 3,500 3,500 100% 1000-406-410360-153 HEALTH INSURANCE 19,237 47,298 28,061 59% 1000-406-410360-155 RETIREMENT 9,759 21,480 11,721 55% 1000-406-410360-210 SUPPLIES 181 4,500 4,319 96% 1000-406-410360-320 PRINTING/BOOKS 1,559 1,500 59- -4% 1000-406-410360-345 TELEPHONE & COMMUNICATION 253 1,000 747 75% 1000-406-410360-353 SECURITY & TECHNOLOGY 9,767 40,000 30,233 76% 1000-406-410360-354 CONTRACT SERVICES 1,410 6,250 4,840 77% 1000-406-410360-373 DUES & TRAINING 1,713 10,000 8,287 83% 1000-406-410360-394 JURY & WITNESS FEES 1,490 7,500 6,010 80% ------------------------------------------------- SUBTOTAL COURT 165,083 407,712 242,629 60% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES-PUBLIC WORKS 8,551 19,158 10,607 55% 1000-410-430100-153 HEALTH INSURANCE 1,410 3,302 1,892 57% 1000-410-430100-155 RETIREMENT 744 1,500 756 50% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 10,177 14,500 4,323 30% 1000-410-430100-231 GAS 1,787 3,000 1,213 40% 1000-410-430100-345 TELEPHONE & COMMUNICATION 441 850 409 48% 1000-410-430100-354 CONTRACT SERVICES 3,222 4,500 1,278 28% 1000-410-430100-373 DUES & TRAINING 820 4,500 3,680 82% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 2,328 4,656 2,328 50% 1000-410-430100-940 MACINERY & EQUIPMENT 9,473 9,500 27 0% ------------------------------------------------- SUBTOTAL PUBLIC WORKS ADMIN 38,953 65,466 26,513 41% CITY HALL MAINT. 1000-412-411230-110 SALARIES-CITY HALL 35,254 72,664 37,410 51% 1000-412-411230-153 HEALTH INSURANCE 7,032 15,100 8,068 53% 1000-412-411230-155 RETIREMENT 2,867 5,849 2,982 51% 1000-412-411230-220 SECURITY IMPROVEMENTS 793 6,793 6,000 88% 1000-412-411230-224 JANITORIAL SUPPLIES 3,427 6,800 3,373 50% 1000-412-411230-241 TOOLS & SUPPLIES 288 1,500 1,212 81% 1000-412-411230-341 ELECTRICITY 22,189 49,394 27,205 55% 1000-412-411230-344 NATURAL GAS 14,609 34,000 19,391 57% THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 5 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-345 TELEPHONE & COMMUNICATION 224 500 276 55% 1000-412-411230-354 CONTRACT SERVICES 4,820 15,000 10,180 68% 1000-412-411230-355 HVAC MAINTENANCE CONTRACT 18,076 17,730 346- -2% 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 540 7,000 6,460 92% 1000-412-411230-362 EQUIPMENT MAINTENANCE 2,056 10,000 7,944 79% 1000-412-411230-366 BUILDING MAINTENANCE 8,835 17,288 8,453 49% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,113 3,780 667 18% 1000-412-411230-920 BUILDING IMPROVEMENTS 0 30,058 30,058 100% ------------------------------------------------- SUBTOTAL CITY HALL 124,123 293,456 169,333 58% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES-PLANNING & ZONING 113,211 246,016 132,805 54% 1000-420-411020-153 HEALTH INSURANCE 15,520 46,047 30,527 66% 1000-420-411020-155 RETIREMENT 9,270 20,021 10,751 54% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 384 4,000 3,616 90% 1000-420-411020-231 GAS 153 450 297 66% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 968 2,500 1,532 61% 1000-420-411020-345 TELEPHONE 256 1,000 744 74% 1000-420-411020-354 CONTRACT SERVICES 25 6,000 5,975 100% 1000-420-411020-373 DUES & TRAINING 1,688 8,000 6,312 79% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 69 139 70 50% ------------------------------------------------- SUBTOTAL PLANNING DEPT. 141,543 334,173 192,630 58% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 36,901 81,675 44,774 55% 1000-480-470210-153 HEALTH INSURANCE 6,922 16,790 9,868 59% 1000-480-470210-155 RETIREMENT 3,032 6,610 3,578 54% 1000-480-470210-210 OFFICE SUPPLIES 84 1,600 1,516 95% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 0 500 500 100% 1000-480-470210-312 POSTAGE & PRINTING 32 300 268 89% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 0 500 500 100% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 148 450 302 67% 1000-480-470210-354 CONTRACT SERVICES 0 250 250 100% 1000-480-470210-373 DUES & TRAINING 3,003 5,000 1,997 40% 1000-480-470210-379 MEETINGS 65 750 685 91% ------------------------------------------------- SUBTOTAL COMMUNITY DEVELOPMENT 50,187 114,425 64,238 56% THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 6 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES-POLICE 1,201,609 2,669,727 1,468,118 55% 1000-413-420140-112 SALARIES-SEVERANCE 40,953 50,000 9,047 18% 1000-413-420140-114 SALARY -comptime buyout 5,287 4,000 1,287- -32% 1000-413-420140-121 OVERTIME (REG & AET OT) 28,063 80,000 51,937 65% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 10,600 35,000 24,400 70% 1000-413-420140-153 HEALTH INSURANCE 205,559 497,110 291,551 59% 1000-413-420140-155 RETIREMENT 152,953 349,720 196,767 56% 1000-413-420140-210 OFFICE SUPPLIES 1,756 3,500 1,744 50% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 1,753 5,000 3,247 65% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 56,467 70,000 13,533 19% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 890 4,000 3,110 78% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 1,928 13,500 11,572 86% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 215 2,700 2,485 92% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 8 11,900 11,892 100% 1000-413-420140-227 AMMO & RELATED SUPPLIES 20,373 65,000 44,627 69% 1000-413-420140-228 PATROL CAR SUPPLIES 1,120 8,000 6,880 86% 1000-413-420140-229 OTHER SUPPLIES 2,965 5,000 2,035 41% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 391 1,000 609 61% 1000-413-420140-231 GAS 37,860 75,000 37,140 50% 1000-413-420140-234 CRISIS NEGOTIATIONS 0 500 500 100% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 243 1,500 1,257 84% 1000-413-420140-320 PRINTING 1,075 4,000 2,925 73% 1000-413-420140-345 TELEPHONE & COMMUNICATION 11,625 22,000 10,375 47% 1000-413-420140-354 CONTRACT SERVICES 11,815 30,000 18,185 61% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 2,054 6,500 4,446 68% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 1,124 2,600 1,476 57% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 1,179 2,000 821 41% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 41,807 57,000 15,193 27% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 1,946 5,000 3,054 61% 1000-413-420140-373 DUES & TRAINING 33,692 55,000 21,308 39% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 3,070 14,500 11,430 79% 1000-413-420140-380 TRAINING MATERIALS 4,000 5,000 1,000 20% 1000-413-420140-388 MEDICAL SERVICES 1,449 3,000 1,551 52% 1000-413-420140-392 BOARDING/TREATING PRISONERS 1,246 2,500 1,255 50% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 47,429 94,858 47,429 50% 1000-413-420140-530 RENT 3,800 7,200 3,400 47% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 32,000 64,000 32,000 50% 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 0 100,000 100,000 100% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 3,000 6,000 3,000 50% 1000-413-420140-944 VEHICLES 28,776 159,000 130,224 82% ------------------------------------------------- SUBTOTAL POLICE DEPT. 2,002,080 4,592,315 2,590,235 56% DETECTIVES 1000-413-420141-110 SALARIES-DETECTIVES 183,403 413,768 230,365 56% 1000-413-420141-121 DETECTIVE-OVERTIME 5,484 15,000 9,516 63% 1000-413-420141-123 OVERTIME (SAFE NEIGHBORHOOD TASK FO 0 8,000 8,000 100% 1000-413-420141-153 HEALTH INSURANCE 33,800 87,900 54,100 62% 1000-413-420141-155 DETECTIVE-RETIREMENT 24,701 55,446 30,745 55% ------------------------------------------------- TOTAL DETECTIVES 247,388 580,114 332,726 57% RECORDS THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 7 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-110 SALARIES-RECORDS DIVISION 70,013 161,768 91,755 57% 1000-413-420142-121 OVERTIME 2,931 6,000 3,069 51% 1000-413-420142-153 HEALTH INSURANCE 14,375 38,000 23,625 62% 1000-413-420142-155 RETIREMENT 5,976 13,094 7,118 54% ------------------------------------------------- TOTAL RECORDS 93,294 218,862 125,568 57% RESOURCE OFFICERS 1000-413-420144-110 SALARIES-SRO 133,662 291,805 158,143 54% 1000-413-420144-153 HEALTH INSURANCE 24,677 61,304 36,627 60% 1000-413-420144-155 SRO RETIREMENT 17,822 39,188 21,366 55% ------------------------------------------------- TOTAL RESOURCE OFFICERS 176,161 392,297 216,136 55% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL-SALARIES 22,098 52,723 30,625 58% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 3,775 9,500 5,725 60% 1000-413-420145-155 RETIREMENT 1,847 4,109 2,262 55% ------------------------------------------------- SUBTOTAL ANIMAL CONTROL 27,720 66,832 39,112 59% PARKING 1000-413-420147-110 PARKINGS -SALARIES 41,762 96,050 54,288 57% 1000-413-420147-153 HEALTH INSURANCE 13,844 32,921 19,077 58% 1000-413-420147-155 RETIREMENT 3,542 7,695 4,153 54% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 936 4,000 3,064 77% 1000-413-420147-354 CONTRACTED SERVICES 169 2,000 1,831 92% 1000-413-420147-362 LOT MAINT 474 10,000 9,526 95% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 0 17,500 17,500 100% 1000-413-420147-550 LOT LEASE PAYMENTS 543 1,500 957 64% ------------------------------------------------- SUBTOTAL PARKING 61,270 171,666 110,396 64% ------------------------------------------------- SUBTOTAL POLICE DEPT. 2,607,914 6,022,086 3,414,172 57% THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 8 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES-FIRE SUPPRESSION 830,624 2,195,634 1,365,010 62% 1000-416-420400-112 SALARY-SEVERANCE 5,874 0 5,874- 0% 1000-416-420400-113 KELLY DAYS 80 0 80- 0% 1000-416-420400-114 COMPTIME BUYOUT 2,605 5,500 2,895 53% 1000-416-420400-115 OUT OF RANK PAY 6,072 12,500 6,428 51% 1000-416-420400-121 OVERTIME 75,332 40,000 35,332- -88% 1000-416-420400-153 HEALTH INSURANCE 172,429 440,413 267,984 61% 1000-416-420400-155 RETIREMENT 110,830 290,559 179,729 62% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 2,173 4,710 2,538 54% 1000-416-420400-218 Equipment (Non Capital) 6,352 21,500 15,148 70% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 15,724 15,000 724- -5% 1000-416-420400-224 JANITORIAL SUPPLIES 2,392 5,150 2,758 54% 1000-416-420400-231 GAS 8,436 17,325 8,889 51% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 5,812 15,750 9,938 63% 1000-416-420400-320 PRINTING 190 200 10 5% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 442 1,250 808 65% 1000-416-420400-345 TELEPHONE & COMMUNICATION 1,615 5,000 3,385 68% 1000-416-420400-354 CONTRACT SERVICES 17,397 17,460 63 0% 1000-416-420400-362 EQUIPMENT MAINTENANCE 3,850 5,500 1,650 30% 1000-416-420400-366 BUILDING MAINTENANCE-STATION 62 3,802 7,500 3,698 49% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 967 5,000 4,033 81% 1000-416-420400-373 DUES & TRAINING 8,865 10,000 1,135 11% 1000-416-420400-388 FIREFIGHTER PHYSICALS 2,530 30,800 28,270 92% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 14,530 29,061 14,531 50% 1000-416-420400-610 DEBT RETIREMENT-FIRE TRUCK 22,698 45,636 22,938 50% 1000-416-420400-620 INTEREST EXPENSE-FIRE TRUCK 2,836 5,720 2,884 50% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 125,000 250,000 125,000 50% 1000-416-420400-821 TFR - 2956 AFG ($5,300) 0 5,300 5,300 100% 1000-416-420400-940 CAPITAL EQUIPMENT-VEHICLE/SCBA/SERV 0 347,500 347,500 100% 1000-416-420440-110 SALARIES-FIRE PREVENTION 10,802 26,242 15,440 59% 1000-416-420440-121 OVERTIME 779 0 779- 0% 1000-416-420440-153 HEALTH INSURANCE 2,373 6,101 3,728 61% 1000-416-420440-155 RETIREMENT 938 2,027 1,089 54% ------------------------------------------------- SUBTOTAL FIRE DEPT. 1,464,348 3,864,338 2,399,990 62% ------------------------------------------------- GRAND TOTAL GENERAL FUND 6,270,226 14,730,961 8,460,735 57% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 9 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SPECIAL REVENUE FUNDS: 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 544,982 1,147,000 602,018 52% 2215-000-311200-000 PERSONAL PROPERTY TAXES 24,958 24,675 283- -1% 2215-000-312000-000 PEN & INTEREST DEL TAXES 983 1,500 517 34% 2215-000-334000-000 GRANT - POOL IMPROVEMENTS 0 86,000 86,000 100% 2215-000-346030-000 SWIMMING POOL FEES 78,133 155,000 76,867 50% 2215-000-346040-000 CONCESSION STAND REVENUE 33,308 42,000 8,692 21% 2215-000-346050-000 PARKS USAGE FEES 6,551 20,000 13,449 67% 2215-000-346051-000 RECREATION FEES 12,624 39,010 26,386 68% 2215-000-346052-000 SPORTS PROGRAMS 47,040 81,728 34,688 42% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 1,617 2,700 1,084 40% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 39,431 67,554 28,123 42% 2215-000-346055-000 ICE RINK 409 22,000 21,591 98% 2215-000-346056-000 KIDSPORT USAGE 546 3,000 2,454 82% 2215-000-346057-000 YOUTH CAMPS 10,786 192,244 181,458 94% 2215-000-346059-000 PICNIC IN THE PARK 2,973 26,500 23,527 89% 2215-000-362015-000 INSURANCE REIMBURSEMENTS 1,565 0 1,565- 0% 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 1,131 0 1,131- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-371010-000 INVESTMENTS 1,597 5,000 3,403 68% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 55,500 111,000 55,500 50% ------------------------------------------------- TOTAL PARKS & REC REVENUE 864,134 2,046,911 1,182,777 58% ================================================= PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES-PARKS 172,180 380,186 208,006 55% 2215-436-460430-111 SEASONAL SALARIES 30,291 89,519 59,228 66% 2215-436-460430-121 OVERTIME 0 300 300 100% 2215-436-460430-153 HEALTH INSURANCE 26,814 65,846 39,032 59% 2215-436-460430-155 RETIREMENT 16,909 34,562 17,653 51% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 397 2,000 1,604 80% 2215-436-460430-215 EQUIPMENT - not capital 0 3,000 3,000 100% 2215-436-460430-224 JANITORIAL SUPPLIES 2,695 7,000 4,305 62% 2215-436-460430-229 OTHER SUPPLIES 3,160 10,000 6,840 68% 2215-436-460430-231 GAS 10,925 17,000 6,075 36% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 808 3,000 2,192 73% 2215-436-460430-320 PRINTING & ADVERTISING 178 200 22 11% 2215-436-460430-341 ELECTRICITY 5,742 13,000 7,258 56% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 9,178 22,000 12,822 58% 2215-436-460430-344 NATURAL GAS 772 2,030 1,258 62% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 912 2,500 1,588 64% 2215-436-460430-351 SPORTS COURT & SPORT MAINTENANCE 0 2,000 2,000 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 2,000 2,000 100% 2215-436-460430-355 CONTRACT SERV. TRAIL MAINT/WEED CON 954 18,000 17,046 95% 2215-436-460430-356 CONSULTANTS - PRELIMINARY DESIGN HW 0 40,000 40,000 100% 2215-436-460430-357 CONSULTANTS - LAWRANCE PARK TRAIL 372 12,000 11,628 97% 2215-436-460430-358 FVCC TENNIS INTERLOCAL AGREEMENT 0 7,000 7,000 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 4,896 8,000 3,104 39% THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 10 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-364 LANDSCAPING 0 5,450 5,450 100% 2215-436-460430-367 VANDALISM REPAIRS 1,596 4,000 2,404 60% 2215-436-460430-373 DUES & TRAINING 4,561 8,000 3,439 43% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 55 500 445 89% 2215-436-460430-395 EQUIPMENT RENTAL 500 500 0 0% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 299 6,500 6,201 95% 2215-436-460430-440 IRRIGATION SUPPLIES 1,652 7,000 5,348 76% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 378 2,000 1,622 81% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 16,482 32,965 16,483 50% 2215-436-460430-545 COUNTY LANDFILL 4,042 6,273 2,231 36% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 30,056 60,234 30,178 50% 2215-436-460430-620 DEBT SERVICE INTEREST 1,020 2,056 1,036 50% ------------------------------------------------- SUBTOTAL PARKS EXPENDITURES 347,822 876,621 528,799 60% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES-COMPLEX 45,354 121,391 76,037 63% 2215-436-460440-111 SEASONAL SALARIES 19,781 45,190 25,409 56% 2215-436-460440-121 OVERTIME 0 300 300 100% 2215-436-460440-153 HEALTH INSURANCE 10,186 32,672 22,486 69% 2215-436-460440-155 RETIREMENT 5,263 11,483 6,220 54% 2215-436-460440-221 SAFETY EQUIPMENT 0 300 300 100% 2215-436-460440-229 OTHER SUPPLIES 2,931 22,000 19,069 87% 2215-436-460440-231 GAS 5,236 8,240 3,004 36% 2215-436-460440-241 CONSUMABLE TOOLS 230 780 550 70% 2215-436-460440-341 ELECTRICITY 5,586 11,656 6,070 52% 2215-436-460440-345 TELEPHONE & COMMUNICATION 116 251 135 54% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 276 500 224 45% 2215-436-460440-364 LANDSCAPING 0 300 300 100% 2215-436-460440-367 VANDALISM REPAIRS 0 500 500 100% 2215-436-460440-373 DUES & TRAINING 525 700 175 25% 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 165 200 35 18% 2215-436-460440-395 RENTAL EQUIPMENT 0 200 200 100% 2215-436-460440-420 METAL PRODUCTS 246 6,000 5,754 96% 2215-436-460440-440 IRRIGATION 2,262 7,000 4,738 68% 2215-436-460440-452 SAND & GRAVEL 245 1,500 1,255 84% 2215-436-460440-521 CENTRAL GARAGE TRANSFER 4,070 8,139 4,069 50% 2215-436-460440-545 COUNTY LANDFILL 3,470 3,500 30 1% 2215-436-460440-940 EQUIPMENT - (RIDING PAINT STRIPER) 0 15,000 15,000 100% ------------------------------------------------- SUBTOTAL ATHLETIC COMPLEX 105,942 298,802 192,860 65% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES-RECREATION 40,069 98,805 58,736 59% 2215-436-460431-111 SEASONAL SALARIES 6,441 22,490 16,049 71% 2215-436-460431-153 HEALTH INSURANCE 6,424 21,999 15,575 71% 2215-436-460431-155 RETIREMENT 3,281 9,674 6,393 66% 2215-436-460431-229 MISC. SUPPLIES 4,631 13,560 8,929 66% 2215-436-460431-231 GAS 139 575 436 76% 2215-436-460431-320 PRINTING & ADVERTISING 0 7,900 7,900 100% 2215-436-460431-345 TELEPHONE & COMMUNICATION 440 1,126 686 61% 2215-436-460431-354 CONTRACT SERVICES 29,844 40,462 10,618 26% 2215-436-460431-357 MUSIC FRANCHISE FEES 903 1,400 497 36% THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 11 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460431-373 DUES & TRAINING 454 1,000 546 55% ------------------------------------------------- SUBTOTAL RECREATION 92,626 218,991 126,365 58% YOUTH CAMPS 2215-436-460448-110 SALARIES-YOUTH CAMPS 35,021 87,665 52,644 60% 2215-436-460448-111 SEASONAL SALARIES 81,624 153,655 72,031 47% 2215-436-460448-121 OVERTIME 221 150 71- -47% 2215-436-460448-153 HEALTH INSURANCE 6,047 18,708 12,661 68% 2215-436-460448-155 RETIREMENT 2,841 8,022 5,181 65% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 278 250 28- -11% 2215-436-460448-229 MISC. SUPPLIES 3,262 3,665 403 11% 2215-436-460448-231 GAS 0 400 400 100% 2215-436-460448-320 PRINTING & ADVERTISING 0 380 380 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 564 1,246 682 55% 2215-436-460448-354 CONTRACT SERVICES 8,471 20,985 12,514 60% 2215-436-460448-355 AFTER SCHOOL PROGRAM 30 1,200 1,170 98% 2215-436-460448-356 BANK FEES/CC CHARGES 1,627 4,700 3,073 65% 2215-436-460448-373 DUES & TRAINING 479 1,000 521 52% ------------------------------------------------- SUBTOTAL YOUTH CAMPS 140,465 302,026 161,561 53% PARKLINE TRAIL MAINTENANCE 2215-436-460457-110 SALARIES - PARK LINE TRAIL 0 45,812 45,812 100% 2215-436-460457-111 SALARIES - SEASONAL 0 17,220 17,220 100% 2215-436-460457-121 OVERTIME 0 300 300 100% 2215-436-460457-153 HEALTH INSURANCE 0 18,798 18,798 100% 2215-436-460457-155 RETIREMENT 0 2,808 2,808 100% 2215-436-460457-210 OFFICE SUPPLIES, EQUIP./COMPUTERS 0 300 300 100% 2215-436-460457-215 EQUIPMENT - NOT CAPITAL 0 1,300 1,300 100% 2215-436-460457-224 JANITORIAL SUPPLIES 0 2,200 2,200 100% 2215-436-460457-229 OTHER SUPPLIES (FERTILIZER, WEED SP 0 3,500 3,500 100% 2215-436-460457-231 GAS 0 4,000 4,000 100% 2215-436-460457-241 TOOLS/ SMALL EQUIP./ SAFETY EQUIP. 0 700 700 100% 2215-436-460457-341 ELECTRICITY 0 4,000 4,000 100% 2215-436-460457-345 TELEPHONE & COMMUNICATIONS 0 600 600 100% 2215-436-460457-355 CONTRACT SERVICES - TRAIL MAINT./WE 0 6,000 6,000 100% 2215-436-460457-362 EQUIPMENT / AMENITY MAINTENANCE 0 1,500 1,500 100% 2215-436-460457-364 LANDSCAPE MATERIALS 0 100 100 100% 2215-436-460457-367 VANDALISM REPAIRS 0 1,200 1,200 100% 2215-436-460457-373 DUES & TRAINING 0 600 600 100% 2215-436-460457-388 MEDICAL SERVICES: DRUG TESTING 0 100 100 100% 2215-436-460457-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460457-440 IRRIGATION SUPPLIES 0 1,200 1,200 100% 2215-436-460457-452 TOP SOIL, DECROATIVE MINERLA MULCH 0 750 750 100% 2215-436-460457-545 COUNTY LANDFILL 0 3,500 3,500 100% 2215-436-460457-941 EQUIPMENT - TOOLCAT (FY22) 0 80,000 80,000 100% ------------------------------------------------- SUBTOTAL PARKLINE TRAIL MAINTE 0 196,988 196,988 100% POOL 2215-437-460445-111 SEASONAL SALARIES-POOL 131,725 197,345 65,620 33% 2215-437-460445-121 OVERTIME 1,845 200 1,645- -822% 2215-437-460445-155 RETIREMENT 597 1,500 903 60% THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 12 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 181 500 319 64% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 2,345 2,000 345- -17% 2215-437-460445-226 CHLORINE/CHEMICALS 27,186 40,000 12,814 32% 2215-437-460445-228 CONCESSION STAND SUPPLIES 16,881 21,000 4,119 20% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 515 4,000 3,485 87% 2215-437-460445-341 ELECTRICITY 5,378 9,500 4,122 43% 2215-437-460445-344 NATURAL GAS 11,048 25,000 13,952 56% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,023 2,500 1,477 59% 2215-437-460445-354 LICENSES & FEES 683 1,400 717 51% 2215-437-460445-356 BANK FEES/ CC CHARGES 2,903 2,300 603- -26% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 4,637 13,000 8,363 64% 2215-437-460445-367 VANDALISM 0 1,000 1,000 100% 2215-437-460445-380 TRAINING MATERIALS 560 1,800 1,240 69% 2215-437-460445-932 EQUIPMENT / POOL IMPROVEMENTS 0 172,000 172,000 100% ------------------------------------------------- SUBTOTAL POOL EXPENDITURES 207,507 495,045 287,538 58% ------------------------------------------------- TOTAL PARKS & RECREATION/POOL 894,361 2,388,473 1,494,112 63% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 13 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING URBAN FORESTRY 2600-436-460433-110 SALARIES-URBAN FORESTRY 95,951 214,844 118,893 55% 2600-436-460433-111 SEASONAL SERVICES 6,948 49,185 42,237 86% 2600-436-460433-121 OVERTIME 0 1,000 1,000 100% 2600-436-460433-153 HEALTH INSURANCE 18,316 46,165 27,849 60% 2600-436-460433-155 RETIREMENT 8,270 21,094 12,824 61% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 3,494 3,500 6 0% 2600-436-460433-231 GAS 3,235 5,900 2,665 45% 2600-436-460433-241 CONSUMABLE TOOLS 624 5,200 4,576 88% 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 311 662 351 53% 2600-436-460433-354 CONTRACT SERVICES 67,420 170,000 102,580 60% 2600-436-460433-357 FORESTRY GRANT 1,000 4,138 3,138 76% 2600-436-460433-358 EAB MONITORING/ARBOR DAY 0 4,750 4,750 100% 2600-436-460433-362 EQUIPMENT MAINTENANCE 370 4,000 3,630 91% 2600-436-460433-364 LANDSCAPING & TREES 3,695 8,000 4,305 54% 2600-436-460433-373 DUES & TRAINING 1,377 5,000 3,623 72% 2600-436-460433-388 MEDICAL 165- 300 465 155% 2600-436-460433-395 EQUIPMENT RENTAL 2,091 7,200 5,109 71% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 6,609 6,609 0- -0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 6,386 12,771 6,385 50% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 10,212 20,424 10,212 50% 2600-436-460433-528 INFORMATION TECHNOLOGY TRANSFER 5,468 10,937 5,469 50% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 5,157 10,374 5,217 50% 2600-436-460433-620 INTEREST EXPENSE 85 171 86 50% ------------------------------------------------- TOTAL URBAN FORESTRY 246,855 612,224 365,369 60% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 14 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 260,111 700,000 439,889 63% 2230-000-342070-000 COUNTY EMS LEVY 0 140,000 140,000 100% 2230-000-365000-000 DONATIONS/SALE OF EQUIP/MISC 1,206 0 1,206- 0% 2230-000-371010-000 INTEREST EARNINGS 44 0 44- 0% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 125,000 250,000 125,000 50% ------------------------------------------------- TOTAL AMBULANCE REVENUE 386,361 1,090,000 703,639 65% ================================================= AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 277,085 675,510 398,425 59% 2230-440-420730-114 COMPTIME BUYBACK 0 3,500 3,500 100% 2230-440-420730-115 OUT OF RANK PAY 0 3,300 3,300 100% 2230-440-420730-121 OVERTIME 14,225 30,000 15,775 53% 2230-440-420730-153 HEALTH INSURANCE 46,302 118,649 72,347 61% 2230-440-420730-155 RETIREMENT 36,171 87,776 51,605 59% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 1,305 3,400 2,095 62% 2230-440-420730-218 NON-CAPITAL EQUIPMENT 550 4,200 3,650 87% 2230-440-420730-231 GAS & OIL 4,128 7,560 3,432 45% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 2,008 4,000 1,992 50% 2230-440-420730-312 POSTAGE/PRINTING 0 1,000 1,000 100% 2230-440-420730-345 TELEPHONE & COMMUNICATION 484 1,700 1,216 72% 2230-440-420730-354 CONTRACT SERVICES 8,515 20,040 11,525 58% 2230-440-420730-359 COLLECTION / CC FEES / AUDIT FEES 2,250 1,650 600- -36% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 0 5,000 5,000 100% 2230-440-420730-373 DUES & TRAINING 4,194 12,000 7,806 65% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 32 2,500 2,468 99% 2230-440-420730-391 MEDICAL TREATMENT-SUPPLIES 28,336 54,315 25,979 48% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 13,041 13,041 0 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 6,674 13,347 6,673 50% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 24,774 49,548 24,774 50% 2230-440-420730-528 INFORMATION TECHNOLOGY TRANSFER 21,874 43,748 21,874 50% 2230-440-420730-610 PRINCIPAL - AMBULANCE 18,323 36,437 18,114 50% 2230-440-420730-620 INTEREST - AMBULANCE 1,952 3,126 1,174 38% ------------------------------------------------- TOTAL AMBULANCE EXPENDITURES 512,223 1,195,347 683,124 57% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 15 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC SAFETY IMPACT FEE REV 2399-000-341072-000 POLICE IMPACT FEES 20,304 20,000 304- -2% 2399-000-341073-000 FIRE IMPACT FEES 253,619 250,000 3,619- -1% 2399-000-371010-000 INVESTMENT EARNINGS 3,057 10,000 6,943 69% ------------------------------------------------- TOTAL PS IMPACT FEE REV 276,980 280,000 3,020 1% ================================================= PUBLIC SAFETY IMPACT FEE EXP 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 7,500 15,000 7,500 50% 2399-413-420140-610 PRINCIPAL - IMPOUND/STORAGE 0 12,000 12,000 100% 2399-413-420140-620 INTEREST - IMPOUND/STORAGE 0 3,000 3,000 100% 2399-413-420140-920 IMPOUND/STORAGE FACILITY 2,560 77,560 75,000 97% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 1,500,000 1,500,000 100% ------------------------------------------------- TOTAL PS IMPACT FEE EXP 10,060 1,607,560 1,597,500 99% ================================================= FIRE & HAZMAT GRANTS 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 1,701 5,000 3,299 66% 2956-416-420415-940 AFG GRT FY22 RADIO 0 58,300 58,300 100% ------------------------------------------------- TOTAL FIRE GRANTS 1,701 63,300 61,599 97% ================================================= 2957-416-420400-221 DoMA EQUIP (REIMB) 14,304 14,809 505 3% 2957-416-420410-125 PASS THRU HAZMAT OT 117 5,000 4,883 98% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 240 10,000 9,760 98% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 3,000 3,000 100% ------------------------------------------------- TOTAL HAZMAT GRANT 14,661 32,809 18,148 55% ================================================= 2958-416-420455-240 SUPPLIES AND EQUIPMENT 1,405 40,000 38,595 96% ------------------------------------------------- TOTAL HAZMAT EQUIP. SUSTAINMEN 1,405 40,000 38,595 96% ================================================= SAFER GRANT 2995-416-420400-110 SALARIES 0 150,000 150,000 100% 2995-416-420400-153 HEALTH INSURANCE 0 40,982 40,982 100% 2995-416-420400-155 RETIREMENT 0 21,540 21,540 100% ------------------------------------------------- TOTAL SAFER GRANT 0 212,522 212,522 100% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 16 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 677,286 750,000 72,714 10% 2394-000-323103-000 PLUMBING PERMITS 34,606 50,000 15,395 31% 2394-000-323104-000 MECHANICAL PERMITS 45,601 50,000 4,400 9% 2394-000-323105-000 ELECTRICAL PERMITS 49,812 90,000 40,188 45% 2394-000-323108-000 PLAN REVIEW FEES 307,355 120,000 187,355- -156% 2394-000-341025-000 MISC. COLLECTIONS/FEES 203 0 203- 0% 2394-000-371010-000 INVESTMENT EARNINGS 4,265 13,000 8,735 67% ------------------------------------------------- TOTAL REVENUE 1,119,127 1,073,000 46,127- -4% ================================================= BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES-BUILDING DEPT. 247,633 577,109 329,476 57% 2394-420-420530-112 SALARIES-SEVERANCE 0 27,993 27,993 100% 2394-420-420530-121 OVERTIME 14,302 20,000 5,698 28% 2394-420-420530-153 HEALTH INSURANCE 41,152 103,135 61,983 60% 2394-420-420530-155 RETIREMENT 21,174 45,136 23,963 53% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 9,588 25,000 15,412 62% 2394-420-420530-231 GAS & OIL 2,255 4,000 1,745 44% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 4,090 6,000 1,910 32% 2394-420-420530-323 ST. ED. ASSESSMENTS 2,045 5,500 3,455 63% 2394-420-420530-345 TELEPHONE & COMMUNICATION 3,590 7,500 3,910 52% 2394-420-420530-353 AUDITING 4,970 5,500 530 10% 2394-420-420530-354 CONTRACT SERVICES 12,890 40,000 27,110 68% 2394-420-420530-355 CITY WORKS LICENSING FEE 22,265 18,500 3,765- -20% 2394-420-420530-356 ArcGIS SERVER UPGRADE LICENSE 8,036 6,000 2,036- -34% 2394-420-420530-357 CREDIT CARD / PAYPAL FEES 11,749 12,500 751 6% 2394-420-420530-360 FURNITURE 80 7,500 7,420 99% 2394-420-420530-373 DUES & TRAINING 7,001 30,000 22,999 77% 2394-420-420530-510 PROPERTY INSURANCE 10,692 10,692 0 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 1,437 2,766 1,329 48% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 17,545 35,089 17,544 50% 2394-420-420530-528 INFORMATION TECHNOLOGY TRANSFER 66,137 132,274 66,137 50% 2394-420-420530-920 BUILDING IMPROVEMENTS 723 0 723- 0% 2394-420-420530-944 VEHICLE (FY22) 0 37,500 37,500 100% ------------------------------------------------- TOTAL BUILDING DEPT. 509,352 1,159,694 650,342 56% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 17 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 36,607 82,065 45,458 55% 2400-410-430263-153 HEALTH INSURANCE 5,013 14,700 9,687 66% 2400-410-430263-155 RETIREMENT 2,897 6,408 3,511 55% 2400-410-430263-244 STREET LIGHT SUPPLIES 30 18,000 17,970 100% 2400-410-430263-245 LUMINAIRES 4,719 30,000 25,281 84% 2400-410-430263-341 ELECTRICITY 68,149 182,000 113,851 63% 2400-410-430263-360 REPAIR & MAINT SERVICES 5,834 21,500 15,666 73% 2400-410-430263-373 DUES & TRAINING 0 3,500 3,500 100% 2400-410-430263-510 INSURANCE 1,846 1,850 4 0% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 6,867 13,734 6,867 50% 2400-410-430263-528 INFORMATION TECH TRANSFER 12,062 24,125 12,063 50% 2400-410-430263-940 MACHINERY & EQUIPMENT 4,549 5,000 452 9% 2400-410-430265-944 MACHINERY & EQUIP (replacement fund 0 70,000 70,000 100% ------------------------------------------------- TOTAL LIGHT MAINT. 148,572 472,882 324,310 69% ================================================= 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 54,060 99,000 44,940 45% 2420-421-430234-957 ALLEY PAVING 23,243 54,882 31,639 58% 2420-421-430240-231 GAS & OIL 19,835 42,000 22,165 53% 2420-421-430240-344 NATURAL GAS 1,178 6,800 5,622 83% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 100% 2420-421-430240-360 REPAIR & MAINT SERVICES 4,411 1,500 2,911- -194% 2420-421-430240-368 OVERLAY/CHIPSEALS 124,288 585,642 461,354 79% 2420-421-430240-452 GRAVEL 0 5,000 5,000 100% 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 33,650 58,000 24,350 42% 2420-421-430240-472 ASPHALT 24,477 40,000 15,523 39% 2420-421-430240-473 CRACK SEALING 4,998 18,000 13,002 72% 2420-421-430240-474 PAINT STRIPING MATERIALS 10,007 30,000 19,993 67% ------------------------------------------------- TOTAL GAS TAX 2,077,197 3,883,922 1,806,725 47% ================================================= BARSAA (GAS TAX) 2421-421-430240-354 PAVEMENT MAINTENANCE 391,420 476,016 84,596 18% ------------------------------------------------- TOTAL BARSAA 391,420 476,016 84,596 18% ================================================= 2825 MACI GRANT 2825-421-430240-940 EQUIPMENT 0 242,814 242,814 100% ------------------------------------------------- TOTAL MACI GRANT 0 242,814 242,814 100% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 18 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500 STREET MAINT. & SIGNS STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 392,294 886,253 493,959 56% 2500-421-430240-121 OVERTIME 3,073 28,000 24,927 89% 2500-421-430240-153 HEALTH INSURANCE 70,388 184,961 114,573 62% 2500-421-430240-155 RETIREMENT 31,302 69,499 38,197 55% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 14,657 25,545 10,888 43% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,326 7,000 5,674 81% 2500-421-430240-220 OTHER SUPPLIES 1,002 4,500 3,498 78% 2500-421-430240-231 GAS & OIL 20,007 42,000 21,993 52% 2500-421-430240-341 ELECTRICITY 1,293 3,500 2,207 63% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 1,216 3,330 2,114 64% 2500-421-430240-354 CONTRACT SERVICES 10,053 22,500 12,447 55% 2500-421-430240-356 TRANSPORTATION PLAN 328 15,000 14,672 98% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 16,124 41,000 24,876 61% 2500-421-430240-366 BUILDING MAINTENANCE 158 5,000 4,842 97% 2500-421-430240-373 DUES & TRAINING 352 13,000 12,648 97% 2500-421-430240-388 MEDICAL SERVICES 270 1,000 730 73% 2500-421-430240-510 LIABILITY INSURANCE 35,156 35,156 0 0% 2500-421-430240-512 UNINSURED LOSS-DEDUCTIBLE 0 45,000 45,000 100% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 104,911 209,822 104,911 50% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 55,509 111,018 55,509 50% 2500-421-430240-528 INFORMATION TECHNOLOGY TRANSFER 23,504 47,008 23,504 50% 2500-421-430240-840 MACI GRANT MATCH - WTR/DE-ICER TRK 0 15,000 15,000 100% 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 13,171 26,573 13,402 50% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 6,461 12,758 6,297 49% 2500-421-430244-354 PAVEMENT REPAIRS-PAVEMENT MNT FUNDS 106,320 509,666 403,346 79% 2500-421-430244-820 TRANSFER TO BaRSAA 23,750 23,750 0 0% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 104,978 632,700 527,722 83% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 11,728 27,380 15,652 57% ------------------------------------------------- TOTAL STREET MAINT. 1,049,330 3,047,919 1,998,589 66% ------------------------------------------------- SIGNS AND SIGNALS 2500-421-430264-110 TSS - SALARIES 52,443 113,067 60,624 54% 2500-421-430264-121 OVERTIME 0 7,500 7,500 100% 2500-421-430264-153 HEALTH INSURANCE 15,824 37,596 21,772 58% 2500-421-430264-155 RETIREMENT 4,148 8,810 4,662 53% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 3,294 5,960 2,666 45% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 817 7,000 6,183 88% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 3,481 4,000 519 13% 2500-421-430264-242 STREET SIGNS 11,936 30,000 18,064 60% 2500-421-430264-243 TRAFFIC SIGNALS 89 50,459 50,370 100% 2500-421-430264-245 BARRICADE MATERIALS 0 6,000 6,000 100% 2500-421-430264-341 ELECTRICITY 790 3,000 2,210 74% 2500-421-430264-345 COMMUNICATIONS 501 1,330 829 62% 2500-421-430264-354 CONTRACT SERVICES 1,282 10,000 8,718 87% 2500-421-430264-362 EQUIPMENT MAINTENANCE 370 3,000 2,630 88% 2500-421-430264-366 BUILDING MAINTENANCE 519 5,000 4,481 90% 2500-421-430264-373 DUES & TRAINING 2,177 7,500 5,323 71% 2500-421-430264-428 PAINT MATERIALS 52 5,000 4,948 99% 2500-421-430264-510 LIABILITY INS.-TSS 3,280 3,280 0- 0% 2500-421-430264-512 UNINSURED LOSS-DEDUCTIBLE 0 1,000 1,000 100% THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 19 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500-421-430264-521 CENTRAL GARAGE TRANSFER 3,614 7,227 3,613 50% 2500-421-430264-940 MACHINERY & EQUIPMENT 4,549 5,000 452 9% ------------------------------------------------- TOTAL SIGNS AND SIGNALS 109,165 321,729 212,564 66% ------------------------------------------------- TOTAL STREET MAINT. & SIGNS 1,158,496 3,369,648 2,211,152 66% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 20 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2188 WESTSIDE TIF REVENUE 2188-000-371010-000 INVESTMENT EARNINGS 2,506 2,300 206- -9% 2188-000-373010-000 INTEREST / LOANS 7,063 14,005 6,942 50% 2188-000-373020-000 PRINCIPAL / LOANS 9,575 19,271 9,696 50% 2188-000-381060-000 TRANSFER FROM GENERAL FUND 450,000 900,000 450,000 50% 2188-000-383001-000 TRANSFER FROM CD PROJECTS (2886) 400,000 828,135 428,135 52% 2188-000-383002-000 TRANSFER FROM 2880 CD 225,000 225,000 0 0% 2188-000-383003-000 TRANSFER FROM 2881 CD 300,000 300,000 0 0% 2188-000-383004-000 TRANSFER FROM 2312 RAIL PARK TEDD 70,000 140,000 70,000 50% 2188-000-383005-000 TRANSFER FROM DEBT SERVICE (3188) 450,000 900,000 450,000 50% ------------------------------------------------- TOTAL REVENUE 1,914,144 3,328,711 1,414,567 43% ================================================= EXPENDITURES 2188-480-470230-110 SALARIES 25,054 55,708 30,654 55% 2188-480-470230-153 HEALTH INSURANCE 4,350 10,556 6,206 59% 2188-480-470230-155 RETIREMENT 2,062 4,493 2,431 54% 2188-480-470230-353 AUDIT 1,420 1,500 80 5% 2188-480-470230-356 TELEPHONE 96 192 96 50% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 960 1,920 960 50% 2188-480-470440-930 CITY MATCH - TRAIL 2,689,231 4,443,135 1,753,904 39% ------------------------------------------------- TOTAL WESTSIDE TIF 2,723,174 4,517,504 1,794,330 40% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 21 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2185 AIRPORT TIF 2185-000-430300-840 REDEVELOPMENT ACTIVITY 22,646 240,459 217,813 91% ------------------------------------------------- TOTAL 2185 AIRPORT TIF 22,646 240,459 217,813 91% ================================================= OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 9,300 9,300 100% 2310-480-470210-356 FED-EX REIMBURSEMENT 8,507 8,862 355 4% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 25,000 50,000 25,000 50% 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 4,000 8,000 4,000 50% ------------------------------------------------- TOTAL OLD SCHOOL TIFS 37,507 76,162 38,655 51% ================================================= GLACIER RAIL PARK TEDD 2312-470-470210-810 TRANSFER - WESTSIDE TIF 70,000 140,000 70,000 50% 2312-480-470210-110 SALARIES & WAGES 11,847 26,594 14,747 55% 2312-480-470210-153 HEALTH INSURANCE 2,572 6,234 3,662 59% 2312-480-470210-155 RETIREMENT 974 2,164 1,190 55% 2312-480-470210-345 TELEPHONE 24 48 24 50% 2312-480-470210-353 AUDIT 1,420 1,500 80 5% 2312-480-470210-522 ADMINISTRATIVE TRANSFER 960 1,920 960 50% 2312-480-470210-795 REDEVELOPMENT / FCEDA REIMB 0 60,000 60,000 100% ------------------------------------------------- TOTAL GLACIER RAIL PARK TEDD 87,797 238,460 150,663 63% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 22 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-470-470210-810 TRANSFER - WESTSIDE TIF 225,000 225,000 0 0% 2880-480-470210-353 AUDITING 1,065 1,000 65- -7% 2880-480-470210-354 CONTRACT SERVICES 243 1,000 757 76% ------------------------------------------------- TOTAL LOAN REVOLVING 226,308 227,000 692 0% ================================================= 2881 CD LOAN REV. #2 2881-470-470210-810 TRANSFER - WESTSIDE TIF 300,000 300,000 0 0% 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 0 405 405 100% ------------------------------------------------- TOTAL 2881 CD REV. #2 300,000 300,405 405 0% ================================================= 2886 CD MISC. 2886-480-470210-795 REDEVELOPMENT - OLD SCHOOL STATION 23,919 0 23,919- 0% 2886-480-470210-810 TRANSFER TO WS TIF 400,000 828,135 428,135 52% ------------------------------------------------- TOTAL CD MISC. 423,919 828,135 404,216 49% ================================================= 2887 RURAL DEVELOPMENT #1 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 19,204 19,204 0 0% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 2,870 2,870 0 0% 2887-480-470210-750 REDEVELOPMENT LOANS 0 150,000 150,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #1 22,074 172,074 150,000 87% ================================================= 2888 RURAL DEVELOPMENT #2 2888-480-470210-354 CONT SERV (LOAN SOFTWARE) 0 500 500 100% 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 8,553 8,553 0 0% 2888-480-470210-620 INTEREST EXPENSE-USDA LOAN 61-03 1,472 1,472 0 0% 2888-480-470210-750 REDEVELOPMENT LOANS 0 299,500 299,500 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #2 10,025 310,025 300,000 97% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 23 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2945 SAMARITAN HOUSE GRANT 2945-480-470243-790 REDEVELOPMENT - SAMARITIN HOUSE PRO 0 30,000 30,000 100% ------------------------------------------------- TOTAL SAMARITAN HOUSE GRANT 0 30,000 30,000 100% 2953 EPA BROWNFIELDS 2953-480-470210-354 CONT SERV/PETROLEUM 0 10,102 10,102 100% 2953-480-470215-373 TRAVEL/HAZARDOUS 160 5,382 5,222 97% ------------------------------------------------- TOTAL EPA BROWNSFIELD 160 15,484 15,324 99% ================================================= 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES-PETROLEUM 0 218,322 218,322 100% 2955-480-470210-725 REVOLVED FUNDS-PETROLEUM 0 100,500 100,500 100% 2955-480-470215-229 SUPPLIES-HAZARDOUS SUBSTANCES 0 267,673 267,673 100% ------------------------------------------------- TOTAL BROWNFIELDS LOAN REV. 0 586,495 586,495 100% ================================================= FY21 AIRPORT GRANT 2974-430-430310-934 CAPITAL IMPROVEMENTS - LIGHTS/FENCI 0 236,712 236,712 100% ------------------------------------------------- TOTAL 2974 FY21 AIRPORT GRANT 0 236,712 236,712 100% ================================================= 2991 TIGER GRANT 2991-480-470245-790 REDEVELOPMENT - TRAIL 2,704,867 2,705,046 179 0% ------------------------------------------------- TOTAL TIGER GRANT 2,704,867 2,941,758 236,891 8% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 24 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD 364 10,000 9,636 96% 2915-413-420140-218 SMALL EQUIP -Stonegarden 0 30,000 30,000 100% ------------------------------------------------- TOTAL 2915 STONEGARDEN GRANT 364 40,000 39,636 99% ================================================= 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 28,110 69,682 41,572 60% 2916-413-420140-121 OVERTIME 6,034 13,000 6,966 54% 2916-413-420140-153 HEALTH INSURANCE 4,839 13,708 8,869 65% 2916-413-420140-155 RETIREMENT 3,826 9,352 5,526 59% ------------------------------------------------- TOTAL 2916 DRUG ENFORCEMENT 42,808 105,742 62,934 60% ================================================= 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 506 3,000 2,494 83% 2919-413-420140-121 OVERTIME - DISPATCH 259 0 259- 0% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 3,422 35,000 31,578 90% 2919-413-420140-127 SCHOOL DIST. OT 6,816 17,000 10,184 60% 2919-413-420140-218 JAG GRT/BODY ARMOR & BODY WORN CAME 1,612 13,000 11,388 88% 2919-413-420140-219 EQUIPMENT FROM CORONAVIRUS GRANT 5,000 5,000 0 0% 2919-413-420140-220 EQUIPMENT-FUNDED BY DONATIONS 9,055 4,000 5,055- -126% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 2,230 6,000 3,770 63% ------------------------------------------------- TOTAL LAW ENF. GRANT 28,900 83,000 54,100 65% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 25 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CAPITAL PROJECT FUNDS 4393 AMERICAN RESCUE PLAN GRAN 4393-410-430550-950 OTHER WTR/SWR ARPA PROJECTS 0 4,700,000 4,700,000 100% 4393-410-430550-951 DOWNTOWN WTR/SWR MAIN ARPA PROJECT 34,851 5,122,718 5,087,867 99% ------------------------------------------------- TOTAL AMERICAN RESCUE PLAN GRA 34,851 9,822,718 9,787,867 100% 4170 IMPOUND/STORAGE FACILITY 4170-400-411230-925 IMPOUND / STORAGE FACILITY 0 250,000 250,000 100% ------------------------------------------------- TOTAL IMPOUND/STORAGE FACILITY 0 250,000 250,000 100% 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION 3,967 25,000 21,033 84% ------------------------------------------------- TOTAL 4290 WALK & CURB 3,967 25,000 21,033 84% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 26 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ENTERPRISE FUNDS WATER REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 1,318 2,000 683 34% 5210-000-343210-000 METERED WATER SALES 2,651,047 3,850,000 1,198,953 31% 5210-000-343220-000 OTHER (CONST.) WATER SALES 33,279 25,000 8,279- -33% 5210-000-343230-000 METER REPLACEMENT FEE 88,698 150,000 61,302 41% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 90,797 52,500 38,297- -73% 5210-000-343270-000 WATER TURN ON FEES 1,775 4,000 2,225 56% 5210-000-343275-000 TAG FEE 16,540 33,000 16,460 50% 5210-000-343365-000 LATECOMER ADMIN FEE 8,034 10,000 1,966 20% 5210-000-371010-000 INVESTMENT EARNINGS 22,458 55,000 32,542 59% 5210-000-383010-000 TRANSFER FROM IMPACT FEE FUND (ADMI 12,000 24,000 12,000 50% 5210-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 125,000 250,000 125,000 50% ------------------------------------------------- TOTAL WATER REVENUE 3,050,945 4,455,500 1,404,555 32% ================================================= WATER FACILITIES 5210-447-430550-110 SALARIES-WATER 348,001 863,706 515,705 60% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 1,051 20,000 18,950 95% 5210-447-430550-153 HEALTH INSURANCE 69,541 193,400 123,859 64% 5210-447-430550-155 RETIREMENT 27,681 67,212 39,531 59% 5210-447-430550-210 OFFICE SUPPLIES /EQUIP/COMPUTERS/GI 13,016 23,000 9,984 43% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 4,330 9,000 4,670 52% 5210-447-430550-226 CHLORINE & CHEMICALS 23,818 59,000 35,182 60% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 2,037 4,500 2,463 55% 5210-447-430550-231 GAS & OIL 12,052 35,000 22,948 66% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 178 1,000 822 82% 5210-447-430550-336 LICENSES & FEES 114 20,000 19,886 99% 5210-447-430550-341 ELECTRICITY 81,822 160,000 78,178 49% 5210-447-430550-344 NATURAL GAS 3,520 15,500 11,980 77% 5210-447-430550-345 TELEPHONE & COMMUNICATION 8,682 13,000 4,318 33% 5210-447-430550-349 LAB SERVICES 5,294 20,000 14,706 74% 5210-447-430550-352 CONTRACT SERVICES - HOSTING FEES 538 0 538- 0% 5210-447-430550-353 AUDITING 3,195 3,500 305 9% 5210-447-430550-354 CONTRACT SERVICES 12,327 55,000 42,673 78% 5210-447-430550-355 NOFFSINGER TRANSMISSION CONDITION A 23,720 263,000 239,280 91% 5210-447-430550-356 BACKBONE CONDITION ASSESS./WTR RIGH 575 75,000 74,425 99% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 1,509 15,000 13,491 90% 5210-447-430550-366 BUILDING MAINTENANCE 1,404 15,000 13,596 91% 5210-447-430550-373 DUES & TRAINING 590 13,000 12,410 95% 5210-447-430550-388 MEDICAL SERVICES 320 700 380 54% 5210-447-430550-410 CONSTRUCTION MATERIALS 11,871 35,000 23,129 66% 5210-447-430550-422 HYDRANTS 0 10,000 10,000 100% 5210-447-430550-423 MATERIALS FOR MAINS 1,421 14,000 12,579 90% 5210-447-430550-424 MATERIALS -SERVICE LINES 11,132 12,000 868 7% 5210-447-430550-425 MATERIALS PUMPS/WELLS 10,949 65,000 54,051 83% 5210-447-430550-510 PROPERTY & LIABILITY INS. 34,319 34,319 0- 0% 5210-447-430550-512 UNINSURED LOSS-DEDUCTIBLE 0 10,000 10,000 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 23,574 47,148 23,574 50% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 60,423 120,846 60,423 50% 5210-447-430550-528 INFORMATION TECH TRANSFER 48,501 97,003 48,502 50% 5210-447-430550-532 LEASE PAYMENTS 0 4,000 4,000 100% THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 27 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-925 NOFFSINGER REHAB ALTERNATIVE 202- 1,771,916 1,772,118 100% 5210-447-430550-935 METER SYSTEM REPLACEMENT 167,469 640,500 473,031 74% 5210-447-430550-940 MACHINERY & EQUIPMENT 0 127,200 127,200 100% 5210-447-430550-951 SECURITY SCADA UPGRADES 2,111 25,000 22,889 92% 5210-447-430550-954 ELEVATED STORAGE TANK & WELL 1,400 9,731,000 9,729,600 100% 5210-447-430550-958 2ND AVE W RR FROM CENTER TO 2ND ST 132,777 148,993 16,216 11% 5210-447-430550-969 DESIGN - LOWER ZONE RESERVOIRS ROOF 14,060 665,000 650,940 98% ------------------------------------------------- SUBTOTAL WATER FACILITIES 1,165,122 15,508,443 14,343,321 92% ------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES-WATER BILLING 59,470 134,700 75,230 56% 5210-447-430560-153 HEALTH INSURANCE 14,931 38,938 24,007 62% 5210-447-430560-155 RETIREMENT 4,857 10,854 5,997 55% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 2,806 16,000 13,194 82% 5210-447-430560-353 AUDITING 1,775 2,000 225 11% 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 26,921 45,000 18,079 40% 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 15,840 28,000 12,160 43% 5210-447-430560-356 OTHER CONTRACT SERVICES 50 1,000 950 95% 5210-447-430560-373 DUES & TRAINING 0 3,000 3,000 100% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 5,840 11,681 5,841 50% 5210-447-430560-528 INFORMATION TECH TRANSFER 38,279 76,558 38,279 50% ------------------------------------------------- SUBTOTAL WATER BILLING 170,769 367,731 196,962 54% ------------------------------------------------- REVENUE BONDS 5210-447-490200-610 PRIN - 4 MILE DR TRANSMISSION / WRF 0 86,000 86,000 100% 5210-447-490200-620 INT - 4 MILE DR TRANSMISSION / WRF 49,788 49,788 1 0% 5210-447-490204-610 BOND PRIN-HWY 93 S WTR - 2004 0 81,000 81,000 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 5,716 5,716 0- 0% 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 0 350 350 100% 5210-447-490206-610 PRIN-WELL/TANK/8114 2.25% 4TH ST 0 93,000 93,000 100% 5210-447-490206-620 INT-WELL&TANK/8114 2.25% 4TH ST WT 12,758 12,758 1 0% 5210-447-490210-610 4TH AVE E MAIN REPL/WRF 17393 0 85,320 85,320 100% 5210-447-490210-620 4TH AVE E MAIN REPL/WFR 17393 40,963 40,963 0 0% ------------------------------------------------- SUBTOTAL REVENUE BONDS 109,224 454,895 345,671 76% ------------------------------------------------- DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 950,000 950,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 950,000 950,000 100% ------------------------------------------------- TOTAL WATER FUND 1,445,115 17,281,069 15,835,954 92% ================================================= WATER IMPACT FEE REVENUE: 5211-000-343225-000 IMPACT FEES 487,757 700,000 212,243 30% 5211-000-371010-000 INTEREST EARNINGS 3,044 6,000 2,957 49% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 28 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING TOTAL WATER IMPACT FEES REVENU 490,800 706,000 215,200 30% ================================================= WATER IMPACT FEES EXPENSES: 5211-447-430555-424 METERS - NEW DEVELOPMENT 55,199 61,420 6,221 10% 5211-447-430555-820 DEBT SERVICE TRANSFER TO 5210 125,000 250,000 125,000 50% 5211-447-430555-825 TRANSFER TO 5210 FOR ADMIN 12,000 24,000 12,000 50% 5211-447-430555-930 CONTRACT MAIN UPSIZE 0 405,000 405,000 100% 5211-447-430555-954 ELEVATED TANK & WELL 168,544 701,986 533,442 76% ------------------------------------------------- TOTAL WATER IMPACT FEE EXPENSE 360,743 1,442,406 1,081,663 75% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 29 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 1,318 1,500 183 12% 5310-000-343310-000 SEWER SERVICE CHARGES 3,619,959 6,780,000 3,160,041 47% 5310-000-343320-000 NUTRIENT WORK GROUP ASSISTANCE REIM 16,317 0 16,317- 0% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 9,571 1,500 8,071- -538% 5310-000-343365-000 LATECOMER ADMIN FEES 5,353 2,000 3,353- -168% 5310-000-371010-000 INVESTMENT EARNINGS 16,460 33,000 16,540 50% 5310-000-383010-000 ADMIN TRANSFER FROM IMPACT FEE FUND 50,000 100,000 50,000 50% 5310-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 500,000 1,000,000 500,000 50% ------------------------------------------------- TOTAL SEWER REVENUE 4,218,977 7,918,000 3,699,023 47% ================================================= SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES-SEWER BILLING 51,725 116,145 64,420 55% 5310-454-430620-153 HEALTH INSURANCE 11,734 28,566 16,832 59% 5310-454-430620-155 RETIREMENT - PERD 4,213 9,219 5,006 54% 5310-454-430620-215 OFFICE SUPPLIES/computers 2,806 16,000 13,194 82% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 1,775 2,000 225 11% 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 26,921 45,000 18,079 40% 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 15,840 28,000 12,160 43% 5310-454-430620-356 OTHER CONTRACT SERVICES 50 1,000 950 95% 5310-454-430620-373 DUES & TRAINING 0 3,000 3,000 100% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 5,265 10,530 5,265 50% 5310-454-430620-528 INFORMATION TECH. TRANSFER 38,279 76,558 38,279 50% ------------------------------------------------- SUBTOTAL SEWER BILLING COSTS 158,608 336,018 177,410 53% ------------------------------------------------- SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES-SANITARY SEWER 133,131 350,322 217,191 62% 5310-454-430630-121 OVERTIME 384 5,500 5,116 93% 5310-454-430630-153 HEALTH INSURANCE 22,698 81,304 58,606 72% 5310-454-430630-155 RETIREMENT 10,636 27,223 16,587 61% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 8,487 13,450 4,963 37% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 1,395 8,350 6,955 83% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 880 2,300 1,420 62% 5310-454-430630-231 GAS & OIL 5,115 12,000 6,885 57% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 0 500 500 100% 5310-454-430630-341 ELECTRICITY 19,657 57,000 37,343 66% 5310-454-430630-344 NATURAL GAS 6,044 16,500 10,456 63% 5310-454-430630-345 TELEPHONE & COMMUNICATION 9,095 27,500 18,405 67% 5310-454-430630-353 AUDITING 2,840 3,000 160 5% 5310-454-430630-354 CONTRACT SERVICES 12,093 35,000 22,907 65% 5310-454-430630-356 CONSULTANTS - MODELING/RATE STUDY 328 20,000 19,672 98% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 2,687 11,500 8,813 77% 5310-454-430630-373 DUES & TRAINING 354 9,250 8,896 96% 5310-454-430630-388 MEDICAL SERVICES 320 500 180 36% 5310-454-430630-410 CONSTRUCTION MATERIALS 1,808 10,000 8,192 82% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 47,687 70,000 22,313 32% 5310-454-430630-510 PROPERTY & LIABILITY INS. 18,697 18,697 0 0% 5310-454-430630-512 UNINSURED LOSS-DEDUCTIBLE 0 25,000 25,000 100% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 6,478 12,955 6,477 50% THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 30 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-522 ADMINISTRATIVE TRANSFER 38,666 77,331 38,665 50% 5310-454-430630-528 INFORMATION TECH TRANSFER 31,339 62,678 31,339 50% 5310-454-430630-532 OFFICE RENT / BNSF LEASE 6,890 0 6,890- 0% 5310-454-430630-922 L.S. #9 IMPROVEMENTS/DESIGN 5,595 2,247,113 2,241,518 100% 5310-454-430630-940 MACHINERY & EQUIPMENT 0 85,672 85,672 100% 5310-454-430630-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 62,098 62,098 100% 5310-454-430630-954 MN REPL. DESIGN - 1ST & 2ND AVE EN 0 1,196,414 1,196,414 100% 5310-454-430630-958 DESIGN - L.S. #3 IMPROVEMENTS 0 418,510 418,510 100% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 0 50,000 50,000 100% 5310-454-430630-961 6TH ALLEY E - S OF 14TH & 13TH 0 339,231 339,231 100% 5310-454-430635-940 MACHINERY & EQUIPMENT (10126) 0 172,700 172,700 100% ------------------------------------------------- SUBTOTAL SEWER COLLECTION 393,302 5,529,598 5,136,296 93% ------------------------------------------------- REVENUE BONDS/SANITARY 5310-454-490200-610 PRINCIPAL WESTSIDE INTERCEPTOR BOND 0 294,000 294,000 100% 5310-454-490200-620 INTEREST-WESTSIDE INTERCEPTOR BOND 279,150 279,150 0 0% 5310-454-490204-610 PRINCIPAL - HWY 93 S/SRF5125/2.25% 0 91,000 91,000 100% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 5,726 5,726 0- 0% ------------------------------------------------- SUBTOTAL REVENUE BONDS 284,876 669,876 385,000 57% ------------------------------------------------- DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 500,000 500,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION-SANITARY 0 500,000 500,000 100% ------------------------------------------------- SUBTOTAL SANITARY SEWER 678,179 6,699,474 6,021,296 90% ------------------------------------------------- WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 213,449 509,354 295,905 58% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-121 OVERTIME 10,867 22,500 11,633 52% 5310-455-430640-153 HEALTH INSURANCE 36,765 95,202 58,437 61% 5310-455-430640-155 RETIREMENT 18,313 39,199 20,886 53% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 10,383 13,500 3,117 23% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 639 3,500 2,861 82% 5310-455-430640-225 ALUM 7,097 35,000 27,903 80% 5310-455-430640-226 CHLORINE & CHEMICALS 57,908 120,000 62,092 52% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 5,126 7,500 2,374 32% 5310-455-430640-231 GAS & OIL 6,155 19,000 12,845 68% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 76 550 474 86% 5310-455-430640-336 LICENSES & FEES 135 16,000 15,865 99% 5310-455-430640-341 ELECTRICITY 73,162 195,000 121,838 62% 5310-455-430640-342 WATER 913 7,500 6,587 88% 5310-455-430640-344 NATURAL GAS 19,363 82,000 62,637 76% 5310-455-430640-345 TELEPHONE & COMMUNICATION 3,144 12,050 8,906 74% 5310-455-430640-353 AUDITING 2,485 2,500 15 1% 5310-455-430640-354 CONTRACT-GLACIER GOLD 61,970 135,000 73,030 54% 5310-455-430640-355 CONTRACT - LAND FILL & OTHER 25,082 55,500 30,418 55% THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 31 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-356 CONSULTANTS 76,988 289,000 212,012 73% 5310-455-430640-358 CONSULTANT- PERMIT/RATE STDY/TMDL 99,936 205,000 105,064 51% 5310-455-430640-360 MISC. MAINT SERVICES 19,044 35,000 15,956 46% 5310-455-430640-366 BUILDING MAINTENANCE 5,914 40,000 34,086 85% 5310-455-430640-373 DUES & TRAINING 1,935 9,500 7,565 80% 5310-455-430640-388 MEDICAL SERVICES 80 500 420 84% 5310-455-430640-510 PROPERTY & LIABILITY INS. 52,332 52,332 0 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 9,373 18,746 9,373 50% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 60,052 120,105 60,053 50% 5310-455-430640-528 INFORMATION TECH TRANSFER 27,342 54,684 27,342 50% 5310-455-430640-921 DESIGN-DOME FOR SECONDARY CLARIFIER 0 419,000 419,000 100% 5310-455-430640-922 CONSTRUCT NEW FERMENTER (rehab) 0 5,925,000 5,925,000 100% 5310-455-430640-930 BIOSOLIDS ALTERNATE DISPOSAL ENG 0 178,052 178,052 100% 5310-455-430640-933 NEW EQ BASIN 0 2,420,000 2,420,000 100% ------------------------------------------------- SUBTOTAL WWTP OPERATIONS 906,029 11,142,774 10,236,745 92% ------------------------------------------------- WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 30,313 125,000 94,687 76% 5310-455-430645-922 DESIGN FERMENTER RECONSTRUCTION 36,553 275,000 238,447 87% 5310-455-430645-934 SECONDARY DIGESTER LID REPLC 13,966 21,235 7,269 34% 5310-455-430645-940 MACHINERY & EQUIPMENT 0 280,000 280,000 100% 5310-455-430645-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 112,325 112,325 100% ------------------------------------------------- SUBTOTAL WWTP REPLACEMENT 80,832 813,560 732,728 90% ------------------------------------------------- WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 58,365 132,414 74,049 56% 5310-455-430646-153 HEALTH INSURANCE 7,550 18,720 11,170 60% 5310-455-430646-155 RETIREMENT 4,738 10,131 5,393 53% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 1,285 6,000 4,715 79% 5310-455-430646-218 NON-CAPITAL EQUIPMENT 2,271 3,500 1,229 35% 5310-455-430646-222 LAB SUPPLIES 11,060 17,500 6,440 37% 5310-455-430646-349 LAB SERVICES 8,030 19,000 10,970 58% 5310-455-430646-350 PRETREATMENT SERVICE 4,871 15,000 10,129 68% 5310-455-430646-362 EQUIPMENT MAINTENANCE 3,924 5,500 1,576 29% 5310-455-430646-373 DUES & TRAINING 0 5,000 5,000 100% 5310-455-430646-940 EQUIPMENT - ANALYZER 8,630 8,500 130- -2% ------------------------------------------------- SUBTOTAL WWTP LAB OPERATIONS 110,723 241,265 130,542 54% DEBT SERVICE - WWTP 5310-455-490227-610 PRINCIPAL - WWTP IMP/SRF8164R/2.25% 0 890,000 890,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 122,198 122,198 1 0% 5310-455-490228-610 PRINC - WWTP DIGESTER LID/SRF 13326 0 52,000 52,000 100% 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 21,540 21,540 0 0% ------------------------------------------------- SUBTOTAL DEBT SERVICE - WWTP 143,738 1,085,738 942,001 87% ------------------------------------------------- DEPRECIATION/REPL. - WWTP 5310-455-510400-831 DEPR. EXP. - WWTP (INCLUDES 010125 0 1,250,000 1,250,000 100% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 32 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SUTOTAL WWTP DEPRECIATION/REPL 0 1,250,000 1,250,000 100% ------------------------------------------------- SUBTOTAL WWTP 1,241,322 14,533,337 13,292,015 91% ------------------------------------------------- TOTAL BILLING/SANITARY/WWTP 2,078,109 21,568,829 19,490,720 90% ================================================= SEWER IMPACT FEE REVENUE 5311-000-343330-000 SANITARY IMPACT FEES 994,813 900,000 94,813- -11% 5311-000-343335-000 TREATMENT IMPACT FEES 572,105 500,000 72,105- -14% 5311-000-371010-000 SANITARY INTEREST EARNINGS 5,566 12,000 6,434 54% 5311-000-371015-000 TREATMENT INTEREST EARNINGS 4,984 9,500 4,516 48% ------------------------------------------------- TOTAL SEWER IMPACT FEES REVENU 1,577,468 1,421,500 155,968- -11% ================================================= SEWER IMPACT FEE EXPENSES 5311-454-430635-820 TRANSFER TO 5310 FOR DEBT (SANITARY 250,000 500,000 250,000 50% 5311-454-430635-825 TRANSFER TO 5310 FOR ADMIN 30,000 60,000 30,000 50% 5311-454-430635-950 RR & UPSIZE - WWTP MAIN (66% - 34% 0 120,542 120,542 100% 5311-454-430635-955 MAIN & L.S. UPSIZE 0 590,000 590,000 100% 5311-454-430635-958 DESIGN - L.S. #3 IMPROVEMENTS 0 356,509 356,509 100% 5311-455-430644-820 TRANSFER TO 5310 FOR DEBT 250,000 500,000 250,000 50% 5311-455-430644-825 TRANSFER TO 5310 FOR ADMIN 20,000 40,000 20,000 50% 5311-455-430644-929 CONSTRUCT NEW EQ BASIN 29,250 440,395 411,145 93% 5311-455-430644-930 BIOSOLIDS ALT. DISPOSAL ENG. (39%) 0 113,837 113,837 100% 5311-455-430644-950 RR & UPSIZE - WWTP MAIN (66% - 34% 0 218,679 218,679 100% ------------------------------------------------- TOTAL SEWER IMPACT FEE EXPENSE 579,250 2,939,962 2,360,712 80% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 33 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM SEWER REVENUE 5349-000-323108-000 PW PLAN REVIEW FEES 1,318 1,000 318- -32% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 0 1,500 1,500 100% 5349-000-343034-000 PERMIT FEES 1,555 1,000 555- -56% 5349-000-343035-000 STORM SEWER CHARGES 1,498 1,000 498- -50% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 1,899,482 1,850,000 49,482- -3% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 1,910 2,500 590 24% 5349-000-371010-000 INTEREST ON INVESTMENTS 7,283 20,000 12,717 64% 5349-000-383010-000 IMPACT FEE 5% ADMIN - TFR FROM IMPA 5,000 10,000 5,000 50% 5349-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 0 150,000 150,000 100% ------------------------------------------------- TOTAL STORM REVENUE 1,918,045 2,037,000 118,955 6% ================================================= STORM SEWER 5349-453-430246-110 SALARIES-STORM SEWER 209,304 537,579 328,275 61% 5349-453-430246-121 OVERTIME 406 4,000 3,594 90% 5349-453-430246-153 HEALTH INSURANCE 36,947 112,926 75,979 67% 5349-453-430246-155 RETIREMENT 16,814 41,860 25,046 60% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 13,541 17,100 3,559 21% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 382 6,000 5,618 94% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100% 5349-453-430246-231 GAS & OIL 5,115 11,500 6,385 56% 5349-453-430246-345 TELEPHONE & COMMUNICATION 1,230 3,000 1,770 59% 5349-453-430246-353 AUDITING 710 1,150 440 38% 5349-453-430246-354 CONTRACT SERVICE 3,145 7,000 3,855 55% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 5,358 35,000 29,642 85% 5349-453-430246-358 CONSULTANTS 328 10,000 9,672 97% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 13,767 30,000 16,233 54% 5349-453-430246-360 REPAIR & MAINT SERVICES 570 5,000 4,430 89% 5349-453-430246-362 GROUNDWATER MONITORING 758 6,500 5,742 88% 5349-453-430246-371 CURB & GUTTER 1,427 21,000 19,573 93% 5349-453-430246-373 DUES & TRAINING 310 9,250 8,940 97% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 1,779 10,000 8,221 82% 5349-453-430246-510 PROPERTY & LIABILITY INS. 13,436 18,436 5,000 27% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 6,478 12,955 6,477 50% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 24,612 49,223 24,611 50% 5349-453-430246-528 INFORMATION TECH TRANSFER 29,225 58,450 29,225 50% 5349-453-430246-530 BNSF LEASE PMT 0 5,500 5,500 100% 5349-453-430246-968 RR W CENTER-7TH AVE W TO MERIDIAN 255,759 230,992 24,767- -11% 5349-453-430246-970 REG. FACILITIES & PIPING DESIGN (BO 1,060,546 2,486,434 1,425,888 57% 5349-453-430247-952 STORM DRAIN CORRECTION (NEW & C/O) 18,686 200,000 181,314 91% 5349-453-430247-954 N. MAIN ST STORMWATER PROJ. 0 252,500 252,500 100% 5349-453-430247-956 WYOMING STREET OUTFALL 0 225,000 225,000 100% 5349-453-430247-959 REGIONAL FACILITIES & PIPING DESIGN 22,087 351,606 329,519 94% 5349-453-430247-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% 5349-453-430247-968 RR W CENTER-7TH AVE W TO MERIDIAN 141,480 288,079 146,599 51% 5349-453-430247-969 1ST AVE W - S. OF CITY SHOPS 2,996 395,500 392,504 99% 5349-453-430249-940 MACHINERY FROM REPLACEMENT 0 258,431 258,431 100% ------------------------------------------------- SUBTOTAL STORM OPERATIONS 1,887,197 5,754,271 3,867,074 67% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 34 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM BONDS/LOANS 5349-453-490200-610 PRINCIPAL - 4TH AVE E BOND 0 3,107 3,107 100% 5349-453-490200-620 INTEREST-4TH AVE E BOND 1,492 1,492 0 0% 5349-453-490225-610 PRINCIPAL - REGIONAL FACILITIES 0 139,038 139,038 100% 5349-453-490225-620 INTEREST - REGIONAL FACILITIES 66,879 92,000 25,121 27% ------------------------------------------------- SUBTOTAL STORM BONDS/LOANS 68,371 235,637 167,266 71% ------------------------------------------------- DEPRECIATION 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 360,000 360,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 360,000 360,000 100% ------------------------------------------------- TOTAL STORM EXPENSE 1,955,568 6,349,908 4,394,340 69% ================================================= STORM SEWER IMPACT FEE REVENUE 5348-000-343033-000 IMPACT FEES 187,202 280,000 92,798 33% 5348-000-371010-000 INTEREST EARNINGS 3,813 9,000 5,187 58% ------------------------------------------------- TOTAL STORM IMPACT FEES REVENU 191,015 289,000 97,985 34% ================================================= STORM SWR IMPACT FEE EXPENSES 5348-453-430248-820 DEBT SERVICE TRANSFER TO 5349 0 150,000 150,000 100% 5348-453-430248-825 TRANSFER TO 5349 FOR ADMIN 5,000 10,000 5,000 50% 5348-453-430248-959 REG FACILITIES & PIPING DESIGN 572,007 1,237,829 665,822 54% 5348-453-430248-960 STORMWATER FACILITY UPSIZING (CARRY 0 230,000 230,000 100% 5348-453-430248-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% ------------------------------------------------- TOTAL STORM IMPACT FEE EXPENSE 577,007 1,677,829 1,100,822 66% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 35 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SOLID WASTE REVENUE: 5510-000-343360-000 SALE OF MAT/AUCTION 2,496 2,500 4 0% 5510-000-343410-000 GARBAGE COLLECTION-ASSESSED 1,081,926 1,060,000 21,926- -2% 5510-000-343420-000 GARBAGE COLLECTION-NOT ASSESSED 28,216 25,000 3,216- -13% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,332 2,000 668 33% 5510-000-371010-000 INVESTMENT EARNINGS 2,029 10,000 7,971 80% ------------------------------------------------- TOTAL SOLID WASTE REVENUE 1,115,999 1,099,500 16,499- -2% ================================================= SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES-SOLID WASTE 210,838 471,278 260,440 55% 5510-460-430840-121 OVERTIME 2,071 6,500 4,429 68% 5510-460-430840-153 HEALTH INSURANCE 39,277 96,042 56,765 59% 5510-460-430840-155 RETIREMENT 16,857 36,556 19,699 54% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 10,601 15,500 4,899 32% 5510-460-430840-218 EQUIPMENT-GARBAGE CONTAINERS 36,601 37,500 899 2% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 1,241 5,500 4,259 77% 5510-460-430840-231 GAS & OIL 33,052 60,000 26,948 45% 5510-460-430840-341 ELECTRICITY 489 2,050 1,561 76% 5510-460-430840-344 NATURAL GAS 887 4,500 3,613 80% 5510-460-430840-345 TELEPHONE & COMMUNICATION 1,070 2,960 1,890 64% 5510-460-430840-354 CONTRACT SERVICES 2,113 22,000 19,887 90% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 3,056 55,000 51,944 94% 5510-460-430840-366 BUILDING MAINTENANCE 81 5,000 4,919 98% 5510-460-430840-373 DUES & TRAINING 302 7,000 6,698 96% 5510-460-430840-388 MEDICAL SERVICES 140 700 560 80% 5510-460-430840-510 PROPERTY & LIABILITY INS. 30,643 30,643 0- 0% 5510-460-430840-512 UNINSURED LOSS-DEDUCTIBLE 0 4,000 4,000 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 56,222 112,444 56,222 50% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 23,020 46,041 23,021 50% 5510-460-430840-528 INFORMATION TECH TRANSFER 23,504 47,008 23,504 50% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 20,000 40,000 20,000 50% 5510-460-430840-944 VEHICLES (Replacement $) 0 332,200 332,200 100% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% ------------------------------------------------- TOTAL SOLID WASTE EXPENSE 512,066 1,590,422 1,078,356 68% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 36 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING INTERNAL SERVICE FUNDS INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 ENTITLEMENT SHARE PMT/HB124 215,000 430,000 215,000 50% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 49,728 210,000 160,272 76% 6030-000-371010-000 INVESTMENT EARNINGS 678 1,100 422 38% 6030-000-393000-000 INTERNAL SERVICES-DATA 376,957 753,914 376,957 50% ------------------------------------------------- TOTAL INFORMATION TECH REVENUE 642,363 1,395,014 752,651 54% ================================================= INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 187,629 414,408 226,779 55% 6030-401-410580-121 OVERTIME 36 1,000 964 96% 6030-401-410580-153 HEALTH INSURANCE 36,247 90,081 53,834 60% 6030-401-410580-155 RETIREMENT 15,416 33,685 18,269 54% 6030-401-410588-218 COMPUTERS - ADMINISTRATIVE DEPTS 0 5,310 5,310 100% 6030-403-410580-215 COMPUTER SUPPLIES 215 3,380 3,165 94% 6030-403-410580-218 EQUIPMENT-NOT CAPITAL 14,057 28,900 14,843 51% 6030-403-410580-325 WEBSITE 5,510 6,670 1,160 17% 6030-403-410580-345 PAGER/PHONE 0 2,400 2,400 100% 6030-403-410580-346 SUMMITNET & ISPS 1,721 14,428 12,707 88% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,597 60,000 56,403 94% 6030-403-410580-354 MAINTENANCE CONTRACTS 1,541 19,000 17,459 92% 6030-403-410580-355 LICENSES 6,458 28,030 21,572 77% 6030-403-410580-356 MAINTENANCE CONTRACTS 74,053 107,900 33,847 31% 6030-403-410580-357 GRANICUS 5,280 5,300 20 0% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 62,042 66,560 4,518 7% 6030-403-410580-359 PRIVATE FIBER - CITY NETWORK 0 21,200 21,200 100% 6030-403-410580-360 MULTI-FACTOR AUTHENTICATION 6,990 8,000 1,010 13% 6030-403-410580-373 DUES & TRAINING 6,119 16,975 10,856 64% 6030-403-410580-510 INSURANCE 6,695 6,800 105 2% 6030-403-410583-218 TV-Video Equipment & programming 284 100,400 100,116 100% 6030-403-410585-229 COPIER,FAX, SUPPLIES 5,119 18,325 13,206 72% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 42,124 152,000 109,876 72% 6030-403-410585-532 COPIER LEASES 6,368 14,288 7,920 55% 6030-403-410585-942 Servers - capital contingency 135 59,000 58,865 100% 6030-403-510400-831 DEPRECIATION EXPENSE 0 25,000 25,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 1,798 2,180 382 18% 6030-405-410588-940 COMPUTERS - SWITCHES 0 50,000 50,000 100% 6030-410-410588-218 COMPUTERS - DPW 3,682 6,420 2,738 43% 6030-413-410588-218 COMPUTERS - POLICE DEPT 13,475 19,290 5,815 30% 6030-413-410588-354 POLICE - HOSTED SERVER 303 2,800 2,497 89% 6030-416-410588-218 COMPUTERS - FIRE 3,231 6,350 3,119 49% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 364 885 521 59% 6030-436-410588-218 COMPUTERS - PARKS 3,143 4,895 1,752 36% 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 2,795 2,795 100% ------------------------------------------------- TOTAL INFORMATION TECH EXPENSE 513,630 1,404,655 891,025 63% ================================================= THE CITY OF KALISPELL, MONTANA01.28.2022 11:56 gb8501_pg.php/Job No: 71900 Page 37 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 THRU DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2022 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 310,000 620,000 310,000 50% 6010-000-371010-000 INVESTMENT EARNINGS 354 900 546 61% ------------------------------------------------- TOTAL CENTRAL GARAGE REVENUE 310,354 620,900 310,546 50% ================================================= CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 86,090 186,349 100,259 54% 6010-410-431330-121 OVERTIME 757 2,500 1,743 70% 6010-410-431330-153 HEALTH INSURANCE 15,043 37,831 22,788 60% 6010-410-431330-155 RETIREMENT 6,453 14,108 7,655 54% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 5,978 19,500 13,522 69% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 3,862 23,500 19,638 84% 6010-410-431330-230 OIL 10,176 25,500 15,324 60% 6010-410-431330-231 GAS 451 1,500 1,049 70% 6010-410-431330-232 VEHICLE PARTS 56,176 140,000 83,824 60% 6010-410-431330-233 TIRES 20,881 54,000 33,119 61% 6010-410-431330-238 FILTERS 4,895 9,000 4,105 46% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 2,041 2,000 41- -2% 6010-410-431330-341 ELECTRICITY 1,463 5,900 4,437 75% 6010-410-431330-342 WATER 264 2,000 1,736 87% 6010-410-431330-344 NATURAL GAS 2,202 12,500 10,298 82% 6010-410-431330-354 CONTRACT SERVICES 13,980 32,000 18,020 56% 6010-410-431330-360 WASH BAY REPAIRS & MAINTENANCE 77 6,000 5,923 99% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 188 6,000 5,812 97% 6010-410-431330-373 DUES & TRAINING 1,604 8,500 6,896 81% 6010-410-431330-388 MEDICAL SERVICES 140 500 360 72% 6010-410-431330-510 INSURANCE 4,698 4,600 98- -2% 6010-410-431330-528 INFORMATION TECH TRANSFER 11,442 22,883 11,441 50% 6010-410-431330-921 SCAN TOOL REPLACEMENT 9,818 11,000 1,182 11% ------------------------------------------------- TOTAL CENTRAL GARAGE EXPENSES 258,682 627,671 368,989 59% =================================================