The URL can be used to link to this page

01-29-21 City Manager Report1 City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 1/29/2021 1.Parks Department Forestry crews are pruning small trees in the Northland Subdivision while the large tree crew is on 4th Avenue East between 11th Street East and 12th Street East. Due to increased interest in our Learn to Skate program this year, we opened a fifth and final session of ice skating lessons: February 23 through March 4. We have seeing a 52% increase from last year’s registration numbers, which was a record year for us. Session 4 will begin on Tuesday, February 2. We started our Kalispell Kickers indoor soccer league at Rankin Elementary School on Saturday, January 23. Due to an increased number of teams this year, we are dropping the mid- court curtain and splitting the gym to allow for additional games. We have 24 teams this year versus 16 teams last year. Our early registration deadline for Little Dribblers youth basketball league (preK-2nd grade) is Friday, February 5. The regular registration deadline is February 19. 2.Police Department With the assignment of Sergeant Sean Keller, the Kalispell Police Department went through a selection process to fill his vacated position as the School Resource Officer at Flathead High School. Interviews were conducted with collaboration from representatives of SD5. Officer Eric Brinton was selected to fill that role. Officer Brinton is a seven-year veteran of the Kalispell Police Department. He started in the SRO role on January 25. Court Security Officer Mike McGilvary continues to attend to his duties attending jury trials, court hearings, and open court. He assists with transports, freeing patrol officer time that previously would have been obligated. He is also training to assist the evidence division in dealing with lost/abandoned property and bicycles while not in court hearings. This allows the evidence technician more time to focus on her primary duties. 2 The co-responder program has been dispatched to more than 260 calls in the City of Kalispell since September 1. This is impressive as the co-responders are responsible for calls throughout the valley. Officer feedback has been exceptionally positive for the program. Calls for service stand at 2321 for 2021. This compares with 2533 this time in 2020, and 2790 in 2019. 3.Fire Department Since the last update the Kalispell Fire Department has received 157 calls for service. Fire department staff are working on 2020 year-end numbers and information for reporting. This includes reviewing the fire reports that are uploaded to the National Fire Incident Reporting System (NFIRS). All calls for service receive one of these reports and must be verified to contain pertinent information required by the database. For the calendar year of 2020, we received a total of 3931 calls for service. This is approximately a 5.5% increase in calls for service from the previous year of 3725. Fire department staff are planning for the upcoming new employee training for three employees. With no active academies being offered in the state, we will conduct the training academy in-house. 4.Planning Department The Planning Board will hold a work session on February 9 to discuss two work items. The first item is a series of growth policy map amendments initiated by the City to update certain areas to reflect changing conditions, such as the construction of the bypass and the pending Parkline Trail construction. The second item is the Downtown Historic District Standards. The development of the standards was initiated by the BID, which secured a grant to hire a consultant to help formulate architectural design standards for the historic area. Prior to the Planning Board work session, staff will also present the draft standards to the BID and the Architectural Review Committee for feedback. 5.Building Department In the last 2 weeks, we have issued permits for 8 single-family homes and 6 townhomes. That will bring the total of new single-family/duplex and townhouse units for the year to 17, compared to 17 last year at this time. The permit was issued for the second Frugals Restaurant located at 635 Treeline Rd. The project is valued at $62,000. There was a total of 139 combined building and/or fire inspections completed in the last 2 3 weeks. Residential – 74 Plumbing – 7 Commercial – 15 Mechanical - 8 Electrical – 11 Fire - 24 6. Community Development The quarterly reports on the USDOT BUILD grant (Kalispell Bypass: Foys Lake Section) were submitted to the Federal Highways Administration on January 14 and Brownfields quarterly reports were submitted the last week of January. Brownfields Petroleum Phase I Environmental Site Assessment (ESA) eligibility determinations have been submitted to EPA Region 8 Office for two properties in the Core Area. These sites have received prerequisite approval of Montana DEQ for use of the City’s Brownfields grant funds to complete the Phase I’s. Once approved by EPA, work could be completed in the coming weeks in anticipation of end of February closings. 7. Public Works Annual Bio-Solids Report The City of Kalispell Wastewater Treatment Plant maintains and operates Bio-Solids Disposal under the regulatory oversight of United States Environmental Protection Agency (EPA). Annually staff reports the amounts of bio-solids generated at the Kalispell WWTP by completing and filing a “Bio-Solids Report Form”. Generally, the report consists of reporting the tonnage production of bio-solids. In 2020, the WWTP process generated 674 dry tons of bio-solids. 476 dry tons was delivered to Glacier Gold LLC for composting, and 198 dry tons was delivered to the Flathead County Solid Waste Landfill. Surplus Equipment up for Auction The City of Kalispell uses a web-based auction site “Public Surplus” to sell surplus equipment and vehicles. Currently, the City has 8 items posted on the Public Surplus website. The items can be viewed and bid on by the public using the following link: https://www.publicsurplus.com/sms/kalispell,mt/list/current?orgid=292964. 8. Finance Department Quarterly Finance Report Attached, please find the printouts reflecting the activity for the 1st half of fiscal year 2021. This printout reflects payroll earned thru Dec. 19, 2020, and accounts payable 4 claims received by the end of December. Debt service funds are not included. GENERAL FUND The general fund receives about 63% of its revenue from tax levies (general and permissive health), and another 25% from intergovernmental revenues (entitlement share, etc.). Generally speaking, for every $1,000,000 of budgeted expenditures the general fund should have $200,000 of cash carryover on July 1. State law allows a 50% carryover for tax supported funds, since taxes aren’t received by the City until January and July. 50% is needed in some municipalities to pay 6 months of bills. The City of Kalispell has enough non-tax revenue in the general fund to reduce the necessary carryover to 20%-30%. Beginning cash carryover was 24% (FY20) and 31% (FY21). 0 2000 4000 6000 8000 Ju l y 2 0 2 0 Au g u s t 20 2 0 Se p t e m b e r 20 2 0 Oc t o b e r 20 2 0 No v e m b e r 20 2 0 De c e m b e r 20 2 0 en d De c e m b e … GENERAL FUND FY21 MONTHLY CASH/EXP/REV (in 1000's) EXPENDITURES REVENUES CASH BAL General Fund tax revenue reflects taxes collected thru December 31. Some first half taxes aren’t received by the City until the County completes the distribution in January. The City has not yet received the January distribution. Last year, the general fund received over $600,000 of first half taxes in January. A similar distribution this January would bring collections to about 58% of the fiscal year 2021 budgeted amount of $6,463,000. The City is currently carrying just over $17,000 in protest taxes. Liquor licenses are billed once a year and are due by June 30. Planning fees and site review fees have already exceeded budgeted amounts. The CARES Act has reimbursed almost $900,000 in presumptive employees (law enforcement and emergency services) earnings. City Court fines and fees revenue reflect July thru November (5 months). General Fund expenditures reflect 41% spent. Some major expenditures such as liability and property insurance are paid during the first quarter for the entire year. This can result in expenditures not being evenly distributed over the fiscal period. PARKS The parks fund is a hybrid tax/charge for services fund that receives approximately 2/3 of its revenue from tax levies (general and permissive health). A majority of parks charges for services revenue is received in the 2nd half of the fiscal year. Similar to a tax supported fund, the parks fund should have enough cash available at July 1 (and January 5 1) to pay expenditures, less revenues other than taxes, through December (June). Beginning cash carryover was 50% (FY20) and 48% (FY21). $0 $200 $400 $600 $800 $1,000 Ju l y 2 0 2 0 Au g u s t 20 2 0 Se p t e m b e r 20 2 0 Oc t o b e r 20 2 0 No v e m b e r 20 2 0 De c e m b e r 20 2 0 en d De c e m b e r … PARKS FY21 MONTHLY CASH/EXP/REV (in 1000's) EXPENDITURES RECEIPTS CASH BAL. Parks tax revenues should be about 60% after the County’s January distribution. Many of the Parks programs were negatively affected by the pandemic. Swimming pool fees and the After School Program fees are about 20% off the fiscal year 20 pace. Youth camps revenue, and many of the other user-based parks fees, historically receives more of their revenue in the 2nd half of the fiscal year (spring). AMBULANCE The ambulance fund is a special revenue fund that receives approximately 2/3 of its revenue from charges for services. Because the fees are insufficient to support the cost to operate this fund, a transfer from the general fund is necessary each fiscal year. -150 -100-50 050 100150 200 250300 350 Ju l y 2 0 2 0 Au g u s t 2 0 2 0 Se p t e m b e r 2 0 2 0 Oc t o b e r 2 0 2 0 No v e m b e r 2 0 2 0 De c e m b e r 2 0 2 0 en d D e c e m b e r 2 0 2 0 AMBULANCE FY21 MONTHLY CASH/EXP/REV (in 1000's) EXPENDITURES RECEIPTS CASH BAL. Ambulance fees for services ($266,918) are down over 32% from the same period last year ($393,824). CARES Act has reimbursed over $150,000 in presumptive employee earnings. Inception of lease (BOI loan) is for the purchase of the ambulance in the current fiscal year. BUILDING DEPARTMENT The building fund is supported by permits and fees. At a minimum, this fund should have enough cash available at July 1st to pay expenditures through December. Beginning cash carryover was 162% (FY20) and 171% (FY21). 6 $0 $500 $1,000 $1,500 $2,000 $2,500 BUILDING DEPARTMENT FY21 MONTHLY CASH/EXP/REV (in 1000's) EXPENDITURES RECEIPTS CASH BAL. Building department permits and fees are outpacing the annual budgeted amount. The approximate $593,000 of permits and fees collected in the first half of this fiscal year is about 80% of the annual budget. WATER The water fund is supported by charges for services. Beginning cash carryover was 204% (FY20) and 195% (FY21). 020004000600080001000012000 WATER FY21 MONTHLY CASH/EXP/REV (in 1000's) EXPENSES RECEIPTS CASH BAL. Metered water sales through December were $2,281,414 (69%), which is an increase from last fiscal first half of about 26%. It is normal this period’s water sales to be in excess of 50% of the annual amount because of late summer irrigation. The increase in revenue can be attributed to the reduction in impact fees and compensating increase in rates. Water impact fees have exceeded the fiscal year 21 budget. SEWER The sewer fund is supported by charges for services. Beginning cash carryover was 61% (FY20) and 57% (FY21). 0 1000 2000 3000 4000 5000 6000 SEWER FY21 MONTHLY CASH/EXP/REV (in 1000's) EXPENSES RECEIPTS CASH BAL. 7 Sewer service charges were $3,052,995, which is just over half (51%) of the budgeted amount. Last year’s 1st half sewer service charges were $2,293,079. The increase from fiscal year 2020 sewer revenue can be attributed to the reduction in impact fees and compensating increase in rates. Sanitary sewer and treatment plant impact fees have both exceeded the anticipated fiscal year 2021 amount. EXPENDITURES/EXPENSES: For most funds or departments, expenditures/expenses include the 13th (25 of 52 weeks) payroll period ending December 19. Most departments and/or funds have over 52% remaining in the salaries and retirement lines which should be adequate. The majority of fire department and ambulance fund employees are paid 13 times annually. This 1st half report includes the 6th of 13 (23 of 52 weeks/44%) pay periods for these employees. Health insurance is paid 12 times per year and includes 5 months (42%) on this report for all funds. With a few exceptions, administrative, central garage, and information technology transfers are done monthly and should show 50% remaining. This is the same on the revenue side for fees for services (Central Garage), internal services (Information Technology), administrative charges (General Fund), and many of the transfers between funds. The general fund administrative charges may vary slightly as some charges are based on a percentage of revenues collected. THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 1 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 3,281,323 6,463,000 3,181,677 49% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 8,887 18,156 9,269 51% 1000-000-311200-000 PERSONAL PROPERTY TAXES 155,836 200,000 44,164 22% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 10,716 9,000 1,716- -19% 1000-000-322101-000 LIQUOR LICENSES 286 33,000 32,714 99% 1000-000-322300-000 BUSINESS LICENSES 78 1,500 1,422 95% 1000-000-323012-000 PLANNING FEES 67,682 60,000 7,682- -13% 1000-000-323109-000 SITE REVIEW 22,019 15,000 7,019- -47% 1000-000-323200-000 PARADE PERMITS 0 1,000 1,000 100% 1000-000-331023-000 MRVCTF 411 0 411- 0% 1000-000-331112-000 KPD - SAFE STREET TASK FORCE 0 8,000 8,000 100% 1000-000-331992-000 CARES ACT REIMBURSEMENT THRU STATE 871,602 0 871,602-0% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 1,200 1,200 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 0 60,000 60,000 100% 1000-000-335110-000 LIVE CARD TABLE PERMIT 0 1,400 1,400 100% 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 1,511,946 3,023,892 1,511,946 50% 1000-000-341020-000 ADMINISTRATIVE CHARGES 306,006 613,512 307,506 50% 1000-000-341021-000 GRANT ADMIN FEES 15,127 25,000 9,873 39% 1000-000-341025-000 CITY COLLECTIONS 38,074 5,000 33,074- -661% 1000-000-342010-000 POLICE SERVICES 16,182 29,000 12,818 44% 1000-000-342014-000 RESOURCE OFFICERS 224,435 224,435 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 800 14,500 13,700 94% 1000-000-343018-000 PARKING PERMITS 48,241 95,000 46,759 49% 1000-000-343062-000 AIRPORT FUEL TAXES 3,091 4,000 909 23% 1000-000-343063-000 AIRPORT GROUND LEASE (HILTON) 15,301 14,500 801--6% 1000-000-351000-000 CITY COURT FINES & FEES 156,244 450,000 293,756 65% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 9,635 30,000 20,365 68% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 16,745 55,000 38,255 70% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 0 20,000 20,000 100% 1000-000-362020-000 MMIA GASB 54 REIMBURSEMENT 59,043 78,500 19,457 25% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 38 10,000 9,962 100% 1000-000-371010-000 INVESTMENT EARNINGS 22,045 36,000 13,955 39% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 485,000 970,000 485,000 50% ------------ ------------- ------------ ------------ TOTAL GENERAL FUND REVENUE 7,346,793 12,569,595 5,222,802 42% ============ ============= ============ ============ This printout reflects payroll earned thru Dec. 19, 2020. THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 2 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 2,500 3,030 530 17% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 13,750 13,750 0 0% 1000-400-410530-354 OPEB EXPENSE 1,500 1,500 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 3,543 3,500 43--1% 1000-400-410560-312 POSTAGE 9,094 16,000 6,906 43% 1000-400-410560-320 PRINTING & ENVELOPES 1,848 5,500 3,652 66% 1000-400-410560-354 CONTRACT SERVICES - DOC. SHREDDING 48 1,400 1,353 97% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 1,623 3,000 1,377 46% 1000-400-420000-354 CONTRACT 911 CENTER 278,029 557,482 279,454 50% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB.286 350 64 18% 1000-400-430300-355 AIRPORT REIMBURSEMENT 19,561 19,000 561--3% 1000-400-460000-820 TFR TO WESTSIDE TIF (CORE AREA) 31,150 1,246,000 1,214,850 98% 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 6,084 105,000 98,916 94% 1000-400-510310-354 ICMA PLAN FEES 250 500 250 50% 1000-400-510330-513 LIABILITY INSURANCE 186,790 186,790 0 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 16,142 60,000 43,858 73% 1000-400-510330-517 PROPERTY INSURANCE 59,654 59,654 0- 0% ------------ ------------- ------------ ------------ SUBTOTAL GEN.GOV'T. 653,452 2,304,056 1,650,604 72% CITY MANAGER 1000-401-410210-110 SALARIES-CITY MANAGER'S OFFICE 70,490 155,616 85,126 55% 1000-401-410210-153 HEALTH INSURANCE 10,939 25,078 14,139 56% 1000-401-410210-155 RETIREMENT 7,602 16,536 8,934 54% 1000-401-410210-210 SUPPLIES 0 1,000 1,000 100% 1000-401-410210-312 NEWSLETTER/BOOKS 0 400 400 100% 1000-401-410210-345 TELEPHONE & COMMUNICATION 480 1,200 720 60% 1000-401-410210-373 DUES & TRAINING 1,342 12,000 10,658 89% 1000-401-410210-379 MEETINGS 616 6,500 5,884 91% ------------ ------------- ------------ ------------ SUBTOTAL CITY MANAGER 91,468 218,330 126,862 58% HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 58,817 127,530 68,713 54% 1000-401-410830-153 HEALTH INSURANCE 8,226 23,920 15,694 66% 1000-401-410830-155 RETIREMENT 4,775 10,202 5,427 53% 1000-401-410830-210 OFFICE SUPPLIES 555 900 345 38% 1000-401-410830-338 RECRUITMENT/RELOCATION 9,502 20,000 10,498 52% 1000-401-410830-354 CONTRACT SERVICES 1,890 1,500 390- -26% 1000-401-410830-373 DUES & TRAINING 1,139 7,500 6,362 85% ------------ ------------- ------------ ------------ SUBTOTAL HUMAN RESOURCES 84,903 191,552 106,649 56% THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 3 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 29,722 63,087 33,365 53% 1000-402-410100-153 HEALTH INSURANCE 19,875 50,783 30,908 61% 1000-402-410100-155 RETIREMENT 1,235 2,587 1,352 52% 1000-402-410100-210 OFFICE SUPPLIES 0 6,500 6,500 100% 1000-402-410100-335 MT LEAGUE OF CITIES 150 2,000 1,850 93% 1000-402-410100-354 CONTRACT SERVICES 915 5,500 4,585 83% 1000-402-410100-373 DUES & TRAINING 9,089 11,500 2,411 21% 1000-402-410100-379 MEETINGS 0 22,000 22,000 100% ------------ ------------- ------------ ------------ SUBTOTAL MAYOR/COUNCIL 60,986 163,957 102,971 63% CITY CLERK 1000-402-410150-110 SALARIES-CITY CLERK 47,567 101,094 53,527 53% 1000-402-410150-121 OVERTIME 0 250 250 100% 1000-402-410150-153 HEALTH INSURANCE 9,614 22,168 12,554 57% 1000-402-410150-155 RETIREMENT 3,866 8,138 4,272 52% 1000-402-410150-210 OFFICE SUPPLIES 148 300 152 51% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 80 600 520 87% 1000-402-410150-345 TELEPHONE & COMMUNICATION 255 480 225 47% 1000-402-410150-352 CODIFICATION 1,298 4,100 2,802 68% 1000-402-410150-354 CONTRACT SERVICES 0 300 300 100% 1000-402-410150-373 DUES & TRAINING 764 6,200 5,436 88% ------------ ------------- ------------ ------------ SUBTOTAL CITY CLERK 63,592 143,630 80,038 56% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES-FINANCE OFFICE 103,638 217,352 113,714 52% 1000-403-410550-121 OVERTIME 0 500 500 100% 1000-403-410550-153 HEALTH INSURANCE 17,062 42,148 25,086 60% 1000-403-410550-155 RETIREMENT 8,370 17,434 9,064 52% 1000-403-410550-210 SUPPLIES 126 800 674 84% 1000-403-410550-322 BOOKS 0 500 500 100% 1000-403-410550-353 CONTRACT SERVICES 0 350 350 100% 1000-403-410550-354 CONTRACT-GRIZZLY SECURITY 360 900 540 60% 1000-403-410550-355 BANK CHARGES & FEES 1,583 3,200 1,617 51% 1000-403-410550-373 DUES & TRAINING 994 8,500 7,506 88% ------------ ------------- ------------ ------------ SUBTOTAL FINANCE 132,133 291,684 159,551 55% THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 4 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CITY ATTORNEY 1000-404-411110-110 SALARIES-CITY ATTORNEY'S 223,114 476,010 252,896 53% 1000-404-411110-153 HEALTH INSURANCE 37,982 82,216 44,234 54% 1000-404-411110-155 RETIREMENT 18,155 38,314 20,159 53% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 16,484 2,500 13,984- -559% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 13,957 25,000 11,043 44% 1000-404-411110-345 TELEPHONE & COMMUNICATION 395 1,000 605 60% 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 1,765 10,000 8,235 82% 1000-404-411110-373 DUES & TRAINING 1,636 6,500 4,864 75% ------------ ------------- ------------ ------------ SUBTOTAL CITY ATTORNEY 313,487 641,540 328,053 51% MUNICIPAL COURT 1000-406-410360-110 SALARIES-COURT 110,326 236,239 125,913 53% 1000-406-410360-121 OVERTIME 0 3,500 3,500 100% 1000-406-410360-153 HEALTH INSURANCE 20,227 47,494 27,267 57% 1000-406-410360-155 RETIREMENT 8,822 18,961 10,139 53% 1000-406-410360-210 SUPPLIES 662 4,500 3,838 85% 1000-406-410360-320 PRINTING/BOOKS 789 1,500 711 47% 1000-406-410360-345 TELEPHONE & COMMUNICATION 39 1,000 961 96% 1000-406-410360-353 SECURITY & TECHNOLOGY 1,653 40,000 38,347 96% 1000-406-410360-354 CONTRACT SERVICES 2,280 6,250 3,970 64% 1000-406-410360-373 DUES & TRAINING 105 10,000 9,895 99% 1000-406-410360-394 JURY & WITNESS FEES 2,717 7,500 4,783 64% ------------ ------------- ------------ ------------ SUBTOTAL COURT 147,621 376,944 229,323 61% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES-PUBLIC WORKS 9,255 19,689 10,434 53% 1000-410-430100-153 HEALTH INSURANCE 1,518 3,806 2,288 60% 1000-410-430100-155 RETIREMENT 742 1,550 808 52% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 9,226 14,500 5,274 36% 1000-410-430100-231 GAS 1,260 3,000 1,740 58% 1000-410-430100-345 TELEPHONE & COMMUNICATION 144 350 206 59% 1000-410-430100-354 CONTRACT SERVICES 716 2,000 1,284 64% 1000-410-430100-373 DUES & TRAINING 398 4,500 4,102 91% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 2,109 4,217 2,108 50% ------------ ------------- ------------ ------------ SUBTOTAL PUBLIC WORKS ADMIN 25,369 53,612 28,243 53% CITY HALL MAINT. 1000-412-411230-110 SALARIES-CITY HALL 31,995 68,986 36,991 54% 1000-412-411230-153 HEALTH INSURANCE 6,413 14,718 8,305 56% 1000-412-411230-155 RETIREMENT 2,501 5,307 2,806 53% 1000-412-411230-220 SECURITY IMPROVEMENTS 1,442 6,793 5,351 79% 1000-412-411230-224 JANITORIAL SUPPLIES 3,410 6,800 3,390 50% 1000-412-411230-241 TOOLS & SUPPLIES 48 1,500 1,452 97% 1000-412-411230-341 ELECTRICITY 25,227 45,000 19,773 44% 1000-412-411230-344 NATURAL GAS 13,157 32,000 18,843 59% 1000-412-411230-345 TELEPHONE & COMMUNICATION 225 400 175 44% 1000-412-411230-354 CONTRACT SERVICES 4,493 25,000 20,507 82% THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 5 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-355 HVAC MAINTENANCE CONTRACT 17,380 16,500 880--5% 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 975 6,000 5,025 84% 1000-412-411230-362 EQUIPMENT MAINTENANCE 1,941 10,000 8,059 81% 1000-412-411230-366 BUILDING MAINTENANCE 1,812 41,150 39,338 96% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,088 3,700 612 17% ------------ ------------- ------------ ------------ SUBTOTAL CITY HALL 114,109 283,854 169,745 60% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES-PLANNING & ZONING 107,670 224,538 116,868 52% 1000-420-411020-153 HEALTH INSURANCE 19,389 49,800 30,411 61% 1000-420-411020-155 RETIREMENT 8,562 18,081 9,519 53% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 3,375 4,000 625 16% 1000-420-411020-231 GAS 65 400 335 84% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 352 2,200 1,848 84% 1000-420-411020-345 TELEPHONE 249 1,000 751 75% 1000-420-411020-354 CONTRACT SERVICES 0 5,500 5,500 100% 1000-420-411020-373 DUES & TRAINING 240 7,500 7,260 97% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 154 308 154 50% ------------ ------------- ------------ ------------ SUBTOTAL PLANNING DEPT. 140,057 313,327 173,270 55% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 33,017 71,468 38,451 54% 1000-480-470210-153 HEALTH INSURANCE 7,270 16,750 9,480 57% 1000-480-470210-155 RETIREMENT 2,693 5,716 3,023 53% 1000-480-470210-210 OFFICE SUPPLIES 670 1,600 930 58% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 389 500 111 22% 1000-480-470210-312 POSTAGE & PRINTING 151 300 149 50% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 0 500 500 100% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 266 450 184 41% 1000-480-470210-354 CONTRACT SERVICES 180 250 70 28% 1000-480-470210-373 DUES & TRAINING 1,009 5,000 3,991 80% 1000-480-470210-379 MEETINGS 20 750 730 97% ------------ ------------- ------------ ------------ SUBTOTAL COMMUNITY DEVELOPMENT 45,666 103,284 57,618 56% THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 6 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES-POLICE 1,158,764 2,558,903 1,400,139 55% 1000-413-420140-112 SALARIES-SEVERANCE 0 40,000 40,000 100% 1000-413-420140-114 SALARY -comptime buyout 10,669 11,500 831 7% 1000-413-420140-121 OVERTIME (REG & AET OT) 54,353 80,000 25,647 32% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 7,936 35,000 27,064 77% 1000-413-420140-153 HEALTH INSURANCE 201,316 512,582 311,266 61% 1000-413-420140-155 RETIREMENT 147,206 336,010 188,804 56% 1000-413-420140-210 OFFICE SUPPLIES 1,749 3,500 1,751 50% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 23,467 27,000 3,533 13% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 19,822 32,560 12,738 39% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 3,238 3,760 522 14% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 3,209 11,500 8,291 72% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 60 1,500 1,440 96% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 9,312 10,000 688 7% 1000-413-420140-227 AMMO & RELATED SUPPLIES 135 33,800 33,665 100% 1000-413-420140-228 PATROL CAR SUPPLIES 4,515 17,500 12,985 74% 1000-413-420140-229 OTHER SUPPLIES 1,146 5,000 3,854 77% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 216 1,000 784 78% 1000-413-420140-231 GAS 24,719 85,000 60,281 71% 1000-413-420140-234 CRISIS NEGOTIATIONS 0 500 500 100% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 287 1,500 1,213 81% 1000-413-420140-320 PRINTING 2,051 5,500 3,449 63% 1000-413-420140-345 TELEPHONE & COMMUNICATION 10,417 21,000 10,583 50% 1000-413-420140-354 CONTRACT SERVICES 35,385 35,800 415 1% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 1,500 6,500 5,000 77% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 450 2,100 1,650 79% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 429 2,000 1,571 79% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 46,857 59,240 12,383 21% 1000-413-420140-369 RADIO EQUIPMENT & MAINT.2,743 2,800 57 2% 1000-413-420140-373 DUES & TRAINING 22,202 55,000 32,798 60% 1000-413-420140-375 REG. TRAINING/TESTING REIMB.318 14,500 14,182 98% 1000-413-420140-380 TRAINING MATERIALS 5,000 5,000 0 0% 1000-413-420140-388 MEDICAL SERVICES 2,415 3,000 585 20% 1000-413-420140-392 BOARDING/TREATING PRISONERS 830 2,500 1,671 67% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 44,248 88,496 44,248 50% 1000-413-420140-530 RENT 3,600 7,200 3,600 50% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 32,000 64,000 32,000 50% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 3,000 6,000 3,000 50% 1000-413-420140-944 VEHICLES 60,754 77,000 16,246 21% ------------ ------------- ------------ ------------ SUBTOTAL POLICE DEPT. 1,946,320 4,265,751 2,319,431 54% DETECTIVES 1000-413-420141-110 SALARIES-DETECTIVES 183,998 400,261 216,263 54% 1000-413-420141-121 DETECTIVE-OVERTIME 5,712 15,000 9,288 62% 1000-413-420141-123 OVERTIME (SAFE NEIGHBORHOOD TASK FO 0 8,000 8,000 100% 1000-413-420141-153 HEALTH INSURANCE 38,822 95,807 56,985 59% 1000-413-420141-155 DETECTIVE-RETIREMENT 24,438 53,729 29,291 55% ------------ ------------- ------------ ------------ TOTAL DETECTIVES 252,970 572,797 319,827 56% RECORDS 1000-413-420142-110 SALARIES-RECORDS DIVISION 70,056 152,955 82,899 54% THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 7 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-121 OVERTIME 3,342 7,500 4,158 55% 1000-413-420142-153 HEALTH INSURANCE 15,900 37,444 21,544 58% 1000-413-420142-155 RETIREMENT 5,904 12,242 6,338 52% ------------ ------------- ------------ ------------ TOTAL RECORDS 95,202 210,141 114,939 55% RESOURCE OFFICERS 1000-413-420144-110 SALARIES-SRO 131,981 281,666 149,685 53% 1000-413-420144-153 HEALTH INSURANCE 27,795 56,050 28,255 50% 1000-413-420144-155 SRO RETIREMENT 17,526 37,912 20,386 54% ------------ ------------- ------------ ------------ TOTAL RESOURCE OFFICERS 177,302 375,628 198,326 53% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL-SALARIES 21,904 46,291 24,387 53% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 3,975 9,111 5,136 56% 1000-413-420145-155 RETIREMENT 1,663 3,565 1,902 53% ------------ ------------- ------------ ------------ SUBTOTAL ANIMAL CONTROL 27,543 59,467 31,924 54% PARKING 1000-413-420147-110 PARKINGS -SALARIES 40,204 85,511 45,307 53% 1000-413-420147-153 HEALTH INSURANCE 14,540 33,500 18,960 57% 1000-413-420147-155 RETIREMENT 3,185 6,840 3,655 53% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 1,015 4,000 2,985 75% 1000-413-420147-354 CONTRACTED SERVICES 281 2,000 1,719 86% 1000-413-420147-362 LOT MAINT 548 10,000 9,452 95% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 5,795 17,500 11,705 67% 1000-413-420147-550 LOT LEASE PAYMENTS 415 1,500 1,085 72% ------------ ------------- ------------ ------------ SUBTOTAL PARKING 65,984 160,851 94,867 59% ------------ ------------- ------------ ------------ SUBTOTAL POLICE DEPT. 2,565,320 5,644,635 3,079,315 55% THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 8 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES-FIRE SUPPRESSION 656,934 1,913,898 1,256,964 66% 1000-416-420400-112 SALARY-SEVERANCE 40,305 54,361 14,056 26% 1000-416-420400-113 KELLY DAYS 80 0 80-0% 1000-416-420400-114 COMPTIME BUYOUT 3,437 5,500 2,063 38% 1000-416-420400-115 OUT OF RANK PAY 4,576 12,500 7,924 63% 1000-416-420400-121 OVERTIME 88,185 40,000 48,185- -120% 1000-416-420400-153 HEALTH INSURANCE 155,199 348,552 193,353 55% 1000-416-420400-155 RETIREMENT 91,577 250,532 158,955 63% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 365 3,000 2,635 88% 1000-416-420400-218 Equipment (Non Capital)4,275 21,500 17,225 80% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 1,995 15,000 13,005 87% 1000-416-420400-224 JANITORIAL SUPPLIES 1,631 5,000 3,369 67% 1000-416-420400-231 GAS 3,807 17,325 13,518 78% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 3,336 15,750 12,414 79% 1000-416-420400-320 PRINTING 0 200 200 100% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 58 1,250 1,192 95% 1000-416-420400-345 TELEPHONE & COMMUNICATION 1,907 6,000 4,093 68% 1000-416-420400-354 CONTRACT SERVICES 7,747 17,460 9,713 56% 1000-416-420400-362 EQUIPMENT MAINTENANCE 5,854 5,500 354--6% 1000-416-420400-366 BUILDING MAINTENANCE-STATION 62 2,686 7,500 4,814 64% 1000-416-420400-369 RADIO EQUIPMENT & MAINT.1,975 5,000 3,025 60% 1000-416-420400-373 DUES & TRAINING 3,195 10,000 6,805 68% 1000-416-420400-388 FIREFIGHTER PHYSICALS 1,282 29,000 27,719 96% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 14,342 28,684 14,342 50% 1000-416-420400-610 DEBT RETIREMENT-FIRE TRUCK 22,068 44,387 22,319 50% 1000-416-420400-620 INTEREST EXPENSE-FIRE TRUCK 1,944 9,776 7,832 80% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 175,000 350,000 175,000 50% 1000-416-420400-821 TFR - 2956 AFG ($31,591)/2995 SAFAR 0 56,591 56,591 100% 1000-416-420440-110 SALARIES-FIRE PREVENTION 9,981 22,115 12,134 55% 1000-416-420440-153 HEALTH INSURANCE 2,495 5,736 3,241 57% 1000-416-420440-155 RETIREMENT 778 1,681 903 54% ------------ ------------- ------------ ------------ SUBTOTAL FIRE DEPT. 1,307,014 3,303,798 1,996,784 60% ------------ ------------- ------------ ------------ GRAND TOTAL GENERAL FUND 5,745,175 14,034,203 8,289,028 59% ============ ============= ============ ============ THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 9 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SPECIAL REVENUE FUNDS: 2215 PARKS & REC. FUND REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 539,766 1,065,000 525,234 49% 2215-000-311200-000 PERSONAL PROPERTY TAXES 24,665 35,000 10,335 30% 2215-000-312000-000 PEN & INTEREST DEL TAXES 951 1,500 549 37% 2215-000-346030-000 SWIMMING POOL FEES 59,544 148,410 88,866 60% 2215-000-346040-000 CONCESSION STAND REVENUE 22,142 37,800 15,658 41% 2215-000-346050-000 PARKS USAGE FEES 6,604 20,000 13,396 67% 2215-000-346051-000 RECREATION FEES 8,747 25,048 16,301 65% 2215-000-346052-000 SPORTS PROGRAMS 29,562 73,577 44,015 60% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS)1,939 2,000 61 3% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 18,789 67,500 48,711 72% 2215-000-346055-000 ICE RINK 0 22,000 22,000 100% 2215-000-346056-000 KIDSPORT USAGE 408 4,000 3,592 90% 2215-000-346057-000 YOUTH CAMPS 26,735 179,201 152,466 85% 2215-000-346059-000 PICNIC IN THE PARK 0 26,500 26,500 100% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-371010-000 INVESTMENTS 2,563 6,500 3,937 61% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 49,000 98,000 49,000 50% ------------ ------------- ------------ ------------ TOTAL PARKS & REC REVENUE 791,415 1,832,036 1,040,621 57% ============ ============= ============ ============ PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES-PARKS 149,665 347,866 198,201 57% 2215-436-460430-111 SEASONAL SALARIES 25,131 66,712 41,581 62% 2215-436-460430-121 OVERTIME 0 300 300 100% 2215-436-460430-153 HEALTH INSURANCE 25,780 72,336 46,556 64% 2215-436-460430-155 RETIREMENT 13,114 30,263 17,149 57% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 1,506 4,400 2,894 66% 2215-436-460430-215 EQUIPMENT - not capital 350 3,000 2,650 88% 2215-436-460430-224 JANITORIAL SUPPLIES 2,325 7,000 4,675 67% 2215-436-460430-229 OTHER SUPPLIES 1,552 10,000 8,448 84% 2215-436-460430-231 GAS 6,503 17,000 10,497 62% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 2,460 4,000 1,540 38% 2215-436-460430-320 PRINTING & ADVERTISING 166 200 34 17% 2215-436-460430-341 ELECTRICITY 6,639 13,500 6,861 51% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.)6,368 22,000 15,632 71% 2215-436-460430-344 NATURAL GAS 682 2,500 1,818 73% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 918 2,800 1,882 67% 2215-436-460430-351 SPORTS COURT & SPORT MAINTENANCE 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 1,323 18,000 16,677 93% 2215-436-460430-356 TRAIL STUDY 0 30,000 30,000 100% 2215-436-460430-358 FVCC TENNIS INTERLOCAL AGREEMENT 7,000 7,000 0 0% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 6,032 8,500 2,468 29% 2215-436-460430-364 LANDSCAPING 0 6,100 6,100 100% 2215-436-460430-367 VANDALISM REPAIRS 2,140 4,200 2,060 49% 2215-436-460430-373 DUES & TRAINING 763 8,000 7,238 90% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 165 400 235 59% THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 10 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 1,932 7,000 5,068 72% 2215-436-460430-440 IRRIGATION SUPPLIES 720 7,500 6,780 90% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 772 2,000 1,228 61% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 18,033 36,067 18,034 50% 2215-436-460430-545 COUNTY LANDFILL 3,735 6,273 2,538 40% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 29,241 58,859 29,618 50% 2215-436-460430-620 DEBT SERVICE INTEREST 914 6,424 5,510 86% ------------ ------------- ------------ ------------ SUBTOTAL PARKS EXPENDITURES 317,929 814,700 496,771 61% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES-COMPLEX 51,308 112,922 61,614 55% 2215-436-460440-111 SEASONAL SALARIES 17,421 38,917 21,496 55% 2215-436-460440-121 OVERTIME 0 300 300 100% 2215-436-460440-153 HEALTH INSURANCE 13,547 33,161 19,614 59% 2215-436-460440-155 RETIREMENT 5,336 10,318 4,982 48% 2215-436-460440-221 SAFETY EQUIPMENT 0 600 600 100% 2215-436-460440-229 OTHER SUPPLIES 3,008 22,000 18,992 86% 2215-436-460440-231 GAS 2,807 9,000 6,193 69% 2215-436-460440-241 CONSUMABLE TOOLS 197 2,000 1,803 90% 2215-436-460440-341 ELECTRICITY 6,547 9,500 2,953 31% 2215-436-460440-345 TELEPHONE & COMMUNICATION 115 240 125 52% 2215-436-460440-354 CONTRACT SERVICES 200 1,000 800 80% 2215-436-460440-362 EQUIPMENT MAINTENANCE 235 800 565 71% 2215-436-460440-364 LANDSCAPING 0 500 500 100% 2215-436-460440-367 VANDALISM REPAIRS 109 500 391 78% 2215-436-460440-373 DUES & TRAINING 140 700 560 80% 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 110 200 90 45% 2215-436-460440-395 RENTAL EQUIPMENT 0 200 200 100% 2215-436-460440-420 METAL PRODUCTS 0 4,000 4,000 100% 2215-436-460440-440 IRRIGATION 2,011 7,000 4,989 71% 2215-436-460440-452 SAND & GRAVEL 659 1,500 841 56% 2215-436-460440-521 CENTRAL GARAGE TRANSFER 2,893 5,787 2,894 50% 2215-436-460440-545 COUNTY LANDFILL 3,389 3,400 11 0% ------------ ------------- ------------ ------------ SUBTOTAL ATHLETIC COMPLEX 110,032 264,545 154,513 58% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES-RECREATION 28,916 86,268 57,352 66% 2215-436-460431-111 SEASONAL SALARIES 6,551 12,306 5,755 47% 2215-436-460431-121 OVERTIME 292 0 292-0% 2215-436-460431-153 HEALTH INSURANCE 5,834 24,380 18,546 76% 2215-436-460431-155 RETIREMENT 2,337 7,789 5,452 70% 2215-436-460431-229 MISC. SUPPLIES 3,857 10,335 6,478 63% 2215-436-460431-231 GAS 71 600 529 88% 2215-436-460431-320 PRINTING & ADVERTISING 134 7,925 7,791 98% 2215-436-460431-345 TELEPHONE & COMMUNICATION 253 675 422 63% 2215-436-460431-354 CONTRACT SERVICES 4,831 37,828 32,997 87% 2215-436-460431-357 MUSIC FRANCHISE FEES 852 1,300 449 35% 2215-436-460431-373 DUES & TRAINING 229 800 571 71% ------------ ------------- ------------ ------------ SUBTOTAL RECREATION 54,156 190,206 136,050 72% THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 11 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING YOUTH CAMPS 2215-436-460448-110 SALARIES-YOUTH CAMPS 24,161 76,112 51,951 68% 2215-436-460448-111 SEASONAL SALARIES 74,890 143,522 68,632 48% 2215-436-460448-121 OVERTIME 40 150 110 74% 2215-436-460448-153 HEALTH INSURANCE 5,437 23,469 18,032 77% 2215-436-460448-155 RETIREMENT 1,953 7,029 5,076 72% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 162 250 88 35% 2215-436-460448-229 MISC. SUPPLIES 2,013 3,520 1,507 43% 2215-436-460448-231 GAS 0 200 200 100% 2215-436-460448-320 PRINTING & ADVERTISING 0 375 375 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 411 1,350 939 70% 2215-436-460448-354 CONTRACT SERVICES 3,483 13,154 9,671 74% 2215-436-460448-355 AFTER SCHOOL PROGRAM 74 1,200 1,126 94% 2215-436-460448-356 BANK FEES/CC CHARGES 1,584 4,500 2,916 65% 2215-436-460448-373 DUES & TRAINING 169 800 631 79% ------------ ------------- ------------ ------------ SUBTOTAL YOUTH CAMPS 114,376 275,631 161,255 59% POOL 2215-437-460445-111 SEASONAL SALARIES-POOL 147,901 170,081 22,180 13% 2215-437-460445-121 OVERTIME 493 200 293- -146% 2215-437-460445-155 RETIREMENT 265 1,500 1,235 82% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 317 500 183 37% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 436 2,000 1,564 78% 2215-437-460445-226 CHLORINE/CHEMICALS 28,387 40,000 11,613 29% 2215-437-460445-228 CONCESSION STAND SUPPLIES 7,870 21,000 13,130 63% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 475 4,000 3,525 88% 2215-437-460445-341 ELECTRICITY 5,543 9,500 3,957 42% 2215-437-460445-344 NATURAL GAS 430 25,000 24,570 98% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 877 2,500 1,623 65% 2215-437-460445-354 LICENSES & FEES 1,375 1,300 75--6% 2215-437-460445-356 BANK FEES/ CC CHARGES 1,102 2,500 1,398 56% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 8,014 28,250 20,236 72% 2215-437-460445-380 TRAINING MATERIALS 380 1,800 1,420 79% ------------ ------------- ------------ ------------ SUBTOTAL POOL EXPENDITURES 203,864 310,131 106,267 34% ------------ ------------- ------------ ------------ TOTAL PARKS & RECREATION/POOL 800,357 1,855,213 1,054,856 57% ============ ============= ============ ============ THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 12 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING URBAN FORESTRY 2600-436-460433-110 SALARIES-URBAN FORESTRY 74,769 199,567 124,798 63% 2600-436-460433-111 SEASONAL SERVICES 17,704 23,406 5,702 24% 2600-436-460433-121 OVERTIME 0 1,000 1,000 100% 2600-436-460433-153 HEALTH INSURANCE 13,988 54,259 40,271 74% 2600-436-460433-155 RETIREMENT 6,716 17,366 10,650 61% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 2,772 4,000 1,228 31% 2600-436-460433-231 GAS 1,777 8,000 6,223 78% 2600-436-460433-241 CONSUMABLE TOOLS 1,192 12,200 11,008 90% 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 361 660 300 45% 2600-436-460433-354 CONTRACT SERVICES 154,554 195,000 40,446 21% 2600-436-460433-357 FORESTRY GRANT 0 6,000 6,000 100% 2600-436-460433-358 EAB MONITORING/ARBOR DAY 0 4,000 4,000 100% 2600-436-460433-362 EQUIPMENT MAINTENANCE 756 4,000 3,244 81% 2600-436-460433-364 LANDSCAPING & TREES 2,347 8,000 5,653 71% 2600-436-460433-373 DUES & TRAINING 430 5,000 4,570 91% 2600-436-460433-388 MEDICAL 185 200 15 8% 2600-436-460433-395 EQUIPMENT RENTAL 9,498 9,500 2 0% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 4,136 4,137 2 0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 4,620 9,241 4,621 50% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 11,988 23,976 11,988 50% 2600-436-460433-528 INFORMATION TECHNOLOGY TRANSFER 3,808 7,617 3,809 50% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 8,556 17,146 8,590 50% 2600-436-460433-620 INTEREST EXPENSE 137 582 445 76% 2600-436-460433-940 MACHINERY & EQUIPMENT 130,021 140,000 9,979 7% ------------ ------------- ------------ ------------ TOTAL URBAN FORESTRY 450,316 754,857 304,541 40% ============ ============= ============ ============ THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 13 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 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 152,323 0 152,323-0% 2230-000-342050-000 FEES FOR SERVICES 266,918 751,500 484,582 64% 2230-000-342070-000 COUNTY EMS LEVY 66,390 130,000 63,610 49% 2230-000-381050-000 INCEPTION OF LEASE 0 190,000 190,000 100% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 175,000 350,000 175,000 50% ------------ ------------- ------------ ------------ TOTAL AMBULANCE REVENUE 660,631 1,421,500 760,869 54% ============ ============= ============ ============ AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 281,796 724,099 442,303 61% 2230-440-420730-114 COMPTIME BUYBACK 0 3,500 3,500 100% 2230-440-420730-115 OUT OF RANK PAY 1,835 3,300 1,465 44% 2230-440-420730-121 OVERTIME 20,012 30,000 9,988 33% 2230-440-420730-153 HEALTH INSURANCE 62,942 157,313 94,371 60% 2230-440-420730-155 RETIREMENT 36,491 94,245 57,754 61% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 696 3,400 2,704 80% 2230-440-420730-218 NON-CAPITAL EQUIPMENT 1,577 4,200 2,623 62% 2230-440-420730-231 GAS & OIL 1,969 7,560 5,591 74% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 1,006 4,000 2,994 75% 2230-440-420730-312 POSTAGE/PRINTING 0 1,000 1,000 100% 2230-440-420730-345 TELEPHONE & COMMUNICATION 493 1,700 1,207 71% 2230-440-420730-354 CONTRACT SERVICES 3,685 20,040 16,355 82% 2230-440-420730-355 911 CENTER CONTRIBUTION 19,124 38,247 19,124 50% 2230-440-420730-359 AUDIT/CC OTHER FEES 2,418 1,650 768--47% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 552 5,000 4,448 89% 2230-440-420730-373 DUES & TRAINING 4,217 5,000 783 16% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,500 2,500 100% 2230-440-420730-391 MEDICAL TREATMENT-SUPPLIES 43,187 51,241 8,054 16% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 11,530 11,530 0-0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 7,989 15,978 7,989 50% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 23,813 47,627 23,814 50% 2230-440-420730-528 INFORMATION TECHNOLOGY TRANSFER 15,233 30,466 15,233 50% 2230-440-420730-610 PRINCIPAL - AMBULANCE 0 19,000 19,000 100% 2230-440-420730-620 INTEREST - AMBULANCE 0 2,375 2,375 100% 2230-440-420730-940 EQUIPMENT 189,481 190,000 519 0% ------------ ------------- ------------ ------------ TOTAL AMBULANCE EXPENDITURES 730,046 1,474,971 744,925 51% ============ ============= ============ ============ THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 14 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC SAFETY IMPACT FEE REV 2399-000-341072-000 POLICE IMPACT FEES 12,436 10,000 2,436- -24% 2399-000-341073-000 FIRE IMPACT FEES 151,224 150,000 1,224- -1% 2399-000-371010-000 INVESTMENT EARNINGS 5,443 13,000 7,557 58% ------------------------------------------------- TOTAL PS IMPACT FEE REV 169,103 173,000 3,897 2% ================================================= PUBLIC SAFETY IMPACT FEE EXP 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 5,000 10,000 5,000 50% 2399-413-420140-610 PRINCIPAL - IMPOUND/STORAGE 0 5,000 5,000 100% 2399-413-420140-620 INTEREST - IMPOUND/STORAGE 0 2,000 2,000 100% 2399-413-420140-920 IMPOUND/STORAGE FACILITY 0 100,000 100,000 100% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 750,000 750,000 100% ------------------------------------------------- TOTAL PS IMPACT FEE EXP 5,000 867,000 862,000 99% ================================================= FIRE & HAZMAT GRANTS 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 19,023 10,000 9,023- -90% 2956-416-420415-940 AFG GRT FY20 SCBA 0 347,501 347,501 100% ------------------------------------------------- TOTAL FIRE GRANTS 19,023 357,501 338,478 95% ================================================= 2957-416-420400-221 DoMA EQUIP (REIMB) 16,234 0 16,234- 0% 2957-416-420410-125 PASS THRU HAZMAT OT 0 5,000 5,000 100% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 240 10,000 9,760 98% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 3,000 3,000 100% ------------------------------------------------- TOTAL HAZMAT GRANTS 16,474 18,000 1,526 8% ================================================= SAFER GRANT 2995-416-420400-110 SALARIES 0 66,500 66,500 100% 2995-416-420400-153 HEALTH INSURANCE 0 19,150 19,150 100% 2995-416-420400-155 RETIREMENT 0 9,550 9,550 100% ------------------------------------------------- TOTAL SAFER GRANT 0 95,200 95,200 100% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 15 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 394,387 400,000 5,613 1% 2394-000-323103-000 PLUMBING PERMITS 36,542 33,000 3,542- -11% 2394-000-323104-000 MECHANICAL PERMITS 32,777 35,000 2,223 6% 2394-000-323105-000 ELECTRICAL PERMITS 51,397 58,000 6,603 11% 2394-000-323108-000 PLAN REVIEW FEES 77,641 120,000 42,359 35% 2394-000-362015-000 INSURANCE REIMBURSEMENT 3,173 0 3,173- 0% 2394-000-371010-000 INVESTMENT EARNINGS 8,207 15,000 6,793 45% ------------------------------------------------- TOTAL REVENUE 604,124 756,200 152,076 20% ================================================= BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES-BUILDING DEPT. 241,550 518,265 276,715 53% 2394-420-420530-112 SALARIES-SEVERANCE 0 23,993 23,993 100% 2394-420-420530-121 OVERTIME 3,697 20,000 16,303 82% 2394-420-420530-153 HEALTH INSURANCE 46,357 92,887 46,530 50% 2394-420-420530-155 RETIREMENT 18,977 39,716 20,739 52% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 11,372 22,000 10,628 48% 2394-420-420530-231 GAS & OIL 1,384 4,000 2,616 65% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 186- 6,000 6,186 103% 2394-420-420530-323 ST. ED. ASSESSMENTS 0 5,500 5,500 100% 2394-420-420530-345 TELEPHONE & COMMUNICATION 3,557 6,000 2,443 41% 2394-420-420530-353 AUDITING 4,500 4,500 0 0% 2394-420-420530-354 CONTRACT SERVICES 10,426 20,000 9,574 48% 2394-420-420530-355 CITY WORKS LICENSING FEE 16,591 16,000 591- -4% 2394-420-420530-356 ArcGIS SERVER UPGRADE LICENSE 0 6,000 6,000 100% 2394-420-420530-357 CREDIT CARD / PAYPAL FEES 6,955 10,000 3,045 30% 2394-420-420530-360 FURNITURE 0 7,500 7,500 100% 2394-420-420530-373 DUES & TRAINING 1,620 30,000 28,380 95% 2394-420-420530-510 PROPERTY INSURANCE 10,914 10,914 0- 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 1,284 2,569 1,285 50% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 15,744 31,612 15,868 50% 2394-420-420530-528 INFORMATION TECHNOLOGY TRANSFER 44,087 88,174 44,087 50% 2394-420-420530-920 BUILDING IMPROVEMENTS 0 199,190 199,190 100% ------------------------------------------------- TOTAL BUILDING DEPT. 438,830 1,164,820 725,990 62% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 16 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 36,645 92,780 56,135 61% 2400-410-430263-153 HEALTH INSURANCE 5,547 16,775 11,228 67% 2400-410-430263-155 RETIREMENT 2,840 7,138 4,298 60% 2400-410-430263-244 STREET LIGHT SUPPLIES 183 18,000 17,817 99% 2400-410-430263-245 LUMINAIRES 13,470 30,000 16,530 55% 2400-410-430263-246 LED LUMINAIRE UPGRADE 32 16,431 16,399 100% 2400-410-430263-341 ELECTRICITY 78,739 182,000 103,261 57% 2400-410-430263-360 REPAIR & MAINT SERVICES 5,315 21,500 16,185 75% 2400-410-430263-373 DUES & TRAINING 0 2,500 2,500 100% 2400-410-430263-510 INSURANCE 1,671 1,671 0 0% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 5,900 11,801 5,901 50% 2400-410-430263-528 INFORMATION TECH TRANSFER 5,222 10,443 5,222 50% ------------------------------------------------- TOTAL LIGHT MAINT. 155,564 411,039 255,475 62% ================================================= 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 82,034 131,071 49,037 37% 2420-421-430234-957 ALLEY PAVING 25,118 40,000 14,882 37% 2420-421-430240-231 GAS & OIL 9,560 42,000 32,440 77% 2420-421-430240-344 NATURAL GAS 959 6,800 5,841 86% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 100% 2420-421-430240-360 REPAIR & MAINT SERVICES 891 1,500 609 41% 2420-421-430240-368 OVERLAY/CHIPSEALS 0 435,642 435,642 100% 2420-421-430240-452 GRAVEL 0 5,000 5,000 100% 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 19,997 58,000 38,003 66% 2420-421-430240-472 ASPHALT 37,482 40,000 2,518 6% 2420-421-430240-473 CRACK SEALING 4,716 16,100 11,384 71% 2420-421-430240-474 PAINT STRIPING MATERIALS 1,487 30,000 28,513 95% ------------------------------------------------- TOTAL GAS TAX 182,244 831,113 648,869 78% ================================================= BARSAA (GAS TAX) 2421-421-430240-354 PAVEMENT MAINTENANCE 165,874 450,000 284,126 63% ------------------------------------------------- TOTAL BARSAA 165,874 450,000 284,126 63% ================================================= 2825 MACI GRANT 2825-421-430240-940 EQUIPMENT 0 242,814 242,814 100% ------------------------------------------------- TOTAL MACI GRANT 0 242,814 242,814 100% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 17 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500 STREET MAINT. & SIGNS STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 378,727 827,422 448,695 54% 2500-421-430240-121 OVERTIME 2,518 28,000 25,482 91% 2500-421-430240-153 HEALTH INSURANCE 74,215 196,448 122,233 62% 2500-421-430240-155 RETIREMENT 29,420 62,911 33,491 53% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 6,913 17,360 10,447 60% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 519 7,000 6,481 93% 2500-421-430240-220 OTHER SUPPLIES 1,802 4,500 2,698 60% 2500-421-430240-231 GAS & OIL 9,802 42,000 32,198 77% 2500-421-430240-341 ELECTRICITY 1,116 3,500 2,384 68% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 724 1,850 1,126 61% 2500-421-430240-354 CONTRACT SERVICES 3,623 22,500 18,877 84% 2500-421-430240-356 TRANSPORTATION PLAN 79,586 105,000 25,414 24% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 8,551 41,000 32,449 79% 2500-421-430240-366 BUILDING MAINTENANCE 2,443 5,000 2,557 51% 2500-421-430240-373 DUES & TRAINING 938 13,000 12,062 93% 2500-421-430240-388 MEDICAL SERVICES 310 1,000 690 69% 2500-421-430240-510 LIABILITY INSURANCE 43,437 43,437 0- 0% 2500-421-430240-512 UNINSURED LOSS-DEDUCTIBLE 6,565 45,000 38,435 85% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 107,360 214,721 107,361 50% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 46,659 93,317 46,658 50% 2500-421-430240-528 INFORMATION TECHNOLOGY TRANSFER 16,646 33,293 16,647 50% 2500-421-430240-840 MACI GRANT MATCH - WTR/DE-ICER TRK 0 15,000 15,000 100% 2500-421-430240-953 SHOP COMPLEX PAVEMENT RESTORATION 7,574 10,000 2,426 24% 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 12,709 25,649 12,940 50% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 6,782 13,404 6,622 49% 2500-421-430244-354 PAVEMENT REPAIRS-PAVEMENT MNT FUNDS 179,350 717,621 538,271 75% 2500-421-430244-820 TRANSFER TO BaRSAA 0 15,000 15,000 100% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 84,500 315,000 230,500 73% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 448 27,828 27,380 98% ------------------------------------------------- TOTAL STREET MAINT. 1,113,235 2,947,761 1,834,526 62% ------------------------------------------------- SIGNS AND SIGNALS 2500-421-430264-110 TSS - SALARIES 36,390 106,087 69,697 66% 2500-421-430264-121 OVERTIME 0 7,500 7,500 100% 2500-421-430264-153 HEALTH INSURANCE 10,777 32,050 21,273 66% 2500-421-430264-155 RETIREMENT 2,801 7,988 5,187 65% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 1,550 4,775 3,225 68% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 498 6,700 6,202 93% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 1,463 4,000 2,537 63% 2500-421-430264-242 STREET SIGNS 9,118 30,000 20,882 70% 2500-421-430264-243 TRAFFIC SIGNALS 18,564 32,459 13,895 43% 2500-421-430264-245 BARRICADE MATERIALS 0 6,000 6,000 100% 2500-421-430264-341 ELECTRICITY 788 3,000 2,212 74% 2500-421-430264-345 COMMUNICATIONS 460 850 390 46% 2500-421-430264-354 CONTRACT SERVICES 1,152 10,000 8,848 88% 2500-421-430264-362 EQUIPMENT MAINTENANCE 1,634 3,000 1,366 46% 2500-421-430264-366 BUILDING MAINTENANCE 0 5,000 5,000 100% 2500-421-430264-373 DUES & TRAINING 121 7,500 7,379 98% 2500-421-430264-428 PAINT MATERIALS 0 5,000 5,000 100% 2500-421-430264-510 LIABILITY INS.-TSS 2,768 2,768 0 0% THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 18 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500-421-430264-512 UNINSURED LOSS-DEDUCTIBLE 0 1,000 1,000 100% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 2,879 5,758 2,879 50% 2500-421-430264-940 MACHINERY & EQUIPMENT 4,377 6,000 1,623 27% ------------------------------------------------- TOTAL SIGNS AND SIGNALS 95,341 287,435 192,094 67% ------------------------------------------------- TOTAL STREET MAINT. & SIGNS 1,208,575 3,235,196 2,026,621 63% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 19 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2188 WESTSIDE TIF REVENUE 2188-000-371010-000 INVESTMENT EARNINGS 1,996 0 1,996- 0% 2188-000-373010-000 INTEREST / LOANS 7,902 15,000 7,098 47% 2188-000-373020-000 PRINCIPAL / LOANS 8,736 18,000 9,264 51% 2188-000-381060-000 TRANSFER FROM GENERAL FUND 31,150 1,246,000 1,214,850 98% 2188-000-383001-000 TRANSFER FROM CD PROGRAMS (2886) 100,000 205,085 105,085 51% ------------------------------------------------- TOTAL REVENUE 149,784 1,484,085 1,334,301 90% ================================================= EXPENDITURES 2188-480-470230-110 SALARIES 22,401 48,475 26,074 54% 2188-480-470230-153 HEALTH INSURANCE 4,572 10,526 5,954 57% 2188-480-470230-155 RETIREMENT 1,826 3,846 2,020 53% 2188-480-470230-353 AUDIT 1,500 1,500 0 0% 2188-480-470230-356 TELEPHONE 96 192 96 50% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 1,064 2,127 1,063 50% 2188-480-470440-930 CITY MATCH - TRAIL 589,707 2,043,808 1,454,101 71% ------------------------------------------------- TOTAL WESTSIDE TIF 621,166 2,110,474 1,489,308 71% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 20 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2185 AIRPORT TIF 2185-000-430300-840 REDEVELOPMENT ACTIVITY 1,296,396 2,320,077 1,023,681 44% ------------------------------------------------- TOTAL 2185 AIRPORT TIF 1,296,396 2,320,077 1,023,681 44% ================================================= OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 9,500 9,500 100% 2310-480-470210-356 FED-EX REIMBURSEMENT 8,862 9,000 138 2% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 35,000 70,000 35,000 50% 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 2,500 5,000 2,500 50% ------------------------------------------------- TOTAL OLD SCHOOL TIFS 46,362 93,500 47,138 50% ================================================= GLACIER RAIL PARK TEDD 2312-480-470210-110 SALARIES & WAGES 10,616 22,869 12,253 54% 2312-480-470210-153 HEALTH INSURANCE 2,700 6,224 3,524 57% 2312-480-470210-155 RETIREMENT 866 1,808 942 52% 2312-480-470210-345 TELEPHONE 24 48 24 50% 2312-480-470210-353 AUDIT 1,500 1,500 0 0% 2312-480-470210-522 ADMINISTRATIVE TRANSFER 1,064 2,128 1,064 50% 2312-480-470210-790 REDEVELOPMENT 0 90,000 90,000 100% ------------------------------------------------- TOTAL GLACIER RAIL PARK TEDD 16,769 124,577 107,808 87% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 21 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 1,000 1,000 0 0% 2880-480-470210-354 CONTRACT SERVICES 75 1,000 925 93% 2880-480-470210-711 REDEVELOPMENT 0 225,000 225,000 100% ------------------------------------------------- TOTAL LOAN REVOLVING 1,075 227,000 225,925 100% ================================================= 2881 CD LOAN REV. #2 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 0 405 405 100% 2881-480-470210-711 REDEVELOPMENT 0 275,000 275,000 100% ------------------------------------------------- TOTAL 2881 CD REV. #2 0 275,405 275,405 100% ================================================= 2886 CD MISC. 2886-480-470210-353 AUDITING 1,000 1,000 0 0% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 250 2,000 1,750 88% 2886-480-470210-528 INFORMATION TECH TRANSFER 7,617 15,233 7,616 50% 2886-480-470210-532 OFFICE RENT 0 646 646 100% 2886-480-470210-790 REDEVELOPMENT ACTIVITY 2,000 5,000 3,000 60% 2886-480-470210-810 TRANSFER TO WS TIF 100,000 205,085 105,085 51% 2886-480-470210-815 TRANSFER TO SID 344 DEBT SERVICE 50,000 100,000 50,000 50% ------------------------------------------------- TOTAL CD MISC. 160,867 328,964 168,097 51% ================================================= 2887 RURAL DEVELOPMENT #1 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 22,074 19,014 3,060- -16% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 0 3,060 3,060 100% 2887-480-470210-750 REDEVELOPMENT LOANS 323 150,000 149,677 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #1 22,397 172,074 149,677 87% ================================================= 2888 RURAL DEVELOPMENT #2 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 10,025 8,468 1,557- -18% 2888-480-470210-620 INTEREST EXPENSE-USDA LOAN 61-03 0 1,557 1,557 100% 2888-480-470210-750 REDEVELOPMENT LOANS 0 300,000 300,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #2 10,025 310,025 300,000 97% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 22 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2953 EPA BROWNFIELDS 2953-480-470210-354 CONT SERV/PETROLEUM 86,856 109,561 22,705 21% 2953-480-470210-373 TRAVEL/PETROLEUM 0 1,429 1,429 100% 2953-480-470215-373 TRAVEL/HAZARDOUS 0 5,382 5,382 100% ------------------------------------------------- TOTAL EPA BROWNSFIELD 86,856 116,372 29,516 25% ================================================= 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES-PETROLEUM 0 218,322 218,322 100% 2955-480-470210-725 REVOLVED FUNDS-PETROLEUM 0 100,500 100,500 100% 2955-480-470215-229 SUPPLIES-HAZARDOUS SUBSTANCES 0 267,673 267,673 100% ------------------------------------------------- TOTAL BROWNFIELDS LOAN REV. 0 586,495 586,495 100% ================================================= FY21 AIRPORT GRANT 2974-430-430310-934 CAPITAL IMPROVEMENTS - LIGHTS/FENCI 0 236,712 236,712 100% ------------------------------------------------- TOTAL 2974 FY21 AIRPORT GRANT 0 236,712 236,712 100% ================================================= 2991 TIGER GRANT 2991-480-470245-790 REDEVELOPMENT - TRAIL 0 3,803,909 3,803,909 100% ------------------------------------------------- TOTAL TIGER GRANT 0 4,040,621 4,040,621 100% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 23 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD 0 10,000 10,000 100% 2915-413-420140-218 SMALL EQUIP -Stonegarden 0 30,000 30,000 100% ------------------------------------------------- TOTAL 2915 STONEGARDEN GRANT 0 40,000 40,000 100% ================================================= 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 32,305 69,526 37,221 54% 2916-413-420140-121 OVERTIME 4,672 13,000 8,328 64% 2916-413-420140-153 HEALTH INSURANCE 5,510 12,889 7,379 57% 2916-413-420140-155 RETIREMENT 4,201 9,348 5,147 55% ------------------------------------------------- TOTAL 2916 DRUG ENFORCEMENT 46,687 104,763 58,076 55% ================================================= 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 299 4,000 3,701 93% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 3,243 35,000 31,757 91% 2919-413-420140-127 SCHOOL DIST. OT 645 20,000 19,355 97% 2919-413-420140-218 JAG GRT/BODY ARMOR & BODY WORN CAME 5,050 15,461 10,411 67% 2919-413-420140-219 EQUIPMENT FROM CORONAVIRUS GRANT 17,082 33,119 16,037 48% 2919-413-420140-220 EQUIPMENT-FUNDED BY DONATIONS 0 4,000 4,000 100% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 3,697 6,000 2,303 38% ------------------------------------------------- TOTAL LAW ENF. GRANT 30,016 117,580 87,564 74% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 24 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CAPITAL PROJECT FUNDS 4170 IMPOUND/STORAGE FACILITY 4170-400-411230-925 IMPOUND/STORAGE FACILITY 0 178,520 178,520 100% ------------------------------------------------- TOTAL IMPOUND/STORAGE FACILITY 0 178,520 178,520 100% 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION 3,853 25,000 21,147 85% ------------------------------------------------- TOTAL 4290 WALK & CURB 3,853 203,520 199,667 98% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 25 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ENTERPRISE FUNDS WATER REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 1,080 2,000 920 46% 5210-000-343210-000 METERED WATER SALES 2,281,414 3,319,443 1,038,029 31% 5210-000-343220-000 OTHER (CONST.) WATER SALES 22,243 25,000 2,757 11% 5210-000-343230-000 METER REPLACEMENT FEE 73,922 136,000 62,078 46% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 52,299 51,500 799- -2% 5210-000-343270-000 WATER TURN ON FEES 2,555 5,000 2,445 49% 5210-000-343275-000 TAG FEE 20,160 33,000 12,840 39% 5210-000-343365-000 LATECOMER ADMIN FEE 6,525 10,000 3,475 35% 5210-000-371010-000 INVESTMENT EARNINGS 44,908 78,000 33,092 42% 5210-000-383010-000 TRANSFER FROM IMPACT FEE FUND (ADMI 8,750 17,500 8,750 50% 5210-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 66,667 200,000 133,333 67% ------------------------------------------------- TOTAL WATER REVENUE 2,580,523 3,877,443 1,296,920 33% ================================================= WATER FACILITIES 5210-447-430550-110 SALARIES-WATER 287,761 788,169 500,408 63% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 4,274 20,000 15,726 79% 5210-447-430550-153 HEALTH INSURANCE 58,060 173,129 115,069 66% 5210-447-430550-155 RETIREMENT 22,633 60,134 37,501 62% 5210-447-430550-210 OFFICE SUPPLIES /EQUIP/COMPUTERS/GI 7,988 23,000 15,012 65% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 1,951 9,000 7,049 78% 5210-447-430550-226 CHLORINE & CHEMICALS 19,819 39,000 19,181 49% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 1,831 4,500 2,669 59% 5210-447-430550-231 GAS & OIL 8,358 35,000 26,642 76% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 848 1,000 152 15% 5210-447-430550-336 LICENSES & FEES 52 19,500 19,448 100% 5210-447-430550-341 ELECTRICITY 87,131 160,000 72,869 46% 5210-447-430550-344 NATURAL GAS 2,945 15,500 12,555 81% 5210-447-430550-345 TELEPHONE & COMMUNICATION 5,685 12,000 6,315 53% 5210-447-430550-349 LAB SERVICES 7,350 20,000 12,650 63% 5210-447-430550-353 AUDITING 3,500 3,500 0 0% 5210-447-430550-354 CONTRACT SERVICES 11,738 55,000 43,262 79% 5210-447-430550-355 NOFFSINGER TRANSMISSION CONDITION A 0 260,500 260,500 100% 5210-447-430550-356 BACKBONE CONDITION ASSESS./WTR RIGH 9,096 205,500 196,404 96% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 1,550 15,000 13,450 90% 5210-447-430550-366 BUILDING MAINTENANCE 2,579 35,000 32,421 93% 5210-447-430550-373 DUES & TRAINING 25 13,000 12,975 100% 5210-447-430550-388 MEDICAL SERVICES 83 700 618 88% 5210-447-430550-410 CONSTRUCTION MATERIALS 14,227 35,000 20,773 59% 5210-447-430550-422 HYDRANTS 2,369 10,000 7,631 76% 5210-447-430550-423 MATERIALS FOR MAINS 1,081 14,000 12,919 92% 5210-447-430550-424 MATERIALS -SERVICE LINES 820 12,000 11,180 93% 5210-447-430550-425 MATERIALS PUMPS/WELLS 958 45,000 44,042 98% 5210-447-430550-426 METERS FM METER CASH (10125) 11,480 50,679 39,199 77% 5210-447-430550-510 PROPERTY & LIABILITY INS. 40,980 40,980 0- 0% 5210-447-430550-512 UNINSURED LOSS-DEDUCTIBLE 4,029 10,000 5,971 60% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 18,138 36,275 18,137 50% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 52,335 104,671 52,336 50% 5210-447-430550-528 INFORMATION TECH TRANSFER 33,691 67,382 33,691 50% 5210-447-430550-532 LEASE PAYMENTS 0 4,000 4,000 100% THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 26 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-925 NOFFSINGER REHAB ALTERNATIVE 0 520,000 520,000 100% 5210-447-430550-935 METER SYSTEM REPLACEMENT 0 317,000 317,000 100% 5210-447-430550-937 BUFFALO HILL FLOW CONTROL UPGRADE 0 140,000 140,000 100% 5210-447-430550-948 METERS (METER FUNDS) 010125 15,175 0 15,175- 0% 5210-447-430550-950 1ST AVE WN MAIN REPLACEMENT 0 30,000 30,000 100% 5210-447-430550-951 SECURITY SCADA UPGRADES 55,449 305,000 249,551 82% 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 7,574 10,000 2,426 24% 5210-447-430550-954 ELEVATED STORAGE TANK & WELL 0 8,270,000 8,270,000 100% 5210-447-430550-958 2ND AVE W RR FROM CENTER TO 2ND ST 659 302,000 301,341 100% 5210-447-430550-971 10TH AVE W & 2ND ST W R&R 345,710 431,380 85,670 20% ------------------------------------------------- SUBTOTAL WATER FACILITIES 1,149,930 12,728,499 11,578,569 91% ------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES-WATER BILLING 57,892 121,093 63,201 52% 5210-447-430560-153 HEALTH INSURANCE 17,446 39,753 22,307 56% 5210-447-430560-155 RETIREMENT 4,674 9,596 4,922 51% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 2,808 9,000 6,192 69% 5210-447-430560-353 AUDITING 2,000 2,000 0 0% 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 22,962 40,000 17,038 43% 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 11,323 27,000 15,677 58% 5210-447-430560-356 OTHER CONTRACT SERVICES 38 1,000 963 96% 5210-447-430560-373 DUES & TRAINING 50 3,000 2,950 98% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 5,695 11,390 5,695 50% 5210-447-430560-528 INFORMATION TECH TRANSFER 26,658 53,316 26,658 50% ------------------------------------------------- SUBTOTAL WATER BILLING 151,546 317,148 165,602 52% ------------------------------------------------- REVENUE BONDS 5210-447-490200-610 PRIN - 4 MILE DR TRANSMISSION / WRF 0 90,000 90,000 100% 5210-447-490200-620 INT - 4 MILE DR TRANSMISSION / WRF 64,888 55,000 9,888- -18% 5210-447-490204-610 BOND PRIN-HWY 93 S WTR - 2004 0 79,000 79,000 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 7,704 7,704 0 0% 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 350 350 0 0% 5210-447-490206-610 PRIN-WELL/TANK/8114 2.25% 4TH ST 0 91,000 91,000 100% 5210-447-490206-620 INT-WELL&TANK/8114 2.25% 4TH ST WT 14,816 14,816 0- 0% 5210-447-490210-610 4TH AVE E MAIN REPL/WRF 17393 0 82,352 82,352 100% 5210-447-490210-620 4TH AVE E MAIN REPL/WFR 17393 43,040 43,040 0- 0% 5210-447-490250-610 PRIN-WTR MAIN/WRF 1032R 2%/IDAHO&MA 0 26,000 26,000 100% 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2%/IDAHO&MAIN 260 260 0 0% ------------------------------------------------- SUBTOTAL REVENUE BONDS 131,058 489,522 358,465 73% ------------------------------------------------- DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 950,000 950,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 950,000 950,000 100% ------------------------------------------------- TOTAL WATER FUND 1,432,533 14,485,169 13,052,636 90% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 27 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING WATER IMPACT FEE REVENUE: 5211-000-343225-000 IMPACT FEES 414,244 350,000 64,244- -18% 5211-000-371010-000 INTEREST EARNINGS 6,132 12,000 5,868 49% ------------------------------------------------- TOTAL WATER IMPACT FEES REVENU 420,377 362,000 58,377- -16% ================================================= WATER IMPACT FEES EXPENSES: 5211-447-430555-424 METERS - NEW DEVELOPMENT 29,925 54,000 24,075 45% 5211-447-430555-820 DEBT SERVICE TRANSFER TO 5210 66,667 200,000 133,333 67% 5211-447-430555-825 TRANSFER TO 5210 FOR ADMIN 8,750 17,500 8,750 50% 5211-447-430555-930 CONTRACT MAIN UPSIZE 202,273 515,000 312,727 61% 5211-447-430555-954 ELEVATED TANK & WELL 64,179 448,000 383,821 86% ------------------------------------------------- TOTAL WATER IMPACT FEE EXPENSE 371,794 1,234,500 862,706 70% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 28 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 1,080 2,000 920 46% 5310-000-343310-000 SEWER SERVICE CHARGES 3,052,995 5,991,963 2,938,968 49% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 19,699 14,000 5,699- -41% 5310-000-343365-000 LATECOMER ADMIN FEES 4,148 5,000 852 17% 5310-000-371010-000 INVESTMENT EARNINGS 29,156 60,000 30,844 51% 5310-000-383010-000 ADMIN TRANSFER FROM IMPACT FEE FUND 16,700 33,400 16,700 50% 5310-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 275,000 900,000 625,000 69% ------------------------------------------------- TOTAL SEWER REVENUE 3,398,777 7,006,363 3,607,586 51% ================================================= SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES-SEWER BILLING 49,502 102,807 53,305 52% 5310-454-430620-153 HEALTH INSURANCE 13,292 29,810 16,518 55% 5310-454-430620-155 RETIREMENT - PERD 3,987 8,127 4,140 51% 5310-454-430620-215 OFFICE SUPPLIES/computers 2,808 9,000 6,192 69% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 0 2,000 2,000 100% 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 22,962 40,000 17,038 43% 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 11,323 27,000 15,677 58% 5310-454-430620-356 OTHER CONTRACT SERVICES 38 1,000 963 96% 5310-454-430620-373 DUES & TRAINING 50 3,000 2,950 98% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 5,196 10,391 5,195 50% 5310-454-430620-528 INFORMATION TECH. TRANSFER 26,658 53,316 26,658 50% ------------------------------------------------- SUBTOTAL SEWER BILLING COSTS 135,816 286,451 150,635 53% ------------------------------------------------- SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES-SANITARY SEWER 131,953 308,061 176,108 57% 5310-454-430630-121 OVERTIME 15 5,500 5,485 100% 5310-454-430630-153 HEALTH INSURANCE 28,448 81,790 53,342 65% 5310-454-430630-155 RETIREMENT 10,273 23,625 13,352 57% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 6,320 13,200 6,880 52% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 1,020 13,350 12,330 92% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 1,029 2,300 1,271 55% 5310-454-430630-231 GAS & OIL 3,760 12,000 8,240 69% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 40 500 460 92% 5310-454-430630-341 ELECTRICITY 23,805 57,000 33,195 58% 5310-454-430630-344 NATURAL GAS 6,007 16,500 10,493 64% 5310-454-430630-345 TELEPHONE & COMMUNICATION 8,887 26,500 17,613 66% 5310-454-430630-353 AUDITING 5,000 3,000 2,000- -67% 5310-454-430630-354 CONTRACT SERVICES 15,219 25,000 9,781 39% 5310-454-430630-356 CONSULTANTS - MODELING/RATE STUDY 0 15,000 15,000 100% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 3,669 16,875 13,206 78% 5310-454-430630-373 DUES & TRAINING 77 9,250 9,173 99% 5310-454-430630-388 MEDICAL SERVICES 338 500 163 33% 5310-454-430630-410 CONSTRUCTION MATERIALS 1,162 10,000 8,838 88% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 26,845 70,000 43,155 62% 5310-454-430630-510 PROPERTY & LIABILITY INS. 58,040 58,040 0- 0% 5310-454-430630-512 UNINSURED LOSS-DEDUCTIBLE 0 25,000 25,000 100% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 5,702 11,404 5,702 50% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 25,645 51,291 25,646 50% THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 29 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-528 INFORMATION TECH TRANSFER 22,266 44,532 22,266 50% 5310-454-430630-532 OFFICE RENT / BNSF LEASE 6,689 0 6,689- 0% 5310-454-430630-922 L.S. #9 IMPROVEMENTS/DESIGN 0 250,000 250,000 100% 5310-454-430630-940 MACHINERY & EQUIPMENT 0 245,000 245,000 100% 5310-454-430630-948 REPAIR & REPLC OF SEWER MAIN 458,336 599,430 141,094 24% 5310-454-430630-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 57,800 57,800 100% 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 7,574 10,000 2,426 24% 5310-454-430630-954 MN REPL. DESIGN - 1ST & 2ND AVE EN 0 121,000 121,000 100% 5310-454-430630-957 WEST SIDE INTERCEPTOR (BONDED) 773,022 2,579,648 1,806,626 70% 5310-454-430630-959 L.S. 5a REMOVAL 0 335,000 335,000 100% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 0 50,000 50,000 100% 5310-454-430630-961 6TH ALLEY E - S OF 14TH & 13TH 0 263,000 263,000 100% 5310-454-430630-962 SEWER MAIN SLIP LINING 232,068 395,000 162,932 41% ------------------------------------------------- SUBTOTAL SEWER COLLECTION 1,863,209 5,806,096 3,942,887 68% ------------------------------------------------- REVENUE BONDS/SANITARY 5310-454-490200-610 PRINCIPAL WESTSIDE INTERCEPTOR BOND 0 334,000 334,000 100% 5310-454-490200-620 INTEREST-WESTSIDE INTERCEPTOR BOND 331,825 270,000 61,825- -23% 5310-454-490200-630 FISCAL AGENT FEE-WESTSIDE INTERCEPT 0 350 350 100% 5310-454-490204-610 PRINCIPAL - HWY 93 S/SRF5125/2.25% 0 89,000 89,000 100% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 7,740 7,741 1 0% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25% 0 350 350 100% ------------------------------------------------- SUBTOTAL REVENUE BONDS 339,565 701,441 361,876 52% ------------------------------------------------- DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 500,000 500,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION-SANITARY 0 500,000 500,000 100% ------------------------------------------------- SUBTOTAL SANITARY SEWER 2,202,774 7,007,537 4,804,763 69% ------------------------------------------------- WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 209,801 468,577 258,776 55% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-121 OVERTIME 9,356 22,500 13,144 58% 5310-455-430640-153 HEALTH INSURANCE 40,333 97,675 57,342 59% 5310-455-430640-155 RETIREMENT 17,026 35,640 18,614 52% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 5,506 11,500 5,994 52% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 2,687 3,000 313 10% 5310-455-430640-225 ALUM 7,058 43,500 36,442 84% 5310-455-430640-226 CHLORINE & CHEMICALS 57,130 111,000 53,870 49% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 4,849 7,000 2,151 31% 5310-455-430640-231 GAS & OIL 5,746 19,000 13,254 70% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 0 550 550 100% 5310-455-430640-336 LICENSES & FEES 93 14,000 13,907 99% 5310-455-430640-341 ELECTRICITY 95,768 193,000 97,232 50% 5310-455-430640-342 WATER 1,504 7,500 5,996 80% 5310-455-430640-344 NATURAL GAS 16,197 82,000 65,803 80% THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 30 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-345 TELEPHONE & COMMUNICATION 3,238 12,050 8,812 73% 5310-455-430640-353 AUDITING 2,500 2,500 0 0% 5310-455-430640-354 CONTRACT-GLACIER GOLD 55,857 135,000 79,143 59% 5310-455-430640-355 CONTRACT - LAND FILL & OTHER 24,608 49,000 24,392 50% 5310-455-430640-356 CONSULTANTS 107,699 267,000 159,301 60% 5310-455-430640-358 CONSULTANT- PERMIT/RATE STDY/TMDL 3,471 145,000 141,529 98% 5310-455-430640-360 MISC. MAINT SERVICES 16,989 30,000 13,011 43% 5310-455-430640-366 BUILDING MAINTENANCE 12,035 51,000 38,965 76% 5310-455-430640-373 DUES & TRAINING 962 9,500 8,538 90% 5310-455-430640-388 MEDICAL SERVICES 165 500 335 67% 5310-455-430640-510 PROPERTY & LIABILITY INS. 49,256 49,256 0 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 10,221 20,443 10,222 50% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 59,957 119,914 59,957 50% 5310-455-430640-528 INFORMATION TECH TRANSFER 19,042 38,083 19,041 50% 5310-455-430640-921 DESIGN-DOME FOR SECONDARY CLARIFIER 0 403,000 403,000 100% 5310-455-430640-930 BIOSOLIDS ALTERNATE DISPOSAL ENG 0 178,052 178,052 100% 5310-455-430640-933 NEW EQ BASIN 0 2,400,000 2,400,000 100% ------------------------------------------------- SUBTOTAL WWTP OPERATIONS 839,056 5,031,740 4,192,684 83% ------------------------------------------------- WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 109,510 193,000 83,490 43% 5310-455-430645-934 SECONDARY DIGESTER LID REPLC 20,531 41,766 21,235 51% 5310-455-430645-940 MACHINERY & EQUIPMENT 79,310 324,000 244,690 76% 5310-455-430645-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 75,480 75,480 100% ------------------------------------------------- SUBTOTAL WWTP REPLACEMENT 209,351 634,246 424,895 67% ------------------------------------------------- WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 55,279 119,920 64,641 54% 5310-455-430646-153 HEALTH INSURANCE 7,950 18,222 10,272 56% 5310-455-430646-155 RETIREMENT 4,284 9,044 4,760 53% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 1,175 6,000 4,825 80% 5310-455-430646-218 NON-CAPITAL EQUIPMENT 11,436 13,500 2,064 15% 5310-455-430646-222 LAB SUPPLIES 6,360 16,500 10,140 61% 5310-455-430646-349 LAB SERVICES 9,240 15,000 5,760 38% 5310-455-430646-350 PRETREATMENT SERVICE 2,287 15,000 12,713 85% 5310-455-430646-362 EQUIPMENT MAINTENANCE 2,458 5,500 3,042 55% 5310-455-430646-373 DUES & TRAINING 344 5,000 4,656 93% 5310-455-430646-940 EQUIPMENT - ANALYZER 43,347 47,000 3,653 8% ------------------------------------------------- SUBTOTAL WWTP LAB OPERATIONS 144,160 270,686 126,526 47% DEBT SERVICE - WWTP 5310-455-490227-610 PRINCIPAL - WWTP IMP/SRF8164R/2.25% 0 871,000 871,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 141,896 141,897 1 0% 5310-455-490228-610 PRINC - WWTP DIGESTER LID/SRF 13326 0 50,000 50,000 100% 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 23,055 23,055 0 0% ------------------------------------------------- SUBTOTAL DEBT SERVICE - WWTP 164,951 1,085,952 921,001 85% ------------------------------------------------- DEPRECIATION/REPL. - WWTP THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 31 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-510400-831 DEPR. EXP. - WWTP (INCLUDES 010125 0 1,250,000 1,250,000 100% ------------------------------------------------- SUTOTAL WWTP DEPRECIATION/REPL 0 1,250,000 1,250,000 100% ------------------------------------------------- SUBTOTAL WWTP 1,357,518 8,272,624 6,915,106 84% ------------------------------------------------- TOTAL BILLING/SANITARY/WWTP 3,696,107 15,566,612 11,870,505 76% ================================================= SEWER IMPACT FEE REVENUE 5311-000-343330-000 SANITARY IMPACT FEES 776,847 460,000 316,847- -69% 5311-000-343335-000 TREATMENT IMPACT FEES 423,804 208,000 215,804- -104% 5311-000-371010-000 SANITARY INTEREST EARNINGS 9,784 18,000 8,216 46% 5311-000-371015-000 TREATMENT INTEREST EARNINGS 8,923 14,400 5,477 38% ------------------------------------------------- TOTAL SEWER IMPACT FEES REVENU 1,219,357 700,400 518,957- -74% ================================================= SEWER IMPACT FEE EXPENSES 5311-454-430635-820 TRANSFER TO 5310 FOR DEBT (SANITARY 200,000 675,000 475,000 70% 5311-454-430635-825 TRANSFER TO 5310 FOR ADMIN 11,500 23,000 11,500 50% 5311-454-430635-950 RR & UPSIZE - WWTP MAIN (66% - 34% 0 146,520 146,520 100% 5311-454-430635-955 MAIN & L.S. UPSIZE 37,469 400,000 362,531 91% 5311-454-430635-957 WEST SIDE INTERCEPTOR PH. 1 34,893 86,692 51,799 60% 5311-455-430644-820 TRANSFER TO 5310 FOR DEBT 75,000 225,000 150,000 67% 5311-455-430644-825 TRANSFER TO 5310 FOR ADMIN 5,200 10,400 5,200 50% 5311-455-430644-929 CONSTRUCT NEW EQ BASIN 0 469,800 469,800 100% 5311-455-430644-930 BIOSOLIDS ALT. DISPOSAL ENG. (39%) 0 113,837 113,837 100% 5311-455-430644-950 RR & UPSIZE - WWTP MAIN (66% - 34% 0 112,200 112,200 100% ------------------------------------------------- TOTAL SEWER IMPACT FEE EXPENSE 364,062 2,262,449 1,898,387 84% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 32 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM SEWER REVENUE 5349-000-323108-000 PW PLAN REVIEW FEES 1,080 1,000 80- -8% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 2,990 1,500 1,490- -99% 5349-000-343034-000 PERMIT FEES 1,610 1,000 610- -61% 5349-000-343035-000 STORM SEWER CHARGES 2,682 1,800 882- -49% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 1,791,692 1,767,772 23,920- -1% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 1,896 2,500 604 24% 5349-000-365000-000 DONATIONS & STRM SWR CLASS 120 0 120- 0% 5349-000-371010-000 INTEREST ON INVESTMENTS 13,513 25,000 11,487 46% 5349-000-383010-000 IMPACT FEE 5% ADMIN - TFR FROM IMPA 3,000 6,000 3,000 50% 5349-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 40,000 150,000 110,000 73% ------------------------------------------------- TOTAL STORM REVENUE 1,858,584 1,956,572 97,988 5% ================================================= STORM SEWER 5349-453-430246-110 SALARIES-STORM SEWER 206,654 493,494 286,840 58% 5349-453-430246-121 OVERTIME 15 4,000 3,985 100% 5349-453-430246-153 HEALTH INSURANCE 41,947 111,722 69,775 62% 5349-453-430246-155 RETIREMENT 16,180 37,805 21,625 57% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 10,262 17,100 6,838 40% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 508 11,000 10,492 95% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100% 5349-453-430246-231 GAS & OIL 3,498 11,500 8,002 70% 5349-453-430246-345 TELEPHONE & COMMUNICATION 1,125 2,500 1,375 55% 5349-453-430246-353 AUDITING 1,150 1,150 0 0% 5349-453-430246-354 CONTRACT SERVICE 4,500 7,000 2,500 36% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 20,235 135,000 114,765 85% 5349-453-430246-358 CONSULTANTS 0 10,000 10,000 100% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 0 30,000 30,000 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 1,328 8,000 6,673 83% 5349-453-430246-362 GROUNDWATER MONITORING 0 6,500 6,500 100% 5349-453-430246-371 CURB & GUTTER 571 21,000 20,429 97% 5349-453-430246-373 DUES & TRAINING 269 9,250 8,981 97% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 2,682 10,000 7,318 73% 5349-453-430246-510 PROPERTY & LIABILITY INS. 11,917 16,917 5,000 30% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 5,702 11,404 5,702 50% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 22,980 45,960 22,980 50% 5349-453-430246-528 INFORMATION TECH TRANSFER 20,455 40,909 20,454 50% 5349-453-430246-530 BNSF LEASE PMT 4,685 5,000 315 6% 5349-453-430246-968 RR W CENTER-7TH AVE W TO MERIDIAN 0 372,000 372,000 100% 5349-453-430246-970 REG. FACILITIES & PIPING DESIGN (BO 0 3,500,000 3,500,000 100% 5349-453-430247-952 STORM DRAIN CORRECTION (NEW & C/O) 128,108 200,000 71,892 36% 5349-453-430247-953 SHOP COMPLEX PAVEMENT (C/O) 7,574 10,000 2,426 24% 5349-453-430247-954 N. MAIN ST STORMWATER PROJ. 0 252,500 252,500 100% 5349-453-430247-956 WYOMING ST 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-430247-968 RR W CENTER-7TH AVE W TO MERIDIAN 0 300,000 300,000 100% 5349-453-430249-940 MACHINERY FROM REPLACEMENT 0 245,000 245,000 100% ------------------------------------------------- SUBTOTAL STORM OPERATIONS 512,343 6,604,011 6,091,668 92% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 33 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM BONDS/LOANS 5349-453-490200-610 PRINCIPAL - 4TH AVE E BOND 0 2,999 2,999 100% 5349-453-490200-620 INTEREST-4TH AVE E BOND 1,568 1,568 1 0% 5349-453-490225-610 PRINCIPAL - REGIONAL FACILITIES 0 144,030 144,030 100% 5349-453-490225-620 INTEREST - REGIONAL FACILITIES 0 91,402 91,402 100% ------------------------------------------------- SUBTOTAL STORM BONDS/LOANS 1,568 239,999 238,432 99% ------------------------------------------------- DEPRECIATION 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 360,000 360,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 360,000 360,000 100% ------------------------------------------------- TOTAL STORM EXPENSE 513,911 7,204,010 6,690,099 93% ================================================= STORM SEWER IMPACT FEE REVENUE 5348-000-343033-000 IMPACT FEES 170,395 120,000 50,395- -42% 5348-000-371010-000 INTEREST EARNINGS 8,426 15,000 6,574 44% ------------------------------------------------- TOTAL STORM IMPACT FEES REVENU 178,821 135,000 43,821- -32% ================================================= STORM SWR IMPACT FEE EXPENSES 5348-453-430248-820 DEBT SERVICE TRANSFER TO 5349 40,000 150,000 110,000 73% 5348-453-430248-825 TRANSFER TO 5349 FOR ADMIN 3,000 6,000 3,000 50% 5348-453-430248-959 REG FACILITIES & PIPING DESIGN 165,959 1,450,908 1,284,949 89% 5348-453-430248-960 STORMWATER FACILITY UPSIZING (CARRY 0 230,000 230,000 100% 5348-453-430248-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% ------------------------------------------------- TOTAL STORM IMPACT FEE EXPENSE 208,959 1,886,908 1,677,949 89% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 34 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SOLID WASTE REVENUE: 5510-000-343360-000 SALE OF MAT/AUCTION 5,090 2,500 2,590- -104% 5510-000-343410-000 GARBAGE COLLECTION-ASSESSED 1,062,680 1,035,000 27,680- -3% 5510-000-343420-000 GARBAGE COLLECTION-NOT ASSESSED 24,965 23,000 1,965- -9% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,353 2,000 647 32% 5510-000-371010-000 INVESTMENT EARNINGS 5,781 10,800 5,019 46% ------------------------------------------------- TOTAL SOLID WASTE REVENUE 1,099,869 1,073,300 26,569- -2% ================================================= SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES-SOLID WASTE 190,225 442,363 252,138 57% 5510-460-430840-121 OVERTIME 3,080 6,500 3,420 53% 5510-460-430840-153 HEALTH INSURANCE 39,891 108,766 68,875 63% 5510-460-430840-155 RETIREMENT 14,940 33,664 18,724 56% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 9,573 15,500 5,927 38% 5510-460-430840-218 EQUIPMENT-GARBAGE CONTAINERS 68 37,500 37,432 100% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 3,205 5,500 2,295 42% 5510-460-430840-231 GAS & OIL 18,429 60,000 41,571 69% 5510-460-430840-341 ELECTRICITY 720 2,050 1,330 65% 5510-460-430840-344 NATURAL GAS 715 4,500 3,785 84% 5510-460-430840-345 TELEPHONE & COMMUNICATION 904 2,000 1,096 55% 5510-460-430840-354 CONTRACT SERVICES 2,510 22,000 19,490 89% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 1,201 5,700 4,499 79% 5510-460-430840-366 BUILDING MAINTENANCE 1,673 5,000 3,328 67% 5510-460-430840-373 DUES & TRAINING 0 7,000 7,000 100% 5510-460-430840-388 MEDICAL SERVICES 110 700 590 84% 5510-460-430840-510 PROPERTY & LIABILITY INS. 20,507 20,507 0 0% 5510-460-430840-512 UNINSURED LOSS-DEDUCTIBLE 0 4,000 4,000 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 44,325 88,650 44,325 50% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 20,786 41,572 20,786 50% 5510-460-430840-528 INFORMATION TECH TRANSFER 16,646 33,293 16,647 50% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 20,000 40,000 20,000 50% 5510-460-430840-944 VEHICLES (Replacement $) 204,881 585,000 380,119 65% 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 7,574 10,000 2,426 24% 5510-460-430845-224 JANITORIAL SUPPLIES 0 500 500 100% 5510-460-430845-341 ELECTRICITY 650 3,500 2,850 81% 5510-460-430845-342 WATER 210 2,000 1,790 90% 5510-460-430845-344 NATURAL GAS 959 6,000 5,041 84% 5510-460-430845-360 REPAIR & MAINT SERVICES 7,679 17,000 9,321 55% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% ------------------------------------------------- TOTAL SOLID WASTE EXPENSE 631,461 1,760,765 1,129,304 64% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 35 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 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 168,000 336,000 168,000 50% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 55,166 210,000 154,834 74% 6030-000-371010-000 INVESTMENT EARNINGS 790 1,000 210 21% 6030-000-393000-000 INTERNAL SERVICES-DATA 265,646 531,292 265,646 50% ------------------------------------------------- TOTAL INFORMATION TECH REVENUE 489,602 1,078,292 588,690 55% ================================================= INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 153,263 366,388 213,125 58% 6030-401-410580-121 OVERTIME 42 1,000 958 96% 6030-401-410580-153 HEALTH INSURANCE 30,647 88,484 57,837 65% 6030-401-410580-155 RETIREMENT 12,437 29,474 17,037 58% 6030-401-410588-218 COMPUTERS - ADMINISTRATIVE DEPTS 1,890 5,310 3,420 64% 6030-403-410580-215 COMPUTER SUPPLIES 453 2,865 2,412 84% 6030-403-410580-218 EQUIPMENT-NOT CAPITAL 9,312 34,295 24,983 73% 6030-403-410580-325 WEBSITE 5,248 6,670 1,422 21% 6030-403-410580-345 PAGER/PHONE 14 2,800 2,786 100% 6030-403-410580-346 SUMMITNET & ISPS 4,876 14,028 9,152 65% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,597 5,220 1,623 31% 6030-403-410580-354 MAINTENANCE CONTRACTS 3,828 65,100 61,272 94% 6030-403-410580-355 LICENSES 3,867 19,950 16,083 81% 6030-403-410580-356 MAINTENANCE CONTRACTS 75,114 86,350 11,236 13% 6030-403-410580-357 GRANICUS 5,393 5,300 93- -2% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 52,265 66,560 14,295 21% 6030-403-410580-359 PRIVATE FIBER - CITY NETWORK 0 19,000 19,000 100% 6030-403-410580-360 MULTI-FACTOR AUTHENTICATION 0 18,000 18,000 100% 6030-403-410580-373 DUES & TRAINING 3,440 15,880 12,440 78% 6030-403-410580-510 INSURANCE 6,077 6,077 0- 0% 6030-403-410583-218 TV-Video Equipment & programming 2,585 3,500 915 26% 6030-403-410585-229 COPIER,FAX, SUPPLIES 4,036 18,475 14,439 78% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 41,790 174,788 132,998 76% 6030-403-410585-532 COPIER LEASES 7,463 15,504 8,041 52% 6030-403-410585-942 Servers - capital contingency 0 43,204 43,204 100% 6030-403-510400-831 DEPRECIATION EXPENSE 0 10,000 10,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 0 3,505 3,505 100% 6030-405-410588-940 COMPUTERS - SWITCHES 0 53,000 53,000 100% 6030-410-410588-218 COMPUTERS - DPW 4,074 3,200 874- -27% 6030-413-410588-218 COMPUTERS - POLICE DEPT 14,647 24,545 9,898 40% 6030-413-410588-354 POLICE - HOSTED SERVER 1,406 2,850 1,444 51% 6030-416-410588-218 COMPUTERS - FIRE 0 6,725 6,725 100% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 2,683 5,200 2,517 48% 6030-436-410588-218 COMPUTERS - PARKS 373 3,615 3,242 90% 6030-480-410588-218 COMMUNITY DEVELOPMENT 0 1,200 1,200 100% ------------------------------------------------- TOTAL INFORMATION TECH EXPENSE 450,818 1,228,062 777,244 63% ================================================= THE CITY OF KALISPELL, MONTANA01.21.2021 16:34 gb8501_pg.php/Job No: 45842 Page 36 of 36 USER: RGW MID-YEAR FY21 FINANCIAL REPORT thru DECEMBER 31 50.00 % Yr Complete For Fiscal Year: 2021 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 290,000 580,000 290,000 50% 6010-000-371010-000 INVESTMENT EARNINGS 481 1,200 719 60% ------------------------------------------------- TOTAL CENTRAL GARAGE REVENUE 290,481 581,200 290,719 50% ================================================= CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 79,854 166,712 86,858 52% 6010-410-431330-121 OVERTIME 1,035 2,500 1,465 59% 6010-410-431330-153 HEALTH INSURANCE 16,485 45,611 29,126 64% 6010-410-431330-155 RETIREMENT 5,842 12,600 6,758 54% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 1,253 11,500 10,247 89% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 1,880 8,000 6,120 77% 6010-410-431330-230 OIL 7,610 25,500 17,890 70% 6010-410-431330-231 GAS 229 1,500 1,271 85% 6010-410-431330-232 VEHICLE PARTS 56,406 136,000 79,594 59% 6010-410-431330-233 TIRES 36,034 54,000 17,966 33% 6010-410-431330-238 FILTERS 3,960 9,000 5,040 56% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 909 2,000 1,091 55% 6010-410-431330-341 ELECTRICITY 1,125 2,200 1,075 49% 6010-410-431330-344 NATURAL GAS 1,213 6,500 5,287 81% 6010-410-431330-354 CONTRACT SERVICES 13,638 32,000 18,362 57% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 97 6,000 5,903 98% 6010-410-431330-373 DUES & TRAINING 210 8,500 8,290 98% 6010-410-431330-388 MEDICAL SERVICES 55 500 445 89% 6010-410-431330-510 INSURANCE 4,201 4,201 0 0% 6010-410-431330-528 INFORMATION TECH TRANSFER 7,617 15,233 7,616 50% 6010-410-431330-944 MACHINERY & EQUIPMENT 34,931 35,000 69 0% ------------------------------------------------- TOTAL CENTRAL GARAGE EXPENSES 274,584 585,057 310,473 53% =================================================