Loading...
07-17-20 City Manager ReportCITY OF KALISPELL 1. Parks Department City of Kalispell OFFICE OF THE CITY Information Memorandum 7/ 17/2020 MANAGER On June 27, a group of volunteers from Faith Lutheran Church spent the day picking up trash along the future Core Trail and throughout Kalispell. We appreciate volunteers, individuals, and groups, who help make our community a little better. A contractor will begin restoration pruning of trees damaged in the May 31 wind event. Restoration pruning will clean stubs from broken branches as well as remove hangers left in the trees canopy. Park field staff are finishing the landscaping around the new playgrounds at Woodland Park. They are relocating irrigation heads to be able to reach the new turf areas, as well as seeding and then installing temporary fencing to keep waterfowl and people from entering the area untill the turf is established. Field staff at KYAC continue working on the midseason turf maintenance programs in preparation for fall sports. .7 A new park bench and concrete pad has been installed at Lawrence Park near the climbing boulders. The bench and pad were purchased by Friends of Lawrence Park in honor of long-time member Dave Downey who passed away a few years ago. July 13-17 is "Wild West" week at Camp Woodland Summer Day Camp with western themed games, crafts, and activities all week long. Wranglers from Bar W Guest Ranch will be coming to the camp on Friday, July 17 to do a roping demonstration for the campers. The campers will have the opportunity to try their hand at roping. The theme for the following week is "Space ... the Final Frontier," and will culminate with a rocket demonstration on Friday, July 24. We have 15 participants in our Skateboarding Camp from July 13-16. This camp is designed for boys and girls (ages 7+) for all ability levels. We are excited to partner with longtime skateboarding coach, Michael "Spike" Blauvelt, who ran the City of Whitefish's skateboard program for more than a decade, instructing KPR's camp this summer. We started our second session of swim lessons on July 13 which will run until July 23. Our swim lesson participation increased from 143 in our first session to 219 this session. We plan to offer two more sessions throughout the summer; July 27 to August 6, and August 10 to August 20. After discussions with Flathead County City Health Department about the impact of COVID-19 and how our summer concert series functions, we made the decision to postpone this year's Picnic in the Park concert series. We have processed refunds for all of this year's sponsors. We have also contacted all bands and informed them that we would hold their spot in the music line-up for next summer. 2. Public Works With the effects of COVID 19 on the national economy it is a good time to see what effects this event may have had on local construction. Public Works can get a feel for the rates of construction through the permits managed through our CityWorks software; mainly right-of-way and construction stormwater. Public Works has been utilizing CityWorks for these permits since 2017, so we can easily get a year to year comparison of permits issued. Right-of-way permits are required for any work within the right-of-way and can include driveways, sidewalk, and utility work. Right-of-way permits are required on most residential construction as well as commercial construction. Construction stormwater permits are required on any project disturbing more than 1,000 square feet or 5 cubic yards. This permit is also issued for most residential or commercial proj ects. Neither one of these permits would be issued on a remodel or tenant improvement that is completely interior to an existing structure, so they are good measures of new construction. Right -of -Way Permits By Year Sturmwaw Permits 4 Year 350 7% Mc m M nm Jan Feb Mar Apr Mlay Jun Id Aug Sep W Nm 0ec -2017 -2018 -2019 -202C---2020)proisued) 2m 145 r' 1.4 £ Mw rarskgn 1N 1S0 t&M YI SW YIM NSfI+f/14F 1¢ i#n r+4 Wr i f V" Iw FA &C WV (" Mh DK -2014 _NI, -Mg --"iW4ip9MyF� 2 The first chart above shows the cumulative Right -of -Way permits starting in January of each year for the previous three years and also 2020 up to the current date. The total for July of 2020 was estimated by doubling the current number for the month since we are approximately half -way through this month. The rest of 2020 was estimated by adding the average permits per month from the previous three years. Similarly, the second chart shows the cumulative Construction Stormwater permits for the same years and uses the same methodology to project the rest of July and the rest of 2020. Two milestones were added to the Charts. First, on March 12, Montana declared a State of Emergency due to the COVID-19 pandemic. Secondly, on June 1, our new impact fee rates went into effect. Admittedly, we are still early into the month of July. However, for both charts, the first half of the month seems on track with the trajectory from the previous month. Either way, it seems safe to say that the COVID-19 pandemic has not yet had an appreciable effect on the rate of construction in Kalispell and it appears that construction is well on pace to exceed the construction from the previous 3 years. 3. Planning Department The Planning Board met on July14 and heard application requests from two applicants. The first application request was from Colton Lee Communities, LLC, for a conditional use permit to construct a multi -family residential development with four buildings and a total of 96 dwelling units, along with an associated parking lot area located at 216 Hutton Ranch Road. The second request was from 430 Stillwater Road, LLC, for a Planned Unit Development ("PUD") application for a Residential Mixed -Use PUD along with applications for rezoning and preliminary plat on 28.2 acres of land within an existing R- 3/PUD Zone. The subject property is located at 430 Stillwater Road at the intersection of Stillwater Road and Four Mile Drive, and was part of the now expired Starling PUD covering Section 35. The project envisions a mixture of single family residential and multi -family residential uses along with a retail area intended to serve the development and the greater area. The plan includes 83 single family lots, 192 multi -family units, and approximately 1.77 acres of commercial/retail area, along with two clubhouses and approximately 4.15 acres of park areas. The PUD would provide for smaller lot sizes/widths and longer block lengths than typical standards. The proposed rezoning of the property would change the underlying zone from R-3 (Residential) to RA -I (Residential Apartment) and B-1 (Neighborhood Business). The Board did recommend approval of the two requests and their recommendations will be forwarded to the Council for their consideration at the August 3, 2020, meeting. The Kalispell City Planning Board also provided the public hearing forum for Creekside Commons. The project consists of 24 one -bedroom and 12 two -bedroom units specifically designed for seniors, located at 120 Financial Drive. The project will house those earning between 30 to 60% of the area median income with below market rents. The project is in the final pool of applications through Montana Housing and would be financed with federal low-income housing tax credits. If awarded, the project will go through the City Conditional Use Permit and building permit process for multi -family housing. 4. Building Department In the last 4 weeks, we have issued permits for 3 single-family homes and 4 townhomes. That will bring the total of new single-family/duplex and townhouse units for the year to 120, compared to 67 last year at this time. The permit was issued for the new Copper Mountain located at 31 Three Mile Dr. The project has an estimated project value of $51,180. There was a total of 154 combined building and/or fire inspections completed in the last 4 weeks. Residential — 59 Plumbing — 16 Commercial — 11 Mechanical - 13 Electrical — 9 Fire - 46 5. Community Development The Airport Road and 18th Street project is underway with stormwater infrastructure at the parking lot being installed this week and 12th Street West sidewalk installation getting started. FCEDA completed demolition on the former CHS Agronomy Center last week leaving just the structures requiring further phase II environmental work and remediation. On Monday, July 20, the City's Brownfields contractor will begin the petroleum phase II for the site and will remove the northwest fueling system canopy, fuel pumps, 3 underground storage tanks and the associated piping. Work is expected to be completed by July 24. 6. Police Department Attached is the latest case report from the Kalispell Police Department. On July 8, 2020, the Kalispell Police Department conducted new officer testing. 32 candidates showed for the testing, 21 passed the testing, and 12 have been chosen to move to the interview phase. There was a noticeable uptick in POST certified applicants from other areas applying with the department. Detective Sergeant Ryan Bartholomew attended a crime scene school in Columbus, MT July 13-17. This 40-hour course is designed to familiarize beginner to intermediate level police personnel with the basic technical skills needed to identify, document, preserve and collect the most common types of physical evidence found at crime scenes. Year to date calls for service stand at 17,451 as of July 15. This compares with 19,903 in 2019, and 18,373 in 2018. N 7. Finance Department Please find attached the printouts reflecting the activity for July 1, 2019 thru June 30, 2020 (FY20). All funds are included with the exception of the debt service funds. GOVERNMENTAL FUNDS REVENUES: Total general fund revenues have been boosted by almost $1,000,000 of CARES ACT disbursements. Most general fund revenues are complete with a few exceptions. General Fund revenue reflects real property tax dollars received from Flathead County thru June 30. Fiscal year 2020 taxes collected by Flathead County before June 30 will be distributed in July and should be between $300,000 and $400,000 in the general fund. Fiscal year 2020 General Fund real property tax revenues negative variance with the budgeted amount will be less than 5%. At June 30, 2020, the City is carrying $17,046 in protest taxes in the General Fund, a decrease from the prior fiscal year end. Parks will receive approximately another $70,000 real property tax revenue for fiscal year 2020. All other Parks revenues should be complete with maybe some minor adjustments. Total Ambulance revenues have been boosted by over $100,000 of CARES ACT disbursements. Ambulance fees for services (697,430) were within $7,000 of last fiscal year ($703,802). The second half of the County EMS Levy has not been received, but it will likely be about $60,000. Building department revenues should be complete and finished fiscal year 2020 42% over the budgeted amount, and about $200,000 more than fiscal year 2019. EXPENDITURES: Keep in mind that these are not final as fiscal year 2020 claims have not all been processed. General fund fiscal year 2020 expenditures are currently $870,334 (6%) under the budgeted amount of $13,832,600. About $170,000 of this amount is due to transfers from the general fund that were not necessary due to the CARES ACT disbursement. Another portion of the positive expenditure budget variance is salary savings in several departments. Fiscal year 2020 claims processing in fiscal year 21, based on past fiscal year history, could bring the budget variance down to about $650,000. Total Parks and Recreation Fund expenditures are 14% ($257,686) under fiscal year 2020 budget, which should be more than adequate for final claims, generally around $50,000. 5 ENTERPRISE FUNDS REVENUES: Metered water sales were $3,033,976, the budgeted amount was $3,000,000. For comparison, last years' metered water sales were $3,193,048. This decrease in water sales can be attributed to the below average temperatures and above average moisture experienced this far in 2020. Water impact fees were over 1.24 times the budgeted amount, but about $200,000 less than last fiscal year. In total, water department revenues, including water impact fees, were $200,000 over the budgeted amount. Sewer service charges were $4,483,952, slightly less than the budgeted amount, and about 2% less than last fiscal year's sewer service charges. Sanitary sewer and treatment plant impact fees were 172% and 169% of the anticipated fiscal year 2020 amount, respectively. In total, including impact fees, sewer department revenues were $700,000 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 $769,977 under the budgeted amount. Personal services savings account for about 32% ($245,000). Other budget savings of at least 15% should be seen in energy cost (natural gas, electric, gasoline), contract services (as much as $360,000), and about $50,000 in construction materials expenses. $10,000 was budgeted, and less than $1000 used for uninsured losses. The Sewer Fund, including the treatment plant, operating expenses are currently $578,372 under the budgeted amount. Contract services savings should be at least $350,000. Other budget savings of at least $40,000 should be seen in energy cost (natural gas, electric, gasoline), and uninsured loss ($20,000). Total Storm Sewer Fund operating expenses are currently 33% ($245,896) under fiscal year 2020 budget, which should be more than adequate for final claims, generally not over $50,000. Total Solid Waste Fund operating expenses are currently 10% ($96,963) under fiscal year 2020 budget. Final solid waste claims are generally insignificant (under $10,000). 0 a O O N-O m ,m, t oo 00 -0— O v �n O 0 o O' M N N v v m '�,° cc ma` o h v o N O O N ao N m V 1p m a -I O m N O ao ao m m 0p `-' O c-I a -I 1p `-' I� ci ao .� r, N N N m lD lD m c-I o V N Q1 co N _ 0--i v � v Q O j v a o 0 `o w vp a` 0 u O � a v o 0 `o m v o w � a v n v a o m o � � Q h a v v `w o n 0 O ¢ ai Q p _T � h a N Ol N O a O _ O ¢ v O O O N N lD lD N O zr O O O N O N M� ti v a • C � � d v p n N W O � v O O O V1 N l0 n N M� rl O N N O O O l0 O O O N O I� N O N O M f� O l0 rl N N ti T Q N O rl NO lltoww�f O O N O N O O O O O O O N OO OOOl0OlOOOOlvtOMrlN-O l0M OOOm u v Q O O N O O M I� M O N O O N N O N O N O O O N O l0 N O N O �+l f� No M M � a N a O N N N O V1 N M M O l0 rl O N O O O N N l0 rl O N O lD lD 01 O TIT N O O O O O rl o o o N o x M O O o m rl O I� n W � Sn ti f6 3 Q 9 11 a N a .o O N N M O lD ti 0 c-I l0 O V l0 .--� N O O O N O CO N O O O N 01 n N O ¢ T v O O O O O M O N rl O ti ti O ti O M r-I 0 0 0-- O O N-- N CO M M � [0 Q � h a v o n O N O M O 01 O V1 V1 O �/1 ul O N rl O N N O CO N N O N I� l0 n l0 C N W O � y 4 as `w a y 'o-> O _ O y co cc 16 •>-• tp: 15 �°.{ -o a Q a m o o ai 0 p ao — > t n 16 0 .£ m b as t v o= E n o v �_ o-8> 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 1 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 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,841,874 6,380,000 538,126 8% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 18,156 16,500 1,656- -10% 1000-000-311200-000 PERSONAL PROPERTY TAXES 177,732 150,000 27,732- -18% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 8,749 9,000 251 3% 1000-000-322101-000 LIQUOR LICENSES 34,246 33,000 1,246- -4% 1000-000-322300-000 BUSINESS LICENSES 1,617 1,500 117- -8% 1000-000-323012-000 PLANNING FEES 104,211 80,000 24,211- -30% 1000-000-323109-000 SITE REVIEW 20,875 16,000 4,875- -30% 1000-000-323200-000 PARADE PERMITS 350 1,000 650 65% 1000-000-331990-000 CARES ACT GRANT/ COVID-19 STIMULUS 18,472 0 18,472- 0% 1000-000-331992-000 CARES ACT REIMBURSEMENT THRU STATE 841,087 0 841,087- 0% 1000-000-335030-000 M.V. TAX - AD VALOREM 1,381 400 981- -245% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 59,300 63,000 3,700 6% 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,250 1,400 150 11% 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 2,983,738 2,983,738 0 0% 1000-000-341020-000 ADMINISTRATIVE CHARGES 672,457 671,704 753- -0% 1000-000-341021-000 GRANT ADMIN FEES 29,078 20,000 9,078- -45% 1000-000-341025-000 CITY COLLECTIONS 7,373 5,000 2,373- -47% 1000-000-342010-000 POLICE SERVICES 29,347 27,000 2,347- -9% 1000-000-342014-000 RESOURCE OFFICERS 218,961 218,967 6 0% 1000-000-342016-000 KPD REGIONAL TRAINING 1,425 14,500 13,075 90% 1000-000-343018-000 PARKING PERMITS 87,969 95,000 7,031 7% 1000-000-343062-000 AIRPORT FUEL TAXES 4,064 4,000 64- -2% 1000-000-343063-000 AIRPORT GROUND LEASE (HILTON) 14,855 14,500 355- -2% 1000-000-351000-000 CITY COURT FINES & FEES 454,377 450,000 4,377- -1% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 25,825 24,000 1,825- -8% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 41,201 58,000 16,799 29% 1000-000-362015-000 INSURANCE REIMBURSEMENTS (FY20 MPOR 12,580 54,600 42,020 77% 1000-000-362020-000 MMIA GASB 54 REIMBURSEMENT 3,000 3,000 0 0% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 1,080 10,000 8,920 89% 1000-000-371010-000 INVESTMENT EARNINGS 59,622 45,000 14,622- -32% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 925,000 925,000 0 0% TOTAL GENERAL FUND REVENUE 12,701,253 12,375,809 325,444- -3% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 2 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 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 3,030 2,935 95- -3% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 13,750 13,750 0 0% 1000-400-410530-354 OPEB EXPENSE 7,500 7,500 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 4,291 3,500 791- -23% 1000-400-410560-312 POSTAGE 15,687 18,000 2,313 13% 1000-400-410560-320 PRINTING & ENVELOPES 6,730 4,000 2,730- -68% 1000-400-410560-354 CONTRACT SERVICES - DOC. SHREDDING 128 1,000 873 87% 1000-400-410580-354 CONTRACT SERVICES 1,142 0 1,142- 0% 1000-400-410600-354 ELECTIONS 14,866 13,657 1,209- -9% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 4,041 3,500 541- -15% 1000-400-420000-354 CONTRACT 911 CENTER 533,475 534,000 525 0% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 334 350 16 4% 1000-400-430300-355 AIRPORT REIMBURSEMENT 16,428 18,500 2,072 11% 1000-400-460000-820 TFR TO FORESTRY (FY18/19) WESTSIDE 1,700,000 1,200,000 500,000- -42% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 15,000 15,000 0 0% 1000-400-460452-366 HOCKADAY MAINTENANCE 6,600 6,600 0 0% 1000-400-510300-000 CONTINGENCY 965 530,000 529,035 100% 1000-400-510310-354 ICMA PLAN FEES 375 500 125 25% 1000-400-510330-513 LIABILITY INSURANCE 140,059 140,807 748 1% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 6,100 50,000 43,900 88% 1000-400-510330-517 PROPERTY INSURANCE 54,676 54,676 0- 0% SUBTOTAL GEN.GOV'T. 2,545,180 2,618,275 73,095 3% 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-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 149,413 149,741 328 0% 22,785 23,220 435 2% 15,930 15,887 43- -0% 1,451 1,000 451- -45% 494 400 94- -23% 960 1,790 830 46% 6,106 10,500 4,394 42% 2,685 4,500 1,815 40% 199,824 207,038 7,214 3% 145,490 137,409 8,081- -6% 17,272 19,916 2,644 13% 10,337 10,868 531 5% 788 600 188- -31% 15,254 20,000 4,746 24% 1,050 1,000 50- -5% 3,804 6,500 2,696 41% 193,994 196,293 2,299 1% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 3 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 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,274 63,087 813 1% 1000-402-410100-153 HEALTH INSURANCE 45,628 55,457 9,829 18% 1000-402-410100-155 RETIREMENT 2,561 2,558 3- -0% 1000-402-410100-210 OFFICE SUPPLIES 63 500 437 87% 1000-402-410100-335 MT LEAGUE OF CITIES 220 9,225 9,006 98% 1000-402-410100-354 CONTRACT SERVICES 9,446 13,000 3,554 27% 1000-402-410100-373 DUES & TRAINING 10,496 10,800 304 3% 1000-402-410100-379 MEETINGS 13,886 20,311 6,425 32% SUBTOTAL MAYOR/COUNCIL 144,573 174,938 30,365 17% CITY CLERK 1000-402-410150-110 SALARIES -CITY CLERK 95,617 97,169 1,552 2% 1000-402-410150-121 OVERTIME 0 250 250 100% 1000-402-410150-153 HEALTH INSURANCE 20,129 20,526 397 2% 1000-402-410150-155 RETIREMENT 7,697 7,732 35 0% 1000-402-410150-210 OFFICE SUPPLIES 0 300 300 100% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 226 600 374 62% 1000-402-410150-345 TELEPHONE & COMMUNICATION 480 480 0 0% 1000-402-410150-352 CODIFICATION 3,046 4,100 1,054 26% 1000-402-410150-354 CONTRACT SERVICES 0 300 300 100% 1000-402-410150-373 DUES & TRAINING 1,666 3,200 1,534 48% SUBTOTAL CITY CLERK 128,861 134,657 5,796 4% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES -FINANCE OFFICE 201,439 216,572 15,133 7% 1000-403-410550-121 OVERTIME 0 500 500 100% 1000-403-410550-153 HEALTH INSURANCE 36,115 36,794 679 2% 1000-403-410550-155 RETIREMENT 16,143 17,170 1,027 6% 1000-403-410550-210 SUPPLIES 176 1,000 824 82% 1000-403-410550-322 BOOKS 0 300 300 100% 1000-403-410550-353 CONTRACT SERVICES 140 500 360 72% 1000-403-410550-354 CONTRACT -GRIZZLY SECURITY 672 800 128 16% 1000-403-410550-355 BANK CHARGES & FEES 2,970 3,200 230 7% 1000-403-410550-373 DUES & TRAINING 3,086 7,500 4,414 59% SUBTOTAL FINANCE 260,739 284,336 23,597 8% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 4 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 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 423,977 442,839 18,862 4% 1000-404-411110-153 HEALTH INSURANCE 71,432 80,997 9,565 12% 1000-404-411110-155 RETIREMENT 34,079 35,232 1,153 3% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 821 2,563 1,742 68% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 15,080 17,000 1,920 11% 1000-404-411110-345 TELEPHONE & COMMUNICATION 704 1,025 321 31% 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 32,525 15,600 16,925- -108% 1000-404-411110-373 DUES & TRAINING 8,144 8,000 144- -2% SUBTOTAL CITY ATTORNEY 586,762 603,256 16,494 3% MUNICIPAL COURT 1000-406-410360-110 SALARIES -COURT 226,886 227,463 577 0% 1000-406-410360-121 OVERTIME 442 3,500 3,058 87% 1000-406-410360-153 HEALTH INSURANCE 42,597 38,585 4,012- -10% 1000-406-410360-155 RETIREMENT 18,119 18,048 71- -0% 1000-406-410360-210 SUPPLIES 1,794 4,500 2,706 60% 1000-406-410360-320 PRINTING/BOOKS 1,576 2,500 924 37% 1000-406-410360-345 TELEPHONE & COMMUNICATION 64 1,400 1,336 95% 1000-406-410360-353 SECURITY & TECHNOLOGY 72,275 40,000 32,275- -81% 1000-406-410360-354 CONTRACT SERVICES 768 6,250 5,482 88% 1000-406-410360-373 DUES & TRAINING 1,638 10,000 8,362 84% 1000-406-410360-394 JURY & WITNESS FEES 1,828 7,500 5,672 76% SUBTOTAL COURT 367,988 359,746 8,242- -2% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES -PUBLIC WORKS 18,916 18,839 77- -0% 1000-410-430100-153 HEALTH INSURANCE 3,172 3,524 352 10% 1000-410-430100-155 RETIREMENT 1,495 1,467 28- -2% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 10,537 14,000 3,463 25% 1000-410-430100-231 GAS 2,318 3,000 682 23% 1000-410-430100-345 TELEPHONE & COMMUNICATION 267 350 83 24% 1000-410-430100-354 CONTRACT SERVICES 1,813 2,000 187 9% 1000-410-430100-373 DUES & TRAINING 3,558 3,500 58- -2% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 4,571 4,571 0- 0% SUBTOTAL PUBLIC WORKS ADMIN 46,647 51,251 4,604 9% CITY HALL MAINT. 1000-412-411230-110 SALARIES -CITY HALL 63,793 72,913 9,120 13% 1000-412-411230-153 HEALTH INSURANCE 11,965 13,628 1,663 12% 1000-412-411230-155 RETIREMENT 4,916 5,544 628 11% 1000-412-411230-220 SECURITY IMPROVEMENTS 5,370 6,793 1,423 21% 1000-412-411230-224 JANITORIAL SUPPLIES 4,734 6,000 1,266 21% 1000-412-411230-241 TOOLS & SUPPLIES 1,008 1,500 492 33% 1000-412-411230-341 ELECTRICITY 44,003 45,000 997 2% 1000-412-411230-344 NATURAL GAS 24,767 32,000 7,233 23% 1000-412-411230-345 TELEPHONE & COMMUNICATION 441 400 41- -10% 1000-412-411230-354 CONTRACT SERVICES 12,312 25,000 12,688 51% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 5 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-355 HVAC MAINTENANCE CONTRACT 16,710 16, 500 210- -1% 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 4,402 6,000 1,598 27% 1000-412-411230-362 EQUIPMENT MAINTENANCE 6,070 10,000 3,930 39% 1000-412-411230-366 BUILDING MAINTENANCE 59,530 41,150 18,380- -45% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,435 3,700 265 7% SUBTOTAL CITY HALL 263,457 286,128 22,671 8% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES -PLANNING & ZONING 248,777 283,588 34,811 12% 1000-420-411020-112 SALARIES - RETIRMENT 43,108 57,078 13,970 24% 1000-420-411020-153 HEALTH INSURANCE 48,151 56,122 7,971 14% 1000-420-411020-155 RETIREMENT 20,306 22,556 2,250 10% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 3,602 5,000 1,398 28% 1000-420-411020-231 GAS 115 400 285 71% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 1,753 2,000 247 12% 1000-420-411020-345 TELEPHONE 590 1,000 410 41% 1000-420-411020-354 CONTRACT SERVICES 5,951 2,000 3,951- -198% 1000-420-411020-373 DUES & TRAINING 6,079 7,000 921 13% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 401 401 0 0% SUBTOTAL PLANNING DEPT. 378,833 437,145 58,312 13% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 66,446 67,380 934 1% 1000-480-470210-153 HEALTH INSURANCE 13,905 13,277 628- -5% 1000-480-470210-155 RETIREMENT 5,352 5,325 27- -1% 1000-480-470210-210 OFFICE SUPPLIES 367 1,000 633 63% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 0 750 750 100% 1000-480-470210-312 POSTAGE & PRINTING 209 500 291 58% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 500 500 0 0% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 437 750 314 42% 1000-480-470210-354 CONTRACT SERVICES 96 500 404 81% 1000-480-470210-373 DUES & TRAINING 4,837 5,000 163 3% 1000-480-470210-379 MEETINGS 944 1,500 556 37% SUBTOTAL COMMUNITY DEVELOPMENT 93,092 96,482 3,390 4% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 6 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES -POLICE 2,320,488 2,399,735 79,247 3% 1000-413-420140-112 SALARIES -SEVERANCE 33,007 22,000 11,007- -50% 1000-413-420140-114 SALARY -comptime buyout 2,743 13,600 10,857 80% 1000-413-420140-121 OVERTIME (REG & AET OT) 70,360 80,000 9,640 12% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 35,767 25,000 10,767- -43% 1000-413-420140-153 HEALTH INSURANCE 428,220 465,977 37,757 8% 1000-413-420140-155 RETIREMENT 294,499 313,964 19,465 6% 1000-413-420140-210 OFFICE SUPPLIES 3,277 3,500 223 6% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 12,104 13,000 896 7% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 19,637 21,000 1,364 6% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 3,498 3,760 262 7% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 7,535 7,000 535- -8% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 963 1,000 37 4% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 29,380 29,250 130- -0% 1000-413-420140-227 AMMO & RELATED SUPPLIES 24,996 25,000 4 0% 1000-413-420140-228 PATROL CAR SUPPLIES 14,925 15,400 475 3% 1000-413-420140-229 OTHER SUPPLIES 4,357 5,000 643 13% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 302 1,000 698 70% 1000-413-420140-231 GAS 64,373 83,000 18,627 22% 1000-413-420140-234 CRISIS NEGOTIATIONS 427 500 73 15% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 354 1,500 1,146 76% 1000-413-420140-320 PRINTING 3,253 5,500 2,247 41% 1000-413-420140-345 TELEPHONE & COMMUNICATION 20,324 19,000 1,324- -7% 1000-413-420140-354 CONTRACT SERVICES 22,476 49,375 26,899 54% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 4,603 6,500 1,897 29% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 4,538 4,830 292 6% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 2,092 2,000 92- -5% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 36,296 33,000 3,296- -10% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 2,828 2,500 328- -13% 1000-413-420140-373 DUES & TRAINING 36,062 46,000 9,938 22% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 661 14,500 13,839 95% 1000-413-420140-380 TRAINING MATERIALS 3,150 3,000 150- -5% 1000-413-420140-388 MEDICAL SERVICES 2,505 3,000 496 17% 1000-413-420140-392 BOARDING/TREATING PRISONERS 2,339 2,500 161 6% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 86,498 86,498 0- 0% 1000-413-420140-530 RENT 8,019 8,520 501 6% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 64,000 64,000 0 0% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 11,500 11,500 0 0% 1000-413-420140-944 VEHICLES 211,793 211,793 0 0% 1000-413-420141-110 1000-413-420141-121 1000-413-420141-153 1000-413-420141-155 SUBTOTAL POLICE DEPT. 3,894,147 4,104,202 210,056 5% DETECTIVES SALARIES -DETECTIVES DETECTIVE -OVERTIME HEALTH INSURANCE DETECTIVE -RETIREMENT TOTAL DETECTIVES RECORDS 1000-413-420142-110 SALARIES -RECORDS DIVISION 1000-413-420142-121 OVERTIME 363,859 382,938 19,079 5% 8,433 15,000 6,567 44% 77,002 81,839 4,837 6% 48,193 51,285 3,092 6% 497,488 531,062 33,574 6% 140,423 149,535 9,112 6% 1,900 7,500 5,600 75% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 7 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-153 HEALTH INSURANCE 31,706 44,050 12,344 28% 1000-413-420142-155 RETIREMENT 11,314 11,831 517 4% TOTAL RECORDS 185,343 212,916 27,573 13% RESOURCE OFFICERS 1000-413-420144-110 SALARIES -SRO 261,581 283,576 21,995 8% 1000-413-420144-153 HEALTH INSURANCE 49,201 42,175 7,026- -17% 1000-413-420144-155 SRO RETIREMENT 34,411 38,062 3,651 10% TOTAL RESOURCE OFFICERS 345,193 363,813 18,620 5% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL -SALARIES 45,002 43,420 1,582- -4% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 8,278 8,436 158 2% 1000-413-420145-155 RETIREMENT 3,402 3,434 32 1% SUBTOTAL ANIMAL CONTROL 56,682 55,790 892- -2% PARKING 1000-413-420147-110 PARKINGS -SALARIES 82,833 83,263 431 1% 1000-413-420147-153 HEALTH INSURANCE 30,422 31,019 597 2% 1000-413-420147-155 RETIREMENT 6,513 6,584 71 1% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 1,888 4,000 2,112 53% 1000-413-420147-354 CONTRACTED SERVICES 1,910 2,000 90 4% 1000-413-420147-362 LOT MAINT 4,510 10,000 5,490 55% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 7,725 17,500 9,775 56% 1000-413-420147-550 LOT LEASE PAYMENTS 1,110 1,500 390 26% SUBTOTAL PARKING 136,910 155,866 18,956 12% SUBTOTAL POLICE DEPT. 5,115,762 5,423,649 307,887 6% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 8 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 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,623,925 1,739,869 115,944 7% 1000-416-420400-114 COMPTIME BUYOUT 3,360 5,500 2,140 39% 1000-416-420400-115 OUT OF RANK PAY 10,422 12,500 2,078 17% 1000-416-420400-121 OVERTIME 94,732 40,000 54,732- -137% 1000-416-420400-153 HEALTH INSURANCE 300,273 297,790 2,483- -1% 1000-416-420400-155 RETIREMENT 211,752 227,035 15,283 7% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 856 4,000 3,144 79% 1000-416-420400-218 Equipment (Non Capital) 40,758 21,500 19,258- -90% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 13,178 15,000 1,822 12% 1000-416-420400-224 JANITORIAL SUPPLIES 4,780 5,000 220 4% 1000-416-420400-231 GAS 8,373 17,325 8,952 52% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 9,540 15,750 6,210 39% 1000-416-420400-320 PRINTING 20 200 180 90% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 280 1,250 970 78% 1000-416-420400-345 TELEPHONE & COMMUNICATION 4,330 6,000 1,670 28% 1000-416-420400-354 CONTRACT SERVICES 21,051 20,390 661- -3% 1000-416-420400-362 EQUIPMENT MAINTENANCE 1,622 5,500 3,878 71% 1000-416-420400-366 BUILDING MAINTENANCE -STATION 62 8,163 6,500 1,663- -26% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 2,568 5,000 2,432 49% 1000-416-420400-373 DUES & TRAINING 6,516 10,000 3,484 35% 1000-416-420400-388 FIREFIGHTER PHYSICALS 17,660 27,475 9,815 36% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 33,663 33,663 0- 0% 1000-416-420400-610 DEBT RETIREMENT -FIRE TRUCK 43,174 43,173 1- 0% 1000-416-420400-620 INTEREST EXPENSE -FIRE TRUCK 14,268 14,633 365 3% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 110,000 280,000 170,000 61% 1000-416-420400-940 EQUIPMENT - PICKUP/SCBA/SERVER 23,113 76,000 52,887 70% 1000-416-420440-110 SALARIES -FIRE PREVENTION 20,771 21,459 688 3% 1000-416-420440-114 COMPTIME BUYOUT 350 0 350- 0% 1000-416-420440-121 OVERTIME 236 0 236- 0% 1000-416-420440-153 HEALTH INSURANCE 5,210 5,311 101 2% 1000-416-420440-155 RETIREMENT 1,610 1,583 27- -2% SUBTOTAL FIRE DEPT. 2,636,554 2,959,406 322,852 11% GRAND TOTAL GENERAL FUND 12,962,266 13,832,600 870,334 6% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 9 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 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 925,171 1,045,000 119,829 11% 2215-000-311200-000 PERSONAL PROPERTY TAXES 29,554 22,868 6,686- -29% 2215-000-312000-000 PEN & INTEREST DEL TAXES 1,319 2,000 681 34% 2215-000-335230-000 ENTITLEMENT SHARE PMT/HB 124 17,133 17,132 1- -0% 2215-000-346030-000 SWIMMING POOL FEES 101,154 140,000 38,846 28% 2215-000-346040-000 CONCESSION STAND REVENUE 28,229 36,000 7,771 22% 2215-000-346050-000 PARKS USAGE FEES 11,396 20,000 8,604 43% 2215-000-346051-000 RECREATION FEES 22,010 20,033 1,977- -10% 2215-000-346052-000 SPORTS PROGRAMS 34,450 59,480 25,030 42% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 801 2,000 1,199 60% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 44,184 56,000 11,816 21% 2215-000-346055-000 ICE RINK 22,042 20,000 2,042- -10% 2215-000-346056-000 KIDSPORT USAGE 913 3,000 2,087 70% 2215-000-346057-000 YOUTH CAMPS 143,269 156,421 13,152 8% 2215-000-346059-000 PICNIC IN THE PARK 3,311 26,500 23,189 88% 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 2,296 0 2,296- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 10,390 20,000 9,610 48% 2215-000-371010-000 INVESTMENTS 9,106 5,500 3,606- -66% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 95,000 95,000 0 0% TOTAL PARKS & REC REVENUE 1,501,728 1,746,934 245,206 14% PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES -PARKS 324,689 336,666 11,977 4% 2215-436-460430-111 SEASONAL SALARIES 41,241 66,679 25,438 38% 2215-436-460430-121 OVERTIME 0 300 300 100% 2215-436-460430-153 HEALTH INSURANCE 57,412 61,999 4,587 7% 2215-436-460430-155 RETIREMENT 28,549 28,857 308 1% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 1,104 1,800 696 39% 2215-436-460430-215 EQUIPMENT - not capital 2,000 6,000 4,000 67% 2215-436-460430-224 JANITORIAL SUPPLIES 4,186 6,000 1,814 30% 2215-436-460430-229 OTHER SUPPLIES 2,195 10,000 7,805 78% 2215-436-460430-231 GAS 12,860 15,500 2,640 17% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 1,283 6,000 4,717 79% 2215-436-460430-320 PRINTING & ADVERTISING 166 200 34 17% 2215-436-460430-341 ELECTRICITY 11,195 14,000 2,805 20% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 21,781 20,000 1,781- -9% 2215-436-460430-344 NATURAL GAS 1,368 2,500 1,133 45% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 1,949 2,800 851 30% 2215-436-460430-351 SPORTS COURT & BAND SHELL REHAB 0 2,000 2,000 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 2,000 2,000 0 0% 2215-436-460430-355 CONTRACT SERV. TRAIL MAINT/WEED CON 15,092 15,000 92- -1% 2215-436-460430-356 TRAIL STUDY 0 30,000 30,000 100% 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 978 1,193 215 18% 2215-436-460430-358 FVCC TENNIS INTERLOCAL AGREEMENT 7,000 7,000 0 0% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 8,192 10,500 2,308 22% 2215-436-460430-364 LANDSCAPING 3,235 6,000 2,765 46% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 10 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-367 VANDALISM REPAIRS 2,418 4,000 1,582 40% 2215-436-460430-373 DUES & TRAINING 5,166 8,000 2,834 35% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 55 400 345 86% 2215-436-460430-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 8,870 9,000 130 1% 2215-436-460430-440 IRRIGATION SUPPLIES 5,637 7,500 1,863 25% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 1,253 1,500 247 16% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 38,968 38,968 0 0% 2215-436-460430-545 COUNTY LANDFILL 3,735 6,273 2,538 40% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 48,413 59,296 10,883 18% 2215-436-460430-620 DEBT SERVICE INTEREST 5,777 7,890 2,113 27% 2215-436-460430-932 PARK IMPROV - LIONS PK IRRIGATION 13,028 16,608 3,580 22% 2215-436-460430-941 TRUCK (FY 20) 32,816 38,000 5,184 14% SUBTOTAL PARKS EXPENDITURES 714,610 850,929 136,319 16% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES -COMPLEX 107,175 110,377 3,202 3% 2215-436-460440-111 SEASONAL SALARIES 31,557 38,917 7,360 19% 2215-436-460440-121 OVERTIME 0 300 300 100% 2215-436-460440-153 HEALTH INSURANCE 28,529 34,733 6,204 18% 2215-436-460440-155 RETIREMENT 10,181 10,009 172- -2% 2215-436-460440-221 SAFETY EQUIPMENT 108 600 492 82% 2215-436-460440-229 OTHER SUPPLIES 14,966 22,000 7,034 32% 2215-436-460440-231 GAS 6,192 8,500 2,308 27% 2215-436-460440-241 CONSUMABLE TOOLS 563 2,000 1,437 72% 2215-436-460440-341 ELECTRICITY 8,020 9,500 1,480 16% 2215-436-460440-345 TELEPHONE & COMMUNICATION 227 240 13 6% 2215-436-460440-354 CONTRACT SERVICES 0 11000 1,000 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 611 800 189 24% 2215-436-460440-364 LANDSCAPING 14 600 586 98% 2215-436-460440-367 VANDALISM REPAIRS 204 500 296 59% 2215-436-460440-373 DUES & TRAINING 681 600 81- -14% 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 0 200 200 100% 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 100% 2215-436-460440-420 METAL PRODUCTS 900 1,500 600 40% 2215-436-460440-440 IRRIGATION 4,907 7,000 2,093 30% 2215-436-460440-452 SAND & GRAVEL 1,104 1,200 96 8% 2215-436-460440-521 CENTRAL GARAGE TRANSFER 4,201 4,201 0 0% 2215-436-460440-545 COUNTY LANDFILL 3,389 3,400 11 0% SUBTOTAL ATHLETIC COMPLEX 223,529 258,327 34,798 13% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES -RECREATION 78,276 83,360 5,084 6% 2215-436-460431-111 SEASONAL SALARIES 8,215 10,065 1,850 18% 2215-436-460431-153 HEALTH INSURANCE 19,190 22,649 3,459 15% 2215-436-460431-155 RETIREMENT 6,232 7,304 1,072 15% 2215-436-460431-229 MISC. SUPPLIES 5,767 11,138 5,371 48% 2215-436-460431-231 GAS 161 584 423 72% 2215-436-460431-320 PRINTING & ADVERTISING 368 9,300 8,932 96% 2215-436-460431-345 TELEPHONE & COMMUNICATION 545 664 119 18% 2215-436-460431-354 CONTRACT SERVICES 25,971 27,550 1,580 6% 2215-436-460431-357 MUSIC FRANCHISE FEES 1,153 1,250 97 8% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 11 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2215-436-460431-373 DUES & TRAINING 369 700 331 47% SUBTOTAL RECREATION 146,246 174,564 28,318 16% YOUTH CAMPS 2215-436-460448-110 SALARIES -YOUTH CAMPS 69,996 73,603 3,607 5% 2215-436-460448-111 SEASONAL SALARIES 127,665 139,364 11,699 8% 2215-436-460448-121 OVERTIME 3 150 147 98% 2215-436-460448-153 HEALTH INSURANCE 18,363 21,805 3,442 16% 2215-436-460448-155 RETIREMENT 5,454 6,765 1,311 19% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 448 250 198- -79% 2215-436-460448-229 MISC. SUPPLIES 5,169 3,520 1,649- -47% 2215-436-460448-231 GAS 37 338 301 89% 2215-436-460448-320 PRINTING & ADVERTISING 27 295 268 91% 2215-436-460448-345 TELEPHONE & COMMUNICATION 984 1,352 368 27% 2215-436-460448-354 CONTRACT SERVICES 13,126 12,870 256- -2% 2215-436-460448-355 AFTER SCHOOL PROGRAM 669 1,200 531 44% 2215-436-460448-356 BANK FEES/CC CHARGES 3,243 4,000 757 19% 2215-436-460448-373 DUES & TRAINING 509 700 191 27% SUBTOTAL YOUTH CAMPS 245,693 266,212 20,519 8% POOL 2215-437-460445-111 SEASONAL SALARIES -POOL 152,938 171,808 18,870 11% 2215-437-460445-121 OVERTIME 50 200 150 75% 2215-437-460445-155 RETIREMENT 187 1,500 1,313 88% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 213 500 287 57% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,568 2,000 432 22% 2215-437-460445-226 CHLORINE/CHEMICALS 35,221 26,500 8,721- -33% 2215-437-460445-228 CONCESSION STAND SUPPLIES 16,364 20,000 3,636 18% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 1,166 4,000 2,834 71% 2215-437-460445-341 ELECTRICITY 7,169 9,000 1,831 20% 2215-437-460445-344 NATURAL GAS 9,604 21,500 11,896 55% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,947 2,550 603 24% 2215-437-460445-354 LICENSES & FEES 1,366 1,300 66- -5% 2215-437-460445-356 BANK FEES/ CC CHARGES 1,894 3,200 1,306 41% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 16,420 18,095 1,675 9% 2215-437-460445-380 TRAINING MATERIALS 114 1,800 1,686 94% SUBTOTAL POOL EXPENDITURES 246,221 283,953 37,732 13% TOTAL PARKS & RECREATION/POOL 1,576,299 1,833,985 257,686 14% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 12 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. URBAN FORESTRY 2600-436-460433-110 SALARIES -URBAN FORESTRY 168,758 194,961 26,203 13% 2600-436-460433-111 SEASONAL SERVICES 22,808 40,963 18,155 44% 2600-436-460433-121 OVERTIME 33 1,000 967 97% 2600-436-460433-153 HEALTH INSURANCE 33,233 38,982 5,749 15% 2600-436-460433-155 RETIREMENT 14,401 18,128 3,727 21% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 2,214 3,600 1,386 38% 2600-436-460433-231 GAS 4,712 7,000 2,288 33% 2600-436-460433-241 CONSUMABLE TOOLS 6,910 11,100 4,190 38% 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 649 660 11 2% 2600-436-460433-354 CONTRACT SERVICES 119,617 150,000 30,383 20% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 3,574 4,000 426 11% 2600-436-460433-362 EQUIPMENT MAINTENANCE 3,794 4,000 206 5% 2600-436-460433-364 LANDSCAPING & TREES 4,874 8,000 3,127 39% 2600-436-460433-373 DUES & TRAINING 3,408 4,000 592 15% 2600-436-460433-395 EQUIPMENT RENTAL 5,202 6,000 798 13% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 2,959 4,000 1,042 26% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 7,839 7,840 1 0% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 21,110 21,110 0- 0% 2600-436-460433-528 DATA PROCESSING TRANSFER 4,547 4,547 0- -0% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 16,859 16,859 0- 0% 2600-436-460433-620 INTEREST EXPENSE 1,353 1,496 143 10% TOTAL URBAN FORESTRY 448,855 548,246 99,391 18% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 13 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2230 AMBULANCE FUND REVENUE: 2230-000-331992-000 CARES ACT REIMBURSEMENT THRU STATE 117,725 0 117,725- 0% 2230-000-342050-000 FEES FOR SERVICES 697,430 719,000 21,570 3% 2230-000-342070-000 COUNTY EMS LEVY 63,042 120,000 56,958 47% 2230-000-381050-000 INCEPTION OF LEASE 0 190,000 190,000 100% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 110,000 280,000 170,000 61% TOTAL AMBULANCE REVENUE 988,197 1,309,000 320,803 25% AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 653,764 682,105 28,341 4% 2230-440-420730-114 COMPTIME BUYBACK 0 3,500 3,500 100% 2230-440-420730-115 OUT OF RANK PAY 4,213 2,500 1,713- -69% 2230-440-420730-121 OVERTIME 28,354 30,000 1,646 5% 2230-440-420730-153 HEALTH INSURANCE 147,319 145,660 1,659- -1% 2230-440-420730-155 RETIREMENT 84,988 88,145 3,157 4% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 1,291 3,400 2,109 62% 2230-440-420730-218 NON -CAPITAL EQUIPMENT 3,012 4,200 1,188 28% 2230-440-420730-231 GAS & OIL 4,746 7,560 2,814 37% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 3,636 4,000 364 9% 2230-440-420730-312 POSTAGE/PRINTING 0 1,000 1,000 100% 2230-440-420730-345 TELEPHONE & COMMUNICATION 1,136 1,700 564 33% 2230-440-420730-354 CONTRACT SERVICES 13,044 19,990 6,946 35% 2230-440-420730-355 911 CENTER CONTRIBUTION 36,600 36,600 0 0% 2230-440-420730-359 AUDIT/CC OTHER FEES 3,916 1,650 2,266- -137% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 2,516 5,000 2,484 50% 2230-440-420730-373 DUES & TRAINING 3,647 5,000 1,353 27% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 295- 2,500 2,795 112% 2230-440-420730-391 MEDICAL TREATMENT -SUPPLIES 40,270 51,241 10,971 21% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 8,555 8,555 0 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 18,009 18,009 0- 0% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 47,276 47,276 0 0% 2230-440-420730-528 DATA PROCESSING TRANSFER 18,189 18,189 0 0% 2230-440-420730-610 PRINCIPAL - AMBULANCE 0 19,000 19,000 100% 2230-440-420730-620 INTEREST - AMBULANCE 0 3,202 3,202 100% 2230-440-420730-943 AMBULANCE 0 190,000 190,000 100% TOTAL AMBULANCE EXPENDITURES 1,124,187 1,399,982 275,795 20% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 14 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. PUBLIC SAFETY IMPACT FEE REV 2399-000-341072-000 POLICE IMPACT FEES 2399-000-341073-000 FIRE IMPACT FEES 2399-000-371010-000 INVESTMENT EARNINGS TOTAL PS IMPACT FEE REV PUBLIC SAFETY IMPACT FEE EXP 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 2399-413-420140-940 POLICE EQUIPMENT 2399-416-420400-940 FIRE DEPT. EQUIPMENT TOTAL PS IMPACT FEE EXP FIRE & HAZMAT GRANTS 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 2956-416-420415-940 AFG GRT FY20 SCBA TOTAL FIRE GRANTS 2957-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 2957-416-420410-125 PASS THRU HAZMAT OT 2957-416-420410-218 PASS THRU HAZMAT EQUIP 2957-416-420410-373 PASS THRU HAZMAT TRAVEL TOTAL HAZMAT GRANTS 40,340 10,000 30,340- -303% 148,692 150,000 1,308 1% 16,696 13,000 3,696- -28% 205,729 173,000 32,729- -19% 10,000 10,000 0 0% 0 100,000 100,000 100% 0 750,000 750,000 100% 10,000 860,000 850,000 99% 1,600 6,000 4,400 73% 0 346,000 346,000 100% 1,600 352,000 350,400 100% 3,778 0 3,778- 0% 826 4,000 3,174 79% 1,004 12,000 10,996 92% 643 2,500 1,857 74% 6,252 ------------ ------------- 18,500 12,248 ------------ ------------ 66% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 15 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 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 628,278 400,000 228,278- -57% 2394-000-323103-000 PLUMBING PERMITS 38,195 35,000 3,195- -9% 2394-000-323104-000 MECHANICAL PERMITS 49,501 35,000 14,501- -41% 2394-000-323105-000 ELECTRICAL PERMITS 70,579 60,000 10,579- -18% 2394-000-323108-000 PLAN REVIEW FEES 192,116 160,000 32,116- -20% 2394-000-371010-000 INVESTMENT EARNINGS 25,507 18,000 7,507- -42% TOTAL REVENUE 1,004,176 708,000 296,176- -42% BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES -BUILDING DEPT. 513,235 520,711 7,476 1% 2394-420-420530-112 SALARIES -SEVERANCE 23,212 55,872 32,660 58% 2394-420-420530-121 OVERTIME 16,952 20,000 3,048 15% 2394-420-420530-153 HEALTH INSURANCE 90,311 95,503 5,192 5% 2394-420-420530-155 RETIREMENT 40,803 39,529 1,274- -3% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 28,016 20,000 8,016- -40% 2394-420-420530-231 GAS & OIL 2,591 5,000 2,409 48% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 6,314 7,300 986 14% 2394-420-420530-323 ST. ED. ASSESSMENTS 1,471 7,500 6,029 80% 2394-420-420530-345 TELEPHONE & COMMUNICATION 6,772 6,000 772- -13% 2394-420-420530-353 AUDITING 4,500 4,500 0 0% 2394-420-420530-354 CONTRACT SERVICES 18,523 20,000 1,477 7% 2394-420-420530-355 CITY WORKS LICENSING FEE 16,757 16,000 757- -5% 2394-420-420530-356 ArcGIS SERVER UPGRADE LICENSE 2,500 6,000 3,500 58% 2394-420-420530-357 CREDIT CARD / PAYPAL FEES 6,954 15,000 8,046 54% 2394-420-420530-360 FURNITURE 8,687 4,000 4,687- -117% 2394-420-420530-373 DUES & TRAINING 11,969 35,000 23,031 66% 2394-420-420530-510 PROPERTY INSURANCE 8,184 10,000 1,816 18% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 1,342 1,342 0- -0% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 33,156 33,156 0 0% 2394-420-420530-528 DATA PROCESSING TRANSFER 31,831 31,831 0 0% 2394-420-420530-920 BUILDING IMPROVEMENTS 810 200,000 199,190 100% TOTAL BUILDING DEPT. 874,891 1,154,244 279,353 24% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 16 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 83,448 86,741 3,293 4% 2400-410-430263-153 HEALTH INSURANCE 12,306 15,533 3,227 21% 2400-410-430263-155 RETIREMENT 6,397 6,589 192 3% 2400-410-430263-244 STREET LIGHT SUPPLIES 854 18,000 17,146 95% 2400-410-430263-245 LUMINAIRES 16,982 30,000 13,018 43% 2400-410-430263-246 LED LUMINAIRE UPGRADE 16,224 32,655 16,431 50% 2400-410-430263-341 ELECTRICITY 144,229 182,000 37,771 21% 2400-410-430263-360 REPAIR & MAINT SERVICES 1,707 20,000 18,293 91% 2400-410-430263-373 DUES & TRAINING 1,125 1,000 125- -13% 2400-410-430263-510 INSURANCE 1,232 1,500 268 18% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 15,457 15,457 0- 0% TOTAL LIGHT MAINT. 299,962 409,475 109,513 27% 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 33,612 114,683 81,071 71% 2420-421-430234-957 ALLEY PAVING 71,195 67,180 4,015- -6% 2420-421-430240-231 GAS & OIL 22,417 42,000 19,583 47% 2420-421-430240-344 NATURAL GAS 1,442 6,800 5,358 79% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 100% 2420-421-430240-360 REPAIR & MAINT SERVICES 900 1,500 600 40% 2420-421-430240-368 OVERLAY/CHIPSEALS 32,936 318,578 285,642 90% 2420-421-430240-452 GRAVEL 3,498 5,000 1,502 30% 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 49,907 53,000 3,093 6% 2420-421-430240-472 ASPHALT 10,748 40,000 29,252 73% 2420-421-430240-473 CRACK SEALING 14,460 14,500 40 0% 2420-421-430240-474 PAINT STRIPING MATERIALS 30,140 30,000 140- -0% TOTAL GAS TAX 271,255 ------------ ------------- 718,241 446,986 ------------ ------------ 62% BARSAA (GAS TAX) 2421-421-430240-354 PAVEMENT MAINTENANCE TOTAL BARSAA 2825 MACI GRANT 2825-421-430240-940 EQUIPMENT TOTAL MACI GRANT 622,386 420,000 202,386- -48% 622,386 420,000 202,386- -48% 0 205,000 205,000 100% 0 205,000 205,000 100% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 17 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 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. 779,087 805,569 26,482 3% 2500-421-430240-121 OVERTIME 3,469 28,000 24,531 88% 2500-421-430240-153 HEALTH INSURANCE 166,652 177,425 10,773 6% 2500-421-430240-155 RETIREMENT 59,488 60,533 1,045 2% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 14,345 16,360 2,015 12% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 6,735 7,000 265 4% 2500-421-430240-220 OTHER SUPPLIES 3,828 4,500 672 15% 2500-421-430240-231 GAS & OIL 23,321 42,000 18,679 44% 2500-421-430240-341 ELECTRICITY 2,341 3,500 1,159 33% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 1,386 1,700 314 18% 2500-421-430240-354 CONTRACT SERVICES 7,621 22,500 14,879 66% 2500-421-430240-356 TRANSPORTATION PLAN 159,438 187,150 27,712 15% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 35,244 33,500 1,744- -5% 2500-421-430240-366 BUILDING MAINTENANCE 22,193 26,375 4,182 16% 2500-421-430240-373 DUES & TRAINING 3,763 7,500 3,737 50% 2500-421-430240-388 MEDICAL SERVICES 310 1,000 690 69% 2500-421-430240-510 LIABILITY INSURANCE 30,260 30,260 0 0% 2500-421-430240-512 UNINSURED LOSS -DEDUCTIBLE 24,184 11,269 12,915- -115% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 195,464 195,464 0- 0% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 115,951 115,951 0- 0% 2500-421-430240-528 DATA PROCESSING TRANSFER 14,191 14,191 0 0% 2500-421-430240-840 MACI GRANT MATCH - WTR/DE-ICER TRK 0 10,000 10,000 100% 2500-421-430240-953 SHOP COMPLEX PAVEMENT RESTORATION 1,599 4,678 3,079 66% 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 24,956 24,955 1- 0% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 14,032 14,032 0 0% 2500-421-430244-354 PAVEMENT REPAIRS -PAVEMENT MNT FUNDS 533,822 873,166 339,344 39% 2500-421-430244-820 TRANSFER TO BaRSAA 22,282 20,000 2,282- -11% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 150,845 158,000 7,155 5% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 100% TOTAL STREET MAINT. 2,416,804 2,924,406 507,602 17% SIGNS AND SIGNALS 2500-421-430264-110 TSS - SALARIES 104,669 103,256 1,413- -1% 2500-421-430264-121 OVERTIME 0 7,500 7,500 100% 2500-421-430264-153 HEALTH INSURANCE 27,433 29,676 2,243 8% 2500-421-430264-155 RETIREMENT 7,903 7,685 218- -3% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 3,485 3,775 290 8% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 8,248 6,700 1,548- -23% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 3,553 3,500 53- -2% 2500-421-430264-242 STREET SIGNS 31,070 30,000 1,070- -4% 2500-421-430264-243 TRAFFIC SIGNALS 9,744 30,000 20,256 68% 2500-421-430264-245 BARRICADE MATERIALS 4,393 6,000 1,607 27% 2500-421-430264-341 ELECTRICITY 1,635 3,000 1,365 46% 2500-421-430264-345 COMMUNICATIONS 556 850 294 35% 2500-421-430264-354 CONTRACT SERVICES 2,603 10,000 7,397 74% 2500-421-430264-362 EQUIPMENT MAINTENANCE 677 3,000 2,323 77% 2500-421-430264-366 BUILDING MAINTENANCE 4,620 7,375 2,755 37% 2500-421-430264-373 DUES & TRAINING 3,901 7,000 3,099 44% 2500-421-430264-428 PAINT MATERIALS 359 5,000 4,641 93% 2500-421-430264-510 LIABILITY INS.-TSS 2,214 3,000 786 26% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 18 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2500-421-430264-512 UNINSURED LOSS -DEDUCTIBLE 0 2,777 2,777 100% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 7,502 7,502 0 0% 2500-421-430264-532 OFFICE RENT 6,421 6,422 1 0% 2500-421-430264-940 MACHINERY & EQUIPMENT 39,591 47,000 7,409 16% TOTAL SIGNS AND SIGNALS 270,579 331,018 60,439 18% TOTAL STREET MAINT. & SIGNS 2,687,382 3,255,424 568,042 17% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 19 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2188 WESTSIDE TIF REVENUE 2188-000-334200-000 MT DOC - ECONOMIC DESIGN PLN -TRAIL 2188-000-365010-000 MISC. REVENUE 2188-000-371010-000 INVESTMENT EARNINGS 2188-000-373010-000 INTEREST / LOANS 2188-000-373020-000 PRINCIPAL / LOANS 2188-000-381060-000 TRANSFER FROM GENERAL FUND 2188-000-383001-000 TRANSFER FROM RD (2887) REIMB. TOTAL REVENUE EXPENDITURES 2188-480-470230-110 SALARIES 2188-480-470230-153 HEALTH INSURANCE 2188-480-470230-155 RETIREMENT 2188-480-470230-353 AUDIT 2188-480-470230-356 TELEPHONE 2188-480-470230-522 ADMINISTRATIVE TRANSFER 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 2188-480-470440-930 CITY MATCH - TRAIL 2188-480-470440-935 CITY MATCH - RAIL PARK TOTAL WESTSIDE TIF 208,279 0 208,279- 0% 12,645 575,000 562,355 98% 2,641 1,000 1,641- -164% 5,408 0 5,408- 0% 5,684 0 5,684- 0% 1,700,000 1,200,000 500,000- -42% 250,000 0 250,000- 0% 2,184,656 1,776,000 408,656- -23% 45,263 46,104 841 2% 8,906 9,381 475 5% 3,646 3,664 18 0% 3,000 3,000 0 0% 192 192 0 0% 4,675 4,675 0- -0% 1,183,698 1,500,000 316,302 21% 286,101 200,000 86,101- -43% 37,984 28,455 9,529- -33% 1,573,465 1,795,471 222,006 12% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 20 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 1,600 1,600 0 0% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 13,584 13,584 0- 0% 2185-000-430300-840 REDEVELOPMENT ACTIVITY 1,069,518 3,316,334 2,246,816 68% 2185-480-470240-110 SALARIES 21,181 21,321 140 1% 2185-480-470240-153 HEALTH INSURANCE 4,998 4,647 351- -8% 2185-480-470240-155 RETIREMENT 1,707 1,703 4- -0% 2185-480-470240-345 TELEPHONE & COMMUNICATION 48 48 0 0% TOTAL 2185 AIRPORT TIF 1,112,636 3,359,237 2,246,601 67% OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 9,717 9,700 17- -0% 2310-480-470210-356 FED -EX REIMBURSEMENT 9,217 9,200 17- -0% 2310-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 0 45,000 45,000 100% 2311-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 0 5,000 5,000 100% TOTAL OLD SCHOOL TIFS 18,934 68,900 49,966 73% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 21 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 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 0% 2880-480-470210-354 CONTRACT SERVICES 575 1,000 425 43% 2880-480-470210-711 REDEVELOPMENT 14,191 225,000 210,809 94% TOTAL LOAN REVOLVING 15,766 227,000 211,234 93% 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-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. 42 2886 CD MISC. OFFICE SUPPLIES AUDITING DUES & TRAINING MEETINGS STUDIES/SURVEYS & MARKETING ADMINISTRATIVE TRANSFER DATA PROCESSING TRANSFER OFFICE RENT 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 405 0 0% 0 250,000 250,000 100% 405 250,405 250,000 100% 0 2,000 2,000 100% 1,000 1,000 0 0% 90 2,000 1,910 96% 164 1,000 836 84% 0 5,000 5,000 100% 2,000 2,000 0 0% 9,094 9,094 0- 0% 646 646 0 0% 0 4,000 4,000 100% 44,704 0 44,704- 0% 57,698 26,740 30,958- -116% 472 0 472- 0% 18,826 18,826 0 0% 3,248 3,248 0- 0% 250,000 400,000 150,000 38% 272,546 422,074 149,528 35% 405 0 405- 0% 8,384 8,384 0- 0% 1,641 1,641 0 0% 0 300,000 300,000 100% 10,430 310,025 299,595 97% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 22 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 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 2953-480-470210-373 TRAVEL/PETROLEUM 2953-480-470215-354 CONT SERV/HAZARDOUS 2953-480-470215-373 TRAVEL/HAZARDOUS TOTAL EPA BROWNSFIELD 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES -PETROLEUM 2955-480-470210-373 TRAVEL -PETROLEUM 2955-480-470210-725 REVOLVED FUNDS -PETROLEUM 2955-480-470215-229 SUPPLIES -HAZARDOUS SUBSTANCES TOTAL BROWNFIELDS LOAN REV. 2991 TIGER GRANT 2991-480-470245-790 REDEVELOPMENT - TRAIL TOTAL TIGER GRANT 56,915 185,592 128,677 69% 514 1,943 1,429 74% 31,883 37,108 5,225 14% 0 1,958 1,958 100% 89,312 226,601 137,289 61% 0 219,251 219,251 100% 929 0 929- 0% 0 100,500 100,500 100% 0 267,673 267,673 100% 929 587,424 586,495 100% 0 3,803,909 3,803,909 100% 0 3,803,909 3,803,909 100% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 23 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 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 2915-413-420140-373 TRAVEL TOTAL 2915 STONEGARDEN GRANT 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 2916-413-420140-121 OVERTIME 2916-413-420140-153 HEALTH INSURANCE 2916-413-420140-155 RETIREMENT 2916-413-420140-354 CONTRACT SERVICES TOTAL 2916 DRUG ENFORCEMENT 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 2919-413-420140-127 SCHOOL DIST. OT 2919-413-420140-218 JAG GRT/BODY ARMOR & BODY WORN CAME 2919-413-420140-220 EQUIPMENT -FUNDED BY DONATIONS 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS TOTAL LAW ENF. GRANT 7,049 10,000 2,951 30% 208 0 208- 0% 7,257 ------------ ------------- 10,000 ------------ 2,743 ------------ 27% 60,148 65,117 4,969 8% 11,016 8,000 3,016- -38% 11,230 11,934 704 6% 7,593 8,751 1,158 13% 0 7,800 7,800 100% 89,988 101,602 11,614 11% 1,505 4,000 2,495 62% 16,469 36,000 19,531 54% 6,552 20,000 13,448 67% 4,938 10,279 5,341 52% 11,859 4,000 7,859- -196% 7,149 7,000 149- -2% 48,473 81,279 32,806 40% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 24 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. CAPITAL PROJECT FUNDS 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION TOTAL 4290 WALK & CURB 15,712 25,000 9,288 37% 15,712 25,000 9,288 37% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 25 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. ENTERPRISE FUNDS WATER REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 1,035 1,000 35- -4% 5210-000-343210-000 METERED WATER SALES 3,033,976 3,000,000 33,976- -1% 5210-000-343220-000 UNMETERED WATER SALES 21,662 15,000 6,662- -44% 5210-000-343230-000 METER REPLACEMENT FEE 105,404 100,000 5,404- -5% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 59,234 55,000 4,234- -8% 5210-000-343270-000 WATER TURN ON FEES 5,145 4,000 1,145- -29% 5210-000-343275-000 TAG FEE 39,760 45,000 5,240 12% 5210-000-371010-000 INVESTMENT EARNINGS 148,279 105,000 43,279- -41% 5210-000-383010-000 TRANSFER FROM IMPACT FEE FUN (10100 25,000 25,000 0 0% 5210-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 309,058 309,058 0 0% TOTAL WATER REVENUE 3,748,553 3,659,058 89,495- -2% WATER FACILITIES 5210-447-430550-110 SALARIES -WATER 604,866 774,817 169,951 22% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 8,003 20,000 11,997 60% 5210-447-430550-153 HEALTH INSURANCE 128,036 174,095 46,059 26% 5210-447-430550-155 RETIREMENT 46,800 58,417 11,617 20% 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 14,928 22,000 7,072 32% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 6,566 8,500 1,934 23% 5210-447-430550-226 CHLORINE & CHEMICALS 32,493 39,000 6,507 17% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 4,048 4,500 452 10% 5210-447-430550-231 GAS & OIL 20,010 35,000 14,990 43% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 965 1,000 35 3% 5210-447-430550-336 LICENSES & FEES 17,906 18,500 594 3% 5210-447-430550-341 ELECTRICITY 130,060 160,000 29,940 19% 5210-447-430550-344 NATURAL GAS 6,798 15,500 8,702 56% 5210-447-430550-345 TELEPHONE & COMMUNICATION 10,778 11,000 222 2% 5210-447-430550-349 LAB SERVICES 13,712 20,000 6,288 31% 5210-447-430550-353 AUDITING 3,500 3,500 0 0% 5210-447-430550-354 CONTRACT SERVICES 38,766 55,000 16,234 30% 5210-447-430550-355 NOFFSINGER TRANSMISSION CONDITION A 0 255,000 255,000 100% 5210-447-430550-356 CONSULTANTS 36,572 125,000 88,428 71% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 3,678 15,000 11,322 75% 5210-447-430550-366 BUILDING MAINTENANCE 11,148 16,375 5,227 32% 5210-447-430550-373 DUES & TRAINING 3,717 11,000 7,283 66% 5210-447-430550-388 MEDICAL SERVICES 1,043 600 443- -74% 5210-447-430550-410 CONSTRUCTION MATERIALS 39,216 35,000 4,216- -12% 5210-447-430550-422 HYDRANTS 4,993 10,000 5,007 50% 5210-447-430550-423 MATERIALS FOR MAINS 4,292 14,000 9,708 69% 5210-447-430550-424 MATERIALS -SERVICE LINES 11,917 12,000 83 1% 5210-447-430550-425 MATERIALS PUMPS/WELLS 3,459 45,000 41,541 92% 5210-447-430550-510 PROPERTY & LIABILITY INS. 33,256 33,256 0- 0% 5210-447-430550-512 UNINSURED LOSS -DEDUCTIBLE 635 10,000 9,365 94% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 27,002 27,002 0 0% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 122,069 122,069 0- 0% 5210-447-430550-528 DATA PROCESSING TRANSFER 33,112 33,112 0 0% 5210-447-430550-532 LEASE PAYMENTS 6,421 10,500 4,079 39% 5210-447-430550-939 FOUR MILE TRANSMISSION MAIN (PHASE 2,087,670 4,239,062 2,151,392 51% 5210-447-430550-940 MACHINERY & EQUIPMENT 36,180 45,000 8,820 20% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 26 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-948 METERS (METER FUNDS) 010125 100,584 151,263 50,679 34% 5210-447-430550-950 1ST AVE WN MAIN REPLACEMENT 0 210,213 210,213 100% 5210-447-430550-951 SECURITY SCADA UPGRADES 0 305,000 305,000 100% 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 0 4,578 4,578 100% 5210-447-430550-968 CONRAD DRIVE 0 246,511 246,511 100% 5210-447-430550-971 LOTH AVE W & 2ND ST W MAIN 23,673 535,000 511,327 96% SUBTOTAL WATER FACILITIES 3,678,873 7,937,370 4,258,497 54% WATER BILLING 5210-447-430560-110 SALARIES -WATER BILLING 118,299 117,187 1,112- -1% 5210-447-430560-153 HEALTH INSURANCE 36,741 36,809 68 0% 5210-447-430560-155 RETIREMENT 9,403 9,182 221- -2% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 7,341 7,000 341- -5% 5210-447-430560-353 AUDITING 2,000 2,000 0 0% 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 41,499 40,000 1,499- -4% 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 22,165 27,000 4,835 18% 5210-447-430560-356 OTHER CONTRACT SERVICES 424 1,500 1,076 72% 5210-447-430560-373 DUES & TRAINING 349 2,500 2,151 86% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 11,259 11,259 0- 0% 5210-447-430560-528 DATA PROCESSING TRANSFER 33,112 33,112 0 0% 5210-447-430560-532 RENT 6,421 6,422 1 0% SUBTOTAL WATER BILLING 289,013 293,971 4,958 2% REVENUE BONDS 5210-447-490200-610 PRIN - 4 MILE DR TRANSMISSION / WRF 0 78,521 78,521 100% 5210-447-490200-620 INT - 4 MILE DR TRANSMISSION / WRF 38,439 50,538 12,099 24% 5210-447-490204-610 BOND PRIN - HWY 93 S WTR - 2004 0 75,000 75,000 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 16,814 19,643 2,829 14% 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 350 350 0 0% 5210-447-490206-610 PRIN-WELL/TANK/8114 2.25% 4T ST WTR 0 89,000 89,000 100% 5210-447-490206-620 INT-WELL&TANK/8114 2.25% 4TH ST WT 16,830 16,831 1 0% 5210-447-490210-610 4TH AVE E MAIN REPLC/WRF 17393 0 80,126 80,126 100% 5210-447-490210-620 4TH AVE E MAIN REPL/WFR 17393 45,052 45,052 0- 0% 5210-447-490250-610 PRIN - WTR MAIN/ WRF 1032R 2% IDAHO 0 50,000 50,000 100% 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2%/IDAHO&MAIN 1,270 1,270 0 0% SUBTOTAL REVENUE BONDS 118,755 506,331 387,576 77% DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE SUBTOTAL DEPRECIATION TOTAL WATER FUND WATER IMPACT FEE REVENUE: 5211-000-343225-000 IMPACT FEES 0 840,000 840,000 100% 0 840,000 840,000 100% 4,086,641 9,577,672 5,491,031 57% 618,569 500,000 118,569- -24% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 27 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. 5211-000-371010-000 INTEREST EARNINGS 19,399 15,000 4,399- -29% 5211-447-430555-820 5211-447-430555-825 5211-447-430555-930 5211-447-430555-939 5211-447-430555-941 5211-447-430555-953 5211-447-430555-954 TOTAL WATER IMPACT FEES REVENU WATER IMPACT FEES EXPENSES: DEBT SERVICE TRANSFER TO 5210 TRANSFER TO 5210 FOR ADMIN CONTRACT MAIN UPSIDE FOUR MILE DR TRANSMISSION MAIN (PH METERS - NEW DEVELOPMENT SECTION 36 WELL ELEVATED STORAGE TANK AND WELL TOTAL WATER IMPACT FEE EXPENSE 637,969 515,000 122,969- -24% 309,058 309,058 0 0% 25,000 25,000 0 0% 0 440,000 440,000 100% 0 223,948 223,948 100% 45,600 45,600 0 0% 0 184,453 184,453 100% 0 448,000 448,000 100% 379,658 1,676,059 1,296,401 77% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 28 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 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,035 1,500 465 31% 5310-000-343310-000 SEWER SERVICE CHARGES 4,483,952 4,500,000 16,048 0% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 1,311 4,000 2,689 67% 5310-000-343365-000 LATECOMER ADMIN FEES 983 4,500 3,517 78% 5310-000-371010-000 INVESTMENT EARNINGS 97,139 66,500 30,639- -46% 5310-000-383010-000 ADMIN TRANSFER FROM IMPACT FEES 50,000 50,000 0 0% 5310-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 891,026 891,026 0 0% TOTAL SEWER REVENUE 5,525,445 ------------ 5,517,526 ------------- 7,919- ------------ ------------ -0% SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES -SEWER BILLING 100,922 99,549 1,373- -1% 5310-454-430620-153 HEALTH INSURANCE 28,040 27,602 438- -2% 5310-454-430620-155 RETIREMENT 7,997 7,778 219- -3% 5310-454-430620-215 OFFICE SUPPLIES/computers 7,300 7,000 300- -4% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 2,000 2,000 0 0% 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 41,499 40,000 1,499- -4% 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 22,165 27,000 4,835 18% 5310-454-430620-356 OTHER CONTRACT SERVICES 424 1,500 1,076 72% 5310-454-430620-373 DUES & TRAINING 349 2,500 2,151 86% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 10,119 10,119 0- 0% 5310-454-430620-528 DATA PROCESSING TRANSFER 33,112 33,112 0 0% 5310-454-430620-532 OFFICE RENT 6,421 6,422 1 0% SUBTOTAL SEWER BILLING COSTS 260,348 264,582 4,234 2% SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES -SANITARY SEWER 279,945 297,006 17,061 6% 5310-454-430630-121 OVERTIME 383 5,500 5,117 93% 5310-454-430630-153 HEALTH INSURANCE 61,030 80,197 19,167 24% 5310-454-430630-155 RETIREMENT 21,447 22,509 1,062 5% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 10,471 12,200 1,729 14% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 7,058 8,350 1,292 15% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 1,463 2,300 837 36% 5310-454-430630-231 GAS & OIL 8,198 12,000 3,802 32% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 119 500 381 76% 5310-454-430630-341 ELECTRICITY 44,746 57,000 12,254 22% 5310-454-430630-344 NATURAL GAS 11,527 16,500 4,973 30% 5310-454-430630-345 TELEPHONE & COMMUNICATION 21,940 26,000 4,060 16% 5310-454-430630-353 AUDITING 3,000 3,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 32,517 24,000 8,517- -35% 5310-454-430630-356 CONSULTANTS - FACILITY PLAN 36,249 185,000 148,752 80% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 9,378 11,375 1,997 18% 5310-454-430630-373 DUES & TRAINING 5,075 7,250 2,175 30% 5310-454-430630-388 MEDICAL SERVICES 576 500 76- -15% 5310-454-430630-410 CONSTRUCTION MATERIALS 11,249 10,000 1,249- -12% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 48,199 50,000 1,801 4% 5310-454-430630-510 PROPERTY & LIABILITY INS. 39,301 42,000 2,699 6% 5310-454-430630-512 UNINSURED LOSS -DEDUCTIBLE 3,695 25,000 21,305 85% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 9,435 9,435 0 0% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 29 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-522 ADMINISTRATIVE TRANSFER 48,854 48,854 0- 0% 5310-454-430630-528 DATA PROCESSING TRANSFER 18,921 18,921 0 0% 5310-454-430630-532 OFFICE RENT 12,915 6,422 6,493- -101% 5310-454-430630-940 MACHINERY & EQUIPMENT 0 43,500 43,500 100% 5310-454-430630-948 REPAIR & REPLC OF SEWER MAIN 570 600,000 599,430 100% 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 0 4,673 4,673 100% 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 8,641 20,000 11,359 57% 5310-454-430630-957 WEST SIDE INTERCEPTOR (BONDED) 96,618 2,783,478 2,686,860 97% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 54,509 50,000 4,509- -9% 5310-454-430630-962 SEWER MAIN SLIP LINING 0 395,000 395,000 100% SUBTOTAL SEWER COLLECTION 908,028 4,878,470 3,970,442 81% REVENUE BONDS/SANITARY 5310-454-490200-610 PRIN - WESTSIDE INTERCEPTOR BOND 0 326,000 326,000 100% 5310-454-490200-620 INTEREST-WESTSIDE INTERCEPTOR BOND 340,025 340,026 1 0% 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.25% 0 87,000 87,000 100% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 9,709 9,709 0 0% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25% 0 350 350 100% SUBTOTAL REVENUE BONDS 349,734 763,085 413,351 54% DEPRECIATION -SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 820,000 820,000 100% SUBTOTAL DEPRECIATION -SANITARY 0 820,000 820,000 100% SUBTOTAL SANITARY SEWER 1,257,761 6,461,555 5,203,794 81% WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 427,652 454,195 26,543 6% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-121 OVERTIME 18,461 22,500 4,039 18% 5310-455-430640-153 HEALTH INSURANCE 85,080 90,736 5,656 6% 5310-455-430640-155 RETIREMENT 34,363 34,152 211- -1% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 10,533 10,000 533- -5% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 2,507 2,700 193 7% 5310-455-430640-225 ALUM 23,799 28,000 4,201 15% 5310-455-430640-226 CHLORINE & CHEMICALS 89,627 87,000 2,627- -3% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 6,534 7,000 466 7% 5310-455-430640-231 GAS & OIL 10,991 19,000 8,009 42% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 584 400 184- -46% 5310-455-430640-336 LICENSES & FEES 14,422 12,000 2,422- -20% 5310-455-430640-341 ELECTRICITY 168,857 190,000 21,143 11% 5310-455-430640-342 WATER 6,115 7,500 1,385 18% 5310-455-430640-344 NATURAL GAS 32,918 82,000 49,082 60% 5310-455-430640-345 TELEPHONE & COMMUNICATION 6,238 6,500 262 4% 5310-455-430640-353 AUDITING 2,500 2,500 0 0% 5310-455-430640-354 CONTRACT -GLACIER GOLD 108,153 135,000 26,847 20% 5310-455-430640-355 OTHER CONTRACT SERVICES 42,863 39,000 3,863- -10% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 30 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-356 CONSULTANTS 129,065 210,960 81,895 39% 5310-455-430640-358 CONSULTANT -FACILITY PLN/RATE STDY/T 79,727 175,000 95,273 54% 5310-455-430640-360 MISC. MAINT SERVICES 27,289 30,000 2,711 9% 5310-455-430640-366 BUILDING MAINTENANCE 44,051 46,000 1,949 4% 5310-455-430640-373 DUES & TRAINING 6,490 8,500 2,010 24% 5310-455-430640-388 MEDICAL SERVICES 110 500 390 78% 5310-455-430640-510 PROPERTY & LIABILITY INS. 41,697 42,000 303 1% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 19,219 19,219 0- 0% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 122,705 122,705 0- 0% 5310-455-430640-528 DATA PROCESSING TRANSFER 23,651 23,651 0- 0% 5310-455-430640-920 TWAS ROOF REPLC 2,330 13,412 11,082 83% 5310-455-430640-930 BIOSOLIDS ALTERNATE DISPOSAL ENG 0 178,052 178,052 100% SUBTOTAL WWTP OPERATIONS 1,588,533 2,105,182 516,649 25% WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 5310-455-430645-921 E. SECONDARY CLARIFIER COATING PRJ 5310-455-430645-934 SECONDARY DIGESTER LID REPLC 5310-455-430645-940 MACHINERY & EQUIPMENT SUBTOTAL WWTP REPLACEMENT WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 5310-455-430646-121 OVERTIME 5310-455-430646-153 HEALTH INSURANCE 5310-455-430646-155 RETIREMENT 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 5310-455-430646-218 NON -CAPITAL EQUIPMENT 5310-455-430646-222 LAB SUPPLIES 5310-455-430646-349 LAB SERVICES 5310-455-430646-362 EQUIPMENT MAINTENANCE 5310-455-430646-373 DUES & TRAINING SUBTOTAL WWTP LAB OPERATIONS DEBT SERVICE - WWTP 5310-455-490227-610 PRIN - WWTP IMP/SRF8164R/2.25% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 5310-455-490228-610 PRIN-WWTP DIGESTER LID/SRF 13326 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 68,475 118,000 49,525 42% 0 75,000 75,000 100% 0 530,648 530,648 100% 120,179 125,500 5,321 4% 188,654 849,148 660,494 78% 112,704 115,308 2,604 2% 1,110 0 1,110- 0% 16,556 16,872 316 2% 8,694 8,589 105- -1% 4,939 4,500 439- -10% 2,863 2,500 363- -15% 14,915 16,500 1,585 10% 18,593 30,000 11,407 38% 5,290 5,500 210 4% 2,079 4,700 2,621 56% 187,741 204,469 16,728 8% 0 851,000 851,000 100% 161,156 161,157 1 0% 0 48,000 48,000 100% 24,510 24,510 0 0% 185,666 1,084,667 899,001 83% 0 420,000 420,000 100% 0 1,425,000 1,425,000 100% 0 1,845,000 1,845,000 100% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 31 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ACCOUNT NUMBER DESC. SUBTOTAL WWTP 2,150,595 6, 088,466 3,937,871 65% TOTAL BILLING/SANITARY/WWTP SEWER IMPACT FEE REVENUE 5311-000-343330-000 SANITARY IMPACT FEES 5311-000-343335-000 TREATMENT IMPACT FEES 5311-000-371010-000 SANITARY INTEREST EARNINGS 5311-000-371015-000 TREATMENT INTEREST EARNINGS TOTAL SEWER IMPACT FEES REVENU SEWER IMPACT FEE EXPENSES 5311-454-430635-820 TRANSFER TO 5310 FOR DEBT 5311-454-430635-825 TRANSFER TO 5310 FOR ADMIN 5311-454-430635-955 MAIN & L.S. UPSIZE 5311-454-430635-957 WEST SIDE INTERCEPTOR 5311-455-430644-820 DEBT SERVICE TRANSFER 5311-455-430644-825 TRANSFER TO 5310 FOR ADMIN 5311-455-430644-929 CONSTRUCT NEW EQ BASIN 5311-455-430644-930 BIOSOLIDS ALT. DISPOSAL ENG. (39%) TOTAL SEWER IMPACT FEE EXPENSE 3,668,705 12,814,603 9,145,898 71% 1,031,561 600,000 431,561- -72% 675,028 400,000 275,028- -69% 33,077 20,000 13,077- -65% 26,724 20,000 6,724- -34% 1,766,389 1,040,000 726,389- -70% 666,026 666,026 0 0% 30,000 30,000 0 0% 0 300,000 300,000 100% 70,192 151,487 81,295 54% 225,000 225,000 0 0% 20,000 20,000 0 0% 0 469,800 469,800 100% 0 113,837 113,837 100% 1,011,218 ------------ 1,976,150 ------------- 964,932 ------------ ------------ 49% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 32 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 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,035 0 1,035- 0% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 3,091 1,500 1,591- -106% 5349-000-343034-000 PERMIT FEES 2,735 0 2,735- 0% 5349-000-343035-000 STORM SEWER CHARGES 0 1,500 1,500 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 1,635,191 1,625,000 10,191- -1% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 2,545 1,800 745- -41% 5349-000-371010-000 INTEREST ON INVESTMENTS 39,829 35,000 4,829- -14% 5349-000-383010-000 IMPACT FEE 5% ADMIN - TFR FROM IMPA 6,500 6,500 0 0% 5349-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 0 175,568 175,568 100% TOTAL STORM REVENUE 1,690,925 1,846,868 155,943 8% STORM SEWER 5349-453-430246-110 SALARIES -STORM SEWER 453,855 476,323 22,468 5% 5349-453-430246-121 OVERTIME 420 4,000 3,580 90% 5349-453-430246-153 HEALTH INSURANCE 87,755 97,207 9,452 10% 5349-453-430246-155 RETIREMENT 34,909 36,107 1,198 3% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 12,951 16,100 3,149 20% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 3,161 6,000 2,839 47% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100% 5349-453-430246-231 GAS & OIL 7,707 11,500 3,793 33% 5349-453-430246-345 TELEPHONE & COMMUNICATION 1,909 1,500 409- -27% 5349-453-430246-353 AUDITING 1,150 1,150 0 0% 5349-453-430246-354 CONTRACT SERVICE 5,329 7,000 1,671 24% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 7,557 135,000 127,443 94% 5349-453-430246-358 CONSULTANTS 481 10,000 9,519 95% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 77 30,000 29,923 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 1,943 2,500 557 22% 5349-453-430246-362 GROUNDWATER MONITORING 4,926 6,500 1,574 24% 5349-453-430246-371 CURB & GUTTER 0 6,000 6,000 100% 5349-453-430246-373 DUES & TRAINING 4,330 7,250 2,920 40% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 358 10,000 9,642 96% 5349-453-430246-510 PROPERTY & LIABILITY INS. 9,329 16,000 6,671 42% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 9,435 9,435 0 0% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 45,133 45,133 0 0% 5349-453-430246-528 DATA PROCESSING TRANSFER 18,921 18,921 0 0% 5349-453-430246-530 BNSF LEASE PMT 4,597 6,200 1,603 26% 5349-453-430246-532 OFFICE RENT 6,421 6,422 1 0% 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 0 367,647 367,647 100% 5349-453-430246-970 REGIONAL FACILITIES & PIPING DESIGN 0 5,500,000 5,500,000 100% 5349-453-430247-952 STORM DRAIN CORRECTION 10,856 249,323 238,467 96% 5349-453-430247-953 SHOP COMPLEX PAVEMNT 0 23,008 23,008 100% 5349-453-430247-954 N. MAIN ST STORMWATER PROJ. 0 252,500 252,500 100% 5349-453-430247-956 WYOMING STREET OUTFALL 0 225,000 225,000 100% 5349-453-430247-959 REGIONAL FACILITIES & PIPING DESIGN 0 400,000 400,000 100% 5349-453-430247-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% 5349-453-430249-940 MACHINERY FROM REPLACEMENT 0 56,500 56,500 100% SUBTOTAL STORM OPERATIONS 733,508 8,092,526 7,359,018 91% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 33 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM BONDS/LOANS 5349-453-490200-610 PRINCIPLE - 4TH AVE E BOND 0 2,918 2,918 100% 5349-453-490200-620 INTEREST-4TH AVE E BOND 1,641 1,641 0 0% 5349-453-490225-610 PRINCIPLE - REGIONAL FACILITIES 0 72,061 72,061 100% 5349-453-490225-620 INTEREST - REGIONAL FACILITIES 0 103,507 103,507 100% SUBTOTAL STORM BONDS/LOANS TOTAL STORM EXPENSE STORM SEWER IMPACT FEE REVENUE 5348-000-343033-000 IMPACT FEES 5348-000-371010-000 INTEREST EARNINGS 5348-453-430248-820 5348-453-430248-825 5348-453-430248-959 5348-453-430248-960 5348-453-430248-961 TOTAL STORM IMPACT FEES REVENU STORM SWR IMPACT FEE EXPENSES DEBT SERVICE TRANSFER TO 5349 TRANSFER TO 5349 FOR ADMIN REG FACILITIES & PIPING DESIGN STORMWATER FACILITIES UPSIZE NORTH REGIONAL CONVEYANCE SYSTEM TOTAL STORM IMPACT FEE EXPENSE 1,641 180,127 178,486 99% 735,149 8,272,653 7,537,504 91% 170,657 130,000 40,657- -31% 29,199 15,000 14,199- -95% 199,856 145,000 54,856- -38% 0 175,568 175,568 100% 6,500 6,500 0 0% 156,927 1,414,852 1,257,925 89% 0 230,000 230,000 100% 0 50,000 50,000 100% 163,427 1,876,920 1,713,493 91% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 34 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 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 2,935 0 2,935- 0% 5510-000-343410-000 GARBAGE COLLECTION -ASSESSED 1,044,367 1,022,000 22,367- -2% 5510-000-343420-000 GARBAGE COLLECTION -BILLED 26,160 23,500 2,660- -11% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,946 2,100 154 7% 5510-000-371010-000 INVESTMENT EARNINGS 19,289 15,000 4,289- -29% TOTAL SOLID WASTE REVENUE 1,094,697 1,062,600 32,097- -3% SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES -SOLID WASTE 401,734 428,543 26,809 6% 5510-460-430840-121 OVERTIME 4,767 6,500 1,733 27% 5510-460-430840-153 HEALTH INSURANCE 90,444 101,080 10,636 11% 5510-460-430840-155 RETIREMENT 30,892 32,232 1,340 4% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 10,962 14,500 3,538 24% 5510-460-430840-218 EQUIPMENT -GARBAGE CONTAINERS 28,494 37,500 9,006 24% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 2,673 5,500 2,827 51% 5510-460-430840-231 GAS & OIL 41,892 60,000 18,108 30% 5510-460-430840-341 ELECTRICITY 1,596 2,050 454 22% 5510-460-430840-344 NATURAL GAS 954 4,500 3,546 79% 5510-460-430840-345 TELEPHONE & COMMUNICATION 1,447 1,250 197- -16% 5510-460-430840-354 CONTRACT SERVICES 21,974 20,000 1,974- -10% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 1,114 5,700 4,586 80% 5510-460-430840-366 BUILDING MAINTENANCE 8,237 8,875 638 7% 5510-460-430840-373 DUES & TRAINING 2,737 5,500 2,763 50% 5510-460-430840-388 MEDICAL SERVICES 635 650 15 2% 5510-460-430840-510 PROPERTY & LIABILITY INS. 12,539 12,539 0 0% 5510-460-430840-512 UNINSURED LOSS -DEDUCTIBLE 3,614 4,000 386 10% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 72,450 72,450 0 0% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 44,649 44,649 0- 0% 5510-460-430840-528 DATA PROCESSING TRANSFER 14,191 14,191 0 0% 5510-460-430840-532 OFFICE RENT 6,421 6,422 1 0% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 40,000 40,000 0 0% 5510-460-430840-944 VEHICLES (Replacement $) 0 260,000 260,000 100% 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 0 4,673 4,673 100% 5510-460-430845-224 JANITORIAL SUPPLIES 356 500 144 29% 5510-460-430845-341 ELECTRICITY 1,639 3,500 1,861 53% 5510-460-430845-342 WATER 465 2,000 1,536 77% 5510-460-430845-344 NATURAL GAS 1,442 6,000 4,558 76% 5510-460-430845-360 REPAIR & MAINT SERVICES 1,350 6,000 4,650 78% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% TOTAL SOLID WASTE EXPENSE 849,668 1,361,304 511,636 38% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 35 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING INTERNAL SERVICE FUNDS INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 ENTITLEMENT SHARE PMT/HB124 185,000 140,000 45,000- -32% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 153,667 225,000 71,333 32% 6030-000-371010-000 INVESTMENT EARNINGS 3,005 1,300 1,705- -131% 6030-000-393000-000 INTERNAL SERVICES -DATA 262,331 262,331 0 0% TOTAL INFORMATION TECH REVENUE 604,003 628,631 24,628 4% INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 196,935 189,303 7,632- -4% 6030-401-410580-121 OVERTIME 51 1,000 949 95% 6030-401-410580-153 HEALTH INSURANCE 35,613 32,742 2,871- -9% 6030-401-410580-155 RETIREMENT 15,842 15,017 825- -6% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 3,119 2,300 819- -36% 6030-403-410580-215 COMPUTER SUPPLIES 1,331 2,000 669 33% 6030-403-410580-218 EQUIPMENT -NOT CAPITAL 23,262 22,840 422- -2% 6030-403-410580-325 WEBSITE 15,663 16,450 787 5% 6030-403-410580-345 PAGER/PHONE 738 900 162 18% 6030-403-410580-346 SUMMITNET & ISPS 7,083 28,140 21,057 75% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,597 4,000 403 10% 6030-403-410580-354 MAINTENANCE CONTRACTS 12,340 45,000 32,660 73% 6030-403-410580-355 LICENSES 16,935 20,185 3,250 16% 6030-403-410580-356 MAINTENANCE CONTRACTS 75,442 60,300 15,142- -25% 6030-403-410580-357 GRANICUS 5,280 5,300 20 0% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 64,436 61,011 3,425- -6% 6030-403-410580-373 DUES & TRAINING 8,521 8,275 246- -3% 6030-403-410580-510 INSURANCE 2,017 3,000 983 33% 6030-403-410583-218 TV -Video Equipment & programming 5,644 7,000 1,356 19% 6030-403-410585-229 COPIER,FAX, SUPPLIES 13,990 18,870 4,881 26% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 81,812 122,000 40,188 33% 6030-403-410585-532 COPIER LEASES 14,990 15,160 170 1% 6030-403-410585-942 Servers - capital contingency 57,796 71,000 13,204 19% 6030-403-510400-831 DEPRECIATION EXPENSE 0 10,000 10,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 3,726 3,870 144 4% 6030-405-410588-940 NETWORK EQUIPMENT 0 28,000 28,000 100% 6030-410-410588-218 COMPUTERS - DPW 4,016 4,440 424 10% 6030-413-410588-218 COMPUTERS - POLICE DEPT 21,137 28,150 7,013 25% 6030-413-410588-354 POLICE - HOSTED SERVER 2,430 2,400 30- -1% 6030-416-410588-218 COMPUTERS - FIRE 13,021 16,870 3,849 23% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 1,807 2,300 493 21% 6030-436-410588-218 COMPUTERS - PARKS 3,395 4,000 605 15% 6030-480-410588-218 COMMUNITY DEVELOPMENT 1,328 1,870 542 29% TOTAL INFORMATION TECH EXPENSE 713,298 853,693 140,395 16% 07.14.2020 08:46 THE CITY OF KALISPELL, MONTANA Page 36 of 36 gb8501_pg.php/Job No: 32357 USER: RGW PRELIMINARY FY20 FINANCIAL REPORT thru JUNE 30 100.00 % Yr Complete For Fiscal Year: 2020 / 6 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 536,000 536,000 0 0% 6010-000-371010-000 INVESTMENT EARNINGS 2,388 1,000 1,388- -139% TOTAL CENTRAL GARAGE REVENUE 538,388 537,000 1,388- -0% CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 159,517 162,350 2,833 2% 6010-410-431330-121 OVERTIME 1,229 2,500 1,271 51% 6010-410-431330-153 HEALTH INSURANCE 38,700 42,455 3,755 9% 6010-410-431330-155 RETIREMENT 11,769 12,130 361 3% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 8,532 11,000 2,468 22% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 11,058 8,000 3,058- -38% 6010-410-431330-230 OIL 19,282 25,000 5,718 23% 6010-410-431330-231 GAS 576 1,500 924 62% 6010-410-431330-232 VEHICLE PARTS 131,554 126,000 5,554- -4% 6010-410-431330-233 TIRES 48,865 50,000 1,135 2% 6010-410-431330-238 FILTERS 6,506 8,500 1,994 23% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 2,088 2,000 88- -4% 6010-410-431330-341 ELECTRICITY 2,097 1,950 147- -8% 6010-410-431330-344 NATURAL GAS 1,787 6,500 4,713 73% 6010-410-431330-354 CONTRACT SERVICES 23,529 32,000 8,471 26% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 109,308 126,375 17,067 14% 6010-410-431330-373 DUES & TRAINING 3,552 7,500 3,948 53% 6010-410-431330-388 MEDICAL SERVICES 145 425 280 66% 6010-410-431330-510 INSURANCE 3,041 4,500 1,459 32% 6010-410-431330-528 INFORMATION TECH TRANSFER 9,460 9,460 0- 0% 6010-410-431330-921 PARTS WASHER 0 10,500 10,500 100% TOTAL CENTRAL GARAGE EXPENSES 592,595 650,645 58,050 9%