The URL can be used to link to this page

10/15/2018-CC-Agenda Packet-RegularBANGER *TEXAS AGENDA CITY COUNCIL REGULAR MEETING MONDAY, OCTOBER 15, 2018 7:00 PM 502 ELM STREET SANGER, TEXAS 1. Call Meeting to Order, Invocation, Pledge of Allegiance. 2. CITIZEN INPUT: (Citizens are allowed 3 minutes to speak. The City Council is unable to respond or to discuss any issues brought up during this section). 3. CONSENT AGENDA: No Items — Minutes to be Provided on the November 5, 2018 Agenda. REGULAR AGENDA 4. Introduction of Economic Development Director, Shani Bradshaw. 5. INFORMATION ITEMS: a. Monthly Financial Report — August 31, 2018. (P-2) b. All American Dogs Report — September 2018. (P-13) c. AP Disbursement Report— September 2018. (P-14) d. Atmos Energy Rider GCR — Rate Filing under Docket No. 10170. (P-36) e. Atmos Energy Tariff Revision. (P-38) f. Atmos Energy Notice Regarding Petition for DeNovo Review of the Statement of Intent Filed by Atmos Energy Corporation Mid -Tex Division. (P-46) 6. FUTURE AGENDA ITEMS: (The purpose of this item is to allow the Mayor and members of Council to bring forward items they wish to discuss at a future meeting, A Council Member may inquire about a subject for which notice has not been given. A statement of specific factual information or the recitation of existing policy maybe given. Any deliberation shall be limited to a proposal to place the subject on an agenda for a subsequent meeting. Items may be placed on a future meeting agenda with a consensus of the Council or at the call of the Mayor). 7. ADJOURN. I, the undersigned authority, do hereby certify that this Notice of Meeting was posted on the City Website, and on the bulletin board, at the City Hall of the City of Sanger, Texas, a place convenient and readily acce [e to he general public at all times. Said notice was posted on the following date and time: �CeeP(. at !bind remained posted continuously for at least 72 hours prior to the scheduled time of said me s4 V c(f%iu posted until meeting is adjourned. C eryl e City Secretary G City of anger, Texas F Thisfacility is wheelchair accessible anil��f�i e�st�(l t,{(kph spaces are available. Requests for accommodations or interpretive services must be made 48 ho�l/fs+pxit3��o this meeting. Please contact the City Secretary's office at (940) 458-7930 for further information. SANGER *TEXAS MONTHLY FINANCIAL REPORT August 31, 2018 This is the financial report forthe period ended August 31, 2018. Revenues and expenditures reflect activity from October 1, 2017 through August 31, 2018 or ninety-two percent (92%) of the fiscal year. GENERAL FUND • The General Fund has collected one hundred and two percent (102%) of projected revenues. Revenues are performing within projections with the excepton of Municipal Court fines and Miscellaneous Revenues, which are performing under projections. • Year to date General Fund expenditures are eight -two percent (82%) of the annual budget. All expenditure categories are within projections. ENTERPRISE FUND • The Enterprise Fund has collected ninety-three percent (93%) of projected revenues. All revenue categories are performing within projections. • Yearto date Enterprise Fund expenditures are ninety-three percent (93%) of the annual budget. Waste Water Department expenditures are at 100% of budget and are projected to exceed the annual budget before the end of the year. All other departments are within projections. Combined General & Enterprise Fund Expenditures by Classification Expenditure Category AnnualBudget Expenditures & Percent of Encumbrances Budget Salaries & Benefits $ 5,835,353 $ 4,667,405 80% Supplies & Materials 589,754 444,181 75% Maintenance & Operations 7,151,972 6,919,123 97% Contract Services 1,609,536 1,550,672 96% Utilities 530,550 400,380 75% Capital Expenses 875,815 629,134 72% Debt Service 1,758,581 1,710,421 97% Other Department Expense 49,126 29,875 61% Transfers 986,800 981,418 99% Total $ 19,387,487 $ 17,332,609 89% Page 1 of 11 2 CITY OF SANGER, TEXAS GENERAL FUND REVENUE & EXPENDITURES August 31, 2018 Annual Year to Date % of I Budget Balance Budget Actual Budget Operating Revenues Property Taxes $ 3,181,000 $ 3,268,076 103% $ (87,076) Sales & Beverage Taxes 905,000 801,504 89% 103,496 Franchise Fees 827,800 782,641 95% 45,159 Solid Waste 770,500 766,465 99% 4,035 Licenses & Permits 206,070 314,040 152% (107,970) Fines & Forfeitures 112,000 82,215 73% 29,785 Department Revenues 676,900 793,313 117% (116,413) Interest & Miscellaneous 81,500 64,644 79% 16,856 6,872,898 102% (112,128) Total Operating Revenues 6,760,770 Operating Expenditures Administration 595,399 463,722 78% 131,677 Police & Animal Control 1,724,546 1,415,440 82% 309,106 Fire & Ambulance 1,272,364 960,715 76% 311,649 Municipal Court 227,155 148,291 65% 78,864 Development Services 311,494 262,703 84% 48,791 Streets 669,996 538,680 80% 131,316 Parks & Recreation 730,867 640,725 88% 90,142 Library 276,810 229,486 83% 47,324 Solid Waste 700,000 687,198 98% 12,802 Total Operating Expenditures 6,508,631 5,346,960 82% 1,161,671 Revenues Over (Under) Expenditures 252,139 1,525,938 (1,273,799) Transfers In From Enterprise Fund 292,999 285,916 98% 7,083 Transfers Out to Capital Projects Fund 460,000 460,000 100% - $ 1,351,854 $ (1,266,716) Net Change in Fund Balance $ 85,138 1,745,609 Fund Balance, Beginning of Year 1,745,609 - 3 097 463 Fund Balance, End of Year 1830,747 $ (1,266,716) General Fund Revenues: Actual to Budgot Properly Taxes 103% Sales & Beverage Taxes 89% Franchise Fees _ _ _ 95% Solid Waste 99% Other Revenues 117% 0% 25% 50% 75% 100% Administration Police & Animal Control Fire & Ambulance Municipal Court Development Services Streets Parks & Recreation Library Solid Waste General Fund Expenditures: Actual to Budget 0% 25% 50% 75% 100% c +YTD Actua! mBudget u YTD Actual o Dudgel Page 2 of 11 N CITY OF SANGER, TEXAS GENERAL FUND 3-YEAR REVENUE TRENDS August 31, 2018 PROPERTY TAX REVENUE $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $ 500, 000 pet pet pet ata ate tr c� a� �e A J5ti et SALES & BEVERAGE TAX REVENUE $1,000,000 $ 800, 000 $ 600, 000 $400,000 $200,000 O°Je` �eeet et �acJac1 atA �0 02 F P heQ�e w 2017-2018 A 2016-2017 w 2015-2016 O 2017-2018 u 2016-2017 0 2015-2016 FRANCHISE FEE REVENUE $1,000,000 $900,000 $800,000 $700,000 $600,000 $500,000 9 2017-2018 $400,000 0 2016-2017 $300,000 $200,000 02015-2016 $100,000 fdWV INN pet etcpet et ac�ata VQ �e Page 3 of 11 CITY OF SANGER, TEXAS ENTERPRISE FUND REVENUE & EXPENDITURES August 31, 2018 Operating Revenues Water Wastewater Electric Penalties & Fees Interest Miscellaneous Total Operating Revenues Operating Expenditures Administration Water Wastewater Electric Debt Service Total Operating Expenditures Revenues Over (Under) Expenditures Transfers Out Transfer to General Fund Transfer to 4A Transfer to WW CIP Reserve Transfers to Storm Recovery Fund Transfer to General Fund - PILOT Total Transfers Out Net Change in Fund Balance Fund Balance, Beginning of Year Fund Balance, End of Year Annual Year to Date % of Budget Budget Actual Budget Balance $ 1,890,000 $ 1,900,147 101% $ (10,147) 1,850,000 1,753,042 95% 96,958 8,122,500 7,326,590 90% 795,910 210,000 199,936 95% 10,064 15,000 15,889 106% (889) 52,000 69,516 134% (17,516) 12,139,500 11,265,120 93% 874,380 1,389,263 1,082,018 78% 307,245 1,294,212 1,095,659 85% 198,553 670,169 696,065 104% (25,896) 6,945,645 6,605,884 95% 339,761 1,572,767 1,524,607 97% 48,160 11,872,056 11,004,233 93% 867,823 267,444 260,887 6,557 100,000 100,000 100% - 25,000 25,000 100% - 156,800 169,583 108% (12,783) 160,000 148,913 93% 11,087 85,000 77,917 92% 7,083 526,800 521,413 9900 5,387 $ (259,356) $ (260,526) $ 1,170 - 3,982,069 3,982,069 $ 3,722,713 $ 3,721,543 $ 1,170 Enterprise Fund Revenues: Actual to Budget Water 10i% Wastewater 95% uY DActual Electric 90% o Budget - -r-- Other Income 103% 0% 25% 50% 75% 100% Enterprise Fund Expenditures: Actual to Budget Administration 78% Water 85% Wastewater 104% _ - _ - - - - „YTo Actual Electric 95% Q Budget Debt Service 97% 0% 25% 50% 75% 100% Page 4 of 11 5 CITY OF SANGER, TEXAS ENTERPRISE FUND 3-YEAR REVENUE TRENDS August 31, 2018 WATER SALES REVENUE $1, 800,000 $1,600,000 $1,400, 000 $1, 200, 000 $1,000, 000 $800,000 0 2017-2018 $600,000 1 64 2016-2017 $400,000 M 2015-2016 $200,000 m w t c a r a ce �A Jyti et WASTE WATER SALES REVENUE $1,800,000 $1,600, 000 $1,400, 000 $1,200, 000 $1,000,000 $800,000 m 2017-2018 $600,000 M2016-2017 $400,000 02015-2016 $200,00- mww Oc�°rec �e�rQ` ce��e` � lJ�� a� �o Oe F heQ ELECTRIC SALES REVENUE $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 M 2017-2018 $ 3,000, 000 - p 2016-207 7 $ 2,000, 000 512015-2016 $1,000,000 OWN INN Q4�°sec e� ce�re� ,A Page 5 of 11 6 CITY OF SANGER, TEXAS CASH AND INVESTMENTS August 31, 2018 Name General Fund Enterprise Debt Service Capital Total Fund Fund Projects Fund UNRESTRICTED Cash for Operations $ 2,934,756 $ 634,150 $ - $ - $ 3,568,906 Contingency Reserves for Operations 1,015,735 1,012,996 - - 2,028,731 TOTAL UNRESTRICTED $ 3,950,491 $ 1,647,146 $ - $ - $ 5,597,637 RESTRICTED Debt Service $ - $ 1,494,823 $ 406,265 $ - $ 1,901,088 Water Deposits - 429,223 - 429,223 Equipment Replacement 215,723 115,416 331,139 Electric Storm Recovery - 953,992 - 953,992 Hotel Occupancy Tax 36,899 - - 36,899 Grant Funds 9,326 9,326 Keep Sanger Beautiful (KSB) 5,526 - - 5,526 Library 95,193 - - - 95,193 Court Security 8,591 - - - 8,591 Cou rt Tech no I ogy 142 - - - 142 Child Safety Fee 26,665 26,665 Donations 13,264 - - - 13,264 TOTAL RESTRICTED $ 411,329 $ 2,993,454 $ 406,265 $ - $ 3,811,048 CAPITAL PROJECTS General Capital Projects $ - $ - $ - $ 1,061,588 $ 1,061,588 Enterprise Capital Projects - - - 8,934,956 8,934,956 TOTAL CAPITAL PROJECTS $ - $ - $ - $ 9,996,544 $ 9,996,544 TOTAL CASH AND INVESTMENTS $ 4,361,820 $ 4,640,600 $ 406,265 $ 9,996,544 $ 19,405,229 Total Cash & Investments Enterprise Capital Projects... Unrestricted Contingency Reserves for Operations 36% Cash fc Operatic _ 64% Capital Projects General Capital Projects 11% Debt Service 41% Restricted Water Deposits 22% equipment eplacement 7% Electric Storm Recovery 21% Page 6 of 91 h GENERAL FUND CASH AND INVESTMENTS August 31, 2018 Current Name Acct. # Maturity Yield Prior Period Balance - Pooled Cash 001-00-1000 0.05% $ 3,627,772 $ 3,429,650 Employee Benefits Cash 110-00-1000 0.20% 14,941 14,931 Employee Benefits MM 110-00-1010 0.20% 31,259 77,512 Internal Service Fund 180-00-1000 150,904 160,421 OPERATING ACCOUNTS $ 3,924,876 $ 3,682,514 GF Contingency Reserve MM 2487969 001-00-1031 0.20% $ 595,045 $ 595,146 GF Contingency Reserve CD Prosperity 001-00-1039 4/26/2019 0.55% 209,511 209,511 GF Contingency Reserve CD 674907 001-00-1043 7/13/2019 0.45% 210,961 211,078 CONTINGENCY RESERVE $1,015,517 $1,015,735 * GF Equipment Replacement MM 2376237 001-00-1032 0.20% $ 151,840 $ 152,291 * GF Equipment Replacement CD 719706 001-00-1033 7/6/2019 0.45% 63,397 63,432 EQUIPMENT REPLACEMENT RESERVES $ 215,237 $ 215,723 * Hotel Occupancy Tax 050-00-1000 $ 36,684 $ 36,899 * Police Grant Fund 320-00-1000 9,326 9,326 * Fire Grant Fund 324-00-1000 28,478 28,478 * Library Grant Fund 342-00-1000 14 14 * Beautification Board - KSB 432-00-1000 5,526 5,526 * Library Restricted for Building Expansion 442-00-1000 43,254 43,854 * Library Building Expansion CD 702994 442-00-1035 1/22/2019 0.45% 51,310 51,339 * Parkland Dedication Fund 450-00-1000 12,878 12,878 * Roadway Impact Fee Fund 451-00-1000 269,279 278,279 * Court Security Restricted Fund 470-00-1000 8,589 8,591 * Court Technology Restricted Fund 471-00-1000 75 142 * Child Safety Fee Fund 475-00-1000 26,665 26,665 * Police Donations 620-00-1000 (1,077) (1,077) * Fire Donations 624-00-1000 6,000 6,000 * Banner Account for Parks 632-00-1000 2,536 2,536 * Library Donations 642-00-1000 5,805 5,805 OTHER $ 505,342 $ 515,255 TOTAL CASH AND INVESTMENTS $ 5,560,972 $ 5,429,227 TOTAL UNRESTRICTED $ 4,840,393 $ 4,698,249 *Restricted Funds Page 7 of 11 8 ENTEPRISE FUND CASH AND INVESTMENTS August 31, 2018 Narre Acct. # Maturity Yield.:.PlIOI Period Current 'ooled Cash 008-00-1010 0.05% $ 629,458 $ 634,150 OPERATING ACCOUNTS $ 629,458 $ 634,150 * Pooled Cash * Water Deposit CD 2375850 008-00-1.010 0.05% 008-00-1041 1/3/2019 0.45% $ 137,240 300,000 $ 129,223 300,000 WATER DEPOSIT REFUND ACCOUNT $ 437,2401 $ 429,223 *Combined EF Debt Service MM 2376113 008-00-1039 0.20% 1,414,582 1,494,823 BOND FUNDS $1,414,582 $1,494,823 EF Contingency Reserve MM 2809753 EF Contingency Reserve CD 787860 EF Reserve CD 642541 008-00-1012 0.20% 008-00-1014 2/14/2019 0.45% 008-00-1040 9/25/2018 0.45% $ 593,574 313,233 105,858 $ 593,674 313,406 105,916 CONTINGENCY RESERVES $1,012,665 $1,012,996 * EF Storm Recovery MM- 2% Electric Rev * EF Equipment Replacement MM 2376202 008-00-1033 0.20% 008-00-1034 0.20% $ 940,295 115,038 $ 953,992 115,416 OTHER $1,055,333 $1,069,408 TOTAL CASH AND INVESTMENTS $ 4,549,278 $ 4,640,600 TOTAL UNRESTRICTED $ 1,642,123 $1,647,146 *Restricted Funds Page 8 of 11 9 DEBT SERVICE & CAPITAL PROJECTS CASH AND INVESTMENTS August 31, 2018 DEBT SERVICE FUND Name Acct. # Maturity. Yield Prior Period Current Balance Pooled Cash 003-00-1000 0,05% $ 588,599 $ 349,139 * DSF Money Market 2376105 003-00-1010 0.20% 57,116 57,126 TOTAL RESTRICTED $ 645,715 $ 406,265 GENERAL CAPITAL PROJECTS FUND Current Name Acct. # Maturity Yield Prior Period,' Balance Pooled Cash 004-00-1000 0.05% $ 1,062,538 $ 1,061,588 TOTAL RESTRICTED $ 1,062,538 $ 1,061,588 ENTERPRISE CAPITAL PROJECTS FUND Name... Acct. # .` Maturity Yield Prior. Period Current Balance Sewer Capital Improvements MM-10% Rev 840-00-1020 0.20% $ 710,362 $ 725,900 * Sewer Capital Reserve MM 2380226 Tap Fees 840-00-1038 0.20% 1,988,907 2,001,245 * SEWER CAPITAL RESERVE - TAP FEES $ 2,699,269 1 $ 2,727,145 * Water Capital Reserve MM 2376156 840-00-1037 0.20% $ 1,114,006 $ 1,123,195 * Pooled Cash 840-00-1000 0.05% 3,499,923 3,030,571 * General CIP Money Market 2674823 840-00-1013 0.05% 2,053,783 2,054,045 TOTAL RESTRICTED $ 9,366,981 $ 8,934,956 *Restricted Funds Page 9of11 10 4A & 4B FUNDS CASH AND INVESTMENTS August 31, 2018 4A FUND Current Name Acct. # Maturity Yield Prior Period `Balance * Pooled Cash 41-00-1000 0.05% $ 561,663 5 601,204 * Cash NOW 900020693 Prosperity 41-00-1010 0.05% 392,344 387,271 * 4A MM 902551273 Prosperity 41-00-1012 0.20% 470,816 471,110 * Sanger TX Ind Corp CD 486639 41-00-1013 10/2/2018 0.25% 94,750 94,806 TOTAL CASH AND INVESTMENTS $ 1,519,573 $ 1,554,391 4B FUND Name Acct. # Maturity. Yield Prior Period Current Balance Pooled Cash 42-00-1000 0.05% $ 465,313 $ 504,974 * Cash MM 2379694 42-00-1010 0.05% 189,697 189,705 * 4B CD 653500 42-00-1013 4/3/2019 0.45% 21,808 21,832 * 4B CD 659924 42-00-1014 11/12/2018 0.45% 21,559 21,571 * 4B CD 664243 42-00-1015 6/5/2019 0.45% 21,644 21,656 * 4B CD 673277 42-00-1016 7/9/2019 0.45% 21,589 21,601 * 413 CD 686115 42-00-1017 8/4/2019 0.45% 21,578 21,589 * 413 CD 689521 42-00-1018 9/11/2018 0.45% 21,490 21,502 * 4B CD 694371 42-00-1019 10/14/2018 0.45% 21,565 21,577 * 4B CD 697230 42-00-1020 11/17/2018 0.45% 21,679 21,691 * 4B CD 699934 42-00-1021 12/18/2018 0.45% 21,595 21,607 * 4B CD 702285 42-00-1022 1/31/2019 0.45% 21,401 21,412 * 4B CD 706078 42-00-1023 2/19/2019 0.45% 21,304 21,316 * 4B CD 720097 42-00-1024 2/9/2019 0.45% 21,068 21,079 * 4B CD 720119 42-00-1025 11/9/2018 0.45% 21,103 21,114 TOTAL CASH AND INVESTMENTS $ 934,393 $ 974,226 *Restricted Funds Page 10 of 11 11 CITY OF SANGER, TEXAS INVESTMENT REPORT August 31, 2018 The Monthly Investment Report is in full compliance with the objectives, restrictions, and strategies as set forth in the City of Sanger's Investment Policy and Texas Government Code 2256.023, the Public Funds Investment Act (PFIA). The City only invests in Money Market accounts and Certificates of Deposit. Interest is paid monthly on all accounts. Therefore, book value and market value are the same and the City does not have accrued interest on its investments. Ethics Disclosure and Conflicts of Interest In accorance with the PFIA, investment officers are required to file a disclosure statement with the Texas Ethics Commission and the governing body if: a. the officer has a business relationship with a business organization offering to engage in an investment transaction with the City (as defined in 2256.005 (i) (1-3); or b. the officer is related within the second degree by affinity or consanguinity, as determined under Chapter 573 of the Texas Government Code, to an individual seeking to transact investment business with the entity. PFIA 2256.005 (i). Cam&& yi2 Clayton Gray Finance Director Alina Ciocan Acting City Manager Page 11 of 11 12 . , • J ! 14 , OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ROLLING OVER: LAST MONTH 0 2 4 5 4 9 2 6 13 30 58 74 INCOMING IMPOUNDED: DOGS 11 13 5 5 10 2 6 8 7 7 5 IMPOUNDED: CATS 8 6 1s 2 1 2 1 5 16 21 10 EMERGENCY CALL OUT: DOG 2 2 2 EMERGENCY CALL OUT: CAT TNR-TRAP RELEASE: CAT TOTAL BEFORE DISPOSITION 19 19 23 7 13 4 9 13 23 30 15 0 SURRENDER: DOG 2 4 7 3 5 2 1 0 0 2 4 SURRENDER: CAT 3 2 1 1 SURRENDER TOTAL FOR MONTH 2 7 7 5 6 2 1 0 1 2 4 0 OUTGOING ADOPTION: DOG 4 4 2 4 3 3 1 2 ADOPTION :CAT 4 5 1 1 3 RESCUE PICK UP: DOG 1 1 2 1 RESCUE PICK UP: CAT OWNER PICK UP: DOG 4 6 7 1 6 2 4 4 2 1 3 OWNER PICK UP: CAT RELEASE TO BARN: CAT 6 6 12 1 2 2 DIED: DOG 1 1 1 DIED: CAT 1 2 1 EUTHANIZED: DOG 2 2 1 2 1 1 EUTHANIZED: CAT 1 2 1 2 4 1 TOTAL OUTGOING 19 24 29 13 14 13 6 6 7 4 3 0 TOTAL FOR THE MONTH 2 4 5 4 9 2 6 13 30 58 74 74 YTD TOTAL(260) 241 222 199 192 179 175 166 153 130 100 85 85 rolling over-- total at the end of the month before total before disposition=all incoming animals total at end of month= rolling over +total before disposition - total outgoing YTD total= 260 - total incoming (1st month) continue subtracting total incoming 13 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE: VENDOR SET: 99 CITY OF SANGER BANK: EMP 3 EMPLOYEE BENEFIT FUND DATE RANGE: 9/01/2018 THRU 9/30/2019 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT 30790 EYEMED 1-163601745 VISION INS SEPT 2018 R 9/04/2018 602.38 000529 602.38 10610 LEADERSLIFE INS. COMPANY I-82989 AUG 2018 LIFE INS R 9/04/2018 86.66 OOD529 86.66 30560 MUTUAL OF OMAHA 1-000771515346 LIFE INS SEPT 2018 R 9/04/2018 1,340.65 000530 1,340.65 30590 UNITED HEALTHCARE INSURANCE CO 1-093303480716 HEALTH & DENTAL SEPT 2018 R 9/04/2018 44,731.62 OODS31 44,731.62 13080 BLUE CROSS BLUE SHIELD OF TEXA I-100 PREM BINDER FOR OCT 2018 MED R 9/10/2018 42,000.00 000532 42,000.00 T 0 T A L S NO INVOICE AMOUNT DISCOUNTS CHECK AMOUNT REGULAR CHECKS: 5 88,761.31 0.00 88,761.31 HAND CHECKS: 0 0.00 0.00 0.00 DRAFTS: 0 0.00 0.00 0.00 EFT: 0 0.00 0.00 0.00 NON CHECKS: 0 0.00 0.00 0.00 VOID CHECKS: 0 VOID DEBITS 0.00 VOID CREDITS 0.00 0.00 0.00 TOTAL ERRORS: 0 NO INVOICE AMOUNT DISCOUNTS CHECK AMOUNT VENDOR SET: 99 BANK: EMP BTOTALS: 5 88,761.31 0.00 88,761.31 BANK: EMP B TOTALS: 5 88,761.31 0.00 88,761.31 14 10/01/2018 1:30 PM VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 A/P HISTORY CHECK REPORT VENDOR T.D. NAME 00600 CITY OF SANGER I -AUGUST 2018 ELECTRIC 7/20/18 - 9/20/18 14210 OFFICE OF THE ATTORNEY GENERAL I-CATPY9.14.18 CHILD SUPPORT I-CBAPY9.14.18 CHILD SUPPORT I-CBWPY9.14.18 CHILD SUPPORT I-CJ2PY9.14.18 CHILD SUPPORT I-CJBPY9.14.18 CHILD SUPPORT I-C3MPY9.14.18 CHIL➢ SUPPORT I-CSAPY9.14.18 CHILD SUPPORT I-CSCPY9.14,18 CHIL➢ SUPPORT I-CSDPY9.14.18 CHILD SUPPORT OFFICE OF THE ATTORNEY GENERAL 14210 CHILD SUPPORT I-CATPY9.28.18 CHILD SUPPORT I-CBAPY9.28.18 I-CBWPY9.28.18 CHILD SUPPORT I-C32PY9.28.18 CHILD SUPPORT I-CIBPY9.28.18 CHILD SUPPORT I-C3MPY9.28.18 CHILD SUPPORT I-CSAPY9.28.18 CHILD SUPPORT I-CSCPY9.28.18 CHILD SUPPORT I-CSDPY9.28.18 CHILD SUPPORT INTERNAL REVENUE SERVICE 22640 FEDERAL W/H C-T1 PY8.31.18 2 FICA PAYABLE C--T3 PY8.31.18 2 FICA PAYABLE C-T4 PY8.31.18 2FEDERAL W/H I-T1 PY9.14.18 FICA PAYABLE I-T3 PY9.14.18 FICA PAYABLE I-T4 PY9.14.18 INTERNAL REVENUE SERVICE 22640 FEDERAL W/H I-Tl PY9.28.18 FICA PAYABLE I-T3 PY9.28.18 FICA PAYABLE I-T4 PY9.28,18 AUSTIN LANE TECHNOLOGIES, INC 25610 CM TO RELEASE PRIOR YR PO NETWORK C-091318CM CONSOLIDATION I-091318 TRUST --CITY OF SANGER EMPLOYEE 26320 I-DC1PY9.14.18 HEALTH INA I-DC1PY9.28.18 HEALTH INA I-DC2PY9.14.18 HEALTH INS I-DC2PY9.28.18 HEALTH INS I-DE1PY9.14.18 DENTAL INS PAGE: 2 CHECK INVOICE CHECK CHECK CHECK STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT D 9/04/2018 32,512.40 000000 32,512.40 D 9/14/2018 103.85 000000 D 9/14/2018 197.54 000000 D 9/14/2018 419.54 000000 D 9/14/2018 325.00 000000 D 9/14/2018 184.62 000000 D 9/14/2018 341.17 000000 D 9/14/2018 189.23 000000 D 9/14/2018 190.62 000000 D 9/14/2018 263.08 000000 2,214.65 D 9/28/2018 103.85 000000 D 9/29/2018 197.54 000000 D 9/28/2018 419.54 000000 D 9/29/2018 325.00 000000 D 9/28/2018 184.62 000000 D 9/28/2018 341.17 000000 D 9/28/2018 189.23 000000 D 9/28/2018 190.62 000000 D 9/28/2018 263.08 000000 2,214.65 D 9/14/2018 261.54CR 000000 D 9/14/2018 206.52CR 000000 D 9/14/2018 48.34CR 000000 D 9/14/2018 14,573.37 000000 D 9/14/2018 19,675.26 000000 D 9/14/2018 4,601.50 000000 39,333.73 D 9/28/2018 13,723.78 000000 D 9/28/2018 19,084.28 000000 D 9/28/2018 4,463.20 000000 37,271.26 N 9/14/2018 5,745.70CR 000000 N 9/14/2018 5,745.70 000000 D 9/28/2019 330.13 000000 D 9/28/2019 330.13 D00000 D 9/28/2019 220.32 000000 D 9/28/2018 220.32 000000 D 9/28/2➢19 259,28 000000 15 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE: VENDOR SET. 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT I-DE1PY9.28.18 DENTAL INS D 9/28/2018 259.28 000000 I-DE2PY9.14.18 HEALTH INS D 9/28/2018 479.46 000000 I-DE2PY9.28.18 HEALTH INS D 9/28/2018 479.46 000000 I-DF1PY9.14.18 HEALTH INS D 9/28/2018 289.08 000000 I-DF1PY9.28.18 HEALTH INS D 9/28/2018 289.08 000000 I-DF2PY9.14.18 HEALTH INS D 9/28/2018 456.48 000000 I-DF2PY9.28.18 HEALTH INS D 9/28/2018 456.48 000000 I-DS1PY9.14.18 HEALTH INS D 9/28/2018 37.03 000000 I-DS1PY9.28.18 HEALTH INS D 9/28/2018 37.03 000000 I-DS2PY9.14.18 HEALTH INS D 9/29/2018 92.67 000000 I-DS2PY9.28.18 HEALTH INS D 9/29/2018 92.67 000000 I-GLIPY9.14.18 GROUP LIFE $25K D 9/28/2018 79.00 000000 I-GLIPY9.28.18 GROUP LIFE $25K D 9/28/2018 79.00 000000 I-HC1PY9.14.18 HEALTH INS D 9/29/2018 1,660.16 000000 I-HC1PY9.28.18 HEALTH INS D 9/28/2018 1,660.16 000000 I-HC2PY9.14.18 HEALTH INS D 9/28/2018 6,689.76 000000 I-HC2PY9.28.18 HEALTH INS D 9/28/2018 6,688,76 000000 I-HElPY9.14.18 HEALTH INS D 9/28/2019 5,488.98 000000 I-HElPY9.28.18 HEALTH INS D 9/28/2018 5,488.98 000000 I-HE2PY9.14.18 HEALTH INS D 9/28/2018 3,353.59 000000 I-HE2PY9.28.18 HEALTH INS D 9/28/2019 3,353.59 000000 I-HE3PY9.14.18 HEALTH IN D 9/28/2018 990.72 000000 I-HE3PY9.28.18 HEALTH IN D 9/28/2018 990.72 000000 I-HF2PY9.14.18 HEALTH IN D 9/28/2018 2,525.08 000000 I-HF2PY9.28.18 HEALTH IN D 9/28/2D18 2,525.08 000000 I-HS2PY9.14.18 HEALTH INS D 9/28/2018 1,302.06 000000 I-HS2PY9.28.18 HEALTH INS D 9/28/2018 1,302.06 000000 I-LLIPY9.14.18 LIFE INSURANCE D 9/28/2019 43.34 00000D I-LLIPY9.28.18 LIFE INSURANCE D 9/28/2018 43.34 000000 I-VC1PY9.14.18 HEALTH INS D 9/28/2018 55.34 000000 I-VC1PY9.28.18 HEALTH INS D 9/28/2018 55.34 000000 I-VE1PY9.14.18 VISION INS D 9/28/2018 84.74 000000 I-VE1PY9.28.18 VISION INS D 9/28/2018 84.74 000000 I-VF1PY9.14.18 HEALTH INS D 9/28/2018 114.84 000000 I-VF1PY9.28.18 HEALTH INS D 9/28/2018 114.84 000000 I-VLIPY9.14.18 EMPLOYEE VOLUNTARY LIFE D 9/28/2018 666.86 000000 I-VLIPY9.28.18 EMPLOYEE VOLUNTARY LIFE D 9/28/2018 666.86 000000 I-VS1PY9.14.18 HEALTH INS D 9/28/2018 37.08 00D000 I-VS1PY9.28.18 HEALTH INS D 9/28/2018 37.08 000000 50,510.00 30600 TASC I-FSCPY8.3.18 FLEX D 9/14/2018 208.33 000000 I-FSMPY8.3.18 FLEX D 9/14/2018 1,970.85 000000 2,179.18 16 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE: VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT 30600 TASC 1-9/28/19 TASC D 9/28/2018 2.00 000000 I-FSCPY8.17.18 FLEX D 9/28/2018 208.33 000000 I-FSMPY8.17.18 FLEX D 9/28/2018 1,970.85 000000 2,181,18 08280 A-1 PORTA PRIVY 1-110323 POTTIES FOR SELLABRATION R 9/04/2018 950.00 069989 950.00 07860 ACT PIPE SUPPLY, INC I-5100255813.001 FIRE HYDRANT METER R 9/04/2018 506.25 069990 506.25 09600 AFLAC c-879299 AFLAC R 9/04/2018 57.35CR 069991 I-AFKPY8.17.18 INSURANCE R 9/04/2018 292.20 069991 I-AFKPY8.3.18 INSURANCE R 9/04/2018 292.20 069991 I-AFLPY8.17.18 INSURANCE R 9/04/2018 1,143.20 069991 I-AFLPY8.3.18 INSURANCE R 9/04/2018 1,143.20 069991 2,813.45 06210 ALERT -ALL CORP I-218070490 KEY TAGS R 9/04/2018 245.00 069992 245.00 22620 ARAMARK UNIFORM SERVICE 1-1157619638 UNIFORM R 9/04/2019 29.80 069993 1-1157619639 UNIFORMS R 9/04/2019 28.08 069993 1-1157619640 UNIFORMS R 9/04/2019 45.34 069993 1-1157619641 UNIFORMS R 9/04/2019 26.73 069993 I-1157619642 MATS / CITY HALL R 9/04/2019 20.17 069993 1-1157631085 MATS / CITY HALL R 9/04/2019 20.17 069993 170.29 25610 AUSTIN LANE TECHNOLOGIES, INC I-161778 IT - CHARGES -MULTI DEPTS R 9/04/2019 5,518.00 069994 5,518.00 09950 B&G CHEMICAL & EQIPMENT, CORP I-201808167659 SLICK ASPH RELEASE AGENT R 9/04/2018 1,317.25 069995 1,317.25 31670 BOOT BARN I-130776 BOOT ALLOW - E PIERCY R 9/04/2018 100.00 069996 I-130779 JEAN ALLOW- E PIERCY R 9/04/2018 277.13 069996 377.13 00420 BOUND TREE MEDICAL, LLC 1-82954187 EMS SUPPLIES R 9/04/2018 717.28 069997 1-82956670 EMS SUPPLIES R 9/04/2018 89.99 069997 I-82957887 EMS SUPPLIES R 9/04/2018 121.84 069997 I-82960739 EMS SUPPLIES R 9/04/2018 190.66 069997 1,119.77 4 17 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE: VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2019 THRU 9/30/2018 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT 00590 CITY OF DENTON I-7/11/18 - 8/14/19 TESTING R 9/04/2018 160.00 069998 160.00 07850 CLEAT I-CLTPY8.17.18 ASSOCIATION DUES EMPLOYEE R 9/04/2018 71.55 069999 I-CLTPY8.3.18 ASSOCIATION DUES EMPLOYEE R 9/04/2018 71.55 069999 143.10 21100 COLEMAN LAW FIRM I-08-24-18 AUG Z018 - MUNIC PROSECUTOR R 9/04/2018 1,125.00 070000 1,125.00 23820 FERGUSON WATERWORKS I-0968960-1 OUT OF SVC HYDRANT DISK R 9/04/2018 84.49 070001 I-0968970 CLAMPS, PIPE REPAIR SADDLE R 9/04/2018 183.27 070001 I-0971316 12 " DRAINAGE PIPE R 9/04/2018 1,505.00 070001 1,772.75 29020 FORT WORTH BOLT & TOOL CO 1 LT I-0# 1225259 CARRIAGE BOLTS R 9/04/2018 45.00 070002 I-0# 1225666 BITS AND BLADES R 9/04/2018 321.00 070002 366.00 08400 FRANKLIN LEGAL PUBLISHING I-2005762 UPDATE ORDINANCES R 9/04/2018 2,370.00 070003 2,370.00 18790 FUELMAN i-NP54043631 FUEL 9/20/18 - 8/26/18 R 9/04/2018 2,386.84 070004 2,386.84 05900 FULTONS 1-000101290498 2X14 GA X 24 SQ TUBE R 9/04/2018 134.43 070005 1-000101290499 3X3X3,16X20, CUT CHRG, 2X11GAX R 9/04/2018 318.75 070005 453.18 01240 INLAND TRUCK PARTS, INC. i-IN-114921 A/C PARTS R 9/04/2018 290.70 070006 290.70 30330 3M TEST SYSTEMS, INC. I-S558798-IN RUBBER GLOVE TESTING R 9/04/2018 193.92 070007 193.92 33140 3PS HEALTH NETWORK 1-6000678338900 SANE EXAM FOR CASE 507301876 R 9/04/2018 589.00 070008 589.00 08210 KWIK KAR I-90449 INSPECTION -DUMP TRUCK STREETS R 9/04/2018 7.00 070009 i-90458 INSPECTION - UNIT 27-30 R 9/04/2018 25.50 070009 I-90627 INSPECTION - BOLZ R 9/04/2018 25.50 070009 58.00 IN 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK VENDOR I.D. NAME STATUS DATE 05400 LEGALSHIELD I-PPLPY8.17.18 PREPAID LEGAL SERVICES R 9/04/2018 I-PPLPY8.3.18 PREPAID LEGAL SERVICES R 9/04/2018 01570 LOWE'S COMPANIES, INC. 1-31038951 AIRLINES, WATER NOZZLE R 9/04/2019 I-34257105 CONCRETE FOR SIGNS R 9/04/2018 I-84052794 PAINT,BATTERIE,POST,WATER HSE R 9/04/2018 I-84605220 WELDING WIRE R 9/04/2018 29780 MARKY'S DRY CLEANERS I-3UL/2018 INV'S JULY 2018 INVOICES R 9/04/2018 29030 MCCREARY, VESELKA, BRAGG & ALL I-174790 JULY WARRANT COLLECTION R 9/04/2018 I-174791 JULY WARRANT COLLECTION R 9/04/2018 30560 MUTUAL OF OMAHA I-00077IS1536 LTD SEPT 2018 R 9/04/2018 25580 NORTH TEXAS GROUNDWATER CONSER I-03/31/19-06/30/18 WATER PURCHASED R 9/04/2018 24940 NTTA I-797183993 TOLL RD - J. BOLZ R 9/04/2018 08690 O'REILLY AUTO PARTS C-1959-466840 CORE RETURN R 9/04/2019 C-1959-467047 RETURN BALL JOINT R 9/04/2018 I-1959-467784 HEAT NOZZLE R 9/04/2019 I-1959-468002 AC DRIER, EXPAND VALVE R 9/04/2018 I-1959--468181 AIR/HYD/OIL FILTERS R 9/04/2018 1-1959-469253 COUPLER R 9/04/2018 I-1959-469650 FUEL HOSE,CLAMPS, PUMP R 9/04/2018 I-1959-469678 BRAKE PADS R 9/04/2018 I-1959-469918 BATTERY R 9/04/2018 I-1959-469931 BATTERY BOUGHT - W/EXCHANGE R 9/04/2018 I-470945 WTR PMP,THERM,TWNG MIRROR R 9/04/2018 I-470962 LOCK RING R 9/04/2018 I-470979 DISC PAD SET UNIT 47-30 R 9/04/2018 I-471040 HOSE CLAMP R 9/04/2018 I-471169 MEGA FUSE R 9/04/2018 I-471170 BLUE DEF R 9/04/2018 PAGE INVOICE CHECK CHECK CHECK AMOUNT DISCOUNT NO STATUS AMOUNT 26.90 070010 26.90 070010 53.80 122.42 070011 332.20 070011 317.68 070011 61.74 070011 834.04 101.75 070012 101.75 89.10 070013 228.93 070013 318.03 737.50 070014 737.50 8,181.33 070015 8,181.33 7.70 070016 7.70 18.00CR 070017 36.46CR 070017 62.99 1.26CR 070017 48.45 0.97CR 070017 35.40 0.71CR 070017 17.98 0.36CR 070017 97.82 1.96CR 070017 58.48 1.17CR 070017 178.32 3.57CR 070017 24.60 0.49CR 070017 269.21 5.38CR 070017 39.99 0.80CR 070017 166.56 3.33CR 070017 1.89 0.04CR 070017 14.97 0.30CR 070017 26.98 0.54CR 070017 968.29 s 19 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE: VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT 09090 PERKINS ENTERPRISE 1-3313 AIR ANALYSIS R 9/04/2019 150.00 070019 150.00 25020 SANGER HARDWARE I-B109703 PVC THREADED PIPE R 9/04/2019 15,56 070020 I-B109743 PVC PRIMER,GLUE, ADAPTER... R 9/04/2019 84.13 070020 I-B109756 CHAIN TO LOCK CONST METERS R 9/04/2019 18.36 070020 I-B109759 BALL VALVE R 9/04/2019 34.17 070020 I-BllOO44 2 STROKE OIL - WEEDEATER R 9/04/2019 12.99 070020 I-B110341 CHAIN R 9/04/2019 29.13 070020 I-C47673 WATER BOOTS R 9/04/2019 44.99 070020 I-C47694 WASP/ HORNET SPRAY R 9/04/2019 3.99 070020 243.32 02450 SOLOMON, CORP. I-310120 TRANSFORMER REP R 9/04/2018 775.00 070021 775.00 24620 SUPERION, LLC I-213323 DIGT DISPATCH MAINT RENEWAL R 9/04/2018 3,306.71 070022 3,306.71 00100 TMRS C-RETPY8.31.18 2 TMRS R 9/04/2018 231.98CR 070023 I-RETPY8.17.18 TMRS R 9/04/2018 19,574.51 070023 I-RETPY8.3.18 TMRS R 9/04/2018 19,798.13 070023 I-RETPY8.31.18 TMRS R 9/04/2018 19,855.12 070023 58,995.78 32030 GILLIAM INVESTMENTS: ➢BA: VANG I-24287 JANITORIAL SVC & SUP R 9/04/2018 2,948.00 070024 2,948.00 1 4924-4926 VILLAS DR 1-000201809057681 US REFUND R 9/10/2018 54.52 070025 54.52 1 4924-4926 VILLAS DR 1-000201809057682 US REFUND R 9/10/2018 88.57 070026 88.57 1 BARTON, REBECCA J 1-000201809057698 US REFUND R 9/10/2018 14.22 070027 14.22 1 BATCHELOR, DANIEL 1-000201809057707 US REFUND R 9/10/2018 65.15 070028 65.15 1 CAMERON CLASSIC HOME 1-000201809057676 US REFUND R 9/10/2018 508.23 070029 508.23 7 20 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE: 8 VENDOR SET: 99 CITY OF SANGER SANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT 1 CANTRELL, DANIELLE L I-000201809057703 US REFUND R 9/10/2019 237.50 070030 237.50 1 CARRICO AND ASSOCIAT 1-000201809057669 US REFUND R 9/10/2019 6.23 070031 6.23 1 CASHION HOMES I-000201809057702 US REFUND R 9/10/2018 66.22 070032 66.22 1 FRAZIER, BRADLEY C 1-000201809057705 US REFUND R 9/10/2018 5.63 070033 5.63 1 GONG, QIULIAN I-000201809057677 US REFUND R 9/10/2018 280.81 070034 280.81 1 HINES, DANNY I-000201809057674 US REFUND R 9/10/2018 3.96 070035 3.96 1 HOME PLACE BUILDERS 1-000201809057679 US REFUND R 9/10/2018 348.08 070036 348.08 1 HUNTER, 7ENNIFER 1-000201809057704 US REFUND R 9/10/2018 84.30 070037 84.30 1 IMPRESSION HOMES 1-000201809057678 US REFUND R 9/10/2018 546.29 070038 546.28 1 IMPRESSION HOMES 1-000201809057691 US REFUND R 9/10/2018 594.40 070039 594.40 1 IMPRESSION HOMES 1--000201809057692 US REFUND R 9/10/2018 287.99 070040 287.98 1 IMPRESSION HOMES 1-000201909057693 US REFUND R 9/10/2018 528.29 070041 528.29 1 IMPRESSION HOMES I-000201809057694 US REFUND R 9/10/2019 432.03 070042 432.03 1 KNISS, CARISSA L 1-000201809057708 US REFUND R 9/10/2018 122.20 070043 122.20 1 MCCLINTOCK HOMES LLC 1-000201809057690 US REFUND R 9/10/2018 508.00 070044 508.00 21 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE: 9 VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT 1 MCCLINTOCK HOMES LLC 1-000201809057699 US REFUND R 9/10/2018 551.84 070045 S51.84 1 MCCLINTOCK HOMES LLC 1-000201809057701 US REFUND R 9/10/2018 520.88 070046 520.88 1 MCCLINTOCK HOMES, LL 1-000201809057700 US REFUND R 9/10/2018 475.18 070047 475.18 1 MEZA, OSCAR 1-000201809057672 US REFUND R 9/10/2018 292.97 070048 292.97 1 MOLINA, DORA 1-000201809057675 US REFUND R 9/10/2018 0.15 07004D 0.15 1 1-000201809057671 USCREFUNDNC R 9/10/2018 500.73 070050 500.73 1 PETERSEN, CURTIS R 1-000201809057668 US REFUND R 9/10/2018 156.22 070051 156.22 1 POTENDYK, DEE ANN E 1-000201809057689 US REFUND R 9/10/2018 121.02 070052 121.02 1 POWERS, TAMRA G 1-000201809057673 US REFUND R 9/10/2018 11.55 070053 11.55 1 PPG CONSTRUCTION 1-000201809057683 US REFUND R 9/10/2018 571.11 070054 571.11 1 PPG CONSTRUCTION 1-000201809057684 US REFUND R 9/10/2019 569.83 070055 569.83 1 PPG CONSTRUCTION 1-000201909057685 US REFUND R 9/10/2018 579.79 070056 579.79 1 PPG CONSTRUCTION I-OG0201909057686 US REFUND R 9/10/2018 568.96 070057 568.96 1 PPG CONSTRUCTION I-000201909057687 US REFUND R 9/10/2018 557.20 07DO58 557.20 1 PPG CONSTRUCTION 1-000201809057688 US REFUND R 9/10/2018 564.02 070059 564.02 22 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE: VENDOR SET: 99 CITY OF SANGER SANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS ➢ATE AMOUNT DISCOUNT NO STATUS AMOUNT 1 ROHAN, TED 1-000201809057697 US REFUND R 9/10/2019 67.64 070060 67.64 1 SAMUEL CUSTOM HOMES, 1-000201809057680 US REFUND R 9/10/2018 579.04 070061 579.04 1 SLE INC I-000201809057670 US REFUND R 9/10/2018 155.71 070062 155.71 1 ULTRA HOMES 1-000201809057695 US REFUND R 9/10/2018 518.16 070063 518.16 1 ULTRA HOMES 1-000201809057696 US REFUND R 9/10/2018 543.57 070064 543.57 1 VINSON, MICHAEL I-000201809057706 US REFUND R 9/10/2018 29.26 070065 28.26 07860 ACT PIPE SUPPLY, INC I-S100260304.001 FIRE HYDRANT METER R 9/10/2018 506.25 070066 506.25 28710 AFFORD -IT TIRES 1-1082 245-75-17 TIRES (37--50) R 9/10/2018 290.00 070067 290.00 25940 ALAN PLUMMER ASSOCIATES, INC I-42790 LIFT STAT REPLACEMENT R 9/10/2018 7,009.35 070068 7,009.35 22620 ARAMARK UNIFORM SERVICE I-1157631081 UNIFORMS R 9/10/2D18 31.28 070069 1-1157631082 UNIFORMS R 9/10/2018 28.08 070069 1-1157631083 UNIFORMS & MATS R 9/10/2018 48.56 070069 1-1157631084 UNIFORMS R 9/10/2018 26.73 070069 134.65 00390 HILL UTTER FORD, INC. 1-334155 SWITCH ASSEMBLY R 9/10/2018 217.37 070070 217.37 19740 CHILD SMART I❑ I-463 PD ID CARD FOR NEW HIRE -PRICE R 9/10/2018 13.00 070071 13.00 29980 CONTROL SPECIALIST SERVICES L. I-18-5634-01 WORK ON PUMP @ LFT STAT R 9/10/2018 1,085.00 070072 1,085.00 00800 COSERV ELECTRIC 1-7/19/18 - 08/19/18 ELECTRIC AUGUST 2018 R 9/10/2018 2,277.81 070073 2,277.81 10 23 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE: VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT 0071E DATA BUSINESS FORMS INC. I-115989 NAME PLATES R 9/10/2018 102.76 070074 102.76 18190 DEPARTMENT OF INFORMATION RESO i-18071024N 3ULY LONG DISTANCE R 9/10/2018 38.05 07007S 38.05 28070 EPP, CINDY I -AUGUST 2018 YOGA INST. AUGUST 2018 R 9/10/2018 360.00 070076 360.00 18790 FUELMAN I-NP54142542 08/27/18 - 09/02/18 R 9/10/2018 3,062.89 070077 3,062.89 01070 GALLS INC. I-010560618 CUFPS/TCTIAL PEN/GLASS BREAKER R 9/10/2018 159.59 070079 1-010568292 8" DUTY BOOT SIZE 13D R 9/10/2018 131.96 070078 I-010568585 BELT HOLDER R 9/10/2018 38.71 070078 I-010569706 UNIF PANT/BRKWY SFTY VEST BARS R 9/10/2018 141.69 070078 I-010611068 DUTY 3CKT/5 SS UNIF SHRTS RAIN R 9/10/2018 521.74 070078 I-010611096 COLLAR STARS 770 CHIEF A. R 9/10/2018 6.28 070078 999.97 07750 HOME DEPOT CREDIT SERVICES C-68400128116 DUP INV - CHARGED TO CARD SV R 9/10/2018 9.36CR 070079 I-08/30/18 BATHROOM SUP FOR FIRE STAT R 9/10/2018 565.87 070079 556.51 19480 HUTHER & ASSOCIATES, INC I-6691 MONTHLY TESTING R 9/10/2018 690.00 070080 690.00 06550 KALAN SACKFLOW SERVICE I-18-8000 REPAIR BACKFLOW 9 WWTP R 9/10/2018 325.17 070081 325.17 01830 NOR-TEX COMMUNICATIONS I--22234 REPROGRAMMED PHONE R 9/10/2018 95.0E 070082 9S.00 08690 0`REILLY AUTO PARTS I-471258 BATTERY, CORE CHG, BATT FEE R 9/10/2018 215.92 4.32CR 070083 1-471771 BRAKE ROTOR (212-30) R 9/10/2018 126.04 2.52CR 070083 1-472809 32 OZ BRAKE FLUID R 9/10/2018 6.99 0.14CR 070083 341.97 02970 OFFICE DEPOT 1-187718932001 CALCULATOR R 9/10/2018 59.84 070084 59.84 25830 PACHECO KOCH, LLC I-43354 MCREYNOLDS ENGINEERING R 9/10/2019 2,736.40 070085 2,736.40 24 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK VENDOR I.D. NAME STATUS DATE 18380 R & T MECHANICAL I-33233 EMERGENCY REP TO AC AT CC R 9/10/2018 25020 SANGER HARDWARE I-B110102 ALL THREAD NUTS AND WASHERS R 9/10/2019 I-B110372 GALV NIPPLES / CAPS R 9/10/2019 I-C47931 GALV NIPPLE R 9/10/2019 I-C47982 MARKING PAINT R 9/10/2019 I-C47996 KEYS MADE - SCREWS R 9/10/2019 02370 SHERWIN WILLIAMS C-6999-9 CM - FOR OVER CHARGE R 9/10/2019 I-1637-2 HOSE FOR PAINT SPRAYER R 9/10/2019 I-6998-1 SPRAY GUN HANDICAP BLUE PAINT R 9/10/2018 24980 SHUMATE, 3ENNIFER I-691725811 ORIENTAL TRDING FOR RUN R 9/10/2018 31970 DAVID STONEKING I-18 GIS PROFESSIONAL SVCS R 9/10/2018 02690 TECHLINE, INC. I-1481120-00 UNIV TRANS CONNECTORS R 9/10/2018 07370 EDWARD 30NES INVESTMENTS I-INVPY9.14.18 EDWARD 30NES - O'CONNOR R 9/14/2018 15830 SANGER EDUCATION FOUNDATION IN I-SGFPY9.14.18 FOUNDATION-ISD R 9/14/2018 14470 UNITED WAY I -UN PY9.14.18 DONATIONS R 9/14/2018 06210 ALERT -ALL CORP I-218080606 KEY TAGS -REMAKING FROM ORDER R 9/14/2018 22620 ARAMARK UNIFORM SERVICE I-1157641816 MATS / CITY HALL R 9/14/2018 31790 ARCHPOINT LABS OF DENTON I-2701 DRUG TESTING R 9/14/2018 02460 AT&T MOBILITY 1-08282018 CELL PHONE 7/23/19 - 08/22/18 R 9/14/2018 PAGE: 12 INVOICE CHECK CHECK CHECK AMOUNT DISCOUNT NO STATUS AMOUNT 2,750.00 070086 2,750.00 14.97 070087 21.97 070097 1.99 070097 22.77 070087 6.59 070097 68.09 89.00CR 070098 39.90 070088 425.85 070088 376.75 78.93 070099 78.93 780.00 070090 780.00 1,526.00 070091 1,526.00 10.00 070092 10.00 7.50 070093 7.50 5.00 070094 5.00 630.00 070095 630.00 20.17 070096 20.17 325.00 070097 325.00 825.9S 070098 825.95 25 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE: 13 VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT 01550 ATMOS I-3023851975SEPT GAS 8.2.18 - 9.4.18 R 9/14/2018 45.06 070099 45.06 01550 ATMOS I-3023852778SEPT GAS 08.02.18 - 09.04.18 R 9/14/2019 45.06 070100 45.06 01550 ATMOS I-3023885028SEPT GAS 09.02.18 - 09.04.18 R 9/14/2019 45.06 070101 45.06 01550 ATMOS i-3033356465SEPT GAS 08.02.18 - 09.04.18 R 9/14/2019 52.70 070102 52.70 01550 ATMOS I-4003476999SEPT GAS 09.02.18 - 09.04.18 R 9/14/2018 53.36 070103 53.36 01550 ATMOS I-4004620446SEPT GAS 9.02.18 - 09.04.18 R 9/14/2018 48.78 070104 48.78 01550 ATMOS I-4014283051SEPT GAS 08.02.18 - 09.04.18 R 9/14/2018 48.79 070105 48.78 01550 ATMOS I-4018479164SEPT GAS 08.02.18 - 9.04.18 R 9/14/2018 49.78 070106 48.78 33190 B 3 PENNINGTON I-COMM CNTR REF COMM CNTR REF- 10/27/18 R 9/14/2018 70.00 070107 70.00 28340 BEWLEY, 3ANSON I-8.30.18 - POSTAGE POSTAGE 9.30.18 R 9/14/2018 24.70 070108 24.70 33050 BLUE MOON SPORTSWEAR INC 1-61416 CAPS R 9/14/2018 328.74 070109 328.74 00420 SOUND TREE MEDICAL, LLC 1-82965784 EMS SUPPLIES R 9/14/2018 588.63 070110 1-82968540 EMS SUPPLIES R 9/14/2018 27.29 070110 1-82968541 EMS SUPPLIES R 9/14/2018 7.35 070110 623.27 25690 BWI COMPANIES, INC I-14857602 CHEMICALS & FERTILIZERS R 9/14/2018 3,277.00 070111 3,277.00 26350 C & G ELECTRIC, INC I-33747 REVIVE PUMP /LOWER LIFT STAT R 9/14/2018 105.00 070112 105.00 26 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE: VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT 22300 CARD SERVICE CENTER C-172035336-001 3 USB DRIVES R 9/14/2019 27.24CR 070113 C-201808167656 AMAZON MEMBERSHIP CORRECTION R 9/14/2018 14.06CR 070113 C-201808167662 AMZN: PRIME MEMBERSHIP REFUND R 9/14/2018 12.99CR 070113 I-001613 WISEMAN: WEEDEATR, BLWR, EDGR R 9/14/2018 878.72 070113 I-00720 TX ANIMAL CONT ASSOC MEMBRSHP R 9/14/2018 50.00 070113 I-01122 NTSHRM LUNCH - JERIANA R 9/14/2018 18.00 070113 I-0124429 2 DESK/2 FILE CABINET-SRGT OFF R 9/14/2018 896.00 070113 I-02283 TCCA MBRSHP V. EAKMAN R 9/14/2018 40.00 070113 I-071418 ANDROID PHONE CLASS R 9/14/2018 75.00 070113 I-08.23.18 - HARB FR TRANSM JACK - HARBOR FRT R 9/14/2018 108.98 070113 I-08/23/18 HOME DEPOT - TRUFUEL R 9/14/2D18 71.88 070113 I-10-07-18 TEST DATE Ll CLERK CERT EXAM R 9/14/2018 75.00 070113 I-1D02538 TRI-STATE CSO CERT STUDY R 9/14/2018 112.95 070113 I-100518185 LABOR LAW POSTERS R 9/14/2018 239.60 070113 1-100580076 STUDY BOOKS -ICC R 9/14/2019 447.25 070113 I-111-4973983-314022 CUTOUTS,TREE FOR 1000 BK PROG R 9/14/2018 30.20 070113 I-11321081878563464 AMAZON -SUP FOR EASTER RUN R 9/14/2018 675.34 070113 I-114-1487736 BOO HOG BABY BOOK R 9/14/2018 6.48 070113 I-114-8894673 CHILDRENS PROGRAM R 9/14/2018 37.10 070113 I-12626623K VEHICLE REG UNIT 21-54 R 9/14/2018 9.50 070113 I-137541 DUMPSTER LINER - WWTP R 9/14/2018 999.80 070113 I-17112733 CADDY,BUTTONS, BINGO STKRS R 9/14/2018 48.93 070113 I-189228 CLASSFOR BOARD R 9/14/2018 68.00 070113 I-201908017570 3 USB DRIVES FOR ALINA R 9/14/2018 27.24 070113 I-201808077638 PIZZA HUT FOR COUNCIL MEETING R 9/14/2018 41.05 070113 I-201908077639 DG: LAUNDRY SOAP, DRYER SHEETS R 9/14/2018 15.10 070113 I-201908087647 SOUTHWEST/MORRISON FLIGHT R 9/14/2018 310.96 070113 I-201808147650 PIZZA HUT: P & Z TRAINING R 9/14/2018 45.41 070113 1-2018081476S1 EMBASSY SUITES R 9/14/2018 479.55 070113 I-201808147652 TDI: WW COLLECTION CLASS NIXON R 9/14/2018 295.00 070113 I-201808147653 TDI: WW COLLECTION CLASS MILLE R 9/14/2018 295.00 070113 I-201808167654 NCTCOG-PW CNSTRCTN STANDARDS R 9/14/2018 153.40 070113 I-201808167663 DG: CARPET CLEANER R 9/14/2018 4.71 070113 I-201808207664 DG: GIFT CARDS/TISSUE PAPER R 9/14/2018 52.17 070113 I-201808207665 KRGR: GIFT CARDS: SR PRIZES R 9/14/2018 79.99 070113 I-203768C EXH TEMP SENSOR R 9/14/2018 41.96 070113 I-203830C FUEL PUMP, JUMPER FUEL PUMP R 9/14/2018 380.16 070113 I-203846C MODULEKIT RETURN FUEL PUMP R 9/14/2018 112.50 070113 I-21894820686 PARK ENV EQUIP - CATCH BASIN R 9/14/2018 990.00 070113 i-3207593 RAMIE-MBRSHP-CODE COUNCIL R 9/14/2018 135.00 070113 I-4724205 AMZN: BOOKS FOR COLLECTION R 9/14/2018 48.18 070113 I-SSIBR0000186847 TX DEPT OF AGG - HUNTER R 9/14/2018 76.94 070113 I-5543286KA5SWFG9IL AMAZON PRIME MONTHLY R 9/14/2018 12.99 070113 I-SS43286KJSSFYVTBY AMAZON PRIME ANNUAL R 9/14/2018 119.00 070113 I-582EA000312992 WTR OPTR LICENSE FEE R 9/14/2018 111.00 070113 I-582L162864943 TCEQ WW FOR BERMAN R 9/14/2018 111.00 070113 I-61VRI172349DR REGISTRATION - UNIT 313-20 R 9/14/2018 9.50 070113 14 27 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE: VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT I-61VR126909031 REGISTRATION - BOLZ R 9/14/2018 10.25 070113 I-7142605 AMZN: BOOKS FOR COLLECTION R 9/14/2018 47.06 070113 I-8.3.18 - TAX CERT TAX CERT - 154653DEN R 9/14/2018 54.50 070113 I -TRANS # 677 SHIPPING R 9/14/2018 6.70 070113 8,481.06 25730 DATAPROSE, LLC I-DP1902790 AUG LATE BILLS & SEPT BILLS R 9/14/2018 2,459.85 070118 2,459,85 00740 DCAD 1-8002 2018 4TH QTR PMT R 9/14/2018 5,733.29 070119 5,733.29 26410 DENTON COUNTY CLERK I-8/31/18-MOW LIENS 8/31/2019 MOWING LIENS (8) R 9/14/2019 240.00 070120 240.00 00850 DENTON RECORD -CHRONICLE I-571394 PUB WRKS EMPLOYMENT AD R 9/14/2018 200.80 070121 I-571395 PUB WRKS EMPLOYMENT AD R 9/14/2018 40.00 070121 240.80 17640 DOLLAR GENERAL - CHARGED SALES 1-1000775322 OIL FOR BURN DEMO R 9/14/2018 15.75 070122 15.75 24660 DPS REPROGRAPHICS & DIST. SERV I-9.10.18 ORDER 25 ALCOHOL BLOOD TST KITS R 9/14/2018 162.50 070123 162.50 28280 EDSUITE I-2717 ANN LICENSE FOR WE3SITE R 9/14/2018 1,350.00 070124 1,3SO.00 26870 EIKON CONSULTANT GROUP I-18136.3-1 WINDSONG HILL EST PLN REV R 9/14/2018 2,380.00 070125 I-18136.4-1 SANGER CIR PLAN REV R 9/14/2019 2,301.47 070125 4,681.47 24090 EMERGENCY EQUIPMENT OF NORTH T I-18104 REP CONDENSER FAN/AC MED 672 R 9/14/2019 699.99 070126 699.99 23920 FERGUSON WATERWORKS I-0974057 2" BOLT CARBON STEEL COUPLING R 9/14/2019 229.44 070127 I-0975894 PVC TRUE UNION BALL VALVE R 9/14/2018 47.30 070127 276.74 31340 FIRST CHECK APPLICANT SCREENIN I-9783 3 PRICE -A TOSTADO-C VASQUEZ-HA R 9/14/2018 123.00 070128 123.00 32530 FRYER CONSTRUCTION CO I-4 REQ TO RELEASE RETAINAGE R 9/14/2018 13,416.00 070129 13,416.00 w 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK VENDOR I.D. NAME STATUS DATE 18790 FUELMAN I-NP54194916 FUEL 9/3/18 - 9/9/18 R 9/14/2019 01070 GALLS INC. I-010630657 GAT HOLDER R 9/14/2019 I-010652567 5.11 STRYKE PANT TR909 DKNV. R 9/14/2019 I-010658898 5.11 1 AAA FLASHLIGHT R 9/14/2019 14920 GLOBAL EQUIPMENT COMPANY I-11311S497 PICNIC TABLES R 9/14/2019 29620 GOODYEAR COMMERCIAL TIRE 1-233-1019382 265-60R17 (UNIT 12-20) R 9/14/2018 01350 HENDERSON, 3OHN I-048742539 TANKER ENDORS LICENSE R 9/14/2018 32770 KBS ELECTRICAL DISTRIBUTORS, I I-1126479 ELECT TAPE, CONN, GARDS R 9/14/2018 26900 THE LANE CONSTRUCTION CORPORAT I-1925128 TYPE D RAP 31.18 R 9/14/2018 28240 MARTINEZ BROTHERS CONCRETE AND I-71 WATER LINE REPAIR R 9/14/2018 I-71A STREET REPAIR R 9/14/2018 19500 NAPA AUTO PARTS I-548068 BRAK CALIPER PERSS R 9/14/2018 24940 NTTA 1-796314902 TOLLS FOR 53-58 R 9/14/2018 08690 O'REILLY AUTO PARTS I-467S32 STARTER R 9/14/2018 02970 OFFICE DEPOT I-191575337001 BINDERS, DIVIDERS, POST IT... R 9/14/2018 I-192045171001 COPY AND RECEIPT PAPER R 9/14/2018 1-194430466001 MAP PENCILS R 9/14/2018 I-195194779001 PKT FILE, PLATES, FORKS, R 9/14/2018 22470 PEREZ TREE SERVICE I-248961 TREE CHIPPING R 9/14/2019 PAGE: 16 INVOICE CHECK CHECK CHECK AMOUNT DISCOUNT NO STATUS AMOUNT 1,821.85 070130 1,821.85 17.09 070131 63.78 070131 18.02 070131 98.89 9,634.09 070132 9,634.09 562.75 070133 562.75 11.00 070134 11.00 1,107.7S 070135 1,107.75 1,660.34 070136 1,660.34 2,100.00 070137 2,700.00 070137 4,900.00 52.99 070139 52.99 9.40 070139 9.40 134.56 2.69CR 070140 131.87 38.56 070141 75.99 070141 2.79 070141 66.33 070141 183.67 1,800.00 070142 1,800.00 29 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE: 17 VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK INVOICE CHECK CHECK CHECK VENDOR I.Q. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT 33230 PILOT POINT AUTO PARTS I-15260-25922 OIL FILTER R 9/14/2019 42.24 070143 42.24 17260 QUEST CARE I-906276 1/1./1.8-1.2/31/1.8 DIR SVCS R 9/14/2019 6,500.00 070144 6,500.00 30260 RICOH USA I-101067819 SVC CONTRACT SEPT 18 R 9/14/201B 14M4 070145 1.42.04 16240 SCHAD & PULTE I-121226 SMALL ACETYLENE & CYLINDERS R 9/14/2019 24.00 070146 24.00 18620 STERICYCLE I-4008040581 HAZARDOUS DRUG DISPOSAL R 9/14/2018 222.10 070147 222.10 24620 SUPERION, LLC I-214437 DIGITAL DISPAT/MOBILE MAINT R 9/14/2018 144.00 070148 144.00 29390 SYMBOL ARTS, LLC i-0314527-IN NEW OFFICER & NEW SGT BDGS R 9/14/2018 230.00 070149 230.00 02690 TECHLINE, INC. I-1480730-00 CONNECTOR, PLUG, RODS R 9/14/2018 323.40 070150 I-1481195-02 TRANS/CONN/CABLE/CONDUIT R 9/14/2018 5,764.05 070150 I-1.481185-03 TRANS/CONN/CABLE/CONDUIT R 9/14/2018 505.00 070150 6,592.45 05350 TEXAS EXCAVATION SAFETY SYST 1-18-13757 MESSAGE FEE FOR 9/2018 R 9/14/2018 108.30 070151 108.30 33240 TEXAS MUNICIPAL POLICE ASSOC I-OCT 9-11, 2018 NEW SUPERVISOR COURSE R 9/14/2018 135.00 070152 135.00 33130 TRAFFIC GUARD INC 1-7513 BARRICADES R 9/14/2018 1,042.00 070153 1,042.00 19260 TYLER TECHNOLOGIES I-025-234086 MONTHLY FEE FOR SUPPORT R 9/14/2018 110.00 070154 I-025-234087 MONTHLY FEE FOR SUPPORT R 9/14/2018 125.00 070154 235.00 03440 VERMEER EQUIP. OF TEXAS I-P10872 BLADES FOR CHIPPER R 9/14/2018 187.72 070155 187.72 31280 WADDEL WILLIAMS ENTERPRISES IN 1-3934817 MOVIE R 9/14/2018 1,404.00 070156 1,404.00 30 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE: 18 VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2019 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT 09550 WATER TECH, INC. 1-69295 CHLORINE R 9/14/2018 1,320.00 070157 1,320,00 25270 WILLBROS T&D SERVICES, LLC I-26051660 B WRIGHT LINE LOCATE R 9/14/2018 17,290.00 070158 17,290.00 25940 ALAN PLUMMER ASSOCIATES, INC I-42635 SANGER PERMIT AMENDMENT R 9/24/2018 13,369.42 070159 I-42773 SANGER PERMIT AMENDMENT R 9/24/2018 367.88 070159 13,737.30 22620 ARAMARK UNIFORM SERVICE I-1157641812 UNIFORMS R 9/24/2D18 31.28 07D160 1-1157641813 UNIFORMS R 9/24/2018 23.70 070160 1-1157641814 UNIFORMS / MATS R 9/24/2018 48.56 070160 1-1157641815 UNIFORMS R 9/24/2018 26.73 070160 1-1157653427 UNIFORMS R 9/24/2018 27.90 070160 1-1157653429 UNIFORMS R 9/24/2018 23.70 070160 1-1157653429 UNIFORMS / MATS R 9/24/2018 48.56 070160 I-115765343 MATS / CITY HALL R 9/24/2018 M 17 070160 1-1157653430 UNIFORMS R 9/24/2018 26.73 070160 277.33 25760 BROOKS DIVERSIFIED SYSTEMS COM I-22125 QTR UL FIRE ALARM MONITORING R 9/24/2018 99.00 070161 99.00 02490 CENTURYLINK 1-08/10 - 09/09/18 PHONE 08/10/18 - 09/10/18 R 9/24/2018 1,727.20 070162 1,727.20 29180 D&D COMMERICAL LANDSCAPE MANAG 1-18431 AUG / SEPT MOWING R 9/24/2018 13,989.00 070163 13,989.00 22650 D&S ENGINEERING LABS, PLLC 1-18-8-000227 MCREYNOLDS PRO] R 9/24/2018 2,255.00 070164 2,255.00 22740 DENTON COUNTY AUDITOR I-SEPT 2018 SEPTEMBER 2018 DISPATCH R 9/24/2018 3,900.08 070165 3,900.08 00850 DENTON RECORD -CHRONICLE 1-09184016 LGL/PUBLIC NOTICES R 9/24/2018 1,308.95 070166 1,308.95 32480 DPC INDUSTRIES I-7670045954-18 CHMICAL FEED EQUIP IN3 NOZZLE R 9/24/2018 693.00 070167 I-767004854-18 CHEMICAL FEED EQUIP IN3 NOZZLE R 9/24/2018 220.00 070167 913.00 31 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE; 19 VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2019 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT 26870 EIKON CONSULTANT GROUP 1-17079.1-3 EIKON R 9/24/2018 510.00 070168 510.00 23820 FERGUSON WATERWORKS I-0974062 4 IN HUB SDR 35 PVC SEWER WYE R 9/24/2018 65.30 070169 65.30 01070 GALLS INC. C-010751639 CREDIT FOR RETURNED SHIRT R 9/24/2018 80.94CR 070170 I-010458943 2 SHIRTS RETURN SHIPPING R 9/24/2018 88.94 070170 8.00 33260 GAVIN R ERWIN I-CIT 23306 BOND REFUND CIT - 23306 R 9/24/2018 316.00 070171 316.00 08210 KWIK KAR I-91568 INSP 2011 CHVY TRUCK 56-58 R 9/24/2018 25.50 070172 I-91573 INSP 2008 FORD TRUCK 50-58 R 9/24/2018 7.00 070172 1-91574 INSP 2000 TRAILER 57-58 R 9/24/2018 7.00 070172 I-91991 STAT INSP 2011 CHEVY IMPALA R 9/24/2018 25.50 070172 I-92232 CHIPPER TRUCK INSPECTION R 9/24/2018 7.00 070172 72.00 26900 THE LANE CONSTRUCTION CORPORAT 1-1926382 TYPE D RAP 39.56 R 9/24/2018 1,738.95 070173 1,738.95 28050 LIONS CLUB I-SEPT 2018 SEPTEMBER 2018 R 9/24/2018 50.00 070174 50,00 16970 LONGHORN, INC. I-S3434801.001 VACUUM BREAKER FOR HOSE BIB R 9/24/2D18 71.92 1.44CR 07D175 70.48 01570 LOWE'S COMPANIES, INC. I-67080 BATTERIES, SAW, WRENCH PLIERS R 9/24/2018 475.67 070176 475.67 17900 LOWER COLORADO RIVER AUTHORITY I-LAB-0027625 QTR TESTING R 9/24/2018 216.19 070177 216.19 02970 OFFICE DEPOT 1-196202631001 OFFICE CHAIR R 9/24/2018 244.79 070178 1-196752551001 DRY ERASE BOARD R 9/24/2018 41.99 070178 286.78 30860 PAVECON PUBLIC WORKS, LP I-16-030-511.17R MCREYNOLDS CONSTRUCTION R 9/24/2018 265,206.11 070179 265,206.11 33100 QUICK STAGE INC 1-19154 OUTDOOR STAGE R 9/24/2018 6,411.97 070180 6,41L 97 32 10/01/2019 1:30 PM A/P HISTORY CHECK REPORT PAGE: 20 VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT 32910 READY REFRESH BY NESTLE 1-0810127279800 WATER / DELIVERY FEE R 9/24/2018 151.53 070181 151.53 25590 SCHNEIDER ENGINEERING I-00000045285 ERCOT TRANS OP DESIGNATION R 9/24/2018 1,160.09 070182 1,160.08 29190 STITCHIN' AND MORE CUSTOM GRAP I-09.13.18 HOODIES FOR WINTER R 9/24/2018 122.00 070183 122.00 32060 SUNNY BUNNY EASTER EGGS I-INv-297103804 PRE FILLED EASTER EGGS R 9/24/2018 1,935.00 070184 1,935.00 16090 TARRANT COUNTY MEDICAL EXAMINE I-S3224 TCQA SING SAMPLE C# S07301876 R 9/24/2018 370.00 070185 370.00 02690 TECHLINE, INC. I-147827S-00 STREET LIGHTS & POLES R 9/24/2018 4,250.00 070186 I-1481121-01 STREET LIGHTING R 9/24/2018 816.84 070186 5,066.84 05510 WASTE CONNECTIONS 1-1203272801 20 YD SEL CONTAINED SVC R 9/24/2018 1,399.26 070187 1,399.26 05510 WASTE CONNECTIONS I-AUG - 2018 SOLID WASTE AUG 2018 R 9/24/2018 60,529.95 070189 60,529.95 24970 WELLSPRING INSURANCE I-1414 CONSULTING FEES R 9/24/2018 2,000.00 070189 2,000.00 07370 EDWARD 30NES INVESTMENTS I-INVPY9.28.18 EDWARD 30NES - O'CONNOR R 9/28/2018 10.00 070190 10.00 15830 SANGER EDUCATION FOUNDATION IN I-SGFPY9.28.18 FOUNDATION-ISD R 9/29/2018 7.50 070191 7.50 14470 UNITED WAY I -UN PY9.28.18 DONATIONS R 9/29/2018 5.00 070192 5.00 00440 BRAZOS ELECTRIC 1-39405-RI-1 AUGUST 2019 E 9/29/2018 10,896.49 999999 10,896.48 01920 NICHOLS, 3ACKSON, DILLARD,HAGE I-16211 LEGAL SERVICES E 9/29/2018 3,209.75 999999 3,209.75 33 10/01/2018 1:30 PM A/P HISTORY CHECK REPORT PAGE: 21 VENDOR SET: 99 CITY OF SANGER BANK: POOL POOLED CASH ACCOUNT DATE RANGE: 9/01/2018 THRU 9/30/2018 CHECK INVOICE CHECK CHECK CHECK VENDOR I.D. NAME STATUS DATE AMOUNT DISCOUNT NO STATUS AMOUNT 02910 UPPER TRINITY I-w271809 AUG 2018 E 9/28/2018 23,757.97 999999 23,7S7.97 08120 ICMA-RC 1-457PY9.14.18 ICMA CITY OF SANGER 457 PLAN E 9/14/2018 2,027.32 999999 2,027.32 08120 ICMA-RC I-457PY9.28.18 ICMA CITY OF SANGER 457 PLAN E 9/28/2018 2,052.32 999999 2,052.32 24050 AEP ENERGY PARTNERS, INC I-17S-21144143 ELECT PURCHASE/ELECT TRANSM E 9/20/2018 536,262.00 999999 S36,262.00 31950 LCRA TRANSMISSION SVCS CORP I-T4AR0000114 TRANSMISSION OPER SVCS E 9/28/2018 25,000.00 999999 25,000.00 ' T O T A L S NO INVOICE AMOUNT DISCOUNTS CHECK AMOUNT REGULAR CHECKS: 199 628,602,04 31.99CR 628,150.35 HAND CHECKS: 0 0.00 0.00 0.00 DRAFTS: 8 167,417.05 0.00 167,417.05 EFT: 7 603,205.84 0.00 603,205.84 NON CHECKS: 1 0,00 0.00 0.00 VOID CHECKS: 0 VOID DEBITS 0.00 VOID CREDITS 0.00 0.00 0.00 TOTAL ERRORS: 0 NO INVOICE AMOUNT DISCOUNTS CHECK AMOUNT VENDOR SET: 99 BANK: POOL TOTALS: 215 1,399,224.93 31.99CR 1,398,773.24 BANK: POOL TOTALS: 215 1,399,224.93 31.99CR 1,398,773.24 REPORT TOTALS: 220 1,487,986.24 31.99CR 1,487,534.55 34 10/01/2019 1:36 PM A/P HISTORY CHECK REPORT PAGE: VENDOR SET: 99 CITY OF SANGER BANK: ALL BANKS DATE RANGE: 9/01/2018 THRU 9/30/2018 VENDOR I.D. NAME C-CHECK VOID CHECK C-CHECK VOID CHECK C-CHECK VOID CHECK C-CHECK VOID CHECK C--CHECK VOID CHECK `` TOTALS REGULAR CHECKS: HAND CHECKS: DRAFTS: EFT: NON CHECKS: VOID CHECKS: TOTAL ERRORS: 0 NO 0 0 0 0 0 5 VOID DEBITS VOID CREDITS CHECK STATUS DATE v 9/04/2018 v 9/14/2018 V 9/14/2018 V 9/14/2018 V 9/14/2018 INVOICE CHECK CHECK CHECK AMOUNT DISCOUNT NO STATUS AMOUNT 070019 070114 070115 070116 070117 INVOICE AMOUNT DISCOUNTS CHECK AMOUNT 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 NO INVOICE AMOUNT DISCOUNTS CHECK AMOUNT VENDOR SET: 99 BANK: TOTALS: 5 0.00 0.00 0.00 BANK: = TOTALS: 5 0.00 0.00 0.00 REPORT TOTALS: 5 0.00 0.00 0.00 Chris Felan Vice President Rates & Requlatory Affairs September 28, 2018 City Official Re: Rider GCR - Rate Filing under Docket No. 10170 Enclosed is Atmos Energy Corp., Mid -Tex Division's Statement of Rider GCR applicable for the October 2018 billing periods. This Statement details the gas cost component of the residential, commercial, and industrial sales rates for customers within your city. This filing is for informative purposes only and no action is required on your city's part. Should you have any questions, please let me know. Sincerely, Attachment Atmos Energy Corporation 5420 LBJ Freeway, Suite 1800 Dallas, TX 75240 P. 214-206-2568 F 214-206-2126 Christopher.Felan@atmosenergy.com 36 ATMOS ENERGY CORPORATION MID-TEX DIVISION STATEMENT OF RIDER GCR October, 2018 PREPARED IN ACCORDANCE WITH GAS UTILITIES DOCKET NO. 10170 Part (a) - Mid -Near Commodity Casts Line (a) (b) 1 Estimated Gas Cost per Unit: $0.19184 2 Estimated City Gate Deliveries: 64,974,320 3 Estimated Gas Cost: $12,464,674 4 Lost and Unaccounted For Gas % 2.5932% 5 Estimated Lost and Unaccounted for Gas $323,234 6 Total Estimated City Gate Gas Cost: $12,787,908 7 Estimated Sales Volume: 49,183,720 8 Estimated Gas Cost Factor - (EGCF) 0.26000 9 Reconciliation Factor- (RF): 0.00000 10 Taxes (TXS): 0.00000 11 Adjustment - (ADJ): 0.00000 Btu Factor Per MMBtu 12 Gas Cost Recovery Factor - (GCRF) 0.26000 per Ccf 0.1024 $2.5391 Part (b) - Pipeline Services Costs Line (a) (b) (c) (d} ._. (e) Rate I - Industrial Service Rate R - Residential Rate C - Commercial Rate T - Transportation' Fixed Costs 13 Fixed Costs Allocation Factors [Set by GUD 10170] 100.0000% 64.3027% 30.5476% 5.1497% 14 a. Current Month Fixed Costs of Pipeline Services $33,015,493 21,229,853 10,085,441 1,700,199 15 b, Plus: Second Prior Month Recovery Adjustment $0 $0 $0 $0 16 Net Fixed Costs $33,015,493 $21,229,853 $10,085,441 $1,700,199 Commodity Costs 17 a. Estimated Commodity Cost of Pipeline Services ($7,002,135) (4,596,063) (2,147,944) (258,125) 18 b. Plus: Second Prior Month Recovery Adjustment $0 $0 $0 $0 19 Net Commodity Cost of Pipeline Services ($7,002,135) ($4,596,063) ($2,147,944) ($258,128) 20 Total Estimated Pipeline Costs (Line 16 + Dine 19) $26,013,358 $16,633,790 $7,937,497 $1,442,071 21 Estimated Billed Volumes 71,751,000 Ccf 46,514,760 Ccf 4,531,306 MMBtu 22 Pipeline Cost Factor (PCF) [Line 20I Line 21] 0.23180 Ccf 0.17060 Ccf $0.3182 MMBtu 23 Gas Cost Recovery Factor - (GCRF) [Line 12] 0.26000 Ccf 0.26000 Ccf $2.5391 MMStu 24 Rider GCR 0.49180 Cef 0.43060 Ccf Rate 1 - $2.8573 MMBtu 25 Rate T - $0.3182 MMBtu Industrial Service and Transportation are reported in MMBtu. An MMBtu conversion factor of .1024 is used to convert from Cof. 37 r Christopher Felan Vice President Rates & Regulatory Affairs October 1, 2018 To the Honorable Mayor and City Officials Re: Tariff Revision Attached to this letter as Attachment A are revised copies of the tariffs required to implement rates. These tariffs include: R-Residential Sales, C-Commercial Sales, I -Industrial Sales, T- Transportation Sales and Rider WNA-Weather Normalization Adjustment. Please note that rates for these tariffs remain the same and have only been revised to reflect an updated header Applicable To: All Customers in the Mid -Tex Division in the Atmos Texas Municipalities Coalition ("ATM"). This filing is for informative purposes and no action is required on your City's part, beyond what has been recommended by your coalition representative. These tariffs should be substituted for the tariff book previously provided to you. Atmos Energy appreciates your partnership in providing service to the citizens of your community. Should you have any questions, please contact your local Atmos Energy, Manager of Public Affairs. Sincerely, "_ _rL L Christopher Felan Vice President, Rates and Regulatory Affairs Enclosure: Attachment A Atmos Energy Corporation 5420 LBJ Freeway, Suite 1800 Dallas, TX 75240 P (214) 206-25681 F (214) 206-21261 Christopher.Felan@atmosenergy.com m MID-TEX DIVISION RRC Tariff No: 29888 ATMOS ENERGY CORPORATION RATE SCHEDULE: R — RESIDENTIAL SALES ALL CUSTOMERS IN THE MID-TEX DIVISION IN THE ATMOS TEXAS APPLICABLE TO: MUNICIPALITIES COALITION ("ATM") EFFECTIVE DATE: Bills Rendered on or after 07/01/2018 PAGE: 29 Application Applicable to Residential Customers for all natural gas provided at one Point of Delivery and measured through one meter. Type of Service Where service of the type desired by Customer is not already available at the Point of Delivery, additional charges and special contract arrangements between Company and Customer may be required prior to service being furnished. Monthly Rate Customer's monthly bill will be calculated by adding the following Customer and Ccf charges to the amounts due under the riders listed below: Charge Amount Customer Charge per Bill $ 18.35 per month Rider CEE Surcharge $ 0.03 per month` Total Customer Charge $ 18.38 per month Commodity Charge — All Ccf $0.13734 per Ccf Gas Cost Recovery: Plus an amount for gas costs and upstream transportation costs calculated in accordance with Part (a) and Part (b), respectively, of Rider GCR. Weather Normalization Adjustment: Plus or Minus an amount for weather normalization calculated in accordance with Rider WNA. Franchise Fee Adjustment: Plus an amount for franchise fees calculated in accordance with Rider FF. Rider FF is only applicable to customers inside the corporate limits of any incorporated municipality. Tax Adjustment: Plus an amount for tax calculated in accordance with Rider TAX. Surcharges: Plus an amount for surcharges calculated in accordance with the applicable rider(s). Agreement An Agreement for Gas Service may be required. Notice Service hereunder and the rates for services provided are subject to the orders of regulatory bodies having jurisdiction and to the Company's Tariff for Gas Service. 'Reference Rider CEE -Conservation and Energy Efficiency as approved in GUD 10170. Surcharge billing effective July 1, 2018, 39 MID-TEX DIVISION RRC Tariff No: 29889 ATMOS ENERGY CORPORATION RATE SCHEDULE: C — COMMERCIAL SALES ALL CUSTOMERS IN THE MID-TEX DIVISION IN THE ATMOS TEXAS APPLICABLE TO: MUNICIPALITIES COALITION ("ATM") EFFECTIVE DATE: Bills Rendered on or after 07/01/2018 PAGE: 31 Application Applicable to Commercial Customers for all natural gas provided at one Point of Delivery and measured through one meter and to Industrial Customers with an average annual usage of less than 30,000 Ccf. Type of Service Where service of the type desired by Customer is not already available at the Point of Delivery, additional charges and special contract arrangements between Company and Customer may be required prior to service being furnished. Monthly Rate Customer's monthly bill will be calculated by adding the following Customer and Ccf charges to the amounts due under the riders listed below: Charge Amount Customer Charge per Bill $ 41.95 per month Rider CEE Surcharge $ (0.03) per month' Total Customer Charge $ 41.92 per month Commodity Charge —All Ccf $ 0.08746 per Ccf Gas Cost Recovery: Plus an amount for gas costs and upstream transportation costs calculated in accordance with Part (a) and Part (b), respectively, of Rider GCR. Weather Normalization Adjustment: Plus or Minus an amount for weather normalization calculated in accordance with Rider WNA. Franchise Fee Adjustment: Plus an amount for franchise fees calculated in accordance with Rider FF. Rider FF is only applicable to customers inside the corporate limits of any incorporated municipality. Tax Adjustment: Plus an amount for tax calculated in accordance with Rider TAX. Surcharges: Plus an amount for surcharges calculated in accordance with the applicable rider(s). Agreement An Agreement for Gas Service may be required. Notice Service hereunder and the rates for services provided are subject to the orders of regulatory bodies having jurisdiction and to the Company's Tariff for Gas Service. 'Reference Rider CEE -Conservation and Energy Efficiency as approved in GUD 10170. Surcharge billing effective July 1, 2018. .O MID-TEX DIVISION RRC Tariff No: 29890 ATMOS ENERGY CORPORATION RATE SCHEDULE: I — INDUSTRIAL SALES ALL CUSTOMERS IN THE MID-TEX DIVISION IN THE ATMOS TEXAS APPLICABLE TO: MUNICIPALITIES COALITION ("ATM") EFFECTIVE DATE: Bills Rendered on or after 04101/2018 PAGE: 33 Application Applicable to Industrial Customers with a maximum daily usage (MDU) of less than 3,500 MMBtu per day for all natural gas provided at one Point of Delivery and measured through one meter. Service for Industrial Customers with an MDU equal to or greater than 3,500 MM13tu per day will be provided at Company's sole option and will require special contract arrangements between Company and Customer. Type of Service Where service of the type desired by Customer is not already available at the Point of Delivery, additional charges and special contract arrangements between Company and Customer may be required prior to service being furnished. Monthly Rate Customer's monthly bill will be calculated by adding the following Customer and MMBtu charges to the amounts due under the riders listed below: Charge Amount Customer Charge per Meter $ 752.00 per month First 0 MMBtu to 1,500 MMBtu $ 0.3172 per MMBtu Next 3,500 MMBtu $ 0.2322 per MMBtu All MMBtu over 5,000 MMBtu $ 0.0498 per MMBtu Gas Cost Recovery: Plus an amount for gas costs and upstream transportation costs calculated in accordance with Part (a) and Part (b), respectively, of Rider GCR. Franchise Fee Adjustment: Plus an amount for franchise fees calculated in accordance with Rider FF. Rider FF is only applicable to customers inside the corporate limits of any incorporated municipality. Tax Adjustment: Plus an amount for tax calculated in accordance with Rider TAX. Surcharges: Plus an amount for surcharges calculated in accordance with the applicable rider(s). Curtailment Overpull Fee Upon notification by Company of an event of curtailment or interruption of Customer's deliveries, Customer will, for each MMBtu delivered in excess of the stated level of curtailment or interruption, pay Company 200% of the midpoint price for the Katy point listed in Platts Gas Daily published for the applicable Gas Day in the table entitled "Daily Price Survey." Replacement Index In the event the "midpoint" or "common" price for the Katy point listed in Platts Gas Daily in the table entitled "Daily Price Survey" is no longer published, Company will calculate the applicable imbalance fees utilizing a daily price index recognized as authoritative by the natural gas industry and most closely approximating the applicable index. 41 MID-TEX DIVISION ATMOS ENERGY CORPORATION RRC Tariff No: 29890 RATE SCHEDULE: I — INDUSTRIAL SALES ALL CUSTOMERS IN THE MID-TEX DIVISION IN THE ATMOS TEXAS APPLICABLE TO: MUNICIPALITIES COALITION ("ATM") EFFECTIVE DATE: Bills Rendered on or after 04/01/2018 PAGE: 35 Exhibit A Cities in the Atmos Texas Municipalities Coalition: AUSTIN STAR HARBOR BALCH SPRINGS TRINIDAD BANDERA WHITNEY BELTON BLOOMING GROVE BURNET CAMERON CEDAR PARK CLIFTON COMMERCE COPPERAS COVE CORSICANA ELECTRA FREDERICKSBURG GATESVILLE GOLDWAITE GRANBURY GREENVILLE GROESBECK HAMILTON HEATH HENRIETTA HICKORY CREEK HICO HILLSBORO LAM PASAS LEANDER LONGVIEW MARBLE FALLS MART MEXIA OLNEY PFUGERVILLE POINT PRINCETON RANGER RICE RIESEL ROCKDALE ROGERS ROUND ROCK SAN ANGELO SANGER SOMERVILLE W MID-TEX DIVISION RRC Tariff No: 29891 ATMOS ENERGY CORPORATION RATE SCHEDULE: T—TRANSPORTATION APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION IN THE ATMOS TEXAS MUNICIPALITIES COALITION ("ATM") EFFECTIVE DATE: Bills Rendered on or after 04/01/2018 PAGE: 37 Curtailment Overpull Fee Upon notification by Company of an event of curtailment or interruption of Customer's deliveries, Customer will, for each MMBtu delivered in excess of the stated level of curtailment or interruption, pay Company 200% of the midpoint price for the Katy point listed in Platts Gas Daily published for the applicable Gas Day in the table entitled "Daily Price Survey." Replacement Index in the event the "midpoint" or "common" price for the Katy point listed in Platts Gas Daily in the table entitled "Daily Price Survey" is no longer published, Company will calculate the applicable imbalance fees utilizing a daily price index recognized as authoritative by the natural gas industry and most closely approximating the applicable index. Agreement A transportation agreement is required. Notice Service hereunder and the rates for services provided are subject to the orders of regulatory bodies having jurisdiction and to the Company's Tariff for Gas Service. Special Conditions In order to receive service under Rate T, customer must have the type of meter required by Company. Customer must pay Company all costs associated with the acquisition and installation of the meter. 43 MID-TEX DIVISION ATMOS ENERGY CORPORATION RIDER: WNA -WEATHER NORMALIZATION ADJUSTMENT ALL CUSTOMERS IN THE MID-TEX DIVISION IN THE ATMOS TEXAS APPLICABLE TO: MUNICIPALITIES COALITION ("ATM") EFFECTIVE DATE: Bills Rendered on or after 11/01/2017 PAGE: 39 Provisions for Adjustment The Commodity Charge per Ccf (100 cubic feet) for gas service set forth in any Rate Schedules utilized by the cities of the Mid -Tex Division service area for determining normalized winter period revenues shall be adjusted by an amount hereinafter described, which amount is referred to as the 'Weather Normalization Adjustment." The Weather Normalization Adjustment shall apply to all temperature sensitive residential and commercial bills based on meters read during the revenue months of November through April. The five regional weather stations are Abilene, Austin, Dallas, Waco, and Wichita Falls. Computation of Weather Normalization Adjustment The Weather Normalization Adjustment Factor shall be computed to the nearest one -hundredth cent per Ccf by the following formula: (HSFi x (NDD-ADD) ) WNAFi - Ri (BLi + (HSFi x ADD) ) Where i - any particular Rate Schedule or billing classification within any such particular Rate Schedule that contains more than one billing classification WNAFI Weather Normalization Adjustment Factor for the ith rate schedule or classification expressed in cents per Ccf Ri = Commodity Charge rate of temperature sensitive sales for the ith schedule or classification. HSFi - heat sensitive factor for the ith schedule or classification divided by the average bill count in that class NDD = billing cycle normal heating degree days calculated as the simple ten-year average of actual heating degree days. ADD = billing cycle actual heating degree days. Bli = base load sales for the ith schedule or classification divided by the average bill count in that class The Weather Normalization Adjustment for the jth customer in ith rate schedule is computed as: WNA; = W NAFi x q;l Where q;j is the relevant sales quantity for the jth customer in ith rate schedule. MID-TEX DIVISION ATMOS ENERGY CORPORATION RIDER: WNA—WEATHER NORMALIZATION ADJUSTMENT ALL CUSTOMERS IN THE MID-TEX DIVISION IN THE ATMOS TEXAS APPLICABLE TO: MUNICIPALITIES COALITION ("ATM") EFFECTIVE DATE: Bills Rendered on or after 11/01/2017 PAGE: 41 Exhibit A Cities in the Atmos Texas Municloalities Coalition: AUSTIN STAR HARBOR BALCH SPRINGS TRINIDAD BAN DERA WHITNEY BELTON BLOOMING GROVE BURNET CAMERON CEDAR PARK CLIFTON COMMERCE COPPERAS COVE CORSICANA ELECTRA FREDERICKSBURG GATESVILLE GOLDWAITE GRANBURY GREENVILLE GROESBECK HAMILTON HEATH HENRIETTA HICKORY CREEK HICO HILLSBORO LAMPASAS LEANDER LONGVIEW MARBLE FALLS MART MEXIA OLNEY PFUGERVILLE POINT PRINCETON RANGER RICE RIESEL ROCKDALE ROGERS ROUND ROCK SAN ANGELO SANGER SOMERVILLE 45 jullimlos energy October 11, 2018 Christopher A. Felan Vice President Rates & Regulatory Affairs Re: Petition For De Novo Review of the Denial of the Statement of Intent Filed by Atmos Energy Corp., Mid -Tex Division by the Cities of Balch Springs, Bandera, Belton, et. al. City Official: Enclosed please find an informational electronic copy of the Atmos Energy Corp., Mid - TeX Division's ("Atmos,Energy" or the "Company") Appeal from the Actions of the Cities of Balch Springs, Bandera, Belton, et. al. and supporting testimony and exhibits (the "Rate Filing Package"). NO ACTION 1S REQUIRED ON THE PART OF YOUR CITY. This filing has been made with the Railroad Commission of Texas ("Commission") and the Company expects final action to take place no later than April 2019, Please do not hesitate to contact me if you have any questions. Sincerely, 6 Christopher A. Felan Vice President, Rates & Regulatory Affairs Atmos Energy Corporation, Mid -Tex Division Enclosures; Hardcopy of the Petition for De Novo Review CD copy of the Rate Filing Package filed with the Commission Atmos Energy Corporation 5420 L137 Freeway, Suite 1862 Dallas, TX 75240 P 214-206-2568 F 214-206-2126 Christopher.Felan@atmosenorgy.com m 2 GAS UTILITIES DOCKET NO. 10779 PETITION FOR DE NOVO REVIEW § OF THE DENIAL OF THE § BEFORE THE STATEMENT OF INTENT FILED BY § ATMOS ENERGY CORP., MID-TEX § RAILROAD COMMISSION OF DIVISION BY THE CITIES OF § BALCH SPRINGS, BANDERA, § TEXAS BELTON, ET. AL. § PETITION FOR REVIEW OF MUNICIPAL RATE DECISIONS TO THE HONORABLE RAILROAD COMMISSION OF TEXAS: COMES NOW Petitioner, Atmos Energy Corporation ("Atmos Energy"), Mid -Tex Division ("Mid -Tex" or the "Company"), and files this Petition for Review ("Petition") from the actions of the Cities of Balch Springs, Bandera, Belton, et. al. ("Cities"), which denied the Company's Statement of Intent to increase rates. The Company filed its municipal Statement of Intent with all cities participating in the Atmos Texas Municipalities ("ATM") Coalition on June 1, 2018, with the exception -of the City of Hico.1 Since that time, the Cities identified in Exhibit A to this Petition have acted to deny the Company's rate request. A copy of the denial ordinances are attached hereto as Exhibit B. This Petition is filed pursuant to the Gas Utility Regulatory Act, Title 3, TEX. UTIL. CODE ANN. (Vernon 2007). ("GURA") and the Rules of the Railroad Commission of Texas (the "Commission"). In support of this Petition, Mid -Tex respectfully shows as follows: I. SUMMARY OF RELIEF REQUESTED The Company requests that the Commission adopt the rate schedules attached to this petition as Exhibit C in order to: (1) afford the Company the opportunity to recover its reasonable and necessary costs to provide gas utility services; and (2) provide the Company with a fair and reasonable rate of return upon its invested capital used and useful in providing natural t The Statement of Intent was filed with the City ofHico on July 31, 2018, 1 HT. DETAILS OF PROPOSED CHANGES A. Test Year The Company's proposed cost of service for the Mid -Tex Division as set forth in the Statement of Intent filed with the City and in the Rate Filing Package is based on the twelve- month period ending December 31, 2017, updated for known changes and conditions that are measurable with reasonable accuracy. B. Expected Revenue Change For the twelve (12) month period ending December 31, 2017, Atmos Energy's adjusted gas sales and transportation revenues from the ATM Coalition cities affected by this Statement of Intent totaled approximately $119,541,598. The proposed rates will increase such annual revenues by approximately $4,393,646 (which does not include rate case expenses of $79,240). If approved, the proposed rates would increase Atmos Energy's aggregate revenues from the incorporated areas affected by this Statement of Intent by 3.68%, including gas costs, or 7.92%, excluding gas cost. Because the proposed changes will increase the total aggregate revenues of the Company within the incorporated areas affected by the Statement of Intent by more than two and one half percent, the proposed rate increase constitutes a major change as that terra is defined by § 104.101 of the Texas Utilities Code. C. Class and Number of Customers Affected The Statement of Intent filed by Atmos Energy on June 1, 2018, affects customers inside the municipal limits of approximately forty-six (46) incorporated cities, as listed on Exhibit D that is attached hereto. The following table shows the number of customers by class within the incorporated areas served by the Mid -Tex Division that will be affected by the proposed changes: 3 e and an updated Class Cost of Service Study. Exhibit G, attached, shows the effect of the proposed change to an average bill for each class of customers. Excluding gas cost, residential customers will see an 11.06% increase in the average monthly bill, commercial customers will see a 4.31% decrease in the average, monthly bill, industrial customers will see a 9.29% decrease in the average monthly bill, and transportation customers will see a 9.29% decrease in the average monthly bill. E. Other Proposed Tariff Changes In addition to the proposed change in rates reflected in its residential, commercial, industrial and transportation rate schedules (Rates R, C, I and T), the Company proposes to revise its Rider WNA and Rider SUR as identified below: (1) Rider WNA The Company proposes to update the heat load and base load factors reflected in its Rider WNA. The Company requests these changes in order to synchronize these factors with proposed rates and the updated billing determinant calculations used to develop the proposed rates. (2) Rider SUR The Company proposes to recover $79,240 of city rate case expenses incurred to review the 2016 Rate Review Mechanism expensed in the 2017 calendar year over a 12-month period through Rider SUR. The Company also requests the establishment of GRIP factors, a new benchmark for pension -related and other post -employment benefits and approval of the amortization of the Company's excess deferred income taxes (EDIT). W1 50 VL COMPANY REPRESENTATIVES FOR NOTIFICATION Mid-Tex's business address and telephone number for purposes of this filing is: 5420 LB3 Freeway, Suite 1600 Dallas, Texas 75240 214-303-9199 (phone) 214-206-2131 (fax) Mid-Tex's authorized representatives are: Chris Felan Ann M. Coffin Vice President, Rates and Regulatory Coffin Renner LLP Affairs 1011 W. 315t Street 5420 LB3 Freeway, Suite 1600 Austin, Texas 78705 Dallas, Texas 75240 512.879.0900 (phone) 214,206.2568 (phone) 512.879.0912 (fax) 214.206.2131 (fax) All pleadings, motions, orders, and other documents filed in this proceeding should be served on Mr. Felan and Ms. Coffin at the above -stated addresses. VII. CONCLUSION WHEREFORE, PREMISES CONSIDERED, the Company requests that the Commission set this matter for hearing on the Gas Services Division Docket; that upon Final Hearing, the Commission issue an order adopting a schedule of rates for residential, commercial, industrial and transportation customers in the ATM Coalition cities identified herein consistent with the rate schedules set forth in Exhibit C; and for such further legal, equitable and necessary relief to which the Company may be entitled. 7 51