The URL can be used to link to this page

04-14-17 City Manager ReportC'ITi' OF K ,,,. _ =-� -a"sCity of Kalispell ��,,r_ �� OFFICE OF THE CITY MANAGER ,1IONTANA Information Memorandum 4/14/2017 1. Information Services IT staff reviewed competitive quotes for the web conferencing system, ordered computers, and collected quotes for an offsite servicer to host critical backups for the courts. Rugged laptops were removed in the ambulances and replaced with tablets that are able to be used on scene, in and out of the vehicles, and in the stations. Information Services has configured the existing financial management to create electronic purchase orders. 2. Fire Department Since the last update for service, the Kalispell Fire Department has received 149 calls for service and has conducted 1 outreach training with 35 individuals in attendance. In addition to the outreach training, fire department staff had the opportunity to conduct hazardous materials awareness training for Kalispell Police Department personnel. This training covered how to identify and properly respond to not only hazardous materials releases they may encounter, but also other situations in the normal day of public safety operations. Fire department staff continue efforts in recognizing the target hazard buildings located within the City of Kalispell and are creating or updating our pre -plans for emergency response. This continues throughout the year and plans are updated as needed, or as new hazards are recognized. Open burning period is upon us. However, there continues to be no open burning in the city limits of Kalispell. Recreational or warming fires are still allowed. 3. Public Works 2017 Street and Alley Restoration Projects Annually, the Street Department performs pavement restoration projects. The restoration consists of asphalt milling and overlay of streets and alleys, major patching, and crack sealing. The projects and activities are prioritized each year based on pavement conditions and budgets. Streets and alleys slated for in-house restoration projects for 2017 construction season and the tentative weekly schedules are listed below: Week of April 10 April 17 April 24 May 4, May 8 May 15 May 22 May 29, June 5 June 12 June 19 June 26, July 3 July 10, July 17 July 24 July 31, August 7 August 14 August 21, August 28 September 4 September 11 September 18 Location Restoration Projects City Patching/Street Maint. Stillwater Road from Timberwolf Parkway to Four Mile Dr. Patching and Overlay Stillwater Road from Three Mile Dr. to Park Ridge Dr. Patching and Overlay 10th Street East between 1st and 2nd Ave East Stillwater Road Citv Street Reconstruction Major Patching Patching/Street Maint. Mill and Overla Center Street from Main Street to 2nd Alley East Patching y, Minor North West Lane from Three Mile Drive to middle school. Mill and Overlay Citv i Patching/Street Maint. City East Washington from Main Street to 8th Ave. EN City East Nevada from Main Street to 3rd Ave EN City West Arizona from Highway 93 to end Second Ave EN from Idaho to Oregon Street City Fifth Ave. EN from Idaho to East California Crack Seal /Street Maint. Mill and Overlay Patching/Street Maint. Street Reconstruction, Mill and Overlay Patching/Street Maint. Mill and Overlay Mill and Overlay Patching/Street Maint. Mill and Overlay Alley Paving. • 6th Alley East— 1300 block September • 25 7th Alley East - 800 block, 1200 block, and 1300 Alley Paving block • 8th Alley West- 500 block, 600 block, 700 block Notes Utility and Misc. 6,400 feet lineal total 1 block Prep for Chip Seal Utility and Misc. MMM 1.5 blocks 1,375 lineal feet Utilitv and Misc. 8 blocks Utility and Misc. 4.5 blocks Utility and Misc. 5 blocks 2 blocks Utility and Misc. 3 blocks Filler task during patching and maintenance if time permits All schedules and projects are subject to change based on weather, work load, and any unforeseeable incidents that may occur. Noffisinger Generator Replacement Project Water Production staff is nearing Y •: • s:r completion of the Noffsinger Generator r Replacement Project. This the generator has been installed within the newly I ailcompleted enclosure. Task items remaining are natural gas installation, electrical connections, and start-up. All task items to date were overseen or 2 completed by in-house staff to ensure budget efficiencies. Seventy-five percent of the project costs for the generator enclosure, installation and startup are covered by a Hazard Mitigation Project Grant from FEMA. 4. Parks and Recreation Light conversions from fluorescent bulbs to LED's at City Hall are now complete. This upgrade is projected to realize $1,700 in annual energy savings. Following a lengthy winter, start up at Kalispell Youth Athletic Complex has required a quick turnaround to accommodate user group's spring schedules. Park staff have bathrooms operating and have begun thatching softball and baseball fields. As part of the Spring Prairie Phase IV development, a trail connecting the retail shopping center to KYAC has been graded. Along with the trail construction, the developer will be adding two gazebos, two 20' X 24' shelters, and a concrete patio area for additional picnic tables. "May the Forest Be with You" is the theme of this year's Arbor Day celebration. Arbor day will be held at KYAC on April 28. Sixteen businesses and organizations have sponsored this year's event. Another seventeen companies and organizations have agreed to host educational booths throughout the day for all School District #5 3rd Graders. Additionally, we will have several adult volunteers planting approximately 20 trees at the complex throughout the day. The wind storm on April 7, caused several trees and branches to blow down. Wind gusts were measured at 40 mph. KPR is busy preparing for our Summer Day Camp. Registration will open on April 19. We have a full schedule of field trips lined up for the summer, including: visiting Glacier National Park, Lake Five, the Whitefish Mountain Resort, and Big Sky Water Slides. Summer Day Camp will run from June 12 through August 18. 7� KPR's new activity guide (May 2017 to October 2017) will be published in the Daily Interlake on April 24. KPR will be introducing several new programs and camps this summer. We are partnering with Resound! School of Music and Theatre to offer three, week-long music camps (Guitar Jam Camp, Performing Arts Exploration Camp, and 3 Orchestra "Boot Camp"). We are also partnering with the Hockaday Museum of Art to offer two new week-long art camps in July for 2nd-6th graders. Finally, we will be offering a new "Zombie" Camp that will run the final week of summer break. 5. Community Development Kalispell was awarded a technical assistance grant through the national brownfields program and had a team of experts in areas of urban design, and rails to trails tour Kalispell's Core Area and meet with staff regarding the Kalispell TIGER project. A working lunch was sponsored by Glacier Bank during which community stakeholders discussed priorities for the trail development. The team will compile the input gathered and correlate that with a mapping of the trail portion of the TIGER project. 6. Building Department Two single family building permits were issued in the past 2 weeks. This brings the total for the year to 20, compared to last year at this time when 25 residential building permits had been issued. Two commercial permits have been issued; one for the new McDonalds Restaurant located at 1110 Hwy 2 West valued at $815,000, and another for the new sports bar Rivals (formerly known as Tree Frog) located at 1250 Hwy 2 West, valued at $50,000. In addition, preliminary plans were submitted for review for the new Elementary School to be located at 2155 Airport Road. The 56,000 square foot school has a preliminary construction value of $10.6 million. 7. Planning Department The Kalispell Planning Board met on April 11 and held hearings on 6 separate projects. The Board recommended approval of: • A request from Kalispell Meeting Halls to amend the Kalispell zoning ordinance to allow private schools as a conditional use permit in commercial zones; • A request form Northwest Automotive for a conditional use permit to operate an auto repair facility at 20 Second Ave East in a building recently used by Centurylink as a maintenance shop; • A request for a conditional use permit by LV Enterprises to operate an accessory casino within the B-2 Zoning District in the rear of the Casa Mexico Restaurant at 1600 Highway 93 South; • A request from AMI Development and DNRC for a for a 6 lot commercial subdivision on 6.8 acres located within DNRC Section 36 on the southeast corner of Old West Reserve and the Highway 93 Bypass route; and • A request by Spartan Holdings, LLC for annexation, a growth policy amendment to mixed use, initial zoning of B-2 and RA-2, and a PUD placeholder overlay on 56 acres of land located on Highway 93 North immediately west of the MDT 11 maintenance yard and future Rose Crossing intersection. The planning department also purchased a software program that will be used to identify properties within the city that are advertising for short term rentals. The staff will then contact those properties and begin the process of helping them get licensed under the new short term rental ordinance. 8. Police Department Assistant Fire Chief Jon Campbell provided officers of the Kalispell Police Department with training in multiple hazards that we come in contact with. The two hour classes touched on many hazards such as: transported chemical hazards, suspicious packages, and fire dangers. Officer Jason Parce and our K9 unit, Cairo, continue to do numerous community presentations to schools and civic groups. Officer Parce recently attended a three day K9 Liability Course in Missoula. Attached, please see the latest case and arrest report. 9. Finance Department Quarterly Finance Report Please find attached, the printouts reflecting the activity for the nine months ended March 31, of fiscal year 2017. All funds are included with the exception of the debt service funds. REVENUES: General F»nd General Fund revenue reflects taxes collected thru March 31. The general fund received an additional $806,953 of first half taxes in the third quarter bringing collections to $3,037,103 (55%) of the budgeted annual amount ($5,490,000). Real property tax collections for the 4th quarter of fiscal year 2017 are expected to be near $2.5 million and more than adequate to fulfill the budgeted amount. The general fund is now carrying $15,548 in protested taxes. City court fines and fees continue to decline, down 21 % from the first three quarters of fiscal year 16 ($296,423). This is a continuing trend beginning in fiscal year 2015 when this revenue declined 7% from the prior fiscal period ($474,141). In fiscal year 2016, the decline was another 9% (435,668). Parks Parks revenues are at 57% of the fiscal year 2017 budget, compared to 53% for the same period last fiscal year. Typically, a substantial portion of parks charges for services are received in the final quarter of the fiscal year. The final quarter of fiscal year 2016 accounted for 46% of the department's annual revenue. A similar quarter this fiscal year should put annual revenues at or near the budgeted amount. Amh»1nnr.P Ambulance fees for services are up about 13 % compared to March 31 of fiscal year 16. At the current pace, fees will fall short of the budgeted amount of $891,000 by approximately 20%. Building Department Revenue is already 210% of the annual budget. Building permits are nearly double the budgeted amount of $350,000, and plan review fees are nearly 3.5 times the budgeted amount of $100,000. Water Metered water sales thru March were $2,335,089, this is 82% of the budgeted amount, but is a decrease of 13 % from last fiscal year. Year-end metered water sales are expected to exceed 105% of the budgeted amount. Water impact fees are up about $50,000 from the same time period last fiscal year. Sewer Sewer service charges are $3,342,482, or about 76% of the budgeted amount. Last year's sewer service charges for the same period were $3,569,888. This decrease is the result of the hot and dry first quarter of fiscal year 16. Sanitary sewer and treatment plant impact fees have both exceeded the anticipated total fiscal year 2017 amount by 167% and 59%, respectively. EXPENDITURES/EXPENSES : For most funds, expenditures/expenses include the 19th (of 26) payroll period ending March 18. Most departments and/or funds have at least 29% remaining in the salaries and retirement lines which should be adequate. An exception is the fire department and ambulance fund where the majority of the employees are paid 13 times annually. For fire and ambulance, this report includes the 9th (of 13) pay period ending March 4. Fire and ambulance should have at least 3 3 % remaining to adequately cover the remaining 4 pay periods. All departments, including fire and ambulance, should have about 34% remaining in the health insurance expenditure line to adequately cover the remainder of this fiscal year. With a few exceptions, administrative, central garage, and information technology transfers are done monthly and should show 25 % 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 also generally done monthly and should show 25% remaining. T 04.11.2017 12:49 gb8501_pg.php/Job No: 53198 THE CITY OF KALISPELL, MONTANA FY17 FINANCIAL REPORT JULY 19 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 Page 1 of 33 USER: RGW G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 3,037,103 5,490,000 2,452,897 45% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 8,626 17,000 8,374 49% 1000-000-311200-000 PERSONAL PROPERTY TAXES 136,776 120,000 16,776- -14% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 5,489 8,000 2,511 31% 1000-000-322101-000 LIQUOR LICENSES 27 30,000 29,973 100% 1000-000-322300-000 BUSINESS LICENSES 1,470 1,700 230 14% 1000-000-323012-000 PLANNING FEES 50,299 30,000 20,299- -68% 1000-000-323109-000 SITE REVIEW 11,564 14,000 2,436 17% 1000-000-323200-000 PARADE PERMITS 550 1,000 450 45% 1000-000-335030-000 M.V. TAX - AD VALOREM 1,263 2,000 737 37% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 57,350 60,000 2,650 4% 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,000 2,000 1,000 50% 1000-000-335230-000 HB124 ENTITLEMENT 2,080,371 2,773,829 693,458 25% 1000-000-341020-000 ADMINISTRATIVE CHARGES 433,351 574,367 141,016 25% 1000-000-341021-000 GRANT ADMIN FEES 0 5,000 5,000 100% 1000-000-341025-000 CITY COLLECTIONS 314 5,000 4,686 94% 1000-000-342010-000 POLICE SERVICES 28,698 25,000 3,698- -15% 1000-000-342014-000 RESOURCE OFFICERS 149,037 149,037 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 1,031 10,000 8,969 90% 1000-000-343018-000 PARKING PERMITS 73,781 95,000 21,219 22% 1000-000-351000-000 CITY COURT FINES & FEES 236,325 500,000 263,675 53% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 14,832 30,000 15,168 51% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 27,027 35,000 7,973 23% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 31,969 20,000 11,969- -60% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 1,672 7,500 5,828 78% 1000-000-371010-000 INVESTMENT EARNINGS 14,842 15,000 158 1% 1000-000-373030-000 INTEREST ON OLD SCHOOL SID LOAN - 1 0 16,250 16,250 100% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 450,500 901,000 450,500 50% TOTAL GENERAL FUND REVENUE ------------ 6,855,268 ------------- 10,937,683 ------------ 4,082,415 ------------ 37% 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 2 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 2,935 2,935 0 0% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 14,250 14,250 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 1,678 4,000 2,322 58% 1000-400-410560-312 POSTAGE 9,609 16,000 6,391 40% 1000-400-410560-320 PRINTING & ENVELOPES 2,169 4,500 2,331 52% 1000-400-410560-354 CONTRACT SERVICES - DOC SHREDDING 123 500 378 76% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 1,222 4,000 2,778 69% 1000-400-420000-354 CONTRACT 911 CENTER 354,603 483,000 128,397 27% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 378 425 47 11% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 15,000 15,000 0 0% 1000-400-460452-366 HOCKADAY MAINTENANCE 6,600 6,600 0 0% 1000-400-510300-000 CONTINGENCY 882 30,000 29,118 97% 1000-400-510310-354 ICMA PLAN FEES 375 500 125 25% 1000-400-510330-513 LIABILITY INSURANCE 61,925 61,925 0 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 20,032 50,000 29,968 60% 1000-400-510330-517 PROPERTY INSURANCE 49,965 ------------ 49,965 ------------- 0 ------------ 0% ------------ SUBTOTAL GEN.GOV'T. CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 1000-401-410210-153 HEALTH INSURANCE 1000-401-410210-155 RETIREMENT 1000-401-410210-210 COMPUTER SOFTWARE/SUPPLIES 1000-401-410210-312 NEWSLETTER/BOOKS 1000-401-410210-345 TELEPHONE & COMMUNICATION 1000-401-410210-373 DUES & TRAINING 1000-401-410210-379 MEETINGS SUBTOTAL CITY MANAGER HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 1000-401-410830-153 HEALTH INSURANCE 1000-401-410830-155 RETIREMENT 1000-401-410830-210 OFFICE SUPPLIES 1000-401-410830-338 RECRUITMENT/RELOCATION 1000-401-410830-354 CONTRACT SERVICES 1000-401-410830-373 DUES & TRAINING SUBTOTAL HUMAN RESOURCES 541,745 743,600 201,855 27% 95,544 137,795 42,251 31% 14,968 22,706 7,738 34% 10,257 14,569 4,312 30% 0 1,500 1,500 100% 0 400 400 100% 640 1,080 440 41% 3,894 8,300 4,406 53% 3,763 ------------------------- 3,400 ------------ 363- ------------ -11% 129, 066 189, 750 60, 684 32% 87,169 123, 814 36, 645 30% 12,863 19,565 6,702 34% 6,746 9, 466 2,720 29% 387 600 213 36% 3,322 8, 000 4, 678 58% 440 1,000 560 56% 5, 916 6,000 84 1 % ------------------------- 116, 843 ------------ 168, 445 ------------ 51, 602 31% 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 3 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING a REMAINING ACCOUNT NUMBER DESC. MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 44,896 63,107 18,211 29% 1000-402-410100-153 HEALTH INSURANCE 38,080 57,698 19,618 34% 1000-402-410100-155 RETIREMENT 1,781 2,445 664 27% 1000-402-410100-210 OFFICE SUPPLIES 0 100 100 100% 1000-402-410100-335 MT LEAGUE OF CITIES 2,145 5,760 3,615 63% 1000-402-410100-354 CONTRACT SERVICES 2,245 4,500 2,255 50% 1000-402-410100-373 DUES & TRAINING 6,576 6,000 576- -10% 1000-402-410100-379 MEETINGS 6,353 8,000 1,647 21% SUBTOTAL MAYOR/COUNCIL ------------------------- 102,076 ------------ 147,610 ------------ 45,534 31% CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 62,430 88,953 26,523 30% 1000-402-410150-121 OVERTIME 0 250 250 100% 1000-402-410150-153 HEALTH INSURANCE 13,275 20,261 6,986 34% 1000-402-410150-155 RETIREMENT 4,842 6,832 1,990 29% 1000-402-410150-210 OFFICE SUPPLIES 0 200 200 100% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 0 700 700 100% 1000-402-410150-345 TELEPHONE & COMMUNICATION 320 480 160 33% 1000-402-410150-352 RECODIFICATION 3,554 3,700 146 4% 1000-402-410150-354 CONTRACT SERVICES 0 300 300 100% 1000-402-410150-373 DUES & TRAINING 1,522 3,200 1,678 52% SUBTOTAL CITY CLERK ------------------------- 85,942 ------------ 124,876 ------------ 38,934 31% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 146,425 210,200 63,775 30% 1000-403-410550-153 HEALTH INSURANCE 26,268 38,445 12,177 32% 1000-403-410550-155 RETIREMENT 11,332 16,121 4,789 30% 1000-403-410550-210 SUPPLIES 190 300 110 37% 1000-403-410550-322 BOOKS 0 250 250 100% 1000-403-410550-353 CONTRACT SERVICES 120 2,000 1,880 94% 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 1,277 2,000 723 36% 1000-403-410550-355 BANK CHARGES & FEES 2,110 3,500 1,390 40% 1000-403-410550-373 DUES & TRAINING 3,103 6,500 3,397 52% SUBTOTAL FINANCE ------------------------- 190,825 ------------ 279,316 ------------ 88,491 32% 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 4 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 257,143 364,724 107,581 300 1000-404-411110-153 HEALTH INSURANCE 34,580 52,592 18,012 340 1000-404-411110-155 RETIREMENT 19,884 29,906 10,022 340 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 701 2,500 1,799 720 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 6,706 8,000 1,294 160 1000-404-411110-345 TELEPHONE & COMMUNICATION 707 1,000 293 290 1000-404-411110-354 CONTRACT SERVICES 177 5,000 4,823 960 1000-404-411110-373 DUES & TRAINING 4,889 7,000 2,111 300 SUBTOTAL CITY ATTORNEY ------------------------- 324,788 470,722 ------------------------ 145,934 310 MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 156,939 226,938 69,999 310 1000-406-410360-121 OVERTIME 411 0 411- 0% 1000-406-410360-153 HEALTH INSURANCE 30,969 51,568 20,599 400 1000-406-410360-155 RETIREMENT 12,156 17,373 5,217 300 1000-406-410360-210 SUPPLIES 1,866 4,500 2,634 590 1000-406-410360-320 PRINTING/BOOKS 228 1,500 1,272 850 1000-406-410360-345 TELEPHONE & COMMUNICATION 62 1,400 1,338 960 1000-406-410360-353 SECURITY & TECHNOLOGY 4,831 40,000 35,169 880 1000-406-410360-354 CONTRACT SERVICES 9,891 5,750 4,141- -720 1000-406-410360-373 DUES & TRAINING 1,840 6,300 4,460 710 1000-406-410360-394 JURY & WITNESS FEES 1,873 7,500 5,627 750 SUBTOTAL COURT ------------------------- 221,066 362,829 ------------------------ 141,763 390 PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 12,293 17,333 5,040 290 1000-410-430100-153 HEALTH INSURANCE 2,088 3,278 1,190 360 1000-410-430100-155 RETIREMENT 940 1,300 360 280 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 4,598 7,500 2,902 390 1000-410-430100-231 GAS 1,794 2,500 706 280 1000-410-430100-345 TELEPHONE & COMMUNICATION 206 300 94 310 1000-410-430100-354 CONTRACT SERVICES 1,680 1,850 170 90 1000-410-430100-373 DUES & TRAINING 1,360 2,500 1,140 460 1000-410-430100-521 CENTRAL GARAGE TRANSFER 2,594 3,459 865 250 SUBTOTAL PUBLIC WORKS ADMIN ------------------------- 27,553 40,020 ------------------------ 12,467 310 CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 46,919 67,873 20,954 310 1000-412-411230-121 OVERTIME 514 0 514- 0% 1000-412-411230-153 HEALTH INSURANCE 8,794 15,847 7,053 450 1000-412-411230-155 RETIREMENT 3,533 4,980 1,447 290 1000-412-411230-220 SECURITY IMPROVEMENTS 0 800 800 1000 1000-412-411230-224 JANITORIAL SUPPLIES 2,468 6,000 3,532 590 1000-412-411230-241 TOOLS & SUPPLIES 373 1,500 1,127 750 1000-412-411230-341 ELECTRICITY 31,709 47,500 15,791 330 1000-412-411230-344 NATURAL GAS 22,624 40,000 17,376 430 1000-412-411230-345 TELEPHONE & COMMUNICATION 95 250 155 620 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 5 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING a REMAINING 1000-412-411230-354 CONTRACT SERVICES 6,981 38,500 31,519 820 1000-412-411230-355 HVAC MAINTENANCE OCNTRACT 15,146 17,300 2,154 120 1000-412-411230-361 ELEVATOR MAINT/ FIRE ALARM MAINT 4,160 4,500 340 80 1000-412-411230-362 EQUIPMENT MAINTENANCE 1,718 8,500 6,782 800 1000-412-411230-366 BUILDING MAINTENANCE 19,523 20,000 477 20 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,228 3,500 272 80 1000-412-411230-920 Public Safety Bldg - painting 12,303 ------------ 30,000 ------------- 17,697 ------------ 590 ------------ SUBTOTAL CITY HALL 180,088 307,050 126,962 410 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 194,041 274,862 80,821 290 1000-420-411020-153 HEALTH INSURANCE 37,433 59,495 22,062 370 1000-420-411020-155 RETIREMENT 15,026 21,071 6,045 290 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 370 5,000 4,630 930 1000-420-411020-231 GAS 78 400 322 810 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 708 2,000 1,292 650 1000-420-411020-345 TELEPHONE 788 750 38- -50 1000-420-411020-354 CONTRACT SERVICES 0 1,000 1,000 1000 1000-420-411020-373 DUES & TRAINING 1,209 5,500 4,291 780 1000-420-411020-521 CENTRAL GARAGE TRANSFER 971 1,295 324 250 SUBTOTAL PLANNING DEPT. ------------------------- 250,625 371,373 ------------------------ 120,748 330 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 43,553 61,676 18,123 290 1000-480-470210-153 HEALTH INSURANCE 5,440 8,243 2,803 340 1000-480-470210-155 RETIREMENT 3,366 4,704 1,338 280 1000-480-470210-210 OFFICE SUPPLIES 23 1,500 1,477 980 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 294 500 206 410 1000-480-470210-312 POSTAGE & PRINTING 49 500 451 900 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 500 500 0 0% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 469 750 281 380 1000-480-470210-354 CONTRACT SERVICES 265 1,500 1,235 820 1000-480-470210-373 DUES & TRAINING 3,670 5,000 1,330 270 1000-480-470210-379 MEETINGS 220 1,000 780 780 SUBTOTAL COMMUNITY DEVELOPMENT ------------------------- 57,848 85,873 ------------------------ 28,025 330 THE CITY OF KALISPELL, MONTANA 04.11.2017 12:49 Page 6 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 11 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 1,504,663 2,114,612 609,949 290 1000-413-420140-112 SALARIES -SEVERANCE 31,782 33,500 1,718 50 1000-413-420140-114 SALARY-comptime buyout 4,445 4,350 95- -20 1000-413-420140-121 OVERTIME (REG & AET OT) 50,056 80,000 29,944 370 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 3,266 25,000 21,734 870 1000-413-420140-153 HEALTH INSURANCE 277,834 413,628 135,794 330 1000-413-420140-155 RETIREMENT 194,327 275,152 80,825 290 1000-413-420140-210 OFFICE SUPPLIES 2,783 3,500 717 200 1000-413-420140-215 COMPUTER SUPPLIES 1,687 5,500 3,813 690 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 40,423 48,500 8,077 170 1000-413-420140-220 INVESTIGATIVE SUPPLIES 1,982 4,000 2,018 500 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 6,512 7,000 488 70 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 932 2,000 1,068 530 1000-413-420140-226 SRT SUPPORT/SUPPLIES 4,542 5,000 458 90 1000-413-420140-227 AMMO & RELATED SUPPLIES 10,917 19,000 8,083 430 1000-413-420140-228 PATROL CAR SUPPLIES 3,791 13,000 9,209 710 1000-413-420140-229 OTHER SUPPLIES 7,578 10,000 2,422 240 1000-413-420140-230 CRIME PREVENTION SUPPLIES 904 1,000 96 100 1000-413-420140-231 GAS 40,930 95,000 54,070 570 1000-413-420140-234 CRISIS NEGOTIATIONS 2,012 2,000 12- _1% 1000-413-420140-235 BIKE PATROL 244 750 506 670 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 280 1,500 1,220 810 1000-413-420140-320 PRINTING 2,288 5,500 3,212 580 1000-413-420140-345 TELEPHONE & COMMUNICATION 12,923 15,500 2,577 170 1000-413-420140-354 CONTRACT SERVICES 6,035 6,875 840 120 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 3,742 6,500 2,758 420 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 167 2,000 1,833 920 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 2,258 2,000 258- -130 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 38,235 40,625 2,390 60 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 1,083 2,500 1,417 570 1000-413-420140-373 DUES & TRAINING 25,315 30,000 4,685 160 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 1,031 10,000 8,969 900 1000-413-420140-380 TRAINING MATERIALS 69 2,000 1,931 970 1000-413-420140-388 MEDICAL SERVICES 1,965 2,500 535 210 1000-413-420140-392 BOARDING/TREATING PRISONERS 2,055 2,500 445 180 1000-413-420140-521 CENTRAL GARAGE TRANSFER 55,288 73,718 18,430 250 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 50,625 67,500 16,875 250 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 116,250 155,000 38,750 250 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 2,625 3,500 875 250 1000-413-420140-922 USFS PROPERTY ACQUISITION 0 27,482 27,482 1000 1000-413-420140-944 VEHICLES 143,575 115,878 27,697- -240 SUBTOTAL POLICE DEPT. ------------ 2,657,420 ------------- 3,735,570 ------------ 1,078,150 ------------ 290 DETECTIVES 1000-413-420141-110 SALARIES -DETECTIVES 249,954 365,552 115,598 320 1000-413-420141-121 DETECTIVE -OVERTIME 5,278 15,000 9,722 650 1000-413-420141-153 HEALTH INSURANCE 47,505 66,611 19,106 290 1000-413-420141-155 DETECTIVE -RETIREMENT 32,805 48,938 16,133 330 TOTAL DETECTIVES ------------ 335,542 ------------- 496,101 ------------ 160,559 ------------ 320 RECORDS 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 7 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-110 SALARIES -RECORDS DIVISION 99,274 142,039 42,765 300 1000-413-420142-121 OVERTIME 2,025 7,500 5,475 730 1000-413-420142-153 HEALTH INSURANCE 21,461 32,970 11,509 350 1000-413-420142-155 RETIREMENT 7,743 10,720 2,977 280 1000-413-420142-215 COMPUTER SUPPLIES 216 0 216- 0% TOTAL RECORDS ------------ 130,718 ------------- 193,229 ------------ 62,511 ------------ 320 RESOURCE OFFICERS 1000-413-420144-110 SALARIES -SRO 127,372 182,257 54,885 300 1000-413-420144-153 HEALTH INSURANCE 24,099 46,773 22,674 480 1000-413-420144-155 SRO RETIREMENT 15,431 24,447 9,016 370 TOTAL RESOURCE OFFICERS ------------ 166,902 ------------- 253,477 ------------------------ 86,575 340 ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL -SALARIES 29,436 38,723 9,287 240 1000-413-420145-121 OVERTIME 0 500 500 1000 1000-413-420145-153 HEALTH INSURANCE 5,440 8,243 2,803 340 1000-413-420145-155 RETIREMENT 2,142 2,920 778 270 SUBTOTAL ANIMAL CONTROL ------------ 37,018 ------------- 50,386 ------------------------ 13,368 270 PARKING 1000-413-420147-110 PARKINGS -SALARIES 62,286 86,114 23,828 280 1000-413-420147-153 HEALTH INSURANCE 16,920 30,585 13,665 450 1000-413-420147-155 RETIREMENT 4,684 6,494 1,810 280 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 578 4,000 3,422 860 1000-413-420147-354 CONTRACTED SERVICES 1,764 2,000 236 120 1000-413-420147-362 LOT MAINT 3,726 10,000 6,274 630 1000-413-420147-365 SNOW REMOVAL -Parking Lots 15,325 17,500 2,175 120 1000-413-420147-550 LOT LEASE PAYMENTS 1,110 1,500 390 260 SUBTOTAL PARKING ------------ 106,394 ------------- 158,193 ------------------------ 51,799 330 SUBTOTAL POLICE DEPT. ------------ 3,433, 995 ------------- 4,886, 956 ------------------------ 1,452, 961 30 0 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 8 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. FIRE DEPARTMENT 1000-416-420400-110 SALARIES -FIRE SUPPRESSION 1,104,025 1,592,324 488,299 310 1000-416-420400-114 COMPTIME BUYOUT 3,784 5,500 1,716 310 1000-416-420400-115 OUT OF RANK PAY 8,956 12,000 3,044 250 1000-416-420400-121 OVERTIME 40,512 40,000 512- -10 1000-416-420400-153 HEALTH INSURANCE 194,385 312,701 118,316 380 1000-416-420400-155 RETIREMENT 145,595 212,650 67,055 320 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 577 2,000 1,423 710 1000-416-420400-218 Equipment (Non Capital) 2,955 21,500 18,545 860 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 14,658 15,000 342 20 1000-416-420400-224 JANITORIAL SUPPLIES 2,313 5,000 2,687 540 1000-416-420400-231 GAS 5,943 17,325 11,382 660 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 8,245 15,000 6,755 450 1000-416-420400-320 PRINTING 0 200 200 1000 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 275 1,000 725 730 1000-416-420400-345 TELEPHONE & COMMUNICATION 3,258 6,000 2,742 460 1000-416-420400-354 CONTRACT SERVICES 9,857 12,000 2,143 180 1000-416-420400-362 EQUIPMENT MAINTENANCE 5,862 5,500 362- -70 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 7,477 7,500 23 0% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 3,836 5,000 1,164 230 1000-416-420400-373 DUES & TRAINING 3,219 10,000 6,781 680 1000-416-420400-388 FIREFIGHTER PHYSICALS 5,660 25,875 20,215 780 1000-416-420400-521 CENTRAL GARAGE TRANSFER 32,954 43,938 10,984 250 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 0 40,000 40,000 1000 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 112,500 150,000 37,500 250 1000-416-420400-821 TRANSFER TO FUND 2956 GRANT MATCH 0 18,454 18,454 1000 1000-416-420400-922 USFS PROPERTY ACQUISITION 0 27,482 27,482 1000 1000-416-420400-940 CAPITAL EQUIPMENT - COMMAND VEHICLE 35,849 35,000 849- -20 1000-416-420440-110 SALARIES -FIRE PREVENTION 35,137 51,287 16,150 310 1000-416-420440-114 COMPTIME BUYOUT 325 0 325- 0% 1000-416-420440-121 OVERTIME 6,227 0 6,227- 0% 1000-416-420440-153 HEALTH INSURANCE 5,606 7,826 2,220 280 1000-416-420440-155 RETIREMENT 3,058 ------------ 3,697 ------------- 639 ------------ 170 ------------ 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,803,048 2,701,759 898,711 330 ------------------------------------------------- 7, 465,507 10,880, 179 3,414, 672 31 0 ------------------------------------------------- 518,750 992,000 473,250 480 ------------------------------------------------- 518,750 992,000 473,250 480 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 9 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 531,546 970,000 438,454 450 2215-000-311200-000 PERSONAL PROPERTY TAXES 33,362 35,000 1,638 50 2215-000-312000-000 PEN & INTEREST DEL TAXES 891 2,000 1,109 550 2215-000-346030-000 SWIMMING POOL FEES 72,622 140,000 67,378 480 2215-000-346040-000 CONCESSION STAND REVENUE 25,103 35,000 9,897 280 2215-000-346050-000 PARKS USAGE FEES 12,298 21,000 8,702 410 2215-000-346051-000 RECREATION FEES 6,638 8,000 1,362 170 2215-000-346052-000 SPORTS PROGRAMS 42,956 45,000 2,044 50 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 1,742 2,500 758 300 2215-000-346054-000 AFTER SCHOOL PROGRAMS 53,550 70,000 16,450 240 2215-000-346055-000 ICE RINK 18,721 25,000 6,279 250 2215-000-346056-000 KIDSPORT USAGE 1,953 300 1,653- -5510 2215-000-346057-000 YOUTH CAMPS 13,292 142,000 128,708 910 2215-000-346059-000 PICNIC IN THE PARK 3,079 30,000 26,921 900 2215-000-362015-000 INSURANCE REIMBURSEMENTS 18,762 0 18,762- 0% 2215-000-365010-000 FEC REFUNDS/DONATIONS 4,518 0 4,518- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 1000 2215-000-371010-000 INVESTMENTS 2,411 2,000 411- -210 2215-000-381050-000 INCEPTION OF LEASE 90,773 130,000 39,227 300 2215-000-381060-000 HEALTH INSURANCE TRANSFER 68,250 91,000 22,750 250 TOTAL PARKS & REC REVENUE ------------ 1,002,467 ------------ ------------- 1,768,800 ------------- ------------------------ 766,333 ------------------------ 430 PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 221,994 316,192 94,198 300 2215-436-460430-111 SEASONAL SALARIES 43,914 65,276 21,362 330 2215-436-460430-121 OVERTIME 0 500 500 1000 2215-436-460430-153 HEALTH INSURANCE 40,548 61,643 21,095 340 2215-436-460430-155 RETIREMENT 19,018 26,136 7,118 270 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 286 1,000 714 710 2215-436-460430-224 JANITORIAL SUPPLIES 3,535 5,000 1,465 290 2215-436-460430-229 OTHER SUPPLIES 2,247 4,000 1,753 440 2215-436-460430-231 GAS 9,502 18,000 8,498 470 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 26 2,500 2,474 990 2215-436-460430-320 PRINTING & ADVERTISING 169 400 231 580 2215-436-460430-341 ELECTRICITY 9,747 16,000 6,253 390 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 18,894 25,000 6,106 240 2215-436-460430-344 NATURAL GAS 1,543 3,000 1,457 490 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 1,759 3,040 1,281 420 2215-436-460430-351 TENNIS COURT REHABILITATION 0 2,000 2,000 1000 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 2,000 2,000 1000 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 320 5,000 4,680 940 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 0 2,680 2,680 1000 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 2,303 5,000 2,697 540 2215-436-460430-364 LANDSCAPING 2,403 5,500 3,097 560 2215-436-460430-367 VANDALISM REPAIRS 31,734 4,000 27,734- -6930 2215-436-460430-373 DUES & TRAINING 4,374 6,000 1,627 270 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 100 600 500 830 2215-436-460430-395 EQUIPMENT RENTAL 301 500 200 400 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 0 3,000 3,000 1000 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 10 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-440 IRRIGATION SUPPLIES 2,394 9,000 6,606 730 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 569 1,700 1,131 670 2215-436-460430-521 CENTRAL GARAGE TRANSFER 32,893 43,857 10,964 250 2215-436-460430-610 DEBT SERVICE PRINCIPAL 9,112 29,112 20,000 690 2215-436-460430-620 DEBT SERVICE INTEREST 327 784 457 580 2215-436-460430-941 CAPITAL OUTLAY: FLATBED, MOWER, WOO 90,673 ------------ 137,000 ------------- 46,327 ------------ 340 ------------ SUBTOTAL PARKS EXPENDITURES 550,687 805,420 254,733 320 ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 43,613 89,153 45,540 510 2215-436-460440-111 SEASONAL SALARIES 20,437 41,906 21,469 510 2215-436-460440-153 HEALTH INSURANCE 9,140 25,922 16,782 650 2215-436-460440-155 RETIREMENT 4,365 10,046 5,681 570 2215-436-460440-221 SAFETY EQUIPMENT 0 350 350 1000 2215-436-460440-229 OTHER SUPPLIES 4,922 15,500 10,578 680 2215-436-460440-231 GAS 3,183 10,500 7,317 700 2215-436-460440-241 CONSUMABLE TOOLS 1,222 1,500 278 190 2215-436-460440-341 ELECTRICITY 4,542 7,700 3,158 410 2215-436-460440-345 TELEPHONE & COMMUNICATION 97 175 78 440 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 1000 2215-436-460440-355 CONTRACT SERVICES - ASPHALT RESURFC 42,274 40,534 1,740- -40 2215-436-460440-362 EQUIPMENT MAINTENANCE 64 600 536 890 2215-436-460440-364 LANDSCAPING 0 600 600 1000 2215-436-460440-367 VANDALISM REPAIRS 300 500 200 400 2215-436-460440-373 DUES & TRAINING 401 500 99 200 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 1000 2215-436-460440-420 METAL PRODUCTS 0 300 300 1000 2215-436-460440-440 IRRIGATION 2,591 4,000 1,409 350 2215-436-460440-452 SAND & GRAVEL 0 1,000 1,000 1000 2215-436-460440-940 EQUIPMENT ------------ 0 ------------- 24,000 24,000 ------------------------ 1000 SUBTOTAL ATHLETIC COMPLEX 137,151 275,936 138,785 500 RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 56,733 81,678 24,945 310 2215-436-460431-111 SEASONAL SALARIES 3,870 8,285 4,415 530 2215-436-460431-153 HEALTH INSURANCE 13,080 23,906 10,826 450 2215-436-460431-155 RETIREMENT 4,357 6,705 2,348 350 2215-436-460431-229 MISC. SUPPLIES 4,499 9,435 4,936 520 2215-436-460431-231 GAS 541 590 49 80 2215-436-460431-320 PRINTING & ADVERTISING 0 10,800 10,800 1000 2215-436-460431-345 TELEPHONE & COMMUNICATION 535 1,661 1,126 680 2215-436-460431-354 CONTRACT SERVICES 17,505 19,093 1,588 80 2215-436-460431-357 MUSIC FRANCHISE FEES 1,042 1,100 58 50 2215-436-460431-373 DUES & TRAINING 292 728 436 600 ------------ SUBTOTAL RECREATION ------------- 102,454 163,981 ------------------------ 61,527 380 YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 50,425 72,793 22,368 310 2215-436-460448-111 SEASONAL SALARIES 77,160 136,855 59,695 440 2215-436-460448-121 OVERTIME 0 300 300 1000 2215-436-460448-153 HEALTH INSURANCE 12,310 22,953 10,643 460 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 11 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460448-155 RETIREMENT 3,869 6,424 2,555 40% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 186 400 214 54% 2215-436-460448-229 MISC. SUPPLIES 840 3,600 2,760 77% 2215-436-460448-231 GAS 199 300 101 34% 2215-436-460448-320 PRINTING & ADVERTISING 0 100 100 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 765 765 0- -0% 2215-436-460448-354 CONTRACT SERVICES 8,450 13,000 4,550 35% 2215-436-460448-355 AFTER SCHOOL PROGRAM 418 800 382 48% 2215-436-460448-356 BANK FEES/CC CHARGES 1,435 3,900 2,465 63% 2215-436-460448-373 DUES & TRAINING 483 800 317 40% SUBTOTAL YOUTH CAMPS ------------ 156,538 ------------- 262,990 ------------ 106,452 ------------ 40% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 116,959 190,325 73,366 39% 2215-437-460445-112 SEVERANCE 0 2,535 2,535 100% 2215-437-460445-121 OVERTIME 187 500 313 63% 2215-437-460445-155 RETIREMENT 929 1,500 571 38% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 0 400 400 100% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 2,138 2,200 62 3% 2215-437-460445-226 CHLORINE/CHEMICALS 17,205 25,000 7,795 31% 2215-437-460445-228 CONCESSION STAND SUPPLIES 9,890 21,000 11,110 53% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 908 4,500 3,592 80% 2215-437-460445-341 ELECTRICITY 5,553 9,500 3,947 42% 2215-437-460445-344 NATURAL GAS 13,556 25,000 11,444 46% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,071 1,620 549 34% 2215-437-460445-354 LICENSES & FEES 590 1,300 710 55% 2215-437-460445-356 BANK FEES/ CC CHARGES 1,157 1,200 43 4% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 7,820 14,600 6,780 46% 2215-437-460445-380 TRAINING MATERIALS 470 1,800 1,330 74% SUBTOTAL POOL EXPENDITURES ------------ 178,433 ------------ ------------- 302,980 ------------- ------------------------ 124,547 ------------------------ 41% TOTAL PARKS & RECREATION/POOL 1,125,262 1,811,307 686,045 38% 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 12 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FORESTRY & DEVELOPER TREES 2600-436-460433-110 SALARIES -URBAN FORESTRY 70,517 107,421 36,904 340 2600-436-460433-111 SEASONAL SERVICES 10,654 25,731 15,077 590 2600-436-460433-121 OVERTIME 0 300 300 1000 2600-436-460433-153 HEALTH INSURANCE 13,970 24,764 10,794 440 2600-436-460433-155 RETIREMENT 5,361 9,713 4,352 450 2600-436-460433-229 OFFICE/OTHER SUPPLIES 41 600 559 930 2600-436-460433-231 GAS 1,022 4,500 3,478 770 2600-436-460433-241 CONSUMABLE TOOLS 1,798 4,500 2,702 600 2600-436-460433-354 CONTRACT SERVICES 13,000 35,000 22,000 630 2600-436-460433-357 FORESTRY GRANT 634 11,880 11,246 950 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 1,650 6,750 5,100 760 2600-436-460433-362 EQUIPMENT MAINTENANCE 315 4,000 3,685 920 2600-436-460433-364 LANDSCAPING & TREES 1,634 8,000 6,366 800 2600-436-460433-373 DUES & TRAINING 1,830 2,000 170 90 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 628 628 0 0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 5,526 7,368 1,842 250 2600-436-460433-522 ADMINISTRATIVE TRANSFER 6,204 8,272 2,068 250 2600-436-460433-528 DATA PROCESSING TRANSFER 3,128 4,171 1,043 250 2600-436-460433-610 DEBT SERVICE PRINCIPAL 10,824 15,000 4,176 280 2600-436-460433-620 INTEREST EXPENSE 665 1,000 335 340 2600-436-460433-940 MACHINERY & EQUIPMENT 0 40,000 40,000 1000 TOTAL URBAN FORESTRY 149,400 321,598 172,198 540 ------------------------------------------------ 2601-436-460435-351 EMPIRE ESTATES ($44,911) 2601-436-460435-352 APPLEWAY ($4,564) 2601-436-460435-353 LEISURE HEIGHTS ($9,990) 2601-436-460435-354 CONTRACT SERVICES 2601-436-460435-356 SINOPAH SUBD ($5,790) 2601-436-460435-357 COTTONWOOD SUBD ($13,100) 2601-436-460435-358 WEST VIEW SUBD ($22,680) 2601-436-460435-359 MTN VISTA ESTATES ($35,903+34,660) 2601-436-460435-361 VILLAGE GREENS ($3,540) 2601-436-460435-362 WESTVIEW BUSINESS CNTR ($1,618) 2601-436-460435-363 MUSKRAT SLOUGH ($1,446) 2601-436-460435-364 MTN VISTA ESTATES III $17,278.25 2601-436-460435-365 VILLAGE GREENS $3,540 2601-436-460435-366 W VIEW ESTATES $20,060 2601-436-460435-367 ABIGAIL SUBDIVISION ($4,253.90) 2601-436-460435-368 NORTHLAND SUBD PHASE 4 TOTAL DEVELOPER TREES 2210 PARKS IN LIEU 2210-436-460430-934 CAPITAL IMPROVEMENTS TOTAL PARKS IN LIEU 0 8, 653 8, 653 100 0 0 4,336 4,336 1000 0 366 366 1000 0 11,231 11,231 100 0 0 667 667 1000 0 1, 928 1,928 100 0 650 16,236 15,586 960 0 27,079 27,079 1000 1, 950 2,219 269 12 0 0 948 948 1000 0 1,390 1,390 100% 650 1, 134 484 43 0 0 2,797 2,797 1000 0 8, 490 8,490 100 0 0 2,716 2,716 1000 0 8,812 8,812 100 0 ------------------------- 3,250 ------------------------- ------------ 99,002 ------------ ------------ 95,752 ------------ 970 0 ------------------------- 1,417 ------------ 1,417 ------------ 100 0 0 1,417 1,417 1000 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 13 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 504,063 891,000 386,937 430 2230-000-342070-000 COUNTY EMS LEVY 50,300 110,000 59,700 540 2230-000-383010-000 TRANSFER FROM GENERAL FUND 112,500 150,000 37,500 250 TOTAL AMBULANCE REVENUE ------------ 666,863 ------------- 1,151,000 ------------ 484,137 ------------ 420 AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 418,621 608,459 189,838 310 2230-440-420730-114 COMPTIME BUYBACK 2,168 3,500 1,332 380 2230-440-420730-115 OUT OF RANK PAY 1,059 1,000 59- -60 2230-440-420730-121 OVERTIME 42,994 50,000 7,006 140 2230-440-420730-153 HEALTH INSURANCE 97,540 159,142 61,602 390 2230-440-420730-155 RETIREMENT 57,082 80,552 23,470 290 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 837 1,000 163 160 2230-440-420730-218 NON -CAPITAL EQUIPMENT 4,108 4,000 108- -30 2230-440-420730-231 GAS & OIL 3,832 7,560 3,728 490 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 0 4,000 4,000 1000 2230-440-420730-312 POSTAGE/PRINTING 0 1,500 1,500 1000 2230-440-420730-345 TELEPHONE & COMMUNICATION 1,241 1,200 41- -30 2230-440-420730-354 CONTRACT SERVICES 9,794 17,800 8,006 450 2230-440-420730-355 911 CENTER CONTRIBUTION 25,500 34,000 8,500 250 2230-440-420730-359 AUDIT/CC OTHER FEES 1,786 1,400 386- -280 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 5,000 5,000 0 0% 2230-440-420730-373 DUES & TRAINING 1,642 5,000 3,358 670 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,500 2,500 1000 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 18,546 46,000 27,454 600 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 7,614 7,614 0 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 12,171 16,229 4,058 250 2230-440-420730-522 ADMINISTRATIVE TRANSFER 31,574 42,099 10,525 250 2230-440-420730-528 DATA PROCESSING TRANSFER 12,513 16,684 4,171 250 2230-440-420730-940 EQUIPMENT ------------ 169,673 170,000 ------------- 327 ------------------------ 0% TOTAL AMBULANCE EXPENDITURES ------------ 925,296 1,286,239 ------------- 360,943 ------------------------ 280 2399 PUBLIC SAFETY IMPACT FEES 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 10,000 10,000 0 0% 2399-413-420140-940 POLICE EQUIPMENT 0 60,000 60,000 1000 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 65,500 65,500 0 0% 2399-416-420400-620 INTEREST - FIRE TRUCK 4,632 4,651 19 0% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 500,000 500,000 1000 ------------ TOTAL PUBLIC SAFETY IMPACT FEE ------------ 80,132 ------------- 640,151 ------------- ------------------------ 560,019 ------------------------ 870 FIRE & HAZMAT GRANTS 2956-416-420400-218 EQUIPMENT (NON CAPITAL) 0 2,200 2,200 1000 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 2,685 3,000 315 100 2956-416-420415-940 AFG GRT (POWER COTS) EMW2014FOO5022 0 225,000 225,000 1000 ------------ TOTAL FIRE GRANTS 2,685 ------------- 230,200 ------------------------ 227,515 990 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 14 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2957-416-420400-155 RETIREMENT 0 2,500 2,500 1000 2957-416-420410-125 PASS THRU HAZMAT OT 10,099 19,365 9,266 480 2957-416-420410-218 PASS THRU HAZMAT EQUIP 17,490 33,113 15,623 470 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 1,929 6,100 4,171 680 TOTAL HAZMAT GRANTS ------------------------- 29,518 ------------ 61,078 ------------ 31,560 520 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 15 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 657,474 350,000 307,474- -88% 2394-000-323103-000 PLUMBING PERMITS 24,488 20,000 4,488- -22% 2394-000-323104-000 MECHANICAL PERMITS 33,055 30,000 3,055- -10% 2394-000-323105-000 ELECTRICAL PERMITS 67,586 30,000 37,586- -125% 2394-000-323108-000 PLAN REVIEW FEES 331,593 100,000 231,593- -232% 2394-000-371010-000 INVESTMENT EARNINGS 10,754 4,500 6,254- -139% TOTAL REVENUE ------------------------- 1,124,950 534,500 ------------------------ 590,450- -110% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 255,842 374,578 118,736 32% 2394-420-420530-121 OVERTIME 9,530 5,000 4,530- -91% 2394-420-420530-153 HEALTH INSURANCE 48,306 85,277 36,971 43% 2394-420-420530-155 RETIREMENT 19,739 27,529 7,790 28% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 26,214 20,000 6,214- -31% 2394-420-420530-231 GAS & OIL 1,852 3,500 1,648 47% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 954 2,500 1,546 62% 2394-420-420530-323 ST. ED. ASSESSMENTS 4,546 3,000 1,546- -52% 2394-420-420530-345 TELEPHONE & COMMUNICATION 2,386 3,500 1,114 32% 2394-420-420530-353 AUDITING 1,000 0 1,000- 0% 2394-420-420530-354 CONTRACT SERVICES 27,679 43,500 15,821 36% 2394-420-420530-355 CITY WORKS LICENSING FEE 15,156 15,000 156- -1% 2394-420-420530-373 DUES & TRAINING 9,357 9,000 357- -4% 2394-420-420530-510 PROPERTY INSURANCE 2,585 2,585 0 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 1,090 1,454 364 25% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 12,211 16,282 4,071 25% 2394-420-420530-528 DATA PROCESSING TRANSFER 21,897 29,196 7,299 25% 2394-420-420530-944 VEHICLES 0 65,000 65,000 100% TOTAL BUILDING DEPT. ------------------------- 460,345 706,901 ------------------------ 246,556 35% 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 16 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 50,036 70,405 20,369 290 2400-410-430263-153 HEALTH INSURANCE 7,466 13,628 6,162 450 2400-410-430263-155 RETIREMENT 3,687 5,141 1,454 280 2400-410-430263-244 STREET LIGHT SUPPLIES 2,859 18,000 15,141 840 2400-410-430263-341 ELECTRICITY 105,497 173,000 67,503 390 2400-410-430263-360 REPAIR & MAINT SERVICES 3,816 20,000 16,184 810 2400-410-430263-510 INSURANCE 392 1,000 608 610 2400-410-430263-522 ADMINISTRATIVE TRANSFER 9,486 12,648 3,162 250 2400-410-430263-920 NEW LUMINAIRES 0 30,000 30,000 1000 2400-410-490500-610 DEBT SERVICE -PRINCIPAL 21,862 21,862 0 0% 2400-410-490500-620 DEBT SERVICE -INTEREST EXPENSE 596 681 85 130 ------------ TOTAL LIGHT MAINT. ------------- 205,697 366,365 ------------------------ 160,668 440 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 11,928 56,485 44,557 790 2420-421-430234-957 ALLEY PAVING 33,435 41,627 8,192 200 2420-421-430240-231 GAS & OIL 22,156 43,000 20,844 480 2420-421-430240-344 NATURAL GAS 3,936 5,500 1,564 280 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 1000 2420-421-430240-360 REPAIR & MAINT SERVICES 450 1,500 1,050 700 2420-421-430240-368 OVERLAY/CHIPSEALS 106,489 225,562 119,073 530 2420-421-430240-452 GRAVEL 0 3,500 3,500 1000 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 1000 2420-421-430240-471 DE-ICER/ROAD OIL 15,502 40,000 24,498 610 2420-421-430240-472 ASPHALT 22,981 53,000 30,019 570 2420-421-430240-473 CRACK SEALING 0 14,500 14,500 1000 2420-421-430240-474 PAINT STRIPING MATERIALS 2,560 60,000 57,440 960 ------------ TOTAL GAS TAX ------------- 219,437 569,674 ------------------------ 350,237 610 2825 MAGI GRANT 2825-421-430240-940 SANDER / SWEEPER 0 433,202 433,202 1000 ------------ TOTAL MACI GRANT ------------- 0 433,202 ------------------------ 433,202 1000 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 479,504 709,550 230,046 320 2500-421-430240-121 OVERTIME 34,826 25,000 9,826- -390 2500-421-430240-153 HEALTH INSURANCE 98,568 172,495 73,927 430 2500-421-430240-155 RETIREMENT 37,800 51,452 13,652 270 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 443 9,000 8,557 950 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 2,835 6,500 3,665 560 2500-421-430240-220 OTHER SUPPLIES 3,101 4,500 1,399 310 2500-421-430240-231 GAS & OIL 23,244 40,000 16,756 420 2500-421-430240-341 ELECTRICITY 1,876 3,300 1,424 430 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 860 1,500 640 430 2500-421-430240-354 CONTRACT SERVICES 6,612 30,000 23,388 780 2500-421-430240-356 CONSULTANT - TRANSPORTATION PLAN UP 0 62,892 62,892 1000 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 24,837 32,500 7,663 240 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 17 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2500-421-430240-366 BUILDING MAINTENANCE 1,524 3,000 1,476 490 2500-421-430240-373 DUES & TRAINING 1,438 5,500 4,062 740 2500-421-430240-388 MEDICAL SERVICES 228 1,500 1,273 850 2500-421-430240-510 LIABILITY INSURANCE 13,578 13,578 0 0% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 1000 2500-421-430240-521 CENTRAL GARAGE TRANSFER 134,414 179,219 44,805 250 2500-421-430240-522 ADMINISTRATIVE TRANSFER 67,928 90,571 22,643 250 2500-421-430240-528 DATA PROCESSING TRANSFER 9,384 12,513 3,129 250 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 111,946 111,946 0- 0% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 3,016 3,447 431 130 2500-421-430240-920 SALT BRINE TANK 0 20,000 20,000 1000 2500-421-430240-921 SAND/COLD MIX STORAGE SHED 1,225 25,771 24,546 950 2500-421-430240-922 USFS PROPERTY ACQUISITION 604 54,964 54,360 990 2500-421-430240-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 1000 2500-421-430240-969 4TH AVE E MAIN REPLC PHASE 1-4 0 1,114,018 1,114,018 1000 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 148,722 762,359 613,637 800 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 251,137 300,544 49,407 160 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 1000 2500-421-430264-110 TSS - SALARIES 85,843 122,685 36,842 300 2500-421-430264-121 OVERTIME 607 7,500 6,893 920 2500-421-430264-153 HEALTH INSURANCE 10,842 17,485 6,643 380 2500-421-430264-155 RETIREMENT 6,288 8,823 2,535 290 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 1,822 1,500 322- -210 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,018 6,700 5,682 850 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 2,072 3,500 1,428 410 2500-421-430264-242 STREET SIGNS 10,486 40,000 29,514 740 2500-421-430264-243 TRAFFIC SIGNALS 8,534 19,000 10,466 550 2500-421-430264-245 BARRICADE MATERIALS 0 5,000 5,000 1000 2500-421-430264-341 ELECTRICITY 1,262 3,000 1,738 580 2500-421-430264-345 COMMUNICATIONS 502 750 248 330 2500-421-430264-354 CONTRACT SERVICES 1,800 10,000 8,200 820 2500-421-430264-362 EQUIPMENT MAINTENANCE 511 3,000 2,489 830 2500-421-430264-366 BUILDING MAINTENANCE 1,770 2,000 230 11% 2500-421-430264-373 DUES & TRAINING 1,677 5,500 3,823 700 2500-421-430264-428 PAINT MATERIALS 68 8,000 7,933 990 2500-421-430264-510 LIABILITY INS.-TSS 1,604 1,604 0 0% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 3,783 2,500 1,283- -51% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 5,950 7,934 1,984 250 2500-421-430264-532 OFFICE RENT 6,422 6,422 0 0% TOTAL SPEC. ST. MAINT. 1,612,511 4,198,902 2,586,391 620 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 18 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 1,600 1,600 0 0% 2185-000-430300-356 REDEVELOPMENT / CONTRACT SERVICES 291 0 291- 0% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 6,933 9,243 2,310 25% 2185-000-430300-840 REDEVELOPMENT ACTIVITY 0 1,750,000 1,750,000 100% 2185-480-470240-110 SALARIES 13,794 20,256 6,462 32% 2185-480-470240-153 HEALTH INSURANCE 1,904 2,935 1,031 35% 2185-480-470240-155 RETIREMENT 1,066 1,526 460 30% 2185-480-470240-345 TELEPHONE & COMMUNICATION 36 48 12 25% TOTAL AIRPORT TIF ------------ 25,623 ------------- 1,785,608 ------------------------ 1,759,985 99% 2188 WESTSIDE TIF 2188-480-470230-110 SALARIES 29,579 43,983 14,404 33% 2188-480-470230-153 HEALTH INSURANCE 3,536 5,558 2,022 36% 2188-480-470230-155 RETIREMENT 2,286 3,337 1,051 31% 2188-480-470230-353 AUDIT 2,000 2,000 0 0% 2188-480-470230-354 TO PORT/GATEWAY W. BLDG MAINT. 0 5,000 5,000 100% 2188-480-470230-356 TELEPHONE 144 0 144- 0% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 2,598 3,464 866 25% 2188-480-470230-840 TRANSFER TO DEBT SERVICE 24,255 32,340 8,085 25% 2188-480-470240-720 PRE AWARD TIGER 153,443 4,000,000 3,846,557 96% TOTAL WESTSIDE TIF ------------ 217,842 ------------ ------------- 4,095,682 ------------- ------------------------ 3,877,840 ------------------------ 95% OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 10,841 11,500 659 6% 2310-480-470210-356 FED -EX REIMBURSEMENT 10,282 11,000 718 7% 2310-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 26,250 35,000 8,750 25% 2311-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 11,250 15,000 3,750 25% TOTAL OLD SCHOOL TIFS ------------ 58,623 ------------- 72,500 ------------------------ 13,877 19% 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 19 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 1,000 1,000 0 0% 2880-480-470210-354 CONTRACT SERVICES 380 1,000 620 620 2880-480-470210-711 REDEVELOPMENT 50,018 150,000 99,982 670 TOTAL LOAN REVOLVING ------------ 51,398 ------------- 152,000 ------------ 100,602 ------------ 660 2881 CD LOAN REV. #2 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 2881-480-470210-711 REDEVELOPMENT 2886-480-470210-210 2886-480-470210-353 2886-480-470210-373 2886-480-470210-379 2886-480-470210-396 2886-480-470210-522 2886-480-470210-528 2886-480-470210-532 2886-480-470210-620 2886-480-470210-790 2886-480-470210-795 2887-480-470210-354 2887-480-470210-610 2887-480-470210-620 2887-480-470210-750 2888-480-470210-354 2888-480-470210-610 2888-480-470210-620 2888-480-470210-750 TOTAL 2881 CD REV. #2 2886 CD MISC. OFFICE SUPPLIES AUDITING DUES & TRAINING MEETINGS GRANT SERVICES ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER OFFICE RENT INTEREST - OLD SCHOOL LOAN - GENERA COMM. DEV. ACTIVITIES REDEVELOPMENT- OLD SCHOOL STATION TOTAL CD MISC. 2887 RURAL DEVELOPMENT #1 CONT SERV (LOAN SOFTWARE) DEBT SERVICE/PRIN-L#61-01 INTEREST EXPENSE/L#61-01 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT #1 2888 RURAL DEVELOPMENT #2 CONT SERV (LOAN SOFTWARE) DEBT SERVICE/PRIN-L#61-03 INTEREST EXPENSE -USDA LOAN 61-03 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT #2 335 0 335- 0% 0 150,000 150,000 1000 ------------------------- 335 150,000 ------------------------ 149,665 1000 0 2,000 2,000 1000 1,000 1, 000 0 0% 55 2, 000 1, 945 97 0 0 1, 000 1,000 100 0 0 25,000 25,000 1000 1,500 2,000 500 250 6,256 8,342 2,086 25 0 1,175 1, 175 0 0% 0 16,250 16,250 100 0 1,705 100,000 98,295 980 87,556 ------------------------- 183, 750 96,194 ------------------------ 52 0 99,248 342,517 243,269 710 335 0 335- 0% 18,272 18,272 0- 0% 3,802 3, 803 1 0% 0 ------------------------- 150,000 150,000 ------------------------ 1000 22,409 ------------------------- 172,075 149,666 ------------------------ 870 335 0 335- 0% 8,138 8,135 3- _0% 1,887 1,890 3 0% 0 ------------------------- 110,000 110,000 ------------------------ 1000 10, 360 120,025 109, 665 91 0 2953 EPA BROWNFIELDS 2953-480-470210-354 PETROLEUM 16 200,000 199,984 1000 2953-480-470210-373 TRAVEL/PETROLEUM 569 0 569- 0% 2953-480-470215-354 HAZARDOUS 16 200,000 199,984 1000 2953-480-470215-373 TRAVEL/HAZARDOUS 397 0 397- 0% 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 20 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. ------------------------------------------------- TOTAL EPA BROWNSFIELD 998 400,000 399,002 1000 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES -PETROLEUM 2955-480-470210-352 PERSONNEL -PETROLEUM 2955-480-470210-353 FRINGES -PETROLEUM 2955-480-470210-354 CONTRACTED SERVICES-PETROLUUM 2955-480-470210-373 TRAVEL -PETROLEUM 2955-480-470210-720 CLEANUP LOANS -PETROLEUM 2955-480-470210-721 CLEANUP SUBGRANTS-PETRO 2955-480-470210-725 REVOLVED FUNDS -PETROLEUM 2955-480-470215-229 SUPPLIES -HAZARDOUS SUBSTANCES 2955-480-470215-354 CONTRACT SERV-HAZARDOUS SUBST 2955-480-470215-373 TRAVEL -HAZARDOUS SUBTSANCE 2955-480-470215-720 CLEANUP LOANS -HAZARDOUS TOTAL BROWNFIELDS LOAN REV. 2991 TIGER GRANT 2991-480-470245-790 REDEVELOPMENT TOTAL TIGER GRANT 2994 KIDSPORTS GRANT 2994-436-460436-930 CAPITAL IMPROVEMENTS TOTAL KIDSPORTS GRANT 0 908 908 1000 0 3,505 3,505 1000 0 493 493 1000 0 1,488 1,488 100 0 35 35 0- -10 0 62,354 62,354 1000 0 100,000 100,000 1000 0 100,500 100,500 1000 0 1,158 1,158 100 0 0 88 88 1000 1,447 3,778 2,331 62 0 0 314,600 314,600 1000 ------------ 1,483 ------------- 588,907 ------------------------ 587,424 1000 0 ------------ 10,000,000 ------------- 10,000,000 ------------------------ 1000 0 10,000,000 10,000,000 1000 160,757 ------------ 2,152,726 ------------- 1,991,969 ------------------------ 93 0 160,757 2,152,726 1,991,969 93% 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 21 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING a REMAINING ACCOUNT NUMBER DESC. 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD /2015 GRT 2,341 31,255 28,914 93% 2915-413-420140-218 SMALL EQUIP - 2015 STONEGARDEN 38,851 25,000 13,851- -55% 2915-413-420140-354 CONT SERV-WPD/MHP/MFWPE-2015 GRT 33,293 38,815 5,522 14% ------------ TOTAL 2915 STONEGARDEN GRANT ------------- 74,485 95,070 ------------------------ 20,585 22% 2916 DRUG ENFORCEMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 42,726 60,926 18,200 30% 2916-413-420140-121 OVERTIME 6,405 7,500 1,095 15% 2916-413-420140-153 HEALTH INSURANCE 11,856 17,541 5,685 32% 2916-413-420140-155 RETIREMENT 5,664 8,167 2,503 31% 2916-413-420140-354 CONTRACT SERVICES 3,906 5,841 1,935 33% ------------ TOTAL 2916 DRUG ENFORCEMENT ------------- 70,558 99,975 ------------------------ 29,417 29% 2918 CHRP GRANT 2918-413-420140-110 SALARIES & PAYROLL COSTS 41,140 140,287 99,147 71% 2918-413-420140-153 HEALTH INSURANCE 5,224 32,606 27,382 84% 2918-413-420140-155 RETIREMENT 5,352 18,857 13,505 72% ------------ TOTAL CHRP GRANT ------------- 51,717 191,750 ------------------------ 140,033 73% 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 2,145 4,000 1,855 46% 2919-413-420140-125 DUI TASK FORCE 0 8,000 8,000 100% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 19,810 36,000 16,190 45% 2919-413-420140-127 SCHOOL DIST. OT 14,706 20,000 5,294 26% 2919-413-420140-218 JAG&MDOT GRTS-WATCHGUARD CAMERAS 10,904 12,000 1,096 9% 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 1,287 2,500 1,213 49% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 6,924 7,000 76 1% ------------ TOTAL LAW ENF. GRANT ------------- 55,776 89,500 ------------------------ 33,724 38% 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 22 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CAPITAL PROJECT FUNDS 4150 FIRE PUMPER 4150-416-420400-944 PUMPER TRUCK TOTAL 4150 FIRE PUMPER 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION TOTAL 4290 WALK & CURB 0 ------------------------- 500,000 500,000 1000 ------------------------ 0 500,000 500,000 1000 6, 310 ------------------------- 25, 000 18,690 75 0 ------------------------ 6, 310 25, 000 18, 690 75 0 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 23 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ENTERPRISE FUNDS WATER REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 900 0 900- 0% 5210-000-331158-000 STATE BYPASS RELOCATION REIMB. 1,876 0 1,876- 00 5210-000-343210-000 METERED WATER SALES 2,335,089 2,850,000 514,911 180 5210-000-343220-000 UNMETERED WATER SALES 11,173 0 11,173- 0% 5210-000-343225-000 IMPACT FEES 502,882 285,000 217,882- -760 5210-000-343230-000 METER REPLACEMENT FEE 74,510 98,000 23,490 240 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 23,340 74,000 50,660 680 5210-000-343265-000 IMPACT ADMIN FEES 0 15,000 15,000 1000 5210-000-343270-000 WATER TURN ON FEES 3,745 0 3,745- 0% 5210-000-343275-000 TAG FEE 52,040 0 52,040- 0% 5210-000-371010-000 INVESTMENT EARNINGS 71,401 46,000 25,401- -550 5210-000-381050-000 INCEPTION OF LEASE 0 ------------ 2,435,627 ------------- 2,435,627 ------------ 1000 ------------ TOTAL WATER REVENUE 3, 076, 957 ------------ 5, 803, 627 ------------- 2,726, 670 ------------------------ 47 0 WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 494,074 702,293 208,219 300 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 1000 5210-447-430550-121 OVERTIME 6,214 20,000 13,786 690 5210-447-430550-153 HEALTH INSURANCE 98,716 168,225 69,509 410 5210-447-430550-155 RETIREMENT 36,852 51,002 14,150 280 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 4,512 11,000 6,488 590 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 4,214 8,500 4,286 500 5210-447-430550-226 CHLORINE & CHEMICALS 19,391 38,000 18,609 490 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 3,442 4,500 1,058 240 5210-447-430550-231 GAS & OIL 15,547 38,000 22,453 590 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 156 4,000 3,844 960 5210-447-430550-336 LICENSES & FEES 15,710 18,500 2,790 150 5210-447-430550-341 ELECTRICITY 96,184 150,000 53,816 360 5210-447-430550-344 NATURAL GAS 7,427 15,500 8,073 520 5210-447-430550-345 TELEPHONE & COMMUNICATION 7,447 9,000 1,553 170 5210-447-430550-349 LAB SERVICES 20,787 26,000 5,213 200 5210-447-430550-353 AUDITING 5,000 5,000 0 0% 5210-447-430550-354 CONTRACT SERVICES 10,466 65,000 54,534 840 5210-447-430550-356 CONSULTANTS-WTR RIGHTS/MODELING 2,652 25,000 22,348 890 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 1,682 15,000 13,318 890 5210-447-430550-366 BUILDING MAINTENANCE 2,886 12,000 9,114 760 5210-447-430550-373 DUES & TRAINING 3,468 9,000 5,532 610 5210-447-430550-388 MEDICAL SERVICES 193 800 608 760 5210-447-430550-410 CONSTRUCTION MATERIALS 9,990 35,000 25,010 710 5210-447-430550-422 HYDRANTS 5,539 8,000 2,462 310 5210-447-430550-423 MATERIALS FOR MAINS 5,967 14,000 8,033 570 5210-447-430550-424 MATERIALS -SERVICE LINES 3,838 14,000 10,162 730 5210-447-430550-425 MATERIALS PUMPS/WELLS 4,126 45,000 40,874 910 5210-447-430550-510 PROPERTY & LIABILITY INS. 15,468 15,468 0 0% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 1000 5210-447-430550-521 CENTRAL GARAGE TRANSFER 17,891 23,855 5,964 250 5210-447-430550-522 ADMINISTRATIVE TRANSFER 77,604 103,473 25,869 250 5210-447-430550-528 DATA PROCESSING TRANSFER 21,897 36,000 14,103 390 5210-447-430550-532 LEASE PAYMENTS (City Hall rent) 6,422 9,500 3,078 320 5210-447-430550-921 SAND/COLD MIX STORAGE SHED 1,225 25,771 24,546 950 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 24 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-922 USFS PROPERTY ACQUISITION 366 32,978 32,612 990 5210-447-430550-936 Noffsinger Spring Generator 49,817 90,000 40,183 450 5210-447-430550-948 METERS (METER FUNDS) 010125 30,100 110,000 79,900 730 5210-447-430550-951 SECURITY SCADA UPGRADES 2,669 15,000 12,331 820 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 1000 5210-447-430550-958 2ND AVE EAST MAIN REPLC & UPSIZE 434 45,147 44,713 990 5210-447-430550-959 PARKS METERING PHASE I 7,100 30,000 22,900 760 5210-447-430550-969 4TH AVE E MAIN REPL. PH. 1 0 2,435,627 2,435,627 1000 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 150,000 150,000 1000 5210-447-430555-941 METERS (NEW SERVICES)010120 30,100 45,600 15,500 340 5210-447-430555-953 SECTION 36 WELL 0 639,746 639,V46 1000 SUBTOTAL WATER FACILITIES ------------ 1,147,572 ------------ ------------- 5,366,037 ------------- ------------ 4,218,465 ------------ ------------ 790 ------------ WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 5210-447-430560-153 HEALTH INSURANCE 5210-447-430560-155 RETIREMENT 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 5210-447-430560-353 AUDITING 5210-447-430560-354 CONTRACT SERVICES 5210-447-430560-355 BILLING COSTS 5210-447-430560-373 DUES & TRAINING 5210-447-430560-522 ADMINISTRATIVE TRANSFER 5210-447-430560-528 DATA PROCESSING TRANSFER 5210-447-430560-532 RENT SUBTOTAL WATER BILLING REVENUE BONDS 5210-447-490204-610 BOND PRIN-HWY 93 S WTR-2004 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 5210-447-490206-610 PRIN-MTR&WELL WRF7104 1.25a;WRF8114 5210-447-490206-620 INT-MTR&WELL/WRF7104 1.25o;WRF8114 5210-447-490250-610 PRIN-WTR MAIN/WRF1032R 20/IDAHO&MAI 5210-447-490250-620 INT-WTR MAIN/WRF1032R 20/IDAHO&MAIN SUBTOTAL REVENUE BONDS DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION TOTAL WATER FUND 74,498 108, 823 34,325 32 0 21,102 36,839 15,737 430 5,717 8,225 2,508 310 1,717 2,500 783 310 2,000 2,000 0 0% 0 3,000 3,000 1000 41,675 70,000 28,325 400 862 2,500 1,638 66 0 5, 962 7, 950 1, 988 25 0 21,897 33,000 11,103 340 6,422 ------------ 6, 422 ------------- 0 ------------------------ 0% 181, 852 ------------ 281,259 ------------- 99, 407 ------------------------ 35 0 0 65,000 65,000 1000 28,835 28,835 0 0% 350 350 0 0% 0 83,000 83,000 1000 22, 601 22, 601 0- 0% 0 48, 000 48,000 100 0 4,440 4,200 240- -60 ------------ 56,226 ------------ ------------- 251,986 ------------- ------------------------ 195,760 ------------------------ 780 0 840,000 840,000 1000 ------------ 0 ------------ ------------- 840,000 ------------- ------------------------ 840,000 ------------------------ 1000 1, 385, 650 6,739,282 5,353, 632 79 0 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 25 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 900 0 900- 0% 5310-000-343310-000 SEWER SERVICE CHARGES 3,342,482 4,400,000 1,057,518 240 5310-000-343330-000 IMPACT FEES (SANITARY) 586,505 220,000 366,505- -1670 5310-000-343335-000 IMPACT FEES (WWTP) 477,085 300,000 177,085- -590 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 896 15,000 14,104 940 5310-000-371010-000 INVESTMENT EARNINGS 79,350 ------------ 50,000 ------------- 29,350- ------------ -590 ------------ TOTAL SEWER REVENUE SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 5310-454-430620-153 HEALTH INSURANCE 5310-454-430620-155 RETIREMENT 5310-454-430620-215 OFFICE SUPPLIES/computers 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 5310-454-430620-355 BILLING COSTS 5310-454-430620-373 DUES & TRAINING 5310-454-430620-522 ADMINISTRATIVE TRANSFER 5310-454-430620-528 DATA PROCESSING TRANSFER 5310-454-430620-532 OFFICE RENT SUBTOTAL SEWER BILLING COSTS 4,487,216 4,985,000 497,784 100 62, 609 91, 956 29,347 32 0 16,814 29,868 13,055 440 4,798 6, 936 2,138 31 0 1,717 2,500 783 310 2,000 2,000 0 0% 44,327 70,000 25,673 370 862 2,500 1, 638 66 0 5,291 7, 055 1,764 25 0 21,897 33,000 11,103 340 6,422 6, 422 0 0% ------------------------- 166,738 ------------------------- ------------ 252,237 ------------ ------------ 85,499 ------------ 340 SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 161,033 251,377 90,344 360 5310-454-430630-121 OVERTIME 737 5,500 4,763 870 5310-454-430630-153 HEALTH INSURANCE 39,451 66,327 26,876 410 5310-454-430630-155 RETIREMENT 12,040 18,365 6,325 340 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 2,102 9,200 7,098 770 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 4,100 8,350 4,250 510 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 1,478 2,000 522 260 5310-454-430630-231 GAS & OIL 4,992 13,500 8,508 630 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 469 400 69- -170 5310-454-430630-341 ELECTRICITY 33,970 54,500 20,530 380 5310-454-430630-344 NATURAL GAS 10,241 16,500 6,259 380 5310-454-430630-345 TELEPHONE & COMMUNICATION 19,910 23,000 3,090 130 5310-454-430630-353 AUDITING 3,000 3,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 13,336 24,000 10,664 440 5310-454-430630-356 CONSULTANTS 1,263 8,000 6,737 840 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 4,477 5,000 523 100 5310-454-430630-373 DUES & TRAINING 1,861 5,500 3,639 660 5310-454-430630-388 MEDICAL SERVICES 0 500 500 1000 5310-454-430630-410 CONSTRUCTION MATERIALS 6,694 9,000 2,306 260 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 1,820 50,000 48,180 960 5310-454-430630-510 PROPERTY & LIABILITY INS. 15,791 15,791 0 0% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 3,658 25,000 21,342 850 5310-454-430630-521 CENTRAL GARAGE TRANSFER 6,885 9,180 2,295 250 5310-454-430630-522 ADMINISTRATIVE TRANSFER 48,346 64,461 16,115 250 5310-454-430630-528 DATA PROCESSING TRANSFER 12,513 19,000 6,487 340 5310-454-430630-532 OFFICE RENT 6,422 6,422 0 0% 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 26 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-921 SAND/COLD MIX STORAGE SHED 1,225 25,771 24,546 950 5310-454-430630-922 USFS PROPERTY ACQUISITION 366 32,978 32,612 990 5310-454-430630-951 1ST ALLEY EN PIPE UPSIZE (34a RATE 0 20,528 20,528 1000 5310-454-430630-952 PETERSON SCHOOL ALLEY REPLACEMENT 434 284,000 283,566 1000 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 1000 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 11,847 20,000 8,153 410 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 10,249 50,000 39,751 800 5310-454-430630-961 2ND ALLEY WN - MONT TO CALF 296,338 324,366 28,028 90 SUBTOTAL SEWER COLLECTION ------------ 737,047 ------------ ------------- 1,502,068 ------------- ------------ 765,021 ------------ ------------ 510 ------------ IMPACT FEES 5310-454-430635-951 1ST ALLEY EN PIPE UPSIZE (34a RATE 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 5310-454-430635-957 3 MILE DR INTERCEPTOR 5310-454-430635-961 2ND ALLEY WN - MONT TO CALF SUBTOTAL IMPACT FEE EXPENSE REVENUE BONDS/SANITARY 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.25a 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.250 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25a SUBTOTAL REVENUE BONDS DEPRECIATION -SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION -SANITARY SUBTOTAL SANITARY SEWER 0 34,035 34,035 1000 0 100,000 100,000 1000 59,282 867,087 807,805 930 152,572 ------------ 167,110 ------------- 14,538 ------------------------ 90 211,854 ------------ 1,168,232 ------------- 956,378 ------------------------ 820 0 81,000 81,000 1000 15,345 15,346 2 0 0 0 300 300 1000 ------------ 15, 345 ------------ ------------- 96, 646 ------------- ------------------------ 81,302 ------------------------ 84 0 0 820,000 820,000 1000 ------------ 0 ------------ ------------- 820,000 ------------- ------------------------ 820,000 ------------------------ 1000 964, 245 ------------ 3,586, 946 ------------- 2, 622,701 ------------------------ 73 0 WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 300,042 448,865 148,823 330 5310-455-430640-111 SEASONAL SALARIES 3,629 5,000 1,371 270 5310-455-430640-112 SALARIES -RETIREMENT 14,457 0 14,457- 0% 5310-455-430640-121 OVERTIME 15,373 22,500 7,127 320 5310-455-430640-153 HEALTH INSURANCE 55,805 88,992 33,187 370 5310-455-430640-155 RETIREMENT 23,480 32,463 8,983 280 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 2,897 10,000 7,103 710 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 2,163 2,700 537 200 5310-455-430640-225 ALUM 7,253 20,000 12,747 640 5310-455-430640-226 CHLORINE & CHEMICALS 16,762 19,000 2,238 120 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 3,611 7,000 3,389 480 5310-455-430640-231 GAS & OIL 7,129 18,500 11,371 610 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 321 350 29 80 5310-455-430640-336 LICENSES & FEES 7,438 10,000 2,562 260 5310-455-430640-341 ELECTRICITY 112,188 178,500 66,312 370 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 27 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-342 WATER 2,342 7,500 5,158 690 5310-455-430640-344 NATURAL GAS 37,941 65,000 27,059 420 5310-455-430640-345 TELEPHONE & COMMUNICATION 4,465 5,500 1,035 190 5310-455-430640-353 AUDITING 4,000 4,000 0 0% 5310-455-430640-354 CONTRACT -GLACIER GOLD 88,950 124,000 35,050 280 5310-455-430640-355 OTHER CONTRACT SERVICES 17,645 30,000 12,355 410 5310-455-430640-356 CONSULTANTS 22,532 100,000 77,468 770 5310-455-430640-358 CONSULTANT-TMDL 962 15,000 14,038 940 5310-455-430640-360 MISC. MAINT SERVICES 11,309 30,000 18,691 620 5310-455-430640-366 BUILDING MAINTENANCE 23,181 36,000 12,819 360 5310-455-430640-373 DUES & TRAINING 3,210 7,500 4,290 570 5310-455-430640-388 MEDICAL SERVICES 140 500 360 720 5310-455-430640-510 PROPERTY & LIABILITY INS. 34,985 34,985 0 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 9,909 13,212 3,303 250 5310-455-430640-522 ADMINISTRATIVE TRANSFER 84,178 112,237 28,059 250 5310-455-430640-528 DATA PROCESSING TRANSFER 15,641 27,500 11,859 430 5310-455-430640-921 EVERGREEN SEWER SAMPLING EQUIP & BL 20,611 40,000 19,389 480 ------------ SUBTOTAL WWTP OPERATIONS 954,548 ------------- 1,516,804 ------------ ------------ 562,256 370 ------------ WWTP BONDED PROJECT ------------- ------------------------ ------------ SUBTOTAL WWTP BONDED 0 ------------- 0 ------------ ------------ 0 0% ------------ WWTP REPLACEMENT ------------- ------------------------ 5310-455-430645-362 EQUIPMENT MAINTENANCE 59,478 100,000 40,522 410 5310-455-430645-920 R.A.S. BLD & STORAGE WAREHOUSE ROOF 0 40,000 40,000 1000 5310-455-430645-933 SOLIDS DEWATERING DESIGN & CONST. 998 100,000 99,002 990 5310-455-430645-934 SECONDARY DIGESTER LID INSPECTION 28,798 531,500 502,702 950 5310-455-430645-936 DIGESTED SLUDGET LINE REPLACEMENT 48,929 298,678 249,749 840 5310-455-430645-937 SAND FILTER MAINT & REPLACMENT 0 200,000 200,000 1000 5310-455-430645-940 MACHINERY & EQUIPMENT 48,022 182,500 134,478 740 ------------ SUBTOTAL WWTP REPLACEMENT ------------ 186,225 ------------- 1,452,678 ------------- ------------------------ 1,266,453 ------------------------ 870 WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 71,412 106,284 34,872 330 5310-455-430646-121 OVERTIME 168 0 168- 0% 5310-455-430646-153 HEALTH INSURANCE 10,880 20,932 10,052 480 5310-455-430646-155 RETIREMENT 5,290 7,630 2,340 310 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 1,853 4,500 2,647 590 5310-455-430646-218 NON -CAPITAL EQUIPMENT 2,611 2,500 111- -40 5310-455-430646-222 LAB SUPPLIES 9,132 9,500 368 40 5310-455-430646-349 LAB SERVICES 20,165 29,000 8,835 300 5310-455-430646-362 EQUIPMENT MAINTENANCE 4,479 5,500 1,021 190 5310-455-430646-373 DUES & TRAINING 1,237 3,700 2,463 670 ------------ SUBTOTAL WWTP LAB OPERATIONS 127,226 ------------- 189,546 ------------------------ 62,320 330 DEBT SERVICE - WWTP 5310-455-490227-610 PRIN-WWTP IMP/SRF8164R/2.25a 0 796,000 796,000 1000 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.250 216,405 216,405 0 0% 5310-455-490228-610 PRIN/WWTP DIGESTER LID/SRF13326/3.0 0 44,000 44,000 1000 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 28 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 28,650 28,650 0 0% ------------------------------------------------- SUBTOTAL DEBT SERVICE - WWTP 245,055 1,085,055 840,000 77% ------------------------------------------------- CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-830 EVERGREEN REPLACEMENT TRANSFER 5310-455-510400-831 DEPRECIATION EXPENSE SUTOTAL WWTP DEPRECIATION/REPL SUBTOTAL WWTP TOTAL BILLING/SANITARY/WWTP 0 450,000 450,000 100% 0 1,425,000 1,425,000 100% ------------------------------------------------- 0 1,875,000 1,875,000 100% ------------------------------------------------- 1, 513, 054 6,119, 083 4, 606,029 75 % ------------------------------------------------- 2, 644,037 9, 958,266 7,314,229 73 % ------------------------------------------------ THE CITY OF KALISPELL, MONTANA 04.11.2017 12:49 Page 29 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 11 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. STORM SEWER REVENUE 5349-000-323108-000 PW PLAN REVIEW FEES 900 0 900- 0% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 4,136 2,500 1,636- -65% 5349-000-343033-000 IMPACT FEES 214,287 150,000 64,287- -43% 5349-000-343034-000 PERMIT FEES 1,085 0 1,085- 0% 5349-000-343035-000 STORM SEWER CHARGES 0 1,000 1,000 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 866,987 850,000 16,987- -2% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 1,476 1,000 476- -48% 5349-000-371010-000 INTEREST ON INVESTMENTS 23,804 18,000 5,804- -32% 5349-000-381050-000 INCEPTION OF LEASE 0 382,000 382,000 100% TOTAL STORM REVENUE ------------ 1,112,674 ------------- 1,404,500 ------------ 291,826 ------------ 21% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 241,957 360,758 118,801 33% 5349-453-430246-121 OVERTIME 747 4,000 3,253 81% 5349-453-430246-153 HEALTH INSURANCE 48,869 81,030 32,161 40% 5349-453-430246-155 RETIREMENT 18,097 26,448 8,351 32% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 3,123 10,100 6,977 69% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 2,932 6,550 3,618 55% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 280 2,200 1,920 87% 5349-453-430246-231 GAS & OIL 4,711 11,500 6,789 59% 5349-453-430246-345 TELEPHONE & COMMUNICATION 623 800 177 22% 5349-453-430246-353 AUDITING 1,150 2,340 1,190 51% 5349-453-430246-354 CONTRACT SERVICE 5,895 6,000 105 2% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 10,530 35,000 24,470 70% 5349-453-430246-357 IMPACT FEE UPDATE 20,018 50,000 29,982 60% 5349-453-430246-358 CONSULTANTS 1,128 7,000 5,872 84% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 0 15,000 15,000 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 939 2,500 1,561 62% 5349-453-430246-362 GROUNDWATER MONITORING 2,150 6,500 4,350 67% 5349-453-430246-371 CURB & GUTTER 0 7,000 7,000 100% 5349-453-430246-373 DUES & TRAINING 1,258 5,500 4,242 77% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 0 10,000 10,000 100% 5349-453-430246-510 PROPERTY & LIABILITY INS. 4,842 10,000 5,158 52% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 6,885 9,180 2,295 25% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 29,814 39,752 9,938 25% 5349-453-430246-528 DATA PROCESSING TRANSFER 12,513 13,000 487 4% 5349-453-430246-530 BNSF LEASE PMT 4,790 5,900 1,110 19% 5349-453-430246-532 OFFICE RENT 6,422 6,422 0 0% 5349-453-430246-840 MACI GRANT MATCH (SWEEPER) 0 43,000 43,000 100% 5349-453-430246-921 SAND/COLD MIX STORAGE SHED 1,225 25,771 24,546 95% 5349-453-430246-952 STORM DRAIN CORRECTION 7,389 100,000 92,611 93% 5349-453-430246-953 WILLOWS PRJ FY14/15; SHOP COMPLX PV 0 30,552 30,552 100% 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 501,380 581,400 80,020 14% 5349-453-430246-969 4TH AVE E. REPLACE PHASE 1-4 0 382,000 382,000 100% 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 130,000 130,000 100% 5349-453-510400-831 DEPRECIATION 0 285,000 285,000 100% TOTAL STORM ------------ 939,665 ------------- 2,312,303 ------------ 1,372,638 ------------ 59% 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 30 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SOLID WASTE REVENUE: 5510-000-343360-000 SALE OF MAT/AUCTION 100 0 100- 0% 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 973,929 955,000 18,929- -20 5510-000-343420-000 GARBAGE COLLECTION -BILLED 28,787 21,500 7,287- -340 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 2,127 2,100 27- _1% 5510-000-371010-000 INVESTMENT EARNINGS 6,828 6,000 828- -140 5510-000-382010-000 SALE OF FIXED ASSETS 15,700 ------------ 0 ------------- 15,700- ------------ 0% ------------ TOTAL SOLID WASTE REVENUE 1,027,471 984,600 42,871- -40 SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 276,245 399,776 123,531 310 5510-460-430840-112 SEVERANCE -RETIREMENT 0 60,455 60,455 1000 5510-460-430840-121 OVERTIME 5,041 5,500 459 80 5510-460-430840-153 HEALTH INSURANCE 58,465 106,280 47,815 450 5510-460-430840-155 RETIREMENT 20,704 28,993 8,289 290 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 1,534 9,500 7,966 840 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 37,290 35,000 2,290- -70 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 2,461 5,500 3,039 550 5510-460-430840-231 GAS & OIL 24,568 60,000 35,432 590 5510-460-430840-341 ELECTRICITY 1,091 1,950 859 440 5510-460-430840-344 NATURAL GAS 2,219 4,900 2,681 550 5510-460-430840-345 TELEPHONE & COMMUNICATION 724 850 126 150 5510-460-430840-354 CONTRACT SERVICES 6,758 9,000 2,242 250 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 755 5,700 4,945 870 5510-460-430840-366 BUILDING MAINTENANCE 288 2,500 2,212 880 5510-460-430840-373 DUES & TRAINING 1,041 3,500 2,459 700 5510-460-430840-388 MEDICAL SERVICES 0 650 650 1000 5510-460-430840-510 PROPERTY & LIABILITY INS. 6,799 6,799 0 0% 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 0 4,000 4,000 1000 5510-460-430840-521 CENTRAL GARAGE TRANSFER 57,078 76,104 19,026 250 5510-460-430840-522 ADMINISTRATIVE TRANSFER 27,984 37,311 9,327 250 5510-460-430840-528 DATA PROCESSING TRANSFER 9,384 12,513 3,129 250 5510-460-430840-532 OFFICE RENT 6,422 6,422 0 0% 5510-460-430840-610 DEBT SERVICE PRINCIPAL -GARBAGE TK 38,343 38,343 0- 0% 5510-460-430840-620 DEBT SERVICE INTEREST -GARBAGE TK 1,656 1,801 145 80 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 26,250 35,000 8,750 250 5510-460-430840-922 USFS PROPERTY ACQUISITION 494 43,971 43,477 990 5510-460-430840-940 EQUIPMENT 38,705 48,000 9,295 190 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 1000 5510-460-430845-224 JANITORIAL SUPPLIES 203 250 47 190 5510-460-430845-341 ELECTRICITY 1,338 3,500 2,162 620 5510-460-430845-342 WATER 374 2,000 1,626 810 5510-460-430845-344 NATURAL GAS 3,936 6,500 2,564 390 5510-460-430845-360 REPAIR & MAINT SERVICES 227 3,500 3,273 940 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 1000 TOTAL SOLID WASTE EXPENSE ------------ 658,378 ------------- 1,246,620 ------------------------ 588,242 470 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 31 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 7,500 10,000 2,500 25% 5160-000-343069-000 HANGER LEASES 9,000 11,000 2,000 18% 5160-000-343071-000 HANGAR SITE LEASES 19,132 17,510 1,622- -9% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 12,669 19,145 6,476 34% 5160-000-343102-000 GROUND LEASES 13,198 13,198 0- 0% 5160-000-343620-000 FUEL TAX 1,704 5,000 3,296 66% 5160-000-371010-000 INVESTMENT EARNINGS 1,482 1,000 482- -48% TOTAL AIRPORT REVENUE ------------ 64,686 ------------- 76,853 ------------ 12,167 ------------ 16% 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 100% 1,036 1,500 464 31 % 27,000 36, 000 9,000 25 % 9,850 7,500 2,350- -31% 1,123 10,000 8,877 89% 560 1,000 440 44% 6,418 6,500 82 1 % 1,921 2,562 641 25 % 1,564 2,085 521 25 % 0 97,918 97, 918 100 % ------------------------- 49, 472 166,065 ------------------------ 116,593 70 % 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 32 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING INTERNAL SERVICE FUNDS INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 HB 124 ENTITLEMENT 153,750 205,000 51,250 250 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 86,777 175,000 88,223 500 6030-000-364030-000 SALE OF MISCELLANEOUS 63 0 63- 00 6030-000-371010-000 INVESTMENT EARNINGS 1,246 1,000 246- -250 6030-000-393000-000 INTERNAL SERVICES -DATA 176,742 ------------ 235,655 ------------- 58,913 ------------ 250 ------------ TOTAL INFORMATION TECH REVENUE 418,578 616,655 198,077 320 INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 117,271 167,379 50,108 300 6030-401-410580-121 OVERTIME 1,116 1,000 116- -120 6030-401-410580-153 HEALTH INSURANCE 29,273 44,317 15,044 340 6030-401-410580-155 RETIREMENT 9,235 12,653 3,418 270 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 85 500 415 830 6030-403-410580-215 COMPUTER SUPPLIES 627 2,400 1,773 740 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 11,619 18,963 7,344 390 6030-403-410580-325 WEBSITE 972 16,000 15,028 940 6030-403-410580-345 PAGER/PHONE 1,453 2,500 1,047 420 6030-403-410580-346 SUMMITNET & ISPS 5,967 8,468 2,501 300 6030-403-410580-353 LASER FICHE MAINTENANCE 3,432 3,500 68 20 6030-403-410580-354 MAINTENANCE CONTRACTS 2,142 8,860 6,718 760 6030-403-410580-355 LICENSES 10,748 21,110 10,362 490 6030-403-410580-356 MAINTENANCE CONTRACTS 30,581 47,550 16,969 360 6030-403-410580-357 GRANICUS 7,400 6,690 710- -11% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 4,132 21,235 17,103 810 6030-403-410580-373 DUES & TRAINING 4,770 8,000 3,230 400 6030-403-410580-510 INSURANCE 819 1,778 959 540 6030-403-410583-218 TV -Video Equipment & programming 746 12,900 12,154 940 6030-403-410585-229 COPIER,FAX, SUPPLIES 6,088 19,552 13,464 690 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 57,122 76,000 18,878 250 6030-403-410585-532 COPIER LEASES 10,067 16,182 6,115 380 6030-403-410585-942 Servers - capital contingency 4,861 23,500 18,640 790 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,000 5,000 1000 6030-404-410588-218 COMPUTERS - ATTORNEYS 3,553 4,964 1,411 280 6030-405-410588-940 NETWORK EQUIPMENT CAPITAL 10,794 49,200 38,406 780 6030-410-410588-218 COMPUTERS - DPW 2,345 2,175 170- -80 6030-413-410588-218 COMPUTERS - POLICE DEPT 11,330 28,360 17,030 600 6030-413-410588-354 POLICE - HOSTED SERVER 761 2,000 1,239 620 6030-416-410588-218 COMPUTERS - FIRE 7,926 16,752 8,826 530 6030-420-410588-218 COMPUTERS - PLANNING DEPT 12,312 11,053 1,259- -110 6030-436-410588-218 COMPUTERS - PARKS 4,136 5,165 1,029 200 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 2,155 2,155 1000 TOTAL INFORMATION TECH EXPENSE ------------------------- 373,683 667,861 ------------------------ 294,178 440 04.11.2017 12:49 THE CITY OF KALISPELL, MONTANA Page 33 of 33 gb8501_pg.php/Job No: 53198 USER: RGW FY17 FINANCIAL REPORT JULY 13 2016 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2017 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 382,500 510,000 127,500 25% 6010-000-371010-000 INVESTMENT EARNINGS 539 200 339- -170% TOTAL CENTRAL GARAGE REVENUE ------------ 383,039 ------------ ------------- 510,200 ------------- ------------ 127,161 ------------ ------------ 25% ------------ CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 111,403 160,046 48,643 30% 6010-410-431330-121 OVERTIME 2,288 2,500 213 9% 6010-410-431330-153 HEALTH INSURANCE 25,247 38,827 13,580 35% 6010-410-431330-155 RETIREMENT 8,066 11,505 3,439 30% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 2,045 10,000 7,955 80% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 8,528 12,700 4,172 33% 6010-410-431330-230 OIL 11,969 25,000 13,031 52% 6010-410-431330-231 GAS 222 3,000 2,778 93% 6010-410-431330-232 VEHICLE PARTS 69,100 108,000 38,900 36% 6010-410-431330-233 TIRES 33,491 38,000 4,509 12% 6010-410-431330-238 FILTERS 5,465 7,700 2,235 29% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 1,995 2,000 5 0% 6010-410-431330-341 ELECTRICITY 1,063 1,950 887 45% 6010-410-431330-344 NATURAL GAS 3,639 7,000 3,361 48% 6010-410-431330-354 CONTRACT SERVICES 12,194 30,000 17,806 59% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 370 2,000 1,630 82% 6010-410-431330-373 DUES & TRAINING 5,073 6,200 1,127 18% 6010-410-431330-388 MEDICAL SERVICES 0 300 300 100% 6010-410-431330-510 INSURANCE 1,286 2,750 1,464 53% 6010-410-431330-528 INFORMATION TECH TRANSFER 6,256 8,342 2,086 25% 6010-410-431330-921 4 POST SERVICE LIFT 20,932 26,000 5,068 19% TOTAL CENTRAL GARAGE EXPENSES ------------------------- 330,632 503,820 ------------------------ 173,188 34% ! ME im 1 CL y � e�moommo 0�00000000 00��0�o0o�m�o�o�� om000am o�o�m�mooa �o��o�m0ooa�oom�� 00�o�m� 0�00000000 00oao�00oomm000�� 0o�o0�m� 0�o�moovoo 0a�0o��0oom�mooa� � oomm0omo �oo�om0000 000�0��o0m000m0� 0omo0�0� ��moo�o�om o00�0��00�0000�� 4-1 Ln E E E