The URL can be used to link to this page

04-13-18 City Manager ReportCity of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 4/13/2018 1. Parks Department Late snow and moisture content in the ground has delayed the opening of the Kalispell Youth Athletic Complex (KYAC). Field crews have been preparing for the opening and as soon as moisture levels allow for activities on the fields, we will open the facility. "Pick Your Park" will be held Saturday, April 21, at Lawrence and Woodland Park from 10:00 am to noon. The community is invited to donate a couple hours to help pickup trash in these parks. Park staff will be on hand with trash bags and gloves. At noon, pizza will be provided to volunteers. The City of Kalispell will celebrate Arbor Day Friday, April 27, in Woodland Park. All School District 45 3rd graders will be in the park moving from station to station learning about subjects dealing with trees and the environment. Volunteers will be planting 20 new trees in the park throughout the day. The general public is invited to the formal ceremony at 1:00 in the garden. While trees in our urban forest have been coming down throughout the winter, Flathead High School woodshop has been milling logs that were removed from Kalispell boulevards. After cut, boards are stacked and dried before being used for student projects. Thanks to a grant from the DNRC, this spring's boulevard cost share tree replacement program tree costs have been dropped to only $75.00 for the adjacent property owner. Property owners who had a tree removed this winter have been sent a letter inviting them to participate in this program. Other citizens are also welcome to participate. Our Spring Break Camp Olympics had a 23% increase from last year's Spring Out Camp. Participants were divided into teams to participate in cur Olympic themed games. The first competition to kick off the week was a photo scavenger hunt where participants and staff where tasked to find and take pictures of specific objects. The rest of the week was filled with relay races, outdoor sports, Easter egg hunts and a trip to Pies Bowling Alley. Points were awarded for each competition and determined who would take the gold at the end of the week. The kids each chose different countries to represent with Switzerland taking gold, Germany taking silver, and Russia receiving bronze. The KPR office will be busy with summer lessons and program registrations that are opening over the next few weeks. Swim lesson registration opens on Tuesday, April 17, for all levels and sessions. Camp Woodland Summer Day Camp registration opens the following day on Wednesday, April 18. Finally, our new Summer Activity Guide is scheduled for publication in the Daily Interlake on Monday, April 23. We are offering over 20 new youth, adult, and community events and programs this summer. 2. Police Department Sgt. Brett Corbett and School Resource Officer Dennis Bain have begun instructing self- defense classes for at -risk girls from Flathead and Glacier high schools. The course will span three weeks and will teach girls awareness and techniques to defend themselves. School Resource Officers Jordan Venezio and Dennis Bain have recently been assigned to conduct park patrol for the summer months. The officers will work with Parks and Recreation to make the parks safer and more inviting. The officers will work uniform, bike patrol, and plain clothes to help address any issues or problems. K-9 Officer Jason Parce and Cairo continue to do presentations at local elementary schools. They were at Peterson Elementary this past Friday and will be there again on Wednesday. Officers Sean Keller and Brooke Pokorny are attending a week-long Interview and Interrogation school held at the Evergreen Firehouse. 3. Fire Department Since the last update, the Kalispell Fire Department has received 261 calls for service and has conducted 2 outreach trainings with 12 individuals in attendance. On March 16, the fire department also sponsored a child safety seat clinic at station 61. With the recent retirements, Lieutenant Mike Chappius has been promoted to Captain and FF Jessica Kinzer has been promoted to Lieutenant. Fire department staff are in the process of assembling testing candidates for the hiring process. Currently, employment applications are being processed and reviewed. Candidates must successfully meet the required certifications and minimum qualifications before moving onto the written test, physical test, interview portions and background checks. Fire department staff are also starting to transition our operational requirements from winter to spring and summer operations. We will soon transition our type VI wildland units to active service. 2 4. Public Works 2018 Street and Alley Restoration Projects Annually, the Street Department is responsible for pavement restoration projects. The restoration consists of asphalt milling and overlay of streets and alleys, major patching and crack sealing. This summer the city will have a contractor perform some of the restoration projects, partially due to the new funding from the Bridge and Road Safety and Accountability Act (BaRSAA — HB473). The projects and activities are prioritized each year based on pavement conditions and budgets. Streets and alleys slated for in-house restoration projects for 2018 construction season and the correlated tentative weekly schedules are listed in the table: ,,,,,,,,,,of,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Week ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,',,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,.............................., Location Restoration Pro'ects Notes 16-Apr East Nevada - 1st Ave East Reconstruction 1 Block to 2nd Ave East Patching and Street Utility and 23-Apr City Maintenance Misc. 30-Apr Palmer Drive and West Mill and Overlay —7,140 May25, Nicklaus Lineal Feet 28- May City Patching and Street Maintenance Utility and Misc. 4-Jun 11- Buffalo Stage Road Mill and Overlay 22 June Lineal 18 Pheasant Run and Stillwater —2,600 Mill and Overlay June Lane Lineal Feet 25-Jun Husky Street Mill and Overlay 1 Block 2-Jul City Patching and Street Maintenance Utility and Misc. 9-Jul 16-Jul 8th Street West Mill and Overlay 1 Block Patching and Street Utility and 23-Jul City Maintenance Misc. July 30 5th Street East Reconstruct 1 Block Patching and Street Utility and 6-Aug City Maintenance Misc. 13-Aug 6th Street East Reconstruct 1 Block Patching and Street Utility and 20-Aug City Maintenance Misc. 27-Aug 3rd Avenue East North Mill and overlay 1 Block 3-Sep city Patching and Street Utility and 14-Sep Maintenance Misc. 17- Sept 1st Ave East Mill and Overlay 2 Blocks 28-Sep Patching / Street Utility and 1-Oct City Maintenance Misc. 8-Oct 9th Street East Reconstruction 1 Block Patching / Street Utility and 15-Oct City Maintenance Misc. Alley Paving 25-Oct • 6th Alley East - 1300 block to end Filler task of during season • 7th Alley East 800, 1200, 1300 Block patching and maintenance • 8th Alley East 800, 1000 Block if time permits • 8th Alley West - 800, 900, 1000 block LAschedules and projects are subject to change based on weather, work d, and any unforeseeable incidents that may occur. 5. City Clerk/Communications The clerk's office is transitioning to a different public notification system on the new city website. "Notify Me", the city's auto email service that allows the public to register for news and notices has been divided into additional categories helping ensure subscribers receive notices relevant to them. Current "Notify Me" subscribers have been asked to sign-up for the new service by May 15 to ensure continuation of their notices. The City Clerk's office has assisted with eighteen bid advertisements and openings to date this year. Seven bids from public works will be opened between April 11 and April 19. Twenty-nine applications have been received for positions on twelve advisory boards or committees that are seeking volunteers due to expiring terms. Appointments to these boards is scheduled for the April 16 City Council meeting. 6. Finance Department Quarterly Finance Report Please find attached the printouts reflecting the activity for the first nine months of fiscal year 2018. This printout reflects payroll earned thru March 31, and accounts payable claims received by the end of March. All funds are included with the exception of the debt service funds. REVENUE: General Fund revenue reflects taxes collected thru March 31. Last year, the general fund received about 45% of its property tax revenue in the 4fh quarter. A similar distribution this 4fh quarter would bring collections to about 102% of the budgeted amount, or just over $5,900,000. The City is currently carrying just over $16,000 in protest taxes in the General Fund. Protest tax dollars are held by the County. City Court fines and fees revenue reflects July thru February (8 months). Parks youth camps revenue, and many of the other user based parks fees, historically receives more of their revenue in the 2nd half of the fiscal year (spring). Ambulance fees for services ($490,849) are just slightly behind last year ($504,063). The first half of the County EMS levy is about 6% less than last fiscal year's first half payment. Building department permits and fees are about 60% of the budgeted annual amounts. M The Westside TIF real property tax revenues were budgeted at the same amount as the City received last fiscal year. However, when the certified values were received from the Department of Revenue in August, the incremental value in the district was down by about 30%. Although there are some other factors, for the most part real property taxes revenue will mirror the incremental value for fiscal year 2018, and will also be down about 30% ($90,000). Metered water sales thru March were $2,605,995. This is 90% of the budgeted amount and almost $300,000 more than the fiscal year 2017 period. It is normal for July thru December metered water sales to be in excess of 50%„ normally around 60%, of the annual amount because of late summer and fall sprinkling and irrigation. This significantly above normal water revenue can be attributed to the extremely dry summer that was experienced in Northwest Montana. Water impact fees have already exceeded the fiscal year 18 budget amount by 64%. Sewer service charges were $3,418,533; 77% of the budgeted amount. Last year to date sewer service charges were $3,342,482. Sanitary sewer (135%) and treatment plant impact fees (138%) have both exceeded the anticipated fiscal year 2018 amount. Storm sewer and Solid Waste revenue reflects assessments billed for fiscal year 2018. Assessments collected for the storm sewer fund are about $760,000, and for the solid waste fund are just over $560,000. Storm impact fees ($239,984) are 96% of the budgeted fiscal year 2018 amount. EXPENDITURES/EXPENSES : General Fund expenditures reflect 72% spent. Some major expenditures such as liability and property insurance are paid during the first quarter for the entire year. This results in expenditures not being evenly distributed over the fiscal period. For most funds, expenditures/expenses include the 20th (of 26), or 10t' (of 13) for the fire/ambulance, payroll period ending March 31. Most departments and/or funds would then need to have about 25% remaining in the salaries, retirement, and health insurance budgets to be adequate. With a few exceptions, administrative, central garage, and information technology transfers are done monthly and should show 25% remaining. This is the same on the revenue side for fees for services (Central Garage), internal services (Information Technology) and administrative charges (General Fund). The general fund administrative charges may vary slightly as some charges are based on a percentage of revenues collected. Annual budgeted operating transfers are also generally done monthly or quarterly and should show 25% remaining. k' 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 1 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 3,315,987 5,800,000 2,484,013 430 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 8,244 17,250 9,006 520 1000-000-311200-000 PERSONAL PROPERTY TAXES 144,205 135,000 9,205- -70 1000-000-312000-000 PEN & INTEREST DEL. TAXES 6,751 8,000 1,249 160 1000-000-322101-000 LIQUOR LICENSES 675 30,000 29,325 980 1000-000-322300-000 BUSINESS LICENSES 1,272 1,700 428 250 1000-000-323012-000 PLANNING FEES 91,530 40,000 51,530- -1290 1000-000-323109-000 SITE REVIEW 12,366 14,000 1,634 120 1000-000-323200-000 PARADE PERMITS 700 1,000 300 300 1000-000-335030-000 M.V. TAX - AD VALOREM 1,860 1,500 360- -240 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 62,550 60,000 2,550- -40 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,550 1,000 550- -550 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 2,098,693 2,857,688 758,995 270 1000-000-341020-000 ADMINISTRATIVE CHARGES 478,992 638,811 159,819 250 1000-000-341021-000 GRANT ADMIN FEES 52,370 5,000 47,370- -9470 1000-000-341025-000 CITY COLLECTIONS 5,074 5,000 74- -1% 1000-000-342010-000 POLICE SERVICES 21,431 25,000 3,569 140 1000-000-342014-000 RESOURCE OFFICERS 205,557 209,037 3,480 20 1000-000-342016-000 KPD REGIONAL TRAINING 11,300 5,000 6,300- -1260 1000-000-342020-000 FIRE CHG/TEST FEES/SPEC EVENTS/INST 60 0 60- 0% 1000-000-343018-000 PARKING PERMITS 80,589 95,000 14,411 150 1000-000-351000-000 CITY COURT FINES & FEES 229,742 450,000 220,258 490 1000-000-351016-000 DUI COURT FINE 1,937 0 1,937- 0% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 14,369 20,000 5,631 280 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 41,957 35,000 6,957- -200 1000-000-362015-000 INSURANCE REIMBURSEMENTS 4,911 20,000 15,089 750 1000-000-362020-000 MMIA GASB 54 REIMBURSEMENT 3,000 3,000 0 0% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 13,018 5,000 8,018- -1600 1000-000-371010-000 INVESTMENT EARNINGS 19,910 15,000 4,910- -330 1000-000-373030-000 INTEREST ON OLD SCHOOL SID LOAN - 1 0 32,500 32,500 1000 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 450,500 901,000 450,500 500 TOTAL GENERAL FUND REVENUE 7,381,100 11,431,486 4,050,386 350 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 2 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING 'k 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 12,900 14,250 1,350 90 1000-400-410530-354 OPEB EXPENSE 7,500 7,500 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 2,833 4,000 1,167 290 1000-400-410560-312 POSTAGE 13,651 16,000 2,349 150 1000-400-410560-320 PRINTING & ENVELOPES 2,910 4,500 1,590 350 1000-400-410560-354 CONTRACT SERVICES - DOC. SHREDDING 75 500 425 850 1000-400-410600-354 ELECTIONS 13,431 18,255 4,824 260 1000-400-410900-331 RECORDS ADMIN./FILING FEES 2,616 4,000 1,384 350 1000-400-420000-354 CONTRACT 911 CENTER 367,532 479,000 111,469 230 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMS. 348 400 52 130 1000-400-460000-820 TRANSFER TO FORESTRY 100,000 200,000 100,000 500 1000-400-460430-820 TRANSFER TO PARKS (BANDSHELL) 10,467 10,467 0 0% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 15,000 15,000 0 0% 1000-400-460452-366 HOCKADAY MAINTENANCE 6,600 6,600 0 0% 1000-400-510300-000 CONTINGENCY 0 30,000 30,000 1000 1000-400-510310-354 ICMA PLAN FEES 375 500 125 250 1000-400-510330-513 LIABILITY INSURANCE 110,313 110,310 3- 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 22,481 50,000 27,519 550 1000-400-510330-517 PROPERTY INSURANCE 50,025 50,012 13- _0% SUBTOTAL GEN.GOV'T. 741,991 1,024,229 282,238 280 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 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 104,769 141,390 36,621 260 13,117 22,857 9,740 430 11,123 14,966 3,843 260 0 1,500 1,500 1000 26 400 374 940 770 1,120 350 310 3,436 8,300 4,864 590 3,089 3,400 311 90 136,330 193,933 57,603 300 94,124 127,044 32,920 260 11,133 19,642 8,509 430 7,362 9,813 2,451 250 436 600 164 270 6,574 8,000 1,426 180 725 1,000 275 280 4,089 6,000 1,911 320 124,443 172,099 47,656 280 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 3 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 46,722 63,107 16,385 260 1000-402-410100-153 HEALTH INSURANCE 40,828 62,936 22,108 350 1000-402-410100-155 RETIREMENT 1,876 2,463 587 240 1000-402-410100-210 OFFICE SUPPLIES 157 100 57- -570 1000-402-410100-335 MT LEAGUE OF CITIES 2,111 6,417 4,306 670 1000-402-410100-354 CONTRACT SERVICES 1,634 4,500 2,866 640 1000-402-410100-373 DUES & TRAINING 6,576 6,000 576- -100 1000-402-410100-379 MEETINGS 2,544 10,590 8,046 760 SUBTOTAL MAYOR/COUNCIL 102,448 156,113 53,665 340 CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 67,295 91,120 23,825 260 1000-402-410150-121 OVERTIME 35 250 215 860 1000-402-410150-153 HEALTH INSURANCE 15,172 20,271 5,099 250 1000-402-410150-155 RETIREMENT 5,286 7,083 1,797 250 1000-402-410150-210 OFFICE SUPPLIES 231 200 31- -150 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 105 700 595 850 1000-402-410150-345 TELEPHONE & COMMUNICATION 400 480 80 170 1000-402-410150-352 RECODIFICATION 1,653 4,100 2,447 600 1000-402-410150-354 CONTRACT SERVICES 0 300 300 1000 1000-402-410150-373 DUES & TRAINING 1,574 3,200 1,626 510 SUBTOTAL CITY CLERK 91,751 127,704 35,953 280 FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 159,165 214,508 55,343 260 1000-403-410550-153 HEALTH INSURANCE 30,384 38,696 8,312 210 1000-403-410550-155 RETIREMENT 12,477 16,650 4,173 250 1000-403-410550-210 SUPPLIES 225 300 75 250 1000-403-410550-322 BOOKS 145 250 105 420 1000-403-410550-353 CONTRACT SERVICES 200 760 560 740 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 638 1,800 1,162 650 1000-403-410550-355 BANK CHARGES & FEES 2,403 3,600 1,197 330 1000-403-410550-373 DUES & TRAINING 3,072 7,500 4,428 590 SUBTOTAL FINANCE 208,709 284,064 75,355 270 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 4 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 268,102 372,621 104,519 280 1000-404-411110-153 HEALTH INSURANCE 38,171 52,804 14,633 280 1000-404-411110-155 RETIREMENT 20,977 28,950 7,973 280 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 1,352 2,500 1,148 460 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 10,782 8,000 2,782- -350 1000-404-411110-345 TELEPHONE & COMMUNICATION 535 1,000 465 460 1000-404-411110-354 CONTRACT SERVICES 7,561 5,000 2,561- -510 1000-404-411110-373 DUES & TRAINING 2,483 7,000 4,517 650 SUBTOTAL CITY ATTORNEY 349,963 477,875 127,912 270 MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 169,320 228,151 58,831 260 1000-406-410360-121 OVERTIME 46 0 46- 0% 1000-406-410360-153 HEALTH INSURANCE 31,801 51,674 19,873 380 1000-406-410360-155 RETIREMENT 13,227 17,683 4,456 250 1000-406-410360-210 SUPPLIES 2,976 4,500 1,524 340 1000-406-410360-320 PRINTING/BOOKS 1,481 1,500 19 to 1000-406-410360-345 TELEPHONE & COMMUNICATION 80 1,400 1,320 940 1000-406-410360-353 SECURITY & TECHNOLOGY 7,005 40,000 32,995 820 1000-406-410360-354 CONTRACT SERVICES 2,892 5,750 2,858 500 1000-406-410360-373 DUES & TRAINING 2,991 10,000 7,009 700 1000-406-410360-394 JURY & WITNESS FEES 823 7,500 6,677 890 SUBTOTAL COURT 232,643 368,158 135,515 370 PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 13,243 17,705 4,462 250 1000-410-430100-153 HEALTH INSURANCE 2,388 3,289 901 270 1000-410-430100-155 RETIREMENT 1,025 1,346 321 240 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 3,881 8,000 4,119 510 1000-410-430100-231 GAS 2,057 2,500 443 180 1000-410-430100-345 TELEPHONE & COMMUNICATION 218 350 132 380 1000-410-430100-354 CONTRACT SERVICES 201 2,000 1,799 900 1000-410-430100-373 DUES & TRAINING 1,206 2,500 1,294 520 1000-410-430100-521 CENTRAL GARAGE TRANSFER 2,709 3,612 903 250 1000-410-430100-940 MACHINERY & EQUIPMENT 7,004 7,400 396 50 SUBTOTAL PUBLIC WORKS ADMIN 33,932 48,702 14,770 300 CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 50,413 68,299 17,886 260 1000-412-411230-153 HEALTH INSURANCE 10,064 15,928 5,864 370 1000-412-411230-155 RETIREMENT 3,806 5,076 1,270 250 1000-412-411230-220 SECURITY IMPROVEMENTS 228 500 272 540 1000-412-411230-224 JANITORIAL SUPPLIES 3,077 6,000 2,923 490 1000-412-411230-241 TOOLS & SUPPLIES 697 1,500 803 540 1000-412-411230-341 ELECTRICITY 33,667 49,200 15,533 320 1000-412-411230-344 NATURAL GAS 24,864 30,000 5,136 170 1000-412-411230-345 TELEPHONE & COMMUNICATION 181 400 219 550 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 5 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING 1000-412-411230-354 CONTRACT SERVICES 49,065 80,000 30,935 390 1000-412-411230-355 HVAC MAINTENANCE OCNTRACT 15,600 16,500 900 50 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 3,964 4,500 536 120 1000-412-411230-362 EQUIPMENT MAINTENANCE 1,318 10,000 8,682 870 1000-412-411230-366 BUILDING MAINTENANCE 23,493 27,500 4,007 150 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,275 3,500 225 60 1000-412-411230-920 BLDG IMP (LIGHT UPGRADES; CHALL ROO 1,601 17,000 15,399 910 SUBTOTAL CITY HALL 225,314 335,903 110,589 330 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 198,410 266,269 67,859 250 1000-420-411020-153 HEALTH INSURANCE 41,479 60,020 18,541 310 1000-420-411020-155 RETIREMENT 15,555 20,657 5,102 250 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 51 5,000 4,949 990 1000-420-411020-231 GAS 92 300 208 690 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 1,394 2,000 606 300 1000-420-411020-345 TELEPHONE 588 900 312 350 1000-420-411020-354 CONTRACT SERVICES 3,800 1,000 2,800- -2800 1000-420-411020-373 DUES & TRAINING 5,702 6,000 298 50 1000-420-411020-521 CENTRAL GARAGE TRANSFER 712 949 237 250 1000-420-411020-944 VEHICLE 13,972 15,000 1,028 70 SUBTOTAL PLANNING DEPT. 281,755 378,095 96,340 250 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 46,652 63,180 16,528 260 1000-480-470210-153 HEALTH INSURANCE 8,218 8,307 89 to 1000-480-470210-155 RETIREMENT 3,658 4,876 1,218 250 1000-480-470210-210 OFFICE SUPPLIES 946 1,500 554 370 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 0 500 500 1000 1000-480-470210-312 POSTAGE & PRINTING 86 500 414 830 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 500 500 0 0% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 254 900 646 720 1000-480-470210-354 CONTRACT SERVICES 0 1,500 1,500 1000 1000-480-470210-373 DUES & TRAINING 874 5,000 4,126 830 1000-480-470210-379 MEETINGS 0 1,500 1,500 1000 SUBTOTAL COMMUNITY DEVELOPMENT 61,189 88,263 27,074 310 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 6 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 1,647,323 2,264,988 617,665 270 1000-413-420140-112 SALARIES -SEVERANCE 35,842 0 35,842- 0% 1000-413-420140-114 SALARY -comptime buyout 2,226 3,000 774 260 1000-413-420140-121 OVERTIME (REG & AET OT) 44,775 80,000 35,225 440 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 1,363 25,000 23,637 950 1000-413-420140-153 HEALTH INSURANCE 326,768 445,536 118,768 270 1000-413-420140-155 RETIREMENT 213,737 296,098 82,361 280 1000-413-420140-210 OFFICE SUPPLIES 2,429 3,500 1,071 310 1000-413-420140-215 COMPUTER SUPPLIES 2,301 5,500 3,199 580 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 54,665 53,500 1,165- -20 1000-413-420140-220 INVESTIGATIVE SUPPLIES 2,064 4,000 1,936 480 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 4,324 7,000 2,676 380 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 1,393 2,000 607 300 1000-413-420140-226 SRT SUPPORT/SUPPLIES 1,874 10,000 8,126 810 1000-413-420140-227 AMMO & RELATED SUPPLIES 11,604 30,000 18,396 610 1000-413-420140-228 PATROL CAR SUPPLIES 5,470 10,000 4,530 450 1000-413-420140-229 OTHER SUPPLIES 3,373 5,000 1,627 330 1000-413-420140-230 CRIME PREVENTION SUPPLIES 532 1,000 468 470 1000-413-420140-231 GAS 56,833 75,000 18,167 240 1000-413-420140-234 CRISIS NEGOTIATIONS 557 2,000 1,443 720 1000-413-420140-235 BIKE PATROL 0 750 750 1000 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 394 1,500 1,106 740 1000-413-420140-320 PRINTING 3,278 5,500 2,222 400 1000-413-420140-345 TELEPHONE & COMMUNICATION 13,731 17,000 3,269 190 1000-413-420140-354 CONTRACT SERVICES 11,105 7,000 4,105- -590 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 6,078 6,500 423 70 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 1,399 5,000 3,601 720 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 1,321 2,000 679 340 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 23,009 27,000 3,991 150 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 1,664 2,500 836 330 1000-413-420140-373 DUES & TRAINING 25,321 32,500 7,179 220 1000-413-420140-375 REG. TRAINING/TESTING REIMS. 15,788 5,000 10,788- -2160 1000-413-420140-380 TRAINING MATERIALS 2,920 2,000 920- -460 1000-413-420140-388 MEDICAL SERVICES 1,534 3,000 1,467 490 1000-413-420140-392 BOARDING/TREATING PRISONERS 1,862 2,500 639 260 1000-413-420140-521 CENTRAL GARAGE TRANSFER 49,598 66,131 16,533 250 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 48,000 64,000 16,000 250 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 45,000 60,000 15,000 250 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 2,625 3,500 875 250 1000-413-420140-940 MAJOR CRIME UNIT TRAILER & RADAR TR 0 29,000 29,000 1000 1000-413-420140-942 EQUIPMENT -RADIO MATCH 0 53,500 53,500 1000 1000-413-420140-944 VEHICLES 94,131 99,055 4,924 50 SUBTOTAL POLICE DEPT. 2,768,211 3,818,058 1,049,847 280 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 274,893 361,097 86,204 240 6,805 15,000 8,195 550 60,693 71,662 10,969 150 35,920 48,339 12,419 260 378,310 496,098 117,788 240 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 7 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING RECORDS 1000-413-420142-110 SALARIES -RECORDS DIVISION 110,626 144,863 34,237 240 1000-413-420142-121 OVERTIME 1,301 7,500 6,200 830 1000-413-420142-153 HEALTH INSURANCE 23,528 33,228 9,700 290 1000-413-420142-155 RETIREMENT 8,692 11,198 2,506 220 TOTAL RECORDS 144,146 196,789 52,643 270 RESOURCE OFFICERS 1000-413-420144-110 SALARIES -SRO 185,144 257,288 72,144 280 1000-413-420144-153 HEALTH INSURANCE 35,551 58,576 23,025 390 1000-413-420144-155 SRO RETIREMENT 23,175 34,530 11,355 330 TOTAL RESOURCE OFFICERS 243,870 350,394 106,524 300 ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL -SALARIES 31,634 40,750 9,116 220 1000-413-420145-121 OVERTIME 0 500 500 1000 1000-413-420145-153 HEALTH INSURANCE 6,228 9,307 3,079 330 1000-413-420145-155 RETIREMENT 2,336 3,148 812 260 SUBTOTAL ANIMAL CONTROL 40,198 53,705 13,507 250 PARKING 1000-413-420147-110 PARKINGS -SALARIES 69,505 88,871 19,366 220 1000-413-420147-153 HEALTH INSURANCE 22,719 25,837 3,118 120 1000-413-420147-155 RETIREMENT 5,303 6,866 1,563 230 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 1,846 4,000 2,154 540 1000-413-420147-354 CONTRACTED SERVICES 1,833 2,000 167 80 1000-413-420147-362 LOT MAINT 1,116 10,000 8,884 890 1000-413-420147-365 SNOW REMOVAL -Parking Lots 20,405 17,500 2,905- -170 1000-413-420147-550 LOT LEASE PAYMENTS 1,100 1,500 400 270 SUBTOTAL PARKING 123,827 156,574 32,747 210 SUBTOTAL POLICE DEPT. 3,698,563 5,071,618 1,373,055 270 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 8 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. FIRE DEPARTMENT 1000-416-420400-110 SALARIES -FIRE SUPPRESSION 1,247,919 1,672,064 424,145 250 1000-416-420400-114 COMPTIME BUYOUT 3,199 5,500 2,301 420 1000-416-420400-115 OUT OF RANK PAY 11,338 12,000 662 60 1000-416-420400-121 OVERTIME 48,150 40,000 8,150- -200 1000-416-420400-153 HEALTH INSURANCE 238,217 315,034 76,817 240 1000-416-420400-155 RETIREMENT 166,396 224,499 58,103 260 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 64 2,000 1,936 970 1000-416-420400-218 Equipment (Non Capital) 14,370 21,500 7,130 330 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 8,027 15,000 6,973 460 1000-416-420400-224 JANITORIAL SUPPLIES 3,280 5,000 1,720 340 1000-416-420400-231 GAS 7,342 17,325 9,983 580 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 3,209 15,750 12,541 800 1000-416-420400-320 PRINTING 0 200 200 1000 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 237 1,000 764 760 1000-416-420400-345 TELEPHONE & COMMUNICATION 3,641 6,000 2,359 390 1000-416-420400-354 CONTRACT SERVICES 33,189 37,600 4,411 120 1000-416-420400-362 EQUIPMENT MAINTENANCE 1,730 5,500 3,770 690 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 4,322 7,500 3,178 420 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 4,622 5,000 378 80 1000-416-420400-373 DUES & TRAINING 5,009 10,000 4,991 500 1000-416-420400-388 FIREFIGHTER PHYSICALS 0 25,875 25,875 1000 1000-416-420400-521 CENTRAL GARAGE TRANSFER 31,253 41,671 10,418 250 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 0 33,500 33,500 1000 1000-416-420400-620 INTEREST EXPENSE -FIRE TRUCK 0 6,500 6,500 1000 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 262,500 350,000 87,500 250 1000-416-420400-821 TRANSFER TO FUND 2956 GRANT MATCH 0 21,040 21,040 1000 1000-416-420440-110 SALARIES -FIRE PREVENTION 15,660 20,173 4,513 220 1000-416-420440-121 OVERTIME 738 0 738- 0% 1000-416-420440-153 HEALTH INSURANCE 3,924 5,145 1,221 240 1000-416-420440-155 RETIREMENT 1,192 1,439 247 170 SUBTOTAL FIRE DEPT. 2,119,526 2,923,815 804,289 280 GRAND TOTAL GENERAL FUND SPECIAL REVENUE FUNDS: PERMISSIVE HEALTH LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND TOTAL PERMISSIVE HEALTH LEVY 8,408,555 11,650,571 3,242,016 280 518,750 992,000 473,250 480 518,750 992,000 473,250 480 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 9 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 558,477 999,000 440,523 440 2215-000-311200-000 PERSONAL PROPERTY TAXES 38,049 40,000 1,951 50 2215-000-312000-000 PEN & INTEREST DEL TAXES 1,168 2,000 832 420 2215-000-346030-000 SWIMMING POOL FEES 95,338 127,000 31,662 250 2215-000-346040-000 CONCESSION STAND REVENUE 30,316 34,000 3,685 11% 2215-000-346050-000 PARKS USAGE FEES 9,826 21,500 11,674 540 2215-000-346051-000 RECREATION FEES 8,460 11,188 2,728 240 2215-000-346052-000 SPORTS PROGRAMS 42,978 43,594 616 to 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 2,182 2,500 318 130 2215-000-346054-000 AFTER SCHOOL PROGRAMS 51,821 70,000 18,179 260 2215-000-346055-000 ICE RINK 12,588 22,500 9,912 440 2215-000-346056-000 KIDSPORT USAGE 2,920 2,000 920- -460 2215-000-346057-000 YOUTH CAMPS 12,128 143,147 131,019 920 2215-000-346059-000 PICNIC IN THE PARK 7,542 25,000 17,458 700 2215-000-362015-000 INSURANCE REIMBURSEMENTS 2,365 0 2,365- 0% 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 10,000 11,500 1,500 130 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 1000 2215-000-371010-000 INVESTMENTS 4,378 3,000 1,378- -460 2215-000-381050-000 INCEPTION OF LEASE 35,191 64,000 28,809 450 2215-000-381060-000 HEALTH INSURANCE TRANSFER 68,250 91,000 22,750 250 2215-000-381070-000 GENERAL FUND TRANSFER (BANDSHELL) 10,467 10,467 0 0% TOTAL PARKS & REC REVENUE PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 2215-436-460430-111 SEASONAL SALARIES 2215-436-460430-121 OVERTIME 2215-436-460430-153 HEALTH INSURANCE 2215-436-460430-155 RETIREMENT 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 2215-436-460430-215 EQUIPMENT - NOT CAPITAL 2215-436-460430-224 JANITORIAL SUPPLIES 2215-436-460430-229 OTHER SUPPLIES 2215-436-460430-231 GAS 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 2215-436-460430-320 PRINTING & ADVERTISING 2215-436-460430-341 ELECTRICITY 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 2215-436-460430-344 NATURAL GAS 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 2215-436-460430-351 TENNIS COURT REHABILITATION 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 2215-436-460430-356 CONSULTANTS 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 2215-436-460430-358 FVCC TENNIS INTERLOCAL AGREEMENT 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 2215-436-460430-364 LANDSCAPING 2215-436-460430-367 VANDALISM REPAIRS 1,004,443 1,743,396 738,953 420 239,595 322,778 83,183 260 18,101 71,610 53,509 750 74 500 426 850 45,468 61,917 16,449 270 18,928 27,476 8,548 310 1,381 1,800 419 230 0 8,000 8,000 1000 3,585 6,000 2,415 400 2,664 4,000 1,336 330 10,383 14,000 3,617 260 1,207 2,500 1,293 520 0 400 400 1000 9,238 16,000 6,762 420 18,802 22,500 3,698 160 1,473 2,500 1,027 410 1,722 3,600 1,878 520 1,500 14,467 12,967 900 0 2,000 2,000 1000 4,479 8,200 3,721 450 0 30,000 30,000 1000 0 2,680 2,680 1000 0 7,000 7,000 1000 19,936 30,000 10,064 340 369 6,000 5,631 940 2,360 4,000 1,640 410 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 10 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING 2215-436-460430-373 DUES & TRAINING 2,983 8,000 5,017 630 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 0 400 400 1000 2215-436-460430-395 EQUIPMENT RENTAL 557 700 143 200 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 2,494 5,500 3,006 550 2215-436-460430-440 IRRIGATION SUPPLIES 2,962 9,000 6,038 670 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 160 1,700 1,540 910 2215-436-460430-521 CENTRAL GARAGE TRANSFER 30,476 40,634 10,158 250 2215-436-460430-610 DEBT SERVICE PRINCIPAL 30,928 41,602 10,675 260 2215-436-460430-620 DEBT SERVICE INTEREST 2,647 4,280 1,633 380 2215-436-460430-931 PARK IMPROV - THOMPSON PLAYGROUND 4,933 29,000 24,067 830 2215-436-460430-932 PARK IMPROV - NORTHRIDGE IRRIGATION 0 20,000 20,000 1000 2215-436-460430-933 PARK IMPROVEMENTS - DOG PARK 32,972 50,000 17,028 340 2215-436-460430-941 KUBOTA MOWER AND SPRAY GATOR (FY17/ 35,191 64,000 28,809 450 SUBTOTAL PARKS EXPENDITURES 547,567 944,744 397,177 420 ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 66,010 90,559 24,549 270 2215-436-460440-111 SEASONAL SALARIES 24,559 41,904 17,345 410 2215-436-460440-153 HEALTH INSURANCE 16,622 28,403 11,781 410 2215-436-460440-155 RETIREMENT 6,710 6,975 265 40 2215-436-460440-221 SAFETY EQUIPMENT 0 350 350 1000 2215-436-460440-229 OTHER SUPPLIES 2,573 15,500 12,927 830 2215-436-460440-231 GAS 3,550 9,500 5,950 630 2215-436-460440-241 CONSUMABLE TOOLS 38 5,000 4,962 990 2215-436-460440-341 ELECTRICITY 6,510 8,500 1,990 230 2215-436-460440-345 TELEPHONE & COMMUNICATION 127 175 48 270 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 1000 2215-436-460440-355 CONTRACT SERVICES - ASPHAT RESURFC 22,549 50,000 27,451 550 2215-436-460440-362 EQUIPMENT MAINTENANCE 144 600 456 760 2215-436-460440-364 LANDSCAPING 136 600 464 770 2215-436-460440-367 VANDALISM REPAIRS 0 500 500 1000 2215-436-460440-373 DUES & TRAINING 140 500 360 720 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 0 200 200 1000 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 1000 2215-436-460440-420 METAL PRODUCTS 2,920 5,300 2,380 450 2215-436-460440-440 IRRIGATION 2,470 4,500 2,030 450 2215-436-460440-452 SAND & GRAVEL 1,078 1,000 78- -80 2215-436-460440-521 CENTRAL GARAGE TRANSFER 823 1,097 274 250 2215-436-460440-940 EQUIPMENT - SAND PRO GROOMER 2,650 5,000 2,350 470 SUBTOTAL ATHLETIC COMPLEX 159,608 277,313 117,705 420 RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 60,477 83,239 22,762 270 2215-436-460431-111 SEASONAL SALARIES 6,622 8,389 1,767 210 2215-436-460431-153 HEALTH INSURANCE 14,785 19,973 5,188 260 2215-436-460431-155 RETIREMENT 4,705 6,943 2,238 320 2215-436-460431-229 MISC. SUPPLIES 5,119 9,070 3,951 440 2215-436-460431-231 GAS 322 720 398 550 2215-436-460431-320 PRINTING & ADVERTISING 28 11,265 11,237 1000 2215-436-460431-345 TELEPHONE & COMMUNICATION 410 640 230 360 2215-436-460431-354 CONTRACT SERVICES 17,185 21,060 3,875 180 2215-436-460431-355 On Line Registration 0 7,499 7,499 1000 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 11 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. 2215-436-460431-357 MUSIC FRANCHISE FEES 1,077 1,100 23 20 2215-436-460431-373 DUES & TRAINING 100 1,000 900 900 SUBTOTAL RECREATION 110,831 170,898 60,067 350 YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 53,664 74,110 20,446 280 2215-436-460448-111 SEASONAL SALARIES 77,715 139,101 61,386 440 2215-436-460448-121 OVERTIME 0 300 300 1000 2215-436-460448-153 HEALTH INSURANCE 14,019 18,797 4,778 250 2215-436-460448-155 RETIREMENT 4,172 6,622 2,450 370 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 30 400 370 920 2215-436-460448-229 MISC. SUPPLIES 1,245 3,730 2,485 670 2215-436-460448-231 GAS 134 500 366 730 2215-436-460448-320 PRINTING & ADVERTISING 25 270 245 910 2215-436-460448-345 TELEPHONE & COMMUNICATION 680 1,000 320 320 2215-436-460448-354 CONTRACT SERVICES 7,914 11,380 3,466 300 2215-436-460448-355 AFTER SCHOOL PROGRAM 654 1,200 546 450 2215-436-460448-356 BANK FEES/CC CHARGES 1,657 6,080 4,423 730 2215-436-460448-373 DUES & TRAINING 285 1,000 715 720 SUBTOTAL YOUTH CAMPS 162,194 264,490 102,296 390 POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 121,820 179,308 57,488 320 2215-437-460445-121 OVERTIME 129 500 371 740 2215-437-460445-155 RETIREMENT 1,018 1,500 482 320 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 192 500 308 620 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,580 2,700 1,120 410 2215-437-460445-226 CHLORINE/CHEMICALS 14,601 27,000 12,399 460 2215-437-460445-228 CONCESSION STAND SUPPLIES 12,753 21,000 8,247 390 2215-437-460445-229 TOOLS/OTHER SUPPLIES 542 4,500 3,958 880 2215-437-460445-341 ELECTRICITY 6,118 9,500 3,382 360 2215-437-460445-344 NATURAL GAS 11,199 25,000 13,801 550 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,323 1,620 297 180 2215-437-460445-354 LICENSES & FEES 669 1,300 631 490 2215-437-460445-356 BANK FEES/ CC CHARGES 1,756 1,632 124- -80 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 7,626 45,500 37,874 830 2215-437-460445-380 TRAINING MATERIALS 0 1,800 1,800 1000 SUBTOTAL POOL EXPENDITURES 181,326 323,360 142,034 440 TOTAL PARKS & RECREATION/POOL 1,161,526 1,980,805 819,279 410 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 12 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING FORESTRY & DEVELOPER TREES 2600-436-460433-110 SALARIES -URBAN FORESTRY 101,091 161,069 59,978 370 2600-436-460433-111 SEASONAL SERVICES 542 29,856 29,314 980 2600-436-460433-121 OVERTIME 10 1,000 990 990 2600-436-460433-153 HEALTH INSURANCE 22,855 42,075 19,220 460 2600-436-460433-155 RETIREMENT 7,702 14,088 6,386 450 2600-436-460433-229 OFFICE/OTHER SUPPLIES 120 600 480 800 2600-436-460433-231 GAS 2,699 2,500 199- -80 2600-436-460433-241 CONSUMABLE TOOLS 2,712 3,249 537 170 2600-436-460433-354 CONTRACT SERVICES 71,421 356,560 285,139 800 2600-436-460433-357 FORESTRY GRANT 6,943 19,500 12,558 640 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 1,712 5,000 3,288 660 2600-436-460433-362 EQUIPMENT MAINTENANCE 408 2,500 2,092 840 2600-436-460433-364 LANDSCAPING & TREES 1,285 8,000 6,716 840 2600-436-460433-373 DUES & TRAINING 3,144 3,500 356 100 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 1,138 1,138 0 0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 6,125 8,167 2,042 250 2600-436-460433-522 ADMINISTRATIVE TRANSFER 9,148 12,197 3,049 250 2600-436-460433-528 DATA PROCESSING TRANSFER 3,128 4,171 1,043 250 2600-436-460433-610 DEBT SERVICE PRINCIPAL 10,904 14,905 4,001 270 2600-436-460433-620 INTEREST EXPENSE 1,012 1,295 283 220 2600-436-460433-940 MACHINERY & EQUIPMENT 48,180 55,000 6,820 120 TOTAL URBAN FORESTRY 302,276 746,370 444,094 600 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 SUED ($5,790) 2601-436-460435-357 COTTONWOOD SUED ($13,100) 2601-436-460435-358 WEST VIEW SUED ($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 SUED PHASE 4 2601-436-460435-369 GL VILLAGE GREENS, Ph 22B ($4,130) 2601-436-460435-370 GL VILLAGE GREENS PH22C ($5,600) TOTAL DEVELOPER TREES 2210 PARKS IN LIEU 2210-436-460430-934 CAPITAL IMPROVEMENTS 0 8,653 8,653 1000 0 4,336 4,336 1000 0 366 366 1000 0 11,231 11,231 1000 0 667 667 1000 0 1,603 1,603 1000 734 14,936 14,202 950 2,936 25,129 22,193 880 0 2,219 2,219 1000 0 948 948 1000 0 1,390 1,390 1000 0 484 484 1000 0 578 578 1000 0 8,490 8,490 1000 0 2,358 2,358 1000 0 8,812 8,812 1000 0 1,474 1,474 1000 0 1,100 1,100 1000 3,670 94,774 91,104 960 0 1,432 1,432 1000 TOTAL PARKS IN LIEU 0 1,432 1,432 1000 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 13 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 490,849 750,000 259,151 350 2230-000-342070-000 COUNTY EMS LEVY 47,398 110,000 62,602 570 2230-000-383010-000 TRANSFER FROM GENERAL FUND 262,500 350,000 87,500 250 TOTAL AMBULANCE REVENUE 800,747 1,210,000 409,253 340 AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 462,991 640,748 177,757 280 2230-440-420730-114 COMPTIME BUYBACK 0 3,500 3,500 1000 2230-440-420730-115 OUT OF RANK PAY 1,435 2,500 1,065 430 2230-440-420730-121 OVERTIME 12,643 30,000 17,357 580 2230-440-420730-153 HEALTH INSURANCE 106,380 156,265 49,885 320 2230-440-420730-155 RETIREMENT 61,272 85,036 23,764 280 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 19 1,400 1,381 990 2230-440-420730-218 NON -CAPITAL EQUIPMENT 402 4,200 3,798 900 2230-440-420730-231 GAS & OIL 4,230 7,560 3,330 440 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 720 4,000 3,280 820 2230-440-420730-312 POSTAGE/PRINTING 0 1,500 1,500 1000 2230-440-420730-345 TELEPHONE & COMMUNICATION 1,425 1,700 275 160 2230-440-420730-354 CONTRACT SERVICES 33,947 43,690 9,743 220 2230-440-420730-355 911 CENTER CONTRIBUTION 25,875 34,500 8,625 250 2230-440-420730-359 AUDIT/CC OTHER FEES 1,758 1,650 108- -70 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 3,289 5,000 1,712 340 2230-440-420730-373 DUES & TRAINING 740 5,000 4,260 850 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 938 2,500 1,562 620 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 18,840 48,300 29,460 610 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 25,771 25,886 115 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 13,553 18,070 4,517 250 2230-440-420730-522 ADMINISTRATIVE TRANSFER 36,305 48,407 12,102 250 2230-440-420730-528 DATA PROCESSING TRANSFER 12,513 16,684 4,171 250 TOTAL AMBULANCE EXPENDITURES 825,045 1,188,096 363,051 310 2399 PUBLIC SAFETY IMPACT FEES 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 50 11,250 15,000 3,750 250 2399-413-420140-940 POLICE EQUIPMENT 0 100,000 100,000 1000 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 67,524 67,675 151 0% 2399-416-420400-620 INTEREST - FIRE TRUCK 1,992 2,034 42 20 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 750,000 750,000 1000 TOTAL PUBLIC SAFETY IMPACT FEE 80,766 934,709 853,943 910 FIRE & HAZMAT GRANTS 2956-416-420400-218 EQUIPMENT (NON CAPITAL) 320 0 320- 0% 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 3,243 5,000 1,757 350 2956-416-420415-940 AFG CRT FY16 COTS/ FY18 SCBA 0 231,448 231,448 1000 TOTAL FIRE GRANTS 3,563 236,448 232,885 980 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 14 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. 2957-416-420400-155 RETIREMENT 0 2,500 2,500 1000 2957-416-420400-373 RESPONSE HAZMAT-TRAVEL 1,945- 0 1,945 0% 2957-416-420410-125 PASS THRU HAZMAT OT 2,060 10,000 7,940 790 2957-416-420410-218 PASS THRU HAZMAT EQUIP 3,949 9,000 5,051 560 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 1,120 2,000 880 440 TOTAL HAZMAT GRANTS 5,185 23,500 18,315 780 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 15 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 455,239 800,000 344,761 430 2394-000-323103-000 PLUMBING PERMITS 28,086 30,000 1,914 60 2394-000-323104-000 MECHANICAL PERMITS 66,813 40,000 26,813- -670 2394-000-323105-000 ELECTRICAL PERMITS 62,849 75,000 12,151 160 2394-000-323108-000 PLAN REVIEW FEES 182,904 400,000 217,096 540 2394-000-371010-000 INVESTMENT EARNINGS 13,541 5,000 8,541- -1710 TOTAL REVENUE 809,432 1,350,000 540,568 400 BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 348,855 490,717 141,862 290 2394-420-420530-121 OVERTIME 26,356 10,000 16,356- -1640 2394-420-420530-153 HEALTH INSURANCE 70,680 101,155 30,475 300 2394-420-420530-155 RETIREMENT 28,357 36,340 7,983 220 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 25,777 28,105 2,328 80 2394-420-420530-231 GAS & OIL 2,442 3,500 1,058 300 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 9,327 7,300 2,027- -280 2394-420-420530-323 ST. ED. ASSESSMENTS 2,570 7,500 4,930 660 2394-420-420530-345 TELEPHONE & COMMUNICATION 2,960 4,000 1,040 260 2394-420-420530-353 AUDITING 3,350 4,500 1,150 260 2394-420-420530-354 CONTRACT SERVICES 19,357 10,000 9,357- -940 2394-420-420530-355 CITY WORKS LICENSING FEE 19,671 21,250 1,579 70 2394-420-420530-356 ARCGIS SERVER UPGRADE LICENSE 9,500 9,500 0 0% 2394-420-420530-360 FURNITURE 7,877 9,000 1,123 120 2394-420-420530-373 DUES & TRAINING 14,565 20,000 5,435 270 2394-420-420530-510 PROPERTY INSURANCE 7,176 5,389 1,787- -330 2394-420-420530-521 CENTRAL GARAGE TRANSFER 1,411 1,882 471 250 2394-420-420530-522 ADMINISTRATIVE TRANSFER 16,090 21,454 5,364 250 2394-420-420530-528 DATA PROCESSING TRANSFER 21,897 29,196 7,299 250 2394-420-420530-920 AWNING 9,447 10,000 553 60 2394-420-420530-940 SERVER 10,000 10,000 0 0% 2394-420-420530-944 VEHICLES 14,815 85,000 70,185 830 TOTAL BUILDING DEPT. 672,480 925,788 253,308 270 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 16 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 53,950 72,058 18,108 250 2400-410-430263-153 HEALTH INSURANCE 8,646 12,535 3,889 310 2400-410-430263-155 RETIREMENT 4,046 5,324 1,278 240 2400-410-430263-244 STREET LIGHT SUPPLIES 4,511 18,000 13,489 750 2400-410-430263-245 LUMINAIRES 20,075 30,000 9,925 330 2400-410-430263-246 LED LUMINAIRE UPGRADE 14,940 60,000 45,060 750 2400-410-430263-341 ELECTRICITY 117,852 182,000 64,148 350 2400-410-430263-360 REPAIR & MAINT SERVICES 9,342 20,000 10,658 530 2400-410-430263-510 INSURANCE 711 1,500 789 530 2400-410-430263-522 ADMINISTRATIVE TRANSFER 9,902 13,202 3,300 250 2400-410-430263-940 MACHINERY & EQUIPMENT 35,549 36,000 451 to 2400-410-490500-610 DEBT SERVICE -PRINCIPAL 22,055 22,055 0- 0% 2400-410-490500-620 DEBT SERVICE -INTEREST EXPENSE 413 551 138 250 TOTAL LIGHT MAINT. 301,992 473,225 171,233 360 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 43,192 94,557 51,365 540 2420-421-430234-957 ALLEY PAVING 12,138 40,000 27,862 700 2420-421-430240-231 GAS & OIL 25,544 40,000 14,456 360 2420-421-430240-344 NATURAL GAS 3,990 5,500 1,510 270 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 1000 2420-421-430240-360 REPAIR & MAINT SERVICES 450 1,500 1,050 700 2420-421-430240-368 OVERLAY/CHIPSEALS 119,073 269,073 150,000 560 2420-421-430240-452 GRAVEL 3,334 3,500 166 50 2420-421-430240-453 EQUIPMENT RENTAL 684 5,000 4,316 860 2420-421-430240-471 DE-ICER/ROAD OIL 23,330 40,000 16,670 420 2420-421-430240-472 ASPHALT 9,038 53,000 43,962 830 2420-421-430240-473 CRACK SEALING 4,707 14,500 9,793 680 2420-421-430240-474 PAINT STRIPING MATERIALS 1,345 30,000 28,655 960 TOTAL GAS TAX 246,825 616,630 369,805 600 2825 MAGI GRANT 2825-421-430240-940 SANDER / SWEEPER 0 433,202 433,202 1000 TOTAL MAGI GRANT 0 433,202 433,202 1000 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 533,122 731,217 198,095 270 2500-421-430240-121 OVERTIME 25,634 25,000 634- -30 2500-421-430240-153 HEALTH INSURANCE 108,938 163,219 54,281 330 2500-421-430240-155 RETIREMENT 41,641 53,704 12,063 220 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 2,616 12,360 9,744 790 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 7,044 8,950 1,906 210 2500-421-430240-220 OTHER SUPPLIES 3,321 4,500 1,179 260 2500-421-430240-231 GAS & OIL 26,321 40,000 13,679 340 2500-421-430240-341 ELECTRICITY 2,039 3,500 1,461 420 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 1,078 1,500 422 280 2500-421-430240-354 CONTRACT SERVICES 7,534 30,000 22,466 750 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 17 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. 2500-421-430240-356 CONSULTANT 0 65,050 65,050 1000 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 20,422 33,500 13,078 390 2500-421-430240-366 BUILDING MAINTENANCE 1,705 5,000 3,295 660 2500-421-430240-373 DUES & TRAINING 1,154 5,500 4,346 790 2500-421-430240-388 MEDICAL SERVICES 285 1,000 716 720 2500-421-430240-510 LIABILITY INSURANCE 17,650 17,359 291- -20 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 1000 2500-421-430240-521 CENTRAL GARAGE TRANSFER 135,176 180,235 45,059 250 2500-421-430240-522 ADMINISTRATIVE TRANSFER 69,975 93,300 23,325 250 2500-421-430240-528 DATA PROCESSING TRANSFER 9,384 12,513 3,129 250 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 74,916 122,878 47,962 390 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 2,290 35,820 33,530 940 2500-421-430240-920 SALT BRINE TANK 2,777 11,050 8,273 750 2500-421-430240-921 SAND/COLD MIX STORAGE SHED 15,277 15,325 48 0% 2500-421-430240-923 COLD STORAGE ROOF REPLACEMENT 0 31,500 31,500 1000 2500-421-430240-953 SHOP COMPLEX PAYVEMENT RESTORATION 0 38,200 38,200 1000 2500-421-430240-969 4TH AVE E MAIN REPLC PHASE 1-4 615,098 670,000 54,902 80 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 11,554 0 11,554- 0% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 3,939 0 3,939- 0% 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 262,463 881,952 619,489 700 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 296,575 330,807 34,232 100 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 1000 2500-421-430264-110 TSS - SALARIES 100,564 124,700 24,136 190 2500-421-430264-121 OVERTIME 0 7,500 7,500 1000 2500-421-430264-153 HEALTH INSURANCE 16,728 17,614 886 50 2500-421-430264-155 RETIREMENT 7,434 9,084 1,650 180 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 622 1,500 878 590 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 2,717 10,200 7,483 730 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 1,111 3,500 2,389 680 2500-421-430264-242 STREET SIGNS 5,863 35,000 29,137 830 2500-421-430264-243 TRAFFIC SIGNALS 5,057 20,000 14,943 750 2500-421-430264-245 BARRICADE MATERIALS 2,127 5,000 2,873 570 2500-421-430264-341 ELECTRICITY 1,412 3,000 1,588 530 2500-421-430264-345 COMMUNICATIONS 593 850 257 300 2500-421-430264-354 CONTRACT SERVICES 7,288 10,000 2,712 270 2500-421-430264-362 EQUIPMENT MAINTENANCE 3,203 3,000 203- -70 2500-421-430264-366 BUILDING MAINTENANCE 230 2,000 1,770 890 2500-421-430264-373 DUES & TRAINING 4,644 5,500 856 160 2500-421-430264-428 PAINT MATERIALS 4,147 5,000 853 170 2500-421-430264-510 LIABILITY INS.-TSS 1,793 2,014 221 11% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 0 2,500 2,500 1000 2500-421-430264-521 CENTRAL GARAGE TRANSFER 6,018 8,024 2,006 250 2500-421-430264-532 OFFICE RENT 6,422 6,422 0 0% 2500-421-430264-940 MACHINERY & EQUIPMENT 14,400 36,000 21,600 600 TOTAL SPEC. ST. MAINT. 2,492,301 3,981,175 1,488,874 370 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 18 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 1,600 1,600 0 0% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 7,481 9,975 2,494 250 2185-000-430300-840 REDEVELOPMENT ACTIVITY 0 2,000,000 2,000,000 1000 2185-480-470240-110 SALARIES 14,828 19,988 5,160 260 2185-480-470240-153 HEALTH INSURANCE 3,115 2,963 152- -50 2185-480-470240-155 RETIREMENT 1,163 1,568 405 260 2185-480-470240-345 TELEPHONE & COMMUNICATION 36 48 12 250 TOTAL AIRPORT TIF 28,223 2,036,142 2,007,919 990 2188 WESTSIDE TIF REVENUE 2188-000-311100-000 REAL PROPERTY TAXES 129,574 300,000 170,426 570 2188-000-311200-000 PERSONAL PROPERTY TAXES 7,764 0 7,764- 0% 2188-000-312000-000 PEN & INTEREST DEL. TAXES 376 200 176- -880 2188-000-335230-000 ENTITLEMENT SHARE PMT/SB96, 372 121,564 243,128 121,564 500 2188-000-341015-000 DEVELOPER PMT-DEPOT PLACE APTS 3,977 8,500 4,523 530 2188-000-371010-000 INVESTMENT EARNINGS 30,500 15,000 15,500- -1030 2188-000-381030-000 BOND PROCEEDS 0 5,000,000 5,000,000 1000 TOTAL REVENUE 293,755 5,566,828 5,273,073 950 EXPENDITURES 2188-480-470230-110 SALARIES 31,824 43,230 11,406 260 2188-480-470230-153 HEALTH INSURANCE 5,103 5,599 496 90 2188-480-470230-155 RETIREMENT 2,494 3,375 881 260 2188-480-470230-353 AUDIT 3,000 3,000 0 0% 2188-480-470230-354 TO PORT/GATEWAY W. BLDG MAINT. 0 5,000 5,000 1000 2188-480-470230-356 TELEPHONE 144 192 48 250 2188-480-470230-522 ADMINISTRATIVE TRANSFER 2,974 3,966 992 250 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 277,909 950,000 672,091 710 2188-480-470230-840 TRANSFER TO DEBT SERVICE 30,000 40,000 10,000 250 2188-480-470230-842 TRANSFER TO DEBT SERVICE FUND 3188 0 200,000 200,000 1000 2188-480-470240-720 PRE AWARD TIGER 37,120 0 37,120- 0% 2188-480-470240-840 TRANSFER TO TIGER GRANT FUND 0 8,107,000 8,107,000 1000 TOTAL WESTSIDE TIF 390,568 9,361,362 8,970,794 960 OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 11,000 11,000 1000 2310-480-470210-356 FED -EX REIMBURSEMENT 9,927 10,500 573 50 2310-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 45,000 60,000 15,000 250 2311-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 7,500 10,000 2,500 250 TOTAL OLD SCHOOL TIFS 62,427 91,500 29,073 320 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 19 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 0 1,000 1,000 1000 2880-480-470210-354 CONTRACT SERVICES 405 1,000 595 600 2880-480-470210-711 REDEVELOPMENT 15,654 100,000 84,346 840 TOTAL LOAN REVOLVING 16,059 102,000 85,941 840 2881 CD LOAN REV. #2 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 405 0 405- 0% 2881-480-470210-711 REDEVELOPMENT 0 150,000 150,000 1000 TOTAL 2881 CD REV. #2 405 150,000 149,595 1000 2886 CD MISC. 2886-480-470210-211 GRANT ADMINISTRATION EXP/PROJECT EX 0 2,000 2, 000 1000 2886-480-470210-353 AUDITING 1,000 1,000 0 0% 2886-480-470210-373 DUES & TRAINING 60 2,000 1,940 970 2886-480-470210-379 MEETINGS 0 1,000 1,000 1000 2886-480-470210-396 GRANT SERVICES 0 5,000 5,000 1000 2886-480-470210-522 ADMINISTRATIVE TRANSFER 0 2,000 2,000 1000 2886-480-470210-528 DATA PROCESSING TRANSFER 6,256 8,342 2,086 250 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 1000 2886-480-470210-790 COMM. DEV. ACTIVITIES 0 3,750 3,750 1000 2886-480-470210-795 REDEVELOPMENT- OLD SCHOOL STATION 78,247 175,102 96,855 550 TOTAL CD MISC. 86,738 233,869 147,131 630 2887 RURAL DEVELOPMENT #1 2887-480-470210-354 CONT SERV (LOAN SOFTWARE) 405 0 405- 0% 2887-480-470210-610 DEBT SERVICE/PAIN-L#61-01 18,455 18,454 1- 0% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 3,619 3,620 1 0% 2887-480-470210-750 REDEVELOPMENT LOANS 10 200,000 199,990 1000 TOTAL RURAL DEVELOPMENT #1 22,489 222,074 199,585 900 2888 RURAL DEVELOPMENT #2 2888-480-470210-354 CONT SERV (LOAN SOFTWARE) 405 0 405- 0% 2888-480-470210-610 DEBT SERVICE/PAIN-L#61-03 8,219 8,219 0 0% 2888-480-470210-620 INTEREST EXPENSE -USDA LOAN 61-03 1,806 1,806 0- _0% 2888-480-470210-750 REDEVELOPMENT LOANS 0 150,000 150,000 1000 TOTAL RURAL DEVELOPMENT #2 10,430 160,025 149,595 930 2953 EPA BROWNFIELDS 2953-480-470210-354 CONT SERV/PETROLEUM 0 185,592 185,592 1000 2953-480-470210-373 TRAVEL/PETROLEUM 965 3,357 2,392 710 2953-480-470215-354 CONT SERV/HAZARDOUS 0 185,592 185,592 1000 2953-480-470215-373 TRAVEL/HAZARDOUS 966 3,517 2,552 730 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 20 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING TOTAL EPA BROWNSFIELD 1,931 378,058 376,127 990 2955-480-470210-229 2955-480-470210-352 2955-480-470210-353 2955-480-470210-354 2955-480-470210-720 2955-480-470210-721 2955-480-470210-725 2955-480-470215-229 2955-480-470215-354 2955-480-470215-373 2955-480-470215-720 2955 BROWNFIELDS LOAN REV. SUPPLIES -PETROLEUM PERSONNEL -PETROLEUM FRINGES -PETROLEUM CONTRACTED SERVICES-PETROLUEM CLEANUP LOANS -PETROLEUM CLEANUP SUBGRANTS-PETRO REVOLVED FUNDS -PETROLEUM SUPPLIES -HAZARDOUS SUBSTANCES CONTRACT SERV-HAZARDOUS SUBST TRAVEL -HAZARDOUS SUBTSANCE 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 1000 0 3,505 3,505 1000 0 493 493 1000 0 1,488 1,488 1000 0 62,354 62,354 1000 0 100,000 100,000 1000 0 100,500 100,500 1000 0 1,158 1,158 1000 0 88 88 1000 0 2,330 2,330 1000 0 314,600 314,600 1000 0 587,424 587,424 1000 0 5,787,000 5,787,000 1000 4,980,899 12,320,000 7,339,101 600 4,980,899 18,107,000 13,126,101 720 561,995 1,302,724 740,729 570 561,995 1,302,724 740,729 570 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 21 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD /2015 CRT 1,367 20,264 18,897 930 2915-413-420140-354 CONT SERV-WPD/MFWPE - STONEGARDEN 15,135 41,209 26,074 630 TOTAL 2915 STONEGARDEN GRANT 16,501 61,473 44,972 730 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 42,013 62,808 20,795 330 2916-413-420140-121 OVERTIME 7,185 7,500 315 40 2916-413-420140-153 HEALTH INSURANCE 5,638 8,307 2,669 320 2916-413-420140-155 RETIREMENT 5,685 8,431 2,746 330 2916-413-420140-354 CONTRACT SERVICES 3,886 6,000 2,114 350 TOTAL 2916 DRUG ENFORCEMENT 64,407 93,046 28,639 310 2918 CHRP GRANT 2918-413-420140-110 SALARIES & PAYROLL COSTS 45,283 57,417 12,134 210 2918-413-420140-153 HEALTH INSURANCE 6,228 8,307 2,079 250 2918-413-420140-155 RETIREMENT 5,835 7,706 1,871 240 TOTAL CHRP GRANT 57,346 73,430 16,084 220 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 2,108 4,000 1,892 470 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 17,708 36,000 18,292 510 2919-413-420140-127 SCHOOL DIST. OT 16,915 20,000 3,085 150 2919-413-420140-218 JAG GRT/RADIOS & TRAINING 0 12,000 12,000 1000 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 1,827 12,500 10,673 850 2919-413-420140-221 BULLET PROOF VESTS & HSPG CRT VESTS 6,015 7,000 985 140 TOTAL LAW ENF. GRANT 44,574 91,500 46,926 510 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 22 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k 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 259,831 500,000 240,169 480 259,831 500,000 240,169 480 4,288 25,000 20,712 830 4,288 25,000 20,712 830 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 23 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. ENTERPRISE FUNDS WATER REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 720 0 720- 0% 5210-000-331113-000 FEMA HMGP DR1996P7F/ BACKUP GENERAT 63,847 0 63,847- 0% 5210-000-343210-000 METERED WATER SALES 2,605,995 2,900,000 294,005 100 5210-000-343220-000 UNMETERED WATER SALES 17,959 30,000 12,041 400 5210-000-343225-000 IMPACT FEES 528,401 323,000 205,401- -640 5210-000-343230-000 METER REPLACEMENT FEE 75,672 98,000 22,328 230 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 41,012 19,000 22,012- -1160 5210-000-343265-000 IMPACT ADMIN FEES 0 17,000 17,000 1000 5210-000-343270-000 WATER TURN ON FEES 4,860 6,000 1,140 190 5210-000-343275-000 TAG FEE 47,700 45,000 2,700- -60 5210-000-343365-000 LATECOMER ADMIN FEE 5,586 0 5,586- 0% 5210-000-371010-000 INVESTMENT EARNINGS 81,696 80,000 1,696- -20 5210-000-381050-000 INCEPTION OF LEASE (FOR BUDGET ONLY 0 2,151,616 2,151,616 1000 TOTAL WATER REVENUE 3,473,447 5,669,616 2,196,169 390 WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 525,626 717,155 191,529 270 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 1000 5210-447-430550-121 OVERTIME 7,430 20,000 12,570 630 5210-447-430550-153 HEALTH INSURANCE 109,770 162,626 52,856 330 5210-447-430550-155 RETIREMENT 39,769 52,778 13,009 250 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 4,097 12,000 7,903 660 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 7,378 8,500 1,122 130 5210-447-430550-226 CHLORINE & CHEMICALS 24,874 38,000 13,126 350 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 2,891 4,500 1,609 360 5210-447-430550-231 GAS & OIL 17,070 35,000 17,930 510 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 330 1,000 670 670 5210-447-430550-336 LICENSES & FEES 15,750 18,500 2,750 150 5210-447-430550-341 ELECTRICITY 116,373 150,000 33,627 220 5210-447-430550-344 NATURAL GAS 8,346 15,500 7,154 460 5210-447-430550-345 TELEPHONE & COMMUNICATION 7,957 10,500 2,543 240 5210-447-430550-349 LAB SERVICES 7,434 20,000 12,566 630 5210-447-430550-353 AUDITING 5,000 5,000 0 0% 5210-447-430550-354 CONTRACT SERVICES 27,584 55,000 27,416 500 5210-447-430550-356 CONSULTANTS-WTR RIGHTS/MODELING 286,280 325,000 38,720 120 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 2,991 15,000 12,009 800 5210-447-430550-366 BUILDING MAINTENANCE 1,765 12,000 10,235 850 5210-447-430550-373 DUES & TRAINING 3,054 9,000 5,946 660 5210-447-430550-388 MEDICAL SERVICES 733 600 133- -220 5210-447-430550-410 CONSTRUCTION MATERIALS 12,906 35,000 22,094 630 5210-447-430550-422 HYDRANTS 8,209 10,000 1,791 180 5210-447-430550-423 MATERIALS FOR MAINS 3,285 14,000 10,715 770 5210-447-430550-424 MATERIALS -SERVICE LINES 8,747 12,000 3,253 270 5210-447-430550-425 MATERIALS PUMPS/WELLS 7,250 45,000 37,750 840 5210-447-430550-510 PROPERTY & LIABILITY INS. 20,309 19,398 911- -50 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 5,283 10,000 4,717 470 5210-447-430550-521 CENTRAL GARAGE TRANSFER 17,812 23,750 5,938 250 5210-447-430550-522 ADMINISTRATIVE TRANSFER 85,667 114,222 28,555 250 5210-447-430550-528 DATA PROCESSING TRANSFER 21,897 36,000 14,103 390 5210-447-430550-532 LEASE PAYMENTS (City Hall rent) 9,048 9,500 452 50 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 24 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING 5210-447-430550-921 SAND/COLD MIX STORAGE SHED 14,997 15,325 328 20 5210-447-430550-936 Noffsinger Spring Generator 7,736 31,057 23,321 750 5210-447-430550-938 OLD SCHOOL WELL FREQUENCY DRIVES 44,830 45,000 170 0% 5210-447-430550-940 MACHINERY & EQUIPMENT 7,004 32,400 25,396 780 5210-447-430550-948 METERS (METER FUNDS) 010125 20,175 110,000 89,825 820 5210-447-430550-951 SECURITY SCADA UPGRADES 995 15,000 14,005 930 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 0 38,200 38,200 1000 5210-447-430550-959 PARKS METERING PHASE II 6,079 28,416 22,337 790 5210-447-430550-962 9TH AVE WEST WATER MAIN REPLACEMENT 667 625,000 624,333 1000 5210-447-430550-963 8TH STREET WEST WATER MAIN REPLACEM 0 416,000 416,000 1000 5210-447-430550-969 4TH AVE E MAIN BETE. PH. 1 1,744,422 1,962,538 218,116 11% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 320,254 320,254 1000 5210-447-430555-941 METERS (NEW SERVICES)010120 16,580 45,600 29,020 640 5210-447-430555-953 SECTION 36 WELL 171,812 961,746 789,934 820 SUBTOTAL WATER FACILITIES 3,458,216 6,668,065 3,209,849 480 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.25o;WRF8114 5210-447-490206-620 INT-MTR&WELL/WRF7104 1.25o;WRF8114 5210-447-490210-620 BOI 2003 INTEREST (PHASE I) 5210-447-490250-610 PRIN-WTR MAIN/WRF1032R 20/IDAHO&MAI 5210-447-490250-620 INT-WTR MAIN/WRF1032R 20/IDAHO&MAIN SUBTOTAL REVENUE BONDS DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION 82,026 111,417 29,391 260 20,687 31,823 11,136 350 6,364 8,527 2,163 250 1,208 2,500 1,292 520 2,000 2,000 0 0% 29,667 45,000 15,333 340 13,861 22,000 8,139 370 8 3,000 2,993 1000 1,291 2,500 1,209 480 8,588 11,451 2,863 250 21,897 33,000 11,103 340 6,422 6,422 0 0% 194,019 279,640 85,621 310 0 70,000 70,000 1000 25,943 25,943 1 0% 350 350 0 0% 0 192,810 192,810 1000 20,723 93,034 72,312 780 36,870 0 36,870- 0% 0 48,000 48,000 1000 3,240 3,240 0 0% 87,125 433,377 346,252 800 0 840,000 840,000 1000 0 840,000 840,000 1000 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 25 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. TOTAL WATER FUND 3,739,360 8,221,082 4,481,722 55% 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 26 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 720 0 720- 0% 5310-000-343310-000 SEWER SERVICE CHARGES 3,418,533 4,425,000 1,006,467 230 5310-000-343330-000 IMPACT FEES (SANITARY) 726,731 540,000 186,731- -350 5310-000-343335-000 IMPACT FEES (WWTP) 440,445 320,000 120,445- -380 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 356 10,000 9,645 960 5310-000-343365-000 LATECOMER ADMIN FEES 762 0 762- 0% 5310-000-371010-000 INVESTMENT EARNINGS 82,174 100,000 17,826 180 5310-000-381050-000 INCEPTION OF LEASE 0 7,873,808 7,873,808 1000 TOTAL SEWER REVENUE 4,669,721 13,268,808 8,599,087 650 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 69,197 94,168 24,971 270 15,783 25,275 9,492 380 5,359 7,190 1,831 250 1,208 2,500 1,292 520 2,000 2,000 0 0% 29,667 45,000 15,333 340 13,861 22,000 8,139 370 8 3,000 2,993 1000 1,336 2,500 1,164 470 7,887 10,516 2,629 250 21,897 33,000 11,103 340 6,422 6,422 0 0% 174,624 253,571 78,947 310 SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 185,387 252,466 67,079 270 5310-454-430630-121 OVERTIME 493 5,500 5,007 910 5310-454-430630-153 HEALTH INSURANCE 43,911 66,485 22,574 340 5310-454-430630-155 RETIREMENT 14,003 18,683 4,680 250 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 3,559 10,200 6,641 650 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 3,524 8,350 4,826 580 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 709 2,300 1,591 690 5310-454-430630-231 GAS & OIL 6,615 12,000 5,385 450 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 0 500 500 1000 5310-454-430630-341 ELECTRICITY 38,129 54,500 16,371 300 5310-454-430630-344 NATURAL GAS 9,140 16,500 7,360 450 5310-454-430630-345 TELEPHONE & COMMUNICATION 19,867 24,000 4,133 170 5310-454-430630-353 AUDITING 3,000 3,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 16,675 24,000 7,325 310 5310-454-430630-356 CONSULTANTS 11,196 258,000 246,804 960 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 1,194 7,000 5,806 830 5310-454-430630-373 DUES & TRAINING 1,137 5,500 4,363 790 5310-454-430630-388 MEDICAL SERVICES 280 500 220 440 5310-454-430630-410 CONSTRUCTION MATERIALS 5,666 10,000 4,334 430 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 20,855 50,000 29,145 580 5310-454-430630-510 PROPERTY & LIABILITY INS. 17,457 18,419 962 50 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 16,900 25,000 8,100 320 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 27 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING 5310-454-430630-521 CENTRAL GARAGE TRANSFER 6,431 8,575 2,144 250 5310-454-430630-522 ADMINISTRATIVE TRANSFER 48,045 64,060 16,015 250 5310-454-430630-528 DATA PROCESSING TRANSFER 12,513 19,000 6,487 340 5310-454-430630-532 OFFICE RENT 6,422 6,422 0 0% 5310-454-430630-921 SAND/COLD MIX STORAGE SHED 14,321 15,325 1,004 70 5310-454-430630-940 MACHINERY & EQUIPMENT 7,004 92,400 85,396 920 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 0 38,200 38,200 1000 5310-454-430630-954 GRANDVIEW L.S. RELOCATOON & UPSIZE 0 230,000 230,000 1000 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 0 20,000 20, 000 1000 5310-454-430630-959 2ND ALLEY E REPLACEMENT 0 558,000 558,000 1000 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 5,193 50,000 44,807 900 5310-454-430630-962 SEWER MAIN SLIP LINING 652 195,000 194,348 1000 SUBTOTAL SEWER COLLECTION 520,277 2,169,885 1,649,608 760 IMPACT FEES 5310-454-430635-954 GRANDVIEW L.S RELOCATION & UPSIZE ( 0 230,000 230,000 1000 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 0 200,000 200,000 1000 5310-454-430635-956 WEST SIDE INTERCEPTOR PHASE I 0 10,680,848 10,680,848 1000 5310-454-430635-957 WEST SIDE INTERCEPTOR 1,138,277 1,755,101 616,824 350 SUBTOTAL IMPACT FEE EXPENSE 1,138,277 12,865,949 11,727,672 910 REVENUE BONDS/SANITARY 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.250 0 83,000 83,000 1000 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.250 13,511 13,511 0- 0% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.250 0 350 350 1000 SUBTOTAL REVENUE BONDS 13,511 96,861 83,350 860 DEPRECIATION -SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 820,000 820,000 1000 SUBTOTAL DEPRECIATION -SANITARY 0 820,000 820,000 1000 SUBTOTAL SANITARY SEWER 1,672,065 15,952,695 14,280,630 900 WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 318,164 448,827 130,663 290 5310-455-430640-111 SEASONAL SALARIES 1,818 5,000 3,182 640 5310-455-430640-112 SALARIES -RETIREMENT 4,244 0 4,244- 0% 5310-455-430640-121 OVERTIME 15,710 22,500 6,790 300 5310-455-430640-153 HEALTH INSURANCE 63,815 89,216 25,402 280 5310-455-430640-155 RETIREMENT 25,198 32,959 7,761 240 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 905 10,000 9,095 910 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 2,089 2,700 611 230 5310-455-430640-225 ALUM 5,820 20,000 14,180 710 5310-455-430640-226 CHLORINE & CHEMICALS 44,928 45,000 72 0% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 2,886 7,000 4,114 590 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 28 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING 5310-455-430640-231 GAS & OIL 8,950 16,000 7,050 440 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 362 350 12- -30 5310-455-430640-336 LICENSES & FEES 11,595 10,000 1,595- -160 5310-455-430640-341 ELECTRICITY 127,664 180,000 52,336 290 5310-455-430640-342 WATER 3,687 7,500 3,813 510 5310-455-430640-344 NATURAL GAS 32,879 60,000 27,121 450 5310-455-430640-345 TELEPHONE & COMMUNICATION 4,529 6,500 1,971 300 5310-455-430640-353 AUDITING 4,000 4,000 0 0% 5310-455-430640-354 CONTRACT -GLACIER GOLD 96,830 124,000 27,170 220 5310-455-430640-355 OTHER CONTRACT SERVICES 26,816 30,000 3,184 11% 5310-455-430640-356 CONSULTANTS 26,504 100,000 73,496 740 5310-455-430640-358 CONSULTANT-TMDL 632 125,000 124,368 990 5310-455-430640-360 MISC. MAINT SERVICES 10,625 30,000 19,375 650 5310-455-430640-366 BUILDING MAINTENANCE 27,607 50,000 22,393 450 5310-455-430640-373 DUES & TRAINING 3,431 7,500 4,069 540 5310-455-430640-388 MEDICAL SERVICES 413 500 88 180 5310-455-430640-510 PROPERTY & LIABILITY INS. 35,462 36,384 922 30 5310-455-430640-521 CENTRAL GARAGE TRANSFER 10,382 13,842 3,461 250 5310-455-430640-522 ADMINISTRATIVE TRANSFER 92,114 122,819 30,705 250 5310-455-430640-528 DATA PROCESSING TRANSFER 15,641 27,500 11,859 430 5310-455-430640-920 BUILDINGS 0 32,000 32,000 1000 5310-455-430640-940 COAT BASIN FY15; BOILER/HEAT EXCHAN 26,147 75,000 48,853 650 SUBTOTAL WWTP OPERATIONS 1,051,844 1,742,097 690,253 400 WWTP BONDED PROJECT SUBTOTAL WWTP BONDED 0 0 0 0% WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 52,060 100,000 47,940 480 5310-455-430645-933 SOLIDS DEWATERING DESIGN & CONST. 89,000 98,462 9,462 100 5310-455-430645-934 SECONDARY DIGESTER LID INSPECTION 18,777 902,702 883,925 980 5310-455-430645-937 SAND FILTER MAINT & REPLACEMENT 0 200,000 200,000 1000 5310-455-430645-940 MACHINERY & EQUIPMENT 73,938 307,828 233,890 760 SUBTOTAL WWTP REPLACEMENT 233,774 1,608,992 1,375,218 850 WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 79,743 108,136 28,393 260 5310-455-430646-121 OVERTIME 60 0 60- 0% 5310-455-430646-153 HEALTH INSURANCE 12,456 17,614 5,158 290 5310-455-430646-155 RETIREMENT 5,980 7,864 1,884 240 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 1,264 4,500 3,236 720 5310-455-430646-218 NON -CAPITAL EQUIPMENT 1,512 2,500 988 400 5310-455-430646-222 LAB SUPPLIES 12,525 14,500 1,975 140 5310-455-430646-349 LAB SERVICES 33,546 29,000 4,546- -160 5310-455-430646-362 EQUIPMENT MAINTENANCE 5,219 5,500 281 50 5310-455-430646-373 DUES & TRAINING 734 3,700 2,966 800 SUBTOTAL WWTP LAB OPERATIONS 153,039 193,314 40,275 210 DEBT SERVICE - WWTP 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 29 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. 5310-455-490227-610 PRIN-WWTP IMP/SRF8164R/2.250 0 814,000 814,000 1000 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.250 198,394 198,394 0 0% 5310-455-490227-630 FISCAL AGENT FEES 0 350 350 1000 5310-455-490228-610 PRIN/WWTP DIGESTER LID/SRF13326/3.0 0 46,000 46,000 1000 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 27,315 27,315 0 0% SUBTOTAL DEBT SERVICE - WWTP 225,709 1,086,059 860,350 790 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 1000 0 1,425,000 1,425,000 1000 0 1,875,000 1,875,000 1000 1,664,366 6,505,462 4,841,096 740 3,511,056 22,711,728 19,200,672 850 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 30 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. STORM SEWER REVENUE 5349-000-323108-000 PW PLAN REVIEW FEES 720 0 720- 0% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 1,533 2,500 967 390 5349-000-343033-000 IMPACT FEES 239,984 250,000 10,016 40 5349-000-343034-000 PERMIT FEES 1,370 0 1,370- 0% 5349-000-343035-000 STORM SEWER CHARGES 67 1,000 933 930 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 1,332,945 1,275,000 57,945- -50 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 1,848 1,200 648- -540 5349-000-371010-000 INTEREST ON INVESTMENTS 27,249 18,000 9,249- -510 5349-000-381050-000 INCEPTION OF LEASE 0 99,213 99,213 1000 TOTAL STORM REVENUE 1,605,715 1,646,913 41,198 30 STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 278,300 408,007 129,707 320 5349-453-430246-121 OVERTIME 750 4,000 3,250 810 5349-453-430246-153 HEALTH INSURANCE 59,027 98,404 39,377 400 5349-453-430246-155 RETIREMENT 21,084 30,228 9,144 300 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 9,525 12,100 2,575 210 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 3,175 6,550 3,375 520 5349-453-430246-229 OTHER SUPPLIES/TOOLS 2,108 2,200 92 40 5349-453-430246-231 GAS & OIL 5,952 11,500 5,548 480 5349-453-430246-345 TELEPHONE & COMMUNICATION 814 900 86 100 5349-453-430246-353 AUDITING 1,150 1,150 0 0% 5349-453-430246-354 CONTRACT SERVICE 6,008 6,000 8- _0% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 6,636 35,000 28,364 810 5349-453-430246-357 IMPACT FEE UPDATE 10,192 15,000 4,808 320 5349-453-430246-358 CONSULTANTS 6,954 7,000 46 to 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 8,812 15,000 6,188 410 5349-453-430246-360 REPAIR & MAINT SERVICES 0 2,500 2,500 1000 5349-453-430246-362 GROUNDWATER MONITORING 1,933 5,000 3,067 610 5349-453-430246-371 CURB & GUTTER 0 7,000 7,000 1000 5349-453-430246-373 DUES & TRAINING 1,602 5,500 3,898 710 5349-453-430246-388 MEDICAL SERVICES 0 100 100 1000 5349-453-430246-410 CONSTRUCTION MATERIALS 1,519 10,000 8,481 850 5349-453-430246-510 PROPERTY & LIABILITY INS. 3,576 9,000 5,424 600 5349-453-430246-521 CENTRAL GARAGE TRANSFER 6,431 8,575 2,144 250 5349-453-430246-522 ADMINISTRATIVE TRANSFER 33,263 44,350 11,087 250 5349-453-430246-528 DATA PROCESSING TRANSFER 12,513 13,000 487 40 5349-453-430246-530 BNSF LEASE PMT 4,588 5,900 1,313 220 5349-453-430246-532 OFFICE RENT 6,422 6,422 0 0% 5349-453-430246-610 PRINCIPAL 0 22,000 22,000 1000 5349-453-430246-620 INTEREST 0 8,000 8,000 1000 5349-453-430246-840 MAGI GRANT MATCH FY18 CARRYOVER 0 43,000 43,000 1000 5349-453-430246-921 SAND/COLD MIX STORAGE SHED 14,997 15,325 328 20 5349-453-430246-951 9TH ST E STORMWATER IMPRV 0 250,000 250,000 1000 5349-453-430246-952 STORM DRAIN CORRECTION 0 100,000 100,000 1000 5349-453-430246-953 SHOP COMPLEX PAVEMNT 0 38,200 38,200 1000 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 0 390,000 390,000 1000 5349-453-430246-968 4TH AVE EAST REPLACE - NON BONDED P 19,873 50,000 30,127 600 5349-453-430246-969 4TH AVE E REPLACE PHASE 1-4 71,914 99,213 27,299 280 5349-453-430248-960 STORMWATER FACILITY UPSIZE 84 230,000 229,916 1000 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 31 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. 5349-453-430249-940 MACHINERY FROM REPLACEMENT 7,004 92,400 85,396 920 5349-453-490400-620 INTEREST EXPENSE 461 0 461- 0% 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 285,000 285,000 1000 TOTAL STORM 606,664 2,393,524 1,786,860 750 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 32 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 996,104 975,000 21,104- -20 5510-000-343420-000 GARBAGE COLLECTION -BILLED 22,370 25,000 2,631 11% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,662 2,100 438 210 5510-000-371010-000 INVESTMENT EARNINGS 7,769 8,000 231 30 TOTAL SOLID WASTE REVENUE 1,027,905 1,010,100 17,805- -20 SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 299,466 409,153 109,687 270 5510-460-430840-112 SEVERANCE -RETIREMENT 0 60,455 60,455 1000 5510-460-430840-121 OVERTIME 4,189 6,500 2,311 360 5510-460-430840-153 HEALTH INSURANCE 67,236 96,542 29,306 300 5510-460-430840-155 RETIREMENT 22,628 30,045 7,417 250 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 1,948 9,500 7,552 790 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 23,351 37,500 14,149 380 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 1,780 5,500 3,720 680 5510-460-430840-231 GAS & OIL 35,079 55,000 19,921 360 5510-460-430840-341 ELECTRICITY 1,153 2,050 897 440 5510-460-430840-344 NATURAL GAS 2,030 4,500 2,470 550 5510-460-430840-345 TELEPHONE & COMMUNICATION 799 1,250 451 360 5510-460-430840-354 CONTRACT SERVICES 8,117 11,500 3,383 290 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 706 5,700 4,994 880 5510-460-430840-366 BUILDING MAINTENANCE 805 4,500 3,695 820 5510-460-430840-373 DUES & TRAINING 1,143 3,500 2,357 670 5510-460-430840-388 MEDICAL SERVICES 145 650 506 780 5510-460-430840-510 PROPERTY & LIABILITY INS. 8,985 13,500 4,515 330 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 110 4,000 3,890 970 5510-460-430840-521 CENTRAL GARAGE TRANSFER 52,340 69,786 17,446 250 5510-460-430840-522 ADMINISTRATIVE TRANSFER 32,435 43,247 10,812 250 5510-460-430840-528 DATA PROCESSING TRANSFER 9,384 12,513 3,129 250 5510-460-430840-532 OFFICE RENT 6,422 6,422 0 0% 5510-460-430840-610 DEBT SERVICE PRINCIPAL -GARBAGE TK 38,728 38,728 0- 0% 5510-460-430840-620 DEBT SERVICE INTEREST -GARBAGE TK 1,703 1,947 244 130 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 30,000 40,000 10,000 250 5510-460-430840-944 VEHICLES (Replacement $) 15,000 20,000 5,000 250 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 0 38,200 38,200 1000 5510-460-430845-224 JANITORIAL SUPPLIES 362 300 62- -210 5510-460-430845-341 ELECTRICITY 1,362 3,500 2,138 610 5510-460-430845-342 WATER 384 2,000 1,616 810 5510-460-430845-344 NATURAL GAS 3,990 6,000 2,010 340 5510-460-430845-360 REPAIR & MAINT SERVICES 1,605 23,500 21,895 930 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 1000 TOTAL SOLID WASTE EXPENSE 673,385 1,217,488 544,103 450 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 33 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 6,600 10,000 3,400 340 5160-000-343069-000 HANGER LEASES 8,500 12,000 3,500 290 5160-000-343071-000 HANGAR SITE LEASES 19,455 18,035 1,420- -80 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 13,098 19,145 6,047 320 5160-000-343102-000 GROUND LEASES 14,002 13,594 408- -30 5160-000-343620-000 FUEL TAX 4,117 5,000 883 180 5160-000-371010-000 INVESTMENT EARNINGS 1,498 1,200 298- -250 TOTAL AIRPORT REVENUE 67,270 78,974 11,704 150 5160-430-430310-210 5160-430-430310-341 5160-430-430310-354 5160-430-430310-356 5160-430-430310-362 5160-430-430310-390 5160-430-430310-510 5160-430-430310-522 5160-430-430310-528 5160-430-430310-820 5160 AIRPORT EXPENSES OFFICE SUPPLIES & EQUIP ELECTRICITY CONTRACT SERVICES -LABOR & MATERIALS CONTRACT SERVICES -SNOW REMOVAL REPAIR & MAINTENANCE EQUIPMENT RENTAL PROPERTY INSURANCE ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER DEPRECIATION TOTAL AIRPORT EXPENSES 0 1,000 1,000 1000 1,140 1,600 460 290 28,200 36,000 7,800 220 8,400 7,500 900- -120 0 10,000 10,000 1000 560 1,000 440 440 5,341 6,500 1,159 180 2,044 2,726 682 250 1,564 2,085 521 250 0 97,918 97,918 1000 47,250 166,329 119,079 720 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 34 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING INTERNAL SERVICE FUNDS INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 ENTITLEMENT SHARE PMT/HB124 153,750 205,000 51,250 250 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 81,955 173,000 91,045 530 6030-000-364030-000 SALE OF MISCELLANEOUS 464 0 464- 0% 6030-000-371010-000 INVESTMENT EARNINGS 1,113 1,100 13- -lo 6030-000-393000-000 INTERNAL SERVICES -DATA 176,742 235,655 58,913 250 TOTAL INFORMATION TECH REVENUE 414,023 614,755 200,732 330 INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 126,082 171,350 45,268 260 6030-401-410580-121 OVERTIME 250 1,000 750 750 6030-401-410580-153 HEALTH INSURANCE 33,526 44,701 11,175 250 6030-401-410580-155 RETIREMENT 9,951 13,115 3,164 240 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 6,199 6,100 99- -20 6030-403-410580-215 COMPUTER SUPPLIES 1,025 2,400 1,375 570 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 25,545 24,000 1,545- -60 6030-403-410580-325 WEBSITE 15,120 15,700 580 40 6030-403-410580-345 PAGER/PHONE 613 2,550 1,937 760 6030-403-410580-346 SUMMITNET & ISPS 7,139 14,000 6,861 490 6030-403-410580-353 LASER FICHE MAINTENANCE 3,432 3,500 68 20 6030-403-410580-354 MAINTENANCE CONTRACTS 3,961 5,000 1,039 210 6030-403-410580-355 LICENSES 18,354 18,850 496 30 6030-403-410580-356 MAINTENANCE CONTRACTS 23,818 44,000 20,182 460 6030-403-410580-357 GRANICUS 4,878 5,000 122 20 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 4,376 20,622 16,246 790 6030-403-410580-373 DUES & TRAINING 794 8,000 7,206 900 6030-403-410580-510 INSURANCE 1,469 3,000 1,531 510 6030-403-410583-218 TV -Video Equipment & programming 1,606 19,500 17,894 920 6030-403-410585-229 COPIER,FAX, SUPPLIES 6,986 19,490 12,504 640 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 57,216 78,000 20,784 270 6030-403-410585-532 COPIER LEASES 12,163 12,588 425 30 6030-403-410585-942 Servers - capital contingency 31,040 33,000 1,960 60 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,000 5,000 1000 6030-404-410588-218 COMPUTERS - ATTORNEYS 3,761 4,100 339 80 6030-405-410588-940 COMPUTERS - SWITCHES 29,319 22,200 7,119- -320 6030-406-410580-218 COURT COMPUTERS (non -capital) 40 0 40- 0% 6030-410-410588-218 COMPUTERS - DPW 3,785 5,381 1,596 300 6030-413-410588-218 COMPUTERS - POLICE DEPT 22,431 37,760 15,329 410 6030-413-410588-354 POLICE - HOSTED SERVER 1,639 1,200 439- -370 6030-416-410588-218 COMPUTERS - FIRE 3,258 8,164 4,906 600 6030-420-410588-218 COMPUTERS - PLANNING DEPT 4,099 4,125 26 to 6030-436-410588-218 COMPUTERS - PARKS 3,626 4,885 1,259 260 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 2,315 2,315 1000 TOTAL INFORMATION TECH EXPENSE 467,502 660,596 193,094 290 04.12.2018 11:09 THE CITY OF KALISPELL, MONTANA Page 35 of 35 gb8501_pg.php/Job No: 76439 USER: RGW FY18 FINANCIAL REPORT JULY 1, 2017 THRU MARCH 31, 2017 75.00 % Yr Complete For Fiscal Year: 2018 / 3 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING 'k REMAINING ACCOUNT NUMBER DESC. CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 371,786 495,000 123,214 250 6010-000-371010-000 INVESTMENT EARNINGS 892 200 692- -3460 TOTAL CENTRAL GARAGE REVENUE 372,678 495,200 122,522 250 CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 100,479 162,760 62,281 380 6010-410-431330-121 OVERTIME 2,011 2,500 489 200 6010-410-431330-153 HEALTH INSURANCE 20,410 38,931 18,521 480 6010-410-431330-155 RETIREMENT 7,324 11,880 4,556 380 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 1,037 10,000 8,963 900 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 3,914 10,700 6,786 630 6010-410-431330-230 OIL 15,490 25,000 9,510 380 6010-410-431330-231 GAS 330 2,500 2,170 870 6010-410-431330-232 VEHICLE PARTS 80,972 112,000 31,028 280 6010-410-431330-233 TIRES 20,088 41,000 20,912 510 6010-410-431330-238 FILTERS 6,148 8,500 2,352 280 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 552 2,000 1,448 720 6010-410-431330-341 ELECTRICITY 1,227 1,950 723 370 6010-410-431330-344 NATURAL GAS 3,574 6,000 2,426 400 6010-410-431330-354 CONTRACT SERVICES 26,862 26,000 862- -30 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 1,268 2,000 732 370 6010-410-431330-373 DUES & TRAINING 1,302 6,200 4,898 790 6010-410-431330-388 MEDICAL SERVICES 520 300 220- -730 6010-410-431330-510 INSURANCE 1,949 4,000 2,051 510 6010-410-431330-528 INFORMATION TECH TRANSFER 6,256 8,342 2,086 250 6010-410-431330-944 VEHICLE -SERVICE TRUCK 7,020 10,000 2,980 300 TOTAL CENTRAL GARAGE EXPENSES 308,733 492,563 183,830 370