[PAGE 1] BOARD OF PUBLIC WORKS DEPARTMENT OF UTILITIES February 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 January 25, 2017. 3. Consider Accounts Payable – 1st half of February 2017. 4. Review Statement of Operations and Net Position for November 2016 (staff report). 5. * Consider outside City limits water application for 4749 W Highway 30 (staff report). 6. Investments (staff report). 7. General Manager Update (no board action is requested). a. Annual IT report – Nick Brand b. Legislative bills – public power 8. Adjournment The agenda was posted at the Municipal Building on February 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 38 [PAGE 2] CITY OF FREMONT BOARD OF PUBLIC WORKS JANUARY 25, 2017 - 4:15 P.M. A meeting of the Board of Public Works was held on January 25, 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 January 20, 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, Hoegemeyer, Shelso, and Sawtelle present and Vering as absent; 4 present, 1 absent. Others in attendance included Troy Schaben, Asst. General Manager; Jan Rise, Admin. Services Dir.; Jody Sanders, Finance Dir.; Al Kasper, Dir. Engineering; Larry Andreasen, Water Supt.; Kirk Hillrichs, Gas Sys. Supt.; John Hemschemeyer, Dir. HR; Keith Kontor, WWTP Supt.; and Dean Kavan, Stores Supervisor; and Councilwoman Jacobus. APPROVE MINUTES Moved by Member Behrens and seconded by Member Shelso to approve the minutes of the January 4, 2017 meeting. Motion carried 4-0. CONSIDER ACCOUNTS PAYABLE – 2nd HALF OF JANUARY 2017 Moved by Member Shelso and seconded by Member Behrens to approve accounts payable in the amount of $3,821,492.87. Motion carried 4-0. REVIEW COLLECTIONS REPORT FOR DECEMBER 2017 (ATTACHED). The Board received and reviewed the December 2017 collections report. Moved by Member Shelso and seconded by Member Behrens to accept the report. Motion carried 4-0. APPROVE COST OF SERVICE STUDY PROPOSAL FROM JK ENERGY GROUP (STAFF REPORT). Moved by Member Behrens and seconded by Member Shelso to approve the cost of service study proposal from JK Energy Group for $18,000. Newton said JK Energy completed the cost of service studies for gas and electric in 2015 and recommended we stay with the same firm for water and wastewater. Motion carried 4-0. CONSIDER TRENCHER PURCHASE FROM DITCH WITCH OF OMAHA THROUGH THE NJPA CONTRACT (STAFF REPORT). Moved by Member Hoegemeyer and seconded by Member Shelso to approve the purchase of a RT 45- T4 Compact Trencher with backhoe from Ditch Witch of Omaha through the NJPA contact (Contract No. 031014-CMW) with Ditch Witch for $65,528.13; and forward the recommendation to City Council for approval. Motion carried 4-0. CONSIDER TRUCK PURCHASES (AERIAL AND DIGGER DERRICK) FROM ALTEC THROUGH THE NJPA CONTRACT (STAFF REPORT). Moved by Member Hoegemeyer and seconded by Member Behrens to approve the purchase of a J42A aerial bucket truck and the purchase of a D3060B digger derrick through the NJPA contract (Contract No. 031014-ALT) with Altec for $425,285; and forward the recommendation to City Council for approval. Motion carried 4-0. CONSIDER OUT-OF-STATE EMPLOYEE TRAINING REQUEST (STAFF REPORT). Moved by Member Shelso and seconded by Member Hoegemeyer to approve out-of-state training for Page 2 of 38 1 Agenda Item #2 [PAGE 3] two gas department employees to attend the Iowa Association of Municipal Utilities Gas Measurement Seminar for $5,708 (plus taxes) and for one accounting employee to attend the Government Finance Officers Association Annual Conference for $1,443. Motion carried 4-0. COMMUNITY SOLAR UPDATE (STAFF REPORT). Newton presented proposed program parameters and price structure for a community solar farm. The public has been invited to informational meetings during the Builders Home Show on January 28-29 where Newton will make the presentations. 2015-2016 AUDIT REPORT. Sanders presented a draft report of the 2015-2016 audit. The final audit report will be presented when it is available. INVESTMENTS. Sanders presented the board with information on Department of Utility investments. GENERAL MANAGER UPDATE (NO BOARD ACTION IS REQUESTED). Schaben presented an updated report on strategic plan activities and answered questions. Rise reported dates for employee and key account tours of Unit #8 at the Lon D. Wright power plant. ADJOURNMENT Member Behrens moved and Member Shelso seconded the motion to adjourn the meeting at 5:38 p.m. Motion carried 4-0. ______________________________ _______________________________ Allen Sawtelle, Chairman Toni Vering, Secretary _______________________ ______________________ ______________________ Dennis Behrens David Shelso Erik Hoegemeyer Page 3 of 38 2 Agenda Item #2 [PAGE 4] PREPARED 01/31/2017 9:38:41 EXPENDITURE APPROVAL LIST PROGRAM: GM339L REPORT PARAMETER SELECTIONS EAL DESCRIPTION: EAL: 01312017 ANDERSEND PAYMENT TYPES Checks . . . . . . . . . . . . . . . . . . . . . Y EFTs . . . . . . . . . . . . . . . . . . . . . . Y ePayables . . . . . . . . . . . . . . . . . . . Y VOUCHER SELECTION CRITERIA Voucher/discount due date . . . . . . . . . . . 01/31/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/04 Payment date . . . . . . . . . . . . . . . . . . 01/31/2017 Page 4 of 38 Agenda Item #3 [PAGE 5] PREPARED 01/31/2017, 9:38:41 EXPENDITURE APPROVAL LIST PAGE 1 PROGRAM: GM339L AS OF: 01/31/2017 PAYMENT DATE: 01/31/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 GTR SALES 000065133 UT 00 01/24/2017 051-0000-143.00-00 FINAL BILL REFUND 150.35 VENDOR TOTAL * 150.35 9999999 00 HARTER, DYLAN J 000071309 UT 00 01/24/2017 051-0000-143.00-00 FINAL BILL REFUND 69.54 VENDOR TOTAL * 69.54 9999999 00 KRUSE, MATTHEW J & TILARA L 000070919 UT 00 01/24/2017 051-0000-143.00-00 FINAL BILL REFUND 165.22 VENDOR TOTAL * 165.22 9999999 00 LESSIG, LAURA L 000063441 UT 00 11/08/2016 051-0000-143.00-00 FINAL BILL REFUND CHECK #: 81786 122.97- VENDOR TOTAL * .00 122.97- 9999999 00 LESSIG, LAURA L 000063441 UT 00 01/31/2017 051-0000-143.00-00 FINAL BILL REFUND 122.97 VENDOR TOTAL * 122.97 9999999 00 REINERT, DAN L 000018527 UT 00 01/24/2017 051-0000-143.00-00 FINAL BILL REFUND 146.18 VENDOR TOTAL * 146.18 9999999 00 SMITH, BRIANNA M 000070445 UT 00 01/24/2017 051-0000-143.00-00 FINAL BILL REFUND 9.23 VENDOR TOTAL * 9.23 0003109 00 UPS 5E9752047 00 01/31/2017 051-5001-940.60-79 1/28/17 Serv Chrg Share 12.90 5E9752047 00 01/31/2017 051-5001-917.60-79 1/28/17 Serv Chrg Share 12.90 5E9752047 00 01/31/2017 053-6105-502.50-23 Water Samples 35.59 VENDOR TOTAL * 61.39 9999999 00 WHITE, SHAELI 000070531 UT 00 01/24/2017 051-0000-143.00-00 FINAL BILL REFUND 126.28 VENDOR TOTAL * 126.28 HAND ISSUED TOTAL *** 122.97- TOTAL EXPENDITURES **** 851.16 122.97- GRAND TOTAL ******************** 728.19 Page 5 of 38 Agenda Item #3 [PAGE 6] DEPARTMENT OF UTILITIES ELECTRONIC WITHDRAWAL LIST FOR BOARD OF PUBLIC WORKS MEETING: 2/8/17 AJ WITHDRAWAL WITHDRAWAL GROUP NO VENDOR NAME DATE ACCOUNT NO ITEM DESCRIPTION AMOUNT 5932 TSYS MERCHANT SOLUTIONS 02/03/17 051-5001-903-60-77 CREDIT CARD FEES 1,901.62 5932 TSYS MERCHANT SOLUTIONS 02/03/17 051-5001-903-60-77 CREDIT CARD FEES 5,250.17 TOTAL EXPENDITURES 7,151.79 Page 6 of 38 M:\Accounts Payable\DU\DU Electronic Withdrawals\2-8-17 Agenda Item #3 [PAGE 7] PREPARED 02/03/2017 12:41:19 EXPENDITURE APPROVAL LIST PROGRAM: GM339L REPORT PARAMETER SELECTIONS EAL DESCRIPTION: EAL: 02032017 ANDERSEND PAYMENT TYPES Checks . . . . . . . . . . . . . . . . . . . . . Y EFTs . . . . . . . . . . . . . . . . . . . . . . Y ePayables . . . . . . . . . . . . . . . . . . . Y VOUCHER SELECTION CRITERIA Voucher/discount due date . . . . . . . . . . . 02/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/05 Payment date . . . . . . . . . . . . . . . . . . 02/09/2017 Page 7 of 38 Agenda Item #3 [PAGE 8] PREPARED 02/03/2017,12:41:19 EXPENDITURE APPROVAL LIST PAGE 1 PROGRAM: GM339L AS OF: 02/09/2017 PAYMENT DATE: 02/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 ------------------------------------------------------------------------------------------------------------------------------------ 0002981 00 A & D TECHNICAL SUPPLY CO INC 0000246092 PI2268 00 02/09/2017 057-8205-870.50-35 PO NUM 044909 3,105.00 VENDOR TOTAL * 3,105.00 0000959 00 ACE HARDWARE 99384/3 PI2214 00 02/09/2017 051-5001-940.50-35 PO NUM 043953 85.57 99436/3 PI2286 00 02/09/2017 051-5001-940.50-35 PO NUM 043953 24.09 VENDOR TOTAL * 109.66 0004276 00 AIRGAS USA LLC 9059565954 PI2235 00 02/09/2017 051-0000-154.00-00 PO NUM 045018 EFT: 332.48 9059279078 PI2119 00 02/09/2017 051-5105-502.50-35 PO NUM 043494 EFT: 276.30 9059606660 PI2285 00 02/09/2017 051-5105-502.50-35 PO NUM 043494 EFT: 386.82 9059606661 PI2295 00 02/09/2017 051-5105-502.50-35 PO NUM 044934 EFT: 173.48 VENDOR TOTAL * .00 1,169.08 0003124 00 ALLIED ELECTRONICS INC 9007172230 PI2138 00 02/09/2017 051-5001-940.50-35 PO NUM 044955 EFT: 19.54 9007172230 PI2139 00 02/09/2017 051-5001-940.60-79 PO NUM 044955 EFT: 6.95 VENDOR TOTAL * .00 26.49 0001549 00 ALLIED OIL & TIRE CO INC 206868-00 PI2141 00 02/09/2017 051-5105-502.50-48 PO NUM 044981 113.34 206868-00 PI2142 00 02/09/2017 051-5105-502.60-61 PO NUM 044981 180.16 VENDOR TOTAL * 293.50 0002612 00 ALTEC INDUSTRIES INC 10688376 PI2201 00 02/09/2017 051-5205-580.50-48 PO NUM 044957 156.10 10688376 PI2202 00 02/09/2017 051-5205-580.60-79 PO NUM 044957 17.36 VENDOR TOTAL * 173.46 0004585 00 AMERICAN BROADBAND INTERNET 51262 0217 PI2291 00 02/09/2017 051-5001-922.50-53 PO NUM 044176 195.00 VENDOR TOTAL * 195.00 0004242 00 ARBOR DAY FOUNDATION 8646828027 2017PI2111 00 02/09/2017 051-5205-580.60-67 PO NUM 044985 15.00 VENDOR TOTAL * 15.00 0004904 00 ATLAS COPCO COMPRESSORS LLC 811238 PI2279 00 02/09/2017 051-0000-153.00-00 PO NUM 044988 4,067.33 VENDOR TOTAL * 4,067.33 0002637 00 BABCOCK & WILCOX CO (DIAMOND POWER) 491585 PI2282 00 02/09/2017 051-0000-153.00-00 PO NUM 045048 835.71 VENDOR TOTAL * 835.71 0003660 00 BAUER BUILT INC 880049548 PI2088 00 02/09/2017 051-5205-580.50-48 PO NUM 044738 236.39 880049548 PI2089 00 02/09/2017 051-5205-580.60-61 PO NUM 044738 27.68 Page 8 of 38 Agenda Item #3 [PAGE 9] PREPARED 02/03/2017,12:41:19 EXPENDITURE APPROVAL LIST PAGE 2 PROGRAM: GM339L AS OF: 02/09/2017 PAYMENT DATE: 02/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 ------------------------------------------------------------------------------------------------------------------------------------ 0003660 00 BAUER BUILT INC VENDOR TOTAL * 264.07 0002768 00 BEARING HEADQUARTERS CO 5182577 PI2307 00 02/09/2017 051-0000-153.00-00 PO NUM 045017 EFT: 183.14 5182578 PI2308 00 02/09/2017 051-0000-153.00-00 PO NUM 045017 EFT: 235.66 5183150 PI2309 00 02/09/2017 051-0000-153.00-00 PO NUM 045017 EFT: 445.63 VENDOR TOTAL * .00 864.43 0003545 00 BOMGAARS SUPPLY INC 16205882 PI2236 00 02/09/2017 051-5001-940.50-35 PO NUM 043954 53.49 16206584 PI2237 00 02/09/2017 051-5001-940.50-35 PO NUM 043954 117.66 VENDOR TOTAL * 171.15 0001011 00 C & J UPHOLSTERY 011817 PI2112 00 02/09/2017 051-5105-502.60-61 PO NUM 044986 55.00 VENDOR TOTAL * 55.00 0004518 00 CAPPEL AUTO SUPPLY INC 205945 PI2093 00 02/09/2017 051-5001-940.50-35 PO NUM 044872 587.43 206045 PI2099 00 02/09/2017 051-5001-940.50-35 PO NUM 044919 502.88 206381 PI2256 00 02/09/2017 051-5001-940.50-35 PO NUM 043990 145.23 206470 PI2258 00 02/09/2017 051-5001-940.50-35 PO NUM 043990 75.44 206487 PI2259 00 02/09/2017 051-5001-940.50-35 PO NUM 043990 110.78 206685 PI2262 00 02/09/2017 051-5001-940.50-35 PO NUM 043990 175.44 206221 PI2271 00 02/09/2017 051-5001-940.50-35 PO NUM 044975 380.67 206090 PI2082 00 02/09/2017 051-5105-502.50-35 PO NUM 043990 6.59 206684 PI2261 00 02/09/2017 051-5105-502.50-48 PO NUM 043990 84.73 206144 PI2083 00 02/09/2017 051-5205-580.50-48 PO NUM 043990 55.03 206249 PI2252 00 02/09/2017 051-5205-580.50-48 PO NUM 043990 132.44 206253 PI2253 00 02/09/2017 051-5205-580.50-48 PO NUM 043990 234.20 206323 PI2254 00 02/09/2017 051-5205-580.50-48 PO NUM 043990 19.26- 206404 PI2257 00 02/09/2017 051-5205-580.50-48 PO NUM 043990 173.31 206558 PI2260 00 02/09/2017 051-5205-580.50-48 PO NUM 043990 72.34 206579 PI2315 00 02/09/2017 051-5205-580.50-35 PO NUM 043990 25.82 206580 PI2316 00 02/09/2017 051-5205-580.50-35 PO NUM 043990 7.66 206380 PI2255 00 02/09/2017 053-6205-583.50-48 PO NUM 043990 185.10 VENDOR TOTAL * 2,935.83 0003512 00 CDW GOVERNMENT INC GPC4412 PI2269 00 02/09/2017 051-5105-502.50-35 PO NUM 044935 EFT: 40.26 GPC4412 PI2270 00 02/09/2017 051-5105-502.60-79 PO NUM 044935 EFT: 15.04 VENDOR TOTAL * .00 55.30 0000584 00 CEI FEB 17 WC 00 02/09/2017 051-5001-919.20-29 Feb 2017 Worker Comp EFT: 25,000.00 VENDOR TOTAL * .00 25,000.00 0004615 00 CENTRAL PLAINS ENERGY PROJECT*WIRE* 011712A197 00 02/09/2017 057-8205-807.50-02 Jan'17 Dth 352,274.70 Page 9 of 38 Agenda Item #3 [PAGE 10] PREPARED 02/03/2017,12:41:19 EXPENDITURE APPROVAL LIST PAGE 3 PROGRAM: GM339L AS OF: 02/09/2017 PAYMENT DATE: 02/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 ------------------------------------------------------------------------------------------------------------------------------------ 0004615 00 CENTRAL PLAINS ENERGY PROJECT*WIRE* VENDOR TOTAL * 352,274.70 0002951 00 CENTRAL STATES GROUP 1308856-00 PI2086 00 02/09/2017 051-5105-502.50-35 PO NUM 044722 18.01 1308856-00 PI2087 00 02/09/2017 051-5105-502.60-79 PO NUM 044722 21.40 VENDOR TOTAL * 39.41 0002675 00 CENTURYLINK 4027272600 0117PI2124 00 02/09/2017 051-5001-922.50-53 PO NUM 043996 48.12 4027272606 0117PI2125 00 02/09/2017 051-5001-922.50-53 PO NUM 043996 408.72 4027272654 0117PI2126 00 02/09/2017 051-5001-922.50-53 PO NUM 043996 48.48 VENDOR TOTAL * 505.32 0004659 00 CLARITUS INC IN261855 PI2207 00 02/09/2017 051-5001-903.60-65 PO NUM 045032 4,751.87 VENDOR TOTAL * 4,751.87 0004266 00 CLEAR IMAGE SIGNS & GRAPHICS 2938 PI2322 00 02/09/2017 051-5001-903.50-35 PO NUM 044884 78.11 2938 PI2323 00 02/09/2017 051-5001-903.60-61 PO NUM 044884 71.69 VENDOR TOTAL * 149.80 0001041 00 CRESCENT ELECTRIC SUPPLY CO (OMAHA) S502997585-002 PI2179 00 02/09/2017 051-0000-153.00-00 PO NUM 044794 46.31 S502996849-001 PI2091 00 02/09/2017 051-5001-940.50-35 PO NUM 044831 145.77 S502996849-001 PI2092 00 02/09/2017 051-5001-940.60-79 PO NUM 044831 25.04 VENDOR TOTAL * 217.12 0004480 00 CSI SOUTH SIDE PRESS 24172 PI2208 00 02/09/2017 051-5001-903.50-31 PO NUM 045040 178.69 VENDOR TOTAL * 178.69 0002739 00 DAKOTA RIGGERS & TOOL SUPPLY INC 0427354-IN PI2211 00 02/09/2017 051-0000-154.00-00 PO NUM 045019 EFT: 198.76 VENDOR TOTAL * .00 198.76 0002897 00 DIERS INC 6004845/1 PI2108 00 02/09/2017 051-5105-502.50-48 PO NUM 044958 EFT: 62.18 6004845/1 PI2109 00 02/09/2017 051-5105-502.60-61 PO NUM 044958 EFT: 253.44 5002480 PI2064 00 02/09/2017 051-5205-580.50-48 PO NUM 043958 EFT: 26.70 VENDOR TOTAL * .00 342.32 0001070 00 DODGE COUNTY REGISTER OF DEEDS 012317 PI2121 00 02/09/2017 057-8205-870.60-77 PO NUM 043969 16.00 VENDOR TOTAL * 16.00 0004212 00 DOWNTOWN RENTAL CENTER INC 1259 PI2330 00 02/09/2017 051-5001-903.50-35 PO NUM 045045 10.50 VENDOR TOTAL * 10.50 0002880 00 DUNRITE INC Page 10 of 38 Agenda Item #3 [PAGE 11] PREPARED 02/03/2017,12:41:19 EXPENDITURE APPROVAL LIST PAGE 4 PROGRAM: GM339L AS OF: 02/09/2017 PAYMENT DATE: 02/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 ------------------------------------------------------------------------------------------------------------------------------------ 0002880 00 DUNRITE INC B724124 PI2171 00 02/09/2017 051-5105-502.50-35 PO NUM 044936 34.41 VENDOR TOTAL * 34.41 0003091 00 DUTTON-LAINSON CO 752035-2 PI2116 00 02/09/2017 051-0000-154.00-00 PO NUM 044854 EFT: 12.01 S89322-2 PI2177 00 02/09/2017 051-0000-154.00-00 PO NUM 044502 EFT: 1,497.66 S89324-1 PI2178 00 02/09/2017 051-0000-154.00-00 PO NUM 044502 EFT: 233.26 VENDOR TOTAL * .00 1,742.93 0004605 00 DXP ENTERPRISES INC 48530872 PI2278 00 02/09/2017 051-0000-154.00-00 PO NUM 044797 EFT: 491.92 48530875 PI2280 00 02/09/2017 051-0000-154.00-00 PO NUM 044997 EFT: 768.64 48530880 PI2281 00 02/09/2017 051-0000-154.00-00 PO NUM 045041 EFT: 159.21 VENDOR TOTAL * .00 1,419.77 0003087 00 EAKES OFFICE SOLUTIONS 7166363-0 PI2324 00 02/09/2017 051-5001-940.50-35 PO NUM 044924 131.47 VENDOR TOTAL * 131.47 0001444 00 ELECTRICAL ENGINEERING & EQUIPMENT 4948491-00 PI2137 00 02/09/2017 053-6105-502.50-35 PO NUM 044913 EFT: 319.95 VENDOR TOTAL * .00 319.95 0004551 00 ELEMETAL FABRICATION LLC 21708 PI2123 00 02/09/2017 053-6105-502.50-35 PO NUM 043975 55.85 VENDOR TOTAL * 55.85 0005017 00 EMBROIDERY CONNECTION 37576 PI2167 00 02/09/2017 053-6205-583.50-35 PO NUM 044893 105.83 VENDOR TOTAL * 105.83 0002050 00 FASTENAL CO NEFRE143282 PI2065 00 02/09/2017 051-5001-940.50-35 PO NUM 043960 EFT: 74.09 VENDOR TOTAL * .00 74.09 0001132 00 FREMONT WINNELSON CO 298474 00 PI2132 00 02/09/2017 053-6105-502.50-35 PO NUM 044770 732.82 298474 00 PI2133 00 02/09/2017 053-6105-502.60-79 PO NUM 044770 12.00 299619 00 PI2120 00 02/09/2017 053-6205-583.50-35 PO NUM 043961 20.33 VENDOR TOTAL * 765.15 0001140 00 GETZSCHMAN HEATING LLC 259474 PI2231 00 02/09/2017 051-5105-502.50-35 PO NUM 045051 150.00 259474 PI2232 00 02/09/2017 051-5105-502.60-61 PO NUM 045051 310.00 VENDOR TOTAL * 460.00 0001143 00 GLASS HOUSE 52034 PI2194 00 02/09/2017 051-5001-932.50-35 PO NUM 044798 1,826.60 52034 PI2195 00 02/09/2017 051-5001-932.60-61 PO NUM 044798 1,687.02 Page 11 of 38 Agenda Item #3 [PAGE 12] PREPARED 02/03/2017,12:41:19 EXPENDITURE APPROVAL LIST PAGE 5 PROGRAM: GM339L AS OF: 02/09/2017 PAYMENT DATE: 02/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 ------------------------------------------------------------------------------------------------------------------------------------ 0001143 00 GLASS HOUSE 52034 PI2196 00 02/09/2017 051-5001-932.60-76 PO NUM 044798 946.38 VENDOR TOTAL * 4,460.00 0004677 00 GOVCONNECTION INC 54441433 PI2090 00 02/09/2017 051-5001-922.50-42 PO NUM 044766 EFT: 1,312.70 54449875 PI2131 00 02/09/2017 051-5001-922.50-42 PO NUM 044766 EFT: 166.15 VENDOR TOTAL * .00 1,478.85 0002804 00 GOVERNMENT FINANCE OFFICERS ASSN CONF DEP-GOEBEL 00 02/09/2017 051-0000-173.00-00 Denver Conf Dep-D Goebel 100.00 VENDOR TOTAL * 100.00 0001445 00 GRAYBAR ELECTRIC CO 989584581 PI2277 00 02/09/2017 051-0000-154.00-00 PO NUM 044504 301.80 989559646 PI2223 00 02/09/2017 051-5205-580.50-35 PO NUM 044843 1,368.93 989545487 PI2224 00 02/09/2017 055-7105-512.50-35 PO NUM 044920 219.26 VENDOR TOTAL * 1,889.99 0004707 00 GREAT PLAINS COMMUNICATIONS INC 4020010078 0117PI2160 00 02/09/2017 051-5001-922.50-53 PO NUM 044192 149.00 4020010078 0117PI2161 00 02/09/2017 051-5001-922.60-65 PO NUM 044192 500.00 4020010078 0117PI2162 00 02/09/2017 055-7105-502.60-76 PO NUM 044192 229.00 VENDOR TOTAL * 878.00 0004386 00 GREAT PLAINS GOVERNMENT FINANCE 1548 GOEBEL PI2192 00 02/09/2017 051-5001-920.60-67 PO NUM 044692 50.00 1550 SANDERS PI2193 00 02/09/2017 051-5001-920.60-67 PO NUM 044692 50.00 VENDOR TOTAL * 100.00 0003155 00 HACH COMPANY 10275263 PI2097 00 02/09/2017 053-6105-502.50-35 PO NUM 044914 1,549.58 10275263 PI2098 00 02/09/2017 053-6105-502.60-79 PO NUM 044914 66.39 10290250 PI2296 00 02/09/2017 055-7105-502.50-52 PO NUM 045000 2,741.49 10290250 PI2297 00 02/09/2017 055-7105-512.50-35 PO NUM 045000 245.52 10291500 PI2325 00 02/09/2017 055-7105-512.50-35 PO NUM 045000 125.00 VENDOR TOTAL * 4,727.98 0004419 00 HANSEN TIRE LLC 17715 PI2068 00 02/09/2017 053-6205-583.50-48 PO NUM 043963 183.43 17715 PI2069 00 02/09/2017 053-6205-583.60-61 PO NUM 043963 24.00 17763 PI2240 00 02/09/2017 053-6205-583.50-48 PO NUM 043963 182.27 17763 PI2241 00 02/09/2017 053-6205-583.60-61 PO NUM 043963 25.16 17710 PI2066 00 02/09/2017 057-8205-870.50-48 PO NUM 043963 1.58 17710 PI2067 00 02/09/2017 057-8205-870.60-61 PO NUM 043963 15.00 VENDOR TOTAL * 431.44 0004573 00 HAYS COMPANIES 331987 00 02/09/2017 051-0000-165.00-00 Property Prem 11/27/16-17 30,705.62 349138 00 02/09/2017 051-0000-165.00-00 Broker Fee 11/27/16-17 6,800.00 Page 12 of 38 Agenda Item #3 [PAGE 13] PREPARED 02/03/2017,12:41:19 EXPENDITURE APPROVAL LIST PAGE 6 PROGRAM: GM339L AS OF: 02/09/2017 PAYMENT DATE: 02/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 ------------------------------------------------------------------------------------------------------------------------------------ 0004573 00 HAYS COMPANIES 331987 00 02/09/2017 053-0000-165.00-00 Property Prem 11/27/16-17 11,514.60 349138 00 02/09/2017 053-0000-165.00-00 Broker Fee 11/27/16-17 2,550.00 331987 00 02/09/2017 055-0000-165.00-00 Property Prem 11/27/16-17 11,514.60 349138 00 02/09/2017 055-0000-165.00-00 Broker Fee 11/27/16-17 2,550.00 331987 00 02/09/2017 057-0000-165.00-00 Property Prem 11/27/16-17 23,029.21 349138 00 02/09/2017 057-0000-165.00-00 Broker Fee 11/27/16-17 5,100.00 VENDOR TOTAL * 93,764.03 0001492 00 HD ELECTRIC COMPANY 515780 PI2165 00 02/09/2017 051-5205-580.60-61 PO NUM 044332 357.28 515780 PI2166 00 02/09/2017 051-5205-580.60-79 PO NUM 044332 10.33 VENDOR TOTAL * 367.61 0004152 00 HD SUPPLY WATERWORKS LTD G601485 PI2056 00 02/09/2017 053-0000-154.00-00 PO NUM 044807 4,698.97 VENDOR TOTAL * 4,698.97 0002794 00 HDR ENGINEERING INC 1200032533 PI2283 00 02/09/2017 051-5105-502.60-61 PO NUM 033491 2,701.35 1200032533 PI2284 00 02/09/2017 051-5105-502.60-61 PO NUM 033491 4,396.26 1200031327 PI2150 00 02/09/2017 053-6205-583.60-61 PO NUM 043936 8,660.26 1200031327 PI2151 00 02/09/2017 055-7205-583.60-61 PO NUM 043936 8,660.26 VENDOR TOTAL * 24,418.13 0000322 00 HERCULES INDUSTRIES INC 96172 PI2115 00 02/09/2017 051-0000-154.00-00 PO NUM 044746 EFT: 991.50 VENDOR TOTAL * .00 991.50 0004188 00 HUNTEL COMMUNICATIONS 226910 PI2157 00 02/09/2017 051-5001-922.60-61 PO NUM 043997 214.00 226917 PI2158 00 02/09/2017 051-5001-922.60-61 PO NUM 043997 58.86 VENDOR TOTAL * 272.86 0001167 00 HY-VEE 344669 PI2169 00 02/09/2017 051-5105-502.50-35 PO NUM 044926 1,811.98 344669 PI2170 00 02/09/2017 051-5105-502.60-79 PO NUM 044926 80.25 VENDOR TOTAL * 1,892.23 0004599 00 IBT INC 6945212 PI2209 00 02/09/2017 051-0000-154.00-00 PO NUM 044796 EFT: 2,194.61 6945213 PI2225 00 02/09/2017 051-5105-502.50-35 PO NUM 044925 EFT: 146.93 6945213 PI2226 00 02/09/2017 051-5105-502.60-79 PO NUM 044925 EFT: 26.75 VENDOR TOTAL * .00 2,368.29 0004838 00 IML NORTH AMERICA LLC 12278 PI2134 00 02/09/2017 051-5205-580.60-61 PO NUM 044873 376.29 VENDOR TOTAL * 376.29 0000205 00 INGERSOLL RAND COMPANY Page 13 of 38 Agenda Item #3 [PAGE 14] PREPARED 02/03/2017,12:41:19 EXPENDITURE APPROVAL LIST PAGE 7 PROGRAM: GM339L AS OF: 02/09/2017 PAYMENT DATE: 02/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 ------------------------------------------------------------------------------------------------------------------------------------ 0000205 00 INGERSOLL RAND COMPANY 23825634 PI2057 00 02/09/2017 051-0000-153.00-00 PO NUM 044879 99.13 VENDOR TOTAL * 99.13 0003483 00 INTERSTATE CHEMCIAL CO INC 265648 PI2213 00 02/09/2017 051-5105-502.50-52 PO NUM 042699 2,840.34 VENDOR TOTAL * 2,840.34 0003074 00 JACKSON SERVICES INC 20170112 PR0112 00 02/09/2017 051-0000-241.00-00 PAYROLL SUMMARY EFT: 194.96 20170126 PR0126 00 02/09/2017 051-0000-241.00-00 PAYROLL SUMMARY EFT: 194.96 567 - 013117 00 02/09/2017 051-5001-932.50-46 Jan Mats EFT: 14.98 567 - 013117 00 02/09/2017 051-5001-940.50-46 Jan Mops/Misc Washings EFT: 6.91 567 - 013117 00 02/09/2017 051-5001-940.20-29 Jan Uniforms/Whse EFT: 69.18 1110 - 013117 00 02/09/2017 051-5001-932.50-46 Jan Mats/Mops/Towels EFT: 212.00 1110 - 013117 00 02/09/2017 051-5001-940.50-46 Jan Mats EFT: 528.96 567 - 013117 00 02/09/2017 051-5105-502.50-46 Jan Mops EFT: 82.40 567 - 013117 00 02/09/2017 051-5105-502.20-29 Jan Uniforms EFT: 1,121.07 1110 - 013117 00 02/09/2017 051-5105-502.50-46 Jan Mats EFT: 442.28 567 - 013117 00 02/09/2017 051-5205-580.20-29 Jan Uniforms/Elect Distr EFT: 1,276.92 567 - 013117 00 02/09/2017 051-5205-580.20-29 Jan Uniforms/Engineers EFT: 74.16 567 - 013117 00 02/09/2017 053-6205-583.20-29 Jan Uniforms EFT: 296.91 567 - 013117 00 02/09/2017 055-7105-502.20-29 Jan Uniforms EFT: 141.78 1110 - 013117 00 02/09/2017 055-7105-502.50-46 Jan Mats/Mops EFT: 99.52 567 - 013117 00 02/09/2017 057-8205-870.20-29 Jan Uniforms EFT: 819.40 VENDOR TOTAL * .00 5,576.39 0004205 00 JCI INDUSTRIES INC 8134558 PI2210 00 02/09/2017 051-0000-153.00-00 PO NUM 044982 672.03 VENDOR TOTAL * 672.03 0000614 00 JERRY'S ELECTRIC INC L01-023-2017 PI2187 00 02/09/2017 051-5205-580.60-61 PO NUM 044368 137.50 VENDOR TOTAL * 137.50 0005021 00 JONES AUTOMOTIVE INC 1-24777 PI2113 00 02/09/2017 051-5205-580.50-48 PO NUM 044994 107.82 1-24777 PI2114 00 02/09/2017 051-5205-580.60-61 PO NUM 044994 302.21 VENDOR TOTAL * 410.03 0004502 00 KEEP FREMONT BEAUTIFUL INC 012317 PI2143 00 02/09/2017 051-5001-919.60-61 PO NUM 044999 4,000.00 VENDOR TOTAL * 4,000.00 0003085 00 KELLY SUPPLY CO 11117467-0 PI2305 00 02/09/2017 051-0000-153.00-00 PO NUM 044939 EFT: 208.41 VENDOR TOTAL * .00 208.41 0005023 00 KENNY PRODUCTS INC 150215 PI2326 00 02/09/2017 051-5001-903.50-35 PO NUM 045009 287.50 Page 14 of 38 Agenda Item #3 [PAGE 15] PREPARED 02/03/2017,12:41:19 EXPENDITURE APPROVAL LIST PAGE 8 PROGRAM: GM339L AS OF: 02/09/2017 PAYMENT DATE: 02/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 ------------------------------------------------------------------------------------------------------------------------------------ 0005023 00 KENNY PRODUCTS INC VENDOR TOTAL * 287.50 0002902 00 KRIZ-DAVIS CO S101479870-003 PI2145 00 02/09/2017 051-0000-154.00-00 PO NUM 044853 EFT: 64.20 S101483953-001 PI2146 00 02/09/2017 051-0000-153.00-00 PO NUM 044938 EFT: 143.38 S101486492-001 PI2147 00 02/09/2017 051-0000-154.00-00 PO NUM 044959 EFT: 51.90 S101488473-001 PI2148 00 02/09/2017 051-0000-154.00-00 PO NUM 044987 EFT: 195.28 S101488473-002 PI2306 00 02/09/2017 051-0000-154.00-00 PO NUM 044987 EFT: 585.83 S101492505-001 PI2310 00 02/09/2017 051-0000-154.00-00 PO NUM 045063 EFT: 160.87 S101479522-001 PI2070 00 02/09/2017 051-5105-502.50-35 PO NUM 043965 EFT: 14.15 S101453683-001 PI2130 00 02/09/2017 051-5105-502.50-35 PO NUM 044627 EFT: 3,948.30 S101488605-001 PI2242 00 02/09/2017 051-5205-580.50-35 PO NUM 043965 EFT: 93.03 S101491371-002 PI2152 00 02/09/2017 053-6105-502.50-35 PO NUM 043965 EFT: 29.92 S101487158-001 PI2071 00 02/09/2017 055-7105-512.50-35 PO NUM 043965 EFT: 199.58 S101492944-001 PI2215 00 02/09/2017 055-7105-512.50-35 PO NUM 043965 EFT: 199.95 S101495537-001 PI2311 00 02/09/2017 055-7105-512.50-35 PO NUM 043965 EFT: 125.70 VENDOR TOTAL * .00 5,812.09 0001215 00 LOU'S SPORTING GOODS AAX765961-AX04 PI2222 00 02/09/2017 053-6205-583.50-95 PO NUM 044775 394.56 VENDOR TOTAL * 394.56 0000480 00 MALLOY ELECTRIC 6115742 PI2190 00 02/09/2017 051-5105-502.50-35 PO NUM 044427 4,855.00 VENDOR TOTAL * 4,855.00 0004976 00 MARCO TECHNOLOGIES LLC INV3964944 PI2085 00 02/09/2017 051-5001-920.60-65 PO NUM 044364 122.23 VENDOR TOTAL * 122.23 0002052 00 MATHESON LINWELD 14761510 PI2144 00 02/09/2017 051-0000-153.00-00 PO NUM 044625 EFT: 3,716.22 14742601 PI2073 00 02/09/2017 051-5105-502.50-35 PO NUM 043967 EFT: 97.81 14742665 PI2074 00 02/09/2017 051-5105-502.50-35 PO NUM 043967 EFT: 195.29 14761514 PI2153 00 02/09/2017 051-5105-502.50-35 PO NUM 043967 EFT: 15.10 14761517 PI2154 00 02/09/2017 051-5105-502.50-35 PO NUM 043967 EFT: 115.59 14761556 PI2155 00 02/09/2017 051-5105-502.50-35 PO NUM 043967 EFT: 53.30 14795983 PI2312 00 02/09/2017 051-5105-502.50-35 PO NUM 043967 EFT: 114.89 14796034 PI2313 00 02/09/2017 051-5105-502.50-35 PO NUM 043967 EFT: 17.49 14742596 PI2072 00 02/09/2017 051-5205-580.50-35 PO NUM 043967 EFT: 154.15 VENDOR TOTAL * .00 4,479.84 0000667 00 MCMASTER-CARR SUPPLY CO 98874273 PI2118 00 02/09/2017 051-0000-154.00-00 PO NUM 044976 59.28 10019115 PI2234 00 02/09/2017 051-0000-154.00-00 PO NUM 045013 108.14 98874273 PI2140 00 02/09/2017 051-5001-940.60-79 PO NUM 044976 9.36 VENDOR TOTAL * 176.78 0001229 00 MENARDS - FREMONT Page 15 of 38 Agenda Item #3 [PAGE 16] PREPARED 02/03/2017,12:41:19 EXPENDITURE APPROVAL LIST PAGE 9 PROGRAM: GM339L AS OF: 02/09/2017 PAYMENT DATE: 02/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 ------------------------------------------------------------------------------------------------------------------------------------ 0001229 00 MENARDS - FREMONT 23574 PI2063 00 02/09/2017 051-0000-154.00-00 PO NUM 044977 217.49 23573 PI2077 00 02/09/2017 051-5001-940.50-35 PO NUM 043970 23.61 23793 PI2122 00 02/09/2017 051-5001-922.50-42 PO NUM 043970 26.04 23867 PI2245 00 02/09/2017 051-5001-940.50-35 PO NUM 043970 32.09 24191 PI2287 00 02/09/2017 051-5001-903.50-35 PO NUM 043970 32.08 24191 PI2287 00 02/09/2017 051-5001-932.50-35 PO NUM 043970 28.76 23057 PI2243 00 02/09/2017 051-5105-502.50-35 PO NUM 043970 246.46 24045 PI2246 00 02/09/2017 051-5105-502.50-35 PO NUM 043970 180.59 23801 PI2244 00 02/09/2017 051-5205-580.50-35 PO NUM 043970 25.66 23576 PI2078 00 02/09/2017 053-6105-502.50-35 PO NUM 043970 5.42 23866 PI2156 00 02/09/2017 053-6105-502.50-35 PO NUM 043970 36.09 23904 PI2216 00 02/09/2017 053-6105-502.50-35 PO NUM 043970 28.82 23498 PI2076 00 02/09/2017 053-6205-583.50-35 PO NUM 043970 38.46 22987 PI2075 00 02/09/2017 055-7105-512.50-35 PO NUM 043970 51.90 VENDOR TOTAL * 973.47 0004953 00 MERRITT TRAILERS INC R014073 PI2274 00 02/09/2017 051-5001-940.50-35 PO NUM 044995 143.40 VENDOR TOTAL * 143.40 0004883 00 MISSISSIPPI LIME COMPANY 1300889 00 02/09/2017 051-0000-158.02-00 1/27/17 23.75 TN EFT: 4,066.77 1299676 00 02/09/2017 051-0000-158.02-00 1/19/17 25.20 TN EFT: 4,315.06 1301890 00 02/09/2017 051-0000-158.02-00 2/02/17 25.54 TN EFT: 4,381.39 VENDOR TOTAL * .00 12,763.22 0001486 00 MOTION INDUSTRIES INC NE01-459453 PI2058 00 02/09/2017 051-0000-153.00-00 PO NUM 044880 121.01 VENDOR TOTAL * 121.01 0002985 00 MSC INDUSTRIAL SUPPLY CO INC C56705187 PI2062 00 02/09/2017 051-0000-154.00-00 PO NUM 044956 EFT: 620.25 C56705187 PI2107 00 02/09/2017 051-5001-940.50-35 PO NUM 044956 EFT: 171.92 60695717 PI2303 00 02/09/2017 051-5001-940.50-35 PO NUM 045055 EFT: 141.92 60695727 PI2304 00 02/09/2017 051-5001-940.50-35 PO NUM 045055 EFT: 224.51 56529457 PI2191 00 02/09/2017 053-6205-583.50-35 PO NUM 044610 EFT: 57.99- VENDOR TOTAL * .00 1,100.61 0003095 00 MUNICIPAL SUPPLY INC OF OMAHA 0647642-IN PI2264 00 02/09/2017 053-6205-583.50-35 PO NUM 044599 4,088.17 VENDOR TOTAL * 4,088.17 0001958 00 NEBR PUBLIC HEALTH ENVIRONMENTAL 484513 PI2129 00 02/09/2017 053-6105-502.60-61 PO NUM 044530 EFT: 786.00 VENDOR TOTAL * .00 786.00 0003052 00 NEBRASKA DEPT OF LABOR - BOILER 104354 PI2175 00 02/09/2017 051-5001-932.60-61 PO NUM 045010 138.00 VENDOR TOTAL * 138.00 0001473 00 NMC EXCHANGE LLC Page 16 of 38 Agenda Item #3 [PAGE 17] PREPARED 02/03/2017,12:41:19 EXPENDITURE APPROVAL LIST PAGE 10 PROGRAM: GM339L AS OF: 02/09/2017 PAYMENT DATE: 02/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 ------------------------------------------------------------------------------------------------------------------------------------ 0001473 00 NMC EXCHANGE LLC CUI335327 PI2061 00 02/09/2017 051-0000-153.00-00 PO NUM 044948 626.44 CUI335327 PI2104 00 02/09/2017 051-5105-502.50-35 PO NUM 044948 103.36 CUI335327 PI2105 00 02/09/2017 051-5105-502.50-48 PO NUM 044948 898.80 CUI335327 PI2106 00 02/09/2017 051-5105-502.50-48 PO NUM 044948 2,212.53 CUI338343 PI2298 00 02/09/2017 055-7105-512.50-35 PO NUM 045022 33.32 CUI338853 PI2299 00 02/09/2017 055-7105-512.50-35 PO NUM 045022 330.09 CUI338856 PI2300 00 02/09/2017 055-7105-512.50-35 PO NUM 045022 443.64 CUI338864 PI2301 00 02/09/2017 055-7105-512.50-35 PO NUM 045022 124.62 CUI337998 PI2327 00 02/09/2017 055-7105-512.50-35 PO NUM 045022 27.43 CUI340590 PI2328 00 02/09/2017 055-7105-512.50-35 PO NUM 045022 96.48 VENDOR TOTAL * 4,896.71 0003136 00 NORTHERN NATURAL GAS CO *FNB WIRE* 254675 JAN 2017 00 02/09/2017 057-8205-807.50-02 223,500.13 VENDOR TOTAL * 223,500.13 0002054 00 NORTHWEST ELECTRIC LLC 0188649 PI2136 00 02/09/2017 055-7105-512.60-61 PO NUM 044901 825.00 VENDOR TOTAL * 825.00 0001710 00 NUTS & BOLTS INC 551286 PI2233 00 02/09/2017 051-0000-154.00-00 PO NUM 045003 55.95 VENDOR TOTAL * 55.95 0002937 00 O'KEEFE ELEVATOR CO INC 00452203 PI2163 00 02/09/2017 051-5001-932.60-65 PO NUM 044245 184.66 00452203 PI2164 00 02/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-431364 PI2212 00 02/09/2017 051-0000-153.00-00 PO NUM 045028 478.85 0397-431329 PI2250 00 02/09/2017 051-5001-940.50-35 PO NUM 043973 82.86 0397-431331 PI2251 00 02/09/2017 051-5001-940.50-35 PO NUM 043973 158.68 0397-429678 PI2079 00 02/09/2017 051-5105-502.50-35 PO NUM 043973 9.60 0397-430860 PI2217 00 02/09/2017 051-5105-502.50-48 PO NUM 043973 214.81 0397-431164 PI2218 00 02/09/2017 051-5105-502.50-35 PO NUM 043973 69.98 0397-431171 PI2219 00 02/09/2017 051-5105-502.50-35 PO NUM 043973 126.02- 0397-431554 PI2220 00 02/09/2017 051-5105-502.50-35 PO NUM 043973 22.36 0397-431756 PI2314 00 02/09/2017 051-5105-502.50-48 PO NUM 043973 191.14 0397-430037 PI2247 00 02/09/2017 051-5205-580.50-35 PO NUM 043973 20.06 0397-431197 PI2249 00 02/09/2017 051-5205-580.50-48 PO NUM 043973 119.09 0397-430306 PI2248 00 02/09/2017 057-8205-870.50-48 PO NUM 043973 41.82 VENDOR TOTAL * 1,283.23 0002888 00 OFFICENET 860649-0 PI2096 00 02/09/2017 051-5001-940.50-40 PO NUM 044910 133.03 861197-0 PI2172 00 02/09/2017 051-5001-940.50-40 PO NUM 044962 138.99 862538-0 PI2206 00 02/09/2017 051-5001-922.50-40 PO NUM 044970 66.33 861778-0 PI2275 00 02/09/2017 051-5001-903.50-40 PO NUM 045004 194.35 Page 17 of 38 Agenda Item #3 [PAGE 18] PREPARED 02/03/2017,12:41:19 EXPENDITURE APPROVAL LIST PAGE 11 PROGRAM: GM339L AS OF: 02/09/2017 PAYMENT DATE: 02/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 ------------------------------------------------------------------------------------------------------------------------------------ 0002888 00 OFFICENET 862035-0 PI2288 00 02/09/2017 051-5001-926.60-61 PO NUM 043998 294.38 862078-0 PI2329 00 02/09/2017 051-5105-502.50-40 PO NUM 045031 460.16 862465-0 PI2263 00 02/09/2017 051-5205-580.60-65 PO NUM 044440 99.44 861971-0 PI2302 00 02/09/2017 053-6105-502.50-40 PO NUM 045024 266.43 VENDOR TOTAL * 1,653.11 0002946 00 OMAHA PUBLIC POWER DISTRICT 2462853776 0117 00 02/09/2017 051-5105-502.60-65 Jan '17 SPP Participation EFT: 8,882.50 1115740525 0117 00 02/09/2017 051-5305-560.60-76 Jan 2017 Interconnection EFT: 4,285.88 VENDOR TOTAL * .00 13,168.38 0001624 00 OMAHA VALVE & FITTING CO 4139461 PI2198 00 02/09/2017 051-5105-502.50-35 PO NUM 044941 910.04 4139461 PI2199 00 02/09/2017 051-5105-502.60-79 PO NUM 044941 19.11 VENDOR TOTAL * 929.15 0001268 00 P & H ELECTRIC INC 116263 PI2110 00 02/09/2017 053-6105-502.50-35 PO NUM 044966 68.48 VENDOR TOTAL * 68.48 0003414 00 PEERLESS ENERGY SYSTEMS LLC 39297 PI2117 00 02/09/2017 055-0000-154.00-00 PO NUM 044891 140.38 VENDOR TOTAL * 140.38 0003827 00 PEST PRO'S INC MNCP BLD 012417PI2293 00 02/09/2017 051-5001-932.60-61 PO NUM 044194 42.80 ASHPD 012317 PI2317 00 02/09/2017 051-5105-502.60-61 PO NUM 044208 48.15 CMBTTUR 012317 PI2318 00 02/09/2017 051-5105-502.60-61 PO NUM 044208 53.50 PWR PLT 013017 PI2319 00 02/09/2017 051-5105-502.60-61 PO NUM 044208 85.60 SUBSTA 013017 PI2294 00 02/09/2017 051-5205-580.60-61 PO NUM 044218 190.35 WTR PLT 012417 PI2290 00 02/09/2017 053-6105-502.60-61 PO NUM 044137 69.55 WWTP 012417 PI2292 00 02/09/2017 055-7105-502.60-61 PO NUM 044189 110.00 VENDOR TOTAL * 599.95 0001279 00 PETTY CASH 011917 PI2084 00 02/09/2017 051-5105-502.50-35 PO NUM 043999 36.00 VENDOR TOTAL * 36.00 0004800 00 PINNACLE BANK - VISA 335459/N ROYUK PI2265 00 02/09/2017 051-5205-580.60-62 PO NUM 044785 250.00 335461/A KASPARPI2266 00 02/09/2017 051-5205-580.60-62 PO NUM 044785 250.00 335462/MENKING PI2267 00 02/09/2017 051-5205-580.60-62 PO NUM 044785 250.00 VENDOR TOTAL * 750.00 0001627 00 PIPING RESOURCES INC 0246862-IN PI2060 00 02/09/2017 051-0000-153.00-00 PO NUM 044943 47.71 0246862-IN PI2102 00 02/09/2017 051-5105-502.50-35 PO NUM 044943 65.65 0246862-IN PI2103 00 02/09/2017 051-5105-502.60-79 PO NUM 044943 13.03 VENDOR TOTAL * 126.39 0002793 00 PLIBRICO COMPANY LLC Page 18 of 38 Agenda Item #3 [PAGE 19] PREPARED 02/03/2017,12:41:19 EXPENDITURE APPROVAL LIST PAGE 12 PROGRAM: GM339L AS OF: 02/09/2017 PAYMENT DATE: 02/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 ------------------------------------------------------------------------------------------------------------------------------------ 0002793 00 PLIBRICO COMPANY LLC 97071 PI2320 00 02/09/2017 051-5001-932.50-35 PO NUM 044711 239.30 97071 PI2321 00 02/09/2017 051-5001-932.60-61 PO NUM 044711 1,890.00 VENDOR TOTAL * 2,129.30 0004696 00 PRIME COMMUNICATIONS INC 40996 PI2200 00 02/09/2017 051-5001-922.60-61 PO NUM 044952 8,560.00 41097 PI2276 00 02/09/2017 051-5001-950.80-50 PO NUM 045033 7,592.65 VENDOR TOTAL * 16,152.65 0004728 00 PRIORITY ONE SIGNS 454 PI2331 00 02/09/2017 051-5001-903.60-61 PO NUM 045080 40.00 454 PI2332 00 02/09/2017 051-5001-903.60-78 PO NUM 045080 47.08 VENDOR TOTAL * 87.08 0004499 00 QUATRED LLC 53982 PI2100 00 02/09/2017 051-5001-940.50-35 PO NUM 044931 240.61 53982 PI2101 00 02/09/2017 051-5001-940.60-79 PO NUM 044931 15.00 VENDOR TOTAL * 255.61 0003639 00 R&S TRACK MAINTENANCE INC 017014 PI2174 00 02/09/2017 051-5105-502.60-61 PO NUM 044979 EFT: 300.00 VENDOR TOTAL * .00 300.00 0002876 00 RAWHIDE CHEMOIL INC 759820 PI2168 00 02/09/2017 053-6105-502.50-35 PO NUM 044917 352.78 VENDOR TOTAL * 352.78 0003059 00 REAMS SPRINKLER SUPPLY CO S1338277-001 PI2059 00 02/09/2017 051-0000-154.00-00 PO NUM 044922 EFT: 855.02 VENDOR TOTAL * .00 855.02 0003036 00 SHAFFER COMMUNICATIONS INC 17-0067 PI2094 00 02/09/2017 051-5105-502.50-35 PO NUM 044882 419.45 17-0067 PI2095 00 02/09/2017 051-5105-502.60-79 PO NUM 044882 16.05 VENDOR TOTAL * 435.50 0001308 00 SHERWIN-WILLIAMS CO 2238-8 PI2197 00 02/09/2017 053-6105-502.50-35 PO NUM 044933 407.47 VENDOR TOTAL * 407.47 0000429 00 SKARSHAUG TESTING LABORATORY INC 214953 PI2185 00 02/09/2017 051-5205-580.60-61 PO NUM 043994 231.40 214953 PI2186 00 02/09/2017 051-5205-580.60-79 PO NUM 043994 95.29 215003 PI2227 00 02/09/2017 051-5205-580.50-35 PO NUM 044930 2,249.16 215003 PI2228 00 02/09/2017 051-5205-580.60-61 PO NUM 044930 25.49 VENDOR TOTAL * 2,601.34 0002023 00 SOLUTIONONE 464890 PI2159 00 02/09/2017 051-5001-903.60-65 PO NUM 044126 263.76 Page 19 of 38 Agenda Item #3 [PAGE 20] PREPARED 02/03/2017,12:41:19 EXPENDITURE APPROVAL LIST PAGE 13 PROGRAM: GM339L AS OF: 02/09/2017 PAYMENT DATE: 02/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 VENDOR TOTAL * 263.76 0003923 00 STATE OF NEBRASKA - CELLULAR 1046805 00 02/09/2017 051-5001-903.50-53 Cellular EFT: 104.37 1046805 00 02/09/2017 051-5001-926.50-53 Safety Mgr Cellular EFT: 57.53 1046805 00 02/09/2017 051-5105-502.50-53 Cellular EFT: 138.28 1046805 00 02/09/2017 051-5205-580.50-53 Engineers Cellular EFT: 230.12 1046805 00 02/09/2017 051-5205-580.50-53 Elect Distr Cellular EFT: 414.66 1046805 00 02/09/2017 053-6105-502.50-53 Cellular EFT: 57.53 1046805 00 02/09/2017 053-6205-583.50-53 Cellular EFT: 166.55 1046805 00 02/09/2017 055-7105-502.50-53 Cellular EFT: 22.52 1046805 00 02/09/2017 057-8205-870.50-53 Cellular EFT: 207.07 VENDOR TOTAL * .00 1,398.63 0000434 00 STOVER CO, RS INV-478721 PI2181 00 02/09/2017 051-0000-153.00-00 PO NUM 044963 981.97 INV-478721 PI2182 00 02/09/2017 051-0000-153.00-00 PO NUM 044963 122.07 INV-478626 PI2127 00 02/09/2017 051-5105-502.50-35 PO NUM 044465 595.99 INV-478626 PI2128 00 02/09/2017 051-5105-502.60-79 PO NUM 044465 6.28 INV-478722 PI2183 00 02/09/2017 057-8205-870.50-35 PO NUM 043275 396.04 INV-478722 PI2184 00 02/09/2017 057-8205-870.60-79 PO NUM 043275 10.17 VENDOR TOTAL * 2,112.52 0003891 00 SUNGARD PUBLIC SECTOR INC 132015 PI2188 00 02/09/2017 051-5001-903.60-77 PO NUM 044387 EFT: 239.43 132015 PI2189 00 02/09/2017 051-5001-917.60-77 PO# 044387 EFT: 12.60 VENDOR TOTAL * .00 252.03 0004754 00 TOTAL TOOL SUPPLY INC 08557628 PI2135 00 02/09/2017 051-5105-502.60-61 PO NUM 044881 59.92 VENDOR TOTAL * 59.92 0004515 00 TRACTOR SUPPLY CREDIT PLAN 260959 PI2080 00 02/09/2017 051-5001-940.50-35 PO NUM 043982 177.52 261171 PI2081 00 02/09/2017 057-8205-870.50-35 PO NUM 043982 103.77 VENDOR TOTAL * 281.29 0004045 00 UNITED RENTALS (NORTH AMERICA) INC 143602612-001 PI2229 00 02/09/2017 053-6205-583.50-35 PO NUM 044969 56.97 VENDOR TOTAL * 56.97 0000647 00 USABLUEBOOK 159565 PI2272 00 02/09/2017 051-5105-502.50-35 PO NUM 044980 65.90 159565 PI2273 00 02/09/2017 051-5105-502.60-79 PO NUM 044980 8.74 VENDOR TOTAL * 74.64 0004336 00 WATERLINK INC 10730 PI2203 00 02/09/2017 051-5105-502.50-52 PO NUM 044967 2,785.29 10730 PI2204 00 02/09/2017 051-5105-502.50-52 PO NUM 044967 728.88 Page 20 of 38 Agenda Item #3 [PAGE 21] PREPARED 02/03/2017,12:41:19 EXPENDITURE APPROVAL LIST PAGE 14 PROGRAM: GM339L AS OF: 02/09/2017 PAYMENT DATE: 02/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 ------------------------------------------------------------------------------------------------------------------------------------ 0004336 00 WATERLINK INC 10730 PI2205 00 02/09/2017 051-5105-502.50-52 PO NUM 044967 1,945.30 VENDOR TOTAL * 5,459.47 0000482 00 WESCO RECEIVABLES CORP 807116 PI2149 00 02/09/2017 051-0000-154.00-00 PO NUM 044998 EFT: 128.40 807644 PI2176 00 02/09/2017 051-0000-154.00-00 PO NUM 043952 EFT: 190.46 807492 PI2180 00 02/09/2017 051-0000-154.00-00 PO NUM 044832 EFT: 47.08 VENDOR TOTAL * .00 365.94 0004135 00 WINDOW PRO INC 31033 PI2221 00 02/09/2017 051-5001-932.60-61 PO NUM 044095 EFT: 10.70 31063 PI2289 00 02/09/2017 051-5001-932.60-61 PO NUM 044095 EFT: 117.70 VENDOR TOTAL * .00 128.40 0004119 00 WINDSTREAM OF THE MIDWEST INC 4027272600 0117PI2230 00 02/09/2017 051-5001-922.50-53 PO NUM 045046 30.55 VENDOR TOTAL * 30.55 EFT/EPAY TOTAL *** 83,246.72 TOTAL EXPENDITURES **** 796,609.94 83,246.72 GRAND TOTAL ******************** 879,856.66 Page 21 of 38 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: February 6, 2017 SUBJECT: Statement of Operations and Net Position for November 2016 Recommendation: Review Statement of Operations and Net Position for November 2016 Background: The financial and operating statements for November are presented for your review. Typically we skip reporting October separately each year, as those statements are prepared several months after October, and the year-to-date data is the same as the single month data. In the following analysis, I will include comments relating to both October and November activity in explaining the year-to-date results. This month represents the second-month mark of the City’s fiscal year, or 16.67% 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 44% of the Change in Net Position budgeted for the fiscal year, compared to 28.5% last YTD. Off system sales are $330,000 more than last year, accounting for much of the increase in revenue. Both Operating and Nonoperating expenses were also higher, with depreciation expense on both the Air Quality Control System (AQCS) and the Unit 8 precipitator generating the largest increase. Interest income also increased significantly, as two-year investments matured during the two months. Other expenses are within budgeted amounts for the year, and overall, margins improved in both months and on a YTD basis. October 2016 included the vacation and sick leave payouts to both the former Director of Electrical Engineering and the Utilities General Manager. E-1: Production reports reflect the increase in Off system sales, with increased generation and fuel use. Page 22 of 38 Agenda Item #4 [PAGE 23] Staff Report, page 2 Statement of Operations and Net Position for November 2016 February 6, 2017 E-2: Cash balance remains solid, as revenues increased more than expenditures, accounting for the current month increase of $447,532 increase in Electric fund cash balance for November. October cash decreased $1,816,347, driven by a $1 million progress payment to Fagen on the AQCS project, as well as some debt service payments and three coal shipments paid. Water Fund: Finance Activity: YTD this fund has recognized 48% of the budgeted Change in Net Position for 2017. Revenues and consumption were up in October, driven by Commercial billings, but November revenues were down slightly, with residential services down $9,000. YTD expenses for departments came in under budget. 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: November total water pumped was up 12.5%, 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 10%, with 7 percent of unexplained difference year to date. W-2: Cash increased $125,624 for the period, due in part to a receipts from the increased October revenues. Wastewater Fund: Finance Activity: YTD this fund has recognized 107% of the budgeted Change in Net Position for 2017. Commercial revenue was down $32,000 in October, but rebounded and was $56,000 higher than last year in November. Nonoperating revenue increase is from the Biosolids application program, with the offsetting cost included in production expense. Expenses are all within budget. S-1: Volumes are 1.7% more year to year, with the 12-month rolling average costs remaining just over $1.00 per 1,000 gal of input. Cash and investment balances increased $121,670 in October and $200,104 in November, as receipts outpaced expenditures each 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 $436,000 YTD, only slightly better than 2016’s start. Expense categories came in at or below budget, led by a $75,000 YTD increase in gas purchase expense. G-1: The inventory level was level for October and November, with gas prices moving upward. Cash balances have decreased $276,013 in October and $292,154 in November as we finished injecting natural gas for the season. 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 23 of 38 Agenda Item #4 [PAGE 24] Page 24 of 38 Agenda Item #4 [PAGE 25] Page E-1 ELECTRIC SYSTEM Statement of Operations For the Month Ended 11/30/2016 CURRENT YEAR PRIOR YEAR Production Data: Current Month Y-T-D Current Month Y-T-D GENERATION: Gross Generation in M's 52,232 95,483 44,524 82,928 Less Plant Use 4,458 8,090 3,917 7,474 Net Generation 47,774 87,393 40,608 75,454 Purchased from other Utilities 2,465 4,497 2,575 9,940 Less sales to other Utilities 17,389 26,918 9,287 18,287 System Net Output 32,850 64,971 33,896 67,107 LOCAL LOAD PEAKS: Gross System Output, KW 67,650 67,730 Gross System Output, Date 30-Nov-16 30-Nov-15 Gross System Output, Time 6:00 PM 7:00 PM System Net Output, KW 60,900 62,550 System Net Output, Date 30-Nov-16 30-Nov-15 System Net Output, Time 6:00 PM 7:00 PM MISCELLANEOUS BTU Per KWH, Gross Generation 11,210 10,900 BTU Per KWH, Net Generation 12,250 11,950 Load Factor, Gross Generation 0.766 0.775 Load Factor, Net Generation 0.749 0.753 FUEL USE: Coal, Tons 32,031 56,041 26,670 50,620 Natural gas, Mcf 15,914 38,422 16,610 34,264 Propane, Gallons FUEL EXPENSE IN DOLLARS: Coal $ 890,022 $ 1,561,592 $ 766,717 $ 1,460,367 Natural gas $ 63,658 $ 156,614 $ 64,447 $ 132,943 Propane $ - $ - $ - $ - Total $ 953,680 $ 1,718,206 $ 831,165 $ 1,593,310 AVERAGE EXPENSE Per KWH Fuel, Gross Generation $0.01826 $0.01867 Fuel, Net Generation $0.01996 $0.02047 Production, Net Generation $0.04126 $0.0383 $0.04134 $0.03865 INVENTORIES IN DOLLARS: Propane $ 12,400 $ 12,400 Fuel Oil $ 30,228 $ 30,228 Coal $ 2,891,930 $ 3,288,954 Production supplies $ 2,841,400 $ 2,858,855 Distribution supplies $ 1,525,599 $ 1,513,149 Gasboy $ 21,482 $ 31,673 Total $ 7,323,040 $ 7,735,258 COAL INVENTORY 104,077 114,406 2/6/2017 Page 25 of 38 Agenda Item #4 [PAGE 26] Page E-2 City of Fremont Department of Utilities Electric Fund Cash Transactions For the Month Ended 11/30/2016 Beginning Disburse- balance Receipts ments Ending balance Cash $ 3,564,641 $ 4,304,817 $ (3,904,722) $ 3,964,735 A. Offset cash $ 229,756 204,429 (157,138) $ 277,048 A. Petty Cash/drawers $ 2,300 - - $ 2,300 A. Money Market Accounts $ 1,020,644 104 - $ 1,020,748 A. Bond proceeds $ 509,186 42 - $ 509,228 B. Unrestricted CD $ 11,500,000 1,000,000 (1,000,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,272,527 $ 5,509,392 $ (5,061,860) $ 25,720,058 net change 447,532 Totals Per Stmt of net position Unrestricted cash A. $ 5,264,831 $ 5,264,831 $ - Restricted cash B. $ 509,228 $ 509,228 $ - 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,720,058 $ 25,720,058 $ - Page 26 of 38 Agenda Item #2/46/2017 [PAGE 27] Page 27 of 38 Agenda Item #4 [PAGE 28] Page W-1 WATER SYSTEM Statement of Operations For the Month Ended 11/30/2016 Current Year Prior Year PRODUCTION DATA: Current Month Current Month TOTAL WATER PUMPED In 1,000 Gallons: 99,364 88,356 Plant II Bypass: 1,036 - PEAKS: Peak Flow - Gallons/Minutes 7,307 6,568 - Date 28-Nov-16 3-Nov-15 - Time 11:35 AM 8:20 AM Peak Day - 1,000 Gallons 4 ,496 4,286 - Date 2-Nov-16 3-Nov-15 Avg. Day - 1,000 Gallons 3,312 2,945 COST PER 1,000 GALLONS PUMPED: YTD YTD Average Electric Cost $0.0830 $0.0830 Average Production Cost $0.3364 $0.2441 $0.3636 $0.2727 Average Kilowatts Used 0.986 0.927 October Production Data/November Sales Data Previous Previous Month % OF TOTAL GALLONS PUMPED: month Y-T-D CURRENT YEAR - M-GALLONS % M-GALLONS % Total Sales 109,169 87% 245,056 73% Bulk Water Sales 2 0% 32 0% Systems Use 1,158 1% 2,915 1% Plant II Bypass 3,370 3% 65,182 19% Unmetered 310 0% 614 0% Difference 12,049 10% 22,526 7% Total Water Pumped 126,059 100% 336,325 100% PRIOR YEAR Total Sales 120,784 78% 260,555 71% Bulk Water Sales 98 0% 196 0% Systems Use 1,674 1% 3,321 1% Plant II Bypass 25,777 17% 87,589 24% Unmetered 991 1% 991 0% Difference 5,957 4% 14,161 4% Total Water Pumped 155,281 100% 366,813 100% 12-month rolling average production cost per 1,000 gallons pumped: $0.2010 $0.2112 2/6/2017 Page 28 of 38 Agenda Item #4 [PAGE 29] Page W-2 City of Fremont Department of Utilities Water Fund Cash Transactions For the Month Ended 11/30/2016 Beginning Disburse- balance Receipts ments Ending balance Cash $ 1,120,872 $ 279,663 $ (154,207) $ 1,246,328 A. Money Market Accounts $ 746,867 168 $ 747,035 A. Unrestricted CD $ - $ - B. Investments Debt Service CDs $ 875,000 $ 875,000 C. Total $ 2,742,739 $ 279,831 $ (154,207) $ 2,868,363 net change 125,624 Totals Per Stmt of net position Unrestricted cash A. $ 1,993,363 $ 1,983,667 $ 9,696 Restricted cash A. $ - $ 9,696 $ (9,696) Unrestricted investments B. $ - $ - $ - Restricted investments C. $ 875,000 $ 875,000 $ - Ending balance $ 2,868,363 $ 2,868,363 $ (0) Page 29 of 38 Agenda Item #2/46/2017 [PAGE 30] Page 30 of 38 Agenda Item #4 [PAGE 31] Page S-1 SEWAGE SYSTEM Statement of Operations/Finance Activity For the Month Ended 11/30/2016 CURRENT YEAR PRIOR YEAR TREATMENT PLANT: Current Month Y T D Current Month Y T D Input in 1,000 Gallons 123,980 256,360 133,185 269,337 Minimum Flow 3,210 6,520 3,361 6,821 Maximum Flow 4,620 9,420 6,500 11,580 Peak Hour Flow 4,100 7,200 6,900 7,000 Average Day 4,130 8,400 4,440 8,830 Gas Produced - 1,000 Cubic Feet 3,930 7,936 3,483 7,020 Propane Used - Gallons - - - - Treatment Cost/ 1,000 Gallons 1.7772 1.4015 1.5187 1.2801 12-month rolling avg production cost/1,000 gal. input: 1.0303 1.5226 Inventory in Dollars $ 136,347 $ 128,481 Sewer Fund Cash Transactions For the Month Ended 11/30/2016 Beginning Disburse- balance Receipts ments Ending balance Cash $ 2,018,934 $ 495,281 $ (295,216) $ 2 ,218,999 A. Money Market Accounts $ 304,465 38 - $ 304,503 A. Unrestricted CD Investments $ 5,200,000 - - $ 5 ,200,000 B. Debt Service CDs $ 175,000 - - $ 175,000 C. Total $ 7,698,399 $ 495,319 $ (295,216) $ 7,898,503 net change 200,104 Totals Per Stmt of net position Unrestricted cash $ 2,523,503 A. $ 2,523,503 $ - Unrestricted investments $ 5,200,000 B. $ 5,097,655 $ 1 02,345 Restricted investments $ 175,000 C. $ 277,345 $ (102,345) Ending balance $ 7,898,503 $ 7,898,503 $ - 2/6/2017 Page 31 of 38 Agenda Item #4 [PAGE 32] Page 32 of 38 Agenda Item #4 [PAGE 33] Page G-1 GAS SYSTEM Statement of Operations/Finance Activity For the Month Ended 11/30/2016 CURRENT YEAR PRIOR YEAR GAS SYSTEM: Current Month Y T D Current Month Y T D Gas volume delivered (Mmbtu) 222,318 424,538 310,044 538,310 Gas Available for Sale 222,318 424,538 310,044 538,310 Cost of Gas / Mmbtu 2.66652 3.12750 A 2.46813 2.32687 Gas Use / Day / Mmbtu 7,411 10,335 Gas Cost / Day 19,760.500 25,507.600 Gas Storage in Mcf 291,176 291,256 Natural Gas inventory $ 936,005 $ 852,058 Other inventory $ 480,256 $ 493,898 Total inventory $ 1,416,261 $ 1,345,956 A. YTD is calculation using adjusted Gas Purchase Expense YTD/Gas Available for Sale YTD. Gas Fund Cash Transactions For the Month Ended 11/30/2016 Beginning Disburse- Ending balance Receipts ments balance Cash $ 410,848 $ 693,220 $ (985,592) $ 118,476 A. Money Market Accounts $ 1,726,607 218 - $ 1,726,826 A. Unrestricted CD Investments $ 3,750,000 - - $ 3,750,000 B. Debt Service CDs $ 250,000 - - $ 250,000 C. Total $ 6,137,455 $ 693,439 $ (985,592) $ 5,845,302 net change (292,154) Totals Per Stmt of net position Unrestricted cash $ 1,845,302 A. $ 1,845,302 $ - Unrestricted investments $ 3,750,000 B. $ 4,000,000 $ (250,000) Restricted investments $ 250,000 C. $ - $ 250,000 Ending balance $ 5,845,302 $ 5,845,302 $ - 2/6/2017 Page 33 of 38 Agenda Item #4 [PAGE 34] CITY OF FREMONT, NEBRASKA Statement of Net Position - Proprietary Funds November 30, 2016 Nov Enterprise Funds Electric Water Sewer Gas Fund Fund Fund Fund Total ASSETS Current assets: Cash and cash equivalents $ 5,264,831 $ 1,983,667 $ 2,523,503 $ 1,845,302 $ 11,617,302 Investments 12,316,175 - 5,097,655 4,000,000 21,413,830 Receivables Accounts, net of allowance for doubtful accounts 1,170,039 263,032 178,385 376,184 1,987,640 Budget billing balance ( 277,048) - - - (277,048) Unbilled revenue 2,300,058 235,075 392,058 541,447 3,468,638 Due from other funds 3 2,532 3,580 6 06 1,725 38,442 Due from other governments - - - - - Interest 193,548 10,026 51,995 39,780 295,349 Inventory 7,323,040 366,811 136,347 1,416,261 9,242,459 Prepaid expenses 118,064 11,700 18,404 23,057 171,224 Total current assets 28,441,239 2,873,891 8,398,952 8,243,755 47,957,837 Noncurrent assets: Restricted cash and cash equivalents 509,228 9,696 - - 518,924 Restricted investments 7,629,825 875,000 277,345 - 8,782,170 Unamortized bond discount 4 6,123 - - - 46,123 Capital assets Land 2,086,695 1,890,618 143,803 116,340 4,237,456 Construction in progress 2,596,414 155,290 182,310 161,717 3,095,730 Depreciable capital assets 202,183,514 39,988,357 50,740,022 15,883,510 308,795,402 Less Accumulated depreciation ( 95,603,648) (16,493,085) (24,848,949) (10,766,272) (147,711,955) Net capital assets 111,262,974 25,541,180 26,217,185 5,395,295 168,416,634 Total noncurrent assets 119,448,149 26,425,876 26,494,530 5,395,295 177,763,850 Total assets 147,889,388 29,299,767 34,893,483 13,639,050 225,721,687 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 19,226 - 180,597 resources LIABILITIES Current liabilities: Accounts payable 792,040 22,529 40,513 800,675 1,655,757 Due to other funds - - - - - Accrued payroll - - - - - Sales tax payable 164,152 291 - 894 165,337 Accrued interest payable 562,489 31,009 2 ,806 - 596,304 Customer deposits 536,455 - 5 01 - 536,956 Warranty reserve surge protection 5 ,794 - - - 5,794 Current portion of long-term obligations 2,507,356 635,434 312,211 - 3,455,001 Total current liabilities 4,568,287 689,263 356,030 801,569 6,415,149 Noncurrent liabilities: Fly Ash liability 6 1,371 - - - 61,371 Compensated absences 1,047,139 51,503 94,155 265,370 1,458,168 Unamortized bond premium 1,918,215 45,856 - - 1,964,071 Noncurrent portion of long-term obligations 56,054,670 5,644,934 1,795,395 - 63,494,999 Total noncurrent liabilities 59,081,396 5,742,293 1,889,550 265,370 66,978,609 Total liabilities 63,649,682 6,431,556 2,245,580 1,066,939 73,393,758 Deferred Inflows of Resources Deferred gain on bond refundings 4 21 425 2 38 - 1,084 Total Deferred inlfows of 4 21 425 2 38 - 1,084 resources NET POSITION Invested in capital assets, net 50,400,192 19,211,493 24,125,999 5,395,295 99,132,979 Restricted for: Debt service 7,191,196 884,696 277,345 - 8,353,237 Fly Ash disposal 438,629 - - - 438,629 Unrestricted 26,343,093 2,799,143 8,263,546 7,176,816 44,582,598 Total net position $ 84,373,110 $ 22,895,332 $ 32,666,890 $ 12,572,110 $ 152,507,442 Page 34 of 38 Agenda Item #4 [PAGE 35] STAFF REPORT TO: Honorable Mayor City Council and Board of Public Works FROM: Brian Newton, General Manager DATE: August 30, 2016 SUBJECT: Outside City limits water/sewer connection to 1804 Old Highway 8. Recommendation: Approve the resolution granting the Department of Utilities General Manager authorization to make an outside City Limits water/sewer connection for MBEE, LLC at 1804 Old Highway 8. BACKGROUND: The Municipal Code requires the City Council approve water and sewer connections to property located outside the City limits and that the appropriate connection fees be charged. An outside corporate limits application for water and sewer service has been requested by MBEE, LLC at 1804 Old Highway 8. Water line: A domestic/fire 6-inch line service is requested to the property. Charges associated with this connection are: a $5,000 connection fee, approximately $3,500 for material to tap the main line, $600 one-time tap fee, and a $50 inspection fee. The construction is also subject to a permit from Dodge County for construction in County Right of Way. Sewer line: An existing 8-inch main line will be extended approximately 350-feet by the applicant, so other than $40 inspection fee, no other costs will be assessed. FISCAL IMPACT: none, costs are assessed/incurred by the applicant. Page 35 of 38 Agenda Item #5 [PAGE 36] Page 36 of 38 Agenda Item #5 [PAGE 37] Page 37 of 38 Agenda Item #5 [PAGE 38] Page 38 of 38 Agenda Item #5