Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
01-13-17 City Manager Report
City of Kalispell ;�. OFFICE OF THE CITY MANAGER Information Memorandum 1/13/2017 1. Parks and Recreation In December, KPR mailed letters to individuals who donated money for a potential band shell project in 2008. Individuals were given an opportunity to either receive a refund or to donate the money to electrical and cosmetic improvements to the existing pavilion. As of last week, we had heard from all but one of the original contributors. Close to 70% percent of the individuals have chosen to put their donations back towards improvements to the existing facility ($1,150.00). All refund requests have been processed. We have two cheerleading clinics in early February. The Glacier High School (GHS) Cheerleading Camp will take place on Saturday, February 4. The Flathead High School (FHS) Cheerleading Camp will take place the following week on Saturday, February 11. Both camps will offer a 3-4 hour practice and culminate with a half-time performance at a varsity basketball game later in the afternoon. For more information, please go to the following link. KPR was selected as a finalist for the 2017 Park Side Partner Program. The Park Side Partner program facilitates a cooperative environment on a local level between the credit union and other service organizations in the Flathead Valley and Missoula. The Partner Program assists in funding service projects and new initiatives in the local community. Representatives from the Recreation Department and Community Development Department presented the proposal to representatives from Park Side Credit Union at their corporate headquarters in Whitefish in early January. Parkside will inform KPR if we are selected within two weeks. This month at the Afterschool Program, our weekly themes are: Outer Space; All about Me; and Science Week, in which the children will be doing small experiments. The last week of January we have the art club from Flathead High School joining us to assist the afterschool children with various art projects. A local volunteer group has begun picking up Christmas trees on Saturdays throughout Kalispell. The group will be out January 14, 21, and 28, to collect the remaining trees. Trees need to be free of ALL ornaments, stands, tinsel, garland or other items considered decoration and placed standing up in boulevards. For additional information call 758- 7849. In 2016, 40 tree permits were issued by the Parks and Recreation Department. Tree planting lead the way with 33 permits, while 5 permits were issued for pruning/removal and 2 permits were issued for chemical treatment. The majority of planting permits were part of the City's 50/50 cost share planting program. With the recent cold weather, the parks staff has been able to flood the pond creating a smooth sheet of ice for citizens to enjoy. 2. Fire Department Since the last update, the Kalispell Fire Department has received 122 calls for service and has conducted 2 outreach trainings with approximately 60 individuals in attendance. State of Montana funding for Hazardous Materials Response Teams is likely to be modified or eliminated depending on the State budget outcomes and funding allocations. State agencies across the board are rumored to be cutting 5% from their budgets. It was relayed that Disaster and Emergency Services has placed HazMat Team funding in its entirety in the 5% cut from their overall budget. If this occurs, a reduction of functions and services will result. The potential exists to eliminate hazmat outreach, tools and equipment purchase, and monthly team trainings. Attached, you will find the year end incident response totals as compared to last year. For the year, we have trended positive with the number of overall responses by 81 calls for service. 3. Public Works Annual Bio-Solids Report The City of Kalispell Wastewater Treatment Plant maintains and operates Bio-Solids Disposal under the United States Environmental Protection Agency (EPA) Region 7 for bio-solids disposal. Annually, staff reports the amounts of bio-solids generated at the Kalispell WWTP by completing and sending in a "Bio-Solids Report Form." The report consists of production of bio-solids in dry metric tons. hi 2016, the WWTP generated 673 dry metric tons of bio-solids, 462 dry metric tons went to Glacier Gold, LLC., for composting; 87 dry metric tons went to the Flathead County Solid Waste Landfill; and the cleaning of the Secondary Digesters produced 124 dry metric tons of bio-solids disposed at the 40 Acer disposal site on Cemetery Road. The City's bio-solids disposal totals amount to the same as 2015, but continues to 2 supports the need for research of alternative disposal means through updating the "Kalispell AWWTP Bio-solids Management Plan." The City's agreement with Glacier Gold allows for disposal 600 dry metric ton, which equates to just over 3 MGD on average. Yearly Production Water and Wastewater The City records daily, monthly, and annual production and treatment quantities for water and wastewater flows. Last year 1,356 million gallons (MG) of water were produced, with an average production per day of 3.7 MG. On the flip side, 1,013 MG of wastewater was treated in 2016, with a daily average of 2.77 MGD. As a comparison, below is a table with past annual production and treatment quantities. Yearly Water Production and Wastewater Treatment Summary Year Water Production MG Wastewater Treatment MG 2016 1,356 1,013 2015 1,490 992 2014 1,230 1,043 2013 1,274 919 2012 1,263 935 2011 1,281 1,096 2010 1,242 957 2009 1,436 960 2008 11367 1,011 2007 1,474 1,017 4. City Clerk/Communications Manager The City Clerk's office recently mailed approximately 180 notices to businesses within the proposed renewal and expansion of the Business Improvement District (BID) and has been answering questions and receiving comments related to the proposed BID. The City Clerk will be attending the ten week 2017 Citizens Police Academy offered by the Kalispell Police Department beginning January 31. Articles will be produced from this experience and posted on the `notes' section of the city Facebook page to help facilitate public understanding of the issues facing the Kalispell Police and the policies and procedures they employ. 5. Building Department As of January 1, the Building Department started utilizing The Montana Transfer File Service for electronic commercial plans submittal. We expect the city website to be updated with instructions within the week. This will greatly reduce the need for storage space of large commercial plans as well as make the plan review process move a little more quickly and efficiently. 6. Planning Department The Planning Board met Tuesday, January 10 and heard 4 requests. 1) they recommended approval of South Side Estates subdivision south of Merganser Drive with a mix of 44 single family and two -unit townhouse units; 2) a request from Stillwater Corporation for Kalispell North Town Center — Phase 1, a major subdivision of 81.4 acres of land into 12 lots located in the former site of Glacier Town Center on Hwy 93 N.; 3) the Board also recommended approval of the annexation request from Stampede Packing on Airport Road adjacent to the new elementary school site; and 4) the Board recommended approval of the next phase of the B-3 Core Area Zoning beginning on 3rd Ave. EN and extending easterly to the east city limits. The Planning Board also held a work session on the KRMC Hospital PUD update. The board directed staff to bring this forward for public hearing at the next Planning Board meeting. Staff has been working with KRMC for the past 6 months to update and refine the H-1 PUD that encompasses much of the hospital property. The new PUD will serve to improve signage, parking, and access standards, as well as address setback and height provisions as the hospital campus continues to grow and evolve. 7. Information Services IT staff are preparing the computer orders for 37 computers for FY 2017 computer replacements. The City IT staff manages over 200 computers, servers, laptops and tablets for all municipal staff. 8. Police Department On January 10, the Kalispell Police Department and the Kalispell Police Association partnered with McDonald's to hold the first "Coffee or a Cone with a Cop" at the McDonalds west location in Kalispell. The event had several families attend to hear a "How to use 911" presentation by Officers Jordan Venezio and Dennis Petersen. The next "Coffee or a Cone with a Cop" will be held at the same McDonalds on February 14. Leads on Line update: The City of Kalispell currently has sixteen businesses successfully reporting to Leads on M Line per City Ordinance. Those businesses include pawn shops, jewelers and retail merchants. In the month of December, 15 Officers accessed the software. Those officers generated 44 separate logins resulting in 387 searches for stolen items or of known suspects. In November, sixteen officers accessed the software and completed 750 searches for stolen items and suspects. During November and December, the department successfully filed two Felony Common Scheme investigations involving two suspects that were pawning a large amount of stolen items. These suspects were committing multiple thefts from the Hutton Ranch area and pawning the brand new items. Information gained through Leads on Line helped us build strong Felony cases on these suspects. In the last 10 months we have recovered three stolen handguns, a generator, approximately $16,000 in stolen jewelry and multiple other items. 9. Finance Department Quarterly Finance Report Please find attached the printouts reflecting the activity for the 1st half of fiscal year 2017. This printout reflects payroll earned thru Dec. 24, 2016. All funds are included with the exception of the debt service funds. REVENUE: General Fund revenue reflects taxes collected thru December 31. Some first half taxes received by the County aren't distributed to the City until the County completes the distribution in January. The City has not yet received the January distribution. Last year, the general fund received about $612,000 of first half taxes in January. A similar distribution this January would bring collections well over 50% of the budgeted annual amount ($5,490,000). The City is currently carrying $13,412 in protest taxes in the General Fund - protest tax dollars are held by the County. Parks tax revenues should also be near 50% after the County's January distribution. Youth camps revenue, and many of the other user based parks fees, historically receives more of their revenue in the 2nd half of the fiscal year (spring). Ambulance fees for services information is incomplete for December, and therefore, only reflect fees thru November. Building department permits and fees have already exceeded the budgeted annual amounts. The approximately $1,000,000 of permits and fees collected in the first half of this fiscal year is more than twice what was collected last fiscal first half. Metered water sales thru December were $1,764,257. This is 62% of the budgeted amount, but more than $200,000 less than the extremely hot and dry fiscal year 2016 period. It is normal for July thru December metered water sales to be in excess of 50% of the annual amount because of late summer and fall sprinkling and irrigation. For a normal year comparison, fiscal year 2015 (fall 2014) 1st half metered water sales were $1,701,099; 61% of the fiscal year 2015 anticipated amount. Water impact fees have already significantly exceeded the annual budget. Sewer service charges were $2,241,630, just over half (51%) of the budgeted amount. Last year's 1st half sewer service charges were $2,281,417. Sanitary sewer (218%) and treatment plant impact fees (101%) have both exceeded the anticipated fiscal year 2017 amount. Storm Sewer and Solid Waste revenue reflect assessments billed for fiscal year 2016. Assessments collected for the storm sewer fund are about $350,000, and for the solid waste fund are just over $385,000. These amounts do not include the January distribution from the County. Both of these funds should receive over $125,000 from the January distribution of first half tax collections, bringing total collections to excess of 50% of the annual budget. Storm impact fees ($179,384) are 120% of the budgeted fiscal year 2017 amount. EXPENDITURES/EXPENSES : General Fund expenditures reflect 46% spent. Some expenditures such as liability and property insurance are paid during the first quarter for the entire year. This normally would result in 2nd half expenditures being less than 1st half. For most funds, expenditures/expenses include the 13th (of 26) payroll period ending December 24. Most departments and/or funds have at least 50% remaining in the salaries and retirement lines which should be adequate. An exception is the fire department and ambulance fund where the majority of the employees are paid 13 times annually. This 1st half report includes only 6 of 13 (47%) pay periods for these employees. Health insurance is paid 12 times per year and includes 5 months (42%) on this report. With a few exceptions, administrative, central garage, and information technology transfers are done monthly and should show 50% remaining. This is the same on the revenue side for fees for services (Central Garage), internal services (Information Technology) and administrative charges (General Fund). The general fund administrative charges may vary slightly as some charges are based on a percentage of revenues collected. Annual budgeted operating transfers are also generally done monthly or quarterly and should show 50% remaining. 0 Incident Type Comparison Report Print Date/Time: 01/11/2017 10:26 Login ID: Station: All Unit: All fire Current Year Previous Year Type of Situation Found I Year Total Year Total No incident found on arrival at 61 37 Motor vehicle accident with no i 90 110 Authorized controlled burning 6 5 Wrong location 1 1 Dispatched & canceled en route 229 171 Good intent call, other 13 31 Cover assignment, standby, moveu 2 1 Unauthorized burning 10 12 Defective elevator, no occupants 0 1 Assist invalid 36 57 Public service 15 6 Police matter 4 5 Assist police or other governmen 9 4 Public service assistance, other 22 11 Animal rescue 1 0 Smoke or odor removal 1 3 Water or steam leak 2 3 Water problem, other 2 2 Lock -out 1 0 Person in distress, other 1 1 Service Call, other 7 2 Attempt to burn 0 1 Attempted burning, illegal actio 1 2 Aircraft standby 0 1 Accident, potential accident, of 1 0 Arcing, shorted electrical equip 3 4 Power line down 15 6 Breakdown of light ballast 0 1 Overheated motor 1 4 Heat from short circuit (wiring) 0 1 Electrical wiring/equipment pro 3 5 Radioactive condition, other 0 1 Carbon monoxide incident 7 7 Chemical spill or leak 1 6 Chemical hazard (no spill or lea 0 1 Toxic condition, other 1 0 Oil or other combustible liquid 3 0 Carbon monoxide detector activat 2 3 Alarm system activation, no fire 71 44 Detector activation, no fire - u 4 4 Smoke detector activation, no fi 23 32 Extinguishing system activation 1 0 Sprinkler activation, no fire - 5 2 Unintentional transmission of al 27 32 CO detector activation due to ma 5 4 Alarm system sounded due to malf 24 23 Smoke detector activation due to 6 4 Extinguishing system malfunction 0 1 Sprinkler activation due to malf 4 0 System malfunction, other 3 1 Bomb scare - no bomb 0 1 Local alarm system, malicious fa 0 3 Malicious, mischievous false cal 3 0 Page: 1 of 2 False alarm or false call, other 63 27 HazMat release investigation w/n 6 3 EMS call, party transported by n 0 2 Smoke from barbecue, tar kettle 1 2 Steam, vapor, fog or dust though 2 1 Smoke scare, odor of smoke 28 25 Steam, other gas mistaken for sm 1 0 Citizen complaint 1 2 Special type of incident, other 1 0 Flood assessment 1 1 Medical assist, assist EMS crew 3 2 Blasting agent explosion (no fir 1 0 Air or gas rupture of pressure o 0 1 Outside equipment fire 1 1 Special outside fire, other 1 1 Dumpster or other outside trash 3 6 Garbage dump or sanitary landfil 0 1 Outside rubbish, trash or waste 2 1 Outside rubbish fire, other 1 1 Grass fire 2 2 Brush or brush -and -grass mixture 2 2 Forest, woods or wildland fire 0 2 Natural vegetation fire, other 2 1 Road freight or transport vehicl 1 0 Passenger vehicle fire 6 7 Mobile property (vehicle) fire, 4 2 Fire in portable building, fixed 1 0 Fire in motor home, camper, recr 1 2 Fire in mobile home used as fixe 3 1 Trash or rubbish fire, contained 5 3 Chimney or flue fire, confined t 2 0 Cooking fire, confined to contai 1 3 Fires in structure other than in 1 0 Building fire 16 19 Fire, other 4 6 Gas leak (natural gas or LPG) 40 55 Gasoline or other flammable liqu 9 3 Combustible/flammable gas/liquid 1 0 Hazardous condition, other 3 0 Rescue or EMS standby 0 2 Extrication of victim(s) from ma 0 2 Removal of victim(s) from stalle 2 0 Motor vehicle/pedestrian acciden 13 11 Motor vehicle accident with inju 64 66 EMS call, excluding vehicle acci 2301 2348 Emergency medical service, other 35 12 Unknown Incident Type 2 0 Grand Totals: 3364 3283 Page: 2 of 2 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Pagel of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 2,271,210 5,490,000 3,218,790 59% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 8,626 17,000 8,374 49% 1000-000-311200-000 PERSONAL PROPERTY TAXES 136,466 120,000 16,466- -14% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 2,711 8,000 5,289 66% 1000-000-322101-000 LIQUOR LICENSES 27 30,000 29,973 100% 1000-000-322300-000 BUSINESS LICENSES 759 1,700 941 55% 1000-000-323012-000 PLANNING FEES 35,647 30,000 5,647- -19% 1000-000-323109-000 SITE REVIEW 7,490 14,000 6,510 47% 1000-000-323200-000 PARADE PERMITS 450 1,000 550 55% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 2,000 2,000 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 56,300 60, 000 3,700 6% 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,000 2,000 1,000 50% 1000-000-335230-000 HB124 ENTITLEMENT 1,386,914 2,773,829 1,386,915 50% 1000-000-341020-000 ADMINISTRATIVE CHARGES 280,938 574,367 293,429 51% 1000-000-341021-000 GRANT ADMIN FEES 0 5,000 5,000 100% 1000-000-341025-000 CITY COLLECTIONS 247 5,000 4,753 95% 1000-000-342010-000 POLICE SERVICES 22,275 25,000 2,725 11% 1000-000-342014-000 RESOURCE OFFICERS 149,037 149,037 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 1,031 10,000 8,969 90% 1000-000-343018-000 PARKING PERMITS 47,163 95,000 47,837 50% 1000-000-351000-000 CITY COURT FINES & FEES 150,468 500,000 349,532 70% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 8,943 30,000 21,057 70% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 18,518 35,000 16,482 47% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 7,944 20,000 12,056 60% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 1,484 7,500 6,016 80% 1000-000-365018-000 BANDSHELL CONTRIBUTIONS 450- 0 450 0% 1000-000-371010-000 INVESTMENT EARNINGS 8,284 15,000 6,716 45% 1000-000-373030-000 INTEREST ON OLD SCHOOL SID LOAN - 1 0 16,250 16,250 100% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 450,500 901,000 450,500 50% TOTAL GENERAL FUND REVENUE 5,053,980 10, 937, 683 5,883,703 54% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 2 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 0 2,935 2,935 100% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 3,900 14,250 10,350 73% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 1,467 4,000 2,533 63% 1000-400-410560-312 POSTAGE 5,668 16, 000 10,332 65% 1000-400-410560-320 PRINTING & ENVELOPES 1,669 4,500 2,831 63% 1000-400-410560-354 CONTRACT SERVICES - DOC SHREDDING 123 500 378 76% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 622 4,000 3,378 84% 1000-400-420000-354 CONTRACT 911 CENTER 236,402 483,000 246,598 51% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 378 425 47 11% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 0 15,000 15,000 100% 1000-400-460452-366 HOCKADAY MAINTENANCE 0 6, 600 6,600 100% 1000-400-510300-000 CONTINGENCY 882 30,000 29,118 97% 1000-400-510310-354 ICMA PLAN FEES 250 500 250 50% 1000-400-510330-513 LIABILITY INSURANCE 61,925 61, 925 0 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 18,137 50,000 31,863 64% 1000-400-510330-517 PROPERTY INSURANCE 49,965 49, 965 0 0% SUBTOTAL GEN.GOV'T. 381,388 743,600 362,212 49% CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER&439;S OFFICE 1000-401-410210-153 HEALTH INSURANCE 1000-401-410210-155 RETIREMENT 1000-401-410210-210 COMPUTER SOFTWARE/SUPPLIES 1000-401-410210-312 NEWSLETTER/BOOKS 1000-401-410210-345 TELEPHONE & COMMUNICATION 1000-401-410210-373 DUES & TRAINING 1000-401-410210-379 MEETINGS SUBTOTAL CITY MANAGER HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 1000-401-410830-153 HEALTH INSURANCE 1000-401-410830-155 RETIREMENT 1000-401-410830-210 OFFICE SUPPLIES 1000-401-410830-338 RECRUITMENT/RELOCATION 1000-401-410830-354 CONTRACT SERVICES 1000-401-410830-373 DUES & TRAINING SUBTOTAL HUMAN RESOURCES 63,494 137, 795 74,301 54% 9,355 22, 706 13,351 59% 6,876 14, 569 7,693 53% 0 1,500 1,500 100% 0 400 400 100% 400 1,080 680 63% 2,670 8,300 5,630 68% 1,000 3,400 2,400 71% 83,795 189,750 105,955 56% 59,055 123, 814 64,759 52% 8,039 19, 565 11,526 59% 4,570 9,466 4,896 52% 154 600 446 74% 2,249 8,000 5,751 72% 260 1, 000 740 74% 5,235 6,000 765 13% 79,562 168,445 88,883 53% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 3 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 30,335 63, 107 32,772 52% 1000-402-410100-153 HEALTH INSURANCE 23,800 57, 698 33,898 59% 1000-402-410100-155 RETIREMENT 1,203 2,445 1,242 51% 1000-402-410100-210 OFFICE SUPPLIES 0 100 100 100% 1000-402-410100-335 MT LEAGUE OF CITIES 2,145 5, 760 3,615 63% 1000-402-410100-354 CONTRACT SERVICES 1,766 4,500 2,734 61% 1000-402-410100-373 DUES & TRAINING 6,576 6, 000 576- -10% 1000-402-410100-379 MEETINGS 12 8,000 7,988 100% SUBTOTAL MAYOR/COUNCIL 65,837 147, 610 81,773 55% CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 42,291 88,953 46,662 52% 1000-402-410150-121 OVERTIME 0 250 250 100% 1000-402-410150-153 HEALTH INSURANCE 8,297 20,261 11,964 59% 1000-402-410150-155 RETIREMENT 3,280 6, 832 3,552 52% 1000-402-410150-210 OFFICE SUPPLIES 0 200 200 100% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 0 700 700 100% 1000-402-410150-345 TELEPHONE & COPM4UNICATION 200 480 280 58% 1000-402-410150-352 RECODIFICATION 3,054 3,700 646 17% 1000-402-410150-354 CONTRACT SERVICES 0 300 300 100% 1000-402-410150-373 DUES & TRAINING 360 3,200 2,840 89% SUBTOTAL CITY CLERK 57,483 124, 876 67,394 54% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 98,548 210,200 111,652 53% 1000-403-410550-153 HEALTH INSURANCE 16,054 38,445 22,391 58% 1000-403-410550-155 RETIREMENT 7,626 16,121 8,495 53% 1000-403-410550-210 SUPPLIES 0 300 300 100% 1000-403-410550-322 BOOKS 0 250 250 100% 1000-403-410550-353 CONTRACT SERVICES 60 2,000 1,940 97% 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 638 2,000 1,362 68% 1000-403-410550-355 BANK CHARGES & FEES 1,571 3,500 1,929 SS% 1000-403-410550-373 DUES & TRAINING 1,870 6, 500 4,630 71% SUBTOTAL FINANCE 126,367 279,316 152,949 55% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 4 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 174,121 364, 724 190,603 52% 1000-404-411110-153 HEALTH INSURANCE 21,612 52,592 30,980 59% 1000-404-411110-155 RETIREMENT 13,469 29, 906 16,437 55% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 568 2,500 1,932 77% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 6,106 8,000 1,894 24% 1000-404-411110-345 TELEPHONE & COMMMUNICATION 519 1,000 481 48% 1000-404-411110-354 CONTRACT SERVICES 95 5,000 4,905 98% 1000-404-411110-373 DUES & TRAINING 3,704 7,000 3,296 47% SUBTOTAL CITY ATTORNEY 220,195 470,722 250,527 53% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 108,061 226, 938 118,877 52% 1000-406-410360-121 OVERTIME 13 0 13- 0% 1000-406-410360-153 HEALTH INSURANCE 21,150 51, 568 30,418 59% 1000-406-410360-155 RETIREMENT 8,351 17,373 9,022 52% 1000-406-410360-210 SUPPLIES 1,499 4,500 3,001 67% 1000-406-410360-320 PRINTING/BOOKS 112 1,500 1,388 93% 1000-406-410360-345 TELEPHONE & COMMUNICATION 37 1,400 1,363 97% 1000-406-410360-353 SECURITY & TECHNOLOGY 3,959 40,000 36,041 90% 1000-406-410360-354 CONTRACT SERVICES 3,084 5,750 2,666 46% 1000-406-410360-373 DUES & TRAINING 1,195 6,300 5,105 81% 1000-406-410360-394 JURY & WITNESS FEES 773 7,500 6,727 90% SUBTOTAL COURT 148,233 362, 829 214,596 59% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 8,332 17,333 9,001 52% 1000-410-430100-153 HEALTH INSURANCE 1,305 3,278 1,973 60% 1000-410-430100-155 RETIREMENT 637 1,300 663 51% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 3,934 7,500 3,566 48% 1000-410-430100-231 GAS 1,188 2,500 1,312 52% 1000-410-430100-345 TELEPHONE & COMMMUNICATION 153 300 147 49% 1000-410-430100-354 CONTRACT SERVICES 1,680 1,850 170 9% 1000-410-430100-373 DUES & TRAINING 1,259 2,500 1,241 50% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 1,730 3,459 1,730 50% SUBTOTAL PUBLIC WORKS ADMIN 20,218 40,020 19,802 49% CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 31,804 67, 873 36,069 53% 1000-412-411230-121 OVERTIME 514 0 514- 0% 1000-412-411230-153 HEALTH INSURANCE 5,496 15,847 10,351 65% 1000-412-411230-155 RETIREMENT 2,407 4,980 2,573 52% 1000-412-411230-220 SECURITY IMPROVEMENTS 0 800 800 100% 1000-412-411230-224 JANITORIAL SUPPLIES 1,514 6, 000 4,486 75% 1000-412-411230-241 TOOLS & SUPPLIES 289 1,500 1,211 81% 1000-412-411230-341 ELECTRICITY 20,223 47,500 27,277 57% 1000-412-411230-344 NATURAL GAS 10,936 40,000 29,064 73% 1000-412-411230-345 TELEPHONE & COMMUNICATION 66 250 184 74% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 5 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-354 CONTRACT SERVICES 6,074 38,500 32,426 84% 1000-412-411230-355 HVAC MAINTENANCE OCNTRACT 15,146 17,300 2,154 12% 1000-412-411230-361 ELEVATOR MAINT/ FIRE ALARM MAINT 488 4,500 4,012 89% 1000-412-411230-362 EQUIPMENT MAINTENANCE 1,460 8,500 7,040 83% 1000-412-411230-366 BUILDING MAINTENANCE 8,531 20,000 11,469 57% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,007 3,500 493 14% 1000-412-411230-920 Public Safety Bldg - painting 12,303 30,000 17,697 59% SUBTOTAL CITY HALL 120,258 307,050 186,792 61% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 131,475 274, 862 143,387 52% 1000-420-411020-153 HEALTH INSURANCE 23,396 59,495 36,099 61% 1000-420-411020-155 RETIREMENT 10,182 21,071 10,889 52% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 368 5,000 4,632 93% 1000-420-411020-231 GAS 78 400 322 81% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 476 2,000 1,524 76% 1000-420-411020-345 TELEPHONE 586 750 164 22% 1000-420-411020-354 CONTRACT SERVICES 0 1,000 1,000 100% 1000-420-411020-373 DUES & TRAINING 919 5,500 4,581 83% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 648 1,295 647 50% SUBTOTAL PLANNING DEPT. 168,126 371,373 203,247 55% 480 COMMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 29,558 61, 676 32,118 52% 1000-480-470210-153 HEALTH INSURANCE 3,400 8,243 4,843 59% 1000-480-470210-155 RETIREMENT 2,285 4,704 2,419 51% 1000-480-470210-210 OFFICE SUPPLIES 0 1,500 1,500 100% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 392 500 108 22% 1000-480-470210-312 POSTAGE & PRINTING 49 500 451 90% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 0 500 500 100% 1000-480-470210-345 TELEPHONE/COPM4UNICATIONS 362 750 388 52% 1000-480-470210-354 CONTRACT SERVICES 265 1,500 1,235 82% 1000-480-470210-373 DUES & TRAINING 2,719 5,000 2,281 46% 1000-480-470210-379 MEETINGS 220 1,000 780 78% SUBTOTAL COMMUNITY DEVELOPMENT 39,249 85,873 46,624 54% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 6 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 1,006,794 2,114,612 1,107,818 52% 1000-413-420140-112 SALARIES -SEVERANCE 31,782 33,500 1,718 5% 1000-413-420140-114 SALARY -comptime buyout 4,445 4,350 95- -2% 1000-413-420140-121 OVERTIME (REG & AET OT) 39,857 80,000 40,143 50% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 3,266 25,000 21,734 87% 1000-413-420140-153 HEALTH INSURANCE 172,487 413, 628 241,141 58% 1000-413-420140-155 RETIREMENT 129,753 275,152 145,399 53% 1000-413-420140-210 OFFICE SUPPLIES 1,686 3,500 1,814 52% 1000-413-420140-215 COMPUTER SUPPLIES 554 5,500 4,946 90% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 36,017 48,500 12,483 26% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 1,715 4,000 2,285 57% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 4,829 7,000 2,171 31% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 91 2,000 1,909 95% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 4,542 5,000 458 9% 1000-413-420140-227 AMMO & RELATED SUPPLIES 10,917 19,000 8,083 43% 1000-413-420140-228 PATROL CAR SUPPLIES 2,421 13,000 10,579 81% 1000-413-420140-229 OTHER SUPPLIES 4,484 10,000 5,516 55% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 204 1,000 796 80% 1000-413-420140-231 GAS 25,393 95,000 69,607 73% 1000-413-420140-234 CRISIS NEGOTIATIONS 1,171 2,000 829 41% 1000-413-420140-235 BIKE PATROL 244 750 506 67% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 0 1,500 1,500 100% 1000-413-420140-320 PRINTING 1,602 5,500 3,898 71% 1000-413-420140-345 TELEPHONE & COPM4UNICATION 8,584 15,500 6,916 45% 1000-413-420140-354 CONTRACT SERVICES 4,952 6, 875 1,923 28% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 2,979 6, 500 3,521 54% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 90 2,000 1,910 96% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 2,258 2,000 258- -13% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 34,797 40, 625 5,828 14% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 856 2,500 1,644 66% 1000-413-420140-373 DUES & TRAINING 24,288 30,000 5,712 19% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 1,031 10,000 8,969 90% 1000-413-420140-380 TRAINING MATERIALS 69 2,000 1,931 97% 1000-413-420140-388 MEDICAL SERVICES 1,845 2,500 655 26% 1000-413-420140-392 BOARDING/TREATING PRISONERS 1,660 2,500 841 34% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 36,859 73,718 36,859 50% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 33,750 67, 500 33,750 50% 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 77,500 155,000 77,500 50% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 1,750 3,500 1,750 50% 1000-413-420140-922 USFS PROPERTY ACQUISITION 0 27,482 27,482 100% 1000-413-420140-944 VEHICLES 108,131 115,878 7,747 7% SUBTOTAL POLICE DEPT. 1,825,653 3,735,570 1,909,917 51% DETECTIVES 1000-413-420141-110 SALARIES -DETECTIVES 1000-413-420141-121 DETECTIVE -OVERTIME 1000-413-420141-153 HEALTH INSURANCE 1000-413-420141-155 DETECTIVE -RETIREMENT TOTAL DETECTIVES RECORDS 166,710 365, 552 198,842 54% 2,936 15,000 12,064 80% 29,845 66,611 36,766 55% 21,818 48,938 27,120 55% 221,308 496,101 274,793 55% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 7 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-110 SALARIES -RECORDS DIVISION 67,232 142,039 74,807 53% 1000-413-420142-121 OVERTIME 1,456 7,500 6,044 81% 1000-413-420142-153 HEALTH INSURANCE 13,301 32,970 19,669 60% 1000-413-420142-155 RETIREMENT 5,238 10,720 5,482 51% 1000-413-420142-215 COMPUTER SUPPLIES 216 0 216- 0% TOTAL RECORDS 87,442 193,229 105,787 55% RESOURCE OFFICERS 1000-413-420144-110 SALARIES -SRO 83,656 182,257 98,601 54% 1000-413-420144-153 HEALTH INSURANCE 15,198 46, 773 31,575 68% 1000-413-420144-155 SRO RETIREMENT 10,251 24,447 14,196 58% TOTAL RESOURCE OFFICERS 109,105 253,477 144,372 57% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL -SALARIES 20,086 38,723 18,637 48% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 3,400 8,243 4,843 59% 1000-413-420145-155 RETIREMENT 1,451 2,920 1,469 50% SUBTOTAL ANIMAL CONTROL 24,938 50,386 25,448 51% PARKING 1000-413-420147-110 PARKINGS -SALARIES 42,339 86,114 43,775 51% 1000-413-420147-153 HEALTH INSURANCE 10,575 30,585 20,010 65% 1000-413-420147-155 RETIREMENT 3,173 6,494 3,321 51% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 0 4,000 4,000 100% 1000-413-420147-354 CONTRACTED SERVICES 73 2,000 1,927 96% 1000-413-420147-362 LOT MAINT 3,333 10,000 6,667 67% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 0 17,500 17,500 100% 1000-413-420147-550 LOT LEASE PAYMENTS 673 1,500 827 SS% SUBTOTAL PARKING 60,166 158,193 98,027 62% SUBTOTAL POLICE DEPT. 2,328,612 4, 886, 956 2,558,344 52% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 8 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. FIRE DEPARTMENT 1000-416-420400-110 SALARIES -FIRE SUPPRESSION 713,392 1,592,324 878,932 55% 1000-416-420400-114 COMPTIME BUYOUT 3,784 5,500 1,716 31% 1000-416-420400-115 OUT OF RANK PAY 6,464 12,000 5,536 46% 1000-416-420400-121 OVERTIME 34,935 40,000 5,065 13% 1000-416-420400-153 HEALTH INSURANCE 116,807 312,701 195,894 63% 1000-416-420400-155 RETIREMENT 96,164 212, 650 116,486 SS% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 103 2,000 1,897 95% 1000-416-420400-218 Equipment (Non Capital) 1,502 21,500 19,998 93% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 12,195 15,000 2,805 19% 1000-416-420400-224 JANITORIAL SUPPLIES 1,730 5,000 3,270 65% 1000-416-420400-231 GAS 3,545 17,325 13,780 80% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 4,235 15,000 10,765 72% 1000-416-420400-320 PRINTING 0 200 200 100% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 275 1,000 725 73% 1000-416-420400-345 TELEPHONE & COMMUNICATION 2,332 6, 000 3,668 61% 1000-416-420400-354 CONTRACT SERVICES 7,380 12,000 4,621 39% 1000-416-420400-362 EQUIPMENT MAINTENANCE 5,862 5,500 362- -7% 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 1,985 7,500 5,515 74% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 2,890 5,000 2,110 42% 1000-416-420400-373 DUES & TRAINING 3,219 10,000 6,781 68% 1000-416-420400-388 FIREFIGHTER PHYSICALS 610 25,875 25,265 98% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 21,969 43,938 21,969 50% 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 0 40,000 40,000 100% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 75,000 150,000 75,000 50% 1000-416-420400-821 TRANSFER TO FUND 2956 GRANT MATCH 0 18,454 18,454 100% 1000-416-420400-922 USFS PROPERTY ACQUISITION 0 27,482 27,482 100% 1000-416-420400-940 CAPITAL EQUIPMENT - COMMAND VEHICLE 35,849 35,000 849- -2% 1000-416-420440-110 SALARIES -FIRE PREVENTION 23,729 51,287 27,558 54% 1000-416-420440-114 COMPTIME BUYOUT 325 0 325- 0% 1000-416-420440-121 OVERTIME 3,626 0 3,626- 0% 1000-416-420440-153 HEALTH INSURANCE 3,504 7, 826 4,322 SS% 1000-416-420440-155 RETIREMENT 2,018 3, 697 1,679 45% SUBTOTAL FIRE DEPT. 1,185,425 2,701,759 1,516,334 56% GRAND TOTAL GENERAL FUND 5.024.748 10.880.179 5.855.431 54% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 9 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. SPECIAL REVENUE FUNDS: 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 1,600 1, 600 0 0% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 4,622 9,243 4,621 50% 2185-000-430300-840 REDEVELOPMENT ACTIVITY 0 1,750,000 1,750,000 100% 2185-480-470240-110 SALARIES 9,344 20,256 10,912 54% 2185-480-470240-153 HEALTH INSURANCE 1,190 2,935 1,745 59% 2185-480-470240-155 RETIREMENT 722 1, 526 804 53% 2185-480-470240-345 TELEPHONE & COMMUNICATION 24 48 24 50% TOTAL AIRPORT TIF 17,502 1, 785, 608 1,768,106 99% 2188 WESTSIDE TIF 2188-480-470230-110 SALARIES 20,034 43,983 23,949 54% 2188-480-470230-153 HEALTH INSURANCE 2,210 5,558 3,348 60% 2188-480-470230-155 RETIREMENT 1,549 3,337 1,788 54% 2188-480-470230-353 AUDIT 2,000 2,000 0 0% 2188-480-470230-354 TO PORT/GATEWAY W. BLDG MAINT. 0 5,000 5,000 100% 2188-480-470230-356 TELEPHONE 96 0 96- 0% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 1,732 3,464 1,732 50% 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 4,000 0 4,000- 0% 2188-480-470230-840 TRANSFER TO DEBT SERVICE 16,170 32,340 16,170 50% 2188-480-470240-720 PRE AWARD TIGER 50,357 4,000,000 3,949,643 99% TOTAL WESTSIDE TIF 98,148 4, 095, 682 3,997,534 98% OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 10,841 11,500 659 6% 2310-480-470210-356 FED -EX REIMBURSEMENT 10,282 11,000 718 7% 2310-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 17,500 35,000 17,500 50% 2311-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 7,500 15,000 7,500 50% TOTAL OLD SCHOOL TIFS 46,123 72,500 26,377 36% PERMISSIVE HEALTH LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND 496,000 992,000 496,000 50% TOTAL PERMISSIVE HEALTH LEVY 496,000 992,000 496,000 50% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 10 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2399 PUBLIC SAFETY IMPACT FEES 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 0 10,000 10,000 100% 2399-413-420140-940 POLICE EQUIPMENT 0 60, 000 60,000 100% 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 32,500 65, 500 33,000 50% 2399-416-420400-620 INTEREST - FIRE TRUCK 2,672 4, 651 1,979 43% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 500,000 500,000 100% TOTAL PUBLIC SAFETY IMPACT FEE 35,172 640, 151 604,979 95% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 11 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 344,450 970,000 625,550 64% 2215-000-311200-000 PERSONAL PROPERTY TAXES 29,108 35,000 5,892 17% 2215-000-312000-000 PEN & INTEREST DEL TAXES 404 2,000 1,596 80% 2215-000-346030-000 SWIMMING POOL FEES 70,545 140,000 69,455 50% 2215-000-346040-000 CONCESSION STAND REVENUE 25,103 35,000 9,897 28% 2215-000-346050-000 PARKS USAGE FEES 7,399 21,000 13,601 65% 2215-000-346051-000 RECREATION FEES 2,086 8,000 5,914 74% 2215-000-346052-000 SPORTS PROGRAMS 10,330 45,000 34,670 77% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 189 2,500 2,311 92% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 33,687 70,000 36,313 52% 2215-000-346055-000 ICE RINK 7,029 25,000 17,971 72% 2215-000-346056-000 KIDSPORT USAGE 177 300 123 41% 2215-000-346057-000 YOUTH CAMPS 8,747 142,000 133,253 94% 2215-000-346059-000 PICNIC IN THE PARK 1,842 30,000 28,158 94% 2215-000-365010-000 FEC REFUNDS/DONATIONS 4,505 0 4,505- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-371010-000 INVESTMENTS 1,516 2,000 484 24% 2215-000-381050-000 INCEPTION OF LEASE 22,199 130,000 107,801 83% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 45,500 91,000 45,500 50% TOTAL PARKS & REC REVENUE 614,818 1, 768, 800 1,153,982 65% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 150,341 316, 192 165,851 52% 2215-436-460430-111 SEASONAL SALARIES 34,758 65,276 30,518 47% 2215-436-460430-121 OVERTIME 0 500 500 100% 2215-436-460430-153 HEALTH INSURANCE 25,343 61, 643 36,300 59% 2215-436-460430-155 RETIREMENT 12,934 26, 136 13,202 51% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 138 1,000 862 86% 2215-436-460430-224 JANITORIAL SUPPLIES 3,118 5,000 1,882 38% 2215-436-460430-229 OTHER SUPPLIES 1,929 4,000 2,071 52% 2215-436-460430-231 GAS 6,646 18,000 11,354 63% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 26 2,500 2,474 99% 2215-436-460430-320 PRINTING & ADVERTISING 169 400 231 58% 2215-436-460430-341 ELECTRICITY 7,270 16, 000 8,730 SS% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 7,280 25,000 17,720 71% 2215-436-460430-344 NATURAL GAS 697 3,000 2,303 77% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 1,232 3,040 1,808 59% 2215-436-460430-351 TENNIS COURT REHABILITATION 0 2,000 2,000 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 2,000 2,000 100% 2215-436-460430-355 CONTRACT SERV.- TRAIL MAINT. 160 5,000 4,840 97% 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 0 2, 680 2,680 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 1,540 5,000 3,460 69% 2215-436-460430-364 LANDSCAPING 2,403 5,500 3,097 56% 2215-436-460430-367 VANDALISM REPAIRS 3,639 4,000 361 9% 2215-436-460430-373 DUES & TRAINING 4,282 6, 000 1,718 29% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 100 600 500 83% 2215-436-460430-395 EQUIPMENT RENTAL 301 500 200 40% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 0 3,000 3,000 100% 2215-436-460430-440 IRRIGATION SUPPLIES 1.741 9.000 7.259 81% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 12 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 569 1,700 1,131 67% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 21,929 43,857 21,929 50% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 4,542 29,112 24,570 84% 2215-436-460430-620 DEBT SERVICE INTEREST 141 784 643 82% 2215-436-460430-941 CAPITAL OUTLAY: FLATBED, MOWER, WOO 22,391 130,000 107,609 83% 2215-436-460430-942 FVCC TENNIS INTERLOCAL AGREEMENT 0 7,000 7,000 100% SUBTOTAL PARKS EXPENDITURES 315,616 805,420 489,804 61% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 2215-436-460440-111 SEASONAL SALARIES 2215-436-460440-153 HEALTH INSURANCE 2215-436-460440-155 RETIREMENT 2215-436-460440-221 SAFETY EQUIPMENT 2215-436-460440-229 OTHER SUPPLIES 2215-436-460440-231 GAS 2215-436-460440-241 CONSUMABLE TOOLS 2215-436-460440-341 ELECTRICITY 2215-436-460440-345 TELEPHONE & COPM4UNICATION 2215-436-460440-354 CONTRACT SERVICES 2215-436-460440-355 CONTRACT SERVICES - ASPHALT RESURFC 2215-436-460440-362 EQUIPMENT MAINTENANCE 2215-436-460440-364 LANDSCAPING 2215-436-460440-367 VANDALISM REPAIRS 2215-436-460440-373 DUES & TRAINING 2215-436-460440-395 RENTAL EQUIPMENT 2215-436-460440-420 METAL PRODUCTS 2215-436-460440-440 IRRIGATION 2215-436-460440-452 SAND & GRAVEL 2215-436-460440-940 EQUIPMENT SUBTOTAL ATHLETIC COMPLEX 26,253 89, 153 62,900 71% 29,594 41, 906 12,312 29% 5,231 25,922 20,691 80% 3,747 10, 046 6,299 63% 0 350 350 100% 4,922 15, 500 10,578 68% 3,183 10,500 7,317 70% 1,222 1,500 278 19% 3,984 7, 700 3,716 48% 73 175 102 58% 0 1,000 1,000 100% 42,274 40,534 1,740- -4% 64 600 536 89% 0 600 600 100% 300 500 200 40% 0 500 500 100% 0 150 150 100% 0 300 300 100% 2,591 4,000 1,409 35% 0 1,000 1,000 100% 0 24,000 24,000 100% 123,437 275,936 152,499 55% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 38,456 81, 678 43,222 53% 2215-436-460431-111 SEASONAL SALARIES 2,271 8,285 6,014 73% 2215-436-460431-153 HEALTH INSURANCE 8,175 23, 906 15,731 66% 2215-436-460431-155 RETIREMENT 2,951 6, 705 3,754 56% 2215-436-460431-229 MISC. SUPPLIES 2,350 9,435 7,085 75% 2215-436-460431-231 GAS 481 590 109 18% 2215-436-460431-320 PRINTING & ADVERTISING 0 10,800 10,800 100% 2215-436-460431-345 TELEPHONE & COPM4UNICATION 382 1,661 1,279 77% 2215-436-460431-354 CONTRACT SERVICES 16,850 19,093 2,243 12% 2215-436-460431-357 MUSIC FRANCHISE FEES 734 1,100 366 33% 2215-436-460431-373 DUES & TRAINING 292 728 436 60% SUBTOTAL RECREATION 72,942 163,981 91,039 56% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 34,182 72,793 38,611 53% 2215-436-460448-111 SEASONAL SALARIES 68,107 136, 855 68,748 50% 2215-436-460448-121 OVERTIME 0 300 300 100% 2215-436-460448-153 HEALTH INSURANCE 7.694 22.953 15.259 66% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 13 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460448-155 RETIREMENT 2,621 6,424 3,803 59% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 186 400 214 54% 2215-436-460448-229 MISC. SUPPLIES 812 3, 600 2,788 77% 2215-436-460448-231 GAS 122 300 178 59% 2215-436-460448-320 PRINTING & ADVERTISING 0 100 100 100% 2215-436-460448-345 TELEPHONE & COPM4UNICATION 553 765 212 28% 2215-436-460448-354 CONTRACT SERVICES 8,450 13,000 4,550 35% 2215-436-460448-355 AFTER SCHOOL PROGRAM 347 800 453 57% 2215-436-460448-356 BANK FEES/CC CHARGES 1,101 3,900 2,799 72% 2215-436-460448-373 DUES & TRAINING 483 800 317 40% SUBTOTAL YOUTH CAMPS 124,657 262, 990 138,333 53% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 116,959 190,325 73,366 39% 2215-437-460445-112 SEVERANCE 0 2,535 2,535 100% 2215-437-460445-121 OVERTIME 187 500 313 63% 2215-437-460445-155 RETIREMENT 929 1,500 571 38% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 0 400 400 100% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 2,138 2,200 62 3% 2215-437-460445-226 CHLORINE/CHEMICALS 17,205 25,000 7,795 31% 2215-437-460445-228 CONCESSION STAND SUPPLIES 9,890 21,000 11,110 53% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 908 4,500 3,592 80% 2215-437-460445-341 ELECTRICITY 4,646 9,500 4,854 51% 2215-437-460445-344 NATURAL GAS 13,350 25,000 11,650 47% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 792 1, 620 828 51% 2215-437-460445-354 LICENSES & FEES 590 1,300 710 55% 2215-437-460445-356 BANK FEES/ CC CHARGES 1,157 1,200 43 4% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 2,984 14, 600 11,616 80% 2215-437-460445-380 TRAINING MATERIALS 175 1,800 1,625 90% SUBTOTAL POOL EXPENDITURES 171,910 302,980 131,070 43% TOTAL PARKS & RECREATION/POOL 808,561 1,811,307 1,002,746 55% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 14 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FORESTRY & DEVELOPER TREES 2600-436-460433-110 SALARIES -URBAN FORESTRY 46,939 107,421 60,482 56% 2600-436-460433-111 SEASONAL SERVICES 5,068 25,731 20,663 80% 2600-436-460433-121 OVERTIME 0 300 300 100% 2600-436-460433-153 HEALTH INSURANCE 8,611 24, 764 16,153 65% 2600-436-460433-155 RETIREMENT 3,583 9,713 6,130 63% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 41 600 559 93% 2600-436-460433-231 GAS 497 4,500 4,003 89% 2600-436-460433-241 CONSUMABLE TOOLS 1,444 4,500 3,056 68% 2600-436-460433-354 CONTRACT SERVICES 13,000 35,000 22,000 63% 2600-436-460433-357 FORESTRY GRANT 0 11,880 11,880 100% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 1,650 6, 750 5,100 76% 2600-436-460433-362 EQUIPMENT MAINTENANCE 232 4,000 3,768 94% 2600-436-460433-364 LANDSCAPING & TREES 1,634 8,000 6,366 80% 2600-436-460433-373 DUES & TRAINING 1,830 2,000 170 9% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 628 628 0 0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 3,684 7,368 3,684 50% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 4,136 8,272 4,136 50% 2600-436-460433-528 DATA PROCESSING TRANSFER 2,085 4,171 2,086 50% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 5,419 15,000 9,581 64% 2600-436-460433-620 INTEREST EXPENSE 374 1,000 626 63% 2600-436-460433-940 MACHINERY & EQUIPMENT 0 40,000 40,000 100% TOTAL URBAN FORESTRY 100,854 321,598 220,744 69% 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 TOTAL DEVELOPER TREES 2210 PARKS IN LIEU 2210-436-460430-934 CAPITAL IMPROVEMENTS TOTAL PARKS IN LIEU 0 8, 653 8,653 100% 0 4,336 4,336 100% 0 366 366 100% 0 11,231 11,231 100% 0 667 667 100% 0 1,928 1,928 100% 650 16,236 15,586 96% 0 27,079 27,079 100% 1,950 2,219 269 12% 0 948 948 100% 0 1,390 1,390 100% 650 1,134 484 43% 0 2,797 2,797 100% 0 8,490 8,490 100% 0 2, 716 2,716 100% 0 8,812 8,812 100% 3,250 99,002 95,752 97% 0 1,417 1,417 100% 0 1,417 1,417 100% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 15 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 301,032 891,000 589,968 66% 2230-000-342070-000 COUNTY EMS LEVY 0 110,000 110,000 100% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 75,000 150,000 75,000 50% TOTAL AMBULANCE REVENUE 376,032 1,151,000 774,968 67% AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 273,184 608,459 335,275 55% 2230-440-420730-114 COMPTIME BUYBACK 2,168 3,500 1,332 38% 2230-440-420730-115 OUT OF RANK PAY 745 1,000 255 26% 2230-440-420730-121 OVERTIME 23,749 50,000 26,251 53% 2230-440-420730-153 HEALTH INSURANCE 60,136 159,142 99,006 62% 2230-440-420730-155 RETIREMENT 37,236 80,552 43,316 54% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 210 1,000 790 79% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 0 4,000 4,000 100% 2230-440-420730-231 GAS k OIL 2,918 7, 560 4,642 61% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 0 4,000 4,000 100% 2230-440-420730-312 POSTAGE/PRINTING 0 1,500 1,500 100% 2230-440-420730-345 TELEPHONE k COPM4UNICATION 758 1,200 442 37% 2230-440-420730-354 CONTRACT SERVICES 7,177 17,800 10,623 60% 2230-440-420730-355 911 CENTER CONTRIBUTION 17,000 34,000 17,000 50% 2230-440-420730-359 AUDIT/CC OTHER FEES 1,214 1,400 186 13% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 0 5,000 5,000 100% 2230-440-420730-373 DUES k TRAINING 1,642 5,000 3,358 67% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,500 2,500 100% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 11,489 46, 000 34,511 75% 2230-440-420730-510 PROPERTY k LIABILITY INSURANCE 7,614 7, 614 0 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 8,114 16,229 8,115 50% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 21,049 42,099 21,050 50% 2230-440-420730-528 DATA PROCESSING TRANSFER 8,342 16, 684 8,342 50% 2230-440-420730-940 EQUIPMENT 166,787 170,000 3,213 2% TOTAL AMBULANCE EXPENDITURES 651,533 1,286,239 634,706 49% FIRE k HAZMAT GRANTS 2956-416-420400-218 EQUIPMENT (NON CAPITAL) 0 2,200 2,200 100% 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 2,685 3,000 315 10% 2956-416-420415-940 AFG GRT (POWER COTS) EMW2014FOO5022 0 225,000 225,000 100% TOTAL FIRE GRANTS 2,685 230,200 227,515 99% 2957-416-420400-155 RETIREMENT 0 2,500 2,500 100% 2957-416-420410-125 PASS THRU HAZMAT OT 4,879 19,365 14,486 75% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 15,507 33,113 17,606 53% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 1,486 6, 100 4,614 76% TOTAL HAZMAT GRANTS 21,871 61,078 39,207 64% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 16 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 597,319 350,000 247,319- -71% 2394-000-323103-000 PLUMBING PERMITS 19,260 20,000 740 4% 2394-000-323104-000 MECHANICAL PERMITS 20,518 30,000 9,483 32% 2394-000-323105-000 ELECTRICAL PERMITS 50,753 30,000 20,753- -69% 2394-000-323108-000 PLAN REVIEW FEES 311,948 100,000 211,948- -212% 2394-000-371010-000 INVESTMENT EARNINGS 7,585 4,500 3,085- -69% TOTAL REVENUE 1,007,383 534,500 472,883- -88% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 168,933 374,578 205,645 55% 2394-420-420530-121 OVERTIME 5,627 5,000 627- -13% 2394-420-420530-153 HEALTH INSURANCE 28,877 85,277 56,400 66% 2394-420-420530-155 RETIREMENT 12,946 27,529 14,583 53% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 22,982 20,000 2,982- -15% 2394-420-420530-231 GAS k OIL 1,220 3,500 2,280 65% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 719 2,500 1,781 71% 2394-420-420530-323 ST. ED. ASSESSMENTS 0 3,000 3,000 100% 2394-420-420530-345 TELEPHONE k COPM4UNICATION 1,497 3,500 2,003 57% 2394-420-420530-353 AUDITING 1,000 0 1,000- 0% 2394-420-420530-354 CONTRACT SERVICES 5,684 43,500 37,816 87% 2394-420-420530-355 CITY WORKS LICENSING FEE 15,156 15,000 156- -1% 2394-420-420530-373 DUES k TRAINING 5,404 9,000 3,596 40% 2394-420-420530-510 PROPERTY INSURANCE 2,585 2,585 0 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 727 1,454 727 50% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 8,141 16,282 8,141 50% 2394-420-420530-528 DATA PROCESSING TRANSFER 14,598 29, 196 14,598 50% 2394-420-420530-944 VEHICLES 0 65, 000 65,000 100% TOTAL BUILDING DEPT. 296,097 706, 901 410,804 58% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 17 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 33,955 70,405 36,450 52% 2400-410-430263-153 HEALTH INSURANCE 4,721 13, 628 8,907 65% 2400-410-430263-155 RETIREMENT 2,502 5,141 2,639 51% 2400-410-430263-244 STREET LIGHT SUPPLIES 519 18,000 17,481 97% 2400-410-430263-341 ELECTRICITY 66,649 173,000 106,352 61% 2400-410-430263-360 REPAIR & MAINT SERVICES 1,941 20,000 18,059 90% 2400-410-430263-510 INSURANCE 392 1,000 608 61% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 6,324 12, 648 6,324 50% 2400-410-430263-920 NEW LUMINAIRES 0 30,000 30,000 100% 2400-410-490500-610 DEBT SERVICE -PRINCIPAL 10,905 21,862 10,957 50% 2400-410-490500-620 DEBT SERVICE -INTEREST EXPENSE 339 681 342 50% TOTAL LIGHT MAINT. 128,246 366,365 238,119 65% 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 11,928 56,485 44,557 79% 2420-421-430234-957 ALLEY PAVING 33,435 41, 627 8,192 20% 2420-421-430240-231 GAS & OIL 10,439 43,000 32,561 76% 2420-421-430240-344 NATURAL GAS 1,317 5,500 4,183 76% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 100% 2420-421-430240-360 REPAIR & MAINT SERVICES 0 1,500 1,500 100% 2420-421-430240-368 OVERLAY/CHIPSEALS 106,489 225, 562 119,073 53% 2420-421-430240-452 GRAVEL 0 3,500 3,500 100% 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 9,035 40,000 30,965 77% 2420-421-430240-472 ASPHALT 22,981 53,000 30,019 57% 2420-421-430240-473 CRACK SEALING 0 14,500 14,500 100% 2420-421-430240-474 PAINT STRIPING MATERIALS 2,560 60, 000 57,440 96% TOTAL GAS TAX 198,185 569,674 371,489 65% 2825 MACI GRANT 2825-421-430240-940 SANDER / SWEEPER 0 433,202 433,202 100% TOTAL MACI GRANT 0 433,202 433,202 100% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 18 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2500 SPEC. STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 315,248 709,550 394,302 56% 2500-421-430240-121 OVERTIME 5,365 25,000 19,635 79% 2500-421-430240-153 HEALTH INSURANCE 58,343 172,495 114,152 66% 2500-421-430240-155 RETIREMENT 23,587 51,452 27,865 54% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 141 9,000 8,859 98% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,518 6, 500 4,982 77% 2500-421-430240-220 OTHER SUPPLIES 1,463 4,500 3,037 67% 2500-421-430240-231 GAS & OIL 10,718 40,000 29,282 73% 2500-421-430240-341 ELECTRICITY 1,007 3,300 2,293 70% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 593 1,500 907 60% 2500-421-430240-354 CONTRACT SERVICES 4,640 30,000 25,360 85% 2500-421-430240-356 CONSULTANT - TRANSPORTATION PLAN UP 0 62, 892 62,892 100% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 7,916 32,500 24,584 76% 2500-421-430240-366 BUILDING MAINTENANCE 1,524 3,000 1,476 49% 2500-421-430240-373 DUES & TRAINING 1,152 5,500 4,348 79% 2500-421-430240-388 MEDICAL SERVICES 228 1,500 1,273 85% 2500-421-430240-510 LIABILITY INSURANCE 13,578 13,578 0 0% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 100% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 89,609 179,219 89,610 50% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 45,286 90,571 45,285 50% 2500-421-430240-528 DATA PROCESSING TRANSFER 6,256 12,513 6,257 50% 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 55,882 111,946 56,064 50% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 1,716 3,447 1,731 50% 2500-421-430240-920 SALT BRINE TANK 0 20,000 20,000 100% 2500-421-430240-921 SAND/COLD MIX STORAGE SHED 1,225 25,771 24,546 95% 2500-421-430240-922 USFS PROPERTY ACQUISITION 604 54, 964 54,360 99% 2500-421-430240-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 2500-421-430240-969 4TH AVE E MAIN REPLC PHASE 1-4 0 1,114,018 1,114,018 100% 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 148,722 762,359 613,637 80% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 244,332 300,544 56,212 19% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 100% 2500-421-430264-110 TSS - SALARIES 58,158 122, 685 64,527 53% 2500-421-430264-121 OVERTIME 261 7,500 7,239 97% 2500-421-430264-153 HEALTH INSURANCE 6,800 17,485 10,685 61% 2500-421-430264-155 RETIREMENT 4,248 8,823 4,575 52% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 166 1,500 1,334 89% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,018 6, 700 5,682 85% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 1,058 3,500 2,442 70% 2500-421-430264-242 STREET SIGNS 7,726 40,000 32,274 81% 2500-421-430264-243 TRAFFIC SIGNALS 5,296 19,000 13,704 72% 2500-421-430264-245 BARRICADE MATERIALS 0 5,000 5,000 100% 2500-421-430264-341 ELECTRICITY 648 3,000 2,352 78% 2500-421-430264-345 COMMUNICATIONS 368 750 382 51% 2500-421-430264-354 CONTRACT SERVICES 1,407 10,000 8,593 86% 2500-421-430264-362 EQUIPMENT MAINTENANCE 511 3,000 2,489 83% 2500-421-430264-366 BUILDING MAINTENANCE 1,154 2,000 846 42% 2500-421-430264-373 DUES & TRAINING 1,371 5,500 4,129 75% 2500-421-430264-428 PAINT MATERIALS 68 8,000 7,933 99% 2500-421-430264-510 LIABILITY INS.-TSS 1,604 1, 604 0 0% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 0 2,500 2,500 100% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 3,967 7,934 3,967 50% 2500-421-430264-532 OFFICE RENT 6,422 6,422 0 0% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 19 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 112 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. TOTAL SPEC. ST. MAINT. 1,142,901 4, 195, 902 3. 056. 001 73. 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 20 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 1,000 1,000 0 0% 2880-480-470210-354 CONTRACT SERVICES 45 1,000 955 95% 2880-480-470210-711 REDEVELOPMENT 50,018 150,000 99,982 67% TOTAL LOAN REVOLVING 51,063 152,000 100,937 66% 2881 CD LOAN REV. 42 2881-480-470210-711 REDEVELOPMENT 0 150,000 150,000 100% TOTAL 2881 CD REV. 42 0 150,000 150,000 100% 2886 CD MISC. 2886-480-470210-210 OFFICE SUPPLIES 0 2,000 2,000 100% 2886-480-470210-353 AUDITING 1,000 1,000 0 0% 2886-480-470210-373 DUES k TRAINING 0 2,000 2,000 100% 2886-480-470210-379 MEETINGS 0 1,000 1,000 100% 2886-480-470210-396 GRANT SERVICES 0 25,000 25,000 100% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 0 2,000 2,000 100% 2886-480-470210-528 DATA PROCESSING TRANSFER 4,171 8,342 4,171 50% 2886-480-470210-532 OFFICE RENT 1,175 1,175 0 0% 2886-480-470210-620 INTEREST - OLD SCHOOL LOAN - GENERA 0 16,250 16,250 100% 2886-480-470210-790 COMM. DEV. ACTIVITIES 1,705 100,000 98,295 98% 2886-480-470210-795 REDEVELOPMENT- OLD SCHOOL STATION 87,556 183,750 96,194 52% TOTAL CD MISC. 95,607 342,517 246,910 72% 2887 RURAL DEVELOPMENT 41 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 22,074 18,272 3,802- -21% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 0 3,803 3,803 100% 2887-480-470210-750 REDEVELOPMENT LOANS 0 150,000 150,000 100% TOTAL RURAL DEVELOPMENT 41 22,074 172,075 150,001 87% 2888 RURAL DEVELOPMENT 42 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 10,025 8,135 1,890- -23% 2888-480-470210-620 INTEREST EXPENSE -USDA LOAN 61-03 0 1,890 1,890 100% 2888-480-470210-750 REDEVELOPMENT LOANS 0 110,000 110,000 100% TOTAL RURAL DEVELOPMENT 42 10,025 120,025 110,000 92% 2953 EPA BROWNFIELDS 2953-480-470210-354 PETROLEUM 16 200,000 199,984 100% 2953-480-470215-354 HAZARDOUS 16 200,000 199,984 100% TOTAL EPA BROWNSFIELD 31 400,000 399,969 100% 2955 BROWNFIELDS LOAN REV. 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 21 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2955-480-470210-229 SUPPLIES -PETROLEUM 0 908 908 100% 2955-480-470210-352 PERSONNEL -PETROLEUM 0 3,505 3,505 100% 2955-480-470210-353 FRINGES -PETROLEUM 0 493 493 100% 2955-480-470210-354 CONTRACTED SERVICES-PETROLUEM 0 1,488 1,488 100% 2955-480-470210-373 TRAVEL -PETROLEUM 1,228 35 1,193- -3,408% 2955-480-470210-720 CLEANUP LOANS -PETROLEUM 0 62,354 62,354 100% 2955-480-470210-721 CLEANUP SUBGRANTS-PETRO 0 100,000 100,000 100% 2955-480-470210-725 REVOLVED FUNDS -PETROLEUM 0 100,500 100,500 100% 2955-480-470215-229 SUPPLIES -HAZARDOUS SUBSTANCES 0 1,158 1,158 100% 2955-480-470215-354 CONTRACT SERV-HAZARDOUS SUBST 0 88 88 100% 2955-480-470215-373 TRAVEL -HAZARDOUS SUBTSANCE 255 3,778 3,523 93% 2955-480-470215-720 CLEANUP LOANS -HAZARDOUS 0 314, 600 314,600 100% TOTAL BROWNFIELDS LOAN REV 2991 TIGER GRANT 2991-480-470245-790 REDEVELOPMENT TOTAL TIGER GRANT 2994 KIDSPORTS GRANT 2994-436-460436-930 CAPITAL IMPROVEMENTS TOTAL KIDSPORTS GRANT 1,483 588,907 587,424 100% 0 10.000.000 10.000.000 100% 0 10,000,000 10,000,000 100% 64,374 2, 152, 726 2,088,352 97% 64,374 2, 152, 726 2,088,352 97% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 22 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD /2015 GRT 1,492 31,255 29,763 95% 2915-413-420140-218 SMALL EQUIP - 2015 STONEGARDEN 38,851 25,000 13,851- -55% 2915-413-420140-354 CONT SERV-WPD/MHP/MFWPE-2015 GRT 0 38,815 38,815 100% TOTAL 2915 STONEGARDEN GRANT 40,342 95,070 54,728 58% 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 26,931 60, 926 33,995 56% 2916-413-420140-121 OVERTIME 4,653 7,500 2,847 38% 2916-413-420140-153 HEALTH INSURANCE 6,871 17,541 10,670 61% 2916-413-420140-155 RETIREMENT 3,593 8, 167 4,574 56% 2916-413-420140-354 CONTRACT SERVICES 2,604 5,841 3,237 55% TOTAL 2916 DRUG ENFORCEMENT 44,652 99,975 55,323 55% 2918 CHRP GRANT 2918-413-420140-110 SALARIES & PAYROLL COSTS 28,083 140,287 112,204 80% 2918-413-420140-153 HEALTH INSURANCE 3,231 32, 606 29,375 90% 2918-413-420140-155 RETIREMENT 3,647 18,857 15,210 81% TOTAL CHRP GRANT 34,960 191,750 156,790 82% 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 1,278 4,000 2,722 68% 2919-413-420140-125 DUI TASK FORCE 0 8,000 8,000 100% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 12,062 36, 000 23,938 67% 2919-413-420140-127 SCHOOL DIST. OT 8,671 20,000 11,329 57% 2919-413-420140-218 SAG&MDOT GRTS-WATCHGUARD CAMERAS 10,904 12,000 1,096 9% 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 1,204 2,500 1,296 52% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 6,054 7,000 946 14% TOTAL LAW ENF. GRANT 40,173 89,500 49,327 55% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 23 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CAPITAL PROJECT FUNDS 4150 FIRE PUMPER 4150-416-420400-944 PUMPER TRUCK TOTAL 4150 FIRE PUMPER 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION TOTAL 4290 WALK & CURB 0 500,000 500,000 100% 0 500,000 500,000 100% 5,914 25,000 19,086 76% 5,914 25,000 19,086 76% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 24 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. ENTERPRISE FUNDS WATER REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 450 0 450- 0% 5210-000-331158-000 STATE BYPASS RELOCATION REIMB. 1,876 0 1,876- 0% 5210-000-343210-000 METERED WATER SALES 1,764,257 2,850,000 1,085,743 38% 5210-000-343220-000 UNMETERED WATER SALES 10,507 0 10,507- 0% 5210-000-343225-000 IMPACT FEES 404,001 285,000 119,001- -42% 5210-000-343230-000 METER REPLACEMENT FEE 51,025 98,000 46,975 48% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 6,677 74,000 67,323 91% 5210-000-343265-000 IMPACT ADMIN FEES 0 15,000 15,000 100% 5210-000-343270-000 WATER TURN ON FEES 2,840 0 2,840- 0% 5210-000-343275-000 TAG FEE 35,900 0 35,900- 0% 5210-000-371010-000 INVESTMENT EARNINGS 51,067 46, 000 5,067- -11% 5210-000-381050-000 INCEPTION OF LEASE 0 2,435, 627 2,435,627 100% TOTAL WATER REVENUE 2,328,602 5, 803, 627 3,475,025 60% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 334,255 702,293 368,038 52% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 3,472 20,000 16,528 83% 5210-447-430550-153 HEALTH INSURANCE 63,366 168,225 104,859 62% 5210-447-430550-155 RETIREMENT 24,886 51,002 26,116 51% 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 2,880 11,000 8,120 74% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 2,123 8,500 6,377 75% 5210-447-430550-226 CHLORINE & CHEMICALS 12,205 38,000 25,795 68% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 2,645 4,500 1,855 41% 5210-447-430550-231 GAS & OIL 9,912 38,000 28,088 74% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 33 4,000 3,967 99% 5210-447-430550-336 LICENSES & FEES 140 18,500 18,360 99% 5210-447-430550-341 ELECTRICITY 68,986 150,000 81,014 54% 5210-447-430550-344 NATURAL GAS 3,481 15,500 12,019 78% 5210-447-430550-345 TELEPHONE & COPM4UNICATION 5,071 9,000 3,929 44% 5210-447-430550-349 LAB SERVICES 10,507 26, 000 15,493 60% 5210-447-430550-353 AUDITING 5,000 5,000 0 0% 5210-447-430550-354 CONTRACT SERVICES 8,488 65, 000 56,512 87% 5210-447-430550-356 CONSULTANTS-WTR RIGHTS/MODELING 2,652 25,000 22,348 89% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 1,414 15,000 13,586 91% 5210-447-430550-366 BUILDING MAINTENANCE 2,081 12,000 9,919 83% 5210-447-430550-373 DUES & TRAINING 1,644 9,000 7,356 82% 5210-447-430550-388 MEDICAL SERVICES 193 800 608 76% 5210-447-430550-410 CONSTRUCTION MATERIALS 9,580 35,000 25,420 73% 5210-447-430550-422 HYDRANTS 759 8,000 7,241 91% 5210-447-430550-423 MATERIALS FOR MAINS 4,974 14,000 9,026 64% 5210-447-430550-424 MATERIALS -SERVICE LINES 3,746 14,000 10,254 73% 5210-447-430550-425 MATERIALS PUMPS/WELLS 1,272 45,000 43,728 97% 5210-447-430550-510 PROPERTY & LIABILITY INS. 15,468 15,468 0 0% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 0 10,000 10,000 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 11,927 23,855 11,928 50% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 51,736 103,473 51,737 50% 5210-447-430550-528 DATA PROCESSING TRANSFER 14,598 36, 000 21,402 59% 5210-447-430550-532 LEASE PAYMENTS (City Hall rent) 6,422 9,500 3,078 32% 5210-447-430550-921 SAND/COLD MIX STORAGE SHED 1,225 25,771 24,546 95% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 25 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-922 USFS PROPERTY ACQUISITION 366 32,978 32,612 99% 5210-447-430550-936 Noffsinger Spring Generator 9,832 90,000 80,168 89% 5210-447-430550-948 METERS (METER FUNDS) 010125 12,100 110,000 97,900 89% 5210-447-430550-951 SECURITY SCADA UPGRADES 0 15,000 15,000 100% 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 5210-447-430550-958 2ND AVE EAST MAIN REPLC & UPSIZE 0 45,147 45,147 100% 5210-447-430550-959 PARKS METERING PHASE I 6,720 30,000 23,280 78% 5210-447-430550-969 4TH AVE E MAIN REPL. PH. 1 0 2,435, 627 2,435,627 100% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 150,000 150,000 100% 5210-447-430555-941 METERS (NEW SERVICES)010120 12,100 45, 600 33,500 73% 5210-447-430555-953 SECTION 36 WELL 0 639, 746 639,746 100% SUBTOTAL WATER FACILITIES 728,259 5,366,037 4,637,778 86% WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 5210-447-430560-153 HEALTH INSURANCE 5210-447-430560-155 RETIREMENT 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 5210-447-430560-353 AUDITING 5210-447-430560-354 CONTRACT SERVICES 5210-447-430560-355 BILLING COSTS 5210-447-430560-373 DUES & TRAINING 5210-447-430560-522 ADMINISTRATIVE TRANSFER 5210-447-430560-528 DATA PROCESSING TRANSFER 5210-447-430560-532 RENT SUBTOTAL WATER BILLING 49,864 108, 823 58,959 54% 13,189 36, 839 23,650 64% 3,826 8,225 4,399 53% 764 2, 500 1,736 69% 2,000 2,000 0 0% 0 3,000 3,000 100% 27,089 70, 000 42,911 61% 302 2,500 2,198 88% 3,975 7,950 3,975 50% 14,598 33, 000 18,402 56% 6,422 6,422 0 0% 122,029 281,259 159,230 57% REVENUE BONDS 5210-447-490204-610 BOND PRIN-HWY 93 S WTR-2004 0 65, 000 65,000 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 29,185 28,835 350- -1% 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 0 350 350 100% 5210-447-490206-610 PRIN-MTR&WELL WRF7104 1.25%;WRF8114 0 83,000 83,000 100% 5210-447-490206-620 INT-MTR&WELL/WRF7104 1.25%;WRF8114 22,601 22, 601 0- 0% 5210-447-490250-610 PRIN-WTR MAIN/WRF1032R 2%/IDAHO&MAI 0 48,000 48,000 100% 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2%/IDAHO&MAIN 4,440 4,200 240- -6% SUBTOTAL REVENUE BONDS 56,226 251, 986 195,760 78% DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION TOTAL WATER FUND 0 840,000 840,000 100% 0 840,000 840,000 100% 906,514 6,739,282 5,832,768 87% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 26 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 450 0 450- 0% 5310-000-343310-000 SEWER SERVICE CHARGES 2,241,630 4,400,000 2,158,370 49% 5310-000-343330-000 IMPACT FEES (SANITARY) 479,920 220,000 259,920- -118% 5310-000-343335-000 IMPACT FEES (WWTP) 301,527 300,000 1,527- -1% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 896 15,000 14,104 94% 5310-000-371010-000 INVESTMENT EARNINGS 57,555 50,000 7,555- -15% TOTAL SEWER REVENUE 3,081,978 4,985,000 1,903,022 38% SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 5310-454-430620-153 HEALTH INSURANCE 5310-454-430620-155 RETIREMENT 5310-454-430620-215 OFFICE SUPPLIES/computers 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 5310-454-430620-355 BILLING COSTS 5310-454-430620-373 DUES & TRAINING 5310-454-430620-522 ADMINISTRATIVE TRANSFER 5310-454-430620-528 DATA PROCESSING TRANSFER 5310-454-430620-532 OFFICE RENT SUBTOTAL SEWER BILLING COSTS 41,807 91, 956 50,149 55% 10,508 29,868 19,360 65% 3,204 6, 936 3,732 54% 764 2, 500 1,736 69% 2,000 2,000 0 0% 29,115 70,000 40,885 58% 302 2,500 2,198 88% 3,527 7,055 3,528 50% 14,598 33,000 18,402 56% 6,422 6,422 0 0% 112,247 252,237 139,990 56% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 107,841 251,377 143,536 57% 5310-454-430630-121 OVERTIME 320 5,500 5,180 94% 5310-454-430630-153 HEALTH INSURANCE 24,258 66,327 42,069 63% 5310-454-430630-155 RETIREMENT 8,050 18,365 10,315 56% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 1,714 9,200 7,486 81% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 922 8,350 7,428 89% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 1,254 2,000 746 37% 5310-454-430630-231 GAS & OIL 3,725 13,500 9,775 72% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 330 400 70 17% 5310-454-430630-341 ELECTRICITY 18,664 54,500 35,836 66% 5310-454-430630-344 NATURAL GAS 6,679 16, 500 9,821 60% 5310-454-430630-345 TELEPHONE & COMMUNICATION 13,520 23,000 9,480 41% 5310-454-430630-353 AUDITING 3,000 3,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 8,431 24,000 15,569 65% 5310-454-430630-356 CONSULTANTS 759 8,000 7,241 91% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 2,763 5,000 2,237 45% 5310-454-430630-373 DUES & TRAINING 992 5,500 4,508 82% 5310-454-430630-388 MEDICAL SERVICES 0 500 500 100% 5310-454-430630-410 CONSTRUCTION MATERIALS 6,246 9,000 2,754 31% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 1,321 50,000 48,679 97% 5310-454-430630-510 PROPERTY & LIABILITY INS. 15,791 15,791 0 0% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 3,658 25,000 21,342 85% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 4,590 9,180 4,590 50% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 32,231 64,461 32,230 50% 5310-454-430630-528 DATA PROCESSING TRANSFER 8,342 19,000 10,658 56% 5310-454-430630-532 OFFICE RENT 6,422 6,422 0 0% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 27 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-921 SAND/COLD MIX STORAGE SHED 1,225 25,771 24,546 95% 5310-454-430630-922 USFS PROPERTY ACQUISITION 366 32,978 32,612 99% 5310-454-430630-951 1ST ALLEY EN PIPE UPSIZE (34% RATE 0 20,528 20,528 100% 5310-454-430630-952 PETERSON SCHOOL ALLEY REPLACEMENT 0 284,000 284,000 100% 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 11,847 20,000 8,153 41% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 10,249 50,000 39,751 80% 5310-454-430630-961 2ND ALLEY WN - MONT TO CALF 296,338 324,366 28,028 9% SUBTOTAL SEWER COLLECTION 601,849 1,502,068 900,219 60% IMPACT FEES 5310-454-430635-951 1ST ALLEY EN PIPE UPSIZE (34% RATE 0 34,035 34,035 100% 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 0 100,000 100,000 100% 5310-454-430635-957 3 MILE DR INTERCEPTOR 44,042 867, 087 823,045 95% 5310-454-430635-961 2ND ALLEY WN - MONT TO CALF 152,572 167,110 14,538 9% SUBTOTAL IMPACT FEE EXPENSE 196,613 1,168,232 971,619 83% REVENUE BONDS/SANITARY 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.25% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25% 0 81,000 81,000 100% 15,345 15,346 2 0% 0 300 300 100% SUBTOTAL REVENUE BONDS 15,345 96,646 81,302 84% DEPRECIATION -SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 820,000 820,000 100% SUBTOTAL DEPRECIATION -SANITARY 0 820,000 820,000 100% SUBTOTAL SANITARY SEWER 813,806 3,586,946 2,773,140 77% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 203,411 448, 865 245,454 55% 5310-455-430640-111 SEASONAL SALARIES 3,629 5,000 1,371 27% 5310-455-430640-112 SALARIES -RETIREMENT 14,457 0 14,457- 0% 5310-455-430640-121 OVERTIME 11,620 22,500 10,880 48% 5310-455-430640-153 HEALTH INSURANCE 34,878 88,992 54,114 61% 5310-455-430640-155 RETIREMENT 16,000 32,463 16,463 51% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 1,498 10,000 8,502 85% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 2,038 2,700 662 25% 5310-455-430640-225 ALUM 0 20,000 20,000 100% 5310-455-430640-226 CHLORINE & CHEMICALS 12,507 19,000 6,493 34% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 2,982 7,000 4,018 57% 5310-455-430640-231 GAS & OIL 4,742 18,500 13,758 74% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 261 350 89 25% 5310-455-430640-336 LICENSES & FEES 115 10,000 9,885 99% 5310-455-430640-341 ELECTRICITY 68.280 178.500 110.220 62% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 28 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-342 WATER 1,925 7,500 5,575 74% 5310-455-430640-344 NATURAL GAS 15,213 65, 000 49,787 77% 5310-455-430640-345 TELEPHONE & COMMUNICATION 3,035 5,500 2,465 45% 5310-455-430640-353 AUDITING 4,000 4,000 0 0% 5310-455-430640-354 CONTRACT -GLACIER GOLD 57,831 124,000 66,169 53% 5310-455-430640-355 OTHER CONTRACT SERVICES 11,621 30,000 18,379 61% 5310-455-430640-356 CONSULTANTS 14,210 100,000 85,790 86% 5310-455-430640-358 CONSULTANT-TMDL 962 15,000 14,038 94% 5310-455-430640-360 MISC. MAINT SERVICES 8,731 30,000 21,269 71% 5310-455-430640-366 BUILDING MAINTENANCE 23,161 36, 000 12,839 36% 5310-455-430640-373 DUES & TRAINING 2,651 7,500 4,849 65% 5310-455-430640-388 MEDICAL SERVICES 140 500 360 72% 5310-455-430640-510 PROPERTY & LIABILITY INS. 34,985 34,985 0 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 6,606 13,212 6,606 50% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 56,118 112,237 56,119 50% 5310-455-430640-528 DATA PROCESSING TRANSFER 10,427 27,500 17,073 62% 5310-455-430640-921 EVERGREEN SEWER SAMPLING EQUIP & BL 20,570 40,000 19,430 49% SUBTOTAL WWTP OPERATIONS 648,607 1, 516, 804 868,197 57% WWTP BONDED PROJECT SUBTOTAL WWTP BONDED 0 0 0 0% WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 48,650 100,000 51,350 51% 5310-455-430645-920 R.A.S. BLD & STORAGE WAREHOUSE ROOF 0 40,000 40,000 100% 5310-455-430645-933 SOLIDS DEWATERING DESIGN & CONST. 592 100,000 99,408 99% 5310-455-430645-934 SECONDARY DIGESTER LID INSPECTION 28,798 531,500 502,702 95% 5310-455-430645-936 DIGESTED SLUDGET LINE REPLACEMENT 29,750 298, 678 268,928 90% 5310-455-430645-937 SAND FILTER MAINT & REPLACMENT 0 200,000 200,000 100% 5310-455-430645-940 MACHINERY & EQUIPMENT 18,452 182,500 164,048 90% SUBTOTAL WWTP REPLACEMENT 126,242 1,452, 678 1,326,436 91% WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 47,595 106,284 58,689 55% 5310-455-430646-121 OVERTIME 168 0 168- 0% 5310-455-430646-153 HEALTH INSURANCE 6,800 20,932 14,132 68% 5310-455-430646-155 RETIREMENT 3,530 7, 630 4,100 54% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 619 4,500 3,881 86% 5310-455-430646-218 NON -CAPITAL EQUIPMENT 0 2,500 2,500 100% 5310-455-430646-222 LAB SUPPLIES 6,956 9,500 2,544 27% 5310-455-430646-349 LAB SERVICES 14,526 29,000 14,474 50% 5310-455-430646-362 EQUIPMENT MAINTENANCE 3,825 5,500 1,675 30% 5310-455-430646-373 DUES & TRAINING 824 3,700 2,876 78% SUBTOTAL WWTP LAB OPERATIONS 84,843 189,546 104,703 55% DEBT SERVICE - WWTP 5310-455-490227-610 PRIN-WWTP IMP/SRF8164R/2.25% 0 796, 000 796,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 216,405 216,405 0 0% 5310-455-490228-610 PRIN/WWTP DIGESTER LID/SRF13326/3.0 0 44,000 44,000 100% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 29 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 28,650 28, 650 0 01 SUBTOTAL DEBT SERVICE - WWTP 245,055 1,085,055 840,000 77% CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-830 EVERGREEN REPLACEMENT TRANSFER 0 450,000 450,000 100% 5310-455-510400-831 DEPRECIATION EXPENSE 0 1,425,000 1,425,000 100% SUTOTAL WWTP DEPRECIATION/REPL 0 1,875,000 1,875,000 100% SUBTOTAL WWTP 1,104,747 6,119,083 5,014,336 82% TOTAL BILLING/SANITARY/WWTP 2,030,801 9, 958,266 7,927,465 80% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 30 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM SEWER REVENUE 5349-000-323108-000 PW PLAN REVIEW FEES 450 0 450- 0% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 2,376 2,500 124 5% 5349-000-343033-000 IMPACT FEES 179,384 150,000 29,384- -20% 5349-000-343034-000 PERMIT FEES 830 0 830- 0% 5349-000-343035-000 STORM SEWER CHARGES 0 1,000 1,000 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 867,285 850,000 17,285- -2% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 971 1,000 29 3% 5349-000-371010-000 INTEREST ON INVESTMENTS 16,892 18,000 1,108 6% 5349-000-381050-000 INCEPTION OF LEASE 0 382,000 382,000 100% TOTAL STORM REVENUE 1,068,189 1,404,500 336,311 24% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 163,454 360, 758 197,304 55% 5349-453-430246-121 OVERTIME 320 4,000 3,680 92% 5349-453-430246-153 HEALTH INSURANCE 30,703 81,030 50,327 62% 5349-453-430246-155 RETIREMENT 12,213 26,448 14,235 54% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 2,531 10,100 7,569 75% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 130 6, 550 6,420 98% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100% 5349-453-430246-231 GAS & OIL 3,290 11,500 8,210 71% 5349-453-430246-345 TELEPHONE & COMMUNICATION 402 800 398 50% 5349-453-430246-353 AUDITING 0 2,340 2,340 100% 5349-453-430246-354 CONTRACT SERVICE 5,563 6, 000 437 7% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 7,454 35,000 27,546 79% 5349-453-430246-357 IMPACT FEE UPDATE 14,286 50,000 35,714 71% 5349-453-430246-358 CONSULTANTS 624 7,000 6,376 91% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 0 15,000 15,000 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 939 2,500 1,561 62% 5349-453-430246-362 GROUNDWATER MONITORING 2,150 6, 500 4,350 67% 5349-453-430246-371 CURB & GUTTER 0 7,000 7,000 100% 5349-453-430246-373 DUES & TRAINING 920 5,500 4,580 83% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 0 10,000 10,000 100% 5349-453-430246-510 PROPERTY & LIABILITY INS. 4,842 10,000 5,158 52% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 4,590 9,180 4,590 50% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 19,876 39,752 19,876 50% 5349-453-430246-528 DATA PROCESSING TRANSFER 8,342 13,000 4,658 36% 5349-453-430246-530 BNSF LEASE PMT 4,790 5,900 1,110 19% 5349-453-430246-532 OFFICE RENT 6,422 6,422 0 0% 5349-453-430246-840 MACI GRANT MATCH (SWEEPER) 0 43,000 43,000 100% 5349-453-430246-921 SAND/COLD MIX STORAGE SHED 1,225 25,771 24,546 95% 5349-453-430246-952 STORM DRAIN CORRECTION 7,389 100,000 92,611 93% 5349-453-430246-953 WILLOWS PRJ FY14/15; SHOP COMPLX PV 0 30,552 30,552 100% 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 501,380 581,400 80,020 14% 5349-453-430246-969 4TH AVE E. REPLACE PHASE 1-4 0 382,000 382,000 100% 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 130,000 130,000 100% 5349-453-510400-831 DEPRECIATION 0 285,000 285,000 100% TOTAL STORM 803,833 2,312,303 1,508,470 65% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 31 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SOLID WASTE REVENUE: 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 973,985 955,000 18,985- -2% 5510-000-343420-000 GARBAGE COLLECTION -BILLED 28,075 21,500 6,575- -31% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,467 2,100 633 30% 5510-000-371010-000 INVESTMENT EARNINGS 4,580 6, 000 1,420 24% 5510-000-382010-000 SALE OF FIXED ASSETS 15,700 0 15,700- 0% TOTAL SOLID WASTE REVENUE 1,023,806 984,600 39,206- -4% SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 186,988 399, 776 212,788 53% 5510-460-430840-112 SEVERANCE -RETIREMENT 0 60,455 60,455 100% 5510-460-430840-121 OVERTIME 2,096 5,500 3,404 62% 5510-460-430840-153 HEALTH INSURANCE 36,986 106,280 69,294 65% 5510-460-430840-155 RETIREMENT 13,920 28,993 15,073 52% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 1,250 9,500 8,250 87% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 37,290 35,000 2,290- -7% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 1,146 5,500 4,354 79% 5510-460-430840-231 GAS & OIL 14,927 60, 000 45,073 75% 5510-460-430840-341 ELECTRICITY 511 1,950 1,439 74% 5510-460-430840-344 NATURAL GAS 893 4,900 4,007 82% 5510-460-430840-345 TELEPHONE & COPM4UNICATION 496 850 354 42% 5510-460-430840-354 CONTRACT SERVICES 5,513 9,000 3,487 39% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 580 5,700 5,120 90% 5510-460-430840-366 BUILDING MAINTENANCE 127 2,500 2,373 95% 5510-460-430840-373 DUES & TRAINING 804 3,500 2,697 77% 5510-460-430840-388 MEDICAL SERVICES 0 650 650 100% 5510-460-430840-510 PROPERTY & LIABILITY INS. 6,799 6, 799 0 0% 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 0 4,000 4,000 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 38,052 76, 104 38,052 50% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 18,656 37,311 18,655 50% 5510-460-430840-528 DATA PROCESSING TRANSFER 6,256 12,513 6,257 50% 5510-460-430840-532 OFFICE RENT 6,422 6,422 0 0% 5510-460-430840-610 DEBT SERVICE PRINCIPAL -GARBAGE TK 19,127 38,343 19,216 50% 5510-460-430840-620 DEBT SERVICE INTEREST -GARBAGE TK 898 1,801 903 50% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 17,500 35,000 17,500 50% 5510-460-430840-922 USFS PROPERTY ACQUISITION 494 43,971 43,477 99% 5510-460-430840-940 EQUIPMENT 0 48,000 48,000 100% 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 0 30,552 30,552 100% 5510-460-430845-224 JANITORIAL SUPPLIES 120 250 130 52% 5510-460-430845-341 ELECTRICITY 697 3,500 2,803 80% 5510-460-430845-342 WATER 267 2,000 1,733 87% 5510-460-430845-344 NATURAL GAS 1,317 6, 500 5,183 80% 5510-460-430845-360 REPAIR & MAINT SERVICES 227 3,500 3,273 94% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% TOTAL SOLID WASTE EXPENSE 420,359 1,246, 620 826,261 66% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 32 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 5,400 10,000 4,600 46% 5160-000-343069-000 HANGER LEASES 6,000 11,000 5,000 45% 5160-000-343071-000 HANGAR SITE LEASES 19,132 17,510 1,622- -9% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 9,455 19,145 9,690 51% 5160-000-343102-000 GROUND LEASES 13,198 13,198 0- 0% 5160-000-343620-000 FUEL TAX 1,704 5,000 3,296 66% 5160-000-371010-000 INVESTMENT EARNINGS 1,094 1,000 94- -9% 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 TOTAL AIRPORT REVENUE 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 55,984 76, 853 20,869 27% 0 1,000 1,000 100% 643 1, 500 857 57% 18,000 36, 000 18,000 50% 0 7,500 7,500 100% 1,123 10,000 8,877 89% 350 1,000 650 65% 423 6, 500 6,077 93% 1,281 2,562 1,281 50% 1,043 2,085 1,042 50% 0 97,918 97,918 100% 22,863 166,065 143,202 86% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 33 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING INTERNAL SERVICE FUNDS INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 HB 124 ENTITLEMENT 102,500 205,000 102,500 50% 6030-000-341027-000 CHARTER COPM4UNICATION/FRANCISE FEES 42,689 175,000 132,311 76% 6030-000-364030-000 SALE OF MISCELLANEOUS 63 0 63- 0% 6030-000-371010-000 INVESTMENT EARNINGS 847 1,000 153 15% 6030-000-393000-000 INTERNAL SERVICES -DATA 117,828 235, 655 117,827 50% TOTAL INFORMATION TECH REVENUE 263,927 616,655 352,728 57% INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 79,600 167,379 87,779 52% 6030-401-410580-121 OVERTIME 659 1,000 341 34% 6030-401-410580-153 HEALTH INSURANCE 18,296 44,317 26,021 59% 6030-401-410580-155 RETIREMENT 6,261 12, 653 6,392 51% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 85 50o 415 83% 6030-403-410580-215 COMPUTER SUPPLIES 505 2,400 1,895 79% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 8,564 18, 963 10,399 55% 6030-403-410580-325 WEBSITE 771 16, 000 15,229 95% 6030-403-410580-345 PAGER/PHONE 1,087 2,500 1,413 57% 6030-403-410580-346 SUMMITNET & ISPS 2,743 8,468 5,725 68% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,432 3,500 68 2% 6030-403-410580-354 MAINTENANCE CONTRACTS 2,142 8, 860 6,718 76% 6030-403-410580-355 LICENSES 4,774 21,110 16,336 77% 6030-403-410580-356 MAINTENANCE CONTRACTS 30,581 47,550 16,969 36% 6030-403-410580-357 GRANICUS 7,317 6, 690 627- -9% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 3,967 21,235 17,268 81% 6030-403-410580-373 DUES & TRAINING 1,016 8,000 6,984 87% 6030-403-410580-510 INSURANCE 819 1,778 959 54% 6030-403-410583-218 TV -Video Equipment & programming 217 12,900 12,683 98% 6030-403-410585-229 COPIER,FAX, SUPPLIES 3,678 19,552 15,874 81% 6030-403-410585-345 TELEPHONE & COPM4UNICATIONS 37,972 76, 000 38,028 50% 6030-403-410585-532 COPIER LEASES 7,172 16,182 9,010 56% 6030-403-410585-942 Servers - capital contingency 0 23,500 23,500 100% 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,000 5,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 0 4, 964 4,964 100% 6030-405-410588-940 NETWORK EQUIPMENT CAPITAL 10,794 49,200 38,406 78% 6030-410-410588-218 COMPUTERS - DPW 2,175 2,175 0 0% 6030-413-410588-218 COMPUTERS - POLICE DEPT 1,737 28,360 26,623 94% 6030-413-410588-354 POLICE - HOSTED SERVER 451 2,000 1,549 77% 6030-416-410588-218 COMPUTERS - FIRE 993 16, 752 15,759 94% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 2,256 11,053 8,797 80% 6030-436-410588-218 COMPUTERS - PARKS 156 5, 165 5,009 97% 6030-480-410588-218 COPM4UNITY DEVELOPMENT 0 2,155 2,155 100% TOTAL INFORMATION TECH EXPENSE 240,220 667, 861 427,641 64% 01.11.2017 15:02 THE CITY OF KALISPELL, MONTANA Page 34 of 34 gb8501_pg.php/Job No: 46731 USER: RGW FY17 FINANCIAL REPORT JULY 1, 2016 THRU DECEMBER 31, 2016 50.00 % Yr Complete For Fiscal Year: 2017 / 12 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 255,000 510,000 255,000 50% 6010-000-371010-000 INVESTMENT EARNINGS 378 200 178- -89% TOTAL CENTRAL GARAGE REVENUE 255,378 510,200 254,822 50% CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 76,055 160, 046 83,991 52% 6010-410-431330-121 OVERTIME 1,639 2,500 861 34% 6010-410-431330-153 HEALTH INSURANCE 15,934 38,827 22,893 59% 6010-410-431330-155 RETIREMENT 5,436 11,505 6,069 53% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 1,420 10,000 8,580 86% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 5,474 12,700 7,226 57% 6010-410-431330-230 OIL 6,774 25,000 18,226 73% 6010-410-431330-231 GAS 98 3,000 2,902 97% 6010-410-431330-232 VEHICLE PARTS 43,283 108,000 64,717 60% 6010-410-431330-233 TIRES 24,347 38,000 13,653 36% 6010-410-431330-238 FILTERS 3,235 7,700 4,465 58% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 475 2,000 1,525 76% 6010-410-431330-341 ELECTRICITY 632 1,950 1,318 68% 6010-410-431330-344 NATURAL GAS 1,168 7,000 5,832 83% 6010-410-431330-354 CONTRACT SERVICES 8,375 30,000 21,625 72% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 341 2,000 1,659 83% 6010-410-431330-373 DUES & TRAINING 4,468 6,200 1,732 28% 6010-410-431330-388 MEDICAL SERVICES 0 300 300 100% 6010-410-431330-510 INSURANCE 1,286 2,750 1,464 53% 6010-410-431330-528 INFORMATION TECH TRANSFER 4,171 8,342 4,171 50% 6010-410-431330-921 4 POST SERVICE LIFT 20,932 26, 000 5,068 19% TOTAL CENTRAL GARAGE EXPENSES 225,545 503,820 278,275 SS%