What happened
- Special session held November 7, 2024 at 5:30 p.m. in City Council chambers; adjourned at 5:48 p.m.
- Resolution 2024-26 approving the City Administrator hiring adopted on roll call vote, 5-0-0
- Scott Lehner named the new City Administrator for Kenyon
- Candidate interviews were conducted October 29, after which an offer was made
- Employment agreement changed to extend relocation time from 1 year and six months to 24 months
- Council Member Molly Ryan participated via Teams from 706 John Nolen Dr., Madison, WI
- Interim City Administrator Frank Boyles outlined the recruitment process to the council
- Boyles informed the council of interest in opening a body art studio in the commercial district; no action taken
- Motion by Bailey, seconded by Helgeson, to adjourn at 5:48 p.m.
What was asked 22 raised · 10 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.
Motion Approving Pay Application #10 to BCM Construction SUPPORTING DOCUMENTS ATTACHED: Resolution Ordinance Contract Minutes OTHER Pay App 22 Contractor's Applica on 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 IMPROVEMENTS Contract: N/A Application No.: 10 Application Date: 11/12/2024 Application Period: From 9/28/2024 to
Pay estimate covering work from 9/28/2024 to 11/1/2024 including a partial retainage release.
Pay request 10 to BCM Construction for 31,726.22 dollars was approved on December 10 2024 on a motion by Bailey seconded by Helgeson. Olinger reported the Pearl Creek and Gates Avenue work substantially complete with a few repairs left, and the payment included part of the withheld retainage. A further pay application 11 was already on the agenda structure for the following month.
12.10.24 Council Packet and Agenda Updated · taken up again 2024-12-10
Other Adult Establishment – Body Art Interim Administrator Boyles informed the council that there was interest in opening a body art studio in the commercial district in Kenyon. For now, he just wanted to make the council aware of the request.
Adult establishment / body art item raised under Other at the special session.
At the meetingNo council action; item presented as information
The city wrote body art into its zoning two months later. Ordinance 110, before the council on January 14 2025, adds tattoo parlors and body art establishments as a permitted use in the downtown commercial district, and city code section 1135.05 requires a body art establishment license issued by the state Commissioner of Health. The informational mention in November became an ordinance without a separate application fight.
1-14-25 council packet · taken up again 2025-01-14
We have started design work for the project and are approximately 10% complete. In the next month we'll be plotting the initial set of preliminary plans, reviewing private utility impacts and reviewing private property impacts. We are currently targeting plan completion in February. SOURCE OF FUNDING: Future Project Financing REQUESTED COUNCIL ACTION: None – Information Only SUPPORTING DOCUMENTS ATTACHED: Resolution Ordinance Contract Minutes OTHER 15 AGENDA ITEM NO. VII.B Agenda Item Summary CITY COUNCIL AGENDA
Status update on the 2025 street and utility project.
The February target slipped. On December 10 2024 Olinger still said design should be completed in February, but on February 11 2025 the design was reported approximately 75 percent complete with bid authorization pushed to the March council meeting. Bidding then produced the April 2 2025 opening whose bids were all rejected in June.
Design was targeted for completion in February 2025 but stood at roughly 75 percent on February 11 2025.
2.11.25 Council Packet Agenda · taken up again 2025-02-11
No CAD drawings will be produced nor provided. Following completion, we'll meet with the City and developer to discuss the results of the study.
Deliverables of the proposed 8th Street development cost study.
The meeting with the developer happened before costs were prepared, not after. On January 14 2025 Olinger reported a potential layout had been drafted showing an ideal buildout of the area and said discussion and input from developers would be helpful prior to preparing costs. The cost half of the deliverable is not recorded as delivered.
1-14-25 council packet · taken up again 2025-01-14
NC = Not Calculated. Lack of calculation and pay adjustment does not represent the city's intention to make future pay adjustments in accordance with the contract. 27 AGENDA ITEM NO. IX.A Agenda Item Summary CITY COUNCIL AGENDA ITEM REPORT DATE: November 12, 2024 SUBMITTED BY: Holli Gudknecht, Administration ITEM TYPE: Financial AGENDA SECTION: FINANCIAL SUBJECT: October Financials SUGGESTED ACTION: See Attached Reports ATTACHMENTS: City of Kenyon Expense Summary.pdf City of Kenyon Revenue Summary.pdf City of
Pay App #10 shows substantial completion contract date 08/02/24 versus actual 10/12/24 at $1,600 per day, not calculated.
The city never assessed substantial completion damages. A change order in August 2025 adjusted the substantial and final completion dates to the dates the contractor actually finished, which the engineer described as effectively removing liquidated damage payments, and stated that assessment would not be appropriate because the project went smoothly and actual damages would be hard to evidence. The contract value was adjusted with no effect on payments already made.
8.12.25 Council Packet Agenda Updated · taken up again 2025-08-12
Final Punch List Complete, Final Documentation Submitted 09/27/24 11/01/24 35 $ (260.00) $ (9,100.00) Totals $ (9,100.00) NC = Not Calculated. Lack of calculation and pay adjustment does not represent the city's intention to make future pay adjustments in accordance with the contract. 27 AGENDA ITEM NO. IX.A Agenda Item Summary CITY COUNCIL AGENDA ITEM REPORT DATE: November 12, 2024 SUBMITTED BY: Holli Gudknecht, Administration ITEM TYPE: Financial AGENDA SECTION: FINANCIAL SUBJECT: October Financials SUGGESTED
Other Payments Summary in BCM Construction Pay Application #10.
The arithmetic holds, 35 days at 260 dollars is exactly 9,100 dollars, but the deduction did not survive. On January 14 2025 the council was told liquidated damages would be suspended over the winter because final restoration on the Barrett property could not be judged until the spring thaw, and a completion date would be set in early spring. The August 2025 change order then moved the completion dates to the actual dates, removing liquidated damages from the contract.
1-14-25 council packet · taken up again 2025-01-14
VI.A Agenda Item Summary CITY COUNCIL AGENDA ITEM REPORT DATE: November 12, 2024 SUBMITTED BY: Holli Gudknecht, Administration ITEM TYPE: Appointments AGENDA SECTION: PRESENTATIONS/PUBLIC HEARINGS RECOGNITIONS/PROCLAMATIONS SUBJECT: Oath of Office for Kenyon Police Officer Josephine Homeier SUGGESTED ACTION: Oath will be given by Police Chief Jeff Sjoblom ATTACHMENTS: 13 AGENDA ITEM NO.
Appointment item scheduled under presentations/recognitions.
Chief Sjoblom administered the oath of office to Officer Josephine Homeier at the December 10 2024 meeting and she introduced herself to the council. The same ceremony recurred for Officer Armani Tucker on July 8 2025.
12.10.24 Council Packet and Agenda Updated · taken up again 2024-12-10
As could be expected in any area, the capital investment needed to purchase the property and build critical infrastructure (streets, sewer, water, etc.) was at the forefront of discussion. In addition, a better understanding of potential site layout and basic costs is still unknown.
Summary of the October 15 meeting with CEDA, city staff and a local developer.
Half the unknown was closed. By January 14 2025 a potential layout for the 8th Street site had been drafted showing an ideal buildout, but Olinger said developer input was needed before costs could be prepared, so basic costs remained unknown. No cost estimate for the site reaches our records.
1-14-25 council packet · taken up again 2025-01-14
General Discussion of City Administrator Employment Agreement Interim Administrator Boyles outlined the process the city when through to find a long-term city administrator. Interviews were conducted on October 29 and an offer was made to one of the candidates.
Boyles outlined the hiring process before the vote on Resolution 2024-26.
The hire was completed at that meeting. Resolution 2024-26 approving the city administrator hiring passed by roll call 5-0-0 with Bailey, Helgeson, Henke, Ryan and Sjolander all voting aye. The search itself had been contracted in July 2024 to South Central Service Cooperative and Mike Humpal for 14,500 dollars, chosen over David Drown Associates. The interim administrator's own contract was then extended to January 31 2025 by Resolution 2024-31.
11.12.24 Council Packet And Agenda / KENYON_BIDS.md · taken up again 2024-11-12
42100 LAW ENFORCEMENT $569,902.38 $508,066.05 112.17% $431,254.30 43100 STREETS E 101-43100-101 SALARIES - REGULAR $95,050.82 $105,495.60 90.10% $80,923.95 E 101-43100-102 SALARIES - OVERTIME $2,126.15 $8,925.00 23.82% $12,402.41 E 101-43100-121 PERA - EMPLOYER SHARE $7,302.06 $7,964.25 91.69% $7,623.16 E 101-43100-122 FICA - EMPLOYER SHARE $8,322.65 $8,785.00 94.74% $7,424.17 E 101-43100-130 INSURANCE - MED/DENT/LIFE/ $29,057.45 $41,082.00 70.73% $33,014.75 E 101-43100-131 EMPLOYER H.S.A.EXPENSE $1,500.01 $0.00
October expense summary presented under Financial.
The overrun widened. Law enforcement finished November 2024 at 602,811.12 dollars, 118.65 percent of the 508,066.05 dollar budget, and the full year 2024 figure carried into the 2025 statements is 671,396.50 dollars, or 132.1 percent of budget. Capital outlay was the largest single driver at 66,376.37 dollars against 48,500 dollars, and the council raised the 2025 police budget to 579,837 dollars.
12.10.24 Council Packet and Agenda Updated / 6-10-25 COUNCIL PACKET Updated · taken up again 2025-06-10
We've discussed and agreed with the contractor that the remaining work can be best accomplished shortly after freeze-up, this year.
Project is substantially complete but close-out work remains.
No completion date from BCM reaches our records, but the size of the remaining work does. By the December 10 2024 pay application the punch list subtotal stood at 4,500 dollars with total retainage of 16,819.06 dollars, held at 1 percent of work completed plus 250 percent of the remaining punch list value. The subcontractor told the council the crew was waiting for frozen ground to avoid further damage.
12.10.24 Council Packet and Agenda Updated
In the next month we'll be plotting the initial set of preliminary plans, reviewing private utility impacts and reviewing private property impacts.
Next steps on 2025 Street & Utility Improvements design.
No preliminary plan set or private utility and property impact review reaches our records. The next documented design milestone is February 11 2025, when the project was approximately 75 percent complete, which implies the intermediate work happened but leaves its findings undocumented here. The preliminary plan sheets and the impact memo would settle it.
2.11.25 Council Packet Agenda
The release is triggered by a statutory requirement. The city is still withholding approximately $40,000 to date for the remaining work.
Explanation of the retainage release included in Pay Application #10.
The pay application's own lines total 38,669.06 dollars, which is 1,330.94 dollars short of the approximately 40,000 dollars the engineer described as withheld. That figure is 29,569.06 dollars of retainage plus 9,100 dollars in liquidated damage deductions. A month later, after the further retainage release in pay application 11, the amount held had fallen to 16,819.06 dollars.
The engineer told the council approximately 40,000 dollars was being withheld, while the attached pay application shows 38,669.06 dollars.
11.12.24 Council Packet And Agenda / 12.10.24 Council Packet and Agenda Updated
The contract was mutually agreed upon with one change being requested. The city would extend the relocation time from 1 year and six months to 24 months.
General discussion of the City Administrator employment agreement before the resolution vote.
At the meetingCouncil adopted Resolution 2024-26 approving the hiring 5-0
The council adopted Resolution 2024-26 approving the hire by roll call 5-0-0 with the relocation term extended to 24 months as the single negotiated change, but the executed employment agreement is not in our holdings. The recruitment that produced the candidate cost 14,500 dollars, awarded to South Central Service Cooperative and Mike Humpal in July 2024 over David Drown Associates. The signed contract would confirm the relocation clause.
11.12.24 Council Packet And Agenda / KENYON_BIDS.md
for the 8th Street Development Cost Study SUPPORTING DOCUMENTS ATTACHED: Resolution Ordinance Contract Minutes OTHER x 17 2900 43rd Street NW Suite 100 Rochester, MN 55901 Phone: (507) 208-4332 Bolton-Menk.com October 21, 2024 Kenyon EDA and City Council RE: 8th Street Development Cost Study Engineering Services: Scope and Fee City of Kenyon, MN Project No.: 0H1.133029 Greetings: This letter contains a scope and fee to complete a planning-level cost analysis for a future residential development in Kenyon. On
RCA lists 'SOURCE OF FUNDING: -' while noting costs will be billed as an extension of general engineering services.
The funding line was never named, but the billing route was: the scope letter says costs will be billed as an extension of Bolton and Menk's general engineering services. The city uses that route elsewhere, including ongoing updates to its ArcGIS Online mapping after the 2024 conversion, which cost 14,500 dollars plus 1,260 dollars a year in ESRI licensing. Which budget line absorbed the 3,000 to 3,500 dollars is not recorded.
11.12.24 Council Packet And Agenda / KENYON_DATA_IN_MEETINGS.md
SOURCE OF FUNDING: Future Project Financing REQUESTED COUNCIL ACTION: None – Information Only SUPPORTING DOCUMENTS ATTACHED: Resolution Ordinance Contract Minutes OTHER 15 AGENDA ITEM NO.
Source of funding line on the 2025 project RCA.
Future project financing turned out to mean bonded debt carried by the levy. The project was awarded to Fitzgerald Excavating at 2,294,629.25 dollars in July 2025, and the pay 2026 tax rate shows the cost: the city's general rate fell 0.38 percent while its bond rate rose 35.91 percent, carrying the total city rate from 79.3028 percent to 84.6822 percent of net tax capacity. The certified 2026 levy is 1,528,541 dollars, up 9.18 percent. We hold no bond schedule tying specific maturities to this project.
taxes/levy.html / taxes/data/kenyon_tax.json
Based on conversations so far, the desired development would consist of traditional, market- rate, single family homes on ~1/4 acre lots (similar to Whitetail Ridge on the north end of town).
Work scope description for the conceptual site layout.
We hold no Whitetail Ridge plat and no lot size data for it. What the market shows is the opposite of quarter acre lots: the only vacant lots listed for sale in Kenyon are three on Engel Drive at 2.27, 2.46 and 3.08 acres, nine to twelve times a quarter acre, priced at 187,778 to 252,230 dollars and sitting 657 days on market. The city also holds 33 vacant residential parcels inside its limits, 18 of them valued at 15,000 dollars or more.
dashboard/data/zillow.json / taxes/data/kenyon_tax.json
This information can be used by any prospective developer for early vetting the property, which would limit their upfront cost and potentially encourage activity. The attached scope and fee was discussed with the EDA on October 22 and was recommended for approval.
Background supporting the council's requested approval of the study.
The December 10 2024 minutes confirm the EDA recommended having the layout and cost projection completed, which corroborates the recommendation, but we hold no EDA minutes of October 22 2024. The scope letter itself states the fee was discussed with the EDA on that date and would be billed as an extension of general engineering services. The EDA minutes would settle the date and the vote.
12.10.24 Council Packet and Agenda Updated
E 101-41610-304 LEGAL $60,676.56 $25,000.00 242.71% $37,803.40 41610 CITY ATTORNEY $60,676.56 $25,000.00 242.71% $37,803.40 41700 CITY ENGINEER E 101-41700-303 ENGINEERING $12,070.00 $10,000.00 120.70% $8,800.00 41700 CITY ENGINEER $12,070.00 $10,000.00 120.70% $8,800.00 41940 GENERAL GOVERNMENT E 101-41940-116 SALARIES -WEBSITE ADMIN $3,346.11 $7,036.05 47.56% $5,967.36 E 101-41940-121 PERA - EMPLOYER SHARE $209.41 $528.00 39.66% $470.11 29 11/08/24 12:23 PM Page 2 2024 %YTD 2023 Account Last Dim Descr YTD Amt
October expense summary presented under Financial.
The percentage checks exactly, 60,676.56 dollars is 242.71 percent of the 25,000 dollar budget, and the same table shows 2023 legal spending at 37,803.40 dollars, so 2024 ran 60.5 percent above the prior year with two months still to go. No explanation of the overrun and no budget amendment appears in our records. The city attorney's billing detail would show what drove it.
11.12.24 Council Packet And Agenda
E 609-49750-501 CAPITAL OUTLAY $92,973.58 $10,000.00 929.74% $0.00 E 609-49750-725 TRANSFER TO GENERAL FUND $0.00 $20,000.00 0.00% $0.00 49750 LIQUOR $822,673.12 $960,308.86 85.67% $758,396.30 900 GASB 34 41000 GENERAL GOVERNMENT E 900-41000-420 DEPRECIATION $22,176.80 $0.00 0.00% $24,394.48 41000 GENERAL GOVERNMENT $22,176.80 $0.00 0.00% $24,394.48 42000 PUBLIC SAFETY E 900-42000-420 DEPRECIATION $113,522.55 $0.00 0.00%
October expense summary for the liquor fund.
The percentage checks, 92,973.58 dollars is 929.74 percent of the 10,000 dollar budget, and the bid record accounts for most of it. Municipal liquor store building work awarded in February and March 2024 totals 66,600.86 dollars: the Chandler Roofing reroof at 40,640 dollars, Hamernick's flooring at 7,480.86 dollars and the Action Plumbing and Luikens heating and mini split work at 18,480 dollars. No authorizing action raising the 10,000 dollar capital line appears in our records.
KENYON_BIDS.md / 11.12.24 Council Packet And Agenda
Furthermore, given the lack of additional planning at this stage in the process, we cannot guarantee the true feasibility and accuracy of any data produced with respect to final development of the property.
Assumptions section of the scope and fee letter, noting surveys, wetland delineation, zoning and geotechnical work are excluded.
This is a professional disclaimer, not a factual question. Whether to buy the excluded work, topographic and boundary surveys, wetland delineation, zoning review, geotechnical borings and other environmental review, is the council's call if the 8th Street project advances. Our records show the study never progressed past a drafted layout, so none of that follow-on work was commissioned.
11.12.24 Council Packet And Agenda
If the city would like to move forward, please indicate so through a formal motion and approval at the next available meeting.
A planning-level layout and cost analysis for a potential low-density housing development south of 8th Street.
No council motion on the Bolton and Menk 8th Street development cost study appears in our record. At $3,000 to $3,500 the fee sits below the $4,999 staff purchasing limit that Administrative Policy No. 34 set two months earlier.
KENYON_BIDS.md · would settle it: A council motion approving the scope and fee letter dated 10/21/2024
Decisions 1 motions
| Motion | Moved / seconded | Vote |
|---|---|---|
| Adopt Resolution 2024-26. Roll Call Vote: Bailey- Aye, Helgeson – Aye, Henke – Aye, Ryan – Aye, Sjolander - Aye | Ryan / Bailey | 5-0-0 |
Who did what
| Person | At this meeting |
|---|---|
| Doug Henke Mayor | Called the special session to order at 5:30 p.m. and voted aye on Resolution 2024-26 |
| Molly Ryan Council Member (via Teams) | Moved adoption of Resolution 2024-26 and voted aye |
| Mary Bailey Council Member | Seconded the motion to adopt Resolution 2024-26, voted aye, and moved to adjourn |
| Kim Helgeson Council Member | Voted aye on Resolution 2024-26 and seconded the motion to adjourn |
| Lee Sjolander Council Member | Voted aye on Resolution 2024-26 |
| Frank Boyles Interim City Administrator | Outlined the administrator search process and contract terms, and reported interest in a body art studio |
| Scott Lehner New City Administrator | Attended the meeting and thanked the council for the opportunity to join the city |
| Holli Gudknecht Administrative Assistant / Deputy City Clerk | Attended and signed the minutes |
| Wayne Ehrich Public Works Superintendent | Attended the special session |
| Jeff Sjoblom Police Chief | Attended the special session |
| Whitney Kyllo Finance Director | Attended the special session |
| Eric Hoversten Attendee | Attended the special session |
Organizations named: City of Kenyon
Figures
| Amount | What |
|---|---|
| $1,256,294.22 | 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 s |
| $1,241,494.22 | te: 11/12/2024 Application Period: From 9/28/2024 to 11/1/2024 1. Original Contract Price $ 1,241,494.22 2. Net change by Change Orders $ 14,800 |
| $1,240,705.52 | d materials stored to date (Sum of Column G Lump Sum Total and Column J Unit Price Total) $ 1,240,705.52 5. Retainage a. See Retainage Summary $ |
| $1,231,905.52 | - $ 14,800.00 100% $ - Original Contract and Change Orders Project Totals $ 1,256,294.22 $ 1,231,905.52 99% $ 1,240,705.52 $ - $ 1,240,705.52 9 |
| $1,225,905.52 | 110% (1,685.60) - - - - - - - Original Contract Totals $ 1,241,494.22 $ 1,217,105.52 99% $ 1,225,905.52 $ - $ 1,225,905.52 99% $ 15,588.70 EJCD |
| $1,217,105.52 | 19,157.60 19,157.60 110% (1,685.60) - - - - - - - Original Contract Totals $ 1,241,494.22 $ 1,217,105.52 99% $ 1,225,905.52 $ - $ 1,225,905.52 9 |
| $1,202,036.46 | - see "Other Payment Summary" $ (9,100.00) 7. Amount eligible to date (Line 4 - Line 5.c) $ 1,202,036.46 8. Less previous payments $ 1,170,310.2 |
| $1,170,310.24 | ) 7. Amount eligible to date (Line 4 - Line 5.c) $ 1,202,036.46 8. Less previous payments $ 1,170,310.24 9. Amount due this application $ 31,726 |
| $960,308.86 | -49750-725 TRANSFER TO GENERAL FUND $0.00 $20,000.00 0.00% $0.00 49750 LIQUOR $822,673.12 $960,308.86 85.67% $758,396.30 900 GASB 34 41000 GE |
| $822,673.12 | $0.00 E 609-49750-725 TRANSFER TO GENERAL FUND $0.00 $20,000.00 0.00% $0.00 49750 LIQUOR $822,673.12 $960,308.86 85.67% $758,396.30 900 GASB |
| $783,759.08 | D ISSUANCE COSTS $0.00 $0.00 0.00% $30,172.07 43256 SEWER $622,881.95 $621,471.56 100.23% $783,759.08 47300 2023 Pearl Creek/Street Improv E |
| $758,396.30 | TO GENERAL FUND $0.00 $20,000.00 0.00% $0.00 49750 LIQUOR $822,673.12 $960,308.86 85.67% $758,396.30 900 GASB 34 41000 GENERAL GOVERNMENT E |
| $622,881.95 | .00% $963.54 E 602-43256-622 BOND ISSUANCE COSTS $0.00 $0.00 0.00% $30,172.07 43256 SEWER $622,881.95 $621,471.56 100.23% $783,759.08 47300 2 |
| $621,471.56 | E 602-43256-622 BOND ISSUANCE COSTS $0.00 $0.00 0.00% $30,172.07 43256 SEWER $622,881.95 $621,471.56 100.23% $783,759.08 47300 2023 Pearl Cr |
Said at the meeting
The contract was mutually agreed upon with one change being requested.
Minutes record (re: Interim City Administrator Frank Boyles) · minutes, verbatim
The city would extend the relocation time from 1 year and six months to 24 months.
Minutes record (re: Interim City Administrator Frank Boyles) · minutes, verbatim
The new city administrator, Scott Lehner, thanked the council for the opportunity to join the city and expressed his enthusiasm to work in Kenyon.
Minutes record (re: Scott Lehner) · minutes, verbatim
For now, he just wanted to make the council aware of the request.
Minutes record (re: Interim City Administrator Frank Boyles) · minutes, verbatim
Resolutions and ordinances
- Approve City Administrator Hiring for the City of Kenyon, MN Motion by Ryan seconded by Bailey to adopt Resolution 2024-26Res. 2024-26
Agenda
Each item links to where it appears in the packet.
Full packet text (1k characters)
The minutes
Official minutes as adopted, from 11.12.24 Council Packet And Agenda; text extracted from the PDF.
Council Special Session was duly held in the City Council chambers at 5:30 p.m. on the 7th day of November 2024.
- Present
- Mayor Doug Henke, Council Members: Kim Helgeson, Mary Bailey, and Lee Sjolander Via Teams: Molly Ryan
- Also present
- Interim City Administrator Frank Boyles, Administrative Assistant Holli Gudknecht, Public Works Superintendent Wayne Ehrich, Police Chief Jeff Sjoblom, Finance Director Whitney Kyllo, Scott Lehner, and Eric Hoversten
Mayor Henke called the special session to order at 5:30 pm.
General Discussion of City Administrator Employment Agreement
Interim Administrator Boyles outlined the process the city when through to find a long-term city administrator. Interviews were conducted on October 29 and an offer was made to one of the candidates. The contract was mutually agreed upon with one change being requested. The city would extend the relocation time from 1 year and six months to 24 months.
Approval of City Administrator Employment Agreement
Resolution 2024-26: Approve City Administrator Hiring for the City of Kenyon, MN
Motion by Ryan seconded by Bailey to adopt Resolution 2024-26.
Roll Call Vote: Bailey- Aye, Helgeson – Aye, Henke – Aye, Ryan – Aye, Sjolander - Aye
Motion carried 5-0-0The new city administrator, Scott Lehner, thanked the council for the opportunity to join the city and expressed his enthusiasm to work in Kenyon.
Other Adult Establishment – Body Art Interim Administrator Boyles informed the council that there was interest in opening a body art studio in the commercial district in Kenyon. For now, he just wanted to make the council aware of the request.
Motion by Bailey seconded by Helgeson to adjourn the meeting at 5:48 p.m.
Holli Gudknecht, Deputy City Clerk Douglas Henke, Mayor
AGENDA ITEM NO. VI.A
Agenda Item Summary
CITY COUNCIL AGENDA ITEM REPORT
DATE: November 12, 2024
SUBMITTED BY: Holli Gudknecht, Administration
ITEM TYPE: Appointments
Agenda Section: Presentations / Public Hearings
RECOGNITIONS/PROCLAMATIONS
SUBJECT: Oath of Office for Kenyon Police Officer Josephine Homeier
SUGGESTED ACTION: Oath will be given by Police Chief Jeff Sjoblom
Attachments:
AGENDA ITEM NO. VII.A
Agenda Item Summary
CITY COUNCIL AGENDA ITEM REPORT
DATE: November 12, 2024
SUBMITTED BY: Holli Gudknecht, Engineering
ITEM TYPE: Engineering
Agenda Section: Engineering
SUBJECT: 2025 Street and Utility Improvements
SUGGESTED ACTION: See Attached
Information Only - No Action
Attachments:
01.1_RCA_2025 Street & Utility Improvements2.pdf
REQUEST FOR COUNCIL ACTION
Agenda Item: Department: Requested Council Meeting Date: Submitted By: Engineering 11/12/2024 Derek Olinger
TITLE OF ISSUE: 2025 Street & Utility Improvements
BACKGROUND AND SUPPLEMENTAL INFORMATION: We have started design work for the project and are approximately 10% complete.
In the next month we'll be plotting the initial set of preliminary plans, reviewing private utility impacts and reviewing private property impacts.
We are currently targeting plan completion in February.
SOURCE OF FUNDING: Future Project Financing
REQUESTED COUNCIL ACTION: None – Information Only
Supporting Documents Attached:
Resolution Ordinance Contract Minutes OTHER
AGENDA ITEM NO. VII.B
Agenda Item Summary
CITY COUNCIL AGENDA ITEM REPORT
DATE: November 12, 2024
SUBMITTED BY: Holli Gudknecht, Engineering
ITEM TYPE: Engineering
Agenda Section: Engineering
SUBJECT: 8th Street Development
SUGGESTED ACTION: See attachments
Attachments:
02.1_RCA_8th Street Development.pdf 02.2_8th St Analysis Scope and Fee.pdf 02.3_8th St Devel-Prelim Layout.pdf
REQUEST FOR COUNCIL ACTION
Agenda Item: Department: Requested Council Meeting Date: Submitted By: Engineering 11/12/2024 Derek Olinger
TITLE OF ISSUE: 8th Street Development
BACKGROUND AND SUPPLEMENTAL INFORMATION: On October 15th, we attended a meeting with CEDA, City Staff/Representatives and a local developer to discuss a potential low density housing development for a parcel of land south of 8 th Street. The subject area is shown in the attachments.
To summarize, the purpose of the discussion was to identify issues which may impede development of this lot. As could be expected in any area, the capital investment needed to purchase the property and build critical infrastructure (streets, sewer, water, etc.) was at the forefront of discussion. In addition, a better understanding of potential site layout and basic costs is still unknown.
With any development, expending public funds on a private effort can be problematic. At the same time, the city as a whole can benefit and grow from this development. Following cost discussions, we offered to prepare a high-level layout and cost projection for the site. This information can be used by any prospective developer for early vetting the property, which would limit their upfront cost and potentially encourage activity.
The attached scope and fee was discussed with the EDA on October 22 and was recommended for approval. Costs will be billed as an extension of our general engineering services.
At the request of the EDA we have included a preliminary layout with the attachments.
Source Of Funding: -
REQUESTED COUNCIL ACTION: Approval of Engineering Proposal for the 8th Street Development Cost Study
Supporting Documents Attached:
Resolution Ordinance Contract Minutes OTHER
x
17 2900 43rd Street NW Suite 100 Rochester, MN 55901
Phone: (507) 208-4332 Bolton-Menk.com
October 21, 2024
Kenyon EDA and City Council
RE: 8th Street Development Cost Study
Engineering Services: Scope and Fee City of Kenyon, MN Project No.: 0H1.133029
Greetings:
This letter contains a scope and fee to complete a planning-level cost analysis for a future residential development in Kenyon. On 10/15/2024, we were asked to attend a meeting with a prospective developer regarding a residential development at the Kenyon property depicted below.
Given the concern and need for additional housing development in Kenyon, it may be appropriate for the city to assist future developers with some planning effort. Information revealed as part of this study
H:\KENYON_CI_MN\_Proposals\2024 8th St Development\2024-10-21_8th St Analysis Scope and Fee.docx
Name: 8th Street Development Cost Study Date: 10/21/2024 Page: 2
Work Scope: Our work would consist of preparing a simple conceptual site layout for future development of the property. Based on conversations so far, the desired development would consist of traditional, market- rate, single family homes on ~1/4 acre lots (similar to Whitetail Ridge on the north end of town). During the layout process, we may indicate areas for different forms of housing or subdivision.
Following production of a layout, we will prepare a planning level cost estimate for construction and extension of basic city infrastructure including streets, sanitary sewer, water and storm sewer/drainage. Cost estimates will be based on typical overall cost per lineal foot of infrastructure and will not included detailed pricing on individual work items.
If requested, we can produce one additional or revised layout as additional services. Continued planning or revisions of layouts beyond this will require a separate scope and fee.
Deliverables will include PDF layouts and cost estimates. No CAD drawings will be produced nor provided. Following completion, we'll meet with the City and developer to discuss the results of the study.
Fee: Bolton & Menk will complete the work scope for and estimated fee of $3,000-$3,500. Fees will be billed as an extension of our normal general engineering services, on an hourly basis. The terms of the work performed under this agreement would be in accordance with the existing Agreement for Professional Services between the City of Kenyon and Bolton & Menk. Any work described as additional services is not included in the fee estimate noted above
Assumptions: This analysis includes only a high-level layout and analysis for the subject property for the overall purpose of basic cost estimating. Other preliminary analysis and planning including, but not limited to topographic and boundary surveys, wetland delineations, zoning reviews, geotechnical borings and reviews, other environmental reviews, etc. are not included as part of this analysis.
Furthermore, given the lack of additional planning at this stage in the process, we cannot guarantee the true feasibility and accuracy of any data produced with respect to final development of the property.
If the city would like to move forward, please indicate so through a formal motion and approval at the next available meeting. We appreciate the opportunity to assist the City of Kenyon with this project. Please reach out to me with any questions.
Sincerely, Bolton & Menk, Inc.
Derek Olinger, P.E. City Engineer
H:\KENYON_CI_MN\_Proposals\2024 8th St Development\2024-10-21_8th St Analysis Scope and Fee.docx
19 8th Street Development 714 714 719 717 608 612 616 622 626 720 721 626 711 714 404 714 514 724 725 8th St 8th St
601 605 611 615 627 804
Fo re st St
School Property
602 602 616 618 820
Red Wing Ave
9th St 9th St
Centenn i al Dr
603 627 902 901
Bullis St Spring St
Forest St
930
10th St Future 10th St
11/3/2024, 9:21:46 PM 1:2,500 0 112.5 225 450 ft City Limits 0 30 60 120 m Parcels - Goodhue Co. Maxar, Microsoft, Esri Community Maps Contributors, © OpenStreetMap, Microsoft, Esri, TomTom, Garmin, SafeGraph, GeoTechnologies, Inc, METI/NASA, USGS, EPA, NPS, US Census Bureau, USDA, USFWS
Earthstar Geographics | Esri, TomTom, Garmin, FAO, NOAA, USGS, EPA, USFWS | 20
AGENDA ITEM NO. VII.C
Agenda Item Summary
CITY COUNCIL AGENDA ITEM REPORT
DATE: November 12, 2024
SUBMITTED BY: Holli Gudknecht, Engineering
ITEM TYPE: Engineering
Agenda Section: Engineering
SUBJECT: Pearl Creek & Gates Ave Utility Improvements
SUGGESTED ACTION: See Attachments
Motion Needed
Attachments:
03.1_RCA_Pearl Creek & Gates Ave Utility Improvements.pdf 03.2_Pearl Creek Pay App 10.pdf
REQUEST FOR COUNCIL ACTION
Agenda Item: Department: Requested Council Meeting Date: Submitted By: Engineering 11/12/2024 Derek Olinger
TITLE OF ISSUE: Pearl Creek & Gates Ave Utility Improvements
BACKGROUND AND SUPPLEMENTAL INFORMATION: Work has been limited over this past month, but contractor has now submitted final testing for the major infrastructure components associated with the project. In addition, yard spaces have around the lift station site have been watered and are looking much better.
Additional turf restoration and other punch list repairs are still required to close out the contract; however, the work is now substantially complete. We've discussed and agreed with the contractor that the remaining work can be best accomplished shortly after freeze-up, this year.
The attached pay estimate includes a release of a portion of the 5% retainage withheld from all previous work. The release is triggered by a statutory requirement. The city is still withholding approximately $40,000 to date for the remaining work.
The attached pay estimate is recommended for payment.
SOURCE OF FUNDING: Project Financing
REQUESTED COUNCIL ACTION: Motion Approving Pay Application #10 to BCM Construction
Supporting Documents Attached:
Resolution Ordinance Contract Minutes OTHER
Pay App
Contractor's Applica on 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 IMPROVEMENTS Contract: N/A Application No.: 10 Application Date: 11/12/2024 Application Period: From 9/28/2024 to 11/1/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,240,705.52 5. Retainage a. See Retainage Summary $ 29,569.06 b. 5% X $ - Stored Materials $ - c. Total Retainage (Line 5.a + Line 5.b) $ 29,569.06 6. Amount other payments (or deductions) - see "Other Payment Summary" $ (9,100.00) 7. Amount eligible to date (Line 4 - Line 5.c) $ 1,202,036.46 8. Less previous payments $ 1,170,310.24 9. Amount due this application $ 31,726.22 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. 23 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 IMPROVEMENTS Contract: N/A
Application No.: 10 Application Period: From 09/28/24 to 11/01/24 Application Date: 11/12/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 Value of Difference fron Bid Value of Bid Item Quantity Completed to Date Materials Currently Stored 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 1.00 55,000.00 1.00 55,000.00 55,000.00 100% - 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 1.00 30,000.00 1.00 30,000.00 30,000.00 100% - 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 1.00 26,500.00 1.00 26,500.00 26,500.00 100% - 8 6" CONCRETE DRIVEWAY (REINFORCED) 160.00 SY 114.00 18,240.00 160.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 1.00 4,500.00 1.00 4,500.00 4,500.00 100% - 11 EROSION & SEDIMENTATION CONTROL 1.00 LS 12,000.00 12,000.00 0.85 10,200.00 1.00 12,000.00 12,000.00 100% - 12 STABILIZE & REESTABLISH TURF 1.00 LS 15,000.00 15,000.00 0.90 13,500.00 1.00 15,000.00 15,000.00 100% - 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 28,799.20 28,799.20 28,799.20 28,799.20 28,799.20 82% 6,200.80 15 HWY 60 MH & PIPE DISCONNECTIONS 1.00 LS 8,000.00 8,000.00 1.00 8,000.00 1.00 8,000.00 8,000.00 100% - 16 REMOVE MANHOLE (SANITARY) 3.00 EACH 1,500.00 4,500.00 3.00 4,500.00 3.00 4,500.00 4,500.00 100% - 17 EXCAVATION - ROCK 180.00 CY 84.00 15,120.00 103.00 8,652.00 103.00 8,652.00 8,652.00 57% 6,468.00 18 DEWATERING 1.00 LS 20,000.00 20,000.00 1.00 20,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 3.00 2,625.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 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 157.00 219,800.00 219,800.00 100% - 23 8" PVC PIPE SEWER 280.00 LF 90.00 25,200.00 283.00 25,470.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 299.00 30,498.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 1.00 7,000.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 1.00 5,500.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 1.00 8,200.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 1.00 8,000.00 8,000.00 100% - 31 REPLACE & ADJUST CASTING 1.00 EACH 1,350.00 1,350.00 1.00 1,350.00 1.00 1,350.00 1,350.00 100% - 32 CONSTRUCT 8" INSIDE DROP (MH C) 1.00 EACH 4,500.00 4,500.00 1.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 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 1.00 3,000.00 3,000.00 100% - 35 LIFT STATION & VALVE VAULT 1.00 LS 235,090.22 235,090.22 1.00 235,090.22 1.00 235,090.22 235,090.22 100% - 36 ELECTRICAL (POWER EXTEN, BACKUP GEN, CONTROL, LIGHT, CONCRETE PADS) 1.00 LS 200,000.00 200,000.00 0.98 196,000.00 1.00 200,000.00 200,000.00 100% - 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% - 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.00 1,800.00 1.00 1,800.00 1,800.00 100% - 1.02 TYPE SP 12.5 WEARING COURSE MIXTURE (2,B) (SINGLE 3" LIFT) 156.00 TON 112.00 17,472.00 171.05 19,157.60 171.05 19,157.60 19,157.60 110% (1,685.60) - - - - - - - Original Contract Totals $ 1,241,494.22 $ 1,217,105.52 99% $ 1,225,905.52 $ - $ 1,225,905.52 99% $ 15,588.70
EJCDC C-620 Contractor's Application for Payment
Unit Price 1 of 2 (c) 2018 National Society of Professional Engineers for EJCDC. All rights reserved. 24 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 IMPROVEMENTS Contract: N/A
Application No.: 10 Application Period: From 09/28/24 to 11/01/24 Application Date: 11/12/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 Value of Difference fron Bid Value of Bid Item Quantity Completed to Date Materials Currently Stored 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 ($) ($) ($) (%) ($) 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 $ 1,231,905.52 99% $ 1,240,705.52 $ - $ 1,240,705.52 99% $ 15,588.70
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 25 Retainage Summary 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 IMPROVEMENTS Contract: N/A
Application No.: 10 Application Period: From 09/28/24 to 11/01/24 Application Date: 11/12/24
A B C D Summary of Retainage: Estimated Cost Calculation Factor Amount Retained
Percent Retainage (1% of work substantially completed) 1% 1,231,905.52 $ 12,319.06
Item No. Punch List Description
Sanitary Add Wiring & Control for Power Loss Notification & Alarm 1% of Electrical $ 2,000.00 250% $ 5,000.00 Sanitary/Water Finish setting tracer Pedestals/Test Stations (wtr and san) (3) @ 100 Each $ 300.00 250% $ 750.00 Turf/Erosion Add topsoil & reestablish turf around MH B (10 CY @ $30/CY) + 2hr x $200/hr $ 700.00 250% $ 1,750.00 Turf/Erosion Replant & Seed Bare spots in Barrett Yard (South of Creek) 10% of item 12 $ 1,500.00 250% $ 3,750.00 Turf/Erosion Remove Sand in Barrett yard, Reestablish Turf 1 hr @ $100 $ 100.00 250% $ 250.00 Remove Erosion/Sediment Control BMPs & Final cleanup of dirt clumps, branches, tire Turf/Erosion 15% of item 11 ruts, etc. in these areas $ 1,800.00 250% $ 4,500.00 Site Modify Grading to allow water to enter inlet of culvert below LS driveway 10% of culvert cost ($5361) $ 500.00 250% $ 1,250.00 250% $ - 250% $ - 250% $ -
PUNCH LIST SUBTOTAL: $ 17,250.00
RETAINAGE TOTAL: $ 29,569.06 Total Amount Retained includes 1% of work completed and 250% of value of remaining punch list items. See most recent punch list for additional detail. List above may not include all repairs on the current punch list.
Other Payments Summary 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 IMPROVEMENTS Contract: N/A
Application No.: 10 Application Period: From 09/28/24 to 11/01/24 Application Date: 11/12/24
A B C D
Actual Completion Liquidated
Milestone/ Contract or Cutoff Date Number of Damages Per Day Totals Completion Completion Description Completion Date (Whichever is earlier) Days Over ($) ($)
Substantial Completed in accordance with Agreement Section 4.02 08/02/24 10/12/24 NC $ (1,600.00) NC
Final Punch List Complete, Final Documentation Submitted 09/27/24 11/01/24 35 $ (260.00) $ (9,100.00)
Totals $ (9,100.00) NC = Not Calculated. Lack of calculation and pay adjustment does not represent the city's intention to make future pay adjustments in accordance with the contract.
AGENDA ITEM NO. IX.A
Agenda Item Summary
CITY COUNCIL AGENDA ITEM REPORT
DATE: November 12, 2024
SUBMITTED BY: Holli Gudknecht, Administration
ITEM TYPE: Financial
Agenda Section: Financial
SUBJECT: October Financials
SUGGESTED ACTION: See Attached Reports
Attachments:
City of Kenyon Expense Summary.pdf City of Kenyon Revenue Summary.pdf City of Kenyon_Profit Loss Summary By Fund YTD©.pdf
28 11/08/24 12:23 PM CITY OF KENYON Page 1 Expense Summary
2024 %YTD 2023 Account Last Dim Descr YTD Amt 2024 Budget Budget YTD Amt
101 GENERAL FUND
41000 GENERAL GOVERNMENT E 101-41000-609 LOAN PRINCIPAL-INTERFUND K $0.00 $0.00 0.00% $14.87 41000 GENERAL GOVERNMENT $0.00 $0.00 0.00% $14.87
41110 CITY COUNCIL E 101-41110-101 SALARIES - REGULAR $9,527.16 $11,660.00 81.71% $6,117.50 E 101-41110-122 FICA - EMPLOYER SHARE $537.95 $920.00 58.47% $398.09 E 101-41110-142 UNEMPLOYMENT COMPENSATI $29.70 $0.00 0.00% $0.00 E 101-41110-150 INSURANCE - WORKERS COMP $42.05 $50.00 84.10% $78.56 E 101-41110-311 CONFERENCE & TRAINING $0.00 $350.00 0.00% $134.30 E 101-41110-331 TRAVEL EXPENSE $0.00 $200.00 0.00% $0.00 E 101-41110-430 MISCELLANEOUS $78.42 $0.00 0.00% $10.00 E 101-41110-433 DUES AND SUBSCRIPTIONS $4,215.38 $100.00 4215.38% $7,650.74 41110 CITY COUNCIL $14,430.66 $13,280.00 108.66% $14,389.19
41310 CITY ADMINISTRATION E 101-41310-100 SALARIES - PART TIME $6,162.56 $17,214.75 35.80% $15,148.06 E 101-41310-101 SALARIES - REGULAR $121,668.73 $177,702.00 68.47% $154,955.01 E 101-41310-102 SALARIES - OVERTIME $14,236.64 $0.00 0.00% $8,057.79 E 101-41310-121 PERA - EMPLOYER SHARE $12,661.75 $14,621.00 86.60% $13,951.94 E 101-41310-122 FICA - EMPLOYER SHARE $12,585.07 $14,910.00 84.41% $14,039.91 E 101-41310-130 INSURANCE - MED/DENT/LIFE/ $42,402.52 $89,645.00 47.30% $81,885.09 E 101-41310-131 EMPLOYER H.S.A.EXPENSE $1,237.50 $0.00 0.00% $0.00 E 101-41310-142 UNEMPLOYMENT COMPENSATI $63.55 $0.00 0.00% -$7.01 E 101-41310-150 INSURANCE - WORKERS COMP $724.05 $870.00 83.22% $1,398.76 E 101-41310-311 CONFERENCE & TRAINING $0.00 $1,500.00 0.00% $676.29 E 101-41310-324 OUTSIDE SERVICES $34,335.71 $0.00 0.00% $18,803.74 E 101-41310-331 TRAVEL EXPENSE $281.40 $1,500.00 18.76% $500.83 E 101-41310-342 TRAINING FEES -$100.00 $0.00 0.00% $0.00 E 101-41310-360 INSURANCE - PROPERTY/LIABIL $944.93 $960.00 98.43% $911.20 E 101-41310-430 MISCELLANEOUS $33.75 $0.00 0.00% $40.52 E 101-41310-433 DUES AND SUBSCRIPTIONS $563.00 $1,100.00 51.18% $2,421.18 41310 CITY ADMINISTRATION $247,801.16 $320,022.75 77.43% $312,783.31
41410 ELECTIONS E 101-41410-103 ELECTION JUDGE PAY $0.00 $2,500.00 0.00% $0.00 E 101-41410-331 TRAVEL EXPENSE $85.76 $0.00 0.00% $705.45 E 101-41410-430 MISCELLANEOUS $191.57 $0.00 0.00% $480.00 41410 ELECTIONS $277.33 $2,500.00 11.09% $1,185.45
41530 AUDITING E 101-41530-301 AUDITING $14,757.50 $15,000.00 98.38% $43,557.17 41530 AUDITING $14,757.50 $15,000.00 98.38% $43,557.17
41610 CITY ATTORNEY E 101-41610-304 LEGAL $60,676.56 $25,000.00 242.71% $37,803.40 41610 CITY ATTORNEY $60,676.56 $25,000.00 242.71% $37,803.40
41700 CITY ENGINEER E 101-41700-303 ENGINEERING $12,070.00 $10,000.00 120.70% $8,800.00 41700 CITY ENGINEER $12,070.00 $10,000.00 120.70% $8,800.00
41940 GENERAL GOVERNMENT E 101-41940-116 SALARIES -WEBSITE ADMIN $3,346.11 $7,036.05 47.56% $5,967.36 E 101-41940-121 PERA - EMPLOYER SHARE $209.41 $528.00 39.66% $470.11
29 11/08/24 12:23 PM Page 2 2024 %YTD 2023 Account Last Dim Descr YTD Amt 2024 Budget Budget YTD Amt E 101-41940-122 FICA - EMPLOYER SHARE $241.25 $537.00 44.93% $449.88 E 101-41940-130 INSURANCE - MED/DENT/LIFE/ $3,258.13 $3,783.00 86.13% $3,393.31 E 101-41940-131 EMPLOYER H.S.A.EXPENSE $8,100.06 $0.00 0.00% $0.00 E 101-41940-150 INSURANCE - WORKERS COMP $26.97 $40.00 67.43% $51.72 E 101-41940-200 OFFICE SUPPLIES $1,861.76 $2,800.00 66.49% $1,328.68 E 101-41940-210 OPERATING SUPPLIES & EXPEN $6,380.40 $10,000.00 63.80% $4,734.02 E 101-41940-302 SAFETY CLASS/DRUG & ALCOH $4,693.44 $4,700.00 99.86% $6,350.63 E 101-41940-308 OUTSIDE JANITORIAL SERVICE $14,418.30 $15,690.00 91.89% $14,775.90 E 101-41940-309 COMPUTER SUPPORT $10,147.48 $2,500.00 405.90% $4,706.40 E 101-41940-321 UTILITIES-PHONE/INTERNET/C $8,748.68 $9,700.00 90.19% $9,552.49 E 101-41940-324 OUTSIDE SERVICES $16,552.25 $0.00 0.00% $0.00 E 101-41940-335 MISC BANK CHARGES $45.00 $200.00 22.50% $95.00 E 101-41940-339 PAY PAL FEES $172.10 $50.00 344.20% $111.57 E 101-41940-340 ADVERTISING $2,433.37 $3,500.00 69.52% $1,533.29 E 101-41940-360 INSURANCE - PROPERTY/LIABIL $8,864.82 $7,000.00 126.64% $7,592.05 E 101-41940-381 UTILITIES-ELECTRIC & WATER $2,724.47 $3,665.00 74.34% $3,135.32 E 101-41940-383 UTILITIES-NATURAL GAS $1,088.28 $1,580.00 68.88% $2,855.03 E 101-41940-384 UTILITIES-REFUSE/RECYCLING $425.56 $455.00 93.53% $517.02 E 101-41940-385 UTILITIES-SEWER CHARGES $1,558.13 $1,120.00 139.12% $1,041.68 E 101-41940-400 REPAIRS AND MAINT $7,144.23 $3,500.00 204.12% $2,790.84 E 101-41940-430 MISCELLANEOUS $2,754.96 $7,000.00 39.36% $2,670.63 E 101-41940-433 DUES AND SUBSCRIPTIONS $5,855.37 $7,000.00 83.65% $11,034.26 E 101-41940-490 DONATIONS $2,000.00 $2,000.00 100.00% $2,000.00 E 101-41940-501 CAPITAL OUTLAY $2,007.39 $8,500.00 23.62% $8,953.00 E 101-41940-609 LOAN PRINCIPAL-INTERFUND K $53,000.00 $8,000.00 662.50% $0.00 E 101-41940-610 LOAN INTEREST - INTERFUND $1,478.00 $4,000.00 36.95% $0.00 E 101-41940-725 TRANSFER TO GENERAL FUND -$300,000.00 $0.00 0.00% $0.00 41940 GENERAL GOVERNMENT -$130,464.08 $114,884.05 -113.56% $96,110.19
42100 LAW ENFORCEMENT E 101-42100-100 SALARIES - PART TIME $21,064.25 $19,000.00 110.86% $10,464.29 E 101-42100-101 SALARIES - REGULAR $226,870.46 $239,294.05 94.81% $198,874.98 E 101-42100-102 SALARIES - OVERTIME $39,386.63 $31,000.00 127.05% $21,425.67 E 101-42100-106 SALARIES - TRAINING $0.00 $0.00 0.00% $997.86 E 101-42100-112 SALARIES - ADMIN $0.00 $0.00 0.00% $18,130.44 E 101-42100-117 LAWENF.SAL./SP PROG/GRANT $1,119.80 $0.00 0.00% $0.00 E 101-42100-121 PERA - EMPLOYER SHARE $48,940.82 $49,195.00 99.48% $44,612.64 E 101-42100-122 FICA - EMPLOYER SHARE $13,903.19 $5,754.00 241.63% $5,101.17 E 101-42100-130 INSURANCE - MED/DENT/LIFE/ $19,635.76 $24,323.00 80.73% $25,541.74 E 101-42100-131 EMPLOYER H.S.A.EXPENSE $5,100.02 $0.00 0.00% $0.00 E 101-42100-142 UNEMPLOYMENT COMPENSATI $144.29 $0.00 0.00% $16.19 E 101-42100-150 INSURANCE - WORKERS COMP $13,724.65 $10,060.00 136.43% $11,315.44 E 101-42100-210 OPERATING SUPPLIES & EXPEN $26,393.72 $7,500.00 351.92% $8,351.82 E 101-42100-211 CLEANING SUPPLIES $316.98 $0.00 0.00% $0.00 E 101-42100-212 MOTOR FUELS, LUBES, ADDITIV $10,017.05 $6,500.00 154.11% $10,670.28 E 101-42100-213 FIREARM AND AMMO PURCHAS $749.30 $780.00 96.06% $1,612.89 E 101-42100-222 TIRES $716.00 $720.00 99.44% $266.78 E 101-42100-304 LEGAL $15,905.00 $13,800.00 115.25% $11,805.94 E 101-42100-307 CONTRACT SERVICES $5,792.48 $3,600.00 160.90% $6,814.32 E 101-42100-311 CONFERENCE & TRAINING $4,682.15 $3,000.00 156.07% $2,747.72 E 101-42100-321 UTILITIES-PHONE/INTERNET/C $6,177.00 $4,220.00 146.37% $5,970.34 E 101-42100-331 TRAVEL EXPENSE $51.52 $500.00 10.30% $0.00 E 101-42100-339 PAY PAL FEES $18.60 $0.00 0.00% $15.54 E 101-42100-340 ADVERTISING $545.87 $750.00 72.78% $2,098.46 E 101-42100-360 INSURANCE - PROPERTY/LIABIL $17,929.73 $15,470.00 115.90% $16,601.83 E 101-42100-381 UTILITIES-ELECTRIC & WATER $2,080.83 $1,000.00 208.08% $2,038.31 E 101-42100-383 UTILITIES-NATURAL GAS $2,982.81 $1,500.00 198.85% $1,221.44 E 101-42100-384 UTILITIES-REFUSE/RECYCLING $331.90 $400.00 82.98% $398.88
30 11/08/24 12:23 PM Page 3 2024 %YTD 2023 Account Last Dim Descr YTD Amt 2024 Budget Budget YTD Amt E 101-42100-385 UTILITIES-SEWER CHARGES $0.00 $300.00 0.00% $189.69 E 101-42100-400 REPAIRS AND MAINT $5,567.20 $4,000.00 139.18% $5,740.04 E 101-42100-418 UNIFORMS $3,062.25 $2,400.00 127.59% $6,275.90 E 101-42100-429 PERMITS AND LICENSES $91.94 $1,200.00 7.66% $0.00 E 101-42100-430 MISCELLANEOUS $1,791.66 $1,000.00 179.17% $2,230.19 E 101-42100-433 DUES AND SUBSCRIPTIONS $3,599.75 $3,300.00 109.08% $2,926.57 E 101-42100-501 CAPITAL OUTLAY $66,376.37 $48,500.00 136.86% $6,796.94 E 101-42100-740 TRANSFER TO CAPITAL FUND $4,832.40 $9,000.00 53.69% $0.00 42100 LAW ENFORCEMENT $569,902.38 $508,066.05 112.17% $431,254.30
43100 STREETS E 101-43100-101 SALARIES - REGULAR $95,050.82 $105,495.60 90.10% $80,923.95 E 101-43100-102 SALARIES - OVERTIME $2,126.15 $8,925.00 23.82% $12,402.41 E 101-43100-121 PERA - EMPLOYER SHARE $7,302.06 $7,964.25 91.69% $7,623.16 E 101-43100-122 FICA - EMPLOYER SHARE $8,322.65 $8,785.00 94.74% $7,424.17 E 101-43100-130 INSURANCE - MED/DENT/LIFE/ $29,057.45 $41,082.00 70.73% $33,014.75 E 101-43100-131 EMPLOYER H.S.A.EXPENSE $1,500.01 $0.00 0.00% $0.00 E 101-43100-142 UNEMPLOYMENT COMPENSATI $41.90 $0.00 0.00% $6.13 E 101-43100-150 INSURANCE - WORKERS COMP $5,194.53 $6,825.00 76.11% $10,157.59 E 101-43100-151 INSURANCE - WORK COMP DED $0.00 $0.00 0.00% $1,000.00 E 101-43100-210 OPERATING SUPPLIES & EXPEN $4,554.02 $10,000.00 45.54% $8,387.97 E 101-43100-212 MOTOR FUELS, LUBES, ADDITIV $4,949.65 $12,000.00 41.25% $11,646.72 E 101-43100-224 STREET MAINTENANCE $28,208.41 $80,000.00 35.26% $78,284.08 E 101-43100-225 BOULEVARD of ROSES $430.61 $2,000.00 21.53% $1,521.76 E 101-43100-311 CONFERENCE & TRAINING $0.00 $500.00 0.00% $0.00 E 101-43100-321 UTILITIES-PHONE/INTERNET/C $1,162.00 $1,255.00 92.59% $1,286.59 E 101-43100-360 INSURANCE - PROPERTY/LIABIL $6,286.96 $7,526.00 83.54% $5,052.67 E 101-43100-381 UTILITIES-ELECTRIC & WATER $1,566.55 $1,625.00 96.40% $1,954.55 E 101-43100-383 UTILITIES-NATURAL GAS $2,101.77 $4,500.00 46.71% $3,717.10 E 101-43100-384 UTILITIES-REFUSE/RECYCLING $454.79 $555.00 81.94% $511.42 E 101-43100-385 UTILITIES-SEWER CHARGES $1,301.98 $1,600.00 81.37% $1,427.91 E 101-43100-400 REPAIRS AND MAINT $13,057.75 $14,000.00 93.27% $20,113.72 E 101-43100-414 OSHA/SAFETY CLOTH. & EQUIP $200.26 $700.00 28.61% $509.78 E 101-43100-418 UNIFORMS $339.38 $500.00 67.88% $313.04 E 101-43100-430 MISCELLANEOUS $0.00 $450.00 0.00% $52.50 E 101-43100-501 CAPITAL OUTLAY $0.00 $0.00 0.00% $8,650.00 E 101-43100-505 GIS Operation and Maintenance $2,239.25 $0.00 0.00% $0.00 E 101-43100-606 CAPITAL LEASE PRINCIPAL $0.00 $13,652.00 0.00% $23,518.76 E 101-43100-619 CAPITAL LEASE INTEREST $0.00 $1,385.00 0.00% $2,385.19 E 101-43100-740 TRANSFER TO CAPITAL FUND $0.00 $45,000.00 0.00% $0.00 43100 STREETS $215,448.95 $376,324.85 57.25% $321,885.92
43160 STREET LIGHTING E 101-43160-387 UTILITIES-STR. LIGHTS - ALLEY $21,084.76 $23,420.00 90.03% $23,613.67 E 101-43160-388 UTILITIES-STR. LIGHTS-MAIN/G $2,736.76 $3,790.00 72.21% $3,302.49 43160 STREET LIGHTING $23,821.52 $27,210.00 87.55% $26,916.16
43250 RECYCLING E 101-43250-386 RECYCLING $38,630.00 $0.00 0.00% $42,495.00 43250 RECYCLING $38,630.00 $0.00 0.00% $42,495.00
45124 SWIMMING POOL E 101-45124-100 SALARIES - PART TIME $51,075.78 $38,818.50 131.58% $44,766.95 E 101-45124-101 SALARIES - REGULAR $2,536.12 $1,606.50 157.87% $3,608.04 E 101-45124-102 SALARIES - OVERTIME $0.00 $1,606.50 0.00% $1,525.04 E 101-45124-121 PERA - EMPLOYER SHARE $825.84 $270.00 305.87% $377.11 E 101-45124-122 FICA - EMPLOYER SHARE $4,076.25 $3,133.00 130.11% $3,815.07 E 101-45124-130 INSURANCE - MED/DENT/LIFE/ $1,380.78 $645.00 214.07% $1,610.75
31 11/08/24 12:23 PM Page 4 2024 %YTD 2023 Account Last Dim Descr YTD Amt 2024 Budget Budget YTD Amt E 101-45124-150 INSURANCE - WORKERS COMP $1,572.69 $1,780.00 88.35% $2,892.39 E 101-45124-210 OPERATING SUPPLIES & EXPEN $2,780.18 $2,500.00 111.21% $2,829.18 E 101-45124-216 CHEMICALS $6,660.29 $5,000.00 133.21% $4,490.01 E 101-45124-250 MERCHANDISE FOR RESALE $2,614.51 $2,500.00 104.58% $3,516.28 E 101-45124-311 CONFERENCE & TRAINING $720.00 $1,200.00 60.00% $1,536.06 E 101-45124-321 UTILITIES-PHONE/INTERNET/C $1,156.95 $755.00 153.24% $1,028.38 E 101-45124-331 TRAVEL EXPENSE $0.00 $0.00 0.00% $122.20 E 101-45124-339 PAY PAL FEES $178.19 $0.00 0.00% $3.87 E 101-45124-340 ADVERTISING $0.00 $180.00 0.00% $73.50 E 101-45124-360 INSURANCE - PROPERTY/LIABIL $2,277.32 $3,450.00 66.01% $2,094.19 E 101-45124-381 UTILITIES-ELECTRIC & WATER $6,609.35 $5,480.00 120.61% $5,101.88 E 101-45124-383 UTILITIES-NATURAL GAS $5,250.24 $5,500.00 95.46% $4,860.26 E 101-45124-384 UTILITIES-REFUSE/RECYCLING $80.00 $100.00 80.00% $0.00 E 101-45124-385 UTILITIES-SEWER CHARGES $5,731.65 $3,910.00 146.59% $4,181.69 E 101-45124-400 REPAIRS AND MAINT $13,584.28 $5,000.00 271.69% $1,024.82 E 101-45124-418 UNIFORMS $935.00 $850.00 110.00% $815.27 E 101-45124-429 PERMITS AND LICENSES $0.00 $900.00 0.00% $1,740.00 E 101-45124-430 MISCELLANEOUS $0.00 $300.00 0.00% $169.13 E 101-45124-501 CAPITAL OUTLAY $0.00 $0.00 0.00% $6,361.50 E 101-45124-740 TRANSFER TO CAPITAL FUND $0.00 $35,000.00 0.00% $0.00 45124 SWIMMING POOL $110,045.42 $120,484.50 91.34% $98,543.57
45200 PARKS E 101-45200-101 SALARIES - REGULAR $25,791.79 $26,225.25 98.35% $23,727.85 E 101-45200-102 SALARIES - OVERTIME $436.96 $1,606.50 27.20% $1,200.79 E 101-45200-121 PERA - EMPLOYER SHARE $2,075.92 $1,885.00 110.13% $1,974.37 E 101-45200-122 FICA - EMPLOYER SHARE $2,134.88 $2,030.00 105.17% $1,962.23 E 101-45200-130 INSURANCE - MED/DENT/LIFE/ $8,792.25 $10,332.00 85.10% $9,728.71 E 101-45200-142 UNEMPLOYMENT COMPENSATI $22.56 $0.00 0.00% $2.44 E 101-45200-150 INSURANCE - WORKERS COMP $756.01 $760.00 99.48% $1,301.21 E 101-45200-210 OPERATING SUPPLIES & EXPEN $2,660.34 $2,000.00 133.02% $2,178.93 E 101-45200-212 MOTOR FUELS, LUBES, ADDITIV $1,675.58 $1,200.00 139.63% $759.15 E 101-45200-360 INSURANCE - PROPERTY/LIABIL $7,326.94 $4,738.00 154.64% $3,945.29 E 101-45200-381 UTILITIES-ELECTRIC & WATER $271.33 $1,260.00 21.53% $1,238.53 E 101-45200-383 UTILITIES-NATURAL GAS $390.60 $1,050.00 37.20% $657.84 E 101-45200-385 UTILITIES-SEWER CHARGES $179.73 $160.00 112.33% $260.11 E 101-45200-400 REPAIRS AND MAINT $2,173.57 $3,000.00 72.45% $1,063.48 E 101-45200-606 CAPITAL LEASE PRINCIPAL $0.00 $3,823.00 0.00% $930.12 E 101-45200-619 CAPITAL LEASE INTEREST $0.00 $388.00 0.00% $94.33 E 101-45200-740 TRANSFER TO CAPITAL FUND $0.00 $15,000.00 0.00% $0.00 45200 PARKS $54,688.46 $75,457.75 72.48% $51,025.38
45300 GUNDERSON HOUSE E 101-45300-314 MANAGEMENT FEES $5,000.00 $2,500.00 200.00% $0.00 E 101-45300-360 INSURANCE - PROPERTY/LIABIL $4,081.28 $3,500.00 116.61% $4,243.86 E 101-45300-400 REPAIRS AND MAINT $149.03 $500.00 29.81% $118.88 E 101-45300-740 TRANSFER TO CAPITAL FUND $0.00 $8,000.00 0.00% $0.00 45300 GUNDERSON HOUSE $9,230.31 $14,500.00 63.66% $4,362.74
45400 COMMUNITY GARDEN E 101-45400-210 OPERATING SUPPLIES & EXPEN $41.17 $0.00 0.00% $19.99 45400 COMMUNITY GARDEN $41.17 $0.00 0.00% $19.99
202 CAPITAL OUTLAY
48100 GEN GOVMNT CAPITAL OUTLAY E 202-48100-501 CAPITAL OUTLAY $5,583.54 $0.00 0.00% $53,200.00 48100 GEN GOVMNT CAPITAL OUTLAY $5,583.54 $0.00 0.00% $53,200.00
32 11/08/24 12:23 PM Page 5 2024 %YTD 2023 Account Last Dim Descr YTD Amt 2024 Budget Budget YTD Amt
48200 PUBLIC SAFETY CAPITAL OUTLAY E 202-48200-501 CAPITAL OUTLAY $3,232.40 $0.00 0.00% $0.00 48200 PUBLIC SAFETY CAPITAL OUTLAY $3,232.40 $0.00 0.00% $0.00
48300 STREETS & HWY CAPITAL OUTLAY E 202-48300-501 CAPITAL OUTLAY $194,479.06 $0.00 0.00% $0.00 E 202-48300-719 TRANSFER-INTERFUND $36,522.78 $0.00 0.00% $8,145.36 48300 STREETS & HWY CAPITAL OUTLAY $231,001.84 $0.00 0.00% $8,145.36
48500 CULTURE & REC CAPITAL OUTLAY E 202-48500-501 CAPITAL OUTLAY $1,164.16 $0.00 0.00% $12,225.68 48500 CULTURE & REC CAPITAL OUTLAY $1,164.16 $0.00 0.00% $12,225.68
203 FIRE
42200 FIRE E 203-42200-119 ADMIN FEE- FIRE & RESCUE $0.00 $250.00 0.00% $0.00 E 203-42200-150 INSURANCE - WORKERS COMP $4,444.32 $5,500.00 80.81% $5,572.86 E 203-42200-200 OFFICE SUPPLIES $32.29 $0.00 0.00% $0.00 E 203-42200-210 OPERATING SUPPLIES & EXPEN $4,465.99 $3,500.00 127.60% $2,667.88 E 203-42200-212 MOTOR FUELS, LUBES, ADDITIV $2,876.76 $2,500.00 115.07% $1,769.48 E 203-42200-301 AUDITING $3,000.00 $3,000.00 100.00% $0.00 E 203-42200-305 MEDICAL $0.00 $2,600.00 0.00% $5,285.00 E 203-42200-321 UTILITIES-PHONE/INTERNET/C $1,845.15 $2,755.00 66.97% $2,945.38 E 203-42200-323 PAGERS/MAINTENANCE $1,568.75 $2,000.00 78.44% $1,568.75 E 203-42200-331 TRAVEL EXPENSE $0.00 $350.00 0.00% $453.26 E 203-42200-341 FIRE DEPT PRACTICE MEALS $1,302.15 $2,500.00 52.09% $2,134.99 E 203-42200-342 TRAINING FEES -$1,065.27 $13,000.00 -8.19% $8,810.00 E 203-42200-344 BANQUETS/SPECIAL EVENTS $2,642.20 $2,500.00 105.69% $1,275.00 E 203-42200-360 INSURANCE - PROPERTY/LIABIL $2,516.94 $6,250.00 40.27% $5,660.88 E 203-42200-381 UTILITIES-ELECTRIC & WATER $3,851.83 $5,375.00 71.66% $4,394.09 E 203-42200-383 UTILITIES-NATURAL GAS $2,145.59 $6,000.00 35.76% $4,307.34 E 203-42200-384 UTILITIES-REFUSE/RECYCLING $274.90 $585.00 46.99% $430.88 E 203-42200-385 UTILITIES-SEWER CHARGES $1,305.14 $850.00 153.55% $949.39 E 203-42200-400 REPAIRS AND MAINT $12,139.20 $12,000.00 101.16% $2,797.13 E 203-42200-414 OSHA/SAFETY CLOTH. & EQUIP $39,657.32 $0.00 0.00% $0.00 E 203-42200-418 UNIFORMS $23,487.72 $56,000.00 41.94% $20,372.29 E 203-42200-419 STATE AID FORWARD TO FIRE $0.00 $26,000.00 0.00% $30,252.29 E 203-42200-430 MISCELLANEOUS $1,140.06 $1,000.00 114.01% $0.00 E 203-42200-433 DUES AND SUBSCRIPTIONS $2,765.75 $1,200.00 230.48% $1,535.00 E 203-42200-491 K. FIRE RELIEF ASSOC. DONATI $10,000.00 $10,000.00 100.00% $0.00 E 203-42200-520 REPAIRS - BLDG & STRUCTURE $1,236.68 $1,500.00 82.45% $0.00 E 203-42200-606 CAPITAL LEASE PRINCIPAL $99,684.56 $18,407.56 541.54% $17,824.78 E 203-42200-619 CAPITAL LEASE INTEREST $3,673.16 $3,212.44 114.34% $3,795.22 E 203-42200-740 TRANSFER TO CAPITAL FUND $0.00 $64,500.00 0.00% $0.00 42200 FIRE $224,991.19 $253,335.00 88.81% $124,801.89
42270 FIRST RESPONDERS E 203-42270-210 OPERATING SUPPLIES & EXPEN $1,062.16 $1,000.00 106.22% $351.47 E 203-42270-212 MOTOR FUELS, LUBES, ADDITIV $241.52 $1,000.00 24.15% $476.82 E 203-42270-311 CONFERENCE & TRAINING $2,400.00 $2,000.00 120.00% $2,000.00 E 203-42270-360 INSURANCE - PROPERTY/LIABIL $339.77 $246.00 138.12% $421.97 E 203-42270-400 REPAIRS AND MAINT $0.00 $1,200.00 0.00% $0.00 E 203-42270-433 DUES AND SUBSCRIPTIONS $0.00 $400.00 0.00% $0.00 E 203-42270-740 TRANSFER TO CAPITAL FUND $0.00 $5,000.00 0.00% $0.00 42270 FIRST RESPONDERS $4,043.45 $10,846.00 37.28% $3,250.26
204 LIBRARY
33 11/08/24 12:23 PM Page 6 2024 %YTD 2023 Account Last Dim Descr YTD Amt 2024 Budget Budget YTD Amt
45500 LIBRARY E 204-45500-100 SALARIES - PART TIME $30,963.46 $37,900.00 81.70% $30,868.70 E 204-45500-101 SALARIES - REGULAR $49,015.75 $57,215.00 85.67% $50,580.24 E 204-45500-102 SALARIES - OVERTIME $615.33 $0.00 0.00% $0.00 E 204-45500-121 PERA - EMPLOYER SHARE $5,937.77 $6,930.00 85.68% $6,147.30 E 204-45500-122 FICA - EMPLOYER SHARE $5,032.64 $7,253.00 69.39% $6,095.28 E 204-45500-130 INSURANCE - MED/DENT/LIFE/ $20,856.88 $29,510.00 70.68% $26,489.26 E 204-45500-131 EMPLOYER H.S.A.EXPENSE $5,100.04 $0.00 0.00% $0.00 E 204-45500-142 UNEMPLOYMENT COMPENSATI $82.76 $0.00 0.00% -$31.01 E 204-45500-150 INSURANCE - WORKERS COMP $365.19 $600.00 60.87% $450.64 E 204-45500-210 OPERATING SUPPLIES & EXPEN $1,206.76 $2,000.00 60.34% $1,574.95 E 204-45500-300 AUTOMATION $4,242.14 $5,600.00 75.75% $6,299.07 E 204-45500-311 CONFERENCE & TRAINING $0.00 $150.00 0.00% $0.00 E 204-45500-321 UTILITIES-PHONE/INTERNET/C $0.00 $1,065.00 0.00% $693.61 E 204-45500-331 TRAVEL EXPENSE $103.18 $300.00 34.39% $27.51 E 204-45500-340 ADVERTISING $50.00 $50.00 100.00% $50.00 E 204-45500-360 INSURANCE - PROPERTY/LIABIL $3,456.55 $3,000.00 115.22% $3,182.86 E 204-45500-381 UTILITIES-ELECTRIC & WATER $2,724.45 $3,800.00 71.70% $3,133.28 E 204-45500-383 UTILITIES-NATURAL GAS $657.23 $1,090.00 60.30% $831.93 E 204-45500-385 UTILITIES-SEWER CHARGES $751.29 $750.00 100.17% $685.39 E 204-45500-400 REPAIRS AND MAINT $100.00 $250.00 40.00% $0.00 E 204-45500-410 LEASE $629.59 $800.00 78.70% $692.84 E 204-45500-430 MISCELLANEOUS $45.67 $50.00 91.34% $521.30 E 204-45500-432 BAD DEBT EXPENSE $268.40 $0.00 0.00% $0.00 E 204-45500-433 DUES AND SUBSCRIPTIONS $285.90 $400.00 71.48% $504.20 E 204-45500-490 DONATIONS $3,205.03 $0.00 0.00% $0.00 E 204-45500-501 CAPITAL OUTLAY $800.00 $0.00 0.00% $0.00 E 204-45500-570 OFFICE EQUIPMENT PURCHASE $1,023.34 $1,200.00 85.28% $1,249.82 E 204-45500-590 BOOKS $20,277.93 $22,500.00 90.12% $20,994.29 45500 LIBRARY $157,797.28 $182,413.00 86.51% $161,041.46
205 ECONOMIC DEVELOPMENT AUTHORITY
46200 SEMMCHRA DEED GRANT E 205-46200-444 DEED GRANT FORWARD TO SE $0.00 $1,000.00 0.00% $0.00 46200 SEMMCHRA DEED GRANT $0.00 $1,000.00 0.00% $0.00
46500 ECONOMIC DEVELOPMENT AUTHORITY E 205-46500-107 EDA BOARD MEMBER PAY $1,190.00 $650.00 183.08% $0.00 E 205-46500-265 PROPERTY TAX $1,422.00 $1,465.00 97.06% $1,406.00 E 205-46500-303 ENGINEERING $0.00 $5,000.00 0.00% $0.00 E 205-46500-304 LEGAL $2,347.50 $3,000.00 78.25% $1,034.00 E 205-46500-307 CONTRACT SERVICES $28,292.81 $1,000.00 2829.28% $29,158.00 E 205-46500-331 TRAVEL EXPENSE $0.00 $1,000.00 0.00% $344.50 E 205-46500-340 ADVERTISING $1,223.13 $2,500.00 48.93% $1,178.00 E 205-46500-344 BANQUETS/SPECIAL EVENTS $300.00 $0.00 0.00% $0.00 E 205-46500-360 INSURANCE - PROPERTY/LIABIL $142.48 $2,090.00 6.82% $418.60 E 205-46500-385 UTILITIES-SEWER CHARGES $85.03 $50.00 170.06% $44.33 E 205-46500-400 REPAIRS AND MAINT $4.00 $250.00 1.60% $462.95 E 205-46500-430 MISCELLANEOUS $0.00 $50.00 0.00% $0.00 E 205-46500-433 DUES AND SUBSCRIPTIONS $0.00 $300.00 0.00% $0.00 E 205-46500-480 FAÇADE IMPROVEMENTS $12,550.00 $0.00 0.00% $3,186.00 E 205-46500-609 LOAN PRINCIPAL-INTERFUND K $10,610.00 $10,352.00 102.49% $10,351.00 E 205-46500-610 LOAN INTEREST - INTERFUND $816.00 $1,074.00 75.98% $1,074.00 46500 ECONOMIC DEVELOPMENT AUTHORIT $58,982.95 $28,781.00 204.94% $48,657.38
230 SPECIAL PURPOSE DONATIONS
42000 PUBLIC SAFETY
34 11/08/24 12:23 PM Page 7 2024 %YTD 2023 Account Last Dim Descr YTD Amt 2024 Budget Budget YTD Amt E 230-42000-430 MISCELLANEOUS $99.53 $0.00 0.00% $0.00 42000 PUBLIC SAFETY $99.53 $0.00 0.00% $0.00
45000 CULTURE & RECREATION E 230-45000-346 ROSE FEST $10,646.45 $0.00 0.00% $15,370.04 E 230-45000-430 MISCELLANEOUS $33,705.54 $0.00 0.00% $3,492.10 45000 CULTURE & RECREATION $44,351.99 $0.00 0.00% $18,862.14
45500 LIBRARY E 230-45500-430 MISCELLANEOUS $725.90 $0.00 0.00% $0.00 45500 LIBRARY $725.90 $0.00 0.00% $0.00
301 2012 G.O. IMP. BONDS-STREETS
47000 DEBT SERVICE E 301-47000-601 BOND PRINCIPAL $0.00 $0.00 0.00% $8,905.00 E 301-47000-611 BOND INTEREST $0.00 $0.00 0.00% $122.45 47000 DEBT SERVICE $0.00 $0.00 0.00% $9,027.45
303 2016 FIRST STREET IMPROVEMENTS
47000 DEBT SERVICE E 303-47000-608 BOND PRINCIPAL - 2016 FIRST $30,000.00 $19,350.00 155.04% $19,350.00 E 303-47000-614 BOND INTEREST 2016 FIRST ST $9,546.46 $7,449.75 128.14% $7,788.37 E 303-47000-620 FISCAL AGENT FEES $1,045.00 $990.00 105.56% $990.00 47000 DEBT SERVICE $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 $91,040.51 $91,040.51 100.00% $88,820.01 E 310-47000-615 BOND INTEREST - 2020A BOND $47,218.94 $47,218.94 100.00% $49,916.84 E 310-47000-620 FISCAL AGENT FEES $495.00 $0.00 0.00% $0.00 47000 DEBT SERVICE $138,754.45 $138,259.45 100.36% $138,736.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 $34,762.22 $34,762.22 100.00% $33,781.73 E 320-47100-625 BOND INT-2016B CIP FIRE HAL $56,353.20 $56,362.78 99.98% $57,334.26 47100 2016 FIRE HALL BOND CIP NOTES $91,115.42 $91,125.00 99.99% $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 $7,378.48 $7,378.48 100.00% $7,172.27 E 321-47200-627 BOND INT-2016B USDA FIRE H $11,962.52 $11,962.52 100.00% $12,168.73 47200 2016 FIRE HALL BOND USDA NOTES $19,341.00 $19,341.00 100.00% $19,341.00
323 2023A G.O. Bond
47300 2023 Pearl Creek/Street Improv E 323-47300-611 BOND INTEREST $24,752.88 $0.00 0.00% $0.00 E 323-47300-620 FISCAL AGENT FEES $0.00 $0.00 0.00% $495.00 E 323-47300-622 BOND ISSUANCE COSTS $0.00 $0.00 0.00% $1,003.53 47300 2023 Pearl Creek/Street Improv $24,752.88 $0.00 0.00% $1,498.53
325 2025 Street Projects
47000 DEBT SERVICE E 325-47000-501 CAPITAL OUTLAY $21,750.00 $0.00 0.00% $0.00 47000 DEBT SERVICE $21,750.00 $0.00 0.00% $0.00
35 11/08/24 12:23 PM Page 8 2024 %YTD 2023 Account Last Dim Descr YTD Amt 2024 Budget Budget YTD Amt
331 2020 FREIGHTLINER 114SD
47000 DEBT SERVICE E 331-47000-606 CAPITAL LEASE PRINCIPAL $33,425.29 $33,425.29 100.00% $32,364.90 E 331-47000-619 CAPITAL LEASE INTEREST $3,097.49 $3,097.49 100.00% $4,157.88 47000 DEBT SERVICE $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% $7,825.06 E 336-47000-619 CAPITAL LEASE INTEREST $0.00 $0.00 0.00% $320.30 47000 DEBT SERVICE $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% $14,000.00 47000 DEBT SERVICE $0.00 $0.00 0.00% $14,000.00
402 2004 SUNSET HOME TAX INCREMENT
48116 TIF #4-4 SUN HOME/ASSIS. LIV. E 402-48116-800 REIMBURSEMENTS $17,611.98 $0.00 0.00% $0.00 48116 TIF #4-4 SUN HOME/ASSIS. LIV. $17,611.98 $0.00 0.00% $0.00
405 2023 Street Overlay Proj
43100 STREETS E 405-43100-501 CAPITAL OUTLAY $26,923.75 $0.00 0.00% $347,656.36 43100 STREETS $26,923.75 $0.00 0.00% $347,656.36
602 SANITARY SEWER
43256 SEWER E 602-43256-101 SALARIES - REGULAR $51,407.86 $51,180.15 100.44% $43,240.55 E 602-43256-102 SALARIES - OVERTIME $13,027.14 $11,476.50 113.51% $10,148.67 E 602-43256-121 PERA - EMPLOYER SHARE $4,380.19 $4,796.23 91.33% $4,194.40 E 602-43256-122 FICA - EMPLOYER SHARE $5,176.83 $4,699.25 110.16% $3,996.63 E 602-43256-130 INSURANCE - MED/DENT/LIFE/ $15,227.30 $18,340.00 83.03% $17,582.58 E 602-43256-131 EMPLOYER H.S.A.EXPENSE $1,950.00 $0.00 0.00% $0.00 E 602-43256-142 UNEMPLOYMENT COMPENSATI $19.91 $0.00 0.00% $1.84 E 602-43256-150 INSURANCE - WORKERS COMP $1,654.51 $2,020.00 81.91% $1,662.70 E 602-43256-210 OPERATING SUPPLIES & EXPEN $11,273.88 $15,000.00 75.16% $19,170.85 E 602-43256-212 MOTOR FUELS, LUBES, ADDITIV $1,211.12 $3,000.00 40.37% $2,581.47 E 602-43256-216 CHEMICALS $10,809.54 $8,000.00 135.12% $7,638.51 E 602-43256-265 PROPERTY TAX $956.00 $860.00 111.16% $788.00 E 602-43256-303 ENGINEERING $0.00 $5,000.00 0.00% $237.00 E 602-43256-304 LEGAL $0.00 $500.00 0.00% $0.00 E 602-43256-307 CONTRACT SERVICES $0.00 $3,100.00 0.00% $3,256.89 E 602-43256-311 CONFERENCE & TRAINING $1,043.58 $500.00 208.72% $587.37 E 602-43256-321 UTILITIES-PHONE/INTERNET/C $1,054.44 $1,380.00 76.41% $816.61 E 602-43256-331 TRAVEL EXPENSE $381.99 $700.00 54.57% $262.00 E 602-43256-360 INSURANCE - PROPERTY/LIABIL $9,284.05 $11,000.00 84.40% $10,915.04 E 602-43256-381 UTILITIES-ELECTRIC & WATER $45,802.50 $38,630.00 118.57% $43,006.65 E 602-43256-383 UTILITIES-NATURAL GAS $3,558.83 $4,500.00 79.09% $7,455.30 E 602-43256-384 UTILITIES-REFUSE/RECYCLING $629.70 $680.00 92.60% $756.77 E 602-43256-385 UTILITIES-SEWER CHARGES $19,504.07 $18,590.00 104.92% $23,361.55 E 602-43256-400 REPAIRS AND MAINT $42,840.12 $25,000.00 171.36% $30,672.92 E 602-43256-414 OSHA/SAFETY CLOTH. & EQUIP $0.00 $1,000.00 0.00% $0.00 E 602-43256-418 UNIFORMS $195.33 $400.00 48.83% $163.94
36 11/08/24 12:23 PM Page 9 2024 %YTD 2023 Account Last Dim Descr YTD Amt 2024 Budget Budget YTD Amt E 602-43256-420 DEPRECIATION $134,555.85 $167,000.00 80.57% $207,929.95 E 602-43256-429 PERMITS AND LICENSES $1,473.00 $1,600.00 92.06% $1,642.15 E 602-43256-430 MISCELLANEOUS $0.00 $500.00 0.00% $0.00 E 602-43256-501 CAPITAL OUTLAY $13,602.40 $20,000.00 68.01% $95,361.97 E 602-43256-505 GIS Operation and Maintenance $3,399.98 $0.00 0.00% $0.00 E 602-43256-603 BOND PRINCIPAL - 2012 HWY 5 $0.00 $0.00 0.00% $12,675.00 E 602-43256-604 BOND PRINCIPAL - 2020A BON $39,749.11 $39,749.11 100.00% $38,779.62 E 602-43256-605 LOAN PRINCIPAL - PFA (RATES) $93,000.00 $93,000.00 100.00% $93,000.00 E 602-43256-606 CAPITAL LEASE PRINCIPAL $0.00 $26,223.00 0.00% $26,222.96 E 602-43256-608 BOND PRINCIPAL - 2016 FIRST $0.00 $8,460.00 0.00% $8,460.00 E 602-43256-611 BOND INTEREST $0.00 $0.00 0.00% $174.28 E 602-43256-612 LOAN INTEREST - PFA $9,750.00 $9,750.00 100.00% $10,680.00 E 602-43256-614 BOND INTEREST 2016 FIRST ST $1,591.54 $3,257.10 48.86% $3,405.15 E 602-43256-615 BOND INTEREST - 2020A BOND $20,616.22 $20,616.22 100.00% $21,794.15 E 602-43256-616 BOND INTEREST - 2023A BOND $63,754.96 $0.00 0.00% $0.00 E 602-43256-619 CAPITAL LEASE INTEREST $0.00 $964.00 0.00% $963.54 E 602-43256-622 BOND ISSUANCE COSTS $0.00 $0.00 0.00% $30,172.07 43256 SEWER $622,881.95 $621,471.56 100.23% $783,759.08
47300 2023 Pearl Creek/Street Improv E 602-47300-611 BOND INTEREST $0.00 $63,448.00 0.00% $0.00 47300 2023 Pearl Creek/Street Improv $0.00 $63,448.00 0.00% $0.00
605 STORM SEWER
43251 STORM SEWER UTIL & MAINT E 605-43251-101 SALARIES - REGULAR $14,194.22 $12,822.60 110.70% $11,059.88 E 605-43251-102 SALARIES - OVERTIME $342.20 $0.00 0.00% $16.16 E 605-43251-121 PERA - EMPLOYER SHARE $1,031.16 $915.00 112.70% $878.22 E 605-43251-122 FICA - EMPLOYER SHARE $1,111.85 $935.00 118.91% $852.82 E 605-43251-130 INSURANCE - MED/DENT/LIFE/ $4,473.33 $5,445.00 82.15% $4,983.43 E 605-43251-131 EMPLOYER H.S.A.EXPENSE $750.01 $0.00 0.00% $0.00 E 605-43251-142 UNEMPLOYMENT COMPENSATI $6.24 $0.00 0.00% $0.76 E 605-43251-150 INSURANCE - WORKERS COMP $272.26 $291.00 93.56% $237.23 E 605-43251-212 MOTOR FUELS, LUBES, ADDITIV $483.66 $1,500.00 32.24% $1,297.06 E 605-43251-360 INSURANCE - PROPERTY/LIABIL $260.66 $300.00 86.89% $319.85 E 605-43251-400 REPAIRS AND MAINT $14,757.23 $9,000.00 163.97% $5,996.30 E 605-43251-420 DEPRECIATION $86,307.10 $51,827.80 166.53% $96,248.43 E 605-43251-501 CAPITAL OUTLAY $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% $13,195.00 E 605-43251-604 BOND PRINCIPAL - 2020A BON $26,159.69 $26,159.69 100.00% $25,521.65 E 605-43251-606 CAPITAL LEASE PRINCIPAL $0.00 $18,940.00 0.00% $18,939.83 E 605-43251-608 BOND PRINCIPAL - 2016 FIRST $0.00 $1,260.00 0.00% $1,260.00 E 605-43251-611 BOND INTEREST $0.00 $0.00 0.00% $181.43 E 605-43251-614 BOND INTEREST 2016 FIRST ST $237.04 $485.10 48.86% $507.15 E 605-43251-615 BOND INTEREST - 2020A BOND $13,567.95 $13,567.95 100.00% $14,343.18 E 605-43251-619 CAPITAL LEASE INTEREST $0.00 $3,021.00 0.00% $3,020.58 43251 STORM SEWER UTIL & MAINT $222,446.77 $161,470.14 137.76% $198,858.96
609 LIQUOR
49750 LIQUOR E 609-49750-100 SALARIES - PART TIME $24,369.34 $0.00 0.00% $100.61 E 609-49750-101 SALARIES - REGULAR $20,904.62 $0.00 0.00% $0.00 E 609-49750-102 SALARIES - OVERTIME $0.00 $0.00 0.00% $150.98 E 609-49750-108 SALARIES - FULL-TIME ON-SAL $6,335.06 $15,910.11 39.82% $13,368.00 E 609-49750-109 SALARIES - FULL-TIME OFF-SA $6,351.06 $15,899.61 39.94% $13,252.00 E 609-49750-110 SALARIES - PART-TIME ON-SA $20,577.94 $45,015.25 45.71% $30,012.15 E 609-49750-111 SALARIES - PART-TIME OFF-SA $5,050.94 $23,292.85 21.68% $11,886.18
37 11/08/24 12:23 PM Page 10 2024 %YTD 2023 Account Last Dim Descr YTD Amt 2024 Budget Budget YTD Amt E 609-49750-112 SALARIES - ADMIN $17,902.37 $34,400.08 52.04% $27,922.67 E 609-49750-121 PERA - EMPLOYER SHARE $7,157.03 $9,038.84 79.18% $7,484.99 E 609-49750-122 FICA - EMPLOYER SHARE $6,763.16 $9,219.62 73.36% $7,633.15 E 609-49750-130 INSURANCE - MED/DENT/LIFE/ $32,461.47 $52,552.50 61.77% $39,708.92 E 609-49750-131 EMPLOYER H.S.A.EXPENSE $5,100.04 $0.00 0.00% $0.00 E 609-49750-142 UNEMPLOYMENT COMPENSATI $151.28 $0.00 0.00% $13.61 E 609-49750-150 INSURANCE - WORKERS COMP $2,608.82 $3,000.00 86.96% $3,171.56 E 609-49750-208 SERVING SUPPLY-FOOD & ALCO $2,591.67 $2,700.00 95.99% $3,474.93 E 609-49750-210 OPERATING SUPPLIES & EXPEN $8,453.43 $7,500.00 112.71% $6,445.73 E 609-49750-251 LIQUOR $156,041.15 $178,500.00 87.42% $162,464.48 E 609-49750-252 BEER $245,115.12 $335,000.00 73.17% $275,900.20 E 609-49750-253 WINE $18,745.46 $27,000.00 69.43% $19,406.91 E 609-49750-254 SODA, MIX, JUICE $12,985.59 $16,000.00 81.16% $15,229.43 E 609-49750-256 TOBACCO $10,562.07 $15,000.00 70.41% $10,267.60 E 609-49750-257 FOOD/CONDIMENTS-COMPLIME $2,440.26 $4,000.00 61.01% $1,903.32 E 609-49750-258 FOOD/MERCHANDISE FOR RESA $18,470.13 $35,000.00 52.77% $22,981.13 E 609-49750-308 OUTSIDE JANITORIAL SERVICE $10,783.10 $14,000.00 77.02% $11,861.41 E 609-49750-309 COMPUTER SUPPORT $2,000.00 $5,000.00 40.00% $2,000.00 E 609-49750-311 CONFERENCE & TRAINING $0.00 $600.00 0.00% $0.00 E 609-49750-321 UTILITIES-PHONE/INTERNET/C $3,724.96 $2,600.00 143.27% $2,411.86 E 609-49750-325 SECURITY SYSTEM $436.70 $1,000.00 43.67% $477.73 E 609-49750-327 PEST CONTROL $756.00 $1,000.00 75.60% $880.00 E 609-49750-331 TRAVEL EXPENSE $0.00 $1,100.00 0.00% $0.00 E 609-49750-333 FREIGHT or SHIPPING CHARGE $498.20 $500.00 99.64% $801.45 E 609-49750-334 CREDIT CARD EXPENSES $15,150.85 $15,000.00 101.01% $16,383.07 E 609-49750-340 ADVERTISING $417.00 $1,000.00 41.70% $817.24 E 609-49750-345 SPECIAL EVENTS/ENTERTAINM $2,446.49 $4,500.00 54.37% $2,391.69 E 609-49750-346 ROSE FEST $18,691.49 $10,000.00 186.91% $11,473.71 E 609-49750-360 INSURANCE - PROPERTY/LIABIL $7,639.91 $6,000.00 127.33% $3,673.56 E 609-49750-364 INSURANCE - DRAM LIQUOR LI $5,863.29 $4,820.00 121.65% $402.00 E 609-49750-381 UTILITIES-ELECTRIC & WATER $8,834.35 $11,430.00 77.29% $9,941.30 E 609-49750-383 UTILITIES-NATURAL GAS $546.01 $1,120.00 48.75% $1,289.60 E 609-49750-384 UTILITIES-REFUSE/RECYCLING $1,486.06 $1,510.00 98.41% $1,765.78 E 609-49750-385 UTILITIES-SEWER CHARGES $2,364.07 $1,200.00 197.01% $1,302.74 E 609-49750-390 TAP CLEANING SERVICE $625.00 $1,000.00 62.50% $616.00 E 609-49750-400 REPAIRS AND MAINT $4,870.12 $4,000.00 121.75% $3,532.28 E 609-49750-418 UNIFORMS $0.00 $500.00 0.00% $0.00 E 609-49750-420 DEPRECIATION $9,795.50 $12,000.00 81.63% $11,846.05 E 609-49750-430 MISCELLANEOUS $18.79 $500.00 3.76% $646.55 E 609-49750-431 CASH SHORT/OVER -$346.36 $100.00 -346.36% $131.63 E 609-49750-433 DUES AND SUBSCRIPTIONS $1,960.00 $800.00 245.00% $822.10 E 609-49750-490 DONATIONS $0.00 $0.00 0.00% $150.00 E 609-49750-501 CAPITAL OUTLAY $92,973.58 $10,000.00 929.74% $0.00 E 609-49750-725 TRANSFER TO GENERAL FUND $0.00 $20,000.00 0.00% $0.00 49750 LIQUOR $822,673.12 $960,308.86 85.67% $758,396.30
900 GASB 34
41000 GENERAL GOVERNMENT E 900-41000-420 DEPRECIATION $22,176.80 $0.00 0.00% $24,394.48 41000 GENERAL GOVERNMENT $22,176.80 $0.00 0.00% $24,394.48
42000 PUBLIC SAFETY E 900-42000-420 DEPRECIATION $113,522.55 $0.00 0.00%