Loading...
04-15-22 City Manager Report, Arrest Reports1 City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 4/15/2022 1. Parks and Recreation Spring maintenance continues at the Kalispell Youth Athletic Complex. O’Keefe Well Drillers has started the process of drilling a new irrigation production well at KYAC. To have enough water capacity to irrigate the 7 new multiuse fields and surrounding areas on the north side of the complex, a second production well was needed. Once the well is established, work can begin tying the new well into the existing irrigation system and the new electronics installed to control both wells simultaneously. Through a grant from the Department of Natural Resource and Conservation, the Urban Forest Committee has worked to create a media campaign to raise the awareness of the value of trees. Two billboards are currently placed in town. On April 7, Fish Wildlife and Parks along with 4th graders from Hedges School stocked Dry Bridge Pond with 500 two-year-old Rainbow Trout. The pond is open to family fishing, though adults are asked to voluntarily release their catch. Dry Bridge is located at the corner of 11th Street East and Woodland Avenue. Forestry staff were able to use an air spade to excavate a small caliper tree and move it to a new location. An air spade uses concentrated air to remove soil from roots without harming the tree. This allowed the water department to make a needed repair to the water line below and saved the tree. We have hired 15+ camp counselors so far for our Camp Woodland Summer Day Camp this summer. We are still looking to hire an additional 15-20 counselors to accommodate an anticipated full summer day camp program. We have hosted several job fairs at Flathead High School and Glacier High School, and we will attend additional job fairs at Linderman and the Flathead County Fairgrounds over the next two weeks. 2 Registration will open for our Camp Woodland Summer Day Camp on Monday, April 18. The staff have been working on programming, field trips, and themes for each week of camp along with working with our Human Resources on providing specific training for employees this summer. Registration for our Spring Soccer program for ages 3 years old through 4th grade closed on Friday, April 8. We have seen a small increase to 463 participants. The league is six weeks long and is scheduled to begin on April 20. 2. Planning Department The Planning Board held a public hearing on April 12 and heard four application requests. The application requests consisted of the following: 1. File # KA-22-01 – A request from Ryan Koistinen for annexation and initial zoning of RA-1 (Residential Apartment) for property located at 1801 and 1823 5th Avenue East. The proposal involves two properties that will be subject to a boundary line adjustment (Assessors Tracts 8D and 8KA). The applicant owns Tract 8D/1823 5th Avenue East, which is partially in the city. Flathead Electric Cooperative, Inc. owns Tract 8KA, which is also partially in the city. The boundary line adjustment would take approximately 0.256 acres of land from Tract 8KA and add it to Tract 8D. This request would annex the entirety of the expanded Tract 8D into the city with an RA-1 zoning designation, with a total of 0.43 acres to be annexed. 2. File #KZC-22-02 – A request from John Todd to change the current zoning of properties located at 128 and 130 2nd Street East and certain adjoining properties from RA-2 (Residential Apartment/Office) to B-4 (Central Business). The combined properties (other owners include the City of Kalispell and Villa Normandy, LLC) contain approximately 0.44 acres of land. 3. Files #KPP-22-03 and KCU-22-01 – A request from Housing Solutions, Inc, for a conditional use permit for a multi-family residential development and major preliminary plat approval for one additional lot within an existing subdivision. The new lot would contain approximately 1.01 acres. The development would include 31 senior housing units which are rent and income restricted, supported by tax credits administered through the Montana Board of Housing. The property is in a B-2 (General Business) zone at 1203 Highway 2 West (Gateway West Mall) with the project to be located in the northern portion of the property. 4. File #KPP-22-04 – A request from Stillwater Corporation for preliminary plat approval for Kalispell North Town Center Phase 5, a major residential subdivision with 37 lots on approximately 10.6 acres in lots, roads, and common area. The property is zoned R-3 (Residential) with a Planned Unit Development overlay. It is located on the east side of Jefferson Boulevard. 3 The Board did recommend approval of the four application requests. The recommendations will be forwarded to the Council for consideration at the May 2 meeting. The planning board also held a work session on the items listed below: 1. Files #KA-22-01 and KPUD-22-01 – A request from Kelcey and Tawnya Bingham for annexation and initial zoning with a Commercial Planned Unit Development overlay on approximately 37.6 acres of land. The development, called the Farm District, would be a mixed-use development with a focus on an indoor youth athletic and arts facility along with commercial and residential uses. The property is located at the northwest corner of Highway 93 North and Church Drive. 2. File #KPUD-22-02 – A request from JCA Management, LLC, for a Commercial Planned Unit Development (“PUD”) overlay on approximately 9.72 acres of land. The property is currently zoned B-2 with a placeholder PUD overlay, which requires a full PUD submittal prior to development. The proposal includes locating a truck and RV Center on the property. The property is located at 3178 Highway 93 South near the intersection of Highway 93 and the Bypass. 3. Files #KA-22-03, KGPA-22-01 and KZC-22-03 – A request from Spartan Holdings for a zone change, growth policy map amendment and annexation and initial zoning of property, to be known as Eagle Valley Ranch Addition on 6.8 acres of land. The developer of Eagle Valley Ranch PUD has acquired land adjacent their development (Home Outfitters) and neighboring property currently within the County that is being requested to be included in the Eagle Valley Ranch PUD. The application includes a zone change of the existing Home Outfitters building which is City R-2 to the Eagle Valley Rand PUD, and annexation and initial zoning of surrounding County property from County SAG- 10 to the Eagle Valley Ranch PUD. The request would also include a growth policy map amendment from suburban residential to urban mixed use on those properties annexing into the city, allowing for neighborhood commercial uses, similar to the commercial properties within the current Eagle Valley Ranch PUD. The goal of the change is similar to that of the original PUD which is to provide a diverse neighborhood close to existing services and commercial development on the north side of Kalispell and allows for inclusion of properties that are currently segregated from the development. The proposed development is generally situated along Highway 93 south of Ponderosa Residential Subdivision, east of Northern Pines Golf Course and north of the Montana National Guard facilities in the West ½ of Section 19, Township 29 North, Range 21 West, P.M.M., Flathead County, Montana. The Board discussed the application requests at length and, excepting some traffic analysis/road alignment changes, the applications are ready for their consideration. The public hearing for the developments will be considered by the Board at their May 10 meeting. 4 3. Building Department In the last 2 weeks, we have issued permits for 5 single-family homes and 2 townhomes. That will bring the total of new single-family/duplex and townhouse units for the year to 48, compared to 67 last year at this time. There are currently 52 commercial projects in the queue with 20 of those ready to issue, 10 under review and 14 to be reviewed. There are five incomplete submittals and three awaiting a response to comments. There was a total of 154 combined building and/or fire inspections completed in the last 3 weeks. Residential – 58 Plumbing – 10 Commercial – 16 Mechanical - 16 Electrical – 12 Fire – 42 4. Community Development The City submitted a $25 million RAISE grant request to the US Department of Transportation in partnership with the Montana Department of Transportation (MDT) on April 13. The proposed project includes: (1) widening West Reserve Road from 3- to 5- lanes; (2) reconstructing Stillwater River bridge to widen consistent with the roadway, (3) adding 6’ landscape boulevards with 8’shared use path on the north and 5’ sidewalk on the south for separated pedestrian and bicycle mobility and safety; (4) intersection improvements to Hutton Ranch Road and Whitefish Stage Road intersections; and (5) construct improvements to .5 miles of Whitefish Stage Road north of the intersection to bring it to urban standards. The map shows project boundaries. If awarded, construction is projected to require two full construction seasons, 2024 and 2025. The pedestrian crossing mast arms and signals have been installed on Main Street and will be operational when construction of the trail is complete, and the Parkline is open to the public. 5 5. Fire Department From the time period of March 30 to April 11, the Fire Department had 138 responses. Of the responses: there were 98 were medical incidents, 7 Motor vehicle accident with injuries, 6 fire alarm activations, 9 public assists, 3 haz-mat incidents, and 16 dispatched and canceled enroute. The order was placed for all new Self-Contained Breathing Apparatus, spare bottles, masks, etc. Fire crews/medics completed Pre-Hospital Trauma Life Support (PHTLS) training. This is a new certification required by our Medical Director. Components for the SCBA fill compressor and cascade fill station have been configured and sent out for bid. Several Firefighters have attended the Car Seat Safety Technician course hosted by the State of Montana. 3 Car seat safety inspections were performed this past week. 6. Police Department Attached is the most recent case report from the Police Department. The Kalispell Police Department recently undertook a Captain’s promotional process for the open Administrative Captain position. Sergeant Ben Sutton was promoted to Captain effective April 6. The Administrative Captain supervises our records division, parking division, Animal Warden, as well as court security. In addition to several other duties, the position runs the new officer testing process and manages grants. On April 11, the Kalispel Police Department conducted a testing process for Patrol Sergeant. The process consisted of inbox exercises in the areas of investigations, human resource issues, and a tactical problem. The process also consisted of a written exam, leadership assessment, and an oral interview with a Chief’s board. The extensive process helps the KPD identify the most prepared candidates to supervise officers in the field. Officer Hunter Maier graduated from the Montana Law Enforcement Academy on April 5. Officer Maier has returned to the police department and will begin the month’s long field training process prior to duty on his own. Detective Shane Lidstrom was chosen as the Kalispell Lion’s Police Officer of the Year. He was recognized for his work ethic, positive attitude, and dedication to duty with the newly created Montana Regional Violent Crimes Task Force (MRVCTF), which is a partnership between the Kalispell Police Department, the Flathead County Sheriff’s Office and the FBI. Year to date calls for service stand at 9,752. This compares with 9,473 in 2021 and 9,159 in 2020. 6 7. Public Works Grandview Well Replacement Project The City Grandview Well experienced unanticipated failure in the fall of 2021. Water Division Staff completed the project to replace Grandview Well in April 2022. Upon diagnosis and design, staff determined that during replacement a new pump and motor combination could be installed that would more closely fit the original design of the facility and increase the water production from the well. The previous pump/motor, after 10 years of use, produced 950 gpm while the new pump/motor increases the production potential to 1,300 gpm. Additionally, the new pump/motor combination was placed deeper into the aquifer to account for anticipated future demands to the flathead water basin. The additional flowrate supports the growing upper zone water demands productions by 350 gpm (additional 766,500 gallons per year based on a 6 hour per day runtime). The new motor also required upgrades to the electrical system which was designed with inhouse engineering services. The upgrades to the electrical system will help protect the new well components while simplifying circuitry in the Motor Control Center (MCC). Consumer Confidence Report (CCR) The CCR or Annual Water Quality Report has been completed for 2021. Notices of the report are advertised in the utility bills. The CCR is an annual water quality report the city is required to provide to its customers. This report summarizes information regarding sources used, any detected contaminants, compliance, and educational information. A link to the report can be found on the city website at: Annual Drinking Water Quality Report (kalispell.com) 8. Finance Quarterly Finance Report Attached are the printouts reflecting the activity for the 1st nine months of fiscal year 2022. This printout reflects payroll earned thru March 26, 2022, and accounts payable claims received by the end of March. Most funds are included in the report. However some funds are excluded due to insignificant activity (expenditures). Revenues are displayed for funds that have significant revenues that are not “taxes and/or assessments”. Debt service funds are not included. GENERAL FUND General Fund tax revenue reflects taxes collected through March 31. Historically, the 7 general fund receives about 45% of its property tax revenue in the 4th quarter. A similar distribution for this fiscal year would bring collections to $6.2M or about 101% of budget. The city is currently carrying just over $3,000 in protest taxes. Liquor licenses are billed once a year and are due by June 30. Planning fees have already exceeded the budgeted. City Court fines and fees revenue reflects July thru February (8 months). General Fund expenditures reflect 66% spent, compared to 69% for the same 9 months last fiscal period. All general fund departments, including police (32%) and fire (35%), have at least 3 months (25%) budget remaining. PARKS The parks fund receives approximately 2/3 of its revenue from tax levies (general and permissive health). A majority of charges for service revenue is received in the 2nd half of the fiscal year. Similar to a solely tax supported fund, the parks fund should have enough cash available at July 1st (and January 1st) to pay expenditures, less revenues other than taxes, through December (June). Beginning cash carryover was 48% (FY21) and 51% (FY22). Parks fund tax collections are 60% at the end of March, compared to 56% one year ago. Youth camps revenue, and many of the other user-based park fees, historically receives the majority of revenue in the last quarter of the fiscal year (spring). Parks fund expenditures reflect 52% spent, compared to 58% over the same period last fiscal year. All parks fund departments have at least 3 months (25%) budget remaining. AMBULANCE The ambulance fund is a special revenue fund that receives approximately 1/2 of its revenue from charges for services. Because ambulance fees for services are insufficient to support the cost to operate this fund, a transfer from the general fund is necessary. Ambulance fees for services ($384,684) are down over 6% from the same period last year ($410,375), and 26% from the fiscal year 20 amount of $516,309. BUILDING DEPARTMENT The building fund is supported by permits and fees. Beginning cash carryover was 171% (FY21) and 179% (FY22). Most Building department permits and fees have exceeded the budgeted annual amounts. The approximately $1.3M of permits and fees collected in the first three quarters of this fiscal year is about 124% of the annual budget, and about 40% more than at this point last fiscal year. 8 WATER The water fund is supported by charges for water service. Metered water sales thru March were $3,311,273 (86%), an increase from the same period last fiscal year of about 15%. It is normal for metered water sales to be in excess of 75% because of late summer and fall sprinkling and irrigation. The increase from fiscal year 2021 water revenue can be mostly attributed to an increase in rates. Water impact fees are 85% of the fiscal year 22 budget. Fiscal year 22 capital projects of the water department through the first three quarters were $858,918. This includes about $300,000 in purchases with the use of impact fees. Water projects include the meter replacement project ($405,264), elevated tank and well ($296,132), and 2nd Avenue West main repairs. SEWER The sewer fund is supported by charges for sewer service. Sewer service charges through March 31 were $5,283,360, 78% of the budgeted amount. Last year’s sewer service charges were $4,512,840 for the same period. The increase from fiscal year 2021 sewer revenue can be mostly attributed an increase in rates. Sanitary sewer (126%) and treatment plant impact fees (131%) have both exceeded the anticipated fiscal year 2022 amounts of $900,000 and $500,000, respectively. Fiscal year 22 capital purchases of the sewer department through the first three quarters were $353,300. This includes about $50,000 in purchases with the use of impact fees. Sewer projects include lift station improvements, replacements and reconstructions at the wastewater treatment plant, a new eq basin at the wastewater treatment plant, and equipment purchases. EXPENDITURES/EXPENSES: For most funds or departments, expenditures/expenses include the 19th (38 of 52 weeks) payroll period ending March 26. Most departments and/or funds have at least 27% remaining in the salaries and retirement lines which should be adequate. The majority of fire department and ambulance fund employees are paid 13 times annually. This 1st half report includes the 10th of 13 (38 of 52 weeks/27%) pay periods for these employees. Health insurance is paid 12 times per year and includes 8 months (66%) on this report for all funds. 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), internal services (Information Technology), administrative charges (General Fund), and many of the transfers between funds. The general fund administrative charges may vary slightly as some charges are based on a percentage of revenues collected. Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Crimes Against Persons Homicide/Justifiable Homicide 0 0 0 0 0 0 0 0 SIWOC/Sexual Assault 8 1 3 0 4 2 15 3 Robbery 0 0 0 0 0 0 0 0 Aggravated Assault 9 0 9 6 9 4 27 10 Assault on a Peace Officer 0 0 0 0 0 0 0 0 Simple Assault 13 8 6 4 6 3 25 15 PFMA 5 2 15 7 15 8 35 17 Resisting Arrest 3 2 6 4 2 2 11 8 Crimes Against Property Burglary 3 0 1 0 6 5 10 5 Theft 49 23 63 33 63 27 175 83 Vehicle Theft/Unauth Use 1 2 5 0 8 3 14 5 Arson 1 0 0 0 0 0 1 0 Forgery/Counterfeit 4 0 3 0 3 1 10 1 Fraud 7 2 2 0 2 1 11 3 Theft of Identity 1 0 0 0 1 0 2 0 Embezzlement 0 0 0 0 0 0 0 0 Stolen Property offenses 0 0 1 0 0 0 1 0 Criminal Mischief 12 4 20 3 13 2 45 9 Crimes Against Society Weapon Law Violations 0 0 2 0 1 0 3 0 Prostitution Offenses 0 0 0 0 0 0 0 0 Child Pornography 0 0 2 0 0 0 2 0 Drug Offenses 14 11 26 10 24 13 64 34 Family Offenses (non-violent)2 0 0 0 2 0 4 0 DUI 8 8 9 9 11 10 28 27 Possession of Alcohol 2 0 0 2 2 0 4 2 Provide Alcohol to Minor 0 0 0 0 0 0 0 0 Other Alcohol Offenses 0 0 0 0 0 0 0 0 Kidnapping/Custodial Int.0 0 0 0 0 0 0 0 Disorderly Conduct 2 2 4 2 4 4 10 8 Criminal Trespass 29 20 25 21 22 13 76 54 Violation of Protective Order 2 0 3 0 4 1 9 1 Obstructing a peace officer 5 3 6 3 5 5 16 11 Juvenile Offenses (except MIP)2 0 2 0 5 0 9 0 Other Offenses 19 20 25 18 33 31 77 69 Total 201 108 238 122 245 135 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 684 365 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 396 300 374 316 345 258 1115 874 Total Calls for Service Kalispell Police Department Case and Arrest Reports - 2022 January February March April May June July August September October November December Totals 2859 2664 3035 8558 THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 1 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 3,612,470 6,145,000 2,532,530 41% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 0 17,750 17,750 100% 1000-000-311200-000 PERSONAL PROPERTY TAXES 151,990 170,000 18,010 11% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 8,757 10,000 1,243 12% 1000-000-322101-000 LIQUOR LICENSES 1,763 33,000 31,238 95% 1000-000-322300-000 BUSINESS LICENSES 487 1,500 1,013 68% 1000-000-323012-000 PLANNING FEES 135,132 95,000 40,132- -42% 1000-000-323109-000 SITE REVIEW 16,748 30,000 13,252 44% 1000-000-323200-000 PARADE PERMITS 350 500 150 30% 1000-000-331023-000 MRVCTF 1,725 0 1,725- 0% 1000-000-335030-000 M.V. TAX - AD VALOREM 1,128 1,350 222 16% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 54,400 60,000 5,600 9% 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,650 1,400 250- -18% 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 2,256,045 3,020,000 763,955 25% 1000-000-341020-000 ADMINISTRATIVE CHARGES 516,401 690,000 173,599 25% 1000-000-341021-000 GRANT ADMIN FEES 31,603 25,000 6,603- -26% 1000-000-341025-000 CITY COLLECTIONS 9,054 5,000 4,054- -81% 1000-000-342010-000 POLICE SERVICES 26,186 29,000 2,814 10% 1000-000-342014-000 RESOURCE OFFICERS 230,045 224,435 5,610- -3% 1000-000-342016-000 KPD REGIONAL TRAINING 2,849 14,500 11,651 80% 1000-000-343018-000 PARKING PERMITS 69,472 90,000 20,528 23% 1000-000-343062-000 AIRPORT FUEL TAXES 3,115 4,000 885 22% 1000-000-343063-000 AIRPORT GROUND LEASE (HILTON) 13,259 15,301 2,042 13% 1000-000-351000-000 CITY COURT FINES & FEES 236,840 450,000 213,160 47% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 13,515 30,000 16,485 55% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 32,165 45,000 12,835 29% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 571 20,000 19,429 97% 1000-000-362020-000 MMIA LIABILITY RETRO 40,436 30,000 10,436- -35% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 856 10,000 9,144 91% 1000-000-371010-000 INVESTMENT EARNINGS 38,436 30,000 8,436- -28% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 550,000 1,100,000 550,000 50% ------------------------------------------------- TOTAL GENERAL FUND REVENUE 8,057,448 12,397,736 4,340,288 35% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 2 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 3,030 3,030 0 0% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 14,100 13,750 350- -3% 1000-400-410530-354 GASB 75 ACTUARIAL VALUATION 7,500 10,000 2,500 25% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 2,981 4,000 1,019 25% 1000-400-410560-312 POSTAGE 10,753 16,000 5,247 33% 1000-400-410560-320 PRINTING & ENVELOPES 1,271 5,500 4,229 77% 1000-400-410560-354 CONTRACT SERVICES - DOC. SHRED / 10 76 1,500 1,424 95% 1000-400-410600-354 ELECTIONS 0 20,000 20,000 100% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 2,805 4,500 1,695 38% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 269 350 81 23% 1000-400-430300-355 AIRPORT REIMBURSEMENT 18,065 20,000 1,935 10% 1000-400-460000-820 TFR TO WESTSIDE TIF 675,000 900,000 225,000 25% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 15,000 15,000 0 0% 1000-400-460452-366 HOCKADAY MAINTENANCE 6,600 6,600 0 0% 1000-400-510300-000 CONTINGENCY 0 210,000 210,000 100% 1000-400-510310-354 ICMA PLAN FEES 250 500 250 50% 1000-400-510330-513 LIABILITY INSURANCE 287,407 287,406 1- 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 9,631 50,000 40,369 81% 1000-400-510330-517 PROPERTY INSURANCE 60,043 60,043 0 0% ------------------------------------------------- SUBTOTAL GEN.GOV'T. 1,114,780 1,628,179 513,399 32% CITY MANAGER 1000-401-410210-110 SALARIES-CITY MANAGER'S OFFICE 118,256 171,133 52,877 31% 1000-401-410210-153 HEALTH INSURANCE 16,382 25,759 9,377 36% 1000-401-410210-155 RETIREMENT 12,688 18,227 5,539 30% 1000-401-410210-210 SUPPLIES 61 1,000 939 94% 1000-401-410210-312 NEWSLETTER/BOOKS 0 400 400 100% 1000-401-410210-345 TELEPHONE & COMMUNICATION 720 1,200 480 40% 1000-401-410210-373 DUES & TRAINING 2,616 12,000 9,384 78% 1000-401-410210-379 MEETINGS 877 6,500 5,623 87% INFORMATION TECHNOLOGY ------------------------------------------------- SUBTOTAL CITY MANAGER 151,600 236,219 84,619 36% HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 110,242 173,487 63,245 36% 1000-401-410830-153 HEALTH INSURANCE 15,236 24,323 9,087 37% 1000-401-410830-155 RETIREMENT 8,950 14,032 5,082 36% 1000-401-410830-210 OFFICE SUPPLIES 588 900 312 35% 1000-401-410830-338 RECRUITMENT/RELOCATION 21,602 20,000 1,602- -8% 1000-401-410830-354 CONTRACT SERVICES 1,318 2,000 682 34% 1000-401-410830-373 DUES & TRAINING 12,246 17,000 4,754 28% ------------------------------------------------- SUBTOTAL HUMAN RESOURCES 170,181 251,742 81,561 32% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 3 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 47,113 63,179 16,066 25% 1000-402-410100-153 HEALTH INSURANCE 30,596 50,123 19,527 39% 1000-402-410100-155 RETIREMENT 1,972 2,617 645 25% 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 1,271 5,500 4,229 77% 1000-402-410100-373 DUES & TRAINING 9,372 11,500 2,128 19% 1000-402-410100-379 MEETINGS 5,205 22,255 17,050 77% ------------------------------------------------- SUBTOTAL MAYOR/COUNCIL 95,726 168,774 73,048 43% CITY CLERK 1000-402-410150-110 SALARIES-CITY CLERK 82,023 114,510 32,487 28% 1000-402-410150-121 OVERTIME 0 250 250 100% 1000-402-410150-153 HEALTH INSURANCE 11,320 21,768 10,448 48% 1000-402-410150-155 RETIREMENT 6,729 9,323 2,594 28% 1000-402-410150-210 OFFICE SUPPLIES 343 800 457 57% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 110 600 490 82% 1000-402-410150-345 TELEPHONE & COMMUNICATION 360 480 120 25% 1000-402-410150-352 CODIFICATION 1,925 4,100 2,175 53% 1000-402-410150-354 CONTRACT SERVICES 117 650 533 82% 1000-402-410150-373 DUES & TRAINING 2,441 6,200 3,759 61% ------------------------------------------------- SUBTOTAL CITY CLERK 105,368 158,681 53,313 34% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES-FINANCE OFFICE 180,897 247,730 66,833 27% 1000-403-410550-121 OVERTIME 0 500 500 100% 1000-403-410550-153 HEALTH INSURANCE 27,157 40,712 13,555 33% 1000-403-410550-155 RETIREMENT 14,941 20,116 5,175 26% 1000-403-410550-210 SUPPLIES 295 800 505 63% 1000-403-410550-322 BOOKS 278 500 222 44% 1000-403-410550-353 CONTRACT SERVICES 0 350 350 100% 1000-403-410550-354 CONTRACT-GRIZZLY SECURITY 883 900 17 2% 1000-403-410550-355 BANK CHARGES & FEES 2,306 3,500 1,194 34% 1000-403-410550-373 DUES & TRAINING 899 8,500 7,601 89% ------------------------------------------------- SUBTOTAL FINANCE 227,656 323,608 95,952 30% CITY ATTORNEY 1000-404-411110-110 SALARIES-CITY ATTORNEY'S 383,669 551,082 167,413 30% 1000-404-411110-112 SALARIES - RETIREMENT 0 130,000 130,000 100% 1000-404-411110-153 HEALTH INSURANCE 55,867 85,995 30,128 35% 1000-404-411110-155 RETIREMENT 31,204 44,825 13,621 30% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 4,502 5,700 1,198 21% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 14,974 25,000 10,026 40% 1000-404-411110-345 TELEPHONE & COMMUNICATION 676 1,500 824 55% 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 852 10,000 9,148 91% 1000-404-411110-373 DUES & TRAINING 4,411 8,000 3,589 45% ------------------------------------------------- SUBTOTAL CITY ATTORNEY 496,155 862,102 365,947 42% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 4 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MUNICIPAL COURT 1000-406-410360-110 SALARIES-COURT 181,472 264,684 83,212 31% 1000-406-410360-121 OVERTIME 0 3,500 3,500 100% 1000-406-410360-153 HEALTH INSURANCE 28,884 47,298 18,415 39% 1000-406-410360-155 RETIREMENT 14,829 21,480 6,651 31% 1000-406-410360-210 SUPPLIES 1,006 4,500 3,494 78% 1000-406-410360-320 PRINTING/BOOKS 1,559 1,500 59- -4% 1000-406-410360-345 TELEPHONE & COMMUNICATION 380 1,000 620 62% 1000-406-410360-353 SECURITY & TECHNOLOGY 15,297 40,000 24,703 62% 1000-406-410360-354 CONTRACT SERVICES 1,965 6,250 4,285 69% 1000-406-410360-373 DUES & TRAINING 2,675 10,000 7,325 73% 1000-406-410360-394 JURY & WITNESS FEES 1,575 7,500 5,925 79% ------------------------------------------------- SUBTOTAL COURT 249,642 407,712 158,070 39% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 5 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES-PUBLIC WORKS 13,456 19,158 5,702 30% 1000-410-430100-153 HEALTH INSURANCE 2,089 3,302 1,213 37% 1000-410-430100-155 RETIREMENT 1,140 1,500 360 24% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 11,048 14,500 3,452 24% 1000-410-430100-231 GAS 2,340 3,000 660 22% 1000-410-430100-345 TELEPHONE & COMMUNICATION 703 850 147 17% 1000-410-430100-354 CONTRACT SERVICES 3,222 4,500 1,278 28% 1000-410-430100-373 DUES & TRAINING 1,809 4,500 2,691 60% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 3,492 4,656 1,164 25% 1000-410-430100-940 MACINERY & EQUIPMENT 9,473 9,500 27 0% ------------------------------------------------- SUBTOTAL PUBLIC WORKS ADMIN 48,773 65,466 16,694 26% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 6 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CITY HALL MAINT. 1000-412-411230-110 SALARIES-CITY HALL 54,313 72,664 18,351 25% 1000-412-411230-153 HEALTH INSURANCE 10,548 15,100 4,552 30% 1000-412-411230-155 RETIREMENT 4,418 5,849 1,431 24% 1000-412-411230-220 SECURITY IMPROVEMENTS 793 6,793 6,000 88% 1000-412-411230-224 JANITORIAL SUPPLIES 5,064 6,800 1,736 26% 1000-412-411230-241 TOOLS & SUPPLIES 475 1,500 1,025 68% 1000-412-411230-341 ELECTRICITY 32,982 49,394 16,412 33% 1000-412-411230-344 NATURAL GAS 29,781 34,000 4,219 12% 1000-412-411230-345 TELEPHONE & COMMUNICATION 335 500 165 33% 1000-412-411230-354 CONTRACT SERVICES 6,667 15,000 8,333 56% 1000-412-411230-355 HVAC MAINTENANCE CONTRACT 18,076 17,730 346- -2% 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 6,160 7,000 840 12% 1000-412-411230-362 EQUIPMENT MAINTENANCE 2,116 10,000 7,884 79% 1000-412-411230-366 BUILDING MAINTENANCE 15,326 17,288 1,962 11% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,373 3,780 407 11% 1000-412-411230-920 BUILDING IMPROVEMENTS 0 30,058 30,058 100% ------------------------------------------------- SUBTOTAL CITY HALL 190,429 293,456 103,027 35% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 7 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES-PLANNING & ZONING 178,107 246,016 67,909 28% 1000-420-411020-153 HEALTH INSURANCE 24,474 46,047 21,573 47% 1000-420-411020-155 RETIREMENT 14,582 20,021 5,439 27% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 384 4,000 3,616 90% 1000-420-411020-231 GAS 153 450 297 66% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 1,098 2,500 1,402 56% 1000-420-411020-345 TELEPHONE 386 1,000 614 61% 1000-420-411020-354 CONTRACT SERVICES 5,582 6,000 418 7% 1000-420-411020-373 DUES & TRAINING 2,968 8,000 5,032 63% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 104 139 35 25% ------------------------------------------------- SUBTOTAL PLANNING DEPT. 227,837 334,173 106,336 32% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 58,119 81,675 23,556 29% 1000-480-470210-153 HEALTH INSURANCE 10,916 16,790 5,874 35% 1000-480-470210-155 RETIREMENT 4,774 6,610 1,836 28% 1000-480-470210-210 OFFICE SUPPLIES 741 1,600 859 54% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 0 500 500 100% 1000-480-470210-312 POSTAGE & PRINTING 204 300 96 32% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 0 500 500 100% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 248 450 202 45% 1000-480-470210-354 CONTRACT SERVICES 0 250 250 100% 1000-480-470210-373 DUES & TRAINING 3,323 5,000 1,677 34% 1000-480-470210-379 MEETINGS 65 750 685 91% ------------------------------------------------- SUBTOTAL COMMUNITY DEVELOPMENT 78,390 114,425 36,035 31% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 8 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES-POLICE 1,944,193 2,669,727 725,535 27% 1000-413-420140-112 SALARIES-SEVERANCE 43,792 50,000 6,208 12% 1000-413-420140-114 SALARY -comptime buyout 5,422 4,000 1,422- -36% 1000-413-420140-121 OVERTIME (REG & AET OT) 45,894 80,000 34,106 43% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 19,574 35,000 15,426 44% 1000-413-420140-153 HEALTH INSURANCE 328,844 497,110 168,266 34% 1000-413-420140-155 RETIREMENT 243,275 349,720 106,445 30% 1000-413-420140-210 OFFICE SUPPLIES 2,991 3,500 509 15% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 2,706 5,000 2,294 46% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 56,916 70,000 13,084 19% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 2,320 4,000 1,680 42% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 3,324 13,500 10,176 75% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 819 2,700 1,881 70% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 2,768 11,900 9,132 77% 1000-413-420140-227 AMMO & RELATED SUPPLIES 65,003 65,000 3- -0% 1000-413-420140-228 PATROL CAR SUPPLIES 3,742 8,000 4,258 53% 1000-413-420140-229 OTHER SUPPLIES 3,839 5,000 1,161 23% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 736 1,000 264 26% 1000-413-420140-231 GAS 50,317 75,000 24,683 33% 1000-413-420140-234 CRISIS NEGOTIATIONS 519 500 19- -4% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 243 1,500 1,257 84% 1000-413-420140-320 PRINTING 2,164 4,000 1,837 46% 1000-413-420140-345 TELEPHONE & COMMUNICATION 17,835 22,000 4,165 19% 1000-413-420140-354 CONTRACT SERVICES 14,515 30,000 15,485 52% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 5,343 6,500 1,157 18% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 1,245 2,600 1,355 52% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 1,258 2,000 742 37% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 47,120 57,000 9,880 17% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 2,908 5,000 2,092 42% 1000-413-420140-373 DUES & TRAINING 44,781 55,000 10,219 19% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 2,677 14,500 11,823 82% 1000-413-420140-380 TRAINING MATERIALS 4,000 5,000 1,000 20% 1000-413-420140-388 MEDICAL SERVICES 1,584 3,000 1,416 47% 1000-413-420140-392 BOARDING/TREATING PRISONERS 2,005 2,500 495 20% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 71,144 94,858 23,714 25% 1000-413-420140-530 RENT 5,900 7,200 1,300 18% ------------------------------------------------- SUBTOTAL O & M 3,051,716 4,263,315 1,211,599 28% TRANSFERS 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 48,000 64,000 16,000 25% 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 4,500 6,000 1,500 25% ------------------------------------------------- TOTAL TRANSFERS 52,500 170,000 117,500 69% CAPITAL OUTLAY 1000-413-420140-944 VEHICLES 28,811 159,000 130,189 82% ------------------------------------------------- TOTAL CAPITAL OUTLAY 28,811 159,000 130,189 82% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 9 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING DETECTIVES 1000-413-420141-110 SALARIES-DETECTIVES 279,457 413,768 134,311 32% 1000-413-420141-121 DETECTIVE-OVERTIME 6,361 15,000 8,639 58% 1000-413-420141-123 OVERTIME (SAFE NEIGHBORHOOD TASK FO 3,001 8,000 4,999 62% 1000-413-420141-153 HEALTH INSURANCE 51,228 87,900 36,672 42% 1000-413-420141-155 DETECTIVE-RETIREMENT 37,542 55,446 17,904 32% ------------------------------------------------- TOTAL DETECTIVES 377,589 580,114 202,525 35% RECORDS 1000-413-420142-110 SALARIES-RECORDS DIVISION 111,591 161,768 50,177 31% 1000-413-420142-121 OVERTIME 3,924 6,000 2,076 35% 1000-413-420142-153 HEALTH INSURANCE 22,361 38,000 15,639 41% 1000-413-420142-155 RETIREMENT 9,464 13,094 3,630 28% ------------------------------------------------- TOTAL RECORDS 147,340 218,862 71,522 33% RESOURCE OFFICERS 1000-413-420144-110 SALARIES-SRO 209,427 291,805 82,378 28% 1000-413-420144-153 HEALTH INSURANCE 38,326 61,304 22,978 37% 1000-413-420144-155 SRO RETIREMENT 27,589 39,188 11,599 30% ------------------------------------------------- TOTAL RESOURCE OFFICERS 275,342 392,297 116,955 30% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL-SALARIES 35,333 52,723 17,390 33% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 5,953 9,500 3,547 37% 1000-413-420145-155 RETIREMENT 2,907 4,109 1,202 29% ------------------------------------------------- SUBTOTAL ANIMAL CONTROL 44,193 66,832 22,639 34% PARKING 1000-413-420147-110 PARKINGS -SALARIES 66,670 96,050 29,380 31% 1000-413-420147-153 HEALTH INSURANCE 21,832 32,921 11,089 34% 1000-413-420147-155 RETIREMENT 5,577 7,695 2,118 28% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 1,354 4,000 2,646 66% 1000-413-420147-354 CONTRACTED SERVICES 1,812 2,000 188 9% 1000-413-420147-362 LOT MAINT 763 10,000 9,237 92% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 14,775 17,500 2,725 16% 1000-413-420147-550 LOT LEASE PAYMENTS 770 1,500 730 49% ------------------------------------------------- SUBTOTAL PARKING 113,553 171,666 58,113 34% ------------------------------------------------- SUBTOTAL POLICE DEPT. 4,091,044 6,022,086 1,931,042 32% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 10 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES-FIRE SUPPRESSION 1,462,993 2,195,634 732,641 33% 1000-416-420400-112 SALARY-SEVERANCE 8,989 0 8,989- 0% 1000-416-420400-113 KELLY DAYS 360 0 360- 0% 1000-416-420400-114 COMPTIME BUYOUT 2,605 5,500 2,895 53% 1000-416-420400-115 OUT OF RANK PAY 10,591 12,500 1,909 15% 1000-416-420400-121 OVERTIME 129,303 40,000 89,303- -223% 1000-416-420400-153 HEALTH INSURANCE 300,938 440,413 139,475 32% 1000-416-420400-155 RETIREMENT 193,792 290,559 96,767 33% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 3,337 4,710 1,373 29% 1000-416-420400-218 Equipment (Non Capital) 6,505 21,500 14,995 70% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 22,378 15,000 7,378- -49% 1000-416-420400-224 JANITORIAL SUPPLIES 3,170 5,150 1,980 38% 1000-416-420400-231 GAS 10,886 17,325 6,439 37% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 16,838 15,750 1,088- -7% 1000-416-420400-320 PRINTING 190 200 10 5% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 563 1,250 687 55% 1000-416-420400-345 TELEPHONE & COMMUNICATION 2,372 5,000 2,628 53% 1000-416-420400-354 CONTRACT SERVICES 19,775 17,460 2,315- -13% 1000-416-420400-362 EQUIPMENT MAINTENANCE 3,710 5,500 1,790 33% 1000-416-420400-366 BUILDING MAINTENANCE-STATION 62 4,078 7,500 3,422 46% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 1,432 5,000 3,568 71% 1000-416-420400-373 DUES & TRAINING 11,912 10,000 1,912- -19% 1000-416-420400-388 FIREFIGHTER PHYSICALS 2,562 30,800 28,238 92% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 21,795 29,061 7,266 25% ------------------------------------------------- TOTAL O & M 2,241,075 3,175,812 934,737 29% DEBT SERVICE 1000-416-420400-610 DEBT RETIREMENT-FIRE TRUCK 45,636 45,636 0- 0% 1000-416-420400-620 INTEREST EXPENSE-FIRE TRUCK 5,531 5,720 189 3% ------------------------------------------------- TOTAL DEBT SERVICE 51,167 51,356 189 0% TRANSFERS 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 187,500 250,000 62,500 25% 1000-416-420400-821 TFR - 2956 AFG ($5,300) 0 5,300 5,300 100% ------------------------------------------------- TOTAL TRANSFERS 187,500 255,300 67,800 27% CAPITAL OUTLAY 1000-416-420400-940 CAPITAL EQUIPMENT-VEHICLE/SCBA/SERV 0 347,500 347,500 100% ------------------------------------------------- TOTAL CAPITAL OUTLAY 0 347,500 347,500 100% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 11 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PREVENTION 1000-416-420440-110 SALARIES-FIRE PREVENTION 17,115 26,242 9,127 35% 1000-416-420440-121 OVERTIME 1,128 0 1,128- 0% 1000-416-420440-153 HEALTH INSURANCE 3,742 6,101 2,359 39% 1000-416-420440-155 RETIREMENT 1,481 2,027 546 27% ------------------------------------------------- TOTAL PREVENTION 23,466 34,370 10,904 32% ------------------------------------------------- TOTAL FIRE DEPARTMENT 2,503,209 3,864,338 1,361,129 35% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 12 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GRAND TOTAL GENERAL FUND 9,750,789 14,730,961 4,980,172 34% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 13 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 ENTITLEMENT SHARE PMT/HB124 322,500 430,000 107,500 25% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 99,775 210,000 110,225 52% 6030-000-371010-000 INVESTMENT EARNINGS 1,420 1,100 320- -29% 6030-000-393000-000 INTERNAL SERVICES-DATA 565,436 753,914 188,478 25% ------------------------------------------------- TOTAL REVENUE 989,131 1,395,014 405,884 29% ================================================= EXPENSES 6030-401-410580-110 SALARIES 295,032 414,408 119,376 29% 6030-401-410580-121 OVERTIME 36 1,000 964 96% 6030-401-410580-153 HEALTH INSURANCE 57,159 90,081 32,922 37% 6030-401-410580-155 RETIREMENT 24,240 33,685 9,445 28% 6030-401-410588-218 COMPUTERS - ADMINISTRATIVE DEPTS 6,077 5,310 767- -14% 6030-403-410580-215 COMPUTER SUPPLIES 767 3,380 2,613 77% 6030-403-410580-218 EQUIPMENT-NOT CAPITAL 25,308 28,900 3,592 12% 6030-403-410580-325 WEBSITE 5,775 6,670 895 13% 6030-403-410580-345 PAGER/PHONE 54 2,400 2,346 98% 6030-403-410580-346 SUMMITNET & ISPS 4,477 14,428 9,951 69% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,597 60,000 56,403 94% 6030-403-410580-354 MAINTENANCE CONTRACTS 1,651 19,000 17,349 91% 6030-403-410580-355 LICENSES 15,420 28,030 12,610 45% 6030-403-410580-356 MAINTENANCE CONTRACTS 81,758 107,900 26,142 24% 6030-403-410580-357 GRANICUS 5,280 5,300 20 0% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 62,606 66,560 3,954 6% 6030-403-410580-359 PRIVATE FIBER - CITY NETWORK 4,035 21,200 17,165 81% 6030-403-410580-360 MULTI-FACTOR AUTHENTICATION 6,990 8,000 1,010 13% 6030-403-410580-373 DUES & TRAINING 11,742 16,975 5,233 31% 6030-403-410580-510 INSURANCE 6,695 6,800 105 2% 6030-403-410583-218 TV-Video Equipment & programming 284 100,400 100,116 100% 6030-403-410585-229 COPIER,FAX, SUPPLIES 7,348 18,325 10,977 60% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 62,987 152,000 89,013 59% 6030-403-410585-532 COPIER LEASES 9,166 14,288 5,122 36% 6030-403-410585-942 Servers - capital contingency 135 59,000 58,865 100% 6030-403-510400-831 DEPRECIATION EXPENSE 0 25,000 25,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 2,293 2,180 113- -5% 6030-405-410588-940 COMPUTERS - SWITCHES 0 50,000 50,000 100% 6030-410-410588-218 COMPUTERS - DPW 4,606 6,420 1,814 28% 6030-413-410588-218 COMPUTERS - POLICE DEPT 17,370 19,290 1,920 10% 6030-413-410588-354 POLICE - HOSTED SERVER 1,493 2,800 1,307 47% 6030-416-410588-218 COMPUTERS - FIRE 6,379 6,350 29- -0% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 793 885 93 10% 6030-436-410588-218 COMPUTERS - PARKS 5,622 4,895 727- -15% 6030-480-410588-218 COMMUNITY DEVELOPMENT 429 2,795 2,366 85% ------------------------------------------------- TOTAL EXPENSE 737,602 1,404,655 667,053 47% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 14 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC SAFETY - EMERGENCY SERV AMBULANCE FUND REVENUE 2230-000-342050-000 FEES FOR SERVICES 384,684 700,000 315,316 45% 2230-000-342070-000 COUNTY EMS LEVY 77,399 140,000 62,601 45% 2230-000-365000-000 DONATIONS/SALE OF EQUIP/MISC 1,987 0 1,987- 0% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 187,500 250,000 62,500 25% ------------------------------------------------- TOTAL REVENUE 651,570 1,090,000 438,430 40% ================================================= EXPENSE 2230-440-420730-110 SALARIES 462,213 675,510 213,297 32% 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 26,757 30,000 3,243 11% 2230-440-420730-153 HEALTH INSURANCE 80,372 118,649 38,277 32% 2230-440-420730-155 RETIREMENT 59,834 87,776 27,942 32% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 1,531 3,400 1,869 55% 2230-440-420730-218 NON-CAPITAL EQUIPMENT 643 4,200 3,557 85% 2230-440-420730-231 GAS & OIL 5,550 7,560 2,010 27% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 2,309 4,000 1,691 42% 2230-440-420730-312 POSTAGE/PRINTING 27 1,000 973 97% 2230-440-420730-345 TELEPHONE & COMMUNICATION 764 1,700 936 55% 2230-440-420730-354 CONTRACT SERVICES 15,823 20,040 4,217 21% 2230-440-420730-359 COLLECTION / CC FEES / AUDIT FEES 3,675 1,650 2,025- -123% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 2,098 5,000 2,902 58% 2230-440-420730-373 DUES & TRAINING 15,985 12,000 3,985- -33% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 32 2,500 2,468 99% 2230-440-420730-391 MEDICAL TREATMENT-SUPPLIES 39,358 54,315 14,957 28% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 13,041 13,041 0 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 10,010 13,347 3,337 25% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 37,161 49,548 12,387 25% 2230-440-420730-528 INFORMATION TECHNOLOGY TRANSFER 32,811 43,748 10,937 25% 2230-440-420730-610 PRINCIPAL - AMBULANCE 36,437 36,437 0- 0% 2230-440-420730-620 INTEREST - AMBULANCE 3,376 3,126 250- -8% ------------------------------------------------- TOTAL EXPENDITURES 849,806 1,195,347 345,541 29% ================================================= 2230 AMBULANCE CASH 2230-000-010100-000 CASH, AMBULANCE 25,079- 0 25,079 0% ------------------------------------------------- AMBULANCE CASH BALANCE 25,079- 0 25,079 0% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 15 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2995 SAFER GRANT 2995-000-331991-000 HOMELAND SECURITY SAFER GRANT 0 159,392 159,392 100% 2995-000-383001-000 TRANSFER FROM GENERAL FUND 0 100,000 100,000 100% ------------------------------------------------- TOTAL SAFER REVENUE 0 259,392 259,392 100% ================================================= 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 EXP 0 212,522 212,522 100% ================================================= 2956 FIRE 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% ------------------------------------------------- 2956 TOTAL FIRE GRANTS 1,701 63,300 61,599 97% ================================================= 2957 HAZMAT GRANT 2957-416-420400-221 DoMA EQUIP (REIMB) 14,304 14,809 505 3% 2957-416-420410-125 PASS THRU HAZMAT OT 117 5,000 4,883 98% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 397 10,000 9,603 96% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 3,000 3,000 100% ------------------------------------------------- TOTAL HAZMA GRANT EXPENDITURES 14,818 32,809 17,991 55% ================================================= 2958 HAZMAT TEAM SUSTAINMENT G 2958-416-420455-240 SUPPLIES AND EQUIPMENT 2,619 40,000 37,381 93% ------------------------------------------------- TOTAL HAZMAT TEAM SUSTAINMENT 2,619 40,000 37,381 93% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 16 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC SAFETY - LAW ENFORCEMEN 2915 STONGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD 364 10,000 9,636 96% 2915-413-420140-940 EQUIPMENT - NIGHT VISION & IR DESIG 0 30,000 30,000 100% ------------------------------------------------- TOTAL STONEGARDEN GRANT 364 40,000 39,636 99% ================================================= 2916 DRUG ENFORCEMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 43,434 69,682 26,248 38% 2916-413-420140-121 OVERTIME 8,547 13,000 4,453 34% 2916-413-420140-153 HEALTH INSURANCE 7,358 13,708 6,350 46% 2916-413-420140-155 RETIREMENT 5,857 9,352 3,495 37% ------------------------------------------------- TOTAL DRUG ENFORCEMENT GRANT 65,196 105,742 40,546 38% ================================================= 2918 COPS HIRING RECOVERY PROG 2918-413-420140-110 SALARIES & PAYROLL COSTS 0 124,828 124,828 100% 2918-413-420140-153 HEALTH INSURANCE 0 37,596 37,596 100% 2918-413-420140-155 RETIREMENT 0 16,775 16,775 100% ------------------------------------------------- TOTAL COPS HIRING RECOVERY GRA 0 179,199 179,199 100% ================================================= 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 835 3,000 2,165 72% 2919-413-420140-121 OVERTIME - DISPATCH 259 0 259- 0% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 4,477 35,000 30,523 87% 2919-413-420140-127 SCHOOL DIST. OT 12,596 17,000 4,404 26% 2919-413-420140-218 JAG GRT/BODY ARMOR & BODY WORN CAME 1,612 13,000 11,388 88% 2919-413-420140-219 EQUIPMENT FROM CORONAVIRUS GRANT 5,000 5,000 0 0% 2919-413-420140-220 EQUIPMENT-FUNDED BY DONATIONS 9,055 4,000 5,055- -126% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 2,230 6,000 3,770 63% ------------------------------------------------- TOTAL LAW ENFORCEMENT GRANTS 36,065 83,000 46,935 57% ================================================= 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% ================================================= 2399 IMPACT FEE FUND 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 11,250 15,000 3,750 25% 2399-413-420140-610 PRINCIPAL - IMPOUND/STORAGE 0 12,000 12,000 100% 2399-413-420140-620 INTEREST - IMPOUND/STORAGE 0 3,000 3,000 100% 2399-413-420140-920 IMPOUND/STORAGE FACILITY 2,560 77,560 75,000 97% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 1,500,000 1,500,000 100% ------------------------------------------------- TOTAL PUBLIC SAFETY IMPACT FEE 13,810 1,607,560 1,593,750 99% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 17 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC WORKS 2500 SPECIAL STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 627,566 886,253 258,687 29% 2500-421-430240-121 OVERTIME 5,718 28,000 22,282 80% 2500-421-430240-153 HEALTH INSURANCE 113,247 184,961 71,714 39% 2500-421-430240-155 RETIREMENT 50,115 69,499 19,384 28% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 16,393 25,545 9,152 36% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 2,711 7,000 4,289 61% 2500-421-430240-220 OTHER SUPPLIES 3,919 4,500 581 13% 2500-421-430240-231 GAS & OIL 28,779 42,000 13,222 31% 2500-421-430240-341 ELECTRICITY 2,095 3,500 1,405 40% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 2,074 3,330 1,256 38% 2500-421-430240-354 CONTRACT SERVICES 15,867 22,500 6,633 29% 2500-421-430240-356 TRANSPORTATION PLAN 328 15,000 14,672 98% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 35,277 41,000 5,723 14% 2500-421-430240-366 BUILDING MAINTENANCE 992 5,000 4,008 80% 2500-421-430240-373 DUES & TRAINING 828 13,000 12,172 94% 2500-421-430240-388 MEDICAL SERVICES 470 1,000 530 53% 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 157,367 209,822 52,455 25% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 83,264 111,018 27,754 25% 2500-421-430240-528 INFORMATION TECHNOLOGY TRANSFER 35,256 47,008 11,752 25% 2500-421-430240-840 MACI GRANT MATCH - WTR/DE-ICER TRK 0 15,000 15,000 100% 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 13,171 26,573 13,402 50% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 6,461 12,758 6,297 49% 2500-421-430244-354 PAVEMENT REPAIRS-PAVEMENT MNT FUNDS 106,320 509,666 403,346 79% 2500-421-430244-820 TRANSFER TO BaRSAA 25,842 23,750 2,092- -9% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 180,603 632,700 452,097 71% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 11,728 27,380 15,652 57% ------------------------------------------------- TOTAL STREET MAINT 1,561,548 3,047,919 1,486,371 49% ------------------------------------------------- TSS 2500-421-430264-110 TSS - SALARIES 82,691 113,067 30,376 27% 2500-421-430264-121 OVERTIME 0 7,500 7,500 100% 2500-421-430264-153 HEALTH INSURANCE 24,953 37,596 12,643 34% 2500-421-430264-155 RETIREMENT 6,531 8,810 2,279 26% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 4,544 5,960 1,416 24% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 4,013 7,000 2,987 43% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 3,584 4,000 416 10% 2500-421-430264-242 STREET SIGNS 16,475 30,000 13,525 45% 2500-421-430264-243 TRAFFIC SIGNALS 89 50,459 50,370 100% 2500-421-430264-245 BARRICADE MATERIALS 920 6,000 5,080 85% 2500-421-430264-341 ELECTRICITY 1,297 3,000 1,703 57% 2500-421-430264-345 COMMUNICATIONS 775 1,330 555 42% 2500-421-430264-354 CONTRACT SERVICES 1,845 10,000 8,155 82% 2500-421-430264-362 EQUIPMENT MAINTENANCE 551 3,000 2,449 82% 2500-421-430264-366 BUILDING MAINTENANCE 519 5,000 4,481 90% 2500-421-430264-373 DUES & TRAINING 2,509 7,500 4,991 67% 2500-421-430264-428 PAINT MATERIALS 52 5,000 4,948 99% 2500-421-430264-510 LIABILITY INS.-TSS 3,280 3,280 0- 0% 2500-421-430264-512 UNINSURED LOSS-DEDUCTIBLE 0 1,000 1,000 100% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 18 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500-421-430264-521 CENTRAL GARAGE TRANSFER 5,421 7,227 1,806 25% 2500-421-430264-940 MACHINERY & EQUIPMENT 4,549 5,000 452 9% ------------------------------------------------- TOTAL TSS 164,598 321,729 157,131 49% ------------------------------------------------- TOTAL SPECIAL STREET 1,726,146 3,369,648 1,643,502 49% ================================================= 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 54,060 99,000 44,940 45% 2420-421-430234-957 ALLEY PAVING 23,243 54,882 31,639 58% 2420-421-430240-231 GAS & OIL 28,142 42,000 13,858 33% 2420-421-430240-344 NATURAL GAS 3,033 6,800 3,767 55% 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 6,137 5,000 1,137- -23% 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 93,499 58,000 35,499- -61% 2420-421-430240-472 ASPHALT 30,022 40,000 9,978 25% 2420-421-430240-473 CRACK SEALING 4,998 18,000 13,002 72% 2420-421-430240-474 PAINT STRIPING MATERIALS 10,007 30,000 19,993 67% ------------------------------------------------- TOTAL GAS TAX 377,637 965,824 588,187 61% ================================================= BARSAA 2421-421-430240-354 PAVEMENT MAINTENANCE 391,420 476,016 84,596 18% ------------------------------------------------- TOTAL BARSAA 391,420 476,016 84,596 18% ================================================= 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 57,712 82,065 24,353 30% 2400-410-430263-153 HEALTH INSURANCE 7,899 14,700 6,801 46% 2400-410-430263-155 RETIREMENT 4,558 6,408 1,850 29% 2400-410-430263-244 STREET LIGHT SUPPLIES 813 18,000 17,187 95% 2400-410-430263-245 LUMINAIRES 5,605 30,000 24,395 81% 2400-410-430263-341 ELECTRICITY 109,484 182,000 72,516 40% 2400-410-430263-360 REPAIR & MAINT SERVICES 9,377 21,500 12,123 56% 2400-410-430263-373 DUES & TRAINING 202 3,500 3,299 94% 2400-410-430263-510 INSURANCE 1,846 1,850 4 0% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 10,301 13,734 3,433 25% 2400-410-430263-528 INFORMATION TECH TRANSFER 18,094 24,125 6,031 25% 2400-410-430263-940 MACHINERY & EQUIPMENT 4,549 5,000 452 9% 2400-410-430265-944 MACHINERY & EQUIP (replacement fund 0 70,000 70,000 100% ------------------------------------------------- TOTAL LIGHT MAINT. 230,440 472,882 242,442 51% ================================================= 2825 MACI GRANT-SWEEPER 2825-421-430240-940 EQUIPMENT 0 242,814 242,814 100% ------------------------------------------------- TOTAL MACI GRANT 0 242,814 242,814 100% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 19 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210 WATER FUND REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 2,083 2,000 83- -4% 5210-000-343210-000 METERED WATER SALES 3,311,273 3,850,000 538,727 14% 5210-000-343220-000 OTHER (CONST.) WATER SALES 33,279 25,000 8,279- -33% 5210-000-343230-000 METER REPLACEMENT FEE 127,295 150,000 22,705 15% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 119,939 52,500 67,439- -128% 5210-000-343270-000 WATER TURN ON FEES 2,745 4,000 1,255 31% 5210-000-343275-000 TAG FEE 24,480 33,000 8,520 26% 5210-000-343365-000 LATECOMER ADMIN FEE 9,225 10,000 775 8% 5210-000-371010-000 INVESTMENT EARNINGS 40,042 55,000 14,958 27% 5210-000-383010-000 TRANSFER FROM IMPACT FEE FUND (ADMI 18,000 24,000 6,000 25% 5210-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 187,500 250,000 62,500 25% ------------------------------------------------- TOTAL REVENUE 3,875,861 4,455,500 579,639 13% ================================================= EXPENSES WATER FACILITIES 5210-447-430550-110 SALARIES-WATER 539,359 863,706 324,347 38% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 2,750 20,000 17,250 86% 5210-447-430550-153 HEALTH INSURANCE 109,929 193,400 83,471 43% 5210-447-430550-155 RETIREMENT 43,031 67,212 24,181 36% 5210-447-430550-210 OFFICE SUPPLIES /EQUIP/COMPUTERS/GI 19,283 23,000 3,717 16% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 5,478 9,000 3,522 39% 5210-447-430550-226 CHLORINE & CHEMICALS 28,224 59,000 30,776 52% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 2,757 4,500 1,743 39% 5210-447-430550-231 GAS & OIL 20,267 35,000 14,733 42% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 178 1,000 822 82% 5210-447-430550-336 LICENSES & FEES 17,272 20,000 2,728 14% 5210-447-430550-341 ELECTRICITY 112,713 160,000 47,287 30% 5210-447-430550-344 NATURAL GAS 8,072 15,500 7,428 48% 5210-447-430550-345 TELEPHONE & COMMUNICATION 11,664 13,000 1,336 10% 5210-447-430550-349 LAB SERVICES 7,569 20,000 12,431 62% 5210-447-430550-352 CONTRACT SERVICES - HOSTING FEES 1,198 0 1,198- 0% 5210-447-430550-353 AUDITING 3,500 3,500 0 0% 5210-447-430550-354 CONTRACT SERVICES 15,167 55,000 39,833 72% 5210-447-430550-355 NOFFSINGER TRANSMISSION CONDITION A 57,958 263,000 205,042 78% 5210-447-430550-356 BACKBONE CONDITION ASSESS./WTR RIGH 575 75,000 74,425 99% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 3,656 15,000 11,344 76% 5210-447-430550-366 BUILDING MAINTENANCE 4,338 15,000 10,662 71% 5210-447-430550-373 DUES & TRAINING 4,340 13,000 8,660 67% 5210-447-430550-388 MEDICAL SERVICES 430 700 270 39% 5210-447-430550-410 CONSTRUCTION MATERIALS 23,403 35,000 11,597 33% 5210-447-430550-422 HYDRANTS 0 10,000 10,000 100% 5210-447-430550-423 MATERIALS FOR MAINS 1,832 14,000 12,168 87% 5210-447-430550-424 MATERIALS -SERVICE LINES 14,558 12,000 2,558- -21% 5210-447-430550-425 MATERIALS PUMPS/WELLS 41,002 65,000 23,998 37% 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 35,361 47,148 11,787 25% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 90,635 120,846 30,211 25% 5210-447-430550-528 INFORMATION TECH TRANSFER 72,752 97,003 24,251 25% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 20 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-532 LEASE PAYMENTS 0 4,000 4,000 100% ------------------------------------------------- TOTAL OPERATING EXPENSES 1,333,571 2,398,834 1,065,263 44% ------------------------------------------------- CAPITAL FROM OPERATING/BONDS 5210-447-430550-925 NOFFSINGER REHAB ALTERNATIVE 0 1,771,916 1,771,916 100% 5210-447-430550-935 METER SYSTEM REPLACEMENT 405,264 640,500 235,236 37% 5210-447-430550-940 MACHINERY & EQUIPMENT 0 127,200 127,200 100% 5210-447-430550-951 SECURITY SCADA UPGRADES 2,111 25,000 22,889 92% 5210-447-430550-954 ELEVATED STORAGE TANK & WELL 1,400 9,731,000 9,729,600 100% 5210-447-430550-958 2ND AVE W RR FROM CENTER TO 2ND ST 132,777 148,993 16,216 11% 5210-447-430550-969 DESIGN - LOWER ZONE RESERVOIRS ROOF 21,234 665,000 643,766 97% ------------------------------------------------- TOTAL CAPITAL FROM OP/BONDS 562,786 13,109,609 12,546,823 96% ------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES-WATER BILLING 89,529 134,700 45,171 34% 5210-447-430560-153 HEALTH INSURANCE 20,906 38,938 18,032 46% 5210-447-430560-155 RETIREMENT 7,300 10,854 3,554 33% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 4,115 16,000 11,885 74% 5210-447-430560-353 AUDITING 2,000 2,000 0 0% 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 37,227 45,000 7,773 17% 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 21,170 28,000 6,830 24% 5210-447-430560-356 OTHER CONTRACT SERVICES 74 1,000 926 93% 5210-447-430560-373 DUES & TRAINING 30 3,000 2,971 99% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 8,761 11,681 2,920 25% 5210-447-430560-528 INFORMATION TECH TRANSFER 57,419 76,558 19,139 25% ------------------------------------------------- TOTAL WATER BILLING 248,530 367,731 119,201 32% ------------------------------------------------- REVENUE BONDS/BOI LOANS 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% ------------------------------------------------- TOTAL REVENUE BONDS 109,224 454,895 345,671 76% ------------------------------------------------- DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 950,000 950,000 100% ------------------------------------------------- TOTAL DEPRECIATION 0 950,000 950,000 100% ------------------------------------------------- TOTAL WATER FUND 2,254,111 17,281,069 15,026,958 87% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 21 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING WATER IMPACT FEE REVENUE: 5211-000-343225-000 IMPACT FEES 592,633 700,000 107,367 15% 5211-000-371010-000 INTEREST EARNINGS 5,237 6,000 763 13% ------------------------------------------------- TOTAL WATER IMPACT FEES REVENU 597,869 706,000 108,131 15% ================================================= WATER IMPACT FEES EXPENSES: 5211-447-430555-424 METERS - NEW DEVELOPMENT 61,420 61,420 0- 0% 5211-447-430555-820 DEBT SERVICE TRANSFER TO 5210 187,500 250,000 62,500 25% 5211-447-430555-825 TRANSFER TO 5210 FOR ADMIN 18,000 24,000 6,000 25% 5211-447-430555-930 CONTRACT MAIN UPSIZE 0 405,000 405,000 100% 5211-447-430555-954 ELEVATED TANK & WELL 296,132 701,986 405,854 58% ------------------------------------------------- TOTAL IMPACT FEES 563,053 1,442,406 879,353 61% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 22 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310 SEWER FUND REVENUE 5310-000-323108-000 PW PLAN REVIEW FEES 2,083 1,500 583- -39% 5310-000-343310-000 SEWER SERVICE CHARGES 5,283,360 6,780,000 1,496,640 22% 5310-000-343320-000 NUTRIENT WORK GROUP ASSISTANCE REIM 58,274 0 58,274- 0% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 9,971 1,500 8,471- -565% 5310-000-343365-000 LATECOMER ADMIN FEES 6,651 2,000 4,651- -233% 5310-000-371010-000 INVESTMENT EARNINGS 30,364 33,000 2,636 8% 5310-000-383010-000 ADMIN TRANSFER FROM IMPACT FEE FUND 75,000 100,000 25,000 25% 5310-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 750,000 1,000,000 250,000 25% ------------------------------------------------- TOTAL REVENUE 6,215,702 7,918,000 1,702,298 22% ================================================= SEWER BILLING COSTS 5310-454-430620-110 SALARIES-SEWER BILLING 80,928 116,145 35,217 30% 5310-454-430620-153 HEALTH INSURANCE 17,757 28,566 10,809 38% 5310-454-430620-155 RETIREMENT - PERD 6,587 9,219 2,632 29% 5310-454-430620-215 OFFICE SUPPLIES/computers 4,113 16,000 11,887 74% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 2,000 2,000 0 0% 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 37,227 45,000 7,773 17% 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 21,170 28,000 6,830 24% 5310-454-430620-356 OTHER CONTRACT SERVICES 74 1,000 926 93% 5310-454-430620-373 DUES & TRAINING 30 3,000 2,971 99% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 7,897 10,530 2,633 25% 5310-454-430620-528 INFORMATION TECH. TRANSFER 57,419 76,558 19,139 25% ------------------------------------------------- TOTAL SEWER BILLING COSTS 235,201 336,018 100,817 30% ------------------------------------------------- SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES-SANITARY SEWER 217,002 350,322 133,320 38% 5310-454-430630-121 OVERTIME 432 5,500 5,068 92% 5310-454-430630-153 HEALTH INSURANCE 36,433 81,304 44,871 55% 5310-454-430630-155 RETIREMENT 17,343 27,223 9,880 36% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 9,662 13,450 3,788 28% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 2,202 8,350 6,148 74% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 1,210 2,300 1,090 47% 5310-454-430630-231 GAS & OIL 6,918 12,000 5,082 42% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 270 500 230 46% 5310-454-430630-341 ELECTRICITY 34,545 57,000 22,455 39% 5310-454-430630-344 NATURAL GAS 10,308 16,500 6,192 38% 5310-454-430630-345 TELEPHONE & COMMUNICATION 15,805 27,500 11,695 43% 5310-454-430630-353 AUDITING 3,000 3,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 21,636 35,000 13,364 38% 5310-454-430630-355 CONTRACT SERVICES - EVERGREEN MTR R 2,595 0 2,595- 0% 5310-454-430630-356 CONSULTANTS - MODELING/RATE STUDY 4,208 20,000 15,792 79% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 3,533 11,500 7,967 69% 5310-454-430630-373 DUES & TRAINING 1,732 9,250 7,518 81% 5310-454-430630-388 MEDICAL SERVICES 500 500 0 0% 5310-454-430630-410 CONSTRUCTION MATERIALS 2,819 10,000 7,181 72% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 59,803 70,000 10,197 15% 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 9,717 12,955 3,238 25% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 57,998 77,331 19,333 25% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 23 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-528 INFORMATION TECH TRANSFER 47,008 62,678 15,670 25% 5310-454-430630-532 OFFICE RENT / BNSF LEASE 6,890 0 6,890- 0% ------------------------------------------------- TOTAL COLLECTION OPERATING EX 592,267 957,860 365,593 38% ------------------------------------------------- CAPITAL FROM OPERATING/BONDS 5310-454-430630-922 L.S. #9 IMPROVEMENTS/DESIGN 24,859 2,247,113 2,222,254 99% 5310-454-430630-940 MACHINERY & EQUIPMENT 85,672 85,672 0 0% 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 958 1,196,414 1,195,456 100% 5310-454-430630-958 DESIGN - L.S. #3 IMPROVEMENTS 5,132 418,510 413,378 99% 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% ------------------------------------------------- TOTAL CAP. FROM OP/BONDS 116,621 4,399,038 4,282,417 97% ------------------------------------------------- CAPITAL FROM EQUIP REPLACEMENT 5310-454-430635-940 MACHINERY & EQUIPMENT (10126) 128,610 172,700 44,090 26% ------------------------------------------------- TOTAL CAP. FROM EQUIP. REPLACE 128,610 172,700 44,090 26% ------------------------------------------------- REVENUE BONDS/SANITARY 5310-454-490200-610 PRINCIPAL WESTSIDE INTERCEPTOR BOND 0 294,000 294,000 100% 5310-454-490200-620 INTEREST-WESTSIDE INTERCEPTOR BOND 279,150 279,150 0 0% 5310-454-490204-610 PRINCIPAL - HWY 93 S/SRF5125/2.25% 0 91,000 91,000 100% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 5,726 5,726 0- 0% ------------------------------------------------- TOTAL REVENUE BONDS 284,876 669,876 385,000 57% ------------------------------------------------- DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 500,000 500,000 100% ------------------------------------------------- TOTAL DEPRECIATION-SANITARY 0 500,000 500,000 100% ------------------------------------------------- TOTAL SANITARY SEWER 1,357,575 7,035,492 5,677,917 81% ------------------------------------------------- WWTP OPERATING 5310-455-430640-110 SALARIES-WWTP 339,654 509,354 169,700 33% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-121 OVERTIME 19,554 22,500 2,946 13% 5310-455-430640-153 HEALTH INSURANCE 57,976 95,202 37,226 39% 5310-455-430640-155 RETIREMENT 28,796 39,199 10,403 27% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 12,750 13,500 750 6% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 1,536 3,500 1,964 56% 5310-455-430640-225 ALUM 15,550 35,000 19,450 56% 5310-455-430640-226 CHLORINE & CHEMICALS 98,078 120,000 21,922 18% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 6,395 7,500 1,105 15% 5310-455-430640-231 GAS & OIL 9,182 19,000 9,818 52% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 76 550 474 86% 5310-455-430640-336 LICENSES & FEES 9,984 16,000 6,016 38% 5310-455-430640-341 ELECTRICITY 117,946 195,000 77,054 40% 5310-455-430640-342 WATER 2,011 7,500 5,489 73% 5310-455-430640-344 NATURAL GAS 44,218 82,000 37,782 46% 5310-455-430640-345 TELEPHONE & COMMUNICATION 4,594 12,050 7,456 62% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 24 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-353 AUDITING 2,500 2,500 0 0% 5310-455-430640-354 CONTRACT-GLACIER GOLD 93,554 135,000 41,446 31% 5310-455-430640-355 CONTRACT - LAND FILL & OTHER 39,841 55,500 15,659 28% 5310-455-430640-356 CONSULTANTS 85,110 289,000 203,890 71% 5310-455-430640-358 CONSULTANT- PERMIT/RATE STDY/TMDL 107,226 205,000 97,774 48% 5310-455-430640-360 MISC. MAINT SERVICES 22,834 35,000 12,166 35% 5310-455-430640-366 BUILDING MAINTENANCE 10,720 40,000 29,280 73% 5310-455-430640-373 DUES & TRAINING 3,082 9,500 6,418 68% 5310-455-430640-388 MEDICAL SERVICES 434 500 66 13% 5310-455-430640-510 PROPERTY & LIABILITY INS. 52,332 52,332 0 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 14,059 18,746 4,687 25% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 90,079 120,105 30,026 25% 5310-455-430640-528 INFORMATION TECH TRANSFER 41,013 54,684 13,671 25% ------------------------------------------------- TOTAL WWTP OPERATING EXPENSE 1,331,085 2,200,722 869,637 40% ------------------------------------------------- WWTP CAPITAL FM OPERATING/BOND 5310-455-430640-921 DESIGN-DOME FOR SECONDARY CLARIFIER 0 419,000 419,000 100% 5310-455-430640-922 CONSTRUCT NEW FERMENTER (rehab) 0 5,925,000 5,925,000 100% 5310-455-430640-930 BIOSOLIDS ALTERNATE DISPOSAL ENG 0 178,052 178,052 100% 5310-455-430640-933 NEW EQ BASIN 0 2,420,000 2,420,000 100% ------------------------------------------------- TOTAL WWTP CAP. FM OP/BOND 0 8,942,052 8,942,052 100% ------------------------------------------------- WWTP LAB 5310-455-430646-110 SALARIES-WWTP LAB 91,870 132,414 40,544 31% 5310-455-430646-153 HEALTH INSURANCE 11,906 18,720 6,814 36% 5310-455-430646-155 RETIREMENT 7,458 10,131 2,673 26% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 1,428 6,000 4,572 76% 5310-455-430646-218 NON-CAPITAL EQUIPMENT 3,298 3,500 202 6% 5310-455-430646-222 LAB SUPPLIES 13,192 17,500 4,308 25% 5310-455-430646-349 LAB SERVICES 9,603 19,000 9,397 49% 5310-455-430646-350 PRETREATMENT SERVICE 4,885 15,000 10,115 67% 5310-455-430646-362 EQUIPMENT MAINTENANCE 5,029 5,500 471 9% 5310-455-430646-373 DUES & TRAINING 0 5,000 5,000 100% 5310-455-430646-940 EQUIPMENT - ANALYZER 8,630 8,500 130- -2% ------------------------------------------------- TOTAL WWTP LAB 157,299 241,265 83,966 35% ------------------------------------------------- WWTP REPLACE(10125) 5310-455-430645-362 EQUIPMENT MAINTENANCE 41,611 125,000 83,389 67% 5310-455-430645-922 DESIGN FERMENTER RECONSTRUCTION 43,951 275,000 231,049 84% 5310-455-430645-934 SECONDARY DIGESTER LID REPLC 13,966 21,235 7,269 34% 5310-455-430645-940 MACHINERY & EQUIPMENT 0 280,000 280,000 100% 5310-455-430645-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 112,325 112,325 100% ------------------------------------------------- TOTAL WWTP REPLACEMENT 99,529 813,560 714,031 88% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 25 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING REVENUE BONDS/WWTP 5310-455-490227-610 PRINCIPAL - WWTP IMP/SRF8164R/2.25% 0 890,000 890,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 122,198 122,198 1 0% 5310-455-490228-610 PRINC - WWTP DIGESTER LID/SRF 13326 0 52,000 52,000 100% 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 21,540 21,540 0 0% ------------------------------------------------- TOTAL REVENUE BONDS/WWTP 143,738 1,085,738 942,001 87% ------------------------------------------------- DEPRECIATION 5310-455-510400-831 DEPR. EXP. - WWTP (INCLUDES 010125 0 1,250,000 1,250,000 100% ------------------------------------------------- TOTAL DEPRECIATION 0 1,250,000 1,250,000 100% ------------------------------------------------- TOTAL WWTP 1,731,650 14,533,337 12,801,687 88% ------------------------------------------------- TOTAL BILLING/SANITARY/WWTP 3,089,225 21,568,829 18,479,604 86% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 26 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER IMPACT FEE REVENUE 5311-000-343330-000 SANITARY IMPACT FEES 1,136,480 900,000 236,480- -26% 5311-000-343335-000 TREATMENT IMPACT FEES 652,846 500,000 152,846- -31% 5311-000-371010-000 SANITARY INTEREST EARNINGS 10,371 12,000 1,629 14% 5311-000-371015-000 TREATMENT INTEREST EARNINGS 8,912 9,500 588 6% ------------------------------------------------- TOTAL SEWER IMPACT FEES REVENU 1,808,609 1,421,500 387,109- -27% ================================================= COLLECTION IMP. FEE EXPENSES 5311-454-430635-820 TRANSFER TO 5310 FOR DEBT (SANITARY 375,000 500,000 125,000 25% 5311-454-430635-825 TRANSFER TO 5310 FOR ADMIN 45,000 60,000 15,000 25% ------------------------------------------------- TOTAL COLL. IMP. FEES TRANSFER 420,000 560,000 140,000 25% ------------------------------------------------- CAPITAL FROM COLL. IMP. FEES 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 5,132 356,509 351,377 99% ------------------------------------------------- TOTAL CAP. FM COLL. IMP. FEES 5,132 1,067,051 1,061,919 100% ------------------------------------------------- TOTAL COLL. IMP. FEE EXPENSE 425,132 1,627,051 1,201,919 74% ------------------------------------------------- TREATMENT IMP. FEE EXPENSES 5311-455-430644-820 TRANSFER TO 5310 FOR DEBT 375,000 500,000 125,000 25% 5311-455-430644-825 TRANSFER TO 5310 FOR ADMIN 30,000 40,000 10,000 25% ------------------------------------------------- TOTAL TREATMT IMP. FEES TRANSF 405,000 540,000 135,000 25% ------------------------------------------------- CAPITAL FROM TREATMT IMP. FEES 5311-455-430644-929 CONSTRUCT NEW EQ BASIN 45,020 440,395 395,375 90% 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 CAP FM TRTMNT IMP. FEES 45,020 772,911 727,891 94% ------------------------------------------------- TOTAL WWTP IMPACT FEES EXPENSE 450,020 1,312,911 862,891 66% ------------------------------------------------- TOTAL SEWER IMPACT FEE EXPENSE 875,152 2,939,962 2,064,810 70% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 27 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5349 STORM SEWER FUND REVENUE 5349-000-323108-000 PW PLAN REVIEW FEES 2,083 1,000 1,083- -108% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 0 1,500 1,500 100% 5349-000-343034-000 PERMIT FEES 2,060 1,000 1,060- -106% 5349-000-343035-000 STORM SEWER CHARGES 1,498 1,000 498- -50% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 1,899,482 1,850,000 49,482- -3% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 2,691 2,500 191- -8% 5349-000-365000-000 DONATIONS & STRM SWR CLASS 600 0 600- 0% 5349-000-371010-000 INTEREST ON INVESTMENTS 12,970 20,000 7,030 35% 5349-000-383010-000 IMPACT FEE 5% ADMIN - TFR FROM IMPA 7,500 10,000 2,500 25% 5349-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 85,000 150,000 65,000 43% ------------------------------------------------- TOTAL REVENUE 2,013,884 2,037,000 23,116 1% ================================================= STORM OPERATING EXPENSES 5349-453-430246-110 SALARIES-STORM SEWER 345,390 537,579 192,189 36% 5349-453-430246-121 OVERTIME 454 4,000 3,546 89% 5349-453-430246-153 HEALTH INSURANCE 59,298 112,926 53,628 47% 5349-453-430246-155 RETIREMENT 27,743 41,860 14,117 34% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 13,967 17,100 3,133 18% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 635 6,000 5,365 89% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100% 5349-453-430246-231 GAS & OIL 6,918 11,500 4,582 40% 5349-453-430246-345 TELEPHONE & COMMUNICATION 1,718 3,000 1,282 43% 5349-453-430246-353 AUDITING 1,150 1,150 0 0% 5349-453-430246-354 CONTRACT SERVICE 4,409 7,000 2,591 37% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 23,919 35,000 11,081 32% 5349-453-430246-358 CONSULTANTS 328 10,000 9,672 97% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 26,104 30,000 3,896 13% 5349-453-430246-360 REPAIR & MAINT SERVICES 570 5,000 4,430 89% 5349-453-430246-362 GROUNDWATER MONITORING 3,281 6,500 3,219 50% 5349-453-430246-371 CURB & GUTTER 1,427 21,000 19,573 93% 5349-453-430246-373 DUES & TRAINING 383 9,250 8,867 96% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 2,732 10,000 7,268 73% 5349-453-430246-510 PROPERTY & LIABILITY INS. 13,436 18,436 5,000 27% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 9,717 12,955 3,238 25% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 36,917 49,223 12,306 25% 5349-453-430246-528 INFORMATION TECH TRANSFER 43,837 58,450 14,613 25% 5349-453-430246-530 BNSF LEASE PMT 0 5,500 5,500 100% ------------------------------------------------- TOTAL STORM OPERATING EXPENSE 624,334 1,015,729 391,395 39% ------------------------------------------------- CAPITAL FROM OPERATING/BONDS 5349-453-430246-968 RR W CENTER-7TH AVE W TO MERIDIAN 230,991 230,992 1 0% 5349-453-430246-970 REG. FACILITIES & PIPING DESIGN (BO 1,060,546 2,486,434 1,425,888 57% ------------------------------------------------- TOTAL CAP. FROM OPERATING/BOND 1,291,537 2,717,426 1,425,889 52% ------------------------------------------------- CAPITAL FROM DES. CAP. PROJECT 5349-453-430247-952 STORM DRAIN CORRECTION (NEW & C/O) 18,686 200,000 181,314 91% 5349-453-430247-954 N. MAIN ST STORMWATER PROJ. 0 252,500 252,500 100% 5349-453-430247-956 WYOMING STREET OUTFALL 0 225,000 225,000 100% 5349-453-430247-959 REGIONAL FACILITIES & PIPING DESIGN 23,269 351,606 328,337 93% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 28 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 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 166,248 288,079 121,831 42% 5349-453-430247-969 1ST AVE W - S. OF CITY SHOPS 41,319 395,500 354,181 90% ------------------------------------------------- TOTAL CAP. FROM DES. CAP. PROJ 249,522 1,762,685 1,513,163 86% ------------------------------------------------- CAPITAL/OTHER FROM REPLACEMENT 5349-453-430249-940 MACHINERY FROM REPLACEMENT 214,282 258,431 44,149 17% ------------------------------------------------- TOTAL CAPITAL/OTHER FROM REPLA 214,282 258,431 44,149 17% ------------------------------------------------- REVENUE BONDS 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% ------------------------------------------------- TOTAL REVENUE BONDS 68,371 235,637 167,266 71% ------------------------------------------------- DEPRECIATION 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 360,000 360,000 100% ------------------------------------------------- TOTAL DEPRECIATION 0 360,000 360,000 100% ------------------------------------------------- TOTAL STORM EXPENSE 2,448,045 6,349,908 3,901,863 61% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 29 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM SEWER IMPACT FEE REVENUE 5348-000-343033-000 IMPACT FEES 222,552 280,000 57,448 21% 5348-000-371010-000 INTEREST EARNINGS 6,129 9,000 2,871 32% ------------------------------------------------- TOTAL STORM IMPACT FEES REVENU 228,681 289,000 60,319 21% ================================================= STORM SWR IMPACT FEE EXPENSES 5348-453-430248-820 DEBT SERVICE TRANSFER TO 5349 85,000 150,000 65,000 43% 5348-453-430248-825 TRANSFER TO 5349 FOR ADMIN 7,500 10,000 2,500 25% ------------------------------------------------- TOTAL IMPACT FEE TRANSFERS 92,500 160,000 67,500 42% ------------------------------------------------- CAPITAL FROM IMPACT FEES 5348-453-430248-959 REG FACILITIES & PIPING DESIGN 573,189 1,237,829 664,640 54% 5348-453-430248-960 STORMWATER FACILITY UPSIZING (CARRY 0 230,000 230,000 100% 5348-453-430248-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% ------------------------------------------------- TOTAL CAPITAL FROM IMPACT FEES 573,189 1,517,829 944,640 62% ------------------------------------------------- TOTAL STORM IMPACT FEE EXPENSE 665,689 1,677,829 1,012,140 60% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 30 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5510 SOLID WASTE REVENUE 5510-000-343360-000 SALE OF MAT/AUCTION 2,496 2,500 4 0% 5510-000-343410-000 GARBAGE COLLECTION-ASSESSED 1,081,926 1,060,000 21,926- -2% 5510-000-343420-000 GARBAGE COLLECTION-NOT ASSESSED 29,862 25,000 4,862- -19% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,957 2,000 43 2% 5510-000-371010-000 INVESTMENT EARNINGS 3,797 10,000 6,203 62% ------------------------------------------------- TOTAL REVENUE 1,120,038 1,099,500 20,538- -2% ================================================= EXPENSES 5510-460-430840-110 SALARIES-SOLID WASTE 331,812 471,278 139,466 30% 5510-460-430840-121 OVERTIME 4,011 6,500 2,489 38% 5510-460-430840-153 HEALTH INSURANCE 61,938 96,042 34,104 36% 5510-460-430840-155 RETIREMENT 26,586 36,556 9,970 27% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 11,658 15,500 3,842 25% 5510-460-430840-218 EQUIPMENT-GARBAGE CONTAINERS 36,601 37,500 899 2% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 2,399 5,500 3,101 56% 5510-460-430840-231 GAS & OIL 43,237 60,000 16,763 28% 5510-460-430840-341 ELECTRICITY 965 2,050 1,085 53% 5510-460-430840-344 NATURAL GAS 2,057 4,500 2,443 54% 5510-460-430840-345 TELEPHONE & COMMUNICATION 1,653 2,960 1,307 44% 5510-460-430840-354 CONTRACT SERVICES 2,886 22,000 19,114 87% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 3,056 55,000 51,944 94% 5510-460-430840-366 BUILDING MAINTENANCE 81 5,000 4,919 98% 5510-460-430840-373 DUES & TRAINING 996 7,000 6,004 86% 5510-460-430840-388 MEDICAL SERVICES 285 700 415 59% 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 84,333 112,444 28,111 25% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 34,531 46,041 11,510 25% 5510-460-430840-528 INFORMATION TECH TRANSFER 35,256 47,008 11,752 25% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 30,000 40,000 10,000 25% 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 744,984 1,590,422 845,438 53% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 31 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 4290 WALK & CURB CONSTRUCTION 4290-410-430234-937 CONSTRUCTION 4,165 25,000 20,835 83% ------------------------------------------------- TOTAL WALK & CURB CONSTRUCTION 4,165 25,000 20,835 83% ================================================= 4393 AMERICAN RESCUE PLAN PROJ 4393-410-430550-950 OTHER WTR/SWR ARPA PROJECTS 0 4,700,000 4,700,000 100% 4393-410-430550-951 DOWNTOWN WTR/SWR MAIN ARPA PROJECT 60,780 5,122,718 5,061,938 99% ------------------------------------------------- TOTAL AMERICAN RESCUE PLAN PRO 60,780 9,822,718 9,761,938 99% ================================================= 5720 WATER/SEWER ARPA PROJECT 5720-410-430550-951 DOWNTOWN WTR/SWR MAIN REPL. ARPA PR 0 2,000,000 2,000,000 100% 5720-410-430550-956 STORM TRTMT FACILITY MAIN & WY ARPA 0 377,766 377,766 100% 5720-410-430550-969 STORM TRTMT FACILITY (ASHLEY) CR AR 0 528,264 528,264 100% ------------------------------------------------- TOTAL WTR/SWR ARPA GRANT 0 2,906,030 2,906,030 100% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 32 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-410-431330-110 SALARIES 131,190 186,349 55,159 30% 6010-410-431330-121 OVERTIME 757 2,500 1,743 70% 6010-410-431330-153 HEALTH INSURANCE 23,722 37,831 14,109 37% 6010-410-431330-155 RETIREMENT 9,986 14,108 4,122 29% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 9,998 19,500 9,502 49% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 3,988 23,500 19,512 83% 6010-410-431330-230 OIL 14,455 25,500 11,045 43% 6010-410-431330-231 GAS 608 1,500 892 59% 6010-410-431330-232 VEHICLE PARTS 95,506 140,000 44,494 32% 6010-410-431330-233 TIRES 29,838 54,000 24,162 45% 6010-410-431330-238 FILTERS 7,599 9,000 1,401 16% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 2,041 2,000 41- -2% 6010-410-431330-341 ELECTRICITY 2,608 5,900 3,292 56% 6010-410-431330-342 WATER 459 2,000 1,541 77% 6010-410-431330-344 NATURAL GAS 6,154 12,500 6,346 51% 6010-410-431330-354 CONTRACT SERVICES 17,497 32,000 14,503 45% 6010-410-431330-360 WASH BAY REPAIRS & MAINTENANCE 77 6,000 5,923 99% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 188 6,000 5,812 97% 6010-410-431330-373 DUES & TRAINING 1,694 8,500 6,806 80% 6010-410-431330-388 MEDICAL SERVICES 230 500 270 54% 6010-410-431330-510 INSURANCE 4,698 4,600 98- -2% 6010-410-431330-528 INFORMATION TECH TRANSFER 17,162 22,883 5,721 25% 6010-410-431330-921 SCAN TOOL REPLACEMENT 9,818 11,000 1,182 11% ------------------------------------------------- TOTAL CENTRAL GARAGE 390,275 627,671 237,396 38% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 33 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PARKS & RECREATION REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 685,041 1,147,000 461,959 40% 2215-000-311200-000 PERSONAL PROPERTY TAXES 25,038 24,675 363- -1% 2215-000-312000-000 PEN & INTEREST DEL TAXES 1,491 1,500 9 1% 2215-000-334000-000 GRANT - POOL IMPROVEMENTS 0 86,000 86,000 100% 2215-000-346030-000 SWIMMING POOL FEES 78,821 155,000 76,179 49% 2215-000-346040-000 CONCESSION STAND REVENUE 33,308 42,000 8,692 21% 2215-000-346050-000 PARKS USAGE FEES 10,846 20,000 9,154 46% 2215-000-346051-000 RECREATION FEES 17,050 39,010 21,960 56% 2215-000-346052-000 SPORTS PROGRAMS 82,199 81,728 471- -1% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 1,657 2,700 1,044 39% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 62,748 67,554 4,806 7% 2215-000-346055-000 ICE RINK 12,831 22,000 9,169 42% 2215-000-346056-000 KIDSPORT USAGE 596 3,000 2,404 80% 2215-000-346057-000 YOUTH CAMPS 17,507 192,244 174,737 91% 2215-000-346059-000 PICNIC IN THE PARK 15,598 26,500 10,902 41% 2215-000-362015-000 INSURANCE REIMBURSEMENTS 2,818 0 2,818- 0% 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 12,803 0 12,803- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-371010-000 INVESTMENTS 3,161 5,000 1,839 37% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 55,500 111,000 55,500 50% ------------------------------------------------- TOTAL PARKS & REC REVENUE 1,119,013 2,046,911 927,898 45% ================================================= EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES-PARKS 261,549 380,186 118,637 31% 2215-436-460430-111 SEASONAL SALARIES 30,291 89,519 59,228 66% 2215-436-460430-121 OVERTIME 0 300 300 100% 2215-436-460430-153 HEALTH INSURANCE 40,651 65,846 25,195 38% 2215-436-460430-155 RETIREMENT 24,936 34,562 9,626 28% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 557 2,000 1,443 72% 2215-436-460430-215 EQUIPMENT - not capital 0 3,000 3,000 100% 2215-436-460430-224 JANITORIAL SUPPLIES 2,956 7,000 4,044 58% 2215-436-460430-229 OTHER SUPPLIES 3,424 10,000 6,576 66% 2215-436-460430-231 GAS 13,450 17,000 3,550 21% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 839 3,000 2,161 72% 2215-436-460430-320 PRINTING & ADVERTISING 178 200 22 11% 2215-436-460430-341 ELECTRICITY 8,003 13,000 4,997 38% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 19,393 22,000 2,607 12% 2215-436-460430-344 NATURAL GAS 1,935 2,030 95 5% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 1,362 2,500 1,138 46% 2215-436-460430-351 SPORTS COURT & SPORT MAINTENANCE 0 2,000 2,000 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 2,000 2,000 0 0% 2215-436-460430-355 CONTRACT SERV. TRAIL MAINT/WEED CON 1,475 18,000 16,525 92% 2215-436-460430-356 CONSULTANTS - PRELIMINARY DESIGN HW 0 40,000 40,000 100% 2215-436-460430-357 CONSULTANTS - LAWRANCE PARK TRAIL 1,843 12,000 10,157 85% 2215-436-460430-358 FVCC TENNIS INTERLOCAL AGREEMENT 7,000 7,000 0 0% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 5,390 8,000 2,610 33% 2215-436-460430-364 LANDSCAPING 0 5,450 5,450 100% 2215-436-460430-367 VANDALISM REPAIRS 1,623 4,000 2,377 59% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 34 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-373 DUES & TRAINING 6,379 8,000 1,621 20% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 55 500 445 89% 2215-436-460430-395 EQUIPMENT RENTAL 500 500 0 0% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 299 6,500 6,201 95% 2215-436-460430-440 IRRIGATION SUPPLIES 1,652 7,000 5,348 76% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 523 2,000 1,477 74% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 24,724 32,965 8,241 25% 2215-436-460430-545 COUNTY LANDFILL 4,042 6,273 2,231 36% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 60,234 60,234 0- 0% 2215-436-460430-620 DEBT SERVICE INTEREST 1,806 2,056 250 12% ------------------------------------------------- SUBTOTAL PARKS EXPENDITURES 529,068 876,621 347,553 40% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES-COMPLEX 68,535 121,391 52,856 44% 2215-436-460440-111 SEASONAL SALARIES 19,781 45,190 25,409 56% 2215-436-460440-121 OVERTIME 0 300 300 100% 2215-436-460440-153 HEALTH INSURANCE 15,740 32,672 16,932 52% 2215-436-460440-155 RETIREMENT 7,155 11,483 4,328 38% 2215-436-460440-221 SAFETY EQUIPMENT 0 300 300 100% 2215-436-460440-229 OTHER SUPPLIES 3,745 22,000 18,255 83% 2215-436-460440-231 GAS 5,755 8,240 2,485 30% 2215-436-460440-241 CONSUMABLE TOOLS 230 780 550 70% 2215-436-460440-341 ELECTRICITY 6,157 11,656 5,499 47% 2215-436-460440-345 TELEPHONE & COMMUNICATION 173 251 78 31% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 276 500 224 45% 2215-436-460440-364 LANDSCAPING 0 300 300 100% 2215-436-460440-367 VANDALISM REPAIRS 0 500 500 100% 2215-436-460440-373 DUES & TRAINING 721 700 21- -3% 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 6,104 8,139 2,035 25% 2215-436-460440-545 COUNTY LANDFILL 3,470 3,500 30 1% 2215-436-460440-940 EQUIPMENT - (RIDING PAINT STRIPER) 14,192 15,000 808 5% ------------------------------------------------- SUBTOTAL ATHLETIC COMPLEX 154,952 298,802 143,850 48% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES-RECREATION 64,358 98,805 34,447 35% 2215-436-460431-111 SEASONAL SALARIES 13,722 22,490 8,768 39% 2215-436-460431-153 HEALTH INSURANCE 10,359 21,999 11,640 53% 2215-436-460431-155 RETIREMENT 5,280 9,674 4,394 45% 2215-436-460431-229 MISC. SUPPLIES 8,762 13,560 4,798 35% 2215-436-460431-231 GAS 139 575 436 76% 2215-436-460431-320 PRINTING & ADVERTISING 0 7,900 7,900 100% 2215-436-460431-345 TELEPHONE & COMMUNICATION 679 1,126 447 40% 2215-436-460431-354 CONTRACT SERVICES 33,049 40,462 7,413 18% 2215-436-460431-357 MUSIC FRANCHISE FEES 1,255 1,400 145 10% 2215-436-460431-373 DUES & TRAINING 552 1,000 448 45% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 35 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SUBTOTAL RECREATION 138,155 218,991 80,836 37% YOUTH CAMPS 2215-436-460448-110 SALARIES-YOUTH CAMPS 56,272 87,665 31,393 36% 2215-436-460448-111 SEASONAL SALARIES 102,191 153,655 51,464 33% 2215-436-460448-121 OVERTIME 593 150 443- -295% 2215-436-460448-153 HEALTH INSURANCE 9,764 18,708 8,944 48% 2215-436-460448-155 RETIREMENT 4,574 8,022 3,448 43% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 278 250 28- -11% 2215-436-460448-229 MISC. SUPPLIES 3,262 3,665 403 11% 2215-436-460448-231 GAS 129 400 271 68% 2215-436-460448-320 PRINTING & ADVERTISING 0 380 380 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 846 1,246 400 32% 2215-436-460448-354 CONTRACT SERVICES 10,133 20,985 10,852 52% 2215-436-460448-355 AFTER SCHOOL PROGRAM 30 1,200 1,170 98% 2215-436-460448-356 BANK FEES/CC CHARGES 2,609 4,700 2,091 45% 2215-436-460448-373 DUES & TRAINING 569 1,000 431 43% ------------------------------------------------- SUBTOTAL YOUTH CAMPS 191,249 302,026 110,777 37% PARKLINE TRAIL MAINTENANCE 2215-436-460457-110 SALARIES - PARK LINE TRAIL 9,948 45,812 35,864 78% 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 1,452 18,798 17,346 92% 2215-436-460457-155 RETIREMENT 807 2,808 2,001 71% 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 181 3,500 3,319 95% 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 70 600 530 88% 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 12,459 196,988 184,529 94% POOL 2215-437-460445-111 SEASONAL SALARIES-POOL 133,087 197,345 64,258 33% 2215-437-460445-121 OVERTIME 1,845 200 1,645- -822% 2215-437-460445-155 RETIREMENT 630 1,500 870 58% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 181 500 319 64% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 2,345 2,000 345- -17% THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 36 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 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 538 4,000 3,462 87% 2215-437-460445-341 ELECTRICITY 6,760 9,500 2,740 29% 2215-437-460445-344 NATURAL GAS 11,263 25,000 13,737 55% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,341 2,500 1,159 46% 2215-437-460445-354 LICENSES & FEES 708 1,400 692 49% 2215-437-460445-356 BANK FEES/ CC CHARGES 2,903 2,300 603- -26% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 8,144 13,000 4,856 37% 2215-437-460445-367 VANDALISM 0 1,000 1,000 100% 2215-437-460445-380 TRAINING MATERIALS 1,260 1,800 540 30% 2215-437-460445-932 EQUIPMENT / POOL IMPROVEMENTS 0 172,000 172,000 100% ------------------------------------------------- SUBTOTAL POOL EXPENDITURES 215,072 495,045 279,973 57% ------------------------------------------------- TOTAL PARKS & RECREATION/POOL 1,240,955 2,388,473 1,147,518 48% ================================================= 2210 PARKS IN LIEU 2210-436-460430-934 CAPITAL IMPROVEMENTS - LIONS PARK P 0 46,000 46,000 100% ------------------------------------------------- TOTAL PARKS IN LIEU 0 46,000 46,000 100% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 37 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING URBAN FORESTRY 2600-436-460433-110 SALARIES-URBAN FORESTRY 147,258 214,844 67,586 31% 2600-436-460433-111 SEASONAL SERVICES 6,948 49,185 42,237 86% 2600-436-460433-121 OVERTIME 0 1,000 1,000 100% 2600-436-460433-153 HEALTH INSURANCE 28,192 46,165 17,973 39% 2600-436-460433-155 RETIREMENT 12,456 21,094 8,638 41% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 3,494 3,500 6 0% 2600-436-460433-231 GAS 4,215 5,900 1,685 29% 2600-436-460433-241 CONSUMABLE TOOLS 796 5,200 4,404 85% 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 500 662 162 24% 2600-436-460433-354 CONTRACT SERVICES 67,420 170,000 102,580 60% 2600-436-460433-357 FORESTRY GRANT 1,000 4,138 3,138 76% 2600-436-460433-358 EAB MONITORING/ARBOR DAY 0 4,750 4,750 100% 2600-436-460433-362 EQUIPMENT MAINTENANCE 443 4,000 3,557 89% 2600-436-460433-364 LANDSCAPING & TREES 3,695 8,000 4,305 54% 2600-436-460433-373 DUES & TRAINING 1,467 5,000 3,533 71% 2600-436-460433-388 MEDICAL 0 300 300 100% 2600-436-460433-395 EQUIPMENT RENTAL 6,273 7,200 927 13% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 6,609 6,609 0- -0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 9,579 12,771 3,192 25% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 15,318 20,424 5,106 25% 2600-436-460433-528 INFORMATION TECHNOLOGY TRANSFER 8,203 10,937 2,734 25% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 10,374 10,374 0- 0% 2600-436-460433-620 INTEREST EXPENSE 128 171 43 25% ------------------------------------------------- TOTAL URBAN FORESTRY 334,367 612,224 277,857 45% ================================================= 2601 DEVELOPER TREES 2601-436-460430-350 ADMIN 5% 1,256 1,256 0 0% 2601-436-460435-351 EMPIRE ESTATES ($44,911) 0 8,653 8,653 100% 2601-436-460435-352 APPLEWAY ($4,564) 0 4,336 4,336 100% 2601-436-460435-353 SIDERIUS - JAXSON RIDGE 0 8,861 8,861 100% 2601-436-460435-354 PW - WEST SIDE INT. 0 6,494 6,494 100% 2601-436-460435-356 SINOPAH SUBD ($5,790) 0 667 667 100% 2601-436-460435-357 COTTONWOOD SUBD ($13,100) 0 1,928 1,928 100% 2601-436-460435-358 WEST VIEW SUBD ($22,680) 4,671 4,671 0 0% 2601-436-460435-359 MTN VISTA ESTATES ($35,903+34,660) 0 14,849 14,849 100% 2601-436-460435-360 OWL VIEW TH ($3,780) 0 3,780 3,780 100% 2601-436-460435-361 VILLAGE GREENS PHASE 19 ($16,497) 0 15,551 15,551 100% 2601-436-460435-362 WESTVIEW BUSINESS CNTR ($1,618) 0 948 948 100% 2601-436-460435-363 MUSKRAT SLOUGH ($1,446) 0 1,390 1,390 100% 2601-436-460435-364 MTN VISTA ESTATES IV 0 17,300 17,300 100% 2601-436-460435-365 VILLAGE GREENS $3,540 0 1,485 1,485 100% 2601-436-460435-366 W VIEW ESTATES $20,060 828 16,876 16,048 95% 2601-436-460435-367 ABIGAIL SUBDIVISION ($4,253.90) 0 2,716 2,716 100% 2601-436-460435-368 NORTHLAND SUBD PHASE 4 423 16,830 16,407 97% 2601-436-460435-370 GL VILLAGE GREENS PH22C ($5,600) 0 5,233 5,233 100% 2601-436-460435-372 GL VILLAGE GREENS, PH 21 ($11,103. 0 9,412 9,412 100% ------------------------------------------------- TOTAL DEVELOPER TREES 7,178 143,236 136,058 95% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 38 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING DEVELOPMENT SERVICES 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 796,036 750,000 46,036- -6% 2394-000-323103-000 PLUMBING PERMITS 60,202 50,000 10,202- -20% 2394-000-323104-000 MECHANICAL PERMITS 62,874 50,000 12,874- -26% 2394-000-323105-000 ELECTRICAL PERMITS 67,564 90,000 22,436 25% 2394-000-323108-000 PLAN REVIEW FEES 330,986 120,000 210,986- -176% 2394-000-341025-000 MISC. COLLECTIONS/FEES 203 0 203- 0% 2394-000-371010-000 INVESTMENT EARNINGS 7,795 13,000 5,205 40% ------------------------------------------------- TOTAL REVENUE 1,325,658 1,073,000 252,658- -24% ================================================= BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES-BUILDING DEPT. 393,671 577,109 183,438 32% 2394-420-420530-112 SALARIES-SEVERANCE 0 27,993 27,993 100% 2394-420-420530-121 OVERTIME 23,738 20,000 3,738- -19% 2394-420-420530-153 HEALTH INSURANCE 67,191 103,135 35,944 35% 2394-420-420530-155 RETIREMENT 33,845 45,136 11,291 25% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 24,289 25,000 711 3% 2394-420-420530-231 GAS & OIL 3,124 4,000 876 22% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 6,540 6,000 540- -9% 2394-420-420530-323 ST. ED. ASSESSMENTS 6,982 5,500 1,482- -27% 2394-420-420530-345 TELEPHONE & COMMUNICATION 5,477 7,500 2,023 27% 2394-420-420530-353 AUDITING 5,500 5,500 0 0% 2394-420-420530-354 CONTRACT SERVICES 18,163 40,000 21,837 55% 2394-420-420530-355 CITY WORKS LICENSING FEE 23,562 18,500 5,062- -27% 2394-420-420530-356 ArcGIS SERVER UPGRADE LICENSE 8,036 6,000 2,036- -34% 2394-420-420530-357 CREDIT CARD / PAYPAL FEES 14,938 12,500 2,438- -20% 2394-420-420530-360 FURNITURE 803 7,500 6,697 89% 2394-420-420530-373 DUES & TRAINING 14,297 30,000 15,703 52% 2394-420-420530-510 PROPERTY INSURANCE 10,692 10,692 0 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 2,129 2,766 637 23% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 26,317 35,089 8,772 25% 2394-420-420530-528 INFORMATION TECHNOLOGY TRANSFER 99,206 132,274 33,068 25% 2394-420-420530-944 VEHICLE (FY22) 0 37,500 37,500 100% ------------------------------------------------- TOTAL BUILDING DEPT. 788,498 1,159,694 371,196 32% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 39 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2188 WESTSIDE TIF REVENUE 2188-000-364030-000 MISC REVENUE 4,322 0 4,322- 0% 2188-000-371010-000 INVESTMENT EARNINGS 2,940 2,300 640- -28% 2188-000-373010-000 INTEREST / LOANS 10,500 14,005 3,505 25% 2188-000-373020-000 PRINCIPAL / LOANS 14,457 19,271 4,815 25% 2188-000-381060-000 TRANSFER FROM GENERAL FUND 675,000 900,000 225,000 25% 2188-000-383001-000 TRANSFER FROM CD PROJECTS (2886) 828,135 828,135 0 0% 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 105,000 140,000 35,000 25% 2188-000-383005-000 TRANSFER FROM DEBT SERVICE (3188) 675,000 900,000 225,000 25% ------------------------------------------------- TOTAL REVENUE 4,961,689 5,704,641 742,952 13% ================================================= EXPENDITURES 2188-480-470230-110 SALARIES 39,450 55,708 16,258 29% 2188-480-470230-153 HEALTH INSURANCE 6,861 10,556 3,695 35% 2188-480-470230-155 RETIREMENT 3,244 4,493 1,249 28% 2188-480-470230-353 AUDIT 1,500 1,500 0 0% 2188-480-470230-356 TELEPHONE 160 192 32 17% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 1,440 1,920 480 25% 2188-480-470440-930 CITY MATCH - TRAIL 2,941,055 4,443,135 1,502,080 34% ------------------------------------------------- TOTAL WESTSIDE TIF 2,993,710 4,517,504 1,523,794 34% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 40 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2185 AIRPORT TIF 2185-000-430300-840 REDEVELOPMENT ACTIVITY 22,646 240,459 217,813 91% ------------------------------------------------- TOTAL 2185 AIRPORT TIF 22,646 240,459 217,813 91% ================================================= OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 9,300 9,300 100% 2310-480-470210-356 FED-EX REIMBURSEMENT 8,507 8,862 355 4% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 37,500 50,000 12,500 25% 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 6,000 8,000 2,000 25% ------------------------------------------------- TOTAL OLD SCHOOL TIFS 52,007 76,162 24,155 32% ================================================= GLACIER RAIL PARK TEDD 2312-470-470210-810 TRANSFER - WESTSIDE TIF 105,000 140,000 35,000 25% 2312-480-470210-110 SALARIES & WAGES 18,654 26,594 7,940 30% 2312-480-470210-153 HEALTH INSURANCE 4,055 6,234 2,179 35% 2312-480-470210-155 RETIREMENT 1,533 2,164 631 29% 2312-480-470210-345 TELEPHONE 40 48 8 17% 2312-480-470210-353 AUDIT 1,500 1,500 0 0% 2312-480-470210-522 ADMINISTRATIVE TRANSFER 1,440 1,920 480 25% 2312-480-470210-790 REDEVELOPMENT - WEST SIDE TIF REIMB 29,063 0 29,063- 0% 2312-480-470210-795 REDEVELOPMENT / FCEDA REIMB 0 60,000 60,000 100% ------------------------------------------------- TOTAL GLACIER RAIL PARK TEDD 161,286 238,460 77,174 32% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 41 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-470-470210-810 TRANSFER - WESTSIDE TIF 225,000 225,000 0 0% 2880-480-470210-353 AUDITING 1,000 1,000 0 0% 2880-480-470210-354 CONTRACT SERVICES 908 1,000 92 9% ------------------------------------------------- TOTAL LOAN REVOLVING 226,908 227,000 92 0% ================================================= 2881 CD LOAN REV. #2 2881-470-470210-810 TRANSFER - WESTSIDE TIF 300,000 300,000 0 0% 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 405 405 0 0% ------------------------------------------------- TOTAL 2881 CD REV. #2 300,405 300,405 0 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 828,135 828,135 0 0% ------------------------------------------------- TOTAL CD MISC. 852,054 828,135 23,919- -3% ================================================= 2887 RURAL DEVELOPMENT #1 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 19,204 19,204 0- 0% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 2,870 2,870 0 0% 2887-480-470210-750 REDEVELOPMENT LOANS 115 150,000 149,885 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #1 22,189 172,074 149,885 87% ================================================= 2888 RURAL DEVELOPMENT #2 2888-480-470210-354 CONT SERV (LOAN SOFTWARE) 500 500 0 0% 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 8,553 8,553 0 0% 2888-480-470210-620 INTEREST EXPENSE-USDA LOAN 61-03 1,472 1,472 0- -0% 2888-480-470210-750 REDEVELOPMENT LOANS 0 299,500 299,500 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #2 10,525 310,025 299,500 97% ================================================= THE CITY OF KALISPELL, MONTANA04.08.2022 10:07 gb8501_pg.php/Job No: 76873 Page 42 of 42 USER: RGW FY22 FINANCIAL REPORT FY22 THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2022 / 3 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 182 10,102 9,920 98% 2953-480-470215-373 TRAVEL/HAZARDOUS 160 5,382 5,222 97% ------------------------------------------------- TOTAL EPA BROWNSFIELD 342 15,484 15,142 98% ================================================= 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES-PETROLEUM 0 218,322 218,322 100% 2955-480-470210-725 REVOLVED FUNDS-PETROLEUM 0 100,500 100,500 100% 2955-480-470215-229 SUPPLIES-HAZARDOUS SUBSTANCES 0 267,673 267,673 100% ------------------------------------------------- TOTAL BROWNFIELDS LOAN REV. 0 586,495 586,495 100% ================================================= FY21 AIRPORT GRANT 2974-430-430310-934 CAPITAL IMPROVEMENTS - LIGHTS/FENCI 0 236,712 236,712 100% ------------------------------------------------- TOTAL 2974 FY21 AIRPORT GRANT 0 236,712 236,712 100% ================================================= 2991 TIGER GRANT 2991-480-470245-790 REDEVELOPMENT - TRAIL 2,704,867 2,705,046 179 0% ------------------------------------------------- TOTAL TIGER GRANT 2,704,867 2,941,758 236,891 8% =================================================