The URL can be used to link to this page

04-17-20 City Manager Report1 City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 4/17/2020 1.Parks Department Colter Hansen has been named as our new Forestry Supervisor. Colter has been an employee of the Parks Department for two years. Forestry continues to work on pruning trees along 3rd Avenue East. The crew working at KYAC have completed thatching of all turf areas. Their next step will be charging the irrigation system, noting any repairs needed, and beginning to apply fertilizer to the turf. They have completed tensioning the backdrops of the softball and baseball backstop nets. Parks crews are making repairs to items that have been vandalized over the winter and removing graffiti. The biggest task has been repairing the supply lines to the waterslides. We are planning to pressure test the repairs in the coming weeks. Recreation is preparing the Woodland Water Park in anticipation of the summer 2020 season. This includes draining and cleaning pools, rebuilding pumps and repairing any equipment that was damaged/ vandalized over the winter. We have received over 40 applications for Woodland Water Park and Camp Woodland Summer Day Camp positions this summer. We are in the process of conducting phone interviews and submitting background checks for Woodland Water Park and Camp Woodland Summer Day Camp positions this summer. 2.Police Department As of April 15, the Kalispell Police Department had responded to 9239 calls for service, compared to 10220 in 2019. The period of April 1-15 the KPD responded to 987 calls for service. During that same time frame in 2019, the KPD responded to 1000 calls for service. 2 Western Montana Mental Health has initiated the hiring process to identify candidates for the co-responding social worker program. They are trying to identify candidates to partner with law enforcement in diversifying and strengthening response to mental health crisis. The KPD will contribute by providing an in-house work space. The social worker will respond at the request of all valley law enforcement agencies. Studies have shown it is key for the co-responding program to be based with the agencies to facilitate communication and strengthen relationships. Officer Eric Juhl and officer Kyle Enser will be attending the Montana Law Enforcement Academy in Helena starting April 20. The academy transitioned to the first two weeks being online in response to COVID-19. The Kalispell Police Officers Association along with other law enforcement agencies, worked with our SRO programs to identify children who may be isolated or in need, and delivered Easter baskets to them. Over 500 baskets were assembled by volunteers and delivered in our valley. 3.Fire Department Since the last update, the Kalispell Fire Department has received 132 calls for service. Fire department staff continue to evolve operations and policies in respect to guidance from our medical control officer and other agencies and partners in response to the COVID pandemic. The open burning period is upon us. However, as a reminder, there is no open burning within the city limits of Kalispell. Recreational or warming fires are still allowed. Crews will be transitioning equipment and preparing for the grass fires we typically see in the spring. This is mainly due to large amounts of dead and dried grasses from the winter season and the high winds during this time of year. 4.Public Works The Sylvan Drive Stormwater System Project The Sylvan Drive stormwater system services a large drainage basin in the west and northwest areas of Kalispell. The system consists of large stormwater pipes, manholes and a detention facility that discharges to the natural 3 drainage backwater channel of the Stillwater River. This project was a two-phase project. The first phase replaced the large storm main in Sylvan Drive and installed a water quality treatment unit. The final phase completed this spring, rehabilitated the detention facility, provided slope stabilization, and updated the outfall structure. Fermenter Operating Valve Replacement The fermenter VFA's, (food for the phosphorus microbes as part of the removal process) can be pumped to either Bio-cells #1, #2 or #3. At this time the bio-cell configuration is set so the VFA's come into Bio-cell #3. The stem to operate the 4” valve that is 12’ within bio-cell #3 twisted off, and both the valve and stem needed to be replaced. WWTP operators developed the construction plan and completed this difficult project in a two-day period. The operators did all the setup and prep work on Monday. On Tuesday, bio-cell #3 was taken out of operation and pumped down. It took 2 hours for the Operators to remove and install the new valve, including some required fabrication to the ~10' extension shaft and handle. The operators worked diligently and effectively to complete the entire project in 7 hours and the process was placed back into operation before the end of the workday. 5.Finance Department Budget Department preliminary budget review sessions have been scheduled for the week of April 20. The preliminary budget is scheduled to be delivered to the City Council by May 4, with Council review work sessions tentatively scheduled for the week of May 11. Quarterly Finance Report Please find attached the printouts reflecting the activity for the 1st nine months of fiscal year 2020. This printout reflects payroll earned thru March 28, and accounts payable claims received by March 20. All funds are included with the exception of the debt service funds. REVENUE: General Fund revenue reflects taxes collected thru March 31. Historically, the general fund received about 45% of its property tax revenue in the 4th quarter. A similar distribution this 4th quarter would bring collections to about 101% of the budgeted amount, or about $6,435,000. The City is currently carrying about $17,000 in protest taxes in the General Fund - protest tax dollars are held by the County. City Court fines and fees revenue of $292,899 only reflects July thru February (8 months). This is an 11% increase over the first 8 months of fiscal year 2019. 4 Parks 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. Many other parks revenues, like the pool, are significantly affected by the weather. Ambulance fees for services ($516,309) are 4% less than for the same period last year ($537,779). The first half of the County EMS levy ($63,042) is about 7% more than last fiscal year’s first half payment. Building department permits and fees are about 71% of the budgeted annual amounts. The approximately $491,500 of permits and fees collected this fiscal year is about 7% less than what was collected thru ¾ of last fiscal year. Most Westside TIF revenues are now required to be received into the new bond debt service fund. Metered water sales thru March were $2,414,225. This is 80% of the budgeted amount but about $130,000 less than the fiscal year 2019 period. It is normal for July thru March metered water sales to be in excess of 75%, normally around 80%-85%, of the annual amount because of late summer and fall sprinkling and irrigation. Water impact fees of $437,862 are slightly less than the fiscal year 19 for the same period and only about 12% from the budgeted fiscal year 20 amount. Sewer service charges were $3,409,538, 76% of the budgeted amount. Last year to date sewer service charges were $3,392,078. Sanitary sewer (126%) and treatment plant impact fees (123%) have both exceeded the anticipated fiscal year 2020 amount. Storm sewer and Solid Waste revenue reflect assessments billed for fiscal year 2020. Assessments collected for the storm sewer fund are about $940,000, and for the solid waste fund are just over $590,000. Storm impact fees ($93,332) are 72% of the budgeted fiscal year 2020 amount. EXPENDITURES/EXPENSES: General Fund expenditures reflect 29% budget remaining, compared to 30% for the same period last fiscal year. Some major expenditures such as liability, property insurance, and some transfers are paid during the first quarter for the entire year. This could result in expenditures not being evenly distributed over the fiscal period. Most general fund departments, including police (31%) and fire (27%), have at least 25% budget remaining which should be sufficient. For most funds, payroll expenditures/expenses include the 20th (of 26), or 10th (of 13) for the fire/ambulance, payroll period ending March 28th. Most departments and/or funds should have about 25% remaining for salaries and retirement. There should be 3 months of health insurance budget remaining, or 25%, to be adequate. With a few exceptions, administrative, central garage, and information technology 5 transfers are done monthly and should show 25% remaining. This is the same on the revenue side for fees for services (Central Garage), internal services (Information Technology) and administrative charges (General Fund). The general fund administrative charges may vary slightly as some charges are based on a percentage of revenues collected. Annual budgeted operating transfers are also generally done monthly or quarterly and should show 25% remaining. THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 1 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 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,577,320 6,380,000 2,802,680 44% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 9,078 16,500 7,422 45% 1000-000-311200-000 PERSONAL PROPERTY TAXES 177,101 150,000 27,101- -18% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 7,659 9,000 1,341 15% 1000-000-322101-000 LIQUOR LICENSES 300- 33,000 33,300 101% 1000-000-322300-000 BUSINESS LICENSES 1,617 1,500 117- -8% 1000-000-323012-000 PLANNING FEES 66,527 80,000 13,473 17% 1000-000-323109-000 SITE REVIEW 13,471 16,000 2,529 16% 1000-000-323200-000 PARADE PERMITS 300 1,000 700 70% 1000-000-335030-000 M.V. TAX - AD VALOREM 1,381 400 981- -245% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 58,150 63,000 4,850 8% 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,250 1,400 150 11% 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 2,237,803 2,983,738 745,935 25% 1000-000-341020-000 ADMINISTRATIVE CHARGES 504,531 671,704 167,173 25% 1000-000-341021-000 GRANT ADMIN FEES 26,072 20,000 6,072- -30% 1000-000-341025-000 CITY COLLECTIONS 17,899 5,000 12,899- -258% 1000-000-342010-000 POLICE SERVICES 23,370 27,000 3,630 13% 1000-000-342014-000 RESOURCE OFFICERS 218,961 218,967 6 0% 1000-000-342016-000 KPD REGIONAL TRAINING 1,425 14,500 13,075 90% 1000-000-342020-000 FIRE CHG/TEST FEES/SPEC EVENTS/INST 10 0 10- 0% 1000-000-343018-000 PARKING PERMITS 70,886 95,000 24,114 25% 1000-000-343062-000 AIRPORT FUEL TAXES 2,534 4,000 1,466 37% 1000-000-343063-000 AIRPORT GROUND LEASE (HILTON) 14,855 14,500 355- -2% 1000-000-351000-000 CITY COURT FINES & FEES 292,899 450,000 157,101 35% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 17,889 24,000 6,111 25% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 35,230 58,000 22,770 39% 1000-000-362015-000 INSURANCE REIMBURSEMENTS (FY20 MPOR 0 54,600 54,600 100% 1000-000-362020-000 MMIA GASB 54 REIMBURSEMENT 0 3,000 3,000 100% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 366 10,000 9,634 96% 1000-000-371010-000 INVESTMENT EARNINGS 49,868 45,000 4,868- -11% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 462,500 925,000 462,500 50% ------------------------------------------------- TOTAL GENERAL FUND REVENUE 7,890,653 12,375,809 4,485,156 36% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 2 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 3,030 2,935 95- -3% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 13,750 13,750 0 0% 1000-400-410530-354 OPEB EXPENSE 7,500 7,500 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 2,604 3,500 896 26% 1000-400-410560-312 POSTAGE 12,611 18,000 5,389 30% 1000-400-410560-320 PRINTING & ENVELOPES 5,067 4,000 1,067- -27% 1000-400-410560-354 CONTRACT SERVICES - DOC. SHREDDING 128 1,000 873 87% 1000-400-410580-354 CONTRACT SERVICES 1,142 0 1,142- 0% 1000-400-410600-354 ELECTIONS 0 13,657 13,657 100% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 2,304 3,500 1,196 34% 1000-400-420000-354 CONTRACT 911 CENTER 400,107 534,000 133,893 25% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 334 350 16 4% 1000-400-430300-355 AIRPORT REIMBURSEMENT 16,428 18,500 2,072 11% 1000-400-460000-820 TFR TO FORESTRY (FY18/19) WESTSIDE 1,200,000 1,200,000 0 0% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 15,000 15,000 0 0% 1000-400-460452-366 HOCKADAY MAINTENANCE 0 6,600 6,600 100% 1000-400-510300-000 CONTINGENCY 0 530,000 530,000 100% 1000-400-510310-354 ICMA PLAN FEES 250 500 250 50% 1000-400-510330-513 LIABILITY INSURANCE 140,059 140,807 748 1% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 16,556 50,000 33,444 67% 1000-400-510330-517 PROPERTY INSURANCE 54,676 54,676 0- 0% ------------------------------------------------- SUBTOTAL GEN.GOV'T. 1,891,546 2,618,275 726,729 28% CITY MANAGER 1000-401-410210-110 SALARIES-CITY MANAGER'S OFFICE 110,593 149,741 39,148 26% 1000-401-410210-153 HEALTH INSURANCE 17,470 23,220 5,750 25% 1000-401-410210-155 RETIREMENT 11,788 15,887 4,099 26% 1000-401-410210-210 SUPPLIES 11 1,000 989 99% 1000-401-410210-312 NEWSLETTER/BOOKS 494 400 94- -23% 1000-401-410210-345 TELEPHONE & COMMUNICATION 760 1,790 1,030 58% 1000-401-410210-373 DUES & TRAINING 4,712 10,500 5,788 55% 1000-401-410210-379 MEETINGS 2,685 4,500 1,815 40% ------------------------------------------------- SUBTOTAL CITY MANAGER 148,515 207,038 58,523 28% HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 114,699 137,409 22,710 17% 1000-401-410830-153 HEALTH INSURANCE 13,270 19,916 6,646 33% 1000-401-410830-155 RETIREMENT 7,865 10,868 3,003 28% 1000-401-410830-210 OFFICE SUPPLIES 785 600 185- -31% 1000-401-410830-338 RECRUITMENT/RELOCATION 9,883 20,000 10,117 51% 1000-401-410830-354 CONTRACT SERVICES 970 1,000 30 3% 1000-401-410830-373 DUES & TRAINING 3,099 6,500 3,401 52% ------------------------------------------------- SUBTOTAL HUMAN RESOURCES 150,570 196,293 45,723 23% THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 3 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 46,289 63,087 16,798 27% 1000-402-410100-153 HEALTH INSURANCE 35,973 55,457 19,484 35% 1000-402-410100-155 RETIREMENT 1,904 2,558 654 26% 1000-402-410100-210 OFFICE SUPPLIES 63 500 437 87% 1000-402-410100-335 MT LEAGUE OF CITIES 220 9,225 9,006 98% 1000-402-410100-354 CONTRACT SERVICES 8,700 13,000 4,300 33% 1000-402-410100-373 DUES & TRAINING 8,933 10,800 1,867 17% 1000-402-410100-379 MEETINGS 13,854 20,311 6,457 32% ------------------------------------------------- SUBTOTAL MAYOR/COUNCIL 115,935 174,938 59,003 34% CITY CLERK 1000-402-410150-110 SALARIES-CITY CLERK 71,141 97,169 26,028 27% 1000-402-410150-121 OVERTIME 0 250 250 100% 1000-402-410150-153 HEALTH INSURANCE 15,438 20,526 5,088 25% 1000-402-410150-155 RETIREMENT 5,725 7,732 2,007 26% 1000-402-410150-210 OFFICE SUPPLIES 0 300 300 100% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 186 600 414 69% 1000-402-410150-345 TELEPHONE & COMMUNICATION 400 480 80 17% 1000-402-410150-352 CODIFICATION 2,684 4,100 1,416 35% 1000-402-410150-354 CONTRACT SERVICES 0 300 300 100% 1000-402-410150-373 DUES & TRAINING 1,471 3,200 1,729 54% ------------------------------------------------- SUBTOTAL CITY CLERK 97,045 134,657 37,612 28% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES-FINANCE OFFICE 148,780 216,572 67,792 31% 1000-403-410550-121 OVERTIME 0 500 500 100% 1000-403-410550-153 HEALTH INSURANCE 27,813 36,794 8,981 24% 1000-403-410550-155 RETIREMENT 11,989 17,170 5,181 30% 1000-403-410550-210 SUPPLIES 116 1,000 884 88% 1000-403-410550-322 BOOKS 0 300 300 100% 1000-403-410550-353 CONTRACT SERVICES 140 500 360 72% 1000-403-410550-354 CONTRACT-GRIZZLY SECURITY 672 800 128 16% 1000-403-410550-355 BANK CHARGES & FEES 2,212 3,200 988 31% 1000-403-410550-373 DUES & TRAINING 2,314 7,500 5,186 69% ------------------------------------------------- SUBTOTAL FINANCE 194,035 284,336 90,301 32% THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 4 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CITY ATTORNEY 1000-404-411110-110 SALARIES-CITY ATTORNEY'S 307,505 442,839 135,334 31% 1000-404-411110-153 HEALTH INSURANCE 53,728 80,997 27,269 34% 1000-404-411110-155 RETIREMENT 24,714 35,232 10,518 30% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 781 2,563 1,782 70% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 14,596 17,000 2,404 14% 1000-404-411110-345 TELEPHONE & COMMUNICATION 536 1,025 489 48% 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 30,575 15,600 14,975- -96% 1000-404-411110-373 DUES & TRAINING 7,569 8,000 431 5% ------------------------------------------------- SUBTOTAL CITY ATTORNEY 440,003 603,256 163,253 27% MUNICIPAL COURT 1000-406-410360-110 SALARIES-COURT 168,664 227,463 58,799 26% 1000-406-410360-121 OVERTIME 405 3,500 3,095 88% 1000-406-410360-153 HEALTH INSURANCE 32,750 38,585 5,835 15% 1000-406-410360-155 RETIREMENT 13,454 18,048 4,594 25% 1000-406-410360-210 SUPPLIES 356 4,500 4,144 92% 1000-406-410360-320 PRINTING/BOOKS 1,336 2,500 1,164 47% 1000-406-410360-345 TELEPHONE & COMMUNICATION 34 1,400 1,366 98% 1000-406-410360-353 SECURITY & TECHNOLOGY 68,280 40,000 28,280- -71% 1000-406-410360-354 CONTRACT SERVICES 584 6,250 5,666 91% 1000-406-410360-373 DUES & TRAINING 1,438 10,000 8,562 86% 1000-406-410360-394 JURY & WITNESS FEES 479 7,500 7,021 94% ------------------------------------------------- SUBTOTAL COURT 287,780 359,746 71,966 20% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES-PUBLIC WORKS 14,059 18,839 4,780 25% 1000-410-430100-153 HEALTH INSURANCE 2,432 3,524 1,092 31% 1000-410-430100-155 RETIREMENT 1,113 1,467 354 24% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 7,987 14,000 6,013 43% 1000-410-430100-231 GAS 1,862 3,000 1,138 38% 1000-410-430100-345 TELEPHONE & COMMUNICATION 202 350 148 42% 1000-410-430100-354 CONTRACT SERVICES 318 2,000 1,682 84% 1000-410-430100-373 DUES & TRAINING 2,659 3,500 841 24% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 3,428 4,571 1,143 25% ------------------------------------------------- SUBTOTAL PUBLIC WORKS ADMIN 34,060 51,251 17,191 34% CITY HALL MAINT. 1000-412-411230-110 SALARIES-CITY HALL 46,839 72,913 26,074 36% 1000-412-411230-153 HEALTH INSURANCE 8,847 13,628 4,781 35% 1000-412-411230-155 RETIREMENT 3,608 5,544 1,936 35% 1000-412-411230-220 SECURITY IMPROVEMENTS 1,370 6,793 5,423 80% 1000-412-411230-224 JANITORIAL SUPPLIES 3,519 6,000 2,481 41% 1000-412-411230-241 TOOLS & SUPPLIES 840 1,500 660 44% 1000-412-411230-341 ELECTRICITY 32,900 45,000 12,100 27% 1000-412-411230-344 NATURAL GAS 15,773 32,000 16,227 51% 1000-412-411230-345 TELEPHONE & COMMUNICATION 291 400 109 27% 1000-412-411230-354 CONTRACT SERVICES 8,544 25,000 16,456 66% THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 5 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-355 HVAC MAINTENANCE OCNTRACT 16,710 16,500 210- -1% 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 4,130 6,000 1,870 31% 1000-412-411230-362 EQUIPMENT MAINTENANCE 2,507 10,000 7,493 75% 1000-412-411230-366 BUILDING MAINTENANCE 33,734 41,150 7,416 18% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,253 3,700 447 12% ------------------------------------------------- SUBTOTAL CITY HALL 182,866 286,128 103,262 36% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES-PLANNING & ZONING 185,368 283,588 98,220 35% 1000-420-411020-112 SALARIES - RETIRMENT 43,108 57,078 13,970 24% 1000-420-411020-153 HEALTH INSURANCE 36,418 56,122 19,704 35% 1000-420-411020-155 RETIREMENT 15,041 22,556 7,515 33% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 1,391 5,000 3,609 72% 1000-420-411020-231 GAS 90 400 310 78% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 1,610 2,000 390 19% 1000-420-411020-345 TELEPHONE 463 1,000 537 54% 1000-420-411020-354 CONTRACT SERVICES 533 2,000 1,467 73% 1000-420-411020-373 DUES & TRAINING 5,122 7,000 1,878 27% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 300 401 101 25% ------------------------------------------------- SUBTOTAL PLANNING DEPT. 289,445 437,145 147,700 34% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 49,240 67,380 18,140 27% 1000-480-470210-153 HEALTH INSURANCE 10,360 13,277 2,917 22% 1000-480-470210-155 RETIREMENT 3,965 5,325 1,360 26% 1000-480-470210-210 OFFICE SUPPLIES 367 1,000 633 63% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 0 750 750 100% 1000-480-470210-312 POSTAGE & PRINTING 162 500 338 68% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 500 500 0 0% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 318 750 432 58% 1000-480-470210-354 CONTRACT SERVICES 96 500 404 81% 1000-480-470210-373 DUES & TRAINING 4,930 5,000 70 1% 1000-480-470210-379 MEETINGS 351 1,500 1,149 77% ------------------------------------------------- SUBTOTAL COMMUNITY DEVELOPMENT 70,288 96,482 26,194 27% THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 6 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES-POLICE 1,726,464 2,399,735 673,271 28% 1000-413-420140-112 SALARIES-SEVERANCE 33,007 22,000 11,007- -50% 1000-413-420140-114 SALARY -comptime buyout 2,743 13,600 10,857 80% 1000-413-420140-121 OVERTIME (REG & AET OT) 51,013 80,000 28,987 36% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 28,930 25,000 3,930- -16% 1000-413-420140-153 HEALTH INSURANCE 329,178 465,977 136,799 29% 1000-413-420140-155 RETIREMENT 218,051 313,964 95,913 31% 1000-413-420140-210 OFFICE SUPPLIES 2,825 3,500 675 19% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 2,360 13,000 10,640 82% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 10,462 21,000 10,538 50% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 2,617 3,760 1,143 30% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 3,772 7,000 3,228 46% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 395 1,000 605 60% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 875 29,250 28,375 97% 1000-413-420140-227 AMMO & RELATED SUPPLIES 2,560 25,000 22,440 90% 1000-413-420140-228 PATROL CAR SUPPLIES 2,740 15,400 12,660 82% 1000-413-420140-229 OTHER SUPPLIES 2,335 5,000 2,665 53% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 260 1,000 740 74% 1000-413-420140-231 GAS 50,765 83,000 32,235 39% 1000-413-420140-234 CRISIS NEGOTIATIONS 319 500 181 36% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 354 1,500 1,146 76% 1000-413-420140-320 PRINTING 2,695 5,500 2,806 51% 1000-413-420140-345 TELEPHONE & COMMUNICATION 15,037 19,000 3,963 21% 1000-413-420140-354 CONTRACT SERVICES 20,990 49,375 28,385 57% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 3,103 6,500 3,397 52% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 3,257 4,830 1,573 33% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 782 2,000 1,218 61% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 32,056 33,000 944 3% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 855 2,500 1,645 66% 1000-413-420140-373 DUES & TRAINING 28,357 46,000 17,643 38% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 661 14,500 13,839 95% 1000-413-420140-380 TRAINING MATERIALS 3,150 3,000 150- -5% 1000-413-420140-388 MEDICAL SERVICES 2,145 3,000 856 29% 1000-413-420140-392 BOARDING/TREATING PRISONERS 1,030 2,500 1,470 59% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 64,874 86,498 21,624 25% 1000-413-420140-530 RENT 5,619 8,520 2,901 34% 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 48,000 64,000 16,000 25% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 8,625 11,500 2,875 25% 1000-413-420140-944 VEHICLES 83,585 211,793 128,208 61% ------------------------------------------------- SUBTOTAL POLICE DEPT. 2,796,843 4,104,202 1,307,359 32% DETECTIVES 1000-413-420141-110 SALARIES-DETECTIVES 278,329 382,938 104,609 27% 1000-413-420141-121 DETECTIVE-OVERTIME 6,846 15,000 8,154 54% 1000-413-420141-153 HEALTH INSURANCE 58,568 81,839 23,271 28% 1000-413-420141-155 DETECTIVE-RETIREMENT 36,795 51,285 14,490 28% ------------------------------------------------- TOTAL DETECTIVES 380,538 531,062 150,524 28% RECORDS 1000-413-420142-110 SALARIES-RECORDS DIVISION 103,511 149,535 46,024 31% 1000-413-420142-121 OVERTIME 1,717 7,500 5,783 77% THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 7 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-153 HEALTH INSURANCE 23,982 44,050 20,068 46% 1000-413-420142-155 RETIREMENT 8,363 11,831 3,468 29% ------------------------------------------------- TOTAL RECORDS 137,573 212,916 75,343 35% RESOURCE OFFICERS 1000-413-420144-110 SALARIES-SRO 193,786 283,576 89,790 32% 1000-413-420144-153 HEALTH INSURANCE 37,493 42,175 4,682 11% 1000-413-420144-155 SRO RETIREMENT 25,497 38,062 12,565 33% ------------------------------------------------- TOTAL RESOURCE OFFICERS 256,777 363,813 107,036 29% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL-SALARIES 33,608 43,420 9,812 23% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 6,347 8,436 2,089 25% 1000-413-420145-155 RETIREMENT 2,531 3,434 903 26% ------------------------------------------------- SUBTOTAL ANIMAL CONTROL 42,486 55,790 13,304 24% PARKING 1000-413-420147-110 PARKINGS -SALARIES 61,755 83,263 21,508 26% 1000-413-420147-153 HEALTH INSURANCE 23,332 31,019 7,687 25% 1000-413-420147-155 RETIREMENT 4,845 6,584 1,739 26% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 1,556 4,000 2,444 61% 1000-413-420147-354 CONTRACTED SERVICES 1,801 2,000 199 10% 1000-413-420147-362 LOT MAINT 1,832 10,000 8,168 82% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 7,725 17,500 9,775 56% 1000-413-420147-550 LOT LEASE PAYMENTS 934 1,500 566 38% ------------------------------------------------- SUBTOTAL PARKING 103,779 155,866 52,087 33% ------------------------------------------------- SUBTOTAL POLICE DEPT. 3,717,997 5,423,649 1,705,652 31% THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 8 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES-FIRE SUPPRESSION 1,242,157 1,739,869 497,712 29% 1000-416-420400-114 COMPTIME BUYOUT 3,360 5,500 2,140 39% 1000-416-420400-115 OUT OF RANK PAY 8,687 12,500 3,813 31% 1000-416-420400-121 OVERTIME 71,909 40,000 31,909- -80% 1000-416-420400-153 HEALTH INSURANCE 245,410 297,790 52,380 18% 1000-416-420400-155 RETIREMENT 160,247 227,035 66,788 29% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 856 4,000 3,144 79% 1000-416-420400-218 Equipment (Non Capital) 7,148 21,500 14,352 67% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 7,241 15,000 7,759 52% 1000-416-420400-224 JANITORIAL SUPPLIES 2,722 5,000 2,278 46% 1000-416-420400-231 GAS 6,441 17,325 10,884 63% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 3,200 15,750 12,550 80% 1000-416-420400-320 PRINTING 0 200 200 100% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 0 1,250 1,250 100% 1000-416-420400-345 TELEPHONE & COMMUNICATION 3,156 6,000 2,844 47% 1000-416-420400-354 CONTRACT SERVICES 14,093 20,390 6,297 31% 1000-416-420400-362 EQUIPMENT MAINTENANCE 1,405 5,500 4,096 74% 1000-416-420400-366 BUILDING MAINTENANCE-STATION 62 7,531 6,500 1,031- -16% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 1,400 5,000 3,600 72% 1000-416-420400-373 DUES & TRAINING 6,021 10,000 3,979 40% 1000-416-420400-388 FIREFIGHTER PHYSICALS 2,856 27,475 24,619 90% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 25,248 33,663 8,415 25% 1000-416-420400-610 DEBT RETIREMENT-FIRE TRUCK 43,174 43,173 1- 0% 1000-416-420400-620 INTEREST EXPENSE-FIRE TRUCK 14,268 14,633 365 3% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 210,000 280,000 70,000 25% 1000-416-420400-940 EQUIPMENT - SCBA 54,409 76,000 21,591 28% 1000-416-420440-110 SALARIES-FIRE PREVENTION 15,472 21,459 5,987 28% 1000-416-420440-114 COMPTIME BUYOUT 350 0 350- 0% 1000-416-420440-121 OVERTIME 236 0 236- 0% 1000-416-420440-153 HEALTH INSURANCE 3,995 5,311 1,316 25% 1000-416-420440-155 RETIREMENT 1,204 1,583 379 24% ------------------------------------------------- SUBTOTAL FIRE DEPT. 2,164,193 2,959,406 795,213 27% ------------------------------------------------- GRAND TOTAL GENERAL FUND 9,784,278 13,832,600 4,048,322 29% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 9 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 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 566,752 1,045,000 478,248 46% 2215-000-311200-000 PERSONAL PROPERTY TAXES 29,452 22,868 6,584- -29% 2215-000-312000-000 PEN & INTEREST DEL TAXES 1,146 2,000 854 43% 2215-000-335230-000 ENTITLEMENT SHARE PMT/HB 124 12,850 17,132 4,282 25% 2215-000-346030-000 SWIMMING POOL FEES 74,541 140,000 65,459 47% 2215-000-346040-000 CONCESSION STAND REVENUE 26,818 36,000 9,182 26% 2215-000-346050-000 PARKS USAGE FEES 9,224 20,000 10,776 54% 2215-000-346051-000 RECREATION FEES 17,019 20,033 3,014 15% 2215-000-346052-000 SPORTS PROGRAMS 41,737 59,480 17,743 30% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 794 2,000 1,206 60% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 44,466 56,000 11,534 21% 2215-000-346055-000 ICE RINK 15,134 20,000 4,866 24% 2215-000-346056-000 KIDSPORT USAGE 4,670 3,000 1,670- -56% 2215-000-346057-000 YOUTH CAMPS 11,053 156,421 145,368 93% 2215-000-346059-000 PICNIC IN THE PARK 7,857 26,500 18,643 70% 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 2,296 0 2,296- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-371010-000 INVESTMENTS 7,715 5,500 2,215- -40% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 47,500 95,000 47,500 50% ------------------------------------------------- TOTAL PARKS & REC REVENUE 921,025 1,746,934 825,909 47% ================================================= PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES-PARKS 247,662 336,666 89,004 26% 2215-436-460430-111 SEASONAL SALARIES 30,471 66,679 36,208 54% 2215-436-460430-121 OVERTIME 0 300 300 100% 2215-436-460430-153 HEALTH INSURANCE 45,136 61,999 16,863 27% 2215-436-460430-155 RETIREMENT 21,781 28,857 7,076 25% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 542 1,800 1,258 70% 2215-436-460430-215 EQUIPMENT - not capital 210 6,000 5,790 97% 2215-436-460430-224 JANITORIAL SUPPLIES 3,346 6,000 2,654 44% 2215-436-460430-229 OTHER SUPPLIES 1,128 10,000 8,872 89% 2215-436-460430-231 GAS 10,500 15,500 5,000 32% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 1,044 6,000 4,956 83% 2215-436-460430-320 PRINTING & ADVERTISING 166 200 34 17% 2215-436-460430-341 ELECTRICITY 8,347 14,000 5,653 40% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 19,297 20,000 703 4% 2215-436-460430-344 NATURAL GAS 706 2,500 1,794 72% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 1,407 2,800 1,393 50% 2215-436-460430-351 SPORTS COURT & BAND SHELL REHAB 0 2,000 2,000 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 2,000 2,000 0 0% 2215-436-460430-355 CONTRACT SERV. TRAIL MAINT/WEED CON 11,128 15,000 3,873 26% 2215-436-460430-356 TRAIL STUDY 0 30,000 30,000 100% 2215-436-460430-357 BUILDING ACTIVE COMMUNITIES GRANT 978 1,193 215 18% 2215-436-460430-358 FVCC TENNIS INTERLOCAL AGREEMENT 7,000 7,000 0 0% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 7,333 10,500 3,167 30% 2215-436-460430-364 LANDSCAPING 167 6,000 5,833 97% THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 10 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-367 VANDALISM REPAIRS 1,128 4,000 2,872 72% 2215-436-460430-373 DUES & TRAINING 5,264 8,000 2,736 34% 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 55 400 345 86% 2215-436-460430-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 2,000 9,000 7,000 78% 2215-436-460430-440 IRRIGATION SUPPLIES 1,865 7,500 5,635 75% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 1,093 1,500 407 27% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 29,226 38,968 9,742 25% 2215-436-460430-545 COUNTY LANDFILL 3,735 6,273 2,538 40% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 48,413 59,296 10,883 18% 2215-436-460430-620 DEBT SERVICE INTEREST 5,777 7,890 2,113 27% 2215-436-460430-932 PARK IMPROV - LIONS PK IRRIGATION 13,028 16,608 3,580 22% 2215-436-460430-941 TRUCK (FY 20) 32,816 38,000 5,184 14% ------------------------------------------------- SUBTOTAL PARKS EXPENDITURES 564,747 850,929 286,182 34% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES-COMPLEX 79,898 110,377 30,479 28% 2215-436-460440-111 SEASONAL SALARIES 22,136 38,917 16,781 43% 2215-436-460440-121 OVERTIME 0 300 300 100% 2215-436-460440-153 HEALTH INSURANCE 21,931 34,733 12,802 37% 2215-436-460440-155 RETIREMENT 7,385 10,009 2,624 26% 2215-436-460440-221 SAFETY EQUIPMENT 0 600 600 100% 2215-436-460440-229 OTHER SUPPLIES 7,644 22,000 14,356 65% 2215-436-460440-231 GAS 4,132 8,500 4,368 51% 2215-436-460440-241 CONSUMABLE TOOLS 427 2,000 1,573 79% 2215-436-460440-341 ELECTRICITY 5,465 9,500 4,035 42% 2215-436-460440-345 TELEPHONE & COMMUNICATION 151 240 89 37% 2215-436-460440-354 CONTRACT SERVICES 0 1,000 1,000 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 433 800 367 46% 2215-436-460440-364 LANDSCAPING 14 600 586 98% 2215-436-460440-367 VANDALISM REPAIRS 95 500 405 81% 2215-436-460440-373 DUES & TRAINING 681 600 81- -14% 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 0 200 200 100% 2215-436-460440-395 RENTAL EQUIPMENT 0 150 150 100% 2215-436-460440-420 METAL PRODUCTS 900 1,500 600 40% 2215-436-460440-440 IRRIGATION 4,496 7,000 2,504 36% 2215-436-460440-452 SAND & GRAVEL 1,104 1,200 96 8% 2215-436-460440-521 CENTRAL GARAGE TRANSFER 3,151 4,201 1,050 25% 2215-436-460440-545 COUNTY LANDFILL 3,389 3,400 11 0% ------------------------------------------------- SUBTOTAL ATHLETIC COMPLEX 163,433 258,327 94,894 37% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES-RECREATION 58,632 83,360 24,728 30% 2215-436-460431-111 SEASONAL SALARIES 5,802 10,065 4,263 42% 2215-436-460431-153 HEALTH INSURANCE 14,748 22,649 7,901 35% 2215-436-460431-155 RETIREMENT 4,666 7,304 2,638 36% 2215-436-460431-229 MISC. SUPPLIES 5,519 11,138 5,619 50% 2215-436-460431-231 GAS 161 584 423 72% 2215-436-460431-320 PRINTING & ADVERTISING 100 9,300 9,200 99% 2215-436-460431-345 TELEPHONE & COMMUNICATION 414 664 250 38% 2215-436-460431-354 CONTRACT SERVICES 25,516 27,550 2,035 7% 2215-436-460431-357 MUSIC FRANCHISE FEES 1,153 1,250 97 8% THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 11 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460431-373 DUES & TRAINING 169 700 531 76% ------------------------------------------------- SUBTOTAL RECREATION 116,880 174,564 57,684 33% YOUTH CAMPS 2215-436-460448-110 SALARIES-YOUTH CAMPS 52,837 73,603 20,766 28% 2215-436-460448-111 SEASONAL SALARIES 91,373 139,364 47,991 34% 2215-436-460448-121 OVERTIME 3 150 147 98% 2215-436-460448-153 HEALTH INSURANCE 14,114 21,805 7,691 35% 2215-436-460448-155 RETIREMENT 4,088 6,765 2,677 40% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 0 250 250 100% 2215-436-460448-229 MISC. SUPPLIES 1,735 3,520 1,785 51% 2215-436-460448-231 GAS 0 338 338 100% 2215-436-460448-320 PRINTING & ADVERTISING 0 295 295 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 638 1,352 714 53% 2215-436-460448-354 CONTRACT SERVICES 12,781 12,870 89 1% 2215-436-460448-355 AFTER SCHOOL PROGRAM 669 1,200 531 44% 2215-436-460448-356 BANK FEES/CC CHARGES 1,726 4,000 2,274 57% 2215-436-460448-373 DUES & TRAINING 509 700 191 27% ------------------------------------------------- SUBTOTAL YOUTH CAMPS 180,473 266,212 85,739 32% POOL 2215-437-460445-111 SEASONAL SALARIES-POOL 120,684 171,808 51,124 30% 2215-437-460445-121 OVERTIME 50 200 150 75% 2215-437-460445-155 RETIREMENT 163 1,500 1,337 89% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 227 500 273 55% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,568 2,000 432 22% 2215-437-460445-226 CHLORINE/CHEMICALS 27,547 26,500 1,047- -4% 2215-437-460445-228 CONCESSION STAND SUPPLIES 12,207 20,000 7,793 39% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 533 4,000 3,467 87% 2215-437-460445-341 ELECTRICITY 6,140 9,000 2,860 32% 2215-437-460445-344 NATURAL GAS 9,318 21,500 12,182 57% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,129 2,550 1,421 56% 2215-437-460445-354 LICENSES & FEES 1,366 1,300 66- -5% 2215-437-460445-356 BANK FEES/ CC CHARGES 1,894 3,200 1,306 41% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 11,104 18,095 6,991 39% 2215-437-460445-380 TRAINING MATERIALS 114 1,800 1,686 94% ------------------------------------------------- SUBTOTAL POOL EXPENDITURES 194,045 283,953 89,908 32% ------------------------------------------------- TOTAL PARKS & RECREATION/POOL 1,219,578 1,833,985 614,407 34% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 12 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING URBAN FORESTRY 2600-436-460433-110 SALARIES-URBAN FORESTRY 132,836 194,961 62,125 32% 2600-436-460433-111 SEASONAL SERVICES 13,380 40,963 27,583 67% 2600-436-460433-121 OVERTIME 33 1,000 967 97% 2600-436-460433-153 HEALTH INSURANCE 27,092 38,982 11,890 31% 2600-436-460433-155 RETIREMENT 11,068 18,128 7,060 39% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 1,732 3,600 1,868 52% 2600-436-460433-231 GAS 4,045 7,000 2,955 42% 2600-436-460433-241 CONSUMABLE TOOLS 2,360 11,100 8,740 79% 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 434 660 226 34% 2600-436-460433-354 CONTRACT SERVICES 88,754 150,000 61,246 41% 2600-436-460433-358 DUTCH ELM DISEASE/tree disposal 395 4,000 3,605 90% 2600-436-460433-362 EQUIPMENT MAINTENANCE 3,395 4,000 605 15% 2600-436-460433-364 LANDSCAPING & TREES 2,304 8,000 5,697 71% 2600-436-460433-373 DUES & TRAINING 3,408 4,000 592 15% 2600-436-460433-395 EQUIPMENT RENTAL 5,440 6,000 560 9% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 2,959 4,000 1,042 26% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 5,880 7,840 1,960 25% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 15,833 21,110 5,277 25% 2600-436-460433-528 DATA PROCESSING TRANSFER 3,410 4,547 1,137 25% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 16,859 16,859 0- 0% 2600-436-460433-620 INTEREST EXPENSE 1,353 1,496 143 10% ------------------------------------------------- TOTAL URBAN FORESTRY 342,969 548,246 205,277 37% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 13 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2230 AMBULANCE FUND REVENUE: 2230-000-342050-000 FEES FOR SERVICES 516,309 719,000 202,691 28% 2230-000-342070-000 COUNTY EMS LEVY 63,042 120,000 56,958 47% 2230-000-381050-000 INCEPTION OF LEASE 0 190,000 190,000 100% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 210,000 280,000 70,000 25% ------------------------------------------------- TOTAL AMBULANCE REVENUE 789,350 1,309,000 519,650 40% ================================================= AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 489,976 682,105 192,129 28% 2230-440-420730-114 COMPTIME BUYBACK 0 3,500 3,500 100% 2230-440-420730-115 OUT OF RANK PAY 3,226 2,500 726- -29% 2230-440-420730-121 OVERTIME 24,637 30,000 5,363 18% 2230-440-420730-153 HEALTH INSURANCE 119,573 145,660 26,087 18% 2230-440-420730-155 RETIREMENT 63,503 88,145 24,642 28% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 1,140 3,400 2,260 66% 2230-440-420730-218 NON-CAPITAL EQUIPMENT 0 4,200 4,200 100% 2230-440-420730-231 GAS & OIL 3,750 7,560 3,810 50% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 1,372 4,000 2,628 66% 2230-440-420730-312 POSTAGE/PRINTING 0 1,000 1,000 100% 2230-440-420730-345 TELEPHONE & COMMUNICATION 886 1,700 814 48% 2230-440-420730-354 CONTRACT SERVICES 4,815 19,990 15,175 76% 2230-440-420730-355 911 CENTER CONTRIBUTION 27,450 36,600 9,150 25% 2230-440-420730-359 AUDIT/CC OTHER FEES 2,871 1,650 1,221- -74% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 2,456 5,000 2,544 51% 2230-440-420730-373 DUES & TRAINING 3,647 5,000 1,353 27% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 327- 2,500 2,827 113% 2230-440-420730-391 MEDICAL TREATMENT-SUPPLIES 31,960 51,241 19,281 38% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 8,555 8,555 0 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 13,507 18,009 4,502 25% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 35,457 47,276 11,819 25% 2230-440-420730-528 DATA PROCESSING TRANSFER 13,642 18,189 4,547 25% 2230-440-420730-610 PRINCIPAL - AMBULANCE 0 19,000 19,000 100% 2230-440-420730-620 INTEREST - AMBULANCE 0 3,202 3,202 100% 2230-440-420730-943 AMBULANCE 0 190,000 190,000 100% ------------------------------------------------- TOTAL AMBULANCE EXPENDITURES 852,094 1,399,982 547,888 39% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 14 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 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 8,164 10,000 1,836 18% 2399-000-341073-000 FIRE IMPACT FEES 95,374 150,000 54,626 36% 2399-000-371010-000 INVESTMENT EARNINGS 13,845 13,000 845- -7% ------------------------------------------------- TOTAL PS IMPACT FEE REV 117,383 173,000 55,617 32% ================================================= PUBLIC SAFETY IMPACT FEE EXP 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 7,500 10,000 2,500 25% 2399-413-420140-940 POLICE EQUIPMENT 0 100,000 100,000 100% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 750,000 750,000 100% ------------------------------------------------- TOTAL PS IMPACT FEE EXP 7,500 860,000 852,500 99% ================================================= FIRE & HAZMAT GRANTS 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 1,600 6,000 4,400 73% 2956-416-420415-940 AFG GRT FY20 SCBA 0 346,000 346,000 100% ------------------------------------------------- TOTAL FIRE GRANTS 1,600 352,000 350,400 100% ================================================= 2957-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 2,651 0 2,651- 0% 2957-416-420410-125 PASS THRU HAZMAT OT 826 4,000 3,174 79% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 884 12,000 11,116 93% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 643 2,500 1,857 74% ------------------------------------------------- TOTAL HAZMAT GRANTS 5,005 18,500 13,495 73% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 15 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 316,847 400,000 83,153 21% 2394-000-323103-000 PLUMBING PERMITS 27,027 35,000 7,974 23% 2394-000-323104-000 MECHANICAL PERMITS 34,013 35,000 988 3% 2394-000-323105-000 ELECTRICAL PERMITS 48,762 60,000 11,238 19% 2394-000-323108-000 PLAN REVIEW FEES 64,806 160,000 95,194 60% 2394-000-371010-000 INVESTMENT EARNINGS 21,488 18,000 3,488- -19% ------------------------------------------------- TOTAL REVENUE 512,943 708,000 195,057 28% ================================================= BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES-BUILDING DEPT. 383,674 520,711 137,037 26% 2394-420-420530-112 SALARIES-SEVERANCE 23,212 55,872 32,660 58% 2394-420-420530-121 OVERTIME 14,219 20,000 5,781 29% 2394-420-420530-153 HEALTH INSURANCE 69,296 95,503 26,207 27% 2394-420-420530-155 RETIREMENT 30,571 39,529 8,958 23% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 16,129 20,000 3,871 19% 2394-420-420530-231 GAS & OIL 2,072 5,000 2,928 59% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 4,689 7,300 2,611 36% 2394-420-420530-323 ST. ED. ASSESSMENTS 1,471 7,500 6,029 80% 2394-420-420530-345 TELEPHONE & COMMUNICATION 5,192 6,000 808 13% 2394-420-420530-353 AUDITING 4,500 4,500 0 0% 2394-420-420530-354 CONTRACT SERVICES 16,234 20,000 3,766 19% 2394-420-420530-355 CITY WORKS LICENSING FEE 16,757 16,000 757- -5% 2394-420-420530-356 ArcGIS SERVER UPGRADE LICENSE 2,500 6,000 3,500 58% 2394-420-420530-357 CREDIT CARD / PAYPAL FEES 4,797 15,000 10,203 68% 2394-420-420530-360 FURNITURE 7,494 4,000 3,494- -87% 2394-420-420530-373 DUES & TRAINING 8,113 35,000 26,887 77% 2394-420-420530-510 PROPERTY INSURANCE 8,184 10,000 1,816 18% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 1,007 1,342 335 25% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 24,867 33,156 8,289 25% 2394-420-420530-528 DATA PROCESSING TRANSFER 23,873 31,831 7,958 25% 2394-420-420530-920 BUILDING IMPROVEMENTS 810 200,000 199,190 100% ------------------------------------------------- TOTAL BUILDING DEPT. 669,659 1,154,244 484,585 42% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 16 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 60,984 86,741 25,757 30% 2400-410-430263-153 HEALTH INSURANCE 9,337 15,533 6,196 40% 2400-410-430263-155 RETIREMENT 4,672 6,589 1,917 29% 2400-410-430263-244 STREET LIGHT SUPPLIES 614 18,000 17,386 97% 2400-410-430263-245 LUMINAIRES 16,132 30,000 13,868 46% 2400-410-430263-246 LED LUMINAIRE UPGRADE 15,684 32,655 16,971 52% 2400-410-430263-341 ELECTRICITY 105,628 182,000 76,372 42% 2400-410-430263-360 REPAIR & MAINT SERVICES 1,384 20,000 18,616 93% 2400-410-430263-373 DUES & TRAINING 1,125 1,000 125- -13% 2400-410-430263-510 INSURANCE 1,232 1,500 268 18% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 11,593 15,457 3,864 25% ------------------------------------------------- TOTAL LIGHT MAINT. 228,385 409,475 181,090 44% ================================================= 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 30,812 114,683 83,871 73% 2420-421-430234-957 ALLEY PAVING 42,168 67,180 25,012 37% 2420-421-430240-231 GAS & OIL 17,231 42,000 24,769 59% 2420-421-430240-344 NATURAL GAS 612 6,800 6,188 91% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 100% 2420-421-430240-360 REPAIR & MAINT SERVICES 450 1,500 1,050 70% 2420-421-430240-368 OVERLAY/CHIPSEALS 32,936 318,578 285,642 90% 2420-421-430240-452 GRAVEL 2,107 5,000 2,893 58% 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 43,319 53,000 9,681 18% 2420-421-430240-472 ASPHALT 9,821 40,000 30,179 75% 2420-421-430240-473 CRACK SEALING 4,922 14,500 9,578 66% 2420-421-430240-474 PAINT STRIPING MATERIALS 13,919 30,000 16,081 54% ------------------------------------------------- TOTAL GAS TAX 198,296 718,241 519,945 72% ================================================= BARSAA (GAS TAX) 2421-421-430240-354 PAVEMENT MAINTENANCE 320,331 420,000 99,669 24% ------------------------------------------------- TOTAL BARSAA 320,331 420,000 99,669 24% ================================================= 2825 MACI GRANT 2825-421-430240-940 EQUIPMENT 0 205,000 205,000 100% ------------------------------------------------- TOTAL MACI GRANT 0 205,000 205,000 100% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 17 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 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. 578,677 805,569 226,892 28% 2500-421-430240-121 OVERTIME 2,906 28,000 25,094 90% 2500-421-430240-153 HEALTH INSURANCE 128,736 177,425 48,689 27% 2500-421-430240-155 RETIREMENT 44,170 60,533 16,363 27% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 10,605 16,360 5,755 35% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 5,337 7,000 1,664 24% 2500-421-430240-220 OTHER SUPPLIES 1,937 4,500 2,563 57% 2500-421-430240-231 GAS & OIL 17,971 42,000 24,029 57% 2500-421-430240-341 ELECTRICITY 1,651 3,500 1,849 53% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 1,077 1,700 623 37% 2500-421-430240-354 CONTRACT SERVICES 4,255 22,500 18,245 81% 2500-421-430240-356 TRANSPORTATION PLAN 126,095 187,150 61,055 33% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 35,179 33,500 1,679- -5% 2500-421-430240-366 BUILDING MAINTENANCE 22,193 26,375 4,182 16% 2500-421-430240-373 DUES & TRAINING 814 7,500 6,686 89% 2500-421-430240-388 MEDICAL SERVICES 255 1,000 745 75% 2500-421-430240-510 LIABILITY INSURANCE 30,260 30,260 0 0% 2500-421-430240-512 UNINSURED LOSS-DEDUCTIBLE 20,498 11,269 9,229- -82% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 146,598 195,464 48,866 25% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 86,963 115,951 28,988 25% 2500-421-430240-528 DATA PROCESSING TRANSFER 10,643 14,191 3,548 25% 2500-421-430240-840 MACI GRANT MATCH - WTR/DE-ICER TRK 0 10,000 10,000 100% 2500-421-430240-953 SHOP COMPLEX PAVEMENT RESTORATION 1,599 4,678 3,079 66% 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 12,478 24,955 12,477 50% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 7,094 14,032 6,938 49% 2500-421-430244-354 PAVEMENT REPAIRS-PAVEMENT MNT FUNDS 398,936 873,166 474,230 54% 2500-421-430244-820 TRANSFER TO BaRSAA 16,141 20,000 3,859 19% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 150,845 158,000 7,155 5% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 27,828 27,828 100% ------------------------------------------------- TOTAL STREET MAINT. 1,863,913 2,924,406 1,060,493 36% ------------------------------------------------- SIGNS AND SIGNALS 2500-421-430264-110 TSS - SALARIES 77,560 103,256 25,696 25% 2500-421-430264-121 OVERTIME 0 7,500 7,500 100% 2500-421-430264-153 HEALTH INSURANCE 21,448 29,676 8,228 28% 2500-421-430264-155 RETIREMENT 5,854 7,685 1,831 24% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 3,439 3,775 336 9% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 5,214 6,700 1,486 22% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 3,516 3,500 16- -0% 2500-421-430264-242 STREET SIGNS 22,496 30,000 7,504 25% 2500-421-430264-243 TRAFFIC SIGNALS 6,265 30,000 23,735 79% 2500-421-430264-245 BARRICADE MATERIALS 1,689 6,000 4,311 72% 2500-421-430264-341 ELECTRICITY 1,194 3,000 1,806 60% 2500-421-430264-345 COMMUNICATIONS 405 850 445 52% 2500-421-430264-354 CONTRACT SERVICES 1,819 10,000 8,181 82% 2500-421-430264-362 EQUIPMENT MAINTENANCE 577 3,000 2,423 81% 2500-421-430264-366 BUILDING MAINTENANCE 4,561 7,375 2,814 38% 2500-421-430264-373 DUES & TRAINING 3,897 7,000 3,103 44% 2500-421-430264-428 PAINT MATERIALS 359 5,000 4,641 93% 2500-421-430264-510 LIABILITY INS.-TSS 2,214 3,000 786 26% THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 18 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500-421-430264-512 UNINSURED LOSS-DEDUCTIBLE 0 2,777 2,777 100% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 5,626 7,502 1,876 25% 2500-421-430264-532 OFFICE RENT 6,421 6,422 1 0% 2500-421-430264-940 MACHINERY & EQUIPMENT 39,591 47,000 7,409 16% ------------------------------------------------- TOTAL SIGNS AND SIGNALS 214,146 331,018 116,872 35% ------------------------------------------------- TOTAL STREET MAINT. & SIGNS 2,078,059 3,255,424 1,177,365 36% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 19 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2188 WESTSIDE TIF REVENUE 2188-000-365010-000 MISC. REVENUE 2,645 575,000 572,355 100% 2188-000-371010-000 INVESTMENT EARNINGS 1,372 1,000 372- -37% 2188-000-373010-000 INTEREST / LOANS 2,301 0 2,301- 0% 2188-000-373020-000 PRINCIPAL / LOANS 472 0 472- 0% 2188-000-381060-000 TRANSFER FROM GENERAL FUND 1,450,000 1,200,000 250,000- -21% ------------------------------------------------- TOTAL REVENUE 1,456,789 1,776,000 319,211 18% ================================================= EXPENDITURES 2188-480-470230-110 SALARIES 33,578 46,104 12,526 27% 2188-480-470230-153 HEALTH INSURANCE 6,678 9,381 2,703 29% 2188-480-470230-155 RETIREMENT 2,704 3,664 960 26% 2188-480-470230-353 AUDIT 3,000 3,000 0 0% 2188-480-470230-356 TELEPHONE 144 192 48 25% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 3,507 4,675 1,168 25% 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 1,189,428 1,500,000 310,572 21% 2188-480-470440-930 CITY MATCH - TRAIL 160,710 200,000 39,290 20% 2188-480-470440-935 CITY MATCH - RAIL PARK 32,254 28,455 3,799- -13% ------------------------------------------------- TOTAL WESTSIDE TIF 1,432,002 1,795,471 363,469 20% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 20 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2185 AIRPORT TIF 2185-000-430300-353 AUDITING 1,600 1,600 0 0% 2185-000-430300-522 ADMINISTRATIVE TRANSFER 10,188 13,584 3,396 25% 2185-000-430300-840 REDEVELOPMENT ACTIVITY 1,069,518 3,316,334 2,246,816 68% 2185-480-470240-110 SALARIES 15,661 21,321 5,660 27% 2185-480-470240-153 HEALTH INSURANCE 3,681 4,647 966 21% 2185-480-470240-155 RETIREMENT 1,261 1,703 442 26% 2185-480-470240-345 TELEPHONE & COMMUNICATION 36 48 12 25% ------------------------------------------------- TOTAL 2185 AIRPORT TIF 1,101,946 3,359,237 2,257,291 67% ================================================= OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 9,700 9,700 100% 2310-480-470210-356 FED-EX REIMBURSEMENT 9,217 9,200 17- -0% 2310-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 0 45,000 45,000 100% 2311-480-470210-820 OPERATING TRANSFER TO 2886 CD MISC 0 5,000 5,000 100% ------------------------------------------------- TOTAL OLD SCHOOL TIFS 9,217 68,900 59,683 87% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 21 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 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 407 1,000 593 59% 2880-480-470210-711 REDEVELOPMENT 14,191 225,000 210,809 94% ------------------------------------------------- TOTAL LOAN REVOLVING 15,598 227,000 211,402 93% ================================================= 2881 CD LOAN REV. #2 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 405 405 0 0% 2881-480-470210-711 REDEVELOPMENT 0 250,000 250,000 100% ------------------------------------------------- TOTAL 2881 CD REV. #2 405 250,405 250,000 100% ================================================= 2886 CD MISC. 2886-480-470210-210 OFFICE SUPPLIES 0 2,000 2,000 100% 2886-480-470210-353 AUDITING 1,000 1,000 0 0% 2886-480-470210-373 DUES & TRAINING 90 2,000 1,910 96% 2886-480-470210-379 MEETINGS 164 1,000 836 84% 2886-480-470210-396 STUDIES/SURVEYS & MARKETING 0 5,000 5,000 100% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 1,500 2,000 500 25% 2886-480-470210-528 DATA PROCESSING TRANSFER 6,821 9,094 2,273 25% 2886-480-470210-532 OFFICE RENT 646 646 0 0% 2886-480-470210-790 REDEVELOPMENT ACTIVITY 0 4,000 4,000 100% ------------------------------------------------- TOTAL CD MISC. 10,221 26,740 16,519 62% ================================================= 2887 RURAL DEVELOPMENT #1 2887-480-470210-354 CONT SERV (LOAN SOFTWARE) 405 0 405- 0% 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 18,826 18,826 0 0% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 3,248 3,248 0- 0% 2887-480-470210-750 REDEVELOPMENT LOANS 250,067 400,000 149,933 37% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #1 272,546 422,074 149,528 35% ================================================= 2888 RURAL DEVELOPMENT #2 2888-480-470210-354 CONT SERV (LOAN SOFTWARE) 405 0 405- 0% 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 8,384 8,384 0- 0% 2888-480-470210-620 INTEREST EXPENSE-USDA LOAN 61-03 1,641 1,641 0 0% 2888-480-470210-750 REDEVELOPMENT LOANS 0 300,000 300,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #2 10,430 310,025 299,595 97% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 22 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2953 EPA BROWNFIELDS 2953-480-470210-354 CONT SERV/PETROLEUM 200 185,592 185,392 100% 2953-480-470210-373 TRAVEL/PETROLEUM 514 1,943 1,429 74% 2953-480-470215-354 CONT SERV/HAZARDOUS 29,101 37,108 8,007 22% 2953-480-470215-373 TRAVEL/HAZARDOUS 0 1,958 1,958 100% ------------------------------------------------- TOTAL EPA BROWNSFIELD 29,815 226,601 196,786 87% ================================================= 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES-PETROLEUM 0 219,251 219,251 100% 2955-480-470210-373 TRAVEL-PETROLEUM 929 0 929- 0% 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. 929 587,424 586,495 100% ================================================= 2991 TIGER GRANT 2991-480-470245-790 REDEVELOPMENT - TRAIL 0 3,803,909 3,803,909 100% ------------------------------------------------- TOTAL TIGER GRANT 0 3,803,909 3,803,909 100% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 23 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2915 STONEGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD 1,813 10,000 8,187 82% ------------------------------------------------- TOTAL 2915 STONEGARDEN GRANT 1,813 10,000 8,187 82% ================================================= 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 44,536 65,117 20,581 32% 2916-413-420140-121 OVERTIME 10,269 8,000 2,269- -28% 2916-413-420140-153 HEALTH INSURANCE 8,747 11,934 3,187 27% 2916-413-420140-155 RETIREMENT 5,860 8,751 2,891 33% 2916-413-420140-354 CONTRACT SERVICES 0 7,800 7,800 100% ------------------------------------------------- TOTAL 2916 DRUG ENFORCEMENT 69,411 101,602 32,191 32% ================================================= 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 1,271 4,000 2,729 68% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 12,326 36,000 23,674 66% 2919-413-420140-127 SCHOOL DIST. OT 6,215 20,000 13,785 69% 2919-413-420140-218 JAG GRT/BODY ARMOR & BODY WORN CAME 4,938 0 4,938- 0% 2919-413-420140-220 EQUIPMENT-FUNDED BY DONATIONS 3,548 4,000 452 11% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 7,149 7,000 149- -2% ------------------------------------------------- TOTAL LAW ENF. GRANT 35,447 71,000 35,553 50% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 24 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CAPITAL PROJECT FUNDS 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION 15,712 25,000 9,288 37% ------------------------------------------------- TOTAL 4290 WALK & CURB 15,712 25,000 9,288 37% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 25 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 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 540 1,000 460 46% 5210-000-343210-000 METERED WATER SALES 2,414,225 3,000,000 585,775 20% 5210-000-343220-000 UNMETERED WATER SALES 21,662 15,000 6,662- -44% 5210-000-343230-000 METER REPLACEMENT FEE 79,423 100,000 20,577 21% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 42,893 55,000 12,107 22% 5210-000-343270-000 WATER TURN ON FEES 4,420 4,000 420- -11% 5210-000-343275-000 TAG FEE 35,480 45,000 9,520 21% 5210-000-343365-000 LATECOMER ADMIN FEE 91- 0 91 0% 5210-000-371010-000 INVESTMENT EARNINGS 122,450 105,000 17,450- -17% 5210-000-383010-000 TRANSFER FROM IMPACT FEE FUN (10100 18,750 25,000 6,250 25% 5210-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 232,654 309,058 76,404 25% ------------------------------------------------- TOTAL WATER REVENUE 2,972,406 3,659,058 686,652 19% ================================================= WATER FACILITIES 5210-447-430550-110 SALARIES-WATER 458,955 774,817 315,862 41% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 6,030 20,000 13,970 70% 5210-447-430550-153 HEALTH INSURANCE 100,106 174,095 73,989 43% 5210-447-430550-155 RETIREMENT 35,503 58,417 22,914 39% 5210-447-430550-210 OFFICE & COMPUTER SUPPLIES 13,825 22,000 8,175 37% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 5,258 8,500 3,242 38% 5210-447-430550-226 CHLORINE & CHEMICALS 23,231 39,000 15,769 40% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 3,076 4,500 1,424 32% 5210-447-430550-231 GAS & OIL 16,369 35,000 18,631 53% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 856 1,000 144 14% 5210-447-430550-336 LICENSES & FEES 17,606 18,500 894 5% 5210-447-430550-341 ELECTRICITY 100,478 160,000 59,522 37% 5210-447-430550-344 NATURAL GAS 4,237 15,500 11,263 73% 5210-447-430550-345 TELEPHONE & COMMUNICATION 8,168 11,000 2,832 26% 5210-447-430550-349 LAB SERVICES 10,614 20,000 9,386 47% 5210-447-430550-353 AUDITING 3,500 3,500 0 0% 5210-447-430550-354 CONTRACT SERVICES 30,123 55,000 24,877 45% 5210-447-430550-355 NOFFSINGER TRANSMISSION CONDITION A 0 255,000 255,000 100% 5210-447-430550-356 CONSULTANTS 30,072 125,000 94,928 76% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 3,201 15,000 11,799 79% 5210-447-430550-366 BUILDING MAINTENANCE 10,822 16,375 5,553 34% 5210-447-430550-373 DUES & TRAINING 3,685 11,000 7,315 67% 5210-447-430550-388 MEDICAL SERVICES 988 600 388- -65% 5210-447-430550-410 CONSTRUCTION MATERIALS 23,590 35,000 11,410 33% 5210-447-430550-422 HYDRANTS 3,139 10,000 6,861 69% 5210-447-430550-423 MATERIALS FOR MAINS 3,387 14,000 10,613 76% 5210-447-430550-424 MATERIALS -SERVICE LINES 1,712 12,000 10,288 86% 5210-447-430550-425 MATERIALS PUMPS/WELLS 3,317 45,000 41,683 93% 5210-447-430550-510 PROPERTY & LIABILITY INS. 33,256 33,256 0- 0% 5210-447-430550-512 UNINSURED LOSS-DEDUCTIBLE 0 10,000 10,000 100% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 20,251 27,002 6,751 25% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 91,552 122,069 30,517 25% 5210-447-430550-528 DATA PROCESSING TRANSFER 24,834 33,112 8,278 25% 5210-447-430550-532 LEASE PAYMENTS 6,421 10,500 4,079 39% 5210-447-430550-939 FOUR MILE TRANSMISSION MAIN (PHASE 829,512 4,239,062 3,409,550 80% THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 26 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-940 MACHINERY & EQUIPMENT 0 45,000 45,000 100% 5210-447-430550-948 METERS (METER FUNDS) 010125 65,750 151,263 85,513 57% 5210-447-430550-950 1ST AVE WN MAIN REPLACEMENT 10,804 210,213 199,409 95% 5210-447-430550-951 SECURITY SCADA UPGRADES 0 305,000 305,000 100% 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 1,666 4,578 2,912 64% 5210-447-430550-968 CONRAD DRIVE 189,662 246,511 56,849 23% 5210-447-430550-971 10TH AVE W & 2ND ST W MAIN 2,106 535,000 532,894 100% ------------------------------------------------- SUBTOTAL WATER FACILITIES 2,197,662 7,937,370 5,739,708 72% ------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES-WATER BILLING 87,791 117,187 29,396 25% 5210-447-430560-153 HEALTH INSURANCE 28,234 36,809 8,575 23% 5210-447-430560-155 RETIREMENT 6,984 9,182 2,198 24% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 6,559 7,000 441 6% 5210-447-430560-353 AUDITING 2,000 2,000 0 0% 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 30,536 40,000 9,464 24% 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 16,690 27,000 10,310 38% 5210-447-430560-356 OTHER CONTRACT SERVICES 189 1,500 1,311 87% 5210-447-430560-373 DUES & TRAINING 75 2,500 2,425 97% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 8,445 11,259 2,814 25% 5210-447-430560-528 DATA PROCESSING TRANSFER 24,834 33,112 8,278 25% 5210-447-430560-532 RENT 6,421 6,422 1 0% ------------------------------------------------- SUBTOTAL WATER BILLING 218,757 293,971 75,214 26% ------------------------------------------------- REVENUE BONDS 5210-447-490200-610 PRIN - 4 MILE DR TRANSMISSION / WRF 0 78,521 78,521 100% 5210-447-490200-620 INT - 4 MILE DR TRANSMISSION / WRF 38,439 50,538 12,099 24% 5210-447-490204-610 BOND PRIN - HWY 93 S WTR - 2004 0 75,000 75,000 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 16,814 19,643 2,829 14% 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 350 350 0 0% 5210-447-490206-610 PRIN-WELL/TANK/8114 2.25% 4T ST WTR 0 89,000 89,000 100% 5210-447-490206-620 INT-WELL&TANK/8114 2.25% 4TH ST WT 16,830 16,831 1 0% 5210-447-490210-610 4TH AVE E MAIN REPLC/WRF 17393 0 80,126 80,126 100% 5210-447-490210-620 4TH AVE E MAIN REPL/WFR 17393 45,052 45,052 0- 0% 5210-447-490250-610 PRIN - WTR MAIN/ WRF 1032R 2% IDAHO 0 50,000 50,000 100% 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2%/IDAHO&MAIN 1,270 1,270 0 0% ------------------------------------------------- SUBTOTAL REVENUE BONDS 118,755 506,331 387,576 77% ------------------------------------------------- DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 840,000 840,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 840,000 840,000 100% ------------------------------------------------- TOTAL WATER FUND 2,535,175 9,577,672 7,042,497 74% ================================================= WATER IMPACT FEE REVENUE: THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 27 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5211-000-343225-000 IMPACT FEES 437,862 500,000 62,138 12% 5211-000-371010-000 INTEREST EARNINGS 16,114 15,000 1,114- -7% ------------------------------------------------- TOTAL WATER IMPACT FEES REVENU 453,975 515,000 61,025 12% ================================================= WATER IMPACT FEES EXPENSES: 5211-447-430555-820 DEBT SERVICE TRANSFER TO 5210 232,654 309,058 76,404 25% 5211-447-430555-825 TRANSFER TO 5210 FOR ADMIN 18,750 25,000 6,250 25% 5211-447-430555-930 CONTRACT MAIN UPSIDE 0 440,000 440,000 100% 5211-447-430555-932 ELEVATED STORAGE TANK AND WELL 0 448,000 448,000 100% 5211-447-430555-939 FOUR MILE DR TRANSMISSION MAIN (PH. 0 223,948 223,948 100% 5211-447-430555-941 METERS - NEW DEVELOPMENT 45,600 45,600 0 0% 5211-447-430555-953 SECTION 36 WELL 19,595 184,453 164,858 89% ------------------------------------------------- TOTAL WATER IMPACT FEE EXPENSE 316,599 1,676,059 1,359,460 81% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 28 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER REVENUE: 5310-000-323108-000 PW PLAN REVIEW FEES 540 1,500 960 64% 5310-000-343310-000 SEWER SERVICE CHARGES 3,409,538 4,500,000 1,090,462 24% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 1,302 4,000 2,698 67% 5310-000-343365-000 LATECOMER ADMIN FEES 639 4,500 3,861 86% 5310-000-371010-000 INVESTMENT EARNINGS 80,651 66,500 14,151- -21% 5310-000-383010-000 ADMIN TRANSFER FROM IMPACT FEES 37,500 50,000 12,500 25% 5310-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 668,013 891,026 223,013 25% ------------------------------------------------- TOTAL SEWER REVENUE 4,198,184 5,517,526 1,319,342 24% ================================================= SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES-SEWER BILLING 74,856 99,549 24,693 25% 5310-454-430620-153 HEALTH INSURANCE 21,559 27,602 6,043 22% 5310-454-430620-155 RETIREMENT 5,938 7,778 1,840 24% 5310-454-430620-215 OFFICE SUPPLIES/computers 6,518 7,000 482 7% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 2,000 2,000 0 0% 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 30,536 40,000 9,464 24% 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 16,690 27,000 10,310 38% 5310-454-430620-356 OTHER CONTRACT SERVICES 189 1,500 1,311 87% 5310-454-430620-373 DUES & TRAINING 75 2,500 2,425 97% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 7,590 10,119 2,529 25% 5310-454-430620-528 DATA PROCESSING TRANSFER 24,834 33,112 8,278 25% 5310-454-430620-532 OFFICE RENT 6,421 6,422 1 0% ------------------------------------------------- SUBTOTAL SEWER BILLING COSTS 197,206 264,582 67,376 25% ------------------------------------------------- SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES-SANITARY SEWER 206,204 297,006 90,802 31% 5310-454-430630-121 OVERTIME 383 5,500 5,117 93% 5310-454-430630-153 HEALTH INSURANCE 46,443 80,197 33,754 42% 5310-454-430630-155 RETIREMENT 15,775 22,509 6,734 30% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 10,257 12,200 1,943 16% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 4,399 8,350 3,951 47% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 1,217 2,300 1,083 47% 5310-454-430630-231 GAS & OIL 6,093 12,000 5,907 49% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 56 500 445 89% 5310-454-430630-341 ELECTRICITY 32,279 57,000 24,721 43% 5310-454-430630-344 NATURAL GAS 7,401 16,500 9,099 55% 5310-454-430630-345 TELEPHONE & COMMUNICATION 14,552 26,000 11,448 44% 5310-454-430630-353 AUDITING 3,000 3,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 23,253 24,000 747 3% 5310-454-430630-356 CONSULTANTS - FACILITY PLAN 33,005 185,000 151,995 82% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 8,596 11,375 2,779 24% 5310-454-430630-373 DUES & TRAINING 4,985 7,250 2,265 31% 5310-454-430630-388 MEDICAL SERVICES 518 500 18- -4% 5310-454-430630-410 CONSTRUCTION MATERIALS 8,806 10,000 1,194 12% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 29,548 50,000 20,452 41% 5310-454-430630-510 PROPERTY & LIABILITY INS. 39,301 42,000 2,699 6% 5310-454-430630-512 UNINSURED LOSS-DEDUCTIBLE 0 25,000 25,000 100% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 7,076 9,435 2,359 25% THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 29 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-522 ADMINISTRATIVE TRANSFER 36,641 48,854 12,213 25% 5310-454-430630-528 DATA PROCESSING TRANSFER 14,191 18,921 4,730 25% 5310-454-430630-532 OFFICE RENT 12,915 6,422 6,493- -101% 5310-454-430630-940 MACHINERY & EQUIPMENT 10,633 43,500 32,867 76% 5310-454-430630-948 REPAIR & REPLC OF SEWER MAIN 0 600,000 600,000 100% 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 1,599 4,673 3,074 66% 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 8,582 20,000 11,418 57% 5310-454-430630-957 WEST SIDE INTERCEPTOR (BONDED) 96,618 2,783,478 2,686,860 97% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 30,735 50,000 19,265 39% 5310-454-430630-962 SEWER MAIN SLIP LINING 0 395,000 395,000 100% ------------------------------------------------- SUBTOTAL SEWER COLLECTION 715,060 4,878,470 4,163,410 85% ------------------------------------------------- REVENUE BONDS/SANITARY 5310-454-490200-610 PRIN - WESTSIDE INTERCEPTOR BOND 0 326,000 326,000 100% 5310-454-490200-620 INTEREST-WESTSIDE INTERCEPTOR BOND 340,025 340,026 1 0% 5310-454-490204-610 PRIN-HWY 93 S/SRF5125/2.25% 0 87,000 87,000 100% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 9,709 9,709 0 0% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25% 0 350 350 100% ------------------------------------------------- SUBTOTAL REVENUE BONDS 349,734 763,085 413,351 54% ------------------------------------------------- DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 820,000 820,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION-SANITARY 0 820,000 820,000 100% ------------------------------------------------- SUBTOTAL SANITARY SEWER 1,064,794 6,461,555 5,396,761 84% ------------------------------------------------- WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 318,191 454,195 136,004 30% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-121 OVERTIME 14,130 22,500 8,370 37% 5310-455-430640-153 HEALTH INSURANCE 65,246 90,736 25,490 28% 5310-455-430640-155 RETIREMENT 25,578 34,152 8,574 25% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 10,434 10,000 434- -4% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 2,390 2,700 310 11% 5310-455-430640-225 ALUM 0 28,000 28,000 100% 5310-455-430640-226 CHLORINE & CHEMICALS 85,661 87,000 1,339 2% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 6,132 7,000 868 12% 5310-455-430640-231 GAS & OIL 7,305 19,000 11,695 62% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 584 400 184- -46% 5310-455-430640-336 LICENSES & FEES 14,082 12,000 2,082- -17% 5310-455-430640-341 ELECTRICITY 124,895 190,000 65,105 34% 5310-455-430640-342 WATER 4,764 7,500 2,736 36% 5310-455-430640-344 NATURAL GAS 18,891 82,000 63,109 77% 5310-455-430640-345 TELEPHONE & COMMUNICATION 4,579 6,500 1,921 30% 5310-455-430640-353 AUDITING 2,500 2,500 0 0% 5310-455-430640-354 CONTRACT-GLACIER GOLD 78,598 135,000 56,402 42% 5310-455-430640-355 OTHER CONTRACT SERVICES 31,813 39,000 7,187 18% THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 30 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-356 CONSULTANTS 115,243 210,960 95,717 45% 5310-455-430640-358 CONSULTANT-FACILITY PLN/RATE STDY/T 68,102 175,000 106,898 61% 5310-455-430640-360 MISC. MAINT SERVICES 17,488 30,000 12,512 42% 5310-455-430640-366 BUILDING MAINTENANCE 43,307 46,000 2,693 6% 5310-455-430640-373 DUES & TRAINING 6,490 8,500 2,010 24% 5310-455-430640-388 MEDICAL SERVICES 55 500 445 89% 5310-455-430640-510 PROPERTY & LIABILITY INS. 41,697 42,000 303 1% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 14,414 19,219 4,805 25% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 92,029 122,705 30,676 25% 5310-455-430640-528 DATA PROCESSING TRANSFER 17,738 23,651 5,913 25% 5310-455-430640-920 TWAS ROOF REPLC 9,755 13,412 3,657 27% 5310-455-430640-930 BIOSOLIDS ALTERNATE DISPOSAL ENG 0 178,052 178,052 100% ------------------------------------------------- SUBTOTAL WWTP OPERATIONS 1,242,091 2,105,182 863,091 41% ------------------------------------------------- WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 45,262 118,000 72,738 62% 5310-455-430645-921 E. SECONDARY CLARIFIER COATING PRJ 68,234 75,000 6,766 9% 5310-455-430645-934 SECONDARY DIGESTER LID REPLC 518,127 530,648 12,521 2% 5310-455-430645-940 MACHINERY & EQUIPMENT 119,780 125,500 5,720 5% ------------------------------------------------- SUBTOTAL WWTP REPLACEMENT 751,403 849,148 97,745 12% ------------------------------------------------- WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 83,796 115,308 31,512 27% 5310-455-430646-121 OVERTIME 1,110 0 1,110- 0% 5310-455-430646-153 HEALTH INSURANCE 12,694 16,872 4,178 25% 5310-455-430646-155 RETIREMENT 6,483 8,589 2,106 25% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 4,939 4,500 439- -10% 5310-455-430646-218 NON-CAPITAL EQUIPMENT 2,863 2,500 363- -15% 5310-455-430646-222 LAB SUPPLIES 10,366 16,500 6,134 37% 5310-455-430646-349 LAB SERVICES 14,416 30,000 15,584 52% 5310-455-430646-362 EQUIPMENT MAINTENANCE 4,117 5,500 1,383 25% 5310-455-430646-373 DUES & TRAINING 1,192 4,700 3,508 75% ------------------------------------------------- SUBTOTAL WWTP LAB OPERATIONS 141,976 204,469 62,493 31% DEBT SERVICE - WWTP 5310-455-490227-610 PRIN - WWTP IMP/SRF8164R/2.25% 0 851,000 851,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 161,156 161,157 1 0% 5310-455-490228-610 PRIN-WWTP DIGESTER LID/SRF 13326 0 48,000 48,000 100% 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 24,510 24,510 0 0% ------------------------------------------------- SUBTOTAL DEBT SERVICE - WWTP 185,666 1,084,667 899,001 83% ------------------------------------------------- CITY/EVERGREEN REQUIREMENTS: 5310-455-510400-830 EVERGREEN REPLACEMENT TRANSFER 0 420,000 420,000 100% 5310-455-510400-831 DEPRECIATION EXPENSE 0 1,425,000 1,425,000 100% ------------------------------------------------- SUTOTAL WWTP DEPRECIATION/REPL 0 1,845,000 1,845,000 100% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 31 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SUBTOTAL WWTP 2,321,136 6,088,466 3,767,330 62% ------------------------------------------------- TOTAL BILLING/SANITARY/WWTP 3,583,136 12,814,603 9,231,467 72% ================================================= SEWER IMPACT FEE REVENUE 5311-000-343330-000 SANITARY IMPACT FEES 756,481 600,000 156,481- -26% 5311-000-343335-000 TREATMENT IMPACT FEES 493,780 400,000 93,780- -23% 5311-000-371010-000 SANITARY INTEREST EARNINGS 27,641 20,000 7,641- -38% 5311-000-371015-000 TREATMENT INTEREST EARNINGS 21,931 20,000 1,931- -10% ------------------------------------------------- TOTAL SEWER IMPACT FEES REVENU 1,299,832 1,040,000 259,832- -25% ================================================= SEWER IMPACT FEE EXPENSES 5311-454-430635-820 TRANSFER TO 5310 FOR DEBT 499,013 666,026 167,013 25% 5311-454-430635-825 TRANSFER TO 5310 FOR ADMIN 22,500 30,000 7,500 25% 5311-454-430635-955 MAIN & L.S. UPSIZE 0 300,000 300,000 100% 5311-454-430635-957 WEST SIDE INTERCEPTOR 65,498 151,487 85,989 57% 5311-455-430644-820 DEBT SERVICE TRANSFER 169,000 225,000 56,000 25% 5311-455-430644-825 TRANSFER TO 5310 FOR ADMIN 15,000 20,000 5,000 25% 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% ------------------------------------------------- TOTAL SEWER IMPACT FEE EXPENSE 771,011 1,976,150 1,205,139 61% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 32 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 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 540 0 540- 0% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 3,091 1,500 1,591- -106% 5349-000-343034-000 PERMIT FEES 1,695 0 1,695- 0% 5349-000-343035-000 STORM SEWER CHARGES 0 1,500 1,500 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 1,635,191 1,625,000 10,191- -1% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 2,185 1,800 385- -21% 5349-000-371010-000 INTEREST ON INVESTMENTS 32,922 35,000 2,078 6% 5349-000-383010-000 IMPACT FEE 5% ADMIN - TFR FROM IMPA 4,875 6,500 1,625 25% 5349-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 0 175,568 175,568 100% ------------------------------------------------- TOTAL STORM REVENUE 1,680,498 1,846,868 166,370 9% ================================================= STORM SEWER 5349-453-430246-110 SALARIES-STORM SEWER 336,652 476,323 139,671 29% 5349-453-430246-121 OVERTIME 420 4,000 3,580 90% 5349-453-430246-153 HEALTH INSURANCE 66,410 97,207 30,797 32% 5349-453-430246-155 RETIREMENT 25,862 36,107 10,245 28% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 12,744 16,100 3,356 21% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 126 6,000 5,874 98% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 0 2,200 2,200 100% 5349-453-430246-231 GAS & OIL 5,603 11,500 5,897 51% 5349-453-430246-345 TELEPHONE & COMMUNICATION 1,421 1,500 79 5% 5349-453-430246-353 AUDITING 1,150 1,150 0 0% 5349-453-430246-354 CONTRACT SERVICE 3,380 7,000 3,620 52% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 2,974 135,000 132,026 98% 5349-453-430246-358 CONSULTANTS 481 10,000 9,519 95% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 77 30,000 29,923 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 1,369 2,500 1,131 45% 5349-453-430246-362 GROUNDWATER MONITORING 1,764 6,500 4,736 73% 5349-453-430246-371 CURB & GUTTER 0 6,000 6,000 100% 5349-453-430246-373 DUES & TRAINING 4,330 7,250 2,920 40% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 358 10,000 9,642 96% 5349-453-430246-510 PROPERTY & LIABILITY INS. 9,329 16,000 6,671 42% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 7,076 9,435 2,359 25% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 33,850 45,133 11,283 25% 5349-453-430246-528 DATA PROCESSING TRANSFER 14,191 18,921 4,730 25% 5349-453-430246-530 BNSF LEASE PMT 4,597 6,200 1,603 26% 5349-453-430246-532 OFFICE RENT 6,421 6,422 1 0% 5349-453-430246-955 SYLVAN DRIVE STORMWATER REPAIR 103,746 367,647 263,901 72% 5349-453-430246-970 REGIONAL FACILITIES & PIPING DESIGN 0 5,500,000 5,500,000 100% 5349-453-430247-952 STORM DRAIN CORRECTION 9,917 249,323 239,406 96% 5349-453-430247-953 SHOP COMPLEX PAVEMNT 7,880 23,008 15,128 66% 5349-453-430247-954 N. MAIN ST STORMWATER PROJ. 0 252,500 252,500 100% 5349-453-430247-956 WYOMING STREET OUTFALL 0 225,000 225,000 100% 5349-453-430247-959 REGIONAL FACILITIES & PIPING DESIGN 0 400,000 400,000 100% 5349-453-430247-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% 5349-453-430249-940 MACHINERY FROM REPLACEMENT 23,633 56,500 32,867 58% ------------------------------------------------- SUBTOTAL STORM OPERATIONS 685,760 8,092,526 7,406,766 92% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 33 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM BONDS/LOANS 5349-453-490200-610 PRINCIPLE - 4TH AVE E BOND 0 2,918 2,918 100% 5349-453-490200-620 INTEREST-4TH AVE E BOND 1,641 1,641 0 0% 5349-453-490225-610 PRINCIPLE - REGIONAL FACILITIES 0 72,061 72,061 100% 5349-453-490225-620 INTEREST - REGIONAL FACILITIES 0 103,507 103,507 100% ------------------------------------------------- SUBTOTAL STORM BONDS/LOANS 1,641 180,127 178,486 99% ------------------------------------------------- TOTAL STORM EXPENSE 687,400 8,272,653 7,585,253 92% ================================================= STORM SEWER IMPACT FEE REVENUE 5348-000-343033-000 IMPACT FEES 93,332 130,000 36,668 28% 5348-000-371010-000 INTEREST EARNINGS 24,420 15,000 9,420- -63% ------------------------------------------------- TOTAL STORM IMPACT FEES REVENU 117,752 145,000 27,248 19% ================================================= STORM SWR IMPACT FEE EXPENSES 5348-453-430248-820 DEBT SERVICE TRANSFER TO 5349 0 175,568 175,568 100% 5348-453-430248-825 TRANSFER TO 5349 FOR ADMIN 4,875 6,500 1,625 25% 5348-453-430248-959 REG FACILITIES & PIPING DESIGN 139,604 1,414,852 1,275,248 90% 5348-453-430248-960 STORMWATER FACILITIES UPSIZE 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 144,479 1,876,920 1,732,441 92% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 34 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SOLID WASTE REVENUE: 5510-000-343360-000 SALE OF MAT/AUCTION 2,526 0 2,526- 0% 5510-000-343410-000 GARBAGE COLLECTION-ASSESSED 1,044,367 1,022,000 22,367- -2% 5510-000-343420-000 GARBAGE COLLECTION-BILLED 25,410 23,500 1,910- -8% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,775 2,100 325 15% 5510-000-371010-000 INVESTMENT EARNINGS 16,164 15,000 1,164- -8% ------------------------------------------------- TOTAL SOLID WASTE REVENUE 1,090,243 1,062,600 27,643- -3% ================================================= SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES-SOLID WASTE 295,939 428,543 132,604 31% 5510-460-430840-121 OVERTIME 4,174 6,500 2,326 36% 5510-460-430840-153 HEALTH INSURANCE 69,180 101,080 31,900 32% 5510-460-430840-155 RETIREMENT 22,768 32,232 9,464 29% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 8,171 14,500 6,329 44% 5510-460-430840-218 EQUIPMENT-GARBAGE CONTAINERS 9,539 37,500 27,961 75% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 2,177 5,500 3,323 60% 5510-460-430840-231 GAS & OIL 32,477 60,000 27,523 46% 5510-460-430840-341 ELECTRICITY 1,130 2,050 920 45% 5510-460-430840-344 NATURAL GAS 447 4,500 4,053 90% 5510-460-430840-345 TELEPHONE & COMMUNICATION 1,102 1,250 148 12% 5510-460-430840-354 CONTRACT SERVICES 19,255 20,000 745 4% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 205 5,700 5,495 96% 5510-460-430840-366 BUILDING MAINTENANCE 8,218 8,875 657 7% 5510-460-430840-373 DUES & TRAINING 2,737 5,500 2,763 50% 5510-460-430840-388 MEDICAL SERVICES 635 650 15 2% 5510-460-430840-510 PROPERTY & LIABILITY INS. 12,539 12,539 0 0% 5510-460-430840-512 UNINSURED LOSS-DEDUCTIBLE 3,614 4,000 386 10% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 54,337 72,450 18,113 25% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 33,487 44,649 11,162 25% 5510-460-430840-528 DATA PROCESSING TRANSFER 10,643 14,191 3,548 25% 5510-460-430840-532 OFFICE RENT 6,421 6,422 1 0% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 30,000 40,000 10,000 25% 5510-460-430840-944 VEHICLES (Replacement $) 0 260,000 260,000 100% 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 1,599 4,673 3,074 66% 5510-460-430845-224 JANITORIAL SUPPLIES 266 500 234 47% 5510-460-430845-341 ELECTRICITY 1,175 3,500 2,325 66% 5510-460-430845-342 WATER 340 2,000 1,660 83% 5510-460-430845-344 NATURAL GAS 612 6,000 5,388 90% 5510-460-430845-360 REPAIR & MAINT SERVICES 1,075 6,000 4,925 82% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% ------------------------------------------------- TOTAL SOLID WASTE EXPENSE 634,262 1,361,304 727,042 53% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 35 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 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 138,750 140,000 1,250 1% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 102,712 225,000 122,288 54% 6030-000-371010-000 INVESTMENT EARNINGS 2,493 1,300 1,193- -92% 6030-000-393000-000 INTERNAL SERVICES-DATA 196,748 262,331 65,583 25% ------------------------------------------------- TOTAL INFORMATION TECH REVENUE 440,703 628,631 187,928 30% ================================================= INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 146,771 189,303 42,532 22% 6030-401-410580-121 OVERTIME 51 1,000 949 95% 6030-401-410580-153 HEALTH INSURANCE 27,089 32,742 5,653 17% 6030-401-410580-155 RETIREMENT 11,807 15,017 3,210 21% 6030-401-410588-218 COMPUTERS - CITY MANAGER/HR DEPTS 1,384 2,300 916 40% 6030-403-410580-215 COMPUTER SUPPLIES 1,234 2,000 766 38% 6030-403-410580-218 EQUIPMENT-NOT CAPITAL 14,924 22,840 7,916 35% 6030-403-410580-325 WEBSITE 15,123 16,450 1,327 8% 6030-403-410580-345 PAGER/PHONE 392 900 508 56% 6030-403-410580-346 SUMMITNET & ISPS 3,742 28,140 24,398 87% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,597 4,000 403 10% 6030-403-410580-354 MAINTENANCE CONTRACTS 8,598 45,000 36,402 81% 6030-403-410580-355 LICENSES 12,994 20,185 7,191 36% 6030-403-410580-356 MAINTENANCE CONTRACTS 41,936 60,300 18,364 30% 6030-403-410580-357 GRANICUS 5,280 5,300 20 0% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 63,996 61,011 2,985- -5% 6030-403-410580-373 DUES & TRAINING 1,108 8,275 7,167 87% 6030-403-410580-510 INSURANCE 2,017 3,000 983 33% 6030-403-410583-218 TV-Video Equipment & programming 5,361 7,000 1,639 23% 6030-403-410585-229 COPIER,FAX, SUPPLIES 7,460 18,870 11,410 60% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 61,538 122,000 60,462 50% 6030-403-410585-532 COPIER LEASES 11,371 15,160 3,789 25% 6030-403-410585-942 Servers - capital contingency 0 71,000 71,000 100% 6030-403-510400-831 DEPRECIATION EXPENSE 0 10,000 10,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 3,113 3,870 757 20% 6030-405-410588-940 NETWORK EQUIPMENT 0 28,000 28,000 100% 6030-410-410588-218 COMPUTERS - DPW 4,160 4,440 280 6% 6030-413-410588-218 COMPUTERS - POLICE DEPT 19,193 28,150 8,957 32% 6030-413-410588-354 POLICE - HOSTED SERVER 1,076 2,400 1,324 55% 6030-416-410588-218 COMPUTERS - FIRE 3,167 16,870 13,703 81% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 1,807 2,300 493 21% 6030-436-410588-218 COMPUTERS - PARKS 1,616 4,000 2,385 60% 6030-480-410588-218 COMMUNITY DEVELOPMENT 1,328 1,870 542 29% ------------------------------------------------- TOTAL INFORMATION TECH EXPENSE 483,235 853,693 370,458 43% ================================================= THE CITY OF KALISPELL, MONTANA04.13.2020 16:07 gb8501_pg.php/Job No: 26259 Page 36 of 36 USER: RGW FY20 FINANCIAL REPORT July 1 thru March 31 75.00 % Yr Complete For Fiscal Year: 2020 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 402,000 536,000 134,000 25% 6010-000-371010-000 INVESTMENT EARNINGS 2,026 1,000 1,026- -103% ------------------------------------------------- TOTAL CENTRAL GARAGE REVENUE 404,026 537,000 132,974 25% ================================================= CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 121,238 162,350 41,112 25% 6010-410-431330-121 OVERTIME 1,229 2,500 1,271 51% 6010-410-431330-153 HEALTH INSURANCE 29,679 42,455 12,776 30% 6010-410-431330-155 RETIREMENT 8,877 12,130 3,253 27% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 3,544 11,000 7,456 68% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 2,042 8,000 5,958 74% 6010-410-431330-230 OIL 13,825 25,000 11,175 45% 6010-410-431330-231 GAS 473 1,500 1,027 69% 6010-410-431330-232 VEHICLE PARTS 94,901 126,000 31,099 25% 6010-410-431330-233 TIRES 37,824 50,000 12,176 24% 6010-410-431330-238 FILTERS 3,792 8,500 4,708 55% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 2,088 2,000 88- -4% 6010-410-431330-341 ELECTRICITY 1,453 1,950 497 25% 6010-410-431330-344 NATURAL GAS 786 6,500 5,714 88% 6010-410-431330-354 CONTRACT SERVICES 20,594 32,000 11,406 36% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 42,129 126,375 84,246 67% 6010-410-431330-373 DUES & TRAINING 3,196 7,500 4,304 57% 6010-410-431330-388 MEDICAL SERVICES 145 425 280 66% 6010-410-431330-510 INSURANCE 3,041 4,500 1,459 32% 6010-410-431330-528 INFORMATION TECH TRANSFER 7,095 9,460 2,365 25% 6010-410-431330-921 PARTS WASHER 4,431 10,500 6,069 58% ------------------------------------------------- TOTAL CENTRAL GARAGE EXPENSES 402,382 650,645 248,263 38% =================================================