The URL can be used to link to this page

07-12-19 City Manager ReportKALISPELL 1. Public Works City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 7/11/2019 TWAS Roof Replacement Phase one of the TWAS roof replacement project is complete. Phase two is scheduled to take place in fiscal year 2020, and involves replacing the electrical conduits and wiring. The TWAS Tank was installed in the 1992 Treatment Plant Expansion. The TWAS tank was initially part of the Two Stage Fermentation Process for Phosphorus Removal from 1992-2007. In 2007, with the plant update, the tank was repurposed to be used for foam remediation and as a backup tank for maintenance projects. Water Main Replacement The water main replacement project in Conrad Drive is at substantial completion. Overall, the contractor installed 3 new fire hydrants, 14 valves, and 1,385 ft of new water main starting from College Ave to the connection locations in the intersection of Woodland Drive and Second Ave E. Additionally, the entire street cross- section was newly paved. The city utilized street pavement funds to improve the deteriorated pavement on the street sections outside of the water project. 1 2. Police Department The Kalispell Police Department participated in outdoor rifle qualifications July 8, 9, and 10. This year's training and qualification included expanding training time including shoot/don't shoot scenarios utilizing a newly acquired rotating target assembly. This requires officers to identify if the target is a threat and to make sound decisions. Detective Webster, Det. Sgt. Bartholomew and Chief Overman participated in the Flathead Children Advocacy Center reaccreditation on July 10, 2019. The reaccreditation process ensures our Center is functioning at national standards. Officer Cory Clarke and Chief Overman will attend a meeting with Western Montana Mental Health on July 11. The purpose of the meeting is to align mental health and addiction professionals with law enforcements field response. The goal is to connect those people in need of service with professional help. 3. Parks and Recreation The 2-5 year -old playground at Woodland Park is getting closer to opening with the pouring of a sidewalk around the perimeter of the playground. This new sidewalk will provide better access around the structure for all and will serve as the barrier in holding the fall surfacing in place. Reclamation of the turf around these structures will happen after they are completed. An Eagle Scout candidate has completed the creation and installation of three nature trail kiosk signs as well as three trail entrance signs at the Lawrence Park nature trail. Four more interpretative signs are in the works by another Eagle Scout candidate. Camp Woodland just finished week five of our summer day camp program. We have been at 99% capacity so far and have only 2 spots left for the entire summer. The camp has some great fields trips planned over the next two weeks with the kids visiting Whitefish Lake, the Lake Five Resort, the Whitefish Mountain Resort, and Glacier National Park. On July 2, weather forced us to cancel the Tropical Montana Marimba Ensemble scheduled to play at Picnic in the Park. We did have an incredible turn out for the Talbott Brothers on July 9. The Talbott Brothers, based out of Portland, Oregon, was a new band for Picnic in the Park and they put on a great show for attendees. Jameson & the Sordid Seeds and Marshall Catch, both valley favorites, are coming up over the next two consecutive Tuesdays. 2 Kalispell Parks & Recreation and the Glacier Raft Company partnered again this summer to give the Kalispell community a great opportunity to try a half -day rafting experience at a greatly reduced rate. We had 23 people participate in our first rafting experience on Saturday, July 6. We have one more opportunity for the community to participate on Saturday, August 10. 4. Information Services City staff worked with a consultant to resolve issues with the map used to display storm data for our Cityworks program. Previously, the map failed to load at times, was fuzzy or unusable for City staff. The issue had been long standing and interrupted City staff work. The storm map now operates without issues. IT staff continue to replace various computers and tablets for staff. The City shop complex cabling portion of the network redesign project is nearly complete, with cable testing remaining. City IT staff are installing new switches to each shop. 5. Building Department In the last 2 weeks, we have issued permits for 5 single-family homes and 2 townhomes. This brings the total of new single-family/duplex and townhouse units for the year to 63, compared to 56 last year at this time. We are currently sitting at 24 units of multifamily housing year to date. Last year, at this time, we had issued permits for 36 apartment units. A permit, valued at $283,405, was issued for the Glacier Law Firm remodel located at 165 Commons Loop. The tenant improvement permit, valued at $60,000, for Riddles Jewelry's new location at 2244 Hwy 93 North was issued. 6. Planning Department The Planning Board met on Tuesday, July 9 and heard a request by Woodlands LLC for a conditional use permit to construct a 9-unit apartment building on a .34 acre parcel of land zoned B-1 on the northeast corner of Shady Glen Road and Woodland Park Drive immediately west of the Woodland Skate Park. The applicant was proposing seven 2- bedroom units and two studio apartments. Several neighbors spoke in opposition to the proposed density and potential traffic impacts. There was also considerable discussion with the placement of the garbage container too close to an existing house. The planning board ultimately recommended approval on a unanimous vote with 13 conditions attached. This item is tentatively scheduled for the August 5 council meeting. 3 The board also held a work session on a request by Town Pump to relocate an existing casino/convenience store at their facility located on the southwest corner of Cemetery Road and US 93 South. The current casino is non -conforming and if closed or moved it cannot be legally rebuilt. Town Pump is pursuing a PUD to allow the casino to be rebuilt several hundred feet west while incorporating their new design concepts similar to the facility at US 93 North and West Reserve across from Home Depot. As part of the PUD process, the planning board discussed the merits of rebuilding the existing casino and incorporating improved architecture, landscaping, signage and screening at that intersection to better reflect the entrance to Kalispell and match the other two corners where Toyota, Green Nissan and Hyundai are located. The Planning Board will hold a public hearing on this issue next month. 7. Community Development The South Kalispell Tax Increment Finance (TIF) District project for traffic improvements at the area of 18th Street and Airport Road will move forward with the proposed 16th Street Offset option. This direction follows City Council discussions and recommendations from the Urban Renewal Agency (URA). The 16th Street Offset design introduces a new street connection at 16th Street West, approximately 360 feet to the north of 18th Street. A two-way stop with a free flow north and south is proposed at the new intersection with 1" Avenue West to accommodate the primary traffic movement. Street lighting is recommended on Airport Road at both the existing 18th Street intersection and the proposed 16th Street intersection. Pedestrian access is included with a widened path along the west side of Airport Road and extension of sidewalk south to Rankin Elementary School and north to 12 th Street West. As proposed, the cost estimate is $1.48 million with approximately $2.1 million in TIF funds currently available for improvements in this area. Additional improvement projects that fit within the District's urban renewal plan will now be explored. 8. Finance Department Please find attached the printouts reflecting the activity for July 1, 2018 thru June 30, 2019 (FYI 9). All funds are included with the exception of the debt service funds. GOVERNMENTAL FUNDS REVENUES: Most general fund revenues are complete with the following exceptions. General Fund revenue reflects real property tax revenue received from Flathead County thru June 30. Fiscal year 2019 taxes collected by Flathead County before June 30 will be distributed in n July, and should be about $400,000 in the general fund. Fiscal year 2019 General Fund revenues variance with the budgeted amount will be less than 1 %. At June 30, 2019, the City is carrying $17,509 in protest taxes in the General Fund, an increase from the prior fiscal year end total of about $1,200. Parks will receive approximately another $65,000 real property tax revenue for fiscal year 2019. A Board of Investments loan of $100,000 for the new Woodland Park playgrounds will put the Parks department revenues over budget by 3 % for fiscal year 2019. All other Parks revenues should be complete with maybe some minor adjustments. Ambulance fees for services ($703,802) exceeded last fiscal year by over $90,000, and the budgeted amount of $696,766. The second half of the County EMS Levy has not been received, but it will likely be about $60,000. Overall, the ambulance revenues should exceed the budgeted amount by about $25,000. Building department revenues should be complete and finished fiscal year 2019 18% under the budgeted amount, and about $500,000 less than fiscal year 2018. EXPENDITURES: Expenditures are not final as fiscal year 2019 claims have not all been processed. General fund fiscal year 2019 expenditures are currently $665,008 (6%) under the budgeted amount of $11,851,324. $114,793 of the $665,008 is a carryover to fiscal year 2020 for Police department vehicles. Fiscal year 2019 claims processing in fiscal year 20, based on past fiscal year history, and reducing for the Police carryover, could bring the budget surplus down to about $450,000. Total Parks and Recreation Fund expenditures are 14% ($299,860) under fiscal year 2019 budget, which should be more than adequate for final claims, generally around $50,000. The ambulance fund and the building department will expend 95% to 100% of their respective fiscal year 2019 budgeted amounts. ENTERPRISE FUNDS REVENUES: Metered water sales were $3,193,048. This is 110% of the budgeted amount. For comparison, last year's metered water sales were $3,274,414. This decrease in water sales goes back to the hot and dry summer of 2018. Water impact fees were over 1.5 times the budgeted amount, but $10,000 less than last fiscal year. In total, water department revenues were $694,43 6 (19%) over the budgeted amount. Sewer service charges were $4,571,438, 102% of the budgeted amount, and slightly more than last fiscal year's sewer service charges. Sanitary sewer and treatment plant impact fees were 169% and 186% of the anticipated fiscal year 2019 amount, respectively. In 5 total, sewer department revenues were $1,062,721 (19%) over the budgeted amount. EXPENSES: Evaluation of the budget versus actual of the enterprise funds is limited to operating expenses (excludes depreciation and capital). The Water Fund operating expenses are currently $476,181 under the budgeted amount. Personal services savings account for about 33% ($156,040). Other budget savings of about 10% should be seen in energy cost (natural gas, electric, gasoline), contract services (as much as 30%), and about $50,000 (43%) in construction materials expenses. $10,000 was budgeted, and less than $1,000 used for uninsured losses. The Sewer Fund, including the treatment plant, operating expenses are currently $586,915 under the budgeted amount. Personal services savings should be about $138,000. Other budget savings of about $20,000 should be seen in energy cost (natural gas, electric, gasoline), contract services (possibly more than $250,000), and uninsured loss ($25,000). Total Storm Sewer Fund operating expenses are currently 20% ($224,928) under fiscal year 2019 budget, which should be more than adequate for final claims, generally not over $50,000. Total Solid Waste Fund operating expenses are currently 14% ($127,897) under fiscal year 2019 budget. Final solid waste claims are generally insignificant (under $10,000). 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 1 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 5,821,829 6,222,000 400,171 60-. 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 16,459 16,500 41 00-. 1000-000-311200-000 PERSONAL PROPERTY TAXES 148,884 145,000 3,884- -30-. 1000-000-312000-000 PEN & INTEREST DEL. TAXES 7,673 8,000 327 40-. 1000-000-322101-000 LIQUOR LICENSES 32,725 30,000 2,725- -90-. 1000-000-322300-000 BUSINESS LICENSES 1,453 1,700 247 150-o 1000-000-323012-000 PLANNING FEES 76,685 60,000 16,685- -280-o 1000-000-323109-000 SITE REVIEW 21,040 15,000 6,040- -400-o 1000-000-323200-000 PARADE PERMITS 150 1,000 850 850-o 1000-000-335030-000 M.V. TAX - AD VALOREM 1,626 1,500 126- -80-0 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 60,325 60,000 325- -10-0 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,400 1,000 400- -400-o 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 2,878,523 2,878,523 0 00-0 1000-000-341020-000 ADMINISTRATIVE CHARGES 626,185 628,533 2,348 00-0 1000-000-341021-000 GRANT ADMIN FEES 14,322 80,000 65,678 820-o 1000-000-341025-000 CITY COLLECTIONS 7,346 5,000 2,346- -470-o 1000-000-342010-000 POLICE SERVICES 30,226 25,000 5,226- -210-o 1000-000-342014-000 RESOURCE OFFICERS 209,187 209,187 0 00-0 1000-000-342016-000 KPD REGIONAL TRAINING 2,425 12,000 9,575 800-0 1000-000-343018-000 PARKING PERMITS 93,631 95,000 1,369 10-0 1000-000-343062-000 AIRPORT FUEL TAX 3,707 6,578 2,871 440-o 1000-000-343063-000 AIRPORT GROUND LEASE 14,423 14,422 1- 00-0 1000-000-351000-000 CITY COURT FINES & FEES 426,039 450,000 23,961 50-o 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 31,180 20,000 11,180- -560-o 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 55,670 50,000 5,670- -110-0 1000-000-362015-000 INSURANCE REIMBURSEMENTS 0 20,000 20,000 1000-0 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 31,148 5,000 26,148- -5230-o 1000-000-371010-000 INVESTMENT EARNINGS 58,953 25,000 33,953- -1360-o 1000-000-373030-000 INTEREST ON OLD SCHOOL SID LOAN - 1 0 48,750 48,750 1000-0 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 889,000 889,000 0 00-0 TOTAL GENERAL FUND REVENUE 11,562,214 12,023,693 461,479 40-8 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 2 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 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 2,935 2,935 0 00-. 1000-400-410530-353 CONTRACT SERVICES - AUDIT 13,750 14,250 500 40-8 1000-400-410530-354 OPEB EXPENSE 1,100 0 1,100- 00-. 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 1,598 4,000 2,402 600-. 1000-400-410560-312 POSTAGE 17,141 17,000 141- -10-. 1000-400-410560-320 PRINTING & ENVELOPES 6,769 4,000 2,769- -690-. 1000-400-410560-354 CONTRACT SERVICES - DOC. SHREDDING 1,170 250 920- -3680-. 1000-400-410900-331 RECORDS ADMIN./FILING FEES 2,758 4,000 1,242 310-o 1000-400-420000-354 CONTRACT 911 CENTER 511,815 510,000 1,815- -00-0 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 354 400 46 110-0 1000-400-430300-355 AIRPORT REIMBURSEMENT 18,129 21,000 2,871 140-8 1000-400-460000-820 TRANSFER TO FORESTRY 100,000 100,000 0 00-0 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 15,000 15,000 0 00-0 1000-400-460452-366 HOCKADAY MAINTENANCE 6,600 6,600 0 00-0 1000-400-510300-000 CONTINGENCY 0 30,000 30,000 1000-0 1000-400-510310-354 ICMA PLAN FEES 375 500 125 250-8 1000-400-510330-513 LIABILITY INSURANCE 75,391 73,483 1,908- -30-o 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 44,792 50,000 5,208 100-0 1000-400-510330-517 PROPERTY INSURANCE 50,760 50,760 0- 00-0 SUBTOTAL GEN.GOV'T. ------------ 870,437 ------------- 904,178 ------------ 33,741 ------------ 40-8 CITY MANAGER 1000-401-410210-110 SALARIES -CITY MANAGER'S OFFICE 1000-401-410210-153 HEALTH INSURANCE 1000-401-410210-155 RETIREMENT 1000-401-410210-210 SUPPLIES 1000-401-410210-312 NEWSLETTER/BOOKS 1000-401-410210-345 TELEPHONE & COMMUNICATION 1000-401-410210-373 DUES & TRAINING 1000-401-410210-379 MEETINGS SUBTOTAL CITY MANAGER HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 1000-401-410830-121 OVERTIME 1000-401-410830-153 HEALTH INSURANCE 1000-401-410830-155 RETIREMENT 1000-401-410830-210 OFFICE SUPPLIES 1000-401-410830-338 RECRUITMENT/RELOCATION 1000-401-410830-354 CONTRACT SERVICES 1000-401-410830-373 DUES & TRAINING SUBTOTAL HUMAN RESOURCES 143,627 144,715 1,088 10-0 25,678 22,723 2,955- -130-o 15,322 15,332 10 00-0 566 2,000 1,434 720-o 220 400 180 450-o 2,205 2,190 15- -10-0 9,477 11,000 1,523 140-o 4,850 5,000 150 30-o ------------------------- 201,944 ------------ 203,360 ------------ 1,416 10-0 131,424 130,303 1,121- -10-0 437 0 437- 00-0 18,982 17,344 1,638- -90-0 10,229 10,185 44- -00-0 428 600 172 290-o 15,002 8,000 7,002- -880-0 820 1,000 181 180-0 6,312 ------------------------- 6,500 ------------ 188 ------------ 30-o 183,634 173,932 9,702- -60-o 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 3 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 62,636 63,107 471 10-. 1000-402-410100-153 HEALTH INSURANCE 49,176 62,903 13,727 220-o 1000-402-410100-155 RETIREMENT 2,546 2,481 65- -30-o 1000-402-410100-210 OFFICE SUPPLIES 0 500 500 1000-0 1000-402-410100-335 MT LEAGUE OF CITIES 1,156 6,498 5,342 820-o 1000-402-410100-354 CONTRACT SERVICES 3,048 7,030 3,982 570-o 1000-402-410100-373 DUES & TRAINING 11,400 8,576 2,824- -330-o 1000-402-410100-379 MEETINGS 20,265 19,500 765- -40-o SUBTOTAL MAYOR/COUNCIL ------------ ------------- 150,226 ------------ 170,595 ------------ 20,369 120-o CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 92,102 93,439 1,337 10-0 1000-402-410150-121 OVERTIME 69 250 181 720-o 1000-402-410150-153 HEALTH INSURANCE 19,996 20,230 234 10-0 1000-402-410150-155 RETIREMENT 7,311 7,349 38 10-0 1000-402-410150-210 OFFICE SUPPLIES 69 300 231 770-o 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 180 600 420 700-o 1000-402-410150-345 TELEPHONE & COMMUNICATION 480 480 0 00-0 1000-402-410150-352 CODIFICATION 2,770 4,100 1,330 320-o 1000-402-410150-354 CONTRACT SERVICES 0 300 300 1000-0 1000-402-410150-373 DUES & TRAINING 3,557 3,200 357- -110-0 SUBTOTAL CITY CLERK ------------ ------------- 126,533 ------------ 130,248 ------------ 3,715 30-o FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 210,111 202,052 8,059- -40-o 1000-403-410550-112 SALARIES -RETIREMENT 22,908 24,871 1,963 80-0 1000-403-410550-121 OVERTIME 437 0 437- 00-0 1000-403-410550-153 HEALTH INSURANCE 38,732 38,637 95- -00-0 1000-403-410550-155 RETIREMENT 16,365 15,863 502- -30-o 1000-403-410550-210 SUPPLIES 317 1,000 683 680-o 1000-403-410550-322 BOOKS 0 300 300 1000-0 1000-403-410550-353 CONTRACT SERVICES 240 540 300 560-o 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 672 1,200 528 440-o 1000-403-410550-355 BANK CHARGES & FEES 3,026 3,200 174 50-o 1000-403-410550-373 DUES & TRAINING 7,663 7,500 163- -20-o SUBTOTAL FINANCE ------------ ------------- 300,470 ------------ 295,163 ------------ 5,307- -20-o 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 4 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CITY ATTORNEY 1000-404-411110-110 SALARIES -CITY ATTORNEY'S 368,482 382,200 13,718 40-8 1000-404-411110-121 OVERTIME 32 0 32- 00-. 1000-404-411110-153 HEALTH INSURANCE 62,432 61,927 505- -10-. 1000-404-411110-155 RETIREMENT 29,196 30,045 849 30-. 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 2,439 2,563 124 50-8 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 13,035 8,500 4,535- -530-. 1000-404-411110-345 TELEPHONE & COMMUNICATION 733 1,025 292 290-o 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 57,772 62,400 4,628 70-8 1000-404-411110-373 DUES & TRAINING 4,994 7,000 2,006 290-o SUBTOTAL CITY ATTORNEY ------------ ------------- 539,115 ------------ 555,660 ------------ 16,545 30-o MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 244,733 233,996 10,737- -50-8 1000-406-410360-121 OVERTIME 3,137 0 3,137- 00-0 1000-406-410360-153 HEALTH INSURANCE 36,780 43,902 7,122 160-o 1000-406-410360-155 RETIREMENT 18,196 18,350 154 10-0 1000-406-410360-210 SUPPLIES 2,054 4,500 2,446 540-8 1000-406-410360-320 PRINTING/BOOKS 1,041 1,500 459 310-o 1000-406-410360-345 TELEPHONE & COMMUNICATION 54 1,400 1,346 960-o 1000-406-410360-353 SECURITY & TECHNOLOGY 15,761 40,000 24,239 610-o 1000-406-410360-354 CONTRACT SERVICES 3,515 5,750 2,235 390-o 1000-406-410360-373 DUES & TRAINING 2,393 10,000 7,607 760-o 1000-406-410360-394 JURY & WITNESS FEES 742 7,500 6,758 900-0 SUBTOTAL COURT ------------ ------------- 328,409 ------------ 366,898 ------------ 38,489 100-0 PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 18,384 18,149 235- -10-0 1000-410-430100-153 HEALTH INSURANCE 3,146 3,285 139 40-8 1000-410-430100-155 RETIREMENT 1,418 1,396 22- -20-o 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 10,620 14,000 3,380 240-8 1000-410-430100-231 GAS 2,382 3,000 618 210-o 1000-410-430100-345 TELEPHONE & COMMUNICATION 300 350 50 140-8 1000-410-430100-354 CONTRACT SERVICES 286 2,000 1,714 860-o 1000-410-430100-373 DUES & TRAINING 2,224 2,500 276 110-0 1000-410-430100-521 CENTRAL GARAGE TRANSFER 4,434 4,434 0- -00-0 SUBTOTAL PUBLIC WORKS ADMIN ------------ ------------- 43,194 ------------ 49,114 ------------ 5,920 120-o CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 67,079 70,063 2,984 40-8 1000-412-411230-121 OVERTIME 21 200 179 890-0 1000-412-411230-153 HEALTH INSURANCE 13,248 14,419 1,171 80-0 1000-412-411230-155 RETIREMENT 5,114 5,268 154 30-o 1000-412-411230-220 SECURITY IMPROVEMENTS 1,407 2,000 593 300-o 1000-412-411230-224 JANITORIAL SUPPLIES 4,374 6,000 1,626 270-8 1000-412-411230-241 TOOLS & SUPPLIES 957 1,500 543 360-o 1000-412-411230-341 ELECTRICITY 43,142 47,000 3,858 80-0 1000-412-411230-344 NATURAL GAS 36,544 30,000 6,544- -220-o 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 5 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-345 TELEPHONE & COMMUNICATION 324 400 76 190-0 1000-412-411230-354 CONTRACT SERVICES 19,660 25,000 5,340 210-o 1000-412-411230-355 HVAC MAINTENANCE OCNTRACT 16,068 16,500 432 30-o 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 3,818 6,000 2,182 360-o 1000-412-411230-362 EQUIPMENT MAINTENANCE 7,905 10,000 2,095 210-o 1000-412-411230-366 BUILDING MAINTENANCE 5,169 27,500 22,331 810-0 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,373 3,700 327 90-0 1000-412-411230-920 BLDG IMP (ENTRYWAY,MEZZANINE, SHOOT 20,459 22,500 2,041 90-0 SUBTOTAL CITY HALL ------------ 248,662 ------------- 288,050 ------------ 39,388 ------------ 140-o 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 270,921 278,527 7,606 30-o 1000-420-411020-153 HEALTH INSURANCE 54,658 60,251 5,593 90-0 1000-420-411020-155 RETIREMENT 21,450 21,867 417 20-o 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 956 6,000 5,044 840-o 1000-420-411020-231 GAS 370 300 70- -230-o 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 1,244 2,000 756 380-o 1000-420-411020-345 TELEPHONE 800 1,000 200 200-o 1000-420-411020-354 CONTRACT SERVICES 4,467 2,000 2,467- -1230-o 1000-420-411020-373 DUES & TRAINING 6,472 7,000 528 80-0 1000-420-411020-521 CENTRAL GARAGE TRANSFER 1,129 1,129 0 00-0 SUBTOTAL PLANNING DEPT. ------------ ------------- 362,467 ------------ 380,074 ------------ 17,607 50-o 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 64,662 64,795 133 00-0 1000-480-470210-153 HEALTH INSURANCE 12,917 14,329 1,412 100-0 1000-480-470210-155 RETIREMENT 5,135 5,060 75- -10-0 1000-480-470210-210 OFFICE SUPPLIES 426 1,500 1,074 720-o 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 0 750 750 1000-0 1000-480-470210-312 POSTAGE & PRINTING 26 500 474 950-o 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 500 500 0 00-0 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 352 900 548 610-o 1000-480-470210-354 CONTRACT SERVICES 59 1,500 1,441 960-o 1000-480-470210-373 DUES & TRAINING 3,256 5,000 1,744 350-o 1000-480-470210-379 MEETINGS 1,253 1,500 247 160-o SUBTOTAL COMMUNITY DEVELOPMENT ------------ ------------- 88,585 ------------ 96,334 ------------ 7,749 80-0 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 6 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 2,173,622 2,290,530 116,908 50-8 1000-413-420140-112 SALARIES -SEVERANCE 13,889 0 13,889- 00-. 1000-413-420140-114 SALARY -comptime buyout 32,783 11,600 21,183- -183% 1000-413-420140-121 OVERTIME (REG & AET OT) 98,530 80,000 18,530- -23% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 16,292 25,000 8,708 35% 1000-413-420140-153 HEALTH INSURANCE 412,803 447,526 34,723 8% 1000-413-420140-155 RETIREMENT 275,500 299,512 24,012 8% 1000-413-420140-210 OFFICE SUPPLIES 3,137 3,500 363 10% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 8,661 5,500 3,161- -57% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 30,132 31,500 1,368 4% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 3,397 4,000 603 15% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 8,613 7,000 1,613- -23% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 2,542 2,000 542- -27% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 23,445 24,500 1,055 4% 1000-413-420140-227 AMMO & RELATED SUPPLIES 31,932 33,450 1,518 5% 1000-413-420140-228 PATROL CAR SUPPLIES 11,237 15,000 3,763 25% 1000-413-420140-229 OTHER SUPPLIES 3,747 5,000 1,253 25% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 617 1,000 383 38% 1000-413-420140-231 GAS 76,920 75,000 1,920- -3% 1000-413-420140-234 CRISIS NEGOTIATIONS 2,067 2,000 67- -3% 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 5,332 5,500 169 3% 1000-413-420140-345 TELEPHONE & COMMUNICATION 18,894 17,500 1,394- -8% 1000-413-420140-354 CONTRACT SERVICES 15,542 15,750 208 1% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 6,103 6,500 397 6% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 1,926 5,000 3,074 61% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 1,654 2,000 346 17% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 26,608 27,000 392 1% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 1,330 2,500 1,170 47% 1000-413-420140-373 DUES & TRAINING 33,440 40,500 7,060 17% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 4,782 14,500 9,719 67% 1000-413-420140-380 TRAINING MATERIALS 2,952 3,000 48 2% 1000-413-420140-388 MEDICAL SERVICES 2,292 3,000 709 24% 1000-413-420140-392 BOARDING/TREATING PRISONERS 1,706 2,500 794 32% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 79,749 79,749 0 0% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 64,000 64,000 0 0% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 3,500 3,500 0 0% 1000-413-420140-940 TRAILER (FY18) / 5-PORTABLE RADIOS 28,710 30,000 1,290 4% 1000-413-420140-942 DIGITICKET (FY18) / IRECORD REPLACE 24,790 22,000 2,790- -13% 1000-413-420140-944 VEHICLES 19,907 134,700 114,793 85% SUBTOTAL POLICE DEPT. 3,573,081 3,845,067 271,986 7% DETECTIVES 1000-413-420141-110 SALARIES -DETECTIVES 382,233 367,855 14,378- -4% 1000-413-420141-121 DETECTIVE -OVERTIME 13,025 15,000 1,975 13% 1000-413-420141-153 HEALTH INSURANCE 80,298 72,770 7,528- -10% 1000-413-420141-155 DETECTIVE -RETIREMENT 50,627 49,247 1,380- -3% TOTAL DETECTIVES ------------ 526,183 ------------- 504,872 ------------------------ 21,311- -4% RECORDS 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 7 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-110 SALARIES -RECORDS DIVISION 139,607 145,239 5,632 40-8 1000-413-420142-121 OVERTIME 3,234 7,500 4,266 570-8 1000-413-420142-153 HEALTH INSURANCE 32,101 33,814 1,713 50-8 1000-413-420142-155 RETIREMENT 11,208 11,359 151 10-0 TOTAL RECORDS ------------ 186,151 ------------- 197,912 ------------ 11,761 ------------ 60-o RESOURCE OFFICERS 1000-413-420144-110 SALARIES -SRO 269,682 268,582 1,100- -00-0 1000-413-420144-153 HEALTH INSURANCE 42,823 62,569 19,746 320-o 1000-413-420144-155 SRO RETIREMENT 34,110 36,047 1,937 50-o TOTAL RESOURCE OFFICERS ------------ 346,616 ------------- 367,198 ------------ ------------ 20,582 60-o ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL -SALARIES 43,170 41,770 1,400- -30-o 1000-413-420145-121 OVERTIME 0 500 500 1000-0 1000-413-420145-153 HEALTH INSURANCE 8,196 9,885 1,689 170-o 1000-413-420145-155 RETIREMENT 3,231 3,266 35 10-0 SUBTOTAL ANIMAL CONTROL ------------ 54,597 ------------- 55,421 ------------ ------------ 824 10-0 PARKING 1000-413-420147-110 PARKINGS -SALARIES 79,688 80,091 403 10-0 1000-413-420147-153 HEALTH INSURANCE 30,208 32,709 2,501 80-0 1000-413-420147-155 RETIREMENT 6,184 6,261 77 10-0 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 4,070 4,000 70- -20-o 1000-413-420147-354 CONTRACTED SERVICES 1,927 2,000 73 40-o 1000-413-420147-362 LOT MAINT 2,759 10,000 7,241 720-o 1000-413-420147-365 SNOW REMOVAL -Parking Lots 15,830 17,500 1,670 100-0 1000-413-420147-550 LOT LEASE PAYMENTS 1,111 1,500 389 260-o SUBTOTAL PARKING ------------ 141,778 ------------- 154,061 ------------ ------------ 12,283 80-0 SUBTOTAL POLICE DEPT. ------------ 4,828,406 ------------- 5,124,531 ------------ ------------ 296,125 60-o 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 8 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. FIRE DEPARTMENT 1000-416-420400-110 SALARIES -FIRE SUPPRESSION 1,566,590 1,707,020 140,430 80-. 1000-416-420400-114 COMPTIME BUYOUT 4,510 5,500 990 180-0 1000-416-420400-115 OUT OF RANK PAY 12,578 12,500 78- -10-0 1000-416-420400-121 OVERTIME 93,865 40,000 53,865- -1350-8 1000-416-420400-153 HEALTH INSURANCE 286,092 314,044 27,952 90-0 1000-416-420400-155 RETIREMENT 210,353 229,190 18,837 80-0 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 469 2,000 1,531 770-8 1000-416-420400-218 Equipment (Non Capital) 19,633 21,500 1,867 9% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 8,392 15,000 6,608 44% 1000-416-420400-224 JANITORIAL SUPPLIES 2,934 5,000 2,066 41% 1000-416-420400-231 GAS 10,186 17,325 7,139 41% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 12,660 15,750 3,090 20% 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 6,017 6,000 17- -0% 1000-416-420400-354 CONTRACT SERVICES 13,668 13,800 132 1% 1000-416-420400-362 EQUIPMENT MAINTENANCE 6,165 5,500 665- -12% 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 6,396 6,500 104 2% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 6,079 5,000 1,079- -22% 1000-416-420400-373 DUES & TRAINING 14,114 10,000 4,114- -41% 1000-416-420400-388 FIREFIGHTER PHYSICALS 21,879 26,675 4,796 18% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 40,027 40,027 0 0% 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 33,483 47,707 14,224 30% 1000-416-420400-620 INTEREST EXPENSE -FIRE TRUCK 10,984 15,750 4,766 30% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 500,000 500,000 0 0% 1000-416-420400-821 TRANSFER TO FUND 2956 GRANT MATCH 0 22,454 22,454 100% 1000-416-420440-110 SALARIES -FIRE PREVENTION 19,883 20,955 1,073 5% 1000-416-420440-121 OVERTIME 199 0 199- 0% 1000-416-420440-153 HEALTH INSURANCE 5,167 5,232 65 1% 1000-416-420440-155 RETIREMENT 1,527 1,558 31 2% SUBTOTAL FIRE DEPT. 2,914,234 3,113,187 198,953 6% GRAND TOTAL GENERAL FUND 11,186,316 11,851,324 665,008 6% ------------------------------------------------- ------------------------------------------------- 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 9 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. SPECIAL REVENUE FUNDS: 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 968,598 1,025,000 56,402 60-. 2215-000-311200-000 PERSONAL PROPERTY TAXES 25,039 40,000 14,961 370-o 2215-000-312000-000 PEN & INTEREST DEL TAXES 1,278 2,000 722 360-o 2215-000-335230-000 ENTITLEMENT SHARE PMT/HB 124 17,000 0 17,000- 00-0 2215-000-346030-000 SWIMMING POOL FEES 165,078 127,000 38,078- -300-o 2215-000-346040-000 CONCESSION STAND REVENUE 41,898 34,000 7,898- -230-o 2215-000-346050-000 PARKS USAGE FEES 20,444 21,500 1,056 50-o 2215-000-346051-000 RECREATION FEES 26,735 17,216 9,519- -550-o 2215-000-346052-000 SPORTS PROGRAMS 51,230 52,022 792 20-o 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 1,622 3,000 1,378 460-o 2215-000-346054-000 AFTER SCHOOL PROGRAMS 56,642 70,000 13,358 190-0 2215-000-346055-000 ICE RINK 21,597 22,500 903 40-o 2215-000-346056-000 KIDSPORT USAGE 4,077 2,500 1,577- -630-o 2215-000-346057-000 YOUTH CAMPS 157,080 147,302 9,778- -70-o 2215-000-346059-000 PICNIC IN THE PARK 27,045 27,000 45- -00-0 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 4,106 0 4,106- 00-0 2215-000-365015-000 KIDSPORTS MAINTENANCE 10,990 20,000 9,010 450-o 2215-000-371010-000 INVESTMENTS 8,923 4,000 4,923- -1230-o 2215-000-381050-000 INCEPTION OF LEASE 0 100,000 100,000 1000-0 2215-000-381060-000 HEALTH INSURANCE TRANSFER 91,000 91,000 0 00-0 TOTAL PARKS & REC REVENUE ------------ 1,700,383 ------------ ------------ ------------- 1,806,040 ------------- ------------- ------------ ------------ 105,657 ------------------------ ------------------------ 60-o PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 319,928 324,341 4,413 10-0 2215-436-460430-111 SEASONAL SALARIES 62,408 73,950 11,542 160-o 2215-436-460430-121 OVERTIME 49 300 251 840-o 2215-436-460430-153 HEALTH INSURANCE 58,360 67,983 9,623 140-o 2215-436-460430-155 RETIREMENT 28,013 27,932 81- -00-0 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 853 1,800 947 530-o 2215-436-460430-215 EQUIPMENT - not capital 5,109 7,000 1,891 27% 2215-436-460430-224 JANITORIAL SUPPLIES 4,247 6,000 1,753 29% 2215-436-460430-229 OTHER SUPPLIES 4,812 10,000 5,188 52% 2215-436-460430-231 GAS 15,435 15,500 65 0% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 1,956 3,500 1,544 44% 2215-436-460430-320 PRINTING & ADVERTISING 166 400 234 58% 2215-436-460430-341 ELECTRICITY 11,170 14,000 2,830 20% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 21,555 20,000 1,555- -8% 2215-436-460430-344 NATURAL GAS 2,257 2,500 243 10% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 1,939 3,600 1,661 46% 2215-436-460430-351 SPORTS COURT & BAND SHELL REHAB 6,765 9,000 2,235 25% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 2,000 2,000 0 0% 2215-436-460430-355 CONTRACT SERV. TRAIL MAINT/BRUSH HO 26,634 30,000 3,366 11% 2215-436-460430-356 TRAIL STUDY 0 30,000 30,000 100% 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 2,222 2,680 458 17% 2215-436-460430-358 FVCC TENNIS INTERLOCAL AGREEMENT 7,000 7,000 0 0% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 20,143 40,000 19,857 50% 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 10 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-364 LANDSCAPING 5,869 6,000 131 20-. 2215-436-460430-367 VANDALISM REPAIRS 3,476 4,000 524 130-o 2215-436-460430-373 DUES & TRAINING 7,253 8,000 747 90-0 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 232 400 168 420-o 2215-436-460430-395 EQUIPMENT RENTAL 155 1,400 1,245 890-0 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 3,828 5,000 1,172 230-o 2215-436-460430-440 IRRIGATION SUPPLIES 6,335 9,500 3,165 330-o 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 861 1,500 639 430-o 2215-436-460430-521 CENTRAL GARAGE TRANSFER 44,867 44,867 0 00-0 2215-436-460430-545 COUNTY LANDFILL 522 5,773 5,251 910-0 2215-436-460430-610 DEBT SERVICE PRINCIPAL 35,674 48,649 12,975 270-o 2215-436-460430-620 DEBT SERVICE INTEREST 4,717 7,001 2,284 330-o 2215-436-460430-932 PARK IMPROV - WOODLAND PLAYGROUND 97,772 100,000 2,228 20-o 2215-436-460430-941 SPRAY UNIT AND NEW USED TRUCK (FY 1 39,912 40,000 88 00-0 SUBTOTAL PARKS EXPENDITURES 854,495 981,576 127,081 130-o ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 101,079 106,149 5,070 50-o 2215-436-460440-111 SEASONAL SALARIES 38,596 41,904 3,308 80-0 2215-436-460440-121 OVERTIME 0 300 300 1000-0 2215-436-460440-153 HEALTH INSURANCE 25,350 31,767 6,417 200-o 2215-436-460440-155 RETIREMENT 9,871 9,714 157- -20-o 2215-436-460440-221 SAFETY EQUIPMENT 161 350 189 540-o 2215-436-460440-229 OTHER SUPPLIES 11,637 20,500 8,863 430-o 2215-436-460440-231 GAS 8,084 8,500 416 50-o 2215-436-460440-241 CONSUMABLE TOOLS 1,515 4,200 2,685 640-o 2215-436-460440-341 ELECTRICITY 7,270 9,500 2,230 230-o 2215-436-460440-345 TELEPHONE & COMMUNICATION 275 240 35- -150-o 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 1000-0 2215-436-460440-355 CONTRACT SERVICES - ASPHAT RESURFC 15,584 15,000 584- -40-o 2215-436-460440-362 EQUIPMENT MAINTENANCE 282 800 518 650-o 2215-436-460440-364 LANDSCAPING 57 600 543 910-0 2215-436-460440-367 VANDALISM REPAIRS 47 500 453 910-0 2215-436-460440-373 DUES & TRAINING 471 600 129 220-o 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 105 200 95 480-o 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 1000-0 2215-436-460440-420 METAL PRODUCTS 0 1,500 1,500 1000-0 2215-436-460440-440 IRRIGATION 3,436 6,000 2,564 430-o 2215-436-460440-452 SAND & GRAVEL 424 1,200 777 650-o 2215-436-460440-521 CENTRAL GARAGE TRANSFER 1,562 1,562 0- -00-0 2215-436-460440-545 COUNTY LANDFILL 0 3,400 3,400 1000-0 2215-436-460440-940 EQUIPMENT - MOWER & SLIT SEEDER 106,924 107,000 76 00-0 SUBTOTAL ATHLETIC COMPLEX ------------ ------------- 332,729 372,636 ------------ ------------ 39,907 110-0 RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 66,762 81,541 14,779 180-0 2215-436-460431-111 SEASONAL SALARIES 9,855 9,133 722- -80-0 2215-436-460431-153 HEALTH INSURANCE 12,479 21,601 9,122 420-o 2215-436-460431-155 RETIREMENT 5,253 7,005 1,752 250-o 2215-436-460431-229 MISC. SUPPLIES 8,302 11,110 2,808 250-o 2215-436-460431-231 GAS 429 780 351 450-o 2215-436-460431-320 PRINTING & ADVERTISING 6,206 12,265 6,059 490-o 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 11 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460431-345 TELEPHONE & COMMUNICATION 529 668 139 210-o 2215-436-460431-353 ON LINE REGISTRATION / CREDIT CARD 0 5,458 5,458 1000-0 2215-436-460431-354 CONTRACT SERVICES 23,839 22,205 1,634- -70-o 2215-436-460431-357 MUSIC FRANCHISE FEES 1,115 1,150 35 30-o 2215-436-460431-373 DUES & TRAINING 1,058 1,214 156 130-o SUBTOTAL RECREATION ------------ 135,828 ------------- 174,130 ------------ 38,302 ------------ 220-o YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 57,420 72,174 14,754 200-o 2215-436-460448-111 SEASONAL SALARIES 119,073 142,248 23,175 160-o 2215-436-460448-121 OVERTIME 366 150 216- -1440-o 2215-436-460448-153 HEALTH INSURANCE 11,659 20,771 9,112 440-o 2215-436-460448-155 RETIREMENT 4,514 6,584 2,070 310-o 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 0 450 450 1000-0 2215-436-460448-229 MISC. SUPPLIES 2,415 4,520 2,105 470-o 2215-436-460448-231 GAS 0 355 355 1000-0 2215-436-460448-320 PRINTING & ADVERTISING 82 345 263 760-o 2215-436-460448-345 TELEPHONE & COMMUNICATION 727 1,040 313 300-o 2215-436-460448-353 ON LINE REGISTRATION FEES 0 4,000 4,000 1000-0 2215-436-460448-354 CONTRACT SERVICES 11,989 12,870 881 70-o 2215-436-460448-355 AFTER SCHOOL PROGRAM 697 1,200 503 420-o 2215-436-460448-356 BANK FEES/CC CHARGES 3,985 6,000 2,015 340-o 2215-436-460448-373 DUES & TRAINING 508 812 304 370-o SUBTOTAL YOUTH CAMPS ------------ 213,436 ------------- 273,519 ------------ ------------ 60,083 220-o POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 168,253 182,210 13,957 80-0 2215-437-460445-121 OVERTIME 105 400 295 740-o 2215-437-460445-155 RETIREMENT 292 1,500 1,208 810-0 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 231 500 269 540-o 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,629 2,500 871 350-o 2215-437-460445-226 CHLORINE/CHEMICALS 26,415 27,500 1,085 40-o 2215-437-460445-228 CONCESSION STAND SUPPLIES 19,605 21,000 1,395 70-o 2215-437-460445-229 TOOLS/OTHER SUPPLIES 2,322 4,500 2,178 480-o 2215-437-460445-341 ELECTRICITY 7,504 9,500 1,996 210-o 2215-437-460445-344 NATURAL GAS 16,261 25,000 8,739 350-o 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 2,131 1,800 331- -180-0 2215-437-460445-354 LICENSES & FEES 776 1,300 524 400-o 2215-437-460445-356 BANK FEES/ CC CHARGES 2,027 3,000 973 320-o 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 17,789 17,350 439- -30-o 2215-437-460445-380 TRAINING MATERIALS 824 1,800 976 540-o SUBTOTAL POOL EXPENDITURES ------------ 266,164 ------------ ------------- 299,860 ------------- ------------ ------------ 33,696 110-0 ------------ ------------ TOTAL PARKS & RECREATION/POOL 1,802,652 ------------ ------------ 2,101,721 ------------- ------------- 299,069 140-o ------------------------ ------------------------ 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 12 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. URBAN FORESTRY 2600-436-460433-110 SALARIES -URBAN FORESTRY 170,004 187,275 17,271 90-. 2600-436-460433-111 SEASONAL SERVICES 16,994 29,856 12,862 430-o 2600-436-460433-121 OVERTIME 0 1,000 1,000 1000-0 2600-436-460433-153 HEALTH INSURANCE 32,255 56,796 24,541 430-o 2600-436-460433-155 RETIREMENT 13,446 16,510 3,064 190-0 2600-436-460433-229 OFFICE/OTHER SUPPLIES 281 600 319 530-o 2600-436-460433-231 GAS 6,775 6,000 775- -130-o 2600-436-460433-241 CONSUMABLE TOOLS 4,249 5,000 751 150-o 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 644 660 16 20-o 2600-436-460433-354 CONTRACT SERVICES 263,284 296,574 33,290 110-0 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 3,556 5,000 1,444 29% 2600-436-460433-362 EQUIPMENT MAINTENANCE 1,861 4,000 2,139 53% 2600-436-460433-364 LANDSCAPING & TREES 5,950 8,000 2,050 26% 2600-436-460433-373 DUES & TRAINING 2,151 4,000 1,849 46% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 1,911 1,863 48- -3% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 8,125 8,125 0- -0% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 10,380 10,380 0- 0% 2600-436-460433-528 DATA PROCESSING TRANSFER 4,780 4,780 0 0% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 16,530 16,530 0- 0% 2600-436-460433-620 INTEREST EXPENSE 1,788 1,920 132 7% 2600-436-460433-940 CHIPPER - FY17&18 / USED TRUCK FY19 20,000 20,000 0 0% TOTAL URBAN FORESTRY 584,965 684,869 99,904 15% ------------------------------------------------- ------------------------------------------------- 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 13 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 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 703,802 696,766 7,036- 2230-000-342070-000 COUNTY EMS LEVY 58,782 100,000 41,218 410-8 2230-000-383010-000 TRANSFER FROM GENERAL FUND 500,000 500,000 0 00-0 TOTAL AMBULANCE REVENUE ------------ 1,262,584 ------------ ------------ ------------- 1,296,766 ------------- ------------- ------------ 34,182 ------------ ------------ ------------ 30-o ------------ ------------ AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 637,348 656,047 18,699 30-o 2230-440-420730-114 COMPTIME BUYBACK 1,006 3,500 2,494 710-o 2230-440-420730-115 OUT OF RANK PAY 1,655 2,500 845 340-o 2230-440-420730-121 OVERTIME 30,616 30,000 616- -20-o 2230-440-420730-153 HEALTH INSURANCE 143,176 155,949 12,773 80-0 2230-440-420730-155 RETIREMENT 84,462 87,109 2,647 30-o 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 538 1,400 862 620-o 2230-440-420730-218 NON -CAPITAL EQUIPMENT 2,356 4,200 1,844 440-o 2230-440-420730-231 GAS & OIL 5,636 7,560 1,924 250-8 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 4,201 4,000 201- -50-o 2230-440-420730-312 POSTAGE/PRINTING 23 1,500 1,477 980-0 2230-440-420730-345 TELEPHONE & COMMUNICATION 1,313 1,700 387 230-o 2230-440-420730-354 CONTRACT SERVICES 9,556 19,990 10,434 520-o 2230-440-420730-355 911 CENTER CONTRIBUTION 35,020 35,020 0 00-0 2230-440-420730-359 AUDIT/CC OTHER FEES 2,471 1,650 821- -500-o 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 3,012 5,000 1,988 400-o 2230-440-420730-373 DUES & TRAINING 6,755 5,000 1,755- -350-o 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 1,525 2,500 975 390-o 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 38,434 49,749 11,315 230-o 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 35,351 34,487 864- -30-o 2230-440-420730-521 CENTRAL GARAGE TRANSFER 18,093 18,093 0- 00-0 2230-440-420730-522 ADMINISTRATIVE TRANSFER 55,862 55,862 0- 00-0 2230-440-420730-528 DATA PROCESSING TRANSFER 19,118 19,118 0- 00-0 2230-440-420730-940 EQUIPMENT 60,000 60,000 0 00-0 TOTAL AMBULANCE EXPENDITURES ------------ 1,197,527 ------------ ------------ ------------- ------------ 1,261,934 ------------------------- ------------------------- ------------ 64,407 ------------ ------------ 50-o 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 14 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2399 PUBLIC SAFETY IMPACT FEES 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 2399-413-420140-940 POLICE EQUIPMENT 2399-416-420400-940 FIRE DEPT. EQUIPMENT TOTAL PUBLIC SAFETY IMPACT FEE FIRE & HAZMAT GRANTS 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 2956-416-420415-940 AFG GRT FY19 SCBA TOTAL FIRE GRANTS 10, 000 10, 000 0 0 % 0 100,000 100,000 1000 0 750,000 750,000 1000 ------------------------------------------------- 10, 000 860,000 850,000 990 ------------------------------------------------- ------------------------------------------------- 6,000 5,000 1,000- -200-o 0 224,546 224,546 1000 ------------------------------------------------- 6, 000 229,546 223,546 970-o ------------------------------------------------- ------------------------------------------------- 2957-416-420410-125 PASS THRU HAZMAT OT 4,014 8,000 3,986 500-8 2957-416-420410-218 PASS THRU HAZMAT EQUIP 4,071 12,000 7,929 660-o 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 1,442 5,000 3,558 710-8 TOTAL HAZMAT GRANTS ------------ ------------- 9,526 ------------------------- ------------------------- ------------ 25,000 ------------ ------------ ------------ 15,474 620-o ------------ ------------ 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 15 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 456,204 600,000 143,796 240-8 2394-000-323103-000 PLUMBING PERMITS 35,852 21,000 14,852- -710-8 2394-000-323104-000 MECHANICAL PERMITS 52,236 30,000 22,236- -740-8 2394-000-323105-000 ELECTRICAL PERMITS 69,592 60,000 9,592- -160-o 2394-000-323108-000 PLAN REVIEW FEES 146,210 250,000 103,790 420-o 2394-000-371010-000 INVESTMENT EARNINGS 28,426 5,000 23,426- -4690-o TOTAL REVENUE ------------ ------------- 788,519 ------------------------- ------------------------- 966,000 ------------ ------------ 177,481 ------------------------ ------------------------ 180-0 BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 486,855 502,504 15,649 30-o 2394-420-420530-112 SALARIES -SEVERANCE 0 21,472 21,472 1000-0 2394-420-420530-121 OVERTIME 12,957 20,000 7,043 350-8 2394-420-420530-153 HEALTH INSURANCE 93,926 95,112 1,186 10-0 2394-420-420530-155 RETIREMENT 37,999 37,666 333- -10-0 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 18,511 36,000 17,489 490-8 2394-420-420530-231 GAS & OIL 3,206 4,500 1,294 290-o 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 5,963 7,300 1,337 180-0 2394-420-420530-323 ST. ED. ASSESSMENTS 1,663 7,500 5,837 780-8 2394-420-420530-345 TELEPHONE & COMMUNICATION 7,600 4,500 3,100- -690-o 2394-420-420530-353 AUDITING 4,500 4,500 0 00-0 2394-420-420530-354 CONTRACT SERVICES 9,510 20,000 10,490 520-o 2394-420-420530-355 CITY WORKS LICENSING FEE 18,199 25,000 6,801 270-8 2394-420-420530-356 ArcGIS SERVER UPGRADE LICENSE 2,500 3,000 500 170-8 2394-420-420530-357 CREDIT CARD / PAYPAL FEES 6,402 20,250 13,848 680-o 2394-420-420530-360 FURNITURE 8,511 9,000 489 50-8 2394-420-420530-373 DUES & TRAINING 29,118 30,000 882 30-o 2394-420-420530-510 PROPERTY INSURANCE 5,015 7,200 2,185 300-o 2394-420-420530-521 CENTRAL GARAGE TRANSFER 1,926 1,926 0 00-0 2394-420-420530-522 ADMINISTRATIVE TRANSFER 29,956 29,956 0- 00-0 2394-420-420530-528 DATA PROCESSING TRANSFER 33,457 33,457 0- 00-0 2394-420-420530-920 FY19 BUILDING IMPROVEMENT PROJECTS 14,196 35,000 20,804 590-8 2394-420-420530-944 VEHICLES - FY19 CARRYOVER 56,341 ------------ ------------- 0 56,341- ------------ ------------ 00-0 TOTAL BUILDING DEPT. 888,310 ------------------------- ------------------------- 955,843 67,533 ------------------------ ------------------------ 70-8 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 16 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 76,504 73,846 2,658- -40-. 2400-410-430263-153 HEALTH INSURANCE 11,382 21,714 10,332 480-8 2400-410-430263-155 RETIREMENT 5,787 5,521 266- -50-8 2400-410-430263-244 STREET LIGHT SUPPLIES 4,214 18,000 13,786 770-8 2400-410-430263-245 LUMINAIRES 1,819 30,000 28,181 940-8 2400-410-430263-246 LED LUMINAIRE UPGRADE 6,180 38,835 32,655 840-8 2400-410-430263-341 ELECTRICITY 142,496 182,000 39,504 220-o 2400-410-430263-360 REPAIR & MAINT SERVICES 8,067 20,000 11,933 600-o 2400-410-430263-510 INSURANCE 777 800 23 30-o 2400-410-430263-522 ADMINISTRATIVE TRANSFER 12,942 12,942 0- 00-0 TOTAL LIGHT MAINT. ------------ ------------- 270,168 ------------------------- ------------------------- 403,658 ------------ ------------ 133,490 330-o ------------------------ ------------------------ 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 36,682 101,365 64,683 640-8 2420-421-430234-957 ALLEY PAVING 12,820 40,000 27,180 680-o 2420-421-430240-231 GAS & OIL 34,191 40,000 5,809 150-8 2420-421-430240-344 NATURAL GAS 6,075 5,800 275- -50-8 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 1000-0 2420-421-430240-360 REPAIR & MAINT SERVICES 600 1,500 900 600-o 2420-421-430240-368 OVERLAY/CHIPSEALS 131,422 300,000 168,578 560-o 2420-421-430240-452 GRAVEL 1,316 5,000 3,684 740-8 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 1000-0 2420-421-430240-471 DE-ICER/ROAD OIL 54,586 45,000 9,586- -210-o 2420-421-430240-472 ASPHALT 33,058 50,000 16,942 340-8 2420-421-430240-473 CRACK SEALING 16,065 14,500 1,565- -110-0 2420-421-430240-474 PAINT STRIPING MATERIALS 9,595 30,000 20,405 680-o TOTAL GAS TAX ------------ ------------- 336,408 ------------------------- ------------------------- 658,165 ------------ ------------ 321,757 490-8 ------------------------ ------------------------ BARSAA (GAS TAX) 2421-421-430240-354 PAVEMENT MAINTENANCE TOTAL BARSAA 2825 MACI GRANT 2825-421-430240-940 SWEEPER TOTAL MACI GRANT 74,438 515,438 441,000 860-o ------------------------------------------------- 74,438 515,438 441,000 860-o ------------------------------------------------- ------------------------------------------------- 240,898 419,406 178,508 430-o ------------------------------------------------- 315,336 934,844 619,508 660-o ------------------------------------------------- ------------------------------------------------- 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 17 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 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. 734,483 776,609 42,126 50-8 2500-421-430240-121 OVERTIME 19,985 28,000 8,015 290-o 2500-421-430240-153 HEALTH INSURANCE 153,942 170,710 16,768 100-0 2500-421-430240-155 RETIREMENT 56,770 57,693 923 20-o 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 10,775 16,360 5,585 340-8 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 6,669 7,000 331 50-8 2500-421-430240-220 OTHER SUPPLIES 2,957 4,500 1,543 340-8 2500-421-430240-231 GAS & OIL 35,287 40,000 4,713 120-o 2500-421-430240-341 ELECTRICITY 2,387 3,500 1,113 320-o 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 1,812 1,500 312- -210-o 2500-421-430240-354 CONTRACT SERVICES 6,634 30,000 23,366 780-8 2500-421-430240-356 TRANSPORTATION PLAN 3,043 137,150 134,107 980-0 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 28,156 33,500 5,344 160-o 2500-421-430240-366 BUILDING MAINTENANCE 3,860 5,000 1,140 230-o 2500-421-430240-373 DUES & TRAINING 5,922 5,500 422- -80-0 2500-421-430240-388 MEDICAL SERVICES 355 1,000 645 650-8 2500-421-430240-510 LIABILITY INSURANCE 17,413 18,500 1,087 60-o 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 13,973 10,000 3,973- -400-8 2500-421-430240-521 CENTRAL GARAGE TRANSFER 200,052 200,052 0 00-0 2500-421-430240-522 ADMINISTRATIVE TRANSFER 98,967 98,967 0 00-0 2500-421-430240-528 DATA PROCESSING TRANSFER 14,339 14,339 0 00-0 2500-421-430240-610 DEBT RETRMNT-PU/PLOW TRK/BLDG CONST 35,539 35,621 82 00-0 2500-421-430240-620 INT.EXP-PU/PLOW TRK/BLDG CONST 836 1,119 283 250-8 2500-421-430240-840 MACI GRANT MATCH WTR/DE-ICER TRK FY 0 10,000 10,000 1000-0 2500-421-430240-922 SHOP ROOF AND INSULATION REPLACEMEN 49,900 45,000 4,900- -110-0 2500-421-430240-953 SHOP COMPLEX PAVEMENT RESTORATION 33,508 38,200 4,692 120-o 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 24,262 24,262 0- 00-0 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 14,644 14,644 0- 00-0 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 158,855 632,021 473,166 750-8 2500-421-430244-820 TRANSFER TO BARSAA 15,254 21,000 5,746 270-8 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 190,283 195,000 4,717 2% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 100% TOTAL STREET MAINT. 1,940,861 ------------ 2,704,575 ------------- 763,714 28% ----------------------- SIGNS AND SIGNALS 2500-421-430264-110 TSS - SALARIES 102,172 124,519 22,347 18% 2500-421-430264-121 OVERTIME 67 7,500 7,433 99% 2500-421-430264-153 HEALTH INSURANCE 27,476 26,794 682- -3% 2500-421-430264-155 RETIREMENT 7,633 9,177 1,544 17% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 2,676 2,500 176- -7% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 4,443 6,700 2,257 34% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 2,323 3,500 1,177 34% 2500-421-430264-242 STREET SIGNS 23,867 30,000 6,133 20% 2500-421-430264-243 TRAFFIC SIGNALS 7,060 20,000 12,940 65% 2500-421-430264-245 BARRICADE MATERIALS 3,696 5,500 1,804 33% 2500-421-430264-341 ELECTRICITY 1,653 3,000 1,347 45% 2500-421-430264-345 COMMUNICATIONS 664 850 186 22% 2500-421-430264-354 CONTRACT SERVICES 2,267 10,000 7,733 77% 2500-421-430264-362 EQUIPMENT MAINTENANCE 586 3,000 2,414 80% 2500-421-430264-366 BUILDING MAINTENANCE 1,936 3,000 1,064 35% 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 18 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2500-421-430264-373 DUES & TRAINING 5,736 6,000 264 40-8 2500-421-430264-428 PAINT MATERIALS 581 5,000 4,419 880-. 2500-421-430264-510 LIABILITY INS.-TSS 1,648 1,900 252 130-o 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 263 2,500 2,238 900-0 2500-421-430264-521 CENTRAL GARAGE TRANSFER 7,435 7,435 0- 00-0 2500-421-430264-532 OFFICE RENT 6,421 6,422 1 00-0 2500-421-430264-940 MACHINERY & EQUIPMENT 44,786 ------------ 51,000 ------------- 6,214 ------------ 120-o ------------ TOTAL SIGNS AND SIGNALS 255,387 ------------ 336,297 ------------- 80,910 ------------ 240-8 ------------ TOTAL STREET MAINT. & SIGNS 2,196,249 ------------ ------------ 3,040,872 ------------- ------------- 844,623 ------------ ------------ 280-o ------------ ------------ 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 19 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2188 WESTSIDE TIF REVENUE 2188-000-311100-000 REAL PROPERTY TAXES 5,677 60,000 54,323 910-0 2188-000-311200-000 PERSONAL PROPERTY TAXES 0 7,500 7,500 1000-0 2188-000-312000-000 PEN & INTEREST DEL. TAXES 231 350 119 340-8 2188-000-334200-000 MT DOC - ECONOMIC DESIGN PLN -TRAIL 10,000 0 10,000- 00-0 2188-000-335230-000 ENTITLEMENT SHARE PMT/SB96, 372 0 243,128 243,128 1000-0 2188-000-341015-000 DEVELOPER PMT-DEPOT PLACE APTS 0 8,000 8,000 1000-0 2188-000-365010-000 CONTRIBUTED CAPITAL 22,369 0 22,369- 00-0 2188-000-371010-000 INVESTMENT EARNINGS 28,291 ------------ 20,000 ------------- 8,291- ------------ ------------ -410-8 TOTAL REVENUE 66,568 ------------ ------------ 338,978 ------------- ------------- 272,410 ------------------------ ------------------------ 800-0 EXPENDITURES 2188-480-470230-110 SALARIES 44,094 44,335 241 10-0 2188-480-470230-153 HEALTH INSURANCE 8,396 8,701 305 40-8 2188-480-470230-155 RETIREMENT 3,500 3,508 8 00-0 2188-480-470230-353 AUDIT 3,000 3,000 0 00-0 2188-480-470230-356 TELEPHONE 192 192 0 00-0 2188-480-470230-522 ADMINISTRATIVE TRANSFER 4,000 4,000 0 00-0 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 1,043,622 900,000 143,622- -160-o 2188-480-470230-840 TRANSFER TO DEBT SERVICE 3188 140,000 140,000 0 00-0 2188-480-470440-930 CITY MATCH - TRAIL 38,992 100,000 61,008 610-o 2188-480-470440-935 CITY MATCH - RAIL PARK 389,207 500,000 110,793 220-o TOTAL WESTSIDE TIF ------------ 1,675,003 ------------ ------------ ------------- 1,703,736 ------------- ------------- ------------ ------------ 28,733 ------------------------ ------------------------ 20-o 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 20 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 2185-000-430300-522 ADMINISTRATIVE TRANSFER 2185-000-430300-840 REDEVELOPMENT ACTIVITY 2185-480-470240-110 SALARIES 2185-480-470240-153 HEALTH INSURANCE 2185-480-470240-155 RETIREMENT 2185-480-470240-345 TELEPHONE & COMMUNICATION TOTAL 2185 AIRPORT TIF OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 2310-480-470210-356 FED -EX REIMBURSEMENT 2310-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 2311-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC TOTAL OLD SCHOOL TIFS 1,600 1,600 0 00-. 9,503 9,503 0- 00-. 95,452 2,500,000 2,404,548 960-. 20,567 20,501 66- -00-. 4,521 5,018 497 100-0 1,634 1,630 4- -00-0 48 48 0 0% ------------ 133,325 ------------ ------------ ------------- 2,538,300 ------------- ------------- ------------------------ 2,404,975 ------------------------ ------------------------ 950-o 10,092 11,000 908 80-0 9,572 10,500 928 90-0 55,000 55,000 0 00-0 10,000 10,000 0 00-0 ------------ 84,664 ------------ ------------ ------------- 86,500 ------------- ------------- ------------------------ 1,836 ------------------------ ------------------------ 20-o 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 21 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 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 00-. 2880-480-470210-354 CONTRACT SERVICES 501 1,000 499 500-8 2880-480-470210-711 REDEVELOPMENT 0 175,000 175,000 1000-0 TOTAL LOAN REVOLVING ------------ 1,501 ------------ ------------ ------------- 177,000 ------------- ------------- ------------ 175,499 ------------ ------------ ------------ 990-0 ------------ ------------ 2881 CD LOAN REV. #2 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 2881-480-470210-711 REDEVELOPMENT 2886-480-470210-210 2886-480-470210-353 2886-480-470210-373 2886-480-470210-379 2886-480-470210-396 2886-480-470210-522 2886-480-470210-528 2886-480-470210-532 2886-480-470210-620 2886-480-470210-790 2886-480-470210-795 2887-480-470210-354 2887-480-470210-610 2887-480-470210-620 2887-480-470210-750 2888-480-470210-354 2888-480-470210-610 2888-480-470210-620 2888-480-470210-750 TOTAL 2881 CD REV. #2 2886 CD MISC. OFFICE SUPPLIES AUDITING DUES & TRAINING MEETINGS STUDIES/SURVEYS & MARKETING ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER OFFICE RENT INTEREST - OLD SCHOOL LOAN - GENERA REDEVELOPMENT ACTIVITY REDEVELOPMENT- OLD SCHOOL STATION TOTAL CD MISC. 2887 RURAL DEVELOPMENT #1 CONT SERV (LOAN SOFTWARE) DEBT SERVICE/PRIN-L#61-01 INTEREST EXPENSE/L#61-01 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT #1 2888 RURAL DEVELOPMENT #2 CONT SERV (LOAN SOFTWARE) DEBT SERVICE/PRIN-L#61-03 INTEREST EXPENSE -USDA LOAN 61-03 REDEVELOPMENT LOANS TOTAL RURAL DEVELOPMENT #2 405 0 405- 00-. 0 240,000 240,000 1000-0 ------------------------- 405 ------------------------- ------------------------- 240,000 ------------------------ 239,595 ------------------------ ------------------------ 1000-0 0 2,000 2,000 1000-0 1,000 1,000 0 00-0 0 2,000 2,000 1000-0 0 1,000 1,000 1000-0 0 5,000 5,000 1000-0 2,000 2,000 0 00-0 9,559 9,559 0- 00-0 647 1,175 528 450-8 0 48,750 48,750 1000-0 1,400 3,750 2,350 630-o 18,564 165,000 146,436 890-0 ------------------------- 33,170 ------------------------- ------------------------- 241,234 ------------------------ 208,064 ------------------------ ------------------------ 860-o 408 0 408- 00-0 18,639 18,639 0- 00-0 3,435 3,435 0 00-0 0 ------------------------- 300,000 300,000 ------------------------ 1000-0 22,482 ------------------------- ------------------------- 322,074 299,593 ------------------------ ------------------------ 930-o 408 0 408- 00-0 8,301 8,301 0- 00-0 1,724 1,724 0 00-0 0 250,000 250,000 1000-0 ------------------------- 10,433 ------------------------- ------------------------- 260,025 ------------------------ 249,593 ------------------------ ------------------------ 960-o 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 22 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2953 EPA BROWNFIELDS 2953-480-470210-354 CONT SERV/PETROLEUM 0 185,592 185,592 1000-0 2953-480-470210-373 TRAVEL/PETROLEUM 449 2,392 1,943 810-0 2953-480-470215-354 CONT SERV/HAZARDOUS 130,836 178,344 47,508 270-8 2953-480-470215-373 TRAVEL/HAZARDOUS 594 2,552 1,958 770-8 TOTAL EPA BROWNSFIELD ------------ 131,879 ------------ ------------ ------------- 368,880 ------------- ------------- ------------ ------------ 237,001 ------------------------ ------------------------ 640-8 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES -PETROLEUM 0 908 908 1000-0 2955-480-470210-352 PERSONNEL -PETROLEUM 0 3,505 3,505 1000-0 2955-480-470210-353 FRINGES -PETROLEUM 0 493 493 1000-0 2955-480-470210-354 CONTRACTED SERVICES-PETROLUEM 0 1,488 1,488 1000-0 2955-480-470210-720 CLEANUP LOANS -PETROLEUM 0 62,354 62,354 1000-0 2955-480-470210-721 CLEANUP SUBGRANTS-PETRO 0 100,000 100,000 1000-0 2955-480-470210-725 REVOLVED FUNDS -PETROLEUM 0 100,500 100,500 1000-0 2955-480-470215-229 SUPPLIES -HAZARDOUS SUBSTANCES 0 1,158 1,158 1000-0 2955-480-470215-354 CONTRACT SERV-HAZARDOUS SUBST 0 88 88 1000-0 2955-480-470215-373 TRAVEL -HAZARDOUS SUBTSANCE 0 2,330 2,330 1000-0 2955-480-470215-720 CLEANUP LOANS -HAZARDOUS 0 314,600 314,600 1000-0 TOTAL BROWNFIELDS LOAN REV. ------------ 0 ------------ ------------ ------------- 587,424 ------------- ------------- ------------ ------------ 587,424 ------------------------ ------------------------ 1000-0 2991 TIGER GRANT 2991-480-470245-790 REDEVELOPMENT - TRAIL 0 3,803,909 3,803,909 1000-0 TOTAL TIGER GRANT ------------ 0 ------------ ------------ ------------- 3,803,909 ------------- ------------- ------------ ------------ 3,803,909 ------------------------ ------------------------ 1000-0 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 23 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD 0 20,000 20,000 1000-0 2915-413-420140-218 SMALL EQUIP -Stonegarden 0 40,000 40,000 1000-0 2915-413-420140-354 CONT SERV-WPD/MFWPE - STONEGARDEN 5,218 60,000 54,782 910-0 ------------ TOTAL 2915 STONEGARDEN GRANT ------------ ------------ ------------- 5,218 ------------- ------------- 120,000 ------------ ------------ 114,782 ------------------------ ------------------------ 960-o 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 61,609 64,857 3,248 50-o 2916-413-420140-121 OVERTIME 13,409 7,500 5,909- -790-o 2916-413-420140-153 HEALTH INSURANCE 10,184 8,453 1,731- -200-o 2916-413-420140-155 RETIREMENT 8,057 8,710 653 80-0 2916-413-420140-354 CONTRACT SERVICES 5,719 6,000 281 50-o ------------ TOTAL 2916 DRUG ENFORCEMENT ------------ ------------ ------------- 98,978 ------------- ------------- 95,520 ------------ ------------ 3,458- ------------------------ ------------------------ -40-o 2918 CHRP GRANT 2918-413-420140-110 SALARIES & PAYROLL COSTS 45,000 60,500 15,500 260-o 2918-413-420140-153 HEALTH INSURANCE 9,688 8,968 720- -80-0 2918-413-420140-155 RETIREMENT 5,922 7,901 1,979 250-o ------------ TOTAL CHRP GRANT ------------ ------------ ------------- 60,610 ------------- ------------- 77,369 ------------ ------------ 16,759 ------------------------ ------------------------ 220-o 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 2,761 4,000 1,239 310-o 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 28,642 36,000 7,358 200-o 2919-413-420140-127 SCHOOL DIST. OT 15,289 20,000 4,711 240-o 2919-413-420140-218 JAG GRT/RADIOS & TRAINING 11,512 12,000 488 40-o 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 578 4,000 3,422 860-o 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 0 7,000 7,000 1000-0 ------------ TOTAL LAW ENF. GRANT ------------ ------------ ------------- 58,781 ------------- ------------- 83,000 ------------ ------------ 24,219 ------------------------ ------------------------ 290-o 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 24 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CAPITAL PROJECT FUNDS 4188 TIGER RAIL/TRAIL CONSTRUC 4188-480-470440-935 GLACIER RAIL PARK CONSTRUCTION TOTAL 4188 TIGER RAIL/TRAIL CO 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION TOTAL 4290 WALK & CURB 3,352,632 3,352,632 0 00-. ------------------------------------------------- 3,352,632 3,352,632 0 00-. ------------------------------------------------- ------------------------------------------------- 7,145 25,000 17,855 710-8 ------------------------------------------------- 7,145 25,000 17,855 710-8 ------------------------------------------------- ------------------------------------------------- 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 25 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 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 1,485 0 1,485- 00-. 5210-000-343210-000 METERED WATER SALES 3,193,048 2,900,000 293,048- -100-0 5210-000-343220-000 UNMETERED WATER SALES 28,014 10,000 18,014- -1800-0 5210-000-343225-000 IMPACT FEES 793,211 500,000 293,211- -590-8 5210-000-343230-000 METER REPLACEMENT FEE 102,938 98,000 4,938- -50-8 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 62,195 50,000 12,195- -240-8 5210-000-343270-000 WATER TURN ON FEES 5,955 5,000 955- -190-0 5210-000-343275-000 TAG FEE 48,320 55,000 6,680 120-o 5210-000-343365-000 LATECOMER ADMIN FEE 6,090 0 6,090- 00-0 5210-000-371010-000 INVESTMENT EARNINGS 171,180 100,000 71,180- -710-8 5210-000-381050-000 INCEPTION OF LEASE (FOR BUDGET ONLY 0 3,675,000 3,675,000 1000-0 TOTAL WATER REVENUE 4,412,436 ------------ ------------ 7,393,000 ------------- ------------- 2,980,564 400-8 ------------------------ ------------------------ WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 645,031 739,728 94,697 130-o 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 1000-0 5210-447-430550-121 OVERTIME 11,489 20,000 8,511 430-o 5210-447-430550-153 HEALTH INSURANCE 127,706 165,884 38,178 230-o 5210-447-430550-155 RETIREMENT 49,569 55,082 5,513 100-0 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 9,684 22,000 12,316 560-o 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 7,603 8,500 897 110-0 5210-447-430550-226 CHLORINE & CHEMICALS 25,573 39,000 13,427 340-8 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 2,364 4,500 2,136 470-8 5210-447-430550-231 GAS & OIL 20,654 35,000 14,346 410-8 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 684 1,000 316 320-o 5210-447-430550-336 LICENSES & FEES 16,318 18,500 2,182 120-o 5210-447-430550-341 ELECTRICITY 134,770 158,000 23,230 150-8 5210-447-430550-344 NATURAL GAS 9,713 15,500 5,787 370-8 5210-447-430550-345 TELEPHONE & COMMUNICATION 10,862 10,500 362- -30-o 5210-447-430550-349 LAB SERVICES 8,335 20,000 11,665 580-8 5210-447-430550-353 AUDITING 3,500 5,000 1,500 300-o 5210-447-430550-354 CONTRACT SERVICES 24,552 55,000 30,448 550-8 5210-447-430550-356 CONSULTANTS FACILITY PLAN 8,732 105,000 96,268 920-o 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 2,214 15,000 12,786 850-8 5210-447-430550-366 BUILDING MAINTENANCE 3,510 12,000 8,490 710-8 5210-447-430550-373 DUES & TRAINING 3,514 9,000 5,486 610-o 5210-447-430550-388 MEDICAL SERVICES 213 600 388 650-8 5210-447-430550-410 CONSTRUCTION MATERIALS 26,435 35,000 8,565 240-8 5210-447-430550-422 HYDRANTS 5,725 10,000 4,275 430-o 5210-447-430550-423 MATERIALS FOR MAINS 2,463 14,000 11,537 820-o 5210-447-430550-424 MATERIALS -SERVICE LINES 10,437 12,000 1,563 130-o 5210-447-430550-425 MATERIALS PUMPS/WELLS 9,545 45,000 35,455 790-8 5210-447-430550-510 PROPERTY & LIABILITY INS. 20,622 21,500 878 40-8 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 418 10,000 9,582 960-o 5210-447-430550-521 CENTRAL GARAGE TRANSFER 21,977 21,977 0- 00-0 5210-447-430550-522 ADMINISTRATIVE TRANSFER 109,988 109,988 0 00-0 5210-447-430550-528 DATA PROCESSING TRANSFER 33,457 33,457 0- 00-0 5210-447-430550-532 LEASE PAYMENTS 6,421 10,500 4,079 390-o 5210-447-430550-935 NOFFSINGER TRANSMISSION CONDITION A 0 250,000 250,000 1000-0 5210-447-430550-939 FOUR MILE TRANSMISSION MAIN (PHASE 0 3,500,000 3,500,000 1000-0 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 26 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 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 300-. 5210-447-430550-948 METERS (METER FUNDS) 010125 65,737 110,000 44,263 400-o 5210-447-430550-950 1ST AVE WN 220,890 620,000 399,110 640-o 5210-447-430550-951 SECURITY SCADA UPGRADES 0 50,000 50,000 1000-0 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 33,546 38,200 4,654 120-o 5210-447-430550-959 PARKS METERING PHASE II 25,977 22,337 3,640- -160-o 5210-447-430550-962 9TH AVE WEST WATER MAIN REPLACEMENT 73,503 467,483 393,980 840-o 5210-447-430550-963 8TH STREET WEST WATER MAIN REPLACEM 495,559 413,319 82,240- -200-o 5210-447-430550-968 CONRAD DRIVE 113,489 360,000 246,511 680-o 5210-447-430555-930 CONTRACT MAIN UPSIZE 0 320,254 320,254 1000-0 5210-447-430555-939 FOUR MILE TRANSMISSION MAIN (PHASE 38,052 262,000 223,948 850-o 5210-447-430555-941 METERS (NEW SERVICES)010120 45,600 45,600 0 00-0 5210-447-430555-953 SECTION 36 WELL 1,217,778 1,402,231 184,453 130-o SUBTOTAL WATER FACILITIES ------------ 3,718,158 ------------ ------------- 9,724,640 ------------- ------------ 6,006,482 ------------ ------------ 620-o ------------ WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 107,811 113,806 5,995 50-8 5210-447-430560-153 HEALTH INSURANCE 30,391 28,181 2,210- -80-0 5210-447-430560-155 RETIREMENT 8,457 8,813 356 40-8 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 4,437 3,500 937- -270-8 5210-447-430560-353 AUDITING 2,000 2,000 0 00-0 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 40,688 40,000 688- -20-o 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 22,726 25,000 2,274 90-0 5210-447-430560-356 OTHER CONTRACT SERVICES 465 2,500 2,035 810-0 5210-447-430560-373 DUES & TRAINING 2,281 2,500 219 90-0 5210-447-430560-522 ADMINISTRATIVE TRANSFER 11,289 11,289 0- 00-0 5210-447-430560-528 DATA PROCESSING TRANSFER 33,457 33,457 0- 00-0 5210-447-430560-532 RENT 6,421 6,422 1 00-0 ------------ SUBTOTAL WATER BILLING ------------ ------------- 270,425 ------------- 277,468 ------------ ------------ 7,043 ------------ ------------ 30-o REVENUE BONDS 5210-447-490204-610 BOND PRIN-HWY 93 S WTR-2004 0 70,000 70,000 1000-0 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 22,793 22,793 1 00-0 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 350 350 0 00-0 5210-447-490206-610 PRIN-WELL/TANK/8114 2.25% 4TH ST 0 87,000 87,000 1000-0 5210-447-490206-620 INT-WELL&TANK/8114 2.25% 4TH ST WT 18,799 18,799 0 00-0 5210-447-490210-610 4TH AVE E MAIN REPL/WRF 17393 0 77,901 77,901 1000 5210-447-490210-620 4TH AVE E MAIN REPL/WFR 17393 47,019 47,019 0 00-0 5210-447-490250-610 PRIN-WTR MAIN/WRF1032R 2%/IDAHO&MAI 0 50,000 50,000 1000 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2%/IDAHO&MAIN 2,270 2,270 0 00-0 ------------ SUBTOTAL REVENUE BONDS ------------ ------------- 91,230 ------------- 376,132 ------------ ------------ 284,902 ------------------------ 760-o DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 840,000 840,000 1000 ------------ SUBTOTAL DEPRECIATION ------------ ------------- 0 ------------- 840,000 ------------------------ 840,000 ------------------------ 1000 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 27 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. TOTAL WATER FUND 4,079,813 11,218,240 7,138,427 640 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 28 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 1,485 0 1,485- 00-. 5310-000-343310-000 SEWER SERVICE CHARGES 4,571,438 4,500,000 71,438- -20-. 5310-000-343330-000 IMPACT FEES (SANITARY) 1,015,348 600,000 415,348- -690-. 5310-000-343335-000 IMPACT FEES (WWTP) 652,712 350,000 302,712- -860-. 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 3,595 10,000 6,405 640-o 5310-000-343365-000 LATECOMER ADMIN FEES 10,672 0 10,672- 00-0 5310-000-371010-000 INVESTMENT EARNINGS 157,940 100,000 57,940- -580-o 5310-000-381030-000 BOND PROCEEDS /SRF/DIGESTER LID WWT 209,531 0 209,531- 00-0 5310-000-381050-000 INCEPTION OF LEASE 0 14,003,470 14,003,470 1000-0 TOTAL SEWER REVENUE 6,622,721 ------------ ------------ 19,563,470 ------------- ------------- 12,940,749 ------------------------ ------------------------ 660-o SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 93,349 96,132 2,783 30-o 5310-454-430620-153 HEALTH INSURANCE 23,186 22,864 322- -10-0 5310-454-430620-155 RETIREMENT 7,308 7,426 118 20-o 5310-454-430620-215 OFFICE SUPPLIES/COMPUTERS 4,376 3,500 876- -250-o 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 2,000 2,000 0 00-0 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 40,689 40,000 689- -20-o 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 22,726 25,000 2,274 90-0 5310-454-430620-356 OTHER CONTRACT SERVICES 465 2,500 2,035 810-0 5310-454-430620-373 DUES & TRAINING 2,177 2,500 323 130-o 5310-454-430620-522 ADMINISTRATIVE TRANSFER 10,385 10,385 0- 00-0 5310-454-430620-528 DATA PROCESSING TRANSFER 33,457 33,457 0- 00-0 5310-454-430620-532 OFFICE RENT 6,421 6,422 1 00-0 SUBTOTAL SEWER BILLING COSTS ------------ 246,539 ------------ ------------- 252,186 ------------- ------------ ------------ 5,647 ------------ ------------ 20-o SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 244,023 283,430 39,407 140-o 5310-454-430630-121 OVERTIME 367 5,500 5,133 930-o 5310-454-430630-153 HEALTH INSURANCE 57,314 71,186 13,872 190-0 5310-454-430630-155 RETIREMENT 18,619 21,197 2,578 120-o 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 7,688 12,200 4,512 370-o 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 7,322 8,350 1,028 120-o 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 1,696 2,300 604 260-o 5310-454-430630-231 GAS & OIL 8,538 12,000 3,462 290-o 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 444 500 56 110-0 5310-454-430630-341 ELECTRICITY 44,894 55,000 10,106 180-0 5310-454-430630-344 NATURAL GAS 12,888 16,500 3,612 220-o 5310-454-430630-345 TELEPHONE & COMMUNICATION 23,724 25,000 1,276 50-o 5310-454-430630-353 AUDITING 3,000 3,000 0 00-0 5310-454-430630-354 CONTRACT SERVICES 19,000 24,000 5,000 210-o 5310-454-430630-356 CONSULTANTS - FACILITY PLAN 141,060 335,000 193,940 580-o 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 4,836 7,000 2,164 310-o 5310-454-430630-373 DUES & TRAINING 2,524 5,500 2,976 540-o 5310-454-430630-388 MEDICAL SERVICES 424 500 77 150-o 5310-454-430630-410 CONSTRUCTION MATERIALS 6,718 10,000 3,282 330-o 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 43,088 50,000 6,912 140-o 5310-454-430630-510 PROPERTY & LIABILITY INS. 22,601 18,400 4,201- -230-o 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 29 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 0 25,000 25,000 1000-0 5310-454-430630-521 CENTRAL GARAGE TRANSFER 10,133 10,133 0 00-0 5310-454-430630-522 ADMINISTRATIVE TRANSFER 59,359 59,359 0 00-0 5310-454-430630-528 DATA PROCESSING TRANSFER 19,118 19,118 0- 00-0 5310-454-430630-532 OFFICE RENT 6,421 6,422 1 00-0 5310-454-430630-940 MACHINERY & EQUIPMENT 52,070 50,000 2,070- -40-8 5310-454-430630-948 REPAIR & REPLC OF SEWER MAIN 0 600,000 600,000 1000-0 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 33,513 38,200 4,687 120-o 5310-454-430630-954 GRANDVIEW L.S. RELOCATOON & UPSIZE 615 579,536 578,921 1000-0 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 13,641 20,000 6,359 320-o 5310-454-430630-957 WEST SIDE INTERCEPTOR PHASE I 10,649,360 13,490,000 2,840,640 210-o 5310-454-430630-959 SEWER LINE A REPLACEMENT PROD. 230,949 556,395 325,446 580-8 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 14,990 50,000 35,010 700-8 5310-454-430630-962 SEWER MAIN SLIP LINING 173,506 194,348 20,842 110-0 SUBTOTAL SEWER COLLECTION ------------ 11,934,442 ------------ ------------- 16,665,074 ------------- ------------ 4,730,632 ------------ ------------ 280-o ------------ IMPACT FEES 5310-454-430635-954 GRANDVIEW L.S. RELOCATION & UPSIZE 5310-454-430635-955 SEWER MAIN/LIFT ST. UPSIZE 5310-454-430635-957 WEST SIDE INTERCEPTOR SUBTOTAL IMPACT FEE EXPENSE REVENUE BONDS/SANITARY 5310-454-490200-610 PRINCIPAL-WESTSIDE INTERCEPTOR BOND 5310-454-490200-620 INTEREST-WESTSIDE INTERCEPTOR BOND 5310-454-490200-630 FISCAL AGENT FEE-WESTSIDE INTERCEPT 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.25% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25% SUBTOTAL REVENUE BONDS DEPRECIATION -SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 5310-455-430640-110 5310-455-430640-111 5310-455-430640-112 5310-455-430640-121 5310-455-430640-153 5310-455-430640-155 5310-455-430640-210 SUBTOTAL DEPRECIATION -SANITARY SUBTOTAL SANITARY SEWER 615 579,536 578,921 1000-0 105,680 310,000 204,320 660-. 641,168 682,347 41,179 60-. ------------ 747,463 ------------ ------------- 1,571,883 ------------- ------------------------ 824,420 520-o ------------------------ 0 119,528 119,528 1000-0 196,553 200,000 3,447 20-o 0 350 350 1000-0 0 85,000 85,000 1000 11,633 11,633 1 00-0 0 350 350 1000 ------------ 208,186 ------------ ------------- 416,861 ------------- ------------------------ 208,675 500-8 ------------------------ 0 820,000 820,000 1000 ------------ 0 ------------ ------------- 820,000 ------------- ------------------------ 820,000 1000 ------------------------ 121890,091 ------------ 19,473,818 ------------- 6,583,727 340-8 ------------ ------------ WWTP/OPERATIONS SALARIES-WWTP 411,609 456,093 44,484 100 SEASONAL SALARIES 0 5,000 5,000 1000 SALARIES -RETIREMENT 31,633 42,317 10,684 250-8 OVERTIME 19,039 22,500 3,461 150-8 HEALTH INSURANCE 81,837 89,087 7,250 80-0 RETIREMENT 32,819 33,891 1,072 30-o OFFICE/COMPUTER SUPPLIES/EQUIP 9,265 10,000 735 70-8 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 30 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 2,780 2,700 80- -30-. 5310-455-430640-225 ALUM 19,776 20,000 224 10-. 5310-455-430640-226 CHLORINE & CHEMICALS 90,001 80,000 10,001- -130-o 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 5,320 7,000 1,680 240-o 5310-455-430640-231 GAS & OIL 11,595 16,000 4,405 280-o 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 19 400 381 950-o 5310-455-430640-336 LICENSES & FEES 6,668 11,500 4,832 420-o 5310-455-430640-341 ELECTRICITY 171,299 182,000 10,701 60-o 5310-455-430640-342 WATER 4,401 7,500 3,099 410-o 5310-455-430640-344 NATURAL GAS 64,579 60,000 4,579- -80-0 5310-455-430640-345 TELEPHONE & COMMUNICATION 6,012 6,500 488 80-0 5310-455-430640-353 AUDITING 2,500 4,000 1,500 380-o 5310-455-430640-354 CONTRACT -GLACIER GOLD 114,612 124,000 9,388 80-0 5310-455-430640-355 OTHER CONTRACT SERVICES 41,536 30,000 11,536- -380-o 5310-455-430640-356 CONSULTANTS 38,045 77,500 39,455 510-o 5310-455-430640-358 CONSULTANT-TMDL 89,096 185,000 95,904 520-o 5310-455-430640-360 MISC. MAINT SERVICES 27,933 30,000 2,067 70-o 5310-455-430640-366 BUILDING MAINTENANCE 40,005 40,000 5- -00-0 5310-455-430640-373 DUES & TRAINING 7,276 7,500 224 30-o 5310-455-430640-388 MEDICAL SERVICES 198 500 303 610-o 5310-455-430640-510 PROPERTY & LIABILITY INS. 37,449 37,343 106- -00-0 5310-455-430640-521 CENTRAL GARAGE TRANSFER 22,489 22,489 0- 00-0 5310-455-430640-522 ADMINISTRATIVE TRANSFER 117,270 117,270 0 00-0 5310-455-430640-528 DATA PROCESSING TRANSFER 23,898 23,898 0 00-0 5310-455-430640-920 BUILDINGS 28,588 32,000 3,412 110-0 5310-455-430640-930 BIOSOLIDS ALTERNATE DISPOSAL ENG 4,948 183,000 178,052 970-o SUBTOTAL WWTP OPERATIONS 1,564,492 1,966,988 402,496 200-o WWTP BONDED PROJECT ------------ ------------- ------------------------ 5310-455-430644-930 BIOSOLIDS ALTERNATE DISPOSAL ENG 3,163 117,000 113,837 970-o SUBTOTAL WWTP BONDED ------------ 3,163 ------------- 117,000 ------------ ------------ 113,837 970-o WWTP REPLACEMENT ------------ ------------- ------------------------ 5310-455-430645-362 EQUIPMENT MAINTENANCE 90,479 100,000 9,521 100-0 5310-455-430645-921 E. SECONDARY CLARIFIER COATING PRJ 0 60,000 60,000 1000-0 5310-455-430645-934 SECONDARY DIGESTER LID INSPECTION 744,350 1,388,991 644,641 460-o 5310-455-430645-937 SAND FILTER MAINT & REPLACEMENT 0 100,000 100,000 1000-0 5310-455-430645-940 MACHINERY & EQUIPMENT 91,389 97,000 5,611 60-o SUBTOTAL WWTP REPLACEMENT ------------ 926,219 ------------ ------------- 1,745,991 ------------- ------------ ------------ 819,772 ------------------------ 470-o WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 108,965 110,917 1,952 20-o 5310-455-430646-121 OVERTIME 231 0 231- 00-0 5310-455-430646-153 HEALTH INSURANCE 16,392 17,608 1,216 70-o 5310-455-430646-155 RETIREMENT 8,258 8,161 97- -10-0 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 2,287 4,500 2,213 490-o 5310-455-430646-218 NON -CAPITAL EQUIPMENT 1,890 2,500 610 240-o 5310-455-430646-222 LAB SUPPLIES 10,818 16,500 5,682 340-o 5310-455-430646-349 LAB SERVICES 14,877 30,000 15,123 500-o 5310-455-430646-362 EQUIPMENT MAINTENANCE 3,988 5,500 1,512 280-o 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 31 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 5310-455-430646-373 DUES & TRAINING 1,759 3,700 1,941 520-o ------------ ------------- ------------ ------------ SUBTOTAL WWTP LAB OPERATIONS 169,464 199,386 29,922 150-8 DEBT SERVICE - WWTP 5310-455-490227-610 PRIN-WWTP IMP/SRF8164R/2.25% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 5310-455-490228-610 PRIN/WWTP DIGESTER LID/SRF13326/3.0 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% SUBTOTAL DEBT SERVICE - WWTP CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-830 EVERGREEN REPLACEMENT TRANSFER 5310-455-510400-831 DEPRECIATION EXPENSE SUTOTAL WWTP DEPRECIATION/REPL SUBTOTAL WWTP TOTAL BILLING/SANITARY/WWTP 0 832,000 832,000 1000 179,978 179,978 1 00-0 0 47,000 47,000 1000 25,935 25,935 0 00-0 ------------------------------------------------- 205, 913 1,084,913 879,001 810 ------------------------------------------------- 0 420,000 420,000 1000 0 1,425,000 1,425,000 1000 ------------------------------------------------- 0 1,845,000 1,845,000 1000 ------------------------------------------------- 21869,250 6,959,278 4,090,028 590-8 ------------------------------------------------- 16, 005,880 26,685,282 10,679,402 400-8 ------------------------------------------------- ------------------------------------------------- 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 32 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 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 1,485 0 1,485- 00-. 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 465 1,500 1,035 690-. 5349-000-343033-000 IMPACT FEES 267,216 200,000 67,216- -340-o 5349-000-343034-000 PERMIT FEES 2,194 0 2,194- 00-0 5349-000-343035-000 STORM SEWER CHARGES 0 1,000 1,000 1000-0 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 1,483,087 1,390,000 93,087- -70-o 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 3,175 1,500 1,675- -1120-o 5349-000-371010-000 INTEREST ON INVESTMENTS 64,300 25,000 39,300- -1570-o TOTAL STORM REVENUE 1,821,922 ------------ ------------ 1,619,000 ------------- ------------- 202,922- -130-o ------------------------ ------------------------ STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 434,822 451,922 17,100 40-o 5349-453-430246-121 OVERTIME 490 4,000 3,510 880-0 5349-453-430246-153 HEALTH INSURANCE 85,430 97,880 12,450 130-o 5349-453-430246-155 RETIREMENT 33,170 33,856 686 20-o 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 12,382 16,100 3,718 230-o 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 3,468 6,550 3,082 470-o 5349-453-430246-229 OTHER SUPPLIES/TOOLS 1,893 2,200 307 140-o 5349-453-430246-231 GAS & OIL 7,886 11,500 3,614 310-o 5349-453-430246-345 TELEPHONE & COMMUNICATION 2,134 1,000 1,134- -1130-o 5349-453-430246-353 AUDITING 1,150 1,150 0 00-0 5349-453-430246-354 CONTRACT SERVICE 4,479 7,000 2,521 360-o 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 7,451 135,000 127,549 940-o 5349-453-430246-358 CONSULTANTS 3,594 10,000 6,406 640-o 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 0 15,000 15,000 1000-0 5349-453-430246-360 REPAIR & MAINT SERVICES 584 2,500 1,916 770-o 5349-453-430246-362 GROUNDWATER MONITORING 465 4,000 3,535 880-0 5349-453-430246-371 CURB & GUTTER 380 7,000 6,620 950-o 5349-453-430246-373 DUES & TRAINING 2,047 5,500 3,453 630-o 5349-453-430246-388 MEDICAL SERVICES 58 100 42 420-o 5349-453-430246-410 CONSTRUCTION MATERIALS 204 10,000 9,796 980-0 5349-453-430246-510 PROPERTY & LIABILITY INS. 8,396 11,824 3,428 290-o 5349-453-430246-521 CENTRAL GARAGE TRANSFER 10,133 10,133 0 00-0 5349-453-430246-522 ADMINISTRATIVE TRANSFER 42,058 42,058 0 00-0 5349-453-430246-528 DATA PROCESSING TRANSFER 19,118 19,118 0- 00-0 5349-453-430246-530 BNSF LEASE PMT 4,672 6,000 1,328 220-o 5349-453-430246-532 OFFICE RENT 6,421 6,422 1 00-0 5349-453-430246-951 2 MILE DR. DRAINAGE IMPROVEMENT 0 250,000 250,000 1000-0 5349-453-430246-952 STORM DRAIN CORRECTION 50,677 200,000 149,323 750-o 5349-453-430246-953 SHOP COMPLEX PAVEMNT 165,123 188,200 23,077 120-o 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 22,353 390,000 367,647 940-o 5349-453-430247-954 N MAIN ST STORMWATER PROD 0 252,500 252,500 1000-0 5349-453-430248-959 REGIONAL FACILITY UPSIZING 182,326 1,236,000 1,053,674 850-o 5349-453-430248-960 STORMWATER FACILITY UPSIZE 0 230,000 230,000 1000-0 5349-453-430249-840 MACHINERY & EQUIP. - MACI MATCH (CA 34,268 43,000 8,732 200-o 5349-453-430249-940 MACHINERY FROM REPLACEMENT 52,070 50,000 2,070- -40-o 5349-453-490200-610 PRINCIPAL-4TH AVE E BOND 0 2,837 2,837 1000-0 5349-453-490200-620 INTEREST-4TH AVE E BOND 1,712 1,712 0- -00-0 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 285,000 285,000 1000-0 TOTAL STORM ------------ 11201,413 ------------- 4,047,062 ------------ ------------ 2,845,649 700-o 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 33 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 34 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 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 271 0 271- 00-. 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 1,022,157 996,000 26,157- -30-. 5510-000-343420-000 GARBAGE COLLECTION -BILLED 23,768 25,000 1,232 50-. 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,822 2,100 278 130-o 5510-000-371010-000 INVESTMENT EARNINGS 17,028 8,000 9,028- -1130-o TOTAL SOLID WASTE REVENUE ------------ 1,065,047 ------------ ------------ ------------- 1,031,100 ------------- ------------- ------------ 33,947- ------------ ------------ ------------ -30-o ------------ ------------ SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 390,498 418,051 27,553 70-8 5510-460-430840-112 SEVERANCE -RETIREMENT 34,107 65,447 31,340 480-8 5510-460-430840-121 OVERTIME 2,103 6,500 4,397 680-o 5510-460-430840-153 HEALTH INSURANCE 86,779 94,557 7,778 80-0 5510-460-430840-155 RETIREMENT 30,984 31,059 75 00-0 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 13,055 14,500 1,445 100-0 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 28,482 37,500 9,018 240-8 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 3,636 5,500 1,864 340-8 5510-460-430840-231 GAS & OIL 47,985 55,000 7,015 130-o 5510-460-430840-341 ELECTRICITY 1,568 2,050 482 240-8 5510-460-430840-344 NATURAL GAS 2,873 4,500 1,627 360-o 5510-460-430840-345 TELEPHONE & COMMUNICATION 1,678 1,250 428- -340-8 5510-460-430840-354 CONTRACT SERVICES 9,832 20,000 10,168 510-8 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 5,571 5,700 129 20-o 5510-460-430840-366 BUILDING MAINTENANCE 4,305 4,500 195 40-8 5510-460-430840-373 DUES & TRAINING 1,396 3,500 2,104 600-o 5510-460-430840-388 MEDICAL SERVICES 562 650 88 140-8 5510-460-430840-510 PROPERTY & LIABILITY INS. 8,471 9,400 930 100-0 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 0 4,000 4,000 1000-0 5510-460-430840-521 CENTRAL GARAGE TRANSFER 71,869 71,869 0- 00-0 5510-460-430840-522 ADMINISTRATIVE TRANSFER 38,199 38,199 0- 00-0 5510-460-430840-528 DATA PROCESSING TRANSFER 14,339 14,339 0 00-0 5510-460-430840-532 OFFICE RENT 6,421 6,422 1 00-0 5510-460-430840-610 DEBT SERVICE PRINCIPAL -GARBAGE TK 0 39,121 39,121 1000-0 5510-460-430840-620 DEBT SERVICE INTEREST -GARBAGE TK 922 1,232 310 250-8 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 40,000 40,000 0 00-0 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 33,513 38,200 4,687 120-o 5510-460-430845-224 JANITORIAL SUPPLIES 165 500 335 670-8 5510-460-430845-341 ELECTRICITY 1,877 3,500 1,623 460-o 5510-460-430845-342 WATER 568 2,000 1,432 720-o 5510-460-430845-344 NATURAL GAS 6,075 6,000 75- -10-0 5510-460-430845-360 REPAIR & MAINT SERVICES 4,108 18,909 14,801 780-8 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 1000-0 TOTAL SOLID WASTE EXPENSE ------------ 891,941 ------------ ------------ ------------- 1,213,955 ------------- ------------- ------------ ------------ 322,014 ------------------------ ------------------------ 270-8 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 35 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 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- 00-. 6030-000-335230-000 ENTITLEMENT SHARE PMT/HB124 180,000 180,000 0 00-. 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 164,965 188,000 23,035 120-o 6030-000-371010-000 INVESTMENT EARNINGS 3,133 1,100 2,033- -1850-8 6030-000-393000-000 INTERNAL SERVICES -DATA 267,657 267,657 0 00-0 TOTAL INFORMATION TECH REVENUE ------------ 628,420 ------------ ------------ ------------- 636,757 ------------- ------------- ------------ 8,337 ------------ ------------ ------------ 10-0 ------------ ------------ INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 166,976 167,269 293 00-0 6030-401-410580-121 OVERTIME 0 1,000 1,000 1000-0 6030-401-410580-153 HEALTH INSURANCE 36,383 40,818 4,435 110-0 6030-401-410580-155 RETIREMENT 13,267 13,828 561 40-8 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 2,575 4,158 1,583 380-o 6030-403-410580-215 COMPUTER SUPPLIES 1,183 2,200 1,017 460-o 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 15,602 25,800 10,198 400-8 6030-403-410580-325 WEBSITE 16,745 16,375 370- -20-o 6030-403-410580-345 PAGER/PHONE 1,687 2,550 863 340-8 6030-403-410580-346 SUMMITNET & ISPS 12,935 16,224 3,289 200-o 6030-403-410580-353 LASER FICHE MAINTENANCE 4,182 3,866 316- -80-0 6030-403-410580-354 MAINTENANCE CONTRACTS 35,887 35,000 887- -30-o 6030-403-410580-355 LICENSES 16,668 20,250 3,582 180-0 6030-403-410580-356 MAINTENANCE CONTRACTS 45,910 49,100 3,190 70-8 6030-403-410580-357 GRANICUS 4,788 5,000 212 40-8 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 9,273 23,661 14,388 610-o 6030-403-410580-373 DUES & TRAINING 2,005 8,300 6,295 760-o 6030-403-410580-510 INSURANCE 1,313 2,000 687 340-8 6030-403-410583-218 TV -Video Equipment & programming 2,682 7,100 4,418 62% 6030-403-410585-229 COPIER,FAX, SUPPLIES 10,529 19,548 9,019 46% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 80,465 78,000 2,465- -3% 6030-403-410585-532 COPIER LEASES 17,325 14,388 2,937- -20% 6030-403-410585-942 Servers - capital contingency 7,230 12,000 4,770 40% 6030-403-510400-831 DEPRECIATION EXPENSE 0 10,000 10,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 747 705 42- -6% 6030-405-410588-940 COMPUTERS - SWITCHES 17,911 16,000 1,911- -12% 6030-410-410588-218 COMPUTERS - DPW 5,226 5,808 582 10% 6030-413-410588-218 COMPUTERS - POLICE DEPT 33,539 33,003 536- -2% 6030-413-410588-354 POLICE - HOSTED SERVER 1,735 2,150 415 19% 6030-416-410588-218 COMPUTERS - FIRE 16,792 12,258 4,534- -37% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 3,696 2,405 1,291- -54% 6030-436-410588-218 COMPUTERS - PARKS 6,627 7,080 453 6% 6030-480-410588-218 COMMUNITY DEVELOPMENT 123 0 123- 0% TOTAL INFORMATION TECH EXPENSE ------------------------- 592,006 ------------------------- ------------------------- ------------ 657,844 ------------ ------------ ------------ 65,838 ------------ ------------ 10% 07.05.2019 09:33 THE CITY OF KALISPELL, MONTANA Page 36 of 36 gb8501_pg.php/Job No: 6816 USER: RGW FY19 FINANCIAL REPORT Preliminary Fiscal Year 2019 100.00 % Yr Complete For Fiscal Year: 2019 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 544,000 544,000 0 00-. 6010-000-371010-000 INVESTMENT EARNINGS 2,413 400 2,013- -5030-. TOTAL CENTRAL GARAGE REVENUE ------------ 546,413 ------------ ------------ ------------- ------------ 544,400 2,013- ------------------------- ------------------------- ------------ -0% ------------ ------------ CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 154,796 165,695 10,899 70-8 6010-410-431330-121 OVERTIME 972 2,500 1,528 610-o 6010-410-431330-153 HEALTH INSURANCE 38,404 48,559 10,155 210-o 6010-410-431330-155 RETIREMENT 11,280 12,237 957 80-0 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 10,381 11,000 619 60-o 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 5,036 10,700 5,664 530-o 6010-410-431330-230 OIL 24,574 25,000 426 20-o 6010-410-431330-231 GAS 1,105 1,500 395 260-o 6010-410-431330-232 VEHICLE PARTS 135,860 124,000 11,860- -100-0 6010-410-431330-233 TIRES 46,632 48,000 1,368 30-o 6010-410-431330-238 FILTERS 9,333 8,500 833- -100-0 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 1,963 2,000 37 20-o 6010-410-431330-341 ELECTRICITY 1,653 1,950 297 150-8 6010-410-431330-344 NATURAL GAS 6,153 6,000 153- -30-o 6010-410-431330-354 CONTRACT SERVICES 25,042 30,000 4,958 170-8 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 6,360 8,000 1,640 200-o 6010-410-431330-373 DUES & TRAINING 3,876 7,200 3,324 460-o 6010-410-431330-388 MEDICAL SERVICES 537 425 112- -260-o 6010-410-431330-510 INSURANCE 2,217 2,179 38- -20-o 6010-410-431330-528 INFORMATION TECH TRANSFER 9,559 9,559 0- 00-0 6010-410-431330-944 TIRE CHANGER 13,517 15,000 1,483 100-0 TOTAL CENTRAL GARAGE EXPENSES ------------ ------------- 509,251 ------------------------- ------------------------- ------------ 540,004 ------------ ------------ ------------ 30,753 ------------ ------------ 60-o