Loading...
07-14-17 City Manager ReportfTYOF 0MONONTANOAA CitY of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 7/ 14/2017 1. Police Department Kalispell Police Officer Brooke Pokorney was hired January 10, 2017. On June 30, she graduated from the Montana Law Enforcement Academy Basic Course in Helena, MT. The Course is an intensive 12-week course accredited by the Montana Public Safety Officer Standards and Training (POST) Council. Topics covered include education and training in the following fundamentals of policing: • Law • Human Behavior • Police Function • Patrol Operations • Investigation • Traffic Enforcement • Police Proficiencies Officer Pokorney is now back in Kalispell and continuing her training in the Kalispell Police Departments 13 week Field Training Program. During the week of July 10, four Kalispell Police Officers attended a 40 hour School Resource Officer (SRO) basic course hosted in Kalispell. The officers gained a working knowledge of the School Resource Officer concept and how to establish a lasting partnership within schools. Completion of this course is required of any officer who becomes a Kalispell SRO. The primary topics covered in this training: • Foundations of School Based Law Enforcement • Ethics and the SRO • The SRO as a Teacher/Guest Speaker • Diversity • Understanding Special Needs Students • Social Media • School Law • The SRO as an Informal Counselor/Mentor • Understanding the Teen Brain • Violence and Victimization: Challenges to Development • Sex Trafficking of Youth • Effects of Youth Trends and Drugs on the School Culture and Environment • Threat Response: Preventing Violence in School Settings • School Safety and Emergency Operations Plans • Crime Prevention through Environmental Design The Kalispell Police Department currently has 3 School Resource Officers. The SRO's are stationed at Flathead High School, Glacier High School, and the Kalispell Middle School. However, they provide service to all of the schools within the city limits of Kalispell. 2. Public Works Peterson Alley Sanitary Sewer Replacement Project Construction of the Peterson Alley Sanitary Sewer Replacement Project is anticipated to be completed in the next week. The Peterson Alley ,-�. Sewer Replacement Project is a sanitary sewer replacement project selected to improve the City of Kalispell Sanitary Sewer Collection System. The project is located in Peterson Alley (first alley south of Peterson Elementary School) between South Meridian Road and 1 lth Alley West. Existing sanitary sewer along this alignment varied in pipe size from 8 inch to 4 inch, reducing in diameter as the line extended west. The existing pipe had root intrusion problems and a long history of backups, especially along the smaller diameter sections. Replacement of the existing collection line and manholes will increase system reliability, reduce potential for backups, and reduce collection system infiltration. Pavement Management The Street Division has completed the following major mill and overlay projects. • Stillwater • West Arizona • Northwest Lane • Two Alleys in East North Kalispell Additionally, the following roads received a chip seal in July. Follow-up striping for chip sealed roads will be completed by September. Around 19,829 lineal feet (3.75 miles) of city roads were chip sealed. • 5th Ave W-5th St to 1 Ith St W • Bluestone Drive • South Meadows • Stillwater Road -Reserve to Three Mile Drive • 3rd Ave W — 4th St to 5th St • Champion Way • 5 St E —Main to 1 st Ave E • 4th St West — Main to 2nd Ave W 2 3. Fire Department Since the last update, the Kalispell Fire Department has received 149 calls for service and has conducted 4 outreach trainings with approximately 70 individuals in attendance. It is the time of year when city staff will start handling tall grass and weed complaints. As a review the ordinance reads: 10-8 Removal of Fire Hazards from Private Property Required. It shall be the duty of the owner, representative or contract purchaser, or the occupant of real property within the City to remove all dry grass, readily combustible rubbish or debris from said property so that such material shall not constitute a fire hazard. After July I of each year, all weeds and grasses over eight (8) inches in height constitute a fire hazard for the purposes of this section. (Ord. 1581, 8-7-2005; Ord. 1617, 8-6-2007; Ord. 1753, 3-2-2015) This is especially important this season as the possibilities of a fire ignition are high. With the forecasted weather trend, we will see these conditions worsen. 4. Community Development The Federal Rail Administration is scheduled to formally obligate the USDOT TIGER grant funds for Kalispell's Rail Park and Trail Project on July 31. Local firm, LHC, Inc., was awarded the rail park construction project by City Council pending this obligation of funding. Construction work at the rail park site is set to begin the week of August 21. 5. Information Services IT staff trained departments on the new presentation system in the Council Chambers. The new system is now fully available for use. The projector screen and projector provide improved viewing of computer presentations in the Council Chambers. Staff are awaiting the final lights replacement to resolve lighting issues over the Council dais in the Council Chambers. The spot lights will be turned to correct the bright/dim areas once the new lamps are installed. These corrections are expected prior to the Council meeting on 7/17. IT staff are deploying upgrades to the antivirus program for all computers. The website redesign committee completed the selection process and CivicPlus will redesign the City website. The redesign process will take roughly 4-5 months before the new website goes live. 6. Parks Department Last week, KYAC staff prepared the fields for the annual Firecracker Pee Wee baseball tournament that was held over the 4th of July weekend. Tasks included; edging the skinned surface areas, fertilizing, painting foul lines, garbage can reallocation, string trimming and mowing. With the hot weather their focus has been directed towards irrigation; making repairs and adjusting water settings to accommodate the hot, dry weather. Staff has also been providing supplemental water to newly planted trees that were planted for Arbor Day. Fresh Life Church volunteers painted several bathroom floors as part of their "Rock the City" event on June 25 in Lawrence and Woodland Park. This is a task that is often low priority for park staff so the added help is gladly appreciated. Our Summer Day Camp program has been running close to capacity every day. For the remaining 5 weeks, we have 2,462 participants registered for 2,500 available spots (98.5% full). The kids have also been enjoying some of the new theme days the staff have incorporated. The Woodland Water Park had 168 children participate in swimming lessons during the first session. Our Brookie class (Introduction to Water Skills for 4-5 year olds) and Rainbow class (Basic Skills for 6-8 year olds) were the most popular classes this session. We started our UK International Soccer camp on July 10 at the Kalispell Youth Athletic Complex. Coaches from the U.K work with participants to provide age appropriate curriculums, which includes "Fun in the Sun", "Skills'n' Thrills" and "Compete with your Feet" programs. The camp is at capacity with 75 participants. 7. Building Department Six single family building permits were issued in the past 2 weeks. This brings the total of new housing units for the year to 64 compared to last year at this time when 72 residential building permits had been issued. The permit was issued and construction has started on the new KRMC Digestive Health Institute located at 320 Sunny View Lane. The project is valued at $12.9 million. 8. Planning Department The Planning Board met on Tuesday, July 11 and recommended approval of all six agenda items as follows: 1. A request from Jackola Engineering and Architecture for a conditional use permit for a 3- story, 24-unit apartment building at the southeast corner of the E intersection of Husky Street and Glenwood Drive. 2. A request from Lisa Wade for a conditional use permit for a 6-plex and an 8-plex (14 total) apartment complex at 1613 and 1615 5th Avenue East. 3. A request from Richard and Susan McCadden for a conditional use permit to operate a dance studio at 1322 Whitefish Stage. 4. A request from Herman and Sharon Androes to annex a .67 acre parcel containing a single family house into the City and Zone the land City R-2 upon annexation located at 465 Leisure Drive. 5. A request by Town Pump for PUD approval on a 6.9-acre parcel of land located within B-2/Siderius Commons PUD Placeholder Zoning District to expand their existing fuel station along Cemetery Road at 2910 Highway 93 South. 6. Phase 4 of the Kalispell City Planning Department program to rezone a portion of the Core Area from B-2, B-5 and I-1 to B-3 (Core Area Business) for a 35 acre area (65 owners) bounded on the north by Idaho, the east by 5th Avenue West, the south by 1st Street West and the west by 7th Avenue West. The Board also held a second work session on the Downtown Kalispell Plan. Two people in the public spoke in strong support of the plan and the Board recommended that the Plan was ready for public hearing at the August 8 Planning Board meeting. If all goes well, the plan would then be forwarded to the City Council for final action. In the past month, the plan has been presented to the BID, the Kalispell Parking Commission and forwarded to several hundred individuals on an e-mail contact list. 9. Finance Department Please find attached the printouts reflecting the activity for July 1, 2016 thru June 30, 2017 (FYI 7). All funds are included with the exception of the debt service funds. GOVERNMENTAL FUNDS REVENUES: Most general fund revenues are complete with the following exceptions. General Fund revenue reflects real property tax revenue received from Flathead County thru June 30. Fiscal year 2017 taxes collected by Flathead County before June 30 will be distributed in July, and should be about $500,000 in the general fund. Overall, FYI General Fund revenues should exceed budget slightly. At June 30, 2017, the City is carrying $15,548 in protest taxes in the General Fund, an increase of about $2,000 from the prior fiscal year end. Parks will receive approximately another $90,000 real property tax revenue for fiscal 5 year 2017. Parks has also applied for reimbursement of about $40,000 from the Board of Investments (loan). All other Parks revenues should be complete with maybe some minor adjustments. Ambulance fees for services exceeded last fiscal year by more than $75,000, but were 20% under the budgeted amount ($891,000). The County EMS Levy revenue came in 8% less than expected ($110,000). Overall, ambulance revenues were $189,108 less than the budgeted amount of $1,151,000. Building department revenues were almost 3 times the budgeted amount, and almost 2 times total building department revenues for fiscal year 2016. EXPENDITURES: Keep in mind that these are not final as fiscal year 2017 claims have not all been processed. There will also be a salaries, retirement, and health insurance accrual for June 251h thru the 30th. General fund fiscal year 2017 expenditures are currently $720,970 (7%) under the budgeted amount of $10,880,179. Final fiscal year claims, salaries, retirement, and health accruals should reduce the excess to about $380,000. Total Parks and Recreation Fund expenditures are 12% ($219,881) under fiscal year 2017 budget, which should be more than adequate for accruals and final claims. The ambulance fund and the building department will expend 95% to 100% of their respective fiscal year 2017 budgeted amounts. ENTERPRISE FUNDS REVENUES: Metered water sales were $2,955,958, this is 104% of the budgeted amount. For comparison, last year's metered water sales were $3,307,170. This significant decrease in water sales goes back to the hot and dry fall of 2015. Water impact fees were almost 2.5 times the budgeted amount, and 20% more than last fiscal year. Sewer service charges were $4,528,608, 103% of the budgeted amount. Last fiscal year's sewer service charges were significantly more for the same reason as the water sales. Sanitary sewer and treatment plant impact fees were 428% and 227% of the anticipated fiscal year 2017 amount, respectively. In total, sewer department revenues were $1,270,632 (25%) over the budgeted amounts. EXPENSES: Evaluation of the budget versus actual of the enterprise funds is limited to operating expenses (not including depreciation). 0 The Water Fund operating expenses are currently $349,605 under the budgeted amount. Personal services savings after year end accruals should be about $65,000. Other budget savings of about $30,000 should be seen in energy cost (natural gas, electric, gasoline), contract services ($50,000), and about $70,000 in construction materials expenses. $10,000 was budgeted but not needed for uninsured losses. The Sewer Fund operating expenses are currently $336,495 under the budgeted amount. Personal services savings after year-end accruals should be about $70,000. Other budget savings of about $39,000 should be seen in energy cost (natural gas, electric, gasoline), contract services ($65,000), and uninsured loss ($20,000). Total Storm Sewer Fund operating expenses are currently 20% ($147,289) under fiscal year 2017 budget, which should be more than adequate for accruals and final claims. Total Solid Waste Fund operating expenses are currently 17% ($154,684) under fiscal year 2017 budget. Payroll accruals will use only about another $15,000 to $20,000. 7 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 1 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 5,026,553 5,490,000 463,447 8% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 17,252 17,000 252- -1% 1000-000-311200-000 PERSONAL PROPERTY TAXES 136,907 120,000 16,907- -14% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 6,181 8,000 1,819 23% 1000-000-322101-000 LIQUOR LICENSES 31,813 30,000 1,813- -6% 1000-000-322300-000 BUSINESS LICENSES 1,551 1,700 149 9% 1000-000-323012-000 PLANNING FEES 77,099 30,000 47,099- -157% 1000-000-323109-000 SITE REVIEW 20,331 14,000 6,331- -45% 1000-000-323200-000 PARADE PERMITS 850 1,000 150 15% 1000-000-335030-000 M.V. TAX - AD VALOREM 1,792 2,000 208 10% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 63,350 60,000 3,350- -6% 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,400 2,000 600 30% 1000-000-335230-000 HB124 ENTITLEMENT 2,773,828 2,773,829 1 0% 1000-000-341020-000 ADMINISTRATIVE CHARGES 574,368 574,367 1- 0% 1000-000-341021-000 GRANT ADMIN FEES 0 5,000 5,000 100% 1000-000-341022-000 BOND FEES/ADMIN.CHG. 65,380 0 65,380- 0% 1000-000-341025-000 CITY COLLECTIONS 14,434 5,000 9,434- -189% 1000-000-342010-000 POLICE SERVICES 36,002 25,000 11,002- -44% 1000-000-342014-000 RESOURCE OFFICERS 149,037 149,037 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 1,906 10,000 8,094 81% 1000-000-343018-000 PARKING PERMITS 92,611 95,000 2,389 3% 1000-000-351000-000 CITY COURT FINES & FEES 392,949 500,000 107,051 21% 1000-000-351016-000 DUI COURT FINE 20 0 20- 0% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 29,550 30,000 450 2% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 39,607 35,000 4,607- -13% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 31,969 20,000 11,969- -60% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 4,874 7,500 2,626 35% 1000-000-371010-000 INVESTMENT EARNINGS 19,561 15,000 4,561- -30% 1000-000-373030-000 INTEREST ON OLD SCHOOL SID LOAN - 1 16,250 16,250 0 0% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 901,000 901,000 0 0% TOTAL GENERAL FUND REVENUE 10,528,425 10,937,683 409,258 4% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 2 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 2,935 2,935 0 0% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 14,250 14,250 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 2,380 4,000 1,620 40% 1000-400-410560-312 POSTAGE 13,201 16,000 2,799 17% 1000-400-410560-320 PRINTING & ENVELOPES 2,669 4,500 1,831 41% 1000-400-410560-354 CONTRACT SERVICES - DOC SHREDDING 123 500 378 76% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 2,367 4,000 1,633 41% 1000-400-420000-354 CONTRACT 911 CENTER 472,804 483,000 10,196 2% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 378 425 47 11% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 15,000 15,000 0 0% 1000-400-460452-366 HOCKADAY MAINTENANCE 6,600 6,600 0 0% 1000-400-510300-000 CONTINGENCY 882 30,000 29,118 97% 1000-400-510310-354 ICMA PLAN FEES 500 500 0 0% 1000-400-510330-513 LIABILITY INSURANCE 61,925 61,925 0 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 20,973 50,000 29,027 58% 1000-400-510330-517 PROPERTY INSURANCE 49,965 49,965 0 0% SUBTOTAL GEN.GOV'T. CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 1000-401-410210-153 HEALTH INSURANCE 1000-401-410210-155 RETIREMENT 1000-401-410210-210 COMPUTER SOFTWARE/SUPPLIES 1000-401-410210-312 NEWSLETTER/BOOKS 1000-401-410210-345 TELEPHONE & COMMUNICATION 1000-401-410210-373 DUES & TRAINING 1000-401-410210-379 MEETINGS SUBTOTAL CITY MANAGER HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 1000-401-410830-153 HEALTH INSURANCE 1000-401-410830-155 RETIREMENT 1000-401-410830-210 OFFICE SUPPLIES 1000-401-410830-338 RECRUITMENT/RELOCATION 1000-401-410830-354 CONTRACT SERVICES 1000-401-410830-373 DUES & TRAINING SUBTOTAL HUMAN RESOURCES 666,952 743,600 76,648 10% 132,817 137,795 4,978 4% 20,581 22,706 2,125 9% 14,213 14,569 356 2% 274 1,500 1,226 82% 0 400 400 100% 880 1,080 200 19% 8,750 8,300 450- -5% 3,938 3,400 538- -16% 181,453 189,750 8,297 4% 119,990 123,814 3,824 3% 17,295 19,565 2,270 12% 9,285 9,466 181 2% 447 600 153 25% 5,667 8,000 2,333 29% 2,320 1,000 1,320- -132% 6,182 6,000 182- -3% 161,185 168,445 7,260 4% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 3 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 61,485 63,107 1,622 3% 1000-402-410100-153 HEALTH INSURANCE 52,360 57,698 5,338 9% 1000-402-410100-155 RETIREMENT 2,439 2,445 6 0% 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,690 4,500 1,810 40% 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 134,048 147,610 13,562 9% CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 85,921 88,953 3,032 3% 1000-402-410150-121 OVERTIME 0 250 250 100% 1000-402-410150-153 HEALTH INSURANCE 18,253 20,261 2,008 10% 1000-402-410150-155 RETIREMENT 6,663 6,832 169 2% 1000-402-410150-210 OFFICE SUPPLIES 173 200 27 14% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 35 700 665 95% 1000-402-410150-345 TELEPHONE & COMMUNICATION 440 480 40 8% 1000-402-410150-352 RECODIFICATION 3,944 3,700 244- -7% 1000-402-410150-354 CONTRACT SERVICES 0 300 300 100% 1000-402-410150-373 DUES & TRAINING 2,338 3,200 862 27% SUBTOTAL CITY CLERK 117,766 124,876 7,110 6% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 202,274 210,200 7,926 4% 1000-403-410550-153 HEALTH INSURANCE 36,229 38,445 2,216 6% 1000-403-410550-155 RETIREMENT 15,655 16,121 466 3% 1000-403-410550-210 SUPPLIES 490 300 190- -63% 1000-403-410550-322 BOOKS 0 250 250 100% 1000-403-410550-353 CONTRACT SERVICES 180 2,000 1,820 91% 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 1,277 2,000 723 36% 1000-403-410550-355 BANK CHARGES & FEES 3,151 3,500 349 10% 1000-403-410550-373 DUES & TRAINING 5,048 6,500 1,452 22% SUBTOTAL FINANCE 264,304 279,316 15,012 5% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 4 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 353,981 364,724 10,743 3% 1000-404-411110-153 HEALTH INSURANCE 47,547 52,592 5,045 10% 1000-404-411110-155 RETIREMENT 27,369 29,906 2,537 8% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 819 2,500 1,681 67% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 8,670 8,000 670- -8% 1000-404-411110-345 TELEPHONE & COMMUNICATION 888 1,000 112 11% 1000-404-411110-354 CONTRACT SERVICES 177 5,000 4,823 96% 1000-404-411110-373 DUES & TRAINING 5,695 7,000 1,305 19% SUBTOTAL CITY ATTORNEY 445,146 470,722 25,576 5% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 216,660 226,938 10,278 5% 1000-406-410360-121 OVERTIME 583 0 583- 0% 1000-406-410360-153 HEALTH INSURANCE 40,714 51,568 10,854 21% 1000-406-410360-155 RETIREMENT 16,777 17,373 596 3% 1000-406-410360-210 SUPPLIES 2,961 4,500 1,539 34% 1000-406-410360-320 PRINTING/BOOKS 228 1,500 1,272 85% 1000-406-410360-345 TELEPHONE & COMMUNICATION 87 1,400 1,313 94% 1000-406-410360-353 SECURITY & TECHNOLOGY 42,447 40,000 2,447- -6% 1000-406-410360-354 CONTRACT SERVICES 10,065 5,750 4,315- -75% 1000-406-410360-373 DUES & TRAINING 3,738 6,300 2,562 41% 1000-406-410360-394 JURY & WITNESS FEES 2,816 7,500 4,684 62% SUBTOTAL COURT 337,075 362,829 25,754 7% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 16,914 17,333 419 2% 1000-410-430100-153 HEALTH INSURANCE 2,871 3,278 407 12% 1000-410-430100-155 RETIREMENT 1,293 1,300 7 1% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 6,687 7,500 813 11% 1000-410-430100-231 GAS 2,736 2,500 236- -9% 1000-410-430100-345 TELEPHONE & COMMUNICATION 294 300 6 2% 1000-410-430100-354 CONTRACT SERVICES 1,848 1,850 2 0% 1000-410-430100-373 DUES & TRAINING 2,673 2,500 173- -7% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 3,459 3,459 0 0% SUBTOTAL PUBLIC WORKS ADMIN 38,776 40,020 1,244 3% CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 64,548 67,873 3,325 5% 1000-412-411230-121 OVERTIME 514 0 514- 0% 1000-412-411230-153 HEALTH INSURANCE 12,092 15,847 3,755 24% 1000-412-411230-155 RETIREMENT 4,846 4,980 134 3% 1000-412-411230-220 SECURITY IMPROVEMENTS 728 800 72 9% 1000-412-411230-224 JANITORIAL SUPPLIES 3,332 6,000 2,668 44% 1000-412-411230-241 TOOLS & SUPPLIES 929 1,500 571 38% 1000-412-411230-341 ELECTRICITY 41,966 47,500 5,534 12% 1000-412-411230-344 NATURAL GAS 29,004 40,000 10,996 27% 1000-412-411230-345 TELEPHONE & COMMUNICATION 150 250 100 40% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 5 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-354 CONTRACT SERVICES 10,590 38,500 27,910 72% 1000-412-411230-355 HVAC MAINTENANCE OCNTRACT 15,146 17,300 2,154 12% 1000-412-411230-361 ELEVATOR MAINT/ FIRE ALARM MAINT 4,160 4,500 340 8% 1000-412-411230-362 EQUIPMENT MAINTENANCE 1,746 8,500 6,754 79% 1000-412-411230-366 BUILDING MAINTENANCE 19,569 20,000 431 2% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,351 3,500 149 4% 1000-412-411230-920 Public Safety Bldg - painting 28,057 30,000 1,943 6% SUBTOTAL CITY HALL 240,728 307,050 66,322 22% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 271,683 274,862 3,179 1% 1000-420-411020-153 HEALTH INSURANCE 51,471 59,495 8,024 13% 1000-420-411020-155 RETIREMENT 20,728 21,071 343 2% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 413 5,000 4,587 92% 1000-420-411020-231 GAS 105 400 295 74% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 1,040 2,000 960 48% 1000-420-411020-345 TELEPHONE 1,047 750 297- -40% 1000-420-411020-354 CONTRACT SERVICES 0 1,000 1,000 100% 1000-420-411020-373 DUES & TRAINING 1,619 5,500 3,881 71% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 1,295 1,295 0- -0% SUBTOTAL PLANNING DEPT. 349,400 371,373 21,973 6% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 59,868 61,676 1,808 3% 1000-480-470210-153 HEALTH INSURANCE 7,676 8,243 567 7% 1000-480-470210-155 RETIREMENT 4,628 4,704 76 2% 1000-480-470210-210 OFFICE SUPPLIES 132 1,500 1,368 91% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 594 500 94- -19% 1000-480-470210-312 POSTAGE & PRINTING 71 500 429 86% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 500 500 0 0% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 586 750 164 22% 1000-480-470210-354 CONTRACT SERVICES 324 1,500 1,176 78% 1000-480-470210-373 DUES & TRAINING 4,020 5,000 980 20% 1000-480-470210-379 MEETINGS 220 1,000 780 78% SUBTOTAL COMMUNITY DEVELOPMENT 78,617 85,873 7,256 8% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 6 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 2,077,999 2,114,612 36,613 2% 1000-413-420140-112 SALARIES -SEVERANCE 61,811 33,500 28,311- -85% 1000-413-420140-114 SALARY -comptime buyout 4,445 4,350 95- -2% 1000-413-420140-121 OVERTIME (REG & AET OT) 63,633 80,000 16,367 20% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 3,446 25,000 21,554 86% 1000-413-420140-153 HEALTH INSURANCE 386,777 413,628 26,851 6% 1000-413-420140-155 RETIREMENT 269,725 275,152 5,427 2% 1000-413-420140-210 OFFICE SUPPLIES 3,212 3,500 288 8% 1000-413-420140-215 COMPUTER SUPPLIES 3,969 5,500 1,531 28% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 44,342 48,500 4,158 9% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 3,401 4,000 599 15% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 6,704 7,000 296 4% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 1,395 2,000 605 30% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 4,856 5,000 144 3% 1000-413-420140-227 AMMO & RELATED SUPPLIES 21,236 19,000 2,236- -12% 1000-413-420140-228 PATROL CAR SUPPLIES 15,137 13,000 2,137- -16% 1000-413-420140-229 OTHER SUPPLIES 11,297 10,000 1,297- -13% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 904 1,000 96 10% 1000-413-420140-231 GAS 59,856 95,000 35,144 37% 1000-413-420140-234 CRISIS NEGOTIATIONS 2,012 2,000 12- -1% 1000-413-420140-235 BIKE PATROL 244 750 506 67% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 357 1,500 1,143 76% 1000-413-420140-320 PRINTING 4,668 5,500 832 15% 1000-413-420140-345 TELEPHONE & COMMUNICATION 17,414 15,500 1,914- -12% 1000-413-420140-354 CONTRACT SERVICES 8,691 6,875 1,816- -26% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 5,399 6,500 1,101 17% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 167 2,000 1,833 92% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 2,975 2,000 975- -49% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 40,398 40,625 227 1% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 1,322 2,500 1,178 47% 1000-413-420140-373 DUES & TRAINING 36,457 30,000 6,457- -22% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 1,031 10,000 8,969 90% 1000-413-420140-380 TRAINING MATERIALS 1,140 2,000 860 43% 1000-413-420140-388 MEDICAL SERVICES 2,611 2,500 111- -4% 1000-413-420140-392 BOARDING/TREATING PRISONERS 2,394 2,500 106 4% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 73,717 73,718 1 0% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 67,500 67,500 0 0% 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 60,000 155,000 95,000 61% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 3,500 3,500 0 0% 1000-413-420140-922 USFS PROPERTY ACQUISITION 0 27,482 27,482 100% 1000-413-420140-944 VEHICLES 143,575 115,878 27,697- -24% SUBTOTAL POLICE DEPT. 3,519,716 3,735,570 215,854 6% DETECTIVES 1000-413-420141-110 SALARIES -DETECTIVES 1000-413-420141-121 DETECTIVE -OVERTIME 1000-413-420141-153 HEALTH INSURANCE 1000-413-420141-155 DETECTIVE -RETIREMENT TOTAL DETECTIVES RECORDS 340,108 365,552 25,444 7% 7,278 15,000 7,722 51% 64,603 66,611 2,009 3% 44,813 48,938 4,125 8% 456,802 496,101 39,299 8% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 7 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-110 SALARIES -RECORDS DIVISION 136,871 142,039 5,168 4% 1000-413-420142-121 OVERTIME 3,784 7,500 3,716 50% 1000-413-420142-153 HEALTH INSURANCE 29,621 32,970 3,349 10% 1000-413-420142-155 RETIREMENT 10,767 10,720 47- -0% TOTAL RECORDS 181,043 193,229 12,186 6% RESOURCE OFFICERS 1000-413-420144-110 SALARIES -SRO 177,292 182,257 4,965 3% 1000-413-420144-153 HEALTH INSURANCE 34,179 46,773 12,594 27% 1000-413-420144-155 SRO RETIREMENT 21,935 24,447 2,512 10% TOTAL RESOURCE OFFICERS 233,406 253,477 20,071 8% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL -SALARIES 40,343 38,723 1,620- -4% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 7,480 8,243 763 9% 1000-413-420145-155 RETIREMENT 2,949 2,920 29- -1% SUBTOTAL ANIMAL CONTROL 50,771 50,386 385- -1% PARKING 1000-413-420147-110 PARKINGS -SALARIES 85,557 86,114 557 1% 1000-413-420147-153 HEALTH INSURANCE 23,265 30,585 7,320 24% 1000-413-420147-155 RETIREMENT 6,447 6,494 47 1% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 1,573 4,000 2,427 61% 1000-413-420147-354 CONTRACTED SERVICES 1,859 2,000 141 7% 1000-413-420147-362 LOT MAINT 5,249 10,000 4,751 48% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 22,395 17,500 4,895- -28% 1000-413-420147-550 LOT LEASE PAYMENTS 1,621 1,500 121- -8% SUBTOTAL PARKING 147,966 158,193 10,227 6% SUBTOTAL POLICE DEPT. 4,589,705 4,886,956 297,251 6% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 8 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. FIRE DEPARTMENT 1000-416-420400-110 SALARIES -FIRE SUPPRESSION 1,587,173 1,592,324 5,151 0% 1000-416-420400-114 COMPTIME BUYOUT 3,784 5,500 1,716 31% 1000-416-420400-115 OUT OF RANK PAY 13,057 12,000 1,057- -9% 1000-416-420400-121 OVERTIME 54,477 40,000 14,477- -36% 1000-416-420400-153 HEALTH INSURANCE 273,710 312,701 38,991 12% 1000-416-420400-155 RETIREMENT 211,351 212,650 1,299 1% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 1,353 2,000 647 32% 1000-416-420400-218 Equipment (Non Capital) 13,264 21,500 8,236 38% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 14,770 15,000 230 2% 1000-416-420400-224 JANITORIAL SUPPLIES 2,902 5,000 2,098 42% 1000-416-420400-231 GAS 8,320 17,325 9,005 52% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 10,201 15,000 4,799 32% 1000-416-420400-320 PRINTING 0 200 200 100% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 275 1,000 725 73% 1000-416-420400-345 TELEPHONE & COMMUNICATION 4,523 6,000 1,477 25% 1000-416-420400-354 CONTRACT SERVICES 10,082 12,000 1,918 16% 1000-416-420400-362 EQUIPMENT MAINTENANCE 6,131 5,500 631- -11% 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 7,477 7,500 23 0% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 4,621 5,000 379 8% 1000-416-420400-373 DUES & TRAINING 5,495 10,000 4,505 45% 1000-416-420400-388 FIREFIGHTER PHYSICALS 21,879 25,875 3,996 15% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 43,938 43,938 0- 0% 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 0 40,000 40,000 100% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 150,000 150,000 0 0% 1000-416-420400-821 TRANSFER TO FUND 2956 GRANT MATCH 0 18,454 18,454 100% 1000-416-420400-922 USFS PROPERTY ACQUISITION 0 27,482 27,482 100% 1000-416-420400-940 CAPITAL EQUIPMENT - COMMAND VEHICLE 35,849 35,000 849- -2% 1000-416-420440-110 SALARIES -FIRE PREVENTION 48,382 51,287 2,905 6% 1000-416-420440-114 COMPTIME BUYOUT 325 0 325- 0% 1000-416-420440-121 OVERTIME 8,775 0 8,775- 0% 1000-416-420440-153 HEALTH INSURANCE 7,708 7,826 118 2% 1000-416-420440-155 RETIREMENT 4,229 3,697 532- -14% SUBTOTAL FIRE DEPT. GRAND TOTAL GENERAL FUND SPECIAL REVENUE FUNDS: PERMISSIVE HEALTH LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND TOTAL PERMISSIVE HEALTH LEVY 2,554,053 2,701,759 147,706 5% 10,159,209 10,880,179 720,970 7% 992,000 992,000 0 0% 992,000 992,000 0 0% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 9 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 880,574 970,000 89,426 9% 2215-000-311200-000 PERSONAL PROPERTY TAXES 37,590 35,000 2,590- -7% 2215-000-312000-000 PEN & INTEREST DEL TAXES 1,012 2,000 988 49% 2215-000-346030-000 SWIMMING POOL FEES 123,784 140,000 16,216 12% 2215-000-346040-000 CONCESSION STAND REVENUE 32,875 35,000 2,125 6% 2215-000-346050-000 PARKS USAGE FEES 21,229 21,000 229- -1% 2215-000-346051-000 RECREATION FEES 13,321 8,000 5,321- -67% 2215-000-346052-000 SPORTS PROGRAMS 46,020 45,000 1,020- -2% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 2,759 2,500 259- -10% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 68,266 70,000 1,734 2% 2215-000-346055-000 ICE RINK 20,846 25,000 4,154 17% 2215-000-346056-000 KIDSPORT USAGE 1,973 300 1,673- -558% 2215-000-346057-000 YOUTH CAMPS 146,133 142,000 4,133- -3% 2215-000-346059-000 PICNIC IN THE PARK 25,893 30,000 4,107 14% 2215-000-362015-000 INSURANCE REIMBURSEMENTS 23,816 0 23,816- 0% 2215-000-365010-000 FEC REFUNDS/DONATIONS 15,188 0 15,188- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 25,163 20,000 5,163- -26% 2215-000-371010-000 INVESTMENTS 3,498 2,000 1,498- -75% 2215-000-381050-000 INCEPTION OF LEASE 90,773 130,000 39,227 30% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 91,000 91,000 0 0% TOTAL PARKS & REC REVENUE 1,671,713 1,768,800 97,087 5% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 305,424 316,192 10,768 3% 2215-436-460430-111 SEASONAL SALARIES 57,256 65,276 8,020 12% 2215-436-460430-121 OVERTIME 0 500 500 100% 2215-436-460430-153 HEALTH INSURANCE 55,754 61,643 5,889 10% 2215-436-460430-155 RETIREMENT 26,015 26,136 121 0% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 860 1,000 140 14% 2215-436-460430-224 JANITORIAL SUPPLIES 4,610 5,000 391 8% 2215-436-460430-229 OTHER SUPPLIES 2,816 4,000 1,184 30% 2215-436-460430-231 GAS 13,880 18,000 4,120 23% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 1,619 2,500 881 35% 2215-436-460430-320 PRINTING & ADVERTISING 169 400 231 58% 2215-436-460430-341 ELECTRICITY 12,610 16,000 3,390 21% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 20,918 25,000 4,082 16% 2215-436-460430-344 NATURAL GAS 1,955 3,000 1,045 35% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 2,468 3,040 572 19% 2215-436-460430-351 TENNIS COURT REHABILITATION 0 2,000 2,000 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 2,000 2,000 100% 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 4,920 5,000 80 2% 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 0 2,680 2,680 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 3,686 5,000 1,314 26% 2215-436-460430-364 LANDSCAPING 5,444 5,500 56 1% 2215-436-460430-367 VANDALISM REPAIRS 46,867 4,000 42,867- -1,072% 2215-436-460430-373 DUES & TRAINING 5,255 6,000 745 12% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 151 600 450 75% 2215-436-460430-395 EQUIPMENT RENTAL 301 500 200 40% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 2,821 3,000 179 6% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 10 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-440 IRRIGATION SUPPLIES 6,632 9,000 2,368 26% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 569 1,700 1,131 67% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 43,857 43,857 0 0% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 9,112 29,112 20,000 69% 2215-436-460430-620 DEBT SERVICE INTEREST 327 784 457 58% 2215-436-460430-941 CAPITAL OUTLAY: FLATBED, MOWER, WOO 127,824 137,000 9,176 7% SUBTOTAL PARKS EXPENDITURES 764,120 805,420 41,300 5% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 2215-436-460440-111 SEASONAL SALARIES 2215-436-460440-153 HEALTH INSURANCE 2215-436-460440-155 RETIREMENT 2215-436-460440-221 SAFETY EQUIPMENT 2215-436-460440-229 OTHER SUPPLIES 2215-436-460440-231 GAS 2215-436-460440-241 CONSUMABLE TOOLS 2215-436-460440-341 ELECTRICITY 2215-436-460440-345 TELEPHONE & COMMUNICATION 2215-436-460440-354 CONTRACT SERVICES 2215-436-460440-355 CONTRACT SERVICES - ASPHALT RESURFC 2215-436-460440-362 EQUIPMENT MAINTENANCE 2215-436-460440-364 LANDSCAPING 2215-436-460440-367 VANDALISM REPAIRS 2215-436-460440-373 DUES & TRAINING 2215-436-460440-395 RENTAL EQUIPMENT 2215-436-460440-420 METAL PRODUCTS 2215-436-460440-440 IRRIGATION 2215-436-460440-452 SAND & GRAVEL 2215-436-460440-940 EQUIPMENT SUBTOTAL ATHLETIC COMPLEX 66,694 89,153 22,459 25% 38,891 41,906 3,015 7% 14,589 25,922 11,333 44% 7,262 10,046 2,784 28% 26 350 324 93% 15,385 15,500 115 1% 4,825 10,500 5,675 54% 1,399 1,500 101 7% 6,004 7,700 1,696 22% 146 175 29 17% 0 1,000 1,000 100% 42,274 40,534 1,740- -4% 434 600 166 28% 548 600 52 9% 300 500 200 40% 401 500 99 20% 0 150 150 100% 0 300 300 100% 3,915 4,000 85 2% 32 1,000 968 97% 23,988 24,000 12 0% 227,112 275,936 48,824 18% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 78,028 81,678 3,650 4% 2215-436-460431-111 SEASONAL SALARIES 6,440 8,285 1,845 22% 2215-436-460431-153 HEALTH INSURANCE 18,409 23,906 5,497 23% 2215-436-460431-155 RETIREMENT 5,997 6,705 708 11% 2215-436-460431-229 MISC. SUPPLIES 7,293 9,435 2,142 23% 2215-436-460431-231 GAS 590 590 0 0% 2215-436-460431-320 PRINTING & ADVERTISING 10,746 10,800 54 1% 2215-436-460431-345 TELEPHONE & COMMUNICATION 688 1,661 973 59% 2215-436-460431-354 CONTRACT SERVICES 18,720 19,093 373 2% 2215-436-460431-357 MUSIC FRANCHISE FEES 1,042 1,100 58 5% 2215-436-460431-373 DUES & TRAINING 509 728 219 30% SUBTOTAL RECREATION 148,460 163,981 15,521 9% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 69,346 72,793 3,447 5% 2215-436-460448-111 SEASONAL SALARIES 102,413 136,855 34,442 25% 2215-436-460448-121 OVERTIME 0 300 300 100% 2215-436-460448-153 HEALTH INSURANCE 17,350 22,953 5,603 24% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 11 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460448-155 RETIREMENT 5,325 6,424 1,099 17% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 208 400 192 48% 2215-436-460448-229 MISC. SUPPLIES 1,098 3,600 2,502 70% 2215-436-460448-231 GAS 266 300 34 11% 2215-436-460448-320 PRINTING & ADVERTISING 0 100 100 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 1,029 765 264- -35% 2215-436-460448-354 CONTRACT SERVICES 8,666 13,000 4,334 33% 2215-436-460448-355 AFTER SCHOOL PROGRAM 1,554 800 754- -94% 2215-436-460448-356 BANK FEES/CC CHARGES 3,685 3,900 215 6% 2215-436-460448-373 DUES & TRAINING 591 800 209 26% SUBTOTAL YOUTH CAMPS 211,530 262,990 51,460 20% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 154,192 190,325 36,133 19% 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 1,182 1,500 318 21% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 42 400 358 90% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 2,029 2,200 171 8% 2215-437-460445-226 CHLORINE/CHEMICALS 27,105 25,000 2,105- -8% 2215-437-460445-228 CONCESSION STAND SUPPLIES 16,008 21,000 4,992 24% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 963 4,500 3,537 79% 2215-437-460445-341 ELECTRICITY 6,432 9,500 3,068 32% 2215-437-460445-344 NATURAL GAS 15,988 25,000 9,012 36% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,697 1,620 77- -5% 2215-437-460445-354 LICENSES & FEES 590 1,300 710 55% 2215-437-460445-356 BANK FEES/ CC CHARGES 1,172 1,200 28 2% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 11,163 14,600 3,437 24% 2215-437-460445-380 TRAINING MATERIALS 1,454 1,800 346 19% SUBTOTAL POOL EXPENDITURES 240,204 302,980 62,776 21% TOTAL PARKS & RECREATION/POOL 1,591,426 1,811,307 219,881 12% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 12 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING FORESTRY & DEVELOPER TREES 2600-436-460433-110 SALARIES -URBAN FORESTRY 98,680 107,421 8,741 8% 2600-436-460433-111 SEASONAL SERVICES 11,536 25,731 14,195 55% 2600-436-460433-121 OVERTIME 0 300 300 100% 2600-436-460433-153 HEALTH INSURANCE 19,714 24,764 5,050 20% 2600-436-460433-155 RETIREMENT 7,484 9,713 2,229 23% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 41 600 559 93% 2600-436-460433-231 GAS 1,345 4,500 3,155 70% 2600-436-460433-241 CONSUMABLE TOOLS 3,196 4,500 1,304 29% 2600-436-460433-354 CONTRACT SERVICES 26,020 35,000 8,980 26% 2600-436-460433-357 FORESTRY GRANT 9,899 11,880 1,981 17% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 3,500 6,750 3,250 48% 2600-436-460433-362 EQUIPMENT MAINTENANCE 336 4,000 3,664 92% 2600-436-460433-364 LANDSCAPING & TREES 4,834 8,000 3,166 40% 2600-436-460433-373 DUES & TRAINING 1,830 2,000 170 9% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 628 628 0 0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 7,368 7,368 0- 0% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 8,271 8,272 1 0% 2600-436-460433-528 DATA PROCESSING TRANSFER 4,171 4,171 0 0% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 10,824 15,000 4,176 28% 2600-436-460433-620 INTEREST EXPENSE 665 1,000 335 34% 2600-436-460433-940 MACHINERY & EQUIPMENT 0 40,000 40,000 100% TOTAL URBAN FORESTRY 220,342 321,598 101,256 31% 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 2601-436-460435-369 GL VILLAGE GREENS, Ph 22B ($4,130) TOTAL DEVELOPER TREES 2210 PARKS IN LIEU 2210-436-460430-934 CAPITAL IMPROVEMENTS TOTAL PARKS IN LIEU 0 8,653 8,653 100% 0 4,336 4,336 100% 0 366 366 100% 0 11,231 11,231 100% 0 667 667 100% 0 1,928 1,928 100% 1,300 16,236 14,936 92% 1,950 27,079 25,129 93% 2,219 2,219 0 0% 0 948 948 100% 0 1,390 1,390 100% 650 1,134 484 43% 0 2,797 2,797 100% 0 8,490 8,490 100% 0 2,716 2,716 100% 0 8,812 8,812 100% 2,656 0 2,656- 0% 8,775 99,002 90,227 91% 0 1,417 1,417 100% 0 1,417 1,417 100% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 13 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 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 710,158 891,000 180,842 20% 2230-000-342070-000 COUNTY EMS LEVY 101,734 110,000 8,266 8% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 150,000 150,000 0 0% TOTAL AMBULANCE REVENUE 961,892 1,151,000 189,108 16% AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 603,191 608,459 5,268 1% 2230-440-420730-114 COMPTIME BUYBACK 2,168 3,500 1,332 38% 2230-440-420730-115 OUT OF RANK PAY 1,602 1,000 602- -60% 2230-440-420730-121 OVERTIME 54,478 50,000 4,478- -9% 2230-440-420730-153 HEALTH INSURANCE 133,089 159,142 26,053 16% 2230-440-420730-155 RETIREMENT 81,923 80,552 1,371- -2% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 844 1,000 156 16% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 4,108 4,000 108- -3% 2230-440-420730-231 GAS & OIL 5,337 7,560 2,223 29% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 332 4,000 3,668 92% 2230-440-420730-312 POSTAGE/PRINTING 32 1,500 1,468 98% 2230-440-420730-345 TELEPHONE & COMMUNICATION 1,660 1,200 460- -38% 2230-440-420730-354 CONTRACT SERVICES 14,589 17,800 3,211 18% 2230-440-420730-355 911 CENTER CONTRIBUTION 34,000 34,000 0 0% 2230-440-420730-359 AUDIT/CC OTHER FEES 3,448 1,400 2,048- -146% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 5,000 5,000 0 0% 2230-440-420730-373 DUES & TRAINING 2,666 5,000 2,334 47% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,500 2,500 100% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 30,015 46,000 15,985 35% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 7,614 7,614 0 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 16,229 16,229 0 0% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 42,099 42,099 0 0% 2230-440-420730-528 DATA PROCESSING TRANSFER 16,684 16,684 0 0% 2230-440-420730-940 EQUIPMENT 169,707 170,000 293 0% TOTAL AMBULANCE EXPENDITURES 1,230,816 1,286,239 55,423 4% 2399 PUBLIC SAFETY IMPACT FEES 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 10,000 10,000 0 0% 2399-413-420140-940 POLICE EQUIPMENT 0 60,000 60,000 100% 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 65,500 65,500 0 0% 2399-416-420400-620 INTEREST - FIRE TRUCK 4,632 4,651 19 0% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 500,000 500,000 100% TOTAL PUBLIC SAFETY IMPACT FEE 80,132 640,151 560,019 87% FIRE & HAZMAT GRANTS 2956-416-420400-218 EQUIPMENT (NON CAPITAL) 0 2,200 2,200 100% 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 2,685 3,000 315 10% 2956-416-420415-940 AFG GRT (POWER COTS) EMW2014FOO5022 0 225,000 225,000 100% TOTAL FIRE GRANTS 2,685 230,200 227,515 99% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 14 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2957-416-420400-155 RETIREMENT 0 2,500 2,500 100% 2957-416-420410-125 PASS THRU HAZMAT OT 13,055 19,365 6,310 33% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 17,392 33,113 15,721 47% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 2,130 6,100 3,970 65% TOTAL HAZMAT GRANTS 32,576 61,078 28,502 47% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 15 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 931,311 350,000 581,311- -166% 2394-000-323103-000 PLUMBING PERMITS 36,020 20,000 16,020- -80% 2394-000-323104-000 MECHANICAL PERMITS 41,595 30,000 11,595- -39% 2394-000-323105-000 ELECTRICAL PERMITS 89,355 30,000 59,355- -198% 2394-000-323108-000 PLAN REVIEW FEES 460,233 100,000 360,233- -360% 2394-000-371010-000 INVESTMENT EARNINGS 13,438 4,500 8,938- -199% TOTAL REVENUE 1,571,952 534,500 1,037,452- -194% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 358,038 374,578 16,540 4% 2394-420-420530-121 OVERTIME 13,922 5,000 8,922- -178% 2394-420-420530-153 HEALTH INSURANCE 66,782 85,277 18,495 22% 2394-420-420530-155 RETIREMENT 27,406 27,529 123 0% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 26,828 20,000 6,828- -34% 2394-420-420530-231 GAS & OIL 2,877 3,500 623 18% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 1,003 2,500 1,497 60% 2394-420-420530-323 ST. ED. ASSESSMENTS 4,546 3,000 1,546- -52% 2394-420-420530-345 TELEPHONE & COMMUNICATION 3,290 3,500 210 6% 2394-420-420530-353 AUDITING 1,000 0 1,000- 0% 2394-420-420530-354 CONTRACT SERVICES 35,800 43,500 7,700 18% 2394-420-420530-355 CITY WORKS LICENSING FEE 15,156 15,000 156- -1% 2394-420-420530-373 DUES & TRAINING 13,318 9,000 4,318- -48% 2394-420-420530-510 PROPERTY INSURANCE 2,585 2,585 0 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 1,453 1,454 1 0% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 16,282 16,282 0 0% 2394-420-420530-528 DATA PROCESSING TRANSFER 32,225 29,196 3,029- -10% 2394-420-420530-944 VEHICLES 63,145 65,000 1,855 3% TOTAL BUILDING DEPT. 685,656 706,901 21,245 3% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 16 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 68,853 70,405 1,552 2% 2400-410-430263-153 HEALTH INSURANCE 10,299 13,628 3,329 24% 2400-410-430263-155 RETIREMENT 5,074 5,141 67 1% 2400-410-430263-244 STREET LIGHT SUPPLIES 5,760 18,000 12,240 68% 2400-410-430263-341 ELECTRICITY 141,533 173,000 31,467 18% 2400-410-430263-360 REPAIR & MAINT SERVICES 8,137 20,000 11,863 59% 2400-410-430263-510 INSURANCE 392 1,000 608 61% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 12,648 12,648 0 0% 2400-410-430263-920 NEW LUMINAIRES 500 30,000 29,500 98% 2400-410-490500-610 DEBT SERVICE -PRINCIPAL 21,862 21,862 0 0% 2400-410-490500-620 DEBT SERVICE -INTEREST EXPENSE 596 681 85 13% TOTAL LIGHT MAINT. 275,652 366,365 90,713 25% 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 11,928 56,485 44,557 79% 2420-421-430234-957 ALLEY PAVING 38,750 41,627 2,877 7% 2420-421-430240-231 GAS & OIL 29,976 43,000 13,024 30% 2420-421-430240-344 NATURAL GAS 4,600 5,500 900 16% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 100% 2420-421-430240-360 REPAIR & MAINT SERVICES 900 1,500 600 40% 2420-421-430240-368 OVERLAY/CHIPSEALS 106,489 225,562 119,073 53% 2420-421-430240-452 GRAVEL 0 3,500 3,500 100% 2420-421-430240-453 EQUIPMENT RENTAL 1,410 5,000 3,590 72% 2420-421-430240-471 DE-ICER/ROAD OIL 26,087 40,000 13,913 35% 2420-421-430240-472 ASPHALT 31,817 53,000 21,183 40% 2420-421-430240-473 CRACK SEALING 4,362 14,500 10,138 70% 2420-421-430240-474 PAINT STRIPING MATERIALS 5,342 60,000 54,658 91% TOTAL GAS TAX 261,660 569,674 308,014 54% 2825 MACI GRANT 2825-421-430240-940 SANDER / SWEEPER 0 433,202 433,202 100% TOTAL MACI GRANT 0 433,202 433,202 100% 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 658,569 709,550 50,981 7% 2500-421-430240-121 OVERTIME 35,135 25,000 10,135- -41% 2500-421-430240-153 HEALTH INSURANCE 134,460 172,495 38,035 22% 2500-421-430240-155 RETIREMENT 51,013 51,452 439 1% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 4,431 9,000 4,569 51% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 6,183 6,500 317 5% 2500-421-430240-220 OTHER SUPPLIES 4,391 4,500 109 2% 2500-421-430240-231 GAS & OIL 31,569 40,000 8,431 21% 2500-421-430240-341 ELECTRICITY 2,563 3,300 737 22% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 1,176 1,500 324 22% 2500-421-430240-354 CONTRACT SERVICES 10,768 30,000 19,232 64% 2500-421-430240-356 CONSULTANT - TRANSPORTATION PLAN UP 0 62,892 62,892 100% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 28,702 32,500 3,798 12% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 17 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. 2500-421-430240-366 BUILDING MAINTENANCE 3,000 3,000 0- -0% 2500-421-430240-373 DUES & TRAINING 2,203 5,500 3,297 60% 2500-421-430240-388 MEDICAL SERVICES 420 1,500 1,080 72% 2500-421-430240-510 LIABILITY INSURANCE 13,578 13,578 0 0% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 165 10,000 9,835 98% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 179,219 179,219 0 0% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 90,571 90,571 0- 0% 2500-421-430240-528 DATA PROCESSING TRANSFER 12,513 12,513 0 0% 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 111,946 111,946 0- 0% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 3,016 3,447 431 13% 2500-421-430240-920 SALT BRINE TANK 8,950 20,000 11,050 55% 2500-421-430240-921 SAND/COLD MIX STORAGE SHED 35,145 25,771 9,374- -36% 2500-421-430240-922 USFS PROPERTY ACQUISITION 604 54,964 54,360 99% 2500-421-430240-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 2500-421-430240-969 4TH AVE E MAIN REPLC PHASE 1-4 0 1,114,018 1,114,018 100% 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 280,142 762,359 482,217 63% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 251,137 300,544 49,407 16% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 100% 2500-421-430264-110 TSS - SALARIES 118,120 122,685 4,565 4% 2500-421-430264-121 OVERTIME 607 7,500 6,893 92% 2500-421-430264-153 HEALTH INSURANCE 14,922 17,485 2,563 15% 2500-421-430264-155 RETIREMENT 8,629 8,823 194 2% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 1,822 1,500 322- -21% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,419 6,700 5,281 79% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 2,279 3,500 1,221 35% 2500-421-430264-242 STREET SIGNS 19,230 40,000 20,770 52% 2500-421-430264-243 TRAFFIC SIGNALS 8,534 19,000 10,466 55% 2500-421-430264-245 BARRICADE MATERIALS 5,229 5,000 229- -5% 2500-421-430264-341 ELECTRICITY 1,721 3,000 1,279 43% 2500-421-430264-345 COMMUNICATIONS 675 750 75 10% 2500-421-430264-354 CONTRACT SERVICES 3,314 10,000 6,686 67% 2500-421-430264-362 EQUIPMENT MAINTENANCE 791 3,000 2,209 74% 2500-421-430264-366 BUILDING MAINTENANCE 1,907 2,000 93 5% 2500-421-430264-373 DUES & TRAINING 3,100 5,500 2,400 44% 2500-421-430264-428 PAINT MATERIALS 3,583 8,000 4,418 55% 2500-421-430264-510 LIABILITY INS.-TSS 1,604 1,604 0 0% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 9,838 2,500 7,338- -294% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 7,934 7,934 0 0% 2500-421-430264-532 OFFICE RENT 6,422 6,422 0 0% TOTAL SPEC. ST. MAINT. 2,183,247 4,198,902 2,015,655 48% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 18 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 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 9,243 9,243 0- 0% 2185-000-430300-840 REDEVELOPMENT ACTIVITY 0 1,750,000 1,750,000 100% 2185-480-470240-110 SALARIES 18,980 20,256 1,276 6% 2185-480-470240-153 HEALTH INSURANCE 2,716 2,935 219 7% 2185-480-470240-155 RETIREMENT 1,467 1,526 59 4% 2185-480-470240-345 TELEPHONE & COMMUNICATION 48 48 0 0% TOTAL AIRPORT TIF 34,346 1,785,608 1,751,262 98% 2188 WESTSIDE TIF 2188-480-470230-110 SALARIES 40,707 43,983 3,276 7% 2188-480-470230-153 HEALTH INSURANCE 4,960 5,558 598 11% 2188-480-470230-155 RETIREMENT 3,146 3,337 191 6% 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 192 0 192- 0% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 3,464 3,464 0- -0% 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 9,700 0 9,700- 0% 2188-480-470230-840 TRANSFER TO DEBT SERVICE 32,340 32,340 0 0% 2188-480-470240-720 PRE AWARD TIGER 198,513 4,000,000 3,801,487 95% TOTAL WESTSIDE TIF 295,023 4,095,682 3,800,660 93% OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 10,841 11,500 659 6% 2310-480-470210-356 FED -EX REIMBURSEMENT 10,282 11,000 718 7% 2310-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 35,000 35,000 0 0% 2311-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 15,000 15,000 0 0% TOTAL OLD SCHOOL TIFS 71,123 72,500 1,377 2% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 19 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 1,000 1,000 0 0% 2880-480-470210-354 CONTRACT SERVICES 380 1,000 620 62% 2880-480-470210-711 REDEVELOPMENT 50,018 150,000 99,982 67% TOTAL LOAN REVOLVING 51,398 152,000 100,602 66% 2881 CD LOAN REV. #2 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 2881-480-470210-711 REDEVELOPMENT 2886-480-470210-210 2886-480-470210-353 2886-480-470210-373 2886-480-470210-379 2886-480-470210-396 2886-480-470210-522 2886-480-470210-528 2886-480-470210-532 2886-480-470210-620 2886-480-470210-790 2886-480-470210-795 2887-480-470210-354 2887-480-470210-610 2887-480-470210-620 2887-480-470210-750 2888-480-470210-354 2888-480-470210-610 2888-480-470210-620 2888-480-470210-750 TOTAL 2881 CD REV. #2 2886 CD MISC. OFFICE SUPPLIES AUDITING DUES & TRAINING MEETINGS GRANT SERVICES ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER OFFICE RENT INTEREST - OLD SCHOOL LOAN - GENERA COMM. DEV. ACTIVITIES REDEVELOPMENT- OLD SCHOOL STATION TOTAL CD MISC. 2887 RURAL DEVELOPMENT #1 CONT SERV (LOAN SOFTWARE) DEBT SERVICE/PRIN-L#61-01 INTEREST EXPENSE/L#61-01 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT #1 2888 RURAL DEVELOPMENT #2 CONT SERV (LOAN SOFTWARE) DEBT SERVICE/PRIN-L#61-03 INTEREST EXPENSE -USDA LOAN 61-03 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT #2 335 0 335- 0% 0 150,000 150,000 100% 335 150,000 149,665 100% 0 2,000 2,000 100% 1,000 1,000 0 0% 55 2,000 1,945 97% 0 1,000 1,000 100% 0 25,000 25,000 100% 2,000 2,000 0 0% 8,342 8,342 0 0% 1,175 1,175 0 0% 16,250 16,250 0 0% 2,905 100,000 97,095 97% 175,113 183,750 8,637 5% 206,840 342,517 135,677 40% 340 0 340- 0% 18,272 18,272 0- 0% 3,802 3,803 1 0% 0 150,000 150,000 100% 22,414 172,075 149,661 87% 335 0 335- 0% 8,138 8,135 3- -0% 1,887 1,890 3 0% 0 110,000 110,000 100% 10,360 120,025 109,665 91% 2953 EPA BROWNFIELDS 2953-480-470210-354 PETROLEUM 3,723 200,000 196,277 98% 2953-480-470210-373 TRAVEL/PETROLEUM 643 0 643- 0% 2953-480-470215-354 HAZARDOUS 3,723 200,000 196,277 98% 2953-480-470215-373 TRAVEL/HAZARDOUS 483 0 483- 0% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 20 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. TOTAL EPA BROWNSFIELD 8,572 400,000 391,428 98% 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES -PETROLEUM 0 908 908 100% 2955-480-470210-352 PERSONNEL -PETROLEUM 0 3,505 3,505 100% 2955-480-470210-353 FRINGES -PETROLEUM 0 493 493 100% 2955-480-470210-354 CONTRACTED SERVICES-PETROLUEM 0 1,488 1,488 100% 2955-480-470210-373 TRAVEL -PETROLEUM 35 35 0- -1% 2955-480-470210-720 CLEANUP LOANS -PETROLEUM 0 62,354 62,354 100% 2955-480-470210-721 CLEANUP SUBGRANTS-PETRO 0 100,000 100,000 100% 2955-480-470210-725 REVOLVED FUNDS -PETROLEUM 0 100,500 100,500 100% 2955-480-470215-229 SUPPLIES -HAZARDOUS SUBSTANCES 0 1,158 1,158 100% 2955-480-470215-354 CONTRACT SERV-HAZARDOUS SUBST 0 88 88 100% 2955-480-470215-373 TRAVEL -HAZARDOUS SUBTSANCE 1,447 3,778 2,331 62% 2955-480-470215-720 CLEANUP LOANS -HAZARDOUS 0 314,600 314,600 100% TOTAL BROWNFIELDS LOAN REV. 1,483 588,907 587,424 100% 2991 TIGER GRANT 2991-480-470245-790 REDEVELOPMENT 0 10,000,000 10,000,000 100% TOTAL TIGER GRANT 0 10,000,000 10,000,000 100% 2994 KIDSPORTS GRANT 2994-436-460436-930 CAPITAL IMPROVEMENTS 722,690 2,152,726 1,430,036 66% TOTAL KIDSPORTS GRANT 722,690 2,152,726 1,430,036 66% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 21 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD /2015 GRT 5,575 31,255 25,680 82% 2915-413-420140-218 SMALL EQUIP - 2015 STONEGARDEN 38,851 25,000 13,851- -55% 2915-413-420140-354 CONT SERV-WPD/MHP/MFWPE-2015 GRT 47,661 38,815 8,846- -23% TOTAL 2915 STONEGARDEN GRANT 92,087 95,070 2,983 3% 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 58,148 60,926 2,778 5% 2916-413-420140-121 OVERTIME 8,920 7,500 1,420- -19% 2916-413-420140-153 HEALTH INSURANCE 13,766 17,541 3,775 22% 2916-413-420140-155 RETIREMENT 7,715 8,167 453 6% 2916-413-420140-354 CONTRACT SERVICES 5,208 5,841 633 11% TOTAL 2916 DRUG ENFORCEMENT 93,757 99,975 6,218 6% 2918 CHRP GRANT 2918-413-420140-110 SALARIES & PAYROLL COSTS 56,191 140,287 84,096 60% 2918-413-420140-153 HEALTH INSURANCE 7,264 32,606 25,342 78% 2918-413-420140-155 RETIREMENT 7,369 18,857 11,488 61% TOTAL CHRP GRANT 70,824 191,750 120,926 63% 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 2,684 4,000 1,316 33% 2919-413-420140-125 DUI TASK FORCE 0 8,000 8,000 100% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 26,779 36,000 9,221 26% 2919-413-420140-127 SCHOOL DIST. OT 16,305 20,000 3,695 18% 2919-413-420140-218 SAG&MDOT GRTS-WATCHGUARD CAMERAS 10,904 12,000 1,096 9% 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 3,577 2,500 1,077- -43% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 6,924 7,000 76 1% TOTAL LAW ENF. GRANT 67,173 89,500 22,327 25% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 22 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CAPITAL PROJECT FUNDS 4150 FIRE PUMPER 4150-416-420400-944 PUMPER TRUCK TOTAL 4150 FIRE PUMPER 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION TOTAL 4290 WALK & CURB 0 500,000 500,000 100% 0 500,000 500,000 100% 6,310 25,000 18,690 75% 6,310 25,000 18,690 75% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 23 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. ENTERPRISE FUNDS WATER REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 1,755 0 1,755- 0% 5210-000-331158-000 STATE BYPASS RELOCATION REIMB. 1,876 0 1,876- 0% 5210-000-343210-000 METERED WATER SALES 2,955,958 2,850,000 105,958- -4% 5210-000-343220-000 UNMETERED WATER SALES 12,082 0 12,082- 0% 5210-000-343225-000 IMPACT FEES 704,557 285,000 419,557- -147% 5210-000-343230-000 METER REPLACEMENT FEE 98,964 98,000 964- -1% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 44,003 74,000 29,997 41% 5210-000-343265-000 IMPACT ADMIN FEES 0 15,000 15,000 100% 5210-000-343270-000 WATER TURN ON FEES 7,795 0 7,795- 0% 5210-000-343275-000 TAG FEE 67,220 0 67,220- 0% 5210-000-371010-000 INVESTMENT EARNINGS 88,718 46,000 42,718- -93% 5210-000-381050-000 INCEPTION OF LEASE 0 2,435,627 2,435,627 100% TOTAL WATER REVENUE 3,982,927 5,803,627 1,820,700 31% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 680,467 702,293 21,826 3% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 8,015 20,000 11,985 60% 5210-447-430550-153 HEALTH INSURANCE 137,048 168,225 31,177 19% 5210-447-430550-155 RETIREMENT 50,731 51,002 271 1% 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 5,680 11,000 5,320 48% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 7,093 8,500 1,407 17% 5210-447-430550-226 CHLORINE & CHEMICALS 25,684 38,000 12,316 32% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 4,165 4,500 335 7% 5210-447-430550-231 GAS & OIL 21,226 38,000 16,774 44% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 156 4,000 3,844 96% 5210-447-430550-336 LICENSES & FEES 16,250 18,500 2,250 12% 5210-447-430550-341 ELECTRICITY 122,713 150,000 27,287 18% 5210-447-430550-344 NATURAL GAS 9,997 15,500 5,503 36% 5210-447-430550-345 TELEPHONE & COMMUNICATION 9,353 9,000 353- -4% 5210-447-430550-349 LAB SERVICES 22,999 26,000 3,001 12% 5210-447-430550-353 AUDITING 5,000 5,000 0 0% 5210-447-430550-354 CONTRACT SERVICES 29,184 65,000 35,816 55% 5210-447-430550-356 CONSULTANTS-WTR RIGHTS/MODELING 2,888 25,000 22,112 88% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 8,524 15,000 6,476 43% 5210-447-430550-366 BUILDING MAINTENANCE 5,107 12,000 6,893 57% 5210-447-430550-373 DUES & TRAINING 6,188 9,000 2,812 31% 5210-447-430550-388 MEDICAL SERVICES 193 800 608 76% 5210-447-430550-410 CONSTRUCTION MATERIALS 17,297 35,000 17,703 51% 5210-447-430550-422 HYDRANTS 8,176 8,000 176- -2% 5210-447-430550-423 MATERIALS FOR MAINS 7,572 14,000 6,428 46% 5210-447-430550-424 MATERIALS -SERVICE LINES 5,473 14,000 8,527 61% 5210-447-430550-425 MATERIALS PUMPS/WELLS 6,612 45,000 38,388 85% 5210-447-430550-510 PROPERTY & LIABILITY INS. 15,468 15,468 0 0% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 23,855 23,855 0 0% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 103,473 103,473 0 0% 5210-447-430550-528 DATA PROCESSING TRANSFER 29,196 36,000 6,804 19% 5210-447-430550-532 LEASE PAYMENTS (City Hall rent) 6,422 9,500 3,078 32% 5210-447-430550-921 SAND/COLD MIX STORAGE SHED 34,378 25,771 8,607- -33% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 24 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 5210-447-430550-922 USFS PROPERTY ACQUISITION 366 32,978 32,612 99% 5210-447-430550-936 Noffsinger Spring Generator 55,907 90,000 34,093 38% 5210-447-430550-948 METERS (METER FUNDS) 010125 32,575 110,000 77,425 70% 5210-447-430550-951 SECURITY SCADA UPGRADES 2,715 15,000 12,285 82% 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 5210-447-430550-958 2ND AVE EAST MAIN REPLC & UPSIZE 453 45,147 44,694 99% 5210-447-430550-959 PARKS METERING PHASE I 8,940 30,000 21,060 70% 5210-447-430550-969 4TH AVE E MAIN REPL. PH. 1 50,883 2,435,627 2,384,744 98% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 150,000 150,000 100% 5210-447-430555-941 METERS (NEW SERVICES)010120 32,575 45,600 13,025 29% 5210-447-430555-953 SECTION 36 WELL 0 639,746 639,746 100% SUBTOTAL WATER FACILITIES 1,620,995 5,366,037 3,745,042 70% 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 102,158 108,823 6,665 6% 28,810 36,839 8,029 22% 7,839 8,225 386 5% 2,237 2,500 263 11% 2,000 2,000 0 0% 0 3,000 3,000 100% 56,696 70,000 13,304 19% 1,755 2,500 745 30% 7,950 7,950 0 0% 29,196 33,000 3,804 12% 6,422 6,422 0 0% 245,065 281,259 36,194 13% REVENUE BONDS 5210-447-490204-610 BOND PRIN-HWY 93 S WTR-2004 0 65,000 65,000 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 28,835 28,835 0 0% 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 350 350 0 0% 5210-447-490206-610 PRIN-MTR&WELL WRF7104 1.25%;WRF8114 0 83,000 83,000 100% 5210-447-490206-620 INT-MTR&WELL/WRF7104 1.25%;WRF8114 22,601 22,601 0- 0% 5210-447-490250-610 PRIN-WTR MAIN/WRF1032R 2%/IDAHO&MAI 0 48,000 48,000 100% 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2%/IDAHO&MAIN 4,440 4,200 240- -6% SUBTOTAL REVENUE BONDS 56,226 251,986 195,760 78% DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION TOTAL WATER FUND 0 840,000 840,000 100% 0 840,000 840,000 100% 1,922,286 6,739,282 4,816,996 71% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 25 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 1,755 0 1,755- 0% 5310-000-343310-000 SEWER SERVICE CHARGES 4,528,608 4,400,000 128,608- -3% 5310-000-343330-000 IMPACT FEES (SANITARY) 941,277 220,000 721,277- -328% 5310-000-343335-000 IMPACT FEES (WWTP) 681,940 300,000 381,940- -127% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 3,064 15,000 11,936 80% 5310-000-343365-000 LATECOMER ADMIN FEES 585 0 585- 0% 5310-000-371010-000 INVESTMENT EARNINGS 98,402 50,000 48,402- -97% TOTAL SEWER REVENUE 6,255,632 4,985,000 1,270,632- -25% SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 85,805 91,956 6,151 7% 5310-454-430620-153 HEALTH INSURANCE 22,915 29,868 6,953 23% 5310-454-430620-155 RETIREMENT 6,575 6,936 361 5% 5310-454-430620-215 OFFICE SUPPLIES/computers 2,217 2,500 283 11% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 2,000 2,000 0 0% 5310-454-430620-355 BILLING COSTS 59,349 70,000 10,651 15% 5310-454-430620-373 DUES & TRAINING 1,755 2,500 745 30% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 7,055 7,055 0 0% 5310-454-430620-528 DATA PROCESSING TRANSFER 29,196 33,000 3,804 12% 5310-454-430620-532 OFFICE RENT 6,422 6,422 0 0% SUBTOTAL SEWER BILLING COSTS 223,288 252,237 28,949 11% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 222,423 251,377 28,954 12% 5310-454-430630-121 OVERTIME 1,343 5,500 4,157 76% 5310-454-430630-153 HEALTH INSURANCE 55,103 66,327 11,224 17% 5310-454-430630-155 RETIREMENT 16,665 18,365 1,700 9% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 3,134 9,200 6,066 66% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 5,773 8,350 2,577 31% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 1,908 2,000 92 5% 5310-454-430630-231 GAS & OIL 7,540 13,500 5,960 44% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 469 400 69- -17% 5310-454-430630-341 ELECTRICITY 47,455 54,500 7,045 13% 5310-454-430630-344 NATURAL GAS 13,530 16,500 2,970 18% 5310-454-430630-345 TELEPHONE & COMMUNICATION 24,418 23,000 1,418- -6% 5310-454-430630-353 AUDITING 3,000 3,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 15,510 24,000 8,490 35% 5310-454-430630-356 CONSULTANTS 2,541 8,000 5,459 68% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 4,755 5,000 245 5% 5310-454-430630-373 DUES & TRAINING 4,726 5,500 774 14% 5310-454-430630-388 MEDICAL SERVICES 53 500 448 90% 5310-454-430630-410 CONSTRUCTION MATERIALS 7,405 9,000 1,596 18% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 30,226 50,000 19,774 40% 5310-454-430630-510 PROPERTY & LIABILITY INS. 15,791 15,791 0 0% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 4,549 25,000 20,451 82% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 9,180 9,180 0 0% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 64,461 64,461 0- 0% 5310-454-430630-528 DATA PROCESSING TRANSFER 16,684 19,000 2,316 12% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 26 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-532 OFFICE RENT 6,422 6,422 0 0% 5310-454-430630-921 SAND/COLD MIX STORAGE SHED 34,378 25,771 8,607- -33% 5310-454-430630-922 USFS PROPERTY ACQUISITION 366 32,978 32,612 99% 5310-454-430630-951 1ST ALLEY EN PIPE UPSIZE (34% RATE 0 20,528 20,528 100% 5310-454-430630-952 PETERSON SCHOOL ALLEY REPLACEMENT 197,756 284,000 86,244 30% 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 12,342 20,000 7,658 38% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 30,945 50,000 19,055 38% 5310-454-430630-961 2ND ALLEY WN - MONT TO CALF 296,338 324,366 28,028 9% SUBTOTAL SEWER COLLECTION 1,157,188 1,502,068 344,880 23% IMPACT FEES 5310-454-430635-951 1ST ALLEY EN PIPE UPSIZE (34% RATE 0 34,035 34,035 100% 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 0 100,000 100,000 100% 5310-454-430635-957 3 MILE DR INTERCEPTOR 74,905 867,087 792,182 91% 5310-454-430635-961 2ND ALLEY WN - MONT TO CALF 152,572 167,110 14,538 9% SUBTOTAL IMPACT FEE EXPENSE 227,477 1,168,232 940,755 81% REVENUE BONDS/SANITARY 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.25% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25% SUBTOTAL REVENUE BONDS DEPRECIATION -SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION -SANITARY SUBTOTAL SANITARY SEWER WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 5310-455-430640-111 SEASONAL SALARIES 5310-455-430640-112 SALARIES -RETIREMENT 5310-455-430640-121 OVERTIME 5310-455-430640-153 HEALTH INSURANCE 5310-455-430640-155 RETIREMENT 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 5310-455-430640-225 ALUM 5310-455-430640-226 CHLORINE & CHEMICALS 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 5310-455-430640-231 GAS & OIL 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 5310-455-430640-336 LICENSES & FEES 0 81,000 81,000 100% 15,345 15,346 2 0% 0 300 300 100% 15,345 96,646 81,302 84% 0 820,000 820,000 100% 0 820,000 820,000 100% 1,400,009 3,586,946 2,186,937 61% 411,964 448,865 36,901 8% 4,196 5,000 804 16% 14,457 0 14,457- 0% 19,892 22,500 2,608 12% 76,732 88,992 12,260 14% 32,159 32,463 304 1% 6,012 10,000 3,988 40% 2,208 2,700 492 18% 20,282 20,000 282- -1% 22,336 19,000 3,336- -18% 6,315 7,000 685 10% 9,069 18,500 9,431 51% 401 350 51- -15% 7.491 10,000 2,509 25% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 27 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-341 ELECTRICITY 159,842 178,500 18,658 10% 5310-455-430640-342 WATER 3,738 7,500 3,762 50% 5310-455-430640-344 NATURAL GAS 44,838 65,000 20,162 31% 5310-455-430640-345 TELEPHONE & COMMUNICATION 6,098 5,500 598- -11% 5310-455-430640-353 AUDITING 4,000 4,000 0 0% 5310-455-430640-354 CONTRACT -GLACIER GOLD 124,075 124,000 75- -0% 5310-455-430640-355 OTHER CONTRACT SERVICES 25,631 30,000 4,369 15% 5310-455-430640-356 CONSULTANTS 53,287 100,000 46,713 47% 5310-455-430640-358 CONSULTANT-TMDL 2,588 15,000 12,412 83% 5310-455-430640-360 MISC. MAINT SERVICES 15,212 30,000 14,788 49% 5310-455-430640-366 BUILDING MAINTENANCE 23,181 36,000 12,819 36% 5310-455-430640-373 DUES & TRAINING 5,391 7,500 2,109 28% 5310-455-430640-388 MEDICAL SERVICES 228 500 273 55% 5310-455-430640-510 PROPERTY & LIABILITY INS. 34,985 34,985 0 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 13,212 13,212 0 0% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 112,237 112,237 0 0% 5310-455-430640-528 DATA PROCESSING TRANSFER 20,854 27,500 6,646 24% 5310-455-430640-921 EVERGREEN SEWER SAMPLING EQUIP & BL 23,054 40,000 16,946 42% SUBTOTAL WWTP OPERATIONS 1,305,966 1,516,804 210,838 14% WWTP BONDED PROJECT SUBTOTAL WWTP BONDED 0 0 0 0% WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 96,696 100,000 3,304 3% 5310-455-430645-920 R.A.S. BLD & STORAGE WAREHOUSE ROOF 34,636 40,000 5,364 13% 5310-455-430645-933 SOLIDS DEWATERING DESIGN & CONST. 1,338 100,000 98,662 99% 5310-455-430645-934 SECONDARY DIGESTER LID INSPECTION 28,798 531,500 502,702 95% 5310-455-430645-936 DIGESTED SLUDGET LINE REPLACEMENT 146,293 298,678 152,385 51% 5310-455-430645-937 SAND FILTER MAINT & REPLACMENT 0 200,000 200,000 100% 5310-455-430645-940 MACHINERY & EQUIPMENT 50,115 182,500 132,385 73% SUBTOTAL WWTP REPLACEMENT 357,875 1,452,678 1,094,803 75% WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 98,943 106,284 7,341 7% 5310-455-430646-121 OVERTIME 168 0 168- 0% 5310-455-430646-153 HEALTH INSURANCE 14,960 20,932 5,972 29% 5310-455-430646-155 RETIREMENT 7,325 7,630 305 4% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 1,853 4,500 2,647 59% 5310-455-430646-218 NON -CAPITAL EQUIPMENT 2,611 2,500 111- -4% 5310-455-430646-222 LAB SUPPLIES 13,163 9,500 3,663- -39% 5310-455-430646-349 LAB SERVICES 27,169 29,000 1,831 6% 5310-455-430646-362 EQUIPMENT MAINTENANCE 4,479 5,500 1,021 19% 5310-455-430646-373 DUES & TRAINING 1,337 3,700 2,363 64% SUBTOTAL WWTP LAB OPERATIONS 172,006 189,546 17,540 9% DEBT SERVICE - WWTP 5310-455-490227-610 PRIN-WWTP IMP/SRF8164R/2.25% 0 796,000 796,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 216,405 216,405 0 0% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 28 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 5310-455-490228-610 PRIN/WWTP DIGESTER LID/SRF13326/3.0 0 44,000 44,000 100% 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 28,650 28,650 0 0% SUBTOTAL DEBT SERVICE - WWTP CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-830 EVERGREEN REPLACEMENT TRANSFER 5310-455-510400-831 DEPRECIATION EXPENSE SUTOTAL WWTP DEPRECIATION/REPL SUBTOTAL WWTP TOTAL BILLING/SANITARY/WWTP 245,055 1,085,055 840,000 77% 0 450,000 450,000 100% 0 1,425,000 1,425,000 100% 0 1,875,000 1,875,000 100% 2,080,902 6,119,083 4,038,181 66% 3,704,200 9,958,266 6,254,066 63% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 29 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING STORM SEWER REVENUE 5349-000-323108-000 PW PLAN REVIEW FEES 1,755 0 1,755- 0% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 4,136 2,500 1,636- -65% 5349-000-343033-000 IMPACT FEES 454,371 150,000 304,371- -203% 5349-000-343034-000 PERMIT FEES 1,895 0 1,895- 0% 5349-000-343035-000 STORM SEWER CHARGES 0 1,000 1,000 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 866,947 850,000 16,947- -2% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 1,553 1,000 553- -55% 5349-000-371010-000 INTEREST ON INVESTMENTS 29,639 18,000 11,639- -65% 5349-000-381050-000 INCEPTION OF LEASE 0 382,000 382,000 100% TOTAL STORM REVENUE 1,360,296 1,404,500 44.204 3% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 330,372 360,758 30,386 8% 5349-453-430246-121 OVERTIME 1,353 4,000 2,647 66% 5349-453-430246-153 HEALTH INSURANCE 67,666 81,030 13,364 16% 5349-453-430246-155 RETIREMENT 24,747 26,448 1,701 6% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 3,436 10,100 6,664 66% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 2,932 6,550 3,618 55% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 280 2,200 1,920 87% 5349-453-430246-231 GAS & OIL 7,094 11,500 4,406 38% 5349-453-430246-345 TELEPHONE & COMMUNICATION 844 800 44- -5% 5349-453-430246-353 AUDITING 1,150 2,340 1,190 51% 5349-453-430246-354 CONTRACT SERVICE 6,320 6,000 320- -5% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 23,009 35,000 11,991 34% 5349-453-430246-357 IMPACT FEE UPDATE 26,881 50,000 23,119 46% 5349-453-430246-358 CONSULTANTS 1,128 7,000 5,872 84% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 1,032 15,000 13,968 93% 5349-453-430246-360 REPAIR & MAINT SERVICES 1,294 2,500 1,206 48% 5349-453-430246-362 GROUNDWATER MONITORING 2,150 6,500 4,350 67% 5349-453-430246-371 CURB & GUTTER 0 7,000 7,000 100% 5349-453-430246-373 DUES & TRAINING 3,933 5,500 1,567 28% 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 9,180 9,180 0 0% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 39,752 39,752 0- 0% 5349-453-430246-528 DATA PROCESSING TRANSFER 16,684 13,000 3,684- -28% 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 34,378 25,771 8,607- -33% 5349-453-430246-952 STORM DRAIN CORRECTION 27,970 100,000 72,030 72% 5349-453-430246-953 WILLOWS PRJ FY14/15; SHOP COMPLX PV 0 30,552 30,552 100% 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 501,380 581,400 80,020 14% 5349-453-430246-969 4TH AVE E. REPLACE PHASE 1-4 0 382,000 382,000 100% 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 130,000 130,000 100% 5349-453-510400-831 DEPRECIATION 0 285,000 285,000 100% TOTAL STORM 1,151,016 2,312,303 1,161,287 50% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 30 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 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,873 955,000 18,873- -2% 5510-000-343420-000 GARBAGE COLLECTION -BILLED 29,002 21,500 7,502- -35% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 2,321 2,100 221- -11% 5510-000-371010-000 INVESTMENT EARNINGS 8,504 6,000 2,504- -42% 5510-000-382010-000 SALE OF FIXED ASSETS 15,700 0 15,700- 0% TOTAL SOLID WASTE REVENUE 1,029,500 984,600 44,900- -5% SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 380,958 399,776 18,818 5% 5510-460-430840-112 SEVERANCE -RETIREMENT 0 60,455 60,455 100% 5510-460-430840-121 OVERTIME 5,303 5,500 197 4% 5510-460-430840-153 HEALTH INSURANCE 80,692 106,280 25,588 24% 5510-460-430840-155 RETIREMENT 28,428 28,993 565 2% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 5,162 9,500 4,338 46% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 37,290 35,000 2,290- -7% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 3,096 5,500 2,404 44% 5510-460-430840-231 GAS & OIL 37,798 60,000 22,202 37% 5510-460-430840-341 ELECTRICITY 1,518 1,950 432 22% 5510-460-430840-344 NATURAL GAS 2,627 4,900 2,273 46% 5510-460-430840-345 TELEPHONE & COMMUNICATION 971 850 121- -14% 5510-460-430840-354 CONTRACT SERVICES 9,958 9,000 958- -11% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 1,517 5,700 4,183 73% 5510-460-430840-366 BUILDING MAINTENANCE 288 2,500 2,212 88% 5510-460-430840-373 DUES & TRAINING 1,825 3,500 1,675 48% 5510-460-430840-388 MEDICAL SERVICES 88 650 562 86% 5510-460-430840-510 PROPERTY & LIABILITY INS. 6,799 6,799 0 0% 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 0 4,000 4,000 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 76,104 76,104 0- 0% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 37,311 37,311 0- 0% 5510-460-430840-528 DATA PROCESSING TRANSFER 12,513 12,513 0 0% 5510-460-430840-532 OFFICE RENT 6,422 6,422 0 0% 5510-460-430840-610 DEBT SERVICE PRINCIPAL -GARBAGE TK 38,343 38,343 0- 0% 5510-460-430840-620 DEBT SERVICE INTEREST -GARBAGE TK 1,656 1,801 145 8% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 35,000 35,000 0 0% 5510-460-430840-922 USFS PROPERTY ACQUISITION 494 43,971 43,477 99% 5510-460-430840-940 EQUIPMENT 45,405 48,000 2,595 5% 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 5510-460-430845-224 JANITORIAL SUPPLIES 285 250 35- -14% 5510-460-430845-341 ELECTRICITY 1,817 3,500 1,683 48% 5510-460-430845-342 WATER 652 2,000 1,348 67% 5510-460-430845-344 NATURAL GAS 4,600 6,500 1,900 29% 5510-460-430845-360 REPAIR & MAINT SERVICES 247 3,500 3,253 93% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% TOTAL SOLID WASTE EXPENSE 865,168 1,246,620 381,452 31% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 31 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 10,800 10,000 800- -8% 5160-000-343069-000 HANGER LEASES 12,000 11,000 1,000- -9% 5160-000-343071-000 HANGAR SITE LEASES 19,132 17,510 1,622- -9% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 19,097 19,145 48 0% 5160-000-343102-000 GROUND LEASES 13,198 13,198 0- 0% 5160-000-343620-000 FUEL TAX 3,931 5,000 1,069 21% 5160-000-371010-000 INVESTMENT EARNINGS 1,789 1,000 789- -79% TOTAL AIRPORT REVENUE 79,949 76,853 3,096- -4% 5160 AIRPORT EXPENSES 5160-430-430310-210 OFFICE SUPPLIES & EQUIP 0 1,000 1,000 100% 5160-430-430310-341 ELECTRICITY 1,403 1,500 97 6% 5160-430-430310-354 CONTRACT SERVICES -LABOR & MATERIALS 36,000 36,000 0 0% 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 9,850 7,500 2,350- -31% 5160-430-430310-362 REPAIR & MAINTENANCE 1,123 10,000 8,877 89% 5160-430-430310-390 EQUIPMENT RENTAL 770 1,000 230 23% 5160-430-430310-510 PROPERTY INSURANCE 6,418 6,500 82 1% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 2,562 2,562 0 0% 5160-430-430310-528 DATA PROCESSING TRANSFER 2,085 2,085 0- -0% 5160-430-430310-820 DEPRECIATION 0 97,918 97,918 100% TOTAL AIRPORT EXPENSES 60,212 166,065 105,853 64% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 32 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 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 205,000 205,000 0 0% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 128,107 175,000 46,893 27% 6030-000-364030-000 SALE OF MISCELLANEOUS 63 0 63- 0% 6030-000-371010-000 INVESTMENT EARNINGS 1,623 1,000 623- -62% 6030-000-393000-000 INTERNAL SERVICES -DATA 235,655 235,655 0- 0% TOTAL INFORMATION TECH REVENUE 570,448 616,655 46,207 7% INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 161,208 167,379 6,171 4% 6030-401-410580-121 OVERTIME 1,116 1,000 116- -12% 6030-401-410580-153 HEALTH INSURANCE 40,251 44,317 4,066 9% 6030-401-410580-155 RETIREMENT 12,663 12,653 10- -0% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 85 500 415 83% 6030-403-410580-215 COMPUTER SUPPLIES 972 2,400 1,428 59% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 17,660 18,963 1,303 7% 6030-403-410580-325 WEBSITE 2,835 16,000 13,165 82% 6030-403-410580-345 PAGER/PHONE 2,056 2,500 444 18% 6030-403-410580-346 SUMMITNET & ISPS 9,217 8,468 749- -9% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,432 3,500 68 2% 6030-403-410580-354 MAINTENANCE CONTRACTS 10,342 8,860 1,482- -17% 6030-403-410580-355 LICENSES 18,452 21,110 2,658 13% 6030-403-410580-356 MAINTENANCE CONTRACTS 49,785 47,550 2,235- -5% 6030-403-410580-357 GRANICUS 7,400 6,690 710- -11% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 6,396 21,235 14,839 70% 6030-403-410580-373 DUES & TRAINING 4,770 8,000 3,230 40% 6030-403-410580-510 INSURANCE 819 1,778 959 54% 6030-403-410583-218 TV -Video Equipment & programming 2,263 12,900 10,637 82% 6030-403-410585-229 COPIER,FAX, SUPPLIES 12,097 19,552 7,455 38% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 76,631 76,000 631- -1% 6030-403-410585-532 COPIER LEASES 15,204 16,182 978 6% 6030-403-410585-942 Servers - capital contingency 25,422 23,500 1,922- -8% 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,000 5,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 3,553 4,964 1,411 28% 6030-405-410588-940 NETWORK EQUIPMENT CAPITAL 47,440 49,200 1,760 4% 6030-410-410588-218 COMPUTERS - DPW 2,345 2,175 170- -8% 6030-413-410588-218 COMPUTERS - POLICE DEPT 29,076 28,360 716- -3% 6030-413-410588-354 POLICE - HOSTED SERVER 1,087 2,000 913 46% 6030-416-410588-218 COMPUTERS - FIRE 9,454 16,752 7,298 44% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 12,312 11,053 1,259- -11% 6030-436-410588-218 COMPUTERS - PARKS 5,034 5,165 131 3% 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 2,155 2,155 100% TOTAL INFORMATION TECH EXPENSE 591,373 667,861 76,488 11% 07.13.2017 09:48 THE CITY OF KALISPELL, MONTANA Page 33 of 33 gb8501_pg.php/Job No: 58560 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU JUNE 30, 2017 100.00 % Yr Complete For Fiscal Year: 2017 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 510,000 510,000 0- 0% 6010-000-364030-000 SALE OF MISC 1,087 0 1,087- 0% 6010-000-371010-000 INVESTMENT EARNINGS 741 200 541- -270% TOTAL CENTRAL GARAGE REVENUE 511,828 510,200 1,628- -0% CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 152,966 160,046 7,080 4% 6010-410-431330-121 OVERTIME 2,288 2,500 213 9% 6010-410-431330-153 HEALTH INSURANCE 34,807 38,827 4,020 10% 6010-410-431330-155 RETIREMENT 11,103 11,505 402 4% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 8,406 10,000 1,594 16% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 9,294 12,700 3,406 27% 6010-410-431330-230 OIL 17,323 25,000 7,678 31% 6010-410-431330-231 GAS 612 3,000 2,388 80% 6010-410-431330-232 VEHICLE PARTS 114,218 108,000 6,218- -6% 6010-410-431330-233 TIRES 40,780 38,000 2,780- -7% 6010-410-431330-238 FILTERS 7,627 7,700 73 1% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 2,043 2,000 43- -2% 6010-410-431330-341 ELECTRICITY 1,463 1,950 487 25% 6010-410-431330-344 NATURAL GAS 4,238 7,000 2,762 39% 6010-410-431330-354 CONTRACT SERVICES 20,728 30,000 9,272 31% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 370 2,000 1,630 82% 6010-410-431330-373 DUES & TRAINING 5,298 6,200 902 15% 6010-410-431330-388 MEDICAL SERVICES 423 300 123- -41% 6010-410-431330-510 INSURANCE 1,286 2,750 1,464 53% 6010-410-431330-528 INFORMATION TECH TRANSFER 8,342 8,342 0 0% 6010-410-431330-921 4 POST SERVICE LIFT 25,504 26,000 496 2% TOTAL CENTRAL GARAGE EXPENSES 469,120 503,820 34,700 7%