The URL can be used to link to this page

10-04-19 City Manager Report1 City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 10/04/2019 1.Police Department Attached is the most recent case and arrest report for law enforcement. Chief Overman, Sgt. Venezio, Officer Parce and Reserve Officer Wilson participated in the Tip a Cop fundraiser held at the McKenzie River locations in Kalispell on September 24.Local Law Enforcement Officers volunteer as “Celebrity Servers” in efforts to earn “tips” for Special Olympics Montana Athletes. All “tip” proceeds are donated directly to local and state-wide Special Olympics Montana Programs. Officer Keller, Officer Petersen, Officer Turner, and Officer Allen attended the Calgary Negotiators Conference September 17-19. The seminar was jointly hosted by the Calgary Police Service and the Southern Alberta District of the Royal Canadian Mounted Police and works to expand the knowledge and expertise of negotiators, incident commanders and tactical officers. Officer Dustin Willey is on his fourth week of the 12-week Montana Law Enforcement Academy. Records Management Specialist Teresa Parker attended the Montana Law Enforcement Information and Records Association Conference in Great Falls September 24 and 25. The purpose of the Association is to provide education and information regarding the current and updated laws and information related to records management. 2.Public Works Woodland Ave and 2nd St E/Conrad Drive Intersection Improvement Project The Montana Department of Transportation (MDT) in coordination with the City of Kalispell, are working to improve intersection safety at Woodland Ave and 2nd St E/Conrad Drive. An early feasibility study identified a mini-roundabout as the most appropriate intersection control and the project will be entering the design phase once the full feasibility study has been completed. The purpose of the project is to reduce the 2 frequency and severity of crashes, accommodate pedestrian and bicycle traffic, mitigate the steep grade on the east leg of the intersection, and to the extent possible, fit the improvements within the existing intersection and right-of-way footprint. MDT and the City would like to notify the public and seek comments on a proposal to improve the Woodland Avenue and 2nd Street East/Conrad intersection. Project team members will be hosting an open house at the ImagineIF Flathead County Library (247 1st Avenue East, Kalispell) on October 28, 2019 between 4:00 p.m. and 6:30 p.m. to discuss the design of the project. The public is encouraged to attend the project information event. For more information, please contact Missoula District Administrator Bob Vosen at (406) 523-5802 or Project Design Engineer Jacquelyn Smith at (406) 444-7694. Members of the public may submit written comments to the Montana Department of Transportation Missoula office at PO Box 7039, Missoula, MT 59807-7039, or online at: ww.mdt.mt.gov/mdt/comment_form.shtml. Rankin Elementary School Zone Speed Through collaboration between MDT and the City of Kalispell, along with community member support, a new speed limit of 25 MPH was established on Airport Road within the Rankin Elementary school zone. TSS installed signage to support the school zone speed change last week. 3.Parks and Recreation In response to the recent cold weather, the majority of park bathrooms have now been winterized and closed for the season. All park irrigation systems have been winterized as well. Over the past couple months, we have seen vandalism increasing within City Parks. Graffiti and destruction to concrete monument benches has kept staff busy making necessary repairs for the community to enjoy our parks. Our Forestry Crew will be pruning the trees along 8th Avenue West over the next few weeks. A contractor is in the final phases of pruning the trees along 5th Avenue West, North Main Street, and 1st Avenue East North. A new connecting segment of pedestrian/bicycle trail is currently being constructed along Highway 93 North, adjacent to the Kalispell Youth Athletic Complex. Funding for this project is from Montana Department of Transportation’s MAP21 grant. We had over 400 people show up to our free showing of The Sandlot on Friday, September 28. Due to inclement weather, we were forced to move from Woodland Park to an inside venue. Flathead High School graciously gave us the use of their new Boyle Gymnasium for the evening. The kids enjoyed the carnival atmosphere leading up to the 3 movie with two bouncy houses, an obstacle course, and other active games. Our sponsors, Park Side Credit Union, Performance Real Estate, Mann Mortgage, The Summit Medical Fitness Center, and Pepsi-Cola, were instrumental in putting on this event. Fall youth sports are in full swing. Fall into Soccer (K-4th grade) is in its final two weeks of the program and will finish on October 11. Our Little Dribblers basketball (K- 2nd grade) started on September 28 at Russell Elementary School. Our Little Squirts basketball (preschool) will be starting October 5 at Rankin Elementary. 4.Fire Department Since the last update, the Kalispell Fire Department has received 232 calls for service. October 6-12 is recognized as Fire Prevention Week. This year’s message “Not Every Hero Wears a Cape, Plan and Practice Your Escape!” highlights the importance of home fire escape plans and the basic behaviors that have life-saving impacts. Fire Department staff have started scheduling the FPW education outreach trainings encompassing the fire prevention puppet shows for 3rd grade students, other outreach trainings, and multiple station tours to emphasizing the importance of this year’s message. Fire department staff also began switching our operational readiness for winter operations. 5.Building Department In the last 2 weeks, we have issued permits for 8 single-family homes and 2 townhomes. This brings the total of new, single-family/duplex and townhouse units for the year to 113, compared to 96 last year at this time. The permits for the new 24-unit Glenwood Apartment Buildings A & B, located at 70 & 72 Glenwood Drive were issued. The combined value of both projects have an estimated value of $4 million and brings the total number of multi-family units for the year up to 80. Last year, at this time, we had issued permits for 66 multi-family units. The permit was issued for the Smith’s Pharmacy upgrade. The project is located inside the Smith’s Grocery Store at 195 - 3rd Ave EN. The project is valued at $150,000. The on-going commercial fire inspection program continues with properties along First Aves. East and West as our focus this month. Once completed, we will move to the Hutton Ranch area prior to the Christmas rush, then turn our focus to the annual school inspections over the Christmas break. 4 6.Planning Department The Kalispell Planning Board will meet on Tuesday, October 8 and hear a request by Siderius Construction, LLP to annex 3.9-acres into the City of Kalispell with an initial zoning of R-4 and major subdivision approval for a 12 lot (24 unit) townhouse subdivision. The property is located at 1702 South Woodland Drive. A work session will be held immediately following the regular meeting to discuss progress on the Kalispell pedestrian and bike plan. The Kalispell TAC (Technical Advisory Committee) met on Thursday, September 26 to hold the kickoff meeting with KLJ Engineering beginning the discussion of the Kalispell Bypass (US 93 South to Airport Road) Design project. KLJ was hired by the MDOT to initiate the process of designing the final leg of the Kalispell US 93 Bypass, more specifically the replacement of the current roundabouts at Airport Road and Siderius Road with bridge (interchange) structures. The next TAC meeting is scheduled for 1:30 p.m. in the Kalispell MDT offices on Wednesday, November 20, while a series of community meetings to begin the public scoping process will start on Thursday, November 21. MDT hopes to have a concept drawing by January with final design a year later and potential construction within 5 years. 7.Community Development Community Development has received draft Phase I Environmental Site Assessment Reports for the three CHS properties in Kalispell’s Core Area. The reports will be finalized over the next couple of weeks. These reports are done in preparation for the properties transferring ownership from CHS, Inc. to Flathead County Economic Development Authority (FCEDA). Additionally, Community Development has received a draft Phase I Environmental Site Assessment Report on the BNSF rail line property in Kalispell in preparation for the City’s acquisition of the property for construction of the Kalispell Trail. 8.Finance Department Certified Annual Financial Report For the 9th 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 2018 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 5 preparing the CAFR. Audit The finance department is working on the City’s fiscal year 2019 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 11th. First Quarter Finance Report Please find attached the printouts reflecting the activity for the 1st quarter of fiscal year 2020. This printout reflects payroll through Sept. 28, seven and a half pay periods, for biweekly employees. For fire and ambulance, this printout reflects payroll through Sept. 14, two and three quarter’s pay periods. 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/revenue at that time. This applies to the assessed funds as well. The Ambulance Fund 1st quarter fees for services is 27% of the annual budget or $195,613. This is an increase of about $25,000 when compared to the 1st quarter of fiscal year 2019. First quarter Building Department revenues of $203,630 are 29% of the annual budget. First quarter fiscal year 2019 revenues were over $250,000. Metered water sales are at 37% compared to 43% for the first quarter of fiscal year 2019. First quarter water sales are usually more than 25% due to summer and early fall sprinkling and irrigation. Sewer metered sales are at 27%, about the same as 1st quarter last fiscal year. Water, sewer and treatment impact fees remain strong in the first quarter and all are over 40% of the fiscal year 2020 budgeted amount. Storm, police and fire impact fees all exceed 25% of the annual budgeted amount. EXPENDITURES/EXPENSES: At this point in the year, the salary and retirement remaining should be about 75% in most funds (19.5 of 26 pay periods remaining). Some seasonal parks and rec salaries would be an exception. Fire and ambulance should have about 78% remaining in salaries and retirement (10.25 of 13 pay periods remaining). Health insurance reflects 3 months paid and should have about 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 6 revenue side for fees for services (Central Garage), internal services (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 ($164,888) and property insurance ($122,759) in August, this results in general government expenditures and some other fund 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 SIWOC/Sexual Assault 5 1 3 0 3 0 6 0 4 0 3 0 1 0 1 1 26 2 Robbery 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 Aggravated Assault 6 3 6 1 3 1 3 1 7 2 2 1 4 1 10 8 41 18 Assault on a Peace Officer 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 Simple Assault 7 4 5 6 12 6 16 11 10 2 8 5 9 5 18 10 85 49 PFMA 14 11 7 6 12 7 12 7 7 6 8 4 8 4 9 6 77 51 Resisting Arrest 4 5 3 2 3 2 1 1 1 1 8 8 2 1 3 3 25 23 Crimes Against Property Burglary 7 4 6 3 2 0 6 1 6 0 5 1 8 1 10 1 50 11 Theft 51 17 48 22 32 12 49 11 77 9 63 11 78 14 59 27 457 123 Vehicle Theft/Unauth Use 2 0 2 0 4 2 7 0 8 1 5 0 8 1 8 1 44 5 Arson 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Forgery/Counterfeit 1 0 5 0 9 2 4 1 8 0 0 0 4 0 3 0 34 3 Fraud 6 0 9 3 3 1 4 0 8 0 5 1 1 0 5 1 41 6 Theft of Identity 1 0 1 0 2 0 1 0 1 0 0 0 0 0 1 0 7 0 Embezzlement 1 1 0 0 2 2 1 1 1 0 0 1 1 0 0 0 6 5 Stolen Property offenses 1 1 2 0 2 0 0 0 2 0 1 0 3 0 5 3 16 4 Criminal Mischief 11 1 4 2 14 4 18 3 18 6 17 2 25 1 18 1 125 20 Crimes Against Society Weapon Law Violations 0 0 1 0 0 0 0 0 1 1 1 0 0 0 1 1 4 2 Prostitution Offenses 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Child Pornography 0 0 1 0 1 0 0 0 3 0 0 0 0 0 0 0 5 0 Drug Offenses 41 22 24 17 37 25 33 17 22 15 30 20 34 16 46 31 267 163 Family Offenses (non-violent)2 0 0 0 3 1 0 0 1 0 0 0 1 1 1 0 8 2 DUI 13 15 7 5 13 13 7 6 7 6 9 8 10 10 11 10 77 73 Possession of Alcohol 0 0 0 0 1 0 4 8 4 4 3 8 2 2 8 23 22 45 Provide Alcohol to Minor 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Other Alcohol Offenses 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Kidnapping/Custodial Int.1 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 3 1 Disorderly Conduct 4 2 6 3 7 7 6 4 7 5 7 5 5 5 3 3 45 34 Criminal Trespass 12 7 5 2 5 5 14 6 18 3 16 9 25 14 21 15 116 61 Violation of Protective Order 2 1 4 1 4 1 2 0 5 2 2 1 6 0 1 0 26 6 Obstructing a peace officer 9 10 7 4 9 8 10 10 5 3 8 9 8 6 9 11 65 61 Juvenile Offenses (except MIP)10 9 10 3 11 10 12 9 7 7 6 7 10 2 7 8 73 55 Other Offenses 49 49 48 48 53 48 38 35 38 37 48 45 39 40 53 52 366 354 Total 260 163 215 128 247 157 254 133 276 110 255 146 292 124 313 217 0 0 0 0 0 0 0 0 2112 1178 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 1045 602 615 422 736 468 739 423 962 612 742 457 529 379 644 501 6012 3864 Total Calls for Service Kalispell Police Department Case and Arrest Reports - 2019 January February March April May June July August September October November December Totals 3206 2734 2809 3040 3346 24659319430143316 THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 1 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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 87,370 6,380,000 6,292,630 99% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 0 16,500 16,500 100% 1000-000-311200-000 PERSONAL PROPERTY TAXES 177,607 150,000 27,607- -18% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 5,113 9,000 3,887 43% 1000-000-322101-000 LIQUOR LICENSES 0 33,000 33,000 100% 1000-000-322300-000 BUSINESS LICENSES 0 1,500 1,500 100% 1000-000-323012-000 PLANNING FEES 14,209 80,000 65,791 82% 1000-000-323109-000 SITE REVIEW 5,893 16,000 10,107 63% 1000-000-323200-000 PARADE PERMITS 0 1,000 1,000 100% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 400 400 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 0 63,000 63,000 100% 1000-000-335110-000 LIVE CARD TABLE PERMIT 0 1,400 1,400 100% 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 745,934 2,983,738 2,237,804 75% 1000-000-341020-000 ADMINISTRATIVE CHARGES 167,926 671,704 503,778 75% 1000-000-341021-000 GRANT ADMIN FEES 20,137 20,000 137--1% 1000-000-341025-000 CITY COLLECTIONS 6 5,000 4,994 100% 1000-000-342010-000 POLICE SERVICES 8,138 27,000 18,863 70% 1000-000-342014-000 RESOURCE OFFICERS 218,961 218,967 6 0% 1000-000-342016-000 KPD REGIONAL TRAINING 700 14,500 13,800 95% 1000-000-343018-000 PARKING PERMITS 26,696 95,000 68,304 72% 1000-000-343062-000 AIRPORT FUEL TAXES 1,153 4,000 2,847 71% 1000-000-343063-000 AIRPORT GROUND LEASE (HILTON) 14,855 14,500 355--2% 1000-000-351000-000 CITY COURT FINES & FEES 83,181 450,000 366,819 82% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 6,306 24,000 17,694 74% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 12,085 58,000 45,915 79% 1000-000-362015-000 INSURANCE REIMBURSEMENTS (FY20 MPOR 0 54,600 54,600 100% 1000-000-362020-000 MMIA GASB 54 REIMBURSEMENT 0 3,000 3,000 100% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 189 10,000 9,811 98% 1000-000-371010-000 INVESTMENT EARNINGS 19,204 45,000 25,796 57% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 0 925,000 925,000 100% ------------ ------------- ------------ ------------ TOTAL GENERAL FUND REVENUE 1,615,662 12,375,809 10,760,147 87% ============ ============= ============ ============ THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 2 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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 2,935 2,935 100% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 1,750 13,750 12,000 87% 1000-400-410530-354 OPEB EXPENSE 7,500 7,500 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 389 3,500 3,111 89% 1000-400-410560-312 POSTAGE 2,533 18,000 15,467 86% 1000-400-410560-320 PRINTING & ENVELOPES 1,439 4,000 2,561 64% 1000-400-410560-354 CONTRACT SERVICES - DOC. SHREDDING 128 1,000 873 87% 1000-400-410600-354 ELECTIONS 0 13,657 13,657 100% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 197 3,500 3,303 94% 1000-400-420000-354 CONTRACT 911 CENTER 0 534,000 534,000 100% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 0 350 350 100% 1000-400-430300-355 AIRPORT REIMBURSEMENT 16,428 18,500 2,072 11% 1000-400-460000-820 TFR TO FORESTRY (FY18/19) WESTSIDE 1,200,000 1,200,000 0 0% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 0 15,000 15,000 100% 1000-400-460452-366 HOCKADAY MAINTENANCE 0 6,600 6,600 100% 1000-400-510300-000 CONTINGENCY 0 530,000 530,000 100% 1000-400-510310-354 ICMA PLAN FEES 0 500 500 100% 1000-400-510330-513 LIABILITY INSURANCE 140,059 140,807 748 1% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 4,673 50,000 45,327 91% 1000-400-510330-517 PROPERTY INSURANCE 54,676 54,676 0- 0% ------------------------------------------------- SUBTOTAL GEN.GOV'T. 1,429,773 2,618,275 1,188,502 45% CITY MANAGER 1000-401-410210-110 SALARIES-CITY MANAGER'S OFFICE 37,027 149,741 112,714 75% 1000-401-410210-153 HEALTH INSURANCE 5,860 23,220 17,360 75% 1000-401-410210-155 RETIREMENT 3,886 15,887 12,001 76% 1000-401-410210-210 SUPPLIES 11 1,000 989 99% 1000-401-410210-312 NEWSLETTER/BOOKS 0 400 400 100% 1000-401-410210-345 TELEPHONE & COMMUNICATION 240 1,790 1,550 87% 1000-401-410210-373 DUES & TRAINING 649 10,500 9,851 94% 1000-401-410210-379 MEETINGS 929 4,500 3,571 79% ------------------------------------------------- SUBTOTAL CITY MANAGER 48,602 207,038 158,436 77% HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 32,560 137,409 104,849 76% 1000-401-410830-153 HEALTH INSURANCE 5,024 19,916 14,892 75% 1000-401-410830-155 RETIREMENT 2,698 10,868 8,170 75% 1000-401-410830-210 OFFICE SUPPLIES 417 600 183 30% 1000-401-410830-338 RECRUITMENT/RELOCATION 1,976 20,000 18,024 90% 1000-401-410830-354 CONTRACT SERVICES 270 1,000 730 73% 1000-401-410830-373 DUES & TRAINING 1,053 6,500 5,447 84% ------------------------------------------------- SUBTOTAL HUMAN RESOURCES 43,999 196,293 152,294 78% THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 3 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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,153 63,087 47,934 76% 1000-402-410100-153 HEALTH INSURANCE 12,774 55,457 42,683 77% 1000-402-410100-155 RETIREMENT 625 2,558 1,933 76% 1000-402-410100-210 OFFICE SUPPLIES 0 500 500 100% 1000-402-410100-335 MT LEAGUE OF CITIES 300 9,225 8,925 97% 1000-402-410100-354 CONTRACT SERVICES 373 13,000 12,627 97% 1000-402-410100-373 DUES & TRAINING 8,857 10,800 1,943 18% 1000-402-410100-379 MEETINGS 4,703 20,311 15,608 77% ------------------------------------------------- SUBTOTAL MAYOR/COUNCIL 42,784 174,938 132,154 76% CITY CLERK 1000-402-410150-110 SALARIES-CITY CLERK 23,718 97,169 73,451 76% 1000-402-410150-121 OVERTIME 0 250 250 100% 1000-402-410150-153 HEALTH INSURANCE 5,175 20,526 15,351 75% 1000-402-410150-155 RETIREMENT 1,910 7,732 5,822 75% 1000-402-410150-210 OFFICE SUPPLIES 0 300 300 100% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 70 600 530 88% 1000-402-410150-345 TELEPHONE & COMMUNICATION 160 480 320 67% 1000-402-410150-352 CODIFICATION 1,205 4,100 2,895 71% 1000-402-410150-354 CONTRACT SERVICES 0 300 300 100% 1000-402-410150-373 DUES & TRAINING 614 3,200 2,586 81% ------------------------------------------------- SUBTOTAL CITY CLERK 32,853 134,657 101,804 76% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES-FINANCE OFFICE 51,113 216,572 165,459 76% 1000-403-410550-121 OVERTIME 0 500 500 100% 1000-403-410550-153 HEALTH INSURANCE 9,766 36,794 27,028 73% 1000-403-410550-155 RETIREMENT 4,172 17,170 12,998 76% 1000-403-410550-210 SUPPLIES 116 1,000 884 88% 1000-403-410550-322 BOOKS 0 300 300 100% 1000-403-410550-353 CONTRACT SERVICES 80 500 420 84% 1000-403-410550-354 CONTRACT-GRIZZLY SECURITY 336 800 464 58% 1000-403-410550-355 BANK CHARGES & FEES 811 3,200 2,389 75% 1000-403-410550-373 DUES & TRAINING 1,235 7,500 6,265 84% ------------------------------------------------- SUBTOTAL FINANCE 67,629 284,336 216,707 76% THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 4 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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 94,476 442,839 348,363 79% 1000-404-411110-153 HEALTH INSURANCE 17,071 80,997 63,926 79% 1000-404-411110-155 RETIREMENT 7,601 35,232 27,631 78% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 127 2,563 2,436 95% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 7,770 17,000 9,230 54% 1000-404-411110-345 TELEPHONE & COMMUNICATION 115 1,025 910 89% 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 12,864 15,600 2,736 18% 1000-404-411110-373 DUES & TRAINING 1,780 8,000 6,220 78% ------------------------------------------------- SUBTOTAL CITY ATTORNEY 141,803 603,256 461,453 76% MUNICIPAL COURT 1000-406-410360-110 SALARIES-COURT 55,658 227,463 171,805 76% 1000-406-410360-121 OVERTIME 0 3,500 3,500 100% 1000-406-410360-153 HEALTH INSURANCE 11,225 38,585 27,360 71% 1000-406-410360-155 RETIREMENT 4,454 18,048 13,594 75% 1000-406-410360-210 SUPPLIES 0 4,500 4,500 100% 1000-406-410360-320 PRINTING/BOOKS 752 2,500 1,748 70% 1000-406-410360-345 TELEPHONE & COMMUNICATION 12 1,400 1,388 99% 1000-406-410360-353 SECURITY & TECHNOLOGY 3,699 40,000 36,301 91% 1000-406-410360-354 CONTRACT SERVICES 235 6,250 6,015 96% 1000-406-410360-373 DUES & TRAINING 1,020 10,000 8,980 90% 1000-406-410360-394 JURY & WITNESS FEES 143 7,500 7,357 98% ------------------------------------------------- SUBTOTAL COURT 77,198 359,746 282,548 79% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES-PUBLIC WORKS 4,687 18,839 14,152 75% 1000-410-430100-153 HEALTH INSURANCE 816 3,524 2,708 77% 1000-410-430100-155 RETIREMENT 372 1,467 1,095 75% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 2,304 14,000 11,696 84% 1000-410-430100-231 GAS 536 3,000 2,464 82% 1000-410-430100-345 TELEPHONE & COMMUNICATION 60 350 290 83% 1000-410-430100-354 CONTRACT SERVICES 0 2,000 2,000 100% 1000-410-430100-373 DUES & TRAINING 2,490 3,500 1,010 29% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 1,143 4,571 3,428 75% ------------------------------------------------- SUBTOTAL PUBLIC WORKS ADMIN 12,407 51,251 38,844 76% CITY HALL MAINT. 1000-412-411230-110 SALARIES-CITY HALL 14,010 72,913 58,903 81% 1000-412-411230-153 HEALTH INSURANCE 2,033 13,628 11,595 85% 1000-412-411230-155 RETIREMENT 1,080 5,544 4,464 81% 1000-412-411230-220 SECURITY IMPROVEMENTS 0 6,793 6,793 100% 1000-412-411230-224 JANITORIAL SUPPLIES 638 6,000 5,362 89% 1000-412-411230-241 TOOLS & SUPPLIES 485 1,500 1,015 68% 1000-412-411230-341 ELECTRICITY 9,663 45,000 35,337 79% 1000-412-411230-344 NATURAL GAS 0 32,000 32,000 100% 1000-412-411230-345 TELEPHONE & COMMUNICATION 55 400 345 86% 1000-412-411230-354 CONTRACT SERVICES 4,820 25,000 20,180 81% THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 5 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-355 HVAC MAINTENANCE OCNTRACT 16,710 16,500 210- -1% 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 0 6,000 6,000 100% 1000-412-411230-362 EQUIPMENT MAINTENANCE 96 10,000 9,904 99% 1000-412-411230-366 BUILDING MAINTENANCE 578 41,150 40,572 99% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 87 3,700 3,613 98% ------------------------------------------------- SUBTOTAL CITY HALL 50,255 286,128 235,873 82% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES-PLANNING & ZONING 69,772 283,588 213,816 75% 1000-420-411020-112 SALARIES - RETIRMENT 0 57,078 57,078 100% 1000-420-411020-153 HEALTH INSURANCE 13,669 56,122 42,453 76% 1000-420-411020-155 RETIREMENT 5,603 22,556 16,953 75% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 552 5,000 4,448 89% 1000-420-411020-231 GAS 45 400 355 89% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 247 2,000 1,753 88% 1000-420-411020-345 TELEPHONE 119 1,000 881 88% 1000-420-411020-354 CONTRACT SERVICES 63 2,000 1,937 97% 1000-420-411020-373 DUES & TRAINING 2,249 7,000 4,751 68% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 100 401 301 75% ------------------------------------------------- SUBTOTAL PLANNING DEPT. 92,419 437,145 344,726 79% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 16,416 67,380 50,964 76% 1000-480-470210-153 HEALTH INSURANCE 3,349 13,277 9,928 75% 1000-480-470210-155 RETIREMENT 1,323 5,325 4,002 75% 1000-480-470210-210 OFFICE SUPPLIES 72 1,000 928 93% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 0 750 750 100% 1000-480-470210-312 POSTAGE & PRINTING 90 500 410 82% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 500 500 0 0% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 110 750 640 85% 1000-480-470210-354 CONTRACT SERVICES 0 500 500 100% 1000-480-470210-373 DUES & TRAINING 1,597 5,000 3,403 68% 1000-480-470210-379 MEETINGS 160 1,500 1,340 89% ------------------------------------------------- SUBTOTAL COMMUNITY DEVELOPMENT 23,616 96,482 72,866 76% THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 6 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES-POLICE 605,953 2,399,735 1,793,782 75% 1000-413-420140-112 SALARIES-SEVERANCE 0 22,000 22,000 100% 1000-413-420140-114 SALARY -comptime buyout 2,355 13,600 11,245 83% 1000-413-420140-121 OVERTIME (REG & AET OT) 21,279 80,000 58,721 73% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 10,583 25,000 14,417 58% 1000-413-420140-153 HEALTH INSURANCE 109,589 465,977 356,388 76% 1000-413-420140-155 RETIREMENT 72,373 313,964 241,591 77% 1000-413-420140-210 OFFICE SUPPLIES 591 3,500 2,909 83% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 717 13,000 12,283 94% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 0 21,000 21,000 100% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 412 3,760 3,348 89% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 1,239 7,000 5,761 82% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 11 1,000 989 99% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 267 29,250 28,983 99% 1000-413-420140-227 AMMO & RELATED SUPPLIES 267 25,000 24,733 99% 1000-413-420140-228 PATROL CAR SUPPLIES 1,652 15,400 13,748 89% 1000-413-420140-229 OTHER SUPPLIES 431 5,000 4,569 91% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 260 1,000 740 74% 1000-413-420140-231 GAS 13,478 83,000 69,522 84% 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 271 5,500 5,229 95% 1000-413-420140-345 TELEPHONE & COMMUNICATION 3,593 19,000 15,407 81% 1000-413-420140-354 CONTRACT SERVICES 5,523 49,375 43,852 89% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 0 6,500 6,500 100% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 128 4,830 4,702 97% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 284 2,000 1,716 86% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 24,912 33,000 8,088 25% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 210 2,500 2,290 92% 1000-413-420140-373 DUES & TRAINING 13,689 46,000 32,311 70% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 392 14,500 14,108 97% 1000-413-420140-380 TRAINING MATERIALS 3,150 3,000 150- -5% 1000-413-420140-388 MEDICAL SERVICES 0 3,000 3,000 100% 1000-413-420140-392 BOARDING/TREATING PRISONERS 258 2,500 2,243 90% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 21,625 86,498 64,873 75% 1000-413-420140-530 RENT 930 8,520 7,590 89% 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 2,875 11,500 8,625 75% 1000-413-420140-944 VEHICLES 0 211,793 211,793 100% ------------------------------------------------- SUBTOTAL POLICE DEPT. 935,296 4,104,202 3,168,906 77% DETECTIVES 1000-413-420141-110 SALARIES-DETECTIVES 96,880 382,938 286,058 75% 1000-413-420141-121 DETECTIVE-OVERTIME 1,435 15,000 13,565 90% 1000-413-420141-153 HEALTH INSURANCE 19,279 81,839 62,560 76% 1000-413-420141-155 DETECTIVE-RETIREMENT 12,716 51,285 38,569 75% ------------------------------------------------- TOTAL DETECTIVES 130,311 531,062 400,751 75% RECORDS 1000-413-420142-110 SALARIES-RECORDS DIVISION 37,442 149,535 112,093 75% 1000-413-420142-121 OVERTIME 670 7,500 6,830 91% THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 7 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-153 HEALTH INSURANCE 8,516 44,050 35,534 81% 1000-413-420142-155 RETIREMENT 3,031 11,831 8,800 74% ------------------------------------------------- TOTAL RECORDS 49,659 212,916 163,257 77% RESOURCE OFFICERS 1000-413-420144-110 SALARIES-SRO 63,318 283,576 220,258 78% 1000-413-420144-153 HEALTH INSURANCE 12,877 42,175 29,298 69% 1000-413-420144-155 SRO RETIREMENT 8,468 38,062 29,594 78% ------------------------------------------------- TOTAL RESOURCE OFFICERS 84,664 363,813 279,149 77% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL-SALARIES 11,507 43,420 31,913 74% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 2,129 8,436 6,307 75% 1000-413-420145-155 RETIREMENT 844 3,434 2,590 75% ------------------------------------------------- SUBTOTAL ANIMAL CONTROL 14,480 55,790 41,310 74% PARKING 1000-413-420147-110 PARKINGS -SALARIES 20,886 83,263 62,377 75% 1000-413-420147-153 HEALTH INSURANCE 7,822 31,019 23,197 75% 1000-413-420147-155 RETIREMENT 1,616 6,584 4,968 75% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 0 4,000 4,000 100% 1000-413-420147-354 CONTRACTED SERVICES 113 2,000 1,887 94% 1000-413-420147-362 LOT MAINT 1,181 10,000 8,819 88% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 0 17,500 17,500 100% 1000-413-420147-550 LOT LEASE PAYMENTS 384 1,500 1,116 74% ------------------------------------------------- SUBTOTAL PARKING 32,003 155,866 123,863 79% ------------------------------------------------- SUBTOTAL POLICE DEPT. 1,246,412 5,423,649 4,177,237 77% THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 8 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES-FIRE SUPPRESSION 339,584 1,739,869 1,400,285 80% 1000-416-420400-114 COMPTIME BUYOUT 0 5,500 5,500 100% 1000-416-420400-115 OUT OF RANK PAY 3,113 12,500 9,387 75% 1000-416-420400-121 OVERTIME 9,012 40,000 30,988 77% 1000-416-420400-153 HEALTH INSURANCE 74,731 297,790 223,059 75% 1000-416-420400-155 RETIREMENT 44,687 227,035 182,348 80% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 0 4,000 4,000 100% 1000-416-420400-218 Equipment (Non Capital) 229 21,500 21,271 99% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 1,705 15,000 13,295 89% 1000-416-420400-224 JANITORIAL SUPPLIES 904 5,000 4,096 82% 1000-416-420400-231 GAS 1,677 17,325 15,648 90% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 475 15,750 15,275 97% 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 715 6,000 5,285 88% 1000-416-420400-354 CONTRACT SERVICES 11,235 20,390 9,155 45% 1000-416-420400-362 EQUIPMENT MAINTENANCE 449 5,500 5,051 92% 1000-416-420400-366 BUILDING MAINTENANCE-STATION 62 1,821 6,500 4,679 72% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 320 5,000 4,680 94% 1000-416-420400-373 DUES & TRAINING 3,643 10,000 6,357 64% 1000-416-420400-388 FIREFIGHTER PHYSICALS 1,773 27,475 25,702 94% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 8,416 33,663 25,247 75% 1000-416-420400-610 DEBT RETIREMENT-FIRE TRUCK 21,486 43,173 21,687 50% 1000-416-420400-620 INTEREST EXPENSE-FIRE TRUCK 7,256 14,633 7,377 50% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 70,000 280,000 210,000 75% 1000-416-420400-821 TRANSFER TO FUND 2956 GRANT MATCH 0 31,454 31,454 100% 1000-416-420400-940 EQUIPMENT - SCBA 12,097 44,546 32,449 73% 1000-416-420440-110 SALARIES-FIRE PREVENTION 5,138 21,459 16,321 76% 1000-416-420440-153 HEALTH INSURANCE 1,340 5,311 3,971 75% 1000-416-420440-155 RETIREMENT 395 1,583 1,188 75% ------------------------------------------------- SUBTOTAL FIRE DEPT. 622,200 2,959,406 2,337,206 79% ------------------------------------------------- GRAND TOTAL GENERAL FUND 3,931,950 13,832,600 9,900,650 72% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 9 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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 14,530 1,045,000 1,030,470 99% 2215-000-311200-000 PERSONAL PROPERTY TAXES 29,537 22,868 6,669- -29% 2215-000-312000-000 PEN & INTEREST DEL TAXES 742 2,000 1,258 63% 2215-000-335230-000 ENTITLEMENT SHARE PMT/HB 124 4,283 17,132 12,849 75% 2215-000-346030-000 SWIMMING POOL FEES 73,522 140,000 66,478 47% 2215-000-346040-000 CONCESSION STAND REVENUE 26,573 36,000 9,427 26% 2215-000-346050-000 PARKS USAGE FEES 6,452 20,000 13,548 68% 2215-000-346051-000 RECREATION FEES 4,197 20,033 15,836 79% 2215-000-346052-000 SPORTS PROGRAMS 17,410 59,480 42,070 71% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 9 2,000 1,991 100% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 10,612 56,000 45,388 81% 2215-000-346055-000 ICE RINK 0 20,000 20,000 100% 2215-000-346056-000 KIDSPORT USAGE 853 3,000 2,147 72% 2215-000-346057-000 YOUTH CAMPS 3,573 156,421 152,848 98% 2215-000-346059-000 PICNIC IN THE PARK 3,456 26,500 23,044 87% 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 171 0 171- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-371010-000 INVESTMENTS 2,911 5,500 2,589 47% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 0 95,000 95,000 100% ------------------------------------------------- TOTAL PARKS & REC REVENUE 198,832 1,746,934 1,548,102 89% ================================================= PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES-PARKS 82,748 336,666 253,918 75% 2215-436-460430-111 SEASONAL SALARIES 28,254 66,679 38,425 58% 2215-436-460430-121 OVERTIME 0 300 300 100% 2215-436-460430-153 HEALTH INSURANCE 15,136 61,999 46,863 76% 2215-436-460430-155 RETIREMENT 7,998 28,857 20,859 72% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 107 1,800 1,693 94% 2215-436-460430-215 EQUIPMENT - not capital 0 6,000 6,000 100% 2215-436-460430-224 JANITORIAL SUPPLIES 2,155 6,000 3,845 64% 2215-436-460430-229 OTHER SUPPLIES 538 10,000 9,462 95% 2215-436-460430-231 GAS 3,898 15,500 11,602 75% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 591 6,000 5,409 90% 2215-436-460430-320 PRINTING & ADVERTISING 166 200 34 17% 2215-436-460430-341 ELECTRICITY 2,834 14,000 11,166 80% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 0 20,000 20,000 100% 2215-436-460430-344 NATURAL GAS 0 2,500 2,500 100% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 352 2,800 2,448 87% 2215-436-460430-351 SPORTS COURT & BAND SHELL REHAB 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 240 15,000 14,760 98% 2215-436-460430-356 TRAIL STUDY 0 30,000 30,000 100% 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 0 1,193 1,193 100% 2215-436-460430-358 FVCC TENNIS INTERLOCAL AGREEMENT 0 7,000 7,000 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 943 10,500 9,557 91% 2215-436-460430-364 LANDSCAPING 167 6,000 5,833 97% THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 10 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-367 VANDALISM REPAIRS 320 4,000 3,680 92% 2215-436-460430-373 DUES & TRAINING 1,674 8,000 6,326 79% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 330 400 70 18% 2215-436-460430-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 2,000 9,000 7,000 78% 2215-436-460430-440 IRRIGATION SUPPLIES 1,852 7,500 5,648 75% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 901 1,500 599 40% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 9,742 38,968 29,226 75% 2215-436-460430-545 COUNTY LANDFILL 0 6,273 6,273 100% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 19,539 59,296 39,757 67% 2215-436-460430-620 DEBT SERVICE INTEREST 2,241 7,890 5,649 72% 2215-436-460430-932 PARK IMPROV - LIONS PK IRRIGATION 0 16,608 16,608 100% 2215-436-460430-941 TRUCK (FY 20) 0 38,000 38,000 100% ------------------------------------------------- SUBTOTAL PARKS EXPENDITURES 184,727 850,929 666,202 78% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES-COMPLEX 26,788 110,377 83,589 76% 2215-436-460440-111 SEASONAL SALARIES 19,919 38,917 18,998 49% 2215-436-460440-121 OVERTIME 0 300 300 100% 2215-436-460440-153 HEALTH INSURANCE 7,505 34,733 27,228 78% 2215-436-460440-155 RETIREMENT 3,144 10,009 6,865 69% 2215-436-460440-221 SAFETY EQUIPMENT 0 600 600 100% 2215-436-460440-229 OTHER SUPPLIES 5,516 22,000 16,484 75% 2215-436-460440-231 GAS 3,020 8,500 5,480 64% 2215-436-460440-241 CONSUMABLE TOOLS 427 2,000 1,573 79% 2215-436-460440-341 ELECTRICITY 3,302 9,500 6,198 65% 2215-436-460440-345 TELEPHONE & COMMUNICATION 38 240 202 84% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 183 800 617 77% 2215-436-460440-364 LANDSCAPING 14 600 586 98% 2215-436-460440-367 VANDALISM REPAIRS 0 500 500 100% 2215-436-460440-373 DUES & TRAINING 60 600 540 90% 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 0 200 200 100% 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 100% 2215-436-460440-420 METAL PRODUCTS 0 1,500 1,500 100% 2215-436-460440-440 IRRIGATION 2,195 7,000 4,805 69% 2215-436-460440-452 SAND & GRAVEL 911 1,200 289 24% 2215-436-460440-521 CENTRAL GARAGE TRANSFER 1,050 4,201 3,151 75% 2215-436-460440-545 COUNTY LANDFILL 0 3,400 3,400 100% ------------------------------------------------- SUBTOTAL ATHLETIC COMPLEX 74,071 258,327 184,256 71% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES-RECREATION 17,780 83,360 65,580 79% 2215-436-460431-111 SEASONAL SALARIES 1,689 10,065 8,376 83% 2215-436-460431-153 HEALTH INSURANCE 5,041 22,649 17,609 78% 2215-436-460431-155 RETIREMENT 1,420 7,304 5,884 81% 2215-436-460431-229 MISC. SUPPLIES 1,662 11,138 9,476 85% 2215-436-460431-231 GAS 29 584 555 95% 2215-436-460431-320 PRINTING & ADVERTISING 50 9,300 9,250 99% 2215-436-460431-345 TELEPHONE & COMMUNICATION 107 664 557 84% 2215-436-460431-354 CONTRACT SERVICES 21,460 27,550 6,090 22% 2215-436-460431-357 MUSIC FRANCHISE FEES 0 1,250 1,250 100% THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 11 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460431-373 DUES & TRAINING 169 700 531 76% ------------------------------------------------- SUBTOTAL RECREATION 49,406 174,564 125,158 72% YOUTH CAMPS 2215-436-460448-110 SALARIES-YOUTH CAMPS 15,443 73,603 58,160 79% 2215-436-460448-111 SEASONAL SALARIES 64,197 139,364 75,167 54% 2215-436-460448-121 OVERTIME 3 150 147 98% 2215-436-460448-153 HEALTH INSURANCE 4,828 21,805 16,977 78% 2215-436-460448-155 RETIREMENT 1,228 6,765 5,537 82% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 0 250 250 100% 2215-436-460448-229 MISC. SUPPLIES 1,244 3,520 2,276 65% 2215-436-460448-231 GAS 0 338 338 100% 2215-436-460448-320 PRINTING & ADVERTISING 0 295 295 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 126 1,352 1,226 91% 2215-436-460448-354 CONTRACT SERVICES 11,147 12,870 1,723 13% 2215-436-460448-355 AFTER SCHOOL PROGRAM 0 1,200 1,200 100% 2215-436-460448-356 BANK FEES/CC CHARGES 684 4,000 3,316 83% 2215-436-460448-373 DUES & TRAINING 169 700 531 76% ------------------------------------------------- SUBTOTAL YOUTH CAMPS 99,068 266,212 167,144 63% POOL 2215-437-460445-111 SEASONAL SALARIES-POOL 119,989 171,808 51,819 30% 2215-437-460445-121 OVERTIME 50 200 150 75% 2215-437-460445-155 RETIREMENT 163 1,500 1,337 89% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 124 500 376 75% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,568 2,000 432 22% 2215-437-460445-226 CHLORINE/CHEMICALS 20,781 26,500 5,719 22% 2215-437-460445-228 CONCESSION STAND SUPPLIES 12,207 20,000 7,793 39% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 533 4,000 3,467 87% 2215-437-460445-341 ELECTRICITY 3,782 9,000 5,218 58% 2215-437-460445-344 NATURAL GAS 8,888 21,500 12,612 59% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 529 2,550 2,021 79% 2215-437-460445-354 LICENSES & FEES 776 1,300 524 40% 2215-437-460445-356 BANK FEES/ CC CHARGES 1,814 3,200 1,386 43% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 10,249 18,095 7,846 43% 2215-437-460445-380 TRAINING MATERIALS 114 1,800 1,686 94% ------------------------------------------------- SUBTOTAL POOL EXPENDITURES 181,567 283,953 102,386 36% ------------------------------------------------- TOTAL PARKS & RECREATION/POOL 588,839 1,833,985 1,245,146 68% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 12 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING URBAN FORESTRY 2600-436-460433-110 SALARIES-URBAN FORESTRY 35,726 194,961 159,235 82% 2600-436-460433-111 SEASONAL SERVICES 9,240 40,963 31,723 77% 2600-436-460433-121 OVERTIME 33 1,000 967 97% 2600-436-460433-153 HEALTH INSURANCE 6,679 38,982 32,303 83% 2600-436-460433-155 RETIREMENT 3,249 18,128 14,879 82% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 1,679 3,600 1,921 53% 2600-436-460433-231 GAS 841 7,000 6,159 88% 2600-436-460433-241 CONSUMABLE TOOLS 156 11,100 10,944 99% 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 108 660 552 84% 2600-436-460433-354 CONTRACT SERVICES 24,505 150,000 125,495 84% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 9 4,000 3,991 100% 2600-436-460433-362 EQUIPMENT MAINTENANCE 170 4,000 3,830 96% 2600-436-460433-364 LANDSCAPING & TREES 285 8,000 7,715 96% 2600-436-460433-373 DUES & TRAINING 920 4,000 3,080 77% 2600-436-460433-395 EQUIPMENT RENTAL 0 6,000 6,000 100% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 2,959 4,000 1,042 26% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 1,960 7,840 5,880 75% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 5,278 21,110 15,832 75% 2600-436-460433-528 DATA PROCESSING TRANSFER 1,137 4,547 3,410 75% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 8,391 16,859 8,468 50% 2600-436-460433-620 INTEREST EXPENSE 742 1,496 754 50% ------------------------------------------------- TOTAL URBAN FORESTRY 104,067 548,246 444,179 81% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 13 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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 195,613 719,000 523,387 73% 2230-000-342070-000 COUNTY EMS LEVY 0 120,000 120,000 100% 2230-000-381050-000 INCEPTION OF LEASE 0 190,000 190,000 100% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 70,000 280,000 210,000 75% ------------------------------------------------- TOTAL AMBULANCE REVENUE 265,613 1,309,000 1,043,387 80% ================================================= AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 139,760 682,105 542,345 80% 2230-440-420730-114 COMPTIME BUYBACK 0 3,500 3,500 100% 2230-440-420730-115 OUT OF RANK PAY 584 2,500 1,916 77% 2230-440-420730-121 OVERTIME 12,942 30,000 17,058 57% 2230-440-420730-153 HEALTH INSURANCE 36,463 145,660 109,198 75% 2230-440-420730-155 RETIREMENT 18,060 88,145 70,085 80% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 15 3,400 3,385 100% 2230-440-420730-218 NON-CAPITAL EQUIPMENT 0 4,200 4,200 100% 2230-440-420730-231 GAS & OIL 999 7,560 6,561 87% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 42 4,000 3,958 99% 2230-440-420730-312 POSTAGE/PRINTING 0 1,000 1,000 100% 2230-440-420730-345 TELEPHONE & COMMUNICATION 162 1,700 1,538 90% 2230-440-420730-354 CONTRACT SERVICES 1,025 19,990 18,965 95% 2230-440-420730-355 911 CENTER CONTRIBUTION 0 36,600 36,600 100% 2230-440-420730-359 AUDIT/CC OTHER FEES 608 1,650 1,042 63% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 2,352 5,000 2,648 53% 2230-440-420730-373 DUES & TRAINING 0 5,000 5,000 100% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 263- 2,500 2,763 111% 2230-440-420730-391 MEDICAL TREATMENT-SUPPLIES 9,466 51,241 41,775 82% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 8,555 8,555 0 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 4,502 18,009 13,507 75% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 11,819 47,276 35,457 75% 2230-440-420730-528 DATA PROCESSING TRANSFER 4,547 18,189 13,642 75% 2230-440-420730-610 PRINCIPAL - AMBULANCE 0 19,000 19,000 100% 2230-440-420730-620 INTEREST - AMBULANCE 0 3,202 3,202 100% 2230-440-420730-943 AMBULANCE 0 190,000 190,000 100% ------------------------------------------------- TOTAL AMBULANCE EXPENDITURES 251,637 1,399,982 1,148,345 82% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 14 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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 4,293 10,000 5,707 57% 2399-000-341073-000 FIRE IMPACT FEES 44,499 150,000 105,501 70% 2399-000-371010-000 INVESTMENT EARNINGS 5,068 13,000 7,932 61% ------------------------------------------------- TOTAL PS IMPACT FEE REV 53,860 173,000 119,140 69% ================================================= PUBLIC SAFETY IMPACT FEE EXP 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 2,500 10,000 7,500 75% 2399-413-420140-940 POLICE EQUIPMENT 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 860,000 857,500 100% ================================================= FIRE & HAZMAT GRANTS 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 1,600 6,000 4,400 73% 2956-416-420415-940 AFG GRT FY20 SCBA 0 346,000 346,000 100% ------------------------------------------------- TOTAL FIRE GRANTS 1,600 352,000 350,400 100% ================================================= 2957-416-420410-125 PASS THRU HAZMAT OT 155 4,000 3,845 96% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 110 12,000 11,890 99% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 2,500 2,500 100% ------------------------------------------------- TOTAL HAZMAT GRANTS 265 18,500 18,235 99% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 15 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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 129,419 400,000 270,581 68% 2394-000-323103-000 PLUMBING PERMITS 8,211 35,000 26,790 77% 2394-000-323104-000 MECHANICAL PERMITS 13,487 35,000 21,513 61% 2394-000-323105-000 ELECTRICAL PERMITS 16,413 60,000 43,587 73% 2394-000-323108-000 PLAN REVIEW FEES 27,780 160,000 132,220 83% 2394-000-371010-000 INVESTMENT EARNINGS 8,321 18,000 9,679 54% ------------------------------------------------- TOTAL REVENUE 203,630 708,000 504,370 71% ================================================= BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES-BUILDING DEPT. 126,814 520,711 393,897 76% 2394-420-420530-112 SALARIES-SEVERANCE 0 55,872 55,872 100% 2394-420-420530-121 OVERTIME 5,475 20,000 14,525 73% 2394-420-420530-153 HEALTH INSURANCE 23,717 95,503 71,786 75% 2394-420-420530-155 RETIREMENT 10,242 39,529 29,287 74% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 5,192 20,000 14,808 74% 2394-420-420530-231 GAS & OIL 610 5,000 4,390 88% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 2,771 7,300 4,529 62% 2394-420-420530-323 ST. ED. ASSESSMENTS 0 7,500 7,500 100% 2394-420-420530-345 TELEPHONE & COMMUNICATION 1,262 6,000 4,738 79% 2394-420-420530-353 AUDITING 0 4,500 4,500 100% 2394-420-420530-354 CONTRACT SERVICES 3,709 20,000 16,291 81% 2394-420-420530-355 CITY WORKS LICENSING FEE 16,757 16,000 757- -5% 2394-420-420530-356 ArcGIS SERVER UPGRADE LICENSE 2,500 6,000 3,500 58% 2394-420-420530-357 CREDIT CARD / PAYPAL FEES 1,766 15,000 13,234 88% 2394-420-420530-360 FURNITURE 0 4,000 4,000 100% 2394-420-420530-373 DUES & TRAINING 1,775 35,000 33,225 95% 2394-420-420530-510 PROPERTY INSURANCE 8,184 10,000 1,816 18% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 336 1,342 1,006 75% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 8,289 33,156 24,867 75% 2394-420-420530-528 DATA PROCESSING TRANSFER 7,958 31,831 23,873 75% 2394-420-420530-920 BUILDING IMPROVEMENTS 0 200,000 200,000 100% ------------------------------------------------- TOTAL BUILDING DEPT. 227,356 1,154,244 926,888 80% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 16 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 19,394 86,741 67,347 78% 2400-410-430263-153 HEALTH INSURANCE 2,955 15,533 12,578 81% 2400-410-430263-155 RETIREMENT 1,483 6,589 5,106 77% 2400-410-430263-244 STREET LIGHT SUPPLIES 193 18,000 17,807 99% 2400-410-430263-245 LUMINAIRES 0 30,000 30,000 100% 2400-410-430263-246 LED LUMINAIRE UPGRADE 0 32,655 32,655 100% 2400-410-430263-341 ELECTRICITY 25,853 182,000 156,147 86% 2400-410-430263-360 REPAIR & MAINT SERVICES 970 20,000 19,030 95% 2400-410-430263-373 DUES & TRAINING 54 1,000 946 95% 2400-410-430263-510 INSURANCE 1,232 1,500 268 18% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 3,864 15,457 11,593 75% ------------------------------------------------- TOTAL LIGHT MAINT. 56,000 409,475 353,475 86% ================================================= 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 5,370 114,683 109,313 95% 2420-421-430234-957 ALLEY PAVING 42,168 67,180 25,012 37% 2420-421-430240-231 GAS & OIL 5,168 42,000 36,832 88% 2420-421-430240-344 NATURAL GAS 0 6,800 6,800 100% 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 32,936 318,578 285,642 90% 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 9,136 53,000 43,864 83% 2420-421-430240-472 ASPHALT 8,893 40,000 31,107 78% 2420-421-430240-473 CRACK SEALING 0 14,500 14,500 100% 2420-421-430240-474 PAINT STRIPING MATERIALS 12,938 30,000 17,062 57% ------------------------------------------------- TOTAL GAS TAX 116,610 718,241 601,632 84% ================================================= BARSAA (GAS TAX) 2421-421-430240-354 PAVEMENT MAINTENANCE 320,331 420,000 99,669 24% ------------------------------------------------- TOTAL BARSAA 320,331 420,000 99,669 24% ================================================= 2825 MACI GRANT 2825-421-430240-940 EQUIPMENT 0 205,000 205,000 100% ------------------------------------------------- TOTAL MACI GRANT 0 205,000 205,000 100% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 17 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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. 183,727 805,569 621,842 77% 2500-421-430240-112 RETIREMENT-severance 7,693 0 7,693- 0% 2500-421-430240-121 OVERTIME 615 28,000 27,385 98% 2500-421-430240-153 HEALTH INSURANCE 42,015 177,425 135,410 76% 2500-421-430240-155 RETIREMENT 14,592 60,533 45,941 76% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 6,054 16,360 10,306 63% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 94 7,000 6,906 99% 2500-421-430240-220 OTHER SUPPLIES 711 4,500 3,789 84% 2500-421-430240-231 GAS & OIL 5,539 42,000 36,461 87% 2500-421-430240-341 ELECTRICITY 370 3,500 3,130 89% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 338 1,700 1,362 80% 2500-421-430240-354 CONTRACT SERVICES 1,814 22,500 20,686 92% 2500-421-430240-356 TRANSPORTATION PLAN 20,000 187,150 167,150 89% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 3,112 33,500 30,388 91% 2500-421-430240-366 BUILDING MAINTENANCE 2,585 26,375 23,790 90% 2500-421-430240-373 DUES & TRAINING 302 7,500 7,198 96% 2500-421-430240-388 MEDICAL SERVICES 145 1,000 855 86% 2500-421-430240-510 LIABILITY INSURANCE 30,260 30,260 0 0% 2500-421-430240-512 UNINSURED LOSS-DEDUCTIBLE 5,064 11,269 6,206 55% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 48,866 195,464 146,598 75% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 28,988 115,951 86,963 75% 2500-421-430240-528 DATA PROCESSING TRANSFER 3,548 14,191 10,643 75% 2500-421-430240-840 MACI GRANT MATCH - WTR/DE-ICER TRK 0 10,000 10,000 100% 2500-421-430240-953 SHOP COMPLEX PAVEMENT RESTORATION 906 4,678 3,772 81% 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 0 24,955 24,955 100% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 0 14,032 14,032 100% 2500-421-430244-354 PAVEMENT REPAIRS-PAVEMENT MNT FUNDS 355,831 873,166 517,335 59% 2500-421-430244-820 TRANSFER TO BaRSAA 5,000 20,000 15,000 75% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 0 158,000 158,000 100% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 100% ------------------------------------------------- TOTAL STREET MAINT. 768,167 2,924,406 2,156,239 74% ------------------------------------------------- SIGNS AND SIGNALS 2500-421-430264-110 TSS - SALARIES 25,797 103,256 77,459 75% 2500-421-430264-121 OVERTIME 0 7,500 7,500 100% 2500-421-430264-153 HEALTH INSURANCE 7,484 29,676 22,192 75% 2500-421-430264-155 RETIREMENT 1,951 7,685 5,734 75% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 281 3,775 3,494 93% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 709 6,700 5,991 89% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 198 3,500 3,302 94% 2500-421-430264-242 STREET SIGNS 7,661 30,000 22,339 74% 2500-421-430264-243 TRAFFIC SIGNALS 0 30,000 30,000 100% 2500-421-430264-245 BARRICADE MATERIALS 0 6,000 6,000 100% 2500-421-430264-341 ELECTRICITY 250 3,000 2,750 92% 2500-421-430264-345 COMMUNICATIONS 102 850 748 88% 2500-421-430264-354 CONTRACT SERVICES 430 10,000 9,570 96% 2500-421-430264-362 EQUIPMENT MAINTENANCE 300 3,000 2,700 90% 2500-421-430264-366 BUILDING MAINTENANCE 0 7,375 7,375 100% 2500-421-430264-373 DUES & TRAINING 175 7,000 6,825 98% 2500-421-430264-428 PAINT MATERIALS 359 5,000 4,641 93% THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 18 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500-421-430264-510 LIABILITY INS.-TSS 2,214 3,000 786 26% 2500-421-430264-512 UNINSURED LOSS-DEDUCTIBLE 0 2,777 2,777 100% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 1,875 7,502 5,627 75% 2500-421-430264-532 OFFICE RENT 0 6,422 6,422 100% 2500-421-430264-940 MACHINERY & EQUIPMENT 0 47,000 47,000 100% ------------------------------------------------- TOTAL SIGNS AND SIGNALS 49,787 331,018 281,231 85% ------------------------------------------------- TOTAL STREET MAINT. & SIGNS 817,954 3,255,424 2,437,470 75% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 19 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2188 WESTSIDE TIF REVENUE 2188-000-365010-000 MISC. REVENUE 2,645 575,000 572,355 100% 2188-000-371010-000 INVESTMENT EARNINGS 230 1,000 770 77% 2188-000-381060-000 TRANSFER FROM GENERAL FUND 1,200,000 1,200,000 0 0% ------------------------------------------------- TOTAL REVENUE 1,202,875 1,776,000 573,125 32% ================================================= EXPENDITURES 2188-480-470230-110 SALARIES 11,194 46,104 34,910 76% 2188-480-470230-153 HEALTH INSURANCE 2,177 9,381 7,204 77% 2188-480-470230-155 RETIREMENT 902 3,664 2,762 75% 2188-480-470230-353 AUDIT 0 3,000 3,000 100% 2188-480-470230-356 TELEPHONE 48 192 144 75% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 1,169 4,675 3,506 75% 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 413,132 1,500,000 1,086,868 72% 2188-480-470440-930 CITY MATCH - TRAIL 27,616 200,000 172,384 86% 2188-480-470440-935 CITY MATCH - RAIL PARK 4,012 28,455 24,443 86% ------------------------------------------------- TOTAL WESTSIDE TIF 460,251 1,795,471 1,335,220 74% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 20 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 0 1,600 1,600 100% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 3,396 13,584 10,188 75% 2185-000-430300-840 REDEVELOPMENT ACTIVITY 26,891 3,316,334 3,289,443 99% 2185-480-470240-110 SALARIES 5,221 21,321 16,100 76% 2185-480-470240-153 HEALTH INSURANCE 1,172 4,647 3,475 75% 2185-480-470240-155 RETIREMENT 421 1,703 1,282 75% 2185-480-470240-345 TELEPHONE & COMMUNICATION 12 48 36 75% ------------------------------------------------- TOTAL 2185 AIRPORT TIF 37,113 3,359,237 3,322,124 99% ================================================= OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 9,700 9,700 100% 2310-480-470210-356 FED-EX REIMBURSEMENT 0 9,200 9,200 100% 2310-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 0 45,000 45,000 100% 2311-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 0 5,000 5,000 100% ------------------------------------------------- TOTAL OLD SCHOOL TIFS 0 68,900 68,900 100% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 21 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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 0 1,000 1,000 100% 2880-480-470210-711 REDEVELOPMENT 0 225,000 225,000 100% ------------------------------------------------- TOTAL LOAN REVOLVING 0 227,000 227,000 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 250,000 250,000 100% ------------------------------------------------- TOTAL 2881 CD REV. #2 0 250,405 250,405 100% ================================================= 2886 CD MISC. 2886-480-470210-210 OFFICE SUPPLIES 0 2,000 2,000 100% 2886-480-470210-353 AUDITING 0 1,000 1,000 100% 2886-480-470210-373 DUES & TRAINING 0 2,000 2,000 100% 2886-480-470210-379 MEETINGS 0 1,000 1,000 100% 2886-480-470210-396 STUDIES/SURVEYS & MARKETING 0 5,000 5,000 100% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 500 2,000 1,500 75% 2886-480-470210-528 DATA PROCESSING TRANSFER 2,274 9,094 6,820 75% 2886-480-470210-532 OFFICE RENT 0 646 646 100% 2886-480-470210-790 REDEVELOPMENT ACTIVITY 0 4,000 4,000 100% ------------------------------------------------- TOTAL CD MISC. 2,774 26,740 23,966 90% ================================================= 2887 RURAL DEVELOPMENT #1 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 0 18,826 18,826 100% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 0 3,248 3,248 100% 2887-480-470210-750 REDEVELOPMENT LOANS 0 400,000 400,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #1 0 422,074 422,074 100% ================================================= 2888 RURAL DEVELOPMENT #2 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 0 8,384 8,384 100% 2888-480-470210-620 INTEREST EXPENSE-USDA LOAN 61-03 0 1,641 1,641 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.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 22 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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 200 185,592 185,392 100% 2953-480-470210-373 TRAVEL/PETROLEUM 200 1,943 1,743 90% 2953-480-470215-354 CONT SERV/HAZARDOUS 1,358 37,108 35,751 96% 2953-480-470215-373 TRAVEL/HAZARDOUS 0 1,958 1,958 100% ------------------------------------------------- TOTAL EPA BROWNSFIELD 1,758 226,601 224,844 99% ================================================= 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES-PETROLEUM 0 219,251 219,251 100% 2955-480-470210-725 REVOLVED FUNDS-PETROLEUM 0 100,500 100,500 100% 2955-480-470215-229 SUPPLIES-HAZARDOUS SUBSTANCES 0 267,673 267,673 100% ------------------------------------------------- TOTAL BROWNFIELDS LOAN REV. 0 587,424 587,424 100% ================================================= 2991 TIGER GRANT 2991-480-470245-790 REDEVELOPMENT - TRAIL 0 3,803,909 3,803,909 100% ------------------------------------------------- TOTAL TIGER GRANT 0 3,803,909 3,803,909 100% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 23 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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% ------------------------------------------------- TOTAL 2915 STONEGARDEN GRANT 0 10,000 10,000 100% ================================================= 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 14,791 65,117 50,326 77% 2916-413-420140-121 OVERTIME 5,203 8,000 2,797 35% 2916-413-420140-153 HEALTH INSURANCE 2,903 11,934 9,031 76% 2916-413-420140-155 RETIREMENT 1,930 8,751 6,821 78% 2916-413-420140-354 CONTRACT SERVICES 0 7,800 7,800 100% ------------------------------------------------- TOTAL 2916 DRUG ENFORCEMENT 24,826 101,602 76,776 76% ================================================= 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 312 4,000 3,688 92% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 2,938 36,000 33,062 92% 2919-413-420140-127 SCHOOL DIST. OT 1,054 20,000 18,946 95% 2919-413-420140-220 EQUIPMENT-FUNDED BY DONATIONS 0 4,000 4,000 100% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 0 7,000 7,000 100% ------------------------------------------------- TOTAL LAW ENF. GRANT 4,304 71,000 66,696 94% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 24 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CAPITAL PROJECT FUNDS 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION 0 25,000 25,000 100% ------------------------------------------------- TOTAL 4290 WALK & CURB 0 25,000 25,000 100% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 25 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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 180 1,000 820 82% 5210-000-343210-000 METERED WATER SALES 1,121,870 3,000,000 1,878,130 63% 5210-000-343220-000 UNMETERED WATER SALES 8,785 15,000 6,215 41% 5210-000-343230-000 METER REPLACEMENT FEE 27,687 100,000 72,313 72% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 16,770 55,000 38,230 70% 5210-000-343270-000 WATER TURN ON FEES 1,825 4,000 2,175 54% 5210-000-343275-000 TAG FEE 12,880 45,000 32,120 71% 5210-000-371010-000 INVESTMENT EARNINGS 44,267 105,000 60,733 58% 5210-000-383010-000 TRANSFER FROM IMPACT FEE FUN (10100 6,250 25,000 18,750 75% 5210-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 56,250 309,058 252,808 82% ------------------------------------------------- TOTAL WATER REVENUE 1,296,764 3,659,058 2,362,294 65% ================================================= WATER FACILITIES 5210-447-430550-110 SALARIES-WATER 158,763 774,817 616,054 80% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 2,963 20,000 17,037 85% 5210-447-430550-153 HEALTH INSURANCE 35,054 174,095 139,041 80% 5210-447-430550-155 RETIREMENT 12,358 58,417 46,059 79% 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 4,626 22,000 17,374 79% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 940 8,500 7,561 89% 5210-447-430550-226 CHLORINE & CHEMICALS 16,601 39,000 22,399 57% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 766 4,500 3,734 83% 5210-447-430550-231 GAS & OIL 6,049 35,000 28,951 83% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 285 1,000 715 71% 5210-447-430550-336 LICENSES & FEES 0 18,500 18,500 100% 5210-447-430550-341 ELECTRICITY 37,034 160,000 122,966 77% 5210-447-430550-344 NATURAL GAS 177 15,500 15,323 99% 5210-447-430550-345 TELEPHONE & COMMUNICATION 2,109 11,000 8,891 81% 5210-447-430550-349 LAB SERVICES 3,230 20,000 16,770 84% 5210-447-430550-353 AUDITING 0 3,500 3,500 100% 5210-447-430550-354 CONTRACT SERVICES 6,406 55,000 48,594 88% 5210-447-430550-355 NOFFSINGER TRANSMISSION CONDITION A 0 255,000 255,000 100% 5210-447-430550-356 CONSULTANTS 4,107 125,000 120,893 97% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 0 15,000 15,000 100% 5210-447-430550-366 BUILDING MAINTENANCE 5,004 16,375 11,371 69% 5210-447-430550-373 DUES & TRAINING 3,230 11,000 7,770 71% 5210-447-430550-388 MEDICAL SERVICES 580 600 20 3% 5210-447-430550-410 CONSTRUCTION MATERIALS 3,787 35,000 31,213 89% 5210-447-430550-422 HYDRANTS 0 10,000 10,000 100% 5210-447-430550-423 MATERIALS FOR MAINS 203 14,000 13,797 99% 5210-447-430550-424 MATERIALS -SERVICE LINES 1,111 12,000 10,889 91% 5210-447-430550-425 MATERIALS PUMPS/WELLS 585 45,000 44,415 99% 5210-447-430550-510 PROPERTY & LIABILITY INS. 33,256 33,256 0- 0% 5210-447-430550-512 UNINSURED LOSS-DEDUCTIBLE 0 10,000 10,000 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 6,750 27,002 20,252 75% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 30,517 122,069 91,552 75% 5210-447-430550-528 DATA PROCESSING TRANSFER 8,278 33,112 24,834 75% 5210-447-430550-532 LEASE PAYMENTS 0 10,500 10,500 100% 5210-447-430550-939 FOUR MILE TRANSMISSION MAIN (PHASE 39 4,239,062 4,239,023 100% 5210-447-430550-940 MACHINERY & EQUIPMENT 0 45,000 45,000 100% THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 26 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-948 METERS (METER FUNDS) 010125 24,778 151,263 126,486 84% 5210-447-430550-950 1ST AVE WN MAIN REPLACEMENT 5,895 210,213 204,318 97% 5210-447-430550-951 SECURITY SCADA UPGRADES 0 305,000 305,000 100% 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 906 4,578 3,672 80% 5210-447-430550-968 CONRAD DRIVE 189,662 246,511 56,849 23% 5210-447-430550-971 10TH AVE W & 2ND ST W MAIN 0 535,000 535,000 100% ------------------------------------------------- SUBTOTAL WATER FACILITIES 606,050 7,937,370 7,331,320 92% ------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES-WATER BILLING 28,976 117,187 88,212 75% 5210-447-430560-153 HEALTH INSURANCE 9,624 36,809 27,185 74% 5210-447-430560-155 RETIREMENT 2,305 9,182 6,877 75% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 1,412 7,000 5,588 80% 5210-447-430560-353 AUDITING 0 2,000 2,000 100% 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 9,667 40,000 30,333 76% 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 4,228 27,000 22,772 84% 5210-447-430560-356 OTHER CONTRACT SERVICES 28 1,500 1,473 98% 5210-447-430560-373 DUES & TRAINING 0 2,500 2,500 100% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 2,815 11,259 8,444 75% 5210-447-430560-528 DATA PROCESSING TRANSFER 8,278 33,112 24,834 75% 5210-447-430560-532 RENT 0 6,422 6,422 100% ------------------------------------------------- SUBTOTAL WATER BILLING 67,331 293,971 226,640 77% ------------------------------------------------- REVENUE BONDS 5210-447-490200-610 PRIN - 4 MILE DR TRANSMISSION / WRF 0 78,521 78,521 100% 5210-447-490200-620 INT - 4 MILE DR TRANSMISSION / WRF 0 50,538 50,538 100% 5210-447-490204-610 BOND PRIN - HWY 93 S WTR - 2004 0 75,000 75,000 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 19,643 19,643 1 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% 4T ST WTR 0 89,000 89,000 100% 5210-447-490206-620 INT-WELL&TANK/8114 2.25% 4TH ST WT 16,830 16,831 1 0% 5210-447-490210-610 4TH AVE E MAIN REPLC/WRF 17393 0 80,126 80,126 100% 5210-447-490210-620 4TH AVE E MAIN REPL/WFR 17393 45,052 45,052 0- 0% 5210-447-490250-610 PRIN - WTR MAIN/ WRF 1032R 2% IDAHO 0 50,000 50,000 100% 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2%/IDAHO&MAIN 1,270 1,270 0 0% ------------------------------------------------- SUBTOTAL REVENUE BONDS 83,145 506,331 423,186 84% ------------------------------------------------- DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 840,000 840,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 840,000 840,000 100% ------------------------------------------------- TOTAL WATER FUND 756,526 9,577,672 8,821,146 92% ================================================= WATER IMPACT FEE REVENUE: 5211-000-343225-000 IMPACT FEES 216,730 500,000 283,270 57% THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 27 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5211-000-371010-000 INTEREST EARNINGS 5,875 15,000 9,125 61% ------------------------------------------------- TOTAL WATER IMPACT FEES REVENU 222,604 515,000 292,396 57% ================================================= WATER IMPACT FEES EXPENSES: 5211-447-430555-820 DEBT SERVICE TRANSFER TO 5210 56,250 309,058 252,808 82% 5211-447-430555-825 TRANSFER TO 5210 FOR ADMIN 6,250 25,000 18,750 75% 5211-447-430555-930 CONTRACT MAIN UPSIDE 0 440,000 440,000 100% 5211-447-430555-932 ELEVATED STORAGE TANK AND WELL 0 448,000 448,000 100% 5211-447-430555-939 FOUR MILE DR TRANSMISSION MAIN (PH. 0 223,948 223,948 100% 5211-447-430555-941 METERS - NEW DEVELOPMENT 19,903 45,600 25,698 56% 5211-447-430555-953 SECTION 36 WELL 5,910 184,453 178,543 97% ------------------------------------------------- TOTAL WATER IMPACT FEE EXPENSE 88,313 1,676,059 1,587,746 95% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 28 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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 180 1,500 1,320 88% 5310-000-343310-000 SEWER SERVICE CHARGES 1,206,043 4,500,000 3,293,957 73% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 0 4,000 4,000 100% 5310-000-343365-000 LATECOMER ADMIN FEES 67 4,500 4,433 99% 5310-000-371010-000 INVESTMENT EARNINGS 31,127 66,500 35,373 53% 5310-000-383010-000 ADMIN TRANSFER FROM IMPACT FEES 12,500 50,000 37,500 75% 5310-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 220,000 891,026 671,026 75% ------------------------------------------------- TOTAL SEWER REVENUE 1,469,917 5,517,526 4,047,609 73% ================================================= SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES-SEWER BILLING 24,661 99,549 74,888 75% 5310-454-430620-153 HEALTH INSURANCE 7,386 27,602 20,216 73% 5310-454-430620-155 RETIREMENT 1,956 7,778 5,822 75% 5310-454-430620-215 OFFICE SUPPLIES/computers 1,412 7,000 5,588 80% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 0 2,000 2,000 100% 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 9,667 40,000 30,333 76% 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 4,228 27,000 22,772 84% 5310-454-430620-356 OTHER CONTRACT SERVICES 28 1,500 1,473 98% 5310-454-430620-373 DUES & TRAINING 0 2,500 2,500 100% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 2,530 10,119 7,589 75% 5310-454-430620-528 DATA PROCESSING TRANSFER 8,278 33,112 24,834 75% 5310-454-430620-532 OFFICE RENT 0 6,422 6,422 100% ------------------------------------------------- SUBTOTAL SEWER BILLING COSTS 60,145 264,582 204,437 77% ------------------------------------------------- SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES-SANITARY SEWER 70,432 297,006 226,574 76% 5310-454-430630-121 OVERTIME 383 5,500 5,117 93% 5310-454-430630-153 HEALTH INSURANCE 15,855 80,197 64,342 80% 5310-454-430630-155 RETIREMENT 5,420 22,509 17,089 76% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 5,075 12,200 7,125 58% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 1,164 8,350 7,186 86% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 300 2,300 2,000 87% 5310-454-430630-231 GAS & OIL 1,746 12,000 10,254 85% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 0 500 500 100% 5310-454-430630-341 ELECTRICITY 6,794 57,000 50,206 88% 5310-454-430630-344 NATURAL GAS 1,607 16,500 14,893 90% 5310-454-430630-345 TELEPHONE & COMMUNICATION 7,218 26,000 18,782 72% 5310-454-430630-353 AUDITING 0 3,000 3,000 100% 5310-454-430630-354 CONTRACT SERVICES 5,417 24,000 18,583 77% 5310-454-430630-356 CONSULTANTS - FACILITY PLAN 4,107 185,000 180,893 98% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 2,753 11,375 8,622 76% 5310-454-430630-373 DUES & TRAINING 4,080 7,250 3,170 44% 5310-454-430630-388 MEDICAL SERVICES 0 500 500 100% 5310-454-430630-410 CONSTRUCTION MATERIALS 6,365 10,000 3,635 36% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 14,788 50,000 35,212 70% 5310-454-430630-510 PROPERTY & LIABILITY INS. 39,301 42,000 2,699 6% 5310-454-430630-512 UNINSURED LOSS-DEDUCTIBLE 0 25,000 25,000 100% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 2,359 9,435 7,076 75% THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 29 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-522 ADMINISTRATIVE TRANSFER 12,214 48,854 36,640 75% 5310-454-430630-528 DATA PROCESSING TRANSFER 4,730 18,921 14,191 75% 5310-454-430630-532 OFFICE RENT 6,494 6,422 72- -1% 5310-454-430630-940 MACHINERY & EQUIPMENT 0 43,500 43,500 100% 5310-454-430630-948 REPAIR & REPLC OF SEWER MAIN 0 600,000 600,000 100% 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 906 4,673 3,767 81% 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 0 20,000 20,000 100% 5310-454-430630-957 WEST SIDE INTERCEPTOR (BONDED) 0 2,783,478 2,783,478 100% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 1,980 50,000 48,020 96% 5310-454-430630-962 SEWER MAIN SLIP LINING 0 395,000 395,000 100% ------------------------------------------------- SUBTOTAL SEWER COLLECTION 221,488 4,878,470 4,656,982 95% ------------------------------------------------- REVENUE BONDS/SANITARY 5310-454-490200-610 PRIN - WESTSIDE INTERCEPTOR BOND 0 326,000 326,000 100% 5310-454-490200-620 INTEREST-WESTSIDE INTERCEPTOR BOND 340,025 340,026 1 0% 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.25% 0 87,000 87,000 100% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 9,709 9,709 0 0% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25% 0 350 350 100% ------------------------------------------------- SUBTOTAL REVENUE BONDS 349,734 763,085 413,351 54% ------------------------------------------------- DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 820,000 820,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION-SANITARY 0 820,000 820,000 100% ------------------------------------------------- SUBTOTAL SANITARY SEWER 571,222 6,461,555 5,890,333 91% ------------------------------------------------- WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 105,179 454,195 349,016 77% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-121 OVERTIME 5,338 22,500 17,162 76% 5310-455-430640-153 HEALTH INSURANCE 21,878 90,736 68,858 76% 5310-455-430640-155 RETIREMENT 8,493 34,152 25,659 75% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 4,565 10,000 5,435 54% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 0 2,700 2,700 100% 5310-455-430640-225 ALUM 0 28,000 28,000 100% 5310-455-430640-226 CHLORINE & CHEMICALS 23,570 87,000 63,430 73% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 3,328 7,000 3,672 52% 5310-455-430640-231 GAS & OIL 1,757 19,000 17,243 91% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 0 400 400 100% 5310-455-430640-336 LICENSES & FEES 0 12,000 12,000 100% 5310-455-430640-341 ELECTRICITY 32,101 190,000 157,899 83% 5310-455-430640-342 WATER 1,281 7,500 6,219 83% 5310-455-430640-344 NATURAL GAS 0 82,000 82,000 100% 5310-455-430640-345 TELEPHONE & COMMUNICATION 1,439 6,500 5,061 78% 5310-455-430640-353 AUDITING 0 2,500 2,500 100% 5310-455-430640-354 CONTRACT-GLACIER GOLD 23,017 135,000 111,983 83% 5310-455-430640-355 OTHER CONTRACT SERVICES 7,714 39,000 31,286 80% THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 30 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-356 CONSULTANTS 22,744 210,960 188,216 89% 5310-455-430640-358 CONSULTANT-FACILITY PLN/RATE STDY/T 4,107 175,000 170,893 98% 5310-455-430640-360 MISC. MAINT SERVICES 5,099 30,000 24,901 83% 5310-455-430640-366 BUILDING MAINTENANCE 4,000 46,000 42,000 91% 5310-455-430640-373 DUES & TRAINING 2,989 8,500 5,511 65% 5310-455-430640-388 MEDICAL SERVICES 0 500 500 100% 5310-455-430640-510 PROPERTY & LIABILITY INS. 41,697 42,000 303 1% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 4,805 19,219 14,414 75% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 30,676 122,705 92,029 75% 5310-455-430640-528 DATA PROCESSING TRANSFER 5,913 23,651 17,738 75% 5310-455-430640-920 TWAS ROOF REPLC 0 13,412 13,412 100% 5310-455-430640-930 BIOSOLIDS ALTERNATE DISPOSAL ENG 0 178,052 178,052 100% ------------------------------------------------- SUBTOTAL WWTP OPERATIONS 361,690 2,105,182 1,743,492 83% ------------------------------------------------- WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 25,376 118,000 92,624 79% 5310-455-430645-921 E. SECONDARY CLARIFIER COATING PRJ 0 75,000 75,000 100% 5310-455-430645-934 SECONDARY DIGESTER LID REPLC 276,905 530,648 253,744 48% 5310-455-430645-940 MACHINERY & EQUIPMENT 0 125,500 125,500 100% ------------------------------------------------- SUBTOTAL WWTP REPLACEMENT 302,280 849,148 546,868 64% ------------------------------------------------- WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 27,816 115,308 87,492 76% 5310-455-430646-153 HEALTH INSURANCE 4,258 16,872 12,614 75% 5310-455-430646-155 RETIREMENT 2,125 8,589 6,464 75% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 2,233 4,500 2,267 50% 5310-455-430646-218 NON-CAPITAL EQUIPMENT 0 2,500 2,500 100% 5310-455-430646-222 LAB SUPPLIES 3,316 16,500 13,184 80% 5310-455-430646-349 LAB SERVICES 2,393 30,000 27,607 92% 5310-455-430646-362 EQUIPMENT MAINTENANCE 3,504 5,500 1,996 36% 5310-455-430646-373 DUES & TRAINING 0 4,700 4,700 100% ------------------------------------------------- SUBTOTAL WWTP LAB OPERATIONS 45,646 204,469 158,823 78% DEBT SERVICE - WWTP 5310-455-490227-610 PRIN - WWTP IMP/SRF8164R/2.25% 0 851,000 851,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 161,156 161,157 1 0% 5310-455-490228-610 PRIN-WWTP DIGESTER LID/SRF 13326 0 48,000 48,000 100% 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 24,510 24,510 0 0% ------------------------------------------------- SUBTOTAL DEBT SERVICE - WWTP 185,666 1,084,667 899,001 83% ------------------------------------------------- CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-830 EVERGREEN REPLACEMENT TRANSFER 0 420,000 420,000 100% 5310-455-510400-831 DEPRECIATION EXPENSE 0 1,425,000 1,425,000 100% ------------------------------------------------- SUTOTAL WWTP DEPRECIATION/REPL 0 1,845,000 1,845,000 100% ------------------------------------------------- SUBTOTAL WWTP 895,282 6,088,466 5,193,184 85% THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 31 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ------------------------------------------------- TOTAL BILLING/SANITARY/WWTP 1,526,649 12,814,603 11,287,954 88% ================================================= SEWER IMPACT FEE REVENUE 5311-000-343330-000 SANITARY IMPACT FEES 375,170 600,000 224,830 37% 5311-000-343335-000 TREATMENT IMPACT FEES 210,111 400,000 189,889 47% 5311-000-371010-000 SANITARY INTEREST EARNINGS 10,280 20,000 9,720 49% 5311-000-371015-000 TREATMENT INTEREST EARNINGS 7,617 20,000 12,383 62% ------------------------------------------------- TOTAL SEWER IMPACT FEES REVENU 603,178 1,040,000 436,822 42% ================================================= SEWER IMPACT FEE EXPENSES 5311-454-430635-820 TRANSFER TO 5310 FOR DEBT 166,000 666,026 500,026 75% 5311-454-430635-825 TRANSFER TO 5310 FOR ADMIN 7,500 30,000 22,500 75% 5311-454-430635-955 MAIN & L.S. UPSIZE 0 300,000 300,000 100% 5311-454-430635-957 WEST SIDE INTERCEPTOR 37,971 151,487 113,516 75% 5311-455-430644-820 DEBT SERVICE TRANSFER 54,000 225,000 171,000 76% 5311-455-430644-825 TRANSFER TO 5310 FOR ADMIN 5,000 20,000 15,000 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% ------------------------------------------------- TOTAL SEWER IMPACT FEE EXPENSE 270,471 1,976,150 1,705,679 86% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 32 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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 180 0 180- 0% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 0 1,500 1,500 100% 5349-000-343034-000 PERMIT FEES 675 0 675- 0% 5349-000-343035-000 STORM SEWER CHARGES 0 1,500 1,500 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 0 1,625,000 1,625,000 100% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 1,426 1,800 374 21% 5349-000-371010-000 INTEREST ON INVESTMENTS 11,710 35,000 23,290 67% 5349-000-383010-000 IMPACT FEE 5% ADMIN - TFR FROM IMPA 1,625 6,500 4,875 75% 5349-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 0 175,568 175,568 100% ------------------------------------------------- TOTAL STORM REVENUE 15,616 1,846,868 1,831,252 99% ================================================= STORM SEWER 5349-453-430246-110 SALARIES-STORM SEWER 113,293 476,323 363,030 76% 5349-453-430246-121 OVERTIME 390 4,000 3,610 90% 5349-453-430246-153 HEALTH INSURANCE 22,255 97,207 74,952 77% 5349-453-430246-155 RETIREMENT 8,744 36,107 27,363 76% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 10,259 16,100 5,841 36% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 0 6,000 6,000 100% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100% 5349-453-430246-231 GAS & OIL 1,451 11,500 10,049 87% 5349-453-430246-345 TELEPHONE & COMMUNICATION 464 1,500 1,036 69% 5349-453-430246-353 AUDITING 0 1,150 1,150 100% 5349-453-430246-354 CONTRACT SERVICE 1,573 7,000 5,427 78% 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 2,500 2,500 100% 5349-453-430246-362 GROUNDWATER MONITORING 1,764 6,500 4,736 73% 5349-453-430246-371 CURB & GUTTER 0 6,000 6,000 100% 5349-453-430246-373 DUES & TRAINING 2,160 7,250 5,090 70% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 0 10,000 10,000 100% 5349-453-430246-510 PROPERTY & LIABILITY INS. 9,329 16,000 6,671 42% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 2,359 9,435 7,076 75% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 11,283 45,133 33,850 75% 5349-453-430246-528 DATA PROCESSING TRANSFER 4,730 18,921 14,191 75% 5349-453-430246-530 BNSF LEASE PMT 0 6,200 6,200 100% 5349-453-430246-532 OFFICE RENT 0 6,422 6,422 100% 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 0 367,647 367,647 100% 5349-453-430246-970 REGIONAL FACILITIES & PIPING DESIGN 0 5,500,000 5,500,000 100% 5349-453-430247-952 STORM DRAIN CORRECTION 0 249,323 249,323 100% 5349-453-430247-953 SHOP COMPLEX PAVEMNT 4,463 23,008 18,545 81% 5349-453-430247-954 N. MAIN ST STORMWATER PROJ. 0 252,500 252,500 100% 5349-453-430247-956 WYOMING STREET OUTFALL 0 225,000 225,000 100% 5349-453-430247-959 REGIONAL FACILITIES & PIPING DESIGN 0 400,000 400,000 100% 5349-453-430247-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% 5349-453-430249-940 MACHINERY FROM REPLACEMENT 0 56,500 56,500 100% 5349-453-490200-610 PRINCIPLE - 4TH AVE E BOND 0 2,918 2,918 100% 5349-453-490200-620 INTEREST-4TH AVE E BOND 1,641 1,641 0 0% 5349-453-490225-610 PRINCIPLE - REGIONAL FACILITIES 0 72,061 72,061 100% 5349-453-490225-620 INTEREST - REGIONAL FACILITIES 0 103,507 103,507 100% THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 33 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 285,000 285,000 100% ------------------------------------------------- TOTAL STORM 196,159 8,557,653 8,361,494 98% ================================================= STORM SEWER IMPACT FEE REVENUE 5348-000-343033-000 IMPACT FEES 33,298 130,000 96,702 74% 5348-000-371010-000 INTEREST EARNINGS 9,304 15,000 5,696 38% ------------------------------------------------- TOTAL STORM IMPACT FEES REVENU 42,602 145,000 102,398 71% ================================================= STORM SWR IMPACT FEE EXPENSES 5348-453-430248-820 DEBT SERVICE TRANSFER TO 5349 0 175,568 175,568 100% 5348-453-430248-825 TRANSFER TO 5349 FOR ADMIN 1,625 6,500 4,875 75% 5348-453-430248-959 REG FACILITIES & PIPING DESIGN 71,369 1,414,852 1,343,483 95% 5348-453-430248-960 STORMWATER FACILITIES UPSIZE 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 72,994 1,876,920 1,803,926 96% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 34 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION-ASSESSED 0 1,022,000 1,022,000 100% 5510-000-343420-000 GARBAGE COLLECTION-BILLED 468 23,500 23,032 98% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,062 2,100 1,038 49% 5510-000-371010-000 INVESTMENT EARNINGS 5,851 15,000 9,149 61% ------------------------------------------------- TOTAL SOLID WASTE REVENUE 7,382 1,062,600 1,055,218 99% ================================================= SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES-SOLID WASTE 100,958 428,543 327,585 76% 5510-460-430840-121 OVERTIME 297 6,500 6,203 95% 5510-460-430840-153 HEALTH INSURANCE 23,053 101,080 78,027 77% 5510-460-430840-155 RETIREMENT 7,615 32,232 24,617 76% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 5,098 14,500 9,402 65% 5510-460-430840-218 EQUIPMENT-GARBAGE CONTAINERS 9 37,500 37,491 100% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 100 5,500 5,400 98% 5510-460-430840-231 GAS & OIL 8,965 60,000 51,035 85% 5510-460-430840-341 ELECTRICITY 212 2,050 1,838 90% 5510-460-430840-344 NATURAL GAS 0 4,500 4,500 100% 5510-460-430840-345 TELEPHONE & COMMUNICATION 336 1,250 914 73% 5510-460-430840-354 CONTRACT SERVICES 2,351 20,000 17,649 88% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 0 5,700 5,700 100% 5510-460-430840-366 BUILDING MAINTENANCE 2,455 8,875 6,420 72% 5510-460-430840-373 DUES & TRAINING 55 5,500 5,445 99% 5510-460-430840-388 MEDICAL SERVICES 580 650 70 11% 5510-460-430840-510 PROPERTY & LIABILITY INS. 12,539 12,539 0 0% 5510-460-430840-512 UNINSURED LOSS-DEDUCTIBLE 0 4,000 4,000 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 18,112 72,450 54,338 75% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 11,162 44,649 33,487 75% 5510-460-430840-528 DATA PROCESSING TRANSFER 3,548 14,191 10,643 75% 5510-460-430840-532 OFFICE RENT 0 6,422 6,422 100% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 10,000 40,000 30,000 75% 5510-460-430840-944 VEHICLES (Replacement $) 0 260,000 260,000 100% 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 906 4,673 3,767 81% 5510-460-430845-224 JANITORIAL SUPPLIES 90 500 410 82% 5510-460-430845-341 ELECTRICITY 262 3,500 3,238 93% 5510-460-430845-342 WATER 63 2,000 1,937 97% 5510-460-430845-344 NATURAL GAS 0 6,000 6,000 100% 5510-460-430845-360 REPAIR & MAINT SERVICES 0 6,000 6,000 100% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% ------------------------------------------------- TOTAL SOLID WASTE EXPENSE 208,767 1,361,304 1,152,537 85% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 35 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 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 46,250 140,000 93,750 67% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 0 225,000 225,000 100% 6030-000-371010-000 INVESTMENT EARNINGS 943 1,300 357 27% 6030-000-393000-000 INTERNAL SERVICES-DATA 65,583 262,331 196,748 75% ------------------------------------------------- TOTAL INFORMATION TECH REVENUE 112,776 628,631 515,855 82% ================================================= INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 47,047 189,303 142,256 75% 6030-401-410580-121 OVERTIME 51 1,000 949 95% 6030-401-410580-153 HEALTH INSURANCE 8,992 32,742 23,750 73% 6030-401-410580-155 RETIREMENT 3,791 15,017 11,226 75% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 57 2,300 2,243 98% 6030-403-410580-215 COMPUTER SUPPLIES 525 2,000 1,475 74% 6030-403-410580-218 EQUIPMENT-NOT CAPITAL 5,656 22,840 17,184 75% 6030-403-410580-325 WEBSITE 15,123 16,450 1,327 8% 6030-403-410580-345 PAGER/PHONE 215 900 685 76% 6030-403-410580-346 SUMMITNET & ISPS 1,671 28,140 26,469 94% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,597 4,000 403 10% 6030-403-410580-354 MAINTENANCE CONTRACTS 1,372 45,000 43,628 97% 6030-403-410580-355 LICENSES 4,236 20,185 15,949 79% 6030-403-410580-356 MAINTENANCE CONTRACTS 16,371 60,300 43,929 73% 6030-403-410580-357 GRANICUS 5,280 5,300 20 0% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 989 61,011 60,022 98% 6030-403-410580-373 DUES & TRAINING 526 8,275 7,749 94% 6030-403-410580-510 INSURANCE 2,017 3,000 983 33% 6030-403-410583-218 TV-Video Equipment & programming 113 7,000 6,887 98% 6030-403-410585-229 COPIER,FAX, SUPPLIES 1,506 18,870 17,364 92% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 18,475 122,000 103,525 85% 6030-403-410585-532 COPIER LEASES 4,032 15,160 11,128 73% 6030-403-410585-942 Servers - capital contingency 0 71,000 71,000 100% 6030-403-510400-831 DEPRECIATION EXPENSE 0 10,000 10,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 170 3,870 3,700 96% 6030-405-410588-940 NETWORK EQUIPMENT 0 28,000 28,000 100% 6030-410-410588-218 COMPUTERS - DPW 4,160 4,440 280 6% 6030-413-410588-218 COMPUTERS - POLICE DEPT 962 28,150 27,188 97% 6030-413-410588-354 POLICE - HOSTED SERVER 413 2,400 1,987 83% 6030-416-410588-218 COMPUTERS - FIRE 113 16,870 16,757 99% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 0 2,300 2,300 100% 6030-436-410588-218 COMPUTERS - PARKS 0 4,000 4,000 100% 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 1,870 1,870 100% ------------------------------------------------- TOTAL INFORMATION TECH EXPENSE 147,462 853,693 706,231 83% ================================================= THE CITY OF KALISPELL, MONTANA10.02.2019 13:48 gb8501_pg.php/Job No: 13405 Page 36 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru September 30 25.00 % Yr Complete For Fiscal Year: 2020 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 134,000 536,000 402,000 75% 6010-000-371010-000 INVESTMENT EARNINGS 774 1,000 226 23% ------------------------------------------------- TOTAL CENTRAL GARAGE REVENUE 134,774 537,000 402,226 75% ================================================= CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 42,885 162,350 119,465 74% 6010-410-431330-121 OVERTIME 226 2,500 2,274 91% 6010-410-431330-153 HEALTH INSURANCE 9,951 42,455 32,504 77% 6010-410-431330-155 RETIREMENT 2,981 12,130 9,149 75% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 887 11,000 10,113 92% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 374 8,000 7,626 95% 6010-410-431330-230 OIL 3,473 25,000 21,527 86% 6010-410-431330-231 GAS 144 1,500 1,356 90% 6010-410-431330-232 VEHICLE PARTS 26,243 126,000 99,757 79% 6010-410-431330-233 TIRES 15,322 50,000 34,678 69% 6010-410-431330-238 FILTERS 1,183 8,500 7,317 86% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 648 2,000 1,352 68% 6010-410-431330-341 ELECTRICITY 273 1,950 1,677 86% 6010-410-431330-344 NATURAL GAS 0 6,500 6,500 100% 6010-410-431330-354 CONTRACT SERVICES 3,364 32,000 28,636 89% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 0 126,375 126,375 100% 6010-410-431330-373 DUES & TRAINING 1,953 7,500 5,547 74% 6010-410-431330-388 MEDICAL SERVICES 0 425 425 100% 6010-410-431330-510 INSURANCE 3,041 4,500 1,459 32% 6010-410-431330-528 INFORMATION TECH TRANSFER 2,365 9,460 7,095 75% 6010-410-431330-921 PARTS WASHER 0 10,500 10,500 100% ------------------------------------------------- TOTAL CENTRAL GARAGE EXPENSES 115,313 650,645 535,332 82% =================================================