Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
01-12-18 City Manager Report
fTYOF ira - City of Kalispell - _is, OFFICE OF THE CITY MANAGER - 1A OVA Information Memorandum 1/12/2018 1. Parks and Recreation Work is now complete on construction of an additional office for Detectives at KPD. A contractor created a second office by dividing one office through installation and finishing of a wall, installing a door and upgrading the electrical. Christmas tree pickup is still occurring each Saturday until late January thanks to a volunteer group. Residents are asked to place trees standing in the boulevard free of lights, stands and ornaments. The last day for curb side pickup by volunteers will be January 20. The Woodland Park pond ice has been a challenge this winter. The early November snow and subsequent amounts before the ice had a chance to freeze has made it impossible to get equipment on the ice. Even after the recent cold spell over Christmas, we cannot get equipment on the ice without breaking through. We require a solid 4" of ice prior to allowing maintenance activities to occur. Forestry has completed the pruning of 7th Ave W and is now starting on 6th Ave W. Approximately 350 trees are currently being pruned through a contract in Ashley Park Phase III in South Kalispell. We would like to give big thanks to the Police, Fire and KPR Forestry Departments for supporting our Freeze Out Camp over the winter break. We had our biggest participation in the last 4 years and our partner departments did an incredible job making the tours and presentations engaging! Kalispell Parks and Recreation's annual Valentines Dance will be held on Saturday February 10, from 7-9pm at the Linderman Education Center Gym. This dance has been offered to our community for over 20 years. DJ Mike Hammer from KOFI will be performing for his second year in a row. Volunteers will spend time on Saturday to help decorate the gym and refreshments will be served during the dance. We are looking for volunteers to assist with decorating the gym the day of the dance. 2. Police Department The Kalispell Police Department is working with Grace Manchala and Detective Guy Baker of the Missoula Police Department to train local law enforcement in Human Sex Trafficking. The course is on January 22 at Flathead High School. Officers from KPD, the Flathead County Sheriff's Office, Montana Highway Patrol, and Columbia Falls Police Department will also be taking part in the training. A similar training session, which will include internet safety, will be open to the public on the night of the 22nd from 5:30-8:30 at the FHS auditorium. A KPD SRO and FCSO Detective Jeanne Parker will be instructing the public session with Detective Baker. Officers Quintin Fowler and Brooke Pokorny celebrated their one-year anniversary with KPD on January 10. Both officers have done an outstanding job for the department and city. They will have a confirmation hearing on January 16, in front of the city council. 3. Public Works Annual Bio-Solids Report The City of Kalispell Wastewater Treatment Plant maintains and operates Bio-Solids Disposal under the United States Environmental Protection Agency (EPA) Region 7 for bio-solids disposal. Annually, staff reports the amounts of bio-solids generated at the Kalispell WWTP by completing and sending in a `Bio-Solids Report Form." The report consists of production of bio-solids in dry metric tons. In 2017, the WWTP generated 575 dry metric tons of bio-solids. 447 dry metric tons went to Glacier Gold LLC for composting, 74 dry metric tons went to the Flathead County Solid Waste Landfill, and the cleaning of the Primary Digesters produced 54 dry metric tons of bio-solids disposed at the 40 Acer disposal site on Cemetery Road. The City's agreement with Glacier Gold allows for disposal 600 dry metric ton, which equates to just over 3 MGD on average. Review of the city bio solids disposal and potential Capital project to support future growth are anticipated to be discussed during the budget review process. Meter Division Yearend Review The Meter Division installed 264 meters and moved 82 meters from homes into meter pits on the 4th Avenue East Water Main project in FY 17. 119 meters were installed for new domestic service and 16 for new sprinkling services, an increase of 10 additional new meters compared to FY 16. The remaining 129 meters were changed because they had reached the end of their service life, were damaged or frozen, or due to a warranty issue, a decrease of 60 replacement meters from FY 16. The City has approximately 8,749 water meters in our system. The Meter Maintenance Division completed 668 work orders and 521 final reads in the last year, compared to 633 and 469 in FY 16. Work orders included a variety of tasks including; new meter installs, meter replacements, meter maintenance, meter pit inspections and testing, and water 2 audits for our customers. 4. Fire Department Since the last update, the Kalispell Fire Department has received 271 Calls for service and has conducted 4 outreach trainings with approximately 42 individuals in attendance. Consultants from CPSM did their operational site visit in regards to the operational study internal to the fire department. This visit was to gain an operational outlook and eyes on risk assessment for the City of Kalispell and the response capabilities. Interviews were conducted with key individuals and groups within the Flathead Valley to assist them in compiling information for their assessment. Fire department staff are also completing and uploading our year-end reports and documentation to state and federal entities. We have also transitioned to our new electronic patient -care reporting program. The new program is funded by the Montana State EMS office. 5. Information Services IT staff worked with a consultant to migrate two physical servers to a virtualized server environment. 3 new physical servers were added to the server rack, creating the foundation for the City's virtual environment. These 3 servers will be able to potentially house all of the City's physical servers as they are virtualized in the future. The virtual environment allows IT staff to move forward with two security projects which were funded through a grant. The migration project required a nearly 70 hour window when one of the City servers couldn't be accessed during the weekend. Nearly 4.6 TB of data was migrated. New network cabling is being run to accommodate the new system. The website consultant was onsite and met with City staff. The website design revised changes will be received from the website consultant and the City Website Resign committee by 1/12. The next deadline for staff will be the "Content Cut-off Date" of 2/2/18. After 2/2, CivicPlus will start the website migration to our new website. The new website will not be available until the end of March. City staff are working to make changes and clean up the existing website before the content cutoff date. The anti-malware software is being updated on all City computers. Changes are being made to the Cityworks Permitting program's test site. 6. Human Resources Following recommendations by our Human Resources Department last year, Montana Municipal Interlocal Authority (MMIA) is now finalizing a new way for designated individuals from member cities to be able to review on the MMIA website, their individual records, reports, and documents on file. This will include, but not limited to: a. The city's property assets (Vehicles, Equipment, Property) listed with MMIA for insurance purposes; b. Specific documents, such as certificates of coverage, insurance policies, etc.; c. Liability, property or worker's compensation claim reports against the city and filed with MMIA. In the past, many of these reports were unavailable to us unless we requested them or MMIA staff specifically sent them to us. This will be a time saver and will also allow us to be able to perform insurance claim trending, especially related to worker's compensation and liability, which in turn can help in reducing costs through proactive actions. Because Kalispell was the one who brought forth the suggestions, we will be one of the first test cities in the coming weeks to try the new system and offer feedback and suggestions. 7. Finance Department Audit The annual audit report for the City's financial statements was received on December 22, 2017. The entire Comprehensive Annual Financial Report (CAFR) is available in PDF format at the City's website: www.kalispell.com. The Independent Auditor's Report begins on page 12 of the CAFR, and is presented as a component of the financial section of the CAFR. The goal of the independent audit is to provide reasonable assurance that the financial statements of the City for the fiscal year ended June 30, 2017, are free of material misstatement. Auditors have a responsibility to issue an appropriate report in circumstances when, in forming their opinion on the financial statements, they conclude that a modification to the auditor's opinion is necessary. The City received an unmodified opinion for the independent audit. Prior to fiscal year 2013 this was referred to as an unqualified opinion, and concludes that the financial statements are presented fairly in all material respects. The Government Finance Officers Association (GFOA) awarded a Certificate of Achievement for Excellence in Financial Reporting to the City of Kalispell for its comprehensive annual financial report for the fiscal years ended June 30, 2010, 2011, 2012, 2013, 2014, 2015, and 2016. We believe that our current comprehensive annual financial report continues to meet the Certificate of Achievement Program's requirements and it has been submitted to the GFOA to determine its eligibility for another certificate. fl Quarterly Finance Report Please find attached the printouts reflecting the activity for the 1st half of the fiscal year 2018. This printout reflects payroll earned thru Dec. 23, 2017, and accounts payable claims received by the end of December. All funds are included with the exception of the debt service funds. REVENUE: General Fund revenue reflects taxes collected thru December 31. Some first half taxes received by the County aren't distributed to the City until the County completes the distribution in January. The City has not yet received the January distribution. Last year, the general fund received about $722,000 of first half taxes in January. A similar distribution this January would bring collections to about 56% of the budgeted annual amount ($5,800,000). The City is currently carrying less than $16,000 in protest taxes in the General Fund - protest tax dollars are held by the County. City Court fines and fees revenue reflects July thru October (4 months). Parks tax revenues should be about 56% after the County's January distribution. Youth camps' revenue, and many of the other user based parks' fees, historically receives more of their revenue in the 2nd half of the fiscal year (spring). Ambulance fees for services ($381,272) are just slightly behind last year ($390,000). The first half of the County EMS levy has not yet been received. Building department permits and fees are on pace with the budgeted annual amounts. The approximately $625,000 of permits and fees collected in the first half of this fiscal year is just over 60% of what was collected last fiscal first half. The Westside TIF real property tax revenues were budgeted at the same amount as the City received last fiscal year. However, when the certified values were received from the Department of Revenue in August, the incremental value in the district was down by about 30%. Although there are some other factors, for the most part real property taxes revenue will mirror the incremental value for fiscal year 2018, and will also be down about 30%. Metered water sales thru December were $2,034,506. This is 70% of the budgeted amount and almost $300,000 more than the fiscal year 2017 period. It is normal for July thru December metered water sales to be in excess of 50%, normally around 60%, of the annual amount because of late summer and fall sprinkling and irrigation. This significantly above normal water revenue can be attributed to the extremely dry summer that was experienced in Northwest Montana. Water impact fees have already exceeded the fiscal year 18 budgeted amount by 20%. Sewer service charges were $2,334,373, just over half (53%) of the budgeted amount. Last year's 1st half sewer service charges were $2,241,630. Sanitary sewer (120%) and treatment plant impact fees (125%) have both exceeded the anticipated fiscal year 2018 amount. 5 Storm sewer and Solid Waste revenue reflect assessments billed for fiscal year 2018. Assessments collected for the storm sewer fund are about $575,000, and for the solid waste fund are just over $425,000. These amounts do not include the January distribution from the County. The January distribution of first half assessment collections should bring total collections to excess of 50% of the annual budget for both of these funds. Storm impact fees ($235,729) are 94% of the budgeted fiscal year 2018 amount. EXPENDITURES/EXPENSES: General Fund expenditures reflect 46% spent. Some major expenditures such as liability and property insurance are paid during the first quarter for the entire year. This could result in expenditures not being evenly distributed over the fiscal period. For most funds, expenditures/expenses include the 13th (of 26) payroll period ending December 23. Most departments and/or funds have over 50% 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. This 1st half report includes only 6 of 13 (47%) pay periods for these employees. Health insurance is paid 12 times per year and includes 5 months (42%) on this report. With a few exceptions, administrative, central garage, and information technology transfers are done monthly and should show 50% remaining. This is the same on the revenue side for fees for services (Central Garage), internal services (Information Technology) 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 monthly or quarterly and should show 50% remaining. 0 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 1 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING ACCOUNT NUMBER DESC. GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 2,519,134 5,800,000 3,280,866 570 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 8,244 17,250 9,006 520 1000-000-311200-000 PERSONAL PROPERTY TAXES 144,284 135,000 9,284- -70 1000-000-312000-000 PEN & INTEREST DEL. TAXES 4,500 8,000 3,500 440 1000-000-322101-000 LIQUOR LICENSES 675 30,000 29,325 980 1000-000-322300-000 BUSINESS LICENSES 561 1,700 1,139 670 1000-000-323012-000 PLANNING FEES 32,675 40,000 7,325 180 1000-000-323109-000 SITE REVIEW 7,566 14,000 6,434 460 1000-000-323200-000 PARADE PERMITS 600 1,000 400 400 1000-000-335030-000 M.V. TAX - AD VALOREM 116 1,500 1,384 920 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 61,800 60,000 1,800- -30 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,550 1,000 550- -550 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 1,399,129 2,857,688 1,458,559 510 1000-000-341020-000 ADMINISTRATIVE CHARGES 321,065 638,811 317,746 500 1000-000-341021-000 GRANT ADMIN FEES 0 5,000 5,000 1000 1000-000-341025-000 CITY COLLECTIONS 57 5,000 4,943 990 1000-000-342010-000 POLICE SERVICES 15,251 25,000 9,749 390 1000-000-342014-000 RESOURCE OFFICERS 205,557 209,037 3,480 20 1000-000-342016-000 KPD REGIONAL TRAINING 5,350 5,000 350- -70 1000-000-342020-000 FIRE CHG/TEST FEES/SPEC EVENTS/INST 60 0 60- 0% 1000-000-343018-000 PARKING PERMITS 52,160 95,000 42,840 450 1000-000-351000-000 CITY COURT FINES & FEES 121,741 450,000 328,259 730 1000-000-351016-000 DUI COURT FINE 1,937 0 1,937- 0% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 6,533 20,000 13,467 670 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 24,344 35,000 10,657 300 1000-000-362015-000 INSURANCE REIMBURSEMENTS 3,182 20,000 16,819 840 1000-000-362020-000 MMIA GASB 54 REIMBURSEMENT 0 3,000 3,000 1000 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 13,018 5,000 8,018- -1600 1000-000-371010-000 INVESTMENT EARNINGS 11,631 15,000 3,369 220 1000-000-373030-000 INTEREST ON OLD SCHOOL SID LOAN - 1 0 32,500 32,500 1000 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 450,500 901,000 450,500 500 TOTAL GENERAL FUND REVENUE 5,413,220 11,431,486 6,018,266 530 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 2 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 2,500 2,935 435 150 1000-400-410530-353 CONTRACT SERVICES - AUDIT 12,900 14,250 1,350 90 1000-400-410530-359 OPEB EXPENSE 7,500 7,500 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 1,654 4,000 2,346 590 1000-400-410560-312 POSTAGE 9,193 16,000 6,807 430 1000-400-410560-320 PRINTING & ENVELOPES 1,991 4,500 3,059 680 1000-400-410560-359 CONTRACT SERVICES - DOC. SHREDDING 60 500 990 880 1000-400-410600-359 ELECTIONS 0 18,255 18,255 1000 1000-400-410900-331 RECORDS ADMIN./FILING FEES 1,366 4,000 2,634 660 1000-400-420000-359 CONTRACT 911 CENTER 245,021 479,000 233,979 490 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 348 400 52 130 1000-400-460000-820 TRANSFER TO FORESTRY 100,000 200,000 100,000 500 1000-400-460430-820 TRANSFER TO PARKS (BANDSHELL) 10,467 10,467 0 0% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 15,000 15,000 0 0% 1000-400-460452-366 HOCKADAY MAINTENANCE 0 6,600 6,600 1000 1000-400-510300-000 CONTINGENCY 0 30,000 30,000 1000 1000-400-510310-359 ICMA PLAN FEES 250 500 250 500 1000-400-510330-513 LIABILITY INSURANCE 110,313 110,310 3- 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 16,288 50,000 33,712 670 1000-400-510330-517 PROPERTY INSURANCE 50,025 50,012 13- _0% SUBTOTAL GEN.GOV'T. 584,326 1,024,229 439,903 430 CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER&139;S OFFICE 66,104 141,390 75,286 530 1000-401-410210-153 HEALTH INSURANCE 7,287 22,857 15,570 680 1000-401-410210-155 RETIREMENT 7,064 14,966 7,902 530 1000-401-410210-210 SUPPLIES 0 1,500 1,500 1000 1000-401-410210-312 NEWSLETTER/BOOKS 0 400 400 1000 1000-401-410210-345 TELEPHONE & COMMUNICATION 480 1,120 640 570 1000-401-410210-373 DUES & TRAINING 2,983 8,300 5,317 64% 1000-401-410210-379 MEETINGS 1,961 3,400 1,439 420 SUBTOTAL CITY MANAGER 85,879 193,933 108,054 560 HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 60,317 127,099 66,727 530 1000-401-410830-153 HEALTH INSURANCE 6,185 19,642 13,457 690 1000-401-410830-155 RETIREMENT 4,720 9,813 5,093 520 1000-401-410830-210 OFFICE SUPPLIES 362 600 238 400 1000-401-410830-338 RECRUITMENT/RELOCATION 3,387 8,000 4,613 580 1000-401-410830-359 CONTRACT SERVICES 360 1,000 640 64% 1000-401-410830-373 DUES & TRAINING 2,077 6,000 3,923 650 SUBTOTAL HUMAN RESOURCES 77,408 172,099 94,691 550 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 3 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING ACCOUNT NUMBER DESC. MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 1000-402-410100-153 HEALTH INSURANCE 1000-402-410100-155 RETIREMENT 1000-402-410100-210 OFFICE SUPPLIES 1000-402-410100-335 MT LEAGUE OF CITIES 1000-402-410100-359 CONTRACT SERVICES 1000-402-410100-373 DUES & TRAINING 1000-402-410100-379 MEETINGS SUBTOTAL MAYOR/COUNCIL CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 1000-402-410150-121 OVERTIME 1000-402-410150-153 HEALTH INSURANCE 1000-402-410150-155 RETIREMENT 1000-402-410150-210 OFFICE SUPPLIES 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 1000-402-410150-345 TELEPHONE & COMMUNICATION 1000-402-410150-352 RECODIFICATION 1000-402-410150-359 CONTRACT SERVICES 1000-402-410150-373 DUES & TRAINING SUBTOTAL CITY CLERK FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 1000-403-410550-153 HEALTH INSURANCE 1000-403-410550-155 RETIREMENT 1000-403-410550-210 SUPPLIES 1000-403-410550-322 BOOKS 1000-403-410550-353 CONTRACT SERVICES 1000-403-410550-359 CONTRACT -GRIZZLY SECURITY 1000-403-410550-355 BANK CHARGES & FEES 1000-403-410550-373 DUES & TRAINING SUBTOTAL FINANCE 30,115 63,107 32,992 520 24,912 62,936 38,024 600 1,210 2,463 1,253 510 157 100 57- -570 2,111 6,417 4,306 670 1,149 4,500 3,351 74% 6,576 6,000 576- -100 231 10,590 10,359 980 66,461 156,113 89,652 570 43,129 91,120 47,991 530 0 250 250 1000 8,429 20,271 11,842 580 3,387 7,083 3,696 520 231 200 31- -150 95 700 605 860 240 480 240 500 1,140 4,100 2,960 720 0 300 300 1000 1,346 3,200 1,854 580 57,997 127,704 69,707 550 102,040 214,508 112,468 520 16,880 38,696 21,816 560 8,000 16,650 8,650 520 162 300 138 460 0 250 250 1000 120 760 640 84% 638 1,800 1,162 650 1,642 3,600 1,958 54% 1,551 7,500 5,949 790 131,033 284,064 153,031 54% 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 4 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING ACCOUNT NUMBER DESC. CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY&439;S 177,767 372,621 194,854 520 1000-404-411110-153 HEALTH INSURANCE 21,975 52,804 30,829 580 1000-404-411110-155 RETIREMENT 13,913 28,950 15,037 520 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 854 2,500 1,646 660 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 8,449 8,000 449- -60 1000-404-411110-345 TELEPHONE & COMMUNICATION 337 1,000 663 660 1000-404-411110-354 CONTRACT SERVICES 921 5,000 4,079 820 1000-404-411110-373 DUES & TRAINING 1,493 7,000 5,507 790 SUBTOTAL CITY ATTORNEY 225,708 477,875 252,167 530 MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 108,144 228,151 120,007 530 1000-406-410360-121 OVERTIME 46 0 46- 0% 1000-406-410360-153 HEALTH INSURANCE 17,667 51,674 34,007 660 1000-406-410360-155 RETIREMENT 8,451 17,683 9,232 520 1000-406-410360-210 SUPPLIES 1,681 4,500 2,819 630 1000-406-410360-320 PRINTING/BOOKS 678 1,500 822 550 1000-406-410360-345 TELEPHONE & COMMUNICATION 44 1,400 1,356 970 1000-406-410360-353 SECURITY & TECHNOLOGY 5,430 40,000 34,570 860 1000-406-410360-354 CONTRACT SERVICES 912 5,750 4,838 840 1000-406-410360-373 DUES & TRAINING 2,691 10,000 7,309 730 1000-406-410360-394 JURY & WITNESS FEES 663 7,500 6,837 910 SUBTOTAL COURT 146,407 368,158 221,751 600 PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 8,484 17,705 9,221 520 1000-410-430100-153 HEALTH INSURANCE 1,327 3,289 1,962 600 1000-410-430100-155 RETIREMENT 657 1,346 689 510 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 3,042 8,000 4,958 620 1000-410-430100-231 GAS 1,254 2,500 1,246 500 1000-410-430100-345 TELEPHONE & COMMUNICATION 124 350 226 650 1000-410-430100-354 CONTRACT SERVICES 186 2,000 1,814 910 1000-410-430100-373 DUES & TRAINING 889 2,500 1,611 640 1000-410-430100-521 CENTRAL GARAGE TRANSFER 1,806 3,612 1,806 500 1000-410-430100-940 MACHINERY & EQUIPMENT 0 7,400 7,400 1000 SUBTOTAL PUBLIC WORKS ADMIN 17,770 48,702 30,932 640 CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 32,303 68,299 35,996 530 1000-412-411230-153 HEALTH INSURANCE 5,591 15,928 10,337 650 1000-412-411230-155 RETIREMENT 2,439 5,076 2,637 520 1000-412-411230-220 SECURITY IMPROVEMENTS 0 500 500 1000 1000-412-411230-224 JANITORIAL SUPPLIES 1,795 6,000 4,205 700 1000-412-411230-241 TOOLS & SUPPLIES 171 1,500 1,329 890 1000-412-411230-341 ELECTRICITY 19,524 49,200 29,676 600 1000-412-411230-344 NATURAL GAS 12,379 30,000 17,621 590 1000-412-411230-345 TELEPHONE & COMMUNICATION 91 400 309 770 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 5 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING 1000-412-411230-354 CONTRACT SERVICES 15,488 80,000 64,512 81% 1000-412-411230-355 HVAC MAINTENANCE OCNTRACT 15,600 16,500 900 50 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 0 4,500 4,500 1000 1000-412-411230-362 EQUIPMENT MAINTENANCE 847 10,000 9,153 920 1000-412-411230-366 BUILDING MAINTENANCE 7,534 27,500 19,966 730 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,050 3,500 450 130 1000-412-411230-920 BLDG IMP (LIGHT UPGRADES; CHALL ROO 7,842 17,000 9,158 540 SUBTOTAL CITY HALL 124,655 335,903 211,248 630 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 127,160 266,269 139,109 520 1000-420-411020-153 HEALTH INSURANCE 23,044 60,020 36,976 620 1000-420-411020-155 RETIREMENT 9,973 20,657 10,684 520 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 28 5,000 4,972 990 1000-420-411020-231 GAS 92 300 208 690 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 457 2,000 1,543 770 1000-420-411020-345 TELEPHONE 378 900 522 580 1000-420-411020-354 CONTRACT SERVICES 3,600 1,000 2,600- -2600 1000-420-411020-373 DUES & TRAINING 1,785 6,000 4,215 700 1000-420-411020-521 CENTRAL GARAGE TRANSFER 474 949 475 500 1000-420-411020-944 VEHICLE 0 15,000 15,000 1000 SUBTOTAL PLANNING DEPT. 166,992 378,095 211,103 560 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 29,916 63,180 33,264 530 1000-480-470210-153 HEALTH INSURANCE 4,455 8,307 3,852 460 1000-480-470210-155 RETIREMENT 2,345 4,876 2,531 520 1000-480-470210-210 OFFICE SUPPLIES 946 1,500 554 370 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 0 500 500 1000 1000-480-470210-312 POSTAGE & PRINTING 16 500 484 970 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 500 500 0 0% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 157 900 743 830 1000-480-470210-354 CONTRACT SERVICES 0 1,500 1,500 1000 1000-480-470210-373 DUES & TRAINING 814 5,000 4,186 840 1000-480-470210-379 MEETINGS 0 1,500 1,500 1000 SUBTOTAL COMMUNITY DEVELOPMENT 39,150 88,263 49,113 560 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 6 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 1,071,784 2,264,988 1,193,204 530 1000-413-420140-114 SALARY -comptime buyout 2,226 3,000 774 260 1000-413-420140-121 OVERTIME (REG & AET OT) 29,937 80,000 50,063 630 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 0 25,000 25,000 1000 1000-413-420140-153 HEALTH INSURANCE 184,363 445,536 261,173 590 1000-413-420140-155 RETIREMENT 138,798 296,098 157,300 530 1000-413-420140-210 OFFICE SUPPLIES 1,108 3,500 2,392 680 1000-413-420140-215 COMPUTER SUPPLIES 1,546 5,500 3,954 720 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 39,625 53,500 13,875 260 1000-413-420140-220 INVESTIGATIVE SUPPLIES 1,094 4,000 2,906 730 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 4,259 7,000 2,741 390 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 1,393 2,000 607 300 1000-413-420140-226 SRT SUPPORT/SUPPLIES 1,784 10,000 8,216 820 1000-413-420140-227 AMMO & RELATED SUPPLIES 3,649 30,000 26,351 880 1000-413-420140-228 PATROL CAR SUPPLIES 4,112 10,000 5,888 590 1000-413-420140-229 OTHER SUPPLIES 2,141 5,000 2,859 570 1000-413-420140-230 CRIME PREVENTION SUPPLIES 532 1,000 468 470 1000-413-420140-231 GAS 31,168 75,000 43,832 580 1000-413-420140-234 CRISIS NEGOTIATIONS 86 2,000 1,914 960 1000-413-420140-235 BIKE PATROL 0 750 750 1000 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 394 1,500 1,106 740 1000-413-420140-320 PRINTING 1,756 5,500 3,744 680 1000-413-420140-345 TELEPHONE & COMMUNICATION 8,221 17,000 8,779 520 1000-413-420140-354 CONTRACT SERVICES 7,734 7,000 734- -100 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 5,185 6,500 1,315 200 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 614 5,000 4,386 880 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 165 2,000 1,835 920 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 21,821 27,000 5,179 190 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 558 2,500 1,942 780 1000-413-420140-373 DUES & TRAINING 10,494 32,500 22,006 680 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 5,517 5,000 517- -100 1000-413-420140-380 TRAINING MATERIALS 2,920 2,000 920- -460 1000-413-420140-388 MEDICAL SERVICES 1,265 3,000 1,736 580 1000-413-420140-392 BOARDING/TREATING PRISONERS 1,308 2,500 1,192 480 1000-413-420140-521 CENTRAL GARAGE TRANSFER 33,066 66,131 33,065 500 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 32,000 64,000 32,000 500 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 30,000 60,000 30,000 500 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 1,750 3,500 1,750 500 1000-413-420140-940 MAJOR CRIME UNIT TRAILER & RADAR TR 0 29,000 29,000 1000 1000-413-420140-942 EQUIPMENT -RADIO MATCH 0 53,500 53,500 1000 1000-413-420140-944 VEHICLES 89,880 99,055 9,175 90 SUBTOTAL POLICE DEPT. 1,774,249 3,818,058 2,043,809 540 DETECTIVES 1000-413-420141-110 SALARIES -DETECTIVES 177,509 361,097 183,588 510 1000-413-420141-121 DETECTIVE -OVERTIME 4,116 15,000 10,884 730 1000-413-420141-153 HEALTH INSURANCE 33,565 71,662 38,097 530 1000-413-420141-155 DETECTIVE -RETIREMENT 23,003 48,339 25,336 520 TOTAL DETECTIVES 238,194 496,098 257,904 520 RECORDS 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 7 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING 1000-413-420142-110 SALARIES -RECORDS DIVISION 71,194 144,863 73,669 510 1000-413-420142-121 OVERTIME 737 7,500 6,763 900 1000-413-420142-153 HEALTH INSURANCE 13,840 33,228 19,388 580 1000-413-420142-155 RETIREMENT 5,586 11,198 5,612 500 TOTAL RECORDS 91,357 196,789 105,432 540 RESOURCE OFFICERS 1000-413-420144-110 SALARIES -SRO 115,733 257,288 141,555 550 1000-413-420144-153 HEALTH INSURANCE 18,621 58,576 39,955 680 1000-413-420144-155 SRO RETIREMENT 14,377 34,530 20,153 580 TOTAL RESOURCE OFFICERS 148,730 350,394 201,664 580 ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL -SALARIES 20,440 40,750 20,310 500 1000-413-420145-121 OVERTIME 0 500 500 1000 1000-413-420145-153 HEALTH INSURANCE 3,460 9,307 5,847 630 1000-413-420145-155 RETIREMENT 1,498 3,148 1,650 520 SUBTOTAL ANIMAL CONTROL 25,398 53,705 28,307 530 PARKING 1000-413-420147-110 PARKINGS -SALARIES 48,721 88,871 40,150 450 1000-413-420147-153 HEALTH INSURANCE 12,529 25,837 13,308 520 1000-413-420147-155 RETIREMENT 3,699 6,866 3,167 460 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 619 4,000 3,381 850 1000-413-420147-354 CONTRACTED SERVICES 154 2,000 1,846 920 1000-413-420147-362 LOT MAINT 578 10,000 9,422 940 1000-413-420147-365 SNOW REMOVAL -Parking Lots 3,955 17,500 13,545 770 1000-413-420147-550 LOT LEASE PAYMENTS 733 1,500 767 510 SUBTOTAL PARKING 70,988 156,574 85,586 550 SUBTOTAL POLICE DEPT. 2,348,916 5,071,618 2,722,702 540 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 8 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES -FIRE SUPPRESSION 721,047 1,672,064 951,017 570 1000-416-420400-114 COMPTIME BUYOUT 3,199 5,500 2,301 420 1000-416-420400-115 OUT OF RANK PAY 7,169 12,000 4,831 400 1000-416-420400-121 OVERTIME 34,274 40,000 5,726 140 1000-416-420400-153 HEALTH INSURANCE 135,134 315,034 179,900 570 1000-416-420400-155 RETIREMENT 98,350 224,499 126,149 560 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 0 2,000 2,000 1000 1000-416-420400-218 Equipment (Non Capital) 10,652 21,500 10,848 500 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 5,720 15,000 9,280 620 1000-416-420400-224 JANITORIAL SUPPLIES 1,635 5,000 3,365 670 1000-416-420400-231 GAS 4,307 17,325 13,018 750 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 1,570 15,750 14,180 900 1000-416-420400-320 PRINTING 0 200 200 1000 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 237 1,000 764 760 1000-416-420400-345 TELEPHONE & COMMUNICATION 2,061 6,000 3,939 660 1000-416-420400-354 CONTRACT SERVICES 20,949 37,600 16,651 440 1000-416-420400-362 EQUIPMENT MAINTENANCE 652 5,500 4,848 880 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 2,471 7,500 5,029 670 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 1,291 5,000 3,709 740 1000-416-420400-373 DUES & TRAINING 4,537 10,000 5,463 550 1000-416-420400-388 FIREFIGHTER PHYSICALS 0 25,875 25,875 1000 1000-416-420400-521 CENTRAL GARAGE TRANSFER 20,835 41,671 20,836 500 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 0 33,500 33,500 1000 1000-416-420400-620 INTEREST EXPENSE -FIRE TRUCK 0 6,500 6,500 1000 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 175,000 350,000 175,000 500 1000-416-420400-821 TRANSFER TO FUND 2956 GRANT MATCH 0 21,040 21,040 1000 1000-416-420440-110 SALARIES -FIRE PREVENTION 10,451 20,173 9,722 480 1000-416-420440-121 OVERTIME 655 0 655- 0% 1000-416-420440-153 HEALTH INSURANCE 2,180 5,145 2,965 580 1000-416-420440-155 RETIREMENT 793 1,439 646 450 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 1,265,171 2,923,815 1,658,644 570 5,337,873 11,650,571 6,312,698 540 496,000 992,000 496,000 500 496,000 992,000 496,000 500 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 9 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING ACCOUNT NUMBER DESC. 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 424,354 999,000 574,646 580 2215-000-311200-000 PERSONAL PROPERTY TAXES 33,813 40,000 6,187 150 2215-000-312000-000 PEN & INTEREST DEL TAXES 790 2,000 1,210 610 2215-000-346030-000 SWIMMING POOL FEES 94,540 127,000 32,460 260 2215-000-346040-000 CONCESSION STAND REVENUE 30,316 34,000 3,685 11% 2215-000-346050-000 PARKS USAGE FEES 7,091 21,500 14,409 670 2215-000-346051-000 RECREATION FEES 5,036 11,188 6,152 550 2215-000-346052-000 SPORTS PROGRAMS 17,713 43,594 25,881 590 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 1,568 2,500 932 370 2215-000-346054-000 AFTER SCHOOL PROGRAMS 32,682 70,000 37,318 530 2215-000-346055-000 ICE RINK 0 22,500 22,500 1000 2215-000-346056-000 KIDSPORT USAGE 430 2,000 1,570 790 2215-000-346057-000 YOUTH CAMPS 7,285 143,147 135,862 950 2215-000-346059-000 PICNIC IN THE PARK 3,494 25,000 21,506 860 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 10,000 11,500 1,500 130 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 1000 2215-000-371010-000 INVESTMENTS 2,651 3,000 399 120 2215-000-381050-000 INCEPTION OF LEASE 0 64,000 64,000 1000 2215-000-381060-000 HEALTH INSURANCE TRANSFER 45,500 91,000 45,500 500 2215-000-381070-000 GENERAL FUND TRANSFER (BANDSHELL) 10,467 10,467 0 0% TOTAL PARKS & REC REVENUE 727,729 1,743,396 1,015,667 580 PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-936-460430-110 SALARIES -PARKS 152,999 322,778 169,779 530 2215-936-460430-111 SEASONAL SALARIES 18,101 71,610 53,509 750 2215-936-460430-121 OVERTIME 79 500 426 850 2215-936-460430-153 HEALTH INSURANCE 25,770 61,917 36,147 580 2215-936-460430-155 RETIREMENT 12,306 27,476 15,170 550 2215-936-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 635 1,800 1,165 650 2215-936-460430-215 EQUIPMENT - NOT CAPITAL 0 8,000 8,000 1000 2215-936-460430-229 JANITORIAL SUPPLIES 2,927 6,000 3,073 510 2215-936-460430-229 OTHER SUPPLIES 1,767 4,000 2,233 560 2215-936-460430-231 GAS 6,850 14,000 7,150 510 2215-936-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 600 2,500 1,900 760 2215-936-460430-320 PRINTING & ADVERTISING 0 400 400 1000 2215-936-460430-341 ELECTRICITY 5,897 16,000 10,103 630 2215-936-460430-343 ICE RINK UTILITIES(REIMB.) 3,690 22,500 18,810 84% 2215-936-460430-399 NATURAL GAS 677 2,500 1,823 730 2215-936-460430-345 TELEPHONE & COMMUNICATIONS 1,038 3,600 2,562 710 2215-936-460430-351 TENNIS COURT REHABILITATION 1,500 14,467 12,967 900 2215-936-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 2,000 2,000 1000 2215-936-460430-355 CONTRACT SERV.- TRAIL MAINT. 2,576 8,200 5,624 690 2215-936-460430-356 CONSULTANTS 0 30,000 30,000 1000 2215-936-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 0 2,680 2,680 1000 2215-936-460430-358 FVCC TENNIS INTERLOCAL AGREEMENT 0 7,000 7,000 1000 2215-936-460430-362 EQUIPMENT/BLDG MAINTENANCE 13,141 30,000 16,859 560 2215-936-460430-369 LANDSCAPING 369 6,000 5,631 94% 2215-936-460430-367 VANDALISM REPAIRS 134 4,000 3,866 970 2215-936-460430-373 DUES & TRAINING 2,239 8,000 5,761 720 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 10 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 0 400 400 100% 2215-436-460430-395 EQUIPMENT RENTAL 557 700 143 200 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 0 5,500 5,500 1000 2215-436-460430-440 IRRIGATION SUPPLIES 2,962 9,000 6,038 670 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 160 1,700 1,540 910 2215-436-460430-521 CENTRAL GARAGE TRANSFER 20,317 40,634 20,317 500 2215-436-460430-610 DEBT SERVICE PRINCIPAL 13,438 41,602 28,164 680 2215-436-460430-620 DEBT SERVICE INTEREST 1,033 4,280 3,247 760 2215-436-460430-931 PARK IMPROV - THOMPSON PLAYGROUND 0 29,000 29,000 1000 2215-436-460430-932 PARK IMPROV - NORTHRIDGE IRRIGATION 0 20,000 20,000 1000 2215-436-460430-933 PARK IMPROVEMENTS - DOG PARK 32,840 50,000 17,160 340 2215-436-460430-941 KUBOTA MOWER AND SPRAY GATOR (FY17/ 35,191 64,000 28,809 450 SUBTOTAL PARKS EXPENDITURES 359,789 944,744 584,955 620 ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 42,314 90,559 48,245 530 2215-436-460440-111 SEASONAL SALARIES 24,559 41,904 17,345 410 2215-436-460440-153 HEALTH INSURANCE 9,235 28,403 19,168 670 2215-436-460440-155 RETIREMENT 4,926 6,975 2,049 290 2215-436-460440-221 SAFETY EQUIPMENT 0 350 350 1000 2215-436-460440-229 OTHER SUPPLIES 2,390 15,500 13,110 850 2215-436-460440-231 GAS 2,977 9,500 6,523 690 2215-436-460440-241 CONSUMABLE TOOLS 38 5,000 4,962 990 2215-436-460440-341 ELECTRICITY 5,760 8,500 2,740 320 2215-436-460440-345 TELEPHONE & COMMUNICATION 61 175 114 650 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 1000 2215-436-460440-355 CONTRACT SERVICES - ASPHAT RESURFC 3,389 50,000 46,611 930 2215-436-460440-362 EQUIPMENT MAINTENANCE 144 600 456 760 2215-436-460440-364 LANDSCAPING 136 600 464 770 2215-436-460440-367 VANDALISM REPAIRS 0 500 500 1000 2215-436-460440-373 DUES & TRAINING 140 500 360 720 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 0 200 200 1000 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 1000 2215-436-460440-420 METAL PRODUCTS 2,870 5,300 2,430 460 2215-436-460440-440 IRRIGATION 2,470 4,500 2,030 450 2215-436-460440-452 SAND & GRAVEL 1,078 1,000 78- -80 2215-436-460440-521 CENTRAL GARAGE TRANSFER 548 1,097 549 500 2215-436-460440-940 EQUIPMENT - SAND PRO GROOMER 2,650 5,000 2,350 470 SUBTOTAL ATHLETIC COMPLEX 105,683 277,313 171,630 620 RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 39,523 83,239 43,716 530 2215-436-460431-111 SEASONAL SALARIES 3,704 8,389 4,685 560 2215-436-460431-153 HEALTH INSURANCE 8,252 19,973 11,721 590 2215-436-460431-155 RETIREMENT 3,077 6,943 3,866 560 2215-436-460431-229 MISC. SUPPLIES 3,165 9,070 5,905 650 2215-436-460431-231 GAS 229 720 491 680 2215-436-460431-320 PRINTING & ADVERTISING 0 11,265 11,265 1000 2215-436-460431-345 TELEPHONE & COMMUNICATION 256 640 384 600 2215-436-460431-354 CONTRACT SERVICES 16,215 21,060 4,845 230 2215-436-460431-355 On Line Registration 0 7,499 7,499 1000 2215-436-460431-357 MUSIC FRANCHISE FEES 346 1,100 754 690 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 11 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING ACCOUNT NUMBER DESC. 2215-436-460431-373 DUES & TRAINING 100 1,000 900 900 SUBTOTAL RECREATION 74,866 170,898 96,032 560 YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 35,160 74,110 38,950 530 2215-436-460448-111 SEASONAL SALARIES 64,625 139,101 74,476 540 2215-436-460448-121 OVERTIME 0 300 300 1000 2215-436-460448-153 HEALTH INSURANCE 7,762 18,797 11,035 590 2215-436-460448-155 RETIREMENT 2,734 6,622 3,888 590 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 30 400 370 920 2215-436-460448-229 MISC. SUPPLIES 1,162 3,730 2,568 690 2215-436-460448-231 GAS 0 500 500 1000 2215-436-460448-320 PRINTING & ADVERTISING 0 270 270 1000 2215-436-460448-345 TELEPHONE & COMMUNICATION 439 1,000 561 560 2215-436-460448-354 CONTRACT SERVICES 7,639 11,380 3,741 330 2215-436-460448-355 AFTER SCHOOL PROGRAM 165 1,200 1,035 860 2215-436-460448-356 BANK FEES/CC CHARGES 1,135 6,080 4,945 810 2215-436-460448-373 DUES & TRAINING 0 1,000 1,000 1000 SUBTOTAL YOUTH CAMPS 120,853 264,490 143,637 540 POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 121,005 179,308 58,303 330 2215-437-460445-121 OVERTIME 129 500 371 740 2215-437-460445-155 RETIREMENT 1,018 1,500 482 320 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 192 500 308 620 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,580 2,700 1,120 410 2215-437-460445-226 CHLORINE/CHEMICALS 14,601 27,000 12,399 460 2215-437-460445-228 CONCESSION STAND SUPPLIES 12,753 21,000 8,247 390 2215-437-460445-229 TOOLS/OTHER SUPPLIES 542 4,500 3,958 880 2215-437-460445-341 ELECTRICITY 4,729 9,500 4,771 500 2215-437-460445-344 NATURAL GAS 11,006 25,000 13,994 560 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 938 1,620 682 420 2215-437-460445-354 LICENSES & FEES 669 1,300 631 490 2215-437-460445-356 BANK FEES/ CC CHARGES 1,756 1,632 124- -80 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 6,829 45,500 38,671 850 2215-437-460445-380 TRAINING MATERIALS 0 1,800 1,800 1000 SUBTOTAL POOL EXPENDITURES 177,747 323,360 145,613 450 TOTAL PARKS & RECREATION/POOL 838,938 1,980,805 1,141,867 580 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 12 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING FORESTRY & DEVELOPER TREES 2600-936-460433-110 SALARIES -URBAN FORESTRY 58,028 161,069 103,042 64% 2600-936-460433-111 SEASONAL SERVICES 0 29,856 29,856 1000 2600-936-460433-121 OVERTIME 10 1,000 990 990 2600-936-460433-153 HEALTH INSURANCE 10,824 42,075 31,251 74% 2600-936-460433-155 RETIREMENT 4,428 14,088 9,660 690 2600-936-460433-229 OFFICE/OTHER SUPPLIES 95 600 505 84% 2600-936-460433-231 GAS 723 2,500 1,777 710 2600-936-460433-241 CONSUMABLE TOOLS 2,541 3,249 708 220 2600-936-460433-359 CONTRACT SERVICES 23,536 356,560 333,024 930 2600-936-460433-357 FORESTRY GRANT 6,943 19,500 12,558 64% 2600-936-460433-358 DUTCH ELM DISEASE/tree disposal 1,701 5,000 3,299 660 2600-936-460433-362 EQUIPMENT MAINTENANCE 210 2,500 2,290 920 2600-936-460433-369 LANDSCAPING & TREES 1,285 8,000 6,716 84% 2600-936-460433-373 DUES & TRAINING 2,116 3,500 1,384 400 2600-936-460433-510 LIABILITY & PROPERTY INSURANCE 1,138 1,138 0 0% 2600-936-460433-521 CENTRAL GARAGE TRANSFER 4,084 8,167 4,083 500 2600-936-460433-522 ADMINISTRATIVE TRANSFER 6,099 12,197 6,098 500 2600-936-460433-528 DATA PROCESSING TRANSFER 2,085 4,171 2,086 500 2600-936-460433-610 DEBT SERVICE PRINCIPAL 5,992 14,905 9,463 630 2600-936-460433-620 INTEREST EXPENSE 394 1,295 901 700 2600-936-460433-940 MACHINERY & EQUIPMENT 48,180 55,000 6,820 120 TOTAL URBAN FORESTRY 179,860 746,370 566,510 760 2601-936-460435-351 EMPIRE ESTATES ($99,911) 0 8,653 8,653 1000 2601-936-460435-352 APPLEWAY ($9,569) 0 4,336 4,336 1000 2601-936-460435-353 LEISURE HEIGHTS ($9,990) 0 366 366 1000 2601-936-460435-359 CONTRACT SERVICES 0 11,231 11,231 1000 2601-936-460435-356 SINOPAH SUBD ($5,790) 0 667 667 1000 2601-936-460435-357 COTTONWOOD SUBD ($13,100) 0 1,603 1,603 1000 2601-936-460435-358 WEST VIEW SUBD ($22,680) 734 14,936 14,202 950 2601-936-460435-359 MTN VISTA ESTATES ($35,903+39,660) 2,936 25,129 22,193 880 2601-936-460435-361 VILLAGE GREENS ($3,590) 0 2,219 2,219 1000 2601-936-460435-362 WESTVIEW BUSINESS CNTR ($1,618) 0 998 998 1000 2601-936-460435-363 MUSKRAT SLOUGH ($1,996) 0 1,390 1,390 1000 2601-936-460435-369 MTN VISTA ESTATES III $17,278.25 0 989 989 1000 2601-936-460435-365 VILLAGE GREENS $3,540 0 578 578 1000 2601-936-460435-366 W VIEW ESTATES $20,060 0 8,490 8,490 1000 2601-936-460435-367 ABIGAIL SUBDIVISION ($9,253.90) 0 2,358 2,358 1000 2601-936-460435-368 NORTHLAND SUBD PHASE 9 0 8,812 8,812 1000 2601-936-460435-369 GL VILLAGE GREENS, Ph 22B ($9,130) 0 1,474 1,474 1000 2601-936-460435-370 GL VILLAGE GREENS PH22C ($5,600) 0 1,100 1,100 1000 TOTAL DEVELOPER TREES 3,670 94,774 91,104 960 2210 PARKS IN LIEU 2210-936-460430-934 CAPITAL IMPROVEMENTS 0 1,432 1,432 1000 TOTAL PARKS IN LIEU 0 1,432 1,432 1000 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 13 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 381,272 750,000 368,728 490 2230-000-342070-000 COUNTY EMS LEVY 0 110,000 110,000 1000 2230-000-383010-000 TRANSFER FROM GENERAL FUND 175,000 350,000 175,000 500 TOTAL AMBULANCE REVENUE 556,272 1,210,000 653,728 54% AMBULANCE EXPENDITURES 2230-990-420730-110 SALARIES 2230-990-420730-114 COMPTIME BUYBACK 2230-990-420730-115 OUT OF RANK PAY 2230-990-420730-121 OVERTIME 2230-990-420730-153 HEALTH INSURANCE 2230-990-420730-155 RETIREMENT 2230-990-420730-210 OFFICE/COMPUTER SUPPLIES 2230-990-420730-218 NON -CAPITAL EQUIPMENT 2230-990-420730-231 GAS & OIL 2230-990-420730-241 CONSUMABLE TOOLS/UNIFORMS 2230-990-420730-312 POSTAGE/PRINTING 2230-990-420730-345 TELEPHONE & COMMUNICATION 2230-990-420730-359 CONTRACT SERVICES 2230-990-420730-355 911 CENTER CONTRIBUTION 2230-990-420730-359 AUDIT/CC OTHER FEES 2230-990-420730-362 EQUIPMENT/RADIO MAINTENANCE 2230-990-420730-373 DUES & TRAINING 2230-990-420730-388 EXP. TESTING/IMMUNIZATION 2230-990-420730-391 MEDICAL TREATMENT -SUPPLIES 2230-990-420730-510 PROPERTY & LIABILITY INSURANCE 2230-990-420730-521 CENTRAL GARAGE TRANSFER 2230-990-420730-522 ADMINISTRATIVE TRANSFER 2230-990-420730-528 DATA PROCESSING TRANSFER TOTAL AMBULANCE EXPENDITURES 2399 PUBLIC SAFETY IMPACT FEES 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 50 2399-413-420140-940 POLICE EQUIPMENT 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 2399-416-420400-620 INTEREST - FIRE TRUCK 2399-416-420400-940 FIRE DEPT. EQUIPMENT TOTAL PUBLIC SAFETY IMPACT FEE FIRE & HAZMAT GRANTS 2956-416-420400-218 EQUIPMENT (NON CAPITAL) 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 2956-416-420415-940 AFG GRT FY16 COTS/ FY18 SCBA TOTAL FIRE GRANTS 275,854 640,748 364,894 570 0 3,500 3,500 1000 1,099 2,500 1,456 580 9,516 30,000 20,484 680 59,917 156,265 96,348 620 36,903 85,036 48,133 570 19 1,400 1,381 990 402 4,200 3,798 900 2,315 7,560 5,245 690 0 4,000 4,000 1000 0 1,500 1,500 1000 777 1,700 923 54% 17,064 43,690 26,626 610 17,250 34,500 17,250 500 1,201 1,650 999 270 3,167 5,000 1,834 370 740 5,000 4,260 850 0 2,500 2,500 1000 11,748 48,300 36,552 760 25,771 25,886 115 0% 9,035 18,070 9,035 500 24,204 48,407 24,203 500 8,342 16,684 8,342 500 505,269 1,188,096 682,827 570 7,500 15,000 7,500 500 0 100,000 100,000 1000 34,000 67,675 33,675 500 1,360 2,034 674 330 0 750,000 750,000 1000 42,860 934,709 891,849 950 320 0 320- 3,293 5,000 1,757 0 231,998 231,998 3,563 236,998 232,885 0% 350 1000 98 0 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 14 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING ACCOUNT NUMBER DESC. 2957-416-420400-155 RETIREMENT 0 2,500 2,500 1000 2957-416-420410-125 PASS THRU HAZMAT OT 1,650 10,000 8,350 840 2957-416-420410-218 PASS THRU HAZMAT EQUIP 1,783 9,000 7,217 800 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 1,120 2,000 880 440 TOTAL HAZMAT GRANTS 4,553 23,500 18,947 810 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 15 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING ACCOUNT NUMBER DESC. 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 364,975 800,000 435,025 540 2394-000-323103-000 PLUMBING PERMITS 17,714 30,000 12,286 410 2394-000-323104-000 MECHANICAL PERMITS 52,786 40,000 12,786- -320 2394-000-323105-000 ELECTRICAL PERMITS 44,941 75,000 30,059 400 2394-000-323108-000 PLAN REVIEW FEES 144,833 400,000 255,167 640 2394-000-371010-000 INVESTMENT EARNINGS 9,162 5,000 4,162- -830 TOTAL REVENUE 634,411 1,350,000 715,589 530 BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 218,738 490,717 271,979 550 2394-420-420530-121 OVERTIME 16,807 10,000 6,807- -680 2394-420-420530-153 HEALTH INSURANCE 37,579 101,155 63,576 630 2394-420-420530-155 RETIREMENT 17,792 36,340 18,548 510 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 29,748 28,105 1,643- -60 2394-420-420530-231 GAS & OIL 1,222 3,500 2,278 650 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 107 7,300 7,193 990 2394-420-420530-323 ST. ED. ASSESSMENTS 0 7,500 7,500 1000 2394-420-420530-345 TELEPHONE & COMMUNICATION 1,796 4,000 2,204 550 2394-420-420530-353 AUDITING 3,350 4,500 1,150 260 2394-420-420530-354 CONTRACT SERVICES 17,268 10,000 7,268- -730 2394-420-420530-355 CITY WORKS LICENSING FEE 3,332 21,250 17,918 840 2394-420-420530-356 ARCGIS SERVER UPGRADE LICENSE 9,500 9,500 0 0% 2394-420-420530-360 FURNITURE 3,966 9,000 5,034 560 2394-420-420530-373 DUES & TRAINING 9,089 20,000 10,911 550 2394-420-420530-510 PROPERTY INSURANCE 7,176 5,389 1,787- -330 2394-420-420530-521 CENTRAL GARAGE TRANSFER 941 1,882 941 500 2394-420-420530-522 ADMINISTRATIVE TRANSFER 10,727 21,454 10,727 500 2394-420-420530-528 DATA PROCESSING TRANSFER 14,598 29,196 14,598 500 2394-420-420530-920 AWNING 9,447 10,000 553 60 2394-420-420530-940 SERVER 0 10,000 10,000 1000 2394-420-420530-944 VEHICLES 800 85,000 84,200 990 TOTAL BUILDING DEPT. 413,981 925,788 511,807 550 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 16 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING ACCOUNT NUMBER DESC. 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 2400-410-430263-153 HEALTH INSURANCE 2400-410-430263-155 RETIREMENT 2400-410-430263-299 STREET LIGHT SUPPLIES 2400-410-430263-245 LUMINAIRES 2400-410-430263-246 LED LUMINAIRE UPGRADE 2400-410-430263-341 ELECTRICITY 2400-410-430263-360 REPAIR & MAINT SERVICES 2400-410-430263-510 INSURANCE 2400-410-430263-522 ADMINISTRATIVE TRANSFER 2400-410-430263-940 MACHINERY & EQUIPMENT 2400-410-490500-610 DEBT SERVICE -PRINCIPAL 2400-410-490500-620 DEBT SERVICE -INTEREST EXPENSE TOTAL LIGHT MAINT. 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 2420-421-430234-957 ALLEY PAVING 2420-421-430240-231 GAS & OIL 2420-421-430240-399 NATURAL GAS 2420-421-430240-359 CONTRACT SERVICES - STRIPING 2420-421-430240-360 REPAIR & MAINT SERVICES 2420-421-430240-368 OVERLAY/CHIPSEALS 2420-421-430240-452 GRAVEL 2420-421-430240-453 EQUIPMENT RENTAL 2420-421-430240-471 DE-ICER/ROAD OIL 2420-421-430240-472 ASPHALT 2420-421-430240-473 CRACK SEALING 2420-421-430240-474 PAINT STRIPING MATERIALS TOTAL GAS TAX 2825 MACI GRANT 2825-421-430240-940 SANDER / SWEEPER TOTAL MACI GRANT 34,712 72,058 37,346 520 4,803 12,535 7,732 620 2,602 5,324 2,722 510 2,556 18,000 15,999 860 20,075 30,000 9,925 330 0 60,000 60,000 1000 64,855 182,000 117,145 64% 8,474 20,000 11,526 580 711 1,500 789 530 6,601 13,202 6,601 500 35,549 36,000 451 to 11,014 22,055 11,041 500 273 551 278 500 192,227 473,225 280,998 590 43,192 94,557 51,365 54% 12,138 40,000 27,862 700 11,685 40,000 28,315 710 1,504 5,500 3,996 730 0 20,000 20,000 1000 450 1,500 1,050 700 119,073 269,073 150,000 560 3,334 3,500 166 50 0 5,000 5,000 1000 4,809 40,000 35,191 880 7,474 53,000 45,526 860 0 14,500 14,500 1000 1,345 30,000 28,655 960 205,004 616,630 411,626 670 0 433,202 433,202 1000 0 433,202 433,202 1000 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 340,995 731,217 390,222 530 2500-421-430240-121 OVERTIME 4,954 25,000 20,046 800 2500-421-430240-153 HEALTH INSURANCE 59,435 163,219 103,784 64% 2500-421-430240-155 RETIREMENT 25,812 53,704 27,892 520 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 1,656 12,360 10,704 870 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 3,896 8,950 5,054 560 2500-421-430240-220 OTHER SUPPLIES 942 4,500 3,558 790 2500-421-430240-231 GAS & OIL 12,138 40,000 27,862 700 2500-421-430240-341 ELECTRICITY 1,016 3,500 2,484 710 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 610 1,500 891 590 2500-421-430240-359 CONTRACT SERVICES 6,517 30,000 23,483 780 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 17 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING �G/L ACCOUNT NUMBER DESC. 2500-421-430240-356 CONSULTANT 0 65,050 65,050 100% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 12,974 33,500 20,526 610 2500-421-430240-366 BUILDING MAINTENANCE 317 5,000 4,683 940 2500-421-430240-373 DUES & TRAINING 623 5,500 4,877 890 2500-421-430240-388 MEDICAL SERVICES 53 1,000 948 950 2500-421-430240-510 LIABILITY INSURANCE 17,650 17,359 291- -20 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 1000 2500-421-430240-521 CENTRAL GARAGE TRANSFER 90,117 180,235 90,118 500 2500-421-430240-522 ADMINISTRATIVE TRANSFER 46,650 93,300 46,650 500 2500-421-430240-528 DATA PROCESSING TRANSFER 6,256 12,513 6,257 500 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 37,366 122,878 85,512 700 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 1,369 35,820 34,451 960 2500-421-430240-920 SALT BRINE TANK 2,777 11,050 8,273 750 2500-421-430240-921 SAND/COLD MIX STORAGE SHED 14,601 15,325 724 50 2500-421-430240-923 COLD STORAGE ROOF REPLACEMENT 0 31,500 31,500 1000 2500-421-430240-953 SHOP COMPLEX PAYVEMENT RESTORATION 0 38,200 38,200 1000 2500-421-430240-969 4TH AVE E MAIN REPLC PHASE 1-4 615,098 670,000 54,902 80 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 262,463 881,952 619,489 700 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 288,527 330,807 42,280 130 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 1000 2500-421-430264-110 TSS - SALARIES 57,307 124,700 67,393 540 2500-421-430264-121 OVERTIME 0 7,500 7,500 1000 2500-421-430264-153 HEALTH INSURANCE 8,524 17,614 9,090 520 2500-421-430264-155 RETIREMENT 4,233 9,084 4,851 530 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 539 1,500 961 640 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,710 10,200 8,490 830 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 520 3,500 2,980 850 2500-421-430264-242 STREET SIGNS 3,861 35,000 31,139 890 2500-421-430264-243 TRAFFIC SIGNALS 182 20,000 19,818 990 2500-421-430264-245 BARRICADE MATERIALS 0 5,000 5,000 1000 2500-421-430264-341 ELECTRICITY 664 3,000 2,336 780 2500-421-430264-345 COMMUNICATIONS 321 850 530 620 2500-421-430264-354 CONTRACT SERVICES 6,581 10,000 3,419 340 2500-421-430264-362 EQUIPMENT MAINTENANCE 805 3,000 2,195 730 2500-421-430264-366 BUILDING MAINTENANCE 215 2,000 1,785 890 2500-421-430264-373 DUES & TRAINING 1,688 5,500 3,812 690 2500-421-430264-428 PAINT MATERIALS 4,147 5,000 853 170 2500-421-430264-510 LIABILITY INS.-TSS 1,793 2,014 221 11% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 0 2,500 2,500 1000 2500-421-430264-521 CENTRAL GARAGE TRANSFER 4,012 8,024 4,012 500 2500-421-430264-532 OFFICE RENT 6,422 6,422 0 0% 2500-421-430264-940 MACHINERY & EQUIPMENT 0 36,000 36,000 1000 TOTAL SPEC. ST. MAINT. 1,958,338 3,981,175 2,022,837 510 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 18 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING ACCOUNT NUMBER DESC. 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 1,600 1,600 0 0% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 4,988 9,975 4,988 500 2185-000-430300-840 REDEVELOPMENT ACTIVITY 0 2,000,000 2,000,000 1000 2185-480-470240-110 SALARIES 9,508 19,988 10,480 520 2185-480-470240-153 HEALTH INSURANCE 1,708 2,963 1,255 420 2185-480-470240-155 RETIREMENT 746 1,568 822 520 2185-480-470240-345 TELEPHONE & COMMUNICATION 29 98 29 500 TOTAL AIRPORT TIF 18,574 2,036,142 2,017,568 990 2188 WESTSIDE TIF REVENUE 2188-000-311100-000 REAL PROPERTY TAXES 91,215 300,000 208,785 700 2188-000-311200-000 PERSONAL PROPERTY TAXES 7,762 0 7,762- 0% 2188-000-312000-000 PEN & INTEREST DEL. TAXES 213 200 13- -60 2188-000-335230-000 ENTITLEMENT SHARE PMT/SB96, 372 121,564 243,128 121,564 500 2188-000-341015-000 DEVELOPER PMT-DEPOT PLACE APTS 3,977 8,500 4,523 530 2188-000-371010-000 INVESTMENT EARNINGS 20,436 15,000 5,936- -360 2188-000-381030-000 BOND PROCEEDS 0 5,000,000 5,000,000 1000 TOTAL REVENUE 245,167 5,566,828 5,321,661 960 EXPENDITURES 2188-480-470230-110 SALARIES 20,407 43,230 22,823 530 2188-480-470230-153 HEALTH INSURANCE 2,746 5,599 2,853 510 2188-480-470230-155 RETIREMENT 1,599 3,375 1,776 530 2188-480-470230-353 AUDIT 3,000 3,000 0 0% 2188-480-470230-354 TO PORT/GATEWAY W. BLDG MAINT. 0 5,000 5,000 1000 2188-480-470230-356 TELEPHONE 96 192 96 500 2188-480-470230-522 ADMINISTRATIVE TRANSFER 1,983 3,966 1,983 500 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 1,998 950,000 948,552 1000 2188-480-470230-840 TRANSFER TO DEBT SERVICE 20,000 40,000 20,000 500 2188-480-470230-842 TRANSFER TO DEBT SERVICE FUND 3188 0 200,000 200,000 1000 2188-480-470240-720 PRE AWARD TIGER 37,078 0 37,078- 0% 2188-480-470240-840 TRANSFER TO TIGER GRANT FUND 0 8,107,000 8,107,000 1000 TOTAL WESTSIDE TIF 88,358 9,361,362 9,273,004 990 OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 11,000 11,000 1000 2310-480-470210-356 FED -EX REIMBURSEMENT 9,927 10,500 573 50 2310-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 30,000 60,000 30,000 500 2311-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 5,000 10,000 5,000 500 TOTAL OLD SCHOOL TIFS 99,927 91,500 46,573 510 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 19 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 0 1,000 1,000 1000 2880-480-470210-359 CONTRACT SERVICES 0 1,000 1,000 1000 2880-480-470210-711 REDEVELOPMENT 15,513 100,000 84,487 84% TOTAL LOAN REVOLVING 15,513 102,000 86,487 850 2881 CD LOAN REV. 12 2881-480-470210-711 REDEVELOPMENT TOTAL 2881 CD REV. 12 2886 CD MISC. 2886-480-470210-211 GRANT ADMINISTRATION EXP/PROJECT EX 2886-480-470210-353 AUDITING 2886-480-470210-373 DUES & TRAINING 2886-480-470210-379 MEETINGS 2886-480-470210-396 GRANT SERVICES 2886-480-470210-522 ADMINISTRATIVE TRANSFER 2886-480-470210-528 DATA PROCESSING TRANSFER 2886-480-470210-532 OFFICE RENT 2886-480-470210-620 INTEREST - OLD SCHOOL LOAN - GENERA 2886-480-470210-790 COMM. DEV. ACTIVITIES 2886-480-470210-795 REDEVELOPMENT- OLD SCHOOL STATION TOTAL CD MISC. 2887 RURAL DEVELOPMENT 11 2887-480-470210-610 DEBT SERVICE/PAIN-L#61-01 2887-480-470210-620 INTEREST EXPENSE/1,461-01 2887-480-470210-750 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT 11 2888 RURAL DEVELOPMENT 12 2888-480-470210-610 DEBT SERVICE/PAIN-L#61-03 2888-480-470210-620 INTEREST EXPENSE -USDA LOAN 61-03 2888-480-470210-750 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT 12 2953 EPA BROWNFIELDS 2953-480-470210-359 CONT SERV/PETROLEUM 2953-480-470210-373 TRAVEL/PETROLEUM 2953-480-470215-359 CONT SERW HAZARDOUS 2953-480-470215-373 TRAVEL/HAZARDOUS TOTAL EPA BROWNSFIELD 0 150,000 150,000 1000 0 150,000 150,000 1000 0 2,000 2,000 1000 1,000 1,000 0 0% 0 2,000 2,000 1000 0 1,000 1,000 1000 0 5,000 5,000 1000 0 2,000 2,000 1000 4,171 8,342 4,171 500 1,175 1,175 0 0% 0 32,500 32,500 1000 0 3,750 3,750 1000 78,247 175,102 96,855 550 84,593 233,869 149,276 64% 22,074 18,454 3,620- -200 0 3,620 3,620 1000 5 200,000 199,995 1000 22,079 222,074 199,995 900 10,025 8,219 1,806- -220 0 1,806 1,806 1000 0 150,000 150,000 1000 10,025 160,025 150,000 94% 0 185,592 185,592 1000 846 3,357 2,511 750 0 185,592 185,592 1000 1,085 3,517 2,432 690 1,931 378,058 376,127 990 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 20 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING ACCOUNT NUMBER DESC. 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES -PETROLEUM 0 908 908 1000 2955-480-470210-352 PERSONNEL -PETROLEUM 0 3,505 3,505 1000 2955-480-470210-353 FRINGES -PETROLEUM 0 993 993 1000 2955-480-470210-359 CONTRACTED SERVICES-PETROLUEM 0 1,488 1,488 1000 2955-480-470210-720 CLEANUP LOANS -PETROLEUM 0 62,354 62,354 1000 2955-480-470210-721 CLEANUP SUBGRANTS-PETRO 0 100,000 100,000 1000 2955-480-470210-725 REVOLVED FUNDS -PETROLEUM 0 100,500 100,500 1000 2955-480-470215-229 SUPPLIES -HAZARDOUS SUBSTANCES 0 1,158 1,158 1000 2955-480-470215-359 CONTRACT SERV-HAZARDOUS SUBST 0 88 88 1000 2955-480-470215-373 TRAVEL -HAZARDOUS SUBTSANCE 0 2,330 2,330 1000 2955-480-470215-720 CLEANUP LOANS -HAZARDOUS 0 314,600 314,600 1000 TOTAL BROWNFIELDS LOAN REV. 0 587,424 587,424 1000 2991 TIGER GRANT 2991-480-470245-790 REDEVELOPMENT - TRAIL 2991-480-470245-791 REDEVELOPMENT - RAIL PARK TOTAL TIGER GRANT 2999 KIDSPORTS GRANT 2999-436-460436-930 CAPITAL IMPROVEMENTS TOTAL KIDSPORTS GRANT 0 5,787,000 5,787,000 1000 2,201,076 12,320,000 10,118,924 820 2,201,076 18,107,000 15,905,924 880 561,995 1,302,724 740,729 570 561,995 1,302,724 740,729 570 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 21 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD /2015 GRT 1,367 20,264 18,897 930 2915-413-420140-354 CONT SERV-WPD/MFWPE - STONEGARDEN 6,745 41,209 34,464 840 TOTAL 2915 STONEGARDEN GRANT 8,111 61,473 53,362 870 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 2916-413-420140-121 OVERTIME 2916-413-420140-153 HEALTH INSURANCE 2916-413-420140-155 RETIREMENT 2916-413-420140-354 CONTRACT SERVICES TOTAL 2916 DRUG ENFORCEMENT 2918 CHRP GRANT 2918-413-420140-110 SALARIES & PAYROLL COSTS 2918-413-420140-153 HEALTH INSURANCE 2918-413-420140-155 RETIREMENT TOTAL CHRP GRANT 27,474 62,808 35,334 560 5,839 7,500 1,661 220 3,212 8,307 5,095 610 3,778 8,431 4,653 550 2,591 6,000 3,409 570 42,894 93,046 50,152 540 29,282 57,417 28,135 490 3,460 8,307 4,847 580 3,707 7,706 3,999 520 36,449 73,430 36,981 500 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 1,598 4,000 2,402 600 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 14,042 36,000 21,958 610 2919-413-420140-127 SCHOOL DIST. OT 12,277 20,000 7,723 390 2919-413-420140-218 JAG GRT/RADIOS & TRAINING 0 12,000 12,000 1000 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 1,787 12,500 10,713 860 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 6,015 7,000 985 140 TOTAL LAW ENF. GRANT 35,718 91,500 55,782 610 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 22 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I 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 1000 0 500,000 500,000 1000 4,084 25,000 20,916 840 4,084 25,000 20,916 840 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 23 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING ACCOUNT NUMBER DESC. ENTERPRISE FUNDS WATER REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 675 0 675- 0% 5210-000-331113-000 FEMA HMGP DR1996P7F/ BACKUP GENERAT 63,847 0 63,897- 0% 5210-000-343210-000 METERED WATER SALES 2,034,506 2,900,000 865,494 300 5210-000-343220-000 UNMETERED WATER SALES 17,959 30,000 12,041 400 5210-000-343225-000 IMPACT FEES 389,001 323,000 66,001- -200 5210-000-343230-000 METER REPLACEMENT FEE 51,799 98,000 46,201 470 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 29,025 19,000 10,025- -530 5210-000-343265-000 IMPACT ADMIN FEES 0 17,000 17,000 1000 5210-000-343270-000 WATER TURN ON FEES 3,405 6,000 2,595 430 5210-000-343275-000 TAG FEE 32,500 45,000 12,500 280 5210-000-343365-000 LATECOMER ADMIN FEE 5,586 0 5,586- 0% 5210-000-371010-000 INVESTMENT EARNINGS 53,814 80,000 26,186 330 5210-000-381050-000 INCEPTION OF LEASE (FOR BUDGET ONLY 0 2,151,616 2,151,616 1000 TOTAL WATER REVENUE 2,682,116 5,669,616 2,987,500 530 WATER FACILITIES 5210-997-430550-110 SALARIES -WATER 333,275 717,155 383,880 54% 5210-997-430550-111 SEASONAL SALARIES 0 5,000 5,000 1000 5210-997-430550-121 OVERTIME 5,404 20,000 14,596 730 5210-997-430550-153 HEALTH INSURANCE 60,746 162,626 101,880 630 5210-997-430550-155 RETIREMENT 25,246 52,778 27,532 520 5210-997-430550-210 OFFICE & COMPUTER SUPPLIES 3,937 12,000 8,063 670 5210-997-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 3,465 8,500 5,035 590 5210-997-430550-226 CHLORINE & CHEMICALS 17,780 38,000 20,220 530 5210-997-430550-229 JANITORIAL/OTHER SUPPLIES 1,181 4,500 3,319 74% 5210-997-430550-231 GAS & OIL 9,617 35,000 25,383 730 5210-997-430550-312 POSTAGE & PRINTING/ADVERTISING 135 1,000 865 870 5210-997-430550-336 LICENSES & FEES 0 18,500 18,500 1000 5210-997-430550-341 ELECTRICITY 80,788 150,000 69,212 460 5210-997-430550-399 NATURAL GAS 3,784 15,500 11,716 760 5210-997-430550-345 TELEPHONE & COMMUNICATION 4,938 10,500 5,562 530 5210-997-430550-399 LAB SERVICES 4,795 20,000 15,205 760 5210-997-430550-353 AUDITING 5,000 5,000 0 00 5210-997-430550-354 CONTRACT SERVICES 19,303 55,000 35,697 650 5210-997-430550-356 CONSULTANTS-WTR RIGHTS/MODELING 203,834 325,000 121,166 370 5210-997-430550-362 EQUIP REPAIRS/MAINT/RENTAL 2,529 15,000 12,471 830 5210-997-430550-366 BUILDING MAINTENANCE 1,255 12,000 10,745 900 5210-997-430550-373 DUES & TRAINING 1,760 9,000 7,240 800 5210-997-430550-388 MEDICAL SERVICES 158 600 993 74% 5210-997-430550-410 CONSTRUCTION MATERIALS 12,312 35,000 22,688 650 5210-997-430550-422 HYDRANTS 5,468 10,000 4,532 450 5210-997-430550-423 MATERIALS FOR MAINS 2,097 14,000 11,903 850 5210-997-430550-424 MATERIALS -SERVICE LINES 5,721 12,000 6,279 520 5210-997-430550-425 MATERIALS PUMPS/WELLS 2,495 45,000 42,505 94% 5210-997-430550-510 PROPERTY & LIABILITY INS. 20,309 19,398 911- -50 5210-997-430550-512 UNINSURED LOSS -DEDUCTIBLE 5,283 10,000 4,717 470 5210-997-430550-521 CENTRAL GARAGE TRANSFER 11,875 23,750 11,875 500 5210-997-430550-522 ADMINISTRATIVE TRANSFER 57,111 114,222 57,111 500 5210-997-430550-528 DATA PROCESSING TRANSFER 14,598 36,000 21,402 590 5210-997-430550-532 LEASE PAYMENTS (City Hall rent) 9,048 9,500 452 50 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 24 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING 5210-447-430550-921 SAND/COLD MIX STORAGE SHED 14,227 15,325 1,098 7% 5210-447-430550-936 Noffsinger Spring Generator 7,736 31,057 23,321 750 5210-447-430550-938 OLD SCHOOL WELL FREQUENCY DRIVES 0 45,000 45,000 1000 5210-447-430550-940 MACHINERY & EQUIPMENT 0 32,400 32,400 1000 5210-447-430550-948 METERS (METER FUNDS) 010125 15,425 110,000 94,575 860 5210-447-430550-951 SECURITY SCADA UPGRADES 995 15,000 14,005 930 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 0 38,200 38,200 1000 5210-447-430550-959 PARKS METERING PHASE II 6,079 28,416 22,337 790 5210-447-430550-962 9TH AVE WEST WATER MAIN REPLACEMENT 0 625,000 625,000 1000 5210-447-430550-963 8TH STREET WEST WATER MAIN REPLACEM 0 416,000 416,000 1000 5210-447-430550-969 4TH AVE E MAIN REPL. PH. 1 1,744,422 1,962,538 218,116 11% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 320,254 320,254 1000 5210-447-430555-941 METERS (NEW SERVICES)010120 14,950 45,600 30,650 670 5210-447-430555-953 SECTION 36 WELL 144,652 961,746 817,094 850 SUBTOTAL WATER FACILITIES 2,883,734 6,668,065 3,784,331 570 WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 52,527 111,417 58,890 530 5210-447-430560-153 HEALTH INSURANCE 11,493 31,823 20,330 640 5210-447-430560-155 RETIREMENT 4,078 8,527 4,449 520 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 722 2,500 1,778 710 5210-447-430560-353 AUDITING 2,000 2,000 0 0% 5210-447-430560-354 CONTRACT SERVICES 1,961 45,000 43,039 960 5210-447-430560-355 BILLING COSTS 27,419 22,000 5,419- -250 5210-447-430560-356 BILLING COST/PRINTING 0 3,000 3,000 1000 5210-447-430560-373 DUES & TRAINING 1,032 2,500 1,468 590 5210-447-430560-522 ADMINISTRATIVE TRANSFER 5,725 11,451 5,726 500 5210-447-430560-528 DATA PROCESSING TRANSFER 14,598 33,000 18,402 560 5210-447-430560-532 RENT 6,422 6,422 0 0% SUBTOTAL WATER BILLING 127,977 279,640 151,663 540 REVENUE BONDS 5210-447-490204-610 BOND PRIN-HWY 93 S WTR-2004 0 70,000 70,000 1000 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 25,943 25,943 1 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.25o;WRF8114 0 192,810 192,810 1000 5210-447-490206-620 INT-MTR&WELL/WRF7104 1.25o;WRF8114 20,723 93,034 72,312 780 5210-447-490210-610 BOI 2003 PRINCIPAL (PHASE I) 101,000 0 101,000- 0% 5210-447-490210-620 BOI 2003 INTEREST (PHASE I) 49,696 0 49,696- 0% 5210-447-490250-610 PRIN-WTR MAIN/WRF1032R 20/IDAHO&MAI 0 48,000 48,000 1000 5210-447-490250-620 INT-WTR MAIN/WRF1032R 20/IDAHO&MAIN 3,240 3,240 0 0% SUBTOTAL REVENUE BONDS 200,951 433,377 232,426 540 DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 840,000 840,000 1000 SUBTOTAL DEPRECIATION 0 840,000 840, 000 1000 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 25 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING ACCOUNT NUMBER DESC. TOTAL WATER FUND 3,212,662 8,221,082 5,008,420 61% 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 26 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 675 0 675- 0% 5310-000-343310-000 SEWER SERVICE CHARGES 2,334,373 4,425,000 2,090,627 470 5310-000-343330-000 IMPACT FEES (SANITARY) 647,701 540,000 107,701- -200 5310-000-343335-000 IMPACT FEES (WWTP) 399,282 320,000 79,282- -250 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 310 10,000 9,690 970 5310-000-343365-000 LATECOMER ADMIN FEES 762 0 762- 0% 5310-000-371010-000 INVESTMENT EARNINGS 55,562 100,000 44,438 440 5310-000-381050-000 INCEPTION OF LEASE 0 7,873,808 7,873,808 1000 TOTAL SEWER REVENUE 3,438,665 13,268,808 9,830,143 740 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-354 BILLING COSTS/GRIZZLY SEC & POSTAGE 5310-454-430620-355 BILLING COSTS 5310-454-430620-356 BILLING COSTS/PRINTING 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 SUBTOTAL SEWER BILLING COSTS 44,290 94,168 49,878 530 8,768 25,275 16,507 650 3,433 7,190 3,757 520 722 2,500 1,778 710 2,000 2,000 0 00 1,961 45,000 43,039 960 27,419 22,000 5,419- -250 0 3,000 3,000 1000 1,077 2,500 1,423 570 5,258 10,516 5,258 500 14,598 33,000 18,402 560 6,422 6,422 0 0% 115,947 253,571 137,624 540 SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 118,703 252,466 133,763 530 5310-454-430630-121 OVERTIME 287 5,500 5,213 950 5310-454-430630-153 HEALTH INSURANCE 24,524 66,485 41,961 630 5310-454-430630-155 RETIREMENT 8,958 18,683 9,725 520 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 3,431 10,200 6,769 660 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 1,663 8,350 6,687 800 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 522 2,300 1,778 770 5310-454-430630-231 GAS & OIL 4,364 12,000 7,636 640 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 0 500 500 1000 5310-454-430630-341 ELECTRICITY 18,669 54,500 35,831 660 5310-454-430630-344 NATURAL GAS 5,511 16,500 10,989 670 5310-454-430630-345 TELEPHONE & COMMUNICATION 13,119 24,000 10,881 450 5310-454-430630-353 AUDITING 3,000 3,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 9,430 24,000 14,570 610 5310-454-430630-356 CONSULTANTS 0 258,000 258,000 1000 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 748 7,000 6,252 890 5310-454-430630-373 DUES & TRAINING 97 5,500 5,403 980 5310-454-430630-388 MEDICAL SERVICES 228 500 273 550 5310-454-430630-410 CONSTRUCTION MATERIALS 4,872 10,000 5,128 510 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 16,142 50,000 33,858 680 5310-454-430630-510 PROPERTY & LIABILITY INS. 17,457 18,419 962 50 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 16,900 25,000 8,100 320 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 27 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING 5310-454-430630-521 CENTRAL GARAGE TRANSFER 4,288 8,575 4,287 50% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 32,030 64,060 32,030 500 5310-454-430630-528 DATA PROCESSING TRANSFER 8,342 19,000 10,658 560 5310-454-430630-532 OFFICE RENT 6,422 6,422 0 0% 5310-454-430630-921 SAND/COLD MIX STORAGE SHED 14,227 15,325 1,098 70 5310-454-430630-940 MACHINERY & EQUIPMENT 0 92,400 92,400 1000 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 0 38,200 38,200 1000 5310-454-430630-954 GRANDVIEW L.S. RELOCATOIN & UPSIZE 0 230,000 230,000 1000 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 0 20,000 20,000 1000 5310-454-430630-959 2ND ALLEY E REPLACEMENT 0 558,000 558,000 1000 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 2,437 50,000 47,563 950 5310-454-430630-962 SEWER MAIN SLIP LINING 0 195,000 195,000 1000 SUBTOTAL SEWER COLLECTION 336,371 2,169,885 1,833,514 850 IMPACT FEES 5310-454-430635-954 GRANDVIEW L.S RELOCATION & UPSIZE 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 5310-454-430635-956 WEST SIDE INTERCEPTOR PHASE I 5310-454-430635-957 WEST SIDE INTERCEPTOR SUBTOTAL IMPACT FEE EXPENSE REVENUE BONDS/SANITARY 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.250 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.250 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.250 SUBTOTAL REVENUE BONDS DEPRECIATION -SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION -SANITARY 0 230,000 230,000 1000 0 200,000 200,000 1000 0 10,680,848 10,680,848 1000 402,492 1,755,101 1,352,609 770 402,492 12,865,949 12,463,457 970 0 83,000 83,000 1000 13,511 13,511 0- 0% 0 350 350 1000 13,511 96,861 83,350 860 0 820,000 820,000 1000 0 820,000 820,000 1000 SUBTOTAL SANITARY SEWER 752,374 15,952,695 15,200,321 950 WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 206,351 448,827 242,476 540 5310-455-430640-111 SEASONAL SALARIES 1,818 5,000 3,182 640 5310-455-430640-121 OVERTIME 10,870 22,500 11,630 520 5310-455-430640-153 HEALTH INSURANCE 35,453 89,216 53,764 600 5310-455-430640-155 RETIREMENT 16,390 32,959 16,569 500 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 840 10,000 9,160 920 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 357 2,700 2,343 870 5310-455-430640-225 ALUM 0 20,000 20,000 1000 5310-455-430640-226 CHLORINE & CHEMICALS 36,321 45,000 8,679 190 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 2,119 7,000 4,881 700 5310-455-430640-231 GAS & OIL 3,686 16,000 12,314 770 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 28 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 343 350 7 2% 5310-455-430640-336 LICENSES & FEES 0 10,000 10,000 1000 5310-455-430640-341 ELECTRICITY 71,511 180,000 108,489 600 5310-455-430640-342 WATER 1,731 7,500 5,769 770 5310-455-430640-344 NATURAL GAS 13,630 60,000 46,370 770 5310-455-430640-345 TELEPHONE & COMMUNICATION 2,890 6,500 3,610 560 5310-455-430640-353 AUDITING 4,000 4,000 0 0% 5310-455-430640-354 CONTRACT -GLACIER GOLD 56,812 124,000 67,188 540 5310-455-430640-355 OTHER CONTRACT SERVICES 17,987 30,000 12,013 400 5310-455-430640-356 CONSULTANTS 23,122 100,000 76,878 770 5310-455-430640-358 CONSULTANT-TMDL 632 125,000 124,368 990 5310-455-430640-360 MISC. MAINT SERVICES 7,558 30,000 22,442 750 5310-455-430640-366 BUILDING MAINTENANCE 26,843 50,000 23,157 460 5310-455-430640-373 DUES & TRAINING 2,319 7,500 5,182 690 5310-455-430640-388 MEDICAL SERVICES 268 500 232 460 5310-455-430640-510 PROPERTY & LIABILITY INS. 36,350 36,384 34 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 6,921 13,842 6,921 500 5310-455-430640-522 ADMINISTRATIVE TRANSFER 61,409 122,819 61,410 500 5310-455-430640-528 DATA PROCESSING TRANSFER 10,427 27,500 17,073 620 5310-455-430640-920 BUILDINGS 0 32,000 32,000 1000 5310-455-430640-940 COAT BASIN FY15; BOILER/HEAT EXCHAN 0 75,000 75,000 1000 SUBTOTAL WWTP OPERATIONS 658,959 1,742,097 1,083,138 620 WWTP BONDED PROJECT SUBTOTAL WWTP BONDED 0 0 0 0% WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 7,436 100,000 92,564 930 5310-455-430645-933 SOLIDS DEWATERING DESIGN & CONST. 89,000 98,462 9,462 100 5310-455-430645-934 SECONDARY DIGESTER LID INSPECTION 1,384 902,702 901,318 1000 5310-455-430645-937 SAND FILTER MAINT & REPLACEMENT 0 200,000 200,000 1000 5310-455-430645-940 MACHINERY & EQUIPMENT 67,948 307,828 239,880 780 SUBTOTAL WWTP REPLACEMENT 165,767 1,608,992 1,443,225 900 WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 51,297 108,136 56,839 530 5310-455-430646-121 OVERTIME 60 0 60- 0% 5310-455-430646-153 HEALTH INSURANCE 6,920 17,614 10,694 610 5310-455-430646-155 RETIREMENT 3,849 7,864 4,015 510 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 706 4,500 3,794 840 5310-455-430646-218 NON -CAPITAL EQUIPMENT 1,259 2,500 1,241 500 5310-455-430646-222 LAB SUPPLIES 8,169 14,500 6,331 440 5310-455-430646-349 LAB SERVICES 28,459 29,000 541 20 5310-455-430646-362 EQUIPMENT MAINTENANCE 3,774 5,500 1,726 310 5310-455-430646-373 DUES & TRAINING 734 3,700 2,966 800 SUBTOTAL WWTP LAB OPERATIONS 105,226 193,314 88,088 460 DEBT SERVICE - WWTP 5310-455-490227-610 PRIN-WWTP IMP/SRF8164R/2.250 0 814,000 814,000 1000 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 29 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING ACCOUNT NUMBER DESC. 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.250 198,394 198,394 0 0% 5310-455-490227-630 FISCAL AGENT FEES 0 350 350 1000 5310-455-490228-610 PRIN/WWTP DIGESTER LID/SRF13326/3.0 0 46,000 46,000 1000 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 27,315 27,315 0 0% SUBTOTAL DEBT SERVICE - WWTP CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-830 EVERGREEN REPLACEMENT TRANSFER 5310-455-510400-831 DEPRECIATION EXPENSE SUTOTAL WWTP DEPRECIATION/REPL SUBTOTAL WWTP TOTAL BILLING/SANITARY/WWTP 225,709 1,086,059 860,350 790 0 450,000 450,000 1000 0 1,425,000 1,425,000 1000 0 1,875,000 1,875,000 1000 1,155,661 6,505,462 5,349,801 820 2,023,983 22,711,728 20,687,745 910 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 30 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING ACCOUNT NUMBER DESC. STORM SEWER REVENUE 5399-000-323108-000 PW PLAN REVIEW FEES 675 0 675- 0% 5399-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 0 2,500 2,500 1000 5399-000-343033-000 IMPACT FEES 235,729 250,000 14,271 60 5399-000-343034-000 PERMIT FEES 1,100 0 1,100- 0% 5399-000-343035-000 STORM SEWER CHARGES 67 1,000 933 930 5399-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 1,332,945 1,275,000 57,995- -50 5399-000-363040-000 PEN & INT ON SPEC ASSESS. 1,374 1,200 179- -150 5399-000-371010-000 INTEREST ON INVESTMENTS 17,553 18,000 997 20 5399-000-381050-000 INCEPTION OF LEASE 0 99,213 99,213 1000 TOTAL STORM REVENUE 1,589,993 1,646,913 57,470 30 STORM SEWER 5399-953-430246-110 SALARIES -STORM SEWER 169,787 408,007 238,220 580 5399-953-430246-121 OVERTIME 568 4,000 3,432 860 5399-953-430246-153 HEALTH INSURANCE 31,829 98,404 66,575 680 5399-953-430246-155 RETIREMENT 12,869 30,228 17,359 570 5399-953-430246-210 OFFICE/COMPUTER SUPPLIES 7,736 12,100 4,364 360 5399-953-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 0 6,550 6,550 1000 5399-953-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 1000 5399-953-430246-231 GAS & OIL 3,742 11,500 7,758 670 5399-953-430246-345 TELEPHONE & COMMUNICATION 480 900 420 470 5399-953-430246-353 AUDITING 1,150 1,150 0 0% 5399-953-430246-359 CONTRACT SERVICE 4,528 6,000 1,472 250 5399-953-430246-356 STORMWATER REG COMPLIANCE PROGRAM 333 35,000 34,667 990 5399-953-430246-357 IMPACT FEE UPDATE 9,256 15,000 5,799 380 5399-953-430246-358 CONSULTANTS 6,954 7,000 96 to 5399-953-430246-359 CONSULTANTS-TMDL / PERMIT 5,172 15,000 9,828 660 5399-953-430246-360 REPAIR & MAINT SERVICES 0 2,500 2,500 1000 5399-953-430246-362 GROUNDWATER MONITORING 1,933 5,000 3,067 610 5399-953-430246-371 CURB & GUTTER 0 7,000 7,000 1000 5399-953-430246-373 DUES & TRAINING 729 5,500 4,771 870 5399-953-430246-388 MEDICAL SERVICES 0 100 100 1000 5399-953-430246-410 CONSTRUCTION MATERIALS 1,519 10,000 8,481 850 5399-953-430246-510 PROPERTY & LIABILITY INS. 3,576 9,000 5,424 600 5399-953-430246-521 CENTRAL GARAGE TRANSFER 4,288 8,575 4,287 500 5399-953-430246-522 ADMINISTRATIVE TRANSFER 22,175 99,350 22,175 500 5399-953-430246-528 DATA PROCESSING TRANSFER 8,342 13,000 4,658 360 5399-953-430246-530 BNSF LEASE PMT 4,588 5,900 1,313 220 5399-953-430246-532 OFFICE RENT 6,422 6,422 0 0% 5399-953-430246-610 PRINCIPAL 0 22,000 22,000 1000 5399-953-430246-620 INTEREST 0 8,000 8,000 1000 5399-953-430246-840 MACI GRANT MATCH FY18 CARRYOVER 0 43,000 43,000 1000 5399-953-430246-921 SAND/COLD MIX STORAGE SHED 14,227 15,325 1,098 70 5399-953-430246-951 9TH ST E STORMWATER IMPRV 0 250,000 250,000 1000 5399-953-430246-952 STORM DRAIN CORRECTION 0 100,000 100,000 1000 5399-953-430246-953 SHOP COMPLEX PAVEMNT 0 38,200 38,200 1000 5399-953-430246-955 SYLVAN DRIVE STORMWATER REPAIR 0 390,000 390,000 1000 5399-953-430246-968 9TH AVE EAST REPLACE - NON BONDED P 29,014 50,000 20,986 420 5399-953-430246-969 9TH AVE E REPLACE PHASE 1-9 62,772 99,213 36,991 370 5399-953-430248-960 STORMWATER FACILITY UPSIZE 0 230,000 230,000 1000 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 31 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING I REMAINING ACCOUNT NUMBER DESC. 5349-453-430249-940 MACHINERY FROM REPLACEMENT 0 92,400 92,400 100% 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 285,000 285,000 1000 TOTAL STORM 413,987 2,393,524 1,979,537 830 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 32 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 997,584 975,000 22,589- -20 5510-000-343420-000 GARBAGE COLLECTION -BILLED 22,837 25,000 2,163 90 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,213 2,100 887 420 5510-000-371010-000 INVESTMENT EARNINGS 4,942 8,000 3,058 380 TOTAL SOLID WASTE REVENUE 1,026,575 1,010,100 16,975- -20 SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 191,928 409,153 217,225 530 5510-460-430840-112 SEVERANCE -RETIREMENT 0 60,455 60,455 1000 5510-460-430840-121 OVERTIME 1,660 6,500 4,840 74% 5510-460-430840-153 HEALTH INSURANCE 37,384 96,542 59,158 610 5510-460-430840-155 RETIREMENT 14,415 30,045 15,630 520 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 1,948 9,500 7,552 790 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 23,036 37,500 14,464 390 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 1,107 5,500 4,393 800 5510-460-430840-231 GAS & OIL 19,806 55,000 35,194 64% 5510-460-430840-341 ELECTRICITY 519 2,050 1,531 750 5510-460-430840-399 NATURAL GAS 819 4,500 3,681 820 5510-460-430840-345 TELEPHONE & COMMUNICATION 477 1,250 773 620 5510-460-430840-354 CONTRACT SERVICES 7,263 11,500 4,237 370 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 86 5,700 5,614 980 5510-460-430840-366 BUILDING MAINTENANCE 0 4,500 4,500 1000 5510-460-430840-373 DUES & TRAINING 979 3,500 2,521 720 5510-460-430840-388 MEDICAL SERVICES 0 650 650 1000 5510-460-430840-510 PROPERTY & LIABILITY INS. 8,985 13,500 4,515 330 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 0 4,000 4,000 1000 5510-460-430840-521 CENTRAL GARAGE TRANSFER 34,893 69,786 34,893 500 5510-460-430840-522 ADMINISTRATIVE TRANSFER 21,624 43,247 21,623 500 5510-460-430840-528 DATA PROCESSING TRANSFER 6,256 12,513 6,257 500 5510-460-430840-532 OFFICE RENT 6,422 6,422 0 0% 5510-460-430840-610 DEBT SERVICE PRINCIPAL -GARBAGE TK 19,319 38,728 19,409 500 5510-460-430840-620 DEBT SERVICE INTEREST -GARBAGE TK 965 1,947 982 500 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 20,000 40,000 20,000 500 5510-460-430840-999 VEHICLES (Replacement $) 15,000 20,000 5,000 250 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 0 38,200 38,200 1000 5510-460-430845-229 JANITORIAL SUPPLIES 83 300 217 720 5510-460-430845-341 ELECTRICITY 652 3,500 2,848 810 5510-460-430845-342 WATER 231 2,000 1,769 880 5510-460-430845-399 NATURAL GAS 1,504 6,000 4,496 750 5510-460-430845-360 REPAIR & MAINT SERVICES 255 23,500 23,245 990 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 1000 TOTAL SOLID WASTE EXPENSE 437,617 1,217,488 779,871 64% 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 33 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 4,500 10,000 5,500 550 5160-000-343069-000 HANGER LEASES 5,500 12,000 6,500 54% 5160-000-343071-000 HANGAR SITE LEASES 19,057 18,035 1,022- -60 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 9,787 19,145 9,358 490 5160-000-343102-000 GROUND LEASES 14,002 13,594 908- -30 5160-000-343620-000 FUEL TAX 3,906 5,000 1,094 220 5160-000-371010-000 INVESTMENT EARNINGS 1,017 1,200 183 150 TOTAL AIRPORT REVENUE 57,770 78,974 21,204 270 5160 AIRPORT EXPENSES 5160-430-430310-210 OFFICE SUPPLIES & EQUIP 5160-430-430310-341 ELECTRICITY 5160-430-430310-354 CONTRACT SERVICES -LABOR & MATERIALS 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 5160-430-430310-362 REPAIR & MAINTENANCE 5160-430-430310-390 EQUIPMENT RENTAL 5160-430-430310-510 PROPERTY INSURANCE 5160-430-430310-522 ADMINISTRATIVE TRANSFER 5160-430-430310-528 DATA PROCESSING TRANSFER 5160-430-430310-820 DEPRECIATION TOTAL AIRPORT EXPENSES 0 1,000 1,000 1000 625 1,600 975 610 21,000 36,000 15,000 420 0 7,500 7,500 1000 0 10,000 10,000 1000 350 1,000 650 650 568 6,500 5,932 910 1,363 2,726 1,363 500 1,043 2,085 1,042 500 0 97,918 97,918 1000 24,948 166,329 141,381 850 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 34 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING INTERNAL SERVICE FUNDS INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 ENTITLEMENT SHARE PMT/HB124 102,500 205,000 102,500 500 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 40,016 173,000 132,984 770 6030-000-371010-000 INVESTMENT EARNINGS 728 1,100 372 340 6030-000-393000-000 INTERNAL SERVICES -DATA 117,828 235,655 117,827 500 TOTAL INFORMATION TECH REVENUE 261,072 614,755 353,683 580 INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 80,945 171,350 90,405 530 6030-401-410580-121 OVERTIME 0 1,000 1,000 1000 6030-401-410580-153 HEALTH INSURANCE 18,751 44,701 25,950 580 6030-401-410580-155 RETIREMENT 6,379 13,115 6,736 510 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 0 6,100 6,100 1000 6030-403-410580-215 COMPUTER SUPPLIES 411 2,400 1,989 830 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 17,533 24,000 6,467 270 6030-403-410580-325 WEBSITE 14,599 15,700 1,101 70 6030-403-410580-345 PAGER/PHONE 429 2,550 2,121 830 6030-403-410580-346 SUMMITNET & ISPS 4,567 14,000 9,433 670 6030-403-410580-353 LASER FICHE MAINTENANCE 3,432 3,500 68 20 6030-403-410580-354 MAINTENANCE CONTRACTS 3,107 5,000 1,893 380 6030-403-410580-355 LICENSES 7,694 18,850 11,156 590 6030-403-410580-356 MAINTENANCE CONTRACTS 17,140 44,000 26,861 610 6030-403-410580-357 GRANICUS 4,878 5,000 122 20 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 4,078 20,622 16,544 800 6030-403-410580-373 DUES & TRAINING 794 8,000 7,206 900 6030-403-410580-510 INSURANCE 1,469 3,000 1,531 510 6030-403-410583-218 TV -Video Equipment & programming 650 19,500 18,850 970 6030-403-410585-229 COPIER,FAX, SUPPLIES 4,109 19,490 15,381 790 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 37,073 78,000 40,927 520 6030-403-410585-532 COPIER LEASES 6,545 12,588 6,043 480 6030-403-410585-942 Servers - capital contingency 0 33,000 33,000 1000 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,000 5,000 1000 6030-404-410588-218 COMPUTERS - ATTORNEYS 456 4,100 3,644 890 6030-405-410588-940 COMPUTERS - SWITCHES 0 22,200 22,200 1000 6030-406-410580-218 COURT COMPUTERS (non -capital) 40 0 40- 0% 6030-410-410588-218 COMPUTERS - DPW 2,156 5,381 3,225 600 6030-413-410588-218 COMPUTERS - POLICE DEPT 955 37,760 36,805 970 6030-413-410588-354 POLICE - HOSTED SERVER 418 1,200 782 650 6030-416-410588-218 COMPUTERS - FIRE 0 8,164 8,164 1000 6030-420-410588-218 COMPUTERS - PLANNING DEPT 2,470 4,125 1,655 400 6030-436-410588-218 COMPUTERS - PARKS 300 4,885 4,585 940 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 2,315 2,315 1000 TOTAL INFORMATION TECH EXPENSE 241,378 660,596 419,218 630 01.11.2018 09:57 THE CITY OF KALISPELL, MONTANA Page 35 of 35 gb8501_pg.php/Job No: 71073 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU DECEMBER 31, 2017 50.00 % Yr Complete For Fiscal Year: 2018 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING I REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 248,036 495,000 246,964 500 6010-000-371010-000 INVESTMENT EARNINGS 498 200 298- -1490 TOTAL CENTRAL GARAGE REVENUE 248,534 495,200 246,666 500 CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 6010-410-431330-121 OVERTIME 6010-410-431330-153 HEALTH INSURANCE 6010-410-431330-155 RETIREMENT 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 6010-410-431330-230 OIL 6010-410-431330-231 GAS 6010-410-431330-232 VEHICLE PARTS 6010-410-431330-233 TIRES 6010-410-431330-238 FILTERS 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 6010-410-431330-341 ELECTRICITY 6010-410-431330-344 NATURAL GAS 6010-410-431330-354 CONTRACT SERVICES 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 6010-410-431330-373 DUES & TRAINING 6010-410-431330-388 MEDICAL SERVICES 6010-410-431330-510 INSURANCE 6010-410-431330-528 INFORMATION TECH TRANSFER 6010-410-431330-944 VEHICLE -SERVICE TRUCK TOTAL CENTRAL GARAGE EXPENSES 66,053 162,760 96,707 590 1,563 2,500 937 370 11,824 38,931 27,107 700 4,744 11,880 7,136 600 513 10,000 9,487 950 2,127 10,700 8,573 800 6,567 25,000 18,433 740 130 2,500 2,370 950 48,244 112,000 63,756 570 18,791 41,000 22,209 540 3,135 8,500 5,365 630 147 2,000 1,853 930 633 1,950 1,317 680 1,316 6,000 4,684 780 17,827 26,000 8,173 310 1,000 2,000 1,000 500 50 6,200 6,150 990 356 300 56- -190 1,949 4,000 2,051 510 4,171 8,342 4,171 500 7,020 10,000 2,980 300 198,161 492,563 294,402 600 'otmmm�m '0tmmm0� 10901110 'memm0m� 11111111 o�moommm 11110111 11911910 om0o�mom 1911101191 e�'mv�me'm 0�m�momee� m�o�moevo� o�'moomm'o ��m�mo�mmm 1�11111111 m�ommmoe'� 0�m�m�o�om m�'mm'mm'm 1011110110 oao��o��00 v�o�amoto� m�ommooee� m�m��m000� 11111111110■1111 0o��o�m0��m�mo�o "m�o�m'mmm■vmm� 00��o00am�m■mo�� 0o��m�moe�a■mm�� nm�'m0'mma■m��e 91111�@9190■191� oo��o�a0m�o■oo�e 11111111111■1111 �����veo�me■om�� "m�oomeov�■m0'� ������vao�a■omoe oo��o�mam��■mm�� nma'em'mmm■mo�a oo��o�mam�m■o��e 01111111119■1110 0o�0o�a0o�m■oo�� "m�o�m'omm■mo0�