The URL can be used to link to this page

10-19-15 City Manager ReportCITYOF _ City of Kalispell OFFICE OF THE CITY MANAGER i mo_ - . 'SibrMONTANA N=.' Information Memorandum 10/19/2015 1. Finance Department Utility Billing Clerks Interviews will be held on October 151h and 16th for the vacant utility billing clerk position and the position necessary for the move to monthly billing. Thirty-six applications were received for the openings. Eight candidates have been chosen for interviews. First Quarter Finance Report Please find attached the printouts reflecting the activity for the 1st quarter of the fiscal year 2016. This printout reflects payroll paid thru Sept. 19, six pay periods. All funds are included with the exception of the debt service funds; G. O. bonds, Sidewalk & Curb and SID's. REVENUES: General Fund revenue has little activity as taxes will not be received until December. The tax receivables have not been booked. Tax bills will go out the end of October and we will book the receivables/revenue at that time. This applies to the assessed funds, garbage and storm, as well. The Ambulance Fund 1st quarter fees for services is 22% of budget or $137,519. This is a decrease of over $30,000 when compared to the 1st quarter of fiscal year 2015. First quarter Building Department revenues are 69% of the annual budget and 1st quarter fiscal year 2016 building department revenue is up over 70% compared to the same period last fiscal year. Water metered sales are at 46% compared to 37% for the first quarter of fiscal year 2015, and reflects the increased irrigation/sprinkling consumption in this dry year. Sewer metered sales are at 29%, compared to 28% for the same quarter last fiscal year. EXPENDITURES/EXPENSES: at this point in the year the salary remaining should be between 75% and 80%. Some seasonal salaries would be the exception, such as parks and recreation. Health insurance reflects 2 months paid and should show about 84% remaining. Retirement should be comparable to salaries as far as % remaining. 2. Public Works Kalispell WWTP Annual Tank Inspections Every fall, WWTP Operator's perform annual inspections on two Primary Clarifiers, three Secondary Clarifiers, the Headworks Grit Chamber, and the Re -aeration Basin. Annual inspections are completed for preventative maintenance purposes. The Operators drain and clean the tanks, then perform an inspection on the tank condition and mechanical equipment. During the inspections, operators identify any problems and make corrective repairs. The inspection also provides the opportunity to make sure there are adequate spare parts in preparation for future replacement of warn equipment. Each tank takes two to three operators approximately one week to complete. - - It's difficult and very labor intense work, but essential in order to maintain the level of operation required to keep the WWTP fine-tuned. Replacement items this year included the composite chain in the west primary clarifier. We were able to get 5 years of service on the chain, which is a very long service life for the environment. FY 2015 Capital Improvement Report Annually, Public Works prepares a Capital Improvement Report specifying the Public Works infrastructure improvements with respective annual costs for water, sanitary sewer, stormwater collection, wastewater treatment, and streets. This information is provided to the Finance Department to satisfy the City's annual auditing requirement. The table below is a simplified summary of the report. A copy of the full report can be acquired from the Finance Department. FY 15 Capital Improvement Summarized Report Fire Hydrants # of Hydrants Costs WWTP Projects CIP/Repair Costs Replacement -City Project 3 $12,131 Headworks /Lift Station Roof Repair Repair $44,348 New -City Project 5 $20,373 Main Bid Light Improvement CIP $5,013 New -Private Development 6 $24,448 Coating Equalization Tank Repair $16669 Digester Room piping CIP $98,723 Water Main Projects Lineal Foot Costs Insulate Foam Separator CIP $14,180 Replacement -City Project 2,052 $637,157,000 Replace Odor Control Bark Repair $42,975 New -Private Development 1,687 $131,715 Storm Main Projects Lineal Foot Costs Water Meter Installation Total Installed Costs Replacement -City Project 2,468 $525,698 %" 222 $43,290 New -Private Development 294 $22,445 1" 3 $1,155 1.5" 5 $3,175 Street Projects Lineal Foot Costs 2" 3 $2,805 City Project -sidewalk 1,723 $68,581 City Project -alley 1,650 $24,112 Sewer Main Projects Lineal Foot Costs City Project -chip Seal 18,000 $169,339 Replacement -City Project ---- City Project-overlay/pavement maint. 8,185 $265,239 New -Private Development 691 $26,762 2 3. Fire Department Since the last update, the Kalispell Fire Department have received 123 calls for service and have conducted 13 outreach trainings with approximately 349 individuals in attendance. The fire department has been working with the Insurance Services Office (ISO) for our ISO evaluation. ISO collects and evaluates information form communities in the United States on their structure fire suppression capabilities. The data is analyzed using the Fire Suppression Rating Schedule (FSRS) and then a Public Protection Classification (PPC) grade is assigned to the community. Insurance companies use PPC information for marketing, underwriting, and to help establish insurance premiums for homeowners and commercial fire insurance. In general, the price of fire insurance in a community with a lower PPC grade is lower than in a community with a higher PPC grade. The relevant data collected includes fire flows, emergency communications, fire department capabilities and the water supply infrastructure for the community. PPC grades are numbered 1-10. PPC class 1 represents an exemplary fire suppression program, and a class 10 indicates that the area's fire suppression program does not meet ISO's minimum criteria. Kalispell remains a PPC Class 3. A Class 3 PPC grade represents classification within the top 9% of rated communities in the United States. The fire department is currently disseminating the information provided in the report to assist us in further improving the services we offer. 4. Planning Department The planning board met on Tuesday, October 13, and heard a request for a conditional use permit by Immanuel Lutheran Corporation for a 5 Phase, multi -year project that will involve remodeling and expansion of both the Buffalo Hills Terrace Assisted Living and the skilled nursing home. The project received a favorable recommendation and has been forwarded to the council for final action. The only issue of contention was a proposal by the applicants to construct 3 pedestrian bulb -outs along Claremont Street to assist residents and staff crossing the street between facilities. The public works department raised significant issues primarily with snow removal as this street does not have boulevards and the bulb -outs will further exasperate snow removal. The planning board supported the concept. Staff will meet with the applicants prior to council action to determine if alternate design concepts can be incorporated. The planning board also recommended approval of a request for a zoning text amendment that would reduce the required parking numbers for the Kalispell Center Mall. This request would allow the Center Mall the option of adding additional building pads on the Mall property in the future. 3 5. Building Department The department issued 2 single family home permits this past week. The Captains Marine permit (south of Gardner's Auction on US 93 South) was also issued. The permit for the Marriot Hotel immediately south of Station 62 was also issued with work commencing immediately. They have targeted June 1 as the projected completion date of this 4 story hotel. Finally, a Certificate of Occupancy was issued to Discount Tire immediately east of Cabala's. 6. Parks and Recreation On October 9, 2015, at the Montana League of Cities and Towns conference in Bozeman, the City of Kalispell was nominated as one of three communities for the 2016 Montana Tree City of the Year Award. Council member Jim Atkinson accepted the nomination on the City's behalf. Governor Bullock will now review the three finalists and make his selection for the award. The governor will also attend the winners Arbor Day celebration in addition to granting a $10,000 award to the selected city's urban forestry program. The Street Tree Committee hosted the fall "Trees To Paper To Trees" Recycling Drive at the Fairgrounds on October 3, 2015. Committee members, students and advisors from Kalispell Middle School volunteered their time unloading vehicles and filling recycling bins donated by Pacific Recycling and Valley Recycling. The Daily Inter Lake helped to sponsor the event through advertising and Pizza Hut sponsored through donated pizza to feed volunteers. Collected amounts were: paper (newspaper and mixed) 10,480 lbs, cardboard 1,000 lbs, aluminum 211 lbs = $69.63. To date the drives have brought in over 667,000 lbs of materials and $13,655 in revenue. Little Squirts and Little Dribblers basketball is in full swing. Registration is up by 20 kids for Dribblers and down 5 kids in Squirts, compared to last year. SkipOut Camp days are scheduled for October 15 and 16. Kids will be going to Sweet Pickin's Pumpkin Patch on Thursday and then decorating their pumpkins on Friday. The winterization of irrigation systems is almost complete. Pool facilities and park restrooms are remaining. Staff focus now turns toward leaf pickup in the parks. Youth Days brought 20 middle school leadership volunteers to Woodland Water Park for several hours on October 5, 2015. Students replenished mulch around the facility helping to beautify the landscaping. 7. Community Development Environmental remediation of lead and asbestos at the Flathead County Historic Jail has been completed. The project was supported by a sub -grant from the City of Kalispell's Brownfields RLF Grant for environmental cleanup projects. The final project report and expenditures will be completed in the coming month. E 8. Police Department Attached is the latest case and arrest report from the police department. 9. Human Resources Over (77) personnel attended one of three Harassment Awareness training classes, which is a mandatory annual training for all city employees. This year the presenter was State Human Rights Investigator Tam Newby, who resides in the Kalispell area. Tam's presentation included what is and is not considered unlawful harassment and/or discrimination as defined by both federally and/or Montana state law and some differences between them. Included in the presentation was a review of the cities specific policies related to harassment. Those employees unable to be there in person are being required to view one of the videotaped of sessions and be signed off by their supervisor. 5 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Pagel of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 51,252 5,418,805 5,367,553 99% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 0 24,090 24,090 100% 1000-000-311200-000 PERSONAL PROPERTY TAXES 95,514 112,000 16,486 15% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 2,361 10,000 7,639 76% 1000-000-322101-000 BEER & LIQUOR LICENSES 1,286 30,000 28,714 96% 1000-000-322300-000 BUSINESS LICENSES 102 1,350 1,248 92% 1000-000-323012-000 PLANNING FEES 9,942 38,000 28,058 74% 1000-000-323109-000 SITE REVIEW 5,081 13,000 7,919 61% 1000-000-323200-000 PARADE PERMITS 200 1,000 800 80% 1000-000-323300-000 ANIMAL LICENSES 391 2,000 1,610 80% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 1,000 1,000 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 75 60,000 59,925 100% 1000-000-335110-000 LIVE CARD TABLE PERMIT 0 3,000 3,000 100% 1000-000-335230-000 HB124 ENTITLEMENT 696,987 2,765,228 2,068,241 75% 1000-000-341020-000 ADMINISTRATIVE CHARGES 132,107 542,726 410,620 76% 1000-000-341021-000 GRANT ADMIN FEES 3,950 10,000 6,050 61% 1000-000-341025-000 CITY COLLECTIONS 4 8,000 7,996 100% 1000-000-342010-000 POLICE SERVICES 10,557 25,000 14,443 58% 1000-000-342014-000 RESOURCE OFFICERS 97,410 97,410 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 525 10,000 9,475 95% 1000-000-342020-000 FIRE CHG/TEST FEES/SPEC EVENTS/INST 5 0 5- 0% 1000-000-343018-000 PARKING PERMITS 25,528 95,000 69,472 73% 1000-000-351000-000 CITY COURT FINES & FEES 87,306 500,000 412,694 83% 1000-000-351016-000 DUI COURT FINE 240 0 240- 0% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 3,609 30,000 26,391 88% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 10,999 35,000 24,001 69% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 3,399 20,000 16,601 83% 1000-000-362020-000 MMIA GASB 54 REIMBURSEMENT 0 3,000 3,000 100% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 549 5,000 4,451 89% 1000-000-365018-000 BANDSHELL CONTRIBUTIONS 0 250 250 100% 1000-000-371010-000 INVESTMENT EARNINGS 3,306 7,000 3,694 53% 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 0 850,000 850,000 100% TOTAL GENERAL FUND REVENUE 1,242,684 10,734,109 9,491,425 88% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 2 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete 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 0 14,250 14,250 100% 1000-400-410530-354 OPEB EXPENSE 0 6,700 6,700 100% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 932 4,500 3,568 79% 1000-400-410560-312 POSTAGE 1,874 21,000 19,126 91% 1000-400-410560-320 PRINTING & ENVELOPES 1,248 4,500 3,253 72% 1000-400-410600-354 ELECTIONS 0 16,000 16,000 100% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 1,439 3,500 2,061 59% 1000-400-420000-354 CONTRACT 911 CENTER 0 473,659 473,659 100% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 0 350 350 100% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 0 15,000 15,000 100% 1000-400-460452-366 HOCKADAY MAINTENANCE 0 6,600 6,600 100% 1000-400-510300-000 CONTINGENCY 0 30,000 30,000 100% 1000-400-510310-354 ICMA PLAN FEES 125 500 375 75% 1000-400-510330-513 LIABILITY INSURANCE 122,255 122,255 0 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 3,329 50,000 46,671 93% 1000-400-510330-517 PROPERTY INSURANCE 45,800 45,800 0 0% SUBTOTAL GEN.GOV'T. 177,002 817,549 640,547 78% CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 1000-401-410210-153 HEALTH INSURANCE 1000-401-410210-155 RETIREMENT 1000-401-410210-210 COMPUTER SOFTWARE/SUPPLIES 1000-401-410210-312 NEWSLETTER/BOOKS 1000-401-410210-345 TELEPHONE & COMMUNICATION 1000-401-410210-373 DUES & TRAINING 1000-401-410210-379 MEETINGS SUBTOTAL CITY MANAGER HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 1000-401-410830-153 HEALTH INSURANCE 1000-401-410830-155 RETIREMENT 1000-401-410830-210 OFFICE SUPPLIES 1000-401-410830-338 RECRUITMENT/RELOCATION 1000-401-410830-354 CONTRACT SERVICES 1000-401-410830-373 DUES & TRAINING SUBTOTAL HUMAN RESOURCES 28,625 135,220 106,595 79% 2,705 21,024 18,319 87% 3,071 14,287 11,216 79% 0 300 300 100% 0 400 400 100% 160 1,080 920 85% 1,366 20,500 19,134 93% 0 3,300 3,300 100% 35,927 196,111 160,184 82% 26,574 122,095 95,521 78% 3,018 18,116 15,098 83% 2,031 9,223 7,192 78% 5 600 595 99% 1,520 7,200 5,680 79% 80 1,000 920 92% 525 4,300 3,775 88% 33,754 162,534 128,780 79% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 3 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 1000-402-410100-110 1000-402-410100-153 1000-402-410100-155 1000-402-410100-210 1000-402-410100-335 1000-402-410100-354 1000-402-410100-373 1000-402-410100-379 MAYOR/COUNCIL SALARIES-MAYOR/COUNCIL HEALTH INSURANCE RETIREMENT OFFICE SUPPLIES MT LEAGUE OF CITIES CONTRACT SERVICES DUES & TRAINING MEETINGS SUBTOTAL MAYOR/COUNCIL 14,166 63,107 48,941 78% 8,904 45,792 36,888 81% 555 2,428 1,873 77% 0 100 100 100% 0 5,000 5,000 100% 293 2,000 1,707 85% 6,377 6,000 377- -6% 0 8,250 8,250 100% 30,294 132,677 102,383 77% CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 19,038 87,628 68,590 78% 1000-402-410150-121 OVERTIME 82 250 168 67% 1000-402-410150-153 HEALTH INSURANCE 3,125 18,761 15,636 83% 1000-402-410150-155 RETIREMENT 1,465 6,650 5,185 78% 1000-402-410150-210 OFFICE SUPPLIES 0 700 700 100% 1000-402-410150-345 TELEPHONE & COMMUNICATION 80 480 400 83% 1000-402-410150-352 RECODIFICATION 0 3,700 3,700 100% 1000-402-410150-354 CONTRACT SERVICES 0 25 25 100% 1000-402-410150-373 DUES & TRAINING 0 2,500 2,500 100% SUBTOTAL CITY CLERK 23,789 120,694 96,905 80% 1000-403-410550-110 1000-403-410550-153 1000-403-410550-155 1000-403-410550-210 1000-403-410550-322 1000-403-410550-353 1000-403-410550-354 1000-403-410550-355 1000-403-410550-373 FINANCE DEPARTMENT SALARIES -FINANCE OFFICE HEALTH INSURANCE RETIREMENT SUPPLIES BOOKS CONTRACT SERVICES CONTRACT -GRIZZLY SECURITY BANK CHARGES & FEES DUES & TRAINING SUBTOTAL FINANCE 45,623 216,869 171,246 79% 5,861 38,990 33,129 85% 3,477 16,442 12,965 79% 0 400 400 100% 0 250 250 100% 0 2,000 2,000 100% 605 1,500 895 60% 799 3,500 2,701 77% 1,868 6,500 4,632 71% 58,234 286,451 228,217 80% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 4 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 70,183 353,043 282,860 80% 1000-404-411110-153 HEALTH INSURANCE 7,477 50,835 43,358 85% 1000-404-411110-155 RETIREMENT 5,355 26,780 21,425 80% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 399 2,500 2,101 84% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 811 8,000 7,189 90% 1000-404-411110-345 TELEPHONE & COMMUNICATION 178 1,000 822 82% 1000-404-411110-354 CONTRACT SERVICES 1,197 1,500 303 20% 1000-404-411110-373 DUES & TRAINING 1,430 7,000 5,570 80% SUBTOTAL CITY ATTORNEY 87,030 450,658 363,628 81% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 49,275 226,725 177,450 78% 1000-406-410360-153 HEALTH INSURANCE 7,053 42,330 35,277 83% 1000-406-410360-155 RETIREMENT 3,756 17,149 13,393 78% 1000-406-410360-210 SUPPLIES 600 4,500 3,900 87% 1000-406-410360-320 PRINTING/BOOKS 44 1,500 1,456 97% 1000-406-410360-345 TELEPHONE & COMMUNICATION 22 1,400 1,378 98% 1000-406-410360-353 SECURITY & TECHNOLOGY 381 40,000 39,619 99% 1000-406-410360-354 CONTRACT SERVICES 23 5,750 5,727 100% 1000-406-410360-373 DUES & TRAINING 1,109 6,300 5,191 82% 1000-406-410360-394 JURY & WITNESS FEES 576 5,750 5,174 90% SUBTOTAL COURT 62,838 351,404 288,566 82% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 3,851 17,364 13,513 78% 1000-410-430100-112 SEVERANCE 0 800 800 100% 1000-410-430100-153 HEALTH INSURANCE 490 2,943 2,453 83% 1000-410-430100-155 RETIREMENT 290 1,287 997 77% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 2,365 7,500 5,135 68% 1000-410-430100-231 GAS 143 2,500 2,357 94% 1000-410-430100-345 TELEPHONE & COMMUNICATION 94 285 191 67% 1000-410-430100-354 CONTRACT SERVICES 0 1,850 1,850 100% 1000-410-430100-373 DUES & TRAINING 237 1,500 1,263 84% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 1,152 4,609 3,457 75% SUBTOTAL PUBLIC WORKS ADMIN 8,623 40,638 32,015 79% CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 14,417 67,207 52,790 79% 1000-412-411230-153 HEALTH INSURANCE 2,591 15,550 12,959 83% 1000-412-411230-155 RETIREMENT 1,060 4,872 3,812 78% 1000-412-411230-220 SECURITY IMPROVEMENTS 0 800 800 100% 1000-412-411230-224 JANITORIAL SUPPLIES 432 6,000 5,568 93% 1000-412-411230-241 TOOLS & SUPPLIES 0 1,500 1,500 100% 1000-412-411230-341 ELECTRICITY 9,260 47,500 38,240 81% 1000-412-411230-344 NATURAL GAS 2,844 40,000 37,156 93% 1000-412-411230-345 TELEPHONE & COMMUNICATION 46 250 204 82% 1000-412-411230-354 CONTRACT SERVICES 2,830 13,500 10,670 79% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 5 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-355 HVAC MAINTENANCE OCNTRACT 15,932 17,300 1,368 8% 1000-412-411230-361 ANNUAL MAINTENANCE CONTRACT 0 4,500 4,500 100% 1000-412-411230-362 EQUIPMENT MAINTENANCE 300 8,000 7,700 96% 1000-412-411230-366 BUILDING MAINTENANCE 1,846 20,000 18,154 91% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 81 3,500 3,420 98% 1000-412-411230-920 BLDG IMPROVEMENT 0 28,700 28,700 100% SUBTOTAL CITY HALL 51,639 279,179 227,540 82% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 57,108 272,988 215,880 79% 1000-420-411020-153 HEALTH INSURANCE 8,284 49,726 41,442 83% 1000-420-411020-155 RETIREMENT 4,362 20,677 16,315 79% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 84 5,000 4,916 98% 1000-420-411020-231 GAS 34 400 366 91% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 224 2,000 1,776 89% 1000-420-411020-345 TELEPHONE 212 750 538 72% 1000-420-411020-354 CONTRACT SERVICES 0 700 700 100% 1000-420-411020-373 DUES & TRAINING 1,909 5,000 3,091 62% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 178 713 535 75% SUBTOTAL PLANNING DEPT. 72,394 357,954 285,560 80% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 9,767 45,105 35,338 78% 1000-480-470210-153 HEALTH INSURANCE 954 5,724 4,770 83% 1000-480-470210-155 RETIREMENT 747 3,586 2,839 79% 1000-480-470210-210 OFFICE SUPPLIES 0 1,500 1,500 100% 1000-480-470210-312 POSTAGE & PRINTING 0 500 500 100% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 500 500 0 0% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 121 750 629 84% 1000-480-470210-354 CONTRACT SERVICES 0 1,000 1,000 100% 1000-480-470210-373 DUES & TRAINING 2,318 3,000 682 23% 1000-480-470210-379 MEETINGS 0 500 500 100% SUBTOTAL COMMUNITY DEVELOPMENT 14,406 62,165 47,759 77% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 6 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 448,185 2,054,055 1,605,870 78% 1000-413-420140-112 SALARIES -SEVERANCE 0 35,000 35,000 100% 1000-413-420140-114 SALARY -comptime buyout 3,228 4,000 772 19% 1000-413-420140-121 OVERTIME (REG & AET OT) 22,792 75,000 52,208 70% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 5,722 25,000 19,278 77% 1000-413-420140-153 HEALTH INSURANCE 61,622 393,313 331,691 84% 1000-413-420140-155 RETIREMENT 57,305 266,975 209,670 79% 1000-413-420140-210 OFFICE SUPPLIES 354 3,500 3,146 90% 1000-413-420140-215 COMPUTER SUPPLIES 2,837 5,500 2,663 48% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 1,710 18,500 16,790 91% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 329 4,000 3,671 92% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 120 7,000 6,880 98% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 0 2,000 2,000 100% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 504 5,000 4,496 90% 1000-413-420140-227 AMMO & RELATED SUPPLIES 1,950 19,000 17,050 90% 1000-413-420140-228 PATROL CAR SUPPLIES 4,121 13,000 8,879 68% 1000-413-420140-229 OTHER SUPPLIES 116 3,500 3,384 97% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 667 1,000 333 33% 1000-413-420140-231 GAS 11,721 95,000 83,279 88% 1000-413-420140-234 CRISIS NEGOTIATIONS 0 2,000 2,000 100% 1000-413-420140-235 BIKE PATROL 107 750 643 86% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 0 1,500 1,500 100% 1000-413-420140-320 PRINTING 330 5,000 4,670 93% 1000-413-420140-345 TELEPHONE & COMMUNICATION 2,574 15,500 12,927 83% 1000-413-420140-354 CONTRACT SERVICES 2,769 6,000 3,231 54% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 0 9,000 9,000 100% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 0 2,000 2,000 100% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 0 2,000 2,000 100% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 11,510 17,500 5,990 34% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 107 2,500 2,393 96% 1000-413-420140-373 DUES & TRAINING 6,912 30,000 23,088 77% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 1,022 10,000 8,978 90% 1000-413-420140-380 TRAINING MATERIALS 125 2,000 1,875 94% 1000-413-420140-388 MEDICAL SERVICES 0 2,500 2,500 100% 1000-413-420140-392 BOARDING/TREATING PRISONERS 151 2,500 2,349 94% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 20,105 80,420 60,315 75% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 14,375 57,500 43,125 75% 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 8,641 34,562 25,922 75% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 875 3,500 2,625 75% 1000-413-420140-944 VEHICLES 0 121,000 121,000 100% SUBTOTAL POLICE DEPT. 692,888 3,438,075 2,745,187 80% DETECTIVES 1000-413-420141-110 SALARIES -DETECTIVES 79,738 357,372 277,634 78% 1000-413-420141-121 DETECTIVE -OVERTIME 760 15,000 14,240 95% 1000-413-420141-153 HEALTH INSURANCE 9,387 62,325 52,938 85% 1000-413-420141-155 DETECTIVE -RETIREMENT 10,189 47,812 37,623 79% TOTAL DETECTIVES 100,073 482,509 382,436 79% RECORDS 1000-413-420142-110 SALARIES -RECORDS DIVISION 26,909 115,309 88,400 77% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 7 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-121 OVERTIME 1,466 7,500 6,034 80% 1000-413-420142-153 HEALTH INSURANCE 3,816 22,896 19,080 83% 1000-413-420142-155 RETIREMENT 2,152 8,703 6,551 75% TOTAL RECORDS 34,343 154,408 120,065 78% RESOURCE OFFICERS 1000-413-420144-110 SALARIES -SRO 26,925 123,825 96,900 78% 1000-413-420144-153 HEALTH INSURANCE 4,274 27,066 22,792 84% 1000-413-420144-155 SRO RETIREMENT 3,375 16,594 13,219 80% TOTAL RESOURCE OFFICERS 34,574 167,485 132,911 79% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL -SALARIES 9,423 39,448 30,025 76% 1000-413-420145-121 OVERTIME 13 500 487 98% 1000-413-420145-153 HEALTH INSURANCE 1,272 10,132 8,860 87% 1000-413-420145-155 RETIREMENT 652 2,976 2,324 78% SUBTOTAL ANIMAL CONTROL 11,360 53,056 41,696 79% PARKING 1000-413-420147-110 PARKINGS -SALARIES 19,489 87,532 68,043 78% 1000-413-420147-153 HEALTH INSURANCE 4,717 28,319 23,602 83% 1000-413-420147-155 RETIREMENT 1,424 6,600 5,176 78% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 441 4,000 3,559 89% 1000-413-420147-354 CONTRACTED SERVICES 58 2,000 1,942 97% 1000-413-420147-362 LOT MAINT 214 10,000 9,786 98% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 0 17,500 17,500 100% 1000-413-420147-550 LOT LEASE PAYMENTS 366 1,500 1,134 76% SUBTOTAL PARKING 26,708 157,451 130,743 83% SUBTOTAL POLICE DEPT. 899,946 4,452,984 3,553,038 80% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 8 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ACCOUNT NUMBER DESC. FIRE DEPARTMENT 1000-416-420400-110 SALARIES -FIRE SUPPRESSION 343,469 1,548,410 1,204,941 78% 1000-416-420400-114 COMPTIME BUYOUT 0 5,500 5,500 100% 1000-416-420400-115 OUT OF RANK PAY 3,660 10,000 6,340 63% 1000-416-420400-121 OVERTIME 17,314 40,000 22,686 57% 1000-416-420400-153 HEALTH INSURANCE 46,993 286,204 239,211 84% 1000-416-420400-155 RETIREMENT 46,592 207,394 160,802 78% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 66 2,000 1,934 97% 1000-416-420400-218 Equipment (Non Capital) 12,601 35,550 22,949 65% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 4,801 15,000 10,199 68% 1000-416-420400-224 JANITORIAL SUPPLIES 277 2,500 2,223 89% 1000-416-420400-231 GAS 1,708 17,325 15,617 90% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 3,450 15,000 11,550 77% 1000-416-420400-320 PRINTING 59 200 142 71% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 7 1,000 993 99% 1000-416-420400-345 TELEPHONE & COMMUNICATION 855 6,000 5,145 86% 1000-416-420400-354 CONTRACT SERVICES 3,656 6,000 2,345 39% 1000-416-420400-362 EQUIPMENT MAINTENANCE 3,771 5,500 1,729 31% 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 200 5,000 4,800 96% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 1,686 5,000 3,314 66% 1000-416-420400-373 DUES & TRAINING 1,358 10,000 8,643 86% 1000-416-420400-388 FIREFIGHTER PHYSICALS 0 22,500 22,500 100% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 8,043 32,172 24,129 75% 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 16,672 16,673 1 0% 1000-416-420400-620 INTEREST EXPENSE -FIRE TRUCK 103 208 105 50% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 95,000 380,000 285,000 75% 1000-416-420440-110 SALARIES -FIRE PREVENTION 10,788 49,802 39,014 78% 1000-416-420440-121 OVERTIME 1,013 0 1,013- 0% 1000-416-420440-153 HEALTH INSURANCE 1,314 7,340 6,026 82% 1000-416-420440-155 RETIREMENT 860 3,587 2,727 76% SUBTOTAL FIRE DEPT. 626,316 2,735,865 2,109,549 77% GRAND TOTAL GENERAL FUND 2,182,191 10,446,863 8,264,672 79% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 9 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete 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 0 1,600 1,600 100% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 2,169 8,674 6,505 75% 2185-000-430300-840 REDEVELOPMENT ACTIVITY 0 1,250,000 1,250,000 100% 2185-480-470240-110 SALARIES 4,033 19,067 15,034 79% 2185-480-470240-153 HEALTH INSURANCE 445 2,721 2,276 84% 2185-480-470240-155 RETIREMENT 308 1,438 1,130 79% 2185-480-470240-345 TELEPHONE & COMMUNICATION 12 48 36 75% TOTAL AIRPORT TIF 6,967 1,283,548 1,276,581 99% 2188 WESTSIDE TIF 2188-480-470230-110 SALARIES 8,336 39,760 31,424 79% 2188-480-470230-153 HEALTH INSURANCE 827 5,161 4,334 84% 2188-480-470230-155 RETIREMENT 637 2,989 2,352 79% 2188-480-470230-353 AUDIT 0 2,000 2,000 100% 2188-480-470230-356 TELEPHONE 48 0 48- 0% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 799 3,198 2,399 75% 2188-480-470230-710 LOAN REVOLVING FUNDS 0 1,500,000 1,500,000 100% 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 160,785 2,500,000 2,339,215 94% 2188-480-470230-840 TRANSFER TO DEBT SERVICE 8,085 32,340 24,255 75% TOTAL WESTSIDE TIF 179,517 4,085,448 3,905,931 96% OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 12,000 12,000 100% 2310-480-470210-356 FED -EX REIMBURSEMENT 0 17,000 17,000 100% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT 15,000 60,000 45,000 75% 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT 2,500 10,000 7,500 75% TOTAL OLD SCHOOL TIFS 17,500 99,000 81,500 82% PERMISSIVE HEALTH LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND TOTAL PERMISSIVE HEALTH LEVY 0 936,000 936,000 100% 0 936,000 936,000 100% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 10 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete 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% 3,916 10,000 6,084 61% 2399-413-420140-940 POLICE EQUIPMENT 0 50,000 50,000 100% 2399-416-420400-610 PRINCIPAL - FIRE TRUCK 31,000 31,500 500 2% 2399-416-420400-620 INTEREST - FIRE TRUCK 3,947 3,585 362- -10% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 400,000 400,000 100% TOTAL PUBLIC SAFETY IMPACT FEE 38,863 495,085 456,222 92% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 11 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete 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 8,040 864,000 855,960 99% 2215-000-311200-000 PERSONAL PROPERTY TAXES 15,919 35,000 19,081 55% 2215-000-312000-000 PEN & INTEREST DEL TAXES 394 2,000 1,606 80% 2215-000-334110-000 DEPT PUBLIC HEALTH AFTER SCHOOL GRT 0 10,000 10,000 100% 2215-000-334111-000 ACTIVE COMM. FY14; OUT OF SCHOOL TI 0 5,000 5,000 100% 2215-000-346030-000 SWIMMING POOL FEES 68,473 140,000 71,527 51% 2215-000-346040-000 CONCESSION STAND REVENUE 23,680 34,000 10,320 30% 2215-000-346050-000 PARKS USAGE FEES 6,861 19,500 12,639 65% 2215-000-346051-000 RECREATION FEES 578 8,000 7,422 93% 2215-000-346052-000 SPORTS PROGRAMS 11,071 44,055 32,984 75% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 1,613 2,000 387 19% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 14,171 65,160 50,989 78% 2215-000-346055-000 ICE RINK 0 25,000 25,000 100% 2215-000-346056-000 KIDSPORT USAGE 50 700 650 93% 2215-000-346057-000 YOUTH CAMPS 7,813 132,000 124,187 94% 2215-000-346059-000 PICNIC IN THE PARK 4,849 32,000 27,151 85% 2215-000-365010-000 FEC REFUNDS/DONATIONS 3,798 0 3,798- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-365016-000 FLATHEAD INDUSTRIES REIMBURSEMENT 175 4,500 4,325 96% 2215-000-371010-000 INVESTMENTS 538 2,000 1,462 73% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 0 86,000 86,000 100% TOTAL PARKS & REC REVENUE 168,022 1,530,915 1,362,893 89% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 68,221 314,562 246,341 78% 2215-436-460430-111 SEASONAL SALARIES 24,179 61,727 37,548 61% 2215-436-460430-121 OVERTIME 0 500 500 100% 2215-436-460430-153 HEALTH INSURANCE 9,510 69,412 59,902 86% 2215-436-460430-155 RETIREMENT 6,616 27,488 20,872 76% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 89 1,000 912 91% 2215-436-460430-224 JANITORIAL SUPPLIES 1,686 4,100 2,414 59% 2215-436-460430-229 OTHER SUPPLIES 678 4,000 3,322 83% 2215-436-460430-231 GAS 3,481 18,000 14,519 81% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 60 2,500 2,440 98% 2215-436-460430-320 PRINTING & ADVERTISING 0 400 400 100% 2215-436-460430-341 ELECTRICITY 3,348 16,000 12,652 79% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 0 25,000 25,000 100% 2215-436-460430-344 NATURAL GAS 76 3,000 2,924 97% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 732 2,800 2,068 74% 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. 0 9,000 9,000 100% 2215-436-460430-356 CONSULTANTS 0 500 500 100% 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 0 2,680 2,680 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 1,404 4,000 2,596 65% 2215-436-460430-364 LANDSCAPING 779 4,000 3,221 81% 2215-436-460430-367 VANDALISM REPAIRS 830 4,000 3,170 79% 2215-436-460430-373 DUES & TRAINING 861 6,000 5,139 86% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 0 600 600 100% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 12 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 0 3,000 3,000 100% 2215-436-460430-440 IRRIGATION SUPPLIES 4,108 7,500 3,392 45% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 0 1,700 1,700 100% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 9,918 39,673 29,755 75% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 5,219 10,437 5,218 50% 2215-436-460430-620 DEBT SERVICE INTEREST 178 349 171 49% 2215-436-460430-941 PLAYGROUND EQUIP - (LAWRENCE PARK) 0 40,500 40,500 100% 2215-436-460430-942 FVCC TENNIS INTERLOCAL AGREEMENT 0 7,000 7,000 100% SUBTOTAL PARKS EXPENDITURES 141,973 695,428 553,455 80% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 13,754 62,551 48,797 78% 2215-436-460440-111 SEASONAL SALARIES 20,722 49,778 29,056 58% 2215-436-460440-153 HEALTH INSURANCE 1,964 19,032 17,068 90% 2215-436-460440-155 RETIREMENT 1,878 6,472 4,594 71% 2215-436-460440-221 SAFETY EQUIPMENT 0 350 350 100% 2215-436-460440-229 OTHER SUPPLIES 6,927 14,500 7,573 52% 2215-436-460440-231 GAS 2,954 10,200 7,246 71% 2215-436-460440-241 CONSUMABLE TOOLS 500 1,500 1,000 67% 2215-436-460440-341 ELECTRICITY 3,351 7,700 4,349 56% 2215-436-460440-345 TELEPHONE & COMMUNICATION 37 175 138 79% 2215-436-460440-354 CONTRACT SERVICES 720 1,000 280 28% 2215-436-460440-362 EQUIPMENT MAINTENANCE 218 600 382 64% 2215-436-460440-364 LANDSCAPING 0 400 400 100% 2215-436-460440-367 VANDALISM REPAIRS 0 500 500 100% 2215-436-460440-373 DUES & TRAINING 0 300 300 100% 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 100% 2215-436-460440-420 METAL PRODUCTS 0 300 300 100% 2215-436-460440-440 IRRIGATION 1,246 4,000 2,754 69% 2215-436-460440-452 SAND & GRAVEL 216 1,000 784 78% 2215-436-460440-610 DEBT SERVICE -PRINCIPAL 7,367 14,731 7,364 50% 2215-436-460440-620 DEBT SERVICE -INTEREST 91 138 47 34% SUBTOTAL ATHLETIC COMPLEX 61,945 195,377 133,432 68% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 3,430 76,816 73,386 96% 2215-436-460431-111 SEASONAL SALARIES 4,741 8,244 3,503 42% 2215-436-460431-112 SEVERANCE 0 15,000 15,000 100% 2215-436-460431-153 HEALTH INSURANCE 816 23,280 22,464 96% 2215-436-460431-155 RETIREMENT 260 6,373 6,113 96% 2215-436-460431-229 MISC. SUPPLIES 1,440 8,264 6,824 83% 2215-436-460431-231 GAS 185 500 315 63% 2215-436-460431-320 PRINTING & ADVERTISING 199 10,500 10,301 98% 2215-436-460431-345 TELEPHONE & COMMUNICATION 0 240 240 100% 2215-436-460431-354 CONTRACT SERVICES 15,357 18,632 3,275 18% 2215-436-460431-357 MUSIC FRANCHISE FEES 0 1,000 1,000 100% 2215-436-460431-373 DUES & TRAINING 86 600 514 86% SUBTOTAL RECREATION 26,515 169,449 142,934 84% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 4,384 61,207 56,823 93% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 13 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 2215-436-460448-111 SEASONAL SALARIES 62,109 126,562 64,453 51% 2215-436-460448-121 OVERTIME 114 300 186 62% 2215-436-460448-153 HEALTH INSURANCE 636 24,363 23,727 97% 2215-436-460448-155 RETIREMENT 333 6,443 6,110 95% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 57 400 343 86% 2215-436-460448-229 MISC. SUPPLIES 321 3,800 3,479 92% 2215-436-460448-231 GAS 0 500 500 100% 2215-436-460448-320 PRINTING & ADVERTISING 0 150 150 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 85 620 535 86% 2215-436-460448-354 CONTRACT SERVICES 12,544 16,710 4,166 25% 2215-436-460448-355 AFTER SCHOOL PROGRAM 0 800 800 100% 2215-436-460448-356 BANK FEES/CC CHARGES 779 3,900 3,121 80% 2215-436-460448-357 OUT OF SCHOOL TIMES PROGRAM GRANT 5,955 20,000 14,045 70% 2215-436-460448-373 DUES & TRAINING 69 500 431 86% SUBTOTAL YOUTH CAMPS 87,386 266,255 178,869 67% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 116,988 190,325 73,337 39% 2215-437-460445-121 OVERTIME 35 500 465 93% 2215-437-460445-155 RETIREMENT 915 1,500 585 39% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 156 400 244 61% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,206 2,000 794 40% 2215-437-460445-226 CHLORINE/CHEMICALS 13,999 23,000 9,001 39% 2215-437-460445-228 CONCESSION STAND SUPPLIES 8,575 20,000 11,425 57% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 1,126 5,000 3,874 77% 2215-437-460445-341 ELECTRICITY 3,746 10,000 6,254 63% 2215-437-460445-344 NATURAL GAS 13,302 25,000 11,698 47% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 411 1,500 1,089 73% 2215-437-460445-354 LICENSES & FEES 62 1,300 1,238 95% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 1,623 34,000 32,377 95% 2215-437-460445-380 TRAINING MATERIALS 1,187 800 387- -48% SUBTOTAL POOL EXPENDITURES 163,331 315,325 151,994 48% TOTAL PARKS & RECREATION/POOL 481,150 1,641,834 1,160,684 71% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 14 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING FORESTRY & DEVELOPER TREES 2600-436-460433-110 SALARIES -URBAN FORESTRY 21,762 101,667 79,905 79% 2600-436-460433-111 SEASONAL SERVICES 1,070 7,658 6,588 86% 2600-436-460433-121 OVERTIME 0 300 300 100% 2600-436-460433-153 HEALTH INSURANCE 3,234 22,404 19,170 86% 2600-436-460433-155 RETIREMENT 1,693 7,431 5,738 77% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 13 200 187 93% 2600-436-460433-231 GAS 34 1,500 1,466 98% 2600-436-460433-241 CONSUMABLE TOOLS 65 1,500 1,435 96% 2600-436-460433-354 CONTRACT SERVICES 6,400 45,000 38,600 86% 2600-436-460433-357 FORESTRY GRANT 0 10,000 10,000 100% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 1,650 6,750 5,100 76% 2600-436-460433-362 EQUIPMENT MAINTENANCE 313 700 387 55% 2600-436-460433-364 LANDSCAPING & TREES 1,950 4,000 2,050 51% 2600-436-460433-373 DUES & TRAINING 0 1,000 1,000 100% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 1,307 2,500 1,193 48% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 1,831 7,325 5,494 75% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 2,156 8,624 6,468 75% 2600-436-460433-528 DATA PROCESSING TRANSFER 1,047 4,120 3,073 75% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 4,190 12,853 8,663 67% 2600-436-460433-620 INTEREST EXPENSE 102 1,147 1,045 91% 2600-436-460433-940 MACHINERY & EQUIPMENT 0 45,000 45,000 100% TOTAL URBAN FORESTRY 48,817 291,679 242,862 83% 2601-436-460435-351 EMPIRE ESTATES ($44,911) 2601-436-460435-352 APPLEWAY ($4,564) 2601-436-460435-353 LEISURE HEIGHTS ($9,990) 2601-436-460435-354 CONTRACT SERVICES 2601-436-460435-356 SINOPAH SUBD ($5,790) 2601-436-460435-357 COTTONWOOD SUBD ($13,100) 2601-436-460435-358 WEST VIEW SUBD ($22,680) 2601-436-460435-359 MTN VISTA ESTATES ($35,903+34,660) 2601-436-460435-361 VILLAGE GREENS ($3,540) 2601-436-460435-362 WESTVIEW BUSINESS CNTR ($1,618) 2601-436-460435-363 MUSKRAT SLOUGH ($1,446) 2601-436-460435-364 MTN VISTA ESTATES III $17,278.25 2601-436-460435-365 VILLAGE GREENS $3,540 2601-436-460435-366 W VIEW ESTATES $20,060 2601-436-460435-367 ABIGAIL SUBDIVISION ($4,253.90) 2601-436-460435-368 NORTHLAND SUBD PHASE 4 TOTAL DEVELOPER TREES 2210 PARKS IN LIEU 2210-436-460430-934 CAPITAL IMPROVEMENTS TOTAL PARKS IN LIEU 2975 TRAILS 2975-436-460457-951 HWY93 NORTH TRAIL 0 8,653 8,653 100% 0 4,336 4,336 100% 0 366 366 100% 0 4,298 4,298 100% 0 667 667 100% 325 2,253 1,928 86% 325 17,536 17,211 98% 0 27,079 27,079 100% 0 2,219 2,219 100% 0 948 948 100% 0 1,390 1,390 100% 0 1,134 1,134 100% 0 2,797 2,797 100% 0 8,490 8,490 100% 0 3,074 3,074 100% 0 8,812 8,812 100% 650 94,052 93,402 99% 0 1,277 1,277 100% 0 1,277 1,277 100% 0 11,000 11,000 100% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 15 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. TOTAL TRAILS 0 11.000 11.000 100% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 16 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete 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 137,519 621,000 483,481 78% 2230-000-342070-000 COUNTY EMS LEVY 0 120,000 120,000 100% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 95,000 380,000 285,000 75% TOTAL AMBULANCE REVENUE 232,519 1,121,000 888,481 79% AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 129,032 593,366 464,334 78% 2230-440-420730-114 COMPTIME BUYBACK 0 3,500 3,500 100% 2230-440-420730-115 OUT OF RANK PAY 115 1,000 885 89% 2230-440-420730-121 OVERTIME 4,814 25,000 20,186 81% 2230-440-420730-153 HEALTH INSURANCE 22,632 146,576 123,944 85% 2230-440-420730-155 RETIREMENT 17,128 78,481 61,353 78% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 444 1,000 556 56% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 0 4,000 4,000 100% 2230-440-420730-231 GAS & OIL 963 7,560 6,597 87% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 578 4,000 3,422 86% 2230-440-420730-312 POSTAGE/PRINTING 0 1,500 1,500 100% 2230-440-420730-345 TELEPHONE & COMMUNICATION 263 1,200 937 78% 2230-440-420730-354 PARAMEDIC RECERTIFICATION 1,559 11,800 10,241 87% 2230-440-420730-355 911 CENTER CONTRIBUTION 0 33,145 33,145 100% 2230-440-420730-359 AUDIT/CC OTHER FEES 292 1,400 1,108 79% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 754 5,000 4,246 85% 2230-440-420730-373 DUES & TRAINING 0 5,000 5,000 100% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,500 2,500 100% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 8,846 40,000 31,154 78% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 8,215 6,000 2,215- -37% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 3,976 15,903 11,927 75% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 9,803 39,213 29,410 75% 2230-440-420730-528 DATA PROCESSING TRANSFER 4,187 16,482 12,295 75% 2230-440-420730-821 TRANSFER TO FUND 2956 GRANT MATCH 0 11,100 11,100 100% 2230-440-420730-940 EQUIPMENT 0 170,000 170,000 100% TOTAL AMBULANCE EXPENDITURES 213,601 1,224,726 1,011,125 83% FIRE & HAZMAT GRANTS 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 813 10,825 10,012 92% 2956-416-420415-940 AFG GRANT - (3) POWER COTS 0 111,000 111,000 100% TOTAL FIRE GRANTS 813 121,825 121,012 99% 2957-416-420400-155 RETIREMENT 0 2,500 2,500 100% 2957-416-420410-125 PASS THRU HAZMAT OT 891 19,365 18,475 95% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 1,597 33,113 31,516 95% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 6,100 6,100 100% TOTAL HAZMAT GRANTS 2,488 61,078 58,590 96% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 17 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 174,503 250,000 75,497 30% 2394-000-323103-000 PLUMBING PERMITS 12,848 15,000 2,152 14% 2394-000-323104-000 MECHANICAL PERMITS 7,257 54,000 46,743 87% 2394-000-323108-000 PLAN REVIEW FEES 66,300 60,000 6,300- -11% 2394-000-371010-000 INVESTMENT EARNINGS 869 2,000 1,131 57% TOTAL REVENUE 261,777 381,000 119,223 31% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 63,922 303,451 239,529 79% 2394-420-420530-121 OVERTIME 1,519 5,000 3,481 70% 2394-420-420530-153 HEALTH INSURANCE 9,004 59,827 50,823 85% 2394-420-420530-155 RETIREMENT 4,813 22,001 17,188 78% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 3,857 20,000 16,143 81% 2394-420-420530-231 GAS & OIL 308 3,000 2,692 90% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 37 1,750 1,713 98% 2394-420-420530-323 ST. ED. ASSESSMENTS 0 2,500 2,500 100% 2394-420-420530-345 TELEPHONE & COMMUNICATION 583 3,500 2,917 83% 2394-420-420530-354 CONTRACT SERVICES 75 3,300 3,225 98% 2394-420-420530-355 CITY WORKS LICENSING FEE 13,268 13,000 268- -2% 2394-420-420530-373 DUES & TRAINING 289 6,000 5,711 95% 2394-420-420530-510 PROPERTY INSURANCE 4,731 6,000 1,269 21% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 437 1,748 1,311 75% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 3,393 13,573 10,180 75% 2394-420-420530-528 DATA PROCESSING TRANSFER 4,187 12,361 8,174 66% 2394-420-420530-930 WEB BASED SOFTWARE PACKAGE 0 11,000 11,000 100% TOTAL BUILDING DEPT. 110,423 488,011 377,588 77% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 18 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 17,175 74,292 57,117 77% 2400-410-430263-153 HEALTH INSURANCE 1,768 12,693 10,925 86% 2400-410-430263-155 RETIREMENT 1,243 5,291 4,048 77% 2400-410-430263-244 STREET LIGHT SUPPLIES 1,697 18,000 16,303 91% 2400-410-430263-341 ELECTRICITY 26,507 169,000 142,493 84% 2400-410-430263-360 REPAIR & MAINT SERVICES 179 20,000 19,821 99% 2400-410-430263-510 INSURANCE 908 1,000 92 9% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 3,911 15,643 11,732 75% 2400-410-490500-610 DEBT SERVICE -PRINCIPAL 10,798 21,647 10,849 50% 2400-410-490500-620 DEBT SERVICE -INTEREST EXPENSE 406 820 414 50% TOTAL LIGHT MAINT. 64,592 338,386 273,794 81% 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 16,405 50,000 33,595 67% 2420-421-430234-957 ALLEY PAVING 27,766 35,000 7,234 21% 2420-421-430240-231 GAS & OIL 4,270 43,000 38,730 90% 2420-421-430240-344 NATURAL GAS 54 5,500 5,446 99% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 136,000 136,000 100% 2420-421-430240-360 REPAIR & MAINT SERVICES 0 1,500 1,500 100% 2420-421-430240-368 OVERLAY/CHIPSEALS 125,100 230,661 105,562 46% 2420-421-430240-452 GRAVEL 200 3,500 3,300 94% 2420-421-430240-453 EQUIPMENT RENTAL 4,660 10,000 5,340 53% 2420-421-430240-471 DE-ICER/ROAD OIL 932 40,000 39,068 98% 2420-421-430240-472 ASPHALT 11,246 40,000 28,754 72% 2420-421-430240-473 CRACK SEALING 3,720 14,500 10,780 74% TOTAL GAS TAX 194,353 609,661 415,308 68% 2825 MACI GRANT 2825-421-430240-940 FLUSH TRUCK / SWEEPER 0 375,839 375,839 100% TOTAL MACI GRANT 0 375,839 375,839 100% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 19 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete 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. 142,496 662,559 520,063 78% 2500-421-430240-112 RETIREMENT -severance 0 2,300 2,300 100% 2500-421-430240-121 OVERTIME 1,308 25,000 23,692 95% 2500-421-430240-153 HEALTH INSURANCE 23,449 152,162 128,713 85% 2500-421-430240-155 RETIREMENT 10,418 46,905 36,487 78% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 1,842 9,000 7,158 80% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 912 6,000 5,088 85% 2500-421-430240-220 OTHER SUPPLIES 1,320 4,100 2,780 68% 2500-421-430240-231 GAS & OIL 4,453 44,000 39,547 90% 2500-421-430240-341 ELECTRICITY 414 3,000 2,586 86% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 379 1,500 1,121 75% 2500-421-430240-354 CONTRACT SERVICES 1,368 30,000 28,632 95% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 1,012 32,500 31,488 97% 2500-421-430240-366 BUILDING MAINTENANCE 230 3,000 2,770 92% 2500-421-430240-373 DUES & TRAINING 611 5,500 4,889 89% 2500-421-430240-388 MEDICAL SERVICES 135 1,500 1,365 91% 2500-421-430240-510 LIABILITY INSURANCE 19,015 20,500 1,485 7% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 359 10,000 9,641 96% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 41,341 165,366 124,025 75% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 20,676 82,703 62,027 75% 2500-421-430240-528 DATA PROCESSING TRANSFER 3,141 12,361 9,220 75% 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 55,257 110,804 55,547 50% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 2,065 4,167 2,102 50% 2500-421-430240-840 MACI GRANT MATCH 0 9,982 9,982 100% 2500-421-430240-921 SAND/COLD MIX STORAGE SHED 0 25,771 25,771 100% 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 86,669 537,040 450,371 84% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 79,121 270,000 190,879 71% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 100% 2500-421-430264-110 TSS - SALARIES 26,357 122,651 96,294 79% 2500-421-430264-121 OVERTIME 491 7,500 7,009 93% 2500-421-430264-153 HEALTH INSURANCE 2,544 16,264 13,720 84% 2500-421-430264-155 RETIREMENT 1,917 8,613 6,696 78% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 990 1,500 510 34% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 491 6,700 6,209 93% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 1,027 3,500 2,473 71% 2500-421-430264-242 STREET SIGNS 14,014 40,000 25,986 65% 2500-421-430264-243 TRAFFIC SIGNALS 738 19,000 18,262 96% 2500-421-430264-245 BARRICADE MATERIALS 3,224 5,000 1,776 36% 2500-421-430264-341 ELECTRICITY 251 3,000 2,749 92% 2500-421-430264-345 COMMUNICATIONS 184 750 566 76% 2500-421-430264-354 CONTRACT SERVICES 296 10,000 9,704 97% 2500-421-430264-362 EQUIPMENT MAINTENANCE 67 3,000 2,933 98% 2500-421-430264-366 BUILDING MAINTENANCE 0 2,000 2,000 100% 2500-421-430264-373 DUES & TRAINING 181 5,500 5,320 97% 2500-421-430264-428 PAINT MATERIALS 2,055 8,000 5,945 74% 2500-421-430264-510 LIABILITY INS.-TSS 2,424 2,500 76 3% 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 0 2,500 2,500 100% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 2,100 8,400 6,300 75% 2500-421-430264-532 OFFICE RENT 6,422 6,422 0 0% TOTAL SPEC. ST. MAINT. 563,763 2,588,348 2,024,585 78% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 20 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 0 1,370 1,370 100% 2880-480-470210-354 CONTRACT SERVICES 0 1,340 1,340 100% 2880-480-470210-711 REDEVELOPMENT 0 100,000 100,000 100% TOTAL LOAN REVOLVING 0 102,710 102,710 100% 2881 CD LOAN REV. #2 2881-480-470210-353 AUDITING 2881-480-470210-711 REDEVELOPMENT TOTAL 2881 CD REV. #2 2886 CD MISC. 2886-480-470210-211 GRANT ADMIN EXP / PROJECT EXP 2886-480-470210-353 AUDITING 2886-480-470210-355 CDBG SENIOR CENTER 2886-480-470210-373 DUES & TRAINING 2886-480-470210-379 MEETINGS 2886-480-470210-396 GRANT SERVICES 2886-480-470210-522 ADMINISTRATIVE TRANSFER 2886-480-470210-528 DATA PROCESSING TRANSFER 2886-480-470210-532 OFFICE RENT 2886-480-470210-790 COMM. DEV. ACTIVITIES 2886-480-470210-795 Redevelopment - Old School Station TOTAL CD MISC. 2887 RURAL DEVELOPMENT #1 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 2887-480-470210-620 INTEREST EXPENSE/L#61-01 2887-480-470210-750 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT #1 2888 RURAL DEVELOPMENT #2 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 2888-480-470210-750 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT #2 0 1,000 1,000 100% 0 150,000 150,000 100% 0 151,000 151,000 100% 0 2,000 2,000 100% 0 1,500 1,500 100% 0 30,000 30,000 100% 0 2,000 2,000 100% 0 1,000 1,000 100% 0 25,000 25,000 100% 0 4,000 4,000 100% 1,047 4,120 3,073 75% 1,175 1,175 0 0% 4,000 150,000 146,000 97% 3,298 200,000 196,702 98% 9,520 420,795 411,275 98% 0 18,092 18,092 100% 0 3,983 3,983 100% 51 150,000 149,949 100% 51 172,075 172,024 100% 0 10,250 10,250 100% 0 110,000 110,000 100% 0 120,250 120,250 100% 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES -PETROLEUM 0 908 908 100% 2955-480-470210-352 PERSONNEL -PETROLEUM 0 3,505 3,505 100% 2955-480-470210-353 FRINGES -PETROLEUM 0 493 493 100% 2955-480-470210-354 CONTRACTED SERVICES-PETROLUEM 0 1,605 1,605 100% 2955-480-470210-373 TRAVEL -PETROLEUM 0 35 35 100% 2955-480-470210-720 CLEANUP LOANS -PETROLEUM 0 62,354 62,354 100% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 21 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2955-480-470210-721 CLEANUP SUBGRANTS-PETRO 0 100,000 100,000 100% 2955-480-470210-725 REVOLVED FUNDS 0 100,500 100,500 100% 2955-480-470215-229 SUPPLIES -HAZARDOUS SUBSTANCES 0 2,458 2,458 100% 2955-480-470215-354 CONTRACT SERV-HAZARDOUS SUBST 0 9,921 9,921 100% 2955-480-470215-373 TRAVEL -HAZARDOUS SUBTSANCE 391 5,961 5,571 93% 2955-480-470215-720 CLEANUP LOANS -HAZARDOUS 0 314,600 314,600 100% 2955-480-470215-721 CLEANUP SUBGRANTS-HAZARDOUS 0 208,373 208,373 100% TOTAL BROWNFIELDS LOAN REV. 391 810,713 810,323 100% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 22 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2915 STONEGARDEN GRANT 2915-413-420140-121 OVERTIME & FRINGES - STONEGARDEN TOTAL 2915 STONEGARDEN GRANT 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 2916-413-420140-121 OVERTIME 2916-413-420140-153 HEALTH INSURANCE 2916-413-420140-155 RETIREMENT 2916-413-420140-354 CONTRACT SERVICES TOTAL 2916 DRUG ENFORCEMENT 2918 CHRP GRANT 2918-413-420140-110 SALARIES & PAYROLL COSTS 2918-413-420140-153 HEALTH INSURANCE 2918-413-420140-155 RETIREMENT TOTAL CHRP GRANT 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 2919-413-420140-125 DUI TASK FORCE 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 2919-413-420140-127 SCHOOL DIST. OT 2919-413-420140-218 SAG GRT-SERVER&CAMERAS/HEADSETS-HSG 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 2919-413-420140-940 SRT CAMERA TOTAL LAW ENF. GRANT 0 65,749 65,749 100% 0 65,749 65,749 100% 11,639 59,252 47,613 80% 2,760 7,500 4,740 63% 1,930 11,824 9,894 84% 1,413 7,949 6,536 82% 1,449 5,841 4,392 75% 19,191 92,366 73,175 79% 0 37,032 37,032 100% 0 16,242 16,242 100% 0 4,976 4,976 100% 0 58,250 58,250 100% 746 4,000 3,254 81% 0 8,000 8,000 100% 7,261 36,000 28,739 80% 3,723 20,000 16,277 81% 10,440 21,886 11,446 52% 2,649 2,500 149- -6% 0 7,000 7,000 100% 0 59,600 59,600 100% 24,820 158,986 134,167 84% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 23 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CAPITAL PROJECT FUNDS 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION TOTAL 4290 WALK & CURB 690 25,000 24,310 97% 690 25,000 24,310 97% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 24 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING ENTERPRISE FUNDS WATER REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 630 0 630- 0% 5210-000-343210-000 METERED WATER SALES 1,298,486 2,810,000 1,511,514 54% 5210-000-343220-000 UNMETERED WATER SALES 480 0 480- 0% 5210-000-343225-000 IMPACT FEES 268,252 285,000 16,748 6% 5210-000-343230-000 METER REPLACEMENT FEE 27,247 98,000 70,753 72% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 3,635 37,000 33,365 90% 5210-000-343270-000 WATER TURN ON FEES 635 3,000 2,365 79% 5210-000-343275-000 TAG FEE 4,520 10,000 5,480 55% 5210-000-343365-000 LATECOMER ADMIN FEE 0 15,000 15,000 100% 5210-000-371010-000 INVESTMENT EARNINGS 9,473 36,000 26,527 74% TOTAL WATER REVENUE 1,613,358 3,294,000 1,680,642 51% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 145,707 690,169 544,462 79% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-112 SALARIES -RETIREMENT 0 1,500 1,500 100% 5210-447-430550-121 OVERTIME 2,604 20,000 17,396 87% 5210-447-430550-153 HEALTH INSURANCE 20,034 146,271 126,237 86% 5210-447-430550-155 RETIREMENT 10,728 49,495 38,767 78% 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 3,530 11,000 7,470 68% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 1,162 8,500 7,338 86% 5210-447-430550-226 CHLORINE & CHEMICALS 6,631 38,000 31,369 83% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 621 4,500 3,879 86% 5210-447-430550-231 GAS & OIL 3,494 38,000 34,506 91% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 0 4,000 4,000 100% 5210-447-430550-336 LICENSES & FEES 0 18,000 18,000 100% 5210-447-430550-341 ELECTRICITY 39,699 139,000 99,301 71% 5210-447-430550-344 NATURAL GAS 367 15,500 15,133 98% 5210-447-430550-345 TELEPHONE & COMMUNICATION 2,354 9,000 6,646 74% 5210-447-430550-349 LAB SERVICES 1,957 22,000 20,043 91% 5210-447-430550-353 AUDITING 0 5,000 5,000 100% 5210-447-430550-354 CONTRACT SERVICES 2,195 55,000 52,805 96% 5210-447-430550-356 CONSULTANTS-WTR RIGHTS/MODELING 1,144 25,000 23,856 95% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 352 15,000 14,648 98% 5210-447-430550-366 BUILDING MAINTENANCE 770 12,000 11,230 94% 5210-447-430550-373 DUES & TRAINING 375 9,000 8,625 96% 5210-447-430550-388 MEDICAL SERVICES 50 800 750 94% 5210-447-430550-410 CONSTRUCTION MATERIALS 6,294 35,000 28,706 82% 5210-447-430550-422 HYDRANTS 641 8,000 7,359 92% 5210-447-430550-423 MATERIALS FOR MAINS 4,505 12,000 7,495 62% 5210-447-430550-424 MATERIALS -SERVICE LINES 1,117 16,000 14,883 93% 5210-447-430550-425 MATERIALS PUMPS/WELLS 332 45,000 44,668 99% 5210-447-430550-510 PROPERTY & LIABILITY INS. 22,452 25,000 2,548 10% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 0 15,000 15,000 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 4,532 18,130 13,598 75% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 24,606 98,426 73,820 75% 5210-447-430550-528 DATA PROCESSING TRANSFER 8,375 32,964 24,589 75% 5210-447-430550-532 LEASE PAYMENTS (City Hall rent) 6,422 7,984 1,562 20% 5210-447-430550-921 SAND/COLD MIX STORAGE SHED 0 25,771 25,771 100% 5210-447-430550-936 Noffsinger Spring Generator 0 90,000 90,000 100% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 25 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 5210-447-430550-937 SHEEPHERDER BACK UP POWER 179 5,157 4,978 97% 5210-447-430550-947 US 93N. UTILITY RELOCATE 0 11,634 11,634 100% 5210-447-430550-948 METERS (METER FUNDS) 010125 19,598 223,240 203,643 91% 5210-447-430550-951 SECURITY SCADA UPGRADES 0 15,000 15,000 100% 5210-447-430550-958 2ND AVE EAST MAIN REPLC & UPSIZE 0 174,000 174,000 100% 5210-447-430550-967 2ND AVE WN MAIN REPLC FROM MT TO WA 26,188 84,591 58,403 69% 5210-447-430550-969 4TH AVE E MAIN REPLC PHASE 1 0 494,000 494,000 100% 5210-447-430550-970 OLD SCHOOL WELL SAND SEPARATOR 0 20,000 20,000 100% 5210-447-430550-971 WESTVIEW WELL VFD UPGRADE 0 40,000 40,000 100% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 150,000 150,000 100% 5210-447-430555-941 METERS (NEW SERVICES)010120 19,598 64,623 45,026 70% 5210-447-430555-953 SECTION 36 WELL 0 626,000 626,000 100% SUBTOTAL WATER FACILITIES 388,610 3,679,255 3,290,645 89% WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 20,201 107,610 87,409 81% 5210-447-430560-112 SEVERANCE/RETIREMENT 0 1,500 1,500 100% 5210-447-430560-153 HEALTH INSURANCE 3,949 33,020 29,071 88% 5210-447-430560-155 RETIREMENT 1,526 8,014 6,488 81% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 133 5,000 4,867 97% 5210-447-430560-353 AUDITING 0 2,020 2,020 100% 5210-447-430560-354 CONTRACT SERVICES 0 1,500 1,500 100% 5210-447-430560-355 BILLING COSTS 7,483 70,000 62,517 89% 5210-447-430560-373 DUES & TRAINING 934 2,500 1,566 63% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 1,933 7,731 5,798 75% 5210-447-430560-528 DATA PROCESSING TRANSFER 8,375 37,000 28,625 77% 5210-447-430560-532 RENT 6,422 6,422 0 0% SUBTOTAL WATER BILLING 50,957 282,317 231,360 82% 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 31,695 31,695 0 0% 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 350 0 350- 0% 5210-447-490206-610 PRIN-MTR&WELL WRF7104 1.25%;WRF8114 0 81,000 81,000 100% 5210-447-490206-620 INT-MTR&WELL/WRF7104 1.25%;WRF8114 24,435 24,436 1 0% 5210-447-490250-610 PRIN-WTR MAIN/WRF1032R 2%/IDAHO&MAI 0 47,000 47,000 100% 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2%/IDAHO&MAIN 5,150 5,150 0 0% SUBTOTAL REVENUE BONDS 61,630 254,281 192,651 76% DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION TOTAL WATER FUND 0 840,000 840,000 100% 0 840,000 840,000 100% 501,196 5,055,853 4,554,657 90% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 26 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 630 0 630- 0% 5310-000-343310-000 SEWER SERVICE CHARGES 1,258,842 4,300,000 3,041,158 71% 5310-000-343330-000 IMPACT FEES (SANITARY) 296,312 220,000 76,312- -35% 5310-000-343335-000 IMPACT FEES (WWTP) 403,624 300,000 103,624- -35% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 10,869 5,000 5,869- -117% 5310-000-343365-000 LATECOMER ADMIN FEES 88 0 88- 0% 5310-000-371010-000 INVESTMENT EARNINGS 11,516 46,000 34,484 75% TOTAL SEWER REVENUE 1,981,880 4,871,000 2,889,120 59% SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 16,465 89,425 72,960 82% 5310-454-430620-112 SEVERANCE/RETIREMENT 0 1,500 1,500 100% 5310-454-430620-153 HEALTH INSURANCE 3,313 27,608 24,295 88% 5310-454-430620-155 RETIREMENT 1,243 6,653 5,410 81% 5310-454-430620-215 OFFICE SUPPLIES/computers 133 5,000 4,867 97% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 0 3,000 3,000 100% 5310-454-430620-355 BILLING COSTS 7,483 70,000 62,517 89% 5310-454-430620-373 DUES & TRAINING 934 2,500 1,566 63% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 1,714 6,857 5,143 75% 5310-454-430620-528 DATA PROCESSING TRANSFER 8,375 37,000 28,625 77% 5310-454-430620-532 OFFICE RENT 6,422 6,422 0 0% SUBTOTAL SEWER BILLING COSTS 46,083 255,965 209,882 82% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 53,875 251,563 197,688 79% 5310-454-430630-112 SALARIES-SEVERANCE/RETIREMENT 0 1,500 1,500 100% 5310-454-430630-121 OVERTIME 275 5,500 5,225 95% 5310-454-430630-153 HEALTH INSURANCE 9,679 63,447 53,768 85% 5310-454-430630-155 RETIREMENT 3,965 18,160 14,195 78% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 1,667 9,200 7,533 82% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 606 8,350 7,744 93% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 353 2,000 1,647 82% 5310-454-430630-231 GAS & OIL 2,045 13,500 11,455 85% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 52 400 348 87% 5310-454-430630-341 ELECTRICITY 6,675 54,500 47,825 88% 5310-454-430630-344 NATURAL GAS 2,223 16,500 14,277 87% 5310-454-430630-345 TELEPHONE & COMMUNICATION 7,974 23,000 15,026 65% 5310-454-430630-353 AUDITING 0 3,000 3,000 100% 5310-454-430630-354 CONTRACT SERVICES 2,465 24,000 21,535 90% 5310-454-430630-356 CONSULTANTS 1,144 8,000 6,856 86% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 9 5,000 4,991 100% 5310-454-430630-373 DUES & TRAINING 780 3,500 2,720 78% 5310-454-430630-388 MEDICAL SERVICES 243 500 257 51% 5310-454-430630-410 CONSTRUCTION MATERIALS 3,359 9,000 5,641 63% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 4,512 50,000 45,488 91% 5310-454-430630-510 PROPERTY & LIABILITY INS. 50,032 62,000 11,968 19% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 0 25,000 25,000 100% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 1,978 7,911 5,933 75% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 27 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 5310-454-430630-522 ADMINISTRATIVE TRANSFER 15,433 61,733 46,300 75% 5310-454-430630-528 DATA PROCESSING TRANSFER 4,187 16,482 12,295 75% 5310-454-430630-532 OFFICE RENT 6,422 6,422 0 0% 5310-454-430630-535 TRANSPORTATION CHGS/TRUMBULL CRK 0 32,000 32,000 100% 5310-454-430630-920 Install Lift Station Enclosure 0 10,000 10,000 100% 5310-454-430630-921 SAND/COLD MIX STORAGE SHED 0 25,771 25,771 100% 5310-454-430630-947 HWY 93 N BYPASS UTILITY RELOCATE DE 0 2,000 2,000 100% 5310-454-430630-951 1ST ALLEY EN PIPE UPSIZE (34% RATE 0 20,528 20,528 100% 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 0 20,000 20,000 100% 5310-454-430630-959 2ND ALLEY E REPLACEMENT 911 110,000 109,089 99% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 0 50,000 50,000 100% 5310-454-430630-961 2ND ALLEY WN- MONT TO CALF 0 367,000 367,000 100% SUBTOTAL SEWER COLLECTION 180,864 1,387,467 1,206,603 87% 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 101,071 101,071 100% 5310-454-430635-957 3 MILE DR INTERCEPTOR 42,657 586,967 544,310 93% 5310-454-430635-958 SPRING CREEK INTERCEPTOR DESIGN 59,773 742,981 683,208 92% 5310-454-430635-961 2ND ALLEY WN - MONT TO CALF 0 187,000 187,000 100% SUBTOTAL IMPACT FEE EXPENSE 102,430 1,652,054 1,549,624 94% REVENUE BONDS/SANITARY 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.25% 0 79,000 79,000 100% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 17,134 17,134 0 0% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25% 0 300 300 100% SUBTOTAL REVENUE BONDS 17,134 96,434 79,300 82% 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 300,428 3,955,955 3,655,527 92% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 78,873 448,294 369,421 82% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-112 SALARIES -RETIREMENT 0 1,500 1,500 100% 5310-455-430640-121 OVERTIME 4,377 22,500 18,123 81% 5310-455-430640-153 HEALTH INSURANCE 10,404 84,419 74,015 88% 5310-455-430640-155 RETIREMENT 6,094 32,035 25,941 81% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 677 10,000 9,323 93% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 652 2,700 2,048 76% 5310-455-430640-225 ALUM 0 20,000 20,000 100% 5310-455-430640-226 CHLORINE & CHEMICALS 260 19,000 18,740 99% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 28 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 1,103 7,000 5,897 84% 5310-455-430640-231 GAS & OIL 1,231 18,500 17,269 93% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 0 350 350 100% 5310-455-430640-336 LICENSES & FEES 0 11,000 11,000 100% 5310-455-430640-341 ELECTRICITY 28,283 178,500 150,217 84% 5310-455-430640-342 WATER 0 6,500 6,500 100% 5310-455-430640-344 NATURAL GAS 1,019 65,000 63,981 98% 5310-455-430640-345 TELEPHONE & COMMUNICATION 1,500 5,000 3,500 70% 5310-455-430640-353 AUDITING 0 4,000 4,000 100% 5310-455-430640-354 CONTRACT -GLACIER GOLD 24,442 124,000 99,558 80% 5310-455-430640-355 OTHER CONTRACT SERVICES 7,729 30,000 22,271 74% 5310-455-430640-356 CONSULTANTS 4,103 145,000 140,897 97% 5310-455-430640-358 CONSULTANT-TMDL 1,039 15,000 13,961 93% 5310-455-430640-360 MISC. MAINT SERVICES 3,634 30,000 26,366 88% 5310-455-430640-366 BUILDING MAINTENANCE 370 60,000 59,630 99% 5310-455-430640-373 DUES & TRAINING 1,985 7,500 5,515 74% 5310-455-430640-388 MEDICAL SERVICES 244 500 256 51% 5310-455-430640-510 PROPERTY & LIABILITY INS. 38,816 40,000 1,184 3% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 3,205 12,822 9,617 75% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 26,035 104,138 78,103 75% 5310-455-430640-528 DATA PROCESSING TRANSFER 6,281 24,723 18,442 75% SUBTOTAL WWTP OPERATIONS 252,359 1,534,981 1,282,622 84% WWTP BONDED PROJECT SUBTOTAL WWTP BONDED WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 5310-455-430645-933 SOLIDS DEWATERING DESIGN & CONST. 5310-455-430645-934 SECONDARY DIGESTER LID INSPECTION 5310-455-430645-936 DIGESTED SLUDGE LINE REPLACEMENT 5310-455-430645-940 MACHINERY & EQUIPMENT SUBTOTAL WWTP REPLACEMENT WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 5310-455-430646-153 HEALTH INSURANCE 5310-455-430646-155 RETIREMENT 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 5310-455-430646-218 NON -CAPITAL EQUIPMENT 5310-455-430646-222 LAB SUPPLIES 5310-455-430646-349 LAB SERVICES 5310-455-430646-362 EQUIPMENT MAINTENANCE 5310-455-430646-373 DUES & TRAINING SUBTOTAL WWTP LAB OPERATIONS DEBT SERVICE - WWTP 5310-455-490227-610 PRIN-WWTP IMP/SRF8164R/2.25% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 0 0 0 0% 11,445 100,000 88,555 89% 29,538 295,233 265,695 90% 0 31,500 31,500 100% 0 300,000 300,000 100% 0 75,000 75,000 100% 40,983 801,733 760,750 95% 28,074 129,261 101,187 78% 4,717 29,319 24,602 84% 2,050 9,177 7,127 78% 1,366 4,500 3,134 70% 134 2,500 2,366 95% 3,531 8,500 4,969 58% 3,860 29,000 25,140 87% 297 4,000 3,703 93% 542 2,700 2,158 80% 44,570 218,957 174,387 80% 0 778,000 778,000 100% 234,011 234,012 1 0% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 29 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 5310-455-490228-610 PRIN/WWTP DIGESTER LID/SRF13326/3.0 0 43,000 43,000 100% 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 29,955 29,955 0 0% SUBTOTAL DEBT SERVICE - WWTP CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-830 EVERGREEN REPLACEMENT TRANSFER 5310-455-510400-831 DEPRECIATION EXPENSE SUTOTAL WWTP DEPRECIATION/REPL SUBTOTAL WWTP TOTAL BILLING/SANITARY/WWTP 263,966 1,084,967 821,001 76% 0 411,599 411,599 100% 0 1,425,000 1,425,000 100% 0 1,836,599 1,836,599 100% 601,879 5,477,237 4,875,358 89% 948,390 9,689,157 8,740,767 90% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 30 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete 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 630 0 630- 0% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 0 2,500 2,500 100% 5349-000-343033-000 IMPACT FEES 153,007 150,000 3,007- -2% 5349-000-343034-000 PERMIT FEES 400 0 400- 0% 5349-000-343035-000 STORM SEWER CHARGES 0 1,000 1,000 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 0 846,000 846,000 100% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 386 2,000 1,614 81% 5349-000-371010-000 INTEREST ON INVESTMENTS 4,072 15,000 10,928 73% TOTAL STORM REVENUE 158,496 1,016,500 858,004 84% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 74,916 354,364 279,448 79% 5349-453-430246-112 SEVERANCE 0 1,500 1,500 100% 5349-453-430246-121 OVERTIME 275 4,000 3,725 93% 5349-453-430246-153 HEALTH INSURANCE 11,405 84,814 73,409 87% 5349-453-430246-155 RETIREMENT 5,515 25,357 19,842 78% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 2,531 10,100 7,569 75% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 87 6,550 6,463 99% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100% 5349-453-430246-231 GAS & OIL 2,045 11,500 9,455 82% 5349-453-430246-345 TELEPHONE & COMMUNICATION 132 800 668 84% 5349-453-430246-353 AUDITING 0 2,340 2,340 100% 5349-453-430246-354 CONTRACT SERVICE 2,294 6,000 3,706 62% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 3,900 25,000 21,100 84% 5349-453-430246-357 IMPACT FEE UPDATE 0 50,000 50,000 100% 5349-453-430246-358 CONSULTANTS 0 7,000 7,000 100% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 1,039 15,000 13,961 93% 5349-453-430246-360 REPAIR & MAINT SERVICES 0 2,500 2,500 100% 5349-453-430246-362 GROUNDWATER MONITORING 2,620 7,500 4,880 65% 5349-453-430246-371 CURB & GUTTER 0 7,000 7,000 100% 5349-453-430246-373 DUES & TRAINING 689 3,500 2,811 80% 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,548 10,000 5,452 55% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 1,978 7,911 5,933 75% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 8,881 35,523 26,642 75% 5349-453-430246-528 DATA PROCESSING TRANSFER 3,141 12,361 9,220 75% 5349-453-430246-530 BNSF LEASE PMT 0 5,900 5,900 100% 5349-453-430246-532 OFFICE RENT 6,422 6,422 0 0% 5349-453-430246-840 MACI GRANT MATCH (SWEEPER) 0 42,264 42,264 100% 5349-453-430246-921 SAND/COLD MIX STORAGE SHED 0 25,771 25,771 100% 5349-453-430246-952 STORM DRAIN CORRECTION 781 100,000 99,219 99% 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 0 581,400 581,400 100% 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 130,000 130,000 100% 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 285,000 285,000 100% TOTAL STORM 133,197 1,879,677 1,746,480 93% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 31 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SOLID WASTE REVENUE: 5510-000-343360-000 SALE OF MAT/AUCTION 7,525 0 7,525- 0% 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 0 954,436 954,436 100% 5510-000-343420-000 GARBAGE COLLECTION -BILLED 440 23,000 22,560 98% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 601 2,500 1,899 76% 5510-000-371010-000 INVESTMENT EARNINGS 1,522 5,000 3,478 70% TOTAL SOLID WASTE REVENUE 10,087 984,936 974,849 99% SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 85,802 404,181 318,379 79% 5510-460-430840-112 SEVERANCE -RETIREMENT 0 61,975 61,975 100% 5510-460-430840-121 OVERTIME 513 5,500 4,987 91% 5510-460-430840-153 HEALTH INSURANCE 14,725 95,330 80,605 85% 5510-460-430840-155 RETIREMENT 6,252 28,610 22,358 78% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 1,403 9,500 8,097 85% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 0 35,000 35,000 100% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 799 5,500 4,701 85% 5510-460-430840-231 GAS & OIL 6,784 61,500 54,716 89% 5510-460-430840-331 PUBLICATION & FILING FEES 0 1,950 1,950 100% 5510-460-430840-341 ELECTRICITY 162 0 162- 0% 5510-460-430840-344 NATURAL GAS 50 4,900 4,850 99% 5510-460-430840-345 TELEPHONE & COMMUNICATION 340 850 510 60% 5510-460-430840-354 CONTRACT SERVICES 997 9,000 8,003 89% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 134 5,700 5,566 98% 5510-460-430840-366 BUILDING MAINTENANCE 0 2,500 2,500 100% 5510-460-430840-373 DUES & TRAINING 300 3,500 3,200 91% 5510-460-430840-388 MEDICAL SERVICES 185 650 465 72% 5510-460-430840-510 PROPERTY & LIABILITY INS. 10,696 10,000 696- -7% 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 262 3,000 2,738 91% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 15,347 61,388 46,041 75% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 8,296 33,186 24,890 75% 5510-460-430840-528 DATA PROCESSING TRANSFER 3,141 12,361 9,220 75% 5510-460-430840-532 OFFICE RENT 6,422 6,422 0 0% 5510-460-430840-610 DEBT SERVICE PRINCIPAL -GARBAGE TK 18,940 37,964 19,024 50% 5510-460-430840-620 DEBT SERVICE INTEREST -GARBAGE TK 956 1,927 971 50% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 8,750 35,000 26,250 75% 5510-460-430840-944 VEHICLES (Replacement $) 121 324,500 324,379 100% 5510-460-430845-224 JANITORIAL SUPPLIES 79 250 171 68% 5510-460-430845-341 ELECTRICITY 245 3,500 3,255 93% 5510-460-430845-342 WATER 0 500 500 100% 5510-460-430845-344 NATURAL GAS 54 6,500 6,446 99% 5510-460-430845-360 REPAIR & MAINT SERVICES 223 3,500 3,277 94% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% TOTAL SOLID WASTE EXPENSE 191,978 1,426,144 1,234,166 87% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 32 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5160 AIRPORT ENTERPRISE FUND 5160-000-343062-000 COMMERCIAL FEES 2,782 10,000 7,218 72% 5160-000-343069-000 HANGER LEASES 2,500 11,000 8,500 77% 5160-000-343071-000 HANGAR SITE LEASES 17,132 17,510 378 2% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 4,455 17,734 13,279 75% 5160-000-343102-000 GROUND LEASES 12,814 12,814 0- 0% 5160-000-343620-000 FUEL TAX 2,070 5,000 2,930 59% 5160-000-371010-000 INVESTMENT EARNINGS 243 850 607 71% TOTAL AIRPORT REVENUE 41,997 74,908 32,911 44% 5160 AIRPORT EXPENSES 5160-430-430310-210 OFFICE SUPPLIES & EQUIP 0 1,000 1,000 100% 5160-430-430310-341 ELECTRICITY 259 1,500 1,241 83% 5160-430-430310-354 CONTRACT SERVICES -LABOR & MATERIALS 9,000 36,000 27,000 75% 5160-430-430310-356 CONTRACT SERVICES -SNOW REMOVAL 0 7,500 7,500 100% 5160-430-430310-362 REPAIR & MAINTENANCE 2,646 10,000 7,354 74% 5160-430-430310-390 EQUIPMENT RENTAL 140 1,000 860 86% 5160-430-430310-510 PROPERTY INSURANCE 423 6,500 6,077 93% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 830 3,320 2,490 75% 5160-430-430310-528 DATA PROCESSING TRANSFER 523 2,060 1,537 75% 5160-430-430310-820 DEPRECIATION 0 97,918 97,918 100% TOTAL AIRPORT EXPENSES 13,822 166,798 152,976 92% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 33 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete 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 38,750 155,000 116,250 75% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 0 180,000 180,000 100% 6030-000-371010-000 INVESTMENT EARNINGS 173 500 327 65% 6030-000-393000-000 INTERNAL SERVICES -DATA 58,101 224,567 166,466 74% TOTAL INFORMATION TECH REVENUE 97,025 560,067 463,042 83% INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 34,430 162,290 127,860 79% 6030-401-410580-121 OVERTIME 0 2,500 2,500 100% 6030-401-410580-153 HEALTH INSURANCE 6,181 33,424 27,243 82% 6030-401-410580-155 RETIREMENT 2,648 12,305 9,657 78% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 266 4,050 3,784 93% 6030-403-410580-215 COMPUTER SUPPLIES 420 2,400 1,980 83% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 2,479 16,800 14,321 85% 6030-403-410580-325 WEBSITE 196 17,000 16,804 99% 6030-403-410580-345 PAGER/PHONE 486 1,800 1,314 73% 6030-403-410580-346 SUMMITNET & ISPS 911 9,800 8,889 91% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,432 4,000 568 14% 6030-403-410580-354 MAINTENANCE CONTRACTS 12,584 42,266 29,682 70% 6030-403-410580-355 LICENSES 2,418 24,500 22,082 90% 6030-403-410580-357 GRANICUS 1,200 7,200 6,000 83% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 1,461 13,700 12,239 89% 6030-403-410580-373 DUES & TRAINING 831 7,050 6,219 88% 6030-403-410580-510 INSURANCE 1,706 1,778 72 4% 6030-403-410583-218 TV -Video Equipment & programming 0 12,400 12,400 100% 6030-403-410583-354 TV -Video Contract Services 450 1,300 850 65% 6030-403-410585-229 COPIER,FAX, SUPPLIES 1,412 17,400 15,988 92% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 17,839 73,000 55,161 76% 6030-403-410585-532 COPIER LEASES 3,038 15,000 11,962 80% 6030-403-410585-942 Servers - capital contingency 0 15,000 15,000 100% 6030-403-510400-831 DEPRECIATION EXPENSE 0 5,000 5,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 266 3,660 3,394 93% 6030-405-410588-940 COMPUTERS - SWITCHES 0 31,000 31,000 100% 6030-410-410588-218 COMPUTERS - DPW 2,175 2,410 235 10% 6030-413-410588-218 COMPUTERS - POLICE DEPT 1,462 26,160 24,698 94% 6030-413-410588-354 POLICE - HOSTED SERVER 0 2,000 2,000 100% 6030-416-410588-218 COMPUTERS - FIRE 399 9,195 8,796 96% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 2,100 8,566 6,466 75% 6030-436-410588-218 COMPUTERS - PARKS 266 1,935 1,669 86% 6030-480-410588-218 COMMUNITY DEVELOPMENT 133 1,855 1,722 93% TOTAL INFORMATION TECH EXPENSE 101,191 588,744 487,553 83% 10.13.2015 14:30 THE CITY OF KALISPELL, MONTANA Page 34 of 34 gb8501_pg.php/Job No: 14989 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU SEPTEMBER 30, 2015 25.00 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 116,123 464,491 348,368 75% 6010-000-371010-000 INVESTMENT EARNINGS 57 30 27- -92% TOTAL CENTRAL GARAGE REVENUE 116,180 464,521 348,341 75% CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 29,032 164,028 134,996 82% 6010-410-431330-121 OVERTIME 328 2,500 2,172 87% 6010-410-431330-153 HEALTH INSURANCE 3,284 27,341 24,057 88% 6010-410-431330-155 RETIREMENT 2,018 11,661 9,643 83% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 4,874 9,000 4,126 46% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 363 14,000 13,637 97% 6010-410-431330-230 OIL 2,843 25,000 22,157 89% 6010-410-431330-231 GAS 169 3,000 2,831 94% 6010-410-431330-232 VEHICLE PARTS 32,628 103,000 70,372 68% 6010-410-431330-233 TIRES 5,766 35,000 29,234 84% 6010-410-431330-238 FILTERS 1,868 7,700 5,832 76% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 32 2,000 1,968 98% 6010-410-431330-341 ELECTRICITY 261 1,950 1,689 87% 6010-410-431330-344 NATURAL GAS 112 9,000 8,888 99% 6010-410-431330-354 CONTRACT SERVICES 3,425 31,000 27,575 89% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 0 2,000 2,000 100% 6010-410-431330-373 DUES & TRAINING 0 6,200 6,200 100% 6010-410-431330-388 MEDICAL SERVICES 50 300 250 83% 6010-410-431330-510 INSURANCE 2,511 2,500 11- -0% 6010-410-431330-528 INFORMATION TECH TRANSFER 2,094 8,241 6,147 75% TOTAL CENTRAL GARAGE EXPENSES 91,657 465,421 373,764 80% O O O Ol OJ N O O Nc-I m - Cof Ic�-IO mC 1 O Q iy l0 N No Nl I� C N c-I f0 O ~ c O. O N N lD m � O I� l0 lD Ol lD lD N I� N N ^ O c-I O M Ill N l0 n I� m O O� mOJ m O� � O 4 Q O E N -O u N M o O 9 a O s 4 Q O E N ° O a o O Z 9 a O s N 4 Q O O u o O O s N O M O O lD m O C O O N O O N N N O O N O ti O� O N O lD Ol C O ti 4 Q N v g O O O M O m I- Ol N N .--I rl M N M O O M M `T l O M O Ol N .--I M N O In .ZT O s Q O O O O O M w M O N N O .--I .-I O N N N O O O N O n C O N O O w ^ O J J a c Q O lD C 00 � M M � N O m C O O C O C O w M OJ 0 O O Q O N O O O � .ZT N N O O O O O N T N O O N O lD ti N m O lD M O �O. M rl _T J v 0 O C N M O l0 Ill N w O C O M M O c-I N .--I l0 l0 N M .--I w l0 l0 M r M O UI Q O O O O O O of O O M c-I O O N O O O .--I N O O m O l0 .-I l0 O M C N n C of O c-I rl J J c Q O C N O in ti O N N n O in m N N N N O O N ti n lD O m ti lD ti m ti m m � O s .-I T Q O O N O C w In O M c-I O O C O O O N O O M. O O O n 0. C � f0 � O O Ill .--I M O I� Ill n .--I N .--I M N .--I O O ZT O w O c-I O N N ^ N rl M O s Q O O O M O I� N m O M O O O N O O O C O O N O in O N O of C O in M� M Q O O M ZT O O-0 C M m T W .--I W .ZT M O O 0 N O O M N w Ill O N O m .--I l0 M m N O s L Q O .--I .-I .-I O O in N O M. O O O O M .-I T c-I O O N O 7T n O O O N C M Oo. f I. n cm-I i f0 O O rl T N O Ill ti Ill n ^ M O N M N N O O M N ti 00 O O O l m l , M N w � N O s T f0 Q O O N .--I O .--I w M O O O O O O O N N O O ti O ti w O .--I O w J 4 i v 0 O M N ZT O 0 C c-I 0 O O Ill C O O C C O O Ol N � N O s T f0 Q O O O .--I O N l0 O O M O O O O O .--I O O .--I O O ON O 'T O O O N l0 O C M O J C Otf O O O O w O O O O O O O O M O � N O s 0 `o O o - 0 0 O 0 _ lu O Q - Oo u o oo ¢ ° \o ° a o vO o E o' 000 N- L0 ¢¢ F u - O O