Loading...
05-26-2015 (City Council) Agenda Packet Wylie City Council CITY OF WYLI NOTICE OF MEETING Regular Meeting Agenda May 26, 2015— 6:00 pm Wylie Municipal Complex Council Chambers/Council Conference Room 300 Country Club Road, Building #100 Eric Hogue Mayor Keith Stephens Mayor Pro Tern Diane Culver Place 2 Todd Wintters Place 3 Bennie Jones Place 4 William Whitney Ill Place 5 David Dahl Place 6 Mindy Manson City Manager Richard Abernathy City Attorney Carole Ehrlich City Secretary In accordance with Section 551.042 of the Texas Government Code, this agenda has been posted at the Wylie Municipal Complex, distributed to the appropriate news media, and posted on the City website: www.wylietexas.gov within the required time frame. As a courtesy, the entire Agenda Packet has also been posted on the City of Wylie website: www.wylietexas.gov. The Mayor and City Council request that all cell phones and pagers be turned off or set to vibrate. Members of the audience are requested to step outside the Council Chambers to respond to a page or to conduct a phone conversation. The Wylie Municipal Complex is wheelchair accessible. Sign interpretation or other special assistance for disabled attendees must be requested 48 hours in advance by contacting the City Secretary's Office at 972.516.6020. Hearing impaired devices are available from the City Secretary prior to each meeting. CALL TO ORDER Announce the presence of a Quorum. INVOCATION & PLEDGE OF ALLEGIANCE PRESENTATIONS • Presentation of Junior Mayor Emily Edwards • Presentation by 1LT Robert F.Welch III Charity to the Wylie PD K-9 Unit CITIZENS COMMENTS ON NON-AGENDA ITEMS Residents may address Council regarding an item that is not listed on the Agenda. Residents must fill out a non-agenda form prior to the meeting in order to speak. Council requests that comments be limited to three (3) minutes. In addition, Council is not allowed to converse, deliberate or take action on any matter presented during citizen participation. May 26,2015 Wylie City Council Regular Meeting Agenda Page 2 of 3 CONSENT AGENDA All matters listed under the Consent Agenda are considered to be routine by the City Council and will be enacted by one motion. There will not be separate discussion of these items. If discussion is desired, that item will be removed from the Consent Agenda and will be considered separately. A. Consider, and act upon, approval of the Minutes of May 12, 2015 Regular Meeting of the Wylie City Council. (C. Ehrlich, City Secretary) B. Consider, and act upon, the monthly Revenue and Expense Report for the Wylie Economic Development Corporation as of April 30,2015. (S. Satterwhite, WEDC Director) C. Consider, and place on file,the City of Wylie Monthly Investment Report for April 30,2015. (L. Bantz, Finance Director) D. Consider, and place on file, the City of Wylie Monthly Revenue and Expenditure Report for April 30,2015. (L. Bantz, Finance Director) E. Consider, and act upon approval of a Final Plat for Westgate Station Addition on 10.060 acres, generally located south east corner of Westgate Way and Fleming. (R. 011ie, Development Services Director) REGULAR AGENDA 1. Consider and act upon Ordinance No. 2015-21 of the City Council of the City of Wylie, Texas, approving a NEGOTIATED settlement between the Atmos Cities Steering Committee ("ACSC") and ATMOS ENERGY CORP., Mid-Tex Division regarding the company's 2014 and 2015 rate review mechanism filings; approving a settlement agreement with attached rate tariffs and proof of revenues; declaring Existing rates to be unreasonable; adopting tariffs that reflect rate adjustments consistent with the Negotiated Settlement; finding the rates to be set by the Settlement Tariffs to be just and reasonable and in the public interest; Requiring the Company to reimburse ACSC's reasonable ratemaking expenses; determining that this ordinance was passed in accordance with the requirements of the Texas Open Meetings Act; adopting a saving clause; declaring an effective date; and requiring delivery of this Ordinance to the company and the ACSC's legal counsel. (M. Manson, City Manager) Executive Summary The City, along with other similarly situated cities served by Atmos Energy Corp.,Mid-Tex Division("Atmos Mid- Tex" or "Company"), is a member of the Atmos Cities Steering Committee ("ACSC"). The RRM Tariff was adopted by the City as an alternative to the Gas Reliability Infrastructure Program("GRIP"),the statutory provision that allows Atmos to bypass the City's rate regulatory authority to increase its rates annually to recover capital investments. In February 2014, Atmos Mid-Tex filed its second annual filing under the Rate Review Mechanism ("RRM") Tariff, seeking an increase of$45.7 million. Although ACSC attempted to reach a settlement with the Company as it had in past years, the wide differences between the Company and ACSC's consultants' recommendations made a compromise impossible. On the recommendation of the ACSC Executive Committee and ACSC's legal counsel,the City in 2014 adopted a Resolution denying the requested rate increase. 2. Consider and act upon Ordinance 2015-20 designating truck routes to regulate the activities of commercial vehicles in the City of Wylie (C. Holsted, City Engineer) Executive Summary The ordinance regulating truck routes within the Wylie city limits was last updated in 1982. The Texas Department of Transportation released ownership of Ballard Avenue from Brown Street to SH 78 to the city. This portion of roadway was previously designated a truck route, however, due to increased pedestrian and vehicular traffic in the downtown area,staff recommends that this section of roadway be removed. May 26,2015 Wylie City Council Regular Meeting Agenda Page 3 of 3 READING OF ORDINANCES Title and caption approved by Council as required by Wylie City Charter,Article III, Section 13-D. ADJOURNMENT If during the course of the meeting covered by this notice,the City Council should determine that a closed or executive meeting or session of the City Council or a consultation with the attorney for the City should be held or is required,then such closed or executive meeting or session or consultation with attorney as authorized by the Texas Open Meetings Act,Texas Government Code§551.001 et. seq.,will be held by the City Council at the date,hour and place given in this notice as the City Council may conveniently meet in such closed or executive meeting or session or consult with the attorney for the City concerning any and all subjects and for any and all purposes permitted by the Act,including,but not limited to,the following sanctions and purposes: CERTIFICATION I certify that this Notice of Meeting was posted on May 22, 2015 at 5:00 p.m. as required by law in accordance with Section 551.042 of the Texas Government Code and that the appropriate news media was contacted. As a courtesy, this agenda is also posted on the City of Wylie website: www.wylietexas.gov. Carole Ehrlich,City Secretary Date Notice Removed Wylie City Council CITY OF WYLIE .......................................................................................... Minutes Wylie City Council Meeting Tuesday, May 12, 2015 — 6:00 p.m. Wylie Municipal Complex — Council Chambers 300 Country Club Road, Bldg. 100 Wylie, TX 75098 CALL TO ORDER Announce the presence of a Quorum. Mayor Eric Hogue called the meeting to order at 6:05 p.m. City Secretary Carole Ehrlich took roll call with the following City Council members present: Mayor Eric Hogue, Mayor pro tem Keith Stephens, Councilman Bennie Jones, Councilman David Dahl, Councilman Todd Wintters, Councilman Nathan Scott, and Councilman William Whitney III. Staff present were: City Manager, Mindy Manson; Assistant City Manager, Jeff Butters; Planning Director, Renae' 011ie; Finance Director, Linda Bantz; Fire Chief, Brent Parker; Public Services Director, Mike Sferra; City Engineer, Chris Hoisted; Assistant Police Chief, Anthony Henderson; City Secretary, Carole Ehrlich; Public Information Officer, Craig Kelly; and various support staff. INVOCATION & PLEDGE OF ALLEGIANCE Mayor pro tem Stephens gave the invocation. Presentation of Colors and Pledge of Allegiance was presented by the Plano Chapter #37 of the Texas Society, Sons of the American Revolution. PRESENTATIONS • Presentation and Appreciation to Councilman Nathan Scott Mayor Hogue presented outgoing Councilman Nathan Scott with a plaque of appreciation for his service on the Wylie City Council from May 2012 to May 2015. • Presentation-"Junior Mayor of the Day"- Carter Riggins Birmingham Elementary Mayor Hogue introduced Junior Mayor for the Day Carter Riggins. Mayor Hogue explained Carter won the silent auction for Birmingham Elementary where he is a student. The winner Minutes May 12, 2015 Wylie City Council Page 1 receives the designation as "Mayor for the Day." Mayor Hogue administered the student oath of office and Carter presided along with the Mayor during the council meeting. All funds raised from the silent auction go to the local campus PTA. • Proclamation declaring Motorcycle Safety Awareness Month; The Christians and Road Dogs Motorcycle Clubs Mayor Hogue presented proclamations to The Christians and The Road Dogs motorcycle organizations recognizing May as Motorcycle Safety Awareness Month. Members from various motorcycle groups were present. • Presentation of Public Service Awards to the Wylie Police & Fire Departments by Plano Chapter#37 of the Texas Society, Sons of the American Revolution Members of the Plano Chapter#37 of the Texas Society, Sons of the American Revolution were present to present certificates of appreciation to the following public safety personnel: • Firefighter—John Hunt • EMS —Andrew Johnson • Telecommunicator—Tristan Whittle • Police - Officer Mark Howeth CITIZENS COMMENTS ON NON-AGENDA ITEMS Residents may address Council regarding an item that is not listed on the Agenda. Residents must fill out a non- agenda form prior to the meeting in order to speak. Council requests that comments be limited to three (3) minutes. In addition, Council is not allowed to converse, deliberate or take action on any matter presented during citizen participation. No citizens were present to address Council during Citizens comments. CONSENT AGENDA All matters listed under the Consent Agenda are considered to be routine by the City Council and will be enacted by one motion. There will not be separate discussion of these items. If discussion is desired, that item will be removed from the Consent Agenda and will be considered separately. A. Consider, and act upon, approval of the Minutes of April 28, 2015 Regular Meeting of the Wylie City Council. (C. Ehrlich, City Secretary) B. Consider, and act upon, authorizing the Mayor to enter into a Cooperative Agreement for additional Law Enforcement Services, between the City of Wylie, Lavon Lake, Texas initiates Agreement No. W9126G-15-P-0080 and the U.S. Army Corps of Engineers. This agreement is for the provisions of additional Law enforcement Services from May 15, 2015 through September 08, 2015 for a sum not to exceed $66,473.07. (A. Henderson, Asst. Chief of Police) C. Consider, and act upon, approval of a Final Plat for Kreymer Estates Ph.4. The Plat will create 78 single family residential lots and one(1) open space area on 27.312 acres and dedicate the necessary rights-of-way and parkland dedication. Subject property generally Minutes May 12, 2015 Wylie City Council Page 2 located south of E.Brown St. and west of WA Allen Blvd. (R. 011ie, Development Services Director) D. Consider, and act upon, Ordinance No. 2015-17, amending the zoning from Neighborhood Services (NS) to Planned Development-Neighborhood Services (PD-NS-) to accommodate a proposed Mixed Use Development on 11 acres, generally located east of Country Club Road, south of WISD Bus Barn.ZC 2015-02 (R. 011ie, Development Services Director) Mayor Hogue requested Item A of the Consent Agenda be pulled and considered under the regular agenda. Consensus of the Council was to remove Item A from the Consent Agenda. Council Action A motion was made by Councilman Scott, seconded by Councilman Wintters to approve Items B, C, and D of the Consent Agenda as presented. A vote was taken and the motion passed 7- 0. REGULAR AGENDA A. Consider, and act upon, approval of the Minutes of April 28, 2015 Regular Meeting of the Wylie City Council. (C. Ehrlich, City Secretary) Mayor Hogue asked that under Invocation and Pledge of Allegiance, page 1, that Boy Scout Troop 178 be removed as it was from another meeting. Council Action A motion was made by Councilman Dahl, seconded by Councilman Scott to approve Item A of the Consent Agenda with the one noted change. A vote was taken and the motion passed 7-0 1. Hold a Public Hearing and consider, and act upon, a change in zoning from Corridor Commercial (CC) to Multi-Family (MF), for multi-family residential development on 10 acres, located north of S.H. 78 and east of Eubanks Lane. ZC 2015-03 (R. 011ie, Development Services Director) Executive Summary Development Services Director 011ie addressed Council stating that the applicant has submitted a letter to withdraw the request to rezone 10 acres from Corridor Commercial (CC) to Multi-Family (MF), for multi- family residential development. The letter was received by Staff on April 1, 2015. 011ie reported the Planning & Zoning Commission voted 5-0 to recommend acceptance of the WITHDRAWAL. Public Hearinci Mayor Hogue opened the public hearing on Zoning Case No. 2015-03 at 6:35 p.m. asking anyone present wishing to address Council top come forward. Minutes May 12, 2015 Wylie City Council Page 3 There were no citizens wishing to address Council. Mayor Hogue closed the public hearing at 6:36 p.m. Council Action A motion was made by Mayor pro tern Stephens, seconded by Councilman Dahl to accept a WITHDRAWAL for a change in zoning from Corridor Commercial (CC) to Multi-Family (MF), for multi- family residential development on 10 acres, located north of S.H. 78 and east of Eubanks Lane. ZC 2015- 03. A vote was taken and the motion passed 7-0. 2. Consider, and act upon, Ordinance No. 2015-18, a request in accordance with Ordinance 2007-21 from Dr.Vinay Kumar to waive the requirement for an appraisal and to abandon a portion of Right-of-Way described as a 20' alley and utility easement, within the Keller's First Addition, Lot 8R, Block 3, consisting of 0.060 acres or approximately 2,600 square feet. (R. 011ie, Development Services Director) Executive Summary Development Services Director 011ie addressed Council stating that in accordance with Ordinance No. 2007-21, Section 2.12.A.5, the applicant, Dr. Vinay Kumar is requesting that the Council waive the requirement for a certified appraisal of 2,580 square feet of public right-of-way. The subject alley and utility easement is part of the Keller's First Addition, Lot 8R, Block 3 as recorded in Volume G, Page 391, of the Deed Records of Collin County, Texas and is solely contained within the boundaries of the subject platted lot. The purpose of the request is to allow the owner/applicant to expand the recently approved development for a medical office. The applicant proposes that the cost alone for the appraisal is slightly less or equals the cost of the value of the unimproved alley. Dr. Kumar has included a letter outlining the request based on an appraisal of recently abandoned vacant right-of-way (Exhibit "H"). The applicant is asking that the Council accept a value of$1.00 per square foot. A Site Plan for a 5,687 s.f. medical office (Exhibit "I") was approved by the Planning and Zoning Commission on April 7th. However, if the Council approves the waiver and adopts an Ordinance to abandon the right-of-way, it will allow the applicant to increase the overall square footage of his building. Council Action A motion was made by Councilman Wintters, seconded by Councilman Dahl to approve Ordinance No. 2015-18 from Dr. Vinay Kumar to waive the requirement for an appraisal and to abandon a portion of Right-of-Way described as a 20' alley and utility easement, within the Keller's First Addition, Lot 8R, Block 3, consisting of 0.060 acres or approximately 2,600 square feet. A vote was taken and the motion passed 7-0. READING OF ORDINANCES Title and caption approved by Council as required by Wylie City Charter,Article III, Section 13-D. City Secretary Ehrlich read the captions to Ordinance No.'s 2015-17 and 2015-18 into the official record. Minutes May 12, 2015 Wylie City Council Page 4 WORK SESSION • Wylie Recreation Center Operations Budget Assessment-Parks and Recreation Board Update Robert Diaz, Parks and Recreation Superintendent and Matt Rose, Parks and Recreation Board Chair addressed Council, presenting an evaluation of the recommendations presented by Ballard-King, Recreation Consultant, at the September 23, 2014 work session. At that September 2014 work session the Council directed staff to prioritize the recommended changes in categories of "can do" and "want to do" as part of their evaluation. Superintendent Diaz explained how staff worked with a Parks and Recreation Board to form a subcommittee to begin the evaluation process and then how the full Board reviewed those findings. The evaluation process took multiple meetings and in the end resulted in a list of recommendations and a sample of some fee options. The consultant recommendations that were discussed with Council were: • Hiring a full-time Front Desk Manager and adjust other full-time staff responsibilities accordingly. • Develop a 5 year prioritized capital improvement plan. • Drop credit card surcharge for online program registration, revamp 1-month membership fees with family option, fee increase of 5% every 2 years, and consider elimination of resident/non-resident fee. The Council asked various questions about the recommendations and the fee options presented to them. Mayor Hogue asked Council members for some direction for staff. Council consensus was that the recommendations presented overall were good and they appreciated the efforts of the Board and staff. Regarding fees specifically, Council provided staff with the following direction: • Eliminate the credit card charge levied on users for on-line registrations. • Fees should remain the same — no fee increase at this time. • Increase the proposed household four-pack to a household six-pack, i.e., a household membership can include up to six members of the same household. Staff will follow this direction and incorporate the necessary fee revisions into an agenda item for consideration by Council in the near future. • Discuss the proposed Great Texas Magic Festival of Wylie, TX proposed to take place October 26-30,2015 Dal Sanders, representing the Society of American Magicians, Dallas Chapter, presented a short report requesting City support for a proposed Great Texas Magic Festival of Wylie, TX to take place the week of October 26-30, 2015. He explained some of the events that would be provided. He requested no funding for the event just support with regard to staff time to facilitate some of the advertising and event planning. Direction from Council was to move forward with plans for the event with the support of the Council. Minutes May 12, 2015 Wylie City Council Page 5 RECONVENE INTO REGULAR SESSION Mayor Hogue reconvened into Regular Session at 7:35 p.m. ADJOURNMENT A motion was made by Councilman Scott, seconded by Councilman Jones to adjourn the meeting at 7:36 p.m. A vote was taken and the motion passed 7-0. Eric Hogue, Mayor ATTEST: Carole Ehrlich, City Secretary Minutes May 12, 2015 Wylie City Council Page 6 �` �� ,�• Wylie City Council :-f AGENDA REPORT a ____di Meeting Date: May 26, 2015 Item Number: B Department: WEDC (City Secretary's Use Only) Prepared By: Angel Wygant Account Code: Date Prepared: May 15, 2015 Budgeted Amount: Exhibits: 1 Subject Consider and place on file, the monthly Revenue and Expenditure Report for the Wylie Economic Development Corporation as of April 30, 2015. Recommendation Motion to approve, the monthly Revenue and Expenditure Report for the Wylie Economic Development Corporation as of April 30, 2015. Discussion The Wylie Economic Development Corporation (WEDC) Board of Directors approved the attached financials on May 15, 2015. (Rev 01/2014) Page 1 of 1 5-12-2015 04:39 PM CITY OF WYLIE PAGE: 1 BALANCE SHEET AS OF: APRIL 30TH, 2015 111-WYLIE ECONOMIC DEVEL CORP ACCOUNT$ TITLE ASSETS 1000-10110 CLAIM ON CASH AND CASH EQUIV. 1,996,776.31 1000-10115 CASH - WEDC - INWOOD 0,00 1000-10135 INWOOD BANK - ESCROW 0,00 1000-10180 DEPOSITS 2,000.00 1000-10198 OTHER - MISC CLEARING 0.00 1000-10341 TEXPOOL 0,00 1000-10343 LOGIC 0,00 1000-10481 INTEREST RECEIVABLE 0.00 1000-11511 ACCTS REC - MISC 26,635.86 1000-11517 ACCTS REC - SALES TAX 0.00 1000-12810 LEASE PAYMENTS RECEIVABLE 0.00 1000-12996 LOAN RECEIVABLE 75,341.21 1000-12997 ACCTS REC - JTM TECH 0.00 1000-12998 ACCTS REC - FORGIVEABLE LOANS 685,2066.16 1000-14112 INVENTORY - MATERIAL/ SUPPLY 0.00 1000-14116 INVENTORY - LAND & BUILDINGS 5,268,291„36 1000-14118 INVENTORY - BAYCO/ SANDEN BLVD 0.00 1000-14310 PREPAID EXPENSES - MISC 0,.00 1000-14410 DEFERRED CHARGES 706,518„00 8,760,768.90 TOTAL ASSETS 8,760,768.90 LIABILITIES 2000-20110 FEDERAL INCOME TAX PAYABLE 0.00 2000-20111 MEDICARE PAYABLE 0.00 2000-20112 CHILD SUPPORT PAYABLE 0.00 2000-20113 CREDIT UNION PAYABLE 0.00 2000-20114 IRS LEVY PAYABLE 0.00 2000-20115 NATIONWIDE DEFERRED COMP 0.00 2000-20116 HEALTH INSUR PAY-EMPLOYEE ( 518.10) 2000-20117 TMRS PAYABLE 0.00 2000-20118 ROTH IRA PAYABLE 0.00 2000-20119 WORKERS COMP PAYABLE 0.00 2000-20120 FICA PAYABLE 0.00 2000-20121 TEC PAYABLE 0.00 2000-20122 STUDENT LOAN LEVY PAYABLE 0.00 2000-20123 ALIMONY PAYABLE 0.00 2000-20124 BANKRUPTCY PAYABLE 0.00 2000-20125 VALIC DEFERRED COMP 0.00 2000-20126 ICMA PAYABLE 0.00 2000-20127 EMP. LEGAL SERVICES PAYABLE 0.00 2000-20130 FLEXIBLE SPENDING ACCOUNT 300.00 2000-20131 EDWARD JONES DEFERRED COMP 0.00 2000-20132 EMP CARE ELITE 12.00 2000-20151 ACCRUED WAGES PAYABLE 0.00 2000-20180 ADDIT EMPLOYEE INSUR PAY 0.00 2000-20199 MISC PAYROLL PAYABLE 0.00 2000-20201 AP PENDING 3,084.66 5-12-2015 04:39 PM CITY OF WYLIE PAGE: 2' BALANCE SHEET AS OF: APRIL 30TH, 2015 Ill-WYLIE ECONOMIC DEVEL CORP ACCOUNT* TITLE 2000-20210 ACCOUNTS PAYABLE 40506.00 2001-20530 PROPERTY TAXES PAYABLE 0.00 2000-20540 NOTES PAYABLE 706,518,00' 2000-20110 DUE TO GENERAL FUND 0.00 2000-22270 DEFERRED REVENUE 231,630.19 2000-22275 DEFERRED REV - LEASE PRINCIPAL 0.00 2000-22280 DEFERRED REVENUE - LEASE TNT 0.00 2100-22515 RENTAL DEPOSITS 2,500.00 TOTAL LIABILITIES 548,112.15 EQUITY 3000-34110 FUND BALANCE - RESERVED 0,00 3000-34590 FUND BALANCE-UNRESERV/UNDESIG 7,375,833.02 TOTAL BEGINNING EQUITY 7,375,833,02 TOTAL REVENUE 1,507,621.88 TOTAL EXPENSES 1,470,804.75 REVENUE OVER/(UNDER) EXPENSES 436,823.13 TOTAL EQUITY & OVER/(UNDER1 7,812,656.15 TOTAL LIABILITIES, EQUITY S OVER/(UNDER) 8,760,768.90 5-12-2015 04:39 PM CITY OF WYLIE PAGE: 1 BALANCE SHEET AS OF: APRIL 30TH, 2015 922-GEN LONG TERM DEBT (WEDC) ACCOUNT 9 TITLE ASSETS 1000-10312 GOVERNMENT NOTES 0.00 1000-18110 LOAN - WEDC 0.00 1300-18120 LOAN - BIRMINGHAM 0.00 1000-18210 AMOUNT TO BE PROVIDED' 0.00 1000-18220 BIRMINGHAM LOAN 0.00 0.00 TOTAL ASSETS 0.00 LI ABIL TES 2000-20310 COMPENSATED ABSENCES PAYABLE 51,906.66 2000-20311 COMP' ABSENCES PAYABLE-CURRENT 0.00 2000-214101 ACCRUED INTEREST PAYABLE 0.00 2000-28205 WEDC LOANS - CURRENT ( 295,204.44) 2000-28220 BIRMINGHAM LOAN 0.00 2000-28230 INWOOD LOAN 0.00 2000-28234 AND LOAN - RANDACK/HUGHES 360,693.49 2000-28235 ANB LOAN 104,959.79 2000-28236 AND CONSTRUCTION LOAN 0.00 2000-28237 ANB ROAD CONSTRUCTION LOAN 965,067.15 2000-28238 AND LOAN - BUCHANAN 394,296,55. 2000-28E40 HUGHES LOAN 0.00' 2000-28250 CITY OF WYLIE LOAN 0.00 2000-28260 PRIME NUTS LOAN 0.00 2000-28270 BOWLAND/ANDERSON LOAN 0.00 2000-20280 CAPITAL ONE CA2AD LOAN 0.00 2000-28290 HOBART/COMMERCE LOAN 250,980.56 TOTAL LIABILITIES 1,832,699.76 EQUITY 3000-34590 FUND BALANCE-UNRESERV/UNDESIG( 2,1211,904.201 TOTAL BEGINNING EQUITY ( 2,127,904.20) TOTAL REVENUE 0.00 TOTAL EXPENSES ( 295,204,44) REVENUE OVER/(UNDER) EXPENSES. 295,204.44 TOTAL EQUITY & OVER((UNDER) ( 1,832,699.76) TOTAL LIABILITIES, EQUITY & OVER/)UNDER) 0.00 5-12-2015 0441 PM CITY OF WYLIE PAGE: 1 REVENUE AND EXPENSE REPORT - (UNAUDITED( AS OF: APRIL 30TH, 2015 III-WYLIE ECONOMIC DOWEL CORP FINANCIAL SUMMARY CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-I) BUDGET % OF RUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE; BUDGET REVENUE SUMMARY TAXES 1,947,992,00 134,475.39 0.00 859,477,17 0.00 1,089,514,93 44,12 INTERGOVERNMENTAL REV. 202,000.00 202,000.00 0.00 202,000,00 0.00 0.00 100.00, INTEREST INCOME 12,228.00 1,056.39 0.00 7,335.71 0.00 4,892.29 59.99 MISCELLANEOUS INCOME 186,000.00 18,950.00 0.00 116,450.00 0,00 69,550.00 62.61 OTHER FINANCING SOURCES 722,365.00 0.00 0.00 722,365.00 0.00 0,00 100.00 TOTAL REVENUES 3,070,585.00 356,481.78 (1.00 1,507,627.89 0.00 1,162,957,12 62.13 F". PENS)I TPESgMMARY DEVELOPMENT CORP-WEDC 3,936,940,00 164,139,16 1,154,19 1,470,804.75 411,102.15 2,055,033,10 47,80 TOTAL EXPENDITURES 3,936,940.00 164,139.16 ( 1,194.19) 1,470,804.75 411,102.15 2,055,033.10 47.80 REVENUE OVER/ UNDER) EXPENDITURES ( 966,355.00) 192,342.62 ( 1,194.19) 436,823.13 ( 411,102.15) ( 892,075.98) 2.97- 5-12-2015 04:41 PM CITY OF WYLIE PAGE: 2 REVENUE AND EXPENSE REPORT - (UNAUDITED) AS OF: APRIL 30TH, 2015 111-WYLIE ECONOMIC DEVEL CORP REVENUES CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET TAXES 4000-40150 REV IN LEIU OF TAXES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4000-40210 SALES TAX 1,947,992.00 134,475,39 0„00 ... 859477.17 0.00 0.m088514 83 44.12,,.. TOTAL TAXES 1,947,992.00 134,475.39 0.00 859,477.17 0.00 1,088,514.83 44.12 INTERGOVERNMENTAL REV. 4000-43518 380...ECOOMI, 0 202,000.00 0 1_.� 380 ECONOMIC AGREEMENTS 202,000 00 0.00 202 000.00 0.00 0.00 100.00 TOTAL INTERGOVERNMENTAL REV. 202,000.00 202,000.00 0.00 202,000.00 0.00 0.00 100.00 INTEREST INCOME 4000-46050 CERTIFICATE OF DEPOSIT 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4000-46110 ALLOCATED INTEREST EARNINGS 270.00 59.91 0.00 360.29 0.00 ¢ 90.29) 133.44 4000-46140 TEXPOOL INTEREST 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4000-46143 LOGIC INTEREST 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4000-46150 INTEREST EARNINGS 3,817.00 316.75 0.00 2,276.11 0.00 1,540.89 59.63 4000-46160 LOAN REPAYMENT (PRINCIPAL) 8,141.00 679.73 0.00 4,699.31 0.00 3,441.69 57.72 4000-46210 BANK MONEY MARKET INTEREST 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL INTEREST INCOME 12,228.00 _-. 1,056.39 �....0.0 .......................7335.7.. 0.00 ..._.... ..�. , 4,892.29 59.99 MISCELLANEOUS INCOME 4000-48110 . 4 RENTAL INCOME 186,000.00 18,950.00 0.00 116,450.00 0.00 69,550.00 62.61 4000-48310 RECOVERY - PRIOR YEAR EXPEN 0,.00 0.00 0.00 0.00 0.00 0.00 0,00 4000-48410 MISCELLANEOUS INCOME 0,00 0.00 0.00 0.00 0.00 0.00 0,00 4000-48430 GAIN/LOSS SALE OF CAP ASSET 0„00 0.00 0.00 0.00 0.00 0,00 0.00 TOTAL MISCELLANEOUS INCOME 186,000.00 ..........18,950.00 . ................._......"0.00 _.... 116,450.00 .........................0.00 _........69,550...o0 62..... ...._. 62.61 OTHER FINANCING SOURCES 4000-49160 TRANSFER FROM GENERAL FUND 0.00 0,00 0,00 0.00 0.00 0.00 0.00 4000-49325 BANK NOTE PROCEEDS 722,365.00 0,00 0,00 722,365.00 0.00 0.00 100.00 4000-49550 LEASE PRINCIPAL PAYMENTS (0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER FINANCING SOURCES 722,365.00 0.00 0.00 722,365.00 0.00 0.00 100.00 TOTAL REVENUES 3,070,585.00 356,481.78 0.00 1,907,627.88 0.00 1,162,957.12 62.13 5-12-2015 04:41 PM CITY OF WYLIE PAGE: 3 REVENUE AND EXPENSE REPORT - (UNAUDITED) AS OF: APRIL 30TH, 2015 111-WYLIE ECONOMIC DEVEL CORP DEVELOPMENT CORP-WEDC DEPARTMENTAL EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET PERSONNEL SERVICES 5611-51110 SALARI ES 176,050.00 13,769.24 0.00 95,716.30 0.00 80,333.70 54.37 5611-51130 OVERTIME 0.00 0.00 0.00 0.00 0,00 0.00 0.00 5611-51140 LONGEVITY PAY 957.00 0.00 0.00 956.00 0,00 1.00 99.90 5611-51145 SICK LEAVE BUYBACK 0.00 0.00 0.00 0.00 0,00 0.00 0.00 5611-51160 CERTIFICATION INCENTIVE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5611-51170 PARAMEDIC INCENTIVE 0.00 0.00 0.00 0.00 0,00 0.00 0.00 5611-51210 CAR ALLOWANCE 11,100.00 870.78 0.00 6,044.61 0„00 5,055.39 54.46 5611-51220 PHONE ALLOWANCE 3,456.00 864.00 0.00 2,592.00 0.00 864.00 75.00 5611-51230 CLOTHING ALLOWANCE 0.00 0.00 0.00 0.00 0,00 0.00 0.00 5611-51310 TMRS 26,603.00 2,059.64 0.00 14,075.71 0.00 12,527.29 52.91 5611-51410 HOSPITAL & LIFE INSURANCE 28,515.00 1,796.33 0.00 14,315.69 0.00 14,199.31 50.20 5611-51415 EXECUTIVE HEALTH PLAN 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5611-51420 LONG-TERM DISABILITY 1,009.00 48.18 0.00 349.49 0,00 659.51 34.64 5611-51440 FICA 11,723.00 875.56 0.00 4,808.65 0.00 6,914.35 41.02 5611-51450 MEDICARE 2,742.00 204.76 0.00 1,441.44 0.00 1,300.56 52.57 5611-51470 WORKERS COMP PREMIUM 427.00 0.00 0.00 386.70 0.00 40.30 90.56 5611-51480 UNEMPLOYMENT COMP (TWC) 540.00 18.00 0.00 111.29 0,00 428.71 20.61 TOTAL PERSONNEL SERVICES 263,122.00 20,506.69 �� -0.00 140,797.88 0.00 122,324.12 53.51 SUPPLIES 5611-52010 OFFICE SUPPLIES 5,000.00 0.00 0,00 413.72 0.00 4,586.28 8.27 5611-52040 POSTAGE & FREIGHT 980.00 73,00 0,00 85.70 0.00 894.30 6.74 5611-52130 TOOLS/ EQUIP (NON-CAPITAL) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5611-52810 FOOD SUPPLIES 5,000.00 287,19 0.00 1,194.59 0.00 3,805.41 23.89 5611-52990 OTHER 5,000.00 0,00 0„00 0.00 0.00 5000.00, 0.00 TOTAL SUPPLIES 15,980.00 .. _W.........360.1g .............._ 0.00 1,694.01 -., , _.. ..__ 0.00 14,285.99 10 10.60 MATERIALS FOR MAINTENANC 5611-54630 TOOLS & EQUIPMENT 0.00 0.00 0,00 0.00 0.00 0.00 0.00 5611-54810 COMPUTER HARD/SOFTWARE 3,000.00 1,689.64 0,00 1,877.14 0„00 1,122.86 62.57 5611-54990 OTHER 0.00 0.00 0,00 0.00 0,00 0.00 0.00 TOTAL MATERIALS FOR MAINTENANC 3,000.00 1,689.64 0.00 1,877.14 0.00 1,122.66 62.57 CONTRACTUAL SERVICES 5611-56030 INCENTIVES 1,025,782.00 34,498.70 0,00 345,336.73 0.00 680,445.27 33.67 5611-56040 SPECIAL SERVICES 82,600.00 21,212.50 0,00 52,064.12 0.00 30,535.88 63.03 5611-56080 ADVERTISING 46,950.00 3,150.00 0.00 16,420.00 0.00 30,530.00 34.97 5611-56090 COMMUNITY DEVELOPMENT 53,200.00 10,367.50 0„00 38,246.50 0.00 14,953.50 71.89 5611-56110 COMMUNICATIONS 4,800.00 743.45 0,00 2,922.58 333.04 1,544.38 67.83 5611-56180 RENTAL 24,600.00 3,894.00 0.00 16,179.00 0.00 8,421.00 65.77 5611-56210 TRAVEL & TRAINING 30,400.00 2,829.90 0„00 12,035.61 1,769.11 16,595.28 45.41 5611-56250 DUES & SUBSCRIPTIONS 9,450.00 0.00 0,00 3,463.94 0.00 5,986.06 36.66 5611-56310 INSURANCE 7,630.00 0.00 0.00 3,010.04 0.00 4,619.96 39.45 5611-56510 AUDIT & LEGAL SERVICES 23,000.00 340.00 0,00 3,796.00 0.00 19,204.00 16.50 5611-56570 ENGINEERING/ARCHITECTURAL 20,000.00 7,500.00 0.00 8,700.00 0.00 11,300.00 43.50 ,....-._�.... 5611-56610 UTILITIES-ELECTRIC ww 2,000.00 0.00 0.00 2,475.32 0.00 ( 475.32) 123.77 mmmmmmmmmmmmm mmmmmmmmmmmmmµ TOTAL CONTRACTUAL SERVICES 1,330,412.00 84,536.05 0.00 504,649.84 2,102.15 823,660.01 38.09 5-12-2015 04:41 PM CITY OF WYLIE PAGE: 4 REVENUE AND EXPENSE REPORT - (UNAUDITED) AS OF: APRIL 30TH, 2015 111-WYLIE ECONOMIC DEVEL CORP DEVELOPMENT CORP-WEDC DEPARTMENTAL EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET DEBT SERVICE & CAP. REPL 5611-57110 DEBT SERVICE 559,561.00 0.00 0.00 0.00 0.00 559,561.00 0.00 5611-57410 PRINCIPAL PAYMENT 0.00 48,376.26 0.00 295,204.44 0.00 ( 295,204.44) 0,00 5611-57415 INTEREST EXPENSE 0.00 8,670.33 0.00 49,704.54 0.00 ( 49,704.54) 0.00 5611-57710 BAD DEBT EXPENSE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEBT SERVICE & CAP. REPL 559,561.00 57,046.59 0.00 344,908.98 0.00 21m 4,652.02 61.6464 CAPITAL OUTLAY 5611-58110 LAND-PURCHASE PRICE 1,759,365.00 326,773.30 0.00 1,318,534.25 409,000.00 31,830.75 98.19 5611-58120 DEVELOPMENT FEES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5611-58150 LAND-BETTERMENTS 0.00 0.00 0.00 0,00 0.00 0.00 0.00 5611-58210 STREETS & ALLEYS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5611-58410 SANITARY SEWER 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5611-58810 COMPUTER HARD/SOFTWARE 3,000.00 0.00 0.00 443.97 0.00 2,556.03 14.80 5611-58830 FURNITURE & FIXTURES 2,500.00 0.00 0.00 0.00 0.00 2,500.00 0.00 5611-58910 BUILDINGS 0.00 0.00 0.00 0,00 0.00 0.00 0.00 5611-58995 CONTRA CAPITAL OUTLAY 0.00.....00 _••258,534.25 0.00 (mm 326�773.30) 0.00 ( �,258,534-25) 1, ....�.�.-_.. TOTAL CAPITAL OUTLAY 1,764,865.00 0.00 0.00 60,443.97 409,000.00 1,295,421.03 26.60 OTHER FINANCING (USES) 5611-59111 TRANSFER TO GENERAL FUND 0.00 0.00 0.00 0.00 0,00 0.00 0.00 5611-59190 TRANSFER TO THORUGHFARE IMP 0.00 0.00 0.00 0.00 0,00 0.00 0.00 5611-59430 TRANSFER TO CAPITAL FUND 0.00 0.00 0.00 416,432.93 0.00 ( 416,432.93) 0.00 5611-59990 PROJECT ACCOUNTING 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER FINANCING (USES) ...................W..._..............0...00 ...__..........................0....00 0.... ..__.. ..-,-,.. 6.,.... ._..._ 0.00 416,432.93 0.00 ( 4166,43232..9393) 0.00 TOTAL DEVELOPMENT CORP-WEDC 3,936,940.00 164,139.16 0.00 1,470,804.75 411,102.15 2,055,033.10 47.80 TOTAL EXPENDITURES 3,936,940.00 164,139.16 0.00 1,470,804.75 411,102.15 2,055,033.10 47.80 REVENUE OVER (UNDER) EXPENDITURES ( 866,355.00) 192,342.62 0.00 436,823.13 ( 411,102.15) ( 892,075.98) 2.97- *** END OF REPORT *** 5-12-2015 4:44 PM DETAIL LISTING PAGE: 1 FUND : 111-WYLIE ECONOMIC DEVEL CORP PERIOD TO USE: Apr-2015 THRU Apr-2015 DEPT ACCOUNTS: 5611-52010 THRU 5611-58910 POST DATE TRAN # REFERENCE PACKET DESCRIPTION VEND INV/JE # NOTE AMOUNT==== ====BALANCE==== FUND: 111-WYLIE ECONOMIC DEVEL CORP DEPT: 611 DEVELOPMENT CORP-WEDC 5611-52010 OFFICE SUPPLIES BEGINNING BALANCE 413.72 5611-52040 POSTAGE & FREIGHT BEGINNING BALANCE 12.70 4/09/15 4/09 A28387 CHK: 074488 71429 COURIER - SERVICES 002174 1718 WEDC 73.00 85.70 ”,.,...q==.=s.,..,-. APRIL ACTIVITY DB: 73.00 CR: 0.00 73.00 5611-52130 TOOLS/ EQUIP (NON-CAPITAL) BEGINNING BALANCE 0.00 5611-52160 TOOLS/ EQUIP - $100-$999.99 BEGINNING BALANCE 0.00 5611-52810 FOOD SUPPLIES BEGINNING BALANCE 907.40 4/16/15 4/16 A28992 CHK: 074641 71596 CHAMBR BCE-MAR15 WEDC 000832 A0055879 MAR15 240.00 1,147.40 4/20/15 4/20 A29287 CHK: 000000 71671 BOARD MTG MEAL 000912 8277 MAR15 WYGANT 16.89 1,164.29 4/20/15 4/20 A29287 CHK: 000000 71671 BOARD MTG MEAL 000912 8277 MAR15 WYGANT 14.14 1,178.43 4/20/15 4/20 A29287 CHK: 000000 71671 BOARD MTG MEAL 000912 8277 MAR15 WYGANT 16.16 1,194.59 _....=.==_®_.,+,__= APRIL ACTIVITY DB: 287.19 CR: 0.00 287.19 5611-52990 OTHER BEGINNING BALANCE 0.00 5611-54630 TOOLS & EQUIPMENT BEGINNING BALANCE 0.00 5611-54810 COMPUTER HARD/SOFTWARE BEGINNING BALANCE 187.50 4/09/15 4/09 A28386 CHK: 074494 71429 TABLETS- JAN-MAR '15 001797 822495799-07 WEDC 1,090.84 1,278.34 4/20/15 4/20 A29287 CHK: 000000 71671 SPAM SOFTWARE 000912 8277 MAR15 WYGANT 59.90 1,338.24 5-12-2015 4:44 PM DETAIL LISTING PAGE: 2 FUND : 111-WYLIE ECONOMIC DEVEL CORP PERIOD TO USE: Apr-2015 THRU Apr-2015 DEPT : 611 DEVELOPMENT CORP-WEDC ACCOUNTS: 5611-52010 THRU 5611-58910 POST DATE TRAN # REFERENCE PACKET DESCRIPTION VEND INV/JE # NOTE AMOUNT==== =-==BALANCE==== 4/20/15 4/20 A29287 CHIC: 000000 71671 CHROMECAST WIRELESS 000912 8277 MAR15 WYGANT 35.00 1,373.24 4/20/15 4/20 A29287 CHK: 000000 71671 SPAM SOFTWARE 000912 8277 MAR15 WYGANT 26.95 1,400.19 4/20/15 4/20 A29287 CHK: 000000 71671 SPAM SOFTWARE 000912 8277 MAR15 WYGANT 26.95 1,427.14 4/24/15 4/24 A29652 CHK: 074817 71779 COMPUTER REPAIR 003339 002370 WEDC 150.00 1,577.14 4/27/15 4/27 A29742 CHK: 074841 71796 NETWORK MAINTENANCE 003339 002367 300.00 1,877.14 _ __====rt== APRIL ACTIVITY DB: 1,689.64 CR: 0.00 1,689.64 5611-54990 OTHER BEGINNING BALANCE 0.00 5611-56030 INCENTIVES BEGINNING BALANCE 310,838.03 4/01/15 3/31 A27628 CHK: 074269 71201 QRTLY TAX REIMBURSEMENT 003990 032315 WEDC 19,498.70 330,336.73 4/17/15 4/17 A29179 VOID: 073333 71648 REVERSE VOIDED CHECK 003591 PAY #1 012915 15,000.00CR 315,336.73 4/21/15 4/21 A29412 CHK: 074726 71705 INCENTIVE #1 004349 PAY #1 041715 15,000.00 330,336.73 4/28/15 4/28 A29797 CHK: 074860 71815 INCENTIVE 1 004354 INC #1 WEDC 15,000.00 345,336.73 _- M+„ =_= APRIL ACTIVITY DB: 49,498.70 CR: 15,000.00CR 34,498.70 5611-56040 SPECIAL SERVICES BEGINNING BALANCE 30,851.62 4/01/15 4/01 A27766 CHK: 074302 71253 QRTLY PEST CONTROL 000792 65334 WEDC 95.00 30,946.62 4/21/15 4/21 A29404 CHK: 074730 71705 MOWING-POST OFC LOT 001173 032315 WEDC 80.00 31,026.62 4/21/15 4/21 A29404 CHK: 074730 71705 MOWING-WALGR LOT 001173 032315 WEDC 60.00 31,086.62 4/21/15 4/21 A29404 CHK: 074730 71705 MOWING-DUAL PROD. 001173 032315 WEDC 60.00 31,146.62 4/21/15 4/21 A29404 CHK: 074730 71705 MOWING- HWY 78 (BEH) 001173 032315 WEDC 100.00 31,246.62 4/21/15 4/21 A29404 CHK: 074730 71705 MOWING-HWY 78 (BEH) 001173 032315 WEDC 100.00 31,346.62 4/27/15 4/27 A29692 CHK: 074831 71787 JANITORIAL SVC - APRL 15 002330 13109 WEDC 157.50 31,504.12 4/27/15 4/27 A29741 CHK: 074836 71796 SOD - 104 N JACKSON 002347 73512 1,100.00 32,604.12 4/30/15 4/30 A30019 CHK: 074933 71873 DEMO 400 N. JACKSON 001026 14209 WEDC 19,460.00 52,064.12 =-w, __.__ -..m-= APRIL ACTIVITY DB: 21,212.50 CR: 0.00 21,212.50 5611-56080 ADVERTISING BEGINNING BALANCE 13,270.00 4/24/15 4/24 A29650 CHK: 074816 71779 WDMA AUDIO - 2QTR 001078 1231 WEDC 150.00 13,420.00 4/27/15 4/27 A29739 CHK: 074839 71796 SCORECARD ADVERTISING 000832 42015 WEDC 1,500.00 14,920.00 4/28/15 4/28 A29781 CHK: 074858 71815 CONNECTION AD APR/MAY 15 000391 6933 WEDC 1,500.00 16,420.00 ____ =mm==A, APRIL ACTIVITY DB: 3,150.00 CR: 0.00 3,150.00 5-12-2015 4:44 PM DETAIL LISTING PAGE: 3 FUND : 111-WYLIE ECONOMIC DEVEL CORP PERIOD TO USE: Apr-2015 THRU Apr-2015 DEPT : 611 DEVELOPMENT CORP-WEDC ACCOUNTS: 5611-52010 THRU 5611-58910 POST DATE TRAN # REFERENCE PACKET DESCRIPTION VEND INV/JE # NOTE AMOUNT==== ====BALANCE==== 5611-56090 COMMUNITY DEVELOPMENT BEGINNING BALANCE 27,879.00 4/13/15 4/13 A28635 CHK: 074555 71505 PEDAL CAR SPONSOR 001078 041515 WEDC 100.00 27,979.00 4/20/15 4/20 A29287 CHK: 000000 71671 SPON CC PRAY BREAK 000912 8277 MAR15 WYGANT 250.00 28,229.00 4/24/15 4/24 A29608 CHK: 074799 71771 STATE OF CITY LUNCHEON 000468 6961 WEDC 30.00 28,259.00 4/27/15 4/27 A29682 CHK: 074818 71787 SPONS. - JAZZ FEST 000101 JA2015-08 WEDC 1,000.00 29,259.00 4/27/15 4/27 A29740 CHK: 074840 71796 BLUEGRASS T-SHIRT SPONS 001078 1244 WEDC 100.00 29,359.00 4/28/15 4/28 A29785 CHK: 074849 71815 ROTARY TOURNAMENT 000932 042115 WEDC 550.00 29,909.00 4/28/15 4/28 A29788 CHK: 074845 71815 2015-16 MAVERICKS 002050 042315 WEDC 7,137.50 37,046.50 4/29/15 4/29 A29899 CHK: 074895 71837 GOLF TOURN. WISD FUNDRAI 003940 042415 WEDC 1,200.00 36,246.50 _.,,_____===..== APRIL ACTIVITY DB: 10,367.50 CR: 0.00 10,367.50 5611-56110 COMMUNICATIONS BEGINNING BALANCE 2,179.13 4/09/15 4/09 A28386 CHK: 074494 71429 TAB & SVC - JAN - MAR '1 001797 822495799-07 WEDC 279.60 2,458.73 4/20/15 4/20 A29268 CHK: 000000 71667 TELEPHONE SVC 000912 8277 MAR15 SATTERW 128.77 2,587.50 4/21/15 4/21 A29400 CHK: 074735 71705 INTERNT MR25-AP24 WEDC 000190 2820367756 MR25-AP 207.96 2,795.46 4/21/15 4/21 A29405 CHK: 074736 71705 TABLET SERV-WEDC 001797 822495799-007 MAR1 94.85 2,890.31 4/21/15 4/21 A29407 CHK: 074725 71705 IPAD SVC WEDC 002374 X04042015 WEDC 32.27 2,922.58 _=____.,====== APRIL ACTIVITY DB: 743.45 CR: 0.00 743.45 5611-56180 RENTAL BEGINNING BALANCE 12,285.00 4/06/15 4/06 A28091 CHK: 074415 71313 RENT - APRIL 2015 003231 033115 APR15 1,850.00 14,135.00 4/07/15 4/07 A28151 CHK: 074424 71346 COPIER EXPENSES 003509 87784 194.00 14,329.00 4/29/15 4/29 A29895 CHK: 074894 71837 RENT - MAY 15 003231 042415 MAY15 1,850.00 16,179.00 =__..,=..,_,_ ___= APRIL ACTIVITY DB: 3,894.00 CR: 0.00 3,894.00 5611-56210 TRAVEL & TRAINING BEGINNING BALANCE 9,205.71 4/20/15 4/20 A29268 CHK: 000000 71667 HOTEL - COL. CTY DAY 000912 8277 MAR15 SATTERW 271.74 9,477.45 4/20/15 4/20 A29268 CHK: 000000 71667 BUS MTG MEAL 000912 8277 MAR15 SATTERW 8.66 9,486.11 4/20/15 4/20 A29268 CHK: 000000 71667 BUS. MTG MEAL 000912 8277 MAR15 SATTERW 32.97 9,519.08 4/20/15 4/20 A29268 CHK: 000000 71667 BUS. MTG MEAL 000912 8277 MAR15 SATTERW 22.56 9,541.64 4/20/15 4/20 A29268 CHK: 000000 71667 BUS. MTG MEAL 000912 8277 MAR15 SATTERW 20.28 9,561.92 4/20/15 4/20 A29268 CHK: 000000 71667 PROJ. UPDATE MEAL 000912 8277 MAR15 SATTERW 14.07 9,575.99 4/20/15 4/20 A29268 CHK: 000000 71667 ICSC-HOTEL FULLER 000912 8277 MAR15 SATTERW 460.73 10,036.72 4/20/15 4/20 A29268 CHK: 000000 71667 ICSC HOTEL-YEAGER 000912 8277 MAR15 SATTERW 828.67 10,865.39 w. 5-12-2015 4:44 PM DETAIL LISTING PAGE: 4 FUND : 111-WYLIE ECONOMIC DEVEL CORP PERIOD TO USE: Apr-2015 THRU Apr-2015 DEPT : 611 DEVELOPMENT CORP-WEDC ACCOUNTS: 5611-52010 THRU 5611-58910 POST DATE TRAN # REFERENCE PACKET DESCRIPTION VEND INV/JE # NOTE AMOUNT---- ----BALANCE---- 4/20/15 4/20 A29268 CHK: 000000 71667 ICSC - AIR FULLER 000912 8277 MAR15 SATTERW 117.98 10,983.37 4/20/15 4/20 A29268 CHK: 000000 71667 ICSC - AIR YEAGER 000912 8277 MAR15 SATTERW 420.98 11;404.35 4/20/15 4/20 A29268 CHK: 000000 71667 BUS. MTG 000912 8277 MAR15 SATTERW 32.20 11,436.55 4/20/15 4/20 A29287 CHK: 000000 71671 ICSC RE -JOHN YEAGER 000912 8277 MAR15 WYGANT 570.00 12,006.55 4/20/15 4/20 A29287 CHK: 000000 71671 ICSC - HOTE - HOGUE 000912 8277 MAR15 WYGANT 1,144.08 13,150.63 4/20/15 4/20 A29287 CHK: 000000 71671 ICSC HOTEL-HOGUE 000912 8277 MAR15 WYGANT 1,551.20CR 11,599.43 4/30/15 4/30 A30068 CHK: 074944 71877 042415 AIRFARE M. HERZOG 003968 042415 AIRFARE 436.18 12,035.61 ,. ,,-, APRIL ACTIVITY DB: 4,381.10 CR: 1,551.20CR 2,829.90 5611-56220 PROFESSIONAL TRAINING BEGINNING BALANCE 0.00 5611-56250 DUES 6 SUBSCRIPTIONS BEGINNING BALANCE 3,463.94 5611-56310 INSURANCE BEGINNING BALANCE 3,010.04 5611-56510 AUDIT & LEGAL SERVICES BEGINNING BALANCE 3,456.00 4/24/15 4/24 A29645 CHK: 074805 71779 ATTY FEES-GLENN PROP 000023 2793-0065M 1 WEDC 340.00 3,796.00 m--m-,—,, _, APRIL ACTIVITY DB: 340.00 CR: 0.00 340.00 5611-56570 ENGINEERING/ARCHITECTURAL BEGINNING BALANCE 1,200.00 4/21/15 4/21 A29410 CHK: 074728 71705 PROF SER-WYL544 MSTR PLA 004197 400979 13245 7,500.00 8,700.00 ......mma....a........ APRIL ACTIVITY DB: 7,500.00 CR: 0.00 7,500.00 5611-56610 UTILITIES-ELECTRIC BEGINNING BALANCE 2,475.32 5611-57110 DEBT SERVICE BEGINNING BALANCE 0.00 4/01/15 5/07 B46405 12801 JE21278 R/C PMT #15 APR 2015 JE# 021278 5,378.30CR 5,378.30CR 4/01/15 3/31 A27629 CHK: 074276 71201 PAYMENT #15-APR '15 004112 PAY #15 APR15 5,378.30 0.00 4/07/15 5/04 B46350 12777 JE21243 R/C PEDDI/WHITE APR15 JE# 021243 7,382.45CR 7,382.45CR 5-12-2015 4:44 PM DETAIL LISTING PAGE: 5 FUND : 111-WYLIE ECONOMIC DEVEL CORP PERIOD TO USE: Apr-2015 THRU Apr-2015 DEPT : 611 DEVELOPMENT CORP-WEDC ACCOUNTS: 5611-52010 THRU 5611-58910 POST DATE TRAN # REFERENCE PACKET DESCRIPTION VEND INV/JE # NOTE AMOUNT---- ====BALANCE==== 4/10/15 4/13 B46019 12684 Peddicord/White April 15 JE# 021095 7,382.45 0.00 4/15/15 4/24 B46157 Bnk Dft 041515 12704 JE21127 WB PKWY APRL 15 JE# 021127 13,267.93 13,267.93 4/15/15 5/04 B46352 Bnk Dft 041515 12779 JE21245 REV JE21127 WB PKWY AP JE# 021245 13,267.93CR 0.00 4/24/15 5/07 B46406 12802 JE21279 R/C PMT 116 MAY 2015 JE# 021279 5,378.30CR 5,378.30CR 4/24/15 4/24 A29655 CHK: 074814 71779 PAYMENT #16-MAY 15 004112 PAY #16 5,378.30 0.00 ==s nm-==art== APRIL ACTIVITY DB: 31,406.98 CR: 31,406,98CR 0.00 5611-57410 PRINCIPAL PAYMENT BEGINNING BALANCE 246,828.18 4/01/15 5/07 B46405 12801 JE21278 HOBART PMT #15 JE# 021278 4,442.00 251,270.18 4/07/15 5/04 B46350 12777 JE21243 PEDDICORD PMT #4 JE# 021243 4,905.32 256,175.50 4/15/15 5/01 B46273 Bnk Dft 041515 12749 JE21203 ANB WB PKWY PMT #8 JE# 021203 11,250.21 267,425.71 4/22/15 4/24 B46178 Bnk Dft 042215 12711 JE21148 ANB BUCHANAN PMT #8 JE# 021148 6,208.96 273,634.67 4/22/15 4/24 B46178 Bnk Dft 042215 12711 JE21148 ANB BUCHANAN PMT #8 JE# 021148 1,122.99 274,757.66 4/22/15 4/24 B46179 Bnk Dft 042215 12711 JE21149 ANB MARTINEZ PMT #53 JE# 021149 8,056.52 282,814.18 4/22/15 5/04 B46357 12784 JE21252 RC ANB BUCHANAN PMT8 JE# 021252 1,122.99CR 281,691.19 4/24/15 5/07 B46406 12802 JE21279 HOBART PMT #16 JE# 021279 4,460.51 286,151.70 4/28/15 5/01 B46276 Bnk Dft 042815 12750 JE21206 HUGHES/RANDACK PMT29 JE# 021206 9,052.74 295,204.44 �_ —,.m R APRIL ACTIVITY DB: 49,499.25 CR: 1,122.99CR 48,376.26 5611-57415 INTEREST EXPENSE BEGINNING BALANCE 41,034.21 4/01/15 5/07 B46405 12801 JE21278 HOBART PMT #15 JE# 021278 936.30 41,970.51 4/07/15 5/04 B46350 12777 JE21243 PEDDICORD PMT #4 JE# 021243 2,477.13 44,447.64 4/15/15 5/01 B46273 Bnk Dft 041515 12749 JE21203 ANB WB PKWY PMT #8 JE# 021203 2,017.72 46,465.36 4/22/15 4/24 B46179 Bnk Dft 042215 12711 JE21149 ANB MARTINEZ PMT #53 JE# 021149 144.14 46,609.50 4/22/15 5/04 846357 12784 JE21252 BUCHANAN PMTB JE# 021252 1,122.99 47,732.49 4/24/15 5/07 B46406 12802 JE21279 HOBART PMT #16 JE# 021279 917.79 48,650.28 4/28/15 5/01 B46276 Bnk Dft 042815 12750 JE21206 HUGHES/RANDACK PMT29 JE# 021206 1,054.26 49,704.54 a=”.___,...___. APRIL ACTIVITY DB: 8,670.33 CR: 0.00 8,670.33 5611-57710 BAD DEBT EXPENSE BEGINNING BALANCE 0.00 5611-58110 LAND-PURCHASE PRICE BEGINNING BALANCE 991,760.95 4/24/15 4/30 B46259 12745 JE21196 CLOSING GLENN PROP JE# 021196 5,000.00 996,760.95 4/24/15 5/12 B46450 E.F.T. 000000 12818 Glenn Property JE# 021297 321,773.30 1,318,534.25 .„.= W,.”=� APRIL ACTIVITY DB: 326,773.30 CR: 0.00 326,773.30 5-12-2015 4:44 PM DETAIL LISTING PAGE: 6 FUND : 111-WYLIE ECONOMIC DEVEL CORP PERIOD TO USE: Apr-2015 THRU Apr-2015 DEPT : 611 DEVELOPMENT CORP-WEDC ACCOUNTS: 5611-52010 THRU 5611-58910 POST DATE TRAN # REFERENCE PACKET DESCRIPTION VEND INV/JE # NOTE AMOUNT==== ====BALANCE---- 5611-58120 DEVELOPMENT FEES BEGINNING BALANCE 0.00 5611-58150 LAND-BETTERMENTS BEGINNING BALANCE 0.00 5611-58210 STREETS & ALLEYS BEGINNING BALANCE 0.00 5611-58410 SANITARY SEWER BEGINNING BALANCE 0.00 5611-58810 COMPUTER HARD/SOFTWARE BEGINNING BALANCE 443.97 5611-58830 FURNITURE & FIXTURES BEGINNING BALANCE 0.00 5611-58910 BUILDINGS BEGINNING BALANCE 0.00 * * * * * * * * * * * * * 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 1,701,702.42 0.00 REPORTED ACTIVITY: 519,486.94 49,081.17CR ENDING BALANCES: 2,221,189.36 49,081.17CR TOTAL FUND ENDING BALANCE: 2,172,108.19 FUND: 922-GEN LONG TERM DEBT (WEDC) DEPT: 611 ** INVALID DEPT ** 5611-57410 PRINCIPAL PAYMENT BEGINNING BALANCE 246,828.18CR 4/01/15 5/07 B46405 12801 JE21278 R/C PMT #15 APR 2015 JE# 021278 4,442.00CR 251,270.18CR 4/07/15 5/04 B46350 12777 JE21243 PEDDICORD PMT #4 JE# 021243 4,905„32CR 256,175.50CR 4/15/15 5/01 B46273 Bnk Dft 041515 12749 JE21203 ANB WB PKWY PMT #8 JE# 021203 11,250,21CR 267,425.71CR 4/22/15 4/24 B46178 Bnk Dft 042215 12711 JE21148 ANB BUCHANAN PMT #8 JE# 021148 6,208.96CR 273,634.67CR 4/22/15 4/24 B46179 Bnk Dft 042215 12711 JE21149 ANB MARTINEZ PMT #53 JE# 021149 8,056„52CR 281,691.19CR 5-12-2015 4:44 PM DETAIL LISTING PACE: 7 FUND : 922-GEN LONG TERM DEBT (WEIK) PERIOD TO USE: Apr-2015 THRU Apr-20I5 DEPT 611 ** INVALID DEPT '* ACCOUNTS 5611-52010 THRU 5611-58910 POST DATE TRAM t REFERENCE PACKET*,*'***!w-DESCRIPTION-, -- VEND INV/JE t NOTE .=-,,====BALANCE***::::*, 4/24/15 5/07 846406 12802 JE21 279 HOBART PIT #16 JEf 021279 4,480.51CR 206,151.70GR 4/28/15 5/01 B46276 Bnk Dft 042815 12750 JE21206 HUGHES fRANDACK PMT29 JEt 021206 9,052.74CR 295,204.44CR APRIL ACTIVITY DB: 0.00 CR: 48,176.26CH 48,316.26CR 5611-57999 CONTRA EXPENSE - (AUDIT ONLY) BEGINNING BALANCE 0.00 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- CREDITS --- BEGINNING BALANCES 0.00 246,828.18CR REPORTED ACTIVITY: 0.00 48,376,26CR ENDING BALANCES: 0,00 295,204.44CR TOTAL FUND ENDING BALANCE: 295,204,44CR 5-12-2015 4:44 PM DETAIL LISTING PACE: 8 SELECTION CRITERIA FISCAL YEAR: Oct-20I4 I ;Sep-2015 FUND: AS S PERIOD T'O USE: Apr-2015 THRU Apr-2015 TRANSACTIONS: 'BOTH ACCOUNT SELECTION ACCOUNT RANGE: 56111-5?010 TNRU S61.1-58910 DEPARTMENT RANGE: - THRU - ACTIVE FUNDS ONLY: NO ACTIVE ACCOUNT ONLY: NO INCLUDE' RESTRICTED ACCOUNTS: NO DIIGIT SELECTION: PRINT OPTIONS DETAIL. OMIT ACCOUNTS WITH NO ACTIVITY: NO PRINT ENCUMBRANCES: NO PRINT VENDOR NAME: NO PRINT PROJECTS: NO PRINT MONTHLY TOTALS: YES PRINT GRAND TOTALS: NO PRINT: INVOICE, it PAGE BREAK BY: NONE '•.., END OF REPORT '*' Wylie Economic Development Corporation Inventory Subledger April 30, 2015 Inventory - Land Date of Pur. Address Acreage Improvements Cost Basis Sub-totals Cooper McMasters 7/12/05 709 Cooper 0.48 n/a $202,045 Heath 12/28/05 706 Cooper 0.46 $32,005 3,625 186,934 Perry 9/13/06 707 Cooper 0.49 Demo 200,224 Bowland/Anderson 10/9/07 Cooper Dr. 0.37 n/a 106,419 KCS 8/1/08 Cooper Dr. 0.41 n/a 60,208 Duel Products 9/7/12 704 Cooper Dr. 0.50 n/a 127,452 Randack 10/23/12 711-713 Cooper Dr. 1.09 217,500 8,880 400,334 Lot 2R3 7/24/14 Cooper Dr. 0.95 n/a 29,306 $1,312,921 Industrial Ct. Hughes 7/25/06 211 -212 Industrial 0.74 209,801 10,000 420,361 R.O.W. 0.18 41,585 Prime Kuts 10/8/07 207 Industrial 0.20 182,223 4,550 229,284 R.O.W. 0.11 n/a 77,380 Cazad 3/17/08 210 Industrial 0.27 128,083 3,900 200,782 Buchanan 8/13/14 400 S. Hwy 78 1.25 68,294 12,750 477,840 Glenn 4/24/15 209 Industrial Ct 0.18 69,426 2,900 325,000 R.O.W. 0.12 1,772,232 Regency Ferrell 9/29/05 2806 F.M. 544 1.09 Demo 239,372 Sale of R.O.W. 2/14/07 -0.09 n/a -20,094 Crossroads 6/12/09 2804 F.M. 544 0.44 24,696 2,800 171,842 Regency Pk, 6/4/10 25 Steel Road 0.65 n/a 25,171 416,290 Commerce Hobart Investments 11/12/13 Commerce 1.60 n/a 156,820 Hobart 1/6/14 605 Commerce 1.07 396,263 20,000 386,380 543,200 Jackson Heath 3/17/14 104 N. Jackson 0.17 220,544 3,304 220,034 Udoh 2/12/14 109 Marble 0.17 n/a 70,330 Peddicord 12/12/14 108/110 Jackson 0.35 155,984 4,444 338,300 City Lot 12/12/14 100 W. Oak St 0.35 n/a 144,656 773,320 Alanis White Property(Alanis) 12/12/14 Alanis 6.63 n/a 420,000 420,000 Total 13.58 $1,704,819 77,153 $5,237,963 $5,237,963 *A Journal entry was made by auditors to adjust the cost of the Hughes land by$4,638.79. This amount was for taxes owed and therefore not part of the land value. *Prime Kuts total purchase price was$306,664.45. The distribution between 207 Industrial and R.O.W. purchased was developed by Seller for tax purposes. Wylie Economic Development Corporation Balance Sheet Sub Ledger April 1, 2015 Notes Payable Date of Rate of Principal Purchase Payment Beginning Bal. Principal Interest Interest Balance March 1, 2015 2,635,153.37 ANBTX-88122627 MARTINEZ(#53 of 60) 10/28/10 $8,200.66 $56,164.34 $8,056.52 $144.14 2.95 48,107.82 ANBTX-88130968 HUGHES/RANDACK(29 of 60) 10/23/12 10,107.00 306,768.20 9,052.74 1,054.26 3.99 297,715.46 Hobart HOBART(#15 of 60) 1/6/14 5,378.30 224,712.46 4,442.00 936.30 5.00 220,270.46 ANBTX-88130976 WOODBRIDGE PKWY (#80f 60) 8/13/14 13,267.93 897,751.98 11,250.21 2,017.72 2.61 886,501.77 ANBTX-88148481 BUCHANAN(#8 of 60) 8/13/14 7,331.95 357,609.16 6,208.96 1,122.99 3.77 351,400.20 ANBTX-88149711 PEDDICORD/WHITE(#4 OF 120) 12/12/14 7,382.45 707,919.07 4,905.32 2,477.13 4.20 703,013.75 April 30, 2015 $43,915.75 $7,752.54 2,507,009.46 Note: Principal and Interest payments vary by date of payment. kW WYLIE ECONOMIC DEVELOPMENT CORPORATION SALES TAX REVENUE FOR THE MONTH OF MAY 2015 MONTH WEDC WEDC WEDC DIFF % DIFF 2013 2014 2015 14 VS 15 14 VS 15 DECEMBER $148,500 $134,371 $154,719 $20,347 13.70% JANUARY 117,904 128,968 156,685 27,717 23.51% FEBRUARY 187,682 213,877 241,858 27,981 14.91% MARCH 139,745 121,483 171,741 50,258 41.37% APRIL 121,594 124,866 134,475 9,610 7.70% MAY 192,612 200,476 211,645 11,168 5.57% JUNE 141,328 145,137 JULY 148,763 149,537 AUGUST 180,280 193,751 SEPTEMBER 144,572 154,328 OCTOBER 137,407 152,545 NOVEMBER 193„783 213,292 Sub-Total $1,854,171 $1,932,632 $1,071,122 $147,080 15.92% AUDIT ADJ TOTAL $1,854,171 $1,932,632 $1,071,122 $147,080 15.92% WEDC SALES TAX ANALYSIS $300,000 ., $250,000 $200,000 $150,000 02014 M2015 $100,000 I I I $50,000 $ I �l II Ia 2 I a O 8 , z ! �� ,�• Wylie City Council ,. li AGENDA REPORT a _______) Meeting Date: May 26, 2015 Item Number: C Department: Finance (City Secretary's Use Only) Prepared By: Finance Account Code: Date Prepared: May 12, 2015 Budgeted Amount: Exhibits: Investment Report Subject Consider, and place on file, the City of Wylie Monthly Investment Report for April 30, 2015. Recommendation Motion to accept and place on file, the City of Wylie Monthly Investment Report for April 30, 2015. Discussion The Finance Department has prepared the attached reports for the City Council as required by the City Charter. Page 1 of 1 2014-2015 Investment Report April 30, 2015 Money Market Accounts: MMA Certificates of Deposit: CCD Treasury Bills: T-Bills Treasury Notes: T-Notes Government Agency Notes: AN Invest. Principal Type Of Interest Purchase Maturity Number Amount Security Rate Issuer Date Date 1 $14,531,508.18 MMA 0.0524% Texpool 12/31/2006 NA 2 $15,049,860.04 MMA 0.0701% TexStar 3/15/2011 NA $29,581,368.22 Total Weighted Average Coupon: 0.0614% Money Markets: $29,581,368.22 Weighted Average Maturity(Days): 1.00 Certificates of Deposits: $0.00 $29,581,368.22 4.! r.,-�• Wylie City Council Am.fzi f AGENDA REPORT a _......0„." Meeting Date: May 26, 2015 Item Number: D Department: Finance (City Secretary's Use Only) Prepared By: Finance Account Code: Date Prepared: May 12, 2015 Budgeted Amount: Revenue and Expenditure Exhibits: Monthly Report Subject Consider, and place on file, the City of Wylie Monthly Revenue and Expenditure Report for April 30, 2015. Recommendation Motion to accept and place on file, the City of Wylie Monthly Revenue and Expenditure Report for April 30, 2015. Discussion The Finance Department has prepared the attached reports for the City Council as required by the City Charter. Page 1 of 1 CITY OF WYLIE MONTHLY FINANCIAL REPORT April 30,2015 ANNUAL CURRENT YTD ACTUAL Benchmark BUDGET MONTH ACTUAL YTD ACTUAL AS A PERCENT 58.33% ACCOUNT DESCRIPTION 2014-2015 2014-2015 2014-2015 OF BUDGET GENERAL FUND REVENUE SUMMARY TAXES 20,452,238 446,026 18,135,772 88.67% A FRANCHISE FEES 2,498,000 36,485 783,688 31.37% B LICENSES AND PERMITS 638,000 103,847 608,980 95.45% INTERGOVERNMENTAL REV. 784,060 9,053 430,436 54.90% SERVICE FEES 3,023,905 238,729 1,794,190 59.33% FINES AND FORFEITURES 300,000 35,690 223,228 74.41% INTEREST INCOME 3,000 578 2,769 92.29% MISCELLANEOUS INCOME 230,000 7,070 97,668 42.46% OTHER FINANCING SOURCES 2,444,855 0 2,444,855 100.00% C REVENUES 30,374,058 877,478 24,521,586 80.73% USE OF FUND BALANCE 1,229,896 NA NA NA D USE OF CARRY-FORWARD FUNDS 67,660 NA NA NA TOTAL REVENUES 31,671,614 NA NA NA GENERAL FUND EXPENDITURE SUMMARY CITY COUNCIL 102,636 6,807 46,751 45.55% CITY MANAGER 809,453 70,861 439,225 54.26% CITY SECRETARY 270,928 28,937 145,224 53.60% CITY ATTORNEY 178,000 8,619 34,399 19.33% FINANCE 993,266 57,341 559,851 56.36% FACILITIES 633,416 63,279 292,928 46.25% MUNICIPAL COURT 353,976 26,878 184,940 52.25% HUMAN RESOURCES 218,850 17,535 128,602 58.76% PURCHASING 94,302 7,184 49,263 52.24% INFORMATION TECHNOLOGY 1,091,937 90,995 599,086 54.86% POLICE 7,348,566 603,274 3,928,178 53.46% FIRE 6,455,247 531,474 3,455,941 53.54% EMERGENCY COMMUNICATIONS 1,269,232 80,109 640,288 50.45% ANIMAL CONTROL 502,491 34,788 239,452 47.65% PLANNING 512,246 31,816 274,501 53.59% BUILDING INSPECTION 555,482 25,893 304,537 54.82% CODE ENFORCEMENT 238,462 15,190 111,622 46.81% STREETS 2,054,727 130,787 615,704 29.97% PARKS 1,906,224 117,908 788,507 41.36% LIBRARY 1,659,266 126,302 841,757 50.73% COMBINED SERVICES 4,534,256 466,764 2,402,442 52.98% TOTAL EXPENDITURES 31,782,963 2,542,741 16,083,198 50.60% REVENUES OVER/(UNDER)EXPENDITURES -111,349 -1,665,263 8,438,388 30.13% A. Property Tax Collections for FY14-15 as of April 30 are 99.18%, in comparison to FY13-14 for the same time period of 98.19%. B. Franchise Fees:The majority of franchise fees are recognized in the third and fourth quarter with electric fees making up the majority. C.Other Financing Sources includes the annual transfer from the Utility Fund plus proceeds from the sale of capital assets. D. Use of Fund Balance: For Replacement/New Fleet&Equipment and Transfer to Debt Service. CITY OF WYLIE MONTHLY FINANCIAL REPORT April 30,2015 ANNUAL CURRENT YTD ACTUAL Benchmark BUDGET MONTH ACTUAL YTD ACTUAL AS A PERCENT 58.33% ACCOUNT DESCRIPTION 2014-2015 2014-2015 2014-2015 OF BUDGET UTILITY FUND REVENUES SUMMARY SERVICE FEES 13,545,000 1,644,644 5,104,533 37.69% E INTEREST INCOME 1,400 179 872 62.31% MISCELLANEOUS INCOME 45,000 4,774 357,341 794.09% F OTHER FINANCING SOURCES 0 0 0 0.00% REVENUES 13,591,400 1,649,597 5,462,746 40.19% USE OF FUND BALANCE 434,000 NA NA NA G TOTAL REVENUES 14,025,400 NA NA NA UTILITY FUND EXPENDITURE SUMMARY UTILITY ADMINISTRATION 423,987 21,233 164,953 38.91% UTILITIES-WATER 1,688,933 107,040 804,258 47.62% CITY ENGINEER 520,614 30,530 216,214 41.53% UTILITIES-SEWER 887,858 44,055 467,533 52.66% UTILITY BILLING 314,218 19,412 141,272 44.96% COMBINED SERVICES 11,191,637 607,935 7,488,573 66.91% H TOTAL EXPENDITURES 15,027,247 830,205 9,282,803 61.77% REVENUES OVER/(UNDER)EXPENDITURES -1,001,847 819,392 -3,820,057 -21.58% E. Most Utility Fund Revenue billed in October was applicable to FY 2013-14. F. Miscellaneous Income: Includes a check in the amount of$310,375 from NTMWD to assist with construction of the East Brown Pump Station. G. Use of Fund Balance: For Replacement/New Fleet&Equipment. H. Due to annual transfer to the General Fund &debt service payment recorded in February. This will level out throughout the fiscal year. 17- 4.! , r';]. ,, Wylie City Councilint 44,4b. il f AGENDA REPORT a Meeting Date: May 26, 2015 Item Number: E Department: Planning (City Secretary's Use Only) Prepared By: Renae' 011ie Account Code: Date Prepared: May 13, 2015 Budgeted Amount: Exhibits: 1 Subject Consider, and act upon approval of a Final Plat for Westgate Station Addition on 10.060 acres, generally located south east corner of Westgate Way and Fleming. Recommendation Motion to approve a Final Plat for Westgate Station Addition on 10.060 acres, generally located south east corner of Westgate Way and Fleming. Discussion OWNER: HNI WYLIE DEVELOPMENT PARTNERS,LLC ENGINEER: HELMBERGER ASSOC. The property totals 10.06 acres and will create one hundred and four (104) townhome residential lots. There are no open space lots within the development. The property owners will pay fees in lieu of parkland dedication in the amount of $156,000. The property was the subject of a zoning case in 2014, and adopted by Ordinance No. 2014-40 (PD-TH) for Single-Family Attached development. The plat shall also dedicate necessary rights-of-way, and utility easements. The Final Plat complies with the approved Concept Plan and with all applicable technical requirements of the City of Wylie. Planning& Zoning Commission Discussion: The Commission asked what was the average and max dwelling unit sizes. The applicant stated that the maximum units will range between 2,400 s.f. and 2,500 s.f., with no less than 20%being smaller than 1,500 s.f. The Commission voted 5- 0 to recommend approval subject to additions and alterations as required by the City Engineering Department. (Rev 01/2014) Page 1 of 1 CERTIFICATE OWNERS DEDICATION AND ACKNOWLEDGEMENT SURVEYOR'S GATE OF TEXAS $ COUNTY OFECO LIN § DF CuIN `3W WHEREAS FIN ley.➢enelapment Partners LCC 3 A del Cuzzo hereby rer1�ry final ding plat from actualsurvey(Mlcn on W E. °`kv, Slate of s.the County o Coll'in and the C1y o Wyl'ie ebeing p or the E.C.DavidsoneSurvey,e supe land oand a�mNaxce with 1ne app coble shown caaes aaa oraiaaafound and/or placed under my City of Nryne 66/ 0 bed 630 of the follows: Deed Records or Co n County. eras and these Railway• recorded in Document No. Premises being more particulorly • .. -,. .e' BEGINNING at 1/2 inch iron rod copped'Roome"sed for corner in the north right-of-woy line of Dollos Michael Cuzzo Area Rapid Transit (00 right-of-way)a \Te. We or o n Texos,according to the plot 120 d d Texas and the southeast rdedicoled ecorded® 7 Corner or sadeL M.B.P Ltd.tract: g ACKNOWLEDGEMENT e. YSTATE OF TEXAS\.p r� atl y,• „:;',_1-: • `v F/pm/ap. / COUNTY OF COLLN § ^g R BOA�a apd BEFOREes au s personally oppe ea NfMnel Nato.known e the person whose / 7 y,W ,�3fPo -z la tact asfollows:THENCE Wil5 said east right-of-way o wayWestgate v a ewes ere o said L.M.a Partnership. o same was executed mepurposes 1 forego e g 10 me that `i thebs ecuted9for the p subscribed and o consideration the expressed. ac � �a.3O °g / g !' 29 4 GIVEN UNDER My HAND AND SEAL OF OFFICE,the the y 2O15. 35 ,-_q_.4q--,.,., -.. z,. North 03.16,9"West,97..feet to a point for corner rnorking the beginning of o curve to the v �y/ �`& rW. ro&s -- r_'s -,� right era from when a /2'ncn iron rod capped DAS 4645 round bears S]n n525 E 066 eel a Y/, �. c e N an ror / s'3 27 IC, ^ "" ]era Stalebor]eras//_ --o or neasl d rye. 1 'q J - s 0353 / r earner marking e 'RECOMMENDED FOR APPROVAL- re :/ beginning. ▪ / ,nsz 25 433 35.) / 1 g7.2o 3),14; 5 6, 7 z g coca ss on Dale T J f ^J✓ csvJ ffi L h n rod copped DAS 6 5 found or corner ma g e Y v Texas U -- / - papp beginning APPROVED FOR CONSTRUCTON r 3 /ll t 23 1having a rodlus of 517,50 feet,o central angle of I m124 j "1 2 m ''.p, 7,a dRIVE d am were a /2 ' 1A ,+ "'� - +o(I b S tl n ron rod mppea DPS d6a5!Duna Mayor.City y Texas pole /�> C I ,se 'N .oe .. ears 191 "ACCEPTED" e m grero / - /�� f -o-_,=�o, _ Pr-'- L - Drive North 31.5 concrete n me centerline or Fleming w �"a,�n6,N a 1 t, P O s 1 -- ^' � 1 3 4 j5 s 78 Bj. THENCE with e M C' w Texas D. • f A, rN o�8" / >�1 _-.-____ to the South SeR and East.93.99 re an x cot roan,n concrete marking e beginning a come y Secretory the City of Wylie,Texas,hereby certifies thot the foregoing f„1 plot of the subdivision or addition to the City of Wylie was submitted;the City Council on the __day of .2015.ond the Council,by I aO 1],,av/ Southeosterly Oh sold curve to the left hoving o rodlus of 367.50 feet.o centrol ongle of d awaterr and sewer lines ors sn a e ] -'W / 5 s cjset-forth in ond upon sold plot and said Council further on orc dIslonce of Eost.19437 feet to on authorized the Mayor to mole the acceptance thereof by signing enobove subsc bed. ,eepp�}r • • q 'curry / oo - and n the o said L ptract;cut set in concrete In the west Ilne of as W g Hollow Addition ▪ ?0 '"»r�6('a^ t _ FI B. Wlnes Y era tns y AD.2O 5. aAN • °+£5y r THENCE with the west line of soid Westgote Hollow Addillon.the west rIght-of-woy Ilne of Did 0 f Tie / 1 _ 2R 3$ 4 5R16 7v N aat �yOh e .cos iq'n'Itit it feet m the Point a g g a w g 06O cares D a d, Dear es. City Secretory �. 3 1 L a.W �� $ OWNER'S CERTIFICATECity o Wylie.TexasLINE BEARING DISTANCE '°' 12 & i10.06O�crke va'°'`b a`°aw • - ____ g t 4 / 'a0 11 '> lmu M+w ee ii .47Z,,s, cue n N (46 ;1 /,t s, COUNTY OF ECawN g r':. SITE L- '2( 10 R2 CSIN110 �' NOW THEREFORE KNOW ALL MEN BY THESE PRESENTS. ¢e / „NNNINE E E0, a sr, 1 MI',NW Development Partners LLC does �' s T%' _ ' r -a 1% s Final Pat cur re,tgw_e swim.hereby vWylie,'� 1 _ s described eeapta°ahas The/ B ( lm 1%_ 2 38,( 5 v:J6 . IIN ee 3e 10 11 1aa�s or Iiir„eel placed upon.over or across the shown.except that landscape Improvements moy be LI5 N31,1:20, nd occommodation of all public utilities desiring to use or ) a.ra err, r ----._ a utilities.said by public utilities g " easements may olso be used for°dime ause s l !�/ 5 I sab,bn�temtepabxsandea w�- mac "4rev 1 T _ _ - e:n 'm` The City or Wy'e and public utiliges entities sholl hove the right to remove ond keep removed oll or VICINITY MAP parts,any building.fences,trees.shrubs or olher improvements or growths which may in any way 1 ;; EBE 10 0 I , . 1„.C) .2 1 ; ; ; , 21,t1 5 4- - endanger or interfere with the constructlon.moIntenance,or efficlency of their respective systems In rs- vI 1 21 33 45 574 63 Y' 8 95110 11 3' 141 C J.s g _ g g cteasements.The City of Wylie and public utility entities shall ot all times have the full right of s"gaad a' lm I pa o e expect ve systems -_-_ 7 M -1m a1 ai _._ wmaut the nece prod!g p :son Tom v . - 04 I 1 N WTNESS my ha.,1'the day Ora ,2O15a ,r / 1'. N 6.IIN Paco e .aI owner --- n FCLE CZF£LdTrON \\\ 00. m; ACKNOWLEDGEMENT fir... to r.. t Y 'o r ,za s, e ao l r r3N -1 1 COUNTY OFSTATE TEXAS ECOLLN 4 'I; I, I'(''� R 11 IT . 15 6 17 18 1"1I 120 21 22 333e ` 2 a DeOO1e Hon.-Magn o me c a isrz.so >>.sz i.nT rv>>zn 2g a se e .) M2 3 4r 5 fi 8" 9 101 sl1 12 1 1 O $ g 11 trot the same was executed for the purposes and considerationvo m e/s a $ L}Y _e DER My HAND of DFF cos me D,5 Final Plat of • BEFORE FE the undersigned auma II' AN me to b me person whose �� �'" Westgate Station a:e name e en:c r=-=,t,:,,,_—,=e = --vol , � o P T xos ° 1..ROW 10.060 Acres in the E.C.Davidson Survey,Abstract No.266 Lod City of Wylie,Collin County, Texas (NOTES(1(2 t;(2(N February 2015 mnavr� a Special is controlling ereaaminundated b Ferree, Kr2/2,5 Insurance Rate Mop Number 48085C0420 J of F.E.M.A.Flood Insuronce Rote Maps for(3 P✓ib,Adr,1625D.KWbo : )Source bea the City of Wylie as (°( ylie Development Partners LLG Dome Land Sutvevim*lee. �.a m nm.m g property PD Panned Development op e nt District. (5) an withholding a utilities deg permits. N Texas 75098 tAF W � p J �* A r Wylie City Council 2A AGENDA REPORT w,�prass���M Meeting Date: May 26, 2015 Item Number: 1 (City Secretary's Use Only) Department: City Manager Prepared By: Account Code: Date Prepared: May 8, 2015 Budgeted Amount: N/A Exhibits: Memo, Ordinance Subject Consider and act upon Ordinance No. 2015-21 of the City Council of the City of Wylie, Texas, approving a NEGOTIATED settlement between the Atmos Cities Steering Committee ("ACSC") and ATMOS ENERGY CORP., Mid-Tex Division regarding the company's 2014 and 2015 rate review mechanism filings; approving a settlement agreement with attached rate tariffs and proof of revenues; declaring Existing rates to be unreasonable; adopting tariffs that reflect rate adjustments consistent with the Negotiated Settlement; finding the rates to be set by the Settlement Tariffs to be just and reasonable and in the public interest; Requiring the Company to reimburse ACSC's reasonable ratemaking expenses; determining that this ordinance was passed in accordance with the requirements of the Texas Open Meetings Act; adopting a saving clause; declaring an effective date; and requiring delivery of this Ordinance to the company and the ACSC's legal counsel. Recommendation Motion to approve Ordinance No. 2014-21, of the City Council of the City of Wylie, Texas, approving a Negotiated Settlement between the Atmos Cities Steering Committee ("ACSC") and ATMOS ENERGY CORP., Mid-Tex Division regarding the company's 2014 and 2015 rate review mechanism filings; approving a settlement agreement with attached rate tariffs and proof of revenues; declaring existing rates to be unreasonable; adopting tariffs that reflect rate adjustments consistent with the Negotiated Settlement and as provided for in Agenda Iteml. Discussion The City, along with other similarly situated cities served by Atmos Energy Corp., Mid-Tex Division ("Atmos Mid-Tex" or "Company"), is a member of the Atmos Cities Steering Committee ("ACSC"). The RRM Tariff was adopted by the City as an alternative to the Gas Reliability Infrastructure Program ("GRIP"), the statutory provision that allows Atmos to bypass the City's rate regulatory authority to increase its rates annually to recover capital investments. In February 2014, Atmos Mid-Tex filed its second annual filing under the Rate Review Mechanism ("RRM") Tariff, seeking an increase of$45.7 million. Although ACSC attempted to reach a settlement with the Company as it had in past years, the wide differences between the Company and ACSC's consultants' recommendations made a compromise impossible. On the recommendation of the ACSC Executive Committee and ACSC's legal counsel, the City in 2014 adopted a Resolution denying the requested rate increase. Page 1 of 4 Page 2 of 4 The Company appealed the City's denial to the Railroad Commission of Texas ("Commission"), and revised its requested increase to $43.8 million. A hearing was held on the Company's appeal on September 3, 2014. On April 28, 2015, the Commission's Hearings Examiner issued his Proposal for Decision ("PFD") in the Company's appeal of the City's denial of the 2014 RRM rate increase. This PFD was not favorable to ACSC, but did recommend a reduction of approximately $860,000 to the Company's adjusted 2014 filing. While the parties were waiting for the PFD from the Hearings Examiner in the appeal of the 2014 RRM filing, on February 27, 2015, Atmos Mid-Tex filed with the City another rate increase request under the RRM Tariff, seeking additional revenues in the amount of $28.762 million (total system) or $24.0 million (affected cities). The City worked with ACSC to analyze the schedules and evidence offered by Atmos Mid-Tex to support its 2015 request to increase rates. The Ordinance and attached Settlement Agreement and tariffs are the result of negotiation between the Mid-Tex Executive Committee and the Company to resolve issues raised by ACSC during the review and evaluation of Atmos Mid-Tex's filing. The recommended Settlement Agreement also requires Atmos to abate its appeal of the City's rejection of the 2014 RRM rate increase pending approval by all ACSC cities of the Settlement Agreement. The Agreement requires Atmos to give the City the benefit of the adjustments to the 2014 rate increase recommended by the PFD. The Ordinance and Settlement tariffs approve rates that will increase the Company's revenues by $65.7 million for the Mid-Tex Rate Division, effective for bills rendered on or after June 1, 2015. The monthly residential customer charge will be $18.60. The consumption charge will change from $0.08819 per Ccf to $0.09931 per Ccf The monthly bill impact for the typical residential customer consuming 60 Ccf will be an increase of$1.14 (about a 1.59% increase in the base bill). The typical commercial customer will see an increase of $2.69 or 0.96%. The ACSC Executive Committee and its designated legal counsel and consultants recommend that all Cities adopt the Ordinance approving the negotiated Settlement Agreement resolving both the 2014 and the 2015 RRM filings, and implementing the rate change. RRM Background: The RRM tariff was originally approved by ACSC Cities as part of the settlement agreement to resolve the Atmos Mid-Tex 2007 system-wide rate filing at the Railroad Commission. In early 2013, the City adopted a renewed RRM tariff for an additional five years. This is the third RRM filing under the renewed tariff. The RRM tariff and the process implementing that tariff were created collaboratively by ACSC and Atmos Mid-Tex as an alternative to the legislatively-authorized GRIP surcharge process. ACSC has opposed GRIP because it constitutes piecemeal ratemaking, does not allow any review of the reasonableness of Atmos' expenditures, and does not allow participation by cities or recovery of cities' rate case expenses. In contrast, the RRM process has allowed for a more comprehensive rate review and annual adjustment as a substitute for GRIP filings. ACSC's consultants have calculated that had Atmos filed its 2015 case under the GRIP provisions, it would have received additional revenues from ratepayers of approximately $10 million. Purpose of the Ordinance: The purpose of the Ordinance is to approve the Settlement Agreement and the resulting rate change under the RRM tariff. As a result of the negotiations, the Executive Committee was able to reduce the Company's requested $28.8 million rate increase for Mid-Tex cities to $21,962,784. When added to the settlement of the 2014 RRM filing and the adjustments recommended by the PFD, the Company will receive total additional annual revenues of$65.7 million. Because the 2014 rates have been in effect since June 1, 2014, the increase to currently-billed rates is $21 million. Approval of the Ordinance will result in rates that implement an increase in Atmos Mid-Tex's revenues effective June 1, 2015. Page 3 of 4 Why Approve the Settlement Agreement: While it is annoying and disconcerting to annually consider rate adjustments from Atmos Mid-Tex, the Texas legislature has granted gas utilities the right, through the GRIP process, to an annual increase based on increases in invested capital. GRIP is piecemeal ratemaking and ignores increases in revenues and declines in O&M expenses that may be associated with plant additions. ACSC found it preferable to negotiate with Atmos to substitute an expedited comprehensive review process that includes consideration of revenues and expenses as well as invested capital for the GRIP process. Compelling reasons for approving the Settlement include: 1. While the 2015 RRM system-wide filing exceeded $28 million, a comparable GRIP filing would have been in excess of $38 million. ACSC has negotiated a reduction to the 2015 filing of approximately $6 million. Therefore, the 2015 RRM result is approximately $16 million better for ratepayers within municipal limits than ratepayers within Environs. 2. ACSC counsel is convinced that the Proposal for Decision ("PFD") by Railroad Commission Examiners in the 2014 RRM appeal will not improve if we file Exceptions and Replies to Exceptions. Counsel recommends action to avoid the PFD becoming a final order that would serve as precedent in future rate proceedings. 3. The token benefit to ratepayers authorized in the PFD to the 2014 appeal has been incorporated into the Settlement Agreement. 4. Atmos will file its formal withdrawal of its 2014 appeal only after all ACSC members approve the Settlement Agreement 5. The alternative to approval of the Settlement Agreement would be another contested case hearing on appeal of the 2015 filing, implementation of interim rates on June 1, 2015 at the full value of the Company's request (or $6 million higher than proposed by the Settlement) and continuation of the 2014 appeal with resulting rate case expenses borne by ratepayers. Explanation of`Be It Ordained" Sections: 1. This section approves all findings in the Ordinance. 2. This section finds the Settlement Agreement (attached to the Ordinance) to be a comprehensive settlement of gas utility rate issues arising from Atmos Mid-Tex's 2014 and 2015 RRM filings, and that such settlement is in the public interest and consistent with the City's statutory authority. 3. This section finds the existing Atmos Mid-Tex rates to be unreasonable, and approves the new tariffed rates providing for additional revenues over currently-billed rates of $21 million and adopts the attached new rate tariffs. 4. This section establishes the baseline for pensions and other post-employment benefits for future rate cases. 5. This section renews the Atmos Mid-Tex RRM Tariff for an additional period of time, commencing with the filing to be made on March 1, 2016, and continuing until the RRM Tariff is suspended by ordinance of the City. Page 4 of 4 6. This section requires the Company to reimburse Cities for reasonable ratemaking costs associated with reviewing and processing the RRM filing. 7. This section repeals any resolution or ordinance that is inconsistent with this Ordinance. 8. This section finds that the meeting was conducted in compliance with the Texas Open Meetings Act, Texas Government Code, Chapter 551. 9. This section is a savings clause, which provides that if any section(s) is later found to be unconstitutional or invalid, that finding shall not affect, impair or invalidate the remaining provisions of this Ordinance. This section further directs that the remaining provisions of the Ordinance are to be interpreted as if the offending section or clause never existed. 10. This section provides for an effective date upon passage which, according to the Cities' ordinance that adopted the RRM process, is June 1, 2015. 11. This paragraph directs that a copy of the signed Ordinance be sent to a representative of the Company and legal counsel for the Steering Committee. ORDINANCE NO. 2015-21 AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF WYLIE, TEXAS, APPROVING A NEGOTIATED SETTLEMENT BETWEEN THE ATMOS CITIES STEERING COMMITTEE ("ACSC") AND ATMOS ENERGY CORP., MID-TEX DIVISION REGARDING THE COMPANY'S 2014 AND 2015 RATE REVIEW MECHANISM FILINGS; APPROVING A SETTLEMENT AGREEMENT WITH ATTACHED RATE TARIFFS AND PROOF OF REVENUES; DECLARING EXISTING RATES TO BE UNREASONABLE; ADOPTING TARIFFS THAT REFLECT RATE ADJUSTMENTS CONSISTENT WITH THE NEGOTIATED SETTLEMENT; FINDING THE RATES TO BE SET BY THE SETTLEMENT TARIFFS TO BE JUST AND REASONABLE AND IN THE PUBLIC INTEREST; REQUIRING THE COMPANY TO REIMBURSE ACSC'S REASONABLE RATEMAKING EXPENSES; DETERMINING THAT THIS ORDINANCE WAS PASSED IN ACCORDANCE WITH THE REQUIREMENTS OF THE TEXAS OPEN MEETINGS ACT; ADOPTING A SAVINGS CLAUSE; DECLARING AN EFFECTIVE DATE; AND REQUIRING DELIVERY OF THIS ORDINANCE TO THE COMPANY AND THE ACSC'S LEGAL COUNSEL. WHEREAS, the City of Wylie, Texas ("City") is a gas utility customer of Atmos Energy Corp., Mid-Tex Division ("Atmos Mid-Tex" or "Company"), and a regulatory authority with an interest in the rates and charges of Atmos; and WHEREAS, the City is a member of the Atmos Cities Steering Committee ("ACSC"), a coalition of similarly-situated cities served by Atmos Mid-Tex ("ACSC Cities") that have joined together to facilitate the review of and response to natural gas issues affecting rates charged in the Atmos Mid-Tex service area; and WHEREAS, ACSC and the Company worked collaboratively to develop a new Rate Review Mechanism ("RRM") tariff that allows for an expedited rate review process by ACSC Cities as a substitute to the Gas Reliability Infrastructure Program ("GRIP")process instituted by Ordinance No.2015-21 1 Approving a negotiated settlement between the Atmos Cities Steering Committee("ACSC") and Atmos Energy Corp. 4753134.1 the Legislature, and that will establish rates for the ACSC Cities based on the system-wide cost of serving the Atmos Mid-Tex Division; and WHEREAS, the initial RRM Tariff was in effect for four(4) years; and WHEREAS, ACSC Cities and Atmos Mid-Tex entered into another settlement agreement and revised the RRM Tariff; and WHEREAS, ACSC Cities and Atmos Mid-Tex compromised and reached agreements on the amount of the rate increases to be in effect for the RRM Tariff filings for 2012 and 2013; and WHEREAS, ACSC Cities and Atmos Mid-Tex were unable to reach an agreement on the 2014 RRM Tariff filing, resulting in the ACSC Cities' rejection of the 2014 RRM filing; and WHEREAS, Atmos Mid-Tex appealed the ACSC Cities' actions rejecting its 2014 RRM filing to the Railroad Commission of Texas ("Commission"), pursuant to the provisions of the RRM Tariff; and WHEREAS, Atmos Mid-Tex and ACSC litigated the appeal of the 2014 RRM filing at the Commission; and WHEREAS, on February 27, 2015, Atmos Mid-Tex filed its 2015 RRM Tariff filing, requesting to increase natural gas base rates system-wide by $28.762 million; and WHEREAS, ACSC coordinated its review of Atmos Mid-Tex RRM filing through its Executive Committee, assisted by ACSC's attorneys and consultants, to resolve issues identified in the Company's RRM filing; and WHEREAS, Atmos Mid-Tex has agreed to withdraw its appeal of ACSC's rejection of its 2014 RRM Tariff rate increase; and WHEREAS, the Executive Committee, as well as ACSC's counsel and consultants, recommend that ACSC Cities approve the attached Settlement Agreement (Attachment A to this Ordinance No.2015-21 2 Approving a negotiated settlement between the Atmos Cities Steering Committee("ACSC") and Atmos Energy Corp. 4753134.1 Ordinance) as well as the tariffs attached thereto, resolving both the 2014 and the 2015 RRM Tariff filings, which together will increase the Company's revenues by $65.7 million over the amount allowed under City-approved rates set in 2013; and WHEREAS, the attached tariffs implementing new rates are consistent with the negotiated Settlement Agreement and are just, reasonable, and in the public interest; and WHEREAS, the RRM Tariff should be renewed for a period of time commencing in 2016 and continuing until the RRM Tariff is suspended by ordinance of the City; and WHEREAS, the RRM Tariff contemplates reimbursement of ACSC's reasonable expenses associated with RRM applications; NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF WYLIE, TEXAS: Section 1. That the findings set forth in this Ordinance are hereby in all things approved. Section 2. That the City Council finds that the Settlement Agreement (Attachment A to this Ordinance) represents a comprehensive settlement of gas utility rate issues affecting the rates, operations, and services offered by Atmos Mid-Tex within the municipal limits arising from Atmos Mid-Tex's 2014 and 2015 RRM filings, is in the public interest, and is consistent with the City's authority under Section 103.001 of the Texas Utilities Code. Section 3. That the existing rates for natural gas service provided by Atmos Mid-Tex are unreasonable. The new tariffs attached hereto and incorporated herein as Attachment C, are just and reasonable, and are designed to allow Atmos Mid-Tex to recover annually an additional $65.7 million in revenue over the amount allowed under currently approved rates, or $21 million over currently-billed rates, as shown in the Proof of Revenues attached hereto and incorporated herein as Attachment B; such tariffs are hereby adopted. Ordinance No.2015-21 3 Approving a negotiated settlement between the Atmos Cities Steering Committee("ACSC") and Atmos Energy Corp. 4753134.1 Section 4. That the ratemaking treatment for pensions and other post-employment benefits in Atmos' next RRM filing shall be as set forth on Attachment D, attached hereto and incorporated herein. Section 5. That in an effort to streamline the regulatory review process, the Atmos Mid- Tex RRM Tariff is renewed for a period commencing with the Company's March 1, 2016 RRM filing for calendar year 2015, effective June 1, 2016, and continuing thereafter until such time as the City adopts an ordinance suspending operation of the RRM Tariff. Section 6. That Atmos Mid-Tex shall reimburse the reasonable ratemaking expenses of the ACSC in processing the Company's RRM application. Section 7. That to the extent any resolution or ordinance previously adopted by the Council is inconsistent with this Ordinance, it is hereby repealed. Section 8. That the meeting at which this Ordinance was approved was in all things conducted in strict compliance with the Texas Open Meetings Act, Texas Government Code, Chapter 551. Section 9. That if any one or more sections or clauses of this Ordinance is adjudged to be unconstitutional or invalid, such judgment shall not affect, impair or invalidate the remaining provisions of this Ordinance and the remaining provisions of the Ordinance shall be interpreted as if the offending section or clause never existed. Section 10. That consistent with the City Ordinance that established the RRM process, this Ordinance shall become effective from and after its passage with rates authorized by attached tariffs to be effective for bills rendered on or after June 1, 2015. Section 11. That a copy of this Ordinance shall be sent to Atmos Mid-Tex, care of Chris Felan, Vice President of Rates and Regulatory Affairs Mid-Tex Division, Atmos Energy Ordinance No.2015-21 4 Approving a negotiated settlement between the Atmos Cities Steering Committee("ACSC") and Atmos Energy Corp. 4753134.1 Corporation, 5420 LBJ Freeway, Suite 1862, Dallas, Texas 75240, and to Geoffrey Gay, General Counsel to ACSC, at Lloyd Gosselink Rochelle & Townsend, P.C., 816 Congress Avenue, Suite 1900, Austin, Texas 78701. PASSED AND APPROVED this 26th day of May, 2015. Mayor ATTEST: APPROVED AS TO FORM: City Secretary City Attorney Ordinance No.2015-21 5 Approving a negotiated settlement between the Atmos Cities Steering Committee("ACSC") and Atmos Energy Corp. 4753134.1 Attachment A SETTLEMENT AGREEMENT BETWEEN ATMOS ENERGY CORP., MID-TEX DIVISION AND ATMOS CITIES STEERING COMMITTEE WHEREAS, this agreement ("Settlement Agreement") is entered into by Atmos Energy Corp's Mid-Tex Division and Atmos Cities Steering Committee ("ACSC") whose members include the Cities of Abilene, Addison, Allen, Alvarado, Angus, Anna, Argyle, Arlington, Aubrey, Bedford, Bellmead, Benbrook, Beverly Hills, Blossom, Blue Ridge, Bowie, Boyd, Bridgeport, Brownwood, Buffalo, Burkburnett, Burleson, Caddo Mills, Canton, Carrollton, Cedar Hill, Celeste, Celina, Centerville, Cisco, Clarksville, Cleburne, Clyde, College Station, Colleyville, Colorado City, Comanche, Commerce, Coolidge, Coppell, Copperas Cove, Corinth, Corral City, Crandall, Crowley, Dalworthington Gardens, Denison, DeSoto, Duncanville, Eastland, Edgecliff Village, Emory, Ennis, Euless, Everman, Fairview, Farmers Branch, Farmersville, Fate, Flower Mound, Forest Hill, Fort Worth, Frisco, Frost, Gainesville, Garland, Garrett, Grand Prairie, Grapevine, Gunter, Haltom City, Harker Heights, Haskell, Haslet, Hewitt, Highland Park, Highland Village, Honey Grove, Hurst, Hutto, Iowa Park, Irving, Justin, Kaufman, Keene, Keller, Kemp, Kennedale, Kerens, Kerrville, Killeen, Krum, Lake Worth, Lakeside, Lancaster, Lewisville, Lincoln Park, Little Elm, Lorena, Madisonville, Malakoff, Mansfield, McKinney, Melissa, Mesquite, Midlothian, Murphy, Newark, Nocona, North Richland Hills, Northlake, Oakleaf, Ovilla, Palestine, Pantego, Paris, Parker, Pecan Hill, Petrolia, Plano, Ponder, Pottsboro, Prosper, Quitman, Red Oak, Reno (Parker County), Richardson, Richland, Richland Hills, Roanoke, Robinson, Rockwall, Roscoe, Rowlett, Royse City, Sachse, Saginaw, Sansom Park, Seagoville, Sherman, Snyder, Southlake, Springtown, Stamford, Stephenville, Sulphur Springs, Sweetwater, Temple, Terrell, The Colony, Trophy Club, Tyler, University Park, Venus, Vernon, Waco, Watauga, Waxahachie, Westlake, White Settlement, Whitesboro, Wichita Falls, Woodway, and Wylie. WHEREAS, on February 28, 2014, Atmos filed with the ACSC Cities an application, hereinafter referred to as the 2014 RRM filing, to adjust rates pursuant to Rider RRM - Rate Review Mechanism, which were subsequently consolidated into GUD No. 10359 at the Railroad Commission of Texas; and WHEREAS, on February 27, 2015, Atmos filed with the ACSC Cities an application, hereinafter referred to as the 2015 RRM filing, to adjust rates pursuant to Rider RRM - Rate Review Mechanism; and WHEREAS, the Settlement Agreement resolves all issues between Atmos and ACSC ("the Signatories") regarding the 2014 RRM filing, which is currently pending before the Commission, and the 2015 RRM filing, which is currently pending before the ACSC Cities, in a manner that the Signatories believe is consistent with the public interest, and the Signatories represent diverse interests; and WHEREAS, the Signatories believe that the resolution of the issues raised in the 2014 RRM filing and the 2015 RRM filing can best be accomplished by each ACSC City approving this Settlement Agreement and the rates, terms and conditions reflected in the tariffs attached to this Settlement Agreement as Exhibit A; NOW, THEREFORE, in consideration of the mutual agreements and covenants established herein, the Signatories, through their undersigned representatives, agree to the 1 Attachment A following Settlement Terms as a means of fully resolving all issues between Atmos and the ACSC Cities involving the 2014 RRM filing and 2015 RRM filing: Settlement Terms 1. Upon the execution of this Settlement Agreement, the ACSC Cities will approve an ordinance or resolution to approve the Settlement Agreement and implement the rates, terms and conditions reflected in the tariffs attached to the Settlement Agreement as Exhibit A. (Attachment A to the Ordinance ratifying the Agreement). Said tariffs should allow Atmos to recover annually an additional $65.7 million in revenue over the amount allowed under currently approved rates by implementation of rates shown in the proof of revenues attached as Exhibit B. (Attachment B to the Ordinance ratifying this Agreement). The uniform implementation of gas rates, terms and conditions established by the Settlement Agreement shall be effective for bills rendered on or after June 1, 2015. Consistent with the City's authority under Section 103.001 of the Texas Utilities Code, the Settlement Agreement represents a comprehensive settlement of gas utility rate issues affecting the rates, operations and services offered by Atmos within the municipal limits of the ACSC Cities arising from Atmos' 2014 RRM filing and 2015 RRM filing. No refunds of charges billed to customers by Atmos under the RRM in past periods shall be owed or owing. 2. In an effort to streamline the regulatory review process, Atmos and the ACSC Cities have agreed to renew the Rate Review Mechanism ("Rider RRM") for a period commencing with the Company's March 1, 2016 filing under this mechanism for the calendar year 2015, effective June 1, 2016, and continuing thereafter until such time as either the ACSC Cities issue an ordinance stating a desire to discontinue the operation of the tariff or Atmos files a Statement of Intent. Atmos and the ACSC Cities further agree that the RRM tariff shall remain in effect until such time as new, final rates are established for Atmos. Upon approval of this Settlement Agreement by the ACSC Cities, Atmos shall file an updated RRM Tariff with each city reflecting the provisions of this agreement. 3. Atmos and the ACSC Cities agree that rate base as of December 31, 2014 in the amount of$1,955,948,256 is just and reasonable and shall be recovered in rates. 4. Atmos and the ACSC Cities agree that a pension and other postemployment benefits balance as of December 31, 2014 in the amount of$18,284,949 is just and reasonable and shall be used as the beginning balance for purposes of determining pension and other postemployment benefits to be recovered in the next RRM filing (Attachment D to the Ordinance ratifying the Agreement). 5. With regard to the treatment of Atmos' Rule 8.209 regulatory asset under the RRM, Atmos and the ACSC Cities agree to the following with respect to any pending and future RRM filings: a. the capital investment in the Rule 8.209 regulatory asset in the 2014 RRM filing and 2015 RRM filing is reasonable and consistent with the requirements of Rule 8.209; 2 Attachment A b. the classification of projects included in the Rule 8.209 regulatory asset in the 2014 RRM filing and 2015 RRM filing is reasonable and consistent with the requirements of Rule 8.209 and shall serve as a basis for classification of projects in future RRM filings; c. the treatment of blanket replacement projects, system upgrades, relocations, and transmission line replacements in the Rule 8.209 regulatory asset in the 2014 RRM filing and 2015 RRM filing is reasonable and consistent with the requirements of Rule 8.209 and shall be included in future RRM filings. d. the incurred expenses included in the Rule 8.209 regulatory asset in the 2014 RRM and the 2015 RRM are reasonable and consistent with the requirements of Rule 8.209 and shall be included in future RRM filings; e. interest on the Rule 8.209 regulatory asset account shall be calculated using the pre-tax cost of capital most recently approved by the Commission. The use of the pre-tax cost of capital is consistent with Rule 8.209. A return on Rule 8.209 capital investment is only earned once the investment is included in rate base. No change in the Company's calculation of the interest component in its Rule 8.209 regulatory asset accounts is warranted through the period ended May 31, 2015. Beginning June 1, 2015, interest expense shall be calculated monthly using simple interest (i.e. 11.49% divided by 12, or approximately 0.96%per month) applied to the total value of the Rule 8.209 asset investment (exclusive of interest) until such time the Rule 8.209 regulatory asset is approved for inclusion in the Company's rate base. f. While Atmos and the ACSC Cities agree to apply the treatments and methodologies set forth in this paragraph, subsections (a) — (e) in all future RRM filings, the regulatory authority retains its right to disallow any capital investment that is not shown to be prudently incurred, and any expense not shown to be reasonable and necessary, in future RRM filings. g. Atmos and the ACSC Cities acknowledge that their agreement regarding the treatment and methodologies applicable to Rule 8.209 capital investments under the RRM tariff shall not prejudice the right of either party to argue for different treatments or methodologies in a future statement of intent proceeding. 6. Revenues approved pursuant to Paragraph 1 of the Settlement Agreement include reimbursement of rate case expenses owed to the ACSC Cities in connection with the 2014 RRM filing. 7. The Signatories agree that each ACSC city shall approve this Settlement Agreement and adopt an ordinance or resolution to implement for the ACSC Cities the rates, terms, and conditions reflected in the tariffs attached to the Settlement Agreement as Exhibit A. Atmos and ACSC further agree that at such time as all of the ACSC Cities have passed an ordinance or resolution consistent with the Settlement and Atmos has received such ordinance or resolution, Atmos shall withdraw its appeal of the currently pending RRM filing before the Railroad Commission of Texas in connection with the 2014 RRM filing. 3 Attachment A 8. Atmos and the ACSC Cities further agree that the express terms of the Rider RRM are supplemental to the filing, notice, regulatory review, or appellate procedural process of the ratemaking provisions of Chapter 104 of the Texas Utilities Code. If the statute requires a mandatory action on behalf of the municipal regulatory authority or Atmos, the parties will follow the provisions of such statute. If the statute allows discretion on behalf of the municipal regulatory authority, the ACSC Cities agree that they shall exercise such discretion in such a way as to implement the provisions of the RRM tariff. If Atmos appeals an action or inaction of an ACSC City regarding an RRM filing to the Railroad Commission, the ACSC Cities agree that they will not oppose the implementation of interim rates or advocate the imposition of a bond by Atmos consistent with the RRM tariff. Atmos agrees that it will make no filings on behalf of its Mid-Tex Division under the provisions of Section 104.301 of the Texas Utilities code while the Rider RRM is in place. In the event that a regulatory authority fails to act or enters an adverse decision regarding the proposed annual RRM adjustment, the Railroad Commission of Texas shall have exclusive appellate jurisdiction, pursuant to the provisions of the Texas Utilities Code, to review the action or inaction of the regulatory authority exercising exclusive original jurisdiction over the RRM request. In addition, the Signatories agree that this Settlement Agreement shall not be construed as a waiver of the ACSC Cities' right to initiate a show cause proceeding or the Company's right to file a Statement of Intent under the provisions of the Texas Utilities Code. 9. The Signatories agree that the terms of the Settlement Agreement are interdependent and indivisible, and that if any ACSC city enters an order that is inconsistent with this Settlement Agreement, then any Signatory may withdraw without being deemed to have waived any procedural right or to have taken any substantive position on any fact or issue by virtue of that Signatory's entry into the Settlement Agreement or its subsequent withdrawal. If any ACSC city rejects this Settlement Agreement, then this Settlement Agreement shall be void ab initio and counsel for the ACSC Cities shall thereafter only take such actions as are in accordance with the Texas Disciplinary Rules of Professional Conduct. 10. The Signatories agree that all negotiations, discussions and conferences related to the Settlement Agreement are privileged, inadmissible, and not relevant to prove any issues associated with Atmos' 2014 RRM filing and 2015 RRM filing. 11. The Signatories agree that neither this Settlement Agreement nor any oral or written statements made during the course of settlement negotiations may be used for any purpose other than as necessary to support the entry by the ACSC Cities of an ordinance or resolution implementing this Settlement Agreement. 12. The Signatories agree that this Settlement Agreement is binding on each Signatory only for the purpose of settling the issues set forth herein and for no other purposes, and, except to the extent the Settlement Agreement governs a Signatory's rights and obligations for future periods, this Settlement Agreement shall not be binding or precedential upon a Signatory outside this proceeding. 4 Attachment A 13. The Signatories agree that this Settlement Agreement may be executed in multiple counterparts and may be filed with facsimile signatures. 5 Attachment A Agreed to this day of May, 2015. ATMOS ENERGY CORP., MID-TEX DIVISION By: Jo A. Paris President, Mid-Tex Division 6 Attachment A Agreed to this ii"--' day of May 201.5. ATTORNEY FOR ATMOS CITIES STEERING COMMITTEE, WHOSE MEMBERS INCLUDE TITIE CIEIES OF ABILENE„ADDISON, ALLEN, ALVARADO, ANGUS, ANNA., ARGYLE, ARLINGTON, AUBREY, BEDFORD, BELLMEAD, 1,3ENBROOK, BF:NE:R.1.Y HILLS,. BLOSSOM., BLUE RIDGE, BOWIE, BOYD, BRIDGEPORT, BROWNWOOD, BUFFALO, BURKBURNETT, BURLESON, CADD(.1) MILLS,. CANTON, CARROLLTON, CEDAR.HULL, C..ELESTE, CELINA, C[NTERVILL„.E, CISCO, CLARKSVILLE, CLEBURNE,. CLYDE, COLLEGE STATION, COLLEYVILLE, COLORADO CITY, COMANCHE, COMMERCE, COOLIDGE, COPPELL, COPPERAS' COVE, CORINTH, CORRAL CITY, CRANDALL, CROWLEY, DALWORTHINGTON GARDENS, DENISON,. DESOTO, DUNCANVILLE, EASTLAND, EDGECLIFT VILLAGE, EMORY, ENNIS, EULESS„ EVERMAN, FAIRVIEW, FARMERS BRANCIL FAR.MERSVIII..E, FATE, FLOWER MOUND, FOREST 141.EL.„ FORT WORTH, FRISCO, FROST, GAINESVILLE, GARLAND, GARRETT, GRAND PRAIRIE, GRAPEVINE, GUNTER, HALTOM CITY, HARKER. HEIGEITS. HASKELL, .HASLET, HEWITT, 1.-IIGH1....AND PARK, „HIGHLAND VILLAGE, FIONEY GROVE, HURST, HUTTO, IOWA PARK, IRVING, JUSTIN, KAUFMAN, KIHENE, KELLER, KEMP, KENNEDALE, .KERENS, KERRVILLE, KILLEEN, KRUM, LAKE WORTH., .LAKESIDE, LANCASTER, LEWISVILLE, LINCOLN PARK, LITTLE ELM, LORENA, MADISONVILLE, MALAKOFF, MANSFIELD, MCKINNEY, MELISSA, MESQUITE, MIDLOTHIAN, MURPHY, NEWARK.. NOCONA, NORTH RICHLANI) HILLS, NGRTHLAKE, OAKLEAF, OVILLA, .PALESTINE„ PAN!EGO. PARIS, PARKER, PECAN EIILL„. PETROLIA, PLANO, PONDER, POTTSBORO, PROSPER, QUITMAN, 'RED OAK, RLNO (PARKER COUNTY), 'RICHARDSON, RICHLANI), RICHLAND HILLS, ROANOKE, ROBINSON, ROCKWALL, ROSCOE, ROWLETT, ROYSE CITY, SACfISE, SAGINAW, SANSOM PARK, SEAGOVILLE, SHERMAN, SNYDER., SOUTEHAKE, SPRINGTOWN, STAMFORD, STEPHENVILLE, SULPEFUR SPRINGS, SWEETWATER, TEMPLE, TERRELL, THE COLONY, TROPITY CLUB, TYLER, UNIVERSITY PARK, VENUS,. VERNON, WACO, WATAUGA,. WAXAHACHIE,. 'WESTLAKE,. WI II SETTLEMENT, WHITE WICIIITA FALLS, WOOD WAY, AND WYLIE. . „. • 2 •„ ..2,,).„... .2.2. ., • By: ..--2/„ • .2, .4441 . 0- •.. 01141,•,,,—. Geo11're 2 "..:iay* 1 * Subject to approval by ACSC City Councils 7 Attachment A Exhibit A MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: C—COMMERCIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 06/01/2015 PAGE: 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 $40.00 per month Rider CEE Surcharge $ 0.00 per month' Total Customer Charge $40.00 per month Commodity Charge—All Ccf $ 0.08020 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. 1 Reference Rider CEE-Conservation And Energy Efficiency as approved in GUD 10170. Surcharge billing effective July 1,2014. Attachment A Exhibit A MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: I—INDUSTRIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 06/01/2015 PAGE: 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 MMBtu 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 $ 700.00 per month First 0 MMBtu to 1,500 MMBtu $ 0.2937 per MMBtu Next 3,500 MMBtu $ 0.2151 per MMBtu All MMBtu over 5,000 MMBtu $ 0.0461 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. Attachment A Exhibit A MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: I—INDUSTRIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 06/01/2015 PAGE: 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. Special Conditions In order to receive service under Rate I, 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. Attachment A Exhibit A MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: R— RESIDENTIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 06/01/2015 PAGE: 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.60 per month Rider CEE Surcharge $ 0.02 per month' Total Customer Charge $ 18.62 per month Commodity Charge—All Ccf $0.09931 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,2014. Attachment A Exhibit A MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: T—TRANSPORTATION APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 06/01/2015 PAGE: Application Applicable, in the event that Company has entered into a Transportation Agreement, to a customer directly connected to the Atmos Energy Corp., Mid-Tex Division Distribution System (Customer) for the transportation of all natural gas supplied by Customer or Customer's agent at one Point of Delivery for use in Customer's facility. 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 bill will be calculated by adding the following Customer and MMBtu charges to the amounts and quantities due under the riders listed below: Charge Amount Customer Charge per Meter $ 700.00 per month First 0 MMBtu to 1,500 MMBtu $ 0.2937 per MMBtu Next 3,500 MMBtu $ 0.2151 per MMBtu All MMBtu over 5,000 MMBtu $ 0.0461 per MMBtu Upstream Transportation Cost Recovery: Plus an amount for upstream transportation costs in accordance with Part(b)of Rider GCR. Retention Adjustment: Plus a quantity of gas as calculated in accordance with Rider RA. 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). Imbalance Fees All fees charged to Customer under this Rate Schedule will be charged based on the quantities determined under the applicable Transportation Agreement and quantities will not be aggregated for any Customer with multiple Transportation Agreements for the purposes of such fees. Monthly Imbalance Fees Customer shall pay Company the greater of(i) $0.10 per MMBtu, or(ii) 150% of the difference per MMBtu between the highest and lowest "midpoint" price for the Katy point listed in Platts Gas Daily in the table entitled "Daily Price Survey" during such month, for the MMBtu of Customer's monthly Cumulative Imbalance, as defined in the applicable Transportation Agreement, at the end of each month that exceeds 10%of Customer's receipt quantities for the month. Attachment A Exhibit A MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: T—TRANSPORTATION APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 06/01/2015 PAGE: 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. Attachment A Exhibit A MID-TEX DIVISION ATMOS ENERGY CORPORATION RIDER: WNA—WEATHER NORMALIZATION ADJUSTMENT APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 11/01/2015 PAGE: 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; = WNAF; x Where q;j is the relevant sales quantity for the jth customer in ith rate schedule. Attachment A Exhibit A MID-TEX DIVISION ATMOS ENERGY CORPORATION RIDER: WNA—WEATHER NORMALIZATION ADJUSTMENT APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 11/01/2015 PAGE: Base Use/Heat Use Factors Residential Commercial Base use Heat use Base use Heat use Weather Station Ccf Ccf/HDD Ccf Ccf/HDD Abilene 10.22 0.1404 98.80 0.6372 Austin 11.59 0.1443 213.62 0.7922 Dallas 14.12 0.2000 208.11 0.9085 Waco 9.74 0.1387 130.27 0.6351 Wichita 11.79 0.1476 122.35 0.5772 Falls Weather Normalization Adjustment(WNA) Report On or before June 1 of each year, the company posts on its website at atmosenergy.com/mtx-wna, in Excel format, a Weather Normalization Adjustment (WNA) Report to show how the company calculated its WNAs factor during the preceding winter season. Additionally, on or before June 1 of each year, the company files one hard copy and a Excel version of the WNA Report with the Railroad Commission of Texas' Gas Services Division, addressed to the Director of that Division. Exhibit B ATMOS ENERGY CORP., MID-TEX DIVISION PROOF OF REVENUES AND PROPOSED TARIFF STRUCTURE TEST YEAR ENDING DECEMBER 31, 2014 (a) (b) (c) (d) (e) (f) (g) 1 Proposed Change In Rates: $21,066,527 Schedule A 2 Proposed Change In Rates without Revenue Related Taxes: $19,757 254 Ln 1 divided by factor on WP_F-5.1 3 4 5 Revenue 6 Requirements Allocations 7 Residential $ 338,431,486 77.95% Per GUD 10170 Final Order 8 Commercial $ 84,223,622 19.40% Per GUD 10170 Final Order 9 Industrial and Transportation $ 11,490,316 2.65% Per GUD 10170 Final Order 10 Net Revenue Requirements GUD No. 10170 $ 434,145,424 11 12 17 Proposed Proposed Rates o Proposed Proposed Change In Proposed with Rate Case B 18 Rate Class Current Change Rates Revenues Revenues Expenses 19 20 Residential Base Charge $ 18.20 $ 0.36 $ 18.56 $ 6,351,350 $ 327,447,398 $ 18.60 21 Residential Consumption Charge $ 0.08819 $ 0.01112 $ 0.09931 $ 9,049,383 $ 80,817,829 $ 0.09931 22 Commercial Base Charge $ 38.50 $ 1.37 $ 39.87: $ 2,000,584 $ 58,221,364 $ 40.00 23 Commercial Consumption Charge $ 0.07681 $ 0.00339 $ 0.08020 $ 1,834,968 $ 43,411,339 $ 0.08020 24 l&T Base Charge $ 675.00 $ 22.35 $ 697,35 $ 220,192 $ 6,870,292 $ 700.00 25 I&T Consumption Charge Tier 1 MMBTU $ 0.2807 $ 0.0130 $ 0.2937 $ 142,055 $ 3,209,350 $ 0.2937 26 I&T Consumption Charge Tier 2 MMBTU $ 0.2056 $ 0.0095 $ 0.2151 $ 117,051 $ 2,650,282 $ 0.2151 27 I&T Consumption Charge Tier 3 MMBTU $ 0.0441 $ 0.0020 $ 0.0461 $ 42,703 $ 984,314 $ 0.0461 28 $ 19,758,287 $ 523,612,169 29 Data Sources: GUD10170_FINAL.xlsm Attachment B ATMOS ENERGY CORP., MID-TEX DIVISION PROOF OF REVENUES AND PROPOSED TARIFF STRUCTURE TEST YEAR ENDING DECEMBER 31, 2014 (a) (b) (c) (d) (e) (f) (g) 1 Proposed Change In Rates: $21,066,527 Schedule A 2 Proposed Change In Rates without Revenue Related Taxes: $19,757 254 Ln 1 divided by factor on WP_F-5.1 3 4 5 Revenue 6 Requirements Allocations 7 Residential $ 338,431,486 77.95% Per GUD 10170 Final Order 8 Commercial $ 84,223,622 19.40% Per GUD 10170 Final Order 9 Industrial and Transportation $ 11,490,316 2.65% Per GUD 10170 Final Order 10 Net Revenue Requirements GUD No. 10170 $ 434,145,424 11 12 17 Proposed Proposed Rates Proposed Proposed Change In Proposed with Rate Case 18 Rate Class Current Change Rates Revenues Revenues Expenses 19 20 Residential Base Charge $ 18.20 $ 0.36 $ 18.56 $ 6,351,350 $ 327,447,398 $ 18.60 21 Residential Consumption Charge $ 0.08819 $ 0.01112 $ 0.09931 $ 9,049,383 $ 80,817,829 $ 0.09931 22 Commercial Base Charge $ 38.50 $ 1.37 $ 39.87: $ 2,000,584 $ 58,221,364 $ 40.00 23 Commercial Consumption Charge $ 0.07681 $ 0.00339 $ 0.08020 $ 1,834,968 $ 43,411,339 $ 0.08020 24 l&T Base Charge $ 675.00 $ 22.35 $ 697,35 $ 220,192 $ 6,870,292 $ 700.00 25 I&T Consumption Charge Tier 1 MMBTU $ 0.2807 $ 0.0130 $ 0.2937 $ 142,055 $ 3,209,350 $ 0.2937 26 I&T Consumption Charge Tier 2 MMBTU $ 0.2056 $ 0.0095 $ 0.2151 $ 117,051 $ 2,650,282 $ 0.2151 27 I&T Consumption Charge Tier 3 MMBTU $ 0.0441 $ 0.0020 $ 0.0461 $ 42,703 $ 984,314 $ 0.0461 28 $ 19,758,287 $ 523,612,169 29 Data Sources: GUD10170_FINAL.xlsm Attachment C MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: C—COMMERCIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 06/01/2015 PAGE: 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 $40.00 per month Rider CEE Surcharge $ 0.00 per month' Total Customer Charge $40.00 per month Commodity Charge—All Ccf $ 0.08020 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. 1 Reference Rider CEE-Conservation And Energy Efficiency as approved in GUD 10170. Surcharge billing effective July 1,2014. Attachment C MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: I—INDUSTRIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 06/01/2015 PAGE: 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 MMBtu 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 $ 700.00 per month First 0 MMBtu to 1,500 MMBtu $ 0.2937 per MMBtu Next 3,500 MMBtu $ 0.2151 per MMBtu All MMBtu over 5,000 MMBtu $ 0.0461 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. Attachment C MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: I—INDUSTRIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 06/01/2015 PAGE: 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. Special Conditions In order to receive service under Rate I, 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. Attachment C MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: R— RESIDENTIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 06/01/2015 PAGE: 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.60 per month Rider CEE Surcharge $ 0.02 per month' Total Customer Charge $ 18.62 per month Commodity Charge—All Ccf $0.09931 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,2014. Attachment C MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: T—TRANSPORTATION APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 06/01/2015 PAGE: Application Applicable, in the event that Company has entered into a Transportation Agreement, to a customer directly connected to the Atmos Energy Corp., Mid-Tex Division Distribution System (Customer) for the transportation of all natural gas supplied by Customer or Customer's agent at one Point of Delivery for use in Customer's facility. 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 bill will be calculated by adding the following Customer and MMBtu charges to the amounts and quantities due under the riders listed below: Charge Amount Customer Charge per Meter $ 700.00 per month First 0 MMBtu to 1,500 MMBtu $ 0.2937 per MMBtu Next 3,500 MMBtu $ 0.2151 per MMBtu All MMBtu over 5,000 MMBtu $ 0.0461 per MMBtu Upstream Transportation Cost Recovery: Plus an amount for upstream transportation costs in accordance with Part(b)of Rider GCR. Retention Adjustment: Plus a quantity of gas as calculated in accordance with Rider RA. 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). Imbalance Fees All fees charged to Customer under this Rate Schedule will be charged based on the quantities determined under the applicable Transportation Agreement and quantities will not be aggregated for any Customer with multiple Transportation Agreements for the purposes of such fees. Monthly Imbalance Fees Customer shall pay Company the greater of(i) $0.10 per MMBtu, or(ii) 150% of the difference per MMBtu between the highest and lowest "midpoint" price for the Katy point listed in Platts Gas Daily in the table entitled "Daily Price Survey" during such month, for the MMBtu of Customer's monthly Cumulative Imbalance, as defined in the applicable Transportation Agreement, at the end of each month that exceeds 10%of Customer's receipt quantities for the month. Attachment C MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: T—TRANSPORTATION APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 06/01/2015 PAGE: 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. Attachment C MID-TEX DIVISION ATMOS ENERGY CORPORATION RIDER: WNA—WEATHER NORMALIZATION ADJUSTMENT APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 11/01/2015 PAGE: 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; = WNAF; x Where q;j is the relevant sales quantity for the jth customer in ith rate schedule. Attachment C MID-TEX DIVISION ATMOS ENERGY CORPORATION RIDER: WNA—WEATHER NORMALIZATION ADJUSTMENT APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bills Rendered on or after 11/01/2015 PAGE: Base Use/Heat Use Factors Residential Commercial Base use Heat use Base use Heat use Weather Station Ccf Ccf/HDD Ccf Ccf/HDD Abilene 10.22 0.1404 98.80 0.6372 Austin 11.59 0.1443 213.62 0.7922 Dallas 14.12 0.2000 208.11 0.9085 Waco 9.74 0.1387 130.27 0.6351 Wichita 11.79 0.1476 122.35 0.5772 Falls Weather Normalization Adjustment(WNA) Report On or before June 1 of each year, the company posts on its website at atmosenergy.com/mtx-wna, in Excel format, a Weather Normalization Adjustment (WNA) Report to show how the company calculated its WNAs factor during the preceding winter season. Additionally, on or before June 1 of each year, the company files one hard copy and a Excel version of the WNA Report with the Railroad Commission of Texas' Gas Services Division, addressed to the Director of that Division. File Date:February 27,2015 ATTACHMENT D ATM OS ENERGY CORP.,MID-TEX DIVISION PENSIONS AND RETIREE MEDICAL BENEFITS FOR CITIES APPROVAL TEST YEAR ENDING DECEMBER 31,2014 Shared Services Mid-Tex Direct Pension Post-Retirement Pension Supplemental Post-Retirement Line Account Plan Medical Plan Account Plan Executive Benefit Medical Plan Adjustment No. Description ("PAP") ("FAS 106") ("PAP") Plan("SERP") ("FAS 106") Total (a) (b) (c) (d) (e) (f) (g) Fiscal Year 2014 Towers Watson Report(excluding Removed Cost 1 Centers) $ 6,388,826 $ 4,542,023 $ 9,481,670 $ 165,758 $ 8,736,645 2 Allocation to Mid-Tex 46.26% 46.26% 71.70% 100.00% 71.70% FY14 Towers Watson Benefit Costs(excluding Removed Cost 3 Centers) Allocated to MTX(Ln 1 x Ln 2) $ 2,955,304 $ 2,101,021 $ 6,798,531 $ 165,758 $ 6,264,334 4 O&M and Capital Allocation Factor 100.00% 100.00% 100.00% 100.00% 100.00% FY14 Towers Watson Benefit Costs To Approve(excluding 5 Removed Cost Centers)(Ln 3 x Ln 4) $ 2,955,304 $ 2,101,021 $ 6,798,531 $ 165,758 $ 6,264,334 $ 18,284,949 6 7 8 Summary of Costs to Approve: 9 10 Total Pension Account Plan("PAP") $ 2,955,304 $ 6,798,531 $ 9,753,835 11 Total Post-Retirement Medical Plan("FAS 106") $ 2,101,021 $ 6,264,334 8,365,356 12 Total Supplemental Executive Retirement Plan("SERP") $ 165,758 165,758 13 Total(Ln 10+Ln 11 +Ln 12) $ 2,955,304 $ 2,101,021 $ 6,798,531 $ 165,758 $ 6,264,334 $ 18,284,949 14 15 16 O&M Expense Factor 95.82% 95.82% 43.03% 21.00% 43.03% 17 18 Expense Portion(Ln 13 x Ln 16) $ 2,831,859 $ 2,013,260 $ 2,925,600 $ 34,809 $ 2,695,721 $ 10,501,250 19 20 Capital Factor 4.18% 4.18% 56.97% 79.00% 56.97% 21 22 Capital Portion(Ln 13 x Ln 20) $ 123,445 $ 87,761 $ 3,872,930 $ 130,949 $ 3,568,614 $ 7,783,699 23 24 Total(Ln 18+Ln 22) $ 2,955,304 $ 2,101,021 $ 6,798,531 $ 165,758 $ 6,264,334 $ 18,284,949 WP_F-2.3.1 Page 1 of 1 W 1 ',I''o t it �',M7titi : Wylie City Council o�' � AGENDA REPORT Meeting Date: May 26, 2015 Item Number: 2 Department: Engineering (City Secretary's Use Only) Prepared By: Engineering Account Code: N/A Date Prepared: May 18, 2015 Budgeted Amount: N/A Exhibits: Ordinance Subject Consider and act upon, Ordinance No. 2015-20 repealing Ordinance Nos. 78-17 and 87-62, designating truck routes to regulate the activities of commercial motor vehicles in the City of Wylie. Recommendation Motion to approve Ordinance No. 2015-20 repealing Ordinance Nos. 78-17 and 87-62, designating truck routes to regulate the activities of commercial motor vehicles in the City of Wylie. Discussion The ordinance regulating truck routes within the Wylie city limits was last updated in 1982. The Texas Department of Transportation released ownership of Ballard Avenue from Brown Street to SH 78 to the city. This portion of roadway was previously designated a truck route, however, due to increased pedestrian and vehicular traffic in the downtown area, staff recommends that this section of roadway be removed. A commercial motor vehicle is defined in Section 3 of the ordinance and references the Texas Transportation Code. Among other requirements, a commercial vehicle is defined as a vehicle that has a gross weight rating of 26,000 pounds. The designate truck routes are shown below: Street Segment Extent FM 2514 (Parker Road) Entire city limits FM 1378 (Country Club Road) Entire city limits West Brown Street From FM 1378 (Country Club) to SH 78 FM 544 From McCreary Road to SH 78 SH 78 Entire city limits Sanden Boulevard From FM 544 to SH 78 Ballard Avenue From SH 78 south to Pleasant Valley Road Stone Road From Ballard Avenue to FM 544 FM 544 From Stone Road south to the city limits Alanis Drive From SH 78 to FM 544 Pleasant Valley Road Entire city limits (Rev 01/2014) Page 1 of 1 ORDINANCE NO. 2015-20 AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF WYLIE, TEXAS, REPEALING ORDINANCE NOS. 78-17 AND 87-62; DESIGNATING TRUCK ROUTES TO REGULATE THE ACTIVITIES OF COMMERCIAL MOTOR VEHICLES IN THE CITY OF WYLIE; PROVIDING FOR DEFINITIONS, UNLAWFUL ACTS AND EXCEPTIONS THERETO; PROVIDING FOR NOTICE OF THE TRUCK ROUTES BY THE INSTALLATION OF SIGNS AND MARKERS; PROVIDING A PENALTY CLAUSE, SAVINGS/REPEALING CLAUSE, SEVERABILITY CLAUSE AND AN EFFECTIVE DATE; AND PROVIDING FOR THE PUBLICATION OF THE CAPTION HEREOF. WHEREAS, the City Council of the City of Wylie, Texas ("City Council") has adopted Ordinance Nos. 78-17 and 87-62 to designate certain roads, streets and highways within the city limits of the City of Wylie, Texas ("City") as truck routes for commercial motor vehicle traffic traveling within the City; and WHEREAS, the City Council desires to strengthen its regulations on commercial motor vehicle traffic and provide for additional enforcement; and WHEREAS, the City Council has investigated and determined that it would be advantageous and beneficial to the City and its citizens to repeal Ordinance Nos. 78-17 and 87- 62, currently codified at Sections 110-151 to 110-153 of the City's Code of Ordinances, in their entirety; and WHEREAS, the City Council finds that it would be advantageous and beneficial to the City and its citizens to adopt a new truck route ordinance, providing for the prohibition of travel of commercial motor vehicles over certain roads, streets and highways in the City to promote the health, safety and welfare of the general public and to preserve and protect the functionality and integrity of the City's roads, streets and highways. NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF WYLIE, TEXAS: SECTION 1: Findings Incorporated. The findings set forth above are incorporated into the body of this Ordinance as if fully set forth herein SECTION 2: Ordinance Nos. 78-17 and 87-62 Repealed. Ordinance Nos. 78-17 and 87-62 are hereby repealed in their entirety and replaced by this Ordinance. The effective date of such repeal shall not occur until the effective date of this Ordinance, at which time Ordinance Nos. 78-17 and 87-62 shall be repealed. Such repeal shall not abate any pending prosecution or lawsuit or prevent any prosecution or lawsuit from being commenced for any violation of Ordinance Nos. 78-17 and 87-62 occurring before the effective date of this Ordinance. Ordinance No.2015-20 Designating Truck Routes and Repealing Ordinance Nos.78-17 and 87-62 Page 1 of 5 669736 SECTION 3: Definitions. For purposes of this Ordinance, the following definitions apply, except where the context clearly indicates a different definition: Commercial motor vehicle means a self-propelled or towed vehicle, other than a farm vehicle with a gross weight, registered weight or gross weight rating of less than 48,000 pounds, that is used on a public road, street or highway to transport passengers or cargo if: (1) the vehicle, including a school activity bus as defined in Section 541.201 of the Texas Transportation Code, or combination of vehicles has a gross weight, registered weight or gross weight rating of more than 26,000 pounds; (2) the vehicle, including a school activity bus as defined in Section 541.201 of the Texas Transportation Code, is designed or used to transport more than 15 passengers, including the driver; (3) the vehicle is used to transport hazardous materials in a quantity requiring placarding by a regulation issued under the Hazardous Materials Transportation Act (49 U.S.C. Section 5101 et seq.); or (4) the vehicle is a commercial motor vehicle as defined by 49 C.F.R. Section 390.5 or similar regulation if operated interstate. Farm vehicle has the meaning assigned by the federal motor carrier safety regulations. Truck route means those roads, streets or highways which are designated in this Ordinance for the use of truck traffic. Truck traffic means the operation of any commercial motor vehicle. SECTION 4: Compliance. It shall be unlawful to operate a commercial motor vehicle on any road, street or highway in the City except on those designated as truck routes in Section 5 and except as provided in Section 8. SECTION 5: Designated Truck Routes. For the purposes of this Ordinance, the following roads, streets or highways in the City are designated as truck routes: Street Segment Extent FM 2514 (Parker Road) Entire city limits FM 1378 (Country Club Road) Entire city limits West Brown Street From FM 1378 (Country Club) to SH 78 FM 544 From McCreary Road to SH 78 SH 78 Entire city limits Sanden Boulevard From FM 544 to SH 78 Ballard Avenue From SH 78 south to Pleasant Valley Road Ordinance No.2015-20 Designating Truck Routes and Repealing Ordinance Nos.78-17 and 87-62 Page 2 of 5 669736 Stone Road From Ballard Avenue to FM 544 FM 544 From Stone Road south to the city limits Alanis Drive From SH 78 to FM 544 Pleasant Valley Road Entire city limits SECTION 6: Proceeding Directly to Routes. If any truck traffic originating within the City shall have, as its point of origin, a point located off a designated truck route, it shall proceed to the nearest point on a designated truck route by the most direct route possible. If such traffic shall originate outside the City and enter the City at a point which is not on a designated truck route, it shall proceed to the nearest point on a designated truck route by the most direct route possible. SECTION 7: Departing from Routes. (1) Truck traffic restricted to the streets, roads and highways designated as truck routes may depart from such truck routes where it is necessary for the immediate loading or unloading of property at locations situated off designated truck routes. However, such truck traffic shall not leave any designated truck route until it has reached a point on a designated truck route which is nearest the applicable place of loading or unloading by the most direct route possible. After leaving a designated truck route to load or unload, truck traffic may continue off truck routes to as many points of destination as necessary. However, if in the course of making necessary stops for loading and unloading the truck traffic shall cross a designated truck route, the truck traffic shall not again leave any designated truck route until it has reached a point on some designated truck route which is nearest to the next place of loading and unloading by the most direct route possible. (2) It shall not be necessary to proceed to the nearest designated truck route when, under Section 6, truck traffic originates off a designated truck route, whether inside or outside the City, and the destination of the truck traffic is nearer the origin or point of entering the City, as the case may be, than is the nearest point on a designated truck route by the most direct route possible. (3) Traveling to a place of business in a commercially zoned area shall be a defense to traveling on a road, street or highway that is not a designated truck route in violation of this Ordinance. SECTION 8: Exceptions. The provisions of this Ordinance shall not apply to: (1) emergency vehicles operating in response to any emergency call; (2) commercial motor vehicles traveling to or from a location that is not a designated truck route for a legitimate business purpose, including but not limited to, repair or maintenance service or loading or unloading cargo that requires traveling off of the designated truck routes, provided that such vehicle is operated on the most Ordinance No.2015-20 Designating Truck Routes and Repealing Ordinance Nos.78-17 and 87-62 Page 3 of 5 669736 direct route possible and the operator of such vehicle has in his or her immediate possession evidence of the local destination and point of origin; (3) an operator of a commercial motor vehicle driving to and from his or her residence; (4) commercial motor vehicles owned or operated by or on behalf of a governmental entity, a public utility or any contractor or materialman engaged in the repair, maintenance or construction of roads, streets or highways, road, street or highway improvements or utilities within the City; (5) commercial motor vehicles owned or operated by or on behalf of a governmental entity engaged in or performing official, authorized government business; and (6) commercial motor vehicles operating on a City- or state-designated detour. SECTION 9: Posting of Signs and Markings. The City Manager or his or her designee shall erect or place appropriate signs and markings indicating the truck routes designated in this Ordinance. The signs shall be permanently affixed to a stationery post or installed on permanent buildings or walls or as otherwise approved. The signs and markings shall in no way be obstructed from view and shall comply with applicable state laws. SECTION 10: Penalty. Any person, firm, corporation or entity violating any provision of this Ordinance, as it exists or may be amended, shall be deemed guilty of a misdemeanor, and upon conviction thereof, shall be fined a sum of not less than One Dollar ($1.00) nor more than Five Hundred Dollars ($500.00). Each continuing day's violation shall constitute a separate offense. The penal provisions imposed under this Ordinance shall not preclude the City from filing suit to enjoin the violation. The City retains all legal rights and remedies available to it pursuant to local, state and federal law. SECTION 11: Severability. Should any section, subsection, sentence, clause or phrase of this Ordinance be declared unconstitutional or invalid by a court of competent jurisdiction, it is expressly provided that any and all remaining portions of this Ordinance shall remain in full force and effect. The City hereby declares that it would have passed this Ordinance, and each section, subsection, clause or phrase thereof, regardless of whether any one or more sections, subsections, sentences, clauses or phrases is declared unconstitutional and/or invalid. SECTION 12: Savings/Repealing. All provisions of any ordinance in conflict with this Ordinance are hereby repealed to the extent they are in conflict, but such repeal shall not abate any pending prosecution for violation of the repealed ordinance, nor shall the repeal prevent a prosecution from being commenced for any violation if occurring prior to the repeal of the ordinance. Any remaining portions of such ordinances shall remain in full force and effect. SECTION 13: Effective Date. This Ordinance shall become effective from and after its adoption and publication as required by law and the City Charter. Ordinance No.2015-20 Designating Truck Routes and Repealing Ordinance Nos.78-17 and 87-62 Page 4 of 5 669736 DULY PASSED AND APPROVED BY THE CITY COUNCIL OF THE CITY OF WYLIE, TEXAS, on this 26t1 day of May, 2015. Eric Hogue, Mayor ATTESTED TO AND CORRECTLY RECORDED BY: Carole Ehrlich, City Secretary Dates of Publication:June 3rd,2015, Wylie News Ordinance No.2015-20 Designating Truck Routes and Repealing Ordinance Nos.78-17 and 87-62 Page 5 of 5 669736