Loading...
10-19-20 City Manager Report1 City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 10/16/2020 1. Planning Department The Planning Board held a public hearing on October 13 and heard four application requests. The application requests consisted of the following: 1. File #KPUD-20-02 – A request from Hammerquist and Caselegno, LLC for a Commercial Planned Unit Development (“PUD”) overlay on two lots containing approximately 2.6 acres of land located at 145 and 151 Snowline Lane. The lots are currently vacant and zoned B-5 (Industrial-Business). The intent would be to use the rear parcel for a construction laydown yard and later develop the front parcel. The property has a PUD placeholder designation, which means that, with limited exceptions, any use or development of the property requires a full PUD submittal. 2. File #KPP-20-03 – A request from Meadows Edge, LLC, for preliminary plat approval for Meadows Edge Phases 2 and 5. Both phases are part of the Meadows Edge Planned Unit Development (“PUD”). Phase 2 includes 37 residential lots, open space, and streets on a total of 10.2 acres zoned R-3 (Residential) with the PUD overlay. Phase 5 consists of one mixed use commercial lot on 3.25 acres zoned B-1 (Neighborhood Business) with the PUD overlay. The overall PUD plan provides for 322 residential lots and mixed-use commercial areas on a total of 112.7 acres. It is located at 1120 Farm to Market Road. 3. File #KZTA-20-01 – A request from the Flathead Warming Center for a zoning text amendment to allow homeless shelters as a conditionally permitted use in the B-1 (Neighborhood Business) zone. The proposed amendment would add homeless shelters as Section 27.12.030(8) and the corresponding table in Appendix B, as well as renumbering the subsequent subsections accordingly. 4. File #KCU-20-05 – A request from the Flathead Warming Center for a conditional use permit for a homeless shelter to be located at 889 North Meridian. The property is zoned B-1 (Neighborhood Business). The facility would be located within an existing building on the property and have a new fenced courtyard. It is intended to operate primarily in colder months from October through April with approximately 40 guests per night. 2 The Board recommended approval of the four of the application requests and their recommendations will be forwarded to the Council for consideration at the November 2 meeting. 2. Building Department In the last 2 weeks, we have issued permits for 8 single-family homes, 6 townhomes and 2 duplexes. That will bring the total of new single-family/duplex and townhouse units for the year to 234, compared to 121 last year at this time. There have been 132 multi-family housing units issued so far this year. At the end of 2019, the building department had issued permits for a total of 84 multi-family units. There was a total of 146 combined building and/or fire inspections completed in the last 2 weeks. Residential – 73 Plumbing – 9 Commercial – 20 Mechanical - 10 Electrical – 14 Fire - 20 3. Community Development The South Kalispell TIF Traffic Improvement Project at Airport Road and 18th Street has been focused on getting concrete poured for sidewalks, driveways, curbs and gutters. Concrete work is expected to be completed in the coming week with asphalt to follow in the new parking lots. The project is scheduled for completion by November 10. 4. Parks and Recreation Park crews are winterizing restrooms as temperatures are predicted to dip below 30 in the coming days. Portable restrooms will be placed at Woodland and Lawrence Parks to accommodate the public for the winter. Forestry is currently working on the 500 block of 3rd Avenue East. They recently completed a project along Grandview to allow Public Works to make improvements to the stormwater ditch along the road. Paws to Play will host a volunteer day at the Begg Dog Park on Saturday, October 17 from 10am to 2pm. This will be for general clean-up of the park prior to winter. Our annual two-day Skip Out Camp will operate on October 15-16 at Elrod Elementary School. Participation is down compared to last year. 3 Our 6-week Little Dribblers youth basketball league begins on Saturday, October 17. Like our fall soccer program, participation in Little Dribblers is up significantly this fall with 236 participants registered for the program (compared to 144 last fall). All Pre-K and Kindergarten practices/games will be played at the Russell Elementary Gym and all 1st and 2nd grade practices/games will be held at the Peterson Elementary Gym. KPR’s new activity guide (November 2020 to April 2021) is tentatively scheduled to be published in the Daily Interlake the last week of October. This guide highlights programs such as our Cairo’s Kids Afterschool Program, school break camps, ice skating lessons, and youth sports. We will deliver some of the overrun of the guide (3,500 copies) to local elementary schools and have some available in our office. 5. Police Department Attached is the latest report activity report from law enforcement. The Co-Responder program has made of 80 unique community contacts since the program’s inception. Year to date calls for service are 25,603. This compares with 29,019 in 2019, and 27,515 in 2018. Lt. Venezio will be attending the FBI Command Leadership Institute in West Yellowstone on October 19-23. Command Leadership Institute students will be engaged in such topics as credibility, command discipline and liability, dealing with problem employees, and leading change within an organization. The Command Leadership Institute is student-centered with a high degree of student involvement. Officer Chad Sweigart will be attending Field Training Officer Training in Missoula October 19-23. The Course Objectives are Key Elements of the Successful Field Training Programs, The Evaluation Process-Achieving Objectivity and Compliance, Role of Supervision/Management, Documentation-Describing Behavior in a Written Format, Instructional Techniques and Laws of Learning, Utilizing Adult Learning Strategies, Remediation, Interpersonal Communication, Revisiting Motivation, Educational and Behavioral Psychology, Legal, Ethical and Due Process Issues and Termination. 6. Public Works WWTP Bio-cell Conduit and Wire Repairs As part of the 2007-2009 WWTP construction, conduits with wires were installed to support aeration operations of the Bio-cells. This wiring supports operational controls for the Hach dissolved oxygen (DO) probes and all the aeration actuators on Bio-cells 1 to 4 11. The operational controls are a critical component used to ensure optimum oxygen is delivered to the microbes for the treatment process. Over the years, the ground disturbed by construction has been settling. This year, the settling broke the rusted conduit and grounded out some of the controls. An internal project was recently completed which replaced the rusted pull box, replaced all the conduit with PVC pipe, and installed slip joints to handle the soil movements. Additionally, new wiring was installed from the Blower Building to the aeration Actuators in Bio Cells #8 thru #11. Leaf Collection Season Public Works will start leaf collection beginning October 15 and will cease collection efforts on November 20. The leaf collection season is instituted to promote effective and efficient leaf collection services prior to the onset of the winter snow season. Due to the unpredictable leaf volumes and weather conditions, it is difficult to maintain an exact schedule for when areas throughout the City will receive collection. Nevertheless, this year Public Work’s is going to provide a weekday collection schedule for designated areas throughout Kalispell. An interactive Leaf Collection map is available on the City’s website at www.kalispell.com/265/Leaf-Removal and provides information on weekday collection areas. This map allows customers the ability to search their address and determine their area’s leaf collection day. Residents and business owners are encouraged to rake the leaves from the boulevard into the street approximately two feet away from the curb. In order to not miss collection, Residents should rake their leaves past the curb by the start of their scheduled weekday. Rocks, dirt, cans, bottles, branches, and items of this nature should not be placed in the leaf piles, because they may cause bodily injury and damage to machinery. Crews will make every effort to collect leaves as outlined in the designated areas. Please note, the leaf collection schedule is a guideline to establish some predictability for residential collection days. However, collection in designated areas outside of the schedule days may occur at the discretion of Public Works. Everyone is encouraged to contact Public Works for leaf collection questions or visit us on our website www.kalispell.com. 5 7. Finance Department Certified Annual Financial Report For the 10th consecutive fiscal year, the City of Kalispell has been presented the Certificate of Achievement in Financial Reporting by the Government Finance Officers Association of the United States and Canada (GFOA) for the fiscal year 2019 comprehensive annual financial report (CAFR). The CAFR has been judged by an impartial panel to meet the high standards of the program including demonstrating a constructive “spirit of full disclosure” to clearly communicate its financial story and motivate potential users and user groups to read the CAFR. The Certificate of Achievement is the highest form of recognition in the area of governmental accounting and financial reporting, and its attainment represents a significant accomplishment by a government and its management. In addition, the finance department received an Award of Financial Reporting Achievement as the department primarily responsible for preparing the award-winning CAFR. 6 Audit The finance department is working on the City’s fiscal year 2020 Certified Annual Financial Report (CAFR) and preparing for the annual audit. The auditors are scheduled to be in City Hall to perform the on-site portion of the audit the week of November 2. First Quarter Finance Report Attached, please find the printouts reflecting the activity for the 1st quarter of the fiscal year 2021. This printout reflects payroll thru Sept. 26th, six full pay periods and approximately 1/4 of a seventh, for biweekly employees. For fire and ambulance, this printout reflects payroll paid thru Sept. 12, two full 28 day pay periods and another 18 days. Expenditures/expenses are included for all funds, with the exception of debt service funds and select special revenue funds. Revenues are excluded from funds which derive all, or the majority of revenue from taxes or assessments. REVENUES: General Fund and parks department revenue has little activity as taxes will not be received until December. The tax receivables have not been booked. Tax bills will go out at the end of October and we will book the receivables (and some revenue) at that time. This applies to the assessed funds as well. The Ambulance Fund 1st quarter fees for services is 20% of the annual budget or $147,599. This is a decrease of about $50,000 when compared to the 1st quarter of fiscal year 2020. First quarter Building Department revenues of $361,551 are 48% of the annual budget. First quarter fiscal year 2020 revenues were just over $200,000. Metered water sales are at 41% compared to 37% for the first quarter of fiscal year 2020. First quarter water sales are usually more than 25% due to summer and early fall sprinkling and irrigation. Sewer metered sales are at 26%, about the same as 1st quarter for the last fiscal year. Water, sewer, treatment, and storm impact fees remain strong in the first quarter and all are well over 50% of the fiscal year 2021 budgeted amount. Treatment impact fees have already eclipsed the budgeted fiscal year 2021 amount of $208,000. Police and fire impact fees were both over 60% of the annual budgeted amount at 77% and 62%, respectively. EXPENDITURES/EXPENSES: At this point in the year, the salary and retirement remaining should be about 76% in most funds (19.75 of 26 pay periods remaining). Some seasonal parks and rec salaries would be an exception. Fire and ambulance should have about 80% remaining in salaries and retirement (10.5 of 13 pay periods remaining). Health insurance reflects 3 months paid and should have at least 75% remaining. With a few exceptions, administrative, central garage, and information technology transfers are done monthly and should show 75% remaining. This is the same on the 7 revenue side for fees for services (Central Garage/Information Technology) and administrative charges (General Fund). The general fund administrative charges may vary slightly as some charges are based on a percentage of revenues collected. Annual budgeted operating transfers are generally done quarterly, depending on cash availability, and should show 75% remaining. The City prepays its annual liability ($367,167) and property insurance ($144,711) in August. This results in general government expenditures and some other funds’ expenses reflecting greater than 25% spent in the 1st quarter. 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 SIWOC/Sexual Assault 2 0 2 0 2 0 6 0 2 0 7 0 4 0 5 0 6 0 36 0 Robbery 0 0 1 0 2 2 0 0 1 0 0 0 0 0 1 0 3 4 8 6 Aggravated Assault 3 0 3 1 2 0 4 2 11 5 5 2 5 5 9 6 3 2 45 23 Assault on a Peace Officer 0 0 0 0 0 0 0 0 1 1 2 2 1 1 1 1 0 0 5 5 Simple Assault 9 3 6 3 5 3 3 2 10 6 12 6 10 4 7 3 7 6 69 36 PFMA 16 12 12 7 12 7 8 4 10 7 9 6 19 10 17 12 10 9 113 74 Resisting Arrest 0 0 0 3 2 3 0 0 2 1 2 1 2 3 1 0 1 0 10 11 Crimes Against Property Burglary 5 2 1 0 4 0 0 0 6 3 3 0 7 1 2 0 7 1 35 7 Theft 53 19 43 21 39 13 32 15 42 14 35 4 69 12 55 17 38 10 406 125 Vehicle Theft/Unauth Use 5 1 6 2 3 0 3 0 5 1 1 0 9 3 3 1 8 0 43 8 Arson 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 Forgery/Counterfeit 5 1 4 0 4 1 1 0 1 2 3 0 5 1 2 0 0 0 25 5 Fraud 10 1 6 0 6 1 2 0 5 1 9 2 2 0 6 2 0 0 46 7 Theft of Identity 5 0 1 0 1 0 0 0 1 0 1 0 0 0 0 0 3 0 12 0 Embezzlement 0 1 2 0 0 1 0 1 0 0 1 1 1 0 0 0 1 0 5 4 Stolen Property offenses 2 0 0 0 1 0 1 0 1 0 3 3 1 0 1 0 0 0 10 3 Criminal Mischief 17 3 18 10 14 1 17 4 20 6 16 4 9 3 19 2 18 5 148 38 Crimes Against Society Weapon Law Violations 1 1 0 0 0 0 0 0 0 0 0 0 2 0 1 0 0 0 4 1 Prostitution Offenses 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 Child Pornography 2 0 2 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 6 0 Drug Offenses 29 13 38 26 27 22 18 10 37 14 22 21 24 9 26 9 9 14 230 138 Family Offenses (non-violent)0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 2 0 3 0 DUI 8 8 8 8 6 6 6 6 8 7 12 11 12 10 3 3 7 7 70 66 Possession of Alcohol 1 4 2 3 1 2 3 9 1 1 3 4 4 3 3 3 3 1 21 30 Provide Alcohol to Minor 1 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 2 1 Other Alcohol Offenses 0 0 0 0 1 1 0 0 1 1 0 0 2 2 0 0 0 0 4 4 Kidnapping/Custodial Int.2 2 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1 1 4 4 Disorderly Conduct 7 7 13 9 6 5 15 9 11 8 11 10 18 12 7 5 11 10 99 75 Criminal Trespass 13 11 17 14 10 7 6 5 11 7 10 3 18 12 13 6 10 5 108 70 Violation of Protective Order 6 2 1 0 1 2 1 0 0 0 4 1 4 1 2 2 5 2 24 10 Obstructing a peace officer 7 8 9 7 9 10 3 3 8 6 5 1 9 7 7 5 5 4 62 51 Juvenile Offenses (except MIP)6 3 11 7 6 3 2 1 1 1 1 1 4 4 2 1 2 0 35 21 Other Offenses 43 39 52 48 30 31 13 12 32 29 30 27 40 38 21 23 22 19 283 266 Total 258 141 258 169 195 121 145 83 228 121 210 111 283 142 214 101 182 100 0 0 0 0 0 0 1973 1089 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 744 499 807 527 412 338 234 262 455 356 425 365 381 354 240 284 324 322 4022 3307 Total Calls for Service 2813 2438631002649273129762840245521052717 Kalispell Police Department Case and Arrest Reports - 2020 January February March April May June July August September October November December Totals THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 1 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 104,589 6,463,000 6,358,412 98% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 0 18,156 18,156 100% 1000-000-311200-000 PERSONAL PROPERTY TAXES 152,375 200,000 47,625 24% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 5,009 9,000 3,991 44% 1000-000-322101-000 LIQUOR LICENSES 286 33,000 32,714 99% 1000-000-322300-000 BUSINESS LICENSES 78 1,500 1,422 95% 1000-000-323012-000 PLANNING FEES 19,313 60,000 40,687 68% 1000-000-323109-000 SITE REVIEW 9,321 15,000 5,679 38% 1000-000-323200-000 PARADE PERMITS 0 1,000 1,000 100% 1000-000-331023-000 MRVCTF 91 0 91- 0% 1000-000-331112-000 KPD - SAFE STREET TASK FORCE 0 8,000 8,000 100% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 1,200 1,200 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 0 60,000 60,000 100% 1000-000-335110-000 LIVE CARD TABLE PERMIT 0 1,400 1,400 100% 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 755,973 3,023,892 2,267,919 75% 1000-000-341020-000 ADMINISTRATIVE CHARGES 153,003 613,512 460,509 75% 1000-000-341021-000 GRANT ADMIN FEES 762 25,000 24,238 97% 1000-000-341025-000 CITY COLLECTIONS 322 5,000 4,678 94% 1000-000-342010-000 POLICE SERVICES 9,315 29,000 19,685 68% 1000-000-342014-000 RESOURCE OFFICERS 224,435 224,435 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 800 14,500 13,700 94% 1000-000-343018-000 PARKING PERMITS 23,746 95,000 71,254 75% 1000-000-343062-000 AIRPORT FUEL TAXES 1,350 4,000 2,650 66% 1000-000-343063-000 AIRPORT GROUND LEASE (HILTON) 15,301 14,500 801- -6% 1000-000-351000-000 CITY COURT FINES & FEES 68,513 450,000 381,487 85% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 4,164 30,000 25,836 86% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 8,293 55,000 46,708 85% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 0 20,000 20,000 100% 1000-000-362020-000 MMIA GASB 54 REIMBURSEMENT 59,043 78,500 19,457 25% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 0 10,000 10,000 100% 1000-000-371010-000 INVESTMENT EARNINGS 14,587 36,000 21,413 59% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 0 970,000 970,000 100% ------------------------------------------------- TOTAL GENERAL FUND REVENUE 1,630,667 12,569,595 10,938,928 87% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 2 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 0 3,030 3,030 100% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 1,500 13,750 12,250 89% 1000-400-410530-354 OPEB EXPENSE 1,500 1,500 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 2,696 3,500 804 23% 1000-400-410560-312 POSTAGE 5,279 16,000 10,721 67% 1000-400-410560-320 PRINTING & ENVELOPES 0 5,500 5,500 100% 1000-400-410560-354 CONTRACT SERVICES - DOC. SHREDDING 48 1,400 1,353 97% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 567 3,000 2,433 81% 1000-400-420000-354 CONTRACT 911 CENTER 139,014 557,482 418,468 75% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 0 350 350 100% 1000-400-430300-355 AIRPORT REIMBURSEMENT 0 19,000 19,000 100% 1000-400-460000-820 TFR TO WESTSIDE TIF (CORE AREA) 31,150 1,246,000 1,214,850 98% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 0 15,000 15,000 100% 1000-400-460452-366 HOCKADAY MAINTENANCE 0 6,600 6,600 100% 1000-400-510300-000 CONTINGENCY 5,000 105,000 100,000 95% 1000-400-510310-354 ICMA PLAN FEES 125 500 375 75% 1000-400-510330-513 LIABILITY INSURANCE 186,790 186,790 0 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 24,642 60,000 35,358 59% 1000-400-510330-517 PROPERTY INSURANCE 59,654 59,654 0- 0% ------------------------------------------------- SUBTOTAL GEN.GOV'T. 457,964 2,304,056 1,846,092 80% CITY MANAGER 1000-401-410210-110 SALARIES-CITY MANAGER'S OFFICE 36,811 155,616 118,805 76% 1000-401-410210-153 HEALTH INSURANCE 6,811 25,078 18,267 73% 1000-401-410210-155 RETIREMENT 3,893 16,536 12,643 76% 1000-401-410210-210 SUPPLIES 0 1,000 1,000 100% 1000-401-410210-312 NEWSLETTER/BOOKS 0 400 400 100% 1000-401-410210-345 TELEPHONE & COMMUNICATION 280 1,200 920 77% 1000-401-410210-373 DUES & TRAINING 1,162 12,000 10,838 90% 1000-401-410210-379 MEETINGS 616 6,500 5,884 91% ------------------------------------------------- SUBTOTAL CITY MANAGER 49,573 218,330 168,757 77% HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 29,930 127,530 97,600 77% 1000-401-410830-153 HEALTH INSURANCE 5,122 23,920 18,798 79% 1000-401-410830-155 RETIREMENT 2,430 10,202 7,772 76% 1000-401-410830-210 OFFICE SUPPLIES 489 900 411 46% 1000-401-410830-338 RECRUITMENT/RELOCATION 4,450 20,000 15,550 78% 1000-401-410830-354 CONTRACT SERVICES 160 1,500 1,340 89% 1000-401-410830-373 DUES & TRAINING 634 7,500 6,867 92% ------------------------------------------------- SUBTOTAL HUMAN RESOURCES 43,214 191,552 148,338 77% THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 3 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 15,157 63,087 47,930 76% 1000-402-410100-153 HEALTH INSURANCE 12,375 50,783 38,408 76% 1000-402-410100-155 RETIREMENT 630 2,587 1,957 76% 1000-402-410100-210 OFFICE SUPPLIES 0 6,500 6,500 100% 1000-402-410100-335 MT LEAGUE OF CITIES 150 2,000 1,850 93% 1000-402-410100-354 CONTRACT SERVICES 530 5,500 4,970 90% 1000-402-410100-373 DUES & TRAINING 9,089 11,500 2,411 21% 1000-402-410100-379 MEETINGS 0 22,000 22,000 100% ------------------------------------------------- SUBTOTAL MAYOR/COUNCIL 37,932 163,957 126,025 77% CITY CLERK 1000-402-410150-110 SALARIES-CITY CLERK 24,327 101,094 76,767 76% 1000-402-410150-121 OVERTIME 0 250 250 100% 1000-402-410150-153 HEALTH INSURANCE 5,986 22,168 16,182 73% 1000-402-410150-155 RETIREMENT 1,977 8,138 6,161 76% 1000-402-410150-210 OFFICE SUPPLIES 0 300 300 100% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 502 600 98 16% 1000-402-410150-345 TELEPHONE & COMMUNICATION 175 480 305 64% 1000-402-410150-352 CODIFICATION 0 4,100 4,100 100% 1000-402-410150-354 CONTRACT SERVICES 0 300 300 100% 1000-402-410150-373 DUES & TRAINING 204 6,200 5,996 97% ------------------------------------------------- SUBTOTAL CITY CLERK 33,171 143,630 110,459 77% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES-FINANCE OFFICE 52,989 217,352 164,363 76% 1000-403-410550-121 OVERTIME 0 500 500 100% 1000-403-410550-153 HEALTH INSURANCE 10,624 42,148 31,524 75% 1000-403-410550-155 RETIREMENT 4,267 17,434 13,167 76% 1000-403-410550-210 SUPPLIES 63 800 737 92% 1000-403-410550-322 BOOKS 0 500 500 100% 1000-403-410550-353 CONTRACT SERVICES 0 350 350 100% 1000-403-410550-354 CONTRACT-GRIZZLY SECURITY 0 900 900 100% 1000-403-410550-355 BANK CHARGES & FEES 815 3,200 2,385 75% 1000-403-410550-373 DUES & TRAINING 605 8,500 7,895 93% ------------------------------------------------- SUBTOTAL FINANCE 69,364 291,684 222,320 76% THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 4 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CITY ATTORNEY 1000-404-411110-110 SALARIES-CITY ATTORNEY'S 114,178 476,010 361,832 76% 1000-404-411110-153 HEALTH INSURANCE 23,649 82,216 58,567 71% 1000-404-411110-155 RETIREMENT 9,291 38,314 29,023 76% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 3,324 2,500 824- -33% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 5,990 25,000 19,010 76% 1000-404-411110-345 TELEPHONE & COMMUNICATION 197 1,000 803 80% 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 21 10,000 9,979 100% 1000-404-411110-373 DUES & TRAINING 1,530 6,500 4,970 76% ------------------------------------------------- SUBTOTAL CITY ATTORNEY 158,180 641,540 483,360 75% MUNICIPAL COURT 1000-406-410360-110 SALARIES-COURT 55,786 236,239 180,453 76% 1000-406-410360-121 OVERTIME 0 3,500 3,500 100% 1000-406-410360-153 HEALTH INSURANCE 12,594 47,494 34,900 73% 1000-406-410360-155 RETIREMENT 4,517 18,961 14,444 76% 1000-406-410360-210 SUPPLIES 259 4,500 4,241 94% 1000-406-410360-320 PRINTING/BOOKS 789 1,500 711 47% 1000-406-410360-345 TELEPHONE & COMMUNICATION 28 1,000 972 97% 1000-406-410360-353 SECURITY & TECHNOLOGY 642 40,000 39,358 98% 1000-406-410360-354 CONTRACT SERVICES 1,371 6,250 4,879 78% 1000-406-410360-373 DUES & TRAINING 105 10,000 9,895 99% 1000-406-410360-394 JURY & WITNESS FEES 657 7,500 6,843 91% ------------------------------------------------- SUBTOTAL COURT 76,749 376,944 300,195 80% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES-PUBLIC WORKS 4,736 19,689 14,953 76% 1000-410-430100-153 HEALTH INSURANCE 945 3,806 2,861 75% 1000-410-430100-155 RETIREMENT 380 1,550 1,170 75% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 5,832 14,500 8,668 60% 1000-410-430100-231 GAS 666 3,000 2,334 78% 1000-410-430100-345 TELEPHONE & COMMUNICATION 78 350 272 78% 1000-410-430100-354 CONTRACT SERVICES 100 2,000 1,900 95% 1000-410-430100-373 DUES & TRAINING 248 4,500 4,252 94% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 1,054 4,217 3,163 75% ------------------------------------------------- SUBTOTAL PUBLIC WORKS ADMIN 14,039 53,612 39,573 74% CITY HALL MAINT. 1000-412-411230-110 SALARIES-CITY HALL 16,387 68,986 52,599 76% 1000-412-411230-153 HEALTH INSURANCE 3,993 14,718 10,725 73% 1000-412-411230-155 RETIREMENT 1,281 5,307 4,026 76% 1000-412-411230-220 SECURITY IMPROVEMENTS 1,347 6,793 5,446 80% 1000-412-411230-224 JANITORIAL SUPPLIES 1,858 6,800 4,942 73% 1000-412-411230-241 TOOLS & SUPPLIES 0 1,500 1,500 100% 1000-412-411230-341 ELECTRICITY 14,063 45,000 30,937 69% 1000-412-411230-344 NATURAL GAS 3,943 32,000 28,057 88% 1000-412-411230-345 TELEPHONE & COMMUNICATION 112 400 288 72% 1000-412-411230-354 CONTRACT SERVICES 2,874 25,000 22,126 89% THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 5 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-355 HVAC MAINTENANCE CONTRACT 17,380 16,500 880- -5% 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 675 6,000 5,325 89% 1000-412-411230-362 EQUIPMENT MAINTENANCE 961 10,000 9,039 90% 1000-412-411230-366 BUILDING MAINTENANCE 269 41,150 40,881 99% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 141 3,700 3,559 96% ------------------------------------------------- SUBTOTAL CITY HALL 65,284 283,854 218,570 77% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES-PLANNING & ZONING 56,430 224,538 168,108 75% 1000-420-411020-153 HEALTH INSURANCE 12,214 49,800 37,586 75% 1000-420-411020-155 RETIREMENT 4,402 18,081 13,679 76% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 3,375 4,000 625 16% 1000-420-411020-231 GAS 33 400 367 92% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 53 2,200 2,147 98% 1000-420-411020-345 TELEPHONE 155 1,000 845 84% 1000-420-411020-354 CONTRACT SERVICES 0 5,500 5,500 100% 1000-420-411020-373 DUES & TRAINING 240 7,500 7,260 97% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 77 308 231 75% ------------------------------------------------- SUBTOTAL PLANNING DEPT. 76,978 313,327 236,349 75% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 16,899 71,468 54,569 76% 1000-480-470210-153 HEALTH INSURANCE 4,527 16,750 12,223 73% 1000-480-470210-155 RETIREMENT 1,379 5,716 4,337 76% 1000-480-470210-210 OFFICE SUPPLIES 608 1,600 992 62% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 0 500 500 100% 1000-480-470210-312 POSTAGE & PRINTING 0 300 300 100% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 0 500 500 100% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 177 450 273 61% 1000-480-470210-354 CONTRACT SERVICES 84 250 166 66% 1000-480-470210-373 DUES & TRAINING 945 5,000 4,055 81% 1000-480-470210-379 MEETINGS 20 750 730 97% ------------------------------------------------- SUBTOTAL COMMUNITY DEVELOPMENT 24,639 103,284 78,645 76% THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 6 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES-POLICE 601,445 2,558,903 1,957,458 77% 1000-413-420140-112 SALARIES-SEVERANCE 0 40,000 40,000 100% 1000-413-420140-114 SALARY -comptime buyout 10,203 11,500 1,297 11% 1000-413-420140-121 OVERTIME (REG & AET OT) 30,260 80,000 49,740 62% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 3,430 35,000 31,570 90% 1000-413-420140-153 HEALTH INSURANCE 121,708 512,582 390,874 76% 1000-413-420140-155 RETIREMENT 73,523 336,010 262,487 78% 1000-413-420140-210 OFFICE SUPPLIES 613 3,500 2,887 82% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 565 27,000 26,435 98% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 17,339 32,560 15,221 47% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 2,309 3,760 1,451 39% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 1,610 11,500 9,890 86% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 0 1,500 1,500 100% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 268 10,000 9,732 97% 1000-413-420140-227 AMMO & RELATED SUPPLIES 135 33,800 33,665 100% 1000-413-420140-228 PATROL CAR SUPPLIES 2,052 17,500 15,448 88% 1000-413-420140-229 OTHER SUPPLIES 813 5,000 4,187 84% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 216 1,000 784 78% 1000-413-420140-231 GAS 12,107 85,000 72,893 86% 1000-413-420140-234 CRISIS NEGOTIATIONS 0 500 500 100% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 0 1,500 1,500 100% 1000-413-420140-320 PRINTING 433 5,500 5,067 92% 1000-413-420140-345 TELEPHONE & COMMUNICATION 5,293 21,000 15,707 75% 1000-413-420140-354 CONTRACT SERVICES 32,211 35,800 3,589 10% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 500 6,500 6,000 92% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 300 2,100 1,800 86% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 359 2,000 1,641 82% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 31,029 59,240 28,211 48% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 761 2,800 2,039 73% 1000-413-420140-373 DUES & TRAINING 13,523 55,000 41,477 75% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 318 14,500 14,182 98% 1000-413-420140-380 TRAINING MATERIALS 0 5,000 5,000 100% 1000-413-420140-388 MEDICAL SERVICES 1,449 3,000 1,551 52% 1000-413-420140-392 BOARDING/TREATING PRISONERS 258 2,500 2,243 90% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 22,124 88,496 66,372 75% 1000-413-420140-530 RENT 1,800 7,200 5,400 75% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 16,000 64,000 48,000 75% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 1,500 6,000 4,500 75% 1000-413-420140-944 VEHICLES 20,221 77,000 56,779 74% ------------------------------------------------- SUBTOTAL POLICE DEPT. 1,026,677 4,265,751 3,239,074 76% DETECTIVES 1000-413-420141-110 SALARIES-DETECTIVES 95,260 400,261 305,001 76% 1000-413-420141-121 DETECTIVE-OVERTIME 3,838 15,000 11,162 74% 1000-413-420141-123 OVERTIME (SAFE NEIGHBORHOOD TASK FO 0 8,000 8,000 100% 1000-413-420141-153 HEALTH INSURANCE 24,172 95,807 71,635 75% 1000-413-420141-155 DETECTIVE-RETIREMENT 12,505 53,729 41,224 77% ------------------------------------------------- TOTAL DETECTIVES 135,775 572,797 437,022 76% RECORDS 1000-413-420142-110 SALARIES-RECORDS DIVISION 35,202 152,955 117,753 77% THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 7 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-121 OVERTIME 2,877 7,500 4,623 62% 1000-413-420142-153 HEALTH INSURANCE 9,900 37,444 27,544 74% 1000-413-420142-155 RETIREMENT 3,063 12,242 9,179 75% ------------------------------------------------- TOTAL RECORDS 51,042 210,141 159,099 76% RESOURCE OFFICERS 1000-413-420144-110 SALARIES-SRO 68,406 281,666 213,260 76% 1000-413-420144-153 HEALTH INSURANCE 17,058 56,050 38,992 70% 1000-413-420144-155 SRO RETIREMENT 8,969 37,912 28,943 76% ------------------------------------------------- TOTAL RESOURCE OFFICERS 94,432 375,628 281,196 75% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL-SALARIES 11,434 46,291 34,857 75% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 2,475 9,111 6,636 73% 1000-413-420145-155 RETIREMENT 852 3,565 2,713 76% ------------------------------------------------- SUBTOTAL ANIMAL CONTROL 14,761 59,467 44,706 75% PARKING 1000-413-420147-110 PARKINGS -SALARIES 20,802 85,511 64,709 76% 1000-413-420147-153 HEALTH INSURANCE 9,054 33,500 24,446 73% 1000-413-420147-155 RETIREMENT 1,630 6,840 5,210 76% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 274 4,000 3,726 93% 1000-413-420147-354 CONTRACTED SERVICES 55 2,000 1,945 97% 1000-413-420147-362 LOT MAINT 263 10,000 9,737 97% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 0 17,500 17,500 100% 1000-413-420147-550 LOT LEASE PAYMENTS 255 1,500 1,245 83% ------------------------------------------------- SUBTOTAL PARKING 32,332 160,851 128,519 80% ------------------------------------------------- SUBTOTAL POLICE DEPT. 1,355,019 5,644,635 4,289,616 76% THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 8 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES-FIRE SUPPRESSION 309,265 1,913,898 1,604,633 84% 1000-416-420400-112 SALARY-SEVERANCE 11,382 54,361 42,979 79% 1000-416-420400-114 COMPTIME BUYOUT 0 5,500 5,500 100% 1000-416-420400-115 OUT OF RANK PAY 2,661 12,500 9,839 79% 1000-416-420400-121 OVERTIME 46,884 40,000 6,884- -17% 1000-416-420400-153 HEALTH INSURANCE 73,896 348,552 274,656 79% 1000-416-420400-155 RETIREMENT 42,839 250,532 207,693 83% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 74 3,000 2,926 98% 1000-416-420400-218 Equipment (Non Capital) 2,522 21,500 18,978 88% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 1,454 15,000 13,546 90% 1000-416-420400-224 JANITORIAL SUPPLIES 678 5,000 4,322 86% 1000-416-420400-231 GAS 1,871 17,325 15,454 89% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 2,912 15,750 12,838 82% 1000-416-420400-320 PRINTING 0 200 200 100% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 0 1,250 1,250 100% 1000-416-420400-345 TELEPHONE & COMMUNICATION 793 6,000 5,207 87% 1000-416-420400-354 CONTRACT SERVICES 6,478 17,460 10,982 63% 1000-416-420400-362 EQUIPMENT MAINTENANCE 2,656 5,500 2,844 52% 1000-416-420400-366 BUILDING MAINTENANCE-STATION 62 970 7,500 6,530 87% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 360 5,000 4,640 93% 1000-416-420400-373 DUES & TRAINING 2,669 10,000 7,331 73% 1000-416-420400-388 FIREFIGHTER PHYSICALS 0 29,000 29,000 100% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 7,171 28,684 21,513 75% 1000-416-420400-610 DEBT RETIREMENT-FIRE TRUCK 22,068 44,387 22,319 50% 1000-416-420400-620 INTEREST EXPENSE-FIRE TRUCK 1,944 9,776 7,832 80% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 87,500 350,000 262,500 75% 1000-416-420400-821 TFR - 2956 AFG ($31,591)/2995 SAFAR 0 56,591 56,591 100% 1000-416-420440-110 SALARIES-FIRE PREVENTION 5,110 22,115 17,005 77% 1000-416-420440-153 HEALTH INSURANCE 1,553 5,736 4,183 73% 1000-416-420440-155 RETIREMENT 399 1,681 1,282 76% ------------------------------------------------- SUBTOTAL FIRE DEPT. 636,110 3,303,798 2,667,688 81% ------------------------------------------------- GRAND TOTAL GENERAL FUND 3,098,215 14,034,203 10,935,988 78% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 9 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SPECIAL REVENUE FUNDS: 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 16,558 1,065,000 1,048,442 98% 2215-000-311200-000 PERSONAL PROPERTY TAXES 24,117 35,000 10,883 31% 2215-000-312000-000 PEN & INTEREST DEL TAXES 769 1,500 731 49% 2215-000-346030-000 SWIMMING POOL FEES 59,014 148,410 89,396 60% 2215-000-346040-000 CONCESSION STAND REVENUE 22,142 37,800 15,658 41% 2215-000-346050-000 PARKS USAGE FEES 5,624 20,000 14,376 72% 2215-000-346051-000 RECREATION FEES 3,924 25,048 21,124 84% 2215-000-346052-000 SPORTS PROGRAMS 22,442 73,577 51,135 70% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 799 2,000 1,201 60% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 8,715 67,500 58,785 87% 2215-000-346055-000 ICE RINK 0 22,000 22,000 100% 2215-000-346056-000 KIDSPORT USAGE 408 4,000 3,592 90% 2215-000-346057-000 YOUTH CAMPS 16,925 179,201 162,276 91% 2215-000-346059-000 PICNIC IN THE PARK 0 26,500 26,500 100% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-371010-000 INVESTMENTS 1,870 6,500 4,630 71% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 0 98,000 98,000 100% ------------------------------------------------- TOTAL PARKS & REC REVENUE 183,306 1,832,036 1,648,730 90% ================================================= PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES-PARKS 74,806 347,866 273,060 79% 2215-436-460430-111 SEASONAL SALARIES 18,124 66,712 48,588 73% 2215-436-460430-121 OVERTIME 0 300 300 100% 2215-436-460430-153 HEALTH INSURANCE 15,701 72,336 56,635 78% 2215-436-460430-155 RETIREMENT 6,918 30,263 23,345 77% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 1,218 4,400 3,182 72% 2215-436-460430-215 EQUIPMENT - not capital 0 3,000 3,000 100% 2215-436-460430-224 JANITORIAL SUPPLIES 1,932 7,000 5,068 72% 2215-436-460430-229 OTHER SUPPLIES 666 10,000 9,334 93% 2215-436-460430-231 GAS 4,087 17,000 12,913 76% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 1,675 4,000 2,325 58% 2215-436-460430-320 PRINTING & ADVERTISING 166 200 34 17% 2215-436-460430-341 ELECTRICITY 4,299 13,500 9,201 68% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 0 22,000 22,000 100% 2215-436-460430-344 NATURAL GAS 158 2,500 2,342 94% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 464 2,800 2,336 83% 2215-436-460430-351 SPORTS COURT & SPORT MAINTENANCE 0 2,000 2,000 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 2,000 2,000 100% 2215-436-460430-355 CONTRACT SERV. TRAIL MAINT/WEED CON 505 18,000 17,495 97% 2215-436-460430-356 TRAIL STUDY 0 30,000 30,000 100% 2215-436-460430-358 FVCC TENNIS INTERLOCAL AGREEMENT 0 7,000 7,000 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 1,803 8,500 6,697 79% 2215-436-460430-364 LANDSCAPING 0 6,100 6,100 100% 2215-436-460430-367 VANDALISM REPAIRS 1,411 4,200 2,789 66% 2215-436-460430-373 DUES & TRAINING 453 8,000 7,548 94% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 0 400 400 100% THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 10 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 0 7,000 7,000 100% 2215-436-460430-440 IRRIGATION SUPPLIES 720 7,500 6,780 90% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 772 2,000 1,228 61% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 9,017 36,067 27,050 75% 2215-436-460430-545 COUNTY LANDFILL 0 6,273 6,273 100% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 29,241 58,859 29,618 50% 2215-436-460430-620 DEBT SERVICE INTEREST 914 6,424 5,510 86% ------------------------------------------------- SUBTOTAL PARKS EXPENDITURES 175,050 814,700 639,650 79% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES-COMPLEX 26,402 112,922 86,520 77% 2215-436-460440-111 SEASONAL SALARIES 14,071 38,917 24,846 64% 2215-436-460440-121 OVERTIME 0 300 300 100% 2215-436-460440-153 HEALTH INSURANCE 8,435 33,161 24,726 75% 2215-436-460440-155 RETIREMENT 3,136 10,318 7,183 70% 2215-436-460440-221 SAFETY EQUIPMENT 0 600 600 100% 2215-436-460440-229 OTHER SUPPLIES 2,990 22,000 19,010 86% 2215-436-460440-231 GAS 2,267 9,000 6,733 75% 2215-436-460440-241 CONSUMABLE TOOLS 0 2,000 2,000 100% 2215-436-460440-341 ELECTRICITY 5,356 9,500 4,144 44% 2215-436-460440-345 TELEPHONE & COMMUNICATION 58 240 182 76% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 184 800 616 77% 2215-436-460440-364 LANDSCAPING 0 500 500 100% 2215-436-460440-367 VANDALISM REPAIRS 0 500 500 100% 2215-436-460440-373 DUES & TRAINING 0 700 700 100% 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 0 200 200 100% 2215-436-460440-395 RENTAL EQUIPMENT 0 200 200 100% 2215-436-460440-420 METAL PRODUCTS 0 4,000 4,000 100% 2215-436-460440-440 IRRIGATION 1,976 7,000 5,024 72% 2215-436-460440-452 SAND & GRAVEL 659 1,500 841 56% 2215-436-460440-521 CENTRAL GARAGE TRANSFER 1,447 5,787 4,340 75% 2215-436-460440-545 COUNTY LANDFILL 0 3,400 3,400 100% ------------------------------------------------- SUBTOTAL ATHLETIC COMPLEX 66,980 264,545 197,565 75% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES-RECREATION 18,519 86,268 67,749 79% 2215-436-460431-111 SEASONAL SALARIES 1,162 12,306 11,144 91% 2215-436-460431-121 OVERTIME 292 0 292- 0% 2215-436-460431-153 HEALTH INSURANCE 4,625 24,380 19,755 81% 2215-436-460431-155 RETIREMENT 1,492 7,789 6,297 81% 2215-436-460431-229 MISC. SUPPLIES 2,611 10,335 7,724 75% 2215-436-460431-231 GAS 36 600 564 94% 2215-436-460431-320 PRINTING & ADVERTISING 84 7,925 7,841 99% 2215-436-460431-345 TELEPHONE & COMMUNICATION 128 675 547 81% 2215-436-460431-354 CONTRACT SERVICES 4,766 37,828 33,062 87% 2215-436-460431-357 MUSIC FRANCHISE FEES 0 1,300 1,300 100% 2215-436-460431-373 DUES & TRAINING 169 800 631 79% ------------------------------------------------- SUBTOTAL RECREATION 33,882 190,206 156,324 82% THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 11 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING YOUTH CAMPS 2215-436-460448-110 SALARIES-YOUTH CAMPS 16,086 76,112 60,026 79% 2215-436-460448-111 SEASONAL SALARIES 66,813 143,522 76,709 53% 2215-436-460448-121 OVERTIME 40 150 110 74% 2215-436-460448-153 HEALTH INSURANCE 4,378 23,469 19,091 81% 2215-436-460448-155 RETIREMENT 1,295 7,029 5,734 82% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 162 250 88 35% 2215-436-460448-229 MISC. SUPPLIES 1,508 3,520 2,012 57% 2215-436-460448-231 GAS 0 200 200 100% 2215-436-460448-320 PRINTING & ADVERTISING 0 375 375 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 285 1,350 1,065 79% 2215-436-460448-354 CONTRACT SERVICES 2,883 13,154 10,271 78% 2215-436-460448-355 AFTER SCHOOL PROGRAM 0 1,200 1,200 100% 2215-436-460448-356 BANK FEES/CC CHARGES 1,159 4,500 3,341 74% 2215-436-460448-373 DUES & TRAINING 169 800 631 79% ------------------------------------------------- SUBTOTAL YOUTH CAMPS 94,778 275,631 180,853 66% POOL 2215-437-460445-111 SEASONAL SALARIES-POOL 142,054 170,081 28,027 16% 2215-437-460445-121 OVERTIME 493 200 293- -146% 2215-437-460445-155 RETIREMENT 255 1,500 1,245 83% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 224 500 276 55% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 436 2,000 1,564 78% 2215-437-460445-226 CHLORINE/CHEMICALS 28,387 40,000 11,613 29% 2215-437-460445-228 CONCESSION STAND SUPPLIES 7,985 21,000 13,015 62% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 422 4,000 3,578 89% 2215-437-460445-341 ELECTRICITY 4,242 9,500 5,258 55% 2215-437-460445-344 NATURAL GAS 215 25,000 24,785 99% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 497 2,500 2,003 80% 2215-437-460445-354 LICENSES & FEES 785 1,300 515 40% 2215-437-460445-356 BANK FEES/ CC CHARGES 1,088 2,500 1,412 56% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 5,552 28,250 22,698 80% 2215-437-460445-380 TRAINING MATERIALS 380 1,800 1,420 79% ------------------------------------------------- SUBTOTAL POOL EXPENDITURES 193,014 310,131 117,117 38% ------------------------------------------------- TOTAL PARKS & RECREATION/POOL 563,704 1,855,213 1,291,509 70% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 12 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING URBAN FORESTRY 2600-436-460433-110 SALARIES-URBAN FORESTRY 34,903 199,567 164,664 83% 2600-436-460433-111 SEASONAL SERVICES 12,803 23,406 10,603 45% 2600-436-460433-121 OVERTIME 0 1,000 1,000 100% 2600-436-460433-153 HEALTH INSURANCE 7,860 54,259 46,399 86% 2600-436-460433-155 RETIREMENT 3,286 17,366 14,080 81% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 2,765 4,000 1,235 31% 2600-436-460433-231 GAS 890 8,000 7,110 89% 2600-436-460433-241 CONSUMABLE TOOLS 72 12,200 12,128 99% 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 157 660 503 76% 2600-436-460433-354 CONTRACT SERVICES 48,995 195,000 146,005 75% 2600-436-460433-357 FORESTRY GRANT 0 6,000 6,000 100% 2600-436-460433-358 EAB MONITORING/ARBOR DAY 0 4,000 4,000 100% 2600-436-460433-362 EQUIPMENT MAINTENANCE 224 4,000 3,776 94% 2600-436-460433-364 LANDSCAPING & TREES 336 8,000 7,664 96% 2600-436-460433-373 DUES & TRAINING 9- 5,000 5,009 100% 2600-436-460433-388 MEDICAL 0 200 200 100% 2600-436-460433-395 EQUIPMENT RENTAL 5,400 9,500 4,100 43% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 4,136 4,137 2 0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 2,310 9,241 6,931 75% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 5,994 23,976 17,982 75% 2600-436-460433-528 INFORMATION TECHNOLOGY TRANSFER 1,904 7,617 5,713 75% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 8,556 17,146 8,590 50% 2600-436-460433-620 INTEREST EXPENSE 137 582 445 76% 2600-436-460433-940 MACHINERY & EQUIPMENT 0 140,000 140,000 100% ------------------------------------------------- TOTAL URBAN FORESTRY 140,719 754,857 614,138 81% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 13 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 147,599 751,500 603,901 80% 2230-000-342070-000 COUNTY EMS LEVY 0 130,000 130,000 100% 2230-000-381050-000 INCEPTION OF LEASE 0 190,000 190,000 100% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 87,500 350,000 262,500 75% ------------------------------------------------- TOTAL AMBULANCE REVENUE 235,099 1,421,500 1,186,401 83% ================================================= AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 146,701 724,099 577,398 80% 2230-440-420730-114 COMPTIME BUYBACK 0 3,500 3,500 100% 2230-440-420730-115 OUT OF RANK PAY 1,076 3,300 2,224 67% 2230-440-420730-121 OVERTIME 14,670 30,000 15,330 51% 2230-440-420730-153 HEALTH INSURANCE 32,716 157,313 124,597 79% 2230-440-420730-155 RETIREMENT 18,806 94,245 75,439 80% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 45 3,400 3,355 99% 2230-440-420730-218 NON-CAPITAL EQUIPMENT 53 4,200 4,147 99% 2230-440-420730-231 GAS & OIL 988 7,560 6,572 87% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 0 4,000 4,000 100% 2230-440-420730-312 POSTAGE/PRINTING 0 1,000 1,000 100% 2230-440-420730-345 TELEPHONE & COMMUNICATION 248 1,700 1,452 85% 2230-440-420730-354 CONTRACT SERVICES 2,025 20,040 18,015 90% 2230-440-420730-355 911 CENTER CONTRIBUTION 9,562 38,247 28,685 75% 2230-440-420730-359 AUDIT/CC OTHER FEES 1,115 1,650 535 32% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 40 5,000 4,960 99% 2230-440-420730-373 DUES & TRAINING 490 5,000 4,510 90% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,500 2,500 100% 2230-440-420730-391 MEDICAL TREATMENT-SUPPLIES 13,121 51,241 38,120 74% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 11,530 11,530 0- 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 3,994 15,978 11,984 75% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 11,907 47,627 35,720 75% 2230-440-420730-528 INFORMATION TECHNOLOGY TRANSFER 7,617 30,466 22,849 75% 2230-440-420730-610 PRINCIPAL - AMBULANCE 0 19,000 19,000 100% 2230-440-420730-620 INTEREST - AMBULANCE 0 2,375 2,375 100% 2230-440-420730-940 EQUIPMENT 185,633 190,000 4,367 2% ------------------------------------------------- TOTAL AMBULANCE EXPENDITURES 462,337 1,474,971 1,012,634 69% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 14 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC SAFETY IMPACT FEE REV 2399-000-341072-000 POLICE IMPACT FEES 7,699 10,000 2,301 23% 2399-000-341073-000 FIRE IMPACT FEES 92,347 150,000 57,653 38% 2399-000-371010-000 INVESTMENT EARNINGS 3,483 13,000 9,517 73% ------------------------------------------------- TOTAL PS IMPACT FEE REV 103,529 173,000 69,471 40% ================================================= PUBLIC SAFETY IMPACT FEE EXP 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 2,500 10,000 7,500 75% 2399-413-420140-610 PRINCIPAL - IMPOUND/STORAGE 0 5,000 5,000 100% 2399-413-420140-620 INTEREST - IMPOUND/STORAGE 0 2,000 2,000 100% 2399-413-420140-920 IMPOUND/STORAGE FACILITY 0 100,000 100,000 100% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 750,000 750,000 100% ------------------------------------------------- TOTAL PS IMPACT FEE EXP 2,500 867,000 864,500 100% ================================================= FIRE & HAZMAT GRANTS 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 19,023 10,000 9,023- -90% 2956-416-420415-940 AFG GRT FY20 SCBA 0 347,501 347,501 100% ------------------------------------------------- TOTAL FIRE GRANTS 19,023 357,501 338,478 95% ================================================= 2957-416-420400-221 DoMA EQUIP (REIMB) 16,234 0 16,234- 0% 2957-416-420410-125 PASS THRU HAZMAT OT 0 5,000 5,000 100% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 120 10,000 9,880 99% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 3,000 3,000 100% ------------------------------------------------- TOTAL HAZMAT GRANTS 16,354 18,000 1,646 9% ================================================= SAFER GRANT 2995-416-420400-110 SALARIES 0 66,500 66,500 100% 2995-416-420400-153 HEALTH INSURANCE 0 19,150 19,150 100% 2995-416-420400-155 RETIREMENT 0 9,550 9,550 100% ------------------------------------------------- TOTAL SAFER GRANT 0 95,200 95,200 100% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 15 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 224,319 400,000 175,681 44% 2394-000-323103-000 PLUMBING PERMITS 19,528 33,000 13,472 41% 2394-000-323104-000 MECHANICAL PERMITS 19,391 35,000 15,609 45% 2394-000-323105-000 ELECTRICAL PERMITS 28,604 58,000 29,396 51% 2394-000-323108-000 PLAN REVIEW FEES 61,276 120,000 58,724 49% 2394-000-362015-000 INSURANCE REIMBURSEMENT 3,173 0 3,173- 0% 2394-000-371010-000 INVESTMENT EARNINGS 5,259 15,000 9,741 65% ------------------------------------------------- TOTAL REVENUE 361,551 756,200 394,649 52% ================================================= BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES-BUILDING DEPT. 122,308 518,265 395,957 76% 2394-420-420530-112 SALARIES-SEVERANCE 0 23,993 23,993 100% 2394-420-420530-121 OVERTIME 1,912 20,000 18,088 90% 2394-420-420530-153 HEALTH INSURANCE 26,948 92,887 65,939 71% 2394-420-420530-155 RETIREMENT 9,728 39,716 29,988 76% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 4,061 22,000 17,939 82% 2394-420-420530-231 GAS & OIL 702 4,000 3,298 82% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 0 6,000 6,000 100% 2394-420-420530-323 ST. ED. ASSESSMENTS 0 5,500 5,500 100% 2394-420-420530-345 TELEPHONE & COMMUNICATION 1,831 6,000 4,169 69% 2394-420-420530-353 AUDITING 0 4,500 4,500 100% 2394-420-420530-354 CONTRACT SERVICES 2,198 20,000 17,802 89% 2394-420-420530-355 CITY WORKS LICENSING FEE 17,180 16,000 1,180- -7% 2394-420-420530-356 ArcGIS SERVER UPGRADE LICENSE 0 6,000 6,000 100% 2394-420-420530-357 CREDIT CARD / PAYPAL FEES 5,358 10,000 4,642 46% 2394-420-420530-360 FURNITURE 0 7,500 7,500 100% 2394-420-420530-373 DUES & TRAINING 415 30,000 29,585 99% 2394-420-420530-510 PROPERTY INSURANCE 10,914 10,914 0- 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 642 2,569 1,927 75% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 7,872 31,612 23,740 75% 2394-420-420530-528 INFORMATION TECHNOLOGY TRANSFER 22,044 88,174 66,130 75% 2394-420-420530-920 BUILDING IMPROVEMENTS 0 199,190 199,190 100% ------------------------------------------------- TOTAL BUILDING DEPT. 234,113 1,164,820 930,707 80% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 16 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 24,352 92,780 68,428 74% 2400-410-430263-153 HEALTH INSURANCE 3,467 16,775 13,308 79% 2400-410-430263-155 RETIREMENT 1,884 7,138 5,254 74% 2400-410-430263-244 STREET LIGHT SUPPLIES 0 18,000 18,000 100% 2400-410-430263-245 LUMINAIRES 0 30,000 30,000 100% 2400-410-430263-246 LED LUMINAIRE UPGRADE 0 16,431 16,431 100% 2400-410-430263-341 ELECTRICITY 38,147 182,000 143,853 79% 2400-410-430263-360 REPAIR & MAINT SERVICES 15,928 21,500 5,572 26% 2400-410-430263-373 DUES & TRAINING 0 2,500 2,500 100% 2400-410-430263-510 INSURANCE 1,671 1,671 0 0% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 2,950 11,801 8,851 75% 2400-410-430263-528 INFORMATION TECH TRANSFER 2,611 10,443 7,832 75% ------------------------------------------------- TOTAL LIGHT MAINT. 91,010 411,039 320,029 78% ================================================= 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 50,841 131,071 80,230 61% 2420-421-430234-957 ALLEY PAVING 25,118 40,000 14,882 37% 2420-421-430240-231 GAS & OIL 4,485 42,000 37,515 89% 2420-421-430240-344 NATURAL GAS 56 6,800 6,744 99% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 100% 2420-421-430240-360 REPAIR & MAINT SERVICES 0 1,500 1,500 100% 2420-421-430240-368 OVERLAY/CHIPSEALS 0 435,642 435,642 100% 2420-421-430240-452 GRAVEL 0 5,000 5,000 100% 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 6,352 58,000 51,648 89% 2420-421-430240-472 ASPHALT 33,196 40,000 6,804 17% 2420-421-430240-473 CRACK SEALING 4,716 16,100 11,384 71% 2420-421-430240-474 PAINT STRIPING MATERIALS 1,467 30,000 28,533 95% ------------------------------------------------- TOTAL GAS TAX 126,231 831,113 704,882 85% ================================================= BARSAA (GAS TAX) 2421-421-430240-354 PAVEMENT MAINTENANCE 139,380 450,000 310,620 69% ------------------------------------------------- TOTAL BARSAA 139,380 450,000 310,620 69% ================================================= 2825 MACI GRANT 2825-421-430240-940 EQUIPMENT 0 242,814 242,814 100% ------------------------------------------------- TOTAL MACI GRANT 0 242,814 242,814 100% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 17 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500 STREET MAINT. & SIGNS STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 193,850 827,422 633,572 77% 2500-421-430240-121 OVERTIME 102 28,000 27,898 100% 2500-421-430240-153 HEALTH INSURANCE 46,052 196,448 150,396 77% 2500-421-430240-155 RETIREMENT 14,958 62,911 47,953 76% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 5,391 17,360 11,969 69% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 48 7,000 6,952 99% 2500-421-430240-220 OTHER SUPPLIES 698 4,500 3,802 84% 2500-421-430240-231 GAS & OIL 4,655 42,000 37,345 89% 2500-421-430240-341 ELECTRICITY 490 3,500 3,010 86% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 410 1,850 1,440 78% 2500-421-430240-354 CONTRACT SERVICES 590 22,500 21,910 97% 2500-421-430240-356 TRANSPORTATION PLAN 30,152 105,000 74,848 71% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 4,231 41,000 36,769 90% 2500-421-430240-366 BUILDING MAINTENANCE 100 5,000 4,900 98% 2500-421-430240-373 DUES & TRAINING 623 13,000 12,377 95% 2500-421-430240-388 MEDICAL SERVICES 145 1,000 855 86% 2500-421-430240-510 LIABILITY INSURANCE 43,437 43,437 0- 0% 2500-421-430240-512 UNINSURED LOSS-DEDUCTIBLE 0 45,000 45,000 100% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 53,680 214,721 161,041 75% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 23,329 93,317 69,988 75% 2500-421-430240-528 INFORMATION TECHNOLOGY TRANSFER 8,323 33,293 24,970 75% 2500-421-430240-840 MACI GRANT MATCH - WTR/DE-ICER TRK 0 15,000 15,000 100% 2500-421-430240-953 SHOP COMPLEX PAVEMENT RESTORATION 0 10,000 10,000 100% 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 0 25,649 25,649 100% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 0 13,404 13,404 100% 2500-421-430244-354 PAVEMENT REPAIRS-PAVEMENT MNT FUNDS 176,702 717,621 540,919 75% 2500-421-430244-820 TRANSFER TO BaRSAA 0 15,000 15,000 100% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 0 315,000 315,000 100% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 448 27,828 27,380 98% ------------------------------------------------- TOTAL STREET MAINT. 608,415 2,947,761 2,339,346 79% ------------------------------------------------- SIGNS AND SIGNALS 2500-421-430264-110 TSS - SALARIES 19,266 106,087 86,821 82% 2500-421-430264-121 OVERTIME 0 7,500 7,500 100% 2500-421-430264-153 HEALTH INSURANCE 7,644 32,050 24,406 76% 2500-421-430264-155 RETIREMENT 1,481 7,988 6,507 81% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 600 4,775 4,175 87% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 0 6,700 6,700 100% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 678 4,000 3,322 83% 2500-421-430264-242 STREET SIGNS 6,054 30,000 23,946 80% 2500-421-430264-243 TRAFFIC SIGNALS 14,230 32,459 18,229 56% 2500-421-430264-245 BARRICADE MATERIALS 0 6,000 6,000 100% 2500-421-430264-341 ELECTRICITY 347 3,000 2,653 88% 2500-421-430264-345 COMMUNICATIONS 154 850 696 82% 2500-421-430264-354 CONTRACT SERVICES 509 10,000 9,491 95% 2500-421-430264-362 EQUIPMENT MAINTENANCE 1,324 3,000 1,676 56% 2500-421-430264-366 BUILDING MAINTENANCE 0 5,000 5,000 100% 2500-421-430264-373 DUES & TRAINING 121 7,500 7,379 98% 2500-421-430264-428 PAINT MATERIALS 0 5,000 5,000 100% 2500-421-430264-510 LIABILITY INS.-TSS 2,768 2,768 0 0% THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 18 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500-421-430264-512 UNINSURED LOSS-DEDUCTIBLE 0 1,000 1,000 100% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 1,439 5,758 4,319 75% 2500-421-430264-940 MACHINERY & EQUIPMENT 0 6,000 6,000 100% ------------------------------------------------- TOTAL SIGNS AND SIGNALS 56,617 287,435 230,818 80% ------------------------------------------------- TOTAL STREET MAINT. & SIGNS 665,032 3,235,196 2,570,164 79% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 19 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2188 WESTSIDE TIF REVENUE 2188-000-371010-000 INVESTMENT EARNINGS 1,620 0 1,620- 0% 2188-000-373010-000 INTEREST / LOANS 3,849 15,000 11,151 74% 2188-000-373020-000 PRINCIPAL / LOANS 4,470 18,000 13,530 75% 2188-000-381060-000 TRANSFER FROM GENERAL FUND 31,150 1,246,000 1,214,850 98% 2188-000-383001-000 TRANSFER FROM CD PROGRAMS (2886) 50,000 205,085 155,085 76% ------------------------------------------------- TOTAL REVENUE 91,089 1,484,085 1,392,996 94% ================================================= EXPENDITURES 2188-480-470230-110 SALARIES 11,466 48,475 37,009 76% 2188-480-470230-153 HEALTH INSURANCE 2,847 10,526 7,679 73% 2188-480-470230-155 RETIREMENT 935 3,846 2,911 76% 2188-480-470230-353 AUDIT 0 1,500 1,500 100% 2188-480-470230-356 TELEPHONE 48 192 144 75% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 532 2,127 1,595 75% 2188-480-470440-930 CITY MATCH - TRAIL 12,997 2,043,808 2,030,811 99% ------------------------------------------------- TOTAL WESTSIDE TIF 28,823 2,110,474 2,081,651 99% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 20 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2185 AIRPORT TIF 2185-000-430300-840 REDEVELOPMENT ACTIVITY 693,845 2,320,077 1,626,232 70% ------------------------------------------------- TOTAL 2185 AIRPORT TIF 693,845 2,320,077 1,626,232 70% ================================================= OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 9,500 9,500 100% 2310-480-470210-356 FED-EX REIMBURSEMENT 0 9,000 9,000 100% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 17,500 70,000 52,500 75% 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 1,250 5,000 3,750 75% ------------------------------------------------- TOTAL OLD SCHOOL TIFS 18,750 93,500 74,750 80% ================================================= GLACIER RAIL PARK TEDD 2312-480-470210-110 SALARIES & WAGES 5,434 22,869 17,435 76% 2312-480-470210-153 HEALTH INSURANCE 1,681 6,224 4,543 73% 2312-480-470210-155 RETIREMENT 443 1,808 1,365 75% 2312-480-470210-345 TELEPHONE 12 48 36 75% 2312-480-470210-353 AUDIT 0 1,500 1,500 100% 2312-480-470210-522 ADMINISTRATIVE TRANSFER 532 2,128 1,596 75% 2312-480-470210-790 REDEVELOPMENT 0 90,000 90,000 100% ------------------------------------------------- TOTAL GLACIER RAIL PARK TEDD 8,102 124,577 116,475 94% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 21 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 0 1,000 1,000 100% 2880-480-470210-354 CONTRACT SERVICES 50 1,000 950 95% 2880-480-470210-711 REDEVELOPMENT 0 225,000 225,000 100% ------------------------------------------------- TOTAL LOAN REVOLVING 50 227,000 226,950 100% ================================================= 2881 CD LOAN REV. #2 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 0 405 405 100% 2881-480-470210-711 REDEVELOPMENT 0 275,000 275,000 100% ------------------------------------------------- TOTAL 2881 CD REV. #2 0 275,405 275,405 100% ================================================= 2886 CD MISC. 2886-480-470210-353 AUDITING 0 1,000 1,000 100% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 125 2,000 1,875 94% 2886-480-470210-528 INFORMATION TECH TRANSFER 3,808 15,233 11,425 75% 2886-480-470210-532 OFFICE RENT 0 646 646 100% 2886-480-470210-790 REDEVELOPMENT ACTIVITY 0 5,000 5,000 100% 2886-480-470210-810 TRANSFER TO WS TIF 50,000 205,085 155,085 76% 2886-480-470210-815 TRANSFER TO SID 344 DEBT SERVICE 25,000 100,000 75,000 75% ------------------------------------------------- TOTAL CD MISC. 78,933 328,964 250,031 76% ================================================= 2887 RURAL DEVELOPMENT #1 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 0 19,014 19,014 100% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 0 3,060 3,060 100% 2887-480-470210-750 REDEVELOPMENT LOANS 0 150,000 150,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #1 0 172,074 172,074 100% ================================================= 2888 RURAL DEVELOPMENT #2 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 0 8,468 8,468 100% 2888-480-470210-620 INTEREST EXPENSE-USDA LOAN 61-03 0 1,557 1,557 100% 2888-480-470210-750 REDEVELOPMENT LOANS 0 300,000 300,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #2 0 310,025 310,025 100% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 22 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2953 EPA BROWNFIELDS 2953-480-470210-354 CONT SERV/PETROLEUM 10,061 109,561 99,500 91% 2953-480-470210-373 TRAVEL/PETROLEUM 0 1,429 1,429 100% 2953-480-470215-373 TRAVEL/HAZARDOUS 0 5,382 5,382 100% ------------------------------------------------- TOTAL EPA BROWNSFIELD 10,061 116,372 106,311 91% ================================================= 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES-PETROLEUM 0 218,322 218,322 100% 2955-480-470210-354 CONTRACTED SERVICES-PETROLUEM 2,622 0 2,622- 0% 2955-480-470210-725 REVOLVED FUNDS-PETROLEUM 0 100,500 100,500 100% 2955-480-470215-229 SUPPLIES-HAZARDOUS SUBSTANCES 0 267,673 267,673 100% ------------------------------------------------- TOTAL BROWNFIELDS LOAN REV. 2,622 586,495 583,873 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 0 3,803,909 3,803,909 100% ------------------------------------------------- TOTAL TIGER GRANT 0 4,040,621 4,040,621 100% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 23 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD 0 10,000 10,000 100% 2915-413-420140-218 SMALL EQUIP -Stonegarden 0 30,000 30,000 100% ------------------------------------------------- TOTAL 2915 STONEGARDEN GRANT 0 40,000 40,000 100% ================================================= 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 17,156 69,526 52,370 75% 2916-413-420140-121 OVERTIME 3,367 13,000 9,633 74% 2916-413-420140-153 HEALTH INSURANCE 3,392 12,889 9,497 74% 2916-413-420140-155 RETIREMENT 2,171 9,348 7,177 77% ------------------------------------------------- TOTAL 2916 DRUG ENFORCEMENT 26,086 104,763 78,677 75% ================================================= 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 213 4,000 3,787 95% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 2,505 35,000 32,495 93% 2919-413-420140-127 SCHOOL DIST. OT 0 20,000 20,000 100% 2919-413-420140-218 JAG GRT/BODY ARMOR & BODY WORN CAME 0 15,461 15,461 100% 2919-413-420140-219 EQUIPMENT FROM CORONAVIRUS GRANT 0 33,119 33,119 100% 2919-413-420140-220 EQUIPMENT-FUNDED BY DONATIONS 0 4,000 4,000 100% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 1,847 6,000 4,153 69% ------------------------------------------------- TOTAL LAW ENF. GRANT 4,566 117,580 113,014 96% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 24 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CAPITAL PROJECT FUNDS 4170 IMPOUND/STORAGE FACILITY 4170-400-411230-925 IMPOUND/STORAGE FACILITY 0 178,520 178,520 100% ------------------------------------------------- TOTAL IMPOUND/STORAGE FACILITY 0 178,520 178,520 100% 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION 1,362 25,000 23,638 95% ------------------------------------------------- TOTAL 4290 WALK & CURB 1,362 203,520 202,158 99% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 25 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ENTERPRISE FUNDS WATER REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 765 2,000 1,235 62% 5210-000-343210-000 METERED WATER SALES 1,354,551 3,319,443 1,964,892 59% 5210-000-343220-000 OTHER (CONST.) WATER SALES 892 25,000 24,108 96% 5210-000-343230-000 METER REPLACEMENT FEE 36,136 136,000 99,865 73% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 30,749 51,500 20,751 40% 5210-000-343270-000 WATER TURN ON FEES 1,385 5,000 3,615 72% 5210-000-343275-000 TAG FEE 10,200 33,000 22,800 69% 5210-000-343365-000 LATECOMER ADMIN FEE 4,927 10,000 5,073 51% 5210-000-371010-000 INVESTMENT EARNINGS 28,922 78,000 49,078 63% 5210-000-383010-000 TRANSFER FROM IMPACT FEE FUND (ADMI 4,375 17,500 13,125 75% 5210-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 50,000 200,000 150,000 75% ------------------------------------------------- TOTAL WATER REVENUE 1,522,901 3,877,443 2,354,542 61% ================================================= WATER FACILITIES 5210-447-430550-110 SALARIES-WATER 138,295 788,169 649,874 82% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 1,969 20,000 18,031 90% 5210-447-430550-153 HEALTH INSURANCE 35,907 173,129 137,222 79% 5210-447-430550-155 RETIREMENT 10,888 60,134 49,246 82% 5210-447-430550-210 OFFICE SUPPLIES /EQUIP/COMPUTERS/GI 5,244 23,000 17,756 77% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 609 9,000 8,391 93% 5210-447-430550-226 CHLORINE & CHEMICALS 12,299 39,000 26,701 68% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 1,002 4,500 3,498 78% 5210-447-430550-231 GAS & OIL 3,676 35,000 31,324 90% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 397 1,000 603 60% 5210-447-430550-336 LICENSES & FEES 52 19,500 19,448 100% 5210-447-430550-341 ELECTRICITY 58,281 160,000 101,719 64% 5210-447-430550-344 NATURAL GAS 666 15,500 14,834 96% 5210-447-430550-345 TELEPHONE & COMMUNICATION 2,773 12,000 9,227 77% 5210-447-430550-349 LAB SERVICES 3,663 20,000 16,337 82% 5210-447-430550-353 AUDITING 0 3,500 3,500 100% 5210-447-430550-354 CONTRACT SERVICES 4,583 55,000 50,417 92% 5210-447-430550-355 NOFFSINGER TRANSMISSION CONDITION A 0 260,500 260,500 100% 5210-447-430550-356 BACKBONE CONDITION ASSESS./WTR RIGH 1,856 205,500 203,644 99% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 1,350 15,000 13,650 91% 5210-447-430550-366 BUILDING MAINTENANCE 289 35,000 34,711 99% 5210-447-430550-373 DUES & TRAINING 0 13,000 13,000 100% 5210-447-430550-388 MEDICAL SERVICES 83 700 618 88% 5210-447-430550-410 CONSTRUCTION MATERIALS 6,801 35,000 28,199 81% 5210-447-430550-422 HYDRANTS 1,196 10,000 8,804 88% 5210-447-430550-423 MATERIALS FOR MAINS 730 14,000 13,270 95% 5210-447-430550-424 MATERIALS -SERVICE LINES 0 12,000 12,000 100% 5210-447-430550-425 MATERIALS PUMPS/WELLS 523 45,000 44,477 99% 5210-447-430550-510 PROPERTY & LIABILITY INS. 40,980 40,980 0- 0% 5210-447-430550-512 UNINSURED LOSS-DEDUCTIBLE 1,654 10,000 8,346 83% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 9,069 36,275 27,206 75% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 26,168 104,671 78,503 75% 5210-447-430550-528 INFORMATION TECH TRANSFER 16,846 67,382 50,536 75% 5210-447-430550-532 LEASE PAYMENTS 0 4,000 4,000 100% 5210-447-430550-925 NOFFSINGER REHAB ALTERNATIVE 0 520,000 520,000 100% THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 26 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-935 METER SYSTEM REPLACEMENT 0 317,000 317,000 100% 5210-447-430550-937 BUFFALO HILL FLOW CONTROL UPGRADE 0 140,000 140,000 100% 5210-447-430550-948 METERS (METER FUNDS) 010125 15,075 50,679 35,604 70% 5210-447-430550-950 1ST AVE WN MAIN REPLACEMENT 0 30,000 30,000 100% 5210-447-430550-951 SECURITY SCADA UPGRADES 17,280 305,000 287,721 94% 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 0 10,000 10,000 100% 5210-447-430550-954 ELEVATED STORAGE TANK & WELL 0 8,270,000 8,270,000 100% 5210-447-430550-958 2ND AVE W RR FROM CENTER TO 2ND ST 0 302,000 302,000 100% 5210-447-430550-971 10TH AVE W & 2ND ST W R&R 345,300 431,380 86,080 20% ------------------------------------------------- SUBTOTAL WATER FACILITIES 765,502 12,728,499 11,962,997 94% ------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES-WATER BILLING 29,948 121,093 91,145 75% 5210-447-430560-153 HEALTH INSURANCE 10,863 39,753 28,890 73% 5210-447-430560-155 RETIREMENT 2,414 9,596 7,182 75% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 909 9,000 8,091 90% 5210-447-430560-353 AUDITING 0 2,000 2,000 100% 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 12,003 40,000 27,997 70% 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 4,469 27,000 22,531 83% 5210-447-430560-356 OTHER CONTRACT SERVICES 15 1,000 985 99% 5210-447-430560-373 DUES & TRAINING 50 3,000 2,950 98% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 2,847 11,390 8,543 75% 5210-447-430560-528 INFORMATION TECH TRANSFER 13,329 53,316 39,987 75% ------------------------------------------------- SUBTOTAL WATER BILLING 76,847 317,148 240,301 76% ------------------------------------------------- REVENUE BONDS 5210-447-490200-610 PRIN - 4 MILE DR TRANSMISSION / WRF 0 90,000 90,000 100% 5210-447-490200-620 INT - 4 MILE DR TRANSMISSION / WRF 64,888 55,000 9,888- -18% 5210-447-490204-610 BOND PRIN-HWY 93 S WTR - 2004 0 79,000 79,000 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 7,704 7,704 0 0% 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 350 350 0 0% 5210-447-490206-610 PRIN-WELL/TANK/8114 2.25% 4TH ST 0 91,000 91,000 100% 5210-447-490206-620 INT-WELL&TANK/8114 2.25% 4TH ST WT 14,816 14,816 0- 0% 5210-447-490210-610 4TH AVE E MAIN REPL/WRF 17393 0 82,352 82,352 100% 5210-447-490210-620 4TH AVE E MAIN REPL/WFR 17393 43,040 43,040 0- 0% 5210-447-490250-610 PRIN-WTR MAIN/WRF 1032R 2%/IDAHO&MA 0 26,000 26,000 100% 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2%/IDAHO&MAIN 260 260 0 0% ------------------------------------------------- SUBTOTAL REVENUE BONDS 131,058 489,522 358,465 73% ------------------------------------------------- DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 950,000 950,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 950,000 950,000 100% ------------------------------------------------- TOTAL WATER FUND 973,407 14,485,169 13,511,762 93% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 27 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING WATER IMPACT FEE REVENUE: 5211-000-343225-000 IMPACT FEES 223,378 350,000 126,622 36% 5211-000-371010-000 INTEREST EARNINGS 3,956 12,000 8,044 67% ------------------------------------------------- TOTAL WATER IMPACT FEES REVENU 227,334 362,000 134,666 37% ================================================= WATER IMPACT FEES EXPENSES: 5211-447-430555-424 METERS - NEW DEVELOPMENT 15,075 54,000 38,925 72% 5211-447-430555-820 DEBT SERVICE TRANSFER TO 5210 50,000 200,000 150,000 75% 5211-447-430555-825 TRANSFER TO 5210 FOR ADMIN 4,375 17,500 13,125 75% 5211-447-430555-930 CONTRACT MAIN UPSIZE 0 515,000 515,000 100% 5211-447-430555-954 ELEVATED TANK & WELL 0 448,000 448,000 100% ------------------------------------------------- TOTAL WATER IMPACT FEE EXPENSE 69,450 1,234,500 1,165,050 94% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 28 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 765 2,000 1,235 62% 5310-000-343310-000 SEWER SERVICE CHARGES 1,546,616 5,991,963 4,445,347 74% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 19,692 14,000 5,692- -41% 5310-000-343365-000 LATECOMER ADMIN FEES 3,091 5,000 1,909 38% 5310-000-371010-000 INVESTMENT EARNINGS 18,990 60,000 41,010 68% 5310-000-383010-000 ADMIN TRANSFER FROM IMPACT FEE FUND 8,350 33,400 25,050 75% 5310-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 206,250 900,000 693,750 77% ------------------------------------------------- TOTAL SEWER REVENUE 1,803,754 7,006,363 5,202,609 74% ================================================= SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES-SEWER BILLING 25,651 102,807 77,156 75% 5310-454-430620-153 HEALTH INSURANCE 8,276 29,810 21,534 72% 5310-454-430620-155 RETIREMENT - PERD 2,062 8,127 6,065 75% 5310-454-430620-215 OFFICE SUPPLIES/computers 909 9,000 8,091 90% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 0 2,000 2,000 100% 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 12,003 40,000 27,997 70% 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 4,469 27,000 22,531 83% 5310-454-430620-356 OTHER CONTRACT SERVICES 15 1,000 985 99% 5310-454-430620-373 DUES & TRAINING 50 3,000 2,950 98% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 2,598 10,391 7,793 75% 5310-454-430620-528 INFORMATION TECH. TRANSFER 13,329 53,316 39,987 75% ------------------------------------------------- SUBTOTAL SEWER BILLING COSTS 69,363 286,451 217,088 76% ------------------------------------------------- SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES-SANITARY SEWER 70,575 308,061 237,486 77% 5310-454-430630-121 OVERTIME 0 5,500 5,500 100% 5310-454-430630-153 HEALTH INSURANCE 18,197 81,790 63,593 78% 5310-454-430630-155 RETIREMENT 5,498 23,625 18,127 77% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 4,266 13,200 8,934 68% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 616 13,350 12,734 95% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 477 2,300 1,823 79% 5310-454-430630-231 GAS & OIL 2,266 12,000 9,734 81% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 12 500 488 98% 5310-454-430630-341 ELECTRICITY 9,911 57,000 47,089 83% 5310-454-430630-344 NATURAL GAS 2,627 16,500 13,873 84% 5310-454-430630-345 TELEPHONE & COMMUNICATION 6,747 26,500 19,753 75% 5310-454-430630-353 AUDITING 0 3,000 3,000 100% 5310-454-430630-354 CONTRACT SERVICES 4,721 25,000 20,279 81% 5310-454-430630-356 CONSULTANTS - MODELING/RATE STUDY 0 15,000 15,000 100% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 620 16,875 16,255 96% 5310-454-430630-373 DUES & TRAINING 0 9,250 9,250 100% 5310-454-430630-388 MEDICAL SERVICES 173 500 328 66% 5310-454-430630-410 CONSTRUCTION MATERIALS 600 10,000 9,400 94% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 9,021 70,000 60,979 87% 5310-454-430630-510 PROPERTY & LIABILITY INS. 58,040 58,040 0- 0% 5310-454-430630-512 UNINSURED LOSS-DEDUCTIBLE 0 25,000 25,000 100% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 2,851 11,404 8,553 75% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 12,823 51,291 38,468 75% THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 29 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-528 INFORMATION TECH TRANSFER 11,133 44,532 33,399 75% 5310-454-430630-532 OFFICE RENT / BNSF LEASE 6,689 0 6,689- 0% 5310-454-430630-922 L.S. #9 IMPROVEMENTS/DESIGN 0 250,000 250,000 100% 5310-454-430630-940 MACHINERY & EQUIPMENT 0 245,000 245,000 100% 5310-454-430630-948 REPAIR & REPLC OF SEWER MAIN 215,750 599,430 383,680 64% 5310-454-430630-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 57,800 57,800 100% 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 0 10,000 10,000 100% 5310-454-430630-954 MN REPL. DESIGN - 1ST & 2ND AVE EN 0 121,000 121,000 100% 5310-454-430630-957 WEST SIDE INTERCEPTOR (BONDED) 603,825 2,579,648 1,975,823 77% 5310-454-430630-959 L.S. 5a REMOVAL 0 335,000 335,000 100% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 0 50,000 50,000 100% 5310-454-430630-961 6TH ALLEY E - S OF 14TH & 13TH 0 263,000 263,000 100% 5310-454-430630-962 SEWER MAIN SLIP LINING 232,068 395,000 162,932 41% ------------------------------------------------- SUBTOTAL SEWER COLLECTION 1,279,506 5,806,096 4,526,590 78% ------------------------------------------------- REVENUE BONDS/SANITARY 5310-454-490200-610 PRINCIPAL WESTSIDE INTERCEPTOR BOND 0 334,000 334,000 100% 5310-454-490200-620 INTEREST-WESTSIDE INTERCEPTOR BOND 331,825 270,000 61,825- -23% 5310-454-490200-630 FISCAL AGENT FEE-WESTSIDE INTERCEPT 0 350 350 100% 5310-454-490204-610 PRINCIPAL - HWY 93 S/SRF5125/2.25% 0 89,000 89,000 100% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 7,740 7,741 1 0% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25% 0 350 350 100% ------------------------------------------------- SUBTOTAL REVENUE BONDS 339,565 701,441 361,876 52% ------------------------------------------------- DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 500,000 500,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION-SANITARY 0 500,000 500,000 100% ------------------------------------------------- SUBTOTAL SANITARY SEWER 1,619,071 7,007,537 5,388,466 77% ------------------------------------------------- WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 106,286 468,577 362,291 77% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-121 OVERTIME 4,244 22,500 18,256 81% 5310-455-430640-153 HEALTH INSURANCE 25,356 97,675 72,319 74% 5310-455-430640-155 RETIREMENT 8,629 35,640 27,011 76% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 4,507 11,500 6,993 61% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 2,292 3,000 708 24% 5310-455-430640-225 ALUM 7,058 43,500 36,442 84% 5310-455-430640-226 CHLORINE & CHEMICALS 31,732 111,000 79,268 71% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 3,838 7,000 3,162 45% 5310-455-430640-231 GAS & OIL 3,815 19,000 15,185 80% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 0 550 550 100% 5310-455-430640-336 LICENSES & FEES 0 14,000 14,000 100% 5310-455-430640-341 ELECTRICITY 48,323 193,000 144,677 75% 5310-455-430640-342 WATER 442 7,500 7,058 94% 5310-455-430640-344 NATURAL GAS 3,814 82,000 78,186 95% THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 30 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-345 TELEPHONE & COMMUNICATION 1,587 12,050 10,464 87% 5310-455-430640-353 AUDITING 0 2,500 2,500 100% 5310-455-430640-354 CONTRACT-GLACIER GOLD 28,702 135,000 106,298 79% 5310-455-430640-355 CONTRACT - LAND FILL & OTHER 8,046 49,000 40,954 84% 5310-455-430640-356 CONSULTANTS 69,914 267,000 197,086 74% 5310-455-430640-358 CONSULTANT- PERMIT/RATE STDY/TMDL 2,254 145,000 142,746 98% 5310-455-430640-360 MISC. MAINT SERVICES 10,694 30,000 19,306 64% 5310-455-430640-366 BUILDING MAINTENANCE 1,626 51,000 49,374 97% 5310-455-430640-373 DUES & TRAINING 29 9,500 9,471 100% 5310-455-430640-388 MEDICAL SERVICES 165 500 335 67% 5310-455-430640-510 PROPERTY & LIABILITY INS. 49,256 49,256 0 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 5,111 20,443 15,332 75% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 29,979 119,914 89,935 75% 5310-455-430640-528 INFORMATION TECH TRANSFER 9,521 38,083 28,562 75% 5310-455-430640-921 DESIGN-DOME FOR SECONDARY CLARIFIER 0 403,000 403,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,400,000 2,400,000 100% ------------------------------------------------- SUBTOTAL WWTP OPERATIONS 467,218 5,031,740 4,564,522 91% ------------------------------------------------- WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 19,139 193,000 173,861 90% 5310-455-430645-934 SECONDARY DIGESTER LID REPLC 20,531 41,766 21,235 51% 5310-455-430645-940 MACHINERY & EQUIPMENT 0 324,000 324,000 100% 5310-455-430645-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 75,480 75,480 100% ------------------------------------------------- SUBTOTAL WWTP REPLACEMENT 39,669 634,246 594,577 94% ------------------------------------------------- WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 28,312 119,920 91,608 76% 5310-455-430646-153 HEALTH INSURANCE 4,950 18,222 13,272 73% 5310-455-430646-155 RETIREMENT 2,194 9,044 6,850 76% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 1,081 6,000 4,919 82% 5310-455-430646-218 NON-CAPITAL EQUIPMENT 0 13,500 13,500 100% 5310-455-430646-222 LAB SUPPLIES 3,604 16,500 12,896 78% 5310-455-430646-349 LAB SERVICES 1,821 15,000 13,179 88% 5310-455-430646-350 PRETREATMENT SERVICE 1,067 15,000 13,933 93% 5310-455-430646-362 EQUIPMENT MAINTENANCE 0 5,500 5,500 100% 5310-455-430646-373 DUES & TRAINING 0 5,000 5,000 100% 5310-455-430646-940 EQUIPMENT - ANALYZER 38,235 47,000 8,765 19% ------------------------------------------------- SUBTOTAL WWTP LAB OPERATIONS 81,264 270,686 189,422 70% DEBT SERVICE - WWTP 5310-455-490227-610 PRINCIPAL - WWTP IMP/SRF8164R/2.25% 0 871,000 871,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 141,896 141,897 1 0% 5310-455-490228-610 PRINC - WWTP DIGESTER LID/SRF 13326 0 50,000 50,000 100% 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 23,055 23,055 0 0% ------------------------------------------------- SUBTOTAL DEBT SERVICE - WWTP 164,951 1,085,952 921,001 85% ------------------------------------------------- DEPRECIATION/REPL. - WWTP THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 31 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-510400-831 DEPR. EXP. - WWTP (INCLUDES 010125 0 1,250,000 1,250,000 100% ------------------------------------------------- SUTOTAL WWTP DEPRECIATION/REPL 0 1,250,000 1,250,000 100% ------------------------------------------------- SUBTOTAL WWTP 753,103 8,272,624 7,519,521 91% ------------------------------------------------- TOTAL BILLING/SANITARY/WWTP 2,441,537 15,566,612 13,125,075 84% ================================================= SEWER IMPACT FEE REVENUE 5311-000-343330-000 SANITARY IMPACT FEES 360,750 460,000 99,250 22% 5311-000-343335-000 TREATMENT IMPACT FEES 213,450 208,000 5,450- -3% 5311-000-371010-000 SANITARY INTEREST EARNINGS 6,294 18,000 11,706 65% 5311-000-371015-000 TREATMENT INTEREST EARNINGS 5,731 14,400 8,669 60% ------------------------------------------------- TOTAL SEWER IMPACT FEES REVENU 586,226 700,400 114,174 16% ================================================= SEWER IMPACT FEE EXPENSES 5311-454-430635-820 TRANSFER TO 5310 FOR DEBT (SANITARY 150,000 675,000 525,000 78% 5311-454-430635-825 TRANSFER TO 5310 FOR ADMIN 5,750 23,000 17,250 75% 5311-454-430635-950 RR & UPSIZE - WWTP MAIN (66% - 34% 0 146,520 146,520 100% 5311-454-430635-955 MAIN & L.S. UPSIZE 0 400,000 400,000 100% 5311-454-430635-957 WEST SIDE INTERCEPTOR PH. 1 28,418 86,692 58,274 67% 5311-455-430644-820 TRANSFER TO 5310 FOR DEBT 56,250 225,000 168,750 75% 5311-455-430644-825 TRANSFER TO 5310 FOR ADMIN 2,600 10,400 7,800 75% 5311-455-430644-929 CONSTRUCT NEW EQ BASIN 0 469,800 469,800 100% 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 112,200 112,200 100% ------------------------------------------------- TOTAL SEWER IMPACT FEE EXPENSE 243,018 2,262,449 2,019,431 89% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 32 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM SEWER REVENUE 5349-000-323108-000 PW PLAN REVIEW FEES 765 1,000 235 24% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 0 1,500 1,500 100% 5349-000-343034-000 PERMIT FEES 1,000 1,000 0 0% 5349-000-343035-000 STORM SEWER CHARGES 2,682 1,800 882- -49% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 0 1,767,772 1,767,772 100% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 1,273 2,500 1,227 49% 5349-000-371010-000 INTEREST ON INVESTMENTS 8,967 25,000 16,033 64% 5349-000-383010-000 IMPACT FEE 5% ADMIN - TFR FROM IMPA 1,500 6,000 4,500 75% 5349-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 30,000 150,000 120,000 80% ------------------------------------------------- TOTAL STORM REVENUE 46,187 1,956,572 1,910,385 98% ================================================= STORM SEWER 5349-453-430246-110 SALARIES-STORM SEWER 110,481 493,494 383,013 78% 5349-453-430246-121 OVERTIME 0 4,000 4,000 100% 5349-453-430246-153 HEALTH INSURANCE 26,518 111,722 85,204 76% 5349-453-430246-155 RETIREMENT 8,643 37,805 29,162 77% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 9,531 17,100 7,569 44% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 243 11,000 10,757 98% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100% 5349-453-430246-231 GAS & OIL 2,018 11,500 9,482 82% 5349-453-430246-345 TELEPHONE & COMMUNICATION 648 2,500 1,852 74% 5349-453-430246-353 AUDITING 0 1,150 1,150 100% 5349-453-430246-354 CONTRACT SERVICE 1,489 7,000 5,511 79% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 0 135,000 135,000 100% 5349-453-430246-358 CONSULTANTS 0 10,000 10,000 100% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 0 30,000 30,000 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 0 8,000 8,000 100% 5349-453-430246-362 GROUNDWATER MONITORING 0 6,500 6,500 100% 5349-453-430246-371 CURB & GUTTER 536 21,000 20,465 97% 5349-453-430246-373 DUES & TRAINING 0 9,250 9,250 100% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 122 10,000 9,878 99% 5349-453-430246-510 PROPERTY & LIABILITY INS. 11,917 16,917 5,000 30% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 2,851 11,404 8,553 75% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 11,490 45,960 34,470 75% 5349-453-430246-528 INFORMATION TECH TRANSFER 10,227 40,909 30,682 75% 5349-453-430246-530 BNSF LEASE PMT 2,250 5,000 2,750 55% 5349-453-430246-968 RR W CENTER-7TH AVE W TO MERIDIAN 0 372,000 372,000 100% 5349-453-430246-970 REG. FACILITIES & PIPING DESIGN (BO 0 3,500,000 3,500,000 100% 5349-453-430247-952 STORM DRAIN CORRECTION (NEW & C/O) 104,540 200,000 95,460 48% 5349-453-430247-953 SHOP COMPLEX PAVEMENT (C/O) 0 10,000 10,000 100% 5349-453-430247-954 N. MAIN ST STORMWATER PROJ. 0 252,500 252,500 100% 5349-453-430247-956 WYOMING ST OUTFALL 0 225,000 225,000 100% 5349-453-430247-959 REGIONAL FACILITIES & PIPING DESIGN 0 400,000 400,000 100% 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 0 300,000 300,000 100% 5349-453-430249-940 MACHINERY FROM REPLACEMENT 0 245,000 245,000 100% ------------------------------------------------- SUBTOTAL STORM OPERATIONS 303,504 6,604,011 6,300,507 95% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 33 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM BONDS/LOANS 5349-453-490200-610 PRINCIPAL - 4TH AVE E BOND 0 2,999 2,999 100% 5349-453-490200-620 INTEREST-4TH AVE E BOND 1,568 1,568 1 0% 5349-453-490225-610 PRINCIPAL - REGIONAL FACILITIES 0 144,030 144,030 100% 5349-453-490225-620 INTEREST - REGIONAL FACILITIES 0 91,402 91,402 100% ------------------------------------------------- SUBTOTAL STORM BONDS/LOANS 1,568 239,999 238,432 99% ------------------------------------------------- DEPRECIATION 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 360,000 360,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 360,000 360,000 100% ------------------------------------------------- TOTAL STORM EXPENSE 305,071 7,204,010 6,898,939 96% ================================================= STORM SEWER IMPACT FEE REVENUE 5348-000-343033-000 IMPACT FEES 105,369 120,000 14,631 12% 5348-000-371010-000 INTEREST EARNINGS 5,554 15,000 9,446 63% ------------------------------------------------- TOTAL STORM IMPACT FEES REVENU 110,923 135,000 24,077 18% ================================================= STORM SWR IMPACT FEE EXPENSES 5348-453-430248-820 DEBT SERVICE TRANSFER TO 5349 30,000 150,000 120,000 80% 5348-453-430248-825 TRANSFER TO 5349 FOR ADMIN 1,500 6,000 4,500 75% 5348-453-430248-959 REG FACILITIES & PIPING DESIGN 90,970 1,450,908 1,359,938 94% 5348-453-430248-960 STORMWATER FACILITY UPSIZING (CARRY 0 230,000 230,000 100% 5348-453-430248-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% ------------------------------------------------- TOTAL STORM IMPACT FEE EXPENSE 122,470 1,886,908 1,764,438 94% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 34 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SOLID WASTE REVENUE: 5510-000-343360-000 SALE OF MAT/AUCTION 5,090 2,500 2,590- -104% 5510-000-343410-000 GARBAGE COLLECTION-ASSESSED 0 1,035,000 1,035,000 100% 5510-000-343420-000 GARBAGE COLLECTION-NOT ASSESSED 934 23,000 22,066 96% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,052 2,000 948 47% 5510-000-371010-000 INVESTMENT EARNINGS 4,025 10,800 6,775 63% ------------------------------------------------- TOTAL SOLID WASTE REVENUE 11,101 1,073,300 1,062,199 99% ================================================= SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES-SOLID WASTE 93,950 442,363 348,413 79% 5510-460-430840-121 OVERTIME 575 6,500 5,925 91% 5510-460-430840-153 HEALTH INSURANCE 24,494 108,766 84,272 77% 5510-460-430840-155 RETIREMENT 7,308 33,664 26,356 78% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 7,541 15,500 7,959 51% 5510-460-430840-218 EQUIPMENT-GARBAGE CONTAINERS 0 37,500 37,500 100% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 1,315 5,500 4,185 76% 5510-460-430840-231 GAS & OIL 8,875 60,000 51,125 85% 5510-460-430840-341 ELECTRICITY 259 2,050 1,791 87% 5510-460-430840-344 NATURAL GAS 65 4,500 4,435 99% 5510-460-430840-345 TELEPHONE & COMMUNICATION 401 2,000 1,599 80% 5510-460-430840-354 CONTRACT SERVICES 878 22,000 21,122 96% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 0 5,700 5,700 100% 5510-460-430840-366 BUILDING MAINTENANCE 0 5,000 5,000 100% 5510-460-430840-373 DUES & TRAINING 0 7,000 7,000 100% 5510-460-430840-388 MEDICAL SERVICES 110 700 590 84% 5510-460-430840-510 PROPERTY & LIABILITY INS. 20,507 20,507 0 0% 5510-460-430840-512 UNINSURED LOSS-DEDUCTIBLE 0 4,000 4,000 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 22,163 88,650 66,487 75% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 10,393 41,572 31,179 75% 5510-460-430840-528 INFORMATION TECH TRANSFER 8,323 33,293 24,970 75% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 10,000 40,000 30,000 75% 5510-460-430840-944 VEHICLES (Replacement $) 0 585,000 585,000 100% 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 0 10,000 10,000 100% 5510-460-430845-224 JANITORIAL SUPPLIES 0 500 500 100% 5510-460-430845-341 ELECTRICITY 336 3,500 3,164 90% 5510-460-430845-342 WATER 86 2,000 1,914 96% 5510-460-430845-344 NATURAL GAS 56 6,000 5,944 99% 5510-460-430845-360 REPAIR & MAINT SERVICES 7,459 17,000 9,541 56% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% ------------------------------------------------- TOTAL SOLID WASTE EXPENSE 225,092 1,760,765 1,535,673 87% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 35 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING INTERNAL SERVICE FUNDS INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 ENTITLEMENT SHARE PMT/HB124 84,000 336,000 252,000 75% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 0 210,000 210,000 100% 6030-000-371010-000 INVESTMENT EARNINGS 472 1,000 528 53% 6030-000-393000-000 INTERNAL SERVICES-DATA 132,823 531,292 398,469 75% ------------------------------------------------- TOTAL INFORMATION TECH REVENUE 217,295 1,078,292 860,997 80% ================================================= INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 75,098 366,388 291,290 80% 6030-401-410580-121 OVERTIME 42 1,000 958 96% 6030-401-410580-153 HEALTH INSURANCE 17,845 88,484 70,639 80% 6030-401-410580-155 RETIREMENT 6,094 29,474 23,380 79% 6030-401-410588-218 COMPUTERS - ADMINISTRATIVE DEPTS 4,163 5,310 1,147 22% 6030-403-410580-215 COMPUTER SUPPLIES 150 2,865 2,715 95% 6030-403-410580-218 EQUIPMENT-NOT CAPITAL 1,471 34,295 32,824 96% 6030-403-410580-325 WEBSITE 5,248 6,670 1,422 21% 6030-403-410580-345 PAGER/PHONE 14 2,800 2,786 100% 6030-403-410580-346 SUMMITNET & ISPS 2,192 14,028 11,836 84% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,597 5,220 1,623 31% 6030-403-410580-354 MAINTENANCE CONTRACTS 709 65,100 64,391 99% 6030-403-410580-355 LICENSES 2,476 19,950 17,475 88% 6030-403-410580-356 MAINTENANCE CONTRACTS 29,781 86,350 56,569 66% 6030-403-410580-357 GRANICUS 5,280 5,300 20 0% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 417 66,560 66,143 99% 6030-403-410580-359 PRIVATE FIBER - CITY NETWORK 0 19,000 19,000 100% 6030-403-410580-360 MULTI-FACTOR AUTHENTICATION 0 18,000 18,000 100% 6030-403-410580-373 DUES & TRAINING 3,440 15,880 12,440 78% 6030-403-410580-510 INSURANCE 6,077 6,077 0- 0% 6030-403-410583-218 TV-Video Equipment & programming 2,526 3,500 974 28% 6030-403-410585-229 COPIER,FAX, SUPPLIES 1,500 18,475 16,975 92% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 20,745 174,788 154,043 88% 6030-403-410585-532 COPIER LEASES 3,793 15,504 11,711 76% 6030-403-410585-942 Servers - capital contingency 0 43,204 43,204 100% 6030-403-510400-831 DEPRECIATION EXPENSE 0 10,000 10,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 0 3,505 3,505 100% 6030-405-410588-940 COMPUTERS - SWITCHES 0 53,000 53,000 100% 6030-410-410588-218 COMPUTERS - DPW 4,074 3,200 874- -27% 6030-413-410588-218 COMPUTERS - POLICE DEPT 0 24,545 24,545 100% 6030-413-410588-354 POLICE - HOSTED SERVER 700 2,850 2,150 75% 6030-416-410588-218 COMPUTERS - FIRE 0 6,725 6,725 100% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 284 5,200 4,916 95% 6030-436-410588-218 COMPUTERS - PARKS 0 3,615 3,615 100% 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 1,200 1,200 100% ------------------------------------------------- TOTAL INFORMATION TECH EXPENSE 197,715 1,228,062 1,030,347 84% ================================================= THE CITY OF KALISPELL, MONTANA10.14.2020 11:33 gb8501_pg.php/Job No: 38916 Page 36 of 36 USER: RGW 1ST QUARTER FY21 FINANCIAL REPORT thru SEPTEMBER 30 25.00 % Yr Complete For Fiscal Year: 2021 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 145,000 580,000 435,000 75% 6010-000-371010-000 INVESTMENT EARNINGS 321 1,200 879 73% ------------------------------------------------- TOTAL CENTRAL GARAGE REVENUE 145,321 581,200 435,879 75% ================================================= CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 42,434 166,712 124,278 75% 6010-410-431330-121 OVERTIME 0 2,500 2,500 100% 6010-410-431330-153 HEALTH INSURANCE 10,514 45,611 35,097 77% 6010-410-431330-155 RETIREMENT 2,988 12,600 9,612 76% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 1,253 11,500 10,247 89% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 1,365 8,000 6,635 83% 6010-410-431330-230 OIL 4,234 25,500 21,266 83% 6010-410-431330-231 GAS 132 1,500 1,368 91% 6010-410-431330-232 VEHICLE PARTS 26,357 136,000 109,643 81% 6010-410-431330-233 TIRES 12,001 54,000 41,999 78% 6010-410-431330-238 FILTERS 2,415 9,000 6,585 73% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 909 2,000 1,091 55% 6010-410-431330-341 ELECTRICITY 524 2,200 1,676 76% 6010-410-431330-344 NATURAL GAS 153 6,500 6,347 98% 6010-410-431330-354 CONTRACT SERVICES 3,211 32,000 28,789 90% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 97 6,000 5,903 98% 6010-410-431330-373 DUES & TRAINING 0 8,500 8,500 100% 6010-410-431330-388 MEDICAL SERVICES 0 500 500 100% 6010-410-431330-510 INSURANCE 4,201 4,201 0 0% 6010-410-431330-528 INFORMATION TECH TRANSFER 3,808 15,233 11,425 75% 6010-410-431330-944 MACHINERY & EQUIPMENT 32,806 35,000 2,194 6% ------------------------------------------------- TOTAL CENTRAL GARAGE EXPENSES 149,402 585,057 435,655 74% =================================================