The URL can be used to link to this page

09-18-15 City Manager ReportCITYOF _ City of Kalispell OFFICE OF THE CITY MANAGER MONTANA Information Memorandum 9/18/2015 1. Parks Department Doggie Dayz is occurring this Saturday, September 19, at Lawrence Park from 11:00a.m.-3:00p.m. The event will be bigger than ever before as Parks and Recreation has partnered with Paws to Play, Costco, and Parkside Credit Union to put on the event. Funds raised through the event will go towards building a dog park in Kalispell. September 19, 2015, from 4:00p.m.- 8:00p.m., the Kalispell Boulder Project will be hosting a street party downtown on 41h St W from Main to 1st Ave W. Proceeds raised will go toward purchasing a climbing boulder park in Lawrence Park. A contractor will be removing twelve dead maple trees near the courthouse on Main Street this week. Work is being accomplished using matching funds from the DNRC. Park staff are currently working to install irrigation around the Lagoon Pavilion in Woodland Park. This upgrade will go a long way to making Woodland Park greener during the summer months. The Street Tree Commission met September 9, 2015, and worked to finalize plans for Kalispell's first ever Tree Cycle event to be held September 27, 2015. The family friendly bike ride will take citizens on a 2 or 3.75 mile bike ride to look at Kalispell's trees. The guided tour will look at some of Kalispell's unique and interesting trees as well as management of the urban forest. The ride begins at 2:00p.m., from Central School Museum. Recreation staff are taking registrations for both Little Dribblers (Kindergarten, Vt & 2nd Grade Boys, 1st & 2nd Grade Girls) and Little Squirts (4 — 5 years old) basketball with the six week programs starting September 11 and September 18, respectively. Registrations numbers appear to be in line with last year's numbers. 2. Public Works Grader -Street Department Public Works has received shipment of the grader budgeted for FY 15/16. The Grader is 6 years old, in great condition with low hours, and allows the operator to articulate tight intersections throughout Kalispell. This grader replaces two worn and high maintenance graders in the Street Division fleet. As Public Works progresses toward seasonal utilization of equipment, this unit will be used for snow removal, gravel road and alley grading, and pavement maintenance operations. Water Maintenance The Water Maintenance Division has repaired four water main ruptures since June of this year. One leak surfaced at 6th St E & Main St., and three others surfaced on the west side of town at 6th Ave. W & 5th St. W, 1st St W & Center St., and Washington St. & 2 Ave. WN. City water crews continually repair main breaks within the water system throughout the year. Typically, customers only experience a 4 hour window where they may not have water service. 3. Fire Department Since the last update, the Kalispell Fire Department has received 152 calls for service and has conducted 3 outreach trainings. In the past two weeks, fire departments staff, along with outside private contractors have conducted our required annual fire hose and fire pump testing and recertification. These tests, if successful, certify that the equipment can still operate to its rated capacity without failure during an actual event. Also Assistant Chief Campbell will be attending the next Montana State Board of Medical Examiners session in Helena. The State Board of Medical Examiners and their 2 EMS subcommittee have oversight of the State of Montana's prehospital treatment protocols for patient care. The State of Montana's six regional hazardous materials response teams, including Kalispell's team as staffed by Kalispell Fire Department, have submitted a protocol exemption application to the Board of Medical Examiners, and this item is on their agenda for Friday, Sept. 18. This application, submitted with the help of Flathead County's medical director, would allow the state regional hazardous materials response teams' advanced life support providers a set of protocols to follow when treating victims involved in hazardous materials incidents. These protocols are one part of three stages of implementing a "Toxmedic" program in the State of Montana. The other two parts have already taken place which were: 1) the training of paramedics to the National Fire Academy curriculum for Advanced Life Support providers on hazardous materials incidents, and 2) the grant funding to supply the six regional teams the equipment to fulfill that function. The implementation of this program will make Montana the first state in the nation to effectively implement a statewide program that meets the recommendation of the National Fire Protection Association's Standard 473 for competencies for EMS personnel responding to hazardous materials/weapons of mass destruction incidents. 4. Planning Department The planning board met on September 15 and heard 2 requests from Flathead County for agency exemptions to our zoning ordinance; 1) an entrance feature off of Two Mile at the entrance to the fairground that was both higher and closer to the pubic R/W than the zoning allowed, and 2) the conversion of a single family house at 1224 First Avenue West into a storage facility. The Board also heard a request from Mountain Plains Equity Group for a conditional use permit to construct a 40 unit senior living apartment complex at 41 Meridian Court. The site lies on the west side of Kalispell between West Second Street and Meridian Court. The applicants are in a competitive process applying for housing tax credits through the State of Montana in order to construct the facility. The planning board also held a hearing on modifications to the casino standards in Kalispell. The board recommended increasing the spacing standard from 300 to 600 feet for any new casino from a church, school, park, residential zone or other casinos. A proposal to prohibit casinos north of a line 300 feet north of Idaho and south of a line along Twin Acres Road and along the south end of the airport was not advanced. The casino amendments and apartment CUP will be forwarded to the council for final action. 5. Building Department Building permits have been issued for Treeline Village, a 96 unit apartment complex consisting of eight, three story 12-plexes in the Bloomstone Subdivision off of Treeline Road and Four Mile Drive. Foundation work has begun on three of the eight buildings. They plan on pouring all foundations this fall and finishing the buildings over the winter/spring. Building permit applications have been submitted for two projects at the hospital; a $400,000 remodel of their convention/meeting facilities, and a $637,000 remodel at the Northwest Oncology & Hematology building located at 350 Heritage Way. 6. Finance Department The Fiscal Year 2016 final budget is being proofed and assembled for submittal to the State by September 30. It is also available for viewing or printing from the City's website. Hard copies will also be available by request. The refinancing of City Hall was completed on September 15. The new loan thru the Montana State Board of Investments is currently at 1.25% compared to the old loan which was fixed at 4.85%. This refinance will save the General Fund over $10,000 at the current rate. Please find attached a financial report for the first two months of fiscal year 2016. This printout reflects payroll paid thru August 22, four pay periods. All funds are included with the exception of the debt service funds, G. O. bonds, Walk & 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. Tan 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. Ambulance fees for services shows no activity. This revenue is normally booked quarterly, so fiscal year 2016 revenue will be posted September 30 for July, August and September. EXPENDITURES/EXPENSES At this point in the year, the salary remaining should be between 85%. Some seasonal salaries would be the exception, such as parks and recreation. Health insurance reflects 1 month paid and should show about 91% remaining. Retirement should be comparable to salaries as far as % remaining. The City pays its annual liability and property insurance in August. This results in general government expenses reflecting greater than 17% spent at the end of August. 7. Human Resources Over forty-two City employees attended a two-hour presentations on the Public Employees Retirement System (PERS) and Voluntary Employee Benefit Association (VEBA). The programs were presented by PERS Training Specialist Armando Orepeza and VEBA Health Officer Melanie Denning with the Dept. of Administration, both out of Helena. They explained how both the public employee retirement benefits and VEBA plans work and talked about how and when to apply for benefits and the pitfalls of poor planning. They stressed the importance of starting retirement planning early in their careers and to consider utilizing a 457 retirement investment plan to enhance benefits as basic PERS retirement and Social Security may not be enough to sustain them. A Montana VEBA HRA (Health Reimbursement Arrangement) is a post- E retirement/employment health reimbursement plan funded with employer contributions. In 2011, the City of Kalispell adopted the program where city employees can form work division groups and have their post -employment unused sick leave rolled over into a tax free HRA. An HRA, similar to a Flexible Spending Account (FSA), can be used to purchase health insurance and other medical expenses not covered by insurance. As an added incentive to not frivolously use sick leave and to allow advanced vacancy planning; employees who have ten -years of service and provide a six-month notice, are eligible for a match to their sick leave payout. Both the City and the employee benefit in this program as there are no taxes paid out when rolled over into these accounts. 5 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Pagel of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 47,739 5,418,805 5,371,066 99% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 0 24,090 24,090 100% 1000-000-311200-000 PERSONAL PROPERTY TAXES 78,674 112,000 33,326 30% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 2,057 10,000 7,943 79% 1000-000-322101-000 BEER & LIQUOR LICENSES 400 30,000 29,600 99% 1000-000-322300-000 BUSINESS LICENSES 97 1,350 1,253 93% 1000-000-323012-000 PLANNING FEES 3,746 38,000 34,254 90% 1000-000-323109-000 SITE REVIEW 0 13,000 13,000 100% 1000-000-323200-000 PARADE PERMITS 200 1,000 800 80% 1000-000-323300-000 ANIMAL LICENSES 221 2,000 1,780 89% 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 0 2,765,228 2,765,228 100% 1000-000-341020-000 ADMINISTRATIVE CHARGES 88,071 542,726 454,655 84% 1000-000-341021-000 GRANT ADMIN FEES 0 10,000 10,000 100% 1000-000-341025-000 CITY COLLECTIONS 4 8,000 7,996 100% 1000-000-342010-000 POLICE SERVICES 7,937 25,000 17,063 68% 1000-000-342014-000 RESOURCE OFFICERS 0 97,410 97,410 100% 1000-000-342016-000 KPD REGIONAL TRAINING 0 10,000 10,000 100% 1000-000-342020-000 FIRE CHG/TEST FEES/SPEC EVENTS/INST 5 0 5- 0% 1000-000-343018-000 PARKING PERMITS 19,055 95,000 75,945 80% 1000-000-351000-000 CITY COURT FINES & FEES 47,347 500,000 452,653 91% 1000-000-351016-000 DUI COURT FINE 240 0 240- 0% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 1,670 30,000 28,330 94% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 6,839 35,000 28,161 80% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 0 20,000 20,000 100% 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 1,687 7,000 5,313 76% 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 306,612 10,734,109 10,427,497 97% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 2 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 752 4,500 3,748 83% 1000-400-410560-312 POSTAGE 962 21,000 20,038 95% 1000-400-410560-320 PRINTING & ENVELOPES 0 4,500 4,500 100% 1000-400-410600-354 ELECTIONS 0 16,000 16,000 100% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 1,132 3,500 2,368 68% 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 0 50,000 50,000 100% 1000-400-510330-517 PROPERTY INSURANCE 45,800 45,800 0 0% SUBTOTAL GEN.GOV'T. 171,026 817,549 646,523 79% 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 18,557 135,220 116,663 86% 1,352 21,024 19,672 94% 2,012 14,287 12,275 86% 0 300 300 100% 0 400 400 100% 120 1,080 960 89% 1,366 20,500 19,134 93% 0 3,300 3,300 100% 23,407 196,111 172,704 88% 17,413 122,095 104,682 86% 1,509 18,116 16,607 92% 1,331 9,223 7,892 86% 5 600 595 99% 1,063 7,200 6,137 85% 40 1,000 960 96% 525 4,300 3,775 88% 21,886 162,534 140,648 87% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 3 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 9,314 63,107 53,793 85% 4,452 45,792 41,340 90% 364 2,428 2,064 85% 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% 20,800 132,677 111,877 84% CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 12,476 87,628 75,152 86% 1000-402-410150-121 OVERTIME 82 250 168 67% 1000-402-410150-153 HEALTH INSURANCE 1,562 18,761 17,199 92% 1000-402-410150-155 RETIREMENT 962 6,650 5,688 86% 1000-402-410150-210 OFFICE SUPPLIES 0 700 700 100% 1000-402-410150-345 TELEPHONE & COMMUNICATION 40 480 440 92% 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 15,122 120,694 105,572 87% 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 29,896 216,869 186,973 86% 2,931 38,990 36,059 92% 2,278 16,442 14,164 86% 0 400 400 100% 0 250 250 100% 0 2,000 2,000 100% 605 1,500 895 60% 249 3,500 3,251 93% 1,868 6,500 4,632 71% 37,826 286,451 248,625 87% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 4 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 43,278 353,043 309,765 88% 1000-404-411110-153 HEALTH INSURANCE 3,421 50,835 47,414 93% 1000-404-411110-155 RETIREMENT 3,302 26,780 23,478 88% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 314 2,500 2,186 87% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 811 8,000 7,189 90% 1000-404-411110-345 TELEPHONE & COMMUNICATION 110 1,000 890 89% 1000-404-411110-354 CONTRACT SERVICES 1,197 1,500 303 20% 1000-404-411110-373 DUES & TRAINING 675 7,000 6,325 90% SUBTOTAL CITY ATTORNEY 53,107 450,658 397,551 88% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 32,286 226,725 194,439 86% 1000-406-410360-153 HEALTH INSURANCE 3,526 42,330 38,804 92% 1000-406-410360-155 RETIREMENT 2,461 17,149 14,688 86% 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 0 1,400 1,400 100% 1000-406-410360-353 SECURITY & TECHNOLOGY 90 40,000 39,910 100% 1000-406-410360-354 CONTRACT SERVICES 23 5,750 5,727 100% 1000-406-410360-373 DUES & TRAINING 848 6,300 5,452 87% 1000-406-410360-394 JURY & WITNESS FEES 120 5,750 5,630 98% SUBTOTAL COURT 39,998 351,404 311,406 89% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 2,523 17,364 14,841 85% 1000-410-430100-112 SEVERANCE 0 800 800 100% 1000-410-430100-153 HEALTH INSURANCE 245 2,943 2,698 92% 1000-410-430100-155 RETIREMENT 190 1,287 1,097 85% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 2,108 7,500 5,392 72% 1000-410-430100-231 GAS 77 2,500 2,423 97% 1000-410-430100-345 TELEPHONE & COMMUNICATION 41 285 244 86% 1000-410-430100-354 CONTRACT SERVICES 0 1,850 1,850 100% 1000-410-430100-373 DUES & TRAINING 160 1,500 1,340 89% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 768 4,609 3,841 83% SUBTOTAL PUBLIC WORKS ADMIN 6,112 40,638 34,526 85% CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 9,446 67,207 57,761 86% 1000-412-411230-153 HEALTH INSURANCE 1,296 15,550 14,254 92% 1000-412-411230-155 RETIREMENT 695 4,872 4,177 86% 1000-412-411230-220 SECURITY IMPROVEMENTS 0 800 800 100% 1000-412-411230-224 JANITORIAL SUPPLIES 311 6,000 5,689 95% 1000-412-411230-241 TOOLS & SUPPLIES 0 1,500 1,500 100% 1000-412-411230-341 ELECTRICITY 4,671 47,500 42,829 90% 1000-412-411230-344 NATURAL GAS 1,498 40,000 38,502 96% 1000-412-411230-345 TELEPHONE & COMMUNICATION 26 250 224 89% 1000-412-411230-354 CONTRACT SERVICES 1,598 13,500 11,902 88% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 5 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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,465 20,000 18,535 93% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 40 3,500 3,460 99% 1000-412-411230-920 BLDG IMPROVEMENT 0 28,700 28,700 100% SUBTOTAL CITY HALL 37,278 279,179 241,901 87% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 36,480 272,988 236,508 87% 1000-420-411020-153 HEALTH INSURANCE 4,142 49,726 45,584 92% 1000-420-411020-155 RETIREMENT 2,786 20,677 17,891 87% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 84 5,000 4,916 98% 1000-420-411020-231 GAS 1 400 400 100% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 103 2,000 1,897 95% 1000-420-411020-345 TELEPHONE 135 750 615 82% 1000-420-411020-354 CONTRACT SERVICES 0 700 700 100% 1000-420-411020-373 DUES & TRAINING 1,804 5,000 3,196 64% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 119 713 594 83% SUBTOTAL PLANNING DEPT. 45,652 357,954 312,302 87% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 6,400 45,105 38,705 86% 1000-480-470210-153 HEALTH INSURANCE 477 5,724 5,247 92% 1000-480-470210-155 RETIREMENT 489 3,586 3,097 86% 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 57 750 693 92% 1000-480-470210-354 CONTRACT SERVICES 0 1,000 1,000 100% 1000-480-470210-373 DUES & TRAINING 1,933 3,000 1,067 36% 1000-480-470210-379 MEETINGS 0 500 500 100% SUBTOTAL COMMUNITY DEVELOPMENT 9,856 62,165 52,309 84% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 6 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 296,847 2,054,055 1,757,208 86% 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) 13,156 75,000 61,844 82% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 5,137 25,000 19,863 79% 1000-413-420140-153 HEALTH INSURANCE 31,220 393,313 362,093 92% 1000-413-420140-155 RETIREMENT 37,578 266,975 229,397 86% 1000-413-420140-210 OFFICE SUPPLIES 297 3,500 3,203 92% 1000-413-420140-215 COMPUTER SUPPLIES 621 5,500 4,879 89% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 0 18,500 18,500 100% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 313 4,000 3,687 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 0 19,000 19,000 100% 1000-413-420140-228 PATROL CAR SUPPLIES 1,272 13,000 11,728 90% 1000-413-420140-229 OTHER SUPPLIES 32 3,500 3,468 99% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 0 1,000 1,000 100% 1000-413-420140-231 GAS 5,982 95,000 89,018 94% 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 281 5,000 4,719 94% 1000-413-420140-345 TELEPHONE & COMMUNICATION 2,244 15,500 13,256 86% 1000-413-420140-354 CONTRACT SERVICES 2,056 6,000 3,944 66% 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. 9,272 17,500 8,228 47% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 53 2,500 2,447 98% 1000-413-420140-373 DUES & TRAINING 4,956 30,000 25,044 83% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 1,256 10,000 8,744 87% 1000-413-420140-380 TRAINING MATERIALS 0 2,000 2,000 100% 1000-413-420140-388 MEDICAL SERVICES 0 2,500 2,500 100% 1000-413-420140-392 BOARDING/TREATING PRISONERS 101 2,500 2,400 96% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 13,403 80,420 67,017 83% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 0 57,500 57,500 100% 1000-413-420140-828 TRANSFER TO 2918 COPS HIRING GRANT 0 34,562 34,562 100% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 0 3,500 3,500 100% 1000-413-420140-944 VEHICLES 0 121,000 121,000 100% SUBTOTAL POLICE DEPT. 430,038 3,438,075 3,008,037 87% DETECTIVES 1000-413-420141-110 SALARIES -DETECTIVES 52,922 357,372 304,450 85% 1000-413-420141-121 DETECTIVE -OVERTIME 534 15,000 14,466 96% 1000-413-420141-153 HEALTH INSURANCE 4,533 62,325 57,792 93% 1000-413-420141-155 DETECTIVE -RETIREMENT 6,634 47,812 41,178 86% TOTAL DETECTIVES 64,624 482,509 417,885 87% RECORDS 1000-413-420142-110 SALARIES -RECORDS DIVISION 16,623 115,309 98,686 86% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 7 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-121 OVERTIME 312 7,500 7,188 96% 1000-413-420142-153 HEALTH INSURANCE 1,908 22,896 20,988 92% 1000-413-420142-155 RETIREMENT 1,285 8,703 7,419 85% TOTAL RECORDS 20,127 154,408 134,281 87% RESOURCE OFFICERS 1000-413-420144-110 SALARIES -SRO 17,852 123,825 105,974 86% 1000-413-420144-153 HEALTH INSURANCE 2,169 27,066 24,897 92% 1000-413-420144-155 SRO RETIREMENT 2,262 16,594 14,332 86% TOTAL RESOURCE OFFICERS 22,283 167,485 145,202 87% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL -SALARIES 6,332 39,448 33,116 84% 1000-413-420145-121 OVERTIME 13 500 487 98% 1000-413-420145-153 HEALTH INSURANCE 636 10,132 9,496 94% 1000-413-420145-155 RETIREMENT 428 2,976 2,548 86% SUBTOTAL ANIMAL CONTROL 7,408 53,056 45,648 86% PARKING 1000-413-420147-110 PARKINGS -SALARIES 12,924 87,532 74,608 85% 1000-413-420147-153 HEALTH INSURANCE 2,358 28,319 25,961 92% 1000-413-420147-155 RETIREMENT 933 6,600 5,667 86% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 0 4,000 4,000 100% 1000-413-420147-354 CONTRACTED SERVICES 9 2,000 1,991 100% 1000-413-420147-362 LOT MAINT 104 10,000 9,896 99% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 0 17,500 17,500 100% 1000-413-420147-550 LOT LEASE PAYMENTS 177 1,500 1,323 88% SUBTOTAL PARKING 16,505 157,451 140,946 90% SUBTOTAL POLICE DEPT. 560,985 4,452,984 3,891,999 87% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 8 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 224,660 1,548,410 1,323,750 85% 1000-416-420400-114 COMPTIME BUYOUT 0 5,500 5,500 100% 1000-416-420400-115 OUT OF RANK PAY 2,545 10,000 7,455 75% 1000-416-420400-121 OVERTIME 10,355 40,000 29,645 74% 1000-416-420400-153 HEALTH INSURANCE 23,489 286,204 262,715 92% 1000-416-420400-155 RETIREMENT 30,462 207,394 176,932 85% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 66 2,000 1,934 97% 1000-416-420400-218 Equipment (Non Capital) 1,021 35,550 34,529 97% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 584 15,000 14,416 96% 1000-416-420400-224 JANITORIAL SUPPLIES 277 2,500 2,223 89% 1000-416-420400-231 GAS 936 17,325 16,389 95% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 3,194 15,000 11,806 79% 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 639 6,000 5,361 89% 1000-416-420400-354 CONTRACT SERVICES 3,656 6,000 2,345 39% 1000-416-420400-362 EQUIPMENT MAINTENANCE 1,471 5,500 4,029 73% 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 60 5,000 4,940 99% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 1,015 5,000 3,985 80% 1000-416-420400-373 DUES & TRAINING 943 10,000 9,058 91% 1000-416-420400-388 FIREFIGHTER PHYSICALS 0 22,500 22,500 100% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 5,362 32,172 26,810 83% 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 0 380,000 380,000 100% 1000-416-420440-110 SALARIES -FIRE PREVENTION 7,114 49,802 42,688 86% 1000-416-420440-121 OVERTIME 1,013 0 1,013- 0% 1000-416-420440-153 HEALTH INSURANCE 657 7,340 6,683 91% 1000-416-420440-155 RETIREMENT 592 3,587 2,995 84% SUBTOTAL FIRE DEPT. 336,951 2,735,865 2,398,914 88% GRAND TOTAL GENERAL FUND 1,380,008 10,446,863 9,066,855 87% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 9 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 1,446 8,674 7,228 83% 2185-000-430300-840 REDEVELOPMENT ACTIVITY 0 1,250,000 1,250,000 100% 2185-480-470240-110 SALARIES 2,642 19,067 16,425 86% 2185-480-470240-153 HEALTH INSURANCE 223 2,721 2,498 92% 2185-480-470240-155 RETIREMENT 202 1,438 1,236 86% 2185-480-470240-345 TELEPHONE & COMMUNICATION 8 48 40 83% TOTAL AIRPORT TIF 4,521 1,283,548 1,279,027 100% 2188 WESTSIDE TIF 2188-480-470230-110 SALARIES 5,462 39,760 34,298 86% 2188-480-470230-153 HEALTH INSURANCE 413 5,161 4,748 92% 2188-480-470230-155 RETIREMENT 417 2,989 2,572 86% 2188-480-470230-353 AUDIT 0 2,000 2,000 100% 2188-480-470230-356 TELEPHONE 32 0 32- 0% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 533 3,198 2,665 83% 2188-480-470230-710 LOAN REVOLVING FUNDS 0 1,500,000 1,500,000 100% 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 121,193 2,500,000 2,378,807 95% 2188-480-470230-840 TRANSFER TO DEBT SERVICE 0 32,340 32,340 100% TOTAL WESTSIDE TIF 128,050 4,085,448 3,957,398 97% 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 0 60,000 60,000 100% 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT 0 10,000 10,000 100% TOTAL OLD SCHOOL TIFS 0 99,000 99,000 100% PERMISSIVE HEALTH LEVY 2372-400-521000-810 OPERATING TRANSFER TO GENERAL FUND 0 936,000 936,000 100% TOTAL PERMISSIVE HEALTH LEVY 0 936,000 936,000 100% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 10 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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% 0 10,000 10,000 100% 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 34,947 495,085 460,138 93% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 11 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 7,454 864,000 856,546 99% 2215-000-311200-000 PERSONAL PROPERTY TAXES 13,112 35,000 21,888 63% 2215-000-312000-000 PEN & INTEREST DEL TAXES 343 2,000 1,657 83% 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,248 140,000 71,752 51% 2215-000-346040-000 CONCESSION STAND REVENUE 23,680 34,000 10,320 30% 2215-000-346050-000 PARKS USAGE FEES 5,789 19,500 13,711 70% 2215-000-346051-000 RECREATION FEES 578 8,000 7,422 93% 2215-000-346052-000 SPORTS PROGRAMS 5,110 44,055 38,945 88% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 534 2,000 1,466 73% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 6,190 65,160 58,970 91% 2215-000-346055-000 ICE RINK 0 25,000 25,000 100% 2215-000-346056-000 KIDSPORT USAGE 0 700 700 100% 2215-000-346057-000 YOUTH CAMPS 7,141 132,000 124,859 95% 2215-000-346059-000 PICNIC IN THE PARK 4,849 32,000 27,151 85% 2215-000-365010-000 FEC REFUNDS/DONATIONS 3,298 0 3,298- 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 334 2,000 1,666 83% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 0 86,000 86,000 100% TOTAL PARKS & REC REVENUE 146,835 1,530,915 1,384,080 90% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 44,734 314,562 269,828 86% 2215-436-460430-111 SEASONAL SALARIES 17,239 61,727 44,488 72% 2215-436-460430-121 OVERTIME 0 500 500 100% 2215-436-460430-153 HEALTH INSURANCE 4,755 69,412 64,657 93% 2215-436-460430-155 RETIREMENT 4,429 27,488 23,059 84% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 0 1,000 1,000 100% 2215-436-460430-224 JANITORIAL SUPPLIES 1,305 4,100 2,795 68% 2215-436-460430-229 OTHER SUPPLIES 458 4,000 3,542 89% 2215-436-460430-231 GAS 1,668 18,000 16,332 91% 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 1,646 16,000 14,354 90% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 0 25,000 25,000 100% 2215-436-460430-344 NATURAL GAS 38 3,000 2,962 99% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 366 2,800 2,434 87% 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 826 4,000 3,175 79% 2215-436-460430-364 LANDSCAPING 238 4,000 3,762 94% 2215-436-460430-367 VANDALISM REPAIRS 201 4,000 3,799 95% 2215-436-460430-373 DUES & TRAINING 510 6,000 5,490 92% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 0 600 600 100% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 12 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 3,500 7,500 4,000 53% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 0 1,700 1,700 100% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 6,612 39,673 33,061 83% 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) 6,200 40,500 34,300 85% 2215-436-460430-942 FVCC TENNIS INTERLOCAL AGREEMENT 0 7,000 7,000 100% SUBTOTAL PARKS EXPENDITURES 100,182 695,428 595,246 86% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 9,031 62,551 53,520 86% 2215-436-460440-111 SEASONAL SALARIES 14,749 49,778 35,029 70% 2215-436-460440-153 HEALTH INSURANCE 982 19,032 18,050 95% 2215-436-460440-155 RETIREMENT 1,228 6,472 5,244 81% 2215-436-460440-221 SAFETY EQUIPMENT 0 350 350 100% 2215-436-460440-229 OTHER SUPPLIES 6,205 14,500 8,295 57% 2215-436-460440-231 GAS 2,727 10,200 7,473 73% 2215-436-460440-241 CONSUMABLE TOOLS 500 1,500 1,000 67% 2215-436-460440-341 ELECTRICITY 1,632 7,700 6,068 79% 2215-436-460440-345 TELEPHONE & COMMUNICATION 25 175 150 86% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 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,260 4,000 2,740 69% 2215-436-460440-452 SAND & GRAVEL 170 1,000 830 83% 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 46,185 195,377 149,192 76% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 1,252 76,816 75,564 98% 2215-436-460431-111 SEASONAL SALARIES 2,820 8,244 5,424 66% 2215-436-460431-112 SEVERANCE 0 15,000 15,000 100% 2215-436-460431-153 HEALTH INSURANCE 408 23,280 22,872 98% 2215-436-460431-155 RETIREMENT 94 6,373 6,279 99% 2215-436-460431-229 MISC. SUPPLIES 1,082 8,264 7,182 87% 2215-436-460431-231 GAS 69 500 431 86% 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 14,857 18,632 3,775 20% 2215-436-460431-357 MUSIC FRANCHISE FEES 0 1,000 1,000 100% 2215-436-460431-373 DUES & TRAINING 0 600 600 100% SUBTOTAL RECREATION 20,781 169,449 148,668 88% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 2,869 61,207 58,338 95% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 13 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 2215-436-460448-111 SEASONAL SALARIES 57,618 126,562 68,944 54% 2215-436-460448-121 OVERTIME 114 300 186 62% 2215-436-460448-153 HEALTH INSURANCE 318 24,363 24,045 99% 2215-436-460448-155 RETIREMENT 218 6,443 6,225 97% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 57 400 343 86% 2215-436-460448-229 MISC. SUPPLIES 280 3,800 3,520 93% 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 53 620 567 92% 2215-436-460448-354 CONTRACT SERVICES 6,533 16,710 10,177 61% 2215-436-460448-355 AFTER SCHOOL PROGRAM 0 800 800 100% 2215-436-460448-356 BANK FEES/CC CHARGES 408 3,900 3,492 90% 2215-436-460448-357 OUT OF SCHOOL TIMES PROGRAM GRANT 3,630 20,000 16,370 82% 2215-436-460448-373 DUES & TRAINING 0 500 500 100% SUBTOTAL YOUTH CAMPS 72,099 266,255 194,156 73% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 111,128 190,325 79,197 42% 2215-437-460445-121 OVERTIME 35 500 465 93% 2215-437-460445-155 RETIREMENT 801 1,500 699 47% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 156 400 244 61% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 888 2,000 1,112 56% 2215-437-460445-226 CHLORINE/CHEMICALS 13,999 23,000 9,001 39% 2215-437-460445-228 CONCESSION STAND SUPPLIES 8,439 20,000 11,561 58% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 1,126 5,000 3,874 77% 2215-437-460445-341 ELECTRICITY 1,858 10,000 8,142 81% 2215-437-460445-344 NATURAL GAS 6,912 25,000 18,088 72% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 199 1,500 1,301 87% 2215-437-460445-354 LICENSES & FEES 0 1,300 1,300 100% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 1,205 34,000 32,795 96% 2215-437-460445-380 TRAINING MATERIALS 1,187 800 387- -48% SUBTOTAL POOL EXPENDITURES 147,934 315,325 167,391 53% TOTAL PARKS & RECREATION/POOL 387,180 1,641,834 1,254,654 76% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 14 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 14,276 101,667 87,391 86% 2600-436-460433-111 SEASONAL SERVICES 0 7,658 7,658 100% 2600-436-460433-121 OVERTIME 0 300 300 100% 2600-436-460433-153 HEALTH INSURANCE 1,617 22,404 20,787 93% 2600-436-460433-155 RETIREMENT 1,060 7,431 6,371 86% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 13 200 187 93% 2600-436-460433-231 GAS 0 1,500 1,500 100% 2600-436-460433-241 CONSUMABLE TOOLS 0 1,500 1,500 100% 2600-436-460433-354 CONTRACT SERVICES 0 45,000 45,000 100% 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 126 700 575 82% 2600-436-460433-364 LANDSCAPING & TREES 0 4,000 4,000 100% 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,221 7,325 6,104 83% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 1,437 8,624 7,187 83% 2600-436-460433-528 DATA PROCESSING TRANSFER 698 4,120 3,422 83% 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 27,697 291,679 263,982 91% 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% 0 2,253 2,253 100% 0 17,536 17,536 100% 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% 0 94,052 94,052 100% 0 1,277 1,277 100% 0 1,277 1,277 100% 0 11,000 11,000 100% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 15 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. TOTAL TRAILS 0 11.000 11.000 100% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 16 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 0 621,000 621,000 100% 2230-000-342070-000 COUNTY EMS LEVY 0 120,000 120,000 100% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 0 380,000 380,000 100% TOTAL AMBULANCE REVENUE 0 1,121,000 1,121,000 100% AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 84,484 593,366 508,882 86% 2230-440-420730-114 COMPTIME BUYBACK 0 3,500 3,500 100% 2230-440-420730-115 OUT OF RANK PAY 78 1,000 922 92% 2230-440-420730-121 OVERTIME 4,572 25,000 20,428 82% 2230-440-420730-153 HEALTH INSURANCE 11,323 146,576 135,253 92% 2230-440-420730-155 RETIREMENT 11,193 78,481 67,288 86% 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 457 7,560 7,103 94% 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 208 1,200 992 83% 2230-440-420730-354 PARAMEDIC RECERTIFICATION 1,440 11,800 10,360 88% 2230-440-420730-355 911 CENTER CONTRIBUTION 0 33,145 33,145 100% 2230-440-420730-359 AUDIT/CC OTHER FEES 176 1,400 1,224 87% 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 6,735 40,000 33,265 83% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 8,215 6,000 2,215- -37% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 2,651 15,903 13,253 83% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 6,536 39,213 32,677 83% 2230-440-420730-528 DATA PROCESSING TRANSFER 2,792 16,482 13,690 83% 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 142,636 1,224,726 1,082,090 88% 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 639 19,365 18,726 97% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 2,533 33,113 30,580 92% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 6,100 6,100 100% TOTAL HAZMAT GRANTS 3,172 61,078 57,906 95% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 17 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 96,121 250,000 153,879 62% 2394-000-323103-000 PLUMBING PERMITS 3,108 15,000 11,892 79% 2394-000-323104-000 MECHANICAL PERMITS 4,085 54,000 49,916 92% 2394-000-323108-000 PLAN REVIEW FEES 50,963 60,000 9,037 15% 2394-000-371010-000 INVESTMENT EARNINGS 393 2,000 1,607 80% TOTAL REVENUE 154,670 381,000 226,330 59% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 41,109 303,451 262,342 86% 2394-420-420530-121 OVERTIME 1,519 5,000 3,481 70% 2394-420-420530-153 HEALTH INSURANCE 4,502 59,827 55,325 92% 2394-420-420530-155 RETIREMENT 3,133 22,001 18,868 86% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 1,766 20,000 18,234 91% 2394-420-420530-231 GAS & OIL 125 3,000 2,875 96% 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 430 3,500 3,070 88% 2394-420-420530-354 CONTRACT SERVICES 18 3,300 3,282 99% 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 291 1,748 1,457 83% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 2,262 13,573 11,311 83% 2394-420-420530-528 DATA PROCESSING TRANSFER 2,792 12,361 9,569 77% 2394-420-420530-930 WEB BASED SOFTWARE PACKAGE 0 11,000 11,000 100% TOTAL BUILDING DEPT. 76,272 488,011 411,739 84% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 18 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 11,191 74,292 63,101 85% 2400-410-430263-153 HEALTH INSURANCE 884 12,693 11,809 93% 2400-410-430263-155 RETIREMENT 810 5,291 4,481 85% 2400-410-430263-244 STREET LIGHT SUPPLIES 640 18,000 17,360 96% 2400-410-430263-341 ELECTRICITY 13,143 169,000 155,857 92% 2400-410-430263-360 REPAIR & MAINT SERVICES 177 20,000 19,823 99% 2400-410-430263-510 INSURANCE 908 1,000 92 9% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 2,607 15,643 13,036 83% 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. 41,564 338,386 296,822 88% 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 7,174 50,000 42,826 86% 2420-421-430234-957 ALLEY PAVING 9,525 35,000 25,475 73% 2420-421-430240-231 GAS & OIL 2,405 43,000 40,595 94% 2420-421-430240-344 NATURAL GAS 26 5,500 5,474 100% 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 104,655 230,661 126,006 55% 2420-421-430240-452 GRAVEL 104 3,500 3,396 97% 2420-421-430240-453 EQUIPMENT RENTAL 3,960 10,000 6,040 60% 2420-421-430240-471 DE-ICER/ROAD OIL 0 40,000 40,000 100% 2420-421-430240-472 ASPHALT 6,015 40,000 33,986 85% 2420-421-430240-473 CRACK SEALING 3,720 14,500 10,780 74% TOTAL GAS TAX 137,584 609,661 472,077 77% 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% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 19 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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. 92,895 662,559 569,664 86% 2500-421-430240-112 RETIREMENT -severance 0 2,300 2,300 100% 2500-421-430240-121 OVERTIME 1,148 25,000 23,852 95% 2500-421-430240-153 HEALTH INSURANCE 11,681 152,162 140,481 92% 2500-421-430240-155 RETIREMENT 6,814 46,905 40,091 85% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 1,442 9,000 7,558 84% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 775 6,000 5,225 87% 2500-421-430240-220 OTHER SUPPLIES 1,170 4,100 2,930 71% 2500-421-430240-231 GAS & OIL 2,573 44,000 41,427 94% 2500-421-430240-341 ELECTRICITY 205 3,000 2,795 93% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 236 1,500 1,264 84% 2500-421-430240-354 CONTRACT SERVICES 296 30,000 29,704 99% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 1,012 32,500 31,488 97% 2500-421-430240-366 BUILDING MAINTENANCE 0 3,000 3,000 100% 2500-421-430240-373 DUES & TRAINING 611 5,500 4,889 89% 2500-421-430240-388 MEDICAL SERVICES 85 1,500 1,415 94% 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 27,561 165,366 137,805 83% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 13,784 82,703 68,919 83% 2500-421-430240-528 DATA PROCESSING TRANSFER 2,094 12,361 10,267 83% 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) 0 270,000 270,000 100% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 100% 2500-421-430264-110 TSS - SALARIES 17,284 122,651 105,367 86% 2500-421-430264-121 OVERTIME 425 7,500 7,075 94% 2500-421-430264-153 HEALTH INSURANCE 1,272 16,264 14,992 92% 2500-421-430264-155 RETIREMENT 1,264 8,613 7,349 85% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 62 1,500 1,438 96% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 435 6,700 6,265 94% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 924 3,500 2,576 74% 2500-421-430264-242 STREET SIGNS 4,886 40,000 35,114 88% 2500-421-430264-243 TRAFFIC SIGNALS 640 19,000 18,360 97% 2500-421-430264-245 BARRICADE MATERIALS 1,424 5,000 3,576 72% 2500-421-430264-341 ELECTRICITY 126 3,000 2,874 96% 2500-421-430264-345 COMMUNICATIONS 122 750 628 84% 2500-421-430264-354 CONTRACT SERVICES 230 10,000 9,770 98% 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 1,400 8,400 7,000 83% 2500-421-430264-532 OFFICE RENT 0 6,422 6,422 100% TOTAL SPEC. ST. MAINT. 362,965 2,588,348 2,225,383 86% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 20 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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% 698 4,120 3,422 83% 0 1,175 1,175 100% 0 150,000 150,000 100% 3,298 200,000 196,702 98% 3,996 420,795 416,799 99% 0 18,092 18,092 100% 0 3,983 3,983 100% 0 150,000 150,000 100% 0 172,075 172,075 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% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 21 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 0 5,961 5,961 100% 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. 0 810,713 810,713 100% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 22 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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% 7,061 59,252 52,191 88% 819 7,500 6,681 89% 684 11,824 11,140 94% 831 7,949 7,118 90% 1,449 5,841 4,392 75% 10,844 92,366 81,522 88% 0 37,032 37,032 100% 0 16,242 16,242 100% 0 4,976 4,976 100% 0 58,250 58,250 100% 434 4,000 3,566 89% 0 8,000 8,000 100% 4,721 36,000 31,279 87% 1,659 20,000 18,341 92% 10,440 21,886 11,446 52% 0 2,500 2,500 100% 0 7,000 7,000 100% 0 59,600 59,600 100% 17,254 158,986 141,732 89% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 23 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 24 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 405 0 405- 0% 5210-000-343210-000 METERED WATER SALES 752,034 2,810,000 2,057,966 73% 5210-000-343220-000 UNMETERED WATER SALES 243 0 243- 0% 5210-000-343225-000 IMPACT FEES 59,041 285,000 225,959 79% 5210-000-343230-000 METER REPLACEMENT FEE 16,892 98,000 81,108 83% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 875 37,000 36,125 98% 5210-000-343270-000 WATER TURN ON FEES 545 3,000 2,455 82% 5210-000-343275-000 TAG FEE 3,200 10,000 6,800 68% 5210-000-343365-000 LATECOMER ADMIN FEE 0 15,000 15,000 100% 5210-000-371010-000 INVESTMENT EARNINGS 4,292 36,000 31,708 88% TOTAL WATER REVENUE 837,527 3,294,000 2,456,473 75% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 96,112 690,169 594,057 86% 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 1,758 20,000 18,242 91% 5210-447-430550-153 HEALTH INSURANCE 9,809 146,271 136,462 93% 5210-447-430550-155 RETIREMENT 7,075 49,495 42,420 86% 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 2,399 11,000 8,601 78% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 1,023 8,500 7,477 88% 5210-447-430550-226 CHLORINE & CHEMICALS 5,337 38,000 32,663 86% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 268 4,500 4,232 94% 5210-447-430550-231 GAS & OIL 1,799 38,000 36,201 95% 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 19,883 139,000 119,117 86% 5210-447-430550-344 NATURAL GAS 183 15,500 15,317 99% 5210-447-430550-345 TELEPHONE & COMMUNICATION 1,557 9,000 7,443 83% 5210-447-430550-349 LAB SERVICES 731 22,000 21,269 97% 5210-447-430550-353 AUDITING 0 5,000 5,000 100% 5210-447-430550-354 CONTRACT SERVICES 876 55,000 54,124 98% 5210-447-430550-356 CONSULTANTS-WTR RIGHTS/MODELING 373 25,000 24,627 99% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 88 15,000 14,912 99% 5210-447-430550-366 BUILDING MAINTENANCE 0 12,000 12,000 100% 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 3,618 35,000 31,382 90% 5210-447-430550-422 HYDRANTS 222 8,000 7,778 97% 5210-447-430550-423 MATERIALS FOR MAINS 268 12,000 11,732 98% 5210-447-430550-424 MATERIALS -SERVICE LINES 1,117 16,000 14,883 93% 5210-447-430550-425 MATERIALS PUMPS/WELLS 191 45,000 44,809 100% 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 3,022 18,130 15,108 83% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 16,404 98,426 82,022 83% 5210-447-430550-528 DATA PROCESSING TRANSFER 5,583 32,964 27,381 83% 5210-447-430550-532 LEASE PAYMENTS (City Hall rent) 0 7,984 7,984 100% 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% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 25 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 268,133 3,679,255 3,411,122 93% WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 13,235 107,610 94,375 88% 5210-447-430560-112 SEVERANCE/RETIREMENT 0 1,500 1,500 100% 5210-447-430560-153 HEALTH INSURANCE 1,975 33,020 31,045 94% 5210-447-430560-155 RETIREMENT 1,000 8,014 7,014 88% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 0 5,000 5,000 100% 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 3,821 70,000 66,179 95% 5210-447-430560-373 DUES & TRAINING 934 2,500 1,566 63% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 1,289 7,731 6,443 83% 5210-447-430560-528 DATA PROCESSING TRANSFER 5,583 37,000 31,417 85% 5210-447-430560-532 RENT 0 6,422 6,422 100% SUBTOTAL WATER BILLING 27,837 282,317 254,480 90% 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% 357,600 5,055,853 4,698,253 93% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 26 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 405 0 405- 0% 5310-000-343310-000 SEWER SERVICE CHARGES 744,144 4,300,000 3,555,856 83% 5310-000-343330-000 IMPACT FEES (SANITARY) 72,518 220,000 147,482 67% 5310-000-343335-000 IMPACT FEES (WWTP) 99,795 300,000 200,205 67% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 0 5,000 5,000 100% 5310-000-371010-000 INVESTMENT EARNINGS 5,267 46,000 40,733 89% TOTAL SEWER REVENUE 922,128 4,871,000 3,948,872 81% SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 10,787 89,425 78,638 88% 5310-454-430620-112 SEVERANCE/RETIREMENT 0 1,500 1,500 100% 5310-454-430620-153 HEALTH INSURANCE 1,657 27,608 25,951 94% 5310-454-430620-155 RETIREMENT 814 6,653 5,839 88% 5310-454-430620-215 OFFICE SUPPLIES/computers 0 5,000 5,000 100% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 0 3,000 3,000 100% 5310-454-430620-355 BILLING COSTS 3,821 70,000 66,179 95% 5310-454-430620-373 DUES & TRAINING 934 2,500 1,566 63% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 1,143 6,857 5,714 83% 5310-454-430620-528 DATA PROCESSING TRANSFER 5,583 37,000 31,417 85% 5310-454-430620-532 OFFICE RENT 0 6,422 6,422 100% SUBTOTAL SEWER BILLING COSTS 24,740 255,965 231,225 90% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 35,474 251,563 216,089 86% 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 4,805 63,447 58,642 92% 5310-454-430630-155 RETIREMENT 2,618 18,160 15,542 86% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 1,584 9,200 7,616 83% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 606 8,350 7,744 93% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 272 2,000 1,728 86% 5310-454-430630-231 GAS & OIL 1,096 13,500 12,404 92% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 52 400 348 87% 5310-454-430630-341 ELECTRICITY 3,332 54,500 51,168 94% 5310-454-430630-344 NATURAL GAS 1,023 16,500 15,477 94% 5310-454-430630-345 TELEPHONE & COMMUNICATION 6,231 23,000 16,769 73% 5310-454-430630-353 AUDITING 0 3,000 3,000 100% 5310-454-430630-354 CONTRACT SERVICES 825 24,000 23,175 97% 5310-454-430630-356 CONSULTANTS 373 8,000 7,627 95% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 0 5,000 5,000 100% 5310-454-430630-373 DUES & TRAINING 510 3,500 2,990 85% 5310-454-430630-388 MEDICAL SERVICES 164 500 336 67% 5310-454-430630-410 CONSTRUCTION MATERIALS 3,262 9,000 5,738 64% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 1,711 50,000 48,289 97% 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,318 7,911 6,593 83% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 10,289 61,733 51,444 83% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 27 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 5310-454-430630-528 DATA PROCESSING TRANSFER 2,792 16,482 13,690 83% 5310-454-430630-532 OFFICE RENT 0 6,422 6,422 100% 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 129,555 1,387,467 1,257,912 91% IMPACT FEES 5310-454-430635-951 1ST ALLEY EN PIPE UPSIZE (34% RATE 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 5310-454-430635-957 3 MILE DR INTERCEPTOR 5310-454-430635-958 SPRING CREEK INTERCEPTOR DESIGN 5310-454-430635-961 2ND ALLEY WN - MONT TO CALF SUBTOTAL IMPACT FEE EXPENSE REVENUE BONDS/SANITARY 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.25% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25% SUBTOTAL REVENUE BONDS DEPRECIATION -SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION -SANITARY SUBTOTAL SANITARY SEWER 0 34,035 34,035 100% 0 101,071 101,071 100% 5,143 586,967 581,824 99% 14,368 742,981 728,613 98% 0 187,000 187,000 100% 19,511 1,652,054 1,632,543 99% 0 79,000 79,000 100% 17,134 17,134 0 0% 0 300 300 100% 17,134 96,434 79,300 82% 0 820,000 820,000 100% 0 820,000 820,000 100% 166,200 3, 955, 955 3,789,755 96% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 51,556 448,294 396,738 89% 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 3,134 22,500 19,366 86% 5310-455-430640-153 HEALTH INSURANCE 5,202 84,419 79,217 94% 5310-455-430640-155 RETIREMENT 4,000 32,035 28,035 88% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 544 10,000 9,456 95% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 647 2,700 2,053 76% 5310-455-430640-225 ALUM 0 20,000 20,000 100% 5310-455-430640-226 CHLORINE & CHEMICALS 260 19,000 18,740 99% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 736 7,000 6,264 89% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 28 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % Yr Complete G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING $ REMAINING 5310-455-430640-231 GAS & OIL 823 18,500 17,678 96% 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 14,161 178,500 164,339 92% 5310-455-430640-342 WATER 0 6,500 6,500 100% 5310-455-430640-344 NATURAL GAS 498 65,000 64,502 99% 5310-455-430640-345 TELEPHONE & COMMUNICATION 622 5,000 4,378 88% 5310-455-430640-353 AUDITING 0 4,000 4,000 100% 5310-455-430640-354 CONTRACT -GLACIER GOLD 16,701 124,000 107,299 87% 5310-455-430640-355 OTHER CONTRACT SERVICES 3,913 30,000 26,087 87% 5310-455-430640-356 CONSULTANTS 2,550 145,000 142,450 98% 5310-455-430640-358 CONSULTANT-TMDL 0 15,000 15,000 100% 5310-455-430640-360 MISC. MAINT SERVICES 2,934 30,000 27,066 90% 5310-455-430640-366 BUILDING MAINTENANCE 185 60,000 59,815 100% 5310-455-430640-373 DUES & TRAINING 710 7,500 6,790 91% 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 2,137 12,822 10,685 83% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 17,356 104,138 86,782 83% 5310-455-430640-528 DATA PROCESSING TRANSFER 4,187 24,723 20,536 83% SUBTOTAL WWTP OPERATIONS 171,915 1,534,981 1,363,066 89% WWTP BONDED PROJECT SUBTOTAL WWTP BONDED 0 0 0 0% WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 7,274 100,000 92,726 93% 5310-455-430645-933 SOLIDS DEWATERING DESIGN & CONST. 28,560 295,233 266,673 90% 5310-455-430645-934 SECONDARY DIGESTER LID INSPECTION 0 31,500 31,500 100% 5310-455-430645-936 DIGESTED SLUDGE LINE REPLACEMENT 0 300,000 300,000 100% 5310-455-430645-940 MACHINERY & EQUIPMENT 0 75,000 75,000 100% SUBTOTAL WWTP REPLACEMENT 35,834 801,733 765,899 96% WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 18,394 129,261 110,867 86% 5310-455-430646-153 HEALTH INSURANCE 2,358 29,319 26,961 92% 5310-455-430646-155 RETIREMENT 1,343 9,177 7,834 85% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 1,366 4,500 3,134 70% 5310-455-430646-218 NON -CAPITAL EQUIPMENT 134 2,500 2,366 95% 5310-455-430646-222 LAB SUPPLIES 2,115 8,500 6,385 75% 5310-455-430646-349 LAB SERVICES 519 29,000 28,481 98% 5310-455-430646-362 EQUIPMENT MAINTENANCE 213 4,000 3,787 95% 5310-455-430646-373 DUES & TRAINING 42 2,700 2,658 98% SUBTOTAL WWTP LAB OPERATIONS 26,484 218,957 192,473 88% DEBT SERVICE - WWTP 5310-455-490227-610 PRIN-WWTP IMP/SRF8164R/2.25% 0 778,000 778,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 234,011 234,012 1 0% 5310-455-490228-610 PRIN/WWTP DIGESTER LID/SRF13326/3.0 0 43,000 43,000 100% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 29 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % Yr Complete 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% 29,955 29,955 0 0% SUBTOTAL DEBT SERVICE - WWTP 263,966 1,084,967 821,001 76% CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-830 EVERGREEN REPLACEMENT TRANSFER 0 411,599 411,599 100% 5310-455-510400-831 DEPRECIATION EXPENSE 0 1,425,000 1,425,000 100% SUTOTAL WWTP DEPRECIATION/REPL 0 1,836,599 1,836,599 100% SUBTOTAL WWTP 498,199 5,477,237 4,979,038 91% TOTAL BILLING/SANITARY/WWTP 689,139 9,689,157 9,000,018 93% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 30 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 405 0 405- 0% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 0 2,500 2,500 100% 5349-000-343033-000 IMPACT FEES 39,831 150,000 110,169 73% 5349-000-343034-000 PERMIT FEES 220 0 220- 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. 316 2,000 1,684 84% 5349-000-371010-000 INTEREST ON INVESTMENTS 1,940 15,000 13,060 87% TOTAL STORM REVENUE 42,712 1,016,500 973,788 96% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 48,638 354,364 305,726 86% 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 5,668 84,814 79,146 93% 5349-453-430246-155 RETIREMENT 3,586 25,357 21,771 86% 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 1,096 11,500 10,404 90% 5349-453-430246-345 TELEPHONE & COMMUNICATION 66 800 734 92% 5349-453-430246-353 AUDITING 0 2,340 2,340 100% 5349-453-430246-354 CONTRACT SERVICE 210 6,000 5,790 97% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 0 25,000 25,000 100% 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 0 15,000 15,000 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 0 2,500 2,500 100% 5349-453-430246-362 GROUNDWATER MONITORING 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 496 3,500 3,004 86% 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,318 7,911 6,593 83% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 5,920 35,523 29,603 83% 5349-453-430246-528 DATA PROCESSING TRANSFER 2,094 12,361 10,267 83% 5349-453-430246-530 BNSF LEASE PMT 0 5,900 5,900 100% 5349-453-430246-532 OFFICE RENT 0 6,422 6,422 100% 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 0 100,000 100,000 100% 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 79,153 1,879,677 1,800,524 96% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 31 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 596 0 596- 0% 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 0 954,436 954,436 100% 5510-000-343420-000 GARBAGE COLLECTION -BILLED 357 23,000 22,644 98% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 541 2,500 1,959 78% 5510-000-371010-000 INVESTMENT EARNINGS 774 5,000 4,226 85% TOTAL SOLID WASTE REVENUE 2,268 984,936 982,668 100% SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 56,077 404,181 348,104 86% 5510-460-430840-112 SEVERANCE -RETIREMENT 0 61,975 61,975 100% 5510-460-430840-121 OVERTIME 204 5,500 5,296 96% 5510-460-430840-153 HEALTH INSURANCE 7,337 95,330 87,993 92% 5510-460-430840-155 RETIREMENT 4,077 28,610 24,533 86% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 1,250 9,500 8,250 87% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 0 35,000 35,000 100% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 755 5,500 4,745 86% 5510-460-430840-231 GAS & OIL 3,730 61,500 57,770 94% 5510-460-430840-331 PUBLICATION & FILING FEES 0 1,950 1,950 100% 5510-460-430840-341 ELECTRICITY 82 0 82- 0% 5510-460-430840-344 NATURAL GAS 25 4,900 4,875 99% 5510-460-430840-345 TELEPHONE & COMMUNICATION 232 850 618 73% 5510-460-430840-354 CONTRACT SERVICES 572 9,000 8,428 94% 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 100 650 550 85% 5510-460-430840-510 PROPERTY & LIABILITY INS. 10,696 10,000 696- -7% 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 0 3,000 3,000 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 10,231 61,388 51,157 83% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 5,531 33,186 27,655 83% 5510-460-430840-528 DATA PROCESSING TRANSFER 2,094 12,361 10,267 83% 5510-460-430840-532 OFFICE RENT 0 6,422 6,422 100% 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 0 35,000 35,000 100% 5510-460-430840-944 VEHICLES (Replacement $) 0 324,500 324,500 100% 5510-460-430845-224 JANITORIAL SUPPLIES 0 250 250 100% 5510-460-430845-341 ELECTRICITY 119 3,500 3,381 97% 5510-460-430845-342 WATER 0 500 500 100% 5510-460-430845-344 NATURAL GAS 26 6,500 6,474 100% 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 123,691 1,426,144 1,302,453 91% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 32 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 1,882 10,000 8,118 81% 5160-000-343069-000 HANGER LEASES 2,000 11,000 9,000 82% 5160-000-343071-000 HANGAR SITE LEASES 17,132 17,510 378 2% 5160-000-343101-000 FBO LEASE -RED EAGLE AVIATION 2,970 17,734 14,764 83% 5160-000-343102-000 GROUND LEASES 12,814 12,814 0- 0% 5160-000-343620-000 FUEL TAX 846 5,000 4,154 83% 5160-000-371010-000 INVESTMENT EARNINGS 114 850 736 87% TOTAL AIRPORT REVENUE 37,758 74,908 37,150 50% 5160 AIRPORT EXPENSES 5160-430-430310-210 OFFICE SUPPLIES & EQUIP 0 1,000 1,000 100% 5160-430-430310-341 ELECTRICITY 128 1,500 1,372 91% 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 0 10,000 10,000 100% 5160-430-430310-390 EQUIPMENT RENTAL 70 1,000 930 93% 5160-430-430310-510 PROPERTY INSURANCE 423 6,500 6,077 93% 5160-430-430310-522 ADMINISTRATIVE TRANSFER 553 3,320 2,767 83% 5160-430-430310-528 DATA PROCESSING TRANSFER 349 2,060 1,711 83% 5160-430-430310-820 DEPRECIATION 0 97,918 97,918 100% TOTAL AIRPORT EXPENSES 10,523 166,798 156,275 94% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 33 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 0 155,000 155,000 100% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 0 180,000 180,000 100% 6030-000-371010-000 INVESTMENT EARNINGS 55 500 445 89% 6030-000-393000-000 INTERNAL SERVICES -DATA 38,734 224,567 185,833 83% TOTAL INFORMATION TECH REVENUE 38,789 560,067 521,278 93% INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 22,190 162,290 140,100 86% 6030-401-410580-121 OVERTIME 0 2,500 2,500 100% 6030-401-410580-153 HEALTH INSURANCE 2,732 33,424 30,692 92% 6030-401-410580-155 RETIREMENT 1,706 12,305 10,599 86% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 0 4,050 4,050 100% 6030-403-410580-215 COMPUTER SUPPLIES 420 2,400 1,980 83% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 1,944 16,800 14,856 88% 6030-403-410580-325 WEBSITE 196 17,000 16,804 99% 6030-403-410580-345 PAGER/PHONE 324 1,800 1,476 82% 6030-403-410580-346 SUMMITNET & ISPS 791 9,800 9,009 92% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,432 4,000 568 14% 6030-403-410580-354 MAINTENANCE CONTRACTS 12,564 42,266 29,702 70% 6030-403-410580-355 LICENSES 1,803 24,500 22,697 93% 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 200 1,300 1,100 85% 6030-403-410585-229 COPIER,FAX, SUPPLIES 578 17,400 16,822 97% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 8,987 73,000 64,013 88% 6030-403-410585-532 COPIER LEASES 1,484 15,000 13,516 90% 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 0 3,660 3,660 100% 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 0 26,160 26,160 100% 6030-413-410588-354 POLICE - HOSTED SERVER 0 2,000 2,000 100% 6030-416-410588-218 COMPUTERS - FIRE 0 9,195 9,195 100% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 2,100 8,566 6,466 75% 6030-436-410588-218 COMPUTERS - PARKS 0 1,935 1,935 100% 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 1,855 1,855 100% TOTAL INFORMATION TECH EXPENSE 68,824 588,744 519,920 88% 09.08.2015 10:51 THE CITY OF KALISPELL, MONTANA Page 34 of 34 gb8501_pg.php/Job No: 12489 USER: RGW FY16 FINANCIAL REPORT JULY 1, 2015 THRU AUGUST 31, 2015 16.67 % 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 77,415 464,491 387,076 83% 6010-000-371010-000 INVESTMENT EARNINGS 11 30 19 62% TOTAL CENTRAL GARAGE REVENUE 77,427 464,521 387,094 83% CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 19,109 164,028 144,919 88% 6010-410-431330-121 OVERTIME 0 2,500 2,500 100% 6010-410-431330-153 HEALTH INSURANCE 1,642 27,341 25,699 94% 6010-410-431330-155 RETIREMENT 1,284 11,661 10,377 89% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 4,352 9,000 4,648 52% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 212 14,000 13,788 98% 6010-410-431330-230 OIL 2,012 25,000 22,988 92% 6010-410-431330-231 GAS 113 3,000 2,887 96% 6010-410-431330-232 VEHICLE PARTS 24,466 103,000 78,534 76% 6010-410-431330-233 TIRES 5,404 35,000 29,596 85% 6010-410-431330-238 FILTERS 1,426 7,700 6,274 81% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 0 2,000 2,000 100% 6010-410-431330-341 ELECTRICITY 131 1,950 1,819 93% 6010-410-431330-344 NATURAL GAS 58 9,000 8,942 99% 6010-410-431330-354 CONTRACT SERVICES 1,562 31,000 29,438 95% 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 0 300 300 100% 6010-410-431330-510 INSURANCE 2,511 2,500 11- -0% 6010-410-431330-528 INFORMATION TECH TRANSFER 1,396 8,241 6,845 83% TOTAL CENTRAL GARAGE EXPENSES 65,676 465,421 399,745 86%