Kenyon/City Hall/Meetings/July 30, 2024
Work session

Kenyon City Council, July 30, 2024

The City Council held a special work session on July 30, 2024, beginning at 1:00 p.m., to review the draft 2025 levy and the department budgets funded by it. Finance Director Whitney Kyllo walked the council through local government aid and small-town aid, and department heads presented their proposed budgets.

0motions
no split votes
4present
0resolutions
$5,629,976largest figure
Norecording posted
budget levy public safety library parks and pool economic development staffing capital equipment

What happened

  1. Work session convened 1:00 p.m. and adjourned 3:10 p.m.; no formal votes taken
  2. $20,000 added to the EDA budget for 3 to 5 façade improvement programs
  3. Proposal to lump property and liability insurance costs into the general fund instead of individual funds
  4. Library line items mostly flat; a 10% funding increase from the County will cover other library expenses
  5. Police: encrypted radios needed at $5,000 each; department to receive $36,000 in local government aid; new squad car arriving in 2024
  6. Fire: $15,900 budgeted for three new radios because Motorola no longer supports older radios
  7. Public works: F350 to be traded for an F550 or F650; skid steer loader upgrade keeping attachments; $1,500 GIS cost added; $10,000 for cameras at the pool and park
  8. Pool chemical and utility budgets increasing; 2025 pool rates need review; mowing costs suggested to be designated to parks
  9. Council's first priority is hiring a long-term city administrator, advertised August 14; second is the comprehensive and classification plan
  10. Leases paid off in 2024 should reduce the levy; CDs and investments now earn 5%, up from .05%; attorney and engineer costs increased by 50%
  11. Draft budget showed an 8% maximum preliminary levy; maximum must be adopted by end of September and final levy by end of December

What was asked 26 raised · 11 settled

Every question, assignment, pending figure and unsourced claim from this meeting, quoted from the record, each checked against the county, census, listing, bid and budget data we hold.

11 what happened next11 partly answered4 we hold no data
Pendingfrom the minutes
Discuss Options for Maximum 2025 Levy The maximum proposed levy increase must be adopted by the council by the end of September.

Discussion of options for the maximum 2025 levy during the budget work session.

What happened next

Resolution 2024-21 adopting the 2025 preliminary budget and levy at a maximum of 9.55% was adopted in the October 8 2024 record, on a motion by Ryan seconded by Bailey with a roll call of Bailey, Sjolander and Ryan all aye. The certification rule was stated correctly: the preliminary maximum goes to Goodhue County by the end of September, the final levy by the end of December, and it can be lowered but never raised. Kenyon has used that room only once in our records, cutting the 2026 levy from a 9.93% maximum to 9.18% final.

10-8-24_AGENDA; 10.14.25_Council_Packet__Agenda; taxes/levy.html · taken up again 2024-10-08

To look upfrom the minutes
Discuss Options for Maximum 2025 Levy The maximum proposed levy increase must be adopted by the council by the end of September. The draft budget showed an 8% maximum levy, but this is only preliminary.

Council reviewed draft levy options at the work session.

At the meetingNo final percentage was set at the work session.

What happened next

The 8% draft did not hold. By the time the council adopted the preliminary levy it had risen to a maximum of 9.55%, and the final levy stayed at 9.55% rather than being trimmed. In dollars that set the 2025 levy at $1,400,000. The pattern repeated the following year from the other direction, when the 2027 draft opened at 19.50% on July 14 2026, fell to 10.34% on August 6 and was certified at 9.26%.

The work session presented 8% as the draft maximum, but the maximum the council actually certified seven weeks later was 9.55%, and the final levy was never brought back down.

10-8-24_AGENDA; 12.10.24_Council_Packet_and_Agenda_Updated; taxes/levy.html · taken up again 2024-12-10

Pendingfrom the minutes
After the maximum levy is adopted, it cannot be increased but can be decreased. The final levy and budget must be adopted by the end of December.

Timeline for the 2025 budget process.

What happened next

Resolution 2024-28 adopted the budget and set the final 2025 tax levy, with the packet noting the December 30 2024 statutory deadline and staff recommending the final stay at the 9.55% maximum approved in September. The certified result was a 2025 levy of $1,400,000, a 9.55% increase.

12.10.24_Council_Packet_and_Agenda_Updated; taxes/levy.html · taken up again 2024-12-10

Action itemfrom the minutes
This would increase the fuel costs to the parks. 10 The city council's first priority is to hire a long-term competent city administrator, which will be advertised August 14.

Council identified hiring a permanent city administrator as its first priority in the 2025 budget discussion.

What happened next

The recruitment ran on schedule and produced a hire. Finalist interviews were held October 29 2024, an offer went to one of three candidates, and the council adopted Resolution 2024-26 approving the city administrator hiring on November 12 2024 by roll call 5-0-0. The search was run by South Central Service Cooperative under Mike Humpal at $14,500, awarded in July 2024 over David Drown Associates.

8-20-24_AGENDA; 11.12.24_Council_Packet_And_Agenda; KENYON_BIDS.md · taken up again 2024-11-12

QuestionLiquor Store Manager Matt Bartelfrom the minutes
Liquor Store Manager Bartel stated there were no major increases for the liquor store. A question for the future is whether the liquor store will begin offering THC products.

Bartel reported no major increases for the liquor store but raised THC sales as a future question.

At the meetingNo answer given; identified as a question for the future.

What happened next

Yes. On April 8 2025 Manager Bartel told the council he was considering THC drinks and gummies on the off-sale side, noting that many public and private stores were benefiting from those sales, and the council voted on a motion by Brunner seconded by Bailey to authorize him to move forward with registering. The same meeting approved 4-0-0 letting him start the process of expanding the Muni into the city-owned former NAPA building at 641 2nd Street with a separate off-sale entrance. Card processing at the liquor store has grown alongside, from $18,515 in 2024 to $22,956 in 2025.

4-8-25_council_packet; KENYON_IT_SPEND.md · taken up again 2025-04-08

Requestfrom the minutes
The suggestion was made for all mowing costs to be designated to the parks department rather than spreading it out between the other departments.

Suggestion made during review of the parks budget.

At the meetingNoted that this would increase the fuel costs to the parks; no decision recorded.

What happened next

Mowing costs were not consolidated. The April 2025 check register still splits fuel four ways, police $807.59, streets and public works $547.71, sewer $124.73 and parks $39.68, a total of $1,519.71 on one account. Parks fuel then jumped to $391.52 in May 2025 as the mowing season opened, which is a tenfold rise on a line that would be flat and much larger if all mowing had been moved to parks. No council decision on the suggestion appears in our record.

5-13-25_council_packet_updated; 6-10-25_COUNCIL_PACKET_Updated · taken up again 2025-06-10

Unsourced claimFinance Director Whitney Kyllofrom the minutes
This will be discussed more at the August 2024 City council meeting. Finance Director Kyllo stated that some leases were paid off in 2024, so that should reduce the levy amount.

Factors that could lower the 2025 levy.

What happened next

Retired leases did not reduce the levy. The August 29 2024 work session shows the debt service tax levy for taxes payable 2025 at $323,207, up from $276,515 in 2024, an increase of $46,692 or 16.9%, because of new bond issuances. Debt service kept pushing after that: the 2026 draft budget opened at a 27.06% maximum levy, driven by a new 2025A general obligation bond payment plus a 2023A bond payment that had been missed in 2025. By pay 2026 the bond rate had risen 35.91% while the general rate fell 0.38%.

Leases retired in 2024 were offered as a reason the levy would fall, but the debt service levy rose from $276,515 to $323,207 for taxes payable 2025 and kept rising, and a 2023A bond payment was missed in 2025 entirely.

8-29-24_work_session; 9-9-25_Council_Packet; taxes/levy.html · taken up again 2025-09-09

Action itemFinance Director Whitney Kyllofrom the minutes
CDs and investments are earning 5%, which has increased from .05%. The city could look into applying for more grants to save money.

Suggestion for reducing levy pressure in 2025.

What happened next

The city did pursue grants, with mixed results. Staff tracked that DEED runs Redevelopment Grant rounds every six months and advised applying close to the start of project activity. In August 2025 staff recommended reapplying for a competitive grant the city had lost in 2023, noting it is one of very few programs funding that type of work. The city and the developer went on to win a DEED grant for the Rebound project, and Kenyon also has access to the League of Minnesota Cities Grant Navigator, worth up to $5,000 per city against a $500,000 program cap. Depot Park's shelters came from a $10,000 SMIF grant.

2.11.25_Council_Packet__Agenda; 8.12.25_Council_Packet__Agenda_Updated; GRANTS.md; KENYON_DEPOT_PARK.md · taken up again 2025-08-12

PendingCity Engineer Derek Olingerfrom the minutes
There are still a few minor control issues that will be resolved prior to final completion; however, the lift station is operational, and sewer flow has been diverted.

Project status update; the lift station is operational and sewer flow has been diverted.

What happened next

The minor control issues were not minor in duration. In September 2024 the contractor was still waiting on parts for the lift station controls, with drainage in the green space around the station also needing work. By November 2024 the contract's final completion date of September 27 had passed, the punch list was still open, and BCM had been notified that further delays would bring liquidated damage deductions from the final payment, with resident Diane Barrett telling the council she was disappointed the work was not getting done. Closeout, with Pay Application No. 12 and Change Order No. 2, did not reach the council until August 2025.

The control issues were described in July 2024 as minor and to be resolved before final completion, but they outlasted the September 27 2024 completion date and triggered a liquidated damages warning to the contractor in November 2024.

9.10.24_Council_Packet_and_Agenda; 11.12.24_Council_Packet_And_Agenda; 8.12.25_Council_Packet__Agenda_Updated · taken up again 2025-08-12

PendingCity Engineer Derek Olingerfrom the minutes
Major items of work remaining include final yard/turf restoration, disconnections from the old pearl creek sewer line, and final televising/inspections of new sewer lines.

Status of major work items outstanding on the 2023 Pearl Creek project.

What happened next

Two of the three remaining items closed within about six weeks. By the October 8 2024 report, final paving, full disconnection from the old Pearl Creek sewer main, and fine grading and seeding were done, leaving final pipeline testing held up waiting for parts. Pay Application No. 8 of $66,188.50 for work through August 30 2024 was approved 3-0-0. Yard restoration around the lift station carried into the November pay estimate, and the project closed out in August 2025.

9.10.24_Council_Packet_and_Agenda; 10-8-24_AGENDA; 8.12.25_Council_Packet__Agenda_Updated · taken up again 2025-08-12

PendingCity Engineer Derek Olingerfrom the minutes
Review Preliminary Engineering Report w/ Council Regular Sept. Meeting  Review & discuss budget and scope  Modify as needed before public notices/meetings/hearings Hold Neighborhood Informational Meeting Early October  Informal opportunity for residents to learn about project Hold Public Improvement Hearing Regular October Meeting  Public opportunity to voice opinions to council  Council considers formal approval of project scope & final design SOURCE OF FUNDING: Future Project Financing REQUESTED COUNCIL

Anticipated schedule of reviews and approvals for the 2025 street and utility project.

At the meetingNo council action requested; information only.

What happened next

The schedule held through the hearing stage. The feasibility report was reviewed at the September 2024 meeting, notices were published and mailed, and the public improvement hearing took place at the regular October 2024 council meeting. The September 2024 packet carries the report's cost summary: city costs of $3,090,887.05, made up of $1,121,166.65 non-assessable street and site, $33,606.10 sidewalk, $732,212.50 sanitary sewer, $936,991.80 watermain and $266,910.00 storm sewer, plus $567,222.85 in assessable costs, or 15.5% of the total. The project then took two bid rounds, with every bid rejected June 10 2025 before Fitzgerald was awarded $2,294,629.25 on July 8 2025.

9.10.24_Council_Packet_and_Agenda; 10-8-24_AGENDA; KENYON_BIDS.md · taken up again 2024-10-08

Pendingfrom the minutes
The plan does increase the wage figures in all budgets. This will be discussed more at the August 2024 City council meeting.

Council's second priority, which increases wage figures in all department budgets.

Partly answered

The plan was built and brought forward, but no adoption vote appears in our holdings. The August 29 2024 work session describes its construction: a consultant scored every job description against responsibility criteria and sorted the positions into nineteen vertical grades across six departments, Administration, Public Works, Kenyon Utility, Finance, Library and Liquor Store, with the compensation plan built from collected market data. The August 20 2024 packet carries it as an approval item. A council motion adopting the Classification and Compensation Plan would settle it.

8-20-24_AGENDA; 8-29-24_work_session

Action itemPublic Works Superintendent Wayne Ehrichfrom the minutes
It would cost $10,000 for cameras at the pool and park. The pool rates need to be reviewed on for the 2025 year.

Review of the pool budget, where chemical and utility costs are rising.

Partly answered

No 2025 pool rate schedule appears in our holdings, but the ledgers show why a review was called for. Pool expense ran $28,252.27 actual in 2024 against a $32,700 budget, then was budgeted at $35,000 for both 2025 and 2026 with $32,142.35 spent by the time of the December 2025 report. On the revenue side pool fees carry $30,000 with $24,125.41 recorded and concessions $5,000 with $3,532.07 recorded, so total pool revenue of roughly $27,700 sits about $7,300 short of the $35,000 expense budget. A proposed rate schedule with cost recovery targets would settle the rate question itself.

12.2.25_Special_Council_Meeting; 4-8-25_council_packet

Unsourced claimPolice Chief Jeff Sjoblomfrom the minutes
Police Chief Sjoblom provided an update on the police department proposed 2025 budget. He stated that encrypted radios are needed. They cost $5,000 each.

Police department 2025 budget presentation.

Partly answered

No vendor quote and no unit count for police encrypted radios appears in our holdings. The fire department's figure from the same work session supports the order of magnitude: $15,900 budgeted for three Motorola radios is $5,300 each, against the $5,000 each the police chief quoted. A quote and a radio count would settle the total exposure.

8-20-24_AGENDA

Unsourced claimFire Chief Wayne Ehrichfrom the minutes
Fire Chief Wayne Ehrich provided a summary of the proposed 2025 Fire Department and First Responder budgets. Motorola no longer supports their older radios, so $15,900 is being budgeted for three new radios.

Fire Department and First Responder 2025 budget summary.

Partly answered

The arithmetic is consistent, $15,900 for three radios is $5,300 each, but we hold no Motorola end-of-support notice and no quote. The replacement program did continue past 2025: the fire chief attributed the $1,658.17 increase in the 2026 fire budget mainly to replacing pagers and radios along with higher property insurance.

8-20-24_AGENDA; 12.9.25_Council_Agenda_and_Packet_Updated

To look upPolice Chief Jeff Sjoblomfrom the minutes
Funds were allocated in prior years to purchase a new squad car that will be arriving in 2024. The police department will be receiving local government aid in the amount of $36,000.

Police 2025 budget presentation on revenue sources.

Partly answered

The police department receives no local government aid at all. Account 101-42100-33401, local government aid in the police fund, carries $0.00 in every column across 2023 through 2026. The money the chief was describing is state police aid, account 101-42100-33421, which ran $32,667.77 actual in 2023, $37,835.00 actual in 2024, and was budgeted at $33,000 for 2025 and $40,000 for 2026. The state aid certification would confirm the award letter figure.

The chief described $36,000 of local government aid to the police department, but the ledger shows police local government aid at zero in every year and budgets the comparable state police aid at $33,000 for 2025.

12.2.25_Special_Council_Meeting

Unsourced claimfrom the minutes
There will be increases in benefits and salaries per council approval. A 10% increase in funding from the County will cover other library expenses.

Review of the library budget, where most line items remained flat.

Partly answered

No county funding commitment letter or figure is in our holdings, so the 10% claim cannot be checked. What our records do show is the library's funding structure and its cost drivers: the library levy fund draws on tax levy, a county contract through SELCO, donations and fines, and the 2026 library budget came in at a 9.44% levy increase driven by wages, automation and utilities. The automation line ran $4,892 in 2024 and $4,956 in 2025 against $6,500 budgeted for 2026 and 2027, consistent with the $347.55 a month the city pays SELCO for ILS support plus $230 a year for hosting.

9-9-25_Council_Packet; 12.9.25_Council_Agenda_and_Packet_Updated; KENYON_IT_SPEND.md

Unsourced claimFinance Director Whitney Kyllofrom the minutes
Twenty thousand dollars was added to the Economic Development Authority budget for 3 to 5 façade improvement programs.

Review of the draft 2025 EDA budget.

Partly answered

The $20,000 spread over three to five facade projects works out to $4,000 to $6,667 per project. We hold no facade program guidelines, no application criteria and no record of a project being funded. The EDA fund draws on tax levy, EDA loan repayments, donations and city property lease payments, which is the pool that $20,000 came from. The EDA facade program guidelines and any grant agreements would settle whether the money was spent.

8-20-24_AGENDA; 12.9.25_Council_Agenda_and_Packet_Updated

Unsourced claimFinance Director Whitney Kyllofrom the minutes
The city could look into applying for more grants to save money. Attorney and engineer costs increased by 50%, so the budget for these items will be increased.

Finance director's summary of cost pressures on the 2025 budget.

Partly answered

No year-over-year attorney or engineer billing totals exist in our holdings, and no Kennedy and Graven rate figure appears in any packet we hold for 2025 or 2026 even though the council approved the rates both years. One mechanism behind engineering growth is documented: the city left the county's shared mapping for its own ArcGIS Online through Bolton and Menk in 2024 at $14,500 for conversion plus $1,260 a year in licensing, with ongoing updates billed as general engineering rather than as a separate line. The annual rate letters and the vendor billing history would settle the 50% figure.

8-20-24_AGENDA; KENYON_DATA_IN_MEETINGS.md

Unsourced claimPublic Works Superintendent Wayne Ehrichfrom the minutes
The budget for chemical costs and utilities costs will be increased. It would cost $10,000 for cameras at the pool and park.

Discussion of proposed pool and parks budget items.

Partly answered

No camera quote for the pool or park is in our holdings and no purchase appears in the bid record. The city's camera vendor in this period is WH Security, which did the liquor store cameras and DVR in 2021 and City Hall cameras plus panic buttons in June 2024, neither with a dollar figure recorded. The item looks to have been squeezed out rather than bought: a year later, reviewing the 2026 parks and pool budgets, Superintendent Ehrich identified several items in his departments that could be cut for savings.

9-9-25_Council_Packet; KENYON_BIDS.md

Unsourced claimPublic Works Superintendent Wayne Ehrichfrom the minutes
The skid steer loader would also be upgraded, but the attachments would be kept. The utility costs for the sanitary sewer were increased. The GIS cost of $1,500 was added.

Review of the proposed 2025 sewer budget.

Partly answered

The $1,500 GIS line covers annual licensing only. The city's actual GIS move, off the county's shared mapping and onto its own ArcGIS Online through Bolton and Menk in 2024, cost $14,500 for conversion plus $1,260 a year in ESRI licensing, with ongoing updates billed as general engineering. On the sewer utility cost side, the March 2025 rate action shows the increases that followed: the residential sanitary sewer rate went from $7.40 to $7.77 per thousand gallons, the residential base rate from $26.25 to $27.57 a month, and the storm sewer maintenance fee from $9.00 to $13.00 a month, a 44% jump on that last line.

The budget carried GIS as a $1,500 addition, which matches only the $1,260 annual licensing and omits the $14,500 conversion the city incurred in the same period.

3-11-25_council_packet_(1); KENYON_DATA_IN_MEETINGS.md · taken up again 2025-03-11

RequestCity Engineer Derek Olingerfrom the minutes
Motion Approving Pay Application #7 to BCM Construction ($335,092.09) SUPPORTING DOCUMENTS ATTACHED: Resolution Ordinance Contract Minutes OTHER X 13 Contractor's Application for Payment Owner: CITY OF KENYON Owner's Project No.: N/A Engineer: BOLTON & MENK Engineer's Project No.: 0H1.126462 Contractor: BCM CONSTRUCTION Agency's Project No.: N/A Project: 2023 PEARL CREEK SANITARY SEWER & GATES AVE UTILITY IMPROVMENTS Contract: N/A Application No.: 7 Application Date: 8/20/2024 Application Period: From 6/29/2024 to

Engineer's recommendation in the August 20 council packet for the Pearl Creek sanitary sewer project.

Partly answered

Pay Application No. 7 to BCM Construction for $335,092.09 appears on both the August 20 and September 10 2024 agendas, but no motion approving it is in our holdings. The applications either side of it are recorded: No. 8 at $66,188.50 for work through August 30 2024, approved 3-0-0 on a motion by Bailey seconded by Sjolander, and No. 9 at $5,438.75. BCM won the Pearl Creek Sanitary Sewer and Gates Avenue contract in June 2023 at $1,241,494.22 against a $1,536,065 estimate.

9.10.24_Council_Packet_and_Agenda; 10-8-24_AGENDA; KENYON_BIDS.md

Action itemfrom the minutes
Currently, the city allocates property and liability costs to each individual fund (police, streets, pool, city administration). It may be best to lump them together in the general fund instead of in each individual fund.

Review of how property and liability costs are currently charged to police, streets, pool, and city administration.

At the meetingNo decision recorded.

We hold no data

We hold nothing showing whether insurance costs were consolidated into the general fund. The only later insurance language in our record is a contractor's comprehensive general liability requirement of not less than $1,000,000 per occurrence in a development agreement, which is unrelated to how the city books its own premiums. The adopted 2025 budget, showing whether property and liability lines still sit in police, streets, pool and city administration, would settle it.

8-20-24_AGENDA · would settle it: A revised budget showing insurance costs consolidated in the general fund

To look upPolice Chief Jeff Sjoblomfrom the minutes
They cost $5,000 each. Funds were allocated in prior years to purchase a new squad car that will be arriving in 2024.

Police department capital discussion during budget review.

We hold no data

We hold no vehicle order, delivery confirmation or capital ledger entry for the squad car. The December 10 2024 agenda carries a joint police and public works item whose content is not in our extract. A purchase order or the police capital fund detail would settle the delivery date and price. The city's own policy required a lease versus buy analysis and Finance and legal approval before any lease was initiated, so a lease-purchase route would have left a paper trail.

8-20-24_AGENDA; 12.10.24_Council_Packet_and_Agenda_Updated · would settle it: The vehicle order and confirmed delivery date

Unsourced claimFinance Director Whitney Kyllofrom the minutes
Finance Director Kyllo stated that some leases were paid off in 2024, so that should reduce the levy amount. CDs and investments are earning 5%, which has increased from .05%.

Discussion of revenue that could offset the levy.

We hold no data

We hold no investment statements, no interest income line and nothing else that tests a move from 0.05% to 5%. The city's designated depositories are Security State Bank, the 4M fund and Northland Securities. The 4M and bank statements or the investment income line in the audited financials would settle it.

8-20-24_AGENDA · would settle it: The city's investment statements showing current rates

Action itemPublic Works Superintendent Wayne Ehrichfrom the minutes
The F350 truck would be traded in for a F550 or F650, so the plow can be used on both hard and class 5 surfaces.

Review of the proposed 2025 streets equipment budget.

We hold no data

No trade-in values or purchase quotes for an F550, an F650 or a skid steer loader appear in the 43-row bid record. The equipment swap Ehrich proposed is not documented as a competitive purchase in any later year.

Truck and loader purchases at this scale require council approval plus two quotes under Administrative Policy No. 34, presented three weeks after this work session, and no quotes are on file.

KENYON_BIDS.md · would settle it: Trade-in values and purchase quotes for the truck and skid steer

Decisions

  • No formal action taken; the council reviewed the draft 2025 budget and levy with department heads
  • Direction given that $20,000 be added to the EDA budget for 3 to 5 façade improvement programs
  • Consensus to consider consolidating property and liability insurance costs into the general fund
  • Council confirmed priorities: hiring a long-term city administrator (advertised August 14) and implementing the comprehensive and classification plan
  • Maximum 2025 levy discussed at a preliminary 8%, to be adopted by the end of September with the final levy and budget by the end of December
  • Meeting adjourned at 3:10 p.m.

Who did what

PersonAt this meeting
Doug Henke
Mayor
Called the work session to order at 1:00 pm
Kim Helgeson
Council Member
Present for the budget and levy review
Mary Bailey
Council Member
Present for the budget and levy review
Lee Sjolander
Council Member
Present for the budget and levy review
Molly Ryan
Council Member
Attended via Zoom
Frank Boyles
Interim City Administrator
Attended the work session
Holli Gudknecht
Administrative Assistant / Deputy City Clerk
Attended and signed the minutes; prepared agenda item summaries
Whitney Kyllo
Finance Director
Reviewed local government aid and small-town aid, leases paid off, investment earnings, and increased attorney and engineer costs
Wayne Ehrich
Public Works Superintendent / Fire Chief
Presented the fire and first responder budgets and reviewed streets, sewer, parks and pool budgets
Michelle Otte
Library Director
Attended for review of the library budget, which remained mostly flat
Jeff Sjoblom
Police Chief
Updated the council on the proposed 2025 police budget, including encrypted radios and a new squad car
Matt Bartel
Liquor Store Manager
Reported no major increases and raised whether the store will offer THC products
Eggert
Operations Superintendent
Attended the work session

Organizations named: City of Kenyon, Kenyon Economic Development Authority, Kenyon Police Department, Kenyon Fire Department, Kenyon Public Library, Motorola, Goodhue County, State of Minnesota

Figures

AmountWhat
$20,000Added to the Economic Development Authority budget for 3 to 5 façade improvement programs
$5,000Cost of each encrypted radio needed by the police department
$36,000Local government aid the police department will receive
$15,900Budgeted for three new fire department radios
$1,500GIS cost added to the proposed budget
$10,000Estimated cost for cameras at the pool and park
$1,277,9652024 total tax levy shown in the packet levy history table
$665,114Local government aid figure in the 2025 general fund revenue draft

Said at the meeting

Liquor Store Manager Bartel stated there were no major increases for the liquor store.

Minutes (Liquor Store Manager Matt Bartel) · minutes, verbatim

He stated that encrypted radios are needed.

Minutes (Police Chief Jeff Sjoblom) · minutes, verbatim

Motorola no longer supports their older radios, so $15,900 is being budgeted for three new radios.

Minutes (Fire Chief Wayne Ehrich) · minutes, verbatim

The city council's first priority is to hire a long-term competent city administrator, which will be advertised August 14.

Minutes (council priorities) · minutes, verbatim

Attorney and engineer costs increased by 50%, so the budget for these items will be increased.

Minutes (Finance Director Whitney Kyllo) · minutes, verbatim

After the maximum levy is adopted, it cannot be increased but can be decreased.

Minutes (levy discussion) · minutes, verbatim

Agenda

Each item links to where it appears in the packet.

  1. I. Call to Order
  2. II. Agenda
  3. II.A Agenda
  4. III. Business to be discussed and Possible Action
  5. III.A Review Proposed 2025 Budget & Levy
  6. IV. Adjourn
  7. II. Review Proposed 2025 Budget and Levy

Full packet text (75k characters)

The minutes

Official minutes as adopted, from 8-20-24 AGENDA; text extracted from the PDF.

Council Work Session was duly held in the City Council chambers at 1:00 p.m. on the 30th day of July 2024.

Present
Mayor Doug Henke, Council Members: Kim Helgeson, Mary Bailey, and Lee Sjolander
Via Zoom
Molly Ryan
Also present
Interim City Administrator Frank Boyles, Administrative Assistant Holli Gudknecht, Public Works Superintendent Wayne Ehrich, Library Director Michelle Otte, Police Chief Jeff Sjoblom, Liquor Store Manager Matt Bartel, Finance Director Whitney Kyllo, and Operations Superintendent Eggert

Mayor Henke called the work session to order at 1:00 pm. The purpose of the work session was to review the draft 2025 levy and department budgets funded by the levy.

Review Proposed 2025 Budget and Levy

Kyllo reviewed the local government aid which is received annually from the State. She also reviewed the small-town aid. Twenty thousand dollars was added to the Economic Development Authority budget for 3 to 5 façade improvement programs.

Currently, the city allocates property and liability costs to each individual fund (police, streets, pool, city administration). It may be best to lump them together in the general fund instead of in each individual fund.

Most library line items remained flat. There will be increases in benefits and salaries per council approval. A 10% increase in funding from the County will cover other library expenses.

Liquor Store Manager Bartel stated there were no major increases for the liquor store. A question for the future is whether the liquor store will begin offering THC products.

Police Chief Sjoblom provided an update on the police department proposed 2025 budget. He stated that encrypted radios are needed. They cost $5,000 each. Funds were allocated in prior years to purchase a new squad car that will be arriving in 2024. The police department will be receiving local government aid in the amount of $36,000.

Fire Chief Wayne Ehrich provided a summary of the proposed 2025 Fire Department and First

Responder budgets. Motorola no longer supports their older radios, so $15,900 is being budgeted for three new radios.

Public Works Superintendent Ehrich reviewed the proposed 2025 streets, sewer, parks, and pool budgets. The F350 truck would be traded in for a F550 or F650, so the plow can be used on both hard and class 5 surfaces. The skid steer loader would also be upgraded, but the attachments would be kept. The utility costs for the sanitary sewer were increased. The GIS cost of $1,500 was added. The pool costs are still increasing due to the price of chemicals. The budget for chemical costs and utilities costs will be increased. It would cost $10,000 for cameras at the pool and park. The pool rates need to be reviewed on for the 2025 year. The suggestion was made for all mowing costs to be designated to the parks department rather than spreading it out between the other departments. This would increase the fuel costs to the parks.

The city council's first priority is to hire a long-term competent city administrator, which will be advertised August 14. The council's second priority is the implementation of the comprehensive and classification plan to retain full-time city employees. The plan does increase the wage figures in all budgets. This will be discussed more at the August 2024 City council meeting.

Finance Director Kyllo stated that some leases were paid off in 2024, so that should reduce the levy amount. CDs and investments are earning 5%, which has increased from .05%. The city could look into applying for more grants to save money. Attorney and engineer costs increased by 50%, so the budget for these items will be increased.

Discuss Options for Maximum 2025 Levy

The maximum proposed levy increase must be adopted by the council by the end of September. The draft budget showed an 8% maximum levy, but this is only preliminary. After the maximum levy is adopted, it cannot be increased but can be decreased. The final levy and budget must be adopted by the end of December.

The meeting was adjourned at 3:10 p.m.

Holli Gudknecht, Deputy City Clerk Douglas Henke, Mayor

AGENDA ITEM NO. VII.A

Agenda Item Summary

CITY COUNCIL AGENDA ITEM REPORT

DATE: August 20, 2024
SUBMITTED BY: Holli Gudknecht, Engineering
ITEM TYPE: Engineering

Agenda Section: Engineering

SUBJECT: Pearl Creek & Gates Ave Utility Improvements
SUGGESTED ACTION: See attachments

Attachments:

01.1_RCA_Pearl Creek & Gates Ave Utility Improvements.pdf 01.2_Pearl Creek Pay App No. 7.pdf

REQUEST FOR COUNCIL ACTION

Agenda Item: Department: Requested Council Meeting Date: Submitted By: Engineering 8/20/2024 Derek Olinger

TITLE OF ISSUE: Pearl Creek & Gates Ave Utility Improvements

BACKGROUND AND SUPPLEMENTAL INFORMATION: In the past month, BCM has installed the remainder of sanitary services, mains and manholes for the project. The new lift station was started in mid-July. There are still a few minor control issues that will be resolved prior to final completion; however, the lift station is operational, and sewer flow has been diverted. The lift station driveway is also now paved, but this work is not included in the attached pay application.

Major items of work remaining include final yard/turf restoration, disconnections from the old pearl creek sewer line, and final televising/inspections of new sewer lines.

The attached pay application is recommended for approval.

SOURCE OF FUNDING: Project Financing

REQUESTED COUNCIL ACTION: Motion Approving Pay Application #7 to BCM Construction ($335,092.09)

Supporting Documents Attached:

Resolution Ordinance Contract Minutes OTHER

X

Contractor's Application for Payment Owner: CITY OF KENYON Owner's Project No.: N/A Engineer: BOLTON & MENK Engineer's Project No.: 0H1.126462 Contractor: BCM CONSTRUCTION Agency's Project No.: N/A Project: 2023 PEARL CREEK SANITARY SEWER & GATES AVE UTILITY IMPROVMENTS Contract: N/A Application No.: 7 Application Date: 8/20/2024 Application Period: From 6/29/2024 to 8/9/2024 1. Original Contract Price $ 1,241,494.22 2. Net change by Change Orders $ 14,800.00 3. Current Contract Price (Line 1 + Line 2) $ 1,256,294.22 4. Total Work completed and materials stored to date (Sum of Column G Lump Sum Total and Column J Unit Price Total) $ 1,156,508.41 5. Retainage a. 5% X $ 1,156,508.41 Work Completed $ 57,825.42 b. 5% X $ - Stored Materials $ - c. Total Retainage (Line 5.a + Line 5.b) $ 57,825.42 6. Amount eligible to date (Line 4 - Line 5.c) $ 1,098,682.99 7. Less previous payments $ 763,590.90 8. Amount due this application $ 335,092.09 Contractor's Certification The undersigned Contractor certifies, to the best of its knowledge, the following: (1) All previous progress payments received from Owner on account of Work done under the Contract have been applied on account to discharge Contractor's legitimate obligations incurred in connection with the Work covered by prior Applications for Payment; (2) Title to all Work, materials and equipment incorporated in said Work, or otherwise listed in or covered by this Application for Payment, will pass to Owner at time of payment free and clear of all liens, security interests, and encumbrances (except such as are covered by a bond acceptable to Owner indemnifying Owner against any such liens, security interest, or encumbrances); and (3) All the Work covered by this Application for Payment is in accordance with the Contract Documents and is not defective.

Contractor: BCM CONSTRUCTION

Signature: Date: Name: AARON MILLER Title: PROJECT MANAGER

Recommended by Engineer Approved by Owner

By: By: Name: DEREK OLINGER, PE Name: FRANK BOYLES Title: CITY ENGINEER Title: INTERIM CITY ADMINISTRATOR Date: Date:

EJCDC C-620 Contractor's Application for Payment

(c) 2018 National Society of Professional Engineers for EJCDC. All rights reserved. 14 Progress Estimate - Unit Price Work Contractor's Application for Payment Owner: CITY OF KENYON Owner's Project No.: N/A Engineer: BOLTON & MENK Engineer's Project No.: 0H1.126462 Contractor: BCM CONSTRUCTION Agency's Project No.: N/A Project: 2023 PEARL CREEK SANITARY SEWER & GATES AVE UTILITY IMPROVMENTS Contract: N/A

Application No.: 7 Application Period: From 06/29/24 to 08/09/24 Application Date: 08/20/24

A B C D E F F1 F2 G H I J K L Contract Information Previous Estimate Work Completed Work Completed and % of Estimated Value of Work Materials Stored Value of Difference fron Bid Value of Bid Item Quantity Completed to Date Materials Currently to Date Item Estimate Bid Item Unit Price (C X E) Quantity Previous Value Previous Incorporated in (E X G) Stored (not in G) (H + I) (J / F) (F - J) No. Description Item Quantity Units ($) ($) Estimate Estimate the Work ($) ($) ($) (%) ($) Original Contract 1 MOBILIZATION 1.00 LS 55,000.00 55,000.00 0.75 41,250.00 0.92 50,600.00 50,600.00 92% 4,400.00 2 CLEARING AND GRUBBING 1.00 LS 13,125.00 13,125.00 1.00 13,125.00 1.00 13,125.00 13,125.00 100% - 3 REMOVE RIPRAP (P) 75.00 CY 21.00 1,575.00 75.00 1,575.00 75.00 1,575.00 1,575.00 100% - 4 SITE GRADING 1.00 LS 30,000.00 30,000.00 0.95 28,500.00 0.95 28,500.00 28,500.00 95% 1,500.00 5 GEOGRID TYPE 1 1,130.00 SY 1.75 1,977.50 955.00 1,671.25 955.00 1,671.25 1,671.25 85% 306.25 6 AGGREGATE SURFACING CLASS 2 630.00 TON 25.00 15,750.00 630.00 15,750.00 630.00 15,750.00 15,750.00 100% - 7 PAVEMENT/CURB/DRIVEWAY PATCHING 1.00 LS 26,500.00 26,500.00 0.80 21,200.00 0.80 21,200.00 21,200.00 80% 5,300.00 8 6" CONCRETE DRIVEWAY (REINFORCED) 160.00 SY 114.00 18,240.00 - - 160.00 18,240.00 18,240.00 100% - 9 BOLLARD 4.00 EA 252.00 1,008.00 - - - - - 1,008.00 10 TRAFFIC CONTROL 1.00 LS 4,500.00 4,500.00 0.65 2,925.00 0.92 4,140.00 4,140.00 92% 360.00 11 EROSION & SEDIMENTATION CONTROL 1.00 LS 12,000.00 12,000.00 0.85 10,200.00 0.85 10,200.00 10,200.00 85% 1,800.00 12 STABILIZE & REESTABLISH TURF 1.00 LS 15,000.00 15,000.00 - - 0.33 4,950.00 4,950.00 33% 10,050.00 13 EXPLORATORY EXCAVATION 10.00 HOUR 400.00 4,000.00 3.00 1,200.00 3.00 1,200.00 1,200.00 30% 2,800.00 14 CONSTRUCTION ALLOWANCE 35,000.00 UNIT 1.00 35,000.00 22,259.20 22,259.20 23,074.20 23,074.20 23,074.20 66% 11,925.80 15 HWY 60 MH & PIPE DISCONNECTIONS 1.00 LS 8,000.00 8,000.00 - - - - - 8,000.00 16 REMOVE MANHOLE (SANITARY) 3.00 EACH 1,500.00 4,500.00 1.00 1,500.00 2.00 3,000.00 3,000.00 67% 1,500.00 17 EXCAVATION - ROCK 180.00 CY 84.00 15,120.00 83.00 6,972.00 103.00 8,652.00 8,652.00 57% 6,468.00 18 DEWATERING 1.00 LS 20,000.00 20,000.00 0.70 14,000.00 1.00 20,000.00 20,000.00 100% - 19 CONNECT TO EXISTING SANITARY SEWER MAIN 2.00 EACH 875.00 1,750.00 1.00 875.00 3.00 2,625.00 2,625.00 150% (875.00) 20 CONNECT TO EXISTING SANITARY SEWER SERVICE 2.00 EACH 600.00 1,200.00 1.00 600.00 1.00 600.00 600.00 50% 600.00 21 6" PVC PIPE DRAIN CLEANOUT 3.00 EACH 400.00 1,200.00 - - 3.00 1,200.00 1,200.00 100% - 22 8" PVC PIPE SEWER (CREEK CROSSING) 157.00 LF 1,400.00 219,800.00 - - 157.00 219,800.00 219,800.00 100% - 23 8" PVC PIPE SEWER 280.00 LF 90.00 25,200.00 224.00 20,160.00 283.00 25,470.00 25,470.00 101% (270.00) 24 6" PVC SANITARY SERVICE PIPE 304.00 LF 102.00 31,008.00 12.00 1,224.00 299.00 30,498.00 30,498.00 98% 510.00 25 4" FORCE MAIN PIPE 1,274.00 LF 37.00 47,138.00 1,279.00 47,323.00 1,279.00 47,323.00 47,323.00 100% (185.00) 26 4" INSULATION 25.00 SY 65.00 1,625.00 - - - - - 1,625.00 27 CONST DRAINAGE STRUCTURE DES 4007 (MH A) 1.00 EACH 7,000.00 7,000.00 0.90 6,300.00 1.00 7,000.00 7,000.00 100% - 28 CONST DRAINAGE STRUCTURE (MH B - AIR/VAC RELEASE) 1.00 EACH 5,500.00 5,500.00 0.90 4,950.00 1.00 5,500.00 5,500.00 100% - 29 CONST DRAINAGE STRUCTURE DES 4007 (MH C) 1.00 EACH 8,200.00 8,200.00 0.80 6,560.00 1.00 8,200.00 8,200.00 100% - 30 CONST DRAINAGE STRUCTURE DES 4007 (MH D) 1.00 EACH 8,000.00 8,000.00 - - 1.00 8,000.00 8,000.00 100% - 31 REPLACE & ADJUST CASTING 1.00 EACH 1,350.00 1,350.00 - - - - - 1,350.00 32 CONSTRUCT 8" INSIDE DROP (MH C) 1.00 EACH 4,500.00 4,500.00 - - 1.00 4,500.00 4,500.00 100% - 33 CONSTRUCT 8" INSIDE DROP (MH D) 1.00 EACH 4,500.00 4,500.00 - - 1.00 4,500.00 4,500.00 100% - 34 SANITARY SEWER TRACER SYSTEM 1.00 LS 3,000.00 3,000.00 0.50 1,500.00 0.50 1,500.00 1,500.00 50% 1,500.00 35 LIFT STATION & VALVE VAULT 1.00 LS 235,090.22 235,090.22 0.90 211,581.20 0.95 223,335.71 223,335.71 95% 11,754.51 36 ELECTRICAL (POWER EXTEN, BACKUP GEN, CONTROL, LIGHT, CONCRETE PADS) 1.00 LS 200,000.00 200,000.00 0.85 170,000.00 0.95 190,000.00 190,000.00 95% 10,000.00 37 GAS SERVICE ALLOWANCE 8,000.00 UNIT 1.00 8,000.00 8,000.00 8,000.00 8,000.00 8,000.00 8,000.00 100% - 38 DISCONNECT EXISTING WATER MAIN 1.00 EACH 500.00 500.00 1.00 500.00 1.00 500.00 500.00 100% - 39 CONNECT TO EXISTING WATER MAIN 5.00 EACH 1,000.00 5,000.00 5.00 5,000.00 5.00 5,000.00 5,000.00 100% - 40 HYDRANT (9' BURY) 1.00 EACH 6,500.00 6,500.00 1.00 6,500.00 1.00 6,500.00 6,500.00 100% - 41 4" GATE VALVE AND BOX 1.00 EACH 2,000.00 2,000.00 1.00 2,000.00 1.00 2,000.00 2,000.00 100% - 42 6" GATE VALVE AND BOX 2.00 EACH 2,250.00 4,500.00 2.00 4,500.00 2.00 4,500.00 4,500.00 100% - 43 8" GATE VALVE AND BOX 1.00 EACH 3,000.00 3,000.00 1.00 3,000.00 1.00 3,000.00 3,000.00 100% - 44 4" WATERMAIN 16.00 LF 100.00 1,600.00 16.00 1,600.00 16.00 1,600.00 1,600.00 100% -

EJCDC C-620 Contractor's Application for Payment

Unit Price (c) 2018 National Society of Professional Engineers for EJCDC. All rights reserved. 1 of 2 15 Progress Estimate - Unit Price Work Contractor's Application for Payment Owner: CITY OF KENYON Owner's Project No.: N/A Engineer: BOLTON & MENK Engineer's Project No.: 0H1.126462 Contractor: BCM CONSTRUCTION Agency's Project No.: N/A Project: 2023 PEARL CREEK SANITARY SEWER & GATES AVE UTILITY IMPROVMENTS Contract: N/A

Application No.: 7 Application Period: From 06/29/24 to 08/09/24 Application Date: 08/20/24

A B C D E F F1 F2 G H I J K L Contract Information Previous Estimate Work Completed Work Completed and % of Estimated Value of Work Materials Stored Value of Difference fron Bid Value of Bid Item Quantity Completed to Date Materials Currently to Date Item Estimate Bid Item Unit Price (C X E) Quantity Previous Value Previous Incorporated in (E X G) Stored (not in G) (H + I) (J / F) (F - J) No. Description Item Quantity Units ($) ($) Estimate Estimate the Work ($) ($) ($) (%) ($) 45 6" WATERMAIN 20.00 LF 100.00 2,000.00 27.00 2,700.00 27.00 2,700.00 2,700.00 135% (700.00) 46 8" WATERMAIN 615.00 LF 70.00 43,050.00 641.00 44,870.00 641.00 44,870.00 44,870.00 104% (1,820.00) 47 WATERMAIN FITTINGS 654.00 LB 13.25 8,665.50 593.00 7,857.25 593.00 7,857.25 7,857.25 91% 808.25 48 WATERMAIN TRACER SYSTEM 1.00 LS 2,500.00 2,500.00 1.00 2,500.00 1.00 2,500.00 2,500.00 100% - 49 6" NON-METALLIC CONDUIT 650.00 LF 57.00 37,050.00 636.00 36,252.00 636.00 36,252.00 36,252.00 98% 798.00 50 ELECTRICAL VAULT MANHOLE 1.00 EACH 10,500.00 10,500.00 1.00 10,500.00 1.00 10,500.00 10,500.00 100% - 1.01 PAVING MOBILIZATION 1.00 LS 1,800.00 1,800.00 - - - - - 1,800.00 1.02 TYPE SP 12.5 WEARING COURSE MIXTURE (2,B) (SINGLE 3" LIFT) 156.00 TON 112.00 17,472.00 - - - - - 17,472.00 - - - - - - - Original Contract Totals $ 1,241,494.22 $ 788,979.90 92% $ 1,141,708.41 $ - $ 1,141,708.41 92% $ 99,785.81

Change Orders

CO1-1 HAUL & DISPOSE CONCRETE RUBBLE 400.00 C Y 22.00 8,800.00 400.00 8,800.00 400.00 8,800.00 8,800.00 100% - CO1-2 IMPORT FILL (REPLACING RUBBLE REMOVAL) 400.00 C Y 15.00 6,000.00 400.00 6,000.00 400.00 6,000.00 6,000.00 100% - - - - - Change Order Totals $ 14,800.00 $ 14,800.00 100% $ 14,800.00 $ - $ 14,800.00 100% $ -

Original Contract and Change Orders

Project Totals $ 1,256,294.22 $ 803,779.90 92% $ 1,156,508.41 $ - $ 1,156,508.41 92% $ 99,785.81

EJCDC C-620 Contractor's Application for Payment

Unit Price (c) 2018 National Society of Professional Engineers for EJCDC. All rights reserved. 2 of 2 16 AGENDA ITEM NO. VII.B

Agenda Item Summary

CITY COUNCIL AGENDA ITEM REPORT

DATE: August 20, 2024
SUBMITTED BY: Holli Gudknecht, Engineering
ITEM TYPE: Engineering

Agenda Section: Engineering

SUBJECT: 2025 Street & Utility Improvements
SUGGESTED ACTION: See Attachments

Attachments:

02.1_RCA_2025 Street & Utility Improvements.pdf 02.2_2025 Project Locations.pdf

REQUEST FOR COUNCIL ACTION

Agenda Item: Department: Requested Council Meeting Date: Submitted By: Engineering 8/20/2024 Derek Olinger

TITLE OF ISSUE: 2025 Street & Utility Improvements

BACKGROUND AND SUPPLEMENTAL INFORMATION: Preliminary design and survey work for this project has started. Sewers have been televised and geotechnical (soil borings) and reporting is complete. The following schedule of reviews and approvals is anticipated:

Review Preliminary Engineering Report w/ Council Regular Sept. Meeting

 Review & discuss budget and scope  Modify as needed before public notices/meetings/hearings Hold Neighborhood Informational Meeting Early October  Informal opportunity for residents to learn about project Hold Public Improvement Hearing Regular October Meeting  Public opportunity to voice opinions to council  Council considers formal approval of project scope & final design

SOURCE OF FUNDING: Future Project Financing

REQUESTED COUNCIL ACTION: None – Information Only

Supporting Documents Attached:

Resolution Ordinance Contract Minutes OTHER

X

Project 2025 PROJECT Map LOCATION MAP

N

2025 Project Areas Full Reconstruction

San Sewer Lining
Watermain Replace

March 28, 2024 1:8,400 Goodhue County Roads 0 0.07 0.15 0.3 mi

CEM; ; OCTY; OCRLN; CTRLN 0 0.15 0.3 0.6 km

CSAHP; CRP

SHWY Parcels ArcGIS WebApp Builder 19 AGENDA ITEM NO. IX.A

Agenda Item Summary

CITY COUNCIL AGENDA ITEM REPORT

DATE: August 20, 2024
SUBMITTED BY: Holli Gudknecht, Finance
ITEM TYPE: Financial

Agenda Section: Financial

Subject: Financials 8 / 20 / 24

Suggested Action:

Attachments:

August CITY OF KENYON Expense Summary.pdf

August CITY OF KENYON Revenue Summary.pdf

20 08/16/24 9:12 AM CITY OF KENYON Page 1 CITY OF KENYON Expense Summary

JULY 2024 %YTD Account Last Dim Descr 2024 Amt YTD Amt 2024 Budget Budget 2023 Amt

101 GENERAL FUND

41110 CITY COUNCIL E 101-41110-101 SALARIES - REGULAR $7,032.00 $9,527.16 $11,660.00 81.71% $12,545.00 E 101-41110-122 FICA - EMPLOYER SHARE $537.95 $537.95 $920.00 58.47% $889.78 E 101-41110-142 UNEMPLOYMENT COMPENSATI $0.00 $29.70 $0.00 0.00% $0.00 E 101-41110-150 INSURANCE - WORKERS COMP $4.16 $29.12 $50.00 58.24% $107.72 E 101-41110-311 CONFERENCE & TRAINING $0.00 $0.00 $350.00 0.00% $134.30 E 101-41110-331 TRAVEL EXPENSE $0.00 $0.00 $200.00 0.00% $0.00 E 101-41110-430 MISCELLANEOUS $0.00 $78.42 $0.00 0.00% $10.00 E 101-41110-433 DUES AND SUBSCRIPTIONS $0.00 $4,215.38 $100.00 4215.38% $7,658.74 41110 CITY COUNCIL $7,574.11 $14,417.73 $13,280.00 108.57% $21,345.54

41310 CITY ADMINISTRATION E 101-41310-100 SALARIES - PART TIME $337.92 $950.40 $17,214.75 5.52% $18,118.78 E 101-41310-101 SALARIES - REGULAR $5,858.14 $125,236.08 $177,702.00 70.48% $183,046.60 E 101-41310-102 SALARIES - OVERTIME $1,733.62 $7,000.66 $0.00 0.00% $9,631.93 E 101-41310-121 PERA - EMPLOYER SHARE $594.73 $9,995.05 $14,621.00 68.36% $16,012.25 E 101-41310-122 FICA - EMPLOYER SHARE $706.56 $10,070.64 $14,910.00 67.54% $5,459.73 E 101-41310-130 INSURANCE - MED/DENT/LIFE/ $4.38 $33,893.43 $89,645.00 37.81% $88,151.95 E 101-41310-131 EMPLOYER H.S.A.EXPENSE $0.00 $1,237.50 $0.00 0.00% $0.00 E 101-41310-142 UNEMPLOYMENT COMPENSATI $0.00 $63.55 $0.00 0.00% $0.00 E 101-41310-150 INSURANCE - WORKERS COMP $71.67 $501.69 $870.00 57.67% $1,900.00 E 101-41310-311 CONFERENCE & TRAINING $0.00 $0.00 $1,500.00 0.00% $676.29 E 101-41310-324 OUTSIDE SERVICES $11,141.00 $16,879.19 $0.00 0.00% $21,815.03 E 101-41310-331 TRAVEL EXPENSE $0.00 $281.40 $1,500.00 18.76% $511.98 E 101-41310-342 TRAINING FEES $0.00 -$100.00 $0.00 0.00% $0.00 E 101-41310-360 INSURANCE - PROPERTY/LIABIL $93.47 $654.29 $960.00 68.16% $1,565.67 E 101-41310-430 MISCELLANEOUS $0.00 $33.75 $0.00 0.00% $120.52 E 101-41310-433 DUES AND SUBSCRIPTIONS $0.00 $663.00 $1,100.00 60.27% $2,956.18 41310 CITY ADMINISTRATION $20,541.49 $207,360.63 $320,022.75 64.80% $349,966.91

41410 ELECTIONS E 101-41410-103 ELECTION JUDGE PAY $0.00 $0.00 $2,500.00 0.00% $0.00 E 101-41410-331 TRAVEL EXPENSE $0.00 $0.00 $0.00 0.00% $941.25 E 101-41410-430 MISCELLANEOUS $87.18 $83.69 $0.00 0.00% $480.00 41410 ELECTIONS $87.18 $83.69 $2,500.00 3.35% $1,421.25

41530 AUDITING

21 08/16/24 9:12 AM Page 2 JULY 2024 %YTD Account Last Dim Descr 2024 Amt YTD Amt 2024 Budget Budget 2023 Amt E 101-41530-301 AUDITING $0.00 $14,757.50 $15,000.00 98.38% $43,557.17 41530 AUDITING $0.00 $14,757.50 $15,000.00 98.38% $43,557.17

41610 CITY ATTORNEY E 101-41610-304 LEGAL $6,900.00 $54,853.81 $25,000.00 219.42% $48,390.03 41610 CITY ATTORNEY $6,900.00 $54,853.81 $25,000.00 219.42% $48,390.03

41700 CITY ENGINEER E 101-41700-303 ENGINEERING $2,610.00 $10,360.00 $10,000.00 103.60% $14,400.00 41700 CITY ENGINEER $2,610.00 $10,360.00 $10,000.00 103.60% $14,400.00

41940 GENERAL GOVERNMENT E 101-41940-116 SALARIES -WEBSITE ADMIN $0.00 $3,346.11 $7,036.05 47.56% $6,750.91 E 101-41940-121 PERA - EMPLOYER SHARE $0.00 $209.41 $528.00 39.66% $528.88 E 101-41940-122 FICA - EMPLOYER SHARE $0.00 $241.25 $537.00 44.93% $130.55 E 101-41940-130 INSURANCE - MED/DENT/LIFE/ $292.23 $1,802.34 $3,783.00 47.64% $3,650.97 E 101-41940-131 EMPLOYER H.S.A.EXPENSE $0.00 $1,312.52 $0.00 0.00% $1,218.75 E 101-41940-150 INSURANCE - WORKERS COMP $2.67 $18.69 $40.00 46.73% $70.39 E 101-41940-200 OFFICE SUPPLIES $44.99 $1,492.09 $2,800.00 53.29% $2,001.07 E 101-41940-210 OPERATING SUPPLIES & EXPEN $279.97 $2,514.40 $10,000.00 25.14% $4,747.00 E 101-41940-302 SAFETY CLASS/DRUG & ALCOH $0.00 $3,163.16 $4,700.00 67.30% $6,350.63 E 101-41940-308 OUTSIDE JANITORIAL SERVICE $1,346.83 $10,377.81 $15,690.00 66.14% $17,202.73 E 101-41940-309 COMPUTER SUPPORT $2,189.60 $5,493.76 $2,500.00 219.75% $6,494.00 E 101-41940-321 UTILITIES-PHONE/INTERNET/C $961.58 $6,896.73 $9,700.00 71.10% $10,976.62 E 101-41940-324 OUTSIDE SERVICES $678.32 $678.32 $0.00 0.00% $0.00 E 101-41940-335 MISC BANK CHARGES $0.00 $45.00 $200.00 22.50% $95.00 E 101-41940-339 PAY PAL FEES $0.00 $79.47 $50.00 158.94% $118.62 E 101-41940-340 ADVERTISING $332.86 $1,932.75 $3,500.00 55.22% $1,628.34 E 101-41940-360 INSURANCE - PROPERTY/LIABIL $876.87 $6,138.09 $7,000.00 87.69% $13,729.92 E 101-41940-381 UTILITIES-ELECTRIC & WATER $295.53 $1,696.53 $3,665.00 46.29% $3,359.79 E 101-41940-383 UTILITIES-NATURAL GAS $17.66 $952.92 $1,580.00 60.31% $3,107.00 E 101-41940-384 UTILITIES-REFUSE/RECYCLING $42.56 $297.89 $455.00 65.47% $559.58 E 101-41940-385 UTILITIES-SEWER CHARGES $155.85 $1,072.08 $1,120.00 95.72% $1,159.37 E 101-41940-400 REPAIRS AND MAINT $124.96 $6,261.55 $3,500.00 178.90% $4,268.44 E 101-41940-430 MISCELLANEOUS $236.22 $2,290.25 $7,000.00 32.72% $2,680.81 E 101-41940-433 DUES AND SUBSCRIPTIONS $188.30 $4,604.33 $7,000.00 65.78% $12,624.01 E 101-41940-490 DONATIONS $2,000.00 $2,000.00 $2,000.00 100.00% $2,000.00 E 101-41940-501 CAPITAL OUTLAY $0.00 $5,583.54 $8,500.00 65.69% $7,893.00 E 101-41940-609 LOAN PRINCIPAL-INTERFUND K $53,000.00 $53,000.00 $8,000.00 662.50% $0.00 E 101-41940-610 LOAN INTEREST - INTERFUND $1,478.00 $1,478.00 $4,000.00 36.95% $0.00 E 101-41940-725 TRANSFER TO GENERAL FUND -$300,000.00 -$300,000.00 $0.00 0.00% $0.00

22 08/16/24 9:12 AM Page 3 JULY 2024 %YTD Account Last Dim Descr 2024 Amt YTD Amt 2024 Budget Budget 2023 Amt 41940 GENERAL GOVERNMENT -$235,455.00 -$175,021.01 $114,884.05 -152.35% $113,346.38

42100 LAW ENFORCEMENT E 101-42100-100 SALARIES - PART TIME $988.99 $13,666.01 $19,000.00 71.93% $11,928.17 E 101-42100-101 SALARIES - REGULAR $18,334.93 $151,042.41 $239,294.05 63.12% $234,294.99 E 101-42100-102 SALARIES - OVERTIME $3,485.08 $16,275.11 $31,000.00 52.50% $24,446.02 E 101-42100-106 SALARIES - TRAINING $0.00 $0.00 $0.00 0.00% $997.86 E 101-42100-112 SALARIES - ADMIN $0.00 $0.00 $0.00 0.00% $19,708.44 E 101-42100-117 LAWENF.SAL./SP PROG/GRANT $0.00 $1,119.80 $0.00 0.00% $0.00 E 101-42100-121 PERA - EMPLOYER SHARE $2,721.29 $30,343.25 $49,195.00 61.68% $50,611.00 E 101-42100-122 FICA - EMPLOYER SHARE $285.12 $5,507.46 $5,754.00 95.72% $1,801.52 E 101-42100-130 INSURANCE - MED/DENT/LIFE/ $2,468.76 $13,915.64 $24,323.00 57.21% $27,716.86 E 101-42100-131 EMPLOYER H.S.A.EXPENSE $0.00 $2,550.02 $0.00 0.00% $1,218.76 E 101-42100-142 UNEMPLOYMENT COMPENSATI $0.00 $144.29 $0.00 0.00% $0.00 E 101-42100-150 INSURANCE - WORKERS COMP $1,358.50 $9,509.50 $10,060.00 94.53% $20,824.94 E 101-42100-210 OPERATING SUPPLIES & EXPEN $674.36 $10,106.14 $7,500.00 134.75% $23,036.61 E 101-42100-211 CLEANING SUPPLIES $0.00 $245.24 $0.00 0.00% $0.00 E 101-42100-212 MOTOR FUELS, LUBES, ADDITIV $932.21 $7,016.93 $6,500.00 107.95% $11,728.00 E 101-42100-213 FIREARM AND AMMO PURCHAS $0.00 $749.30 $0.00 0.00% $1,612.89 E 101-42100-222 TIRES $0.00 $0.00 $1,500.00 0.00% $266.78 E 101-42100-304 LEGAL $1,400.00 $10,872.00 $13,800.00 78.78% $13,284.94 E 101-42100-307 CONTRACT SERVICES $40.90 $3,727.08 $3,600.00 103.53% $8,600.22 E 101-42100-311 CONFERENCE & TRAINING $191.44 $3,747.23 $3,000.00 124.91% $2,747.72 E 101-42100-321 UTILITIES-PHONE/INTERNET/C $891.07 $3,849.41 $4,220.00 91.22% $6,540.48 E 101-42100-331 TRAVEL EXPENSE $37.52 $37.52 $500.00 7.50% $0.00 E 101-42100-339 PAY PAL FEES $0.62 $10.54 $0.00 0.00% $15.54 E 101-42100-340 ADVERTISING $0.00 $0.00 $750.00 0.00% $2,184.35 E 101-42100-360 INSURANCE - PROPERTY/LIABIL $1,773.53 $12,414.71 $15,470.00 80.25% $29,017.36 E 101-42100-381 UTILITIES-ELECTRIC & WATER $255.17 $1,334.64 $1,000.00 133.46% $2,224.37 E 101-42100-383 UTILITIES-NATURAL GAS $242.27 $2,982.81 $1,500.00 198.85% $1,221.44 E 101-42100-384 UTILITIES-REFUSE/RECYCLING $33.19 $232.33 $400.00 58.08% $432.07 E 101-42100-385 UTILITIES-SEWER CHARGES $0.00 $0.00 $300.00 0.00% $189.69 E 101-42100-400 REPAIRS AND MAINT $93.35 $4,117.72 $4,000.00 102.94% $5,945.04 E 101-42100-418 UNIFORMS $0.00 $2,186.20 $2,400.00 91.09% $6,607.70 E 101-42100-429 PERMITS AND LICENSES $0.00 $91.94 $1,200.00 7.66% $0.00 E 101-42100-430 MISCELLANEOUS $143.69 $1,499.71 $1,000.00 149.97% $3,523.94 E 101-42100-433 DUES AND SUBSCRIPTIONS $0.99 $3,441.84 $3,300.00 104.30% $2,926.57 E 101-42100-501 CAPITAL OUTLAY $0.00 $3,232.40 $48,500.00 6.66% $6,796.94 E 101-42100-740 TRANSFER TO CAPITAL FUND $0.00 $4,832.40 $9,000.00 53.69% $9,000.00 42100 LAW ENFORCEMENT $36,352.98 $320,801.58 $508,066.05 63.14% $531,451.21

23 08/16/24 9:12 AM Page 4 JULY 2024 %YTD Account Last Dim Descr 2024 Amt YTD Amt 2024 Budget Budget 2023 Amt

43100 STREETS E 101-43100-101 SALARIES - REGULAR $7,717.24 $58,969.96 $105,495.60 55.90% $96,742.47 E 101-43100-102 SALARIES - OVERTIME $0.00 $2,126.15 $8,925.00 23.82% $12,670.37 E 101-43100-121 PERA - EMPLOYER SHARE $578.80 $4,549.28 $7,964.25 57.12% $8,521.12 E 101-43100-122 FICA - EMPLOYER SHARE $590.37 $4,497.15 $8,785.00 51.19% $2,337.96 E 101-43100-130 INSURANCE - MED/DENT/LIFE/ $3,772.66 $19,668.60 $41,082.00 47.88% $35,760.50 E 101-43100-131 EMPLOYER H.S.A.EXPENSE $0.00 $1,500.01 $0.00 0.00% $1,078.12 E 101-43100-142 UNEMPLOYMENT COMPENSATI $0.00 $41.90 $0.00 0.00% $0.00 E 101-43100-150 INSURANCE - WORKERS COMP $514.17 $3,599.19 $6,825.00 52.74% $13,756.76 E 101-43100-151 INSURANCE - WORK COMP DED $0.00 $0.00 $0.00 0.00% $1,000.00 E 101-43100-210 OPERATING SUPPLIES & EXPEN $374.84 $2,760.03 $10,000.00 27.60% $10,429.00 E 101-43100-212 MOTOR FUELS, LUBES, ADDITIV $316.84 $3,287.19 $12,000.00 27.39% $11,919.00 E 101-43100-224 STREET MAINTENANCE $0.00 $12,647.41 $80,000.00 15.81% $78,457.78 E 101-43100-225 BOULEVARD of ROSES $0.00 $340.81 $2,000.00 17.04% $1,521.76 E 101-43100-311 CONFERENCE & TRAINING $0.00 $0.00 $500.00 0.00% $0.00 E 101-43100-321 UTILITIES-PHONE/INTERNET/C $223.82 $798.85 $1,255.00 63.65% $1,530.00 E 101-43100-360 INSURANCE - PROPERTY/LIABIL $621.88 $4,353.16 $7,526.00 57.84% $9,405.55 E 101-43100-381 UTILITIES-ELECTRIC & WATER $164.08 $1,059.82 $1,625.00 65.22% $2,190.09 E 101-43100-383 UTILITIES-NATURAL GAS $0.00 $1,966.27 $4,500.00 43.69% $4,229.52 E 101-43100-384 UTILITIES-REFUSE/RECYCLING $42.55 $297.88 $555.00 53.67% $553.97 E 101-43100-385 UTILITIES-SEWER CHARGES $139.07 $877.37 $1,600.00 54.84% $1,610.17 E 101-43100-400 REPAIRS AND MAINT $4,257.79 $12,638.37 $14,000.00 90.27% $20,113.72 E 101-43100-414 OSHA/SAFETY CLOTH. & EQUIP $0.00 $170.27 $700.00 24.32% $535.77 E 101-43100-418 UNIFORMS $0.00 $195.73 $500.00 39.15% $740.57 E 101-43100-430 MISCELLANEOUS -$158.98 $0.00 $450.00 0.00% $52.50 E 101-43100-501 CAPITAL OUTLAY $0.00 $194,479.06 $0.00 0.00% $8,650.00 E 101-43100-505 GIS Operation and Maintenance $0.00 $1,983.75 $0.00 0.00% $0.00 E 101-43100-606 CAPITAL LEASE PRINCIPAL $0.00 $0.00 $13,652.00 0.00% $148,637.87 E 101-43100-619 CAPITAL LEASE INTEREST $0.00 $0.00 $1,385.00 0.00% $8,370.52 E 101-43100-740 TRANSFER TO CAPITAL FUND $0.00 $0.00 $45,000.00 0.00% $45,000.00 43100 STREETS $19,155.13 $332,808.21 $376,324.85 88.44% $525,815.09

43160 STREET LIGHTING E 101-43160-387 UTILITIES-STR. LIGHTS - ALLEY $1,623.81 $15,072.89 $23,420.00 64.36% $26,247.72 E 101-43160-388 UTILITIES-STR. LIGHTS-MAIN/G $213.77 $1,966.09 $3,790.00 51.88% $3,646.04 43160 STREET LIGHTING $1,837.58 $17,038.98 $27,210.00 62.62% $29,893.76

43250 RECYCLING E 101-43250-386 RECYCLING $3,865.00 $27,035.00 $0.00 0.00% $46,360.00 43250 RECYCLING $3,865.00 $27,035.00 $0.00 0.00% $46,360.00

24 08/16/24 9:12 AM Page 5 JULY 2024 %YTD Account Last Dim Descr 2024 Amt YTD Amt 2024 Budget Budget 2023 Amt

45124 SWIMMING POOL E 101-45124-100 SALARIES - PART TIME $17,171.37 $29,751.54 $38,818.50 76.64% $44,766.95 E 101-45124-101 SALARIES - REGULAR $362.98 $784.40 $1,606.50 48.83% $3,717.04 E 101-45124-102 SALARIES - OVERTIME $0.00 $0.00 $1,606.50 0.00% $1,525.04 E 101-45124-121 PERA - EMPLOYER SHARE $657.31 $685.58 $270.00 253.92% $377.11 E 101-45124-122 FICA - EMPLOYER SHARE $1,341.35 $2,299.89 $3,133.00 73.41% $3,815.07 E 101-45124-130 INSURANCE - MED/DENT/LIFE/ $173.13 $926.13 $645.00 143.59% $1,736.69 E 101-45124-150 INSURANCE - WORKERS COMP $155.67 $1,089.69 $1,780.00 61.22% $3,982.06 E 101-45124-210 OPERATING SUPPLIES & EXPEN $217.48 $1,338.51 $2,500.00 53.54% $2,829.18 E 101-45124-216 CHEMICALS $3,001.04 $6,660.29 $5,000.00 133.21% $4,490.01 E 101-45124-250 MERCHANDISE FOR RESALE $577.96 $2,310.84 $2,500.00 92.43% $3,516.28 E 101-45124-311 CONFERENCE & TRAINING $0.00 $0.00 $1,200.00 0.00% $1,536.06 E 101-45124-321 UTILITIES-PHONE/INTERNET/C $208.19 $696.70 $755.00 92.28% $1,195.30 E 101-45124-331 TRAVEL EXPENSE $0.00 $0.00 $0.00 0.00% $122.20 E 101-45124-339 PAY PAL FEES $25.03 $167.09 $0.00 0.00% $3.87 E 101-45124-340 ADVERTISING $0.00 $0.00 $180.00 0.00% $73.50 E 101-45124-360 INSURANCE - PROPERTY/LIABIL $225.26 $1,576.82 $3,450.00 45.70% $3,671.45 E 101-45124-381 UTILITIES-ELECTRIC & WATER $1,564.11 $4,349.10 $5,480.00 79.36% $5,101.88 E 101-45124-383 UTILITIES-NATURAL GAS $1,394.98 $3,624.17 $5,500.00 65.89% $4,943.94 E 101-45124-384 UTILITIES-REFUSE/RECYCLING $0.00 $80.00 $100.00 80.00% $0.00 E 101-45124-385 UTILITIES-SEWER CHARGES $1,157.60 $3,857.25 $3,910.00 98.65% $4,189.74 E 101-45124-400 REPAIRS AND MAINT $440.49 $13,445.23 $5,000.00 268.90% $1,024.82 E 101-45124-418 UNIFORMS $0.00 $935.00 $850.00 110.00% $815.27 E 101-45124-429 PERMITS AND LICENSES $0.00 $0.00 $900.00 0.00% $1,740.00 E 101-45124-430 MISCELLANEOUS -$5.65 $0.00 $300.00 0.00% $169.13 E 101-45124-501 CAPITAL OUTLAY $0.00 $0.00 $0.00 0.00% $6,361.50 E 101-45124-740 TRANSFER TO CAPITAL FUND $0.00 $0.00 $35,000.00 0.00% $35,000.00 45124 SWIMMING POOL $28,668.30 $74,578.23 $120,484.50 61.90% $136,704.09

45200 PARKS E 101-45200-101 SALARIES - REGULAR $2,187.86 $16,513.93 $26,225.25 62.97% $27,683.51 E 101-45200-102 SALARIES - OVERTIME $0.00 $436.96 $1,606.50 27.20% $1,243.13 E 101-45200-121 PERA - EMPLOYER SHARE $164.09 $1,327.34 $1,885.00 70.42% $2,225.22 E 101-45200-122 FICA - EMPLOYER SHARE $167.38 $1,266.45 $2,030.00 62.39% $542.86 E 101-45200-130 INSURANCE - MED/DENT/LIFE/ $1,198.73 $5,900.07 $10,332.00 57.10% $10,542.00 E 101-45200-142 UNEMPLOYMENT COMPENSATI $0.00 $22.56 $0.00 0.00% $0.00 E 101-45200-150 INSURANCE - WORKERS COMP $74.83 $523.81 $760.00 68.92% $1,825.04 E 101-45200-210 OPERATING SUPPLIES & EXPEN $548.23 $1,623.01 $2,000.00 81.15% $2,225.92 E 101-45200-212 MOTOR FUELS, LUBES, ADDITIV $238.75 $598.82 $1,200.00 49.90% $941.53 E 101-45200-360 INSURANCE - PROPERTY/LIABIL $724.75 $5,073.25 $4,738.00 107.08% $9,019.04

25 08/16/24 9:12 AM Page 6 JULY 2024 %YTD Account Last Dim Descr 2024 Amt YTD Amt 2024 Budget Budget 2023 Amt E 101-45200-381 UTILITIES-ELECTRIC & WATER $18.25 $148.23 $1,260.00 11.76% $1,294.00 E 101-45200-383 UTILITIES-NATURAL GAS $38.36 $270.00 $1,050.00 25.71% $709.18 E 101-45200-385 UTILITIES-SEWER CHARGES $19.35 $122.85 $160.00 76.78% $269.11 E 101-45200-400 REPAIRS AND MAINT $4,623.07 $8,496.15 $3,000.00 283.21% $1,077.00 E 101-45200-606 CAPITAL LEASE PRINCIPAL $0.00 $0.00 $3,823.00 0.00% $5,472.33 E 101-45200-619 CAPITAL LEASE INTEREST $0.00 $0.00 $388.00 0.00% $307.23 E 101-45200-740 TRANSFER TO CAPITAL FUND $0.00 $0.00 $15,000.00 0.00% $15,000.00 45200 PARKS $10,003.65 $42,323.43 $75,457.75 56.09% $80,377.10

45300 GUNDERSON HOUSE E 101-45300-314 MANAGEMENT FEES $0.00 $5,000.00 $2,500.00 200.00% $0.00 E 101-45300-360 INSURANCE - PROPERTY/LIABIL $403.70 $2,825.90 $3,500.00 80.74% $7,069.56 E 101-45300-400 REPAIRS AND MAINT $0.00 $89.03 $500.00 17.81% $118.88 E 101-45300-740 TRANSFER TO CAPITAL FUND $0.00 $0.00 $8,000.00 0.00% $8,000.00 45300 GUNDERSON HOUSE $403.70 $7,914.93 $14,500.00 54.59% $15,188.44

45400 COMMUNITY GARDEN E 101-45400-210 OPERATING SUPPLIES & EXPEN $0.00 $41.17 $0.00 0.00% $19.99 45400 COMMUNITY GARDEN $0.00 $41.17 $0.00 0.00% $19.99 101 GENERAL FUND -$97,455.88 $949,353.88 $1,622,729.95 58.50% $1,958,236.96

202 CAPITAL OUTLAY

48100 GEN GOVMNT CAPITAL OUTLAY E 202-48100-501 CAPITAL OUTLAY $0.00 $0.00 $0.00 0.00% $53,200.00 48100 GEN GOVMNT CAPITAL OUTLAY $0.00 $0.00 $0.00 0.00% $53,200.00

48300 STREETS & HWY CAPITAL OUTLAY E 202-48300-719 TRANSFER-INTERFUND $0.00 $18,261.39 $0.00 0.00% $8,145.36 48300 STREETS & HWY CAPITAL OUTLAY $0.00 $18,261.39 $0.00 0.00% $8,145.36

48500 CULTURE & REC CAPITAL OUTLAY E 202-48500-501 CAPITAL OUTLAY $0.00 $0.00 $0.00 0.00% $12,225.68 48500 CULTURE & REC CAPITAL OUTLAY $0.00 $0.00 $0.00 0.00% $12,225.68 202 CAPITAL OUTLAY $0.00 $18,261.39 $0.00 0.00% $73,571.04

203 FIRE

42200 FIRE E 203-42200-119 ADMIN FEE- FIRE & RESCUE $0.00 $0.00 $250.00 0.00% $0.00 E 203-42200-150 INSURANCE - WORKERS COMP $451.83 $3,162.81 $5,500.00 57.51% $6,024.69 E 203-42200-200 OFFICE SUPPLIES $0.00 $32.29 $0.00 0.00% $0.00

26 08/16/24 9:12 AM Page 7 JULY 2024 %YTD Account Last Dim Descr 2024 Amt YTD Amt 2024 Budget Budget 2023 Amt E 203-42200-210 OPERATING SUPPLIES & EXPEN $327.48 $1,185.09 $3,500.00 33.86% $3,352.76 E 203-42200-212 MOTOR FUELS, LUBES, ADDITIV $690.44 $2,133.28 $2,500.00 85.33% $1,890.67 E 203-42200-301 AUDITING $3,000.00 $3,000.00 $3,000.00 100.00% $3,000.00 E 203-42200-305 MEDICAL $0.00 $0.00 $2,600.00 0.00% $5,285.00 E 203-42200-321 UTILITIES-PHONE/INTERNET/C $259.90 $1,585.25 $2,755.00 57.54% $3,253.95 E 203-42200-323 PAGERS/MAINTENANCE $0.00 $1,568.75 $2,000.00 78.44% $1,568.75 E 203-42200-331 TRAVEL EXPENSE $0.00 $0.00 $350.00 0.00% $453.26 E 203-42200-341 FIRE DEPT PRACTICE MEALS $250.59 $1,119.18 $2,500.00 44.77% $2,163.65 E 203-42200-342 TRAINING FEES $0.00 -$1,400.00 $13,000.00 -10.77% $8,810.00 E 203-42200-344 BANQUETS/SPECIAL EVENTS $0.00 $2,642.20 $2,500.00 105.69% $1,275.00 E 203-42200-360 INSURANCE - PROPERTY/LIABIL $253.71 $1,775.97 $6,250.00 28.42% $5,914.59 E 203-42200-381 UTILITIES-ELECTRIC & WATER $404.47 $2,524.48 $5,375.00 46.97% $4,806.93 E 203-42200-383 UTILITIES-NATURAL GAS $0.00 $2,018.35 $6,000.00 33.64% $4,670.79 E 203-42200-384 UTILITIES-REFUSE/RECYCLING $27.49 $192.43 $585.00 32.89% $558.41 E 203-42200-385 UTILITIES-SEWER CHARGES $131.67 $776.93 $850.00 91.40% $1,039.11 E 203-42200-400 REPAIRS AND MAINT $6,774.16 $10,248.31 $12,000.00 85.40% $3,457.13 E 203-42200-414 OSHA/SAFETY CLOTH. & EQUIP $39,640.00 $39,657.32 $0.00 0.00% $78,924.94 E 203-42200-418 UNIFORMS $17,145.43 $19,503.50 $56,000.00 34.83% $38,069.10 E 203-42200-419 STATE AID FORWARD TO FIRE $0.00 $0.00 $26,000.00 0.00% $64,046.29 E 203-42200-430 MISCELLANEOUS $0.00 $1,104.08 $1,000.00 110.41% $0.00 E 203-42200-433 DUES AND SUBSCRIPTIONS $0.00 $2,000.00 $1,200.00 166.67% $1,535.00 E 203-42200-491 K. FIRE RELIEF ASSOC. DONATI $10,000.00 $10,000.00 $10,000.00 100.00% $10,000.00 E 203-42200-520 REPAIRS - BLDG & STRUCTURE $0.00 $0.00 $1,500.00 0.00% $36.13 E 203-42200-606 CAPITAL LEASE PRINCIPAL $0.00 $99,684.56 $18,407.56 541.54% $17,824.78 E 203-42200-619 CAPITAL LEASE INTEREST $0.00 $3,673.16 $3,212.44 114.34% $3,795.22 E 203-42200-740 TRANSFER TO CAPITAL FUND $0.00 $0.00 $64,500.00 0.00% $64,500.00 42200 FIRE $79,357.17 $208,187.94 $253,335.00 82.18% $336,256.15

42270 FIRST RESPONDERS E 203-42270-210 OPERATING SUPPLIES & EXPEN $0.00 $1,062.16 $1,000.00 106.22% $1,067.64 E 203-42270-212 MOTOR FUELS, LUBES, ADDITIV $0.00 $241.52 $1,000.00 24.15% $534.64 E 203-42270-311 CONFERENCE & TRAINING $0.00 $2,400.00 $2,000.00 120.00% $2,000.00 E 203-42270-360 INSURANCE - PROPERTY/LIABIL $34.25 $239.75 $246.00 97.46% $456.22 E 203-42270-400 REPAIRS AND MAINT $0.00 $0.00 $1,200.00 0.00% $0.00 E 203-42270-433 DUES AND SUBSCRIPTIONS $0.00 $0.00 $400.00 0.00% $0.00 E 203-42270-740 TRANSFER TO CAPITAL FUND $0.00 $0.00 $5,000.00 0.00% $5,000.00 42270 FIRST RESPONDERS $34.25 $3,943.43 $10,846.00 36.36% $9,058.50 203 FIRE $79,391.42 $212,131.37 $264,181.00 80.30% $345,314.65

204 LIBRARY

27 08/16/24 9:12 AM Page 8 JULY 2024 %YTD Account Last Dim Descr 2024 Amt YTD Amt 2024 Budget Budget 2023 Amt

45500 LIBRARY E 204-45500-100 SALARIES - PART TIME $2,793.26 $18,562.60 $37,900.00 48.98% $32,679.16 E 204-45500-101 SALARIES - REGULAR $4,484.20 $31,352.92 $57,215.00 54.80% $58,691.59 E 204-45500-102 SALARIES - OVERTIME $0.00 $168.16 $0.00 0.00% $0.00 E 204-45500-121 PERA - EMPLOYER SHARE $569.68 $3,794.08 $6,930.00 54.75% $7,085.13 E 204-45500-122 FICA - EMPLOYER SHARE $581.08 $3,739.43 $7,253.00 51.56% $2,367.94 E 204-45500-130 INSURANCE - MED/DENT/LIFE/ $2,359.58 $14,496.79 $29,510.00 49.13% $28,621.67 E 204-45500-131 EMPLOYER H.S.A.EXPENSE $0.00 $2,550.02 $0.00 0.00% $1,218.75 E 204-45500-142 UNEMPLOYMENT COMPENSATI $0.00 $82.76 $0.00 0.00% $0.00 E 204-45500-150 INSURANCE - WORKERS COMP $37.17 $260.19 $600.00 43.37% $487.81 E 204-45500-210 OPERATING SUPPLIES & EXPEN $75.34 $1,205.74 $2,000.00 60.29% $1,643.28 E 204-45500-300 AUTOMATION $270.17 $3,199.49 $5,600.00 57.13% $6,633.74 E 204-45500-311 CONFERENCE & TRAINING $0.00 $0.00 $150.00 0.00% $0.00 E 204-45500-321 UTILITIES-PHONE/INTERNET/C $0.00 $0.00 $1,065.00 0.00% $832.28 E 204-45500-331 TRAVEL EXPENSE $0.00 $50.92 $300.00 16.97% $27.51 E 204-45500-340 ADVERTISING $0.00 $0.00 $50.00 0.00% $50.00 E 204-45500-360 INSURANCE - PROPERTY/LIABIL $336.97 $2,358.79 $3,000.00 78.63% $3,519.83 E 204-45500-381 UTILITIES-ELECTRIC & WATER $295.53 $1,696.52 $3,800.00 44.65% $3,357.75 E 204-45500-383 UTILITIES-NATURAL GAS $5.65 $594.02 $1,090.00 54.50% $978.21 E 204-45500-385 UTILITIES-SEWER CHARGES $75.60 $520.79 $750.00 69.44% $748.88 E 204-45500-400 REPAIRS AND MAINT $0.00 $0.00 $250.00 0.00% $0.00 E 204-45500-410 LEASE $67.54 $448.54 $800.00 56.07% $780.16 E 204-45500-430 MISCELLANEOUS $0.00 $45.67 $50.00 91.34% $0.00 E 204-45500-433 DUES AND SUBSCRIPTIONS $0.00 $182.90 $400.00 45.73% $504.20 E 204-45500-490 DONATIONS $0.00 $1,416.66 $0.00 0.00% $0.00 E 204-45500-501 CAPITAL OUTLAY $0.00 $800.00 $0.00 0.00% $0.00 E 204-45500-570 OFFICE EQUIPMENT PURCHASE $0.00 $1,023.34 $1,200.00 85.28% $1,249.82 E 204-45500-590 BOOKS $2,061.71 $14,617.82 $22,500.00 64.97% $22,316.76 45500 LIBRARY $14,013.48 $103,168.15 $182,413.00 56.56% $173,794.47 204 LIBRARY $14,013.48 $103,168.15 $182,413.00 56.56% $173,794.47

205 ECONOMIC DEVELOPMENT AUTHORITY

46200 SEMMCHRA DEED GRANT E 205-46200-444 DEED GRANT FORWARD TO SE $0.00 $0.00 $1,000.00 0.00% $0.00 46200 SEMMCHRA DEED GRANT $0.00 $0.00 $1,000.00 0.00% $0.00

46500 ECONOMIC DEVELOPMENT AUTHORITY E 205-46500-107 EDA BOARD MEMBER PAY $0.00 $1,190.00 $650.00 183.08% $0.00 E 205-46500-265 PROPERTY TAX $0.00 $1,422.00 $1,465.00 97.06% $1,406.00 E 205-46500-303 ENGINEERING $0.00 $0.00 $5,000.00 0.00% $0.00

28 08/16/24 9:12 AM Page 9 JULY 2024 %YTD Account Last Dim Descr 2024 Amt YTD Amt 2024 Budget Budget 2023 Amt E 205-46500-304 LEGAL $0.00 $2,347.50 $3,000.00 78.25% $1,081.00 E 205-46500-307 CONTRACT SERVICES $7,493.75 $20,799.06 $1,000.00 2079.91% $29,158.00 E 205-46500-331 TRAVEL EXPENSE $0.00 $0.00 $1,000.00 0.00% $344.50 E 205-46500-340 ADVERTISING $0.00 $1,223.13 $2,500.00 48.93% $1,178.00 E 205-46500-344 BANQUETS/SPECIAL EVENTS $0.00 $300.00 $0.00 0.00% $0.00 E 205-46500-360 INSURANCE - PROPERTY/LIABIL $14.14 $98.98 $2,090.00 4.74% $432.74 E 205-46500-385 UTILITIES-SEWER CHARGES $9.00 $58.03 $50.00 116.06% $48.36 E 205-46500-400 REPAIRS AND MAINT $0.00 $0.00 $250.00 0.00% $462.95 E 205-46500-430 MISCELLANEOUS $0.00 $0.00 $50.00 0.00% $0.00 E 205-46500-433 DUES AND SUBSCRIPTIONS $0.00 $0.00 $300.00 0.00% $0.00 E 205-46500-480 FAÇADE IMPROVEMENTS $0.00 $0.00 $0.00 0.00% $7,186.00 E 205-46500-609 LOAN PRINCIPAL-INTERFUND K $10,610.00 $10,610.00 $10,352.00 102.49% $0.00 E 205-46500-610 LOAN INTEREST - INTERFUND $816.00 $816.00 $1,074.00 75.98% $1,074.00 46500 ECONOMIC DEVELOPMENT AUTHORIT $18,942.89 $38,864.70 $28,781.00 135.04% $42,371.55 205 ECONOMIC DEVELOPMENT AUTHORITY $18,942.89 $38,864.70 $29,781.00 130.50% $42,371.55

230 SPECIAL PURPOSE DONATIONS

42000 PUBLIC SAFETY E 230-42000-430 MISCELLANEOUS $0.00 $99.53 $0.00 0.00% $50,480.06 42000 PUBLIC SAFETY $0.00 $99.53 $0.00 0.00% $50,480.06

45000 CULTURE & RECREATION E 230-45000-346 ROSE FEST $1,981.00 $2,686.22 $0.00 0.00% $15,370.04 E 230-45000-430 MISCELLANEOUS $20,627.62 $21,537.49 $0.00 0.00% $3,972.34 45000 CULTURE & RECREATION $22,608.62 $24,223.71 $0.00 0.00% $19,342.38

45500 LIBRARY E 230-45500-430 MISCELLANEOUS $0.00 $305.90 $0.00 0.00% $0.00 45500 LIBRARY $0.00 $305.90 $0.00 0.00% $0.00 230 SPECIAL PURPOSE DONATIONS $22,608.62 $24,629.14 $0.00 0.00% $69,822.44

301 2012 G.O. IMP. BONDS-STREETS

47000 DEBT SERVICE E 301-47000-601 BOND PRINCIPAL $0.00 $0.00 $0.00 0.00% $8,905.00 E 301-47000-611 BOND INTEREST $0.00 $0.00 $0.00 0.00% $122.45 47000 DEBT SERVICE $0.00 $0.00 $0.00 0.00% $9,027.45 301 2012 G.O. IMP. BONDS-STREETS $0.00 $0.00 $0.00 0.00% $9,027.45

303 2016 FIRST STREET IMPROVEMENTS

29 08/16/24 9:12 AM Page 10 JULY 2024 %YTD Account Last Dim Descr 2024 Amt YTD Amt 2024 Budget Budget 2023 Amt

47000 DEBT SERVICE E 303-47000-608 BOND PRINCIPAL - 2016 FIRST $0.00 $30,000.00 $19,350.00 155.04% $19,350.00 E 303-47000-614 BOND INTEREST 2016 FIRST ST $0.00 $9,546.46 $7,449.75 128.14% $7,788.37 E 303-47000-620 FISCAL AGENT FEES $0.00 $1,045.00 $990.00 105.56% $990.00 47000 DEBT SERVICE $0.00 $40,591.46 $27,789.75 146.07% $28,128.37 303 2016 FIRST STREET IMPROVEMENTS $0.00 $40,591.46 $27,789.75 146.07% $28,128.37

310 2020A GO BOND (RW, BUS PK, 2ND

47000 DEBT SERVICE E 310-47000-604 BOND PRINCIPAL - 2020A BON $0.00 $91,040.51 $91,040.51 100.00% $93,102.01 E 310-47000-615 BOND INTEREST - 2020A BOND $0.00 $47,218.94 $47,218.94 100.00% $52,322.84 E 310-47000-620 FISCAL AGENT FEES $0.00 $495.00 $0.00 0.00% $0.00 47000 DEBT SERVICE $0.00 $138,754.45 $138,259.45 100.36% $145,424.85 310 2020A GO BOND (RW, BUS PK, 2ND $0.00 $138,754.45 $138,259.45 100.36% $145,424.85

320 2016B GO USDA BOND FIRE HALL

47100 2016 FIRE HALL BOND CIP NOTES E 320-47100-624 BOND PRIN-2016B CIP FIRE HA $0.00 $0.00 $34,762.22 0.00% $33,787.73 E 320-47100-625 BOND INT-2016B CIP FIRE HAL $0.00 $0.00 $56,362.78 0.00% $57,328.26 47100 2016 FIRE HALL BOND CIP NOTES $0.00 $0.00 $91,125.00 0.00% $91,115.99 320 2016B GO USDA BOND FIRE HALL $0.00 $0.00 $91,125.00 0.00% $91,115.99

321 2016B USDA NOTE FIRE HALL

47200 2016 FIRE HALL BOND USDA NOTES E 321-47200-626 BOND PRIN-2016B USDA FIRE $0.00 $0.00 $7,378.48 0.00% $7,172.27 E 321-47200-627 BOND INT-2016B USDA FIRE H $0.00 $0.00 $11,962.52 0.00% $12,168.73 47200 2016 FIRE HALL BOND USDA NOTES $0.00 $0.00 $19,341.00 0.00% $19,341.00 321 2016B USDA NOTE FIRE HALL $0.00 $0.00 $19,341.00 0.00% $19,341.00

323 2023A G.O. Bond

47300 2023 Pearl Creek/Street Improv E 323-47300-611 BOND INTEREST $24,752.88 $24,752.88 $0.00 0.00% $0.00 E 323-47300-622 BOND ISSUANCE COSTS $0.00 $0.00 $0.00 0.00% -$0.47 47300 2023 Pearl Creek/Street Improv $24,752.88 $24,752.88 $0.00 0.00% -$0.47 323 2023A G.O. Bond $24,752.88 $24,752.88 $0.00 0.00% -$0.47

331 2020 FREIGHTLINER 114SD

30 08/16/24 9:12 AM Page 11 JULY 2024 %YTD Account Last Dim Descr 2024 Amt YTD Amt 2024 Budget Budget 2023 Amt

47000 DEBT SERVICE E 331-47000-606 CAPITAL LEASE PRINCIPAL $16,847.34 $33,425.29 $33,425.29 100.00% $32,364.90 E 331-47000-619 CAPITAL LEASE INTEREST $1,414.05 $3,097.49 $3,097.49 100.00% $4,157.88 47000 DEBT SERVICE $18,261.39 $36,522.78 $36,522.78 100.00% $36,522.78 331 2020 FREIGHTLINER 114SD $18,261.39 $36,522.78 $36,522.78 100.00% $36,522.78

336 2019 FORD F150 LEASE

47000 DEBT SERVICE E 336-47000-606 CAPITAL LEASE PRINCIPAL $0.00 $0.00 $0.00 0.00% $7,704.06 E 336-47000-619 CAPITAL LEASE INTEREST $0.00 $0.00 $0.00 0.00% $441.30 47000 DEBT SERVICE $0.00 $0.00 $0.00 0.00% $8,145.36 336 2019 FORD F150 LEASE $0.00 $0.00 $0.00 0.00% $8,145.36

340 RED WING AVE CAPITAL PROJECT

47000 DEBT SERVICE E 340-47000-622 BOND ISSUANCE COSTS $0.00 $0.00 $0.00 0.00% $0.00 47000 DEBT SERVICE $0.00 $0.00 $0.00 0.00% $0.00 340 RED WING AVE CAPITAL PROJECT $0.00 $0.00 $0.00 0.00% $0.00

405 2023 Street Overlay Proj

43100 STREETS E 405-43100-501 CAPITAL OUTLAY $925.00 $20,245.25 $0.00 0.00% $638,774.57 43100 STREETS $925.00 $20,245.25 $0.00 0.00% $638,774.57 405 2023 Street Overlay Proj $925.00 $20,245.25 $0.00 0.00% $638,774.57

602 SANITARY SEWER

43256 SEWER E 602-43256-101 SALARIES - REGULAR $3,894.88 $31,346.66 $51,180.15 61.25% $48,972.16 E 602-43256-102 SALARIES - OVERTIME $1,216.62 $4,186.34 $11,476.50 36.48% $10,365.09 E 602-43256-121 PERA - EMPLOYER SHARE $383.37 $2,499.23 $4,796.23 52.11% $4,687.03 E 602-43256-122 FICA - EMPLOYER SHARE $391.03 $2,608.09 $4,699.25 55.50% $1,238.92 E 602-43256-130 INSURANCE - MED/DENT/LIFE/ $1,797.89 $10,382.76 $18,340.00 56.61% $19,066.54 E 602-43256-131 EMPLOYER H.S.A.EXPENSE $0.00 $1,950.00 $0.00 0.00% $0.00 E 602-43256-142 UNEMPLOYMENT COMPENSATI $0.00 $19.91 $0.00 0.00% $0.00 E 602-43256-150 INSURANCE - WORKERS COMP $146.50 $1,025.50 $2,020.00 50.77% $1,809.20 E 602-43256-210 OPERATING SUPPLIES & EXPEN $703.88 $7,032.50 $15,000.00 46.88% $19,911.74 E 602-43256-212 MOTOR FUELS, LUBES, ADDITIV $0.00 $6.99 $3,000.00 0.23% $3,198.83 E 602-43256-216 CHEMICALS $2,371.49 $7,033.77 $8,000.00 87.92% $7,638.51

31 08/16/24 9:12 AM Page 12 JULY 2024 %YTD Account Last Dim Descr 2024 Amt YTD Amt 2024 Budget Budget 2023 Amt E 602-43256-265 PROPERTY TAX $0.00 $956.00 $860.00 111.16% $788.00 E 602-43256-303 ENGINEERING $0.00 $0.00 $5,000.00 0.00% $237.00 E 602-43256-304 LEGAL $0.00 $0.00 $500.00 0.00% $0.00 E 602-43256-307 CONTRACT SERVICES $0.00 $0.00 $3,100.00 0.00% $3,256.89 E 602-43256-311 CONFERENCE & TRAINING $0.00 $458.58 $500.00 91.72% $587.37 E 602-43256-321 UTILITIES-PHONE/INTERNET/C $58.85 $226.75 $1,380.00 16.43% $977.88 E 602-43256-331 TRAVEL EXPENSE $0.00 $381.99 $700.00 54.57% $262.00 E 602-43256-360 INSURANCE - PROPERTY/LIABIL $917.08 $6,419.56 $11,000.00 58.36% $11,832.12 E 602-43256-381 UTILITIES-ELECTRIC & WATER $8,103.80 $29,345.30 $38,630.00 75.97% $44,336.90 E 602-43256-383 UTILITIES-NATURAL GAS $0.00 $3,127.26 $4,500.00 69.49% $8,210.55 E 602-43256-384 UTILITIES-REFUSE/RECYCLING $62.97 $440.79 $680.00 64.82% $819.74 E 602-43256-385 UTILITIES-SEWER CHARGES $4,487.45 $14,296.34 $18,590.00 76.90% $23,936.50 E 602-43256-400 REPAIRS AND MAINT $0.00 $18,419.55 $25,000.00 73.68% $30,732.26 E 602-43256-414 OSHA/SAFETY CLOTH. & EQUIP $0.00 $0.00 $1,000.00 0.00% $150.00 E 602-43256-418 UNIFORMS $48.20 $134.13 $400.00 33.53% $194.90 E 602-43256-420 DEPRECIATION $13,854.58 $94,170.87 $167,000.00 56.39% $233,290.00 E 602-43256-429 PERMITS AND LICENSES $0.00 $1,473.00 $1,600.00 92.06% $1,642.15 E 602-43256-430 MISCELLANEOUS $0.00 $0.00 $500.00 0.00% $0.00 E 602-43256-501 CAPITAL OUTLAY $0.00 $13,602.40 $20,000.00 68.01% $33,207.97 E 602-43256-505 GIS Operation and Maintenance $0.00 $3,399.98 $0.00 0.00% $0.00 E 602-43256-603 BOND PRINCIPAL - 2012 HWY 5 $0.00 $0.00 $0.00 0.00% $0.00 E 602-43256-604 BOND PRINCIPAL - 2020A BON $0.00 $39,749.11 $39,749.11 100.00% $0.00 E 602-43256-605 LOAN PRINCIPAL - PFA (RATES) $93,000.00 $93,000.00 $93,000.00 100.00% $0.00 E 602-43256-606 CAPITAL LEASE PRINCIPAL $0.00 $0.00 $26,223.00 0.00% $0.44 E 602-43256-608 BOND PRINCIPAL - 2016 FIRST $0.00 $0.00 $8,460.00 0.00% $0.00 E 602-43256-611 BOND INTEREST $0.00 $0.00 $0.00 0.00% $53.28 E 602-43256-612 LOAN INTEREST - PFA $4,875.00 $9,750.00 $9,750.00 100.00% $10,344.00 E 602-43256-614 BOND INTEREST 2016 FIRST ST $0.00 $1,591.54 $3,257.10 48.86% $3,554.15 E 602-43256-615 BOND INTEREST - 2020A BOND $0.00 $20,616.22 $20,616.22 100.00% $23,495.15 E 602-43256-616 BOND INTEREST - 2023A BOND $63,754.96 $63,754.96 $0.00 0.00% $21,149.00 E 602-43256-619 CAPITAL LEASE INTEREST $0.00 $0.00 $964.00 0.00% $2,025.85 E 602-43256-622 BOND ISSUANCE COSTS $0.00 $0.00 $0.00 0.00% $47,015.07 43256 SEWER $200,068.55 $483,406.08 $621,471.56 77.78% $618,987.19

47300 2023 Pearl Creek/Street Improv E 602-47300-611 BOND INTEREST $0.00 $0.00 $63,448.00 0.00% $0.00 47300 2023 Pearl Creek/Street Improv $0.00 $0.00 $63,448.00 0.00% $0.00 602 SANITARY SEWER $200,068.55 $483,406.08 $684,919.56 70.58% $618,987.19

605 STORM SEWER

32 08/16/24 9:12 AM Page 13 JULY 2024 %YTD Account Last Dim Descr 2024 Amt YTD Amt 2024 Budget Budget 2023 Amt

43251 STORM SEWER UTIL & MAINT E 605-43251-101 SALARIES - REGULAR $992.33 $9,588.09 $12,822.60 74.77% $12,638.80 E 605-43251-102 SALARIES - OVERTIME $0.00 $342.20 $0.00 0.00% $64.40 E 605-43251-121 PERA - EMPLOYER SHARE $74.43 $666.61 $915.00 72.85% $1,016.50 E 605-43251-122 FICA - EMPLOYER SHARE $75.92 $651.48 $935.00 69.68% $86.66 E 605-43251-130 INSURANCE - MED/DENT/LIFE/ $579.75 $3,010.72 $5,445.00 55.29% $5,404.31 E 605-43251-131 EMPLOYER H.S.A.EXPENSE $0.00 $750.01 $0.00 0.00% $1,078.13 E 605-43251-142 UNEMPLOYMENT COMPENSATI $0.00 $6.24 $0.00 0.00% $0.00 E 605-43251-150 INSURANCE - WORKERS COMP $20.50 $143.50 $291.00 49.31% $257.73 E 605-43251-212 MOTOR FUELS, LUBES, ADDITIV $0.00 $202.77 $1,500.00 13.52% $1,416.42 E 605-43251-360 INSURANCE - PROPERTY/LIABIL $27.20 $190.40 $300.00 63.47% $347.05 E 605-43251-400 REPAIRS AND MAINT $0.00 $0.00 $9,000.00 0.00% $6,014.09 E 605-43251-420 DEPRECIATION $8,630.71 $60,414.97 $51,827.80 116.57% $52,031.00 E 605-43251-501 CAPITAL OUTLAY $0.00 $58,492.17 $15,000.00 389.95% $0.00 E 605-43251-603 BOND PRINCIPAL - 2012 HWY 5 $0.00 $0.00 $0.00 0.00% $0.00 E 605-43251-604 BOND PRINCIPAL - 2020A BON $0.00 $26,159.69 $26,159.69 100.00% $0.00 E 605-43251-606 CAPITAL LEASE PRINCIPAL $0.00 $0.00 $18,940.00 0.00% $0.06 E 605-43251-608 BOND PRINCIPAL - 2016 FIRST $0.00 $0.00 $1,260.00 0.00% $0.00 E 605-43251-611 BOND INTEREST $0.00 $0.00 $0.00 0.00% $30.43 E 605-43251-614 BOND INTEREST 2016 FIRST ST $0.00 $237.04 $485.10 48.86% $529.15 E 605-43251-615 BOND INTEREST - 2020A BOND $0.00 $13,567.95 $13,567.95 100.00% $10,647.18 E 605-43251-619 CAPITAL LEASE INTEREST $0.00 $0.00 $3,021.00 0.00% $6,511.25 43251 STORM SEWER UTIL & MAINT $10,400.84 $174,423.84 $161,470.14 108.02% $98,073.16 605 STORM SEWER $10,400.84 $174,423.84 $161,470.14 108.02% $98,073.16

609 LIQUOR

49750 LIQUOR E 609-49750-100 SALARIES - PART TIME $4,790.97 $4,790.97 $0.00 0.00% $100.61 E 609-49750-101 SALARIES - REGULAR $5,100.00 $5,100.00 $0.00 0.00% $0.00 E 609-49750-102 SALARIES - OVERTIME $0.00 $0.00 $0.00 0.00% $150.98 E 609-49750-108 SALARIES - FULL-TIME ON-SAL $0.00 $6,335.06 $15,910.11 39.82% $15,109.00 E 609-49750-109 SALARIES - FULL-TIME OFF-SA $0.00 $6,351.06 $15,899.61 39.94% $14,993.00 E 609-49750-110 SALARIES - PART-TIME ON-SA $0.00 $20,577.94 $45,015.25 45.71% $34,047.36 E 609-49750-111 SALARIES - PART-TIME OFF-SA $0.00 $5,050.94 $23,292.85 21.68% $13,306.97 E 609-49750-112 SALARIES - ADMIN $0.00 $17,902.37 $34,400.08 52.04% $32,829.39 E 609-49750-121 PERA - EMPLOYER SHARE $741.83 $4,530.84 $9,038.84 50.13% $8,302.72 E 609-49750-122 FICA - EMPLOYER SHARE $756.65 $4,882.98 $9,219.62 52.96% $2,262.49 E 609-49750-130 INSURANCE - MED/DENT/LIFE/ $3,697.56 $22,589.80 $52,552.50 42.99% $42,910.04 E 609-49750-131 EMPLOYER H.S.A.EXPENSE $0.00 $2,550.02 $0.00 0.00% $1,218.75

33 08/16/24 9:12 AM Page 14 JULY 2024 %YTD Account Last Dim Descr 2024 Amt YTD Amt 2024 Budget Budget 2023 Amt E 609-49750-142 UNEMPLOYMENT COMPENSATI $0.00 $151.28 $0.00 0.00% $0.00 E 609-49750-150 INSURANCE - WORKERS COMP $264.83 $1,853.81 $3,000.00 61.79% $3,436.39 E 609-49750-208 SERVING SUPPLY-FOOD & ALCO $319.45 $1,771.52 $2,700.00 65.61% $3,674.03 E 609-49750-210 OPERATING SUPPLIES & EXPEN $554.34 $6,444.66 $7,500.00 85.93% $7,096.96 E 609-49750-251 LIQUOR $14,491.75 $109,116.03 $178,500.00 61.13% $178,437.14 E 609-49750-252 BEER $30,306.60 $176,182.85 $335,000.00 52.59% $301,413.09 E 609-49750-253 WINE $1,791.21 $14,154.10 $27,000.00 52.42% $21,689.77 E 609-49750-254 SODA, MIX, JUICE $1,030.15 $9,073.14 $16,000.00 56.71% $16,161.44 E 609-49750-256 TOBACCO $1,800.04 $7,089.65 $15,000.00 47.26% $10,864.71 E 609-49750-257 FOOD/CONDIMENTS-COMPLIME $107.19 $1,361.15 $4,000.00 34.03% $2,088.05 E 609-49750-258 FOOD/MERCHANDISE FOR RESA $2,193.67 $13,073.23 $35,000.00 37.35% $25,574.70 E 609-49750-308 OUTSIDE JANITORIAL SERVICE $1,078.31 $7,548.17 $14,000.00 53.92% $12,939.72 E 609-49750-309 COMPUTER SUPPORT $200.00 $1,400.00 $5,000.00 28.00% $2,200.00 E 609-49750-311 CONFERENCE & TRAINING $0.00 $0.00 $600.00 0.00% $0.00 E 609-49750-321 UTILITIES-PHONE/INTERNET/C $468.86 $2,241.20 $2,600.00 86.20% $2,846.06 E 609-49750-325 SECURITY SYSTEM $43.91 $304.97 $1,000.00 30.50% $521.16 E 609-49750-327 PEST CONTROL $0.00 $420.00 $1,000.00 42.00% $960.00 E 609-49750-331 TRAVEL EXPENSE $0.00 $0.00 $1,100.00 0.00% $0.00 E 609-49750-333 FREIGHT or SHIPPING CHARGE $35.80 $268.50 $500.00 53.70% $855.30 E 609-49750-334 CREDIT CARD EXPENSES $1,794.02 $9,833.11 $15,000.00 65.55% $17,834.03 E 609-49750-340 ADVERTISING $0.00 $17.00 $1,000.00 1.70% $879.64 E 609-49750-345 SPECIAL EVENTS/ENTERTAINM $300.00 $1,809.76 $4,500.00 40.22% $3,591.69 E 609-49750-346 ROSE FEST $1,894.00 $2,894.00 $10,000.00 28.94% $11,473.71 E 609-49750-360 INSURANCE - PROPERTY/LIABIL $369.03 $6,533.42 $6,000.00 108.89% $4,042.59 E 609-49750-364 INSURANCE - DRAM LIQUOR LI $0.00 $5,863.29 $4,820.00 121.65% $402.00 E 609-49750-381 UTILITIES-ELECTRIC & WATER $825.91 $6,278.92 $11,430.00 54.93% $10,699.95 E 609-49750-383 UTILITIES-NATURAL GAS $0.00 $494.64 $1,120.00 44.16% $1,400.11 E 609-49750-384 UTILITIES-REFUSE/RECYCLING $142.06 $1,059.88 $1,510.00 70.19% $1,907.84 E 609-49750-385 UTILITIES-SEWER CHARGES $241.57 $1,722.43 $1,200.00 143.54% $1,475.08 E 609-49750-390 TAP CLEANING SERVICE $121.00 $457.00 $1,000.00 45.70% $672.00 E 609-49750-400 REPAIRS AND MAINT $0.00 $4,422.50 $4,000.00 110.56% $4,093.25 E 609-49750-418 UNIFORMS $0.00 $0.00 $500.00 0.00% $0.00 E 609-49750-420 DEPRECIATION $979.55 $6,856.85 $12,000.00 57.14% $11,756.00 E 609-49750-430 MISCELLANEOUS $0.00 -$136.29 $500.00 -27.26% $620.55 E 609-49750-431 CASH SHORT/OVER -$21.39 -$230.18 $100.00 -230.18% $139.36 E 609-49750-433 DUES AND SUBSCRIPTIONS $0.00 $1,160.00 $800.00 145.00% $822.10 E 609-49750-501 CAPITAL OUTLAY $0.00 $92,973.58 $10,000.00 929.74% $0.00 E 609-49750-725 TRANSFER TO GENERAL FUND $0.00 $0.00 $20,000.00 0.00% $20,000.00 49750 LIQUOR $76,418.87 $595,126.15 $960,308.86 61.97% $847,799.73 609 LIQUOR $76,418.87 $595,126.15 $960,308.86 61.97% $847,799.73

34 08/16/24 9:12 AM Page 15 JULY 2024 %YTD Account Last Dim Descr 2024 Amt YTD Amt 2024 Budget Budget 2023 Amt

900 GASB 34

41000 GENERAL GOVERNMENT E 900-41000-420 DEPRECIATION $2,217.68 $15,523.76 $0.00 0.00% $26,612.00 41000 GENERAL GOVERNMENT $2,217.68 $15,523.76 $0.00 0.00% $26,612.00

42000 PUBLIC SAFETY E 900-42000-420 DEPRECIATION $12,080.79 $77,280.18 $0.00 0.00% $132,959.00 42000 PUBLIC SAFETY $12,080.79 $77,280.18 $0.00 0.00% $132,959.00

43000 PUBLIC WORKS E 900-43000-420 DEPRECIATION $22,394.06 $132,159.97 $0.00 0.00% $247,438.00 43000 PUBLIC WORKS $22,394.06 $132,159.97 $0.00 0.00% $247,438.00

45000 CULTURE & RECREATION E 900-45000-420 DEPRECIATION $1,527.57 $11,927.69 $0.00 0.00% $18,516.00 45000 CULTURE & RECREATION $1,527.57 $11,927.69 $0.00 0.00% $18,516.00 900 GASB 34 $38,220.10 $236,891.60 $0.00 0.00% $425,525.00

$406,548.16 $3,097,123.12 $4,218,841.49 73.41% $5,629,976.09

35 08/16/24 9:15 AM CITY OF KENYON Page 1 CITY OF KENYON Revenue Summary

JULY 2024 2024 %YTD 2023 Account Last Dim Descr 2024 Amt YTD Amt Budget Budget YTD Amt

101 GENERAL FUND

00000 GENERAL REVENUE R 101-00000-32000 LICENSES & PERMITS $0.00 $3,420.00 $2,700.00 126.67% $1,535.00 R 101-00000-32002 RENTAL PROPERTY LICENSE $0.00 $0.00 $100.00 0.00% $60.00 R 101-00000-32110 ALCOHOL LICENSE $0.00 $1,200.00 $1,900.00 63.16% $1,900.00 R 101-00000-32210 BUILDING PERMIT $421.55 $2,620.92 $3,600.00 72.80% $2,565.09 R 101-00000-32240 ANIMAL LICENSE $67.00 $548.35 $350.00 156.67% $323.59 R 101-00000-33900 DIVIDENDS $0.00 $0.00 $500.00 0.00% $0.00 R 101-00000-34102 ZONING & VARIANCE FEES $0.00 $466.00 $350.00 133.14% $206.00 R 101-00000-34107 ASSESSMENT SEARCHES $175.00 $375.00 $500.00 75.00% $389.97 R 101-00000-34109 CHARGES FOR SERVICES $0.00 $3,780.69 $6,000.00 63.01% $87.86 R 101-00000-34409 REIMBURSEMENTS $0.00 $0.00 $0.00 0.00% $1,210.00 R 101-00000-34790 SALE OF EXCESS EQUIPMEN $0.00 $0.00 $0.00 0.00% $539.92 R 101-00000-35300 PAY PAL FEE $0.00 $130.95 $80.00 163.69% $26.32 R 101-00000-36101 SPECIAL ASSESSMENTS $390.91 $390.91 $0.00 0.00% $0.00 R 101-00000-36105 SPECIAL ASSESS. -DEL UTILI $133.24 $133.24 $680.00 19.59% $384.00 R 101-00000-36200 MISCELLANEOUS REVENUE $150.00 $11,094.88 $200.00 5547.44% $1,616.00 R 101-00000-36210 INTEREST EARNINGS $79.51 $11,045.36 $150.00 7363.57% $36,797.68 R 101-00000-36220 RENT - LAND $0.00 $2,415.00 $2,000.00 120.75% $2,147.50 R 101-00000-38050 CABLE TV FRANCHISE FEES $0.00 $3,063.10 $9,600.00 31.91% $3,906.80 R 101-00000-39202 TRANSFER FROM ENTERPRIS $0.00 $0.00 $20,000.00 0.00% $0.00 00000 GENERAL REVENUE $1,417.21 $40,684.40 $48,710.00 83.52% $53,695.73

41000 GENERAL GOVERNMENT R 101-41000-31020 DELINQUENT TAXES $6,687.01 $6,687.01 $15,000.00 44.58% $30,270.16 R 101-41000-31030 MOBILE HOME TAX $711.03 $711.03 $1,000.00 71.10% $2,954.19 R 101-41000-31110 CURRENT AD VALOREM TAX $396,712.54 $396,712.54 $739,725.00 53.63% $343,446.56 R 101-41000-33401 LOCAL GOVERNMENT AID $332,132.50 $332,132.50 $640,500.00 51.86% $297,725.00 41000 GENERAL GOVERNMENT $736,243.08 $736,243.08 $1,396,225.00 52.73% $674,395.91

41100 GENERAL GOVERNMENT R 101-41100-31120 TRANSFER-KMU IN LIEU OF