Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
10-13-17 City Manager Report
City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 10/13/2017 1. Parks Department Begg Dog Park continues to be a popular amenity with use at the facility exceeding expectations. A1128 park irrigation systems have been winterized for the year. Crews are now working on winterizing the seasonal restrooms throughout the park system. The skinned areas of the Peewee minor pod at KYAC have been leveled and reshaped to fill holes and aid drainage for next spring. The winterization process for concessions, restrooms, and irrigation have been completed. Our forestry contactor is in the process of pruning or removing removal or pruned due to hazards. KPR will be hosting a free family outdoor movie night in Woodland Park on Friday, October 20 at 7pm. We will be showing Ice Age: Collision Course. We will have our Skip -Out Camp for children in grades K-5 on October 19-20, while School District 5 is out. We will spend those days doing Halloween themed activities with the kids such as candy corn bingo, spooky crafts, and painting pumpkins. We will also be taking a field trip to the Sweet Pickins Pumpkin Patch. The Woodland Water Park has been winterized for the season. The Lazy River has also been drained so it can be prepped for patching and repainted this fall, weather permitting. 2. Community Development Initial clearing of vegetation, fencing, and debris at the rail park site is complete. Due to weather conditions, the water line construction on East Oregon has been delayed until the spring of 2018. Mass grading at the site will begin the week of October 23, 2017. 3. Fire Department Since the last update, the Kalispell Fire Department has received 279 calls for service and has conducted 9 outreach events with over 170 individuals in attendance. This week is Fire Prevention Week for the fire services around the nation. Crews from the Kalispell fire department will be conducting many outreach events spreading this year's theme: "Every Second Counts: Plan 2 Ways Out!" Crews will be conducting puppet shows and station tours for local schools, pre-schools, clubs, and other organizations throughout the next 2 weeks. Fire Department staff are preparing for winter operations by winterizing our wildland engines and equipment. All department staff took part in a training conducted by the Montana State Fire Training School on pump and fire flows. 4. Public Works Street Maintenance The Street Maintenance Division is responsible for the surface maintenance of streets and alleys within the city. These responsibilities include minor and major patching, crack sealing, pothole repairs, milling and overlays, and street reconstruction. In 2017, the Street Maintenance Crew completed over 2.9 miles of overlay, major patching, and street reconstruction projects. On average, a 50% cost saving is achieved having the city perform these tasks vs hiring a contractor to perform the same work. 2 Kalispell Leaf Collection Street crews remove leaves from City streets during the Fall from October 1 — November 30 (dates may vary due to weather). Residents and business owners are encouraged to rake the leaves from the boulevards onto the street approximately two feet away from the curb. Leaf piles placed two feet from the curb ensure the leaf machines can operate efficiently. City Street personnel will make every effort to remove leaves as quickly as possible. As a guideline, avenues are done on Mondays, Wednesdays, and Fridays, and streets are done on Tuesdays and Thursdays. Outlying residential areas will be throughout the week on an as needed basis. 5. Information Services Vehicles must be removed from the curbsides during leaf pickup operations. Bagged leaves and bundled branches should be placed in the alley for solid waste pick up. Rocks, dirt, cans, bottles, branches, and items of this nature in the leaf piles can cause bodily injury to city personnel, bystanders, and machinery. The Public Works department annually warns residents about placing these items in leaf piles. IT staff are preparing design ideas and selecting photos for incorporation into the redesigned website. IT staff removed all instances of Microsoft Office 2007 before the date when Microsoft would stop supporting and publishing security patches. An RFP has been published for a Virtual Server Cluster and Storage Area Network expansion. 6. Building Department Two single-family building permits were issued in the past 2 weeks bringing the total of new single family/duplex units for the year to 101 compared to 121 last year at this time. An application has been submitted for the 40-unit Owl View Landing Apartment complex located on Sawyer Lane in West View Estates. This project is valued at $3.6 Million and contains five 8-plex condominium units. The building permit for the Physical Therapy Associates building located @ 105 Village Loop permit has been issued. This project is valued at an $870,000. The new Homegoods Store located at 2280 Hwy 93 N has been completed and issued a Certificate of Occupancy. 7. Planning Department Planning Staff held an open house on Tuesday, October 10 to discuss the final phase of the B-3 zoning effort through the core area. This final phase extends from 71h Ave. West to Meridian Road with Idaho as the north boundary and 1st Street West as the southern boundary. Everyone in the new area or within 150 feet of the new area was notified by mail. Approximately 10 people attended. All comments received were supportive of the effort. Staff presented the Downtown Plan and the Core Area Plan to the Leadership Flathead Class on Friday, October 6 with 40 in attendance and the Leadership Montana Class on Tuesday, October 11 with approximately 50 in attendance. Staff met with School District 5 representatives to begin discussions to address parking strategies for the coming year as Flathead High School prepares to undertake major remodeling over the next 1 1/z years. Staff also met with the design team for Flathead High as well to begin coordination of the construction project which is tentatively scheduled to begin in March 2018. 8. Police Department Attached to this memo is the latest case and arrest report which includes information up through September. 9. Finance Department Audit The finance department is completing work on the City's fiscal year 2017 Certified Annual Financial Report (CAFR) and preparing for the annual audit. The auditors are scheduled to be in City Hall to begin the on -site portion of the audit the week of November 6. First Quarter Finance Report Please find attached the printouts reflecting the activity for the 1st quarter of the fiscal year 2017. This printout reflects payroll paid thru September 22, six and a half pay periods. All funds are included with the exception of the debt service funds, G. O. bonds, Sidewalk & Curb, and SID's. REVENUES: General Fund revenue has little activity as taxes will not be received until December. We will book the receivables/revenue when the tax bills are distributed. This applies to the assessed funds, garbage, and storm, as well. The Ambulance Fund 1 st quarter fees for services is 19% of the annual budget or $145,262. This is a decrease of about $20,000 when compared to the lst quarter of fiscal M year 2017. First quarter Building Department revenues of $377,614 are 28% of the annual budget. First quarter fiscal year 2017 revenues were $455,078. Metered water sales are at 45% compared to 40% for the first quarter of fiscal year 2017. This increase in consumption can be attributed to the hot and dry summer and the increased use of sprinkling and irrigation. Sewer metered sales are at 28% of budget; compared to 27% for the same quarter last fiscal year. Impact fees remain strong in the first quarter and all types are in excess of 50% of the fiscal year 2018 budgeted amount. EXPENDITURES/EXPENSES: At this point in the year the salary and retirement remaining should be about 75% in most funds (19.5 of 26 pay periods remaining). Some seasonal parks and rec salaries are an exception. Health insurance reflects 3 months paid and should have about 75% remaining. Fire and ambulance should have about 80% remaining in salaries (10.5 of 13 pay periods remaining) and 83% for health insurance (10 of 12 months remaining). With a few exceptions; administrative, central garage, and information technology transfers are done monthly and should show 75% 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, depending on cash availability, and should show 75% remaining. The City prepays its annual liability ($184,792) and property insurance ($118,650) in August, this can results in general government expenditures and some other fund expenses reflecting greater than 25% spent in the I" quarter. o �o �o m N m 'n � rn� m o a rn .� N m 1O N � o � m� rn N� N •� As N o � v E Q Hill o v v = o O 0 � o � v E Q O v � o �o o 0 z � o `v a O 0 O o O O � N O O O N O m N O N .ti O .ti ti O O ti m 0 0 0 .ti ti N O O 00 Q v o. O m n C O m C .ti ti ti O O O m C .ti O 00 m n n 00 m N O � Q 0 0 0 0 o m o 0 0 o 0 0 W o o, ^ o 0 o r' o r, ,n o un a a O m o o 00 o N N 00 O O O N O 0 O O O a o � >, Q o 0 o o a o ti o o dw m o fo� o 000 N O c v Q O OHOLHO ti O O ti 0 0 0W ti 0 I� `� ti ti O N� ti m ti 0� m� ti ti N C o. O O O O O00 � ti n ti ti N m C 00 N N O rc T Q O N O O .ti n n O ci 0 0 .ti ti O O O o o o N o^ ci N O N O m ci N N o ci O �y f0 o. O O m .ti 00 w t0 O O .ti m ti O O w C w N O m O N w ifl 00 00 O � .Q Q O .ti O .ti O O m 0 ti O O O N O O N ti O N ti O O ti O m N ti 0 ti N O � a o. O C O C O C O t0 O �O O .ti ti ti O n O C N .ti O w O 0 N O c � w Q O O N .ti m m ifl .ti ^ ci o o o .ti O O O ti ti O O m N .ti w ci O m o I� 0 ci m t0 m I N �y f0 O Q O C 0 W m O C w N ci ci m O O .ti N O C N ti 00 C m n N 00 O � w m o � o 0 0 0 0 �n m o `r,° o 0 0 .� o .� .� .� O o o r^, .� a 0 O00 v = 0 o m o O 0 O m 00 o 0 N O rc i f0 w Q O O m N 0 .ti ti N m N O O N ti ti ti O 0 0 0 0 0 O N't O �O N C O Q O O �I1 N O� I� ci N O .ti t0 ci O .ti ci O .ti ci m n m N N O rc v j p C O O O O 0 T O O W -0-. V .t uo O N c O O O V O o W A Q V U E O O c O CO Q O \ T F O _ O a o 2' w> Q w c v > o H - c °o. y> O v ¢ `v - o - O 0 3 o m o Q o y r ° o w o .E o aEoo o r ° .E o r s a a" - >" a` G 3 0 6 0 0- o G> o o 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 1 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 92,748 5, 800, 000 5,707,252 98. 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 0 17,250 17,250 100. 1000-000-311200-000 PERSONAL PROPERTY TAXES 143,016 135,000 8,016- -6. 1000-000-312000-000 PEN & INTEREST DEL. TAXES 4,353 8, 000 3,647 46. 1000-000-322101-000 LIQUOR LICENSES 0 30,000 30,000 100. 1000-000-322300-000 BUSINESS LICENSES 0 1,700 1,700 100. 1000-000-323012-000 PLANNING FEES 21,445 40,000 18,555 46. 1000-000-323109-000 SITE REVIEW 3,447 14,000 10,553 75. 1000-000-323200-000 PARADE PERMITS 400 1,000 600 60. 1000-000-335030-000 M.V. TAX - AD VALOREM 58 1,500 1,442 96. 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 0 60, 000 60,000 100. 1000-000-335110-000 LIVE CARD TABLE PERMIT 0 1,000 1,000 100. 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 699,564 2,857,688 2,158,124 76. 1000-000-341020-000 ADMINISTRATIVE CHARGES 163,342 638,811 475,469 74. 1000-000-341021-000 GRANT ADMIN FEES 0 5,000 5,000 100. 1000-000-341025-000 CITY COLLECTIONS 8 5,000 4,992 100. 1000-000-342010-000 POLICE SERVICES 8,028 25,000 16,972 68. 1000-000-342014-000 RESOURCE OFFICERS 152,017 209,037 57,020 27. 1000-000-342016-000 KPD REGIONAL TRAINING 0 5,000 5,000 100. 1000-000-342020-000 FIRE CHG/TEST FEES/SPEC EVENTS/INST 10 0 10- 0. 1000-000-343018-000 PARKING PERMITS 28,209 95,000 66,791 70. 1000-000-351000-000 CITY COURT FINES & FEES 62,993 450,000 387,007 86. 1000-000-351016-000 DUI COURT FINE 1,937 0 1,937- 0. 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 2,156 20,000 17,844 89. 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 12,015 35,000 22,986 66. 1000-000-362015-000 INSURANCE REIMBURSEMENTS 1,512 20,000 18,488 92. 1000-000-362020-000 MMIA GASP 54 REIMBURSEMENT 0 3,000 3,000 100. 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 0 5,000 5,000 100. 1000-000-371010-000 INVESTMENT EARNINGS 6,590 15,000 8,410 56. 1000-000-373030-000 INTEREST ON OLD SCHOOL SID LOAN - 1 0 32,500 32,500 100. 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 0 901,000 901,000 100. TOTAL GENERAL FUND REVENUE 1,403,847 11,431,486 10,027,639 88. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 2 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 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 0 2,935 2,935 100. 1000-400-410530-353 CONTRACT SERVICES - AUDIT 3,500 14,250 10,750 75. 1000-400-410530-354 OPEB EXPENSE 7,500 7,500 0 0. 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 908 4,000 3,092 77. 1000-400-410560-312 POSTAGE 2,500 16, 000 13,500 84. 1000-400-410560-320 PRINTING & ENVELOPES 295 4,500 4,205 93. 1000-400-410560-354 CONTRACT SERVICES - DOC. SHREDDING 55 500 445 89. 1000-400-410600-354 ELECTIONS 0 18,255 18,255 100. 1000-400-410900-331 RECORDS ADMIN./FILING FEES 868 4,000 3,132 78. 1000-400-420000-354 CONTRACT 911 CENTER 122,511 479,000 356,490 74. 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 0 400 400 100. 1000-400-460000-820 TRANSFER TO FORESTRY 0 200,000 200,000 100. 1000-400-460430-820 TRANSFER TO PARKS (BANDSHELL) 0 10,467 10,467 100. 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 0 15,000 15,000 100. 1000-400-460452-366 HOCKADAY MAINTENANCE 0 6, 600 6,600 100. 1000-400-510300-000 CONTINGENCY 0 30,000 30,000 100. 1000-400-510310-354 ICMA PLAN FEES 250 500 250 50. 1000-400-510330-513 LIABILITY INSURANCE 110,313 110,310 3- 0. 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 13,043 50,000 36,957 74. 1000-400-510330-517 PROPERTY INSURANCE 50,025 50,012 13- -0. SUBTOTAL GEN.GOV'T. 311,767 1,024,229 712,462 70. CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER&439;S OFFICE 1000-401-410210-153 HEALTH INSURANCE 1000-401-410210-155 RETIREMENT 1000-401-410210-210 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 35,145 141, 390 106,245 75. 4,372 22,857 18,485 81. 3,673 14,966 11,293 75. 0 1,500 1,500 100. 0 400 400 100. 280 1, 120 840 75. 345 8, 300 7,955 96. 1,189 3,400 2,211 65. 45,005 193, 933 148,929 77. 31,365 127, 044 95,679 75. 3,711 19,642 15,931 81. 2,456 9, 813 7,357 75. 207 600 393 65. 2,180 8, 000 5,820 73. 240 1, 000 760 76. 1,229 6, 000 4,771 80. 41,388 172,099 130,711 76. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 3 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 15,552 63,107 47,555 75. 1000-402-410100-153 HEALTH INSURANCE 14,532 62, 936 48,404 77. 1000-402-410100-155 RETIREMENT 626 2,463 1,837 75. 1000-402-410100-210 OFFICE SUPPLIES 100 100 0 0. 1000-402-410100-335 MT LEAGUE OF CITIES 1,313 6,417 5,104 80. 1000-402-410100-354 CONTRACT SERVICES 439 4,500 4,061 90. 1000-402-410100-373 DUES & TRAINING 6,576 6, 000 576- -10. 1000-402-410100-379 MEETINGS 0 10,590 10,590 100. SUBTOTAL MAYOR/COUNCIL 39,138 156,113 116,975 75. CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 22,427 91,120 68,693 75. 1000-402-410150-121 OVERTIME 0 250 250 100. 1000-402-410150-153 HEALTH INSURANCE 5,057 20,271 15,214 75. 1000-402-410150-155 RETIREMENT 1,762 7,083 5,321 75. 1000-402-410150-210 OFFICE SUPPLIES 231 200 31- -15. 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 29 700 671 96. 1000-402-410150-345 TELEPHONE & COMMUNICATION 160 480 320 67. 1000-402-410150-352 RECODIFICATION 0 4,100 4,100 100. 1000-402-410150-354 CONTRACT SERVICES 0 300 300 100. 1000-402-410150-373 DUES & TRAINING 546 3,200 2,654 83. SUBTOTAL CITY CLERK 30,212 127,704 97,492 76. FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 53,054 214,508 161,454 75. 1000-403-410550-153 HEALTH INSURANCE 10,128 38,696 28,568 74. 1000-403-410550-155 RETIREMENT 4,161 16, 650 12,489 75. 1000-403-410550-210 SUPPLIES 0 300 300 100. 1000-403-410550-322 BOOKS 0 250 250 100. 1000-403-410550-353 CONTRACT SERVICES 80 760 680 89. 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 319 1, 800 1,481 82. 1000-403-410550-355 BANK CHARGES & FEES 866 3, 600 2,734 76. 1000-403-410550-373 DUES & TRAINING 731 7,500 6,769 90. SUBTOTAL FINANCE 69,340 284, 064 214,724 76. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 4 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY&439;S 92,440 372, 621 280,181 75. 1000-404-411110-153 HEALTH INSURANCE 13,185 52,804 39,619 75. 1000-404-411110-155 RETIREMENT 7,238 28,950 21,712 75. 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 819 2,500 1,681 67. 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 6,072 8, 000 1,928 24. 1000-404-411110-345 TELEPHONE & COMMUNICATION 147 1,000 853 85. 1000-404-411110-354 CONTRACT SERVICES 921 5,000 4,079 82. 1000-404-411110-373 DUES & TRAINING 1,264 7,000 5,736 82. SUBTOTAL CITY ATTORNEY 122,086 477,875 355,789 74. MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 56,234 228,151 171,917 75. 1000-406-410360-121 OVERTIME 12 0 12- 0. 1000-406-410360-153 HEALTH INSURANCE 10,600 51, 674 41,074 79. 1000-406-410360-155 RETIREMENT 4,395 17,683 13,288 75. 1000-406-410360-210 SUPPLIES 929 4,500 3,571 79. 1000-406-410360-320 PRINTING/BOOKS 678 1,500 822 55. 1000-406-410360-345 TELEPHONE & COMMUNICATION 22 1,400 1,378 98. 1000-406-410360-353 SECURITY & TECHNOLOGY 4,111 40,000 35,889 90. 1000-406-410360-354 CONTRACT SERVICES 815 5,750 4,935 86. 1000-406-410360-373 DUES & TRAINING 738 10,000 9,262 93. 1000-406-410360-394 JURY & WITNESS FEES 118 7,500 7,382 98. SUBTOTAL COURT 78,653 368,158 289,505 79. PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 4,412 17,705 13,293 75. 1000-410-430100-153 HEALTH INSURANCE 796 3,289 2,493 76. 1000-410-430100-155 RETIREMENT 342 1,346 1,004 75. 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 2,608 8, 000 5,392 67. 1000-410-430100-231 GAS 723 2,500 1,777 71. 1000-410-430100-345 TELEPHONE & COMMUNICATION 77 350 273 78. 1000-410-430100-354 CONTRACT SERVICES 50 2,000 1,950 98. 1000-410-430100-373 DUES & TRAINING 510 2,500 1,990 80. 1000-410-430100-521 CENTRAL GARAGE TRANSFER 903 3,612 2,709 75. 1000-410-430100-940 MACHINERY & EQUIPMENT 0 7,400 7,400 100. SUBTOTAL PUBLIC WORKS ADMIN 10,420 48,702 38,282 79. CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 16,810 68,299 51,489 75. 1000-412-411230-153 HEALTH INSURANCE 3,355 15,928 12,573 79. 1000-412-411230-155 RETIREMENT 1,270 5, 076 3,806 75. 1000-412-411230-220 SECURITY IMPROVEMENTS 0 500 500 100. 1000-412-411230-224 JANITORIAL SUPPLIES 678 6, 000 5,322 89. 1000-412-411230-241 TOOLS & SUPPLIES 120 1,500 1,380 92. 1000-412-411230-341 ELECTRICITY 12,674 49,200 36,526 74. 1000-412-411230-344 NATURAL GAS 4,117 30,000 25,883 86. 1000-412-411230-345 TELEPHONE & COMMUNICATION 50 400 350 87. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 5 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-354 CONTRACT SERVICES 2,198 80, 000 77,802 97. 1000-412-411230-355 HVAC MAINTENANCE OCNTRACT 15,600 16, 500 900 5. 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 0 4,500 4,500 100. 1000-412-411230-362 EQUIPMENT MAINTENANCE 847 10,000 9,153 92. 1000-412-411230-366 BUILDING MAINTENANCE 4,340 27,500 23,160 84. 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 122 3,500 3,378 97. 1000-412-411230-920 BLDG IMP (LIGHT UPGRADES; CHALL ROO 0 17,000 17,000 100. SUBTOTAL CITY HALL 62,182 335,903 273,721 81. 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 66,103 266,269 200,166 75. 1000-420-411020-153 HEALTH INSURANCE 13,826 60, 020 46,194 77. 1000-420-411020-155 RETIREMENT 5,187 20, 657 15,470 75. 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 28 5,000 4,972 99. 1000-420-411020-231 GAS 31 300 269 90. 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 270 2,000 1,730 87. 1000-420-411020-345 TELEPHONE 164 900 736 82. 1000-420-411020-354 CONTRACT SERVICES 200 1,000 800 80. 1000-420-411020-373 DUES & TRAINING 1,019 6, 000 4,981 83. 1000-420-411020-521 CENTRAL GARAGE TRANSFER 237 949 712 75. 1000-420-411020-944 VEHICLE 0 15,000 15,000 100. SUBTOTAL PLANNING DEPT. 87,065 378,095 291,030 77. 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 15,558 63,180 47,622 75. 1000-480-470210-153 HEALTH INSURANCE 2,673 8,307 5,634 68. 1000-480-470210-155 RETIREMENT 1,220 4, 876 3,656 75. 1000-480-470210-210 OFFICE SUPPLIES 883 1,500 617 41. 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 0 500 500 100. 1000-480-470210-312 POSTAGE & PRINTING 0 500 500 100. 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 500 500 0 0. 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 77 900 823 91. 1000-480-470210-354 CONTRACT SERVICES 0 1,500 1,500 100. 1000-480-470210-373 DUES & TRAINING 605 5,000 4,395 88. 1000-480-470210-379 MEETINGS 0 1,500 1,500 100. SUBTOTAL COMMUNITY DEVELOPMENT 21.516 88.263 66.747 76. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 6 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 563,324 2,264, 988 1,701,664 75. 1000-413-420140-114 SALARY -comptime buyout 1,819 3,000 1,181 39. 1000-413-420140-121 OVERTIME (REG & AET OT) 16,529 80, 000 63,471 79. 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 0 25,000 25,000 100. 1000-413-420140-127 SCHOOL DISTRICT OVERTIME 120 0 120- 0. 1000-413-420140-153 HEALTH INSURANCE 109,730 445, 536 335,806 75. 1000-413-420140-155 RETIREMENT 71,808 296, 098 224,290 76. 1000-413-420140-210 OFFICE SUPPLIES 663 3,500 2,837 81. 1000-413-420140-215 COMPUTER SUPPLIES 708 5,500 4,792 87. 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 31,357 53,500 22,143 41. 1000-413-420140-220 INVESTIGATIVE SUPPLIES 589 4,000 3,411 85. 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 703 7,000 6,297 90. 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 296 2,000 1,704 85. 1000-413-420140-226 SRT SUPPORT/SUPPLIES 9 10,000 9,991 100. 1000-413-420140-227 AMMO & RELATED SUPPLIES 3,157 30,000 26,843 89. 1000-413-420140-228 PATROL CAR SUPPLIES 2,679 10,000 7,321 73. 1000-413-420140-229 OTHER SUPPLIES 1,536 5,000 3,464 69. 1000-413-420140-230 CRIME PREVENTION SUPPLIES 532 1,000 468 47. 1000-413-420140-231 GAS 18,664 75,000 56,336 75. 1000-413-420140-234 CRISIS NEGOTIATIONS 86 2,000 1,914 96. 1000-413-420140-235 BIKE PATROL 0 750 750 100. 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 394 1,500 1,106 74. 1000-413-420140-320 PRINTING 804 5,500 4,696 85. 1000-413-420140-345 TELEPHONE & COMMUNICATION 3,896 17,000 13,104 77. 1000-413-420140-354 CONTRACT SERVICES 4,451 7,000 2,549 36. 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 3,400 6, 500 3,100 48. 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 109 5,000 4,891 98. 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 146 2,000 1,854 93. 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 11,001 27,000 15,999 59. 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 407 2,500 2,093 84. 1000-413-420140-373 DUES & TRAINING 6,598 32,500 25,902 80. 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 4,573 5,000 427 9. 1000-413-420140-380 TRAINING MATERIALS 0 2,000 2,000 100. 1000-413-420140-388 MEDICAL SERVICES 1,235 3,000 1,766 59. 1000-413-420140-392 BOARDING/TREATING PRISONERS 878 2,500 1,623 65. 1000-413-420140-521 CENTRAL GARAGE TRANSFER 16,533 66,131 49,598 75. 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 16,000 64, 000 48,000 75. 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 15,000 60, 000 45,000 75. 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 875 3,500 2,625 75. 1000-413-420140-940 MAJOR CRIME UNIT TRAILER & RADAR TR 0 29,000 29,000 100. 1000-413-420140-942 EQUIPMENT -RADIO MATCH 0 53,500 53,500 100. 1000-413-420140-944 VEHICLES 18,000 99,055 81,055 82. SUBTOTAL POLICE DEPT. 928,605 3, 818, 058 2,889,453 76. 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 95,531 361, 097 265,566 74. 3,032 15,000 11,968 80. 20,002 71, 662 51,660 72. 11,966 48,339 36,373 75. 130,531 496, 098 365,567 74. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 7 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING RECORDS 1000-413-420142-110 SALARIES -RECORDS DIVISION 35,615 144,863 109,248 750s 1000-413-420142-121 OVERTIME 304 7,500 7,196 960s 1000-413-420142-153 HEALTH INSURANCE 8,304 33,228 24,924 750s 1000-413-420142-155 RETIREMENT 2,787 11,198 8,411 750s TOTAL RECORDS 47.010 196, 789 149,779 760s RESOURCE OFFICERS 1000-413-420144-110 SALARIES -SRO 57,365 257,288 199,923 780s 1000-413-420144-153 HEALTH INSURANCE 10,069 58, 576 48,507 830s 1000-413-420144-155 SRO RETIREMENT 6,737 34,530 27,793 800s TOTAL RESOURCE OFFICERS 74,171 350,394 276,223 790s ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL -SALARIES 10,845 40,750 29,905 730s 1000-413-420145-121 OVERTIME 0 500 500 1000s 1000-413-420145-153 HEALTH INSURANCE 2,076 9,307 7,231 780s 1000-413-420145-155 RETIREMENT 779 3,148 2,369 750s SUBTOTAL ANIMAL CONTROL 13,700 53,705 40,005 740s PARKING 1000-413-420147-110 PARKINGS -SALARIES 22,734 88,871 66,137 740s 1000-413-420147-153 HEALTH INSURANCE 6,448 25,837 19,389 750s 1000-413-420147-155 RETIREMENT 1,711 6, 866 5,155 750s 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 0 4,000 4,000 1000s 1000-413-420147-354 CONTRACTED SERVICES 91 2,000 1,909 950s 1000-413-420147-362 LOT MAINT 321 10,000 9,679 970s 1000-413-420147-365 SNOW REMOVAL -Parking Lots 0 17,500 17,500 1000s 1000-413-420147-550 LOT LEASE PAYMENTS 368 1,500 1,132 750s SUBTOTAL PARKING 31,673 156, 574 124,901 800s SUBTOTAL POLICE DEPT. 1,225,690 5,071,618 3,845,928 760s 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 8 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. FIRE DEPARTMENT 1000-416-420400-110 SALARIES -FIRE SUPPRESSION 347,114 1, 672, 064 1,324,950 79. 1000-416-420400-114 COMPTIME BUYOUT 0 5,500 5,500 100. 1000-416-420400-115 OUT OF RANK PAY 3,798 12,000 8,202 68. 1000-416-420400-121 OVERTIME 18,112 40,000 21,888 55. 1000-416-420400-153 HEALTH INSURANCE 55,841 315,034 259,193 82. 1000-416-420400-155 RETIREMENT 47,339 224,499 177,160 79. 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 0 2,000 2,000 100. 1000-416-420400-218 Equipment (Non Capital) 6,907 21,500 14,593 68. 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 802 15,000 14,198 95. 1000-416-420400-224 JANITORIAL SUPPLIES 1,062 5,000 3,938 79. 1000-416-420400-231 GAS 2,366 17,325 14,959 86. 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 400 15,750 15,350 97. 1000-416-420400-320 PRINTING 0 200 200 100. 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 0 1,000 1,000 100. 1000-416-420400-345 TELEPHONE & COMMUNICATION 901 6, 000 5,099 85. 1000-416-420400-354 CONTRACT SERVICES 6,875 37, 600 30,725 82. 1000-416-420400-362 EQUIPMENT MAINTENANCE 141 5,500 5,359 97. 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 1,822 7,500 5,678 76. 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 781 5,000 4,219 84. 1000-416-420400-373 DUES & TRAINING 1,428 10,000 8,572 86. 1000-416-420400-388 FIREFIGHTER PHYSICALS 0 25,875 25,875 100. 1000-416-420400-521 CENTRAL GARAGE TRANSFER 10,418 41,671 31,253 75. 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 0 33,500 33,500 100. 1000-416-420400-620 INTEREST EXPENSE -FIRE TRUCK 0 6, 500 6,500 100. 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 87,500 350,000 262,500 75. 1000-416-420400-821 TRANSFER TO FUND 2956 GRANT MATCH 0 21,040 21,040 100. 1000-416-420440-110 SALARIES -FIRE PREVENTION 5,995 20,173 14,178 70. 1000-416-420440-121 OVERTIME 655 0 655- 0. 1000-416-420440-153 HEALTH INSURANCE 1,308 5,145 3,837 75. 1000-416-420440-155 RETIREMENT 457 1,439 982 68. SUBTOTAL FIRE DEPT. 602.022 2, 923, 815 2,321,793 79. GRAND TOTAL GENERAL FUND SPECIAL REVENUE FUNDS: PERMISSIVE HEALTH LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND TOTAL PERMISSIVE HEALTH LEVY 2,746,484 11, 650, 571 8,904,087 76. 0 992,000 992,000 100. 0 992,000 992,000 100. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 9 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 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 16,271 999,000 982,729 98. 2215-000-311200-000 PERSONAL PROPERTY TAXES 29,340 40,000 10,660 27. 2215-000-312000-000 PEN & INTEREST DEL TAXES 764 2,000 1,236 62. 2215-000-346030-000 SWIMMING POOL FEES 93,492 127,000 33,508 26. 2215-000-346040-000 CONCESSION STAND REVENUE 30,316 34,000 3,685 11. 2215-000-346050-000 PARKS USAGE FEES 6,766 21,500 14,734 69. 2215-000-346051-000 RECREATION FEES 1,551 11,188 9,637 86. 2215-000-346052-000 SPORTS PROGRAMS 15,637 43,594 27,957 64. 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 815 2,500 1,685 67. 2215-000-346054-000 AFTER SCHOOL PROGRAMS 15,560 70,000 54,440 78. 2215-000-346055-000 ICE RINK 0 22,500 22,500 100. 2215-000-346056-000 KIDSPORT USAGE 430 2,000 1,570 79. 2215-000-346057-000 YOUTH CAMPS 3,258 143,147 139,889 98. 2215-000-346059-000 PICNIC IN THE PARK 3,494 25,000 21,506 86. 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 10,000 11,500 1,500 13. 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100. 2215-000-371010-000 INVESTMENTS 1,464 3,000 1,536 51. 2215-000-381050-000 INCEPTION OF LEASE 0 64, 000 64,000 100. 2215-000-381060-000 HEALTH INSURANCE TRANSFER 0 101,467 101,467 100. TOTAL PARKS & REC REVENUE 229,159 1,743,396 1,514,237 87. PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 79,646 322,778 243,132 75. 2215-436-460430-111 SEASONAL SALARIES 18,101 71,610 53,509 75. 2215-436-460430-121 OVERTIME 74 500 426 85. 2215-436-460430-153 HEALTH INSURANCE 15,462 61,917 46,455 75. 2215-436-460430-155 RETIREMENT 6,689 27,476 20,787 76. 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 193 1, 800 1,608 89. 2215-436-460430-215 EQUIPMENT - NOT CAPITAL 0 8, 000 8,000 100. 2215-436-460430-224 JANITORIAL SUPPLIES 2,580 6, 000 3,420 57. 2215-436-460430-229 OTHER SUPPLIES 1,319 4,000 2,681 67. 2215-436-460430-231 GAS 4,820 14,000 9,180 66. 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 160 2,500 2,340 94. 2215-436-460430-320 PRINTING & ADVERTISING 0 400 400 100. 2215-436-460430-341 ELECTRICITY 3,863 16, 000 12,137 76. 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 0 22,500 22,500 100. 2215-436-460430-344 NATURAL GAS 137 2,500 2,363 95. 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 519 3, 600 3,081 86. 2215-436-460430-351 TENNIS COURT REHABILITATION 1,500 14,467 12,967 90. 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 2,000 2,000 100. 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 340 8,200 7,860 96. 2215-436-460430-356 CONSULTANTS 0 30,000 30,000 100. 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 0 2, 680 2,680 100. 2215-436-460430-358 FVCC TENNIS INTERLOCAL AGREEMENT 0 7,000 7,000 100. 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 407 30,000 29,593 99. 2215-436-460430-364 LANDSCAPING 99 6, 000 5,901 98. 2215-436-460430-367 VANDALISM REPAIRS 100 4,000 3,900 98. 2215-436-460430-373 DUES & TRAINING 81- 8, 000 8,081 101. 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 0 400 400 100. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 10 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 2215-436-460430-395 EQUIPMENT RENTAL 0 700 700 1000s 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 0 5,500 5,500 1000s 2215-436-460430-440 IRRIGATION SUPPLIES 2,898 9,000 6,102 680s 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 160 1,700 1,540 910s 2215-436-460430-521 CENTRAL GARAGE TRANSFER 10,159 40, 634 30,475 750s 2215-436-460430-610 DEBT SERVICE PRINCIPAL 13,438 41, 602 28,164 680s 2215-436-460430-620 DEBT SERVICE INTEREST 1,033 4,280 3,247 760s 2215-436-460430-931 PARK IMPROV - THOMPSON PLAYGROUND 0 29,000 29,000 1000s 2215-436-460430-932 PARK IMPROV - NORTHRIDGE IRRIGATION 0 20,000 20,000 1000s 2215-436-460430-933 PARK IMPROVEMENTS - DOG PARK 29,180 50,000 20,820 420s 2215-436-460430-941 KUBOTA MOWER AND SPRAY GATOR (FY17/ 69 64, 000 63,931 1000s SUBTOTAL PARKS EXPENDITURES 192,863 944,744 751,881 800s ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 22,004 90,559 68,555 760s 2215-436-460440-111 SEASONAL SALARIES 21,432 41,904 20,472 490s 2215-436-460440-153 HEALTH INSURANCE 5,541 28,403 22,862 800s 2215-436-460440-155 RETIREMENT 3,166 6, 975 3,809 550s 2215-436-460440-221 SAFETY EQUIPMENT 0 350 350 1000s 2215-436-460440-229 OTHER SUPPLIES 1,594 15,500 13,906 900s 2215-436-460440-231 GAS 2,751 9,500 6,749 710s 2215-436-460440-241 CONSUMABLE TOOLS 38 5,000 4,962 990s 2215-436-460440-341 ELECTRICITY 5,070 8, 500 3,430 400s 2215-436-460440-345 TELEPHONE & COMMUNICATION 36 175 139 790s 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 1000s 2215-436-460440-355 CONTRACT SERVICES - ASPHAT RESURFC 0 50,000 50,000 1000s 2215-436-460440-362 EQUIPMENT MAINTENANCE 144 600 456 760s 2215-436-460440-364 LANDSCAPING 136 600 464 770s 2215-436-460440-367 VANDALISM REPAIRS 0 500 500 1000s 2215-436-460440-373 DUES & TRAINING 0 500 500 1000s 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 0 200 200 1000s 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 1000s 2215-436-460440-420 METAL PRODUCTS 0 5,300 5,300 1000s 2215-436-460440-440 IRRIGATION 2,429 4,500 2,071 460s 2215-436-460440-452 SAND & GRAVEL 817 1,000 183 180s 2215-436-460440-521 CENTRAL GARAGE TRANSFER 274 1,097 823 750s 2215-436-460440-940 EQUIPMENT - SAND PRO GROOMER 2,650 5,000 2,350 470s SUBTOTAL ATHLETIC COMPLEX 68,081 277,313 209,232 750s RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 22,196 83,239 61,043 730s 2215-436-460431-111 SEASONAL SALARIES 1,741 8, 389 6,648 790s 2215-436-460431-153 HEALTH INSURANCE 4,927 19,973 15,046 750s 2215-436-460431-155 RETIREMENT 1,731 6, 943 5,212 750s 2215-436-460431-229 MISC. SUPPLIES 2,111 9,070 6,959 770s 2215-436-460431-231 GAS 186 720 534 740s 2215-436-460431-320 PRINTING & ADVERTISING 0 11,265 11,265 1000s 2215-436-460431-345 TELEPHONE & COMMUNICATION 102 640 538 840s 2215-436-460431-354 CONTRACT SERVICES 16,090 21, 060 4,970 240s 2215-436-460431-355 On Line Registration 0 7,499 7,499 1000s 2215-436-460431-357 MUSIC FRANCHISE FEES 0 1,100 1,100 1000s 2215-436-460431-373 DUES & TRAINING 0 1.000 1.000 1000s 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 11 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. SUBTOTAL RECREATION 49.084 170, 898 121,814 71. YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 19,928 74,110 54,182 73. 2215-436-460448-111 SEASONAL SALARIES 54,185 139,101 84,916 61. 2215-436-460448-121 OVERTIME 0 300 300 100. 2215-436-460448-153 HEALTH INSURANCE 4,634 18,797 14,163 75. 2215-436-460448-155 RETIREMENT 1,553 6, 622 5,069 77. 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 30 400 370 92. 2215-436-460448-229 MISC. SUPPLIES 977 3,730 2,754 74. 2215-436-460448-231 GAS 0 500 500 100. 2215-436-460448-320 PRINTING & ADVERTISING 0 270 270 100. 2215-436-460448-345 TELEPHONE & COMMUNICATION 216 1,000 784 78. 2215-436-460448-354 CONTRACT SERVICES 7,551 11,380 3,829 34. 2215-436-460448-355 AFTER SCHOOL PROGRAM 0 1,200 1,200 100. 2215-436-460448-356 BANK FEES/CC CHARGES 675 6, 080 5,405 89. 2215-436-460448-373 DUES & TRAINING 0 1,000 1,000 100. SUBTOTAL YOUTH CAMPS 89,747 264,490 174,743 66. POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 118,023 179,308 61,285 34. 2215-437-460445-121 OVERTIME 129 500 371 74. 2215-437-460445-155 RETIREMENT 1,018 1,500 482 32. 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 125 500 375 75. 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,573 2,700 1,127 42. 2215-437-460445-226 CHLORINE/CHEMICALS 14,601 27,000 12,399 46. 2215-437-460445-228 CONCESSION STAND SUPPLIES 12,753 21,000 8,247 39. 2215-437-460445-229 TOOLS/OTHER SUPPLIES 375 4,500 4,125 92. 2215-437-460445-341 ELECTRICITY 4,013 9,500 5,487 58. 2215-437-460445-344 NATURAL GAS 10,814 25,000 14,186 57. 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 567 1, 620 1,053 65. 2215-437-460445-354 LICENSES & FEES 79 1,300 1,221 94. 2215-437-460445-356 BANK FEES/ CC CHARGES 1,750 1,632 118- -7. 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 2,138 45,500 43,362 95. 2215-437-460445-380 TRAINING MATERIALS 0 1, 800 1,800 100. SUBTOTAL POOL EXPENDITURES 167,957 323,360 155,403 48. TOTAL PARKS & RECREATION/POOL 567,732 1, 980, 805 1,413,073 71. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 12 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FORESTRY & DEVELOPER TREES 2600-436-460433-110 SALARIES -URBAN FORESTRY 26,886 161, 069 134,183 830s 2600-436-460433-111 SEASONAL SERVICES 0 29, 856 29,856 1000s 2600-436-460433-121 OVERTIME 10 1,000 990 990s 2600-436-460433-153 HEALTH INSURANCE 5,840 42,075 36,235 860s 2600-436-460433-155 RETIREMENT 2,056 14,088 12,032 850s 2600-436-460433-229 OFFICE/OTHER SUPPLIES 0 600 600 1000s 2600-436-460433-231 GAS 291 2,500 2,209 880s 2600-436-460433-241 CONSUMABLE TOOLS 52 3,249 3,197 980s 2600-436-460433-354 CONTRACT SERVICES 3,789 356, 560 352,771 990s 2600-436-460433-357 FORESTRY GRANT 6,943 19,500 12,558 640s 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 1,701 5,000 3,299 660s 2600-436-460433-362 EQUIPMENT MAINTENANCE 116 2,500 2,384 950s 2600-436-460433-364 LANDSCAPING & TREES 0 8, 000 8,000 1000s 2600-436-460433-373 DUES & TRAINING 1,247 3,500 2,253 640s 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 1,138 1,138 0 00s 2600-436-460433-521 CENTRAL GARAGE TRANSFER 2,042 8,167 6,125 750s 2600-436-460433-522 ADMINISTRATIVE TRANSFER 3,049 12,197 9,148 750s 2600-436-460433-528 DATA PROCESSING TRANSFER 1,043 4,171 3,128 750s 2600-436-460433-610 DEBT SERVICE PRINCIPAL 5,442 14,905 9,463 630s 2600-436-460433-620 INTEREST EXPENSE 394 1,295 901 700s 2600-436-460433-940 MACHINERY & EQUIPMENT 0 55,000 55,000 1000s TOTAL URBAN FORESTRY 62,039 746, 370 684,331 920s 2601-436-460435-351 EMPIRE ESTATES ($44,911) 0 8,653 8,653 1000s 2601-436-460435-352 APPLEWAY ($4,564) 0 4,336 4,336 1000s 2601-436-460435-353 LEISURE HEIGHTS ($9,990) 0 366 366 1000s 2601-436-460435-354 CONTRACT SERVICES 0 11,231 11,231 1000s 2601-436-460435-356 SINOPAH SUED ($5,790) 0 667 667 1000s 2601-436-460435-357 COTTONWOOD SUED ($13,100) 0 1,603 1,603 1000s 2601-436-460435-358 WEST VIEW SUED ($22,680) 0 14,936 14,936 1000s 2601-436-460435-359 MTN VISTA ESTATES ($35,903+34,660) 0 25,129 25,129 1000s 2601-436-460435-361 VILLAGE GREENS ($3,540) 0 2,219 2,219 1000s 2601-436-460435-362 WESTVIEW BUSINESS CNTR ($1,618) 0 948 948 1000s 2601-436-460435-363 MUSKRAT SLOUGH ($1,446) 0 1,390 1,390 1000s 2601-436-460435-364 MTN VISTA ESTATES III $17,278.25 0 484 484 1000s 2601-436-460435-365 VILLAGE GREENS $3,540 0 578 578 1000s 2601-436-460435-366 W VIEW ESTATES $20, 060 0 8,490 8,490 1000s 2601-436-460435-367 ABIGAIL SUBDIVISION ($4,253.90) 0 2,358 2,358 1000s 2601-436-460435-368 NORTHLAND SUED PHASE 4 0 8,812 8,812 1000s 2601-436-460435-369 GL VILLAGE GREENS, Ph 22B ($4,130) 0 1,474 1,474 1000s 2601-436-460435-370 GL VILLAGE GREENS PH22C ($5,600) 0 1,100 1,100 1000s TOTAL DEVELOPER TREES 0 94,774 94,774 1000s 2210 PARKS IN LIEU 2210-436-460430-934 CAPITAL IMPROVEMENTS 0 1,432 1,432 1000s TOTAL PARKS IN LIEU 0 1,432 1,432 1000s 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 13 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 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 145,262 750,000 604,738 81. 2230-000-342070-000 COUNTY EMS LEVY 0 110,000 110,000 100. 2230-000-383010-000 TRANSFER FROM GENERAL FUND 87,500 350,000 262,500 75. TOTAL AMBULANCE REVENUE 232.762 1,210,000 977,238 81. AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 134,204 640, 748 506,544 79. 2230-440-420730-114 COMPTIME BUYBACK 0 3,500 3,500 100. 2230-440-420730-115 OUT OF RANK PAY 467 2,500 2,033 81. 2230-440-420730-121 OVERTIME 4,880 30,000 25,120 84. 2230-440-420730-153 HEALTH INSURANCE 25,713 156,265 130,552 84. 2230-440-420730-155 RETIREMENT 17,951 85,036 67,085 79. 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 0 1,400 1,400 100. 2230-440-420730-218 NON -CAPITAL EQUIPMENT 0 4,200 4,200 100. 2230-440-420730-231 GAS & OIL 1,337 7, 560 6,223 82. 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 0 4,000 4,000 100. 2230-440-420730-312 POSTAGE/PRINTING 0 1,500 1,500 100. 2230-440-420730-345 TELEPHONE & COMMUNICATION 262 1,700 1,438 85. 2230-440-420730-354 CONTRACT SERVICES 3,392 43, 690 40,298 92. 2230-440-420730-355 911 CENTER CONTRIBUTION 8,625 34,500 25,875 75. 2230-440-420730-359 AUDIT/CC OTHER FEES 662 1, 650 988 60. 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 0 5,000 5,000 100. 2230-440-420730-373 DUES & TRAINING 65 5,000 4,935 99. 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,500 2,500 100. 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 5,564 48,300 42,736 88. 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 25,771 25,886 115 0. 2230-440-420730-521 CENTRAL GARAGE TRANSFER 4,518 18,070 13,552 75. 2230-440-420730-522 ADMINISTRATIVE TRANSFER 12,102 48,407 36,305 75. 2230-440-420730-528 DATA PROCESSING TRANSFER 4,171 16,684 12,513 75. TOTAL AMBULANCE EXPENDITURES 249,684 1,188,096 938,412 79. 2399 PUBLIC SAFETY IMPACT FEES 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 3,750 15,000 11,250 75. 2399-413-420140-940 POLICE EQUIPMENT 0 100,000 100,000 100. 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 34,000 67, 675 33,675 50. 2399-416-420400-620 INTEREST - FIRE TRUCK 1,360 2,034 674 33. 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 750,000 750,000 100. TOTAL PUBLIC SAFETY IMPACT FEE 39,110 934,709 895,599 96. FIRE & HAZMAT GRANTS 2956-416-420400-218 EQUIPMENT (NON CAPITAL) 320 0 320- 0. 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 1,773 5,000 3,227 65. 2956-416-420415-940 AFG GRT FY16 COTS/ FY18 SCBA 0 231,448 231,448 100. TOTAL FIRE GRANTS 2,093 236,448 234,355 99. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 14 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 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 594 10,000 9,406 94. 2957-416-420410-218 PASS THRU HAZMAT EQUIP 487 9,000 8,513 95. 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 788 2,000 1,212 61. TOTAL HAZMAT GRANTS 1,869 23,500 21,631 92. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 15 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 219,059 800, 000 580,941 73. 2394-000-323103-000 PLUMBING PERMITS 8,434 30,000 21,566 72. 2394-000-323104-000 MECHANICAL PERMITS 34,492 40,000 5,508 14. 2394-000-323105-000 ELECTRICAL PERMITS 25,878 75,000 49,122 66. 2394-000-323108-000 PLAN REVIEW FEES 85,573 400,000 314,427 79. 2394-000-371010-000 INVESTMENT EARNINGS 4,177 5,000 823 16. TOTAL REVENUE 377,614 1,350,000 972,386 72. BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 106,192 490,717 384,525 78. 2394-420-420530-121 OVERTIME 8,899 10,000 1,101 11. 2394-420-420530-153 HEALTH INSURANCE 21,028 101,155 80,127 79. 2394-420-420530-155 RETIREMENT 8,724 36,340 27,616 76. 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 27,592 28,105 513 2. 2394-420-420530-231 GAS & OIL 673 3,500 2,827 81. 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 0 7,300 7,300 100. 2394-420-420530-323 ST. ED. ASSESSMENTS 0 7,500 7,500 100. 2394-420-420530-345 TELEPHONE & COMMUNICATION 768 4,000 3,232 81. 2394-420-420530-353 AUDITING 0 4,500 4,500 100. 2394-420-420530-354 CONTRACT SERVICES 7,796 10,000 2,204 22. 2394-420-420530-355 CITY WORKS LICENSING FEE 0 21,250 21,250 100. 2394-420-420530-356 ARCGIS SERVER UPGRADE LICENSE 9,500 9,500 0 0. 2394-420-420530-360 FURNITURE 2,125 9,000 6,875 76. 2394-420-420530-373 DUES & TRAINING 4,736 20,000 15,264 76. 2394-420-420530-510 PROPERTY INSURANCE 5,378 5, 389 11 0. 2394-420-420530-521 CENTRAL GARAGE TRANSFER 470 1,882 1,412 75. 2394-420-420530-522 ADMINISTRATIVE TRANSFER 5,363 21,454 16,091 75. 2394-420-420530-528 DATA PROCESSING TRANSFER 7,299 29, 196 21,897 75. 2394-420-420530-920 AWNING 0 10,000 10,000 100. 2394-420-420530-940 SERVER 0 10,000 10,000 100. 2394-420-420530-944 VEHICLES 800 85, 000 84,200 99. TOTAL BUILDING DEPT. 217,344 925,788 708,444 77. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 16 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 18,113 72,058 53,945 75. 2400-410-430263-153 HEALTH INSURANCE 2,882 12,535 9,653 77. 2400-410-430263-155 RETIREMENT 1,359 5,324 3,965 74. 2400-410-430263-244 STREET LIGHT SUPPLIES 611 18, 000 17,389 97. 2400-410-430263-245 LUMINAIRES 8,789 30,000 21,211 71. 2400-410-430263-246 LED LUMINAIRE UPGRADE 0 60, 000 60,000 100. 2400-410-430263-341 ELECTRICITY 37,652 182,000 144,348 79. 2400-410-430263-360 REPAIR & MAINT SERVICES 2,021 20,000 17,979 90. 2400-410-430263-510 INSURANCE 711 1,500 789 53. 2400-410-430263-522 ADMINISTRATIVE TRANSFER 3,301 13,202 9,901 75. 2400-410-430263-920 NEW LUMINAIRES 11,286 0 11,286- 0. 2400-410-430263-940 MACHINERY & EQUIPMENT 0 36, 000 36,000 100. 2400-410-490500-610 DEBT SERVICE -PRINCIPAL 11,014 22,055 11,041 50. 2400-410-490500-620 DEBT SERVICE -INTEREST EXPENSE 273 551 278 50. TOTAL LIGHT MAINT. 98,010 473,225 375,215 79. 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 31,337 94,557 63,220 67. 2420-421-430234-957 ALLEY PAVING 0 40,000 40,000 100. 2420-421-430240-231 GAS & OIL 6,526 40,000 33,474 84. 2420-421-430240-344 NATURAL GAS 58 5,500 5,442 99. 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 100. 2420-421-430240-360 REPAIR & MAINT SERVICES 0 1,500 1,500 100. 2420-421-430240-368 OVERLAY/CHIPSEALS 119,073 269, 073 150,000 56. 2420-421-430240-452 GRAVEL 3,334 3,500 166 So 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 100. 2420-421-430240-471 DE-ICER/ROAD OIL 3,249 40,000 36,751 92. 2420-421-430240-472 ASPHALT 4,331 53,000 48,669 92. 2420-421-430240-473 CRACK SEALING 0 14,500 14,500 100. 2420-421-430240-474 PAINT STRIPING MATERIALS 1,345 30,000 28,655 96. TOTAL GAS TAX 169,253 616, 630 447,377 73. 2825 MAGI GRANT 2825-421-430240-940 SANDER / SWEEPER 0 433,202 433,202 100. TOTAL MAGI GRANT 0 433,202 433,202 100. 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 176,960 731,217 554,257 76. 2500-421-430240-121 OVERTIME 337 25,000 24,663 99. 2500-421-430240-153 HEALTH INSURANCE 35,827 163,219 127,392 78. 2500-421-430240-155 RETIREMENT 13,237 53,704 40,467 75. 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 586 12,360 11,774 95. 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,209 8,950 7,741 87. 2500-421-430240-220 OTHER SUPPLIES 513 4,500 3,987 89. 2500-421-430240-231 GAS & OIL 6,900 40,000 33,100 83. 2500-421-430240-341 ELECTRICITY 549 3,500 2,951 84. 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 386 1,500 1,114 74. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 17 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. 2500-421-430240-354 CONTRACT SERVICES 30,250 30,000 250- -1°s 2500-421-430240-356 CONSULTANT 0 65, 050 65,050 1000s 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 2,303 33,500 31,197 930s 2500-421-430240-366 BUILDING MAINTENANCE 60 5,000 4,940 990s 2500-421-430240-373 DUES & TRAINING 614 5,500 4,886 890s 2500-421-430240-388 MEDICAL SERVICES 0 1,000 1,000 1000s 2500-421-430240-510 LIABILITY INSURANCE 17,650 17,359 291- -20s 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 1000s 2500-421-430240-521 CENTRAL GARAGE TRANSFER 45,059 180,235 135,176 750s 2500-421-430240-522 ADMINISTRATIVE TRANSFER 23,325 93,300 69,975 750s 2500-421-430240-528 DATA PROCESSING TRANSFER 3,128 12,513 9,385 750s 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 37,366 122,878 85,512 700s 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 1,369 35,820 34,451 960s 2500-421-430240-920 SALT BRINE TANK 0 11,050 11,050 1000s 2500-421-430240-921 SAND/COLD MIX STORAGE SHED 14,227 15,325 1,098 70s 2500-421-430240-923 COLD STORAGE ROOF REPLACEMENT 0 31,500 31,500 1000s 2500-421-430240-953 SHOP COMPLEX PAYVEMENT RESTORATION 0 38,200 38,200 1000s 2500-421-430240-969 4TH AVE E MAIN REPLC PHASE 1-4 615,098 670, 000 54,902 80s 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 233,569 881,952 648,383 740s 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 10,185 330,807 320,622 970s 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 1000s 2500-421-430264-110 TSS - SALARIES 30,337 124,700 94,363 760s 2500-421-430264-121 OVERTIME 0 7,500 7,500 1000s 2500-421-430264-153 HEALTH INSURANCE 4,225 17,614 13,389 760s 2500-421-430264-155 RETIREMENT 2,236 9,084 6,848 750s 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 539 1,500 961 640s 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 481 10,200 9,719 950s 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 256 3,500 3,244 930s 2500-421-430264-242 STREET SIGNS 902 35,000 34,098 970s 2500-421-430264-243 TRAFFIC SIGNALS 119 20,000 19,881 990s 2500-421-430264-245 BARRICADE MATERIALS 0 5,000 5,000 1000s 2500-421-430264-341 ELECTRICITY 349 3,000 2,651 880s 2500-421-430264-345 COMMUNICATIONS 195 850 655 770s 2500-421-430264-354 CONTRACT SERVICES 6,222 10,000 3,778 380s 2500-421-430264-362 EQUIPMENT MAINTENANCE 714 3,000 2,286 760s 2500-421-430264-366 BUILDING MAINTENANCE 0 2,000 2,000 1000s 2500-421-430264-373 DUES & TRAINING 826 5,500 4,674 850s 2500-421-430264-428 PAINT MATERIALS 3,877 5,000 1,123 220s 2500-421-430264-510 LIABILITY INS.-TSS 1,793 2,014 221 110s 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 0 2,500 2,500 1000s 2500-421-430264-521 CENTRAL GARAGE TRANSFER 2,006 8,024 6,018 750s 2500-421-430264-532 OFFICE RENT 6,422 6,422 0 00s 2500-421-430264-940 MACHINERY & EQUIPMENT 0 36, 000 36,000 1000s TOTAL SPEC. ST. MAINT. 1,332,207 3,981,175 2,648,968 670s 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 18 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 0 1, 600 1,600 100. 2185-000-430300-522 ADMINISTRATIVE TRANSFER 2,494 9,975 7,481 75. 2185-000-430300-840 REDEVELOPMENT ACTIVITY 0 2,000,000 2,000,000 100. 2185-480-470240-110 SALARIES 4,945 19, 988 15,043 75. 2185-480-470240-153 HEALTH INSURANCE 1,025 2, 963 1,938 65. 2185-480-470240-155 RETIREMENT 388 1,568 1,180 75. 2185-480-470240-345 TELEPHONE & COMMUNICATION 12 48 36 75. TOTAL AIRPORT TIF 8,864 2, 036, 142 2,027,278 100. 2188 WESTSIDE TIF 2188-480-470230-110 SALARIES 10,613 43,230 32,617 75. 2188-480-470230-153 HEALTH INSURANCE 1,648 5,599 3,951 71. 2188-480-470230-155 RETIREMENT 832 3,375 2,543 75. 2188-480-470230-353 AUDIT 0 3,000 3,000 100. 2188-480-470230-354 TO PORT/GATEWAY W. BLDG MAINT. 0 5,000 5,000 100. 2188-480-470230-356 TELEPHONE 48 192 144 75. 2188-480-470230-522 ADMINISTRATIVE TRANSFER 991 3, 966 2,975 75. 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 445 950,000 949,555 100. 2188-480-470230-840 TRANSFER TO DEBT SERVICE 10,000 40,000 30,000 75. 2188-480-470230-842 TRANSFER TO DEBT SERVICE FUND 3188 0 200,000 200,000 100. 2188-480-470240-720 PRE AWARD TIGER 25,284 0 25,284- 0. 2188-480-470240-840 TRANSFER TO TIGER GRANT FUND 0 8,107,000 8,107,000 100. TOTAL WESTSIDE TIF 49,861 9,361,362 9,311,501 99. OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 11,000 11,000 100. 2310-480-470210-356 FED -EX REIMBURSEMENT 0 10,500 10,500 100. 2310-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 15,000 60, 000 45,000 75. 2311-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 2,500 10,000 7,500 75. TOTAL OLD SCHOOL TIFS 17,500 91,500 74,000 81. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 19 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 0 1,000 1,000 100. 2880-480-470210-354 CONTRACT SERVICES 0 1,000 1,000 100. 2880-480-470210-711 REDEVELOPMENT 15,498 100,000 84,502 85. TOTAL LOAN REVOLVING 15,498 102,000 86,502 85. 2881 CD LOAN REV. 42 2881-480-470210-711 REDEVELOPMENT 0 150,000 150,000 100. TOTAL 2881 CD REV. 42 0 150,000 150,000 100. 2886 CD MISC. 2886-480-470210-211 GRANT ADMINISTRATION EXP/PROJECT EX 0 2,000 2,000 100. 2886-480-470210-353 AUDITING 0 1,000 1,000 100. 2886-480-470210-373 DUES & TRAINING 0 2,000 2,000 100. 2886-480-470210-379 MEETINGS 0 1,000 1,000 100. 2886-480-470210-396 GRANT SERVICES 0 5,000 5,000 100. 2886-480-470210-522 ADMINISTRATIVE TRANSFER 0 2,000 2,000 100. 2886-480-470210-528 DATA PROCESSING TRANSFER 2,085 8,342 6,257 75. 2886-480-470210-532 OFFICE RENT 1,175 1,175 0 0. 2886-480-470210-620 INTEREST - OLD SCHOOL LOAN - GENERA 0 32,500 32,500 100. 2886-480-470210-790 COMM. DEV. ACTIVITIES 0 3,750 3,750 100. 2886-480-470210-795 REDEVELOPMENT- OLD SCHOOL STATION 0 175,102 175,102 100. TOTAL CD MISC. 3,260 233,869 230,609 99. 2887 RURAL DEVELOPMENT 41 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 0 18,454 18,454 100. 2887-480-470210-620 INTEREST EXPENSE/L#61-01 0 3, 620 3,620 100. 2887-480-470210-750 REDEVELOPMENT LOANS 0 200,000 200,000 100. TOTAL RURAL DEVELOPMENT 41 0 222,074 222,074 100. 2888 RURAL DEVELOPMENT 42 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 0 8,219 8,219 100. 2888-480-470210-620 INTEREST EXPENSE -USDA LOAN 61-03 0 1,806 1,806 100. 2888-480-470210-750 REDEVELOPMENT LOANS 0 150,000 150,000 100. TOTAL RURAL DEVELOPMENT 42 0 160, 025 160,025 100. 2953 EPA BROWNFIELDS 2953-480-470210-354 CONT SERV/PETROLEUM 0 185,592 185,592 100. 2953-480-470210-373 TRAVEL/PETROLEUM 227 3,357 3,130 93. 2953-480-470215-354 CONT SERV/HAZARDOUS 0 185,592 185,592 100. 2953-480-470215-373 TRAVEL/HAZARDOUS 227 3,517 3,290 94. TOTAL EPA BROWNSFIELD 454 378,058 377,604 100. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 20 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 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-PETROLUEM 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 - TRAIL 2991-480-470245-791 REDEVELOPMENT - RAIL PARK TOTAL TIGER GRANT 2994 KIDSPORTS GRANT 2994-436-460436-930 CAPITAL IMPROVEMENTS TOTAL KIDSPORTS GRANT 0 908 908 100. 0 3,505 3,505 100. 0 493 493 100. 0 1,488 1,488 100. 0 62, 354 62,354 100. 0 100,000 100,000 100. 0 100,500 100,500 100. 0 1,158 1,158 100. 0 88 88 100. 0 2,330 2,330 100. 0 314, 600 314,600 100. 0 587,424 587,424 100. 0 5,787,000 5,787,000 100. 170,147 12,320,000 12,149,853 99. 170,147 18,107,000 17,936,853 99. 16,179 1,302,724 1,286,545 99. 16.179 1,302,724 1,286.545 99. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 21 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 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 2915-413-420140-354 CONT SERV-WPD/MFWPE - STONEGARDEN TOTAL 2915 STONEGARDEN GRANT 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 2916-413-420140-121 OVERTIME 2916-413-420140-153 HEALTH INSURANCE 2916-413-420140-155 RETIREMENT 2916-413-420140-354 CONTRACT SERVICES TOTAL 2916 DRUG ENFORCEMENT 2918 CHRP GRANT 2918-413-420140-110 SALARIES & PAYROLL COSTS 2918-413-420140-153 HEALTH INSURANCE 2918-413-420140-155 RETIREMENT TOTAL CHRP GRANT 1,367 20,264 18,897 93. 0 41,209 41,209 100. 1,367 61,473 60,106 98. 14,199 62,808 48,609 77. 5,530 7,500 1,970 26. 1,999 8,307 6,308 76. 1,999 8,431 6,432 76. 1,295 6, 000 4,705 78. 25,022 93,046 68,024 73. 16,179 57,417 41,238 72. 2,076 8,307 6,231 75. 1,949 7,706 5,757 75. 20,204 73,430 53,226 72. 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 1,323 4,000 2,677 67. 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 12,677 36, 000 23,323 65. 2919-413-420140-127 SCHOOL DIST. OT 9,044 20,000 10,956 55. 2919-413-420140-218 JAG GRT/RADIOS & TRAINING 0 12,000 12,000 100. 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 1,447 12,500 11,053 88. 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 4,153 7,000 2,847 41. TOTAL LAW ENF. GRANT 28,644 91,500 62,856 69. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 22 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 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. 4,084 25,000 20,916 84. 4,084 25,000 20,916 84. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 23 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 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 540 0 540- 0. 5210-000-343210-000 METERED WATER SALES 1,310,569 2,900,000 1,589,431 55. 5210-000-343220-000 UNMETERED WATER SALES 949 0 949- 0. 5210-000-343225-000 IMPACT FEES 237,201 323,000 85,799 27. 5210-000-343230-000 METER REPLACEMENT FEE 26,327 98, 000 71,673 73. 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 16,350 100,000 83,650 84. 5210-000-343265-000 IMPACT ADMIN FEES 0 17,000 17,000 100. 5210-000-343270-000 WATER TURN ON FEES 1,560 0 1,560- 0. 5210-000-343275-000 TAG FEE 15,300 0 15,300- 0. 5210-000-343365-000 LATECOMER ADMIN FEE 5,586 0 5,586- 0. 5210-000-371010-000 INVESTMENT EARNINGS 22,949 80, 000 57,051 71. 5210-000-381050-000 INCEPTION OF LEASE (FOR BUDGET ONLY 0 2,151,616 2,151,616 100. TOTAL WATER REVENUE 1,637,331 5, 669, 616 4,032,285 71. WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 169,503 717,155 547,652 76. 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100. 5210-447-430550-121 OVERTIME 4,630 20,000 15,370 77. 5210-447-430550-153 HEALTH INSURANCE 35,306 162, 626 127,320 78. 5210-447-430550-155 RETIREMENT 12,980 52,778 39,798 75. 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 3,475 12,000 8,525 71. 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 1,219 8,500 7,281 86. 5210-447-430550-226 CHLORINE & CHEMICALS 11,719 38, 000 26,281 69. 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 518 4,500 3,982 88. 5210-447-430550-231 GAS & OIL 4,181 35,000 30,819 88. 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 0 1,000 1,000 100. 5210-447-430550-336 LICENSES & FEES 0 18, 500 18,500 100. 5210-447-430550-341 ELECTRICITY 62,131 150,000 87,869 59. 5210-447-430550-344 NATURAL GAS 613 15,500 14,887 96. 5210-447-430550-345 TELEPHONE & COMMUNICATION 2,634 10,500 7,866 75. 5210-447-430550-349 LAB SERVICES 3,378 20,000 16,622 83. 5210-447-430550-353 AUDITING 0 5,000 5,000 100. 5210-447-430550-354 CONTRACT SERVICES 9,351 55,000 45,649 83. 5210-447-430550-355 CONTRACT SERV.-AERIAL MAPPING 28 0 28- 0. 5210-447-430550-356 CONSULTANTS-WTR RIGHTS/MODELING 56,824 325,000 268,176 83. 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 1,939 15,000 13,061 87. 5210-447-430550-366 BUILDING MAINTENANCE 0 12,000 12,000 100. 5210-447-430550-373 DUES & TRAINING 1,443 9,000 7,557 84. 5210-447-430550-388 MEDICAL SERVICES 0 600 600 100. 5210-447-430550-410 CONSTRUCTION MATERIALS 6,923 35,000 28,077 80. 5210-447-430550-422 HYDRANTS 360 10,000 9,640 96. 5210-447-430550-423 MATERIALS FOR MAINS 881 14,000 13,119 94. 5210-447-430550-424 MATERIALS -SERVICE LINES 5,180 12,000 6,820 57. 5210-447-430550-425 MATERIALS PUMPS/WELLS 1,853 45,000 43,147 96. 5210-447-430550-510 PROPERTY & LIABILITY INS. 20,309 19,398 911- -5. 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 100. 5210-447-430550-521 CENTRAL GARAGE TRANSFER 5,937 23,750 17,813 75. 5210-447-430550-522 ADMINISTRATIVE TRANSFER 28,556 114,222 85,666 75. 5210-447-430550-528 DATA PROCESSING TRANSFER 7,299 36, 000 28,701 80. 5210-447-430550-532 LEASE PAYMENTS (City Hall rent) 7,573 9,500 1,927 20. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 24 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 5210-447-430550-921 SAND/COLD MIX STORAGE SHED 14,227 15,325 1,098 70s 5210-447-430550-936 Noffsinger Spring Generator 5,757 31,057 25,301 810s 5210-447-430550-938 OLD SCHOOL WELL FREQUENCY DRIVES 0 45,000 45,000 1000s 5210-447-430550-940 MACHINERY & EQUIPMENT 0 32,400 32,400 1000s 5210-447-430550-948 METERS (METER FUNDS) 010125 10,875 110,000 99,125 900s 5210-447-430550-951 SECURITY SCADA UPGRADES 995 15,000 14,005 930s 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 0 38,200 38,200 1000s 5210-447-430550-959 PARKS METERING PHASE II 4,110 28,416 24,306 860s 5210-447-430550-962 9TH AVE WEST WATER MAIN REPLACEMENT 0 625, 000 625,000 1000s 5210-447-430550-963 8TH STREET WEST WATER MAIN REPLACEM 0 416, 000 416,000 1000s 5210-447-430550-969 4TH AVE E MAIN REPL. PH. 1 1,744,422 1,962,538 218,116 110s 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 320,254 320,254 1000s 5210-447-430555-941 METERS (NEW SERVICES)010120 14,950 45, 600 30,650 670s 5210-447-430555-953 SECTION 36 WELL 43,366 961, 746 918,380 950s SUBTOTAL WATER FACILITIES 2,305,446 6, 668, 065 4,362,619 650s 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-356 BILLING COST/PRINTING 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.25%;WRF8114 5210-447-490206-620 INT-MTR&WELL/WRF7104 1.25%;WRF8114 5210-447-490250-610 PRIN-WTR MAIN/WRF1032R 2%/IDAHO&MAI 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2%/IDAHO&MAIN SUBTOTAL REVENUE BONDS DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION TOTAL WATER FUND 27,432 111,417 83,985 750s 6,896 31, 823 24,927 780s 2,130 8, 527 6,397 750s 262 2, 500 2,238 900s 0 2, 000 2,000 1000s 980 45, 000 44,020 980s 10,626 22, 000 11,374 520s 0 3,000 3,000 1000s 834 2, 500 1,666 670s 2,863 11,451 8,588 750s 7,299 33, 000 25,701 780s 6,422 6,422 0 00s 65.744 279, 640 213.896 760s 0 70,000 70,000 1000s 25,943 25, 943 1 00s 350 350 0 00s 0 192,810 192,810 1000s 103,420 93,034 10,386- -110s 0 48, 000 48,000 1000s 3,240 3,240 0 00s 132,953 433,377 300,425 690s 0 840,000 840,000 1000s 0 840,000 840,000 1000s 2,504,142 8.221, 082 5,716.940 700s 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 25 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 26 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 540 0 540- 00s 5310-000-343310-000 SEWER SERVICE CHARGES 1,261,300 4,425,000 3,163,700 720s 5310-000-343330-000 IMPACT FEES (SANITARY) 304,867 540,000 235,133 440s 5310-000-343335-000 IMPACT FEES (WWTP) 187,976 320,000 132,024 410s 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 256 10,000 9,744 970s 5310-000-343365-000 LATECOMER ADMIN FEES 762 0 762- 00s 5310-000-371010-000 INVESTMENT EARNINGS 25,325 100,000 74,675 750s 5310-000-381050-000 INCEPTION OF LEASE 0 7,873,808 7,873,808 1000s TOTAL SEWER REVENUE 1,781,025 13,268,808 11,487,783 870s SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 5310-454-430620-153 HEALTH INSURANCE 5310-454-430620-155 RETIREMENT 5310-454-430620-215 OFFICE SUPPLIES/computers 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 5310-454-430620-354 BILLING COSTS/GRIZZLY SEC & POSTAGE 5310-454-430620-355 BILLING COSTS 5310-454-430620-356 BILLING COSTS/PRINTING 5310-454-430620-373 DUES & TRAINING 5310-454-430620-522 ADMINISTRATIVE TRANSFER 5310-454-430620-528 DATA PROCESSING TRANSFER 5310-454-430620-532 OFFICE RENT SUBTOTAL SEWER BILLING COSTS 23,131 94,168 71,037 750s 5,261 25,275 20,014 790s 1,793 7,190 5,397 750s 262 2, 500 2,238 900s 0 2, 000 2,000 1000s 980 45, 000 44,020 980s 10,654 22, 000 11,346 520s 0 3,000 3,000 1000s 834 2, 500 1,666 670s 2,629 10, 516 7,887 750s 7,299 33, 000 25,701 780s 6,422 6,422 0 00s 59,266 253,571 194,306 770s SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 61,381 252,466 191,085 760s 5310-454-430630-121 OVERTIME 92 5,500 5,408 980s 5310-454-430630-153 HEALTH INSURANCE 14,714 66,485 51,771 780s 5310-454-430630-155 RETIREMENT 4,635 18,683 14,048 750s 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 2,586 10,200 7,614 750s 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 1,098 8, 350 7,252 870s 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 81 2,300 2,219 960s 5310-454-430630-231 GAS & OIL 2,959 12,000 9,041 750s 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 0 500 500 1000s 5310-454-430630-341 ELECTRICITY 10,296 54,500 44,204 810s 5310-454-430630-344 NATURAL GAS 2,426 16, 500 14,074 850s 5310-454-430630-345 TELEPHONE & COMMUNICATION 9,138 24,000 14,862 620s 5310-454-430630-353 AUDITING 0 3,000 3,000 1000s 5310-454-430630-354 CONTRACT SERVICES 5,084 24,000 18,916 790s 5310-454-430630-356 CONSULTANTS 0 258,000 258,000 1000s 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 463 7,000 6,537 930s 5310-454-430630-373 DUES & TRAINING 35 5,500 5,465 990s 5310-454-430630-388 MEDICAL SERVICES 0 500 500 1000s 5310-454-430630-410 CONSTRUCTION MATERIALS 4,851 10,000 5,149 510s 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 9,601 50,000 40,399 810s 5310-454-430630-510 PROPERTY & LIABILITY INS. 17,457 18,416 959 So 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 13.408 25.000 11.592 460s 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 27 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 5310-454-430630-521 CENTRAL GARAGE TRANSFER 2,144 8,575 6,431 75. 5310-454-430630-522 ADMINISTRATIVE TRANSFER 16,015 64, 060 48,045 75. 5310-454-430630-528 DATA PROCESSING TRANSFER 4,171 19,000 14,829 78. 5310-454-430630-532 OFFICE RENT 6,422 6,422 0 0. 5310-454-430630-921 SAND/COLD MIX STORAGE SHED 14,227 15,325 1,098 7. 5310-454-430630-940 MACHINERY & EQUIPMENT 0 92,400 92,400 100. 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 0 38,200 38,200 100. 5310-454-430630-954 GRANDVIEW L.S. RELOCATION & UPSIZE 0 230,000 230,000 100. 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 0 20,000 20,000 100. 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 2,437 50,000 47,563 95. 5310-454-430630-962 SEWER MAIN SLIP LINING 0 195,000 195,000 100. SUBTOTAL SEWER COLLECTION 205,720 1,611,882 1,406,162 87. IMPACT FEES 5310-454-430635-954 GRANDVIEW L.S RELOCATION & UPSIZE 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 5310-454-430635-956 WEST SIDE INTERCEPTOR PHASE I 5310-454-430635-957 WEST SIDE INTERCEPTOR SUBTOTAL IMPACT FEE EXPENSE REVENUE BONDS/SANITARY 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.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 5310-455-430640-110 5310-455-430640-111 5310-455-430640-121 5310-455-430640-153 5310-455-430640-155 5310-455-430640-210 5310-455-430640-218 5310-455-430640-225 5310-455-430640-226 5310-455-430640-229 5310-455-430640-231 5310-455-430640-312 SUBTOTAL DEPRECIATION -SANITARY SUBTOTAL SANITARY SEWER 0 230, 000 230,000 100. 0 200,000 200,000 100. 0 7, 086,427 7,086,427 100. 46,810 1, 180, 861 1,134,051 96. 46,810 8, 697,288 8,650,478 99. 0 83, 000 83,000 100. 13,511 13, 511 0- 0. 0 350 350 100. 13,511 96,861 83,350 86. 0 820,000 820,000 100. 0 820,000 820,000 100. 266.042 11,226,031 10,959,989 98. WWTP/OPERATIONS SALARIES-WWTP 107,428 448,827 341,399 76. SEASONAL SALARIES 1,818 5,000 3,182 64. OVERTIME 5,573 22,500 16,927 75. HEALTH INSURANCE 21,272 89,216 67,945 76. RETIREMENT 8,516 32,959 24,443 74. OFFICE/COMPUTER SUPPLIES/EQUIP 493 10,000 9,507 95. SAFETY EQUIP & SUPPLIES 38 2,700 2,662 99. ALUM 0 20,000 20,000 100. CHLORINE & CHEMICALS 19,601 45,000 25,399 56. JANITORIAL/OTHER SUPPLIES/RENTAL 487 7,000 6,513 93. GAS & OIL 1,993 16, 000 14,007 88. POSTAGE. PRINTING & ADVERTISING 233 350 118 34. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 28 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 5310-455-430640-336 LICENSES & FEES 0 10,000 10,000 100. 5310-455-430640-341 ELECTRICITY 43,432 180, 000 136,568 76. 5310-455-430640-342 WATER 1,128 7,500 6,372 85. 5310-455-430640-344 NATURAL GAS 1,518 60, 000 58,482 97. 5310-455-430640-345 TELEPHONE & COMMUNICATION 1,526 6, 500 4,974 77. 5310-455-430640-353 AUDITING 0 4,000 4,000 100. 5310-455-430640-354 CONTRACT -GLACIER GOLD 30,370 124,000 93,630 76. 5310-455-430640-355 OTHER CONTRACT SERVICES 7,474 30,000 22,526 75. 5310-455-430640-356 CONSULTANTS 13,403 100,000 86,597 87. 5310-455-430640-358 CONSULTANT-TMDL 632 125,000 124,368 99. 5310-455-430640-360 MISC. MAINT SERVICES 4,533 30,000 25,467 85. 5310-455-430640-366 BUILDING MAINTENANCE 230 50,000 49,770 100. 5310-455-430640-373 DUES & TRAINING 2,319 7,500 5,182 69. 5310-455-430640-388 MEDICAL SERVICES 268 500 232 46. 5310-455-430640-510 PROPERTY & LIABILITY INS. 36,350 36,384 34 0. 5310-455-430640-521 CENTRAL GARAGE TRANSFER 3,461 13,842 10,382 75. 5310-455-430640-522 ADMINISTRATIVE TRANSFER 30,705 122,819 92,114 75. 5310-455-430640-528 DATA PROCESSING TRANSFER 5,214 27,500 22,286 81. 5310-455-430640-920 BUILDINGS 0 32,000 32,000 100. 5310-455-430640-940 COAT BASIN FY15; BOILER/HEAT EXCHAN 0 75,000 75,000 100. SUBTOTAL WWTP OPERATIONS 350,013 1,742,097 1,392,084 80. WWTP BONDED PROJECT SUBTOTAL WWTP BONDED 0 0 0 0. WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 3,846 100,000 96,154 96. 5310-455-430645-933 SOLIDS DEWATERING DESIGN & CONST. 0 98,462 98,462 100. 5310-455-430645-934 SECONDARY DIGESTER LID INSPECTION 0 902,702 902,702 100. 5310-455-430645-936 DIGESTED SLUDGET LINE REPLACEMENT 1,384 0 1,384- 0. 5310-455-430645-937 SAND FILTER MAINT & REPLACEMENT 0 200,000 200,000 100. 5310-455-430645-940 MACHINERY & EQUIPMENT 35,703 307,828 272,125 88. SUBTOTAL WWTP REPLACEMENT 40,933 1, 608, 992 1,568,059 97. WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 26,708 108,136 81,428 75. 5310-455-430646-121 OVERTIME 60 0 60- 0. 5310-455-430646-153 HEALTH INSURANCE 4,152 17,614 13,462 76. 5310-455-430646-155 RETIREMENT 2,007 7, 864 5,857 74. 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 193 4,500 4,307 96. 5310-455-430646-218 NON -CAPITAL EQUIPMENT 0 2,500 2,500 100. 5310-455-430646-222 LAB SUPPLIES 4,638 14,500 9,862 68. 5310-455-430646-349 LAB SERVICES 12,973 29,000 16,027 55. 5310-455-430646-362 EQUIPMENT MAINTENANCE 1,131 5,500 4,369 79. 5310-455-430646-373 DUES & TRAINING 500 3,700 3,200 86. SUBTOTAL WWTP LAB OPERATIONS 52,361 193,314 140,953 73. DEBT SERVICE - WWTP 5310-455-490227-610 PRIN-WWTP IMP/SRF8164R/2.25% 0 814,000 814,000 100. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 29 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 198,394 198,394 0 0. 5310-455-490227-630 FISCAL AGENT FEES 0 350 350 100. 5310-455-490228-610 PRIN/WWTP DIGESTER LID/SRF13326/3.0 0 46, 000 46,000 100. 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 27,315 27,315 0 0. SUBTOTAL DEBT SERVICE - WWTP 225,709 1, 086, 059 860,350 79. 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. 669,015 6, 505,462 5,836,447 90. 994,323 17, 985, 064 16,990,741 94. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 30 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 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 540 0 540- 0. 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 0 2,500 2,500 100. 5349-000-343033-000 IMPACT FEES 177,665 250,000 72,335 29. 5349-000-343034-000 PERMIT FEES 710 0 710- 0. 5349-000-343035-000 STORM SEWER CHARGES 0 1,000 1,000 100. 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 0 1,275,000 1,275,000 100. 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 1,343 1,200 143- -12. 5349-000-371010-000 INTEREST ON INVESTMENTS 8,156 18, 000 9,844 55. 5349-000-381050-000 INCEPTION OF LEASE 0 99,213 99,213 100. TOTAL STORM REVENUE 188.414 1,646,913 1,458.499 89. STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 89,553 408,007 318,454 78. 5349-453-430246-121 OVERTIME 104 4,000 3,896 97. 5349-453-430246-153 HEALTH INSURANCE 19,430 98,404 78,974 80. 5349-453-430246-155 RETIREMENT 6,768 30,228 23,460 78. 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 2,848 12,100 9,252 76. 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 0 6, 550 6,550 100. 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100. 5349-453-430246-231 GAS & OIL 2,336 11,500 9,164 80. 5349-453-430246-345 TELEPHONE & COMMUNICATION 313 900 587 65. 5349-453-430246-353 AUDITING 0 1,150 1,150 100. 5349-453-430246-354 CONTRACT SERVICE 4,034 6, 000 1,966 33. 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 0 35,000 35,000 100. 5349-453-430246-357 IMPACT FEE UPDATE 6,570 15,000 8,430 56. 5349-453-430246-358 CONSULTANTS 0 7,000 7,000 100. 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 0 15,000 15,000 100. 5349-453-430246-360 REPAIR & MAINT SERVICES 0 2,500 2,500 100. 5349-453-430246-362 GROUNDWATER MONITORING 0 5,000 5,000 100. 5349-453-430246-371 CURB & GUTTER 0 7,000 7,000 100. 5349-453-430246-373 DUES & TRAINING 380 5,500 5,120 93. 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100. 5349-453-430246-410 CONSTRUCTION MATERIALS 1,519 10,000 8,481 85. 5349-453-430246-510 PROPERTY & LIABILITY INS. 3,576 9,000 5,424 60. 5349-453-430246-521 CENTRAL GARAGE TRANSFER 2,144 8,575 6,431 75. 5349-453-430246-522 ADMINISTRATIVE TRANSFER 11,088 44,350 33,262 75. 5349-453-430246-528 DATA PROCESSING TRANSFER 4,171 13,000 8,829 68. 5349-453-430246-530 BNSF LEASE PMT 214 5,900 5,686 96. 5349-453-430246-532 OFFICE RENT 6,422 6,422 0 0. 5349-453-430246-610 PRINCIPAL 0 22,000 22,000 100. 5349-453-430246-620 INTEREST 0 8, 000 8,000 100. 5349-453-430246-840 MAGI GRANT MATCH FY18 CARRYOVER 0 43,000 43,000 100. 5349-453-430246-921 SAND/COLD MIX STORAGE SHED 14,227 15,325 1,098 7. 5349-453-430246-951 9TH ST E STORMWATER IMPRV 0 250,000 250,000 100. 5349-453-430246-952 STORM DRAIN CORRECTION 0 100,000 100,000 100. 5349-453-430246-953 SHOP COMPLEX PAVEMNT 0 38,200 38,200 100. 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 0 390,000 390,000 100. 5349-453-430246-968 4TH AVE EAST REPLACE - NON BONDED P 29,014 50,000 20,986 42. 5349-453-430246-969 4TH AVE E REPLACE PHASE 1-4 62,772 99,213 36,441 37. 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 230,000 230,000 100. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 31 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 5349-453-430249-940 MACHINERY FROM REPLACEMENT 0 92,400 92,400 100. 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 285,000 285,000 100. TOTAL STORM 267,483 2,393,524 2,126,041 89. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 32 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 0 975,000 975,000 100. 5510-000-343420-000 GARBAGE COLLECTION -BILLED 293 25,000 24,708 99. 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,172 2,100 928 44. 5510-000-371010-000 INVESTMENT EARNINGS 2,448 8, 000 5,552 69. TOTAL SOLID WASTE REVENUE 3.912 1,010,100 1,006.188 100. SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 99,986 409,153 309,167 76. 5510-460-430840-112 SEVERANCE -RETIREMENT 0 60,455 60,455 100. 5510-460-430840-121 OVERTIME 1,092 6, 500 5,408 83. 5510-460-430840-153 HEALTH INSURANCE 22,596 96, 542 73,946 77. 5510-460-430840-155 RETIREMENT 7,556 30,045 22,489 75. 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 1,125 9,500 8,375 88. 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 590 37,500 36,910 98. 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 568 5,500 4,932 90. 5510-460-430840-231 GAS & OIL 11,459 55,000 43,541 79. 5510-460-430840-341 ELECTRICITY 277 2,050 1,773 87. 5510-460-430840-344 NATURAL GAS 59 4,500 4,441 99. 5510-460-430840-345 TELEPHONE & COMMUNICATION 278 1,250 972 78. 5510-460-430840-354 CONTRACT SERVICES 1,735 11,500 9,765 85. 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 0 5,700 5,700 100. 5510-460-430840-366 BUILDING MAINTENANCE 0 4,500 4,500 100. 5510-460-430840-373 DUES & TRAINING 684 3,500 2,816 80. 5510-460-430840-388 MEDICAL SERVICES 0 650 650 100. 5510-460-430840-510 PROPERTY & LIABILITY INS. 8,985 13,500 4,515 33. 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 0 4,000 4,000 100. 5510-460-430840-521 CENTRAL GARAGE TRANSFER 17,447 69, 786 52,339 75. 5510-460-430840-522 ADMINISTRATIVE TRANSFER 10,812 43,247 32,435 75. 5510-460-430840-528 DATA PROCESSING TRANSFER 3,128 12,513 9,385 75. 5510-460-430840-532 OFFICE RENT 6,422 6,422 0 0. 5510-460-430840-610 DEBT SERVICE PRINCIPAL -GARBAGE TK 19,319 38,728 19,409 50. 5510-460-430840-620 DEBT SERVICE INTEREST -GARBAGE TK 965 1,947 982 50. 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 10,000 40,000 30,000 75. 5510-460-430840-944 VEHICLES (Replacement $) 15,000 20,000 5,000 25. 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 0 38,200 38,200 100. 5510-460-430845-224 JANITORIAL SUPPLIES 0 300 300 100. 5510-460-430845-341 ELECTRICITY 334 3,500 3,166 90. 5510-460-430845-342 WATER 92 2,000 1,908 95. 5510-460-430845-344 NATURAL GAS 58 6, 000 5,942 99. 5510-460-430845-360 REPAIR & MAINT SERVICES 0 23,500 23,500 100. 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100. TOTAL SOLID WASTE EXPENSE 240,566 1,217,488 976,922 80. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 33 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 2,250 10,000 7,750 78. 5160-000-343069-000 HANGER LEASES 2,500 12,000 9,500 79. 5160-000-343071-000 HANGAR SITE LEASES 18,791 18,035 756- -4. 5160-000-343101-000 FPO LEASE -RED EAGLE AVIATION 4,821 19,145 14,324 75. 5160-000-343102-000 GROUND LEASES 14,002 13,594 408- -3. 5160-000-343620-000 FUEL TAX 2,256 5,000 2,744 55. 5160-000-371010-000 INVESTMENT EARNINGS 474 1,200 726 60. TOTAL AIRPORT REVENUE 45,096 78,974 33,878 43. 5160 AIRPORT EXPENSES 5160-430-430310-210 OFFICE SUPPLIES & EQUIP 0 1,000 1,000 100. 5160-430-430310-341 ELECTRICITY 368 1, 600 1,232 77. 5160-430-430310-354 CONTRACT SERVICES -LABOR & MATERIALS 12,000 36, 000 24,000 67. 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 0 7,500 7,500 100. 5160-430-430310-362 REPAIR & MAINTENANCE 0 10,000 10,000 100. 5160-430-430310-390 EQUIPMENT RENTAL 140 1,000 860 86. 5160-430-430310-510 PROPERTY INSURANCE 568 6, 500 5,932 91. 5160-430-430310-522 ADMINISTRATIVE TRANSFER 681 2, 726 2,045 75. 5160-430-430310-528 DATA PROCESSING TRANSFER 521 2,085 1,564 75. 5160-430-430310-820 DEPRECIATION 0 97,918 97,918 100. TOTAL AIRPORT EXPENSES 14,278 166, 329 152,051 91. 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 34 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING INTERNAL SERVICE FUNDS INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 ENTITLEMENT SHARE PMT/HB124 51,250 205,000 153,750 750s 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 0 173,000 173,000 1000s 6030-000-371010-000 INVESTMENT EARNINGS 291 1,100 809 740s 6030-000-393000-000 INTERNAL SERVICES -DATA 58,914 235, 655 176,741 750s TOTAL INFORMATION TECH REVENUE 110,455 614, 755 504,300 820s INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 42,139 171,350 129,211 750s 6030-401-410580-121 OVERTIME 0 1,000 1,000 1000s 6030-401-410580-153 HEALTH INSURANCE 11,364 44,701 33,337 750s 6030-401-410580-155 RETIREMENT 3,323 13,115 9,792 750s 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 0 6, 100 6,100 1000s 6030-403-410580-215 COMPUTER SUPPLIES 53 2,400 2,347 980s 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 7,347 24,000 16,653 690s 6030-403-410580-325 WEBSITE 14,789 15,700 911 60s 6030-403-410580-345 PAGER/PHONE 245 2,550 2,305 900s 6030-403-410580-346 SUMMITNET & ISPS 1,372 14,000 12,629 900s 6030-403-410580-353 LASER FICHE MAINTENANCE 3,432 3,500 68 20s 6030-403-410580-354 MAINTENANCE CONTRACTS 477 5,000 4,524 900s 6030-403-410580-355 LICENSES 1,432 18,850 17,418 920s 6030-403-410580-356 MAINTENANCE CONTRACTS 15,337 44,000 28,663 650s 6030-403-410580-357 GRANICUS 4,788 5,000 212 40s 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 3,709 20, 622 16,913 820s 6030-403-410580-373 DUES & TRAINING 794 8, 000 7,206 900s 6030-403-410580-510 INSURANCE 1,469 3,000 1,531 510s 6030-403-410583-218 TV -Video Equipment & programming 582 19,500 18,918 970s 6030-403-410585-229 COPIER,FAX, SUPPLIES 2,570 19,490 16,920 870s 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 18,658 78,000 59,342 760s 6030-403-410585-532 COPIER LEASES 4,211 12,588 8,377 670s 6030-403-410585-942 Servers - capital contingency 0 33,000 33,000 1000s 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,000 5,000 1000s 6030-404-410588-218 COMPUTERS - ATTORNEYS 456 4,100 3,644 890s 6030-405-410588-940 COMPUTERS - SWITCHES 0 22,200 22,200 1000s 6030-406-410580-218 COURT COMPUTERS (non -capital) 40 0 40- 00s 6030-410-410588-218 COMPUTERS - DPW 2,156 5,381 3,225 600s 6030-413-410588-218 COMPUTERS - POLICE DEPT 529 37, 760 37,231 990s 6030-413-410588-354 POLICE - HOSTED SERVER 98 1,200 1,102 920s 6030-416-410588-218 COMPUTERS - FIRE 0 8,164 8,164 1000s 6030-420-410588-218 COMPUTERS - PLANNING DEPT 2,470 4,125 1,655 400s 6030-436-410588-218 COMPUTERS - PARKS 127 4,885 4,758 970s 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 2,315 2,315 1000s TOTAL INFORMATION TECH EXPENSE 143,966 660, 596 516,630 780s 10.12.2017 08:21 THE CITY OF KALISPELL, MONTANA Page 35 of 35 gb8501_pg.php/Job No: 65043 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU SEPTEMBER 30, 2017 25.00 % Yr Complete For Fiscal Year: 2018 / 9 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 123,750 495,000 371,250 75. 6010-000-371010-000 INVESTMENT EARNINGS 157 200 43 22. TOTAL CENTRAL GARAGE REVENUE 123,907 495,200 371,293 75. CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 39,777 162, 760 122,983 76. 6010-410-431330-121 OVERTIME 0 2,500 2,500 100. 6010-410-431330-153 HEALTH INSURANCE 8,261 38,931 30,670 79. 6010-410-431330-155 RETIREMENT 2,803 11,880 9,077 76. 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 0 10,000 10,000 100. 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 2,052 10,700 8,648 81. 6010-410-431330-230 OIL 4,003 25, 000 20,997 84. 6010-410-431330-231 GAS 130 2,500 2,370 95. 6010-410-431330-232 VEHICLE PARTS 24,259 112,000 87,741 78. 6010-410-431330-233 TIRES 4,360 41, 000 36,640 89. 6010-410-431330-238 FILTERS 1,933 8, 500 6,567 77. 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 0 2,000 2,000 100. 6010-410-431330-341 ELECTRICITY 368 1,950 1,582 81. 6010-410-431330-344 NATURAL GAS 118 6, 000 5,882 98. 6010-410-431330-354 CONTRACT SERVICES 8,700 26, 000 17,300 67. 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 1,000 2,000 1,000 50. 6010-410-431330-373 DUES & TRAINING 0 6,200 6,200 100. 6010-410-431330-388 MEDICAL SERVICES 264 300 36 12. 6010-410-431330-510 INSURANCE 1,949 4,000 2,051 51. 6010-410-431330-528 INFORMATION TECH TRANSFER 2,085 8,342 6,257 75. 6010-410-431330-944 VEHICLE -SERVICE TRUCK 7,020 10,000 2,980 30. TOTAL CENTRAL GARAGE EXPENSES 109,083 492, 563 383,480 78.