[PAGE 1] BOARD OF PUBLIC WORKS DEPARTMENT OF UTILITIES March 8, 2017 4:15 P.M. Fremont Municipal Building, 2nd Floor Conference Room, 400 East Military, Fremont Nebraska __________________________________________________________________________ 1. Roll call. 2. Approve minutes of February 22, 2017. 3. Consider Accounts Payable – 1st half of March 2017. 4. Review Statement of Operations and Net Position for December 2016 (staff report). 5. * Consider approval of Brick Repair Bid – Lon D. Wright Power Plant (staff report). 6. * Consider insurance settlement on LDW Unit 8 Generator and Turbine claims (staff report). 7. * Consider approval of LDW Unit 8 Heater 4 Tube Bundle Replacement (staff report). 8. Investments (staff report). 9. General Manager Update (no board action is requested). a. Annual report – Dean Kavan b. Retail electric choice - Newton 10. Adjournment The agenda was posted at the Municipal Building on March 3, 2017. The agenda and enclosures are distributed to Board and posted on the City of Fremont’s website. The official current copy of the agenda is available at Municipal Building, 400 East Military, office of the General Manager. A copy of the Open Meeting Law is posted in the 2nd floor conference room for review by the public. The Board of Public Works reserves the right to adjust the order of items on this agenda. *items referred to City Council (if any) Page 1 of 39 [PAGE 2] CITY OF FREMONT BOARD OF PUBLIC WORKS FEBRUARY 22, 2017 - 4:15 P.M. A meeting of the Board of Public Works was held on February 22, 2017 at 4:15 p.m. in the 2nd floor meeting room at 400 East Military, Fremont, Nebraska. The meeting was preceded by publicized notice in the Fremont Tribune and the agenda displayed in the Municipal Building. The meeting was open to the public. A continually current copy of the agenda was available for public inspection at the office of the General Manger, Department of Utilities, 400 East Military. The agenda was distributed to the Board of Public Works on February 6, 2017 and posted, along with the supporting documents, on the City’s website. A copy of the open meeting law is posted continually for public inspection. ROLL CALL Roll call showed Board Members Behrens, Shelso, and Sawtelle, Vering, and Hoegemeyer present. 5 present, 0 absent. Others in attendance included Brian Newton, General Manager/Interim City Administrator; Troy Schaben, Asst. General Manager; Jody Sanders, Finance Dir.; Al Kasper, Dir. Engineering; John Hemschemeyer, Dir. HR; Keith Kontor, WWTP Supt.; and Dean Kavan, Stores Supervisor; Jeff Shanahan, Power Plant Superintendent; Mike Royuk, Electric Dist. Supt.; Jan Rise, Admin. Services; Kirk Hillrichs, Gas Sys. Supt.; Susan Jacobus, Council Member; Lottie Mitchell, Exec. Asst.; and Cecilia Harry, GFDC. APPROVE MINUTES Moved by Member Behrens and seconded by Member Vering to approve the minutes of the February 8, 2017 meeting. Motion carried 5-0. RECEIVE QUARTERLY REPORT BY CECILIA HARRY, GREATER FREMONT DEVELOPMENT COUNCIL Cecelia Harry, Executive Director of the Greater Fremont Development Council presented the 2016 fourth quarter report and answered questions regarding recent economic activities. Moved by Member Vering and seconded by Member Shelso to receive the quarterly report. Motion carried 5-0. CONSIDER ACCOUNTS PAYABLE – 2nd HALF OF FEBRUARY 2017 Sanders presented the report and answered questions about specific expenditures. It was moved by Member Shelso and seconded by Member Vering to approve accounts payable in the amount of $2,652,679.61. Motion carried 5-0. CONSIDER POWER PURCHASE AGREEMENT AMENDMENT (STAFF REPORT) Moved by Member Vering and seconded by Member Behrens to approve the Power Purchase Agreement Amendment. Newton explained several of the reasons for the amendment. Motion carried 5-0. CONSIDER ASSET MANAGEMENT AGREEMENT WITH BP CANADA ENERGY MARKETING CORP (STAFF REPORT) Moved by Member Behrens and seconded by Member Shelso to approve Asset Management Agreement. Newton presented information about the management services we require and how each bid addressed or exceeded our requirements. Motion carried 5-0. CONSIDER COLLECTION ACTIVITY REPORT (STAFF REPORT) The board received the report. Page 2 of 39 1 Agenda Item #2 [PAGE 3] CONSIDER TWO (2) OUT-OF-STATE TRAVEL REQUESTS FOR EMPMLOYEE TRAINING (STAFF REPORT) Moved by Member Vering and seconded by Member Hoegemeyer to approve the out-of- state travel request for the AEGIS Policy Holder’s Conference. Motion carried 5-0. Moved by Member Vering and seconded by Member Hoegemeyer to approve the out-of- state travel request for the APPA Engineering Operations Technical Conference. Motion carried 5-0. INVESTMENTS. Sanders presented the board with information on Department of Utility investments. Moved by Member Vering and seconded by Member Behrens to accept and receive the report. Motion carried 5-0. GENERAL MANAGER UPDATE (NO BOARD ACTION IS REQUESTED). Hillrichs presented the Gas Department Annual Report. Newton reported information regarding Legislative bills LB 557 and LB 660 and gave a Community Solar Farm update. ADJOURNMENT Moved by Member Vering and seconded by Member Shelso the motion to adjourn the meeting at 5:08 p.m. Motion carried 5-0. _____________________________ ______________________________ Allen Sawtelle, Chairman Toni Vering, Secretary _____________________ _____________________ ____________________ Dennis Behrens David Shelso Erik Hoegemeyer Page 3 of 39 2 Agenda Item #2 [PAGE 4] PREPARED 02/28/2017 10:11:49 EXPENDITURE APPROVAL LIST PROGRAM: GM339L REPORT PARAMETER SELECTIONS EAL DESCRIPTION: EAL: 02282017 ANDERSEND PAYMENT TYPES Checks . . . . . . . . . . . . . . . . . . . . . Y EFTs . . . . . . . . . . . . . . . . . . . . . . Y ePayables . . . . . . . . . . . . . . . . . . . Y VOUCHER SELECTION CRITERIA Voucher/discount due date . . . . . . . . . . . 02/28/2017 All banks . . . . . . . . . . . . . . . . . . . A REPORT SEQUENCE OPTIONS: Vendor . . . . . . . . . . . . . . . . . . . . . X One vendor per page? (Y,N) . . . . . . . . . . N Bank/Vendor . . . . . . . . . . . . . . . . . . One vendor per page? (Y,N) . . . . . . . . . . N Fund/Dept/Div . . . . . . . . . . . . . . . . . Validate cash on hand? (Y,N) . . . . . . . . . N Fund/Dept/Div/Element/Obj . . . . . . . . . . . Validate cash on hand? (Y,N) . . . . . . . . . N Proj/Fund/Dept/Div/Elm/Obj . . . . . . . . . . . This report is by: Vendor Process by bank code? (Y,N) . . . . . . . . . . Y Print reports in vendor name sequence? (Y,N) . . Y Calendar year for 1099 withholding . . . . . . . 2017 Disbursement year/per . . . . . . . . . . . . . 2017/05 Payment date . . . . . . . . . . . . . . . . . . 02/28/2017 Page 4 of 39 Agenda Item #3 [PAGE 5] PREPARED 02/28/2017,10:11:49 EXPENDITURE APPROVAL LIST PAGE 1 PROGRAM: GM339L AS OF: 02/28/2017 PAYMENT DATE: 02/28/2017 DEPARTMENT OF UTILITIES ------------------------------------------------------------------------------------------------------------------------------------ VEND NO SEQ# VENDOR NAME EFT, EPAY OR INVOICE VOUCHER P.O. BNK CHECK/DUE ACCOUNT ITEM CHECK HAND-ISSUED NO NO NO DATE NO DESCRIPTION AMOUNT AMOUNT ------------------------------------------------------------------------------------------------------------------------------------ 9999999 00 FELDHAUS, LEE J 000069997 UT 00 02/24/2017 051-0000-143.00-00 MANUAL DEPOSIT REFUND 200.00 VENDOR TOTAL * 200.00 9999999 00 FLAMME, LARRY 000028885 UT 00 02/22/2017 051-0000-143.00-00 MANUAL CHECK 121.27 VENDOR TOTAL * 121.27 9999999 00 LOPEZ, ALBERTO 000041751 UT 00 02/23/2017 051-0000-143.00-00 FINAL BILL REFUND 102.06 VENDOR TOTAL * 102.06 9999999 00 MCCABE-REYNOLDS, RENAE L 000047555 UT 00 02/23/2017 051-0000-143.00-00 FINAL BILL REFUND .71 VENDOR TOTAL * .71 9999999 00 SMUTZ, KATHLEEN 000019819 UT 00 02/23/2017 051-0000-143.00-00 FINAL BILL REFUND .42 VENDOR TOTAL * .42 0003109 00 UPS 5E9752087 00 02/28/2017 051-5001-940.60-79 2/25/17 Serv Chrg Share 6.45 5E9752087 00 02/28/2017 051-5001-917.60-79 2/25/17 Serv Chrg Share 6.45 5E9752087 00 02/28/2017 051-5001-917.60-79 City/Parks-Ditch Witch 8.51 5E9752087 00 02/28/2017 051-5205-580.60-79 Mid American Signal Inc 37.76 5E9752087 00 02/28/2017 053-6105-502.50-23 Water Samples 35.93 VENDOR TOTAL * 95.10 TOTAL EXPENDITURES **** 519.56 GRAND TOTAL ******************** 519.56 Page 5 of 39 Agenda Item #3 [PAGE 6] (cid:7)(cid:17)(cid:13)(cid:1)(cid:8)(cid:5)(cid:18)(cid:17)(cid:15)(cid:5)(cid:14)(cid:11) (cid:14)(cid:12)(cid:5)(cid:4)(cid:9)(cid:4)(cid:5)(cid:4)(cid:17)(cid:20) (cid:17)(cid:9)(cid:17)(cid:19)(cid:5)(cid:8)(cid:11)(cid:15)(cid:4)(cid:19)(cid:14)(cid:3)(cid:4)(cid:5)(cid:6)(cid:7)(cid:8)(cid:1)(cid:3)(cid:1)(cid:9)(cid:14)(cid:9)(cid:4)(cid:20)(cid:5) (cid:11)(cid:8)(cid:14)#(cid:11)(cid:1)(cid:8)(cid:7)(cid:14)(cid:11) (cid:14)(cid:13)(cid:12)#(cid:9)(cid:4)(cid:19)(cid:14)(cid:3)(cid:11)(cid:8)(cid:31)(cid:20)(cid:14)(cid:18)(cid:17)(cid:17)(cid:5)(cid:4)(cid:15)(cid:10)$(cid:14)(cid:30)(cid:25)%(cid:25)(cid:26)(cid:27) (cid:1)(cid:2) (cid:3)(cid:4)(cid:5)(cid:6)(cid:7)(cid:8)(cid:1)(cid:3)(cid:1)(cid:9) (cid:3)(cid:4)(cid:5)(cid:6)(cid:7)(cid:8)(cid:1)(cid:3)(cid:1)(cid:9) (cid:10)(cid:8)(cid:11)(cid:12)(cid:13)(cid:14)(cid:15)(cid:11) (cid:16)(cid:17)(cid:15)(cid:7)(cid:11)(cid:8)(cid:14)(cid:15)(cid:1)(cid:18)(cid:17) (cid:7)(cid:1)(cid:5)(cid:17) (cid:1)(cid:19)(cid:19)(cid:11)(cid:12)(cid:15)(cid:5)(cid:14)(cid:15)(cid:11) (cid:4)(cid:5)(cid:17)(cid:18)(cid:14)(cid:7)(cid:17)(cid:20)(cid:19)(cid:8)(cid:4)(cid:13)(cid:5)(cid:4)(cid:11)(cid:15) (cid:1)(cid:18)(cid:11)(cid:12)(cid:15)(cid:5) (cid:21)(cid:22)(cid:23)(cid:21) (cid:16)(cid:1)(cid:15)(cid:5)(cid:4)(cid:16) (cid:22)(cid:24)(cid:25)(cid:24)(cid:24)(cid:25)(cid:26)(cid:27) (cid:22)(cid:23)(cid:26)(cid:28)(cid:23)(cid:22)(cid:22)(cid:26)(cid:28)(cid:29)(cid:22)(cid:30)(cid:28)(cid:21)(cid:22)(cid:28)(cid:27)(cid:27) (cid:31)(cid:4)(cid:11)(cid:20)(cid:31)(cid:14)(cid:19)(cid:8)(cid:17)(cid:7)(cid:4)(cid:5)(cid:14)(cid:19)(cid:1)(cid:8)(cid:7)(cid:14) (cid:17)(cid:17)(cid:20) (cid:26)(cid:24)!(cid:24)(cid:22) (cid:5)(cid:11)(cid:5)(cid:1)(cid:9)(cid:14)(cid:17)"(cid:13)(cid:17)(cid:15)(cid:7)(cid:4)(cid:5)(cid:12)(cid:8)(cid:17)(cid:20) (cid:26)(cid:24)!(cid:24)(cid:22) Page 6 of 39 (cid:18)$&(cid:1)''()*+,(cid:14)(cid:13)-.-/01&(cid:7)(cid:12)&(cid:7)(cid:12)(cid:14)(cid:17)01'+2(*3'(cid:14)(cid:3)3+452-6-0,&(cid:30)(cid:28)%(cid:28)(cid:26)(cid:27) Agenda Item #3 [PAGE 7] PREPARED 03/02/2017 13:05:02 EXPENDITURE APPROVAL LIST PROGRAM: GM339L REPORT PARAMETER SELECTIONS EAL DESCRIPTION: EAL: 03022017 ANDERSEND PAYMENT TYPES Checks . . . . . . . . . . . . . . . . . . . . . Y EFTs . . . . . . . . . . . . . . . . . . . . . . Y ePayables . . . . . . . . . . . . . . . . . . . Y VOUCHER SELECTION CRITERIA Voucher/discount due date . . . . . . . . . . . 03/09/2017 All banks . . . . . . . . . . . . . . . . . . . A REPORT SEQUENCE OPTIONS: Vendor . . . . . . . . . . . . . . . . . . . . . X One vendor per page? (Y,N) . . . . . . . . . . N Bank/Vendor . . . . . . . . . . . . . . . . . . One vendor per page? (Y,N) . . . . . . . . . . N Fund/Dept/Div . . . . . . . . . . . . . . . . . Validate cash on hand? (Y,N) . . . . . . . . . N Fund/Dept/Div/Element/Obj . . . . . . . . . . . Validate cash on hand? (Y,N) . . . . . . . . . N Proj/Fund/Dept/Div/Elm/Obj . . . . . . . . . . . This report is by: Vendor Process by bank code? (Y,N) . . . . . . . . . . Y Print reports in vendor name sequence? (Y,N) . . Y Calendar year for 1099 withholding . . . . . . . 2017 Disbursement year/per . . . . . . . . . . . . . 2017/06 Payment date . . . . . . . . . . . . . . . . . . 03/09/2017 Page 7 of 39 Agenda Item #3 [PAGE 8] PREPARED 03/02/2017,13:05:02 EXPENDITURE APPROVAL LIST PAGE 1 PROGRAM: GM339L AS OF: 03/09/2017 PAYMENT DATE: 03/09/2017 DEPARTMENT OF UTILITIES ------------------------------------------------------------------------------------------------------------------------------------ VEND NO SEQ# VENDOR NAME EFT, EPAY OR INVOICE VOUCHER P.O. BNK CHECK/DUE ACCOUNT ITEM CHECK HAND-ISSUED NO NO NO DATE NO DESCRIPTION AMOUNT AMOUNT ------------------------------------------------------------------------------------------------------------------------------------ 0004920 00 ADVANCED ELECTRICAL AND MOTOR AEM-16-3498 PI2766 00 03/09/2017 051-5105-502.60-61 PO NUM 045237 EFT: 1,379.45 AEM-16-3498 PI2767 00 03/09/2017 051-5105-502.60-79 PO NUM 045237 EFT: 247.91 VENDOR TOTAL * .00 1,627.36 0004604 00 AEROMET ENGINEERING INC 22566RS PI2671 00 03/09/2017 051-5105-502.60-62 PO NUM 045150 240.00 VENDOR TOTAL * 240.00 0004276 00 AIRGAS USA LLC 9060263380 PI2641 00 03/09/2017 051-5105-502.50-35 PO NUM 043494 EFT: 349.98 9060356403 PI2658 00 03/09/2017 051-5105-502.50-35 PO NUM 044974 EFT: 242.60 9060505326 PI2774 00 03/09/2017 051-5105-502.50-35 PO NUM 043494 EFT: 239.46 VENDOR TOTAL * .00 832.04 0000965 00 ALL SYSTEMS LLC 72035 PI2622 00 03/09/2017 051-5105-502.50-35 PO NUM 045107 525.37 VENDOR TOTAL * 525.37 0004585 00 AMERICAN BROADBAND INTERNET 51262 0317 PI2754 00 03/09/2017 051-5001-922.50-53 PO NUM 044176 195.00 VENDOR TOTAL * 195.00 0000983 00 ARPS GRAVEL & CONCRETE INC 16896 PI2843 00 03/09/2017 051-5205-580.50-35 PO NUM 045215 304.68 VENDOR TOTAL * 304.68 0002531 00 BABCOCK & WILCOX COMPANY BA60335142 PI2797 00 03/09/2017 051-5105-502.60-79 PO NUM 044698 EFT: 226.16 VENDOR TOTAL * .00 226.16 0004999 00 BARONE INC 300313536 PI2850 00 03/09/2017 051-5001-932.60-61 PO NUM 045260 329.03 VENDOR TOTAL * 329.03 0003660 00 BAUER BUILT INC 880050392 PI2776 00 03/09/2017 051-5105-502.50-35 PO NUM 043955 123.38 VENDOR TOTAL * 123.38 0004380 00 BENETECH INC 107786 PI2757 00 03/09/2017 051-5105-502.50-35 PO NUM 045120 15,402.00 VENDOR TOTAL * 15,402.00 0004021 00 BINMASTER / GARNER INDUSTRIES 213843 PI2709 00 03/09/2017 051-0000-153.00-00 PO NUM 045177 519.19 213843 PI2725 00 03/09/2017 051-5105-502.50-35 PO NUM 045177 7.19 VENDOR TOTAL * 526.38 0003545 00 BOMGAARS SUPPLY INC 16211874 PI2739 00 03/09/2017 051-5001-940.50-35 PO NUM 043954 32.30 Page 8 of 39 Agenda Item #3 [PAGE 9] PREPARED 03/02/2017,13:05:02 EXPENDITURE APPROVAL LIST PAGE 2 PROGRAM: GM339L AS OF: 03/09/2017 PAYMENT DATE: 03/09/2017 DEPARTMENT OF UTILITIES ------------------------------------------------------------------------------------------------------------------------------------ VEND NO SEQ# VENDOR NAME EFT, EPAY OR INVOICE VOUCHER P.O. BNK CHECK/DUE ACCOUNT ITEM CHECK HAND-ISSUED NO NO NO DATE NO DESCRIPTION AMOUNT AMOUNT ------------------------------------------------------------------------------------------------------------------------------------ 0003545 00 BOMGAARS SUPPLY INC 16210686 PI2597 00 03/09/2017 051-5105-502.50-35 PO NUM 043954 26.91 16211853 PI2762 00 03/09/2017 051-5205-580.50-48 PO NUM 045201 641.98 16210421 PI2596 00 03/09/2017 055-7105-502.50-48 PO NUM 043954 39.94 16212491 PI2740 00 03/09/2017 055-7105-512.50-35 PO NUM 043954 71.88 16213008 PI2775 00 03/09/2017 055-7105-512.50-35 PO NUM 043954 66.96 VENDOR TOTAL * 879.97 0004518 00 CAPPEL AUTO SUPPLY INC 207507 PI2747 00 03/09/2017 051-5001-940.50-35 PO NUM 043990 67.09 207562 PI2748 00 03/09/2017 051-5001-940.50-35 PO NUM 043990 203.02 207944 PI2751 00 03/09/2017 051-5001-940.50-35 PO NUM 043990 239.81 208372 PI2828 00 03/09/2017 051-5001-940.50-35 PO NUM 043990 73.32 207707 PI2749 00 03/09/2017 051-5205-580.50-48 PO NUM 043990 63.98 207795 PI2750 00 03/09/2017 051-5205-580.50-48 PO NUM 043990 83.44 208136 PI2752 00 03/09/2017 051-5205-580.50-48 PO NUM 043990 38.50 208140 PI2753 00 03/09/2017 051-5205-580.50-48 PO NUM 043990 35.31 207786 PI2611 00 03/09/2017 055-7105-512.50-35 PO NUM 043990 107.84 VENDOR TOTAL * 912.31 0004144 00 CARPENTER PAPER COMPANY 272724-00 PI2593 00 03/09/2017 051-0000-154.00-00 PO NUM 045062 125.55 272776-00 PI2708 00 03/09/2017 051-0000-154.00-00 PO NUM 045138 1,743.03 VENDOR TOTAL * 1,868.58 0003817 00 CED AUTOMATION OMAHA 497641/497788 PI2618 00 03/09/2017 055-7105-512.50-35 PO NUM 044918 5,024.52 VENDOR TOTAL * 5,024.52 0000584 00 CEI MAR 17 WC 00 03/09/2017 051-5001-919.20-29 Mar 2017 Worker Comp EFT: 25,000.00 VENDOR TOTAL * .00 25,000.00 0004615 00 CENTRAL PLAINS ENERGY PROJECT*WIRE* 021712A197 00 03/09/2017 057-8205-807.50-02 Feb'17 Dth 273,663.60 VENDOR TOTAL * 273,663.60 0002951 00 CENTRAL STATES GROUP 1311274-00 PI2595 00 03/09/2017 051-0000-153.00-00 PO NUM 045178 219.88 1311275-00 PI2710 00 03/09/2017 051-0000-153.00-00 PO NUM 045178 426.02 1311182-00 PI2726 00 03/09/2017 051-5105-502.50-35 PO NUM 045195 10.55 1311182-00 PI2727 00 03/09/2017 051-5105-502.60-79 PO NUM 045195 20.37 VENDOR TOTAL * 676.82 0002675 00 CENTURYLINK 4027272600 0217PI2650 00 03/09/2017 051-5001-922.50-53 PO NUM 043996 48.12 4027272606 0217PI2651 00 03/09/2017 051-5001-922.50-53 PO NUM 043996 408.72 4027272654 0217PI2652 00 03/09/2017 051-5001-922.50-53 PO NUM 043996 48.48 VENDOR TOTAL * 505.32 0003736 00 CLEAN HARBORS ENVIRON SERVICES INC Page 9 of 39 Agenda Item #3 [PAGE 10] PREPARED 03/02/2017,13:05:02 EXPENDITURE APPROVAL LIST PAGE 3 PROGRAM: GM339L AS OF: 03/09/2017 PAYMENT DATE: 03/09/2017 DEPARTMENT OF UTILITIES ------------------------------------------------------------------------------------------------------------------------------------ VEND NO SEQ# VENDOR NAME EFT, EPAY OR INVOICE VOUCHER P.O. BNK CHECK/DUE ACCOUNT ITEM CHECK HAND-ISSUED NO NO NO DATE NO DESCRIPTION AMOUNT AMOUNT ------------------------------------------------------------------------------------------------------------------------------------ 0003736 00 CLEAN HARBORS ENVIRON SERVICES INC 1001661516 PI2755 00 03/09/2017 051-5205-580.60-61 PO NUM 044575 1,172.75 VENDOR TOTAL * 1,172.75 0004524 00 CLOUD PEAK ENERGY RESOURCES *WIRE* ACC-17-0225 00 03/09/2017 051-0000-152.00-00 2/25/17 tons 174,983.49 VENDOR TOTAL * 174,983.49 0003615 00 COLE PAPERS INC 9289109 PI2679 00 03/09/2017 051-0000-154.00-00 PO NUM 045128 EFT: 1,359.11 VENDOR TOTAL * .00 1,359.11 0004561 00 COPY SHOP 7745 PI2841 00 03/09/2017 051-5001-920.50-40 PO NUM 045057 134.82 VENDOR TOTAL * 134.82 0001671 00 COSGRAVE COMPANY 6043828-IN PI2624 00 03/09/2017 051-5001-940.50-35 PO NUM 045131 136.96 6043828-IN PI2625 00 03/09/2017 051-5001-940.60-79 PO NUM 045131 10.86 VENDOR TOTAL * 147.82 0001041 00 CRESCENT ELECTRIC SUPPLY CO (OMAHA) S503159982-001 PI2737 00 03/09/2017 051-0000-154.00-00 PO NUM 045121 340.98 VENDOR TOTAL * 340.98 0004480 00 CSI SOUTH SIDE PRESS 24224 PI2621 00 03/09/2017 051-5001-903.50-31 PO NUM 045082 1,108.52 VENDOR TOTAL * 1,108.52 0003843 00 DAKOTA SUPPLY GROUP/ HYDRO METERING C835089 PI2769 00 03/09/2017 057-0000-154.00-00 PO NUM 044866 EFT: 7,361.94 VENDOR TOTAL * .00 7,361.94 0003050 00 DEPT OF HEALTH & HUMAN SERVICES 022217 PI2811 00 03/09/2017 053-6205-583.60-62 PO NUM 045247 178.00 VENDOR TOTAL * 178.00 0002897 00 DIERS INC 6005971 PI2631 00 03/09/2017 051-5205-580.50-48 PO NUM 045192 EFT: 114.37 6005971 PI2632 00 03/09/2017 051-5205-580.60-61 PO NUM 045192 EFT: 296.41 VENDOR TOTAL * .00 410.78 0001313 00 DILLON CHEVROLET FREMONT INC, SID 195031 PI2777 00 03/09/2017 055-7105-512.50-35 PO NUM 043959 16.17 1TCS147198 PI2815 00 03/09/2017 055-7205-583.60-61 PO NUM 043959 35.00 VENDOR TOTAL * 51.17 0003638 00 DODGE COUNTY CLERK 2017 BIOSLD FEEPI2763 00 03/09/2017 055-7105-502.60-61 PO NUM 045222 10,000.00 VENDOR TOTAL * 10,000.00 0001072 00 DODGE COUNTY TREASURER Page 10 of 39 Agenda Item #3 [PAGE 11] PREPARED 03/02/2017,13:05:02 EXPENDITURE APPROVAL LIST PAGE 4 PROGRAM: GM339L AS OF: 03/09/2017 PAYMENT DATE: 03/09/2017 DEPARTMENT OF UTILITIES ------------------------------------------------------------------------------------------------------------------------------------ VEND NO SEQ# VENDOR NAME EFT, EPAY OR INVOICE VOUCHER P.O. BNK CHECK/DUE ACCOUNT ITEM CHECK HAND-ISSUED NO NO NO DATE NO DESCRIPTION AMOUNT AMOUNT ------------------------------------------------------------------------------------------------------------------------------------ 0001072 00 DODGE COUNTY TREASURER 1509206 '17 RAM 00 03/09/2017 051-5001-950.80-50 Tax/Title'17 RAM 1500-Eng 1,853.34 VENDOR TOTAL * 1,853.34 0003321 00 DOUGLAS COUNTY TREASURER/LANDFILL 77731 PI2756 00 03/09/2017 051-5105-502.50-49 PO NUM 044584 10,912.45 VENDOR TOTAL * 10,912.45 0003091 00 DUTTON-LAINSON CO S88490-2 PI2592 00 03/09/2017 051-0000-154.00-00 PO NUM 044295 EFT: 399.92 752035-3 PI2634 00 03/09/2017 051-0000-154.00-00 PO NUM 044854 EFT: 482.79 S89446-1 PI2705 00 03/09/2017 051-0000-154.00-00 PO NUM 044614 EFT: 571.21 S90357-1 PI2706 00 03/09/2017 051-0000-154.00-00 PO NUM 044854 EFT: 158.90 S90046-1 PI2768 00 03/09/2017 051-0000-154.00-00 PO NUM 044854 EFT: 11,480.71 VENDOR TOTAL * .00 13,093.53 0001444 00 ELECTRICAL ENGINEERING & EQUIPMENT 4988154-00 PI2842 00 03/09/2017 051-5205-580.50-35 PO NUM 045214 EFT: 121.13 VENDOR TOTAL * .00 121.13 0004551 00 ELEMETAL FABRICATION LLC 21957 PI2686 00 03/09/2017 051-5105-502.50-35 PO NUM 043975 243.96 21887 PI2695 00 03/09/2017 051-5105-502.50-35 PO NUM 045050 1,039.96 21918 PI2745 00 03/09/2017 055-7105-502.50-48 PO NUM 043975 115.75 VENDOR TOTAL * 1,399.67 0003836 00 ENVIRONMENTAL RESOURCE ASSOCIATES 1-68KK53 PI2839 00 03/09/2017 051-5105-502.60-61 PO NUM 044937 EFT: 204.00 1-68KK53 PI2840 00 03/09/2017 051-5105-502.60-79 PO NUM 044937 EFT: 38.64 VENDOR TOTAL * .00 242.64 0002050 00 FASTENAL CO NEFRE143857 PI2680 00 03/09/2017 051-0000-154.00-00 PO NUM 045139 EFT: 572.28 NEFRE144057 PI2702 00 03/09/2017 051-5001-940.50-35 PO NUM 045167 EFT: 92.89 NEFRE143944 PI2598 00 03/09/2017 051-5105-502.50-35 PO NUM 043960 EFT: 108.98 NEFRE144061 PI2683 00 03/09/2017 051-5105-502.50-35 PO NUM 043960 EFT: 6.61 NEFRE144128 PI2778 00 03/09/2017 051-5105-502.50-35 PO NUM 043960 EFT: 35.70 VENDOR TOTAL * .00 816.46 0001729 00 FCX PERFORMANCE INC 3986718 PI2594 00 03/09/2017 051-0000-153.00-00 PO NUM 045111 1,687.79 VENDOR TOTAL * 1,687.79 0002830 00 FISHER SCIENTIFIC CO LLC 1207369 PI2845 00 03/09/2017 051-5105-502.50-35 PO NUM 045217 460.50 1207369 PI2846 00 03/09/2017 051-5105-502.60-79 PO NUM 045217 21.82 VENDOR TOTAL * 482.32 0002884 00 FREMONT AREA CHAMBER 20067 PI2630 00 03/09/2017 051-5001-919.60-65 PO NUM 045174 300.00 Page 11 of 39 Agenda Item #3 [PAGE 12] PREPARED 03/02/2017,13:05:02 EXPENDITURE APPROVAL LIST PAGE 5 PROGRAM: GM339L AS OF: 03/09/2017 PAYMENT DATE: 03/09/2017 DEPARTMENT OF UTILITIES ------------------------------------------------------------------------------------------------------------------------------------ VEND NO SEQ# VENDOR NAME EFT, EPAY OR INVOICE VOUCHER P.O. BNK CHECK/DUE ACCOUNT ITEM CHECK HAND-ISSUED NO NO NO DATE NO DESCRIPTION AMOUNT AMOUNT ------------------------------------------------------------------------------------------------------------------------------------ 0002884 00 FREMONT AREA CHAMBER VENDOR TOTAL * 300.00 0003488 00 FREMONT HEALTH CLINIC IM364763 012317PI2659 00 03/09/2017 055-7205-583.60-61 PO NUM 045014 178.42 VENDOR TOTAL * 178.42 0001124 00 FREMONT PRINTING CO 15100 PI2670 00 03/09/2017 051-5001-903.50-40 PO NUM 045144 365.94 VENDOR TOTAL * 365.94 0002924 00 FREMONT WASTE TRANSFER 525052 00 03/09/2017 051-5105-502.50-49 5.00 VENDOR TOTAL * 5.00 0001132 00 FREMONT WINNELSON CO 300696 00 PI2816 00 03/09/2017 051-5105-502.50-35 PO NUM 043961 39.93 VENDOR TOTAL * 39.93 0000247 00 GEXPRO S116090696-001 PI2773 00 03/09/2017 051-0000-155.00-00 PO NUM 045151 409.63 VENDOR TOTAL * 409.63 0001445 00 GRAYBAR ELECTRIC CO 989998394 PI2735 00 03/09/2017 051-0000-156.00-00 PO NUM 044475 6,712.00 990038129 PI2738 00 03/09/2017 051-0000-154.00-00 PO NUM 045213 753.35 VENDOR TOTAL * 7,465.35 0004707 00 GREAT PLAINS COMMUNICATIONS INC 4020010078 0217PI2612 00 03/09/2017 051-5001-922.50-53 PO NUM 044192 149.00 4020010078 0217PI2613 00 03/09/2017 051-5001-922.60-65 PO NUM 044192 500.00 4020010078 0217PI2614 00 03/09/2017 055-7105-502.60-76 PO NUM 044192 229.00 VENDOR TOTAL * 878.00 0003155 00 HACH COMPANY 10313828 PI2619 00 03/09/2017 055-7105-502.50-52 PO NUM 045000 201.00 VENDOR TOTAL * 201.00 0003324 00 HAMPTON INN KEARNEY 270078 PI2620 00 03/09/2017 053-6205-583.60-62 PO NUM 045021 251.22 VENDOR TOTAL * 251.22 0004419 00 HANSEN TIRE LLC 17969 PI2605 00 03/09/2017 051-5205-580.50-48 PO NUM 043963 1.58 17969 PI2606 00 03/09/2017 051-5205-580.60-61 PO NUM 043963 15.00 17974 PI2607 00 03/09/2017 051-5205-580.50-48 PO NUM 043963 17.42 17974 PI2608 00 03/09/2017 051-5205-580.60-61 PO NUM 043963 213.75 17935 PI2626 00 03/09/2017 051-5205-580.50-48 PO NUM 045168 74.02 17935 PI2627 00 03/09/2017 051-5205-580.60-61 PO NUM 045168 255.00 17973 PI2628 00 03/09/2017 051-5205-580.50-48 PO NUM 045173 203.60 Page 12 of 39 Agenda Item #3 [PAGE 13] PREPARED 03/02/2017,13:05:02 EXPENDITURE APPROVAL LIST PAGE 6 PROGRAM: GM339L AS OF: 03/09/2017 PAYMENT DATE: 03/09/2017 DEPARTMENT OF UTILITIES ------------------------------------------------------------------------------------------------------------------------------------ VEND NO SEQ# VENDOR NAME EFT, EPAY OR INVOICE VOUCHER P.O. BNK CHECK/DUE ACCOUNT ITEM CHECK HAND-ISSUED NO NO NO DATE NO DESCRIPTION AMOUNT AMOUNT ------------------------------------------------------------------------------------------------------------------------------------ 0004419 00 HANSEN TIRE LLC 17973 PI2629 00 03/09/2017 051-5205-580.60-61 PO NUM 045173 277.50 18072 PI2817 00 03/09/2017 051-5205-580.60-61 PO NUM 043963 40.00 17961 PI2599 00 03/09/2017 053-6205-583.50-48 PO NUM 043963 1.58 17961 PI2600 00 03/09/2017 053-6205-583.60-61 PO NUM 043963 15.00 17962 PI2601 00 03/09/2017 053-6205-583.50-48 PO NUM 043963 1.58 17962 PI2602 00 03/09/2017 053-6205-583.60-61 PO NUM 043963 15.00 17968 PI2603 00 03/09/2017 053-6205-583.50-48 PO NUM 043963 1.58 17968 PI2604 00 03/09/2017 053-6205-583.60-61 PO NUM 043963 15.00 17975 PI2609 00 03/09/2017 053-6205-583.50-48 PO NUM 043963 2.64 17975 PI2610 00 03/09/2017 053-6205-583.60-61 PO NUM 043963 25.00 18032 PI2742 00 03/09/2017 053-6205-583.60-61 PO NUM 043963 65.00 VENDOR TOTAL * 1,240.25 0002794 00 HDR ENGINEERING INC 1200035400 PI2643 00 03/09/2017 051-5205-580.60-61 PO NUM 043611 4,928.98 VENDOR TOTAL * 4,928.98 0004849 00 HIBU INC 031391 2017 PI2792 00 03/09/2017 051-5001-903.60-78 PO NUM 044293 336.00 VENDOR TOTAL * 336.00 0003359 00 HONEYWELL INDUSTRY SOLUTIONS 5239191871 PI2771 00 03/09/2017 051-0000-153.00-00 PO NUM 045027 EFT: 7,666.00 VENDOR TOTAL * .00 7,666.00 0001868 00 HOTSY EQUIPMENT CO 274793 PI2716 00 03/09/2017 051-5001-940.50-35 PO NUM 043964 EFT: 19.26 274793 PI2717 00 03/09/2017 051-5001-940.60-61 PO NUM 043964 EFT: 160.50 VENDOR TOTAL * .00 179.76 0004062 00 HOUSTON & ASSOCIATES LLC 394 PI2615 00 03/09/2017 057-8205-870.60-61 PO NUM 044193 EFT: 2,500.00 VENDOR TOTAL * .00 2,500.00 0004188 00 HUNTEL COMMUNICATIONS 227193 PI2623 00 03/09/2017 051-5001-922.60-65 PO NUM 045125 1,559.00 227191 PI2698 00 03/09/2017 051-5001-922.50-42 PO NUM 045145 112.35 227191 PI2699 00 03/09/2017 051-5001-922.60-61 PO NUM 045145 29.43 227258 PI2783 00 03/09/2017 051-5001-922.60-61 PO NUM 043997 155.16 227284 PI2784 00 03/09/2017 051-5001-922.60-61 PO NUM 043997 117.70 VENDOR TOTAL * 1,973.64 0004599 00 IBT INC 6966270 PI2812 00 03/09/2017 051-0000-154.00-00 PO NUM 044796 EFT: 159.79 6966271 PI2813 00 03/09/2017 055-0000-154.00-00 PO NUM 045127 EFT: 234.90 VENDOR TOTAL * .00 394.69 0005011 00 IMPERIAL INDUSTRIES INC 10382 PI2616 00 03/09/2017 051-5105-502.50-35 PO NUM 044786 835.00 Page 13 of 39 Agenda Item #3 [PAGE 14] PREPARED 03/02/2017,13:05:02 EXPENDITURE APPROVAL LIST PAGE 7 PROGRAM: GM339L AS OF: 03/09/2017 PAYMENT DATE: 03/09/2017 DEPARTMENT OF UTILITIES ------------------------------------------------------------------------------------------------------------------------------------ VEND NO SEQ# VENDOR NAME EFT, EPAY OR INVOICE VOUCHER P.O. BNK CHECK/DUE ACCOUNT ITEM CHECK HAND-ISSUED NO NO NO DATE NO DESCRIPTION AMOUNT AMOUNT ------------------------------------------------------------------------------------------------------------------------------------ 0005011 00 IMPERIAL INDUSTRIES INC 10382 PI2617 00 03/09/2017 051-5105-502.60-79 PO NUM 044786 162.86 VENDOR TOTAL * 997.86 0004036 00 INDUSTRIAL DESIGN SOLUTIONS INC 1328 PI2682 00 03/09/2017 051-5105-502.60-61 PO NUM 042701 2,227.50 VENDOR TOTAL * 2,227.50 0003074 00 JACKSON SERVICES INC 20170209 PR0209 00 03/09/2017 051-0000-241.00-00 PAYROLL SUMMARY EFT: 199.73 20170223 PR0223 00 03/09/2017 051-0000-241.00-00 PAYROLL SUMMARY EFT: 194.96 567 - 022817 00 03/09/2017 051-5001-932.50-46 Feb Mats EFT: 14.98 567 - 022817 00 03/09/2017 051-5001-940.50-46 Feb Mops EFT: 4.72 567 - 022817 00 03/09/2017 051-5001-940.20-29 Feb Uniforms/Whse EFT: 69.18 1110 - 022817 00 03/09/2017 051-5001-932.50-46 Feb Mats/Mops/Towels EFT: 212.00 1110 - 022817 00 03/09/2017 051-5001-940.50-46 Feb Mats EFT: 507.23 567 - 022817 00 03/09/2017 051-5105-502.50-46 Feb Mops EFT: 84.77 567 - 022817 00 03/09/2017 051-5105-502.20-29 Feb Uniforms EFT: 1,035.87 1110 - 022817 00 03/09/2017 051-5105-502.50-46 Feb Mats EFT: 448.37 567 - 022817 00 03/09/2017 051-5205-580.20-29 Feb Uniforms/Elect Distr EFT: 1,523.13 567 - 022817 00 03/09/2017 051-5205-580.20-29 Feb Uniforms/Engineers EFT: 51.36 1110 - 022817 00 03/09/2017 053-6105-502.50-46 Feb Mats EFT: 25.76 567 - 022817 00 03/09/2017 053-6205-583.20-29 Feb Uniforms EFT: 298.48 567 - 022817 00 03/09/2017 055-7105-502.20-29 Feb Uniforms EFT: 146.84 1110 - 022817 00 03/09/2017 055-7105-502.50-46 Feb Mats/Mops EFT: 94.72 567 - 022817 00 03/09/2017 057-8205-870.20-29 Feb Uniforms EFT: 819.40 VENDOR TOTAL * .00 5,731.50 0004205 00 JCI INDUSTRIES INC 8135649 PI2638 00 03/09/2017 051-0000-153.00-00 PO NUM 045152 1,433.60 VENDOR TOTAL * 1,433.60 0003085 00 KELLY SUPPLY CO 11117640-0 PI2696 00 03/09/2017 051-5105-502.50-35 PO NUM 045113 EFT: 674.70 11117640-0 PI2697 00 03/09/2017 051-5105-502.60-79 PO NUM 045113 EFT: 53.50 VENDOR TOTAL * .00 728.20 0004708 00 KIMBALL MIDWEST 5440232 PI2761 00 03/09/2017 051-5001-940.50-35 PO NUM 045200 261.35 VENDOR TOTAL * 261.35 0005001 00 KOONS GAS MEASUREMENT 18636 PI2772 00 03/09/2017 057-0000-154.00-00 PO NUM 045043 1,143.70 VENDOR TOTAL * 1,143.70 0002027 00 KRIHA FLUID POWER CO INC 00283534 PI2731 00 03/09/2017 057-8205-870.50-48 PO NUM 045225 EFT: 321.49 00283534 PI2732 00 03/09/2017 057-8205-870.60-61 PO NUM 045225 EFT: 7.49 VENDOR TOTAL * .00 328.98 0002902 00 KRIZ-DAVIS CO Page 14 of 39 Agenda Item #3 [PAGE 15] PREPARED 03/02/2017,13:05:02 EXPENDITURE APPROVAL LIST PAGE 8 PROGRAM: GM339L AS OF: 03/09/2017 PAYMENT DATE: 03/09/2017 DEPARTMENT OF UTILITIES ------------------------------------------------------------------------------------------------------------------------------------ VEND NO SEQ# VENDOR NAME EFT, EPAY OR INVOICE VOUCHER P.O. BNK CHECK/DUE ACCOUNT ITEM CHECK HAND-ISSUED NO NO NO DATE NO DESCRIPTION AMOUNT AMOUNT ------------------------------------------------------------------------------------------------------------------------------------ 0002902 00 KRIZ-DAVIS CO S101509054-001 PI2714 00 03/09/2017 051-0000-153.00-00 PO NUM 045197 EFT: 524.30 S101364722-017 PI2642 00 03/09/2017 051-5205-580.50-35 PO NUM 043570 EFT: 8,466.40 S101513402-001 PI2819 00 03/09/2017 053-6105-502.50-35 PO NUM 043965 EFT: 127.12 S101512980-001 PI2818 00 03/09/2017 055-7205-583.50-35 PO NUM 043965 EFT: 16.69 VENDOR TOTAL * .00 9,134.51 0003740 00 LARSON DATA COMMUNICATIONS LD-IV-17051 PI2681 00 03/09/2017 051-0000-155.00-00 PO NUM 045180 279.28 VENDOR TOTAL * 279.28 0002797 00 LAWSON PRODUCTS INC 9304709111 PI2636 00 03/09/2017 051-0000-154.00-00 PO NUM 045140 228.59 VENDOR TOTAL * 228.59 0004976 00 MARCO TECHNOLOGIES LLC INV4047834 PI2689 00 03/09/2017 051-5001-920.60-65 PO NUM 044364 135.62 VENDOR TOTAL * 135.62 0002052 00 MATHESON LINWELD 14931868 PI2644 00 03/09/2017 051-5105-502.50-35 PO NUM 043967 EFT: 76.99 14961986 PI2820 00 03/09/2017 051-5105-502.50-35 PO NUM 043967 EFT: 77.31 14961989 PI2821 00 03/09/2017 051-5105-502.50-35 PO NUM 043967 EFT: 134.27 51145636 PI2822 00 03/09/2017 051-5105-502.60-79 PO NUM 043967 EFT: 108.47 VENDOR TOTAL * .00 397.04 0000667 00 MCMASTER-CARR SUPPLY CO 13251732 PI2639 00 03/09/2017 051-0000-153.00-00 PO NUM 045155 239.82 14873122 PI2807 00 03/09/2017 051-5105-502.50-35 PO NUM 045194 55.48 14873122 PI2808 00 03/09/2017 051-5105-502.50-35 PO NUM 045194 51.48 14873122 PI2809 00 03/09/2017 051-5105-502.60-79 PO NUM 045194 7.95 VENDOR TOTAL * 354.73 0001229 00 MENARDS - FREMONT 25522 PI2736 00 03/09/2017 051-0000-154.00-00 PO NUM 045103 256.99 25156 PI2646 00 03/09/2017 051-5105-502.50-35 PO NUM 043970 26.16 25576 PI2684 00 03/09/2017 051-5105-502.50-35 PO NUM 043970 178.34 25931 PI2824 00 03/09/2017 051-5105-502.50-35 PO NUM 043970 34.55 25718 PI2823 00 03/09/2017 051-5205-580.50-35 PO NUM 043970 64.16 24896 PI2645 00 03/09/2017 053-6105-502.50-35 PO NUM 043970 72.17 25268 PI2647 00 03/09/2017 055-7105-512.50-35 PO NUM 043970 99.98 25647 PI2743 00 03/09/2017 057-8205-870.50-35 PO NUM 043970 6.29 VENDOR TOTAL * 738.64 0004883 00 MISSISSIPPI LIME COMPANY 1304222 00 03/09/2017 051-0000-158.02-00 2/17/17 TN EFT: 4,371.10 1305048 00 03/09/2017 051-0000-158.02-00 2/23/17N EFT: 4,376.24 VENDOR TOTAL * .00 8,747.34 0001486 00 MOTION INDUSTRIES INC Page 15 of 39 Agenda Item #3 [PAGE 16] PREPARED 03/02/2017,13:05:02 EXPENDITURE APPROVAL LIST PAGE 9 PROGRAM: GM339L AS OF: 03/09/2017 PAYMENT DATE: 03/09/2017 DEPARTMENT OF UTILITIES ------------------------------------------------------------------------------------------------------------------------------------ VEND NO SEQ# VENDOR NAME EFT, EPAY OR INVOICE VOUCHER P.O. BNK CHECK/DUE ACCOUNT ITEM CHECK HAND-ISSUED NO NO NO DATE NO DESCRIPTION AMOUNT AMOUNT ------------------------------------------------------------------------------------------------------------------------------------ 0001486 00 MOTION INDUSTRIES INC NE01-462042 PI2711 00 03/09/2017 051-0000-153.00-00 PO NUM 045191 843.48 NE01-462026 PI2712 00 03/09/2017 051-0000-153.00-00 PO NUM 045193 2.63 NE01-462027 PI2713 00 03/09/2017 051-0000-153.00-00 PO NUM 045193 14.33 NE01-462025 PI2730 00 03/09/2017 051-5105-502.50-35 PO NUM 045211 815.14 VENDOR TOTAL * 1,675.58 0004239 00 MOUNTAIN VIEW LLC DBA PMT 7425 PI2733 00 03/09/2017 051-5105-502.60-62 PO NUM 045229 1,175.00 VENDOR TOTAL * 1,175.00 0002985 00 MSC INDUSTRIAL SUPPLY CO INC 65396887 PI2637 00 03/09/2017 051-0000-154.00-00 PO NUM 045141 EFT: 176.75 66863017 PI2640 00 03/09/2017 051-0000-153.00-00 PO NUM 045182 EFT: 334.55 67281797 PI2666 00 03/09/2017 051-5001-940.50-35 PO NUM 045101 EFT: 1,041.08 66248350 PI2672 00 03/09/2017 051-5105-502.50-35 PO NUM 045154 EFT: 368.01 66862967 PI2677 00 03/09/2017 051-5105-502.50-35 PO NUM 045181 EFT: 52.21 VENDOR TOTAL * .00 1,972.60 0003095 00 MUNICIPAL SUPPLY INC OF OMAHA 0648412-IN PI2653 00 03/09/2017 053-6205-583.50-35 PO NUM 044599 357.10 VENDOR TOTAL * 357.10 0001840 00 MURPHY TRACTOR & EQUIPMENT CO INC 679345 PI2678 00 03/09/2017 051-5105-502.60-61 PO NUM 045202 EFT: 712.96 VENDOR TOTAL * .00 712.96 0001958 00 NEBR PUBLIC HEALTH ENVIRONMENTAL 485376 PI2794 00 03/09/2017 053-6105-502.60-61 PO NUM 044530 EFT: 779.00 VENDOR TOTAL * .00 779.00 0003051 00 NEBRASKA PUBLIC SERVICE COMMISSION REVIEW FEE 2017PI2847 00 03/09/2017 051-5205-580.60-77 PO NUM 045254 35.00 VENDOR TOTAL * 35.00 0003428 00 NEW PIG CORPORATION 22126113-00 PI2673 00 03/09/2017 051-5105-502.50-35 PO NUM 045156 422.64 22126113-00 PI2674 00 03/09/2017 051-5105-502.60-79 PO NUM 045156 27.80 VENDOR TOTAL * 450.44 0004151 00 NORTH AMERICAN ELECTRIC RELIABILITY 21213 PI2692 00 03/09/2017 051-5105-502.60-61 PO NUM 044580 5,177.37 VENDOR TOTAL * 5,177.37 0003136 00 NORTHERN NATURAL GAS CO *FNB WIRE* 255619 FEB 2017 00 03/09/2017 057-8205-807.50-02 216,625.13 VENDOR TOTAL * 216,625.13 0002054 00 NORTHWEST ELECTRIC LLC 0189246 PI2838 00 03/09/2017 055-7105-512.60-61 PO NUM 044596 789.50 Page 16 of 39 Agenda Item #3 [PAGE 17] PREPARED 03/02/2017,13:05:02 EXPENDITURE APPROVAL LIST PAGE 10 PROGRAM: GM339L AS OF: 03/09/2017 PAYMENT DATE: 03/09/2017 DEPARTMENT OF UTILITIES ------------------------------------------------------------------------------------------------------------------------------------ VEND NO SEQ# VENDOR NAME EFT, EPAY OR INVOICE VOUCHER P.O. BNK CHECK/DUE ACCOUNT ITEM CHECK HAND-ISSUED NO NO NO DATE NO DESCRIPTION AMOUNT AMOUNT ------------------------------------------------------------------------------------------------------------------------------------ 0002054 00 NORTHWEST ELECTRIC LLC VENDOR TOTAL * 789.50 0002937 00 O'KEEFE ELEVATOR CO INC 00453584 PI2687 00 03/09/2017 051-5001-932.60-65 PO NUM 044245 184.66 00453584 PI2688 00 03/09/2017 051-5105-502.60-65 PO NUM 044245 1,046.44 VENDOR TOTAL * 1,231.10 0001020 00 O'REILLY AUTOMOTIVE INC 0397-436262 PI2744 00 03/09/2017 051-5205-580.50-48 PO NUM 043973 117.66 0397-437837 PI2844 00 03/09/2017 051-5205-580.50-48 PO NUM 045216 660.94 0397-438560 PI2779 00 03/09/2017 055-7105-512.50-35 PO NUM 043973 11.45 VENDOR TOTAL * 790.05 0002888 00 OFFICENET 864355-0 PI2635 00 03/09/2017 051-0000-154.00-00 PO NUM 045134 98.29 864355-0 PI2668 00 03/09/2017 051-5001-940.50-40 PO NUM 045134 266.72 864843-0 PI2723 00 03/09/2017 051-5001-920.50-40 PO NUM 045165 89.92 866349-0 PI2785 00 03/09/2017 051-5001-903.60-65 PO NUM 044096 222.85 866348-0 PI2795 00 03/09/2017 051-5001-940.60-65 PO NUM 044582 74.14 866350-0 PI2796 00 03/09/2017 051-5001-940.60-65 PO NUM 044582 266.98 866620-0 PI2793 00 03/09/2017 051-5205-580.60-65 PO NUM 044440 99.44 865511-0 PI2719 00 03/09/2017 055-7105-512.60-61 PO NUM 043998 89.00 865162-0 PI2724 00 03/09/2017 055-7105-502.50-41 PO NUM 045175 79.99 VENDOR TOTAL * 1,287.33 0002946 00 OMAHA PUBLIC POWER DISTRICT 2462853776 0217 00 03/09/2017 051-5105-502.60-65 Feb '17 SPP Participation EFT: 8,882.50 1115740525 0217 00 03/09/2017 051-5305-560.60-76 Feb 2017 Interconnection EFT: 4,285.88 VENDOR TOTAL * .00 13,168.38 0001268 00 P & H ELECTRIC INC 116410 PI2685 00 03/09/2017 055-7105-512.50-35 PO NUM 043974 80.00 116422 PI2718 00 03/09/2017 055-7105-512.50-35 PO NUM 043974 42.85 116428 PI2825 00 03/09/2017 055-7105-512.50-35 PO NUM 043974 75.07 VENDOR TOTAL * 197.92 0004911 00 PATHFINDER SYSTEMS INC 17152 PI2728 00 03/09/2017 051-5105-502.50-35 PO NUM 045198 430.30 17152 PI2729 00 03/09/2017 051-5105-502.60-79 PO NUM 045198 24.31 VENDOR TOTAL * 454.61 0004948 00 PCM SALES INC B01474070101 PI2661 00 03/09/2017 051-5001-922.50-42 PO NUM 045073 1,198.38 VENDOR TOTAL * 1,198.38 0003414 00 PEERLESS ENERGY SYSTEMS LLC 39578 PI2770 00 03/09/2017 055-0000-154.00-00 PO NUM 044891 513.60 VENDOR TOTAL * 513.60 0003827 00 PEST PRO'S INC Page 17 of 39 Agenda Item #3 [PAGE 18] PREPARED 03/02/2017,13:05:02 EXPENDITURE APPROVAL LIST PAGE 11 PROGRAM: GM339L AS OF: 03/09/2017 PAYMENT DATE: 03/09/2017 DEPARTMENT OF UTILITIES ------------------------------------------------------------------------------------------------------------------------------------ VEND NO SEQ# VENDOR NAME EFT, EPAY OR INVOICE VOUCHER P.O. BNK CHECK/DUE ACCOUNT ITEM CHECK HAND-ISSUED NO NO NO DATE NO DESCRIPTION AMOUNT AMOUNT ------------------------------------------------------------------------------------------------------------------------------------ 0003827 00 PEST PRO'S INC MNCP BLD 022717PI2831 00 03/09/2017 051-5001-932.60-61 PO NUM 044194 42.80 ASH PD 022717 PI2832 00 03/09/2017 051-5105-502.60-61 PO NUM 044208 48.15 CMBT TUR 022717PI2833 00 03/09/2017 051-5105-502.60-61 PO NUM 044208 53.50 PWR PLT 022717 PI2834 00 03/09/2017 051-5105-502.60-61 PO NUM 044208 85.60 SUB STA 022717 PI2835 00 03/09/2017 051-5205-580.60-61 PO NUM 044218 190.35 WTR PLT 022717 PI2829 00 03/09/2017 053-6105-502.60-61 PO NUM 044137 69.55 WWTP 022717 PI2830 00 03/09/2017 055-7105-502.60-61 PO NUM 044189 110.00 VENDOR TOTAL * 599.95 0004800 00 PINNACLE BANK - VISA 3676238095 PI2703 00 03/09/2017 055-7105-512.50-35 PO NUM 045205 190.00 1025 PI2806 00 03/09/2017 055-7105-512.50-35 PO NUM 045186 399.50 000883 PI2720 00 03/09/2017 057-8205-870.60-62 PO NUM 045097 23.00 11552 ISHMIEL PI2721 00 03/09/2017 057-8205-870.60-62 PO NUM 045097 141.12 11551 CARNAHAN PI2722 00 03/09/2017 057-8205-870.60-62 PO NUM 045097 141.12 VENDOR TOTAL * 894.74 0001627 00 PIPING RESOURCES INC 0248974-IN PI2805 00 03/09/2017 055-7105-512.50-35 PO NUM 045185 1,179.60 VENDOR TOTAL * 1,179.60 0002793 00 PLIBRICO COMPANY LLC 97105 PI2654 00 03/09/2017 051-5001-932.50-35 PO NUM 044711 3,163.30 97105 PI2655 00 03/09/2017 051-5001-932.60-61 PO NUM 044711 4,890.47 97362 PI2798 00 03/09/2017 051-5001-932.60-61 PO NUM 044711 390.00 97376 PI2799 00 03/09/2017 051-5001-932.60-61 PO NUM 044711 738.00 97378 PI2800 00 03/09/2017 051-5001-932.60-61 PO NUM 044711 4,463.75 VENDOR TOTAL * 13,645.52 0004740 00 PREMIER STAFFING INC 9242 PI2664 00 03/09/2017 051-5001-903.60-61 PO NUM 045081 325.60 9276 PI2804 00 03/09/2017 051-5001-903.60-61 PO NUM 045081 325.60 9243 PI2649 00 03/09/2017 051-5105-502.60-61 PO NUM 043988 30.00 VENDOR TOTAL * 681.20 0004696 00 PRIME COMMUNICATIONS INC 41267 PI2669 00 03/09/2017 051-5001-922.60-65 PO NUM 045136 5,262.26 VENDOR TOTAL * 5,262.26 0002028 00 QA BALANCE SERVICES 6002 PI2810 00 03/09/2017 051-5105-502.60-61 PO NUM 045220 160.00 6001 PI2704 00 03/09/2017 055-7105-512.60-61 PO NUM 045208 160.00 VENDOR TOTAL * 320.00 0004866 00 QUESTLINE INC 021317B PI2814 00 03/09/2017 051-5001-903.60-61 PO NUM 043059 3,326.25 VENDOR TOTAL * 3,326.25 0004463 00 RESOURCE ACTION PROGRAMS LLC Page 18 of 39 Agenda Item #3 [PAGE 19] PREPARED 03/02/2017,13:05:02 EXPENDITURE APPROVAL LIST PAGE 12 PROGRAM: GM339L AS OF: 03/09/2017 PAYMENT DATE: 03/09/2017 DEPARTMENT OF UTILITIES ------------------------------------------------------------------------------------------------------------------------------------ VEND NO SEQ# VENDOR NAME EFT, EPAY OR INVOICE VOUCHER P.O. BNK CHECK/DUE ACCOUNT ITEM CHECK HAND-ISSUED NO NO NO DATE NO DESCRIPTION AMOUNT AMOUNT ------------------------------------------------------------------------------------------------------------------------------------ 0004463 00 RESOURCE ACTION PROGRAMS LLC 12311609800 PI2836 00 03/09/2017 051-5001-903.50-35 PO NUM 044244 1,610.84 12311609800 PI2837 00 03/09/2017 051-5001-903.60-79 PO NUM 044244 88.00 VENDOR TOTAL * 1,698.84 0003790 00 RIEKES EQUIPMENT CO ROMINV00082819 PI2758 00 03/09/2017 051-5001-940.50-35 PO NUM 045172 834.61 ROMINV00082819 PI2759 00 03/09/2017 051-5001-940.60-79 PO NUM 045172 48.15 VENDOR TOTAL * 882.76 0004989 00 SCS ENGINEERS 0295721 PI2802 00 03/09/2017 051-5105-502.60-61 PO NUM 044947 450.00 0295721 PI2803 00 03/09/2017 051-5105-502.60-61 PO NUM 044947 4,951.25 VENDOR TOTAL * 5,401.25 0003036 00 SHAFFER COMMUNICATIONS INC 17-0241 PI2665 00 03/09/2017 051-5205-580.50-35 PO NUM 045094 2,706.67 VENDOR TOTAL * 2,706.67 0001308 00 SHERWIN-WILLIAMS CO 3117-3 PI2780 00 03/09/2017 055-7105-512.50-35 PO NUM 043978 358.46 3164-5 PI2826 00 03/09/2017 055-7105-512.50-35 PO NUM 043978 224.76 VENDOR TOTAL * 583.22 0004273 00 SHRED MONSTER INC 23497 PI2786 00 03/09/2017 051-5001-932.60-61 PO NUM 044124 58.00 VENDOR TOTAL * 58.00 0000780 00 SHUTTLEWAGON INC 037773 PI2662 00 03/09/2017 051-5105-502.50-48 PO NUM 045075 EFT: 1,258.61 037773 PI2663 00 03/09/2017 051-5105-502.60-79 PO NUM 045075 EFT: 31.94 VENDOR TOTAL * .00 1,290.55 0004652 00 SIEMENS INDUSTRY INC 5601439215 PI2656 00 03/09/2017 051-5105-502.60-61 PO NUM 044732 EFT: 8,904.59 5601439215 PI2657 00 03/09/2017 051-5105-502.60-79 PO NUM 044732 EFT: 54.42 VENDOR TOTAL * .00 8,959.01 0000429 00 SKARSHAUG TESTING LABORATORY INC 215931 PI2781 00 03/09/2017 051-5205-580.60-61 PO NUM 043994 223.80 215931 PI2782 00 03/09/2017 051-5205-580.60-79 PO NUM 043994 102.15 VENDOR TOTAL * 325.95 0003415 00 SNAP-ON INDUSTRIAL ARV/31715959 PI2760 00 03/09/2017 051-5105-502.50-35 PO NUM 045199 70.71 VENDOR TOTAL * 70.71 0004674 00 SOLARWINDS INC IN314662 PI2734 00 03/09/2017 057-8205-870.50-42 PO NUM 045234 743.00 VENDOR TOTAL * 743.00 0002023 00 SOLUTIONONE Page 19 of 39 Agenda Item #3 [PAGE 20] PREPARED 03/02/2017,13:05:02 EXPENDITURE APPROVAL LIST PAGE 13 PROGRAM: GM339L AS OF: 03/09/2017 PAYMENT DATE: 03/09/2017 DEPARTMENT OF UTILITIES ------------------------------------------------------------------------------------------------------------------------------------ VEND NO SEQ# VENDOR NAME EFT, EPAY OR INVOICE VOUCHER P.O. BNK CHECK/DUE ACCOUNT ITEM CHECK HAND-ISSUED NO NO NO DATE NO DESCRIPTION AMOUNT AMOUNT ------------------------------------------------------------------------------------------------------------------------------------ 0002023 00 SOLUTIONONE 467033 PI2787 00 03/09/2017 051-5001-903.60-65 PO NUM 044126 204.96 VENDOR TOTAL * 204.96 0004430 00 STANDARD LABORATORIES INC 70009735 PI2715 00 03/09/2017 051-5105-502.60-61 PO NUM 042641 471.90 VENDOR TOTAL * 471.90 0003923 00 STATE OF NEBRASKA - CELLULAR 1051336 00 03/09/2017 051-5001-903.50-53 Cellular EFT: 47.36 1051336 00 03/09/2017 051-5001-919.50-53 Cellular EFT: 72.18 1051336 00 03/09/2017 051-5001-922.50-53 Cellular EFT: 97.29 1051336 00 03/09/2017 051-5001-926.50-53 Safety Mgr Cellular EFT: 57.53 1051336 00 03/09/2017 051-5105-502.50-53 Cellular EFT: 137.84 1051336 00 03/09/2017 051-5205-580.50-53 Engineers Cellular EFT: 230.12 1051336 00 03/09/2017 051-5205-580.50-53 Elect Distr Cellular EFT: 362.82 1051336 00 03/09/2017 053-6105-502.50-53 Cellular EFT: 57.53 1051336 00 03/09/2017 053-6205-583.50-53 Cellular EFT: 164.42 1051336 00 03/09/2017 055-7105-502.50-53 Cellular EFT: 24.17 1051336 00 03/09/2017 057-8205-870.50-53 Cellular EFT: 196.59 VENDOR TOTAL * .00 1,447.85 0001137 00 STEFFY CHRYSLER CENTER INC, GENE HS675594 2017 PI2801 00 03/09/2017 051-5001-950.80-50 PO NUM 044802 26,262.00 5054757 PI2827 00 03/09/2017 051-5205-580.50-48 PO NUM 043979 151.08 6092564/2 PI2848 00 03/09/2017 051-5205-580.50-48 PO NUM 045255 331.99 6092564/2 PI2849 00 03/09/2017 051-5205-580.60-61 PO NUM 045255 928.95 VENDOR TOTAL * 27,674.02 0000434 00 STOVER CO, RS INV-479323 PI2707 00 03/09/2017 051-0000-153.00-00 PO NUM 044963 453.89 VENDOR TOTAL * 453.89 0003891 00 SUNGARD PUBLIC SECTOR INC 133361 PI2690 00 03/09/2017 051-5001-903.60-77 PO NUM 044387 EFT: 248.80 133361 PI2691 00 03/09/2017 051-5001-917.60-77 PO# 044387 EFT: 13.09 VENDOR TOTAL * .00 261.89 0004647 00 T SQUARE SUPPLY LLC 15803 PI2746 00 03/09/2017 051-5001-940.50-35 PO NUM 043980 125.39 VENDOR TOTAL * 125.39 0004552 00 TITAN MACHINERY INC 8960856 GP PI2648 00 03/09/2017 051-5105-502.50-35 PO NUM 043983 EFT: 143.53 VENDOR TOTAL * .00 143.53 0003780 00 ULTRA-CHEM INC 1183134 PI2700 00 03/09/2017 057-8205-870.50-35 PO NUM 045161 395.48 1183134 PI2701 00 03/09/2017 057-8205-870.60-79 PO NUM 045161 46.83 VENDOR TOTAL * 442.31 0001914 00 UNION PACIFIC RAILROAD Page 20 of 39 Agenda Item #3 [PAGE 21] PREPARED 03/02/2017,13:05:02 EXPENDITURE APPROVAL LIST PAGE 14 PROGRAM: GM339L AS OF: 03/09/2017 PAYMENT DATE: 03/09/2017 DEPARTMENT OF UTILITIES ------------------------------------------------------------------------------------------------------------------------------------ VEND NO SEQ# VENDOR NAME EFT, EPAY OR INVOICE VOUCHER P.O. BNK CHECK/DUE ACCOUNT ITEM CHECK HAND-ISSUED NO NO NO DATE NO DESCRIPTION AMOUNT AMOUNT ------------------------------------------------------------------------------------------------------------------------------------ 0001914 00 UNION PACIFIC RAILROAD 285737944 00 03/09/2017 051-0000-152.00-00 2/25/17 EFT: 236,100.30 VENDOR TOTAL * .00 236,100.30 0005012 00 UNITED POWER SERVICES INC 17/2837-IN PI2764 00 03/09/2017 051-5205-580.60-61 PO NUM 045236 108.00 17/2837-IN PI2765 00 03/09/2017 051-5205-580.60-79 PO NUM 045236 26.80 VENDOR TOTAL * 134.80 0000525 00 UTILITY EQUIPMENT CO 40052196-000 PI2676 00 03/09/2017 053-6205-583.60-76 PO NUM 045169 300.00 VENDOR TOTAL * 300.00 0002894 00 WASTE CONNECTIONS INC 4755002 PI2788 00 03/09/2017 051-5001-932.50-49 PO NUM 044253 226.14 4755002 PI2789 00 03/09/2017 051-5001-940.50-49 PO NUM 044253 291.41 4755002 PI2790 00 03/09/2017 051-5105-502.50-49 PO NUM 044253 264.71 4755002 PI2791 00 03/09/2017 055-7105-502.50-49 PO NUM 044253 1,030.91 VENDOR TOTAL * 1,813.17 0004336 00 WATERLINK INC 10887 PI2675 00 03/09/2017 051-5105-502.50-52 PO NUM 045163 3,865.99 VENDOR TOTAL * 3,865.99 0000482 00 WESCO RECEIVABLES CORP 815630 PI2633 00 03/09/2017 051-0000-154.00-00 PO NUM 044832 EFT: 110.75 817907 PI2693 00 03/09/2017 051-5205-580.50-35 PO NUM 044842 EFT: 530.72 817907 PI2694 00 03/09/2017 051-5205-580.50-48 PO NUM 044842 EFT: 184.04 VENDOR TOTAL * .00 825.51 0002791 00 YRC FREIGHT 579-962336-X PI2667 00 03/09/2017 051-5105-502.60-79 PO NUM 045119 171.39 VENDOR TOTAL * 171.39 EFT/EPAY TOTAL *** 352,560.75 TOTAL EXPENDITURES **** 838,000.16 352,560.75 GRAND TOTAL ******************** 1,190,560.91 Page 21 of 39 Agenda Item #3 [PAGE 22] STAFF REPORT TO: Board of Public Works Brian Newton, Utilities General Manager FROM: Jody Sanders, CPA, Director of Finance DATE: March 6, 2017 SUBJECT: Statement of Operations and Net Position for December 2016 Recommendation: Review Statement of Operations and Net Position for December 2016 Background: The financial and operating statements for December are presented for your review. This month represents the three-month mark of the City’s fiscal year, or 25% of the budget. One recurring theme for 2017 is the change in recording administration costs. Expenses for Customer Service, Executive Management, Accounting/Finance, Information Technology, Human Resources and Warehouse are being accumulated differently to allow for budgeting and monitoring for these departments individually. The result for the Board’s financial reports is only that Payroll in Dollars activity for these departments stay in the Electric Fund for the Finance Activity report. The Administration expenses remain split predominantly 50% City, 20% Electric, 7.5% each for Water and Sewer and 15% Gas funds, with certain exceptions on the Board’s reports. One other change is including deprecation in the calculation of production cost per unit of sales in the Electric, Water and Sewer Fund reports. Fiscal Impact: Electric Fund: Finance Activity: Year to date (YTD) this fund has recognized a positive 25% of the Change in Net Position budgeted for the fiscal year, right on target, like last year YTD (25% also). Off system sales are $797,000 more than last year, accounting for much of the increase in revenue. This increase is also reflected in fuel cost exceeding last year marks as well. Other expenses are within budgeted amounts for the year. October 2016 included the vacation and sick leave payouts to both the former Director of Electrical Engineering and the Utilities General Manager, which effect YTD numbers all year long. E-1: Production reports reflect the increase in Off system sales, with increased generation and fuel use. E-2: Cash balance remains solid, as revenues increased more than expenditures, accounting for the current month increase of $127,456 in Electric fund cash balance for December, as no coal shipments are received during the winter months. [PAGE 23] Staff Report, page 2 Statement of Operations and Net Position for November 2016 March 6, 2017 Water Fund: Finance Activity: YTD this fund has recognized 33% of the budgeted Change in Net Position for 2017, compared to 37% last YTD. Revenues were flat in December. YTD expenses for departments came in under budget, except in Distribution, where 300 erts for meters were issued. (Yes we are looking into this. More on Wednesday). The apparent $15,000 increase year-to-year in production is due to the prior year’s capital activity reducing November 2016 production expense. W-1: December total water pumped was up 12.9%, with nearly every metric reflecting this increase. We continue to monitor the production versus sales data, and find that this is the month where we again have a large difference of 15%, with 9 percent of unexplained difference year to date. Avg production cost remain at the $0.20 mark. W-2: Cash decreased a modest $19,501 for the period. Wastewater Fund: Finance Activity: YTD this fund has recognized 134% of the budgeted Change in Net Position for 2017, compared to 85%. Commercial revenue was down $13,000 in December. Nonoperating revenue increase is from the Biosolids application program, with the offsetting cost included in production expense. Expenses are all within budget. Note that prior year’s production expense included $29,000 for centrifuge repair. S-1: Volumes are down 6.6% year to year, with the 12-month rolling average costs remaining just over $1.50 per 1,000 gal of input. Cash and investment balances decreased $100,187 in December after the $200,000 increase last month. Gas Fund: Finance Activity: As we’ve discussed in Board meetings previously, this fund’s bottom line bounces throughout the year, with an inauspicious start of a loss of $935,293 YTD. Expense categories came in at or below budget, led by a $431,258 YTD increase in gas purchase expense. G-1: The inventory level was down slightly in December, with gas prices moving upward. Cash balance decreased $348,320 in December as we paid for gas sold, but unbilled in December. I have included the natural gas graph updated for the current quarter’s activity to help illustrate the unusual nature of the margin curve in the Gas Fund. The Utilities’ Statement of Net Position shows each fund’s net position (sometimes referred to as “reserves”) and the restrictions on net position. -2- [PAGE 24] Page 22 of 39 Agenda Item #4 [PAGE 25] Page E-1 ELECTRIC SYSTEM Statement of Operations For the Month Ended 12/31/2016 CURRENT YEAR PRIOR YEAR Production Data: Current Month Y-T-D Current Month Y-T-D GENERATION: Gross Generation in M's 54,135 149,618 40,011 122,939 Less Plant Use 4,352 12,442 3,869 11,342 Net Generation 49,783 137,176 36,143 111,597 Purchased from other Utilities 2,805 7,302 3,252 13,192 Less sales to other Utilities 12,740 39,659 1,354 19,641 System Net Output 39,847 104,819 38,041 105,148 LOCAL LOAD PEAKS: Gross System Output, KW 77,300 73,430 Gross System Output, Date 15-Dec-16 28-Dec-15 Gross System Output, Time 6:00 PM 7:00 PM System Net Output, KW 70,080 67,390 System Net Output, Date 15-Dec-16 28-Dec-15 System Net Output, Time 6:00 PM 11:00 AM MISCELLANEOUS BTU Per KWH, Gross Generation 10,980 11,040 BTU Per KWH, Net Generation 11,940 12,220 Load Factor, Gross Generation 0.769 0.793 Load Factor, Net Generation 0.764 0.784 FUEL USE: Coal, Tons 32,612 88,652 24,739 75,359 Natural gas, Mcf 13,343 51,764 13,041 47,304 Propane, Gallons FUEL EXPENSE IN DOLLARS: Coal $ 906,159 $ 2,467,751 $ 711,188 $ 2 ,171,554 Natural gas $ 59,241 $ 215,855 $ 50,598 $ 1 83,541 Propane $ - $ - $ - $ - Total $ 965,400 $ 2,683,605 $ 761,786 $ 2 ,355,096 AVERAGE EXPENSE Per KWH Fuel, Gross Generation $0.01783 $0.01904 Fuel, Net Generation $0.01939 $0.02108 Production, Net Generation $0.04536 $0.0348 $0.04983 $0.0371 INVENTORIES IN DOLLARS: Propane $ 12,400 $ 12,400 Fuel Oil $ 30,228 $ 30,228 Coal $ 1,985,771 $ 2,577,766 Production supplies $ 2,867,537 $ 2,880,289 Distribution supplies $ 1,553,414 $ 1,516,146 Gasboy $ 20,991 $ 28,817 Total $ 6,470,341 $ 7,045,645 COAL INVENTORY 71,465 89,668 3/6/2017 Page 23 of 39 Agenda Item #4 [PAGE 26] Page E-2 City of Fremont Department of Utilities Electric Fund Cash Transactions For the Month Ended 12/31/2016 Beginning Disburse- balance Receipts ments Ending balance Cash $ 3,964,735 $ 4,441,809 $ (4,333,567) $ 4,072,977 A. Offset cash $ 277,048 263,365 (244,328) $ 296,084 A. Petty Cash/drawers $ 2,300 - - $ 2,300 A. Money Market Accounts $ 1,020,748 134 - $ 1,020,883 A. Bond proceeds $ 509,228 43 - $ 509,271 B. Unrestricted CD $ 11,500,000 1,250,000 (1,250,000) $ 11,500,000 C. Investments Insurance Reserve CD $ 250,000 - - $ 250,000 D. Monofill Closure CD $ 500,000 - - $ 500,000 D. Debt Service CDs $ 7,696,000 - - $ 7,696,000 D. Total $ 25,720,058 $ 5,955,352 $ (5,827,895) $ 25,847,515 net change 127,456 Totals Per Stmt of Net Position Unrestricted cash A. $ 5,392,244 $ 5,392,244 $ - Restricted cash B. $ 509,271 $ 509,271 $ - Unrestricted investments C. $ 11,500,000 $ 12,316,175 $ (816,175) Restricted investments D. $ 8,446,000 $ 7,629,825 $ 816,175 Ending balance $ 25,847,515 $ 25,847,515 $ - Page 24 of 39 Agenda Item #3/46/2017 [PAGE 27] Page 25 of 39 Agenda Item #4 [PAGE 28] Page W-1 WATER SYSTEM Statement of Operations For the Month Ended 12/31/2016 Current Year Prior Year PRODUCTION DATA: Current Month Current Month TOTAL WATER PUMPED In 1,000 Gallons: 91,820 81,317 Plant II Bypass: 26 - PEAKS: Peak Flow - Gallons/Minutes 6,079 5,910 -Date 22-Dec-16 9-Dec-15 -Time 10:15 AM 11:40 AM Peak Day - 1,000 Gallons 3 ,485 2,919 -Date 21-Dec-16 15-Dec-15 Avg. Day - 1,000 Gallons 2,962 2,623 COST PER 1,000 GALLONS PUMPED: YTD YTD Average Electric Cost $0.0830 $0.0830 Average Production Cost $0.5218 $0.3811 $0.5832 $0.3799 Average Kilowatts Used 0.922 0.873 November Production Data/December Sales Data Previous Previous Month % OF TOTAL GALLONS PUMPED: month Y-T-D CURRENT YEAR - M-GALLONS % M-GALLONS % Total Sales 81,443 82% 326,499 75% Bulk Water Sales - 32 0% Systems Use 1,298 1% 4,213 1% Plant II Bypass 1,036 1% 66,218 15% Unmetered 401 0% 1,015 0% Difference 15,185 15% 37,712 9% Total Water Pumped 99,364 100% 435,689 100% PRIOR YEAR Total Sales 87,879 99% 348,435 143% Bulk Water Sales 3 0% 199 0% Systems Use 1,534 2% 4,855 2% Plant II Bypass - 87,589 36% Unmetered 3,553 4% 4,847 2% Difference (4,613) -5% (202,288) -83% Total Water Pumped 88,356 100% 243,637 100% 12-month rolling average production cost per 1,000 gallons pumped: $0.1999 $0.2007 3/6/2017 Page 26 of 39 Agenda Item #4 [PAGE 29] Page W-2 City of Fremont Department of Utilities Water Fund Cash Transactions For the Month Ended 12/31/2016 Beginning Disburse- balance Receipts ments Ending balance Cash $ 1,246,328 $ 267,933 $ (287,602) $ 1,226,659 A. Money Market Accounts $ 747,035 169 - $ 747,203 A. Unrestricted CD $ - - - $ - B. Investments Debt Service CDs $ 875,000 - - $ 875,000 C. Total $ 2,868,363 $ 268,101 $ (287,602) $ 2,848,862 net change (19,501) Totals Per Stmt of net position Unrestricted cash A. $ 1,973,862 $ 1,964,166 $ 9,696 Restricted cash A. $ - $ 9,696 $ (9,696) Unrestricted investments B. $ - $ - $ - Restricted investments C. $ 875,000 $ 875,000 $ - Ending balance $ 2,848,862 $ 2,848,862 $ 0 Page 27 of 39 Agenda Item #3/46/2017 [PAGE 30] Page 28 of 39 Agenda Item #4 [PAGE 31] Page S-1 SEWAGE SYSTEM Statement of Operations/Finance Activity For the Month Ended 12/31/2016 CURRENT YEAR PRIOR YEAR TREATMENT PLANT: Current Month Y T D Current Month Y T D Input in 1,000 Gallons 125,540 381,900 134,450 403,787 Minimum Flow 3,270 9,790 3,140 9,961 Maximum Flow 4,460 13,880 6,490 18,070 Peak Hour Flow 7,000 7,200 9,600 7,900 Average Day 4,050 12,450 4,340 13,170 Gas Produced - 1,000 Cubic Feet 3,839 11,774 3,053 10,073 Propane Used - Gallons - - - - Treatment Cost/ 1,000 Gallons 1.7446 1.5143 1.4688 1.0169 12-month rolling avg production 1.5005 1.5446 cost/1,000 gal. input: Inventory in Dollars $ 132,212 $ 131,268 City of Fremont Department of Utilities Sewer Fund Cash Transactions For the Month Ended 12/31/2016 Beginning Disburse- Ending balance Receipts ments balance Cash $ 2,218,999 $ 441,790 $ (542,034) $ 2,118,755 A. Money Market Accounts $ 304,503 57 - $ 304,560 A. Unrestricted CD Investments $ 5,200,000 2,000,000 (2,000,000) $ 5,200,000 B. Debt Service CDs $ 175,000 - - $ 175,000 C. Total $ 7,898,503 $ 2,441,848 $(2,542,034) $ 7,798,316 net change ( 100,187) Totals Per Stmt of Net Position Unrestricted cash $ 2,423,316 A. $ 2,423,316 $ - Unrestricted investments $ 5,200,000 B. $ 5,097,655 $ 102,345 Restricted investments $ 175,000 C $ 277,345 $ ( 102,345) Ending balance $ 7,798,316 $ 7,798,316 $ - 3/6/2017 Page 29 of 39 Agenda Item #4 [PAGE 32] Page 30 of 39 Agenda Item #4 [PAGE 33] Page G-1 GAS SYSTEM Statement of Operations/Finance Activity For the Month Ended 12/31/2016 CURRENT YEAR PRIOR YEAR GAS SYSTEM: Current Month Y T D Current Month Y T D Gas volume delivered (Mmbtu) 349,573 774,111 3 68,643 906,953 Gas Available for Sale 349,573 774,111 3 68,643 906,953 Cost of Gas / Mmbtu 3.16229 3.44573 A 2.51617 2.46553 Gas Use / Day / Mmbtu 11,277 11,892 Gas Cost / Day 35,659.710 2 9,921.613 Gas Storage in Mcf 222,200 2 45,208 Natural Gas inventory $ 713,989 $ 6 47,305 Other inventory $ 455,446 $ 4 93,789 Total inventory $ 1,169,435 $ 1 ,141,094 A. YTD is calculation using adjusted Gas Purchase Expense YTD/Gas Available for Sale YTD. City of Fremont Department of Utilities Gas Fund Cash Transactions For the Month Ended 12/31/2016 Beginning Disburse- Ending balance Receipts ments balance Cash $ 118,476 $ 1,410,546 $ (1,259,194) $ 269,828 A. Money Market Accounts $ 1,726,826 328 $ 1,727,154 A. Unrestricted CD Investments $ 3,750,000 1,500,000 (2,000,000) $ 3,250,000 B. Debt Service CDs $ 250,000 $ 250,000 C. Total $ 5,845,302 $ 2,910,874 $ (3,259,194) $ 5,496,982 net change (348,320) Totals Per Stmt of Net Position Unrestricted cash $ 1,996,982 A. $ 1 ,996,982 $ - Unrestricted investments $ 3,250,000 B. $ 3 ,500,000 $ (250,000) Restricted investments $ 250,000 C. $ - $ 250,000 Ending balance $ 5,496,982 $ 5 ,496,982 $ - 3/6/2017 Page 31 of 39 Agenda Item #4 [PAGE 34] City of Fremont Department of Utilities Natural gas activity by month 2012 ‐ 2017 YTD $4,000,000 $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $0 3.3579 4.2962 3.6192 6.7732 3.9683 3.4522 2.5162 3.1623 Operating Revenue Gas purchas expense Consumption (ccf) Cost of gas Page 32 of 39 Agenda Item #4 [PAGE 35] CITY OF FREMONT, NEBRASKA Statement of Net Position - Proprietary Funds December 31, 2016 Dec Enterprise Funds Electric Water Sewer Gas Fund Fund Fund Fund Total ASSETS Current assets: Cash and cash equivalents $ 5 ,392,244 $ 1,964,166 $ 2,423,316 $ 1,996,982 $ 1 1,776,708 Investments 12,316,175 - 5 ,097,655 3,500,000 20,913,830 Receivables Accounts, net of allowance for doubtful accounts 1,346,051 230,446 2 11,973 6 61,685 2,450,156 Budget billing balance ( 296,084) - - - ( 296,084) Unbilled revenue 2,300,058 235,075 3 92,058 5 41,447 3,468,638 Due from other funds 63,588 2,166 366 4,720 70,840 Due from other governments - - - - - Interest 193,548 10,026 5 1,995 3 9,780 295,349 Inventory 6,470,341 343,779 1 32,212 1,169,435 8,115,767 Prepaid expenses 306,498 85,274 9 1,308 1 70,367 653,446 Total current assets 2 8,092,420 2,870,932 8 ,400,883 8,084,415 47,448,650 Noncurrent assets: Restricted cash and cash equivalents 509,271 9,696 - - 518,967 Restricted investments 7,629,825 875,000 2 77,345 - 8,782,170 Unamortized bond discount 46,123 - - - 46,123 Capital assets Land 2,086,695 1,890,618 1 43,803 1 16,340 4,237,456 Construction in progress 6,520,339 196,775 1 92,515 2 18,944 7,128,573 Depreciable capital assets 2 02,448,514 3 9,988,357 51,201,786 15,883,510 3 09,522,167 Less Accumulated depreciation (96,010,150) (16,570,618) (24,834,346) (10,797,099) (148,212,212) Net capital assets 1 15,045,398 2 5,505,132 26,703,759 5,421,695 1 72,675,984 Total noncurrent assets 1 23,230,616 2 6,389,828 26,981,104 5,421,695 1 82,023,243 Total assets 1 51,323,036 29,260,760 35,381,987 13,506,111 229,471,893 Deferred Outflows of Reources Deferred loss on bond refunding 133,825 27,546 19,226 - 180,597 Total Deferred outlfows of 133,825 27,546 1 9,226 - 180,597 resources LIABILITIES Current liabilities: Accounts payable 4,550,204 29,163 4 49,118 1,167,749 6,196,234 Due to other funds 980 1,754 306 132 3,172 Sales tax payable 206,662 2,038 - 173 208,873 Accrued interest payable 562,489 31,009 2,806 - 596,304 Customer deposits 544,250 - 511 - 544,761 Warranty reserve surge protection 6,082 - - - 6,082 Curr. portion of comp absences 888,000 25,000 4 7,000 1 40,000 1,100,000 Current portion of long-term obligations 2,507,356 635,434 3 12,211 - 3,455,001 Total current liabilities 9,266,023 724,397 8 11,952 1,308,054 12,110,427 Noncurrent liabilities: Fly Ash liability 61,371 - - - 61,371 Compensated absences 159,139 26,503 4 7,155 125,370.18 358,168 Unamortized bond premium 1,918,215 45,856 - - 1,964,071 Noncurrent portion of long-term obligations 5 6,054,670 5,644,934 1 ,795,395 - 63,494,999 Total noncurrent liabilities 5 8,193,396 5,717,293 1 ,842,550 1 25,370 65,878,609 Total liabilities 6 7,459,419 6,441,690 2 ,654,502 1,433,424 77,989,035 Deferred Inflows of Resources Deferred gain on bond refundings 421 425 238 - 1,084 Total Deferred inlfows of 421 425 238 - 1,084 resources NET POSITION Invested in capital assets, net 5 4,182,616 19,175,445 24,612,572 5,421,695 1 03,392,329 Restricted for: Debt service 7,191,196 884,696 2 77,345 - 8,353,237 Fly Ash disposal 438,629 - - - 438,629 Unrestricted 2 2,184,581 2,786,049.69 7 ,856,554 6,650,992 39,478,176 Total net position $ 8 3,997,021 $ 2 2,846,191 $ 32,746,472 $ 12,072,687 $ 1 51,662,371 Page 33 of 39 Agenda Item #4 [PAGE 36] STAFF REPORT TO: Board of Public Works FROM: Brian Newton, General Manager Jeff Shanahan, LDW Plant Superintendent DATE: March 8, 2017 SUBJECT: LDW Power Plant brick repair Recommendation: Authorize repair of brick BACKGROUND: The City of Fremont, Department of Utilities Lon D. Wright (LDW) power plant has developed a multiyear plan to repair exterior brick. On February 22, 2017, FDU received bids for Brick Removal, Materials and Installation. Although the specifications were advertised and three previous brickwork vendors were contacted directly, only one bid was received. This bid meets all requirements given. Square Estimated number Vendor feet of Cost of brick to replace repair Mid-Continental Restoration 1,000 17,026 $146,482.00 Company LDW Staff recommends the Board of Public Works authorize LDW staff to issue a purchase order to Mid-Continental Restoration Company at a cost of $146,482.00 FISCAL IMPACT: FY 2016/2017 operating budget expenditure of $146,482.00 + tax. Page 34 of 39 Agenda Item #5 [PAGE 37] STAFF REPORT TO: BOARD OF PUBLIC WORKS FROM: Jan Rise, Administrative Services Director Brian Newton, Utilities General Manager/Interim City Administrator DATE: March 8, 2017 SUBJECT: Claim Settlements for Lon D. Wright Power Plant Turbine and Generator Damage ________________________________________________________________________ Recommendation: Approve damage claim settlements for turbine damage claim in the amount of $1,230,906 and for generator damage claim in the amount of $100,000 for a total reimbursement of $1,330,906. ________________________________________________________________________ Background: During a routine technical inspection of the Unit 8 generator at the Lon D. Wright Power Plant in April 2016, damages to the turbine and generator were discovered. The mechanical failure in the turbine subsequently caused damage to the generator. While the equipment was out of service, some additional maintenance scheduled for next year was performed. Two insurance claims were filed with the ACE American Insurance Company for the mechanical failure to the Unit 8 turbine and generator. Some maintenance and other extra expenses were not eligible expenses. A summary of the claims and insurance settlement includes the following: Claims Total Repair & Eligible Less Net Claim Maintenance Repair Deductible Settlement Expenditures Costs Per Claim Turbine $1,593,620 $1,430,906 $200,000 $1,230,906 Generator $ 582,600 $ 300,000 $200,000 $ 100,000 Total $2,176,220 $1,730,906 $400,000 $1,330,906 It is recommended that the Fremont Department of Utilities accept the claim settlement as negotiated and recommend that City Council authorize execution of the same. Fiscal Impact: $1,330,906 reduction in $2,176,220 expenditure Page 35 of 39 Agenda Item #6 [PAGE 38] Page 36 of 39 Agenda Item #6 [PAGE 39] STAFF REPORT TO: Board of Public Works FROM: Brian Newton, General Manager Jeff Shanahan, LDW Plant Superintendent DATE: March 8, 2017 SUBJECT: Lon D. Wright Unit #8 Heater #4 Replacement Recommendation: Approve bid and recommend approval by City Council to authorize LDW staff to issue a purchase order to replace Unit #8 Heater #4. BACKGROUND: LDW Unit #8 heater #4 has been isolated for months due to a major failure resulting in a forced outage of Unit #8. LDW hired a contractor to analyze the damage of the heater and it was determined that the heater tubes had thinned to the point that the heater was not suitable to be placed back into service and a total tube bundle replacement was required. On March 2, 2017, FDU received one bid for tube bundle replacement. Although the specifications were advertised and two vendors were contacted directly, only one bid was received. This bid meets all requirements. Vendor Cost Brimhall Industrial, Inc. $289,714.27 Staff recommends the Board of Public Works approve the bid and recommend the City Council authorize LDW staff to issue a purchase order to Brimhall Industrial Inc. at a cost of $289,714.27 FISCAL IMPACT: FY 2016/2017 budget expenditure of $289,714.27 including 7% sales tax. Page 37 of 39 Agenda Item #7 [PAGE 40] STAFF REPORT TO: Board of Public Works Brian Newton, Utilities General Manager FROM: Jody Sanders, Director of Finance DATE: March 6, 2017 SUBJECT: DU Investment report Recommendation: Receive DU investment activity Background: Certificate of deposit investments owned by the Fremont Department of Utilities as of February 28, 2017 follow this staff report. The most recent maturity of February 24, 2017 was a $1 million certificate of deposit for the Electric Fund, which was cashed to help with cash flow in the Electric Fund. Page 38 of 39 Agenda Item #8 [PAGE 41] Department of Utilities Investments For Month ended 2/28/17 Year End 9/30/2017 DATE For Bond BANK TYPE CD # INVESTED DUE DATE RATE % Investment Dept Ledger 26 Pinnacle Fremont CD 7200009667 3/16/2016 3/16/2017 0.0077 1,250,000.00 Electric 051-0000-127.27-02 General 43 Pinnacle Fremont CD 7200009668 3/16/2016 3/16/2017 0.0077 1,000,000.00 Sewer 055-0000-127.27-02 General 41 Pinnacle Fremont CD 7200009565 3/16/2015 3/16/2017 0.0090 700,000.00 Sewer 055-0000-127.27-02 General 9 Pinnacle Fremont CD 7200009572 3/20/2015 3/20/2017 0.0090 1,500,000.00 Electric 051-0000-127.27-02 General Pinnacle Fremont CD 7200009572 3/20/2015 3/20/2017 0.0090 500,000.00 Water 053-0000-126-00-00 Debt Service CD 76116801 14 Pinnacle Fremont CD 7200009574 3/24/2015 3/24/2017 0.0090 250,000.00 Sewer 055-0000-127.27-02 General Pinnacle Fremont CD 7200009574 3/24/2015 3/24/2017 0.0090 250,000.00 Gas 057-0000-126.00-00 Debt Service CD 76108501 17 Pinnacle Fremont CD 7200009573 3/24/2015 3/24/2017 0.0090 175,000.00 Sewer 055-0000-126.00-00 Debt Service 76108501 13 Pinnacle Fremont CD 7200009578 4/6/2015 4/6/2017 0.0090 1,000,000.00 Electric 051-0000-127.27-02 General 37 Pinnacle Fremont CD 7200009579 4/6/2015 4/6/2017 0.0090 1,250,000.00 Gas 057-0000-127.27-02 General 38 Pinnacle Fremont CD 7200009580 4/6/2015 4/6/2017 0.0090 750,000.00 Sewer 055-0000-127.27-02 General 15 Pinnacle Fremont CD 7200009581 4/7/2015 4/7/2017 0.0090 500,000.00 Electric 051-0000-127.27-02 General 1 NebraskaLand Nat'l Bank CD 29525 7/6/2015 7/6/2017 0.0090 1,000,000.00 Electric 051-0000-127.27-02 General 5 Pinnacle Fremont CD 7200009618 8/10/2015 8/10/2017 0.0095 175,000.00 Water 053-0000-126-00-00 Debt Service CD 76108501 First National Bank CD 70048501926 9/19/2016 9/19/2017 0.0105 1,000,000.00 Electric 051-0000-127.27-02 General First National Bank CD 70048502226 9/19/2016 9/19/2017 0.0105 500,000.00 Gas 057-0000-127.27-02 General Nebraskaland National bank CD 29780 9/21/2015 9/21/2017 0.0101 250,000.00 Electric 051-0000-123.00-00 Restricted Trust Fossil 29 NebraskaLand National Bank CD 29779 9/21/2015 9/21/2017 0.0101 846,000.00 Electric 051-0000-126.00-00 Debt Service CD 76115901 Pinnacle Fremont CD 7200009721 10/13/2016 10/13/2017 0.0110 500,000.00 Sewer 055-0000-127.27-02 General 28 Pinnacle Fremont CD 7200009740 11/29/2016 11/29/2017 0.0107 1,000,000.00 Electric 051-0000-127.27-02 General Pinnacle Fremont CD 7200009743 12/7/2016 12/7/2017 0.0111 1,000,000.00 Gas 057-0000-127.27-02 General 19 Pinnacle Fremont CD 7200009752 12/16/2016 12/16/2017 0.0124 500,000.00 Gas 057-0000-127.27-02 General 45 Pinnacle Fremont CD 720000754 12/16/2016 12/16/2017 0.0124 1,250,000.00 Electric 051-0000-127.27-02 General 46 Pinnacle Fremont CD 7200009755 12/16/2016 12/16/2017 0.0124 2,000,000.00 Sewer 055-0000-127.27-02 General 10 Pinnacle Fremont CD 7200009664 3/13/2016 3/13/2018 0.0111 200,000.00 Water 053-0000-126-00-00 Debt Service CD 76111601 11 Pinnacle Fremont CD 7200009665 3/13/2016 3/13/2018 0.0111 1,750,000.00 Electric 051-0000-126-00-00 Debt Service CD 76111601 21 Pinnacle Fremont CD 7200009666 3/16/2016 3/16/2018 0.0111 750,000.00 Electric 051-0000-126.00-00 Debt Service CD 76120501 2 First National Bank Fremont CD 7164222 8/15/2016 8/15/2018 0.0121 250,000.00 Electric 051-0000-121.00-00 Insurance Reserve 3 First National Bank Fremont CD 7164223 8/15/2016 8/15/2018 0.0121 250,000.00 Electric 051-0000-123.00-00 Restricted Trust Fossil 4 First National Bank Fremont CD 7164224 8/15/2016 8/15/2018 0.0121 250,000.00 Electric 051-0000-126.00-00 Debt Service CD 76117501 7 First State Bank CD 11935 65568 8/26/2016 8/26/2018 0.0129 300,000.00 Electric 051-0000-126.00-00 Debt Service CD 76117501 8 First State Bank CD 11935 65567 8/26/2016 8/26/2018 0.0129 300,000.00 Electric 051-0000-126.00-00 Debt Service CD 76117501 27 First State Bank CD 11935 65569 8/26/2016 8/26/2018 0.0129 2,000,000.00 Electric 051-0000-126.00-00 Debt Service CD 76117501 20 Pinnacle Fremont CD 7200009722 10/13/2016 10/13/2018 0.0138 500,000.00 Electric 051-0000-127.27-02 General 39 Pinnacle Fremont CD 7200009720 10/13/2016 10/13/2018 0.0138 1,500,000.00 Electric 051-0000-126.00-00 Debt Service CD 27,196,000.00 Investments by Bank Pinnacle Fremont 20,250,000.00 First National Bank 2,250,000.00 First State Bank 2,600,000.00 Nebraskaland Nat'l Bank 2,096,000.00 27,196,000.00 Page 39 of 39 Agenda Item #8