The URL can be used to link to this page

01-17-20 City Manager Report1 City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 1/17/2020 1. Parks Department The last Christmas tree pickup will be Saturday, January 25. We once again would like to thank our volunteer group for helping our community collect the trees. Christmas trees will be chipped and repurposed. We have one forestry crew that is continuing to prune on 3rd Avenue East with a second crew moving to the Cottonwood and Blue Herron subdivisions to do some train pruning as they have completed work in Northview Heights. Park crews completed 136 work orders in 2019. Work orders usually come from special requests for work above the normal routine of parks operations. We had a great turnout for our annual FHS Cheerleading Camp on January 11. The girls worked hard and did a wonderful job at the varsity basketball halftime performance. Special thanks to the Flathead coaches and cheerleaders for their enthusiasm and dedication to help get the camp participants ready to perform. We are half way through our ice skating lessons at the Woodland Ice Center. These introductory lessons allow skaters with little to no skating experience to build confidence while learning to skate. We still have spots available for Session 3 (starting January 21) and Session 4 (starting February 4). Our winter youth sports leagues start in the next few weeks. Kalispell Kickers (indoor soccer for preschool thru 4th grade) starts on Saturday, January 25 at Rankin Elementary School. Our Little Squirts Basketball league for 4-5 year olds starts the following Saturday (February 1) at Elrod Elementary School. 2 2.Police Department Attached is the end of year activity report. In 2019, K9 Cairo and handle Officer Jason Parce conducted 52 search warrants, conducted 53 searches, completed 10 Agency Assist, and referred 61 cases for prosecution. These cases resulted in excess of $62,000 in street value drugs being seized by the Kalispell Police Department. Officer Parce’s work is supported by over 200 hours of training in the last year. Detectives finished 2019 investigating 572 Felony cases. The Kalispell Police Department responded to 36,000 calls for service in 2019. This compares to 34,909 in 2018, 33,744 in 2017. Chief Overman, Sheriff Heino, and Officer Cory Clarke completed an on-site visit with the Gallatin County Sheriff and Bozeman Chief of Police on the embedded social worker program. Valuable insight was gained on lessons learned while implementing the program. Western Montana Mental health and Flathead County have received a grant for the corresponding social worker. The program should begin early this spring and assist Law Enforcement with mental health calls. 3.Fire Department Since the last update, the Kalispell Fire Department has received 130 calls for service. Fire department staff member and Hazardous materials team member Firefighter Hansen recently attended a USDOT sponsored AWR-140 Radiation Nuclear Awareness train the trainer course in Billings. This course is generally offered to those who work within fire/ medical and emergency response services. This course presents a radiological/nuclear WMD overview consisting of ionizing radiation fundamentals, terminology, health effects, and recognition factors. Fire department staff are finalizing and submitting year-end demographics and data as required for our reporting purposes. Fire department Paramedics are also completing their required testing for their Pediatric Advance Life Support (PALS) certifications this week. 4.Planning Department The Planning Board met on January 14 and heard a request from Spartan Holdings, LLC for a PUD and major preliminary plat application within the B-2/PUD and RA-2/PUD Zones. The subject property is located at 2890 Highway 93 North, generally bound by the Stillwater River on the west and south, U.S. 93 North on the east and Northern Pines Golf Course and Falkor Defense on the north. The Board did unanimously recommend approval of the two requests after lengthy discussion and that recommendation will be 3 forwarded onto the Council for their consideration at the February 3, 2020 meeting. 5.Building Department In the last 2 weeks, we have issued permits for 1 single-family home and 6 townhomes. That will bring the total of new single-family/duplex and townhouse units for the year to 7, compared to 0 last year at this time. At the end of 2019, the building department had issued permits for a total of 84 Multi-family units. At this time, for 2020, we have not issued any permits for Multi-family units, however there are currently two large Multi- family projects under review; The Crossings located on Two Mile drive which would contain 324 units on full build out and Frontier Village located at Treeline Drive which would contain 126 units at full build out. There were a total of 97 building inspections completed in the last 2 weeks. Residential – 50 Plumbing - 6 Commercial – 9 Mechanical - 15 Electrical – 12 Fire - 5 Fire/Life Safety Fire/Life Safety inspections were conducted at the following school locations; Flathead HS, Kalispell Middle School, Glacier HS, Hedges, Peterson, Elrod, Russel, Rankin, Linderman and Edgerton. These inspections were conducted during the 2019 Christmas/New Year’s break. Our Fire/Life Safety inspectors continue to work with the district on remedying issues that were found. During the month of December, there were a total of 148 Fire/Life Safety Inspections and 9 re-inspections completed. 6.Community Development The City has filed for a one-year extension of its Notice of Interim Trail Use (NITU) permit period with the Surface Transportation Board. The City of Kalispell and BNSF have completed negotiations for the railbanking and sale agreement so the time extension simply allows for completion of the required steps for the sale to close. Staff will be working with WGM group on Task Orders necessary to complete the planning, permitting, design, bidding, and construction administration of the Airport/18th Street urban renewal project recently approved by the Council via Ordinance 1835. The goal is to have the project BID and under contract this Spring. 7.Public Works Annual Bio-Solids Report The City of Kalispell Wastewater Treatment Plant maintains and operates Bio-Solids 4 Disposal under the regulatory oversight of United States Environmental Protection Agency (EPA). Annually, staff reports the amounts of bio-solids generated at the Kalispell WWTP by completing and sending in a “Bio-Solids Report Form”. The report consists of reporting production of bio-solids in dry metric tons. In 2019, the WWTP process generated 626 dry metric tons of bio-solids, 433 dry metric tons were delivered to Glacier Gold LLC for composting, and 183 dry metric tons went to the Flathead County Solid Waste Landfill. Traffic Signs and Signal Sign Inventory TSS staff has been populating an assets management program with Kalispell’s sign inventory. The asset management program allows staff to track and record activities and costs associated with sign installation and maintenance. 8.Finance Department Quarterly Finance Report Attached, please find the printouts reflecting the activity for the 1st half of fiscal year 2020. This printout reflects payroll earned thru Dec. 21, 2019, and accounts payable claims received by the end of December. All funds are included with the exception of the debt service funds. REVENUE: General Fund tax revenue reflects taxes collected thru December 31. Some first half taxes received by the County aren’t distributed to the City until the County completes the distribution in January. The City has not yet received the January distribution. Last year, the general fund received almost $700,000 of first half taxes in January. A similar 5 distribution this January would bring collections to about 56% of the fiscal year 2020 budgeted amount of $6,380,000. The City is currently carrying less than $18,000 in protest taxes in the General Fund - protest tax dollars are held by the County. Liquor licenses are billed once a year and are due by June 30. City Court fines and fees revenue only reflects July thru November (5 months). Parks tax revenues should be about 56% after the County’s January distribution. Youth camps revenue, and many of the other user based parks fees, historically receives more of their revenue in the 2nd half of the fiscal year (spring). Ambulance fees for services ($393,824) are up over 27% from last year ($308,201). The first half of the County EMS levy has not yet been received. Inception of lease (BOI loan) is for the purchase of an ambulance and may be carried over to fiscal year 2021. Building department permits and fees are outpacing the budgeted annual amounts. The approximately $370,000 of permits and fees collected in the first half of this fiscal year is about 53% of the annual budget. Metered water sales thru December were $1,816,914, a decrease from last fiscal first half of about 8%. It is normal for July thru December metered water sales to be in excess of 50%, normally about 60%, of the annual amount because of late summer and fall sprinkling and irrigation. The decrease from fiscal year 2019 water revenue can be attributed to the hot and dry summer that was experienced in Northwest Montana in 2018. Water impact fees are over 65% of the fiscal year 2020 budgeted amount of $500,000. Sewer service charges were $2,293,079, just over half (51%) of the budgeted amount. Last year’s 1st half sewer service charges were $2,339,398. Sanitary sewer and treatment plant impact fees are both over 80% of the anticipated fiscal year 2020 amount. Storm sewer and Solid Waste revenue reflect assessments billed for fiscal year 2020. Actual assessments collected for the storm sewer fund are about $700,000, and for the solid waste fund are just over $440,000. These amounts do not include the January distribution from the County. The January distribution of first half assessment collections should bring total collections to excess of 50% of the annual budget for both of these funds. Storm impact fees ($71,392) are 55% of the budgeted fiscal year 2020 amount. EXPENDITURES/EXPENSES: General Fund expenditures reflect 47% spent. Some major expenditures such as liability and property insurance are paid during the first quarter for the entire year. This can result in expenditures not being evenly distributed over the fiscal period. For most funds, expenditures/expenses include the 13th (25 of 52 weeks) payroll period 6 ending December 21st. Most departments and/or funds have over 52% remaining in the salaries and retirement lines which should be adequate. The majority of fire department and ambulance fund employees are paid 13 times annually. This 1st half report includes the 6th of 13 (23 of 52 weeks/44%) pay periods for these employees. Health insurance is paid 12 times per year and includes 5 months (42%) on this report for all funds. With a few exceptions, administrative, central garage, and information technology transfers are done monthly and should show 50% remaining. This is the same on the revenue side for fees for services (Central Garage), internal services (Information Technology), administrative charges (General Fund), and many of the transfers between funds. The general fund administrative charges may vary slightly as some charges are based on a percentage of revenues collected. Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Crimes Against Persons Homicide 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 SIWOC/Sexual Assault 5 1 3 0 3 0 6 0 4 0 3 0 1 0 1 1 7 1 6 0 8 0 5 0 52 3 Robbery 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 2 0 Aggravated Assault 6 3 6 1 3 1 3 1 7 2 2 1 4 1 10 8 2 0 9 3 4 3 3 5 59 29 Assault on a Peace Officer 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 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 6 3 9 3 10 2 7 1 117 58 PFMA 14 11 7 6 12 7 12 7 7 6 8 4 8 4 10 6 10 7 8 6 10 7 6 4 112 75 Resisting Arrest 4 5 3 2 3 2 1 1 1 1 8 8 2 1 3 3 3 3 5 5 4 3 4 4 41 38 Crimes Against Property Burglary 7 4 6 3 2 0 6 1 6 0 5 1 8 1 10 1 8 1 4 0 2 0 7 0 71 12 Theft 51 17 48 22 32 12 49 11 77 9 63 11 78 14 63 27 69 17 81 25 83 32 61 27 755 224 Vehicle Theft/Unauth Use 2 0 2 0 4 2 7 0 8 1 5 0 8 1 8 1 0 0 7 1 6 0 3 0 60 6 Arson 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 Forgery/Counterfeit 1 0 5 0 9 2 4 1 8 0 0 0 4 0 3 0 9 1 15 1 7 0 11 0 76 5 Fraud 6 0 9 3 3 1 4 0 8 0 5 1 1 0 6 1 8 1 5 1 4 1 9 4 68 13 Theft of Identity 1 0 1 0 2 0 1 0 1 0 0 0 0 0 1 0 1 0 0 0 1 0 0 0 9 0 Embezzlement 1 1 0 0 2 2 1 1 1 0 0 1 1 0 0 0 1 0 0 0 0 1 1 0 8 6 Stolen Property offenses 1 1 2 0 2 0 0 0 2 0 1 0 3 0 5 3 3 1 5 4 2 1 6 3 32 13 Criminal Mischief 11 1 4 2 14 4 18 3 18 6 17 2 25 1 18 1 14 3 14 0 8 1 18 2 179 26 Crimes Against Society Weapon Law Violations 0 0 1 0 0 0 0 0 1 1 1 0 0 0 1 1 1 1 0 0 0 0 0 0 5 3 Prostitution Offenses 0 0 0 0 0 0 0 0 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 0 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 47 31 42 19 36 19 40 28 26 16 412 245 Family Offenses (non-violent)2 0 0 0 3 1 0 0 1 0 0 0 1 1 1 0 0 0 0 0 1 0 1 0 10 2 DUI 13 15 7 5 13 13 7 6 7 6 9 8 10 10 11 10 7 7 10 9 5 5 4 4 103 98 Possession of Alcohol 0 0 0 0 1 0 4 8 4 4 3 8 2 2 8 23 2 4 8 7 9 12 3 3 44 71 Provide Alcohol to Minor 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 1 2 Other Alcohol Offenses 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 3 2 0 0 5 4 Kidnapping/Custodial Int.1 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1 0 0 0 0 0 4 1 Disorderly Conduct 4 2 6 3 7 7 6 4 7 5 7 5 5 5 4 3 5 4 7 6 9 9 12 7 79 60 Criminal Trespass 12 7 5 2 5 5 14 6 18 3 16 9 25 14 21 15 18 9 19 10 24 10 24 7 201 97 Violation of Protective Order 2 1 4 1 4 1 2 0 5 2 2 1 6 0 1 0 2 1 6 2 11 3 5 7 50 19 Obstructing a peace officer 9 10 7 4 9 8 10 10 5 3 8 9 8 6 9 11 9 6 11 8 8 3 7 7 100 85 Juvenile Offenses (except MIP)10 9 10 3 11 10 12 9 7 7 6 7 10 2 7 8 4 2 3 2 8 6 8 6 96 71 Other Offenses 49 49 48 48 53 48 38 35 38 37 48 45 39 40 53 52 41 38 46 43 38 37 39 35 530 507 Total 260 163 215 128 247 157 254 133 276 110 255 146 292 124 321 217 272 129 318 157 306 166 272 144 3288 1774 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 579 447 556 420 437 302 614 390 8198 5423 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 2875 36001319430143316301028942563 THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 1 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 2,891,137 6,380,000 3,488,863 55% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 9,078 16,500 7,422 45% 1000-000-311200-000 PERSONAL PROPERTY TAXES 176,646 150,000 26,646- -18% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 5,554 9,000 3,446 38% 1000-000-322101-000 LIQUOR LICENSES 0 33,000 33,000 100% 1000-000-322300-000 BUSINESS LICENSES 1,141 1,500 359 24% 1000-000-323012-000 PLANNING FEES 32,504 80,000 47,496 59% 1000-000-323109-000 SITE REVIEW 8,875 16,000 7,125 45% 1000-000-323200-000 PARADE PERMITS 200 1,000 800 80% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 400 400 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 57,700 63,000 5,300 8% 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,250 1,400 150 11% 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 1,491,869 2,983,738 1,491,869 50% 1000-000-341020-000 ADMINISTRATIVE CHARGES 335,352 671,704 336,352 50% 1000-000-341021-000 GRANT ADMIN FEES 23,059 20,000 3,059- -15% 1000-000-341025-000 CITY COLLECTIONS 5,107 5,000 107- -2% 1000-000-342010-000 POLICE SERVICES 16,238 27,000 10,763 40% 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-342020-000 FIRE CHG/TEST FEES/SPEC EVENTS/INST 10 0 10- 0% 1000-000-343018-000 PARKING PERMITS 48,271 95,000 46,729 49% 1000-000-343062-000 AIRPORT FUEL TAXES 1,874 4,000 2,126 53% 1000-000-343063-000 AIRPORT GROUND LEASE (HILTON) 14,855 14,500 355- -2% 1000-000-351000-000 CITY COURT FINES & FEES 191,418 450,000 258,582 57% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 11,948 24,000 12,052 50% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 23,923 58,000 34,078 59% 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 245 10,000 9,755 98% 1000-000-371010-000 INVESTMENT EARNINGS 31,723 45,000 13,277 30% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 462,500 925,000 462,500 50% ------------------------------------------------- TOTAL GENERAL FUND REVENUE 6,062,137 12,375,809 6,313,672 51% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 2 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 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 2,500 2,935 435 15% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 5,750 13,750 8,000 58% 1000-400-410530-354 OPEB EXPENSE 7,500 7,500 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 1,251 3,500 2,249 64% 1000-400-410560-312 POSTAGE 9,639 18,000 8,361 46% 1000-400-410560-320 PRINTING & ENVELOPES 4,145 4,000 145- -4% 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 509 3,500 2,991 85% 1000-400-420000-354 CONTRACT 911 CENTER 266,738 534,000 267,262 50% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 334 350 16 4% 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 125 500 375 75% 1000-400-510330-513 LIABILITY INSURANCE 140,059 140,807 748 1% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 16,556 50,000 33,444 67% 1000-400-510330-517 PROPERTY INSURANCE 54,676 54,676 0- 0% ------------------------------------------------- SUBTOTAL GEN.GOV'T. 1,726,338 2,618,275 891,937 34% CITY MANAGER 1000-401-410210-110 SALARIES-CITY MANAGER'S OFFICE 69,603 149,741 80,138 54% 1000-401-410210-153 HEALTH INSURANCE 9,730 23,220 13,490 58% 1000-401-410210-155 RETIREMENT 7,470 15,887 8,417 53% 1000-401-410210-210 SUPPLIES 11 1,000 989 99% 1000-401-410210-312 NEWSLETTER/BOOKS 494 400 94- -23% 1000-401-410210-345 TELEPHONE & COMMUNICATION 480 1,790 1,310 73% 1000-401-410210-373 DUES & TRAINING 4,461 10,500 6,039 58% 1000-401-410210-379 MEETINGS 1,054 4,500 3,446 77% ------------------------------------------------- SUBTOTAL CITY MANAGER 93,304 207,038 113,734 55% HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 63,477 137,409 73,932 54% 1000-401-410830-153 HEALTH INSURANCE 8,343 19,916 11,573 58% 1000-401-410830-155 RETIREMENT 5,187 10,868 5,681 52% 1000-401-410830-210 OFFICE SUPPLIES 954 600 354- -59% 1000-401-410830-338 RECRUITMENT/RELOCATION 6,734 20,000 13,266 66% 1000-401-410830-354 CONTRACT SERVICES 813 1,000 187 19% 1000-401-410830-373 DUES & TRAINING 1,770 6,500 4,730 73% ------------------------------------------------- SUBTOTAL HUMAN RESOURCES 87,279 196,293 109,014 56% THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 3 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 29,712 63,087 33,375 53% 1000-402-410100-153 HEALTH INSURANCE 21,210 55,457 34,247 62% 1000-402-410100-155 RETIREMENT 1,223 2,558 1,335 52% 1000-402-410100-210 OFFICE SUPPLIES 63 500 437 87% 1000-402-410100-335 MT LEAGUE OF CITIES 220 9,225 9,006 98% 1000-402-410100-354 CONTRACT SERVICES 8,327 13,000 4,673 36% 1000-402-410100-373 DUES & TRAINING 8,857 10,800 1,943 18% 1000-402-410100-379 MEETINGS 10,855 20,311 9,456 47% ------------------------------------------------- SUBTOTAL MAYOR/COUNCIL 80,467 174,938 94,471 54% CITY CLERK 1000-402-410150-110 SALARIES-CITY CLERK 45,614 97,169 51,555 53% 1000-402-410150-121 OVERTIME 0 250 250 100% 1000-402-410150-153 HEALTH INSURANCE 8,596 20,526 11,930 58% 1000-402-410150-155 RETIREMENT 3,671 7,732 4,061 53% 1000-402-410150-210 OFFICE SUPPLIES 0 300 300 100% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 180 600 420 70% 1000-402-410150-345 TELEPHONE & COMMUNICATION 240 480 240 50% 1000-402-410150-352 CODIFICATION 1,546 4,100 2,554 62% 1000-402-410150-354 CONTRACT SERVICES 0 300 300 100% 1000-402-410150-373 DUES & TRAINING 1,471 3,200 1,729 54% ------------------------------------------------- SUBTOTAL CITY CLERK 61,318 134,657 73,339 54% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES-FINANCE OFFICE 99,155 216,572 117,417 54% 1000-403-410550-121 OVERTIME 0 500 500 100% 1000-403-410550-153 HEALTH INSURANCE 16,218 36,794 20,576 56% 1000-403-410550-155 RETIREMENT 8,020 17,170 9,150 53% 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 120 500 380 76% 1000-403-410550-354 CONTRACT-GRIZZLY SECURITY 336 800 464 58% 1000-403-410550-355 BANK CHARGES & FEES 1,528 3,200 1,672 52% 1000-403-410550-373 DUES & TRAINING 1,915 7,500 5,585 74% ------------------------------------------------- SUBTOTAL FINANCE 127,407 284,336 156,929 55% THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 4 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CITY ATTORNEY 1000-404-411110-110 SALARIES-CITY ATTORNEY'S 186,015 442,839 256,824 58% 1000-404-411110-153 HEALTH INSURANCE 28,353 80,997 52,644 65% 1000-404-411110-155 RETIREMENT 14,957 35,232 20,275 58% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 458 2,563 2,105 82% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 13,812 17,000 3,188 19% 1000-404-411110-345 TELEPHONE & COMMUNICATION 382 1,025 643 63% 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 28,958 15,600 13,358- -86% 1000-404-411110-373 DUES & TRAINING 5,446 8,000 2,554 32% ------------------------------------------------- SUBTOTAL CITY ATTORNEY 278,380 603,256 324,876 54% MUNICIPAL COURT 1000-406-410360-110 SALARIES-COURT 107,891 227,463 119,572 53% 1000-406-410360-121 OVERTIME 0 3,500 3,500 100% 1000-406-410360-153 HEALTH INSURANCE 18,400 38,585 20,185 52% 1000-406-410360-155 RETIREMENT 8,561 18,048 9,487 53% 1000-406-410360-210 SUPPLIES 104 4,500 4,396 98% 1000-406-410360-320 PRINTING/BOOKS 1,299 2,500 1,201 48% 1000-406-410360-345 TELEPHONE & COMMUNICATION 24 1,400 1,376 98% 1000-406-410360-353 SECURITY & TECHNOLOGY 5,226 40,000 34,774 87% 1000-406-410360-354 CONTRACT SERVICES 325 6,250 5,925 95% 1000-406-410360-373 DUES & TRAINING 1,020 10,000 8,980 90% 1000-406-410360-394 JURY & WITNESS FEES 375 7,500 7,125 95% ------------------------------------------------- SUBTOTAL COURT 143,226 359,746 216,520 60% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES-PUBLIC WORKS 9,003 18,839 9,836 52% 1000-410-430100-153 HEALTH INSURANCE 1,355 3,524 2,169 62% 1000-410-430100-155 RETIREMENT 714 1,467 753 51% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 7,210 14,000 6,790 49% 1000-410-430100-231 GAS 1,291 3,000 1,709 57% 1000-410-430100-345 TELEPHONE & COMMUNICATION 125 350 225 64% 1000-410-430100-354 CONTRACT SERVICES 296 2,000 1,704 85% 1000-410-430100-373 DUES & TRAINING 2,559 3,500 941 27% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 2,286 4,571 2,285 50% ------------------------------------------------- SUBTOTAL PUBLIC WORKS ADMIN 24,838 51,251 26,413 52% CITY HALL MAINT. 1000-412-411230-110 SALARIES-CITY HALL 29,163 72,913 43,750 60% 1000-412-411230-153 HEALTH INSURANCE 4,304 13,628 9,324 68% 1000-412-411230-155 RETIREMENT 2,247 5,544 3,297 59% 1000-412-411230-220 SECURITY IMPROVEMENTS 0 6,793 6,793 100% 1000-412-411230-224 JANITORIAL SUPPLIES 2,076 6,000 3,924 65% 1000-412-411230-241 TOOLS & SUPPLIES 804 1,500 696 46% 1000-412-411230-341 ELECTRICITY 21,766 45,000 23,234 52% 1000-412-411230-344 NATURAL GAS 4,985 32,000 27,015 84% 1000-412-411230-345 TELEPHONE & COMMUNICATION 216 400 184 46% 1000-412-411230-354 CONTRACT SERVICES 7,369 25,000 17,631 71% THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 5 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 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 240 6,000 5,760 96% 1000-412-411230-362 EQUIPMENT MAINTENANCE 1,609 10,000 8,391 84% 1000-412-411230-366 BUILDING MAINTENANCE 12,509 41,150 28,641 70% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,023 3,700 677 18% ------------------------------------------------- SUBTOTAL CITY HALL 107,022 286,128 179,106 63% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES-PLANNING & ZONING 132,789 283,588 150,799 53% 1000-420-411020-112 SALARIES - RETIRMENT 43,108 57,078 13,970 24% 1000-420-411020-153 HEALTH INSURANCE 22,539 56,122 33,583 60% 1000-420-411020-155 RETIREMENT 10,827 22,556 11,729 52% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 917 5,000 4,083 82% 1000-420-411020-231 GAS 90 400 310 78% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 896 2,000 1,104 55% 1000-420-411020-345 TELEPHONE 345 1,000 655 66% 1000-420-411020-354 CONTRACT SERVICES 501 2,000 1,499 75% 1000-420-411020-373 DUES & TRAINING 3,079 7,000 3,921 56% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 200 401 201 50% ------------------------------------------------- SUBTOTAL PLANNING DEPT. 215,290 437,145 221,855 51% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 31,571 67,380 35,809 53% 1000-480-470210-153 HEALTH INSURANCE 5,562 13,277 7,715 58% 1000-480-470210-155 RETIREMENT 2,542 5,325 2,783 52% 1000-480-470210-210 OFFICE SUPPLIES 367 1,000 633 63% 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 232 750 518 69% 1000-480-470210-354 CONTRACT SERVICES 96 500 404 81% 1000-480-470210-373 DUES & TRAINING 3,229 5,000 1,771 35% 1000-480-470210-379 MEETINGS 160 1,500 1,340 89% ------------------------------------------------- SUBTOTAL COMMUNITY DEVELOPMENT 44,349 96,482 52,133 54% THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 6 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES-POLICE 1,108,617 2,399,735 1,291,118 54% 1000-413-420140-112 SALARIES-SEVERANCE 0 22,000 22,000 100% 1000-413-420140-114 SALARY -comptime buyout 2,743 13,600 10,857 80% 1000-413-420140-121 OVERTIME (REG & AET OT) 37,567 80,000 42,433 53% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 18,592 25,000 6,408 26% 1000-413-420140-153 HEALTH INSURANCE 181,595 465,977 284,382 61% 1000-413-420140-155 RETIREMENT 139,604 313,964 174,360 56% 1000-413-420140-210 OFFICE SUPPLIES 2,107 3,500 1,393 40% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 1,149 13,000 11,851 91% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 10,223 21,000 10,777 51% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 2,129 3,760 1,631 43% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 3,149 7,000 3,851 55% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 323 1,000 677 68% 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,887 15,400 13,513 88% 1000-413-420140-229 OTHER SUPPLIES 874 5,000 4,126 83% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 260 1,000 740 74% 1000-413-420140-231 GAS 32,713 83,000 50,287 61% 1000-413-420140-234 CRISIS NEGOTIATIONS 0 500 500 100% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 270 1,500 1,230 82% 1000-413-420140-320 PRINTING 1,514 5,500 3,986 72% 1000-413-420140-345 TELEPHONE & COMMUNICATION 11,944 19,000 7,056 37% 1000-413-420140-354 CONTRACT SERVICES 11,290 49,375 38,085 77% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 2,552 6,500 3,949 61% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 761 4,830 4,069 84% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 491 2,000 1,509 75% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 26,765 33,000 6,235 19% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 535 2,500 1,965 79% 1000-413-420140-373 DUES & TRAINING 21,603 46,000 24,398 53% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 433 14,500 14,067 97% 1000-413-420140-380 TRAINING MATERIALS 3,150 3,000 150- -5% 1000-413-420140-388 MEDICAL SERVICES 966 3,000 2,034 68% 1000-413-420140-392 BOARDING/TREATING PRISONERS 773 2,500 1,728 69% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 43,249 86,498 43,249 50% 1000-413-420140-530 RENT 4,419 8,520 4,101 48% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 32,000 64,000 32,000 50% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 5,750 11,500 5,750 50% 1000-413-420140-944 VEHICLES 2,587 211,793 209,206 99% ------------------------------------------------- SUBTOTAL POLICE DEPT. 1,715,117 4,104,202 2,389,085 58% DETECTIVES 1000-413-420141-110 SALARIES-DETECTIVES 185,302 382,938 197,636 52% 1000-413-420141-121 DETECTIVE-OVERTIME 3,902 15,000 11,098 74% 1000-413-420141-153 HEALTH INSURANCE 32,020 81,839 49,819 61% 1000-413-420141-155 DETECTIVE-RETIREMENT 24,580 51,285 26,705 52% ------------------------------------------------- TOTAL DETECTIVES 245,805 531,062 285,257 54% RECORDS 1000-413-420142-110 SALARIES-RECORDS DIVISION 64,321 149,535 85,214 57% 1000-413-420142-121 OVERTIME 1,691 7,500 5,809 77% THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 7 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-153 HEALTH INSURANCE 12,734 44,050 31,316 71% 1000-413-420142-155 RETIREMENT 5,248 11,831 6,583 56% ------------------------------------------------- TOTAL RECORDS 83,993 212,916 128,923 61% RESOURCE OFFICERS 1000-413-420144-110 SALARIES-SRO 122,888 283,576 160,688 57% 1000-413-420144-153 HEALTH INSURANCE 21,168 42,175 21,007 50% 1000-413-420144-155 SRO RETIREMENT 16,324 38,062 21,738 57% ------------------------------------------------- TOTAL RESOURCE OFFICERS 160,381 363,813 203,432 56% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL-SALARIES 21,707 43,420 21,713 50% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 3,535 8,436 4,901 58% 1000-413-420145-155 RETIREMENT 1,623 3,434 1,811 53% ------------------------------------------------- SUBTOTAL ANIMAL CONTROL 26,865 55,790 28,925 52% PARKING 1000-413-420147-110 PARKINGS -SALARIES 39,749 83,263 43,514 52% 1000-413-420147-153 HEALTH INSURANCE 12,992 31,019 18,027 58% 1000-413-420147-155 RETIREMENT 3,106 6,584 3,478 53% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 1,066 4,000 2,934 73% 1000-413-420147-354 CONTRACTED SERVICES 198 2,000 1,802 90% 1000-413-420147-362 LOT MAINT 1,503 10,000 8,497 85% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 890 17,500 16,610 95% 1000-413-420147-550 LOT LEASE PAYMENTS 691 1,500 809 54% ------------------------------------------------- SUBTOTAL PARKING 60,196 155,866 95,670 61% ------------------------------------------------- SUBTOTAL POLICE DEPT. 2,292,356 5,423,649 3,131,293 58% THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 8 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES-FIRE SUPPRESSION 716,669 1,739,869 1,023,200 59% 1000-416-420400-114 COMPTIME BUYOUT 3,360 5,500 2,140 39% 1000-416-420400-115 OUT OF RANK PAY 5,522 12,500 6,978 56% 1000-416-420400-121 OVERTIME 38,624 40,000 1,376 3% 1000-416-420400-153 HEALTH INSURANCE 148,074 297,790 149,716 50% 1000-416-420400-155 RETIREMENT 94,327 227,035 132,708 58% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 415 4,000 3,585 90% 1000-416-420400-218 Equipment (Non Capital) 7,297 21,500 14,203 66% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 6,358 15,000 8,642 58% 1000-416-420400-224 JANITORIAL SUPPLIES 1,722 5,000 3,278 66% 1000-416-420400-231 GAS 4,204 17,325 13,121 76% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 1,221 15,750 14,529 92% 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 2,227 6,000 3,773 63% 1000-416-420400-354 CONTRACT SERVICES 11,461 20,390 8,929 44% 1000-416-420400-362 EQUIPMENT MAINTENANCE 1,196 5,500 4,304 78% 1000-416-420400-366 BUILDING MAINTENANCE-STATION 62 5,869 6,500 631 10% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 1,040 5,000 3,960 79% 1000-416-420400-373 DUES & TRAINING 4,206 10,000 5,794 58% 1000-416-420400-388 FIREFIGHTER PHYSICALS 2,139 27,475 25,336 92% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 16,832 33,663 16,831 50% 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 140,000 280,000 140,000 50% 1000-416-420400-821 TRANSFER TO FUND 2956 GRANT MATCH 0 31,454 31,454 100% 1000-416-420400-940 EQUIPMENT - SCBA 23,113 44,546 21,433 48% 1000-416-420440-110 SALARIES-FIRE PREVENTION 9,908 21,459 11,551 54% 1000-416-420440-114 COMPTIME BUYOUT 350 0 350- 0% 1000-416-420440-153 HEALTH INSURANCE 2,225 5,311 3,086 58% 1000-416-420440-155 RETIREMENT 759 1,583 825 52% ------------------------------------------------- SUBTOTAL FIRE DEPT. 1,277,856 2,959,406 1,681,550 57% ------------------------------------------------- GRAND TOTAL GENERAL FUND 6,559,430 13,832,600 7,273,170 53% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 9 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 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 458,344 1,045,000 586,656 56% 2215-000-311200-000 PERSONAL PROPERTY TAXES 29,377 22,868 6,509- -28% 2215-000-312000-000 PEN & INTEREST DEL TAXES 815 2,000 1,185 59% 2215-000-335230-000 ENTITLEMENT SHARE PMT/HB 124 8,567 17,132 8,566 50% 2215-000-346030-000 SWIMMING POOL FEES 73,947 140,000 66,053 47% 2215-000-346040-000 CONCESSION STAND REVENUE 26,818 36,000 9,182 26% 2215-000-346050-000 PARKS USAGE FEES 7,632 20,000 12,368 62% 2215-000-346051-000 RECREATION FEES 13,546 20,033 6,487 32% 2215-000-346052-000 SPORTS PROGRAMS 20,917 59,480 38,563 65% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 759 2,000 1,241 62% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 29,536 56,000 26,464 47% 2215-000-346055-000 ICE RINK 2,088 20,000 17,912 90% 2215-000-346056-000 KIDSPORT USAGE 863 3,000 2,137 71% 2215-000-346057-000 YOUTH CAMPS 10,716 156,421 145,705 93% 2215-000-346059-000 PICNIC IN THE PARK 3,482 26,500 23,018 87% 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 2,296 0 2,296- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-371010-000 INVESTMENTS 4,712 5,500 788 14% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 47,500 95,000 47,500 50% ------------------------------------------------- TOTAL PARKS & REC REVENUE 741,916 1,746,934 1,005,018 58% ================================================= PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES-PARKS 158,979 336,666 177,687 53% 2215-436-460430-111 SEASONAL SALARIES 30,471 66,679 36,208 54% 2215-436-460430-121 OVERTIME 0 300 300 100% 2215-436-460430-153 HEALTH INSURANCE 25,136 61,999 36,863 59% 2215-436-460430-155 RETIREMENT 14,503 28,857 14,354 50% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 231 1,800 1,569 87% 2215-436-460430-215 EQUIPMENT - not capital 0 6,000 6,000 100% 2215-436-460430-224 JANITORIAL SUPPLIES 2,966 6,000 3,034 51% 2215-436-460430-229 OTHER SUPPLIES 902 10,000 9,098 91% 2215-436-460430-231 GAS 7,936 15,500 7,564 49% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 750 6,000 5,250 88% 2215-436-460430-320 PRINTING & ADVERTISING 166 200 34 17% 2215-436-460430-341 ELECTRICITY 5,764 14,000 8,236 59% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 6,746 20,000 13,254 66% 2215-436-460430-344 NATURAL GAS 0 2,500 2,500 100% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 976 2,800 1,824 65% 2215-436-460430-351 SPORTS COURT & BAND SHELL REHAB 0 2,000 2,000 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 405 2,000 1,595 80% 2215-436-460430-355 CONTRACT SERV. TRAIL MAINT/WEED CON 10,248 15,000 4,753 32% 2215-436-460430-356 TRAIL STUDY 0 30,000 30,000 100% 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 978 1,193 215 18% 2215-436-460430-358 FVCC TENNIS INTERLOCAL AGREEMENT 0 7,000 7,000 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 6,253 10,500 4,247 40% 2215-436-460430-364 LANDSCAPING 167 6,000 5,833 97% THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 10 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-367 VANDALISM REPAIRS 716 4,000 3,284 82% 2215-436-460430-373 DUES & TRAINING 4,385 8,000 3,615 45% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 0 400 400 100% 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,865 7,500 5,635 75% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 1,093 1,500 407 27% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 19,484 38,968 19,484 50% 2215-436-460430-545 COUNTY LANDFILL 3,735 6,273 2,538 40% 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 13,028 16,608 3,580 22% 2215-436-460430-941 TRUCK (FY 20) 0 38,000 38,000 100% ------------------------------------------------- SUBTOTAL PARKS EXPENDITURES 341,662 850,929 509,267 60% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES-COMPLEX 51,266 110,377 59,111 54% 2215-436-460440-111 SEASONAL SALARIES 22,136 38,917 16,781 43% 2215-436-460440-121 OVERTIME 0 300 300 100% 2215-436-460440-153 HEALTH INSURANCE 12,314 34,733 22,419 65% 2215-436-460440-155 RETIREMENT 5,192 10,009 4,817 48% 2215-436-460440-221 SAFETY EQUIPMENT 0 600 600 100% 2215-436-460440-229 OTHER SUPPLIES 6,908 22,000 15,092 69% 2215-436-460440-231 GAS 4,132 8,500 4,368 51% 2215-436-460440-241 CONSUMABLE TOOLS 427 2,000 1,573 79% 2215-436-460440-341 ELECTRICITY 4,906 9,500 4,594 48% 2215-436-460440-345 TELEPHONE & COMMUNICATION 114 240 126 53% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 433 800 367 46% 2215-436-460440-364 LANDSCAPING 14 600 586 98% 2215-436-460440-367 VANDALISM REPAIRS 95 500 405 81% 2215-436-460440-373 DUES & TRAINING 509 600 92 15% 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 4,496 7,000 2,504 36% 2215-436-460440-452 SAND & GRAVEL 1,104 1,200 96 8% 2215-436-460440-521 CENTRAL GARAGE TRANSFER 2,100 4,201 2,101 50% 2215-436-460440-545 COUNTY LANDFILL 3,389 3,400 11 0% ------------------------------------------------- SUBTOTAL ATHLETIC COMPLEX 119,535 258,327 138,792 54% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES-RECREATION 36,662 83,360 46,698 56% 2215-436-460431-111 SEASONAL SALARIES 3,338 10,065 6,727 67% 2215-436-460431-153 HEALTH INSURANCE 8,277 22,649 14,373 63% 2215-436-460431-155 RETIREMENT 2,918 7,304 4,386 60% 2215-436-460431-229 MISC. SUPPLIES 3,052 11,138 8,086 73% 2215-436-460431-231 GAS 161 584 423 72% 2215-436-460431-320 PRINTING & ADVERTISING 50 9,300 9,250 99% 2215-436-460431-345 TELEPHONE & COMMUNICATION 283 664 381 57% 2215-436-460431-354 CONTRACT SERVICES 21,661 27,550 5,890 21% 2215-436-460431-357 MUSIC FRANCHISE FEES 825 1,250 425 34% THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 11 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 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 77,395 174,564 97,169 56% YOUTH CAMPS 2215-436-460448-110 SALARIES-YOUTH CAMPS 33,074 73,603 40,529 55% 2215-436-460448-111 SEASONAL SALARIES 76,477 139,364 62,887 45% 2215-436-460448-121 OVERTIME 3 150 147 98% 2215-436-460448-153 HEALTH INSURANCE 7,923 21,805 13,882 64% 2215-436-460448-155 RETIREMENT 2,548 6,765 4,217 62% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 0 250 250 100% 2215-436-460448-229 MISC. SUPPLIES 1,433 3,520 2,087 59% 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 415 1,352 937 69% 2215-436-460448-354 CONTRACT SERVICES 11,962 12,870 908 7% 2215-436-460448-355 AFTER SCHOOL PROGRAM 389 1,200 811 68% 2215-436-460448-356 BANK FEES/CC CHARGES 1,164 4,000 2,836 71% 2215-436-460448-373 DUES & TRAINING 169 700 531 76% ------------------------------------------------- SUBTOTAL YOUTH CAMPS 135,558 266,212 130,654 49% POOL 2215-437-460445-111 SEASONAL SALARIES-POOL 120,684 171,808 51,124 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 137 500 363 73% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,568 2,000 432 22% 2215-437-460445-226 CHLORINE/CHEMICALS 27,547 26,500 1,047- -4% 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 4,853 9,000 4,147 46% 2215-437-460445-344 NATURAL GAS 9,103 21,500 12,397 58% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 861 2,550 1,689 66% 2215-437-460445-354 LICENSES & FEES 1,366 1,300 66- -5% 2215-437-460445-356 BANK FEES/ CC CHARGES 1,894 3,200 1,306 41% 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 191,329 283,953 92,624 33% ------------------------------------------------- TOTAL PARKS & RECREATION/POOL 865,479 1,833,985 968,506 53% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 12 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING URBAN FORESTRY 2600-436-460433-110 SALARIES-URBAN FORESTRY 80,196 194,961 114,765 59% 2600-436-460433-111 SEASONAL SERVICES 13,380 40,963 27,583 67% 2600-436-460433-121 OVERTIME 33 1,000 967 97% 2600-436-460433-153 HEALTH INSURANCE 13,717 38,982 25,265 65% 2600-436-460433-155 RETIREMENT 6,999 18,128 11,129 61% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 1,732 3,600 1,868 52% 2600-436-460433-231 GAS 2,506 7,000 4,494 64% 2600-436-460433-241 CONSUMABLE TOOLS 2,160 11,100 8,940 81% 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 326 660 334 51% 2600-436-460433-354 CONTRACT SERVICES 88,754 150,000 61,246 41% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 395 4,000 3,605 90% 2600-436-460433-362 EQUIPMENT MAINTENANCE 2,635 4,000 1,365 34% 2600-436-460433-364 LANDSCAPING & TREES 2,304 8,000 5,697 71% 2600-436-460433-373 DUES & TRAINING 2,724 4,000 1,276 32% 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 3,920 7,840 3,920 50% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 10,555 21,110 10,555 50% 2600-436-460433-528 DATA PROCESSING TRANSFER 2,274 4,547 2,273 50% 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 246,701 548,246 301,545 55% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 13 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 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 393,824 719,000 325,176 45% 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 140,000 280,000 140,000 50% ------------------------------------------------- TOTAL AMBULANCE REVENUE 533,824 1,309,000 775,176 59% ================================================= AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 288,825 682,105 393,280 58% 2230-440-420730-114 COMPTIME BUYBACK 0 3,500 3,500 100% 2230-440-420730-115 OUT OF RANK PAY 1,763 2,500 737 29% 2230-440-420730-121 OVERTIME 20,561 30,000 9,439 31% 2230-440-420730-153 HEALTH INSURANCE 71,020 145,660 74,640 51% 2230-440-420730-155 RETIREMENT 37,573 88,145 50,572 57% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 276 3,400 3,124 92% 2230-440-420730-218 NON-CAPITAL EQUIPMENT 0 4,200 4,200 100% 2230-440-420730-231 GAS & OIL 2,385 7,560 5,175 68% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 1,372 4,000 2,628 66% 2230-440-420730-312 POSTAGE/PRINTING 0 1,000 1,000 100% 2230-440-420730-345 TELEPHONE & COMMUNICATION 497 1,700 1,203 71% 2230-440-420730-354 CONTRACT SERVICES 2,875 19,990 17,115 86% 2230-440-420730-355 911 CENTER CONTRIBUTION 18,300 36,600 18,300 50% 2230-440-420730-359 AUDIT/CC OTHER FEES 1,772 1,650 122- -7% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 2,456 5,000 2,544 51% 2230-440-420730-373 DUES & TRAINING 3,647 5,000 1,353 27% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 327- 2,500 2,827 113% 2230-440-420730-391 MEDICAL TREATMENT-SUPPLIES 17,975 51,241 33,266 65% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 8,555 8,555 0 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 9,005 18,009 9,004 50% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 23,638 47,276 23,638 50% 2230-440-420730-528 DATA PROCESSING TRANSFER 9,094 18,189 9,095 50% 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 521,263 1,399,982 878,719 63% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 14 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 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 6,528 10,000 3,472 35% 2399-000-341073-000 FIRE IMPACT FEES 73,513 150,000 76,487 51% 2399-000-371010-000 INVESTMENT EARNINGS 8,678 13,000 4,322 33% ------------------------------------------------- TOTAL PS IMPACT FEE REV 88,719 173,000 84,281 49% ================================================= PUBLIC SAFETY IMPACT FEE EXP 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 5,000 10,000 5,000 50% 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 5,000 860,000 855,000 99% ================================================= 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 685 4,000 3,315 83% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 270 12,000 11,730 98% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 597 2,500 1,903 76% ------------------------------------------------- TOTAL HAZMAT GRANTS 1,552 18,500 16,948 92% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 15 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 238,425 400,000 161,575 40% 2394-000-323103-000 PLUMBING PERMITS 19,311 35,000 15,690 45% 2394-000-323104-000 MECHANICAL PERMITS 24,198 35,000 10,803 31% 2394-000-323105-000 ELECTRICAL PERMITS 33,660 60,000 26,340 44% 2394-000-323108-000 PLAN REVIEW FEES 52,771 160,000 107,229 67% 2394-000-371010-000 INVESTMENT EARNINGS 14,043 18,000 3,957 22% ------------------------------------------------- TOTAL REVENUE 382,407 708,000 325,593 46% ================================================= BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES-BUILDING DEPT. 248,517 520,711 272,194 52% 2394-420-420530-112 SALARIES-SEVERANCE 23,212 55,872 32,660 58% 2394-420-420530-121 OVERTIME 9,171 20,000 10,829 54% 2394-420-420530-153 HEALTH INSURANCE 39,098 95,503 56,405 59% 2394-420-420530-155 RETIREMENT 19,738 39,529 19,791 50% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 13,650 20,000 6,350 32% 2394-420-420530-231 GAS & OIL 1,433 5,000 3,567 71% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 3,492 7,300 3,808 52% 2394-420-420530-323 ST. ED. ASSESSMENTS 0 7,500 7,500 100% 2394-420-420530-345 TELEPHONE & COMMUNICATION 3,364 6,000 2,636 44% 2394-420-420530-353 AUDITING 4,500 4,500 0 0% 2394-420-420530-354 CONTRACT SERVICES 4,408 20,000 15,592 78% 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 5,433 15,000 9,567 64% 2394-420-420530-360 FURNITURE 2,750 4,000 1,250 31% 2394-420-420530-373 DUES & TRAINING 6,204 35,000 28,796 82% 2394-420-420530-510 PROPERTY INSURANCE 8,184 10,000 1,816 18% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 671 1,342 671 50% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 16,578 33,156 16,578 50% 2394-420-420530-528 DATA PROCESSING TRANSFER 15,915 31,831 15,916 50% 2394-420-420530-920 BUILDING IMPROVEMENTS 0 200,000 200,000 100% ------------------------------------------------- TOTAL BUILDING DEPT. 445,576 1,154,244 708,668 61% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 16 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 38,309 86,741 48,432 56% 2400-410-430263-153 HEALTH INSURANCE 5,012 15,533 10,521 68% 2400-410-430263-155 RETIREMENT 2,933 6,589 3,656 55% 2400-410-430263-244 STREET LIGHT SUPPLIES 419 18,000 17,581 98% 2400-410-430263-245 LUMINAIRES 16,132 30,000 13,868 46% 2400-410-430263-246 LED LUMINAIRE UPGRADE 3,956 32,655 28,699 88% 2400-410-430263-341 ELECTRICITY 64,895 182,000 117,105 64% 2400-410-430263-360 REPAIR & MAINT SERVICES 974 20,000 19,026 95% 2400-410-430263-373 DUES & TRAINING 1,125 1,000 125- -13% 2400-410-430263-510 INSURANCE 1,232 1,500 268 18% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 7,729 15,457 7,728 50% ------------------------------------------------- TOTAL LIGHT MAINT. 142,717 409,475 266,758 65% ================================================= 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 30,812 114,683 83,871 73% 2420-421-430234-957 ALLEY PAVING 42,168 67,180 25,012 37% 2420-421-430240-231 GAS & OIL 11,924 42,000 30,076 72% 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 450 1,500 1,050 70% 2420-421-430240-368 OVERLAY/CHIPSEALS 32,936 318,578 285,642 90% 2420-421-430240-452 GRAVEL 2,107 5,000 2,893 58% 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 37,472 53,000 15,528 29% 2420-421-430240-472 ASPHALT 9,821 40,000 30,179 75% 2420-421-430240-473 CRACK SEALING 0 14,500 14,500 100% 2420-421-430240-474 PAINT STRIPING MATERIALS 13,919 30,000 16,081 54% ------------------------------------------------- TOTAL GAS TAX 181,608 718,241 536,633 75% ================================================= 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, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 17 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 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. 354,951 805,569 450,618 56% 2500-421-430240-112 RETIREMENT-severance 18,293 0 18,293- 0% 2500-421-430240-121 OVERTIME 1,573 28,000 26,427 94% 2500-421-430240-153 HEALTH INSURANCE 70,738 177,425 106,687 60% 2500-421-430240-155 RETIREMENT 28,450 60,533 32,083 53% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 7,276 16,360 9,084 56% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,365 7,000 5,635 81% 2500-421-430240-220 OTHER SUPPLIES 1,164 4,500 3,336 74% 2500-421-430240-231 GAS & OIL 12,421 42,000 29,579 70% 2500-421-430240-341 ELECTRICITY 902 3,500 2,598 74% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 668 1,700 1,032 61% 2500-421-430240-354 CONTRACT SERVICES 3,225 22,500 19,275 86% 2500-421-430240-356 TRANSPORTATION PLAN 64,567 187,150 122,583 66% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 8,007 33,500 25,493 76% 2500-421-430240-366 BUILDING MAINTENANCE 20,015 26,375 6,360 24% 2500-421-430240-373 DUES & TRAINING 722 7,500 6,778 90% 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 16,070 11,269 4,801- -43% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 97,732 195,464 97,732 50% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 57,976 115,951 57,975 50% 2500-421-430240-528 DATA PROCESSING TRANSFER 7,095 14,191 7,096 50% 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 1,599 4,678 3,079 66% 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 12,478 24,955 12,477 50% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 7,094 14,032 6,938 49% 2500-421-430244-354 PAVEMENT REPAIRS-PAVEMENT MNT FUNDS 389,623 873,166 483,543 55% 2500-421-430244-820 TRANSFER TO BaRSAA 10,000 20,000 10,000 50% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 99,700 158,000 58,300 37% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 100% ------------------------------------------------- TOTAL STREET MAINT. 1,324,111 2,924,406 1,600,295 55% ------------------------------------------------- SIGNS AND SIGNALS 2500-421-430264-110 TSS - SALARIES 49,507 103,256 53,749 52% 2500-421-430264-121 OVERTIME 0 7,500 7,500 100% 2500-421-430264-153 HEALTH INSURANCE 12,430 29,676 17,246 58% 2500-421-430264-155 RETIREMENT 3,744 7,685 3,941 51% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 612 3,775 3,163 84% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,047 6,700 5,653 84% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 904 3,500 2,596 74% 2500-421-430264-242 STREET SIGNS 18,474 30,000 11,526 38% 2500-421-430264-243 TRAFFIC SIGNALS 6,265 30,000 23,735 79% 2500-421-430264-245 BARRICADE MATERIALS 531 6,000 5,469 91% 2500-421-430264-341 ELECTRICITY 664 3,000 2,336 78% 2500-421-430264-345 COMMUNICATIONS 254 850 596 70% 2500-421-430264-354 CONTRACT SERVICES 996 10,000 9,004 90% 2500-421-430264-362 EQUIPMENT MAINTENANCE 577 3,000 2,423 81% 2500-421-430264-366 BUILDING MAINTENANCE 4,449 7,375 2,926 40% 2500-421-430264-373 DUES & TRAINING 1,550 7,000 5,450 78% 2500-421-430264-428 PAINT MATERIALS 359 5,000 4,641 93% THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 18 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 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 3,751 7,502 3,751 50% 2500-421-430264-532 OFFICE RENT 0 6,422 6,422 100% 2500-421-430264-940 MACHINERY & EQUIPMENT 20,721 47,000 26,279 56% ------------------------------------------------- TOTAL SIGNS AND SIGNALS 129,049 331,018 201,969 61% ------------------------------------------------- TOTAL STREET MAINT. & SIGNS 1,453,160 3,255,424 1,802,264 55% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 19 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 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 1,201 1,000 201- -20% 2188-000-381060-000 TRANSFER FROM GENERAL FUND 1,200,000 1,200,000 0 0% ------------------------------------------------- TOTAL REVENUE 1,203,845 1,776,000 572,155 32% ================================================= EXPENDITURES 2188-480-470230-110 SALARIES 21,528 46,104 24,576 53% 2188-480-470230-153 HEALTH INSURANCE 3,616 9,381 5,765 61% 2188-480-470230-155 RETIREMENT 1,734 3,664 1,930 53% 2188-480-470230-353 AUDIT 3,000 3,000 0 0% 2188-480-470230-356 TELEPHONE 96 192 96 50% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 2,338 4,675 2,337 50% 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 1,122,057 1,500,000 377,943 25% 2188-480-470440-930 CITY MATCH - TRAIL 32,433 200,000 167,567 84% 2188-480-470440-935 CITY MATCH - RAIL PARK 34,742 28,455 6,287- -22% ------------------------------------------------- TOTAL WESTSIDE TIF 1,221,543 1,795,471 573,928 32% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 20 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 1,600 1,600 0 0% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 6,792 13,584 6,792 50% 2185-000-430300-840 REDEVELOPMENT ACTIVITY 999,051 3,316,334 2,317,283 70% 2185-480-470240-110 SALARIES 10,042 21,321 11,279 53% 2185-480-470240-153 HEALTH INSURANCE 1,946 4,647 2,701 58% 2185-480-470240-155 RETIREMENT 808 1,703 895 53% 2185-480-470240-345 TELEPHONE & COMMUNICATION 24 48 24 50% ------------------------------------------------- TOTAL 2185 AIRPORT TIF 1,020,265 3,359,237 2,338,972 70% ================================================= 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, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 21 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 1,000 1,000 0 0% 2880-480-470210-354 CONTRACT SERVICES 2 1,000 998 100% 2880-480-470210-711 REDEVELOPMENT 0 225,000 225,000 100% ------------------------------------------------- TOTAL LOAN REVOLVING 1,002 227,000 225,998 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 1,000 1,000 0 0% 2886-480-470210-373 DUES & TRAINING 0 2,000 2,000 100% 2886-480-470210-379 MEETINGS 164 1,000 836 84% 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 4,547 9,094 4,547 50% 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. 6,211 26,740 20,529 77% ================================================= 2887 RURAL DEVELOPMENT #1 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 22,074 18,826 3,248- -17% 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 22,074 422,074 400,000 95% ================================================= 2888 RURAL DEVELOPMENT #2 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 10,025 8,384 1,641- -20% 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 10,025 310,025 300,000 97% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 22 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 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 514 1,943 1,429 74% 2953-480-470215-354 CONT SERV/HAZARDOUS 17,022 37,108 20,086 54% 2953-480-470215-373 TRAVEL/HAZARDOUS 0 1,958 1,958 100% ------------------------------------------------- TOTAL EPA BROWNSFIELD 17,736 226,601 208,865 92% ================================================= 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES-PETROLEUM 0 219,251 219,251 100% 2955-480-470210-373 TRAVEL-PETROLEUM 929 0 929- 0% 2955-480-470210-725 REVOLVED FUNDS-PETROLEUM 0 100,500 100,500 100% 2955-480-470215-229 SUPPLIES-HAZARDOUS SUBSTANCES 0 267,673 267,673 100% ------------------------------------------------- TOTAL BROWNFIELDS LOAN REV. 929 587,424 586,495 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, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 23 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD 1,813 10,000 8,187 82% ------------------------------------------------- TOTAL 2915 STONEGARDEN GRANT 1,813 10,000 8,187 82% ================================================= 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 28,667 65,117 36,450 56% 2916-413-420140-121 OVERTIME 6,627 8,000 1,373 17% 2916-413-420140-153 HEALTH INSURANCE 4,769 11,934 7,165 60% 2916-413-420140-155 RETIREMENT 3,785 8,751 4,966 57% 2916-413-420140-354 CONTRACT SERVICES 0 7,800 7,800 100% ------------------------------------------------- TOTAL 2916 DRUG ENFORCEMENT 43,848 101,602 57,754 57% ================================================= 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 722 4,000 3,278 82% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 7,264 36,000 28,736 80% 2919-413-420140-127 SCHOOL DIST. OT 2,948 20,000 17,052 85% 2919-413-420140-220 EQUIPMENT-FUNDED BY DONATIONS 3,478 4,000 522 13% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 7,149 7,000 149- -2% ------------------------------------------------- TOTAL LAW ENF. GRANT 21,561 71,000 49,439 70% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 24 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 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 14,958 25,000 10,042 40% ------------------------------------------------- TOTAL 4290 WALK & CURB 14,958 25,000 10,042 40% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 25 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 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 360 1,000 640 64% 5210-000-343210-000 METERED WATER SALES 1,816,914 3,000,000 1,183,086 39% 5210-000-343220-000 UNMETERED WATER SALES 21,011 15,000 6,011- -40% 5210-000-343230-000 METER REPLACEMENT FEE 54,475 100,000 45,525 46% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 28,381 55,000 26,619 48% 5210-000-343270-000 WATER TURN ON FEES 3,270 4,000 730 18% 5210-000-343275-000 TAG FEE 24,420 45,000 20,580 46% 5210-000-343365-000 LATECOMER ADMIN FEE 91- 0 91 0% 5210-000-371010-000 INVESTMENT EARNINGS 75,495 105,000 29,505 28% 5210-000-383010-000 TRANSFER FROM IMPACT FEE FUN (10100 12,500 25,000 12,500 50% 5210-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 156,250 309,058 152,808 49% ------------------------------------------------- TOTAL WATER REVENUE 2,192,985 3,659,058 1,466,073 40% ================================================= WATER FACILITIES 5210-447-430550-110 SALARIES-WATER 292,043 774,817 482,774 62% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 4,584 20,000 15,416 77% 5210-447-430550-153 HEALTH INSURANCE 55,877 174,095 118,218 68% 5210-447-430550-155 RETIREMENT 22,654 58,417 35,763 61% 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 6,618 22,000 15,382 70% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 3,256 8,500 5,244 62% 5210-447-430550-226 CHLORINE & CHEMICALS 16,800 39,000 22,200 57% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 1,587 4,500 2,913 65% 5210-447-430550-231 GAS & OIL 10,419 35,000 24,581 70% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 659 1,000 341 34% 5210-447-430550-336 LICENSES & FEES 1,232 18,500 17,268 93% 5210-447-430550-341 ELECTRICITY 71,626 160,000 88,374 55% 5210-447-430550-344 NATURAL GAS 1,229 15,500 14,271 92% 5210-447-430550-345 TELEPHONE & COMMUNICATION 5,314 11,000 5,686 52% 5210-447-430550-349 LAB SERVICES 5,138 20,000 14,862 74% 5210-447-430550-353 AUDITING 3,500 3,500 0 0% 5210-447-430550-354 CONTRACT SERVICES 13,568 55,000 41,432 75% 5210-447-430550-355 NOFFSINGER TRANSMISSION CONDITION A 0 255,000 255,000 100% 5210-447-430550-356 CONSULTANTS 24,136 125,000 100,864 81% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 177 15,000 14,823 99% 5210-447-430550-366 BUILDING MAINTENANCE 10,224 16,375 6,151 38% 5210-447-430550-373 DUES & TRAINING 3,380 11,000 7,620 69% 5210-447-430550-388 MEDICAL SERVICES 580 600 20 3% 5210-447-430550-410 CONSTRUCTION MATERIALS 14,985 35,000 20,015 57% 5210-447-430550-422 HYDRANTS 0 10,000 10,000 100% 5210-447-430550-423 MATERIALS FOR MAINS 2,879 14,000 11,121 79% 5210-447-430550-424 MATERIALS -SERVICE LINES 1,712 12,000 10,288 86% 5210-447-430550-425 MATERIALS PUMPS/WELLS 1,800 45,000 43,200 96% 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 13,501 27,002 13,501 50% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 61,035 122,069 61,034 50% 5210-447-430550-528 DATA PROCESSING TRANSFER 16,556 33,112 16,556 50% 5210-447-430550-532 LEASE PAYMENTS 0 10,500 10,500 100% 5210-447-430550-939 FOUR MILE TRANSMISSION MAIN (PHASE 445,742 4,239,062 3,793,320 89% THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 26 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-940 MACHINERY & EQUIPMENT 0 45,000 45,000 100% 5210-447-430550-948 METERS (METER FUNDS) 010125 33,605 151,263 117,658 78% 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 1,666 4,578 2,912 64% 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 1,376,895 7,937,370 6,560,475 83% ------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES-WATER BILLING 56,125 117,187 61,062 52% 5210-447-430560-153 HEALTH INSURANCE 15,827 36,809 20,982 57% 5210-447-430560-155 RETIREMENT 4,464 9,182 4,718 51% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 3,837 7,000 3,163 45% 5210-447-430560-353 AUDITING 2,000 2,000 0 0% 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 19,816 40,000 20,184 50% 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 11,529 27,000 15,471 57% 5210-447-430560-356 OTHER CONTRACT SERVICES 70 1,500 1,430 95% 5210-447-430560-373 DUES & TRAINING 28 2,500 2,472 99% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 5,630 11,259 5,629 50% 5210-447-430560-528 DATA PROCESSING TRANSFER 16,556 33,112 16,556 50% 5210-447-430560-532 RENT 0 6,422 6,422 100% ------------------------------------------------- SUBTOTAL WATER BILLING 135,882 293,971 158,089 54% ------------------------------------------------- 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 38,439 50,538 12,099 24% 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 121,584 506,331 384,747 76% ------------------------------------------------- DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 840,000 840,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 840,000 840,000 100% ------------------------------------------------- TOTAL WATER FUND 1,634,361 9,577,672 7,943,311 83% ================================================= WATER IMPACT FEE REVENUE: THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 27 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5211-000-343225-000 IMPACT FEES 328,764 500,000 171,236 34% 5211-000-371010-000 INTEREST EARNINGS 10,150 15,000 4,850 32% ------------------------------------------------- TOTAL WATER IMPACT FEES REVENU 338,914 515,000 176,087 34% ================================================= WATER IMPACT FEES EXPENSES: 5211-447-430555-820 DEBT SERVICE TRANSFER TO 5210 156,250 309,058 152,808 49% 5211-447-430555-825 TRANSFER TO 5210 FOR ADMIN 12,500 25,000 12,500 50% 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 24,645 45,600 20,955 46% 5211-447-430555-953 SECTION 36 WELL 16,347 184,453 168,106 91% ------------------------------------------------- TOTAL WATER IMPACT FEE EXPENSE 209,742 1,676,059 1,466,317 87% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 28 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 360 1,500 1,140 76% 5310-000-343310-000 SEWER SERVICE CHARGES 2,293,079 4,500,000 2,206,921 49% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 1,227 4,000 2,773 69% 5310-000-343365-000 LATECOMER ADMIN FEES 315 4,500 4,185 93% 5310-000-371010-000 INVESTMENT EARNINGS 52,182 66,500 14,318 22% 5310-000-383010-000 ADMIN TRANSFER FROM IMPACT FEES 25,000 50,000 25,000 50% 5310-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 445,000 891,026 446,026 50% ------------------------------------------------- TOTAL SEWER REVENUE 2,817,163 5,517,526 2,700,363 49% ================================================= SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES-SEWER BILLING 47,828 99,549 51,721 52% 5310-454-430620-153 HEALTH INSURANCE 12,110 27,602 15,492 56% 5310-454-430620-155 RETIREMENT 3,794 7,778 3,984 51% 5310-454-430620-215 OFFICE SUPPLIES/computers 3,835 7,000 3,165 45% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 2,000 2,000 0 0% 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 19,816 40,000 20,184 50% 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 11,529 27,000 15,471 57% 5310-454-430620-356 OTHER CONTRACT SERVICES 70 1,500 1,430 95% 5310-454-430620-373 DUES & TRAINING 28 2,500 2,472 99% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 5,060 10,119 5,059 50% 5310-454-430620-528 DATA PROCESSING TRANSFER 16,556 33,112 16,556 50% 5310-454-430620-532 OFFICE RENT 0 6,422 6,422 100% ------------------------------------------------- SUBTOTAL SEWER BILLING COSTS 122,626 264,582 141,956 54% ------------------------------------------------- SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES-SANITARY SEWER 132,151 297,006 164,855 56% 5310-454-430630-121 OVERTIME 383 5,500 5,117 93% 5310-454-430630-153 HEALTH INSURANCE 25,804 80,197 54,393 68% 5310-454-430630-155 RETIREMENT 10,092 22,509 12,417 55% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 8,919 12,200 3,281 27% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 2,012 8,350 6,338 76% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 847 2,300 1,453 63% 5310-454-430630-231 GAS & OIL 3,871 12,000 8,129 68% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 21 500 479 96% 5310-454-430630-341 ELECTRICITY 18,478 57,000 38,522 68% 5310-454-430630-344 NATURAL GAS 4,190 16,500 12,310 75% 5310-454-430630-345 TELEPHONE & COMMUNICATION 9,337 26,000 16,663 64% 5310-454-430630-353 AUDITING 3,000 3,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 14,898 24,000 9,102 38% 5310-454-430630-356 CONSULTANTS - FACILITY PLAN 26,334 185,000 158,666 86% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 7,921 11,375 3,454 30% 5310-454-430630-373 DUES & TRAINING 4,283 7,250 2,967 41% 5310-454-430630-388 MEDICAL SERVICES 145 500 355 71% 5310-454-430630-410 CONSTRUCTION MATERIALS 6,990 10,000 3,010 30% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 24,669 50,000 25,331 51% 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 4,717 9,435 4,718 50% THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 29 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-522 ADMINISTRATIVE TRANSFER 24,427 48,854 24,427 50% 5310-454-430630-528 DATA PROCESSING TRANSFER 9,460 18,921 9,461 50% 5310-454-430630-532 OFFICE RENT 6,494 6,422 72- -1% 5310-454-430630-940 MACHINERY & EQUIPMENT 10,633 43,500 32,867 76% 5310-454-430630-948 REPAIR & REPLC OF SEWER MAIN 0 600,000 600,000 100% 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 1,599 4,673 3,074 66% 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 0 20,000 20,000 100% 5310-454-430630-957 WEST SIDE INTERCEPTOR (BONDED) 96,774 2,783,478 2,686,704 97% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 13,280 50,000 36,720 73% 5310-454-430630-962 SEWER MAIN SLIP LINING 0 395,000 395,000 100% ------------------------------------------------- SUBTOTAL SEWER COLLECTION 511,032 4,878,470 4,367,438 90% ------------------------------------------------- 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 860,766 6,461,555 5,600,789 87% ------------------------------------------------- WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 203,416 454,195 250,779 55% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-121 OVERTIME 9,721 22,500 12,779 57% 5310-455-430640-153 HEALTH INSURANCE 36,334 90,736 54,402 60% 5310-455-430640-155 RETIREMENT 16,391 34,152 17,761 52% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 9,892 10,000 108 1% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 250 2,700 2,450 91% 5310-455-430640-225 ALUM 0 28,000 28,000 100% 5310-455-430640-226 CHLORINE & CHEMICALS 52,245 87,000 34,755 40% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 4,108 7,000 2,892 41% 5310-455-430640-231 GAS & OIL 4,116 19,000 14,884 78% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 297 400 103 26% 5310-455-430640-336 LICENSES & FEES 343 12,000 11,657 97% 5310-455-430640-341 ELECTRICITY 78,219 190,000 111,781 59% 5310-455-430640-342 WATER 3,459 7,500 4,041 54% 5310-455-430640-344 NATURAL GAS 91 82,000 81,909 100% 5310-455-430640-345 TELEPHONE & COMMUNICATION 3,004 6,500 3,496 54% 5310-455-430640-353 AUDITING 2,500 2,500 0 0% 5310-455-430640-354 CONTRACT-GLACIER GOLD 50,785 135,000 84,215 62% 5310-455-430640-355 OTHER CONTRACT SERVICES 20,171 39,000 18,829 48% THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 30 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-356 CONSULTANTS 66,475 210,960 144,485 68% 5310-455-430640-358 CONSULTANT-FACILITY PLN/RATE STDY/T 29,008 175,000 145,992 83% 5310-455-430640-360 MISC. MAINT SERVICES 11,818 30,000 18,182 61% 5310-455-430640-366 BUILDING MAINTENANCE 39,911 46,000 6,089 13% 5310-455-430640-373 DUES & TRAINING 5,677 8,500 2,823 33% 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 9,610 19,219 9,609 50% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 61,353 122,705 61,352 50% 5310-455-430640-528 DATA PROCESSING TRANSFER 11,826 23,651 11,825 50% 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 772,717 2,105,182 1,332,465 63% ------------------------------------------------- WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 36,747 118,000 81,253 69% 5310-455-430645-921 E. SECONDARY CLARIFIER COATING PRJ 68,234 75,000 6,766 9% 5310-455-430645-934 SECONDARY DIGESTER LID REPLC 518,127 530,648 12,521 2% 5310-455-430645-940 MACHINERY & EQUIPMENT 119,252 125,500 6,248 5% ------------------------------------------------- SUBTOTAL WWTP REPLACEMENT 742,360 849,148 106,788 13% ------------------------------------------------- WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 53,663 115,308 61,645 53% 5310-455-430646-121 OVERTIME 587 0 587- 0% 5310-455-430646-153 HEALTH INSURANCE 7,070 16,872 9,802 58% 5310-455-430646-155 RETIREMENT 4,143 8,589 4,446 52% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 3,154 4,500 1,346 30% 5310-455-430646-218 NON-CAPITAL EQUIPMENT 2,863 2,500 363- -15% 5310-455-430646-222 LAB SUPPLIES 6,421 16,500 10,080 61% 5310-455-430646-349 LAB SERVICES 10,480 30,000 19,520 65% 5310-455-430646-362 EQUIPMENT MAINTENANCE 4,034 5,500 1,466 27% 5310-455-430646-373 DUES & TRAINING 254 4,700 4,446 95% ------------------------------------------------- SUBTOTAL WWTP LAB OPERATIONS 92,669 204,469 111,801 55% 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% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 31 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SUBTOTAL WWTP 1,793,413 6,088,466 4,295,053 71% ------------------------------------------------- TOTAL BILLING/SANITARY/WWTP 2,776,804 12,814,603 10,037,799 78% ================================================= SEWER IMPACT FEE REVENUE 5311-000-343330-000 SANITARY IMPACT FEES 577,822 600,000 22,178 4% 5311-000-343335-000 TREATMENT IMPACT FEES 326,283 400,000 73,717 18% 5311-000-371010-000 SANITARY INTEREST EARNINGS 17,560 20,000 2,440 12% 5311-000-371015-000 TREATMENT INTEREST EARNINGS 13,432 20,000 6,568 33% ------------------------------------------------- TOTAL SEWER IMPACT FEES REVENU 935,097 1,040,000 104,903 10% ================================================= SEWER IMPACT FEE EXPENSES 5311-454-430635-820 TRANSFER TO 5310 FOR DEBT 332,000 666,026 334,026 50% 5311-454-430635-825 TRANSFER TO 5310 FOR ADMIN 15,000 30,000 15,000 50% 5311-454-430635-955 MAIN & L.S. UPSIZE 0 300,000 300,000 100% 5311-454-430635-957 WEST SIDE INTERCEPTOR 52,666 151,487 98,821 65% 5311-455-430644-820 DEBT SERVICE TRANSFER 113,000 225,000 112,000 50% 5311-455-430644-825 TRANSFER TO 5310 FOR ADMIN 10,000 20,000 10,000 50% 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 522,666 1,976,150 1,453,484 74% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 32 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 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 360 0 360- 0% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 0 1,500 1,500 100% 5349-000-343034-000 PERMIT FEES 1,085 0 1,085- 0% 5349-000-343035-000 STORM SEWER CHARGES 0 1,500 1,500 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 1,636,522 1,625,000 11,522- -1% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 1,573 1,800 227 13% 5349-000-371010-000 INTEREST ON INVESTMENTS 19,886 35,000 15,114 43% 5349-000-383010-000 IMPACT FEE 5% ADMIN - TFR FROM IMPA 3,250 6,500 3,250 50% 5349-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 0 175,568 175,568 100% ------------------------------------------------- TOTAL STORM REVENUE 1,662,677 1,846,868 184,191 10% ================================================= STORM SEWER 5349-453-430246-110 SALARIES-STORM SEWER 213,383 476,323 262,940 55% 5349-453-430246-121 OVERTIME 390 4,000 3,610 90% 5349-453-430246-153 HEALTH INSURANCE 36,205 97,207 61,002 63% 5349-453-430246-155 RETIREMENT 16,373 36,107 19,734 55% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 11,571 16,100 4,529 28% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 126 6,000 5,874 98% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100% 5349-453-430246-231 GAS & OIL 3,532 11,500 7,968 69% 5349-453-430246-345 TELEPHONE & COMMUNICATION 876 1,500 624 42% 5349-453-430246-353 AUDITING 1,150 1,150 0 0% 5349-453-430246-354 CONTRACT SERVICE 2,303 7,000 4,697 67% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 1,943 135,000 133,057 99% 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 4,209 7,250 3,041 42% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 358 10,000 9,642 96% 5349-453-430246-510 PROPERTY & LIABILITY INS. 9,329 16,000 6,671 42% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 4,717 9,435 4,718 50% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 22,566 45,133 22,567 50% 5349-453-430246-528 DATA PROCESSING TRANSFER 9,460 18,921 9,461 50% 5349-453-430246-530 BNSF LEASE PMT 4,597 6,200 1,603 26% 5349-453-430246-532 OFFICE RENT 0 6,422 6,422 100% 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 102,886 367,647 264,761 72% 5349-453-430246-970 REGIONAL FACILITIES & PIPING DESIGN 0 5,500,000 5,500,000 100% 5349-453-430247-952 STORM DRAIN CORRECTION 9,917 249,323 239,406 96% 5349-453-430247-953 SHOP COMPLEX PAVEMNT 7,880 23,008 15,128 66% 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 10,633 56,500 45,867 81% ------------------------------------------------- SUBTOTAL STORM OPERATIONS 476,169 8,092,526 7,616,357 94% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 33 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM BONDS/LOANS 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% ------------------------------------------------- SUBTOTAL STORM BONDS/LOANS 1,641 180,127 178,486 99% ------------------------------------------------- TOTAL STORM EXPENSE 477,810 8,272,653 7,794,843 94% ================================================= STORM SEWER IMPACT FEE REVENUE 5348-000-343033-000 IMPACT FEES 71,392 130,000 58,608 45% 5348-000-371010-000 INTEREST EARNINGS 15,618 15,000 618- -4% ------------------------------------------------- TOTAL STORM IMPACT FEES REVENU 87,010 145,000 57,990 40% ================================================= 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 3,250 6,500 3,250 50% 5348-453-430248-959 REG FACILITIES & PIPING DESIGN 117,538 1,414,852 1,297,314 92% 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 120,788 1,876,920 1,756,132 94% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 34 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SOLID WASTE REVENUE: 5510-000-343360-000 SALE OF MAT/AUCTION 2,526 0 2,526- 0% 5510-000-343410-000 GARBAGE COLLECTION-ASSESSED 1,044,352 1,022,000 22,352- -2% 5510-000-343420-000 GARBAGE COLLECTION-BILLED 2,281 23,500 21,219 90% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,242 2,100 858 41% 5510-000-371010-000 INVESTMENT EARNINGS 9,852 15,000 5,148 34% ------------------------------------------------- TOTAL SOLID WASTE REVENUE 1,060,253 1,062,600 2,347 0% ================================================= SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES-SOLID WASTE 185,816 428,543 242,727 57% 5510-460-430840-121 OVERTIME 1,753 6,500 4,747 73% 5510-460-430840-153 HEALTH INSURANCE 38,245 101,080 62,835 62% 5510-460-430840-155 RETIREMENT 14,200 32,232 18,032 56% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 6,554 14,500 7,946 55% 5510-460-430840-218 EQUIPMENT-GARBAGE CONTAINERS 9,520 37,500 27,980 75% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 1,256 5,500 4,244 77% 5510-460-430840-231 GAS & OIL 21,384 60,000 38,616 64% 5510-460-430840-341 ELECTRICITY 601 2,050 1,449 71% 5510-460-430840-344 NATURAL GAS 0 4,500 4,500 100% 5510-460-430840-345 TELEPHONE & COMMUNICATION 705 1,250 545 44% 5510-460-430840-354 CONTRACT SERVICES 18,008 20,000 1,992 10% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 205 5,700 5,495 96% 5510-460-430840-366 BUILDING MAINTENANCE 7,247 8,875 1,628 18% 5510-460-430840-373 DUES & TRAINING 2,627 5,500 2,873 52% 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 3,614 4,000 386 10% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 36,225 72,450 36,225 50% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 22,325 44,649 22,324 50% 5510-460-430840-528 DATA PROCESSING TRANSFER 7,095 14,191 7,096 50% 5510-460-430840-532 OFFICE RENT 0 6,422 6,422 100% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 20,000 40,000 20,000 50% 5510-460-430840-944 VEHICLES (Replacement $) 0 260,000 260,000 100% 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 1,599 4,673 3,074 66% 5510-460-430845-224 JANITORIAL SUPPLIES 176 500 324 65% 5510-460-430845-341 ELECTRICITY 616 3,500 2,884 82% 5510-460-430845-342 WATER 173 2,000 1,827 91% 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 413,063 1,361,304 948,241 70% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 35 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 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 92,500 140,000 47,500 34% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 50,491 225,000 174,509 78% 6030-000-371010-000 INVESTMENT EARNINGS 1,568 1,300 268- -21% 6030-000-393000-000 INTERNAL SERVICES-DATA 131,165 262,331 131,166 50% ------------------------------------------------- TOTAL INFORMATION TECH REVENUE 275,724 628,631 352,907 56% ================================================= INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 93,559 189,303 95,744 51% 6030-401-410580-121 OVERTIME 51 1,000 949 95% 6030-401-410580-153 HEALTH INSURANCE 14,934 32,742 17,808 54% 6030-401-410580-155 RETIREMENT 7,531 15,017 7,486 50% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 1,097 2,300 1,203 52% 6030-403-410580-215 COMPUTER SUPPLIES 868 2,000 1,132 57% 6030-403-410580-218 EQUIPMENT-NOT CAPITAL 11,145 22,840 11,695 51% 6030-403-410580-325 WEBSITE 15,123 16,450 1,327 8% 6030-403-410580-345 PAGER/PHONE 392 900 508 56% 6030-403-410580-346 SUMMITNET & ISPS 2,590 28,140 25,550 91% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,597 4,000 403 10% 6030-403-410580-354 MAINTENANCE CONTRACTS 4,328 45,000 40,672 90% 6030-403-410580-355 LICENSES 6,475 20,185 13,710 68% 6030-403-410580-356 MAINTENANCE CONTRACTS 40,671 60,300 19,629 33% 6030-403-410580-357 GRANICUS 5,280 5,300 20 0% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 57,536 61,011 3,475 6% 6030-403-410580-373 DUES & TRAINING 1,078 8,275 7,197 87% 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 4,398 18,870 14,472 77% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 38,860 122,000 83,140 68% 6030-403-410585-532 COPIER LEASES 7,702 15,160 7,458 49% 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 2,250 3,870 1,620 42% 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 11,868 28,150 16,282 58% 6030-413-410588-354 POLICE - HOSTED SERVER 845 2,400 1,555 65% 6030-416-410588-218 COMPUTERS - FIRE 1,153 16,870 15,717 93% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 1,807 2,300 493 21% 6030-436-410588-218 COMPUTERS - PARKS 1,040 4,000 2,960 74% 6030-480-410588-218 COMMUNITY DEVELOPMENT 1,040 1,870 830 44% ------------------------------------------------- TOTAL INFORMATION TECH EXPENSE 343,510 853,693 510,183 60% ================================================= THE CITY OF KALISPELL, MONTANA01.13.2020 16:33 gb8501_pg.php/Job No: 20732 Page 36 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru December 31 50.00 % Yr Complete For Fiscal Year: 2020 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 268,000 536,000 268,000 50% 6010-000-371010-000 INVESTMENT EARNINGS 1,305 1,000 305- -31% ------------------------------------------------- TOTAL CENTRAL GARAGE REVENUE 269,305 537,000 267,695 50% ================================================= CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 79,129 162,350 83,221 51% 6010-410-431330-121 OVERTIME 1,229 2,500 1,271 51% 6010-410-431330-153 HEALTH INSURANCE 16,527 42,455 25,928 61% 6010-410-431330-155 RETIREMENT 5,702 12,130 6,428 53% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 3,080 11,000 7,920 72% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 1,186 8,000 6,814 85% 6010-410-431330-230 OIL 9,961 25,000 15,039 60% 6010-410-431330-231 GAS 323 1,500 1,177 78% 6010-410-431330-232 VEHICLE PARTS 62,654 126,000 63,346 50% 6010-410-431330-233 TIRES 30,755 50,000 19,245 38% 6010-410-431330-238 FILTERS 2,720 8,500 5,780 68% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 1,289 2,000 711 36% 6010-410-431330-341 ELECTRICITY 812 1,950 1,138 58% 6010-410-431330-344 NATURAL GAS 0 6,500 6,500 100% 6010-410-431330-354 CONTRACT SERVICES 16,139 32,000 15,861 50% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 42,069 126,375 84,306 67% 6010-410-431330-373 DUES & TRAINING 3,196 7,500 4,304 57% 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 4,730 9,460 4,730 50% 6010-410-431330-921 PARTS WASHER 4,431 10,500 6,069 58% ------------------------------------------------- TOTAL CENTRAL GARAGE EXPENSES 288,974 650,645 361,671 56% =================================================