Loading...
01-18-19 City Manager Report1 City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 1/18/2019 1. Public Works Stormwater Cleaning Public Works crews have begun cleaning stormwater mains on Center Street from 1st Ave. W to 5th Ave. W, and 5th Ave. W from Center Street to 8th St. W. Crews are experiencing heavy sediment in some areas, which requires a great deal of time to properly clean. Sediment removed from the conveyance helps us achieve compliance with our Stormwater MS4 Permit and keeps sediment out of our local water bodies. Stormwater Detention Facility In preparation for the redevelopment and reconstruction of the Sylvan Stormwater Detention Facility, Public Works crews are removing dead, downed, and hazardous trees within the facility. Heavy equipment will be working in and around the path that goes from Willow Glen to Woodland Avenue. Pedestrians and bicyclists are cautioned to be aware of equipment as they use the path throughout the project area. This work helps promote a healthy stormwater detention pond free of unnecessary debris. 2. Parks and Recreation Department The Parks Department received a new Toro Groundsmaster 5900 16’ mower for the Kalispell Youth Athletic Complex. This new mower will help reduce current mow times and provide needed relief to our current 2011 16’ mower. 2 Park staff have been taking advantage of the unseasonably warm weather to clean up brush, limbs and trees that has built up around the pedestrian trails making them more user friendly. The Forestry Division has rented a small lift to be able to reach medium sized trees that need pruned through many of the newer subdivisions. This has allowed our boom truck to continue work on larger trees. 3rd Avenue West, and Aspen Creek subdivision are now complete. Crews are now on 2nd Avenue West, Silverbrook Estates and Buffalo Stage subdivisions. The last day for Christmas tree pickup will be Saturday January 19, thanks to a volunteer group. Please have trees in the boulevard free of lights, stands and ornaments. Our contractor has completed the first phase of thinning of the understory brush on the Woodland Park hillside. The goal is to reduce the density for security while still maintaining a natural look. Parks crews will start to reclaim lower portions for maintenance purposes as weather permits. The pond at Woodland finally provided us with enough ice to start maintenance efforts of use. We offered our annual Freeze Out Camp over winter break for grades K-5 on December 26-28. The kids spent their mornings doing arts and crafts, playing games, scavenger hunts, and other activities. Each afternoon we had a variety of field trips scheduled including trips to the Kalispell Fire Station, the Woodland Ice Center, and the Rockfish Indoor Climbing Gym. Special thanks to the staff at the Fire Department for the wonderful tour. We will be starting a new 6-week adult broomball league starting on Sunday, February 3 at the Woodland Ice Center. Broomball is a game very similar to hockey in its formation and rules, but also incorporates some soccer strategies. The game is played on a hockey rink with two teams consisting of six players on each side (a goalie, two defensemen and three forwards). Each player uses a stick (a shaft with a molded broom-shaped head) to maneuver a six-inch diameter ball up and down the ice. Instead of skates, players wear shoes so participants do not need to know how to skate. The Kalispell Brewing Company has donated $380 for the purchase of equipment and Bias Brewing is sponsoring prizes for the league. We are half way through our ice skating lessons at the Woodland Ice Center. We still have spots available for Sessions 3, starting January 22, and Session 4, starting February 5. 3 3.Community Development WGM Group will present preliminary design alternatives and cost estimates on the Airport Road and 18th Street West/1st Avenue West project to the Urban Renewal Agency (URA) at its January 16 meeting. At the request of City Council, the URA is reviewing concepts 8 and 9 from the original set provided by WGM. The 18th Street Realignment (formerly concept 8) is distinguished by its re-alignment of 18th Street and 1st Avenue West to square up the intersection while the 16th Street Offset (formerly concept 9) removes the west leg of 18th Street from the intersection and introduces a new street connection to the north at 16th Street West. Both designs create parking on the currently vacant city lot located between 1st Avenue West and Airport Road and both provide for significant sidewalk development. URA recommendations move on to City Council for consideration. 18th Street Realignment (formerly concept 8): 16th Street Offset (formerly concept 9): The Kalispell Urban Renewal Agency and Community Development Department have issued the 2017-2018 Annual Tax Increment Financing (TIF) Report. The report is produced to provide information on activity of the City TIF districts for the period and includes history on each district to date. The report is available on the City of Kalispell website at: https://www.kalispell.com/DocumentCenter/View/2043/Annual-Tax- Increment-Financing-District-Report 4.Fire Department Since the last update, the Kalispell Fire Department has received 148 calls for service. Crews this week have been busy providing outreach trainings. Kalispell Fire Regional Hazmat Team members recently provided Lincoln County LEPC 2 hours of outreach instruction on Hazmat Team procedures, capabilities, and equipment as part of the hazmat awareness outreach. Fire department staff have also provided blood borne pathogens training and basic meth 4 lab awareness training to other city departments and staff. This training involves education on common pathogens that they might encounter in their work environment and the proper procedures for protecting themselves from accidental exposures and contaminations. Fire department staff are currently re-certifying their EMS licensure for the EMT and Paramedic certifications through the state and national registries. Fire department staff are also receiving their training and skills testing for CPR certification as required. 5.Building Department New construction activity is off to a slow start. There were no single family or duplex houses approved since the New Year. A three story, 24-plex apartment building was issued at North Town Center on Jefferson Avenue with construction slated for this spring. 6.Planning Department The planning department has prepared a draft Request for Qualifications for the update to our 2006 Kalispell Area Transportation plan. The draft RFQ was sent to the Helena Office of the Department of Transportation for review and comment. The City has $100,000 budgeted for this update. We are asking MDT to contribute an additional $150,000 for the study. Once the contract is approved and a professional design team is selected, it is anticipated that the plan will take approximately 12-15 months to complete. 7.Police Department Attached is the 2018 case and arrest report from the police department. For comparison purposes, I am also attaching the 2017 report. On January 7, Officer Tara Oster reported to the Montana Law Enforcement Academy (MLEA) in Helena. This is an intensive 12-week course to include education and training in the fundamentals of law, human behavior, police function, patrol operations, investigation, traffic enforcement, and police proficiencies. A young man by the name of Hunter Arentz will start as an intern this week. The Kalispell Police Department internship program runs approximately six months. Participants ride along with officers learning the career of a police officer. They must complete a training manual similar to that of new officers and receive an extensive look into the day-to-day operations of the police department. Detective Karen Webster attended the Montana Children’s Justice Conference on January 16 and 17 in Big Sky. The Montana Children’s Justice Conference is an advanced training sponsored by the Children’s Alliance of Montana, an accredited Chapter of the National Children’s Alliance and MCSART program of the Montana Department of Justice Children’s Justice Bureau. Detective Webster will receive furthering education 5 on the investigation of child abuse, sexual assault, and preparation for trial. On January 16, Canine Officer Jason Parce and Cairo conducted a canine presentation at Summit Preparatory School in Smith Valley. 8.Finance Department Attached is the quarterly financial report. General Fund revenue reflects taxes collected thru December 31. Some first half taxes received by the County aren’t distributed to the City until the County completes the distribution in January. Last year, the general fund received over $700,000 of first half taxes in January. A similar distribution this January would bring collections to about 56% of the budgeted annual amount ($6,222,000). The City is currently carrying less than $17,000 in protest taxes in the General Fund – which are held by the County. City Court fines and fees revenue only reflects July thru November (5 months). Parks tax revenues should also be about 56% after the County’s January distribution. Youth camps revenue, and many of the other user based parks fees, historically receives more of their revenue in the 2nd half of the fiscal year (spring). Ambulance fees for services ($308,201) are down 20% from last year ($381,272). The first half of the County EMS levy has not yet been received. Building department permits and fees are on pace with the budgeted annual amounts. The approximately $420,000 of permits and fees collected in the first half of this fiscal year is about 44% of the annual budget. Metered water sales through December were $1,969,086, this is 68% of the budgeted amount. It is normal for July through December metered water sales to be in excess of 50%, normally about 60%, of the annual amount because of late summer and fall sprinkling and irrigation. This above normal water revenue can be attributed to the dry summer that was experienced in Northwest Montana. Water impact fees are over 80% of the fiscal year 2019 budgeted amount of $500,000. Sewer service charges were $2,339,398, just over half (52%) of the budgeted amount. Last year’s 1st half sewer service charges were $2,334,373. Sanitary sewer and treatment plant impact fees are both over 85% of the anticipated fiscal year 2019 amount. Storm sewer and Solid Waste revenue reflect assessments billed for fiscal year 2019. Assessments collected for the storm sewer fund are about $660,000, and for the solid waste fund are just over $440,000. These amounts do not include the January distribution from the County. The January distribution of first half assessment collections should bring total collections to excess of 50% of the annual budget for both of these funds. Storm impact fees ($75,496) are 38% of the budgeted fiscal year 2019 amount. 6 EXPENDITURES/EXPENSES: General Fund expenditures reflect 45% spent. Some major expenditures such as liability and property insurance are paid during the first quarter for the entire year. This could result in expenditures not being evenly distributed over the fiscal period. For most funds, expenditures/expenses include the 13th (of 26) payroll period ending December 22. Most departments and/or funds have over 50% remaining in the salaries and retirement lines which should be adequate. The majority of fire department and ambulance fund employees are paid 13 times annually. This 1st half report includes the 6th of 13 (45%) pay periods for these employees. With a few exceptions, administrative, central garage, and information technology transfers are done monthly and should show 50% remaining. This is the same on the revenue side for fees for services (Central Garage), internal services (Information Technology) and administrative charges (General Fund). The general fund administrative charges may vary slightly as some charges are based on a percentage of revenues collected. Annual budgeted operating transfers are also generally done monthly or quarterly and should show 50% remaining. THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 1 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 2,792,788 6,222,000 3,429,212 55% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 8,230 16,500 8,271 50% 1000-000-311200-000 PERSONAL PROPERTY TAXES 147,973 145,000 2,973- -2% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 4,941 8,000 3,059 38% 1000-000-322101-000 LIQUOR LICENSES 0 30,000 30,000 100% 1000-000-322300-000 BUSINESS LICENSES 507 1,700 1,193 70% 1000-000-323012-000 PLANNING FEES 45,137 60,000 14,863 25% 1000-000-323109-000 SITE REVIEW 9,860 15,000 5,140 34% 1000-000-323200-000 PARADE PERMITS 100- 1,000 1,100 110% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 1,500 1,500 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 58,300 60,000 1,700 3% 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,400 1,000 400- -40% 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 1,439,261 2,878,523 1,439,262 50% 1000-000-341020-000 ADMINISTRATIVE CHARGES 312,923 628,533 315,610 50% 1000-000-341021-000 GRANT ADMIN FEES 5,089 80,000 74,911 94% 1000-000-341025-000 CITY COLLECTIONS 7,332 5,000 2,332- -47% 1000-000-342010-000 POLICE SERVICES 15,943 25,000 9,057 36% 1000-000-342014-000 RESOURCE OFFICERS 209,187 209,187 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 0 12,000 12,000 100% 1000-000-343018-000 PARKING PERMITS 48,544 95,000 46,456 49% 1000-000-343062-000 AIRPORT FUEL TAX 2,507 6,578 4,071 62% 1000-000-343063-000 AIRPORT GROUND LEASE 14,423 14,422 1- 0% 1000-000-351000-000 CITY COURT FINES & FEES 163,278 450,000 286,722 64% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 10,953 20,000 9,047 45% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 27,883 50,000 22,118 44% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 0 20,000 20,000 100% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 7,149 5,000 2,149- -43% 1000-000-371010-000 INVESTMENT EARNINGS 25,482 25,000 482- -2% 1000-000-373030-000 INTEREST ON OLD SCHOOL SID LOAN - 1 0 48,750 48,750 100% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 444,500 889,000 444,500 50% ------------------------------------------------- TOTAL GENERAL FUND REVENUE 5,803,489 12,023,693 6,220,204 52% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 2 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 3,000 2,935 65- -2% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 3,750 14,250 10,500 74% 1000-400-410530-354 OPEB EXPENSE 1,100 0 1,100- 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 980 4,000 3,020 76% 1000-400-410560-312 POSTAGE 10,114 17,000 6,886 41% 1000-400-410560-320 PRINTING & ENVELOPES 2,975 4,000 1,025 26% 1000-400-410560-354 CONTRACT SERVICES - DOC. SHREDDING 90 250 160 64% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 962 4,000 3,038 76% 1000-400-420000-354 CONTRACT 911 CENTER 255,908 510,000 254,092 50% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 354 400 46 11% 1000-400-430300-355 AIRPORT REIMBURSEMENT 16,676 21,000 4,324 21% 1000-400-460000-820 TRANSFER TO FORESTRY 50,000 100,000 50,000 50% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 0 15,000 15,000 100% 1000-400-460452-366 HOCKADAY MAINTENANCE 0 6,600 6,600 100% 1000-400-510300-000 CONTINGENCY 0 30,000 30,000 100% 1000-400-510310-354 ICMA PLAN FEES 250 500 250 50% 1000-400-510330-513 LIABILITY INSURANCE 75,391 73,483 1,908- -3% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 24,543 50,000 25,457 51% 1000-400-510330-517 PROPERTY INSURANCE 50,760 50,760 0- 0% ------------------------------------------------- SUBTOTAL GEN.GOV'T. 496,853 904,178 407,325 45% CITY MANAGER 1000-401-410210-110 SALARIES-CITY MANAGER'S OFFICE 67,652 144,715 77,063 53% 1000-401-410210-153 HEALTH INSURANCE 12,518 22,723 10,205 45% 1000-401-410210-155 RETIREMENT 7,269 15,332 8,063 53% 1000-401-410210-210 SUPPLIES 492 2,000 1,508 75% 1000-401-410210-312 NEWSLETTER/BOOKS 220 400 180 45% 1000-401-410210-345 TELEPHONE & COMMUNICATION 480 2,190 1,710 78% 1000-401-410210-373 DUES & TRAINING 5,031 11,000 5,969 54% 1000-401-410210-379 MEETINGS 1,648 5,000 3,352 67% ------------------------------------------------- SUBTOTAL CITY MANAGER 95,310 203,360 108,050 53% HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 61,915 130,303 68,388 52% 1000-401-410830-121 OVERTIME 241 0 241- 0% 1000-401-410830-153 HEALTH INSURANCE 7,680 17,344 9,664 56% 1000-401-410830-155 RETIREMENT 4,925 10,185 5,260 52% 1000-401-410830-210 OFFICE SUPPLIES 203 600 397 66% 1000-401-410830-338 RECRUITMENT/RELOCATION 5,754 8,000 2,246 28% 1000-401-410830-354 CONTRACT SERVICES 460 1,000 541 54% 1000-401-410830-373 DUES & TRAINING 5,554 6,500 946 15% ------------------------------------------------- SUBTOTAL HUMAN RESOURCES 86,730 173,932 87,202 50% THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 3 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 30,106 63,107 33,001 52% 1000-402-410100-153 HEALTH INSURANCE 20,490 62,903 42,413 67% 1000-402-410100-155 RETIREMENT 1,224 2,481 1,257 51% 1000-402-410100-210 OFFICE SUPPLIES 0 500 500 100% 1000-402-410100-335 MT LEAGUE OF CITIES 1,156 6,498 5,342 82% 1000-402-410100-354 CONTRACT SERVICES 879 7,030 6,151 88% 1000-402-410100-373 DUES & TRAINING 9,866 8,576 1,290- -15% 1000-402-410100-379 MEETINGS 15,543 19,500 3,957 20% ------------------------------------------------- SUBTOTAL MAYOR/COUNCIL 79,264 170,595 91,331 54% CITY CLERK 1000-402-410150-110 SALARIES-CITY CLERK 44,267 93,439 49,172 53% 1000-402-410150-121 OVERTIME 53 250 197 79% 1000-402-410150-153 HEALTH INSURANCE 8,332 20,230 11,898 59% 1000-402-410150-155 RETIREMENT 3,516 7,349 3,833 52% 1000-402-410150-210 OFFICE SUPPLIES 69 300 231 77% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 110 600 490 82% 1000-402-410150-345 TELEPHONE & COMMUNICATION 240 480 240 50% 1000-402-410150-352 CODIFICATION 0 4,100 4,100 100% 1000-402-410150-354 CONTRACT SERVICES 0 300 300 100% 1000-402-410150-373 DUES & TRAINING 1,694 3,200 1,506 47% ------------------------------------------------- SUBTOTAL CITY CLERK 58,280 130,248 71,968 55% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES-FINANCE OFFICE 103,188 202,052 98,864 49% 1000-403-410550-112 SALARIES-RETIREMENT 22,908 24,871 1,963 8% 1000-403-410550-121 OVERTIME 241 0 241- 0% 1000-403-410550-153 HEALTH INSURANCE 16,766 38,637 21,871 57% 1000-403-410550-155 RETIREMENT 8,126 15,863 7,737 49% 1000-403-410550-210 SUPPLIES 317 1,000 683 68% 1000-403-410550-322 BOOKS 0 300 300 100% 1000-403-410550-353 CONTRACT SERVICES 120 540 420 78% 1000-403-410550-354 CONTRACT-GRIZZLY SECURITY 336 1,200 864 72% 1000-403-410550-355 BANK CHARGES & FEES 1,500 3,200 1,700 53% 1000-403-410550-373 DUES & TRAINING 3,647 7,500 3,853 51% ------------------------------------------------- SUBTOTAL FINANCE 157,149 295,163 138,014 47% THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 4 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CITY ATTORNEY 1000-404-411110-110 SALARIES-CITY ATTORNEY'S 177,874 382,200 204,326 53% 1000-404-411110-153 HEALTH INSURANCE 23,986 61,927 37,941 61% 1000-404-411110-155 RETIREMENT 14,083 30,045 15,962 53% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 1,328 2,563 1,235 48% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 11,905 8,500 3,405- -40% 1000-404-411110-345 TELEPHONE & COMMUNICATION 421 1,025 604 59% 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 20,583 62,400 41,818 67% 1000-404-411110-373 DUES & TRAINING 2,524 7,000 4,476 64% ------------------------------------------------- SUBTOTAL CITY ATTORNEY 252,703 555,660 302,957 55% MUNICIPAL COURT 1000-406-410360-110 SALARIES-COURT 111,483 233,996 122,513 52% 1000-406-410360-121 OVERTIME 1,283 0 1,283- 0% 1000-406-410360-153 HEALTH INSURANCE 14,220 43,902 29,682 68% 1000-406-410360-155 RETIREMENT 8,887 18,350 9,463 52% 1000-406-410360-210 SUPPLIES 1,733 4,500 2,767 61% 1000-406-410360-320 PRINTING/BOOKS 929 1,500 571 38% 1000-406-410360-345 TELEPHONE & COMMUNICATION 29 1,400 1,371 98% 1000-406-410360-353 SECURITY & TECHNOLOGY 8,781 40,000 31,219 78% 1000-406-410360-354 CONTRACT SERVICES 714 5,750 5,036 88% 1000-406-410360-373 DUES & TRAINING 911 10,000 9,089 91% 1000-406-410360-394 JURY & WITNESS FEES 347 7,500 7,154 95% ------------------------------------------------- SUBTOTAL COURT 149,317 366,898 217,581 59% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES-PUBLIC WORKS 8,706 18,149 9,443 52% 1000-410-430100-153 HEALTH INSURANCE 1,311 3,285 1,974 60% 1000-410-430100-155 RETIREMENT 681 1,396 715 51% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 6,309 14,000 7,691 55% 1000-410-430100-231 GAS 1,178 3,000 1,822 61% 1000-410-430100-345 TELEPHONE & COMMUNICATION 141 350 209 60% 1000-410-430100-354 CONTRACT SERVICES 141 2,000 1,859 93% 1000-410-430100-373 DUES & TRAINING 656 2,500 1,844 74% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 2,217 4,434 2,217 50% ------------------------------------------------- SUBTOTAL PUBLIC WORKS ADMIN 21,340 49,114 27,774 57% CITY HALL MAINT. 1000-412-411230-110 SALARIES-CITY HALL 33,223 70,063 36,840 53% 1000-412-411230-121 OVERTIME 21 200 179 89% 1000-412-411230-153 HEALTH INSURANCE 5,520 14,419 8,899 62% 1000-412-411230-155 RETIREMENT 2,533 5,268 2,735 52% 1000-412-411230-220 SECURITY IMPROVEMENTS 630 2,000 1,370 69% 1000-412-411230-224 JANITORIAL SUPPLIES 1,505 6,000 4,495 75% 1000-412-411230-241 TOOLS & SUPPLIES 610 1,500 890 59% 1000-412-411230-341 ELECTRICITY 20,472 47,000 26,528 56% 1000-412-411230-344 NATURAL GAS 11,928 30,000 18,072 60% 1000-412-411230-345 TELEPHONE & COMMUNICATION 135 400 265 66% THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 5 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-354 CONTRACT SERVICES 6,131 25,000 18,869 75% 1000-412-411230-355 HVAC MAINTENANCE OCNTRACT 16,068 16,500 432 3% 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 240 6,000 5,760 96% 1000-412-411230-362 EQUIPMENT MAINTENANCE 485 10,000 9,515 95% 1000-412-411230-366 BUILDING MAINTENANCE 2,465 27,500 25,035 91% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,014 3,700 686 19% 1000-412-411230-920 BLDG IMP (ENTRYWAY,MEZZANINE, SHOOT 7,356 22,500 15,144 67% ------------------------------------------------- SUBTOTAL CITY HALL 112,335 288,050 175,715 61% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES-PLANNING & ZONING 130,129 278,527 148,398 53% 1000-420-411020-153 HEALTH INSURANCE 22,774 60,251 37,477 62% 1000-420-411020-155 RETIREMENT 10,306 21,867 11,561 53% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 490 6,000 5,510 92% 1000-420-411020-231 GAS 208 300 92 31% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 485 2,000 1,516 76% 1000-420-411020-345 TELEPHONE 451 1,000 549 55% 1000-420-411020-354 CONTRACT SERVICES 126 2,000 1,874 94% 1000-420-411020-373 DUES & TRAINING 2,810 7,000 4,190 60% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 564 1,129 565 50% ------------------------------------------------- SUBTOTAL PLANNING DEPT. 168,342 380,074 211,732 56% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 31,558 64,795 33,237 51% 1000-480-470210-153 HEALTH INSURANCE 5,382 14,329 8,947 62% 1000-480-470210-155 RETIREMENT 2,508 5,060 2,552 50% 1000-480-470210-210 OFFICE SUPPLIES 386 1,500 1,114 74% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 0 750 750 100% 1000-480-470210-312 POSTAGE & PRINTING 26 500 474 95% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 500 500 0 0% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 172 900 728 81% 1000-480-470210-354 CONTRACT SERVICES 0 1,500 1,500 100% 1000-480-470210-373 DUES & TRAINING 3,131 5,000 1,869 37% 1000-480-470210-379 MEETINGS 1,223 1,500 277 18% ------------------------------------------------- SUBTOTAL COMMUNITY DEVELOPMENT 44,885 96,334 51,449 53% THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 6 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES-POLICE 1,054,294 2,290,530 1,236,236 54% 1000-413-420140-114 SALARY -comptime buyout 15,028 11,600 3,428- -30% 1000-413-420140-121 OVERTIME (REG & AET OT) 33,013 80,000 46,987 59% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 5,951 25,000 19,049 76% 1000-413-420140-153 HEALTH INSURANCE 171,398 447,526 276,128 62% 1000-413-420140-155 RETIREMENT 131,819 299,512 167,693 56% 1000-413-420140-210 OFFICE SUPPLIES 1,531 3,500 1,969 56% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 7,820 5,500 2,320- -42% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 2,682 31,500 28,818 91% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 2,357 4,000 1,643 41% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 3,671 7,000 3,329 48% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 337 2,000 1,663 83% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 800 24,500 23,700 97% 1000-413-420140-227 AMMO & RELATED SUPPLIES 1,705 33,450 31,745 95% 1000-413-420140-228 PATROL CAR SUPPLIES 818 15,000 14,182 95% 1000-413-420140-229 OTHER SUPPLIES 1,190 5,000 3,810 76% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 574 1,000 426 43% 1000-413-420140-231 GAS 37,775 75,000 37,225 50% 1000-413-420140-234 CRISIS NEGOTIATIONS 942 2,000 1,058 53% 1000-413-420140-235 BIKE PATROL 0 750 750 100% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 0 1,500 1,500 100% 1000-413-420140-320 PRINTING 1,505 5,500 3,996 73% 1000-413-420140-345 TELEPHONE & COMMUNICATION 10,010 17,500 7,490 43% 1000-413-420140-354 CONTRACT SERVICES 8,926 15,750 6,824 43% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 3,000 6,500 3,500 54% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 764 5,000 4,236 85% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 837 2,000 1,163 58% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 24,566 27,000 2,434 9% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 539 2,500 1,961 78% 1000-413-420140-373 DUES & TRAINING 14,021 40,500 26,479 65% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 0 14,500 14,500 100% 1000-413-420140-380 TRAINING MATERIALS 2,952 3,000 48 2% 1000-413-420140-388 MEDICAL SERVICES 1,449 3,000 1,551 52% 1000-413-420140-392 BOARDING/TREATING PRISONERS 784 2,500 1,716 69% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 39,874 79,749 39,875 50% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 32,000 64,000 32,000 50% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 1,750 3,500 1,750 50% 1000-413-420140-940 TRAILER (FY18) / 5-PORTABLE RADIOS 28,710 30,000 1,290 4% 1000-413-420140-942 DIGITICKET (FY18) / IRECORD REPLACE 0 22,000 22,000 100% 1000-413-420140-944 VEHICLES 0 134,700 134,700 100% ------------------------------------------------- SUBTOTAL POLICE DEPT. 1,645,392 3,845,067 2,199,675 57% DETECTIVES 1000-413-420141-110 SALARIES-DETECTIVES 179,163 367,855 188,692 51% 1000-413-420141-121 DETECTIVE-OVERTIME 7,956 15,000 7,044 47% 1000-413-420141-153 HEALTH INSURANCE 33,468 72,770 39,302 54% 1000-413-420141-155 DETECTIVE-RETIREMENT 23,694 49,247 25,553 52% ------------------------------------------------- TOTAL DETECTIVES 244,281 504,872 260,591 52% RECORDS 1000-413-420142-110 SALARIES-RECORDS DIVISION 68,824 145,239 76,415 53% THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 7 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-121 OVERTIME 743 7,500 6,757 90% 1000-413-420142-153 HEALTH INSURANCE 13,660 33,814 20,154 60% 1000-413-420142-155 RETIREMENT 5,458 11,359 5,901 52% ------------------------------------------------- TOTAL RECORDS 88,685 197,912 109,227 55% RESOURCE OFFICERS 1000-413-420144-110 SALARIES-SRO 134,428 268,582 134,154 50% 1000-413-420144-153 HEALTH INSURANCE 17,505 62,569 45,064 72% 1000-413-420144-155 SRO RETIREMENT 16,594 36,047 19,453 54% ------------------------------------------------- TOTAL RESOURCE OFFICERS 168,527 367,198 198,671 54% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL-SALARIES 20,985 41,770 20,785 50% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 3,415 9,885 6,470 65% 1000-413-420145-155 RETIREMENT 1,553 3,266 1,713 52% ------------------------------------------------- SUBTOTAL ANIMAL CONTROL 25,953 55,421 29,468 53% PARKING 1000-413-420147-110 PARKINGS -SALARIES 38,586 80,091 41,505 52% 1000-413-420147-153 HEALTH INSURANCE 12,587 32,709 20,122 62% 1000-413-420147-155 RETIREMENT 2,973 6,261 3,288 53% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 1,083 4,000 2,917 73% 1000-413-420147-354 CONTRACTED SERVICES 146 2,000 1,854 93% 1000-413-420147-362 LOT MAINT 621 10,000 9,379 94% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 280 17,500 17,220 98% 1000-413-420147-550 LOT LEASE PAYMENTS 573 1,500 927 62% ------------------------------------------------- SUBTOTAL PARKING 56,848 154,061 97,213 63% ------------------------------------------------- SUBTOTAL POLICE DEPT. 2,229,686 5,124,531 2,894,845 56% THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 8 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES-FIRE SUPPRESSION 674,549 1,707,020 1,032,471 60% 1000-416-420400-114 COMPTIME BUYOUT 4,510 5,500 990 18% 1000-416-420400-115 OUT OF RANK PAY 6,175 12,500 6,325 51% 1000-416-420400-121 OVERTIME 55,213 40,000 15,213- -38% 1000-416-420400-153 HEALTH INSURANCE 140,525 314,044 173,519 55% 1000-416-420400-155 RETIREMENT 91,447 229,190 137,743 60% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 105 2,000 1,895 95% 1000-416-420400-218 Equipment (Non Capital) 16,163 21,500 5,337 25% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 2,489 15,000 12,511 83% 1000-416-420400-224 JANITORIAL SUPPLIES 912 5,000 4,088 82% 1000-416-420400-231 GAS 4,826 17,325 12,499 72% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 7,924 15,750 7,826 50% 1000-416-420400-320 PRINTING 0 200 200 100% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 385 1,000 615 62% 1000-416-420400-345 TELEPHONE & COMMUNICATION 3,325 6,000 2,675 45% 1000-416-420400-354 CONTRACT SERVICES 11,635 13,800 2,165 16% 1000-416-420400-362 EQUIPMENT MAINTENANCE 4,510 5,500 990 18% 1000-416-420400-366 BUILDING MAINTENANCE-STATION 62 1,638 6,500 4,862 75% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 5,119 5,000 119- -2% 1000-416-420400-373 DUES & TRAINING 8,099 10,000 1,901 19% 1000-416-420400-388 FIREFIGHTER PHYSICALS 1,559 26,675 25,116 94% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 20,013 40,027 20,014 50% 1000-416-420400-610 DEBT RETIREMENT-FIRE TRUCK 12,059 47,707 35,648 75% 1000-416-420400-620 INTEREST EXPENSE-FIRE TRUCK 3,408 15,750 12,342 78% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 250,000 500,000 250,000 50% 1000-416-420400-821 TRANSFER TO FUND 2956 GRANT MATCH 0 22,454 22,454 100% 1000-416-420440-110 SALARIES-FIRE PREVENTION 9,544 20,955 11,411 54% 1000-416-420440-153 HEALTH INSURANCE 2,153 5,232 3,079 59% 1000-416-420440-155 RETIREMENT 726 1,558 832 53% ------------------------------------------------- SUBTOTAL FIRE DEPT. 1,339,009 3,113,187 1,774,178 57% ------------------------------------------------- GRAND TOTAL GENERAL FUND 5,291,204 11,851,324 6,560,121 55% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 9 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SPECIAL REVENUE FUNDS: 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 464,780 1,025,000 560,220 55% 2215-000-311200-000 PERSONAL PROPERTY TAXES 24,886 40,000 15,114 38% 2215-000-312000-000 PEN & INTEREST DEL TAXES 831 2,000 1,169 58% 2215-000-335230-000 ENTITLEMENT SHARE PMT/HB 124 8,500 0 8,500- 0% 2215-000-346030-000 SWIMMING POOL FEES 98,040 127,000 28,960 23% 2215-000-346040-000 CONCESSION STAND REVENUE 33,085 34,000 915 3% 2215-000-346050-000 PARKS USAGE FEES 7,709 21,500 13,791 64% 2215-000-346051-000 RECREATION FEES 6,790 17,216 10,426 61% 2215-000-346052-000 SPORTS PROGRAMS 17,954 52,022 34,068 65% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 342 3,000 2,658 89% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 26,384 70,000 43,616 62% 2215-000-346055-000 ICE RINK 249 22,500 22,251 99% 2215-000-346056-000 KIDSPORT USAGE 3,263 2,500 763- -31% 2215-000-346057-000 YOUTH CAMPS 8,188 147,302 139,114 94% 2215-000-346059-000 PICNIC IN THE PARK 5,146 27,000 21,854 81% 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 1,548 0 1,548- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-371010-000 INVESTMENTS 3,841 4,000 159 4% 2215-000-381050-000 INCEPTION OF LEASE 0 100,000 100,000 100% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 45,500 91,000 45,500 50% ------------------------------------------------- TOTAL PARKS & REC REVENUE 757,037 1,806,040 1,049,003 58% ================================================= PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES-PARKS 153,510 324,341 170,831 53% 2215-436-460430-111 SEASONAL SALARIES 40,639 73,950 33,311 45% 2215-436-460430-121 OVERTIME 49 300 251 84% 2215-436-460430-153 HEALTH INSURANCE 24,317 67,983 43,666 64% 2215-436-460430-155 RETIREMENT 13,602 27,932 14,330 51% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 668 1,800 1,132 63% 2215-436-460430-215 EQUIPMENT - not capital 3,512 7,000 3,488 50% 2215-436-460430-224 JANITORIAL SUPPLIES 2,568 6,000 3,432 57% 2215-436-460430-229 OTHER SUPPLIES 2,311 10,000 7,689 77% 2215-436-460430-231 GAS 8,605 15,500 6,895 44% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 1,824 3,500 1,676 48% 2215-436-460430-320 PRINTING & ADVERTISING 166 400 234 58% 2215-436-460430-341 ELECTRICITY 6,008 14,000 7,992 57% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 4,968 20,000 15,032 75% 2215-436-460430-344 NATURAL GAS 653 2,500 1,847 74% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 986 3,600 2,614 73% 2215-436-460430-351 SPORTS COURT & BAND SHELL REHAB 0 9,000 9,000 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 2,000 2,000 100% 2215-436-460430-355 CONTRACT SERV. TRAIL MAINT/BRUSH HO 6,882 30,000 23,118 77% 2215-436-460430-356 TRAIL STUDY 0 30,000 30,000 100% 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 695 2,680 1,985 74% 2215-436-460430-358 FVCC TENNIS INTERLOCAL AGREEMENT 0 7,000 7,000 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 12,769 40,000 27,231 68% THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 10 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-364 LANDSCAPING 449 6,000 5,551 93% 2215-436-460430-367 VANDALISM REPAIRS 1,509 4,000 2,491 62% 2215-436-460430-373 DUES & TRAINING 6,884 8,000 1,116 14% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 53 400 348 87% 2215-436-460430-395 EQUIPMENT RENTAL 0 1,400 1,400 100% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 1,501 5,000 3,499 70% 2215-436-460430-440 IRRIGATION SUPPLIES 3,469 9,500 6,031 63% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 701 1,500 799 53% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 22,433 44,867 22,434 50% 2215-436-460430-545 COUNTY LANDFILL 0 5,773 5,773 100% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 16,361 48,649 32,288 66% 2215-436-460430-620 DEBT SERVICE INTEREST 2,238 7,001 4,763 68% 2215-436-460430-932 PARK IMPROV - WOODLAND PLAYGROUND 53,609 100,000 46,391 46% 2215-436-460430-941 SPRAY UNIT AND NEW USED TRUCK (FY 1 39,912 40,000 88 0% ------------------------------------------------- SUBTOTAL PARKS EXPENDITURES 433,851 981,576 547,725 56% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES-COMPLEX 47,441 106,149 58,708 55% 2215-436-460440-111 SEASONAL SALARIES 21,007 41,904 20,897 50% 2215-436-460440-121 OVERTIME 0 300 300 100% 2215-436-460440-153 HEALTH INSURANCE 10,563 31,767 21,204 67% 2215-436-460440-155 RETIREMENT 4,823 9,714 4,891 50% 2215-436-460440-221 SAFETY EQUIPMENT 83 350 267 76% 2215-436-460440-229 OTHER SUPPLIES 3,842 20,500 16,658 81% 2215-436-460440-231 GAS 4,733 8,500 3,767 44% 2215-436-460440-241 CONSUMABLE TOOLS 958 4,200 3,242 77% 2215-436-460440-341 ELECTRICITY 4,792 9,500 4,708 50% 2215-436-460440-345 TELEPHONE & COMMUNICATION 144 240 96 40% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 2215-436-460440-355 CONTRACT SERVICES - ASPHAT RESURFC 15,584 15,000 584- -4% 2215-436-460440-362 EQUIPMENT MAINTENANCE 231 800 569 71% 2215-436-460440-364 LANDSCAPING 0 600 600 100% 2215-436-460440-367 VANDALISM REPAIRS 0 500 500 100% 2215-436-460440-373 DUES & TRAINING 471 600 129 22% 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 105 200 95 48% 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 100% 2215-436-460440-420 METAL PRODUCTS 0 1,500 1,500 100% 2215-436-460440-440 IRRIGATION 2,013 6,000 3,987 66% 2215-436-460440-452 SAND & GRAVEL 424 1,200 777 65% 2215-436-460440-521 CENTRAL GARAGE TRANSFER 781 1,562 781 50% 2215-436-460440-545 COUNTY LANDFILL 0 3,400 3,400 100% 2215-436-460440-940 EQUIPMENT - MOWER & SLIT SEEDER 13,155 107,000 93,845 88% ------------------------------------------------- SUBTOTAL ATHLETIC COMPLEX 131,148 372,636 241,488 65% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES-RECREATION 32,143 81,541 49,398 61% 2215-436-460431-111 SEASONAL SALARIES 4,014 9,133 5,119 56% 2215-436-460431-153 HEALTH INSURANCE 5,149 21,601 16,452 76% 2215-436-460431-155 RETIREMENT 2,530 7,005 4,475 64% 2215-436-460431-229 MISC. SUPPLIES 3,074 11,110 8,036 72% 2215-436-460431-231 GAS 179 780 601 77% 2215-436-460431-320 PRINTING & ADVERTISING 0 12,265 12,265 100% THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 11 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460431-345 TELEPHONE & COMMUNICATION 267 668 401 60% 2215-436-460431-353 ON LINE REGISTRATION / CREDIT CARD 0 5,458 5,458 100% 2215-436-460431-354 CONTRACT SERVICES 18,626 22,205 3,579 16% 2215-436-460431-357 MUSIC FRANCHISE FEES 354 1,150 796 69% 2215-436-460431-373 DUES & TRAINING 1,008 1,214 206 17% ------------------------------------------------- SUBTOTAL RECREATION 67,345 174,130 106,785 61% YOUTH CAMPS 2215-436-460448-110 SALARIES-YOUTH CAMPS 27,654 72,174 44,520 62% 2215-436-460448-111 SEASONAL SALARIES 65,273 142,248 76,975 54% 2215-436-460448-121 OVERTIME 194 150 44- -30% 2215-436-460448-153 HEALTH INSURANCE 4,808 20,771 15,963 77% 2215-436-460448-155 RETIREMENT 2,175 6,584 4,409 67% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 0 450 450 100% 2215-436-460448-229 MISC. SUPPLIES 1,456 4,520 3,064 68% 2215-436-460448-231 GAS 0 355 355 100% 2215-436-460448-320 PRINTING & ADVERTISING 82 345 263 76% 2215-436-460448-345 TELEPHONE & COMMUNICATION 445 1,040 595 57% 2215-436-460448-353 ON LINE REGISTRATION FEES 0 4,000 4,000 100% 2215-436-460448-354 CONTRACT SERVICES 10,255 12,870 2,615 20% 2215-436-460448-355 AFTER SCHOOL PROGRAM 335 1,200 865 72% 2215-436-460448-356 BANK FEES/CC CHARGES 1,030 6,000 4,970 83% 2215-436-460448-373 DUES & TRAINING 508 812 304 37% ------------------------------------------------- SUBTOTAL YOUTH CAMPS 114,216 273,519 159,303 58% POOL 2215-437-460445-111 SEASONAL SALARIES-POOL 119,923 182,210 62,287 34% 2215-437-460445-121 OVERTIME 101 400 299 75% 2215-437-460445-155 RETIREMENT 206 1,500 1,294 86% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 231 500 269 54% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,629 2,500 871 35% 2215-437-460445-226 CHLORINE/CHEMICALS 13,203 27,500 14,297 52% 2215-437-460445-228 CONCESSION STAND SUPPLIES 13,087 21,000 7,913 38% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 75 4,500 4,425 98% 2215-437-460445-341 ELECTRICITY 4,813 9,500 4,687 49% 2215-437-460445-344 NATURAL GAS 15,958 25,000 9,042 36% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,154 1,800 646 36% 2215-437-460445-354 LICENSES & FEES 683 1,300 617 47% 2215-437-460445-356 BANK FEES/ CC CHARGES 1,953 3,000 1,047 35% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 2,228 17,350 15,122 87% 2215-437-460445-380 TRAINING MATERIALS 140 1,800 1,660 92% ------------------------------------------------- SUBTOTAL POOL EXPENDITURES 175,384 299,860 124,476 42% ------------------------------------------------- TOTAL PARKS & RECREATION/POOL 921,943 2,101,721 1,179,778 56% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 12 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING URBAN FORESTRY 2600-436-460433-110 SALARIES-URBAN FORESTRY 73,329 187,275 113,946 61% 2600-436-460433-111 SEASONAL SERVICES 4,562 29,856 25,294 85% 2600-436-460433-121 OVERTIME 0 1,000 1,000 100% 2600-436-460433-153 HEALTH INSURANCE 11,448 56,796 45,348 80% 2600-436-460433-155 RETIREMENT 5,622 16,510 10,888 66% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 156 600 444 74% 2600-436-460433-231 GAS 2,719 6,000 3,281 55% 2600-436-460433-241 CONSUMABLE TOOLS 3,313 5,000 1,687 34% 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 268 660 392 59% 2600-436-460433-354 CONTRACT SERVICES 163,151 296,574 133,423 45% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 1,667 5,000 3,333 67% 2600-436-460433-362 EQUIPMENT MAINTENANCE 1,053 4,000 2,947 74% 2600-436-460433-364 LANDSCAPING & TREES 1,804 8,000 6,196 77% 2600-436-460433-373 DUES & TRAINING 1,584 4,000 2,416 60% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 1,911 1,863 48- -3% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 4,063 8,125 4,062 50% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 5,190 10,380 5,190 50% 2600-436-460433-528 DATA PROCESSING TRANSFER 2,390 4,780 2,390 50% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 8,229 16,530 8,301 50% 2600-436-460433-620 INTEREST EXPENSE 951 1,920 969 50% 2600-436-460433-940 CHIPPER - FY17&18 / USED TRUCK FY19 20,000 20,000 0 0% ------------------------------------------------- TOTAL URBAN FORESTRY 313,411 684,869 371,458 54% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 13 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 308,201 696,766 388,565 56% 2230-000-342070-000 COUNTY EMS LEVY 0 100,000 100,000 100% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 250,000 500,000 250,000 50% ------------------------------------------------- TOTAL AMBULANCE REVENUE 558,201 1,296,766 738,565 57% ================================================= AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 281,860 656,047 374,187 57% 2230-440-420730-114 COMPTIME BUYBACK 1,006 3,500 2,494 71% 2230-440-420730-115 OUT OF RANK PAY 895 2,500 1,605 64% 2230-440-420730-121 OVERTIME 21,779 30,000 8,221 27% 2230-440-420730-153 HEALTH INSURANCE 69,355 155,949 86,594 56% 2230-440-420730-155 RETIREMENT 37,606 87,109 49,503 57% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 260 1,400 1,140 81% 2230-440-420730-218 NON-CAPITAL EQUIPMENT 987 4,200 3,213 77% 2230-440-420730-231 GAS & OIL 2,706 7,560 4,854 64% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 3,997 4,000 3 0% 2230-440-420730-312 POSTAGE/PRINTING 0 1,500 1,500 100% 2230-440-420730-345 TELEPHONE & COMMUNICATION 752 1,700 948 56% 2230-440-420730-354 CONTRACT SERVICES 4,293 19,990 15,697 79% 2230-440-420730-355 911 CENTER CONTRIBUTION 17,510 35,020 17,510 50% 2230-440-420730-359 AUDIT/CC OTHER FEES 1,114 1,650 536 32% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 770 5,000 4,230 85% 2230-440-420730-373 DUES & TRAINING 3,775 5,000 1,225 25% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 73 2,500 2,427 97% 2230-440-420730-391 MEDICAL TREATMENT-SUPPLIES 19,616 49,749 30,133 61% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 35,351 34,487 864- -3% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 9,047 18,093 9,046 50% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 27,931 55,862 27,931 50% 2230-440-420730-528 DATA PROCESSING TRANSFER 9,559 19,118 9,559 50% 2230-440-420730-940 EQUIPMENT 60,000 60,000 0 0% ------------------------------------------------- TOTAL AMBULANCE EXPENDITURES 610,241 1,261,934 651,693 52% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 14 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2399 PUBLIC SAFETY IMPACT FEES 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 5,000 10,000 5,000 50% 2399-413-420140-940 POLICE EQUIPMENT 0 100,000 100,000 100% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 750,000 750,000 100% ------------------------------------------------- TOTAL PUBLIC SAFETY IMPACT FEE 5,000 860,000 855,000 99% ================================================= FIRE & HAZMAT GRANTS 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 6,000 5,000 1,000- -20% 2956-416-420415-940 AFG GRT FY19 SCBA 0 224,546 224,546 100% ------------------------------------------------- TOTAL FIRE GRANTS 6,000 229,546 223,546 97% ================================================= 2957-416-420410-125 PASS THRU HAZMAT OT 1,030 8,000 6,970 87% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 1,690 12,000 10,310 86% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 264 5,000 4,736 95% ------------------------------------------------- TOTAL HAZMAT GRANTS 2,984 25,000 22,016 88% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 15 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 251,355 600,000 348,645 58% 2394-000-323103-000 PLUMBING PERMITS 21,404 21,000 404- -2% 2394-000-323104-000 MECHANICAL PERMITS 28,206 30,000 1,794 6% 2394-000-323105-000 ELECTRICAL PERMITS 38,621 60,000 21,379 36% 2394-000-323108-000 PLAN REVIEW FEES 81,321 250,000 168,679 67% 2394-000-371010-000 INVESTMENT EARNINGS 13,687 5,000 8,687- -174% ------------------------------------------------- TOTAL REVENUE 434,593 966,000 531,407 55% ================================================= BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES-BUILDING DEPT. 239,578 502,504 262,926 52% 2394-420-420530-112 SALARIES-SEVERANCE 0 21,472 21,472 100% 2394-420-420530-121 OVERTIME 2,269 20,000 17,731 89% 2394-420-420530-153 HEALTH INSURANCE 40,863 95,112 54,249 57% 2394-420-420530-155 RETIREMENT 18,263 37,666 19,403 52% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 3,476 36,000 32,524 90% 2394-420-420530-231 GAS & OIL 1,636 4,500 2,864 64% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 337 7,300 6,963 95% 2394-420-420530-323 ST. ED. ASSESSMENTS 0 7,500 7,500 100% 2394-420-420530-345 TELEPHONE & COMMUNICATION 3,878 4,500 622 14% 2394-420-420530-353 AUDITING 2,500 4,500 2,000 44% 2394-420-420530-354 CONTRACT SERVICES 10,215 20,000 9,785 49% 2394-420-420530-355 CITY WORKS LICENSING FEE 18,199 25,000 6,801 27% 2394-420-420530-356 ArcGIS SERVER UPGRADE LICENSE 2,500 3,000 500 17% 2394-420-420530-357 CREDIT CARD / PAYPAL FEES 0 20,250 20,250 100% 2394-420-420530-360 FURNITURE 0 9,000 9,000 100% 2394-420-420530-373 DUES & TRAINING 18,487 30,000 11,513 38% 2394-420-420530-510 PROPERTY INSURANCE 5,015 7,200 2,185 30% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 963 1,926 963 50% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 14,978 29,956 14,978 50% 2394-420-420530-528 DATA PROCESSING TRANSFER 16,729 33,457 16,728 50% 2394-420-420530-920 FY19 BUILDING IMPROVEMENT PROJECTS 0 35,000 35,000 100% 2394-420-420530-944 VEHICLES - FY19 CARRYOVER 56,341 0 56,341- 0% ------------------------------------------------- TOTAL BUILDING DEPT. 456,226 955,843 499,617 52% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 16 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 36,596 73,846 37,250 50% 2400-410-430263-153 HEALTH INSURANCE 4,742 21,714 16,972 78% 2400-410-430263-155 RETIREMENT 2,772 5,521 2,749 50% 2400-410-430263-244 STREET LIGHT SUPPLIES 2,758 18,000 15,242 85% 2400-410-430263-245 LUMINAIRES 1,737 30,000 28,263 94% 2400-410-430263-246 LED LUMINAIRE UPGRADE 2,400 38,835 36,435 94% 2400-410-430263-341 ELECTRICITY 64,686 182,000 117,314 64% 2400-410-430263-360 REPAIR & MAINT SERVICES 3,430 20,000 16,570 83% 2400-410-430263-510 INSURANCE 777 800 23 3% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 6,471 12,942 6,471 50% ------------------------------------------------- TOTAL LIGHT MAINT. 126,369 403,658 277,289 69% ================================================= 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 33,882 101,365 67,483 67% 2420-421-430234-957 ALLEY PAVING 12,820 40,000 27,180 68% 2420-421-430240-231 GAS & OIL 13,469 40,000 26,531 66% 2420-421-430240-344 NATURAL GAS 1,501 5,800 4,299 74% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 100% 2420-421-430240-360 REPAIR & MAINT SERVICES 300 1,500 1,200 80% 2420-421-430240-368 OVERLAY/CHIPSEALS 131,422 300,000 168,578 56% 2420-421-430240-452 GRAVEL 0 5,000 5,000 100% 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 18,627 45,000 26,373 59% 2420-421-430240-472 ASPHALT 15,545 50,000 34,455 69% 2420-421-430240-473 CRACK SEALING 0 14,500 14,500 100% 2420-421-430240-474 PAINT STRIPING MATERIALS 5,444 30,000 24,556 82% ------------------------------------------------- TOTAL GAS TAX 233,010 658,165 425,155 65% ================================================= BARSAA (GAS TAX) 2421-421-430240-354 PAVEMENT MAINTENANCE 74,438 515,438 441,000 86% ------------------------------------------------- TOTAL BARSAA 74,438 515,438 441,000 86% ================================================= 2825 MACI GRANT 2825-421-430240-940 SWEEPER 32,028 419,406 387,378 92% ------------------------------------------------- TOTAL MACI GRANT 106,466 934,844 828,378 89% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 17 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500 STREET MAINT. & SIGNS STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 349,475 776,609 427,134 55% 2500-421-430240-121 OVERTIME 318 28,000 27,682 99% 2500-421-430240-153 HEALTH INSURANCE 62,851 170,710 107,859 63% 2500-421-430240-155 RETIREMENT 26,328 57,693 31,365 54% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 4,514 16,360 11,846 72% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 951 7,000 6,049 86% 2500-421-430240-220 OTHER SUPPLIES 899 4,500 3,601 80% 2500-421-430240-231 GAS & OIL 13,968 40,000 26,032 65% 2500-421-430240-341 ELECTRICITY 875 3,500 2,625 75% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 1,020 1,500 480 32% 2500-421-430240-354 CONTRACT SERVICES 3,077 30,000 26,923 90% 2500-421-430240-356 TRANSPORTATION PLAN 1,160 137,150 135,990 99% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 23,191 33,500 10,309 31% 2500-421-430240-366 BUILDING MAINTENANCE 1,396 5,000 3,604 72% 2500-421-430240-373 DUES & TRAINING 1,709 5,500 3,791 69% 2500-421-430240-388 MEDICAL SERVICES 245 1,000 755 76% 2500-421-430240-510 LIABILITY INSURANCE 17,413 18,500 1,087 6% 2500-421-430240-512 UNINSURED LOSS-DEDUCTIBLE 1,463 10,000 8,537 85% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 100,026 200,052 100,026 50% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 49,483 98,967 49,484 50% 2500-421-430240-528 DATA PROCESSING TRANSFER 7,169 14,339 7,170 50% 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 17,838 35,621 17,783 50% 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 555 1,119 564 50% 2500-421-430240-840 MACI GRANT MATCH WTR/DE-ICER TRK FY 0 10,000 10,000 100% 2500-421-430240-922 SHOP ROOF AND INSULATION REPLACEMEN 0 45,000 45,000 100% 2500-421-430240-953 SHOP COMPLEX PAVEMENT RESTORATION 0 38,200 38,200 100% 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 12,016 24,262 12,246 50% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 7,397 14,644 7,247 49% 2500-421-430244-354 PAVEMENT REPAIRS-PAVEMENT MNT FUNDS 108,790 632,021 523,231 83% 2500-421-430244-820 TRANSFER TO BARSAA 0 21,000 21,000 100% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 154,783 195,000 40,217 21% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 100% ------------------------------------------------- TOTAL STREET MAINT. 968,909 2,704,575 1,735,666 64% ------------------------------------------------- SIGNS AND SIGNALS 2500-421-430264-110 TSS - SALARIES 48,471 124,519 76,048 61% 2500-421-430264-121 OVERTIME 0 7,500 7,500 100% 2500-421-430264-153 HEALTH INSURANCE 10,620 26,794 16,174 60% 2500-421-430264-155 RETIREMENT 3,627 9,177 5,550 60% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 1,069 2,500 1,431 57% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,009 6,700 5,691 85% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 1,043 3,500 2,457 70% 2500-421-430264-242 STREET SIGNS 9,915 30,000 20,085 67% 2500-421-430264-243 TRAFFIC SIGNALS 4,592 20,000 15,408 77% 2500-421-430264-245 BARRICADE MATERIALS 1,276 5,500 4,224 77% 2500-421-430264-341 ELECTRICITY 654 3,000 2,346 78% 2500-421-430264-345 COMMUNICATIONS 312 850 538 63% 2500-421-430264-354 CONTRACT SERVICES 900 10,000 9,100 91% 2500-421-430264-362 EQUIPMENT MAINTENANCE 586 3,000 2,414 80% 2500-421-430264-366 BUILDING MAINTENANCE 418 3,000 2,582 86% THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 18 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500-421-430264-373 DUES & TRAINING 3,444 6,000 2,556 43% 2500-421-430264-428 PAINT MATERIALS 383 5,000 4,617 92% 2500-421-430264-510 LIABILITY INS.-TSS 1,648 1,900 252 13% 2500-421-430264-512 UNINSURED LOSS-DEDUCTIBLE 263 2,500 2,238 90% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 3,718 7,435 3,717 50% 2500-421-430264-532 OFFICE RENT 6,421 6,422 1 0% 2500-421-430264-940 MACHINERY & EQUIPMENT 27,661 51,000 23,339 46% ------------------------------------------------- TOTAL SIGNS AND SIGNALS 128,030 336,297 208,267 62% ------------------------------------------------- TOTAL STREET MAINT. & SIGNS 1,096,939 3,040,872 1,943,933 64% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 19 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2188 WESTSIDE TIF REVENUE 2188-000-311100-000 REAL PROPERTY TAXES 28,963 60,000 31,037 52% 2188-000-311200-000 PERSONAL PROPERTY TAXES 5,512 7,500 1,988 27% 2188-000-312000-000 PEN & INTEREST DEL. TAXES 203 350 147 42% 2188-000-335230-000 ENTITLEMENT SHARE PMT/SB96, 372 121,564 243,128 121,564 50% 2188-000-341015-000 DEVELOPER PMT-DEPOT PLACE APTS 7,940 8,000 60 1% 2188-000-371010-000 INVESTMENT EARNINGS 23,126 20,000 3,126- -16% ------------------------------------------------- TOTAL REVENUE 187,308 338,978 151,670 45% ================================================= EXPENDITURES 2188-480-470230-110 SALARIES 21,517 44,335 22,818 51% 2188-480-470230-153 HEALTH INSURANCE 3,498 8,701 5,203 60% 2188-480-470230-155 RETIREMENT 1,709 3,508 1,799 51% 2188-480-470230-353 AUDIT 3,000 3,000 0 0% 2188-480-470230-356 TELEPHONE 96 192 96 50% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 2,000 4,000 2,000 50% 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 521,198 1,500,000 978,802 65% 2188-480-470230-840 TRANSFER TO DEBT SERVICE 3188 180,000 360,000 180,000 50% ------------------------------------------------- TOTAL WESTSIDE TIF 733,018 1,923,736 1,190,718 62% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 20 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 1,600 1,600 0 0% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 4,752 9,503 4,751 50% 2185-000-430300-840 REDEVELOPMENT ACTIVITY 34,763 2,500,000 2,465,237 99% 2185-480-470240-110 SALARIES 10,041 20,501 10,460 51% 2185-480-470240-153 HEALTH INSURANCE 1,884 5,018 3,134 62% 2185-480-470240-155 RETIREMENT 798 1,630 832 51% 2185-480-470240-345 TELEPHONE & COMMUNICATION 24 48 24 50% ------------------------------------------------- TOTAL 2185 AIRPORT TIF 53,861 2,538,300 2,484,439 98% ================================================= OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 11,000 11,000 100% 2310-480-470210-356 FED-EX REIMBURSEMENT 9,572 10,500 928 9% 2310-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 27,500 55,000 27,500 50% 2311-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 5,000 10,000 5,000 50% ------------------------------------------------- TOTAL OLD SCHOOL TIFS 42,072 86,500 44,428 51% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 21 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 1,000 1,000 0 0% 2880-480-470210-354 CONTRACT SERVICES 22 1,000 978 98% 2880-480-470210-711 REDEVELOPMENT 0 175,000 175,000 100% ------------------------------------------------- TOTAL LOAN REVOLVING 1,022 177,000 175,978 99% ================================================= 2881 CD LOAN REV. #2 2881-480-470210-711 REDEVELOPMENT 0 240,000 240,000 100% ------------------------------------------------- TOTAL 2881 CD REV. #2 0 240,000 240,000 100% ================================================= 2886 CD MISC. 2886-480-470210-210 OFFICE SUPPLIES 0 2,000 2,000 100% 2886-480-470210-353 AUDITING 1,000 1,000 0 0% 2886-480-470210-373 DUES & TRAINING 0 2,000 2,000 100% 2886-480-470210-379 MEETINGS 0 1,000 1,000 100% 2886-480-470210-396 STUDIES/SURVEYS & MARKETING 0 5,000 5,000 100% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 1,000 2,000 1,000 50% 2886-480-470210-528 DATA PROCESSING TRANSFER 4,780 9,559 4,779 50% 2886-480-470210-532 OFFICE RENT 647 1,175 528 45% 2886-480-470210-620 INTEREST - OLD SCHOOL LOAN - GENERA 0 48,750 48,750 100% 2886-480-470210-790 REDEVELOPMENT ACTIVITY 0 3,750 3,750 100% 2886-480-470210-795 REDEVELOPMENT- OLD SCHOOL STATION 0 165,000 165,000 100% ------------------------------------------------- TOTAL CD MISC. 7,427 241,234 233,807 97% ================================================= 2887 RURAL DEVELOPMENT #1 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 22,074 18,639 3,435- -18% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 0 3,435 3,435 100% 2887-480-470210-750 REDEVELOPMENT LOANS 0 300,000 300,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #1 22,074 322,074 300,000 93% ================================================= 2888 RURAL DEVELOPMENT #2 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 10,025 8,301 1,724- -21% 2888-480-470210-620 INTEREST EXPENSE-USDA LOAN 61-03 0 1,724 1,724 100% 2888-480-470210-750 REDEVELOPMENT LOANS 0 250,000 250,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #2 10,025 260,025 250,000 96% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 22 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2953 EPA BROWNFIELDS 2953-480-470210-354 CONT SERV/PETROLEUM 0 185,592 185,592 100% 2953-480-470210-373 TRAVEL/PETROLEUM 0 2,392 2,392 100% 2953-480-470215-354 CONT SERV/HAZARDOUS 41,453 178,344 136,891 77% 2953-480-470215-373 TRAVEL/HAZARDOUS 0 2,552 2,552 100% ------------------------------------------------- TOTAL EPA BROWNSFIELD 41,453 368,880 327,427 89% ================================================= 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,488 1,488 100% 2955-480-470210-720 CLEANUP LOANS-PETROLEUM 0 62,354 62,354 100% 2955-480-470210-721 CLEANUP SUBGRANTS-PETRO 0 100,000 100,000 100% 2955-480-470210-725 REVOLVED FUNDS-PETROLEUM 0 100,500 100,500 100% 2955-480-470215-229 SUPPLIES-HAZARDOUS SUBSTANCES 0 1,158 1,158 100% 2955-480-470215-354 CONTRACT SERV-HAZARDOUS SUBST 0 88 88 100% 2955-480-470215-373 TRAVEL-HAZARDOUS SUBTSANCE 0 2,330 2,330 100% 2955-480-470215-720 CLEANUP LOANS-HAZARDOUS 0 314,600 314,600 100% ------------------------------------------------- TOTAL BROWNFIELDS LOAN REV. 0 587,424 587,424 100% ================================================= 2991 TIGER GRANT 2991-480-470245-790 REDEVELOPMENT - TRAIL 0 3,803,909 3,803,909 100% ------------------------------------------------- TOTAL TIGER GRANT 0 3,803,909 3,803,909 100% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 23 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD 0 20,000 20,000 100% 2915-413-420140-218 SMALL EQUIP -Stonegarden 0 40,000 40,000 100% 2915-413-420140-354 CONT SERV-WPD/MFWPE - STONEGARDEN 3,167 60,000 56,833 95% ------------------------------------------------- TOTAL 2915 STONEGARDEN GRANT 3,167 120,000 116,833 97% ================================================= 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 29,361 64,857 35,496 55% 2916-413-420140-121 OVERTIME 5,217 7,500 2,283 30% 2916-413-420140-153 HEALTH INSURANCE 3,415 8,453 5,038 60% 2916-413-420140-155 RETIREMENT 3,847 8,710 4,863 56% 2916-413-420140-354 CONTRACT SERVICES 2,859 6,000 3,141 52% ------------------------------------------------- TOTAL 2916 DRUG ENFORCEMENT 44,699 95,520 50,821 53% ================================================= 2918 CHRP GRANT 2918-413-420140-110 SALARIES & PAYROLL COSTS 28,936 60,500 31,564 52% 2918-413-420140-153 HEALTH INSURANCE 5,382 8,968 3,586 40% 2918-413-420140-155 RETIREMENT 3,853 7,901 4,048 51% ------------------------------------------------- TOTAL CHRP GRANT 38,170 77,369 39,199 51% ================================================= 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 912 4,000 3,088 77% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 8,737 36,000 27,263 76% 2919-413-420140-127 SCHOOL DIST. OT 5,537 20,000 14,463 72% 2919-413-420140-218 JAG GRT/RADIOS & TRAINING 0 12,000 12,000 100% 2919-413-420140-220 EQUIPMENT-FUNDED BY DONATIONS 520 4,000 3,481 87% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 2,835 7,000 4,165 60% ------------------------------------------------- TOTAL LAW ENF. GRANT 18,541 83,000 64,459 78% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 24 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CAPITAL PROJECT FUNDS 4188 TIGER RAIL/TRAIL CONSTRUC 4188-480-470440-930 GLACIER RAIL PEDESTRIAN TRAIL CONST 59,944 0 59,944- 0% 4188-480-470440-935 GLACIER RAIL PARK CONSTRUCTION 3,357,222 3,352,632 4,590- -0% ------------------------------------------------- TOTAL 4188 TIGER RAIL/TRAIL CO 3,417,166 3,352,632 64,534- -2% ================================================= 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION 6,804 25,000 18,196 73% ------------------------------------------------- TOTAL 4290 WALK & CURB 6,804 25,000 18,196 73% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 25 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 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 180 0 180- 0% 5210-000-343210-000 METERED WATER SALES 1,969,086 2,900,000 930,914 32% 5210-000-343220-000 UNMETERED WATER SALES 26,104 10,000 16,104- -161% 5210-000-343225-000 IMPACT FEES 401,724 500,000 98,276 20% 5210-000-343230-000 METER REPLACEMENT FEE 53,093 98,000 44,907 46% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 30,597 50,000 19,403 39% 5210-000-343270-000 WATER TURN ON FEES 3,375 5,000 1,625 33% 5210-000-343275-000 TAG FEE 26,040 55,000 28,960 53% 5210-000-343365-000 LATECOMER ADMIN FEE 1,189 0 1,189- 0% 5210-000-371010-000 INVESTMENT EARNINGS 81,088 100,000 18,912 19% 5210-000-381050-000 INCEPTION OF LEASE (FOR BUDGET ONLY 0 3,675,000 3,675,000 100% ------------------------------------------------- TOTAL WATER REVENUE 2,592,475 7,393,000 4,800,525 65% ================================================= WATER FACILITIES 5210-447-430550-110 SALARIES-WATER 318,718 739,728 421,010 57% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 4,650 20,000 15,350 77% 5210-447-430550-153 HEALTH INSURANCE 56,764 165,884 109,120 66% 5210-447-430550-155 RETIREMENT 24,400 55,082 30,682 56% 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 6,120 22,000 15,880 72% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 1,135 8,500 7,365 87% 5210-447-430550-226 CHLORINE & CHEMICALS 18,290 39,000 20,710 53% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 1,166 4,500 3,334 74% 5210-447-430550-231 GAS & OIL 11,235 35,000 23,765 68% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 271 1,000 729 73% 5210-447-430550-336 LICENSES & FEES 0 18,500 18,500 100% 5210-447-430550-341 ELECTRICITY 78,879 158,000 79,121 50% 5210-447-430550-344 NATURAL GAS 2,287 15,500 13,213 85% 5210-447-430550-345 TELEPHONE & COMMUNICATION 5,770 10,500 4,730 45% 5210-447-430550-349 LAB SERVICES 4,088 20,000 15,912 80% 5210-447-430550-353 AUDITING 5,000 5,000 0 0% 5210-447-430550-354 CONTRACT SERVICES 12,598 55,000 42,402 77% 5210-447-430550-356 CONSULTANTS FACILITY PLAN 1,392 105,000 103,608 99% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 307 15,000 14,693 98% 5210-447-430550-366 BUILDING MAINTENANCE 1,288 12,000 10,712 89% 5210-447-430550-373 DUES & TRAINING 1,921 9,000 7,079 79% 5210-447-430550-388 MEDICAL SERVICES 158 600 443 74% 5210-447-430550-410 CONSTRUCTION MATERIALS 14,692 35,000 20,308 58% 5210-447-430550-422 HYDRANTS 3,778 10,000 6,222 62% 5210-447-430550-423 MATERIALS FOR MAINS 778 14,000 13,222 94% 5210-447-430550-424 MATERIALS -SERVICE LINES 4,422 12,000 7,578 63% 5210-447-430550-425 MATERIALS PUMPS/WELLS 8,208 45,000 36,792 82% 5210-447-430550-510 PROPERTY & LIABILITY INS. 20,622 21,500 878 4% 5210-447-430550-512 UNINSURED LOSS-DEDUCTIBLE 0 10,000 10,000 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 10,989 21,977 10,988 50% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 54,994 109,988 54,994 50% 5210-447-430550-528 DATA PROCESSING TRANSFER 16,729 33,457 16,728 50% 5210-447-430550-532 LEASE PAYMENTS 6,421 10,500 4,079 39% 5210-447-430550-935 NOFFSINGER TRANSMISSION CONDITION A 0 250,000 250,000 100% 5210-447-430550-939 FOUR MILE TRANSMISSION MAIN (PHASE 0 3,500,000 3,500,000 100% THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 26 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-940 MACHINERY & EQUIPMENT 13,950 20,000 6,050 30% 5210-447-430550-948 METERS (METER FUNDS) 010125 26,650 110,000 83,350 76% 5210-447-430550-950 1ST AVE WN 0 620,000 620,000 100% 5210-447-430550-951 SECURITY SCADA UPGRADES 0 50,000 50,000 100% 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 0 38,200 38,200 100% 5210-447-430550-959 PARKS METERING PHASE II 8,150 22,337 14,187 64% 5210-447-430550-962 9TH AVE WEST WATER MAIN REPLACEMENT 73,503 467,483 393,980 84% 5210-447-430550-963 8TH STREET WEST WATER MAIN REPLACEM 494,288 413,319 80,969- -20% 5210-447-430550-968 CONRAD DRIVE 0 360,000 360,000 100% 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 320,254 320,254 100% 5210-447-430555-939 FOUR MILE TRANSMISSION MAIN (PHASE 24,378 262,000 237,622 91% 5210-447-430555-941 METERS (NEW SERVICES)010120 21,198 45,600 24,403 54% 5210-447-430555-953 SECTION 36 WELL 743,540 1,402,231 658,691 47% ------------------------------------------------- SUBTOTAL WATER FACILITIES 2,103,724 9,724,640 7,620,916 78% ------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES-WATER BILLING 49,845 113,806 63,961 56% 5210-447-430560-153 HEALTH INSURANCE 11,047 28,181 17,134 61% 5210-447-430560-155 RETIREMENT 3,905 8,813 4,908 56% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 2,099 3,500 1,401 40% 5210-447-430560-353 AUDITING 0 2,000 2,000 100% 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 20,467 40,000 19,533 49% 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 11,575 25,000 13,425 54% 5210-447-430560-356 OTHER CONTRACT SERVICES 55 2,500 2,445 98% 5210-447-430560-373 DUES & TRAINING 609 2,500 1,891 76% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 5,645 11,289 5,644 50% 5210-447-430560-528 DATA PROCESSING TRANSFER 16,729 33,457 16,728 50% 5210-447-430560-532 RENT 6,421 6,422 1 0% ------------------------------------------------- SUBTOTAL WATER BILLING 128,397 277,468 149,071 54% ------------------------------------------------- REVENUE BONDS 5210-447-490204-610 BOND PRIN-HWY 93 S WTR-2004 0 70,000 70,000 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 22,793 22,793 1 0% 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 350 350 0 0% 5210-447-490206-610 PRIN-WELL/TANK/8114 2.25% 4TH ST 0 87,000 87,000 100% 5210-447-490206-620 INT-WELL&TANK/8114 2.25% 4TH ST WT 18,799 18,799 0 0% 5210-447-490210-610 4TH AVE E MAIN REPL/WRF 17393 0 77,901 77,901 100% 5210-447-490210-620 4TH AVE E MAIN REPL/WFR 17393 47,019 47,019 0 0% 5210-447-490250-610 PRIN-WTR MAIN/WRF1032R 2%/IDAHO&MAI 0 50,000 50,000 100% 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2%/IDAHO&MAIN 2,270 2,270 0 0% ------------------------------------------------- SUBTOTAL REVENUE BONDS 91,230 376,132 284,902 76% ------------------------------------------------- DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 840,000 840,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 840,000 840,000 100% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 27 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING TOTAL WATER FUND 2,323,351 11,218,240 8,894,889 79% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 28 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 180 0 180- 0% 5310-000-343310-000 SEWER SERVICE CHARGES 2,339,398 4,500,000 2,160,602 48% 5310-000-343330-000 IMPACT FEES (SANITARY) 508,933 600,000 91,067 15% 5310-000-343335-000 IMPACT FEES (WWTP) 308,733 350,000 41,267 12% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 1,060 10,000 8,940 89% 5310-000-343365-000 LATECOMER ADMIN FEES 2,872 0 2,872- 0% 5310-000-371010-000 INVESTMENT EARNINGS 74,085 100,000 25,915 26% 5310-000-381050-000 INCEPTION OF LEASE 0 14,003,470 14,003,470 100% ------------------------------------------------- TOTAL SEWER REVENUE 3,235,261 19,563,470 16,328,209 83% ================================================= SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES-SEWER BILLING 44,067 96,132 52,065 54% 5310-454-430620-153 HEALTH INSURANCE 8,886 22,864 13,978 61% 5310-454-430620-155 RETIREMENT 3,448 7,426 3,978 54% 5310-454-430620-215 OFFICE SUPPLIES/COMPUTERS 2,085 3,500 1,415 40% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 0 2,000 2,000 100% 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 20,467 40,000 19,533 49% 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 11,575 25,000 13,425 54% 5310-454-430620-356 OTHER CONTRACT SERVICES 55 2,500 2,445 98% 5310-454-430620-373 DUES & TRAINING 609 2,500 1,891 76% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 5,193 10,385 5,192 50% 5310-454-430620-528 DATA PROCESSING TRANSFER 16,729 33,457 16,728 50% 5310-454-430620-532 OFFICE RENT 6,421 6,422 1 0% ------------------------------------------------- SUBTOTAL SEWER BILLING COSTS 119,534 252,186 132,652 53% ------------------------------------------------- SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES-SANITARY SEWER 118,330 283,430 165,100 58% 5310-454-430630-121 OVERTIME 211 5,500 5,289 96% 5310-454-430630-153 HEALTH INSURANCE 22,631 71,186 48,555 68% 5310-454-430630-155 RETIREMENT 9,016 21,197 12,181 57% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 3,024 12,200 9,176 75% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 2,171 8,350 6,179 74% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 654 2,300 1,646 72% 5310-454-430630-231 GAS & OIL 4,373 12,000 7,627 64% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 275 500 225 45% 5310-454-430630-341 ELECTRICITY 18,387 55,000 36,613 67% 5310-454-430630-344 NATURAL GAS 5,510 16,500 10,990 67% 5310-454-430630-345 TELEPHONE & COMMUNICATION 11,509 25,000 13,491 54% 5310-454-430630-353 AUDITING 3,000 3,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 12,314 24,000 11,686 49% 5310-454-430630-356 CONSULTANTS - FACILITY PLAN 133,405 335,000 201,595 60% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 1,825 7,000 5,175 74% 5310-454-430630-373 DUES & TRAINING 1,253 5,500 4,247 77% 5310-454-430630-388 MEDICAL SERVICES 228 500 273 55% 5310-454-430630-410 CONSTRUCTION MATERIALS 3,669 10,000 6,331 63% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 26,120 50,000 23,880 48% 5310-454-430630-510 PROPERTY & LIABILITY INS. 22,601 18,400 4,201- -23% 5310-454-430630-512 UNINSURED LOSS-DEDUCTIBLE 0 25,000 25,000 100% THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 29 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-521 CENTRAL GARAGE TRANSFER 5,066 10,133 5,067 50% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 29,679 59,359 29,680 50% 5310-454-430630-528 DATA PROCESSING TRANSFER 9,559 19,118 9,559 50% 5310-454-430630-532 OFFICE RENT 6,421 6,422 1 0% 5310-454-430630-940 MACHINERY & EQUIPMENT 0 50,000 50,000 100% 5310-454-430630-948 REPAIR & REPLC OF SEWER MAIN 0 600,000 600,000 100% 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 0 38,200 38,200 100% 5310-454-430630-954 GRANDVIEW L.S. RELOCATOIN & UPSIZE 615 579,536 578,921 100% 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 13,641 20,000 6,359 32% 5310-454-430630-957 WEST SIDE INTERCEPTOR PHASE I 10,492,402 13,490,000 2,997,598 22% 5310-454-430630-959 SEWER LINE A REPLACEMENT PROJ. 229,010 556,395 327,385 59% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 14,990 50,000 35,010 70% 5310-454-430630-962 SEWER MAIN SLIP LINING 173,506 194,348 20,842 11% ------------------------------------------------- SUBTOTAL SEWER COLLECTION 11,375,395 16,665,074 5,289,679 32% ------------------------------------------------- IMPACT FEES 5310-454-430635-954 GRANDVIEW L.S. RELOCATION & UPSIZE 615 579,536 578,921 100% 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 105,680 310,000 204,320 66% 5310-454-430635-957 WEST SIDE INTERCEPTOR 488,969 682,347 193,378 28% ------------------------------------------------- SUBTOTAL IMPACT FEE EXPENSE 595,264 1,571,883 976,619 62% ------------------------------------------------- REVENUE BONDS/SANITARY 5310-454-490200-610 PRINCIPAL-WESTSIDE INTERCEPTOR BOND 0 119,528 119,528 100% 5310-454-490200-620 INTEREST-WESTSIDE INTERCEPTOR BOND 0 200,000 200,000 100% 5310-454-490200-630 FISCAL AGENT FEE-WESTSIDE INTERCEPT 0 350 350 100% 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.25% 0 85,000 85,000 100% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 11,633 11,633 1 0% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25% 0 350 350 100% ------------------------------------------------- SUBTOTAL REVENUE BONDS 11,633 416,861 405,229 97% ------------------------------------------------- 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 11,982,292 19,473,818 7,491,526 38% ------------------------------------------------- WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 196,262 456,093 259,831 57% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-112 SALARIES-RETIREMENT 31,633 42,317 10,684 25% 5310-455-430640-121 OVERTIME 9,817 22,500 12,683 56% 5310-455-430640-153 HEALTH INSURANCE 33,747 89,087 55,340 62% 5310-455-430640-155 RETIREMENT 15,717 33,891 18,174 54% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 3,286 10,000 6,714 67% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 971 2,700 1,729 64% THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 30 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-225 ALUM 6,675 20,000 13,325 67% 5310-455-430640-226 CHLORINE & CHEMICALS 47,238 80,000 32,762 41% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 4,244 7,000 2,756 39% 5310-455-430640-231 GAS & OIL 6,958 16,000 9,042 57% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 11 400 389 97% 5310-455-430640-336 LICENSES & FEES 163 11,500 11,337 99% 5310-455-430640-341 ELECTRICITY 62,145 182,000 119,855 66% 5310-455-430640-342 WATER 2,457 7,500 5,043 67% 5310-455-430640-344 NATURAL GAS 26,015 60,000 33,985 57% 5310-455-430640-345 TELEPHONE & COMMUNICATION 2,908 6,500 3,592 55% 5310-455-430640-353 AUDITING 4,000 4,000 0 0% 5310-455-430640-354 CONTRACT-GLACIER GOLD 59,261 124,000 64,739 52% 5310-455-430640-355 OTHER CONTRACT SERVICES 19,021 30,000 10,979 37% 5310-455-430640-356 CONSULTANTS 43,858 77,500 33,642 43% 5310-455-430640-358 CONSULTANT-TMDL 0 185,000 185,000 100% 5310-455-430640-360 MISC. MAINT SERVICES 16,968 30,000 13,032 43% 5310-455-430640-366 BUILDING MAINTENANCE 4,231 40,000 35,769 89% 5310-455-430640-373 DUES & TRAINING 4,255 7,500 3,245 43% 5310-455-430640-388 MEDICAL SERVICES 0 500 500 100% 5310-455-430640-510 PROPERTY & LIABILITY INS. 37,449 37,343 106- -0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 11,245 22,489 11,244 50% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 58,635 117,270 58,635 50% 5310-455-430640-528 DATA PROCESSING TRANSFER 11,949 23,898 11,949 50% 5310-455-430640-920 BUILDINGS 0 32,000 32,000 100% 5310-455-430640-930 BIOSOLIDS ALTERNATE DISPOSAL ENG 4,948 183,000 178,052 97% ------------------------------------------------- SUBTOTAL WWTP OPERATIONS 726,066 1,966,988 1,240,922 63% ------------------------------------------------- WWTP BONDED PROJECT 5310-455-430644-930 BIOSOLIDS ALTERNATE DISPOSAL ENG 3,163 117,000 113,837 97% ------------------------------------------------- SUBTOTAL WWTP BONDED 3,163 117,000 113,837 97% ------------------------------------------------- WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 50,809 100,000 49,191 49% 5310-455-430645-921 E. SECONDARY CLARIFIER COATING PRJ 0 60,000 60,000 100% 5310-455-430645-934 SECONDARY DIGESTER LID INSPECTION 742,742 1,388,991 646,249 47% 5310-455-430645-937 SAND FILTER MAINT & REPLACEMENT 0 100,000 100,000 100% 5310-455-430645-940 MACHINERY & EQUIPMENT 90,598 97,000 6,402 7% ------------------------------------------------- SUBTOTAL WWTP REPLACEMENT 884,150 1,745,991 861,841 49% ------------------------------------------------- WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 52,239 110,917 58,678 53% 5310-455-430646-121 OVERTIME 61 0 61- 0% 5310-455-430646-153 HEALTH INSURANCE 6,830 17,608 10,778 61% 5310-455-430646-155 RETIREMENT 3,956 8,161 4,205 52% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 1,073 4,500 3,427 76% 5310-455-430646-218 NON-CAPITAL EQUIPMENT 1,890 2,500 610 24% 5310-455-430646-222 LAB SUPPLIES 5,443 16,500 11,057 67% 5310-455-430646-349 LAB SERVICES 5,999 30,000 24,001 80% 5310-455-430646-362 EQUIPMENT MAINTENANCE 75 5,500 5,425 99% 5310-455-430646-373 DUES & TRAINING 959 3,700 2,741 74% THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 31 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ------------------------------------------------- SUBTOTAL WWTP LAB OPERATIONS 78,525 199,386 120,862 61% DEBT SERVICE - WWTP 5310-455-490227-610 PRIN-WWTP IMP/SRF8164R/2.25% 0 832,000 832,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 179,978 179,978 1 0% 5310-455-490228-610 PRIN/WWTP DIGESTER LID/SRF13326/3.0 0 47,000 47,000 100% 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 25,935 25,935 0 0% ------------------------------------------------- SUBTOTAL DEBT SERVICE - WWTP 205,913 1,084,913 879,001 81% ------------------------------------------------- CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-830 EVERGREEN REPLACEMENT TRANSFER 0 420,000 420,000 100% 5310-455-510400-831 DEPRECIATION EXPENSE 0 1,425,000 1,425,000 100% ------------------------------------------------- SUTOTAL WWTP DEPRECIATION/REPL 0 1,845,000 1,845,000 100% ------------------------------------------------- SUBTOTAL WWTP 1,897,816 6,959,278 5,061,462 73% ------------------------------------------------- TOTAL BILLING/SANITARY/WWTP 13,999,642 26,685,282 12,685,640 48% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 32 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM SEWER REVENUE 5349-000-323108-000 PW PLAN REVIEW FEES 180 0 180- 0% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 0 1,500 1,500 100% 5349-000-343033-000 IMPACT FEES 75,496 200,000 124,504 62% 5349-000-343034-000 PERMIT FEES 895 0 895- 0% 5349-000-343035-000 STORM SEWER CHARGES 0 1,000 1,000 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 1,483,087 1,390,000 93,087- -7% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 2,090 1,500 590- -39% 5349-000-371010-000 INTEREST ON INVESTMENTS 28,432 25,000 3,432- -14% ------------------------------------------------- TOTAL STORM REVENUE 1,590,179 1,619,000 28,821 2% ================================================= STORM SEWER 5349-453-430246-110 SALARIES-STORM SEWER 204,579 451,922 247,343 55% 5349-453-430246-121 OVERTIME 66 4,000 3,934 98% 5349-453-430246-153 HEALTH INSURANCE 32,917 97,880 64,963 66% 5349-453-430246-155 RETIREMENT 15,583 33,856 18,273 54% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 7,869 16,100 8,231 51% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 837 6,550 5,713 87% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100% 5349-453-430246-231 GAS & OIL 4,243 11,500 7,257 63% 5349-453-430246-345 TELEPHONE & COMMUNICATION 1,223 1,000 223- -22% 5349-453-430246-353 AUDITING 1,150 1,150 0 0% 5349-453-430246-354 CONTRACT SERVICE 17,380 7,000 10,380- -148% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 1,654 135,000 133,346 99% 5349-453-430246-358 CONSULTANTS 1,392 10,000 8,608 86% 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 465 4,000 3,535 88% 5349-453-430246-371 CURB & GUTTER 380 7,000 6,620 95% 5349-453-430246-373 DUES & TRAINING 1,068 5,500 4,432 81% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 204 10,000 9,796 98% 5349-453-430246-510 PROPERTY & LIABILITY INS. 8,127 11,824 3,697 31% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 5,066 10,133 5,067 50% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 21,029 42,058 21,029 50% 5349-453-430246-528 DATA PROCESSING TRANSFER 9,559 19,118 9,559 50% 5349-453-430246-530 BNSF LEASE PMT 4,672 6,000 1,328 22% 5349-453-430246-532 OFFICE RENT 6,421 6,422 1 0% 5349-453-430246-951 2 MILE DR. DRAINAGE IMPROVEMENT 0 250,000 250,000 100% 5349-453-430246-952 STORM DRAIN CORRECTION 50,677 200,000 149,323 75% 5349-453-430246-953 SHOP COMPLEX PAVEMNT 0 188,200 188,200 100% 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 0 390,000 390,000 100% 5349-453-430247-954 N MAIN ST STORMWATER PROJ 0 252,500 252,500 100% 5349-453-430248-959 REGIONAL FACILITY UPSIZING 0 1,236,000 1,236,000 100% 5349-453-430248-960 STORMWATER FACILITY UPSIZE 123,383 230,000 106,617 46% 5349-453-430249-840 MACHINERY & EQUIP. - MACI MATCH (CA 0 43,000 43,000 100% 5349-453-430249-940 MACHINERY FROM REPLACEMENT 0 50,000 50,000 100% 5349-453-490200-610 PRINCIPAL-4TH AVE E BOND 0 2,837 2,837 100% 5349-453-490200-620 INTEREST-4TH AVE E BOND 1,712 1,712 0- -0% 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 285,000 285,000 100% ------------------------------------------------- TOTAL STORM 521,656 4,047,062 3,525,406 87% THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 33 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 34 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 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 239 0 239- 0% 5510-000-343410-000 GARBAGE COLLECTION-ASSESSED 1,022,157 996,000 26,157- -3% 5510-000-343420-000 GARBAGE COLLECTION-BILLED 21,655 25,000 3,345 13% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,222 2,100 878 42% 5510-000-371010-000 INVESTMENT EARNINGS 7,449 8,000 551 7% ------------------------------------------------- TOTAL SOLID WASTE REVENUE 1,052,722 1,031,100 21,622- -2% ================================================= SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES-SOLID WASTE 187,437 418,051 230,614 55% 5510-460-430840-112 SEVERANCE-RETIREMENT 34,107 65,447 31,340 48% 5510-460-430840-121 OVERTIME 1,043 6,500 5,457 84% 5510-460-430840-153 HEALTH INSURANCE 34,015 94,557 60,542 64% 5510-460-430840-155 RETIREMENT 15,480 31,059 15,579 50% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 6,581 14,500 7,919 55% 5510-460-430840-218 EQUIPMENT-GARBAGE CONTAINERS 0 37,500 37,500 100% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 1,007 5,500 4,493 82% 5510-460-430840-231 GAS & OIL 22,963 55,000 32,037 58% 5510-460-430840-341 ELECTRICITY 562 2,050 1,488 73% 5510-460-430840-344 NATURAL GAS 573 4,500 3,927 87% 5510-460-430840-345 TELEPHONE & COMMUNICATION 908 1,250 342 27% 5510-460-430840-354 CONTRACT SERVICES 3,884 20,000 16,116 81% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 780 5,700 4,920 86% 5510-460-430840-366 BUILDING MAINTENANCE 527 4,500 3,973 88% 5510-460-430840-373 DUES & TRAINING 538 3,500 2,962 85% 5510-460-430840-388 MEDICAL SERVICES 105 650 545 84% 5510-460-430840-510 PROPERTY & LIABILITY INS. 8,258 9,400 1,142 12% 5510-460-430840-512 UNINSURED LOSS-DEDUCTIBLE 0 4,000 4,000 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 35,935 71,869 35,934 50% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 19,100 38,199 19,099 50% 5510-460-430840-528 DATA PROCESSING TRANSFER 7,169 14,339 7,170 50% 5510-460-430840-532 OFFICE RENT 6,421 6,422 1 0% 5510-460-430840-610 DEBT SERVICE PRINCIPAL-GARBAGE TK 0 39,121 39,121 100% 5510-460-430840-620 DEBT SERVICE INTEREST-GARBAGE TK 611 1,232 621 50% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 20,000 40,000 20,000 50% 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 0 38,200 38,200 100% 5510-460-430845-224 JANITORIAL SUPPLIES 83 500 417 83% 5510-460-430845-341 ELECTRICITY 793 3,500 2,707 77% 5510-460-430845-342 WATER 234 2,000 1,766 88% 5510-460-430845-344 NATURAL GAS 1,501 6,000 4,499 75% 5510-460-430845-360 REPAIR & MAINT SERVICES 354 18,909 18,555 98% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% ------------------------------------------------- TOTAL SOLID WASTE EXPENSE 410,967 1,213,955 802,988 66% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 35 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING INTERNAL SERVICE FUNDS INFORMATION TECHNOLOGY REVENUE 6030-000-331112-000 Homeland Security Grt(Cyber Attack 12,665 0 12,665- 0% 6030-000-335230-000 ENTITLEMENT SHARE PMT/HB124 90,000 180,000 90,000 50% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 51,692 188,000 136,308 73% 6030-000-371010-000 INVESTMENT EARNINGS 1,080 1,100 20 2% 6030-000-393000-000 INTERNAL SERVICES-DATA 133,828 267,657 133,829 50% ------------------------------------------------- TOTAL INFORMATION TECH REVENUE 289,266 636,757 347,491 55% ================================================= INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 79,038 175,914 96,876 55% 6030-401-410580-121 OVERTIME 0 1,000 1,000 100% 6030-401-410580-153 HEALTH INSURANCE 16,814 42,173 25,359 60% 6030-401-410580-155 RETIREMENT 6,287 13,828 7,541 55% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 384 4,158 3,774 91% 6030-403-410580-215 COMPUTER SUPPLIES 206 2,200 1,994 91% 6030-403-410580-218 EQUIPMENT-NOT CAPITAL 6,003 25,800 19,797 77% 6030-403-410580-325 WEBSITE 15,898 16,375 477 3% 6030-403-410580-345 PAGER/PHONE 1,000 2,550 1,550 61% 6030-403-410580-346 SUMMITNET & ISPS 6,000 16,224 10,224 63% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,432 3,866 434 11% 6030-403-410580-354 MAINTENANCE CONTRACTS 10,507 25,000 14,493 58% 6030-403-410580-355 LICENSES 13,925 20,250 6,325 31% 6030-403-410580-356 MAINTENANCE CONTRACTS 21,587 49,100 27,513 56% 6030-403-410580-357 GRANICUS 4,788 5,000 212 4% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 6,087 23,661 17,574 74% 6030-403-410580-373 DUES & TRAINING 192 8,300 8,108 98% 6030-403-410580-510 INSURANCE 1,313 2,000 687 34% 6030-403-410583-218 TV-Video Equipment & programming 190 7,100 6,910 97% 6030-403-410585-229 COPIER,FAX, SUPPLIES 2,263 19,548 17,285 88% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 39,447 78,000 38,553 49% 6030-403-410585-532 COPIER LEASES 8,458 14,388 5,930 41% 6030-403-410585-942 Servers - capital contingency 0 12,000 12,000 100% 6030-403-510400-831 DEPRECIATION EXPENSE 0 10,000 10,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 420 705 285 40% 6030-405-410588-940 COMPUTERS - SWITCHES 0 16,000 16,000 100% 6030-410-410588-218 COMPUTERS - DPW 4,938 5,808 870 15% 6030-413-410588-218 COMPUTERS - POLICE DEPT 5,449 33,003 27,554 83% 6030-413-410588-354 POLICE - HOSTED SERVER 557 2,150 1,593 74% 6030-416-410588-218 COMPUTERS - FIRE 4,661 12,258 7,597 62% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 3,696 2,405 1,291- -54% 6030-436-410588-218 COMPUTERS - PARKS 2,537 7,080 4,543 64% 6030-480-410588-218 COMMUNITY DEVELOPMENT 123 0 123- 0% ------------------------------------------------- TOTAL INFORMATION TECH EXPENSE 266,199 657,844 391,645 60% ================================================= THE CITY OF KALISPELL, MONTANA01.03.2019 12:17 gb8501_pg.php/Job No: 94269 Page 36 of 36 USER: RGW FY19 FINANCIAL REPORT THRU DECEMBER 31, 2018 50.00 % Yr Complete For Fiscal Year: 2019 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 272,000 544,000 272,000 50% 6010-000-371010-000 INVESTMENT EARNINGS 961 400 561- -140% ------------------------------------------------- TOTAL CENTRAL GARAGE REVENUE 272,961 544,400 271,439 50% ================================================= CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 76,391 165,695 89,304 54% 6010-410-431330-121 OVERTIME 972 2,500 1,528 61% 6010-410-431330-153 HEALTH INSURANCE 16,002 48,559 32,557 67% 6010-410-431330-155 RETIREMENT 5,425 12,237 6,812 56% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 2,856 11,000 8,144 74% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 1,151 10,700 9,549 89% 6010-410-431330-230 OIL 9,771 25,000 15,229 61% 6010-410-431330-231 GAS 439 1,500 1,061 71% 6010-410-431330-232 VEHICLE PARTS 57,013 124,000 66,987 54% 6010-410-431330-233 TIRES 36,495 48,000 11,505 24% 6010-410-431330-238 FILTERS 3,509 8,500 4,991 59% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 889 2,000 1,111 56% 6010-410-431330-341 ELECTRICITY 658 1,950 1,292 66% 6010-410-431330-344 NATURAL GAS 1,516 6,000 4,484 75% 6010-410-431330-354 CONTRACT SERVICES 12,066 30,000 17,934 60% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 160 8,000 7,840 98% 6010-410-431330-373 DUES & TRAINING 3,527 7,200 3,673 51% 6010-410-431330-388 MEDICAL SERVICES 302 425 123 29% 6010-410-431330-510 INSURANCE 2,217 2,179 38- -2% 6010-410-431330-528 INFORMATION TECH TRANSFER 4,780 9,559 4,779 50% 6010-410-431330-944 TIRE CHANGER 13,517 15,000 1,483 10% ------------------------------------------------- TOTAL CENTRAL GARAGE EXPENSES 249,655 540,004 290,349 54% ================================================= Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Crimes Against Persons Homicide 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 SIWOC/Sexual Assault 1 0 3 0 4 0 4 1 4 2 4 2 4 1 3 0 3 0 4 0 6 0 1 0 41 6 Robbery 2 3 0 0 2 2 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 6 6 Aggravated Assault 5 2 4 0 5 4 4 1 3 0 4 0 5 4 1 0 5 2 4 0 2 2 2 1 44 16 Assault on a Peace Officer 0 0 0 0 1 1 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 Simple Assault 5 1 2 0 10 3 4 0 12 4 8 2 12 5 8 3 12 5 9 3 8 6 6 5 96 37 PFMA 12 6 6 5 12 3 4 3 10 7 12 4 8 8 10 6 9 3 12 9 17 13 10 7 122 74 Resisting Arrest 2 1 6 3 7 5 0 0 8 7 2 2 3 3 5 4 5 2 4 4 3 2 5 4 50 37 Burglary 8 2 4 0 7 1 12 0 12 0 4 2 10 3 13 1 7 0 4 0 1 0 3 1 85 10 Theft 63 9 60 16 58 17 64 16 64 16 44 11 64 33 62 21 54 26 54 21 46 11 58 13 691 210 Vehicle Theft/Unauth Use 7 2 1 0 3 0 6 0 6 0 1 0 2 0 2 0 4 1 6 0 7 0 6 0 51 3 Arson 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 Forgery/Counterfeit 4 0 3 0 4 0 6 0 5 1 8 1 4 0 6 1 3 1 3 0 2 0 0 0 48 4 Fraud 8 2 9 1 8 1 0 0 13 1 6 1 5 1 4 1 4 1 7 3 3 4 9 0 76 16 Theft of Identity 2 1 1 0 2 0 1 0 1 0 1 0 1 0 0 0 1 0 2 1 0 0 0 0 12 2 Embezzlement 0 1 1 1 1 0 1 0 0 0 1 0 0 0 2 0 1 0 1 0 1 0 0 0 9 2 Stolen Property offenses 1 1 1 1 1 0 1 0 1 0 0 0 2 0 2 0 1 1 1 1 0 0 1 0 12 4 Criminal Mischief 6 0 5 1 16 1 17 2 9 5 10 1 13 2 8 1 19 3 13 0 13 6 13 5 142 27 Crimes Against Society Weapon Law Violations 1 0 0 0 3 1 0 0 1 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 6 2 Prostitution Offenses 0 0 0 0 0 0 7 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 7 Child Pornography 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 Drug Offenses 46 20 43 17 57 23 40 12 38 26 28 18 37 24 26 18 33 16 49 36 47 30 27 14 471 254 Family Offenses (non-violent)1 0 1 1 1 1 2 0 4 0 1 0 3 0 0 0 5 1 1 0 1 0 0 0 20 3 DUI 15 13 15 14 19 18 12 12 18 17 7 7 19 18 10 9 12 12 17 26 8 14 7 10 159 170 Possession of Alcohol 4 16 3 4 2 5 1 0 2 2 5 11 5 9 12 17 5 5 4 3 5 7 5 10 53 89 Provide Alcohol to Minor 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 4 3 0 0 0 0 0 0 5 4 Other Alcohol Offenses 1 1 1 1 4 3 8 11 3 2 1 0 5 7 0 0 1 2 3 2 0 0 0 0 27 29 Kidnapping/Custodial Int.1 0 0 0 2 0 0 0 0 0 2 2 1 0 0 0 0 0 0 0 0 0 1 1 7 3 Disorderly Conduct 8 2 3 2 14 7 7 3 14 13 16 14 7 4 4 11 11 5 9 9 6 3 4 5 103 78 Criminal Trespass 9 4 8 3 18 10 21 12 29 22 13 13 13 7 13 10 9 5 7 3 8 4 9 4 157 97 Violation of Protective Order 4 0 5 1 4 3 1 0 2 0 3 0 2 0 3 1 7 0 5 2 3 0 7 0 46 7 Obstructing a peace officer 7 6 5 4 9 6 9 5 8 7 4 4 6 6 5 5 7 5 8 8 2 2 6 6 76 64 Juvenile Offenses (except MIP)3 2 1 1 7 3 7 1 5 6 8 9 5 1 9 10 8 5 0 0 4 4 5 6 62 48 Other Offenses 27 17 13 9 27 21 16 16 15 11 23 15 42 37 37 36 36 30 35 30 41 34 25 22 337 278 Total 255 112 204 85 308 139 255 102 288 150 218 121 280 174 245 155 266 134 262 161 234 142 210 114 3025 1589 Traffic Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites 795 405 516 336 804 478 608 337 643 457 646 389 636 390 958 519 708 393 692 436 766 378 685 398 8457 4916 Total Calls for Service Kalispell Police Department Case and Arrest Reports - 2017 January February March April May June July August September October November December Totals Crimes Against Property 2802 3374534633071279026022884296026602391272024062996 Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Crimes Against Persons Homicide 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 1 1 SIWOC/Sexual Assault 1 0 1 0 3 0 5 0 8 0 5 0 1 0 5 1 3 0 3 1 1 0 6 2 42 4 Robbery 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 1 1 1 0 3 2 Aggravated Assault 3 3 3 3 3 0 3 1 6 2 10 2 2 1 4 3 1 0 3 1 2 0 10 3 50 19 Assault on a Peace Officer 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Simple Assault 1 0 5 3 6 3 8 3 10 5 6 2 12 6 5 3 8 3 13 10 3 1 3 1 80 40 PFMA 8 3 7 5 13 8 12 9 14 8 12 6 8 3 8 8 9 3 5 6 5 3 8 6 109 68 Resisting Arrest 6 5 3 3 0 0 1 1 3 3 4 4 6 5 1 1 2 2 3 3 1 1 4 4 34 32 Burglary 8 2 4 2 4 1 4 0 5 0 2 0 8 2 7 0 8 1 2 0 6 1 7 1 65 10 Theft 56 14 38 10 46 19 47 15 50 21 67 19 47 10 56 10 64 20 48 22 53 19 37 10 609 189 Vehicle Theft/Unauth Use 3 2 3 2 5 0 2 1 2 1 2 0 3 1 5 1 5 1 2 0 6 2 2 1 40 12 Arson 0 0 0 0 0 0 1 0 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 1 Forgery/Counterfeit 3 1 0 0 4 0 4 1 5 0 3 1 2 0 0 1 2 1 4 0 5 0 2 0 34 5 Fraud 16 10 3 1 5 4 5 5 8 4 9 0 6 2 5 1 8 0 4 5 7 1 11 0 87 33 Theft of Identity 1 0 1 0 1 0 2 1 1 0 1 0 1 0 3 0 2 0 2 0 0 0 3 0 18 1 Embezzlement 0 0 1 0 3 0 1 0 2 1 0 2 1 0 0 1 1 0 1 1 0 2 1 0 11 7 Stolen Property offenses 3 0 2 2 0 1 1 0 3 0 2 0 3 2 1 0 3 1 2 0 2 1 2 0 24 7 Criminal Mischief 10 3 2 1 12 1 15 2 16 6 12 4 14 2 16 2 15 5 12 3 12 1 9 2 145 32 Crimes Against Society Weapon Law Violations 1 0 0 0 1 0 1 1 0 0 0 0 0 0 1 1 0 0 0 0 1 1 0 0 5 3 Prostitution Offenses 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 Child Pornography 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 4 0 Drug Offenses 43 24 27 18 20 6 38 15 41 21 24 19 31 18 39 26 34 25 36 18 32 25 21 16 386 231 Family Offenses (non-violent)1 0 1 0 1 0 0 0 1 0 0 0 1 0 1 0 2 0 1 0 2 0 2 0 13 0 DUI 13 15 14 14 12 11 9 9 10 10 12 12 10 9 15 15 12 12 15 15 10 16 9 11 141 149 Possession of Alcohol 8 13 8 7 8 11 5 9 9 9 8 9 3 3 6 6 3 3 6 7 4 4 2 2 70 83 Provide Alcohol to Minor 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 2 0 Other Alcohol Offenses 0 0 0 0 1 1 1 1 1 1 0 0 2 5 0 0 1 1 0 0 0 0 0 0 6 9 Kidnapping/Custodial Int.1 0 0 0 1 1 0 0 1 0 1 0 0 0 0 0 0 0 0 0 1 0 1 1 6 2 Disorderly Conduct 4 2 2 1 8 6 11 8 9 5 5 4 6 6 8 4 7 3 5 8 3 3 7 4 75 54 Criminal Trespass 17 7 9 2 12 5 12 7 6 2 12 7 18 6 11 6 10 7 8 6 6 6 4 2 125 63 Violation of Protective Order 2 1 1 0 1 0 0 0 1 0 5 1 3 1 3 1 2 0 3 1 2 0 3 0 26 5 Obstructing a peace officer 9 6 3 2 5 4 3 3 5 5 12 8 10 8 12 8 6 6 4 3 8 8 3 2 80 63 Juvenile Offenses (except MIP)5 2 5 4 4 2 9 8 6 7 16 12 5 3 6 4 8 6 9 7 9 8 5 6 87 69 Other Offenses 43 41 29 27 31 29 34 32 29 23 28 26 29 27 37 36 37 36 38 33 37 36 30 26 402 372 Total 266 154 172 107 212 113 234 132 254 135 258 138 232 120 257 141 253 136 230 150 220 140 196 100 2784 1566 Traffic Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites 840 478 564 319 787 367 734 414 912 489 718 367 764 424 881 448 771 453 817 468 777 445 895 538 9460 5210 Total Calls for Service Kalispell Police Department Case and Arrest Reports - 2018 January February March April May June July August September October November December Totals Crimes Against Property 2919 3490930073269322728603051280428982250258627933245