The URL can be used to link to this page

06-26-2019 HUCCPHUTCHINSON UTILITIES COMMISSION AGENDA REGULAR MEETING June 26, 2019 3:00 p.m. 1. CONFLICT OF INTEREST 2. APPROVE CONSENT AGENDA a. Approve Minutes b. Ratify Payment of Bills 3. APPROVE FINANCIAL STATEMENTS 4. OPEN FORUM 5. COMMUNICATION a. City Administrator b. Divisions C. Human Resources d. Legal e. General Manager 6. POLICIES a. Review Policies i. Section 6 of Exempt Handbook ii. Section 6 of Non -Exempt Handbook b. Approve Changes 7. UNFINISHED BUSINESS 8. NEW BUSINESS a. Approve Requisition #7984 - Replacing Transformer for Generator #3 b. Approve Petrotech Contract — Unit #8 Control System Replacement C. Approve Requisition #8006 — Prince of Peace Relocate d. Approve Requisition #8007 — Waller Drive Relocate e. Approve Requisition #8013 — SCADA Master Replacement f. Discussion of Exempt Employee Pay Performance System 9. ADJOURN MINUTES Regular Meeting — Hutchinson Utilities Commission Wednesday, May 29, 2019 Call to order — 3:00 p.m. President Don Martinez called the meeting to order. Members present: President Don Martinez; Vice President Matt Cheney; Secretary Robert Wendorff; Commissioner Monty Morrow; Commissioner Anthony Hanson; GM Jeremy Carter Absent: Attorney Marc Sebora 1. Conflict of Interest 2. Approve Consent Agenda a. Approve Minutes b. Ratify Payment of Bills Motion by Commissioner Hanson, second by Commissioner Cheney to approve the Consent Agenda. Motion carried unanimously. 3. Approve Financial Statements GM Carter presented the financial statements. Electric Division Net Loss decreased by $74,043 mostly due to a decrease in generation and purchased power. KWH sold for Industrial saw a reduction in loads, which is due to 3M efficiency and HTI ramping down. HUC will continue to watch loads and if loads continue to fall for 12 months HUC may re -class. Large General KWH increased by 9,600K due to Uponor. Mr. Martig added Natural Gas net income decreased by $87,862, which is mostly due to lower customer revenue with decreased usage. Purchased Gas also decreased due to lower usage. GM Carter reviewed the Investment Report. Two US treasury bills came due, that money was reinvested into 9 new Municipal Bonds. After discussions, a motion by Commissioner Morrow, second by Commissioner Hanson to approve the financial statements. Motion carried unanimously. 4. Open Forum 5. Communication a. City Administrator —Matthew Jaunich — i. 5t" Ave construction will be starting June 7 ii. Council awarded bill for Uponor/TDK road to start this summer iii. Rate schedule for water/sewer iv. Patching pot holes b. Divisions 1 i. Dan Lang, Engineering Services Manager — Nothing to report ii. Dave Hunstad, Electric Transmission/Distribution Manager — 1. Had an outage last week by Cash Wise. Will be finishing repair work this week. 2. Working on 5t" Ave project 3. Working on RP3 application iii. Randy Blake, Production Manager — 1 . Received Plant 1 air permit 2. Emissions testing results look good 3. Completed testing on cooling tower, however there were leaks. Fagen Inc. made permanent repairs. 4. Caterpillar will be removing all the Conex box containers soon 5. Lube oil was received and installed in both engines 6. Quade Electric is here this week pulling the last of the wires 7. Looking to start engines around June 10tn iv. John Webster, Natural Gas Division Manager- 1. Repairing a two-inch steel line by the old KFC building that was hit 2. Working on 5t" Ave project 3. Working on receiving quotes from contractors for Prince of Peace relocation. v. Jared Martig, Financial Manager- Nothing to report c. Legal — Marc Sebora — Absent d. Human Resources - Brenda Ewing — Absent e. General Manager — Jeremy Carter i. Continuing to work on Financial modeling ii. Working through Strategic Planning iii. Coordinating a 2nd Union sub -committee meeting iv. Legislative updates - No significant changes for municipal utilities 6. Policies a. Review Policies i. Section 5 of Exempt Handbook ii. Section 5 of Non -Exempt Handbook No changes recommended at this time. b. Approve Changes No changes made to the policies under review. 7. Unfinished Business 2 8. New Business a. Approve Bid for Unit #8 Control System Replacement GM Carter presented approving the Bid for Unit #8 Control System Replacement. HUC recently advertised for bids to replace a portion of the genset control system due to obsolescence of replacement parts and support. Having met all bidding requirements, HUC Staff would recommend awarding the Unit #8 Control System Replacement project to Petrotech, Inc. for $215,512.00, which is within the 2019 budget of $305,000. Motion by Commissioner Hanson, second by Commissioner Wendorff to Approve Bid for Unit #8 Control System Replacement. Motion carried unanimously. b. Approve 2nd Amendment to Natural Gas Transportation Agreement — TDK/HTI Mr. Webster presented the 2nd Amendment to Natural Gas Transportation Agreement — TDK/HTI. Mr. Webster noted that conversations have been held with TDK/HTI the last few months to assist in controlling the natural gas commodity costs. The impact to HUC would be minimal and Mr. Webster would work with TDK/HTI to procure and manage all natural gas contracts. After discussion, a motion by Commissioner Cheney, second by Commissioner Morrow to Approve 2nd Amendment to Natural Gas Transportation Agreement — TDK/HTI. Motion carried unanimously. 9. Adjourn There being no further business, a motion by Commissioner Cheney, second by Commissioner Hanson to adjourn the meeting at 3:29p.m. Motion carried unanimously. ATTEST: Don Martinez, President 3 Robert Wendorff, Secretary 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Payee Description Account Dept Pag 1/25 Amount Fund: 1 ELECTRIC 05/24/2019 GEN 380(E)*4 BP CANANDA ENERGY SOLUTIONS GENERATOR 41 NATURAL GAS 401-547- 01 2, 399. 90 GENERATOR 41 NATURAL GAS 401-547- 01 138.09 Generator 41 Aux Boiler 401-547- 01 22.69 GENERATOR 43 NATURAL GAS 401-547- 01 69.47 GENERATOR 43 NATURAL GAS 401-547- 01 10. 62 GENERATOR 44 NATURAL GAS 401-547- 01 54.73 GENERATOR 44 NATURAL GAS 401-547- 01 10. 62 GENERATOR 45 NATURAL GAS 401-547- 01 425.27 GENERATOR 45 NATURAL GAS 401-547- 01 21.24 GENERATOR 48 NATURAL GAS 401-547- 01 37.18 Generator 49 Natural Gas 401-547- 01 66.40 Utility Expenses - Water/Waste 401-930- 08 1,433.10 HECK GEN 380(E) TOTAL 4,689.31 05/28/2019 GEN 387(E) MISO Deferred Energy Cost - Miso 174-000- 00 57,928.85 Deferred Energy Cost - Miso 174-000- 00 850.47 HECK GEN 387(E) TOTAL 58,779.32 05/30/2019 GEN 389(E) BOND TRUST SERVICES CORPORATION 2017 BOND INTEREST 237-000- 00 279,328.13 06/01/2019 GEN 69121* 41 NAILS SPA DEP REFUND/APPLIED 235-000- 00 357.50 06/01/2019 GEN 69122* AARON JERGENS DEP REFUND/APPLIED 235-000- 00 188.50 06/01/2019 GEN 69123* ALLEN SMITH DEP REFUND/APPLIED 235-000- 00 94.25 06/01/2019 GEN 69124* ALLEN SMITH DEP REFUND/APPLIED 235-000- 00 74.75 06/01/2019 GEN 69125* AMY KING DEP REFUND/APPLIED 235-000- 00 136.50 06/01/2019 GEN 69126* AMY KING DEP REFUND/APPLIED 235-000- 00 58.50 06/01/2019 GEN 69127* ANDREW BERGLUND DEP REFUND/APPLIED 235-000- 00 97.50 06/20/2019 10:20 AM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES Pag 2/25 User: JMartig CHECK DATE FROM 05/23/2019 - 06/20/2019 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Amount Fund: 1 ELECTRIC 06/01/2019 GEN 69128* BONNIE ALSLEBEN DEP REFUND/APPLIED 235-000- 00 32.50 06/01/2019 GEN 69129*4 BORDER STATES ELECTRIC SUPPLY TERMINAL BLOCK, 3 PLACE, "COVERED" CSB 154-000- 00 132.20 TAPE, HIGH VOLTAGE BUS, 2" WIDE x 25 154-000- 00 433.20 SHOVEL, 42, CLOSED BACK 48", 154-000- 00 140.81 HECK GEN 69129 TOTAL 706.21 06/01/2019 GEN 69130* BROTHERS FIRE PROTECTION GROUNDS - OUTSIDE SERVICES 401-935- 08 126.38 06/01/2019 GEN 69131* CAROL MISKOVSKY DEP REFUND/APPLIED 235-000- 00 39.00 06/01/2019 GEN 69132* CASEY CLARK DEP REFUND/APPLIED 235-000- 00 130.00 06/01/2019 GEN 69133 CENTRAL HYDRAULICS Generators 107-344- 00 44.26 06/01/2019 GEN 69134* CHAD KOENEN OR JENNIFER KOENEN DEP REFUND/APPLIED 235-000- 00 169. 00 06/01/2019 GEN 69135* CHAD REINER DEP REFUND/APPLIED 235-000- 00 195.00 06/01/2019 GEN 69136*4 CINTAS CORPORATION 4470 Uniforms & Laundry 401-550- 01 388.04 Uniforms & Laundry 401-588- 02 286.43 HECK GEN 69136 TOTAL 674.47 06/01/2019 GEN 69137 COLONIAL SUPPLEMENTAL INS CO COLONIAL INSURANCE 242-000- 00 170.64 06/01/2019 GEN 69138*4 CREEKSIDE SOILS Materials 401-588- 02 37.08 06/01/2019 GEN 69139* DARCY HUSTED OR SHEILA HUSTED DEP REFUND/APPLIED 235-000- 00 162.50 06/01/2019 GEN 69140* DAWN PEARSON DEP REFUND/APPLIED 235-000- 00 247.00 06/01/2019 GEN 69141* DEMETRIA COLLINS DEP REFUND/APPLIED 235-000- 00 32.50 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Payee Description Account Dept Pag 3/25 Amount Fund: 1 ELECTRIC 06/01/2019 GEN 69142* ELIZABETH KAKOW OR THOMAS RADON DEP REFUND/APPLIED 235-000- 00 247.00 06/01/2019 GEN 69143* EVAN SCHANDORFF DEP REFUND/APPLIED 235-000- 00 39.00 06/01/2019 GEN 69144 FAGEN, INC Generators 107-344- 00 294,043.51 06/01/2019 GEN 691454 FASTENAL COMPANY Supplies 401-550- 01 14.79 Maintenance Other - Materials 402-554- 01 97.92 Line - Materials 402-594- 02 3.48 HECK GEN 69145 TOTAL 116.19 06/01/2019 GEN 691464 FERGUSON ENTERPRISES 4525 Sales Tax Receivable - Replace 186-000- 00 5.89 1/2" 30004 coupling -part #FSTHCD 402-554- 01 8.46 1/2"6004 threaded BV-part # 402-554- 01 77.27 HECK GEN 69146 TOTAL 91.62 06/01/2019 GEN 69147* FIONA DEAN OR SHAWN SMITH DEP REFUND/APPLIED 235-000- 00 45.50 06/01/2019 GEN 691484 FREMONT INDUSTRIES INC F-9918 154-000- 00 694.29 Sales Tax Receivable - Replace 186-000- 00 28.33 FWT-5, 45 Micromho 401-550- 01 76.62 FWT-6, 445 Micromho 401-550- 01 74.52 Accessory Plant - Materials 402-554- 01 412.00 HECK GEN 69148 TOTAL 1,285.76 06/01/2019 GEN 69150* GUARDIAN DENTAL INSURANCE-80o ELEC 242-000- 00 3, 655.74 DENTAL INSURANCE -COBRA 242-000- 00 318.27 HECK GEN 69150 TOTAL 3,974.01 06/01/2019 GEN 69151 HAGER JEWELRY INC Breakroom/Recognition Banquet 401-926- 08 125.63 06/01/2019 GEN 69152 HER ENGINEERING INC Generators 107-344- 00 14,610.93 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Payee Description Account Pag Dept 4/25 Amount Fund: 1 ELECTRIC 06/01/2019 GEN 6915314 HILLYARD/HUTCHINSON Grounds - Materials 401-935- 08 11.76 06/01/2019 GEN 69154* HUTCHINSON CENTER FOR THE ARTS DEP REFUND/APPLIED 235-000- 00 195.00 06/01/2019 GEN 69155 IRBY TOOL & SAFETY Uniforms & Laundry 401-588- 02 484.23 06/01/2019 GEN 69156* IRIS ROGNLI DEP REFUND/APPLIED 235-000- 00 104.00 06/01/2019 GEN 69157* JACOB HOFFMAN OR JAMES ROGERS DEP REFUND/APPLIED 235-000- 00 178.75 06/01/2019 GEN 69158* JACOB MILLER DEP REFUND/APPLIED 235-000- 00 71.50 06/01/2019 GEN 69159* JAY MALONE OR KRISTEN MALONE DEP REFUND/APPLIED 235-000- 00 149. 50 06/01/2019 GEN 69160 JBETCO LLC OVERPAYMENTS 142-000- 00 42.81 06/01/2019 GEN 69161* JENNIFER TRUE DEP REFUND/APPLIED 235-000- 00 94.25 06/01/2019 GEN 69162 JEROME STOLL Cip - Residential 401-916- 07 25.00 06/01/2019 GEN 69163 JLR GARAGE DOOR SERVICE INC Building & Grounds - Materials 402-592- 02 135.69 06/01/2019 GEN 69164* JOHN PEWS DEP REFUND/APPLIED 235-000- 00 48.75 06/01/2019 GEN 69165* KELLY RUPP DEP REFUND/APPLIED 235-000- 00 266.50 06/01/2019 GEN 69167* KRISTA D HORST OR JOESPH HOLMGREM DEP REFUND/APPLIED 235-000- 00 130.00 06/01/2019 GEN 69168* KRISTEN SAWYER OR KELSEY FRAHM DEP REFUND/APPLIED 235-000- 00 130.00 06/01/2019 GEN 69169* KYLE JORGENSEN OR PAIGE JORGENSEN DEP REFUND/APPLIED 235-000- 00 136.50 06/01/2019 GEN 69170* LUREE HARGROVE DEP REFUND/APPLIED 235-000- 00 162.50 06/20/2019 10:20 AM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES Pag 5/25 User: JMartig CHECK DATE FROM 05/23/2019 - 06/20/2019 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Amount Fund: 1 ELECTRIC 06/01/2019 GEN 69171* MARCO TECHNOLOGIES, LLC Office Supplies 401-921- 08 323.24 06/01/2019 GEN 69172* MAYCE STEFFEN GET REFUND/APPLIED 235-000- 00 78.00 06/01/2019 GEN 69173* MEDICA HEALTH INSURANCE 85% ELEC 242-000- 00 54,198.19 HEALTH INSURANCE -COBRA 242-000- 00 1,789.14 HECK GEN 69173 TOTAL 55,987.33 06/01/2019 GEN 69174* MEGAN VAN OORT OR JORDAN VAN OORT GET REFUND/APPLIED 235-000- 00 204.75 06/01/2019 GEN 69175* METRO PCS GET REFUND/APPLIED 235-000- 00 520.00 06/01/2019 GEN 69176 MID-CONTINENT SALES O-RING, NOZZEL, FUEL, 154-000- 00 105. 96 06/01/2019 GEN 69177* MN NCPERS LIFE INSURANCE-PERA LIFE 242-000- 00 48.00 06/01/2019 GEN 69178* MORGAN HOLDER GET REFUND/APPLIED 235-000- 00 113.75 06/01/2019 GEN 69179* NANCY DAHL GET REFUND/APPLIED 235-000- 00 39.00 06/01/2019 GEN 69180 PFC EQUIPMENT INC FILTER, WATER INJECTION PUMP. 10" - 5 154-000- 00 181.52 Sales Tax Receivable - Replace 186-000- 00 13.39 HECK GEN 69180 TOTAL 194.91 06/01/2019 GEN 69181*4 PRO AUTO & TRANSMISSION REPAIR VEHICLES - MATERIAL-ELEC 402-598- 02 158. 96 06/01/2019 GEN 69182* RELIANCE STANDARD LIFE -LIFE LTD INSURANCE-80o ELEC 242-000- 00 1, 400.25 LIFE INSURANCE-80o ELEC 242-000- 00 762.81 HECK GEN 69182 TOTAL 2,163.06 06/01/2019 GEN 69183* RICK GRANT Cip - Residential 401-916- 07 400.00 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Payee Description Account Pag Dept 6/25 Amount Fund: 1 ELECTRIC 06/01/2019 GEN 691844 RUNNING'S SUPPLY INC Generators 107-344- 00 11.58 Sales Tax Receivable - Replace 186-000- 00 0.85 Supplies 401-550- 01 117.40 Vehicles - Material 402-598- 02 55.29 HECK GEN 69184 TOTAL 185.12 06/01/2019 GEN 69186* STEVEN WHITED GET REFUND/APPLIED 235-000- 00 162.50 06/01/2019 GEN 69187* TARA EVANSON GET REFUND/APPLIED 235-000- 00 26.00 06/01/2019 GEN 69188* TASC HEALTH INSURANCE-HRA FEES 401-926- 08 534.38 06/01/2019 GEN 69189* TED DOMEIER GET REFUND/APPLIED 235-000- 00 78.00 06/01/2019 GEN 69190* TIGER CAPITAL LLC GET REFUND/APPLIED 235-000- 00 195.00 06/01/2019 GEN 69191*4 TOTALFUNDS COLLECTION - MATERIALSI/2 OF 55/45 401-903- 06 1,100.00 POSTAGE 1/2 75/25 401-921- 08 1,500.00 HECK GEN 69191 TOTAL 2,600.00 06/01/2019 GEN 69192* WASTENA GILL GET REFUND/APPLIED 235-000- 00 32.50 06/01/2019 GEN 69193* WOODSTONE OF HUTCHINSON GET REFUND/APPLIED 235-000- 00 5,525.00 06/04/2019 GEN 390(E) MISO Deferred Energy Cost - Miso 174-000- 00 36,516.53 Deferred Energy Cost - Miso 174-000- 00 884.53 HECK GEN 390(E) TOTAL 37,401.06 06/05/2019 GEN 69194* A R ENGH HEATHING AND AIR COND, Grounds - Outside Services 401-935- 08 234.40 Grounds - Outside Services 401-935- 08 288.75 Grounds - Outside Services 401-935- 08 337.50 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Payee Description Account Pag Dept 7/25 Amount Fund: 1 ELECTRIC HECK GEN 69194 TOTAL 860.65 06/05/2019 GEN 691954 AG SYSTEMS INC Sales Tax Receivable - Replace 186-000- 00 0.73 Accessory Plant - Materials 402-554- 01 10.58 HECK GEN 69195 TOTAL 11.31 06/05/2019 GEN 69196 ALICE ILAR OVERPAYMENTS 142-000- 00 2.03 06/05/2019 GEN 69197 BARRY SCHAFFER OR JULIE SCHAFFER OVERPAYMENTS 142-000- 00 143. 98 06/05/2019 GEN 69198* BORDER STATES ELECTRIC SUPPLY BULB, 150W, HIS LU150/55 HIS LAMP 44043 154-000- 00 466.32 SPLIT BOLT 48 KS-15 Cu BURNDY 154-000- 00 13.80 SPLICE, YS1J4W4W Al/CU 46 to 46 BURNDY 154-000- 00 40.00 SPADE LUG 1/0-48TN HOMAC SA1/0-48 154-000- 00 24.60 TAPE, SUPER 33+ PROFESSIONAL GRADE 154-000- 00 80.20 TAPE, RED, 3/4" x 66, 3M SCOTCH 35 154-000- 00 38.80 INHIBITOR, OXIDE, DE-OX, 8 OR, ILSCO 154-000- 00 49. 32 PHOTO EYE, TWIST LOCK,(FOR LED) 154-000- 00 424.83 Sales Tax Receivable - New 186-000- 00 0.95 Sales Tax Receivable - New 186-000- 00 16.02 HECK GEN 69198 TOTAL 1,154.84 06/05/2019 GEN 69199 CARTER GILBERTSON OVERPAYMENTS 142-000- 00 158.40 06/05/2019 GEN 69200 CATHERINE ELLER OVERPAYMENTS 142-000- 00 13. 02 06/05/2019 GEN 69201 CELINA ANDERSON OVERPAYMENTS 142-000- 00 28.05 06/05/2019 GEN 692024 CENTRAL HYDRAULICS Sales Tax Receivable - Replace 186-000- 00 31.86 Supplies 401-550- 01 7.71 Accessory Plant - Materials 402-554- 01 432.00 HECK GEN 69202 TOTAL 471.57 06/05/2019 GEN 69204*4 CINTAS CORPORATION 4470 Uniforms & Laundry 401-550- 01 388.04 UNIFORMS & LAUNDRY 401-588- 02 286.43 HECK GEN 69204 TOTAL 674.47 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Description Fund: 1 ELECTRIC 06/05/2019 GEN 69205 CORE & MAIN 06/05/2019 GEN 69206 CULLEN RAASCH 06/05/2019 GEN 69207 DALTON SCURR 06/05/2019 GEN 69208 DELMAR COMPANY 06/05/2019 GEN 69209 EVAN YU 06/05/2019 GEN 69210* FIRST CHOICE FOOD & BEVERAGE 06/05/2019 GEN 692114 FREMONT INDUSTRIES INC 06/05/2019 GEN 69212*4 GOPHER STATE ONE -CALL INC 06/05/2019 GEN 69214 HUG ENGINEERING INC USA 06/05/2019 GEN 69216 JAKE DELAROSBY 06/05/2019 GEN 69217 KELLYS DANCE ACADEMY 06/05/2019 GEN 69218 MARIANNA DEIBLER 06/05/2019 GEN 692194 MATHESON TRI-GAS INC 06/05/2019 GEN 69221 MIKAYLA MCILRATH 06/05/2019 GEN 69222 NATHAN SHIELDS 06/05/2019 GEN 69224* NUVERA Pag 8/25 Account Dept Amount METER READING - MATERIALS 401-902- 06 3,000.00 OVERPAYMENTS 142-000- 00 123.44 OVERPAYMENTS 142-000- 00 60.76 GASKET, FLEXITALLIC, HAND HOLE 3" X 4" 154-000- 00 158.16 GASKET, FLEXITALLIC, HAND HOLE 3" X 4" 154-000- 00 21.03 HECK GEN 69208 TOTAL 179.19 OVERPAYMENTS 142-000- 00 56. 97 BREAKROOM/RECOGNITION BANQUET 401-926- 08 89.25 Sales Tax Receivable - Replace 186-000- 00 48.74 Fremont IN: 040199 402-554- 01 709.00 HECK GEN 69211 TOTAL 757.74 LINE - MATERIALS 401-581- 02 193.05 SENSOR, NOS, 24V 154-000- 00 1,845.67 OVERPAYMENTS 142-000- 00 46.63 OVERPAYMENTS 142-000- 00 20.10 OVERPAYMENTS 142-000- 00 65.64 Sales Tax Receivable - Replace 186-000- 00 5.65 Generator 41 Material 402-554- 01 82.12 HECK GEN 69219 TOTAL 87.77 OVERPAYMENTS 142-000- 00 101.65 OVERPAYMENTS 142-000- 00 102.85 TELEPHONE 401-921- 08 1,886.90 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Payee Description Account Pag Dept 9/25 Amount Fund: 1 ELECTRIC 06/05/2019 GEN 6922514 O'REILLY AUTOMOTIVE INC Sales Tax Receivable - Replace 186-000- 00 2.95 Generator 41 Material 402-554- 01 39.99 Power Equipment - Materials 402-598- 02 113.71 HECK GEN 69225 TOTAL 156.65 06/05/2019 GEN 69226*4 OXYGEN SERVICE COMPANY INC Supplies 401-550- 01 86.04 Materials 402-574- 03 131.12 HECK GEN 69226 TOTAL 217.16 06/05/2019 GEN 692274 QUADE ELECTRIC Generators 107-344- 00 579.05 Sales Tax Receivable - Replace 186-000- 00 39.80 Sales Tax Receivable - Replace 186-000- 00 3.70 Accessory Plant - Materials 402-554- 01 53.90 HECK GEN 69227 TOTAL 676.45 06/05/2019 GEN 69228 ROD EQUIPMENT PRODRILL 402-598- 02 304.60 PRODRILL 402-598- 02 0.01 PRODYNE 402-598- 02 193.00 Power Equipment - Materials 402-598- 02 68.27 HECK GEN 69228 TOTAL 565.88 06/05/2019 GEN 69229 SAMANTHA STIMPERT OVERPAYMENTS 142-000- 00 48.89 06/05/2019 GEN 69230 SARAH KUHN OVERPAYMENTS 142-000- 00 86.86 06/05/2019 GEN 69231 SHANE WAGNER OR AMANDA HAWKINSON OVERPAYMENTS 142-000- 00 47. 82 06/05/2019 GEN 69232* SHRED RIGHT OFFICE SUPPLIES -SHREDDING SERVICES 401-921- 08 12.48 06/05/2019 GEN 69233 THOMAS TRAMP OVERPAYMENTS 142-000- 00 1,414.05 06/05/2019 GEN 69234* UNITED PARCEL SERVICE MAIL SERVICES - UPS, FEDEX 401-921- 08 190.37 06/05/2019 GEN 69235* VERIZON WIRELESS TELEPHONE 401-921- 08 1,236.04 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Description Fund: 1 ELECTRIC 06/10/2019 GEN 400(E)* CITIZENS BANK 06/10/2019 GEN 401(E)* TASC 06/11/2019 GEN 391(E) MISO 06/13/2019 GEN 69238*4 ACE HARDWARE 06/13/2019 GEN 69239 AMANDA TROST 06/13/2019 GEN 69240 ANDREA MITCHELL 06/13/2019 GEN 69241 ASHLEE WELLS 06/13/2019 GEN 692424 AUTOMATIONDIRECT.COM INC 06/13/2019 GEN 69243*4 BORDER STATES ELECTRIC SUPPLY Account Dept Pag 10/25 Amount Office Supplies 401-921- 08 119.02 Prepaid HRA 174-000- 00 3,458.25 Deferred Energy Cost - Miso 174-000- 00 14,430.93 Deferred Energy Cost - Miso 174-000- 00 870.99 HECK GEN 391(E) TOTAL 15,301.92 Generators 107-344- 00 7.59 Sales Tax Receivable - Replace 186-000- 00 0.52 Sales Tax Receivable - Replace 186-000- 00 0.66 Supplies 401-550- 01 77.93 Maint Power Prod Plant - Build 402-554- 01 90.52 Accessory Plant - Materials 402-554- 01 9.59 Maintenance Other - Materials 402-554- 01 103.28 Materials 401-588- 02 44.00 Materials 402-574- 03 8.30 HECK GEN 69238 TOTAL 342.39 OVERPAYMENTS 142-000- 00 50.29 Cip - Residential 401-916- 07 25.00 OVERPAYMENTS 142-000- 00 30.69 Sales Tax Receivable - Replace 186-000- 00 5.98 LED pushbutton -part 4GCX3211-24L 402-554- 01 14.50 LED white pilot It part 4ECX2055-24L 402-554- 01 35.00 LED red pilot light part # ECX2051-24L 402-554- 01 26.25 LED green pilot light part # ECX2052- 402-554- 01 5.25 HECK GEN 69242 TOTAL 86.98 CONDUCTOR, 14 TW BLACK SOL 154-000- 00 355.00 CONDUCTOR, 14 TW WHITE SOL 154-000- 00 355.00 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Payee Description Account Pag Dept 11/25 Amount Fund: 1 ELECTRIC BUSHING, WELL INSERT, 200A, COOPER 154-000- 00 241.00 DUST CAP, 600A, COOPER DPC625 154-000- 00 438.30 Sales Tax Receivable - New 186-000- 00 48.82 Sales Tax Receivable - New 186-000- 00 46.70 BATTERY, SIZE AA 401-550- 01 40.03 BATTERY, SIZE D 401-581- 02 144.72 BATTERY, SIZE AAA 401-935- 08 40.03 HECK GEN 69243 TOTAL 1,709.60 06/13/2019 GEN 69244 BRANDON TIRE Vehicles - Material 402-598- 02 630.94 06/13/2019 GEN 69245 BRENT SCHMELING Cip - Residential 401-916- 07 25.00 06/13/2019 GEN 69247* CARD SERVICES BREAKROOM/RECOGNITION BANQUET 401-926- 08 237.14 06/13/2019 GEN 69248 CHRIS HANSEN OVERPAYMENTS 142-000- 00 12.57 06/13/2019 GEN 69249 CHUCK STENBERG Cip - Residential 401-916- 07 25.00 06/13/2019 GEN 69250*4 CINTAS CORPORATION 4470 Uniforms & Laundry 401-550- 01 386.04 T-SHIRT, NAVY BLUE, SIZE 401-550- 01 625.00 T-SHIRT, NAVY BLUE, SIZE 401-550- 01 22.68 T-SHIRT, NAVY BLUE, SIZE 401-550- 01 480.00 T-SHIRT, NAVY BLUE, SIZE 401-550- 01 17.41 T-SHIRT, NAVY BLUE, SIZE 401-550- 01 240.00 T-SHIRT, NAVY BLUE, SIZE 401-550- 01 9.54 T-SHIRT, NAVY BLUE, SIZE X-LARGE 401-550- 01 600.00 T-SHIRT, NAVY BLUE, SIZE X-LARGE 401-550- 01 23.86 UNIFORMS & LAUNDRY 401-588- 02 286.43 T-SHIRT, ORANGE, SIZE XX-LARGE TALL, 401-588- 02 480.00 T-SHIRT, ORANGE, SIZE XX-LARGE TALL, 401-588- 02 17.41 T-SHIRT, ORANGE, SIZE LARGE REGULAR, 401-588- 02 480.00 T-SHIRT, ORANGE, SIZE LARGE REGULAR, 401-588- 02 19.09 T-SHIRT, ORANGE, SIZE XXX-LARGE REGULAR 401-588- 02 360.00 T-SHIRT, ORANGE, SIZE XXX-LARGE REGULAR 401-588- 02 14. 32 HECK GEN 69250 TOTAL 4,061.78 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Payee Description Account Pag Dept 12/25 Amount Fund: 1 ELECTRIC 06/13/2019 GEN 6925114 CITY OF HUTCHINSON VEHICLE/EQUIPMENT FUEL -POWER 401-550- 01 110.65 VEHICLES/EQUIPMENT FUEL-ELEC 401-588- 02 1,536.01 Grounds - Materials 401-935- 08 16.50 VEHICLES/EQUIPMENT FUEL-ADMIN 55/45 401-935- 08 107.04 HECK GEN 69251 TOTAL 1,770.20 06/13/2019 GEN 69252 COUNTRYSIDE FLAGPOLE Supplies 401-550- 01 157.11 06/13/2019 GEN 69253 CREEKSIDE SOILS Materials 401-588- 02 43.28 06/13/2019 GEN 69254* DEPARTMENT OF THE TREASURY Health Insurance 242-000- 00 99. 96 06/13/2019 GEN 69255* DONNA OLSEN Cip - Residential 401-916- 07 425.00 06/13/2019 GEN 69256 ELI MILLER OVERPAYMENTS 142-000- 00 105.27 06/13/2019 GEN 692574 FASTENAL COMPANY Sales Tax Receivable - Replace 186-000- 00 0.44 Accessory Plant - Materials 402-554- 01 6.47 HECK GEN 69257 TOTAL 6.91 06/13/2019 GEN 69258* FIRST CHOICE FOOD & BEVERAGE BREAKROOM/RECOGNITION BANQUET 401-926- 08 85.50 06/13/2019 GEN 69259 FREMONT INDUSTRIES INC TOWER INHIBITOR, F-9173 154-000- 00 1,979.89 TOWER INHIBITOR, F-9173 154-000- 00 64.99 HECK GEN 69259 TOTAL 2,044.88 06/13/2019 GEN 69261 HER ENGINEERING INC Professional Services - Outsid 401-557- 03 4,638.96 06/13/2019 GEN 69262 HEARING HELP AUDIOLOGY CLINIC TRAINING - EXPENSE 401-546- 01 385.00 06/13/2019 GEN 69263 HILLYARD/HUTCHINSON Supplies 401-550- 01 67.50 06/13/2019 GEN 69264* HUTCHINSON LEADER Cip - Marketing 401-916- 07 407.56 06/13/2019 GEN 69265 HUTCHINSON WHOLESALE SUPPLY CO Materials 401-588- 02 3.08 06/13/2019 GEN 69266 JANICE HEINTZ Cip - Residential 401-916- 07 250.00 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Description Fund: 1 ELECTRIC 06/13/2019 GEN 69267 JLR GARAGE DOOR SERVICE INC 06/13/2019 GEN 69269 JOHN BRUNKHORST 06/13/2019 GEN 69271 JUUL CONTRACTING COMPANY 06/13/2019 GEN 69272 KAREN GRUND 06/13/2019 GEN 69274* LEAGUE OF MN CITIES INS TRUST 06/13/2019 GEN 69275 LEROY HLAVKA 06/13/2019 GEN 69276*4 LOCATORS & SUPPLIES INC 06/13/2019 GEN 69277 MATTHEW EVERS 06/13/2019 GEN 692784 MCC ENERGY SOLUTIONS, LLC 06/13/2019 GEN 69281* MINNESOTA COMMERCE DEPT 06/13/2019 GEN 69285 PABLO GARCIA 06/13/2019 GEN 69286 PATRICIA A KRIPPNER 06/13/2019 GEN 69287* PEACE LUTHERN CHURCH 06/13/2019 GEN 69288* PREMIUM WATERS INC 06/13/2019 GEN 69290 TAYA HUNTLEY 06/13/2019 GEN 69291 TAYA HUNTLEY 06/13/2019 GEN 69292 FIANNA EVANS Account Dept Pag 13/25 Amount Accessory Plant - Materials 402-554- 01 156.25 Cip - Residential 401-916- 07 25.00 PRIME MOVERS/RENEWABLES 107-343- 00 905.00 OVERPAYMENTS 142-000- 00 75. 94 PREPAID INSURANCE 174-000- 00 174.81 Cip - Residential 401-916- 07 25.00 SAFETY GLASSES, GRAY, SILVER MIRROR, 401-550- 01 46.46 RAIN PANTS, 1501TFY, SIZE 2XL 401-550- 01 93.74 SAFETY GLASSES, GRAY, SILVER MIRROR, 401-588- 02 46.46 HECK GEN 69276 TOTAL 186.66 Cip - Residential 401-916- 07 25.00 I AM MANAGEMENT FEES 401-555- 02 3,900.00 IAM USAGE FEES 401-556- 03 3,050.00 CHECK GEN 69278 TOTAL 6,950.00 Doc - Cip Assessment 401-916- 07 5,197.38 OVERPAYMENTS 142-000- 00 14.31 OVERPAYMENTS 142-000- 00 95.83 Cip- Commercial 401-916- 07 300.00 OFFICE SUPPLIES -BOTTLED WATER 401-921- 08 47.45 OVERPAYMENTS 142-000- 00 19. 43 OVERPAYMENTS 142-000- 00 16.05 OVERPAYMENTS 142-000- 00 49. 83 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Payee Description Account Pag Dept 14/25 Amount Fund: 1 ELECTRIC 06/13/2019 GEN 69293* TRANS LEASE/SERVICE AGREEMENTS 401-921- 08 910.31 06/13/2019 GEN 69294 TRENCHERS PLUS INC Vehicles/Equipment Fuel 401-588- 02 2,999.50 06/13/2019 GEN 69295 TWO-WAY COMMUNICATIONS INC Telephone 401-921- 08 182.48 06/13/2019 GEN 69296*4 WEST CENTRAL SANITATION INC GENERATOR 41 WATER & SEWER 401-547- 01 88.74 Waste Disposal 401-550- 01 143.25 UTILITY EXPENSES - WATER/WASTE 55/45 401-930- 08 216.49 HECK GEN 69296 TOTAL 448.48 06/13/2019 GEN 69297 YVONNE OLINGER Cip - Residential 401-916- 07 25.00 06/16/2019 GEN 393(E)*4 VISA PRIME MOVERS/RENEWABLES 107-343- 00 892.95 GENERATORS -INSULATION 107-344- 00 27.14 Sales Tax Receivable - Replace 186-000- 00 44.42 Sales Tax Receivable - Replace 186-000- 00 6.11 Sales Tax Receivable - Replace 186-000- 00 92.09 Sales Tax Receivable - Replace 186-000- 00 65.86 SUPPLIES 401-550- 01 297.14 SUPPLIES -PAINT 401-550- 01 70. 82 SUPPLIES -USE TX 19.52 401-550- 01 283.94 GENERATOR 41 MATERIALREPAIRS 402-554- 01 602.29 GENERATOR 45 LABOR -INVERTER DRIVE 402-554- 01 1,248.72 GENERATOR 45 LABORC-PLUGS 402-554- 01 1,301.64 ACCESSORY PLANT - MATERIAL -TEMP LTE 402-554- 01 82.87 Maintenance Other - Materials 402-554- 01 23.66 Training - Expense 401-580- 02 120.64 Meetings & Travel - Expense (S 401-580- 02 762.00 Materials 401-588- 02 408.52 UNIFORMS & LAUNDRY-ELEC BIBS 401-588- 02 134.99 OFFICE SUPPLIES-VERIDESK/FLOWERS 401-921- 08 695.39 OFFICE SUPPLIES -CELL ACCESSORIES 401-921- 08 30.05 BREAKROOM/RECOGNITION BQT-DALES 401-926- 08 466.76 TRAINING - EXPENSE 401-930- 08 74.50 Grounds - Materials 401-935- 08 133.42 06/20/2019 10:20 AM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES User: JMartig CHECK DATE FROM 05/23/2019 - 06/20/2019 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Fund: 1 ELECTRIC HECK GEN 393(E) TOTAL 06/18/2019 GEN 392(E) MISO Deferred Energy Cost - Miso 174-000- 00 Deferred Energy Cost - Miso 174-000- 00 HECK GEN 392(E) TOTAL 06/20/2019 GEN 394(E)* MINNESOTA REVENUE State Sales Tax 242-000- 00 State Sales Tax 242-000- 00 City Sales Tax 242-000- 00 City Sales Tax 242-000- 00 HECK GEN 394(E) TOTAL 06/20/2019 GEN 395(E) MISO SCHEDULE 10 401-565- 03 06/20/2019 GEN 396(E) MRES Purchased Power 401-555- 02 06/20/2019 GEN 397(E)* POINT & PAY collection - Materials 401-903- 06 06/20/2019 GEN 402(E) MISO SCHEDULE 26 401-565- 03 SCHEDULE 26A 401-565- 03 HECK GEN 402(E) TOTAL 06/20/2019 GEN 403(E) MISO SCHEDULE 1 401-565- 03 SCHEDULE 2 401-565- 03 MISC 401-565- 03 HECK GEN 403(E) TOTAL Total for fund 1 ELECTRIC Pag 15/25 Amount 7,865.92 10,877.50 819.17 11,696.67 53,000.00 54,004.00 3,200.00 3,899.00 114,103.00 6,234.35 903,432.40 2,003.22 18,318.16 5,149.26 13,799.75 1,961,713.09 06/20/2019 10:20 AM CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES User: JMartig CHECK DATE FROM 05/23/2019 - 06/20/2019 DE: Hutchinson Utili Check Date Bank Check # Payee Description Account Dept Fund: 2 GAS 05/24/2019 GEN 380(E)*4 BP CANANDA ENERGY SOLUTIONS GAS FOR RETAIL 401-807- 04 GAS FOR RETAIL 401-807- 04 Contract Gas For Retail 401-807- 04 Contract Gas For Retail 401-807- 04 Contract Gas For Retail 401-807- 04 Contract Gas For Retail 401-807- 04 Utility Expenses - Water/Waste 401-930- 08 HECK GEN 380(E) TOTAL 05/30/2019 GEN 388(E) BOND TRUST SERVICES CORPORATION 2012 BOND INTEREST 237-000- 00 06/01/2019 GEN 69121* 41 NAILS SPA DEP REFUND/APPLIED 235-000- 00 06/01/2019 GEN 69122* AARON JERGENS DEP REFUND/APPLIED 235-000- 00 06/01/2019 GEN 69123* ALLEN SMITH DEP REFUND/APPLIED 235-000- 00 06/01/2019 GEN 69124* ALLEN SMITH DEP REFUND/APPLIED 235-000- 00 06/01/2019 GEN 69125* AMY KING DEP REFUND/APPLIED 235-000- 00 06/01/2019 GEN 69126* AMY KING DEP REFUND/APPLIED 235-000- 00 06/01/2019 GEN 69127* ANDREW BERGLUND DEP REFUND/APPLIED 235-000- 00 06/01/2019 GEN 69128* BONNIE ALSLEBEN DEP REFUND/APPLIED 235-000- 00 06/01/2019 GEN 69129*4 BORDER STATES ELECTRIC SUPPLY 6" Weld Neck Flat Faced Flange, 150 401-874- 04 Materials 402-892- 04 Materials 402-892- 04 HECK GEN 69129 TOTAL Pag 16/25 Amount 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Payee Description Account Pag Dept 17/25 Amount Fund: 2 GAS 06/01/2019 GEN 69130* BROTHERS FIRE PROTECTION GROUNDS - OUTSIDE SERVICES 401-935- 08 103.40 06/01/2019 GEN 69131* CAROL MISKOVSKY DEP REFUND/APPLIED 235-000- 00 21.00 06/01/2019 GEN 69132* CASEY CLARK DEP REFUND/APPLIED 235-000- 00 70.00 06/01/2019 GEN 69134* CHAD KOENEN OR JENNIFER KOENEN DEP REFUND/APPLIED 235-000- 00 91.00 06/01/2019 GEN 69135* CHAD REINER DEP REFUND/APPLIED 235-000- 00 105.00 06/01/2019 GEN 69136*4 CINTAS CORPORATION 4470 UNIFORMS & LAUNDRY 401-880- 04 184.63 06/01/2019 GEN 69138*4 CREEKSIDE SOILS Services 107-380- 00 16.98 06/01/2019 GEN 69139* DARCY HUSTED OR SHEILA HUSTED DEP REFUND/APPLIED 235-000- 00 87.50 06/01/2019 GEN 69140* DAWN PEARSON DEP REFUND/APPLIED 235-000- 00 133.00 06/01/2019 GEN 69141* DEMETRIA COLLINS DEP REFUND/APPLIED 235-000- 00 17.50 06/01/2019 GEN 69142* ELIZABETH KAKOW OR THOMAS RADON DEP REFUND/APPLIED 235-000- 00 133.00 06/01/2019 GEN 69143* EVAN SCHANDORFF DEP REFUND/APPLIED 235-000- 00 21.00 06/01/2019 GEN 69147* FIONA DEAN OR SHAWN SMITH DEP REFUND/APPLIED 235-000- 00 24.50 06/01/2019 GEN 69149 GROEBNER & ASSOCIATES INC GAS, CALIBRATION, 2.5% BY VOL.(50oLEL) 154-000- 00 138.27 06/01/2019 GEN 69150* GUARDIAN DENTAL INSURANCE-20o GAS 242-000- 00 913. 94 06/01/2019 GEN 69153*4 HILLYARD/HUTCHINSON Materials 401-874- 04 126.62 Grounds - Materials 401-935- 08 9.63 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK Payee DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Description Account Pag Dept 18/25 Amount Fund: 2 GAS HECK GEN 69153 TOTAL 136.25 06/01/2019 GEN 69154* HUTCHINSON CENTER FOR THE ARTS DEP REFUND/APPLIED 235-000- 00 105.00 06/01/2019 GEN 69156* IRIS ROGNLI DEP REFUND/APPLIED 235-000- 00 56.00 06/01/2019 GEN 69157* JACOB HOFFMAN OR JAMES ROGERS DEP REFUND/APPLIED 235-000- 00 96.25 06/01/2019 GEN 69158* JACOB MILLER DEP REFUND/APPLIED 235-000- 00 38.50 06/01/2019 GEN 69159* JAY MALONE OR KRISTEN MALONE DEP REFUND/APPLIED 235-000- 00 80.50 06/01/2019 GEN 69161* JENNIFER TRUE DEP REFUND/APPLIED 235-000- 00 50.75 06/01/2019 GEN 69164* JOHN PEWS DEP REFUND/APPLIED 235-000- 00 26.25 06/01/2019 GEN 69165* KELLY RUPP DEP REFUND/APPLIED 235-000- 00 143.50 06/01/2019 GEN 69166 KGM KGM2005 Meter, AC-250, 107-381- 00 12,962.28 06/01/2019 GEN 69167* KRISTA D HORST OR JOESPH HOLMGREM DEP REFUND/APPLIED 235-000- 00 70.00 06/01/2019 GEN 69168* KRISTEN SAWYER OR KELSEY FRAHM DEP REFUND/APPLIED 235-000- 00 70.00 06/01/2019 GEN 69169* KYLE JORGENSEN OR PAIGE JORGENSEN DEP REFUND/APPLIED 235-000- 00 73.50 06/01/2019 GEN 69170* LUREE HARGROVE DEP REFUND/APPLIED 235-000- 00 87.50 06/01/2019 GEN 69171* MARCO TECHNOLOGIES, LLC OFFICE SUPPLIES 401-921- 08 107.74 06/01/2019 GEN 69172* MAYCE STEFFEN DEP REFUND/APPLIED 235-000- 00 42.00 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK Payee DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Description Account Pag Dept 19/25 Amount Fund: 2 GAS 06/01/2019 GEN 69173* MEDICA HEALTH INSURANCE 15% GAS 242-000- 00 9,564.39 06/01/2019 GEN 69174* MEGAN VAN OORT OR JORDAN VAN OORT GET REFUND/APPLIED 235-000- 00 110.25 06/01/2019 GEN 69175* METRO PCS GET REFUND/APPLIED 235-000- 00 280.00 06/01/2019 GEN 69177* MN NCPERS LIFE INSURANCE-PERA LIFE 242-000- 00 16.00 06/01/2019 GEN 69178* MORGAN HOLDER GET REFUND/APPLIED 235-000- 00 61.25 06/01/2019 GEN 69179* NANCY DAHL GET REFUND/APPLIED 235-000- 00 21.00 06/01/2019 GEN 69181*4 PRO AUTO & TRANSMISSION REPAIR VEHICLES - MATERIAL -GAS 402-895- 04 628.34 06/01/2019 GEN 69182* RELIANCE STANDARD LIFE -LIFE LTD INSURANCE-20o GAS 242-000- 00 350.07 LIFE INSURANCE-20o GAS 242-000- 00 190.71 HECK GEN 69182 TOTAL 540.78 06/01/2019 GEN 69183* RICK GRANT Cip - Residential 401-916- 07 400.00 06/01/2019 GEN 69185 RYAN ELLENSON Materials 401-856- 05 173.43 06/01/2019 GEN 69186* STEVEN WHITED GET REFUND/APPLIED 235-000- 00 87.50 06/01/2019 GEN 69187* TARA EVANSON GET REFUND/APPLIED 235-000- 00 14.00 06/01/2019 GEN 69188* TASC HEALTH INSURANCE-HRA FEES 401-926- 08 178.12 06/01/2019 GEN 69189* TED DOMEIER GET REFUND/APPLIED 235-000- 00 42.00 06/01/2019 GEN 69190* TIGER CAPITAL LLC GET REFUND/APPLIED 235-000- 00 105.00 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Payee Description Account Pag Dept 20/25 Amount Fund: 2 GAS 06/01/2019 GEN 69191*4 TOTALFUNDS collection - Materials 401-903- 06 900.00 Postage 401-921- 08 500.00 HECK GEN 69191 TOTAL 1,400.00 06/01/2019 GEN 69192* WASTENA GILL DEP REFUND/APPLIED 235-000- 00 17.50 06/01/2019 GEN 69193* WOODSTONE OF HUTCHINSON DEP REFUND/APPLIED 235-000- 00 2, 975.00 06/05/2019 GEN 69194* A R ENGH HEATHING AND AIR COND, Grounds - Outside Services 401-935- 08 78.13 Grounds - Outside Services 401-935- 08 96.25 Grounds - Outside Services 401-935- 08 112.50 HECK GEN 69194 TOTAL 286.88 06/05/2019 GEN 69198* BORDER STATES ELECTRIC SUPPLY FITTING, WELD STOP 4", LOW PRESSURE 154-000- 00 884.88 FITTING, WELD STOP 2", LOW PRESSURE 154-000- 00 377.91 TAPE, TEFLON, 1/2" X 260", HIGH 154-000- 00 10.52 CAP, FEMALE THRD, 3/4", BM CLASS 150 154-000- 00 17.21 FITTING, WELD STOP 2", LOW PRESSURE 154-000- 00 188. 95 HECK GEN 69198 TOTAL 1,479.47 06/05/2019 GEN 69203 CENTURYLINK Utilities (Electric, Satellite 401-856- 05 55.96 06/05/2019 GEN 69204*4 CINTAS CORPORATION 4470 UNIFORMS & LAUNDRY 401-880- 04 184.63 06/05/2019 GEN 69210* FIRST CHOICE FOOD & BEVERAGE BREAKROOM/RECOGNITION BANQUET 401-926- 08 29. 75 06/05/2019 GEN 69212*4 GOPHER STATE ONE -CALL INC MATERIALS 401-874- 04 193.05 MATERIALS 401-856- 05 44.55 HECK GEN 69212 TOTAL 237.60 06/05/2019 GEN 69213 GROEBNER & ASSOCIATES INC HP InTest for AAT-35/57, Test at 416-108- 04 2,266.71 06/05/2019 GEN 69215 HUGHES NETWORK SYSTEMS UTILITIES -NEW ULM COMMUNICATIONS 401-856- 05 106. 94 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Description Fund: 2 GAS 06/05/2019 GEN 69220 MIDWEST REGION GAS TASK FORCE 06/05/2019 GEN 69223 NORTHERN BORDER PIPELINE CO 06/05/2019 GEN 69224* NUVERA 06/05/2019 GEN 69225*4 O'REILLY AUTOMOTIVE INC 06/05/2019 GEN 69226*4 OXYGEN SERVICE COMPANY INC 06/05/2019 GEN 69232* SHRED RIGHT 06/05/2019 GEN 69234* UNITED PARCEL SERVICE 06/05/2019 GEN 69235* VERIZON WIRELESS 06/10/2019 GEN 400(E)* CITIZENS BANK 06/10/2019 GEN 401(E)* TASC 06/13/2019 GEN 69238*4 ACE HARDWARE 06/13/2019 GEN 69243*4 BORDER STATES ELECTRIC SUPPLY Account Dept Pag 21/25 Amount Dues/Membership Expense 401-930- 08 1,000.00 LINE - OUTSIDE SERVICES -INTERCONNECT 401-856- 05 2,000.00 TELEPHONE 401-921- 08 628.97 Materials 401-874- 04 180.13 Materials 401-874- 04 86.04 OFFICE SUPPLIES -SHREDDING SERVICES 401-921- 08 4.16 MAIL SERVICES - UPS, FEDEX 401-921- 08 63.46 TELEPHONE 401-921- 08 412.02 Office Supplies 401-921- 08 119.02 Prepaid HRA 174-000- 00 1,152.75 M & R Station Equipment 107-369- 00 1.47 Materials 401-874- 04 7.65 HECK GEN 69238 TOTAL 9.12 26-0217-0000-00, T.D. 107-376- 00 183.67 26-0212-0000, T.D. Williamson 107-376- 00 88.67 26-0218-0000-00, T. D. Williamson 107-376- 00 333.56 TDWS - 06-7218-0000-00 SHORTSTOPP 4IN 3 107-376- 00 2,311.62 VALVE, SAV-A-VALVE, 3/4" X 3", MUELLER 154-000- 00 178.01 NIPPLE, 1/4" X 6", BM, STD, SMLS, TEE 154-000- 00 19.53 VAVVE, BALL, 2" WELD X WELD, 154-000- 00 480.88 TAPE, BELOW GROUND USE, 41 WAX, 4" X 9 154-000- 00 513.50 BATTERY, SIZE C 401-874- 04 90.86 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Payee Description Account Pag Dept 22/25 Amount Fund: 2 GAS HECK GEN 69243 TOTAL 4,200.30 06/13/2019 GEN 69246 BROWN COUNTY RURAL ELECTRIC Utilities (Electric, Satellite 401-856- 05 136.94 06/13/2019 GEN 69247* CARD SERVICES BREAKROOM/RECOGNITION BANQUET 401-926- 08 79. 04 06/13/2019 GEN 69250*4 CINTAS CORPORATION 4470 UNIFORMS & LAUNDRY 401-880- 04 186.63 T-SHIRT, ORANGE, SIZE LARGE TALL, 401-880- 04 250.00 T-SHIRT, ORANGE, SIZE LARGE TALL, 401-880- 04 9.07 T-SHIRT, ORANGE, SIZE XXX-LARGE TALL, 401-880- 04 330.00 T-SHIRT, ORANGE, SIZE XXX-LARGE TALL, 401-880- 04 11.97 T-SHIRT, ORANGE, SIZE X-LARGE REGULAR, 401-880- 04 480.00 T-SHIRT, ORANGE, SIZE X-LARGE REGULAR, 401-880- 04 19.09 HECK GEN 69250 TOTAL 1,286.76 06/13/2019 GEN 69251*4 CITY OF HUTCHINSON VEHICLE/EQUIPMENT FUEL -GAS 401-880- 04 1,760.09 Grounds - Materials 401-935- 08 13.50 VEHICLES/EQUIPMENT FUEL-ADMIN 55/45 401-935- 08 87.57 HECK GEN 69251 TOTAL 1,861.16 06/13/2019 GEN 69254* DEPARTMENT OF THE TREASURY Health Insurance 242-000- 00 24.99 06/13/2019 GEN 69255* DONNA OLSEN Cip - Residential 401-916- 07 400.00 06/13/2019 GEN 69258* FIRST CHOICE FOOD & BEVERAGE BREAKROOM/RECOGNITION BANQUET 401-926- 08 28.50 06/13/2019 GEN 69260 GROEBNER & ASSOCIATES INC 006-24-071-00, Bottom Index Shaft Dog 416-108- 04 3.69 006-24-071-00, Bottom Index Shaft Dog 416-108- 04 1.49 950578, Retaining Ring Truarc X5113-11 416-108- 04 1.26 950578, Retaining Ring Truarc X5113-11 416-108- 04 0.51 006-24-423-01000, Index Shaft 416-108- 04 76.35 006-24-423-01000, Index Shaft 416-108- 04 30.82 HECK GEN 69260 TOTAL 114.12 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Description Fund: 2 GAS 06/13/2019 GEN 69264* HUTCHINSON LEADER 06/13/2019 GEN 69268 JOHN BOMSTAD 06/13/2019 GEN 69270 JON OTTESON PHOTOGRAPHY 06/13/2019 GEN 692734 KDUZ/KARP 06/13/2019 GEN 69274* LEAGUE OF MN CITIES INS TRUST 06/13/2019 GEN 69276*4 LOCATORS & SUPPLIES INC 06/13/2019 GEN 692794 MCLEOD COOPERATVIE POWER ASSN 06/13/2019 GEN 69280 MIDWAY FORD COMMERCIAL 06/13/2019 GEN 69281* MINNESOTA COMMERCE DEPT 06/13/2019 GEN 69282 MRC GLOBAL 06/13/2019 GEN 69283 NELSON TECHNOLOGIES INC Account Dept Pag 23/25 Amount CIP - MARKETING 401-916- 07 135.85 Cip - Residential 401-916- 07 25.00 Meetings & Travel - Expense (S 401-870- 04 107.38 PUBLIC AWARENESS - MATERIAL 401-874- 04 148.50 Public Awareness - Material 401-856- 05 49.50 HECK GEN 69273 TOTAL 198.00 PREPAID INSURANCE 174-000- 00 58.27 PAINT, LOCATING, INVERTED SURVEY 154-000- 00 505.01 PAINT, LOCATING, INVERTED SURVEY 154-000- 00 69.61 SAFETY GLASSES, GRAY, SILVER MIRROR, 401-880- 04 46.46 HECK GEN 69276 TOTAL 621.08 MISC EXPENSE -GAS LINE PUMP 401-880- 04 60.88 UTILITIES (ELECTRIC, SATELLITE-MCLEOD 401-856- 05 38.48 UTILITIES (ELECTRIC, SATELLITE -PIPELINE 401-856- 05 39.48 HECK GEN 69279 TOTAL 138.84 2019 Ford 3/4 Ton, Extended/Double Cab, 107-392- 00 30,145.50 2019 F350 4x4 Crew Cab, Cab and 107-392- 00 40,098.10 HECK GEN 69280 TOTAL 70,243.60 Doc - Cip Assessment 401-916- 07 1,721.06 PIPE, 2", ELK STEEL, BARE, API-5L, 154-000- 00 448.50 PIPE, 2", ELK STEEL, BARE, API-5L, 154-000- 00 27.15 HECK GEN 69282 TOTAL 475.65 3" 75 Durometer Diaphragm IN 103-105-01 402-892- 04 252.00 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee Fund: 2 GAS CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Description Account Dept 3" 75 Durometer Diaphragm IN 103-105-01 402-892- 04 Pilot Rebuild Kit IN 201-120-01 402-892- 04 Pilot Rebuild Kit IN 201-120-01 402-892- 04 Restrictor O-Ring Kit IN 240-004-01 402-892- 04 Restrictor O-Ring Kit IN 240-004-01 402-892- 04 Type 30 Filter Element IN 301-005-01 402-892- 04 Type 30 Filter Element IN 301-005-01 402-892- 04 75 Durometer Diaphragm IN 103-105-01 402-892- 04 75 Durometer Diaphragm IN 103-105-01 402-892- 04 Pilot Rebuild Kit IN 201-009-01 402-892- 04 Pilot Rebuild Kit IN 201-009-01 402-892- 04 Restrictor O-Ring Kit IN 240-004-01 402-892- 04 Restrictor O-Ring Kit IN 240-004-01 402-892- 04 Type 30 Filter Element IN 301-005-01 402-892- 04 Type 30 Filter Element IN 301-005-01 402-892- 04 HECK GEN 69283 TOTAL 06/13/2019 GEN 69284 NORTHERN STATES SUPPLY INC BLADE, PIDTSCI4P, 14"X.125X1" 402-895- 04 06/13/2019 GEN 69287* PEACE LUTHERN CHURCH Cip- Commercial 401-916- 07 06/13/2019 GEN 69288* PREMIUM WATERS INC OFFICE SUPPLIES -BOTTLED WATER 401-921- 08 06/13/2019 GEN 69289 SPRINT Utilities (Electric, Satellite 401-856- 05 06/13/2019 GEN 69293* TRANS LEASE/SERVICE AGREEMENTS 401-921- 08 06/13/2019 GEN 69296*4 WEST CENTRAL SANITATION INC UTILITY EXPENSES - WATER/WASTE 45/55 401-930- 08 06/16/2019 GEN 393(E)*4 VISA Meetings & Travel - Expense (S 401-870- 04 MATERIALS -SPRAY PAINT 401-874- 04 MATERIALS -SHOE COVERS 401-874- 04 MATERIALS -EQUIP RENTAL 402-892- 04 OTHER EQUIPMENT - DECALS/SENSIT REPAIRS 402-895- 04 AM INNOVATIONS REMOTE MONITORING 401-856- 05 OFFICE SUPPLIES-VERIDESK/FLOWERS 401-921- 08 Pag 24/25 Amount 24.59 324.00 31.61 98.40 9.60 112.80 it.00 504.00 47.42 324.00 30.48 98.40 9.26 112.80 10.61 2,000.97 173.99 800.00 15.82 141.52 303.44 177.12 40.36 255.00 98.99 1,647.14 134.44 89.00 568.95 06/20/2019 10:20 AM User: JMartig DE: Hutchinson Utili Check Date Bank Check # Payee Fund: 2 GAS CHECK DISBURSEMENT REPORT FOR HUTCHINSON UTILITIES CHECK DATE FROM 05/23/2019 - 06/20/2019 Description 06/20/2019 GEN 394(E)* MINNESOTA REVENUE 06/20/2019 GEN 397(E)* POINT & PAY 06/20/2019 GEN 398(E) PUBLIC ENERGY AUTHORITY OF OFFICE SUPPLIES -CELL ACCESSORIES Training - Expense Grounds - Materials HECK GEN 393(E) TOTAL State Sales Tax State Sales Tax City Sales Tax City Sales Tax HECK GEN 394(E) TOTAL METER READING - MATERIALS Gas For Retail 3M HECK GEN 398(E) TOTAL Total for fund 2 GAS TOTAL - ALL FUNDS '*'-INDICATES CHECK DISTRIBUTED TO MORE THAN ONE FUND '#'-INDICATES CHECK DISTRIBUTED TO MORE THAN ONE DEPARTMENT Account Dept 401-921- 08 401-930- 08 401-935- 08 242-000- 00 242-000- 00 242-000- 00 242-000- 00 401-903- 06 401-807- 04 401-807- 04 Pag 25/25 Amount 30.05 74.50 133.42 3,071.85 13,000.00 17,020.00 800.00 1,230.00 32,050.00 1,639.00 80,689.28 83,545.00 164,234.28 809,198.05 2,770,911.14 HUTCHINSON UTILITIES COMMISSION COMBINED DIVISIONS FINANCIAL REPORT FOR MAY, 2019 2019 2018 Di %Chng 2019 2018 Di %Chng Full YrBud %of Bud Combined Division Customer Revenue $ 2,417,574 $ 2,496,038 $ (78,464) (3.1%) $ 15,616,929 $ 16,027,384 $ (410,455) (2.6%) $ 36,285,018 43.0% Sales for Resale $ 193,049 $ 337,981 $ (144,932) (42.9%) $ 1,011,790 $ 1,264,701 $ (252,911) (20.0%) $ 2,951,500 34.3% NU Transportation $ 83,280 $ 71,033 $ 12,247 17.2% $ 411,876 $ 357,528 $ 54,348 15.2% $ 885,452 46.5% Electric Division Transfer $ 54,982 $ 54,697 $ 285 0.5% $ 274,910 $ 273,486 $ 1,424 0.5% $ 659,783 41.7% Other Revenues $ 39,096 $ 40,441 $ (1,345) (3.3%) $ 220,591 $ 228,080 $ (7,489) (3.3%) $ 490,208 45.0% Interest Income $ 31,910 $ 22,421 $ 9,489 42.3% $ 198,077 $ 127,895 $ 70,182 54.9% $ 283,456 69.9% TOTAL REVENUES $ 2,819,891 $ 3,022,611 $ (202,720) (6.7%) $ 17,734,172 $ 18,279,075 $ (544,902) (3.0%) $ 41,555,417 42.7% Salaries & Benefits $ 449,911 $ 462,476 $ (12,564) (2.72%) $ 2,411,779 $ 2,456,915 $ (45,137) (1.8%) $ 6,252,888 38.6% Purchased Commodities $ 1,319,824 $ 1,427,160 $ (107,336) (7.5%) $ 8,961,052 $ 8,996,850 $ (35,798) (0.4%) $ 19,155,179 46.8% Transmission $ 168,004 $ 201,236 $ (33,232) (16.5%) $ 986,574 $ 895,943 $ 90,631 10.1% $ 3,380,000 29.2% Generator Fuel/Chem. $ 13,403 $ 146,683 $ (133,280) (90.9%) $ 99,158 $ 390,235 $ (291,076) (74.6%) $ 1,139,850 8.7% Depreciation $ 327,083 $ 325,667 $ 1,417 0.4% $ 1,635,417 $ 1,628,333 $ 7,083 0.4% $ 3,925,000 41.7% Transfers (Elect./City) $ 188,434 $ 158,986 $ 29,448 18.5% $ 942,169 $ 794,931 $ 147,238 18.5% $ 2,261,207 41.7% Operating Expense $ 199,509 $ 179,687 $ 19,822 11.0% $ 1,068,359 $ 828,946 $ 239,413 28.9% $ 3,215,236 33.2% Debt Interest $ 97,334 $ 103,551 $ (6,218) (6.0%) $ 486,669 $ 517,757 $ (31,088) jLg%j $ 1,168,007 41.7% TOTAL EXPENSES $ 2,763,502 $ 3,005,447 $ (241,944) (8.1%) $ 16,591,177 $ 16,509,911 $ 81,266 0.5% $ 40,497,367 41.0% NET PROFIT/(LOSS) $ 56,388 $ 17,164 $ 39,224 228.5%1 $ 1,142,995 $ 1,769,164 $ (626,169) (35.4%) $ 1,058,050 108.0% May May YTD YTD 2019 2018 Change 2019 2018 Change Gross Margin % 33.9% 31.6% 2.3% 33.5% 36.3°% -2 8°% Operating Income Per Revenue $ (%) 3.7% 2.5% 1.2% 7.6% 11.3% -3.7% Net Income Per Revenue $ (%): 2.0% 0.6% 1.4% 6.4% 9.7% -3.2% 2019 HUC Budget Target 32.8°% 4.2°% 2.5°% HUTCHINSON UTILITIES COMMISSION ELECTRIC DIVISION FINANCIAL REPORT FOR MAY, 2019 2019 2018 Pi . Electric Division Customer Revenue $ 1,876,485 $ 2,075,123 $ (198,638) Sales for Resale $ 193,049 $ 337,981 $ (144,932) Other Revenues $ 15,477 $ 16,518 $ (1,041) Interest Income $ 17,349 $ 12,605 $ 4,744 TOTAL REVENUES $ 2,102,360 $ 2,442,227 $ (339,867) Salaries & Benefits $ 340,302 $ 366,258 $ (25,956) Purchased Power $ 1,030,864 $ 1,187,818 $ (156,954) Transmission $ 168,004 $ 201,236 $ (33,232) Generator Fuel/Chem. $ 13,403 $ 146,683 $ (133,280) Depreciation $ 241,667 $ 241,667 $ Transfers (Elect./City) $ 147,172 $ 128,224 $ 18,947 Operating Expense $ 151,392 $ 109,197 $ 42,195 Debt Interest $ 46,555 $ 47,376 $ (822) TOTAL EXPENSES $ 2,139,359 $ 2,428,460 $ (289,101) NET PROFIT/(LOSS) $ (36,999) $ 13,767 $ (50,765) %Chna 2019 2018 Di %Chna Full YrBud %of Bud (9.6%) $ 9,775,255 $ 9,866,504 $ (91,249) (0.9%) $ 26,118,530 37.4% (42.9%) $ 1,011,790 $ 1,264,701 $ (252,911) (20.0%) $ 2,951,500 34.3% (6.3%) $ 89,527 $ 81,763 $ 7,764 9.5% $ 203,500 44.0% 37.6% $ 106,391 $ 70,918 $ 35,473 50.0% $ 158,456 67.1% (13.9%) $ 10,982,963 $ 11,283,886 $ (300,923) (2.7%) $ 29,431,986 37.3% (7.1%) $ 1,830,058 $ 1,920,979 $ (90,921) (4.7%) $ 4,541,091 (13.2%) $ 5,585,594 $ 5,794,185 $ (208,591) (3.6%) $ 13,640,000 (16.5%) $ 986,574 $ 895,943 $ 90,631 10.1% $ 3,380,000 (90.9%) $ 99,158 $ 390,235 $ (291,076) (74.6%) $ 1,139,850 0.0% $ 1,208,333 $ 1,208,333 $ - 0.0% $ 2,900,000 14.8% $ 735,859 $ 641,122 $ 94,737 14.8% $ 1,766,062 38.6% $ 772,364 $ 557,681 $ 214,683 38.5% $ 2,173,291 (1.7%) $ 232,773 $ 236,882 $ (4,108) 1.7% $ 558,657 $ 30,098,951 (11.9%) $ 11,450,714 $ 11,645,360 $ (194,646) (1.7%) 368.8%) $ (467,751) $ (361,475) $ (106,277) 29.4% $ (666,965) 40.3% 41.0% 29.2% 8.7% 41.7% 41.7% 35.5% 41.7% 38.0% 70.1% 2019 2018 Di %Chna 2019 2018 Di . %Chna Full YrBud %of Bud Electric Division Residential 3,532,455 4,274,950 (742,495) (17.37%) 19,413,450 19,720,429 (306,979) (1.56%) 50,327,925 38.6% All Electric 129,558 127,658 1,900 1.49% 1,312,976 1,276,624 36,352 2.85% 2,504,213 52.4% Small General 1,432,597 1,625,565 (192,968) (11.87%) 7,731,260 7,706,362 24,898 0.32% 17,687,385 43.7% Large General 6,665,090 6,843,530 (178,440) (2.61%) 32,349,050 30,223,950 2,125,100 7.03% 77,713,164 41.6% Industrial 9,165,000 11,744,000 (2,579,000) (21.96%) 46,408,000 52,353,000 (5,945,000) (11.36%) 135,502,800 34.2% Total KWH Sold 20,924,700 24,615,703 (3,691,003) (14.99%) 107,214,736 111,280,365 (4,065,629) (3.65%)l 283,735,487 37.8% May May YTD YTD 2019 HUC 2019 2018 Change 2019 2018 Change Budget Target Gross Margin % 26.6% 26.3% 0.4% 25.0% 26.5% -1.5% 25.3% Operating Income Per Revenue $ (%) -0.4% 1.9% -2.2% -3.2% -1.8% -1.4% -0.9% 0%-5% Net Income Per Revenue $ (%): -1.8% 0.6% -2.3% -4.3% -3.2% -1.1% -2.3% 0%-5% Customer Revenue per KWH: $0.0897 $0.0843 $0.0054 $0.0908 $0.0883 $0.0025 $0.0915 $0.0915 Total Power Supply Exp. per KWH: $0.0731 $0.0727 $0.0004 $0.0760 $0.0740 $0.0020 $0.0771 Electric Divison Net Loss increased by $50,765 mostly due to a decrease in revenue. Usage was down among all classes. Transalta sales were also down. Expenses also decreased with the decrease in usage. Sales for Resale of $193,049 consisted of $9,208 in market sales, $36,400 in the monthly tolling fee from Transalta, $31,441 in Transalta energy sales, and $116,000 in capacity sales to SMMPA. May 2018 Sales for Resale of $337,981 consisted of $21,132 in market sales, $35,600 in monthly tolling fees from Transalta, $185,249 in Transalta energy sales, and $96,000 in capacity sales to SMMPA. May 2017 Sales for Resale of $137,718 consisted of $18,774 in market sales, $34,400 in Transalta tolling fees, $18,044 in Transalta energy sales, and capacity sales to SMMPA for $66,500. Overall Purchased Power decreased by $156,954. MRES purchases decreased by $29,050 and market purchases/MISO costs decreased by $127,904. May's power cost adjustment was $.00354/kwhr bringing in an additional $74,313 in revenue for the month and $634,987 YTD. Last year's power cost adjustment for May 2018 generated $0 in additional revenue for the month and $466,036 YTD. HUTCHINSON UTILITIES COMMISSION GAS DIVISION FINANCIAL REPORT FOR MAY, 2019 2019 2018 Di %Chng 2019 2018 Di %Chng Full YrBud %of Bud Gas Division Customer Revenue $ 541,089 $ 420,915 $ 120,174 28.6% $ 5,841,674 $ 6,160,881 $ (319,207) (5.2%) $ 10,166,488 57.5% Transportation $ 83,280 $ 71,033 $ 12,247 17.2% $ 411,876 $ 357,528 $ 54,348 15.2% $ 885,452 46.5% Electric Div. Transfer $ 54,982 $ 54,697 $ 285 0.5% $ 274,910 $ 273,486 $ 1,424 0.5% $ 659,783 41.7% Other Revenues $ 23,619 $ 23,922 $ (304) (1.3%) $ 131,064 $ 146,317 $ (15,253) (10.4%) $ 286,708 45.7% Interest Income $ 14,561 $ 9,817 $ 4,744 48.3% $ 91,686 $ 56,978 $ 34,708 60.9% $ 125,000 73.3% TOTAL REVENUES $ 717,530 $ 580,384 $ 137,146 23.6% $ 6,751,210 $ 6,995,189 $ (243,979) (3.5%) $ 12,123,431 55.7% Salaries & Benefits $ 109,609 $ 96,218 $ 13,391 13.9% $ 581,720 $ 535,936 $ 45,785 8.5% $ 1,711,797 34.0% Purchased Gas $ 288,959 $ 239,342 $ 49,617 20.7% $ 3,375,458 $ 3,202,665 $ 172,793 5.4% $ 5,515,179 61.2% Operating Expense $ 48,117 $ 70,490 $ (22,373) (31.7%) $ 295,995 $ 271,265 $ 24,730 9.1% $ 1,041,945 28.4% Depreciation $ 85,417 $ 84,000 $ 1,417 1.7% $ 427,083 $ 420,000 $ 7,083 1.7% $ 1,025,000 41.7% Transfers (City) $ 41,262 $ 30,762 $ 10,500 34.1% $ 206,310 $ 153,809 $ 52,501 34.1% $ 495,145 41.7% Debt Interest $ 50,779 $ 56,175 $ (5,396) 0.0% $ 253,896 $ 280,875 $ (26,979) ja.6% $ 609,350 41.7% TOTAL EXPENSES $ 624,144 $ 576,987 $ 47,157 8.2% $ 5,140,463 $ 4,864,551 $ 275,912 5.7% $ 10,398,416 49.4% NET PROFIT/(LOSS) $ 93,387 $ 3,398 $ 89,989 2,648.7%1 $ 1,610,747 $ 2,130,639 $ (519,892) (24.4%) $ 1,725,015 93.4% 2019 2018 Di %Chng 2019 2018 Di %Chng Full YrBud %of Bud Gas Division Residential 19,147,861 9,861,932 9,285,929 94.16% 277,908,569 264,324,003 13,584,566 5.14% 421,716,000 65.9% Commercial 15,431,474 10,118,354 5,313,120 52.51% 200,448,263 199,781,459 666,804 0.33% 330,746,000 60.6% Industrial 55,506,291 52,384,688 3,121,603 5.96% 420,614,995 429,787,437 (9,172,442) (2.13%) 822,478,000 51.1% Total CF Sold 90,085,626 72,364,974 17,720,652 24.49% 898,971,827 893,892,899 5,078,928 0.57% 1,574,940,000 57.1% May May YTD YTD 2019 HUC 2019 2018 Change 2019 2018 Change Budget Target Gross Margin % 55.9% 54.8% 1.1% 47.4% 52.3% -4.9% 51.5% Operating Income Per Revenue $ (%) 16.3% 5.6% 10.7% 25.5% 32.8% -7.3% 16.9% Net Income Per Revenue $ (%): 13.7% 0.6% 13.1% 24.7% 31.4% -6.7% 14.7% IIIIIIIIIIIIIIIIIIIII Contracted Customer Rev. per CF: $0.0037 $0.0037 $0.0000 $0.0042 $0.0041 $0.0001 $0.0038 IIIIIIIIIIIIIIIIIIIII Customer Revenue per CF: $0.0091 $0.0107 -$0.0016 $0.0084 $0.0093 -$0.0010 $0.0090 $0.0090 Total Power Supply Exp. per CF: $0.0034 $0.0034 ($0.0001) $0.0038 $0.0036 $0.0002 $0.0036 $0.0036 Natural Gas net income increased by $89,989. This is mostly due to higher customer revenue withincreased usage. Purchased gas increased with the higher usage. May's fuel cost credit adjustment was $1.45158/MCF totalling $55,584 for the month and $533,596 YTD. May 2018 credits totalled $16,873 for the month and $150,397. Current Assets UnrestrictedlUndesignated Cash Cash Petty Cash Designated Cash Capital Expenditures - Five Yr. CIP Payment in Lieu of Taxes Rate Stabilization - Electric Rate Stabilization - Gas Catastrophic Funds Restricted Cash Bond Interest Payment 2017 Bond Interest Payment 2012 Debt Service Reserve Funds Total Current Assets Receivables Accounts (net of uncollectible allowances) Interest Total Receivables Other Assets Inventory Prepaid Expenses Sales Tax Receivable Deferred Outflows - Electric Deferred Outflows - Gas Total Other Assets Total Current Assets Capital Assets Land & Land Rights Depreciable Capital Assets Accumulated Depreciation Construction - Work in Progress Total Net Capital Assets HUTCHINSON UTILITIES COMMISSION BALANCE SHEET - CONSOLIDATED MAY31, 2019 Electric Gas Total Division Division 2019 6,974,793.75 9,304,423.65 16,279,217.40 680.00 170.00 850.00 2,750,000.00 700,000.00 3,450,000.00 1,106,279.00 495,145.00 1,601,424.00 372,736.68 - 372,736.68 - 651,306.61 651,306.61 400,000.00 100,000.00 500,000.00 Total Net Change 2018 Total (YTD) 22,256,175.65 (5,976,958.25) 850.00 - 3,450,000.00 1,251,469.00 349,955.00 372,736.68 - 651,306.61 - 500,000.00 - 1,091,828.09 - 1,091,828.09 954,819.66 137,008.43 - 985,354.17 985,354.17 984,549.98 804.19 522,335.64 2,188,694.02 2,711,029.66 2,711,029.66 - 13,218,653.16 14,425,093.45 27,643,746.61 33,132,937.24 (5,489,190.63) 1,997,642.04 735,177.56 2,732,819.60 2,881,009.28 (148,189.68) 23,632.29 23,632.29 47,264.58 38,078.98 9,185.60 2,021,274.33 758,809.85 2,780,084.18 2,919,088.26 (139,004.08) 1,239,395.96 455,922.32 1,695,318.28 1,709,316.63 (13,998.35) 133,570.52 3,085.61 136,656.13 67,990.32 68,665.81 42,930.13 - 42,930.13 44,400.91 (1,470.78) 494,053.00 - 494,053.00 752,887.00 (258,834.00) - 164,685.00 164,685.00 250,962.00 (86,277.00) 1,909,949.61 623,692.93 2,533,642.54 2,825,556.86 (291,914.32) 17,149,877.10 15,807,596.23 690,368.40 3,899,918.60 90,204,538.76 41,684,214.28 (56,379,717.57) (16,513,489.53) 15,768,111.91 77,138.49 50,283,301.50 29,147,781.84 32,957,473.33 38,877,582.36 (5,920,109.03) 4,590,287.00 4,590,287.00 - 131,888,753.04 130,893,920.10 994,832.94 (72,893,207.10) (69,163,911.88) (3,729,295.22) 15,845,250.40 6,045,076.54 9,800,173.86 79,431,083.34 72,365,371.76 7,065,711.58 Total Assets 67,433,178.60 44,955,378.07 112,388,556.67 111,242,954.12 1,145,602.55 Current Liabilities Current Portion of Long-term Debt Bonds Payable Bond Premium Accounts Payable Accrued Expenses Accrued Interest Accrued Payroll Total Current Liabilities Long -Term Liabilities Noncurrent Portion of Long-term Debt 2017 Bonds 2012 Bonds 2003 Bonds Bond Premium 2012 Pension Liability- Electric Pension Liability - Electric OPEB Pension Liability - Nat Gas Pension Liability - Nat Gas OPEB Accrued Vacation Payable Accrued Severance Deferred Outflows - Electric Deferred Outflows - Nat Gas Total Long -Term Liabilities Net Position Retained Earnings Total Net Position HUTCHINSON UTILITIES COMMISSION BALANCE SHEET - CONSOLIDATED MAY31, 2019 Electric Gas Total Division Division 2019 625,000.00 2,815,969.51 43,116.11 3,484,085.62 16,050,000.00 618,953.76 2,700,290.00 72,192.00 366,391.02 77,139.06 804,800.00 20,689,765.84 1,370,000.00 185,608.32 597,845.41 12,132.66 2,165,586.39 12,530,000.00 1,206,453.71 900,097.00 24,064.00 111, 060.50 29,491.28 268,267.00 15,069,433.49 1,995,000.00 185,608.32 3,413,814.92 55,248.77 5,649,672.01 16,050,000.00 12,530,000.00 1,825,407.47 2,700,290.00 72,192.00 900,097.00 24,064.00 477,451.52 106,630.34 804,800.00 268,267.00 35,759,199.33 Total 2018 1,295,000.00 185,608.32 2,769,697.38 0.20 43,605.75 4,293,911.65 16,675,000.00 13,900,000.00 2,044,472.75 3,083,440.00 1,027,813.00 426, 510.04 102, 320.61 794,370.00 264,790.00 38,318,716.40 Net Change Total (YTD) 700,000.00 644,117.54 (0.20) 11, 643.02 1,355,760.36 (625,000.00) (1,370,000.00) (219,065.28) (383,150.00) 72,192.00 (127,716.00) 24,064.00 50,941.48 4,309.73 10,430.00 3,477.00 (2,559,517.07) 43,259,327.14 27,720,358.19 70,979,685.33 68,630,326.07 2,349,359.26 43,259,327.14 27,720,358.19 70,979,685.33 68,630,326.07 2,349,359.26 Total Liabilities and Net Position 67,433,178.60 44,955,378.07 112,388,556.67 111,242,954.12 1,145,602.55 Hutchinson Utilities Commission Cash -Designations Report, Combined 5/31/2019 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest May 2019 April 2019 Position Savings, Checking, Investments varies varies varies 27,643,746.61 28,224,445.58 (580,698.97) Total Operating Funds 27,643,746.61 28,224,445.58 (580,698.97) Debt Reserve Requirements Bond Covenants - sinking fund Debt Reserve Requirements Bond Covenants -1 year Max. P & I Total Restricted Funds 2,077,182.26 1,814,452.56 262,729.70 2,711,029.66 2,711,029.66 - 4,788,211.92 4,525,482.22 262,729.70 Operating Reserve Min 60 days of 2019 Operating Bud. 6,086,812.00 6,086,812.00 Rate Stabalization Funds 1,024,043.29 1,024,043.29 PILOT Funds Charter (Formula Only) 1,601,424.00 1,601,424.00 Catastrophic Funds Risk Mitigation Amount 500,000.00 500,000.00 Capital Reserves 5 Year CIP ( 2019-2023 Fleet & Infrastructure Maintenance) 3,450,000.00 3,450,000.00 Total Designated Funds 12,662,279.29 12,662,279.29 YE YE YE YE YTD HUC 2015 2016 2017 2018 2019 Target Debt to Asset 32.4% 32.2% 40.2% 37.7% 36.8% Current Ratio 2.52 3.06 3.36 3.93 4.87 RONA 1.31% 2.17% 1.82% 3.43% 1.13% Notes/Graphs: Change in Cash Balance (From 12131114 to 513112019) Month End Electric Elec. Change Natural Gas Gas Change Total Total Change 5/31/2019 13,218,653 14,425,093 27,643,747 12/31/2017 23,213,245 (9,994,592) 10,702,689 3,722,404 33,915,934 (6,272,187) 12/31/2016 8,612,801 14,600,444 9,500,074 1,202,615 18,112,875 15,803,059 12/31/2015 6,170,790 2,442,011 9,037,373 462,701 15,208,163 2,904,712 12/31/2014 3,598,821 2,571,969 6,765,165 2,272,208 10,363,986 4,844,177 * 2017's Signifcant increase in cash balance is due to issuing bonds for the generator project. Hutchinson Utilities Commission Cash -Designations Report, Electric 5/31/2019 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest May 2019 April 2019 Position Savings, Checking, Investments varies varies Total HUC Operating Funds Debt Restricted Requirements Bond Covenants - sinking fund Debt Restricted Requirements Bond Covenants -1 year Max. P & I Total Restricted Funds varies 27,643,746.61 28,224,445.58 (580,698.97) 27,643,746.61 28,224,445.58 (580,698.97) 1,091,828.09 993,190.06 98,638.03 522,335.64 522,335.64 - 1,614,163.73 1,515,525.70 98,638.03 Operating Reserve Min 60 days of 2019 Operating Bud. 4,532,992.00 4,532,992.00 Rate Stabalization Funds $400K-$1.2K 372,736.68 372,736.68 PILOT Funds Charter (Formula Only) 1,106,279.00 1,106,279.00 Catastrophic Funds Risk Mitigation Amount 400,000.00 400,000.00 Capital Reserves 5 Year CIP ( 2019-2023 Fleet & Infrastructure Maintenance) 2,750,000.00 2,750,000.00 Total Designated Funds 9,162,007.68 9,162,007.68 YE YE YE YE YTD APPA Ratio HUC 2015 2016 2017 2018 2019 SK-10K Cust. Target Debt to Asset Ratio (* w/Gen.) 13.9% 16.7% 35.4% 35.7% 35.8% 50.1% Current Ratio 2.95 3.57 4.36 3.63 4.32 2.43 RONA -1.2% -0.4% -0.6% -0.3% -0.8% NA >0% Hutchinson Utilities Commission Cash -Designations Report, Gas 5/31/2019 Change in Financial Annual Balance, Balance, Cash/Reserve Institution Current Interest Rate Interest May 2019 April 2019 Position Savings, Checking, Investments varies varies varies 27,643,746.61 28,224,445.58 (580,698.97) Total HUC Operating Funds 27,643,746.61 28,224,445.58 (580,698.97) Debt Restricted Requirements Debt Restricted Requirements Total Restricted Funds Operating Reserve Rate Stabalization Funds PILOT Funds Catastrophic Funds Capital Reserves Total Designated Funds Bond Covenants - sinking fund Bond Covenants -1 year Max. P & I Min 60 days of 2019 Operating Bud. $200K-$600K Charter (Formula Only) Risk Mitigation Amount 5 Year CIP ( 2019-2023 Fleet & Infrastructure Maintenance) 985,354.17 821,262.50 164,091.67 2,188,694.02 2,188,694.02 - 3,174,048.19 3,009,956.52 164,091.67 1,553,820.00 1,553,820.00 651, 306.61 651, 306.61 495,145.00 495,145.00 100, 000.00 100, 000.00 700,000.00 700,000.00 3, 500, 271.61 3, 500, 271.61 YE YE YE YE YTD HUC 2015 2016 2017 2018 2019 APGA Ratio Target Debt to Asset 55.0% 51.2% 47.6% 40.7% 38.3% TBD Current Ratio 2.17 2.59 2.74 4.33 5.76 TBD RONA 4.7% 5.6% 5.0% 8.3% 4.1% TBD HUTCHINSON UTILITIES COMMISSION Investment Report For [he Mon[h End.d May 31, 2019 Interest Cun-t Date of Date of Par Cunent Purchase Unreali .d Premium Next Institution Description Rate YTM Purchase Maturity Value Value Amount Gain/(L... ) (Discount) Call Date Wells Ferga Maney Market 1.610% 1.610% NA NA - 11, 188.60 - - - N/A Wells Fart CD 's 2.550% 2.550% 08/21/2018 02/21/2020 245000.00 "1210.)0 245000.00 21010 - N/A Wells Ferga CD 's 2.450% 2.450% 03/2)/2019 0,12)12020 245000.00 ... 0", 245000.00 2.45 - N/A Wells Fargo CD 's 2.100% 2.100% 02/121/12018 08/21/2019 245000.00 244'15.85 245000.00 (164.15' - N/A Wells Ferga CD 's 2.500% 2.500% 04/02/2019 04/05/2021 245000.00 245026.95 245000.00 2695 - N/A Wells Fargo CD 's 2.000% 2.000% 04/0)/2016 10/07/2021 245000.00 242015.90 245000.00 (2,114.10) - 10 /0712019 Wells Ferga CD 's 2.150% 2.150% O612712017 M12712022 245000.00 242089.40 245000.00 (2,910.60) - M12712019 Wells Ferga GD's 2.600% 2.600% 03/29/2019 03/29/2021 245000.00 245120.05 245000.00 12005 - 09/29/2019 Wells Ferga FHLMC-Step 2.000% 2.192% O6/29/201) W29/2022 275000.00 274923.00 2)5000.00 ()).00) - M29/2019 Wells Fargo FH LMC-Step 2.000% 2.2m% 10/27/2016 10/27/2023 1025000.00 102140225 1025000.00 (359).)5) 0)/2)/2019 Broker Total 25.) % 3 015 000.00 3, 129 815.15 3 015 000.00 (9 373.45) - Getera Investment Services Maney Market 0.200% 0.200% N/A N/A - 11802.6) - - - N/A Getera Investment Services U.S. Treasury Bill 2.230% 2.230% 02/19/2019 08/15/2019 1,615,600.00 1,608135.93 1598315.24 982069 (1)28476) N/A Cetera lmest-t Services Municipal 8antls 2.995% 2.073% 03/0)/2016 07/01/2020 250000.00 2511)).51 260,135.21 (905).)1) 10835.21 N/A Cetera lmest-t Services Municipal 8antls 2.750% 1.881% 03/0)/2016 08/01/2020 250000.00 251900.00 259820.00 ()920.00) 982000 N/A Cetera lmest-t Services Municipal 8antls 2.163% 1.))9% 03/08/2016 07/01/2019 510000.00 4998)5.00 508145.00 (6270.00) 6,14500 N/A Cetera lmest-t Services Municipal 8antls 5.000% 1.610% 10/11/2016 01/01/2020 250000.00 255032.50 276500.00 (2146750) 26500.00 N/A Cetera lmest-t Services Municipal 8antls 2.8)5% 2.121% 04/29/2016 09/01/2021 250000.00 253422.50 25946).50 (6045.00) 946)50 N/A Cetera lmest-t Services Municipal 8antls 3.)51% 2.399% 04/29/2016 11/01/2021 250000.00 2551)5.00 26)330.00 (11505500) 1)330.00 WA Cetera lmest-t Services Municipal 8antls 3.139% 2.190% 12/11/2017 09/01 /2021 300000.00 305169.00 310,116.00 (494).00) 10116.00 N/A Getera Investment Services Municipal 8antls 2055% 2208% 12/11/201) 03/01 /2022 300000.00 303531.00 305314.92 (1183.92) 531492 N/A Cetera lmest-t Services Municipal 8antls 2.300% 1.)15% 12/11/2017 10/01/2020 100000.00 100259.00 101595.00 (1336.00) 159500 N/A Cetera lmest-t Services Municipal 8antls 3.240% 3.240% 11/17/2017 02/15/2023 80000.00 72110.10 69,633.48 2,54732 (10,36652 N/A Cetera lmest-t Services Municipal 8antls 3.436% 3.436% 12/20/2018 12/15/2021 50000.00 46794.00 45155.00 103900 (4845.00) N/A Cetera lmest-t Services Municipal 8antls 3.000% 3.118% 12/20/2018 08/01/2022 50000.00 51004.50 503)).67 62683 37707 N/A Cetera lmest-t Services Municipal 8antls 3.633% 3.116% 12/20/2018 09/01/2022 250000.00 25674).5' 25721).48 (46'") )21)48 N/A Cetera lmest-t Services Municipal 8antls 3650% 3.004% 12/20/2018 02/01/2023 250000.00 25944).50 256165.00 328250 6,16500 N/A Cetera lmest-t Services Municipal 8antls 3.0)5% 3.236% 12/20/2018 M/0112023 50000.00 5051100 49746.15 M905 (25305) WA Cetera lmest-t Services Municipal 8antls 2.500% 3.181% 12/20/2018 08/01/2023 35000.00 35, 5 M5.10 34320.05 74505 (6)995) N/A Cetera lmest-t Services Municipal 8antls 3.400% 3.148% 12/20/2018 11/01/2023 125000.00 12)46100 126376.25 108315 13)625 N/A Cetera lmest-t Services Municipal 8antls 3.400% 3.148% 12/20/2018 11/01/2023 65000.00 M2)9.20 65715.65 M355 71565 N/A Cetera lmest-t Services Municipal 8antls 2.854% 3.1)3% 12/20/2018 02/01/2024 100000.00 101314.00 99805.9' il)804 (39404) N/A Cetera lmest-t Services Municipal 8antls 2.9))% 3.246% 12/20/2018 03/15/2024 250000.00 254040.00 248,743.99 529101 (12M 01) N/A Cetera lmest-t Services Municipal 8antls 3.922% 3.429% 12/20/2018 12/01/2024 250000.00 265030.00 25)122.49 )90)51 7,12249 N/A Cetera lmest-t Services Municipal 8antls 5.290% 2.)24% 04/18/2019 M/0112023 260000.00 285963.80 291059.96 (5096.36) 31059.96 N/A Getera lmest-tServices Municipal 8antls 5.)42% 3.658% 04/11/2019 08/01 /2024 500000.00 548150.00 555382.50 (6532.50) 55382.50 N/A Cetera lmest-t Services Municipal 8antls 4.400% 3.221% 04/11/2019 07/01/2025 5W, 00.00 535085.00 539101.11 (4016.11) 39101.11 07/01/2023 Cetera lmest-t Services Municipal 8antls 5.640% 3.00)% 04/18/2019 08/15/2025 205000.00 188,401.35 16973).95 (1336.60) (3526205) N/A Cetera lmest-t Services Municipal 8antls 3.)43% 2.740% 04/18/2019 09/15/2025 215000.00 226816.40 228334.53 (1518.13) 13334.53 N/A Cetera lmest-t Services Municipal 8antls 4.250% 3.258% 04/11/2019 01/01'2026 510000.00 52375/00 52976103 (6019.03) 29169.03 N/A Cetera lmest-t Services Municipal 8antls 6.690% 3.3M 04/18/2019 04/15/2026 60000.00 4)994.00 4)545.20 44880 (12'45410) N/A Cetera lmest-t Services Municipal 8antls 3.250% 2.903% 04/18/2019 08/01'026 500000.00 50)910.00 514190.6' (6880.69) 14190.69 N/A Cetera lmest-t Services Municipal 8antls 3.332% 3.120% 04/18/2019 04/15/202) 500000.00 51)515.00 50))83.94 973106 ))8394 N/A Broker Total 74.3% 8,W0000.00 9044794.05 9089122.95 (5593157) 228522.95 TOTAL INVESTMENTS 100.0% $ 11,875,600.00 $ 12,174,609.20 $ 12,104,122.95 $ (65,305.02) $ 228,522.95 M... y Market $135791.27 1.1% $127035.19 1.1% $8156.08 CD's 1I709,3 01.31 140% 1I)08I663. 85 142% )3)45 GO---t 8antls 2,904 461.18 23 9% 2,89) 526.14 24 0% 6,135 04 Municipal 8antls )425055.12 610% )316190.20 601% 1865.25 TOTAL $12,1)4,609.20 100.0% $12,049,915.08 08100.0% $124,693.82 Less than 1 year $3233883 70 26 6% 1-2 years 1094083.50 9.0% 2-3 ys a6 1 406 10).40 11 6% 3-4 years 1,1l 6, 12.70 9.5% 4-5 years 11 42190.15 160% 5+years 3341351.75 274% TOTAL $12,174,609.20 100.0% $3500000.00 $3,233,BBd $3.34L352 $3.000.0W.00 $2,500.000.00 $2,000,000.00 $1,942,190 $1406707 $1, 500,0W.00 $1AWAAAAAR $1156393 00 $1,0,000.00 lug $500,0W.00 11 $0.00 Less than Iyear 1-2year1 2-3years 3-4years 4-Syears 5+years ELECTRIC DIVISION Operating Revenue May 2019 CLASS AMOUNT KWH /KWH Street Lights $0.44 8 $0.05500 Electric Residential Service $368,664.05 3,532,455 $0.10436 All Electric Residential Service $13,901.62 129,558 $0.10730 Electric Small General Service $142,992.07 1,432,597 $0.09981 Electric Large General Service $621,398.89 6,665,090 $0.09323 Electric Large Industrial Service $729,528.20 9,165,000 $0.07960 Total $1,876,485.27 20,924,708 $0.08968 Power Adjustment $0.00354 Rate Without Power Adjustment $0.08614 Electric Division Year -to -Date M2019$A--t 02018$A--t ■2019KWH110 02018 KWH110 13,000,000 12,000,000 11,000,000 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 Street Lights Residential All Elec. Small Gen. Large Gen. Large For Resale Total Resid. Srv. Srv. Industrial NOTE: Sales for resale includes capacity sales, market sales and Transalta sales. NATURAL GAS DIVISION Operating Revenue MAY 2019 CLASS AMOUNT MCF /$ MCF Residential $184,232.14 19,148 $9.62148 Commercial $130,577.36 15,431 $8.46202 Large Industrial $34,134.62 3,770 $9.05428 Large Industrial Contracts $192,144.53 51,736 $3.71394 Total $541,088.65 90,085 $6.00642 ® 2019 $ Amount 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 Fuel Adjustment-$1.45000 Rate Without Fuel Adjustment $7.45642 Natural Gas Division Year -to -Date 0 2018 $ Amount ■ 2019 MCF 132018 MCF Gas Residential Gas Commercial Large Industrial Large Industrial Total Contracts eReliability I Monthly Statistics Pagel of 5 Monthly Report - Hutchinson Utilities Hutchinson Utilities Commission Commission Year Minimum duration Substation rt_ 2019F .. _..w Month 05 - May Annual Report? 0 Yes No FO Maximum duration Top-level Cause Unscheduled ....................... Circuit Remove Major Events? https://reliability.publicpower.org/reports/monthly/utility/9l/?year=2019&month=5&is an... 6/18/2019 eReliability I Monthly Statistics Page 2 of 5 IEEE 1366 Statistics Metric May 2019 May 2018 SAIDI 0.08 None SAIFI 0.00028 None CAIDI 288 None ASAI 99.9998% 100% Momentary Interruptions 0 0 Sustained Interruptions 1 0 Circuit Ranking - Worst Performing Ranked by Outage Count Circuit Substation Fdr#16 Plant 1 Ranked by Customer Interruptions Circuit Substation Fdr#16 Plant 1 Number of Outages i Customer Interruptions 2 9 Ranked by Customer Minutes of Duration Circuit Substation Customer Minutes of Duration Fdr#16 Plant 1 576 https://reliability.publicpower.org/reports/monthly/utility/9l /?year=2019&month=5&is_an... 6/18/2019 eReliability I Monthly Statistics Page 3 of 5 Historical Monthly SAIDI Chart 7 6 5 4 3 2 1 SAIDI values Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May 2018 2018 2018 2018 2018 2018 2018 2019 2019 2019 2019 2019 Historical Monthly SAIFI Chart 0.08 --- I Monthly SAIFI 0.07 Average of monthl SAIFI values 0.06 0.05 0.04 0.03 0.02 0.01 0.00� , Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May 2018 2018 2018 2018 2018 2018 2018 2019 2019 2019 2019 2019 https://reliability.publicpower.org/reports/monthly/utility/91/?year=2019&month=5&is an... 6/18/2019 eReliability I Monthly Statistics Page 4 of 5 Causes Ranked by Count Cause Electrical Failure Causes Ranked by Duration Cause Electrical Failure Count Duration 576 https://reliability.publicpower.org/reports/monthly/utility/9l/?year=2019&month=5&is an... 6/18/2019 eReliability I Monthly Statistics Page 5 of 5 Top 1 Outages for the Month Customers Customer Minutes of Address Interrupted Duration Interruption 1060 Hwy 15 2 288 576 South Total Customers Affected for the Month: Average Customers Affected per Outage: U Start Date 05/25/2019 2 z https://reliability.publicpower.org/reports/monthly/utility/9l /?year=2019&month=5&is_an... 6/18/2019 Work Order Description 11708 Units 6 & 7 11901 Plant 1 Heating/Air Conditioning 11902 East Engine Room Shop Floor Epoxy 11903 Plant 1 Cooling Tower Upgrade 11904 Unit 8 Controls Upgrade 11905 Lube Oil and Glycol Maintenance Plant 1 11906 Replacement Hoist in East Engine Room 11907 Unit 1 Circuit Breaker Electric Production Total Total Percentage Materials Labor Budgeted Actual Difference Completed $ 14,369,702.00 $ - $ 14,369,702.00 $ 15,203,963.35 $ 834,261.35 90% 10,000.00 2,000.00 $ 12,000.00 $ (12,000.00) 35,000.00 $ 35,000.00 $ (35,000.00) 80,000.00 $ 80,000.00 5,876.36 $ (74,123.64) 5% 270,000.00 35,000.00 $ 305,000.00 4,676.90 $ (300,323.10) 5% 40,000.00 10,000.00 $ 50,000.00 4,961.68 $ (45,038.32) 5% 30,000.00 $ 30,000.00 $ (30,000.00) - - $ - 37,043.95 $ 37,043.95 50% $ 14,834,702.00 $ 47,000.00 $ 14,881,702.00 $ 15,256,522.24 $ 374,820.24 Work Order Descripmtion 21901 Pole Repair or Replacement 21902 Station Equipment 21903 Step Up Transformer Unit 3 21904 Duct for Reconductor 21905 Century Court Apartments 21906 Highfield Apartments 21907 Feeder 15 and 16 Reconductor 21908 New Developments 21909 City Road Projects 21910 Century Court Apartments 21911 Transformer Replacements 21912 Transformer New Developments 21913 Highfield Apartments 21914 Meters 21915 Hutchinson Substation Circuit Breaker Electric Distribution Total Total Percentage Materials Labor Bud;e,te,d Actual Difference Completed 15,000.00 - 15,000.00 - $ (15,000.00) 10,000.00 10,000.00 2,226.95 $ (7,773.05) 10% 100,000.00 5,000.00 105,000.00 940.94 $ (104,059.06) 15,000.00 65,000.00 80,000.00 - $ (80,000.00) 20,000.00 15,000.00 35,000.00 323.92 $ (34,676.08) 20,000.00 15,000.00 35,000.00 - $ (35,000.00) 50,000.00 100,000.00 150,000.00 9,600.06 $ (140,399.94) 50,000.00 50,000.00 21,433.08 $ (28,566.92) 5% 50,000.00 20,000.00 70,000.00 13,812.69 $ (56,187.31) 20,000.00 5,000.00 25,000.00 - $ (25,000.00) 40,000.00 14,000.00 54,000.00 202.45 $ (53,797.55) 50,000.00 - 50,000.00 893.40 $ (49,106.60) 15,000.00 3,000.00 18,000.00 - $ (18,000.00) 30,000.00 30,000.00 - $ (30,000.00) - - - 79,500.00 $ 79,500.00 50% $ 485,000.00 $ 242,000.00 $ 727,000.00 $ 128,933.49 $ (598,066.51) Administrative Total Total Work Order Description Budgeted Actual 51901 Replace #542 2008 Silverado 26,523.00 51902 Replace #573 2008 Super Duty Truck 60,000.00 51903 Replace #827 Tahoe 30,000.00 51904 Replace #651 38,192.00 51905 Replace Vehicle #623 66,837.00 $ 221,552.00 $ Difference 26,523.00 - 60,000.00 - 30,000.00 - 38,192.00 - 66,837.00 $ (221,552.00) Percentage Completed Work Order Description 61901 Replace Regulators Station 2 61902 Misc Developments and Improvements 61903 STh Ave (Lynn to Ontario) 61904 SCD Trunk Storm 61905 South Grade Corridor (Dale to Hwy 15) 61906 Clinton Ave SW (Harrington to Merrill) 61907 South Grade Road (School Road to Dale) 61908 Trunk Hwy 7 Pedestrian Trail Improvements 61909 Century Court Apartments 61910 Waller Drive (Feed to HTI) 61911 Isolated Main Replacement (btn Barley and Glenda) 61912 Regulator Station Improvements 61913 Service Lines 61914 Meters, AM[, and all Fittings 61915 Residential Regulators 61916 Trunk Hwy 15 State Improvement Project 61917 Industrial Metering and Regulation 61918 Pressure Monitors- AMI System, Laser Gas Detector Natural Gas Total Materials Labor Budaeted $ 28,000.00 $ 2,000.00 $ 30,000.00 $ 100,000.00 25,000.00 125,000.00 300,000.00 20,000.00 320,000.00 50,000.00 5,500.00 $ 55,500.00 20,000.00 2,750.00 $ 22,750.00 5,000.00 2,000.00 $ 7,000.00 10,000.00 4,000.00 $ 14,000.00 5,000.00 2,000.00 $ 7,000.00 95,000.00 25,000.00 $ 120,000.00 20,000.00 3,000.00 $ 23,000.00 57,000.00 35,000.00 $ 92,000.00 95,000.00 4,000.00 $ 99,000.00 35,000.00 - $ 35,000.00 225,000.00 5,000.00 $ 230,000.00 80,000.00 7,000.00 $ 87,000.00 20,000.00 3,500.00 $ 23,500.00 $ 1,145,000.00 $ 145,750.00 $ 1,290,750.00 $ Total Actual Difference 28,488.33 $ (1,511.67) 8,014.80 $ (116,985.20) - $ (320,000.00) 1,399.80 $ 1,399.80 $ (55,500.00) $ (22,750.00) - $ (7,000.00) $ (14,000.00) 1,360.96 $ (5,639.04) - $ (120,000.00) - $ (23,000.00) 12,377.89 $ (79,622.11) 17,997.56 $ (81,002.44) - $ (35,000.00) 1,705.32 $ (228,294.68) 5,789.55 $ (81,210.45) - $ (23,500.00) 77,134.21 $ (1,213,615. 79) Percentage Completed 50% 15% 15% HUTCHINSON UTILITIES COMMISSION ,c�,« Board Action Form 'AlUTlt Agenda Item: Review Policies Jeremv Carter Review Policies BACKGROUND/EXPLANATION OFAGENDA ITEM: es As part of HUC's standard operating procedures, a continual policy review is practiced. This month, the following policies were reviewed and no changes are recommended on these policies at this time: Section 6 of Exempt Handbook Section 6 of Non -Exempt Handbook BOARD ACTION REQUESTED: None EXEMPT SECTION 6 - HEALTH AND SAFETY HUC is very concerned about the safety of its employees and the public HUC serves. All employees are required to follow all HUC safety rules and make the safety of themselves, their co- workers, and the public a priority. To encourage a safe workplace, the Commission has adopted the APPA — Utilities Safety Handbook. Compliance with the APPA is "mandatory and is considered a requirement for employment". ACCIDENTS AND INJURIES Employees must immediately report to a Director, Manager or Supervisor j ob-related illnesses, all accidents and injuries (regardless how minor) that occur during the course of employment with HUC. The Employee and Supervisor must fill out and sign an accident report. If a supervisor is not available and the nature of injury or illness requires immediate treatment, the employee is to go to the nearest available medical facility for treatment and, as soon as possible, notify his/her supervisor of the action taken. In the case of a serious emergency, 911 should be called. If the injury is not of an emergency nature, but requires medical attention, the employee will report it to the supervisor and make arrangements for a medical appointment. Worker's compensation benefits and procedures to return to work will be applied according to applicable state and federal laws. Workers Compensation insurer is League of Minnesota Cities Insurance Trust (LMCIT). Pursuant to Minnesota Law, HUC has established a labor-management safety committee that investigates or reviews all accidents to identify causes of the accidents and suggest ways to prevent reoccurrence of the accident. The safety committee may request to interview any employee involved in an accident or any employee who may have knowledge of an accident. All employees are required to cooperate with the safety committee. UNSAFE CONDITIONS OR PRACTICES Employees are required to report to a Director, Manager or Supervisor any unsafe conditions or practices they observe, including failure of a co-worker to follow safety rules or procedures. EMPLOYEE RIGHT -To -KNOW Minnesota's Employee Right -to -Know law requires HUC to inform employees when they may be exposed to hazardous substances, harmful physical agents, or infectious agents. HUC has adopted a written Employee Right -to -Know program. HUC has evaluated and reevaluates the work sites to determine the presence of hazardous substances. Employees shall become familiar with the location of Safety Data Sheets (SDS) in their work area. NON-EXEMPT SECTION 6 — HEALTH AND SAFETY HUC is very concerned about the safety of its employees and the public HUC serves. All employees are required to follow all HUC safety rules and make the safety of themselves, their co- workers, and the public a priority. To encourage a safe workplace, The Commission has adopted the APPA — Utilities Safety Handbook. Compliance with the APPA is "mandatory and is considered a requirement for employment". ACCIDENTS AND INJURIES Employees must immediately report to a Director, Manager or Supervisor j ob-related illnesses, all accidents and injuries (regardless how minor) that occur during the course of employment with HUC. The Employee and Supervisor must fill out and sign an accident report. If a supervisor is not available and the nature of injury or illness requires immediate treatment, the employee is to go to the nearest available medical facility for treatment and, as soon as possible, notify his/her supervisor of the action taken. In the case of a serious emergency, 911 should be called. If the injury is not of an emergency nature, but requires medical attention, the employee will report it to the supervisor and make arrangements for a medical appointment. Worker's compensation benefits and procedures to return to work will be applied according to applicable state and federal laws. Workers Compensation insurer is League of Minnesota Cities Insurance Trust (LMCIT). Pursuant to Minnesota Law, HUC has established a labor-management safety committee that investigates or reviews all accidents to identify causes of the accidents and suggest ways to prevent reoccurrence of the accident. The safety committee may request to interview any employee involved in an accident or any employee who may have knowledge of an accident. All employees are required to cooperate with the safety committee. UNSAFE CONDITIONS OR PRACTICES Employees are required to report to a Director or Manager any unsafe conditions or practices they observe, including failure of a co-worker to follow safety rules or procedures. EMPLOYEE RIGHT -To -KNOW Minnesota's Employee Right -to -Know law requires HUC to inform employees when they may be exposed to hazardous substances, harmful physical agents, or infectious agents. HUC has adopted a written Employee Right -to -Know program. HUC has evaluated and reevaluates the work sites to determine the presence of hazardous substances. Employees shall become familiar with the location of Safety Data Sheets (SDS) in their work area. SAFETY GLASSES Employees must pay for their own eye examination (health insurance will generally cover 100% of examination expense). Any supplier who can provide certification that the glasses meet OSHA requirements may fill the prescription. It is recommended that employees fill their prescriptions at any optical department who accepts the Minnesota State Contract. Forms are available in the business office. HUTCHINSON UTILITIES COMMISSION�1` Board Action Form �rMturscti mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm Agenda Item: Step Up transformer for Generator #3 Presenter: Dave Agenda Item Type: Time Requested (Minutes): 5 New Business Attachments,: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: As we have eliminated the older Generators at the Plant 1, the existing 10MVA step up transformer has become oversized and less efficient. We are looking to replace it with a rebuilt 51VIVA step up transformer. Attached are two quotes for a rebuilt 51VIVA transformer. T&R Electric ----- $89830.00 Solomon Corp ---- $95000.00 The sale of the existing 10MVA will happen once the change out has been completed, however both companies have also given a purchase price. T&R will buy our 10MVA for $16000.00 Solomon Corp will buy our 10MVA for $7500.00. BOARD ACTION REQUESTED: Approve Requisition 7984 Fiscal Impact: 89830.00 Included in current budget: Yes Budget Change: No PROJECT SECTION: Total Project Cost: Remaining Cost: HUTCHINSON UTILITIES ra,�itiaa° oni'initIIIEwasrioni Note PURCHASE REQUISITION HUTCHINSON UTILITIES COMMISSION 225 MICHIGAN ST SE HUTCHINSON, MN 55350 Phone:320-587-4746 Fax:320-587-4721 T & R ELECTRIC SUPPLY CO INC 308 SW 3RD ST PO BOX 180 COLMAN, SD 57107 Description: 5 MVA transformer for Plant 1 step down Date Requisition No. 05/29/2019 007984 Required by: 06/26/2019 Requested by: dhunstad Item No. Part No. Description Qty Unit Due Date Unit Price Ext. Amount 5 MVA STEP UP TRANSFORMER - MFG. PART: 1 1.00 EA $89,830.000 $89,830.00 Total: 89,830.00 Date Printed: 05/29/2019 Requisitioned By: dhunstad Page: 1/1 Tine Transformer Peoplea MR191111 When, Every Minute Counts II IIa;wNtwan 0 0 iu 0 a rliueu R. SD 57017 IPhoup ;~OOO�7994 nluotsi(q'nlla1r�nw r d,fu^'^a.:Cpa w 1"ee5 34111Sht Date: May 20, 2019 Contact: Dave Hunstad Company: Hutchinson Utilities Commission ITEM 1: Product Type: Rem anufactured/Rewind Job Type: Sale Transformer Type: Power Class Substation Manufacturer: T&R SPECIFICATIONS: KVA: 5000/5600 PHASE: 3 Cooling Class: ONAN Temperature Rise: 55/65 High Voltage: 13800Y/7970 Low Voltage: 4160Y/2400 HV BIL Rating: 110 kV BIL LV BIL Rating: 75 kV BIL Taps: 2 - 2.5 % taps above and below Impedance: Standard Insulating Fluid: Mineral Oil Hertz: 60 Winding Material: New Copper HV & LV Winding Design Rectangular Layer Tank Enclosure: Welded Cover w/ inspection cover Weld on cooling radiators Ground Pads Sealed Tank Design Bushinas: High Voltage: New WARCO 110kV BIL Bushings Side Mounted (ATC/Flange) Low Voltage: New WARCO 75kV BIL Bushings Side Mounted (ATC/Flange) 'HO/XO Bushing Separate (Not Common) Protection: CT's & Arresters not included in this quote - can be provided as an adder upon request. Accessories: New Qualitrol Liquid Temperature gauge New Qualitrol Liquid level gauge New Qualitrol Pressure/vacuum gauge with bleeder New Cover mounted pressure relief device (PRD) New Drain Valve with sampler 'Please notify T&R of any additional accessories requested. Switchina: New 5-Position no-load tapchanger Paint Color: ANSI 70 Quantity: 1 PRICE: $89,830 Each Warranty: Three Years Shipment: 16-18.5 Weeks (ARo) FOB: Included Terms: Net 30 Adders: None Exceptions: None Additional Notes: 1 This quote is valid for 30 days. Please see attached for warranty information; T&R's terms and conditions will apply. 2 This unit is subject to prior sale. 3 Freight terms may vary on each particular order depending upon size and shipping destination. Shipping is included in this quote. 4 T&R does not provide crane service, field assembly, or field testing and these items are not included in this quote. 5 Payment term of Net 30 days is subject to credit approval at time of order. 6 If approval drawings are required please add 4 Weeks to our quoted lead time. 7 This transformer quoted is a remanufactured unit and will be built to the speciafications included in this quote and our build document. If you have any addidtional questions or need any additional information please call me at 800-843-7994. Sincerely, Gary Bowen Sales Repersentative From: Dave Hunstad To: Angie Radke Subject: FW: Date: Wednesday, June 19, 2019 8:17:55 AM T&R replied there buy back number in this email. From: Gary Bowen <gary.bowen@trelectric.com> Sent: Monday, May 20, 2019 1:28 PM To: Dave Hunstad <dhunstad@ci.hutchinson.mn.us> Subject: Dave: We will give you $16000.00 for you unit if you buy the 5000 KVA from us. Thank you, Gary Gary Bowen P: 800-843-7994 Ext. 2107 F:605-534-3861 QaryCitrelectric.com %*-%0 %.00 Li To: Dave Hunstad From: RJ Ladenburger Quote: Q-16483 Hutchinson Util. Comm. 785-822-4608 Date: 5/24/2019 Hutchinson, Minnesota rladenburger(d)solomoncorp.com United States QTY I DESCRIPTION I EACH (USD) I 11 1 Three Phase Substation - 5000 KVA 1 $95,000.00 1 5000/5600/6250/7000 KVA Three Phase Substation Transformer 55/65 Degree C Rise ONAN/ONAF, 60 Hertz, Standard Impedance Primary Voltage: 13800Y/7970 (110 KV BIL) Secondary Voltage: 4160Y/2400 x 2400 Delta (75 KV BIL) Primary Taps: 2-2.5% FCAN & BN Sidewall Mounted Primary Bushings (Spades) - ANSI Segment #4 Primary Bushing Type: 4-Hole Spades Primary Bushing Enclosure: Air Terminal Chamber Sidewall Mounted Secondary Bushings - ANSI Segment #2 Secondary Bushing Type: 4-Hole Spades Secondary Bushing Enclosure: Air Terminal Chamber Secondary Connection Board Liquid Level Gauge Liquid Temperature Gauge with Two Contacts Pressure Vacuum Gauge and Bleeder Assembly Pressure Relief Device Drain Valve and Sampler Cooling Fans and Controls Inspection Lid, Lifting Facilities Layer Wound Primary and Secondary Windings Non -PCB Mineral Oil Value of Existing 10 MVA Unit: $7,500.00 **Offer contingent on a less than 50 ppm PCB sample. Standard Factory Tests: Turn Ratio Test Excitation Test Impedance Doble Power Factor Megohm Insulation Test Resistance Tests No -Load Losses Full -Load Losses Induced Potential Applied Potential Engineering Quote: 3SLWO524J Note: In order to stay within dimensional requirements for shipment by truck, some parts may be shipped separately and will require installation on site. The installation of these parts is the customer's responsibility. Our field service department can install these components and perform field acceptance testing which includes TTR, Meg & Doble for an additional charge. The customer will be responsible for unloading at the job site. Solomon, KS www.solomoncorp.com - 800.234.2867 Please note any changes to the specifications on this quotation form and also reference the quotation number on your Purchase Order. Solomon Corporation will use your Purchase Order as order confirmation and proceed with manufacturing. Please note that changes made after the manufacturing process begins may result in additional charges and potential delays in production. Completely Reconditioned to Nameplate Specifications Shipment: 12-14 Weeks ARO FOB Allowed To: Minnesota Warranty: 3 Years Terms: Net 30 with approved credit Prices valid for 30 days. Units subject to availability. Please see attached Terms and Conditions. Price does not include tax. If applicable, tax will be added to the invoice. If order is tax exempt, please provide a copy of your exemption certificate. Unit(s) quoted are for normal service conditions as defined by ANSI/IEEE Standard. Notify Solomon Corporation at time of quotation should the unit(s) be subject to harmonics, motor starting, shovel duty, or other special service conventions. If you have any questions about this quotation, please call me at 785-822-4608. Thank you, RJ Ladenburger— Outside Sales Solomon Corporation rladenburger@solomoncorp.com 785-822-4608 Solomon, KS www.solomoncorp.com - 800.234.2867 HUTCHINSON UTILITIES COMMISSION�1` Board Action Form �rMturscti mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm Agenda Item: Contract Approval - Unit #8 Control System Replacement Presenter: iC Agenda Item Type: Time Requested (Minutes): 5 New Business Attachments,: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: Hutchinson Utilities Commission owns and operates a General Electric Frame 3 "STAG' natural gas fired gas turbine (Unit #8) and has recently advertised for bids to replace a portion of the genset control system due to obsolescence of replacement parts and support. Results of the May 14th bid opening: Ethos Energy: $227,005.00 Lone Star Controls: $292,194.19 Case RMC: $330,074.00 Petrotech: $215,512.00 Having met all bidding requirements, it is the recommendation of HUC Staff to award the Unit #8 Control System Replacement project to Petrotech, Inc. This project was included in the 2019 budget ($305,000). BOARD ACTION REQUESTED: Approve contract with Petrotech, Inc for $215,512.00. Fiscal Impact: Included in current budget: Yes Budget Change: No PROJECT SECTION: Total Project Cost: Remaining Cost: Petrotech Proposal Purchaser Hutchinson Utilities Commission Project contact Mr. Randy Blake Email: .-_-..��,?, i. t ..-.nson. n.us Project name GE Frame 3 Control System Replacement Balance of Plant Petrotech quote number 19-0065 Revision level 1 Date issued May 13, 2019 Scope summary Control System Replacement for GE Frame 3 Combustion Turbine Balance of Plant at Hutchinson Utilities Commission Plant, Minnesota. Petrotech Account Manager Craig Springford, Tel.: 618-979-8034 Email: C .).._c rdki)j eta�o� nimc a Prepared by Hadi Abdallah, Tel.: 504-620-5334 Email: H bda,Uai k,,')Isetrotec[�ixc.com. Please submit all purchase orders to: _r eerr tr r i;<' . t l i mcortta or mail to: Applications Engineering Manager 151 Brookhollow Esplanade New Orleans, LA 70123 USA Proposal Contents Section 1 Petrotech Introduction Section 2 Execution Statement Section 3 Detailed Scope of Supply Section 4 Commercial 1 Section 5 References Section 6 Literature/Attachments www.petrotech1nc.com Proposal 19-0065 Revision 1 Section 1. Petrotech Introduction May 13, 2019 Thank you for your interest in Petrotech's full range of products and services. Petrotech Incorporated provides controls and instrumentation for thousands of rotating machinery assets such as Compressors, Gas and Steam Turbines, Generators, Reciprocating Compressors, and associated auxiliary systems. In Petrotech's 50 years of experience it has installed over 2000 systems becoming the trusted experts in rotating machinery controls. This experience list includes compressor controls as well as gas turbine, steam turbine, reciprocating engines and a variety of various applications requiring industrial control. Petrotech has installed systems for solutions including full turnkey controls and mechanical retrofit, stand-alone control products, and new equipment solutions for turbomachinery industry OEM's. The combination of services from a single supplier means that Petrotech, Inc. has in fact the turnkey capability to perform all of the engineering, manufacturing, installation, commissioning, and training required to complete your project. Petrotech's facilities include Head offices in New Orleans, Louisiana, Engineering and Sales offices in Houston, Texas, and support offices in all major regions of the world. Petrotech's integrated control systems include complete driver control, load control, sequencing, protection, and information systems integrated into a control system hardware platform of customer choice. The types of rotating machinery include the following: Turbine Drives Gas or Steam Turbine Driven Compressors, Generators, and Pumps. Reciprocating Engine Drives Reciprocating Engine Driven Compressors, Generators, and Pumps. Electric Motor Drives Electric Motor Driven Compressors and Pumps. Compressor Trains Complex Centrifugal and Axial Compressor Trains. Balance of Plant / Station Balance of Plant / Station Supervisory Control Systems for Pipeline Controls Compressor Stations, Gas Plants, and Power Plants. Additionally, Petrotech offers a wide range of services for a complete turnkey retrofit solution: Technical Training: Custom courses specifically for your control system at the beginner, operator, engineer, and senior technical management levels. Technical Surveys and Studies of control problems with already -installed machinery to identify specific problems in process piping or layout that require correction or mitigation to achieve satisfactory results. Installation and Commissioning: Petrotech installation crews are specifically trained for RMC (rotating machinery controls). They are familiar with special heat, vibration, and wiring integrity requirements for high value RMC installations. Some supervisors have managed more than 200 RMC installation projects. Petrotech commissioning engineers and technicians operate worldwide and have special training and equipment for commissioning, calibration, and tuning. Technical Support and Services: Telephone support 24x7x365 at no charge includes assistance in fault finding and control systems operational issues. Field support includes fault finding, calibration, repair/replace actions, system modification, system updates, and programming services. CONFIDENTIAL Page 2 of 20 Proposal 19-0065 Revision 1 COMPANY DETAILS FACILITIES USA Headquarters Petrotech, Inc. 151 Brookhollow Esplanade New Orleans, Louisiana 70123 USA Phone: (504) 620-6600 Fax: (504) 620-6601 Web Site: www,is)co::ron::echi:n.c.corn. Houston Facility Petrotech, Inc. 7240 Brittmoore Rd., Suite 115 Houston, Texas 77041 USA Phone: (281) 220-3060 Fax: (281) 220-3070 United Kingdom Facility Petrotech (UK) Limited Unit 3 Bunting Road Bury St. Edmunds Suffolk IP32 7BX, United Kingdom Phone: +44 (0)1284 715714 QUALITY ASSURANCE PLAN Per ISO 9001 standards BANKING FACILITIES Whitney National Bank 228 St. Charles Avenue New Orleans, Louisiana 70131-2601 USA Phone: (504) 552-4671 LICENSES Registered as a professional engineering company by the Louisiana State Board of Registration. Initial date of license: 1980 State of Louisiana Contractor's License #13827- Other states available. May 13, 2019 PRINCIPAL PRODUCTS and SERVICES Integrated Control Systems for: • Gas and Steam Turbines • Centrifugal and Axial Compressors • Generators, E-Motors and Pumps • Reciprocating Engines and Compressors • Balance of Plant / Supervisory Control Systems for Compressor Stations, Gas Plants, Power Plants, Process Plants, and Offshore Platforms Auxiliary Systems for: • Gas and Liquid Fuel Upgrades • Water and Steam Injection • Vibration, Hydraulics, Power, Fire & Gas Technical Support for: • Installation • Commissioning • Training • Consulting Services INSURANCE Petrotech maintains all workers' compensation, automobile, general liability, and other insurance typically required by major industrial customers worldwide. Certificates available upon request. TRANSPORTATION • Nearest seaport: Port of New Orleans 17 km (10 miles) • Nearest major airport: New Orleans International Airport (MSY) 12 km (7 miles) CONFIDENTIAL Page 3 of 20 Proposal 19-0065 Revision 1 PARTIAL CUSTOMER REFERENCE LIST PIPELINE & PETROCHEMICAL AGIP Italy Al Furat Petroleum Syria American Natural Resources U.S.A. Amoco Trinidad Aramco Saudi Arabia Arco Various BP USA/China Chevron Texaco Various CMS Energy U.S.A. Columbia Gas & Gulf U.S.A. Conoco -Phillips U.S.A. Dow Chemical U.S.A. Dragoso Canada Duke Energy U.S.A. El Paso Energy U.S.A. Elf Petroland Holland Enron Various EPMI Malaysia Enterprise U.S.A. Exxon Mobil Various Fina Oil & Chemical U.S.A. Gaz de France Holland Gulf South Pipeline U.S.A. GUPCO Egypt Kinder Morgan U.S.A. Kirkuk Gas Turbine Plant Iraq Koch Gateway Pipeline U.S.A. Maersk Holland Marathon U.S.A. National Gas Company Trinidad Northern Natural Gas U.S.A. Northwest Pipeline U.S.A. ONGC India PDVSA Venezuela PEI\/IEX Mexico Petrobras Brazil Petrocanada Canada Petronas Malaysia Petroperu Peru PDO Oman POL Pakistan Sempra U.S.A. Shell Various South Carolina Pipeline U.S.A. Tesoro Petroleum U.S.A. Texas Gas Transmission U.S.A. TGS/TGN/YPF Argentina TOTAL Holland Unocal Thailand Vico Indonesia Williams Energy U.S.A. May 13, 2019 POWER GENERATION AGIP . Nigeria mm i1� Aiken County Public Service U.S.A. Alberta Pacific Forest Industries Canada Aluminium Bahrain Bahrain American Atlas U.S.A. American Municipal Power U.S.A. Archer Daniels Midland U.S.A. Arizona Electric Power Company U.S. A. BP Alaska U.S.A. Bras Nigeria Nigeria Central Vermont Public Service U.S.A. Chevron Angola Angola Citizens Utilities U.S.A. City of Lakeland U.S.A. City of Marquette U.S.A. City of Medicine Hat Canada City of Springfield Utility U.S.A. Conectiv U.S.A. Consolidated Edison U.S.A. Cooperativa Electrical Power Argentina Delmarva Power U.S.A. DSM Power Holland Dyergy U.S.A. Ecopetrol Colombia Electricity Generating Authority Thailand Electroquito Ecuador Elf Aquitaine France Enelbar Venezuela Federal Electricityand Water Dubai Imperial Irrigation U.S.A. Koch Power Company U.S.A. Lincoln Electric Utility U.S.A. Madison Gas & Electric U.S.A. Manitowoc Power Company U.S.A. New Smyrna Beach Utility U.S.A. Northern Indiana Public Service U.S.A. Northern States Power U.S.A. NRG U.S.A. Oman Refinery Corporation Oman Pennsylvania Power & Light U.S.A. Phelps Dodge U.S.A. Plains Exploration U.S.A. Qatar Fertilizer Company Qatar Reliant Energy U.S.A. Rochester Gas and Electric U.S.A. Salomon Smith Barney U.S.A. Texas Petrochemical U.S.A. Tractebel U.S.A. Uri -ion Carbide U.S.A. Virgin Islands Water & Power Virgin Islands ZADCO Abu Dhabi CONFIDENTIAL Page 4 of 20 Proposal 19-0065 Revision 1 May 13, 2019 PARTIAL REFERENCE LIST OF ROTATING MACHINERY CONTROL SYSTEMS I Following is a partial list of common rotating machinery for which Pctrotcch has developed control solutions. Other machinery control systems are available from the extensive library of products developed by Petrotech. TURBINE CONTROL SYSTEMS -over 1000 Units Installed ABB Stal GT35 Kongsberg Allison Lycoming Dresser Mitsubishi Elliott Stearn Turbine Pratt & Whitney Fiat Rolls-Royce GE Frame Series Ruston GE LM Series Siemens GE Steam Turbine Solar Hispano-Suiza Westinghouse __ ....._ ...........�...... .... .....�. — .____� m ................... _____ „ �....... RECRIPOCATING ENGINE CONTROL SYSTEMS -over 300 Units Installed __ . ................. �� _ ......... ,...--... . Ariel EMD Diesel Chicago Compressor Ingersoll-Rand Clark Rolls-Royce Cooper -Bessemer Ruston Cummins Waukesha Detroit Diesel White Superior Dresser -Rand Worthington COMPRESSOR CONTROL SYSTEMS -over 1,600 Units Installed �__-�___. �... ..A.. ...... � _ ......... _ Air Separation Liquid Extraction Alkaline Process LNG Carbon Monoxide LPG Chlorine Process Maleic Anhydride CO2 Process Natural Gas Coker Gas Nitric Acid Expansion Crack Gas Nitrogen Process Ethylene Process Air FCCU Process Propane FCCU Wet Gas Propylene Flash Gas Process Refrigeration H2S Gas Residual Gas HCL Turbo Expander Hydrogen/Methane Waste Gas Hydrogen Gas CONFIDENTIAL Page 5 of 20 Proposal 19-0065 May 13, 2019 Revision 1 Section 2. Execution Statement Petrotech is pleased to offer our proposal to upgrade the Balance of Plant (BOP) Control system for One (1) GE Frame 3 turbine generator control package for Hutchinson Utilities Commission. Based on the expansive experience retrofitting every type of gas turbine, we have put together a comprehensive proposal for the upgrade of the C3-Ilex RTU and HMI. This proposal is turnkey, and will include all services required for design, fabrication, testing, commissioning, and training. Petrotech has over 40 years of experience in the turbomachinery controls business and have retrofitted every type of gas turbine in both power generation and mechanical drive with hundreds of GE Frame 3 Upgrades. We started with pneumatic controls, later developed our own microprocessor -based turbine controls, and in the early 1990's moved our core technology to modern platforms such as PLC, DCS and others. Since then, we have delivered gas turbine control systems for virtually all brands and models of gas turbines on all major PLC platforms such as the one you are requesting (Rockwell, GE, TI, Siemens, Modicon, etc.). We have successfully delivered over 2000 systems accounting for over 8 million of running hours making us the trusted experts in this field. Our PLC based solution leads itself to better plant integration and user self-sufficiency and independence from the OEM at a significantly lower cost of ownership over the life of the system. Although our system controls and protects the gas turbine to the same design specifications as the OEM; our state-of-the-art designs are intuitive and self -diagnosing and eliminate the need for the OEM engineer for every change or tuning required with minimal remote support. Because of this simplicity, once a customer like you uses our system on one of their turbines, they never go back to the OEM for any of their control retrofits. Project Execution: The primary project team assigned for this project would consist of a Project Manager (PM) and a Project Engineer (PE). The PM will provide support and customer interface throughout the project as well as maintain the project schedule. The PE will manage all the design inputs to ensure the control panel sub -plates and programs are designed and configured in line with the project requirements, the specific site requirements, and the OEM specifications. During the design phase, Petrotech will conduct a detailed site survey during which the engineer will gather field data, documentation, measurements, and consult with HUC operators and engineers to start the preliminary design. Basic preliminary design for approval will include developing drawings and system design documents. Documentation for approval will include, but not be limited to: • Project Schedule • Input/Output List • Cause & Effect Diagrams • Panel Sub -plate Layout Drawings • Bill of Materials • PLC Layout • Communication System Architecture Drawing • Wiring Diagrams • HMI Screens • FAT Protocol CONFIDENTIAL Page 6 of 20 Pr(,.)posa.1 19 0065 Revision. 1 SAJ'Protocoal May 13, 20119 I'Ih.e Petrotech GE Frame 3 Balance of'I'lant (b'011)1 apl-Aication wilt be integrated into your selected itadustri.R] 11YA-l' systern (Allen Bradley Contr.oR..,ogix) in. a sim.j..)Icx configut°atiori.i.n.cit:tcliilg all required Power Stapj,:dies, Cornjxvani.cadoinModules, and Simplex 1/0 IWod.tflcs.'r'hc..,. provided co n.t:rol system will have "open." control lo-90c where HLTC will Imave access to die Control logic corl.fturadon for self-suppott over the life of the systern., Petr-otecli's softwaxe is developed using die concept of open architecture, meaning thar all the togic, f6r seqa .x.,ncing and p.rotec'-tion, 1/0 cf.�).nfiguratioa ia, 6rtns confign uratios, sf.,.,t-points, .1. corra-nuri.ic-ations, etc. are op en. to thccrid. usc-r to view and nn.odify as needed to support their Opel",.1ti(Al 'WitIlOut the need of'Petrotecli's involvetraent. However, it is worth noting than Petrotedl.,.i offers 24/7 tt:elephone sup][)Oft f(310-11 free of charge. The Allen. -Bradley PII,('-'PlatF(-)rrn wJ111coi..w.ii..)Ietell.,y.t.,ep.l,,ice the existing 0-11.ex cc)-titrol sysrem used for the Frarne 3 sequencing, protectio:).n, Boiler, Stearn. ".Furbi-.ie Control, Flotwetl Controt,.Flarrie Detection., Vibration Monitoring, Lube Oil Sy,,stetti., an: dTurning G-�..,ar Control. Petrotech will use Allen Bradley ControlLogix ir:v3dules carefully selected for this applicationin tennis of scan time, resolution, card density an.d chann.el isolation requiremen.t.s.'rhe operators will have the cqmbilitics to make chan.ges to tlic control s)rstern annul operadiig functions. PeLrotech is provichng, -an 111\41 application based ovra Factory Talk Site Edition. wiffi. the recluired Petrotech BOP Standard screeni.s.For safa� and re]iable op eration. of the c(.juipt.n. ent, The screens will ptovidc sufficient ini-brmation ro dae opetator for stath...1p of the machine, orilme 011eration, hist(-trical. ti.-ciading and logging, detafled Janns, andoverview screens of all the r.majc)t subsysteruis ofthe gas turbine. ".11lie alarms are ggpnerated wid,..i. first -out logic and detailed descriptions of the faiAts to lx.)int tile cupe'ratot exactly to the issu atharld., High speed h.istor-i.calfcaF,,g,,in.gwi-Ulour achieved E)Y thelIill: appilication in w1hicilh vanables will be logged to allow fc),r post -fault analysis. '..rhe f0flowing points wit.11 be included in. thetreading pant ageas rnirrii'mirm • All terrTeratnres and RIT) values (scated to engjneerIIIg units) • (:'PeneratorLoad-in MW,.NfV, VAR.s, arid Arril-m • I.JnJt. pararneters ,a.icbas..Futbine/Generator speeds, process flow valucs, process pro ssurc values, and any other pararneters crificat to operation of the unit • Digital operating points assist inn rrouNeshootingfrom a sequejn.ce of events, such as piam. p start/stop cornritands, rnotot start/stop corn.rn.a.inds, ahixm. oiccuttclaces, to status changes, etc. • Pall t.-Lirbii.i.cannul gv.,neratorvlt3.rat.ionlevels. • Boiler and Stu am Thl.e e-� stirig 7-Slot Contr-olLogix PLC Rack wUl E)e replaced wiffi. 10 -Slot PLE Rack with. Two (2) CFM Speed Modutes added, u.) it wbile aU the c(..Iu.ipr.n.e.fiit.r(..Iatcd to this tack will reused such as, existIng 1/0 mod-ules, Servo Va alves converters, etc. Petroecli will be replacing) the 1.5.5 ("PI) with a. new (-'.'on.t.rOEL(3gLx 1...81e CPU and Redii.ntdant Ethernet Module fat cotritnunication. with the Inew Remote 1/0 Rack.Thc DVAR System will I)e rePlaced with ariew Controll.,ogjx Rernotel/Q Rack as stated x..j.nder Itern 3 Scq-.)c of Supply Itcm. 1.1.2. In. Addition, the C.3--flex (.J"LJ mad 1/0 tn.Odules in the BOP Panel will be -replace with a new Controll...,ogix Remote 1/0 Rack as staffed uvider I(em L.1.2. The new BOP 1/0 Rac k. tc)o into corisideration the additional 1/0 that will be added. per the RFR CONFIDENTIAL Pag'7 ref: e, A 20 Proposal 19-0065 May 13, 2019 Revision 1 In addition to the BOP Upgrade, Petrotech included in its proposal a DEIF Auto -Synchronizer as stated under Section 3 Detailed Scope of Supply Item 1.1.9. Metrix Vibration modules will be provided to replace existing obsolete vibration monitor and be wired directly to the new PLC system. Screens will be created in the HMI that will reference the turbine vibration sensors. The control system will be delivered fully assembled on new sub -plates that will fit inside the existing control panels. This approach has worked perfectly in many past upgrades. By using shop fabricated doors and sub -plates, the installation task becomes much easier saving time in the field. After fabrication is complete, Petrotech will hold a Factory Acceptance Test (FAT) in our shop. During this test, all inputs and outputs, alarms and shutdowns, startup sequence, operating modes, etc. will be verified by simulating all inputs and outputs from the field sensors. This will be documented in a pre -approved FAT Protocol. At this time HUC engineers and operators will be able to verify the operation and make fine adjustments that will better fit how they operate their machines at the facility. This will also be a great training experience for the end user getting a hands-on experience with the PLC and HMI in a controlled environment. An option for onsite training services is also offered in which the Petrotech engineer will cover the operations manual, wiring diagram, control system logic and HMI features, and troubleshooting techniques. Training will be held at the customer's facilities and will be given at the times most appropriate to cover all shifts. Expert Turbomachinery Controls (TMC) Specialist/Engineer will come to site to perform the startup tasks following a previously approved Site Acceptance 'Test (SAT) Protocol. This will include full loop checks of the end devices, step-by-step startup of the machine, tuiung, and load testing to meet customer requirements. After commissioning, the engineer will bring back any field markups to prepare an "As Commissioned" documentation package. In addition to updating the documents mentioned above, Petrotech will provide the following in electronic format: • System Operations and Maintenance Manual (Control Narrative) • PLC and HMI Programs • System Configuration Tables • Calibration Sheets • Vendor Datasheets • Training Manuals Petrotech Differentiators It is important to highlight that Petrotech's project execution process briefly described above is backed by an ISO-9001 certification. This ensures that all projects are executed and delivered with the expected high quality, on budget, and on schedule. Furthermore, our process is specifically designed for retrofit projects which. allow the level of customization needed for this type of applications at a low cost. This is something that differentiates Petrotech from the typical OEM standard solution. Since our origin, over 40 years ago, when our turbine technology group separated from GE, we have focused on delivering a superior product at a much better total value to the end user when compared to turbine OEM's such as GE. CONFIDF.NTTAL Page 8 of 20 Proposal 19-0065 Revision 1 May 13, 2019 Our superior offerings at times in our history attracted some of the OEM's to source our solution for their turbomachinery sales. Since our inception, Petrotech has focused on being the expert in Turbomachinery controls, while the OEM focuses on being good mechanical engine designers. We hire best of class control engineers, while the OEM hires mechanical ones. Our experience with every type of gas turbine has enabled us to advance the technology versatility over each of the individual OEM's. Over the years, we have used best of breed practices from the various gas turbine designs to produce superior features such as: • Soft Light -off reliability near 100% of the time • First time light -off capability • Exhaust Gas Temperature (EGT) hot/cold spot detection with reliable thermocouple monitoring algorithm • EGT control to within 1 degree • Bumpless transfer between Isochronous and Droop operation on line and load share control • Optimization of air/fuel equivalence ratio and flame temperatures • Critical Function Redundancy • Better performance monitoring and integration into plant data management system The above are just a few features that keep customers like Reliant Energy in New York (now EasternGen) coming back for over 40 GE Frame 5 gas turbines in their fleet so far; without consideration of the OEM because of our value proposition and the system features we provide when retrofitting their fleet of gas turbines. Over our history, we have evolved the gas turbine control technology to state of the art processing platforms. Petrotech and all OEM's started in Pneumatic and Electromechanical controllers and then moved to proprietary microprocessor platforms. We then lead the migration to state of the art open architecture platform that significantly improved the value proposition to the users. Our leadership in technology evolution eventually forced all OEM's to do the same, GE, Rolls Royce, Ruston and Siemens, and Solar now offer their controls only in PLC solutions. Other advantages to using Petrotech's "Open Architecture" solution for controls include the following: Use of off the shelf control system components, consistent programming for all systems, common spare parts, common training, ease of integration to other systems, flexible scaability for integration with future upgrades, multiple communications options, and the ability for the customer to self-support after the Petrotech training sessions on the control system. We appreciate the opportunity to bid on this project and we are available to answer any questions about the scope and/or our capabilities. We look forward to working with HUC project group in completing the upgrade of this system. CONFIDEN'TLU Page 9 of 20 Proposal 19-0065 May 13, 2019 Revision 1 Section 3. Detailed Scope of Supply ITEM 1.1 1.1.2 DETAILED SCOPE OF SUPPLY ITEM 1.0 — GE FRAME 3 BALANCE OF PLANT UPGRADE DESCRIPTION GOODS INCLUDED IN ITEM 1.0 1 Lot Petrotech Balance of Plant Sequence and Protection Application Software for the GE Frame 3 Unit. Software is integrated into an industrial PLC platform as described in Item 1.1.2 and provides all sequencing and protection functions for the gas turbine generator set. Control functions provided include: • Start-up/Shutdown Sequencing • Turbine EGI' Handling • Flame Detection • Vibration Monitoring • Lube Oil System • Turning Gear Control • Hotwell Control • Boiler Control • Interface to customer Fuel Control Application Firmware package • Alarm and Shutdown functions 1 Lot Allen Bradley ControlLogix Programmable Logic Controller (PLC) based on a simplex CPU configuration. Includes the following components: Governor PLC Rack: • One (1) 1756-L81 e CPU Processor Module • One (1) 1756-EN2TR Redundant Ethernet Communication Module Remote I Rack._ in. Turbine,Control„Panel: • One (1) Rack Chassis • One (1) 1756-PB75 Power Supply Module • One (1) 1756-EN2TR Redundant Ethernet Communication Module • Five (5) 1756-IRT8I RTD/Thermocouple Input Modules (8-Channel) • One (1) 1756-IF16 Analog Input Module (16-Channel) Remote lz`O_Rack in BOP Panel: CONFIDENTIAL Page 10 of 20 Proposal 19-0065 May 13, 2019 Revision 1 DETAILED SCOPE OF SUPPLY ITEM 1.0 — GE FRAME 3 BALANCE OF PLANT UPGRADE ITEM QTY. DESCRIPTION • One (1) Rack Chassis • One (1) 1756-PB75 Power Supply Module • One (1) 1756-EN2TR Redundant Ethernet Communication Module • One (1) 1756-IRT8I RTD/Thermocouple Input Module (8-Channel) • Two (2) 1756-IF16 Analog Input Module (16-Channel) • One (1) 1756-OF8 Analog Output Module (8-Channel) • Two (2) 1756-OB16D Digital Output Module (16-Channel) • Four (4) 1756-IB32 Digital Input Modules (32-Channel) 1.1.3 1 Lot Allen Bradley Hardware as follow for the existing Governor PLC Rack: • One (1) 1756-AlO 10-Slot PLC Chassis • Two (2) 1756-CFM Frequency Input Modules (2-Channel) 1.1.4 6 Metrix Vibration Transmitter. 1.1.5 3 4-20mA to 10-50mA Converters for the following: • Feedwater Valve • Hotwell Control Valve • Bypass Steam Valve 1.1.6 1 Dell Precision 3630 Tower PC loaded with Factory Talk SE to be used as the operator interface with the following Features: • Intel Core i5-8500, 6 Core, 9MB Cache, 3.OGHz, 4.1 Ghz Turbo w/ HD Graphics 630 • Windows 10 Pro OS 64 English, French, Spanish • 8GB (1x8GB) 2666MHz DDR4 UDIMM Non-ECC • 500GB 7200rpm SATA Hard Disk Drive • Rockwell FactoryTalk Site Edition License (25 Displays) 1.1.7 1 Lot Aluminum sub -plates for installation in the existing Turbine control and Balance of Plant enclosures. The sub -plates will be supplied completely assembled, wired and tested with all project equipment located internally and wired to terminal strips for quick termination to existing field input wiring. 1.1.8 1 Un-managed Ethernet switch. CONFIDENTLLL Page 11 of 20 Proposal 19-0065 May 13, 2019 Revision 1 ITEM DETAILED SCOPE OF SUPPLY ITEM 1.0 — GE FRAME 3 BALANCE OF PLANT UPGRADE DESCRIPTION 1.1.9 1 120 VAC to 24 VDC Power Supply Module. 1.1.10 1 DEIF Auto -Synchronizer. 1.1.11 1 Lot Terminals, wire duct, wire, wire markers, nametags and miscellaneous materials to make a complete control assembly. 1.1.12 1 Lot System Manuals on CD-ROM (2 sets). 1.1.13 1 Lot Crating Material as required. 1.2 SERVICES INCLUDED IN ITEM 1.0 1.2.1 1 Lot Petrotech project management services to provide customer interface throughout the control system design, fabrication, installation and commissioning. 1.2.2 1 Lot Engineering services to provide support for one (1) kickoff meeting or site survey for a period of One (1) day at the customer location. 1.2.3 1 Lot Engineering services required to develop, define and layout a the complete sub -plates assembly. 1.2.4 1 Lot Engineering services to configure and integrate the sequencing and protection application product to the control system in the existing Governor PLC Code. 1.2.5 1 Lot Engineering services to add the additional logic and programming fot the new Alarms I/O in the existing Governor PLC Code. 1.2.6 1 Lot Engineering services to develop the HMI screens to meet the application. 1.2.7 1 Lot Drafting services to provide the drawing package for the assembly of the control enclosure assembly. This would also provide for the attachment of existing customer wiring or newly pulled wiring for the system. 1.2.8 1 Lot Shop services to provide the labor to mount all system assemblies and equipment on the new sub -plates. This would also include the wiring of all modules to terminal strips per the engineering drawings specified. CONFIDENTIAL Page 12 of 20 Proposal 19-0065 May 13, 2019 Revision 1 ITEM DETAILED SCOPE OF SUPPLY ITEM 1.0 — GE FRAME 3 BALANCE OF PLANT UPGRADE DESCRIPTION 1.2.9 1 Lot Engineering and shop services to provide for a customer witnessed factory acceptance test. This test would be held at the Petrotech facility located in New Orleans. This test would take approximately Four (4) days to accomplish and during this test, all functions, hardware, software graphics and any other system related equipment or software would be tested and approved by the customer prior to shipment to the customer location.. 1.2.10 1 Lot Engineering and drafting services to document all changes and or modifications to the system once the FAT is completed and finalize the system drawing package. 1.2.11 1 Lot Engineering services to prepare proper and complete system documentation for the project. Operations manuals, operating procedures and other related manufacturer manuals and information will be compiled into a system manual that will be furnished on CD-ROM. 1.2.12 1 Lot Shipping preparation. CONFIDENTL L Page 13 of 20 Proposal 19-0065 Revision 1 ITEM 2.1 2.1.1 2.2 2.2.1 May 13, 2019 DETAILED SCOPE OF SUPPLY ITEM 2.0 — COMMISSIONING SERVICES DESCRIPTION GOODS INCLUDED IN ITEM 2.0 1 Lot Materials and special tools for use by the Commissioning Engineer to commission the provided Control System. All special tools remain property of Petrotech. SERVICES INCLUDED IN ITEM 2.0 1 Lot One (1) Petrotech Rotating Machinery Control (RMC) Specialist to be on site for a period of Ten (10) days, working an 10-hour day, seven (7) days per week to complete the commissioning and startup of the Petrotech provided controls upgrade hardware. The commissioning engineer with the assistance of the Customer Installation Technicians will provide the following services: • Checkout the installation of the equipment • Perform Loop Check for all the I/O. • Startup of the machine • Load test to customer performance requirements. Note: This Item assumes that all end devices are in good conditions and have been calibrated by the customer. Note: Commissioning services assume it will be done on one (1) trip of the Petrotech RMC Specialist. Additional mobilization - demobilizations, if required, will be charged at T&M rates. CONFIDENTIAL Page 14 of 20 Proposal 19-0065 Revision 1 ITEM 3.2 3.2.1 3.2.2 3.3 3.3.1 1 Lot 1 Lot 1 Lot May 13, 2019 DETAILED SCOPE OF SUPPLY ITEM 3.0 — OPTIONAL TRAINING SERVICES DESCRIPTION GOODS INCLUDED IN ITEM 3.0 Training materials for up to five (5) attendees that would consist of the following items: 0 System Operations and Maintenance Manual • System Drawing Package • Troubleshooting • Training Class Outline SERVICES INCLUDED IN ITEM 3.0 Petrotech engineering services to prepare the site specific training class for the material to be covered. One (1) Petrotech engineer to be on site for a period of two (2) days to conduct a training course for up to Five (5) participants. SERVICES NOT INCLUDED IN ITEM 3.0 Mobilization -Demobilization charges are not included in this proposal. It is assumed that training would be accomplished during the time the commissioning engineer is still on site prior to leaving. If this is not the case then separate travel time and expenses would be added. CONFIDENTLkL Page 15 of 20 Proposal 19-0065 Revision 1 Section 4. Commercial May 13, 2019 Pricing Base price includes the following items: Item 1.0-2.0 GE Frame 3 Balance of Plant integrated in an Allen Bradley ControlLogix PLC Platform with Commissioning Services as defined by Detailed Scope of Supply, Item 1.0-2.0 Price Item 1.0-2.0: $ 205,127.00 options: Item 3.0 Training Services as defined by Detailed Scope of Supply, Item 3.0. Price Item 3.0: $ 10,385.00 Item 4.0 Additional Services not included in the Scope of Work above. Price Item 4.0: T&M Rates Shipment From receipt of valid purchase order 14-16 weeks Currency All currency listed in this proposal is U.S. Dollars Proposal Validity 30 days Shipping Terms Ex -Works Crating -Ins tructio ns ❑ DOMESTIC ❑ SEA ❑AIR ®UNCRATED Payment Terms Petrotech's quote is based on progress payments per the following milestones: 25% - with acceptance of purchase order 25% - with delivery of preliminary engineering submittal to the customer 30% - with completion of successful factory acceptance test at Petrotech's facility in New Orleans, LA, USA. 10% - Upon Readiness of shipment from Petrotech's facility 10% - Upon Completion of the Commissioning Services TermsW and Conditions Petrotech commercial terms and conditions apply. CONFIDENTIAL, Page 16 of 20 Proposal 19-0065 May 13, 2019 Revision 1 Warranty Petrotech offers a standard limited warranty in accordance with Petrotech Bulletin 03007, "Limited Warranty". Taxes Petrotech's quote is exclusive of all taxes. This includes but is not limited to, state, county, contractor, sales, or any other similar levy that may be required. End Devices This proposal is exclusive of external devices and systems not specifically detailed in this offer. Fuel System Petrotech intends to retain and reuse the existing fuel control valve and existing primary and secondary fuel stop valves. Fire &Gas System This proposal is exclusive of any Fire & Gas detection equipment. The existing Fire & Gas equipment will be retained and reused. Addit onal„WoYk Any additional work, including delays caused by factors out of Petrotech's control, shall be billed on a Time & Material basis in accordance with Petrotech published service rates. System Training Petrotech has provided for system on -site training of customer personnel. This would be for up to Five (5) attendees for this training session that would take two (2) days to complete. Confidentiality This proposal is an offer to sell. It is a commercial response to provide specific application information and documentation. This offer is considered confidential and may contain forward -looking statements or proprietary information. By acceptance of the proposal, purchaser agrees to maintain vendor confidentiality, not distribute beyond purchaser's company or its assigns, or reuse in whole or part beyond the scope the original purchase realization. CONFIDENTL<1L Page 17 of 20 Proposal 19-0065 Revision 1 Section 5. References May 13, 2019 GEMCO/Total in Elf, Congo. Petrotech completed the upgrade of Four (4) GE Frame 3 Turbines Generators including upgrade of instrumentation, and complete rewiring of the turbine control to the skid. The Provided Control System was based on an Industrial PLC Platform based on Simplex CPU configuration, Redundant Communication, and Simplex I/O. Project Contact: Yann Pigaglio Email: ann-)i9a9h2.@)wn� Phone: +33 (0)5 59 72 74 90 Columbia Pipeline Group in Ceredo, WV. Petrotech completed the upgrade of One (1) GE Frame 3 Turbines including upgrade of instrumentation, and complete rewiring of the turbine control to the skid. The Provided Control System was based on an Industrial PLC Platform based on Simplex CPU configuration, Redundant Communication, and Simplex I/O. Eastern Generation at Gowanus, Astoria, and Narrows Stations in Brooklyn, NY • Petrotech completed forty-one (41) GE Frame 5 turbine upgrades (ten Power Blocks) part of multi -unit, multi -year contracts to upgrade all customer's units. Our first contract was the upgrade of 16 units simultaneously. The most recent 4-unit power block was completed in early 2017. Upgrades included gas turbine and generator controls and for some units conversion to dual fuel with allmechanical, electrical, and instrumentation work associated with the project. • At Narrows Station: o Sixteen (16) GE Gas Turbine Generators Control and Protection System Upgrade — DECS-40ON Excitation Systems 0 29600 kVA generators o Allen Bradley ControlLogix Platform o Wonderware InTouch HMI Project Contact: Emmett Facquet Email: efacquet@uspowergen.com Phone: 718-499-2058 • City of Columbia, Missouri . Petrotech Completed Four (4) GE Frame 6b DLN Turbine Generator Control System Upgrade using Allen Bradley ControlLogix platform with redundant CPU configuration. In addition, Petrotech Upgraded of the Balance of Plant (BOP) Control System for the Four (4) GE Frame 6B using Allen Bradley ControlLogix platform with redundant CPU configuration. Project Contact: John Gerke Email: john.gerke@como.gov Phone: 573 814-2731 CONFIDENTIAL Page 18 of 20 Proposal 19-0065 Revision 1 May 13, 2019 • Sempra, California Petrotech completed Upgrade the Balance of the Plant (BOP) Control System for the Four (4) GE Gas Turbines using Allen Bradley ControlLogix platform with Simplex CPU configuration. More references can be submitted upon request. CONFIDENTIAL Page 19 of 20 Proposal 19-0065 Revision 1 Section 6. Literature/Attachments Petrotech Limited Warranty Petrotech Standard Terms & Conditions (US) Rev Payment Bond Performance Bond Certificate of Insurance Hutchison Utilities Commission Signature Name .......... Title Date Signature Name ---------------- Title Date May 13, 2019 Bulletin 03007 Petrotech, Inc. S1, wre I evin COYr1 Fan Name Director, IIR & Corporate Services Title Date/ CONFIDENTIAL Page 20 of 20 TERMS AND CONDITIONS 1. Definitions In these Conditions of Sale:- 1.1 "The Company" means Petrotech, Inc. and its affiliates, subsidiaries and joint ventures. 1.2 "The Customer" means the person, firm or company purchasing the Goods. 1.3 "The Goods" means all goods, materials and services or to be supplied by the Company to the Customer under this Contract. 2. Acceptance of Order 2.1 All orders are accepted by the Company subject to these Terms and Conditions. These Terms and Conditions are the only terms or conditions upon which the Company sells or supplies the Goods and they shall form part of and govern every order between the Company and the Customer for the supply of Goods. 2.2 No terms and conditions referred to or imposed by the Customer and no addition to or variation of these Terms and Conditions shall have effect except to the extent that it was expressly agreed to in writing and signed by a duly authorized representative of the Company. In particular orders submitted on Customers' own purchase order forms will be accepted by the Company only upon condition and with the express understanding that the liabilities of the Company shall be determined solely by these Conditions of Sale and in accepting and consummating any such order the Company shall be deemed not to have in any way changed, enlarged or modified its liabilities or obligations as fixed by these Conditions of Sale. 2.3 The Company has a policy of continuous improvements to its products and in pursuance of this policy reserves the right to alter the specifications, types or models of Goods at any time without notice provided such changes shall not affect the validity of the Contract. 2.4 Where Goods are sold packed the extent of packing and/or protection will be at the Company's discretion unless the Customer stipulates special packing, in which case such packing will be charged extra. Petrotech, Inc. 3. Quotations 3.1 Quotations indicate the price at which the Company will be willing to supply Goods if a firm order is placed within 30 days unless otherwise specified in the quotation. 3.2 A quotation is not an offer to supply Goods and no Contract shall arise between the Company and the Customer until a firm order by the Customer has been accepted in writing by the Company and the date of such acceptance shall be the Contract date. 4. Price 4.1 The price of the Goods shall be in accordance with the Quotation or Schedule of Rates as varied in accordance with clause 4.2. 4.2 All rates as specified in the Schedule of Rates are subject to periodic change at the discretion of the Company. 4.3 Except where otherwise agreed in writing any specified price shall be the price of the Goods ex -works and the Customer shall in addition to the price payable for the Goods pay all duties, charges and taxes on the Goods. 5. Payment Terms 5.1 Unless otherwise expressly agreed in writing payment for Goods will be due upon receipt of the relevant invoice. 5.2 Where payment is to be made by milestones, if the Customer fails to pay any installment on the due date, the Company may treat such failure as a breach of the entire Contract and recover the damages for such breach. 5.3 The Company reserves the right, without prejudice to any other rights which it may have, to charge interest at the rate of 2% per month of the unpaid balance on overdue accounts. 6. Delivery 6.1 Delivery is Ex -Works unless otherwise agreed in writing in which case the Company shall provide reasonable assistance to arrange delivery of the Goods in accordance with the Customer's instructions. However time for delivery and installation shall not be of the essence of the Contract and delay shall not entitle the Customer to remedy. US Rev 3 petrotechinc.com Page 1 6.2 6.3 TERMS AND CONDITIONS The Company shall be entitled to levy additional delivery, insurance, transportation, storage and handling charges in the event of the Customer failing or refusing for any reason to take delivery of the Goods at any time during normal working hours and shall be entitled to determine the Contract if the Customer then fails to take delivery within 14 days of a written request requiring him to do SO. The Customer will be responsible for obtaining any import licenses and complying with all regulations governing admission of Goods into the country of destination and for payment of all customs duties, port dues and other charges. 7. Passing of Risk to Customer The Goods shall be at the Customer's risk: 7.1 Where delivery is Ex -Works from the time when the Goods are loaded onto the vehicle; 7.2 In the case of f.o.b. export Contracts from the time the Goods are loaded on board at the port of shipment, 7.3 In any other case from the time the Goods are unloaded at the point of delivery. 8. 8.1 Passing of Property to Customer The title to Goods supplied under the Contract shall not pass to the Customer until the Company has received payment in full of all sums invoiced under each and every Contract between the Company and the Customer together with any interest accrued thereon and other charges. In the meantime the Company shall retain the full legal and beneficial title to the Goods and the Customer shall hold such goods in a fiduciary capacity as the Company's bailee free from any charge, lien or other encumbrance, shall store the Goods separately (in such a way that they can be clearly identified as the Company's property) and shall keep them fully insured with a reputable insurer. During this period, the Company shall be entitled without restrictions to lawfully enter upon the premises of the Customer for the purpose of removing the Goods. The Customer shall pay all costs and expenses incurred by the Company in exercising this right. Notwithstanding that title may not have passed to the Customer, the Company may maintain an action for the price of Goods supplied. Petrotec, Inc. 9. Indemnity 9.1 EACH PARTY SHALL HOLD HARMLESS AND INDEMNIFY THE OTHER PARTY FROM ANY AND ALL CONSEQUENTIAL, INCIDENTAL, INDIRECT, SPECIAL OR PUNITIVE DAMAGES ARISING OUT OF THIS AGREEMENT WHETHER BASED UPON LOST GOODWILL, LOST REVENUE OR ANTICIPATED PROFITS, INTEREST, LOSS OF USE, OR WORK STOPPAGE WHETHER OR NOT LOSS OR DAMAGE IS BASED ON CONTRACT, WARRANTY, NEGLIGENCE, INDEMNITY, TORT, STRICT LIABILITY OR OTHERWISE, INCLUDING ANY SUCH DAMAGES OR LOSSES RESULTING FROM BUSINESS INTERRUPTION OR LOST PROFITS. 10. Warranties 10.1 All Goods are supplied with the benefit of a twelve month warranty unless otherwise specified. However, because the Goods require correct handling, storage'and processing and these matters are out of the Company's control once the Goods have left the Company's premises, the Company's liability in respect of the Goods shall be limited as set out in this clause. 10.2 The Company warrants that the Goods meet the agreed specification, will be free from material defect and of satisfactory quality. 10.3 The Customer will be responsible for inspecting and testing the Goods on arrival, and the Company shall not be liable for any consequential loss of any kind (including in particular loss of or defects in any product to which the Goods have been introduced or the consequences of any such product being defective). 10.4 The Company shall not be liable for any defect in the Goods unless: a) A claim is made by the Customer within 30 days of the Goods arriving at the Customer's premises, and b) The Company is given reasonable opportunity to inspect and test the Goods in the condition in which they arrived at the Customer's premises. 10.5 Except as provided herein, the Company shall not be liable to compensate or indemnify the Customer for any loss or damage whatsoever arising out of any damage to or defect in the Goods or as a result of negligence of the Company, its agents, servants or sub -contractors, and all of the conditions or warranties about the Goods which might otherwise be implied are hereby excluded. US Rev 3 petrotechinc.com Page 2 ° J TERMS AND CONDITIONS 11. Loss or Damage in Transit 11.1 Claims for damage or partial loss of Goods in transit must be made to the carrier immediately on delivery of the Goods and confirmed by facsimile telex or letter to the Company and to the carrier so as to reach both within three days of arrival of the Goods. 11.2 Claims for non -delivery of Goods must be made within twenty eight (28) days of the due date of arrival. 12. Force Majeure 12.1 Every effort will be made to perform any Contract between the Company and the Customer in accordance with its terms, but due performance is subject to such variation (including suspension or cancellation) as the Company may find necessary as a result of inability to secure labor, materials or supplies or as a result of any Act of God, war, strike, lock -out or other labor dispute, fire, flood, drought, legislation or order of any public authority or other cause (whether of the foregoing class or not) beyond the controlof the Company or its suppliers and the Company shall not be liable for an inability, to deliver in accordance with the Contract caused by any such contingency. 13. Assignment and Termination 13.1 This Contract may be terminated by the Company (without prejudice to any other remedy it may have) forthwith by notice in writing to the Customer if: - a) The Customer is in breach of the terms of these conditions; or b) The Customer (being an individual) dies or has a bankruptcy order made in respect of him or if the Customer (being a body corporate) goes or is put into liquidation otherwise than by voluntary liquidation for the purpose only of amalgamation or reconstruction or shall enter into an arrangement or composition with its creditors or if a receiver, administrative receiver or a similar officer is appointed in respect of the Customer's assets or undertaking or any part thereof or the Customer is subject to any similar action in any jurisdiction to which it is subject; or c) The Customer has failed to pay any sum due hereunder to the Company for a period in excess of thirty (30) days from the date of invoice. Petrotech, Inc. 13.2 Upon a lawful determination of the Contract the Company shall be entitled to immediately recover from the Customer (notwithstanding any period of credit extended to the Customer may not have expired) all sums then due to the Company under the Contract (including accrued interest and any other charges properly levied) and all losses arising to the Company as a result of such determination. 13.3 The Company may suspend performance of any Contract for the sale of Goods incorporating these terms in the event that the Customer is in breach of any Contract with the Company until such time as any such breach has been remedied to the reasonable satisfaction of the Company. 14. Law 14.1 These conditions and all other express terms of the Contract shall be governed and construed in accordance with the laws of Louisiana, USA. US Rev 3 petrotechinc.com Page 3 HUTCHINSON UTILITIES COMMISSION�1` Board Action Form �rMturscti mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm Agenda Item: Approval of Requisition 008006- Prince of Peace Relocate Presenter: John Webster Agenda Item Type: Time Requested (Minutes): 2 New Business Attachments,: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: Prince of Peace Senior Apartments, Inc. ( AKA Prince of Peace, Prince of Peace Retirement Living, POPRL) has requested that Hutchinson Utilities move the gas line that is currently located in the alley behind 301 Glen St SW. The POPRL Board of Directors has passed a motion to pay for the cost of moving the gas line and cost of materials. As this is a 2" steel line, a contractor is required to perform the work for Hutchinson Utilities. Three contractors have been contacted, and the results are listed below: Northern Pipeline Construction - $26,352.00 Michels - Unable to Bid, no crews available Primoris (Q3 Contracting) - Unable to Bid, no resources available All expenses incurred on this project will be invoiced to Prince of Peace BOARD ACTION REQUESTED: Approval of requisition number 008006 Fiscal Impact: $26,352.00 Included in current budget: No Budget Change: No PROJECT SECTION: Total Project Cost: Approx $50,000 Remaining Cost: Approx $24,000 )07 I . ...... .. . )', 9", 3 0 f 1 e 1G Si r, , e VV I IIo i � rV \J 5 0 (,) 234 7588 ",elf (320) 583-2 H 7 l',320) 23,14,(`K355 Hutchinson Utilities Commission C/O John Webster, EIT, RGDP Director Natural Gas Division 225 Michigan St SE Hutchinson, MN 55350 EAF�t .......... . . , ... . ..... ... Refiirenrwir'a, Ltifir h,,-! g "Y"i e ir I t-rimf Apartments, Inc. (AKA �,,rince of Peace, Prince of Peace Retirement Living, POPRL) is requesting that the Hutchinson Utilities Commission move the gas line that is currently running down the alley behind the 301 Glen St SW property. The POPRL Board of Directors has passed a motion to pay for the cost of moving the gas line and cost of materials. As a 501@3 nonprofit organization, we are asking that labor costs and materials be billed separately. I have enclosed a Certificate of Exemption for your records. POPRL also requires that the delivery of the materials to POPRL and work on the project wait until I have given you approval in order to satisfy the bank's requirements. If you have any questions in regards to this vro�ect lease feel fr-,q-. f""", at Thank you. M Sincerely, Merline Duering Executive Director nl,lh"',Sh"'v-( W C )f oerd Lh1h �g h') ai� J, 1, l) /'/ f f :111(/ er�lor colm-nunfl, S and'151;el mililch rmr`r qt)alfly „4: rm OV HUTCHINSON UTILITIES .w COMMISM0I0 NPL 8190 215TH ST W LAKEVIEW, MN 55044-1300 Note: Description: Prince of Peace Relocate Project PURCHASE REQUISITION HUTCHINSON UTILITIES COMMISSION 225 MICHIGAN ST SE HUTCHINSON, MN 55350 Phone:320-587-4746 Fax:320-587-4721 Date Requisition No. 06/18/2019 008006 Required by: Requested by: JWebster Item Part No. Description Qty Unit Due Date Unit Price Ext. Amount No. INSTALL 565' OF 2" STEEL AND TWO - TDW 3- WAY TEES. CONTRACTOR TO PROVIDE AIR 1 000-00000 TEST AT 100 PSIG, TAP LINE INTO SERVICE, 1.00 EA 08/07/2019 $26,352.000 $26,352.00 RETIRE EXISTING LINE. RESTORATION NOT INCLUDED. MFG. PART;. Total 26,352.00 Date Printed: 06/19/2019 Requisitioned By: JWebster Page: 1/1 "Fit I U 1 t ; ;Ir',"A H 8190 215th street west LAKEVILLE, MN 55044 May 2, 2019 Hutchinson Utilities John Webster RE: 2" Steel Reroute NPL to mobilize to site for the install of 565' of 2" steel and two TDW away tees. We will air test and tap line into service, all materials by utility. Restoration not included in this proposal. 2" install and taps lump price $26,352.00 Thank You for the opportunity to work with you on your project, if you have any questions please feel free to contact me at any time. Sincerely, Mike Theis NPL (612)221-2517 cell (952)469-2800 office 3 m 3 m c 0 m - cr , ¥ .. .. 7 $ 0 7 0 ƒ / Rac Cr o ƒ J (D 0 � k �222 &ff� / tD / (A % L Ln CD 2 % 0 3 � #/ -0 Iq 0 O: 0 0 7 k CO �// /CCn q \ @ \ Z coLn k co / k 7 k \ E 2ƒ ■ CD % O q« j 0 o � 2 ca O 2 2 k � .� j E 2 w / � � / C 0 M § � rn ƒ / I \/�o 7 2 77 5 ' « §/Q/ E oo / @ tD ] @ F k v 0 cr c o 0 �m ro C CD O O c o LM 3 A cu a 0 `O O m 3 '+ 3 �q '=r V�f n N O O LL A fD F' "< n lD rD m `^ F� C (D V U7 N 7' 0 �n, S N ll Oo o ?r .`. �N -. O 00 it Fo Oo 00 CA V CJl � N (cn CCD_ (D O O W W O (p 7 O VJ W Ln < w (D cn W O O O CD m � CD CD m 0 n y. cn Z) nO O 'aCD 0 c O ry. O o M MM 0 3 O CC S C � a m :3 d O ^C n C � O (D W N X, 0. %r O � � N n � � S V 0 3 pn:i o(- mmc;b0 T r z f 9 � � w w N N 0 �Cli �? > --f fVCM O X 6 r m Ui m G) --I G) 0 z 0 `0 0 c_ m (P? 0 0' d 0 x z CD M LA LA lu as m -h I 0 3 C) 00 w tl J w I I u n i c),- m Fri c �b 0 I n n z > z 0 0 m 0 :1 N) 0 o 0 z z > 0 c a M --1 0 x 00 I > > > b (D r m < m u W 6) 0 N W > 0 > z I w U) U 0 ) m 0 > (n z W Z z n > m K U) m 0 m K m n 0 x m E z m --i 0 9j Pi X m m u 7 1 L- G) 0 0 M rl M 0 c ;u n > a: K z o (n 0 z > c r z c m M QO (0 Z 0 m T m 0 n 0 w 0 T 0 Cm TI 0 0 m w I �• ° �� s 0 c 0 c X'COD (D CD O fD rtCC OW X = p f,�, S C E ,� N (D CD N O M lD CL S O (D a. fD 7 EA 0 -1 C CSi C p �-r n c,D ;< pr u� C:)= � p S a o N 3 0 < o 0 co r+ a '* CO c� O O � C CD coN -0 rr e-r "I NJ '* O FD re) W W r. O Cp N p cra fD A p cn O O N n Q1 N G n (DDD :3 fD O 0 c U1 0 W C C O O N V O 1 c O A 0 O rt m O CD CD 2 O a O -n 01 F, 0. (D 3 !: 9' "Al N Ol CD 0 O N C 0 rr N rr O r Lo N Lo ALrl ~ N m D cD O a -Z (A) 6) (p �i,D q � C, F1 70 0 01 C.F� 3 �.m. G') 0 U) (1) Pq N p Gmq� 0 x U) 0 Ii rl "-q C) _1 Q > " PI 70 �a a 0 n c Y (j) I C z C O Qn m ! rt m = Tl Q r+ rF (p CL A � N S n A O Ln �n m.. T1 3 O S 7 f cr m 0, 0 7 i m I — (A -4 (A -n 0 r+ 3 M > r+ =r NrD m CL o --% — = (D 03 LM (A CL M aQ m (D 0) 0 Z3 A 0 7z rr Ln r q r) (D C, < 0 Ln ?. n ko —- I G ') m -q 00 =r pi C) c LA 0 v 0 Mj Ti 3 dN v PI -71 m 19 co LA (A n c fD -t R fD LA Nn F� ID =r F; CL 5 -n Ln 0 (D 0 iA fi CL m 00 o P :3 w cr 1, W C) M Ul Ln 4�1 Ln NJ NJ 0 -b Ln 1+ fD Nj 0 r o� op�� w � o` C �fA In M o 14 r '* M o p -� O w m CCD 3 s o p� rr O y $ N W N 0rn 1 n rt 0) U7 v "C N �. - L ' fD A rF A Q fp -M (D we fir, i O A V v C y n S O C 0 Q O c O O 'O O �� pp On m O(D Q rb �� U7 v '� (D a n n N vNi I , m m �� rr N Oq n M s '+ c �,' - � M A '+ (D n CD O� C N C W (D Cr (A 0M � ` n C3. d ? (D Np (D O -1 of c cr a fD A _ CC m O G N LD nS t D N -O ~ r�r 7 Q O r _ (D ,-r O (D ? 00 nn S Ln (D (A:3 O O � rF O Lo � `< [D 3 v a- O O 7 n (D (D --i N (AO 7 V1 7< l0 V 7 y I N (D 7 4 O FO 77 (A V O C OT co 00 00 O rD a O 3 Q V � O O =r Vf N O `C -4 IV O1 7 Q O Of N C rr 3 C N rr M (D N (D n 1+ h C Q (D ('1 7� lD e-h O Q Q C (D rt O rr S (D n rr rr S qJ rr I N 0 -M 0 211 <; Ln M r.L % C Or Ln M. �Al, M M c 0 to m 4r- cr Jj W C) s5A' 0 =r A =r v Cli > HUTCHINSON UTILITIES COMMISSION�1` Board Action Form �rMturscti mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm Agenda Item: Approval of Requisition 008007- Waller Drive Relocate Presenter: John Webster Agenda Item Type: Time Requested (Minutes): 2 New Business Attachments,: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: The City of Hutchinson has requested that the existing 3" steel main that feeds HTI be relocated to allow the City of Hutchison to perform storm drainage work on Waller Dr. As this is a 3" steel line, a contractor is required to perform the work for Hutchinson Utilities. The replacement of this line also allows the Natural Gas Division to retire a non -complying underground valve. Three contractors have been contacted, and the results are listed below: Northern Pipeline Construction - $28,352.00 Michels - Unable to Bid, no crews available Primoris (Q3 Contracting) - Unable to Bid, No resources available BOARD ACTION REQUESTED: Approval of requisition number 008007 Fiscal Impact: $28,352.00 Included in current budget: Yes Budget Change: No PROJECT SECTION: Total Project Cost: Approx $50,000 Remaining Cost: Approx $21,000 HUTCHINSON UTILITIES � s NPL 8190 215TH ST W LAKEVIEW, MN 55044-1300 Note: Description: Waller Drive - 4" Steel PURCHASE REQUISITION HUTCHINSON UTILITIES COMMISSION 225 MICHIGAN ST SE HUTCHINSON, MN 55350 Phone:320-587-4746 Fax:320-587-4721 Date Requisition No. 06/18/2019 008007 Required by: Requested by: JWebster Item part No. Description Oty Unit Due Date Unit Price Ext. Amount No. INSTALL APPROXIMATELY 200' OF 4" STEEL - AND TWO TDW 3-WAY TEES. CONTRACTOR TO AIR TEST NEW FACILITIES TO 100 PSIG, 1 TAP INTO SERVICE AND RETIRE EXISTING 3" 1.00 EA 08/17/2019 $28,352.000 $28,352.00 STEEL. HARD SURFACE RESTORATION NOT INCLUDED. MFG. PART; Total 28,362.00 Date Printed: 06/19/2019 Requisitioned By: JWebster Page: 1/1 Via,,, if fV t;eK May 12, 2019 Hutchinson Utilities John Webster RE: 4" Steel Reroute 8190 215th street west LAKEVILLE, MN 55044 NPL to mobilize to site for the install of 200' of 4" steel and two TDW 3way tees. We will air test and tap line into service, all materials by utility. Hard surface Restoration not included in this proposal. 4" install and taps lump price $285352.00 Thank You for the opportunity to work with you on your project, if you have any questions please feel free to contact me at any time. Sincerely, Mike Theis NPL (612)221-2517 cell (952)469-2800 office 3 m 3 m c 0 m - cr , ¥ .. .. 7 $ 0 7 0 ƒ / Rac Cr o ƒ J (D 0 � k �222 &ff� / tD / (A % L Ln CD 2 % 0 3 � #/ -0 Iq 0 O: 0 0 7 k CO �// /CCn q \ @ \ Z coLn k co / k 7 k \ E 2ƒ ■ CD % O q« j 0 o � 2 ca O 2 2 k � .� j E 2 w / � � / C 0 M § � rn ƒ / I \/�o 7 2 77 5 ' « §/Q/ E oo / @ tD ] @ F k v 0 cr c o 0 �m ro C CD O O c o LM 3 A cu a 0 `O O m 3 '+ 3 �q '=r V�f n N O O LL A fD F' "< n lD rD m `^ F� C (D V U7 N 7' 0 �n, S N ll Oo o ?r .`. �N -. O 00 it Fo Oo 00 CA V CJl � N (cn CCD_ (D O O W W O (p 7 O VJ W Ln < w (D cn W O O O CD m � CD CD m 0 n y. cn Z) nO O 'aCD 0 c O ry. O o M MM 0 3 O CC S C � a m :3 d O ^C n C � O (D W N X, 0. %r O � � N n � � S V 0 3 pn:i o(- mmc;b0 T r z f 9 � � w w N N 0 �Cli �? > --f fVCM O X 6 r m Ui m G) --I G) 0 z 0 `0 0 c_ m (P? 0 0' d 0 x z CD M LA LA lu as m -h I 0 3 C) 00 w tl J w I I u n i c),- m Fri c �b 0 I n n z > z 0 0 m 0 :1 N) 0 o 0 z z > 0 c a M --1 0 x 00 I > > > b (D r m < m u W 6) 0 N W > 0 > z I w U) U 0 ) m 0 > (n z W Z z n > m K U) m 0 m K m n 0 x m E z m --i 0 9j Pi X m m u 7 1 L- G) 0 0 M rl M 0 c ;u n > a: K z o (n 0 z > c r z c m M QO (0 Z 0 m T m 0 n 0 w 0 T 0 Cm TI 0 0 m w I �• ° �� s 0 c 0 c X'COD (D CD O fD rtCC OW X = p f,�, S C E ,� N (D CD N O M lD CL S O (D a. fD 7 EA 0 -1 C CSi C p �-r n c,D ;< pr u� C:)= � p S a o N 3 0 < o 0 co r+ a '* CO c� O O � C CD coN -0 rr e-r "I NJ '* O FD re) W W r. O Cp N p cra fD A p cn O O N n Q1 N G n (DDD :3 fD O 0 c U1 0 W C C O O N V O 1 c O A 0 O rt m O CD CD 2 O a O -n 01 F, 0. (D 3 !: 9' "Al N Ol CD 0 O N C 0 rr N rr O r Lo N Lo ALrl ~ N m D cD O a -Z (A) 6) (p �i,D q � C, F1 70 0 01 C.F� 3 �.m. G') 0 U) (1) Pq N p Gmq� 0 x U) 0 Ii rl "-q C) _1 Q > " PI 70 �a a 0 n c Y (j) I C z C O Qn m ! rt m = Tl Q r+ rF (p CL A � N S n A O Ln �n m.. T1 3 O S 7 f cr m 0, 0 7 i m I — (A -4 (A -n 0 r+ 3 M > r+ =r NrD m CL o --% — = (D 03 LM (A CL M aQ m (D 0) 0 Z3 A 0 7z rr Ln r q r) (D C, < 0 Ln ?. n ko —- I G ') m -q 00 =r pi C) c LA 0 v 0 Mj Ti 3 dN v PI -71 m 19 co LA (A n c fD -t R fD LA Nn F� ID =r F; CL 5 -n Ln 0 (D 0 iA fi CL m 00 o P :3 w cr 1, W C) M Ul Ln 4�1 Ln NJ NJ 0 -b Ln 1+ fD Nj 0 r o� op�� w � o` C �fA In M o 14 r '* M o p -� O w m CCD 3 s o p� rr O y $ N W N 0rn 1 n rt 0) U7 v "C N �. - L ' fD A rF A Q fp -M (D we fir, i O A V v C y n S O C 0 Q O c O O 'O O �� pp On m O(D Q rb �� U7 v '� (D a n n N vNi I , m m �� rr N Oq n M s '+ c �,' - � M A '+ (D n CD O� C N C W (D Cr (A 0M � ` n C3. d ? (D Np (D O -1 of c cr a fD A _ CC m O G N LD nS t D N -O ~ r�r 7 Q O r _ (D ,-r O (D ? 00 nn S Ln (D (A:3 O O � rF O Lo � `< [D 3 v a- O O 7 n (D (D --i N (AO 7 V1 7< l0 V 7 y I N (D 7 4 O FO 77 (A V O C OT co 00 00 O rD a O 3 Q V � O O =r Vf N O `C -4 IV O1 7 Q O Of N C rr 3 C N rr M (D N (D n 1+ h C Q (D ('1 7� lD e-h O Q Q C (D rt O rr S (D n rr rr S qJ rr I N 0 -M 0 211 <; Ln M r.L % C Or Ln M. �Al, M M c 0 to m 4r- cr Jj W C) s5A' 0 =r A =r v Cli > HUTCHINSON UTILITIES COMMISSION�1` Board Action Form �rMturscti mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm Agenda Item: Requisition #8013: SCADA Master Replacement Presenter: Dan L. Agenda Item Type: Time Requested (Minutes): 5 New Business Attachments,: Yes BACKGROUND/EXPLANATION OFAGENDA ITEM: HUC Staff wishes to replace the Supervisory Control and Data Acquisition (SCADA) Master due to outdated and obsolete software which is causing compatibility issues with key items such as the Windows operating system, support software/cybersecurity, and field devices. Presently there is no manufacturer support of HUC's SCADA system. Updating the system will also allow for the optional expansion and integration of outage management, GIS, and other system reliability products. Quotes received: Survalent Technology, Inc.: $112,750 Advanced Control Systems: $68,410 HUC Staff is recommending the approval of the quote provided by Survalent due to its fulfillment of HUC's specifications in the areas of OS compatibility (Windows vs Linux), cybersecurity/workstation access (SQL Server database in DMZ vs individual PC software), and migration of current end user requirements (daily natural gas logs). Price includes software licenses, system development, commissioning, and training for administrators and users. This project was included in the 2019 O&M budget ($160,000). Cost to be split between Electric and Natural Gas Divisions. BOARD ACTION REQUESTED: Approve Requisition #8013 Fiscal Impact: Included in current budget: Yes Budget Change: No PROJECT SECTION: Total Project Cost: Remaining Cost: HUTCHINSON UTILITIES PURCHASE REQUISITION HUTCHINSON UTILITIES COMMISSION 225 MICHIGAN ST SE HUTCHINSON, MN 55350 Phone: 320-587-4746 Fax: 320-587-4721 SURVALENT TECHNOLOGY, INC 1967 WEHRLE DR, SUITE 1, PMB122 BUFFALO, NY 14221 Note: Description: SCADA Master Date Requisition No. 06/1912019 008013 Required by: Requested by: 131-ang Item No. Part No. Description oty Unit Due Date Unit Price Ext. Amount SCADA MASTER (ELEC DIV) - SURVALENT SCADA SOFTWARE LICENSES, PROJECT MANAGEMENT, COMMISSIONING, AND 1 000-00000 TRAINING. 1.00 EA 06/19/2019 $56,375.000 $56,375.00 SEE ATTACHMENT FOR QUOTE NO. Al 8962645[REV2] MFG. PART I SCADA MASTER (GAS DIV) - SURVALENT SCADA SOFTWARE LICENSES, PROJECT MANAGEMENT, COMMISSIONING, AND 2 000-00000 TRAINING. 1.00 EA 06/19/2019 $56,375.000 $56,375.00 SEE ATTACHMENT FOR QUOTE NO. A18 9 62645[REV2] MFG. PART I Total: 112,750.00 Date Printed: 06/19/2019 Requisitioned By: DI-ang Page: 1/1 � � y : �. - « » %i i»i ��z»1y � � � \} � % � . � < / ~� � � � . . . x ƒ ', . . � \ ^ � > � : & . , . Survallent Technology Inc„ 1967.wehrie Drive, Suite 1, PMB 122 Buffallo, New YoIrk- USA 1 221 IT +1-905-825-5000 - F +1--905-820-7144 sLurvaIlent.com � o�� IIU 1111111,11, 001 1 SurvalentONE SCADA Software Dual Server INCLUDED The base SCADA license includes data acquisition, data processing, alarm and eEvent processing, and historical data management functions. It also includes the STC Explorer database editor which includes editing tools for database points, access control, control zones, system parameters, station cloning, point modelling, and setup of advanced applications. Other features include command sequencing, alarm suppression, event data recording and archiving, mapboard driver, and remote alarm annunciation. 002 3 SurvalentONE SmartVU (1 Concurrent User) INCLUDED SmartVU provides a modern, intuitive, user friendly user interface for managing the distribution network using high quality graphics driven by a powerful graphics engine. The SmartVU environment includes a tabbed interface that provides quick access to a large number of graphic displays including single -line diagrams, geographical maps, trend graphs, summary displays, operations log, and tabular views of the distribution network. The graphic displays support layers, panning, zooming, decluttering, dynamic line coloring, hyperlinks, and other dynamic display features as well as standard graphics formats such as JPG, BMP, PDF, etc. One license is required for each concurrent user. 003 1 SurvalentONE Standard DNP3 Protocol INCLUDED The DNP3 scan task is designed to communicate with one or more devices that use the DNP3 protocol over serial asynchronous or TCP/IP communication lines. The scan task conforms to Level 2 of the DNP3 Application Layer protocol as specified in the Subset Definitions published by the DNP3 User's Group. This license is for the standard DNP3 protocol implementation, Secure DNP3 Protocol is also available under a separate license. 004 1 SurvalentONE Standard ICCP Protocol INCLUDED ICCP is an industry -standard protocol designed to share information with different vendor computer systems. It is typically used for data transfer between two or more SCADA master stations. The system support conformance blocks 1, 2 and 5. This license is for the standard ICCP protocol implementaiton, Secure ICCP Protocol is also available under a separate license. 06-Jun-2019 [A18_9_62645_Rev2] PROPRIETARY AND CONFIDENTIAL Page 2 of 12 Survallent Technology Inc„ 1.967' ehrie Drive, Suite 1, PMB 122 Buffalo, New YoY rk- USA 1 221 T +1-905-826-5000 - F +1--905-826-7144 sLurvaIlent.com EM 005 1 1-1 1 1 1 1 e e SurvalentONE IED Control Panel IED Control Panel is a rapid graphical user interface development tool for SmartVU. The IED Control Panel application is a companion product to the IED Wizard, but can be used as a stand-alone product. It allows users to interact with a graphic representation of an intelligent electronic device (IED), just like they were standing in front of it. The IED Control Panel application contains an extensive library of the most common IEDs available on the market, including SEL, Cooper, ABB, Beckwith, and PML. . . 0 INCLUDED 006 1 SurvalentONE IED Wizard INCLUDED IED Wizard is a tool that automates the creation of the database for an intelligent electronic device (IED). In just a few simple steps, the wizard creates the required points in the SCADA system database. All of the telemetry and control addresses are generated automatically. The IED Wizard completely eliminates the tedious error -prone data entry of telemetry addresses and mapping tables. The IED Wizard contains an extensive library of the most common IEDs available on the market, including SEL, Cooper, ABB, Beckwith, and PML. 007 1 SurvalentONE Network Topology Processor INCLUDED The Network Topology Processor application calculates the energized/de-energized status of electric, gas and water line sections, and displays them on world maps. The calculation is based on the topology of the system and the current status of breakers and valves. For an electrical line section, the system supports 3-phase distribution, and computes the status of each phase independently, such that line sections that are downstream of non -ganged switching devices may contain a mix of energized and de -energized phases. The user can specify colors for "partially energized" or "partially looped" etc. The topology processor includes a feeder trace function that allows the user to select a trace color and have the extent of a feeder highlighted in the selected trace color. Multiple simultaneous traces in different colors are supported. 008 1 SurvalentONE SCADA Add -in INCLUDED A Microsoft Excel add -in that allows the user to export real-time and historical data from the SCADA system into Microsoft Excel. All point data fields (not just values) are available to export. The menu commands are available from the standard menu bar within Microsoft Excel. Note: Microsoft office software and license is not included. 06-Jun-2019 [A18_9_62645_Rev2] PROPRIETARY AND CONFIDENTIAL Page 3 of 12 Survallent Technology Inc„ 1.967' ehrie Drive, Suite 1, PMB 122 Buffalo, New YoY rk - USA 14221 T +1-905-825-5000 - F +1--905-826-7144 sLurvaIlent.com EM 009 1 11-1 1 1 1 1 ingimplil !!!!!!!I I === SurvalentONE Replicator & Archiver Single Server Replicator provides near -real-time replication of the ADMS-SCADA database to a SQL Server database in the DMZ, providing access to ADMS-SCADA data by external systems. Archiver provide long-term storage of historical data in the DMZ by transferring the historical data into a parallel set of archive tables, and allowing the archive tables to grow to a much larger size, or even indefinitely. Note: Microsoft SQL Server License is not included. . . 0 INCLUDED 010 1 SurvalentONE WebSury Portal Single Server INCLUDED The WebSury portal provides the ability to display near -real-time ADMS information to corporate users via web browser and without the need for custom installation or maintenance. WebSury allows the user to call up and view any SmartVu graphical display, substation one -line, or tabular display. Refresh of dynamic data, alarms, and graphics can be user defined and achieved on a periodic basis every few seconds. WebSury supports panning, zooming, dynamic line coloring and other dynamic features of the SmartVu interface. 011 1 Project Management Included: Correspondence, customer guidance/consulting/exchange of data and conference calls/meetings. The customer is required to provide: a)Point list in Excel containing Points' addresses (RTU-to-Master); Other data for status points: 1. Bit (0 or 1) indicating the point's abnormal state; 2. Command -state strings; 3. The alarm priority level (1 to 10) for each status. Other data for analog points: 1. Scale factor; 2. Offset (if applicable); 3. Alarm limits (pre -emergency low/high, emergency low/high, unreasonably low/high) b)Drawings: DWG, DXF, pdf or picture format of the Single -line diagrams 06-Jun-2019 [A18_9_62645_Rev2] PROPRIETARY AND CONFIDENTIAL Page 4 of 12 Survallent Technology Inc„ 1.967' ehrie Drive, Suite 1, PMB 122 Buffalo, New YoY rk- USA 1 221 T+1-905-826-5000-F+1--905-826-7144 sLurvaIlent.com EM 11-1 1 1 1 1 ingimplil !!!!!!!I I === . . 0 012 1 Database and Graphics Generation Gas Site Included: a)Database development with the utilization of method of direct mapping and/or use of existing or customized IED Templates for building database with the following specification: Total database points: max 230 Calculations: for a max. 50 points Command sequences for gas sites: max 5 Typical reports: 1 Historical datasets for a max. 100 points b)Graphics development: Views: 2 -Natural Gas Pipeline -HWY 212/Brownton Muni Implementation of standard library or customized control panels if applicable Creation of Navigation Template 013 1 On -Site Training - System Administration — Level 1 This 5-day on -site course is designed for individuals who will be responsible for installation, configuration, and maintenance of the SCADA System. Topics covered include SCADA client/server architecture, database generation and maintenance, display generation and maintenance, SCADA attributes (alarm priorities, analog limits, etc.), historical data, trend graphs, topology processor, system backups, trouble -shooting techniques, maintenance procedures, and more. 014 1 SCADA System Installation & Commissioning Five consecutive days of on -site system engineering services for system installation & commissioning. Services purchased on a project order must be used before the end of system commissioning. Services purchased outside a project order will be invoiced on receipt of order, and must be used within 6 months unless mutually agreed by both parties. No refund will be provided for any unused hours. 015 1 SCADA System Optimization & Operator Training Five consecutive days of on -site system engineering services for system optimization, performance tuning, and operator training. Services purchased on a project order must be used before the end of system commissioning. Services purchased outside a project order will be invoiced on receipt of order, and must be used within 6 months unless mutually agreed by both parties. No refund will be provided for any unused hours. 06-Jun-2019 [A18_9_62645_Rev2] PROPRIETARY AND CONFIDENTIAL Page 5 of 12 Survallent Technology Inc„ 1.967' ehrie Drive, Suite 1, PMB 122 Buffalo, New YoIrk- USA 1 221 T +1-905-826-5000 - F +1--905-826-7144 sLurvaIlent.com 016 1 SCADA/OMS/DMS Production Server DELL PowerEdge R430 Rack Server (or equivalent) 1 x Intel Xeon ES-2630 2.2GHz 2 x 8GB RAM 2 x 960GB Solid State Drive (RAID-1) Windows Server 2016 Standard Edition (10 Cores) 017 1 DMZ WebSury Web Server DELL PowerEdge R430 Rack Server (or equivalent) 1 x Intel Xeon ES-2630 2.2GHz 3 x 8GB RAM 2 x 960GB Solid State Drive (RAID-1) Windows Server 2016 Standard Edition (10 Cores) 018 1 SurvalentONE GIS Wizard $40,000 The GIS Wizard is used to import the distribution network model and geographic displays into the ADMS. The GIS Wizard checks for the absence of essential electrical information such as phase, KVA and section names and provides an additional level of electrical connectivity check to ensure the data that is imported is complete and correct. It also checks the spatial relationship for your field devices such as transformers and service locations, ensuring the secondary network is accurate. The graphical user interface allows the GIS Specialist to quickly locate database objects with data issues, enabling them to quickly fix them. Note: Requires an ESRI ArcGIS for Desktop Basic license (not included). Note: Hardware is not included. This application normally runs on the GIS server. Note: Customer must provide a properly formatted geodatabase (.gdb) or shape files containing the connectivity model, distribution transformers, and service locations. 019 1 SurvalentONE MultiSpeak AMI Interface $22,500 This MultiSpeak interface is used to ping meters, disconnect and reconnect meters, receive unsolicited outage and event reports from meters, and read voltages and other data on demand or on schedule via an external Advanced Metering Infrastructure (AMI). Note: Refer to the product overview document for details of messages supported; any custom interface will be quoted and priced separately. 06-Jun-2019 [A18_9_62645_Rev2] PROPRIETARY AND CONFIDENTIAL Page 6 of 12 020 021 Survallent Technology Inc„ 1967.wehrie Drive, Suite 1, PMB 122 Buffallo, New York- USA 1 221 T+1-905-826-5000-F+1--905-826-7144 sLurvaIlent.com 1 Database and Graphics Generation Electric Part Included: a)Database development with the utilization of method of direct mapping and/or use of existing or customized IED Templates for building database with the following specification: Substations included: 6 Total database points: max 3562 Calculations: for a max. 20 points Typical reports: 2 Historical datasets for a max. 2400 points ICCP database setup *No Command Sequences included b)Graphics development: Views: 7 -Main/Home -3M Substation -HTI Substation -Hutchinson Substation -McLeod Substation -Plant 1-13.8kV Bus -Plant 2 Substation Implementation of standard library or customized control panels if applicable Creation of Navigation Template 1 SCS implementation Included: Implementation of SCS on 6 substation SLDs. $27,000 $8,000 06-Jun-2019 [A18_9_62645_Rev2] PROPRIETARY AND CONFIDENTIAL Page 7 of 12 Survallent Technology Inc„ 1.967' ehrie Drive, Suite 1, PMB 122 Buffallo, New YoY rk- USA 1 221 T+1-905-826-5000-F+1--905-826-7144 sLurvaIlent.com EM 11-1 1 1 1 1 . 0 e e 022 1 GIS Import $20,000 Included: • Conversion of spatial data with the use of GIS Wizard and GIS Batch Import application and preparation for importing the system model and map from the owner's system • Customer guidance and check of GDB file during the clean-up process (customer's responsibility); • Import of service territory dwg; • Preparation of the graphics for the connectivity import: creating SCS color tables, GIS pmacros and GIS Symbols; • Import of the connectivity model from the GIS database into the SCADA system with the use of Survalent Connectivity Import facility; • Generating database points for manual switches. • Establishing connection between outgoing substation feeders from 6 substations with the connectivity model outside the substation and map optimization. 023 1 Silver SCADA Support Plan [1 Year] $14,900 The Silver SCADA Support Plan provides the following: a) Access to the latest software releases of the delivered SurvalentONE software components, effectively providing an extended warranty on these software components and providing access to the latest product features. b) Access to the Survalent Support Portal which includes the ability to create and track support cases, and provides access to software downloads, product documentation, knowledge base articles, live chat, and support forums. c) 240 access to priority, telephone emergency support from the Survalent Support Team. Cases will be treated on a first -come, first serve basis. d) 1 Global User Conference training pass and conference pass per year. 06-Jun-2019 [A18_9_62645_Rev2] PROPRIETARY AND CONFIDENTIAL Page 8 of 12 Survallent Technology Inc„ 1967.wehde Drive, Suite 1, PMB 122 Buffallo, New York- USA 1 221 T +1-905-825-5000 - F +1--905-828-7144 sLurvaIlent.com 024 I 1 I Gold SCADA Support Plan [1 Year] The Gold SCADA Support Plan provides the following: a) Access to the latest software releases of the delivered SurvalentONE software components, effectively providing an extended warranty on these software components and providing access to the latest product features. b) Access to the Survalent Support Portal which includes the ability to create and track support cases, and provides access to software downloads, product documentation, knowledge base articles, live chat, and support forums. c) 240 access to priority, telephone emergency support from the Survalent Support Team. Cases will be treated on a first -come, first serve basis. d) 2 Global User Conference training passes and conference passes per year. e) 25 hours (not more than 8 hours per day) per year of Remote Support Services. All services will be performed by Survalent staff from Survalent offices. Any hours not used during the support period will expire. $19, 900 06-Jun-2019 [A18_9_62645_Rev2] PROPRIETARY AND CONFIDENTIAL Page 9 of 12 Survallent Technology Inc„ 1.967' ehde Drive, Suite 1, PPw B 122 8ruffallo, New YoY rk- USA 1 221 T +1-905-826-50001- F +1--905-826-7144 sLurvaIlent.com 025 I 1 I Platinum SCADA Support Plan [1 Year] The Platinum SCADA Support Plan provides the following: a) Access to the latest software releases of the delivered SurvalentONE software components, effectively providing an extended warranty on all software components and providing access to the latest product features. b) Access to the Survalent Support Portal which includes the ability to create and track support cases, and provides access to software downloads, product documentation, knowledge base articles, live chat, and support forums. c) 240 access to priority, telephone emergency support from the Survalent Support Team. Cases will be treated on a first -come, first serve basis. d) 3 Global User Conference training passes and conference passes per year. e) 25 hours (not more than 8 hours per day) per year of Remote Support Services. All services will be performed by Survalent staff from Survalent offices. Any hours not used during the support period will expire. f) Access to a Survalent System Engineer on -site to provide technical assistance with software updates, assess system health and performance, perform system tuning, and any other technical assistance desired. Duration is 2 days for single and dual redundant configurations, 3 days for tri-redundant configurations, and 5 days for quad -redundant configurations. Site visit is once per year, and must be used during the support period. $27,200 End User: Hutchinson Utilities Commission Shipping Terms: EXW Ontario, Canada Shipment approximately 16 To 20 weeks from receipt of purchase order. Please send purchase order to stcorder@survalent.com Prices do not include applicable state, provincial, federal or other local taxes. This quote is valid for 60 days from date of issue and is based on Survalent Standard Terms and Conditions of Sale. Note 1: SurvalentONE SCADA software licenses are valid for up to 25,000 points and includes 12 months warranty. Note 2: Software licenses are non-refundable and cannot be exchanged. 06-Jun-2019 [A18_9_62645_Rev2] PROPRIETARY AND CONFIDENTIAL Page 10 of 12 Surr°vallent Technology Inc„ 1967.Wehrle Drive, Suite 1, PMB 122 Buffalo, New York- USA 1 221 T+1-905-826-50001- F +1--905-826-7144 sourrvalient.corn Note 3: Software license prices do not include installation and commissioning services. If you have not purchased system engineering services, and would like support to install, configure, test, and commission your system, please request a quote at sales@survalent.com Note 4: Survalent reserves the right to issue temporary licenses until payment has been received in full. Note 5: Survalent reserves the right to periodically audit the end user system configuration to ensure the software has been deployed in accordance with the Survalent Software License Agreement. Note 6: Maintenance price is based on Dual Server configuration. Note 7: Please ensure the end user client name is identified on the purchase order; purchase orders may be rejected if this information is missing. Note 8: Standard payment terms are 25% at end of project kickoff, 25% on shipment, 25% at end of commissioning, and 25% at end of training. This quotation is not valid unless signed by an authorized representative of Survalent. Prepared By: Juan Munoz, Inside Sales Approved By: 2 �� Joe De Fil ppis, Manager Project Delivery & Inside Sales 06-Jun-2019 [A18_9_62645_Rev2] PROPRIETARY AND CONFIDENTIAL Page 11 of 12 Most trusted provider of ADMS solutions acrmloss the glolbe Survalent. Confidential & Proprietary IN �Q. swrea�or �.umm sas+s��ome. .....:�uamn nne M�amme ..wna•:ero.+n�� remmm� rm . ��,;�w..r�auw �mn�wt�m�sw-amu�aaaim :i�vree� anam Confidential & proprietary ZEN 600 Largest System ................... ....................... 360 Largest Systems at PLN Indonesia Confidential & proprietary Electric Gas Water/ I ransit Wastewater Confidential & Proprietary . .............................. .......... . . . . . . . . . . . . .......... . . . . . . . . . ............ .............. ............. ............... ....... .......... ... ................ .......... ........... ........... Confidential & Proprietary Survalent. Allows utilities to effectively operate,, iimeme rnotiftor, m t m 000ie restore ,, 0 0 mi im 000i mowm critical r e mi k mi im pi o mowm m mi o Confidential & proprietary IN 10 WFIRMN2170, -0 1 - ✓*"AFArA'AVAFA jr Confidential & Proprietary Scalable Sean-fless Secure Confidential & Proprietary Confidential & Proprietary 0 Provides advanced supervisory control & data acquisition capabilities WO Real-time, automated network control & monitoring 0 Improves network reliability INN= OkWINIM 0 Streamlines operations lll�Offers advanced data collection capabilities -to manage remote assets Confidential & Proprietary Allows utilities to reduce the scale & duration of outages through efficient tracking & management providing: Predictive outage analysis m Processes for rapid damage assessmerE m Reporting capabilities m Enhanced customer communications capabilities 111111 1111 [llj1111jl 11 111! Confidential & Proprietary SurvalentONE DIVIS features a wide -range of applications that enable utilities to analyze & optimize their networks more efficiently = f M.161MIM =OUIRROMMMS minarans mim =-- v m Analyze & Forecastin,,.� Confidential & Proprietary ,VAjVA11AWXCS'" ra June 18, 2019 To: Hutchinson Utilities Commission 225 Michigan Street SE Hutchinson, MN 55350 Attn: Dan Lang dlang@ci. hutch inson. mn. us (320) 587-4746 Offer Number: PR-1905-4229 Description: PRISM SCADA Dear Mr. Lang, Advanced Control Systems, an Indra Company, is pleased to present to the Hutchinson Utilities Commission this offer to install a new PRISM SCADA System. Our PRISM SCADA System provides the latest in real-time operating system technology on a secure and stable Linux operating system sought after for mission critical operations. The SCADA system provides the following features: • Red Hat Linux operating system: Open system architecture, compatible with third -party applications and system interfaces. • DNP over TCP/IP communications: Network communications to RTUs and IEDs. • Alarm/event/SOE processing: Information is shown in a format that you can dynamically change and sort. • SCADA: Collects real-time information and controls field devices. • Real-time data trending: Trend multiple points in a window -any database point can be sampled and trended at different intervals. • Historical Data Collection: All data points can be collected, calculated, and archived. Please let us know of you have any questions. We are here to ensure that your system includes our latest technology enabling you to manage your network efficiently and effectively. Sincerely, Ganesh Ramjit Sales Director (281) 796-6715 ganesh.ramjit@acspower.com 'A ,WAWAW C1 ,,rable of Contents 1 Introduction....................................................................................................................................... 4 2 Solution Description.......................................................................................................................... 6 2.1 The PRISM & ACS Advantage................................................................................................ 6 2.2 ePRISM Remote User Access................................................................................................9 2.3 Option: eAlarm Event Notification and Summary .................................................................. 10 3 Scope of Supply............................................................................................................................. 11 3.1 System Hardware................................................................................................................. 11 3.2 System Software.................................................................................................................. 11 3.3 ACS Project Services........................................................................................................... 12 4 Pricing............................................................................................................................................ 13 4.1 Proposal Assumptions.......................................................................................................... 13 5 Terms and Conditions..................................................................................................................... 14 5.1 Terms of Payment................................................................................................................ 14 5.2 Shipping & Handling............................................................................................................. 14 Viunu: 8,2(09 iflldiunsoni U ➢IIJlh6i:ls U; D111uunuussii01111 „ 'A 0APAW C1 IIIIIII . aiiiro& lii' aiii[] ACS, an Indra Company, is pleased to present the following proposal to the Hutchinson Utilities Commission. The proposed solution is based on the PRISM platform that is trusted by over 200 utilities across the globe. PRISM is a highly scalable and modular platform that includes SCADA, DMS, OMS and EMS modules offering a high degree of flexibility in supporting both todays and future growth objectives. With ACS' real-time platform and the acquisition by Indra, ACS offers the most complete portfolio of solutions within the industry. In August 2018, ACS was acquired by Indra, a global IT solutions and consulting services company with revenues over $313N, more than 40,000 professionals, local presence in 46 countries and business operations in over 140 countries. More importantly for ACS customers and prospective customers, Indra invests over $200M a year in research and development to bring new solutions to market with the latest cutting -edge technology. Indra acquired ACS to add the real-time and advanced applications expertise and solutions to the existing Utility practice that already had a suite of market leading utility IT solutions. With ACS, the utility practice now has the most complete IT/OT solutions offering in the industry and over 450 customers rely on solutions from Indra and ACS to keep the lights on and to drive towards the utility of the future. The diagram below provides a high-level view of the combined ACS / Indra Utility IT/OT portfolio which supports the digital transformation while promoting a customer centric business model. Reporting, Eleci7lon Making, KPI KPIs, Analytirs Business Intelligence Plants & Energy Grid Smart Metering Vex✓/J Customer I II Management Ln Work Force Management ManagementManagement R�el'atVpl7.... Fa Maintenance Advanced rrtld Operations Meter Data Capture Cctiatptlnee5ervice LA lar � Geographic Informatiionsystern 0 Asset Perfoinin does Management DER Mai Dagement Miter data Management Meted to -Cash 0 V1 Energy Trading Sr >, Y;lisk IManagenvenit Energy 1NetwaorkDeveiopment Energy Control Prcrsurner Services ra + Management & Maintenance & FraUd detection � Cyberspctirity, © Cloud _u Open Platfrmrm PTtlelod data Prws SCADA 'Historian E',dc a 5 Services Blg Dana substaitianPTIJs Feeder AdltnH17tinn MlicroGridControls lnteiliigentIgodes Anal icsservices „Iliullu� 8,2(09 l iullcIhuilnsoilnU➢Ildl61:1' U;D111uunuussii01111 "ag,',I°"n 'A 0AWAV C1 Taking a deeper dive into the Grid Management solutions the ACS Solutions fit perfectly in the Advanced Grid Operations portion of the solution offering. With this extensive solution set we can offer a roadmap to increased functionality across the utility IT and OT domains. d� APsse ............... ....... ....... ..... ...... 6,pp`At,5POrfrnrmarnce pli ICauy k+a Gr"d �a�tt6 GOd k r^rformearnce Management ementt � Data a rw rc; ......... ......... ........: ....,. ........ I Data Historian E �wwww� & IMaurnttenance piaruo'r§tv�,..,Scher@nulwra, . tw✓Q 7btl1if."C11a 1"V Ceb ; r ol9 stnuct&k•,'d7'n �.. GIS Planning &:Scheduling Asset Data Management ��Ykti:r�tr cuenM1C eh ..., • ____"fir ttY�tk C,�___,,,....^k Nti eriwr If�aik,a..., u j ,"P CtQ IR.e aB'f i rate C4rrxrm unw catty rah bus C RT ') tttlstr� .........,ttutrn"W UI, ".........,, C4LR d;,ctruYrtMer r"^'ce Stnar%. �-y�, �i d�r� uu�t�wVllrvtlntt 5 tAbsta � � erronr�Rkd, . � ... Nodes Oren Meters When teaming with ACS, HUC will have one vendor for solutions that typically require numerous vendors and costly integrations. ACS looks forward to teaming with HUC to create a world class SCADA system and give HUC the ability to grow with one, industry -proven vender. „liliuno: 8,2(09 iflldiunsoni U ➢IIJlh6i:ls V;I'wYunuunuussii011il " gi:h 'A 0AWAV C1 11 . "The &ACS ii,; IIIII g ACS offers one of the most advanced and integrated suites of applications available today for the control and operation of a utility network. Our PRISM platform is based on more than 40 years of experience delivering "mission critical' real-time systems where performance, availability and reliability cannot be compromised. PRISM offers several key advantage/ benefits; • High Performance & Scalable architecture that can be extended over time • Modular yet integrated platform allows for phased implementations, in fact we deploy the full software stack offering a quicker time to benefits for future additions • Single network model for OMS and DMS applications using the utility GIS and available planning data as the source • Comprehensive full suite of advanced applications for visualization, optimization, analysis, operations and network automation • Unified and comprehensive user interface, providing safer and more efficient system control • Sophisticated simulator platform that enables training of operators and other personnel based on realistic operational scenarios and actual events captured from the operating system • Secure and reliable platform running on RedHat Linux. The use of the Linux for PRISM offers enhanced performance and flexibility while providing stability and security against viruses and intruders inherent with Windows based systems. The following competitive advantages and features of the ACS PRISM SCADA solution clearly distinguishes ACS as the best qualified vendor for your SCADA System: 1. System Architecture. The ACS PRISM design seamlessly integrates the SCADA, OMS, and DMS and EMS applications into a single platform with a common interface and code base to support monitoring, analysis, control, planning and optimization of the distribution network. Our architecture is designed for the easy addition of OMS, DMS and other advanced applications that Consumers Power, Inc. may be interested in pursuing in the future. This is a key differentiator when compared to other solutions on the market. ACS supports and encourages the integration of other supporting systems such as AMR, GIS, OMS, MDM, IVR, AVL, etc. Viunu: 8,2(09 iflldiunsoni U ➢IIJlh6i:ls U; D111uunuussii01111 " gi:h I 6 'A 0AWAV C1 2. Advanced Distribution Applications. As your electric system and automation plans evolve, the SCADA platform can be expanded with proven distribution applications. ACS first delivered FDIR in a DMS system back in 2002 to Taiwan Power. This transformed operations and restored outages within seconds rather than hours. We capitalized on this groundbreaking experience by developing further applications and a real-time outage management, featuring high- performance graphics and a database shared with distribution SCADA. Some of the distribution management and automation solutions we have developed include: 1. Loss Minimization: To improve power quality through the centralized automation of any optimized capacitor bank control applications. 2. Integrated Volt Var Control (IVVC): To manage demand and smooth system voltage through the optimized control of capacitors, regulators and tap change transformers. 3. Optimal Switching: To reduce operating risk of the network by preventing unnecessary outages and damage resulting from inadvertent and unexpected switching. 4. Fault Detection, Isolation, Restoration (FDIR): Used to automatically detect and isolate faults, either using automated switches, manual switches, or both. In addition, the software will provide a downstream restoration switching plan if one is available. 5. Three Phase Unbalanced Load Flow Analysis: Allows operators to analyze the effects of proposed switching changes on the network. The solution will identify and quantify any parameter violations that would result. 6. Distributed Generation and Distributed Energy Resources: Allows optimal management and control of DER assets while maintaining the integrity of the network. 7. Short Circuit Analysis: Provides network wide analysis of current protection schemes as they relate to existing topology. 8. Intelligent Switch Order: Provides the ability to develop switching plans for necessary field work that minimizes customer impact. For example, the software can develop a switching plan to isolate a substation with no loss of customers and no system violations. 9. Capacitor Bank Placement: Works with our Simulator based upon historical operational data to provide the optimal location for capacitor banks on the network. iiunu: 8,2(09 iflldiunsoni U ➢IIJlh6i:ls V; D111uunuussii01111 „,' 'A 0AWAV C1 3. System Interfaces Every utility has different business goals and requirements for different OT and IT system to exchange data. ACS provides several standard API's to interface to other systems. ACS is a log time user of Multispeak and other interfaces mechanism such as ICCP and SOA / web services. DDS is now native within PRISM; this is the result of an accelerated roadmap with Indra and offers the ability to incorporate PRSIM in a distributed architecture with the highest level of interoperability. Furthermore, the utility practice across Indra is well versed at Enterprise integration utilizing a variety of ESB technologies. 4. NERC-CIP Security. The reliability and security of our customers' PRISM systems is of paramount importance to ACS. We are committed to providing you with the highest level of support and service expertise to keep your system safe and secure. Advanced Control Systems takes cyber security, emerging threats and the applicable industry standards very seriously. A Critical Infrastructure Protection (CIP) group within ACS is charged with addressing the issues faced by our customers in this area and helping to ensure that every delivered system is as secure. As part of our ongoing commitment to support our customer security efforts, ACS can offer: • ACS evaluation of the customer system to disable and/or remove all unnecessary ports and services. • System patch management on a monthly or quarterly basis. • Malware/antivirus software with updates to the definitions system wide performed during the monthly/quarterly patch management service. • Work with the customer to establish proper user account management controls, including role -based user accounts for permissions. • Work with the customer to set up and establish password enforcement which includes Password strength enforcement and password aging. • Optional system host -based intrusion detection software, with updates to the definitions system wide during the monthly patch management service. • NERC CIP assessments can be performed through ACS partners. 5. Customer Support. ACS provides the best Support and Training of any vendor in our industry. Our Customer Support group located at our headquarters in Norcross, Georgia includes degreed engineers who are dedicated to Customer Support and Training. All customer support calls come in directly to our Help Desk 800 number and are answered 8 a.m. to 8 p.m., or, for customers requiring 24 X 7 support, by the on -call engineer after hours. Additionally, customers can submit cases via the Salesforce customer portal. The team uses the Salesforce CRM to manage and track all cases. Each Help Desk call is logged and is tracked every step of the way until it is satisfactorily closed. Records of all calls, both open and closed are kept and stored and reported to the senior management team. Any system down call is given priority code 1 and is immediately routed to a Customer Support Engineer. Less critical calls that are informational requests are responded to within a maximum of 4 hours. Viunu: 8,2(09 iflldiunsoni U➢IIJlh6i:ls U;D111uunuussii01111 " gi:h I 8 'A OAWAW C1 6. Substation Controllers. Our automation product lines include a wide range of flexible and cost— effective substation, distribution and feeder automation solutions. Our NTX series of intelligent, high performance automation controllers, are available in pole -top and substation models sized for every application and includes a range designed to upgrade V party RTU that are no longer supported in a very cost-effective way as compared to a replacement. ° IIIII IIIII :IIIII: l[teIII'n.ole Useill:. Access ePRISM uses any network or dial —up connection, including the internet, to deliver mission —critical SCADA applications without loading special software on the client PC, allowing productivity from any location. No emulation software to bring specialized applications to otherwise incompatible display devices is required. It is enabled for secure socket layer (SSL) encryption; however, additional security measures, including corporate firewalls, routers using I filtering strategies, and VPN technologies, ensure a secure connection to perform the necessary SCADA operations remotely. ACS recommends that the PRISM node that hosts the ePRISM session has a minimum of 2 GB memory for session encryption and authentication. Viunu: 8,2(09 iflldiunsoni U ➢IIJlh6i:ls U; D111uunuussii01111 ° agh 19 'A OAWAW C1 00 . u .��.�.. ... ..uY Vr' ., , III .. . .. '; I I Isla III ��..I auil PRISM eAlarm provides the capability to send e-mail alerts for system events or critical alarms that require immediate attention. Notification may be provided for: a breaker lockout; a limit violation for an analog point; a control action by an operator; or any other system event or alarm condition within the PRISM database. You control the list of recipients for these e-mail alerts, configurable for each event type you define. In eAlarm, you specify what your utility considers to be a critical alarm or event. Selected points can be digital status or numeric telemetry. The application has the capability to define up to 20 e-mail addresses in the recipient list. The application supports grouping alarms/events on a pre -defined interval, schedules a script to prepare an e-mail message, and uses PRISM system resources to send the message to your company mail server. The PRISM system AOA capability is used to retrieve the alarms/events. Two modes of operation are provided: — Interval mode: in this mode, the system collects a group of alarm/ event messages that have occurred during the interval and passes the information to the mail server. A single e-mail may contain more than one alarm/event messages. — Default mode: when not configured for interval mode, eAlarm sends an e-mail for each individual alarm/event that you have specified. Each e-mail sent to a recipient contains only one alarm/event message. By default, the alarm/event e-mail notifications from eAlarm are formatted to include the same information that is displayed in the alarm zone of the PRISM operator interface window. You can filter system alarm/event messages to ensure that only the necessary information is contained in the e-mail text. Utilizing the PRISM system AOA capability, eAlarm may be configured to send notification to different sets of recipients for various types of system events. For example, substation crews may need to be notified only for events related to equipment within the substation, but not for events related to devices on the feeder. iiuuol� 18, ,YoU'n9 iflldiunsoni U ➢II'ullli6i:ls U; D11111lu ilussli01111 'A ,WAFAW CI . Scope o 1 ..°ull" M:IIIII IIIII IIIII'Illll M 1 PRISM Master Virtual Machine 1 Virtual Machine configured with: • 64 GB Memory • 1.2TB Storage 2 Network Equipment 1 ACS VPN Diagnostic Router 3 Optional eAlarm Proxy Virtual Machine 1 Virtual Machine configured with: Optional • 32 GB Memory • 1.2TB Storage 4 PRISM Software 1 PRISM Master Server -based License 1 DNPnet Network Communication Protocol — Single Node License 1 ePRISM Remote User Access for 10 Users 5 Operating System 1 Red Hat Enterprise Linux 6 Optional eAlarm Software 1 eAlarm Event Notification and Summary 1 Red Hat Enterprise Linux ilulnl::� 18, .`(U'nPil iflldilnsoni U ➢II'ullli6i:ls U;,D11111lll 111lssli011ll 'A OAWAW C1 7 ACS Factory Services Lot Services include: • Project Management • Creation of Database and Display for 4 Substations • Migration of Data into PRISM system • Creation of Gas Reports • PRISM Software and OS Installation and Configuration • ACS Factory Testing • Material Inventory and Control 8 ACS Onsite Engineering Services Lot ACS has included one week of onsite installation and configuration. Following this week, ACS will conduct one week of PRISM SCADA training. 9 Optional eAlarm Services Lot Services include: • Loading and Configuration of the eAlarm Software • Configuration of eAlarm Proxy Server „lillunl: 8,2(09 iflldiunsoni U ➢IIJlh6i:ls U;D111uunuussii01111 W gi:h I 12 'A ,WAWAW C1 PRISM SCADA System 1-2 System Hardware $1,022 4-5 System Software $16,325 7-8 ACS Project Services $36,128 Total Price $53,475 Option: eAlarm Event Notification and Summary 6 System Software $3,575 9 ACS Project Services $11,360 Total Price $14,935 All above pricing is based on standard ACS configuration and is defined under the following conditions: • Firm, in USD, for the validity of the Offer • All taxes are excluded from price • Prices quoted are F.O.B Norcross, GA • Limited to the Scope of Supply IIII[ lull- psd t ... s: llll:. Illll uul vu p 11 lull:].s The following assumptions have been made regarding this proposal. If any of these are incorrect, please notify ACS. • All field communication to the PRISM Master will be DNP3/IP. • The virtual environment is VMware ESXi Version 6 and HUC will be responsible for the maintenance of the virtual environment. • All existing SCADA data will be available in .csv file. • The equations and methodology for Gas Reports is available and will not need to be created. n9(3 22 :II !illy S II:) , Viunu: 8,2(09 iulldluuu.usoniU➢IIJlh6i:lsU;D111uunuussii01111 „' n; 'A 0AWAV C1 The terms and conditions governing this offer are set forth in Attachment A — ACS General Terms and Conditions of Sales. . ":�I:" � IIII[ .vul:vul.S I1" :Illlf � u1 �°vu vu � III'It ACS will invoice in accordance with the payment milestone(s) described below. Payments not received within this period will be subject to interest charges. Receipt of Order 0% 100% 0% ACS Hardware Order 100% 0% 0% Placement Installation of 0% 0% 40% Operating System Completion of In - House Factory 0% 0% 40% Acceptance Test Completion of Project or 90 Days After 0% 0% 20% System Delivery 5-:2, 6Sh hill ul� 'p hill IIIII:i. IIIII IIIII :IIIII IIIII: . Standard shipping within the continental US is typically 5-7 business days. A shipping & handling fee of $35 will be added to each small package shipment. No separate freight invoice will be submitted. Packages exceeding $35 freight charges will be billed at cost, or fixed pre - quoted cost if applicable. Charges for premium shipping (next day morning delivery, afternoon delivery, etc.) will be billed at cost. lliiuuu�� 18, 2( n9 iiulldliunsoni U ➢II'ullli6i:ls U; D111uunuussli0uu �:'° gi:h I 1°":1 Customer purchase orders need to include the ACS Offer Number, the ACS Terms of Payment (as stated in section 5.1 of offer), and the Customer's Billing and Shipping Information. All purchase orders should be sent to the address below. Advanced Control Systems, Inc. 2755 Northwoods Parkway Norcross, Georgia 30071 Attn: Order Entry Team FAX 01-770-448-0957 Email: ACSOrderEntryTeam@acspower.com 7 Vali di. . This Offer is valid for a period of 90 days from the date of this offer. The following points must be considered as explicitly excluded from the offer: Any equipment or service not explicitly mentioned in this offer Attachment A — ACS General Terms and Conditions of Sales Attachment B — ACS Software License Maintenance Agreement Attachment C — PRISM SCADA Overview lliiuuu�� 18, .'(U'n9 iiulldluuu.usoni U ➢II'ullli6i:ls U; D111uunuussli0uu �:'° gi:h I 1