Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
11.07.22 Council Packet
CITY OF Meeting Location: FARMINGTON Farmington City Hall 430 Third Street Farmington,MN 55024 CITY COUNCIL REGULAR MEETING AGENDA November 7, 2022 7:00 P.M. Action Taken 1. CALL TO ORDER 7:00 P.M. 2. PLEDGE OF ALLEGIANCE 3. ROLL CALL 4. APPROVE AGENDA 5. ANNOUNCEMENTS/COMMENDATIONS 6. CITIZEN COMMENTS/RESPONSES TO COMMENTS(This time is reserved for citizen comments regarding non-agenda items. No official action can be taken on these items. Speakers are limited to five minutes to address the city council during citizen comment time.) 7. CONSENT AGENDA a) Approve October 17, 2022, City Council Meeting Minutes-Administration Approved b) Adopt Resolution Approving Gambling Premise Permits—Farmington Youth Tabled to Nov 14 Work Hockey Association —Administration Session c) Acknowledge Financial Review for the Quarter Ended September 30, 2022— Finance Acknowledged d) Approval of Liability Coverage Waiver Form—Finance Approved e) Approve Bills—Finance Approved f) Purchase of Capital Improvement Plan Software—Finance Approved g) Staff Changes and Recommendations—Human Resources Approved h) Recalibration of Current Salary Structure— Human Resources Approved I) Adopt Resolution Accepting Donation from Farmington VFW Post 7662 to the Halloween Walk—Parks and Recreation R77-22 REGULAR AGENDA 8. PUBLIC HEARINGS 9. AWARD OF CONTRACT 10. PETITIONS, REQUESTS AND COMMUNICATIONS 11. UNFINISHED BUSINESS 12. NEW BUSINESS 13. CITY COUNCIL ROUNDTABLE 14. ADJOURN CITY OF O 430 Third St., Farmington, MN 55024 FARMINGTON 0 651-28o-6800 woo Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Cynthia Muller, Administrative Assistant SUBJECT: Approve October 17, 2022, City Council Meeting Minutes-Administration DATE: November 7, 2022 INTRODUCTION Attached for your review are the minutes of the October 17, 2022,city council meeting. DISCUSSION N/A BUDGET IMPACT N/A ACTION REQUESTED Approve the minutes of the October 17, 2022, city council meeting. ATTACHMENTS: Type Description D Exhibit Meeting Minutes COUNCIL MINUTES REGULAR October 17, 2022 1. CALL TO ORDER The meeting was called to order by Mayor Hoyt at 7:00 p.m. 2. PLEDGE OF ALLEGIANCE Mayor Hoyt led the audience and Council in the Pledge of Allegiance. 3. ROLL CALL Members Present: Hoyt, Lien, Wilson Members Absent: Bernhjelm, Porter Also Present: Leah Koch, City Attorney; Lynn Gorski, City Administrator; Chris Regis, Finance Director;Justin Elvestad, Fire Chief; Gary Rutherford, Police Chief; Kellee Omlid, Parks and Recreation Director; Cynthia Muller, Administrative Assistant Audience: Becky DeWilde 4. APPROVE AGENDA MOTION by Wilson, second by Lien to approve the agenda. APIF, MOTION CARRIED. 5. ANNOUNCEMENTS 6. CITIZEN COMMENTS 7. CONSENT AGENDA MOTION by Lien, second by Wilson to approve the Consent Agenda as follows: a) Approved October 3, 2022, City Council Work Session and Meeting Minutes— Administration b) Approved Temporary On-Sale Liquor License—Knights of Columbus— Administration C) Adopted RESOLUTION R73-22 Approving Gambling Event Permit—Knights of Columbus—Administration d) Approved Temporary On-Sale Liquor License—Farmington Area Education Foundation—Administration e) Adopted RESOLUTION R74-22 Approving Gambling Event Permit—Farmington Area Education Foundation —Administration f) Received Third Quarter 2022 New Construction Report and Population Estimate —Community Development g) Approved an Amendment to the Contract for Design Services on the 2022 Street Improvement Project- Engineering h) Approved Final Payment for Design Services on the TH3 Trail Improvements— Engineering i) Approved Bills— Finance j) Approved AFSCME Maintenance Unit, Local #3815 and AFSCME Clerical, Technical, Professional Local #3815 Memorandums of Understanding (MOU) — Human Resources Council Minutes(Regular) October 17,2022 Page 2 k) Approved Staff Changes and Recommendations—Human Resources 1) Approved 2022-2023 Farmington High School Hockey Game Ice Rental Agreement—Parks and Recreation m) Adopted RESOLUTION R75-22 Approving Plans and Specifications and Authorize Advertisement for Bids for the City Hall Boiler Replacement Project—Parks and Recreation APIF, MOTION CARRIED. 8. PUBLIC HEARINGS a) Adopt Resolution Certifying Delinquent Municipal Services to 2023 Property Taxes- Finance Notices were mailed to property owners with delinquent utility invoices as of July 31, 2022, as well as delinquent mowing invoices and code violations. Recipients had until October 14, 2022, to pay the delinquent amount in full. At the time of the meeting,453 accounts had unpaid invoices totaling$231,504. MOTION by Wilson, second by Lien to close the public hearing. APIF, MOTION CARRIED. MOTION by Lien, second by Wilson to adopt RESOLUTION R76-22 certifying the delinquent accounts as an addition to the 2023 real estate taxes of the appropriate properties. APIF, MOTION CARRIED. 9. AWARD OF CONTRACT 10. PETITIONS, REQUESTS AND COMMUNICATIONS 11. UNFINISHED BUSINESS 12. NEW BUSINESS 13. COUNCIL ROUNDTABLE Lien: Thank you to the Parks and Recreation Commission for the adopt-a-park signs. Wilson: The city has an ordinance regulating campaign signs, allowing them only on private property with the property owner's permission. The purpose is to keep the city attractive while promoting candidates. Residents received an automated voicemail last week stating yard waste service will end the week of November 14, 2022. On the Consent Agenda tonight, we approved two new employees we are very excited to have join us. Gorski: Thank you to the Council for approving appointments for the new community development director and public works director. Thank you to staff for taking on extra assignments until these positions were filled. We have an opening for a communications specialist. The deadline for applying is October 20, 2022. On October 19, 2022, the north bound leg of the roundabout on TH3 will be closed as they are sealing the bridge. Blacktop has been laid on the east side of the arena and work has started on the west side. Council Minutes(Regular) October 17,2022 Page 3 Omlid: The Halloween Walk is October 28, 2022, from 5:30 to 7:30 p.m. at Dodge Middle School. The annual Rambling River Center breakfast and silent auction is October 29, 2022. The Halloween lights tour started tonight. Regis: Finance staff is participating in demonstrations for the new software. Rutherford: October is breast cancer awareness month and the police department is participating in the pink patch project. The liquor store is promoting a fundraiser and silent auction for the food shelf. In two weeks, winter parking restrictions will start on November 1, 2022. Courtesy warnings will be given out in the beginning. Elvestad: Turkey bingo is November 12, 2022. Hoyt: Temperatures should climb by the end of the week, so it will be a good time to get the fall chores done to prepare for winter. Community activities are increasing this time of year. Encouraged residents to shop local. 14. ADJOURN MOTION by Wilson, second by Lien to adjourn at 7:13 p.m. APIF, MOTION CARRIED. Respectfully submitted, Cynthia Nuller Cynthia Muller Administrative Assistant CITY 4F O 43o Third St., Farmington, MN 55024 FARMINGTON 651-28o-6800 Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Cynthia Muller,Administrative Assistant SUBJECT: Adopt Resolution Approving Gambling Premise Permits—Farmington Youth Hockey Association -Administration DATE: November 7, 2022 INTRODUCTION Farmington Youth Hockey Association is requesting two Gambling Premise Permits at Las Enchiladas, 18500 Pilot Knob Road#A and Farmington Lanes, 27 5th Street. DISCUSSION Pursuant to State Statute and pertinent city code, an organization must first obtain a resolution from the city,granting permission for gambling to occur at a specific location. Farmington Youth Hockey Association is requesting approval to conduct gambling activity at Las Enchiladas 18500 Pilot Knob Road #A and Farmington Lanes, 27 5th Street. The appropriate application and fees have been received. BUDGET IMPACT Gambling permit fees are included in the revenue estimates of the 2022 budget. ACTION REQUESTED Adopt the attached resolution approving two Gambling Premise Permits for Farmington Youth Hockey Association at Las Enchiladas, 18500 Pilot Knob Road#A and Farmington Lanes, 27 5th Street. ATTACHMENTS: Type Description D Resolution Resolution RESOLUTION NO. APPROVING TWO MINNESOTA LAWFUL GAMBLING PREMISE PERMIT APPLICATIONS FOR FARMINGTON YOUTH HOCKEY ASSOCIATION Pursuant to due call and notice thereof,a regular meeting of the City Council of the City of Farmington, Minnesota,was held in the Council Chambers of said City on the 7th day of November 2022 at 7:00 p.m. Members Present: Members Absent: Member and Member introduced and seconded the following: WHEREAS,pursuant to M.S.349.166,the State of Minnesota Gambling Board may not issue or renew a Gambling Premise Permit unless the City Council adopts a resolution approving said permit; and, WHEREAS,Farmington Youth Hockey Association has submitted applications for two Gambling Premise Permits to be conducted at 18500 Pilot Knob Road#A and 27 5th Street,for Council consideration. NOW,THEREFORE, BE IT RESOLVED by the Farmington City Council that the Gambling Premise Permits for Farmington Youth Hockey Association at 18500 Pilot Knob Road#A and 27 5th Street, are hereby approved. This resolution adopted by recorded vote of the Farmington City Council in open session on the 7th day of November 2022. Mayor Attested to the day of November 2022. City Administrator SEAL CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 II W Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Chris Regis, Finance Director SUBJECT: Acknowledge Financial Review for the Quarter Ended September 30, 2022- Finance DATE: November 7, 2022 INTRODUCTION Staff reviews the financial performance of the General Fund and several other funds with the city council quarterly review. The financial statements are included in your packet.The following provides a more in depth review of the General Fund and highlights notable areas for the other funds included in this review. DISCUSSION General Fund The General Fund is the City's primary operating account.The financial summary for the first nine months is the first two pages of the attachment. The following will provide explanations for the various revenue items and highlights the more significant expenditure variations.The items reviewed are in the order they appear on the attached General Fund financial statement. Revenues For 2022, budgeted General Fund revenues total$15,729,719 including transfers. During the third quarter of the year the city recorded General Fund revenues totaling$9,438,527 or 60%of total budgeted revenues. Property taxes represent the majority of total General Fund revenues (including transfers in from other funds). Property taxes are generally payable in two installments, May and October and collected by the county.The city receives its share from the county in June and December. While there are many reasons the city needs a fund balance(which is similar to an individual's personal net worth), needing to pay its bills between the receipt of tax payments from the county is the most significant reason. Over the past few years,the city has strengthened its fund balance and is now able to pay all of its General Fund bills between the receipt of tax payments, essentially vendor payments and paychecks,from the county without borrowing from other funds. The other types of revenues in the General Fund consist of licenses, permits, intergovernmental revenue, charges for services,fines, investment income,franchise fees, rental income and miscellaneous revenues. Licensing includes liquor, beer and wine, massage, animal, etc. Fees for the third quarter of 2022 are at $37,914, or 84% of budget and they exceed prior year third quarter results. Permit revenue includes building, plumbing, heating, electric, etc., permits. The revenue for the third quarter of 2022 is $591,122 which is slight increase over the 2021 amount. I ntergovernmental revenue includes local government aid (LGA), municipal state aid (MSA) maintenance, police and fire aid, and federal,state, and local grants.The city's allotment of LGA for 2022 is$105,587, the same amount as 2021. LGA is paid in two installments,July and December.As of September 30,the city has received its allotment of police and fire state aid,the amount received was $437,056. Charges for services includes fire, recreation, school resource officer(SRO), etc., charges. Castle Rock and Eureka townships are billed quarterly for fire protection. Empire,the largest of the three townships, is billed annually, after year end, per contract. Non-contract(i.e., illegal and/or hazardous)fires are billed as they occur. The schools are billed for their share of the school resource officers human resource costs on a quarterly basis. Recreation programs,which are primarily offered in the summer, currently show improvement over prior year revenues for the same time period. Fines revenue is received the month following the occurrence of the fine. Current levels of revenue exceed prior year amounts by approximately$4,448 which may signal improvement from prior years levels. I nvestment income consists of investment earnings from the city's portfolio and the annual mark-to- market calculation to recognize the market value of the investment portfolio.The income amounts are based on average monthly cash balances. Currently, investment income is trending slightly higher than 2021 levels. Miscellaneous revenues include rental income related to the Rambling River Center (RRC-senior center), the rental of city hall space by the USDA, and the rental of fire station space by Allina Health. I n addition, the category includes donations and any other types of revenues that don't fit into a specific category. Franchise fee revenue in the General Fund represents the transfer of a portion of the city's franchise fee revenue to the General Fund to help pay for city operations.The remainder of the franchise fees are used to pay for the city's cable operations.The payments are received quarterly,with the first payment of the year received early in the second quarter. Expenditures Finance tracks general fund expenditures by department. The following notes explain significant or unusual variations from last year or actual versus budgeted amounts which may vary somewhat from the expected 75 percent(9 of 12 months)through the end of September in the same order as they appear on the attached General Fund financial report. The administration division currently exceeds budget due to the payout of a non-budgeted legal settlement, costs to rekey city hall, boiler repair and the costs associated with the USDA buildout. The Human Resources division exceeds budgeted levels due to temporary employment costs, accrued leave payouts, and employee severance settlements. The Finance department currently exceeds budget year to date.The overage can be traced to the Risk Management division due to an increase in property and liability premium costs. The city is part of a JPA for the Dakota Broadband Board (D BB). Costs include the annual access fee and quarterly operating charges. Within the Community Development department,the Building Inspections division exceeds budget levels quarter to date. An increase in personnel costs resulting from a new building inspector hired in January, and increased overtime costs are some of the causes for the increased costs year to date. Park Maintenance in the Recreation Services department currently exceeds budgeted levels year to date. The increase can be traced to increased personnel, equipment supplies and parts,fuel, and utility costs. The Recreation Programs division also exceeds budget year to date.The increase can be traced to increased personnel costs year to date. Overall,the General Fund expenditures before transfers are at 72.05%of budget for the third quarter of the year. EDA, Park Improvement,and Arena The EDA (Economic Development Authority), Park I mprovement Fund, and Ice Arena activities have historically been of interest to the council.They are included for your review. EDA Revenues for the EDA include only interest income for the third quarter. Expenditures include fa§ade grant payments, membership, IT charges and training costs. Park Improvement Fund The Park I mprovement fund revenues includes park development and dedication fees totaling$306,880 and a farm lease payment. Expenditures for the quarter relate to costs incurred related to the update of the parks master plan and park supplies for Lake Julia and Evergreen Knoll parks. Arena Revenues for the arena have decreased as compared to prior year to date levels due to decrease ice rental revenues. Expenditures reflect increases over the prior year levels due to increases in repair and maintenance, IT, contractual services and utility costs. Liquor Operations The City has two financial benchmarks for its liquor operations.The first is a 25 percent gross profit margin. For the third quarter both of the stores met the gross profit margin target. The second standard is a 6 percent profit as a percent of sales. This is evaluated on a combined basis. For the third quarter, the operation exceeded the standard and reported a 7.60%of profit as a percent of sales. Sales for the third quarter ending have increased by$617,234 or 15.24%over 2021.The Downtown store has increased sales by$672,780,while the Pilot Knob store reflects a decrease of$55,546. After each calendar year, staff reviews the combined financial results of the two liquor stores, determines the amount of funds needed to cover day to day operations and administrative transfers to the General Fund.The remaining funds are divided evenly and transferred into the Community Investment and Capital I mprovement accounts.This is referred to as the four pots philosophy. Each year staff utilizes actual financial results to fund these four pots. Staff periodically makes recommendations to council on how to best invest available dollars in the Community I nvestment pot to benefit the community. Meanwhile,the capital improvement dollars are available for future liquor store capital building needs (e.g., remodeling, updating, relocation, possible building, etc.).The transfer is completed as part of the audit process. Enterprise Funds The city operates five utility funds:sewer operations, solid waste, storm water,water, and street lighting. The solid waste fund is shown in this report as there is still some activity in the fund. Sewer Operations Revenues for the Sewer fund reflect an increase of$273,086 as compared to 2021 due to an increase in rates. Expenses have increased due to increased VICES (Metropolitan Council Environmental Services) fees, which are fees charged to treat the city to treat its wastewater.The fees reflect an increase in the cost to treat the volumes processed.Transfers out have increased due to the fund contributing its share for sewer infrastructure improvements as part of the Spruce/Division Street project. Solid Waste The city ceased its solid waste operation as of December 31, 2021.Activity in the fund for the year to date represents revenues for the final billings for services from the last quarter of 2021,the costs for benefit payouts to former employees, and the costs for the city paying for the first quarter of solid waste services for the residents and businesses of the city. Storm Water Expenses for the Storm Water operation reflect an increase from the prior year quarter end.The increase can be traced to increased professional service costs and 2022 pond maintenance costs. Revenues have increased moderately as the result of a rate increase. The fund has realized an increase in transfers out due to the fund contributing its share of the Spruce/Division Street project. Water Revenues for the water fund reflect a decrease due to a decrease in water consumption and water trunk charges. Beginning in 2022, a water trunk fund was established so all new trunk charges are deposited into that fund. Expenses reflect an increase due to increases in equipment supplies and parts, professional services and utilities costs. Similar to the Sewer and Storm Water funds,transfers out for the Water fund have increased due to the Spruce/Division Street project. Street Light Operating results for the street light fund have decreased approximately$23,000 from the prior year due to increases in electrical costs. For all of the city's utility funds,the billing cycle(revenue) lags the recording of expenses. For example, the city bills every three months.The January billing includes November and December of the previous year, as well as January of the current year. So,two-thirds of that billing cycle is attributable to the prior year and is recorded as such in the financial statements. This means that at the end of the year this year, the financial statements will remain open so that the revenues for the current year can be captured, even though they will not be billed out until January and February of the following year. BUDGET IMPACT The budget impacts have been noted above as appropriate ACTION REQUESTED Review and acknowledge the financial reports for the third quarter September 30, 2022. ATTACHMENTS: Type Description a Backup Material Quarter Ending September 30, 2022 Financial Statements CITY OF FARMINGTON FINANCE DIVISION MONTHLY FINANCIAL REPORT September 30,2022 STATEMENT OF REVENUES-BUDGET TO ACTUAL REVENUE SOURCE THIS 2022 YEAR 2021 YEAR DIFFERENCE PERCENT BUDGET MONTH TO DATE TO DATE UNDER(OVER) COLLECTED Taxes $ 12,118,136 $ - $ 6,295,438 $ 5,708,226 $ 5,822,698 51.95% Business Licenses 44,900 370 37,914 26,717 6,986 84.44% Building Permits 691,800 55,180 591,122 587,896 100,678 85.45% Fines and Forfeits 50,000 4,395 39,825 35,377 10,175 79.65% Intergovernmental: Local Government Aid 105,587 - 52,794 52,794 52,793 50.00% Law Officers Training Reimbursement 15,000 - 25,370 25,759 (10,370) 0.00% MSA Maintenance 184,000 - 333,718 325,993 (149,718) 181.37% State Aid Police/Fire 355,000 437,056 439,056 - (84,056) 123.68% Grants-Federal 5,000 - 11,092 9,623 (6,092) 221.84% Other Grants 7,500 893 35,380 87,341 (27,880) 471.73% Charges for Services: General government 7,135 166 15,253 18,318 (8,118) 213.78% Public Safety 339,325 20,979 122,615 145,436 216,710 36.13% Public Works 9,500 1,350 82,359 38,241 (72,859) 866.94% Park and Recreation 101,500 5,896 76,471 69,929 25,029 75.34% Miscellaneous Revenues Investment Income 41,600 7,365 44,144 40,525 (2,544) 106.12% Rental Income 46,678 4,433 33,209 29,260 13,469 71.14% Franchise Fees 145,000 - 102,454 97,281 42,546 70.66% Other 34,200 186 29,420 11,308 4,780 86.02% Transfers 1,427,858 118,988 1,070,893 1,034,767 356,965 75.00% Total $ 15,729,719 $ 657,257 $ 9,438,527 $ 8,344,791 $ 6,291,192 60.00% Cash Balance as of September 30,2022$5,130,675. CITY OF FARMINGTON MONTHLY FINANCIAL REPORT September 30,2022 GENERALFUND STATEMENT OF EXPENDITURES-BUDGET TO ACTUAL UNEXPENDED PERCENT DEPARTMENT/DIVISION BUDGET YEAR TO DATE BALANCE EXPENDED ADMINISTRATION Legislative $ 87,259 $ 55,722 $ 31,537 63.86% Administration 469,641 381,403 88,238 81.21% Elections 47,948 17,268 30,680 36.01% Communications 132,916 86,631 46,285 65.18% City Hall 361,485 303,804 57,681 84.04% Total $ 1,099,249 $ 844,828 254,421 76.86% HUMAN RESOURCES Human Resources $ 402,112 $ 438,839 $ (36,727) 109.13% Total $ 402,112 $ 438,839 (36,727) 109.13% DAKOTA BROADBAND Dakota Broadband $ 45,500 $ 24,685 $ 20,815 54.25% Total $ 45,500 $ 24,685 $ 20,815 54.25% FINANCE AND RISK MANAGEMENT Finance $ 648,309 $ 484,506 $ 163,803 74.73% Risk Management 170,450 138,022 32,428 80.98% Total $ 818,759 $ 622,528 $ 196,231 76.03% POLICE Police Administration $ 1,356,642 $ 981,681 $ 374,961 72.36% Patrol Services 2,929,249 2,150,111 779,138 73.40% Investigations 974,019 698,381 275,638 71.70% Emergency Management 19,900 823 19,077 4.14% Total $ 5,279,810 $ 3,830,996 $ 1,448,814 72.56% FIRE Fire $ 1,592,646 $ 1,014,292 $ 578,354 63.69% Total $ 1,592,646 $ 1,014,292 $ 578,354 63.69% COMMUNITY DEVELOPMENT Planning $ 624,475 $ 351,067 $ 273,408 56.22% Building Inspections 434,707 415,972 18,735 95.69% Total $ 1,059,182 $ 767,039 $ 292,143 72.42°% ENGINEERING Engineering $ 725,816 $ 397,294 $ 328,522 54.740/6 Natural Resources 124,595 55,369 69,226 44.440/6 Total $ 850,411 $ 452,663 $ 397,748 53.23% MUNICIPAL SERVICES Streets $ 1,358,489 $ 908,898 $ 449,591 66.91°% Snow Removal 251,215 141,057 110,158 56.15% Total $ 1,609,704 $ 1,049,955 $ 559,749 65.23% RECREATION SERVICES Park Maintenance $ 677,974 $ 627,818 $ 50,156 92.60% Rambling River Center 227,731 132,369 95,362 58.13% Park&Recreation Admin 324,745 220,291 104,454 67.840/6 Recreation Programs 99,287 75,404 23,883 75.95% Total $ 1,329,737 $ 1,055,882 $ 273,855 79.41% Transfers Out $ 1,642,609 $ 1,231,957 $ 410,652 75.00°% TOTAL GENERAL FUND $ 15,729,719 $ 11,333,664 $ 4,396,055 72.05% CITY OF FARMINGTON MONTHLY FINANCIAL REPORT September 30, 2022 ECONOMIC DEVELOPMENT AGENCY COMPARATIVE STATEMENT OF REVENUES AND EXPENSES BUDGET THIS YEAR TO YEAR TO PERCENT 2021 2022 MONTH DATE 2022 DATE 2021 COLL/EXP ACTUAL REVENUES Other Income - - - 34,000 0.00% 34,000 Interest 2,400 350 2,256 2,533 94.00% 251 Total Revenues 2,400 350 2,256 36,533 94.00% 34,251 EXPENDITURES Other Services&Charges 41,916 1,033 35,755 84,350 85.30% 120,376 TOTAL EXPENDITURES 41,916 1,033 35,755 84,350 85.30% 120,376 TRANSFERS 50,000 4,167 81,867 30,000 (4,367) EXCESS(DEFICIENCY) $ 10,484 $ 3,484 $ 48,368 $ (17,817) $ (90,492) Cash Balance as of September 30, 2022$214,679. CITY OF FARMINGTON MONTHLY FINANCIAL REPORT September 30, 2022 PARKIMPROVEMENTFUND COMPARATIVE STATEMENT OF REVENUES AND EXPENSES BUDGET THIS YEAR TO YEAR TO PERCENT 2021 2022 MONTH DATE 2022 DATE 2021 COLL/EXP ACTUAL REVENUES Park Dedication Fees $ 25,000 $ - $ 210,000 $ 198,943 840.00% $ 198,943 Park Development Fees - - 96,880 186,570 0.00% 186,570 Rental Income 8,400 - 7,403 8,403 88.13% 8,403 Miscellaneous Revenue - - - 24,120 0.00% 30,424 Interest 3,200 1,889 10,860 6,167 339.38% (5,595) Total Revenues 36,600 1,889 325,143 424,203 888.37% 418,745 EXPENDITURES Other Services &Charges 157,500 8,702 19,591 6,448 12.44% 6,860 Capital Outlay - - - 10,837 0.00% 11,740 TOTAL EXPENDITURES 157,500 8,702 19,591 17,285 12.44% 18,600 Transfers 75,000 6,250 56,250 56,250 75,000 EXCESS (DEFICIENCY) $(45,900) $ (563) $ 361,802 $463,168 $ 475,145 Cash Balance as of September 30, 2022 $1,349,149. CITY OF FARMINGTON MONTHLY FINANCIAL REPORT September 30, 2022 ICE ARENA COMPARATIVE STATEMENT OF REVENUES AND EXPENSES BUDGET THIS YEAR TO YEAR TO PERCENT 2021 2022 MONTH DATE 2022 DATE 2021 COLL/EXP ACTUAL REVENUES User Fees $ 386,700 $ 23,482 $ 211,250 $ 238,524 54.63% $ 402,929 Interest 300 - 409 426 136.33% 355 Other Revenue 9,000 - 6,360 8,380 70.67% 10,100 Total Revenues 396,000 23,482 218,019 247,330 55.06% 413,384 Cost of Sales (750) - - - 0.00% - TOTAL REVENUES 395,250 23,482 218,019 247,330 55.16% 413,384 EXPENDITURES Personal Services 300,986 16,816 180,660 179,382 60.02% 260,104 Other Services &Charges 126,015 17,664 118,332 99,554 93.90% 143,032 Capital Outlay 500 - - 2,459 0.00% 2,699 TOTAL EXPENDITURES 427,501 34,480 298,992 281,395 69.94% 405,835 TRANSFERS - - - - 45,000 EXCESS (DEFICIENCY) $ (32,251) $ (10,998) $ (80,973) (34,065) $ 52,549 Cash Deficit as of September 30, 2022 ($142). CITY OF FARMINGTON MONTHLY FINANCIAL REPORT September 30, 2022 SEWER FUND COMPARATIVE STATEMENT OF REVENUES AND EXPENSES BUDGET THIS YEAR TO YEAR TO PERCENT 2021 2022 MONTH DATE 2022 DATE 2021 COLL/EXt ACTUAL REVENUES Charges for Service* $ 2,547,821 $ 387,633 1,813,242 $ 1,520,141 71.17% $ 2,260,523 Interest 21,300 3,185 20,118 23,163 94.45% (5,267) Other Revenue - - - 16,970 0.00% 171,730 TOTAL REVENUES 2,569,121 390,818 1,833,360 1,560,274 71.36% 2,426,986 EXPENSES Personnel Services 13,038 - 847 1,682 6.50% 2,070 Other Services&Chargef 297,773 10,277 117,419 121,104 39.43% 155,651 MCES Charges** 1,789,024 149,085 1,341,768 1,245,828 75.00% 1,661,104 Depreciation 661,944 55,162 496,458 498,965 75.00% 665,287 TOTAL EXPENSES 2,761,779 214,524 1,956,492 1,867,579 70.84% 2,484,112 TRANSFERS (350,127) (28,578) (500,103) (249,827) (444,419) EXCESS (DEFICIENCY) $ (542,785) $ 147,716 $ (623,235) $ (557,132) $ (501,545) FOOTNOTES: * Charges for Services are not collected on an even flow basis during the year due to the accrual of revenues year end. Wastewater sales for October, November, and December are not billed until the subsequent year, but are accrued at year end. **MCES wastewater charges are made on an annual and monthly basis. The budgeted amount is anticipated as the total expenditure in 2022. Cash Balance as of September 30, 2022$2,274,925. CITY OF FARMINGTON MONTHLY FINANCIAL REPORT September 30, 2022 SOLID WASTE FUND COMPARATIVE STATEMENT OF REVENUES AND EXPENSES BUDGET THIS YEAR TO YEAR TO PERCENT 2021 2022 MONTH DATE 2022 DATE 2021 COLL/EXP ACTUAL REVENUES Charges for Services* $ 775,103 $ 2,836 $ 18,663 $ 1,945,301 2.41% $ 2,854,452 Intergovernmental 33,000 - 1,027 114,811 0.00% 234,794 Interest 11,100 2,732 18,610 14,009 167.66% (15,611) Other Revenue - - 487,129 1,909 0.00% 4,506 TOTAL REVENUES 819,203 5,568 525,429 2,076,030 64.14% 3,078,141 EXPENSES Personnel Services 299,300 - 66,143 363,745 22.10% 484,079 Other Services&Charges 1,013,496 1,093 921,835 1,555,732 90.96% 2,022,849 Depreciation 15,998 1,333 11,999 96,563 75.00% 128,751 TOTAL EXPENSES 1,328,794 2,426 999,977 2,016,040 75.25% 2,635,679 TRANSFERS (119,356) (13,000) (116,999) (85,547) (114,063) EXCESS (DEFICIENCY) $ (628,947) $ (9,858) $ (591,547) $ (25,557) $ 328,399 * Charges for Services are not collected on an even flow basis during the year due to the accrual of revenues year end. Solid Waste sales for October, November, and December are not billed until the subsequent year, but are accrued at year end. Cash Balance as of September 30, 2022 $1,951,572. CITY OF FARMINGTON MONTHLY FINANCE REPORT September 30, 2022 STORM WATER FUND COMPARATIVE STATEMENT OF REVENUES AND EXPENSES BUDGET THIS YEAR TO YEAR TO PERCENT 2021 2022 MONTH DATE 2022 DATE 2021 COLL/EXF ACTUAL REVENUES Charges for Services* $ 1,260,250 $ 191,588 $ 864,173 $ 818,372 68.57% $ 1,158,564 Interest 15,200 2,882 19,232 21,345 0.00% (5,643) Other - - - - 0.00% 156,864 TOTAL REVENUES 1,275,450 194,470 883,405 839,717 69.26% 1,309,785 EXPENSES Personnel Services 9,229 - 781 359 8.46% 359 Other Services&Charges 303,373 10,859 214,948 200,480 70.85% 122,016 Depreciation 458,531 38,211 343,898 330,316 75.00% 458,815 TOTAL EXPENSES 771,133 49,070 559,627 531,155 72.57% 581,190 TRANSFERS (422,241) (34,588) (922,289) (301,932) (524,951) EXCESS (DEFICIENCY) $ 82,076 $ 110,812 $ (598,511) $ 6,630 $ 203,644 * Charges for Services are not collected on an even flow basis during the year due to the accrual of revenues year end. Storm Water sales for October, November,and December are not billed until the subsequent year, but are accrued at year end. Cash Balance as of September 30, 2022$2,058,169. CITY OF FARMINGTON MONTHLY FINANCIAL REPORT September 30, 2022 WATER FUND COMPARATIVE STATEMENT OF REVENUES AND EXPENSES BUDGET THIS YEAR TO YEAR TO PERCENT 2021 2022 MONTH DATE 2022 DATE 2021 COLUEXP ACTUAL REVENUES Charges for Service* $ 2,215,389 $ 488,967 $ 1,535,117 $ 1,573,298 69.29% $ 2,281,002 Trunk Charges 294,600 - - 564,107 0.00% 627,350 Interest 75,200 14,880 95,383 94,727 126.84% (33,693) Rental Income 260,000 40,004 263,225 245,652 101.24% 277,747 Other Revenue - 725 1,475 2,171 0.00% 238,813 TOTAL REVENUES 2,845,189 544,576 1,895,200 2,479,955 66.61% 3,391,219 EXPENSES Personnel Services 30,829 1,310 5,235 3,318 16.98% 5,473 Other Services&Charges 639,623 104,367 621,519 544,884 97.17% 757,464 Debt Service - - 26,425 29,550 0.00% 18,462 Depreciation 1,038,885 86,574 779,164 743,738 75.00% 1,039,124 TOTAL EXPENSES 1,709,337 192,251 1,432,343 1,321,490 83.80% 1,820,523 TRANSFERS (472,668) (37,492) (1,253,227) (333,028) (582,728) EXCESS (DEFICIENCY) $ 663,184 $ 314,833 $ (790,370) $ 825,437 $ 987,968 FOOTNOTES: * Charges for services are not collected on an even flow basis during the year due to the accrual of revenues at year end. Water sales for October, November,and December may not be billed until the subsequent year, but are accrued at year end. Cash Balance as of September 30, 2022 Operating $ 6,057,203 Water Treatment Plant 2,461,488 $ 8,518,691 CITY OF FARMINGTON MONTHLY FINANCIAL REPORT September 30, 2022 STREET LIGHT FUND COMPARATIVE STATEMENT OF REVENUES AND EXPENSES BUDGET THIS YEAR TO YEAR TO PERCENT 2021 2022 MONTH DATE 2022 DATE 2021 COLL/EXP ACTUAL REVENUES Charges for Services* $ 224,000 $ 22,809 $ 157,001 $ 155,130 70.09% $ 230,479 Interest 2,100 506 3,042 2,978 144.86% (972) Other Revenue - - - - 0.00% 1,899 TOTAL REVENUES 226,100 23,315 160,043 158,108 70.78% 231,406 EXPENSES Other Services&Charges 221,500 19,368 158,007 133,189 71.33% 180,528 TOTAL EXPENSES 221,500 19,368 158,007 133,189 71.33% 180,528 EXCESS (DEFICIENCY) $ 4,600 $ 3,947 $ 2,036 $ 24,919 $ 50,878 * Charges for services are not collected on an even flow basis during the year due to the accrual of revenues at year end. Street Light sales for October, November, and December may not be billed until the subsequent year, but are accrued at year end. Cash Balance as of September 30, 2022 $361,175. CITY OF FARMINGTON MUNICIPAL LIQUOR OPERATIONS September 30, 2022 DOWNTOWN PILOT KNOB TOTAL YEAR TO DATE YEAR TO DATE YEAR TO DATE SALES 2022 $ 2,121,954 $ 2,546,257 $ 4,668,211 2021 1,449,174 2,601,803 4,050,977 $ Difference 672,780 (55,546) 617,234 % Difference 46.43% -2.13% 15.24% COST OF GOODS SOLD 1,588,934 1,895,412 3,484,346 GROSS PROFIT 533,020 650,845 1,183,865 %OF GROSS PROFIT TO SALES 25.12% 25.56% 25.36% OPERATING EXPENSES: Personnel Services &Supplies 233,149 205,441 438,590 Other Services &Charges 173,009 215,029 388,038 Depreciation 1,279 1,182 2,461 TOTAL 407,437 421,652 829,089 Operating Income 125,583 229,193 354,776 Other Income 8,542 7,105 15,647 INCOME BEFORE TRANSFERS 134,125 236,298 370,423 Profit as a %of Sales 7.60% Operating Transfers(Out) (53,612) (53,612) (107,224) NET INCOME $ 80,513 $ 182,686 $ 263,199 Cash Balance as of September 30, 2022 Operating Cash(Pots 1 &2) $ 550,823 Community Projects (Pot 3) 321,139 Capital Improvements (Pot 4) 769,146 Petty Cash 3,502 $ 1,644,610 CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 Fu, Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Chris Regis, Finance Director SUBJECT: Approval of Liability Coverage Waiver Form- Finance DATE: November 7, 2022 INTRODUCTION The attached Liability Coverage—Waiver form requires approval by the City Council. DISCUSSION Members who obtain liability coverage through the League of Minnesota Cities I nsurance Trust(LMCIT) must decide whether to waive the statutory tort liability limits to the extent of the coverage purchased. BUDGET IMPACT N/A ACTION REQUESTED Approve the Liability Coverage Waiver form as presented. ATTACHMENTS: Type Description ❑ Backup Material Liability Coverage-Waiver Form i I I LMCLEAGUE of MINNESOTA CITIES i LIABILITY COVERAGE —WAIVER FORM Members who obtain liability coverage through the League of Minnesota Cities Insurance Trust (LMCIT)must complete and return this form to LMCIT before the member's effective date of coverage.Return completed form to your underwriter or email to pstech a lrnc.org. The decision to naive or not waive the steitutw y toil liinits must be made annually by the member's governing body, in consultation with its attorney if necessary. Members who obtain liability coverage from LMCIT must decide whether to waive the statutory tort liability limits to the extent of the coverage purchased. The decision has the following effects: • If the member does not waive the statutory tort limits,an individual claimant could recover no more than$500,000 on any claim to which the statutory tort limits apply. The total all claimants could recover for a single occurrence to which the statutory tort limits apply would be limited to$1,500,000. These statutory tort limits would apply regardless of whether the member purchases the optional LMCIT excess liability coverage. • If the member waives the statutory tort limits and does not purchase excess liability coverage,a single claimant could recover up to$2,000,000 for a single occurrence(tinder the waive option,the tort cap liability limits are only waived to the extent of the member's liability coverage limits,and the LMCIT per occurrence limit is$2,000,000).The total all claimants could recover for a single occurrence to which the statutory tort limits apply would also be limited to$2,000,000,regardless of the number of claimants. • Ifthe member waives the statutory tort limits andpurehases excess liabilio)coverage,a single claimant could potentially recover an amount up to the limit of the coverage purchased. The total all claimants could recover for a single occurrence to which the statutory tort limits apply would also be limited to the amount of coverage purchased,regardless of the number of claimants. Claims to which the statutory municipal tort limits do not apply are not affected by this decision. LEAGUE OF MINNESOTA CITIES 145 University Avenue West PFI: (651) 281-1200 17X: (651)281-1298 INSURANCE TRUST St.Paul, Minnesota 55103 'r r: (800)925-1122 www.11nc.org 1 i I i f i i LMC1T Member Name: Check one: The member DOES NOT WAIVE the monetary limits on municipal tort liability established by Minn. Stat. , 4$ 66,04. ❑The member WAIVES the monetary limits on municipal tort liability established by Minn. Stat, 466.04,to the extent of the limits of the liability coverage obtained from LMCIT. Date of memb -'s governin body meeting: November 7,2022 Signature: Position: Finance Director i 2 CITY OF O 430 Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Chris Regis, Finance Director SUBJECT: Approve Bills- Finance DATE: November 7, 2022 INTRODUCTION Attached is the October 12, 2022—October 31, 2022 city council check register and recently processed automatic payments for your review. DISCUSSION N/A BUDGET IMPACT N/A ACTION REQUESTED Approve the attached payments. ATTACHMENTS: Type Description D Backup Material Council Check Summary R55CKS2 LOGIS600V COUNCIL MEETING NOV 7, 2022 CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 1 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 101163 10/14/2022 103861 ALEX AIR APPARATUS INC 1,076.71 FIRE ST 1 AIR BOTTLE FILL MAIN 206862 5932 1060 6505 EQUIPMENT REPAIR/MAINTENANCE FIRE SERVICES 01000 06 955.84 FIRE ST2AIR BOTTLE FILL MAIN 206863 5933 1060 6505 EQUIPMENT REPAIR/MAINTENANCE FIRE SERVICES 01000 06 2,032.55 101164 10/14/2022 100493 BELLBOY CORPORATION 219.74 LIQUOR SUPPLIES&MIXES ORDER 207128 0105853100 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 190.95 BAG ORDER 207128 0105853100 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 250.65 LIQUOR&SPIRTS ORDER 207129 0096845200 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,986.71 LIQUOR&SPIRTS ORDER 207162 0096842900 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 174.90 LIQUOR SUPPLIES&MIXES ORDER 207166 0105851700 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,822.95 101165 10/14/2022 109603 BIFFS,INC 160.00 SEPT'22 PRTBLE RNTL-EVRGRN K 207244 #W887008 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 SEPT'22 PRTBLE RNTL-FARM PRS 207245 #W887007 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 SEPT'22 PRTBLE RNTL-HILL DEE 207246 #W886999 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 SEPT'22 PRTBLE RNTL-MDWVW PR 207247 #W887006 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 640.00 101166 10/14/2022 117735 CLEAR RIVER BEVERAGE 274.00 BEER ORDER 207114 654241 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 216.75 BEER ORDER 207146 654306 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 76.46- BEER ORDER CREDIT 207186 654392 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 414.29 101167 10/14/2022 100071 COLLEGE CITY BEVERAGE INC 10,368.00 BEER ORDER 207117 840228 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 802.00 BEER ORDER 207118 840364 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 988.00 BEER ORDER 207119 836535 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 20.80- BEER ORDER CREDIT 207122 840352 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,987.40 BEER ORDER 207142 840353 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 746.30 BEER ORDER 207147 840227 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 135.00 WINE ORDER 207148 840033 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 18.10- BEER ORDER CREDIT 207178 1682-00075 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12,159.10 BEER ORDER 207209 838092 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 31,146.90 101168 10/14/2022 107747 M.AMUNDSON LLP 1,019.10 CIGARETTES&POP ORDER 207130 350027 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,019.10 101169 10/14/2022 115396 MACQUEEN EMERGENCY GROUP 84.55 MAINTENANCE TO ENG 11 206873 P07706 1060 6510 1 OUTSIDE VEHICLE REPAIR/MAINT FIRE SERVICES 01000 06 84.55 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 2 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 101170 10/14/2022 100070 MINNESOTA VALLEY TESTING LABORATORIES 95.02 BAC-T SAMPLE 206508 1164272 6502 6535 OTHER REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 95.02 101171 10/14/2022 117742 STANDARD SPRING PARTS 2,280.38 FRONT SPRINGS FOR D705 207217 395163 1072 6230 VEHICLE SUPPLIES&PARTS STREET MAINTENANCE 01000 08 2,280.38 101172 10/14/2022 100235 STERLING CODIFIERS INC 190.00 ORD#022-767 UPDATE 207259 19800 1010 6401 PROFESSIONAL SERVICES ADMINISTRATION 01000 01 190.00 101173 10/14/2022 114206 SUN LIFE FINANCIAL 3,785.58 OCT'22 LIFE INSURANCE 206972 237780 OCT'22 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 3,785.58 101174 10/14/2022 108670 TERMINAL SUPPLY COMPANY 541.55 WIRE NUTS BOLTS SUPPLIES 206950 74815-00 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 541.55 101175 10/14/2022 112567 ULTIMATE SAFETY CONCEPTS,INC 2,627.66 GAS METER SENSORS 206976 202060 1060 6220 EQUIP SUPPLIES&PARTS FIRE SERVICES 01000 06 2,627.66 101176 10/14/2022 108808 VINOCOPIA,INC 1,341.62 WINE ORDER 207127 0314106-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,341.62 101177 10/21/2022 102087 AUTOMATIC SYSTEMS COMPANY 2,830.00 WELL 9 VENTILATION INSTALL 206963 37882 S 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 2,339.75 SCADA MAINTENANCE 206964 37877S 6502 6505 EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 5,169.75 101178 10/21/2022 100493 BELLBOY CORPORATION 932.76 LIQUOR&SPIRITS ORDER 207279 0096944300 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 149.27 LIQUOR SUPPLIES&MIXES ORDER 207284 0105888100 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 43.75- BAG ORDER CREDIT 207298 0105853300 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 222.09 LIQUOR SUPPLIES&MIXES ORDER 207304 0105890100 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 553.20 LIQUOR&SPIRITS ORDER 207308 0096948200 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,813.57 101179 10/21/2022 109503 BIFFS,INC 160.00 SEPT'22 PRTBLE RNTL-DAISY KN 207372 #W886997 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 SEPT'22 PRTBLE RNTL-TMRCK PR 207373 #W887002 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 300.00 SEPT'22 PRTBLE RNTL-FEELY FLDS 207374 #W887005 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 SEPT'22 PRTBLE RNTL-PRRVW PRK 207375 #W887003 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 SEPT'22 PRTBLE RNTL-LK JULIA 207376 #W887000 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 3 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 160.00 SEPT'22 PRTBLE RNTL-JIM BELL P 207377 #W887010 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 SEPT'22 PRTBLE RNTL-DISTAD PRK 207378 #W887009 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 SEPT'22 PRTBLE RNTL-DKTA EST P 207379 #W886998 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 160.00 SEPT'22 PRTBLE RNTL-PINE KNLL 207380 #W887001 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 311.00 SEPT'22 PRTBLE RNTL-RRP 207381 #W887004 1090 6555 RENTAL OF EQUIPMENT PARK MAINTENANCE 01000 09 1,891.00 101180 10/21/2022 118704 BLUE CLOUD DISTRIBUTION OF MINNESOTA INC 15.96- SALES TAX CREDIT 207172 99-1 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 111.11- SALES TAX CREDIT 207180 99-2 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 560.00 LIQUOR&SPIRITS ORDER 207313 100960197 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 432.93 101181 10/21/2022 103089 BOUND TREE MEDICAL LLC 259.75 MEDICAL SUPPLIES 206858 84697998 1060 6250 OTHER SUPPLIES&PARTS FIRE SERVICES 01000 06 259.75 101182 10/21/2022 117735 CLEAR RIVER BEVERAGE 35.00- BEER ORDER CREDIT 207312 655419 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,228.95 BEER ORDER 207319 655313 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,193.95 101183 10/21/2022 100071 COLLEGE CITY BEVERAGE INC 135.00 WINE ORDER 207276 841701 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 111.40 BEER ORDER 207287 842526 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 8,212.50 BEER ORDER 207296 842527 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 061DO 02 106.71- BEER ORDER CREDIT 207297 842555 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 490.20 BEER ORDER 207314 842483 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 13,340.35 BEER ORDER 207316 842523 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 180.00 LIQUOR&SPIRITS ORDER 207320 842999 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 22,362.74 101184 10/21/2022 109182 DAKOTA 911 6,092.67 NOV 2022 DCC FEES 207218 FA2022-11 1060 6560 CONTRACTUAL SERVICES FIRE SERVICES 01000 06 12,185.33 NOV 2022 DCC FEES 207218 FA2022-11 1050 6560 CONTRACTUAL SERVICES POLICE ADMINISTRATION 01000 05 18,278.00 101185 10/21/2022 100717 FARMERS MILL&ELEVATOR INC 401.51 PESTICIDE 207368 M3143729 1072 6255 LANDSCAPING MATERIALS STREET MAINTENANCE 01000 08 401.51 PESTICIDE 207369 R7000478 1072 6255 LANDSCAPING MATERIALS STREET MAINTENANCE 01000 08 803.02 101186 10/21/2022 109768 IMAGE TREND,INC 358.21 SOFTWARE ANNUAL FEE 206868 137966 1060 6505 EQUIPMENT REPAIR/MAINTENANCE FIRE SERVICES 01000 06 358.21 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 4 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 101187 10/21/2022 117341 INBOUND BREWCO 218.00 BEER ORDER 207334 14729 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 218.00 101188 10/21/2022 110525 IN-SITU INC 100.00 OCT'22 CELL SVS:WTR LVS SFTWR 207393 HV11039 6502 6505 EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 100.00 101189 10/21/2022 113199 LUBE-TECH&PARTNERS,LLC 1,907.14 STOCK GEAR OIL 206953 3029234 7200 6274 LUBRICANTS&ADDITIVES FLEET OPERATIONS 07200 08 1,907.14 101190 10/21/2022 111268 LUTZ,CHRISTOPHER 47.31 OCT'22 FUEL REIMB 207402 20221006 LUTZ 1051 6272 FUEL PATROL SERVICES 01000 05 41.35 OCT'22 MEAL REIMB 207402 20221006 LUTZ 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 88.66 101191 10/21/2022 100070 MINNESOTA VALLEY TESTING LABORATORIES 95.02 BAC-T SAMPLE(7) 206808 1165411 6502 6535 OTHER REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 95.02 101192 10/21/2022 102644 NORTHERN SAFETY TECHNOLOGY,INC 175.00 BEACON FOR 0932 206806 54564 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 175.00 101193 10/21/2022 113031 NRG RELIABILITY SOLUTIONS LLC 1,831.03 SEPT-22 ELEC LAW ENFORCE CNTR 207228 3346-2210 1050 6422 ELECTRIC POLICE ADMINISTRATION 01000 05 1,460.49 SEPT'22 ELEC CMF 207388 3347-2210 6502 6422 ELECTRIC WATER UTILITY EXPENSE 06500 08 40.57 SEPT'22 ELEC CMF 207388 3347-2210 6402 6422 ELECTRIC STORM WATER UTILITY OPERA 06400 08 60.85 SEPT'22 ELEC CMF 207388 3347-2210 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 106.29 SEPT'22 ELEC CMF 207388 3347-2210 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 40.57 SEPT'22 ELEC CMF 207388 3347-2210 1072 6422 ELECTRIC STREET MAINTENANCE 01000 08 3,539.80 101194 10/21/2022 102247 SUNDGREN,MARK 24.17 OCT'22 MEAL REIMB-BCKGRND INVS 207401 20221012 SUNDGREN1052 6470 TRAINING&SUBSISTANCE INVESTIGATION SERVICES 01000 05 24.17 101195 10/21/2022 108670 TERMINAL SUPPLY COMPANY 59.32 WHEEL FOR GRINDER 207022 77612-00 7200 6220 EQUIP SUPPLIES&PARTS FLEET OPERATIONS 07200 OB 59.32 101196 10/21/2022 110954 ULINE SHIPPING&SUPPLY SPECIALISTS,INC 417.28 INVESTIGATIONS SUPPLIES 206984 154325871 1052 6250 OTHER SUPPLIES&PARTS INVESTIGATION SERVICES 01000 05 417.28 101197 10/21/2022 109258 VAN DORN,ANDREW 16.22 OCT'22 MEAL REIMB-SWAT TRNG 207399 20221007 VAN DORN 1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 5 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 29.62 OCT'22 FUEL REIMB-SWAT TRNG 207399 20221007 VAN DORN 1051 6272 FUEL PATROL SERVICES 01000 05 45.84 101198 10/2112022 108808 VINOCOPIA,INC 631.00 WINE ORDER 207292 0314575-IN 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 730.50 WINE ORDER 207307 0314481-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,361.50 101199 10/21/2022 102592 WINE COMPANY,THE 250.00 WINE ORDER 207310 217488 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 250.00 101200 10/28/2022 100493 BELLBOY CORPORATION 149.80 LIQUOR SUPPLIES&MIXES ORDER 207532 0105917200 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 88.75 BAG ORDER 207532 0105917200 6110 6250 OTHER SUPPLIES&PARTS DOWNTOWN LIQUOR REV&EXP 06100 02 977.16 LIQUOR&SPIRITS ORDER 207533 0097037400 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 727.65 LIQUOR&SPIRITS ORDER 207539 0097036200 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 268.60 BAG ORDER 207545 0105916900 6115 6250 OTHER SUPPLIES&PARTS PILOT KNOB LIQUOR 06100 02 111.43 LIQUOR SUPPLIES&MIXES ORDER 207545 0105916900 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,323.39 101201 10/28/2022 100253 CAMPBELL KNUTSON,P.A. 1,762.80 SEP722 LEGAL FEES-GENERAL/RET 207048 1852-000OG SEP'22 1005 6403 LEGAL LEGISLATIVE CONTROL 01000 01 225.70 SEP722 LEGAL FEES-GENERAURET 207048 1852-000OG SEP'22 1010 6403 LEGAL ADMINISTRATION 01000 01 232.50 SEPT'22 LEGAL FEES-GENERAURET 207048 1852-000OG SEP'22 1011 6403 LEGAL HUMAN RESOURCES 01000 04 70.80 SEPT'22 LEGAL FEES-GENERAURET 207048 1852-000OG SEP'22 1021 6403 LEGAL FINANCE 01000 02 203.60 SEPT'22 LEGAL FEES-GENERAL/RET 207048 1852-000OG SEP'22 1060 6403 LEGAL FIRE SERVICES 01000 06 166.00 SEPT'22 LEGAL FEES-GENERAL/RET 207048 1852-000OG SEP'22 1070 6403 LEGAL ENGINEERING SERVICES 01000 07 356.30 SEPT'22 LEGAL FEES-GENERAL/RET 207048 1852-000OG SEP'22 1094 6403 LEGAL PARK&RECREATION ADMIN 01000 09 98.00 SEPT 2022 LEGAL FORFEITURES 207266 1852-0003G SEP'22 2100 6403 LEGAL POLICE FORFEITURES 02100 05 993.50 SEPTEMBER 2022 LEGAL GENERAL 207267 1852-0004G SEP'22 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 5,239.20 SEPTEMBER 2022 LEGAL PROSECUTI 207268 1852-0999G SEP'22 1050 6403 LEGAL POLICE ADMINISTRATION 01000 05 9,348.40 101202 10/28/2022 107371 CERTIFIED RECYCLING 1,770.00 MATTRESS/BOX SPRING RECYCLING 207460 70637 6302 6401 PROFESSIONAL SERVICES SOLID WASTE OPERATIONS 06300 08 1,770.00 101203 10/28/2022 117735 CLEAR RIVER BEVERAGE 200.00 BEER ORDER 207531 656451 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 200.00 101204 10/28/2022 100071 COLLEGE CITY BEVERAGE INC 44.83- BEER ORDER CREDIT 207558 844569 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 9,021.55 BEER ORDER 207559 844570 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 21.70- BEER ORDER CREDIT 207563 1695-00089 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 6 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 2.47- BEER ORDER CREDIT 207566 1695-00090 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 215.40 BEER ORDER 207569 844700 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 104.54- BEER ORDER CREDIT 207570 844711 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 7,931.90 BEER ORDER 207587 844701 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2.45- BEER ORDER CREDIT 207588 844710 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 16,992.86 101205 10/28/2022 100717 FARMERS MILL&ELEVATOR INC 473.68 GRASS SEED 207476 R1113158 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 2,343.52 PESTICIDE 207524 W7000470 1090 6260 CHEMICALS PARK MAINTENANCE 01000 09 2,817.20 101206 10/28/2022 118179 FARMINGTON MALL LLC 6,678.50 NOV-22 RENT DT LIQUOR STORE 207502 20221101 DT LIQ 6110 6556 BUILDING RENTAL DOWNTOWN LIQUOR REV&EXP 06100 02 6,678.50 101207 10/28/2022 100049 LOCAL GOVERNMENT INFORMATION SYSTEMS 2,634.00 OCT'22 APPL SUPPORT INV 207624 52725 7400 6402 DATA PROCESSING INFORMATION TECHNOLOGY 07400 04 1,379.00 OCT-22 APPL SUPPORT INV 207624 52725 6502 6402 DATA PROCESSING WATER UTILITY EXPENSE 06500 08 1,379.00 OCT-22 APPL SUPPORT INV 207624 52725 6402 6402 DATA PROCESSING STORM WATER UTILITY OPERA 06400 08 1,379.00 OCT-22 APPL SUPPORT INV 207624 52725 6202 6402 DATA PROCESSING SEWER OPERATIONS EXPENSE 06200 08 3,528.00 OCT'22 APPL SUPPORT INV 207624 52725 1031 6402 DATA PROCESSING BUILDING INSPECTIONS 01000 07 397.00 OCT'22 APPL SUPPORT INV 207624 52725 1060 6402 DATA PROCESSING FIRE SERVICES 01000 06 2,492.00 OCT'22 APPL SUPPORT INV 207624 52725 1050 6402 DATA PROCESSING POLICE ADMINISTRATION 01000 05 2,608.00 OCT'22 APPL SUPPORT INV 207624 52725 1011 6402 DATA PROCESSING HUMAN RESOURCES 01000 04 4,970.00 OCT-22 APPL SUPPORT INV 207624 52725 1021 6402 DATA PROCESSING FINANCE 01000 02 20,766.00 101208 10/28/2022 107747 M.AMUNDSON LLP 1,040.54 CIGARETTES&POP ORDER 207546 350807 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,040.54 101209 10/28/2022 102796 MARTIN-MCALLISTER 1,300.00 PERSONNEL EVALUATION 206983 14878 1011 6405 EMPLOYMENT TESTING HUMAN RESOURCES 01000 04 1,300.00 101210 10/28/2022 102644 NORTHERN SAFETY TECHNOLOGY,INC 382.79 SQD 24 EQUIPMENT 207220 54601 5602 6940 50 VEHICLES-POLICE GEN CAPITAL EQUIP FUND EX 05600 496.65 SQD 24 EQUIPMENT 207221 54602 5602 6940 50 VEHICLES-POLICE GEN CAPITAL EQUIP FUND EX 05600 2,701.00 SQD 24 EQUIPMENT 207222 54594 5602 6940 50 VEHICLES-POLICE GEN CAPITAL EQUIP FUND EX 05600 77.35 SQD 24 EQUIPMENT 207223 54599 5602 6940 50 VEHICLES-POLICE GEN CAPITAL EQUIP FUND EX 05600 3,657.79 101211 10/28/2022 100125 R&R SPECIALTIES OF WISCONSIN INC 82.50 ZAMBONI BLADE SHARPEN 207387 0076872-IN 2502 6505 EQUIPMENT REPAIR/MAINTENANCE ICE ARENA OPERATIONS EXPE 02500 09 82.50 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 7 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div 101212 10/28/2022 107946 SCHWINESS,LLC 10,071.10 LEASE PAYMENT 207503 2921 6115 6556 BUILDING RENTAL PILOT KNOB LIQUOR 06100 02 10,071.10 101213 10/28/2022 108808 VINOCOPIA,INC 316.25 WINE ORDER 207541 0314947-IN 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 316.25 101214 10/28/2022 111267 WATER CONSERVATION SERVICE,INC 382.50 EAVES WAY/CT LEAK DETECTION 207579 12660 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 382.50 101216 10/28/2022 100389 WOLD ARCHITECTS&ENGINEERS INC 1,715.00 PD SPACE NEEDS STUDY 207229 81943 7600 6401 27004 PROFESSIONAL SERVICES FEDERALAID-COVID19 07600 02 1,715.00 101216 10/28/2022 108460 WSB&ASSOCIATES INC 7,910.00 AUG'22 CODE ENFORCEMENT SERVIC 206987 R-019521-000-8 1030 6401 PROFESSIONAL SERVICES PLANNING&ZONING 01000 03 1,156.00 VRWJPO DRAINAGE STUDY 207339 R-018756-000-10 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 1,774.00 POND MAINT DESIGN 207340 R-019577-000-6 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 1,037.71 MS4 PERMIT IMPLEMENTATION 207341 R-020038-000-6 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 11,877.71 168738 10/14/2022 119046 LENDSERV-ELK RIVER 426.37 REF UTIL CR@18146 ELYAVE 207047 LSN63833 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 426.37 168739 10/14/2022 100068 ADVANCE AUTO PARTS 10.00- BATTERY CORE RETURN FOR 0931 207023 2131-602158 CR 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 18.90 HYDRAULIC FITTING FOR 0705 207025 2131-602599 1072 623D VEHICLE SUPPLIES&PARTS STREET MAINTENANCE 01000 08 114.30 FLOOR DRY FOR SHOP 207026 2131-601996 7200 6242 CLEANING SUPPLIES FLEET OPERATIONS 07200 08 47.02 WIPER BLADESAND BULB FOR 0918 207028 2131-602857 1090 6230 VEHICLE SUPPLIES&PARTS PARK MAINTENANCE 01000 09 170.22 168740 10/14/2022 114662 ALL AMERICAN TITLE CO,INC 200.77 REF UTIL CR@18045 EMPIRE TRL 207016 123279-22-08 R/56 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 200.77 168741 10/14/2022 119036 ALTEMP MECHANICAL INC 62.40 ICE MACHINE REPAIR 207231 258150 6502 6505 EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 89.14 ICE MACHINE REPAIR 207231 258150 6402 6505 EQUIPMENT REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 44.57 ICE MACHINE REPAIR 2D7231 258150 6202 6505 EQUIPMENT REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 71.31 ICE MACHINE REPAIR 207231 258150 1090 6505 EQUIPMENT REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 44.58 ICE MACHINE REPAIR 207231 258150 1072 6505 EQUIPMENT REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 312.00 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 8 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 158742 10/14/2022 109681 AMUNDSON,JASON 14.82 SEP'22 MEAL REIMB 207043 20220927 AMUNDSON1051 6470 TRAINING&SUBSISTANCE PATROL SERVICES 01000 05 14.82 158743 10/14/2022 110959 ANCONA TITLE&ESCROW 10.16 REF UTILCR@19858 DEERBROOKE PA 207202 2022-214103 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 10.16 158744 10/14/2022 113303 ARTISAN BEER COMPANY 215.20 BEER ORDER 207100 3556825 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 913.85 BEER ORDER 207137 3563804 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 277.00 BEER ORDER 207145 3563869 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,406.05 158745 10/14/2022 108446 ASPEN MILLS,INC. 261.45 UNIFORM FOR HUNSINGER 206866 301106 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 149.99 UNIFORM ALLOWANCE LARKIN 206977 301305 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 411.44 158746 10/14/2022 117935 AT HOME TITLE 228.07 REF UTIL CR@5550 EUCLID WAY 207012 MN-60194 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 228.07 158747 10/14/2022 110262 BAAR,SONDRA 115.86 SEP'22 MILEAGE REIMB 207044 20220927 BAAR 1050 6485 MILEAGE REIMBURSEMENT POLICE ADMINISTRATION 01D00 05 15.21 SEP'22 MEAL REIMB 207044 20220927 BAAR 1050 6470 TRAINING&SUBSISTANCE POLICE ADMINISTRATION 01000 05 131.07 158748 10/14/2022 100112 BADGER METER INC 426.24 SEPT'22 BEACON MBL HOSTING SER 206959 80109275 6502 6505 EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 426.24 158749 10/14/2022 114075 BLACKFIRE CREATIVE DESIGNS 660.00 SQD 24 WINDOW TINTING 207224 6327 5602 6940 50 VEHICLES-POLICE GEN CAPITAL EQUIP FUND EX 05600 660.00 158750 10/14/2022 114472 BREAKTHRU BEVERAGE MN BEER,LLC 117.50 BEER ORDER 207110 345938973 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 44.80 BEER ORDER 207116 345839338 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 145.00 BEER ORDER 207163 345932313 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 11B.60 BEER ORDER 207164 345932770 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 9,960.75 BEER ORDER 207176 345839337 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 18,635.40 BEER ORDER 207183 345938972 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 9,849.15 BEER ORDER 207185 345932769 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 38,871.20 168761 10/14/2022 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 9 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 496.20 WINE ORDER 207104 345932494 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 528.94 LIQUOR&SPIRTS ORDER 207105 345837063 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 632.70 WINE ORDER 207107 345932493 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 338.90 WINE ORDER 207169 345933350 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 4,581.68 LIQUOR&SPIRTS ORDER 207181 345933351 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 5,742.43 LIQUOR&SPIRTS ORDER 207182 345932492 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12,320.85 158752 10/14/2022 110218 BURNET TITLE 239.19 REF UTIL CR@1084 PINE ST 207000 2111022-06626 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 30.10 REF UTIL CR@4787 220TH ST W 207008 2111022-08500 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 129.02 REF UTIL CR@18223 EMPIRE TRL 207019 2121022-07485 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 130.97 REF UTIL CR@18539 EGRET WAY 207188 2164022-06639 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 103.50 REF UTIL CR@19615 EVENSONG AVE 207198 2131022-08343 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 93.97 REF UTIL CR@20528 CYPRESS DR 207203 2111022-08668 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 726.75 158753 10/14/2022 100025 CINTAS CORP LOC 754 154.48 FIRSTAID SUPPLIES 207252 5125257757 2502 6250 OTHER SUPPLIES&PARTS ICE ARENA OPERATIONS EXPE 02500 09 154.48 158754 10/14/2022 117504 CLEAR TITLE LLC 46.77 REF UTILCR@19848 DEERBROOKE PA 207200 2022-07-2233 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 46.77 158755 10/14/2022 118419 CLOSING HUB 70.75 REF UTIL CR@19740 EVERHILLAV 207199 22-0967/117 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 70.75 158756 10/14/2022 117505 COMMUNITY TITLE&ESCROW LLC 205.40 REF UTIL CR@19164 EVENING STAR 207193 22141543 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 205.40 158757 10/14/2022 100030 CORE&MAIN,LP 141.55 VALVE BOX RISERS 206822 R620412 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 141.55 158758 10/14/2022 110844 DAKOTA COUNTY FINANCIAL SRVS 83.91 AUG'22 DIESEL FUEL 206955 00045233 1090 6272 FUEL PARK MAINTENANCE 01000 09 30.56 AUG'22 DIESEL FUEL 206955 00045233 1072 6272 FUEL STREET MAINTENANCE 01000 08 55.75 AUG'22 DIESEL FUEL 206955 00045233 6202 6272 FUEL SEWER OPERATIONS EXPENSE 06200 08 1,642.93 AUG'22 DIESEL FUEL 206955 00045233 1060 6272 FUEL FIRE SERVICES 01000 06 105.05 AUG'22 DIESEL FUEL 206955 00045233 1076 6272 FUEL NATURAL RESOURCES 01000 07 1,918.20 168769 10/14/2022 108012 DAKOTA COUNTY REGIONAL CHAMBER COMMERCE R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 10 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 2,500.00 2023 MEMBERSHIP DUES 206988 73791 2000 1505 PREPAID EXPENSES HRA/ECONOMIC DEVELOPMENT 02000 03 2,500.00 158760 10/14/2022 119047 DESIGN TREE ENGINEERING INC 3,437.50 CITY HALL BOILER REPLACEMENT 207096 22565 7600 6401 27001 PROFESSIONAL SERVICES FEDERALAID-COVID19 07600 02 3,437.50 158761 10/14/2022 115062 DISTINCTIVE DESIGN BUILD,LLC 3,000.00 ER 1485 SPRUCE ST 207261 ER 1485 SPRUCE ST 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 3,000.00 168762 10/14/2022 115736 DRIVER AND VEHICLE SERVICES 45.00 F#T0502'23 FR CARGO TRLR 206986 F#T0502'23 1051 6950 27009 MACHINERY,EQUIPMENT&TOOLS PATROL SERVICES 01000 05 POLICE TRLR 45.00 158763 10/14/2022 115815 EDGEWATER TITLE GROUP,LLC 271.19 REF UTIL CR@512 11TH ST 206994 22-85323 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 156.62 REF UTIL CR@18468 ELDORADO WY 207187 22-85419 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 44.75 REF UTIL CR@18890 ELGIN AVE 207191 36393 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 472.56 158764 10/14/2022 113296 EDINA REALTY TITLE 58.30 REF UTIL CR@1009 WALNUT ST 206999 2169520 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 80.82 REF UTIL CR@1348 WILLOW TRL 207004 21726831101 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 182.51 REF UTIL CR@5174 UPR 183 ST W 207009 2171841/84 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 67.21 REF UTIL CR@18794 EASTON CT 207189 2172367/101 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 169.24 REF UTIL CR@19438 EVEREST PA 207197 2163346/296 6200 131D 3 REFUND CIS SEWER OPERATIONS 06200 08 558.08 158765 10/14/2022 113096 ETERNITY HOMES,LLC 3,000.00 ER 2821-213TH ST W 207262 ER 2821-213TH ST 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 W 3,000.00 ER 2730-213TH ST W 207263 ER 2730-213TH ST 4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 W 6,000.00 158766 10/14/2022 109931 FACTORY MOTOR PARTS 57.86 STOCK FILTERS 206649 75-450595 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 7.04 STOCK FILTERS 206650 1-7997634 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 22.00- CORE RETURN CREDIT 206804 1-Z30461 CR 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 42.90 158767 10/14/2022 114630 FARMINGTON ISD#192 FACILITIES 78.00 GYM RENTAL FOR TENNIS LESSONS 206967 2022 SEP-OCT'22 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 TENNIS R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 11 10/12/2022- 1013112022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 78.00 158768 10/14/2022 100223 FEDEX 67.48 SHIPPING: WATER SAMPLES 206966 7-896-99668 6502 6445 POSTAGE/SHIPPING FEES WATER UTILITY EXPENSE 06500 08 67.48 158769 10/14/2022 109294 FIRST AMERICAN TITLE 621.39 REF UTIL CR@5578 UPR 182 ST W 207013 1622881 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 621.39 158770 10/14/2022 110176 FIRST FINANCIAL TITLE 103.90 REF UTIL CR@23 WALNUT ST 206991 22-45451/22 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 103.90 158771 10/14/2022 118479 FLAHERTY&HOOD,P.A. 895.00 HR LEGAL CONSULTING FEES 207206 221010 1011 6403 LEGAL HUMAN RESOURCES 01000 04 895.00 158772 1011412022 119045 FLEX TITLE COMPANY LLC 269.77 REF UTIL CR@721 5TH ST 207014 2208-0382/56 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 230.08 REF UTIL CR@30 PINE PL 207015 2208-0367/47 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 499.85 158773 10/14/2022 111456 GLOBAL CLOSING&TITLE SERVICES 429.81 REF UTIL CR@18050 EMERALD TL 207018 MN-07-220932 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 29.06 REF UTIL CR@708 HERITAGE WAY 207046 MN-06-220828 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 458.87 158774 10/14/2022 102071 GOODYEAR TIRE&RUBBER COMPANY,THE 409.16 TIRES FOR 0305 206651 124-1105998 7200 6232 VEHICLE/EQUIPMENT TIRES FLEET OPERATIONS 07200 08 1,243.20 SQUAD TIRES 206800 124-1106052 1051 6232 VEHICLE/EQUIPMENT TIRES PATROLSERVICES 01000 05 1,652.36 158775 10/14/2022 102072 GOPHER 225.00 T-BALL 24 BALLS 206664 IN220217 1095 6570 PROGRAMMING EXPENSE RECREATION PROGRAM SERVIC 01000 09 225.00 158776 10/14/2022 103373 GRAYBAR ELECTRIC CO INC 2,759.64 STREET LIGHT POLE 206916 9328820092 6602 6220 EQUIP SUPPLIES&PARTS STREETLIGHT UTILITY EXPEN 06600 08 2,759.64 158777 10/14/2022 100027 GREAT LAKES COCA-COLA DISTRIBUTION,LLC 655.09 POP ORDER 207131 3608217705 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 655.09 158778 10/14/2022 100007 HAWKINS INC 336.42 CHLOURINE PIPE SUPPLIES 206511 6292505 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 16,004.13 WELL CHEMICALS 206798 6293703 6502 6260 CHEMICALS WATER UTILITY EXPENSE 06500 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 12 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 16,340.55 158779 10/14/2022 108140 HEDLUND IRRIGATION&LANDSCAPING INC 185.60 IRRIGATION REPAIR 207250 6854A 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 265.14 IRRIGATION REPAIR 207250 6854A 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 132.57 IRRIGATION REPAIR 207250 6854A 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 212.11 IRRIGATION REPAIR 207250 6854A 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 132.58 IRRIGATION REPAIR 207250 6854A 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 928.00 158780 10/14/2022 100074 HOHENSTEINS INC 237.00 BEER ORDER 207112 546288 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,080.20 BEER ORDER 207120 546295 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 527.40 BEER ORDER 207144 548030 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,844.60 158781 10/14/2022 115145 INTRADO INTERACTIVE SERVICES CORPORATION 3,000.00 '22 WEBSITE ANNUAL MAINT 207260 304814 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 3,000.00 158782 10/14/2022 100033 JOHNSON BROTHERS LIQUOR COMPANY 15.51 LIQUOR&SPIRTS ORDER 207101 2145645 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 14.00- WINE ORDER CREDIT 207102 222316 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 17.00- DELIVERY CHARGE CREDIT 207103 218574 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 27.20- DELIVERY CHARGE CREDIT 207106 218575 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 424.30- LIQUOR&SPIRTS ORDER CREDIT 207108 220497 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 11.90- DELIVERY CHARGE CREDIT 207109 218573 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 8.67- WINE ORDER CREDIT 207111 222315 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 10.20- DELIVERY ORDER CREDIT 207113 218576 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 20.40- DELIVERY CHARGE CREDIT 207123 218582 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 66.30- DELIVERY CHARGE CREDIT 207124 218584 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 56.10- DELIVERY CHARGE CREDIT 207125 216583 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 108.00 LIQUOR&SPIRTS ORDER 207126 2145542 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,420.70 WINE ORDER 207132 2150336 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,848.87 LIQUOR&SPIRTS ORDER 207138 2150335 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,089.86 LIQUOR&SPIRTS ORDER 207139 2150333 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,018.34 WINE ORDER 207140 2150334 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,777.30 LIQUOR&SPIRTS ORDER 207141 2150332 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 48.20 WINE ORDER 207151 2150508 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 288.86 WINE ORDER 207152 2150510 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,599.91 LIQUOR&SPIRTS ORDER 207154 2150509 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 833.64 WINE ORDER 207155 2150512 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 930.00 WINE ORDER 207157 2150331 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 207.73 LIQUOR&SPIRTS ORDER 207158 2150507 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 13 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 30.58 DELIVERY CHARGE 207160 2127537 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 138.00 LIQUOR&SPIRTS ORDER 207161 2145543 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 730.50 LIQUOR&SPIRTS ORDER 207165 2152656 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 863.45 LIQUOR&SPIRTS ORDER 207168 2150511 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 934.72 WINE ORDER 207170 2150338 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 51.20 LIQUOR&SPIRTS ORDER 207173 2150337 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 8.33- WINE ORDER CREDIT 207177 222566 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 7.50- LIQUOR&SPIRTS ORDER CREDI 207179 220499 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 16,263.47 158783 10/14/2022 114167 JONES&BARTLETT LEARNING,LLC 583.63 TRAINING BOOKS 207195 575814 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 583.63 158784 10/14/2022 110501 LAND TITLE INC 125.48 REF UTIL CR@504 5TH ST 206993 664480 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 125.48 158785 10/14/2022 117763 LEGACY TITLE 133.40 REF UTIL CR@1100 WALNUT ST 207001 MN 31974/102 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 133.40 158786 10/14/2022 115466 LIFE INSURANCE COMPANY OF NORTH AMERICA 157.31 OCT'22 Cl INSURANCE 206971 C1960343 OCT'22 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 157.31 158787 10/14/2022 100375 MINNESOTA DEPT OF PUBLIC SAFETY 100.00 MN DPS TIER 2 EPCRA FEE 207213 1904000192021 6502 6460 MEMBER DUES&LICENSURE WATER UTILITY EXPENSE 06500 08 M-126648 100.00 158788 10/14/2022 100153 MINNESOTA STATE FIRE CHIEFS ASSOCIATION 325.00 ANNUAL CONF REG:ELVESTAD,J. 206979 4649 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 400.00 ANNUAL CONF REG:MATTINGLY,S 206980 4652 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 325.00 ANNUAL CONF REG:SCHMITZ,J 206981 4651 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 325.00 ANNUAL CONF REG:ALLBEE,J 207192 4658 1060 6470 TRAINING&SUBSISTANCE FIRE SERVICES 01000 06 1,375.00 158789 10/14/2022 118563 MINNESOTA TITLE 247.23 REF UTIL CR@19851 DAWSON LN 207201 MT-2208-1010-AV/73 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 247.23 158790 10/14/2022 118612 MN BUREAU OF CRIMINAL APPREHENSION 1,080.00 BCACJDN FEES 207219 00000718106 1050 6411 TELEPHONE/CABLE SERVICES POLICE ADMINISTRATION 01000 05 1,080.00 158791 10/14/2022 100443 NELCOM CORPORATION R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 14 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 402.30 CIVIL DEFENSE SIREN REPAIR 206654 30582 1054 6505 EQUIPMENT REPAIR/MAINTENANCE EMERGENCY MGMT SERVICES 01000 05 247.50 CIVIL DEFENSE SIREN REPAIR 206655 30580 1054 6505 EQUIPMENT REPAIR/MAINTENANCE EMERGENCY MGMT SERVICES 01000 05 649.80 158792 10/14/2022 112501 NEW FRANCE WINE COMPANY,INC 607.16 WINE ORDER 207174 193666 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 607.16 158793 10/14/2022 117866 NORTHSTAR TITLE GROUP,LLC 122.44 REF UTIL CR@416 WALNUT ST 206992 22-988 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 122.44 158794 10/14/2022 112901 ON SITE TITLE LLC 27.02 REF UTIL CR@620 MAIN ST 206996 22-538 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 OB 27.02 158795 10/14/2022 101264 ORKIN EXTERMINATING,LLC 116.00 SEPT'22 PEST CNTRL-5446 195TH 206823 231168702 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 16.00 SEPT'22 PEST CONTROL-1 ST ST 206849 231170619 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 22.86 SEPT'22 PEST CONTROL-IST ST 206849 231170619 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 11.43 SEPT'22 PEST CONTROL-1ST ST 206849 231170619 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 18.29 SEPT'22 PEST CONTROL-1ST ST 206849 231170619 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 11.42 SEPT'22 PEST CONTROL-1ST ST 206849 231170619 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 196.00 158796 10/14/2022 116731 PARTNERS TITLE 227.21 REF UTIL CR@18878 DYLAN DR 207190 MN67117 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 227.21 158797 10/14/2022 100290 PAUSTIS&SONS WINE COMPANY 881.50 WINE ORDER 207121 179734 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 389.50 WINE ORDER 207167 179577 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,271.00 158798 10/14/2022 100093 PELLICCI HARDWARE&RENTAL 8.98 PAINT SUPPLIES 206960 101393/F 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 46.98 WELL HOUSE PAINT 207021 101388/F 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 3.99 PAINT BRUSH 207238 101395/F 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 59.95 168799 10/14/2022 118379 PEQUOD DISTRIBUTING 293.00 BEER ORDER 207208 W-164556 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 293.00 158800 10/14/2022 100034 PHILLIPS WINE AND SPIRITS,INC 2,817.07 LIQUOR&SPIRTS ORDER 207134 6472504 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 367.75 WINE ORDER 207135 6472505 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 15 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 136.70 LIQUOR&SPIRTS ORDER 207136 6472506 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 100.71 LIQUOR&SPIRTS ORDER 207150 6472650 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 279.94 WINE ORDER 207156 6472651 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 102.65 LIQUOR&SPIRTS ORDER 207210 6476158 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 335.31 WINE ORDER 207211 6476327 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 798.79 LIQUOR&SPIRTS ORDER 207212 6476326 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 4,938.92 158801 10114/2022 115677 PILLAR TITLE SERVICES 151.57 REF UTIL CR@1205 LARCH ST 207045 101304.22 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 151.57 158802 10/14/2022 110664 PREMIER TITLE INSURANCE AGENCY INC 92.55 REF UTIL CR@2704 213TH ST W 207005 FN6103/58 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 193.48 REF UTIL CR@2797 213TH ST W 207006 FN6172/49 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 100.00 REF UTIL CR@2821 213TH ST W 207007 FN6187/50 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 386.03 158803 10/14/2022 113896 PRO HYDRO-TESTING LLC 2,462.79 HYDRO TEST SCBA BOTTLES 207194 104280 1060 6505 EQUIPMENT REPAIR/MAINTENANCE FIRE SERVICES 01000 06 2,462.79 158804 10/14/2022 118936 RESULTS TITLE 147.64 REF UTIL CR@401 SPRUCE ST 207017 22-05810 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 147.64 158805 10/14/2022 118809 RITE ENTERPRISES,INC 845.21 CARD TERMINALS 207020 T0460001411 6115 6960 FURNITURE,OFFICE EQUIP,IT PILOT KNOB LIQUOR 06100 02 845.22 CARD TERMINALS 207020 T0460001411 6110 6960 FURNITURE,OFFICE EQUIP,IT DOWNTOWN LIQUOR REV&EXP 06100 02 1,690.43 158806 10/14/2022 109046 RIVER VALLEY HOME CARE INC 1,625.00 FACADE GRANT REIMB 207049 2022 FACADE GRANT2000 6550 DEVELOPER PAYMENTS HRA/ECONOMIC DEVELOPMENT 02000 03 PROGRAM 1,625.00 158807 10/14/2022 110022 SCHWICKERT'S TECTA AMERICA,LLC 34.29 HVAC REPAIR 206843 S510099492 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 54.86 HVAC REPAIR 206843 S510099492 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 34.29 HVAC REPAIR 206843 S510099492 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 68.56 HVAC REPAIR 206843 S510099492 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 48.00 HVAC REPAIR 206843 S510099492 6502 6515 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 385.00 FALL HVAC MAINTENANCE 207248 S510100076 1060 6515 BUILDING REPAIR/MAINTENANCE FIRE SERVICES 01000 06 80.00 HVAC COIL CLEANING 207249 S510100077 1050 6515 BUILDING REPAIR/MAINTENANCE POLICE ADMINISTRATION 01000 05 652.37 RPZ VALVE REBUILD 207251 S500008488 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 52.00 RPZ VALVE REBUILD 207253 S500008495 6502 6615 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE 06500 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 16 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 74.29 RPZ VALVE REBUILD 207253 S500008495 6402 6515 BUILDING REPAIR/MAINTENANCE STORM WATER UTILITY OPERA 06400 08 37.14 RPZ VALVE REBUILD 207253 S500008495 6202 6515 BUILDING REPAIR/MAINTENANCE SEWER OPERATIONS EXPENSE 06200 08 59.43 RPZ VALVE REBUILD 207253 S500008495 1090 6515 BUILDING REPAIR/MAINTENANCE PARK MAINTENANCE 01000 09 37.14 RPZ VALVE REBUILD 207253 S500008495 1072 6515 BUILDING REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 275.00 RPZ VALVE INSPECTION 207254 S500008487 1015 6515 BUILDING REPAIR/MAINTENANCE CITY HALL 01000 01 1,723.03 WATER SPIGOT REPAIR 207255 S500008509 1050 6515 BUILDING REPAIR/MAINTENANCE POLICE ADMINISTRATION 01000 05 260.00 RPZ VALVE INSPECTION 207256 S500008490 1060 6515 BUILDING REPAIR/MAINTENANCE FIRE SERVICES 01000 06 260.00 RPZ VALVE INSPECTION 207257 S500008531 1050 6515 BUILDING REPAIR/MAINTENANCE POLICE ADMINISTRATION 01000 05 4,135.40 158808 10/14/2022 107018 SHAMROCK GROUP 110.75 ICE CUBE ORDER 207115 2818701 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 73.30 ICE CUBE ORDER 2D7143 2818702 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 218.10 ICE CUBE ORDER 207149 2820821 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 402.15 168809 10/14/2022 110507 SHRED-IT USA,LLC 102.31 SHREDDING SERVICE 206665 8002377037 1010 6401 PROFESSIONAL SERVICES ADMINISTRATION 01000 01 102.31 168810 10/14/2022 112051 SOUTHERN GLAZER'S OF MN 3,036.66 LIQUOR&SPIRTS ORDER 207171 2268229 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 12,695.74 LIQUOR&SPIRTS ORDER 207175 2265958 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,961.38 LIQUOR&SPIRTS ORDER 207184 2265955 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 18,693.78 158811 10/14/2022 110799 SPECIALIZED ENVIRONMENTAL TECHNOLOGIES 72.00 SEPT'22 STREET LEAVES COMPSTNG 206965 10159 SEP'22 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 72.00 158812 10/14/2022 115777 TITLE GROUP INC,THE 112.46 REF UTIL CR@1003 WALNUT ST 206998 220840502/109 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 112.46 158813 10/14/2022 113484 TITLE SMART,INC 56.84 REF UTIL CR@613 6TH ST 206995 270125/51 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 OB 56.84 158814 10114/2022 115759 TITLE SMART,INC 78.49 REF UTIL CR@5490 193RD ST W 207011 269950/69 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 OB 78.49 168815 10/14/2022 114967 TITLE SPECIALISTS,INC 181.41 REF UTIL CR@1104 SPRUCE ST 207002 221282/42 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 181.41 168816 10/14/2022 114013 TRADEMARK TITLE SERVICES,INC R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 17 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 110.73 REF UTIL CR@20966 CAPRI ST 207204 22-4145/69 6200 1310 3 REFUND CIS SEWER OPERATIONS 0620D 08 110.73 158817 10/14/2022 119013 VALKYRIE CONSERVATION 706.59 CHARTER CONSERVE TREATMENT 207258 2022 VALKYRIE 1014 6401 PROFESSIONAL SERVICES COMMUNICATIONS 01000 01 CONSERV 706.59 158818 10/14/2022 117589 WATERMARK TITLE AGENCY 144.60 REF UTIL CR@1250 WILLOW TRL 207003 95962 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 144.60 158819 10/14/2022 100334 WINE MERCHANTS 582.80 WINE ORDER 207133 7398168 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3.40 WINE ORDER 207153 7398169 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,606.10 WINE ORDER 207159 7398207 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 746.77 WINE ORDER 207207 7399120 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,939.07 158820 10/14/2022 109119 WIPPLER,TONY 205.92 SEP'22 MILEAGE REIMB 206793 20220921 WIPPLER 1030 6485 MILEAGE REIMBURSEMENT PLANNING&ZONING 01000 03 317.98 SEP'22 LODGING REIMB 206793 20220921 WIPPLER 1030 6470 TRAINING&SUBSISTANCE PLANNING&ZONING 01000 03 523.90 158821 10/14/2022 118646 WOLF,EILEEN 100.00 REF UTIL CR@19798 FALCON PATH 207205 OVR PYMT ON 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 FINALLED ACCT 100.00 158822 10/21/2022 100058 ADVANCE AUTO PARTS 155.99 BATTERY FOR 0582 207027 2131-603375 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 155.99 158823 10/21/2022 113906 AMERICAN SOLUTIONS FOR BUSINESS 701.94 IMPRINTED WATER BOTTLES 206939 INVO6243231 7001 6570 PROGRAMMING EXPENSE EMPLOYEE BENEFITS-WELLN 07000 04 701.94 158824 10/21/2022 100011 ANDERSEN,EARL F 196.80 STREET SIGNS 206824 0130926-IN 1072 6254 SIGNS&STRIPING MATERIALS STREET MAINTENANCE 01000 08 196.80 158825 10/21/2022 113303 ARTISAN BEER COMPANY 345.20 BEER ORDER 207282 3565146 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 345.20 158826 10/21/2022 108446 ASPEN MILLS,INC. 590.69 UNIFORM FOR FIREFIGHTER SCHOLL 206982 301480 1060 6290 UNIFORMS&CLOTHING FIRE SERVICES 01000 06 590.69 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 18 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 158827 10/21/2022 115520 BALD MAN BREWING,INC 244.00 BEER ORDER 207303 E-6585 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 061DO 02 244.00 158828 10/21/2022 119051 BCM 183,114.18 2022 SPRUCE STREET PROJ CONSTR 207336 OT1.126264 5800 7010 02202 CONSTRUCTION CONTRACTS Spruce Street Reconstruct 05800 07 44,744.17 2022 PARKING LOT CONSTRUCTION 207336 OT1.126264 5801 7010 02202 CONSTRUCTION CONTRACTS 2022 Parking Lot Project 05801 07 227,858.35 158829 10/21/2022 117284 BLACK STACK BREWING,INC 342.00 BEER ORDER 207309 19672 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 342.00 158830 10/21/2022 110290 BOLTON&MENK,INC 29,724.50 VERMILLION COMMONS 1ST CONSTR 207337 0297926 4600 2256 71004 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 5,618.00 WHISPERING FIELDS 2ND CONSTRUC 207338 0297935 4600 2256 70805 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 4,519.50 SAPPHIRE LAKE 4TH CONSTRUCTION 207342 0297925 4600 2256 70408 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 39,862.00 158831 10/21/2022 114472 BREAKTHRU BEVERAGE MN BEER,LLC 12,940.95 BEER ORDER 207275 346032600 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 81.00 LIQUOR&SPIRITS ORDER 207280 346034436 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 198.75 BEER ORDER 207311 346033848 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 10,905.11 BEER ORDER 207332 346033849 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 24,125.81 158832 10/21/2022 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 167.95- LIQUOR&SPIRTS ORDER CREDIT 207264 410188896 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,392.52 LIQUOR&SPIRITS ORDER 207281 346030260 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 335.90- LIQUOR&SPIRITS ORDER CREDIT 207299 410188813 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 28.83- LIQUOR&SPIRITS ORDER CREDIT 207301 410190368 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,696.66 LIQUOR&SPIRITS ORDER 207305 346029712 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,462.50 WINE ORDER 207306 346029713 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 5,019.00 158833 10/21/2022 108360 CANNON RIVER WINERY 336.00 WINE ORDER 207302 14147 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 336.00 158834 10/21/2022 117966 COX COMMUNICATIONS 50.00 22000877 SUBPOENA FEE 207265 21775 1052 6401 PROFESSIONAL SERVICES INVESTIGATION SERVICES 01000 05 50.00 158835 10/21/2022 107384 DAKOTA COUNTY ATTORNEY'S OFFICE 1,800.00 CF-21-107 DISB FORFTRE PROCEED 207411 CF-21-107 2100 7410 ADMINISTRATION CHARGES POLICE FORFEITURES 02100 05 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 19 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div DISBURSEMENT 1,800.00 158836 10/21/2022 110844 DAKOTA COUNTY FINANCIAL SRVS 6,895.00 4TH QTR 2022 DBB OPER COSTS 207408 00045312 1020 6570 PROGRAMMING EXPENSE DAKOTA BROAD BAND-DBB 01000 6,895.00 158837 10/21/2022 100241 DELEGARD TOOL CO 3,814.50 SCAN TOOL FOR SHOP 206954 207629/1 7200 6950 MACHINERY,EQUIPMENT&TOOLS FLEET OPERATIONS 07200 08 3,814.50 158838 10/21/2022 100057 DICK'S SANITATION SERVICE 1,093.47 SEPT'22 RECYCLING-FAA 207406 4862611T480 6302 6560 CONTRACTUAL SERVICES SOLID WASTE OPERATIONS 06300 08 1,093.47 158839 10/21/2022 119057 DORING,SCOTT&KATHERINE 70.00 VOID BLDG PRMT 52162 207404 VOID BLDG PRMT 1001 4305 BUILDING PERMITS GENERAL FUND REVENUES 01000 01 52162 1.00 VOID BLDG PRMT 52162 207404 VOID BLDG PRMT 1000 2420 BUILDING PERMIT SURCHARGE GENERAL FUND BALANCE SHEE 01000 52162 71.00 158840 10/21/2022 118859 ENTERPRISE FM TRUST 2,567.99 OCT 2022 SQUAD LEASE PAYMENT 207278 FBN4577060 5602 6555 RENTAL OF EQUIPMENT GEN CAPITAL EQUIP FUND EX 05600 2,567.99 158841 10/21/2022 109931 FACTORY MOTOR PARTS 303.10 BATTERIES FOR 0720 206805 1-Z30460 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 303.10 158842 10/21/2022 119048 FARMINGTON TAP HOUSE 150.00 FOOD FOR BLOOD DRIVE 207344 20220929 BLOOD 4302 6480 MEETING EXPENSE FIRE RELIEF 04300 06 DRIVE 150.00 158843 10/21/2022 119050 FULSAAS EXTERIORS 65.00 VOID BLDG PRMT 52156 207269 VOID BLDG PRMT 1001 4305 BUILDING PERMITS GENERAL FUND REVENUES 01000 01 52156 1.00 VOID BLDG PRMT 52156 207269 VOID BLDG PRMT 1000 2420 BUILDING PERMIT SURCHARGE GENERAL FUND BALANCE SHEE 01000 52156 66.00 158844 10/21/2022 100027 GREAT LAKES COCA-COLA DISTRIBUTION,LLC 567.42 POP ORDER 207315 3608217778 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 567.42 158845 10/21/2022 118257 HAWKE,MICHAEL J 7,865.55 SEPT'22 ELEC PRMTS PAYABLE 207398 INV#2022-7 1000 2020 CONTRACTS PAYABLE GENERAL FUND BALANCE SHEE 01000 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 20 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 7,865.55 168846 10/21/2022 119053 HERITAGE LINKS LLP 3,760.91 PD AWARDS BANQUET 207400 PD AWARDS BANQUEM50 6480 MEETING EXPENSE POLICE ADMINISTRATION 01000 05 3,760.91 158847 10/21/2022 100074 HOHENSTEINS INC 687.45 BEER ORDER 207317 548276 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 687.45 168848 10/21/2022 111773 INNOVATIVE OFFICE SOLUTIONS,LLC 57.48 PENS,RUBBERBANDS,TAPE 206786 IN3947216 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 44.37 TRAINING FOLDERS 206787 IN3945620 1013 6210 OFFICE SUPPLIES ELECTIONS 01000 01 70.29 CLIP BOARD,LANYARDS 206787 IN3945620 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 22.81 HOOKS,GLUE STICKS 206788 IN3949143 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 98.46 TONER 206789 IN3952275 1010 6220 EQUIP SUPPLIES&PARTS ADMINISTRATION 01000 01 40.69 LABELS,POST-ITS,MARKERS 206789 IN3952275 1010 6210 OFFICE SUPPLIES ADMINISTRATION 01000 01 334.10 158849 10/21/2022 100033 JOHNSON BROTHERS LIQUOR COMPANY 1,675.55 LIQUOR&SPIRITS ORDER 207277 2155177 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 419.59 WINE ORDER 207283 2155179 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 955.58 LIQUOR&SPIRITS ORDER 207286 2155178 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 781.70 LIQUOR&SPIRITS ORDER 207288 2154996 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 288.50 WINE ORDER 207290 2155001 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 252.94 WINE ORDER 207291 2155176 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 444.48 LIQUOR&SPIRITS ORDER 207293 2155175 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 221.70 LIQUOR&SPIRITS ORDERG 207294 2155000 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 257.10 WINE ORDER 207295 2154997 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 136.14- WINE ORDER CREDIT 207300 225310 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 30.00 LIQUOR&SPIRITS ORDER 207321 2155006 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,557.02 LIQUOR&SPIRITS ORDER 207322 2154998 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,748.09 WINE ORDER 207323 2154999 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 84.70 LIQUOR&SPIRITS ORDER 207324 2155004 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 3,232.79 LIQUOR&SPIRITS ORDER 207325 2155003 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 872.08 WINE ORDER 207326 2155005 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 49.65 LIQUOR&SPIRITS ORDER 207328 2155007 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 221.70 LIQUOR&SPIRITS ORDER 207329 2155002 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 12,957.03 168860 10/21/2022 100048 LAKEVILLE,CITY OF 80,033.90 202ND STREET CONSTRUCTION 207418 33346 5711 7010 02102 CONSTRUCTION CONTRACTS STREET MAINTENANCE 05700 80,033.90 158861 10/21/2022 119056 LINE-X COATINGS R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 21 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 774.00 SQD 24 BEDLINER 207415 20447 5602 6940 50 VEHICLES-POLICE GEN CAPITAL EQUIP FUND EX 05600 774.00 158862 10/21/2022 119054 LUO,DAN 40.00 REFUND CODE ENF PD IN ERROR 207405 5828 180TH CODE 1001 4311 CODE ENFORCEMENT FEES GENERAL FUND REVENUES 01000 01 ENF REF 40.00 158853 10/21/2022 110493 LYNCH,DAVID 56.25 OCT'22 MILEAGE REIMB-TRNG 207403 20221011 LYNCH 2502 6485 MILEAGE REIMBURSEMENT ICE ARENA OPERATIONS EXPE 02500 09 56.25 158854 10/21/2022 118682 MESSERLI&KRAMER PA 19.48 207397 102022737364 7000 2128 GARNISHMENT PAYABLE EMPLOYEE EXPENSE FUND 07000 02 19.48 158855 10/21/2022 119055 MINNESOTA MANAGEMENT&BUDGET 660.00 21000719 FORF PROCEEDS 207412 21000719 FORF 2100 7410 ADMINISTRATION CHARGES POLICE FORFEITURES 02100 05 PROCEEDS 660.00 158856 10/21/2022 101313 MN DEPT OF LABOR&INDUSTRY 10.00 PRESSURE VESSEL PERMIT FEE 206978 ABR0288595X 1060 6564 PERMIT FEES FIRE SERVICES 01000 06 2.00 BOILER PERMIT 207240 ABR0288567X 6502 6564 PERMIT FEES WATER UTILITY EXPENSE 06500 08 2.86 BOILER PERMIT 207240 ABR0288567X 6402 6564 PERMIT FEES STORM WATER UTILITY OPERA 06400 08 1.43 BOILER PERMIT 207240 ABR0288567X 6202 6564 PERMIT FEES SEWER OPERATIONS EXPENSE 06200 08 2.29 BOILER PERMIT 207240 ABR0288567X 1090 6564 PERMIT FEES PARK MAINTENANCE 01000 09 1.42 BOILER PERMIT 207240 ABR0288567X 1072 6505 EQUIPMENT REPAIR/MAINTENANCE STREET MAINTENANCE 01000 08 20.00 BOILER PERMIT 207241 ABR0290035X 2502 6564 PERMIT FEES ICE ARENA OPERATIONS EXPE 02500 09 40.00 158857 10/21/2022 100322 MN NCPERS LIFE INSURANCE 16.00 207396 102022737363 7000 2119 PERA LIFE INS PAYABLE EMPLOYEE EXPENSE FUND 07000 02 16.00 158858 10/21/2022 119037 NORTHERN SODA COMPANY 240.00 POP ORDER 207285 5916 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 240.00 158859 10/21/2022 100034 PHILLIPS WINE AND SPIRITS,INC 255.16 WINE ORDER 207327 6476160 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,463.48 LIQUOR&SPIRITS ORDER 207330 6476159 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,718.64 158860 10/21/2022 102455 PRAIRIE RESTORATIONS INC 775.00 CAMERON WOODS SPRAY 206918 #35212 1076 6560 CONTRACTUAL SERVICES NATURAL RESOURCES 01000 07 775.00 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 22 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 158861 10/21/2022 110760 PRO-TECH DESIGN,INC 433.50 TROUBLSHOOT CAMERA MAINT FAC 206929 106846 7400 6401 PROFESSIONAL SERVICES INFORMATION TECHNOLOGY 07400 04 5,702.40 36 RAPID REVIEW LICENSE 206930 106773 7400 6505 EQUIPMENT REPAIR/MAINTENANCE INFORMATION TECHNOLOGY 07400 04 6,135.90 158862 10/21/2022 100151 SAUBER PLUMBING&HEATING COMPANY 4,155.00 LAUNDROMAT SERVICE REPAIR 207272 23 670 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 4,155.00 158863 10/21/2022 110022 SCHWICKERT'S TECTA AMERICA,LLC 120.00 HVAC REPAIR 207389 S510100402 1060 6515 BUILDING REPAIR/MAINTENANCE FIRE SERVICES 01000 06 120.00 158864 10/21/2022 107018 SHAMROCK GROUP 127.65 ICE CUBE ORDER 207318 2820820 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 127.65 158865 10/21/2022 112051 SOUTHERN GLAZER'S OF MN 5.12 DELIVERY CHARGE 207333 2268231 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 6,547.10 LIQUOR&SPIRITS ORDER 207335 2268232 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 6,552.22 158866 10/21/2022 100100 STREICHER'S 63.00 40MM LAUNCHER POUCHES 207414 11594561 1051 6220 EQUIP SUPPLIES&PARTS PATROL SERVICES 01000 05 63.00 168867 10/21/2022 118440 SUMMER LAKES BEVERAGE LLC 393.75 LIQUOR&SPIRITS ORDER 207289 4716 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 393.75 LIQUOR&SPIRITS ORDER 207331 4715 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 787.50 158868 10/21/2022 118999 WENDEL ARCHITECTURE 4,725.00 FIRE STATION PLAN 207343 502282 1060 6401 PROFESSIONAL SERVICES FIRE SERVICES 01000 06 4,725.00 158869 10/21/2022 118072 WINSUPPLY LAKEVILLE MN CO. 107.47 LIGHT BULBS 206832 399391 01 1060 6240 BUILDING SUPPLIES&PARTS FIRE SERVICES 01000 06 107.47- RTRN: LIGHT BULBS 206844 399391 03 CR 1060 6240 BUILDING SUPPLIES&PARTS FIRE SERVICES 01000 06 332.75 LIGHT BULBS 207237 399391 04 1050 6240 BUILDING SUPPLIES&PARTS POLICE ADMINISTRATION 01000 05 332.75 158870 10/28/2022 117724 @TITLE,LLC 105.40 REF UTIL CR@1104 LOCUST ST 207437 22-4934/37 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 105.40 158871 10/28/2022 100068 ADVANCE AUTO PARTS 23.74 HITCH RECIEVER PIN FOR 0731 207024 2131-603751 1072 6230 VEHICLE SUPPLIES&PARTS STREET MAINTENANCE 01000 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 23 10/12/2022- 10/3112022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 23.74 158872 10/28/2022 113303 ARTISAN BEER COMPANY 779.40 BEER ORDER 207485 3565099 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 249.20 BEER ORDER 207493 3566474 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 138.50 BEER ORDER 207551 3566425 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,167.10 158873 10/28/2022 115890 ATTORNEYS TITLE GROUP,LLC 174.48 REF UTIL CR@18676 DULANEY DR 207447 5040506579 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 174.48 158874 10/28/2022 118350 BALDUS,JOSEPH 180.00 FLAG FOOTBALL OFFICIAL 207629 20221019 BALDUS 1095 6560 CONTRACTUAL SERVICES RECREATION PROGRAM SERVIC 01000 09 180.00 158875 10/28/2022 110290 BOLTON&MENK,INC 32,629.00 FEB'22 SVS:TH 3 TRAIL DESIGN 207441 0286289 5721 6401 02002 PROFESSIONAL SERVICES TRAIL MAINTENANCE 05700 2,150.50 JUL'22 SVS:VITAATTIVA3 PLAN 207443 0295686 4600 2256 70905 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 6,757.00 JUL'22 SVS:VITAATTIVA 1 DEV 207443 0295686 4600 2256 70903 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 1,610.50 MAR'22 SVS:TH 3 TRAIL DESIGN 207445 0288071 5721 6401 02002 PROFESSIONAL SERVICES TRAIL MAINTENANCE 05700 680.00 AUG'22 SVS:TRAFFIC COUNTS 207456 0295674 1070 6401 PROFESSIONAL SERVICES ENGINEERING SERVICES 01000 07 6,644.50 AUG'22 SVS:VITAATTIVA 1ST 207457 0297934 4600 2256 70903 DEVELOPMENT ESCROWS PRIVATE CAPITAL PROJECTS 04600 07 669.50 AUG'22 SVS:MYSTIC MDW TRL 207525 0297916 5810 6401 PROFESSIONAL SERVICES Trail Maintenance 05810 09 51,141.00 158876 10/28/2022 114472 BREAKTHRU BEVERAGE MN BEER,LLC 25.60 BEER ORDER 207526 346132112 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 527.00 LIQUOR&SPIRITS ORDER 207530 346132111 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 13,042.83 BEER ORDER 207536 346132110 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 192.10 BEER ORDER 207544 346128452 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 528.40 LIQUOR&SPIRITS ORDER 207555 346128481 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 16,742.95 BEER ORDER 207565 346128451 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 31,058.88 158877 10/28/2022 114471 BREAKTHRU BEVERAGE MN WINE&SPIRITS 428.70 WINE ORDER 207528 346129869 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 124.05 WINE ORDER 207529 346129868 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3,456.71 LIQUOR&SPIRITS ORDER 207534 346129867 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 129.45 WINE ORDER 207538 346129014 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 169.45- LIQUOR&SPIRITS ORDER CREDIT 207542 410147534 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,070.02 BEER ORDER 207564 346129013 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 8,039.48 158878 10/28/2022 110218 BURNET TITLE 262.52 REF UTIL CR@30 SPRUCE ST 207435 2111022-08533 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 24 10/12/2022- 10/31/2022 Check# Date Amount Supplier I Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 53.24 REF UTILCR@19063 CLOVERLEAF WY 207451 2111022-09858 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 315.76 158879 10/2812022 119059 CARLSON,CHRYSTIE 15.83 GOLF CLASS REFUND 207429 101922 1001 4662 RECREATION FEES-GENERAL GENERAL FUND REVENUES 01000 01 15.83 158880 10/2812022 115948 CEDARLINE CONSTRUCTION 3,000.00 ER 3210 VERMILLION RVR TR 207609 ER 3210 VERMILLION4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 RVR TR 3,000.00 ER 3170 VERMILLION RVR TR 2D7610 ER 3170 VERMILLION4600 2255 DEPOSITS PAYABLE PRIVATE CAPITAL PROJECTS 04600 07 RVR TR 6,000.00 158881 10/28/2022 110511 CHARTER COMMUNICATIONS HOLDINGS,LLC 543.23 OCT'22 CABLE&ALARM LINES 207622 0001792100122 7400 6411 TELEPHONE/CABLE SERVICES INFORMATION TECHNOLOGY 07400 04 16.85 OCT'22 CABLE FD STATION#2 207623 0164297100622 7400 6412 CELLULAR SERVICES INFORMATION TECHNOLOGY 07400 04 560.08 158882 10/28/2022 118291 COCCARELLI,CHARLES 210.00 FLAG FOOTBALL OFFICIAL 207628 20221019 1095 6560 CONTRACTUAL SERVICES RECREATION PROGRAM SERVIC 01000 09 COCCARELLI 210.00 158883 10/28/2022 100456 COMMERCIAL ASPHALT COMPANY 2,235.05 ASPHALT 207039 220930 1072 6253 STREET MATERIALS STREET MAINTENANCE 01000 08 2,235.05 158884 10/28/2022 112888 COOL AIR MECHANICAL,INC 375.00 HAZWOPER TRAINING 207464 101103 2502 6470 TRAINING&SUBSISTANCE ICE ARENA OPERATIONS EXPE 02500 09 375.00 158885 10/28/2022 100030 CORE&MAIN,LP 432.00 HYDRANT PAINT 207431 R355280 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 207.40 4"REPAIR BAND 207432 R704341 6502 6220 EQUIP SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 639.40 158886 10/28/2022 100133 DAKOTA COUNTY FINANCIAL SRVS 1,049.85 SEPT'22 RADIO SUBSCRIBER FEES 207416 00045446 1050 6560 CONTRACTUAL SERVICES POLICE ADMINISTRATION 01000 05 1,633.10 SEPT'22 RADIO SUBSCRIBER FEES 207416 00045446 1060 6560 CONTRACTUAL SERVICES FIRE SERVICES 01000 06 2,682.95 158887 10128/2022 100118 DAKOTA COUNTY TREASURER-AUDITOR 3,600.00 WHEP 207273 2022 WHEP 6402 6570 PROGRAMMING EXPENSE STORM WATER UTILITY OPERA 06400 08 3,600.00 158888 1012812022 114949 DVS REGISTRATION 14.25 SQD 92 REGISTRATION 207613 F#0592 2020 FORD 1051 6234 VEHICLE LICENSES,TAXES,FEE PATROL SERVICES 01000 05 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 25 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Cc Dept Div EX RENEW 14.25 158889 10/28/2022 100149 ECM PUBLISHERS,INC 55.75 ORD#02-769 206989 913493 1010 6455 LEGAL NOTICES ADMINISTRATION 01000 01 44.75 PH:DELINQ SVS CERTIFICATION 206990 913494 1010 6455 LEGAL NOTICES ADMINISTRATION 01000 01 100.50 158890 10/28/2022 115815 EDGEWATER TITLE GROUP,LLC 99.29 REF UTIL CR@3260 223RD ST W 207440 22-85526 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 99.29 158891 10/28/2022 113296 EDINA REALTY TITLE 46.49 REF UTIL CR@23 LILAC LN 207458 2173900/126 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 46.49 158892 10/28/2022 100419 EMPIRE TOWNSHIP 472.05 3RD QTR 2022 SEWER USAGE FEE 206962 01-00000057 6202 6560 CONTRACTUAL SERVICES SEWER OPERATIONS EXPENSE 06200 08 J U L-SE P'22 472.05 168893 10/28/2022 109931 FACTORY MOTOR PARTS 9.98 STOCK FILTERS 206951 1-8040808 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 58.74 SPARK PLUGS FOR 0522 206951 1-8040808 1051 6230 VEHICLE SUPPLIES&PARTS PATROL SERVICES 01000 05 22.00 STOCK FILTERS 206952 25-1080611 7200 6230 VEHICLE SUPPLIES&PARTS FLEET OPERATIONS 07200 08 90.72 158894 10/28/2022 113454 FARMINGTON PETTY CASH ACCT 350.00 RRC ANNUAL BRKFST FNDRSR 207426 102922 1000 1020 PETTY CASH GENERAL FUND BALANCE SHEE 01000 350.00 158895 10/28/2022 102494 FARMINGTON VET CLINIC 91.40 K9 SMOKE VET VISIT 207614 236092 2200 6401 PROFESSIONAL SERVICES K-9(EFF.2019) 02200 05 61.56 K9 SMOKE VET VISIT 207615 235050 2200 6401 PROFESSIONAL SERVICES K-9(EFF.2019) 02200 05 152.96 158896 10/28/2022 119070 GILBERTSON,DANIEL PAUL 210.00 FLAG FOOTBALL OFFICIAL 207632 20221019 1095 6560 CONTRACTUAL SERVICES RECREATION PROGRAM SERVIC 01000 09 GILBERTSON 210.00 158897 10/28/2022 111456 GLOBAL CLOSING&TITLE SERVICES 309.46 REFUTILCR@19362 EVEN'N STAR CT 207452 MN-08-221125 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 309.46 158898 10/28/2022 100024 GOPHER STATE ONE-CALL 175.95 SEPTEMBER 2022 LOCATES 207425 12090391 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 175.95 SEPTEMBER 2022 LOCATES 207425 12090391 6202 6401 PROFESSIONAL SERVICES SEWER OPERATIONS EXPENSE 06200 08 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 26 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 175.95 SEPTEMBER 2022 LOCATES 207425 12090391 6402 6401 PROFESSIONAL SERVICES STORM WATER UTILITY OPERA 06400 08 527.85 158899 10/28/2022 100027 GREAT LAKES COCA-COLA DISTRIBUTION,LLC 739.66 POP ORDER 207490 3608217833 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 739.66 158900 10/28/2022 116589 GREATAMERICA FINANCIAL SERVICES 217.85 OCT'22 POSTAGE METER RENTAL 207370 32606332 1010 6555 RENTAL OF EQUIPMENT ADMINISTRATION 01000 01 217.85 158901 10/28/2022 102222 GRENGS,BRENT 340.00 FLAG FOOTBALL OFFICIAL 207633 20221017 GRENGS 1095 6560 CONTRACTUAL SERVICES RECREATION PROGRAM SERVIC 01000 09 BRENT 340.00 158902 10/28/2022 113588 GRENGS,LUKE D 140.00 FLAG FOOTBALL OFFICIAL 207630 20221017 GRENGS 1095 6560 CONTRACTUAL SERVICES RECREATION PROGRAM SERVIC 01000 09 LUKE 140.00 158903 10/28/2022 105389 GRENGS,TROY 245.00 FLAG FOOTBALL OFFICIAL 207631 20221017 GRENGS 1095 6560 CONTRACTUAL SERVICES RECREATION PROGRAM SERVIC 01000 09 TROY 245.00 158904 10/28/2022 100074 HOHENSTEINS INC 776.00 BEER ORDER 207488 550383 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 494.10 BEER ORDER 207556 550195 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 423.50 BEER ORDER 207590 552206 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,693.60 158905 10/28/2022 100192 HOLCIM-MWR,INC 121.49 CLASS 5 WATER REPAIR EAVES CT 207041 716999936 6502 6250 OTHER SUPPLIES&PARTS WATER UTILITY EXPENSE 06500 08 121.49 158906 10/28/2022 100597 INDEPENDENT BLACK DIRT CO INC 378.00 DIRT FOR SIGN REMOVALS 207386 SEPTEMBER 2022 1090 6255 LANDSCAPING MATERIALS PARK MAINTENANCE 01000 09 378.00 158907 10/28/2022 114168 JML FABRICATION,LLC 2,219.10 RAILINGS:RRC&BAKERY 207627 21492 5721 7020 OTHER CONSTRUCTION COSTS TRAIL MAINTENANCE 05700 2,219.10 158908 10/28/2022 100033 JOHNSON BROTHERS LIQUOR COMPANY 191.40 WINE ORDER 207491 2159775 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 381.34 LIQUOR&SPIRITS ORDER 207492 2159922 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 647.85 LIQUOR&SPIRITS ORDER 207495 2159925 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 27 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 379.66 WINE ORDER 207496 2159926 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 691.90 WINE ORDER 207497 2159923 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 49.70 LIQUOR&SPIRITS ORDER 207499 2159927 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 3,110.10 LIQUOR&SPIRITS ORDER 207500 2159924 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 163.40 WINE ORDER 207527 2160265 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 1,167.25 LIQUOR&SPIRITS ORDER 207537 2159773 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,363.59 WINE ORDER 207540 2159774 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,314.60 LIQUOR&SPIRITS ORDER 207543 2159776 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 480.79 WINE ORDER 207547 2159772 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,309.61 LIQUOR&SPIRITS ORDER 207553 2159771 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 14,251.19 158909 10/28/2022 119062 JOHNSON,DEB 15.83 GOLF CLASS CANCELLATION 207423 101922 1001 4662 RECREATION FEES-GENERAL GENERAL FUND REVENUES 01000 01 15.83 158910 10/28/2022 119061 KOCHEVAR,SHALYNN 15.83 GOLF CLASS CANCELLATION 207422 101922 1001 4662 RECREATION FEES-GENERAL GENERAL FUND REVENUES 01000 01 15.83 158911 10/28/2022 110501 LAND TITLE INC 131.08 REF UTIL CR@5339 187TH ST W 207444 666404 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 131.08 158912 10/28/2022 115466 LIFE INSURANCE COMPANY OF NORTH AMERICA 157.31 NOV'22 Cl INSURANCE 207521 C1960343 NOV'22 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 144.30 NOV'22 ACCIDENT INSURANCE 207523 A1960331 NOV'22 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 301.61 158913 10/28/2022 119066 LINA,JENNIFER 47.49 GOLF CLASS CANCELLATION REFUND 207424 102122 1001 4662 RECREATION FEES-GENERAL GENERAL FUND REVENUES 01000 01 47.49 158914 10/28/2022 116483 LOOYEN,MARINA 15.83 GOLF CLASS REFUND 207420 101922 1001 4662 RECREATION FEES-GENERAL GENERAL FUND REVENUES 01000 01 15.83 158915 10/28/2022 112398 MADISON NATIONAL LIFE INSURANCE CO, 973.45 NOV'22 LTD INSURANCE 207522 1523351 NOV'22 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 973.45 158916 10/28/2022 110975 MARSC HALL LINE INC 261.06 FARMINGTON TOUR 207575 67988 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 261.06 158917 10/28/2022 111035 MEDICINE LAKE TOURS 2,465.00 OZARK JUBILEE 207473 20221116 OZARK 1093 6570 PROGRAMMING EXPENSE SENIOR CITIZEN SERVICES 01000 09 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 28 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div JUBILEE 2,465.00 158918 10/28/2022 118580 MEGA BEER LLC 2,174.25 BEER ORDER 207535 17906 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 2,174.25 158919 10/28/2022 100095 METROPOLITAN COUNCIL ENVIRONMENTAL SVS 149,085.30 NOV 2022 WASTE WATER MCES FEES 207038 0001147190 6202 6565 MCES FEES SEWER OPERATIONS EXPENSE 06200 08 149,085.30 158920 10/28/2022 108724 MIDWEST PLAYSCAPES INC 772.13 PLAYGROUND REPAIR PARTS 207462 9817 1090 6220 EQUIP SUPPLIES&PARTS PARK MAINTENANCE 01000 09 772.13 158921 10/28/2022 108490 MINNESOTA UI FUND 14,850.17 3RD QTR 2022 UI PAYMENT 207427 07986748 3RD QTR 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 '22 14,850.17 158922 10/26/2022 107932 MOOD MEDIA 58.53 NOV 2022 RADIO SVS-LIQUOR 207598 57150838 6110 6401 PROFESSIONAL SERVICES DOWNTOWN LIQUOR REV&EXP 06100 02 58.52 NOV 2022 RADIO SVS-LIQUOR 207598 57150838 6115 6401 PROFESSIONAL SERVICES PILOT KNOB LIQUOR 06100 02 117.05 158923 10/28/2022 119071 MOTION PICTURE LICENSING CORPORATION 289.00 MOTION PICTURE LICENSE CERT 207626 504411048 1093 6460 MEMBER DUES&LICENSURE SENIOR CITIZEN SERVICES 01000 09 289.00 158924 10/28/2022 112901 ON SITE TITLE LLC 192.84 REF UTIL CR@5669 180TH ST W 207446 22-723 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 89.06 REF UTIL CR@18763 ENGLEWD WAY 207448 22-687 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 79.23 REF UTIL CR@20572 CAMDEN PATH 207455 22-727 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 361.13 158925 10/28/2022 117112 OS NATIONAL,LLC 50.08 REF UTIL CR@19651 ESTES PATH 207453 456194 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 50.08 158926 10/28/2022 119065 OUVERSON SEWER&WATER INC 2,800.00 1320 CENTENNIAL SERVICE REPAIR 207578 7161 6502 6401 PROFESSIONAL SERVICES WATER UTILITY EXPENSE 06500 08 2,800.00 158927 10/28/2022 100290 PAUSTIS&SONS WINE COMPANY 232.00 WINE ORDER 207554 180953 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 232.00 158928 10/28/2022 100032 PEPSI COLA COMPANY R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 29 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 103.40- POP ORDER CREDIT 207557 93669409 CR 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 234.40 POP ORDER 207560 93669408 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 131.00 158929 10/28/2022 118379 PEQUOD DISTRIBUTING 287.63 BEER ORDER 207486 W-166245 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 061DO 02 287.63 168930 10128/2022 100034 PHILLIPS WINE AND SPIRITS,INC 285.74 WINE ORDER 207494 6480252 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 330.95 LIQUOR&SPIRITS ORDER 207498 6480251 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 967.05 WINE ORDER 207550 6480122 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 1,203.95 LIQUOR&SPIRITS ORDER 207552 6480121 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 2,787.69 158931 10/28/2022 117232 POPP,STACEY 12.50 MILEAGE OPEN HOUSE 207611 20221012 POPP 1093 6485 MILEAGE REIMBURSEMENT SENIOR CITIZEN SERVICES 01000 09 12.50 158932 10/28/2022 110664 PREMIER TITLE INSURANCE AGENCY INC 140.69 REF UTIL CR@2816 213TH ST W 207439 FN6167/50 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 140.69 158933 10/2812022 114619 RED BULL DISTRIBUTION COMPANY,INC 337.92 RED BULL ORDER 207572 5003508769 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 337.92 168934 10/28/2022 107129 ROTO-ROOTER SERVICES COMPANY 297.00 ROTO ROOTER CLEAR DRAIN 207472 48-24406890 1093 6515 BUILDING REPAIR/MAINTENANCE SENIOR CITIZEN SERVICES 01000 09 297.00 168935 10/28/2022 107824 SCHAD TRACY SIGNS INC 2,230.01 EXTERIOR SIGN REPAIR DOWNPYMT 207501 220701-01 6115 6515 BUILDING REPAIR/MAINTENANCE PILOT KNOB LIQUOR 06100 02 2,230.01 158936 10/28/2022 110022 SCHWICKERT'S TECTA AMERICA,LLC 1,507.52 RPZ VALVE REBUILD 207471 S500008572 1060 6515 BUILDING REPAIR/MAINTENANCE FIRE SERVICES 01000 06 1,507.52 158937 10/28/2022 107018 SHAMROCK GROUP 208.50 ICE CUBE ORDER 207487 2827224 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 183.90 ICE CUBE ORDER 207562 2827225 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 66.95 ICE CUBE ORDER 207571 2824444 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 459.35 158938 10/28/2022 119060 SIMON,JODIE 15.83 GOLF CLASS CANCELLATION 207421 101922 1001 4662 RECREATION FEES-GENERAL GENERAL FUND REVENUES 01000 01 15.83 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 30 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 158939 10/28/2022 118672 SMALL LOT WINE 246.32 LIQUOR&SPIRITS ORDER 207589 MN57534 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 246.32 158940 10/28/2022 112051 SOUTHERN GLAZER'S OF MN 4,142.60 LIQUOR&SPIRITS ORDER 207489 2270944 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 5,214.50 LIQUOR&SPIRITS ORDER 207561 2270947 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 4,325.37 LIQUOR&SPIRITS ORDER 207567 2273444 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 .02- LIQUOR&SPIRITS ORDER CREDIT 207591 39012 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 90.00- LIQUOR&SPIRITS ORDER CREDIT 207592 9334657 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 185.76- LIQUOR&SPIRITS ORDER CREDIT 207593 9428068 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 14.40- LIQUOR&SPIRITS ORDER CREDIT 207594 9334766 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 12.80- LIQUOR&SPIRITS ORDER CREDIT 207595 9423525 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 193.50- LIQUOR&SPIRITS ORDER CREDIT 207596 9409127 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 17.50- LIQUOR&SPIRITS ORDER CREDIT 207597 9434975 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 131.07- LIQUOR&SPIRITS ORDER CREDIT 207599 31269 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 11.20- LIQUOR&SPIRITS ORDER CREDIT 207600 9400834 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 208.98- LIQUOR&SPIRITS ORDER CREDIT 207601 9415745 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 48.00- LIQUOR&SPIRITS ORDER CREDIT 207602 9330965 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 78.00- LIQUOR&SPIRITS ORDER CREDIT 207603 9330805 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 19.20- LIQUOR&SPIRITS ORDER CREDIT 207604 9308152 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 13.46- LIQUOR&SPIRITS ORDER CREDIT 207605 20042 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 47.00- LIQUOR&SPIRITS ORDER CREDIT 207606 9300792 CR 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 12,611.58 158941 10/28/2022 109225 STEWART TITLE OF MN,INC 59.85 REF UTIL CR@1212 MAPLE ST 207438 1836179 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 59.85 158942 10/28/2022 114967 TITLE SPECIALISTS,INC 28.13 REF UTIL CR@18770 DYLAN DR 207449 221495/37 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 28.13 158943 1012812022 114013 TRADEMARK TITLE SERVICES,INC 140.53 REF UTIL CR@622 5TH ST 207436 22-4370/102 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 124.75 REF UTIL CR@20130 DUNBAR AVE 207454 22-4400/64 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 265.28 158944 10/28/2022 119001 URSA MINOR BREWING LLC 276.66 BEER ORDER 207568 E-2997 6100 1405 10 INVENTORY-DOWNTOWN LIQUOR OPERATIONS 06100 02 276.66 158945 10/28/2022 100396 VALMONT INDUSTRIES INC 1,608.00 LIGHT POLE BANNER MOUNTS 207617 CD25085631 2150 6220 EQUIP SUPPLIES&PARTS POLICE PUBLIC OUTREACH 02150 05 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 31 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 1,608.00 158946 10/28/2022 117589 WATERMARK TITLE AGENCY 150.82 REF UTIL CR@5016 217TH ST W 207442 94146 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 25.37 REF UTIL CR@18840 EMBERS AVE 207450 97005 6200 1310 3 REFUND CIS SEWER OPERATIONS 06200 08 176.19 158947 10/28/2022 100334 WINE MERCHANTS 902.80 WINE ORDER 207549 7400022 6100 1405 15 INVENTORY-PILOT KNOB LIQUOR OPERATIONS 06100 02 902.80 20221009 10/5/2022 115438 AMERITAS LIFE INSURANCE CORP 5,465.28 OCT-22 DENTAL INSURANCE 206970 010-44446 OC722 7000 6158 EMPLOYEE BENEFITS EMPLOYEE EXPENSE FUND 07000 02 5,465.28 20221010 10/12/2022 108980 MINNESOTA ENERGY RESOURCES CORPORATION 18.00 SEPT'22 GAS 208TH ST WARM HOUS 206830 0506537581 SEPT'22 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 18.00 20221011 10/17/2022 116564 FP MAILING SOLUTIONS/POSTALIA 500.00 10/13/22 POSTAGE METER REFILL 207407 61858118 20221013 1014 6445 POSTAGE/SHIPPING FEES COMMUNICATIONS 01000 01 500.00 20221012 10/18/2022 108980 MINNESOTA ENERGY RESOURCES CORPORATION 18.00 SEPT'22 GAS WELL#5 206819 0507120636 SEPT'22 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 18.00 SEPT'22 GAS VERM GROVE LIFT ST 206820 0503080372 SEPT'22 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 36.00 20221013 10/18/2022 117633 NOKOMIS ENERGY LLC 5,372.36 SEP'22 ELEC CITYHALL/ARENA/RRC 207367 AOR3YP-2022-09-30 1015 6422 ELECTRIC CITY HALL 01000 01 8,174.99 SEP-22 ELEC CITYHALL/ARENA/RRC 207367 AOR3YP-2022-09-30 2502 6422 ELECTRIC ICE ARENA OPERATIONS EXPE 02500 09 981.55 SEP'22 ELEC CITY HALL/ARE NA/RRC 207367 AOR3YP-2022-09-30 1093 6422 ELECTRIC SENIOR CITIZEN SERVICES 01000 09 14,528.90 20221014 10/19/2022 100394 XCEL ENERGY 231.35 SEPT'22 ELEC-321 ELM ST LTS 206810 51-8608862 SEP'22 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 23.68 SEPT'22 ELEC-LINDEN ST LFT STN 206811 51-6585658 SEP'22 6202 6422 ELECTRIC SEWER OPERATIONS EXPENSE 06200 08 40.50 SEPT'22 ELEC-5262 208TH ST LTS 206812 51-8391412 SEP'22 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 217.19 SEPT'22 ELEC-190TH ST BRDG LTS 206813 51-9371130 SEP'22 6602 6422 ELECTRIC STREETLIGHT UTILITY EXPEN 06600 08 512.72 20221015 10/20/2022 111046 VOYAGER FLEET SYSTEMS INC 265.79 SEPT'22 FUEL BLDG INSP 206666 8690882372239 BLDG 1031 6272 FUEL BUILDING INSPECTIONS 01000 07 INSP 181.77 SEPT'22 FUEL NAT RES 206784 8690882372239 NAT 1076 6272 FUEL NATURAL RESOURCES 01000 07 RES 150.00 SEPT'22 FUEL NAT RES 206784 8690882372239 NAT 1076 6272 FUEL NATURAL RESOURCES 01000 07 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 32 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div RES 193.56 SEPT'22 FUEL RECREATION 206790 8690882372239 1094 6272 FUEL PARK&RECREATION ADMIN 01000 09 RECREATION 458.14 SEPT'21 FUEL FLEET 206814 8690882372239 7200 6272 FUEL FLEET OPERATIONS 07200 08 FLEET 916.13 SEPT'22 FUEL SEWER 206815 8690882372239 6202 6272 FUEL SEWER OPERATIONS EXPENSE 06200 08 SEWER 694.21 SEPT'22 FUEL STORM 206816 8690882372239 6402 6272 FUEL STORM WATER UTILITY OPERA 06400 08 STORM 976.19 SEPT'22 FUEL STREET 206817 8690882372239 1072 6272 FUEL STREET MAINTENANCE 01000 08 ST/SN 717.91 SEPT'22 FUEL WATER 2D6818 8690882372239 6502 6272 FUEL WATER UTILITY EXPENSE 06500 08 WATER 4.56 SEPT'22 FUEL BLDG MAINT 206841 8690882372239 BLDG6502 6272 FUEL WATER UTILITY EXPENSE 06500 08 MAINT 6.51 SEPT'22 FUEL BLDG MAINT 206841 8690882372239 BLDG6402 6272 FUEL STORM WATER UTILITY OPERA 06400 08 MAINT 3.25 SEPT'22 FUEL BLDG MAINT 206841 8690882372239 BLDG6202 6272 FUEL SEWER OPERATIONS EXPENSE 06200 08 MAINT 3.26 SEPT'22 FUEL BLDG MAINT 206841 8690882372239 BLDG1050 6272 FUEL POLICE ADMINISTRATION 01000 05 MAINT 2.60 SEPT'22 FUEL BLDG MAINT 206841 8690882372239 BLDG1093 6272 FUEL SENIOR CITIZEN SERVICES 01000 09 MAINT 5.21 SEPT'22 FUEL BLDG MAINT 206841 8690882372239 BLDG1090 6272 FUEL PARK MAINTENANCE 01000 09 MAINT 3.25 SEPT'22 FUEL BLDG MAINT 206841 8690882372239 BLDG1072 6272 FUEL STREET MAINTENANCE 01000 08 MAINT 11.72 SEPT'22 FUEL BLDG MAINT 206841 8690882372239 BLDG1060 6272 FUEL FIRE SERVICES 01000 06 MAINT 45.57 SEPT'22 FUEL BLDG MAINT 206841 8690882372239 BLDG1015 6272 FUEL CITY HALL 01000 01 MAINT 2,851.35 SEPT'22 FUEL PARKS 206857 8690882372239 1090 6272 FUEL PARK MAINTENANCE 01000 09 PARKS 110.60 SEPT'22 FUEL ENGINEERING 206926 8690882372239 1031 6272 FUEL BUILDING INSPECTIONS 01000 07 ENGINEERING 74.15 SEPT'22 FUEL ENGINEERING 206926 8690882372239 1070 6272 FUEL ENGINEERING SERVICES 01000 07 ENGINEERING 894.92 SEPT'22 FUEL FIRE 206973 8690882372239 FIRE 1060 6272 FUEL FIRE SERVICES 01000 06 6,086.81 SEPT'22 FUEL POLICE 206985 8690882372239 1051 6272 FUEL PATROL SERVICES 01000 05 POLICE 14,657.46 R55CKS2 LOGIS600V CITY OF FARMINGTON 11/1/2022 8:04:52 Note: Payment amount may not reflect the actual amount due to data sequencing and/or data selection. Council Check Summary Page- 33 10/12/2022- 10/31/2022 Check# Date Amount Supplier/Explanation PO# Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div 20221016 10/20/2022 108980 MINNESOTA ENERGY RESOURCES CORPORATION 48.20 SEPT'22 GAS DT LIQ STORE 206914 0731950432 SEPT'22 6110 6423 NATURAL GAS DOWNTOWN LIQUOR REV&EXP 06100 02 48.20 20221017 10/20/2022 100394 XCEL ENERGY 1,521.11 SEPT'22 ELEC-DT LIQ STORE 206669 51-0013680782 6110 6422 ELECTRIC DOWNTOWN LIQUOR REV&EXP 06100 02 S EP'22 29.21 SEPT'22 ELEC-DISTAD PARK WRM H 206831 51-9027188 SEPT'22 1090 6422 ELECTRIC PARK MAINTENANCE 01000 09 1,550.32 20221018 10/21/2022 108980 MINNESOTA ENERGY RESOURCES CORPORATION 18.00 SEPT'22 GAS WELL HOUSE 1 OAK S 206956 0506788875 SEPT'22 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 63.73 SEPT'22 GAS FIRE STATION 1 206974 0506565319 SEPT'22 1060 6423 NATURAL GAS FIRE SERVICES 01000 06 129.90 SEPT'22 GAS RRC 207010 0507948331 SEPT'22 1093 6423 NATURAL GAS SENIOR CITIZEN SERVICES 01000 09 1,564.12 SEPT'22 GAS ARENA 207232 0502346011 SEPT'22 2502 6423 NATURALGAS ICE ARENA OPERATIONS EXPE 02500 09 11.84 SEPT'22 GAS 1ST STREET GARAGE 207233 0505547424 SEPT'22 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 7.11 SEPT'22 GAS 1ST STREET GARAGE 207233 0505547424 SEPT'22 6402 6423 NATURAL GAS STORM WATER UTILITY OPERA 06400 08 8.88 SEPT'22 GAS 1ST STREET GARAGE 207233 0505547424 SEPT'22 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 9.47 SEPT'22 GAS 1ST STREET GARAGE 207233 0505547424 SEPT'22 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 7.70 SEPT'22 GAS 1ST STREET GARAGE 207233 0505547424 SEPT'22 1072 6423 NATURAL GAS STREET MAINTENANCE 01000 08 95.08 SEPT'22 GAS CMF 207234 0502362190 SEPT'22 6502 6423 NATURAL GAS WATER UTILITY EXPENSE 06500 08 57.05 SEPT'22 GAS CMF 207234 0502362190 SEP722 6402 6423 NATURAL GAS STORM WATER UTILITY OPERA 06400 08 71.31 SEPT'22 GAS CMF 207234 0502362190 SEPT'22 6202 6423 NATURAL GAS SEWER OPERATIONS EXPENSE 06200 08 76.07 SEPT'22 GAS CMF 207234 0502362190 SEPT'22 1090 6423 NATURAL GAS PARK MAINTENANCE 01000 09 61.81 SEPT'22 GAS CMF 207234 0502362190 SEPT'22 1072 6423 NATURAL GAS STREET MAINTENANCE 01000 08 2,182.07 20221019 10/21/2022 100136 PUBLIC EMPLOYEES RETIREMENT ASSN. 25,558.92 207394 102022737361 7000 2113 PERA PAYABLE EMPLOYEE EXPENSE FUND 07000 02 34,195.34 207395 102022737362 7000 6154 PERA EMPLOYEE EXPENSE FUND 07000 02 59,754.26 Report Totals 1,249,497.33 APPROVALS: akHOYT PORTER BERNHJELM �?20N /4--L-1 EN CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON 0 651-28o-6800 Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Chris Regis, Finance Director SUBJECT: Purchase of Capital Improvement Plan Software- Finance DATE: November 7, 2022 INTRODUCTION At the present time,the city does not have a formal capital improvement plan (Cl P) process. Staff has been exploring options to establish a formal, annual CI P process. DISCUSSION City staff has viewed a demonstration of a capital improvement plan software product called Plan-It.This capital improvement plan software product provides an efficient way to collect information for future capital projects and equipment purchases. It will provide a project description and justification, estimated expenditure amounts and funding sources. The final output will be a capital improvement plan document that provides a comprehensive list of projects necessary to meet the needs of the city over a five year period and provide organized information for policy decisions. BUDGET IMPACT The cost would be$3,100 and ARPA money would be used as the funding source. ACTION REQUESTED Staff is requesting City Council approval for the purchase of Plan-I t capital improvement plan software. CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: Julie Flaten, Assistant City Administrator/Human Resource Director SUBJECT: Staff Changes and Recommendations- Human Resources DATE: November 7, 2022 INTRODUCTION We are recommending the appointment of Champange Eiklenborg as our newest Police Officer. We are recommending the appointment of John Carpenter as our newest Parks Maintenance Worker. We are also recommending the hiring of two part-time liquor store clerks and four seasonal warming house attendants. DISCUSSION Police Officer Champange Eiklenborg has been selected to be Farmington's newest Police Officer. Champange has her bachelor's degree in Criminal Justice from Winona State University and has been a fulltime police officer in Northfield since 2019. Prior to working in Northfield, she was a Correctional Officer II for the Department of Corrections. We recommend starting Champange at $35.54/hour which is equivalent to the After 1 year step of the LELS pay plan. This is consistent with other police department officer hires who have previous experience. She will begin employment on November 8th Parks Maintenance In April of 2022 the City Council authorized the hiring of two new fulltime Parks Maintenance Worker positions. The first employee was hired in June. Staff is requesting the appointment of John Carpenter to the second fulltime position. John has worked for Cottage Grove and Apple Valley in seasonal roles in Parks and Utilities during both summer and winter seasons. His past supervisors from both cities highly recommend him for this role and we are excited to have him join our team. A start date will be established shortly and in accordance with the collective bargaining agreement John's starting wage will be$26.12/hour. Liquor Store We are recommending the hiring of Lynne Sandstrom and Candy Borgan-Harvey as parttime liquor store clerks. Wages will be paid in accordance with the AFSCME CTP union wage scale. Seasonal—Warming House We are recommending the hiring of Nathan Bartell, Everet Bennett, Madison Dineen, and Leah Dreher as seasonal warming house employees. All four have previously worked for the City. Wages will be paid in accordance with the seasonal wage scale. BUDGET IMPACT Salary for all positions,with the exception of the Parks position, is included in the 2022 budget. Wages for the Parks position are not included in the 2022 adopted budget, but as approved in April wages will be paid from the General Fund. ACTION REQUESTED Approve the appointment of a police officer, parks maintenance worker,two part-time liquor store clerks, and four seasonal warming house employees. CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Julie Flaten, Assistant City Administrator/Human Resource Director SUBJECT: Recalibration of Current Salary Structure- Human Resources DATE: November 7, 2022 INTRODUCTION We are requesting the approval to enter into an agreement with Gallagher Consulting to do a recalibration of our current salary structure through an independent market survey. DISCUSSION Classification and compensation studies are done for many reasons. One of the main reasons is to have an independent analysis of current municipal compensation markets completed to ensure the City is paying wages that are competitive to assist in attracting and retaining top talent. Best practice is for the City to conduct a full compensation and classification study every 8—10 years and update the market data every 1—2 years. The City of Farmington last conducted a full compensation and classification study in 2013 with Gallagher Consulting. An independent market update has not been completed since that time. Gallagher provided the City two options to complete an independent market study and update our current salary structure. Staff is recommending approval of the more cost effective option at $10,500. For this fee Gallagher will review and confirm comparable survey participants as well as benchmark jobs from recent surveys. They will refine and summarize the market data to determine the City's market competitiveness and conduct a regression analysis to determine any needed salary structure adjustments. Once completed Gallagher will provide the City with an updated salary structure to ensure the City has a logical and justifiable wage and salary framework in place. BUDGET IMPACT $7,000 was budgeted in 2022 and $7,000 was budgeted in 2023 for this work. The estimated time to complete this project is 8- 12 weeks,funds from both budget years will cover the cost. ACTION REQUESTED Approve the agreement with Gallagher Human Resources & Compensation Consulting ATTACHMENTS: Type Description D Backup Material Professional Services Agreement M. Gallagher Insurance I Risk Management I Consulting AW MASTER AGREEMENT FOR PROFESSIONAL SERVICES This MASTER AGREEMENT FOR PROFESSIONAL SERVICES("Agreement")entered into as of November 7, 2022 ("Effective Date") is between Gallagher Benefit Services, Inc., a subsidiary of Arthur J. Gallagher&Co., a Delaware corporation ("Gallagher') and the City of Farmington, MN ("Client"). Gallagher and Client desire to arrange for the provision of services by Gallagher to the Client as set forth herein. In consideration of the promises and mutual covenants set forth herein and other good and valuable consideration, the receipt and sufficiency of which is hereby acknowledged, the parties hereto agree as follows: 1. ENGAGEMENT OF SERVICES. From time to time, Gallagher and Client may enter into project assignment(s)for the provision of services provided by Gallagher(each a, "Project Assignment"attached hereto as a sample). The exact nature and scope of the services shall be agreed, and the scope of services shall be detailed in a Project Assignment, and shall be governed by the terms and conditions of this Agreement. 2. SCOPE OF PROJECT ASSIGNMENTS. Gallagher will provide any services, functions, or responsibilities related to the services set forth in the Project Assignment that are: (a) reasonably required for the proper performance and delivery of such services, functions, or responsibilities in accordance with this Agreement, or(b) an inherent part of, or a necessary subpart included within such services, functions or responsibilities. 3. STANDARD FOR PERFORMANCE. Subject to the terms of this Agreement; Gallagher will use its best efforts to render the services and complete the Project Assignment by the applicable completion dates. 4. COMPENSATION. Client will pay Gallagher a fee for services rendered under this Agreement as set forth in the Project Assignment(s)undertaken by Gallagher. Client shall be responsible for all expenses incurred by Gallagher in the performance of its services under this Agreement. Upon termination of this Agreement for any reason, Gallagher will be paid fees specified on the Project Assignment for work which is then in progress on a proportional basis, and expenses incurred through the effective date of such termination. Unless other terms are set forth in the Project Assignment(s)for projects which are in progress, Client will pay Gallagher for services and will reimburse Gallagher for previously approved expenses within thirty(30) days of the date of Gallagher's invoice. Any amounts not paid when due will accrue interest at the rate of one percent (1%) per month or the highest rate permitted by applicable law, whichever is less. If any amount is not paid in full when due without a good faith basis to withhold, that nonpayment will constitute a material breach of this Agreement 5. INDEPENDENT CONTRACTOR RELATIONSHIP. Gallagher's relationship with Client will be that of an independent contractor and nothing in this Agreement should be construed to create a partnership, joint venture, agent-principal, or employer-employee relationship. In the performance of its duties, Gallagher may rely upon, and will have no obligation to independently verify the accuracy, completeness, or authenticity of, any written instructions or information provided to Gallagher by the Client or its designated representatives and reasonably believed by Gallagher to be genuine and authorized by the Client. Furthermore, Gallagher's engagement under this Agreement will not prevent it from taking similar engagements with other clients who may be competitors of the Client. Gallagher will, nevertheless, exercise care and diligence to prevent any actions or conditions which could result in a conflict with Client's best interest. City of Farmington, MN I October 27,2022 ©2022 Arthur J.Gallagher&Co.All rights reserved.Rev.07.08.2021 Page 1 of 7 Gallagher Insurance Risk Management Consulting 6. CONFIDENTIAL&NON-IDENTIFYING INFORMATION. 6.1 Confidential Information.As used in this Agreement, "Confidential Information"means any non-public, proprietary or personal data and information furnished by either party or its agents or representatives to the other party or its agents and representatives, whenever furnished and regardless of the manner or media in which such information is furnished,which the receiving party knows or reasonably should know to be confidential. Each party shall treat Confidential Information as confidential and only use it in the performance of its obligations under this Agreement. The parties acknowledge that Confidential Information includes personal data provided to Gallagher by Client for the benefit of Client and/or its employees to facilitate the performance of services set forth in this Agreement or applicable Project Assignment. Both Parties also agree that the Confidential Information may include information that alone, or in combination with other information, uniquely identifies an individual. Client agrees that Gallagher is permitted to disclose and transfer Client's Confidential Information to Gallagher's affiliates, agents or vendors that have a need to know the Confidential Information in connection with the services provided under this Agreement(including insurance carriers,as necessary, for quoting and/or placing insurance coverages). Gallagher has established security controls to protect Client Confidential Information from unauthorized use or disclosure. For additional information, please review Gallagher's Privacy Policy located at https://www.ajg.com/privacy-policy/. Both Gallagher and Client agree to comply with all state and federal laws, rules, and orders that relate to privacy and data protection which are, or which in the future may be, applicable to Confidential Information,the services or the performance of obligations under this Agreement. Upon request, Gallagher will cooperate with Client pursuant to applicable law(s) to comply with requests from individuals regarding their personal information. 6.2 Non-Identifying Information. Notwithstanding Section 6.1 above, Gallagher may collect, use, transfer, and disclose information in a form that does not specifically identify Client("Non-identifying Information")for any purpose. Non-Identifying Information can include certain organizational and personal information that has been de-identified; that is, information that has been rendered anonymous. Gallagher may obtain Non-Identifying Information about Client from information provided to Gallagher by Client. Furthermore, Gallagher may combine and aggregate Client Non-Identifying Information with information collected from other sources for internal and external research purposes. Gallagher certifies that it shall comply with applicable laws, with respect to privacy and data security relative to Non-Identifying Information. 7. REPRESENTATIONS AND WARRANTIES. 7.1. Gallagher Representations and Warranties. Gallagher represents and warrants that its services shall be performed by personnel possessing competency consistent with applicable industry standards. 7.2. Client Representations and Warranties. Client hereby represents and warrants that: (a) materials provided to Gallagher for use in connection with the services provided hereunder will not infringe the intellectual property rights of any third party; and(b)Client has full right and power to enter into and perform this Agreement without the consent of any third party. City of Farmington, MN I October 27,2022 ©2022 Arthur J.Gallagher&Co.All rights reserved.Rev.07.08.2021 Page 2 of 7 t Gallagher Insurance Risk Management Consulting 7.3. No Other Representations and Warranties. EXCEPT FOR THE REPRESENTATIONS AND WARRANTIES SET FORTH IN THIS AGREEMENT, NO OTHER REPRESENTATION, EXPRESS OR IMPLIED, AND NO WARRANTY OR GUARANTEES ARE INCLUDED OR INTENDED BY GALLAGHER IN THIS AGREEMENT, OR IN ANY REPORT, OPINION, DELIVERABLE, WORK PRODUCT, DOCUMENT OR OTHERWISE. THIS SECTION SETS FORTH THE ONLY WARRANTIES PROVIDED BY GALLAGHER CONCERNING THE MATTERS COVERED BY THIS AGREEMENT. THIS WARRANTY IS MADE EXPRESSLY IN LIEU OF ALL OTHER WARRANTIES, EXPRESS OR IMPLIED, INCLUDING WITHOUT LIMITATION, ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE OR MERCHANTABILITY. 8. LIMITED LIABILITY. Gallagher's liability to the Client and any other party for any losses, injury or damages to persons or properties or work performed arising out of in connection with this Agreement and for any other claim, whether the claim arises in contract, tort, statute or otherwise, shall be limited to the amount of the total fees due to Gallagher from Client for the particular Project Assignment giving rise to the claim. NOTWITHSTANDING ANYTHING TO THE CONTRARY IN THIS AGREEMENT, GALLAGHER SHALL NOT BE LIABLE FOR ANY SPECIAL, INDIRECT, CONSEQUENTIAL, LOST PROFITS, OR PUNITIVE DAMAGES SUSTAINED OR INCURRED IN CONNECTION WITH THIS AGREEMENT, AND WHETHER OR NOT SUCH DAMAGES ARE FORESEEABLE. Client's exclusive remedy for any claim arising out of or relating to this Agreement will be for Gallagher, at its sole option and upon receipt of written notice, either: (a) to use commercially reasonable efforts to cure, at its expense, the matter that gave rise to the claim for which Gallagher is at fault, or (b) return to Client the fees paid by Client to Gallagher for the particular service provided that gives rise to the claim, subject to the limitation contained in this section. Client agrees that it will not allege that this remedy fails its essential purpose. No claim or cause of action, regardless of form (tort, contract, statutory, or otherwise), arising out of, relating to or in any way connected with this Agreement or any services provided hereunder may be brought by either party any later than two(2)years after the accrual of such claim or cause of action. 9. INDEMNIFICATION. Each party agrees to defend, indemnify, and hold the other party and its affiliates and their respective directors, officers, employees, and agents harmless from any and all losses, liabilities, exposures, damages, and all related costs and expenses, including reasonable legal fees,to the extent arising from or relating to any third-party claims, demands, suits, allegations, causes, or threats of action based on the indemnifying party's: (a) breach of any representation, warranty or covenant made by such party hereunder; or (b) grossly negligent acts, omissions, or intentional misconduct; provided, however,that the indemnifying party's indemnification obligations hereunder shall be reduced to the extent that such losses and damages arise from the acts or omissions of the other party or its employees or agents. 10. TERM AND TERMINATION. The term of this Agreement will commence on the Effective Date and shall remain in effect until terminated in accordance with this Agreement. Either party may terminate this Agreement by giving the other party at least sixty (60) days written notice of its intent to terminate. Client shall be responsible to Gallagher for any services performed prior to the date of termination and Gallagher shall be responsible to Client to continue to provide services until the date of termination of this Agreement. Upon termination of the Agreement, contingent upon Client's full payment for services and incurred expenses, Gallagher will deliver to Client any and all of its information, forms and documentation. City of Farmington, MN I October 27, 2022 02022 Arthur J.Gallagher&Co.All rights reserved.Rev.07.08.2021 Page 3 of 7 Gallagher Insurance Risk Management Consulting 11. GENERAL PROVISIONS. 11.1. Assignment and Subcontractors. Client may not assign this Agreement without Gallagher's prior written consent. Gallagher may deem it necessary to outsource or subcontract all or any portion of the services to be performed by it under this Agreement. If this is necessary, Client will be notified of this and has the right to request a professional of their choice. If the person chosen by the Client requires assistance from Gallagher, Client will be billed for Gallagher's time at its regular hourly rate. This Agreement shall inure to the benefit of, and shall be binding upon, both Gallagher and Client and their respective heirs, legal representatives and permitted assigns. 11.2. Travel Expenses. Expenses are to be kept to a minimum and are billed at actual cost for (but not limited to)the following: consultant travel, lodging, meals, local transportation, and airport, meeting, and parking expenses. Hotel expenses will typically be based on preferred rates obtained by Client or Gallagher; however Gallagher may select a non-preferred major chain (e.g., Marriott; Hyatt;etc.) if personal safety factors, geography, or meeting requirements dictate. Charges for airfare will be based on the most economical means of travel wherever possible, however, due to scheduling difficulties, aircraft capacity, and/or fare availability, charges may on occasion include higher cost, refundable fares fees, full coach, or non-refundable business/first class charges. 11.3. Force Majeure. Except for Client's payment obligations under this Agreement, neither party shall be liable for any delay or failure in performance due to causes beyond its reasonable control. 11.4. No Legal Advice Intended. The advice given by Gallagher is not intended to be nor shall should it be construed as legal advice. Client is recommended, at its own cost,to have its own independent legal counsel review all documentation provided by Gallagher. Gallagher will not be obligated to perform, and the Client will not request performance of, any services which may constitute unauthorized practice of law. The Client will be solely responsible for obtaining any legal advice, review or opinion as may be necessary to ensure that its own conduct and operations, including the engagement of Gallagher under the scope and terms as provided herein, conform in all respects with applicable State and Federal laws and regulations (including ERISA, the Internal Revenue Code, State and securities laws and implementing regulations) and, to the extent that the Client has foreign operations, any applicable foreign laws and regulations. 11.5. Severability. In case any one or more of the provisions contained in this Agreement shall, for any reason, be held to be invalid, illegal or unenforceable in any respect, such invalidity, illegality, or unenforceability shall not affect the other provisions of this Agreement, and this Agreement shall be construed as if such invalid, illegal, or unenforceable provision had never been contained herein. 11.6. Notices. All notices, requests and other communications under this Agreement must be in writing, and must be mailed by registered or certified mail, postage prepaid and return receipt requested, delivered by overnight delivery or delivered by hand to the party to whom such notice is required or permitted to be given. If mailed, any such notice will be considered to have been given five (5) business days after it was mailed, as evidenced by the postmark. If delivered by overnight delivery or hand, any such notice will be considered to have been given when received by the party to whom notice is given, as evidenced by written and dated receipt of the receiving party. The mailing address for notice to either party will be the address show on the signature page of Agreement. Either party may change its mailing address by notice as provided by this section. 11.7. Governing Law. The parties agree that this Agreement shall be governed by, interpreted and construed in accordance with the laws of the State of Minnesota without giving effect to the choice of law principles thereof or any canon, custom or rule of law requiring construction against the drafter. City of Farmington, MN I October 27, 2022 02022 Arthur J.Gallagher&Co.All rights reserved.Rev.07.08.2021 Page 4 of 7 Gallagher Insurance I Risk Management I Consulting 11.8. Enforcement. In the event that either party shall successfully bring an action against the other with respect to the enforcement, interpretation, or breach of any provision of this Agreement,the other party shall pay the reasonable amounts incurred by the party bringing the action,specifically including court costs, expenses and reasonable attorneys'fees. 11.9. Waiver. No waiver by either party of any breach of this Agreement shall be a waiver of any preceding or succeeding breach. No waiver by either party of any right under this Agreement shall be construed as a waiver of any other right. Neither party shall be required to give notice to enforce strict adherence to all terms of this Agreement. 11.10. Entire Agreement. This Agreement is the final, complete and exclusive agreement of the parties with respect to the subject matter hereof and supersedes and merges all prior discussions between them. No modification of or amendment to this Agreement, nor any waiver of any rights under this Agreement, will be effective unless in writing and signed by the party to be charged. The terms of this Agreement will govern all Project Assignments and services undertaken by Gallagher for Client. In the event of any conflict between this Agreement and a Project Assignment,the Project Assignment shall control, but only with respect to the matters set forth therein. 11.11. Counterparts. This Agreement may be executed in counterparts, each of which shall be deemed an original but all of which shall constitute one and the same instrument. One or more counterparts of this Agreement may be delivered by facsimile, with such delivery having the same effect as delivery of an original counterpart. IN WITNESS WHEREOF, the parties hereto have caused this Agreement to be duly executed on the date first written above. Client: Gallagher Benefit Services, Inc. r By: By: Name: Name: Michael Verdoorn Title: InA Za(L Title: Managing Principal Date: 0 1-7 12--2- Date: DATE Address: t06 VIP-13 VIP-13Address: 1600 Utica Avenue, Suite 450 ,,MN QZ-2,q St. Louis Park, MN 55416 City of Farmington, MN I October 27,2022 02022 Arthur J.Gallagher&Co.All rights reserved.Rev.07.08.2021 Page 6 of 7 Gallagher Insurance Risk Management Consulting Project Assignment This Project Assignment is issued pursuant to the terms and conditions of the Master Agreement for Professional Services with an Effective Date of November 7, 2022 (the"Agreement"), by and between Gallagher Benefit Services, Inc. ("Gallagher") and the City of Farmington, MN "(Client"). Defined terms used herein and not otherwise defined in this Project Assignment shall have the same meaning ascribed to the in the Agreement. Scope of Services: Compensation Study We will leverage data from recent custom surveys conducted in Minnesota. The data will reflect a similar labor market and positions. We will supplement the data with the League of Minnesota Cities survey database, provided the data is up-to-date. The survey process will include the following components. This approach requires approximately 8-12 weeks to compile and refine data, analyze data and present findings: • Review and confirm the comparable survey participants from recent surveys • Review and confirm the benchmark jobs from recent surveys • Refine data to reflect the City • Summarize market data to determine City market competitiveness • Conduct regression analysis to determine any salary structure adjustments and market relationship adjustments • Recommendations on any salary structure adjustments • Development and presentation of a final report Schedule/Period of Performance: Study will require a maximum of three months for completion. Fees& Expenses: $10,500 Key Assumptions: City provides employee census inclusive of salary data,job title, department, time in position and with the City. City validates job matches used from the City to ensure accurate comparison. Special Requirements: none The terms and conditions contained in this Project Assignment constitute the parties' complete understanding and agreement relating to the subject matter hereof. Notwithstanding anything to the contrary in the Agreement or elsewhere, in the event of a conflict between this Project Assignment and the Agreement,the Agreement will control. No other terms and conditions, beyond those contained herein,will be valid unless mutually agreed to by Client and Gallagher in a writing signed by authorized representatives of each party. City of Farmington, MN I October 27, 2022 02022 Arthur J.Gallagher&Co.All rights reserved.Rev.07.08.2021 Page 6 of 7 Gallagher Insurance Risk Management Consulting ACCEPTED AND AGREED: Client: Gallagher Benefit Services, Inc. By: By: Name: d j Name: Michael Verdoorn Title: MIP\/4-0 Title: Managing Principal Date: I2-2- Date: DATE, 2022 Address: L130 Pflp—D S j Address: 1600 Utica Avenue, Suite 450 St. Louis Park, MN 55416 City of Farmington, MN I October 27, 2022 02022 Arthur J.Gallagher&Co.All rights reserved.Rev.07.08.2021 Page 7 of 7 CITY OF 0 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Kellee Omlid, Parks and Recreation Director SUBJECT: Adopt Resolution Accepting Donation from Farmington VFW Post 7662 to the Halloween Walk—Parks and Recreation DATE: November 7, 2022 INTRODUCTION The Farmington VFW Post 7662 recently donated to the Halloween Walk. DISCUSSION The Farmington VFW Post 7662 recently donated $250.00 to the Halloween Walk. The donated money was used to purchase candy. Rambling River Center members participated in the Halloween Walk as the Peanuts characters. Approximately 1,400 children attended the Halloween Walk, which was held on Friday, October 28. Staff will communicate the city's appreciation on behalf of the city council to the Farmington VFW Post 7662 for this generous donation. BUDGET IMPACT N/A ACTION REQUESTED Adopt the attached resolution accepting the donation of$250.00 from the Farmington VFW Post 7662 to the Halloween Walk. ATTACHMENTS: Type Description D Resolution Donation Resolution RESOLUTION NO. R77-22 ACCEPTING DONATION OF$250.00 FROM THE FARMINGTON VFW POST 7662 TO THE HALLOWEEN WALK Pursuant to due call and notice thereof, a regular meeting of the City Council of the City of Farmington, Minnesota,was held in the council chambers of said City on the 7th day of November 2022 at 7:00 p.m. Members Present: Hoyt, Lien,Wilson Members Absent: Bernhjelm, Porter Member Wilson and Member Lien introduced and seconded the following: WHEREAS, a donation of$250.00 was made by the Farmington VFW Post 7662 to the Halloween Walk; and, WHEREAS, it is required by State Statute that such donation be formally accepted; and, WHEREAS, it is in the best interest of the city to accept this donation. NOW,THEREFORE, BE IT RESOLVED that after due consideration,the Mayor and City Council of the City of Farmington, Minnesota, hereby accepts with gratitude the generous donation of $250.00 from the Farmington VFW Post 7662 to the Halloween Walk. This resolution adopted by recorded vote of the Farmington City Council in o on the 7th day of November 2022. M or Attested to the � day of November 2022. ko (70/vv-,-,/ City A ministrator SEAL