HomeMy WebLinkAboutAgenda_2018_5_30_Meeting(397)A Proud Past - A Promising
Future
Committed to Providing High
Quality, Timely and Responsive
Service to All of Our Customers
City of Farmington
430 Third Street
Farmington, MN 55024
AGE N D A
WAT E R B OARD
May 30, 2018
5:00 P M
C ity Hall - C onference Room 169
1.C AL L T O O RD E R
2.AP P RO V E M I NUT E S
(a)A pprove April 23, 2018 Meeting Minutes
3.NE W B US INE S S
(a)Well #9 P rofessional S ervices - Engineering
(b)2017 A nnual F inancial Report
4.AP P RO V E B IL L S
(a)A pprove B ills
5.O P E N F O RUM
6.AD J O URN
C ity of Farm ington
430 T hird S treet
F armington, Minnes ota
651.280.6800 - F ax 651.280.6899
www.ci.farmington.mn.us
TO:Water Board Members , C ity Administrator
F R O M:Katy G ehler
S UB J E C T:Approve April 23, 2018 Meeting Minutes
D AT E:May 30, 2018
IN T R O D UC T IO N
Attached are the minutes from the April 23, 2018, Water Board meeting.
D IS C US S IO N
N/A
B UD GE T IMPAC T
N/A
AC T ION R E Q UE S T E D
R eview, revis e and approve the minutes.
AT TAC HME N T S:
Type Desc ription
Bac kup Material April 23, 2018 Minutes
MINUTES
REGULAR WATER BOARD MEETING
Monday, April 23, 2018
7:00 PM
Conference Room 169
City Hall 430 Third Street Farmington, MN
Members Present: Gassert, Weierke
Members Absent: Snobeck
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 7:00 p.m.
1. Approve Minutes – April 23, 2018 - MOTION by Gassert second by Weierke to approve
minutes as presented. APIF, Motion Carried.
2. Water Citations – None
3. Continued Business – None
4. New Business –
a. 2017 Consumer Confidence Report & Water Use Summary - Informational
5. Approve Bills – Motion by Weierke second by Gassert to approve the bills, as presented in the
amount of $22,483.02. APIF, Motion Carried.
6. Open Forum – Director Gehler provided an update on the water tower rehabilitation. KLM is
estimating $1.3 - $1.4 project cost.
7. Adjourn – Motion by Weierke, second by Gassert to adjourn at 7:40pm PM. APIF, Motion
Carried.
Respectfully submitted,
Sue Miller
Administrative Assistant
C ity of Farm ington
430 T hird S treet
F armington, Minnes ota
651.280.6800 - F ax 651.280.6899
www.ci.farmington.mn.us
TO:Water Board Members , C ity Administrator
F R O M:Katy G ehler
S UB J E C T:Well #9 P rofes s ional S ervic es - Engineering
D AT E:May 30, 2018
IN T R O D UC T IO N
T he C I P identified three major projec ts in the next few years including drilling Well #9 to replace the aging
Well #1. T he timing of thes e projec ts was dis cus s ed with the board earlier this year with Well #9 work
s tarting this s ummer.
D IS C US S IO N
A request for propos als (R F P ) was prepared for the engineering services related to s iting, design and
cons truction s upport for a new municipal well. T he R F P was provided to three cons ultants that have
completed similar work and all have a history with the F armington water sys tem.
All three cons ultants submitted proposals that were due on May 21, 2018. As a professional service,
propos als c an be evaluated on c riteria other than jus t the fee. A c ommittee made up of the P W D/C ity
Engineer, Assistant C ity Engineer, Munic ipal S ervices Director and Maintenance S uperintendent reviewed
and rated the proposals bas ed on pre-establis hed criteria. T he criteria includes the unders tanding of the
objectives of the project, work plan, knowledge base of both the firm and s taff as s igned to the project and
propos ed hours and fees . T he attached table shows the c riteria and rating of the committee.
At the meeting, s taff will review the findings of the committee and recommend a cons ultant a finalize a
contrac t. A summary of the hours and fees each c onsultant propos ed for the projec t is attac hed.
B UD GE T IMPAC T
Well #9 has been planned to be funded through c apital res erve (fund balance). T he timing of the major water
C I P projec ts was adjusted late 2017 to optimize water supply during the water tower refurbis hing project. In
doing so, the well project was pus hed up to a 2018/2019 sc hedule. T he 2018 budget should be amended as
s uc h.
AC T ION R E Q UE S T E D
C onsider the rec ommendation of the s election committee. Approve negotiation of a final c ontract with the
s elected c onsultant to be forwarded to the C ity C ounc il along with amending the 2018 Water F und budget in
the same amount.
AT TAC HME N T S:
Type Desc ription
Bac kup Material P roposal S coring
Bac kup Material S ummary of Hours and F ees
RFP Score Sheet - Well No. 9 Professional Services
Evaluator's Name:
Combined Ratings and Comments
Rating Factor Weight Score
Weighted
Score Score
Weighted
Score Score
Weighted
Score Score
Weighted
Score Evaluation Comments
(1)
Expressed understanding of proposal
objectives 0.10 5 0.50 5 0.50 3 0.30 0.00
Barr was the only firm that expanded on the
proposal objectives and demonstrated a
complete understanding of the project and
concerns with recent well projects.
(2) Work Plan
0.30 5 1.50 4 1.20 3 0.90 0.00
Barr was the only firm that expanded on the
RFP text to demonstrate a complete
understanding of the work plan to complete the
project. Included modeling where the other
firms did not expressly note that.
(3) Cost Detail
0.20 4 0.80 3 0.60 3 0.60 0.00
Bolton and Menk submitted the lowest fee for
the project but did not include the required cost
detail so we can not compare the time allocated
to the different level staff assigned. Barr was
the second lowest fee and Stantec was the
highest. Hour/fee comparison in separate
sheet.
(4) Qualifications and experience of firm
0.10 5 0.50 4 0.40 3 0.30 0.00
Barr has a reputation for underground well
work, completed the metro model and also the
Farmington WHPP. The other firms do
complete well work, but on a much more limited
basis. BMI experience primarily in the early
2000s. Stantec team did not list other
experience besides the required references.
(5) Qualifications and experience of
personnel assigned to the project
0.30 4 1.20 4 1.20 3 0.90 0.00
The Barr team includes John Greer whom has
completed the most recent WHPP and has a
good grasp of the underlying geology. Stantec
team has a history in Farmington. BMI team
completed Water Plan.
1.00 4.50 3.90 3.00 0.00
Instructions: Enter a score (0 to 5) in the each of the four evaluation criteria (Score) boxes:
0 Totally unresponsive, does not meet expectations.
1 Well below average, barely meets expectations.
2 Slightly below average, meets expectations.
3 Average, meets expectations, exceeds expectations in some areas.
4 Above average, exceeds expectations in many or all areas.
5 Outstanding, far exceeds expectations in most areas.
Review Committee: Review Date:
Katy Gehler
Todd Reiten
Steve Arndt
Matt Decur
Barr Bolton & Menk Stantec
Well No. 9 Proposal Fee Summary
Hours Cost Avg. Hr. Hours Cost Avg. Hr. Hours Cost Avg. Hr.
Phase 1
Well Siting 40 $6,070 $151.75 67 $8,680 $129.55 50 $7,316 $146.32
Phase Total 40 $6,070 $151.75 67 $8,680 $129.55 50 $7,316 $146.32
Phase 2
Design/Bidding 85 $12,090 $142.24 156 $21,660 $138.85 156 $22,560 $144.62
Construction 156 $22,220 $142.44 226 $29,435 $130.24 206 $29,956 $145.42
Phase Total 241 $34,310 $142.37 382 $51,095 $133.76 362 $52,516 $145.07
Phase 3
Design/Bidding 313 $43,380 $138.59 218 $48,180 $221.01 572 $85,008 $148.62
Construction 304 $41,510 $136.55 199 $34,445 $173.09 300 $48,138 $160.46
Phase Total 617 $84,890 $137.59 417 $82,625 $198.14 872 $133,146 $152.69
Project Total 898 $125,270 $139.50 866 $142,400 $164.43 1284 $192,978 $150.29
BMI Barr Stantec
C ity of Farm ington
430 T hird S treet
F armington, Minnes ota
651.280.6800 - F ax 651.280.6899
www.ci.farmington.mn.us
TO:Water Board Members , C ity Administrator
F R O M:Katy G ehler
S UB J E C T:2017 Annual F inancial R eport
D AT E:May 30, 2018
IN T R O D UC T IO N
Each year the city's financial records are audited by an independent public acc ounting firm. Included in the
audit is the water fund.
D IS C US S IO N
T he c ity's financ ial rec ords have been audited by Malloy, Montague, Karnowski, R ados evic h & C o., P.A.
(MMKR ). Based upon their audit, they concluded there was a reasonable basis for rendering an unmodified
opinion that the C ity of F armington’s financ ial statements for the fis cal year ended December 31, 2017 are
fairly pres ented in c onformity with G enerally Ac cepted Acc ounting P rinc iples (G AAP ). An unmodified
opinion is is s ued when the independent auditor believes that the company’s financial s tatements are s ound;
that is , the statements are free from material misstatement.
T he findings of the auditors are publis hed in the C omprehensive Annual F inancial R eport (C AF R ). T he
C AF R is a large doc ument that covers all of the city's funds . An exc erpt of the document summarizing the
enterpris e funds is attac hed. S taff will review the C AF R as it relates to the water fund. Als o attac hed is a
s ummary of the revenues and expenses for 2017 and 2018.
B UD GE T IMPAC T
N/A
AC T ION R E Q UE S T E D
No ac tion is needed. T his item is informational only.
AT TAC HME N T S:
Type Desc ription
Bac kup Material 2017 F armington C AF R Exerpt - Enterpris e
F unds
Bac kup Material 2017/2018 Water F und S ummary - Budget to
Ac tual
Liquor Sewer Solid Storm
Operations Operations Waste Water
Assets
Current assets
Cash and investments 1,123,054$ 2,602,817$ 1,265,288$ 969,383$
Cash restricted for drinking water treatment plant – – – –
Receivables
Accounts 78,869 428,374 448,054 147,228
Interest 2,851 6,628 3,221 2,469
Delinquent special assessments – 22,277 – –
Due from other governments – – – –
Inventory 495,597 – – –
Prepaid items 290 – – –
Total current assets 1,700,661 3,060,096 1,716,563 1,119,080
Noncurrent assets
Special assessments – 293,943 – –
Capital assets
Land – 85,000 – 1,192
Buildings – – – –
Improvements other than buildings 121,012 – – –
Machinery and equipment 242,513 720,696 1,383,689 30,264
Distribution system – – – –
Collection system – 28,273,060 – 20,182,371
Less accumulated depreciation (363,525) (11,707,111) (1,163,761)(6,984,509)
Total capital assets (net of accumulated depreciation)– 17,371,645 219,928 13,229,318
Total noncurrent assets – 17,665,588 219,928 13,229,318
Total assets 1,700,661 20,725,684 1,936,491 14,348,398
Deferred outflows of resources
Pension plan deferments – PERA 89,391 – 69,526 –
Total assets and deferred outflows of resources 1,790,052$ 20,725,684$ 2,006,017$ 14,348,398$
Liabilities
Current liabilities
Accounts and contracts payable 86,861$ 12,457$ 81,013$ 15,470$
Accrued salaries and employee benefits payable – – – –
Deposits payable – – – –
Due to other governments 47,411 9,940 21,881 –
Compensated absences payable – current 28,766 – 36,902 –
Total current liabilities 163,038 22,397 139,796 15,470
Noncurrent liabilities
Compensated absences payable 9,588 – 12,300 –
Net pension liability – PERA 343,009 – 266,785 –
Net OPEB obligation 50,890 – 47,056 –
Total noncurrent liabilities 403,487 – 326,141 –
Total liabilities 566,525 22,397 465,937 15,470
Deferred inflows of resources
Pension plan deferments – PERA 71,814 – 55,855 –
Net position
Investment in capital assets – 17,371,645 219,928 13,229,318
Restricted for drinking water treatment plant – – – –
Unrestricted 1,151,713 3,331,642 1,264,297 1,103,610
Total net position 1,151,713 20,703,287 1,484,225 14,332,928
Total liabilities, deferred inflows of resources, and net position 1,790,052$ 20,725,684$ 2,006,017$ 14,348,398$
as of December 31, 2017
Business-Type Activities – Enterprise Funds
CITY OF FARMINGTON
Statement of Net Position
Proprietary Funds
See notes to basic financial statements -26-
Governmental
Street Activities –
Water Light Total Internal Service
6,344,434$ 83,377$ 12,388,353$ 2,303,452$
2,238,206 – 2,238,206 –
262,559 34,154 1,399,238 70,653
21,851 212 37,232 5,834
– – 22,277 –
– – – 51
– – 495,597 –
– – 290 7,606
8,867,050 117,743 16,581,193 2,387,596
436 – 294,379 –
328,384 – 414,576 –
3,243,203 – 3,243,203 –
– – 121,012 –
317,003 – 2,694,165 116,173
32,511,466 – 32,511,466 –
– – 48,455,431 –
(15,756,298)– (35,975,204) (83,135)
20,643,758 – 51,464,649 33,038
20,644,194 – 51,759,028 33,038
29,511,244 117,743 68,340,221 2,420,634
– – 158,917 –
29,511,244$ 117,743$ 68,499,138$ 2,420,634$
31,065$ 22,223$ 249,089$ 27,913$
– – – 336,155
35,496 – 35,496 1,569
1,016 – 80,248 –
– – 65,668 26,201
67,577 22,223 430,501 391,838
– – 21,888 –
– – 609,794 –
– – 97,946 –
– – 729,628 –
67,577 22,223 1,160,129 391,838
– – 127,669 –
20,643,758 – 51,464,649 33,038
2,238,206 – 2,238,206 –
6,561,703 95,520 13,508,485 1,995,758
29,443,667 95,520 67,211,340 2,028,796
29,511,244$ 117,743$ 68,499,138$ 2,420,634$
-27-
City of Farmington
Water Fund
2017 & 2018
5/24/2018 4:45:20 PM
Company 2017
Actual
2017
Budget
2017 Actual
Budget
Variance
2017 Actual
Budget
Variance %
2018
Actual
2018
Budget
2018 Actual
Budget
Variance
2018 Actual
Budget
Variance %
Revenues
Enterprise Sales 1,363,768 1,457,808 (94,040)-6.45%242,469 1,150,000 (907,531)-78.92%
Rental Income 218,100 203,700 14,400 7.07%123,933 213,885 (89,952)-42.06%
Water Quality Management Fee 6,240 1,000 5,240 524.00%63,440 1,040 62,400 6,000.00%
Water Availability Charge 55,220 65,000 (9,780)-15.05%13,805 67,000 (53,195)-79.40%
Water Connection Charge 1,515 1,515 0 0
Water Main Trunk Charge 10,758 0 10,758 103,616 0 103,616
Other Charges 100,254 78,691 21,563 27.40%49,772 94,350 (44,578)-47.25%
Total Revenues 1,755,854 1,806,199 (50,345)-2.79%597,035 1,526,275 (929,240)-60.88%
Expenditures
Personnel 14,023 10,354 3,669 35.43%1,847 10,357 (8,510)-82.17%
Parts & Supplies 164,972 272,800 (107,828)-39.53%36,624 224,650 (188,026)-83.70%
Professional Services 58,813 162,000 (103,187)-63.70%37,202 202,000 (164,798)-81.58%
Internal Services 58,968 74,816 (15,848)-21.18%23,342 73,927 (50,585)-68.43%
Utilities 182,595 196,000 (13,406)-6.84%52,887 195,500 (142,613)-72.95%
Outside Repair Services 63,991 16,345 47,646 291.50%17,154 127,090 (109,936)-86.50%
Programming Expense 3,170 6,500 (3,330)-51.22%3,365 6,500 (3,135)-48.23%
Machinery Equipment 0 0 0 0 215,000 (215,000)-100.00%
Transfers Out 529,867 418,617 111,250 26.58%134,408 403,225 (268,817)-66.67%
Total Expenditures 1,076,399 1,157,432 (81,033)-7.00%306,829 1,458,249 (1,151,420)-78.96%
Revenues Over (Under) Expenditures 679,456 648,767 30,689 4.73%290,206 68,026 222,180 326.61%
C ity of Farm ington
430 T hird S treet
F armington, Minnes ota
651.280.6800 - F ax 651.280.6899
www.ci.farmington.mn.us
TO:Water Board Members , C ity Administrator
F R O M:Katy G ehler
S UB J E C T:Approve Bills
D AT E:May 30, 2018
IN T R O D UC T IO N
Attached are the bills from April 19, 2018 to May 22, 2018. Note the bills for Dakota Electric. Due to a
change in their billing proc edure, the las t three months were billed recently. To acc ount for eac h month
individually, eac h premis e total was reentered by month total.
D IS C US S IO N
N/A
B UD GE T IMPAC T
N/A
AC T ION R E Q UE S T E D
R eview, disc uss, and approve the bills .
AT TAC HME N T S:
Type Desc ription
Bac kup Material 04/19/2018 to 05/22/2018 Water Board Bills
5/22/2018CITY OF FARMINGTON 14:36:14R55CKS2LOGIS600V
1Page -Council Check SummaryNote: Payment amount may not reflect the actual amount due to data sequencing and/or data selection.
5/22/20184/19/2018 -
Check #AmountDate Supplier / Explanation PO#Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div
143403 4/20/2018 100036 AMERICAN PAYMENT CENTERS
06500 08640120.25 65022ND QTR FAM FRESH UTIL BOX 164606 15-17720 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
20.25
143420 4/20/2018 100030 CORE & MAIN, LP
06500 086250174.90 6502CHLORINE TABLETS 164577 I643309 OTHER SUPPLIES & PARTS WATER UTILITY EXPENSE
174.90
143470 4/20/2018 113442 METERING & TECHNOLOGY SOLUTIONS
06500 08622012.21 6502METER GASKETS 164587 11322 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
12.21
143476 4/20/2018 100070 MVTL- MINN VALLEY TESTING LABS
06500 08640143.75 6502COLIFORM COLILERT BAC-T SAMPLE 164611 910501 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
43.75
143483 4/20/2018 113031 NRG RELIABILITY SOLUTIONS LLC
06500 0864221,558.38 6502CMF ELEC MAR'18 164489 3347-1804 ELECTRIC WATER UTILITY EXPENSE
1,558.38
143484 4/20/2018 101254 ORKIN EXTERMINATING
06500 08640117.49 6502PEST CONTROL APR'18 MAINT FAC 164597 169017885/28367911 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
17.49
143509 4/20/2018 109843 SPOK, INC.
06500 0864123.94 6502PAGER CONTRACT APR'18 164591 B0317419P CELLULAR PHONES WATER UTILITY EXPENSE
3.94
143534 5/4/2018 103774 AMERICAN PUBLIC WORKS ASSOCIATION
06500 086460206.25 6502MEMBERSHIP JUL'18 TO JUN'19 164899 699682 JUL'18 -
JUN'19
SUBSCRIPTIONS & DUES WATER UTILITY EXPENSE
206.25
143546 5/4/2018 107089 CANNON VALLEY PRINTING
06500 086450826.73 6502PRINTING SERVICES -CNRG SUMMER 164867 FPR 36056 OUTSIDE PRINTING WATER UTILITY EXPENSE
826.73
143547 5/4/2018 100025 CINTAS CORP LOC 754
06500 08629027.47 6502WEEKLY UNIFORM CLEANING APR'18 164984 4005078512 UNIFORMS & CLOTHING WATER UTILITY EXPENSE
06500 08629027.47 6502WEEKLY UNIFORM CLEANING APR'18 164992 4004910526 UNIFORMS & CLOTHING WATER UTILITY EXPENSE
54.94
143560 5/4/2018 111431 FERGUSON WATERWORKS
06500 086220100.00 6502GAS MONITOR 164951 0277280 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
100.00
143567 5/4/2018 107123 GS DIRECT INC
06500 08625015.36 6502PLOTTER SUPPLIES 164985 341131 OTHER SUPPLIES & PARTS WATER UTILITY EXPENSE
5/22/2018CITY OF FARMINGTON 14:36:14R55CKS2LOGIS600V
2Page -Council Check SummaryNote: Payment amount may not reflect the actual amount due to data sequencing and/or data selection.
5/22/20184/19/2018 -
Check #AmountDate Supplier / Explanation PO#Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div
15.36
143575 5/4/2018 102456 KLM ENGINEERING INC
06500 0864013,800.00 6502WATER TOWER CLEAN & INSPECT 164986 6723 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
3,800.00
143581 5/4/2018 100049 LOCAL GVMT INFO SYSTEMS ASSN.
06500 086402883.00 6502LOGIS BILL - FEB'18 164907 45050 DATA PROCESSING WATER UTILITY EXPENSE
06500 086402883.00 6502LOGIS BILL - MAR'18 164908 45124 DATA PROCESSING WATER UTILITY EXPENSE
1,766.00
143593 5/4/2018 100070 MVTL- MINN VALLEY TESTING LABS
06500 08640148.75 6502COLIFORM COLILERT BAC-T SAMPLE 164998 912533 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
06500 08640125.00 6502COLIFORM COLILERT BAC-T SAMPLE 164999 912532 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
73.75
143596 5/4/2018 100093 PELLICCI HARDWARE & RENTAL
06500 0862406.50 6502DOOR LUBE 164942 K16545 BUILDING SUPPLIES & PARTS WATER UTILITY EXPENSE
06500 0862406.50 6502DOOR LUBE 164959 K16430 BUILDING SUPPLIES & PARTS WATER UTILITY EXPENSE
06500 0862404.88 6502DISH SOAP AND BATTERIES 164991 K16173 BUILDING SUPPLIES & PARTS WATER UTILITY EXPENSE
06500 08625060.00 6502DEIONIZED WATER 165005 72629 OTHER SUPPLIES & PARTS WATER UTILITY EXPENSE
06500 08622033.06 6502LIGHT BULBS 165006 K16130 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
110.94
143612 5/4/2018 112307 T-MOBILE
06500 0862206.67 6502GPS SERVICE APR'18 164909 823329497 APR'18 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
6.67
143619 5/18/2018 100192 AGGREGATE INDUSTRIES - MWR, INC
06500 086250155.02 6502SAND/WATER REPAIR UPPER 182ND 165162 708581864 OTHER SUPPLIES & PARTS WATER UTILITY EXPENSE
155.02
143633 5/18/2018 100025 CINTAS CORP LOC 754
06500 08629027.47 6502WEEKLY UNIFORM CLEANING APR'18 165273 4005419975 UNIFORMS & CLOTHING WATER UTILITY EXPENSE
06500 08629027.47 6502WEEKLY UNIFORM CLEANING APR'18 165274 4005250691 UNIFORMS & CLOTHING WATER UTILITY EXPENSE
54.94
143635 5/18/2018 100030 CORE & MAIN, LP
06500 086220116.74 6502CORP AND SADDLE 165161 I742538 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
116.74
143636 5/18/2018 100581 CRAWFORD DOOR SALES CO
06500 086515724.60 6502SANATATION DOOR REPAIR 165125 29619 BUILDING REPAIR SERVICE WATER UTILITY EXPENSE
724.60
143647 5/18/2018 103692 FASTENAL COMPANY
06500 08622034.56 6502BLUE FLAGS 165219 MNLAK154350 EQUIP SUPPLIES & PARTS WATER UTILITY EXPENSE
34.56
5/22/2018CITY OF FARMINGTON 14:36:14R55CKS2LOGIS600V
3Page -Council Check SummaryNote: Payment amount may not reflect the actual amount due to data sequencing and/or data selection.
5/22/20184/19/2018 -
Check #AmountDate Supplier / Explanation PO#Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div
143652 5/18/2018 100024 GOPHER STATE ONE-CALL INC
06500 08640140.50-6502FEBRUARY 2018 LOCATES 163819 8020371 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
06500 08640164.35 6502APRIL 2018 LOCATES 165234 8040372 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
23.85
143656 5/18/2018 107123 GS DIRECT INC
06500 08625045.14 6502PLOTTER SUPPLIES 165199 341186 OTHER SUPPLIES & PARTS WATER UTILITY EXPENSE
45.14
143658 5/18/2018 100007 HAWKINS INC
06500 08626012,072.34 6502WELL CHEMICALS 164914 4271073 CHEMICALS WATER UTILITY EXPENSE
12,072.34
143663 5/18/2018 112416 IMPACT MAILING OF MN INC
06500 086445246.44 6502FEB'18 UB MAIL PREP/POSTAGE 165262 131163 POSTAGE WATER UTILITY EXPENSE
06500 08644539.79 6502FEB'18 UB MAIL PREP/POSTAGE 165262 131163 POSTAGE WATER UTILITY EXPENSE
286.23
143690 5/18/2018 100070 MVTL- MINN VALLEY TESTING LABS
06500 08640143.75 6502COLIFORM COLILERT BAC-T SAMPLE 165191 914504 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
06500 08640137.50 6502COLIFORM COLILERT BAC-T SAMPLE 165198 913486 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
81.25
143695 5/18/2018 113031 NRG RELIABILITY SOLUTIONS LLC
06500 0864221,535.22 6502CMF ELEC APR'18 165209 3347-1805 ELECTRIC WATER UTILITY EXPENSE
1,535.22
143696 5/18/2018 101254 ORKIN EXTERMINATING
06500 08640117.49 6502PEST CONTROL MAY'18 MAINT FAC 165237 170171174/28367911 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
17.49
143698 5/18/2018 100093 PELLICCI HARDWARE & RENTAL
06500 08624029.25 6502AIR FILTERS 165277 79256 BUILDING SUPPLIES & PARTS WATER UTILITY EXPENSE
29.25
143709 5/18/2018 100151 SAUBER PLUMBING & HEATING CO.
06500 0864012,730.00 65025815 UPPER 182ND WATER LEAK 165218 21810 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
2,730.00
143716 5/18/2018 109843 SPOK, INC.
06500 0864123.94 6502PAGER CONTRACT MAY'18 165160 B0317419Q CELLULAR PHONES WATER UTILITY EXPENSE
3.94
143730 5/18/2018 111267 WATER CONSERVATION SERVICE, INC
06500 086401382.98 65025815 UPPER 182ND WATER LEAK 165268 8511 PROFESSIONAL SERVICES WATER UTILITY EXPENSE
382.98
5/22/2018CITY OF FARMINGTON 14:36:14R55CKS2LOGIS600V
4Page -Council Check SummaryNote: Payment amount may not reflect the actual amount due to data sequencing and/or data selection.
5/22/20184/19/2018 -
Check #AmountDate Supplier / Explanation PO#Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div
20180413 4/19/2018 114654 INVOICE CLOUD
06500 086545511.43 6502IC PYMT PROCESS FEES MAR'18 164490 819-2018_3 PYMT PROCESSING FEES WATER UTILITY EXPENSE
511.43
20180418 4/30/2018 102160 CARDMEMBER SERVICES
06500 08641235.01 6502FEB'18 CELL PHONE SERVICE 164617 6913-4547-3/19 CELLULAR PHONES WATER UTILITY EXPENSE
06500 08641299.29 6502FEB'18 CELL PHONE SERVICE 164618 6913-2625-3/26 CELLULAR PHONES WATER UTILITY EXPENSE
134.30
20180505 5/2/2018 100085 DAKOTA ELECTRIC ASSOCIATION
06500 0864222,354.42 6502WELL #6 ELEC JAN'18 163095 155015-1 JAN'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864221,775.55 6502WELL #8 ELEC JAN'18 163099 419970-9 JAN'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864222,393.86 6502WELL #5 ELEC JAN'18 163100 278553-3 JAN'18 ELECTRIC WATER UTILITY EXPENSE
06500 086422796.17 6502WELL #7 ELEC JAN'18 163102 349073-7 JAN'18 ELECTRIC WATER UTILITY EXPENSE
06500 08642285.76 6502195TH WATER TOWER ELEC JAN'18 163103 258709-5 JAN'18 ELECTRIC WATER UTILITY EXPENSE
06500 08642224.38 6502DAISY KNOLL TOWER ELEC JAN'18 163105 131851-8 JAN'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864221,673.69 6502WELL #4 ELEC JAN'18 163106 131852-6 JAN'18 ELECTRIC WATER UTILITY EXPENSE
06500 08642245.80 6502DAISY KNOLL TOWER ELEC FEB'18 163806 131851-8 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 08642245.80-6502DAISY KNOLL TOWER ELEC FEB'18 163806 131851-8 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 08642221.42 6502DAISY KNOLL TOWER ELEC FEB'18 163806 131851-8 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864224,181.11 6502WELL #4 ELEC FEB'18 163807 131852-6 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864224,181.11-6502WELL #4 ELEC FEB'18 163807 131852-6 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864222,507.42 6502WELL #4 ELEC FEB'18 163807 131852-6 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864223,305.06 6502WELL #8 ELEC FEB'18 163813 419970-9 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864223,305.06-6502WELL #8 ELEC FEB'18 163813 419970-9 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864221,529.51 6502WELL #8 ELEC FEB'18 163813 419970-9 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 086422168.22 6502195TH WATER TOWER ELEC FEB'18 163814 258709-5 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 086422168.22-6502195TH WATER TOWER ELEC FEB'18 163814 258709-5 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 08642282.46 6502195TH WATER TOWER ELEC FEB'18 163814 258709-5 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864224,857.97 6502WELL #5 ELEC FEB'18 163815 278553-3 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864224,857.97-6502WELL #5 ELEC FEB'18 163815 278553-3 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864222,464.11 6502WELL #5 ELEC FEB'18 163815 278553-3 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864221,646.31 6502WELL #7 ELEC FEB'18 163817 349073-7 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864221,646.31-6502WELL #7 ELEC FEB'18 163817 349073-7 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 086422850.14 6502WELL #7 ELEC FEB'18 163817 349073-7 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864223,878.97 6502WELL #6 ELEC FEB'18 163818 155015-1 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864223,878.97-6502WELL #6 ELEC FEB'18 163818 155015-1 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 0864221,524.55 6502WELL #6 ELEC FEB'18 163818 155015-1 FEB'18 ELECTRIC WATER UTILITY EXPENSE
06500 08642217.77 6502DAISY KNOLL TOWER ELEC MAR'18 164918 200001318518
MAR'18
ELECTRIC WATER UTILITY EXPENSE
06500 086422991.99 6502WELL #4 ELEC MAR'18 164919 200001318526
MAR'18
ELECTRIC WATER UTILITY EXPENSE
06500 0864223,584.41 6502WELL #6 ELEC MAR'18 164921 200001550151 ELECTRIC WATER UTILITY EXPENSE
5/22/2018CITY OF FARMINGTON 14:36:14R55CKS2LOGIS600V
5Page -Council Check SummaryNote: Payment amount may not reflect the actual amount due to data sequencing and/or data selection.
5/22/20184/19/2018 -
Check #AmountDate Supplier / Explanation PO#Doc No Inv No BU Obj Sub Subledger Account Description BU Description Co Dept Div
MAR'18
06500 08642269.91 6502195TH WATER TOWER ELEC MAR'18 164922 200002587095
MAR'18
ELECTRIC WATER UTILITY EXPENSE
06500 086422194.02 6502WELL #5 ELEC MAR'18 164923 200002785533
MAR'18
ELECTRIC WATER UTILITY EXPENSE
06500 086422906.68 6502WELL #7 ELEC MAR'18 164925 200003490737
MAR'18
ELECTRIC WATER UTILITY EXPENSE
06500 0864222,678.38 6502WELL #8 ELEC MAR'18 164927 200004199709
MAR'18
ELECTRIC WATER UTILITY EXPENSE
26,526.60
20180506 5/3/2018 100394 XCEL ENERGY
06500 086422393.82 6502WELL #1 & 3 ELEC MAR'18 164564 51-4874005-0
MAR'18
ELECTRIC WATER UTILITY EXPENSE
06500 086422127.89 6502CITY GARAGE ELEC MAR'18 164564 51-4874005-0
MAR'18
ELECTRIC WATER UTILITY EXPENSE
521.71
Report Totals 54,779.15