The URL can be used to link to this page

10-13-23 City Manager Report1 City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 10/13/2023 1. Parks and Recreation Park irrigation systems have been winterized and seasonal restrooms have been closed for winter. Park crews have started a major project at the pool to repair a main water line that returns water from the pool to the filters. A fencing contractor is installing an eight foot fence around the north side of Woodland Water Park to help with vandalism, graffiti, and illegal entry through the soffits. Forestry staff are pruning trees on 12th Street West while a contactor is pruning trees between Montana Street and Idaho Street. 5v5 Futsal league registration is now open. Futsal League will begin in October and will take place at Edgerton Elementary on Tuesday, Wednesday and Thursday evenings. Little Dribblers is set to begin this Saturday, October 14. Games will be played at Rankin, Peterson, and Linderman Schools from 8am-6pm. Our fall break Skip Out camp registration closes Friday, October 12. We will be going to Sweet Pickin’s Pumpkin Patch, making fall crafts, and enjoying no school! The After School program has limited availability. 2. Public Works Leaf Collection Public Works will start the collection of leaves this season beginning October 16 and will stop the collection effort on November 17. The leaf collection season is instituted to 2 promote effective and efficient leaf collection services by the Public Works Department prior to the onset of the winter snow season. Residents and business owners are encouraged to rake the leaves from the boulevard onto the street approximately two feet away from the curb. Residents should rake the leaves past the curb by the start of their scheduled weekday, to not miss collection. In an effort to provide routine leaf service in areas throughout Kalispell, Public Works has designated areas of leaf collection for each day of the week. The following link, Leaf Removal | Kalispell, MT will direct you to the City’s website with additional leaf collection information and a map with the designated collection areas and corresponding collection days. Public Works will make every effort to collect leaves on the designated days, however unpredictable leaf volumes, weather conditions, and equipment failures may require leaf collection days to be performed outside of the scheduled areas. As a reminder, the City does not perform curbside/streetside leaf collection in spring, and the public is encouraged to contact Public Works for guidance on proper leaf disposal after the Leaf Collection Season or visit us on our website www.kalispell.com. 50/50 Sidewalk Repair Program The City had another successful 50/50 Sidewalk Repair construction season with various curb and sidewalk projects completed throughout the city. Projects this year included a mix of private property and City ADA accessibility projects. The City’s contractor completed 17 work orders that included 3.75 blocks of sidewalk and 5 ADA accessibility improvements. As part of our concrete contract, the contractor also completed 225 LF (approx. 0.68 blocks) of curb and gutter replacement. 3. Planning Department The Planning Board held a public hearing on October 10 and heard two application requests and a public hearing with no action. Agenda items consisted of the following: 1. The Kalispell Planning Board held a public hearing to receive public testimony regarding its intent to submit a U.S. Department of Housing and Urban Development Pathways to Removing Obstacles to Housing (PRO Housing) grant. All interested persons were given the opportunity to ask questions and to express their opinions regarding the proposed grant application. 3 2. Files # KPUD-23-02 and KPP-23-08 – A request from Silvermont Properties, LLLP, for Riverside North, which includes applications for an amended Planned Unit Development (“PUD”) overlay and major preliminary plat on approximately 80.97 acres of land. The property was included as part of the 2006 Silverbrook PUD (a 325-acre development with R-2 (Residential), R-4 (Residential), and B-1 (Neighborhood Business) underlying zoning) and had previously received preliminary plat approval as Silverbrook Phase 2D. The subject property is part of the area of the overall PUD that is zoned R-2. The updated development plan includes 97 lots (95 single family lots, with a storage unit lot for residents and a fire station/public works facility lot to be dedicated to the City), roads, park and common area. The property is located at 250 Church Drive. 3. File #KPP-23-10 – A request from Stillwater Corporation for major preliminary plat approval for Kalispell North Town Center Phases 6 and 7, a 23-lot commercial subdivision located in a B-2 (General Business) zone within the Kalispell North Town Center Planned Unit Development overlay (previously known as The Glacier Town Center PUD). Overall, Kalispell North Town Center is 485.5 acres and includes four zoning designations of R-3 (single-family residential), R-4 (two-family residential), B-1 (neighborhood business), and B-2 (general business). These phases contain 72.6 acres in lots, roads and common area. The property is generally located on the east side of Highway 93 North between Glacier Memorial Gardens and Lincoln Street. The Board recommended approval of the two requests and no comment was received regarding the PRO Housing grant application. The recommendations will be forwarded to the Council for consideration at the November 6 meeting. The Planning Board also held a work session on the item listed below: 1. Files #KPUD-23-03 and KPP-23-09 – A request from Stillwater Development Partners, LLC, for Stillwater Bend Phase 2, which includes applications for a Planned Unit Development (“PUD”) overlay and major preliminary plat on approximately 30.5 acres of land. The property was annexed in 2017 as part of a 56-acre placeholder PUD with 25.5 acres along Highway 93 zoned B-2 (General Business) and the remainder zoned RA-2 (Residential Apartment/Office). In 2020, the B-2 area received a full PUD approval with the RA-2 remaining as a placeholder PUD. This PUD proposal would encompass the remaining area. The proposed PUD would allow for 432 multi-family dwelling units. The preliminary plat includes four lots, roads, and common area. The property is located at the western terminus of Rose Crossing to the west of Highway 93 North. 4. Building Department In the last 2 weeks, we have issued 1 single-family home permit, bringing the year-to- date total of new single-family/duplex and townhouse units to 93, compared to 129 last year at this time. There have been 379 multi-family housing units issued so far this year. Last year at this time we had issued 556 multi-family housing units. 4 There were a total of 275 combined building and/or fire inspections completed in the last 2 weeks. Residential – 51 Plumbing – 14 Commercial – 40 Mechanical - 21 Electrical – 15 Fire – 134 5. Community Development Kalispell’s Safe Streets and Roads for All Safety Action Grant Plan Request for Proposals generated two proposals. The stakeholder/selection committee, comprised of community and agency representatives, reviewed and scored the proposals. The recommendation to City Council to select Kittleson & Associates for this project will be presented for consideration at the October 16 meeting. Kalispell’s Urban Renewal Agency (URA) met September 20, and reviewed the recommendation of four public benefit projects for Tax Increment Finance funding. The URA voted to recommend funding from the Westside/Core Area TIF for the following projects: Depot Park Building Remodel, Wye Track property purchase and Welcome to Kalispell signage on overpass bridge at Highway 2 East. The URA chose not to make a recommendation to Council regarding the proposed funding of a Police Evidence Facility. The URA recommendations will go to City Council for consideration at the October 16 meeting. 6. Fire Department From the period of September 27 to October 10, the Fire Department had 178 responses. Of these, there were 130 were medical incidents, 1 structure fire, 1 brush fire, 9 Motor vehicle accidents, 5 Fire alarm activations, 4 public assists, 2 Haz-Mat incidents, and 26 nothing found or dispatched and canceled enroute. Three new firefighter/paramedics are in week 3 of the Fire Academies, focusing on “all hazards” scenarios, i.e., Haz-Mat, Tech Rescue, and local EMS protocols. Our 2018 Smeal Fire Engine was returned from service from Legends RV Repair. The rear body of the vehicle was repainted and re-stripped due to paint failure. Preparation for an active shooter drill at Logan Health is underway. A Federal training program for Fire Officer 1 is scheduled to be delivered November 27 through November 30 for all Captains and Acting Captains. Logan Health nurses have been riding with ambulance crews for field observations. State DEQ has been instructing crews on asbestos awareness training and hazardous 5 waste, i.e. methamphetamine. We recently held a call review session with our Department Medical Director related to pre-hospital care and patient outcomes. 7. Police Department Attached is the latest case report from the Kalispell Police Department. Our year-to-date Calls for Service are as follows: 2023-29750 2022-28350 2021-27475 Year-to-date Felony Cases are as follows: 2023- 485 2022- 526 2021- 425 8. Finance Department Quarterly Finance Report Please find attached the printouts reflecting the activity for the first three months of fiscal year 2024. This printout reflects payroll earned through September 23, 2023, and accounts payable claims received by the end of September. 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 22% Licenses & Permits 61% Charges for Services 13% Other Revenue -6.8% 6 General Fund revenue has little activity as taxes will not be received until December. The tax receivables have not been booked. Tax bills will go out at the end of October and receivables/revenue will be booked at that time. General Fund Expenses________________________________________________ Expense Budget Remaining For Year Expense Type % Remaining Salaries 79.80% Supplies 85.60% Services 85.10% Other Charges 78.00% Salary and retirement remaining should be about 77% in most funds. With a few exceptions administrative, central garage, and information technology transfers are done monthly and should show 75% remaining. Parks Department________________________________________________________ Revenue Year to Date Revenue Source % Change Property Tax 15.6% Fees 2.93% Other Revenue 1.0% Expense Budget Remaining For Year Expense Type % Remaining Salaries 68.80% Supplies 61.10% Services 86.03% Other Charges 75.00% 7 The parks fund receives approximately two-thirds of its revenue from tax levies (general and permissive health). Also, a majority of parks charges for services are received in the second half of the fiscal year. Ambulance Fund_____________________________________________________ The Ambulance Fund 1st Quarter fees for service is 20% of the annual budget or $86,315. This is an increase of about $2,508 when compared to the 1st quarter of 2022. Overtime expense is over $18,889 due to assistance with the Ridge Fire. We will be receiving full reimbursement for services provided. Building Department__________________________________________________ First quarter building department revenues of $350,279 are 28% of the annual budget. First quarter fiscal year 2023 revenues were just over 125,000. Water Fund ________________________ Metered water sales are at 50% compared to 44% for the first quarter of fiscal year 2023. First quarter water sales are usually more than 25% due to summer and early fall sprinkling and irrigation. Revenue Year to Date Revenue Source % Change Metered Water Sales 50% Fees for Service 27% Other Revenue -51% Expense Budget Remaining for Year Expense Type % Remaining Salaries 79% Supplies 61% Services 85% Other Charges 70% 8 Sewer Fund ______________________ Sewer metered sales are at 28%, about the same as 1st quarter last fiscal year. Revenue Year to Date Revenue Source % Change Sewer Charges 1.0% Fees for Service 3.0% Other Revenue 18 % Expense Budget Remaining Expense Type % Remaining Salaries 77% Supplies 79% Services 90% Other Charges 73% 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 1 1 0 0 0 0 0 0 1 1 SIWOC/Sexual Assault 5 0 3 0 1 0 7 1 4 0 2 0 4 1 4 0 1 1 31 3 Robbery 1 2 1 1 2 2 1 1 1 0 0 0 0 0 2 0 0 0 8 6 Aggravated Assault 4 3 5 2 11 5 5 5 10 4 8 4 7 4 6 3 10 5 66 35 Assault on a Peace Officer 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 1 1 Simple Assault 7 5 10 4 14 5 4 1 22 10 13 8 7 5 8 5 12 3 97 46 PFMA 12 8 5 5 4 3 11 5 13 6 12 10 4 3 6 2 8 4 75 46 Resisting Arrest 4 4 2 1 2 2 1 0 5 6 7 6 4 2 1 1 2 2 28 24 Crimes Against Property Burglary 3 1 1 1 2 1 1 0 4 1 1 0 0 0 3 0 2 1 17 5 Theft 48 15 29 7 46 20 49 28 62 39 50 19 57 23 71 26 69 40 481 217 Vehicle Theft/Unauth Use 9 5 3 2 5 4 1 0 4 2 2 0 5 0 8 0 6 0 43 13 Arson 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 1 1 Forgery/Counterfeit 0 0 0 0 2 0 4 2 1 0 1 0 3 1 5 1 3 0 19 4 Fraud 2 0 4 1 2 0 3 0 5 0 3 0 1 1 0 0 1 0 21 2 Theft of Identity 1 0 2 0 2 0 1 0 0 0 0 0 0 0 1 0 0 0 7 0 Embezzlement 1 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 0 4 0 Stolen Property offenses 0 0 2 4 0 0 0 0 2 1 0 0 0 0 1 0 0 2 5 7 Criminal Mischief 12 5 13 4 17 1 16 0 30 7 24 8 13 9 20 4 7 1 152 39 Crimes Against Society Weapon Law Violations 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 1 Prostitution Offenses 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 Child Pornography 0 0 1 0 0 0 0 0 2 0 1 0 0 0 1 0 0 0 5 0 Drug Offenses 6 5 15 7 8 7 6 5 11 8 23 13 15 5 17 6 23 9 124 65 Family Offenses (non-violent)1 0 0 1 1 0 0 0 0 1 0 0 1 0 1 0 1 0 5 2 DUI 15 15 5 4 9 9 11 11 10 10 7 8 10 9 4 4 6 6 77 76 Possession of Alcohol 0 0 3 1 7 13 13 11 2 3 3 2 3 5 0 0 1 1 32 36 Provide Alcohol to Minor 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Other Alcohol Offenses 1 4 0 0 0 0 0 0 2 2 0 0 1 1 0 0 0 0 4 7 Kidnapping/Custodial Int.0 0 1 0 0 0 0 0 1 1 0 0 0 0 0 0 1 1 3 2 Disorderly Conduct 6 6 7 6 3 3 10 7 14 11 20 19 10 10 5 5 6 5 81 72 Criminal Trespass 28 19 26 9 27 16 17 9 30 25 34 21 23 14 31 16 20 14 236 143 Violation of Protective Order 8 2 2 0 2 0 2 0 7 6 7 1 2 0 6 1 3 1 39 11 Obstructing a peace officer 7 5 5 2 6 6 4 4 7 7 15 13 6 4 2 2 8 7 60 50 Juvenile Offenses (except MIP)5 2 4 6 3 1 7 7 15 5 2 1 4 0 4 0 6 1 50 23 Other Offenses 11 8 13 11 11 5 14 7 18 20 11 9 15 11 24 23 16 16 133 110 Total 198 114 162 79 188 104 188 104 282 175 250 145 196 108 232 99 212 120 0 0 0 0 0 0 1908 1048 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 491 247 481 181 453 226 490 220 347 250 470 293 491 298 424 223 324 197 3971 2135 Total Calls for Service Kalispell Police Department Case and Arrest Reports - 2023 January February March April May June July August September October November December Totals 3102 2670 3044 3252 3543 3720 28907345432832839 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 1 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 138,916 7,575,000 7,436,084 98% 1000-000-311200-000 PERSONAL PROPERTY TAXES 105,117 100,000 5,117- -5% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 6,757 10,000 3,243 32% 1000-000-322101-000 LIQUOR LICENSES 0 33,000 33,000 100% 1000-000-322300-000 GENERAL & OCCUPATIONAL 5 500 495 99% 1000-000-323012-000 PLANNING FEES 84,428 225,000 140,572 62% 1000-000-323109-000 SITE REVIEW 2,772 20,000 17,228 86% 1000-000-323200-000 PARADE PERMITS 0 500 500 100% 1000-000-331112-000 KPD - SAFE STREET TASK FORCE 0 5,000 5,000 100% 1000-000-334010-000 CANNABIS LOCAL OPTION TAX 0 200,000 200,000 100% 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 0 60,000 60,000 100% 1000-000-335110-000 LIVE CARD TABLE PERMIT 0 1,650 1,650 100% 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 925,765 3,263,060 2,337,295 72% 1000-000-341020-000 ADMINISTRATIVE CHARGES 243,649 715,947 472,298 66% 1000-000-341021-000 GRANT ADMIN FEES 0 30,000 30,000 100% 1000-000-341025-000 CITY COLLECTIONS 375 5,000 4,625 93% 1000-000-342010-000 POLICE SERVICES 6,966 30,000 23,034 77% 1000-000-342014-000 RESOURCE OFFICERS 66,326 265,306 198,980 75% 1000-000-342016-000 KPD REGIONAL TRAINING 652 10,000 9,348 93% 1000-000-342017-000 KFD-IFSAC TRAINING REIMB 0 8,000 8,000 100% 1000-000-343018-000 PARKING PERMITS 20,864 70,000 49,136 70% 1000-000-343062-000 AIRPORT FUEL TAXES 1,572 4,000 2,428 61% 1000-000-343063-000 AIRPORT GROUND LEASE (HILTON) 0 14,000 14,000 100% 1000-000-351000-000 CITY COURT FINES & FEES 94,957 430,000 335,043 78% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 3,835 25,000 21,165 85% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 14,819 30,000 15,181 51% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 0 20,000 20,000 100% 1000-000-362020-000 MMIA LIABILITY RETRO 22,874 27,000 4,126 15% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 0 10,000 10,000 100% 1000-000-365016-000 INSURANCE REIMBURSEMENTS 38,623 0 38,623- 0% 1000-000-371010-000 INVESTMENT EARNINGS 75,180 225,000 149,820 67% 1000-000-381050-000 TRANSFER FROM 2886 CD 0 250,000 250,000 100% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 0 1,150,000 1,150,000 100% ------------------------------------------------- TOTAL GENERAL FUND REVENUE 1,854,452 14,813,963 12,959,511 87% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 2 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 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 0 3,030 3,030 100% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 298 17,250 16,953 98% 1000-400-410530-354 GASB 75 ACTUARIAL VALUATION 8,000 8,000 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 193 4,000 3,807 95% 1000-400-410560-312 POSTAGE 5,949 17,500 11,551 66% 1000-400-410560-320 PRINTING & ENVELOPES 1,584 2,500 916 37% 1000-400-410560-354 CONTRACT SERVICES - DOC. SHRED / 10 53 3,000 2,948 98% 1000-400-410600-354 ELECTIONS 0 50,000 50,000 100% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 863 4,500 3,637 81% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 0 350 350 100% 1000-400-430300-355 AIRPORT REIMBURSEMENT 4,737 25,000 20,263 81% 1000-400-460452-355 MOUNTAIN CLIMBER CONTRIBUTION 0 15,000 15,000 100% 1000-400-460452-366 HOCKADAY MAINTENANCE 0 6,600 6,600 100% 1000-400-510300-000 CONTINGENCY 10,658 50,000 39,342 79% 1000-400-510330-513 LIABILITY INSURANCE 320,406 320,406 0 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 338,432 50,000 288,432- -577% 1000-400-510330-517 PROPERTY INSURANCE 82,359 82,359 0- 0% ------------------------------------------------- SUBTOTAL GEN.GOV'T. 773,532 659,495 114,037- -17% CITY MANAGER 1000-401-410210-110 SALARIES-CITY MANAGER'S OFFICE 41,265 190,481 149,216 78% 1000-401-410210-153 HEALTH INSURANCE 4,260 25,364 21,104 83% 1000-401-410210-155 RETIREMENT 4,389 20,358 15,969 78% 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 240 1,200 960 80% 1000-401-410210-373 DUES & TRAINING 150 12,000 11,850 99% 1000-401-410210-379 MEETINGS 264 6,500 6,236 96% ------------------------------------------------- SUBTOTAL CITY MANAGER 50,568 256,603 206,035 80% HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 48,780 215,580 166,800 77% 1000-401-410830-153 HEALTH INSURANCE 3,974 24,066 20,092 83% 1000-401-410830-155 RETIREMENT 4,108 17,826 13,718 77% 1000-401-410830-210 OFFICE SUPPLIES 24 3,500 3,476 99% 1000-401-410830-338 RECRUITMENT/RELOCATION 4,468 24,000 19,532 81% 1000-401-410830-354 CONTRACT SERVICES 505 2,500 1,995 80% 1000-401-410830-373 DUES & TRAINING 95 17,000 16,905 99% ------------------------------------------------- SUBTOTAL HUMAN RESOURCES 61,953 304,472 242,519 80% 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 3 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 13,875 63,179 49,304 78% 1000-402-410100-153 HEALTH INSURANCE 7,740 48,786 41,046 84% 1000-402-410100-155 RETIREMENT 593 2,676 2,083 78% 1000-402-410100-210 OFFICE SUPPLIES 0 3,500 3,500 100% 1000-402-410100-335 MT LEAGUE OF CITIES 398 4,000 3,602 90% 1000-402-410100-354 CONTRACT SERVICES 782 5,500 4,718 86% 1000-402-410100-373 DUES & TRAINING 0 13,000 13,000 100% 1000-402-410100-379 MEETINGS 3,560 28,000 24,440 87% ------------------------------------------------- SUBTOTAL MAYOR/COUNCIL 26,948 168,641 141,693 84% CITY CLERK 1000-402-410150-110 SALARIES-CITY CLERK 30,054 132,406 102,352 77% 1000-402-410150-121 OVERTIME 34 250 216 87% 1000-402-410150-153 HEALTH INSURANCE 2,937 17,796 14,859 84% 1000-402-410150-155 RETIREMENT 2,530 11,023 8,493 77% 1000-402-410150-210 OFFICE SUPPLIES 41 400 359 90% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 70 500 430 86% 1000-402-410150-345 TELEPHONE & COMMUNICATION 120 480 360 75% 1000-402-410150-352 CODIFICATION 3,495 4,100 605 15% 1000-402-410150-354 CONTRACT SERVICES 0 450 450 100% 1000-402-410150-373 DUES & TRAINING 699 4,500 3,801 84% ------------------------------------------------- SUBTOTAL CITY CLERK 39,980 171,905 131,925 77% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES-FINANCE OFFICE 63,250 278,375 215,125 77% 1000-403-410550-121 OVERTIME 0 500 500 100% 1000-403-410550-153 HEALTH INSURANCE 8,232 45,135 36,903 82% 1000-403-410550-155 RETIREMENT 5,321 23,113 17,792 77% 1000-403-410550-210 SUPPLIES 0 1,000 1,000 100% 1000-403-410550-322 BOOKS 0 250 250 100% 1000-403-410550-353 CONTRACT SERVICES 0 1,500 1,500 100% 1000-403-410550-354 CONTRACT-GRIZZLY SECURITY 608 1,500 892 59% 1000-403-410550-355 BANK CHARGES & FEES 520 3,500 2,980 85% 1000-403-410550-373 DUES & TRAINING 155 12,000 11,845 99% ------------------------------------------------- SUBTOTAL FINANCE 78,087 366,873 288,786 79% 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 4 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CITY ATTORNEY 1000-404-411110-110 SALARIES-CITY ATTORNEY'S 130,929 570,797 439,868 77% 1000-404-411110-121 OVERTIME 69 0 69- 0% 1000-404-411110-153 HEALTH INSURANCE 13,005 84,286 71,281 85% 1000-404-411110-155 RETIREMENT 11,023 47,472 36,449 77% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 745 13,930 13,185 95% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 6,359 10,000 3,641 36% 1000-404-411110-345 TELEPHONE & COMMUNICATION 204 1,000 796 80% 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 30 10,000 9,970 100% 1000-404-411110-373 DUES & TRAINING 1,474 10,000 8,526 85% ------------------------------------------------- SUBTOTAL CITY ATTORNEY 163,838 747,485 583,647 78% MUNICIPAL COURT 1000-406-410360-110 SALARIES-COURT 66,343 307,302 240,959 78% 1000-406-410360-121 OVERTIME 0 3,500 3,500 100% 1000-406-410360-153 HEALTH INSURANCE 6,319 55,044 48,725 89% 1000-406-410360-155 RETIREMENT 5,585 25,500 19,915 78% 1000-406-410360-210 SUPPLIES 68 4,500 4,432 98% 1000-406-410360-320 PRINTING/BOOKS 689 1,500 811 54% 1000-406-410360-345 TELEPHONE & COMMUNICATION 247 1,500 1,253 84% 1000-406-410360-353 SECURITY & TECHNOLOGY 610 40,000 39,390 98% 1000-406-410360-354 CONTRACT SERVICES 2,687 7,000 4,313 62% 1000-406-410360-373 DUES & TRAINING 1,197 10,000 8,803 88% 1000-406-410360-394 JURY & WITNESS FEES 268 10,000 9,732 97% ------------------------------------------------- SUBTOTAL COURT 84,014 465,846 381,832 82% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES-PUBLIC WORKS 6,317 27,752 21,435 77% 1000-410-430100-153 HEALTH INSURANCE 642 3,901 3,259 84% 1000-410-430100-155 RETIREMENT 527 2,274 1,747 77% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 7,736 15,500 7,764 50% 1000-410-430100-218 NON CAPITAL EQUIP/ENGINEERING TOOLS 0 3,500 3,500 100% 1000-410-430100-231 GAS 1,254 6,800 5,546 82% 1000-410-430100-345 TELEPHONE & COMMUNICATION 302 1,600 1,298 81% 1000-410-430100-354 CONTRACT SERVICES 2,195 4,000 1,805 45% 1000-410-430100-373 DUES & TRAINING 656 5,000 4,344 87% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 1,831 5,494 3,663 67% ------------------------------------------------- SUBTOTAL PUBLIC WORKS ADMIN 21,461 75,821 54,360 72% CITY HALL MAINT. 1000-412-411230-110 SALARIES-CITY HALL 19,017 83,711 64,694 77% 1000-412-411230-153 HEALTH INSURANCE 2,496 15,307 12,811 84% 1000-412-411230-155 RETIREMENT 1,584 6,892 5,308 77% 1000-412-411230-220 SECURITY IMPROVEMENTS 0 85,700 85,700 100% 1000-412-411230-224 JANITORIAL SUPPLIES 1,137 7,600 6,463 85% 1000-412-411230-241 TOOLS & SUPPLIES 177 1,500 1,323 88% 1000-412-411230-341 ELECTRICITY 9,689 50,000 40,311 81% 1000-412-411230-344 NATURAL GAS 3,674 45,430 41,756 92% 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 5 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-345 TELEPHONE & COMMUNICATION 112 500 388 78% 1000-412-411230-354 CONTRACT SERVICES 4,899 15,000 10,101 67% 1000-412-411230-355 HVAC MAINTENANCE CONTRACT 22,876 21,500 1,376- -6% 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 884 7,500 6,616 88% 1000-412-411230-362 EQUIPMENT MAINTENANCE 585 20,000 19,415 97% 1000-412-411230-366 BUILDING MAINTENANCE 3,178 25,000 21,822 87% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 174 4,000 3,826 96% 1000-412-411230-920 BLDG IMPROVEMENT 74 65,000 64,926 100% ------------------------------------------------- SUBTOTAL CITY HALL 70,554 454,640 384,086 84% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES-PLANNING & ZONING 62,524 274,209 211,685 77% 1000-420-411020-153 HEALTH INSURANCE 7,626 46,284 38,658 84% 1000-420-411020-155 RETIREMENT 5,261 22,820 17,559 77% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 0 5,000 5,000 100% 1000-420-411020-231 GAS 0 550 550 100% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 421 2,500 2,079 83% 1000-420-411020-345 TELEPHONE 98 1,000 902 90% 1000-420-411020-354 CONTRACT SERVICES 468 6,000 5,532 92% 1000-420-411020-373 DUES & TRAINING 1,884 8,000 6,116 76% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 92 275 183 67% ------------------------------------------------- SUBTOTAL PLANNING DEPT. 78,374 366,638 288,264 79% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 2,527 11,163 8,636 77% 1000-480-470210-153 HEALTH INSURANCE 243 1,971 1,728 88% 1000-480-470210-155 RETIREMENT 214 920 706 77% 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 29 400 371 93% 1000-480-470210-354 CONTRACT SERVICES 0 250 250 100% 1000-480-470210-373 DUES & TRAINING 83 2,500 2,417 97% 1000-480-470210-379 MEETINGS 0 750 750 100% ------------------------------------------------- SUBTOTAL COMMUNITY DEVELOPMENT 3,095 20,454 17,359 85% 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 6 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES-POLICE 648,562 3,055,993 2,407,431 79% 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) 21,478 80,000 58,522 73% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 4,379 35,000 30,621 87% 1000-413-420140-153 HEALTH INSURANCE 72,284 533,321 461,037 86% 1000-413-420140-155 RETIREMENT 78,951 402,034 323,083 80% 1000-413-420140-210 OFFICE SUPPLIES 148 5,000 4,852 97% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 94 4,310 4,216 98% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 250 48,946 48,696 99% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 0 7,230 7,230 100% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 1,905 16,200 14,295 88% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 608 2,780 2,172 78% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 1,819 21,500 19,681 92% 1000-413-420140-227 AMMO & RELATED SUPPLIES 42,606 56,500 13,894 25% 1000-413-420140-228 PATROL CAR SUPPLIES 348 2,100 1,752 83% 1000-413-420140-229 OTHER SUPPLIES 2,517 13,000 10,483 81% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 0 1,000 1,000 100% 1000-413-420140-231 GAS 13,752 85,000 71,248 84% 1000-413-420140-234 CRISIS NEGOTIATIONS 37 2,400 2,363 98% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 0 1,500 1,500 100% 1000-413-420140-320 PRINTING 296 4,500 4,204 93% 1000-413-420140-345 TELEPHONE & COMMUNICATION 4,834 23,500 18,666 79% 1000-413-420140-354 CONTRACT SERVICES 633 83,000 82,367 99% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 2,224 7,000 4,776 68% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 1,021 4,900 3,879 79% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 390 2,500 2,110 84% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 24,688 69,000 44,312 64% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 567 6,500 5,933 91% 1000-413-420140-373 DUES & TRAINING 3,235 60,500 57,266 95% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 521 14,500 13,980 96% 1000-413-420140-380 TRAINING MATERIALS 0 4,000 4,000 100% 1000-413-420140-388 MEDICAL SERVICES 0 3,000 3,000 100% 1000-413-420140-392 BOARDING/TREATING PRISONERS 239 3,255 3,017 93% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 32,410 97,230 64,820 67% 1000-413-420140-530 RENT 700 8,400 7,700 92% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 21,333 64,000 42,667 67% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 2,000 6,000 4,000 67% 1000-413-420140-942 EQUIPMENT (WATCHGUARD CAMERA/MOTORO 0 12,500 12,500 100% 1000-413-420140-944 VEHICLES 39,039 228,000 188,961 83% ------------------------------------------------- SUBTOTAL POLICE DEPT. 1,030,442 5,129,099 4,098,657 80% DETECTIVES 1000-413-420141-110 SALARIES-DETECTIVES 105,328 454,688 349,360 77% 1000-413-420141-121 DETECTIVE-OVERTIME 5,721 15,000 9,279 62% 1000-413-420141-123 OVERTIME (SAFE NEIGHBORHOOD TASK FO 244 8,000 7,756 97% 1000-413-420141-153 HEALTH INSURANCE 12,145 81,447 69,302 85% 1000-413-420141-155 DETECTIVE-RETIREMENT 13,949 60,948 46,999 77% ------------------------------------------------- TOTAL DETECTIVES 137,387 620,083 482,696 78% RECORDS 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 7 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-110 SALARIES-RECORDS DIVISION 46,127 205,766 159,639 78% 1000-413-420142-121 OVERTIME 305 6,500 6,195 95% 1000-413-420142-153 HEALTH INSURANCE 9,057 48,693 39,636 81% 1000-413-420142-155 RETIREMENT 3,916 17,033 13,117 77% ------------------------------------------------- TOTAL RECORDS 59,404 277,992 218,588 79% RESOURCE OFFICERS 1000-413-420144-110 SALARIES-SRO 77,439 342,463 265,024 77% 1000-413-420144-153 HEALTH INSURANCE 10,377 57,913 47,536 82% 1000-413-420144-155 SRO RETIREMENT 9,925 46,001 36,076 78% ------------------------------------------------- TOTAL RESOURCE OFFICERS 97,740 446,377 348,637 78% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL-SALARIES 12,500 56,242 43,742 78% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 1,548 10,357 8,809 85% 1000-413-420145-155 RETIREMENT 1,003 4,482 3,480 78% ------------------------------------------------- SUBTOTAL ANIMAL CONTROL 15,051 71,581 56,530 79% PARKING 1000-413-420147-110 PARKINGS -SALARIES 25,955 113,801 87,846 77% 1000-413-420147-153 HEALTH INSURANCE 5,649 34,330 28,681 84% 1000-413-420147-155 RETIREMENT 2,137 9,324 7,187 77% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 45 3,000 2,955 99% 1000-413-420147-354 CONTRACTED SERVICES 90 3,000 2,910 97% 1000-413-420147-362 LOT MAINT 1,132 10,000 8,868 89% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 0 20,000 20,000 100% 1000-413-420147-550 LOT LEASE PAYMENTS 390 1,500 1,110 74% ------------------------------------------------- SUBTOTAL PARKING 35,397 194,955 159,558 82% ------------------------------------------------- SUBTOTAL POLICE DEPT. 1,375,422 6,740,087 5,364,665 80% 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 8 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES-FIRE SUPPRESSION 468,581 2,521,748 2,053,167 81% 1000-416-420400-112 SALARY-SEVERANCE 0 15,000 15,000 100% 1000-416-420400-114 COMPTIME BUYOUT 0 5,500 5,500 100% 1000-416-420400-115 OUT OF RANK PAY 3,170 12,500 9,330 75% 1000-416-420400-121 OVERTIME 27,617 60,000 32,383 54% 1000-416-420400-153 HEALTH INSURANCE 75,146 443,566 368,420 83% 1000-416-420400-155 RETIREMENT 58,633 355,470 296,837 84% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 2,454 5,300 2,846 54% 1000-416-420400-218 EQUIPMENT (Non Capital) 2,339 32,500 30,161 93% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 1,108 24,000 22,892 95% 1000-416-420400-224 JANITORIAL SUPPLIES 1,840 6,000 4,160 69% 1000-416-420400-231 GAS 4,145 24,000 19,855 83% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 1,300 19,025 17,725 93% 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 2,505 5,500 2,995 54% 1000-416-420400-354 CONTRACT SERVICES 22,872 80,000 57,128 71% 1000-416-420400-362 EQUIPMENT MAINTENANCE 717 6,800 6,083 89% 1000-416-420400-366 BUILDING MAINTENANCE-STATION 62 329 16,000 15,671 98% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 806 5,500 4,694 85% 1000-416-420400-373 DUES & TRAINING 1,957 28,000 26,043 93% 1000-416-420400-388 FIREFIGHTER PHYSICALS 8,310 40,000 31,690 79% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 11,453 34,359 22,906 67% 1000-416-420400-610 DEBT RETIREMENT-FIRE TRUCK 24,020 70,791 46,771 66% 1000-416-420400-620 INTEREST EXPENSE-FIRE TRUCK 7,240 27,537 20,297 74% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 222,500 890,000 667,500 75% 1000-416-420400-940 CAPITAL EQUIPMENT-VEHICLE/SCBA/SERV 0 120,000 120,000 100% 1000-416-420440-110 SALARIES-FIRE PREVENTION 6,490 30,008 23,518 78% 1000-416-420440-153 HEALTH INSURANCE 970 0 970- 0% 1000-416-420440-155 RETIREMENT 542 0 542- 0% ------------------------------------------------- SUBTOTAL FIRE DEPT. 957,076 4,880,704 3,923,628 80% ------------------------------------------------- GRAND TOTAL GENERAL FUND 3,784,902 15,679,664 11,894,762 76% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 9 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SPECIAL REVENUE FUNDS: 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 24,760 1,350,000 1,325,240 98% 2215-000-311200-000 PERSONAL PROPERTY TAXES 18,736 24,675 5,939 24% 2215-000-312000-000 PEN & INTEREST DEL TAXES 1,204 1,500 296 20% 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 14,640 24,000 9,360 39% 2215-000-346051-000 RECREATION FEES 5,362 47,444 42,082 89% 2215-000-346052-000 SPORTS PROGRAMS 38,982 108,882 69,900 64% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 10 3,200 3,190 100% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 24,021 103,500 79,480 77% 2215-000-346055-000 ICE RINK 0 23,000 23,000 100% 2215-000-346056-000 KIDSPORT USAGE 0 1,800 1,800 100% 2215-000-346057-000 YOUTH CAMPS 10,900 259,712 248,812 96% 2215-000-346059-000 PICNIC IN THE PARK 14,349 26,500 12,151 46% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-371010-000 INVESTMENTS 7,281 15,000 7,719 51% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 0 115,000 115,000 100% ------------------------------------------------- TOTAL PARKS & REC REVENUE 265,398 2,435,213 2,169,815 89% ================================================= PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES-PARKS 95,823 446,804 350,981 79% 2215-436-460430-111 SEASONAL SALARIES 19,230 69,137 49,907 72% 2215-436-460430-121 OVERTIME 0 300 300 100% 2215-436-460430-153 HEALTH INSURANCE 10,746 71,991 61,245 85% 2215-436-460430-155 RETIREMENT 9,695 36,569 26,874 73% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 1,727 3,700 1,973 53% 2215-436-460430-215 EQUIPMENT - not capital 8,958 29,000 20,042 69% 2215-436-460430-224 JANITORIAL SUPPLIES 2,898 7,200 4,302 60% 2215-436-460430-229 OTHER SUPPLIES 1,355 10,000 8,645 86% 2215-436-460430-231 GAS 6,099 30,000 23,901 80% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 163 3,000 2,837 95% 2215-436-460430-320 PRINTING & ADVERTISING 198 200 2 1% 2215-436-460430-341 ELECTRICITY 2,812 13,500 10,688 79% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 0 23,000 23,000 100% 2215-436-460430-344 NATURAL GAS 153 2,950 2,797 95% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 468 2,700 2,232 83% 2215-436-460430-351 SPORTS COURT & SPORT MAINTENANCE 0 7,550 7,550 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 2,500 2,500 100% 2215-436-460430-355 CONTRACT SERV. TRAIL MAINT/WEED CON 0 15,000 15,000 100% 2215-436-460430-356 CONSULTANTS - PRELIMINARY DESIGN HW 0 50,000 50,000 100% 2215-436-460430-357 CONSULTANTS - PARKS MASTER PLAN 0 100,000 100,000 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 270 8,500 8,230 97% 2215-436-460430-364 LANDSCAPE MATERIALS, PERENNIALS & R 772 6,000 5,228 87% 2215-436-460430-367 VANDALISM REPAIRS 898 4,500 3,602 80% 2215-436-460430-373 DUES & TRAINING 1,455 9,000 7,545 84% 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 10 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 0 600 600 100% 2215-436-460430-395 EQUIPMENT RENTAL 0 700 700 100% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 58 6,500 6,442 99% 2215-436-460430-440 IRRIGATION SUPPLIES 1,548 6,000 4,452 74% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 570 2,000 1,430 72% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 11,795 35,386 23,591 67% 2215-436-460430-545 COUNTY LANDFILL 0 6,273 6,273 100% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 10,188 24,841 14,653 59% 2215-436-460430-620 DEBT SERVICE INTEREST 1,385 2,202 817 37% 2215-436-460430-910 LAND 0 50,000 50,000 100% ------------------------------------------------- SUBTOTAL PARKS EXPENDITURES 189,263 1,087,603 898,340 83% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES-COMPLEX 30,768 140,811 110,043 78% 2215-436-460440-111 SEASONAL SALARIES 24,628 61,926 37,298 60% 2215-436-460440-121 OVERTIME 0 300 300 100% 2215-436-460440-153 HEALTH INSURANCE 4,752 30,358 25,606 84% 2215-436-460440-155 RETIREMENT 4,140 11,272 7,132 63% 2215-436-460440-221 SAFETY EQUIPMENT 67 300 233 78% 2215-436-460440-229 OTHER SUPPLIES 13,353 22,000 8,647 39% 2215-436-460440-231 GAS 3,756 13,000 9,244 71% 2215-436-460440-241 CONSUMABLE TOOLS 54 850 796 94% 2215-436-460440-341 ELECTRICITY 3,922 12,000 8,078 67% 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 0 1,500 1,500 100% 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 0 2,000 2,000 100% 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 0 300 300 100% 2215-436-460440-395 RENTAL EQUIPMENT 0 200 200 100% 2215-436-460440-420 METAL PRODUCTS 0 7,500 7,500 100% 2215-436-460440-440 IRRIGATION 5,310 7,000 1,690 24% 2215-436-460440-452 SAND & GRAVEL 279 1,500 1,221 81% 2215-436-460440-521 CENTRAL GARAGE TRANSFER 2,738 8,215 5,477 67% 2215-436-460440-545 COUNTY LANDFILL 0 3,500 3,500 100% 2215-436-460440-610 DEBT SERVICE - PRINCIPAL 0 10,000 10,000 100% 2215-436-460440-620 DEB SERVICE - INTEREST 141 2,875 2,734 95% ------------------------------------------------- SUBTOTAL ATHLETIC COMPLEX 93,970 340,067 246,097 72% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES-RECREATION 25,608 111,244 85,636 77% 2215-436-460431-111 SEASONAL SALARIES 4,544- 38,792 43,336 112% 2215-436-460431-153 HEALTH INSURANCE 2,477 21,604 19,127 89% 2215-436-460431-155 RETIREMENT 2,132 9,136 7,004 77% 2215-436-460431-229 MISC. SUPPLIES 3,554 19,550 15,996 82% 2215-436-460431-231 GAS 114 676 562 83% 2215-436-460431-320 PRINTING & ADVERTISING 766 7,850 7,084 90% 2215-436-460431-345 TELEPHONE & COMMUNICATION 409 855 446 52% 2215-436-460431-353 ONLINE REGISTRATION 1,876 3,869 1,993 52% 2215-436-460431-354 CONTRACT SERVICES 27,602 43,099 15,497 36% 2215-436-460431-355 BANK FEES/CREDIT CARD CHARGES 0 3,309 3,309 100% 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 11 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460431-357 MUSIC FRANCHISE FEES 0 1,400 1,400 100% 2215-436-460431-373 DUES & TRAINING 299 1,500 1,201 80% ------------------------------------------------- SUBTOTAL RECREATION 60,291 262,884 202,593 77% YOUTH CAMPS 2215-436-460448-110 SALARIES-YOUTH CAMPS 22,290 97,681 75,391 77% 2215-436-460448-111 SEASONAL SALARIES 111,270 240,979 129,709 54% 2215-436-460448-121 OVERTIME 233 150 83- -56% 2215-436-460448-153 HEALTH INSURANCE 2,322 20,168 17,846 88% 2215-436-460448-155 RETIREMENT 1,858 8,025 6,167 77% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 40 300 260 87% 2215-436-460448-229 MISC. SUPPLIES 960 5,025 4,065 81% 2215-436-460448-231 GAS 0 532 532 100% 2215-436-460448-320 PRINTING & ADVERTISING 0 355 355 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 319 2,640 2,321 88% 2215-436-460448-353 ONLINE REGISTRATION 4,592 9,475 4,883 52% 2215-436-460448-354 CONTRACT SERVICES 9,015 21,967 12,953 59% 2215-436-460448-355 AFTER SCHOOL PROGRAM 143 1,500 1,357 91% 2215-436-460448-356 BANK FEES/CC CHARGES 772 9,948 9,176 92% 2215-436-460448-373 DUES & TRAINING 299 1,500 1,201 80% ------------------------------------------------- SUBTOTAL YOUTH CAMPS 154,113 420,245 266,132 63% PARKLINE TRAIL MAINTENANCE 2215-436-460457-110 SALARIES - PARK LINE TRAIL 11,921 53,154 41,233 78% 2215-436-460457-111 SALARIES - SEASONAL 9,308 26,866 17,558 65% 2215-436-460457-121 OVERTIME 0 300 300 100% 2215-436-460457-153 HEALTH INSURANCE 1,548 9,857 8,309 84% 2215-436-460457-155 RETIREMENT 1,739 4,395 2,656 60% 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 30 2,000 1,970 99% 2215-436-460457-231 GAS 1,142 4,000 2,858 71% 2215-436-460457-241 TOOLS / SMALL EQUIP / SAFETY EQUIP 73 900 827 92% 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 0 1,000 1,000 100% 2215-436-460457-388 MEDICAL SERVICES - DRUG TESTING 0 100 100 100% 2215-436-460457-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460457-440 IRRIGATION SUPPLIES 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 0 15,800 15,800 100% 2215-436-460457-620 DEBT SERVICE - INTEREST 923 4,543 3,620 80% ------------------------------------------------- SUBTOTAL PARKLINE TRAIL MAINTE 28,105 152,665 124,560 82% POOL 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 12 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-437-460445-111 SEASONAL SALARIES-POOL 167,990 273,320 105,330 39% 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 711 4,000 3,289 82% 2215-437-460445-341 ELECTRICITY 3,523 10,500 6,977 66% 2215-437-460445-344 NATURAL GAS 9,122 30,680 21,558 70% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 5,576 18,555 12,979 70% 2215-437-460445-354 LICENSES & FEES 0 1,835 1,835 100% 2215-437-460445-356 BANK FEES/ CC CHARGES 1,822 6,647 4,825 73% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 5,910 70,540 64,630 92% 2215-437-460445-367 VANDALISM 0 1,000 1,000 100% 2215-437-460445-380 TRAINING MATERIALS 589 1,800 1,211 67% 2215-437-460445-932 EQUIPMENT / POOL IMPROVEMENTS 0 172,000 172,000 100% ------------------------------------------------- SUBTOTAL POOL EXPENDITURES 246,210 676,127 429,917 64% ------------------------------------------------- TOTAL PARKS & RECREATION/POOL 771,951 2,939,591 2,167,640 74% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 13 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING URBAN FORESTRY 2600-436-460433-110 SALARIES-URBAN FORESTRY 55,713 249,757 194,044 78% 2600-436-460433-111 SEASONAL SERVICES 22,305 61,267 38,962 64% 2600-436-460433-121 OVERTIME 0 1,000 1,000 100% 2600-436-460433-153 HEALTH INSURANCE 8,068 52,695 44,627 85% 2600-436-460433-155 RETIREMENT 5,442 20,612 15,170 74% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 3,136 4,500 1,364 30% 2600-436-460433-231 GAS 1,199 8,500 7,301 86% 2600-436-460433-241 CONSUMABLE TOOLS 653 5,200 4,547 87% 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 155 700 545 78% 2600-436-460433-354 CONTRACT SERVICES 24,345 170,000 145,655 86% 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 518 3,000 2,482 83% 2600-436-460433-364 LANDSCAPING & TREES 0 9,000 9,000 100% 2600-436-460433-373 DUES & TRAINING 0 6,500 6,500 100% 2600-436-460433-388 MEDICAL 170- 400 570 143% 2600-436-460433-395 EQUIPMENT RENTAL 0 8,000 8,000 100% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 6,783 6,783 1 0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 3,423 10,268 6,845 67% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 7,726 23,177 15,451 67% 2600-436-460433-528 INFORMATION TECHNOLOGY TRANSFER 3,833 11,550 7,717 67% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 0 16,000 16,000 100% 2600-436-460433-620 INTEREST EXPENSE 0 4,600 4,600 100% 2600-436-460433-940 MACHINERY & EQUIPMENT 0 71,634 71,634 100% ------------------------------------------------- TOTAL URBAN FORESTRY 165,128 790,143 625,015 79% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 14 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 86,315 500,000 413,685 83% 2230-000-342070-000 COUNTY EMS LEVY 0 160,000 160,000 100% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 222,500 890,000 667,500 75% ------------------------------------------------- TOTAL AMBULANCE REVENUE 308,815 1,550,000 1,241,185 80% ================================================= AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 164,024 824,009 659,985 80% 2230-440-420730-113 KELLY DAYS 60 0 60- 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 48,899 30,000 18,899- -63% 2230-440-420730-153 HEALTH INSURANCE 33,726 139,951 106,225 76% 2230-440-420730-155 RETIREMENT 23,093 107,145 84,052 78% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 15 3,400 3,385 100% 2230-440-420730-218 NON-CAPITAL EQUIPMENT 0 4,800 4,800 100% 2230-440-420730-231 GAS & OIL 2,721 13,000 10,279 79% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 358 5,500 5,142 93% 2230-440-420730-312 POSTAGE/PRINTING 70 1,000 930 93% 2230-440-420730-345 TELEPHONE & COMMUNICATION 1,034 2,000 966 48% 2230-440-420730-354 CONTRACT SERVICES 1,979 32,800 30,821 94% 2230-440-420730-359 COLLECTION SERV. / CC FEES / AUDIT 925 5,300 4,375 83% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 0 5,500 5,500 100% 2230-440-420730-373 DUES & TRAINING 3,807 16,500 12,693 77% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,000 2,000 100% 2230-440-420730-391 MEDICAL TREATMENT-SUPPLIES 11,949 62,000 50,051 81% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 14,605 15,480 875 6% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 6,665 19,995 13,330 67% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 16,292 48,877 32,585 67% 2230-440-420730-528 INFORMATION TECHNOLOGY TRANSFER 15,333 46,198 30,865 67% 2230-440-420730-610 PRINCIPAL - AMBULANCE 18,832 37,877 19,045 50% 2230-440-420730-620 INTEREST - AMBULANCE 3,309 6,673 3,364 50% 2230-440-420730-940 EQUIPMENT 0 105,401 105,401 100% ------------------------------------------------- TOTAL AMBULANCE EXPENDITURES 367,697 1,542,206 1,174,509 76% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 15 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC SAFETY IMPACT FEE REV 2399-000-341072-000 POLICE IMPACT FEES 3,225 20,000 16,775 84% 2399-000-341073-000 FIRE IMPACT FEES 43,644 250,000 206,356 83% 2399-000-371010-000 INVESTMENT EARNINGS 13,202 20,000 6,798 34% ------------------------------------------------- TOTAL PS IMPACT FEE REV 60,071 290,000 229,929 79% ================================================= PUBLIC SAFETY IMPACT FEE EXP 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 5,000 15,000 10,000 67% 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 PS IMPACT FEE EXP 5,000 2,015,000 2,010,000 100% ================================================= FIRE & HAZMAT GRANTS 2956-416-420400-218 RESCUE EQUIPMENT - TOWNPUMP GRANT 4,950 6,000 1,050 18% 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 3,465 5,000 1,535 31% ------------------------------------------------- TOTAL FIRE GRANTS 8,415 11,000 2,585 24% ================================================= 2957-416-420410-125 PASS THRU HAZMAT OT 553 5,000 4,447 89% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 234 10,000 9,766 98% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 3,000 3,000 100% ------------------------------------------------- TOTAL HAZMAT GRANT 787 18,000 17,213 96% ================================================= 2958-416-420455-240 OTHER SUPPLIES AND EQUIPMENT 20,629 21,061 432 2% ------------------------------------------------- TOTAL HAZMAT EQUIP. SUSTAINMEN 20,629 21,061 432 2% ================================================= SAFER GRANT ------------------------------------------------- TOTAL SAFER GRANT 0 0 0 0% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 16 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 203,752 750,000 546,248 73% 2394-000-323103-000 PLUMBING PERMITS 13,061 65,000 51,939 80% 2394-000-323104-000 MECHANICAL PERMITS 24,496 65,000 40,504 62% 2394-000-323105-000 ELECTRICAL PERMITS 25,548 65,000 39,452 61% 2394-000-323108-000 PLAN REVIEW FEES 66,593 325,000 258,407 80% 2394-000-371010-000 INVESTMENT EARNINGS 16,829 20,000 3,171 16% ------------------------------------------------- TOTAL REVENUE 350,279 1,290,000 939,721 73% ================================================= BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES-BUILDING DEPT. 166,595 760,854 594,259 78% 2394-420-420530-112 SALARIES-SEVERANCE 0 33,559 33,559 100% 2394-420-420530-121 OVERTIME 7,645 20,000 12,355 62% 2394-420-420530-153 HEALTH INSURANCE 18,729 120,189 101,460 84% 2394-420-420530-155 RETIREMENT 14,417 60,858 46,441 76% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 24,722 55,360 30,638 55% 2394-420-420530-231 GAS & OIL 772 6,000 5,228 87% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 1,981 7,500 5,519 74% 2394-420-420530-323 ST. ED. ASSESSMENTS 0 7,500 7,500 100% 2394-420-420530-345 TELEPHONE & COMMUNICATION 2,027 8,000 5,973 75% 2394-420-420530-353 AUDITING 0 5,500 5,500 100% 2394-420-420530-354 CONTRACT SERVICES 0 40,000 40,000 100% 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 3,854 17,500 13,646 78% 2394-420-420530-360 FURNITURE 190 7,500 7,310 97% 2394-420-420530-373 DUES & TRAINING 499 30,000 29,501 98% 2394-420-420530-510 PROPERTY INSURANCE 13,657 13,657 0 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 688 2,063 1,375 67% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 14,011 42,034 28,023 67% 2394-420-420530-528 INFORMATION TECHNOLOGY TRANSFER 36,893 110,928 74,035 67% ------------------------------------------------- TOTAL BUILDING DEPT. 336,960 1,383,002 1,046,042 76% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 17 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 23,691 104,172 80,481 77% 2400-410-430263-153 HEALTH INSURANCE 4,048 25,949 21,901 84% 2400-410-430263-155 RETIREMENT 1,944 8,418 6,474 77% 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 29,612 182,000 152,388 84% 2400-410-430263-360 REPAIR & MAINT SERVICES 2,768 22,500 19,732 88% 2400-410-430263-373 DUES & TRAINING 0 4,000 4,000 100% 2400-410-430263-510 INSURANCE 2,171 2,171 0- -0% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 4,550 13,649 9,099 67% 2400-410-430263-528 INFORMATION TECH TRANSFER 8,591 25,824 17,233 67% 2400-410-430265-944 MACHINERY & EQUIP (replacement fund 68,185 88,000 19,815 23% ------------------------------------------------- TOTAL LIGHT MAINT. 147,669 525,683 378,014 72% ================================================= 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 3,028 104,071 101,043 97% 2420-421-430234-957 ALLEY PAVING 54,150 73,540 19,390 26% 2420-421-430240-231 GAS & OIL 8,690 71,000 62,310 88% 2420-421-430240-344 NATURAL GAS 91 6,500 6,409 99% 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 7,525 83,000 75,475 91% 2420-421-430240-472 ASPHALT 1,343 50,000 48,657 97% 2420-421-430240-473 CRACK SEALING 13,365 20,000 6,635 33% 2420-421-430240-474 PAINT STRIPING MATERIALS 7,009 30,000 22,991 77% ------------------------------------------------- TOTAL GAS TAX 1,040,455 4,284,875 3,244,420 76% ================================================= BARSAA (GAS TAX) 2421-421-430240-354 PAVEMENT MAINTENANCE 396,896 1,825,506 1,428,610 78% ------------------------------------------------- TOTAL BARSAA 396,896 1,825,506 1,428,610 78% ================================================= 2825 MACI GRANT 2825-421-430240-940 EQUIPMENT 0 336,629 336,629 100% ------------------------------------------------- TOTAL MACI GRANT 0 336,629 336,629 100% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 18 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500 STREET MAINT. & SIGNS STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 237,752 1,107,150 869,398 79% 2500-421-430240-121 OVERTIME 106 28,000 27,894 100% 2500-421-430240-153 HEALTH INSURANCE 28,807 198,072 169,265 85% 2500-421-430240-155 RETIREMENT 19,277 88,813 69,536 78% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 6,910 26,500 19,590 74% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 620 7,000 6,380 91% 2500-421-430240-220 OTHER SUPPLIES 453 5,000 4,547 91% 2500-421-430240-231 GAS & OIL 9,014 73,000 63,986 88% 2500-421-430240-341 ELECTRICITY 398 4,000 3,602 90% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 1,143 4,800 3,657 76% 2500-421-430240-353 AUDITING 0 1,920 1,920 100% 2500-421-430240-354 CONTRACT SERVICES 2,431 25,000 22,569 90% 2500-421-430240-356 CONSULTANT REVIEWS 796 30,000 29,204 97% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 5,464 57,000 51,536 90% 2500-421-430240-366 BUILDING MAINTENANCE 120 5,000 4,880 98% 2500-421-430240-373 DUES & TRAINING 798 14,000 13,202 94% 2500-421-430240-388 MEDICAL SERVICES 215 1,000 785 79% 2500-421-430240-510 LIABILITY INSURANCE 46,228 46,229 1 0% 2500-421-430240-512 UNINSURED LOSS-DEDUCTIBLE 519,247- 45,000 564,247 1,254% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 62,758 188,274 125,516 67% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 32,897 98,690 65,793 67% 2500-421-430240-528 INFORMATION TECHNOLOGY TRANSFER 16,385 49,305 32,920 67% 2500-421-430240-610 DEBT SERVICE - PRINCIPAL 20,599 41,328 20,729 50% 2500-421-430240-620 DEBT SERVICE - INTEREST 6,072 12,245 6,173 50% 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 0 27,729 27,729 100% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 0 11,406 11,406 100% 2500-421-430244-354 PAVEMENT REPAIRS-PAVEMENT MNT FUNDS 8,312 380,000 371,688 98% 2500-421-430244-820 TRANSFER TO BaRSAA 0 33,000 33,000 100% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 0 220,100 220,100 100% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 15,652 15,652 100% ------------------------------------------------- TOTAL STREET MAINT. 11,692- 2,869,383 2,881,075 100% ------------------------------------------------- SIGNS AND SIGNALS 2500-421-430264-110 TSS - SALARIES 28,129 124,698 96,569 77% 2500-421-430264-121 OVERTIME 0 7,500 7,500 100% 2500-421-430264-153 HEALTH INSURANCE 4,771 28,979 24,208 84% 2500-421-430264-155 RETIREMENT 2,273 9,946 7,673 77% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 819 5,960 5,141 86% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 126 8,000 7,874 98% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 103 4,500 4,397 98% 2500-421-430264-242 STREET SIGNS 13,817 30,000 16,183 54% 2500-421-430264-243 TRAFFIC SIGNALS 1,440 50,549 49,109 97% 2500-421-430264-245 BARRICADE MATERIALS 0 6,000 6,000 100% 2500-421-430264-341 ELECTRICITY 219 3,000 2,781 93% 2500-421-430264-345 COMMUNICATIONS 275 1,350 1,075 80% 2500-421-430264-354 CONTRACT SERVICES 473 10,000 9,527 95% 2500-421-430264-362 EQUIPMENT MAINTENANCE 641 3,000 2,359 79% 2500-421-430264-366 BUILDING MAINTENANCE 2,145 8,000 5,855 73% 2500-421-430264-373 DUES & TRAINING 200 7,500 7,300 97% 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 19 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 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 1,703 5,110 3,407 67% ------------------------------------------------- TOTAL SIGNS AND SIGNALS 60,937 323,942 263,005 81% ------------------------------------------------- TOTAL STREET MAINT. & SIGNS 49,244 3,193,325 3,144,081 98% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 20 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2188 WESTSIDE TIF REVENUE 2188-000-371010-000 INVESTMENT EARNINGS 4,565 5,000 435 9% 2188-000-373010-000 INTEREST / LOANS 4,110 13,023 8,913 68% 2188-000-373020-000 PRINCIPAL / LOANS 4,209 20,253 16,044 79% 2188-000-383005-000 TRANSFER FROM DEBT SERVICE (3188) 0 1,600,000 1,600,000 100% ------------------------------------------------- TOTAL REVENUE 12,884 1,638,276 1,625,392 99% ================================================= EXPENDITURES 2188-480-470230-110 SALARIES 8,850 39,663 30,813 78% 2188-480-470230-153 HEALTH INSURANCE 849 5,448 4,599 84% 2188-480-470230-155 RETIREMENT 745 3,267 2,522 77% 2188-480-470230-353 AUDIT 0 1,800 1,800 100% 2188-480-470230-356 TELEPHONE 42 192 150 78% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 512 1,535 1,023 67% 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 0 4,000,000 4,000,000 100% ------------------------------------------------- TOTAL WESTSIDE TIF 10,997 4,051,905 4,040,908 100% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 21 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2185 AIRPORT TIF 2185-000-430300-840 REDEVELOPMENT ACTIVITY 0 184,954 184,954 100% ------------------------------------------------- TOTAL 2185 AIRPORT TIF 0 184,954 184,954 100% ================================================= OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 10,000 10,000 100% 2310-480-470210-356 FED-EX REIMBURSEMENT 0 10,000 10,000 100% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 16,667 50,000 33,333 67% 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 2,000 6,000 4,000 67% ------------------------------------------------- TOTAL OLD SCHOOL TIFS 18,667 76,000 57,333 75% ================================================= GLACIER RAIL PARK TEDD 2312-480-470210-110 SALARIES & WAGES 1,265 5,816 4,552 78% 2312-480-470210-153 HEALTH INSURANCE 121 935 814 87% 2312-480-470210-155 RETIREMENT 106 483 377 78% 2312-480-470210-345 TELEPHONE 6 48 42 88% 2312-480-470210-353 AUDIT 0 1,800 1,800 100% 2312-480-470210-522 ADMINISTRATIVE TRANSFER 512 1,535 1,023 67% 2312-480-470210-795 REDEVELOPMENT - FCEDA REIMB. 0 75,000 75,000 100% 2312-480-470210-796 REDEVELOPMENT/SIDEWALK 0 200,000 200,000 100% ------------------------------------------------- TOTAL GLACIER RAIL PARK TEDD 2,010 285,617 283,607 99% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 22 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 0 1,200 1,200 100% 2880-480-470210-354 CONTRACT SERVICES 40 1,500 1,460 97% 2880-480-470210-711 REDEVELOPMENT 0 80,000 80,000 100% ------------------------------------------------- TOTAL LOAN REVOLVING 40 82,700 82,660 100% ================================================= 2881 CD LOAN REV. #2 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 0 475 475 100% 2881-480-470210-711 REDEVELOPMENT 0 100,000 100,000 100% ------------------------------------------------- TOTAL 2881 CD REV. #2 0 100,475 100,475 100% ================================================= 2886 CD MISC. 2886-480-470210-790 REDEVELOPMENT ACTIVITY 0 28,087 28,087 100% 2886-480-470210-810 TRANSFER TO WS TIF 0 250,000 250,000 100% ------------------------------------------------- TOTAL CD MISC. 0 278,087 278,087 100% ================================================= 2887 RURAL DEVELOPMENT #1 2887-480-470210-354 CONT SERV (LOAN SOFTWARE) 0 475 475 100% 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 0 19,590 19,590 100% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 0 2,484 2,484 100% 2887-480-470210-750 REDEVELOPMENT LOANS 0 180,000 180,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #1 0 202,549 202,549 100% ================================================= 2888 RURAL DEVELOPMENT #2 2888-480-470210-354 CONT SERV (LOAN SOFTWARE) 0 500 500 100% 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 0 8,725 8,725 100% 2888-480-470210-620 INTEREST EXPENSE-USDA LOAN 61-03 0 1,300 1,300 100% 2888-480-470210-750 REDEVELOPMENT LOANS 0 279,000 279,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #2 0 289,525 289,525 100% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 23 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2945 SAMARITAN HOUSE GRANT ------------------------------------------------- TOTAL SAMARITAN HOUSE GRANT 0 0 0 0% 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% ================================================= 2991 TIGER GRANT ------------------------------------------------- TOTAL TIGER GRANT 0 394,187 394,187 100% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 24 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD 0 16,050 16,050 100% 2915-413-420140-218 SMALL EQUIP -Stonegarden 0 29,000 29,000 100% ------------------------------------------------- TOTAL 2915 STONEGARDEN GRANT 0 45,050 45,050 100% ================================================= 2916 DRUG ENFORECMENT 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 2916 DRUG ENFORCEMENT 26,866 119,830 92,964 78% ================================================= 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 221 3,000 2,779 93% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 2,586 35,000 32,414 93% 2919-413-420140-127 SCHOOL DIST. OT 3,592 17,000 13,408 79% 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 4,677 10,523 5,846 56% 2919-413-420140-373 TRAINING - FORFEITURE FUNDS 1,184 1,000 184- -18% ------------------------------------------------- TOTAL LAW ENF. GRANT 12,260 89,023 76,763 86% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 25 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CAPITAL PROJECT FUNDS 4393 AMERICAN RESCUE PLAN GRAN 4393-410-430550-950 LRF PROJECT - L.S. #3 RECOVERY ACT 0 4,720,305 4,720,305 100% 4393-410-430550-951 DOWNTOWN WTR/SWR MAIN ARPA PROJECT 462,612 712,742 250,130 35% ------------------------------------------------- TOTAL AMERICAN RESCUE PLAN GRA 462,612 5,433,047 4,970,435 91% 4170 IMPOUND/STORAGE FACILITY ------------------------------------------------- TOTAL IMPOUND/STORAGE FACILITY 0 0 0 0% 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION 0 25,000 25,000 100% ------------------------------------------------- TOTAL 4290 WALK & CURB 0 25,000 25,000 100% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 26 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ENTERPRISE FUNDS WATER REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 3,545 2,000 1,545- -77% 5210-000-343210-000 METERED WATER SALES 2,361,130 4,718,000 2,356,870 50% 5210-000-343220-000 OTHER (CONST.) WATER SALES 8,628 25,000 16,372 65% 5210-000-343230-000 METER REPLACEMENT FEE 65,332 175,000 109,668 63% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 7,303 71,000 63,697 90% 5210-000-343270-000 WATER TURN ON FEES 1,550 4,000 2,450 61% 5210-000-343275-000 TAG FEE 11,460 33,000 21,540 65% 5210-000-343365-000 LATECOMER ADMIN FEE 3,590 10,000 6,410 64% 5210-000-371010-000 INVESTMENT EARNINGS 81,821 100,000 18,179 18% 5210-000-371500-000 LEASE INTEREST INCOME 22,121 0 22,121- 0% 5210-000-383010-000 TRANSFER FROM IMPACT FEE FUND (ADMI 8,333 25,000 16,667 67% 5210-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 83,333 250,000 166,667 67% ------------------------------------------------- TOTAL WATER REVENUE 2,658,147 5,413,000 2,754,853 51% ================================================= WATER FACILITIES 5210-447-430550-110 SALARIES-WATER 203,189 988,404 785,215 79% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 6,912 20,000 13,088 65% 5210-447-430550-153 HEALTH INSURANCE 27,877 186,588 158,711 85% 5210-447-430550-155 RETIREMENT 16,915 79,471 62,556 79% 5210-447-430550-210 OFFICE SUPPLIES /EQUIP/COMPUTERS/GI 5,556 24,500 18,944 77% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 307 9,000 8,693 97% 5210-447-430550-226 CHLORINE & CHEMICALS 12,323 85,000 72,678 86% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 824 4,650 3,826 82% 5210-447-430550-231 GAS & OIL 10,107 40,000 29,893 75% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 39 1,000 961 96% 5210-447-430550-336 LICENSES & FEES 0 20,000 20,000 100% 5210-447-430550-341 ELECTRICITY 48,266 175,000 126,734 72% 5210-447-430550-344 NATURAL GAS 612 16,000 15,388 96% 5210-447-430550-345 TELEPHONE & COMMUNICATION 2,904 15,500 12,596 81% 5210-447-430550-349 LAB SERVICES 6,487 30,000 23,513 78% 5210-447-430550-352 CONTRACT SERVICES - HOSTING FEES 5,589 30,000 24,411 81% 5210-447-430550-353 AUDITING 0 4,200 4,200 100% 5210-447-430550-354 CONTRACT SERVICES 2,611 56,000 53,389 95% 5210-447-430550-355 NOFFSINGER TRANSMISSION CONDITION A 8,593 68,854 60,261 88% 5210-447-430550-356 WTR RIGHTS/ MODELING/ REVIEWS/ RATE 0 185,000 185,000 100% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 367 15,000 14,633 98% 5210-447-430550-366 BUILDING MAINTENANCE 101 15,000 14,899 99% 5210-447-430550-373 DUES & TRAINING 772 14,000 13,228 94% 5210-447-430550-388 MEDICAL SERVICES 180 700 520 74% 5210-447-430550-410 CONSTRUCTION MATERIALS 11,860 50,000 38,140 76% 5210-447-430550-422 HYDRANTS 4,040 10,000 5,960 60% 5210-447-430550-423 MATERIALS FOR MAINS 704 16,000 15,296 96% 5210-447-430550-424 MATERIALS -SERVICE LINES 2,093 20,000 17,907 90% 5210-447-430550-425 MATERIALS PUMPS/WELLS (CARRY/NEW) 48,217 147,326 99,109 67% 5210-447-430550-510 PROPERTY & LIABILITY INS. 46,801 46,801 0 0% 5210-447-430550-512 UNINSURED LOSS-DEDUCTIBLE 0 10,000 10,000 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 15,391 46,173 30,782 67% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 45,621 136,863 91,242 67% 5210-447-430550-528 INFORMATION TECH TRANSFER 29,704 90,191 60,487 67% 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 27 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-532 LEASE PAYMENTS 0 4,000 4,000 100% 5210-447-430550-925 N MAIN WELL-NOFFSINGER REPLC (CARRY 120,033 2,151,456 2,031,423 94% 5210-447-430550-935 METER SYSTEM REPLACEMENT (CARRY/NEW 63,284 466,316 403,032 86% 5210-447-430550-940 MACHINERY & EQUIPMENT (CARRY/NEW) 45,337 380,000 334,663 88% 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 0 350,000 350,000 100% 5210-447-430550-954 ELEVATED STORAGE TANK & WELL (CARRY 0 750,956 750,956 100% 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 0 2,450,969 2,450,969 100% 5210-447-430550-970 DESIGN-NORTHWEST WELL #2 (CARRY) 0 307,000 307,000 100% 5210-447-430551-954 1 MG STORAGE TANK & WELLS (BONDED) 3,881,970 18,439,992 14,558,022 79% 5210-447-430551-969 LOWER ZONE RESERVOIRS ROOF REPLC (B 0 11,715,000 11,715,000 100% ------------------------------------------------- SUBTOTAL WATER FACILITIES 4,677,027 39,937,910 35,260,883 88% ------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES-WATER BILLING 33,671 152,289 118,618 78% 5210-447-430560-153 HEALTH INSURANCE 4,775 46,180 41,405 90% 5210-447-430560-155 RETIREMENT 2,807 12,549 9,742 78% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 520 10,500 9,980 95% 5210-447-430560-353 AUDITING 0 2,500 2,500 100% 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 14,122 55,000 40,878 74% 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 5,860 38,000 32,140 85% 5210-447-430560-356 OTHER CONTRACT SERVICES 394 1,000 607 61% 5210-447-430560-373 DUES & TRAINING 652 4,000 3,348 84% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 4,398 13,194 8,796 67% 5210-447-430560-528 INFORMATION TECH TRANSFER 26,832 80,847 54,015 67% ------------------------------------------------- SUBTOTAL WATER BILLING 94,030 416,059 322,029 77% ------------------------------------------------- REVENUE BONDS 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% 5210-447-490250-620 INT-WTR STORAGE TANK/WELL WRF - 2.5 0 566,188 566,188 100% ------------------------------------------------- SUBTOTAL REVENUE BONDS 92,119 1,907,902 1,815,783 95% ------------------------------------------------- DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 950,000 950,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 950,000 950,000 100% 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 28 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ------------------------------------------------- TOTAL WATER FUND 4,863,176 43,211,871 38,348,695 89% ================================================= WATER IMPACT FEE REVENUE: 5211-000-343225-000 IMPACT FEES 159,546 500,000 340,454 68% 5211-000-371010-000 INTEREST EARNINGS 6,323 10,000 3,677 37% ------------------------------------------------- TOTAL WATER IMPACT FEES REVENU 165,869 510,000 344,131 67% ================================================= WATER IMPACT FEES EXPENSES: 5211-447-430555-424 METERS - NEW DEVELOPMENT 25,643 73,552 47,909 65% 5211-447-430555-820 DEBT SERVICE TRANSFER TO 5210 83,333 250,000 166,667 67% 5211-447-430555-825 TRANSFER TO 5210 FOR ADMIN 8,333 25,000 16,667 67% 5211-447-430555-930 CONTRACT MAIN UPSIZE 0 753,394 753,394 100% 5211-447-430555-954 ELEVATED TANK & WELL 65,566 85,666 20,100 23% ------------------------------------------------- TOTAL WATER IMPACT FEE EXPENSE 182,876 1,187,612 1,004,736 85% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 29 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 3,545 1,500 2,045- -136% 5310-000-343310-000 SEWER SERVICE CHARGES 2,253,467 8,016,040 5,762,573 72% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 0 1,500 1,500 100% 5310-000-343365-000 LATECOMER ADMIN FEES 2,348 2,000 348- -17% 5310-000-371010-000 INVESTMENT EARNINGS 80,391 75,000 5,391- -7% 5310-000-383010-000 ADMIN TRANSFER FROM IMPACT FEE FUND 33,333 100,000 66,667 67% 5310-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 433,333 1,300,000 866,667 67% ------------------------------------------------- TOTAL SEWER REVENUE 2,806,417 9,496,040 6,689,623 70% ================================================= SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES-SEWER BILLING 29,346 130,037 100,691 77% 5310-454-430620-153 HEALTH INSURANCE 4,110 24,109 19,999 83% 5310-454-430620-155 RETIREMENT - PERD 2,444 10,661 8,217 77% 5310-454-430620-215 OFFICE SUPPLIES/computers 520 10,500 9,980 95% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 0 2,500 2,500 100% 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 14,122 55,000 40,878 74% 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 5,860 38,000 32,140 85% 5310-454-430620-356 OTHER CONTRACT SERVICES 394 1,000 607 61% 5310-454-430620-373 DUES & TRAINING 0 4,000 4,000 100% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 4,159 12,476 8,317 67% 5310-454-430620-528 INFORMATION TECH. TRANSFER 26,832 80,847 54,015 67% ------------------------------------------------- SUBTOTAL SEWER BILLING COSTS 87,786 369,130 281,344 76% ------------------------------------------------- SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES-SANITARY SEWER 88,906 416,234 327,328 79% 5310-454-430630-121 OVERTIME 113 5,500 5,387 98% 5310-454-430630-153 HEALTH INSURANCE 10,454 81,817 71,363 87% 5310-454-430630-155 RETIREMENT 7,271 33,581 26,310 78% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 7,521 15,800 8,279 52% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 1,250 8,500 7,250 85% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 641 2,500 1,859 74% 5310-454-430630-231 GAS & OIL 1,641 19,000 17,359 91% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 0 500 500 100% 5310-454-430630-341 ELECTRICITY 6,960 57,000 50,040 88% 5310-454-430630-344 NATURAL GAS 2,705 18,000 15,295 85% 5310-454-430630-345 TELEPHONE & COMMUNICATION 8,758 27,500 18,742 68% 5310-454-430630-353 AUDITING 0 3,600 3,600 100% 5310-454-430630-354 CONTRACT SERVICES 1,158 45,000 43,842 97% 5310-454-430630-355 CONTRACT SERVICES - EVERGREEN MTR R 5,316 36,000 30,684 85% 5310-454-430630-356 CONSULTANTS - MODELING/REVIEWS 0 20,000 20,000 100% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 91 11,500 11,409 99% 5310-454-430630-373 DUES & TRAINING 912 10,250 9,338 91% 5310-454-430630-388 MEDICAL SERVICES 60 1,000 940 94% 5310-454-430630-410 CONSTRUCTION MATERIALS 3,064 12,000 8,936 74% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 2,592 105,000 102,408 98% 5310-454-430630-510 PROPERTY & LIABILITY INS. 27,941 27,928 13- -0% 5310-454-430630-512 UNINSURED LOSS-DEDUCTIBLE 0 25,000 25,000 100% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 5,135 15,406 10,271 67% 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 30 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-522 ADMINISTRATIVE TRANSFER 25,444 76,333 50,889 67% 5310-454-430630-528 INFORMATION TECH TRANSFER 17,982 54,095 36,113 67% 5310-454-430630-532 OFFICE RENT / BNSF LEASE 7,309 7,000 309- -4% 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 192,728 192,728 100% 5310-454-430630-951 5TH ALLEY E, 4TH AVE EN, 7TH AVE EN 569,229 748,250 179,021 24% 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 0 10,000 10,000 100% 5310-454-430630-958 DESIGN - L.S. #3 IMPROVEMENTS 5,124 336,087 330,963 98% 5310-454-430630-959 L.S. #10 CONTROL PANEL RELOCATION & 5,635 12,898 7,263 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% 5310-454-430631-922 L.S. #9 IMPROVMENTS 191,878 1,012,880 821,002 81% 5310-454-430631-958 L.S. #3 IMPROVEMENTS 0 3,020,000 3,020,000 100% ------------------------------------------------- SUBTOTAL SEWER COLLECTION 1,033,110 8,185,280 7,152,170 87% ------------------------------------------------- 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% ------------------------------------------------- SUBTOTAL REVENUE BONDS 265,749 883,751 618,002 70% ------------------------------------------------- DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 900,000 900,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION-SANITARY 0 900,000 900,000 100% ------------------------------------------------- SUBTOTAL SANITARY SEWER 1,298,858 9,969,031 8,670,173 87% ------------------------------------------------- WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 133,385 634,593 501,208 79% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-121 OVERTIME 5,971 22,500 16,529 73% 5310-455-430640-153 HEALTH INSURANCE 15,780 113,292 97,512 86% 5310-455-430640-155 RETIREMENT 11,516 50,951 39,435 77% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 3,011 14,800 11,789 80% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 526 3,500 2,974 85% 5310-455-430640-225 ALUM 0 56,500 56,500 100% 5310-455-430640-226 CHLORINE & CHEMICALS 49,322 186,000 136,678 73% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 1,336 8,000 6,664 83% 5310-455-430640-231 GAS & OIL 6,057 33,000 26,943 82% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 0 550 550 100% 5310-455-430640-336 DEQ PERMITS, LICENSES & FEES 500 16,000 15,500 97% 5310-455-430640-341 ELECTRICITY 33,076 207,500 174,424 84% 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 31 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-342 WATER 1,263 7,000 5,737 82% 5310-455-430640-344 NATURAL GAS 1,825 82,000 80,175 98% 5310-455-430640-345 TELEPHONE & COMMUNICATION 3,329 15,000 11,671 78% 5310-455-430640-353 AUDITING 0 3,000 3,000 100% 5310-455-430640-354 CONTRACT-GLACIER GOLD 26,872 135,000 108,128 80% 5310-455-430640-355 CONTRACT - LAND FILL & OTHER 12,699 60,000 47,301 79% 5310-455-430640-356 CONSULTANTS 648 220,000 219,352 100% 5310-455-430640-358 CONSULTANT- PERMIT/TMDL 562 100,000 99,438 99% 5310-455-430640-360 MISC. MAINT SERVICES 9,047 35,000 25,953 74% 5310-455-430640-366 BUILDING MAINTENANCE 6,895 42,000 35,105 84% 5310-455-430640-373 DUES & TRAINING 1,529 10,500 8,971 85% 5310-455-430640-388 MEDICAL SERVICES 180 500 320 64% 5310-455-430640-510 PROPERTY & LIABILITY INS. 90,804 90,804 0- 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 7,432 22,296 14,864 67% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 45,368 136,103 90,735 67% 5310-455-430640-528 INFORMATION TECH TRANSFER 19,166 57,748 38,582 67% 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% ------------------------------------------------- SUBTOTAL WWTP OPERATIONS 488,100 7,039,637 6,551,537 93% ------------------------------------------------- WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 11,857 187,000 175,143 94% 5310-455-430645-922 FERMENTER RECONSTRUCTION (CARRY) 3,821 216,461 212,640 98% 5310-455-430645-940 MACHINERY & EQUIPMENT (CARRYOVER & 0 115,000 115,000 100% 5310-455-430645-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 314,406 314,406 100% ------------------------------------------------- SUBTOTAL WWTP REPLACEMENT 15,678 832,867 817,189 98% ------------------------------------------------- WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 34,010 151,668 117,658 78% 5310-455-430646-121 OVERTIME 43 0 43- 0% 5310-455-430646-153 HEALTH INSURANCE 3,207 19,714 16,507 84% 5310-455-430646-155 RETIREMENT 2,830 12,085 9,255 77% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 861 7,000 6,139 88% 5310-455-430646-218 NON-CAPITAL EQUIPMENT 4,558 5,000 442 9% 5310-455-430646-222 LAB SUPPLIES 5,096 18,500 13,404 72% 5310-455-430646-349 LAB SERVICES 3,096 22,000 18,904 86% 5310-455-430646-350 PRETREATMENT SERVICE 2,789 15,000 12,211 81% 5310-455-430646-362 EQUIPMENT MAINTENANCE 433 10,500 10,067 96% 5310-455-430646-373 DUES & TRAINING 550 5,500 4,950 90% 5310-455-430646-940 MACHINERY & EQUIPMENT 8,600 8,700 100 1% ------------------------------------------------- SUBTOTAL WWTP LAB OPERATIONS 66,071 275,667 209,596 76% DEBT SERVICE - WWTP 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% ------------------------------------------------- 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 32 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SUBTOTAL DEBT SERVICE - WWTP 99,836 1,085,836 986,000 91% ------------------------------------------------- DEPRECIATION/REPL. - WWTP 5310-455-510400-831 DEPR. EXP. - WWTP (INCLUDES 010125 0 1,300,000 1,300,000 100% ------------------------------------------------- SUTOTAL WWTP DEPRECIATION/REPL 0 1,300,000 1,300,000 100% ------------------------------------------------- SUBTOTAL WWTP 669,685 10,534,007 9,864,322 94% ------------------------------------------------- TOTAL BILLING/SANITARY/WWTP 2,056,329 20,872,168 18,815,839 90% ================================================= SEWER IMPACT FEE REVENUE 5311-000-343330-000 SANITARY IMPACT FEES 156,519 787,500 630,981 80% 5311-000-343335-000 TREATMENT IMPACT FEES 125,292 483,000 357,708 74% 5311-000-371010-000 SANITARY INTEREST EARNINGS 25,311 15,000 10,311- -69% 5311-000-371015-000 TREATMENT INTEREST EARNINGS 17,024 11,000 6,024- -55% ------------------------------------------------- TOTAL SEWER IMPACT FEES REVENU 324,146 1,296,500 972,354 75% ================================================= SEWER IMPACT FEE EXPENSES 5311-454-430635-820 TRANSFER TO 5310 FOR DEBT (SANITARY 216,667 650,000 433,333 67% 5311-454-430635-825 TRANSFER TO 5310 FOR ADMIN 21,667 65,000 43,333 67% 5311-454-430635-950 RR & UPSIZE - WWTP MAIN (66% - 34% 0 275,721 275,721 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 5,124 264,677 259,553 98% 5311-454-430635-961 LIFT STATION #36 IMPROVEMENTS & CON 0 1,460,723 1,460,723 100% 5311-455-430644-820 TRANSFER TO 5310 FOR DEBT 216,667 650,000 433,333 67% 5311-455-430644-825 TRANSFER TO 5310 FOR ADMIN 11,667 35,000 23,333 67% 5311-455-430644-929 CONSTRUCT NEW EQ BASIN 27,918 216,453 188,535 87% 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 559,636 559,636 100% ------------------------------------------------- TOTAL SEWER IMPACT FEE EXPENSE 636,887 5,710,022 5,073,135 89% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 33 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM SEWER REVENUE 5349-000-323108-000 PW PLAN REVIEW FEES 3,545 1,500 2,045- -136% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 0 1,000 1,000 100% 5349-000-343034-000 PERMIT FEES 400 1,500 1,100 73% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 0 2,010,000 2,010,000 100% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 2,724 2,500 224- -9% 5349-000-371010-000 INTEREST ON INVESTMENTS 31,799 25,000 6,799- -27% 5349-000-383010-000 IMPACT FEE 5% ADMIN - TFR FROM IMPA 3,333 10,000 6,667 67% 5349-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 46,667 140,000 93,333 67% ------------------------------------------------- TOTAL STORM REVENUE 88,468 2,191,500 2,103,032 96% ================================================= STORM SEWER 5349-453-430246-110 SALARIES-STORM SEWER 125,349 619,004 493,655 80% 5349-453-430246-121 OVERTIME 113 4,000 3,887 97% 5349-453-430246-153 HEALTH INSURANCE 14,133 115,145 101,012 88% 5349-453-430246-155 RETIREMENT 10,293 49,787 39,494 79% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 9,499 18,500 9,001 49% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 307 6,000 5,693 95% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100% 5349-453-430246-231 GAS & OIL 1,641 18,500 16,859 91% 5349-453-430246-345 TELEPHONE & COMMUNICATION 573 3,250 2,677 82% 5349-453-430246-353 AUDITING 0 1,380 1,380 100% 5349-453-430246-354 CONTRACT SERVICE 983 10,000 9,017 90% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 1,492 35,000 33,508 96% 5349-453-430246-358 CONSULTANTS 0 350,000 350,000 100% 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 2,439 21,000 18,561 88% 5349-453-430246-373 DUES & TRAINING 0 10,250 10,250 100% 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 5,135 15,406 10,271 67% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 19,266 57,799 38,533 67% 5349-453-430246-528 INFORMATION TECH TRANSFER 16,417 49,790 33,373 67% 5349-453-430246-530 BNSF LEASE PMT 0 5,500 5,500 100% 5349-453-430246-972 MERIDIAN BASIN DRAINAGE UPGRADES DE 0 100,000 100,000 100% 5349-453-430247-952 STORM DRAIN CORRECTION (NEW & C/O) 51,124 750,000 698,876 93% 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 410,422 364,602 45,820- -13% 5349-453-430247-971 MERIDIAN CT DRAINAGE IMPROVEMENTS 0 191,000 191,000 100% ------------------------------------------------- SUBTOTAL STORM OPERATIONS 850,130 3,444,767 2,594,637 75% ------------------------------------------------- STORM BONDS/LOANS 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% 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 34 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 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% ------------------------------------------------- SUBTOTAL STORM BONDS/LOANS 50,184 141,426 91,242 65% ------------------------------------------------- DEPRECIATION 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 400,000 400,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 400,000 400,000 100% ------------------------------------------------- TOTAL STORM EXPENSE 900,314 3,986,193 3,085,879 77% ================================================= STORM SEWER IMPACT FEE REVENUE 5348-000-343033-000 IMPACT FEES 66,559 157,500 90,941 58% 5348-000-371010-000 INTEREST EARNINGS 10,669 10,000 669- -7% ------------------------------------------------- TOTAL STORM IMPACT FEES REVENU 77,227 167,500 90,273 54% ================================================= STORM SWR IMPACT FEE EXPENSES 5348-453-430248-820 DEBT SERVICE TRANSFER TO 5349 46,667 140,000 93,333 67% 5348-453-430248-825 TRANSFER TO 5349 FOR ADMIN 3,333 10,000 6,667 67% 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 STORM IMPACT FEE EXPENSE 50,000 530,000 480,000 91% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 35 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION-ASSESSED 0 1,342,000 1,342,000 100% 5510-000-343420-000 GARBAGE COLLECTION-NOT ASSESSED 5,253 30,000 24,747 82% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,562 2,000 438 22% 5510-000-371010-000 INVESTMENT EARNINGS 8,627 15,000 6,373 42% ------------------------------------------------- TOTAL SOLID WASTE REVENUE 15,441 1,389,000 1,373,559 99% ================================================= SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES-SOLID WASTE 130,256 569,256 439,000 77% 5510-460-430840-121 OVERTIME 801 8,000 7,199 90% 5510-460-430840-153 HEALTH INSURANCE 19,427 110,316 90,889 82% 5510-460-430840-155 RETIREMENT 10,646 45,597 34,951 77% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 7,623 16,500 8,877 54% 5510-460-430840-218 EQUIPMENT-GARBAGE CONTAINERS 21,103 71,200 50,097 70% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 1,127 5,500 4,373 80% 5510-460-430840-231 GAS & OIL 15,859 116,000 100,141 86% 5510-460-430840-341 ELECTRICITY 192 2,050 1,858 91% 5510-460-430840-344 NATURAL GAS 65 4,500 4,435 99% 5510-460-430840-345 TELEPHONE & COMMUNICATION 537 3,500 2,963 85% 5510-460-430840-354 CONTRACT SERVICES 11,859 157,000 145,141 92% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 8,861 55,000 46,139 84% 5510-460-430840-366 BUILDING MAINTENANCE 0 5,000 5,000 100% 5510-460-430840-373 DUES & TRAINING 88 10,000 9,912 99% 5510-460-430840-388 MEDICAL SERVICES 0 900 900 100% 5510-460-430840-510 PROPERTY & LIABILITY INS. 28,110 28,110 0 0% 5510-460-430840-512 UNINSURED LOSS-DEDUCTIBLE 486 4,000 3,514 88% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 36,351 109,052 72,701 67% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 16,441 49,324 32,883 67% 5510-460-430840-528 INFORMATION TECH TRANSFER 16,385 49,695 33,310 67% 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 13,333 40,000 26,667 67% 5510-460-430840-944 VEHICLES (Replacement $) 0 914,356 914,356 100% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% ------------------------------------------------- TOTAL SOLID WASTE EXPENSE 339,551 2,582,794 2,243,243 87% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 36 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING INTERNAL SERVICE FUNDS INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 ENTITLEMENT SHARE PMT/HB124 0 440,000 440,000 100% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 0 225,000 225,000 100% 6030-000-371010-000 INVESTMENT EARNINGS 3,119 10,000 6,881 69% 6030-000-393000-000 INTERNAL SERVICES-DATA 242,146 726,448 484,302 67% ------------------------------------------------- TOTAL INFORMATION TECH REVENUE 245,265 1,401,448 1,156,183 83% ================================================= INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 105,120 501,721 396,601 79% 6030-401-410580-121 OVERTIME 0 1,000 1,000 100% 6030-401-410580-153 HEALTH INSURANCE 14,461 102,551 88,090 86% 6030-401-410580-155 RETIREMENT 8,861 41,699 32,838 79% 6030-401-410588-218 COMPUTERS - ADMINISTRATIVE DEPTS 509 4,300 3,791 88% 6030-403-410580-215 COMPUTER SUPPLIES 749 3,900 3,151 81% 6030-403-410580-218 EQUIPMENT-NOT CAPITAL 4,118 28,080 23,962 85% 6030-403-410580-325 WEBSITE 9,794 10,200 406 4% 6030-403-410580-345 PAGER/PHONE 0 2,800 2,800 100% 6030-403-410580-346 SUMMITNET & ISPS 1,157 8,428 7,271 86% 6030-403-410580-353 LASER FICHE MAINTENANCE 0 13,000 13,000 100% 6030-403-410580-354 MAINTENANCE CONTRACTS 1 48,100 48,100 100% 6030-403-410580-355 LICENSES 7,267 32,959 25,692 78% 6030-403-410580-356 MAINTENANCE CONTRACTS 11,028 96,150 85,122 89% 6030-403-410580-357 GRANICUS 9,000 7,800 1,200- -15% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 543 79,666 79,123 99% 6030-403-410580-359 PRIVATE FIBER - CITY NETWORK 3,885 18,600 14,715 79% 6030-403-410580-360 MULTI-FACTOR AUTHENTICATION 0 9,000 9,000 100% 6030-403-410580-373 DUES & TRAINING 1,523 16,960 15,437 91% 6030-403-410580-510 INSURANCE 7,952 7,952 0 0% 6030-403-410583-218 TV-Video Equipment & programming 1,905 23,500 21,595 92% 6030-403-410585-229 COPIER,FAX, SUPPLIES 1,563 18,223 16,660 91% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 81,687 265,433 183,746 69% 6030-403-410585-532 COPIER LEASES 0 13,460 13,460 100% 6030-403-410585-942 Servers - capital contingency 0 80,925 80,925 100% 6030-403-510400-831 DEPRECIATION EXPENSE 0 50,000 50,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 1,650 3,460 1,810 52% 6030-405-410588-940 COMPUTERS - SWITCHES 0 160,025 160,025 100% 6030-410-410588-218 COMPUTERS - DPW 6,445 6,922 477 7% 6030-413-410588-218 COMPUTERS - POLICE DEPT 1,327 31,710 30,383 96% 6030-416-410588-218 COMPUTERS - FIRE 0 22,630 22,630 100% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 0 4,350 4,350 100% 6030-436-410588-218 COMPUTERS - PARKS 0 4,300 4,300 100% ------------------------------------------------- TOTAL INFORMATION TECH EXPENSE 280,546 1,719,804 1,439,258 84% ================================================= 1ST QUARTER FINANCIAL REPORT THE CITY OF KALISPELL, MONTANA10.09.2023 12:20 gb8501_pg.php/Job No: 16143 Page 37 of 37 USER: AIMEE FY24 FINANCIAL REPORT FY24 THRU SEPTEMBER 30 33.33 % Yr Complete For Fiscal Year: 2024 / 10 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 209,133 615,000 405,867 66% 6010-000-371010-000 INVESTMENT EARNINGS 795 1,500 705 47% ------------------------------------------------- TOTAL CENTRAL GARAGE REVENUE 209,929 616,500 406,571 66% ================================================= CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 50,620 212,006 161,386 76% 6010-410-431330-121 OVERTIME 0 2,500 2,500 100% 6010-410-431330-153 HEALTH INSURANCE 6,955 43,204 36,249 84% 6010-410-431330-155 RETIREMENT 3,668 16,571 12,903 78% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 9,198 19,500 10,302 53% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 2,187 10,700 8,513 80% 6010-410-431330-230 OIL 1,415 26,500 25,085 95% 6010-410-431330-231 GAS 233 1,900 1,667 88% 6010-410-431330-232 VEHICLE PARTS 34,421 160,000 125,579 78% 6010-410-431330-233 TIRES 12,957 60,500 47,543 79% 6010-410-431330-238 FILTERS 1,396 10,500 9,104 87% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 63 2,100 2,037 97% 6010-410-431330-341 ELECTRICITY 541 5,900 5,359 91% 6010-410-431330-342 WATER 116 2,000 1,884 94% 6010-410-431330-344 NATURAL GAS 227 12,500 12,273 98% 6010-410-431330-354 CONTRACT SERVICES 7,723 40,000 32,277 81% 6010-410-431330-360 WASH BAY REPAIRS & MAINTENANCE 503 6,000 5,497 92% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 1,055 10,000 8,945 89% 6010-410-431330-373 DUES & TRAINING 0 12,000 12,000 100% 6010-410-431330-388 MEDICAL SERVICES 0 500 500 100% 6010-410-431330-510 INSURANCE 5,402 5,402 1 0% 6010-410-431330-528 INFORMATION TECH TRANSFER 7,793 23,480 15,687 67% 6010-410-431330-944 MACHINERY & EQUIPMENT 0 14,650 14,650 100% ------------------------------------------------- TOTAL CENTRAL GARAGE EXPENSES 146,473 698,413 551,940 79% =================================================