The URL can be used to link to this page

04-16-21 City Manager Report with Financials and Arrest Reports1 City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 4/16/2021 1. Parks Department Park staff are working to repair an irrigation line break at Begg Park, under the parking lot. Woodland, Lawrence, and Lions parks restrooms will be opened for the season starting April 16. The Urban Forestry Committee is preparing to host Arbor Day virtually this year on April 30. The main ceremony will be live via zoom beginning at 9:00am. The traditional environmental stations at Arbor Day are in the process of being prerecorded and will be made available to all School District 5 third graders via the City’s YouTube channel following the ceremony. Thanks to a grant from the Montana Department of Natural Resources and Conservation, the Boulevard Tree Cost Share Program cost to adjacent homeowners will be reduced to $91.25 for this spring. Under our 50/50 tree replacement program the cost for a boulevard tree is typically $182.50. On April 7, Montana Fish Wildlife and Parks did a fish study of Woodland Pond. This study was to help the biologists understand what species of fish are in the pond and if we have an invasive population. The only fish they were able to catch were two Fathead Minnows, which are considered invasive. There will now be two temperature loggers installed in the pond to provide more data as we continue to work with FWP in options for the future of Woodland Pond. Our Spring Soccer program for ages 3 years old to 4th grade will begin Wednesday, April 21. We have over 420 participants registered for the program with approximately 170 kids playing on Wednesdays and 250 kids playing on Fridays. The league is six weeks long and is scheduled to finish on May 28. Registration for Camp Woodland Summer Day Camp will open on April 19. Due to 2 Covid precautions, we are encouraging parents to email or fax their registration forms again this year. Understanding that state, county, and other local directives and guidelines continue to change, we will send out additional information regarding covid policies and procedures as we get closer to camp opening. Rather than family groups like last summer, we will work to keep participants together in age groups and keep groups consistent. It is our hope to offer a modified field trip schedule this year, however this determination will be made closer to camp starting in June. Our tentative plan is to offer outdoor field trips to places such as Glacier National Park, local state parks, and other outdoor areas on Wednesdays in July and August. We also plan to hold special events on various Fridays (i.e. carnivals, guest speakers, concerts, etc.). 2. Public Works Street Division Pavement Preservation Projects The following table summarizes the mill and overlay projects scheduled for this summer. Schedules are subject to change based on weather, equipment, and any other unforeseen activities that may occur during the paving season. Road closures and traffic impacts will be advertised via the radio, Kalispell’s web site, and social media outlets. The public can also sign up for directed construction PSA notifications via the City’s website at https://mt-kalispell.civicplus.com/list.aspx. New Sidearm Solid Waste Division The Solid Waste Department took ownership of a new 27- yard side arm garbage truck, allocated as part of FY 2021 Solid Waste Budget. The new truck will be used as a main-line route truck as we shuffle the older 2010 truck into backup status for the Solid Waste fleet. Main-line trucks are used 8 years and then moved into backup positions for the last 4-5 years of their useful life with the City. The new truck comes equipped with air disc brakes, designed for the Solid Waste Industry’s harsh stopping environment. City garbage trucks 3 dump containers ranging from 100-gallon rollouts to 400-gallon alley and commercial cans. The new truck’s Curbtender body allows for picking up cans in the City’s tight alley locations, in addition to accommodating collection of the multiple container sizes with the same truck. These trucks collect an average of 650 cans a day and haul two full loads per day to the landfill for disposal. 3. Police Department Attached is the most recent case report from the Police Department. Detective Dan Williams, Officer Justin Turner, Officer Ron Clackler, Sgt. Sean Keller, and Lt. Jordan Venezio attended Assisting Individuals in Crisis and Group Crisis Intervention training. The class helps develop agency-based teams in involving Critical Incident Stress Management for first responders. This class was hosted in partnership with Kalispell Fire and coordinated by retired Kalispell Firefighter Jessica Kinzer. On April 13, Officer Tim Cronin was awarded the 2020 Kalispell Lion’s Club Officer of the Year. On April 6, Officer Toth Mendius started law enforcement basic course in Helena. The Law Enforcement Officer Basic (LEOB) Course is an intensive 12-week course which is offered three times a year. The course is accredited by the Public Safety Officer Standards and Training (POST) Council and conducted on campus by Staff and Adjunct Instructors. Topics covered include; Law & Criminal Procedure, Human Behavior & Social Interaction, Patrol Operations, Investigations, Survival Skills, and Health & Wellness. The Co-Responder program was dispatched to 184 calls for service assisting law enforcement in the Flathead Valley in March. Chief Overman participated as the Law Enforcement representative in the state-wide Funding Behavioral Health System and ROI coalition. The Montana Public Health Institute along with JG Research and Evaluation is trying to gain input as we look at the cost of funding behavioral health crisis systems and what the return on investment is. 4. Planning Department The Planning Board held a public hearing on April 13 and heard three application requests. The application requests consisted of the following: 1. File #KCU-21-02 – A request from Patrick Jentz for a conditional use permit to allow a second single-family structure on a lot within an RA-1 (Residential Apartment) zone. The property contains an existing single-family home towards the front of the lot with the proposed second home to be placed towards the alley. The property is located at 469 First Avenue East North. 4 2. File #KA-21-01 – A request from Manpreet Singh (Kalispell Properties, LLC) for annexation and initial zoning of B-1 (Neighborhood Business) for property located at 81 Woodland Park Drive (Woodland Quick Stop), containing approximately 0.53 acres. The request is based on a desire to connect to city sanitary sewer service. 3. File #KZTA-21-01 –A request by the City of Kalispell Planning Department on behalf of the Downtown Business Improvement District for a text amendment to the Kalispell Zoning Ordinance for the creation of a Downtown Historic District Overlay and the addition of the Downtown Historic District Design Standards. The Business Improvement District received a grant from the Montana Department of Commerce Main Street Program in 2020 to establish historic design standards as part of an effort to implement the goals of the Downtown Plan and Growth Policy. Staff, in conjunction with consultant A&E Architects, has drafted the proposal. The design standards are broken into two subsections: one set of standards that applies to all properties within the Downtown Historic District Overlay and focuses on pedestrian-friendly urban site design and an additional set of standards that would apply to buildings within the Main Street Historic District (a sub-district of the overall overlay) that focus on historic architectural form, material, and colors reflective of Kalispell’s period of significance (1891-1960). The Downtown Historic District Overlay is generally bounded by Center Street to the north, 3rd Ave East to the east, 5th Street to the south, and the alley between 2nd Ave West and 3rd Ave West to the west. The Board did unanimously recommend approval of all three application requests. Their recommendations of KCU-21-02 and KA-21-01 will be forwarded onto the Council for their consideration at their May 3, 2021 meeting. Application KZTA-21-01 (Historical Standards) will be topic of discussion at the Council’s work session on April 26, 2021. The Council will then consider the application request at their meeting on May 17, 2021. 5. Building Department In the last 2 weeks, we have issued permits for 16 single-family homes. This brings the total of new single-family/duplex and townhouse units for the year to 76, compared to 47 last year at this time. There have been 51 multi-family housing units issued so far this year. Last year at this time we had not issued any multi-family housing permits. There was a total of 181 combined building and/or fire inspections completed in the last 2 weeks. Residential – 80 Plumbing – 16 Commercial – 18 Mechanical - 17 Electrical – 11 Fire - 39 5 6. Community Development Landscaping is being completed on the South Kalispell Traffic Project with the irrigation system, trees and sod. Paving work will restart next week. The project is to be substantially completed on April 30. The Region 8 Brownfields office will conduct a phase I and phase II environmental site assessment at the Depot Building occupied by the Kalispell Chamber of Commerce at their request. The Chamber is interested in gathering the information generated by these reports to prepare for maintenance work and plan future expansion. Reports are expected to be completed this Summer. The City is preparing to apply to the Montana Department of Transportation for a Transportation Alternatives grant for the purpose of constructing a section of shared use path along Kidsports at 4 Mile Drive where there currently is none. For the application, a proposed design and budget are being developed to be shared with City Council at a public hearing on the proposed project in May. The grant application is due June 4. 7. Finance Quarterly Finance Report Please find attached the printouts reflecting the activity for the 1st nine months of fiscal year 2021. This printout reflects payroll earned thru March 27 and accounts payable claims received by the end of March. Most funds are included in the report, however some funds are excluded due to insignificant activity (expenditures). Revenues are displayed for funds that have a significant revenues that are not “taxes and/or assessments.” Debt service funds are not included. GENERAL FUND General Fund tax revenue reflects taxes collected thru March 31. Historically, the general fund receives about 45% of its property tax revenue in the 4th quarter. A similar distribution for this fiscal year would bring collections to almost $7M or about 105% of budget. The City is currently carrying just over $3,000 in protest taxes. Liquor licenses are billed once a year and are due by June 30. Planning fees and site review fees have already exceeded budget. City Court fines and fees revenue reflects July thru February (8 months). General Fund expenditures reflect 69% spent, compared to 71% for the same 9 months last fiscal period. Most general fund departments, including police (28%) and fire (28%), have at least 3 months (25%) budget remaining. PARKS 6 The parks fund receives approximately 2/3 of its revenue from tax levies (general and permissive health). A majority of parks charges for services revenue is received in the 2nd half of the fiscal year. Similar to a solely tax supported fund, the parks fund should have enough cash available at July 1st (and January 1st) to pay expenditures, less revenues other than taxes, through December (June). Beginning cash carryover was 50% (FY20) and 48% (FY21). Parks fund tax collections are 56% at the end of March, compared to 59% one year ago. Many of the Parks programs were negatively affected by the pandemic. Recreation fees and the After School Program fees are over 20% off of the fiscal year 20 pace. Youth camps revenue, and many of the other user-based parks fees, historically receives more of their revenue in the last quarter of the fiscal year (spring). Parks fund expenditures reflect 58% spent, a decrease of over 11% over the same period last fiscal year. All parks fund departments have at least 3 months (25%) budget remaining. AMBULANCE The ambulance fund is a special revenue fund that receives approximately 2/3 of its revenue from charges for services. Because ambulance fees for services are insufficient to support the cost to operate this fund, a transfer from the general fund is necessary each fiscal year. Ambulance fees for services ($410,375) are down over 20% from the same period last year ($516,309). Inception of lease (BOI loan) is for the purchase of the ambulance in the current fiscal year. Ambulance fund operating expenditures reflect a decrease of about $15,000 from the same period in fiscal year 20. Not included in the operations decrease is the capital purchase of a new ambulance for $189,481. BUILDING DEPARTMENT The building fund is supported by permits and fees. Permits and fees revenues are random. At a minimum, this fund should have enough cash available at July 1st to pay expenditures through December. Beginning cash carryover was 162% (FY20) and 171% (FY21). Most Building department permits and fees have exceeded the budgeted annual amounts. The approximately $803,000 of permits and fees collected in the first three quarters of this fiscal year is about 106% of the annual budget, and about 60% more than at this point last fiscal year. Building fund operating expenditures reflect an increase of about $17,000 from the same period in fiscal year 20. Not included in the operations decrease is the partial capital construction of the City Hall Mezzanine for $73,945. 7 WATER The water fund is supported by charges for water service. Metered water sales thru March were $2,868,606 (86%), an increase from last fiscal first half of about 19%. It is normal for metered water sales to be in excess of 75%, normally about 80%, of the annual amount because of late summer and fall sprinkling and irrigation. The increase from fiscal year 2020 water revenue can be attributed to the reduction in impact fees and compensating increase in rates. Water impact fees are 152% of the fiscal year 21 budget. Fiscal year 21 capital purchases of the water department thru the first three quarters were $1,777,244. This includes about $80,000 in purchases with the use of impact fees. Water projects include SCADA upgrades and 10th Ave. W. main repairs. SEWER The sewer fund is supported by charges for sewer service. Sewer service charges thru March 31 were $4,512,840, three-fourths (75%) of the budgeted amount. Last year’s sewer service charges were $3,409,538 for the same time period. The increase from fiscal year 2020 sewer revenue can be attributed to the reduction in impact fees and compensating increase in rates. Sanitary sewer (205%) and treatment plant impact fees (274%) have both exceeded the anticipated fiscal year 2021 amount. Fiscal year 21 capital purchases of the water department thru the first three quarters were $825,940. This includes about $300,000 in purchases with the use of impact fees. Water projects include slip lining sewer mains, the west side interceptor, and 11th St. W. main repairs. EXPENDITURES/EXPENSES: For most funds or departments, expenditures/expenses include the 19th (39 of 52 weeks) payroll period ending March 27th. Most departments and/or funds have over 24% remaining in the salaries and retirement lines which should be adequate. The majority of fire department and ambulance fund employees are paid 13 times annually. This 1st half report includes the 9th of 13 (39 of 52 weeks/25%) pay periods for these employees. Health insurance is paid 12 times per year and includes 10 months (83%) on this report for all funds. With a few exceptions, administrative, central garage, and information technology transfers are done monthly and should show 75% remaining. This is the same on the revenue side for fees for services (Central Garage), internal services (Information Technology), administrative charges (General Fund), and many of the transfers between funds. The general fund administrative charges may vary slightly as some charges are based on a percentage of revenues collected. Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Offenses Reported Arrests Crimes Against Persons Homicide/Justifiable Homicide 0 0 1 0 0 0 1 0 SIWOC/Sexual Assault 3 0 0 0 5 0 8 0 Robbery 0 0 0 0 0 0 0 0 Aggravated Assault 3 0 4 2 3 3 10 5 Assault on a Peace Officer 0 0 4 3 0 0 4 3 Simple Assault 6 5 7 3 9 6 22 14 PFMA 12 8 10 10 8 6 30 24 Resisting Arrest 3 3 4 4 6 6 13 13 Crimes Against Property Burglary 2 0 1 0 4 1 7 1 Theft 41 23 37 16 45 21 123 60 Vehicle Theft/Unauth Use 3 1 3 1 9 6 15 8 Arson 0 0 0 0 0 0 0 0 Forgery/Counterfeit 1 1 5 0 3 0 9 1 Fraud 5 2 4 1 3 1 12 4 Theft of Identity 0 0 1 0 0 0 1 0 Embezzlement 1 2 0 0 0 0 1 2 Stolen Property offenses 0 0 1 0 1 0 2 0 Criminal Mischief 8 3 8 1 21 2 37 6 Crimes Against Society Weapon Law Violations 1 1 0 0 0 0 1 1 Prostitution Offenses 0 0 0 0 0 0 0 0 Child Pornography 0 0 0 0 0 0 0 0 Drug Offenses 22 16 9 8 23 14 54 38 Family Offenses (non-violent)2 0 0 0 2 0 4 0 DUI 6 5 10 9 4 4 20 18 Possession of Alcohol 1 1 5 4 0 0 6 5 Provide Alcohol to Minor 1 0 0 0 0 0 1 0 Other Alcohol Offenses 0 0 0 0 2 1 2 1 Kidnapping/Custodial Int.1 1 0 0 1 1 2 2 Disorderly Conduct 7 6 4 4 4 5 15 15 Criminal Trespass 28 22 7 8 10 6 45 36 Violation of Protective Order 4 2 9 1 2 0 15 3 Obstructing a peace officer 13 12 5 4 5 5 23 21 Juvenile Offenses (except MIP)1 1 2 2 0 0 3 3 Other Offenses 42 41 29 27 33 30 104 98 Total 217 156 170 108 203 118 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 590 382 Traffic Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites Traffic Stops Cites 513 345 367 294 504 333 1384 972 Total Calls for Service Kalispell Police Department Case and Arrest Reports - 2021 January February March April May June July August September October November December Totals 2775 2465 3013 8253 THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 1 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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,818,207 6,463,000 2,644,793 41% 1000-000-311105-000 PILT-GL MANOR & TRESURE ST PLAZA 8,887 18,156 9,269 51% 1000-000-311200-000 PERSONAL PROPERTY TAXES 155,936 200,000 44,064 22% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 13,898 9,000 4,898- -54% 1000-000-322101-000 LIQUOR LICENSES 286 33,000 32,714 99% 1000-000-322300-000 BUSINESS LICENSES 1,770 1,500 270- -18% 1000-000-323012-000 PLANNING FEES 79,079 60,000 19,079- -32% 1000-000-323109-000 SITE REVIEW 25,364 15,000 10,364- -69% 1000-000-323200-000 PARADE PERMITS 0 1,000 1,000 100% 1000-000-331023-000 MRVCTF 1,676 0 1,676- 0% 1000-000-331112-000 KPD - SAFE STREET TASK FORCE 0 8,000 8,000 100% 1000-000-331992-000 CARES ACT REIMBURSEMENT THRU STATE 1,774,164 0 1,774,164- 0% 1000-000-335030-000 M.V. TAX - AD VALOREM 1,316 1,200 116- -10% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 59,800 60,000 200 0% 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,650 1,400 250- -18% 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 2,261,564 3,023,892 762,328 25% 1000-000-341020-000 ADMINISTRATIVE CHARGES 459,202 613,512 154,310 25% 1000-000-341021-000 GRANT ADMIN FEES 17,187 25,000 7,813 31% 1000-000-341025-000 CITY COLLECTIONS 5,337 5,000 337- -7% 1000-000-342010-000 POLICE SERVICES 20,666 29,000 8,334 29% 1000-000-342014-000 RESOURCE OFFICERS 224,435 224,435 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 800 14,500 13,700 94% 1000-000-343018-000 PARKING PERMITS 69,760 95,000 25,240 27% 1000-000-343062-000 AIRPORT FUEL TAXES 3,480 4,000 520 13% 1000-000-343063-000 AIRPORT GROUND LEASE (HILTON) 15,301 14,500 801- -6% 1000-000-351000-000 CITY COURT FINES & FEES 247,226 450,000 202,774 45% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 15,248 30,000 14,752 49% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 26,725 55,000 28,275 51% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 32,737 20,000 12,737- -64% 1000-000-362020-000 MMIA GASB 54 REIMBURSEMENT 73,623 78,500 4,877 6% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 38 10,000 9,962 100% 1000-000-371010-000 INVESTMENT EARNINGS 37,636 36,000 1,636- -5% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 485,000 970,000 485,000 50% ------------------------------------------------- TOTAL GENERAL FUND REVENUE 9,937,997 12,569,595 2,631,598 21% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 2 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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 3,030 0 0% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 13,750 13,750 0 0% 1000-400-410530-354 OPEB EXPENSE 1,500 1,500 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 4,219 3,500 719- -21% 1000-400-410560-312 POSTAGE 12,207 16,000 3,793 24% 1000-400-410560-320 PRINTING & ENVELOPES 2,370 5,500 3,130 57% 1000-400-410560-354 CONTRACT SERVICES - DOC. SHREDDING 1,240 1,400 160 11% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 2,644 3,000 356 12% 1000-400-420000-354 CONTRACT 911 CENTER 278,029 557,482 279,454 50% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 286 350 64 18% 1000-400-430300-355 AIRPORT REIMBURSEMENT 19,561 19,000 561- -3% 1000-400-460000-820 TFR TO WESTSIDE TIF (CORE AREA) 623,000 1,246,000 623,000 50% 1000-400-460452-355 EAGLE TRANSIT CONTRIBUTION 15,000 15,000 0 0% 1000-400-460452-366 HOCKADAY MAINTENANCE 6,600 6,600 0 0% 1000-400-510300-000 CONTINGENCY 6,043 105,000 98,957 94% 1000-400-510310-354 ICMA PLAN FEES 375 500 125 25% 1000-400-510330-513 LIABILITY INSURANCE 186,790 186,790 0 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 20,913 60,000 39,087 65% 1000-400-510330-517 PROPERTY INSURANCE 59,654 59,654 0- 0% ------------------------------------------------- SUBTOTAL GEN.GOV'T. 1,257,212 2,304,056 1,046,844 45% CITY MANAGER 1000-401-410210-110 SALARIES-CITY MANAGER'S OFFICE 113,082 155,616 42,534 27% 1000-401-410210-153 HEALTH INSURANCE 19,195 25,078 5,883 23% 1000-401-410210-155 RETIREMENT 12,087 16,536 4,449 27% 1000-401-410210-210 SUPPLIES 0 1,000 1,000 100% 1000-401-410210-312 NEWSLETTER/BOOKS 0 400 400 100% 1000-401-410210-345 TELEPHONE & COMMUNICATION 760 1,200 440 37% 1000-401-410210-373 DUES & TRAINING 1,941 12,000 10,059 84% 1000-401-410210-379 MEETINGS 616 6,500 5,884 91% ------------------------------------------------- SUBTOTAL CITY MANAGER 147,681 218,330 70,649 32% HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 92,503 127,530 35,027 27% 1000-401-410830-153 HEALTH INSURANCE 14,433 23,920 9,487 40% 1000-401-410830-155 RETIREMENT 7,510 10,202 2,692 26% 1000-401-410830-210 OFFICE SUPPLIES 1,029 900 129- -14% 1000-401-410830-338 RECRUITMENT/RELOCATION 29,768 20,000 9,768- -49% 1000-401-410830-354 CONTRACT SERVICES 2,200 1,500 700- -47% 1000-401-410830-373 DUES & TRAINING 4,173 7,500 3,327 44% ------------------------------------------------- SUBTOTAL HUMAN RESOURCES 151,617 191,552 39,935 21% THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 3 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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,333 63,087 16,754 27% 1000-402-410100-153 HEALTH INSURANCE 34,875 50,783 15,908 31% 1000-402-410100-155 RETIREMENT 1,925 2,587 662 26% 1000-402-410100-210 OFFICE SUPPLIES 0 6,500 6,500 100% 1000-402-410100-335 MT LEAGUE OF CITIES 150 2,000 1,850 93% 1000-402-410100-354 CONTRACT SERVICES 1,388 5,500 4,112 75% 1000-402-410100-373 DUES & TRAINING 9,089 11,500 2,411 21% 1000-402-410100-379 MEETINGS 0 22,000 22,000 100% ------------------------------------------------- SUBTOTAL MAYOR/COUNCIL 93,759 163,957 70,198 43% CITY CLERK 1000-402-410150-110 SALARIES-CITY CLERK 74,295 101,094 26,799 27% 1000-402-410150-121 OVERTIME 0 250 250 100% 1000-402-410150-153 HEALTH INSURANCE 16,870 22,168 5,298 24% 1000-402-410150-155 RETIREMENT 6,038 8,138 2,100 26% 1000-402-410150-210 OFFICE SUPPLIES 148 300 152 51% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 106 600 494 82% 1000-402-410150-345 TELEPHONE & COMMUNICATION 415 480 65 14% 1000-402-410150-352 CODIFICATION 1,683 4,100 2,417 59% 1000-402-410150-354 CONTRACT SERVICES 0 300 300 100% 1000-402-410150-373 DUES & TRAINING 814 6,200 5,386 87% ------------------------------------------------- SUBTOTAL CITY CLERK 100,367 143,630 43,263 30% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES-FINANCE OFFICE 162,772 217,352 54,580 25% 1000-403-410550-121 OVERTIME 0 500 500 100% 1000-403-410550-153 HEALTH INSURANCE 29,084 42,148 13,064 31% 1000-403-410550-155 RETIREMENT 13,157 17,434 4,277 25% 1000-403-410550-210 SUPPLIES 178 800 622 78% 1000-403-410550-322 BOOKS 0 500 500 100% 1000-403-410550-353 CONTRACT SERVICES 0 350 350 100% 1000-403-410550-354 CONTRACT-GRIZZLY SECURITY 360 900 540 60% 1000-403-410550-355 BANK CHARGES & FEES 2,308 3,200 892 28% 1000-403-410550-373 DUES & TRAINING 1,816 8,500 6,684 79% ------------------------------------------------- SUBTOTAL FINANCE 209,676 291,684 82,008 28% THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 4 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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 349,612 476,010 126,398 27% 1000-404-411110-153 HEALTH INSURANCE 66,647 82,216 15,569 19% 1000-404-411110-155 RETIREMENT 28,430 38,314 9,884 26% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 18,605 2,500 16,105- -644% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 14,838 25,000 10,162 41% 1000-404-411110-345 TELEPHONE & COMMUNICATION 593 1,000 407 41% 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 20,896 10,000 10,896- -109% 1000-404-411110-373 DUES & TRAINING 3,616 6,500 2,884 44% ------------------------------------------------- SUBTOTAL CITY ATTORNEY 503,236 641,540 138,304 22% MUNICIPAL COURT 1000-406-410360-110 SALARIES-COURT 173,286 236,239 62,953 27% 1000-406-410360-121 OVERTIME 0 3,500 3,500 100% 1000-406-410360-153 HEALTH INSURANCE 35,493 47,494 12,001 25% 1000-406-410360-155 RETIREMENT 13,921 18,961 5,040 27% 1000-406-410360-210 SUPPLIES 808 4,500 3,692 82% 1000-406-410360-320 PRINTING/BOOKS 789 1,500 711 47% 1000-406-410360-345 TELEPHONE & COMMUNICATION 89 1,000 911 91% 1000-406-410360-353 SECURITY & TECHNOLOGY 4,850 40,000 35,150 88% 1000-406-410360-354 CONTRACT SERVICES 2,470 6,250 3,780 60% 1000-406-410360-373 DUES & TRAINING 372 10,000 9,628 96% 1000-406-410360-394 JURY & WITNESS FEES 4,223 7,500 3,277 44% ------------------------------------------------- SUBTOTAL COURT 236,301 376,944 140,643 37% PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES-PUBLIC WORKS 14,496 19,689 5,193 26% 1000-410-430100-153 HEALTH INSURANCE 2,664 3,806 1,142 30% 1000-410-430100-155 RETIREMENT 1,164 1,550 386 25% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 10,339 14,500 4,161 29% 1000-410-430100-231 GAS 1,712 3,000 1,288 43% 1000-410-430100-345 TELEPHONE & COMMUNICATION 223 350 127 36% 1000-410-430100-354 CONTRACT SERVICES 716 2,000 1,284 64% 1000-410-430100-373 DUES & TRAINING 737 4,500 3,763 84% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 3,163 4,217 1,054 25% ------------------------------------------------- SUBTOTAL PUBLIC WORKS ADMIN 35,213 53,612 18,399 34% CITY HALL MAINT. 1000-412-411230-110 SALARIES-CITY HALL 49,900 68,986 19,086 28% 1000-412-411230-153 HEALTH INSURANCE 11,253 14,718 3,465 24% 1000-412-411230-155 RETIREMENT 3,924 5,307 1,383 26% 1000-412-411230-220 SECURITY IMPROVEMENTS 1,442 6,793 5,351 79% 1000-412-411230-224 JANITORIAL SUPPLIES 4,852 6,800 1,948 29% 1000-412-411230-241 TOOLS & SUPPLIES 260 1,500 1,240 83% 1000-412-411230-341 ELECTRICITY 36,166 45,000 8,834 20% 1000-412-411230-344 NATURAL GAS 25,992 32,000 6,008 19% 1000-412-411230-345 TELEPHONE & COMMUNICATION 337 400 63 16% 1000-412-411230-354 CONTRACT SERVICES 7,888 25,000 17,112 68% THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 5 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-412-411230-355 HVAC MAINTENANCE CONTRACT 17,380 16,500 880- -5% 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 6,340 6,000 340- -6% 1000-412-411230-362 EQUIPMENT MAINTENANCE 2,377 10,000 7,623 76% 1000-412-411230-366 BUILDING MAINTENANCE 3,038 41,150 38,112 93% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,342 3,700 358 10% ------------------------------------------------- SUBTOTAL CITY HALL 174,492 283,854 109,362 39% 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES-PLANNING & ZONING 167,517 224,538 57,022 25% 1000-420-411020-153 HEALTH INSURANCE 33,738 49,800 16,062 32% 1000-420-411020-155 RETIREMENT 13,413 18,081 4,668 26% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 3,375 4,000 625 16% 1000-420-411020-231 GAS 65 400 335 84% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 741 2,200 1,459 66% 1000-420-411020-345 TELEPHONE 439 1,000 561 56% 1000-420-411020-354 CONTRACT SERVICES 5,557 5,500 57- -1% 1000-420-411020-373 DUES & TRAINING 878 7,500 6,622 88% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 231 308 77 25% ------------------------------------------------- SUBTOTAL PLANNING DEPT. 225,954 313,327 87,373 28% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 51,864 71,468 19,604 27% 1000-480-470210-153 HEALTH INSURANCE 12,757 16,750 3,993 24% 1000-480-470210-155 RETIREMENT 4,227 5,716 1,489 26% 1000-480-470210-210 OFFICE SUPPLIES 670 1,600 930 58% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 393 500 107 21% 1000-480-470210-312 POSTAGE & PRINTING 151 300 149 50% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 0 500 500 100% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 389 450 61 14% 1000-480-470210-354 CONTRACT SERVICES 180 250 70 28% 1000-480-470210-373 DUES & TRAINING 1,259 5,000 3,741 75% 1000-480-470210-379 MEETINGS 20 750 730 97% ------------------------------------------------- SUBTOTAL COMMUNITY DEVELOPMENT 71,911 103,284 31,373 30% THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 6 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES-POLICE 1,822,502 2,558,903 736,401 29% 1000-413-420140-112 SALARIES-SEVERANCE 19,753 40,000 20,247 51% 1000-413-420140-114 SALARY -comptime buyout 10,669 11,500 831 7% 1000-413-420140-121 OVERTIME (REG & AET OT) 71,871 80,000 8,129 10% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 9,193 35,000 25,807 74% 1000-413-420140-153 HEALTH INSURANCE 365,760 512,582 146,822 29% 1000-413-420140-155 RETIREMENT 233,402 336,010 102,608 31% 1000-413-420140-210 OFFICE SUPPLIES 2,564 3,500 936 27% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 25,265 27,000 1,735 6% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 19,822 32,560 12,738 39% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 3,772 3,760 12- -0% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 7,858 11,500 3,642 32% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 1,230 1,500 270 18% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 9,312 10,000 688 7% 1000-413-420140-227 AMMO & RELATED SUPPLIES 30,889 33,800 2,911 9% 1000-413-420140-228 PATROL CAR SUPPLIES 12,228 17,500 5,272 30% 1000-413-420140-229 OTHER SUPPLIES 2,245 5,000 2,755 55% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 216 1,000 784 78% 1000-413-420140-231 GAS 33,512 85,000 51,488 61% 1000-413-420140-234 CRISIS NEGOTIATIONS 468 500 32 6% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 376 1,500 1,124 75% 1000-413-420140-320 PRINTING 2,415 5,500 3,085 56% 1000-413-420140-345 TELEPHONE & COMMUNICATION 16,020 21,000 4,980 24% 1000-413-420140-354 CONTRACT SERVICES 37,082 35,800 1,282- -4% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 2,552 6,500 3,948 61% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 1,149 2,100 951 45% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 536 2,000 1,464 73% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 53,692 59,240 5,548 9% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 3,488 2,800 688- -25% 1000-413-420140-373 DUES & TRAINING 46,794 55,000 8,206 15% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 318 14,500 14,182 98% 1000-413-420140-380 TRAINING MATERIALS 5,000 5,000 0 0% 1000-413-420140-388 MEDICAL SERVICES 2,735 3,000 265 9% 1000-413-420140-392 BOARDING/TREATING PRISONERS 1,194 2,500 1,307 52% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 66,372 88,496 22,124 25% 1000-413-420140-530 RENT 5,400 7,200 1,800 25% 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 4,500 6,000 1,500 25% 1000-413-420140-944 VEHICLES 74,615 77,000 2,385 3% ------------------------------------------------- SUBTOTAL POLICE DEPT. 3,054,769 4,265,751 1,210,982 28% DETECTIVES 1000-413-420141-110 SALARIES-DETECTIVES 287,870 400,261 112,391 28% 1000-413-420141-121 DETECTIVE-OVERTIME 10,030 15,000 4,970 33% 1000-413-420141-123 OVERTIME (SAFE NEIGHBORHOOD TASK FO 0 8,000 8,000 100% 1000-413-420141-153 HEALTH INSURANCE 68,122 95,807 27,685 29% 1000-413-420141-155 DETECTIVE-RETIREMENT 38,360 53,729 15,369 29% ------------------------------------------------- TOTAL DETECTIVES 404,382 572,797 168,415 29% RECORDS 1000-413-420142-110 SALARIES-RECORDS DIVISION 110,116 152,955 42,839 28% THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 7 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 1000-413-420142-121 OVERTIME 4,019 7,500 3,481 46% 1000-413-420142-153 HEALTH INSURANCE 27,900 37,444 9,544 25% 1000-413-420142-155 RETIREMENT 9,191 12,242 3,051 25% ------------------------------------------------- TOTAL RECORDS 151,226 210,141 58,915 28% RESOURCE OFFICERS 1000-413-420144-110 SALARIES-SRO 206,542 281,666 75,124 27% 1000-413-420144-153 HEALTH INSURANCE 46,217 56,050 9,833 18% 1000-413-420144-155 SRO RETIREMENT 26,987 37,912 10,925 29% ------------------------------------------------- TOTAL RESOURCE OFFICERS 279,746 375,628 95,882 26% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL-SALARIES 33,866 46,291 12,425 27% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 6,975 9,111 2,136 23% 1000-413-420145-155 RETIREMENT 2,610 3,565 955 27% ------------------------------------------------- SUBTOTAL ANIMAL CONTROL 43,451 59,467 16,016 27% PARKING 1000-413-420147-110 PARKINGS -SALARIES 62,707 85,511 22,804 27% 1000-413-420147-153 HEALTH INSURANCE 25,514 33,500 7,986 24% 1000-413-420147-155 RETIREMENT 4,999 6,840 1,841 27% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 1,472 4,000 2,528 63% 1000-413-420147-354 CONTRACTED SERVICES 1,816 2,000 184 9% 1000-413-420147-362 LOT MAINT 832 10,000 9,168 92% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 10,860 17,500 6,640 38% 1000-413-420147-550 LOT LEASE PAYMENTS 594 1,500 906 60% ------------------------------------------------- SUBTOTAL PARKING 108,794 160,851 52,057 32% ------------------------------------------------- SUBTOTAL POLICE DEPT. 4,042,367 5,644,635 1,602,268 28% THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 8 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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,295,870 1,913,898 618,028 32% 1000-416-420400-112 SALARY-SEVERANCE 40,305 54,361 14,056 26% 1000-416-420400-113 KELLY DAYS 240 0 240- 0% 1000-416-420400-114 COMPTIME BUYOUT 3,437 5,500 2,063 38% 1000-416-420400-115 OUT OF RANK PAY 10,143 12,500 2,357 19% 1000-416-420400-121 OVERTIME 166,771 40,000 126,771- -317% 1000-416-420400-153 HEALTH INSURANCE 273,671 348,552 74,881 21% 1000-416-420400-155 RETIREMENT 177,245 250,532 73,287 29% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 936 3,000 2,064 69% 1000-416-420400-218 Equipment (Non Capital) 9,038 21,500 12,462 58% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 7,585 15,000 7,415 49% 1000-416-420400-224 JANITORIAL SUPPLIES 3,822 5,000 1,178 24% 1000-416-420400-231 GAS 5,381 17,325 11,944 69% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 10,736 15,750 5,014 32% 1000-416-420400-320 PRINTING 0 200 200 100% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 58 1,250 1,192 95% 1000-416-420400-345 TELEPHONE & COMMUNICATION 2,866 6,000 3,134 52% 1000-416-420400-354 CONTRACT SERVICES 11,229 17,460 6,231 36% 1000-416-420400-362 EQUIPMENT MAINTENANCE 6,478 5,500 978- -18% 1000-416-420400-366 BUILDING MAINTENANCE-STATION 62 2,686 7,500 4,814 64% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 2,534 5,000 2,466 49% 1000-416-420400-373 DUES & TRAINING 6,608 10,000 3,392 34% 1000-416-420400-388 FIREFIGHTER PHYSICALS 1,790 29,000 27,211 94% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 21,513 28,684 7,171 25% 1000-416-420400-610 DEBT RETIREMENT-FIRE TRUCK 44,387 44,387 0 0% 1000-416-420400-620 INTEREST EXPENSE-FIRE TRUCK 6,582 9,776 3,194 33% 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 233,333 350,000 116,667 33% 1000-416-420400-821 TFR - 2956 AFG ($31,591)/2995 SAFAR 0 56,591 56,591 100% 1000-416-420440-110 SALARIES-FIRE PREVENTION 15,546 22,115 6,569 30% 1000-416-420440-153 HEALTH INSURANCE 4,378 5,736 1,358 24% 1000-416-420440-155 RETIREMENT 1,221 1,681 460 27% ------------------------------------------------- SUBTOTAL FIRE DEPT. 2,366,390 3,303,798 937,408 28% ------------------------------------------------- GRAND TOTAL GENERAL FUND 9,616,176 14,034,203 4,418,027 31% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 9 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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 626,014 1,065,000 438,986 41% 2215-000-311200-000 PERSONAL PROPERTY TAXES 24,681 35,000 10,319 29% 2215-000-312000-000 PEN & INTEREST DEL TAXES 1,462 1,500 38 3% 2215-000-346030-000 SWIMMING POOL FEES 59,826 148,410 88,584 60% 2215-000-346040-000 CONCESSION STAND REVENUE 22,142 37,800 15,658 41% 2215-000-346050-000 PARKS USAGE FEES 10,853 20,000 9,147 46% 2215-000-346051-000 RECREATION FEES 10,269 25,048 14,779 59% 2215-000-346052-000 SPORTS PROGRAMS 58,958 73,577 14,619 20% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 1,994 2,000 6 0% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 34,677 67,500 32,823 49% 2215-000-346055-000 ICE RINK 10,648 22,000 11,352 52% 2215-000-346056-000 KIDSPORT USAGE 1,029 4,000 2,971 74% 2215-000-346057-000 YOUTH CAMPS 32,620 179,201 146,581 82% 2215-000-346059-000 PICNIC IN THE PARK 9,861 26,500 16,639 63% 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 25,725 0 25,725- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 20,000 20,000 100% 2215-000-371010-000 INVESTMENTS 4,089 6,500 2,411 37% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 49,000 98,000 49,000 50% ------------------------------------------------- TOTAL PARKS & REC REVENUE 983,848 1,832,036 848,188 46% ================================================= PARKS & REC. EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES-PARKS 240,142 347,866 107,724 31% 2215-436-460430-111 SEASONAL SALARIES 25,131 66,712 41,581 62% 2215-436-460430-121 OVERTIME 0 300 300 100% 2215-436-460430-153 HEALTH INSURANCE 47,062 72,336 25,274 35% 2215-436-460430-155 RETIREMENT 20,425 30,263 9,838 33% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 2,020 4,400 2,380 54% 2215-436-460430-215 EQUIPMENT - not capital 350 3,000 2,650 88% 2215-436-460430-224 JANITORIAL SUPPLIES 2,533 7,000 4,467 64% 2215-436-460430-229 OTHER SUPPLIES 2,174 10,000 7,826 78% 2215-436-460430-231 GAS 8,864 17,000 8,136 48% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 2,547 4,000 1,453 36% 2215-436-460430-320 PRINTING & ADVERTISING 166 200 34 17% 2215-436-460430-341 ELECTRICITY 9,254 13,500 4,246 31% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 17,499 22,000 4,501 20% 2215-436-460430-344 NATURAL GAS 1,711 2,500 789 32% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 1,323 2,800 1,477 53% 2215-436-460430-351 SPORTS COURT & SPORT MAINTENANCE 0 2,000 2,000 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 2,000 2,000 0 0% 2215-436-460430-355 CONTRACT SERV. TRAIL MAINT/WEED CON 2,054 18,000 15,946 89% 2215-436-460430-356 TRAIL STUDY 0 30,000 30,000 100% 2215-436-460430-358 FVCC TENNIS INTERLOCAL AGREEMENT 7,000 7,000 0 0% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 7,256 8,500 1,244 15% 2215-436-460430-364 LANDSCAPING 0 6,100 6,100 100% 2215-436-460430-367 VANDALISM REPAIRS 2,570 4,200 1,630 39% 2215-436-460430-373 DUES & TRAINING 763 8,000 7,238 90% THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 10 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 0 400 400 100% 2215-436-460430-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 2,168 7,000 4,832 69% 2215-436-460430-440 IRRIGATION SUPPLIES 720 7,500 6,780 90% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 772 2,000 1,228 61% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 27,050 36,067 9,017 25% 2215-436-460430-545 COUNTY LANDFILL 3,735 6,273 2,538 40% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 58,859 58,859 0 0% 2215-436-460430-620 DEBT SERVICE INTEREST 2,854 6,424 3,570 56% ------------------------------------------------- SUBTOTAL PARKS EXPENDITURES 498,999 814,700 315,701 39% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES-COMPLEX 79,952 112,922 32,970 29% 2215-436-460440-111 SEASONAL SALARIES 17,421 38,917 21,496 55% 2215-436-460440-121 OVERTIME 0 300 300 100% 2215-436-460440-153 HEALTH INSURANCE 23,771 33,161 9,390 28% 2215-436-460440-155 RETIREMENT 7,618 10,318 2,700 26% 2215-436-460440-221 SAFETY EQUIPMENT 0 600 600 100% 2215-436-460440-229 OTHER SUPPLIES 3,137 22,000 18,863 86% 2215-436-460440-231 GAS 2,807 9,000 6,193 69% 2215-436-460440-241 CONSUMABLE TOOLS 197 2,000 1,803 90% 2215-436-460440-341 ELECTRICITY 7,044 9,500 2,456 26% 2215-436-460440-345 TELEPHONE & COMMUNICATION 174 240 66 28% 2215-436-460440-354 CONTRACT SERVICES 200 1,000 800 80% 2215-436-460440-362 EQUIPMENT MAINTENANCE 235 800 565 71% 2215-436-460440-364 LANDSCAPING 0 500 500 100% 2215-436-460440-367 VANDALISM REPAIRS 109 500 391 78% 2215-436-460440-373 DUES & TRAINING 140 700 560 80% 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 165 200 35 18% 2215-436-460440-395 RENTAL EQUIPMENT 0 200 200 100% 2215-436-460440-420 METAL PRODUCTS 0 4,000 4,000 100% 2215-436-460440-440 IRRIGATION 2,011 7,000 4,989 71% 2215-436-460440-452 SAND & GRAVEL 659 1,500 841 56% 2215-436-460440-521 CENTRAL GARAGE TRANSFER 4,340 5,787 1,447 25% 2215-436-460440-545 COUNTY LANDFILL 3,389 3,400 11 0% ------------------------------------------------- SUBTOTAL ATHLETIC COMPLEX 153,368 264,545 111,177 42% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES-RECREATION 41,854 86,268 44,414 51% 2215-436-460431-111 SEASONAL SALARIES 12,518 12,306 212- -2% 2215-436-460431-121 OVERTIME 292 0 292- 0% 2215-436-460431-153 HEALTH INSURANCE 8,627 24,380 15,753 65% 2215-436-460431-155 RETIREMENT 3,387 7,789 4,402 57% 2215-436-460431-229 MISC. SUPPLIES 6,241 10,335 4,094 40% 2215-436-460431-231 GAS 71 600 529 88% 2215-436-460431-320 PRINTING & ADVERTISING 134 7,925 7,791 98% 2215-436-460431-345 TELEPHONE & COMMUNICATION 378 675 297 44% 2215-436-460431-354 CONTRACT SERVICES 4,831 37,828 32,997 87% 2215-436-460431-357 MUSIC FRANCHISE FEES 1,183 1,300 117 9% 2215-436-460431-373 DUES & TRAINING 229 800 571 71% ------------------------------------------------- SUBTOTAL RECREATION 79,743 190,206 110,463 58% THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 11 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING YOUTH CAMPS 2215-436-460448-110 SALARIES-YOUTH CAMPS 34,384 76,112 41,728 55% 2215-436-460448-111 SEASONAL SALARIES 88,694 143,522 54,828 38% 2215-436-460448-121 OVERTIME 40 150 110 74% 2215-436-460448-153 HEALTH INSURANCE 7,930 23,469 15,539 66% 2215-436-460448-155 RETIREMENT 2,783 7,029 4,246 60% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 162 250 88 35% 2215-436-460448-229 MISC. SUPPLIES 2,013 3,520 1,507 43% 2215-436-460448-231 GAS 0 200 200 100% 2215-436-460448-320 PRINTING & ADVERTISING 0 375 375 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 764 1,350 586 43% 2215-436-460448-354 CONTRACT SERVICES 3,758 13,154 9,396 71% 2215-436-460448-355 AFTER SCHOOL PROGRAM 74 1,200 1,126 94% 2215-436-460448-356 BANK FEES/CC CHARGES 2,282 4,500 2,218 49% 2215-436-460448-373 DUES & TRAINING 169 800 631 79% ------------------------------------------------- SUBTOTAL YOUTH CAMPS 143,051 275,631 132,580 48% POOL 2215-437-460445-111 SEASONAL SALARIES-POOL 147,945 170,081 22,136 13% 2215-437-460445-121 OVERTIME 493 200 293- -146% 2215-437-460445-155 RETIREMENT 265 1,500 1,235 82% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 317 500 183 37% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 436 2,000 1,564 78% 2215-437-460445-226 CHLORINE/CHEMICALS 28,387 40,000 11,613 29% 2215-437-460445-228 CONCESSION STAND SUPPLIES 7,870 21,000 13,130 63% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 475 4,000 3,525 88% 2215-437-460445-341 ELECTRICITY 6,926 9,500 2,574 27% 2215-437-460445-344 NATURAL GAS 644 25,000 24,356 97% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,263 2,500 1,237 49% 2215-437-460445-354 LICENSES & FEES 1,375 1,300 75- -6% 2215-437-460445-356 BANK FEES/ CC CHARGES 1,102 2,500 1,398 56% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 11,472 28,250 16,778 59% 2215-437-460445-380 TRAINING MATERIALS 380 1,800 1,420 79% ------------------------------------------------- SUBTOTAL POOL EXPENDITURES 209,350 310,131 100,781 33% ------------------------------------------------- TOTAL PARKS & RECREATION/POOL 1,084,512 1,855,213 770,701 42% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 12 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING URBAN FORESTRY 2600-436-460433-110 SALARIES-URBAN FORESTRY 126,008 199,567 73,559 37% 2600-436-460433-111 SEASONAL SERVICES 17,704 23,406 5,702 24% 2600-436-460433-121 OVERTIME 0 1,000 1,000 100% 2600-436-460433-153 HEALTH INSURANCE 28,545 54,259 25,714 47% 2600-436-460433-155 RETIREMENT 10,801 17,366 6,565 38% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 2,772 4,000 1,228 31% 2600-436-460433-231 GAS 2,716 8,000 5,284 66% 2600-436-460433-241 CONSUMABLE TOOLS 1,262 12,200 10,938 90% 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 515 660 145 22% 2600-436-460433-354 CONTRACT SERVICES 175,466 195,000 19,534 10% 2600-436-460433-357 FORESTRY GRANT 0 6,000 6,000 100% 2600-436-460433-358 EAB MONITORING/ARBOR DAY 0 4,000 4,000 100% 2600-436-460433-362 EQUIPMENT MAINTENANCE 987 4,000 3,013 75% 2600-436-460433-364 LANDSCAPING & TREES 2,347 8,000 5,653 71% 2600-436-460433-373 DUES & TRAINING 907 5,000 4,093 82% 2600-436-460433-388 MEDICAL 185 200 15 8% 2600-436-460433-395 EQUIPMENT RENTAL 9,498 9,500 2 0% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 4,136 4,137 2 0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 6,930 9,241 2,311 25% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 17,982 23,976 5,994 25% 2600-436-460433-528 INFORMATION TECHNOLOGY TRANSFER 5,712 7,617 1,905 25% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 17,147 17,146 1- 0% 2600-436-460433-620 INTEREST EXPENSE 376 582 206 35% 2600-436-460433-940 MACHINERY & EQUIPMENT 130,021 140,000 9,979 7% ------------------------------------------------- TOTAL URBAN FORESTRY 562,017 754,857 192,840 26% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 13 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2230 AMBULANCE FUND REVENUE: 2230-000-331992-000 CARES ACT REIMBURSEMENT THRU STATE 296,846 0 296,846- 0% 2230-000-342050-000 FEES FOR SERVICES 410,375 751,500 341,125 45% 2230-000-342070-000 COUNTY EMS LEVY 66,390 130,000 63,610 49% 2230-000-381050-000 INCEPTION OF LEASE 189,438 190,000 562 0% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 233,333 350,000 116,667 33% ------------------------------------------------- TOTAL AMBULANCE REVENUE 1,196,382 1,421,500 225,118 16% ================================================= AMBULANCE EXPENDITURES 2230-440-420730-110 SALARIES 462,883 724,099 261,216 36% 2230-440-420730-114 COMPTIME BUYBACK 0 3,500 3,500 100% 2230-440-420730-115 OUT OF RANK PAY 2,918 3,300 382 12% 2230-440-420730-121 OVERTIME 30,473 30,000 473- -2% 2230-440-420730-153 HEALTH INSURANCE 102,648 157,313 54,665 35% 2230-440-420730-155 RETIREMENT 59,230 94,245 35,015 37% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 1,356 3,400 2,044 60% 2230-440-420730-218 NON-CAPITAL EQUIPMENT 2,463 4,200 1,737 41% 2230-440-420730-231 GAS & OIL 2,823 7,560 4,737 63% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 1,006 4,000 2,994 75% 2230-440-420730-312 POSTAGE/PRINTING 0 1,000 1,000 100% 2230-440-420730-345 TELEPHONE & COMMUNICATION 752 1,700 948 56% 2230-440-420730-354 CONTRACT SERVICES 5,360 20,040 14,680 73% 2230-440-420730-355 911 CENTER CONTRIBUTION 19,124 38,247 19,124 50% 2230-440-420730-359 AUDIT/CC OTHER FEES 3,354 1,650 1,704- -103% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 4,005 5,000 995 20% 2230-440-420730-373 DUES & TRAINING 6,236 5,000 1,236- -25% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,500 2,500 100% 2230-440-420730-391 MEDICAL TREATMENT-SUPPLIES 49,550 51,241 1,691 3% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 11,530 11,530 0- 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 11,983 15,978 3,995 25% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 35,720 47,627 11,907 25% 2230-440-420730-528 INFORMATION TECHNOLOGY TRANSFER 22,850 30,466 7,616 25% 2230-440-420730-610 PRINCIPAL - AMBULANCE 0 19,000 19,000 100% 2230-440-420730-620 INTEREST - AMBULANCE 0 2,375 2,375 100% 2230-440-420730-940 EQUIPMENT 189,481 190,000 519 0% ------------------------------------------------- TOTAL AMBULANCE EXPENDITURES 1,025,744 1,474,971 449,227 30% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 14 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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 15,275 10,000 5,275- -53% 2399-000-341073-000 FIRE IMPACT FEES 185,708 150,000 35,708- -24% 2399-000-371010-000 INVESTMENT EARNINGS 7,997 13,000 5,003 38% ------------------------------------------------- TOTAL PS IMPACT FEE REV 208,980 173,000 35,980- -21% ================================================= PUBLIC SAFETY IMPACT FEE EXP 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 7,500 10,000 2,500 25% 2399-413-420140-610 PRINCIPAL - IMPOUND/STORAGE 0 5,000 5,000 100% 2399-413-420140-620 INTEREST - IMPOUND/STORAGE 0 2,000 2,000 100% 2399-413-420140-920 IMPOUND/STORAGE FACILITY 14,098 100,000 85,902 86% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 750,000 750,000 100% ------------------------------------------------- TOTAL PS IMPACT FEE EXP 21,598 867,000 845,402 98% ================================================= FIRE & HAZMAT GRANTS 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 19,023 10,000 9,023- -90% 2956-416-420415-940 AFG GRT FY20 SCBA 0 347,501 347,501 100% ------------------------------------------------- TOTAL FIRE GRANTS 19,023 357,501 338,478 95% ================================================= 2957-416-420400-221 DoMA EQUIP (REIMB) 16,954 0 16,954- 0% 2957-416-420410-125 PASS THRU HAZMAT OT 535 5,000 4,465 89% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 360 10,000 9,640 96% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 3,000 3,000 100% ------------------------------------------------- TOTAL HAZMAT GRANTS 17,850 18,000 150 1% ================================================= SAFER GRANT 2995-416-420400-110 SALARIES 0 66,500 66,500 100% 2995-416-420400-153 HEALTH INSURANCE 0 19,150 19,150 100% 2995-416-420400-155 RETIREMENT 0 9,550 9,550 100% ------------------------------------------------- TOTAL SAFER GRANT 0 95,200 95,200 100% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 15 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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 512,340 400,000 112,340- -28% 2394-000-323103-000 PLUMBING PERMITS 51,562 33,000 18,562- -56% 2394-000-323104-000 MECHANICAL PERMITS 51,095 35,000 16,095- -46% 2394-000-323105-000 ELECTRICAL PERMITS 73,967 58,000 15,967- -28% 2394-000-323108-000 PLAN REVIEW FEES 98,648 120,000 21,352 18% 2394-000-362015-000 INSURANCE REIMBURSEMENT 3,173 0 3,173- 0% 2394-000-371010-000 INVESTMENT EARNINGS 11,858 15,000 3,142 21% ------------------------------------------------- TOTAL REVENUE 802,643 756,200 46,443- -6% ================================================= BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES-BUILDING DEPT. 375,588 518,265 142,677 28% 2394-420-420530-112 SALARIES-SEVERANCE 0 23,993 23,993 100% 2394-420-420530-121 OVERTIME 6,378 20,000 13,622 68% 2394-420-420530-153 HEALTH INSURANCE 80,466 92,887 12,421 13% 2394-420-420530-155 RETIREMENT 29,866 39,716 9,850 25% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 24,326 22,000 2,326- -11% 2394-420-420530-231 GAS & OIL 1,797 4,000 2,203 55% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 1,050 6,000 4,950 82% 2394-420-420530-323 ST. ED. ASSESSMENTS 2,424 5,500 3,076 56% 2394-420-420530-345 TELEPHONE & COMMUNICATION 5,418 6,000 582 10% 2394-420-420530-353 AUDITING 4,500 4,500 0 0% 2394-420-420530-354 CONTRACT SERVICES 20,918 20,000 918- -5% 2394-420-420530-355 CITY WORKS LICENSING FEE 16,591 16,000 591- -4% 2394-420-420530-356 ArcGIS SERVER UPGRADE LICENSE 0 6,000 6,000 100% 2394-420-420530-357 CREDIT CARD / PAYPAL FEES 11,576 10,000 1,576- -16% 2394-420-420530-360 FURNITURE 0 7,500 7,500 100% 2394-420-420530-373 DUES & TRAINING 3,813 30,000 26,187 87% 2394-420-420530-510 PROPERTY INSURANCE 10,914 10,914 0- 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 1,927 2,569 642 25% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 23,616 31,612 7,996 25% 2394-420-420530-528 INFORMATION TECHNOLOGY TRANSFER 66,131 88,174 22,043 25% 2394-420-420530-920 BUILDING IMPROVEMENTS 73,945 199,190 125,245 63% ------------------------------------------------- TOTAL BUILDING DEPT. 761,244 1,164,820 403,576 35% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 16 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 55,515 92,780 37,265 40% 2400-410-430263-153 HEALTH INSURANCE 9,708 16,775 7,067 42% 2400-410-430263-155 RETIREMENT 4,314 7,138 2,824 40% 2400-410-430263-244 STREET LIGHT SUPPLIES 257 18,000 17,743 99% 2400-410-430263-245 LUMINAIRES 13,470 30,000 16,530 55% 2400-410-430263-246 LED LUMINAIRE UPGRADE 200 16,431 16,231 99% 2400-410-430263-341 ELECTRICITY 119,590 182,000 62,410 34% 2400-410-430263-360 REPAIR & MAINT SERVICES 7,171 21,500 14,329 67% 2400-410-430263-373 DUES & TRAINING 13 2,500 2,488 100% 2400-410-430263-510 INSURANCE 1,671 1,671 0 0% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 8,851 11,801 2,950 25% 2400-410-430263-528 INFORMATION TECH TRANSFER 7,832 10,443 2,611 25% ------------------------------------------------- TOTAL LIGHT MAINT. 228,592 411,039 182,447 44% ================================================= 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 82,034 131,071 49,037 37% 2420-421-430234-957 ALLEY PAVING 25,118 40,000 14,882 37% 2420-421-430240-231 GAS & OIL 14,460 42,000 27,540 66% 2420-421-430240-344 NATURAL GAS 2,554 6,800 4,246 62% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 100% 2420-421-430240-360 REPAIR & MAINT SERVICES 891 1,500 609 41% 2420-421-430240-368 OVERLAY/CHIPSEALS 0 435,642 435,642 100% 2420-421-430240-452 GRAVEL 1,420 5,000 3,580 72% 2420-421-430240-453 EQUIPMENT RENTAL 0 5,000 5,000 100% 2420-421-430240-471 DE-ICER/ROAD OIL 42,790 58,000 15,210 26% 2420-421-430240-472 ASPHALT 37,482 40,000 2,518 6% 2420-421-430240-473 CRACK SEALING 4,716 16,100 11,384 71% 2420-421-430240-474 PAINT STRIPING MATERIALS 3,408 30,000 26,592 89% ------------------------------------------------- TOTAL GAS TAX 214,872 831,113 616,241 74% ================================================= BARSAA (GAS TAX) 2421-421-430240-354 PAVEMENT MAINTENANCE 165,874 450,000 284,126 63% ------------------------------------------------- TOTAL BARSAA 165,874 450,000 284,126 63% ================================================= 2825 MACI GRANT 2825-421-430240-940 EQUIPMENT 0 242,814 242,814 100% ------------------------------------------------- TOTAL MACI GRANT 0 242,814 242,814 100% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 17 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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. 592,861 827,422 234,561 28% 2500-421-430240-121 OVERTIME 4,745 28,000 23,255 83% 2500-421-430240-153 HEALTH INSURANCE 130,571 196,448 65,877 34% 2500-421-430240-155 RETIREMENT 46,243 62,911 16,668 26% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 9,479 17,360 7,881 45% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 2,539 7,000 4,461 64% 2500-421-430240-220 OTHER SUPPLIES 3,581 4,500 919 20% 2500-421-430240-231 GAS & OIL 14,724 42,000 27,276 65% 2500-421-430240-341 ELECTRICITY 1,650 3,500 1,850 53% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 1,137 1,850 713 39% 2500-421-430240-354 CONTRACT SERVICES 4,726 22,500 17,774 79% 2500-421-430240-356 TRANSPORTATION PLAN 104,330 105,000 670 1% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 18,310 41,000 22,690 55% 2500-421-430240-366 BUILDING MAINTENANCE 3,097 5,000 1,903 38% 2500-421-430240-373 DUES & TRAINING 1,185 13,000 11,815 91% 2500-421-430240-388 MEDICAL SERVICES 310 1,000 690 69% 2500-421-430240-510 LIABILITY INSURANCE 43,437 43,437 0- 0% 2500-421-430240-512 UNINSURED LOSS-DEDUCTIBLE 24,065 45,000 20,935 47% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 161,041 214,721 53,680 25% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 69,988 93,317 23,329 25% 2500-421-430240-528 INFORMATION TECHNOLOGY TRANSFER 24,970 33,293 8,323 25% 2500-421-430240-840 MACI GRANT MATCH - WTR/DE-ICER TRK 0 15,000 15,000 100% 2500-421-430240-953 SHOP COMPLEX PAVEMENT RESTORATION 7,574 10,000 2,426 24% 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 12,709 25,649 12,940 50% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 6,782 13,404 6,622 49% 2500-421-430244-354 PAVEMENT REPAIRS-PAVEMENT MNT FUNDS 179,350 717,621 538,271 75% 2500-421-430244-820 TRANSFER TO BaRSAA 0 15,000 15,000 100% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 84,500 315,000 230,500 73% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 448 27,828 27,380 98% ------------------------------------------------- TOTAL STREET MAINT. 1,554,350 2,947,761 1,393,411 47% ------------------------------------------------- SIGNS AND SIGNALS 2500-421-430264-110 TSS - SALARIES 64,334 106,087 41,753 39% 2500-421-430264-121 OVERTIME 0 7,500 7,500 100% 2500-421-430264-153 HEALTH INSURANCE 19,293 32,050 12,757 40% 2500-421-430264-155 RETIREMENT 4,960 7,988 3,028 38% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 1,707 4,775 3,068 64% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 3,560 6,700 3,140 47% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 1,481 4,000 2,519 63% 2500-421-430264-242 STREET SIGNS 10,185 30,000 19,815 66% 2500-421-430264-243 TRAFFIC SIGNALS 18,630 32,459 13,829 43% 2500-421-430264-245 BARRICADE MATERIALS 1,681 6,000 4,319 72% 2500-421-430264-341 ELECTRICITY 1,317 3,000 1,683 56% 2500-421-430264-345 COMMUNICATIONS 737 850 113 13% 2500-421-430264-354 CONTRACT SERVICES 1,827 10,000 8,173 82% 2500-421-430264-362 EQUIPMENT MAINTENANCE 1,938 3,000 1,062 35% 2500-421-430264-366 BUILDING MAINTENANCE 0 5,000 5,000 100% 2500-421-430264-373 DUES & TRAINING 424 7,500 7,076 94% 2500-421-430264-428 PAINT MATERIALS 0 5,000 5,000 100% 2500-421-430264-510 LIABILITY INS.-TSS 2,768 2,768 0 0% THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 18 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500-421-430264-512 UNINSURED LOSS-DEDUCTIBLE 0 1,000 1,000 100% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 4,318 5,758 1,440 25% 2500-421-430264-940 MACHINERY & EQUIPMENT 4,377 6,000 1,623 27% ------------------------------------------------- TOTAL SIGNS AND SIGNALS 143,537 287,435 143,898 50% ------------------------------------------------- TOTAL STREET MAINT. & SIGNS 1,697,887 3,235,196 1,537,309 48% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 19 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2188 WESTSIDE TIF REVENUE 2188-000-311100-000 REAL PROPERTY TAXES 3,157 0 3,157- 0% 2188-000-312000-000 PEN & INTEREST DEL TAXES 202 0 202- 0% 2188-000-371010-000 INVESTMENT EARNINGS 2,245 0 2,245- 0% 2188-000-373010-000 INTEREST / LOANS 11,083 15,000 3,917 26% 2188-000-373020-000 PRINCIPAL / LOANS 13,874 18,000 4,126 23% 2188-000-381060-000 TRANSFER FROM GENERAL FUND 623,000 1,246,000 623,000 50% 2188-000-383001-000 TRANSFER FROM CD PROGRAMS (2886) 151,270 205,085 53,815 26% ------------------------------------------------- TOTAL REVENUE 804,831 1,484,085 679,254 46% ================================================= EXPENDITURES 2188-480-470230-110 SALARIES 35,189 48,475 13,286 27% 2188-480-470230-153 HEALTH INSURANCE 8,021 10,526 2,505 24% 2188-480-470230-155 RETIREMENT 2,867 3,846 979 25% 2188-480-470230-353 AUDIT 1,500 1,500 0 0% 2188-480-470230-356 TELEPHONE 144 192 48 25% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 1,596 2,127 531 25% 2188-480-470440-930 CITY MATCH - TRAIL 746,052 2,043,808 1,297,756 64% ------------------------------------------------- TOTAL WESTSIDE TIF 795,369 2,110,474 1,315,105 62% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 20 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2185 AIRPORT TIF 2185-000-430300-840 REDEVELOPMENT ACTIVITY 1,869,711 2,320,077 450,366 19% ------------------------------------------------- TOTAL 2185 AIRPORT TIF 1,869,711 2,320,077 450,366 19% ================================================= OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 9,500 9,500 100% 2310-480-470210-356 FED-EX REIMBURSEMENT 8,862 9,000 138 2% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 52,500 70,000 17,500 25% 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 3,750 5,000 1,250 25% ------------------------------------------------- TOTAL OLD SCHOOL TIFS 65,112 93,500 28,388 30% ================================================= GLACIER RAIL PARK TEDD 2312-480-470210-110 SALARIES & WAGES 16,676 22,869 6,193 27% 2312-480-470210-153 HEALTH INSURANCE 4,737 6,224 1,487 24% 2312-480-470210-155 RETIREMENT 1,359 1,808 449 25% 2312-480-470210-345 TELEPHONE 36 48 12 25% 2312-480-470210-353 AUDIT 1,500 1,500 0 0% 2312-480-470210-522 ADMINISTRATIVE TRANSFER 1,596 2,128 532 25% 2312-480-470210-790 REDEVELOPMENT 0 90,000 90,000 100% ------------------------------------------------- TOTAL GLACIER RAIL PARK TEDD 25,903 124,577 98,674 79% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 21 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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 580 1,000 420 42% 2880-480-470210-711 REDEVELOPMENT 0 225,000 225,000 100% ------------------------------------------------- TOTAL LOAN REVOLVING 1,580 227,000 225,420 99% ================================================= 2881 CD LOAN REV. #2 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 405 405 0 0% 2881-480-470210-711 REDEVELOPMENT 0 275,000 275,000 100% ------------------------------------------------- TOTAL 2881 CD REV. #2 405 275,405 275,000 100% ================================================= 2886 CD MISC. 2886-480-470210-353 AUDITING 1,000 1,000 0 0% 2886-480-470210-522 ADMINISTRATIVE TRANSFER 375 2,000 1,625 81% 2886-480-470210-528 INFORMATION TECH TRANSFER 11,425 15,233 3,808 25% 2886-480-470210-532 OFFICE RENT 0 646 646 100% 2886-480-470210-790 REDEVELOPMENT ACTIVITY 2,000 5,000 3,000 60% 2886-480-470210-810 TRANSFER TO WS TIF 151,270 205,085 53,815 26% 2886-480-470210-815 TRANSFER TO SID 344 DEBT SERVICE 75,000 100,000 25,000 25% ------------------------------------------------- TOTAL CD MISC. 241,070 328,964 87,894 27% ================================================= 2887 RURAL DEVELOPMENT #1 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 19,014 19,014 0- 0% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 3,060 3,060 0 0% 2887-480-470210-750 REDEVELOPMENT LOANS 728 150,000 149,272 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #1 22,802 172,074 149,272 87% ================================================= 2888 RURAL DEVELOPMENT #2 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 8,468 8,468 0 0% 2888-480-470210-620 INTEREST EXPENSE-USDA LOAN 61-03 1,557 1,557 0- 0% 2888-480-470210-750 REDEVELOPMENT LOANS 405 300,000 299,595 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #2 10,430 310,025 299,595 97% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 22 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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 99,406 109,561 10,155 9% 2953-480-470210-373 TRAVEL/PETROLEUM 0 1,429 1,429 100% 2953-480-470215-373 TRAVEL/HAZARDOUS 0 5,382 5,382 100% ------------------------------------------------- TOTAL EPA BROWNSFIELD 99,406 116,372 16,966 15% ================================================= 2955 BROWNFIELDS LOAN REV. 2955-480-470210-229 SUPPLIES-PETROLEUM 0 218,322 218,322 100% 2955-480-470210-725 REVOLVED FUNDS-PETROLEUM 0 100,500 100,500 100% 2955-480-470215-229 SUPPLIES-HAZARDOUS SUBSTANCES 0 267,673 267,673 100% ------------------------------------------------- TOTAL BROWNFIELDS LOAN REV. 0 586,495 586,495 100% ================================================= FY21 AIRPORT GRANT 2974-430-430310-934 CAPITAL IMPROVEMENTS - LIGHTS/FENCI 0 236,712 236,712 100% ------------------------------------------------- TOTAL 2974 FY21 AIRPORT GRANT 0 236,712 236,712 100% ================================================= 2991 TIGER GRANT 2991-480-470245-790 REDEVELOPMENT - TRAIL 0 3,803,909 3,803,909 100% ------------------------------------------------- TOTAL TIGER GRANT 0 4,040,621 4,040,621 100% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 23 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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 0 10,000 10,000 100% 2915-413-420140-218 SMALL EQUIP -Stonegarden 0 30,000 30,000 100% ------------------------------------------------- TOTAL 2915 STONEGARDEN GRANT 0 40,000 40,000 100% ================================================= 2916 DRUG ENFORECMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 46,051 69,526 23,475 34% 2916-413-420140-121 OVERTIME 7,219 13,000 5,781 44% 2916-413-420140-153 HEALTH INSURANCE 9,006 12,889 3,883 30% 2916-413-420140-155 RETIREMENT 6,044 9,348 3,304 35% ------------------------------------------------- TOTAL 2916 DRUG ENFORCEMENT 68,320 104,763 36,443 35% ================================================= 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 737 4,000 3,263 82% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 6,229 35,000 28,771 82% 2919-413-420140-127 SCHOOL DIST. OT 6,122 20,000 13,878 69% 2919-413-420140-218 JAG GRT/BODY ARMOR & BODY WORN CAME 5,050 15,461 10,411 67% 2919-413-420140-219 EQUIPMENT FROM CORONAVIRUS GRANT 32,009 33,119 1,110 3% 2919-413-420140-220 EQUIPMENT-FUNDED BY DONATIONS 0 4,000 4,000 100% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 6,000 6,000 0 0% ------------------------------------------------- TOTAL LAW ENF. GRANT 56,147 117,580 61,433 52% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 24 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CAPITAL PROJECT FUNDS 4170 IMPOUND/STORAGE FACILITY 4170-400-411230-925 IMPOUND/STORAGE FACILITY 0 178,520 178,520 100% ------------------------------------------------- TOTAL IMPOUND/STORAGE FACILITY 0 178,520 178,520 100% 4290 WALK & CURB 4290-410-430234-937 CONSTRUCTION 4,046 25,000 20,954 84% ------------------------------------------------- TOTAL 4290 WALK & CURB 4,046 203,520 199,474 98% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 25 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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 1,170 2,000 830 42% 5210-000-343210-000 METERED WATER SALES 2,868,606 3,319,443 450,837 14% 5210-000-343220-000 OTHER (CONST.) WATER SALES 22,383 25,000 2,617 10% 5210-000-343230-000 METER REPLACEMENT FEE 106,990 136,000 29,010 21% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 72,039 51,500 20,539- -40% 5210-000-343270-000 WATER TURN ON FEES 3,185 5,000 1,815 36% 5210-000-343275-000 TAG FEE 26,120 33,000 6,880 21% 5210-000-343365-000 LATECOMER ADMIN FEE 11,403 10,000 1,403- -14% 5210-000-371010-000 INVESTMENT EARNINGS 65,356 78,000 12,644 16% 5210-000-383010-000 TRANSFER FROM IMPACT FEE FUND (ADMI 13,125 17,500 4,375 25% 5210-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 100,000 200,000 100,000 50% ------------------------------------------------- TOTAL WATER REVENUE 3,290,377 3,877,443 587,066 15% ================================================= WATER FACILITIES 5210-447-430550-110 SALARIES-WATER 466,590 788,169 321,579 41% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 4,903 20,000 15,097 75% 5210-447-430550-153 HEALTH INSURANCE 105,958 173,129 67,171 39% 5210-447-430550-155 RETIREMENT 36,672 60,134 23,462 39% 5210-447-430550-210 OFFICE SUPPLIES /EQUIP/COMPUTERS/GI 9,569 23,000 13,431 58% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 5,358 9,000 3,642 40% 5210-447-430550-226 CHLORINE & CHEMICALS 24,813 39,000 14,187 36% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 2,484 4,500 2,016 45% 5210-447-430550-231 GAS & OIL 13,963 35,000 21,037 60% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 952 1,000 48 5% 5210-447-430550-336 LICENSES & FEES 16,784 19,500 2,716 14% 5210-447-430550-341 ELECTRICITY 116,210 160,000 43,790 27% 5210-447-430550-344 NATURAL GAS 6,701 15,500 8,799 57% 5210-447-430550-345 TELEPHONE & COMMUNICATION 8,623 12,000 3,377 28% 5210-447-430550-349 LAB SERVICES 14,751 20,000 5,249 26% 5210-447-430550-353 AUDITING 3,500 3,500 0 0% 5210-447-430550-354 CONTRACT SERVICES 15,426 55,000 39,574 72% 5210-447-430550-355 NOFFSINGER TRANSMISSION CONDITION A 0 260,500 260,500 100% 5210-447-430550-356 BACKBONE CONDITION ASSESS./WTR RIGH 10,087 205,500 195,413 95% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 1,666 15,000 13,334 89% 5210-447-430550-366 BUILDING MAINTENANCE 2,673 35,000 32,327 92% 5210-447-430550-373 DUES & TRAINING 1,458 13,000 11,542 89% 5210-447-430550-388 MEDICAL SERVICES 83 700 618 88% 5210-447-430550-410 CONSTRUCTION MATERIALS 20,114 35,000 14,886 43% 5210-447-430550-422 HYDRANTS 4,498 10,000 5,502 55% 5210-447-430550-423 MATERIALS FOR MAINS 1,177 14,000 12,823 92% 5210-447-430550-424 MATERIALS -SERVICE LINES 5,499 12,000 6,501 54% 5210-447-430550-425 MATERIALS PUMPS/WELLS 25,925 45,000 19,075 42% 5210-447-430550-426 METERS FM METER CASH (10125) 45,855 50,679 4,824 10% 5210-447-430550-510 PROPERTY & LIABILITY INS. 40,980 40,980 0- 0% 5210-447-430550-512 UNINSURED LOSS-DEDUCTIBLE 4,029 10,000 5,971 60% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 27,206 36,275 9,069 25% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 78,503 104,671 26,168 25% 5210-447-430550-528 INFORMATION TECH TRANSFER 50,537 67,382 16,845 25% 5210-447-430550-532 LEASE PAYMENTS 0 4,000 4,000 100% THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 26 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-925 NOFFSINGER REHAB ALTERNATIVE 0 520,000 520,000 100% 5210-447-430550-935 METER SYSTEM REPLACEMENT 0 317,000 317,000 100% 5210-447-430550-950 1ST AVE WN MAIN REPLACEMENT 414 30,000 29,586 99% 5210-447-430550-951 SECURITY SCADA UPGRADES 174,233 305,000 130,767 43% 5210-447-430550-953 SHOP COMPLEX PAVEMENT RESTORATION 7,574 10,000 2,426 24% 5210-447-430550-954 ELEVATED STORAGE TANK & WELL 0 8,270,000 8,270,000 100% 5210-447-430550-958 2ND AVE W RR FROM CENTER TO 2ND ST 659 442,000 441,341 100% 5210-447-430550-971 10TH AVE W & 2ND ST W R&R 345,710 431,380 85,670 20% ------------------------------------------------- SUBTOTAL WATER FACILITIES 1,702,138 12,728,499 11,026,361 87% ------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES-WATER BILLING 90,161 121,093 30,932 26% 5210-447-430560-153 HEALTH INSURANCE 30,186 39,753 9,567 24% 5210-447-430560-155 RETIREMENT 7,290 9,596 2,306 24% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 4,243 9,000 4,757 53% 5210-447-430560-353 AUDITING 2,000 2,000 0 0% 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 32,665 40,000 7,335 18% 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 17,597 27,000 9,403 35% 5210-447-430560-356 OTHER CONTRACT SERVICES 60 1,000 940 94% 5210-447-430560-373 DUES & TRAINING 196 3,000 2,804 93% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 8,542 11,390 2,848 25% 5210-447-430560-528 INFORMATION TECH TRANSFER 39,987 53,316 13,329 25% ------------------------------------------------- SUBTOTAL WATER BILLING 232,927 317,148 84,221 27% ------------------------------------------------- REVENUE BONDS 5210-447-490200-610 PRIN - 4 MILE DR TRANSMISSION / WRF 0 90,000 90,000 100% 5210-447-490200-620 INT - 4 MILE DR TRANSMISSION / WRF 64,888 55,000 9,888- -18% 5210-447-490204-610 BOND PRIN-HWY 93 S WTR - 2004 0 79,000 79,000 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 7,704 7,704 0 0% 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 350 350 0 0% 5210-447-490206-610 PRIN-WELL/TANK/8114 2.25% 4TH ST 0 91,000 91,000 100% 5210-447-490206-620 INT-WELL&TANK/8114 2.25% 4TH ST WT 14,816 14,816 0- 0% 5210-447-490210-610 4TH AVE E MAIN REPL/WRF 17393 0 82,352 82,352 100% 5210-447-490210-620 4TH AVE E MAIN REPL/WFR 17393 43,040 43,040 0- 0% 5210-447-490250-610 PRIN-WTR MAIN/WRF 1032R 2%/IDAHO&MA 0 26,000 26,000 100% 5210-447-490250-620 INT-WTR MAIN/WRF1032R 2%/IDAHO&MAIN 260 260 0 0% ------------------------------------------------- SUBTOTAL REVENUE BONDS 131,058 489,522 358,465 73% ------------------------------------------------- DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 950,000 950,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 950,000 950,000 100% ------------------------------------------------- TOTAL WATER FUND 2,066,122 14,485,169 12,419,047 86% ================================================= WATER IMPACT FEE REVENUE: THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 27 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5211-000-343225-000 IMPACT FEES 530,513 350,000 180,513- -52% 5211-000-371010-000 INTEREST EARNINGS 8,727 12,000 3,273 27% ------------------------------------------------- TOTAL WATER IMPACT FEES REVENU 539,240 362,000 177,240- -49% ================================================= WATER IMPACT FEES EXPENSES: 5211-447-430555-424 METERS - NEW DEVELOPMENT 38,835 54,000 15,165 28% 5211-447-430555-820 DEBT SERVICE TRANSFER TO 5210 100,000 200,000 100,000 50% 5211-447-430555-825 TRANSFER TO 5210 FOR ADMIN 13,125 17,500 4,375 25% 5211-447-430555-930 CONTRACT MAIN UPSIZE 202,273 515,000 312,727 61% 5211-447-430555-954 ELEVATED TANK & WELL 95,077 448,000 352,923 79% ------------------------------------------------- TOTAL WATER IMPACT FEE EXPENSE 449,310 1,234,500 785,190 64% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 28 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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 1,170 2,000 830 42% 5310-000-343310-000 SEWER SERVICE CHARGES 4,512,840 5,991,963 1,479,123 25% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 19,779 14,000 5,779- -41% 5310-000-343365-000 LATECOMER ADMIN FEES 6,650 5,000 1,650- -33% 5310-000-371010-000 INVESTMENT EARNINGS 41,430 60,000 18,570 31% 5310-000-383010-000 ADMIN TRANSFER FROM IMPACT FEE FUND 25,050 33,400 8,350 25% 5310-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 431,250 900,000 468,750 52% ------------------------------------------------- TOTAL SEWER REVENUE 5,038,169 7,006,363 1,968,194 28% ================================================= SANITARY SEWER EXPENSES: SEWER BILLING COSTS 5310-454-430620-110 SALARIES-SEWER BILLING 77,000 102,807 25,807 25% 5310-454-430620-153 HEALTH INSURANCE 22,897 29,810 6,913 23% 5310-454-430620-155 RETIREMENT - PERD 6,212 8,127 1,915 24% 5310-454-430620-215 OFFICE SUPPLIES/computers 4,243 9,000 4,757 53% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 2,000 2,000 0 0% 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 32,665 40,000 7,335 18% 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 17,597 27,000 9,403 35% 5310-454-430620-356 OTHER CONTRACT SERVICES 60 1,000 940 94% 5310-454-430620-373 DUES & TRAINING 196 3,000 2,804 93% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 7,794 10,391 2,597 25% 5310-454-430620-528 INFORMATION TECH. TRANSFER 39,987 53,316 13,329 25% ------------------------------------------------- SUBTOTAL SEWER BILLING COSTS 210,651 286,451 75,800 26% ------------------------------------------------- SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES-SANITARY SEWER 200,349 308,061 107,713 35% 5310-454-430630-121 OVERTIME 15 5,500 5,485 100% 5310-454-430630-153 HEALTH INSURANCE 48,104 81,790 33,686 41% 5310-454-430630-155 RETIREMENT 15,643 23,625 7,982 34% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 7,287 13,200 5,913 45% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 2,739 13,350 10,611 79% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 1,225 2,300 1,075 47% 5310-454-430630-231 GAS & OIL 4,817 12,000 7,183 60% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 57 500 443 89% 5310-454-430630-341 ELECTRICITY 37,808 57,000 19,192 34% 5310-454-430630-344 NATURAL GAS 10,115 16,500 6,385 39% 5310-454-430630-345 TELEPHONE & COMMUNICATION 16,984 26,500 9,516 36% 5310-454-430630-353 AUDITING 3,000 3,000 0 0% 5310-454-430630-354 CONTRACT SERVICES 20,022 25,000 4,978 20% 5310-454-430630-356 CONSULTANTS - MODELING/RATE STUDY 12,262 15,000 2,738 18% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 5,942 16,875 10,933 65% 5310-454-430630-373 DUES & TRAINING 500 9,250 8,750 95% 5310-454-430630-388 MEDICAL SERVICES 367 500 134 27% 5310-454-430630-410 CONSTRUCTION MATERIALS 1,662 10,000 8,338 83% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 29,411 70,000 40,589 58% 5310-454-430630-510 PROPERTY & LIABILITY INS. 58,040 58,040 0- 0% 5310-454-430630-512 UNINSURED LOSS-DEDUCTIBLE 0 25,000 25,000 100% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 8,553 11,404 2,851 25% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 38,468 51,291 12,823 25% THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 29 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-528 INFORMATION TECH TRANSFER 33,399 44,532 11,133 25% 5310-454-430630-532 OFFICE RENT / BNSF LEASE 6,689 0 6,689- 0% 5310-454-430630-922 L.S. #9 IMPROVEMENTS/DESIGN 2,888 250,000 247,113 99% 5310-454-430630-940 MACHINERY & EQUIPMENT 31,107 245,000 213,893 87% 5310-454-430630-948 REPAIR & REPLC OF SEWER MAIN 458,336 599,430 141,094 24% 5310-454-430630-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 57,800 57,800 100% 5310-454-430630-953 SHOP COMPLEX PAVEMENT RESTORATION 7,574 10,000 2,426 24% 5310-454-430630-954 MN REPL. DESIGN - 1ST & 2ND AVE EN 0 121,000 121,000 100% 5310-454-430630-957 WEST SIDE INTERCEPTOR (BONDED) 773,022 2,579,648 1,806,626 70% 5310-454-430630-959 L.S. 5a REMOVAL 0 335,000 335,000 100% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 13,425 50,000 36,575 73% 5310-454-430630-961 6TH ALLEY E - S OF 14TH & 13TH 0 263,000 263,000 100% 5310-454-430630-962 SEWER MAIN SLIP LINING 237,918 395,000 157,082 40% ------------------------------------------------- SUBTOTAL SEWER COLLECTION 2,087,726 5,806,096 3,718,370 64% ------------------------------------------------- REVENUE BONDS/SANITARY 5310-454-490200-610 PRINCIPAL WESTSIDE INTERCEPTOR BOND 0 334,000 334,000 100% 5310-454-490200-620 INTEREST-WESTSIDE INTERCEPTOR BOND 331,825 270,000 61,825- -23% 5310-454-490200-630 FISCAL AGENT FEE-WESTSIDE INTERCEPT 0 350 350 100% 5310-454-490204-610 PRINCIPAL - HWY 93 S/SRF5125/2.25% 0 89,000 89,000 100% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 7,740 7,741 1 0% 5310-454-490204-630 FEES-HWY 93 S/SRF5125/2.25% 0 350 350 100% ------------------------------------------------- SUBTOTAL REVENUE BONDS 339,565 701,441 361,876 52% ------------------------------------------------- DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 500,000 500,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION-SANITARY 0 500,000 500,000 100% ------------------------------------------------- SUBTOTAL SANITARY SEWER 2,427,291 7,007,537 4,580,246 65% ------------------------------------------------- WWTP/OPERATIONS 5310-455-430640-110 SALARIES-WWTP 338,840 468,577 129,737 28% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-121 OVERTIME 14,641 22,500 7,859 35% 5310-455-430640-153 HEALTH INSURANCE 68,332 97,675 29,343 30% 5310-455-430640-155 RETIREMENT 27,731 35,640 7,909 22% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 7,350 11,500 4,150 36% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 2,687 3,000 313 10% 5310-455-430640-225 ALUM 7,058 43,500 36,442 84% 5310-455-430640-226 CHLORINE & CHEMICALS 77,065 111,000 33,935 31% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 6,695 7,000 305 4% 5310-455-430640-231 GAS & OIL 7,099 19,000 11,901 63% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 55 550 495 90% 5310-455-430640-336 LICENSES & FEES 7,208 14,000 6,792 49% 5310-455-430640-341 ELECTRICITY 144,508 193,000 48,492 25% 5310-455-430640-342 WATER 2,431 7,500 5,069 68% 5310-455-430640-344 NATURAL GAS 33,776 82,000 48,224 59% THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 30 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-345 TELEPHONE & COMMUNICATION 4,958 12,050 7,092 59% 5310-455-430640-353 AUDITING 2,500 2,500 0 0% 5310-455-430640-354 CONTRACT-GLACIER GOLD 76,888 135,000 58,112 43% 5310-455-430640-355 CONTRACT - LAND FILL & OTHER 32,999 49,000 16,001 33% 5310-455-430640-356 CONSULTANTS 139,645 267,000 127,355 48% 5310-455-430640-358 CONSULTANT- PERMIT/RATE STDY/TMDL 5,357 145,000 139,643 96% 5310-455-430640-360 MISC. MAINT SERVICES 22,994 30,000 7,006 23% 5310-455-430640-366 BUILDING MAINTENANCE 12,319 51,000 38,681 76% 5310-455-430640-373 DUES & TRAINING 1,255 9,500 8,245 87% 5310-455-430640-388 MEDICAL SERVICES 165 500 335 67% 5310-455-430640-510 PROPERTY & LIABILITY INS. 49,256 49,256 0 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 15,332 20,443 5,111 25% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 89,936 119,914 29,978 25% 5310-455-430640-528 INFORMATION TECH TRANSFER 28,562 38,083 9,521 25% 5310-455-430640-921 DESIGN-DOME FOR SECONDARY CLARIFIER 0 403,000 403,000 100% 5310-455-430640-930 BIOSOLIDS ALTERNATE DISPOSAL ENG 0 178,052 178,052 100% 5310-455-430640-933 NEW EQ BASIN 0 2,400,000 2,400,000 100% ------------------------------------------------- SUBTOTAL WWTP OPERATIONS 1,227,640 5,031,740 3,804,100 76% ------------------------------------------------- WWTP REPLACEMENT 5310-455-430645-362 EQUIPMENT MAINTENANCE 113,412 193,000 79,588 41% 5310-455-430645-934 SECONDARY DIGESTER LID REPLC 20,531 41,766 21,235 51% 5310-455-430645-940 MACHINERY & EQUIPMENT 104,027 324,000 219,973 68% 5310-455-430645-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 75,480 75,480 100% ------------------------------------------------- SUBTOTAL WWTP REPLACEMENT 237,969 634,246 396,277 62% ------------------------------------------------- WWTP LAB OPERATIONS 5310-455-430646-110 SALARIES-WWTP LAB 86,288 119,920 33,632 28% 5310-455-430646-153 HEALTH INSURANCE 13,950 18,222 4,272 23% 5310-455-430646-155 RETIREMENT 6,739 9,044 2,305 25% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 2,379 6,000 3,621 60% 5310-455-430646-218 NON-CAPITAL EQUIPMENT 11,436 13,500 2,064 15% 5310-455-430646-222 LAB SUPPLIES 11,379 16,500 5,121 31% 5310-455-430646-349 LAB SERVICES 12,820 15,000 2,180 15% 5310-455-430646-350 PRETREATMENT SERVICE 4,944 15,000 10,056 67% 5310-455-430646-362 EQUIPMENT MAINTENANCE 3,300 5,500 2,200 40% 5310-455-430646-373 DUES & TRAINING 344 5,000 4,656 93% 5310-455-430646-940 EQUIPMENT - ANALYZER 43,347 47,000 3,653 8% ------------------------------------------------- SUBTOTAL WWTP LAB OPERATIONS 196,927 270,686 73,759 27% DEBT SERVICE - WWTP 5310-455-490227-610 PRINCIPAL - WWTP IMP/SRF8164R/2.25% 0 871,000 871,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 141,896 141,897 1 0% 5310-455-490228-610 PRINC - WWTP DIGESTER LID/SRF 13326 0 50,000 50,000 100% 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 23,055 23,055 0 0% ------------------------------------------------- SUBTOTAL DEBT SERVICE - WWTP 164,951 1,085,952 921,001 85% ------------------------------------------------- DEPRECIATION/REPL. - WWTP THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 31 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-510400-831 DEPR. EXP. - WWTP (INCLUDES 010125 0 1,250,000 1,250,000 100% ------------------------------------------------- SUTOTAL WWTP DEPRECIATION/REPL 0 1,250,000 1,250,000 100% ------------------------------------------------- SUBTOTAL WWTP 1,827,487 8,272,624 6,445,137 78% ------------------------------------------------- TOTAL BILLING/SANITARY/WWTP 4,465,429 15,566,612 11,101,183 71% ================================================= SEWER IMPACT FEE REVENUE 5311-000-343330-000 SANITARY IMPACT FEES 941,770 460,000 481,770- -105% 5311-000-343335-000 TREATMENT IMPACT FEES 570,775 208,000 362,775- -174% 5311-000-371010-000 SANITARY INTEREST EARNINGS 14,681 18,000 3,319 18% 5311-000-371015-000 TREATMENT INTEREST EARNINGS 13,287 14,400 1,113 8% ------------------------------------------------- TOTAL SEWER IMPACT FEES REVENU 1,540,513 700,400 840,113- -120% ================================================= SEWER IMPACT FEE EXPENSES 5311-454-430635-820 TRANSFER TO 5310 FOR DEBT (SANITARY 318,750 675,000 356,250 53% 5311-454-430635-825 TRANSFER TO 5310 FOR ADMIN 17,250 23,000 5,750 25% 5311-454-430635-950 RR & UPSIZE - WWTP MAIN (66% - 34% 0 112,200 112,200 100% 5311-454-430635-955 MAIN & L.S. UPSIZE 37,469 400,000 362,531 91% 5311-454-430635-957 WEST SIDE INTERCEPTOR PH. 1 42,600 86,692 44,092 51% 5311-455-430644-820 TRANSFER TO 5310 FOR DEBT 112,500 225,000 112,500 50% 5311-455-430644-825 TRANSFER TO 5310 FOR ADMIN 7,800 10,400 2,600 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% 5311-455-430644-950 RR & UPSIZE - WWTP MAIN (66% - 34% 0 146,520 146,520 100% ------------------------------------------------- TOTAL SEWER IMPACT FEE EXPENSE 536,369 2,262,449 1,726,080 76% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 32 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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 1,170 1,000 170- -17% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 2,990 1,500 1,490- -99% 5349-000-343034-000 PERMIT FEES 4,053 1,000 3,053- -305% 5349-000-343035-000 STORM SEWER CHARGES 2,682 1,800 882- -49% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 1,791,924 1,767,772 24,152- -1% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 2,535 2,500 35- -1% 5349-000-365000-000 DONATIONS & STRM SWR CLASS 120 0 120- 0% 5349-000-371010-000 INTEREST ON INVESTMENTS 20,369 25,000 4,631 19% 5349-000-383010-000 IMPACT FEE 5% ADMIN - TFR FROM IMPA 4,500 6,000 1,500 25% 5349-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 40,000 150,000 110,000 73% ------------------------------------------------- TOTAL STORM REVENUE 1,870,343 1,956,572 86,229 4% ================================================= STORM SEWER 5349-453-430246-110 SALARIES-STORM SEWER 320,429 493,494 173,065 35% 5349-453-430246-121 OVERTIME 35 4,000 3,965 99% 5349-453-430246-153 HEALTH INSURANCE 73,459 111,722 38,263 34% 5349-453-430246-155 RETIREMENT 25,159 37,805 12,646 33% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 11,061 17,100 6,039 35% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 1,749 11,000 9,251 84% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 45 2,200 2,155 98% 5349-453-430246-231 GAS & OIL 4,551 11,500 6,949 60% 5349-453-430246-345 TELEPHONE & COMMUNICATION 1,774 2,500 726 29% 5349-453-430246-353 AUDITING 1,150 1,150 0 0% 5349-453-430246-354 CONTRACT SERVICE 5,979 7,000 1,021 15% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 22,374 135,000 112,626 83% 5349-453-430246-358 CONSULTANTS 991 10,000 9,009 90% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 0 30,000 30,000 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 1,328 8,000 6,673 83% 5349-453-430246-362 GROUNDWATER MONITORING 0 6,500 6,500 100% 5349-453-430246-371 CURB & GUTTER 571 21,000 20,429 97% 5349-453-430246-373 DUES & TRAINING 531 9,250 8,719 94% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 2,682 10,000 7,318 73% 5349-453-430246-510 PROPERTY & LIABILITY INS. 11,917 16,917 5,000 30% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 8,553 11,404 2,851 25% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 34,470 45,960 11,490 25% 5349-453-430246-528 INFORMATION TECH TRANSFER 30,682 40,909 10,227 25% 5349-453-430246-530 BNSF LEASE PMT 4,685 5,000 315 6% 5349-453-430246-968 RR W CENTER-7TH AVE W TO MERIDIAN 0 372,000 372,000 100% 5349-453-430246-970 REG. FACILITIES & PIPING DESIGN (BO 0 3,500,000 3,500,000 100% 5349-453-430247-952 STORM DRAIN CORRECTION (NEW & C/O) 128,798 200,000 71,202 36% 5349-453-430247-953 SHOP COMPLEX PAVEMENT (C/O) 7,574 10,000 2,426 24% 5349-453-430247-954 N. MAIN ST STORMWATER PROJ. 0 252,500 252,500 100% 5349-453-430247-956 WYOMING ST OUTFALL 0 225,000 225,000 100% 5349-453-430247-959 REGIONAL FACILITIES & PIPING DESIGN 7,670 400,000 392,330 98% 5349-453-430247-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% 5349-453-430247-968 RR W CENTER-7TH AVE W TO MERIDIAN 0 300,000 300,000 100% 5349-453-430249-940 MACHINERY FROM REPLACEMENT 31,107 245,000 213,893 87% ------------------------------------------------- SUBTOTAL STORM OPERATIONS 739,325 6,604,011 5,864,686 89% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 33 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM BONDS/LOANS 5349-453-490200-610 PRINCIPAL - 4TH AVE E BOND 0 2,999 2,999 100% 5349-453-490200-620 INTEREST-4TH AVE E BOND 1,568 1,568 1 0% 5349-453-490225-610 PRINCIPAL - REGIONAL FACILITIES 0 144,030 144,030 100% 5349-453-490225-620 INTEREST - REGIONAL FACILITIES 0 91,402 91,402 100% ------------------------------------------------- SUBTOTAL STORM BONDS/LOANS 1,568 239,999 238,432 99% ------------------------------------------------- DEPRECIATION 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 360,000 360,000 100% ------------------------------------------------- SUBTOTAL DEPRECIATION 0 360,000 360,000 100% ------------------------------------------------- TOTAL STORM EXPENSE 740,892 7,204,010 6,463,118 90% ================================================= STORM SEWER IMPACT FEE REVENUE 5348-000-343033-000 IMPACT FEES 206,412 120,000 86,412- -72% 5348-000-371010-000 INTEREST EARNINGS 12,000 15,000 3,000 20% ------------------------------------------------- TOTAL STORM IMPACT FEES REVENU 218,412 135,000 83,412- -62% ================================================= STORM SWR IMPACT FEE EXPENSES 5348-453-430248-820 DEBT SERVICE TRANSFER TO 5349 40,000 150,000 110,000 73% 5348-453-430248-825 TRANSFER TO 5349 FOR ADMIN 4,500 6,000 1,500 25% 5348-453-430248-959 REG FACILITIES & PIPING DESIGN 205,793 1,450,908 1,245,115 86% 5348-453-430248-960 STORMWATER FACILITY UPSIZING (CARRY 0 230,000 230,000 100% 5348-453-430248-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% ------------------------------------------------- TOTAL STORM IMPACT FEE EXPENSE 250,293 1,886,908 1,636,615 87% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 34 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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 5,090 2,500 2,590- -104% 5510-000-343410-000 GARBAGE COLLECTION-ASSESSED 1,062,680 1,035,000 27,680- -3% 5510-000-343420-000 GARBAGE COLLECTION-NOT ASSESSED 25,164 23,000 2,164- -9% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,775 2,000 225 11% 5510-000-371010-000 INVESTMENT EARNINGS 8,423 10,800 2,377 22% ------------------------------------------------- TOTAL SOLID WASTE REVENUE 1,103,133 1,073,300 29,833- -3% ================================================= SOLID WASTE EXPENSES: 5510-460-430840-110 SALARIES-SOLID WASTE 300,392 442,363 141,971 32% 5510-460-430840-121 OVERTIME 4,865 6,500 1,635 25% 5510-460-430840-153 HEALTH INSURANCE 70,620 108,766 38,146 35% 5510-460-430840-155 RETIREMENT 23,660 33,664 10,004 30% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 10,391 15,500 5,109 33% 5510-460-430840-218 EQUIPMENT-GARBAGE CONTAINERS 17,306 37,500 20,194 54% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 3,423 5,500 2,077 38% 5510-460-430840-231 GAS & OIL 25,034 60,000 34,966 58% 5510-460-430840-341 ELECTRICITY 1,268 2,050 782 38% 5510-460-430840-344 NATURAL GAS 1,786 4,500 2,714 60% 5510-460-430840-345 TELEPHONE & COMMUNICATION 1,430 2,000 570 29% 5510-460-430840-354 CONTRACT SERVICES 4,163 22,000 17,837 81% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 1,201 5,700 4,499 79% 5510-460-430840-366 BUILDING MAINTENANCE 1,777 5,000 3,223 64% 5510-460-430840-373 DUES & TRAINING 77 7,000 6,923 99% 5510-460-430840-388 MEDICAL SERVICES 110 700 590 84% 5510-460-430840-510 PROPERTY & LIABILITY INS. 20,507 20,507 0 0% 5510-460-430840-512 UNINSURED LOSS-DEDUCTIBLE 0 4,000 4,000 100% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 66,488 88,650 22,162 25% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 31,179 41,572 10,393 25% 5510-460-430840-528 INFORMATION TECH TRANSFER 24,970 33,293 8,323 25% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 30,000 40,000 10,000 25% 5510-460-430840-944 VEHICLES (Replacement $) 495,630 585,000 89,370 15% 5510-460-430840-953 SHOP COMPLEX PAVEMENT RESTORATION 7,574 10,000 2,426 24% 5510-460-430845-224 JANITORIAL SUPPLIES 0 500 500 100% 5510-460-430845-341 ELECTRICITY 1,020 3,500 2,480 71% 5510-460-430845-342 WATER 377 2,000 1,623 81% 5510-460-430845-344 NATURAL GAS 2,554 6,000 3,446 57% 5510-460-430845-360 REPAIR & MAINT SERVICES 8,067 17,000 8,933 53% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% ------------------------------------------------- TOTAL SOLID WASTE EXPENSE 1,155,868 1,760,765 604,897 34% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 35 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 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 252,000 336,000 84,000 25% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 131,827 210,000 78,173 37% 6030-000-371010-000 INVESTMENT EARNINGS 1,200 1,000 200- -20% 6030-000-393000-000 INTERNAL SERVICES-DATA 398,469 531,292 132,823 25% ------------------------------------------------- TOTAL INFORMATION TECH REVENUE 783,497 1,078,292 294,795 27% ================================================= INFORMATION TECH EXPENSES 6030-401-410580-110 SALARIES 251,087 366,388 115,301 31% 6030-401-410580-121 OVERTIME 42 1,000 958 96% 6030-401-410580-153 HEALTH INSURANCE 59,385 88,484 29,099 33% 6030-401-410580-155 RETIREMENT 20,380 29,474 9,094 31% 6030-401-410588-218 COMPUTERS - ADMINISTRATIVE DEPTS 4,064 5,310 1,246 23% 6030-403-410580-215 COMPUTER SUPPLIES 592 2,865 2,273 79% 6030-403-410580-218 EQUIPMENT-NOT CAPITAL 14,477 34,295 19,818 58% 6030-403-410580-325 WEBSITE 5,788 6,670 882 13% 6030-403-410580-345 PAGER/PHONE 14 2,800 2,786 100% 6030-403-410580-346 SUMMITNET & ISPS 7,551 14,028 6,477 46% 6030-403-410580-353 LASER FICHE MAINTENANCE 3,597 5,220 1,623 31% 6030-403-410580-354 MAINTENANCE CONTRACTS 4,937 65,100 60,163 92% 6030-403-410580-355 LICENSES 10,066 19,950 9,884 50% 6030-403-410580-356 MAINTENANCE CONTRACTS 92,014 86,350 5,664- -7% 6030-403-410580-357 GRANICUS 5,393 5,300 93- -2% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 53,599 66,560 12,961 19% 6030-403-410580-359 PRIVATE FIBER - CITY NETWORK 0 19,000 19,000 100% 6030-403-410580-360 MULTI-FACTOR AUTHENTICATION 24,950 18,000 6,950- -39% 6030-403-410580-373 DUES & TRAINING 4,410 15,880 11,470 72% 6030-403-410580-510 INSURANCE 6,077 6,077 0- 0% 6030-403-410583-218 TV-Video Equipment & programming 2,808 3,500 692 20% 6030-403-410585-229 COPIER,FAX, SUPPLIES 6,388 18,475 12,087 65% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 63,047 174,788 111,741 64% 6030-403-410585-532 COPIER LEASES 11,132 15,504 4,372 28% 6030-403-410585-942 Servers - capital contingency 10,700 43,204 32,504 75% 6030-403-510400-831 DEPRECIATION EXPENSE 0 10,000 10,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 1,087 3,505 2,418 69% 6030-405-410588-940 COMPUTERS - SWITCHES 0 53,000 53,000 100% 6030-410-410588-218 COMPUTERS - DPW 4,074 3,200 874- -27% 6030-413-410588-218 COMPUTERS - POLICE DEPT 22,977 24,545 1,568 6% 6030-413-410588-354 POLICE - HOSTED SERVER 2,460 2,850 390 14% 6030-416-410588-218 COMPUTERS - FIRE 4,657 6,725 2,068 31% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 3,770 5,200 1,430 28% 6030-436-410588-218 COMPUTERS - PARKS 2,547 3,615 1,068 30% 6030-480-410588-218 COMMUNITY DEVELOPMENT 1,087 1,200 113 9% ------------------------------------------------- TOTAL INFORMATION TECH EXPENSE 705,157 1,228,062 522,905 43% ================================================= THE CITY OF KALISPELL, MONTANA04.16.2021 08:25 gb8501_pg.php/Job No: 51549 Page 36 of 36 USER: RGW FY21 FINANCIAL REPORT THRU MARCH 31 75.00 % Yr Complete For Fiscal Year: 2021 / 3 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-000-342050-000 FEES FOR SERVICES 435,000 580,000 145,000 25% 6010-000-371010-000 INVESTMENT EARNINGS 746 1,200 454 38% ------------------------------------------------- TOTAL CENTRAL GARAGE REVENUE 435,746 581,200 145,454 25% ================================================= CENTRAL GARAGE EXPENSES 6010-410-431330-110 SALARIES 123,178 166,712 43,534 26% 6010-410-431330-121 OVERTIME 1,035 2,500 1,465 59% 6010-410-431330-153 HEALTH INSURANCE 28,429 45,611 17,182 38% 6010-410-431330-155 RETIREMENT 9,174 12,600 3,426 27% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 4,722 11,500 6,778 59% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 2,128 8,000 5,872 73% 6010-410-431330-230 OIL 11,292 25,500 14,208 56% 6010-410-431330-231 GAS 264 1,500 1,236 82% 6010-410-431330-232 VEHICLE PARTS 84,162 136,000 51,838 38% 6010-410-431330-233 TIRES 39,435 54,000 14,565 27% 6010-410-431330-238 FILTERS 5,097 9,000 3,903 43% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 1,009 2,000 991 50% 6010-410-431330-341 ELECTRICITY 1,778 2,200 422 19% 6010-410-431330-344 NATURAL GAS 2,991 6,500 3,509 54% 6010-410-431330-354 CONTRACT SERVICES 19,030 32,000 12,970 41% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 97 6,000 5,903 98% 6010-410-431330-373 DUES & TRAINING 2,105 8,500 6,395 75% 6010-410-431330-388 MEDICAL SERVICES 55 500 445 89% 6010-410-431330-510 INSURANCE 4,201 4,201 0 0% 6010-410-431330-528 INFORMATION TECH TRANSFER 11,425 15,233 3,808 25% 6010-410-431330-944 MACHINERY & EQUIPMENT 34,931 35,000 69 0% ------------------------------------------------- TOTAL CENTRAL GARAGE EXPENSES 386,537 585,057 198,520 34% =================================================