Loading...
10-15-21 City Manager Report and Financial and Arrest Reports1 City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 10/15/2021 1. Public Works Spring Creek Flood Control Structure-Cleaning Project City Crews completed the Spring Creek Flood Control Structure cleaning project this past September. This 3-week, in-house, operations and maintenance project involved removing approximately 600 yards of sediment from a concrete structure designed to control flooding from Spring Creek and the combined stormwater flow on the west side of town. The flood structure was constructed in 1977, and there is no record of adequate maintenance being performed since its original construction. The structure is surrounded by private property which creates access challenges for heavy equipment. This project was initiated in response to recent high rainfall events where staff identified potential capacity problems in the surrounding upstream stormwater infrastructure. Staff identified the project, worked with a neighboring property owner to secure a temporary construction easement, obtained the appropriate DEQ permitting, and completed the removal and cleaning with in-house equipment and labor. Joe Schrader-Utility Superintendent, Matt Bean-Sewer Supervisor, John Charles – Assistant Street Supervisor, and the Street and Sewer/Stormwater Crews identified the need and completed this maintenance activity within the dry weather timelines. 2 Leaf Collection Season Public Works has started leaf collection for this season and will conclude collection efforts on November 12. The leaf collection season is instituted to 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 from the curb. An interactive Leaf Collection map is available on the City’s website and provides information on weekday collection areas. This map allows customers the ability to easily search their address and determine their area’s leaf collection day. The leaf collection schedule is a guideline to establish some predictability for residential collection days. However, collection in designated areas outside of the schedule days may occur at the discretion of Public Works. 2. Police Department Attached is the latest law enforcement report. KPD Officers Brinton and Parce and MHP Troopers were on hand to congratulate Special Olympic athletes and present them with their well-deserved medals at the recent competition on October 8. Chief Overman and Co-Responder Sarah Winfrey participated in a round table discussion of different models of crisis response during the Montana League of Cities and Towns conference on October 8. The discussion included models in the Flathead and Missoula areas and lessons learned during the implementation of these programs. Over the past year, the Kalispell Police Department has participated in 169 calls with the Co-Responder program. 3. Parks and Recreation Our forestry contractor has now completed the pruning of trees along 10th & 11th Streets East. Our forestry crew are pruning trees along the 700 block of 5th Ave East. Park seasonal bathrooms have been winterized for the year due to freezing temps. Port-a- potties have been placed at Woodland and Lawrence for the winter. Transient activity within the parks and along trails continues. Park crews are trying to stay on top as we see or are notified of the camps in hopes to reduce the debris that may accumulate within our park system. Volunteers from Rails to Trails also cleaned a section 3 of trail. Parks crews have begun have pulling planting materials from the downtown planters. They will also be pulling the planting materials form the formal garden and readying the rose garden for the winter. We completed our fall youth soccer and football programs on October 8-9 and will kick off our Little Dribblers youth basketball league on Saturday, October 16. Participation in our youth basketball league is at an all-time high with 373 participants, compared to 236 last fall (58% increase). After cancelling our adult season last fall due to Covid, we are bringing back our indoor adult soccer league this year and will run the program from November 2021 to March 2022 at Edgerton Elementary School. Games will be played on Tuesday, Wednesday, and Thursday evenings from 6pm-9pm. This will be a co-rec league (must have at least 1 male and 1 female per team) and played in a 5 on 5 Futsal format. Registration is still open for our Skip-Out Camp for children ages 5-13 on October 21-22. Activities this year will include field trips to the pumpkin patch and bowling. 4. Planning Department The Planning Board held a public hearing on October 13 and heard two application requests. The application requests consisted of the following: 1. Files #KZC-21-02 and KCU-21-07 – A request from Samaritan House, Inc. for a zone change and a conditional use permit on approximately 2.42 acres of land at 1110 2nd Street West. The proposed zone change would also apply to a tract of land at the northeast corner of the intersection of South Meridian Road and 2nd Street West, which is owned by the City of Kalispell and contains approximately 0.1 acres. The existing zoning on the properties is P-1 (Public) and the proposed zoning is B-3 (Core Area Business). The conditional use permit is a request to allow sleeping space as part of a homeless shelter, along with a dining area and shared community space. In addition, there would be 16 multi-family housing units for long term housing which are a permitted use within the B-3 zone and not subject to the conditional use permit. The proposal would include remodeling of existing space as well as new construction. 2. Files #KZC-21-03 and KCU-21-08 – A request from Meridian Investments, LLC for a zone change and a conditional use permit on approximately 1.0 acres of land located to the east of 41 Meridian Court. The property is currently zoned R-4 (Residential), and the proposed zone change would be to B-1 (Neighborhood Business). The zone change would allow multi-family dwellings as a conditionally permitted use on the property. The requested conditional use permit would expand a multi-family development currently under construction by adding 4 a building and extending parking to the additional land. The building would contain 36 dwelling units. The Board recommended approval of the two application requests. The recommendations will be forwarded to Council for their consideration at the November 1 meeting. The Board also held a work session on the following application request: 1. Files #KA-21-05 and KPUD-21-04 – A request from Bish’s RV for the annexation of two parcels located at 3100 Highway 93 South containing approximately 8.36 acres of land with an initial zoning designation of B-2 (General Business). The proposal would add a Planned Unit Development (“PUD”) overlay on the two parcels along with a third parcel containing approximately 12.58 acres that is already within the city limits with a B-2/PUD placeholder designation. The Bish’s RV PUD as proposed would then be a Commercial PUD on approximately 20.94 acres and would contemplate a renovation and expansion of an existing RV dealership. The Board did not take any formal action on the PUD application request and a public hearing is scheduled for the matter at the Board’s next regularly scheduled meeting on November 9. 5. Building Department In the last 2 weeks, we have issued permits for 7 single-family homes. That will bring the total of new single-family/duplex and townhouse units for the year to 210, compared to 229 last year at this time. There have been 329 multi-family housing units issued so far this year. Last year at this time we had issued 132 multi-family housing units. There was a total of 158 combined building and/or fire inspections completed in the last 2 weeks. Residential – 64 Plumbing – 20 Commercial – 35 Mechanical - 18 Electrical – 12 Fire - 9 6. Community Development Construction of the Kalispell Parkline Main Street/U.S. 93 pedestrian crossing has begun with roadway surface removal. Construction of the pedestrian crossing will occur during the hours of 7:00pm to 7:00am and is scheduled to be completed on November 1. 7. Finance Department First Quarter Finance Report Attached are the printouts reflecting the activity for the 1st quarter of Fiscal Year 2022. 5 This printout reflects payroll thru Sept. 25; six full pay periods for biweekly employees. For fire and ambulance, this printout reflects payroll paid thru Sept. 12; about two and one-half of 13 pay periods. Expenditures/expenses are included for all funds, with the exception of debt service funds. REVENUES: General Fund and parks department 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 we will book the receivables/revenue at that time. This applies to the assessed funds as well. The Ambulance Fund 1st quarter fees for services is 18% of the annual budget or $126,137. This is a decrease of about $20,000 when compared to the 1st quarter of fiscal year 2021. First quarter Building Department revenues of $486,359 are 38% of the annual budget. First quarter fiscal year 2021 revenues were just over $361,000. Metered water sales are at 46% compared to 41% for the first quarter of fiscal year 2021. First quarter water sales are usually more than 25% due to summer and early fall sprinkling and irrigation. Sewer metered sales are at 28%, which is about the same as 1st quarter last fiscal year. Water, sewer, treatment, and storm impact fees remain strong in the first quarter and all are well over 25% of the fiscal year 2022 budgeted amount. Police and fire impact fees were both at 40% of the annual budgeted. EXPENDITURES/EXPENSES: At this point in the year, the salary and retirement remaining should be about 77% in most funds (20 of 26 pay periods remaining). Some seasonal parks and rec salaries would be an exception. Fire and ambulance should have about 81% remaining in salaries and retirement (10.5 of 13 pay periods remaining). Health insurance reflects 3 months paid and should have at least 75% remaining. With a few exceptions, administrative, central garage, and information technology transfers are done monthly and should show 75% remaining. This is the same on the revenue side for fees for services (Central Garage/Information Technology) and administrative charges (General Fund). The general fund administrative charges may vary slightly as some charges are based on a percentage of revenues collected. Annual budgeted operating transfers are generally done quarterly, depending on cash availability, and should show 75% remaining. The City prepays its annual liability ($420,812) and property insurance ($158,082) in August. This can result in general government expenditures and some other funds’ expenses reflecting greater than 25% spent in the 1st quarter. THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 1 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 122,702 6,145,000 6,022,298 98% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 0 17,750 17,750 100% 1000-000-311200-000 PERSONAL PROPERTY TAXES 148,165 170,000 21,835 13% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 5,810 10,000 4,190 42% 1000-000-322101-000 LIQUOR LICENSES 1,763 33,000 31,238 95% 1000-000-322300-000 BUSINESS LICENSES 78 1,500 1,422 95% 1000-000-323012-000 PLANNING FEES 33,164 95,000 61,836 65% 1000-000-323109-000 SITE REVIEW 9,214 30,000 20,786 69% 1000-000-323200-000 PARADE PERMITS 200 500 300 60% 1000-000-331023-000 MRVCTF 440 0 440- 0% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 1,350 1,350 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 0 60,000 60,000 100% 1000-000-335110-000 LIVE CARD TABLE PERMIT 0 1,400 1,400 100% 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 752,015 3,020,000 2,267,985 75% 1000-000-341020-000 ADMINISTRATIVE CHARGES 172,067 690,000 517,933 75% 1000-000-341021-000 GRANT ADMIN FEES 218 25,000 24,782 99% 1000-000-341025-000 CITY COLLECTIONS 3,084 5,000 1,916 38% 1000-000-342010-000 POLICE SERVICES 7,683 29,000 21,317 74% 1000-000-342014-000 RESOURCE OFFICERS 270,481 224,435 46,046- -21% 1000-000-342016-000 KPD REGIONAL TRAINING 2,539 14,500 11,961 82% 1000-000-343018-000 PARKING PERMITS 24,661 90,000 65,339 73% 1000-000-343062-000 AIRPORT FUEL TAXES 2,125 4,000 1,875 47% 1000-000-343063-000 AIRPORT GROUND LEASE (HILTON) 13,259 15,301 2,042 13% 1000-000-351000-000 CITY COURT FINES & FEES 72,993 450,000 377,007 84% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 4,289 30,000 25,711 86% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 10,445 45,000 34,555 77% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 571 20,000 19,429 97% 1000-000-362020-000 MMIA LIABILITY RETRO 0 30,000 30,000 100% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 0 10,000 10,000 100% 1000-000-371010-000 INVESTMENT EARNINGS 8,713 30,000 21,287 71% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 0 1,100,000 1,100,000 100% ------------------------------------------------- TOTAL GENERAL FUND REVENUE 1,666,679 12,397,736 10,731,057 87% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 2 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 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 0 13,750 13,750 100% 1000-400-410530-354 GASB 75 ACTUARIAL VALUATION 7,500 10,000 2,500 25% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 197 4,000 3,803 95% 1000-400-410560-312 POSTAGE 4,670 16,000 11,330 71% 1000-400-410560-320 PRINTING & ENVELOPES 0 5,500 5,500 100% 1000-400-410560-354 CONTRACT SERVICES - DOC. SHRED / 10 0 1,500 1,500 100% 1000-400-410600-354 ELECTIONS 0 20,000 20,000 100% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 1,118 4,500 3,382 75% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 0 350 350 100% 1000-400-430300-355 AIRPORT REIMBURSEMENT 18,065 20,000 1,935 10% 1000-400-460000-820 TFR TO WESTSIDE TIF 225,000 900,000 675,000 75% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 0 15,000 15,000 100% 1000-400-460452-366 HOCKADAY MAINTENANCE 0 6,600 6,600 100% 1000-400-510300-000 CONTINGENCY 0 210,000 210,000 100% 1000-400-510310-354 ICMA PLAN FEES 125 500 375 75% 1000-400-510330-513 LIABILITY INSURANCE 287,407 287,406 1- 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 0 50,000 50,000 100% 1000-400-510330-517 PROPERTY INSURANCE 60,043 60,043 0 0% ------------------------------------------------- SUBTOTAL GEN.GOV'T. 604,126 1,628,179 1,024,053 63% CITY MANAGER 1000-401-410210-110 SALARIES-CITY MANAGER'S OFFICE 37,786 171,133 133,347 78% 1000-401-410210-153 HEALTH INSURANCE 6,392 25,759 19,367 75% 1000-401-410210-155 RETIREMENT 3,994 18,227 14,233 78% 1000-401-410210-210 SUPPLIES 0 1,000 1,000 100% 1000-401-410210-312 NEWSLETTER/BOOKS 0 400 400 100% 1000-401-410210-345 TELEPHONE & COMMUNICATION 280 1,200 920 77% 1000-401-410210-373 DUES & TRAINING 1,418 12,000 10,582 88% 1000-401-410210-379 MEETINGS 25 6,500 6,475 100% ------------------------------------------------- SUBTOTAL CITY MANAGER 49,895 236,219 186,324 79% HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 37,302 173,487 136,185 79% 1000-401-410830-153 HEALTH INSURANCE 5,902 24,323 18,421 76% 1000-401-410830-155 RETIREMENT 2,960 14,032 11,072 79% 1000-401-410830-210 OFFICE SUPPLIES 104 900 796 88% 1000-401-410830-338 RECRUITMENT/RELOCATION 5,145 20,000 14,855 74% 1000-401-410830-354 CONTRACT SERVICES 160 2,000 1,840 92% 1000-401-410830-373 DUES & TRAINING 219 17,000 16,781 99% ------------------------------------------------- SUBTOTAL HUMAN RESOURCES 51,792 251,742 199,950 79% THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 3 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 14,983 63,179 48,196 76% 1000-402-410100-153 HEALTH INSURANCE 11,616 50,123 38,507 77% 1000-402-410100-155 RETIREMENT 629 2,617 1,988 76% 1000-402-410100-210 OFFICE SUPPLIES 0 6,500 6,500 100% 1000-402-410100-335 MT LEAGUE OF CITIES 198 7,100 6,902 97% 1000-402-410100-354 CONTRACT SERVICES 422 5,500 5,078 92% 1000-402-410100-373 DUES & TRAINING 9,372 11,500 2,128 19% 1000-402-410100-379 MEETINGS 3,271 22,255 18,984 85% ------------------------------------------------- SUBTOTAL MAYOR/COUNCIL 40,492 168,774 128,282 76% CITY CLERK 1000-402-410150-110 SALARIES-CITY CLERK 26,447 114,510 88,063 77% 1000-402-410150-121 OVERTIME 0 250 250 100% 1000-402-410150-153 HEALTH INSURANCE 4,418 21,768 17,350 80% 1000-402-410150-155 RETIREMENT 2,169 9,323 7,154 77% 1000-402-410150-210 OFFICE SUPPLIES 147 800 653 82% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 0 600 600 100% 1000-402-410150-345 TELEPHONE & COMMUNICATION 160 480 320 67% 1000-402-410150-352 CODIFICATION 0 4,100 4,100 100% 1000-402-410150-354 CONTRACT SERVICES 39 650 611 94% 1000-402-410150-373 DUES & TRAINING 1,363 6,200 4,837 78% ------------------------------------------------- SUBTOTAL CITY CLERK 34,742 158,681 123,939 78% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES-FINANCE OFFICE 56,777 247,730 190,953 77% 1000-403-410550-121 OVERTIME 0 500 500 100% 1000-403-410550-153 HEALTH INSURANCE 9,768 40,712 30,944 76% 1000-403-410550-155 RETIREMENT 4,760 20,116 15,356 76% 1000-403-410550-210 SUPPLIES 135 800 665 83% 1000-403-410550-322 BOOKS 0 500 500 100% 1000-403-410550-353 CONTRACT SERVICES 0 350 350 100% 1000-403-410550-354 CONTRACT-GRIZZLY SECURITY 369 900 531 59% 1000-403-410550-355 BANK CHARGES & FEES 807 3,500 2,693 77% 1000-403-410550-373 DUES & TRAINING 245 8,500 8,255 97% ------------------------------------------------- SUBTOTAL FINANCE 72,861 323,608 250,747 77% THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 4 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CITY ATTORNEY 1000-404-411110-110 SALARIES-CITY ATTORNEY'S 127,345 551,082 423,737 77% 1000-404-411110-112 SALARIES - RETIREMENT 0 130,000 130,000 100% 1000-404-411110-153 HEALTH INSURANCE 22,247 85,995 63,748 74% 1000-404-411110-155 RETIREMENT 10,457 44,825 34,368 77% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 3,877 5,700 1,823 32% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 7,236 25,000 17,764 71% 1000-404-411110-345 TELEPHONE & COMMUNICATION 273 1,500 1,227 82% 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 32 10,000 9,968 100% 1000-404-411110-373 DUES & TRAINING 1,722 8,000 6,278 78% ------------------------------------------------- SUBTOTAL CITY ATTORNEY 173,189 862,102 688,914 80% MUNICIPAL COURT 1000-406-410360-110 SALARIES-COURT 60,367 264,684 204,317 77% 1000-406-410360-121 OVERTIME 0 3,500 3,500 100% 1000-406-410360-153 HEALTH INSURANCE 11,838 47,298 35,460 75% 1000-406-410360-155 RETIREMENT 4,956 21,480 16,525 77% 1000-406-410360-210 SUPPLIES 69 4,500 4,431 98% 1000-406-410360-320 PRINTING/BOOKS 926 1,500 574 38% 1000-406-410360-345 TELEPHONE & COMMUNICATION 167 1,000 833 83% 1000-406-410360-353 SECURITY & TECHNOLOGY 2,134 40,000 37,866 95% 1000-406-410360-354 CONTRACT SERVICES 660 6,250 5,590 89% 1000-406-410360-373 DUES & TRAINING 300 10,000 9,700 97% 1000-406-410360-394 JURY & WITNESS FEES 846 7,500 6,654 89% ------------------------------------------------- SUBTOTAL COURT 82,263 407,712 325,449 80% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES-PUBLIC WORKS 4,360 19,158 14,798 77% 1000-410-430100-153 HEALTH INSURANCE 957 3,302 2,345 71% 1000-410-430100-155 RETIREMENT 404 1,500 1,096 73% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 7,635 14,500 6,865 47% 1000-410-430100-231 GAS 636 3,000 2,364 79% 1000-410-430100-345 TELEPHONE & COMMUNICATION 149 850 701 82% 1000-410-430100-354 CONTRACT SERVICES 265 4,500 4,235 94% 1000-410-430100-373 DUES & TRAINING 521 4,500 3,979 88% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 1,164 4,656 3,492 75% 1000-410-430100-940 MACINERY & EQUIPMENT 0 9,500 9,500 100% ------------------------------------------------- SUBTOTAL PUBLIC WORKS ADMIN 16,091 65,466 49,375 75% CITY HALL MAINT. 1000-412-411230-110 SALARIES-CITY HALL 18,911 72,664 53,753 74% 1000-412-411230-153 HEALTH INSURANCE 4,688 15,100 10,412 69% 1000-412-411230-155 RETIREMENT 1,538 5,849 4,311 74% 1000-412-411230-220 SECURITY IMPROVEMENTS 793 6,793 6,000 88% 1000-412-411230-224 JANITORIAL SUPPLIES 972 6,800 5,829 86% 1000-412-411230-241 TOOLS & SUPPLIES 130 1,500 1,370 91% 1000-412-411230-341 ELECTRICITY 14,680 49,394 34,714 70% 1000-412-411230-344 NATURAL GAS 4,748 34,000 29,252 86% THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 5 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 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 2,854 15,000 12,146 81% 1000-412-411230-355 HVAC MAINTENANCE CONTRACT 18,076 17,730 346- -2% 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 75 7,000 6,925 99% 1000-412-411230-362 EQUIPMENT MAINTENANCE 378 10,000 9,622 96% 1000-412-411230-366 BUILDING MAINTENANCE 4,328 17,288 12,960 75% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 154 3,780 3,626 96% 1000-412-411230-920 BUILDING IMPROVEMENTS 0 30,058 30,058 100% ------------------------------------------------- SUBTOTAL CITY HALL 72,435 293,456 221,021 75% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES-PLANNING & ZONING 57,454 246,016 188,562 77% 1000-420-411020-153 HEALTH INSURANCE 9,551 46,047 36,496 79% 1000-420-411020-155 RETIREMENT 4,704 20,021 15,317 77% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 384 4,000 3,616 90% 1000-420-411020-231 GAS 49 450 401 89% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 143 2,500 2,357 94% 1000-420-411020-345 TELEPHONE 159 1,000 841 84% 1000-420-411020-354 CONTRACT SERVICES 25 6,000 5,975 100% 1000-420-411020-373 DUES & TRAINING 1,243 8,000 6,757 84% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 35 139 104 75% ------------------------------------------------- SUBTOTAL PLANNING DEPT. 73,747 334,173 260,426 78% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 18,726 81,675 62,949 77% 1000-480-470210-153 HEALTH INSURANCE 4,260 16,790 12,530 75% 1000-480-470210-155 RETIREMENT 1,538 6,610 5,072 77% 1000-480-470210-210 OFFICE SUPPLIES 0 1,600 1,600 100% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 0 500 500 100% 1000-480-470210-312 POSTAGE & PRINTING 27 300 273 91% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 0 500 500 100% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 77 450 373 83% 1000-480-470210-354 CONTRACT SERVICES 0 250 250 100% 1000-480-470210-373 DUES & TRAINING 951 5,000 4,049 81% 1000-480-470210-379 MEETINGS 0 750 750 100% ------------------------------------------------- SUBTOTAL COMMUNITY DEVELOPMENT 25,580 114,425 88,845 78% THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 6 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES-POLICE 610,502 2,669,727 2,059,225 77% 1000-413-420140-112 SALARIES-SEVERANCE 16,647 50,000 33,353 67% 1000-413-420140-114 SALARY -comptime buyout 5,287 4,000 1,287- -32% 1000-413-420140-121 OVERTIME (REG & AET OT) 14,637 80,000 65,363 82% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 9,884 35,000 25,116 72% 1000-413-420140-153 HEALTH INSURANCE 125,043 497,110 372,067 75% 1000-413-420140-155 RETIREMENT 77,891 349,720 271,829 78% 1000-413-420140-210 OFFICE SUPPLIES 423 3,500 3,077 88% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 828 5,000 4,172 83% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 12,335 70,000 57,666 82% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 637 4,000 3,363 84% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 154 13,500 13,346 99% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 0 2,700 2,700 100% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 8 11,900 11,892 100% 1000-413-420140-227 AMMO & RELATED SUPPLIES 12,593 65,000 52,407 81% 1000-413-420140-228 PATROL CAR SUPPLIES 787 8,000 7,213 90% 1000-413-420140-229 OTHER SUPPLIES 1,026 5,000 3,974 79% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 0 1,000 1,000 100% 1000-413-420140-231 GAS 13,528 75,000 61,472 82% 1000-413-420140-234 CRISIS NEGOTIATIONS 0 500 500 100% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 0 1,500 1,500 100% 1000-413-420140-320 PRINTING 145 4,000 3,855 96% 1000-413-420140-345 TELEPHONE & COMMUNICATION 5,976 22,000 16,024 73% 1000-413-420140-354 CONTRACT SERVICES 8,499 30,000 21,501 72% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 554 6,500 5,946 91% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 852 2,600 1,748 67% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 237 2,000 1,763 88% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 30,107 57,000 26,893 47% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 1,091 5,000 3,909 78% 1000-413-420140-373 DUES & TRAINING 18,633 55,000 36,367 66% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 2,677 14,500 11,823 82% 1000-413-420140-380 TRAINING MATERIALS 0 5,000 5,000 100% 1000-413-420140-388 MEDICAL SERVICES 0 3,000 3,000 100% 1000-413-420140-392 BOARDING/TREATING PRISONERS 378 2,500 2,123 85% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 23,715 94,858 71,143 75% 1000-413-420140-530 RENT 1,800 7,200 5,400 75% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 16,000 64,000 48,000 75% 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 0 100,000 100,000 100% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 1,500 6,000 4,500 75% 1000-413-420140-944 VEHICLES 26,748 159,000 132,252 83% ------------------------------------------------- SUBTOTAL POLICE DEPT. 1,041,119 4,592,315 3,551,196 77% DETECTIVES 1000-413-420141-110 SALARIES-DETECTIVES 94,865 413,768 318,903 77% 1000-413-420141-121 DETECTIVE-OVERTIME 2,657 15,000 12,343 82% 1000-413-420141-123 OVERTIME (SAFE NEIGHBORHOOD TASK FO 0 8,000 8,000 100% 1000-413-420141-153 HEALTH INSURANCE 21,167 87,900 66,733 76% 1000-413-420141-155 DETECTIVE-RETIREMENT 12,636 55,446 42,810 77% ------------------------------------------------- TOTAL DETECTIVES 131,325 580,114 448,789 77% RECORDS THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 7 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-110 SALARIES-RECORDS DIVISION 37,510 161,768 124,258 77% 1000-413-420142-121 OVERTIME 1,262 6,000 4,738 79% 1000-413-420142-153 HEALTH INSURANCE 9,293 38,000 28,707 76% 1000-413-420142-155 RETIREMENT 3,176 13,094 9,918 76% ------------------------------------------------- TOTAL RECORDS 51,241 218,862 167,621 77% RESOURCE OFFICERS 1000-413-420144-110 SALARIES-SRO 66,760 291,805 225,045 77% 1000-413-420144-153 HEALTH INSURANCE 15,114 61,304 46,190 75% 1000-413-420144-155 SRO RETIREMENT 8,980 39,188 30,208 77% ------------------------------------------------- TOTAL RESOURCE OFFICERS 90,854 392,297 301,443 77% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL-SALARIES 10,754 52,723 41,969 80% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 2,323 9,500 7,177 76% 1000-413-420145-155 RETIREMENT 939 4,109 3,170 77% ------------------------------------------------- SUBTOTAL ANIMAL CONTROL 14,016 66,832 52,816 79% PARKING 1000-413-420147-110 PARKINGS -SALARIES 20,413 96,050 75,637 79% 1000-413-420147-153 HEALTH INSURANCE 8,520 32,921 24,401 74% 1000-413-420147-155 RETIREMENT 1,798 7,695 5,897 77% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 646 4,000 3,354 84% 1000-413-420147-354 CONTRACTED SERVICES 62 2,000 1,938 97% 1000-413-420147-362 LOT MAINT 263 10,000 9,737 97% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 0 17,500 17,500 100% 1000-413-420147-550 LOT LEASE PAYMENTS 236 1,500 1,264 84% ------------------------------------------------- SUBTOTAL PARKING 31,937 171,666 139,729 81% ------------------------------------------------- SUBTOTAL POLICE DEPT. 1,360,492 6,022,086 4,661,594 77% THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 8 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES-FIRE SUPPRESSION 385,814 2,195,634 1,809,820 82% 1000-416-420400-112 SALARY-SEVERANCE 5,036 0 5,036- 0% 1000-416-420400-114 COMPTIME BUYOUT 0 5,500 5,500 100% 1000-416-420400-115 OUT OF RANK PAY 3,036 12,500 9,464 76% 1000-416-420400-121 OVERTIME 37,001 40,000 2,999 8% 1000-416-420400-153 HEALTH INSURANCE 82,226 440,413 358,187 81% 1000-416-420400-155 RETIREMENT 51,778 290,559 238,781 82% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 144 4,710 4,566 97% 1000-416-420400-218 Equipment (Non Capital) 125 21,500 21,375 99% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 3,295 15,000 11,705 78% 1000-416-420400-224 JANITORIAL SUPPLIES 1,180 5,150 3,970 77% 1000-416-420400-231 GAS 3,004 17,325 14,321 83% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 3,095 15,750 12,655 80% 1000-416-420400-320 PRINTING 190 200 10 5% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 0 1,250 1,250 100% 1000-416-420400-345 TELEPHONE & COMMUNICATION 864 5,000 4,136 83% 1000-416-420400-354 CONTRACT SERVICES 9,900 17,460 7,560 43% 1000-416-420400-362 EQUIPMENT MAINTENANCE 245 5,500 5,255 96% 1000-416-420400-366 BUILDING MAINTENANCE-STATION 62 473 7,500 7,027 94% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 569 5,000 4,431 89% 1000-416-420400-373 DUES & TRAINING 837 10,000 9,163 92% 1000-416-420400-388 FIREFIGHTER PHYSICALS 1,262 30,800 29,538 96% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 7,265 29,061 21,796 75% 1000-416-420400-610 DEBT RETIREMENT-FIRE TRUCK 22,698 45,636 22,938 50% 1000-416-420400-620 INTEREST EXPENSE-FIRE TRUCK 2,836 5,720 2,884 50% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 62,500 250,000 187,500 75% 1000-416-420400-821 TFR - 2956 AFG ($5,300) 0 5,300 5,300 100% 1000-416-420400-940 CAPITAL EQUIPMENT-VEHICLE/SCBA/SERV 0 347,500 347,500 100% 1000-416-420440-110 SALARIES-FIRE PREVENTION 5,514 26,242 20,728 79% 1000-416-420440-121 OVERTIME 779 0 779- 0% 1000-416-420440-153 HEALTH INSURANCE 1,460 6,101 4,641 76% 1000-416-420440-155 RETIREMENT 506 2,027 1,521 75% ------------------------------------------------- SUBTOTAL FIRE DEPT. 693,637 3,864,338 3,170,701 82% ------------------------------------------------- GRAND TOTAL GENERAL FUND 3,351,342 14,730,961 11,379,619 77% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 9 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 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 20,213 1,147,000 1,126,787 98% 2215-000-311200-000 PERSONAL PROPERTY TAXES 24,408 24,675 267 1% 2215-000-312000-000 PEN & INTEREST DEL TAXES 946 1,500 554 37% 2215-000-334000-000 GRANT - POOL IMPROVEMENTS 0 86,000 86,000 100% 2215-000-346030-000 SWIMMING POOL FEES 77,040 155,000 77,960 50% 2215-000-346040-000 CONCESSION STAND REVENUE 33,308 42,000 8,692 21% 2215-000-346050-000 PARKS USAGE FEES 6,037 20,000 13,963 70% 2215-000-346051-000 RECREATION FEES 4,939 39,010 34,071 87% 2215-000-346052-000 SPORTS PROGRAMS 26,817 81,728 54,911 67% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 2 2,700 2,698 100% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 19,119 67,554 48,435 72% 2215-000-346055-000 ICE RINK 0 22,000 22,000 100% 2215-000-346056-000 KIDSPORT USAGE 546 3,000 2,454 82% 2215-000-346057-000 YOUTH CAMPS 35 192,244 192,209 100% 2215-000-346059-000 PICNIC IN THE PARK 2,973 26,500 23,527 89% 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 1,097 0 1,097- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-371010-000 INVESTMENTS 989 5,000 4,011 80% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 0 111,000 111,000 100% ------------------------------------------------- TOTAL PARKS & REC REVENUE 218,470 2,046,911 1,828,441 89% ================================================= PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES-PARKS 87,606 380,186 292,581 77% 2215-436-460430-111 SEASONAL SALARIES 18,353 89,519 71,166 80% 2215-436-460430-121 OVERTIME 0 300 300 100% 2215-436-460430-153 HEALTH INSURANCE 16,501 65,846 49,345 75% 2215-436-460430-155 RETIREMENT 9,001 34,562 25,561 74% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 134 2,000 1,866 93% 2215-436-460430-215 EQUIPMENT - not capital 0 3,000 3,000 100% 2215-436-460430-224 JANITORIAL SUPPLIES 1,416 7,000 5,584 80% 2215-436-460430-229 OTHER SUPPLIES 2,593 10,000 7,407 74% 2215-436-460430-231 GAS 4,572 17,000 12,428 73% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 38 3,000 2,962 99% 2215-436-460430-320 PRINTING & ADVERTISING 178 200 22 11% 2215-436-460430-341 ELECTRICITY 4,381 13,000 8,619 66% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 0 22,000 22,000 100% 2215-436-460430-344 NATURAL GAS 163 2,030 1,867 92% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 462 2,500 2,038 82% 2215-436-460430-351 SPORTS COURT & SPORT MAINTENANCE 0 2,000 2,000 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 2,000 2,000 100% 2215-436-460430-355 CONTRACT SERV. TRAIL MAINT/WEED CON 356 18,000 17,644 98% 2215-436-460430-356 CONSULTANTS - PRELIMINARY DESIGN HW 0 40,000 40,000 100% 2215-436-460430-357 CONSULTANTS - LAWRANCE PARK TRAIL 0 12,000 12,000 100% 2215-436-460430-358 FVCC TENNIS INTERLOCAL AGREEMENT 0 7,000 7,000 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 536 8,000 7,464 93% 2215-436-460430-364 LANDSCAPING 0 5,450 5,450 100% THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 10 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-367 VANDALISM REPAIRS 511 4,000 3,489 87% 2215-436-460430-373 DUES & TRAINING 2,051 8,000 5,949 74% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 0 500 500 100% 2215-436-460430-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 272 6,500 6,228 96% 2215-436-460430-440 IRRIGATION SUPPLIES 1,223 7,000 5,777 83% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 378 2,000 1,622 81% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 8,241 32,965 24,724 75% 2215-436-460430-545 COUNTY LANDFILL 0 6,273 6,273 100% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 30,056 60,234 30,178 50% 2215-436-460430-620 DEBT SERVICE INTEREST 1,020 2,056 1,036 50% ------------------------------------------------- SUBTOTAL PARKS EXPENDITURES 190,040 876,621 686,581 78% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES-COMPLEX 22,725 121,391 98,666 81% 2215-436-460440-111 SEASONAL SALARIES 15,881 45,190 29,309 65% 2215-436-460440-121 OVERTIME 0 300 300 100% 2215-436-460440-153 HEALTH INSURANCE 6,290 32,672 26,382 81% 2215-436-460440-155 RETIREMENT 3,113 11,483 8,370 73% 2215-436-460440-221 SAFETY EQUIPMENT 0 300 300 100% 2215-436-460440-229 OTHER SUPPLIES 1,468 22,000 20,532 93% 2215-436-460440-231 GAS 3,346 8,240 4,894 59% 2215-436-460440-241 CONSUMABLE TOOLS 230 780 550 70% 2215-436-460440-341 ELECTRICITY 5,120 11,656 6,536 56% 2215-436-460440-345 TELEPHONE & COMMUNICATION 58 251 193 77% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 76 500 424 85% 2215-436-460440-364 LANDSCAPING 0 300 300 100% 2215-436-460440-367 VANDALISM REPAIRS 0 500 500 100% 2215-436-460440-373 DUES & TRAINING 0 700 700 100% 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 165 200 35 18% 2215-436-460440-395 RENTAL EQUIPMENT 0 200 200 100% 2215-436-460440-420 METAL PRODUCTS 246 6,000 5,754 96% 2215-436-460440-440 IRRIGATION 2,262 7,000 4,738 68% 2215-436-460440-452 SAND & GRAVEL 245 1,500 1,255 84% 2215-436-460440-521 CENTRAL GARAGE TRANSFER 2,035 8,139 6,104 75% 2215-436-460440-545 COUNTY LANDFILL 0 3,500 3,500 100% 2215-436-460440-940 EQUIPMENT - (RIDING PAINT STRIPER) 0 15,000 15,000 100% ------------------------------------------------- SUBTOTAL ATHLETIC COMPLEX 63,261 298,802 235,541 79% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES-RECREATION 20,515 98,805 78,290 79% 2215-436-460431-111 SEASONAL SALARIES 1,030 22,490 21,460 95% 2215-436-460431-153 HEALTH INSURANCE 4,164 21,999 17,835 81% 2215-436-460431-155 RETIREMENT 1,678 9,674 7,996 83% 2215-436-460431-229 MISC. SUPPLIES 2,316 13,560 11,244 83% 2215-436-460431-231 GAS 54 575 521 91% 2215-436-460431-320 PRINTING & ADVERTISING 0 7,900 7,900 100% 2215-436-460431-345 TELEPHONE & COMMUNICATION 220 1,126 906 80% 2215-436-460431-354 CONTRACT SERVICES 28,880 40,462 11,582 29% 2215-436-460431-357 MUSIC FRANCHISE FEES 0 1,400 1,400 100% 2215-436-460431-373 DUES & TRAINING 454 1,000 546 55% THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 11 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ------------------------------------------------- SUBTOTAL RECREATION 59,309 218,991 159,682 73% YOUTH CAMPS 2215-436-460448-110 SALARIES-YOUTH CAMPS 17,819 87,665 69,846 80% 2215-436-460448-111 SEASONAL SALARIES 69,855 153,655 83,800 55% 2215-436-460448-121 OVERTIME 221 150 71- -47% 2215-436-460448-153 HEALTH INSURANCE 3,932 18,708 14,776 79% 2215-436-460448-155 RETIREMENT 1,457 8,022 6,565 82% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 278 250 28- -11% 2215-436-460448-229 MISC. SUPPLIES 3,175 3,665 490 13% 2215-436-460448-231 GAS 0 400 400 100% 2215-436-460448-320 PRINTING & ADVERTISING 0 380 380 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 283 1,246 963 77% 2215-436-460448-354 CONTRACT SERVICES 7,386 20,985 13,599 65% 2215-436-460448-355 AFTER SCHOOL PROGRAM 0 1,200 1,200 100% 2215-436-460448-356 BANK FEES/CC CHARGES 924 4,700 3,776 80% 2215-436-460448-373 DUES & TRAINING 479 1,000 521 52% ------------------------------------------------- SUBTOTAL YOUTH CAMPS 105,808 302,026 196,218 65% PARKLINE TRAIL MAINTENANCE 2215-436-460457-110 SALARIES - PARK LINE TRAIL 0 45,812 45,812 100% 2215-436-460457-111 SALARIES - SEASONAL 0 17,220 17,220 100% 2215-436-460457-121 OVERTIME 0 300 300 100% 2215-436-460457-153 HEALTH INSURANCE 0 18,798 18,798 100% 2215-436-460457-155 RETIREMENT 0 2,808 2,808 100% 2215-436-460457-210 OFFICE SUPPLIES, EQUIP./COMPUTERS 0 300 300 100% 2215-436-460457-215 EQUIPMENT - NOT CAPITAL 0 1,300 1,300 100% 2215-436-460457-224 JANITORIAL SUPPLIES 0 2,200 2,200 100% 2215-436-460457-229 OTHER SUPPLIES (FERTILIZER, WEED SP 0 3,500 3,500 100% 2215-436-460457-231 GAS 0 4,000 4,000 100% 2215-436-460457-241 TOOLS/ SMALL EQUIP./ SAFETY EQUIP. 0 700 700 100% 2215-436-460457-341 ELECTRICITY 0 4,000 4,000 100% 2215-436-460457-345 TELEPHONE & COMMUNICATIONS 0 600 600 100% 2215-436-460457-355 CONTRACT SERVICES - TRAIL MAINT./WE 0 6,000 6,000 100% 2215-436-460457-362 EQUIPMENT / AMENITY MAINTENANCE 0 1,500 1,500 100% 2215-436-460457-364 LANDSCAPE MATERIALS 0 100 100 100% 2215-436-460457-367 VANDALISM REPAIRS 0 1,200 1,200 100% 2215-436-460457-373 DUES & TRAINING 0 600 600 100% 2215-436-460457-388 MEDICAL SERVICES: DRUG TESTING 0 100 100 100% 2215-436-460457-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460457-440 IRRIGATION SUPPLIES 0 1,200 1,200 100% 2215-436-460457-452 TOP SOIL, DECROATIVE MINERLA MULCH 0 750 750 100% 2215-436-460457-545 COUNTY LANDFILL 0 3,500 3,500 100% 2215-436-460457-941 EQUIPMENT - TOOLCAT (FY22) 0 80,000 80,000 100% ------------------------------------------------- SUBTOTAL PARKLINE TRAIL MAINTE 0 196,988 196,988 100% POOL 2215-437-460445-111 SEASONAL SALARIES-POOL 129,689 197,345 67,656 34% 2215-437-460445-121 OVERTIME 1,845 200 1,645- -822% 2215-437-460445-155 RETIREMENT 562 1,500 938 63% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 114 500 386 77% THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 12 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 2,345 2,000 345- -17% 2215-437-460445-226 CHLORINE/CHEMICALS 27,186 40,000 12,814 32% 2215-437-460445-228 CONCESSION STAND SUPPLIES 16,881 21,000 4,119 20% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 399 4,000 3,601 90% 2215-437-460445-341 ELECTRICITY 4,397 9,500 5,103 54% 2215-437-460445-344 NATURAL GAS 10,817 25,000 14,183 57% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 700 2,500 1,800 72% 2215-437-460445-354 LICENSES & FEES 93 1,400 1,307 93% 2215-437-460445-356 BANK FEES/ CC CHARGES 2,889 2,300 589- -26% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 1,897 13,000 11,103 85% 2215-437-460445-367 VANDALISM 0 1,000 1,000 100% 2215-437-460445-380 TRAINING MATERIALS 560 1,800 1,240 69% 2215-437-460445-932 EQUIPMENT / POOL IMPROVEMENTS 0 172,000 172,000 100% ------------------------------------------------- SUBTOTAL POOL EXPENDITURES 200,376 495,045 294,669 60% ------------------------------------------------- TOTAL PARKS & RECREATION/POOL 618,793 2,388,473 1,769,680 74% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 13 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING URBAN FORESTRY 2600-436-460433-110 SALARIES-URBAN FORESTRY 48,620 214,844 166,224 77% 2600-436-460433-111 SEASONAL SERVICES 4,129 49,185 45,056 92% 2600-436-460433-121 OVERTIME 0 1,000 1,000 100% 2600-436-460433-153 HEALTH INSURANCE 11,320 46,165 34,845 75% 2600-436-460433-155 RETIREMENT 4,218 21,094 16,876 80% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 3,494 3,500 6 0% 2600-436-460433-231 GAS 1,085 5,900 4,815 82% 2600-436-460433-241 CONSUMABLE TOOLS 116 5,200 5,084 98% 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 155 662 507 77% 2600-436-460433-354 CONTRACT SERVICES 13,407 170,000 156,593 92% 2600-436-460433-357 FORESTRY GRANT 0 4,138 4,138 100% 2600-436-460433-358 EAB MONITORING/ARBOR DAY 0 4,750 4,750 100% 2600-436-460433-362 EQUIPMENT MAINTENANCE 32 4,000 3,968 99% 2600-436-460433-364 LANDSCAPING & TREES 3,695 8,000 4,305 54% 2600-436-460433-373 DUES & TRAINING 682 5,000 4,318 86% 2600-436-460433-388 MEDICAL 165 300 135 45% 2600-436-460433-395 EQUIPMENT RENTAL 0 7,200 7,200 100% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 6,609 6,609 0- -0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 3,193 12,771 9,578 75% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 5,106 20,424 15,318 75% 2600-436-460433-528 INFORMATION TECHNOLOGY TRANSFER 2,734 10,937 8,203 75% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 5,157 10,374 5,217 50% 2600-436-460433-620 INTEREST EXPENSE 85 171 86 50% ------------------------------------------------- TOTAL URBAN FORESTRY 114,002 612,224 498,222 81% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 14 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 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 126,137 700,000 573,863 82% 2230-000-342070-000 COUNTY EMS LEVY 0 140,000 140,000 100% 2230-000-365000-000 DONATIONS/SALE OF EQUIP/MISC 1,206 0 1,206- 0% 2230-000-371010-000 INTEREST EARNINGS 37 0 37- 0% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 62,500 250,000 187,500 75% ------------------------------------------------- TOTAL AMBULANCE REVENUE 189,880 1,090,000 900,120 83% ================================================= AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 128,002 675,510 547,508 81% 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 6,474 30,000 23,526 78% 2230-440-420730-153 HEALTH INSURANCE 21,551 118,649 97,098 82% 2230-440-420730-155 RETIREMENT 16,614 87,776 71,162 81% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 0 3,400 3,400 100% 2230-440-420730-218 NON-CAPITAL EQUIPMENT 0 4,200 4,200 100% 2230-440-420730-231 GAS & OIL 1,373 7,560 6,187 82% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 0 4,000 4,000 100% 2230-440-420730-312 POSTAGE/PRINTING 0 1,000 1,000 100% 2230-440-420730-345 TELEPHONE & COMMUNICATION 242 1,700 1,458 86% 2230-440-420730-354 CONTRACT SERVICES 5,650 20,040 14,390 72% 2230-440-420730-359 COLLECTION / CC FEES / AUDIT FEES 1,196 1,650 454 28% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 0 5,000 5,000 100% 2230-440-420730-373 DUES & TRAINING 3,658 12,000 8,342 70% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 32 2,500 2,468 99% 2230-440-420730-391 MEDICAL TREATMENT-SUPPLIES 11,776 54,315 42,539 78% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 13,041 13,041 0 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 3,337 13,347 10,010 75% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 12,387 49,548 37,161 75% 2230-440-420730-528 INFORMATION TECHNOLOGY TRANSFER 10,937 43,748 32,811 75% 2230-440-420730-610 PRINCIPAL - AMBULANCE 18,323 36,437 18,114 50% 2230-440-420730-620 INTEREST - AMBULANCE 1,952 3,126 1,174 38% ------------------------------------------------- TOTAL AMBULANCE EXPENDITURES 256,544 1,195,347 938,803 79% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 15 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 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 8,029 20,000 11,971 60% 2399-000-341073-000 FIRE IMPACT FEES 100,529 250,000 149,471 60% 2399-000-371010-000 INVESTMENT EARNINGS 1,725 10,000 8,275 83% ------------------------------------------------- TOTAL PS IMPACT FEE REV 110,283 280,000 169,717 61% ================================================= PUBLIC SAFETY IMPACT FEE EXP 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 3,750 15,000 11,250 75% 2399-413-420140-610 PRINCIPAL - IMPOUND/STORAGE 0 12,000 12,000 100% 2399-413-420140-620 INTEREST - IMPOUND/STORAGE 0 3,000 3,000 100% 2399-413-420140-920 IMPOUND/STORAGE FACILITY 1,494 77,560 76,066 98% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 1,500,000 1,500,000 100% ------------------------------------------------- TOTAL PS IMPACT FEE EXP 5,244 1,607,560 1,602,316 100% ================================================= FIRE & HAZMAT GRANTS 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 1,701 5,000 3,299 66% 2956-416-420415-940 AFG GRT FY22 RADIO 0 58,300 58,300 100% ------------------------------------------------- TOTAL FIRE GRANTS 1,701 63,300 61,599 97% ================================================= 2957-416-420400-221 DoMA EQUIP (REIMB) 0 14,809 14,809 100% 2957-416-420410-125 PASS THRU HAZMAT OT 117 5,000 4,883 98% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 13,403 10,000 3,403- -34% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 3,000 3,000 100% ------------------------------------------------- TOTAL HAZMAT GRANT 13,520 32,809 19,289 59% ================================================= 2958-416-420455-240 SUPPLIES AND EQUIPMENT 0 40,000 40,000 100% ------------------------------------------------- TOTAL HAZMAT EQUIP. SUSTAINMEN 0 40,000 40,000 100% ================================================= SAFER GRANT 2995-416-420400-110 SALARIES 0 150,000 150,000 100% 2995-416-420400-153 HEALTH INSURANCE 0 40,982 40,982 100% 2995-416-420400-155 RETIREMENT 0 21,540 21,540 100% ------------------------------------------------- TOTAL SAFER GRANT 0 212,522 212,522 100% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 16 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 295,609 750,000 454,391 61% 2394-000-323103-000 PLUMBING PERMITS 24,274 50,000 25,727 51% 2394-000-323104-000 MECHANICAL PERMITS 25,559 50,000 24,441 49% 2394-000-323105-000 ELECTRICAL PERMITS 31,864 90,000 58,136 65% 2394-000-323107-000 HOUSE MOVING PERMITS 180 0 180- 0% 2394-000-323108-000 PLAN REVIEW FEES 106,297 120,000 13,703 11% 2394-000-341025-000 MISC. COLLECTIONS/FEES 203 0 203- 0% 2394-000-371010-000 INVESTMENT EARNINGS 2,374 13,000 10,626 82% ------------------------------------------------- TOTAL REVENUE 486,359 1,285,522 799,163 62% ================================================= BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES-BUILDING DEPT. 121,309 577,109 455,800 79% 2394-420-420530-112 SALARIES-SEVERANCE 0 27,993 27,993 100% 2394-420-420530-121 OVERTIME 9,701 20,000 10,299 51% 2394-420-420530-153 HEALTH INSURANCE 24,622 103,135 78,513 76% 2394-420-420530-155 RETIREMENT 10,616 45,136 34,520 76% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 1,953 25,000 23,047 92% 2394-420-420530-231 GAS & OIL 775 4,000 3,225 81% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 366 6,000 5,635 94% 2394-420-420530-323 ST. ED. ASSESSMENTS 2,045 5,500 3,455 63% 2394-420-420530-345 TELEPHONE & COMMUNICATION 1,754 7,500 5,746 77% 2394-420-420530-353 AUDITING 0 5,500 5,500 100% 2394-420-420530-354 CONTRACT SERVICES 341 40,000 39,659 99% 2394-420-420530-355 CITY WORKS LICENSING FEE 22,265 18,500 3,765- -20% 2394-420-420530-356 ArcGIS SERVER UPGRADE LICENSE 8,036 6,000 2,036- -34% 2394-420-420530-357 CREDIT CARD / PAYPAL FEES 7,992 12,500 4,508 36% 2394-420-420530-360 FURNITURE 0 7,500 7,500 100% 2394-420-420530-373 DUES & TRAINING 1,571 30,000 28,430 95% 2394-420-420530-510 PROPERTY INSURANCE 10,692 10,692 0 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 746 2,766 2,020 73% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 8,772 35,089 26,317 75% 2394-420-420530-528 INFORMATION TECHNOLOGY TRANSFER 33,069 132,274 99,205 75% 2394-420-420530-920 BUILDING IMPROVEMENTS 723 0 723- 0% 2394-420-420530-944 VEHICLE (FY22) 0 37,500 37,500 100% ------------------------------------------------- TOTAL BUILDING DEPT. 267,346 1,159,694 892,348 77% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 17 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 18,585 82,065 63,480 77% 2400-410-430263-153 HEALTH INSURANCE 3,088 14,700 11,612 79% 2400-410-430263-155 RETIREMENT 1,471 6,408 4,937 77% 2400-410-430263-244 STREET LIGHT SUPPLIES 30 18,000 17,970 100% 2400-410-430263-245 LUMINAIRES 4,719 30,000 25,281 84% 2400-410-430263-341 ELECTRICITY 40,134 182,000 141,866 78% 2400-410-430263-360 REPAIR & MAINT SERVICES 3,729 21,500 17,771 83% 2400-410-430263-373 DUES & TRAINING 0 3,500 3,500 100% 2400-410-430263-510 INSURANCE 1,846 1,850 4 0% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 3,434 13,734 10,300 75% 2400-410-430263-528 INFORMATION TECH TRANSFER 6,031 24,125 18,094 75% 2400-410-430263-940 MACHINERY & EQUIPMENT 4,549 5,000 452 9% 2400-410-430263-944 MACHINERY & EQUIPMENT 0 70,000 70,000 100% ------------------------------------------------- TOTAL LIGHT MAINT. 87,615 472,882 385,267 81% ================================================= 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 32,408 99,000 66,592 67% 2420-421-430234-957 ALLEY PAVING 23,243 54,882 31,639 58% 2420-421-430240-231 GAS & OIL 5,517 42,000 36,483 87% 2420-421-430240-344 NATURAL GAS 95 6,800 6,705 99% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 100% 2420-421-430240-360 REPAIR & MAINT SERVICES 209 1,500 1,291 86% 2420-421-430240-368 OVERLAY/CHIPSEALS 124,288 585,642 461,354 79% 2420-421-430240-452 GRAVEL 0 5,000 5,000 100% 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 6,423 58,000 51,577 89% 2420-421-430240-472 ASPHALT 20,622 40,000 19,378 48% 2420-421-430240-473 CRACK SEALING 4,998 18,000 13,002 72% 2420-421-430240-474 PAINT STRIPING MATERIALS 9,826 30,000 20,174 67% ------------------------------------------------- TOTAL GAS TAX 227,631 965,824 738,193 76% ================================================= BARSAA (GAS TAX) 2421-421-430240-354 PAVEMENT MAINTENANCE 391,420 476,016 84,596 18% ------------------------------------------------- TOTAL BARSAA 391,420 476,016 84,596 18% ================================================= 2825 MACI GRANT 2825-421-430240-940 EQUIPMENT 0 242,814 242,814 100% ------------------------------------------------- TOTAL MACI GRANT 0 242,814 242,814 100% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 18 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 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. 198,996 886,253 687,257 78% 2500-421-430240-121 OVERTIME 80 28,000 27,920 100% 2500-421-430240-153 HEALTH INSURANCE 43,227 184,961 141,734 77% 2500-421-430240-155 RETIREMENT 15,760 69,499 53,739 77% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 8,640 25,545 16,905 66% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 157 7,000 6,843 98% 2500-421-430240-220 OTHER SUPPLIES 251 4,500 4,249 94% 2500-421-430240-231 GAS & OIL 5,517 42,000 36,483 87% 2500-421-430240-341 ELECTRICITY 499 3,500 3,001 86% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 604 3,330 2,726 82% 2500-421-430240-354 CONTRACT SERVICES 5,246 22,500 17,254 77% 2500-421-430240-356 TRANSPORTATION PLAN 0 15,000 15,000 100% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 1,532 41,000 39,468 96% 2500-421-430240-366 BUILDING MAINTENANCE 147 5,000 4,853 97% 2500-421-430240-373 DUES & TRAINING 310 13,000 12,690 98% 2500-421-430240-388 MEDICAL SERVICES 215 1,000 785 79% 2500-421-430240-510 LIABILITY INSURANCE 35,156 35,156 0 0% 2500-421-430240-512 UNINSURED LOSS-DEDUCTIBLE 0 45,000 45,000 100% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 52,456 209,822 157,366 75% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 27,755 111,018 83,263 75% 2500-421-430240-528 INFORMATION TECHNOLOGY TRANSFER 11,752 47,008 35,256 75% 2500-421-430240-840 MACI GRANT MATCH - WTR/DE-ICER TRK 0 15,000 15,000 100% 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 0 26,573 26,573 100% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 0 12,758 12,758 100% 2500-421-430244-354 PAVEMENT REPAIRS-PAVEMENT MNT FUNDS 106,533 509,666 403,133 79% 2500-421-430244-820 TRANSFER TO BaRSAA 0 23,750 23,750 100% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 0 632,700 632,700 100% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,380 27,380 100% ------------------------------------------------- TOTAL STREET MAINT. 514,833 3,047,919 2,533,086 83% ------------------------------------------------- SIGNS AND SIGNALS 2500-421-430264-110 TSS - SALARIES 26,504 113,067 86,563 77% 2500-421-430264-121 OVERTIME 0 7,500 7,500 100% 2500-421-430264-153 HEALTH INSURANCE 9,738 37,596 27,858 74% 2500-421-430264-155 RETIREMENT 2,097 8,810 6,713 76% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 611 5,960 5,349 90% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 427 7,000 6,573 94% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 2,654 4,000 1,346 34% 2500-421-430264-242 STREET SIGNS 6,228 30,000 23,772 79% 2500-421-430264-243 TRAFFIC SIGNALS 0 50,459 50,459 100% 2500-421-430264-245 BARRICADE MATERIALS 0 6,000 6,000 100% 2500-421-430264-341 ELECTRICITY 384 3,000 2,616 87% 2500-421-430264-345 COMMUNICATIONS 259 1,330 1,071 80% 2500-421-430264-354 CONTRACT SERVICES 554 10,000 9,446 94% 2500-421-430264-362 EQUIPMENT MAINTENANCE 365 3,000 2,635 88% 2500-421-430264-366 BUILDING MAINTENANCE 115 5,000 4,885 98% 2500-421-430264-373 DUES & TRAINING 1,867 7,500 5,633 75% 2500-421-430264-428 PAINT MATERIALS 45 5,000 4,955 99% 2500-421-430264-510 LIABILITY INS.-TSS 3,280 3,280 0- 0% 2500-421-430264-512 UNINSURED LOSS-DEDUCTIBLE 0 1,000 1,000 100% THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 19 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500-421-430264-521 CENTRAL GARAGE TRANSFER 1,807 7,227 5,420 75% 2500-421-430264-940 MACHINERY & EQUIPMENT 4,549 5,000 452 9% ------------------------------------------------- TOTAL SIGNS AND SIGNALS 61,484 321,729 260,245 81% ------------------------------------------------- TOTAL STREET MAINT. & SIGNS 576,317 3,369,648 2,793,331 83% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 20 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2188 WESTSIDE TIF REVENUE 2188-000-371010-000 INVESTMENT EARNINGS 1,189 2,300 1,111 48% 2188-000-373010-000 INTEREST / LOANS 4,146 14,005 9,859 70% 2188-000-373020-000 PRINCIPAL / LOANS 4,655 19,271 14,616 76% 2188-000-381060-000 TRANSFER FROM GENERAL FUND 225,000 900,000 675,000 75% 2188-000-383001-000 TRANSFER FROM DEBT SERVICE (3188) 0 900,000 900,000 100% 2188-000-383002-000 TRANSFER FROM 2880 CD 225,000 225,000 0 0% 2188-000-383003-000 TRANSFER FROM 2881 CD 300,000 300,000 0 0% 2188-000-383004-000 TRANSFER FROM 2312 RAIL PARK TEDD 35,000 140,000 105,000 75% 2188-000-383005-000 TRANSFER FROM 2886 - OLD SCHOOL LOT 225,000 828,135 603,135 73% ------------------------------------------------- TOTAL REVENUE 1,019,989 3,328,711 2,308,722 69% ================================================= EXPENDITURES 2188-480-470230-110 SALARIES 12,715 55,708 42,993 77% 2188-480-470230-153 HEALTH INSURANCE 2,677 10,556 7,879 75% 2188-480-470230-155 RETIREMENT 1,048 4,493 3,445 77% 2188-480-470230-353 AUDIT 0 1,500 1,500 100% 2188-480-470230-356 TELEPHONE 48 192 144 75% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 480 1,920 1,440 75% 2188-480-470440-930 CITY MATCH - TRAIL 64,064 4,443,135 4,379,071 99% ------------------------------------------------- TOTAL WESTSIDE TIF 81,032 4,517,504 4,436,472 98% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 21 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2185 AIRPORT TIF 2185-000-430300-840 REDEVELOPMENT ACTIVITY 22,646 240,459 217,813 91% ------------------------------------------------- TOTAL 2185 AIRPORT TIF 22,646 240,459 217,813 91% ================================================= OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 9,300 9,300 100% 2310-480-470210-356 FED-EX REIMBURSEMENT 0 8,862 8,862 100% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 12,500 50,000 37,500 75% 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 2,000 8,000 6,000 75% ------------------------------------------------- TOTAL OLD SCHOOL TIFS 14,500 76,162 61,662 81% ================================================= GLACIER RAIL PARK TEDD 2312-470-470210-810 TRANSFER - WESTSIDE TIF 35,000 140,000 105,000 75% 2312-480-470210-110 SALARIES & WAGES 6,012 26,594 20,582 77% 2312-480-470210-153 HEALTH INSURANCE 1,583 6,234 4,651 75% 2312-480-470210-155 RETIREMENT 495 2,164 1,669 77% 2312-480-470210-345 TELEPHONE 12 48 36 75% 2312-480-470210-353 AUDIT 0 1,500 1,500 100% 2312-480-470210-522 ADMINISTRATIVE TRANSFER 480 1,920 1,440 75% 2312-480-470210-795 REDEVELOPMENT / FCEDA REIMB 0 60,000 60,000 100% ------------------------------------------------- TOTAL GLACIER RAIL PARK TEDD 43,582 238,460 194,878 82% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 22 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-470-470210-810 TRANSFER - WESTSIDE TIF 225,000 225,000 0 0% 2880-480-470210-353 AUDITING 0 1,000 1,000 100% 2880-480-470210-354 CONTRACT SERVICES 143 1,000 857 86% ------------------------------------------------- TOTAL LOAN REVOLVING 225,143 227,000 1,857 1% ================================================= 2881 CD LOAN REV. #2 2881-470-470210-810 TRANSFER - WESTSIDE TIF 300,000 300,000 0 0% 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 0 405 405 100% ------------------------------------------------- TOTAL 2881 CD REV. #2 300,000 300,405 405 0% ================================================= 2886 CD MISC. 2886-480-470210-795 REDEVELOPMENT - OLD SCHOOL STATION 23,919 0 23,919- 0% 2886-480-470210-810 TRANSFER TO WS TIF 0 828,135 828,135 100% ------------------------------------------------- TOTAL CD MISC. 23,919 828,135 804,216 97% ================================================= 2887 RURAL DEVELOPMENT #1 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 0 19,204 19,204 100% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 0 2,870 2,870 100% 2887-480-470210-750 REDEVELOPMENT LOANS 0 150,000 150,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #1 0 172,074 172,074 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,553 8,553 100% 2888-480-470210-620 INTEREST EXPENSE-USDA LOAN 61-03 0 1,472 1,472 100% 2888-480-470210-750 REDEVELOPMENT LOANS 0 299,500 299,500 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #2 0 310,025 310,025 100% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 23 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2945 SAMARITAN HOUSE GRANT 2945-480-470243-790 REDEVELOPMENT - SAMARITIN HOUSE PRO 0 30,000 30,000 100% ------------------------------------------------- TOTAL SAMARITAN HOUSE GRANT 0 30,000 30,000 100% 2953 EPA BROWNFIELDS 2953-480-470210-354 CONT SERV/PETROLEUM 0 10,102 10,102 100% 2953-480-470215-373 TRAVEL/HAZARDOUS 160 5,382 5,222 97% ------------------------------------------------- TOTAL EPA BROWNSFIELD 160 15,484 15,324 99% ================================================= 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES-PETROLEUM 0 218,322 218,322 100% 2955-480-470210-725 REVOLVED FUNDS-PETROLEUM 0 100,500 100,500 100% 2955-480-470215-229 SUPPLIES-HAZARDOUS SUBSTANCES 0 267,673 267,673 100% ------------------------------------------------- TOTAL BROWNFIELDS LOAN REV. 0 586,495 586,495 100% ================================================= FY21 AIRPORT GRANT 2974-000-334020-000 MDT AERONAUTICS DIVISION GRANT ($23 0 236,712 236,712 100% 2974-430-430310-934 CAPITAL IMPROVEMENTS - LIGHTS/FENCI 0 236,712 236,712 100% ------------------------------------------------- TOTAL 2974 FY21 AIRPORT GRANT 0 473,424 473,424 100% ================================================= 2991 TIGER GRANT 2991-480-470245-790 REDEVELOPMENT - TRAIL 2,616,583 2,705,046 88,463 3% ------------------------------------------------- TOTAL TIGER GRANT 2,616,583 3,178,470 561,887 18% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 24 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD 364 10,000 9,636 96% 2915-413-420140-218 SMALL EQUIP -Stonegarden 0 30,000 30,000 100% ------------------------------------------------- TOTAL 2915 STONEGARDEN GRANT 364 40,000 39,636 99% ================================================= 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 13,785 69,682 55,897 80% 2916-413-420140-121 OVERTIME 3,643 13,000 9,357 72% 2916-413-420140-153 HEALTH INSURANCE 3,010 13,708 10,698 78% 2916-413-420140-155 RETIREMENT 1,913 9,352 7,439 80% ------------------------------------------------- TOTAL 2916 DRUG ENFORCEMENT 22,352 105,742 83,390 79% ================================================= 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 292 3,000 2,708 90% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 3,053 35,000 31,947 91% 2919-413-420140-127 SCHOOL DIST. OT 2,989 17,000 14,011 82% 2919-413-420140-218 JAG GRT/BODY ARMOR & BODY WORN CAME 1,612 13,000 11,388 88% 2919-413-420140-220 EQUIPMENT-FUNDED BY DONATIONS 9,031 4,000 5,031- -126% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 1,105 6,000 4,895 82% ------------------------------------------------- TOTAL LAW ENF. GRANT 18,082 78,000 59,918 77% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 25 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 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 WATER/SEWER INFRASTRUCTURE REC ACT 0 2,973,819 2,973,819 100% 4393-410-430550-951 WATER/SWR INFRASTRUCTURE PROJECTS - 0 2,973,819 2,973,819 100% ------------------------------------------------- TOTAL AMERICAN RESCUE PLAN GRA 0 5,947,638 5,947,638 100% 4170 IMPOUND/STORAGE FACILITY 4170-400-411230-925 IMPOUND / STORAGE FACILITY 0 250,000 250,000 100% ------------------------------------------------- TOTAL IMPOUND/STORAGE FACILITY 0 250,000 250,000 100% 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION 0 25,000 25,000 100% ------------------------------------------------- TOTAL 4290 WALK & CURB 0 25,000 25,000 100% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 26 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 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 733 2,000 1,268 63% 5210-000-343210-000 METERED WATER SALES 1,774,707 3,850,000 2,075,293 54% 5210-000-343220-000 OTHER (CONST.) WATER SALES 2,085 25,000 22,915 92% 5210-000-343230-000 METER REPLACEMENT FEE 41,065 150,000 108,935 73% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 22,941 52,500 29,560 56% 5210-000-343270-000 WATER TURN ON FEES 755 4,000 3,245 81% 5210-000-343275-000 TAG FEE 8,440 33,000 24,560 74% 5210-000-343365-000 LATECOMER ADMIN FEE 7,183 10,000 2,817 28% 5210-000-371010-000 INVESTMENT EARNINGS 12,772 55,000 42,228 77% 5210-000-383010-000 TRANSFER FROM IMPACT FEE FUND (ADMI 6,000 24,000 18,000 75% 5210-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 62,500 250,000 187,500 75% ------------------------------------------------- TOTAL WATER REVENUE 1,939,180 4,455,500 2,516,320 56% ================================================= WATER FACILITIES 5210-447-430550-110 SALARIES-WATER 176,732 863,706 686,974 80% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 793 20,000 19,207 96% 5210-447-430550-153 HEALTH INSURANCE 41,964 193,400 151,436 78% 5210-447-430550-155 RETIREMENT 14,074 67,212 53,138 79% 5210-447-430550-210 OFFICE SUPPLIES /EQUIP/COMPUTERS/GI 8,474 23,000 14,526 63% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 2,090 9,000 6,910 77% 5210-447-430550-226 CHLORINE & CHEMICALS 18,699 59,000 40,301 68% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 817 4,500 3,683 82% 5210-447-430550-231 GAS & OIL 4,468 35,000 30,532 87% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 73 1,000 927 93% 5210-447-430550-336 LICENSES & FEES 44 20,000 19,956 100% 5210-447-430550-341 ELECTRICITY 60,063 160,000 99,937 62% 5210-447-430550-344 NATURAL GAS 792 15,500 14,708 95% 5210-447-430550-345 TELEPHONE & COMMUNICATION 5,922 13,000 7,078 54% 5210-447-430550-349 LAB SERVICES 1,817 20,000 18,183 91% 5210-447-430550-353 AUDITING 0 3,500 3,500 100% 5210-447-430550-354 CONTRACT SERVICES 4,240 55,000 50,760 92% 5210-447-430550-355 NOFFSINGER TRANSMISSION CONDITION A 0 263,000 263,000 100% 5210-447-430550-356 BACKBONE CONDITION ASSESS./WTR RIGH 247 75,000 74,753 100% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 882 15,000 14,118 94% 5210-447-430550-366 BUILDING MAINTENANCE 846 15,000 14,154 94% 5210-447-430550-373 DUES & TRAINING 520 13,000 12,480 96% 5210-447-430550-388 MEDICAL SERVICES 140 700 560 80% 5210-447-430550-410 CONSTRUCTION MATERIALS 9,897 35,000 25,103 72% 5210-447-430550-422 HYDRANTS 0 10,000 10,000 100% 5210-447-430550-423 MATERIALS FOR MAINS 1,421 14,000 12,579 90% 5210-447-430550-424 MATERIALS -SERVICE LINES 1,350 12,000 10,650 89% 5210-447-430550-425 MATERIALS PUMPS/WELLS 3,049 65,000 61,951 95% 5210-447-430550-510 PROPERTY & LIABILITY INS. 34,319 34,319 0- 0% 5210-447-430550-512 UNINSURED LOSS-DEDUCTIBLE 0 10,000 10,000 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 11,787 47,148 35,361 75% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 30,212 120,846 90,634 75% 5210-447-430550-528 INFORMATION TECH TRANSFER 24,251 97,003 72,752 75% 5210-447-430550-532 LEASE PAYMENTS 0 4,000 4,000 100% 5210-447-430550-925 NOFFSINGER REHAB ALTERNATIVE 0 1,771,916 1,771,916 100% THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 27 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-935 METER SYSTEM REPLACEMENT 103,474 640,500 537,026 84% 5210-447-430550-940 MACHINERY & EQUIPMENT 0 127,200 127,200 100% 5210-447-430550-951 SECURITY SCADA UPGRADES 1,593 25,000 23,407 94% 5210-447-430550-954 ELEVATED STORAGE TANK & WELL 1,400 9,731,000 9,729,600 100% 5210-447-430550-958 2ND AVE W RR FROM CENTER TO 2ND ST 106,843 148,993 42,150 28% 5210-447-430550-969 DESIGN - LOWER ZONE RESERVOIRS ROOF 0 665,000 665,000 100% ------------------------------------------------- SUBTOTAL WATER FACILITIES 673,292 15,508,443 14,835,151 96% ------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES-WATER BILLING 31,223 134,700 103,477 77% 5210-447-430560-153 HEALTH INSURANCE 9,890 38,938 29,048 75% 5210-447-430560-155 RETIREMENT 2,552 10,854 8,302 76% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 1,400 16,000 14,600 91% 5210-447-430560-353 AUDITING 0 2,000 2,000 100% 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 10,869 45,000 34,131 76% 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 7,273 28,000 20,727 74% 5210-447-430560-356 OTHER CONTRACT SERVICES 20 1,000 980 98% 5210-447-430560-373 DUES & TRAINING 0 3,000 3,000 100% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 2,920 11,681 8,761 75% 5210-447-430560-528 INFORMATION TECH TRANSFER 19,140 76,558 57,418 75% ------------------------------------------------- SUBTOTAL WATER BILLING 85,286 367,731 282,445 77% ------------------------------------------------- REVENUE BONDS 5210-447-490200-610 PRIN - 4 MILE DR TRANSMISSION / WRF 0 86,000 86,000 100% 5210-447-490200-620 INT - 4 MILE DR TRANSMISSION / WRF 49,788 49,788 1 0% 5210-447-490204-610 BOND PRIN-HWY 93 S WTR - 2004 0 81,000 81,000 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 5,716 5,716 0- 0% 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 0 350 350 100% 5210-447-490206-610 PRIN-WELL/TANK/8114 2.25% 4TH ST 0 93,000 93,000 100% 5210-447-490206-620 INT-WELL&TANK/8114 2.25% 4TH ST WT 12,758 12,758 1 0% 5210-447-490210-610 4TH AVE E MAIN REPL/WRF 17393 0 85,320 85,320 100% 5210-447-490210-620 4TH AVE E MAIN REPL/WFR 17393 40,963 40,963 0 0% ------------------------------------------------- SUBTOTAL REVENUE BONDS 109,224 454,895 345,671 76% ------------------------------------------------- DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 950,000 950,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 950,000 950,000 100% ------------------------------------------------- TOTAL WATER FUND 867,803 17,281,069 16,413,266 95% ================================================= WATER IMPACT FEE REVENUE: 5211-000-343225-000 IMPACT FEES 236,865 700,000 463,135 66% 5211-000-371010-000 INTEREST EARNINGS 1,721 6,000 4,279 71% ------------------------------------------------- TOTAL WATER IMPACT FEES REVENU 238,586 706,000 467,414 66% THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 28 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ================================================= WATER IMPACT FEES EXPENSES: 5211-447-430555-424 METERS - NEW DEVELOPMENT 0 61,420 61,420 100% 5211-447-430555-820 DEBT SERVICE TRANSFER TO 5210 62,500 250,000 187,500 75% 5211-447-430555-825 TRANSFER TO 5210 FOR ADMIN 6,000 24,000 18,000 75% 5211-447-430555-930 CONTRACT MAIN UPSIZE 0 405,000 405,000 100% 5211-447-430555-954 ELEVATED TANK & WELL 0 701,986 701,986 100% ------------------------------------------------- TOTAL WATER IMPACT FEE EXPENSE 68,500 1,442,406 1,373,906 95% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 29 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 733 1,500 768 51% 5310-000-343310-000 SEWER SERVICE CHARGES 1,904,766 6,780,000 4,875,234 72% 5310-000-343320-000 NUTRIENT WORK GROUP ASSISTANCE REIM 13,597 0 13,597- 0% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 3,025 1,500 1,525- -102% 5310-000-343365-000 LATECOMER ADMIN FEES 4,561 2,000 2,561- -128% 5310-000-371010-000 INVESTMENT EARNINGS 9,242 33,000 23,758 72% 5310-000-383010-000 ADMIN TRANSFER FROM IMPACT FEE FUND 25,000 100,000 75,000 75% 5310-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 250,000 1,000,000 750,000 75% ------------------------------------------------- TOTAL SEWER REVENUE 2,210,923 7,918,000 5,707,077 72% ================================================= SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES-SEWER BILLING 26,611 116,145 89,534 77% 5310-454-430620-153 HEALTH INSURANCE 7,455 28,566 21,111 74% 5310-454-430620-155 RETIREMENT - PERD 2,168 9,219 7,051 76% 5310-454-430620-215 OFFICE SUPPLIES/computers 1,400 16,000 14,600 91% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 0 2,000 2,000 100% 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 10,869 45,000 34,131 76% 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 7,273 28,000 20,727 74% 5310-454-430620-356 OTHER CONTRACT SERVICES 20 1,000 980 98% 5310-454-430620-373 DUES & TRAINING 0 3,000 3,000 100% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 2,632 10,530 7,898 75% 5310-454-430620-528 INFORMATION TECH. TRANSFER 19,140 76,558 57,418 75% ------------------------------------------------- SUBTOTAL SEWER BILLING COSTS 77,567 336,018 258,451 77% ------------------------------------------------- SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES-SANITARY SEWER 63,993 350,322 286,329 82% 5310-454-430630-121 OVERTIME 82 5,500 5,418 99% 5310-454-430630-153 HEALTH INSURANCE 13,510 81,304 67,794 83% 5310-454-430630-155 RETIREMENT 5,132 27,223 22,091 81% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 7,118 13,450 6,332 47% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 131 8,350 8,219 98% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 269 2,300 2,031 88% 5310-454-430630-231 GAS & OIL 1,571 12,000 10,429 87% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 0 500 500 100% 5310-454-430630-341 ELECTRICITY 9,778 57,000 47,222 83% 5310-454-430630-344 NATURAL GAS 2,619 16,500 13,881 84% 5310-454-430630-345 TELEPHONE & COMMUNICATION 6,965 27,500 20,535 75% 5310-454-430630-353 AUDITING 0 3,000 3,000 100% 5310-454-430630-354 CONTRACT SERVICES 5,324 35,000 29,676 85% 5310-454-430630-356 CONSULTANTS - MODELING/RATE STUDY 0 20,000 20,000 100% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 1,263 11,500 10,237 89% 5310-454-430630-373 DUES & TRAINING 310 9,250 8,940 97% 5310-454-430630-388 MEDICAL SERVICES 85 500 415 83% 5310-454-430630-410 CONSTRUCTION MATERIALS 891 10,000 9,109 91% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 5,858 70,000 64,142 92% 5310-454-430630-510 PROPERTY & LIABILITY INS. 18,697 18,697 0 0% 5310-454-430630-512 UNINSURED LOSS-DEDUCTIBLE 0 25,000 25,000 100% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 3,239 12,955 9,716 75% THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 30 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-522 ADMINISTRATIVE TRANSFER 19,333 77,331 57,998 75% 5310-454-430630-528 INFORMATION TECH TRANSFER 15,669 62,678 47,009 75% 5310-454-430630-532 OFFICE RENT / BNSF LEASE 6,890 0 6,890- 0% 5310-454-430630-922 L.S. #9 IMPROVEMENTS/DESIGN 0 2,247,113 2,247,113 100% 5310-454-430630-940 MACHINERY & EQUIPMENT 0 258,372 258,372 100% 5310-454-430630-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 62,098 62,098 100% 5310-454-430630-954 MN REPL. DESIGN - 1ST & 2ND AVE EN 0 1,196,414 1,196,414 100% 5310-454-430630-958 DESIGN - L.S. #3 IMPROVEMENTS 0 418,510 418,510 100% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 0 50,000 50,000 100% 5310-454-430630-961 6TH ALLEY E - S OF 14TH & 13TH 0 339,231 339,231 100% ------------------------------------------------- SUBTOTAL SEWER COLLECTION 188,726 5,529,598 5,340,872 97% ------------------------------------------------- REVENUE BONDS/SANITARY 5310-454-490200-610 PRINCIPAL WESTSIDE INTERCEPTOR BOND 0 294,000 294,000 100% 5310-454-490200-620 INTEREST-WESTSIDE INTERCEPTOR BOND 279,150 279,150 0 0% 5310-454-490204-610 PRINCIPAL - HWY 93 S/SRF5125/2.25% 0 91,000 91,000 100% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 0 5,726 5,726 100% ------------------------------------------------- SUBTOTAL REVENUE BONDS 279,150 669,876 390,726 58% ------------------------------------------------- DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 500,000 500,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION-SANITARY 0 500,000 500,000 100% ------------------------------------------------- SUBTOTAL SANITARY SEWER 467,876 6,699,474 6,231,598 93% ------------------------------------------------- WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 108,273 509,354 401,081 79% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-121 OVERTIME 5,496 22,500 17,004 76% 5310-455-430640-153 HEALTH INSURANCE 22,625 95,202 72,577 76% 5310-455-430640-155 RETIREMENT 9,292 39,199 29,907 76% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 6,930 13,500 6,570 49% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 155 3,500 3,345 96% 5310-455-430640-225 ALUM 7,097 35,000 27,903 80% 5310-455-430640-226 CHLORINE & CHEMICALS 17,398 120,000 102,602 86% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 2,902 7,500 4,598 61% 5310-455-430640-231 GAS & OIL 2,153 19,000 16,847 89% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 21 550 529 96% 5310-455-430640-336 LICENSES & FEES 0 16,000 16,000 100% 5310-455-430640-341 ELECTRICITY 44,696 195,000 150,304 77% 5310-455-430640-342 WATER 391 7,500 7,109 95% 5310-455-430640-344 NATURAL GAS 4,107 82,000 77,893 95% 5310-455-430640-345 TELEPHONE & COMMUNICATION 1,657 12,050 10,393 86% 5310-455-430640-353 AUDITING 0 2,500 2,500 100% 5310-455-430640-354 CONTRACT-GLACIER GOLD 28,459 135,000 106,541 79% 5310-455-430640-355 CONTRACT - LAND FILL & OTHER 12,442 55,500 43,058 78% 5310-455-430640-356 CONSULTANTS 33,156 289,000 255,844 89% THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 31 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-358 CONSULTANT- PERMIT/RATE STDY/TMDL 67,015 205,000 137,985 67% 5310-455-430640-360 MISC. MAINT SERVICES 8,590 35,000 26,410 75% 5310-455-430640-366 BUILDING MAINTENANCE 4,254 40,000 35,746 89% 5310-455-430640-373 DUES & TRAINING 1,487 9,500 8,013 84% 5310-455-430640-388 MEDICAL SERVICES 80 500 420 84% 5310-455-430640-510 PROPERTY & LIABILITY INS. 52,332 52,332 0 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 4,686 18,746 14,060 75% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 30,026 120,105 90,079 75% 5310-455-430640-528 INFORMATION TECH TRANSFER 13,671 54,684 41,013 75% 5310-455-430640-921 DESIGN-DOME FOR SECONDARY CLARIFIER 0 419,000 419,000 100% 5310-455-430640-930 BIOSOLIDS ALTERNATE DISPOSAL ENG 0 178,052 178,052 100% 5310-455-430640-933 NEW EQ BASIN 0 2,420,000 2,420,000 100% ------------------------------------------------- SUBTOTAL WWTP OPERATIONS 489,392 5,217,774 4,728,382 91% ------------------------------------------------- WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 7,781 125,000 117,219 94% 5310-455-430645-922 DESIGN FERMENTER RECONSTRUCTION 16,175 6,200,000 6,183,825 100% 5310-455-430645-934 SECONDARY DIGESTER LID REPLC 13,247 21,235 7,988 38% 5310-455-430645-940 MACHINERY & EQUIPMENT 0 280,000 280,000 100% 5310-455-430645-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 112,325 112,325 100% ------------------------------------------------- SUBTOTAL WWTP REPLACEMENT 37,203 6,738,560 6,701,357 99% ------------------------------------------------- WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 29,461 132,414 102,953 78% 5310-455-430646-153 HEALTH INSURANCE 4,646 18,720 14,074 75% 5310-455-430646-155 RETIREMENT 2,392 10,131 7,739 76% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 1,000 6,000 5,000 83% 5310-455-430646-218 NON-CAPITAL EQUIPMENT 2,012 3,500 1,488 43% 5310-455-430646-222 LAB SUPPLIES 4,280 17,500 13,220 76% 5310-455-430646-349 LAB SERVICES 3,160 19,000 15,840 83% 5310-455-430646-350 PRETREATMENT SERVICE 1,549 15,000 13,451 90% 5310-455-430646-362 EQUIPMENT MAINTENANCE 301 5,500 5,199 95% 5310-455-430646-373 DUES & TRAINING 0 5,000 5,000 100% 5310-455-430646-940 EQUIPMENT - ANALYZER 0 8,500 8,500 100% ------------------------------------------------- SUBTOTAL WWTP LAB OPERATIONS 48,801 241,265 192,464 80% DEBT SERVICE - WWTP 5310-455-490227-610 PRINCIPAL - WWTP IMP/SRF8164R/2.25% 0 890,000 890,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 127,924 122,198 5,726- -5% 5310-455-490228-610 PRINC - WWTP DIGESTER LID/SRF 13326 0 52,000 52,000 100% 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 21,540 21,540 0 0% ------------------------------------------------- SUBTOTAL DEBT SERVICE - WWTP 149,464 1,085,738 936,274 86% ------------------------------------------------- DEPRECIATION/REPL. - WWTP 5310-455-510400-831 DEPR. EXP. - WWTP (INCLUDES 010125 0 1,250,000 1,250,000 100% ------------------------------------------------- SUTOTAL WWTP DEPRECIATION/REPL 0 1,250,000 1,250,000 100% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 32 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SUBTOTAL WWTP 724,860 14,533,337 13,808,477 95% ------------------------------------------------- TOTAL BILLING/SANITARY/WWTP 1,270,303 21,568,829 20,298,526 94% ================================================= SEWER IMPACT FEE REVENUE 5311-000-343330-000 SANITARY IMPACT FEES 405,846 900,000 494,154 55% 5311-000-343335-000 TREATMENT IMPACT FEES 243,146 500,000 256,854 51% 5311-000-371010-000 SANITARY INTEREST EARNINGS 3,080 12,000 8,920 74% 5311-000-371015-000 TREATMENT INTEREST EARNINGS 2,840 9,500 6,660 70% ------------------------------------------------- TOTAL SEWER IMPACT FEES REVENU 654,913 1,421,500 766,587 54% ================================================= SEWER IMPACT FEE EXPENSES 5311-454-430635-820 TRANSFER TO 5310 FOR DEBT (SANITARY 125,000 500,000 375,000 75% 5311-454-430635-825 TRANSFER TO 5310 FOR ADMIN 15,000 60,000 45,000 75% 5311-454-430635-950 RR & UPSIZE - WWTP MAIN (66% - 34% 0 120,542 120,542 100% 5311-454-430635-955 MAIN & L.S. UPSIZE 0 590,000 590,000 100% 5311-454-430635-958 DESIGN - L.S. #3 IMPROVEMENTS 0 356,509 356,509 100% 5311-455-430644-820 TRANSFER TO 5310 FOR DEBT 125,000 500,000 375,000 75% 5311-455-430644-825 TRANSFER TO 5310 FOR ADMIN 10,000 40,000 30,000 75% 5311-455-430644-929 CONSTRUCT NEW EQ BASIN 3,432 440,395 436,963 99% 5311-455-430644-930 BIOSOLIDS ALT. DISPOSAL ENG. (39%) 0 113,837 113,837 100% 5311-455-430644-950 RR & UPSIZE - WWTP MAIN (66% - 34% 0 218,679 218,679 100% ------------------------------------------------- TOTAL SEWER IMPACT FEE EXPENSE 278,432 2,939,962 2,661,530 91% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 33 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 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 733 1,000 268 27% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 0 1,500 1,500 100% 5349-000-343034-000 PERMIT FEES 830 1,000 170 17% 5349-000-343035-000 STORM SEWER CHARGES 1,498 1,000 498- -50% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 0 1,850,000 1,850,000 100% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 1,856 2,500 644 26% 5349-000-371010-000 INTEREST ON INVESTMENTS 4,325 20,000 15,675 78% 5349-000-383010-000 IMPACT FEE 5% ADMIN - TFR FROM IMPA 2,500 10,000 7,500 75% 5349-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 0 150,000 150,000 100% ------------------------------------------------- TOTAL STORM REVENUE 11,742 2,037,000 2,025,258 99% ================================================= STORM SEWER 5349-453-430246-110 SALARIES-STORM SEWER 107,639 537,579 429,940 80% 5349-453-430246-121 OVERTIME 82 4,000 3,918 98% 5349-453-430246-153 HEALTH INSURANCE 22,290 112,926 90,636 80% 5349-453-430246-155 RETIREMENT 8,655 41,860 33,205 79% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 11,728 17,100 5,372 31% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 0 6,000 6,000 100% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100% 5349-453-430246-231 GAS & OIL 1,571 11,500 9,929 86% 5349-453-430246-345 TELEPHONE & COMMUNICATION 670 3,000 2,330 78% 5349-453-430246-353 AUDITING 0 1,150 1,150 100% 5349-453-430246-354 CONTRACT SERVICE 1,254 7,000 5,746 82% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 3,600 35,000 31,400 90% 5349-453-430246-358 CONSULTANTS 0 10,000 10,000 100% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 0 30,000 30,000 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 380 5,000 4,620 92% 5349-453-430246-362 GROUNDWATER MONITORING 0 6,500 6,500 100% 5349-453-430246-371 CURB & GUTTER 686 21,000 20,314 97% 5349-453-430246-373 DUES & TRAINING 310 9,250 8,940 97% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 1,519 10,000 8,481 85% 5349-453-430246-510 PROPERTY & LIABILITY INS. 13,436 18,436 5,000 27% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 3,239 12,955 9,716 75% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 12,306 49,223 36,917 75% 5349-453-430246-528 INFORMATION TECH TRANSFER 14,612 58,450 43,838 75% 5349-453-430246-530 BNSF LEASE PMT 0 5,500 5,500 100% 5349-453-430246-968 RR W CENTER-7TH AVE W TO MERIDIAN 255,759 230,992 24,767- -11% 5349-453-430246-970 REG. FACILITIES & PIPING DESIGN (BO 993,877 2,486,434 1,492,557 60% 5349-453-430247-952 STORM DRAIN CORRECTION (NEW & C/O) 0 200,000 200,000 100% 5349-453-430247-954 N. MAIN ST STORMWATER PROJ. 0 252,500 252,500 100% 5349-453-430247-956 WYOMING STREET OUTFALL 0 225,000 225,000 100% 5349-453-430247-959 REGIONAL FACILITIES & PIPING DESIGN 12,095 351,606 339,511 97% 5349-453-430247-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% 5349-453-430247-968 RR W CENTER-7TH AVE W TO MERIDIAN 136,620 288,079 151,459 53% 5349-453-430247-969 1ST AVE W - S. OF CITY SHOPS 0 395,500 395,500 100% 5349-453-430249-940 MACHINERY FROM REPLACEMENT 0 258,431 258,431 100% ------------------------------------------------- SUBTOTAL STORM OPERATIONS 1,602,327 5,754,271 4,151,944 72% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 34 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM BONDS/LOANS 5349-453-490200-610 PRINCIPAL - 4TH AVE E BOND 0 3,107 3,107 100% 5349-453-490200-620 INTEREST-4TH AVE E BOND 1,492 1,492 0 0% 5349-453-490225-610 PRINCIPAL - REGIONAL FACILITIES 0 139,038 139,038 100% 5349-453-490225-620 INTEREST - REGIONAL FACILITIES 66,879 92,000 25,121 27% ------------------------------------------------- SUBTOTAL STORM BONDS/LOANS 68,371 235,637 167,266 71% ------------------------------------------------- DEPRECIATION 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 360,000 360,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 360,000 360,000 100% ------------------------------------------------- TOTAL STORM EXPENSE 1,670,698 6,349,908 4,679,210 74% ================================================= STORM SEWER IMPACT FEE REVENUE 5348-000-343033-000 IMPACT FEES 98,025 280,000 181,975 65% 5348-000-371010-000 INTEREST EARNINGS 2,233 9,000 6,767 75% ------------------------------------------------- TOTAL STORM IMPACT FEES REVENU 100,258 289,000 188,742 65% ================================================= STORM SWR IMPACT FEE EXPENSES 5348-453-430248-820 DEBT SERVICE TRANSFER TO 5349 0 150,000 150,000 100% 5348-453-430248-825 TRANSFER TO 5349 FOR ADMIN 2,500 10,000 7,500 75% 5348-453-430248-959 REG FACILITIES & PIPING DESIGN 12,095 1,237,829 1,225,734 99% 5348-453-430248-960 STORMWATER FACILITY UPSIZING (CARRY 0 230,000 230,000 100% 5348-453-430248-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% ------------------------------------------------- TOTAL STORM IMPACT FEE EXPENSE 14,595 1,677,829 1,663,234 99% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 35 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SOLID WASTE REVENUE: 5510-000-343360-000 SALE OF MAT/AUCTION 2,496 2,500 4 0% 5510-000-343410-000 GARBAGE COLLECTION-ASSESSED 0 1,060,000 1,060,000 100% 5510-000-343420-000 GARBAGE COLLECTION-NOT ASSESSED 995 25,000 24,005 96% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,260 2,000 740 37% 5510-000-371010-000 INVESTMENT EARNINGS 1,219 10,000 8,781 88% ------------------------------------------------- TOTAL SOLID WASTE REVENUE 5,970 1,099,500 1,093,530 99% ================================================= SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES-SOLID WASTE 107,238 471,278 364,040 77% 5510-460-430840-121 OVERTIME 1,197 6,500 5,303 82% 5510-460-430840-153 HEALTH INSURANCE 24,170 96,042 71,872 75% 5510-460-430840-155 RETIREMENT 8,584 36,556 27,972 77% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 8,908 15,500 6,592 43% 5510-460-430840-218 EQUIPMENT-GARBAGE CONTAINERS 21,141 37,500 16,359 44% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 176 5,500 5,324 97% 5510-460-430840-231 GAS & OIL 10,768 60,000 49,232 82% 5510-460-430840-341 ELECTRICITY 281 2,050 1,769 86% 5510-460-430840-344 NATURAL GAS 70 4,500 4,430 98% 5510-460-430840-345 TELEPHONE & COMMUNICATION 535 2,960 2,425 82% 5510-460-430840-354 CONTRACT SERVICES 713 22,000 21,287 97% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 2,926 55,000 52,074 95% 5510-460-430840-366 BUILDING MAINTENANCE 26 5,000 4,974 99% 5510-460-430840-373 DUES & TRAINING 302 7,000 6,698 96% 5510-460-430840-388 MEDICAL SERVICES 85 700 615 88% 5510-460-430840-510 PROPERTY & LIABILITY INS. 30,643 30,643 0- 0% 5510-460-430840-512 UNINSURED LOSS-DEDUCTIBLE 0 4,000 4,000 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 28,111 112,444 84,333 75% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 11,510 46,041 34,531 75% 5510-460-430840-528 INFORMATION TECH TRANSFER 11,752 47,008 35,256 75% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 10,000 40,000 30,000 75% 5510-460-430840-944 VEHICLES (Replacement $) 0 332,200 332,200 100% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% ------------------------------------------------- TOTAL SOLID WASTE EXPENSE 279,136 1,590,422 1,311,286 82% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 36 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 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 107,500 430,000 322,500 75% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 0 210,000 210,000 100% 6030-000-371010-000 INVESTMENT EARNINGS 366 1,100 734 67% 6030-000-393000-000 INTERNAL SERVICES-DATA 188,479 753,914 565,435 75% ------------------------------------------------- TOTAL INFORMATION TECH REVENUE 296,344 1,395,014 1,098,670 79% ================================================= INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 95,413 414,408 318,995 77% 6030-401-410580-121 OVERTIME 36 1,000 964 96% 6030-401-410580-153 HEALTH INSURANCE 22,306 90,081 67,775 75% 6030-401-410580-155 RETIREMENT 7,840 33,685 25,845 77% 6030-401-410588-218 COMPUTERS - ADMINISTRATIVE DEPTS 0 5,310 5,310 100% 6030-403-410580-215 COMPUTER SUPPLIES 120 3,380 3,260 96% 6030-403-410580-218 EQUIPMENT-NOT CAPITAL 4,883 28,900 24,017 83% 6030-403-410580-325 WEBSITE 5,510 6,670 1,160 17% 6030-403-410580-345 PAGER/PHONE 0 2,400 2,400 100% 6030-403-410580-346 SUMMITNET & ISPS 694 14,428 13,734 95% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,597 60,000 56,403 94% 6030-403-410580-354 MAINTENANCE CONTRACTS 0 19,000 19,000 100% 6030-403-410580-355 LICENSES 6,244 28,030 21,786 78% 6030-403-410580-356 MAINTENANCE CONTRACTS 33,376 107,900 74,524 69% 6030-403-410580-357 GRANICUS 5,280 5,300 20 0% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 1,086 66,560 65,474 98% 6030-403-410580-359 PRIVATE FIBER - CITY NETWORK 0 21,200 21,200 100% 6030-403-410580-360 MULTI-FACTOR AUTHENTICATION 0 8,000 8,000 100% 6030-403-410580-373 DUES & TRAINING 2,391 16,975 14,584 86% 6030-403-410580-510 INSURANCE 6,695 6,800 105 2% 6030-403-410583-218 TV-Video Equipment & programming 198 100,400 100,202 100% 6030-403-410585-229 COPIER,FAX, SUPPLIES 1,889 18,325 16,436 90% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 21,210 152,000 130,790 86% 6030-403-410585-532 COPIER LEASES 2,668 14,288 11,620 81% 6030-403-410585-942 Servers - capital contingency 0 59,000 59,000 100% 6030-403-510400-831 DEPRECIATION EXPENSE 0 25,000 25,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 0 2,180 2,180 100% 6030-405-410588-940 COMPUTERS - SWITCHES 0 50,000 50,000 100% 6030-410-410588-218 COMPUTERS - DPW 2,232 6,420 4,188 65% 6030-413-410588-218 COMPUTERS - POLICE DEPT 376 19,290 18,914 98% 6030-413-410588-354 POLICE - HOSTED SERVER 3 2,800 2,797 100% 6030-416-410588-218 COMPUTERS - FIRE 0 6,350 6,350 100% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 0 885 885 100% 6030-436-410588-218 COMPUTERS - PARKS 0 4,895 4,895 100% 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 2,795 2,795 100% ------------------------------------------------- TOTAL INFORMATION TECH EXPENSE 224,046 1,404,655 1,180,609 84% ================================================= THE CITY OF KALISPELL, MONTANA10.12.2021 14:59 gb8501_pg.php/Job No: 64238 Page 37 of 37 USER: RGW FY22 FINANCIAL REPORT FY22 1ST QUARTER 25.00 % Yr Complete For Fiscal Year: 2022 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 155,000 620,000 465,000 75% 6010-000-371010-000 INVESTMENT EARNINGS 3,445 900 2,545- -283% ------------------------------------------------- TOTAL CENTRAL GARAGE REVENUE 158,445 620,900 462,455 74% ================================================= CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 45,265 186,349 141,084 76% 6010-410-431330-121 OVERTIME 0 2,500 2,500 100% 6010-410-431330-153 HEALTH INSURANCE 9,258 37,831 28,573 76% 6010-410-431330-155 RETIREMENT 3,276 14,108 10,832 77% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 5,208 19,500 14,292 73% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 1,190 23,500 22,310 95% 6010-410-431330-230 OIL 2,536 25,500 22,964 90% 6010-410-431330-231 GAS 138 1,500 1,362 91% 6010-410-431330-232 VEHICLE PARTS 27,702 140,000 112,298 80% 6010-410-431330-233 TIRES 9,433 54,000 44,567 83% 6010-410-431330-238 FILTERS 2,806 9,000 6,194 69% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 1,434 2,000 566 28% 6010-410-431330-341 ELECTRICITY 851 5,900 5,049 86% 6010-410-431330-342 WATER 115 2,000 1,885 94% 6010-410-431330-344 NATURAL GAS 245 12,500 12,255 98% 6010-410-431330-354 CONTRACT SERVICES 5,865 32,000 26,135 82% 6010-410-431330-360 WASH BAY REPAIRS & MAINTENANCE 77 6,000 5,923 99% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 188 6,000 5,812 97% 6010-410-431330-373 DUES & TRAINING 150 8,500 8,350 98% 6010-410-431330-388 MEDICAL SERVICES 85 500 415 83% 6010-410-431330-510 INSURANCE 4,698 4,600 98- -2% 6010-410-431330-528 INFORMATION TECH TRANSFER 5,721 22,883 17,162 75% 6010-410-431330-921 SCAN TOOL REPLACEMENT 0 11,000 11,000 100% ------------------------------------------------- TOTAL CENTRAL GARAGE EXPENSES 126,240 627,671 501,431 80% ================================================= 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 1 0 0 0 0 0 1 0 0 0 0 0 0 0 1 1 3 1 SIWOC/Sexual Assault 3 0 0 0 5 0 3 0 8 0 1 0 4 0 3 0 4 0 31 0 Robbery 0 0 0 0 0 0 1 1 0 0 1 1 0 0 0 0 0 0 2 2 Aggravated Assault 3 0 4 2 3 3 6 2 7 3 4 2 7 4 3 1 4 2 41 19 Assault on a Peace Officer 0 0 4 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 3 Simple Assault 6 5 7 3 9 6 13 10 3 1 7 3 8 3 6 5 8 3 67 39 PFMA 12 8 10 10 8 6 13 5 8 6 12 9 16 14 15 8 10 6 104 72 Resisting Arrest 3 3 4 4 6 6 7 6 2 1 3 3 6 5 4 3 4 3 39 34 Crimes Against Property Burglary 2 0 1 0 4 1 1 0 4 1 1 1 5 1 1 0 4 1 23 5 Theft 41 23 37 16 45 21 39 18 26 13 48 15 47 10 43 12 57 15 383 143 Vehicle Theft/Unauth Use 3 1 3 1 9 6 5 2 2 0 4 2 3 0 5 1 6 1 40 14 Arson 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 Forgery/Counterfeit 1 1 5 0 3 0 3 0 1 0 1 0 2 0 1 0 4 0 21 1 Fraud 5 2 4 1 3 1 5 2 4 1 1 0 3 0 5 0 3 1 33 8 Theft of Identity 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 2 0 Embezzlement 1 2 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 3 Stolen Property offenses 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 2 1 Criminal Mischief 8 3 8 1 21 2 9 1 16 5 22 6 24 4 18 2 23 3 149 27 Crimes Against Society Weapon Law Violations 1 1 0 0 0 0 0 0 0 0 0 0 1 0 2 1 1 0 5 2 Prostitution Offenses 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Child Pornography 0 0 0 0 0 0 0 0 1 0 0 0 1 0 1 0 0 0 3 0 Drug Offenses 22 16 9 8 23 14 11 3 7 5 14 6 18 17 15 9 14 9 133 87 Family Offenses (non-violent)2 0 0 0 2 0 2 0 1 0 0 0 0 0 1 0 0 0 8 0 DUI 6 5 10 9 4 4 7 6 16 17 7 7 9 7 5 3 5 5 69 63 Possession of Alcohol 1 1 5 4 0 0 6 6 7 9 3 3 2 2 8 15 3 3 35 43 Provide Alcohol to Minor 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 Other Alcohol Offenses 0 0 0 0 2 1 3 3 1 1 0 0 1 0 0 0 2 2 9 7 Kidnapping/Custodial Int.1 1 0 0 1 1 0 0 1 1 0 0 1 1 0 0 2 0 6 4 Disorderly Conduct 7 6 4 4 4 5 7 5 5 4 9 8 6 5 9 9 7 5 58 51 Criminal Trespass 28 22 7 8 10 6 17 16 7 2 14 11 12 7 16 12 14 8 125 92 Violation of Protective Order 4 2 9 1 2 0 4 3 2 4 2 0 3 3 7 0 3 1 36 14 Obstructing a peace officer 13 12 5 4 5 5 9 9 7 5 6 6 13 11 14 15 5 4 77 71 Juvenile Offenses (except MIP)1 1 2 2 0 0 2 0 9 6 15 17 8 8 6 7 2 0 45 41 Other Offenses 42 41 29 27 33 30 35 33 38 36 29 30 38 34 13 11 21 19 278 261 Total 217 156 170 108 203 118 209 131 184 122 204 130 239 136 201 114 207 93 0 0 0 0 0 0 1834 1108 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 513 345 367 294 504 333 383 329 567 400 474 342 470 358 524 362 447 350 4249 3113 Total Calls for Service Kalispell Police Department Case and Arrest Reports - 2021 January February March April May June July August September October November December Totals 2775 2465 3013 2785 2878 3130 26701338031813094