HomeMy WebLinkAboutAgenda_2020_9_28_Meeting(632)
M eeng Locaon :
Farmin gton C ity H all
430 T hird Street
Farmin gton, M N 55024
WAT E R BO A R D R E G U L A R M E E T I NG A G E NDA
September 28, 2020
5:00 P M
1.C A L L TO O R D E R
2.A P P R OV E M I N U T E S
(a)A ppr ove Minutes
3.N E W B U S I N E S S
(a)C ons ider upgrades to City's por table generator - Well No. 9 / Wellhous e 8 I mprovements
U pdate
(b)2021 Fee S chedule-Water Fees
4.A P P R OV E B I L L S
(a)A ppr ove Bills
5.O P E N F O R U M
(a)P roj ect and I nforma0on U pdate
6.A D J O U R N
TO :Water Board Member s , C ity A dminis trator
F R O M :Katy G ehler, P ublic Wor ks D irector
S U B J EC T:A ppr ove Minutes
DAT E:S eptember 28, 2020
I N T R O D U C TI O N
A#ached are the minutes from the J uly 27, 2020 Water Board mee'ng.
D I S C U S S I O N
N/A
B U D G E T I M PA C T
N/A
A C T I O N R EQ U E S T E D
Rev iew, revise and appr ove the minutes.
AT TA C H M E N TS :
Type D es crip'on
Backup M aterial July 27, 2020 M ee'ng M inutes
MINUTES
REGULAR WATER BOARD MEETING
Monday, July 27, 2020
5:00 PM
Conference Room 169
City Hall 430 Third Street Farmington, MN
Members Present: Weierke, Snobeck
Members Absent: None
Staff Present: Katy Gehler, Public Works Director/City Engineer, Sue Miller, Administrative Assistant.
Others Present: None
Call to Order: The meeting was called to order by Chair Weierke at 5:00 p.m.
1. Approve Minutes – June 22, 2020 - MOTION by Snobeck second by Weierke to approve
minutes as presented. APIF, Motion Carried.
2. Water Citations – None
3. New Business – None
4. Approve Bills – Motion by Weierke second by Snobeck to approve the bills, as presented, in the
amount of $63,300.34. APIF, Motion Carried.
5. Open Forum – Project & Information Update
a. COVID-19 Impacts to Operations – Director Gehler updated the members.
b. Well #9 – Tax exemption process still being worked on.
c. Metering System Upgrade – First reading went well. The first reading included the
entire city.
d. Water Efficiency Rebate Program –Director Gehler indicated that the program is going
well and we have had 15 applicants to date.
6. Adjourn – Motion by Weierke, second by Snobeck to adjourn at 5:28 PM. APIF, Motion Carried.
Respectfully submitted,
Sue Miller
Administrative Assistant
TO :Water Board Member s , C ity A dminis trator
F R O M :M a D ecur, A ssistant C ity Engineer
S U B J EC T:C ons ider upgrades to C ity's por table generator - Well N o. 9 / Wellhous e 8
I mpr ovements Update
DAT E:S eptember 28, 2020
I N T R O D U C TI O N
T he C ity aw arded contracts to Barr Engineering in May 2018 to provide des ign s erv ices for Well No. 9
(P has e I ); to Tr aut C ompanies in O ctober 2 0 1 8 for the cons truc3 on of Well N o. 9 (P hase 2 ); and to
Magney C ons tr uc3on for improvements at Wellhous e 8 (P hase 3) in Febr uar y 2019. T his item provides a
s ummary of the w or k completed s ince the las t update (June 2020) and informa3 on on an opportunity to
upgrade the C ity 's portable generator used to pr ovide emergency power to Water U3 lity sites .
D I S C U S S I O N
Magney C ons tr uc3on has completed major w ork at Wells 8 and 9. M inor lands caping repairs remain to
be completed. A S ales Tax Refund Reques t has been s ubmied to the M innes ota D epartment of Revenue
and mus t be appr oved prior to final acceptance and closeout of the project.
D N R G roundw ater S pecialists con3 nue their review of the C ity ’s Water S upply P lan. O nce the P lan is
approved, the D N R and D epartment of H ealth will r ev iew permits for Well 9 . W hen permits are
approved Well 9 can be fully incorporated into the City ’s water s upply sys tem.
D uring des ign of Well 9 and Wellhouse 8, emer gency electrical panels and connec3ons were added at
each loca3on. Bas ed on the Water U3 lity ’s emergency management plan, emer gency power at Wells 8
and 9 during a power outage w ould be prov ided by a r ented generator s ince the C ity ’s only generator
w ould be used to power Well 5 and the control s y s tems (S C A DA ). Therefore, emergency pow er
connec3 ons at Wells 8 and 9 were designed w ith a new Pos i-lok sys tem – different from the A rk3 te
s ystem currently at Wells 3, 4 , and 5.
Pos i-lok is a new er, indus try standard quick connect s y s tem that is installed on mos t new generators .
Pos i-lok cords are divided into 5 connec3ons (ground, neutral, and 3 phas es ), mak ing them easier to
handle than the large bundled A rk3te cords . The 5 Pos i-lok connectors ar e color coded and keyed,
making connec3ons more s traight-forward. Pos i-lok connec3 on panels lock and can only be connected
and disconnected in the pr oper order, preven3 ng dangerous and cos tly cros s -connec3on accidents.
T he C ity ’s por table gener ator does not curr ently hav e connec3ons for the new Pos i-lok emergency
pow er connec3ons at Wells 8 and 9. K illmer Electric has prov ided a propos al to fur nis h and install a 40 0
amp Pos i-lok receptacle panel on the City ’s gener ator at a cos t of $11,000 . This connec3on panel would
replace the 40 0 amp A rk 3te connec3 on. The 400 amp A rk3 te connec3on w as us ed at C ity H all and F ir e
S ta3 on 2 prior to ins talla3 on of permanent gener ator s at those facili3 es.
A cceptance of K illmer ’s pr opos al and ins talla3 on of a Posi-loc receptacle panel on the City ’s generator
w ould allow the C ity to immediately provide emergency pow er to Wells 8 or 9 s hould thos e loca3ons be
affected by a pow er outage w hile Well 5 and the S C A DA sy s tem remain opera3onal and unaffected by
the power outage.
B U D G E T I M PA C T
T he $11,000 cos t for generator upgrades w ould be paid through the cons tr uc3on contract with M agney
Construc3on for Well 9 and Wellhous e 8 I mprov ements. T hat contract curr ently s tands at
$1,329,626.1 5 , down $1,7 7 4 .85 from the $1,3 3 1 ,401 original approved contr act amount.
A C T I O N R EQ U E S T E D
D iscuss and pr ovide direc3on on the propos ed upgrade to the City ’s portable generator.
AT TA C H M E N TS :
Type D es crip3 on
Backup M aterial K illmer propos al
1
Matthew Decur
From:Matthew Pettit <mpettit@killmerelectric.com>
Sent:Thursday, August 27, 2020 2:45 PM
To:Matthew Decur
Cc:Steve Arndt
Subject:Farmington Generator to Well 8 and 9
Matt,
I Reviewed your existing generator this week that has a 480volt setup for wells3, 4, and 5. We can provide and install
the 400amp posilock receptacle panel and put matching end on your cords to make for connections to Wells 8 and
9. We can place same labels similar that you have for other site on generator so the correct voltage selector and
connection type is used.
The cost for this is: $11,000.00
$2,800.00 Labor
$8,200.00 Materials.
Posilock receptacle panel, Posilock plug set, Junction box, DLO copper connection cable, Distribution block as needed
and installation.
Thanks,
Matthew Pettit
Killmer Electric Co, Inc.
5141 Lakeland Ave N
Crystal, MN 55429
Ph. 763-425-2525
Fx. 763-424-1258
Mob. 612-363-3120
TO :Water Board Member s , C ity A dminis trator
F R O M :Katy G ehler, P ublic Wor ks D irector
S U B J EC T:2021 Fee S chedule-Water Fees
DAT E:S eptember 28, 2020
I N T R O D U C TI O N
Each fall, the Water Board and City Council es tablis h fees for city s ervices for the upcoming y ear.
D I S C U S S I O N
Fees set by the Water B oard fall into four categories :
User Rates
D evelopment Fees
Water Tow er C ommunica/on D evice Fees
Water U s e Res tric/on Penal/es
User R ate s
T he user rates are the charges to customers for prov iding the w ater that they us e on a day-to-day
basis. The u/lity funds ar e primarily s uppor ted by revenues generated by the us er rates. G enerally the
city has taken the appr oach of more regular, but s maller increas es to adjus t for infla/on and grow th for
all u/lity funds .
A financial model was dev eloped to annually review the large capital purchas es and rate impacts. S taff
w ill review the C apital I mprovement P lan (C I P ) that is part of this model and s ugges ted rates for 2021.
D eve lopme nt Fees
T he development fees cov er the cost of exis /ng and future trunk w ater infras tructur e to serv e
undev eloped areas of town as w ell as the cos t of a futur e water treatment plant. T he C ons truc/on Cos t
I ndex (C C I ) w as r ev iewed to inform an adjus tment to account for infla/on w ithin this industry. The
adj us tment for 2 0 2 1 is recommended to be 2 %. The proposed 2021 development fees are:
Fee 2 0 2 0 Rate 2 0 2 1 Rate
Water M ain Tr unk Fee $4 ,611 per acre $4 ,703 per acre
WA C Fee (Bldg Permit)$2 ,407 per R E U $2 ,455 per R E U
Water Tower A nt e nnas
T he water tow er communica/on device fees s et the annual charges for cell phone antennas on our water
tow ers as well as gr ound s pace rental rates at the bas e of the tow ers . Thes e fees ar e increas ed 5%
annually to align w ith the 5% annual increas e included in our exis/ng leas es . T he pr opos ed fees for 2021
are:
Fee 2021 M onthly Fee 2021 A nnual Fee
Base L ease R ate (3 ar rays, 3 0 0 s qA ground s pace)$3,741.31 $44,8 9 5 .69
A ddi/onal A ntenna Rate (per array over 3)$1,247.14 $14,9 6 5 .64
A ddi/onal S pace Rental (per s qA over 300 )$6.91 $8 2 .91
Water Use Rest ric!on Penal!e s
T he Water Board has s et a policy for res tric/ng w ater use in the summer months to encourage w ater
cons erva/on. Penal/es for enforcing non-compliance of thes e policies is included in the the City's fee
s chedule and is s how n below. The board s hould dis cus s whether there s hould be r ev is ions to the fees
that are included in the 2021 fee schedule.
Water Use Res tric/on Penal/es
1 s tO ffens e Warning
2 ndO ffens e $50
3 rdand S ubs equent O ffenses $100
B U D G E T I M PA C T
2 021 fees are us ed to pr oject revenues for the 2 0 2 1 budget.
A C T I O N R EQ U E S T E D
Rev iew and dis cus s the fees , then by mo/on, approv e the fees and their inclus ion in the 2021 fee
s chedule that w ill be approv ed by the city council later this fall.
AT TA C H M E N TS :
Type D es crip/on
Backup M aterial 2 021 Water F inancial P lan and C I P
DRAFT 9/24/2020
FUND 6500 - Water Enterprise Fund
Financial Plan Summary
Service Details 2020 2021 2022 2023 2024 2025
Population 24,300 24,700 25,100 25,500 25,900 26,300
Average Day per Capita (Gallons)80 80 80 80 80 80
Connections 7,171 7,309 7,447 7,585 7,723 7,861
New Households 128 138 138 138 138 138
Amount Metered (Gallons)709,560,000 721,240,000 732,920,000 744,600,000 756,280,000 767,960,000
Water Rates
Base Charge 15.00 15.00 15.60 16.22 16.87 17.55
Tier 1 Water Rate (Under 20,000 gal)1.66 1.66 1.73 1.80 1.87 1.94
Tier 2 Water Rate (20,000-40,000 gal)2.5 2.49 2.59 2.69 2.80 2.91
Tier 3 Water Rate (Over 40,000 gal)3.33 3.32 3.45 3.59 3.73 3.88
Base Rate Percent Increase 7.1%0.0%4.0%4.0%4.0%4.0%
Volume Rate Percent Increase 3.7%0.0%4.0%4.0%4.0%4.0%
Beginning Fund Balance:5,340,318$ 5,847,867$ 6,168,902$ 2,063,490$ 2,267,746$ 1,900,405$
Revenues
Enterprise Sales $2,005,510 2,055,444$ 2,156,589$ 2,279,832$ 2,409,484$ 2,545,861$
Revenues from Debt 2,461,488$
Trunk Fund Contributions 280,229$
Other Revenue (Interest, meters, etc.)
Total Revenue 2,005,510$ 2,055,444$ 4,898,306$ 2,279,832$ 2,409,484$ 2,545,861$
Expenses
Operating Expenses 836,507$ 853,237$ 870,301$ 887,707$ 905,462$ 923,571$
Tansfers Operating (personnel)401,868$ 417,943$ 434,661$ 452,047$ 470,129$ 488,934$
Capital Improvement Plan (CIP)170,195$ 372,179$ 7,605,705$ 390,021$ 1,053,685$ 78,650$
Debt Payments 89,391$ 91,050$ 93,050$ 345,800$ 347,550$ 344,050$
Total Expenses 1,497,961$ 1,734,409$ 9,003,717$ 2,075,576$ 2,776,826$ 1,835,205$
Annual Surplus/Deficit 507,549$ 321,035$ (4,105,412)$ 204,256$ (367,341)$ 710,656$
Ending Fund Balance:5,847,867$ 6,168,902$ 2,063,490$ 2,267,746$ 1,900,405$ 2,611,061$
Minimum Fund Balance Goal 400,644$ 410,845$ 672,041$ 682,489$ 687,948$ 698,676$
3 Mo. Operating 309,594$ 317,795$ 326,241$ 334,939$ 343,898$ 353,126$
Debt Payments 91,050$ 93,050$ 345,800$ 347,550$ 344,050$ 345,550$
Rate Variables
Incease 1 Increase 2 Increase 3 Increase 4
Base Rate Increase Year 2019 2021
Base Rate Increase Per Connection $2.00 $0.00
Volume Rate Increase Year 2019 2021
Tier 1 Increase Amount $0.30 $0.00
Default Rate Increase if not Defined Above
General Variables
Estimated Persons Per Household 2.9 2.9 persons per household used for 2040 Comprehensive Plan
Estimated GPCD (gallons/capita/day)80 Average of last ten years 92. Minimum 78. Used 80
O&M Yearly Percent Increase 5.0%Assume 4% inflationary increase plus 1% growth
Interfund Transfer Yearly Percent Increase 4.0%Applied to Personnel Transfers
% Sold in Quarter 1 18%UB Software does not allow Jan. 1 Rate Changes. New Rates implemented April 1. % based on Historical consum
% sold in Qtr 2-4 82%UB Software does not allow Jan. 1 Rate Changes. New Rates implemented April 1. % based on Historical consum
Estimated Usage in Tier 1 55%Based on Infinity.BI consumption reports.
Estimated Usage in Tier 2 20%Based on Infinity.BI consumption reports.
Estimated Usage in Tier 3 25%Based on Infinity.BI consumption reports. All irrigation accounts will be billed at Tier 3
Tier 2 Multiplier 1.5
Tier 3 Multiplier 2.0
4.00%
Fund 6500 - Water Enterprise
Capital Improvement Plan (CIP)
Approx.
Lifespan
Projected
Cost Year 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030
Miscellaneous
Software Update SCADA Software and
Hardware.15 $ 30,000 2015 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 40,800$
Meters New Meters 15 $ 2,000,000 2026 -$ -$ -$ -$ -$ -$ 2,480,000$ -$ -$ -$ -$
Study Arc Flash Hazard
Assessment/Study $ 15,000 2015 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Study Water Supply & Distribution Plan 10 $ 50,000 2017 -$ -$ -$ -$ -$ -$ -$ 63,500$ -$ -$ -$
Distribution Watermain replacement with
Street Projects 58,895$ 284,979$ 1,146,105$ 390,021$ 1,053,685$ -$ -$ -$ 439,137$ 666,489$ -$
Fleet -$ -$ 299,600$ -$ -$ 78,650$ -$ 19,050$ -$ 332,500$ 285,600$
Wells
1 Routine Maintenance (pull well,
check pipe, shaft, motor, bail)7 -$ RETIRED
3 Routine Maintenance (pull well,
check pipe, shaft, motor, bail)7 $ 40,000 2019 -$ -$ -$ -$ -$ -$ 49,600$ RETIRED
4 Routine Maintenance (pull well,
check pipe, shaft, motor, bail)7 $ 40,000 2021 -$ 43,600$ -$ -$ -$ -$ -$ -$ 52,000$ -$ -$
5 Routine Maintenance (pull well,
check pipe, shaft, motor, bail)7 $ 40,000 2020 42,400$ -$ -$ -$ -$ -$ -$ 50,800$ -$ -$ -$
6 Routine Maintenance (pull well,
check pipe, shaft, motor, bail)7 $ 40,000 2019 -$ -$ -$ -$ -$ -$ 49,600$ -$ -$ -$ -$
7 Routine Maintenance (pull well,
check pipe, shaft, motor, bail)7 $ 40,000 2020 42,400$ -$ -$ -$ -$ -$ -$ 50,800$ -$ -$ -$
8 Routine Maintenance (pull well,
check pipe, shaft, motor, bail)7 $ 40,000 2021 -$ 43,600$ -$ -$ -$ -$ -$ -$ 52,000$ -$ -$
9 Routine Maintenance (pull well,
check pipe, shaft, motor, bail)7 $ 40,000 2026 -$ -$ -$ -$ -$ -$ 49,600$ -$ -$ -$ -$
10 Routine Maintenance (pull well,
check pipe, shaft, motor, bail)7 $ 40,000 2033 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
11 Routine Maintenance (pull well,
check pipe, shaft, motor, bail)7 $ 40,000 2042 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
12 Routine Maintenance (pull well,
check pipe, shaft, motor, bail)7 $ 40,000 2045 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
1,2 Seal and Abandon $ 25,000 2020 26,500$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
3 Seal and Abandon $ 25,000 2027 -$ -$ -$ -$ -$ -$ -$ 31,750$ -$ -$ -$
4 Seal and Abandon $ 25,000 2036 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
9 Construction (Replaces 1/2) $ 1,942,926 2019 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
10 Construction (Replaces 3) $ 1,200,000 2026 -$ -$ -$ -$ -$ -$ 1,488,000$ -$ -$ -$ -$
11 Construction (Replaces 4) $ 1,200,000 2035 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
12 Construction $ 1,200,000 2038 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Towers
Municipal
Campus Painting 20 $ 1,600,000 2019 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Daisy Knoll Abandon with cell structure -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
New Tower 1 Painting 20 $ 1,600,000 2042 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
New Tower 2 Painting 20 $ 1,600,000 2065 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
New Tower 1 Construction 100 $ 5,500,000 2022 -$ -$ 6,160,000$ -$ -$ -$ -$ -$ -$ -$ -$
New Tower 2 Construction 100 $ 5,500,000 2045 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
TOTAL ANNUAL CIP 170,195$ 372,179$ 7,605,705$ 390,021$ 1,053,685$ 78,650$ 4,116,800$ 215,900$ 543,137$ 998,989$ 326,400$
TO :Water Board Member s , C ity A dminis trator
F R O M :Katy G ehler, P ublic Wor ks D irector
S U B J EC T:A ppr ove Bills
DAT E:S eptember 28, 2020
I N T R O D U C TI O N
T he bills from J uly 2 3 , 2020 to S eptember 22, 2 0 2 0 ar e a'ached for review and approv al.
D I S C U S S I O N
N/A
B U D G E T I M PA C T
N/A
A C T I O N R EQ U E S T E D
Rev iew, dis cus s , and approv e the bills .
AT TA C H M E N TS :
Type D es crip-on
Backup M aterial Water Board Bills
9/23/2020CITY OF FARMINGTON 9:04:40R55CKS2LOGIS600V
1Page -Council Check SummaryNote: Payment amount may not reflect the actual amount due to data sequencing and/or data selection.
9/22/20207/23/2020 -
Check #AmountDate Supplier / Explanation PO#Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div
151966 7/24/2020 100025 CINTAS CORP LOC 754
06500 08629043.31 6502JUN'20 WEEKLY UNIFORM SERVICES 186185 4052189110 UNIFORMS & CLOTHING WATER UTILITY EXPENSE
43.31
151967 7/24/2020 116853 CLIMATE MAKERS INC
06500 08651578.35 6502CMF BLDG AUTOMATN SYSTM REPAIR 186023 101222 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE
78.35
151972 7/24/2020 100030 CORE & MAIN, LP
06500 086220205.90 6502CURB BOX REPAIR LID 186015 M578654 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
205.90
151984 7/24/2020 100024 GOPHER STATE ONE-CALL
06500 086401217.35 6502JUNE 2020 LOCATES 185833 0060387 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
217.35
151994 7/24/2020 116827 JOHNSON LITHO GRAPHICS OF EAU CLAIRE LTD
06500 086445274.50 6502FALL'20 CURRENTS POSTAGE 186232 100547 POSTAGE WATER UTILITY EXPENSE
274.50
151997 7/24/2020 100049 LOCAL GOVERNMENT INFORMATION SYSTEMS
06500 086402968.00 6502JUN'20 APPL SUPPORT INVOICE 185841 48951 DATA PROCESSING WATER UTILITY EXPENSE
968.00
152000 7/24/2020 114625 MASTER MECHANICAL, INC
06500 08651548.51 6502HVAC REPAIR 186244 57128 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE
48.51
152004 7/24/2020 113031 NRG RELIABILITY SOLUTIONS LLC
06500 086422392.22 6502JUN'20 ELEC CMF 186001 3347-2007 ELECTRIC WATER UTILITY EXPENSE
392.22
152006 7/24/2020 101254 ORKIN EXTERMINATING, LLC
06500 08651520.63 6502JUN'20 PEST CONTROL CMF 186198 198271320/28367911 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE
20.63
152044 7/31/2020 107123 GS DIRECT INC
06500 08622027.49 6502PLOTTER INK 186386 357435 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
27.49
152056 7/31/2020 113442 METERING & TECHNOLOGY SOLUTIONS
06500 086220225.92 6502ORION MODULE 186017 17325 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
225.92
152091 8/7/2020 100025 CINTAS CORP LOC 754
06500 08629043.31 6502JUL'20 WEEKLY UNIFORM SERVICES 186182 4055344434 UNIFORMS & CLOTHING WATER UTILITY EXPENSE
06500 08629043.31 6502JUL'20 WEEKLY UNIFORM SERVICES 186247 4055910173 UNIFORMS & CLOTHING WATER UTILITY EXPENSE
06500 08629043.31 6502JUL'20 WEEKLY UNIFORM SERVICES 186548 4057202166 UNIFORMS & CLOTHING WATER UTILITY EXPENSE
9/23/2020CITY OF FARMINGTON 9:04:40R55CKS2LOGIS600V
2Page -Council Check SummaryNote: Payment amount may not reflect the actual amount due to data sequencing and/or data selection.
9/22/20207/23/2020 -
Check #AmountDate Supplier / Explanation PO#Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div
06500 08629043.75 6502JUL'20 WEEKLY UNIFORM SERVICES 186551 4056564256 UNIFORMS & CLOTHING WATER UTILITY EXPENSE
173.68
152100 8/7/2020 111431 FERGUSON WATERWORKS
06500 0862202,915.32 6502AFC MOD KIT: HYDRANT PARTS 186012 0456680 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
2,915.32
152112 8/7/2020 111068 JOHN HENRY FOSTER MN, INC
06500 08622018.32 6502AIR COMPRESSOR PART 186248 10495609-00 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
18.32
152117 8/7/2020 113442 METERING & TECHNOLOGY SOLUTIONS
06500 0864015,000.00 6502BEACON ENGAGEMENT FEE: SERVICE 186530 17253 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
5,000.00
152120 8/7/2020 100070 MINNESOTA VALLEY TESTING LABORATORIES
06500 086401110.00 6502BAC-T SAMPLE (10)/MTHLY REPORT 186142 1040963 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
110.00
152125 8/7/2020 100093 PELLICCI HARDWARE & RENTAL
06500 08622021.99 6502TIE DOWN RATCHET 186134 K37103/F EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
06500 0862201.20 6502VAC BAGS AND SPRAYER 186179 K37078/F EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
06500 08624262.00 6502FLOOR CLEANER 186268 23353/F CLEANING SUPPLIES WATER UTILITY EXPENSE
06500 08624248.65 6502PAPER TWLS/MLT-FLD TWLS 186272 18927/F CLEANING SUPPLIES WATER UTILITY EXPENSE
06500 0862427.55 6502PAPER TOWELS 186274 K37390/F CLEANING SUPPLIES WATER UTILITY EXPENSE
06500 0862421.49 6502TOILET BOWL CLEANER 186538 27357/F CLEANING SUPPLIES WATER UTILITY EXPENSE
06500 08624231.59 6502RESTROOM DISINFECTANT 186540 39654/F CLEANING SUPPLIES WATER UTILITY EXPENSE
06500 0862423.75 6502DISPOSABLE GLOVES 186541 K37589/F CLEANING SUPPLIES WATER UTILITY EXPENSE
06500 086242.95 6502STEEL WOOL/BRKPRS FRND/TILE CL 186616 37683/F '20 CLEANING SUPPLIES WATER UTILITY EXPENSE
179.17
152128 8/7/2020 108759 PROFESSIONAL BEVERAGE SYSTEMS INC II
06500 08650533.12 6502ICE MACHINE REPAIR 186542 47980 EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE
33.12
152136 8/7/2020 108220 SOUTH METRO RENTAL INC
06500 086950300.84 6502CHOP SAW/BLADES 186234 106783 MACHINERY, EQUIPMENT & TOOLS WATER UTILITY EXPENSE
300.84
152140 8/7/2020 112307 T-MOBILE USA INC
06500 0864126.67 6502JUL'20 GPS SERVICE 186528 823329497 JULY'20 CELLULAR SERVICES WATER UTILITY EXPENSE
6.67
152144 8/7/2020 111267 WATER CONSERVATION SERVICE, INC
06500 086401321.90 6502LOCATE LEAK EUCLID WAY/ST 186508 10592 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
321.90
152151 8/14/2020 100112 BADGER METER INC
9/23/2020CITY OF FARMINGTON 9:04:40R55CKS2LOGIS600V
3Page -Council Check SummaryNote: Payment amount may not reflect the actual amount due to data sequencing and/or data selection.
9/22/20207/23/2020 -
Check #AmountDate Supplier / Explanation PO#Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div
06500 086950412.80 6502BADGER METER BEACONS (6,880)186796 80057720 MACHINERY, EQUIPMENT & TOOLS WATER UTILITY EXPENSE
412.80
152158 8/14/2020 100030 CORE & MAIN, LP
06500 086220250.00 6502GATE VALVE BOX 186509 M717964 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
250.00
152172 8/14/2020 100007 HAWKINS INC
06500 08626020,217.41 6502WELL CHEMICALS 186496 4758971 CHEMICALS WATER UTILITY EXPENSE
20,217.41
152173 8/14/2020 109232 HELM ELECTRIC INC
06500 0865051,154.99 6502REPLACE PUMP WIRES WELL 8 186714 13989B EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE
1,154.99
152175 8/14/2020 112416 IMPACT MAILING OF MN, INC
06500 086445188.87 6502JUL'20 UB BILL POSTAGE 186713 148561 POSTAGE WATER UTILITY EXPENSE
06500 08640138.48 6502JUL'20 UB MAIL PREP 186713 148561 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
227.35
152181 8/14/2020 114625 MASTER MECHANICAL, INC
06500 08651548.50 6502AC REPAIR 186754 57374 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE
48.50
152187 8/14/2020 100070 MINNESOTA VALLEY TESTING LABORATORIES
06500 086401105.00 6502BAC-T SAMPLE (10)186443 1041994 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
105.00
152201 8/14/2020 109843 SPOK, INC.
06500 0864122.64 6502AUG'20 PAGER CONTRACT 186675 D0317419T CELLULAR SERVICES WATER UTILITY EXPENSE
2.64
152260 8/21/2020 116827 JOHNSON LITHO GRAPHICS OF EAU CLAIRE LTD
06500 086450743.75 6502FALL'20 CURRENTS PRINTING 187012 100675 OUTSIDE PRINTING WATER UTILITY EXPENSE
743.75
152271 8/21/2020 113031 NRG RELIABILITY SOLUTIONS LLC
06500 086422423.08 6502JULY'20 CMF ELECTRIC 186984 3347-2008 ELECTRIC WATER UTILITY EXPENSE
423.08
152296 8/21/2020 116842 TRAUT COMPANIES
06500 08695013,668.00 6502INSTALL NEW VFD WELL 8 186829 328571 MACHINERY, EQUIPMENT & TOOLS WATER UTILITY EXPENSE
13,668.00
152316 8/28/2020 100030 CORE & MAIN, LP
06500 086220430.90 6502HYDRANT PARTS 187077 M789225 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
430.90
152318 8/28/2020 110844 DAKOTA COUNTY FINANCIAL SRVS
9/23/2020CITY OF FARMINGTON 9:04:40R55CKS2LOGIS600V
4Page -Council Check SummaryNote: Payment amount may not reflect the actual amount due to data sequencing and/or data selection.
9/22/20207/23/2020 -
Check #AmountDate Supplier / Explanation PO#Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div
06500 08627274.43 6502JUL'20 DIESEL FUEL 187208 00038902 FUEL WATER UTILITY EXPENSE
74.43
152325 8/28/2020 100024 GOPHER STATE ONE-CALL
06500 086401163.35 6502JULY 2020 LOCATES 186726 0070386 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
163.35
152326 8/28/2020 100044 GRAINGER INC
06500 086950103.34 6502EXHAUST FAN WELL 3 186733 9610066848 MACHINERY, EQUIPMENT & TOOLS WATER UTILITY EXPENSE
103.34
152339 8/28/2020 100049 LOCAL GOVERNMENT INFORMATION SYSTEMS
06500 086402968.00 6502JUL'20 APPL SUPPORT INVOICE 186789 49045 DATA PROCESSING WATER UTILITY EXPENSE
968.00
152344 8/28/2020 102725 MINNESOTA DEPT OF HEALTH
06500 08656016,759.00 65023RD QTR 2020 SVS CONNECT FEES 187133 1190008 JULY- SEPT CONTRACTUAL SERVICES WATER UTILITY EXPENSE
16,759.00
152382 9/4/2020 100025 CINTAS CORP LOC 754
06500 08629043.31 6502AUG'20 WEEKLY UNIFORM SERVICES 186745 4057855534 UNIFORMS & CLOTHING WATER UTILITY EXPENSE
06500 08629043.31 6502AUG'20 WEEKLY UNIFORM SERVICES 186988 4058488799 UNIFORMS & CLOTHING WATER UTILITY EXPENSE
06500 08629043.31 6502AUG'20 WEEKLY UNIFORM SERVICES 187249 4059171993 UNIFORMS & CLOTHING WATER UTILITY EXPENSE
06500 08629043.31 6502AUG'20 WEEKLY UNIFORM SERVICES 187332 4059774553 UNIFORMS & CLOTHING WATER UTILITY EXPENSE
173.24
152385 9/4/2020 100030 CORE & MAIN, LP
06500 086950253.76 6502HYDRANT WRENCHES (2)187134 M824170 MACHINERY, EQUIPMENT & TOOLS WATER UTILITY EXPENSE
253.76
152390 9/4/2020 109931 FACTORY MOTOR PARTS
06500 086220313.58 6502BATTERIES FOR 0004 187073 1-6496884 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
313.58
152394 9/4/2020 109232 HELM ELECTRIC INC
06500 086505223.03 6502REPAIR OUTLETS AT WELLS 3/4 187320 14008B EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE
223.03
152399 9/4/2020 100031 JIRIK SOD FARMS, INC
06500 08625540.00 6502EROSION BLANKET 187322 46068 LANDSCAPING MATERIALS WATER UTILITY EXPENSE
40.00
152402 9/4/2020 110766 JOHNSON CONTROLS FIRE PROTECTION LP
06500 08651540.71 65021ST ST GAR ALARM MONITRNG 187243 21774062 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE
40.71
152407 9/4/2020 100070 MINNESOTA VALLEY TESTING LABORATORIES
06500 08640168.00 6502BAC-T SAMPLE (6)/MTHLY REPORT 186827 1045332 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
9/23/2020CITY OF FARMINGTON 9:04:40R55CKS2LOGIS600V
5Page -Council Check SummaryNote: Payment amount may not reflect the actual amount due to data sequencing and/or data selection.
9/22/20207/23/2020 -
Check #AmountDate Supplier / Explanation PO#Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div
68.00
152410 9/4/2020 101254 ORKIN EXTERMINATING, LLC
06500 08651520.42 6502JUL'20 PEST CONTROL CMF 187251 199394028/28367911 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE
20.42
152412 9/4/2020 100093 PELLICCI HARDWARE & RENTAL
06500 0862428.00 6502GLASS CLEANER 186744 K37761/F CLEANING SUPPLIES WATER UTILITY EXPENSE
06500 0869501.75 6502TAPE MEASURE-35'186753 K37788/F MACHINERY, EQUIPMENT & TOOLS WATER UTILITY EXPENSE
06500 086220.30 6502WD 40 186757 37911/F EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
06500 0862409.50 6502FLOOR FINISH AND SUPPLIES 186989 46608/F BUILDING SUPPLIES & PARTS WATER UTILITY EXPENSE
06500 08622034.96 6502HYDRANT PAINT SUPPLIES 187108 K38083/F EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
06500 0862422.39 6502WALL CLEANING PADS 187258 52180/F CLEANING SUPPLIES WATER UTILITY EXPENSE
06500 08624235.00 6502PAPER TOWELS 187259 52408/F CLEANING SUPPLIES WATER UTILITY EXPENSE
06500 086220.60 6502WD40187336K38294/F EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
06500 0862425.07 6502TIDE 160 POWDER 187410 K38429/F CLEANING SUPPLIES WATER UTILITY EXPENSE
97.57
152424 9/4/2020 112307 T-MOBILE USA INC
06500 0864126.67 6502AUG'20 GPS SERVICE 187303 823329497 AUG'20 CELLULAR SERVICES WATER UTILITY EXPENSE
6.67
152427 9/4/2020 111267 WATER CONSERVATION SERVICE, INC
06500 086401403.10 6502LOCATE WATER LEAK 187305 10644 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
403.10
152445 9/11/2020 100030 CORE & MAIN, LP
06500 086220160.00 6502BLUE MARKING FLAGS 187139 M841874 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
160.00
152454 9/11/2020 112416 IMPACT MAILING OF MN, INC
06500 08640150.66 6502AUG'20 UB MAIL PREP 187435 148961 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
06500 086445243.38 6502AUG'20 UB BILL POSTAGE 187435 148961 POSTAGE WATER UTILITY EXPENSE
294.04
152464 9/11/2020 100070 MINNESOTA VALLEY TESTING LABORATORIES
06500 08640173.50 6502BAC-T SAMPLE (7)187106 1046408 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
73.50
152467 9/11/2020 101254 ORKIN EXTERMINATING, LLC
06500 08651520.42 6502AUG'20 PEST CONTROL CMF 187334 200672222/28367911 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE
20.42
152482 9/18/2020 100058 ADVANCE AUTO PARTS
06500 08622028.49 6502BRAKE BATTERY FOR 0004 187606 2131-540793 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
28.49
152483 9/18/2020 100192 AGGREGATE INDUSTRIES - MWR, INC
9/23/2020CITY OF FARMINGTON 9:04:40R55CKS2LOGIS600V
6Page -Council Check SummaryNote: Payment amount may not reflect the actual amount due to data sequencing and/or data selection.
9/22/20207/23/2020 -
Check #AmountDate Supplier / Explanation PO#Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div
06500 08625076.36 6502G.V. REPAIR EUCLID ST/WAY 187584 713074461 OTHER SUPPLIES & PARTS WATER UTILITY EXPENSE
06500 08625079.06 6502G.V. REPAIR EUCLID ST/WAY 187585 713081462 OTHER SUPPLIES & PARTS WATER UTILITY EXPENSE
155.42
152489 9/18/2020 102087 AUTOMATIC SYSTEMS COMPANY
06500 086505397.75 6502WORK ON SCADA COMPUTER 187323 35272S EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE
397.75
152490 9/18/2020 100112 BADGER METER INC
06500 086505413.16 6502AUG'20 BEACON HSTNG SVS FEES 187543 80059352 EQUIPMENT REPAIR/MAINTENANCE WATER UTILITY EXPENSE
413.16
152503 9/18/2020 116853 CLIMATE MAKERS INC
06500 086515113.85 6502HVAC REPAIR 187338 101691 BUILDING REPAIR/MAINTENANCE WATER UTILITY EXPENSE
113.85
152517 9/18/2020 111431 FERGUSON WATERWORKS
06500 0862202,992.32 6502REBUILD HYDRANT 621 PARK DR 187590 0461283 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
2,992.32
152526 9/18/2020 100007 HAWKINS INC
06500 08626020,026.55 6502WELL CHEMICALS 187273 4780183 CHEMICALS WATER UTILITY EXPENSE
06500 0862201,335.00 6502CHLORINE VACUUM REGULATOR 187274 4780225 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
21,361.55
152540 9/18/2020 100070 MINNESOTA VALLEY TESTING LABORATORIES
06500 08640173.50 6502BAC-T SAMPLE (7)187280 1047433 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
73.50
152555 9/18/2020 109843 SPOK, INC.
06500 0864122.64 6502SEPT'20 PAGER CONTRACT 187328 D0317419U CELLULAR SERVICES WATER UTILITY EXPENSE
2.64
20200713 7/24/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION
06500 08642318.00 6502JUN'20 GAS WELL HOUSE 1 OAK ST 185820 0506788875-JUNE'20 NATURAL GAS WATER UTILITY EXPENSE
18.00
20200715 7/31/2020 109509 US BANK
06500 08712015,525.00 6502SERIES 2019A 2020 INT WATER 185397 1613279 DEBT INTEREST WATER UTILITY EXPENSE
15,525.00
20200717 7/30/2020 114654 INVOICE CLOUD
06500 086545549.02 6502JUN'20 IC PYMT FEES 186452 819-2020_6 PYMT PROCESSING FEES WATER UTILITY EXPENSE
549.02
20200720 7/27/2020 100085 DAKOTA ELECTRIC ASSOCIATION
06500 08642215.88 6502JUN'20 ELEC WELL#9 185830 200010028004
JUNE'20
ELECTRIC WATER UTILITY EXPENSE
9/23/2020CITY OF FARMINGTON 9:04:40R55CKS2LOGIS600V
7Page -Council Check SummaryNote: Payment amount may not reflect the actual amount due to data sequencing and/or data selection.
9/22/20207/23/2020 -
Check #AmountDate Supplier / Explanation PO#Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div
15.88
20200802 8/3/2020 100085 DAKOTA ELECTRIC ASSOCIATION
06500 0864222,711.05 6502JUN'20 ELEC WELL #5 186139 200002785533
JUNE'20
ELECTRIC WATER UTILITY EXPENSE
06500 08642223.44 6502JUN'20 ELEC DAISY KNOLL TOWER 186664 200001318518
JUNE'20
ELECTRIC WATER UTILITY EXPENSE
06500 0864221,998.96 6502JUN'20 ELEC WELL #4 186665 200001318526
JUNE'20
ELECTRIC WATER UTILITY EXPENSE
06500 0864223,258.54 6502JUN'20 ELEC WELL #6 186666 200001550151
JUNE'20
ELECTRIC WATER UTILITY EXPENSE
06500 0864222,568.27 6502JUN'20 ELEC WELL #7 186667 200003490737
JUNE'20
ELECTRIC WATER UTILITY EXPENSE
06500 086422153.12 6502JUN'20 ELEC 195TH WATER TOWER 186668 200002587095
JUNE'20
ELECTRIC WATER UTILITY EXPENSE
06500 0864222,274.64 6502JUN'20 ELEC WELL #8 186670 200004199709
JUNE'20
ELECTRIC WATER UTILITY EXPENSE
12,988.02
20200807 8/5/2020 100394 XCEL ENERGY
06500 086422105.44 6502JUN'20 ELEC CITY GARAGE 186227 51-4874005 JUNE'20 ELECTRIC WATER UTILITY EXPENSE
06500 0864223,093.06 6502JUN'20 ELEC WELL #1 & 3 186227 51-4874005 JUNE'20 ELECTRIC WATER UTILITY EXPENSE
3,198.50
20200812 8/14/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION
06500 08642318.00 6502JUL'20 GAS WELL #5 186506 0507120636 JULY'20 NATURAL GAS WATER UTILITY EXPENSE
18.00
20200817 8/18/2020 111046 VOYAGER FLEET SYSTEMS INC
06500 086272312.83 6502JUL'20 FUEL WATER 186499 869088237030 WATER FUEL WATER UTILITY EXPENSE
06500 0862726.02 6502JUL'20 FUEL BLDG MAINT 186632 869088237030 BLD
MAINT
FUEL WATER UTILITY EXPENSE
06500 0862723.12 6502JUL'20 FUEL JANITORIAL 186633 869088237030
JANITORIAL
FUEL WATER UTILITY EXPENSE
321.97
20200820 8/24/2020 100085 DAKOTA ELECTRIC ASSOCIATION
06500 08642257.35 6502JUL'20 ELEC WELL#9 186671 200010028004
JULY'20
ELECTRIC WATER UTILITY EXPENSE
57.35
20200824 8/28/2020 102160 CARDMEMBER SERVICES
06500 0869501,314.10 6502(2) AIR CONDITIONERS FOR WATER 186517 4021-4135-7/24 MACHINERY, EQUIPMENT & TOOLS WATER UTILITY EXPENSE
1,314.10
20200902 9/2/2020 114654 INVOICE CLOUD
9/23/2020CITY OF FARMINGTON 9:04:40R55CKS2LOGIS600V
8Page -Council Check SummaryNote: Payment amount may not reflect the actual amount due to data sequencing and/or data selection.
9/22/20207/23/2020 -
Check #AmountDate Supplier / Explanation PO#Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div
06500 086545579.16 6502JUL'20 PAYMENT FEES 187407 819-2020_7 PYMT PROCESSING FEES WATER UTILITY EXPENSE
579.16
20200905 9/2/2020 100394 XCEL ENERGY
06500 0864224,346.30 6502JUL'20 ELEC WELL #1 & 3 186828 51-4874005-0
JULY'20
ELECTRIC WATER UTILITY EXPENSE
06500 086422129.72 6502JUL'20 ELEC CITY GARAGE 186828 51-4874005-0
JULY'20
ELECTRIC WATER UTILITY EXPENSE
4,476.02
20200906 9/8/2020 100085 DAKOTA ELECTRIC ASSOCIATION
06500 0864223,568.23 6502JUL'20 ELEC WELL #8 186780 200004199709
JULY'20
ELECTRIC WATER UTILITY EXPENSE
06500 0864222,666.82 6502JUL'20 ELEC WELL #6 186781 200001550151
JULY'20
ELECTRIC WATER UTILITY EXPENSE
06500 0864222,527.63 6502JUL'20 ELEC WELL #4 186782 200001318526
JULY'20
ELECTRIC WATER UTILITY EXPENSE
06500 08642224.50 6502JUL'20 ELEC DAISY KNOLL TOWER 186783 200001318518
JULY'20
ELECTRIC WATER UTILITY EXPENSE
06500 0864222,472.99 6502JUL'20 ELEC WELL #7 186784 200003490737
JULY'20
ELECTRIC WATER UTILITY EXPENSE
06500 086422163.21 6502JUL'20 ELEC 195TH WATER TOWER 186786 200002587095
JULY'20
ELECTRIC WATER UTILITY EXPENSE
06500 0864223,812.39 6502JUL'20 ELEC WELL #5 186787 200002785533
JULY'20
ELECTRIC WATER UTILITY EXPENSE
15,235.77
20200909 9/8/2020 114654 INVOICE CLOUD
06500 086545447.63 6502AUG'20 IC PYMT FEES 187658 819-2020_8 PYMT PROCESSING FEES WATER UTILITY EXPENSE
447.63
20200910 9/17/2020 111046 VOYAGER FLEET SYSTEMS INC
06500 0862722.74 6502AUG'20 FUEL BLDG MAINT 187262 869088237035 BLDG
MAINT
FUEL WATER UTILITY EXPENSE
06500 0862722.05 6502AUG'20 FUEL JANITORIAL 187263 869088237035
JANITORIAL
FUEL WATER UTILITY EXPENSE
06500 086272197.68 6502AUG'20 FUEL WATER 187276 869088237035 WATER FUEL WATER UTILITY EXPENSE
202.47
20200911 9/17/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION
06500 08642318.00 6502AUG'20 GAS WELL #5 187272 0507120636-AUG'20 NATURAL GAS WATER UTILITY EXPENSE
06500 08642313.04 6502AUG'20 GAS CMF 187547 0502362190 AUG'20 NATURAL GAS WATER UTILITY EXPENSE
31.04
20200912 9/18/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION
9/23/2020CITY OF FARMINGTON 9:04:40R55CKS2LOGIS600V
9Page -Council Check SummaryNote: Payment amount may not reflect the actual amount due to data sequencing and/or data selection.
9/22/20207/23/2020 -
Check #AmountDate Supplier / Explanation PO#Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div
06500 0864237.43 6502AUG'20 GAS 1ST STREET GARAGE 187546 0505547424 AUG'20 NATURAL GAS WATER UTILITY EXPENSE
7.43
20200913 9/14/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION
06500 08642318.00 6502AUG'20 GAS WELL HOUSE 1 OAK ST 187329 0506788875 AUG'20 NATURAL GAS WATER UTILITY EXPENSE
18.00
20200919 8/21/2020 108980 MINNESOTA ENERGY RESOURCES CORPORATION
06500 08642310.78 6502JUL'20 GAS CMF 186642 0502362190 JULY'20 NATURAL GAS WATER UTILITY EXPENSE
06500 0864238.91 6502JUL'20 GAS 1ST STREET GARAGE 186644 0505547424 JULY'20 NATURAL GAS WATER UTILITY EXPENSE
06500 08642321.60 6502JUL'20 GAS WELL HOUSE 1 OAK ST 186663 0506788875 JULY'20 NATURAL GAS WATER UTILITY EXPENSE
41.29
Report Totals 150,085.11
TO :Water Board Member s , C ity A dminis trator
F R O M :Katy G ehler, P ublic Wor ks D irector
S U B J EC T:P roj ect and I nforma on U pdate
DAT E:S eptember 28, 2020
I N T R O D U C TI O N
S taff w ill provide an update on the follow ing items :
C O V I D -1 9 I mpacts to opera ons
Water U s e Res tric ons Enforcement 2020
Metering S ys tem U pgrade
Water Efficiency Rebate P rogram
O ther
AT TA C H M E N TS :
Type D es crip on
Backup M aterial Water Cita on L og
Backup M aterial Water Rebates L og
2020 Log of Water Use Restriction Citations
Date Address Time Issued by 12-6 Ban Odd/Even Auto/Ind Photo#Offence#Appeal NOTES
1 6/2/2020 18725 Englewood Way 2:26 p.m.KS X X Ind
18725EW_01
18725EW_02 Warning
2 6/25/2020 713 Second Street 4:46 PM KAG X Ind Observation Warning
3 7/15/2020 20295 Erickson Path 2:01 p.m.SA X Auto Observation Warning
4 7/17/2020 18180 Empire Trail 10:02 a.m.KS X Ind 18180ET_01 Warning
5 8/11/2020 5375 203rd Street W 1:10 p.m.SA X Auto Observation Warning
6 9/8/2020 2881 213th Street 4:25 p.m.KS X X NA IMG_2487 Warning Eternity Homes owns lot
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
2020-2021 Water Efficiency Rebate Grant Tracking
$8,000 Max $6,000 Max
Row#
Date
Application
Received
Application
Approved/
Denied
Date
Application
Approved/
Denied
Date Rebate
Credited to UB
Account
UB
Account #
UB
Customer #Account Holder Name Property Street Address and Zip Code
Property
Type
(Select):
Water Device Replaced
(Select):
Cost per
Device:
# of
Devices
Rebate or
Grant per
device
Est. Annual
Water Saved
per Device
(Gallons)
Total Rebate
or UB Credit
Municipality
Contribution
Eligible Grant
Amount
Estimated
Annual Water
Saved
(Gallons)
Cumulative
Rebate Total
Cumulative
Municipality
Contribution
Cumulative
MCES Grant
Amount
1 6/1/2020 Approved 6/1/2020 6/3/2020 498237629 17570 Thomas Strese 4737 - 198th St. W., 55024 Residential Irrigation Controller $189.00 1 $94.50 7600 $94.50 $23.63 $70.88 7600 $94.50 $23.63 $70.88
2 6/10/2020 6/12/2020 324025104 18535 Julie Martin 3251 - 224th St. W., 55024 Residential Clothes Washer $648.00 1 $200.00 2000 $200.00 $50.00 $150.00 2000 $294.50 $73.63 $220.88
3 6/11/2020 6/12/2020 161065905 21157 John Fogliano/Madison Currie 18659 English Ave.Residential Clothes Washer $649.99 1 $200.00 2000 $200.00 $50.00 $150.00 2000 $494.50 $123.63 $370.88
4 6/11/2020 6/12/2020 430563106 21682 Matthew Childs 20631 East Oaks Drive Residential Irrigation Controller $196.88 1 $98.44 7600 $98.44 $24.61 $73.83 7600 $592.94 $148.24 $444.71
5 6/15/2020 Approved 6/15/2020 6/22/2020 185007801 7906 Jason Sanders 5078 - 185th St. W.Residential Clothes Washer $579.99 1 $200.00 2000 $200.00 $50.00 $150.00 2000 $792.94 $198.24 $594.71
6 6/18/2020 Approved 6/18/2020 6/22/2020 446085904 7311 Dean Hyytinen 19859 Executive Path Residential Irrigation Controller $169.99 1 $85.00 7600 $85.00 $21.25 $63.75 7600 $877.94 $219.48 $658.45
7 6/18/2020 Approved 6/19/2020 6/22/2020 192085009 468 Diane Berdan 4850 - 192nd St. W.Residential Irrigation Controller $199.00 1 $99.50 7600 $99.50 $24.88 $74.63 7600 $977.44 $244.36 $733.08
8 6/25/2020 Approved 6/25/2020 7/17/2020 498237769 17665 Amy Hayes 19812 Dover Dr.Residential Irrigation Controller $189.00 1 $94.50 7600 $94.50 $23.63 $70.88 7600 $1,071.94 $267.98 $803.95
9 6/29/2020 Approved 6/30/2020 7/17/2020 498238669 Craig Moen 19874 Deerbrooke Path Residential Irrigation Controller $219.99 1 $110.00 7600 $110.00 $27.50 $82.50 7600 $1,181.93 $295.48 $886.45
10 6/29/2020 Approved 6/30/2020 7/17/2020 321061206 6999 Craig Hussman 612 Ash St Residential Clothes Washer $484.38 1 $200.00 2000 $200.00 $50.00 $150.00 2000 $1,381.93 $345.48 $1,036.45
11 6/30/2020 Approved 7/13/2020 7/17/2020 301071303 2469 Roger Christensen 713 Main St.Residential Clothes Washer $989.99 1 $200.00 2000 $200.00 $50.00 $150.00 2000 $1,581.93 $395.48 $1,186.45
12 7/2/2020 Approved 7/13/2020 7/17/2020 141086807 21869 Ashley VanderWyst 18868 Embers Ave.Residential Clothes Washer $677.70 1 $200.00 2000 $200.00 $50.00 $150.00 2000 $1,781.93 $445.48 $1,336.45
13 7/6/2020 Approved 7/13/2020 7/17/2020 301441206 11870 Septimia Filip 412 - 14th St.Residential Clothes Washer $579.99 1 $200.00 2000 $200.00 $50.00 $150.00 2000 $1,981.93 $495.48 $1,486.45
14 7/10/2020 Approved 7/13/2020 7/17/2020 498238129 7483 Jennifer Hogan 19858 Deerbrooke Path Residential Clothes Washer $699.99 1 $200.00 2000 $200.00 $50.00 $150.00 2000 $2,181.93 $545.48 $1,636.45
15 7/21/2020 Approved 7/21/2020 9/9/2020 126548605 21871 Nancy Skupas 19486 Ellington Trail Residential Toilet $179.00 2 $50.00 2000 $100.00 $25.00 $75.00 4000 $2,281.93 $570.48 $1,711.45
16 7/27/2020 Approved 7/27/2020 9/9/2020 309032802 21388 Brian Dale 3328 - 209th St. W.Residential Clothes Washer $548.00 1 $200.00 2000 $200.00 $50.00 $150.00 2000 $2,481.93 $620.48 $1,861.45
17 7/31/2020 Approved 8/3/2020 9/9/2020 491076000 15864 Wesley Hyduke 5760 - 191st St. W.Residential Clothes Washer $699.99 1 $200.00 2000 $200.00 $50.00 $150.00 2000 $2,681.93 $670.48 $2,011.45
18 7/31/2020 Approved 8/3/2020 9/9/2020 190071001 11493 Bruce Nelson 4710 - 190th St. W.Residential Clothes Washer $498.00 1 $200.00 2000 $200.00 $50.00 $150.00 2000 $2,881.93 $720.48 $2,161.45
19 8/4/2020 Approved 8/4/2020 9/9/2020 203082109 15276 Sackett Properties 821 - 3rd St.Commercial Toilet $276.29 1 $50.00 2000 $50.00 $12.50 $37.50 2000 $2,931.93 $732.98 $2,198.95
20 8/6/2020 Approved 8/5/2020 9/9/2020 443554803 2789 John E Frank 20548 Eastview Curve Residential Toilet $149.00 1 $50.00 2000 $50.00 $12.50 $37.50 2000 $2,981.93 $745.48 $2,236.45
21 8/6/2020 Approved 8/6/2020 9/9/2020 111099102 13039 Darin Montgomery 19991 Dover Dr.Residential Irrigation Controller $249.99 1 $125.00 7600 $125.00 $31.25 $93.75 7600 $3,106.93 $776.73 $2,330.20
22 8/6/2020 Approved 8/6/2020 9/9/2020 498235479 5126 Greg Rudrud 19864 Devrie Path Residential Clothes Washer $799.98 1 $200.00 2000 $200.00 $50.00 $150.00 2000 $3,306.93 $826.73 $2,480.20
23 8/19/2020 Approved 8/19/2020 9/9/2020 498235689 4237 Clark Johnson 4796 - 198th St. W.Residential Toilet $152.10 1 $50.00 2000 $50.00 $12.50 $37.50 2000 $3,356.93 $839.23 $2,517.70
24 8/26/2020 Approved 8/26/2020 9/9/2020 141527206 5148 Mark Tilc 18272 Emerald Trail Residential Toilet $215.21 1 $50.00 2000 $50.00 $12.50 $37.50 2000 $3,406.93 $851.73 $2,555.20
25 8/28/2020 Approved 8/28/2020 9/9/2020 426043007 13625 William Poore 19430 Elmwood Circle Residential Irrigation Controller $179.99 1 $90.00 7600 $90.00 $22.50 $67.50 7600 $3,496.93 $874.23 $2,622.69
26 9/1/2020 Approved 9/2/2020 9/9/2020 189070501 11641 Jeff Allbee 4705 - 189th St. W.Residential Clothes Washer $799.99 1 $200.00 2000 $200.00 $50.00 $150.00 2000 $3,696.93 $924.23 $2,772.69
27 9/1/2020 Approved 9/2/2020 9/9/2020 430566703 7249 Jay Rinke 20667 East Oaks Drive Residential Irrigation Controller $179.99 1 $90.00 7600 $90.00 $22.50 $67.50 7600 $3,786.92 $946.73 $2,840.19
28 9/1/2020 Approved 9/2/2020 9/9/2020 121686908 9961 Michael Handley 18869 Dupont Way Residential Irrigation Controller $59.97 1 $29.99 7600 $29.99 $7.50 $22.49 7600 $3,816.91 $954.23 $2,862.68
29 9/1/2020 Approved 9/2/2020 9/9/2020 421001501 15269 Roger Thelen 15 Walnut St.Residential Toilet $89.98 1 $44.99 2000 $44.99 $11.25 $33.74 2000 $3,861.90 $965.47 $2,896.42
30 9/10/2020 Approved 9/9/2020 124044708 21295 Andrew Prusaczyk 18447 Eldorado Way Residential Clothes Washer $628.00 1 $200.00 2000 $200.00 $50.00 $150.00 2000 $4,061.90 $1,015.47 $3,046.42
31 9/22/2020 Approved 9/22/2020 484082106 5666 Melody Larson 5821 - 184th St. W.Residential Toilet $357.50 1 $50.00 2000 $50.00 $12.50 $37.50 2000 $4,111.90 $1,027.97 $3,083.92
32 9/22/2020 Approved 9/23/2020 472030104 21689 Michael Leubner 20301 Erickson Path Residential Irrigation Controller $180.99 1 $90.50 7600 $90.50 $22.62 $67.87 7600 $4,202.39 $1,050.60 $3,151.79
33 9/22/2020 Approved 9/23/2020 465030509 9860 Ron Stafford 20305 Enright Way Residential Toilet $178.00 2 $50.00 2000 $100.00 $25.00 $75.00 4000 $4,302.39 $1,075.60 $3,226.79
34 9/22/2020 Approved 9/23/2020 493074102 9697 John Tracy 5741 - 193rd St. W.Residential Toilet $129.00 2 $50.00 2000 $100.00 $25.00 $75.00 4000 $4,402.39 $1,100.60 $3,301.79
35 9/22/2020 Approved 9/23/2020 493074102 9697 John Tracy 5741 - 193rd St. W.Residential Clothes Washer $699.98 1 $200.00 2000 $200.00 $50.00 $150.00 2000 $4,602.39 $1,150.60 $3,451.79
36 9/22/2020 Approved 9/23/2020 488093208 6329 Theresa Powers 5932 - 188th St W Residential Toilet $99.00 1 $49.50 2000 $49.50 $12.38 $37.13 2000 $4,651.89 $1,162.97 $3,488.92