The URL can be used to link to this page

06-02-17 City Manager ReportCity p of Kalispell OFFICE OF THE CITY MANAGER 001hVTA1*VA Information Memorandum 6/2/2017 1. Parks and Recreation Flathead Valley Disc Golf has donated materials and their time to improve the disc golf course at Lawrence Park. The poles were replaced on the back nine holes with regulation baskets. Flathead Valley Disc Golf plans to install concrete pads to make the course more permanent, maintenance friendly, and enjoyable for all park users. The main bathrooms at Woodland Park have been painted inside and outside. The next planned improvements are: new bathroom fixtures, stalls, and a refurbished concrete floor. Work has also been finished on the Woodland Park Camp Center bathrooms. This will allow public use during the summer months by providing access from the east side of the building. These bathrooms are located at the Camp Center and are adjacent to the Formal Garden. This year's Flathead High School student built home included Elm wood donated from the City of Kalispell, as a part of our Dutch Elm Disease removals. Elm wood is incorporated throughout the house in the window trim, banisters, and as this pantry door. LHC started moving soil at KYAC last week. Work started on the west side of the park and the contractor plans to work counter clockwise. They are moving the soil from the higher parts of KYAC to fill the lower portions. Signs and fencing have been placed to remind the public the area is closed due to construction activities. We are in the final weeks of getting the Woodland Water Park ready for the summer. Opening is scheduled for June 10. We are almost finished with the hiring process with 39 staff returning and 13 new staff joining the WWP team this summer. The pools have been drained and cleaned from winter debris and are ready to be filled on May 27. Staff training will begin May 30. Park and Recreation staff are in the process of transitioning Woodland Camp Center back into our Summer Day Camp facility after Flathead Valley Hockey Association removed their remaining equipment last week. We are also currently completing our Summer Day Camp hiring process. Summer Day Camp is at 80% capacity with 3,900 participants registered for this summer so far. 2. Public Works 2017 Street Restoration Projects Status: As part of the city's annual pavement restoration projects performed by the Street Division, the mill and overlay for Stillwater Road from Timberwolf Parkway to Three Mile Drive has been completed. This stretch of road will be chip sealed in July of 2017, followed by the pavement marking application. Solid Waste Annual Spring Cleanup Collection: The City of Kalispell's Solid Waste Division completed their fourth annual spring clean-up for residential rollout customers during the week of May 15. This annual service allows residential rollout customers to put large items and excess household items on the curb for rear loader pickup. These items may consist of couches, washers, dryers, yard debris, large boxes, and other items that do not fit in their rollout container. This service does not allow the collection of any hazardous products like oils, antifreeze, batteries, pesticides or weed killers. A two - man crew operating a rear loader collects the large items and deliver them to the County Landfill. The solid waste staff, in one week, removed around 21 tons of debris and 16 appliances for the residents on the roll out accounts. 3. Fire Department Since the last update, the Kalispell Fire Department has received 214 calls for service. As part of our public education program, department personnel assist and take part in numerous public activities throughout the year. On May 20, department personnel and other agencies took part in the Public Safety Day at the Summit Fitness Center. Crews provided safety information, engine and ambulance tours, and assisted with child car seat installations. Fire department staff have continued our Home Safety Survey program where staff can assist the community in making their homes fire safe and accident free. 2 On Tuesday, May 23, the Kalispell Fire Department Hazardous Materials Response Team participated in� a full scale exercise in collaboration with Flathead County Office of Emergency Services, the Montana Department of Emergency Services, and the 83ra Civil Support Team. The drill consisted of responding to a possible terrorist incident involving a - dispersal device and an unidentified white powder. The HazMat Team was able to use a variety of tests to identify the white powder and rule out certain biological and chemical hazards. 4. Community Development Kalispell's US DOT TIGER grant required an Environmental Assessment (EA) under the National Environmental Policy Act (NEPA). The EA has been available for a 30-day public comment period running May 19, 2017, through June 17, 2017. The document is available in hardcopy for review at the Community and Economic Development Department located in City Hall, 201 First Avenue East, Kalispell, as well as at the Imaginelf Library located at 247 First Avenue East, Kalispell. The document is available electronically at the City of Kalispell website at http://www.kalispell.com/community_ economic_ development and also at the Federal Railroad Administration's (FRA) website at https://www.fra.dot.gov/Page/P0214. This comment period is intended to satisfy the public involvement requirements of Section 106 of the National Historic Preservation Act and Section 4(f) of the U.S. Department of Transportation Act. These two laws afford protection to resources such as historic properties, parks, and recreational areas. The Federal Rail Administration (FRA) and the City will consider comments received during the public comment period before FRA makes a final NEPA decision and Section 4(f) determination. 5. Building Department Six single-family building permits were issued in the past 3 weeks. This brings the total for the year to 39 compared to last year at this time when 52 residential building permits had been issued. Construction has started on the RDO Equipment (John Deer) Remodel located at 3145 Hwy 93 S. The project is valued at $500,000. In addition, the permit for the Immanuel Lutheran Skilled Nursing facility located at 185 Crestline Ave was issued. This project is valued at $3.2 million. Fire inspections continue with 17 commercial facilities inspected in the month of May. Additionally, 6 re -inspections were conducted. 6 short-term rental inspections and 2 re - inspections were conducted. 6. Planning Department We are beginning to receive applications for short-term rentals. We have received 8 applications to date. 3 applications have been approved, 3 are in process, and 2 have been denied due to lack of off street parking and other code issues. We have contracted with a software company who will be supplying the addresses and locations of short-term rentals in the city. It appears that there are currently 66 such homes in the city that are actively advertising on one of the internet search engines. We have begun to systematically contact each of these properties and invite them to apply for a license. The Planning Board will meet on June 13 and hear a request from the Flathead County Economic Development Authority (FCEDA) concerning the development of a PUD for their 40-acre property known as the Glacier Rail Park. The PUD application seeks to address a number of zoning and subdivision regulations not anticipated in our local development code for the development of an industrial rail park including fencing heights, paving, signage and private road standards. A work session is scheduled immediately following the regular meeting to discuss the following: • Kalispell Downtown Plan • Kalispell Town Pump — Fuel Island Expansion — Planned Unit Development proposal at Cemetery Road and US 93 South. • B-3 Core Area Re -zone Phase 4 along west Center Street west of 51h Avenue West. 7. Information Services IT staff collected and recycled 870 pounds of e-waste on the special e-waste pickup that is done once a year. The video conference system in the courtroom was upgraded. Improved video quality will be realized from the cameras in the courtroom. IT staff are adding web conferencing abilities into the system to allow the court to video conference with people who only have a web connection and are not in a courtroom. The web conferencing is a new feature of the new video conference system. Previously a third party provided a service and a fee was paid for this type of conference. 8. Police Department ■�mr;� r Officer Jason Parce and K9, Cairo, have worked a total of 33 shifts together since being certified on March 17. During that time, they have been deployed 33 times. Every deployment has resulted in the seizure of illegal narcotics. A notable string of recent seizures occurred last weekend with three separate incidents resulting in heroin and meth seizures, and a felony fl warrant arrest of a female stemming from a canine deployment last month. These recent activities included a self -initiated traffic stop, an agency assist from Flathead County Sheriffs Office, and an agency assist from the NW Drug Task Force. The Kalispell Police Department has activated all 10 of the Watch Guard Body Worn Cameras purchased last fall. We are currently testing and evaluating the cameras to determine if the extent of Body Worn Cameras at the Kalispell Police Department in the future. Over the past several months, we have been working with our IT department to configure storage for the data, develop policies, and install Body Worn Camera equipment in the patrol vehicles. Officer Sean Keller has been meeting with tenants of an East Side Apartment complex to discuss crime prevention. Officer Keller discussed criminal behavior, crime prevention tactics, being a good witness, police investigation hurdles, and direction on establishing a neighborhood watch. On May 22-26, Det. Massie and Officer Petersen attended FBI Negotiator training in Helena. MT at MLEA. The course was forty hours in length and covered basic negotiations, including a number of hands on scenarios and active negotiations using role players. Both Officers are members of the four -man KPD Crisis Negotiations Team. With summer approaching and the end of the school year near, the Kalispell Police Department has been providing tours to children from local schools. In the final month of school, KPD has/will have given six tours. West Valley School and Fairmont Egan School first graders as well as preschoolers from the Knowledge Nest have visited KPD. 9. Finance Certified Annual Financial Report For the 7th consecutive fiscal year, the City of Kalispell has been presented the Certificate of Achievement in Financial Reporting by the Government Finance Officers Association of the United States and Canada (GFOA) for the fiscal year 2016 comprehensive annual financial report (CAFR). The CAFR has been judged by a panel to meet the standards of the program, including demonstrating a constructive "spirit of full disclosure" to clearly communicate its financial story and motivate potential users and user groups to read the CAFR. The Certificate of Achievement is the highest form of recognition in the area of governmental accounting and financial reporting, and its attainment represents a significant accomplishment. In addition, the finance department received an Award of Financial Reporting Achievement as the department primarily responsible for preparing the award -winning CAFR. 4th Avenue East Water Main Replacement Project Bonds The City of Kalispell plans to participate in the Montana Department of Natural Resources and Conservation Water Revolving Fund Program to finance the $2.984M 4th Avenue East Water Main Replacement Project. The interest rate on the 20-year term bonds is fixed at 2.50%. 5 City Financial Information thru May 31 Please find attached the budget to actual printouts reflecting the financial activity for the period July 1, 2016, thru May 31, 2017. This printout reflects 23.5 of the 26 payrolls for fiscal year 2017. All funds are included with the exception of the debt service funds. GOVERNMENTAL FUND REVENUES: General Fund General Fund revenue reflects taxes collected thru May 31. The general fund received an additional $20,000 of property taxes in April and May bringing collections to $3,057,939 (56%) of the budgeted annual amount ($5,490,000). Real property tax collections for the 4th quarter of fiscal year 2017 are expected to be near $2.5 million and more than adequate to fulfill the budgeted amount. The general fund is now carrying only $15,548 in protested taxes. City court fines and fees continue to decline, down 15% from the same time period of fiscal year 16 ($375,140). This is a continuing trend beginning in fiscal year 2015 when this revenue declined 7% from the prior fiscal period ($474,141). In fiscal year 2016, the decline was another 9% (435,668). Interest on the Old School Station property loan is being accrued, but not compounded and will be recognized when there is money from a property sale. Parks Parks revenues are at 67% of the fiscal year 2017 budget, and very comparable (64%) to the same period last fiscal year. Typically, a substantial portion of parks charges for services are received in the final quarter of the fiscal year. The final month of fiscal year 2016 accounted for 35% of the department's annual revenue. A substantial portion of that final month revenue is property taxes. Ambulance Ambulance fees for services are at about $640,000, about 72% of the budgeted amount of $891,000, thru May 31. At the current pace, fees will fall short of the budgeted amount of $891,000 by approximately 20% ($180,000). Building Department Revenue is already 237% of the annual budget. Building permits have more than doubled the budgeted amount of $350,000, and plan review fees are over 3.5 times the budgeted amount of $100,000. ENTERPRISE FUND REVENUES: Water Metered water sales thru May were $2,698,333. This is 95% of the budgeted amount. Year-end metered water sales are expected to exceed 100% of the budgeted amount. Water impact fees are up about $30,000 from the same period last fiscal year, and over 2x the budgeted amount. 0 Sewer Sewer service charges are $4,115,936, or about 94% of the budgeted amount. Last year's sewer service charges for the same period were $4,294,541. This decrease is the result of the hot and dry first quarter of fiscal year 16. Sanitary sewer and treatment plant impact fees have both exceeded the anticipated total fiscal year 2017 amount by 209% and 79%, respectively. EXPENDITURES/EXPENSES: For most funds, expenditures/expenses include the 24th (of 26) payroll period ending May 27th. Most departments and/or funds have at least 9% remaining in the salaries and retirement lines, which should be adequate. An exception is the fire department and ambulance fund where the majority of the employees are paid 13 times annually. For fire and ambulance, this report includes the 12th (of 13) pay period ending May 27. Fire and ambulance should have about 10% remaining to cover the remaining pay period. Fire and ambulance salaries and retirement are going to exceed the annual budgeted amount by about $45,000 and $10,000, respectively. This is due to a midyear contract implementation that increased maximum hours paid in a pay period. All departments, including fire and ambulance, should have at least 9% remaining in the health insurance expenditure line to cover the remainder of this fiscal year. With a few exceptions, administrative, central garage, and information technology transfers are done monthly and should show 8% remaining. This is the same on the revenue side for fees for services (Central Garage), internal services (Information Technology) and administrative charges (General Fund). The general fund administrative charges may vary slightly as some charges are based on a percentage of revenues collected. Annual budgeted operating transfers are generally done quarterly and should show 25% remaining. 7 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Pagel of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 3,131,751 5,490,000 2,358,249 43% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 14,907 17,000 2,093 12% 1000-000-311200-000 PERSONAL PROPERTY TAXES 136,843 120,000 16,843- -14% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 5,970 8,000 2,030 25% 1000-000-322101-000 LIQUOR LICENSES 30,945 30,000 945- -3% 1000-000-322300-000 BUSINESS LICENSES 1,551 1,700 149 9% 1000-000-323012-000 PLANNING FEES 73,237 30,000 43,237- -144% 1000-000-323109-000 SITE REVIEW 11,564 14,000 2,436 17% 1000-000-323200-000 PARADE PERMITS 750 1,000 250 25% 1000-000-335030-000 M.V. TAX - AD VALOREM 1,792 2,000 208 10% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 63,350 60,000 3,350- -6% 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,000 2,000 1,000 50% 1000-000-335230-000 HB124 ENTITLEMENT 2,080,371 2,773,829 693,458 25% 1000-000-341020-000 ADMINISTRATIVE CHARGES 527,029 574,367 47,338 8% 1000-000-341021-000 GRANT ADMIN FEES 0 5,000 5,000 100% 1000-000-341022-000 BOND FEES/ADMIN.CHG. 65,380 0 65,380- 0% 1000-000-341025-000 CITY COLLECTIONS 14,423 5,000 9,423- -188% 1000-000-342010-000 POLICE SERVICES 33,983 25,000 8,983- -36% 1000-000-342014-000 RESOURCE OFFICERS 149,037 149,037 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 1,031 10,000 8,969 90% 1000-000-343018-000 PARKING PERMITS 87,007 95,000 7,993 8% 1000-000-351000-000 CITY COURT FINES & FEES 321,429 500,000 178,571 36% 1000-000-351016-000 DUI COURT FINE 20 0 20- 0% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 25,430 30,000 4,570 15% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 35,720 35,000 720- -2% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 31,969 20,000 11,969- -60% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 4,874 7,500 2,626 35% 1000-000-371010-000 INVESTMENT EARNINGS 16,215 15,000 1,215- -8% 1000-000-373030-000 INTEREST ON OLD SCHOOL SID LOAN - 1 0 16,250 16,250 100% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 450,500 901,000 450,500 50% TOTAL GENERAL FUND REVENUE 7,318,080 10,937,683 3,619,603 33% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 2 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 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,935 2,935 0 0% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 14,250 14,250 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 2,134 4,000 1,866 47% 1000-400-410560-312 POSTAGE 12,012 16,000 3,988 25% 1000-400-410560-320 PRINTING & ENVELOPES 2,169 4,500 2,331 52% 1000-400-410560-354 CONTRACT SERVICES - DOC SHREDDING 123 500 378 76% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 2,038 4,000 1,962 49% 1000-400-420000-354 CONTRACT 911 CENTER 354,603 483,000 128,397 27% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 378 425 47 11% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 15,000 15,000 0 0% 1000-400-460452-366 HOCKADAY MAINTENANCE 6,600 6,600 0 0% 1000-400-510300-000 CONTINGENCY 882 30,000 29,118 97% 1000-400-510310-354 ICMA PLAN FEES 500 500 0 0% 1000-400-510330-513 LIABILITY INSURANCE 61,925 61,925 0 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 20,973 50,000 29,027 58% 1000-400-510330-517 PROPERTY INSURANCE 49,965 49,965 0 0% SUBTOTAL GEN.GOV'T. CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 1000-401-410210-153 HEALTH INSURANCE 1000-401-410210-155 RETIREMENT 1000-401-410210-210 COMPUTER SOFTWARE/SUPPLIES 1000-401-410210-312 NEWSLETTER/BOOKS 1000-401-410210-345 TELEPHONE & COMMUNICATION 1000-401-410210-373 DUES & TRAINING 1000-401-410210-379 MEETINGS SUBTOTAL CITY MANAGER HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 1000-401-410830-153 HEALTH INSURANCE 1000-401-410830-155 RETIREMENT 1000-401-410830-210 OFFICE SUPPLIES 1000-401-410830-338 RECRUITMENT/RELOCATION 1000-401-410830-354 CONTRACT SERVICES 1000-401-410830-373 DUES & TRAINING SUBTOTAL HUMAN RESOURCES 546,486 743,600 197,114 27% 122,535 137,795 15,260 11% 20,581 22,706 2,125 9% 13,082 14,569 1,487 10% 41 1,500 1,459 97% 0 400 400 100% 800 1,080 280 26% 4,531 8,300 3,769 45% 3,938 3,400 538- -16% 165,508 189,750 24,242 13% 110,594 123,814 13,220 11% 17,295 19,565 2,270 12% 8,559 9,466 907 10% 432 600 168 28% 3,967 8,000 4,033 50% 2,320 1,000 1,320- -132% 6,182 6,000 182- -3% 149,349 168,445 19,096 11% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 3 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 56,620 63,107 6,487 10% 1000-402-410100-153 HEALTH INSURANCE 52,360 57,698 5,338 9% 1000-402-410100-155 RETIREMENT 2,246 2,445 199 8% 1000-402-410100-210 OFFICE SUPPLIES 0 100 100 100% 1000-402-410100-335 MT LEAGUE OF CITIES 2,145 5,760 3,615 63% 1000-402-410100-354 CONTRACT SERVICES 2,391 4,500 2,109 47% 1000-402-410100-373 DUES & TRAINING 6,576 6,000 576- -10% 1000-402-410100-379 MEETINGS 6,353 8,000 1,647 21% SUBTOTAL MAYOR/COUNCIL 128,692 147,610 18,918 13% CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 79,205 88,953 9,748 11% 1000-402-410150-121 OVERTIME 0 250 250 100% 1000-402-410150-153 HEALTH INSURANCE 18,253 20,261 2,008 10% 1000-402-410150-155 RETIREMENT 6,143 6,832 689 10% 1000-402-410150-210 OFFICE SUPPLIES 0 200 200 100% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 0 700 700 100% 1000-402-410150-345 TELEPHONE & COMMUNICATION 440 480 40 8% 1000-402-410150-352 RECODIFICATION 3,944 3,700 244- -7% 1000-402-410150-354 CONTRACT SERVICES 0 300 300 100% 1000-402-410150-373 DUES & TRAINING 2,338 3,200 862 27% SUBTOTAL CITY CLERK 110,322 124,876 14,554 12% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 186,306 210,200 23,894 11% 1000-403-410550-153 HEALTH INSURANCE 36,229 38,445 2,216 6% 1000-403-410550-155 RETIREMENT 14,420 16,121 1,701 11% 1000-403-410550-210 SUPPLIES 190 300 110 37% 1000-403-410550-322 BOOKS 0 250 250 100% 1000-403-410550-353 CONTRACT SERVICES 180 2,000 1,820 91% 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 1,277 2,000 723 36% 1000-403-410550-355 BANK CHARGES & FEES 2,636 3,500 864 25% 1000-403-410550-373 DUES & TRAINING 4,159 6,500 2,341 36% SUBTOTAL FINANCE 245,396 279,316 33,920 12% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 4 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 326,295 364,724 38,429 11% 1000-404-411110-153 HEALTH INSURANCE 47,547 52,592 5,045 10% 1000-404-411110-155 RETIREMENT 25,230 29,906 4,676 16% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 819 2,500 1,681 67% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 8,670 8,000 670- -8% 1000-404-411110-345 TELEPHONE & COMMUNICATION 829 1,000 171 17% 1000-404-411110-354 CONTRACT SERVICES 177 5,000 4,823 96% 1000-404-411110-373 DUES & TRAINING 5,695 7,000 1,305 19% SUBTOTAL CITY ATTORNEY 415,263 470,722 55,459 12% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 199,621 226,938 27,317 12% 1000-406-410360-121 OVERTIME 550 0 550- 0% 1000-406-410360-153 HEALTH INSURANCE 40,714 51,568 10,854 21% 1000-406-410360-155 RETIREMENT 15,460 17,373 1,913 11% 1000-406-410360-210 SUPPLIES 2,949 4,500 1,551 34% 1000-406-410360-320 PRINTING/BOOKS 228 1,500 1,272 85% 1000-406-410360-345 TELEPHONE & COMMUNICATION 82 1,400 1,318 94% 1000-406-410360-353 SECURITY & TECHNOLOGY 37,621 40,000 2,379 6% 1000-406-410360-354 CONTRACT SERVICES 10,050 5,750 4,300- -75% 1000-406-410360-373 DUES & TRAINING 2,095 6,300 4,205 67% 1000-406-410360-394 JURY & WITNESS FEES 2,018 7,500 5,482 73% SUBTOTAL COURT 311,388 362,829 51,441 14% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 15,594 17,333 1,739 10% 1000-410-430100-153 HEALTH INSURANCE 2,871 3,278 407 12% 1000-410-430100-155 RETIREMENT 1,192 1,300 108 8% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 5,958 7,500 1,542 21% 1000-410-430100-231 GAS 2,237 2,500 263 11% 1000-410-430100-345 TELEPHONE & COMMUNICATION 276 300 24 8% 1000-410-430100-354 CONTRACT SERVICES 1,848 1,850 2 0% 1000-410-430100-373 DUES & TRAINING 2,623 2,500 123- -5% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 3,171 3,459 288 8% SUBTOTAL PUBLIC WORKS ADMIN 35,771 40,020 4,249 11% CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 59,511 67,873 8,362 12% 1000-412-411230-121 OVERTIME 514 0 514- 0% 1000-412-411230-153 HEALTH INSURANCE 12,092 15,847 3,755 24% 1000-412-411230-155 RETIREMENT 4,471 4,980 509 10% 1000-412-411230-220 SECURITY IMPROVEMENTS 0 800 800 100% 1000-412-411230-224 JANITORIAL SUPPLIES 2,923 6,000 3,077 51% 1000-412-411230-241 TOOLS & SUPPLIES 767 1,500 733 49% 1000-412-411230-341 ELECTRICITY 38,445 47,500 9,055 19% 1000-412-411230-344 NATURAL GAS 25,977 40,000 14,023 35% 1000-412-411230-345 TELEPHONE & COMMUNICATION 136 250 114 45% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 5 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-354 CONTRACT SERVICES 9,429 38,500 29,071 76% 1000-412-411230-355 HVAC MAINTENANCE OCNTRACT 15,146 17,300 2,154 12% 1000-412-411230-361 ELEVATOR MAINT/ FIRE ALARM MAINT 4,160 4,500 340 8% 1000-412-411230-362 EQUIPMENT MAINTENANCE 1,732 8,500 6,768 80% 1000-412-411230-366 BUILDING MAINTENANCE 19,569 20,000 431 2% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,310 3,500 190 5% 1000-412-411230-920 Public Safety Bldg - painting 27,699 30,000 2,301 8% SUBTOTAL CITY HALL 225,880 307,050 81,170 26% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 251,168 274,862 23,694 9% 1000-420-411020-153 HEALTH INSURANCE 51,471 59,495 8,024 13% 1000-420-411020-155 RETIREMENT 19,139 21,071 1,932 9% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 399 5,000 4,601 92% 1000-420-411020-231 GAS 105 400 295 74% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 853 2,000 1,147 57% 1000-420-411020-345 TELEPHONE 963 750 213- -28% 1000-420-411020-354 CONTRACT SERVICES 0 1,000 1,000 100% 1000-420-411020-373 DUES & TRAINING 1,619 5,500 3,881 71% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 1,187 1,295 108 8% SUBTOTAL PLANNING DEPT. 326,904 371,373 44,469 12% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 55,211 61,676 6,465 10% 1000-480-470210-153 HEALTH INSURANCE 7,480 8,243 763 9% 1000-480-470210-155 RETIREMENT 4,267 4,704 437 9% 1000-480-470210-210 OFFICE SUPPLIES 106 1,500 1,394 93% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 594 500 94- -19% 1000-480-470210-312 POSTAGE & PRINTING 49 500 451 90% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 500 500 0 0% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 551 750 199 26% 1000-480-470210-354 CONTRACT SERVICES 265 1,500 1,235 82% 1000-480-470210-373 DUES & TRAINING 4,020 5,000 980 20% 1000-480-470210-379 MEETINGS 220 1,000 780 78% SUBTOTAL COMMUNITY DEVELOPMENT 73,263 85,873 12,610 15% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 6 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 1,917,738 2,114,612 196,874 9% 1000-413-420140-112 SALARIES -SEVERANCE 61,811 33,500 28,311- -85% 1000-413-420140-114 SALARY -comptime buyout 4,445 4,350 95- -2% 1000-413-420140-121 OVERTIME (REG & AET OT) 60,504 80,000 19,496 24% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 3,446 25,000 21,554 86% 1000-413-420140-153 HEALTH INSURANCE 386,777 413,628 26,851 6% 1000-413-420140-155 RETIREMENT 248,575 275,152 26,577 10% 1000-413-420140-210 OFFICE SUPPLIES 3,061 3,500 439 13% 1000-413-420140-215 COMPUTER SUPPLIES 1,943 5,500 3,557 65% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 40,423 48,500 8,077 17% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 2,590 4,000 1,410 35% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 6,610 7,000 390 6% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 1,379 2,000 621 31% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 4,856 5,000 144 3% 1000-413-420140-227 AMMO & RELATED SUPPLIES 10,917 19,000 8,083 43% 1000-413-420140-228 PATROL CAR SUPPLIES 13,224 13,000 224- -2% 1000-413-420140-229 OTHER SUPPLIES 10,609 10,000 609- -6% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 904 1,000 96 10% 1000-413-420140-231 GAS 53,215 95,000 41,785 44% 1000-413-420140-234 CRISIS NEGOTIATIONS 2,012 2,000 12- -1% 1000-413-420140-235 BIKE PATROL 244 750 506 67% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 280 1,500 1,220 81% 1000-413-420140-320 PRINTING 4,619 5,500 881 16% 1000-413-420140-345 TELEPHONE & COMMUNICATION 15,120 15,500 380 2% 1000-413-420140-354 CONTRACT SERVICES 8,065 6,875 1,190- -17% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 5,399 6,500 1,101 17% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 167 2,000 1,833 92% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 2,975 2,000 975- -49% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 40,398 40,625 227 1% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 1,185 2,500 1,315 53% 1000-413-420140-373 DUES & TRAINING 31,693 30,000 1,693- -6% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 1,031 10,000 8,969 90% 1000-413-420140-380 TRAINING MATERIALS 69 2,000 1,931 97% 1000-413-420140-388 MEDICAL SERVICES 2,611 2,500 111- -4% 1000-413-420140-392 BOARDING/TREATING PRISONERS 2,339 2,500 161 6% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 67,574 73,718 6,144 8% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 50,625 67,500 16,875 25% 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 116,250 155,000 38,750 25% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 2,625 3,500 875 25% 1000-413-420140-922 USFS PROPERTY ACQUISITION 0 27,482 27,482 100% 1000-413-420140-944 VEHICLES 143,575 115,878 27,697- -24% SUBTOTAL POLICE DEPT. 3,331,885 3,735,570 403,685 11% DETECTIVES 1000-413-420141-110 SALARIES -DETECTIVES 1000-413-420141-121 DETECTIVE -OVERTIME 1000-413-420141-153 HEALTH INSURANCE 1000-413-420141-155 DETECTIVE -RETIREMENT TOTAL DETECTIVES RECORDS 313,735 365,552 51,817 14% 7,102 15,000 7,898 53% 64,603 66,611 2,009 3% 41,269 48,938 7,669 16% 426,708 496,101 69,393 14% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 7 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-110 SALARIES -RECORDS DIVISION 125,960 142,039 16,079 11% 1000-413-420142-121 OVERTIME 3,298 7,500 4,202 56% 1000-413-420142-153 HEALTH INSURANCE 29,621 32,970 3,349 10% 1000-413-420142-155 RETIREMENT 9,892 10,720 828 8% 1000-413-420142-215 COMPUTER SUPPLIES 216 0 216- 0% TOTAL RECORDS 168,987 193,229 24,242 13% RESOURCE OFFICERS 1000-413-420144-110 SALARIES -SRO 162,984 182,257 19,273 11% 1000-413-420144-153 HEALTH INSURANCE 34,179 46,773 12,594 27% 1000-413-420144-155 SRO RETIREMENT 20,175 24,447 4,272 17% TOTAL RESOURCE OFFICERS 217,338 253,477 36,139 14% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL -SALARIES 37,227 38,723 1,496 4% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 7,480 8,243 763 9% 1000-413-420145-155 RETIREMENT 2,718 2,920 202 7% SUBTOTAL ANIMAL CONTROL 47,425 50,386 2,961 6% PARKING 1000-413-420147-110 PARKINGS -SALARIES 78,908 86,114 7,206 8% 1000-413-420147-153 HEALTH INSURANCE 23,265 30,585 7,320 24% 1000-413-420147-155 RETIREMENT 5,944 6,494 550 8% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 906 4,000 3,094 77% 1000-413-420147-354 CONTRACTED SERVICES 1,808 2,000 192 10% 1000-413-420147-362 LOT MAINT 5,143 10,000 4,857 49% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 22,395 17,500 4,895- -28% 1000-413-420147-550 LOT LEASE PAYMENTS 1,302 1,500 198 13% SUBTOTAL PARKING 139,671 158,193 18,522 12% SUBTOTAL POLICE DEPT. 4,332,014 4,886,956 554,942 11% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 8 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. FIRE DEPARTMENT 1000-416-420400-110 SALARIES -FIRE SUPPRESSION 1,467,200 1,592,324 125,124 8% 1000-416-420400-114 COMPTIME BUYOUT 3,784 5,500 1,716 31% 1000-416-420400-115 OUT OF RANK PAY 11,866 12,000 134 1% 1000-416-420400-121 OVERTIME 52,593 40,000 12,593- -31% 1000-416-420400-153 HEALTH INSURANCE 273,710 312,701 38,991 12% 1000-416-420400-155 RETIREMENT 195,022 212,650 17,628 8% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 966 2,000 1,034 52% 1000-416-420400-218 Equipment (Non Capital) 4,468 21,500 17,032 79% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 14,658 15,000 342 2% 1000-416-420400-224 JANITORIAL SUPPLIES 2,899 5,000 2,101 42% 1000-416-420400-231 GAS 7,594 17,325 9,731 56% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 9,188 15,000 5,812 39% 1000-416-420400-320 PRINTING 0 200 200 100% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 275 1,000 725 73% 1000-416-420400-345 TELEPHONE & COMMUNICATION 4,027 6,000 1,973 33% 1000-416-420400-354 CONTRACT SERVICES 10,082 12,000 1,918 16% 1000-416-420400-362 EQUIPMENT MAINTENANCE 6,131 5,500 631- -11% 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 7,477 7,500 23 0% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 4,281 5,000 719 14% 1000-416-420400-373 DUES & TRAINING 5,495 10,000 4,505 45% 1000-416-420400-388 FIREFIGHTER PHYSICALS 21,825 25,875 4,050 16% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 40,277 43,938 3,661 8% 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 0 40,000 40,000 100% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 112,500 150,000 37,500 25% 1000-416-420400-821 TRANSFER TO FUND 2956 GRANT MATCH 0 18,454 18,454 100% 1000-416-420400-922 USFS PROPERTY ACQUISITION 0 27,482 27,482 100% 1000-416-420400-940 CAPITAL EQUIPMENT - COMMAND VEHICLE 35,849 35,000 849- -2% 1000-416-420440-110 SALARIES -FIRE PREVENTION 44,612 51,287 6,675 13% 1000-416-420440-114 COMPTIME BUYOUT 325 0 325- 0% 1000-416-420440-121 OVERTIME 8,154 0 8,154- 0% 1000-416-420440-153 HEALTH INSURANCE 7,708 7,826 118 2% 1000-416-420440-155 RETIREMENT 3,904 3,697 207- -6% SUBTOTAL FIRE DEPT. GRAND TOTAL GENERAL FUND SPECIAL REVENUE FUNDS: PERMISSIVE HEALTH LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND TOTAL PERMISSIVE HEALTH LEVY 2,356,869 2,701,759 344,890 13% 9,423,104 10,880,179 1,457,075 13% 518,750 992,000 473,250 48% 518,750 992,000 473,250 48% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 9 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 548,153 970,000 421,847 43% 2215-000-311200-000 PERSONAL PROPERTY TAXES 33,372 35,000 1,628 5% 2215-000-312000-000 PEN & INTEREST DEL TAXES 975 2,000 1,025 51% 2215-000-346030-000 SWIMMING POOL FEES 80,667 140,000 59,333 42% 2215-000-346040-000 CONCESSION STAND REVENUE 25,103 35,000 9,897 28% 2215-000-346050-000 PARKS USAGE FEES 18,377 21,000 2,623 12% 2215-000-346051-000 RECREATION FEES 10,875 8,000 2,875- -36% 2215-000-346052-000 SPORTS PROGRAMS 44,183 45,000 817 2% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 2,759 2,500 259- -10% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 66,676 70,000 3,324 5% 2215-000-346055-000 ICE RINK 20,846 25,000 4,154 17% 2215-000-346056-000 KIDSPORT USAGE 1,973 300 1,673- -558% 2215-000-346057-000 YOUTH CAMPS 130,389 142,000 11,611 8% 2215-000-346059-000 PICNIC IN THE PARK 22,945 30,000 7,056 24% 2215-000-362015-000 INSURANCE REIMBURSEMENTS 18,762 0 18,762- 0% 2215-000-365010-000 FEC REFUNDS/DONATIONS 15,188 0 15,188- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-371010-000 INVESTMENTS 2,684 2,000 684- -34% 2215-000-381050-000 INCEPTION OF LEASE 90,773 130,000 39,227 30% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 68,250 91,000 22,750 25% TOTAL PARKS & REC REVENUE 1,202,950 1,768,800 565,850 32% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 281,582 316,192 34,610 11% 2215-436-460430-111 SEASONAL SALARIES 50,535 65,276 14,741 23% 2215-436-460430-121 OVERTIME 0 500 500 100% 2215-436-460430-153 HEALTH INSURANCE 55,754 61,643 5,889 10% 2215-436-460430-155 RETIREMENT 23,926 26,136 2,210 8% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 860 1,000 140 14% 2215-436-460430-224 JANITORIAL SUPPLIES 4,312 5,000 688 14% 2215-436-460430-229 OTHER SUPPLIES 2,649 4,000 1,351 34% 2215-436-460430-231 GAS 11,310 18,000 6,690 37% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 1,304 2,500 1,196 48% 2215-436-460430-320 PRINTING & ADVERTISING 169 400 231 58% 2215-436-460430-341 ELECTRICITY 11,603 16,000 4,397 27% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 20,918 25,000 4,082 16% 2215-436-460430-344 NATURAL GAS 1,803 3,000 1,197 40% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 2,261 3,040 779 26% 2215-436-460430-351 TENNIS COURT REHABILITATION 0 2,000 2,000 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 2,000 2,000 100% 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 480 5,000 4,520 90% 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 0 2,680 2,680 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 2,582 5,000 2,418 48% 2215-436-460430-364 LANDSCAPING 2,403 5,500 3,097 56% 2215-436-460430-367 VANDALISM REPAIRS 31,734 4,000 27,734- -693% 2215-436-460430-373 DUES & TRAINING 5,255 6,000 745 12% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 151 600 450 75% 2215-436-460430-395 EQUIPMENT RENTAL 301 500 200 40% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 76 3,000 2,924 97% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 10 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-440 IRRIGATION SUPPLIES 4,873 9,000 4,127 46% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 569 1,700 1,131 67% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 40,202 43,857 3,655 8% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 9,112 29,112 20,000 69% 2215-436-460430-620 DEBT SERVICE INTEREST 327 784 457 58% 2215-436-460430-941 CAPITAL OUTLAY: FLATBED, MOWER, WOO 99,615 137,000 37,385 27% SUBTOTAL PARKS EXPENDITURES 666,666 805,420 138,754 17% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 2215-436-460440-111 SEASONAL SALARIES 2215-436-460440-153 HEALTH INSURANCE 2215-436-460440-155 RETIREMENT 2215-436-460440-221 SAFETY EQUIPMENT 2215-436-460440-229 OTHER SUPPLIES 2215-436-460440-231 GAS 2215-436-460440-241 CONSUMABLE TOOLS 2215-436-460440-341 ELECTRICITY 2215-436-460440-345 TELEPHONE & COMMUNICATION 2215-436-460440-354 CONTRACT SERVICES 2215-436-460440-355 CONTRACT SERVICES - ASPHALT RESURFC 2215-436-460440-362 EQUIPMENT MAINTENANCE 2215-436-460440-364 LANDSCAPING 2215-436-460440-367 VANDALISM REPAIRS 2215-436-460440-373 DUES & TRAINING 2215-436-460440-395 RENTAL EQUIPMENT 2215-436-460440-420 METAL PRODUCTS 2215-436-460440-440 IRRIGATION 2215-436-460440-452 SAND & GRAVEL 2215-436-460440-940 EQUIPMENT SUBTOTAL ATHLETIC COMPLEX 60,100 89,153 29,053 33% 31,049 41,906 10,857 26% 14,589 25,922 11,333 44% 6,316 10,046 3,730 37% 26 350 324 93% 11,487 15,500 4,013 26% 3,865 10,500 6,635 63% 1,399 1,500 101 7% 4,955 7,700 2,745 36% 134 175 41 24% 0 1,000 1,000 100% 42,274 40,534 1,740- -4% 434 600 166 28% 528 600 72 12% 300 500 200 40% 401 500 99 20% 0 150 150 100% 0 300 300 100% 3,551 4,000 449 11% 0 1,000 1,000 100% 23,988 24,000 12 0% 205,395 275,936 70,541 26% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 71,939 81,678 9,739 12% 2215-436-460431-111 SEASONAL SALARIES 6,440 8,285 1,845 22% 2215-436-460431-153 HEALTH INSURANCE 18,409 23,906 5,497 23% 2215-436-460431-155 RETIREMENT 5,529 6,705 1,176 18% 2215-436-460431-229 MISC. SUPPLIES 7,051 9,435 2,384 25% 2215-436-460431-231 GAS 590 590 0 0% 2215-436-460431-320 PRINTING & ADVERTISING 25 10,800 10,775 100% 2215-436-460431-345 TELEPHONE & COMMUNICATION 637 1,661 1,024 62% 2215-436-460431-354 CONTRACT SERVICES 17,505 19,093 1,588 8% 2215-436-460431-357 MUSIC FRANCHISE FEES 1,042 1,100 58 5% 2215-436-460431-373 DUES & TRAINING 509 728 219 30% SUBTOTAL RECREATION 129,674 163,981 34,307 21% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 63,935 72,793 8,858 12% 2215-436-460448-111 SEASONAL SALARIES 84,873 136,855 51,982 38% 2215-436-460448-121 OVERTIME 0 300 300 100% 2215-436-460448-153 HEALTH INSURANCE 17,350 22,953 5,603 24% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 11 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460448-155 RETIREMENT 4,909 6,424 1,515 24% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 186 400 214 54% 2215-436-460448-229 MISC. SUPPLIES 860 3,600 2,740 76% 2215-436-460448-231 GAS 266 300 34 11% 2215-436-460448-320 PRINTING & ADVERTISING 0 100 100 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 951 765 186- -24% 2215-436-460448-354 CONTRACT SERVICES 8,556 13,000 4,444 34% 2215-436-460448-355 AFTER SCHOOL PROGRAM 1,554 800 754- -94% 2215-436-460448-356 BANK FEES/CC CHARGES 1,941 3,900 1,959 50% 2215-436-460448-373 DUES & TRAINING 591 800 209 26% SUBTOTAL YOUTH CAMPS 185,971 262,990 77,019 29% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 121,356 190,325 68,969 36% 2215-437-460445-112 SEVERANCE 0 2,535 2,535 100% 2215-437-460445-121 OVERTIME 187 500 313 63% 2215-437-460445-155 RETIREMENT 929 1,500 571 38% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 42 400 358 90% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 2,029 2,200 171 8% 2215-437-460445-226 CHLORINE/CHEMICALS 27,105 25,000 2,105- -8% 2215-437-460445-228 CONCESSION STAND SUPPLIES 9,890 21,000 11,110 53% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 908 4,500 3,592 80% 2215-437-460445-341 ELECTRICITY 6,170 9,500 3,330 35% 2215-437-460445-344 NATURAL GAS 13,622 25,000 11,378 46% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,458 1,620 162 10% 2215-437-460445-354 LICENSES & FEES 590 1,300 710 55% 2215-437-460445-356 BANK FEES/ CC CHARGES 1,157 1,200 43 4% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 9,471 14,600 5,129 35% 2215-437-460445-380 TRAINING MATERIALS 470 1,800 1,330 74% SUBTOTAL POOL EXPENDITURES 195,383 302,980 107,597 36% TOTAL PARKS & RECREATION/POOL 1,383,089 1,811,307 428,218 24% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 12 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING FORESTRY & DEVELOPER TREES 2600-436-460433-110 SALARIES -URBAN FORESTRY 90,633 107,421 16,788 16% 2600-436-460433-111 SEASONAL SERVICES 11,536 25,731 14,195 55% 2600-436-460433-121 OVERTIME 0 300 300 100% 2600-436-460433-153 HEALTH INSURANCE 19,714 24,764 5,050 20% 2600-436-460433-155 RETIREMENT 6,878 9,713 2,835 29% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 41 600 559 93% 2600-436-460433-231 GAS 1,345 4,500 3,155 70% 2600-436-460433-241 CONSUMABLE TOOLS 2,396 4,500 2,104 47% 2600-436-460433-354 CONTRACT SERVICES 26,020 35,000 8,980 26% 2600-436-460433-357 FORESTRY GRANT 9,899 11,880 1,981 17% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 3,102 6,750 3,648 54% 2600-436-460433-362 EQUIPMENT MAINTENANCE 336 4,000 3,664 92% 2600-436-460433-364 LANDSCAPING & TREES 4,021 8,000 3,979 50% 2600-436-460433-373 DUES & TRAINING 1,830 2,000 170 9% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 628 628 0 0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 6,754 7,368 614 8% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 7,582 8,272 690 8% 2600-436-460433-528 DATA PROCESSING TRANSFER 3,823 4,171 348 8% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 10,824 15,000 4,176 28% 2600-436-460433-620 INTEREST EXPENSE 665 1,000 335 34% 2600-436-460433-940 MACHINERY & EQUIPMENT 0 40,000 40,000 100% TOTAL URBAN FORESTRY 208,028 321,598 113,570 35% 2601-436-460435-351 EMPIRE ESTATES ($44,911) 2601-436-460435-352 APPLEWAY ($4,564) 2601-436-460435-353 LEISURE HEIGHTS ($9,990) 2601-436-460435-354 CONTRACT SERVICES 2601-436-460435-356 SINOPAH SUBD ($5,790) 2601-436-460435-357 COTTONWOOD SUBD ($13,100) 2601-436-460435-358 WEST VIEW SUBD ($22,680) 2601-436-460435-359 MTN VISTA ESTATES ($35,903+34,660) 2601-436-460435-361 VILLAGE GREENS ($3,540) 2601-436-460435-362 WESTVIEW BUSINESS CNTR ($1,618) 2601-436-460435-363 MUSKRAT SLOUGH ($1,446) 2601-436-460435-364 MTN VISTA ESTATES III $17,278.25 2601-436-460435-365 VILLAGE GREENS $3,540 2601-436-460435-366 W VIEW ESTATES $20,060 2601-436-460435-367 ABIGAIL SUBDIVISION ($4,253.90) 2601-436-460435-368 NORTHLAND SUBD PHASE 4 TOTAL DEVELOPER TREES 2210 PARKS IN LIEU 2210-436-460430-934 CAPITAL IMPROVEMENTS TOTAL PARKS IN LIEU 0 8,653 8,653 100% 0 4,336 4,336 100% 0 366 366 100% 0 11,231 11,231 100% 0 667 667 100% 0 1,928 1,928 100% 650 16,236 15,586 96% 0 27,079 27,079 100% 1,950 2,219 269 12% 0 948 948 100% 0 1,390 1,390 100% 650 1,134 484 43% 0 2,797 2,797 100% 0 8,490 8,490 100% 0 2,716 2,716 100% 0 8,812 8,812 100% 3,250 99,002 95,752 97% 0 1,417 1,417 100% 0 1,417 1,417 100% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 13 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 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 504,063 891,000 386,937 43% 2230-000-342070-000 COUNTY EMS LEVY 50,300 110,000 59,700 54% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 112,500 150,000 37,500 25% TOTAL AMBULANCE REVENUE 666,863 1,151,000 484,137 42% AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 555,329 608,459 53,130 9% 2230-440-420730-114 COMPTIME BUYBACK 2,168 3,500 1,332 38% 2230-440-420730-115 OUT OF RANK PAY 1,435 1,000 435- -43% 2230-440-420730-121 OVERTIME 52,024 50,000 2,024- -4% 2230-440-420730-153 HEALTH INSURANCE 133,089 159,142 26,053 16% 2230-440-420730-155 RETIREMENT 75,511 80,552 5,041 6% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 844 1,000 156 16% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 4,108 4,000 108- -3% 2230-440-420730-231 GAS & OIL 4,856 7,560 2,704 36% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 170 4,000 3,830 96% 2230-440-420730-312 POSTAGE/PRINTING 32 1,500 1,468 98% 2230-440-420730-345 TELEPHONE & COMMUNICATION 1,527 1,200 327- -27% 2230-440-420730-354 CONTRACT SERVICES 13,230 17,800 4,570 26% 2230-440-420730-355 911 CENTER CONTRIBUTION 25,500 34,000 8,500 25% 2230-440-420730-359 AUDIT/CC OTHER FEES 3,053 1,400 1,653- -118% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 5,000 5,000 0 0% 2230-440-420730-373 DUES & TRAINING 2,537 5,000 2,463 49% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,500 2,500 100% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 23,209 46,000 22,791 50% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 7,614 7,614 0 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 14,876 16,229 1,353 8% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 38,590 42,099 3,509 8% 2230-440-420730-528 DATA PROCESSING TRANSFER 15,293 16,684 1,391 8% 2230-440-420730-940 EQUIPMENT 169,707 170,000 293 0% TOTAL AMBULANCE EXPENDITURES 1,149,704 1,286,239 136,535 11% 2399 PUBLIC SAFETY IMPACT FEES 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 10,000 10,000 0 0% 2399-413-420140-940 POLICE EQUIPMENT 0 60,000 60,000 100% 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 65,500 65,500 0 0% 2399-416-420400-620 INTEREST - FIRE TRUCK 4,632 4,651 19 0% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 500,000 500,000 100% TOTAL PUBLIC SAFETY IMPACT FEE 80,132 640,151 560,019 87% FIRE & HAZMAT GRANTS 2956-416-420400-218 EQUIPMENT (NON CAPITAL) 0 2,200 2,200 100% 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 2,685 3,000 315 10% 2956-416-420415-940 AFG GRT (POWER COTS) EMW2014FOO5022 0 225,000 225,000 100% TOTAL FIRE GRANTS 2,685 230,200 227,515 99% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 14 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2957-416-420400-155 RETIREMENT 0 2,500 2,500 100% 2957-416-420410-125 PASS THRU HAZMAT OT 13,055 19,365 6,310 33% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 16,655 33,113 16,458 50% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 2,677 6,100 3,423 56% TOTAL HAZMAT GRANTS 32,386 61,078 28,692 47% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 15 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 738,846 350,000 388,846- -111% 2394-000-323103-000 PLUMBING PERMITS 32,692 20,000 12,692- -63% 2394-000-323104-000 MECHANICAL PERMITS 38,332 30,000 8,332- -28% 2394-000-323105-000 ELECTRICAL PERMITS 77,593 30,000 47,593- -159% 2394-000-323108-000 PLAN REVIEW FEES 365,593 100,000 265,593- -266% 2394-000-371010-000 INVESTMENT EARNINGS 11,491 4,500 6,991- -155% TOTAL REVENUE 1,264,546 534,500 730,046- -137% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 329,788 374,578 44,790 12% 2394-420-420530-121 OVERTIME 12,991 5,000 7,991- -160% 2394-420-420530-153 HEALTH INSURANCE 66,782 85,277 18,495 22% 2394-420-420530-155 RETIREMENT 25,225 27,529 2,304 8% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 26,760 20,000 6,760- -34% 2394-420-420530-231 GAS & OIL 2,611 3,500 889 25% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 1,003 2,500 1,497 60% 2394-420-420530-323 ST. ED. ASSESSMENTS 4,546 3,000 1,546- -52% 2394-420-420530-345 TELEPHONE & COMMUNICATION 3,070 3,500 430 12% 2394-420-420530-353 AUDITING 1,000 0 1,000- 0% 2394-420-420530-354 CONTRACT SERVICES 33,938 43,500 9,562 22% 2394-420-420530-355 CITY WORKS LICENSING FEE 15,156 15,000 156- -1% 2394-420-420530-373 DUES & TRAINING 12,974 9,000 3,974- -44% 2394-420-420530-510 PROPERTY INSURANCE 2,585 2,585 0 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 1,332 1,454 122 8% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 14,925 16,282 1,357 8% 2394-420-420530-528 DATA PROCESSING TRANSFER 26,763 29,196 2,433 8% 2394-420-420530-944 VEHICLES 63,145 65,000 1,855 3% TOTAL BUILDING DEPT. 644,594 706,901 62,307 9% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 16 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 63,570 70,405 6,835 10% 2400-410-430263-153 HEALTH INSURANCE 10,299 13,628 3,329 24% 2400-410-430263-155 RETIREMENT 4,685 5,141 456 9% 2400-410-430263-244 STREET LIGHT SUPPLIES 3,846 18,000 14,154 79% 2400-410-430263-341 ELECTRICITY 129,810 173,000 43,190 25% 2400-410-430263-360 REPAIR & MAINT SERVICES 4,468 20,000 15,532 78% 2400-410-430263-510 INSURANCE 392 1,000 608 61% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 11,594 12,648 1,054 8% 2400-410-430263-920 NEW LUMINAIRES 0 30,000 30,000 100% 2400-410-490500-610 DEBT SERVICE -PRINCIPAL 21,862 21,862 0 0% 2400-410-490500-620 DEBT SERVICE -INTEREST EXPENSE 596 681 85 13% TOTAL LIGHT MAINT. 251,122 366,365 115,243 31% 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 11,928 56,485 44,557 79% 2420-421-430234-957 ALLEY PAVING 33,435 41,627 8,192 20% 2420-421-430240-231 GAS & OIL 26,208 43,000 16,792 39% 2420-421-430240-344 NATURAL GAS 4,307 5,500 1,193 22% 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 106,489 225,562 119,073 53% 2420-421-430240-452 GRAVEL 0 3,500 3,500 100% 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 20,047 40,000 19,953 50% 2420-421-430240-472 ASPHALT 24,477 53,000 28,523 54% 2420-421-430240-473 CRACK SEALING 4,362 14,500 10,138 70% 2420-421-430240-474 PAINT STRIPING MATERIALS 2,560 60,000 57,440 96% TOTAL GAS TAX 234,263 569,674 335,411 59% 2825 MACI GRANT 2825-421-430240-940 SANDER / SWEEPER 0 433,202 433,202 100% TOTAL MACI GRANT 0 433,202 433,202 100% 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 605,666 709,550 103,884 15% 2500-421-430240-121 OVERTIME 35,135 25,000 10,135- -41% 2500-421-430240-153 HEALTH INSURANCE 134,460 172,495 38,035 22% 2500-421-430240-155 RETIREMENT 47,119 51,452 4,333 8% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 489 9,000 8,511 95% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 5,563 6,500 937 14% 2500-421-430240-220 OTHER SUPPLIES 3,726 4,500 774 17% 2500-421-430240-231 GAS & OIL 27,660 40,000 12,340 31% 2500-421-430240-341 ELECTRICITY 2,354 3,300 946 29% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 1,114 1,500 386 26% 2500-421-430240-354 CONTRACT SERVICES 10,572 30,000 19,428 65% 2500-421-430240-356 CONSULTANT - TRANSPORTATION PLAN UP 0 62,892 62,892 100% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 25,947 32,500 6,554 20% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 17 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2500-421-430240-366 BUILDING MAINTENANCE 3,000 3,000 0- -0% 2500-421-430240-373 DUES & TRAINING 2,161 5,500 3,340 61% 2500-421-430240-388 MEDICAL SERVICES 368 1,500 1,133 76% 2500-421-430240-510 LIABILITY INSURANCE 13,578 13,578 0 0% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 100% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 164,284 179,219 14,935 8% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 83,024 90,571 7,547 8% 2500-421-430240-528 DATA PROCESSING TRANSFER 11,470 12,513 1,043 8% 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 111,946 111,946 0- 0% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 3,016 3,447 431 13% 2500-421-430240-920 SALT BRINE TANK 8,950 20,000 11,050 55% 2500-421-430240-921 SAND/COLD MIX STORAGE SHED 2,395 25,771 23,376 91% 2500-421-430240-922 USFS PROPERTY ACQUISITION 604 54,964 54,360 99% 2500-421-430240-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 2500-421-430240-969 4TH AVE E MAIN REPLC PHASE 1-4 0 1,114,018 1,114,018 100% 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 161,244 762,359 601,115 79% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 251,137 300,544 49,407 16% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 100% 2500-421-430264-110 TSS - SALARIES 108,772 122,685 13,913 11% 2500-421-430264-121 OVERTIME 607 7,500 6,893 92% 2500-421-430264-153 HEALTH INSURANCE 14,922 17,485 2,563 15% 2500-421-430264-155 RETIREMENT 7,956 8,823 867 10% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 1,822 1,500 322- -21% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,097 6,700 5,603 84% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 2,228 3,500 1,272 36% 2500-421-430264-242 STREET SIGNS 17,710 40,000 22,290 56% 2500-421-430264-243 TRAFFIC SIGNALS 8,534 19,000 10,466 55% 2500-421-430264-245 BARRICADE MATERIALS 1,155 5,000 3,845 77% 2500-421-430264-341 ELECTRICITY 1,584 3,000 1,416 47% 2500-421-430264-345 COMMUNICATIONS 625 750 125 17% 2500-421-430264-354 CONTRACT SERVICES 3,198 10,000 6,802 68% 2500-421-430264-362 EQUIPMENT MAINTENANCE 511 3,000 2,489 83% 2500-421-430264-366 BUILDING MAINTENANCE 1,900 2,000 100 5% 2500-421-430264-373 DUES & TRAINING 2,524 5,500 2,976 54% 2500-421-430264-428 PAINT MATERIALS 68 8,000 7,933 99% 2500-421-430264-510 LIABILITY INS.-TSS 1,604 1,604 0 0% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 9,838 2,500 7,338- -294% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 7,273 7,934 661 8% 2500-421-430264-532 OFFICE RENT 6,422 6,422 0 0% TOTAL SPEC. ST. MAINT. 1,917,331 4,198,902 2,281,571 54% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 18 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 1,600 1,600 0 0% 2185-000-430300-356 REDEVELOPMENT / CONTRACT SERVICES 291 0 291- 0% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 8,473 9,243 770 8% 2185-000-430300-840 REDEVELOPMENT ACTIVITY 0 1,750,000 1,750,000 100% 2185-480-470240-110 SALARIES 17,502 20,256 2,754 14% 2185-480-470240-153 HEALTH INSURANCE 2,618 2,935 317 11% 2185-480-470240-155 RETIREMENT 1,353 1,526 173 11% 2185-480-470240-345 TELEPHONE & COMMUNICATION 44 48 4 8% TOTAL AIRPORT TIF 31,881 1,785,608 1,753,727 98% 2188 WESTSIDE TIF 2188-480-470230-110 SALARIES 37,529 43,983 6,454 15% 2188-480-470230-153 HEALTH INSURANCE 4,862 5,558 696 13% 2188-480-470230-155 RETIREMENT 2,901 3,337 436 13% 2188-480-470230-353 AUDIT 2,000 2,000 0 0% 2188-480-470230-354 TO PORT/GATEWAY W. BLDG MAINT. 0 5,000 5,000 100% 2188-480-470230-356 TELEPHONE 176 0 176- 0% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 3,176 3,464 288 8% 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 2,925 0 2,925- 0% 2188-480-470230-840 TRANSFER TO DEBT SERVICE 24,255 32,340 8,085 25% 2188-480-470240-720 PRE AWARD TIGER 205,165 4,000,000 3,794,835 95% TOTAL WESTSIDE TIF 282,988 4,095,682 3,812,694 93% OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 10,841 11,500 659 6% 2310-480-470210-356 FED -EX REIMBURSEMENT 10,282 11,000 718 7% 2310-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 26,250 35,000 8,750 25% 2311-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 11,250 15,000 3,750 25% TOTAL OLD SCHOOL TIFS 58,623 72,500 13,877 19% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 19 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 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 380 1,000 620 62% 2880-480-470210-711 REDEVELOPMENT 50,018 150,000 99,982 67% TOTAL LOAN REVOLVING 51,398 152,000 100,602 66% 2881 CD LOAN REV. #2 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 2881-480-470210-711 REDEVELOPMENT 2886-480-470210-210 2886-480-470210-353 2886-480-470210-373 2886-480-470210-379 2886-480-470210-396 2886-480-470210-522 2886-480-470210-528 2886-480-470210-532 2886-480-470210-620 2886-480-470210-790 2886-480-470210-795 2887-480-470210-354 2887-480-470210-610 2887-480-470210-620 2887-480-470210-750 2888-480-470210-354 2888-480-470210-610 2888-480-470210-620 2888-480-470210-750 TOTAL 2881 CD REV. #2 2886 CD MISC. OFFICE SUPPLIES AUDITING DUES & TRAINING MEETINGS GRANT SERVICES ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER OFFICE RENT INTEREST - OLD SCHOOL LOAN - GENERA COMM. DEV. ACTIVITIES REDEVELOPMENT- OLD SCHOOL STATION TOTAL CD MISC. 2887 RURAL DEVELOPMENT #1 CONT SERV (LOAN SOFTWARE) DEBT SERVICE/PRIN-L#61-01 INTEREST EXPENSE/L#61-01 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT #1 2888 RURAL DEVELOPMENT #2 CONT SERV (LOAN SOFTWARE) DEBT SERVICE/PRIN-L#61-03 INTEREST EXPENSE -USDA LOAN 61-03 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT #2 335 0 335- 0% 0 150,000 150,000 100% 335 150,000 149,665 100% 0 2,000 2,000 100% 1,000 1,000 0 0% 55 2,000 1,945 97% 0 1,000 1,000 100% 0 25,000 25,000 100% 1,500 2,000 500 25% 7,647 8,342 695 8% 1,175 1,175 0 0% 0 16,250 16,250 100% 1,705 100,000 98,295 98% 175,113 183,750 8,637 5% 188,194 342,517 154,323 45% 335 0 335- 0% 18,272 18,272 0- 0% 3,802 3,803 1 0% 0 150,000 150,000 100% 22,409 172,075 149,666 87% 335 0 335- 0% 8,138 8,135 3- -0% 1,887 1,890 3 0% 0 110,000 110,000 100% 10,360 120,025 109,665 91% 2953 EPA BROWNFIELDS 2953-480-470210-354 PETROLEUM 16 200,000 199,984 100% 2953-480-470210-373 TRAVEL/PETROLEUM 483 0 483- 0% 2953-480-470215-354 HAZARDOUS 16 200,000 199,984 100% 2953-480-470215-373 TRAVEL/HAZARDOUS 483 0 483- 0% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 20 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. TOTAL EPA BROWNSFIELD 998 400,000 399,002 100% 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES -PETROLEUM 0 908 908 100% 2955-480-470210-352 PERSONNEL -PETROLEUM 0 3,505 3,505 100% 2955-480-470210-353 FRINGES -PETROLEUM 0 493 493 100% 2955-480-470210-354 CONTRACTED SERVICES-PETROLUEM 0 1,488 1,488 100% 2955-480-470210-373 TRAVEL -PETROLEUM 35 35 0- -1% 2955-480-470210-720 CLEANUP LOANS -PETROLEUM 0 62,354 62,354 100% 2955-480-470210-721 CLEANUP SUBGRANTS-PETRO 0 100,000 100,000 100% 2955-480-470210-725 REVOLVED FUNDS -PETROLEUM 0 100,500 100,500 100% 2955-480-470215-229 SUPPLIES -HAZARDOUS SUBSTANCES 0 1,158 1,158 100% 2955-480-470215-354 CONTRACT SERV-HAZARDOUS SUBST 0 88 88 100% 2955-480-470215-373 TRAVEL -HAZARDOUS SUBTSANCE 1,447 3,778 2,331 62% 2955-480-470215-720 CLEANUP LOANS -HAZARDOUS 0 314,600 314,600 100% TOTAL BROWNFIELDS LOAN REV. 1,483 588,907 587,424 100% 2991 TIGER GRANT 2991-480-470245-790 REDEVELOPMENT 0 10,000,000 10,000,000 100% TOTAL TIGER GRANT 0 10,000,000 10,000,000 100% 2994 KIDSPORTS GRANT 2994-436-460436-930 CAPITAL IMPROVEMENTS 171,494 2,152,726 1,981,232 92% TOTAL KIDSPORTS GRANT 171,494 2,152,726 1,981,232 92% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 21 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD /2015 GRT 5,575 31,255 25,680 82% 2915-413-420140-218 SMALL EQUIP - 2015 STONEGARDEN 38,851 25,000 13,851- -55% 2915-413-420140-354 CONT SERV-WPD/MHP/MFWPE-2015 GRT 33,293 38,815 5,522 14% TOTAL 2915 STONEGARDEN GRANT 77,719 95,070 17,351 18% 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 53,871 60,926 7,055 12% 2916-413-420140-121 OVERTIME 8,306 7,500 806- -11% 2916-413-420140-153 HEALTH INSURANCE 13,766 17,541 3,775 22% 2916-413-420140-155 RETIREMENT 7,121 8,167 1,046 13% 2916-413-420140-354 CONTRACT SERVICES 5,208 5,841 633 11% TOTAL 2916 DRUG ENFORCEMENT 88,272 99,975 11,703 12% 2918 CHRP GRANT 2918-413-420140-110 SALARIES & PAYROLL COSTS 51,820 140,287 88,467 63% 2918-413-420140-153 HEALTH INSURANCE 7,264 32,606 25,342 78% 2918-413-420140-155 RETIREMENT 6,795 18,857 12,062 64% TOTAL CHRP GRANT 65,879 191,750 125,871 66% 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 2,555 4,000 1,445 36% 2919-413-420140-125 DUI TASK FORCE 0 8,000 8,000 100% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 26,176 36,000 9,824 27% 2919-413-420140-127 SCHOOL DIST. OT 14,862 20,000 5,138 26% 2919-413-420140-218 SAG&MDOT GRTS-WATCHGUARD CAMERAS 10,904 12,000 1,096 9% 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 1,387 2,500 1,113 45% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 6,924 7,000 76 1% TOTAL LAW ENF. GRANT 62,808 89,500 26,692 30% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 22 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CAPITAL PROJECT FUNDS 4150 FIRE PUMPER 4150-416-420400-944 PUMPER TRUCK TOTAL 4150 FIRE PUMPER 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION TOTAL 4290 WALK & CURB 0 500,000 500,000 100% 0 500,000 500,000 100% 6,310 25,000 18,690 75% 6,310 25,000 18,690 75% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 23 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. ENTERPRISE FUNDS WATER REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 1,620 0 1,620- 0% 5210-000-331158-000 STATE BYPASS RELOCATION REIMB. 1,876 0 1,876- 0% 5210-000-343210-000 METERED WATER SALES 2,698,333 2,850,000 151,667 5% 5210-000-343220-000 UNMETERED WATER SALES 11,262 0 11,262- 0% 5210-000-343225-000 IMPACT FEES 576,042 285,000 291,042- -102% 5210-000-343230-000 METER REPLACEMENT FEE 90,200 98,000 7,800 8% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 42,321 74,000 31,679 43% 5210-000-343265-000 IMPACT ADMIN FEES 0 15,000 15,000 100% 5210-000-343270-000 WATER TURN ON FEES 7,525 0 7,525- 0% 5210-000-343275-000 TAG FEE 61,000 0 61,000- 0% 5210-000-371010-000 INVESTMENT EARNINGS 76,361 46,000 30,361- -66% 5210-000-381050-000 INCEPTION OF LEASE 0 2,435,627 2,435,627 100% TOTAL WATER REVENUE 3,566,540 5,803,627 2,237,087 39% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 627,128 702,293 75,165 11% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 7,115 20,000 12,885 64% 5210-447-430550-153 HEALTH INSURANCE 137,048 168,225 31,177 19% 5210-447-430550-155 RETIREMENT 46,732 51,002 4,270 8% 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 4,612 11,000 6,388 58% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 5,546 8,500 2,954 35% 5210-447-430550-226 CHLORINE & CHEMICALS 19,391 38,000 18,609 49% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 3,895 4,500 605 13% 5210-447-430550-231 GAS & OIL 18,295 38,000 19,705 52% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 156 4,000 3,844 96% 5210-447-430550-336 LICENSES & FEES 15,710 18,500 2,790 15% 5210-447-430550-341 ELECTRICITY 113,120 150,000 36,880 25% 5210-447-430550-344 NATURAL GAS 9,080 15,500 6,420 41% 5210-447-430550-345 TELEPHONE & COMMUNICATION 8,936 9,000 64 1% 5210-447-430550-349 LAB SERVICES 22,009 26,000 3,991 15% 5210-447-430550-353 AUDITING 5,000 5,000 0 0% 5210-447-430550-354 CONTRACT SERVICES 20,849 65,000 44,151 68% 5210-447-430550-356 CONSULTANTS-WTR RIGHTS/MODELING 2,888 25,000 22,112 88% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 6,758 15,000 8,242 55% 5210-447-430550-366 BUILDING MAINTENANCE 2,955 12,000 9,045 75% 5210-447-430550-373 DUES & TRAINING 4,769 9,000 4,231 47% 5210-447-430550-388 MEDICAL SERVICES 193 800 608 76% 5210-447-430550-410 CONSTRUCTION MATERIALS 13,868 35,000 21,132 60% 5210-447-430550-422 HYDRANTS 8,839 8,000 839- -10% 5210-447-430550-423 MATERIALS FOR MAINS 6,817 14,000 7,183 51% 5210-447-430550-424 MATERIALS -SERVICE LINES 4,896 14,000 9,104 65% 5210-447-430550-425 MATERIALS PUMPS/WELLS 5,028 45,000 39,972 89% 5210-447-430550-510 PROPERTY & LIABILITY INS. 15,468 15,468 0 0% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 21,867 23,855 1,988 8% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 94,850 103,473 8,623 8% 5210-447-430550-528 DATA PROCESSING TRANSFER 26,763 36,000 9,237 26% 5210-447-430550-532 LEASE PAYMENTS (City Hall rent) 6,422 9,500 3,078 32% 5210-447-430550-921 SAND/COLD MIX STORAGE SHED 2,395 25,771 23,376 91% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 24 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 5210-447-430550-922 USFS PROPERTY ACQUISITION 366 32,978 32,612 99% 5210-447-430550-936 Noffsinger Spring Generator 53,607 90,000 36,393 40% 5210-447-430550-948 METERS (METER FUNDS) 010125 32,575 110,000 77,425 70% 5210-447-430550-951 SECURITY SCADA UPGRADES 2,715 15,000 12,285 82% 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 5210-447-430550-958 2ND AVE EAST MAIN REPLC & UPSIZE 453 45,147 44,694 99% 5210-447-430550-959 PARKS METERING PHASE I 7,100 30,000 22,900 76% 5210-447-430550-969 4TH AVE E MAIN REPL. PH. 1 72 2,435,627 2,435,555 100% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 150,000 150,000 100% 5210-447-430555-941 METERS (NEW SERVICES)010120 32,575 45,600 13,025 29% 5210-447-430555-953 SECTION 36 WELL 0 639,746 639,746 100% SUBTOTAL WATER FACILITIES 1,418,860 5,366,037 3,947,177 74% WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 5210-447-430560-153 HEALTH INSURANCE 5210-447-430560-155 RETIREMENT 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 5210-447-430560-353 AUDITING 5210-447-430560-354 CONTRACT SERVICES 5210-447-430560-355 BILLING COSTS 5210-447-430560-373 DUES & TRAINING 5210-447-430560-522 ADMINISTRATIVE TRANSFER 5210-447-430560-528 DATA PROCESSING TRANSFER 5210-447-430560-532 RENT SUBTOTAL WATER BILLING 94,648 108,823 14,175 13% 28,810 36,839 8,029 22% 7,264 8,225 961 12% 2,083 2,500 417 17% 2,000 2,000 0 0% 0 3,000 3,000 100% 50,452 70,000 19,548 28% 1,310 2,500 1,190 48% 7,287 7,950 663 8% 26,763 33,000 6,237 19% 6,422 6,422 0 0% 227,040 281,259 54,219 19% REVENUE BONDS 5210-447-490204-610 BOND PRIN-HWY 93 S WTR-2004 0 65,000 65,000 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 28,835 28,835 0 0% 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 350 350 0 0% 5210-447-490206-610 PRIN-MTR&WELL WRF7104 1.25%;WRF8114 0 83,000 83,000 100% 5210-447-490206-620 INT-MTR&WELL/WRF7104 1.25%;WRF8114 22,601 22,601 0- 0% 5210-447-490250-610 PRIN-WTR MAIN/WRF1032R 2%/IDAHO&MAI 0 48,000 48,000 100% 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2%/IDAHO&MAIN 4,440 4,200 240- -6% SUBTOTAL REVENUE BONDS 56,226 251,986 195,760 78% DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION TOTAL WATER FUND 0 840,000 840,000 100% 0 840,000 840,000 100% 1,702,126 6,739,282 5,037,156 75% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 25 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 1,620 0 1,620- 0% 5310-000-343310-000 SEWER SERVICE CHARGES 4,115,936 4,400,000 284,064 6% 5310-000-343330-000 IMPACT FEES (SANITARY) 680,831 220,000 460,831- -209% 5310-000-343335-000 IMPACT FEES (WWTP) 537,647 300,000 237,647- -79% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 3,064 15,000 11,936 80% 5310-000-371010-000 INVESTMENT EARNINGS 84,808 50,000 34,808- -70% TOTAL SEWER REVENUE SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 5310-454-430620-153 HEALTH INSURANCE 5310-454-430620-155 RETIREMENT 5310-454-430620-215 OFFICE SUPPLIES/computers 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 5310-454-430620-355 BILLING COSTS 5310-454-430620-373 DUES & TRAINING 5310-454-430620-522 ADMINISTRATIVE TRANSFER 5310-454-430620-528 DATA PROCESSING TRANSFER 5310-454-430620-532 OFFICE RENT 5,423,906 4,985,000 438,906- -9% 79,570 91,956 12,386 13% 22,915 29,868 6,953 23% 6,098 6,936 838 12% 2,081 2,500 419 17% 2,000 2,000 0 0% 53,105 70,000 16,895 24% 1,310 2,500 1,190 48% 6,467 7,055 588 8% 26,763 33,000 6,237 19% 6,422 6,422 0 0% SUBTOTAL SEWER BILLING COSTS 206,732 252,237 45,505 18% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 203,953 251,377 47,424 19% 5310-454-430630-121 OVERTIME 941 5,500 4,559 83% 5310-454-430630-153 HEALTH INSURANCE 55,103 66,327 11,224 17% 5310-454-430630-155 RETIREMENT 15,259 18,365 3,106 17% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 2,102 9,200 7,098 77% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 5,405 8,350 2,945 35% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 1,861 2,000 139 7% 5310-454-430630-231 GAS & OIL 6,064 13,500 7,436 55% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 469 400 69- -17% 5310-454-430630-341 ELECTRICITY 43,407 54,500 11,093 20% 5310-454-430630-344 NATURAL GAS 11,779 16,500 4,721 29% 5310-454-430630-345 TELEPHONE & COMMUNICATION 23,066 23,000 66- -0% 5310-454-430630-353 AUDITING 3,000 3,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 13,977 24,000 10,023 42% 5310-454-430630-356 CONSULTANTS 2,541 8,000 5,459 68% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 4,731 5,000 269 5% 5310-454-430630-373 DUES & TRAINING 4,223 5,500 1,277 23% 5310-454-430630-388 MEDICAL SERVICES 53 500 448 90% 5310-454-430630-410 CONSTRUCTION MATERIALS 7,103 9,000 1,897 21% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 12,257 50,000 37,744 75% 5310-454-430630-510 PROPERTY & LIABILITY INS. 15,791 15,791 0 0% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 3,658 25,000 21,342 85% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 8,415 9,180 765 8% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 59,089 64,461 5,372 8% 5310-454-430630-528 DATA PROCESSING TRANSFER 15,293 19,000 3,707 20% 5310-454-430630-532 OFFICE RENT 6,422 6,422 0 0% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 26 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-921 SAND/COLD MIX STORAGE SHED 2,395 25,771 23,376 91% 5310-454-430630-922 USFS PROPERTY ACQUISITION 366 32,978 32,612 99% 5310-454-430630-951 1ST ALLEY EN PIPE UPSIZE (34% RATE 0 20,528 20,528 100% 5310-454-430630-952 PETERSON SCHOOL ALLEY REPLACEMENT 434 284,000 283,566 100% 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 12,152 20,000 7,848 39% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 12,104 50,000 37,896 76% 5310-454-430630-961 2ND ALLEY WN - MONT TO CALF 296,338 324,366 28,028 9% SUBTOTAL SEWER COLLECTION 849,752 1,502,068 652,316 43% IMPACT FEES 5310-454-430635-951 1ST ALLEY EN PIPE UPSIZE (34% RATE 0 34,035 34,035 100% 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 0 100,000 100,000 100% 5310-454-430635-957 3 MILE DR INTERCEPTOR 70,234 867,087 796,853 92% 5310-454-430635-961 2ND ALLEY WN - MONT TO CALF 152,572 167,110 14,538 9% SUBTOTAL IMPACT FEE EXPENSE 222,806 1,168,232 945,426 81% REVENUE BONDS/SANITARY 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.25% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25% SUBTOTAL REVENUE BONDS DEPRECIATION -SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION -SANITARY 0 81,000 81,000 100% 15,345 15,346 2 0% 0 300 300 100% 15,345 96,646 81,302 84% 0 820,000 820,000 100% 0 820,000 820,000 100% SUBTOTAL SANITARY SEWER 1,087,903 3,586,946 2,499,043 70% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 379,794 448,865 69,071 15% 5310-455-430640-111 SEASONAL SALARIES 3,629 5,000 1,371 27% 5310-455-430640-112 SALARIES -RETIREMENT 14,457 0 14,457- 0% 5310-455-430640-121 OVERTIME 18,461 22,500 4,039 18% 5310-455-430640-153 HEALTH INSURANCE 76,732 88,992 12,260 14% 5310-455-430640-155 RETIREMENT 29,656 32,463 2,807 9% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 3,231 10,000 6,769 68% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 2,163 2,700 537 20% 5310-455-430640-225 ALUM 17,495 20,000 2,505 13% 5310-455-430640-226 CHLORINE & CHEMICALS 19,549 19,000 549- -3% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 5,887 7,000 1,113 16% 5310-455-430640-231 GAS & OIL 8,599 18,500 9,901 54% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 321 350 29 8% 5310-455-430640-336 LICENSES & FEES 7,438 10,000 2,562 26% 5310-455-430640-341 ELECTRICITY 144,817 178,500 33,683 19% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 27 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 5310-455-430640-342 WATER 3,095 7,500 4,405 59% 5310-455-430640-344 NATURAL GAS 41,573 65,000 23,427 36% 5310-455-430640-345 TELEPHONE & COMMUNICATION 5,507 5,500 7- -0% 5310-455-430640-353 AUDITING 4,000 4,000 0 0% 5310-455-430640-354 CONTRACT -GLACIER GOLD 111,432 124,000 12,568 10% 5310-455-430640-355 OTHER CONTRACT SERVICES 20,920 30,000 9,080 30% 5310-455-430640-356 CONSULTANTS 53,235 100,000 46,765 47% 5310-455-430640-358 CONSULTANT-TMDL 1,994 15,000 13,006 87% 5310-455-430640-360 MISC. MAINT SERVICES 13,236 30,000 16,764 56% 5310-455-430640-366 BUILDING MAINTENANCE 23,181 36,000 12,819 36% 5310-455-430640-373 DUES & TRAINING 3,730 7,500 3,770 50% 5310-455-430640-388 MEDICAL SERVICES 228 500 273 55% 5310-455-430640-510 PROPERTY & LIABILITY INS. 34,985 34,985 0 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 12,111 13,212 1,101 8% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 102,884 112,237 9,353 8% 5310-455-430640-528 DATA PROCESSING TRANSFER 19,117 27,500 8,383 30% 5310-455-430640-921 EVERGREEN SEWER SAMPLING EQUIP & BL 23,054 40,000 16,946 42% SUBTOTAL WWTP OPERATIONS 1,206,509 1,516,804 310,295 20% WWTP BONDED PROJECT SUBTOTAL WWTP BONDED 0 0 0 0% WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 67,497 100,000 32,503 33% 5310-455-430645-920 R.A.S. BLD & STORAGE WAREHOUSE ROOF 34,636 40,000 5,364 13% 5310-455-430645-933 SOLIDS DEWATERING DESIGN & CONST. 998 100,000 99,002 99% 5310-455-430645-934 SECONDARY DIGESTER LID INSPECTION 28,798 531,500 502,702 95% 5310-455-430645-936 DIGESTED SLUDGET LINE REPLACEMENT 60,674 298,678 238,004 80% 5310-455-430645-937 SAND FILTER MAINT & REPLACMENT 0 200,000 200,000 100% 5310-455-430645-940 MACHINERY & EQUIPMENT 49,871 182,500 132,629 73% SUBTOTAL WWTP REPLACEMENT 242,473 1,452,678 1,210,205 83% WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 91,077 106,284 15,207 14% 5310-455-430646-121 OVERTIME 168 0 168- 0% 5310-455-430646-153 HEALTH INSURANCE 14,960 20,932 5,972 29% 5310-455-430646-155 RETIREMENT 6,744 7,630 886 12% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 1,853 4,500 2,647 59% 5310-455-430646-218 NON -CAPITAL EQUIPMENT 2,611 2,500 111- -4% 5310-455-430646-222 LAB SUPPLIES 11,506 9,500 2,006- -21% 5310-455-430646-349 LAB SERVICES 22,778 29,000 6,222 21% 5310-455-430646-362 EQUIPMENT MAINTENANCE 4,479 5,500 1,021 19% 5310-455-430646-373 DUES & TRAINING 1,337 3,700 2,363 64% SUBTOTAL WWTP LAB OPERATIONS 157,511 189,546 32,035 17% DEBT SERVICE - WWTP 5310-455-490227-610 PRIN-WWTP IMP/SRF8164R/2.25% 0 796,000 796,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 216,405 216,405 0 0% 5310-455-490228-610 PRIN/WWTP DIGESTER LID/SRF13326/3.0 0 44,000 44,000 100% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 28 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 28,650 28,650 0 0% SUBTOTAL DEBT SERVICE - WWTP 245,055 1,085,055 840,000 77% CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-830 EVERGREEN REPLACEMENT TRANSFER 0 450,000 450,000 100% 5310-455-510400-831 DEPRECIATION EXPENSE 0 1,425,000 1,425,000 100% SUTOTAL WWTP DEPRECIATION/REPL 0 1,875,000 1,875,000 100% SUBTOTAL WWTP 1,851,548 6,119,083 4,267,535 70% TOTAL BILLING/SANITARY/WWTP 3,146,182 9,958,266 6,812,084 68% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 29 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 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 1,620 0 1,620- 0% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 4,136 2,500 1,636- -65% 5349-000-343033-000 IMPACT FEES 239,139 150,000 89,139- -59% 5349-000-343034-000 PERMIT FEES 1,675 0 1,675- 0% 5349-000-343035-000 STORM SEWER CHARGES 0 1,000 1,000 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 866,947 850,000 16,947- -2% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 1,511 1,000 511- -51% 5349-000-371010-000 INTEREST ON INVESTMENTS 25,431 18,000 7,431- -41% 5349-000-381050-000 INCEPTION OF LEASE 0 382,000 382,000 100% TOTAL STORM REVENUE 1.140.459 1,404,500 264,041 19% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 303,737 360,758 57,021 16% 5349-453-430246-121 OVERTIME 952 4,000 3,048 76% 5349-453-430246-153 HEALTH INSURANCE 67,666 81,030 13,364 16% 5349-453-430246-155 RETIREMENT 22,731 26,448 3,717 14% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 3,436 10,100 6,664 66% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 2,932 6,550 3,618 55% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 280 2,200 1,920 87% 5349-453-430246-231 GAS & OIL 5,783 11,500 5,717 50% 5349-453-430246-345 TELEPHONE & COMMUNICATION 826 800 26- -3% 5349-453-430246-353 AUDITING 1,150 2,340 1,190 51% 5349-453-430246-354 CONTRACT SERVICE 6,146 6,000 146- -2% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 26,563 35,000 8,437 24% 5349-453-430246-357 IMPACT FEE UPDATE 23,129 50,000 26,871 54% 5349-453-430246-358 CONSULTANTS 1,128 7,000 5,872 84% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 1,032 15,000 13,968 93% 5349-453-430246-360 REPAIR & MAINT SERVICES 1,294 2,500 1,206 48% 5349-453-430246-362 GROUNDWATER MONITORING 2,150 6,500 4,350 67% 5349-453-430246-371 CURB & GUTTER 0 7,000 7,000 100% 5349-453-430246-373 DUES & TRAINING 3,123 5,500 2,377 43% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 0 10,000 10,000 100% 5349-453-430246-510 PROPERTY & LIABILITY INS. 4,842 10,000 5,158 52% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 8,415 9,180 765 8% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 36,439 39,752 3,313 8% 5349-453-430246-528 DATA PROCESSING TRANSFER 15,293 13,000 2,293- -18% 5349-453-430246-530 BNSF LEASE PMT 4,790 5,900 1,110 19% 5349-453-430246-532 OFFICE RENT 6,422 6,422 0 0% 5349-453-430246-840 MACI GRANT MATCH (SWEEPER) 0 43,000 43,000 100% 5349-453-430246-921 SAND/COLD MIX STORAGE SHED 2,395 25,771 23,376 91% 5349-453-430246-952 STORM DRAIN CORRECTION 7,389 100,000 92,611 93% 5349-453-430246-953 WILLOWS PRJ FY14/15; SHOP COMPLX PV 0 30,552 30,552 100% 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 501,380 581,400 80,020 14% 5349-453-430246-969 4TH AVE E. REPLACE PHASE 1-4 0 382,000 382,000 100% 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 130,000 130,000 100% 5349-453-510400-831 DEPRECIATION 0 285,000 285,000 100% TOTAL STORM 1,061,421 2,312,303 1,250,882 54% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 30 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 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 100 0 100- 0% 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 973,929 955,000 18,929- -2% 5510-000-343420-000 GARBAGE COLLECTION -BILLED 29,068 21,500 7,568- -35% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 2,290 2,100 190- -9% 5510-000-371010-000 INVESTMENT EARNINGS 7,283 6,000 1,283- -21% 5510-000-382010-000 SALE OF FIXED ASSETS 15,700 0 15,700- 0% TOTAL SOLID WASTE REVENUE 1,028,369 984,600 43,769- -4% SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 351,013 399,776 48,763 12% 5510-460-430840-112 SEVERANCE -RETIREMENT 0 60,455 60,455 100% 5510-460-430840-121 OVERTIME 5,254 5,500 246 4% 5510-460-430840-153 HEALTH INSURANCE 80,692 106,280 25,588 24% 5510-460-430840-155 RETIREMENT 26,218 28,993 2,775 10% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 1,534 9,500 7,966 84% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 37,290 35,000 2,290- -7% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 2,961 5,500 2,539 46% 5510-460-430840-231 GAS & OIL 30,952 60,000 29,048 48% 5510-460-430840-341 ELECTRICITY 1,406 1,950 544 28% 5510-460-430840-344 NATURAL GAS 2,445 4,900 2,455 50% 5510-460-430840-345 TELEPHONE & COMMUNICATION 911 850 61- -7% 5510-460-430840-354 CONTRACT SERVICES 9,778 9,000 778- -9% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 1,211 5,700 4,489 79% 5510-460-430840-366 BUILDING MAINTENANCE 288 2,500 2,212 88% 5510-460-430840-373 DUES & TRAINING 1,825 3,500 1,675 48% 5510-460-430840-388 MEDICAL SERVICES 0 650 650 100% 5510-460-430840-510 PROPERTY & LIABILITY INS. 6,799 6,799 0 0% 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 0 4,000 4,000 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 69,762 76,104 6,342 8% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 34,202 37,311 3,109 8% 5510-460-430840-528 DATA PROCESSING TRANSFER 11,470 12,513 1,043 8% 5510-460-430840-532 OFFICE RENT 6,422 6,422 0 0% 5510-460-430840-610 DEBT SERVICE PRINCIPAL -GARBAGE TK 38,343 38,343 0- 0% 5510-460-430840-620 DEBT SERVICE INTEREST -GARBAGE TK 1,656 1,801 145 8% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 26,250 35,000 8,750 25% 5510-460-430840-922 USFS PROPERTY ACQUISITION 494 43,971 43,477 99% 5510-460-430840-940 EQUIPMENT 44,245 48,000 3,755 8% 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 5510-460-430845-224 JANITORIAL SUPPLIES 285 250 35- -14% 5510-460-430845-341 ELECTRICITY 1,676 3,500 1,824 52% 5510-460-430845-342 WATER 563 2,000 1,437 72% 5510-460-430845-344 NATURAL GAS 4,307 6,500 2,193 34% 5510-460-430845-360 REPAIR & MAINT SERVICES 247 3,500 3,253 93% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% TOTAL SOLID WASTE EXPENSE 800,500 1,246,620 446,120 36% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 31 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 9,750 10,000 250 3% 5160-000-343069-000 HANGER LEASES 11,000 11,000 0 0% 5160-000-343071-000 HANGAR SITE LEASES 19,132 17,510 1,622- -9% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 17,490 19,145 1,655 9% 5160-000-343102-000 GROUND LEASES 13,198 13,198 0- 0% 5160-000-343620-000 FUEL TAX 1,980 5,000 3,020 60% 5160-000-371010-000 INVESTMENT EARNINGS 1,572 1,000 572- -57% TOTAL AIRPORT REVENUE 74,122 76,853 2,731 4% 5160 AIRPORT EXPENSES 5160-430-430310-210 OFFICE SUPPLIES & EQUIP 0 1,000 1,000 100% 5160-430-430310-341 ELECTRICITY 1,282 1,500 218 15% 5160-430-430310-354 CONTRACT SERVICES -LABOR & MATERIALS 33,000 36,000 3,000 8% 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 9,850 7,500 2,350- -31% 5160-430-430310-362 REPAIR & MAINTENANCE 1,123 10,000 8,877 89% 5160-430-430310-390 EQUIPMENT RENTAL 700 1,000 300 30% 5160-430-430310-510 PROPERTY INSURANCE 6,418 6,500 82 1% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 2,348 2,562 214 8% 5160-430-430310-528 DATA PROCESSING TRANSFER 1,912 2,085 173 8% 5160-430-430310-820 DEPRECIATION 0 97,918 97,918 100% TOTAL AIRPORT EXPENSES 56,633 166,065 109,432 66% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 32 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING INTERNAL SERVICE FUNDS INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 HB 124 ENTITLEMENT 153,750 205,000 51,250 25% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 128,107 175,000 46,893 27% 6030-000-364030-000 SALE OF MISCELLANEOUS 63 0 63- 0% 6030-000-371010-000 INVESTMENT EARNINGS 1,349 1,000 349- -35% 6030-000-393000-000 INTERNAL SERVICES -DATA 216,017 235,655 19,638 8% TOTAL INFORMATION TECH REVENUE 499,286 616,655 117,369 19% INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 148,646 167,379 18,733 11% 6030-401-410580-121 OVERTIME 1,116 1,000 116- -12% 6030-401-410580-153 HEALTH INSURANCE 40,251 44,317 4,066 9% 6030-401-410580-155 RETIREMENT 11,683 12,653 970 8% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 85 500 415 83% 6030-403-410580-215 COMPUTER SUPPLIES 810 2,400 1,590 66% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 13,771 18,963 5,192 27% 6030-403-410580-325 WEBSITE 1,753 16,000 14,247 89% 6030-403-410580-345 PAGER/PHONE 1,934 2,500 566 23% 6030-403-410580-346 SUMMITNET & ISPS 8,009 8,468 459 5% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,432 3,500 68 2% 6030-403-410580-354 MAINTENANCE CONTRACTS 2,398 8,860 6,462 73% 6030-403-410580-355 LICENSES 10,748 21,110 10,362 49% 6030-403-410580-356 MAINTENANCE CONTRACTS 31,930 47,550 15,620 33% 6030-403-410580-357 GRANICUS 7,400 6,690 710- -11% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 6,224 21,235 15,011 71% 6030-403-410580-373 DUES & TRAINING 4,770 8,000 3,230 40% 6030-403-410580-510 INSURANCE 819 1,778 959 54% 6030-403-410583-218 TV -Video Equipment & programming 1,194 12,900 11,706 91% 6030-403-410585-229 COPIER,FAX, SUPPLIES 11,074 19,552 8,478 43% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 70,120 76,000 5,880 8% 6030-403-410585-532 COPIER LEASES 12,895 16,182 3,287 20% 6030-403-410585-942 Servers - capital contingency 4,861 23,500 18,640 79% 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,000 5,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 3,553 4,964 1,411 28% 6030-405-410588-940 NETWORK EQUIPMENT CAPITAL 10,794 49,200 38,406 78% 6030-410-410588-218 COMPUTERS - DPW 2,345 2,175 170- -8% 6030-413-410588-218 COMPUTERS - POLICE DEPT 29,076 28,360 716- -3% 6030-413-410588-354 POLICE - HOSTED SERVER 924 2,000 1,076 54% 6030-416-410588-218 COMPUTERS - FIRE 9,454 16,752 7,298 44% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 12,312 11,053 1,259- -11% 6030-436-410588-218 COMPUTERS - PARKS 4,523 5,165 642 12% 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 2,155 2,155 100% TOTAL INFORMATION TECH EXPENSE 468,903 667,861 198,958 30% 06.01.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 33 of 33 gb8501_pg.php/Job No: 55934 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MAY 31, 2017 91.66 % Yr Complete For Fiscal Year: 2017 / 5 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 467,500 510,000 42,500 8% 6010-000-364030-000 SALE OF MISC 911 0 911- 0% 6010-000-371010-000 INVESTMENT EARNINGS 597 200 397- -198% TOTAL CENTRAL GARAGE REVENUE 469,007 510,200 41,193 8% CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 141,114 160,046 18,932 12% 6010-410-431330-121 OVERTIME 2,288 2,500 213 9% 6010-410-431330-153 HEALTH INSURANCE 34,807 38,827 4,020 10% 6010-410-431330-155 RETIREMENT 10,237 11,505 1,268 11% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 7,749 10,000 2,251 23% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 9,025 12,700 3,675 29% 6010-410-431330-230 OIL 14,077 25,000 10,923 44% 6010-410-431330-231 GAS 271 3,000 2,729 91% 6010-410-431330-232 VEHICLE PARTS 91,251 108,000 16,749 16% 6010-410-431330-233 TIRES 37,751 38,000 249 1% 6010-410-431330-238 FILTERS 7,447 7,700 253 3% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 2,028 2,000 28- -1% 6010-410-431330-341 ELECTRICITY 1,332 1,950 618 32% 6010-410-431330-344 NATURAL GAS 3,960 7,000 3,040 43% 6010-410-431330-354 CONTRACT SERVICES 18,724 30,000 11,276 38% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 370 2,000 1,630 82% 6010-410-431330-373 DUES & TRAINING 5,073 6,200 1,127 18% 6010-410-431330-388 MEDICAL SERVICES 0 300 300 100% 6010-410-431330-510 INSURANCE 1,286 2,750 1,464 53% 6010-410-431330-528 INFORMATION TECH TRANSFER 7,647 8,342 695 8% 6010-410-431330-921 4 POST SERVICE LIFT 25,504 26,000 496 2% TOTAL CENTRAL GARAGE EXPENSES 421,942 503,820 81,878 16%