The URL can be used to link to this page

05-17-24 City Manager Report, Financials, and Police Offense and Arrest Totals1 City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 5/17/2024 1. Parks and Recreation Crews in Parks and at KYAC are energizing irrigation systems and making repairs as needed. On the systems that don’t need repairs, timers will be adjusted and set for the spring in the coming week. Crews also continue with spring health and maintenance routines of turf areas. A forestry contract for dead cottonwoods throughout the park systems has been initiated. A total of 30 trees will be removed. Crews are working on replacing the media in the 3 large pool filters at Woodland Waterpark. The media is 20 years old and is no longer efficient. We have two weeks left of the Spring Soccer season. Spring Soccer is designed to teach the fundamentals of Soccer to 3-year olds through 4th grade in a noncompetitive setting. All games are played at the Kalispell Youth Athletic Complex on Wednesday and Thursday evenings. Registration for our youth 3v3 Basketball league is open now. 3v3 Basketball is open to boys and girls heading into 4th grade through high school. Games are played at Thompson Memorial Park on Wednesday evenings with the registration deadline on June 9. Games start June 19. We still have some availability in our Harry Potter, Zombie Survival, Outdoor Adventure, and Art Camps. Activities and field trips for the summer are being secured for Camp Woodland. We hope to have them published soon. 2. Public Works Solid Waste Rollout Customer Spring Cleanup The Spring Cleanup event for Kalispell’s rollout cart customers will take place the week 2 of May 20. Public Works Staff will be tagging containers this week with a reminder of the upcoming cleanup service. Consumer Confidence Reports (CCR) All Public Water Suppliers are required to provide consumers an annual water quality report, i.e. Consumer Confidence Report (CCR). Kalispell’s CCR is available via the website and has City source water quality information for the 2023 calendar year. Notifications for the 2023 CCR is placed on the April Utility bill and will be advertised through the City’s social media outlets. 3. Building Department In the last 2 weeks we have issued permits for 6 single-family homes. This brings the total of new single-family/duplex and townhouse units for the year to 62, compared to 19 at the same time last year. There have been 0 multi-family housing units issued so far this year. There were a total of 295 combined building and/or fire inspections completed in the last 3 weeks. Residential – 41 Plumbing – 24 Commercial – 40 Mechanical – 30 Electrical – 32 Fire – 128 3 4. Planning The Planning Commission held a public hearing on May 14 and heard one application request, consisting of the following: • File #KCU-24-01 –Brenton Battles has submitted an application for a conditional use permit for the construction of a parking lot at 1825 Airport Road (Kalispell City Airport) to be associated with a new Experimental Aircraft Association Training and Educational Facility. The approximately 30-space parking lot will be located to the northwest of the northern end of the runway. The use as a training facility is permitted in the I-1 (Light Industrial) and P-1 (Public) zoning districts. The parking lot is generally a permitted use under the zoning ordinance, but is listed as a conditional use through the Airport Affected Area Ordinance due to the location of the parking in the Runway Protection Zone. The facility building itself will be located outside of the Runway Protection Zone. The Commission recommended approval of the application request. The recommendation will be forwarded to the Council for consideration at the June 3 meeting. Additionally, the Commission held a work session on the following project: • Files #KPUD-24-01 and KPP-24-02 – A request from Kalispell National Multifamily, LLC, for Bloomstone Phase 4, which includes applications for a Planned Unit Development (“PUD”) amendment to the overall Bloomstone PUD and major preliminary plat on approximately 16.6 acres of land. The property has an existing PUD and preliminary plat. The PUD amendment calls for an additional 133 units beyond the previously approved amount. The preliminary plat would replace the existing Phase 4 with a new Phase 4 including a portion of a remainder parcel. The new phase includes 135 townhouse lots (sublots), roads, and common area. The property is located on the north side of Four Mile Drive between the Highway 93 Bypass and Kidsports. No action was taken regarding this project and a public hearing is scheduled for the June 11 Commission meeting. 5. Community Development The City is contracting with NewFields to conduct an update on the phase I environmental site assessment (ESA) completed by the firm last summer on the BNSF Wye Track property. This additional work is necessary to establish the City’s prospective purchaser protections per statute for the property. This step also maintains the city’s potential eligibility for future Brownfields resources, should they be needed. The phase I ESA update is expected to be complete by the end of May. The second Safe Streets for All (SS4A) open house was held Wednesday, May 15, from 5 to 7 pm in City Council Chambers at City Hall. The public is encouraged to continue reviewing 4 materials and providing comment via the following platforms: http://www.mainstreetkalispellsafetyplan.com/ or https://storymaps.arcgis.com/stories/af5387d2a6444daebfc0295a1f25d90e. A draft Safety Action Plan is expected to be available for review in June and to move forward to City Council for consideration in July. 6. Police Department Attached is the latest case report from the Kalispell Police Department. Patrol is currently at “full staff,” however, we have 3 in the police academy, 4 in Field Training and 2 on light duty. In June, we are expected to have multiple people clearing field training and returning from light duty. Additionally, we are expected to offer several of the levy positions in the upcoming weeks. Carlee Brown attended Field Training Officer school and will begin duties training new hires starting this weekend. Officer Vukonich and Lt. Petersen attended a K9 supervisor’s course last week in Nevada. The year-to-date Calls for Service for the past three years are as follows: 2024-11,700 2023-13,686 2022-13,039 The year-to-date felony cases for the detective division for the past three years are as follows: 2024- 207 2023- 228 2022- 258 7. Finance Attached is the 3rd quarter financial report, along with a summary of the financial report. Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Crimes Against Persons Homicide/Justifiable Homicide 0 0 0 0 0 0 0 0 0 0 SIWOC/Sexual Assault 1 1 4 0 6 0 4 0 15 1 Robbery 0 0 0 0 1 1 0 0 1 1 Aggravated Assault 4 4 1 2 7 7 5 1 17 14 Assault on a Peace Officer 0 0 0 0 1 1 0 0 1 1 Simple Assault 3 1 6 5 13 6 9 4 31 16 PFMA 11 7 7 5 13 11 8 7 39 30 Resisting Arrest 2 2 0 0 4 3 1 1 7 6 Crimes Against Property Burglary 2 0 0 0 4 1 3 0 9 1 Theft 33 15 51 23 47 26 60 24 191 88 Vehicle Theft/Unauth Use 3 1 5 0 4 0 3 0 15 1 Arson 0 0 1 1 0 0 0 0 1 1 Forgery/Counterfeit 1 1 2 1 1 1 3 2 7 5 Fraud 1 0 5 0 5 0 2 1 13 1 Theft of Identity 0 0 2 0 1 0 2 0 5 0 Embezzlement 0 0 1 0 0 0 1 0 2 0 Stolen Property offenses 0 0 0 0 3 0 0 0 3 0 Criminal Mischief 2 2 5 3 8 2 13 4 28 11 Crimes Against Society Weapon Law Violations 0 0 0 0 0 0 0 0 0 0 Prostitution Offenses 0 0 0 0 2 0 1 0 3 0 Child Pornography 3 0 0 0 0 0 0 0 3 0 Drug Offenses 19 15 21 15 22 10 13 6 75 46 Family Offenses (non-violent)0 0 0 0 0 0 1 0 1 0 DUI 6 5 9 8 8 6 14 14 37 33 Possession of Alcohol 3 5 2 2 3 3 2 4 10 14 Provide Alcohol to Minor 0 0 0 0 0 0 0 0 0 0 Other Alcohol Offenses 0 0 0 0 1 1 1 1 2 2 Kidnapping/Custodial Int.1 0 0 0 1 1 0 0 2 1 Disorderly Conduct 4 4 5 6 3 3 5 6 17 19 Criminal Trespass 20 14 28 23 23 18 19 12 90 67 Violation of Protective Order 2 1 4 3 1 1 1 0 8 5 Obstructing a peace officer 6 5 4 4 5 4 4 4 19 17 Juvenile Offenses (except MIP)2 0 3 0 6 3 7 2 18 5 Other Offenses 15 10 20 19 24 18 17 17 76 64 Total 144 93 186 120 217 127 199 110 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 746 450 Traffic Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites 254 172 432 217 413 218 383 247 1482 854 Total Calls for Service Kalispell Police Department Case and Arrest Reports - 2024 January February March April May June July August September October November December Totals 2272 2569 2794 2822 10457 THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 1 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 4,331,641 7,575,000 3,243,359 43% 1000-000-311200-000 PERSONAL PROPERTY TAXES 109,639 100,000 9,639- -10% 1000-000-311400-000 AIRPORT TIF SUNSET DISTRIBUTION 44,657 0 44,657- 0% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 10,811 10,000 811- -8% 1000-000-322101-000 LIQUOR LICENSES 0 33,000 33,000 100% 1000-000-322300-000 GENERAL & OCCUPATIONAL 404 500 96 19% 1000-000-323012-000 PLANNING FEES 282,843 225,000 57,843- -26% 1000-000-323109-000 SITE REVIEW 6,649 20,000 13,351 67% 1000-000-323200-000 PARADE PERMITS 100 500 400 80% 1000-000-331023-000 MRVCTF 980 0 980- 0% 1000-000-331112-000 KPD - SAFE STREET TASK FORCE 0 5,000 5,000 100% 1000-000-334010-000 CANNABIS LOCAL OPTION TAX 111,721 200,000 88,279 44% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 1,000 1,000 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 54,700 60,000 5,300 9% 1000-000-335110-000 LIVE CARD TABLE PERMIT 700 1,650 950 58% 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 2,447,295 3,263,060 815,765 25% 1000-000-341020-000 ADMINISTRATIVE CHARGES 548,272 715,947 167,675 23% 1000-000-341021-000 GRANT ADMIN FEES 10,229 30,000 19,771 66% 1000-000-341025-000 CITY COLLECTIONS 12,186 5,000 7,186- -144% 1000-000-342010-000 POLICE SERVICES 19,732 30,000 10,268 34% 1000-000-342014-000 RESOURCE OFFICERS 265,306 265,306 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 652 10,000 9,348 93% 1000-000-342017-000 KFD-IFSAC TRAINING REIMB 6,140 8,000 1,860 23% 1000-000-343018-000 PARKING PERMITS 68,706 70,000 1,294 2% 1000-000-343062-000 AIRPORT FUEL TAXES 2,820 4,000 1,180 29% 1000-000-343063-000 AIRPORT GROUND LEASE (HILTON) 0 14,000 14,000 100% 1000-000-351000-000 CITY COURT FINES & FEES 201,601 430,000 228,399 53% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 9,007 25,000 15,993 64% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 40,292 30,000 10,292- -34% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 38,623 20,000 18,623- -93% 1000-000-362020-000 MMIA LIABILITY RETRO 22,874 27,000 4,126 15% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 510 10,000 9,490 95% 1000-000-371010-000 INVESTMENT EARNINGS 450,517 225,000 225,517- -100% 1000-000-381050-000 TRANSFER FROM 2886 CD 6,532 250,000 243,468 97% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 565,000 1,150,000 585,000 51% ------------------------------------------------- TOTAL GENERAL FUND REVENUE 9,671,140 14,813,963 5,142,823 35% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 2 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 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 3,000 3,030 30 1% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 20,518 17,250 3,268- -19% 1000-400-410530-354 GASB 75 ACTUARIAL VALUATION 8,000 8,000 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 688 4,000 3,312 83% 1000-400-410560-312 POSTAGE 11,188 17,500 6,312 36% 1000-400-410560-320 PRINTING & ENVELOPES 2,276 2,500 224 9% 1000-400-410560-354 CONTRACT SERVICES - DOC. SHRED / 10 3,298 3,000 298- -10% 1000-400-410600-354 ELECTIONS 22,874 50,000 27,126 54% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 2,791 4,500 1,709 38% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 256 350 94 27% 1000-400-430300-355 AIRPORT REIMBURSEMENT 4,737 25,000 20,263 81% 1000-400-460452-355 MOUNTAIN CLIMBER CONTRIBUTION 15,000 15,000 0 0% 1000-400-460452-366 HOCKADAY MAINTENANCE 6,600 6,600 0 0% 1000-400-510300-000 CONTINGENCY 10,658 50,000 39,342 79% 1000-400-510310-354 ICMA PLAN FEES 125 0 125- 0% 1000-400-510330-513 LIABILITY INSURANCE 320,406 320,406 0 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 35,671 50,000 14,329 29% 1000-400-510330-517 PROPERTY INSURANCE 82,359 82,359 0- 0% ------------------------------------------------- SUBTOTAL GEN.GOV'T. 550,445 659,495 109,050 17% CITY MANAGER 1000-401-410210-110 SALARIES-CITY MANAGER'S OFFICE 134,073 190,481 56,408 30% 1000-401-410210-153 HEALTH INSURANCE 17,040 25,364 8,324 33% 1000-401-410210-155 RETIREMENT 14,419 20,358 5,939 29% 1000-401-410210-210 SUPPLIES 0 500 500 100% 1000-401-410210-312 NEWSLETTER/BOOKS 0 200 200 100% 1000-401-410210-345 TELEPHONE & COMMUNICATION 720 1,200 480 40% 1000-401-410210-373 DUES & TRAINING 6,648 12,000 5,352 45% 1000-401-410210-379 MEETINGS 3,955 6,500 2,545 39% INFORMATION TECHNOLOGY ------------------------------------------------- SUBTOTAL CITY MANAGER 176,854 256,603 79,749 31% HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 154,629 215,580 60,951 28% 1000-401-410830-153 HEALTH INSURANCE 15,895 24,066 8,171 34% 1000-401-410830-155 RETIREMENT 13,005 17,826 4,821 27% 1000-401-410830-210 OFFICE SUPPLIES 3,400 3,500 100 3% 1000-401-410830-338 RECRUITMENT/RELOCATION 20,837 24,000 3,163 13% 1000-401-410830-354 CONTRACT SERVICES 2,209 2,500 292 12% 1000-401-410830-373 DUES & TRAINING 7,473 17,000 9,527 56% ------------------------------------------------- SUBTOTAL HUMAN RESOURCES 217,447 304,472 87,025 29% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 3 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 45,295 63,179 17,884 28% 1000-402-410100-153 HEALTH INSURANCE 30,960 48,786 17,826 37% 1000-402-410100-155 RETIREMENT 1,932 2,676 744 28% 1000-402-410100-210 OFFICE SUPPLIES 0 3,500 3,500 100% 1000-402-410100-335 MT LEAGUE OF CITIES 1,259 4,000 2,741 69% 1000-402-410100-354 CONTRACT SERVICES 1,631 5,500 3,869 70% 1000-402-410100-373 DUES & TRAINING 0 13,000 13,000 100% 1000-402-410100-379 MEETINGS 17,660 28,000 10,340 37% ------------------------------------------------- SUBTOTAL MAYOR/COUNCIL 98,737 168,641 69,904 41% CITY CLERK 1000-402-410150-110 SALARIES-CITY CLERK 95,168 132,406 37,238 28% 1000-402-410150-121 OVERTIME 34 250 216 87% 1000-402-410150-153 HEALTH INSURANCE 11,747 17,796 6,049 34% 1000-402-410150-155 RETIREMENT 7,997 11,023 3,026 27% 1000-402-410150-210 OFFICE SUPPLIES 41 400 359 90% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 120 500 380 76% 1000-402-410150-345 TELEPHONE & COMMUNICATION 360 480 120 25% 1000-402-410150-352 CODIFICATION 4,605 4,100 505- -12% 1000-402-410150-354 CONTRACT SERVICES 0 450 450 100% 1000-402-410150-373 DUES & TRAINING 1,666 4,500 2,834 63% ------------------------------------------------- SUBTOTAL CITY CLERK 121,738 171,905 50,167 29% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES-FINANCE OFFICE 210,878 278,375 67,497 24% 1000-403-410550-121 OVERTIME 129 500 371 74% 1000-403-410550-153 HEALTH INSURANCE 31,412 45,135 13,723 30% 1000-403-410550-155 RETIREMENT 17,679 23,113 5,434 24% 1000-403-410550-210 SUPPLIES 69 1,000 931 93% 1000-403-410550-322 BOOKS 0 250 250 100% 1000-403-410550-353 CONTRACT SERVICES 301 1,500 1,199 80% 1000-403-410550-354 CONTRACT-GRIZZLY SECURITY 1,211 1,500 289 19% 1000-403-410550-355 BANK CHARGES & FEES 2,305 3,500 1,195 34% 1000-403-410550-373 DUES & TRAINING 2,297 12,000 9,703 81% ------------------------------------------------- SUBTOTAL FINANCE 266,281 366,873 100,592 27% CITY ATTORNEY 1000-404-411110-110 SALARIES-CITY ATTORNEY'S 400,611 570,797 170,186 30% 1000-404-411110-121 OVERTIME 69 0 69- 0% 1000-404-411110-153 HEALTH INSURANCE 48,797 84,286 35,489 42% 1000-404-411110-155 RETIREMENT 33,666 47,472 13,806 29% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 8,591 13,930 5,339 38% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 6,709 10,000 3,291 33% 1000-404-411110-345 TELEPHONE & COMMUNICATION 588 1,000 412 41% 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 110 10,000 9,890 99% 1000-404-411110-373 DUES & TRAINING 5,440 10,000 4,560 46% ------------------------------------------------- SUBTOTAL CITY ATTORNEY 504,580 747,485 242,905 33% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 4 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MUNICIPAL COURT 1000-406-410360-110 SALARIES-COURT 213,749 307,302 93,553 30% 1000-406-410360-121 OVERTIME 0 3,500 3,500 100% 1000-406-410360-153 HEALTH INSURANCE 25,276 55,044 29,768 54% 1000-406-410360-155 RETIREMENT 17,969 25,500 7,531 30% 1000-406-410360-210 SUPPLIES 2,208 4,500 2,292 51% 1000-406-410360-320 PRINTING/BOOKS 1,039 1,500 461 31% 1000-406-410360-345 TELEPHONE & COMMUNICATION 742 1,500 758 51% 1000-406-410360-353 SECURITY & TECHNOLOGY 2,642 40,000 37,358 93% 1000-406-410360-354 CONTRACT SERVICES 6,496 7,000 504 7% 1000-406-410360-373 DUES & TRAINING 2,756 10,000 7,244 72% 1000-406-410360-394 JURY & WITNESS FEES 1,206 10,000 8,794 88% ------------------------------------------------- SUBTOTAL COURT 274,083 465,846 191,763 41% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 5 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES-PUBLIC WORKS 19,971 27,752 7,781 28% 1000-410-430100-153 HEALTH INSURANCE 2,569 3,901 1,332 34% 1000-410-430100-155 RETIREMENT 1,664 2,274 610 27% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 9,556 15,500 5,944 38% 1000-410-430100-218 NON CAPITAL EQUIP/ENGINEERING TOOLS 402 3,500 3,098 89% 1000-410-430100-231 GAS 4,013 6,800 2,787 41% 1000-410-430100-345 TELEPHONE & COMMUNICATION 2,008 1,600 408- -26% 1000-410-430100-354 CONTRACT SERVICES 2,419 4,000 1,581 40% 1000-410-430100-373 DUES & TRAINING 2,952 5,000 2,048 41% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 4,120 5,494 1,374 25% ------------------------------------------------- SUBTOTAL PUBLIC WORKS ADMIN 49,676 75,821 26,145 34% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 6 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CITY HALL MAINT. 1000-412-411230-110 SALARIES-CITY HALL 60,950 83,711 22,761 27% 1000-412-411230-153 HEALTH INSURANCE 10,757 15,307 4,550 30% 1000-412-411230-155 RETIREMENT 5,072 6,892 1,820 26% 1000-412-411230-220 SECURITY IMPROVEMENTS 33,822 85,700 51,878 61% 1000-412-411230-224 JANITORIAL SUPPLIES 4,019 7,600 3,581 47% 1000-412-411230-241 TOOLS & SUPPLIES 1,142 1,500 358 24% 1000-412-411230-341 ELECTRICITY 32,749 50,000 17,251 35% 1000-412-411230-344 NATURAL GAS 22,545 45,430 22,885 50% 1000-412-411230-345 TELEPHONE & COMMUNICATION 335 500 165 33% 1000-412-411230-354 CONTRACT SERVICES 11,511 15,000 3,489 23% 1000-412-411230-355 HVAC MAINTENANCE CONTRACT 22,876 21,500 1,376- -6% 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 9,859 7,500 2,359- -31% 1000-412-411230-362 EQUIPMENT MAINTENANCE 9,163 20,000 10,837 54% 1000-412-411230-366 BUILDING MAINTENANCE 9,898 25,000 15,102 60% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,431 4,000 569 14% 1000-412-411230-920 BLDG IMPROVEMENT 54,972 65,000 10,028 15% ------------------------------------------------- SUBTOTAL CITY HALL 293,100 454,640 161,540 36% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 7 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES-PLANNING & ZONING 198,144 274,209 76,065 28% 1000-420-411020-153 HEALTH INSURANCE 30,505 46,284 15,779 34% 1000-420-411020-155 RETIREMENT 16,650 22,820 6,170 27% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 0 5,000 5,000 100% 1000-420-411020-231 GAS 209 550 341 62% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 902 2,500 1,598 64% 1000-420-411020-345 TELEPHONE 307 1,000 693 69% 1000-420-411020-354 CONTRACT SERVICES 6,594 6,000 594- -10% 1000-420-411020-373 DUES & TRAINING 7,119 8,000 881 11% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 206 275 69 25% ------------------------------------------------- SUBTOTAL PLANNING DEPT. 260,635 366,638 106,003 29% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 8,007 11,163 3,156 28% 1000-480-470210-153 HEALTH INSURANCE 970 1,971 1,001 51% 1000-480-470210-155 RETIREMENT 674 920 246 27% 1000-480-470210-210 OFFICE SUPPLIES 0 1,200 1,200 100% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 0 500 500 100% 1000-480-470210-312 POSTAGE & PRINTING 0 300 300 100% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 0 500 500 100% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 73 400 327 82% 1000-480-470210-354 CONTRACT SERVICES 0 250 250 100% 1000-480-470210-373 DUES & TRAINING 3,154 2,500 654- -26% 1000-480-470210-379 MEETINGS 0 750 750 100% ------------------------------------------------- SUBTOTAL COMMUNITY DEVELOPMENT 12,878 20,454 7,576 37% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 8 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES-POLICE 2,068,867 3,055,993 987,126 32% 1000-413-420140-112 SALARIES-SEVERANCE 0 45,000 45,000 100% 1000-413-420140-114 SALARY -comptime buyout 6,574 8,000 1,426 18% 1000-413-420140-121 OVERTIME (REG & AET OT) 47,450 80,000 32,550 41% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 13,491 35,000 21,509 61% 1000-413-420140-153 HEALTH INSURANCE 305,447 533,321 227,874 43% 1000-413-420140-155 RETIREMENT 262,626 402,034 139,408 35% 1000-413-420140-210 OFFICE SUPPLIES 1,639 5,000 3,361 67% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 3,172 4,310 1,138 26% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 48,421 48,946 525 1% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 3,402 7,230 3,828 53% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 10,976 16,200 5,224 32% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 1,651 2,780 1,129 41% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 2,520 21,500 18,980 88% 1000-413-420140-227 AMMO & RELATED SUPPLIES 50,783 56,500 5,717 10% 1000-413-420140-228 PATROL CAR SUPPLIES 2,077 2,100 23 1% 1000-413-420140-229 OTHER SUPPLIES 9,714 13,000 3,286 25% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 1,001 1,000 1- -0% 1000-413-420140-231 GAS 44,848 85,000 40,152 47% 1000-413-420140-234 CRISIS NEGOTIATIONS 1,528 2,400 872 36% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 108 1,500 1,392 93% 1000-413-420140-320 PRINTING 7,359 4,500 2,859- -64% 1000-413-420140-345 TELEPHONE & COMMUNICATION 17,353 23,500 6,147 26% 1000-413-420140-354 CONTRACT SERVICES 45,903 83,000 37,097 45% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 3,224 7,000 3,776 54% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 2,625 4,900 2,275 46% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 549 2,500 1,951 78% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 38,338 69,000 30,662 44% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 3,551 6,500 2,949 45% 1000-413-420140-373 DUES & TRAINING 21,785 60,500 38,715 64% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 967 14,500 13,534 93% 1000-413-420140-380 TRAINING MATERIALS 4,000 4,000 0 0% 1000-413-420140-388 MEDICAL SERVICES 3,146 3,000 146- -5% 1000-413-420140-392 BOARDING/TREATING PRISONERS 716 3,255 2,540 78% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 72,923 97,230 24,307 25% 1000-413-420140-530 RENT 6,300 8,400 2,100 25% ------------------------------------------------- SUBTOTAL O & M 3,115,032 4,818,599 1,703,567 35% TRANSFERS 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 48,000 64,000 16,000 25% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 4,500 6,000 1,500 25% ------------------------------------------------- TOTAL TRANSFERS 52,500 70,000 17,500 25% CAPITAL OUTLAY 1000-413-420140-942 EQUIPMENT (WATCHGUARD CAMERA/MOTORO 6,345 12,500 6,155 49% 1000-413-420140-944 VEHICLES 101,642 228,000 126,358 55% ------------------------------------------------- TOTAL CAPITAL OUTLAY 107,988 240,500 132,512 55% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 9 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING DETECTIVES 1000-413-420141-110 SALARIES-DETECTIVES 323,675 454,688 131,013 29% 1000-413-420141-121 DETECTIVE-OVERTIME 9,983 15,000 5,017 33% 1000-413-420141-123 OVERTIME (SAFE NEIGHBORHOOD TASK FO 1,034 8,000 6,966 87% 1000-413-420141-153 HEALTH INSURANCE 47,151 81,447 34,296 42% 1000-413-420141-155 DETECTIVE-RETIREMENT 43,347 60,948 17,601 29% ------------------------------------------------- TOTAL DETECTIVES 425,189 620,083 194,894 31% RECORDS 1000-413-420142-110 SALARIES-RECORDS DIVISION 137,235 205,766 68,531 33% 1000-413-420142-121 OVERTIME 2,741 6,500 3,759 58% 1000-413-420142-153 HEALTH INSURANCE 31,231 48,693 17,462 36% 1000-413-420142-155 RETIREMENT 11,743 17,033 5,290 31% ------------------------------------------------- TOTAL RECORDS 182,951 277,992 95,041 34% RESOURCE OFFICERS 1000-413-420144-110 SALARIES-SRO 212,293 342,463 130,170 38% 1000-413-420144-153 HEALTH INSURANCE 30,933 57,913 26,980 47% 1000-413-420144-155 SRO RETIREMENT 27,415 46,001 18,586 40% ------------------------------------------------- TOTAL RESOURCE OFFICERS 270,641 446,377 175,736 39% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL-SALARIES 38,638 56,242 17,604 31% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 6,192 10,357 4,165 40% 1000-413-420145-155 RETIREMENT 3,171 4,482 1,311 29% ------------------------------------------------- SUBTOTAL ANIMAL CONTROL 48,001 71,581 23,580 33% PARKING 1000-413-420147-110 PARKINGS -SALARIES 81,252 113,801 32,549 29% 1000-413-420147-153 HEALTH INSURANCE 22,595 34,330 11,735 34% 1000-413-420147-155 RETIREMENT 6,759 9,324 2,565 28% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 1,454 3,000 1,546 52% 1000-413-420147-354 CONTRACTED SERVICES 1,972 3,000 1,028 34% 1000-413-420147-362 LOT MAINT 1,714 10,000 8,286 83% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 15,615 20,000 4,385 22% 1000-413-420147-550 LOT LEASE PAYMENTS 733 1,500 767 51% ------------------------------------------------- SUBTOTAL PARKING 132,094 194,955 62,861 32% ------------------------------------------------- SUBTOTAL POLICE DEPT. 4,334,396 6,740,087 2,405,691 36% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 10 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES-FIRE SUPPRESSION 1,798,080 2,521,748 723,668 29% 1000-416-420400-112 SALARY-SEVERANCE 11,446 15,000 3,554 24% 1000-416-420400-114 COMPTIME BUYOUT 3,090 5,500 2,410 44% 1000-416-420400-115 OUT OF RANK PAY 9,614 12,500 2,886 23% 1000-416-420400-121 OVERTIME 137,012 60,000 77,012- -128% 1000-416-420400-153 HEALTH INSURANCE 275,119 443,566 168,447 38% 1000-416-420400-155 RETIREMENT 233,447 355,470 122,023 34% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 2,581 5,300 2,719 51% 1000-416-420400-218 EQUIPMENT (Non Capital) 23,153 32,500 9,347 29% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 7,104 24,000 16,896 70% 1000-416-420400-224 JANITORIAL SUPPLIES 6,585 6,000 585- -10% 1000-416-420400-231 GAS 14,059 24,000 9,941 41% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 5,902 19,025 13,123 69% 1000-416-420400-320 PRINTING 0 200 200 100% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 30 1,400 1,370 98% 1000-416-420400-345 TELEPHONE & COMMUNICATION 4,825 5,500 675 12% 1000-416-420400-354 CONTRACT SERVICES 77,175 80,000 2,825 4% 1000-416-420400-362 EQUIPMENT MAINTENANCE 2,734 6,800 4,066 60% 1000-416-420400-366 BUILDING MAINTENANCE-STATION 62 7,823 16,000 8,177 51% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 1,637 5,500 3,863 70% 1000-416-420400-373 DUES & TRAINING 24,893 28,000 3,107 11% 1000-416-420400-388 FIREFIGHTER PHYSICALS 12,909 40,000 27,091 68% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 25,769 34,359 8,590 25% ------------------------------------------------- TOTAL O & M 2,684,987 3,742,368 1,057,381 28% DEBT SERVICE 1000-416-420400-610 DEBT RETIREMENT-FIRE TRUCK 48,291 70,791 22,500 32% 1000-416-420400-620 INTEREST EXPENSE-FIRE TRUCK 13,903 27,537 13,634 50% ------------------------------------------------- TOTAL DEBT SERVICE 62,194 98,328 36,134 37% TRANSFERS 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 667,500 890,000 222,500 25% ------------------------------------------------- TOTAL TRANSFERS 667,500 890,000 222,500 25% CAPITAL OUTLAY 1000-416-420400-940 CAPITAL EQUIPMENT-VEHICLE/SCBA/SERV 54,706 120,000 65,294 54% ------------------------------------------------- TOTAL CAPITAL OUTLAY 54,706 120,000 65,294 54% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 11 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PREVENTION 1000-416-420440-110 SALARIES-FIRE PREVENTION 20,768 30,008 9,240 31% 1000-416-420440-121 OVERTIME 1,483 0 1,483- 0% 1000-416-420440-153 HEALTH INSURANCE 3,881 0 3,881- 0% 1000-416-420440-155 RETIREMENT 1,854 0 1,854- 0% ------------------------------------------------- TOTAL PREVENTION 27,987 30,008 2,021 7% ------------------------------------------------- TOTAL FIRE DEPARTMENT 3,497,375 4,880,704 1,383,329 28% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 12 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GRAND TOTAL GENERAL FUND 10,658,225 15,679,664 5,021,439 32% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 13 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 ENTITLEMENT SHARE PMT/HB124 330,000 440,000 110,000 25% 6030-000-341025-000 MISC REVENUE 800 0 800- 0% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 89,452 225,000 135,548 60% 6030-000-364030-000 SALE OF MISCELLANEOUS 879 0 879- 0% 6030-000-371010-000 INVESTMENT EARNINGS 16,910 10,000 6,910- -69% 6030-000-393000-000 INTERNAL SERVICES-DATA 544,828 726,448 181,620 25% ------------------------------------------------- TOTAL REVENUE 982,870 1,401,448 418,579 30% ================================================= EXPENSES 6030-401-410580-110 SALARIES 336,543 501,721 165,178 33% 6030-401-410580-121 OVERTIME 68 1,000 932 93% 6030-401-410580-153 HEALTH INSURANCE 61,481 102,551 41,070 40% 6030-401-410580-155 RETIREMENT 28,336 41,699 13,363 32% 6030-401-410588-218 COMPUTERS - ADMINISTRATIVE DEPTS 4,170 4,300 130 3% 6030-403-410580-215 COMPUTER SUPPLIES 1,290 3,900 2,610 67% 6030-403-410580-218 EQUIPMENT-NOT CAPITAL 15,005 28,080 13,075 47% 6030-403-410580-325 WEBSITE 9,794 10,200 406 4% 6030-403-410580-345 PAGER/PHONE 1,632 2,800 1,168 42% 6030-403-410580-346 SUMMITNET & ISPS 5,404 8,428 3,024 36% 6030-403-410580-353 LASER FICHE MAINTENANCE 11,630 13,000 1,370 11% 6030-403-410580-354 MAINTENANCE CONTRACTS 21,743 48,100 26,357 55% 6030-403-410580-355 LICENSES 17,541 32,959 15,418 47% 6030-403-410580-356 MAINTENANCE CONTRACTS 75,803 133,050 57,247 43% 6030-403-410580-357 GRANICUS 9,000 7,800 1,200- -15% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 58,804 79,666 20,862 26% 6030-403-410580-359 PRIVATE FIBER - CITY NETWORK 11,656 18,600 6,944 37% 6030-403-410580-360 MULTI-FACTOR AUTHENTICATION 0 9,000 9,000 100% 6030-403-410580-373 DUES & TRAINING 7,798 16,960 9,162 54% 6030-403-410580-510 INSURANCE 7,952 7,952 0 0% 6030-403-410583-218 TV-Video Equipment & programming 14,457 23,500 9,043 38% 6030-403-410585-229 COPIER,FAX, SUPPLIES 6,620 18,223 11,603 64% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 118,004 265,433 147,429 56% 6030-403-410585-532 COPIER LEASES 0 13,460 13,460 100% 6030-403-410585-940 MACHINERY & EQUIPMENT 57,871 0 57,871- 0% 6030-403-410585-942 Servers - capital contingency 93,530 80,925 12,605- -16% 6030-403-510400-831 DEPRECIATION EXPENSE 0 50,000 50,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 3,227 3,460 233 7% 6030-405-410588-940 COMPUTERS - SWITCHES 62,918 160,025 97,107 61% 6030-410-410588-218 COMPUTERS - DPW 6,445 6,922 477 7% 6030-413-410588-218 COMPUTERS - POLICE DEPT 26,383 31,710 5,327 17% 6030-416-410588-218 COMPUTERS - FIRE 5,867 22,630 16,763 74% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 1,408 4,350 2,942 68% 6030-436-410588-218 COMPUTERS - PARKS 3,660 4,300 640 15% ------------------------------------------------- TOTAL EXPENSE 1,086,040 1,756,704 670,664 38% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 14 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC SAFETY - EMERGENCY SERV AMBULANCE FUND REVENUE 2230-000-331990-000 DNRC RIDGE FIRE AMB. STANDBY REIMB 54,765 0 54,765- 0% 2230-000-342050-000 FEES FOR SERVICES 324,750 500,000 175,250 35% 2230-000-342070-000 COUNTY EMS LEVY 133,179 160,000 26,821 17% 2230-000-365000-000 DONATIONS/SALE OF EQUIP/MISC 400 0 400- 0% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 667,500 890,000 222,500 25% ------------------------------------------------- TOTAL REVENUE 1,180,594 1,550,000 369,406 24% ================================================= EXPENSE 2230-440-420730-110 SALARIES 574,995 824,009 249,014 30% 2230-440-420730-113 KELLY DAYS 20- 0 20 0% 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 84,409 30,000 54,409- -181% 2230-440-420730-153 HEALTH INSURANCE 99,025 139,951 40,926 29% 2230-440-420730-155 RETIREMENT 74,918 107,145 32,227 30% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 977 3,400 2,423 71% 2230-440-420730-218 NON-CAPITAL EQUIPMENT 397 4,800 4,403 92% 2230-440-420730-231 GAS & OIL 7,709 13,000 5,291 41% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 2,708 5,500 2,792 51% 2230-440-420730-312 POSTAGE/PRINTING 70 1,000 930 93% 2230-440-420730-345 TELEPHONE & COMMUNICATION 1,955 2,000 45 2% 2230-440-420730-354 CONTRACT SERVICES 15,358 32,800 17,442 53% 2230-440-420730-359 COLLECTION SERV. / CC FEES / AUDIT 2,966 5,300 2,334 44% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 0 5,500 5,500 100% 2230-440-420730-373 DUES & TRAINING 11,793 16,500 4,707 29% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,000 2,000 100% 2230-440-420730-391 MEDICAL TREATMENT-SUPPLIES 34,923 62,000 27,077 44% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 14,605 15,480 875 6% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 14,995 19,995 5,000 25% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 36,658 48,877 12,219 25% 2230-440-420730-528 INFORMATION TECHNOLOGY TRANSFER 34,499 46,198 11,699 25% 2230-440-420730-610 PRINCIPAL - AMBULANCE 37,877 37,877 0 0% 2230-440-420730-620 INTEREST - AMBULANCE 6,127 6,673 546 8% 2230-440-420730-940 EQUIPMENT 57,807 105,401 47,594 45% ------------------------------------------------- TOTAL EXPENDITURES 1,114,751 1,542,206 427,455 28% ================================================= 2230 AMBULANCE CASH 2230-000-010100-000 CASH, AMBULANCE 93,975 0 93,975- 0% ------------------------------------------------- AMBULANCE CASH BALANCE 93,975 0 93,975- 0% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 15 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2995 SAFER GRANT ------------------------------------------------- TOTAL SAFER REVENUE 0 0 0 0% ================================================= ------------------------------------------------- TOTAL SAFER EXP 0 0 0 0% ================================================= 2956 FIRE GRANTS 2956-416-420400-218 RESCUE EQUIPMENT - TOWNPUMP GRANT 6,000 6,000 0 0% 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 3,465 5,000 1,535 31% ------------------------------------------------- 2956 TOTAL FIRE GRANTS 9,465 11,000 1,535 14% ================================================= 2957 HAZMAT GRANT 2957-416-420410-125 PASS THRU HAZMAT OT 1,763 5,000 3,237 65% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 4,969 10,000 5,031 50% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 3,000 3,000 100% ------------------------------------------------- TOTAL HAZMA GRANT EXPENDITURES 6,733 18,000 11,267 63% ================================================= 2958 HAZMAT TEAM SUSTAINMENT G 2958-416-420455-240 OTHER SUPPLIES AND EQUIPMENT 23,879 101,061 77,182 76% ------------------------------------------------- TOTAL HAZMAT TEAM SUSTAINMENT 23,879 101,061 77,182 76% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 16 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC SAFETY - LAW ENFORCEMEN 2915 STONGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD 2,829 16,050 13,221 82% 2915-413-420140-218 SMALL EQUIP -Stonegarden 0 29,000 29,000 100% ------------------------------------------------- TOTAL STONEGARDEN GRANT 2,829 45,050 42,221 94% ================================================= 2916 DRUG ENFORCEMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 19,212 76,888 57,676 75% 2916-413-420140-121 OVERTIME 2,528 13,000 10,472 81% 2916-413-420140-153 HEALTH INSURANCE 3,338 19,621 16,283 83% 2916-413-420140-155 RETIREMENT 1,787 10,321 8,534 83% ------------------------------------------------- TOTAL DRUG ENFORCEMENT GRANT 26,866 119,830 92,964 78% ================================================= 2918 COPS HIRING RECOVERY PROG ------------------------------------------------- TOTAL COPS HIRING RECOVERY GRA 0 0 0 0% ================================================= 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 1,910 3,000 1,090 36% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 2,586 35,000 32,414 93% 2919-413-420140-127 SCHOOL DIST. OT 17,493 17,000 493- -3% 2919-413-420140-218 JAG GRT/BODY ARMOR & BODY WORN CAME 0 13,500 13,500 100% 2919-413-420140-219 EQUIPMENT FROM WALMART COMMUNITY GR 0 5,000 5,000 100% 2919-413-420140-220 EQUIPMENT-FUNDED BY DONATIONS 0 4,000 4,000 100% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 10,523 10,523 0 0% 2919-413-420140-223 ROUND UP FOR SAFETY SUPPLIES 0 4,632 4,632 100% 2919-413-420140-373 TRAINING - FORFEITURE FUNDS 1,184 1,000 184- -18% ------------------------------------------------- TOTAL LAW ENFORCEMENT GRANTS 33,696 93,655 59,959 64% ================================================= 4170 IMPOUND/STORAGE FACILITY ------------------------------------------------- TOTAL IMPOUND STORAGE FACILITY 0 0 0 0% ================================================= 2399 IMPACT FEE FUND 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 11,250 15,000 3,750 25% 2399-413-420140-940 POLICE EQUIPMENT 0 100,000 100,000 100% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 1,900,000 1,900,000 100% ------------------------------------------------- TOTAL PUBLIC SAFETY IMPACT FEE 11,250 2,015,000 2,003,750 99% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 17 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC WORKS 2500 SPECIAL STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 768,083 1,107,150 339,067 31% 2500-421-430240-121 OVERTIME 5,516 28,000 22,484 80% 2500-421-430240-153 HEALTH INSURANCE 123,700 198,072 74,372 38% 2500-421-430240-155 RETIREMENT 62,691 88,813 26,122 29% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 13,798 26,500 12,702 48% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 5,761 7,000 1,239 18% 2500-421-430240-220 OTHER SUPPLIES 1,533 5,000 3,467 69% 2500-421-430240-231 GAS & OIL 31,119 73,000 41,881 57% 2500-421-430240-341 ELECTRICITY 2,050 4,000 1,950 49% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 3,461 4,800 1,339 28% 2500-421-430240-353 AUDITING 2,420 1,920 500- -26% 2500-421-430240-354 CONTRACT SERVICES 10,235 25,000 14,765 59% 2500-421-430240-356 CONSULTANT REVIEWS 12,622 30,000 17,378 58% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 44,668 57,000 12,332 22% 2500-421-430240-366 BUILDING MAINTENANCE 1,168 5,000 3,832 77% 2500-421-430240-373 DUES & TRAINING 1,364 14,000 12,636 90% 2500-421-430240-388 MEDICAL SERVICES 460 1,000 540 54% 2500-421-430240-510 LIABILITY INSURANCE 46,228 46,229 1 0% 2500-421-430240-512 UNINSURED LOSS-DEDUCTIBLE 0 45,000 45,000 100% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 141,206 188,274 47,068 25% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 74,018 98,690 24,672 25% 2500-421-430240-528 INFORMATION TECHNOLOGY TRANSFER 36,866 49,305 12,439 25% 2500-421-430240-610 DEBT SERVICE - PRINCIPAL 41,328 41,328 0- 0% 2500-421-430240-620 DEBT SERVICE - INTEREST 11,648 12,245 597 5% 2500-421-430240-840 MACI GRANT MATCH - WTR/DE-ICER TRK 0 24,170 24,170 100% 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 13,633 27,729 14,096 51% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 5,788 11,406 5,618 49% 2500-421-430244-354 PAVEMENT REPAIRS-PAVEMENT MNT FUNDS 11,691 380,000 368,309 97% 2500-421-430244-820 TRANSFER TO BaRSAA 0 33,000 33,000 100% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 146,412 220,100 73,688 33% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 15,652 15,652 100% ------------------------------------------------- TOTAL STREET MAINT 1,619,467 2,869,383 1,249,916 44% ------------------------------------------------- TSS 2500-421-430264-110 TSS - SALARIES 90,950 124,698 33,748 27% 2500-421-430264-121 OVERTIME 0 7,500 7,500 100% 2500-421-430264-153 HEALTH INSURANCE 20,759 28,979 8,220 28% 2500-421-430264-155 RETIREMENT 7,344 9,946 2,602 26% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 1,814 5,960 4,146 70% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,361 8,000 6,639 83% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 702 4,500 3,798 84% 2500-421-430264-242 STREET SIGNS 27,131 30,000 2,869 10% 2500-421-430264-243 TRAFFIC SIGNALS 1,586 50,549 48,963 97% 2500-421-430264-245 BARRICADE MATERIALS 90 6,000 5,910 99% 2500-421-430264-341 ELECTRICITY 1,652 3,000 1,348 45% 2500-421-430264-345 COMMUNICATIONS 830 1,350 520 39% 2500-421-430264-354 CONTRACT SERVICES 3,564 10,000 6,436 64% 2500-421-430264-362 EQUIPMENT MAINTENANCE 1,505 3,000 1,495 50% 2500-421-430264-366 BUILDING MAINTENANCE 7,017 8,000 983 12% 2500-421-430264-373 DUES & TRAINING 1,742 7,500 5,758 77% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 18 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500-421-430264-428 PAINT MATERIALS 0 5,000 5,000 100% 2500-421-430264-510 LIABILITY INS.-TSS 3,803 3,850 47 1% 2500-421-430264-512 UNINSURED LOSS-DEDUCTIBLE 0 1,000 1,000 100% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 3,832 5,110 1,278 25% ------------------------------------------------- TOTAL TSS 175,684 323,942 148,258 46% ------------------------------------------------- TOTAL SPECIAL STREET 1,795,151 3,193,325 1,398,174 44% ================================================= 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 33,175 104,071 70,896 68% 2420-421-430234-957 ALLEY PAVING 56,074 73,540 17,466 24% 2420-421-430240-231 GAS & OIL 30,629 71,000 40,371 57% 2420-421-430240-344 NATURAL GAS 2,812 6,500 3,688 57% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 100% 2420-421-430240-360 REPAIR & MAINT SERVICES 0 1,500 1,500 100% 2420-421-430240-368 OVERLAY/CHIPSEALS 110,346 613,079 502,733 82% 2420-421-430240-452 GRAVEL 0 6,000 6,000 100% 2420-421-430240-453 EQUIPMENT RENTAL 0 7,500 7,500 100% 2420-421-430240-471 DE-ICER/ROAD OIL 48,281 83,000 34,719 42% 2420-421-430240-472 ASPHALT 10,154 50,000 39,846 80% 2420-421-430240-473 CRACK SEALING 13,365 20,000 6,635 33% 2420-421-430240-474 PAINT STRIPING MATERIALS 19,218 30,000 10,782 36% ------------------------------------------------- TOTAL GAS TAX 324,054 1,086,190 762,136 70% ================================================= BARSAA 2421-421-430240-354 PAVEMENT MAINTENANCE 1,148,505 1,825,506 677,001 37% ------------------------------------------------- TOTAL BARSAA 1,148,505 1,825,506 677,001 37% ================================================= 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 75,753 104,172 28,419 27% 2400-410-430263-153 HEALTH INSURANCE 16,143 25,949 9,806 38% 2400-410-430263-155 RETIREMENT 6,206 8,418 2,212 26% 2400-410-430263-244 STREET LIGHT SUPPLIES 2,110 18,000 15,890 88% 2400-410-430263-245 LUMINAIRES 0 31,000 31,000 100% 2400-410-430263-341 ELECTRICITY 119,010 182,000 62,990 35% 2400-410-430263-360 REPAIR & MAINT SERVICES 5,954 22,500 16,546 74% 2400-410-430263-373 DUES & TRAINING 1,029 4,000 2,971 74% 2400-410-430263-510 INSURANCE 2,171 2,171 0- -0% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 10,237 13,649 3,412 25% 2400-410-430263-528 INFORMATION TECH TRANSFER 19,331 25,824 6,493 25% 2400-410-430265-944 MACHINERY & EQUIP (replacement fund 79,824 88,000 8,176 9% ------------------------------------------------- TOTAL LIGHT MAINT. 337,768 525,683 187,915 36% ================================================= 2825 MACI GRANT-SWEEPER 2825-421-430240-940 EQUIPMENT 0 336,629 336,629 100% ------------------------------------------------- TOTAL MACI GRANT 0 336,629 336,629 100% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 19 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210 WATER FUND REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 7,465 2,000 5,465- -273% 5210-000-343028-000 REIMBURSABLE RECORD DRAWING DEPOSIT 833 0 833- 0% 5210-000-343210-000 METERED WATER SALES 4,721,577 4,718,000 3,577- -0% 5210-000-343220-000 OTHER (CONST.) WATER SALES 55,949 25,000 30,949- -124% 5210-000-343230-000 METER REPLACEMENT FEE 206,280 175,000 31,280- -18% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 27,958 71,000 43,042 61% 5210-000-343270-000 WATER TURN ON FEES 3,825 4,000 175 4% 5210-000-343275-000 TAG FEE 25,660 33,000 7,340 22% 5210-000-343365-000 LATECOMER ADMIN FEE 11,735 10,000 1,735- -17% 5210-000-371010-000 INVESTMENT EARNINGS 459,249 100,000 359,249- -359% 5210-000-371500-000 LEASE INTEREST INCOME 49,569 0 49,569- 0% 5210-000-383010-000 TRANSFER FROM IMPACT FEE FUND (ADMI 18,750 25,000 6,250 25% 5210-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 187,500 250,000 62,500 25% ------------------------------------------------- TOTAL REVENUE 5,776,351 5,413,000 363,351- -7% ================================================= EXPENSES WATER FACILITIES 5210-447-430550-110 SALARIES-WATER 598,551 988,404 389,853 39% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 13,231 20,000 6,769 34% 5210-447-430550-153 HEALTH INSURANCE 100,922 186,588 85,666 46% 5210-447-430550-155 RETIREMENT 55,302 79,471 24,169 30% 5210-447-430550-210 OFFICE SUPPLIES /EQUIP/COMPUTERS/GI 11,541 24,500 12,959 53% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 2,740 9,000 6,260 70% 5210-447-430550-226 CHLORINE & CHEMICALS 44,058 85,000 40,942 48% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 2,471 4,650 2,179 47% 5210-447-430550-231 GAS & OIL 23,298 40,000 16,702 42% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 104 1,000 896 90% 5210-447-430550-336 LICENSES & FEES 18,193 20,000 1,807 9% 5210-447-430550-341 ELECTRICITY 119,888 175,000 55,112 31% 5210-447-430550-344 NATURAL GAS 6,892 16,000 9,108 57% 5210-447-430550-345 TELEPHONE & COMMUNICATION 8,325 15,500 7,175 46% 5210-447-430550-349 LAB SERVICES 11,579 30,000 18,421 61% 5210-447-430550-352 CONTRACT SERVICES - HOSTING FEES 12,475 30,000 17,525 58% 5210-447-430550-353 AUDITING 9,243 4,200 5,043- -120% 5210-447-430550-354 CONTRACT SERVICES 11,257 56,000 44,743 80% 5210-447-430550-355 NOFFSINGER TRANSMISSION CONDITION A 68,911 68,854 57- -0% 5210-447-430550-356 WTR RIGHTS/ MODELING/ REVIEWS/ RATE 7,148 185,000 177,853 96% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 3,043 15,000 11,957 80% 5210-447-430550-366 BUILDING MAINTENANCE 1,209 15,000 13,791 92% 5210-447-430550-373 DUES & TRAINING 4,479 14,000 9,522 68% 5210-447-430550-388 MEDICAL SERVICES 240 700 460 66% 5210-447-430550-410 CONSTRUCTION MATERIALS 23,647 50,000 26,353 53% 5210-447-430550-422 HYDRANTS 10,749 10,000 749- -7% 5210-447-430550-423 MATERIALS FOR MAINS 4,465 16,000 11,535 72% 5210-447-430550-424 MATERIALS -SERVICE LINES 12,023 20,000 7,977 40% 5210-447-430550-425 MATERIALS PUMPS/WELLS (CARRY/NEW) 58,588 147,326 88,738 60% 5210-447-430550-510 PROPERTY & LIABILITY INS. 46,801 46,801 0 0% 5210-447-430550-512 UNINSURED LOSS-DEDUCTIBLE 1,000 10,000 9,000 90% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 34,629 46,173 11,544 25% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 20 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-522 ADMINISTRATIVE TRANSFER 102,647 136,863 34,216 25% 5210-447-430550-528 INFORMATION TECH TRANSFER 66,833 90,191 23,358 26% 5210-447-430550-532 LEASE PAYMENTS 0 4,000 4,000 100% ------------------------------------------------- TOTAL OPERATING EXPENSES 1,496,479 2,666,221 1,169,742 44% ------------------------------------------------- CAPITAL FROM OPERATING/BONDS 5210-447-430550-925 N MAIN WELL-NOFFSINGER REPLC (CARRY 836,339 2,151,456 1,315,117 61% 5210-447-430550-935 METER SYSTEM REPLACEMENT (CARRY/NEW 359,330 466,316 106,986 23% 5210-447-430550-940 MACHINERY & EQUIPMENT (CARRY/NEW) 292,952 380,000 87,048 23% 5210-447-430550-950 WATER MAIN REHAB & REPLACEMENT 0 25,000 25,000 100% 5210-447-430550-951 SECURITY SCADA UPGRADES 1,443 25,000 23,557 94% 5210-447-430550-952 8TH AVE W R&R (ARPA WTR/SWR PRJ) CA 23,042 350,000 326,958 93% 5210-447-430550-954 ELEVATED STORAGE TANK & WELL (CARRY 121,583 750,956 629,373 84% 5210-447-430550-967 WELL REPLC & UPSIZE (CARRY/NEW) 0 140,000 140,000 100% 5210-447-430550-968 BUFFALO HILL BOOSTER STATION UPGRAD 0 70,000 70,000 100% 5210-447-430550-969 DESIGN - LOWER ZONE RESERVOIRS ROOF 66,341 2,450,969 2,384,629 97% 5210-447-430550-970 DESIGN-NORTHWEST WELL #2 (CARRY) 0 307,000 307,000 100% ------------------------------------------------- TOTAL CAPITAL FROM OP/BONDS 1,701,029 7,116,697 5,415,668 76% ------------------------------------------------- CAPITAL OUTLAY - BONDED 5210-447-430551-954 1 MG STORAGE TANK & WELLS (BONDED)10,628,753 18,439,992 7,811,239 42% 5210-447-430551-969 LOWER ZONE RESERVOIRS ROOF REPLC (B 0 11,715,000 11,715,000 100% ------------------------------------------------- TOTAL CAPITAL BONDED 10,628,753 30,154,992 19,526,239 65% ------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES-WATER BILLING 106,000 152,289 46,289 30% 5210-447-430560-153 HEALTH INSURANCE 17,886 46,180 28,294 61% 5210-447-430560-155 RETIREMENT 8,833 12,549 3,716 30% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 3,689 10,500 6,811 65% 5210-447-430560-353 AUDITING 2,758 2,500 258- -10% 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 37,374 55,000 17,626 32% 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 29,263 38,000 8,737 23% 5210-447-430560-356 OTHER CONTRACT SERVICES 446 1,000 554 55% 5210-447-430560-373 DUES & TRAINING 1,105 4,000 2,895 72% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 9,895 13,194 3,299 25% 5210-447-430560-528 INFORMATION TECH TRANSFER 60,372 80,847 20,475 25% ------------------------------------------------- TOTAL WATER BILLING 277,622 416,059 138,437 33% ------------------------------------------------- REVENUE BONDS/BOI LOANS 5210-447-490200-610 PRIN - 4 MILE DR TRANSMISSION / WRF 0 91,000 91,000 100% 5210-447-490200-620 INT - 4 MILE DR TRANSMISSION / WRF 45,413 45,413 1 0% 5210-447-490204-610 BOND PRIN-HWY 93 S WTR - 2004 0 84,648 84,648 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 1,579 1,579 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 97,000 97,000 100% 5210-447-490206-620 INT-WELL&TANK/8114 2.25% 4TH ST WT 8,505 8,506 1 0% 5210-447-490210-610 4TH AVE E MAIN REPL/WRF 17393 0 89,029 89,029 100% 5210-447-490210-620 4TH AVE E MAIN REPL/WFR 17393 36,623 36,623 0 0% 5210-447-490250-610 PRIN-WTR STORAGE TANK/WELL WRF 2.5% 0 887,566 887,566 100% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 21 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-490250-620 INT-WTR STORAGE TANK/WELL WRF - 2.5 0 566,188 566,188 100% ------------------------------------------------- TOTAL REVENUE BONDS 92,119 1,907,902 1,815,783 95% ------------------------------------------------- DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 950,000 950,000 100% ------------------------------------------------- TOTAL DEPRECIATION 0 950,000 950,000 100% ------------------------------------------------- TOTAL WATER FUND 14,196,002 43,211,871 29,015,869 67% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 22 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING WATER IMPACT FEE REVENUE: 5211-000-343225-000 IMPACT FEES 300,140 500,000 199,860 40% 5211-000-371010-000 INTEREST EARNINGS 29,283 10,000 19,283- -193% ------------------------------------------------- TOTAL WATER IMPACT FEES REVENU 329,423 510,000 180,577 35% ================================================= WATER IMPACT FEES EXPENSES: 5211-447-430555-424 METERS - NEW DEVELOPMENT 73,552 73,552 0- 0% 5211-447-430555-820 DEBT SERVICE TRANSFER TO 5210 187,500 250,000 62,500 25% 5211-447-430555-825 TRANSFER TO 5210 FOR ADMIN 18,750 25,000 6,250 25% 5211-447-430555-930 CONTRACT MAIN UPSIZE 90,069 753,394 663,325 88% 5211-447-430555-954 ELEVATED TANK & WELL 85,666 85,666 0- 0% ------------------------------------------------- TOTAL IMPACT FEES 455,537 1,187,612 732,075 62% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 23 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310 SEWER FUND REVENUE 5310-000-323108-000 PW PLAN REVIEW FEES 7,465 1,500 5,965- -398% 5310-000-343028-000 REIMBURSABLE RECORD DRAWING DEPOSIT 833 0 833- 0% 5310-000-343310-000 SEWER SERVICE CHARGES 6,414,788 8,016,040 1,601,252 20% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 1,270 1,500 230 15% 5310-000-343365-000 LATECOMER ADMIN FEES 4,576 2,000 2,576- -129% 5310-000-371010-000 INVESTMENT EARNINGS 468,881 75,000 393,881- -525% 5310-000-383010-000 ADMIN TRANSFER FROM IMPACT FEE FUND 75,000 100,000 25,000 25% 5310-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 975,000 1,300,000 325,000 25% ------------------------------------------------- TOTAL REVENUE 7,947,813 9,496,040 1,548,227 16% ================================================= SEWER BILLING COSTS 5310-454-430620-110 SALARIES-SEWER BILLING 92,248 130,037 37,789 29% 5310-454-430620-153 HEALTH INSURANCE 15,179 24,109 8,930 37% 5310-454-430620-155 RETIREMENT - PERD 7,679 10,661 2,982 28% 5310-454-430620-215 OFFICE SUPPLIES/computers 3,689 10,500 6,811 65% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 2,758 2,500 258- -10% 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 37,374 55,000 17,626 32% 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 29,263 38,000 8,737 23% 5310-454-430620-356 OTHER CONTRACT SERVICES 446 1,000 554 55% 5310-454-430620-373 DUES & TRAINING 453 4,000 3,547 89% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 9,357 12,476 3,119 25% 5310-454-430620-528 INFORMATION TECH. TRANSFER 60,372 80,847 20,475 25% ------------------------------------------------- TOTAL SEWER BILLING COSTS 258,818 369,130 110,312 30% ------------------------------------------------- SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES-SANITARY SEWER 294,926 416,234 121,308 29% 5310-454-430630-121 OVERTIME 1,072 5,500 4,428 81% 5310-454-430630-153 HEALTH INSURANCE 46,650 81,817 35,167 43% 5310-454-430630-155 RETIREMENT 24,110 33,581 9,471 28% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 8,073 15,800 7,727 49% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 2,268 8,500 6,232 73% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 1,750 2,500 750 30% 5310-454-430630-231 GAS & OIL 7,540 19,000 11,460 60% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 0 500 500 100% 5310-454-430630-341 ELECTRICITY 34,759 57,000 22,241 39% 5310-454-430630-344 NATURAL GAS 10,429 18,000 7,571 42% 5310-454-430630-345 TELEPHONE & COMMUNICATION 17,111 27,500 10,389 38% 5310-454-430630-353 AUDITING 7,987 3,600 4,387- -122% 5310-454-430630-354 CONTRACT SERVICES 11,040 45,000 33,960 75% 5310-454-430630-355 CONTRACT SERVICES - EVERGREEN MTR R 24,075 36,000 11,925 33% 5310-454-430630-356 CONSULTANTS - MODELING/REVIEWS 4,056 20,000 15,944 80% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 794 11,500 10,707 93% 5310-454-430630-373 DUES & TRAINING 2,094 10,250 8,156 80% 5310-454-430630-388 MEDICAL SERVICES 60 1,000 940 94% 5310-454-430630-410 CONSTRUCTION MATERIALS 3,609 12,000 8,391 70% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 49,615 105,000 55,385 53% 5310-454-430630-510 PROPERTY & LIABILITY INS. 27,941 27,928 13- -0% 5310-454-430630-512 UNINSURED LOSS-DEDUCTIBLE 3,726 25,000 21,274 85% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 11,555 15,406 3,851 25% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 57,250 76,333 19,083 25% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 24 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-528 INFORMATION TECH TRANSFER 40,459 54,095 13,636 25% 5310-454-430630-532 OFFICE RENT / BNSF LEASE 7,309 7,000 309- -4% ------------------------------------------------- TOTAL COLLECTION OPERATING EX 700,258 1,136,044 435,786 38% ------------------------------------------------- CAPITAL FROM OPERATING/BONDS 5310-454-430630-922 L.S. #9 IMPROVEMENTS/DESIGN (CARRYO 11,000 205,670 194,670 95% 5310-454-430630-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 224,983 224,983 100% 5310-454-430630-951 5TH ALLEY E, 4TH AVE EN, 7TH AVE EN 571,354 748,250 176,896 24% 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 0 10,000 10,000 100% 5310-454-430630-958 DESIGN - L.S. #3 IMPROVEMENTS 22,487 336,087 313,600 93% 5310-454-430630-959 L.S. #10 CONTROL PANEL RELOCATION & 5,694 12,898 7,204 56% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 17,018 50,000 32,983 66% 5310-454-430630-961 LIFT STATION #36 IMPROVEMENTS & CON 0 1,460,723 1,460,723 100% ------------------------------------------------- TOTAL CAP. FROM OP/BONDS 627,553 3,048,611 2,421,058 79% ------------------------------------------------- CAPITAL FROM BONDS 5310-454-430631-922 L.S. #9 IMPROVMENTS 191,878 1,012,880 821,002 81% 5310-454-430631-958 L.S. #3 IMPROVEMENTS 1,500,000 3,020,000 1,520,000 50% ------------------------------------------------- TOTAL CAPITAL FROM BONDS 1,691,878 4,032,880 2,341,002 58% ------------------------------------------------- CAPITAL FROM EQUIP REPLACEMENT ------------------------------------------------- TOTAL CAP. FROM EQUIP. REPLACE 0 0 0 0% ------------------------------------------------- REVENUE BONDS/SANITARY 5310-454-490200-610 PRINCIPAL WESTSIDE INTERCEPTOR BOND 0 310,000 310,000 100% 5310-454-490200-620 INTEREST-WESTSIDE INTERCEPTOR BOND 264,163 264,163 1 0% 5310-454-490202-610 PRINCIPAL- LIFT STATION #3 BOND 0 61,255 61,255 100% 5310-454-490202-620 INTEREST - LIFT STATION #3 BOND 0 39,425 39,425 100% 5310-454-490204-610 PRINCIPAL - HWY 93 S/SRF5125/2.25% 0 94,000 94,000 100% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 1,586 1,587 1 0% 5310-454-490206-610 PRINCIPAL LIFT STATION #9 BOND 0 69,377 69,377 100% 5310-454-490206-620 INTEREST LIFT STATION #9 BOND 0 43,944 43,944 100% ------------------------------------------------- TOTAL REVENUE BONDS 265,749 883,751 618,002 70% ------------------------------------------------- DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 900,000 900,000 100% ------------------------------------------------- TOTAL DEPRECIATION-SANITARY 0 900,000 900,000 100% ------------------------------------------------- TOTAL SANITARY SEWER 3,544,256 10,370,416 6,826,160 66% ------------------------------------------------- WWTP OPERATING 5310-455-430640-110 SALARIES-WWTP 411,102 634,593 223,491 35% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-121 OVERTIME 19,231 22,500 3,269 15% 5310-455-430640-153 HEALTH INSURANCE 63,562 113,292 49,730 44% 5310-455-430640-155 RETIREMENT 35,760 50,951 15,191 30% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 5,464 14,800 9,336 63% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 2,734 3,500 766 22% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 25 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-225 ALUM 0 56,500 56,500 100% 5310-455-430640-226 CHLORINE & CHEMICALS 126,046 186,000 59,954 32% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 7,461 8,000 539 7% 5310-455-430640-231 GAS & OIL 12,967 33,000 20,033 61% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 0 550 550 100% 5310-455-430640-336 DEQ PERMITS, LICENSES & FEES 2,129 16,000 13,871 87% 5310-455-430640-341 ELECTRICITY 133,461 207,500 74,039 36% 5310-455-430640-342 WATER 5,676 7,000 1,324 19% 5310-455-430640-344 NATURAL GAS 23,616 82,000 58,384 71% 5310-455-430640-345 TELEPHONE & COMMUNICATION 9,605 15,000 5,395 36% 5310-455-430640-353 AUDITING 3,309 3,000 309- -10% 5310-455-430640-354 CONTRACT-GLACIER GOLD 88,499 135,000 46,501 34% 5310-455-430640-355 CONTRACT - LAND FILL & OTHER 39,383 60,000 20,617 34% 5310-455-430640-356 CONSULTANTS 7,618 220,000 212,382 97% 5310-455-430640-358 CONSULTANT- PERMIT/TMDL 40,227 100,000 59,773 60% 5310-455-430640-360 MISC. MAINT SERVICES 31,134 35,000 3,866 11% 5310-455-430640-366 BUILDING MAINTENANCE 24,795 42,000 17,205 41% 5310-455-430640-373 DUES & TRAINING 3,435 10,500 7,065 67% 5310-455-430640-388 MEDICAL SERVICES 240 500 260 52% 5310-455-430640-510 PROPERTY & LIABILITY INS. 90,804 90,804 0- 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 16,722 22,296 5,574 25% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 102,077 136,103 34,026 25% 5310-455-430640-528 INFORMATION TECH TRANSFER 43,123 57,748 14,625 25% ------------------------------------------------- TOTAL WWTP OPERATING EXPENSE 1,350,180 2,369,137 1,018,957 43% ------------------------------------------------- WWTP CAPITAL FM OPERATING/BOND 5310-455-430640-921 DESIGN-DOME FOR SECONDARY CLARIFIER 0 419,000 419,000 100% 5310-455-430640-922 CONSTRUCT NEW FERMENTER (rehab) 0 1,675,500 1,675,500 100% 5310-455-430640-930 BIOSOLIDS ALTERNATE DISPOSAL ENG 0 61,000 61,000 100% 5310-455-430640-933 NEW EQ BASIN 0 2,515,000 2,515,000 100% ------------------------------------------------- TOTAL WWTP CAP. FM OP/BOND 0 4,670,500 4,670,500 100% ------------------------------------------------- WWTP LAB 5310-455-430646-110 SALARIES-WWTP LAB 107,293 151,668 44,375 29% 5310-455-430646-121 OVERTIME 43 0 43- 0% 5310-455-430646-153 HEALTH INSURANCE 12,495 19,714 7,219 37% 5310-455-430646-155 RETIREMENT 8,910 12,085 3,175 26% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 1,397 7,000 5,603 80% 5310-455-430646-218 NON-CAPITAL EQUIPMENT 4,558 5,000 442 9% 5310-455-430646-222 LAB SUPPLIES 11,710 18,500 6,790 37% 5310-455-430646-349 LAB SERVICES 12,139 22,000 9,861 45% 5310-455-430646-350 PRETREATMENT SERVICE 9,077 15,000 5,923 39% 5310-455-430646-362 EQUIPMENT MAINTENANCE 9,202 10,500 1,298 12% 5310-455-430646-373 DUES & TRAINING 1,350 5,500 4,150 75% 5310-455-430646-940 MACHINERY & EQUIPMENT 8,690 8,700 10 0% ------------------------------------------------- TOTAL WWTP LAB 186,863 275,667 88,804 32% ------------------------------------------------- WWTP REPLACE(10125) 5310-455-430645-362 EQUIPMENT MAINTENANCE 88,621 187,000 98,379 53% 5310-455-430645-922 FERMENTER RECONSTRUCTION (CARRY) 24,555 216,461 191,906 89% 5310-455-430645-940 MACHINERY & EQUIPMENT (CARRYOVER & 14,147 115,000 100,853 88% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 26 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430645-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 337,475 337,475 100% ------------------------------------------------- TOTAL WWTP REPLACEMENT 127,323 855,936 728,613 85% ------------------------------------------------- REVENUE BONDS/WWTP 5310-455-490215-610 PRINCIPAL - EQ BASIN / FERMENTER SR 0 84,473 84,473 100% 5310-455-490215-620 INTEREST - EQ BASIN / FERMENTER SRF 0 54,369 54,369 100% 5310-455-490227-610 PRINCIPAL - WWTP IMP/SRF8164R/2.25% 0 931,000 931,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 81,461 81,461 0- 0% 5310-455-490228-610 PRINC - WWTP DIGESTER LID/SRF 13326 0 55,000 55,000 100% 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 18,375 18,375 0 0% ------------------------------------------------- TOTAL REVENUE BONDS/WWTP 99,836 1,224,678 1,124,842 92% ------------------------------------------------- DEPRECIATION 5310-455-510400-831 DEPR. EXP. - WWTP (INCLUDES 010125 0 1,300,000 1,300,000 100% ------------------------------------------------- TOTAL DEPRECIATION 0 1,300,000 1,300,000 100% ------------------------------------------------- TOTAL WWTP 1,764,203 10,695,918 8,931,715 84% ------------------------------------------------- TOTAL BILLING/SANITARY/WWTP 5,308,459 21,066,334 15,757,875 75% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 27 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER IMPACT FEE REVENUE 5311-000-343330-000 SANITARY IMPACT FEES 380,273 787,500 407,227 52% 5311-000-343335-000 TREATMENT IMPACT FEES 259,268 483,000 223,732 46% 5311-000-371010-000 SANITARY INTEREST EARNINGS 126,413 15,000 111,413- -743% 5311-000-371015-000 TREATMENT INTEREST EARNINGS 85,340 11,000 74,340- -676% ------------------------------------------------- TOTAL SEWER IMPACT FEES REVENU 851,294 1,296,500 445,206 34% ================================================= COLLECTION IMP. FEE EXPENSES 5311-454-430635-820 TRANSFER TO 5310 FOR DEBT (SANITARY 487,500 650,000 162,500 25% 5311-454-430635-825 TRANSFER TO 5310 FOR ADMIN 48,750 65,000 16,250 25% ------------------------------------------------- TOTAL COLL. IMP. FEES TRANSFER 536,250 715,000 178,750 25% ------------------------------------------------- CAPITAL FROM COLL. IMP. FEES 5311-454-430635-950 RR & UPSIZE - WWTP MAIN (66% - 34% 0 350,983 350,983 100% 5311-454-430635-955 MAIN & L.S. UPSIZE 137,179 1,493,812 1,356,633 91% 5311-454-430635-958 DESIGN-L.S #3 IMPROVEMENTS 22,487 264,677 242,190 92% 5311-454-430635-961 LIFT STATION #36 IMPROVEMENTS & CON 0 1,460,723 1,460,723 100% ------------------------------------------------- TOTAL CAP. FM COLL. IMP. FEES 159,666 3,570,195 3,410,529 96% ------------------------------------------------- TOTAL COLL. IMP. FEE EXPENSE 695,916 4,285,195 3,589,279 84% ------------------------------------------------- TREATMENT IMP. FEE EXPENSES 5311-455-430644-820 TRANSFER TO 5310 FOR DEBT 487,500 650,000 162,500 25% 5311-455-430644-825 TRANSFER TO 5310 FOR ADMIN 26,250 35,000 8,750 25% ------------------------------------------------- TOTAL TREATMT IMP. FEES TRANSF 513,750 685,000 171,250 25% ------------------------------------------------- CAPITAL FROM TREATMT IMP. FEES 5311-455-430644-929 CONSTRUCT NEW EQ BASIN 47,733 216,453 168,720 78% 5311-455-430644-930 BIOSOLIDS ALT. DISPOSAL ENG. (39%) 0 39,000 39,000 100% 5311-455-430644-950 RR & UPSIZE - WWTP MAIN (66% - 34% 0 613,464 613,464 100% ------------------------------------------------- TOTAL CAP FM TRTMNT IMP. FEES 47,733 868,917 821,184 95% ------------------------------------------------- TOTAL WWTP IMPACT FEES EXPENSE 561,483 1,553,917 992,434 64% ------------------------------------------------- TOTAL SEWER IMPACT FEE EXPENSE 1,257,399 5,839,112 4,581,713 78% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 28 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5349 STORM SEWER FUND REVENUE 5349-000-323108-000 PW PLAN REVIEW FEES 7,465 1,500 5,965- -398% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 0 1,000 1,000 100% 5349-000-343028-000 REIMBURSABLE RECORD DRAWINGS DEPOSI 833 0 833- 0% 5349-000-343034-000 PERMIT FEES 1,135 1,500 365 24% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 2,047,385 2,010,000 37,385- -2% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 3,966 2,500 1,466- -59% 5349-000-371010-000 INTEREST ON INVESTMENTS 163,905 25,000 138,905- -556% 5349-000-383010-000 IMPACT FEE 5% ADMIN - TFR FROM IMPA 7,500 10,000 2,500 25% 5349-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 105,000 140,000 35,000 25% ------------------------------------------------- TOTAL REVENUE 2,337,190 2,191,500 145,690- -7% ================================================= STORM OPERATING EXPENSES 5349-453-430246-110 SALARIES-STORM SEWER 397,701 619,004 221,303 36% 5349-453-430246-121 OVERTIME 1,194 4,000 2,806 70% 5349-453-430246-153 HEALTH INSURANCE 60,563 115,145 54,582 47% 5349-453-430246-155 RETIREMENT 32,652 49,787 17,135 34% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 11,191 18,500 7,309 40% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 1,108 6,000 4,892 82% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 43 2,200 2,157 98% 5349-453-430246-231 GAS & OIL 7,456 18,500 11,044 60% 5349-453-430246-345 TELEPHONE & COMMUNICATION 1,707 3,250 1,543 47% 5349-453-430246-353 AUDITING 2,027 1,380 647- -47% 5349-453-430246-354 CONTRACT SERVICE 4,372 10,000 5,628 56% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 2,299 35,000 32,701 93% 5349-453-430246-358 CONSULTANTS 112,766 350,000 237,234 68% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 8,134 30,000 21,866 73% 5349-453-430246-360 REPAIR & MAINT SERVICES 0 5,000 5,000 100% 5349-453-430246-362 GROUNDWATER MONITORING 0 6,500 6,500 100% 5349-453-430246-371 CURB & GUTTER 7,145 21,000 13,855 66% 5349-453-430246-373 DUES & TRAINING 604 10,250 9,646 94% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 0 12,000 12,000 100% 5349-453-430246-510 PROPERTY & LIABILITY INS. 15,554 15,554 0- 0% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 11,555 15,406 3,851 25% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 43,349 57,799 14,450 25% 5349-453-430246-528 INFORMATION TECH TRANSFER 36,938 49,790 12,852 26% 5349-453-430246-530 BNSF LEASE PMT 2,350 5,500 3,150 57% ------------------------------------------------- TOTAL STORM OPERATING EXPENSE 760,709 1,461,665 700,956 48% ------------------------------------------------- CAPITAL FROM OPERATING/BONDS 5349-453-430246-972 MERIDIAN BASIN DRAINAGE UPGRADES DE 0 100,000 100,000 100% ------------------------------------------------- TOTAL CAP. FROM OPERATING/BOND 0 100,000 100,000 100% ------------------------------------------------- CAPITAL FROM DES. CAP. PROJECT 5349-453-430247-952 STORM DRAIN CORRECTION (NEW & C/O) 301,124 750,000 448,876 60% 5349-453-430247-954 N. MAIN ST STORMWATER PROJ. 0 252,500 252,500 100% 5349-453-430247-956 WYOMING STREET OUTFALL 157,258 225,000 67,742 30% 5349-453-430247-957 WEDGEWOOD & SHERWOOD DESIGN/SURVEY 0 50,000 50,000 100% 5349-453-430247-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% 5349-453-430247-969 1ST AVE W - S. OF CITY SHOPS 175,203 364,602 189,399 52% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 29 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5349-453-430247-971 MERIDIAN CT DRAINAGE IMPROVEMENTS 0 191,000 191,000 100% ------------------------------------------------- TOTAL CAP. FROM DES. CAP. PROJ 633,585 1,883,102 1,249,517 66% ------------------------------------------------- CAPITAL/OTHER FROM REPLACEMENT ------------------------------------------------- TOTAL CAPITAL/OTHER FROM REPLA 0 0 0 0% ------------------------------------------------- REVENUE BONDS 5349-453-490200-610 PRINCIPAL - 4TH AVE E BOND 0 3,242 3,242 100% 5349-453-490200-620 INTEREST-4TH AVE E BOND 1,334 1,334 0 0% 5349-453-490225-610 PRINCIPAL - REGIONAL FACILITIES 0 88,000 88,000 100% 5349-453-490225-620 INTEREST - REGIONAL FACILITIES 48,850 48,850 0 0% ------------------------------------------------- TOTAL REVENUE BONDS 50,184 141,426 91,242 65% ------------------------------------------------- DEPRECIATION 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 400,000 400,000 100% ------------------------------------------------- TOTAL DEPRECIATION 0 400,000 400,000 100% ------------------------------------------------- TOTAL STORM EXPENSE 1,444,477 3,986,193 2,541,716 64% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 30 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM SEWER IMPACT FEE REVENUE 5348-000-343033-000 IMPACT FEES 133,952 157,500 23,549 15% 5348-000-371010-000 INTEREST EARNINGS 57,253 10,000 47,253- -473% ------------------------------------------------- TOTAL STORM IMPACT FEES REVENU 191,204 167,500 23,704- -14% ================================================= STORM SWR IMPACT FEE EXPENSES 5348-453-430248-820 DEBT SERVICE TRANSFER TO 5349 105,000 140,000 35,000 25% 5348-453-430248-825 TRANSFER TO 5349 FOR ADMIN 7,500 10,000 2,500 25% ------------------------------------------------- TOTAL IMPACT FEE TRANSFERS 112,500 150,000 37,500 25% ------------------------------------------------- CAPITAL FROM IMPACT FEES 5348-453-430248-960 STORMWATER FACILITY UPSIZING (CARRY 0 230,000 230,000 100% 5348-453-430248-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 150,000 150,000 100% ------------------------------------------------- TOTAL CAPITAL FROM IMPACT FEES 0 380,000 380,000 100% ------------------------------------------------- TOTAL STORM IMPACT FEE EXPENSE 112,500 530,000 417,500 79% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 31 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5510 SOLID WASTE REVENUE 5510-000-343410-000 GARBAGE COLLECTION-ASSESSED 1,424,644 1,342,000 82,644- -6% 5510-000-343420-000 GARBAGE COLLECTION-NOT ASSESSED 44,308 30,000 14,308- -48% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 2,605 2,000 605- -30% 5510-000-371010-000 INVESTMENT EARNINGS 34,494 15,000 19,494- -130% ------------------------------------------------- TOTAL REVENUE 1,506,052 1,389,000 117,052- -8% ================================================= EXPENSES 5510-460-430840-110 SALARIES-SOLID WASTE 402,317 569,256 166,939 29% 5510-460-430840-121 OVERTIME 4,784 8,000 3,216 40% 5510-460-430840-153 HEALTH INSURANCE 76,595 110,316 33,721 31% 5510-460-430840-155 RETIREMENT 32,993 45,597 12,604 28% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 9,720 16,500 6,780 41% 5510-460-430840-218 EQUIPMENT-GARBAGE CONTAINERS 50,108 71,200 21,092 30% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 4,178 5,500 1,322 24% 5510-460-430840-231 GAS & OIL 61,495 116,000 54,505 47% 5510-460-430840-341 ELECTRICITY 1,170 2,050 880 43% 5510-460-430840-344 NATURAL GAS 1,936 4,500 2,564 57% 5510-460-430840-345 TELEPHONE & COMMUNICATION 1,581 3,500 1,919 55% 5510-460-430840-354 CONTRACT SERVICES 74,441 157,000 82,559 53% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 14,757 55,000 40,243 73% 5510-460-430840-366 BUILDING MAINTENANCE 0 5,000 5,000 100% 5510-460-430840-373 DUES & TRAINING 3,035 10,000 6,965 70% 5510-460-430840-388 MEDICAL SERVICES 150 900 750 83% 5510-460-430840-510 PROPERTY & LIABILITY INS. 28,110 28,110 0 0% 5510-460-430840-512 UNINSURED LOSS-DEDUCTIBLE 13,923 4,000 9,923- -248% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 81,789 109,052 27,263 25% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 36,993 49,324 12,331 25% 5510-460-430840-528 INFORMATION TECH TRANSFER 36,866 49,695 12,829 26% 5510-460-430840-610 PRINCIPAL - GARBAGE TRUCK 0 45,000 45,000 100% 5510-460-430840-620 INTEREST - GARBAGE TRUCK 0 12,938 12,938 100% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 30,000 40,000 10,000 25% 5510-460-430840-944 VEHICLES (Replacement $) 914,356 914,356 0 0% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% ------------------------------------------------- TOTAL SOLID WASTE 1,881,297 2,582,794 701,497 27% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 32 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 4290 WALK & CURB CONSTRUCTION 4290-410-430234-937 CONSTRUCTION 1,309 25,000 23,691 95% ------------------------------------------------- TOTAL WALK & CURB CONSTRUCTION 1,309 25,000 23,691 95% ================================================= 4393 AMERICAN RESCUE PLAN PROJ 4393-410-430550-950 LRF PROJECT - L.S. #3 RECOVERY ACT 882,290 4,720,305 3,838,015 81% 4393-410-430550-951 DOWNTOWN WTR/SWR MAIN ARPA PROJECT 712,743 712,742 1- 0% ------------------------------------------------- TOTAL AMERICAN RESCUE PLAN PRO 1,595,033 5,433,047 3,838,014 71% ================================================= 5720 WATER/SEWER ARPA PROJECT 5720-410-430550-922 WWTP - FERMENTER REHAB 0 1,000,000 1,000,000 100% 5720-410-430550-925 WATER - NOFFSINGER WATER SOURCE 913,441 913,441 0 0% 5720-410-430550-950 WWTP - INF. PIPE/DIV. STRUCTURE 165,988 347,957 181,969 52% 5720-410-430550-951 DOWNTOWN WTR/SWR MAIN ARPA PROJECT 3,629,532 3,629,532 0- 0% 5720-410-430550-956 STORMWATER-MAIN & WYOMING ARPA PROJ 263,216 263,216 0 0% 5720-410-430550-969 STORMWATER-ASHLEY CR. DRAINAGE 281,151 281,151 0 0% ------------------------------------------------- TOTAL WTR/SWR ARPA GRANT 5,253,328 6,435,297 1,181,969 18% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 33 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-410-431330-110 SALARIES 153,097 212,006 58,909 28% 6010-410-431330-121 OVERTIME 0 2,500 2,500 100% 6010-410-431330-153 HEALTH INSURANCE 27,820 43,204 15,384 36% 6010-410-431330-155 RETIREMENT 11,926 16,571 4,645 28% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 11,017 19,500 8,483 44% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 6,269 10,700 4,431 41% 6010-410-431330-230 OIL 11,039 26,500 15,461 58% 6010-410-431330-231 GAS 767 1,900 1,133 60% 6010-410-431330-232 VEHICLE PARTS 125,549 160,000 34,451 22% 6010-410-431330-233 TIRES 41,025 60,500 19,475 32% 6010-410-431330-238 FILTERS 5,220 10,500 5,280 50% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 1,389 2,100 711 34% 6010-410-431330-341 ELECTRICITY 2,373 5,900 3,527 60% 6010-410-431330-342 WATER 559 2,000 1,441 72% 6010-410-431330-344 NATURAL GAS 6,645 12,500 5,855 47% 6010-410-431330-354 CONTRACT SERVICES 29,227 40,000 10,773 27% 6010-410-431330-360 WASH BAY REPAIRS & MAINTENANCE 503 6,000 5,497 92% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 4,101 10,000 5,899 59% 6010-410-431330-373 DUES & TRAINING 1,186 12,000 10,814 90% 6010-410-431330-388 MEDICAL SERVICES 60 500 440 88% 6010-410-431330-510 INSURANCE 5,402 5,402 1 0% 6010-410-431330-528 INFORMATION TECH TRANSFER 17,535 23,480 5,945 25% 6010-410-431330-944 MACHINERY & EQUIPMENT 12,232 14,650 2,418 17% ------------------------------------------------- TOTAL CENTRAL GARAGE 474,944 698,413 223,469 32% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 34 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PARKS & RECREATION REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 785,492 1,400,000 614,508 44% 2215-000-311200-000 PERSONAL PROPERTY TAXES 19,542 24,675 5,133 21% 2215-000-312000-000 PEN & INTEREST DEL TAXES 1,902 1,500 402- -27% 2215-000-334000-000 GRANT - POOL IMPROVEMENTS 0 86,000 86,000 100% 2215-000-346030-000 SWIMMING POOL FEES 74,432 175,000 100,568 57% 2215-000-346040-000 CONCESSION STAND REVENUE 30,721 50,000 19,279 39% 2215-000-346050-000 PARKS USAGE FEES 22,780 24,000 1,220 5% 2215-000-346051-000 RECREATION FEES 17,933 47,444 29,511 62% 2215-000-346052-000 SPORTS PROGRAMS 105,857 108,882 3,025 3% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 2,830 3,200 370 12% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 82,523 103,500 20,977 20% 2215-000-346055-000 ICE RINK 17,543 23,000 5,457 24% 2215-000-346056-000 KIDSPORT USAGE 0 1,800 1,800 100% 2215-000-346057-000 YOUTH CAMPS 25,013 259,712 234,699 90% 2215-000-346059-000 PICNIC IN THE PARK 19,858 26,500 6,642 25% 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 494 0 494- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-371010-000 INVESTMENTS 36,114 15,000 21,114- -141% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 57,500 115,000 57,500 50% ------------------------------------------------- TOTAL PARKS & REC REVENUE 1,300,535 2,485,213 1,184,678 48% ================================================= EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES-PARKS 307,024 446,804 139,780 31% 2215-436-460430-111 SEASONAL SALARIES 27,307 69,137 41,830 61% 2215-436-460430-121 OVERTIME 86 300 214 71% 2215-436-460430-153 HEALTH INSURANCE 45,196 71,991 26,795 37% 2215-436-460430-155 RETIREMENT 28,536 36,569 8,034 22% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 2,167 3,700 1,533 41% 2215-436-460430-215 EQUIPMENT - not capital 17,643 29,000 11,357 39% 2215-436-460430-224 JANITORIAL SUPPLIES 4,652 7,200 2,548 35% 2215-436-460430-229 OTHER SUPPLIES 4,904 10,000 5,096 51% 2215-436-460430-231 GAS 13,540 30,000 16,460 55% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 1,308 3,000 1,692 56% 2215-436-460430-320 PRINTING & ADVERTISING 198 200 2 1% 2215-436-460430-341 ELECTRICITY 8,564 13,500 4,936 37% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 17,233 23,000 5,767 25% 2215-436-460430-344 NATURAL GAS 1,414 2,950 1,536 52% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 1,317 2,700 1,383 51% 2215-436-460430-351 SPORTS COURT & SPORT MAINTENANCE 0 7,550 7,550 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 418 2,500 2,082 83% 2215-436-460430-355 CONTRACT SERV. TRAIL MAINT/WEED CON 6,271 15,000 8,729 58% 2215-436-460430-356 CONSULTANTS - PRELIMINARY DESIGN HW 21,006 50,000 28,995 58% 2215-436-460430-357 CONSULTANTS - PARKS MASTER PLAN 0 100,000 100,000 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 1,026 8,500 7,474 88% 2215-436-460430-364 LANDSCAPE MATERIALS, PERENNIALS & R 794 6,000 5,206 87% 2215-436-460430-367 VANDALISM REPAIRS 1,910 4,500 2,590 58% 2215-436-460430-373 DUES & TRAINING 4,354 9,000 4,646 52% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 180 600 420 70% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 35 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-395 EQUIPMENT RENTAL 40 700 660 94% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 2,520 6,500 3,980 61% 2215-436-460430-440 IRRIGATION SUPPLIES 1,570 6,000 4,430 74% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 570 2,000 1,430 72% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 26,539 35,386 8,847 25% 2215-436-460430-545 COUNTY LANDFILL 3,735 6,273 2,538 40% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 24,313 24,841 528 2% 2215-436-460430-620 DEBT SERVICE INTEREST 3,233 2,202 1,031- -47% 2215-436-460430-910 LAND 0 50,000 50,000 100% ------------------------------------------------- SUBTOTAL PARKS EXPENDITURES 579,566 1,087,603 508,037 47% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES-COMPLEX 97,349 140,811 43,462 31% 2215-436-460440-111 SEASONAL SALARIES 31,159 61,926 30,767 50% 2215-436-460440-121 OVERTIME 0 300 300 100% 2215-436-460440-153 HEALTH INSURANCE 19,008 30,358 11,350 37% 2215-436-460440-155 RETIREMENT 10,197 11,272 1,075 10% 2215-436-460440-221 SAFETY EQUIPMENT 67 300 233 78% 2215-436-460440-229 OTHER SUPPLIES 15,076 22,000 6,924 31% 2215-436-460440-231 GAS 6,853 13,000 6,147 47% 2215-436-460440-241 CONSUMABLE TOOLS 515 850 335 39% 2215-436-460440-341 ELECTRICITY 6,289 12,000 5,711 48% 2215-436-460440-345 TELEPHONE & COMMUNICATION 0 260 260 100% 2215-436-460440-354 CONTRACT SERVICES 0 1,500 1,500 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 21 1,500 1,479 99% 2215-436-460440-364 LANDSCAPING 62 300 238 79% 2215-436-460440-367 VANDALISM REPAIRS 0 600 600 100% 2215-436-460440-373 DUES & TRAINING 1,265 2,000 735 37% 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 120 300 180 60% 2215-436-460440-395 RENTAL EQUIPMENT 0 200 200 100% 2215-436-460440-420 METAL PRODUCTS 88 7,500 7,412 99% 2215-436-460440-440 IRRIGATION 5,644 7,000 1,356 19% 2215-436-460440-452 SAND & GRAVEL 279 1,500 1,221 81% 2215-436-460440-521 CENTRAL GARAGE TRANSFER 6,161 8,215 2,054 25% 2215-436-460440-545 COUNTY LANDFILL 3,470 3,500 30 1% 2215-436-460440-610 DEBT SERVICE - PRINCIPAL 1,061 10,000 8,939 89% 2215-436-460440-620 DEB SERVICE - INTEREST 491 2,875 2,384 83% ------------------------------------------------- SUBTOTAL ATHLETIC COMPLEX 205,174 340,067 134,893 40% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES-RECREATION 79,477 111,244 31,768 29% 2215-436-460431-111 SEASONAL SALARIES 11,063 38,792 27,729 71% 2215-436-460431-153 HEALTH INSURANCE 9,907 21,604 11,697 54% 2215-436-460431-155 RETIREMENT 6,623 9,136 2,513 28% 2215-436-460431-229 MISC. SUPPLIES 14,593 19,550 4,957 25% 2215-436-460431-231 GAS 408 676 268 40% 2215-436-460431-320 PRINTING & ADVERTISING 880 7,850 6,970 89% 2215-436-460431-345 TELEPHONE & COMMUNICATION 1,148 855 293- -34% 2215-436-460431-353 ONLINE REGISTRATION 3,752 3,869 117 3% 2215-436-460431-354 CONTRACT SERVICES 34,514 43,099 8,585 20% 2215-436-460431-355 BANK FEES/CREDIT CARD CHARGES 770 3,309 2,539 77% 2215-436-460431-357 MUSIC FRANCHISE FEES 1,407 1,400 7- -0% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 36 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460431-373 DUES & TRAINING 668 1,500 833 56% ------------------------------------------------- SUBTOTAL RECREATION 165,208 262,884 97,676 37% YOUTH CAMPS 2215-436-460448-110 SALARIES-YOUTH CAMPS 69,238 97,681 28,444 29% 2215-436-460448-111 SEASONAL SALARIES 155,767 240,979 85,212 35% 2215-436-460448-121 OVERTIME 233 150 83- -56% 2215-436-460448-153 HEALTH INSURANCE 9,288 20,168 10,880 54% 2215-436-460448-155 RETIREMENT 5,771 8,025 2,254 28% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 40 300 260 87% 2215-436-460448-229 MISC. SUPPLIES 1,252 5,025 3,773 75% 2215-436-460448-231 GAS 0 532 532 100% 2215-436-460448-320 PRINTING & ADVERTISING 15 355 340 96% 2215-436-460448-345 TELEPHONE & COMMUNICATION 1,126 2,640 1,514 57% 2215-436-460448-353 ONLINE REGISTRATION 9,183 9,475 292 3% 2215-436-460448-354 CONTRACT SERVICES 13,777 21,967 8,190 37% 2215-436-460448-355 AFTER SCHOOL PROGRAM 933 1,500 567 38% 2215-436-460448-356 BANK FEES/CC CHARGES 4,465 9,948 5,483 55% 2215-436-460448-373 DUES & TRAINING 668 1,500 833 56% ------------------------------------------------- SUBTOTAL YOUTH CAMPS 271,757 420,245 148,488 35% PARKLINE TRAIL MAINTENANCE 2215-436-460457-110 SALARIES - PARK LINE TRAIL 37,736 53,154 15,418 29% 2215-436-460457-111 SALARIES - SEASONAL 10,154 26,866 16,712 62% 2215-436-460457-121 OVERTIME 0 300 300 100% 2215-436-460457-153 HEALTH INSURANCE 6,192 9,857 3,665 37% 2215-436-460457-155 RETIREMENT 3,950 4,395 445 10% 2215-436-460457-210 OFFICE SUPPLIES - EQUIP / COMPUTERS 10 300 290 97% 2215-436-460457-215 EQUIPMENT - NOT CAPITAL 0 1,300 1,300 100% 2215-436-460457-224 JANITORIAL SUPPLIES 20 700 680 97% 2215-436-460457-229 OTHER SUPPLIES (FERTILIZER, WEED SP 133 2,000 1,867 93% 2215-436-460457-231 GAS 2,263 4,000 1,737 43% 2215-436-460457-241 TOOLS / SMALL EQUIP / SAFETY EQUIP 206 900 694 77% 2215-436-460457-341 ELECTRICITY 0 1,500 1,500 100% 2215-436-460457-345 TELEPHONE & COMMUNICATIONS 0 2,500 2,500 100% 2215-436-460457-355 CONTRACT SERVICES - TRAIL MAINT / W 0 11,000 11,000 100% 2215-436-460457-362 EQUIUPMENT / AMENITY MAINTENANCE 740 1,500 760 51% 2215-436-460457-364 LANDSCAPE MATERIALS 68 3,500 3,432 98% 2215-436-460457-367 VANDALISM REPAIRS 494 1,500 1,006 67% 2215-436-460457-373 DUES & TRAINING 79 1,000 921 92% 2215-436-460457-388 MEDICAL SERVICES - DRUG TESTING 155 100 55- -55% 2215-436-460457-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460457-440 IRRIGATION SUPPLIES 88 1,200 1,112 93% 2215-436-460457-452 TOP SOIL / MULCH & COMPOST 0 750 750 100% 2215-436-460457-545 COUNTY LANDFILL 0 3,500 3,500 100% 2215-436-460457-610 DEBT SERVICE - PRINCIPAL 6,955 15,800 8,845 56% 2215-436-460457-620 DEBT SERVICE - INTEREST 3,219 4,543 1,324 29% ------------------------------------------------- SUBTOTAL PARKLINE TRAIL MAINTE 72,461 152,665 80,204 53% POOL 2215-437-460445-111 SEASONAL SALARIES-POOL 169,388 273,320 103,932 38% THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 37 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-437-460445-121 OVERTIME 67 200 133 67% 2215-437-460445-155 RETIREMENT 934 1,500 566 38% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 171 650 479 74% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,303 3,100 1,797 58% 2215-437-460445-226 CHLORINE/CHEMICALS 28,870 52,800 23,930 45% 2215-437-460445-228 CONCESSION STAND SUPPLIES 19,622 27,000 7,378 27% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 2,322 4,000 1,678 42% 2215-437-460445-341 ELECTRICITY 5,688 10,500 4,812 46% 2215-437-460445-344 NATURAL GAS 9,224 30,680 21,456 70% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 6,827 18,555 11,728 63% 2215-437-460445-354 LICENSES & FEES 590 1,835 1,245 68% 2215-437-460445-356 BANK FEES/ CC CHARGES 2,404 6,647 4,243 64% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 21,774 70,540 48,766 69% 2215-437-460445-367 VANDALISM 0 1,000 1,000 100% 2215-437-460445-380 TRAINING MATERIALS 889 1,800 911 51% 2215-437-460445-932 EQUIPMENT / POOL IMPROVEMENTS 0 172,000 172,000 100% ------------------------------------------------- SUBTOTAL POOL EXPENDITURES 270,072 676,127 406,055 60% ------------------------------------------------- TOTAL PARKS & RECREATION/POOL 1,564,239 2,939,591 1,375,352 47% ================================================= 2210 PARKS IN LIEU 2210-436-460430-522 MAINTENANCE FEES 0 6,500 6,500 100% 2210-436-460430-933 QUAIL MEADOWS - KYAC IMPROVEMENTS S 0 129,631 129,631 100% 2210-436-460430-935 JAXON RIDGE 0 36,923 36,923 100% 2210-436-460430-936 LAWRENCE PARK IMPROVEMENTS 0 7,423 7,423 100% 2210-436-460430-937 COTTAGE GARDENS 0 9,449 9,449 100% 2210-436-460430-938 3RD AVE APT - LIONS PARK IMPROVEMEN 0 29,659 29,659 100% 2210-436-460430-939 WESTCRAFT - KYAC IMPROVEMENTS SUPPO 0 42,250 42,250 100% ------------------------------------------------- TOTAL PARKS IN LIEU 0 261,835 261,835 100% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 38 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING URBAN FORESTRY 2600-436-460433-110 SALARIES-URBAN FORESTRY 174,605 249,757 75,152 30% 2600-436-460433-111 SEASONAL SERVICES 38,786 61,267 22,481 37% 2600-436-460433-121 OVERTIME 42 1,000 958 96% 2600-436-460433-153 HEALTH INSURANCE 33,278 52,695 19,417 37% 2600-436-460433-155 RETIREMENT 16,006 20,612 4,606 22% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 4,392 4,500 108 2% 2600-436-460433-231 GAS 4,217 8,500 4,283 50% 2600-436-460433-241 CONSUMABLE TOOLS 1,657 5,200 3,543 68% 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 465 700 235 34% 2600-436-460433-354 CONTRACT SERVICES 100,860 170,000 69,140 41% 2600-436-460433-357 FORESTRY GRANT 22,000 40,000 18,000 45% 2600-436-460433-358 EAB MONITORING/ARBOR DAY 0 5,000 5,000 100% 2600-436-460433-362 EQUIPMENT MAINTENANCE 656 3,000 2,344 78% 2600-436-460433-364 LANDSCAPING & TREES 311 9,000 8,689 97% 2600-436-460433-373 DUES & TRAINING 356 6,500 6,144 95% 2600-436-460433-388 MEDICAL 110- 400 510 128% 2600-436-460433-395 EQUIPMENT RENTAL 6,844 8,000 1,156 14% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 6,783 6,783 1 0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 7,701 10,268 2,567 25% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 17,383 23,177 5,794 25% 2600-436-460433-528 INFORMATION TECHNOLOGY TRANSFER 8,625 11,550 2,925 25% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 0 16,000 16,000 100% 2600-436-460433-620 INTEREST EXPENSE 609 4,600 3,991 87% 2600-436-460433-940 MACHINERY & EQUIPMENT 58,184 71,634 13,450 19% ------------------------------------------------- TOTAL URBAN FORESTRY 503,648 790,143 286,495 36% ================================================= 2601 DEVELOPER TREES 2601-436-460430-350 ADMIN 5% 0 1,798 1,798 100% 2601-436-460435-351 EMPIRE ESTATES ($44,911) 0 8,653 8,653 100% 2601-436-460435-352 APPLEWAY ($4,564) 0 4,336 4,336 100% 2601-436-460435-353 SIDERIUS - JAXSON RIDGE 0 8,861 8,861 100% 2601-436-460435-354 PW - WEST SIDE INT 0 5,548 5,548 100% 2601-436-460435-356 SINOPAH SUBD ($5,790) 0 667 667 100% 2601-436-460435-357 COTTONWOOD SUBD ($13,100) 0 1,928 1,928 100% 2601-436-460435-359 MTN VISTA ESTATES ($35,903+34,660) 0 14,849 14,849 100% 2601-436-460435-360 OWL VIEW TH ($3,780) 0 3,780 3,780 100% 2601-436-460435-361 VILLAGE GREENS PHASE 19 ($16,497) 0 15,184 15,184 100% 2601-436-460435-362 WESTVIEW BUSINESS CNTR ($1,618) 0 948 948 100% 2601-436-460435-363 MUSKRAT SLOUGH ($1,446) 0 1,390 1,390 100% 2601-436-460435-364 MTN VISTA ESTATES IV 0 17,300 17,300 100% 2601-436-460435-365 VILLAGE GREENS $3,540 0 1,012 1,012 100% 2601-436-460435-366 W VIEW ESTATES $20,060 0 10,899 10,899 100% 2601-436-460435-367 ABIGAIL SUBDIVISION ($4,253.90) 0 2,716 2,716 100% 2601-436-460435-368 NORTHLAND SUBD PHASE 4 0 16,407 16,407 100% 2601-436-460435-369 ALDER HOMES - SANTA PROP ($1,776) 0 1,687 1,687 100% 2601-436-460435-370 GL VILLAGE GREENS PH22C ($5,600) 0 5,233 5,233 100% 2601-436-460435-371 NORTHLAND PH. 5 ($15,989) 0 15,190 15,190 100% 2601-436-460435-372 GL VILLAGE GREENS, PH 21 ($11,103. 0 9,412 9,412 100% ------------------------------------------------- TOTAL DEVELOPER TREES 0 147,798 147,798 100% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 39 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING DEVELOPMENT SERVICES 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 462,525 750,000 287,475 38% 2394-000-323103-000 PLUMBING PERMITS 29,680 65,000 35,320 54% 2394-000-323104-000 MECHANICAL PERMITS 50,621 65,000 14,379 22% 2394-000-323105-000 ELECTRICAL PERMITS 73,273 65,000 8,273- -13% 2394-000-323108-000 PLAN REVIEW FEES 166,496 325,000 158,504 49% 2394-000-341025-000 MISC. COLLECTIONS/FEES 1,125 0 1,125- 0% 2394-000-371010-000 INVESTMENT EARNINGS 88,141 20,000 68,141- -341% ------------------------------------------------- TOTAL REVENUE 871,861 1,290,000 418,139 32% ================================================= BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES-BUILDING DEPT. 511,379 760,854 249,475 33% 2394-420-420530-112 SALARIES-SEVERANCE 0 33,559 33,559 100% 2394-420-420530-121 OVERTIME 15,707 20,000 4,293 21% 2394-420-420530-153 HEALTH INSURANCE 74,916 120,189 45,273 38% 2394-420-420530-155 RETIREMENT 43,468 60,858 17,390 29% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 33,128 55,360 22,232 40% 2394-420-420530-231 GAS & OIL 2,894 6,000 3,106 52% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 3,986 7,500 3,514 47% 2394-420-420530-323 ST. ED. ASSESSMENTS 2,500 7,500 5,000 67% 2394-420-420530-345 TELEPHONE & COMMUNICATION 6,082 8,000 1,918 24% 2394-420-420530-353 AUDITING 8,627 5,500 3,127- -57% 2394-420-420530-354 CONTRACT SERVICES 1,281 40,000 38,719 97% 2394-420-420530-355 LICENSING FEE 21,442 25,000 3,558 14% 2394-420-420530-356 ArcGIS SERVER UPGRADE LICENSE 8,839 9,000 161 2% 2394-420-420530-357 CREDIT CARD / PAYPAL FEES 11,691 17,500 5,809 33% 2394-420-420530-360 FURNITURE 190 7,500 7,310 97% 2394-420-420530-373 DUES & TRAINING 21,136 30,000 8,864 30% 2394-420-420530-510 PROPERTY INSURANCE 13,657 13,657 0 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 1,547 2,063 516 25% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 31,525 42,034 10,509 25% 2394-420-420530-528 INFORMATION TECHNOLOGY TRANSFER 83,009 110,928 27,919 25% ------------------------------------------------- TOTAL BUILDING DEPT. 897,003 1,383,002 485,999 35% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 40 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2188 WESTSIDE TIF REVENUE 2188-000-371010-000 INVESTMENT EARNINGS 52,238 5,000 47,238- -945% 2188-000-373010-000 INTEREST / LOANS 9,940 13,023 3,083 24% 2188-000-373020-000 PRINCIPAL / LOANS 15,017 20,253 5,236 26% 2188-000-383005-000 TRANSFER FROM DEBT SERVICE (3188) 2,150,000 4,000,000 1,850,000 46% ------------------------------------------------- TOTAL REVENUE 3,996,058 6,859,076 2,863,018 42% ================================================= EXPENDITURES 2188-480-470230-110 SALARIES 28,030 39,663 11,633 29% 2188-480-470230-153 HEALTH INSURANCE 3,396 5,448 2,052 38% 2188-480-470230-155 RETIREMENT 2,356 3,267 911 28% 2188-480-470230-353 AUDIT 1,800 1,800 0 0% 2188-480-470230-356 TELEPHONE 126 192 66 34% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 1,152 1,535 383 25% 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 298,601 4,000,000 3,701,399 93% ------------------------------------------------- TOTAL WESTSIDE TIF 335,460 4,051,905 3,716,445 92% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 41 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2180 DOWNTOWN TIF 2180-480-470230-110 SALARIES 40,043 55,453 15,410 28% 2180-480-470230-153 HEALTH 4,852 7,554 2,702 36% 2180-480-470230-155 RETIREMENT 3,364 4,616 1,252 27% 2180-480-470230-353 AUDITING 1,994 1,800 194- -11% 2180-480-470230-356 LEGAL SURVEY/TITLE SEARCH/APPRAISAL 180 10,000 9,820 98% 2180-480-470230-720 PARKING STRUCTURE REIMBURSEMENT 0 150,000 150,000 100% 2180-480-470230-820 TRANSFER TO SAFE STREET GRANT (CITY 70,000 80,000 10,000 13% 2180-480-470230-840 REDEVELOPMENT ACTIVITY 0 900,000 900,000 100% ------------------------------------------------- TOTAL 2180 AIRPORT TIF 120,432 1,209,423 1,088,991 90% ================================================= 2185 AIRPORT TIF 2185-000-430300-840 REDEVELOPMENT ACTIVITY 184,955 184,954 1- 0% ------------------------------------------------- TOTAL 2185 AIRPORT TIF 184,955 184,954 1- 0% ================================================= OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 10,000 10,000 100% 2310-480-470210-356 FED-EX REIMBURSEMENT 7,796 10,000 2,204 22% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 37,500 50,000 12,500 25% 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 4,500 6,000 1,500 25% ------------------------------------------------- TOTAL OLD SCHOOL TIFS 49,796 76,000 26,204 34% ================================================= GLACIER RAIL PARK TEDD 2312-480-470210-110 SALARIES & WAGES 4,003 5,816 1,813 31% 2312-480-470210-153 HEALTH INSURANCE 485 935 450 48% 2312-480-470210-155 RETIREMENT 336 483 147 30% 2312-480-470210-345 TELEPHONE 18 48 30 63% 2312-480-470210-353 AUDIT 1,994 1,800 194- -11% 2312-480-470210-522 ADMINISTRATIVE TRANSFER 1,152 1,535 383 25% 2312-480-470210-795 REDEVELOPMENT - FCEDA REIMB. 21,372 75,000 53,628 72% 2312-480-470210-796 REDEVELOPMENT/SIDEWALK 0 200,000 200,000 100% ------------------------------------------------- TOTAL GLACIER RAIL PARK TEDD 29,360 285,617 256,257 90% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 42 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 1,336 1,200 136- -11% 2880-480-470210-354 CONTRACT SERVICES 922 1,500 578 39% 2880-480-470210-711 REDEVELOPMENT 80,000 80,000 0 0% ------------------------------------------------- TOTAL LOAN REVOLVING 82,258 82,700 442 1% ================================================= 2881 CD LOAN REV. #2 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 475 475 0 0% 2881-480-470210-711 REDEVELOPMENT 100,000 100,000 0 0% ------------------------------------------------- TOTAL 2881 CD REV. #2 100,475 100,475 0 0% ================================================= 2886 CD MISC. 2886-480-470210-790 REDEVELOPMENT ACTIVITY 0 28,087 28,087 100% 2886-480-470210-810 TRANSFER TO WS TIF 6,532 250,000 243,468 97% ------------------------------------------------- TOTAL CD MISC. 6,532 278,087 271,555 98% ================================================= 2887 RURAL DEVELOPMENT #1 2887-480-470210-354 CONT SERV (LOAN SOFTWARE) 475 475 0 0% 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 19,590 19,590 0- 0% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 2,484 2,484 0 0% 2887-480-470210-750 REDEVELOPMENT LOANS 0 180,000 180,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #1 22,549 202,549 180,000 89% ================================================= 2888 RURAL DEVELOPMENT #2 2888-480-470210-354 CONT SERV (LOAN SOFTWARE) 500 500 0 0% 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 8,725 8,725 0 0% 2888-480-470210-620 INTEREST EXPENSE-USDA LOAN 61-03 1,300 1,300 0- -0% 2888-480-470210-750 REDEVELOPMENT LOANS 0 279,000 279,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #2 10,525 289,525 279,000 96% ================================================= THE CITY OF KALISPELL, MONTANA05.13.2024 12:22 gb8501_pg.php/Job No: 31878 Page 43 of 43 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2024 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2953 EPA BROWNFIELDS 2953-480-470210-353 CONT. SERV - (STATE PETRO REIMB) 0 1,115 1,115 100% ------------------------------------------------- TOTAL EPA BROWNSFIELD 0 1,115 1,115 100% ================================================= 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES-PETROLEUM 0 218,322 218,322 100% 2955-480-470210-373 TRAVEL-PETROLEUM 1,402 0 1,402- 0% 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% 2955-480-470215-373 TRAVEL-HAZARDOUS SUBTSANCE 1,158 0 1,158- 0% ------------------------------------------------- TOTAL BROWNFIELDS LOAN REV. 2,560 586,495 583,935 100% ================================================= FY21 AIRPORT GRANT 2974-430-430310-934 CAPITAL IMROVEMENTS - LIGHT/FENCING 0 394,187 394,187 100% ------------------------------------------------- TOTAL 2974 FY21 AIRPORT GRANT 0 394,187 394,187 100% ================================================= ------------------------------------------------- ================================================= City of Kalispell, Montana P.O. Box 1997 - Kalispell, Montana 59903-1997 Telephone (406) 758 - 7000 Fax - (406) 758-7758 Quarterly Finance Report Please find attached the printouts reflecting the activity for the first nine months of fiscal year 2024. This printout reflects payroll earned through March 29, 2024, and accounts payable claims received by the end of March. Most funds are included in the report however some funds are excluded due to insignificant activity (expenditures). General Fund - Revenue_______________________________________________ Revenue Year to Date Revenue Source % Change Property Tax 9.84% Licenses & Permits 135.77% Intergovernmental 5.06% Charges for Services .11% Other Revenue 14.81% Third Quarter Revenue Revenue Source % Change Property Tax 78.12% Licenses & Permits 297.2% Intergovernmental 9.22% Charges for Services 6.37% Other Revenue 46.79% General Fund revenue reflects taxes collected through March 31. Historically, the general fund receives about 45% of its property tax revenue in the 4th quarter. A similar distribution for this fiscal year would bring collections to almost $7.8M or about 105% of budget. The City is currently carrying just over $18,000 in protest taxes. General Fund Expenses________________________________________________ Expense Budget Remaining For Year Expense Type % Remaining Salaries 31.50% Supplies 42.50% Services 42.20% Other Charges 25.63% Salary and retirement remaining should be about 23% in most funds. With a few exceptions; administrative, central garage, and information technology transfers are done monthly and should also show 25% remaining. The general fund administrative charges may vary slightly as some charges are based on the percentage of revenues collected. Annual budgeted operating transfers are generally done quarterly, depending on cash availability, and should show 25% remaining. Parks Department___________________________________________________ Revenue Year to Date Revenue Source % Change Property Tax 11.31% Fees 10.53% Other Revenue -20.17% Expense Budget Remaining For Year Expense Type % Remaining Salaries 36.10% Supplies 43.00% Services 63.90% Other Charges 76.07% Parks fund tax collections are 56% at the end of March, compared to 58% a year ago. Fourth quarter collections of $615,000 are required to reach the budgeted revenue amount. 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). FY24 fee collections are currently $40,000 more the at the same point last fiscal year. 0 500 1000 Property Tax Fees Other Revenue Parks Year To Date Revenue Comparison (in thousands) Current Year Prior Year Ambulance Fund_____________________________________________________ The Ambulance Fund third Quarter fees for service are 65% of the annual budget or $324,750. This is an increase of about 2% when compared to the third quarter of 2023. Ambulance fund operating expenditures reflect a decrease of about $50,000 from the same period in fiscal year 2023. This decrease can be attributed to salary cost savings. Building Department__________________________________________________ Third quarter building department revenues of $871,861 are 68% of the annual budget. Third quarter fiscal year 2023 revenues were just over $818,000. Water Fund ________________________ Metered water sales are at 100% compared to 88% for the third quarter of fiscal year 2023. It is normal for metered water sales to be in excess of 75% of the annual amount because of late summer and fall sprinkling and irrigation. Revenue Year to Date Revenue Source % Change Metered Water Sales 24.09% Fees for Service 33.96% Other Revenue 70.63% Expense Budget Remaining for Year Expense Type % Remaining Salaries 35.5% Supplies 49.43% Services 52.60% Other Charges 79.72% Sewer Fund ______________________ Sewer service charges were $6,414,788, 80% of budgeted amount. For comparison, last year’s meter sewer sales were $5,970,193. Most of the increase between years can also be attributed to an approved rate increase for fy24. Revenue Year to Date Revenue Source % Change Sewer Charges 7.45% Fees for Service -23.2% Other Revenue 106 % Expense Budget Remaining for Year Expense Type % Remaining Salaries 33.4% Supplies 49.6% Services 52.4% Other Charges 68.57%