Loading...
02-03-23 City Manager Report and Quarterly Financials1 City of Kalispell OFFICE OF THE CITY MANAGER Information Memorandum 2/3/2023 1. Parks Department Forestry crews have finished pruning trees in the Spring Creek Estates Subdivision and are currently pruning in Mountain Vista Estates. Neighborhoods with younger trees are pruned every three years to establish good branch structure while larger trees are pruned every seven to ten years. A second field crew has completed 4th Street West and has now moved to 5th Street West. A contractor continues to remove hangers and prune large stubs that incurred during the November 2 snow event. In 2022, 1,270 trees were pruned on municipal properties by field staff and contactors. Flathead Cheerleading Camp will take place on February 11. With 40 participants registered, the camp has already surpassed last year’s registration level of 35 participants, with two more weeks of registration remaining. Our Ice-Skating Lessons are officially full for the season. Session 4 began Tuesday, January 31. The annual Valentine’s Dance will be taking place on February 11 at the Linderman Education Center from 7:00pm – 9:00pm. DJ Mike Hammer is joining us again for this family friendly event with great music and fun games to play on the dance floor. The Kalispell Kids After School program has fun activities planned for the month of February. These activities include Groundhog’s Day and Valentine’s Day crafts, Valentine’s Day games, as well as four different movies being shown. Spring Break Camp registration will be opening on February 1. This year’s theme is “The Olympics” with competitive activities such as relay races, tournaments, a talent show, and great fieldtrips planned for Rockfish Climbing Gym and swimming at the Summit. We are entering week 11 of the Adult Futsal League. The postponed games will be rescheduled and played at the end of the regular season before the start of playoffs. There are 12 teams in 2 the league who are each guaranteed 14 games including playoffs. Games are played at Edgerton Elementary on Tuesdays, Wednesdays and Thursdays from 7-9pm. The Kalispell Kickers youth indoor soccer season started on January 21 with 165 participants. Games are played at Rankin Elementary on Saturdays between 9am-3pm. Registration is open for the Spring Little Dribblers Basketball season. Early registration deadline is February 11, at 5pm. Regular registration deadline is February 25, at 5pm. Games will be played at Rankin, Russell, and Peterson Elementary Schools between 8am-6pm. 2. Public Works In 2022 the Department of Environmental Quality (DEQ) implemented a required sampling project for Montana Public Water Suppliers to determine the prevalence of manganese in certain geographic areas throughout the state. Like calcium, manganese (Mn) is a naturally occurring element commonly found in minerals; often in combination with iron. It can be found in soil, water, air, and many of the foods we eat, like seeds and nuts. Consumed in small amounts, manganese is an essential nutrient for maintaining a healthy body, just like calcium and iron. Mn is currently regulated under secondary drinking water standards. Secondary Drinking Water Regulations (NSDWRs) set non- mandatory water quality standards for 15 contaminants. EPA does not enforce these "secondary maximum contaminant levels" (SMCLs). They are established as guidelines to assist public water systems in managing their drinking water for aesthetic considerations, such as taste, color, and odor. Although manganese is an essential nutrient at low doses, chronic exposure to high doses may be harmful. The health effects from over-exposure of manganese are dependent on the route of exposure, the chemical form, the age at exposure, and an individual’s nutritional status. EPA has recently developed a lifetime health advisory limit and DEQ has updated the State’s health –base guidance for Mn. Health advisory (HA) values can be used to evaluate the safety of your household drinking water, but because they are guidance, public water systems are not required to meet these values. The following table compares the City’s PWS December 2022 sample results with EPA and DEQ HA values. Kalispell’s results are significantly lower than the comparable HA values. 3 More information on manganese can be found on DEQ’s website at : Drinking Water Rules | Montana DEQ (mt.gov). 3. Fire Department From the period of January 11 to January 24, the Fire Department had 172 responses. Of these, there were 130 were medical incidents, 5 Motor vehicle accident with injuries, 10 Fire alarm activations, 5 public assists, 3 Haz-Mat incidents, 1 Vehicle Fire, and 18 dispatched and canceled enroute. Chief Pearce has been working with County Fire Chiefs/DNR/911 on a potential on-line burn permit program. While there is no burning in the City limits, the Fire Department fields many phone calls about this issue. Crews have been performing building walk-throughs and Fire Pre-Plans in commercial businesses in Kalispell. The Assistant Chief attended a weeklong Leadership II class in Belgrade. This was hosted by the Montana State Fire Training School. Several KFD members are attending Incident Command Courses (ICS 300 and 400) this week, hosted by Flathead County OES. Members have been attending refresher courses in Advanced Cardiac Life Support (ACLS) and CPR. 4 4. Police Department Year to date calls for service stand at 3,119 for 2023. This compares with 2886 in 2022, and 2796 in 2021. Chef Overman along with City Manager Doug Russell participated in a conversation about long term sustainability for the co-responder program. The meeting was held at the Earl Bennet building and involved members of City-County Health, Greater Valley Health, Sheriff Heino, and the County Administrator. The purpose of the meeting was to work on long-term funding concepts to ensure sustainability for the co-responder program. Of primary concern was allowing the co-responder the flexibility to be a true crisis response. The co-responder program assisted the Kalispell Police Department with 21 incidents in November, 16 in December (gone part of the month), and 31 in January. These calls do not include calls for service with other valley agencies. The Kalispell Police Department conducted new officer testing the week of January 23. Several promising candidates were identified during the process. Interviews were conducted on February 2 for the three open positions. Candidates then move into the background stage prior to conditional offers of employment. Chief Overman hosted US Attorney Jesse Laslovich for a meeting with local law enforcement leaders on January 26. The purpose of the meeting was to build a relationship and further communication with the US Attorney’s Office to better serve the Flathead community. 5. Planning Department The Kalispell City Planning Board will hold a public hearing at their February 14 meeting and take public comments on the agenda items listed below: 1. Files #KA-22-09, KPUD-22-05, and KPP-22-08 – A request from Timberwolf Ridge, LLC, for annexation, initial zoning of RA-1 (Residential Apartment) with a Residential Planned Unit Development (“PUD”) overlay, and major preliminary plat on approximately 20.1 acres of land. The development, called Timberwolf Ridge, would contain up to 400 multi-family dwelling units in six (6) buildings on six (6) lots along with parking, recreational amenities, and open space. The property is located at 605 Stillwater Road at the intersection of Stillwater Road and Timberwolf Parkway. 2. File #KPP-23-01 – A request from GKM Associates, LLC, for preliminary plat approval for Spring Creek Park Phases 2 and 3, a major subdivision on approximately 49.6 acres located to the southeast of the intersection of Three Mile Drive and West Springcreek Road. The subdivision would contain 22 lots (18 attached single-family lots, three multi-family lots, and one commercial lot) as well as streets, parks and open space. It is anticipated that the multi-family lots would contain up to 464 dwelling units. The development proposal is consistent with a Planned Unit Development overlay approved by the Kalispell City Council 5 on March 21, 2022 (Ordinance 1873). 3. File #KA-23-01 – A request from the City of Kalispell for annexation and initial zoning of R-2 (Residential) of a property located at 850 Four Mile Drive. The property is intended to be used as a well site which would be part of the city water system infrastructure. Documents pertaining to the agenda item are on file for public inspection at the Kalispell Planning Department, 201 First Avenue East, Kalispell, MT 59901, and are available for public review during regular office hours. In addition, information on the agenda item is posted on our website at https://mt-kalispell.civicplus.com/314/Planning-Board under planning board “upcoming agenda.” 6. Building Department In the last 3 weeks, we have issued permits for 2 single-family homes. That will bring the total of new single-family/duplex and townhouse units for the year to 5, compared to 18 at this time last year. There have been 36 multi-family housing units issued so far this year. Last year, at this time, we had issued 24 multi-family housing units. There were a total of 270 combined building and/or fire inspections completed in the last 3 weeks. Residential – 47 Plumbing – 19 Commercial – 3 Mechanical - 28 Electrical – 30 Fire – 112 7. Community Development The City of Kalispell has been awarded $520,000.00 from the US Department of Transportation’s Safe Streets and Roads for All Grant Program for a planning study for the Downtown Corridor. This will provide for a thorough planning and community outreach effort involving multiple stakeholders for the Corridor. Total project budget will be $650,000 with a 20% match coming from the City of Kalispell ($80,000.00) and Montana Department of Transportation ($50,000.00). The next step is to establish and execute a mutually agreed upon grant agreement with USDOT. Once that agreement is in place, a local stakeholder group will be put in place that will facilitate a planning process that will take well over a year. 8. Finance Department First Half Finance Report 6 Please find attached the printouts reflecting the activity for the 1st half of fiscal year 2023. This printout reflects payroll through December 31, for biweekly employees. For fire and ambulance, this printout reflects payroll paid thru December 17. All claims submitted by the end of December should be included. Debt service funds are not included. REVENUES: General Fund tax revenue reflects taxes collected thru December 31. Some first half taxes received by the County are not distributed to the City until the County completes the distribution in January. The City has not yet received the January distribution. Last year, the general fund received over $650,000 of first half taxes in January. A similar distribution this January would bring collections to about 59% of the fiscal year 2023 budgeted amount of $7,210,000. Protested taxes remain low. Liquor licenses are billed once a year and are due by June 30. City Court fines and fees revenue reflects July thru December. Parks tax revenues should be over 60% after the County’s January distribution. Youth camps revenue, and many of the other user-based parks fees historically receives more of their revenue in the 2nd half of the fiscal year (spring). The Ambulance Fund 1st half fees for services are 37% of the annual budget or $220,523. This is a decrease when compared to the 1st half of fiscal year 2022. First half Building Department revenues of $657,895 are 48% of the annual budget. First half fiscal year 2022 revenues are $1,119,127. Metered water sales are at 70%. First half water sales are usually more than 50% due to summer and early fall sprinkling and irrigation. Sewer service charges are at 55%, about the same as last fiscal year. Water, sewer, treatment, and storm impact fees are at about 50% of the annual budget. Police and fire impact fees revenues are also at 50% of the annual budget. EXPENDITURES/EXPENSES: At this point in the year, the salary and retirement remaining should be at least 50% in most funds (26 of 52 weeks remaining). Some seasonal parks and rec salaries would be an exception. Fire and ambulance should have about 54% remaining in salaries and retirement (7 of 13 pay periods remaining). Health insurance reflects 6 months paid and should have around 50% remaining. With a few exceptions, administrative, central garage, and information technology transfers are done monthly and should show 50% remaining. This is the same on the revenue side for fees for services (Central Garage/Information Technology) and administrative charges (General Fund). The general fund administrative charges may vary slightly as some charges are based on a percentage of revenues collected. Annual budgeted operating transfers are generally done quarterly, depending on cash availability, 7 and should show 50% remaining. The City prepays its annual liability ($494,147) and property insurance ($205,279) in August. This can result in general government expenditures and some other funds’ expenses reflecting greater than 50% spent in the 1st half of the fiscal year. THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 1 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - REVENUE 1000-000-311100-000 REAL PROPERTY TAXES 3,577,147 7,210,000 3,632,853 50% 1000-000-311200-000 PERSONAL PROPERTY TAXES 85,818 190,000 104,182 55% 1000-000-312000-000 PEN & INTEREST DEL. TAXES 6,045 10,000 3,955 40% 1000-000-322101-000 LIQUOR LICENSES 0 33,000 33,000 100% 1000-000-322300-000 BUSINESS LICENSES 5 1,500 1,495 100% 1000-000-323012-000 PLANNING FEES 82,551 100,000 17,449 17% 1000-000-323109-000 SITE REVIEW 3,092 30,000 26,908 90% 1000-000-323200-000 PARADE PERMITS 200 500 300 60% 1000-000-331112-000 KPD - SAFE STREET TASK FORCE 0 8,000 8,000 100% 1000-000-331990-000 CARES ACT GRANT/ COVID-19 STIMULUS 25,161 0 25,161- 0% 1000-000-335030-000 M.V. TAX - AD VALOREM 0 1,128 1,128 100% 1000-000-335076-000 ST VIDEO -LIC FEE AND TAX DIST 55,300 60,000 4,700 8% 1000-000-335110-000 LIVE CARD TABLE PERMIT 1,650 1,650 0 0% 1000-000-335230-000 ENTITLEMENT SHARE PMT/HB124 1,603,980 3,186,286 1,582,306 50% 1000-000-341020-000 ADMINISTRATIVE CHARGES 357,591 700,531 342,940 49% 1000-000-341021-000 GRANT ADMIN FEES 16,538 30,000 13,462 45% 1000-000-341025-000 CITY COLLECTIONS 8,199 5,000 3,199- -64% 1000-000-342010-000 POLICE SERVICES 13,808 29,000 15,192 52% 1000-000-342014-000 RESOURCE OFFICERS 258,836 258,836 0 0% 1000-000-342016-000 KPD REGIONAL TRAINING 4,125 14,500 10,375 72% 1000-000-343018-000 PARKING PERMITS 54,308 90,000 35,692 40% 1000-000-343062-000 AIRPORT FUEL TAXES 2,365 4,000 1,635 41% 1000-000-343063-000 AIRPORT GROUND LEASE (HILTON) 13,532 13,259 273- -2% 1000-000-351000-000 CITY COURT FINES & FEES 105,156 430,000 324,844 76% 1000-000-351017-000 COURT SECURITY & TECHNOLOGY FEE 4,472 25,000 20,528 82% 1000-000-351035-000 PARKING FINES & BOOT REMOVAL 23,602 40,000 16,399 41% 1000-000-362015-000 INSURANCE REIMBURSEMENTS 0 20,000 20,000 100% 1000-000-362020-000 MMIA LIABILITY RETRO 24,458 20,000 4,458- -22% 1000-000-364030-000 SALE OF MISCELLANEOUS/AUCTION 31 10,000 9,969 100% 1000-000-371010-000 INVESTMENT EARNINGS 139,266 30,000 109,266- -364% 1000-000-381060-000 OPERATING TRANSFER- FUND 2372 550,000 1,100,000 550,000 50% 1000-000-382030-000 GAIN (LOSS)SALE OF ASSET 59,851 0 59,851- 0% ------------------------------------------------- TOTAL GENERAL FUND REVENUE 7,077,087 13,652,190 6,575,103 48% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 2 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GENERAL FUND - EXPENDITURES GENERAL GOV'T. 1000-400-410530-331 ANNUAL REPORT FILING FEES 2,500 3,530 1,030 29% 1000-400-410530-353 CONTRACT SERVICES - AUDIT 0 14,250 14,250 100% 1000-400-410530-354 GASB 75 ACTUARIAL VALUATION 1,750 1,750 0 0% 1000-400-410560-210 PURCHASING/OFFICE SUPPLIES 1,017 4,500 3,483 77% 1000-400-410560-312 POSTAGE 9,120 17,500 8,380 48% 1000-400-410560-320 PRINTING & ENVELOPES 1,988 5,500 3,512 64% 1000-400-410560-354 CONTRACT SERVICES - DOC. SHRED / 10 755 1,200 445 37% 1000-400-410900-331 RECORDS ADMIN./FILING FEES 4,155 4,500 345 8% 1000-400-420000-356 SMITH VALLEY FIRE LEVY REIMB. 264 350 86 24% 1000-400-430300-355 AIRPORT REIMBURSEMENT 76,771 25,000 51,771- -207% 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 0 30,000 30,000 100% 1000-400-510330-513 LIABILITY INSURANCE 330,841 330,842 1 0% 1000-400-510330-516 UNINSURED LOSS -PROPERTY/LIABILITY 2,545- 50,000 52,545 105% 1000-400-510330-517 PROPERTY INSURANCE 72,813 72,813 0 0% ------------------------------------------------- SUBTOTAL GEN.GOV'T. 521,029 583,335 62,306 11% CITY MANAGER 1000-401-410210-110 SALARIES-CITY MANAGER'S OFFICE 84,932 175,140 90,208 52% 1000-401-410210-153 HEALTH INSURANCE 11,922 25,228 13,306 53% 1000-401-410210-155 RETIREMENT 9,138 18,663 9,525 51% 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 520 1,200 680 57% 1000-401-410210-373 DUES & TRAINING 12,710 12,000 710- -6% 1000-401-410210-379 MEETINGS 2,256 6,500 4,244 65% INFORMATION TECHNOLOGY ------------------------------------------------- SUBTOTAL CITY MANAGER 121,478 240,131 118,653 49% HUMAN RESOURCES 1000-401-410830-110 SALARIES-HR DEPT. 89,106 179,526 90,420 50% 1000-401-410830-153 HEALTH INSURANCE 11,141 22,403 11,262 50% 1000-401-410830-155 RETIREMENT 7,404 14,749 7,345 50% 1000-401-410830-210 OFFICE SUPPLIES 473 1,500 1,027 68% 1000-401-410830-338 RECRUITMENT/RELOCATION 11,133 24,000 12,867 54% 1000-401-410830-345 TELEPHONE 0 625 625 100% 1000-401-410830-354 CONTRACT SERVICES 3,130 2,500 630- -25% 1000-401-410830-373 DUES & TRAINING 10,563 17,000 6,437 38% ------------------------------------------------- SUBTOTAL HUMAN RESOURCES 132,951 262,303 129,352 49% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 3 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MAYOR/COUNCIL 1000-402-410100-110 SALARIES-MAYOR/COUNCIL 30,913 63,179 32,266 51% 1000-402-410100-153 HEALTH INSURANCE 21,660 45,560 23,900 52% 1000-402-410100-155 RETIREMENT 1,303 2,646 1,343 51% 1000-402-410100-210 OFFICE SUPPLIES 0 6,500 6,500 100% 1000-402-410100-335 MT LEAGUE OF CITIES 299 1,500 1,201 80% 1000-402-410100-354 CONTRACT SERVICES 1,844 5,500 3,656 66% 1000-402-410100-373 DUES & TRAINING 11,110 11,500 390 3% 1000-402-410100-379 MEETINGS 12,405 36,000 23,595 66% ------------------------------------------------- SUBTOTAL MAYOR/COUNCIL 79,533 172,385 92,852 54% CITY CLERK 1000-402-410150-110 SALARIES-CITY CLERK 58,746 118,594 59,848 50% 1000-402-410150-121 OVERTIME 66 250 184 73% 1000-402-410150-153 HEALTH INSURANCE 8,239 16,566 8,327 50% 1000-402-410150-155 RETIREMENT 4,883 9,764 4,881 50% 1000-402-410150-210 OFFICE SUPPLIES 107 600 493 82% 1000-402-410150-331 COMMUNICATIONS - ADVERTISING 0 500 500 100% 1000-402-410150-345 TELEPHONE & COMMUNICATION 280 480 200 42% 1000-402-410150-352 CODIFICATION 2,866 4,100 1,234 30% 1000-402-410150-354 CONTRACT SERVICES 78 650 572 88% 1000-402-410150-373 DUES & TRAINING 3,956 6,200 2,244 36% ------------------------------------------------- SUBTOTAL CITY CLERK 79,221 157,704 78,483 50% FINANCE DEPARTMENT 1000-403-410550-110 SALARIES-FINANCE OFFICE 126,455 260,655 134,200 51% 1000-403-410550-112 SALARIES-RETIREMENT 38,450 36,940 1,510- -4% 1000-403-410550-121 OVERTIME 0 500 500 100% 1000-403-410550-153 HEALTH INSURANCE 22,863 41,548 18,685 45% 1000-403-410550-155 RETIREMENT 10,492 21,402 10,910 51% 1000-403-410550-210 SUPPLIES 416 1,500 1,084 72% 1000-403-410550-322 BOOKS 0 500 500 100% 1000-403-410550-353 CONTRACT SERVICES 1,558 250 1,308- -523% 1000-403-410550-354 CONTRACT-GRIZZLY SECURITY 1,173 1,500 327 22% 1000-403-410550-355 BANK CHARGES & FEES 1,568 3,500 1,932 55% 1000-403-410550-373 DUES & TRAINING 573 12,000 11,427 95% ------------------------------------------------- SUBTOTAL FINANCE 203,547 380,295 176,748 46% CITY ATTORNEY 1000-404-411110-110 SALARIES-CITY ATTORNEY'S 232,025 535,511 303,486 57% 1000-404-411110-112 SALARIES - SEVERANCE 126,413 135,000 8,587 6% 1000-404-411110-121 OVERTIME 135 0 135- 0% 1000-404-411110-153 HEALTH INSURANCE 36,169 92,560 56,391 61% 1000-404-411110-155 RETIREMENT 19,228 44,037 24,809 56% 1000-404-411110-210 OFFICE/COMPUTER SUPPLIES 1,520 6,000 4,480 75% 1000-404-411110-322 LEXIS-NEXIS/BOOKS/SUBSCRIPTIONS 10,987 20,000 9,013 45% 1000-404-411110-345 TELEPHONE & COMMUNICATION 412 1,000 588 59% 1000-404-411110-354 CONTRACT SERVICES/CONTINGENCY 753 10,000 9,247 92% 1000-404-411110-373 DUES & TRAINING 3,412 8,000 4,588 57% ------------------------------------------------- SUBTOTAL CITY ATTORNEY 431,053 852,108 421,055 49% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 4 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING MUNICIPAL COURT 1000-406-410360-110 SALARIES-COURT 114,923 274,694 159,771 58% 1000-406-410360-121 OVERTIME 0 3,500 3,500 100% 1000-406-410360-153 HEALTH INSURANCE 20,018 46,394 26,376 57% 1000-406-410360-155 RETIREMENT 9,549 22,546 12,997 58% 1000-406-410360-210 SUPPLIES 785 4,500 3,715 83% 1000-406-410360-320 PRINTING/BOOKS 33 1,500 1,467 98% 1000-406-410360-345 TELEPHONE & COMMUNICATION 399 1,000 601 60% 1000-406-410360-353 SECURITY & TECHNOLOGY 13,322 40,000 26,678 67% 1000-406-410360-354 CONTRACT SERVICES 4,494 7,000 2,506 36% 1000-406-410360-373 DUES & TRAINING 2,346 10,000 7,654 77% 1000-406-410360-394 JURY & WITNESS FEES 2,147 10,000 7,853 79% ------------------------------------------------- SUBTOTAL COURT 168,016 421,134 253,118 60% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 5 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC WORKS ADMINISTRATION 1000-410-430100-110 SALARIES-PUBLIC WORKS 10,846 25,394 14,548 57% 1000-410-430100-153 HEALTH INSURANCE 1,579 3,631 2,052 57% 1000-410-430100-155 RETIREMENT 890 2,055 1,165 57% 1000-410-430100-210 COMPUTER/OFFICE SUPPLIES 7,700 15,500 7,800 50% 1000-410-430100-218 NON CAPITAL EQUIP/ENGINEERING TOOLS 0 3,500 3,500 100% 1000-410-430100-231 GAS 3,157 4,500 1,343 30% 1000-410-430100-345 TELEPHONE & COMMUNICATION 537 900 363 40% 1000-410-430100-354 CONTRACT SERVICES 4,598 8,000 3,402 43% 1000-410-430100-373 DUES & TRAINING 809 5,000 4,191 84% 1000-410-430100-521 CENTRAL GARAGE TRANSFER 2,164 4,327 2,163 50% ------------------------------------------------- SUBTOTAL PUBLIC WORKS ADMIN 32,281 72,807 40,526 56% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 6 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CITY HALL MAINT. 1000-412-411230-110 SALARIES-CITY HALL 36,949 74,374 37,425 50% 1000-412-411230-153 HEALTH INSURANCE 6,272 14,564 8,292 57% 1000-412-411230-155 RETIREMENT 3,040 6,055 3,015 50% 1000-412-411230-220 SECURITY IMPROVEMENTS 0 5,000 5,000 100% 1000-412-411230-224 JANITORIAL SUPPLIES 3,654 7,500 3,846 51% 1000-412-411230-241 TOOLS & SUPPLIES 367 1,500 1,133 76% 1000-412-411230-341 ELECTRICITY 21,937 50,000 28,063 56% 1000-412-411230-344 NATURAL GAS 18,412 35,000 16,588 47% 1000-412-411230-345 TELEPHONE & COMMUNICATION 223 500 277 55% 1000-412-411230-354 CONTRACT SERVICES 5,839 15,000 9,161 61% 1000-412-411230-355 HVAC MAINTENANCE CONTRACT 18,076 18,076 0 0% 1000-412-411230-361 ELEVATOR MAINT/FIRE ALARM MAINT 1,094 7,200 6,106 85% 1000-412-411230-362 EQUIPMENT MAINTENANCE 9,475 10,000 525 5% 1000-412-411230-366 BUILDING MAINTENANCE 9,523 22,000 12,477 57% 1000-412-411230-545 COUNTY LANDFILL/RECYCLING 3,135 3,780 645 17% 1000-412-411230-920 BLDG IMPROVEMENT 0 73,000 73,000 100% ------------------------------------------------- SUBTOTAL CITY HALL 137,994 343,549 205,555 60% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 7 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 420 PLANNING DEPARTMENT 1000-420-411020-110 SALARIES-PLANNING & ZONING 121,494 256,086 134,592 53% 1000-420-411020-153 HEALTH INSURANCE 21,428 39,816 18,388 46% 1000-420-411020-155 RETIREMENT 10,083 21,079 10,996 52% 1000-420-411020-210 SUPPLIES/EQUIPMENT/SOFTWARE 1,474 4,000 2,526 63% 1000-420-411020-231 GAS 236 500 264 53% 1000-420-411020-331 PUBLICATION/FILING FEES/BOOKS 722 2,500 1,778 71% 1000-420-411020-345 TELEPHONE 262 1,000 738 74% 1000-420-411020-354 CONTRACT SERVICES 175 6,000 5,825 97% 1000-420-411020-373 DUES & TRAINING 1,804 8,000 6,196 77% 1000-420-411020-521 CENTRAL GARAGE TRANSFER 40 81 41 50% ------------------------------------------------- SUBTOTAL PLANNING DEPT. 157,718 339,062 181,344 53% 480 COMMUNITY DEVELOPMENT 1000-480-470210-110 SALARIES - COMM. DEV. DEPT. 19,588 52,217 32,629 62% 1000-480-470210-153 HEALTH INSURANCE 2,762 9,856 7,094 72% 1000-480-470210-155 RETIREMENT 1,627 4,271 2,644 62% 1000-480-470210-210 OFFICE SUPPLIES 72 1,600 1,528 95% 1000-480-470210-211 GRANT ADMIN EXP/PROJECT EXP 120 600 480 80% 1000-480-470210-312 POSTAGE & PRINTING 0 300 300 100% 1000-480-470210-334 MT WEST ECONOMIC DEV MEMBERSHIP 0 500 500 100% 1000-480-470210-345 TELEPHONE/COMMUNICATIONS 116 450 334 74% 1000-480-470210-354 CONTRACT SERVICES 84 250 166 66% 1000-480-470210-373 DUES & TRAINING 2,870 5,000 2,130 43% 1000-480-470210-379 MEETINGS 0 750 750 100% ------------------------------------------------- SUBTOTAL COMMUNITY DEVELOPMENT 27,240 75,794 48,554 64% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 8 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING POLICE DEPARTMENT 1000-413-420140-110 SALARIES-POLICE 1,305,763 2,807,937 1,502,174 54% 1000-413-420140-112 SALARIES-SEVERANCE 17,780 50,000 32,220 64% 1000-413-420140-114 SALARY -comptime buyout 8,753 10,050 1,297 13% 1000-413-420140-121 OVERTIME (REG & AET OT) 44,312 80,000 35,688 45% 1000-413-420140-123 SPECIAL ASSIGN OVERTIME/SRT-MCU 13,647 35,000 21,353 61% 1000-413-420140-153 HEALTH INSURANCE 242,123 521,963 279,840 54% 1000-413-420140-155 RETIREMENT 168,345 369,130 200,785 54% 1000-413-420140-210 OFFICE SUPPLIES 1,368 4,500 3,132 70% 1000-413-420140-215 COMPUTER SUPPLIES/EQUIP./MAINT. 4,680 5,560 880 16% 1000-413-420140-218 EQUIPMENT (NON CAPITAL) 28,718 36,000 7,282 20% 1000-413-420140-220 INVESTIGATIVE SUPPLIES 1,565 5,500 3,935 72% 1000-413-420140-221 SAFETY EQUIP & SUPPLIES 9,809 13,000 3,191 25% 1000-413-420140-225 MAJOR CASE UNIT SUPPLIES 46 3,400 3,354 99% 1000-413-420140-226 SRT SUPPORT/SUPPLIES 2,716 8,600 5,884 68% 1000-413-420140-227 AMMO & RELATED SUPPLIES 46,346 50,900 4,554 9% 1000-413-420140-228 PATROL CAR SUPPLIES 4,217 8,000 3,783 47% 1000-413-420140-229 OTHER SUPPLIES 3,921 13,000 9,079 70% 1000-413-420140-230 CRIME PREVENTION SUPPLIES 0 1,000 1,000 100% 1000-413-420140-231 GAS 41,251 85,000 43,749 51% 1000-413-420140-234 CRISIS NEGOTIATIONS 0 500 500 100% 1000-413-420140-237 RESERVE PROGRAM SUPPLIES 80 1,500 1,420 95% 1000-413-420140-320 PRINTING 1,286 4,500 3,214 71% 1000-413-420140-345 TELEPHONE & COMMUNICATION 12,389 23,000 10,611 46% 1000-413-420140-354 CONTRACT SERVICES 48,436 78,220 29,784 38% 1000-413-420140-357 FORENSIC ANALYSIS/PATHOLOGY 2,785 10,500 7,715 73% 1000-413-420140-358 SHELTER/ANIMAL:VET. TREATMENT 439 23,000 22,561 98% 1000-413-420140-363 OFFICE EQUIP MAINTENANCE 2,287 2,100 187- -9% 1000-413-420140-365 SOFTWARE-MAINT. & LISC. 11,698 58,000 46,302 80% 1000-413-420140-369 RADIO EQUIPMENT & MAINT. 1,274 6,000 4,726 79% 1000-413-420140-373 DUES & TRAINING 35,694 61,450 25,756 42% 1000-413-420140-375 REG. TRAINING/TESTING REIMB. 4,886 14,500 9,615 66% 1000-413-420140-380 TRAINING MATERIALS 4,000 4,000 0 0% 1000-413-420140-388 MEDICAL SERVICES 0 3,000 3,000 100% 1000-413-420140-392 BOARDING/TREATING PRISONERS 1,178 3,255 2,077 64% 1000-413-420140-521 CENTRAL GARAGE TRANSFER 40,361 80,722 40,361 50% 1000-413-420140-530 RENT 3,500 8,400 4,900 58% ------------------------------------------------- SUBTOTAL O & M 2,115,650 4,491,187 2,375,537 53% TRANSFERS 1000-413-420140-827 TRANSFER TO 2916 DRUG GRANT 32,000 64,000 32,000 50% 1000-413-420140-829 TRANSFER TO 2919 BLOCK GRANT 3,000 6,000 3,000 50% ------------------------------------------------- TOTAL TRANSFERS 35,000 70,000 35,000 50% CAPITAL OUTLAY 1000-413-420140-944 VEHICLES 30,399 160,000 129,601 81% ------------------------------------------------- TOTAL CAPITAL OUTLAY 30,399 160,000 129,601 81% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 9 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING DETECTIVES 1000-413-420141-110 SALARIES-DETECTIVES 199,697 402,264 202,567 50% 1000-413-420141-121 DETECTIVE-OVERTIME 6,818 15,000 8,182 55% 1000-413-420141-123 OVERTIME (SAFE NEIGHBORHOOD TASK FO 567 8,000 7,433 93% 1000-413-420141-153 HEALTH INSURANCE 37,707 76,798 39,091 51% 1000-413-420141-155 DETECTIVE-RETIREMENT 26,663 53,903 27,240 51% ------------------------------------------------- TOTAL DETECTIVES 271,452 555,965 284,513 51% RECORDS 1000-413-420142-110 SALARIES-RECORDS DIVISION 81,624 179,369 97,745 54% 1000-413-420142-121 OVERTIME 2,166 6,500 4,334 67% 1000-413-420142-153 HEALTH INSURANCE 21,358 46,394 25,036 54% 1000-413-420142-155 RETIREMENT 6,917 14,683 7,766 53% ------------------------------------------------- TOTAL RECORDS 112,065 246,946 134,881 55% RESOURCE OFFICERS 1000-413-420144-110 SALARIES-SRO 121,623 295,851 174,228 59% 1000-413-420144-153 HEALTH INSURANCE 21,202 59,540 38,338 64% 1000-413-420144-155 SRO RETIREMENT 15,964 39,733 23,769 60% ------------------------------------------------- TOTAL RESOURCE OFFICERS 158,789 395,124 236,335 60% ANIMAL CONTROL 1000-413-420145-110 ANIMAL CONTROL-SALARIES 13,336 53,717 40,381 75% 1000-413-420145-121 OVERTIME 0 500 500 100% 1000-413-420145-153 HEALTH INSURANCE 2,888 9,235 6,347 69% 1000-413-420145-155 RETIREMENT 1,093 4,234 3,141 74% ------------------------------------------------- SUBTOTAL ANIMAL CONTROL 17,317 67,686 50,369 74% PARKING 1000-413-420147-110 PARKINGS -SALARIES 48,216 97,881 49,665 51% 1000-413-420147-153 HEALTH INSURANCE 15,893 31,949 16,056 50% 1000-413-420147-155 RETIREMENT 3,943 7,930 3,987 50% 1000-413-420147-210 SUPPLIES-OFFICE/FUEL/OTHER 707 3,000 2,293 76% 1000-413-420147-354 CONTRACTED SERVICES 133 3,000 2,867 96% 1000-413-420147-362 LOT MAINT 408 10,000 9,592 96% 1000-413-420147-365 SNOW REMOVAL -Parking Lots 6,775 17,500 10,725 61% 1000-413-420147-550 LOT LEASE PAYMENTS 606 1,500 894 60% ------------------------------------------------- SUBTOTAL PARKING 76,681 172,760 96,079 56% ------------------------------------------------- SUBTOTAL POLICE DEPT. 2,817,353 6,159,668 3,342,315 54% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 10 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING FIRE DEPARTMENT 1000-416-420400-110 SALARIES-FIRE SUPPRESSION 1,168,644 2,366,445 1,197,801 51% 1000-416-420400-112 SALARY-SEVERANCE 0 15,000 15,000 100% 1000-416-420400-114 COMPTIME BUYOUT 4,555 5,500 945 17% 1000-416-420400-115 OUT OF RANK PAY 6,742 12,500 5,758 46% 1000-416-420400-121 OVERTIME 51,803 60,000 8,197 14% 1000-416-420400-153 HEALTH INSURANCE 214,729 406,835 192,106 47% 1000-416-420400-155 RETIREMENT 153,244 331,503 178,259 54% 1000-416-420400-210 OFFICE/COMPUTER SUPPLIES 1,251 5,180 3,929 76% 1000-416-420400-218 EQUIPMENT (Non Capital) 5,387 22,500 17,113 76% 1000-416-420400-221 SAFETY EQUIP & SUPPLIES 10,482 95,000 84,518 89% 1000-416-420400-224 JANITORIAL SUPPLIES 2,933 5,575 2,642 47% 1000-416-420400-231 GAS 13,629 20,800 7,171 34% 1000-416-420400-241 CONSUMABLE TOOLS/UNIFORMS 12,312 17,325 5,013 29% 1000-416-420400-320 PRINTING 0 200 200 100% 1000-416-420400-322 SUBSCRIPTIONS/PUBLICATIONS/MATERIAL 260 1,250 990 79% 1000-416-420400-345 TELEPHONE & COMMUNICATION 2,009 5,500 3,491 63% 1000-416-420400-354 CONTRACT SERVICES 35,871 68,250 32,379 47% 1000-416-420400-362 EQUIPMENT MAINTENANCE 4,379 6,500 2,121 33% 1000-416-420400-366 BUILDING MAINTENANCE-STATION 62 23,584 26,000 2,416 9% 1000-416-420400-369 RADIO EQUIPMENT & MAINT. 1,757 5,000 3,243 65% 1000-416-420400-373 DUES & TRAINING 6,700 20,000 13,300 67% 1000-416-420400-388 FIREFIGHTER PHYSICALS 8,088 31,000 22,912 74% 1000-416-420400-521 CENTRAL GARAGE TRANSFER 9,463 18,926 9,463 50% ------------------------------------------------- TOTAL O & M 1,737,823 3,546,789 1,808,966 51% DEBT SERVICE 1000-416-420400-610 DEBT RETIREMENT-FIRE TRUCK 23,436 65,921 42,485 64% 1000-416-420400-620 INTEREST EXPENSE-FIRE TRUCK 2,239 10,665 8,426 79% ------------------------------------------------- TOTAL DEBT SERVICE 25,675 76,586 50,911 66% TRANSFERS 1000-416-420400-820 TRANSFER TO AMBULANCE FUND 445,000 890,000 445,000 50% 1000-416-420400-821 TFR - 2956 AFG ($5,300) 0 5,300 5,300 100% ------------------------------------------------- TOTAL TRANSFERS 445,000 895,300 450,300 50% CAPITAL OUTLAY 1000-416-420400-940 CAPITAL EQUIPMENT-VEHICLE/SCBA/SERV 5,167 34,304 29,137 85% ------------------------------------------------- TOTAL CAPITAL OUTLAY 5,167 34,304 29,137 85% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 11 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PREVENTION 1000-416-420440-110 SALARIES-FIRE PREVENTION 11,829 25,679 13,850 54% 1000-416-420440-153 HEALTH INSURANCE 2,724 5,476 2,752 50% 1000-416-420440-155 RETIREMENT 975 1,942 967 50% ------------------------------------------------- TOTAL PREVENTION 15,528 33,097 17,569 53% ------------------------------------------------- TOTAL FIRE DEPARTMENT 2,229,194 4,586,076 2,356,882 51% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 12 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING GRAND TOTAL GENERAL FUND 7,138,609 14,646,351 7,507,742 51% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 13 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING INFORMATION TECHNOLOGY REVENUE 6030-000-335230-000 ENTITLEMENT SHARE PMT/HB124 185,000 370,000 185,000 50% 6030-000-341025-000 MISC REVENUE 185 0 185- 0% 6030-000-341027-000 CHARTER COMMUNICATION/FRANCISE FEES 48,343 210,000 161,657 77% 6030-000-371010-000 INVESTMENT EARNINGS 6,291 1,100 5,191- -472% 6030-000-393000-000 INTERNAL SERVICES-DATA 314,563 628,947 314,384 50% ------------------------------------------------- TOTAL REVENUE 554,382 1,210,047 655,665 54% ================================================= EXPENSES 6030-401-410580-110 SALARIES 202,362 458,353 255,991 56% 6030-401-410580-112 SALARIES - RETIREMENT 0 12,500 12,500 100% 6030-401-410580-121 OVERTIME 760 1,000 240 24% 6030-401-410580-153 HEALTH INSURANCE 38,993 91,042 52,049 57% 6030-401-410580-155 RETIREMENT 16,842 37,669 20,827 55% 6030-401-410588-218 COMPUTERS - ADMINISTRATIVE DEPTS 152 8,021 7,869 98% 6030-403-410580-215 COMPUTER SUPPLIES 1,391 5,280 3,889 74% 6030-403-410580-218 EQUIPMENT-NOT CAPITAL 9,788 30,472 20,684 68% 6030-403-410580-325 WEBSITE 8,854 9,000 146 2% 6030-403-410580-345 PAGER/PHONE 0 2,800 2,800 100% 6030-403-410580-346 SUMMITNET & ISPS 2,422 8,716 6,294 72% 6030-403-410580-353 LASER FICHE MAINTENANCE 679 20,000 19,321 97% 6030-403-410580-354 MAINTENANCE CONTRACTS 24,099 60,000 35,901 60% 6030-403-410580-355 LICENSES 6,025 23,696 17,671 75% 6030-403-410580-356 MAINTENANCE CONTRACTS 82,209 187,794 105,585 56% 6030-403-410580-357 GRANICUS 7,800 7,200 600- -8% 6030-403-410580-358 MICROSOFT EXCHANGE EMAIL HOSTING 1,130 67,424 66,294 98% 6030-403-410580-359 PRIVATE FIBER - CITY NETWORK 8,649 23,616 14,967 63% 6030-403-410580-360 MULTI-FACTOR AUTHENTICATION 1,925 1,500 425- -28% 6030-403-410580-373 DUES & TRAINING 5,231 20,465 15,234 74% 6030-403-410580-510 INSURANCE 8,221 8,221 0 0% 6030-403-410580-660 LEASE INTEREST EXPENSE 55 0 55- 0% 6030-403-410580-835 LEASE AMORTIZATION EXPENSE 655 0 655- 0% 6030-403-410583-218 TV-Video Equipment & programming 44,070 105,269 61,199 58% 6030-403-410585-229 COPIER,FAX, SUPPLIES 6,789 17,365 10,576 61% 6030-403-410585-345 TELEPHONE & COMMUNICATIONS 42,643 200,045 157,402 79% 6030-403-410585-532 COPIER LEASES 0 14,578 14,578 100% 6030-403-410585-942 Servers - capital contingency 0 54,000 54,000 100% 6030-403-510400-831 DEPRECIATION EXPENSE 0 50,000 50,000 100% 6030-404-410588-218 COMPUTERS - ATTORNEYS 609 1,450 841 58% 6030-405-410588-940 COMPUTERS - SWITCHES 44,725 120,000 75,275 63% 6030-410-410588-218 COMPUTERS - DPW 5,330 7,295 1,965 27% 6030-413-410588-218 COMPUTERS - POLICE DEPT 4,145 23,034 18,889 82% 6030-413-410588-354 POLICE - HOSTED SERVER 1,123 0 1,123- 0% 6030-416-410588-218 COMPUTERS - FIRE 914 9,262 8,348 90% 6030-420-410588-218 COMPUTERS - PLANNING DEPT 457 750 293 39% 6030-436-410588-218 COMPUTERS - PARKS 609 4,050 3,441 85% 6030-480-410588-218 COMMUNITY DEVELOPMENT 319 0 319- 0% ------------------------------------------------- TOTAL EXPENSE 579,975 1,691,867 1,111,892 66% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 14 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC SAFETY - EMERGENCY SERV AMBULANCE FUND REVENUE 2230-000-342050-000 FEES FOR SERVICES 220,523 600,000 379,477 63% 2230-000-342070-000 COUNTY EMS LEVY 0 140,000 140,000 100% 2230-000-383010-000 TRANSFER FROM GENERAL FUND 445,000 890,000 445,000 50% ------------------------------------------------- TOTAL REVENUE 665,523 1,630,000 964,477 59% ================================================= EXPENSE 2230-440-420730-110 SALARIES 352,962 715,828 362,866 51% 2230-440-420730-114 COMPTIME BUYBACK 0 3,500 3,500 100% 2230-440-420730-115 OUT OF RANK PAY 0 3,300 3,300 100% 2230-440-420730-121 OVERTIME 25,008 30,000 4,992 17% 2230-440-420730-153 HEALTH INSURANCE 69,248 135,494 66,246 49% 2230-440-420730-155 RETIREMENT 45,161 93,027 47,866 51% 2230-440-420730-210 OFFICE/COMPUTER SUPPLIES 266 3,400 3,134 92% 2230-440-420730-218 NON-CAPITAL EQUIPMENT 2,070 4,500 2,430 54% 2230-440-420730-231 GAS & OIL 7,217 9,500 2,283 24% 2230-440-420730-241 CONSUMABLE TOOLS/UNIFORMS 34 4,500 4,466 99% 2230-440-420730-312 POSTAGE/PRINTING 178 1,000 822 82% 2230-440-420730-345 TELEPHONE & COMMUNICATION 521 2,000 1,479 74% 2230-440-420730-354 CONTRACT SERVICES 3,935 21,500 17,565 82% 2230-440-420730-359 COLLECTION SERV. / CC FEES / AUDIT 2,550 5,000 2,450 49% 2230-440-420730-362 EQUIPMENT/RADIO MAINTENANCE 781 5,000 4,219 84% 2230-440-420730-373 DUES & TRAINING 114 16,500 16,386 99% 2230-440-420730-388 EXP. TESTING/IMMUNIZATION 0 2,000 2,000 100% 2230-440-420730-391 MEDICAL TREATMENT-SUPPLIES 24,164 60,000 35,836 60% 2230-440-420730-510 PROPERTY & LIABILITY INSURANCE 14,855 14,855 0- 0% 2230-440-420730-521 CENTRAL GARAGE TRANSFER 7,767 15,535 7,768 50% 2230-440-420730-522 ADMINISTRATIVE TRANSFER 24,328 48,656 24,328 50% 2230-440-420730-528 INFORMATION TECHNOLOGY TRANSFER 19,343 38,686 19,343 50% 2230-440-420730-610 PRINCIPAL - AMBULANCE 18,374 36,947 18,573 50% 2230-440-420730-620 INTEREST - AMBULANCE 1,138 2,372 1,234 52% 2230-440-420730-940 EQUIPMENT 18,239 370,000 351,761 95% ------------------------------------------------- TOTAL EXPENDITURES 638,254 1,643,100 1,004,846 61% ================================================= 2230 AMBULANCE CASH 2230-000-010100-000 CASH, AMBULANCE 91,670 0 91,670- 0% ------------------------------------------------- AMBULANCE CASH BALANCE 91,670 0 91,670- 0% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 15 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2995 SAFER GRANT ------------------------------------------------- TOTAL SAFER REVENUE 0 0 0 0% ================================================= ------------------------------------------------- TOTAL SAFER EXP 0 0 0 0% ================================================= 2956 FIRE GRANTS 2956-416-420400-221 SAFETY EQUIP (ROUNDUP FOR SAFETY) 1,816 5,000 3,184 64% 2956-416-420415-940 AFG GRT FY22 RADIO 0 58,300 58,300 100% ------------------------------------------------- 2956 TOTAL FIRE GRANTS 1,816 63,300 61,484 97% ================================================= 2957 HAZMAT GRANT 2957-416-420400-221 DoMA EQUIP (REIMB) 174 0 174- 0% 2957-416-420410-125 PASS THRU HAZMAT OT 799 5,000 4,201 84% 2957-416-420410-218 PASS THRU HAZMAT EQUIP 240 10,000 9,760 98% 2957-416-420410-373 PASS THRU HAZMAT TRAVEL 0 3,000 3,000 100% ------------------------------------------------- TOTAL HAZMA GRANT EXPENDITURES 1,213 18,000 16,787 93% ================================================= 2958 HAZMAT TEAM SUSTAINMENT G 2958-416-420455-240 OTHER SUPPLIES AND EQUIPMENT 1,223 37,381 36,158 97% ------------------------------------------------- TOTAL HAZMAT TEAM SUSTAINMENT 1,223 37,381 36,158 97% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 16 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC SAFETY - LAW ENFORCEMEN 2915 STONGARDEN GRANT 2915-413-420140-121 OT&FRINGES/KPD 2,655 10,000 7,345 73% 2915-413-420140-218 SMALL EQUIP -Stonegarden 0 30,000 30,000 100% ------------------------------------------------- TOTAL STONEGARDEN GRANT 2,655 40,000 37,345 93% ================================================= 2916 DRUG ENFORCEMENT GRANT 2916-413-420140-110 SALARIES - DRUG ENFORCEMENT GRANT 20,612 70,949 50,337 71% 2916-413-420140-121 OVERTIME 9,040 13,000 3,960 30% 2916-413-420140-153 HEALTH INSURANCE 9,084 13,312 4,228 32% 2916-413-420140-155 RETIREMENT 4,145 9,523 5,378 56% ------------------------------------------------- TOTAL DRUG ENFORCEMENT GRANT 42,881 106,784 63,903 60% ================================================= 2918 COPS HIRING RECOVERY PROG ------------------------------------------------- TOTAL COPS HIRING RECOVERY GRA 0 0 0 0% ================================================= 2919 LAW ENFORCEMENT GRANT 2919-413-420140-110 SALARIES - BENEFITS 597 3,000 2,403 80% 2919-413-420140-121 OVERTIME - DISPATCH 215 0 215- 0% 2919-413-420140-126 HOLIDAY OT REIMB (STEP GRT) 4,689 35,000 30,311 87% 2919-413-420140-127 SCHOOL DIST. OT 6,812 17,000 10,188 60% 2919-413-420140-218 JAG GRT/BODY ARMOR & BODY WORN CAME 6,381 13,500 7,119 53% 2919-413-420140-219 EQUIPMENT FROM WALMART COMMUNITY GR 0 5,000 5,000 100% 2919-413-420140-220 EQUIPMENT-FUNDED BY DONATIONS 140 4,000 3,860 97% 2919-413-420140-221 BULLET PROOF VESTS & HSPG GRT VESTS 0 6,000 6,000 100% 2919-413-420140-373 TRAINING - FORFEITURE FUNDS 0 9,946 9,946 100% ------------------------------------------------- TOTAL LAW ENFORCEMENT GRANTS 18,834 93,446 74,612 80% ================================================= 4170 IMPOUND/STORAGE FACILITY 4170-400-411230-925 IMPOUND STORAGE FACILITY 0 430,000 430,000 100% ------------------------------------------------- TOTAL IMPOUND STORAGE FACILITY 0 430,000 430,000 100% ================================================= 2399 IMPACT FEE FUND 2399-400-420100-522 ADMIN CHARGE - IMPACT FEES 5% 7,500 15,000 7,500 50% 2399-413-420140-610 PRINCIPAL - IMPOUND/STORAGE 0 28,500 28,500 100% 2399-413-420140-620 INTEREST - IMPOUND/STORAGE 0 6,500 6,500 100% 2399-413-420140-920 IMPOUND/STORAGE FACILITY 0 75,000 75,000 100% 2399-416-420400-940 FIRE DEPT. EQUIPMENT 0 1,700,000 1,700,000 100% ------------------------------------------------- TOTAL PUBLIC SAFETY IMPACT FEE 7,500 1,825,000 1,817,500 100% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 17 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PUBLIC WORKS 2500 SPECIAL STREET MAINT. 2500-421-430240-110 SALARIES-SPEC.STREET MAINT. 408,308 976,681 568,373 58% 2500-421-430240-121 OVERTIME 11,513 28,000 16,487 59% 2500-421-430240-153 HEALTH INSURANCE 75,818 204,005 128,187 63% 2500-421-430240-155 RETIREMENT 33,577 77,516 43,939 57% 2500-421-430240-210 COMPUTER EQUIP./SUPPLIES 11,702 26,500 14,798 56% 2500-421-430240-218 SAFETY/OTHER EQUIP. & SUPPLIES 1,076 14,000 12,924 92% 2500-421-430240-220 OTHER SUPPLIES 1,462 4,600 3,138 68% 2500-421-430240-231 GAS & OIL 36,369 51,000 14,631 29% 2500-421-430240-341 ELECTRICITY 1,224 3,600 2,376 66% 2500-421-430240-345 TELEPHONE/COMMUNICATIONS 2,057 4,330 2,273 53% 2500-421-430240-353 AUDITING 0 1,600 1,600 100% 2500-421-430240-354 CONTRACT SERVICES 3,519 25,000 21,481 86% 2500-421-430240-356 CONSULTANT REVIEWS 748 30,000 29,252 98% 2500-421-430240-362 EQUIP. MAINT./SUPPLIES 30,629 43,000 12,371 29% 2500-421-430240-366 BUILDING MAINTENANCE 3,529 5,000 1,471 29% 2500-421-430240-373 DUES & TRAINING 1,730 14,000 12,270 88% 2500-421-430240-388 MEDICAL SERVICES 310 1,000 690 69% 2500-421-430240-510 LIABILITY INSURANCE 51,088 51,088 0- 0% 2500-421-430240-512 UNINSURED LOSS-DEDUCTIBLE 8,272 45,000 36,728 82% 2500-421-430240-521 CENTRAL GARAGE TRANSFER 85,719 171,438 85,719 50% 2500-421-430240-522 ADMINISTRATIVE TRANSFER 56,739 113,478 56,739 50% 2500-421-430240-528 INFORMATION TECHNOLOGY TRANSFER 20,989 41,978 20,989 50% 2500-421-430240-610 DEBT SERVICE - PRINCIPAL 0 25,000 25,000 100% 2500-421-430240-620 DEBT SERVICE - INTEREST 0 1,938 1,938 100% 2500-421-430240-840 MACI GRANT MATCH - WTR/DE-ICER TRK 0 19,500 19,500 100% 2500-421-430241-610 PRINCIPAL-2017 4TH AVE E PROJECT 13,633 27,266 13,633 50% 2500-421-430241-620 INTEREST-2017 4TH AVE E PROJECT 6,129 12,088 5,959 49% 2500-421-430244-354 PAVEMENT REPAIRS-PAVEMENT MNT FUNDS 169,381 512,399 343,018 67% 2500-421-430244-820 TRANSFER TO BaRSAA 0 30,000 30,000 100% 2500-421-430245-940 MACHINERY/EQUIP (replacement funds) 305,677 501,023 195,346 39% 2500-421-430248-354 SIDEWALK REPAIR/MAINT. $ 0 15,652 15,652 100% ------------------------------------------------- TOTAL STREET MAINT 1,341,199 3,077,680 1,736,481 56% ------------------------------------------------- TSS 2500-421-430264-110 TSS - SALARIES 53,187 115,226 62,039 54% 2500-421-430264-121 OVERTIME 0 7,500 7,500 100% 2500-421-430264-153 HEALTH INSURANCE 13,451 36,516 23,065 63% 2500-421-430264-155 RETIREMENT 4,226 9,080 4,854 53% 2500-421-430264-210 COMPUTER EQUIP. & SUPPLIES 843 5,960 5,117 86% 2500-421-430264-218 SAFETY/OTHER EQUIP. & SUPPLIES 353 8,000 7,647 96% 2500-421-430264-220 JANITORIAL/OTHER SUPPLIES/TOOLS 597 4,500 3,903 87% 2500-421-430264-242 STREET SIGNS 8,522 30,000 21,478 72% 2500-421-430264-243 TRAFFIC SIGNALS 542 50,459 49,917 99% 2500-421-430264-245 BARRICADE MATERIALS 0 6,000 6,000 100% 2500-421-430264-341 ELECTRICITY 590 3,000 2,410 80% 2500-421-430264-345 COMMUNICATIONS 552 1,350 798 59% 2500-421-430264-354 CONTRACT SERVICES 1,058 10,000 8,942 89% 2500-421-430264-362 EQUIPMENT MAINTENANCE 160 3,000 2,840 95% 2500-421-430264-366 BUILDING MAINTENANCE 1,293 5,000 3,707 74% 2500-421-430264-373 DUES & TRAINING 1,282 7,500 6,218 83% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 18 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2500-421-430264-428 PAINT MATERIALS 8 5,000 4,992 100% 2500-421-430264-510 LIABILITY INS.-TSS 3,783 3,783 0 0% 2500-421-430264-512 UNINSURED LOSS-DEDUCTIBLE 0 1,000 1,000 100% 2500-421-430264-521 CENTRAL GARAGE TRANSFER 2,260 4,519 2,259 50% 2500-421-430264-940 MACHINERY & EQUIPMENT 0 10,500 10,500 100% ------------------------------------------------- TOTAL TSS 92,704 327,893 235,189 72% ------------------------------------------------- TOTAL SPECIAL STREET 1,433,902 3,405,573 1,971,671 58% ================================================= 2420 GAS TAX 2420-421-430234-956 SIDEWALK & CURB CONSTRUCTION 27,669 90,740 63,071 70% 2420-421-430234-957 ALLEY PAVING 17,683 51,223 33,540 65% 2420-421-430240-231 GAS & OIL 35,497 51,000 15,503 30% 2420-421-430240-344 NATURAL GAS 1,402 5,000 3,598 72% 2420-421-430240-354 CONTRACT SERVICES - STRIPING 0 20,000 20,000 100% 2420-421-430240-360 REPAIR & MAINT SERVICES 0 1,500 1,500 100% 2420-421-430240-368 OVERLAY/CHIPSEALS 148,275 611,354 463,079 76% 2420-421-430240-452 GRAVEL 1,148 6,000 4,852 81% 2420-421-430240-453 EQUIPMENT RENTAL 0 7,500 7,500 100% 2420-421-430240-471 DE-ICER/ROAD OIL 8,337 78,000 69,663 89% 2420-421-430240-472 ASPHALT 9,887 50,000 40,113 80% 2420-421-430240-473 CRACK SEALING 0 20,000 20,000 100% 2420-421-430240-474 PAINT STRIPING MATERIALS 13,514 30,000 16,486 55% ------------------------------------------------- TOTAL GAS TAX 263,414 1,022,317 758,903 74% ================================================= BARSAA 2421-421-430240-354 PAVEMENT MAINTENANCE 0 542,685 542,685 100% ------------------------------------------------- TOTAL BARSAA 0 542,685 542,685 100% ================================================= 2400 LIGHT MAINT. 2400-410-430263-110 SALARIES 42,948 92,131 49,183 53% 2400-410-430263-153 HEALTH INSURANCE 7,779 14,670 6,891 47% 2400-410-430263-155 RETIREMENT 3,442 7,367 3,925 53% 2400-410-430263-244 STREET LIGHT SUPPLIES 178 18,000 17,822 99% 2400-410-430263-245 LUMINAIRES 0 31,000 31,000 100% 2400-410-430263-341 ELECTRICITY 68,913 182,000 113,087 62% 2400-410-430263-360 REPAIR & MAINT SERVICES 12,220 22,500 10,280 46% 2400-410-430263-373 DUES & TRAINING 0 4,000 4,000 100% 2400-410-430263-510 INSURANCE 2,245 2,245 0- -0% 2400-410-430263-522 ADMINISTRATIVE TRANSFER 6,992 13,984 6,992 50% 2400-410-430263-528 INFORMATION TECH TRANSFER 11,139 22,277 11,138 50% 2400-410-430265-944 MACHINERY & EQUIP (replacement fund 0 70,000 70,000 100% ------------------------------------------------- TOTAL LIGHT MAINT. 155,857 480,174 324,317 68% ================================================= 2825 MACI GRANT-SWEEPER 2825-421-430240-940 EQUIPMENT 0 292,481 292,481 100% ------------------------------------------------- TOTAL MACI GRANT 0 292,481 292,481 100% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 19 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210 WATER FUND REVENUE 5210-000-323108-000 PW PLAN REVIEW FEES 4,189 2,000 2,189- -109% 5210-000-343210-000 METERED WATER SALES 3,030,770 4,300,000 1,269,230 30% 5210-000-343220-000 OTHER (CONST.) WATER SALES 39,727 25,000 14,727- -59% 5210-000-343230-000 METER REPLACEMENT FEE 112,333 160,000 47,667 30% 5210-000-343260-000 INSTALL/SALE OF MAT./TOWER RENT/OTH 14,255 71,000 56,745 80% 5210-000-343270-000 WATER TURN ON FEES 2,630 4,000 1,370 34% 5210-000-343275-000 TAG FEE 16,060 33,000 16,940 51% 5210-000-343365-000 LATECOMER ADMIN FEE 5,275 10,000 4,725 47% 5210-000-371010-000 INVESTMENT EARNINGS 139,627 45,000 94,627- -210% 5210-000-371500-000 LEASE INTEREST INCOME 33,768 0 33,768- 0% 5210-000-383010-000 TRANSFER FROM IMPACT FEE FUND (ADMI 17,500 30,000 12,500 42% 5210-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 125,000 250,000 125,000 50% ------------------------------------------------- TOTAL REVENUE 3,541,136 4,930,000 1,388,864 28% ================================================= EXPENSES WATER FACILITIES 5210-447-430550-110 SALARIES-WATER 393,942 873,444 479,502 55% 5210-447-430550-111 SEASONAL SALARIES 0 5,000 5,000 100% 5210-447-430550-121 OVERTIME 7,255 20,000 12,745 64% 5210-447-430550-153 HEALTH INSURANCE 78,698 193,108 114,410 59% 5210-447-430550-155 RETIREMENT 31,825 69,471 37,646 54% 5210-447-430550-210 OFFICE SUPPLIES /EQUIP/COMPUTERS/GI 10,147 24,500 14,353 59% 5210-447-430550-218 NON CAP & SAFETY EQUIP/SUPPLIES 1,703 9,000 7,297 81% 5210-447-430550-226 CHLORINE & CHEMICALS 48,149 70,000 21,851 31% 5210-447-430550-229 JANITORIAL/OTHER SUPPLIES 2,154 4,650 2,496 54% 5210-447-430550-231 GAS & OIL 20,017 35,000 14,983 43% 5210-447-430550-312 POSTAGE & PRINTING/ADVERTISING 18 1,000 982 98% 5210-447-430550-336 LICENSES & FEES 17,712 20,000 2,288 11% 5210-447-430550-341 ELECTRICITY 85,263 168,000 82,737 49% 5210-447-430550-344 NATURAL GAS 4,282 15,500 11,218 72% 5210-447-430550-345 TELEPHONE & COMMUNICATION 5,645 14,500 8,855 61% 5210-447-430550-349 LAB SERVICES 4,020 20,000 15,980 80% 5210-447-430550-352 CONTRACT SERVICES - HOSTING FEES 6,661 27,000 20,340 75% 5210-447-430550-353 AUDITING 0 3,500 3,500 100% 5210-447-430550-354 CONTRACT SERVICES 7,736 56,000 48,264 86% 5210-447-430550-355 NOFFSINGER TRANSMISSION CONDITION A 44,395 140,872 96,477 68% 5210-447-430550-356 BACKBONE CONDITION ASSESS./WTR RIGH 3,540 75,000 71,460 95% 5210-447-430550-362 EQUIP REPAIRS/MAINT/RENTAL 3,516 15,000 11,484 77% 5210-447-430550-366 BUILDING MAINTENANCE 932 15,000 14,068 94% 5210-447-430550-373 DUES & TRAINING 578 14,000 13,422 96% 5210-447-430550-388 MEDICAL SERVICES 248 700 453 65% 5210-447-430550-410 CONSTRUCTION MATERIALS 17,237 50,000 32,763 66% 5210-447-430550-422 HYDRANTS 0 10,000 10,000 100% 5210-447-430550-423 MATERIALS FOR MAINS 10,319 11,000 681 6% 5210-447-430550-424 MATERIALS -SERVICE LINES 6,294 20,000 13,706 69% 5210-447-430550-425 MATERIALS PUMPS/WELLS 2,310 100,000 97,690 98% 5210-447-430550-510 PROPERTY & LIABILITY INS. 44,539 44,539 0- 0% 5210-447-430550-512 UNINSURED LOSS-DEDUCTIBLE 7,199 10,000 2,801 28% 5210-447-430550-521 CENTRAL GARAGE TRANSFER 22,562 45,125 22,563 50% 5210-447-430550-522 ADMINISTRATIVE TRANSFER 62,644 125,287 62,643 50% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 20 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5210-447-430550-528 INFORMATION TECH TRANSFER 37,926 75,851 37,925 50% 5210-447-430550-532 LEASE PAYMENTS 0 4,000 4,000 100% ------------------------------------------------- TOTAL OPERATING EXPENSES 989,463 2,386,047 1,396,584 59% ------------------------------------------------- CAPITAL FROM OPERATING/BONDS 5210-447-430550-925 NOFFSINGER REHAB ALTERNATIVE 44,400 2,124,968 2,080,568 98% 5210-447-430550-935 METER SYSTEM REPLACEMENT 136,641 532,906 396,265 74% 5210-447-430550-940 MACHINERY & EQUIPMENT 0 240,000 240,000 100% 5210-447-430550-951 SECURITY SCADA UPGRADES 566 25,000 24,434 98% 5210-447-430550-952 8TH AVE W R&R (ARPA WTR/SWR PRJ) 0 350,000 350,000 100% 5210-447-430550-954 ELEVATED STORAGE TANK & WELL 625,457 1,241,048 615,591 50% 5210-447-430550-958 2ND AVE W RR FROM CENTER TO 2ND ST 3,785 13,216 9,431 71% 5210-447-430550-967 WELL REPLC & UPSIZE 0 115,000 115,000 100% 5210-447-430550-969 DESIGN - LOWER ZONE RESERVOIRS ROOF 65,203 549,036 483,833 88% 5210-447-430550-970 DESIGN-NORTHWEST WELL #2 0 307,000 307,000 100% ------------------------------------------------- TOTAL CAPITAL FROM OP/BONDS 876,051 5,498,174 4,622,123 84% ------------------------------------------------- CAPITAL OUTLAY - BONDED 5210-447-430551-954 1 MG STORAGE TANK & WELLS (BONDED) 0 10,708,885 10,708,885 100% 5210-447-430551-969 LOWER ZONE RESERVOIRS ROOF REPLC (B 0 7,270,000 7,270,000 100% ------------------------------------------------- TOTAL CAPITAL BONDED 0 17,978,885 17,978,885 100% ------------------------------------------------- WATER BILLING 5210-447-430560-110 SALARIES-WATER BILLING 74,990 145,340 70,350 48% 5210-447-430560-153 HEALTH INSURANCE 12,584 32,937 20,353 62% 5210-447-430560-155 RETIREMENT 5,457 11,194 5,737 51% 5210-447-430560-210 OFFICE & COMPUTER SUPPLIES 4,923 11,500 6,577 57% 5210-447-430560-353 AUDITING 0 2,000 2,000 100% 5210-447-430560-354 GRIZZLY SEC./MAIL ROOM 26,988 55,000 28,012 51% 5210-447-430560-355 BANK & CC FEES/CENTURYLINK 18,733 35,000 16,267 46% 5210-447-430560-356 OTHER CONTRACT SERVICES 395 1,000 605 61% 5210-447-430560-373 DUES & TRAINING 402 4,000 3,599 90% 5210-447-430560-522 ADMINISTRATIVE TRANSFER 6,157 12,314 6,157 50% 5210-447-430560-528 INFORMATION TECH TRANSFER 33,850 67,700 33,850 50% ------------------------------------------------- TOTAL WATER BILLING 184,479 377,985 193,506 51% ------------------------------------------------- REVENUE BONDS/BOI LOANS 5210-447-490200-610 PRIN - 4 MILE DR TRANSMISSION / WRF 0 88,000 88,000 100% 5210-447-490200-620 INT - 4 MILE DR TRANSMISSION / WRF 47,625 47,625 0 0% 5210-447-490204-610 BOND PRIN-HWY 93 S WTR - 2004 0 83,000 83,000 100% 5210-447-490204-620 BOND INT-HWY 93 S WTR 2004 3,679 3,679 0 0% 5210-447-490204-630 BOND FEES-HWY 93 S WTR 2004 0 350 350 100% 5210-447-490206-610 PRIN-WELL/TANK/8114 2.25% 4TH ST 0 95,000 95,000 100% 5210-447-490206-620 INT-WELL&TANK/8114 2.25% 4TH ST WT 10,654 10,654 0 0% 5210-447-490210-610 4TH AVE E MAIN REPL/WRF 17393 0 87,545 87,545 100% 5210-447-490210-620 4TH AVE E MAIN REPL/WFR 17393 38,811 38,811 0- 0% ------------------------------------------------- TOTAL REVENUE BONDS 100,769 454,664 353,895 78% ------------------------------------------------- THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 21 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING DEPRECIATION 5210-447-510400-831 DEPRECIATION EXPENSE 0 950,000 950,000 100% ------------------------------------------------- TOTAL DEPRECIATION 0 950,000 950,000 100% ------------------------------------------------- TOTAL WATER FUND 2,150,761 27,645,755 25,494,994 92% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 22 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING WATER IMPACT FEE REVENUE: 5211-000-343225-000 IMPACT FEES 188,778 700,000 511,222 73% 5211-000-371010-000 INTEREST EARNINGS 14,291 4,000 10,291- -257% ------------------------------------------------- TOTAL WATER IMPACT FEES REVENU 203,069 704,000 500,931 71% ================================================= WATER IMPACT FEES EXPENSES: 5211-447-430555-424 METERS - NEW DEVELOPMENT 27,430 65,000 37,570 58% 5211-447-430555-820 DEBT SERVICE TRANSFER TO 5210 125,000 250,000 125,000 50% 5211-447-430555-825 TRANSFER TO 5210 FOR ADMIN 17,500 35,000 17,500 50% 5211-447-430555-930 CONTRACT MAIN UPSIZE 52,661 766,055 713,394 93% 5211-447-430555-954 ELEVATED TANK & WELL 194,296 493,868 299,572 61% ------------------------------------------------- TOTAL IMPACT FEES 416,887 1,609,923 1,193,036 74% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 23 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310 SEWER FUND REVENUE 5310-000-323108-000 PW PLAN REVIEW FEES 4,189 1,500 2,689- -179% 5310-000-343310-000 SEWER SERVICE CHARGES 4,047,695 7,300,000 3,252,305 45% 5310-000-343360-000 INSTALLATION,SALE OF MAT./OTHER 2,670 1,500 1,170- -78% 5310-000-343365-000 LATECOMER ADMIN FEES 693 2,000 1,307 65% 5310-000-371010-000 INVESTMENT EARNINGS 123,612 31,000 92,612- -299% 5310-000-383010-000 ADMIN TRANSFER FROM IMPACT FEE FUND 50,000 100,000 50,000 50% 5310-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 575,000 1,150,000 575,000 50% ------------------------------------------------- TOTAL REVENUE 4,803,860 8,586,000 3,782,141 44% ================================================= SEWER BILLING COSTS 5310-454-430620-110 SALARIES-SEWER BILLING 66,606 125,965 59,359 47% 5310-454-430620-153 HEALTH INSURANCE 10,723 25,347 14,624 58% 5310-454-430620-155 RETIREMENT - PERD 4,762 9,569 4,807 50% 5310-454-430620-215 OFFICE SUPPLIES/computers 4,951 11,500 6,549 57% 5310-454-430620-353 AUDITING/OTHER CONTRACT SERVICES 0 2,000 2,000 100% 5310-454-430620-354 GRIZZLY SEC./MAIL ROOM 26,989 55,000 28,011 51% 5310-454-430620-355 BANK & CC FEES/CENTURYLINK 18,738 35,000 16,262 46% 5310-454-430620-356 OTHER CONTRACT SERVICES 395 1,000 605 61% 5310-454-430620-373 DUES & TRAINING 225 4,000 3,776 94% 5310-454-430620-522 ADMINISTRATIVE TRANSFER 5,595 11,191 5,596 50% 5310-454-430620-528 INFORMATION TECH. TRANSFER 33,850 67,700 33,850 50% ------------------------------------------------- TOTAL SEWER BILLING COSTS 172,834 348,272 175,438 50% ------------------------------------------------- SANITARY SEWER/COLLECTION 5310-454-430630-110 SALARIES-SANITARY SEWER 168,097 370,013 201,916 55% 5310-454-430630-121 OVERTIME 0 5,500 5,500 100% 5310-454-430630-153 HEALTH INSURANCE 31,017 74,895 43,878 59% 5310-454-430630-155 RETIREMENT 13,572 29,522 15,950 54% 5310-454-430630-210 OFFICE/COMPUTER SUPPLIES/EQUIP 6,771 15,800 9,029 57% 5310-454-430630-218 NON CAP/SAFETY EQUIP & SUPPLIES 6,277 8,500 2,223 26% 5310-454-430630-229 JANITORIAL/OTHER SUPPLIES 692 2,500 1,808 72% 5310-454-430630-231 GAS & OIL 9,138 14,500 5,362 37% 5310-454-430630-312 POSTAGE, PRINTING & ADVERTISING 0 500 500 100% 5310-454-430630-341 ELECTRICITY 19,349 57,000 37,651 66% 5310-454-430630-344 NATURAL GAS 7,036 16,500 9,464 57% 5310-454-430630-345 TELEPHONE & COMMUNICATION 9,765 27,500 17,735 64% 5310-454-430630-353 AUDITING 0 3,000 3,000 100% 5310-454-430630-354 CONTRACT SERVICES 6,582 45,000 38,418 85% 5310-454-430630-355 CONTRACT SERVICES - EVERGREEN MTR R 10,605 31,200 20,595 66% 5310-454-430630-356 CONSULTANTS - MODELING/REVIEWS 6,732 20,000 13,268 66% 5310-454-430630-362 BLDGS/EQUIPMENT MAINTENANCE 2,319 11,500 9,181 80% 5310-454-430630-373 DUES & TRAINING 536 10,250 9,715 95% 5310-454-430630-388 MEDICAL SERVICES 188 650 463 71% 5310-454-430630-410 CONSTRUCTION MATERIALS 3,350 12,000 8,650 72% 5310-454-430630-425 MATERIALS PUMPS/LIFT ST. 16,853 96,000 79,147 82% 5310-454-430630-510 PROPERTY & LIABILITY INS. 25,389 25,389 0 0% 5310-454-430630-512 UNINSURED LOSS-DEDUCTIBLE 10,333 25,000 14,667 59% 5310-454-430630-521 CENTRAL GARAGE TRANSFER 5,487 10,974 5,487 50% 5310-454-430630-522 ADMINISTRATIVE TRANSFER 37,027 74,053 37,026 50% 5310-454-430630-528 INFORMATION TECH TRANSFER 23,150 46,300 23,150 50% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 24 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-454-430630-532 OFFICE RENT / BNSF LEASE 7,096 7,000 96- -1% ------------------------------------------------- TOTAL COLLECTION OPERATING EX 427,360 1,041,046 613,686 59% ------------------------------------------------- CAPITAL FROM OPERATING/BONDS 5310-454-430630-922 L.S. #9 IMPROVEMENTS/DESIGN 708 217,168 216,460 100% 5310-454-430630-950 RR & UPSIZE - WWTP MAIN (34% - 66% 0 93,718 93,718 100% 5310-454-430630-951 5TH ALLEY E, 4TH AVE EN, 7TH AVE EN 0 350,000 350,000 100% 5310-454-430630-954 MN REPL. DESIGN - 1ST & 2ND AVE EN 617,867 1,600,961 983,094 61% 5310-454-430630-956 LIFT STATION COMMUNICATION UPGRADE 0 10,000 10,000 100% 5310-454-430630-958 DESIGN - L.S. #3 IMPROVEMENTS 55,657 464,094 408,437 88% 5310-454-430630-959 L.S. #10 CONTROL PANEL RELOCATION & 0 60,000 60,000 100% 5310-454-430630-960 MANHOLE REHAB/MAIN REPLACEMENT 3,858 50,000 46,142 92% ------------------------------------------------- TOTAL CAP. FROM OP/BONDS 678,091 2,845,941 2,167,850 76% ------------------------------------------------- CAPITAL FROM BONDS 5310-454-430631-922 L.S. #9 IMPROVMENTS 0 1,980,500 1,980,500 100% 5310-454-430631-958 L.S. #3 IMPROVEMENTS 0 3,020,000 3,020,000 100% ------------------------------------------------- TOTAL CAPITAL FROM BONDS 0 5,000,500 5,000,500 100% ------------------------------------------------- CAPITAL FROM EQUIP REPLACEMENT 5310-454-430635-940 MACHINERY & EQUIPMENT (10126) 0 7,200 7,200 100% ------------------------------------------------- TOTAL CAP. FROM EQUIP. REPLACE 0 7,200 7,200 100% ------------------------------------------------- REVENUE BONDS/SANITARY 5310-454-490200-610 PRINCIPAL WESTSIDE INTERCEPTOR BOND 0 302,000 302,000 100% 5310-454-490200-620 INTEREST-WESTSIDE INTERCEPTOR BOND 271,750 271,750 0 0% 5310-454-490204-610 PRINCIPAL - HWY 93 S/SRF5125/2.25% 0 92,000 92,000 100% 5310-454-490204-620 INT-HWY 93 S/SRF5125/2.25% 3,668 3,668 1 0% 5310-454-490206-610 PRINCIPAL LIFT STATION #9 BOND 0 80,000 80,000 100% 5310-454-490206-620 INTEREST LIFT STATION #9 BOND 0 50,921 50,921 100% ------------------------------------------------- TOTAL REVENUE BONDS 275,418 800,339 524,922 66% ------------------------------------------------- DEPRECIATION-SANITARY SEWER 5310-454-510400-831 DEPRECIATION EXPENSE 0 500,000 500,000 100% ------------------------------------------------- TOTAL DEPRECIATION-SANITARY 0 500,000 500,000 100% ------------------------------------------------- TOTAL SANITARY SEWER 1,553,702 10,543,298 8,989,596 85% ------------------------------------------------- WWTP OPERATING 5310-455-430640-110 SALARIES-WWTP 250,995 574,139 323,144 56% 5310-455-430640-111 SEASONAL SALARIES 0 5,000 5,000 100% 5310-455-430640-112 SALARIES-RETIREMENT 5,828 0 5,828- 0% 5310-455-430640-121 OVERTIME 13,021 22,500 9,479 42% 5310-455-430640-153 HEALTH INSURANCE 43,723 117,561 73,838 63% 5310-455-430640-155 RETIREMENT 21,389 45,581 24,192 53% 5310-455-430640-210 OFFICE/COMPUTER SUPPLIES/EQUIP 5,729 14,800 9,071 61% 5310-455-430640-218 SAFETY EQUIP & SUPPLIES 2,492 3,500 1,008 29% 5310-455-430640-225 ALUM 0 42,000 42,000 100% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 25 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5310-455-430640-226 CHLORINE & CHEMICALS 79,508 154,000 74,492 48% 5310-455-430640-229 JANITORIAL/OTHER SUPPLIES/RENTAL 5,222 8,000 2,778 35% 5310-455-430640-231 GAS & OIL 11,357 19,000 7,643 40% 5310-455-430640-312 POSTAGE, PRINTING & ADVERTISING 21 550 529 96% 5310-455-430640-336 LICENSES & FEES 1,608 16,000 14,392 90% 5310-455-430640-341 ELECTRICITY 77,098 195,000 117,902 60% 5310-455-430640-342 WATER 1,487 7,000 5,513 79% 5310-455-430640-344 NATURAL GAS 19,744 82,000 62,256 76% 5310-455-430640-345 TELEPHONE & COMMUNICATION 2,799 15,000 12,201 81% 5310-455-430640-353 AUDITING 0 2,500 2,500 100% 5310-455-430640-354 CONTRACT-GLACIER GOLD 58,036 135,000 76,964 57% 5310-455-430640-355 CONTRACT - LAND FILL & OTHER 34,960 57,500 22,540 39% 5310-455-430640-356 CONSULTANTS 20,739 220,000 199,261 91% 5310-455-430640-358 CONSULTANT- PERMIT/TMDL 6,728 100,000 93,272 93% 5310-455-430640-360 MISC. MAINT SERVICES 19,442 35,000 15,558 44% 5310-455-430640-366 BUILDING MAINTENANCE 11,685 40,000 28,315 71% 5310-455-430640-373 DUES & TRAINING 3,224 10,500 7,276 69% 5310-455-430640-388 MEDICAL SERVICES 160 500 340 68% 5310-455-430640-510 PROPERTY & LIABILITY INS. 78,833 78,833 0- 0% 5310-455-430640-521 CENTRAL GARAGE TRANSFER 9,033 18,065 9,032 50% 5310-455-430640-522 ADMINISTRATIVE TRANSFER 66,549 133,097 66,548 50% 5310-455-430640-528 INFORMATION TECH TRANSFER 24,179 48,357 24,178 50% ------------------------------------------------- TOTAL WWTP OPERATING EXPENSE 875,587 2,200,983 1,325,396 60% ------------------------------------------------- WWTP CAPITAL FM OPERATING/BOND 5310-455-430640-921 DESIGN-DOME FOR SECONDARY CLARIFIER 0 419,000 419,000 100% 5310-455-430640-922 CONSTRUCT NEW FERMENTER (rehab) 0 1,675,500 1,675,500 100% 5310-455-430640-930 BIOSOLIDS ALTERNATE DISPOSAL ENG 0 61,000 61,000 100% 5310-455-430640-933 NEW EQ BASIN 0 2,515,000 2,515,000 100% ------------------------------------------------- TOTAL WWTP CAP. FM OP/BOND 0 4,670,500 4,670,500 100% ------------------------------------------------- WWTP LAB 5310-455-430646-110 SALARIES-WWTP LAB 61,461 136,840 75,379 55% 5310-455-430646-121 OVERTIME 87 0 87- 0% 5310-455-430646-153 HEALTH INSURANCE 7,942 18,424 10,482 57% 5310-455-430646-155 RETIREMENT 4,940 10,792 5,852 54% 5310-455-430646-210 COMPUTER/OTHER SUPPLIES 1,388 7,000 5,612 80% 5310-455-430646-218 NON-CAPITAL EQUIPMENT 6,974 8,500 1,526 18% 5310-455-430646-222 LAB SUPPLIES 9,495 18,500 9,005 49% 5310-455-430646-349 LAB SERVICES 10,100 22,000 11,900 54% 5310-455-430646-350 PRETREATMENT SERVICE 3,829 15,000 11,171 74% 5310-455-430646-362 EQUIPMENT MAINTENANCE 9,759 10,000 241 2% 5310-455-430646-373 DUES & TRAINING 0 5,500 5,500 100% ------------------------------------------------- TOTAL WWTP LAB 115,975 252,556 136,581 54% ------------------------------------------------- WWTP REPLACE(10125) 5310-455-430645-362 EQUIPMENT MAINTENANCE 70,928 153,000 82,072 54% 5310-455-430645-922 DESIGN FERMENTER RECONSTRUCTION 15,902 263,689 247,787 94% 5310-455-430645-934 SECONDARY DIGESTER LID REPLC 17,221 20,000 2,779 14% 5310-455-430645-940 MACHINERY & EQUIPMENT 7,945 123,800 115,855 94% 5310-455-430645-950 RR & UPSIZE - WWTP MAIN (34% - 66% 250 137,500 137,250 100% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 26 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ------------------------------------------------- TOTAL WWTP REPLACEMENT 112,246 697,989 585,743 84% ------------------------------------------------- REVENUE BONDS/WWTP 5310-455-490227-610 PRINCIPAL - WWTP IMP/SRF8164R/2.25% 0 910,000 910,000 100% 5310-455-490227-620 INT-WWTP IMP/SRF8164R/2.25% 102,060 102,060 0 0% 5310-455-490228-610 PRINC - WWTP DIGESTER LID/SRF 13326 0 53,000 53,000 100% 5310-455-490228-620 INT-WWTP DIGESTER LID/SRF13326/3.0% 19,980 19,980 0 0% ------------------------------------------------- TOTAL REVENUE BONDS/WWTP 122,040 1,085,040 963,000 89% ------------------------------------------------- DEPRECIATION 5310-455-510400-831 DEPR. EXP. - WWTP (INCLUDES 010125 0 1,300,000 1,300,000 100% ------------------------------------------------- TOTAL DEPRECIATION 0 1,300,000 1,300,000 100% ------------------------------------------------- TOTAL WWTP 1,225,847 10,207,068 8,981,221 88% ------------------------------------------------- TOTAL BILLING/SANITARY/WWTP 2,779,549 20,750,366 17,970,817 87% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 27 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING SEWER IMPACT FEE REVENUE 5311-000-343330-000 SANITARY IMPACT FEES 489,953 1,000,000 510,047 51% 5311-000-343335-000 TREATMENT IMPACT FEES 274,551 588,000 313,449 53% 5311-000-371010-000 SANITARY INTEREST EARNINGS 42,233 11,000 31,233- -284% 5311-000-371015-000 TREATMENT INTEREST EARNINGS 31,339 9,500 21,839- -230% ------------------------------------------------- TOTAL SEWER IMPACT FEES REVENU 838,077 1,608,500 770,423 48% ================================================= COLLECTION IMP. FEE EXPENSES 5311-454-430635-820 TRANSFER TO 5310 FOR DEBT (SANITARY 250,000 500,000 250,000 50% 5311-454-430635-825 TRANSFER TO 5310 FOR ADMIN 32,500 65,000 32,500 50% ------------------------------------------------- TOTAL COLL. IMP. FEES TRANSFER 282,500 565,000 282,500 50% ------------------------------------------------- CAPITAL FROM COLL. IMP. FEES 5311-454-430635-950 RR & UPSIZE - WWTP MAIN (66% - 34% 0 231,922 231,922 100% 5311-454-430635-955 MAIN & L.S. UPSIZE 0 1,172,000 1,172,000 100% 5311-454-430635-958 DESIGN-L.S #3 IMPROVEMENTS 55,657 392,593 336,936 86% ------------------------------------------------- TOTAL CAP. FM COLL. IMP. FEES 55,657 1,796,515 1,740,858 97% ------------------------------------------------- TOTAL COLL. IMP. FEE EXPENSE 338,157 2,361,515 2,023,358 86% ------------------------------------------------- TREATMENT IMP. FEE EXPENSES 5311-455-430644-820 TRANSFER TO 5310 FOR DEBT 325,000 650,000 325,000 50% 5311-455-430644-825 TRANSFER TO 5310 FOR ADMIN 17,500 35,000 17,500 50% ------------------------------------------------- TOTAL TREATMT IMP. FEES TRANSF 342,500 685,000 342,500 50% ------------------------------------------------- CAPITAL FROM TREATMT IMP. FEES 5311-455-430644-929 CONSTRUCT NEW EQ BASIN 29,527 386,869 357,342 92% 5311-455-430644-930 BIOSOLIDS ALT. DISPOSAL ENG. (39%) 0 39,000 39,000 100% 5311-455-430644-950 RR & UPSIZE - WWTP MAIN (66% - 34% 752 317,500 316,748 100% ------------------------------------------------- TOTAL CAP FM TRTMNT IMP. FEES 30,279 743,369 713,090 96% ------------------------------------------------- TOTAL WWTP IMPACT FEES EXPENSE 372,779 1,428,369 1,055,590 74% ------------------------------------------------- TOTAL SEWER IMPACT FEE EXPENSE 710,936 3,789,884 3,078,948 81% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 28 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5349 STORM SEWER FUND REVENUE 5349-000-323108-000 PW PLAN REVIEW FEES 1,333 1,500 168 11% 5349-000-334040-000 PETRO TANK RELEASE/MONITORING REIMB 4,592 1,000 3,592- -359% 5349-000-343034-000 PERMIT FEES 635 1,500 865 58% 5349-000-343035-000 STORM SEWER CHARGES 0 1,000 1,000 100% 5349-000-343370-000 STORM SEWER ASSESSMENTS (Billed) 2,004,552 1,924,487 80,065- -4% 5349-000-363040-000 PEN & INT ON SPEC ASSESS. 2,163 2,500 337 13% 5349-000-371010-000 INTEREST ON INVESTMENTS 47,778 15,000 32,778- -219% 5349-000-383010-000 IMPACT FEE 5% ADMIN - TFR FROM IMPA 5,000 10,000 5,000 50% 5349-000-383015-000 DEBT SERVICE TRANSFER FROM IMPACT F 0 150,000 150,000 100% ------------------------------------------------- TOTAL REVENUE 2,066,052 2,106,987 40,935 2% ================================================= STORM OPERATING EXPENSES 5349-453-430246-110 SALARIES-STORM SEWER 264,882 575,707 310,825 54% 5349-453-430246-121 OVERTIME 17 4,000 3,983 100% 5349-453-430246-153 HEALTH INSURANCE 44,151 106,252 62,101 58% 5349-453-430246-155 RETIREMENT 21,152 45,839 24,687 54% 5349-453-430246-210 OFFICE/COMPUTER SUPPLIES 8,538 18,500 9,962 54% 5349-453-430246-218 NON CAP. & SAFETY EQUIP. & SUPPLIES 5,724 6,000 276 5% 5349-453-430246-229 OTHER SUPPLIES/TOOLS 294 2,200 1,906 87% 5349-453-430246-231 GAS & OIL 8,699 14,500 5,802 40% 5349-453-430246-345 TELEPHONE & COMMUNICATION 1,048 3,250 2,202 68% 5349-453-430246-353 AUDITING 0 1,150 1,150 100% 5349-453-430246-354 CONTRACT SERVICE 3,319 10,000 6,681 67% 5349-453-430246-356 STORMWATER REG COMPLIANCE PROGRAM 3,143 35,000 31,857 91% 5349-453-430246-358 CONSULTANTS 0 260,000 260,000 100% 5349-453-430246-359 CONSULTANTS-TMDL / PERMIT 0 30,000 30,000 100% 5349-453-430246-360 REPAIR & MAINT SERVICES 339 5,000 4,661 93% 5349-453-430246-362 GROUNDWATER MONITORING 0 6,500 6,500 100% 5349-453-430246-371 CURB & GUTTER 5,676 21,000 15,324 73% 5349-453-430246-373 DUES & TRAINING 301 10,250 9,949 97% 5349-453-430246-388 MEDICAL SERVICES 0 100 100 100% 5349-453-430246-410 CONSTRUCTION MATERIALS 1,842 12,000 10,158 85% 5349-453-430246-510 PROPERTY & LIABILITY INS. 15,340 15,340 0 0% 5349-453-430246-521 CENTRAL GARAGE TRANSFER 5,487 10,974 5,487 50% 5349-453-430246-522 ADMINISTRATIVE TRANSFER 25,095 50,191 25,096 50% 5349-453-430246-528 INFORMATION TECH TRANSFER 21,079 42,157 21,078 50% 5349-453-430246-530 BNSF LEASE PMT 4,496 5,500 1,004 18% ------------------------------------------------- TOTAL STORM OPERATING EXPENSE 440,621 1,291,410 850,789 66% ------------------------------------------------- CAPITAL FROM OPERATING/BONDS ------------------------------------------------- TOTAL CAP. FROM OPERATING/BOND 0 0 0 0% ------------------------------------------------- CAPITAL FROM DES. CAP. PROJECT 5349-453-430247-952 STORM DRAIN CORRECTION (NEW & C/O) 3,503 500,000 496,497 99% 5349-453-430247-954 N. MAIN ST STORMWATER PROJ. 0 252,500 252,500 100% 5349-453-430247-956 WYOMING STREET OUTFALL 0 225,000 225,000 100% 5349-453-430247-957 WEDGEWOOD & SHERWOOD DESIGN/SURVEY 0 50,000 50,000 100% 5349-453-430247-959 REGIONAL FACILITIES & PIPING DESIGN 1,704 50,000 48,296 97% 5349-453-430247-961 NORTH REGIONAL CONVEYANCE SYSTEM 0 50,000 50,000 100% 5349-453-430247-969 1ST AVE W - S. OF CITY SHOPS 74,066 468,981 394,916 84% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 29 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING ------------------------------------------------- TOTAL CAP. FROM DES. CAP. PROJ 79,272 1,596,481 1,517,209 95% ------------------------------------------------- CAPITAL/OTHER FROM REPLACEMENT 5349-453-430249-940 MACHINERY FROM REPLACEMENT 0 62,500 62,500 100% ------------------------------------------------- TOTAL CAPITAL/OTHER FROM REPLA 0 62,500 62,500 100% ------------------------------------------------- REVENUE BONDS 5349-453-490200-610 PRINCIPAL - 4TH AVE E BOND 0 3,188 3,188 100% 5349-453-490200-620 INTEREST-4TH AVE E BOND 1,413 1,413 0- -0% 5349-453-490225-610 PRINCIPAL - REGIONAL FACILITIES 0 99,000 99,000 100% 5349-453-490225-620 INTEREST - REGIONAL FACILITIES 51,013 58,488 7,476 13% ------------------------------------------------- TOTAL REVENUE BONDS 52,426 162,089 109,663 68% ------------------------------------------------- DEPRECIATION 5349-453-510400-831 DEPRECIATION (FUND $40,000) 0 360,000 360,000 100% ------------------------------------------------- TOTAL DEPRECIATION 0 360,000 360,000 100% ------------------------------------------------- TOTAL STORM EXPENSE 572,319 3,472,480 2,900,161 84% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 30 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING STORM SEWER IMPACT FEE REVENUE 5348-000-343033-000 IMPACT FEES 97,137 280,000 182,863 65% 5348-000-371010-000 INTEREST EARNINGS 19,015 6,000 13,015- -217% ------------------------------------------------- TOTAL STORM IMPACT FEES REVENU 116,152 286,000 169,848 59% ================================================= STORM SWR IMPACT FEE EXPENSES 5348-453-430248-820 DEBT SERVICE TRANSFER TO 5349 0 150,000 150,000 100% 5348-453-430248-825 TRANSFER TO 5349 FOR ADMIN 5,000 10,000 5,000 50% ------------------------------------------------- TOTAL IMPACT FEE TRANSFERS 5,000 160,000 155,000 97% ------------------------------------------------- CAPITAL FROM IMPACT FEES 5348-453-430248-959 REG FACILITIES & PIPING DESIGN 1,704 50,000 48,296 97% 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 CAPITAL FROM IMPACT FEES 1,704 330,000 328,296 99% ------------------------------------------------- TOTAL STORM IMPACT FEE EXPENSE 6,704 490,000 483,296 99% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 31 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 5510 SOLID WASTE REVENUE 5510-000-343360-000 SALE OF MAT/AUCTION 0 2,500 2,500 100% 5510-000-343410-000 GARBAGE COLLECTION-ASSESSED 1,278,177 1,094,982 183,195- -17% 5510-000-343420-000 GARBAGE COLLECTION-NOT ASSESSED 28,835 29,185 350 1% 5510-000-363040-000 PEN & INT ON SPEC ASSESS. 1,254 2,000 746 37% 5510-000-371010-000 INVESTMENT EARNINGS 13,385 5,000 8,385- -168% 5510-000-381050-000 INCEPTION OF LOAN - 5 YR GARBAGE TR 0 450,000 450,000 100% ------------------------------------------------- TOTAL REVENUE 1,321,652 1,583,667 262,015 17% ================================================= EXPENSES 5510-460-430840-110 SALARIES-SOLID WASTE 227,812 526,843 299,031 57% 5510-460-430840-121 OVERTIME 4,646 6,500 1,854 29% 5510-460-430840-153 HEALTH INSURANCE 45,666 124,920 79,254 63% 5510-460-430840-155 RETIREMENT 18,518 41,736 23,218 56% 5510-460-430840-213 OFFICE/COMPUTER EQUIP/SUPPLIES 7,255 16,500 9,245 56% 5510-460-430840-218 EQUIPMENT-GARBAGE CONTAINERS 26,003 69,125 43,122 62% 5510-460-430840-229 SAFETY/OTHER SUPPLIES & EQUIPMENT 2,761 5,500 2,739 50% 5510-460-430840-231 GAS & OIL 53,300 73,000 19,701 27% 5510-460-430840-341 ELECTRICITY 466 2,050 1,584 77% 5510-460-430840-344 NATURAL GAS 1,039 4,500 3,461 77% 5510-460-430840-345 TELEPHONE & COMMUNICATION 1,086 3,500 2,414 69% 5510-460-430840-354 CONTRACT SERVICES 3,681 122,000 118,319 97% 5510-460-430840-362 EQUIPMENT MAINT & SUPPLIES 24,163 55,000 30,837 56% 5510-460-430840-366 BUILDING MAINTENANCE 1,181 5,000 3,819 76% 5510-460-430840-373 DUES & TRAINING 360 8,000 7,640 96% 5510-460-430840-388 MEDICAL SERVICES 160 700 540 77% 5510-460-430840-510 PROPERTY & LIABILITY INS. 24,861 24,861 0 0% 5510-460-430840-512 UNINSURED LOSS-DEDUCTIBLE 7,012 4,000 3,012- -75% 5510-460-430840-521 CENTRAL GARAGE TRANSFER 46,020 92,039 46,019 50% 5510-460-430840-522 ADMINISTRATIVE TRANSFER 21,991 43,982 21,991 50% 5510-460-430840-528 INFORMATION TECH TRANSFER 20,989 41,978 20,989 50% 5510-460-430840-820 ALLEY PAVING - TRANSFER TO GAS TAX 20,000 40,000 20,000 50% 5510-460-430840-944 VEHICLES (Replacement $) 0 900,000 900,000 100% 5510-460-510400-831 DEPRECIATION EXPENSE 0 150,000 150,000 100% ------------------------------------------------- TOTAL SOLID WASTE 558,969 2,361,734 1,802,765 76% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 32 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 4290 WALK & CURB CONSTRUCTION 4290-410-430234-937 CONSTRUCTION 13,696 25,000 11,304 45% ------------------------------------------------- TOTAL WALK & CURB CONSTRUCTION 13,696 25,000 11,304 45% ================================================= 4393 AMERICAN RESCUE PLAN PROJ 4393-410-430550-950 LRF PROJECT - L.S. #3 RECOVERY ACT 0 4,720,305 4,720,305 100% 4393-410-430550-951 DOWNTOWN WTR/SWR MAIN ARPA PROJECT 198,781 1,374,049 1,175,268 86% ------------------------------------------------- TOTAL AMERICAN RESCUE PLAN PRO 198,781 6,094,354 5,895,573 97% ================================================= 5720 WATER/SEWER ARPA PROJECT 5720-410-430550-922 WWTP - FERMENTER REHAB 0 1,000,000 1,000,000 100% 5720-410-430550-925 WATER - NOFFSINGER WATER SOURCE 0 1,000,000 1,000,000 100% 5720-410-430550-950 WWTP - INF. PIPE/DIV. STRUCTURE 0 347,957 347,957 100% 5720-410-430550-951 DOWNTOWN WTR/SWR MAIN ARPA PROJECT 0 5,554,001 5,554,001 100% 5720-410-430550-954 SEWER MAIN REPLACEMENT 694,000 694,000 0 0% 5720-410-430550-956 STORMWATER-MAIN & WYOMING ARPA PROJ 0 377,766 377,766 100% 5720-410-430550-969 STORMWATER-ASHLEY CR. DRAINAGE 0 528,264 528,264 100% ------------------------------------------------- TOTAL WTR/SWR ARPA GRANT 694,000 9,501,988 8,807,988 93% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 33 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING CENTRAL GARAGE 6010-410-431330-110 SALARIES 86,314 191,323 105,009 55% 6010-410-431330-121 OVERTIME 0 2,500 2,500 100% 6010-410-431330-153 HEALTH INSURANCE 18,782 36,215 17,433 48% 6010-410-431330-155 RETIREMENT 6,582 14,789 8,207 55% 6010-410-431330-210 OFFICE/COMPUTER SUPPLIES 9,793 19,500 9,707 50% 6010-410-431330-229 NON CAPITAL EQUIP-SAFETY/OTHER 8,040 9,000 960 11% 6010-410-431330-230 OIL 6,685 26,500 19,815 75% 6010-410-431330-231 GAS 782 1,700 918 54% 6010-410-431330-232 VEHICLE PARTS 67,694 144,200 76,506 53% 6010-410-431330-233 TIRES 14,667 58,000 43,333 75% 6010-410-431330-238 FILTERS 5,341 9,500 4,159 44% 6010-410-431330-241 CONSUMABLE TOOLS/BOOKS 0 2,100 2,100 100% 6010-410-431330-341 ELECTRICITY 1,511 5,900 4,389 74% 6010-410-431330-342 WATER 341 2,000 1,659 83% 6010-410-431330-344 NATURAL GAS 2,842 12,500 9,658 77% 6010-410-431330-354 CONTRACT SERVICES 16,614 34,000 17,386 51% 6010-410-431330-360 WASH BAY REPAIRS & MAINTENANCE 155 6,000 5,845 97% 6010-410-431330-362 EQUIP/BLDG MAINTENANCE 693 6,000 5,307 88% 6010-410-431330-373 DUES & TRAINING 462 9,000 8,538 95% 6010-410-431330-388 MEDICAL SERVICES 55 500 445 89% 6010-410-431330-510 INSURANCE 5,328 5,328 1 0% 6010-410-431330-528 INFORMATION TECH TRANSFER 9,851 19,701 9,851 50% ------------------------------------------------- TOTAL CENTRAL GARAGE 262,532 616,256 353,724 57% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 34 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING PARKS & RECREATION REVENUE: 2215-000-311100-000 REAL PROPERTY TAXES 638,323 1,310,000 671,677 51% 2215-000-311200-000 PERSONAL PROPERTY TAXES 15,871 24,675 8,804 36% 2215-000-312000-000 PEN & INTEREST DEL TAXES 1,058 1,500 442 29% 2215-000-334000-000 GRANT - POOL IMPROVEMENTS 0 86,000 86,000 100% 2215-000-346030-000 SWIMMING POOL FEES 91,501 165,000 73,499 45% 2215-000-346040-000 CONCESSION STAND REVENUE 40,687 46,000 5,313 12% 2215-000-346050-000 PARKS USAGE FEES 8,531 20,000 11,469 57% 2215-000-346051-000 RECREATION FEES 18,864 40,045 21,181 53% 2215-000-346052-000 SPORTS PROGRAMS 42,219 91,788 49,569 54% 2215-000-346053-000 SCHOLARSHIPS (DONATIONS) 2,256 3,200 944 30% 2215-000-346054-000 AFTER SCHOOL PROGRAMS 40,159 73,000 32,842 45% 2215-000-346055-000 ICE RINK 434 20,000 19,566 98% 2215-000-346056-000 KIDSPORT USAGE 626 1,600 974 61% 2215-000-346057-000 YOUTH CAMPS 18,455 207,344 188,889 91% 2215-000-346059-000 PICNIC IN THE PARK 9,044 26,500 17,456 66% 2215-000-365010-000 DONATIONS/TELETECH ART ED/FEC REFUN 5,027 0 5,027- 0% 2215-000-365015-000 KIDSPORTS MAINTENANCE 0 19,000 19,000 100% 2215-000-371010-000 INVESTMENTS 11,395 4,800 6,595- -137% 2215-000-381050-000 INCEPTION OF LOAN 0 172,000 172,000 100% 2215-000-381060-000 HEALTH INSURANCE TRANSFER 55,500 111,000 55,500 50% ------------------------------------------------- TOTAL PARKS & REC REVENUE 999,949 2,423,452 1,423,503 59% ================================================= EXPENDITURES PARKS DEPARTMENT: 2215-436-460430-110 SALARIES-PARKS 188,498 387,869 199,371 51% 2215-436-460430-111 SEASONAL SALARIES 22,446 51,878 29,432 57% 2215-436-460430-121 OVERTIME 0 300 300 100% 2215-436-460430-153 HEALTH INSURANCE 31,086 70,540 39,454 56% 2215-436-460430-155 RETIREMENT 17,494 33,821 16,327 48% 2215-436-460430-210 OFFICE/COMPUTER SUPPLIES/EQUIP 441 2,000 1,559 78% 2215-436-460430-215 EQUIPMENT - not capital 0 3,000 3,000 100% 2215-436-460430-224 JANITORIAL SUPPLIES 3,834 7,000 3,166 45% 2215-436-460430-229 OTHER SUPPLIES 1,347 10,000 8,653 87% 2215-436-460430-231 GAS 18,048 19,000 952 5% 2215-436-460430-241 SAFETY/OTHER EQUIPMENT/TOOLS 760 3,000 2,240 75% 2215-436-460430-320 PRINTING & ADVERTISING 178 200 22 11% 2215-436-460430-341 ELECTRICITY 6,543 13,500 6,957 52% 2215-436-460430-343 ICE RINK UTILITIES(REIMB.) 4,549 20,000 15,451 77% 2215-436-460430-344 NATURAL GAS 939 2,200 1,261 57% 2215-436-460430-345 TELEPHONE & COMMUNICATIONS 907 2,500 1,593 64% 2215-436-460430-351 SPORTS COURT & SPORT MAINTENANCE 0 7,550 7,550 100% 2215-436-460430-354 CONTRACT SERVICES-TENNIS,SECURITY 0 2,000 2,000 100% 2215-436-460430-355 CONTRACT SERV. TRAIL MAINT/WEED CON 23,134 40,000 16,866 42% 2215-436-460430-356 CONSULTANTS - PRELIMINARY DESIGN HW 0 40,000 40,000 100% 2215-436-460430-357 CONSULTANTS - PARKS MASTER PLAN 0 100,000 100,000 100% 2215-436-460430-362 EQUIPMENT/BLDG MAINTENANCE 1,061 8,000 6,939 87% 2215-436-460430-364 LANDSCAPE MATERIALS, PERENNIALS & R 1,895 5,500 3,605 66% 2215-436-460430-367 VANDALISM REPAIRS 1,476 4,000 2,524 63% 2215-436-460430-373 DUES & TRAINING 3,237 8,000 4,763 60% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 35 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460430-388 MEDICAL SERVICES/DRUG TESTING 180 600 420 70% 2215-436-460430-395 EQUIPMENT RENTAL 0 700 700 100% 2215-436-460430-420 FENCING/PICNIC TABLES/OTHER 2,156 6,500 4,344 67% 2215-436-460430-440 IRRIGATION SUPPLIES 2,798 6,000 3,202 53% 2215-436-460430-452 GRAVEL, TOP SOIL, SAND AND COMPOST 264 2,000 1,736 87% 2215-436-460430-521 CENTRAL GARAGE TRANSFER 11,882 23,765 11,883 50% 2215-436-460430-545 COUNTY LANDFILL 3,735 6,273 2,538 40% 2215-436-460430-610 DEBT SERVICE PRINCIPAL 16,575 37,685 21,110 56% 2215-436-460430-620 DEBT SERVICE INTEREST 479 1,331 852 64% 2215-436-460430-941 EQUIPMENT - FY 23 TRACTOR 0 43,000 43,000 100% ------------------------------------------------- SUBTOTAL PARKS EXPENDITURES 365,942 969,712 603,770 62% ATHLETIC COMPLEX EXPENDITURES 2215-436-460440-110 SALARIES-COMPLEX 58,249 122,702 64,453 53% 2215-436-460440-111 SEASONAL SALARIES 26,526 45,983 19,457 42% 2215-436-460440-121 OVERTIME 0 300 300 100% 2215-436-460440-153 HEALTH INSURANCE 15,729 30,361 14,632 48% 2215-436-460440-155 RETIREMENT 6,476 11,847 5,371 45% 2215-436-460440-221 SAFETY EQUIPMENT 0 300 300 100% 2215-436-460440-229 OTHER SUPPLIES 2,138 22,000 19,862 90% 2215-436-460440-231 GAS 5,263 10,000 4,737 47% 2215-436-460440-241 CONSUMABLE TOOLS 295 780 485 62% 2215-436-460440-341 ELECTRICITY 6,965 12,000 5,035 42% 2215-436-460440-345 TELEPHONE & COMMUNICATION 49 251 202 81% 2215-436-460440-354 CONTRACT SERVICES 0 21,800 21,800 100% 2215-436-460440-362 EQUIPMENT MAINTENANCE 641 1,000 359 36% 2215-436-460440-364 LANDSCAPING 300 300 0 0% 2215-436-460440-367 VANDALISM REPAIRS 0 500 500 100% 2215-436-460440-373 DUES & TRAINING 70 1,500 1,430 95% 2215-436-460440-388 MEDICAL SERVICES: DRUG TESTING 0 300 300 100% 2215-436-460440-395 RENTAL EQUIPMENT 0 200 200 100% 2215-436-460440-420 METAL PRODUCTS 2,156 7,500 5,344 71% 2215-436-460440-440 IRRIGATION 4,018 7,000 2,982 43% 2215-436-460440-452 SAND & GRAVEL 452 1,500 1,048 70% 2215-436-460440-521 CENTRAL GARAGE TRANSFER 2,950 5,901 2,951 50% 2215-436-460440-545 COUNTY LANDFILL 3,470 3,500 30 1% 2215-436-460440-610 DEBT SERVICE - PRINCIPAL 0 5,000 5,000 100% 2215-436-460440-620 DEBT SERVICE - INTEREST 0 386 386 100% 2215-436-460440-940 EQUIPMENT - FY23 TRUCK & ZERO TURN 12,605 50,000 37,395 75% ------------------------------------------------- SUBTOTAL ATHLETIC COMPLEX 148,352 362,911 214,559 59% RECREATION EXPENDITURES 2215-436-460431-110 SALARIES-RECREATION 45,474 100,317 54,843 55% 2215-436-460431-111 SEASONAL SALARIES 6,871 26,496 19,625 74% 2215-436-460431-121 OVERTIME 8 0 8- 0% 2215-436-460431-153 HEALTH INSURANCE 6,657 22,012 15,355 70% 2215-436-460431-155 RETIREMENT 3,748 10,219 6,471 63% 2215-436-460431-229 MISC. SUPPLIES 7,239 15,020 7,781 52% 2215-436-460431-231 GAS 112 575 463 81% 2215-436-460431-320 PRINTING & ADVERTISING 0 7,850 7,850 100% 2215-436-460431-345 TELEPHONE & COMMUNICATION 499 800 301 38% 2215-436-460431-354 CONTRACT SERVICES 34,737 41,113 6,376 16% THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 36 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-436-460431-357 MUSIC FRANCHISE FEES 392 1,400 1,008 72% 2215-436-460431-373 DUES & TRAINING 169 1,000 831 83% ------------------------------------------------- SUBTOTAL RECREATION 105,905 226,802 120,897 53% YOUTH CAMPS 2215-436-460448-110 SALARIES-YOUTH CAMPS 39,495 89,347 49,852 56% 2215-436-460448-111 SEASONAL SALARIES 104,205 171,201 66,996 39% 2215-436-460448-121 OVERTIME 160- 150 310 207% 2215-436-460448-153 HEALTH INSURANCE 6,224 20,641 14,417 70% 2215-436-460448-155 RETIREMENT 3,254 8,236 4,982 60% 2215-436-460448-224 JANITORIAL SUPPLIES (DAYCAMP FACILI 0 300 300 100% 2215-436-460448-229 MISC. SUPPLIES 1,562 3,675 2,113 58% 2215-436-460448-231 GAS 0 400 400 100% 2215-436-460448-320 PRINTING & ADVERTISING 0 355 355 100% 2215-436-460448-345 TELEPHONE & COMMUNICATION 564 1,250 686 55% 2215-436-460448-354 CONTRACT SERVICES 10,824 20,147 9,323 46% 2215-436-460448-355 AFTER SCHOOL PROGRAM 507 1,200 693 58% 2215-436-460448-356 BANK FEES/CC CHARGES 1,839 6,000 4,161 69% 2215-436-460448-373 DUES & TRAINING 454 1,000 546 55% ------------------------------------------------- SUBTOTAL YOUTH CAMPS 168,766 323,902 155,136 48% PARKLINE TRAIL MAINTENANCE 2215-436-460457-110 SALARIES - PARK LINE TRAIL 22,265 45,874 23,609 51% 2215-436-460457-111 SALARIES - SEASONAL 7,897 21,001 13,105 62% 2215-436-460457-121 OVERTIME 0 300 300 100% 2215-436-460457-153 HEALTH INSURANCE 11,141 13,691 2,550 19% 2215-436-460457-155 RETIREMENT 1,827 3,751 1,924 51% 2215-436-460457-210 OFFICE SUPPLIES - EQUIP / COMPUTERS 56 300 244 81% 2215-436-460457-215 EQUIPMENT - NOT CAPITAL 560 1,300 740 57% 2215-436-460457-224 JANITORIAL SUPPLIES 0 2,200 2,200 100% 2215-436-460457-229 OTHER SUPPLIES (FERTILIZER, WEED SP 41 3,500 3,459 99% 2215-436-460457-231 GAS 1,538 4,000 2,462 62% 2215-436-460457-241 TOOLS / SMALL EQUIP / SAFETY EQUIP 287 700 413 59% 2215-436-460457-341 ELECTRICITY 0 4,000 4,000 100% 2215-436-460457-345 TELEPHONE & COMMUNICATIONS 0 2,235 2,235 100% 2215-436-460457-355 CONTRACT SERVICES - TRAIL MAINT / W 8,382 6,000 2,382- -40% 2215-436-460457-362 EQUIUPMENT / AMENITY MAINTENANCE 132 1,500 1,368 91% 2215-436-460457-364 LANDSCAPE MATERIALS 0 3,000 3,000 100% 2215-436-460457-367 VANDALISM REPAIRS 264 1,200 936 78% 2215-436-460457-373 DUES & TRAINING 70 600 530 88% 2215-436-460457-388 MEDICAL SERVICES - DRUG TESTING 0 100 100 100% 2215-436-460457-395 EQUIPMENT RENTAL 0 500 500 100% 2215-436-460457-440 IRRIGATION SUPPLIES 0 1,200 1,200 100% 2215-436-460457-452 TOP SOIL / MULCH & COMPOST 0 750 750 100% 2215-436-460457-545 COUNTY LANDFILL 0 3,500 3,500 100% 2215-436-460457-610 DEBT SERVICE - PRINCIPAL 0 7,900 7,900 100% 2215-436-460457-620 DEBT SERVICE - INTEREST 0 612 612 100% 2215-436-460457-941 EQUIPMENT - TOOLCAT 0 79,000 79,000 100% ------------------------------------------------- SUBTOTAL PARKLINE TRAIL MAINTE 54,460 208,714 154,254 74% POOL THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 37 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2215-437-460445-111 SEASONAL SALARIES-POOL 119,733 222,525 102,792 46% 2215-437-460445-121 OVERTIME 657 200 457- -229% 2215-437-460445-155 RETIREMENT 1,207 1,500 293 20% 2215-437-460445-210 OFFICE EQUIP/SUPPLIES/PRINTING 309 500 191 38% 2215-437-460445-224 JANITORIAL/SAFETY SUPPLIES 1,606 3,000 1,394 46% 2215-437-460445-226 CHLORINE/CHEMICALS 29,435 48,000 18,565 39% 2215-437-460445-228 CONCESSION STAND SUPPLIES 25,146 23,000 2,146- -9% 2215-437-460445-229 TOOLS/OTHER SUPPLIES 352 4,000 3,648 91% 2215-437-460445-341 ELECTRICITY 4,377 10,500 6,123 58% 2215-437-460445-344 NATURAL GAS 23,543 24,000 457 2% 2215-437-460445-345 TELEPHONE/SECURITY CAMERAS 1,459 9,855 8,396 85% 2215-437-460445-354 LICENSES & FEES 1,498 1,835 337 18% 2215-437-460445-356 BANK FEES/ CC CHARGES 2,730 3,500 770 22% 2215-437-460445-362 BLDG/EQUIPMENT MAINTENANCE 13,284 73,800 60,516 82% 2215-437-460445-367 VANDALISM 0 1,000 1,000 100% 2215-437-460445-380 TRAINING MATERIALS 667 1,800 1,133 63% 2215-437-460445-932 EQUIPMENT / POOL IMPROVEMENTS 0 172,000 172,000 100% ------------------------------------------------- SUBTOTAL POOL EXPENDITURES 226,004 601,015 375,011 62% ------------------------------------------------- TOTAL PARKS & RECREATION/POOL 1,069,428 2,693,056 1,623,628 60% ================================================= 2210 PARKS IN LIEU 2210-436-460430-935 JAXSON RIDGE 0 36,923 36,923 100% 2210-436-460430-936 LAWRENCE PARK IMPROVEMENTS 0 7,423 7,423 100% 2210-436-460430-937 COTTAGE GARDENS 0 9,449 9,449 100% 2210-436-460430-938 3RD AVE APT - LIONS PARK IMPROVEMEN 0 29,659 29,659 100% 2210-436-460430-939 WESTCRAFT - KYAC IMPROVEMENTS SUPPO 0 42,250 42,250 100% ------------------------------------------------- TOTAL PARKS IN LIEU 0 125,704 125,704 100% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 38 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING URBAN FORESTRY 2600-436-460433-110 SALARIES-URBAN FORESTRY 108,958 219,698 110,740 50% 2600-436-460433-111 SEASONAL SERVICES 12,592 50,062 37,470 75% 2600-436-460433-121 OVERTIME 522 1,000 478 48% 2600-436-460433-153 HEALTH INSURANCE 21,500 49,140 27,640 56% 2600-436-460433-155 RETIREMENT 9,137 21,790 12,653 58% 2600-436-460433-229 OFFICE/OTHER SUPPLIES 4,170 4,500 330 7% 2600-436-460433-231 GAS 3,688 7,000 3,312 47% 2600-436-460433-241 CONSUMABLE TOOLS 1,792 5,200 3,408 66% 2600-436-460433-345 TELEPHONE / COMMUNICATIONS 310 662 352 53% 2600-436-460433-354 CONTRACT SERVICES 59,510 170,000 110,490 65% 2600-436-460433-358 EAB MONITORING/ARBOR DAY 0 4,750 4,750 100% 2600-436-460433-362 EQUIPMENT MAINTENANCE 601 4,000 3,399 85% 2600-436-460433-364 LANDSCAPING & TREES 0 8,000 8,000 100% 2600-436-460433-373 DUES & TRAINING 2,719 5,000 2,281 46% 2600-436-460433-388 MEDICAL 75 300 225 75% 2600-436-460433-395 EQUIPMENT RENTAL 1,645 8,000 6,355 79% 2600-436-460433-510 LIABILITY & PROPERTY INSURANCE 7,202 7,202 1 0% 2600-436-460433-521 CENTRAL GARAGE TRANSFER 4,976 9,952 4,976 50% 2600-436-460433-522 ADMINISTRATIVE TRANSFER 12,233 24,465 12,232 50% 2600-436-460433-528 INFORMATION TECHNOLOGY TRANSFER 4,836 9,671 4,835 50% 2600-436-460433-610 DEBT SERVICE PRINCIPAL 0 8,000 8,000 100% 2600-436-460433-620 INTEREST EXPENSE 0 620 620 100% 2600-436-460433-940 MACHINERY & EQUIPMENT 25,898 80,000 54,102 68% ------------------------------------------------- TOTAL URBAN FORESTRY 282,363 699,012 416,649 60% ================================================= 2601 DEVELOPER TREES 2601-436-460430-350 ADMIN 5% 0 1,798 1,798 100% 2601-436-460435-351 EMPIRE ESTATES ($44,911) 0 8,653 8,653 100% 2601-436-460435-352 APPLEWAY ($4,564) 0 4,336 4,336 100% 2601-436-460435-353 SIDERIUS - JAXSON RIDGE 0 8,861 8,861 100% 2601-436-460435-354 PW - WEST SIDE INT 0 5,548 5,548 100% 2601-436-460435-356 SINOPAH SUBD ($5,790) 0 667 667 100% 2601-436-460435-357 COTTONWOOD SUBD ($13,100) 0 1,928 1,928 100% 2601-436-460435-359 MTN VISTA ESTATES ($35,903+34,660) 0 14,849 14,849 100% 2601-436-460435-360 OWL VIEW TH ($3,780) 0 3,780 3,780 100% 2601-436-460435-361 VILLAGE GREENS PHASE 19 ($16,497) 0 15,551 15,551 100% 2601-436-460435-362 WESTVIEW BUSINESS CNTR ($1,618) 0 948 948 100% 2601-436-460435-363 MUSKRAT SLOUGH ($1,446) 0 1,390 1,390 100% 2601-436-460435-364 MTN VISTA ESTATES IV 0 17,300 17,300 100% 2601-436-460435-365 VILLAGE GREENS $3,540 0 1,012 1,012 100% 2601-436-460435-366 W VIEW ESTATES $20,060 0 12,736 12,736 100% 2601-436-460435-367 ABIGAIL SUBDIVISION ($4,253.90) 0 2,716 2,716 100% 2601-436-460435-368 NORTHLAND SUBD PHASE 4 0 16,407 16,407 100% 2601-436-460435-369 ADLER HOMES - SANTA PROP. ($1,776) 0 1,687 1,687 100% 2601-436-460435-370 GL VILLAGE GREENS PH22C ($5,600) 0 5,233 5,233 100% 2601-436-460435-371 NORTHLAND PH. 5 ($15,989) 0 15,190 15,190 100% 2601-436-460435-372 GL VILLAGE GREENS, PH 21 ($11,103. 0 9,412 9,412 100% ------------------------------------------------- TOTAL DEVELOPER TREES 0 150,002 150,002 100% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 39 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING DEVELOPMENT SERVICES 2394 BUILDING DEPARTMENT REVENUE: 2394-000-323101-000 BUILDING PERMITS 351,424 800,000 448,576 56% 2394-000-323103-000 PLUMBING PERMITS 42,632 70,000 27,368 39% 2394-000-323104-000 MECHANICAL PERMITS 28,092 70,000 41,908 60% 2394-000-323105-000 ELECTRICAL PERMITS 36,581 90,000 53,419 59% 2394-000-323108-000 PLAN REVIEW FEES 168,609 325,000 156,391 48% 2394-000-371010-000 INVESTMENT EARNINGS 30,557 11,500 19,057- -166% ------------------------------------------------- TOTAL REVENUE 657,895 1,366,500 708,605 52% ================================================= BUILDING EXPENDITURES: 2394-420-420530-110 SALARIES-BUILDING DEPT. 283,208 646,981 363,773 56% 2394-420-420530-112 SALARIES-SEVERANCE 0 28,378 28,378 100% 2394-420-420530-121 OVERTIME 12,829 20,000 7,171 36% 2394-420-420530-153 HEALTH INSURANCE 50,667 121,556 70,889 58% 2394-420-420530-155 RETIREMENT 24,295 51,100 26,805 52% 2394-420-420530-210 COMPUTER/OTHER SUPPLIES 17,359 70,000 52,641 75% 2394-420-420530-231 GAS & OIL 2,471 5,000 2,529 51% 2394-420-420530-320 POSTAGE/PRINTING/CODE BOOKS 6,925 6,000 925- -15% 2394-420-420530-323 ST. ED. ASSESSMENTS 0 7,500 7,500 100% 2394-420-420530-345 TELEPHONE & COMMUNICATION 3,854 7,500 3,646 49% 2394-420-420530-353 AUDITING 0 5,500 5,500 100% 2394-420-420530-354 CONTRACT SERVICES 2,164 40,000 37,836 95% 2394-420-420530-355 LICENSING FEE 19,046 25,000 5,954 24% 2394-420-420530-356 ArcGIS SERVER UPGRADE LICENSE 8,839 8,500 339- -4% 2394-420-420530-357 CREDIT CARD / PAYPAL FEES 7,401 15,000 7,599 51% 2394-420-420530-360 FURNITURE 0 7,500 7,500 100% 2394-420-420530-373 DUES & TRAINING 8,888 30,000 21,112 70% 2394-420-420530-510 PROPERTY INSURANCE 14,088 14,088 0- 0% 2394-420-420530-521 CENTRAL GARAGE TRANSFER 1,329 2,658 1,329 50% 2394-420-420530-522 ADMINISTRATIVE TRANSFER 21,378 42,756 21,378 50% 2394-420-420530-528 INFORMATION TECHNOLOGY TRANSFER 53,384 106,767 53,383 50% 2394-420-420530-944 VEHICLE (FY22) 31,062 127,500 96,438 76% ------------------------------------------------- TOTAL BUILDING DEPT. 569,187 1,389,284 820,097 59% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 40 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2188 WESTSIDE TIF REVENUE 2188-000-371010-000 INVESTMENT EARNINGS 3,286 2,500 786- -31% 2188-000-373010-000 INTEREST / LOANS 6,770 13,425 6,655 50% 2188-000-373020-000 PRINCIPAL / LOANS 9,868 19,851 9,983 50% 2188-000-383005-000 TRANSFER FROM DEBT SERVICE (3188) 150,000 600,000 450,000 75% ------------------------------------------------- TOTAL REVENUE 1,397,006 3,541,562 2,144,556 61% ================================================= EXPENDITURES 2188-480-470230-110 SALARIES 21,951 57,392 35,442 62% 2188-480-470230-153 HEALTH INSURANCE 3,102 10,341 7,239 70% 2188-480-470230-155 RETIREMENT 1,823 4,682 2,859 61% 2188-480-470230-353 AUDIT 0 1,500 1,500 100% 2188-480-470230-356 TELEPHONE 96 192 96 50% 2188-480-470230-522 ADMINISTRATIVE TRANSFER 717 1,434 717 50% 2188-480-470230-720 TIF DISTRIBUTION/ or REDEVELOPMENT 21,659 300,000 278,341 93% ------------------------------------------------- TOTAL WESTSIDE TIF 49,348 375,541 326,194 87% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 41 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2180 DOWNTOWN TIF 2180-480-470230-110 SALARIES 14,336 42,049 27,713 66% 2180-480-470230-153 HEALTH 2,081 8,187 6,106 75% 2180-480-470230-155 RETIREMENT 1,189 3,462 2,273 66% 2180-480-470230-353 AUDITING 0 1,500 1,500 100% 2180-480-470230-354 CONTRACT SERVICES - CORRIDOR STUDY 0 75,000 75,000 100% 2180-480-470230-356 LEGAL SURVEY/TITLE SEARCH/APPRAISAL 60 1,500 1,440 96% 2180-480-470230-720 PARKING STRUCTURE REIMBURSEMENT 0 150,000 150,000 100% 2180-480-470230-840 REDEVELOPMENT ACTIVITY 0 160,000 160,000 100% ------------------------------------------------- TOTAL 2180 AIRPORT TIF 17,666 441,698 424,032 96% ================================================= 2185 AIRPORT TIF 2185-000-430300-840 REDEVELOPMENT ACTIVITY 43,050 214,339 171,289 80% ------------------------------------------------- TOTAL 2185 AIRPORT TIF 43,050 214,339 171,289 80% ================================================= OLD SCHOOL TIFS 2310-480-470210-355 GLACIER INVESTMENTS -TIF REIMBS. 0 10,000 10,000 100% 2310-480-470210-356 FED-EX REIMBURSEMENT 8,151 10,000 1,849 18% 2310-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 25,000 50,000 25,000 50% 2311-480-470210-820 OPERATING TRANSFER TO 3644 DEBT SER 3,000 6,000 3,000 50% ------------------------------------------------- TOTAL OLD SCHOOL TIFS 36,151 76,000 39,849 52% ================================================= GLACIER RAIL PARK TEDD 2312-480-470210-110 SALARIES & WAGES 2,110 17,090 14,980 88% 2312-480-470210-153 HEALTH INSURANCE 379 4,765 4,387 92% 2312-480-470210-155 RETIREMENT 176 1,406 1,230 87% 2312-480-470210-345 TELEPHONE 0 48 48 100% 2312-480-470210-353 AUDIT 0 1,500 1,500 100% 2312-480-470210-522 ADMINISTRATIVE TRANSFER 717 1,434 717 50% 2312-480-470210-795 REDEVELOPMENT - FCEDA REIMB. 29,238 75,000 45,762 61% 2312-480-470210-796 REDEVELOPMENT/SIDEWALK 0 100,000 100,000 100% ------------------------------------------------- TOTAL GLACIER RAIL PARK TEDD 32,619 201,243 168,624 84% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 42 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2880 COM DEV REVOLVING FUND 2880-480-470210-353 AUDITING 0 1,000 1,000 100% 2880-480-470210-354 CONTRACT SERVICES 390 1,500 1,110 74% 2880-480-470210-711 REDEVELOPMENT 0 55,000 55,000 100% ------------------------------------------------- TOTAL LOAN REVOLVING 390 57,500 57,110 99% ================================================= 2881 CD LOAN REV. #2 2881-480-470210-354 CONT SERV (LOAN SOFTWARE, ETC) 0 405 405 100% 2881-480-470210-711 REDEVELOPMENT 0 50,000 50,000 100% ------------------------------------------------- TOTAL 2881 CD REV. #2 0 50,405 50,405 100% ================================================= 2886 CD MISC. ------------------------------------------------- TOTAL CD MISC. 0 0 0 0% ================================================= 2887 RURAL DEVELOPMENT #1 2887-480-470210-610 DEBT SERVICE/PRIN-L#61-01 22,074 19,396 2,678- -14% 2887-480-470210-620 INTEREST EXPENSE/L#61-01 0 2,678 2,678 100% 2887-480-470210-750 REDEVELOPMENT LOANS 0 170,000 170,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #1 22,074 192,074 170,000 89% ================================================= 2888 RURAL DEVELOPMENT #2 2888-480-470210-354 CONT SERV (LOAN SOFTWARE) 0 500 500 100% 2888-480-470210-610 DEBT SERVICE/PRIN-L#61-03 10,025 8,638 1,387- -16% 2888-480-470210-620 INTEREST EXPENSE-USDA LOAN 61-03 0 1,387 1,387 100% 2888-480-470210-750 REDEVELOPMENT LOANS 0 289,000 289,000 100% ------------------------------------------------- TOTAL RURAL DEVELOPMENT #2 10,025 299,525 289,500 97% ================================================= THE CITY OF KALISPELL, MONTANA01.31.2023 17:19 gb8501_pg.php/Job No: 97058 Page 43 of 43 USER: AIMEE FY23 FINANCIAL REPORT FY23 THRU DEC 31 50.00 % Yr Complete For Fiscal Year: 2023 / 12 G/L ACCOUNT NUMBER FUND ACCOUNT NUMBER DESC. ACTUAL YTD FINAL BUDGET REMAINING % REMAINING 2945 SAMARITAN HOUSE GRANT 2945-480-470243-790 SAMARITIN HOUSE PROJECT 15,000 30,000 15,000 50% ------------------------------------------------- TOTAL SAMARITAN HOUSE GRANT 15,000 30,000 15,000 50% ================================================= 2953 EPA BROWNFIELDS 2953-480-470210-353 CONT. SERV - (STATE PETRO REIMB) 26,481 27,596 1,115 4% 2953-480-470210-354 CONT SERV/PETROLEUM 1,628 688 940- -137% 2953-480-470210-373 TRAVEL/PETROLEUM 809 0 809- 0% 2953-480-470215-354 CONT SERV/HAZARDOUS 47 0 47- 0% 2953-480-470215-373 TRAVEL/HAZARDOUS 107 1,905 1,798 94% ------------------------------------------------- TOTAL EPA BROWNSFIELD 29,073 30,189 1,116 4% ================================================= 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 IMROVEMENTS - LIGHT/FENCING 0 394,187 394,187 100% ------------------------------------------------- TOTAL 2974 FY21 AIRPORT GRANT 0 394,187 394,187 100% ================================================= 2991 TIGER GRANT ------------------------------------------------- TOTAL TIGER GRANT 0 394,187 394,187 100% =================================================